enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,465 ✖
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
2046791 2046791 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2019   grade_10 85 4 5 0   2     0   4   45 55                       100.0 85 4 5 0   2     0   4   45 55                 100
2047217 2047217 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2019   grade_5 11 8 71 0   8     0   2   52 48                       100.0 11 8 71 0   8     0   2   52 48                 100
2047392 2047392 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2019   kindergarten 33 23 34 0   4     0   6   40 60                       100.0 33 23 34 0   4     0   6   40 60                 100
2047453 2047453 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_9 6 12 74 0   7     0   1   48 52                       100.0 6 12 74 0   7     0   1   48 52                 100
2047532 2047532 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_12 8 15 71 2   4     0   0   45 55                       100.0 8 15 71 2   4     0   0   45 55                 100
2047652 2047652 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_5 75 3 9 1   8     0   4   47 53                       100.0 75 3 9 1   8     0   4   47 53                 100
2047653 2047653 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_6 75 3 7 0   14     0   1   53 47                       100.0 75 3 7 0   14     0   1   53 47                 100
2047654 2047654 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_7 68 3 12 0   6     0   11   46 54                       100.0 68 3 12 0   6     0   11   46 54                 100
2047655 2047655 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_8 81 3 6 0   5     0   5   57 43                       100.0 81 3 6 0   5     0   5   57 43                 100
2047766 2047766 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2019   grade_6 53 33 8 0   1     0   5   57 43                       100.0 53 33 8 0   1     0   5   57 43                 100
2047783 2047783 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 Man   Regular School Yes High 09 12 2019   grade_10 2 33 59 1   0     0   5   39 61                       100.0 2 33 59 1   0     0   5   39 61                 100
2048416 2048416 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2019   grade_9 88 2 4 0   1     1   4   51 49                       100.0 88 2 4 0   1     1   4   51 49                 100
2048622 2048622 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2019   grade_3 76 7 5 1   3     0   8   57 43                       100.0 76 7 5 1   3     0   8   57 43                 100
2048695 2048695 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No Elementary 02 04 2019   grade_4 85 1 6 0   0     1   7   48 52                       100.0 85 1 6 0   0     1   7   48 52                 100
2049115 2049115 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional High   Regular School No High 09 12 2019   grade_12 89 1 7 0   0     0   3   54 45                       100.0 89 1 7 0   0     0   3   54 45                 100
2049272 2049272 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   kindergarten 17 19 32 0   27     0   5   45 55                       100.0 17 19 32 0   27     0   5   45 55                 100
2039963 2039963 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   kindergarten 77 0 4 0   7     0   13   54 47                       101.0 77 0 4 0   7     0   13   54 47                 101
2040031 2040031 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2019   grade_4 64 8 16 0   3     0   10   53 48                       101.0 64 8 16 0   3     0   10   53 48                 101
2040452 2040452 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_6 10 2 88 0   1     0   0   53 48                       101.0 10 2 88 0   1     0   0   53 48                 101
2040453 2040453 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_7 8 2 90 0   0     0   1   50 51                       101.0 8 2 90 0   0     0   1   50 51                 101
2040703 2040703 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_5 4 45 46 1   1     1   3   53 48                       101.0 4 45 46 1   1     1   3   53 48                 101
2041251 2041251 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2019   grade_1 23 65 5 0   3     1   4   35 66                       101.0 23 65 5 0   3     1   4   35 66                 101
2041280 2041280 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2019   grade_1 21 60 13 2   1     0   4   65 36                       101.0 21 60 13 2   1     0   4   65 36                 101
2041540 2041540 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2019   grade_6 30 34 12 0   17     1   7   41 60                       101.0 30 34 12 0   17     1   7   41 60                 101
2041780 2041780 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2019   kindergarten 95 3 1 0   1     0   1   47 54                       101.0 95 3 1 0   1     0   1   47 54                 101
2041932 2041932 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2019   grade_6 93 1 3 0   2     0   2   43 58                       101.0 93 1 3 0   2     0   2   43 58                 101
2041937 2041937 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2019   grade_11 92 0 3 0   3     1   2   43 58                       101.0 92 0 3 0   3     1   2   43 58                 101
2042041 2042041 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2019   grade_4 70 7 15 0   6     0   3   59 42                       101.0 70 7 15 0   6     0   3   59 42                 101
2042153 2042153 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_2 11 16 70 0   4     0   0   45 56                       101.0 11 16 70 0   4     0   0   45 56                 101
2042196 2042196 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2019   grade_2 50 3 36 0   3     0   9   55 46                       101.0 50 3 36 0   3     0   9   55 46                 101
2043128 2043128 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_7 0 1 99 0   1     0   0   59 42                       101.0 0 1 99 0   1     0   0   59 42                 101
2043196 2043196 MA Worcester   school 2506780 153   Leominster 250678000064 1530003 Bennett   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 11 30 0   3     0   6   63 38                       101.0 51 11 30 0   3     0   6   63 38                 101
2043207 2043207 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2019   grade_3 32 7 51 0   2     0   9   56 45                       101.0 32 7 51 0   2     0   9   56 45                 101
2043211 2043211 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2019   grade_1 49 9 36 0   2     0   5   52 49                       101.0 49 9 36 0   2     0   5   52 49                 101
2043253 2043253 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2019   grade_3 42 5 6 1   42     0   5   47 54                       101.0 42 5 6 1   42     0   5   47 54                 101
2043449 2043449 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2019   grade_4 15 2 33 0   45     0   6   60 41                       101.0 15 2 33 0   45     0   6   60 41                 101
2043537 2043537 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2019   grade_11 90 4 0 1   4     0   2   43 58                       101.0 90 4 0 1   4     0   2   43 58                 101
2043584 2043584 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   grade_3 2 4 81 0   11     0   3   56 45                       101.0 2 4 81 0   11     0   3   56 45                 101
2043594 2043594 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2019   grade_1 4 10 73 0   11     0   3   50 51                       101.0 4 10 73 0   11     0   3   50 51                 101
2043686 2043686 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No Elementary KG 04 2019   grade_3 79 2 8 0   7     0   5   44 57                       101.0 79 2 8 0   7     0   5   44 57                 101
2043702 2043702 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_1 33 8 14 0   41     0   5   49 52                       101.0 33 8 14 0   41     0   5   49 52                 101
2043708 2043708 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_7 25 18 15 0   41     1   1   57 44                       101.0 25 18 15 0   41     1   1   57 44                 101
2043711 2043711 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_1 25 19 28 0   25     0   4   52 49                       101.0 25 19 28 0   25     0   4   52 49                 101
2043713 2043713 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_3 22 23 30 1   17     0   8   50 51                       101.0 22 23 30 1   17     0   8   50 51                 101
2043714 2043714 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_4 27 18 38 0   14     0   4   48 53                       101.0 27 18 38 0   14     0   4   48 53                 101
2043730 2043730 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2019   grade_2 33 22 16 0   26     0   4   51 50                       101.0 33 22 16 0   26     0   4   51 50                 101
2044134 2044134 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary KG 05 2019   grade_5 82 5 2 0   6     1   5   52 49                       101.0 82 5 2 0   6     1   5   52 49                 101
2044142 2044142 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2019   kindergarten 84 6 1 1   3     0   6   48 53                       101.0 84 6 1 1   3     0   6   48 53                 101
2044263 2044263 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2019   kindergarten 84 1 4 0   6     0   6   53 48                       101.0 84 1 4 0   6     0   6   53 48                 101
2044318 2044318 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary KG 05 2019   grade_2 9 19 70 0   1     0   2   48 53                       101.0 9 19 70 0   1     0   2   48 53                 101
2044903 2044903 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No Elementary PK 05 2019   grade_1 82 4 10 0   1     0   4   42 59                       101.0 82 4 10 0   1     0   4   42 59                 101
2045118 2045118 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No Elementary KG 05 2019   grade_5 96 1 3 0   0     0   1   53 48                       101.0 96 1 3 0   0     0   1   53 48                 101
2045356 2045356 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2019   pre_kindergarten 66 0 34 0   1     0   0   61 40                       101.0 66 0 34 0   1     0   0   61 40                 101
2045705 2045705 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No Elementary KG 05 2019   grade_5 91 2 4 0   0     0   4   52 49                       101.0 91 2 4 0   0     0   4   52 49                 101
2046064 2046064 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2019   grade_10 15 25 58 0   1     1   1   56 45                       101.0 15 25 58 0   1     1   1   56 45                 101
2046098 2046098 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_7 3 11 85 0   0     0   2   52 49                       101.0 3 11 85 0   0     0   2   52 49                 101
2046414 2046414 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No Middle 04 06 2019   grade_5 92 1 2 0   1     0   5   44 57                       101.0 92 1 2 0   1     0   5   44 57                 101
2046462 2046462 MA Middlesex   school 2511910 305   Wakefield 251191001941 3050005 Dolbeare   Regular School No Elementary KG 04 2019   grade_2 87 1 8 0   2     0   3   53 48                       101.0 87 1 8 0   2     0   3   53 48                 101
2046590 2046590 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2019   grade_5 89 2 7 0   0     0   3   52 49                       101.0 89 2 7 0   0     0   3   52 49                 101
2046755 2046755 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2019   grade_2 38 2 20 1   36     0   4   50 51                       101.0 38 2 20 1   36     0   4   50 51                 101
2046786 2046786 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Middle 04 06 2019   grade_5 82 6 0 1   1     1   10   46 55                       101.0 82 6 0 1   1     1   10   46 55                 101
2048128 2048128 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2019   kindergarten 93 0 5 0   1     0   2   53 48                       101.0 93 0 5 0   1     0   2   53 48                 101
2048158 2048158 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2019   grade_5 89 0 10 0   0     0   2   61 40                       101.0 89 0 10 0   0     0   2   61 40                 101
2049033 2049033 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2019   grade_1 89 1 7 0   2     0   2   46 55                       101.0 89 1 7 0   2     0   2   46 55                 101
2049130 2049130 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2019   grade_2 90 0 5 1   2     0   3   59 42                       101.0 90 0 5 1   2     0   3   59 42                 101
2039831 2039831 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_5 97 1 3 0   1     0   0   60 42                       102.0 97 1 3 0   1     0   0   60 42                 102
2040371 2040371 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 02 2019   grade_1 5 69 25 0   0     0   3   62 40                       102.0 5 69 25 0   0     0   3   62 40                 102
2040378 2040378 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_4 28 21 48 0   3     0   2   44 58                       102.0 28 21 48 0   3     0   2   44 58                 102
2040524 2040524 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_6 24 37 33 1   6     0   1   44 58                       102.0 24 37 33 1   6     0   1   44 58                 102
2040994 2040994 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_9 1 54 45 1   0     0   1   49 53                       102.0 1 54 45 1   0     0   1   49 53                 102
2041249 2041249 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_8 12 64 15 0   0     1   10   44 58                       102.0 12 64 15 0   0     1   10   44 58                 102
2041252 2041252 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2019   grade_2 39 45 10 0   1     0   7   54 48                       102.0 39 45 10 0   1     0   7   54 48                 102
2041341 2041341 MA Middlesex   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2019   grade_6 59 4 9 0   22     0   8   52 50                       102.0 59 4 9 0   22     0   8   52 50                 102
2041537 2041537 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2019   grade_6 49 19 14 1   10     0   9   58 44                       102.0 49 19 14 1   10     0   9   58 44                 102
2041566 2041566 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2019   grade_5 80 4 2 0   9     0   7   57 45                       102.0 80 4 2 0   9     0   7   57 45                 102
2041608 2041608 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2019   grade_1 71 3 5 0   20     0   3   54 48                       102.0 71 3 5 0   20     0   3   54 48                 102
2041774 2041774 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2019   grade_11 63 6 30 0   2     0   1   56 46                       102.0 63 6 30 0   2     0   1   56 46                 102
2042034 2042034 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2019   grade_8 81 2 14 0   3     0   2   59 43                       102.0 81 2 14 0   3     0   2   59 43                 102
2042150 2042150 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2019   grade_8 30 19 47 1   3     0   2   44 58                       102.0 30 19 47 1   3     0   2   44 58                 102
2042188 2042188 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2019   kindergarten 54 12 22 0   2     0   12   43 59                       102.0 54 12 22 0   2     0   12   43 59                 102
2042210 2042210 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2019   grade_2 43 7 40 0   3     0   9   41 61                       102.0 43 7 40 0   3     0   9   41 61                 102
2042842 2042842 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_8 51 24 14 0   4     0   9   49 53                       102.0 51 24 14 0   4     0   9   49 53                 102
2043265 2043265 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2019   grade_3 38 3 3 0   53     0   5   57 45                       102.0 38 3 3 0   53     0   5   57 45                 102
2043705 2043705 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_4 33 22 13 0   29     0   5   52 50                       102.0 33 22 13 0   29     0   5   52 50                 102
2043897 2043897 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No High 09 12 2019   grade_12 74 3 14 0   4     0   7   51 51                       102.0 74 3 14 0   4     0   7   51 51                 102
2044056 2044056 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2019   grade_3 94 1 3 0   0     0   4   61 41                       102.0 94 1 3 0   0     0   4   61 41                 102
2044080 2044080 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2019   grade_5 83 1 5 0   5     0   8   50 52                       102.0 83 1 5 0   5     0   8   50 52                 102
2044208 2044208 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2019   grade_3 53 1 11 0   32     0   5   54 48                       102.0 53 1 11 0   32     0   5   54 48                 102
2044216 2044216 MA Middlesex   school 2508340 198   Natick 250834001299 1980035 Lilja Elementary   Regular School No Elementary KG 04 2019   grade_1 76 2 8 0   13     0   3   48 54                       102.0 76 2 8 0   13     0   3   48 54                 102
2044265 2044265 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2019   grade_2 79 3 3 0   8     0   9   52 50                       102.0 79 3 3 0   8     0   9   52 50                 102
2044674 2044674 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2019   kindergarten 91 4 4 0   3     0   0   51 51                       102.0 91 4 4 0   3     0   0   51 51                 102
2044902 2044902 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No Elementary PK 05 2019   kindergarten 86 2 9 0   2     0   3   55 47                       102.0 86 2 9 0   2     0   3   55 47                 102
2045132 2045132 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2019   grade_1 86 1 5 0   0     0   10   60 42                       102.0 86 1 5 0   0     0   10   60 42                 102
2045491 2045491 MA Essex   school 2510380 258   Salem 251038001668 2580070 Witchcraft Heights   Regular School No Elementary KG 05 2019   grade_1 45 8 41 0   4     0   4   53 49                       102.0 45 8 41 0   4     0   4   53 49                 102
2045626 2045626 MA Norfolk   school 2510620 266   Sharon 251062001702 2660005 Cottage Street   Regular School No Elementary KG 05 2019   grade_4 51 6 4 1   28     1   11   54 48                       102.0 51 6 4 1   28     1   11   54 48                 102
2046054 2046054 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2019   kindergarten 4 14 83 0   1     0   0   53 49                       102.0 4 14 83 0   1     0   0   53 49                 102
2046059 2046059 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2019   grade_5 3 15 83 0   1     0   0   59 43                       102.0 3 15 83 0   1     0   0   59 43                 102
2046793 2046793 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2019   grade_12 93 5 1 0   1     0   2   45 57                       102.0 93 5 1 0   1     0   2   45 57                 102
2046896 2046896 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2019   kindergarten 93 1 5 0   0     0   3   45 57                       102.0 93 1 5 0   0     0   3   45 57                 102
2047072 2047072 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2019   kindergarten 92 1 3 0   3     0   3   55 47                       102.0 92 1 3 0   3     0   3   55 47                 102

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