enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_8", state = "MA" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 499 ✖

grade ✖

  • grade_8 · 499 ✖
Link rowid ▼ state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1672017 1672017 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_8 136 5 18 1   3     0   6   82 87 *                     169.0 136 5 18 1   3     0   6   82 87                 169
1672032 1672032 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_8 99 0 4 0   1     0   5   59 50 *                     109.0 99 0 4 0   1     0   5   59 50                 109
1672057 1672057 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam - Agawam Junior High   Regular School No Middle 07 08 2021   grade_8 229 13 20 0   4     0   9   138 137 *                     275.0 229 13 20 0   4     0   9   138 137                 275
1672077 1672077 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_8 121 5 11 0   3     1   6   70 77 *                     147.0 121 5 11 0   3     1   6   70 77                 147
1672141 1672141 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover - Doherty Middle   Regular School No Middle 06 08 2021   grade_8 133 2 12 1   17     1   4   83 87 *                     170.0 133 2 12 1   17     1   4   83 87                 170
1672144 1672144 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_8 119 6 14 0   29     0   7   97 78 *                     175.0 119 6 14 0   29     0   7   97 78                 175
1672147 1672147 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover - Wood Hill Middle School   Regular School No Middle 06 08 2021   grade_8 62 3 12 1   50     0   3   73 58 *                     131.0 62 3 12 1   50     0   3   73 58                 131
1672198 1672198 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington - Ottoson Middle   Regular School No Middle 07 08 2021   grade_8 309 15 35 1   46     1   29   239 196 *                     436.0 309 15 35 1   46     1   29   239 196                 436
1672212 1672212 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_8 142 7 33 0   28     0   8   110 108 *                     218.0 142 7 33 0   28     0   8   110 108                 218
1672246 1672246 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_8 128 12 23 0   6     0   11   99 81 *                     180.0 128 12 23 0   6     0   11   99 81                 180
1672250 1672250 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_8 100 9 41 0   9     0   5   94 70 *                     164.0 100 9 41 0   9     0   5   94 70                 164
1672254 1672254 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro - Wamsutta Middle School   Regular School No Middle 05 08 2021   grade_8 85 11 21 0   11     0   7   64 71 *                     135.0 85 11 21 0   11     0   7   64 71                 135
1672274 1672274 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_8 152 5 26 0   10     0   9   104 98 *                     202.0 152 5 26 0   10     0   9   104 98                 202
1672290 1672290 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_8 28 19 6 0   3     0   5   27 34 *                     61.0 28 19 6 0   3     0   5   27 34                 61
1672320 1672320 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_8 265 31 62 0   11     2   18   192 197 *                     389.0 265 31 62 0   11     2   18   192 197                 389
1672335 1672335 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford - John Glenn Middle   Regular School No Middle 06 08 2021   grade_8 141 10 12 1   41     0   1   120 86 *                     206.0 141 10 12 1   41     0   1   120 86                 206
1672349 1672349 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Belchertown - Jabish Middle School   Regular School No Middle 07 08 2021   grade_8 165 7 7 0   3     1   4   101 85 *                     187.0 165 7 7 0   3     1   4   101 85                 187
1672367 1672367 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham - Bellingham High School   Regular School No High 08 12 2021   grade_8 144 0 9 0   10     0   0   81 82 *                     163.0 144 0 9 0   10     0   0   81 82                 163
1672400 1672400 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_8 212 14 16 0   76     0   25   175 168 *                     343.0 212 14 16 0   76     0   25   175 168                 343
1672414 1672414 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_8 88 1 5 0   0     0   2   48 48 *                     96.0 88 1 5 0   0     0   2   48 48                 96
1672444 1672444 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly - Beverly Middle School   Regular School No Middle 05 08 2021   grade_8 265 10 56 0   12     0   7   178 172 *                     350.0 265 10 56 0   12     0   7   178 172                 350
1672482 1672482 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica - Billerica Memorial High School   Regular School No High 08 12 2021   grade_8 303 26 29 1   30     1   13   205 198 *                     403.0 303 26 29 1   30     1   13   205 198                 403
1672504 1672504 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_8 3 4 8 0   1     0   1   13 4 *                     17.0 3 4 8 0   1     0   1   13 4                 17
1672528 1672528 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_8 3 14 12 1   0     0   0   15 15 *                     30.0 3 14 12 1   0     0   0   15 15                 30
1672538 1672538 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston - Jackson Mann   Regular School No Elementary PK 08 2021   grade_8 1 17 17 0   2     0   0   21 16 *                     37.0 1 17 17 0   2     0   0   21 16                 37
1672563 1672563 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston - Curley K-8 School   Regular School No Elementary PK 08 2021   grade_8 2 20 57 0   1     0   3   38 45 *                     83.0 2 20 57 0   1     0   3   38 45                 83
1672611 1672611 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston - Dearborn   Regular School No High 06 12 2021   grade_8 2 52 29 0   2     2   2   45 44 *                     89.0 2 52 29 0   2     2   2   45 44                 89
1672625 1672625 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_8 1 17 23 0   0     1   3   22 23 *                     45.0 1 17 23 0   0     1   3   22 23                 45
1672635 1672635 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_8 5 1 91 0   1     0   0   52 46 *                     98.0 5 1 91 0   1     0   0   52 46                 98
1672653 1672653 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_8 16 8 19 1   5     0   1   25 25 *                     50.0 16 8 19 1   5     0   1   25 25                 50
1672670 1672670 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston - Franklin D Roosevelt   Regular School No Elementary PK 08 2021   grade_8 2 20 21 0   1     0   2   27 19 *                     46.0 2 20 21 0   1     0   2   27 19                 46
1672710 1672710 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston - Condon K-8   Regular School No Elementary PK 08 2021   grade_8 18 27 29 0   3     0   1   42 36 *                     78.0 18 27 29 0   3     0   1   42 36                 78
1672719 1672719 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston - James W Hennigan   Regular School No Elementary KG 08 2021   grade_8 4 14 55 0   0     0   0   32 41 *                     73.0 4 14 55 0   0     0   0   32 41                 73
1672758 1672758 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston - John W McCormack   Regular School No Middle 06 08 2021   grade_8 5 35 60 0   3     0   2   42 63 *                     105.0 5 35 60 0   3     0   2   42 63                 105
1672783 1672783 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_8 0 1 19 0   0     0   0   13 7 *                     20.0 0 1 19 0   0     0   0   13 7                 20
1672793 1672793 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston - Joseph Lee   Regular School No Elementary PK 08 2021   grade_8 2 29 19 0   4     0   6   31 29 *                     60.0 2 29 19 0   4     0   6   31 29                 60
1672811 1672811 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston - Joyce Kilmer   Regular School No Elementary PK 08 2021   grade_8 9 5 10 0   2     0   2   14 14 *                     28.0 9 5 10 0   2     0   2   14 14                 28
1672844 1672844 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_8 3 8 26 0   1     0   0   12 26 *                     38.0 3 8 26 0   1     0   0   12 26                 38
1672869 1672869 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_8 2 26 29 0   28     0   2   52 35 *                     87.0 2 26 29 0   28     0   2   52 35                 87
1672886 1672886 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_8 7 3 2 0   1     0   1   6 8 *                     14.0 7 3 2 0   1     0   1   6 8                 14
1672896 1672896 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_8 1 42 46 0   0     1   0   44 46 *                     90.0 1 42 46 0   0     1   0   44 46                 90
1672902 1672902 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston - William H Ohrenberger   Regular School No Middle 03 08 2021   grade_8 4 23 39 0   0     0   4   42 28 *                     70.0 4 23 39 0   0     0   4   42 28                 70
1672912 1672912 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_8 4 6 16 0   0     0   1   13 14 *                     27.0 4 6 16 0   0     0   1   13 14                 27
1672977 1672977 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_8 2 6 19 0   0     0   0   16 11 *                     27.0 2 6 19 0   0     0   0   16 11                 27
1672987 1672987 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston - Gardner Pilot Academy   Regular School No Elementary PK 08 2021   grade_8 6 8 22 0   2     0   1   21 18 *                     39.0 6 8 22 0   2     0   1   21 18                 39
1673005 1673005 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_8 12 5 11 0   1     0   4   13 20 *                     33.0 12 5 11 0   1     0   4   13 20                 33
1673019 1673019 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_8 3 12 10 0   1     0   1   22 5 *                     27.0 3 12 10 0   1     0   1   22 5                 27
1673041 1673041 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_8 1 12 5 0   0     0   1   11 8 *                     19.0 1 12 5 0   0     0   1   11 8                 19
1673058 1673058 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston - Edison K-8   Regular School No Elementary PK 08 2021   grade_8 3 13 33 0   4     0   3   32 24 *                     56.0 3 13 33 0   4     0   3   32 24                 56
1673068 1673068 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_8 2 21 17 0   0     0   1   20 21 *                     41.0 2 21 17 0   0     0   1   20 21                 41
1673074 1673074 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_8 2 21 21 0   0     0   2   32 14 *                     46.0 2 21 21 0   0     0   2   32 14                 46
1673084 1673084 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_8 2 50 38 0   1     0   0   56 35 *                     91.0 2 50 38 0   1     0   0   56 35                 91
1673094 1673094 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_8 1 19 24 0   0     0   0   22 22 *                     44.0 1 19 24 0   0     0   0   22 22                 44
1673104 1673104 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_8 3 2 12 0   0     0   1   10 8 *                     18.0 3 2 12 0   0     0   1   10 8                 18
1673107 1673107 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston - Lilla G. Frederick Middle School   Regular School No Middle 06 08 2021   grade_8 2 62 66 0   9     0   4   78 65 *                     143.0 2 62 66 0   9     0   4   78 65                 143
1673121 1673121 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_8 13 25 20 1   2     0   0   30 31 *                     61.0 13 25 20 1   2     0   0   30 31                 61
1673128 1673128 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston - Clarence R Edwards Middle   Regular School No Middle 06 08 2021   grade_8 13 17 84 0   2     0   1   60 57 *                     117.0 13 17 84 0   2     0   1   60 57                 117
1673131 1673131 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston - Washington Irving Middle   Regular School No Middle 06 08 2021   grade_8 5 28 44 0   0     0   0   37 40 *                     77.0 5 28 44 0   0     0   0   37 40                 77
1673134 1673134 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston - James P Timilty Middle   Regular School No Middle 06 08 2021   grade_8 1 36 54 0   2     0   0   46 47 *                     93.0 1 36 54 0   2     0   0   46 47                 93
1673188 1673188 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston - New Mission High School   Alternative School No High 07 12 2021   grade_8 2 25 22 0   0     0   1   22 28 *                     50.0 2 25 22 0   0     0   1   22 28                 50
1673197 1673197 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston - Boston Latin Academy   Regular School No High 07 12 2021   grade_8 94 56 73 1   43     0   14   119 162 *                     281.0 94 56 73 1   43     0   14   119 162                 281
1673218 1673218 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_8 186 30 52 1   126     0   22   189 227 *                     417.0 186 30 52 1   126     0   22   189 227                 417
1673225 1673225 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   grade_8 2 14 21 0   38     0   1   39 37 *                     76.0 2 14 21 0   38     0   1   39 37                 76
1673232 1673232 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston - O'Bryant School Math/Science   Regular School No High 07 12 2021   grade_8 26 49 58 0   32     1   3   91 78 *                     169.0 26 49 58 0   32     1   3   91 78                 169
1673256 1673256 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   grade_8 7 1 137 0   1     0   1   74 73 *                     147.0 7 1 137 0   1     0   1   74 73                 147
1673259 1673259 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_8 6 73 36 0   2     0   4   61 60 *                     121.0 6 73 36 0   2     0   4   61 60                 121
1673277 1673277 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_8 2 0 23 0   0     0   0   12 13 *                     25.0 2 0 23 0   0     0   0   12 13                 25
1673284 1673284 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_8 0 3 6 0   0     0   0   7 2 *                     9.0 0 3 6 0   0     0   0   7 2                 9
1673302 1673302 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_8 132 3 10 3   2     0   7   88 69 *                     157.0 132 3 10 3   2     0   7   88 69                 157
1673351 1673351 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree - East Middle School   Regular School No Middle 05 08 2021   grade_8 135 28 15 0   64     0   1   124 119 *                     243.0 135 28 15 0   64     0   1   124 119                 243
1673354 1673354 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree - South Middle School   Regular School No Middle 06 08 2021   grade_8 168 9 10 0   54     0   1   115 127 *                     242.0 168 9 10 0   54     0   1   115 127                 242
1673416 1673416 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_8 16 79 19 1   2     0   7   58 66 *                     124.0 16 79 19 1   2     0   7   58 66                 124
1673453 1673453 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_8 1 3 4 0   0     0   0   7 1 *                     8.0 1 3 4 0   0     0   0   7 1                 8
1673460 1673460 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_8 24 188 31 2   3     0   10   128 130 *                     258.0 24 188 31 2   3     0   10   128 130                 258
1673464 1673464 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton - South Middle School   Regular School No Middle 06 08 2021   grade_8 26 142 30 0   0     0   6   113 91 *                     204.0 26 142 30 0   0     0   6   113 91                 204
1673467 1673467 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton - West Middle School   Regular School No Middle 06 08 2021   grade_8 52 160 23 2   8     0   6   137 114 *                     251.0 52 160 23 2   8     0   6   137 114                 251
1673470 1673470 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton - Ashfield Middle School   Regular School No Middle 06 08 2021   grade_8 62 116 24 2   8     2   4   99 119 *                     218.0 62 116 24 2   8     2   4   99 119                 218
1673473 1673473 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton - Joseph F. Plouffe Academy   Regular School No Middle 06 08 2021   grade_8 51 119 71 1   8     0   13   140 123 *                     263.0 51 119 71 1   8     0   13   140 123                 263
1673507 1673507 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline - Edith C Baker   Regular School No Elementary KG 08 2021   grade_8 50 3 11 0   16     0   6   47 39 *                     86.0 50 3 11 0   16     0   6   47 39                 86
1673517 1673517 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline - Florida Ruffin Ridley School   Regular School No Elementary PK 08 2021   grade_8 49 5 16 0   8     0   7   47 38 *                     85.0 49 5 16 0   8     0   7   47 38                 85
1673526 1673526 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline - Michael Driscoll   Regular School No Elementary KG 08 2021   grade_8 33 2 10 0   6     0   6   23 34 *                     57.0 33 2 10 0   6     0   6   23 34                 57
1673536 1673536 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline - Heath   Regular School No Elementary PK 08 2021   grade_8 35 2 6 0   9     0   5   20 37 *                     57.0 35 2 6 0   9     0   5   20 37                 57
1673545 1673545 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline - Lawrence   Regular School No Elementary KG 08 2021   grade_8 31 4 3 0   18     0   5   36 25 *                     61.0 31 4 3 0   18     0   5   36 25                 61
1673554 1673554 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline - William H Lincoln   Regular School No Elementary KG 08 2021   grade_8 44 9 8 0   8     0   4   27 46 *                     73.0 44 9 8 0   8     0   4   27 46                 73
1673563 1673563 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline - Pierce   Regular School No Elementary KG 08 2021   grade_8 44 3 6 0   11     0   5   34 35 *                     69.0 44 3 6 0   11     0   5   34 35                 69
1673573 1673573 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   grade_8 44 4 4 0   7     0   8   33 34 *                     67.0 44 4 4 0   7     0   8   33 34                 67
1673606 1673606 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington - Marshall Simonds Middle   Regular School No Middle 06 08 2021   grade_8 158 17 14 0   53     0   14   121 135 *                     256.0 158 17 14 0   53     0   14   121 135                 256
1673628 1673628 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge - Amigos School   Regular School No Elementary PK 08 2021   grade_8 15 0 21 0   0     0   5   19 22 *                     41.0 15 0 21 0   0     0   5   19 22                 41
1673701 1673701 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge - Cambridge Street Upper School   Regular School No Middle 06 08 2021   grade_8 37 20 15 1   9     0   11   52 41 *                     93.0 37 20 15 1   9     0   11   52 41                 93
1673704 1673704 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge - Putnam Avenue Upper School   Regular School No Middle 06 08 2021   grade_8 28 34 12 0   12     1   8   38 56 *                     95.0 28 34 12 0   12     1   8   38 56                 95
1673707 1673707 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Cambridge - Rindge Avenue Upper School   Regular School No Middle 06 08 2021   grade_8 33 35 7 0   6     0   10   47 44 *                     91.0 33 35 7 0   6     0   10   47 44                 91
1673710 1673710 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge - Vassal Lane Upper School   Regular School No Middle 06 08 2021   grade_8 43 27 4 0   17     0   6   50 46 *                     97.0 43 27 4 0   17     0   6   50 46                 97
1673737 1673737 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton - Wm H Galvin Middle   Regular School No Middle 06 08 2021   grade_8 161 34 7 0   28     0   13   108 135 *                     243.0 161 34 7 0   28     0   13   108 135                 243
1673752 1673752 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_8 49 0 2 0   6     0   8   38 27 *                     65.0 49 0 2 0   6     0   8   38 27                 65
1673762 1673762 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_8 118 0 5 1   0     1   0   71 54 *                     125.0 118 0 5 1   0     1   0   71 54                 125
1673791 1673791 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Chelmsford - Col Moses Parker School   Regular School No Middle 05 08 2021   grade_8 127 4 15 2   29     0   5   110 72 *                     182.0 127 4 15 2   29     0   5   110 72                 182
1673795 1673795 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_8 127 7 11 0   22     0   10   104 73 *                     177.0 127 7 11 0   22     0   10   104 73                 177
1673824 1673824 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_8 8 7 110 0   0     0   2   55 72 *                     127.0 8 7 110 0   0     0   2   55 72                 127
1673828 1673828 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea - Clark Avenue School   Regular School No Middle 05 08 2021   grade_8 10 4 141 1   2     0   2   91 69 *                     160.0 10 4 141 1   2     0   2   91 69                 160
1673832 1673832 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_8 4 1 132 0   0     0   0   71 66 *                     137.0 4 1 132 0   0     0   0   71 66                 137

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);