Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by white descending

View and edit SQL

year

grade

  • grade_2 · 6,831
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 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
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
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
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
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
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
1366694 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 04 2020   grade_2 99 1 36 0   0     0   3   70 69 *                     139.0 99 1 36 0   0     0   3   70 69                 139
1366807 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2020   grade_2 99 2 4 0   0     0   6   57 54 *                     111.0 99 2 4 0   0     0   6   57 54                 111
1371984 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2020   grade_2 99 1 7 0   6     0   5   55 63 *                     118.0 99 1 7 0   6     0   5   55 63                 118
1373268 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary PK 04 2020   grade_2 99 1 3 0   1     0   6   54 56 *                     110.0 99 1 3 0   1     0   6   54 56                 110
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
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
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
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
742958 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No 1 01 03 2015   grade_2 98 0 9 0   7     0   3   57 60                       117 98 0 9 0   7     0   3   57 60                 117
941466 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No 1 KG 04 2016   grade_2 98 1 3 0   1     0   7   55 55                       110 98 1 3 0   1     0   7   55 55                 110
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
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
1366712 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2020   grade_2 98 2 2 0   1     0   0   44 59 *                     103.0 98 2 2 0   1     0   0   44 59                 103
1367525 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2020   grade_2 98 0 4 0   24     0   3   73 56 *                     129.0 98 0 4 0   24     0   3   73 56                 129
1371310 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2020   grade_2 98 9 4 0   7     0   1   59 60 *                     119.0 98 9 4 0   7     0   1   59 60                 119
1373075 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2020   grade_2 98 4 11 0   3     0   5   59 62 *                     121.0 98 4 11 0   3     0   5   59 62                 121
1674036 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth - James M. Quinn School   Regular School No Elementary KG 05 2021   grade_2 98 1 8 0   1     0   7   64 51 *                     115.0 98 1 8 0   1     0   7   64 51                 115
1674699 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_2 98 0 1 0   0     0   5   50 54 *                     104.0 98 0 1 0   0     0   5   50 54                 104
1678621 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge - Taft Early Learning Center   Regular School No Elementary PK 03 2021   grade_2 98 0 5 0   2     1   2   60 48 *                     108.0 98 0 5 0   2     1   2   60 48                 108
1680969 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 North Middlesex - Varnum Brook   Regular School No Elementary KG 04 2021   grade_2 98 2 12 0   2     0   4   57 61 *                     118.0 98 2 12 0   2     0   4   57 61                 118
2044084 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2019   grade_2 98 3 49 1   3     0   6   81 79                       160.0 98 3 49 1   3     0   6   81 79                 160
739724 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_2 97 3 3 8   3     0   9   59 64                       123 97 3 3 8   3     0   9   59 64                 123
739873 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2015   grade_2 97 4 30 0   2     0   7   71 69                       140 97 4 30 0   2     0   7   71 69                 140
936972 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No 1 PK 05 2016   grade_2 97 4 10 0   5     0   8   51 73                       124 97 4 10 0   5     0   8   51 73                 124
937832 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No 1 PK 04 2016   grade_2 97 0 9 1   0     0   5   56 56                       112 97 0 9 1   0     0   5   56 56                 112
941062 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No 1 02 04 2016   grade_2 97 6 9 0   1     0   6   55 64                       119 97 6 9 0   1     0   6   55 64                 119
941109 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No 1 KG 03 2016   grade_2 97 0 1 0   1     0   0   51 48                       99 97 0 1 0   1     0   0   51 48                 99
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
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
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
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
1368702 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 02 2020   grade_2 97 2 9 0   0     0   4   63 49 *                     112.0 97 2 9 0   0     0   4   63 49                 112
1673940 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset - Joseph Osgood   Regular School No Elementary PK 02 2021   grade_2 97 4 1 0   1     0   0   47 56 *                     103.0 97 4 1 0   1     0   0   47 56                 103
1676901 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 Northbridge - W Edward Balmer   Regular School No Elementary 02 04 2021   grade_2 97 1 8 0   0     0   8   60 54 *                     114.0 97 1 8 0   0     0   8   60 54                 114
1677056 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Oxford - Clara Barton   Regular School No Elementary 02 04 2021   grade_2 97 1 14 1   0     0   3   53 63 *                     116.0 97 1 14 1   0     0   3   53 63                 116
1677289 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Plymouth - Indian Brook   Regular School No Elementary KG 05 2021   grade_2 97 1 3 0   1     0   4   51 55 *                     106.0 97 1 3 0   1     0   4   51 55                 106
1679077 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Westport - Alice A Macomber   Regular School No Elementary PK 02 2021   grade_2 97 1 6 0   0     0   3   47 60 *                     107.0 97 1 6 0   0     0   3   47 60                 107
2048451 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2019   grade_2 97 3 1 0   6     0   3   60 50                       110.0 97 3 1 0   6     0   3   60 50                 110
2237906 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   grade_2 97 1 4 0   4     1   6   55 58                       113.0 97 1 4 0   4     1   6   55 58                 113
742147 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No 1 PK 02 2015   grade_2 96 0 2 0   1     0   7   49 57                       106 96 0 2 0   1     0   7   49 57                 106
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
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
1364802 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_2 96 4 5 0   1     0   3   56 53 *                     109.0 96 4 5 0   1     0   3   56 53                 109
2044055 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2019   grade_2 96 1 1 0   2     0   3   49 54                       103.0 96 1 1 0   2     0   3   49 54                 103
2044202 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2019   grade_2 96 1 2 0   12     0   6   55 62                       117.0 96 1 2 0   12     0   6   55 62                 117
2046898 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2019   grade_2 96 0 6 0   0     0   6   61 47                       108.0 96 0 6 0   0     0   6   61 47                 108
2236874 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Webster: Park Avenue Elementary   Regular School No Elementary PK 04 2018   grade_2 96 8 43 0   2     0   7   84 72                       156.0 96 8 43 0   2     0   7   84 72                 156
744842 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No 1 02 05 2015   grade_2 95 3 10 0   1     0   4   56 57                       113 95 3 10 0   1     0   4   56 57                 113
934769 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No 1 PK 02 2016   grade_2 95 3 2 0   3     0   4   52 55                       107 95 3 2 0   3     0   4   52 55                 107
941820 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2016   grade_2 95 2 4 0   1     0   0   54 48                       102 95 2 4 0   1     0   0   54 48                 102
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
1371151 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2020   grade_2 95 2 9 0   1     0   6   51 62 *                     113.0 95 2 9 0   1     0   6   51 62                 113
1373387 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2020   grade_2 95 0 3 0   4     0   7   57 52 *                     109.0 95 0 3 0   4     0   7   57 52                 109
1676320 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Milton - Glover   Regular School No Elementary KG 05 2021   grade_2 95 9 2 1   5     0   6   52 66 *                     118.0 95 9 2 1   5     0   6   52 66                 118
1678454 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton - Sutton Early Learning   Regular School No Elementary PK 02 2021   grade_2 95 2 4 0   1     0   3   62 43 *                     105.0 95 2 4 0   1     0   3   62 43                 105
1680890 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Narragansett - Templeton Elementary School   Regular School No Elementary PK 05 2021   grade_2 95 1 4 0   1     0   2   55 48 *                     103.0 95 1 4 0   1     0   2   55 48                 103
2042597 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2019   grade_2 95 0 9 0   23     0   8   81 54                       135.0 95 0 9 0   23     0   8   81 54                 135
2046312 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No Elementary KG 02 2019   grade_2 95 0 1 0   1     0   0   52 45                       97.0 95 0 1 0   1     0   0   52 45                 97
935290 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2016   grade_2 94 1 8 0   28     0   0   63 68                       131 94 1 8 0   28     0   0   63 68                 131
937813 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2016   grade_2 94 0 2 0   0     0   1   47 50                       97 94 0 2 0   0     0   1   47 50                 97
938359 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2016   grade_2 94 4 9 1   86     0   8   100 102                       202 94 4 9 1   86     0   8   100 102                 202
940698 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_2 94 2 11 0   2     0   1   53 57                       110 94 2 11 0   2     0   1   53 57                 110
941736 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No 1 KG 02 2016   grade_2 94 0 5 0   3     0   5   52 55                       107 94 0 5 0   3     0   5   52 55                 107
1129661 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 East Taunton Elementary   Regular School No Elementary KG 04 2017   grade_2 94 14 14 1   1     0   4   58 70                       128 94 14 14 1   1     0   4   58 70                 128
1130283 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2017   grade_2 94 1 2 0   24     0   7   68 60                       128 94 1 2 0   24     0   7   68 60                 128
1368984 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_2 94 3 3 3   1     0   5   62 47 *                     109.0 94 3 3 3   1     0   5   62 47                 109
1369059 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary KG 05 2020   grade_2 94 1 4 0   10     0   3   63 49 *                     112.0 94 1 4 0   10     0   3   63 49                 112
1369194 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2020   grade_2 94 4 5 0   12     0   5   48 72 *                     120.0 94 4 5 0   12     0   5   48 72                 120
1369716 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2020   grade_2 94 1 4 0   0     0   6   49 56 *                     105.0 94 1 4 0   0     0   6   49 56                 105
1373712 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2020   grade_2 94 2 2 0   1     0   8   48 59 *                     107.0 94 2 2 0   1     0   8   48 59                 107
1676237 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_2 94 3 0 0   2     0   6   52 53 *                     105.0 94 3 0 0   2     0   6   52 53                 105
1678958 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater - Rose L Macdonald   Regular School No Elementary 01 03 2021   grade_2 94 6 8 0   0     0   4   56 56 *                     112.0 94 6 8 0   0     0   4   56 56                 112
2231231 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas: Douglas Elementary School   Regular School No Elementary 02 05 2018   grade_2 94 0 5 0   1     0   2   50 52                       102.0 94 0 5 0   1     0   2   50 52                 102
2233816 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Milford: Memorial   Regular School No Elementary KG 02 2018   grade_2 94 4 50 1   5     0   7   83 78                       161.0 94 4 50 1   5     0   7   83 78                 161
2238604 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster: Westminster Elementary   Regular School No Elementary 02 05 2018   grade_2 94 1 1 0   0     0   1   52 45                       97.0 94 1 1 0   0     0   1   52 45                 97
739046 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2015   grade_2 93 7 1 2   5     0   0   63 45                       108 93 7 1 2   5     0   0   63 45                 108
739190 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No 1 PK 02 2015   grade_2 93 1 5 0   5     0   3   54 53                       107 93 1 5 0   5     0   3   54 53                 107
740064 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No 1 KG 04 2015   grade_2 93 3 1 0   10     0   13   59 61                       120 93 3 1 0   10     0   13   59 61                 120
1127139 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2017   grade_2 93 1 4 0   18     1   7   70 54                       124 93 1 4 0   18     1   7   70 54                 124
1132458 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No Elementary PK 05 2017   grade_2 93 2 3 0   5     0   3   51 55                       106 93 2 3 0   5     0   3   51 55                 106
1369016 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2020   grade_2 93 6 54 1   0     0   7   86 75 *                     161.0 93 6 54 1   0     0   7   86 75                 161
1371195 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2020   grade_2 93 0 4 1   1     0   1   50 50 *                     100.0 93 0 4 1   1     0   1   50 50                 100
1374057 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2020   grade_2 93 3 4 0   1     0   1   56 46 *                     102.0 93 3 4 0   1     0   1   56 46                 102
1676280 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Millbury - Elmwood Street   Regular School No Elementary PK 03 2021   grade_2 93 8 4 0   5     0   8   58 60 *                     118.0 93 8 4 0   5     0   8   58 60                 118
1677982 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Southborough - Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2021   grade_2 93 1 4 0   14     0   8   59 61 *                     120.0 93 1 4 0   14     0   8   59 61                 120
1680315 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster - Westminster Elementary   Regular School No Elementary 02 05 2021   grade_2 93 0 5 0   1     0   2   53 48 *                     101.0 93 0 5 0   1     0   2   53 48                 101
1681208 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Wachusett - Naquag Elementary School   Regular School No Elementary KG 02 2021   grade_2 93 1 4 0   2     0   2   52 50 *                     102.0 93 1 4 0   2     0   2   52 50                 102
2040116 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2019   grade_2 93 5 4 0   1     0   6   53 56                       109.0 93 5 4 0   1     0   6   53 56                 109
2046227 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   grade_2 93 2 7 0   2     0   7   59 52                       111.0 93 2 7 0   2     0   7   59 52                 111
2231954 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_2 93 0 4 0   3     0   0   55 45                       100.0 93 0 4 0   3     0   0   55 45                 100
2235858 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Southborough: Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2018   grade_2 93 3 9 0   25     1   7   78 60                       138.0 93 3 9 0   25     1   7   78 60                 138
738433 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_2 92 1 4 0   10     0   5   59 53                       112 92 1 4 0   10     0   5   59 53                 112
742975 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No 1 KG 02 2015   grade_2 92 3 7 0   5     1   1   59 50                       109 92 3 7 0   5     1   1   59 50                 109
744811 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland Elementary   Regular School No 1 PK 04 2015   grade_2 92 1 2 0   0     0   3   50 48                       98 92 1 2 0   0     0   3   50 48                 98

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