Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by white 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
1672032 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_8 99 0 4 0   1     0   5   59 50 *                     109.0 99 0 4 0   1     0   5   59 50                 109
1672079 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_10 99 2 10 0   0     0   7   63 55 *                     118.0 99 2 10 0   0     0   7   63 55                 118
1673763 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_9 99 1 3 0   0     0   3   66 40 *                     106.0 99 1 3 0   0     0   3   66 40                 106
1674321 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_11 99 103 287 3   25     0   7   273 251 *                     524.0 99 103 287 3   25     0   7   273 251                 524
1674668 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin - Remington Middle   Regular School No Middle 06 08 2021   grade_8 99 5 8 0   10     0   1   66 57 *                     123.0 99 5 8 0   10     0   1   66 57                 123
1675689 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Lunenburg - Turkey Hill Elementary School   Regular School No Elementary 03 05 2021   grade_5 99 4 13 0   6     0   1   67 56 *                     123.0 99 4 13 0   6     0   1   67 56                 123
1675692 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg - Lunenburg Middle School   Regular School No Middle 06 08 2021   grade_8 99 1 16 0   0     1   3   62 57 *                     120.0 99 1 16 0   0     1   3   62 57                 120
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
1676284 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Millbury - Raymond E. Shaw Elementary   Regular School No Middle 04 06 2021   grade_6 99 8 5 0   9     1   10   66 66 *                     132.0 99 8 5 0   9     1   10   66 66                 132
1676290 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury - Millbury Junior/Senior High   Regular School No High 07 12 2021   grade_12 99 6 7 0   3     0   4   54 63 *                     119.0 99 6 7 0   3     0   4   54 63                 119
1676710 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Newton - Bigelow Middle   Regular School No Middle 06 08 2021   grade_6 99 13 19 0   24     0   13   88 80 *                     168.0 99 13 19 0   24     0   13   88 80                 168
1677309 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 Plymouth - South Elementary   Regular School No Elementary KG 05 2021   grade_4 99 0 3 2   0     0   9   68 45 *                     113.0 99 0 3 2   0     0   9   68 45                 113
1678623 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Uxbridge - Whitin Intermediate   Regular School No Middle 04 07 2021   grade_4 99 0 7 0   0     0   4   60 50 *                     110.0 99 0 7 0   0     0   4   60 50                 110
1678702 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Walpole - Eleanor N Johnson Middle   Regular School No Middle 06 08 2021   grade_7 99 3 9 0   20     0   5   71 65 *                     136.0 99 3 9 0   20     0   5   71 65                 136
1678771 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware - Ware Junior/Senior High School   Regular School No High 07 12 2021   grade_8 99 3 7 0   0     1   4   57 57 *                     114.0 99 3 7 0   0     1   4   57 57                 114
1679657 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Worcester - Burncoat Senior High   Regular School No High 09 12 2021   grade_10 99 55 142 0   8     0   16   146 174 *                     320.0 99 55 142 0   8     0   16   146 174                 320
1681142 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield - Knox Trail Middle School   Regular School No Middle 05 08 2021   grade_7 99 4 17 0   2     0   6   66 62 *                     128.0 99 4 17 0   2     0   6   66 62                 128
1681339 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Regional Vocational Technical - Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2021   grade_12 99 10 20 1   0     1   3   92 42 *                     134.0 99 10 20 1   0     1   3   92 42                 134
1681427 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural - Bristol County Agricultural High   Career and Technical School No High 09 12 2021   grade_11 99 3 4 0   0     1   0   28 79 *                     107.0 99 3 4 0   0     1   0   28 79                 107
1673199 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston - Boston Latin Academy   Regular School No High 07 12 2021   grade_10 98 75 81 1   72     1   10   133 204 *                     338.0 98 75 81 1   72     1   10   133 204                 338
1673314 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford - Spofford Pond   Regular School No Elementary 03 06 2021   grade_5 98 2 3 0   4     0   4   57 54 *                     111.0 98 2 3 0   4     0   4   57 54                 111
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
1674698 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_1 98 0 4 0   1     0   2   47 58 *                     105.0 98 0 4 0   1     0   2   47 58                 105
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
1674778 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton - Millbury Street Elementary School   Regular School No Elementary 02 06 2021   grade_5 98 4 7 0   21     0   2   72 60 *                     132.0 98 4 7 0   21     0   2   72 60                 132
1674779 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton - Millbury Street Elementary School   Regular School No Elementary 02 06 2021   grade_6 98 0 15 0   29     0   1   76 67 *                     143.0 98 0 15 0   29     0   1   76 67                 143
1675482 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Littleton - Russell St Elementary   Regular School No Elementary 03 05 2021   grade_4 98 1 2 0   9     0   2   56 56 *                     112.0 98 1 2 0   9     0   2   56 56                 112
1677062 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford - Oxford Middle   Regular School No Middle 05 07 2021   grade_5 98 3 18 0   0     0   7   66 60 *                     126.0 98 3 18 0   0     0   7   66 60                 126
1677983 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Southborough - Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2021   grade_3 98 0 7 0   20     0   8   68 65 *                     133.0 98 0 7 0   20     0   8   68 65                 133
1678566 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 Tewksbury - North Street   Regular School No Elementary 03 04 2021   grade_3 98 6 6 0   9     0   1   57 63 *                     120.0 98 6 6 0   9     0   1   57 63                 120
1678620 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge - Taft Early Learning Center   Regular School No Elementary PK 03 2021   grade_1 98 0 17 0   1     0   1   63 54 *                     117.0 98 0 17 0   1     0   1   63 54                 117
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
1679082 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport - Westport Junior/Senior High School   Regular School No High 07 12 2021   grade_7 98 0 2 0   0     0   6   61 45 *                     106.0 98 0 2 0   0     0   6   61 45                 106
1679827 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 2021   grade_10 98 6 13 0   26     0   12   84 71 *                     155.0 98 6 13 0   26     0   12   84 71                 155
1680372 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley School District - Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2021   grade_7 98 7 23 1   4     0   4   72 65 *                     137.0 98 7 23 1   4     0   4   72 65                 137
1680389 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Berkshire Hills - Monument Mt Regional High   Regular School No High 09 12 2021   grade_10 98 0 13 0   4     0   3   57 61 *                     118.0 98 0 13 0   4     0   3   57 61                 118
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
1680431 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone-Millville - Blackstone Millville RHS   Regular School No High 09 12 2021   grade_11 98 1 7 0   1     0   5   53 59 *                     112.0 98 1 7 0   1     0   5   53 59                 112
1680558 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley-Charlton Reg - Dudley Elementary   Regular School No Elementary 02 04 2021   grade_3 98 3 18 0   1     0   2   60 62 *                     122.0 98 3 18 0   1     0   2   60 62                 122
1680599 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown-Lakeville - Freetown Elementary School   Regular School No Elementary PK 03 2021   grade_1 98 0 5 0   0     0   2   64 41 *                     105.0 98 0 5 0   0     0   2   64 41                 105
1680654 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Groton-Dunstable - Florence Roche School   Regular School No Elementary KG 04 2021   grade_4 98 3 1 0   10     0   6   62 56 *                     118.0 98 3 1 0   10     0   6   62 56                 118
1680722 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Hampden-Wilbraham - Mile Tree Elementary   Regular School No Elementary PK 01 2021   kindergarten 98 5 11 1   3     0   3   63 58 *                     121.0 98 5 11 1   3     0   3   63 58                 121
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
1681082 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake - Silver Lake Regional High   Regular School No High 09 12 2021   pre_kindergarten 98 1 0 0   0     0   0   57 42 *                     99.0 98 1 0 0   0     0   0   57 42                 99
1681251 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Wachusett - Glenwood Elementary School   Regular School No Elementary 03 05 2021   grade_4 98 2 10 0   1     0   1   56 56 *                     112.0 98 2 10 0   1     0   1   56 56                 112
1672204 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland - Henry E Warren Elementary   Regular School No Elementary KG 02 2021   kindergarten 97 10 30 0   45     0   9   107 84 *                     191.0 97 10 30 0   45     0   9   107 84                 191
1672244 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_6 97 9 15 0   8     0   7   75 61 *                     136.0 97 9 15 0   8     0   7   75 61                 136
1673934 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Cohasset - Deer Hill   Regular School No Elementary 03 05 2021   grade_3 97 2 3 0   1     0   0   43 60 *                     103.0 97 2 3 0   1     0   0   43 60                 103
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
1674322 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_12 97 104 215 0   25     1   12   238 216 *                     454.0 97 104 215 0   25     1   12   238 216                 454
1674516 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg - Fitchburg High   Regular School No High 09 12 2021   grade_10 97 25 202 0   18     0   20   197 165 *                     362.0 97 25 202 0   18     0   20   197 165                 362
1674678 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner - Elm Street School   Regular School No Elementary 02 04 2021   grade_3 97 5 49 0   4     0   12   78 89 *                     167.0 97 5 49 0   4     0   12   78 89                 167
1675191 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich - Ipswich Middle School   Regular School No Middle 06 08 2021   grade_6 97 1 5 0   4     0   6   53 60 *                     113.0 97 1 5 0   4     0   6   53 60                 113
1676120 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Medford - Madeleine Dugger Andrews   Regular School No Middle 06 08 2021   grade_6 97 19 12 1   21     0   11   75 86 *                     161.0 97 19 12 1   21     0   11   75 86                 161
1676122 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Medford - Madeleine Dugger Andrews   Regular School No Middle 06 08 2021   grade_8 97 9 10 1   11     0   11   80 59 *                     139.0 97 9 10 1   11     0   11   80 59                 139
1676263 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Milford - Brookside   Regular School No Elementary KG 02 2021   grade_1 97 2 48 0   3     0   0   75 75 *                     150.0 97 2 48 0   3     0   0   75 75                 150
1676279 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Millbury - Elmwood Street   Regular School No Elementary PK 03 2021   grade_1 97 1 8 0   8     0   7   71 50 *                     121.0 97 1 8 0   8     0   7   71 50                 121
1676380 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Natick - Bennett-Hemenway   Regular School No Elementary KG 04 2021   grade_4 97 1 3 0   10     0   6   54 63 *                     117.0 97 1 3 0   10     0   6   54 63                 117
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
1677063 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford - Oxford Middle   Regular School No Middle 05 07 2021   grade_6 97 2 14 0   0     0   4   63 54 *                     117.0 97 2 14 0   0     0   4   63 54                 117
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
1677677 MA Essex   school 2510380 258   Salem 251038002404 2580305 Salem - Collins Middle   Regular School No Middle 06 08 2021   grade_7 97 18 87 0   8     0   12   111 111 *                     222.0 97 18 87 0   8     0   12   111 111                 222
1677960 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville - Somerville High   Regular School No High 09 12 2021   grade_10 97 33 139 0   17     1   4   151 140 *                     291.0 97 33 139 0   17     1   4   151 140                 291
1678413 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Sturbridge - Burgess Elementary   Regular School No Elementary PK 06 2021   grade_5 97 2 10 0   0     0   6   68 47 *                     115.0 97 2 10 0   0     0   6   68 47                 115
1678618 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge - Taft Early Learning Center   Regular School No Elementary PK 03 2021   kindergarten 97 1 6 1   0     0   2   57 50 *                     107.0 97 1 6 1   0     0   2   57 50                 107
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
1679079 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport - Westport Elementary   Regular School No Elementary 03 06 2021   grade_4 97 0 6 0   0     0   5   61 47 *                     108.0 97 0 6 0   0     0   5   61 47                 108
1679240 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington - Woburn Street   Regular School No Elementary 01 03 2021   grade_1 97 2 7 0   6     0   6   71 47 *                     118.0 97 2 7 0   6     0   6   71 47                 118
1679828 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 2021   grade_11 97 2 11 0   30     0   7   73 74 *                     147.0 97 2 11 0   30     0   7   73 74                 147
1680318 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster - Westminster Elementary   Regular School No Elementary 02 05 2021   grade_5 97 2 4 0   0     0   1   55 49 *                     104.0 97 2 4 0   0     0   1   55 49                 104
1681347 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_12 97 0 5 0   0     0   4   68 38 *                     106.0 97 0 5 0   0     0   4   68 38                 106
1672029 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_5 96 0 3 0   1     0   8   57 51 *                     108.0 96 0 3 0   1     0   8   57 51                 108
1672243 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_5 96 11 17 0   9     1   13   87 60 *                     147.0 96 11 17 0   9     1   13   87 60                 147
1673305 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   grade_11 96 4 5 2   2     0   2   49 62 *                     111.0 96 4 5 2   2     0   2   49 62                 111
1673764 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_10 96 0 0 2   0     0   0   44 54 *                     98.0 96 0 0 2   0     0   0   44 54                 98
1674683 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner - Gardner Middle School   Regular School No Middle 05 07 2021   grade_5 96 8 50 0   7     0   16   80 97 *                     177.0 96 8 50 0   7     0   16   80 97                 177
1676196 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen - Marsh Grammar School   Regular School No Elementary PK 08 2021   grade_8 96 3 34 0   2     0   8   75 68 *                     143.0 96 3 34 0   2     0   8   75 68                 143
1676240 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_5 96 2 2 0   0     0   8   56 52 *                     108.0 96 2 2 0   0     0   8   56 52                 108
1677676 MA Essex   school 2510380 258   Salem 251038002404 2580305 Salem - Collins Middle   Regular School No Middle 06 08 2021   grade_6 96 15 95 0   6     0   11   121 102 *                     223.0 96 15 95 0   6     0   11   121 102                 223
1678020 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 South Hadley - Michael E. Smith Middle School   Regular School No Middle 05 08 2021   grade_7 96 3 21 0   3     0   0   67 56 *                     123.0 96 3 21 0   3     0   0   67 56                 123
1678611 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough - Tyngsborough Middle   Regular School No Middle 06 08 2021   grade_6 96 5 3 0   11     0   4   65 54 *                     119.0 96 5 3 0   11     0   4   65 54                 119
1678613 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough - Tyngsborough Middle   Regular School No Middle 06 08 2021   grade_8 96 7 14 0   6     0   2   69 56 *                     125.0 96 7 14 0   6     0   2   69 56                 125
1678966 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater - West Bridgewater Junior/Senior   Regular School No High 07 12 2021   grade_8 96 5 5 0   1     0   5   52 60 *                     112.0 96 5 5 0   1     0   5   52 60                 112
1679246 MA Middlesex   school 2513050 342   Wilmington 251305001575 3420060 Wilmington - North Intermediate   Regular School No Elementary 04 05 2021   grade_4 96 2 4 0   4     0   5   58 53 *                     111.0 96 2 4 0   4     0   5   58 53                 111
1679262 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Winchendon - Toy Town Elementary   Regular School No Elementary 03 05 2021   grade_4 96 0 8 0   0     1   4   68 41 *                     109.0 96 0 8 0   0     1   4   68 41                 109
1679648 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester - Burncoat Middle School   Regular School No Middle 07 08 2021   grade_8 96 52 161 0   18     0   24   181 170 *                     351.0 96 52 161 0   18     0   24   181 170                 351
1680425 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 Blackstone-Millville - A F Maloney   Regular School No Elementary 03 05 2021   grade_5 96 0 10 0   1     0   6   67 46 *                     113.0 96 0 10 0   1     0   6   67 46                 113
1680535 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Dighton-Rehoboth - Palmer River   Regular School No Elementary PK 04 2021   grade_4 96 2 2 1   3     0   4   53 55 *                     108.0 96 2 2 1   3     0   4   53 55                 108
1680894 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett - Narragansett Middle   Regular School No Middle 05 08 2021   grade_6 96 1 8 0   0     0   8   59 54 *                     113.0 96 1 8 0   0     0   8   59 54                 113
1681256 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett - Central Tree Middle   Regular School No Middle 06 08 2021   grade_6 96 2 3 1   3     0   2   52 55 *                     107.0 96 2 3 1   3     0   2   52 55                 107
1681367 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical - Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2021   grade_11 96 9 92 5   2     0   8   127 85 *                     212.0 96 9 92 5   2     0   8   127 85                 212
1672031 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_7 95 1 2 1   1     0   0   55 45 *                     100.0 95 1 2 1   1     0   0   55 45                 100
1672410 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   grade_4 95 0 2 0   1     0   3   57 44 *                     101.0 95 0 2 0   1     0   3   57 44                 101
1673937 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset - Joseph Osgood   Regular School No Elementary PK 02 2021   kindergarten 95 0 2 1   0     0   2   54 46 *                     100.0 95 0 2 1   0     0   2   54 46                 100
1674950 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_6 95 12 108 0   7     0   12   131 103 *                     234.0 95 12 108 0   7     0   12   131 103                 234
1675487 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton - Littleton High School   Regular School No High 09 12 2021   grade_9 95 3 4 0   10     0   5   48 69 *                     117.0 95 3 4 0   10     0   5   48 69                 117
1675925 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden - Malden High   Regular School No High 09 12 2021   grade_12 95 83 108 1   104     0   6   222 174 *                     397.0 95 83 108 1   104     0   6   222 174                 397
1676235 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_5 95 1 3 0   0     0   8   58 49 *                     107.0 95 1 3 0   0     0   8   58 49                 107
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

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