enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by multiracial_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
2041412 2041412 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_9 326 29 65 0   75     1   58   296 255                       554.0 326 29 65 0   75     1   58   296 255                 554
2041414 2041414 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_11 266 38 51 0   88     0   46   260 227                       489.0 266 38 51 0   88     0   46   260 227                 489
2041311 2041311 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_9 174 708 154 3   20     4   45   585 523                       1108.0 174 708 154 3   20     4   45   585 523                 1108
2041549 2041549 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_9 198 143 77 3   44     2   45   262 250                       512.0 198 143 77 3   44     2   45   262 250                 512
2041413 2041413 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_10 287 40 73 0   100     1   41   261 279                       542.0 287 40 73 0   100     1   41   261 279                 542
2041312 2041312 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_10 197 601 130 3   22     4   38   541 454                       995.0 197 601 130 3   22     4   38   541 454                 995
2042274 2042274 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2019   grade_9 297 53 160 1   28     0   38   316 261                       577.0 297 53 160 1   28     0   38   316 261                 577
2041314 2041314 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_12 201 593 108 2   22     1   37   450 514                       964.0 201 593 108 2   22     1   37   450 514                 964
2041550 2041550 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_10 188 136 74 2   54     2   37   256 237                       493.0 188 136 74 2   54     2   37   256 237                 493
2041313 2041313 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_11 151 620 120 5   28     1   35   504 456                       960.0 151 620 120 5   28     1   35   504 456                 960
2042352 2042352 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2019   grade_10 81 24 154 0   11     0   35   143 162                       305.0 81 24 154 0   11     0   35   143 162                 305
2044546 2044546 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_9 328 32 52 2   92     0   35   283 258                       541.0 328 32 52 2   92     0   35   283 258                 541
2049371 2049371 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_9 252 35 56 1   10     1   35   157 233                       390.0 252 35 56 1   10     1   35   157 233                 390
2044410 2044410 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_9 232 111 247 5   9     1   34   339 300                       639.0 232 111 247 5   9     1   34   339 300                 639
2044547 2044547 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_10 307 42 44 3   68     0   34   254 242                       498.0 307 42 44 3   68     0   34   254 242                 498
2041415 2041415 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_12 292 33 59 0   81     1   33   243 255                       499.0 292 33 59 0   81     1   33   243 255                 499
2043292 2043292 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_9 286 31 19 0   229     0   33   297 301                       598.0 286 31 19 0   229     0   33   297 301                 598
2043293 2043293 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_10 269 15 24 2   199     0   33   264 278                       542.0 269 15 24 2   199     0   33   264 278                 542
2043294 2043294 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_11 258 23 19 1   238     0   33   287 284                       572.0 258 23 19 1   238     0   33   287 284                 572
2040002 2040002 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2019   grade_8 301 18 21 0   42     0   32   184 230                       414.0 301 18 21 0   42     0   32   184 230                 414
2041551 2041551 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_11 184 141 62 3   60     1   32   248 235                       483.0 184 141 62 3   60     1   32   248 235                 483
2044551 2044551 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2019   grade_9 277 29 28 0   113     0   32   252 226                       479.0 277 29 28 0   113     0   32   252 226                 479
2046374 2046374 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_8 400 110 79 3   8     0   31   331 300                       631.0 400 110 79 3   8     0   31   331 300                 631
2049184 2049184 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 318 51 144 1   8     1   31   282 272                       554.0 318 51 144 1   8     1   31   282 272                 554
2040000 2040000 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2019   grade_6 321 15 34 1   61     1   30   250 213                       463.0 321 15 34 1   61     1   30   250 213                 463
2043289 2043289 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_6 131 6 12 0   134     0   30   148 165                       313.0 131 6 12 0   134     0   30   148 165                 313
2043493 2043493 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_9 221 104 233 0   236     0   30   411 413                       824.0 221 104 233 0   236     0   30   411 413                 824
2044051 2044051 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2019   grade_11 247 6 164 0   15     1   30   231 232                       463.0 247 6 164 0   15     1   30   231 232                 463
2044404 2044404 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2019   grade_6 179 38 150 3   2     0   30   218 184                       402.0 179 38 150 3   2     0   30   218 184                 402
2044548 2044548 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_11 334 35 48 0   75     0   30   254 266                       522.0 334 35 48 0   75     0   30   254 266                 522
2047121 2047121 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2019   grade_6 245 3 11 1   63     0   30   178 175                       353.0 245 3 11 1   63     0   30   178 175                 353
2049176 2049176 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2019   grade_10 274 13 36 3   8     0   30   202 162                       364.0 274 13 36 3   8     0   30   202 162                 364
2046605 2046605 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2019   grade_5 123 15 12 2   2     0   29   84 99                       183.0 123 15 12 2   2     0   29   84 99                 183
2048097 2048097 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_9 246 9 22 0   154     0   29   227 233                       460.0 246 9 22 0   154     0   29   227 233                 460
2049188 2049188 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 2019   grade_9 210 31 230 2   96     0   29   300 295                       598.0 210 31 230 2   96     0   29   300 295                 598
2040201 2040201 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_5 210 12 24 1   90     1   28   189 177                       366.0 210 12 24 1   90     1   28   189 177                 366
2042516 2042516 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_4 127 2 34 1   0     0   28   113 79                       192.0 127 2 34 1   0     0   28   113 79                 192
2044052 2044052 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2019   grade_12 273 6 163 2   19     1   28   259 233                       492.0 273 6 163 2   19     1   28   259 233                 492
2044234 2044234 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No High 09 12 2019   grade_9 293 15 23 1   24     0   28   191 192                       384.0 293 15 23 1   24     0   28   191 192                 384
2046729 2046729 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2019   grade_6 264 22 15 0   65     0   28   180 213                       394.0 264 22 15 0   65     0   28   180 213                 394
2046731 2046731 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2019   grade_8 283 7 17 0   51     0   28   208 178                       386.0 283 7 17 0   51     0   28   208 178                 386
2048312 2048312 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2019   grade_4 170 19 20 8   2     0   28   123 124                       247.0 170 19 20 8   2     0   28   123 124                 247
2049230 2049230 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 175 120 46 1   7     0   28   190 186                       377.0 175 120 46 1   7     0   28   190 186                 377
2040060 2040060 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2019   grade_10 295 30 72 1   25     2   27   239 213                       452.0 295 30 72 1   25     2   27   239 213                 452
2048120 2048120 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2019   grade_10 121 17 42 0   24     0   27   104 127                       231.0 121 17 42 0   24     0   27   104 127                 231
2040202 2040202 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_6 229 14 18 0   77     0   26   191 173                       364.0 229 14 18 0   77     0   26   191 173                 364
2042462 2042462 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_12 301 49 126 0   38     0   26   283 257                       540.0 301 49 126 0   38     0   26   283 257                 540
2043290 2043290 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_7 123 16 13 0   100     0   26   130 148                       278.0 123 16 13 0   100     0   26   130 148                 278
2044411 2044411 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_10 159 101 241 3   5     2   26   268 269                       537.0 159 101 241 3   5     2   26   268 269                 537
2045715 2045715 MA Middlesex   school 2510890 274   Somerville 251089002561 2740005 Capuano Early Childhood Center   Regular School No Elementary PK KG 2019   pre_kindergarten 108 15 68 0   21     0   26   139 99                       238.0 108 15 68 0   21     0   26   139 99                 238
2047029 2047029 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2019   grade_9 375 30 44 0   25     1   26   270 230                       501.0 375 30 44 0   25     1   26   270 230                 501
2041026 2041026 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_9 166 34 53 0   129     0   25   175 232                       407.0 166 34 53 0   129     0   25   175 232                 407
2043494 2043494 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_10 202 83 203 1   251     0   25   370 395                       765.0 202 83 203 1   251     0   25   370 395                 765
2044050 2044050 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2019   grade_10 260 6 201 1   25     0   25   280 238                       518.0 260 6 201 1   25     0   25   280 238                 518
2044542 2044542 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2019   grade_8 198 18 16 2   42     0   25   177 124                       301.0 198 18 16 2   42     0   25   177 124                 301
2044552 2044552 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2019   grade_10 301 25 34 0   111     0   25   257 237                       496.0 301 25 34 0   111     0   25   257 237                 496
2049185 2049185 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 326 39 144 4   3     0   25   264 277                       541.0 326 39 144 4   3     0   25   264 277                 541
2049231 2049231 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_11 153 113 45 0   7     0   25   175 168                       343.0 153 113 45 0   7     0   25   175 168                 343
2040203 2040203 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2019   grade_7 245 14 24 1   52     0   24   174 186                       360.0 245 14 24 1   52     0   24   174 186                 360
2042275 2042275 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2019   grade_10 308 52 151 1   28     0   24   278 286                       564.0 308 52 151 1   28     0   24   278 286                 564
2044271 2044271 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2019   grade_6 359 9 28 0   30     0   24   224 226                       450.0 359 9 28 0   30     0   24   224 226                 450
2044272 2044272 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No High 09 12 2019   grade_9 355 10 17 2   42     0   24   215 235                       450.0 355 10 17 2   42     0   24   215 235                 450
2044401 2044401 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2019   grade_6 127 56 149 1   6     1   24   198 166                       364.0 127 56 149 1   6     1   24   198 166                 364
2046258 2046258 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2019   grade_7 240 14 9 0   23     0   24   150 160                       310.0 240 14 9 0   23     0   24   150 160                 310
2046604 2046604 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2019   grade_4 127 20 17 2   1     1   24   103 89                       192.0 127 20 17 2   1     1   24   103 89                 192
2047460 2047460 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2019   grade_8 201 75 177 1   24     0   24   242 260                       502.0 201 75 177 1   24     0   24   242 260                 502
2048243 2048243 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Middle 04 06 2019   grade_6 247 14 4 1   4     2   24   136 160                       296.0 247 14 4 1   4     2   24   136 160                 296
2040118 2040118 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2019   grade_4 288 32 62 2   7     0   23   218 196                       414.0 288 32 62 2   7     0   23   218 196                 414
2040205 2040205 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2019   grade_9 235 11 17 0   58     0   23   170 174                       344.0 235 11 17 0   58     0   23   170 174                 344
2041552 2041552 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_12 183 156 68 2   60     1   23   249 244                       493.0 183 156 68 2   60     1   23   249 244                 493
2042262 2042262 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_6 127 19 47 1   6     1   23   107 117                       224.0 127 19 47 1   6     1   23   107 117                 224
2042351 2042351 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2019   grade_9 77 13 144 0   16     0   23   152 121                       273.0 77 13 144 0   16     0   23   152 121                 273
2042460 2042460 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_10 345 47 128 0   31     0   23   287 287                       574.0 345 47 128 0   31     0   23   287 287                 574
2043287 2043287 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_7 123 14 16 0   120     0   23   144 152                       296.0 123 14 16 0   120     0   23   144 152                 296
2043291 2043291 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_8 149 9 10 0   137     0   23   160 168                       328.0 149 9 10 0   137     0   23   160 168                 328
2044269 2044269 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No Middle 07 08 2019   grade_7 332 12 33 0   39     0   23   210 229                       439.0 332 12 33 0   39     0   23   210 229                 439
2044549 2044549 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_12 361 18 56 3   83     0   23   269 274                       544.0 361 18 56 3   83     0   23   269 274                 544
2046733 2046733 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley Sr High   Regular School No High 09 12 2019   grade_10 294 13 19 0   56     0   23   206 199                       405.0 294 13 19 0   56     0   23   206 199                 405
2048098 2048098 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_10 243 8 11 1   143     0   23   223 206                       429.0 243 8 11 1   143     0   23   223 206                 429
2040003 2040003 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_9 270 15 18 0   39     0   22   175 189                       364.0 270 15 18 0   39     0   22   175 189                 364
2040122 2040122 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_8 260 25 47 2   5     1   22   157 205                       362.0 260 25 47 2   5     1   22   157 205                 362
2041884 2041884 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2019   grade_9 242 5 11 0   1     0   22   136 145                       281.0 242 5 11 0   1     0   22   136 145                 281
2042265 2042265 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2019   grade_6 139 18 64 0   11     0   22   111 143                       254.0 139 18 64 0   11     0   22   111 143                 254
2042277 2042277 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2019   grade_12 245 36 106 1   23     2   22   217 218                       435.0 245 36 106 1   23     2   22   217 218                 435
2042305 2042305 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2019   grade_5 225 8 14 12   5     0   22   153 133                       286.0 225 8 14 12   5     0   22   153 133                 286
2042461 2042461 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_11 338 35 131 0   28     1   22   282 273                       555.0 338 35 131 0   28     1   22   282 273                 555
2044235 2044235 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No High 09 12 2019   grade_10 319 14 32 0   20     1   22   190 218                       408.0 319 14 32 0   20     1   22   190 218                 408
2046216 2046216 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2019   grade_6 154 57 32 0   8     4   22   126 151                       277.0 154 57 32 0   8     4   22   126 151                 277
2046375 2046375 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_9 334 86 96 1   10     0   22   271 278                       549.0 334 86 96 1   10     0   22   271 278                 549
2048257 2048257 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2019   grade_12 351 12 0 0   7     2   22   198 196                       394.0 351 12 0 0   7     2   22   198 196                 394
2048294 2048294 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No High 09 12 2019   grade_9 250 14 18 1   25     0   22   145 184                       330.0 250 14 18 1   25     0   22   145 184                 330
2049191 2049191 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 2019   grade_12 214 17 179 2   80     0   22   300 214                       514.0 214 17 179 2   80     0   22   300 214                 514
2049369 2049369 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_7 111 16 27 0   5     0   22   89 92                       181.0 111 16 27 0   5     0   22   89 92                 181
2040101 2040101 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 78 15 30 1   1     0   21   88 58                       146.0 78 15 30 1   1     0   21   88 58                 146
2040206 2040206 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2019   grade_10 224 10 10 1   64     0   21   170 160                       330.0 224 10 10 1   64     0   21   170 160                 330
2041886 2041886 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2019   grade_11 234 2 9 0   1     0   21   149 118                       267.0 234 2 9 0   1     0   21   149 118                 267
2042459 2042459 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_9 337 50 156 2   35     1   21   300 302                       602.0 337 50 156 2   35     1   21   300 302                 602
2043295 2043295 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_12 300 15 21 0   194     0   21   287 264                       551.0 300 15 21 0   194     0   21   287 264                 551
2044406 2044406 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2019   grade_8 200 30 144 2   8     0   21   203 202                       405.0 200 30 144 2   8     0   21   203 202                 405
2044412 2044412 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_11 159 89 261 4   7     1   21   297 245                       542.0 159 89 261 4   7     1   21   297 245                 542

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