enrollments

Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,218 ✖
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
737124 737124 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_5 9 99 14 0   3     1   6   65 67                       132 9 99 14 0   3     1   6   65 67                 132
1131205 1131205 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_5 11 97 71 0   3     0   2   87 97                       184 11 97 71 0   3     0   2   87 97                 184
933991 933991 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 05 2016   grade_5 9 95 16 1   5     0   5   70 61                       131 9 95 16 1   5     0   5   70 61                 131
1372539 1372539 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_5 13 95 64 1   4     0   4   83 98 *                     181.0 13 95 64 1   4     0   4   83 98                 181
1673434 1673434 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_5 42 94 31 1   11     0   10   98 91 *                     189.0 42 94 31 1   11     0   10   98 91                 189
1679941 1679941 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_5 31 90 5 0   11     0   12   71 78 *                     149.0 31 90 5 0   11     0   12   71 78                 149
736056 736056 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_5 240 9 14 0   54     0   22   165 174                       339 240 9 14 0   54     0   22   165 174                 339
736415 736415 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2015   grade_5 6 9 5 0   1     0   2   13 10                       23 6 9 5 0   1     0   2   13 10                 23
736513 736513 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   grade_5 5 9 6 0   2     0   1   16 7                       23 5 9 6 0   2     0   1   16 7                 23
737308 737308 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No 1 PK 05 2015   grade_5 16 9 2 0   9     0   6   27 15                       42 16 9 2 0   9     0   6   27 15                 42
737346 737346 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   grade_5 19 9 9 1   3     0   2   29 14                       43 19 9 9 1   3     0   2   29 14                 43
737508 737508 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_5 8 9 118 1   4     0   3   80 63                       143 8 9 118 1   4     0   3   80 63                 143
739331 739331 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2015   grade_5 51 9 33 0   34     0   13   72 68                       140 51 9 33 0   34     0   13   72 68                 140
739616 739616 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Jordan/Jackson Elementary   Regular School No 1 03 05 2015   grade_5 264 9 12 0   15     0   11   152 159                       311 264 9 12 0   15     0   11   152 159                 311
740195 740195 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No 1 KG 05 2015   grade_5 18 9 24 0   0     0   1   27 25                       52 18 9 24 0   0     0   1   27 25                 52
740496 740496 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No 1 PK 05 2015   grade_5 48 9 10 0   7     0   0   40 34                       74 48 9 10 0   7     0   0   40 34                 74
741828 741828 MA Hampden   school 2511130 281   Springfield 251113001803 2810075 Frank H Freedman   Regular School No 1 KG 05 2015   grade_5 7 9 21 0   1     0   2   22 18                       40 7 9 21 0   1     0   2   22 18                 40
741883 741883 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No 1 PK 05 2015   grade_5 11 9 18 0   4     0   0   19 23                       42 11 9 18 0   4     0   0   19 23                 42
743206 743206 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2015   grade_5 31 9 32 0   21     0   6   65 34                       99 31 9 32 0   21     0   6   65 34                 99
743259 743259 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2015   grade_5 9 9 8 0   3     0   1   19 11                       30 9 9 8 0   3     0   1   19 11                 30
743289 743289 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2015   grade_5 32 9 30 0   9     0   5   44 41                       85 32 9 30 0   9     0   5   44 41                 85
933382 933382 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2016   grade_5 1 9 8 0   1     0   0   8 11                       19 1 9 8 0   1     0   0   8 11                 19
933389 933389 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   grade_5 4 9 5 0   4     0   0   12 10                       22 4 9 5 0   4     0   0   12 10                 22
933413 933413 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_5 15 9 6 0   1     0   0   16 15                       31 15 9 6 0   1     0   0   16 15                 31
933503 933503 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_5 0 9 27 0   1     0   0   17 20                       37 0 9 27 0   1     0   0   17 20                 37
933892 933892 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No 1 KG 05 2016   grade_5 48 9 0 0   8     0   2   35 32                       67 48 9 0 0   8     0   2   35 32                 67
933898 933898 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 KG 05 2016   grade_5 39 9 6 1   4     0   0   28 31                       59 39 9 6 1   4     0   0   28 31                 59
934052 934052 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_5 34 9 5 0   22     0   7   40 37                       77 34 9 5 0   22     0   7   40 37                 77
934185 934185 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2016   grade_5 20 9 5 0   3     0   2   16 23                       39 20 9 5 0   3     0   2   16 23                 39
934206 934206 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2016   grade_5 15 9 5 0   3     0   1   15 18                       33 15 9 5 0   3     0   1   15 18                 33
934890 934890 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2016   grade_5 86 9 26 0   4     0   7   74 58                       132 86 9 26 0   4     0   7   74 58                 132
934909 934909 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2016   grade_5 39 9 40 0   4     0   1   55 38                       93 39 9 40 0   4     0   1   55 38                 93
936796 936796 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 08 2016   grade_5 234 9 87 4   8     0   11   174 179                       353 234 9 87 4   8     0   11   174 179                 353
936936 936936 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2016   grade_5 181 9 15 0   13     0   20   122 116                       238 181 9 15 0   13     0   20   122 116                 238
937052 937052 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2016   grade_5 55 9 22 1   1     0   12   50 50                       100 55 9 22 1   1     0   12   50 50                 100
937059 937059 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No 1 PK 05 2016   grade_5 18 9 21 1   0     0   1   29 21                       50 18 9 21 1   0     0   1   29 21                 50
937542 937542 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2016   grade_5 36 9 4 0   0     0   1   28 22                       50 36 9 4 0   0     0   1   28 22                 50
937729 937729 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No 1 KG 05 2016   grade_5 64 9 12 0   2     0   8   49 46                       95 64 9 12 0   2     0   8   49 46                 95
937949 937949 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No 2 05 08 2016   grade_5 45 9 9 0   19     0   2   45 39                       84 45 9 9 0   19     0   2   45 39                 84
938126 938126 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No 2 05 08 2016   grade_5 139 9 11 0   2     0   5   93 73                       166 139 9 11 0   2     0   5   93 73                 166
938600 938600 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No 1 KG 05 2016   grade_5 6 9 39 0   0     0   0   29 25                       54 6 9 39 0   0     0   0   29 25                 54
938606 938606 MA Hampden   school 2511130 281   Springfield 251113001807 2810050 Hiram L Dorman   Regular School No 1 KG 05 2016   grade_5 6 9 28 0   1     0   0   21 23                       44 6 9 28 0   1     0   0   21 23                 44
938654 938654 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   grade_5 11 9 14 0   0     0   1   15 20                       35 11 9 14 0   0     0   1   15 20                 35
938670 938670 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Kensington International School   Regular School No 1 KG 05 2016   grade_5 4 9 38 0   5     0   0   25 31                       56 4 9 38 0   5     0   0   25 31                 56
938701 938701 MA Hampden   school 2511130 281   Springfield 251113001819 2810145 Mary O Pottenger   Regular School No 1 KG 05 2016   grade_5 13 9 44 0   3     0   0   35 34                       69 13 9 44 0   3     0   0   35 34                 69
938726 938726 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No 1 KG 05 2016   grade_5 9 9 22 0   2     0   1   22 21                       43 9 9 22 0   2     0   1   22 21                 43
939161 939161 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2016   grade_5 211 9 20 0   7     0   6   141 112                       253 211 9 20 0   7     0   6   141 112                 253
940068 940068 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2016   grade_5 9 9 18 0   1     0   4   22 19                       41 9 9 18 0   1     0   4   22 19                 41
940082 940082 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2016   grade_5 40 9 10 0   2     0   2   31 32                       63 40 9 10 0   2     0   2   31 32                 63
1122729 1122729 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_5 21 9 10 0   3     0   1   21 23                       44 21 9 10 0   3     0   1   21 23                 44
1122740 1122740 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   grade_5 4 9 9 0   0     0   1   11 12                       23 4 9 9 0   0     0   1   11 12                 23
1123042 1123042 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No Elementary PK 05 2017   grade_5 2 9 44 0   2     0   1   27 31                       58 2 9 44 0   2     0   1   27 31                 58
1123896 1123896 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2017   grade_5 7 9 6 0   8     0   1   12 19                       31 7 9 6 0   8     0   1   12 19                 31
1123904 1123904 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   grade_5 21 9 7 0   0     0   7   23 21                       44 21 9 7 0   0     0   7   23 21                 44
1124065 1124065 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2017   grade_5 162 9 11 0   32     2   2   118 100                       218 162 9 11 0   32     2   2   118 100                 218
1125385 1125385 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 05 2017   grade_5 136 9 19 0   2     0   2   89 79                       168 136 9 19 0   2     0   2   89 79                 168
1125447 1125447 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_5 66 9 84 0   2     0   1   84 78                       162 66 9 84 0   2     0   1   84 78                 162
1126422 1126422 MA Essex   school 2507110 163   Lynn 250711001074 1630055 Hood   Regular School No Elementary KG 05 2017   grade_5 14 9 48 0   7     0   2   45 35                       80 14 9 48 0   7     0   2   45 35                 80
1126675 1126675 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_5 162 9 156 0   19     0   18   168 196                       364 162 9 156 0   19     0   18   168 196                 364
1127342 1127342 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No Elementary PK 05 2017   grade_5 8 9 13 0   0     1   0   14 17                       31 8 9 13 0   0     1   0   14 17                 31
1128135 1128135 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No Elementary PK 05 2017   grade_5 38 9 7 0   3     0   5   33 29                       62 38 9 7 0   3     0   5   33 29                 62
1128372 1128372 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No Middle 05 08 2017   grade_5 37 9 9 1   25     1   4   43 43                       86 37 9 9 1   25     1   4   43 43                 86
1130031 1130031 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No Elementary KG 05 2017   grade_5 67 9 1 0   14     0   4   45 50                       95 67 9 1 0   14     0   4   45 50                 95
1130326 1130326 MA Middlesex   school 2512750 330   Weston 251275000785 3300012 Field Elementary School   Regular School No Elementary 04 05 2017   grade_5 113 9 8 0   16     0   11   85 72                       157 113 9 8 0   16     0   11   85 72                 157
1130756 1130756 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_5 8 9 72 0   10     0   1   52 48                       100 8 9 72 0   10     0   1   52 48                 100
1130996 1130996 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2017   grade_5 9 9 57 0   7     0   3   45 40                       85 9 9 57 0   7     0   3   45 40                 85
1132366 1132366 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   grade_5 117 9 15 1   1     1   5   74 75                       149 117 9 15 1   1     1   5   74 75                 149
1133128 1133128 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   grade_5 12 9 30 0   9     0   5   38 27                       65 12 9 30 0   9     0   5   38 27                 65
1365020 1365020 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_5 101 9 15 0   9     0   7   82 59 *                     141.0 101 9 15 0   9     0   7   82 59                 141
1365028 1365028 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_5 85 9 19 0   1     0   15   65 64 *                     129.0 85 9 19 0   1     0   15   65 64                 129
1365435 1365435 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2020   grade_5 10 9 10 0   0     0   5   12 22 *                     34.0 10 9 10 0   0     0   5   12 22                 34
1365643 1365643 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2020   grade_5 1 9 6 0   4     0   0   9 11 *                     20.0 1 9 6 0   4     0   0   9 11                 20
1365775 1365775 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2020   grade_5 2 9 10 0   1     1   0   7 16 *                     23.0 2 9 10 0   1     1   0   7 16                 23
1366431 1366431 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2020   grade_5 8 9 6 0   5     0   3   13 18 *                     31.0 8 9 6 0   5     0   3   13 18                 31
1366438 1366438 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2020   grade_5 10 9 3 1   7     0   5   22 13 *                     35.0 10 9 3 1   7     0   5   22 13                 35
1366557 1366557 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2020   grade_5 134 9 14 1   27     0   10   105 90 *                     195.0 134 9 14 1   27     0   10   105 90                 195
1367050 1367050 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_5 20 9 43 0   4     0   0   37 39 *                     76.0 20 9 43 0   4     0   0   37 39                 76
1367126 1367126 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2020   grade_5 50 9 45 0   8     0   10   66 56 *                     122.0 50 9 45 0   8     0   10   66 56                 122
1367157 1367157 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   grade_5 26 9 9 0   1     0   12   29 28 *                     57.0 26 9 9 0   1     0   12   29 28                 57
1368527 1368527 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_5 3 9 62 0   7     0   2   44 39 *                     83.0 3 9 62 0   7     0   2   44 39                 83
1368705 1368705 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_5 183 9 16 0   5     0   9   125 97 *                     222.0 183 9 16 0   5     0   9   125 97                 222
1368923 1368923 MA Middlesex   school 2507620 178   Melrose 250762001196 1780035 Roosevelt   Regular School No Elementary KG 05 2020   grade_5 47 9 4 0   3     0   4   40 27 *                     67.0 47 9 4 0   3     0   4   40 27                 67
1369158 1369158 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2020   grade_5 156 9 12 1   24     1   11   111 103 *                     214.0 156 9 12 1   24     1   11   111 103                 214
1369229 1369229 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No Elementary KG 05 2020   grade_5 17 9 20 0   1     1   7   27 28 *                     55.0 17 9 20 0   1     1   7   27 28                 55
1369860 1369860 MA Essex   school 2509360 229   Peabody 250936001503 2290010 Thomas Carroll   Regular School No Elementary KG 05 2020   grade_5 72 9 12 0   1     0   1   44 51 *                     95.0 72 9 12 0   1     0   1   44 51                 95
1369977 1369977 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No Elementary PK 05 2020   grade_5 32 9 16 0   0     0   4   30 31 *                     61.0 32 9 16 0   0     0   4   30 31                 61
1370653 1370653 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2020   grade_5 5 9 21 0   2     0   3   20 20 *                     40.0 5 9 21 0   2     0   3   20 20                 40
1370818 1370818 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No Elementary PK 05 2020   grade_5 1 9 31 0   0     0   1   26 16 *                     42.0 1 9 31 0   0     0   1   26 16                 42
1370971 1370971 MA Hampden   school 2511130 281   Springfield 251113001836 2810185 Washington   Regular School No Elementary PK 05 2020   grade_5 5 9 38 0   1     0   0   28 25 *                     53.0 5 9 38 0   1     0   0   28 25                 53
1371114 1371114 MA Norfolk   school 2511250 285   Stoughton 251125001858 2850010 Helen Hansen Elementary   Regular School No Elementary KG 05 2020   grade_5 19 9 10 0   0     0   3   22 19 *                     41.0 19 9 10 0   0     0   3   22 19                 41
1371223 1371223 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2020   grade_5 110 9 23 0   6     0   6   78 76 *                     154.0 110 9 23 0   6     0   6   78 76                 154
1371751 1371751 MA Hampden   school 2512630 325   Westfield 251263002894 3250075 Westfield Intermediate School   Regular School No Middle 05 06 2020   grade_5 253 9 59 1   12     0   12   180 166 *                     346.0 253 9 59 1   12     0   12   180 166                 346
1372228 1372228 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2020   grade_5 14 9 22 0   6     0   4   28 27 *                     55.0 14 9 22 0   6     0   4   28 27                 55
1372242 1372242 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2020   grade_5 17 9 5 0   5     0   2   17 21 *                     38.0 17 9 5 0   5     0   2   17 21                 38
1373183 1373183 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_5 144 9 0 1   5     0   7   77 89 *                     166.0 144 9 0 1   5     0   7   77 89                 166
1374251 1374251 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2020   grade_5 11 9 31 0   3     0   1   24 31 *                     55.0 11 9 31 0   3     0   1   24 31                 55
1374298 1374298 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_5 33 9 14 0   3     0   9   37 31 *                     68.0 33 9 14 0   3     0   9   37 31                 68
1672106 1672106 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_5 31 9 12 0   5     0   3   30 30 *                     60.0 31 9 12 0   5     0   3   30 30                 60
1672755 1672755 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston - John D Philbrick   Regular School No Elementary PK 05 2021   grade_5 3 9 6 0   0     0   0   12 6 *                     18.0 3 9 6 0   0     0   0   12 6                 18
1673012 1673012 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_5 2 9 8 0   0     0   1   12 8 *                     20.0 2 9 8 0   0     0   1   12 8                 20

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]);