enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by non_binary descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1368046 1368046 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_9 20 5 879 0   12     0   3   483 429 7                     919.0 20 5 879 0   12     0   3   483 429 7               919
1367970 1367970 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   kindergarten 2 0 95 0   0     0   0   50 42 5                     97.0 2 0 95 0   0     0   0   50 42 5               97
1681321 1681321 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Regional Vocational Technical - Assabet Valley Vocational High School   Career and Technical School No High 09 12 2021   grade_10 216 8 61 1   0     0   5   177 109 5                     291.0 216 8 61 1   0     0   5   177 109 5               291
1681376 1681376 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical - Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_12 263 7 59 0   6     0   10   167 173 5                     345.0 263 7 59 0   6     0   10   167 173 5               345
1366343 1366343 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_10 323 32 64 0   83     1   54   296 257 4                     557.0 323 32 64 0   83     1   54   296 257 4               557
1676448 1676448 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham - Needham High   Regular School No High 09 12 2021   grade_9 322 10 30 0   38     1   23   204 216 4                     424.0 322 10 30 0   38     1   23   204 216 4               424
1681360 1681360 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 197 39 221 1   115     0   23   268 324 4                     596.0 197 39 221 1   115     0   23   268 324 4               596
1681374 1681374 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical - Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_10 260 5 63 0   8     0   18   163 187 4                     354.0 260 5 63 0   8     0   18   163 187 4               354
1366345 1366345 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_12 254 39 48 0   87     0   46   250 221 3                     474.0 254 39 48 0   87     0   46   250 221 3               474
1368047 1368047 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_10 28 16 833 0   8     0   1   489 394 3                     886.0 28 16 833 0   8     0   1   489 394 3               886
1374072 1374072 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2020   grade_9 221 10 63 1   0     0   5   182 115 3                     300.0 221 10 63 1   0     0   5   182 115 3               300
1374112 1374112 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 240 30 229 0   108     0   0   329 275 3                     607.0 240 30 229 0   108     0   0   329 275 3               607
1374113 1374113 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 208 29 221 2   96     0   28   287 294 3                     584.0 208 29 221 2   96     0   28   287 294 3               584
1374125 1374125 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 265 5 63 0   9     0   16   158 197 3                     358.0 265 5 63 0   9     0   16   158 197 3               358
1675292 1675292 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_10 17 4 854 0   13     0   2   466 421 3                     890.0 17 4 854 0   13     0   2   466 421 3               890
1681361 1681361 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_10 231 30 219 0   104     0   0   321 260 3                     584.0 231 30 219 0   104     0   0   321 260 3               584
1681362 1681362 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_11 198 29 214 2   89     0   28   276 281 3                     560.0 198 29 214 2   89     0   28   276 281 3               560
1366344 1366344 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_11 268 43 67 0   89     1   44   245 265 2                     512.0 268 43 67 0   89     1   44   245 265 2               512
1368048 1368048 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_11 23 5 674 0   20     0   1   372 349 2                     723.0 23 5 674 0   20     0   1   372 349 2               723
1374073 1374073 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2020   grade_10 202 8 75 1   3     0   9   180 116 2                     298.0 202 8 75 1   3     0   9   180 116 2               298
1374127 1374127 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 271 7 59 0   6     0   10   170 181 2                     353.0 271 7 59 0   6     0   10   170 181 2               353
1675291 1675291 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_9 19 13 735 1   14     0   3   425 358 2                     785.0 19 13 735 1   14     0   3   425 358 2               785
1675293 1675293 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_11 22 13 703 0   6     0   1   389 354 2                     745.0 22 13 703 0   6     0   1   389 354 2               745
1676450 1676450 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham - Needham High   Regular School No High 09 12 2021   grade_11 345 10 18 2   44     1   25   214 229 2                     445.0 345 10 18 2   44     1   25   214 229 2               445
1681320 1681320 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Regional Vocational Technical - Assabet Valley Vocational High School   Career and Technical School No High 09 12 2021   grade_9 219 1 78 0   2     0   6   166 138 2                     306.0 219 1 78 0   2     0   6   166 138 2               306
1681322 1681322 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Regional Vocational Technical - Assabet Valley Vocational High School   Career and Technical School No High 09 12 2021   grade_11 192 8 71 1   3     0   8   169 112 2                     283.0 192 8 71 1   3     0   8   169 112 2               283
1681323 1681323 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Regional Vocational Technical - Assabet Valley Vocational High School   Career and Technical School No High 09 12 2021   grade_12 217 2 42 0   1     0   7   160 107 2                     269.0 217 2 42 0   1     0   7   160 107 2               269
1681375 1681375 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical - Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_11 269 10 64 0   6     0   14   186 175 2                     363.0 269 10 64 0   6     0   14   186 175 2               363
1681381 1681381 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Regional Vocational Technical - Nashoba Valley Technical High School   Career and Technical School No High 09 12 2021   grade_9 153 3 20 0   3     0   11   112 76 2                     190.0 153 3 20 0   3     0   11   112 76 2               190
1681382 1681382 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Regional Vocational Technical - Nashoba Valley Technical High School   Career and Technical School No High 09 12 2021   grade_10 155 2 17 2   1     1   1   102 75 2                     179.0 155 2 17 2   1     1   1   102 75 2               179
1681384 1681384 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Regional Vocational Technical - Nashoba Valley Technical High School   Career and Technical School No High 09 12 2021   grade_12 152 7 8 0   6     0   3   111 63 2                     176.0 152 7 8 0   6     0   3   111 63 2               176
1681527 1681527 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_9 81 8 27 1   4     1   10   62 68 2                     132.0 81 8 27 1   4     1   10   62 68 2               132
1681528 1681528 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_10 64 9 25 0   5     0   9   49 61 2                     112.0 64 9 25 0   5     0   9   49 61 2               112
1681530 1681530 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_12 66 6 16 0   1     0   4   24 67 2                     93.0 66 6 16 0   1     0   4   24 67 2               93
1368049 1368049 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_12 21 9 717 0   11     0   2   401 349 10                     760.0 21 9 717 0   11     0   2   401 349 10               760
1367971 1367971 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   grade_1 5 1 114 0   0     0   0   61 58 1                     120.0 5 1 114 0   0     0   0   61 58 1               120
1367974 1367974 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   grade_4 4 2 117 0   0     0   0   72 50 1                     123.0 4 2 117 0   0     0   0   72 50 1               123
1374074 1374074 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2020   grade_11 224 2 43 0   1     0   7   160 116 1                     277.0 224 2 43 0   1     0   7   160 116 1               277
1374126 1374126 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 281 10 66 0   6     0   14   198 178 1                     377.0 281 10 66 0   6     0   14   198 178 1               377
1675294 1675294 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_12 18 5 639 1   20     0   1   347 336 1                     684.0 18 5 639 1   20     0   1   347 336 1               684
1681373 1681373 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical - Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 268 7 58 0   6     0   16   175 179 1                     355.0 268 7 58 0   6     0   16   175 179 1               355
1681525 1681525 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_7 63 6 17 0   7     0   8   54 46 1                     101.0 63 6 17 0   7     0   8   54 46 1               101
1681529 1681529 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_11 53 5 15 0   5     0   9   35 51 1                     87.0 53 5 15 0   5     0   9   35 51 1               87
1366342 1366342 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   grade_9 281 48 54 0   81     0   57   253 268 0                     521.0 281 48 54 0   81     0   57   253 268 0               521
1366346 1366346 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2020   sped_beyond_grade_12 8 2 4 0   1     0   4   16 3 0                     19.0 8 2 4 0   1     0   4   16 3 0               19
1367972 1367972 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   grade_2 2 0 120 0   0     0   0   64 58 0                     122.0 2 0 120 0   0     0   0   64 58 0               122
1367973 1367973 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   grade_3 2 2 127 0   0     0   1   63 69 0                     132.0 2 2 127 0   0     0   1   63 69 0               132
1368050 1368050 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   sped_beyond_grade_12 2 1 29 0   1     0   0   20 13 0                     33.0 2 1 29 0   1     0   0   20 13 0               33
1374075 1374075 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2020   grade_12 222 1 34 1   2     0   6   165 101 0                     266.0 222 1 34 1   2     0   6   165 101 0               266
1374114 1374114 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 251 21 180 1   85     0   19   301 256 0                     557.0 251 21 180 1   85     0   19   301 256 0               557
1374115 1374115 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 236 16 166 1   77     0   14   272 238 0                     510.0 236 16 166 1   77     0   14   272 238 0               510
1374116 1374116 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2020   sped_beyond_grade_12 5 0 4 1   3     0   0   10 3 0                     13.0 5 0 4 1   3     0   0   10 3 0               13
1374128 1374128 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 264 5 56 0   5     0   12   178 164 0                     342.0 264 5 56 0   5     0   12   178 164 0               342
1675295 1675295 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   sped_beyond_grade_12 3 1 23 0   1     0   0   17 11 0                     28.0 3 1 23 0   1     0   0   17 11 0               28
1676449 1676449 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham - Needham High   Regular School No High 09 12 2021   grade_10 303 4 26 0   27     0   17   187 190 0                     377.0 303 4 26 0   27     0   17   187 190 0               377
1676451 1676451 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham - Needham High   Regular School No High 09 12 2021   grade_12 345 8 18 0   35     0   17   208 215 0                     423.0 345 8 18 0   35     0   17   208 215 0               423
1681363 1681363 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_12 245 21 171 1   81     0   19   292 246 0                     538.0 245 21 171 1   81     0   19   292 246 0               538
1681364 1681364 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   sped_beyond_grade_12 9 1 4 1   3     0   0   13 5 0                     18.0 9 1 4 1   3     0   0   13 5 0               18
1681383 1681383 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Regional Vocational Technical - Nashoba Valley Technical High School   Career and Technical School No High 09 12 2021   grade_11 153 5 10 0   4     0   8   111 69 0                     180.0 153 5 10 0   4     0   8   111 69 0               180
1681518 1681518 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   kindergarten 17 3 7 0   2     0   3   14 18 0                     32.0 17 3 7 0   2     0   3   14 18 0               32
1681519 1681519 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_1 23 3 10 0   1     0   0   16 21 0                     37.0 23 3 10 0   1     0   0   16 21 0               37
1681520 1681520 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_2 22 2 10 0   4     0   2   18 22 0                     40.0 22 2 10 0   4     0   2   18 22 0               40
1681521 1681521 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_3 29 6 9 0   5     0   2   20 31 0                     51.0 29 6 9 0   5     0   2   20 31 0               51
1681522 1681522 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_4 30 6 5 0   3     0   2   18 28 0                     46.0 30 6 5 0   3     0   2   18 28 0               46
1681523 1681523 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_5 31 5 8 0   2     0   2   27 21 0                     48.0 31 5 8 0   2     0   2   27 21 0               48
1681524 1681524 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_6 32 8 9 0   1     2   3   33 22 0                     55.0 32 8 9 0   1     2   3   33 22 0               55
1681526 1681526 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_8 64 4 20 0   9     0   12   57 52 0                     109.0 64 4 20 0   9     0   12   57 52 0               109
1364784 1364784 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 68 9 7 0   4     0   0   43 45 *                     88.0 68 9 7 0   4     0   0   43 45                 88
1364785 1364785 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_3 135 6 21 0   2     1   0   81 84 *                     165.0 135 6 21 0   2     1   0   81 84                 165
1364786 1364786 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_4 110 7 11 0   5     0   3   61 75 *                     136.0 110 7 11 0   5     0   3   61 75                 136
1364787 1364787 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   kindergarten 131 9 22 1   4     0   2   82 86 *                     169.0 131 9 22 1   4     0   2   82 86                 169
1364788 1364788 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_1 130 9 9 3   5     0   1   80 77 *                     157.0 130 9 9 3   5     0   1   80 77                 157
1364789 1364789 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_2 119 10 10 2   3     0   1   68 77 *                     145.0 119 10 10 2   3     0   1   68 77                 145
1364790 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
1364791 1364791 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_6 137 6 20 2   4     0   3   92 80 *                     172.0 137 6 20 2   4     0   3   92 80                 172
1364792 1364792 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_7 139 3 12 1   4     0   5   86 78 *                     164.0 139 3 12 1   4     0   5   86 78                 164
1364793 1364793 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_8 164 6 14 0   3     0   0   106 81 *                     187.0 164 6 14 0   3     0   0   106 81                 187
1364794 1364794 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_9 125 7 20 0   6     0   2   75 85 *                     160.0 125 7 20 0   6     0   2   75 85                 160
1364795 1364795 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_10 127 10 12 0   4     0   3   80 76 *                     156.0 127 10 12 0   4     0   3   80 76                 156
1364796 1364796 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_11 127 8 15 0   3     0   1   80 74 *                     154.0 127 8 15 0   3     0   1   80 74                 154
1364797 1364797 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_12 102 3 6 0   4     0   2   55 62 *                     117.0 102 3 6 0   4     0   2   55 62                 117
1364798 1364798 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   sped_beyond_grade_12 5 0 1 0   0     0   0   3 3 *                     6.0 5 0 1 0   0     0   0   3 3                 6
1364799 1364799 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   kindergarten 79 1 5 0   1     0   3   51 38 *                     89.0 79 1 5 0   1     0   3   51 38                 89
1364800 1364800 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten 39 1 4 0   0     0   2   28 18 *                     46.0 39 1 4 0   0     0   2   28 18                 46
1364801 1364801 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_1 118 1 2 0   2     0   4   62 65 *                     127.0 118 1 2 0   2     0   4   62 65                 127
1364802 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
1364803 1364803 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_3 74 1 4 1   0     0   5   44 41 *                     85.0 74 1 4 1   0     0   5   44 41                 85
1364804 1364804 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_4 99 0 4 0   1     0   7   56 55 *                     111.0 99 0 4 0   1     0   7   56 55                 111
1364805 1364805 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_5 97 0 8 0   1     0   4   49 61 *                     110.0 97 0 8 0   1     0   4   49 61                 110
1364806 1364806 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_6 97 1 2 0   1     0   0   57 44 *                     101.0 97 1 2 0   1     0   0   57 44                 101
1364807 1364807 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_7 99 0 6 0   1     0   6   62 50 *                     112.0 99 0 6 0   1     0   6   62 50                 112
1364808 1364808 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_8 112 2 2 0   1     0   3   62 58 *                     120.0 112 2 2 0   1     0   3   62 58                 120
1364809 1364809 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 114 6 18 0   15     0   7   93 67 *                     160.0 114 6 18 0   15     0   7   93 67                 160
1364810 1364810 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   kindergarten 45 1 7 0   4     0   1   24 34 *                     58.0 45 1 7 0   4     0   1   24 34                 58
1364811 1364811 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_1 26 1 9 0   5     0   0   23 18 *                     41.0 26 1 9 0   5     0   0   23 18                 41
1364812 1364812 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_2 28 1 6 0   3     0   0   20 18 *                     38.0 28 1 6 0   3     0   0   20 18                 38
1364813 1364813 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_3 62 2 4 0   0     1   1   32 38 *                     70.0 62 2 4 0   0     1   1   32 38                 70
1364814 1364814 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_4 35 1 11 0   0     0   2   24 25 *                     49.0 35 1 11 0   0     0   2   24 25                 49
1364815 1364815 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   kindergarten 57 1 5 0   3     0   1   36 31 *                     67.0 57 1 5 0   3     0   1   36 31                 67
1364816 1364816 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   grade_1 59 0 2 0   2     0   0   38 25 *                     63.0 59 0 2 0   2     0   0   38 25                 63

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