enrollments

Data source: Big Local News · About: Big Local

9,499 rows where state = "MA" and year = 2016 sorted by hispanic_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 9,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
935823 935823 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No 4 09 09 2016   grade_9 25 12 700 1   12     0   3   391 362                       753 25 12 700 1   12     0   3   391 362                 753
934350 934350 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No 1 PK KG 2016   kindergarten 41 25 448 0   4     0   10   298 230                       528 41 25 448 0   4     0   10   298 230                 528
934380 934380 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2016   grade_9 27 28 429 0   6     0   2   282 210                       492 27 28 429 0   6     0   2   282 210                 492
934381 934381 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2016   grade_10 24 28 383 0   10     0   2   228 219                       447 24 28 383 0   10     0   2   228 219                 447
933688 933688 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   grade_9 56 28 369 2   4     0   6   272 193                       465 56 28 369 2   4     0   6   272 193                 465
939908 939908 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No 1 PK PK 2016   pre_kindergarten 105 108 332 3   19     1   3   294 277                       571 105 108 332 3   19     1   3   294 277                 571
938816 938816 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2016   grade_9 58 65 328 0   9     0   7   281 186                       467 58 65 328 0   9     0   7   281 186                 467
938807 938807 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2016   grade_9 99 148 327 0   44     1   9   347 281                       628 99 148 327 0   44     1   9   347 281                 628
941880 941880 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 67 6 322 0   2     0   0   201 196                       397 67 6 322 0   2     0   0   201 196                 397
938811 938811 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_9 43 94 303 0   4     0   8   239 213                       452 43 94 303 0   4     0   8   239 213                 452
936369 936369 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2016   grade_9 72 52 299 1   30     0   18   283 189                       472 72 52 299 1   30     0   18   283 189                 472
941881 941881 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_10 55 2 289 0   4     0   0   179 171                       350 55 2 289 0   4     0   0   179 171                 350
938812 938812 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_10 39 92 281 0   5     0   4   226 195                       421 39 92 281 0   5     0   4   226 195                 421
937115 937115 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_11 284 93 276 5   6     3   28   351 344                       695 284 93 276 5   6     3   28   351 344                 695
935621 935621 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2016   grade_9 73 15 272 0   1     0   5   194 172                       366 73 15 272 0   1     0   5   194 172                 366
938817 938817 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2016   grade_10 47 61 271 0   6     1   0   209 177                       386 47 61 271 0   6     1   0   209 177                 386
933689 933689 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   grade_10 42 27 270 2   6     0   2   192 157                       349 42 27 270 2   6     0   2   192 157                 349
938087 938087 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2016   grade_9 163 31 265 3   33     0   12   251 256                       507 163 31 265 3   33     0   12   251 256                 507
938088 938088 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2016   grade_10 144 19 263 0   26     0   10   227 235                       462 144 19 263 0   26     0   10   227 235                 462
936370 936370 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2016   grade_10 84 45 262 0   31     0   20   263 179                       442 84 45 262 0   31     0   20   263 179                 442
937113 937113 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_9 209 68 261 9   4     1   25   339 238                       577 209 68 261 9   4     1   25   339 238                 577
941882 941882 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_11 71 3 261 0   5     0   2   174 168                       342 71 3 261 0   5     0   2   174 168                 342
936356 936356 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2016   grade_6 52 37 259 5   37     0   15   213 192                       405 52 37 259 5   37     0   15   213 192                 405
938841 938841 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2016   grade_9 38 57 255 0   7     1   1   162 197                       359 38 57 255 0   7     1   1   162 197                 359
936359 936359 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2016   grade_6 67 46 254 5   59     0   17   225 223                       448 67 46 254 5   59     0   17   225 223                 448
934860 934860 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2016   grade_10 182 111 250 2   23     0   9   316 261                       577 182 111 250 2   23     0   9   316 261                 577
938843 938843 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2016   grade_11 35 66 246 0   6     0   5   169 189                       358 35 66 246 0   6     0   5   169 189                 358
934382 934382 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2016   grade_11 26 29 244 0   11     0   0   134 176                       310 26 29 244 0   11     0   0   134 176                 310
933690 933690 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   grade_11 53 25 242 2   5     0   2   182 147                       329 53 25 242 2   5     0   2   182 147                 329
941883 941883 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_12 66 4 242 1   3     0   0   165 151                       316 66 4 242 1   3     0   0   165 151                 316
936360 936360 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2016   grade_7 57 45 241 1   40     0   12   216 180                       396 57 45 241 1   40     0   12   216 180                 396
935622 935622 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2016   grade_10 100 10 238 0   7     0   7   200 162                       362 100 10 238 0   7     0   7   200 162                 362
936365 936365 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2016   grade_9 117 50 238 2   44     1   14   256 210                       466 117 50 238 2   44     1   14   256 210                 466
934351 934351 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No 1 PK KG 2016   pre_kindergarten 21 17 235 1   1     0   1   143 133                       276 21 17 235 1   1     0   1   143 133                 276
934859 934859 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2016   grade_9 164 90 235 3   24     1   8   281 244                       525 164 90 235 3   24     1   8   281 244                 525
938808 938808 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2016   grade_10 103 114 234 0   27     0   4   247 235                       482 103 114 234 0   27     0   4   247 235                 482
936357 936357 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2016   grade_7 36 34 233 0   29     0   10   194 148                       342 36 34 233 0   29     0   10   194 148                 342
933691 933691 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   grade_12 62 42 231 1   7     0   3   185 161                       346 62 42 231 1   7     0   3   185 161                 346
936361 936361 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2016   grade_8 71 35 228 0   52     0   9   207 188                       395 71 35 228 0   52     0   9   207 188                 395
936366 936366 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2016   grade_10 85 54 228 1   54     0   11   215 218                       433 85 54 228 1   54     0   11   215 218                 433
936371 936371 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2016   grade_11 98 33 225 0   28     0   5   189 200                       389 98 33 225 0   28     0   5   189 200                 389
938089 938089 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2016   grade_11 150 20 225 0   22     0   10   211 216                       427 150 20 225 0   22     0   10   211 216                 427
938810 938810 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2016   grade_12 85 96 225 0   27     0   3   221 215                       436 85 96 225 0   27     0   3   221 215                 436
936207 936207 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_9 253 96 223 0   259     0   24   432 423                       855 253 96 223 0   259     0   24   432 423                 855
934383 934383 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2016   grade_12 19 19 221 1   7     0   1   132 136                       268 19 19 221 1   7     0   1   132 136                 268
934861 934861 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2016   grade_11 164 110 212 3   19     0   6   287 227                       514 164 110 212 3   19     0   6   287 227                 514
938842 938842 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2016   grade_10 57 90 210 0   6     0   2   166 199                       365 57 90 210 0   6     0   2   166 199                 365
938818 938818 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2016   grade_11 26 60 208 0   8     0   1   170 133                       303 26 60 208 0   8     0   1   170 133                 303
936358 936358 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2016   grade_8 35 35 205 0   30     0   14   168 151                       319 35 35 205 0   30     0   14   168 151                 319
938809 938809 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2016   grade_11 73 114 191 0   31     0   6   204 211                       415 73 114 191 0   31     0   6   204 211                 415
941888 941888 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 227 21 190 3   96     0   25   327 235                       562 227 21 190 3   96     0   25   327 235                 562
937114 937114 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_10 123 50 189 4   4     4   19   216 177                       393 123 50 189 4   4     4   19   216 177                 393
936367 936367 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2016   grade_11 77 52 186 0   33     1   9   192 166                       358 77 52 186 0   33     1   9   192 166                 358
938813 938813 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_11 17 62 186 0   7     0   2   142 132                       274 17 62 186 0   7     0   2   142 132                 274
936208 936208 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_10 244 82 185 1   269     0   12   417 376                       793 244 82 185 1   269     0   12   417 376                 793
938844 938844 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2016   grade_12 37 63 185 0   7     0   2   132 162                       294 37 63 185 0   7     0   2   132 162                 294
938090 938090 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2016   grade_12 136 14 182 2   22     0   14   158 212                       370 136 14 182 2   22     0   14   158 212                 370
935623 935623 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2016   grade_11 72 10 181 0   2     0   3   132 136                       268 72 10 181 0   2     0   3   132 136                 268
935624 935624 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2016   grade_12 82 11 181 0   2     0   2   150 128                       278 82 11 181 0   2     0   2   150 128                 278
936372 936372 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2016   grade_12 78 46 176 0   35     0   8   162 181                       343 78 46 176 0   35     0   8   162 181                 343
940195 940195 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No 3 09 12 2016   grade_10 90 48 175 0   45     0   10   194 174                       368 90 48 175 0   45     0   10   194 174                 368
940181 940181 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_8 107 63 173 0   49     0   14   196 210                       406 107 63 173 0   49     0   14   196 210                 406
940191 940191 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No 3 09 12 2016   grade_10 84 66 173 1   28     0   12   182 182                       364 84 66 173 1   28     0   12   182 182                 364
936755 936755 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No 3 09 12 2016   grade_9 288 17 171 3   17     1   9   272 234                       506 288 17 171 3   17     1   9   272 234                 506
936756 936756 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No 3 09 12 2016   grade_10 281 19 171 0   22     0   6   266 233                       499 281 19 171 0   22     0   6   266 233                 499
935740 935740 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No 1 PK KG 2016   pre_kindergarten 28 2 170 0   5     0   1   116 90                       206 28 2 170 0   5     0   1   116 90                 206
941889 941889 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_10 247 12 169 2   99     0   13   307 235                       542 247 12 169 2   99     0   13   307 235                 542
940180 940180 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_7 114 61 168 1   41     0   15   216 184                       400 114 61 168 1   41     0   15   216 184                 400
940177 940177 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2016   grade_7 82 74 167 1   28     0   23   198 177                       375 82 74 167 1   28     0   23   198 177                 375
934024 934024 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_9 267 694 166 5   26     3   51   637 575                       1212 267 694 166 5   26     3   51   637 575                 1212
936210 936210 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_12 202 73 166 1   231     0   6   338 341                       679 202 73 166 1   231     0   6   338 341                 679
936209 936209 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_11 274 90 165 1   247     0   6   394 389                       783 274 90 165 1   247     0   6   394 389                 783
935049 935049 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2016   grade_10 105 21 163 0   23     1   12   169 156                       325 105 21 163 0   23     1   12   169 156                 325
936517 936517 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2016   grade_5 180 12 162 0   17     0   10   202 179                       381 180 12 162 0   17     0   10   202 179                 381
935050 935050 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2016   grade_11 96 17 161 0   16     0   14   159 145                       304 96 17 161 0   16     0   14   159 145                 304
936368 936368 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2016   grade_12 110 62 160 1   38     0   7   191 187                       378 110 62 160 1   38     0   7   191 187                 378
936382 936382 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 08 12 2016   grade_10 28 28 160 1   8     0   3   140 88                       228 28 28 160 1   8     0   3   140 88                 228
934356 934356 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2016   grade_1 18 16 159 0   1     0   4   103 95                       198 18 16 159 0   1     0   4   103 95                 198
934360 934360 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2016   grade_1 7 2 158 0   1     0   1   91 78                       169 7 2 158 0   1     0   1   91 78                 169
938773 938773 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No 2 06 08 2016   grade_6 29 59 155 0   6     0   1   138 112                       250 29 59 155 0   6     0   1   138 112                 250
934357 934357 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2016   grade_2 14 11 154 1   4     0   2   99 87                       186 14 11 154 1   4     0   2   99 87                 186
936242 936242 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No 1 PK 05 2016   kindergarten 15 13 154 1   17     0   9   107 102                       209 15 13 154 1   17     0   9   107 102                 209
938481 938481 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No 3 09 12 2016   grade_9 121 49 154 0   37     0   3   199 165                       364 121 49 154 0   37     0   3   199 165                 364
939259 939259 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No 3 09 12 2016   grade_10 167 41 153 1   23     1   11   209 188                       397 167 41 153 1   23     1   11   209 188                 397
940190 940190 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No 3 09 12 2016   grade_9 57 64 153 3   18     0   12   158 149                       307 57 64 153 3   18     0   12   158 149                 307
940175 940175 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2016   grade_8 237 53 151 0   23     0   28   258 234                       492 237 53 151 0   23     0   28   258 234                 492
934367 934367 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2016   grade_4 14 8 149 0   2     0   0   93 80                       173 14 8 149 0   2     0   0   93 80                 173
934974 934974 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2016   grade_9 330 48 149 2   29     2   29   312 277                       589 330 48 149 2   29     2   29   312 277                 589
935479 935479 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2016   grade_11 288 18 149 0   12     0   2   269 200                       469 288 18 149 0   12     0   2   269 200                 469
938550 938550 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No 1 PK 05 2016   pre_kindergarten 19 14 148 0   1     0   3   113 72                       185 19 14 148 0   1     0   3   113 72                 185
933670 933670 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2016   grade_9 17 89 147 0   33     0   2   182 106                       288 17 89 147 0   33     0   2   182 106                 288
938775 938775 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No 2 06 08 2016   grade_8 40 42 147 0   5     0   2   127 109                       236 40 42 147 0   5     0   2   127 109                 236
938819 938819 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2016   grade_12 19 34 147 1   6     0   1   122 86                       208 19 34 147 1   6     0   1   122 86                 208
938482 938482 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No 3 09 12 2016   grade_10 77 40 145 0   20     0   1   166 117                       283 77 40 145 0   20     0   1   166 117                 283
939258 939258 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No 3 09 12 2016   grade_9 154 36 145 1   18     2   13   178 191                       369 154 36 145 1   18     2   13   178 191                 369
940174 940174 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2016   grade_7 235 53 145 1   33     0   26   255 238                       493 235 53 145 1   33     0   26   255 238                 493
940178 940178 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2016   grade_8 73 74 145 0   29     0   12   159 174                       333 73 74 145 0   29     0   12   159 174                 333
935477 935477 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2016   grade_9 295 16 144 0   12     1   4   250 222                       472 295 16 144 0   12     1   4   250 222                 472
936381 936381 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 08 12 2016   grade_9 38 17 144 1   18     0   8   130 96                       226 38 17 144 1   18     0   8   130 96                 226
938767 938767 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No 2 06 08 2016   grade_6 24 46 144 0   14     1   3   111 121                       232 24 46 144 0   14     1   3   111 121                 232

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