enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by native_hawaiian_pacific_islander 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
2045202 2045202 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2019   grade_4 27 12 15 0   47     5   2   48 60                       108.0 27 12 15 0   47     5   2   48 60                 108
2040126 2040126 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_12 269 26 36 2   12     4   13   174 188                       362.0 269 26 36 2   12     4   13   174 188                 362
2040164 2040164 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_2 71 2 5 0   0     4   2   47 37                       84.0 71 2 5 0   0     4   2   47 37                 84
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
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
2042657 2042657 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_8 37 1 3 0   0     4   1   24 22                       46.0 37 1 3 0   0     4   1   24 22                 46
2044848 2044848 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2019   pre_kindergarten 73 8 5 0   15     4   0   63 42                       105.0 73 8 5 0   15     4   0   63 42                 105
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
2046378 2046378 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_12 284 69 46 0   16     4   18   231 206                       437.0 284 69 46 0   16     4   18   231 206                 437
2040124 2040124 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_10 254 31 58 1   3     3   12   189 173                       362.0 254 31 58 1   3     3   12   189 173                 362
2042478 2042478 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_2 55 0 4 1   2     3   2   35 32                       67.0 55 0 4 1   2     3   2   35 32                 67
2042511 2042511 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_11 383 6 11 0   20     3   14   215 222                       437.0 383 6 11 0   20     3   14   215 222                 437
2042656 2042656 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_7 33 0 3 0   3     3   3   25 20                       45.0 33 0 3 0   3     3   3   25 20                 45
2043797 2043797 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 91 12 42 0   20     3   7   95 80                       175.0 91 12 42 0   20     3   7   95 80                 175
2044661 2044661 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No High 09 12 2019   grade_12 320 11 36 1   21     3   5   189 207                       397.0 320 11 36 1   21     3   5   189 207                 397
2044843 2044843 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No Elementary 01 05 2019   grade_1 21 5 7 0   18     3   1   24 31                       55.0 21 5 7 0   18     3   1   24 31                 55
2044849 2044849 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2019   kindergarten 167 27 23 1   39     3   4   146 118                       264.0 167 27 23 1   39     3   4   146 118                 264
2048494 2048494 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2019   grade_4 41 0 0 0   0     3   1   23 22                       45.0 41 0 0 0   0     3   1   23 22                 45
2039960 2039960 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_3 52 0 1 0   15     2   5   37 38                       75.0 52 0 1 0   15     2   5   37 38                 75
2040001 2040001 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2019   grade_7 329 10 29 0   52     2   19   205 236                       441.0 329 10 29 0   52     2   19   205 236                 441
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
2040120 2040120 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2019   grade_6 288 31 56 0   10     2   12   201 198                       399.0 288 31 56 0   10     2   12   201 198                 399
2040159 2040159 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2019   grade_1 67 2 6 0   2     2   2   39 42                       81.0 67 2 6 0   2     2   2   39 42                 81
2040163 2040163 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_1 71 1 4 0   1     2   3   46 36                       82.0 71 1 4 0   1     2   3   46 36                 82
2040259 2040259 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2019   grade_12 220 15 28 0   8     2   5   129 148                       278.0 220 15 28 0   8     2   5   129 148                 278
2040301 2040301 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 06 08 2019   grade_7 129 7 15 0   10     2   4   91 76                       167.0 129 7 15 0   10     2   4   91 76                 167
2040428 2040428 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_6 2 55 30 0   3     2   2   48 46                       94.0 2 55 30 0   3     2   2   48 46                 94
2040429 2040429 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_7 0 36 19 0   0     2   1   26 32                       58.0 0 36 19 0   0     2   1   26 32                 58
2040607 2040607 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2019   grade_8 4 35 15 0   2     2   3   32 29                       61.0 4 35 15 0   2     2   3   32 29                 61
2040700 2040700 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_2 0 47 37 1   2     2   3   45 47                       92.0 0 47 37 1   2     2   3   45 47                 92
2040839 2040839 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   kindergarten 2 35 21 1   2     2   2   31 34                       65.0 2 35 21 1   2     2   2   31 34                 65
2040845 2040845 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_6 1 27 12 0   1     2   1   28 16                       44.0 1 27 12 0   1     2   1   28 16                 44
2040966 2040966 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2019   grade_10 1 67 21 0   0     2   2   52 41                       93.0 1 67 21 0   0     2   2   52 41                 93
2041025 2041025 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_8 191 29 54 0   113     2   18   190 217                       407.0 191 29 54 0   113     2   18   190 217                 407
2041027 2041027 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_10 198 30 48 1   138     2   14   197 234                       431.0 198 30 48 1   138     2   14   197 234                 431
2041084 2041084 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No High 09 12 2019   grade_12 4 31 53 0   6     2   2   35 63                       98.0 4 31 53 0   6     2   2   35 63                 98
2041189 2041189 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2019   grade_9 294 13 19 0   79     2   7   205 209                       414.0 294 13 19 0   79     2   7   205 209                 414
2041245 2041245 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_4 11 76 15 0   1     2   6   51 60                       111.0 11 76 15 0   1     2   6   51 60                 111
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
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
2041571 2041571 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2019   grade_4 44 6 9 0   15     2   4   40 40                       80.0 44 6 9 0   15     2   4   40 40                 80
2041572 2041572 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2019   grade_5 65 8 3 0   12     2   5   42 53                       95.0 65 8 3 0   12     2   5   42 53                 95
2042162 2042162 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2019   grade_11 128 97 265 2   23     2   5   270 252                       522.0 128 97 265 2   23     2   5   270 252                 522
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
2042476 2042476 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   kindergarten 45 1 1 0   1     2   0   25 25                       50.0 45 1 1 0   1     2   0   25 25                 50
2042509 2042509 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_9 383 6 15 0   33     2   6   221 224                       445.0 383 6 15 0   33     2   6   221 224                 445
2042512 2042512 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_12 366 10 11 1   26     2   8   208 215                       424.0 366 10 11 1   26     2   8   208 215                 424
2042581 2042581 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2019   grade_9 193 5 32 0   2     2   4   131 107                       238.0 193 5 32 0   2     2   4   131 107                 238
2042602 2042602 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2019   grade_7 189 4 16 2   30     2   6   128 121                       249.0 189 4 16 2   30     2   6   128 121                 249
2042749 2042749 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Moody   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 106 21 64 3   4     2   0   126 74                       200.0 106 21 64 3   4     2   0   126 74                 200
2043239 2043239 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2019   grade_11 73 8 43 0   1     2   7   90 44                       134.0 73 8 43 0   1     2   7   90 44                 134
2043335 2043335 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No Elementary KG 05 2019   grade_5 64 0 4 0   21     2   3   41 53                       94.0 64 0 4 0   21     2   3   41 53                 94
2043535 2043535 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2019   grade_9 106 3 11 1   2     2   1   63 63                       126.0 106 3 11 1   2     2   1   63 63                 126
2044159 2044159 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2019   grade_9 185 40 17 2   15     2   10   134 137                       271.0 185 40 17 2   15     2   10   134 137                 271
2044171 2044171 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2019   grade_7 54 1 6 0   2     2   3   33 35                       68.0 54 1 6 0   2     2   3   33 35                 68
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
2044413 2044413 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_12 133 75 215 2   8     2   18   241 212                       453.0 133 75 215 2   8     2   18   241 212                 453
2044477 2044477 MA Middlesex   school 2508610 207   Newton 250861001366 2070055 Franklin   Regular School No Elementary KG 05 2019   grade_4 64 3 4 0   7     2   6   40 46                       86.0 64 3 4 0   7     2   6   40 46                 86
2044693 2044693 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2019   grade_6 328 8 20 1   17     2   15   170 221                       391.0 328 8 20 1   17     2   15   170 221                 391
2044725 2044725 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2019   grade_7 147 8 12 0   21     2   11   93 108                       201.0 147 8 12 0   21     2   11   93 108                 201
2044726 2044726 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2019   grade_8 154 5 13 1   13     2   9   107 90                       197.0 154 5 13 1   13     2   9   107 90                 197
2044823 2044823 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2019   grade_1 31 7 22 0   5     2   2   38 31                       69.0 31 7 22 0   5     2   2   38 31                 69
2044896 2044896 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2019   grade_9 78 4 10 0   1     2   4   44 55                       99.0 78 4 10 0   1     2   4   44 55                 99
2045188 2045188 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2019   grade_1 31 12 10 1   44     2   5   46 59                       105.0 31 12 10 1   44     2   5   46 59                 105
2045205 2045205 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Merrymount   Regular School No Elementary KG 05 2019   grade_2 31 6 1 1   16     2   0   33 24                       57.0 31 6 1 1   16     2   0   33 24                 57
2045241 2045241 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2019   grade_7 73 7 4 0   92     2   9   100 87                       187.0 73 7 4 0   92     2   9   100 87                 187
2045246 2045246 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_6 92 5 6 0   83     2   9   94 103                       197.0 92 5 6 0   83     2   9   94 103                 197
2045260 2045260 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2019   grade_11 208 48 27 0   91     2   13   191 198                       389.0 208 48 27 0   91     2   13   191 198                 389
2045261 2045261 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2019   grade_12 222 25 34 1   74     2   10   209 158                       368.0 222 25 34 1   74     2   10   209 158                 368
2045267 2045267 MA Norfolk   school 2509930 244   Randolph 250993001592 2440015 Margaret L Donovan   Regular School No Elementary KG 05 2019   kindergarten 12 42 8 1   15     2   2   43 39                       82.0 12 42 8 1   15     2   2   43 39                 82
2045295 2045295 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2019   grade_9 16 108 31 0   29     2   11   116 81                       197.0 16 108 31 0   29     2   11   116 81                 197
2045517 2045517 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2019   grade_3 186 3 7 0   5     2   0   100 103                       203.0 186 3 7 0   5     2   0   100 103                 203
2046217 2046217 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2019   grade_7 166 71 34 1   25     2   13   184 128                       312.0 166 71 34 1   25     2   13   184 128                 312
2046377 2046377 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_11 311 90 63 0   8     2   15   224 264                       489.0 311 90 63 0   8     2   15   224 264                 489
2046459 2046459 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Early Childhood Center at the Doyle School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 109 3 15 0   8     2   5   85 57                       142.0 109 3 15 0   8     2   5   85 57                 142
2046582 2046582 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No High 09 12 2019   grade_12 152 49 148 1   20     2   13   188 197                       385.0 152 49 148 1   20     2   13   188 197                 385
2047124 2047124 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No High 09 12 2019   grade_9 247 1 13 1   64     2   16   169 175                       344.0 247 1 13 1   64     2   16   169 175                 344
2047183 2047183 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No Elementary KG 05 2019   grade_3 22 5 10 0   10     2   1   29 21                       50.0 22 5 10 0   10     2   1   29 21                 50
2047528 2047528 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_8 29 14 123 4   3     2   0   81 94                       175.0 29 14 123 4   3     2   0   81 94                 175
2047536 2047536 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2019   grade_9 6 33 41 1   2     2   1   47 39                       86.0 6 33 41 1   2     2   1   47 39                 86
2047621 2047621 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   kindergarten 10 14 93 0   2     2   1   52 70                       122.0 10 14 93 0   2     2   1   52 70                 122
2047684 2047684 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_12 0 30 8 0   0     2   0   20 20                       40.0 0 30 8 0   0     2   0   20 20                 40
2048182 2048182 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2019   grade_7 92 3 13 2   8     2   5   66 59                       125.0 92 3 13 2   8     2   5   66 59                 125
2048199 2048199 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2019   grade_10 102 4 10 0   3     2   6   66 61                       127.0 102 4 10 0   3     2   6   66 61                 127
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
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
2048521 2048521 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2019   kindergarten 118 3 14 0   4     2   6   75 72                       147.0 118 3 14 0   4     2   6   75 72                 147
2048581 2048581 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2019   grade_9 99 10 30 5   2     2   5   97 56                       153.0 99 10 30 5   2     2   5   97 56                 153
2048737 2048737 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2019   grade_9 241 6 9 0   4     2   4   120 146                       266.0 241 6 9 0   4     2   4   120 146                 266
2048750 2048750 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2019   grade_9 261 3 12 1   42     2   13   156 178                       334.0 261 3 12 1   42     2   13   156 178                 334
2049143 2049143 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2019   grade_11 250 6 12 0   7     2   4   133 148                       281.0 250 6 12 0   7     2   4   133 148                 281
2049241 2049241 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 238 3 17 1   4     2   10   174 101                       275.0 238 3 17 1   4     2   10   174 101                 275
2049354 2049354 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_5 26 7 7 0   2     2   6   29 21                       50.0 26 7 7 0   2     2   6   29 21                 50
2049372 2049372 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_10 235 18 38 1   9     2   17   124 196                       320.0 235 18 38 1   9     2   17   124 196                 320
2042463 2042463 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 83 1 4 1   2     11   5   61 46                       107.0 83 1 4 1   2     11   5   61 46                 107
2039811 2039811 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_3 108 5 8 0   5     1   2   55 74                       129.0 108 5 8 0   5     1   2   55 74                 129
2039823 2039823 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_12 90 4 9 0   3     1   0   48 59                       107.0 90 4 9 0   3     1   0   48 59                 107
2039838 2039838 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_2 60 2 3 0   0     1   1   30 37                       67.0 60 2 3 0   0     1   1   30 37                 67
2039866 2039866 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   kindergarten 47 0 3 0   0     1   2   25 28                       53.0 47 0 3 0   0     1   2   25 28                 53
2039878 2039878 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_6 132 3 9 0   2     1   4   71 80                       151.0 132 3 9 0   2     1   4   71 80                 151

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