enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by hispanic descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
736792 736792 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2015   grade_7 0 53 99 0   0     0   3   89 66                       155 0 53 99 0   0     0   3   89 66                 155
737517 737517 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_6 5 13 99 0   5     0   0   65 57                       122 5 13 99 0   5     0   0   65 57                 122
738972 738972 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2015   grade_6 0 1 99 0   0     0   0   55 45                       100 0 1 99 0   0     0   0   55 45                 100
741384 741384 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No 3 09 12 2015   grade_11 118 8 99 0   7     0   13   117 128                       245 118 8 99 0   7     0   13   117 128                 245
935820 935820 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2016   grade_6 5 1 99 0   0     0   0   52 53                       105 5 1 99 0   0     0   0   52 53                 105
935844 935844 MA Essex   school 2506660 149   Lawrence 250666002618 1490533 Math, Science & Technology High School   Regular School No 3 09 12 2016   grade_12 5 1 99 1   8     0   0   62 52                       114 5 1 99 1   8     0   0   62 52                 114
938762 938762 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No 4 06 10 2016   grade_6 29 40 99 0   5     0   2   106 69                       175 29 40 99 0   5     0   2   106 69                 175
940185 940185 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No 3 09 12 2016   grade_12 89 49 99 0   11     0   3   136 115                       251 89 49 99 0   11     0   3   136 115                 251
940648 940648 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 09 2016   grade_8 2 139 99 0   2     0   3   117 128                       245 2 139 99 0   2     0   3   117 128                 245
1125448 1125448 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_6 106 1 99 0   4     1   2   98 115                       213 106 1 99 0   4     1   2   98 115                 213
1125826 1125826 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_4 3 0 99 0   0     0   2   56 48                       104 3 0 99 0   0     0   2   56 48                 104
1133020 1133020 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2017   grade_12 334 53 99 2   3     0   17   229 279                       508 334 53 99 2   3     0   17   229 279                 508
2231013 2231013 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee: Chicopee High   Regular School No High 09 12 2018   grade_10 120 4 99 0   2     0   1   118 108                       226.0 120 4 99 0   2     0   1   118 108                 226
2232637 2232637 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_4 2 0 99 0   0     0   0   51 50                       101.0 2 0 99 0   0     0   0   51 50                 101
2232693 2232693 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 Lawrence: High School Learning Center   Regular School No High 09 12 2018   grade_12 5 0 99 0   1     0   0   64 41                       105.0 5 0 99 0   1     0   0   64 41                 105
2040934 2040934 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_6 23 17 99 0   9     0   1   79 70                       149.0 23 17 99 0   9     0   1   79 70                 149
2041746 2041746 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2019   grade_11 109 5 99 0   7     0   2   117 105                       222.0 109 5 99 0   7     0   2   117 105                 222
2043128 2043128 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_7 0 1 99 0   1     0   0   59 42                       101.0 0 1 99 0   1     0   0   59 42                 101
2046115 2046115 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_8 11 16 99 0   1     0   3   66 64                       130.0 11 16 99 0   1     0   3   66 64                 130
2047196 2047196 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 311 107 99 4   9     0   21   261 290                       551.0 311 107 99 4   9     0   21   261 290                 551
1365911 1365911 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2020   grade_12 12 67 99 1   19     0   4   121 81 *                     202.0 12 67 99 1   19     0   4   121 81                 202
1368142 1368142 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2020   grade_6 147 40 99 1   12     0   12   157 154 *                     311.0 147 40 99 1   12     0   12   157 154                 311
1368966 1368966 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2020   grade_7 55 5 99 0   7     0   7   98 75 *                     173.0 55 5 99 0   7     0   7   98 75                 173
1369025 1369025 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2020   grade_10 190 11 99 1   6     0   11   176 142 *                     318.0 190 11 99 1   6     0   11   176 142                 318
1371007 1371007 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_8 18 25 99 0   0     0   2   84 60 *                     144.0 18 25 99 0   0     0   2   84 60                 144
1673821 1673821 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_5 9 6 99 0   0     0   2   57 59 *                     116.0 9 6 99 0   0     0   2   57 59                 116
1673830 1673830 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_6 10 8 99 0   0     0   6   66 57 *                     123.0 10 8 99 0   0     0   6   66 57                 123
1675208 1675208 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 Lawrence - John Breen School   Regular School No Elementary PK KG 2021   kindergarten 8 4 99 0   2     0   1   53 61 *                     114.0 8 4 99 0   2     0   1   53 61                 114
1675831 1675831 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn - Pickering Middle   Regular School No Middle 06 08 2021   grade_7 76 10 99 3   19     0   9   112 104 *                     216.0 76 10 99 3   19     0   9   112 104                 216
1677560 1677560 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Revere - Susan B. Anthony Middle School   Regular School No Middle 06 08 2021   grade_6 58 7 99 0   6     0   2   74 98 *                     172.0 58 7 99 0   6     0   2   74 98                 172
1679819 1679819 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District) - KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2021   grade_9 4 23 99 0   3     0   1   65 65 *                     130.0 4 23 99 0   3     0   1   65 65                 130
736890 736890 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_9 30 112 98 0   72     0   11   154 169                       323 30 112 98 0   72     0   11   154 169                 323
737498 737498 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_3 7 5 98 1   0     0   0   62 49                       111 7 5 98 1   0     0   0   62 49                 111
737509 737509 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_6 9 11 98 0   2     0   1   72 49                       121 9 11 98 0   2     0   1   72 49                 121
737586 737586 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2015   grade_8 151 6 98 1   7     0   6   124 145                       269 151 6 98 1   7     0   6   124 145                 269
934456 934456 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2016   grade_10 243 11 98 0   7     0   3   195 167                       362 243 11 98 0   7     0   3   195 167                 362
935023 935023 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_5 62 12 98 0   12     0   16   104 96                       200 62 12 98 0   12     0   16   104 96                 200
935024 935024 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_6 43 7 98 0   8     0   14   85 85                       170 43 7 98 0   8     0   14   85 85                 170
938081 938081 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No 2 06 08 2016   grade_6 56 5 98 0   9     0   5   89 84                       173 56 5 98 0   9     0   5   89 84                 173
938803 938803 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No 2 06 08 2016   grade_8 19 20 98 1   4     0   1   56 87                       143 19 20 98 1   4     0   1   56 87                 143
940188 940188 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No 3 09 12 2016   grade_11 145 52 98 0   24     0   10   181 148                       329 145 52 98 0   24     0   10   181 148                 329
1124189 1124189 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2017   grade_6 129 6 98 0   2     0   9   130 114                       244 129 6 98 0   2     0   9   130 114                 244
1124882 1124882 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_7 42 6 98 0   7     0   10   91 72                       163 42 6 98 0   7     0   10   91 72                 163
1125449 1125449 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_7 96 8 98 0   3     0   1   99 107                       206 96 8 98 0   3     0   1   99 107                 206
1125870 1125870 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_7 16 3 98 0   3     0   1   63 58                       121 16 3 98 0   3     0   1   63 58                 121
1128534 1128534 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2017   grade_7 66 5 98 0   13     0   2   89 95                       184 66 5 98 0   13     0   2   89 95                 184
1129061 1129061 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge Middle School   Regular School No Middle 06 08 2017   grade_7 57 1 98 1   0     0   4   83 78                       161 57 1 98 1   0     0   4   83 78                 161
2230078 2230078 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Boston: Brighton High   Regular School No High 09 12 2018   grade_12 6 87 98 1   11     0   2   122 83                       205.0 6 87 98 1   11     0   2   122 83                 205
2231009 2231009 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee: Dupont Middle   Regular School No Middle 06 08 2018   grade_7 123 16 98 1   3     0   9   145 105                       250.0 123 16 98 1   3     0   9   145 105                 250
2232618 2232618 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence: Gerard A. Guilmette   Regular School No Elementary 01 04 2018   grade_1 4 3 98 0   0     0   1   57 49                       106.0 4 3 98 0   0     0   1   57 49                 106
2232677 2232677 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence: UP Academy Leonard Middle School   Regular School No Middle 06 08 2018   grade_7 1 0 98 0   1     0   0   54 46                       100.0 1 0 98 0   1     0   0   54 46                 100
2236169 2236169 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 Springfield: John F Kennedy Middle   Regular School No Middle 06 08 2018   grade_6 21 34 98 0   1     0   2   92 64                       156.0 21 34 98 0   1     0   2   92 64                 156
2236518 2236518 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_8 476 81 98 1   14     0   23   342 351                       693.0 476 81 98 1   14     0   23   342 351                 693
2239869 2239869 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metropolitan Regional Vocational Technical: Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2018   grade_11 179 11 98 0   8     0   5   152 149                       301.0 179 11 98 0   8     0   5   152 149                 301
2041006 2041006 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_10 98 72 98 1   84     1   8   156 206                       362.0 98 72 98 1   84     1   8   156 206                 362
2047931 2047931 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_6 3 133 98 1   3     0   1   121 118                       239.0 3 133 98 1   3     0   1   121 118                 239
1366571 1366571 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   grade_1 4 1 98 0   0     0   0   46 57 *                     103.0 4 1 98 0   0     0   0   46 57                 103
1366598 1366598 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_5 12 7 98 0   0     0   4   64 57 *                     121.0 12 7 98 0   0     0   4   64 57                 121
1368012 1368012 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_5 1 0 98 0   0     0   0   55 44 *                     99.0 1 0 98 0   0     0   0   55 44                 99
1368153 1368153 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2020   grade_9 116 24 98 0   8     0   12   171 87 *                     258.0 116 24 98 0   8     0   12   171 87                 258
1372548 1372548 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_1 8 14 98 0   1     2   1   53 71 *                     124.0 8 14 98 0   1     2   1   53 71                 124
1372860 1372860 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_7 0 134 98 0   1     0   1   119 115 *                     234.0 0 134 98 0   1     0   1   119 115                 234
1374117 1374117 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2020   grade_9 86 15 98 4   4     0   7   125 89 *                     214.0 86 15 98 4   4     0   7   125 89                 214
736796 736796 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2015   grade_11 11 113 97 0   6     0   6   128 105                       233 11 113 97 0   6     0   6   128 105                 233
737511 737511 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_8 18 13 97 0   3     0   1   58 74                       132 18 13 97 0   3     0   1   58 74                 132
738197 738197 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2015   grade_12 94 22 97 0   25     0   8   124 122                       246 94 22 97 0   25     0   8   124 122                 246
738940 738940 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_4 1 1 97 0   0     0   0   47 52                       99 1 1 97 0   0     0   0   47 52                 99
738949 738949 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2015   grade_8 2 0 97 1   0     0   1   54 47                       101 2 0 97 1   0     0   1   54 47                 101
739609 739609 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_12 148 95 97 2   114     2   16   246 228                       474 148 95 97 2   114     2   16   246 228                 474
740270 740270 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_7 212 29 97 1   1     2   16   183 175                       358 212 29 97 1   1     2   16   183 175                 358
741942 741942 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2015   pre_kindergarten 6 32 97 0   2     0   2   61 78                       139 6 32 97 0   2     0   2   61 78                 139
745096 745096 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Vocational Education School No 3 09 12 2015   grade_12 194 8 97 0   2     0   5   173 133                       306 194 8 97 0   2     0   5   173 133                 306
934445 934445 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_7 160 8 97 1   9     0   8   144 139                       283 160 8 97 1   9     0   8   144 139                 283
935033 935033 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_5 49 10 97 0   10     0   11   95 82                       177 49 10 97 0   10     0   11   95 82                 177
935792 935792 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_3 2 0 97 0   0     0   1   57 43                       100 2 0 97 0   0     0   1   57 43                 100
1124094 1124094 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_1 10 5 97 0   0     0   2   58 56                       114 10 5 97 0   0     0   2   58 56                 114
1125791 1125791 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2017   grade_1 10 1 97 0   2     0   1   58 53                       111 10 1 97 0   2     0   1   58 53                 111
1126594 1126594 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2017   grade_10 135 90 97 3   109     0   13   216 231                       447 135 90 97 3   109     0   13   216 231                 447
1129338 1129338 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No Other 06 11 2017   grade_6 20 59 97 0   6     0   3   117 68                       185 20 59 97 0   6     0   3   117 68                 185
1131185 1131185 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2017   grade_12 14 115 97 3   7     1   10   103 144                       247 14 115 97 3   7     1   10   103 144                 247
2231709 2231709 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg: Memorial Intermediate   Regular School No Middle 05 08 2018   grade_6 58 8 97 0   14     0   10   90 97                       187.0 58 8 97 0   14     0   10   90 97                 187
2231814 2231814 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   kindergarten 18 3 97 0   1     0   3   50 72                       122.0 18 3 97 0   1     0   3   50 72                 122
2232609 2232609 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence: Robert Frost   Regular School No Elementary KG 04 2018   grade_2 11 3 97 0   2     0   1   59 55                       114.0 11 3 97 0   2     0   1   59 55                 114
2233829 2233829 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford: Stacy Middle   Regular School No Middle 06 08 2018   grade_7 223 10 97 4   12     0   9   178 177                       355.0 223 10 97 4   12     0   9   178 177                 355
2235872 2235872 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Southbridge: Eastford Road   Regular School No Elementary PK 01 2018   grade_1 61 2 97 0   1     0   0   79 82                       161.0 61 2 97 0   1     0   0   79 82                 161
2236158 2236158 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 Springfield: John J Duggan Middle   Regular School No High 06 12 2018   grade_7 21 60 97 1   6     0   3   118 70                       188.0 21 60 97 1   6     0   3   118 70                 188
2040954 2040954 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2019   grade_11 12 68 97 1   21     0   4   125 78                       203.0 12 68 97 1   21     0   4   125 78                 203
2041659 2041659 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_5 5 9 97 0   3     0   3   68 49                       117.0 5 9 97 0   3     0   3   68 49                 117
2042100 2042100 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 44 36 97 0   13     0   4   114 80                       194.0 44 36 97 0   13     0   4   114 80                 194
2043230 2043230 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No High 09 12 2019   grade_10 151 29 97 0   9     0   9   137 158                       295.0 151 29 97 0   9     0   9   137 158                 295
2044403 2044403 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2019   grade_8 119 40 97 1   2     1   14   131 143                       274.0 119 40 97 1   2     1   14   131 143                 274
2045817 2045817 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2019   grade_1 62 4 97 0   0     0   2   77 88                       165.0 62 4 97 0   0     0   2   77 88                 165
2046102 2046102 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_8 3 16 97 0   0     0   0   51 65                       116.0 3 16 97 0   0     0   0   51 65                 116
2047930 2047930 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_5 4 120 97 1   0     1   0   115 108                       223.0 4 120 97 1   0     1   0   115 108                 223
1365410 1365410 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_7 6 1 97 0   1     0   0   55 50 *                     105.0 6 1 97 0   1     0   0   55 50                 105
1365890 1365890 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2020   grade_6 8 21 97 0   11     1   2   72 68 *                     140.0 8 21 97 0   11     1   2   72 68                 140
1367350 1367350 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_1 15 4 97 0   0     0   6   51 71 *                     122.0 15 4 97 0   0     0   6   51 71                 122
1368018 1368018 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_6 0 0 97 0   0     0   0   46 50 *                     97.0 0 0 97 0   0     0   0   46 50                 97
1372556 1372556 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_9 7 20 97 0   4     0   2   74 56 *                     130.0 7 20 97 0   4     0   2   74 56                 130
1675389 1675389 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster - Sky View Middle School   Regular School No Middle 06 08 2021   grade_7 136 34 97 1   14     0   12   151 143 *                     294.0 136 34 97 1   14     0   12   151 143                 294

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