enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,536 ✖
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
1672113 1672113 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover - Bancroft Elementary   Regular School No Elementary KG 05 2021   grade_5 74 2 9 0   8     0   6   56 43 *                     99.0 74 2 9 0   8     0   6   56 43                 99
1672137 1672137 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover - West Elementary   Regular School No Elementary KG 05 2021   grade_4 76 3 7 0   12     0   1   52 47 *                     99.0 76 3 7 0   12     0   1   52 47                 99
1672559 1672559 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston - Curley K-8 School   Regular School No Elementary PK 08 2021   grade_4 34 17 44 0   0     0   4   45 54 *                     99.0 34 17 44 0   0     0   4   45 54                 99
1672708 1672708 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston - Condon K-8   Regular School No Elementary PK 08 2021   grade_6 25 20 37 0   12     0   5   49 50 *                     99.0 25 20 37 0   12     0   5   49 50                 99
1672748 1672748 MA Suffolk   school 2502790 35   Boston 250279000268 350167 Boston - UP Academy Holland   Regular School No Elementary PK 05 2021   grade_5 1 50 36 0   9     0   3   44 55 *                     99.0 1 50 36 0   9     0   3   44 55                 99
1673136 1673136 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Boston - Brighton High   Regular School No High 09 12 2021   grade_10 5 38 53 1   1     0   1   60 39 *                     99.0 5 38 53 1   1     0   1   60 39                 99
1673313 1673313 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford - Spofford Pond   Regular School No Elementary 03 06 2021   grade_4 83 0 2 0   5     0   9   51 48 *                     99.0 83 0 2 0   5     0   9   51 48                 99
1673337 1673337 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree - Liberty   Regular School No Elementary 01 05 2021   grade_5 55 1 4 0   35     1   3   47 52 *                     99.0 55 1 4 0   35     1   3   47 52                 99
1673409 1673409 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_1 12 67 15 1   0     0   4   46 53 *                     99.0 12 67 15 1   0     0   4   46 53                 99
1673583 1673583 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Burlington - Fox Hill   Regular School No Elementary KG 05 2021   grade_3 49 5 5 0   33     0   7   50 49 *                     99.0 49 5 5 0   33     0   7   50 49                 99
1673817 1673817 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_1 11 4 84 0   0     0   0   45 54 *                     99.0 11 4 84 0   0     0   0   45 54                 99
1674038 1674038 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth - James M. Quinn School   Regular School No Elementary KG 05 2021   grade_4 88 0 4 0   1     0   6   51 48 *                     99.0 88 0 4 0   1     0   6   51 48                 99
1674371 1674371 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Fall River - Letourneau Elementary School   Regular School No Elementary PK 05 2021   grade_5 48 8 38 0   1     0   4   44 55 *                     99.0 48 8 38 0   1     0   4   44 55                 99
1674700 1674700 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_3 91 1 2 0   2     0   3   52 47 *                     99.0 91 1 2 0   2     0   3   52 47                 99
1674841 1674841 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax - Halifax Elementary   Regular School No Elementary KG 06 2021   grade_3 84 2 9 0   0     0   4   50 49 *                     99.0 84 2 9 0   0     0   4   50 49                 99
1675343 1675343 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester - Leicester High   Regular School No High 09 12 2021   grade_12 77 4 11 1   4     0   2   54 43 *                     99.0 77 4 11 1   4     0   2   54 43                 99
1675361 1675361 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Leominster - Fall Brook   Regular School No Elementary KG 05 2021   grade_1 54 8 28 0   5     0   4   57 42 *                     99.0 54 8 28 0   5     0   4   57 42                 99
1675377 1675377 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Leominster - Johnny Appleseed   Regular School No Elementary KG 05 2021   grade_5 35 13 38 0   7     0   6   45 54 *                     99.0 35 13 38 0   7     0   6   45 54                 99
1675760 1675760 MA Essex   school 2507110 163   Lynn 250711001070 1630045 Lynn - E J Harrington   Regular School No Elementary PK 05 2021   grade_1 13 11 67 0   7     0   1   59 40 *                     99.0 13 11 67 0   7     0   1   59 40                 99
1675779 1675779 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Lynn - Ingalls   Regular School No Elementary KG 05 2021   grade_2 6 5 83 0   4     0   1   48 51 *                     99.0 6 5 83 0   4     0   1   48 51                 99
1675884 1675884 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_8 24 13 19 0   40     0   3   56 43 *                     99.0 24 13 19 0   40     0   3   56 43                 99
1675888 1675888 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_3 26 12 30 0   28     0   3   57 42 *                     99.0 26 12 30 0   28     0   3   57 42                 99
1675907 1675907 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden - Linden   Regular School No Elementary KG 08 2021   grade_4 28 21 19 0   29     0   2   50 49 *                     99.0 28 21 19 0   29     0   2   50 49                 99
1675991 1675991 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Marlborough - Charles Jaworek School   Regular School No Elementary KG 05 2021   grade_3 39 5 46 0   9     0   0   53 46 *                     99.0 39 5 46 0   9     0   0   53 46                 99
1676295 1676295 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Millis - Clyde F Brown   Regular School No Elementary PK 05 2021   grade_3 79 0 15 1   2     0   2   53 46 *                     99.0 79 0 15 1   2     0   2   53 46                 99
1676307 1676307 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Milton - Collicot   Regular School No Elementary KG 05 2021   grade_2 79 1 3 0   11     0   5   48 51 *                     99.0 79 1 3 0   11     0   5   48 51                 99
1676310 1676310 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Milton - Collicot   Regular School No Elementary KG 05 2021   grade_5 79 4 4 0   8     0   4   58 41 *                     99.0 79 4 4 0   8     0   4   58 41                 99
1676316 1676316 MA Norfolk   school 2507980 189   Milton 250798002485 1890007 Milton - Cunningham School   Regular School No Elementary PK 05 2021   grade_4 74 7 6 0   7     0   5   49 50 *                     99.0 74 7 6 0   7     0   5   49 50                 99
1676441 1676441 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Needham - Newman Elementary   Regular School No Elementary PK 05 2021   grade_2 79 2 4 0   7     0   7   60 39 *                     99.0 79 2 4 0   7     0   7   60 39                 99
1676494 1676494 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 New Bedford - Alfred J Gomes   Regular School No Elementary KG 05 2021   grade_4 7 20 69 0   2     0   1   51 48 *                     99.0 7 20 69 0   2     0   1   51 48                 99
1676540 1676540 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 New Bedford - Casimir Pulaski   Regular School No Elementary PK 05 2021   grade_2 64 6 21 2   3     0   3   53 46 *                     99.0 64 6 21 2   3     0   3   53 46                 99
1677057 1677057 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Oxford - Clara Barton   Regular School No Elementary 02 04 2021   grade_3 82 2 12 0   0     0   3   50 49 *                     99.0 82 2 12 0   0     0   3   50 49                 99
1677102 1677102 MA Essex   school 2509360 229   Peabody 250936001503 2290010 Peabody - Thomas Carroll   Regular School No Elementary KG 05 2021   grade_4 69 2 27 0   1     0   0   56 43 *                     99.0 69 2 27 0   1     0   0   56 43                 99
1677363 1677363 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy - Lincoln-Hancock Community School   Regular School No Elementary KG 04 2021   grade_2 29 4 12 2   44     0   8   52 47 *                     99.0 29 4 12 2   44     0   8   52 47                 99
1677554 1677554 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Revere - Garfield Elementary School   Regular School No Elementary PK 05 2021   grade_3 21 4 69 0   3     0   2   46 53 *                     99.0 21 4 69 0   3     0   2   46 53                 99
1678003 1678003 MA Worcester   school 2511010 277   Southbridge 251101002868 2770515 Southbridge - Southbridge High School   Regular School No High 09 12 2021   grade_11 29 1 65 0   1     0   3   53 46 *                     99.0 29 1 65 0   1     0   3   53 46                 99
1678122 1678122 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Springfield - Frederick Harris   Regular School No Elementary PK 05 2021   grade_1 16 15 59 1   1     0   7   51 48 *                     99.0 16 15 59 1   1     0   7   51 48                 99
1678237 1678237 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 Springfield - German Gerena Community School   Regular School No Elementary PK 05 2021   grade_1 5 16 71 0   2     0   5   52 47 *                     99.0 5 16 71 0   2     0   5   52 47                 99
1678279 1678279 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield - STEM Middle Academy   Regular School No Middle 06 08 2021   grade_7 10 25 59 0   4     0   1   59 40 *                     99.0 10 25 59 0   4     0   1   59 40                 99
1678520 1678520 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Taunton - Joseph C Chamberlain   Regular School No Elementary KG 04 2021   grade_4 76 10 6 0   3     0   4   57 42 *                     99.0 76 10 6 0   3     0   4   57 42                 99
1678523 1678523 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 Taunton - East Taunton Elementary   Regular School No Elementary KG 04 2021   grade_2 70 17 5 0   0     0   7   44 55 *                     99.0 70 17 5 0   0     0   7   44 55                 99
1678926 1678926 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Westborough - Annie E Fales   Regular School No Elementary KG 03 2021   grade_2 47 1 2 0   48     1   0   49 50 *                     99.0 47 1 2 0   48     1   0   49 50                 99
1678963 1678963 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 West Bridgewater - Howard School   Regular School No Middle 04 06 2021   grade_5 82 6 4 0   2     0   5   47 52 *                     99.0 82 6 4 0   2     0   5   47 52                 99
1679074 1679074 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Westport - Alice A Macomber   Regular School No Elementary PK 02 2021   kindergarten 91 1 6 0   0     0   1   47 52 *                     99.0 91 1 6 0   0     0   1   47 52                 99
1679907 1679907 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_11 24 26 40 0   3     0   6   41 58 *                     99.0 24 26 40 0   3     0   6   41 58                 99
1679933 1679933 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_10 18 49 24 0   3     0   5   53 46 *                     99.0 18 49 24 0   3     0   5   53 46                 99
1680053 1680053 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District) - MATCH Charter Public School   Regular School Yes Other PK 12 2021   grade_2 2 58 39 0   0     0   0   45 54 *                     99.0 2 58 39 0   0     0   0   45 54                 99
1680374 1680374 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley School District - Ayer Shirley Regional High School   Regular School No High 09 12 2021   grade_9 75 2 11 1   5     2   3   54 45 *                     99.0 75 2 11 1   5     2   3   54 45                 99
1680429 1680429 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone-Millville - Blackstone Millville RHS   Regular School No High 09 12 2021   grade_9 88 2 4 0   0     0   5   60 38 *                     99.0 88 2 4 0   0     0   5   60 38                 99
1680557 1680557 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley-Charlton Reg - Dudley Elementary   Regular School No Elementary 02 04 2021   grade_2 78 2 12 1   1     0   5   59 40 *                     99.0 78 2 12 1   1     0   5   59 40                 99
1680618 1680618 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_9 75 5 5 0   7     0   7   58 41 *                     99.0 75 5 5 0   7     0   7   58 41                 99
1680619 1680619 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_10 85 2 8 0   2     0   2   47 52 *                     99.0 85 2 8 0   2     0   2   47 52                 99
1680739 1680739 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire - Hampshire Regional High   Regular School No High 07 12 2021   grade_10 89 0 6 0   1     0   3   39 60 *                     99.0 89 0 6 0   1     0   3   39 60                 99
1681082 1681082 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake - Silver Lake Regional High   Regular School No High 09 12 2021   pre_kindergarten 98 1 0 0   0     0   0   57 42 *                     99.0 98 1 0 0   0     0   0   57 42                 99
1672135 1672135 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover - West Elementary   Regular School No Elementary KG 05 2021   grade_2 66 5 10 0   10     0   7   52 46 *                     98.0 66 5 10 0   10     0   7   52 46                 98
1672229 1672229 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro - Hyman Fine Elementary School   Regular School No Elementary KG 04 2021   grade_1 66 9 17 0   1     0   5   47 51 *                     98.0 66 9 17 0   1     0   5   47 51                 98
1672231 1672231 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro - Hyman Fine Elementary School   Regular School No Elementary KG 04 2021   grade_3 61 3 21 0   4     0   9   48 50 *                     98.0 61 3 21 0   4     0   9   48 50                 98
1672635 1672635 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_8 5 1 91 0   1     0   0   52 46 *                     98.0 5 1 91 0   1     0   0   52 46                 98
1673105 1673105 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston - Lilla G. Frederick Middle School   Regular School No Middle 06 08 2021   grade_6 2 38 43 0   14     0   1   57 41 *                     98.0 2 38 43 0   14     0   1   57 41                 98
1673303 1673303 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   grade_9 84 1 4 3   2     0   4   49 49 *                     98.0 84 1 4 3   2     0   4   49 49                 98
1673417 1673417 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Brockton - Hancock   Regular School No Elementary KG 05 2021   kindergarten 26 50 15 0   3     0   4   48 50 *                     98.0 26 50 15 0   3     0   4   48 50                 98
1673753 1673753 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver - Carver Elementary School   Regular School No Elementary PK 05 2021   kindergarten 94 2 1 0   1     0   0   52 46 *                     98.0 94 2 1 0   1     0   0   52 46                 98
1673764 1673764 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_10 96 0 0 2   0     0   0   44 54 *                     98.0 96 0 0 2   0     0   0   44 54                 98
1673780 1673780 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford - Charles D Harrington   Regular School No Elementary KG 04 2021   grade_2 56 5 11 0   22     0   4   44 54 *                     98.0 56 5 11 0   22     0   4   44 54                 98
1673814 1673814 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_4 2 6 90 0   0     0   0   47 51 *                     98.0 2 6 90 0   0     0   0   47 51                 98
1674770 1674770 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_2 74 2 3 0   19     0   0   51 47 *                     98.0 74 2 3 0   19     0   0   51 47                 98
1675341 1675341 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester - Leicester High   Regular School No High 09 12 2021   grade_10 76 4 13 0   2     0   3   38 60 *                     98.0 76 4 13 0   2     0   3   38 60                 98
1675489 1675489 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton - Littleton High School   Regular School No High 09 12 2021   grade_11 84 1 2 0   9     0   2   49 49 *                     98.0 84 1 2 0   9     0   2   49 49                 98
1675879 1675879 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_3 26 12 15 0   40     0   5   48 50 *                     98.0 26 12 15 0   40     0   5   48 50                 98
1676251 1676251 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Middleton - Fuller Meadow   Regular School No Elementary KG 02 2021   kindergarten 80 1 7 2   6     0   2   55 43 *                     98.0 80 1 7 2   6     0   2   55 43                 98
1676323 1676323 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Milton - Glover   Regular School No Elementary KG 05 2021   grade_5 77 6 2 0   4     0   9   50 48 *                     98.0 77 6 2 0   4     0   9   50 48                 98
1676416 1676416 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Needham - Broadmeadow   Regular School No Elementary KG 05 2021   grade_2 65 3 5 0   15     0   10   48 50 *                     98.0 65 3 5 0   15     0   10   48 50                 98
1676513 1676513 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 New Bedford - Hayden/McFadden   Regular School No Elementary PK 05 2021   grade_2 25 14 55 0   0     1   3   49 49 *                     98.0 25 14 55 0   0     1   3   49 49                 98
1676986 1676986 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 Norwell - William G Vinal   Regular School No Elementary PK 05 2021   grade_3 89 1 2 0   0     0   6   53 45 *                     98.0 89 1 2 0   0     0   6   53 45                 98
1677287 1677287 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Plymouth - Indian Brook   Regular School No Elementary KG 05 2021   kindergarten 88 0 5 0   0     0   5   48 50 *                     98.0 88 0 5 0   0     0   5   48 50                 98
1678096 1678096 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Springfield - Rebecca M Johnson   Regular School No Elementary PK 05 2021   grade_1 7 19 70 0   0     0   2   51 47 *                     98.0 7 19 70 0   0     0   2   51 47                 98
1678125 1678125 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Springfield - Frederick Harris   Regular School No Elementary PK 05 2021   grade_4 23 24 45 0   2     0   4   47 51 *                     98.0 23 24 45 0   2     0   4   47 51                 98
1678239 1678239 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 Springfield - German Gerena Community School   Regular School No Elementary PK 05 2021   grade_3 5 16 77 0   0     0   0   45 53 *                     98.0 5 16 77 0   0     0   0   45 53                 98
1678463 1678463 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton - Sutton High School   Regular School No High 09 12 2021   grade_11 90 0 3 0   1     0   4   53 45 *                     98.0 90 0 3 0   1     0   4   53 45                 98
1678604 1678604 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough - Tyngsborough Elementary   Regular School No Elementary PK 05 2021   kindergarten 72 3 6 0   13     0   4   49 49 *                     98.0 72 3 6 0   13     0   4   49 49                 98
1678859 1678859 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Webster - Bartlett High School   Regular School No High 09 12 2021   grade_10 53 9 30 1   2     0   3   36 62 *                     98.0 53 9 30 1   2     0   3   36 62                 98
1678967 1678967 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater - West Bridgewater Junior/Senior   Regular School No High 07 12 2021   grade_9 82 4 4 1   1     0   6   45 53 *                     98.0 82 4 4 1   1     0   6   45 53                 98
1679101 1679101 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield - John R Fausey   Regular School No Elementary 01 05 2021   grade_5 77 1 12 0   3     0   5   51 47 *                     98.0 77 1 12 0   3     0   5   51 47                 98
1679641 1679641 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester - Claremont Academy   Regular School No High 07 12 2021   grade_7 11 9 70 0   8     0   0   47 51 *                     98.0 11 9 70 0   8     0   0   47 51                 98
1679848 1679848 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_10 60 9 15 0   8     0   6   54 44 *                     98.0 60 9 15 0   8     0   6   54 44                 98
1679934 1679934 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_11 17 54 21 0   6     0   0   45 53 *                     98.0 17 54 21 0   6     0   0   45 53                 98
1679976 1679976 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_10 3 36 59 0   0     0   0   29 69 *                     98.0 3 36 59 0   0     0   0   29 69                 98
1679977 1679977 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_11 1 37 55 1   2     0   2   32 66 *                     98.0 1 37 55 1   2     0   2   32 66                 98
1680524 1680524 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002427 6500005 Dighton-Rehoboth - Dighton Elementary   Regular School No Elementary PK 04 2021   kindergarten 81 3 8 0   1     0   5   51 47 *                     98.0 81 3 8 0   1     0   5   51 47                 98
1680562 1680562 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Dudley-Charlton Reg - Mason Road School   Regular School No Elementary PK 01 2021   grade_1 81 3 13 0   0     0   1   47 51 *                     98.0 81 3 13 0   0     0   1   47 51                 98
1680651 1680651 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Groton-Dunstable - Florence Roche School   Regular School No Elementary KG 04 2021   grade_1 78 0 3 1   7     0   9   50 48 *                     98.0 78 0 3 1   7     0   9   50 48                 98
1680741 1680741 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire - Hampshire Regional High   Regular School No High 07 12 2021   grade_12 93 1 2 0   1     0   1   38 60 *                     98.0 93 1 2 0   1     0   1   38 60                 98
1680798 1680798 MA Worcester   school 2507680 710   Mendon-Upton 250768001277 7100001 Mendon-Upton - Memorial School   Regular School No Elementary PK 04 2021   grade_3 81 2 6 0   6     0   3   56 42 *                     98.0 81 2 6 0   6     0   3   56 42                 98
1681287 1681287 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional - Quaboag Regional High   Regular School No High 09 12 2021   grade_10 88 0 5 0   0     0   5   47 51 *                     98.0 88 0 5 0   0     0   5   47 51                 98
1681428 1681428 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural - Bristol County Agricultural High   Career and Technical School No High 09 12 2021   grade_12 83 3 7 0   0     0   5   33 64 *                     98.0 83 3 7 0   0     0   5   33 64                 98
1681491 1681491 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_9 2 87 7 1   0     0   1   53 45 *                     98.0 2 87 7 1   0     0   1   53 45                 98
1672111 1672111 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover - Bancroft Elementary   Regular School No Elementary KG 05 2021   grade_3 83 2 3 0   6     0   3   49 48 *                     97.0 83 2 3 0   6     0   3   49 48                 97
1672237 1672237 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Attleboro - Hill-Roberts Elementary School   Regular School No Elementary KG 04 2021   grade_4 59 8 15 0   4     0   11   59 38 *                     97.0 59 8 15 0   4     0   11   59 38                 97
1672239 1672239 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Attleboro - Peter Thacher Elementary School   Regular School No Elementary KG 04 2021   grade_1 61 12 18 0   3     0   3   51 46 *                     97.0 61 12 18 0   3     0   3   51 46                 97
1672633 1672633 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_6 8 0 88 0   0     0   1   44 53 *                     97.0 8 0 88 0   0     0   1   44 53                 97

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