enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
2235135 2235135 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy: Clifford H Marshall Elementary   Regular School No Elementary KG 04 2018   grade_3 32 14 15 0   48     7   2   54 64                       118.0 32 14 15 0   48     7   2   54 64                 118
2229182 2229182 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham: Stall Brook   Regular School No Elementary KG 03 2018   grade_1 68 2 4 0   0     5   2   43 38                       81.0 68 2 4 0   0     5   2   43 38                 81
2232113 2232113 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley: Hopkins Academy   Regular School No High 07 12 2018   grade_7 39 0 3 0   0     5   1   24 24                       48.0 39 0 3 0   0     5   1   24 24                 48
2234723 2234723 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 Norwood: George F. Willett   Regular School No Elementary PK KG 2018   kindergarten 168 24 35 0   42     5   6   140 140                       280.0 168 24 35 0   42     5   6   140 140                 280
2229134 2229134 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_11 277 32 39 4   12     4   15   187 196                       383.0 277 32 39 4   12     4   15   187 196                 383
2236521 2236521 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_11 313 68 57 0   15     4   24   255 225                       481.0 313 68 57 0   15     4   24   255 225                 481
2229126 2229126 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable: Barnstable United Elementary School   Regular School No Elementary 04 05 2018   grade_5 324 29 53 0   11     3   13   216 217                       433.0 324 29 53 0   11     3   13   216 217                 433
2230513 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
2231866 2231866 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin: Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 84 3 8 1   1     3   4   63 41                       104.0 84 3 8 1   1     3   4   63 41                 104
2231883 2231883 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   grade_1 50 0 4 1   2     3   2   31 31                       62.0 50 0 4 1   2     3   2   31 31                 62
2232012 2232012 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester: Gloucester High   Regular School No High 09 12 2018   grade_12 179 5 18 0   6     3   2   109 104                       213.0 179 5 18 0   6     3   2   109 104                 213
2232111 2232111 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_6 40 1 3 0   1     3   3   27 24                       51.0 40 1 3 0   1     3   3   27 24                 51
2233163 2233163 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg: Lunenburg Middle School   Regular School No Middle 06 08 2018   grade_8 122 4 13 2   2     3   1   80 67                       147.0 122 4 13 2   2     3   1   80 67                 147
2233909 2233909 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton: Milton High   Regular School No High 09 12 2018   grade_12 166 58 8 0   21     3   9   135 130                       265.0 166 58 8 0   21     3   9   135 130                 265
2234498 2234498 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover: North Andover High   Regular School No High 09 12 2018   grade_11 318 12 35 1   21     3   5   190 205                       395.0 318 12 35 1   21     3   5   190 205                 395
2234577 2234577 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_8 180 3 5 1   22     3   7   117 104                       221.0 180 3 5 1   22     3   7   117 104                 221
2236312 2236312 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 Stoughton: South Elementary   Regular School No Elementary KG 05 2018   grade_5 30 8 2 0   2     3   2   21 26                       47.0 30 8 2 0   2     3   2   21 26                 47
2239041 2239041 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Hamilton-Wenham: Cutler School   Regular School No Elementary KG 05 2018   grade_3 40 0 0 0   0     3   1   22 22                       44.0 40 0 0 0   0     3   1   22 22                 44
2228932 2228932 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   grade_2 49 0 0 0   15     2   4   32 38                       70.0 49 0 0 0   15     2   4   32 38                 70
2229056 2229056 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_9 309 27 66 1   25     2   26   242 214                       456.0 309 27 66 1   25     2   26   242 214                 456
2229059 2229059 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_12 289 23 40 2   16     2   18   199 191                       390.0 289 23 40 2   16     2   18   199 191                 390
2229135 2229135 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_12 250 29 36 3   13     2   12   169 176                       345.0 250 29 36 3   13     2   12   169 176                 345
2229176 2229176 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham: South Elementary   Regular School No Elementary KG 03 2018   kindergarten 60 3 6 0   1     2   3   36 39                       75.0 60 3 6 0   1     2   3   36 39                 75
2229181 2229181 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham: Stall Brook   Regular School No Elementary KG 03 2018   kindergarten 71 2 3 0   1     2   2   45 36                       81.0 71 2 3 0   1     2   2   45 36                 81
2229301 2229301 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly: Beverly High   Regular School No High 09 12 2018   grade_11 213 15 28 0   7     2   7   126 146                       272.0 213 15 28 0   7     2   7   126 146                 272
2229350 2229350 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica: Locke Middle   Regular School No Middle 06 08 2018   grade_6 128 6 11 0   11     2   4   87 75                       162.0 128 6 11 0   11     2   4   87 75                 162
2229358 2229358 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   grade_12 241 9 10 0   16     2   3   130 151                       281.0 241 9 10 0   16     2   3   130 151                 281
2229669 2229669 MA Suffolk   school 2502790 35   Boston 250279000270 350180 Boston: John Winthrop   Regular School No Elementary PK 05 2018   grade_5 0 27 12 0   3     2   1   19 26                       45.0 0 27 12 0   3     2   1   19 26                 45
2229698 2229698 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston: Joseph Lee   Regular School No Elementary PK 08 2018   grade_7 2 35 22 0   2     2   5   38 30                       68.0 2 35 22 0   2     2   5   38 30                 68
2229963 2229963 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_5 2 37 20 0   1     2   3   41 24                       65.0 2 37 20 0   1     2   3   41 24                 65
2230165 2230165 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_7 194 29 58 0   115     2   19   189 228                       417.0 194 29 58 0   115     2   19   189 228                 417
2230167 2230167 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_9 201 32 50 2   140     2   16   205 238                       443.0 201 32 50 2   140     2   16   205 238                 443
2230182 2230182 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_9 39 141 148 1   60     2   6   178 219                       397.0 39 141 148 1   60     2   6   178 219                 397
2230248 2230248 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Boston: Snowden International School at Copley   Regular School No High 09 12 2018   grade_11 5 37 64 0   6     2   1   46 69                       115.0 5 37 64 0   6     2   1   46 69                 115
2230435 2230435 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_3 16 74 18 1   1     2   6   54 64                       118.0 16 74 18 1   1     2   6   54 64                 118
2230495 2230495 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton: North Middle School   Regular School No Middle 06 08 2018   grade_8 20 164 23 0   3     2   4   111 105                       216.0 20 164 23 0   3     2   4   111 105                 216
2230514 2230514 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_10 167 642 144 6   27     2   34   556 466                       1022.0 167 642 144 6   27     2   34   556 466                 1022
2230516 2230516 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_12 150 635 102 4   30     2   27   476 474                       950.0 150 635 102 4   30     2   27   476 474                 950
2230785 2230785 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge: Cambridge Rindge and Latin   Regular School No High 09 12 2018   grade_9 183 140 71 2   50     2   36   253 231                       484.0 183 140 71 2   50     2   36   253 231                 484
2230809 2230809 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Canton: Dean S Luce   Regular School No Elementary KG 05 2018   grade_3 45 5 9 0   14     2   3   42 36                       78.0 45 5 9 0   14     2   3   42 36                 78
2230810 2230810 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Canton: Dean S Luce   Regular School No Elementary KG 05 2018   grade_4 65 6 3 0   10     2   4   43 47                       90.0 65 6 3 0   10     2   4   43 47                 90
2231502 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
2231633 2231633 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River: B M C Durfee High   Regular School No High 09 12 2018   grade_11 275 39 115 1   26     2   26   250 234                       484.0 275 39 115 1   26     2   26   250 234                 484
2231868 2231868 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin: Jefferson Elementary   Regular School No Elementary KG 05 2018   kindergarten 47 2 2 0   6     2   0   37 22                       59.0 47 2 2 0   6     2   0   37 22                 59
2231912 2231912 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin: Annie Sullivan Middle School   Regular School No Middle 06 08 2018   grade_8 144 0 4 0   6     2   1   82 75                       157.0 144 0 4 0   6     2   1   82 75                 157
2231923 2231923 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_10 385 7 9 0   20     2   14   214 223                       437.0 385 7 9 0   20     2   14   214 223                 437
2231924 2231924 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_11 368 9 8 1   27     2   8   203 220                       423.0 368 9 8 1   27     2   8   203 220                 423
2232006 2232006 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_7 169 5 14 1   4     2   18   123 90                       213.0 169 5 14 1   4     2   18   123 90                 213
2232041 2232041 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 89 1 6 2   7     2   3   63 47                       110.0 89 1 6 2   7     2   3   63 47                 110
2232815 2232815 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Leominster: Center For Technical Education Innovation   Career and Technical School No High 09 12 2018   grade_10 83 10 48 0   2     2   7   98 54                       152.0 83 10 48 0   2     2   7   98 54                 152
2232930 2232930 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Longmeadow: Blueberry Hill   Regular School No Elementary KG 05 2018   grade_4 66 0 4 0   21     2   3   42 54                       96.0 66 0 4 0   21     2   3   42 54                 96
2233476 2233476 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Marlborough: Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 104 6 26 0   30     2   6   108 66                       174.0 104 6 26 0   30     2   6   108 66                 174
2233903 2233903 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Milton: Charles S Pierce Middle   Regular School No Middle 06 08 2018   grade_8 198 41 16 2   16     2   11   141 145                       286.0 198 41 16 2   16     2   11   141 145                 286
2233919 2233919 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Monson: Granite Valley Middle   Regular School No Middle 05 08 2018   grade_6 53 1 5 0   2     2   2   31 34                       65.0 53 1 5 0   2     2   2   31 34                 65
2233921 2233921 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Monson: Granite Valley Middle   Regular School No Middle 05 08 2018   grade_8 91 1 1 0   0     2   3   54 44                       98.0 91 1 1 0   0     2   3   54 44                 98
2234203 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
2234205 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
2234304 2234304 MA Middlesex   school 2508610 207   Newton 250861001377 2070100 Newton: Peirce   Regular School No Elementary KG 05 2018   grade_1 19 2 6 0   7     2   8   25 19                       44.0 19 2 6 0   7     2   8   25 19                 44
2234366 2234366 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton: Newton North High   Regular School No High 09 12 2018   grade_12 364 29 50 0   87     2   20   282 270                       552.0 364 29 50 0   87     2   20   282 270                 552
2234499 2234499 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover: North Andover High   Regular School No High 09 12 2018   grade_12 300 13 27 2   28     2   5   182 195                       377.0 300 13 27 2   28     2   5   182 195                 377
2234575 2234575 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_6 145 7 14 0   21     2   11   96 104                       200.0 145 7 14 0   21     2   11   96 104                 200
2234576 2234576 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_7 156 4 16 2   15     2   10   112 93                       205.0 156 4 16 2   15     2   10   112 93                 205
2234642 2234642 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading: North Reading High   Regular School No High 09 12 2018   grade_12 198 1 6 0   9     2   1   98 119                       217.0 198 1 6 0   9     2   1   98 119                 217
2234744 2234744 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs: Oak Bluffs Elementary   Regular School No Elementary PK 08 2018   grade_8 14 6 8 0   0     2   0   21 9                       30.0 14 6 8 0   0     2   0   21 9                 30
2234781 2234781 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford: Oxford High   Regular School No High 08 12 2018   grade_8 111 4 12 1   1     2   6   61 76                       137.0 111 4 12 1   1     2   6   61 76                 137
2234911 2234911 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke: Pembroke High School   Regular School No High 09 12 2018   grade_12 259 1 1 0   3     2   2   139 128                       268.0 259 1 1 0   3     2   2   139 128                 268
2235119 2235119 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy: Lincoln-Hancock Community School   Regular School No Elementary KG 04 2018   kindergarten 38 21 9 0   50     2   8   53 75                       128.0 38 21 9 0   50     2   8   53 75                 128
2235136 2235136 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy: Clifford H Marshall Elementary   Regular School No Elementary KG 04 2018   grade_4 38 10 6 0   53     2   6   67 48                       115.0 38 10 6 0   53     2   6   67 48                 115
2235139 2235139 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Quincy: Merrymount   Regular School No Elementary KG 05 2018   grade_1 32 2 2 1   14     2   0   32 21                       53.0 32 2 2 1   14     2   0   32 21                 53
2235204 2235204 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy: Quincy High   Regular School No High 09 12 2018   grade_10 210 47 22 0   93     2   10   195 189                       384.0 210 47 22 0   93     2   10   195 189                 384
2235205 2235205 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy: Quincy High   Regular School No High 09 12 2018   grade_11 234 31 38 2   72     2   13   222 169                       392.0 234 31 38 2   72     2   13   222 169                 392
2235206 2235206 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy: Quincy High   Regular School No High 09 12 2018   grade_12 207 38 25 2   80     2   13   189 178                       367.0 207 38 25 2   80     2   13   189 178                 367
2235221 2235221 MA Norfolk   school 2509930 244   Randolph 250993002596 2440018 Randolph: J F Kennedy Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 8 37 8 2   8     2   5   42 28                       70.0 8 37 8 2   8     2   5   42 28                 70
2236329 2236329 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton: O'Donnell Middle School   Regular School No Middle 06 08 2018   grade_6 174 72 33 1   28     2   12   188 134                       322.0 174 72 33 1   28     2   12   188 134                 322
2236359 2236359 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Sudbury: Israel Loring School   Regular School No Elementary KG 05 2018   grade_5 60 2 4 0   7     2   3   41 37                       78.0 60 2 4 0   7     2   3   41 37                 78
2236515 2236515 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton: Benjamin Friedman Middle   Regular School No Middle 05 07 2018   grade_6 191 22 24 0   3     2   14   127 129                       256.0 191 22 24 0   3     2   14   127 129                 256
2236520 2236520 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_10 308 93 62 0   8     2   19   232 260                       492.0 308 93 62 0   8     2   19   232 260                 492
2236629 2236629 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Wakefield: Woodville School   Regular School No Elementary KG 04 2018   kindergarten 101 3 5 1   7     2   6   59 66                       125.0 101 3 5 1   7     2   6   59 66                 125
2236765 2236765 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham: Waltham Sr High   Regular School No High 09 12 2018   grade_11 149 48 153 1   21     2   12   192 194                       386.0 149 48 153 1   21     2   12   192 194                 386
2236780 2236780 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware: Ware Junior/Senior High School   Regular School No High 07 12 2018   grade_9 64 2 9 0   0     2   2   42 37                       79.0 64 2 9 0   0     2   2   42 37                 79
2236881 2236881 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster: Webster Middle School   Regular School No Middle 05 08 2018   grade_8 91 12 36 0   3     2   10   70 84                       154.0 91 12 36 0   3     2   10   70 84                 154
2237541 2237541 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Woburn: Mary D Altavesta   Regular School No Elementary KG 05 2018   grade_2 22 4 10 0   12     2   1   27 24                       51.0 22 4 10 0   12     2   1   27 24                 51
2237799 2237799 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester: Tatnuck   Regular School No Elementary PK 06 2018   kindergarten 28 8 20 0   3     2   1   35 27                       62.0 28 8 20 0   3     2   1   35 27                 62
2237938 2237938 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_7 26 13 122 5   3     2   0   80 91                       171.0 26 13 122 5   3     2   0   80 91                 171
2238107 2238107 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_11 0 33 8 0   0     2   0   22 21                       43.0 0 33 8 0   0     2   0   22 21                 43
2238358 2238358 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District): UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2018   grade_8 8 71 56 1   8     2   7   84 69                       153.0 8 71 56 1   8     2   7   84 69                 153
2238670 2238670 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley School District: Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2018   grade_6 98 2 12 1   8     2   4   71 56                       127.0 98 2 12 1   8     2   4   71 56                 127
2238691 2238691 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Berkshire Hills: Monument Mt Regional High   Regular School No High 09 12 2018   grade_9 103 4 10 0   3     2   6   69 59                       128.0 103 4 10 0   3     2   6   69 59                 128
2238743 2238743 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham: Williams Intermediate School   Regular School No Middle 04 06 2018   grade_5 258 15 0 1   3     2   21   148 152                       300.0 258 15 0 1   3     2   21   148 152                 300
2238760 2238760 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham: Bridgewater-Raynham Regional   Regular School No High 09 12 2018   grade_11 362 14 1 0   7     2   18   203 201                       404.0 362 14 1 0   7     2   18   203 201                 404
2239071 2239071 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Hampden-Wilbraham: Mile Tree Elementary   Regular School No Elementary PK 01 2018   pre_kindergarten 49 1 6 0   1     2   0   33 26                       59.0 49 1 6 0   1     2   0   33 26                 59
2239091 2239091 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Hampden-Wilbraham: Minnechaug Regional High   Regular School No High 09 12 2018   grade_12 241 8 17 1   4     2   3   130 146                       276.0 241 8 17 1   4     2   3   130 146                 276
2239301 2239301 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Nashoba: Luther Burbank Middle School   Regular School No Middle 06 08 2018   grade_8 69 3 3 0   0     2   5   38 44                       82.0 69 3 3 0   0     2   5   38 44                 82
2239322 2239322 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Northboro-Southboro: Algonquin Regional High   Regular School No High 09 12 2018   grade_10 272 5 25 1   37     2   11   182 171                       353.0 272 5 25 1   37     2   11   182 171                 353
2239512 2239512 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake: Silver Lake Regional High   Regular School No High 09 12 2018   grade_12 311 3 4 0   4     2   1   160 165                       325.0 311 3 4 0   4     2   1   160 165                 325
2239711 2239711 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett: Central Tree Middle   Regular School No Middle 06 08 2018   grade_6 105 3 5 0   3     2   3   51 70                       121.0 105 3 5 0   3     2   3   51 70                 121
2239723 2239723 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett: Wachusett Regional High   Regular School No High 09 12 2018   grade_12 434 12 18 0   20     2   7   222 271                       493.0 434 12 18 0   20     2   7   222 271                 493
2239783 2239783 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman-Hanson: Whitman Hanson Regional   Regular School No High 09 12 2018   grade_10 249 7 9 0   7     2   4   136 142                       278.0 249 7 9 0   7     2   4   136 142                 278
2240014 2240014 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District: Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_4 26 6 8 0   0     2   6   28 20                       48.0 26 6 8 0   0     2   6   28 20                 48
2240033 2240033 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District: TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_9 207 16 40 2   9     2   20   133 163                       296.0 207 16 40 2   9     2   20   133 163                 296

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