Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by male descending

View and edit SQL

year

  • 2020 · 9,537
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
1365071 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 94 9 29 0   3     0   26   99 62 *                     161.0 94 9 29 0   3     0   26   99 62                 161
1366240 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2020   grade_8 52 82 70 0   9     0   10   99 124 *                     223.0 52 82 70 0   9     0   10   99 124                 223
1366595 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_6 11 6 171 1   1     1   2   99 94 *                     193.0 11 6 171 1   1     1   2   99 94                 193
1366979 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2020   grade_6 165 6 10 0   19     0   9   99 110 *                     209.0 165 6 10 0   19     0   9   99 110                 209
1367191 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_7 127 19 46 1   6     1   16   99 117 *                     216.0 127 19 46 1   6     1   16   99 117                 216
1367610 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_7 193 6 7 0   6     0   3   99 116 *                     215.0 193 6 7 0   6     0   3   99 116                 215
1367786 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2020   grade_10 179 3 10 0   22     0   4   99 119 *                     218.0 179 3 10 0   22     0   4   99 119                 218
1367787 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2020   grade_11 169 2 5 2   15     0   2   99 96 *                     195.0 169 2 5 2   15     0   2   99 96                 195
1367911 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2020   grade_5 161 8 31 0   5     0   2   99 108 *                     207.0 161 8 31 0   5     0   2   99 108                 207
1367914 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2020   grade_8 181 1 25 0   8     0   2   99 118 *                     217.0 181 1 25 0   8     0   2   99 118                 217
1368398 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2020   grade_5 58 11 69 0   13     0   9   99 61 *                     160.0 58 11 69 0   13     0   9   99 61                 160
1368406 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2020   grade_5 20 4 63 0   74     0   7   99 69 *                     168.0 20 4 63 0   74     0   7   99 69                 168
1368627 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2020   grade_5 153 1 15 0   11     0   6   99 87 *                     186.0 153 1 15 0   11     0   6   99 87                 186
1369721 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2020   grade_7 173 3 9 0   3     0   10   99 99 *                     198.0 173 3 9 0   3     0   10   99 99                 198
1370358 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2020   grade_6 145 11 32 0   3     0   3   99 95 *                     194.0 145 11 32 0   3     0   3   99 95                 194
1373066 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2020   grade_8 176 2 15 1   1     0   2   99 98 *                     197.0 176 2 15 1   1     0   2   99 98                 197
1373287 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2020   grade_8 138 3 10 1   17     0   8   99 78 *                     177.0 138 3 10 1   17     0   8   99 78                 177
1374147 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 134 3 8 1   0     0   5   99 52 *                     151.0 134 3 8 1   0     0   5   99 52                 151
1365106 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2020   grade_3 121 14 12 0   35     0   15   98 99 *                     197.0 121 14 12 0   35     0   15   98 99                 197
1365144 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2020   grade_8 150 3 13 1   8     0   7   98 84 *                     182.0 150 3 13 1   8     0   7   98 84                 182
1365959 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2020   grade_8 92 66 69 0   36     0   6   98 171 *                     269.0 92 66 69 0   36     0   6   98 171                 269
1366119 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2020   grade_6 145 6 4 2   52     0   3   98 114 *                     212.0 145 6 4 2   52     0   3   98 114                 212
1366156 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2020   grade_1 15 95 73 0   1     0   5   98 91 *                     189.0 15 95 73 0   1     0   5   98 91                 189
1366909 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2020   grade_3 194 0 5 0   2     0   5   98 108 *                     206.0 194 0 5 0   2     0   5   98 108                 206
1367188 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2020   grade_7 81 10 63 0   8     0   13   98 77 *                     175.0 81 10 63 0   8     0   13   98 77                 175
1367615 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2020   grade_12 182 0 2 0   6     0   0   98 92 *                     190.0 182 0 2 0   6     0   0   98 92                 190
1368156 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2020   grade_12 78 9 48 0   1     3   5   98 46 *                     144.0 78 9 48 0   1     3   5   98 46                 144
1368401 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2020   grade_8 56 16 71 0   27     0   5   98 77 *                     175.0 56 16 71 0   27     0   5   98 77                 175
1368439 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2020   grade_11 186 4 10 0   0     0   8   98 109 *                     208.0 186 4 10 0   0     0   8   98 109                 208
1368966 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2020   grade_7 55 5 99 0   7     0   7   98 75 *                     173.0 55 5 99 0   7     0   7   98 75                 173
1369000 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2020   grade_11 167 5 4 0   1     0   5   98 84 *                     182.0 167 5 4 0   1     0   5   98 84                 182
1369702 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading Middle   Regular School No Middle 06 08 2020   grade_7 168 0 6 0   6     0   3   98 85 *                     183.0 168 0 6 0   6     0   3   98 85                 183
1369744 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No Middle 06 08 2020   grade_8 148 0 3 0   5     1   5   98 64 *                     162.0 148 0 3 0   5     1   5   98 64                 162
1369997 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2020   grade_6 108 17 28 1   2     0   21   98 79 *                     177.0 108 17 28 1   2     0   21   98 79                 177
1370005 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2020   grade_11 131 23 28 1   7     0   7   98 99 *                     197.0 131 23 28 1   7     0   7   98 99                 197
1370845 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK KG 2020   pre_kindergarten 23 37 116 1   3     0   7   98 89 *                     187.0 23 37 116 1   3     0   7   98 89                 187
1370995 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2020   grade_6 19 44 100 1   4     0   0   98 70 *                     168.0 19 44 100 1   4     0   0   98 70                 168
1371108 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham High   Regular School No High 09 12 2020   grade_12 152 4 13 0   7     0   4   98 82 *                     180.0 152 4 13 0   7     0   4   98 82                 180
1372909 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2020   grade_10 190 5 19 2   3     0   3   98 123 *                     222.0 190 5 19 2   3     0   3   98 123                 222
1373257 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_11 119 16 23 5   5     0   8   98 78 *                     176.0 119 16 23 5   5     0   8   98 78                 176
1373318 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_7 175 9 13 1   3     0   2   98 105 *                     203.0 175 9 13 1   3     0   2   98 105                 203
1374088 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 113 16 21 4   1     0   7   98 63 *                     162.0 113 16 21 4   1     0   7   98 63                 162
1374096 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Technical   Career and Technical School No High 09 12 2020   grade_9 138 0 13 0   0     0   2   98 55 *                     153.0 138 0 13 0   0     0   2   98 55                 153
1374120 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2020   grade_12 78 14 72 3   0     0   8   98 77 *                     175.0 78 14 72 3   0     0   8   98 77                 175
1364920 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_7 124 5 11 0   28     0   8   97 79 *                     176.0 124 5 11 0   28     0   8   97 79                 176
1365022 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_7 124 12 23 0   5     0   11   97 78 *                     175.0 124 12 23 0   5     0   11   97 78                 175
1366561 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_5 131 5 14 0   27     1   14   97 95 *                     192.0 131 5 14 0   27     1   14   97 95                 192
1366562 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_6 140 5 9 0   34     0   7   97 98 *                     195.0 140 5 9 0   34     0   7   97 98                 195
1366975 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2020   grade_2 151 1 24 0   8     0   9   97 96 *                     193.0 151 1 24 0   8     0   9   97 96                 193
1367187 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2020   grade_6 81 14 60 1   6     0   25   97 90 *                     187.0 81 14 60 1   6     0   25   97 90                 187
1367267 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_6 52 16 94 0   7     0   14   97 86 *                     183.0 52 16 94 0   7     0   14   97 86                 183
1367452 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2020   grade_8 131 6 41 0   1     0   12   97 94 *                     191.0 131 6 41 0   1     0   12   97 94                 191
1367602 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 01 2020   kindergarten 191 2 1 0   3     0   1   97 101 *                     198.0 191 2 1 0   3     0   1   97 101                 198
1368440 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2020   grade_12 167 5 14 1   2     0   6   97 98 *                     195.0 167 5 14 1   2     0   6   97 98                 195
1371501 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_7 92 16 47 0   9     0   4   97 71 *                     168.0 92 16 47 0   9     0   4   97 71                 168
1371820 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston High   Regular School No High 09 12 2020   grade_12 116 12 4 0   35     0   3   97 73 *                     170.0 116 12 4 0   35     0   3   97 73                 170
1371993 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2020   grade_9 166 3 7 0   9     0   10   97 98 *                     195.0 166 3 7 0   9     0   10   97 98                 195
1373065 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2020   grade_7 175 1 7 0   1     0   6   97 93 *                     190.0 175 1 7 0   1     0   6   97 93                 190
1373390 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2020   grade_5 169 2 3 0   18     1   4   97 100 *                     197.0 169 2 3 0   18     1   4   97 100                 197
1373394 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2020   grade_9 146 1 5 1   11     1   3   97 71 *                     168.0 146 1 5 1   11     1   3   97 71                 168
1373396 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2020   grade_11 171 2 3 0   15     0   1   97 94 *                     192.0 171 2 3 0   15     0   1   97 94                 192
1373520 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2020   grade_10 93 10 42 4   2     1   5   97 60 *                     157.0 93 10 42 4   2     1   5   97 60                 157
1374136 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Career and Technical School No High 09 12 2020   grade_12 146 0 10 1   1     0   4   97 65 *                     162.0 146 0 10 1   1     0   4   97 65                 162
1364790 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_5 138 5 16 0   5     0   3   96 71 *                     167.0 138 5 16 0   5     0   3   96 71                 167
1364850 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_5 150 1 16 1   5     0   8   96 85 *                     181.0 150 1 16 1   5     0   8   96 85                 181
1364851 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_6 128 4 18 0   2     0   10   96 66 *                     162.0 128 4 18 0   2     0   10   96 66                 162
1365115 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2020   grade_12 133 11 17 0   25     1   7   96 98 *                     194.0 133 11 17 0   25     1   7   96 98                 194
1365257 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 05 07 2020   grade_6 141 3 8 0   12     0   8   96 76 *                     172.0 141 3 8 0   12     0   8   96 76                 172
1366236 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_7 64 117 25 2   7     2   4   96 125 *                     221.0 64 117 25 2   7     2   4   96 125                 221
1366506 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2020   grade_9 148 20 14 0   20     0   11   96 117 *                     213.0 148 20 14 0   20     0   11   96 117                 213
1366596 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_7 10 6 147 1   2     0   2   96 72 *                     168.0 10 6 147 1   2     0   2   96 72                 168
1367448 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2020   grade_1 102 3 38 0   0     0   17   96 64 *                     160.0 102 3 38 0   0     0   17   96 64                 160
1368387 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2020   grade_7 41 8 34 0   76     0   7   96 70 *                     166.0 41 8 34 0   76     0   7   96 70                 166
1368835 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2020   grade_7 156 1 12 0   7     0   10   96 90 *                     186.0 156 1 12 0   7     0   10   96 90                 186
1369613 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 113 5 9 0   25     0   7   96 63 *                     159.0 113 5 9 0   25     0   7   96 63                 159
1369653 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_8 148 8 14 0   21     2   11   96 108 *                     204.0 148 8 14 0   21     2   11   96 108                 204
1371525 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2020   kindergarten 138 11 16 3   2     0   28   96 102 *                     198.0 138 11 16 3   2     0   28   96 102                 198
1371570 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No High 09 12 2020   grade_11 112 10 40 2   18     0   2   96 88 *                     184.0 112 10 40 2   18     0   2   96 88                 184
1372908 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2020   grade_9 185 5 11 1   10     0   5   96 120 *                     217.0 185 5 11 1   10     0   5   96 120                 217
1373346 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2020   grade_9 185 3 1 0   1     0   1   96 95 *                     191.0 185 3 1 0   1     0   1   96 95                 191
1373757 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No High 09 12 2020   grade_9 154 1 5 0   2     0   3   96 69 *                     165.0 154 1 5 0   2     0   3   96 69                 165
1374142 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 129 0 4 0   1     0   5   96 43 *                     139.0 129 0 4 0   1     0   5   96 43                 139
1365870 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2020   grade_8 4 70 77 0   8     0   6   95 70 *                     165.0 4 70 77 0   8     0   6   95 70                 165
1366017 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2020   grade_6 20 7 150 0   8     0   4   95 94 *                     189.0 20 7 150 0   8     0   4   95 94                 189
1366594 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_5 13 6 159 0   1     0   2   95 86 *                     181.0 13 6 159 0   1     0   2   95 86                 181
1366844 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2020   grade_10 122 12 30 0   2     0   4   95 74 *                     170.0 122 12 30 0   2     0   4   95 74                 170
1367111 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No High 09 12 2020   grade_11 169 0 9 1   7     0   1   95 92 *                     187.0 169 0 9 1   7     0   1   95 92                 187
1367381 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2020   grade_8 108 15 43 0   6     0   8   95 85 *                     180.0 108 15 43 0   6     0   8   95 85                 180
1367964 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No Elementary PK KG 2020   pre_kindergarten 12 4 164 0   3     0   1   95 89 *                     184.0 12 4 164 0   3     0   1   95 89                 184
1368155 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2020   grade_11 83 10 49 0   2     0   4   95 53 *                     148.0 83 10 49 0   2     0   4   95 53                 148
1368706 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_6 167 4 15 0   3     0   8   95 102 *                     197.0 167 4 15 0   3     0   8   95 102                 197
1369156 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2020   grade_7 124 5 12 0   13     0   13   95 72 *                     167.0 124 5 12 0   13     0   13   95 72                 167
1369366 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2020   grade_10 171 1 3 0   2     0   5   95 87 *                     182.0 171 1 3 0   2     0   5   95 87                 182
1370223 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2020   grade_11 9 79 24 0   41     1   4   95 63 *                     158.0 9 79 24 0   41     1   4   95 63                 158
1370282 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2020   grade_8 51 10 109 1   8     0   5   95 89 *                     184.0 51 10 109 1   8     0   5   95 89                 184
1371322 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2020   grade_9 173 9 6 1   7     0   2   95 103 *                     198.0 173 9 6 1   7     0   2   95 103                 198
1371531 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2020   grade_5 115 21 17 1   1     1   20   95 81 *                     176.0 115 21 17 1   1     1   20   95 81                 176
1371786 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2020   grade_8 115 0 7 0   60     0   4   95 91 *                     186.0 115 0 7 0   60     0   4   95 91                 186
1372455 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_8 19 9 142 1   3     1   2   95 82 *                     177.0 19 9 142 1   3     1   2   95 82                 177
1373317 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_6 154 7 14 0   5     0   5   95 89 *                     185.0 154 7 14 0   5     0   5   95 89                 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]);