enrollments

Data source: Big Local News · About: Big Local

970 rows where grade = "grade_2", state = "MA" and year = 2021 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 970 ✖

grade ✖

  • grade_2 · 970 ✖
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
1675700 1675700 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1674752 1674752 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_2 * * * *   *     *   *   * * *                     1.0                                             1
1677341 1677341 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_2 3 6 0 0   0     0   1   3 7 *                     10.0 3 6 0 0   0     0   1   3 7                 10
1680592 1680592 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg - Farmington River Elementary   Regular School No Elementary PK 06 2021   grade_2 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1681191 1681191 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional - Chilmark Elementary   Regular School No Elementary KG 05 2021   grade_2 10 0 0 0   0     0   0   6 4 *                     10.0 10 0 0 0   0     0   0   6 4                 10
1674348 1674348 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River - North End Elementary   Regular School No Elementary PK 05 2021   grade_2 52 12 22 0   1     0   13   46 54 *                     100.0 52 12 22 0   1     0   13   46 54                 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
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
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
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
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
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
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
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
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
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
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
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
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
1673940 1673940 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset - Joseph Osgood   Regular School No Elementary PK 02 2021   grade_2 97 4 1 0   1     0   0   47 56 *                     103.0 97 4 1 0   1     0   0   47 56                 103
1675943 1675943 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 Marblehead - L H Coffin   Regular School No Elementary 01 02 2021   grade_2 87 3 6 0   3     0   4   53 50 *                     103.0 87 3 6 0   3     0   4   53 50                 103
1677374 1677374 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy - Clifford H Marshall Elementary   Regular School No Elementary KG 04 2021   grade_2 27 12 12 0   50     1   1   40 63 *                     103.0 27 12 12 0   50     1   1   40 63                 103
1678123 1678123 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Springfield - Frederick Harris   Regular School No Elementary PK 05 2021   grade_2 18 13 62 0   3     0   7   61 42 *                     103.0 18 13 62 0   3     0   7   61 42                 103
1679691 1679691 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham - Delaney   Regular School No Elementary PK 03 2021   grade_2 90 0 6 0   4     0   3   52 51 *                     103.0 90 0 6 0   4     0   3   52 51                 103
1680890 1680890 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Narragansett - Templeton Elementary School   Regular School No Elementary PK 05 2021   grade_2 95 1 4 0   1     0   2   55 48 *                     103.0 95 1 4 0   1     0   2   55 48                 103
1672268 1672268 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn - Pakachoag School   Regular School No Elementary PK 02 2021   grade_2 85 3 11 0   3     0   2   58 46 *                     104.0 85 3 11 0   3     0   2   58 46                 104
1674395 1674395 MA Bristol   school 2504830 95   Fall River 250483000684 950065 Fall River - William S Greene   Regular School No Elementary PK 05 2021   grade_2 38 12 41 0   2     0   11   52 52 *                     104.0 38 12 41 0   2     0   11   52 52                 104
1674699 1674699 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_2 98 0 1 0   0     0   5   50 54 *                     104.0 98 0 1 0   0     0   5   50 54                 104
1676232 1676232 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_2 91 3 2 0   1     0   7   53 51 *                     104.0 91 3 2 0   1     0   7   53 51                 104
1674312 1674312 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_2 9 14 79 0   3     0   0   44 61 *                     105.0 9 14 79 0   3     0   0   44 61                 105
1675747 1675747 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Lynn - Cobbet Elementary   Regular School No Elementary KG 05 2021   grade_2 5 7 89 0   3     0   1   59 46 *                     105.0 5 7 89 0   3     0   1   59 46                 105
1676237 1676237 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_2 94 3 0 0   2     0   6   52 53 *                     105.0 94 3 0 0   2     0   6   52 53                 105
1678454 1678454 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton - Sutton Early Learning   Regular School No Elementary PK 02 2021   grade_2 95 2 4 0   1     0   3   62 43 *                     105.0 95 2 4 0   1     0   3   62 43                 105
1678565 1678565 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Tewksbury - Heath-Brook   Regular School No Elementary KG 02 2021   grade_2 86 6 8 0   3     0   2   49 56 *                     105.0 86 6 8 0   3     0   2   49 56                 105
1679244 1679244 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Wilmington - Shawsheen Elementary   Regular School No Elementary 01 03 2021   grade_2 89 1 2 0   7     1   5   59 46 *                     105.0 89 1 2 0   7     1   5   59 46                 105
1672116 1672116 MA Essex   school 2501950 9   Andover 250195001676 90004 Andover - High Plain Elementary   Regular School No Elementary KG 05 2021   grade_2 46 4 13 0   39     0   4   58 48 *                     106.0 46 4 13 0   39     0   4   58 48                 106
1672452 1672452 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Billerica - Thomas Ditson   Regular School No Elementary KG 04 2021   grade_2 82 3 6 0   11     0   4   52 54 *                     106.0 82 3 6 0   11     0   4   52 54                 106
1673770 1673770 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Chelmsford - Center Elementary School   Regular School No Elementary KG 04 2021   grade_2 74 2 5 0   22     0   3   59 47 *                     106.0 74 2 5 0   22     0   3   59 47                 106
1677289 1677289 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Plymouth - Indian Brook   Regular School No Elementary KG 05 2021   grade_2 97 1 3 0   1     0   4   51 55 *                     106.0 97 1 3 0   1     0   4   51 55                 106
1677806 1677806 MA Norfolk   school 2510620 266   Sharon 251062001703 2660010 Sharon - East Elementary   Regular School No Elementary KG 05 2021   grade_2 56 4 5 0   35     0   6   50 55 *                     106.0 56 4 5 0   35     0   6   50 55                 106
1675761 1675761 MA Essex   school 2507110 163   Lynn 250711001070 1630045 Lynn - E J Harrington   Regular School No Elementary PK 05 2021   grade_2 15 9 69 0   9     0   5   51 56 *                     107.0 15 9 69 0   9     0   5   51 56                 107
1678534 1678534 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Taunton - Elizabeth Pole   Regular School No Elementary KG 04 2021   grade_2 50 22 19 1   2     0   13   52 55 *                     107.0 50 22 19 1   2     0   13   52 55                 107
1679024 1679024 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Westford - Nabnasset   Regular School No Elementary KG 02 2021   grade_2 89 0 1 0   16     0   1   46 61 *                     107.0 89 0 1 0   16     0   1   46 61                 107
1679077 1679077 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Westport - Alice A Macomber   Regular School No Elementary PK 02 2021   grade_2 97 1 6 0   0     0   3   47 60 *                     107.0 97 1 6 0   0     0   3   47 60                 107
1679241 1679241 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington - Woburn Street   Regular School No Elementary 01 03 2021   grade_2 88 1 5 0   7     0   6   62 45 *                     107.0 88 1 5 0   7     0   6   62 45                 107
1678621 1678621 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge - Taft Early Learning Center   Regular School No Elementary PK 03 2021   grade_2 98 0 5 0   2     1   2   60 48 *                     108.0 98 0 5 0   2     1   2   60 48                 108
1675480 1675480 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Littleton - Shaker Lane Elementary   Regular School No Elementary PK 02 2021   grade_2 89 1 1 0   16     0   2   62 47 *                     109.0 89 1 1 0   16     0   2   62 47                 109
1680652 1680652 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Groton-Dunstable - Florence Roche School   Regular School No Elementary KG 04 2021   grade_2 83 1 8 1   9     0   7   66 43 *                     109.0 83 1 8 1   9     0   7   66 43                 109
1679050 1679050 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton - Westhampton Elementary School   Regular School No Elementary PK 06 2021   grade_2 11 0 0 0   0     0   0   8 3 *                     11.0 11 0 0 0   0     0   0   8 3                 11
1680867 1680867 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Mohawk Trail - Colrain Central   Regular School No Elementary PK 06 2021   grade_2 11 0 0 0   0     0   0   4 7 *                     11.0 11 0 0 0   0     0   0   4 7                 11
1677100 1677100 MA Essex   school 2509360 229   Peabody 250936001503 2290010 Peabody - Thomas Carroll   Regular School No Elementary KG 05 2021   grade_2 74 4 28 1   3     0   0   50 60 *                     110.0 74 4 28 1   3     0   0   50 60                 110
1680179 1680179 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_2 88 6 7 0   3     1   5   53 57 *                     110.0 88 6 7 0   3     1   5   53 57                 110
1674354 1674354 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Fall River - Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2021   grade_2 45 11 39 0   2     0   14   59 52 *                     111.0 45 11 39 0   2     0   14   59 52                 111
1675242 1675242 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence - Gerard A. Guilmette   Regular School No Elementary 01 04 2021   grade_2 2 2 106 0   1     0   0   63 48 *                     111.0 2 2 106 0   1     0   0   63 48                 111
1675443 1675443 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Lexington - Maria Hastings   Regular School No Elementary KG 05 2021   grade_2 41 0 7 0   53     0   10   56 55 *                     111.0 41 0 7 0   53     0   10   56 55                 111
1676850 1676850 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 North Attleborough - Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2021   grade_2 86 6 7 1   4     0   7   62 49 *                     111.0 86 6 7 1   4     0   7   62 49                 111
1678097 1678097 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Springfield - Rebecca M Johnson   Regular School No Elementary PK 05 2021   grade_2 1 41 65 2   0     0   2   51 60 *                     111.0 1 41 65 2   0     0   2   51 60                 111
1672941 1672941 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston - Josiah Quincy   Regular School No Elementary PK 05 2021   grade_2 17 13 10 0   68     0   4   52 60 *                     112.0 17 13 10 0   68     0   4   52 60                 112
1673384 1673384 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Brockton - Mary E. Baker School   Regular School No Elementary KG 05 2021   grade_2 27 55 18 1   3     0   8   58 54 *                     112.0 27 55 18 1   3     0   8   58 54                 112
1673812 1673812 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_2 6 4 102 0   0     0   0   55 57 *                     112.0 6 4 102 0   0     0   0   55 57                 112
1677540 1677540 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Revere - Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2021   grade_2 27 2 75 0   7     0   1   58 54 *                     112.0 27 2 75 0   7     0   1   58 54                 112
1678958 1678958 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater - Rose L Macdonald   Regular School No Elementary 01 03 2021   grade_2 94 6 8 0   0     0   4   56 56 *                     112.0 94 6 8 0   0     0   4   56 56                 112
1675374 1675374 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Leominster - Johnny Appleseed   Regular School No Elementary KG 05 2021   grade_2 64 10 32 0   3     0   5   57 57 *                     114.0 64 10 32 0   3     0   5   57 57                 114
1676365 1676365 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket - Nantucket Elementary   Regular School No Elementary PK 02 2021   grade_2 55 8 42 0   4     0   5   54 60 *                     114.0 55 8 42 0   4     0   5   54 60                 114
1676901 1676901 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 Northbridge - W Edward Balmer   Regular School No Elementary 02 04 2021   grade_2 97 1 8 0   0     0   8   60 54 *                     114.0 97 1 8 0   0     0   8   60 54                 114
1677553 1677553 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Revere - Garfield Elementary School   Regular School No Elementary PK 05 2021   grade_2 27 1 78 0   5     0   3   51 63 *                     114.0 27 1 78 0   5     0   3   51 63                 114
1673437 1673437 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton - Oscar F Raymond   Regular School No Elementary KG 05 2021   grade_2 8 89 18 0   0     0   0   61 54 *                     115.0 8 89 18 0   0     0   0   61 54                 115
1674036 1674036 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth - James M. Quinn School   Regular School No Elementary KG 05 2021   grade_2 98 1 8 0   1     0   7   64 51 *                     115.0 98 1 8 0   1     0   7   64 51                 115
1675978 1675978 MA Middlesex   school 2507320 170   Marlborough 250732002913 1700020 Marlborough - Goodnow Brothers Elementary School   Regular School No Elementary KG 05 2021   grade_2 47 3 61 0   2     0   2   69 46 *                     115.0 47 3 61 0   2     0   2   69 46                 115
1680604 1680604 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Freetown-Lakeville - Assawompset Elementary School   Regular School No Elementary KG 03 2021   grade_2 102 0 3 0   1     0   9   61 54 *                     115.0 102 0 3 0   1     0   9   61 54                 115
1674940 1674940 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Haverhill - Tilton   Regular School No Elementary KG 03 2021   grade_2 44 5 64 0   0     0   3   62 54 *                     116.0 44 5 64 0   0     0   3   62 54                 116
1676190 1676190 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen - Marsh Grammar School   Regular School No Elementary PK 08 2021   grade_2 57 8 46 0   1     1   3   59 57 *                     116.0 57 8 46 0   1     1   3   59 57                 116
1677056 1677056 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Oxford - Clara Barton   Regular School No Elementary 02 04 2021   grade_2 97 1 14 1   0     0   3   53 63 *                     116.0 97 1 14 1   0     0   3   53 63                 116
1681446 1681446 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_2 18 22 36 1   34     0   5   53 63 *                     116.0 18 22 36 1   34     0   5   53 63                 116
1672026 1672026 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_2 107 1 2 0   2     0   5   62 55 *                     117.0 107 1 2 0   2     0   5   62 55                 117
1675000 1675000 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 Holbrook - John F Kennedy   Regular School No Elementary PK 05 2021   grade_2 64 26 14 0   5     0   8   62 55 *                     117.0 64 26 14 0   5     0   8   62 55                 117
1675878 1675878 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_2 45 10 21 0   41     0   0   58 59 *                     117.0 45 10 21 0   41     0   0   58 59                 117
1680512 1680512 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth - Station Avenue Elementary   Regular School No Elementary KG 03 2021   grade_2 84 8 10 0   4     0   11   59 58 *                     117.0 84 8 10 0   4     0   11   59 58                 117
1675217 1675217 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence - Community Day Arlington   Regular School No Elementary KG 04 2021   grade_2 5 1 112 0   0     0   0   60 58 *                     118.0 5 1 112 0   0     0   0   60 58                 118
1676280 1676280 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Millbury - Elmwood Street   Regular School No Elementary PK 03 2021   grade_2 93 8 4 0   5     0   8   58 60 *                     118.0 93 8 4 0   5     0   8   58 60                 118
1676320 1676320 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Milton - Glover   Regular School No Elementary KG 05 2021   grade_2 95 9 2 1   5     0   6   52 66 *                     118.0 95 9 2 1   5     0   6   52 66                 118
1680969 1680969 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 North Middlesex - Varnum Brook   Regular School No Elementary KG 04 2021   grade_2 98 2 12 0   2     0   4   57 61 *                     118.0 98 2 12 0   2     0   4   57 61                 118
1675990 1675990 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Marlborough - Charles Jaworek School   Regular School No Elementary KG 05 2021   grade_2 48 3 55 1   12     0   0   43 76 *                     119.0 48 3 55 1   12     0   0   43 76                 119
1677575 1677575 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond - Richmond Consolidated   Regular School No Elementary PK 08 2021   grade_2 10 0 1 0   0     0   1   3 9 *                     12.0 10 0 1 0   0     0   1   3 9                 12
1677863 1677863 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury - Shutesbury Elementary   Regular School No Elementary PK 06 2021   grade_2 11 0 1 0   0     0   0   3 9 *                     12.0 11 0 1 0   0     0   0   3 9                 12
1678668 1678668 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales - Wales Elementary   Regular School No Elementary PK 06 2021   grade_2 12 0 0 0   0     0   0   8 4 *                     12.0 12 0 0 0   0     0   0   8 4                 12
1680463 1680463 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen - New Hingham Regional Elementary   Regular School No Elementary PK 06 2021   grade_2 12 0 0 0   0     0   0   5 7 *                     12.0 12 0 0 0   0     0   0   5 7                 12
1672745 1672745 MA Suffolk   school 2502790 35   Boston 250279000268 350167 Boston - UP Academy Holland   Regular School No Elementary PK 05 2021   grade_2 1 61 53 2   3     0   0   54 66 *                     120.0 1 61 53 2   3     0   0   54 66                 120
1677982 1677982 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Southborough - Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2021   grade_2 93 1 4 0   14     0   8   59 61 *                     120.0 93 1 4 0   14     0   8   59 61                 120
1679898 1679898 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_2 26 35 51 0   2     0   6   68 52 *                     120.0 26 35 51 0   2     0   6   68 52                 120
1679925 1679925 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_2 17 62 31 3   2     0   5   56 64 *                     120.0 17 62 31 3   2     0   5   56 64                 120
1680533 1680533 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Dighton-Rehoboth - Palmer River   Regular School No Elementary PK 04 2021   grade_2 107 1 6 0   2     0   4   73 47 *                     120.0 107 1 6 0   2     0   4   73 47                 120
1674585 1674585 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_2 18 4 93 0   0     0   6   54 67 *                     121.0 18 4 93 0   0     0   6   54 67                 121
1673756 1673756 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver - Carver Elementary School   Regular School No Elementary PK 05 2021   grade_2 117 1 3 0   0     0   3   58 66 *                     124.0 117 1 3 0   0     0   3   58 66                 124
1675234 1675234 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence - Robert Frost   Regular School No Elementary KG 04 2021   grade_2 5 3 110 0   6     0   0   63 59 *                     124.0 5 3 110 0   6     0   0   63 59                 124
1678607 1678607 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough - Tyngsborough Elementary   Regular School No Elementary PK 05 2021   grade_2 91 7 7 1   16     0   2   70 54 *                     124.0 91 7 7 1   16     0   2   70 54                 124

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