Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by native_hawaiian_pacific_islander descending

View and edit SQL

year

  • 2021 · 9,536
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
1676885 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_5 41 0 6 0   4     8   3   36 26 *                     62.0 41 0 6 0   4     8   3   36 26                 62
1676882 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_2 21 1 5 0   5     7   4   24 19 *                     43.0 21 1 5 0   5     7   4   24 19                 43
1678402 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton - O'Donnell Middle School   Regular School No Middle 06 08 2021   grade_8 148 66 39 0   9     6   22   136 154 *                     290.0 148 66 39 0   9     6   22   136 154                 290
1676880 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   kindergarten 25 1 1 1   2     5   2   17 20 *                     37.0 25 1 1 1   2     5   2   17 20                 37
1676881 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_1 26 0 5 0   1     5   4   22 19 *                     41.0 26 0 5 0   1     5   4   22 19                 41
1677429 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy - Point Webster Middle   Regular School No Middle 05 08 2021   grade_6 17 13 21 0   40     5   4   46 54 *                     100.0 17 13 21 0   40     5   4   46 54                 100
1673477 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_12 166 561 110 4   19     4   31   471 424 *                     895.0 166 561 110 4   19     4   31   471 424                 895
1674835 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley - Hopkins Academy   Regular School No High 07 12 2021   grade_10 30 1 3 0   0     4   0   18 20 *                     38.0 30 1 3 0   0     4   0   18 20                 38
1676884 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_4 42 1 5 0   4     4   1   30 27 *                     57.0 42 1 5 0   4     4   1   30 27                 57
1677019 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Norwood - Charles J Prescott   Regular School No Elementary KG 05 2021   grade_3 21 4 7 0   14     4   1   23 28 *                     51.0 21 4 7 0   14     4   1   23 28                 51
1677023 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 Norwood - George F. Willett   Regular School No Elementary PK KG 2021   pre_kindergarten 52 7 10 0   10     4   0   44 39 *                     83.0 52 7 10 0   10     4   0   44 39                 83
1681344 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Regional Vocational Technical - Franklin County Technical   Career and Technical School No High 09 12 2021   grade_9 152 1 11 1   0     4   2   89 82 *                     171.0 152 1 11 1   0     4   2   89 82                 171
1673712 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_10 179 128 79 0   45     3   44   226 252 *                     478.0 179 128 79 0   45     3   44   226 252                 478
1673735 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton - Wm H Galvin Middle   Regular School No Middle 06 08 2021   grade_6 146 26 16 0   34     3   17   117 125 *                     242.0 146 26 16 0   34     3   17   117 125                 242
1674639 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   kindergarten 44 0 1 0   4     3   0   30 22 *                     52.0 44 0 1 0   4     3   0   30 22                 52
1674643 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   grade_4 50 0 4 1   1     3   2   30 31 *                     61.0 50 0 4 1   1     3   2   30 31                 61
1674744 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester - Gloucester High   Regular School No High 09 12 2021   grade_9 210 3 26 0   5     3   11   146 112 *                     258.0 210 3 26 0   5     3   11   146 112                 258
1674834 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley - Hopkins Academy   Regular School No High 07 12 2021   grade_9 36 1 5 0   2     3   3   27 23 *                     50.0 36 1 5 0   2     3   3   27 23                 50
1675459 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Lincoln - Hanscom Primary   Regular School No Elementary PK 03 2021   grade_1 32 2 19 0   1     3   11   34 34 *                     68.0 32 2 19 0   1     3   11   34 34                 68
1676014 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Marshfield - Daniel Webster   Regular School No Elementary PK 05 2021   kindergarten 39 0 1 0   0     3   1   21 23 *                     44.0 39 0 1 0   0     3   1   21 23                 44
1676900 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough - Robert E. Melican Middle School   Regular School No Middle 06 08 2021   grade_8 129 1 19 2   20     3   9   89 94 *                     183.0 129 1 19 2   20     3   9   89 94                 183
1680705 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham - Miles River Middle   Regular School No Middle 06 08 2021   grade_6 116 0 7 0   3     3   7   69 67 *                     136.0 116 0 7 0   3     3   7   69 67                 136
1672158 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_5 42 0 1 0   14     2   6   31 34 *                     65.0 42 0 1 0   14     2   6   31 34                 65
1672258 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro - Attleboro High   Regular School No High 09 12 2021   grade_12 281 25 61 0   27     2   24   215 205 *                     420.0 281 25 61 0   27     2   24   215 205                 420
1672320 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_8 265 31 62 0   11     2   18   192 197 *                     389.0 265 31 62 0   11     2   18   192 197                 389
1672324 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_12 241 30 56 2   4     2   10   180 165 *                     345.0 241 30 56 2   4     2   10   180 165                 345
1672358 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham - Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2021   grade_3 52 2 12 0   2     2   1   34 37 *                     71.0 52 2 12 0   2     2   1   34 37                 71
1672362 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham - Stall Brook   Regular School No Elementary KG 03 2021   grade_3 59 1 2 0   1     2   3   38 30 *                     68.0 59 1 2 0   1     2   3   38 30                 68
1672363 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham - Bellingham Memorial School   Regular School No Middle 04 07 2021   grade_4 139 1 10 0   4     2   1   85 72 *                     157.0 139 1 10 0   4     2   1   85 72                 157
1672399 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_7 211 13 20 1   92     2   28   189 178 *                     367.0 211 13 20 1   92     2   28   189 178                 367
1672611 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston - Dearborn   Regular School No High 06 12 2021   grade_8 2 52 29 0   2     2   2   45 44 *                     89.0 2 52 29 0   2     2   2   45 44                 89
1672887 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   kindergarten 2 24 26 0   2     2   0   29 27 *                     56.0 2 24 26 0   2     2   0   29 27                 56
1672892 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_4 0 55 35 1   2     2   2   52 45 *                     97.0 0 55 35 1   2     2   2   52 45                 97
1672922 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Boston - Dr. William Henderson Lower   Regular School No Elementary PK 01 2021   pre_kindergarten 18 22 14 0   8     2   4   38 30 *                     68.0 18 22 14 0   8     2   4   38 30                 68
1673026 MA Suffolk   school 2502790 35   Boston 250279000337 350366 Boston - William E Russell   Regular School No Elementary PK 05 2021   pre_kindergarten 3 20 22 0   4     2   1   27 25 *                     52.0 3 20 22 0   4     2   1   27 25                 52
1673035 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_2 0 24 17 0   1     2   3   22 25 *                     47.0 0 24 17 0   1     2   3   22 25                 47
1673127 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston - Clarence R Edwards Middle   Regular School No Middle 06 08 2021   grade_7 7 16 60 0   3     2   1   47 42 *                     89.0 7 16 60 0   3     2   1   47 42                 89
1673162 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston - Jeremiah E Burke High   Regular School No High 09 12 2021   grade_12 1 75 34 0   0     2   4   66 50 *                     116.0 1 75 34 0   0     2   4   66 50                 116
1673217 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_7 189 29 55 0   121     2   23   228 191 *                     419.0 189 29 55 0   121     2   23   228 191                 419
1673220 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_10 183 39 61 0   126     2   19   202 226 *                     430.0 183 39 61 0   126     2   19   202 226                 430
1673222 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_12 192 26 46 1   135     2   13   191 223 *                     415.0 192 26 46 1   135     2   13   191 223                 415
1673358 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree - Braintree High   Regular School No High 09 12 2021   grade_11 298 16 25 2   88     2   7   221 217 *                     438.0 298 16 25 2   88     2   7   221 217                 438
1673414 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_6 14 92 17 0   3     2   3   51 80 *                     131.0 14 92 17 0   3     2   3   51 80                 131
1673436 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton - Oscar F Raymond   Regular School No Elementary KG 05 2021   grade_1 8 90 11 0   0     2   2   67 46 *                     113.0 8 90 11 0   0     2   2   67 46                 113
1673468 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton - Ashfield Middle School   Regular School No Middle 06 08 2021   grade_6 31 78 16 1   3     2   6   79 58 *                     137.0 31 78 16 1   3     2   6   79 58                 137
1673470 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton - Ashfield Middle School   Regular School No Middle 06 08 2021   grade_8 62 116 24 2   8     2   4   99 119 *                     218.0 62 116 24 2   8     2   4   99 119                 218
1673474 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_9 187 617 165 1   24     2   48   589 455 *                     1044.0 187 617 165 1   24     2   48   589 455                 1044
1673475 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_10 132 759 198 3   27     2   50   651 520 *                     1171.0 132 759 198 3   27     2   50   651 520                 1171
1673476 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_11 131 580 128 3   22     2   39   450 455 *                     905.0 131 580 128 3   22     2   39   450 455                 905
1673713 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_11 186 129 65 2   46     2   46   246 230 *                     476.0 186 129 65 2   46     2   46   246 230                 476
1673714 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_12 182 128 60 2   47     2   30   225 225 *                     451.0 182 128 60 2   47     2   30   225 225                 451
1673736 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton - Wm H Galvin Middle   Regular School No Middle 06 08 2021   grade_7 197 29 8 2   27     2   18   137 146 *                     283.0 197 29 8 2   27     2   18   137 146                 283
1674641 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   grade_2 48 0 2 0   2     2   0   28 26 *                     54.0 48 0 2 0   2     2   0   28 26                 54
1674659 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin - Davis Thayer   Regular School No Elementary KG 05 2021   grade_2 38 0 2 0   2     2   0   21 23 *                     44.0 38 0 2 0   2     2   0   21 23                 44
1674669 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_6 101 1 8 0   4     2   2   54 64 *                     118.0 101 1 8 0   4     2   2   54 64                 118
1674670 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_7 111 2 4 0   8     2   4   70 61 *                     131.0 111 2 4 0   8     2   4   70 61                 131
1674674 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin - Franklin High   Regular School No High 09 12 2021   grade_11 376 6 15 0   31     2   6   219 217 *                     436.0 376 6 15 0   31     2   6   219 217                 436
1674745 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester - Gloucester High   Regular School No High 09 12 2021   grade_10 148 3 33 1   2     2   13   121 81 *                     202.0 148 3 33 1   2     2   13   121 81                 202
1674955 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill - Haverhill High   Regular School No High 09 12 2021   grade_9 274 28 202 2   6     2   5   277 242 *                     519.0 274 28 202 2   6     2   5   277 242                 519
1674956 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill - Haverhill High   Regular School No High 09 12 2021   grade_10 240 23 154 0   12     2   8   229 210 *                     439.0 240 23 154 0   12     2   8   229 210                 439
1675458 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Lincoln - Hanscom Primary   Regular School No Elementary PK 03 2021   pre_kindergarten 33 3 11 0   0     2   6   33 22 *                     55.0 33 3 11 0   0     2   6   33 22                 55
1675474 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln - Hanscom Middle   Regular School No Middle 04 08 2021   grade_6 21 5 14 0   0     2   7   21 28 *                     49.0 21 5 14 0   0     2   7   21 28                 49
1675514 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow - Williams Middle   Regular School No Middle 06 08 2021   grade_7 94 0 7 0   17     2   9   55 74 *                     129.0 94 0 7 0   17     2   9   55 74                 129
1675691 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg - Lunenburg Middle School   Regular School No Middle 06 08 2021   grade_7 120 1 9 0   4     2   5   73 68 *                     141.0 120 1 9 0   4     2   5   73 68                 141
1675695 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg - Lunenburg High   Regular School No High 09 12 2021   grade_11 99 4 15 2   2     2   1   57 68 *                     125.0 99 4 15 2   2     2   1   57 68                 125
1675889 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_4 19 16 32 0   23     2   3   45 50 *                     95.0 19 16 32 0   23     2   3   45 50                 95
1676588 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_11 216 109 298 3   7     2   36   359 311 *                     671.0 216 109 298 3   7     2   36   359 311                 671
1676589 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_12 155 109 235 4   8     2   26   274 265 *                     539.0 155 109 235 4   8     2   26   274 265                 539
1676716 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 Newton - F A Day Middle   Regular School No Middle 06 08 2021   grade_6 205 18 32 1   50     2   27   171 164 *                     335.0 205 18 32 1   50     2   27   171 164                 335
1676869 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough - North Attleborough Middle   Regular School No Middle 06 08 2021   grade_8 319 11 22 0   15     2   16   169 216 *                     385.0 319 11 22 0   15     2   16   169 216                 385
1676997 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood - Balch   Regular School No Elementary 01 05 2021   grade_2 23 5 19 0   6     2   0   28 27 *                     55.0 23 5 19 0   6     2   0   28 27                 55
1677022 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 Norwood - George F. Willett   Regular School No Elementary PK KG 2021   kindergarten 166 17 33 0   39     2   8   122 143 *                     265.0 166 17 33 0   39     2   8   122 143                 265
1677068 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford - Oxford High   Regular School No High 08 12 2021   grade_11 71 4 9 0   1     2   4   44 46 *                     91.0 71 4 9 0   1     2   4   44 46                 91
1677381 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Quincy - Merrymount   Regular School No Elementary KG 05 2021   grade_4 26 2 1 1   13     2   1   28 18 *                     46.0 26 2 1 1   13     2   1   28 18                 46
1677421 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy - Central Middle   Regular School No Middle 06 08 2021   grade_7 93 7 7 0   103     2   5   109 108 *                     217.0 93 7 7 0   103     2   5   109 108                 217
1677422 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy - Central Middle   Regular School No Middle 06 08 2021   grade_8 90 5 8 0   85     2   10   95 105 *                     200.0 90 5 8 0   85     2   10   95 105                 200
1677432 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy - Quincy High   Regular School No High 09 12 2021   grade_9 167 32 44 0   79     2   11   169 165 *                     335.0 167 32 44 0   79     2   11   169 165                 335
1677436 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy - North Quincy High   Regular School No High 09 12 2021   grade_9 145 7 12 2   167     2   18   192 161 *                     353.0 145 7 12 2   167     2   18   192 161                 353
1677696 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich - Oak Ridge   Regular School No Elementary 03 06 2021   grade_5 173 2 8 0   7     2   0   99 93 *                     192.0 173 2 8 0   7     2   0   99 93                 192
1677732 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus - Saugus Middle School   Regular School No Middle 06 08 2021   grade_8 136 8 44 1   11     2   4   112 94 *                     206.0 136 8 44 1   11     2   4   112 94                 206
1678403 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton - Stoughton High   Regular School No High 09 12 2021   grade_9 146 81 24 1   24     2   12   175 115 *                     290.0 146 81 24 1   24     2   12   175 115                 290
1678551 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_8 426 113 92 4   5     2   33   337 338 *                     675.0 426 113 92 4   5     2   33   337 338                 675
1678552 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_9 314 122 79 5   5     2   38   293 272 *                     565.0 314 122 79 5   5     2   38   293 272                 565
1678688 MA Norfolk   school 2511970 307   Walpole 251197001960 3070015 Walpole - Fisher   Regular School No Elementary KG 05 2021   grade_2 52 2 5 0   14     2   3   43 35 *                     78.0 52 2 5 0   14     2   3   43 35                 78
1679312 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester - Winchester High School   Regular School No High 09 12 2021   grade_11 235 3 13 1   67     2   16   168 169 *                     337.0 235 3 13 1   67     2   16   168 169                 337
1679375 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 94 19 10 0   13     2   6   71 73 *                     144.0 94 19 10 0   13     2   6   71 73                 144
1679721 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_10 25 14 128 3   2     2   0   81 93 *                     174.0 25 14 128 3   2     2   0   81 93                 174
1679729 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School (District) - Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2021   grade_11 5 36 38 0   1     2   2   49 35 *                     84.0 5 36 38 0   1     2   2   49 35                 84
1679797 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   kindergarten 9 77 87 0   3     2   7   88 97 *                     185.0 9 77 87 0   3     2   7   88 97                 185
1679812 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District) - KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2021   grade_2 9 14 97 0   1     2   1   54 70 *                     124.0 9 14 97 0   1     2   1   54 70                 124
1679943 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_7 47 65 5 1   13     2   12   64 81 *                     145.0 47 65 5 1   13     2   12   64 81                 145
1680052 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District) - MATCH Charter Public School   Regular School Yes Other PK 12 2021   grade_1 1 47 41 1   0     2   3   51 44 *                     95.0 1 47 41 1   0     2   3   51 44                 95
1680154 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District) - Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2021   grade_7 4 62 24 0   4     2   4   49 51 *                     100.0 4 62 24 0   4     2   4   49 51                 100
1680288 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough - Raymond J Grey Junior High   Regular School No Middle 07 08 2021   grade_8 202 14 28 2   159     2   14   212 208 *                     421.0 202 14 28 2   159     2   14   212 208                 421
1680374 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley School District - Ayer Shirley Regional High School   Regular School No High 09 12 2021   grade_9 75 2 11 1   5     2   3   54 45 *                     99.0 75 2 11 1   5     2   3   54 45                 99
1680391 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Berkshire Hills - Monument Mt Regional High   Regular School No High 09 12 2021   grade_12 98 4 9 0   3     2   6   65 57 *                     122.0 98 4 9 0   3     2   6   65 57                 122
1680437 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham - Mitchell Elementary School   Regular School No Elementary PK 03 2021   grade_3 219 11 13 0   5     2   8   140 118 *                     258.0 219 11 13 0   5     2   8   140 118                 258
1680514 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth - Nathaniel H. Wixon School   Regular School No Elementary 04 05 2021   grade_4 148 25 20 8   5     2   20   130 98 *                     228.0 148 25 20 8   5     2   20   130 98                 228
1680727 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Hampden-Wilbraham - Stony Hill School   Regular School No Elementary 02 03 2021   grade_2 114 3 17 0   3     2   8   80 67 *                     147.0 114 3 17 0   3     2   8   80 67                 147
1680933 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba - Nashoba Regional   Regular School No High 09 12 2021   grade_11 230 3 12 0   4     2   4   118 136 *                     255.0 230 3 12 0   4     2   4   118 136                 255

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