enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by white descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
737777 737777 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2015   grade_2 99 1 2 1   4     0   3   46 64                       110 99 1 2 1   4     0   3   46 64                 110
737784 737784 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_9 99 0 2 0   0     0   0   52 49                       101 99 0 2 0   0     0   0   52 49                 101
738527 738527 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2015   grade_1 99 0 2 0   0     0   0   51 50                       101 99 0 2 0   0     0   0   51 50                 101
738530 738530 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No 1 03 04 2015   grade_4 99 0 2 0   2     0   0   54 49                       103 99 0 2 0   2     0   0   54 49                 103
739047 739047 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2015   grade_6 99 0 10 0   2     0   1   62 50                       112 99 0 10 0   2     0   1   62 50                 112
739199 739199 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2015   grade_11 99 1 2 1   6     0   2   53 58                       111 99 1 2 1   6     0   2   53 58                 111
739385 739385 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_4 99 2 11 0   0     1   2   68 47                       115 99 2 11 0   0     1   2   68 47                 115
739879 739879 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2015   grade_8 99 5 35 0   3     0   1   71 72                       143 99 5 35 0   3     0   1   71 72                 143
739970 739970 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2015   grade_8 99 1 13 0   1     0   4   60 58                       118 99 1 13 0   1     0   4   60 58                 118
740686 740686 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2015   grade_5 99 2 0 0   3     0   1   44 61                       105 99 2 0 0   3     0   1   44 61                 105
740997 740997 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No 1 KG 05 2015   grade_2 99 2 4 0   1     0   2   53 55                       108 99 2 4 0   1     0   2   53 55                 108
742148 742148 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No 1 03 05 2015   grade_3 99 1 3 0   2     0   4   53 56                       109 99 1 3 0   2     0   4   53 56                 109
742980 742980 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2015   grade_7 99 1 8 0   8     0   2   53 65                       118 99 1 8 0   8     0   2   53 65                 118
743508 743508 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2015   grade_8 99 4 2 2   26     0   12   62 83                       145 99 4 2 2   26     0   12   62 83                 145
744039 744039 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2015   grade_7 99 2 10 0   1     0   0   57 55                       112 99 2 10 0   1     0   0   57 55                 112
744101 744101 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No 2 04 05 2015   grade_5 99 1 5 0   1     0   3   49 60                       109 99 1 5 0   1     0   3   49 60                 109
744813 744813 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland Elementary   Regular School No 1 PK 04 2015   grade_4 99 3 3 0   2     0   0   54 53                       107 99 3 3 0   2     0   0   54 53                 107
744839 744839 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000202408 7670010 Lake Street   Regular School No 1 PK 01 2015   kindergarten 99 1 8 0   1     0   1   62 48                       110 99 1 8 0   1     0   1   62 48                 110
744847 744847 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Junior High   Regular School No 2 06 08 2015   grade_7 99 2 13 0   1     0   1   77 39                       116 99 2 13 0   1     0   1   77 39                 116
744999 744999 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2015   grade_2 99 1 4 0   0     0   5   42 67                       109 99 1 4 0   0     0   5   42 67                 109
933844 933844 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_9 99 5 4 0   0     0   5   55 58                       113 99 5 4 0   0     0   5   55 58                 113
934584 934584 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No 1 KG 05 2016   grade_3 99 2 2 0   2     0   9   67 47                       114 99 2 2 0   2     0   9   67 47                 114
935217 935217 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 08 12 2016   grade_11 99 8 15 0   2     0   3   74 53                       127 99 8 15 0   2     0   3   74 53                 127
935286 935286 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2016   grade_3 99 1 6 0   13     0   5   68 56                       124 99 1 6 0   13     0   5   68 56                 124
935439 935439 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2016   grade_7 99 5 23 0   3     0   0   70 60                       130 99 5 23 0   3     0   0   70 60                 130
936043 936043 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2016   grade_9 99 0 1 0   4     1   4   50 59                       109 99 0 1 0   4     1   4   50 59                 109
936046 936046 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2016   grade_12 99 1 2 1   6     0   2   52 59                       111 99 1 2 1   6     0   2   52 59                 111
936070 936070 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2016   grade_7 99 1 5 1   9     0   4   58 61                       119 99 1 5 1   9     0   4   58 61                 119
936590 936590 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No 1 PK 03 2016   grade_2 99 3 18 0   1     0   5   59 67                       126 99 3 18 0   1     0   5   59 67                 126
936787 936787 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2016   kindergarten 99 0 42 0   8     0   5   82 72                       154 99 0 42 0   8     0   5   82 72                 154
936910 936910 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No 1 KG 04 2016   grade_3 99 4 1 0   11     0   14   66 63                       129 99 4 1 0   11     0   14   66 63                 129
937630 937630 MA Essex   school 2509360 229   Peabody 250936001503 2290010 Thomas Carroll   Regular School No 1 KG 05 2016   grade_3 99 4 22 0   1     0   1   60 67                       127 99 4 22 0   1     0   1   60 67                 127
937640 937640 MA Essex   school 2509360 229   Peabody 250936001821 2290016 John E. McCarthy   Regular School No 1 PK 05 2016   pre_kindergarten 99 2 5 0   2     0   1   50 59                       109 99 2 5 0   2     0   1   50 59                 109
937784 937784 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No 2 04 06 2016   grade_4 99 1 6 1   7     0   1   52 63                       115 99 1 6 1   7     0   1   52 63                 115
937962 937962 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2016   grade_10 99 6 14 1   174     0   2   152 144                       296 99 6 14 1   174     0   2   152 144                 296
938807 938807 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2016   grade_9 99 148 327 0   44     1   9   347 281                       628 99 148 327 0   44     1   9   347 281                 628
939112 939112 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No 1 PK 05 2016   kindergarten 99 2 5 0   7     0   5   58 60                       118 99 2 5 0   7     0   5   58 60                 118
939253 939253 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No 2 06 08 2016   grade_7 99 22 48 0   9     0   2   88 92                       180 99 22 48 0   9     0   2   88 92                 180
939360 939360 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No 2 05 08 2016   grade_5 99 4 38 0   3     0   9   64 89                       153 99 4 38 0   3     0   9   64 89                 153
939533 939533 MA Hampden   school 2512630 325   Westfield 251263002074 3250605 Westfield Technical Academy   Vocational Education School No 3 09 12 2016   grade_12 99 1 1 0   1     0   0   55 47                       102 99 1 1 0   1     0   0   55 47                 102
939535 939535 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No 1 03 05 2016   grade_4 99 1 0 0   15     0   3   54 64                       118 99 1 0 0   15     0   3   54 64                 118
939594 939594 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 02 2016   grade_2 99 0 3 0   0     0   9   59 52                       111 99 0 3 0   0     0   9   59 52                 111
940873 940873 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2016   grade_7 99 1 10 0   0     0   4   61 53                       114 99 1 10 0   0     0   4   61 53                 114
941105 941105 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No 1 PK 03 2016   grade_2 99 0 0 0   0     0   0   46 53                       99 99 0 0 0   0     0   0   46 53                 99
941242 941242 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   grade_9 99 0 1 0   0     0   2   54 48                       102 99 0 1 0   0     0   2   54 48                 102
941283 941283 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2016   grade_10 99 0 0 0   0     0   0   46 53                       99 99 0 0 0   0     0   0   46 53                 99
941821 941821 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2016   grade_3 99 2 4 0   2     0   5   42 70                       112 99 2 4 0   2     0   5   42 70                 112
941826 941826 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2016   grade_1 99 0 6 0   2     0   2   60 49                       109 99 0 6 0   2     0   2   60 49                 109
941834 941834 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No 1 03 05 2016   grade_3 99 1 4 0   1     0   1   54 52                       106 99 1 4 0   1     0   1   54 52                 106
1122117 1122117 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_8 99 7 7 0   40     0   3   66 90                       156 99 7 7 0   40     0   3   66 90                 156
1122246 1122246 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2017   grade_6 99 10 26 0   7     0   4   87 59                       146 99 10 26 0   7     0   4   87 59                 146
1123481 1123481 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2017   grade_11 99 1 4 0   2     0   2   50 58                       108 99 1 4 0   2     0   2   50 58                 108
1125128 1125128 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_5 99 2 2 0   0     0   0   58 45                       103 99 2 2 0   0     0   0   58 45                 103
1125682 1125682 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2017   grade_3 99 0 8 0   1     0   1   53 56                       109 99 0 8 0   1     0   1   53 56                 109
1125912 1125912 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No Elementary 03 05 2017   grade_3 99 9 8 0   1     0   1   65 53                       118 99 9 8 0   1     0   1   65 53                 118
1126106 1126106 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2017   grade_10 99 0 2 0   8     1   4   53 61                       114 99 0 2 0   8     1   4   53 61                 114
1126107 1126107 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2017   grade_11 99 2 1 0   1     0   3   53 53                       106 99 2 1 0   1     0   3   53 53                 106
1127047 1127047 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_8 99 1 2 0   6     1   3   70 42                       112 99 1 2 0   6     1   3   70 42                 112
1127380 1127380 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_6 99 42 94 1   1     0   17   131 123                       254 99 42 94 1   1     0   17   131 123                 254
1127495 1127495 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 99 11 18 0   48     0   17   124 69                       193 99 11 18 0   48     0   17   124 69                 193
1127580 1127580 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   pre_kindergarten 99 0 10 0   0     0   10   63 56                       119 99 0 10 0   0     0   10   63 56                 119
1128213 1128213 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No Elementary KG 05 2017   grade_3 99 0 1 0   0     0   1   49 52                       101 99 0 1 0   0     0   1   49 52                 101
1129718 1129718 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2017   grade_1 99 1 1 0   1     0   4   51 55                       106 99 1 1 0   1     0   4   51 55                 106
1131816 1131816 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_8 99 0 9 0   0     0   4   60 52                       112 99 0 9 0   0     0   4   60 52                 112
1132104 1132104 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2017   grade_3 99 0 0 0   1     0   0   50 50                       100 99 0 0 0   1     0   0   50 50                 100
1132439 1132439 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_7 99 2 7 0   0     1   2   60 51                       111 99 2 7 0   0     1   2   60 51                 111
1132944 1132944 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten 99 2 6 0   1     0   5   72 41                       113 99 2 6 0   1     0   5   72 41                 113
2230140 2230140 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston: Boston Latin Academy   Regular School No High 07 12 2018   grade_7 99 63 67 0   58     1   12   120 179                       300.0 99 63 67 0   58     1   12   120 179                 300
2231166 2231166 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth: James M. Quinn School   Regular School No Elementary KG 05 2018   kindergarten 99 2 2 0   0     0   8   58 53                       111.0 99 2 2 0   0     0   8   58 53                 111
2232045 2232045 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton: Millbury Street Elementary School   Regular School No Elementary 02 06 2018   grade_4 99 2 9 0   22     0   0   68 64                       132.0 99 2 9 0   22     0   0   68 64                 132
2233167 2233167 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg: Lunenburg High   Regular School No High 09 12 2018   grade_11 99 1 3 1   8     1   1   56 58                       114.0 99 1 3 1   8     1   1   56 58                 114
2233565 2233565 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee: Mashpee High   Regular School No High 09 12 2018   grade_9 99 7 7 8   5     0   3   64 65                       129.0 99 7 7 8   5     0   3   64 65                 129
2233818 2233818 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Milford: Brookside   Regular School No Elementary KG 02 2018   kindergarten 99 8 39 0   0     0   8   88 66                       154.0 99 8 39 0   0     0   8   88 66                 154
2234793 2234793 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Palmer: Old Mill Pond   Regular School No Elementary PK 05 2018   grade_5 99 4 13 0   3     0   6   52 73                       125.0 99 4 13 0   3     0   6   52 73                 125
2236403 2236403 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton: Sutton High School   Regular School No High 09 12 2018   grade_10 99 0 1 0   0     0   4   46 58                       104.0 99 0 1 0   0     0   4   46 58                 104
2236437 2236437 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Swansea: Elizabeth S Brown   Regular School No Elementary 03 05 2018   grade_4 99 0 0 0   3     0   0   43 59                       102.0 99 0 0 0   3     0   0   43 59                 102
2236535 2236535 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Tewksbury: Heath-Brook   Regular School No Elementary KG 02 2018   grade_2 99 0 1 0   2     0   4   51 55                       106.0 99 0 1 0   2     0   4   51 55                 106
2236776 2236776 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware: Ware Middle School   Regular School No Middle 04 06 2018   grade_6 99 3 6 0   0     1   6   51 64                       115.0 99 3 6 0   0     1   6   51 64                 115
2238055 2238055 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District): Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2018   grade_9 99 1 10 0   43     0   5   79 79                       158.0 99 1 10 0   43     0   5   79 79                 158
2238848 2238848 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Dighton-Rehoboth: Palmer River   Regular School No Elementary KG 04 2018   grade_2 99 0 8 0   2     0   0   54 55                       109.0 99 0 8 0   2     0   0   54 55                 109
2239053 2239053 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham: Miles River Middle   Regular School No Middle 06 08 2018   grade_6 99 2 5 0   6     1   3   42 74                       116.0 99 2 5 0   6     1   3   42 74                 116
2239758 2239758 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Whitman-Hanson: Maquan Elementary   Regular School No Elementary PK 02 2018   kindergarten 99 1 5 0   1     0   1   56 51                       107.0 99 1 5 0   1     0   1   56 51                 107
2239770 2239770 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson: Indian Head   Regular School No Elementary 03 05 2018   grade_3 99 0 6 0   2     0   2   59 50                       109.0 99 0 6 0   2     0   2   59 50                 109
2239771 2239771 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson: Indian Head   Regular School No Elementary 03 05 2018   grade_4 99 0 2 0   0     0   2   51 52                       103.0 99 0 2 0   0     0   2   51 52                 103
2040069 2040069 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2019   grade_2 99 1 7 0   2     0   4   56 57                       113.0 99 1 7 0   2     0   4   56 57                 113
2041766 2041766 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 04 2019   grade_4 99 5 39 0   1     0   5   73 76                       149.0 99 5 39 0   1     0   5   73 76                 149
2041875 2041875 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2019   kindergarten 99 1 6 0   0     0   6   58 54                       112.0 99 1 6 0   0     0   6   58 54                 112
2042535 2042535 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_1 99 0 2 0   2     0   2   56 49                       105.0 99 0 2 0   2     0   2   56 49                 105
2043325 2043325 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2019   grade_8 99 0 2 1   9     0   7   58 60                       118.0 99 0 2 1   9     0   7   58 60                 118
2044940 2044940 MA Essex   school 2509360 229   Peabody 250936001821 2290016 John E. McCarthy   Regular School No Elementary PK 05 2019   pre_kindergarten 99 3 14 0   0     0   3   71 48                       119.0 99 3 14 0   0     0   3   71 48                 119
2045133 2045133 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2019   grade_2 99 0 3 1   0     0   7   66 44                       110.0 99 0 3 1   0     0   7   66 44                 110
2046228 2046228 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   grade_3 99 0 8 0   0     0   5   64 48                       112.0 99 0 8 0   0     0   5   64 48                 112
2046229 2046229 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   grade_4 99 2 8 2   2     0   6   68 51                       119.0 99 2 8 2   2     0   6   68 51                 119
2046281 2046281 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No High 09 12 2019   grade_12 99 0 4 0   0     0   2   48 57                       105.0 99 0 4 0   0     0   2   48 57                 105
2046385 2046385 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2019   grade_1 99 5 7 0   7     0   0   60 58                       118.0 99 5 7 0   7     0   0   60 58                 118
2046676 2046676 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2019   grade_4 99 6 39 1   2     0   7   78 76                       154.0 99 6 39 1   2     0   7   78 76                 154
2046789 2046789 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2019   grade_8 99 7 5 0   0     0   1   63 49                       112.0 99 7 5 0   0     0   1   63 49                 112
2047505 2047505 MA Hampshire   school 2508860 406   Northampton-Smith Vocational Agricultural 250886002314 4060705 Smith Vocational and Agricultural High   Career and Technical School No High 09 12 2019   grade_9 99 3 13 0   0     0   2   61 56                       117.0 99 3 13 0   0     0   2   61 56                 117
2048335 2048335 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2019   grade_7 99 2 4 0   1     0   4   62 48                       110.0 99 2 4 0   1     0   4   62 48                 110
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

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