Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by female descending

View and edit SQL

year

  • 2019 · 9,565
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
2040084 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_12 160 6 7 0   11     0   5   90 99                       189.0 160 6 7 0   11     0   5   90 99                 189
2042312 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2019   grade_12 148 4 7 3   10     0   7   79 99                       179.0 148 4 7 3   10     0   7   79 99                 179
2042521 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_6 131 3 48 0   5     0   19   107 99                       206.0 131 3 48 0   5     0   19   107 99                 206
2042688 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2019   grade_7 204 4 5 0   6     0   1   121 99                       220.0 204 4 5 0   6     0   1   121 99                 220
2042861 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2019   grade_1 160 1 13 0   19     0   13   107 99                       206.0 160 1 13 0   19     0   13   107 99                 206
2043775 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Middle 04 06 2019   grade_5 165 6 15 0   3     0   8   98 99                       197.0 165 6 15 0   3     0   8   98 99                 197
2044436 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2019   grade_7 177 3 7 0   9     0   4   101 99                       200.0 177 3 7 0   9     0   4   101 99                 200
2045076 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2019   grade_8 127 21 27 0   3     0   18   97 99                       196.0 127 21 27 0   3     0   18   97 99                 196
2045335 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No Middle 06 08 2019   grade_8 172 3 7 0   11     0   3   97 99                       196.0 172 3 7 0   11     0   3   97 99                 196
2045559 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No High 09 12 2019   grade_12 138 5 29 0   7     0   1   81 99                       180.0 138 5 29 0   7     0   1   81 99                 180
2045654 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2019   kindergarten 87 8 18 4   96     0   8   122 99                       221.0 87 8 18 4   96     0   8   122 99                 221
2045715 MA Middlesex   school 2510890 274   Somerville 251089002561 2740005 Capuano Early Childhood Center   Regular School No Elementary PK KG 2019   pre_kindergarten 108 15 68 0   21     0   26   139 99                       238.0 108 15 68 0   21     0   26   139 99                 238
2046605 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2019   grade_5 123 15 12 2   2     0   29   84 99                       183.0 123 15 12 2   2     0   29   84 99                 183
2047189 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2019   grade_6 137 16 23 0   8     1   6   92 99                       191.0 137 16 23 0   8     1   6   92 99                 191
2047612 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_3 8 102 69 0   2     0   3   85 99                       184.0 8 102 69 0   2     0   3   85 99                 184
2048789 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2019   grade_12 173 5 1 0   7     0   3   90 99                       189.0 173 5 1 0   7     0   3   90 99                 189
2049010 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No Middle 07 08 2019   grade_8 195 2 4 0   1     0   2   105 99                       204.0 195 2 4 0   1     0   2   105 99                 204
2040077 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2019   grade_6 154 3 23 0   7     0   9   98 98                       196.0 154 3 23 0   7     0   9   98 98                 196
2041222 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2019   kindergarten 16 105 78 0   1     0   5   107 98                       205.0 16 105 78 0   1     0   5   107 98                 205
2041228 MA Plymouth   school 2503090 44   Brockton 250309002792 440008 Barrett Russell Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 57 107 33 0   1     1   8   109 98                       207.0 57 107 33 0   1     1   8   109 98                 207
2041300 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2019   grade_7 29 130 37 0   3     0   6   107 98                       205.0 29 130 37 0   3     0   6   107 98                 205
2042605 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2019   grade_10 161 8 6 0   11     0   6   94 98                       192.0 161 8 6 0   11     0   6   94 98                 192
2042997 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2019   grade_11 157 3 17 0   2     0   0   81 98                       179.0 157 3 17 0   2     0   0   81 98                 179
2043522 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2019   grade_11 165 5 15 1   2     0   6   96 98                       194.0 165 5 15 1   2     0   6   96 98                 194
2044724 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2019   grade_6 127 2 16 0   28     1   7   83 98                       181.0 127 2 16 0   28     1   7   83 98                 181
2045078 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2019   grade_10 142 20 27 1   6     0   9   107 98                       205.0 142 20 27 1   6     0   9   107 98                 205
2045387 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2019   grade_8 54 11 103 1   8     0   4   83 98                       181.0 54 11 103 1   8     0   4   83 98                 181
2045664 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_4 72 6 11 2   96     0   10   99 98                       197.0 72 6 11 2   96     0   10   99 98                 197
2046640 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2019   grade_8 128 9 24 2   12     1   9   87 98                       185.0 128 9 24 2   12     1   9   87 98                 185
2047613 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_4 14 93 67 1   4     0   4   85 98                       183.0 14 93 67 1   4     0   4   85 98                 183
2048379 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2019   grade_6 164 9 12 1   3     0   3   94 98                       192.0 164 9 12 1   3     0   3   94 98                 192
2048411 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2019   grade_10 195 1 6 0   3     0   2   109 98                       207.0 195 1 6 0   3     0   2   109 98                 207
2048887 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2019   grade_9 165 1 12 0   1     1   6   88 98                       186.0 165 1 12 0   1     1   6   88 98                 186
2040075 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2019   grade_4 159 5 22 0   14     0   4   107 97                       204.0 159 5 22 0   14     0   4   107 97                 204
2040130 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_2 126 13 9 0   34     0   15   100 97                       197.0 126 13 9 0   34     0   15   100 97                 197
2040297 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_6 156 14 11 1   12     0   4   101 97                       198.0 156 14 11 1   12     0   4   101 97                 198
2040979 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2019   grade_10 3 98 164 0   4     0   3   175 97                       272.0 3 98 164 0   4     0   3   175 97                 272
2041631 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2019   grade_5 144 5 9 1   34     0   7   103 97                       200.0 144 5 9 1   34     0   7   103 97                 200
2041889 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No Elementary PK KG 2019   kindergarten 144 7 29 0   6     0   15   104 97                       201.0 144 7 29 0   6     0   15   104 97                 201
2042184 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No High 09 12 2019   grade_11 144 0 13 0   3     0   3   66 97                       163.0 144 0 13 0   3     0   3   66 97                 163
2042326 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_5 63 7 103 0   7     1   12   96 97                       193.0 63 7 103 0   7     1   12   96 97                 193
2042867 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2019   grade_10 170 2 4 2   15     0   2   98 97                       195.0 170 2 4 2   15     0   2   98 97                 195
2043774 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Middle 04 06 2019   grade_4 179 10 18 0   5     0   9   124 97                       221.0 179 10 18 0   5     0   9   124 97                 221
2043908 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2019   grade_9 181 1 5 0   10     0   8   108 97                       205.0 181 1 5 0   10     0   8   108 97                 205
2043964 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2019   grade_8 157 1 9 1   5     0   2   78 97                       175.0 157 1 9 1   5     0   2   78 97                 175
2044441 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2019   grade_12 167 3 9 0   3     0   2   87 97                       184.0 167 3 9 0   3     0   2   87 97                 184
2044780 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2019   grade_11 190 1 4 0   5     0   1   104 97                       201.0 190 1 4 0   5     0   1   104 97                 201
2045714 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2019   grade_8 186 4 8 0   2     0   6   109 97                       206.0 186 4 8 0   2     0   6   109 97                 206
2046181 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham High   Regular School No High 09 12 2019   grade_10 147 4 19 0   10     0   8   91 97                       188.0 147 4 19 0   10     0   8   91 97                 188
2046860 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2019   grade_6 144 1 6 0   45     0   8   107 97                       204.0 144 1 6 0   45     0   8   107 97                 204
2048458 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2019   grade_9 152 1 6 0   19     0   4   85 97                       182.0 152 1 6 0   19     0   4   85 97                 182
2048459 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2019   grade_10 171 2 3 0   14     0   1   94 97                       191.0 171 2 3 0   14     0   1   94 97                 191
2049155 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 125 50 24 1   5     0   9   117 97                       214.0 125 50 24 1   5     0   9   117 97                 214
2040011 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2019   grade_3 124 3 27 0   30     0   7   95 96                       191.0 124 3 27 0   30     0   7   95 96                 191
2040081 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_9 141 4 14 0   6     0   8   77 96                       173.0 141 4 14 0   6     0   8   77 96                 173
2042392 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2019   grade_10 155 11 8 0   7     0   1   86 96                       182.0 155 11 8 0   7     0   1   86 96                 182
2042514 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_2 124 2 39 0   3     0   11   83 96                       179.0 124 2 39 0   3     0   11   83 96                 179
2042522 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_7 127 8 36 0   1     0   17   93 96                       189.0 127 8 36 0   1     0   17   93 96                 189
2042606 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2019   grade_11 164 3 7 0   21     0   6   105 96                       201.0 164 3 7 0   21     0   6   105 96                 201
2042869 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2019   grade_12 161 1 7 0   11     0   4   88 96                       184.0 161 1 7 0   11     0   4   88 96                 184
2043517 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2019   grade_6 179 7 19 2   0     0   4   115 96                       211.0 179 7 19 2   0     0   4   115 96                 211
2044065 MA Plymouth   school 2507770 182   Middleborough 250777002626 1820011 Memorial Early Childhood Center   Regular School No Elementary PK KG 2019   kindergarten 192 2 5 0   5     0   1   109 96                       205.0 192 2 5 0   5     0   1   109 96                 205
2044625 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2019   grade_11 145 6 34 0   6     0   12   107 96                       203.0 145 6 34 0   6     0   12   107 96                 203
2045080 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2019   grade_12 127 17 28 0   3     0   11   90 96                       186.0 127 17 28 0   3     0   11   90 96                 186
2045355 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2019   grade_8 94 6 88 1   6     1   2   102 96                       198.0 94 6 88 1   6     1   2   102 96                 198
2045382 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2019   grade_6 70 7 114 0   7     0   3   105 96                       201.0 70 7 114 0   7     0   3   105 96                 201
2046362 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2019   grade_7 155 35 20 1   2     0   15   132 96                       228.0 155 35 20 1   2     0   15   132 96                 228
2046670 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2019   grade_12 143 6 7 0   38     0   10   108 96                       204.0 143 6 7 0   38     0   10   108 96                 204
2046891 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston High   Regular School No High 09 12 2019   grade_9 107 11 7 2   31     0   6   68 96                       164.0 107 11 7 2   31     0   6   68 96                 164
2048455 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2019   grade_6 162 5 5 0   9     0   4   89 96                       185.0 162 5 5 0   9     0   4   89 96                 185
2048456 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2019   grade_7 182 2 2 1   8     1   4   104 96                       200.0 182 2 2 1   8     1   4   104 96                 200
2048460 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2019   grade_11 168 1 1 0   10     1   0   85 96                       181.0 168 1 1 0   10     1   0   85 96                 181
2048598 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2019   grade_6 177 0 11 0   6     0   7   105 96                       201.0 177 0 11 0   6     0   7   105 96                 201
2048885 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2019   grade_7 170 1 7 0   3     0   2   87 96                       183.0 170 1 7 0   3     0   2   87 96                 183
2049014 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No High 09 12 2019   grade_12 167 0 9 0   2     0   2   84 96                       180.0 167 0 9 0   2     0   2   84 96                 180
2039948 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2019   grade_8 138 2 6 1   24     0   6   82 95                       177.0 138 2 6 1   24     0   6   82 95                 177
2040136 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2019   grade_8 126 14 12 0   32     0   7   96 95                       191.0 126 14 12 0   32     0   7   96 95                 191
2040145 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Middle 04 06 2019   grade_5 162 2 8 1   2     0   3   83 95                       178.0 162 2 8 1   2     0   3   83 95                 178
2040978 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2019   grade_9 5 88 137 2   4     0   5   146 95                       241.0 5 88 137 2   4     0   5   146 95                 241
2040980 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2019   grade_11 2 72 113 1   2     1   4   100 95                       195.0 2 72 113 1   2     1   4   100 95                 195
2041301 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2019   grade_8 22 146 30 0   6     0   11   120 95                       215.0 22 146 30 0   6     0   11   120 95                 215
2041914 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2019   grade_10 128 18 29 0   6     0   7   93 95                       188.0 128 18 29 0   6     0   7   93 95                 188
2041976 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2019   grade_11 160 18 10 2   13     0   4   112 95                       207.0 160 18 10 2   13     0   4   112 95                 207
2042264 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_8 114 14 41 1   13     0   16   104 95                       199.0 114 14 41 1   13     0   16   104 95                 199
2042744 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_7 147 12 35 0   3     1   3   106 95                       201.0 147 12 35 0   3     1   3   106 95                 201
2042793 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_7 109 10 95 1   3     0   1   124 95                       219.0 109 10 95 1   3     0   1   124 95                 219
2044781 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2019   grade_12 171 1 3 0   5     0   4   89 95                       184.0 171 1 3 0   5     0   4   89 95                 184
2044818 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No Middle 06 08 2019   grade_8 162 0 0 1   3     0   3   74 95                       169.0 162 0 0 1   3     0   3   74 95                 169
2045354 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2019   grade_7 56 11 115 1   10     0   5   103 95                       198.0 56 11 115 1   10     0   5   103 95                 198
2045516 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2019   grade_2 165 1 10 1   5     0   4   91 95                       186.0 165 1 10 1   5     0   4   91 95                 186
2046183 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham High   Regular School No High 09 12 2019   grade_12 151 7 7 0   4     0   2   76 95                       171.0 151 7 7 0   4     0   2   76 95                 171
2046370 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2019   grade_7 82 48 29 2   2     0   14   82 95                       177.0 82 48 29 2   2     0   14   82 95                 177
2046667 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2019   grade_9 129 9 8 0   42     1   10   104 95                       199.0 129 9 8 0   42     1   10   104 95                 199
2046680 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2019   grade_8 87 12 40 0   2     0   9   55 95                       150.0 87 12 40 0   2     0   9   55 95                 150
2048141 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2019   grade_10 163 0 5 0   4     0   2   79 95                       174.0 163 0 5 0   4     0   2   79 95                 174
2048349 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2019   grade_8 135 7 7 1   17     0   10   82 95                       177.0 135 7 7 1   17     0   10   82 95                 177
2048413 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2019   grade_12 174 3 4 1   2     0   8   97 95                       192.0 174 3 4 1   2     0   8   97 95                 192
2048785 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2019   grade_8 206 2 5 0   4     0   8   130 95                       225.0 206 2 5 0   4     0   8   130 95                 225
2048818 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No High 09 12 2019   grade_10 182 4 3 0   8     0   3   105 95                       200.0 182 4 3 0   8     0   3   105 95                 200
2040016 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2019   grade_8 123 3 25 2   30     0   2   91 94                       185.0 123 3 25 2   30     0   2   91 94                 185

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