enrollments

Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,436 ✖
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
1676187 1676187 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen - Marsh Grammar School   Regular School No Elementary PK 08 2021   kindergarten 49 5 38 0   4     0   4   55 45 *                     100.0 49 5 38 0   4     0   4   55 45                 100
1676200 1676200 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen - Comprehensive Grammar School   Regular School No Elementary PK 08 2021   grade_2 45 4 42 0   5     0   4   57 43 *                     100.0 45 4 42 0   5     0   4   57 43                 100
1676382 1676382 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Natick - Brown   Regular School No Elementary KG 04 2021   grade_1 55 2 10 0   27     0   6   54 46 *                     100.0 55 2 10 0   27     0   6   54 46                 100
1676481 1676481 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 New Bedford - Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2021   grade_3 32 15 38 0   1     0   14   51 49 *                     100.0 32 15 38 0   1     0   14   51 49                 100
1676623 1676623 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 Newton - A E Angier   Regular School No Elementary KG 05 2021   grade_4 72 3 3 0   15     0   7   55 45 *                     100.0 72 3 3 0   15     0   7   55 45                 100
1677061 1677061 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Oxford - Alfred M Chaffee   Regular School No Elementary PK 01 2021   grade_1 75 1 15 0   3     0   6   49 51 *                     100.0 75 1 15 0   3     0   6   49 51                 100
1677307 1677307 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 Plymouth - South Elementary   Regular School No Elementary KG 05 2021   grade_2 82 4 4 1   2     0   7   47 53 *                     100.0 82 4 4 1   2     0   7   47 53                 100
1677429 1677429 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy - Point Webster Middle   Regular School No Middle 05 08 2021   grade_6 17 13 21 0   40     5   4   46 54 *                     100.0 17 13 21 0   40     5   4   46 54                 100
1677515 1677515 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 Revere - A. C. Whelan Elementary School   Regular School No Elementary KG 05 2021   kindergarten 39 2 55 1   3     0   0   54 46 *                     100.0 39 2 55 1   3     0   0   54 46                 100
1679028 1679028 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Westford - Col John Robinson   Regular School No Elementary KG 02 2021   grade_2 56 2 1 0   34     0   7   54 46 *                     100.0 56 2 1 0   34     0   7   54 46                 100
1679035 1679035 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Westford - Rita E. Miller Elementary School   Regular School No Elementary PK 02 2021   grade_2 57 4 5 0   31     0   3   58 42 *                     100.0 57 4 5 0   31     0   3   58 42                 100
1679076 1679076 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Westport - Alice A Macomber   Regular School No Elementary PK 02 2021   grade_1 95 0 4 0   0     0   1   50 50 *                     100.0 95 0 4 0   0     0   1   50 50                 100
1679707 1679707 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   kindergarten 20 17 56 1   0     0   6   45 55 *                     100.0 20 17 56 1   0     0   6   45 55                 100
1679752 1679752 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District) - Boston Preparatory Charter Public School   Regular School Yes High 06 12 2021   grade_6 2 61 35 0   0     0   2   46 54 *                     100.0 2 61 35 0   0     0   2   46 54                 100
1679843 1679843 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_5 70 6 12 0   5     0   7   44 56 *                     100.0 70 6 12 0   5     0   7   44 56                 100
1679844 1679844 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_6 71 7 9 0   6     0   7   57 43 *                     100.0 71 7 9 0   6     0   7   57 43                 100
1679846 1679846 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_8 76 3 7 0   13     0   1   54 46 *                     100.0 76 3 7 0   13     0   1   54 46                 100
1679975 1679975 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) - Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2021   grade_9 5 39 47 0   2     0   7   38 62 *                     100.0 5 39 47 0   2     0   7   38 62                 100
1680130 1680130 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_12 1 53 45 0   0     0   1   55 45 *                     100.0 1 53 45 0   0     0   1   55 45                 100
1680154 1680154 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District) - Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2021   grade_7 4 62 24 0   4     2   4   49 51 *                     100.0 4 62 24 0   4     2   4   49 51                 100
1680353 1680353 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol-Royalston - Athol High   Regular School No High 09 12 2021   grade_9 71 4 22 0   1     0   2   49 51 *                     100.0 71 4 22 0   1     0   2   49 51                 100
1680387 1680387 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills - W.E.B. Du Bois Regional Middle School   Regular School No Middle 05 08 2021   grade_8 79 3 11 0   2     0   5   60 40 *                     100.0 79 3 11 0   2     0   5   60 40                 100
1680538 1680538 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth - Dighton Middle School   Regular School No Middle 05 08 2021   grade_7 88 2 4 0   1     0   5   59 41 *                     100.0 88 2 4 0   1     0   5   59 41                 100
1680967 1680967 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 North Middlesex - Varnum Brook   Regular School No Elementary KG 04 2021   kindergarten 87 6 3 0   3     0   1   47 53 *                     100.0 87 6 3 0   3     0   1   47 53                 100
1681118 1681118 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Southwick-Tolland-Granville Regional School District - Powder Mill School   Regular School No Elementary 03 06 2021   grade_4 87 2 6 0   1     0   4   51 49 *                     100.0 87 2 6 0   1     0   4   51 49                 100
1681206 1681206 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Wachusett - Naquag Elementary School   Regular School No Elementary KG 02 2021   kindergarten 86 0 6 0   3     0   5   51 49 *                     100.0 86 0 6 0   3     0   5   51 49                 100
1681306 1681306 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson - Indian Head   Regular School No Elementary KG 04 2021   grade_3 91 3 4 0   1     0   1   52 48 *                     100.0 91 3 4 0   1     0   1   52 48                 100
1681307 1681307 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson - Indian Head   Regular School No Elementary KG 04 2021   grade_4 90 0 5 1   2     0   2   55 45 *                     100.0 90 0 5 1   2     0   2   55 45                 100
1681450 1681450 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District) - Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2021   grade_6 15 17 41 1   26     0   0   55 45 *                     100.0 15 17 41 1   26     0   0   55 45                 100
1672161 1672161 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington - Brackett   Regular School No Elementary KG 05 2021   grade_2 78 0 4 0   6     0   13   55 46 *                     101.0 78 0 4 0   6     0   13   55 46                 101
1672410 1672410 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   grade_4 95 0 2 0   1     0   3   57 44 *                     101.0 95 0 2 0   1     0   3   57 44                 101
1673430 1673430 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_1 13 63 14 0   9     0   2   65 36 *                     101.0 13 63 14 0   9     0   2   65 36                 101
1673431 1673431 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_2 17 59 14 0   5     0   6   56 45 *                     101.0 17 59 14 0   5     0   6   56 45                 101
1673444 1673444 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton - Downey   Regular School No Elementary KG 05 2021   kindergarten 16 64 16 0   0     0   5   52 49 *                     101.0 16 64 16 0   0     0   5   52 49                 101
1674094 1674094 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas - Douglas Middle School   Regular School No Middle 06 08 2021   grade_8 94 1 3 0   1     0   2   47 54 *                     101.0 94 1 3 0   1     0   2   47 54                 101
1674195 1674195 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton - Easthampton High   Regular School No High 09 12 2021   grade_10 80 3 14 0   3     0   1   59 42 *                     101.0 80 3 14 0   3     0   1   59 42                 101
1675005 1675005 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook - Holbrook Middle High School   Regular School No High 06 12 2021   grade_7 51 18 17 1   5     0   9   54 47 *                     101.0 51 18 17 1   5     0   9   54 47                 101
1675100 1675100 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_5 1 4 94 0   1     0   1   52 49 *                     101.0 1 4 94 0   1     0   1   52 49                 101
1675257 1675257 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_5 6 1 94 0   0     0   0   49 52 *                     101.0 6 1 94 0   0     0   0   49 52                 101
1675263 1675263 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence - UP Academy Oliver Middle School   Regular School No Middle 06 08 2021   grade_6 2 2 96 0   1     0   0   56 44 *                     101.0 2 2 96 0   1     0   0   56 44                 101
1675746 1675746 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Lynn - Cobbet Elementary   Regular School No Elementary KG 05 2021   grade_1 2 8 85 0   3     0   3   52 49 *                     101.0 2 8 85 0   3     0   3   52 49                 101
1675782 1675782 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Lynn - Ingalls   Regular School No Elementary KG 05 2021   grade_5 7 10 70 0   7     0   7   49 52 *                     101.0 7 10 70 0   7     0   7   49 52                 101
1675887 1675887 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_2 28 19 26 0   24     0   4   52 49 *                     101.0 28 19 26 0   24     0   4   52 49                 101
1676231 1676231 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_1 89 5 2 0   0     0   5   48 53 *                     101.0 89 5 2 0   0     0   5   48 53                 101
1676234 1676234 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_4 86 1 3 0   2     0   9   47 54 *                     101.0 86 1 3 0   2     0   9   47 54                 101
1676253 1676253 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Middleton - Fuller Meadow   Regular School No Elementary KG 02 2021   grade_2 80 1 8 1   5     0   6   51 50 *                     101.0 80 1 8 1   5     0   6   51 50                 101
1676378 1676378 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Natick - Bennett-Hemenway   Regular School No Elementary KG 04 2021   grade_2 65 5 8 0   15     0   8   48 53 *                     101.0 65 5 8 0   15     0   8   48 53                 101
1676444 1676444 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Needham - Newman Elementary   Regular School No Elementary PK 05 2021   grade_5 74 6 5 0   9     0   7   49 52 *                     101.0 74 6 5 0   9     0   7   49 52                 101
1676848 1676848 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 North Attleborough - Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2021   kindergarten 83 4 5 0   2     0   7   56 45 *                     101.0 83 4 5 0   2     0   7   56 45                 101
1677364 1677364 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy - Lincoln-Hancock Community School   Regular School No Elementary KG 04 2021   grade_3 27 12 9 0   47     1   5   42 59 *                     101.0 27 12 9 0   47     1   5   42 59                 101
1677372 1677372 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy - Clifford H Marshall Elementary   Regular School No Elementary KG 04 2021   kindergarten 26 8 13 1   48     0   5   50 51 *                     101.0 26 8 13 1   48     0   5   50 51                 101
1677376 1677376 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy - Clifford H Marshall Elementary   Regular School No Elementary KG 04 2021   grade_4 32 19 15 0   34     0   1   44 57 *                     101.0 32 19 15 0   34     0   1   44 57                 101
1678641 1678641 MA Middlesex   school 2511910 305   Wakefield 251191001941 3050005 Wakefield - Dolbeare   Regular School No Elementary KG 04 2021   grade_4 86 2 8 0   2     0   3   56 45 *                     101.0 86 2 8 0   2     0   3   56 45                 101
1678642 1678642 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Wakefield - Woodville School   Regular School No Elementary KG 04 2021   kindergarten 76 3 11 0   7     0   4   48 53 *                     101.0 76 3 11 0   7     0   4   48 53                 101
1678769 1678769 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware - Ware Middle School   Regular School No Middle 04 06 2021   grade_6 73 1 16 1   1     0   9   50 51 *                     101.0 73 1 16 1   1     0   9   50 51                 101
1679023 1679023 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Westford - Nabnasset   Regular School No Elementary KG 02 2021   grade_1 76 1 0 0   19     0   5   49 52 *                     101.0 76 1 0 0   19     0   5   49 52                 101
1679266 1679266 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon - Murdock Middle School   Regular School No Middle 06 08 2021   grade_8 83 5 6 0   4     1   2   53 48 *                     101.0 83 5 6 0   4     1   2   53 48                 101
1679908 1679908 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District) - Sabis International Charter School   Regular School Yes Other KG 12 2021   grade_12 38 21 31 0   4     0   7   46 55 *                     101.0 38 21 31 0   4     0   7   46 55                 101
1680315 1680315 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster - Westminster Elementary   Regular School No Elementary 02 05 2021   grade_2 93 0 5 0   1     0   2   53 48 *                     101.0 93 0 5 0   1     0   2   53 48                 101
1680341 1680341 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol-Royalston - Athol Community Elementary School   Regular School No Elementary PK 04 2021   grade_4 84 3 10 0   0     0   4   50 51 *                     101.0 84 3 10 0   0     0   4   50 51                 101
1680738 1680738 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire - Hampshire Regional High   Regular School No High 07 12 2021   grade_9 95 0 2 0   1     0   3   51 50 *                     101.0 95 0 2 0   1     0   3   51 50                 101
1681124 1681124 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District - Southwick Regional School   Regular School No High 07 12 2021   grade_10 92 2 3 0   3     0   1   49 52 *                     101.0 92 2 3 0   3     0   1   49 52                 101
1681126 1681126 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District - Southwick Regional School   Regular School No High 07 12 2021   grade_12 90 2 6 1   1     0   1   51 50 *                     101.0 90 2 6 1   1     0   1   51 50                 101
1681493 1681493 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District) - New Heights Charter School of Brockton   Regular School Yes High 06 12 2021   grade_11 1 92 8 0   0     0   0   49 52 *                     101.0 1 92 8 0   0     0   0   49 52                 101
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
1672394 1672394 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_2 69 7 1 0   14     0   11   43 59 *                     102.0 69 7 1 0   14     0   11   43 59                 102
1673154 1673154 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Boston - Excel High School   Regular School No High 09 12 2021   grade_9 9 22 54 0   14     0   3   58 44 *                     102.0 9 22 54 0   14     0   3   58 44                 102
1673771 1673771 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Chelmsford - Center Elementary School   Regular School No Elementary KG 04 2021   grade_3 66 4 6 0   23     0   3   53 49 *                     102.0 66 4 6 0   23     0   3   53 49                 102
1674039 1674039 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth - James M. Quinn School   Regular School No Elementary KG 05 2021   grade_5 82 2 5 0   3     0   10   58 44 *                     102.0 82 2 5 0   3     0   10   58 44                 102
1674304 1674304 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett - Lafayette School   Regular School No Elementary KG 08 2021   grade_3 24 15 46 0   15     0   2   52 50 *                     102.0 24 15 46 0   15     0   2   52 50                 102
1674374 1674374 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   grade_1 48 6 39 0   3     0   6   56 46 *                     102.0 48 6 39 0   3     0   6   56 46                 102
1674488 1674488 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Fitchburg - Reingold Elementary   Regular School No Elementary PK 04 2021   grade_3 26 7 57 0   2     0   10   59 43 *                     102.0 26 7 57 0   2     0   10   59 43                 102
1674772 1674772 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_4 82 1 7 1   7     0   4   47 55 *                     102.0 82 1 7 1   7     0   4   47 55                 102
1674898 1674898 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Haverhill - Bradford Elementary   Regular School No Elementary KG 04 2021   grade_2 43 3 52 0   2     0   2   59 43 *                     102.0 43 3 52 0   2     0   2   59 43                 102
1675362 1675362 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Leominster - Fall Brook   Regular School No Elementary KG 05 2021   grade_2 43 12 40 0   3     0   4   56 46 *                     102.0 43 12 40 0   3     0   4   56 46                 102
1675364 1675364 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Leominster - Fall Brook   Regular School No Elementary KG 05 2021   grade_4 46 11 36 0   2     0   7   55 47 *                     102.0 46 11 36 0   2     0   7   55 47                 102
1675882 1675882 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_6 30 20 16 0   31     0   5   52 50 *                     102.0 30 20 16 0   31     0   5   52 50                 102
1676984 1676984 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 Norwell - William G Vinal   Regular School No Elementary PK 05 2021   grade_1 91 0 1 0   2     0   8   51 51 *                     102.0 91 0 1 0   2     0   8   51 51                 102
1677365 1677365 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy - Lincoln-Hancock Community School   Regular School No Elementary KG 04 2021   grade_4 29 15 23 1   28     1   5   53 49 *                     102.0 29 15 23 1   28     1   5   53 49                 102
1678235 1678235 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 Springfield - German Gerena Community School   Regular School No Elementary PK 05 2021   kindergarten 10 11 77 1   0     0   3   57 45 *                     102.0 10 11 77 1   0     0   3   57 45                 102
1678459 1678459 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton - Sutton Middle School   Regular School No Middle 06 08 2021   grade_7 85 0 7 0   2     0   8   48 54 *                     102.0 85 0 7 0   2     0   8   48 54                 102
1678522 1678522 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 Taunton - East Taunton Elementary   Regular School No Elementary KG 04 2021   grade_1 66 15 15 0   0     0   6   53 49 *                     102.0 66 15 15 0   0     0   6   53 49                 102
1678770 1678770 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware - Ware Junior/Senior High School   Regular School No High 07 12 2021   grade_7 88 1 10 0   0     0   3   57 45 *                     102.0 88 1 10 0   0     0   3   57 45                 102
1679095 1679095 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 West Springfield - Philip G Coburn   Regular School No Elementary KG 05 2021   grade_4 57 4 27 0   12     0   2   48 54 *                     102.0 57 4 27 0   12     0   2   48 54                 102
1679688 1679688 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham - Delaney   Regular School No Elementary PK 03 2021   kindergarten 89 3 1 0   5     0   4   52 50 *                     102.0 89 3 1 0   5     0   4   52 50                 102
1679709 1679709 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_2 18 11 70 0   0     0   3   41 61 *                     102.0 18 11 70 0   0     0   3   41 61                 102
1679845 1679845 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_7 75 4 10 1   8     0   4   45 57 *                     102.0 75 4 10 1   8     0   4   45 57                 102
1680104 1680104 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District) - Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2021   grade_5 1 61 36 0   0     0   4   49 53 *                     102.0 1 61 36 0   0     0   4   49 53                 102
1680534 1680534 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Dighton-Rehoboth - Palmer River   Regular School No Elementary PK 04 2021   grade_3 89 2 4 0   1     0   6   52 50 *                     102.0 89 2 4 0   1     0   6   52 50                 102
1680620 1680620 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_11 91 2 3 0   1     1   4   52 50 *                     102.0 91 2 3 0   1     1   4   52 50                 102
1680776 1680776 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional - Manchester Essex Regional Middle School   Regular School No Middle 06 08 2021   grade_6 101 0 1 0   0     0   0   60 42 *                     102.0 101 0 1 0   0     0   0   60 42                 102
1680825 1680825 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Monomoy Regional School District - Harwich Elementary School   Regular School No Elementary PK 04 2021   grade_4 81 7 5 0   0     0   9   45 57 *                     102.0 81 7 5 0   0     0   9   45 57                 102
1681116 1681116 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Southwick-Tolland-Granville Regional School District - Woodland School   Regular School No Elementary PK 02 2021   grade_2 88 2 9 0   0     0   3   48 54 *                     102.0 88 2 9 0   0     0   3   48 54                 102
1681208 1681208 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Wachusett - Naquag Elementary School   Regular School No Elementary KG 02 2021   grade_2 93 1 4 0   2     0   2   52 50 *                     102.0 93 1 4 0   2     0   2   52 50                 102
1672315 1672315 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   grade_3 82 1 12 0   0     0   8   51 52 *                     103.0 82 1 12 0   0     0   8   51 52                 103
1673160 1673160 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston - Jeremiah E Burke High   Regular School No High 09 12 2021   grade_10 3 62 34 0   1     0   3   50 53 *                     103.0 3 62 34 0   1     0   3   50 53                 103
1673190 1673190 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston - New Mission High School   Alternative School No High 07 12 2021   grade_10 0 45 53 0   4     0   1   49 54 *                     103.0 0 45 53 0   4     0   1   49 54                 103
1673215 1673215 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston - Boston Community Leadership Academy   Regular School No High 09 12 2021   grade_12 6 37 57 0   2     0   1   52 51 *                     103.0 6 37 57 0   2     0   1   52 51                 103
1673296 1673296 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   grade_2 91 1 4 1   3     0   3   45 58 *                     103.0 91 1 4 1   3     0   3   45 58                 103
1673448 1673448 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton - Downey   Regular School No Elementary KG 05 2021   grade_4 17 58 17 1   1     1   8   60 43 *                     103.0 17 58 17 1   1     1   8   60 43                 103

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