Data source: Big Local News · About: Big Local

11,284 rows where state = "MA" and year = 2018 sorted by hispanic_int descending

View and edit SQL

year

  • 2018 · 11,284
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
2232680 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_9 30 6 854 0   20     0   1   500 411                       911.0 30 6 854 0   20     0   1   500 411                 911
2232681 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_10 29 15 826 1   10     0   1   483 399                       882.0 29 15 826 1   10     0   1   483 399                 882
2232682 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_11 21 13 688 1   13     0   5   363 378                       741.0 21 13 688 1   13     0   5   363 378                 741
2232683 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_12 24 13 679 0   14     0   1   344 387                       731.0 24 13 679 0   14     0   1   344 387                 731
2230890 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea: Shurtleff Early Childhood   Regular School No Elementary PK 01 2018   kindergarten 39 33 429 0   8     0   4   241 272                       513.0 39 33 429 0   8     0   4   241 272                 513
2236218 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield: Springfield Central High   Regular School No High 09 12 2018   grade_9 76 162 408 0   34     0   7   394 293                       687.0 76 162 408 0   34     0   7   394 293                 687
2232436 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke: Holyoke High   Regular School No High 09 12 2018   grade_9 74 6 378 1   4     0   2   254 211                       465.0 74 6 378 1   4     0   2   254 211                 465
2235358 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere: Revere High   Regular School No High 09 12 2018   grade_9 184 19 363 8   30     0   10   320 294                       614.0 184 19 363 8   30     0   10   320 294                 614
2230930 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea: Chelsea High   Regular School No High 09 12 2018   grade_10 21 21 361 0   7     1   2   218 195                       413.0 21 21 361 0   7     1   2   218 195                 413
2230931 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea: Chelsea High   Regular School No High 09 12 2018   grade_11 17 22 346 0   6     0   2   206 187                       393.0 17 22 346 0   6     0   2   206 187                 393
2233318 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn: Lynn English High   Regular School No High 09 12 2018   grade_9 73 44 345 1   41     0   13   317 200                       517.0 73 44 345 1   41     0   13   317 200                 517
2230929 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea: Chelsea High   Regular School No High 09 12 2018   grade_9 17 29 343 0   8     0   1   236 162                       398.0 17 29 343 0   8     0   1   236 162                 398
2239827 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 66 3 341 1   8     0   0   217 202                       419.0 66 3 341 1   8     0   0   217 202                 419
2239828 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_10 60 3 328 1   4     0   0   180 216                       396.0 60 3 328 1   4     0   0   180 216                 396
2233301 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_6 45 45 317 0   33     0   15   230 225                       455.0 45 45 317 0   33     0   15   230 225                 455
2233305 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_6 49 45 316 0   41     0   19   265 205                       470.0 49 45 316 0   41     0   19   265 205                 470
2239829 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_11 65 6 305 0   2     0   0   193 185                       378.0 65 6 305 0   2     0   0   193 185                 378
2236219 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield: Springfield Central High   Regular School No High 09 12 2018   grade_10 76 121 298 1   28     1   5   267 263                       530.0 76 121 298 1   28     1   5   267 263                 530
2233303 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_8 53 40 291 6   35     0   15   227 213                       440.0 53 40 291 6   35     0   15   227 213                 440
2237559 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Worcester: Head Start   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 104 107 290 0   12     0   16   254 275                       529.0 104 107 290 0   12     0   16   254 275                 529
2230107 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_11 45 30 286 2   5     0   4   200 172                       372.0 45 30 286 2   5     0   4   200 172                 372
2233319 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn: Lynn English High   Regular School No High 09 12 2018   grade_10 66 30 286 0   48     0   10   217 223                       440.0 66 30 286 0   48     0   10   217 223                 440
2234204 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_10 179 90 285 4   5     1   22   325 261                       586.0 179 90 285 4   5     1   22   325 261                 586
2230932 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea: Chelsea High   Regular School No High 09 12 2018   grade_12 16 21 283 0   12     0   1   160 173                       333.0 16 21 283 0   12     0   1   160 173                 333
2236228 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield: Springfield High School of Science and Technology   Regular School No High 09 12 2018   grade_9 27 69 281 0   6     0   1   229 155                       384.0 27 69 281 0   6     0   1   229 155                 384
2230105 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_9 34 17 277 0   6     0   6   222 118                       340.0 34 17 277 0   6     0   6   222 118                 340
2233313 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn: Classical High   Regular School No High 09 12 2018   grade_9 68 30 274 2   30     0   7   240 171                       411.0 68 30 274 2   30     0   7   240 171                 411
2233302 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_7 41 40 269 0   35     0   13   195 203                       398.0 41 40 269 0   35     0   13   195 203                 398
2230108 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_12 43 36 268 2   6     0   3   200 158                       358.0 43 36 268 2   6     0   3   200 158                 358
2231502 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett: Everett High   Regular School No High 09 12 2018   grade_10 132 91 266 2   27     2   5   271 254                       525.0 132 91 266 2   27     2   5   271 254                 525
2236229 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield: Springfield High School of Science and Technology   Regular School No High 09 12 2018   grade_10 35 64 265 1   6     1   6   225 153                       378.0 35 64 265 1   6     1   6   225 153                 378
2233306 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_7 67 37 264 1   49     0   16   216 218                       434.0 67 37 264 1   49     0   16   216 218                 434
2239830 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_12 47 2 263 0   4     0   0   163 153                       316.0 47 2 263 0   4     0   0   163 153                 316
2235360 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere: Revere High   Regular School No High 09 12 2018   grade_11 146 25 262 2   36     0   10   234 247                       481.0 146 25 262 2   36     0   10   234 247                 481
2236255 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Springfield: Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2018   grade_9 29 71 260 1   3     0   3   180 187                       367.0 29 71 260 1   3     0   3   180 187                 367
2233314 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn: Classical High   Regular School No High 09 12 2018   grade_10 92 44 258 1   47     0   9   254 197                       451.0 92 44 258 1   47     0   9   254 197                 451
2236223 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 Springfield: High School Of Commerce   Regular School No High 09 12 2018   grade_9 35 53 257 0   6     0   5   177 179                       356.0 35 53 257 0   6     0   5   177 179                 356
2233307 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_8 65 40 256 4   52     0   12   223 206                       429.0 65 40 256 4   52     0   12   223 206                 429
2236256 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Springfield: Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2018   grade_10 48 66 255 0   6     0   1   164 212                       376.0 48 66 255 0   6     0   1   164 212                 376
2235361 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere: Revere High   Regular School No High 09 12 2018   grade_12 134 24 253 0   28     0   7   224 222                       446.0 134 24 253 0   28     0   7   224 222                 446
2234205 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_11 152 75 252 2   8     2   19   280 230                       510.0 152 75 252 2   8     2   19   280 230                 510
2231503 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett: Everett High   Regular School No High 09 12 2018   grade_11 141 96 251 1   23     1   5   260 258                       518.0 141 96 251 1   23     1   5   260 258                 518
2232437 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke: Holyoke High   Regular School No High 09 12 2018   grade_10 59 6 244 0   3     0   5   146 170                       317.0 59 6 244 0   3     0   5   146 170                 317
2233118 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_9 214 80 242 1   256     0   29   409 413                       822.0 214 80 242 1   256     0   29   409 413                 822
2235359 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere: Revere High   Regular School No High 09 12 2018   grade_10 150 12 240 2   28     0   11   226 217                       443.0 150 12 240 2   28     0   11   226 217                 443
2236257 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Springfield: Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2018   grade_11 36 58 240 0   6     0   1   155 186                       341.0 36 58 240 0   6     0   1   155 186                 341
2233320 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn: Lynn English High   Regular School No High 09 12 2018   grade_11 62 45 238 1   23     0   11   210 170                       380.0 62 45 238 1   23     0   11   210 170                 380
2230891 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea: Shurtleff Early Childhood   Regular School No Elementary PK 01 2018   pre_kindergarten 29 8 236 0   0     0   2   151 124                       275.0 29 8 236 0   0     0   2   151 124                 275
2236764 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham: Waltham Sr High   Regular School No High 09 12 2018   grade_10 164 37 232 1   16     0   6   271 185                       456.0 164 37 232 1   16     0   6   271 185                 456
2230106 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_10 27 11 228 1   4     0   3   147 127                       274.0 27 11 228 1   4     0   3   147 127                 274
2234203 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_9 172 81 227 4   5     2   26   284 233                       517.0 172 81 227 4   5     2   26   284 233                 517
2233321 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn: Lynn English High   Regular School No High 09 12 2018   grade_12 74 46 221 0   30     0   15   207 179                       386.0 74 46 221 0   30     0   15   207 179                 386
2231501 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett: Everett High   Regular School No High 09 12 2018   grade_9 100 86 212 0   28     0   10   230 206                       436.0 100 86 212 0   28     0   10   230 206                 436
2237867 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_7 92 67 210 1   38     0   16   226 198                       424.0 92 67 210 1   38     0   16   226 198                 424
2231504 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett: Everett High   Regular School No High 09 12 2018   grade_12 150 112 208 2   23     0   5   253 247                       500.0 150 112 208 2   23     0   5   253 247                 500
2233315 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn: Classical High   Regular School No High 09 12 2018   grade_11 114 43 205 1   46     1   10   224 196                       420.0 114 43 205 1   46     1   10   224 196                 420
2236258 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Springfield: Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2018   grade_12 49 88 205 0   5     0   5   160 192                       352.0 49 88 205 0   5     0   5   160 192                 352
2237863 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_7 78 69 204 0   22     0   17   196 194                       390.0 78 69 204 0   22     0   17   196 194                 390
2233334 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_10 36 10 200 0   13     0   7   150 116                       266.0 36 10 200 0   13     0   7   150 116                 266
2233119 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_10 227 93 199 0   240     1   20   393 387                       780.0 227 93 199 0   240     1   20   393 387                 780
2236230 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield: Springfield High School of Science and Technology   Regular School No High 09 12 2018   grade_11 40 52 198 0   6     0   4   165 135                       300.0 40 52 198 0   6     0   4   165 135                 300
2232268 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill: Haverhill High   Regular School No High 09 12 2018   grade_9 339 25 197 1   6     0   8   309 267                       576.0 339 25 197 1   6     0   8   309 267                 576
2236220 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield: Springfield Central High   Regular School No High 09 12 2018   grade_11 76 109 196 0   39     1   7   220 208                       428.0 76 109 196 0   39     1   7   220 208                 428
2232578 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 Lawrence: John Breen School   Regular School No Elementary PK KG 2018   pre_kindergarten 10 6 195 0   7     0   1   123 96                       219.0 10 6 195 0   7     0   1   123 96                 219
2236221 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield: Springfield Central High   Regular School No High 09 12 2018   grade_12 82 96 195 0   26     0   5   212 192                       404.0 82 96 195 0   26     0   5   212 192                 404
2239837 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 277 29 195 1   98     0   20   335 285                       620.0 277 29 195 1   98     0   20   335 285                 620
2232439 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke: Holyoke High   Regular School No High 09 12 2018   grade_12 83 8 192 0   3     0   7   159 134                       293.0 83 8 192 0   3     0   7   159 134                 293
2233120 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_11 222 104 192 0   243     0   19   380 400                       780.0 222 104 192 0   243     0   19   380 400                 780
2236194 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield: Chestnut Academy   Regular School No Middle 06 08 2018   grade_8 9 26 190 1   1     0   2   121 108                       229.0 9 26 190 1   1     0   2   121 108                 229
2233776 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen: Methuen High   Regular School No High 09 12 2018   grade_10 253 3 189 0   17     1   30   260 233                       493.0 253 3 189 0   17     1   30   260 233                 493
2233775 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen: Methuen High   Regular School No High 09 12 2018   grade_9 258 4 188 1   24     0   23   264 234                       498.0 258 4 188 1   24     0   23   264 234                 498
2239838 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_10 246 20 188 1   90     0   19   297 267                       564.0 246 20 188 1   90     0   19   297 267                 564
2239839 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_11 227 21 185 2   87     0   23   317 228                       545.0 227 21 185 2   87     0   23   317 228                 545
2233316 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn: Classical High   Regular School No High 09 12 2018   grade_12 81 48 182 2   53     0   12   181 197                       378.0 81 48 182 2   53     0   12   181 197                 378
2233496 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough: 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2018   grade_5 184 10 181 0   11     0   9   198 197                       395.0 184 10 181 0   11     0   9   198 197                 395
2232438 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke: Holyoke High   Regular School No High 09 12 2018   grade_11 61 12 179 0   1     1   3   127 130                       257.0 61 12 179 0   1     1   3   127 130                 257
2230229 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston: Mario Umana Academy   Regular School No Elementary PK 08 2018   grade_6 16 5 177 0   6     0   1   104 101                       205.0 16 5 177 0   6     0   1   104 101                 205
2236226 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 Springfield: High School Of Commerce   Regular School No High 09 12 2018   grade_12 24 53 175 0   2     0   3   142 115                       257.0 24 53 175 0   2     0   3   142 115                 257
2237864 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_8 76 57 175 0   22     0   8   174 164                       338.0 76 57 175 0   22     0   8   174 164                 338
2233498 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough: 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2018   grade_7 123 13 173 0   8     0   8   176 149                       325.0 123 13 173 0   8     0   8   176 149                 325
2237859 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester: Forest Grove Middle   Regular School No Middle 07 08 2018   grade_7 199 65 173 1   23     0   25   238 248                       486.0 199 65 173 1   23     0   25   238 248                 486
2237860 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester: Forest Grove Middle   Regular School No Middle 07 08 2018   grade_8 213 57 173 0   27     0   22   259 233                       492.0 213 57 173 0   27     0   22   259 233                 492
2237885 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 Worcester: South High Community   Regular School No High 09 12 2018   grade_9 84 53 173 0   38     0   15   185 178                       363.0 84 53 173 0   38     0   15   185 178                 363
2236165 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield: Forest Park Middle   Regular School No Middle 06 08 2018   grade_6 8 43 168 0   24     0   1   120 124                       244.0 8 43 168 0   24     0   1   120 124                 244
2237886 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 Worcester: South High Community   Regular School No High 09 12 2018   grade_10 79 60 168 0   47     0   9   189 174                       363.0 79 60 168 0   47     0   9   189 174                 363
2233333 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_9 42 21 167 0   20     0   6   145 111                       256.0 42 21 167 0   20     0   6   145 111                 256
2237880 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 Worcester: North High   Regular School No High 09 12 2018   grade_9 58 81 167 0   22     0   13   170 171                       341.0 58 81 167 0   22     0   13   170 171                 341
2231631 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River: B M C Durfee High   Regular School No High 09 12 2018   grade_9 345 47 164 0   31     0   28   317 298                       615.0 345 47 164 0   31     0   28   317 298                 615
2235913 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Springfield: Edward P. Boland School   Regular School No Elementary PK 05 2018   pre_kindergarten 21 12 164 0   5     0   2   115 89                       204.0 21 12 164 0   5     0   2   115 89                 204
2237868 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_8 103 56 164 1   49     0   20   199 194                       393.0 103 56 164 1   49     0   20   199 194                 393
2236167 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield: Forest Park Middle   Regular School No Middle 06 08 2018   grade_8 13 51 163 0   20     1   3   129 122                       251.0 13 51 163 0   20     1   3   129 122                 251
2236224 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 Springfield: High School Of Commerce   Regular School No High 09 12 2018   grade_10 24 48 161 0   5     1   3   140 102                       242.0 24 48 161 0   5     1   3   140 102                 242
2233777 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen: Methuen High   Regular School No High 09 12 2018   grade_11 283 2 159 2   18     1   28   268 225                       493.0 283 2 159 2   18     1   28   268 225                 493
2232575 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawrence: Lawlor Early Childhood Center   Regular School No Elementary KG KG 2018   kindergarten 2 2 158 0   0     0   1   87 76                       163.0 2 2 158 0   0     0   1   87 76                 163
2230513 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_9 218 689 157 3   23     3   50   630 513                       1143.0 218 689 157 3   23     3   50   630 513                 1143
2233336 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_12 30 24 157 1   8     0   4   141 83                       224.0 30 24 157 1   8     0   4   141 83                 224
2233778 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen: Methuen High   Regular School No High 09 12 2018   grade_12 258 5 157 0   23     0   21   237 227                       464.0 258 5 157 0   23     0   21   237 227                 464
2239840 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_12 236 12 157 2   92     0   14   294 219                       513.0 236 12 157 2   92     0   14   294 219                 513
2230116 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston: Madison Park High   Career and Technical School No High 09 12 2018   grade_10 2 72 155 1   2     0   6   130 108                       238.0 2 72 155 1   2     0   6   130 108                 238
2232630 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_7 6 0 155 0   1     0   0   83 79                       162.0 6 0 155 0   1     0   0   83 79                 162

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