enrollments

Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by hispanic_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,537 ✖
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
1368046 1368046 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_9 20 5 879 0   12     0   3   483 429 7                     919.0 20 5 879 0   12     0   3   483 429 7               919
1368047 1368047 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_10 28 16 833 0   8     0   1   489 394 3                     886.0 28 16 833 0   8     0   1   489 394 3               886
1368049 1368049 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_12 21 9 717 0   11     0   2   401 349 10                     760.0 21 9 717 0   11     0   2   401 349 10               760
1368048 1368048 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_11 23 5 674 0   20     0   1   372 349 2                     723.0 23 5 674 0   20     0   1   372 349 2               723
1366569 1366569 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   kindergarten 30 20 442 1   0     0   2   261 234 *                     495.0 30 20 442 1   0     0   2   261 234                 495
1371044 1371044 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2020   grade_9 51 119 434 1   23     0   13   349 292 *                     641.0 51 119 434 1   23     0   13   349 292                 641
1366602 1366602 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2020   grade_9 22 14 428 1   1     0   6   267 205 *                     472.0 22 14 428 1   1     0   6   267 205                 472
1368597 1368597 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2020   grade_10 56 52 413 5   40     0   10   301 275 *                     576.0 56 52 413 5   40     0   10   301 275                 576
1368596 1368596 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2020   grade_9 41 51 380 2   43     0   15   287 244 *                     532.0 41 51 380 2   43     0   15   287 244                 532
1374104 1374104 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 59 5 363 1   4     0   0   222 210 *                     432.0 59 5 363 1   4     0   0   222 210                 432
1368586 1368586 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_6 36 48 359 1   54     0   19   260 257 *                     517.0 36 48 359 1   54     0   19   260 257                 517
1368583 1368583 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_6 43 57 350 1   27     0   19   255 242 *                     497.0 43 57 350 1   27     0   19   255 242                 497
1368587 1368587 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_7 62 51 348 1   43     0   13   255 263 *                     518.0 62 51 348 1   43     0   13   255 263                 518
1368584 1368584 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_7 39 38 341 0   36     0   6   240 220 *                     460.0 39 38 341 0   36     0   6   240 220                 460
1374105 1374105 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 56 5 340 0   5     0   0   215 191 *                     406.0 56 5 340 0   5     0   0   215 191                 406
1369337 1369337 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_9 269 89 331 3   4     0   37   377 355 *                     733.0 269 89 331 3   4     0   37   377 355                 733
1366603 1366603 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2020   grade_10 13 17 329 1   0     0   5   211 154 *                     365.0 13 17 329 1   0     0   5   211 154                 365
1370315 1370315 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2020   grade_9 167 22 328 1   27     1   7   279 273 *                     553.0 167 22 328 1   27     1   7   279 273                 553
1370317 1370317 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2020   grade_11 162 16 322 9   30     0   10   285 264 *                     549.0 162 16 322 9   30     0   10   285 264                 549
1368592 1368592 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2020   grade_9 64 35 319 2   47     0   14   251 230 *                     481.0 64 35 319 2   47     0   14   251 230                 481
1367862 1367862 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2020   grade_10 53 10 318 0   1     1   5   200 187 *                     388.0 53 10 318 0   1     1   5   200 187                 388
1368593 1368593 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2020   grade_10 102 35 318 4   47     0   19   272 253 *                     525.0 102 35 318 4   47     0   19   272 253                 525
1374106 1374106 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 56 3 318 1   9     0   1   198 190 *                     388.0 56 3 318 1   9     0   1   198 190                 388
1368598 1368598 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2020   grade_11 66 49 308 1   40     0   11   260 215 *                     475.0 66 49 308 1   40     0   11   260 215                 475
1367864 1367864 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2020   grade_12 63 6 306 0   5     0   6   179 206 *                     386.0 63 6 306 0   5     0   6   179 206                 386
1374107 1374107 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 53 3 304 1   4     0   0   169 196 *                     365.0 53 3 304 1   4     0   0   169 196                 365
1371045 1371045 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2020   grade_10 61 135 302 0   20     0   5   292 231 *                     523.0 61 135 302 0   20     0   5   292 231                 523
1370316 1370316 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2020   grade_10 148 20 299 2   26     0   13   265 242 *                     508.0 148 20 299 2   26     0   13   265 242                 508
1367089 1367089 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_10 103 99 298 3   24     0   7   274 260 *                     534.0 103 99 298 3   24     0   7   274 260                 534
1371052 1371052 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2020   grade_9 25 72 298 0   7     1   7   223 187 *                     410.0 25 72 298 0   7     1   7   223 187                 410
1367861 1367861 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2020   grade_9 58 11 297 0   0     0   4   195 175 *                     370.0 58 11 297 0   0     0   4   195 175                 370
1369338 1369338 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_10 214 107 288 4   7     1   31   350 302 *                     652.0 214 107 288 4   7     1   31   350 302                 652
1367863 1367863 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2020   grade_11 75 7 286 1   2     0   2   205 168 *                     373.0 75 7 286 1   2     0   2   205 168                 373
1367088 1367088 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_9 90 86 281 4   24     0   8   251 242 *                     493.0 90 86 281 4   24     0   8   251 242                 493
1371048 1371048 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2020   grade_9 32 78 281 2   7     1   4   211 194 *                     405.0 32 78 281 2   7     1   4   211 194                 405
1368585 1368585 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_8 28 40 274 0   21     0   10   187 186 *                     373.0 28 40 274 0   21     0   10   187 186                 373
1368410 1368410 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_9 150 79 272 0   210     0   29   388 352 *                     740.0 150 79 272 0   210     0   29   388 352                 740
1371076 1371076 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2020   grade_9 26 59 264 0   9     0   2   167 193 *                     360.0 26 59 264 0   9     0   2   167 193                 360
1371047 1371047 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2020   grade_12 65 120 261 1   26     1   5   236 243 *                     479.0 65 120 261 1   26     1   5   236 243                 479
1366604 1366604 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2020   grade_11 13 15 260 0   1     0   5   175 119 *                     294.0 13 15 260 0   1     0   5   175 119                 294
1367091 1367091 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_12 124 117 253 2   24     2   5   273 254 *                     527.0 124 117 253 2   24     2   5   273 254                 527
1371077 1371077 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2020   grade_10 31 78 253 0   6     0   3   165 206 *                     371.0 31 78 253 0   6     0   3   165 206                 371
1368594 1368594 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2020   grade_11 73 32 244 2   28     0   6   207 178 *                     385.0 73 32 244 2   28     0   6   207 178                 385
1365926 1365926 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2020   grade_10 27 13 242 0   9     0   5   167 129 *                     296.0 27 13 242 0   9     0   5   167 129                 296
1366570 1366570 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   pre_kindergarten 27 18 239 0   0     0   6   151 139 *                     290.0 27 18 239 0   0     0   6   151 139                 290
1371078 1371078 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2020   grade_11 27 64 237 0   3     0   3   158 176 *                     334.0 27 64 237 0   3     0   3   158 176                 334
1367388 1367388 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2020   grade_9 356 36 236 1   27     1   27   353 331 *                     684.0 356 36 236 1   27     1   27   353 331                 684
1369339 1369339 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_11 153 106 233 4   6     2   28   263 269 *                     532.0 153 106 233 4   6     2   28   263 269                 532
1368599 1368599 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2020   grade_12 57 34 232 0   50     0   10   184 199 *                     383.0 57 34 232 0   50     0   10   184 199                 383
1366241 1366241 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_9 169 865 231 3   29     3   52   766 586 *                     1352.0 169 865 231 3   29     3   52   766 586                 1352
1368588 1368588 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_8 29 21 231 0   29     0   10   172 148 *                     320.0 29 21 231 0   29     0   10   172 148                 320
1374112 1374112 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 240 30 229 0   108     0   0   329 275 3                     607.0 240 30 229 0   108     0   0   329 275 3               607
1366605 1366605 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2020   grade_12 15 15 228 0   2     1   7   128 140 *                     268.0 15 15 228 0   2     1   7   128 140                 268
1365925 1365925 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2020   grade_9 21 12 227 1   2     0   0   170 93 *                     263.0 21 12 227 1   2     0   0   170 93                 263
1365927 1365927 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2020   grade_11 30 12 225 0   6     0   6   173 106 *                     279.0 30 12 225 0   6     0   6   173 106                 279
1367090 1367090 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_11 96 90 221 0   24     0   11   233 209 *                     442.0 96 90 221 0   24     0   11   233 209                 442
1371079 1371079 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2020   grade_12 38 62 221 0   5     0   1   143 184 *                     327.0 38 62 221 0   5     0   1   143 184                 327
1374113 1374113 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 208 29 221 2   96     0   28   287 294 3                     584.0 208 29 221 2   96     0   28   287 294 3               584
1371046 1371046 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2020   grade_11 59 108 219 0   27     0   5   224 194 *                     418.0 59 108 219 0   27     0   5   224 194                 418
1368979 1368979 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2020   grade_10 254 15 218 0   22     1   20   273 257 *                     530.0 254 15 218 0   22     1   20   273 257                 530
1368978 1368978 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2020   grade_9 209 6 216 0   24     0   26   251 230 *                     481.0 209 6 216 0   24     0   26   251 230                 481
1368743 1368743 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_5 158 13 215 0   8     0   19   198 215 *                     413.0 158 13 215 0   8     0   19   198 215                 413
1368744 1368744 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_6 120 12 215 1   14     0   9   204 167 *                     371.0 120 12 215 1   14     0   9   204 167                 371
1369340 1369340 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_12 153 85 214 5   7     1   19   248 236 *                     484.0 153 85 214 5   7     1   19   248 236                 484
1371049 1371049 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2020   grade_10 20 60 214 0   3     1   4   144 158 *                     302.0 20 60 214 0   3     1   4   144 158                 302
1370318 1370318 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2020   grade_12 139 14 208 2   28     0   10   198 202 *                     401.0 139 14 208 2   28     0   10   198 202                 401
1368595 1368595 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2020   grade_12 87 45 206 0   46     0   8   208 184 *                     392.0 87 45 206 0   46     0   8   208 184                 392
1371506 1371506 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No High 09 12 2020   grade_9 168 39 205 0   14     0   8   236 197 *                     434.0 168 39 205 0   14     0   8   236 197                 434
1367711 1367711 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No High 09 12 2020   grade_9 259 22 204 0   11     2   8   268 238 *                     506.0 259 22 204 0   11     2   8   268 238                 506
1368611 1368611 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_9 48 13 202 1   12     0   11   167 120 *                     287.0 48 13 202 1   12     0   11   167 120                 287
1371054 1371054 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2020   grade_11 21 53 200 0   5     1   0   145 135 *                     280.0 21 53 200 0   5     1   0   145 135                 280
1372392 1372392 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2020   grade_8 108 67 200 0   41     0   16   210 222 *                     432.0 108 67 200 0   41     0   16   210 222                 432
1368745 1368745 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_7 157 13 198 0   7     0   9   197 187 *                     384.0 157 13 198 0   7     0   9   197 187                 384
1371053 1371053 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2020   grade_10 28 44 196 1   4     0   2   154 121 *                     275.0 28 44 196 1   4     0   2   154 121                 275
1365935 1365935 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2020   grade_9 14 130 194 0   4     2   7   209 142 *                     351.0 14 130 194 0   4     2   7   209 142                 351
1368610 1368610 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_8 37 29 194 0   15     0   12   159 128 *                     287.0 37 29 194 0   15     0   12   159 128                 287
1371507 1371507 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No High 09 12 2020   grade_10 161 35 194 0   12     0   5   219 188 *                     407.0 161 35 194 0   12     0   5   219 188                 407
1368612 1368612 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_10 37 18 193 3   18     0   7   152 123 *                     276.0 37 18 193 3   18     0   7   152 123                 276
1368980 1368980 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2020   grade_11 250 6 193 1   24     0   20   259 235 *                     494.0 250 6 193 1   24     0   20   259 235                 494
1372403 1372403 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2020   grade_9 65 73 193 0   10     0   11   181 171 *                     352.0 65 73 193 0   10     0   11   181 171                 352
1372408 1372408 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No High 09 12 2020   grade_9 79 64 193 1   34     0   15   218 168 *                     386.0 79 64 193 1   34     0   15   218 168                 386
1367281 1367281 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2020   grade_9 105 26 191 0   16     0   21   192 167 *                     359.0 105 26 191 0   16     0   21   192 167                 359
1365928 1365928 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2020   grade_12 24 12 189 1   4     0   4   119 115 *                     234.0 24 12 189 1   4     0   4   119 115                 234
1372404 1372404 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2020   grade_10 60 58 189 0   20     0   9   187 149 *                     336.0 60 58 189 0   20     0   9   187 149                 336
1372388 1372388 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2020   grade_7 70 62 187 0   19     1   14   175 178 *                     353.0 70 62 187 0   19     1   14   175 178                 353
1368412 1368412 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_11 204 86 186 0   244     0   23   355 388 *                     743.0 204 86 186 0   244     0   23   355 388                 743
1368614 1368614 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_12 28 12 186 0   10     0   7   137 106 *                     243.0 28 12 186 0   10     0   7   137 106                 243
1372389 1372389 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2020   grade_8 59 80 183 1   36     0   16   181 194 *                     375.0 59 80 183 1   36     0   16   181 194                 375
1368411 1368411 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_10 221 97 182 0   229     0   25   366 388 *                     754.0 221 97 182 0   229     0   25   366 388                 754
1371509 1371509 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No High 09 12 2020   grade_12 155 39 182 2   18     0   8   230 174 *                     404.0 155 39 182 2   18     0   8   230 174                 404
1374114 1374114 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 251 21 180 1   85     0   19   301 256 0                     557.0 251 21 180 1   85     0   19   301 256 0               557
1368746 1368746 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_8 108 6 179 0   4     0   13   149 161 *                     310.0 108 6 179 0   4     0   13   149 161                 310
1371055 1371055 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2020   grade_12 29 48 179 0   4     0   5   159 106 *                     265.0 29 48 179 0   4     0   5   159 106                 265
1368413 1368413 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_12 215 99 177 0   232     1   17   367 374 *                     741.0 215 99 177 0   232     1   17   367 374                 741
1372387 1372387 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2020   grade_8 186 64 177 1   30     0   19   258 219 *                     477.0 186 64 177 1   30     0   19   258 219                 477
1368747 1368747 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2020   grade_9 86 10 172 0   5     0   5   153 125 *                     278.0 86 10 172 0   5     0   5   153 125                 278
1366595 1366595 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_6 11 6 171 1   1     1   2   99 94 *                     193.0 11 6 171 1   1     1   2   99 94                 193
1365908 1365908 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2020   grade_9 12 48 168 0   10     0   4   146 96 *                     242.0 12 48 168 0   10     0   4   146 96                 242
1367389 1367389 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2020   grade_10 297 46 168 1   35     1   19   275 292 *                     567.0 297 46 168 1   35     1   19   275 292                 567
1367962 1367962 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawlor Early Childhood Center   Regular School No Elementary KG KG 2020   kindergarten 3 1 168 0   0     0   0   88 84 *                     172.0 3 1 168 0   0     0   0   88 84                 172

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