enrollments

Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by native_hawaiian_pacific_islander descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2015 · 9,541 ✖
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
740277 740277 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_11 226 61 151 6   2     6   31   271 212                       483 226 61 151 6   2     6   31   271 212                 483
741069 741069 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2015   kindergarten 35 8 10 0   53     6   2   57 57                       114 35 8 10 0   53     6   2   57 57                 114
738300 738300 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No 1 PK PK 2015   pre_kindergarten 110 2 4 1   10     5   4   84 52                       136 110 2 4 1   10     5   4   84 52                 136
738421 738421 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2015   grade_9 205 2 22 0   3     5   4   118 123                       241 205 2 22 0   3     5   4   118 123                 241
737596 737596 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2015   grade_10 247 9 86 1   12     4   9   212 156                       368 247 9 86 1   12     4   9   212 156                 368
738496 738496 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_4 35 0 0 1   1     4   1   22 20                       42 35 0 0 1   1     4   1   22 20                 42
739100 739100 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No 2 06 08 2015   grade_7 160 20 81 1   8     4   10   144 140                       284 160 20 81 1   8     4   10   144 140                 284
740275 740275 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_9 213 54 248 8   3     4   27   322 235                       557 213 54 248 8   3     4   27   322 235                 557
740278 740278 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_12 183 71 105 1   10     4   32   200 206                       406 183 71 105 1   10     4   32   200 206                 406
737118 737118 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2015   grade_5 57 85 21 0   7     3   10   92 91                       183 57 85 21 0   7     3   10   92 91                 183
737165 737165 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_10 220 623 140 4   27     3   25   503 539                       1042 220 623 140 4   27     3   25   503 539                 1042
737598 737598 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2015   grade_12 231 8 67 0   11     3   9   184 145                       329 231 8 67 0   11     3   9   184 145                 329
738399 738399 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Milton L Fuller Elementary   Regular School No 1 PK PK 2015   pre_kindergarten 80 1 1 1   1     3   1   56 32                       88 80 1 1 1   1     3   1   56 32                 88
738419 738419 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_7 171 3 15 0   4     3   7   95 108                       203 171 3 15 0   4     3   7   95 108                 203
738495 738495 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_3 42 2 3 0   1     3   4   28 27                       55 42 2 3 0   1     3   4   28 27                 55
739193 739193 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No 1 03 05 2015   grade_5 92 2 4 0   4     3   1   55 51                       106 92 2 4 0   4     3   1   55 51                 106
739386 739386 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_5 112 3 12 1   2     3   1   69 65                       134 112 3 12 1   2     3   1   69 65                 134
739622 739622 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_11 287 11 7 2   16     3   2   165 163                       328 287 11 7 2   16     3   2   165 163                 328
740019 740019 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2015   grade_9 158 65 8 0   17     3   10   129 132                       261 158 65 8 0   17     3   10   129 132                 261
740271 740271 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_8 221 21 94 3   2     3   12   165 191                       356 221 21 94 3   2     3   12   165 191                 356
740274 740274 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_8 88 25 93 0   0     3   9   122 96                       218 88 25 93 0   0     3   9   122 96                 218
740276 740276 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_10 297 93 274 3   5     3   32   369 338                       707 297 93 274 3   5     3   32   369 338                 707
740417 740417 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_12 290 18 26 0   93     3   14   209 235                       444 290 18 26 0   93     3   14   209 235                 444
740522 740522 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2015   grade_7 281 13 32 0   30     3   4   173 190                       363 281 13 32 0   30     3   4   173 190                 363
740523 740523 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2015   grade_8 342 10 32 0   23     3   6   214 202                       416 342 10 32 0   23     3   6   214 202                 416
740525 740525 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2015   grade_10 254 10 25 0   23     3   10   150 175                       325 254 10 25 0   23     3   10   150 175                 325
741060 741060 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2015   grade_2 43 13 11 0   25     3   3   57 41                       98 43 13 11 0   25     3   3   57 41                 98
742075 742075 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No 1 KG 05 2015   grade_2 29 7 2 0   2     3   4   19 28                       47 29 7 2 0   2     3   4   19 28                 47
742248 742248 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_8 448 75 73 1   16     3   27   346 297                       643 448 75 73 1   16     3   27   346 297                 643
742462 742462 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No 2 04 06 2015   grade_6 95 5 7 0   0     3   4   66 48                       114 95 5 7 0   0     3   4   66 48                 114
742722 742722 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No 3 09 12 2015   grade_12 269 4 39 1   14     3   3   170 163                       333 269 4 39 1   14     3   3   170 163                 333
742969 742969 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2015   grade_11 190 2 6 0   5     3   2   89 119                       208 190 2 6 0   5     3   2   89 119                 208
744370 744370 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No 1 KG 05 2015   kindergarten 36 0 1 0   0     3   1   20 21                       41 36 0 1 0   0     3   1   20 21                 41
744622 744622 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2015   grade_11 317 5 13 0   30     3   7   180 195                       375 317 5 13 0   30     3   7   180 195                 375
744623 744623 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2015   grade_12 317 2 8 0   22     3   2   164 190                       354 317 2 8 0   22     3   2   164 190                 354
735713 735713 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_12 267 6 8 2   7     2   3   153 142                       295 267 6 8 2   7     2   3   153 142                 295
735901 735901 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_6 96 8 17 0   7     2   10   80 60                       140 96 8 17 0   7     2   10   80 60                 140
735908 735908 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_9 310 30 48 3   22     2   18   224 209                       433 310 30 48 3   22     2   18   224 209                 433
735970 735970 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_6 275 28 35 3   5     2   15   209 154                       363 275 28 35 3   5     2   15   209 154                 363
735972 735972 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_8 316 22 13 4   21     2   20   197 201                       398 316 22 13 4   21     2   20   197 201                 398
735973 735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
735976 735976 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_12 273 18 20 2   9     2   10   161 173                       334 273 18 20 2   9     2   10   161 173                 334
736060 736060 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2015   grade_9 244 16 9 0   53     2   17   172 169                       341 244 16 9 0   53     2   17   172 169                 341
736114 736114 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2015   grade_8 235 11 25 0   5     2   5   133 150                       283 235 11 25 0   5     2   5   133 150                 283
736161 736161 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No 2 06 08 2015   grade_8 192 1 6 0   10     2   3   114 100                       214 192 1 6 0   10     2   3   114 100                 214
736163 736163 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2015   grade_9 292 6 11 0   14     2   5   163 167                       330 292 6 11 0   14     2   5   163 167                 330
736373 736373 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 05 2015   grade_5 24 44 34 0   10     2   7   60 61                       121 24 44 34 0   10     2   7   60 61                 121
736422 736422 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2015   grade_2 0 30 19 0   4     2   3   24 34                       58 0 30 19 0   4     2   3   24 34                 58
736425 736425 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2015   grade_5 0 26 13 0   0     2   0   15 26                       41 0 26 13 0   0     2   0   15 26                 41
736557 736557 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_8 0 41 43 0   0     2   0   39 47                       86 0 41 43 0   0     2   0   39 47                 86
736695 736695 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_2 3 52 29 0   0     2   2   40 48                       88 3 52 29 0   0     2   2   40 48                 88
736857 736857 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_10 74 87 68 1   58     2   7   123 174                       297 74 87 68 1   58     2   7   123 174                 297
736905 736905 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2015   grade_10 4 63 19 1   4     2   1   50 44                       94 4 63 19 1   4     2   1   50 44                 94
737090 737090 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   kindergarten 17 68 12 1   2     2   7   56 53                       109 17 68 12 1   2     2   7   56 53                 109
737134 737134 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2015   kindergarten 23 58 13 1   1     2   11   58 51                       109 23 58 13 1   1     2   11   58 51                 109
737154 737154 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_8 50 86 26 0   2     2   7   88 85                       173 50 86 26 0   2     2   7   88 85                 173
737155 737155 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_6 61 110 28 0   7     2   11   108 111                       219 61 110 28 0   7     2   11   108 111                 219
737156 737156 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_7 69 95 32 1   8     2   8   113 102                       215 69 95 32 1   8     2   8   113 102                 215
737164 737164 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_9 206 707 159 6   31     2   35   624 522                       1146 206 707 159 6   31     2   35   624 522                 1146
737390 737390 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2015   grade_7 35 32 13 2   4     2   4   53 39                       92 35 32 13 2   4     2   4   53 39                 92
737402 737402 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_10 193 139 64 2   56     2   15   250 221                       471 193 139 64 2   56     2   15   250 221                 471
737419 737419 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2015   kindergarten 57 7 6 0   14     2   2   45 43                       88 57 7 6 0   14     2   2   45 43                 88
737420 737420 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2015   grade_1 68 6 1 0   12     2   5   48 46                       94 68 6 1 0   12     2   5   48 46                 94
737703 737703 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2015   grade_8 257 6 17 0   9     2   5   155 141                       296 257 6 17 0   9     2   5   155 141                 296
737732 737732 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2015   grade_10 272 7 8 0   11     2   3   147 156                       303 272 7 8 0   11     2   3   147 156                 303
737855 737855 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_9 157 9 3 0   0     2   2   82 91                       173 157 9 3 0   0     2   2   82 91                 173
737930 737930 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No 3 09 12 2015   grade_12 244 17 12 0   10     2   8   147 146                       293 244 17 12 0   10     2   8   147 146                 293
738110 738110 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2015   grade_8 126 13 40 0   8     2   11   84 116                       200 126 13 40 0   8     2   11   84 116                 200
738123 738123 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_9 376 59 148 1   36     2   19   344 297                       641 376 59 148 1   36     2   19   344 297                 641
738341 738341 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_7 141 1 2 0   8     2   7   81 80                       161 141 1 2 0   8     2   7   81 80                 161
738342 738342 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_8 134 0 6 0   6     2   2   73 77                       150 134 0 6 0   6     2   2   73 77                 150
738366 738366 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 09 12 2015   grade_11 105 1 9 2   3     2   3   73 52                       125 105 1 9 2   3     2   3   73 52                 125
738418 738418 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_6 161 0 20 2   0     2   3   88 100                       188 161 0 20 2   0     2   3   88 100                 188
738434 738434 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_3 84 0 4 1   7     2   3   56 45                       101 84 0 4 1   7     2   3   56 45                 101
738614 738614 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 KG 04 2015   grade_4 36 3 56 1   3     2   1   54 48                       102 36 3 56 1   3     2   1   54 48                 102
739202 739202 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2015   grade_1 72 0 5 0   14     2   4   43 54                       97 72 0 5 0   14     2   4   43 54                 97
739372 739372 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2015   grade_6 204 4 16 1   3     2   5   113 122                       235 204 4 16 1   3     2   5   113 122                 235
739375 739375 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No 3 09 12 2015   grade_9 211 3 24 1   1     2   4   123 123                       246 211 3 24 1   1     2   4   123 123                 246
739596 739596 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden Early Learning Center   Regular School No 1 PK PK 2015   pre_kindergarten 138 57 18 0   93     2   9   175 142                       317 138 57 18 0   93     2   9   175 142                 317
739608 739608 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_11 128 110 83 2   115     2   12   223 229                       452 128 110 83 2   115     2   12   223 229                 452
739609 739609 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_12 148 95 97 2   114     2   16   246 228                       474 148 95 97 2   114     2   16   246 228                 474
740028 740028 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No 1 PK 04 2015   grade_3 64 0 2 0   1     2   2   36 35                       71 64 0 2 0   1     2   2   36 35                 71
740030 740030 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_5 96 1 1 0   0     2   3   50 53                       103 96 1 1 0   0     2   3   50 53                 103
740266 740266 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_6 128 48 95 2   4     2   24   159 144                       303 128 48 95 2   4     2   24   159 144                 303
740267 740267 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_7 117 56 95 3   2     2   17   158 134                       292 117 56 95 3   2     2   17   158 134                 292
740269 740269 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_6 191 27 96 4   2     2   10   183 149                       332 191 27 96 4   2     2   10   183 149                 332
740270 740270 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_7 212 29 97 1   1     2   16   183 175                       358 212 29 97 1   1     2   16   183 175                 358
740273 740273 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_7 123 31 93 1   2     2   10   136 126                       262 123 31 93 1   2     2   10   136 126                 262
740409 740409 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_9 368 25 44 0   81     2   19   275 264                       539 368 25 44 0   81     2   19   275 264                 539
740455 740455 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_11 74 7 6 1   0     2   10   41 59                       100 74 7 6 1   0     2   10   41 59                 100
740456 740456 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_12 83 2 4 0   0     2   7   48 50                       98 83 2 4 0   0     2   7   48 50                 98
740526 740526 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2015   grade_11 286 7 19 0   23     2   3   173 167                       340 286 7 19 0   23     2   3   173 167                 340
740547 740547 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No 1 KG 05 2015   grade_2 105 1 2 0   7     2   3   55 65                       120 105 1 2 0   7     2   3   55 65                 120
740598 740598 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2015   grade_7 170 2 7 1   22     2   4   119 89                       208 170 2 7 1   22     2   4   119 89                 208
740651 740651 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2015   grade_9 206 1 7 0   9     2   1   103 123                       226 206 1 7 0   9     2   1   103 123                 226
740670 740670 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No 3 09 12 2015   grade_10 192 3 0 0   1     2   2   98 102                       200 192 3 0 0   1     2   2   98 102                 200
740726 740726 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No 3 09 12 2015   grade_11 196 36 13 0   15     2   1   146 117                       263 196 36 13 0   15     2   1   146 117                 263
740735 740735 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_5 17 4 5 0   0     2   2   20 10                       30 17 4 5 0   0     2   2   20 10                 30
740752 740752 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No 1 KG 05 2015   grade_5 37 1 2 0   0     2   0   22 20                       42 37 1 2 0   0     2   0   22 20                 42
740878 740878 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2015   grade_9 267 2 1 0   3     2   2   149 128                       277 267 2 1 0   3     2   2   149 128                 277

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