enrollments

Data source: Big Local News · About: Big Local

975 rows where grade = "grade_2", state = "MA" and year = 2019 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 975 ✖

grade ✖

  • grade_2 · 975 ✖
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
2039815 2039815 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_2 133 5 19 1   2     0   0   85 75                       160.0 133 5 19 1   2     0   0   85 75                 160
2040010 2040010 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_2 149 3 30 0   37     0   11   113 117                       230.0 149 3 30 0   37     0   11   113 117                 230
2040069 2040069 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2019   grade_2 99 1 7 0   2     0   4   56 57                       113.0 99 1 7 0   2     0   4   56 57                 113
2040073 2040073 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   grade_2 75 5 5 0   4     0   5   50 44                       94.0 75 5 5 0   4     0   5   50 44                 94
2040130 2040130 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_2 126 13 9 0   34     0   15   100 97                       197.0 126 13 9 0   34     0   15   100 97                 197
2040368 2040368 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2019   grade_2 0 17 32 0   1     0   1   30 21                       51.0 0 17 32 0   1     0   1   30 21                 51
2040372 2040372 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 02 2019   grade_2 1 44 13 0   1     0   1   30 30                       60.0 1 44 13 0   1     0   1   30 30                 60
2040386 2040386 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2019   grade_2 39 24 25 0   2     0   4   48 46                       94.0 39 24 25 0   2     0   4   48 46                 94
2041134 2041134 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2019   grade_2 82 0 3 0   6     0   9   52 48                       100.0 82 0 3 0   6     0   9   52 48                 100
2041197 2041197 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2019   grade_2 68 3 5 0   0     0   5   40 41                       81.0 68 3 5 0   0     0   5   40 41                 81
2041689 2041689 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2019   grade_2 45 6 39 0   1     0   2   46 47                       93.0 45 6 39 0   1     0   2   46 47                 93
2041782 2041782 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2019   grade_2 108 2 2 0   2     0   4   63 55                       118.0 108 2 2 0   2     0   4   63 55                 118
2041985 2041985 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2019   grade_2 183 0 3 0   2     0   5   91 102                       193.0 183 0 3 0   2     0   5   91 102                 193
2041997 2041997 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2019   grade_2 137 2 2 1   2     0   7   80 71                       151.0 137 2 2 1   2     0   7   80 71                 151
2042046 2042046 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2019   grade_2 140 1 16 0   11     0   9   99 78                       177.0 140 1 16 0   11     0   9   99 78                 177
2042061 2042061 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2019   grade_2 55 6 9 1   2     1   4   46 32                       78.0 55 6 9 1   2     1   4   46 32                 78
2042065 2042065 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2019   grade_2 72 4 6 0   1     0   2   40 45                       85.0 72 4 6 0   1     0   2   40 45                 85
2042069 2042069 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2019   grade_2 61 7 7 3   1     0   2   38 43                       81.0 61 7 7 3   1     0   2   38 43                 81
2042683 2042683 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2019   grade_2 118 1 5 0   1     0   1   69 57                       126.0 118 1 5 0   1     0   1   69 57                 126
2042725 2042725 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2019   grade_2 8 0 27 0   0     0   5   22 18                       40.0 8 0 27 0   0     0   5   22 18                 40
2042785 2042785 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2019   grade_2 35 2 7 0   1     0   4   25 24                       49.0 35 2 7 0   1     0   4   25 24                 49
2042862 2042862 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2019   grade_2 184 3 12 0   20     0   10   118 111                       229.0 184 3 12 0   20     0   10   118 111                 229
2043039 2043039 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2019   grade_2 139 1 1 0   0     0   1   74 68                       142.0 139 1 1 0   0     0   1   74 68                 142
2043079 2043079 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2019   grade_2 2 2 75 0   0     0   1   43 37                       80.0 2 2 75 0   0     0   1   43 37                 80
2043174 2043174 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No Elementary PK 02 2019   grade_2 75 4 6 0   3     0   4   49 43                       92.0 75 4 6 0   3     0   4   49 43                 92
2043319 2043319 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2019   grade_2 100 0 0 0   13     0   3   60 56                       116.0 100 0 0 0   13     0   3   60 56                 116
2043528 2043528 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2019   grade_2 100 3 8 0   4     0   3   56 62                       118.0 100 3 8 0   4     0   3   56 62                 118
2043755 2043755 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2019   grade_2 191 12 15 0   19     0   12   129 120                       249.0 191 12 15 0   19     0   12   129 120                 249
2043865 2043865 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_2 69 7 3 7   3     1   13   48 55                       103.0 69 7 3 7   3     1   13   48 55                 103
2044076 2044076 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No Elementary KG 02 2019   grade_2 72 0 4 1   4     0   3   38 46                       84.0 72 0 4 1   4     0   3   38 46                 84
2044084 2044084 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2019   grade_2 98 3 49 1   3     0   6   81 79                       160.0 98 3 49 1   3     0   6   81 79                 160
2044087 2044087 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2019   grade_2 90 7 56 0   0     1   4   72 86                       158.0 90 7 56 0   0     1   4   72 86                 158
2044189 2044189 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 02 2019   grade_2 43 7 38 0   1     0   4   47 46                       93.0 43 7 38 0   1     0   4   47 46                 93
2044562 2044562 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2019   grade_2 118 1 1 0   5     0   6   70 61                       131.0 118 1 1 0   5     0   6   70 61                 131
2044875 2044875 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No Elementary PK 02 2019   grade_2 58 3 6 0   0     0   3   39 31                       70.0 58 3 6 0   0     0   3   39 31                 70
2045516 2045516 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2019   grade_2 165 1 10 1   5     0   4   91 95                       186.0 165 1 10 1   5     0   4   91 95                 186
2046271 2046271 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2019   grade_2 80 1 1 0   0     0   2   40 44                       84.0 80 1 1 0   0     0   2   40 44                 84
2046312 2046312 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No Elementary KG 02 2019   grade_2 95 0 1 0   1     0   0   52 45                       97.0 95 0 1 0   1     0   0   52 45                 97
2046316 2046316 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Mark G Hoyle Elementary   Regular School No Elementary PK 02 2019   grade_2 69 0 1 0   0     0   2   39 33                       72.0 69 0 1 0   0     0   2   39 33                 72
2046386 2046386 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2019   grade_2 127 8 17 0   3     1   2   81 77                       158.0 127 8 17 0   3     1   2   81 77                 158
2046389 2046389 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2019   grade_2 111 3 7 0   6     0   1   66 62                       128.0 111 3 7 0   6     0   1   66 62                 128
2046534 2046534 MA Middlesex   school 2512000 308   Waltham 251200002863 3080001 Waltham Public Schools Dual Language Program   Regular School No Elementary KG 02 2019   grade_2 10 1 24 0   2     0   1   20 18                       38.0 10 1 24 0   2     0   1   20 18                 38
2046602 2046602 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2019   grade_2 107 13 14 1   1     0   18   66 88                       154.0 107 13 14 1   1     0   18   66 88                 154
2046847 2046847 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2019   grade_2 70 0 3 0   22     0   3   47 51                       98.0 70 0 3 0   22     0   3   47 51                 98
2046850 2046850 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No Elementary KG 02 2019   grade_2 71 1 1 0   26     0   7   52 54                       106.0 71 1 1 0   26     0   7   52 54                 106
2046856 2046856 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary KG 02 2019   grade_2 51 0 2 0   35     0   5   50 43                       93.0 51 0 2 0   35     0   5   50 43                 93
2046898 2046898 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2019   grade_2 96 0 6 0   0     0   6   61 47                       108.0 96 0 6 0   0     0   6   61 47                 108
2047074 2047074 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2019   grade_2 85 1 7 0   0     0   6   59 40                       99.0 85 1 7 0   0     0   6   59 40                 99
2047131 2047131 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2019   grade_2 119 2 22 0   0     0   2   70 75                       145.0 119 2 22 0   0     0   2   70 75                 145
2048212 2048212 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 John F Kennedy Elementary   Regular School No Elementary KG 02 2019   grade_2 69 2 9 0   0     0   5   41 44                       85.0 69 2 9 0   0     0   5   41 44                 85
2048814 2048814 MA Essex   school 2509450 745   Pentucket 250945000414 7450020 Dr Frederick N Sweetsir   Regular School No Elementary PK 02 2019   grade_2 57 0 2 0   0     0   5   46 18                       64.0 57 0 2 0   0     0   5   46 18                 64
2048940 2048940 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   grade_2 92 2 6 0   1     0   3   55 49                       104.0 92 2 6 0   1     0   3   55 49                 104
2049034 2049034 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2019   grade_2 106 2 5 0   1     0   2   59 57                       116.0 106 2 5 0   1     0   2   59 57                 116
2040104 2040104 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   grade_2 48 3 6 0   3     0   4   36 28                       64.0 48 3 6 0   3     0   4   36 28                 64
2040108 2040108 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   grade_2 35 5 7 0   2     0   3   29 23                       52.0 35 5 7 0   2     0   3   29 23                 52
2040112 2040112 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2019   grade_2 26 16 27 0   1     0   7   33 44                       77.0 26 16 27 0   1     0   7   33 44                 77
2040116 2040116 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2019   grade_2 93 5 4 0   1     0   6   53 56                       109.0 93 5 4 0   1     0   6   53 56                 109
2040148 2040148 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2019   grade_2 138 2 7 0   1     0   9   79 78                       157.0 138 2 7 0   1     0   9   79 78                 157
2040160 2040160 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2019   grade_2 81 0 3 0   2     0   0   44 42                       86.0 81 0 3 0   2     0   0   44 42                 86
2040164 2040164 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_2 71 2 5 0   0     4   2   47 37                       84.0 71 2 5 0   0     4   2   47 37                 84
2040312 2040312 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2019   grade_2 0 18 16 1   3     0   1   24 15                       39.0 0 18 16 1   3     0   1   24 15                 39
2040332 2040332 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2019   grade_2 1 16 18 0   0     0   1   22 14                       36.0 1 16 18 0   0     0   1   22 14                 36
2040363 2040363 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2019   grade_2 0 28 10 0   0     0   2   18 22                       40.0 0 28 10 0   0     0   2   18 22                 40
2042935 2042935 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No Elementary KG 03 2019   grade_2 3 6 58 0   0     0   0   34 33                       67.0 3 6 58 0   0     0   0   34 33                 67
2042962 2042962 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2019   grade_2 207 1 11 1   58     0   3   143 138                       281.0 207 1 11 1   58     0   3   143 138                 281
2043299 2043299 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Hanscom Primary   Regular School No Elementary PK 03 2019   grade_2 33 6 17 0   2     0   8   32 34                       66.0 33 6 17 0   2     0   8   32 34                 66
2043513 2043513 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No Elementary 02 03 2019   grade_2 140 4 20 0   0     0   1   96 69                       165.0 140 4 20 0   0     0   1   96 69                 165
2043769 2043769 MA Essex   school 2507260 168   Marblehead 250726001123 1680005 Malcolm L Bell   Regular School No Elementary KG 03 2019   grade_2 68 1 10 0   1     0   3   47 36                       83.0 68 1 10 0   1     0   3   47 36                 83
2043772 2043772 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 03 2019   grade_2 67 2 10 0   2     0   2   45 38                       83.0 67 2 10 0   2     0   2   45 38                 83
2043780 2043780 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No Elementary PK 03 2019   grade_2 87 0 3 0   2     0   2   45 49                       94.0 87 0 3 0   2     0   2   45 49                 94
2043879 2043879 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2019   grade_2 48 0 1 0   0     0   3   22 30                       52.0 48 0 1 0   0     0   3   22 30                 52
2043887 2043887 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2019   grade_2 80 3 16 0   0     0   8   61 46                       107.0 80 3 16 0   0     0   8   61 46                 107
2043903 2043903 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2019   grade_2 173 1 14 0   6     0   8   116 86                       202.0 173 1 14 0   6     0   8   116 86                 202
2044103 2044103 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No Elementary PK 03 2019   grade_2 81 3 4 0   3     0   12   55 48                       103.0 81 3 4 0   3     0   12   55 48                 103
2044431 2044431 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2019   grade_2 122 1 6 0   4     0   3   69 67                       136.0 122 1 6 0   4     0   3   69 67                 136
2044785 2044785 MA Bristol   school 2509000 218   Norton 250900001450 2180010 L G Nourse Elementary   Regular School No Elementary KG 03 2019   grade_2 58 5 6 0   0     0   2   36 35                       71.0 58 5 6 0   0     0   2   36 35                 71
2044790 2044790 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2019   grade_2 83 1 7 0   0     0   8   45 54                       99.0 83 1 7 0   0     0   8   45 54                 99
2045092 2045092 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No Elementary PK 03 2019   grade_2 78 4 3 0   1     0   6   53 39                       92.0 78 4 3 0   1     0   6   53 39                 92
2045806 2045806 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2019   grade_2 86 1 2 1   23     0   11   61 63                       124.0 86 1 2 1   23     0   11   61 63                 124
2046419 2046419 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Steward Elementary   Regular School No Elementary PK 03 2019   grade_2 77 0 2 1   1     0   3   40 44                       84.0 77 0 2 1   1     0   3   40 44                 84
2046445 2046445 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No Elementary PK 03 2019   grade_2 112 0 5 0   0     0   3   64 56                       120.0 112 0 5 0   0     0   3   64 56                 120
2046587 2046587 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Stanley M Koziol Elementary School   Regular School No Elementary PK 03 2019   grade_2 76 1 3 0   1     0   4   46 39                       85.0 76 1 3 0   1     0   4   46 39                 85
2046746 2046746 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2019   grade_2 53 2 9 0   51     0   6   61 60                       121.0 53 2 9 0   51     0   6   61 60                 121
2046750 2046750 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No Elementary KG 03 2019   grade_2 43 0 5 0   45     0   3   41 55                       96.0 43 0 5 0   45     0   3   41 55                 96
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
2046781 2046781 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2019   grade_2 76 4 4 1   1     0   4   43 47                       90.0 76 4 4 1   1     0   4   43 47                 90
2046879 2046879 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Country   Regular School No Elementary PK 03 2019   grade_2 41 2 6 0   9     0   3   30 31                       61.0 41 2 6 0   9     0   3   30 31                 61
2046886 2046886 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2019   grade_2 54 4 4 0   15     1   2   43 37                       80.0 54 4 4 0   15     1   2   43 37                 80
2047055 2047055 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2019   grade_2 108 2 3 1   4     0   5   65 58                       123.0 108 2 3 1   4     0   5   65 58                 123
2047058 2047058 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2019   grade_2 91 0 8 0   11     0   3   54 59                       113.0 91 0 8 0   11     0   3   54 59                 113
2047500 2047500 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2019   grade_2 108 2 8 0   3     0   3   65 59                       124.0 108 2 8 0   3     0   3   65 59                 124
2047607 2047607 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2019   grade_2 29 16 17 0   3     0   1   31 35                       66.0 29 16 17 0   3     0   1   31 35                 66
2048105 2048105 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Elementary School   Regular School No Elementary PK 03 2019   grade_2 70 3 3 0   0     0   4   48 32                       80.0 70 3 3 0   0     0   4   48 32                 80
2048234 2048234 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2019   grade_2 211 15 2 0   7     0   7   123 119                       242.0 211 15 2 0   7     0   7   123 119                 242
2048301 2048301 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2019   grade_2 47 4 7 2   0     0   9   37 32                       69.0 47 4 7 2   0     0   9   37 32                 69
2048306 2048306 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2019   grade_2 37 6 8 3   0     1   6   40 21                       61.0 37 6 8 3   0     1   6   40 21                 61
2048310 2048310 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2019   grade_2 77 10 8 5   3     1   5   63 46                       109.0 77 10 8 5   3     1   5   63 46                 109
2048398 2048398 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2019   grade_2 80 0 2 0   0     0   1   47 36                       83.0 80 0 2 0   0     0   1   47 36                 83
2048402 2048402 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2019   grade_2 101 1 2 0   0     0   8   58 54                       112.0 101 1 2 0   0     0   8   58 54                 112
2048525 2048525 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Stony Hill School   Regular School No Elementary 02 03 2019   grade_2 141 6 9 0   6     0   6   83 85                       168.0 141 6 9 0   6     0   6   83 85                 168

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