enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by white descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
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
1122439 1122439 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_7 98 1 3 0   2     0   2   54 52                       106 98 1 3 0   2     0   2   54 52                 106
1123491 1123491 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2017   grade_5 98 0 3 0   4     0   1   46 60                       106 98 0 3 0   4     0   1   46 60                 106
1125210 1125210 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2017   grade_4 98 2 5 0   14     0   4   68 55                       123 98 2 5 0   14     0   4   68 55                 123
1125923 1125923 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2017   grade_8 98 3 14 0   4     0   2   73 48                       121 98 3 14 0   4     0   2   73 48                 121
1128010 1128010 MA Essex   school 2509360 229   Peabody 250936001821 2290016 John E. McCarthy   Regular School No Elementary PK 05 2017   pre_kindergarten 98 3 10 0   2     0   1   68 46                       114 98 3 10 0   2     0   1   68 46                 114
1128226 1128226 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No Elementary KG 05 2017   grade_2 98 1 4 0   2     0   10   57 58                       115 98 1 4 0   2     0   10   57 58                 115
1128578 1128578 MA Plymouth   school 2510170 251   Rockland 251017001708 2510060 Jefferson Elementary School   Regular School No Elementary KG 04 2017   kindergarten 98 4 16 0   2     0   4   62 62                       124 98 4 16 0   2     0   4   62 62                 124
1128672 1128672 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2017   grade_8 98 10 67 0   4     0   5   101 83                       184 98 10 67 0   4     0   5   101 83                 184
1128675 1128675 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2017   grade_10 98 20 107 1   4     0   11   132 109                       241 98 20 107 1   4     0   11   132 109                 241
1129585 1129585 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No High 09 12 2017   grade_9 98 0 1 0   0     0   4   46 57                       103 98 0 1 0   0     0   4   46 57                 103
1130060 1130060 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2017   grade_3 98 7 43 0   1     0   7   77 79                       156 98 7 43 0   1     0   7   77 79                 156
1130198 1130198 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2017   grade_10 98 3 2 0   1     0   2   46 60                       106 98 3 2 0   1     0   2   46 60                 106
1130348 1130348 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2017   grade_3 98 0 5 0   0     0   8   61 50                       111 98 0 5 0   0     0   8   61 50                 111
1130543 1130543 MA Middlesex   school 2513050 342   Wilmington 251305000802 3420005 Boutwell   Regular School No Elementary PK KG 2017   kindergarten 98 1 5 0   9     0   4   61 56                       117 98 1 5 0   9     0   4   61 56                 117
1130731 1130731 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Elementary PK PK 2017   pre_kindergarten 98 103 330 2   18     2   7   280 280                       560 98 103 330 2   18     2   7   280 280                 560
1132099 1132099 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2017   grade_3 98 0 0 0   0     0   0   46 52                       98 98 0 0 0   0     0   0   46 52                 98
1132312 1132312 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2017   grade_11 98 0 0 0   0     0   0   46 52                       98 98 0 0 0   0     0   0   46 52                 98
1132946 1132946 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No Elementary PK 02 2017   grade_2 98 0 5 0   2     0   2   58 49                       107 98 0 5 0   2     0   2   58 49                 107
1133032 1133032 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Career and Technical School No High 09 12 2017   grade_9 98 11 9 1   6     0   4   88 41                       129 98 11 9 1   6     0   4   88 41                 129
1122242 1122242 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_7 97 8 24 0   4     0   8   77 64                       141 97 8 24 0   4     0   8   77 64                 141
1122416 1122416 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2017   grade_2 97 3 0 0   15     0   7   63 59                       122 97 3 0 0   15     0   7   63 59                 122
1124030 1124030 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_10 97 1 0 0   0     0   2   52 48                       100 97 1 0 0   0     0   2   52 48                 100
1124426 1124426 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_12 97 2 3 0   1     0   1   42 62                       104 97 2 3 0   1     0   1   42 62                 104
1124910 1124910 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2017   grade_10 97 26 147 0   18     0   19   151 156                       307 97 26 147 0   18     0   19   151 156                 307
1124911 1124911 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2017   grade_11 97 22 149 0   21     1   14   159 145                       304 97 22 149 0   21     1   14   159 145                 304
1125134 1125134 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2017   grade_9 97 0 5 0   1     0   5   47 61                       108 97 0 5 0   1     0   5   47 61                 108
1125440 1125440 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_7 97 7 30 0   3     1   1   67 72                       139 97 7 30 0   3     1   1   67 72                 139
1126138 1126138 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2017   grade_8 97 1 5 1   8     0   4   60 56                       116 97 1 5 1   8     0   4   60 56                 116
1126342 1126342 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2017   grade_9 97 5 1 0   6     0   3   55 57                       112 97 5 1 0   6     0   3   55 57                 112
1126739 1126739 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_3 97 5 4 8   2     0   5   59 62                       121 97 5 4 8   2     0   5   59 62                 121
1127051 1127051 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No High 09 12 2017   grade_11 97 3 3 2   2     0   2   62 47                       109 97 3 3 2   2     0   2   62 47                 109
1127559 1127559 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2017   grade_2 97 0 6 0   2     0   1   63 43                       106 97 0 6 0   2     0   1   63 43                 106
1129523 1129523 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2017   grade_1 97 0 7 0   0     0   3   62 45                       107 97 0 7 0   0     0   3   62 45                 107
1129524 1129524 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2017   grade_2 97 0 3 2   2     0   3   64 43                       107 97 0 3 2   2     0   3   64 43                 107
1129657 1129657 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2017   grade_4 97 7 6 0   2     0   6   65 53                       118 97 7 6 0   2     0   6   65 53                 118
1129719 1129719 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2017   grade_2 97 3 2 0   1     0   3   51 55                       106 97 3 2 0   1     0   3   51 55                 106
1129768 1129768 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2017   kindergarten 97 3 8 0   9     0   4   76 45                       121 97 3 8 0   9     0   4   76 45                 121
1129815 1129815 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No Elementary KG 04 2017   kindergarten 97 3 5 1   6     0   7   65 54                       119 97 3 5 1   6     0   7   65 54                 119
1130272 1130272 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   grade_4 97 0 0 3   15     0   3   65 53                       118 97 0 0 3   15     0   3   65 53                 118
1130657 1130657 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop High School   Regular School No High 09 12 2017   grade_11 97 2 18 2   1     0   6   64 62                       126 97 2 18 2   1     0   6   64 62                 126
1131225 1131225 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_9 97 5 5 1   26     0   8   84 58                       142 97 5 5 1   26     0   8   84 58                 142
1132939 1132939 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2017   grade_3 97 3 5 0   0     0   1   54 52                       106 97 3 5 0   0     0   1   54 52                 106
1132940 1132940 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2017   grade_4 97 2 6 0   1     0   4   40 70                       110 97 2 6 0   1     0   4   40 70                 110
1122184 1122184 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Elementary PK PK 2017   pre_kindergarten 96 2 5 0   23     0   5   68 63                       131 96 2 5 0   23     0   5   68 63                 131
1123486 1123486 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2017   grade_1 96 0 5 1   3     0   4   58 51                       109 96 0 5 1   3     0   4   58 51                 109
1124239 1124239 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2017   kindergarten 96 1 2 0   2     0   4   56 49                       105 96 1 2 0   2     0   4   56 49                 105
1124423 1124423 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_9 96 0 3 0   3     1   3   47 59                       106 96 0 3 0   3     1   3   47 59                 106
1125282 1125282 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Elementary 04 07 2017   grade_6 96 1 24 0   1     0   7   66 63                       129 96 1 24 0   1     0   7   66 63                 129
1125407 1125407 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_8 96 4 26 0   3     0   1   68 62                       130 96 4 26 0   3     0   1   68 62                 130
1125449 1125449 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_7 96 8 98 0   3     0   1   99 107                       206 96 8 98 0   3     0   1   99 107                 206
1126922 1126922 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_7 96 2 25 0   2     0   3   67 61                       128 96 2 25 0   2     0   3   67 61                 128
1127141 1127141 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2017   grade_4 96 4 2 0   10     0   11   63 60                       123 96 4 2 0   10     0   11   63 60                 123
1127215 1127215 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2017   grade_3 96 3 11 0   5     0   8   52 71                       123 96 3 11 0   5     0   8   52 71                 123
1127527 1127527 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2017   grade_8 96 15 12 2   27     1   10   77 86                       163 96 15 12 2   27     1   10   77 86                 163
1128178 1128178 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Elementary 04 06 2017   grade_5 96 1 6 1   6     0   0   52 58                       110 96 1 6 1   6     0   0   52 58                 110
1128870 1128870 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_3 96 1 11 1   93     0   7   100 109                       209 96 1 11 1   93     0   7   100 109                 209
1129575 1129575 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2017   grade_2 96 1 2 0   3     0   6   56 52                       108 96 1 2 0   3     0   6   56 52                 108
1130065 1130065 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2017   grade_7 96 10 31 1   3     2   10   66 87                       153 96 10 31 1   3     2   10   66 87                 153
1130269 1130269 MA Hampden   school 2512630 325   Westfield 251263002074 3250605 Westfield Technical Academy   Career and Technical School No High 09 12 2017   grade_12 96 2 1 0   2     1   0   73 29                       102 96 2 1 0   2     1   0   73 29                 102
1130560 1130560 MA Middlesex   school 2513050 342   Wilmington 251305001576 3420080 West Intermediate   Regular School No Elementary 04 05 2017   grade_4 96 2 12 0   8     0   2   56 64                       120 96 2 12 0   8     0   2   56 64                 120
1131815 1131815 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_7 96 1 6 1   0     0   3   53 54                       107 96 1 6 1   0     0   3   53 54                 107
1132101 1132101 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2017   kindergarten 96 0 0 1   1     0   3   53 48                       101 96 0 0 1   1     0   3   53 48                 101
1132522 1132522 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2017   grade_2 96 0 4 0   1     0   6   59 48                       107 96 0 4 0   1     0   6   59 48                 107
1132670 1132670 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2017   grade_11 96 0 8 0   2     0   3   55 54                       109 96 0 8 0   2     0   3   55 54                 109
1123490 1123490 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2017   grade_4 95 0 0 0   4     0   0   51 48                       99 95 0 0 0   4     0   0   51 48                 99
1123553 1123553 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2017   pre_kindergarten 95 3 3 0   20     0   1   76 46                       122 95 3 3 0   20     0   1   76 46                 122
1124424 1124424 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_10 95 0 3 0   0     0   1   52 47                       99 95 0 3 0   0     0   1   52 47                 99
1125113 1125113 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2017   grade_11 95 2 15 0   1     0   9   59 63                       122 95 2 15 0   1     0   9   59 63                 122
1125215 1125215 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2017   grade_3 95 2 8 0   26     0   0   68 63                       131 95 2 8 0   26     0   0   68 63                 131
1125638 1125638 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2017   grade_7 95 2 5 0   0     0   1   50 53                       103 95 2 5 0   0     0   1   50 53                 103
1125921 1125921 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2017   grade_6 95 5 12 0   2     0   6   54 66                       120 95 5 12 0   2     0   6   54 66                 120
1126765 1126765 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Elementary 04 07 2017   grade_4 95 3 18 0   1     0   1   70 48                       118 95 3 18 0   1     0   1   70 48                 118
1126770 1126770 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No High 08 12 2017   grade_8 95 3 8 0   2     0   3   54 57                       111 95 3 8 0   2     0   3   54 57                 111
1126933 1126933 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_7 95 0 36 0   11     0   5   83 64                       147 95 0 36 0   11     0   5   83 64                 147
1127001 1127001 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2017   kindergarten 95 5 50 0   2     1   4   78 79                       157 95 5 50 0   2     1   4   78 79                 157
1127040 1127040 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No Elementary PK 04 2017   grade_2 95 1 3 0   1     0   5   52 53                       105 95 1 3 0   1     0   5   52 53                 105
1127707 1127707 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten 95 6 4 2   18     1   10   77 59                       136 95 6 4 2   18     1   10   77 59                 136
1128859 1128859 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2017   kindergarten 95 2 13 0   128     0   11   137 112                       249 95 2 13 0   128     0   11   137 112                 249
1129033 1129033 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2017   grade_1 95 3 9 0   24     0   5   77 59                       136 95 3 9 0   24     0   5   77 59                 136
1129774 1129774 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2017   grade_5 95 4 7 1   6     0   3   58 58                       116 95 4 7 1   6     0   3   58 58                 116
1129942 1129942 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2017   grade_8 95 19 52 0   9     0   2   91 86                       177 95 19 52 0   9     0   2   91 86                 177
1130200 1130200 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2017   grade_12 95 3 0 0   1     0   0   45 54                       99 95 3 0 0   1     0   0   45 54                 99

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