enrollments

Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by female descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,218 ✖
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
935539 935539 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No 1 03 05 2016   grade_5 174 1 13 1   13     0   6   109 99                       208 174 1 13 1   13     0   6   109 99                 208
937494 937494 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No 2 04 05 2016   grade_5 176 3 5 1   2     0   5   93 99                       192 176 3 5 1   2     0   5   93 99                 192
1672475 1672475 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica - Marshall Middle School   Regular School No Middle 05 07 2021   grade_5 136 16 20 1   23     0   4   101 99 *                     200.0 136 16 20 1   23     0   4   101 99                 200
2043775 2043775 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Middle 04 06 2019   grade_5 165 6 15 0   3     0   8   98 99                       197.0 165 6 15 0   3     0   8   98 99                 197
2046605 2046605 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2019   grade_5 123 15 12 2   2     0   29   84 99                       183.0 123 15 12 2   2     0   29   84 99                 183
744333 744333 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2015   grade_5 169 1 3 0   19     1   3   98 98                       196 169 1 3 0   19     1   3   98 98                 196
1125336 1125336 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2017   grade_5 209 1 3 0   5     0   1   121 98                       219 209 1 3 0   5     0   1   121 98                 219
1372539 1372539 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_5 13 95 64 1   4     0   4   83 98 *                     181.0 13 95 64 1   4     0   4   83 98                 181
2231935 2231935 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner: Gardner Middle School   Regular School No Middle 05 07 2018   grade_5 137 4 45 0   3     0   19   110 98                       208.0 137 4 45 0   3     0   19   110 98                 208
2233450 2233450 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead: Village School   Regular School No Middle 04 06 2018   grade_5 205 5 13 0   3     0   6   134 98                       232.0 205 5 13 0   3     0   6   134 98                 232
2235519 2235519 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich: Oak Ridge   Regular School No Elementary 03 06 2018   grade_5 191 4 4 1   2     0   3   107 98                       205.0 191 4 4 1   2     0   3   107 98                 205
735983 735983 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2015   grade_5 143 10 7 0   35     0   7   105 97                       202 143 10 7 0   35     0   7   105 97                 202
742175 742175 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No 2 05 08 2015   grade_5 156 7 22 0   5     0   2   95 97                       192 156 7 22 0   5     0   2   95 97                 192
742771 742771 MA Middlesex   school 2512750 330   Weston 251275000785 3300012 Field Elementary School   Regular School No 2 04 05 2015   grade_5 123 14 9 1   20     0   7   77 97                       174 123 14 9 1   20     0   7   77 97                 174
1122192 1122192 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2017   grade_5 140 4 21 1   25     0   7   101 97                       198 140 4 21 1   25     0   7   101 97                 198
1131205 1131205 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_5 11 97 71 0   3     0   2   87 97                       184 11 97 71 0   3     0   2   87 97                 184
1365048 1365048 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2020   grade_5 160 5 23 0   16     0   4   111 97 *                     208.0 160 5 23 0   16     0   4   111 97                 208
1368705 1368705 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_5 183 9 16 0   5     0   9   125 97 *                     222.0 183 9 16 0   5     0   9   125 97                 222
1674683 1674683 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner - Gardner Middle School   Regular School No Middle 05 07 2021   grade_5 96 8 50 0   7     0   16   80 97 *                     177.0 96 8 50 0   7     0   16   80 97                 177
2041631 2041631 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2019   grade_5 144 5 9 1   34     0   7   103 97                       200.0 144 5 9 1   34     0   7   103 97                 200
2042326 2042326 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_5 63 7 103 0   7     1   12   96 97                       193.0 63 7 103 0   7     1   12   96 97                 193
738229 738229 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2015   grade_5 185 5 7 2   4     0   3   110 96                       206 185 5 7 2   4     0   3   110 96                 206
744479 744479 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 05 08 2015   grade_5 186 1 10 0   3     0   1   105 96                       201 186 1 10 0   3     0   1   105 96                 201
935023 935023 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_5 62 12 98 0   12     0   16   104 96                       200 62 12 98 0   12     0   16   104 96                 200
936932 936932 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No 2 05 08 2016   grade_5 137 0 6 0   21     0   5   73 96                       169 137 0 6 0   21     0   5   73 96                 169
1127835 1127835 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2017   grade_5 143 3 9 1   5     0   11   76 96                       172 143 3 9 1   5     0   11   76 96                 172
1368433 1368433 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No Elementary 04 05 2020   grade_5 136 3 22 0   3     0   7   75 96 *                     171.0 136 3 22 0   3     0   7   75 96                 171
1369719 1369719 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2020   grade_5 159 5 10 2   2     0   8   90 96 *                     186.0 159 5 10 2   2     0   8   90 96                 186
932738 932738 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No 1 03 05 2016   grade_5 138 6 16 2   29     0   6   102 95                       197 138 6 16 2   29     0   6   102 95                 197
932869 932869 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2016   grade_5 181 2 6 0   6     1   8   109 95                       204 181 2 6 0   6     1   8   109 95                 204
933985 933985 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_5 53 101 16 0   9     0   9   93 95                       188 53 101 16 0   9     0   9   93 95                 188
934705 934705 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2016   grade_5 162 5 2 1   3     0   3   81 95                       176 162 5 2 1   3     0   3   81 95                 176
939043 939043 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2016   grade_5 157 31 27 1   5     0   5   131 95                       226 157 31 27 1   5     0   5   131 95                 226
1124948 1124948 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2017   grade_5 175 14 8 0   5     0   3   110 95                       205 175 14 8 0   5     0   3   110 95                 205
1366561 1366561 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_5 131 5 14 0   27     1   14   97 95 *                     192.0 131 5 14 0   27     1   14   97 95                 192
1367256 1367256 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_5 57 11 84 0   5     0   18   80 95 *                     175.0 57 11 84 0   5     0   18   80 95                 175
1672332 1672332 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford - Lt Job Lane School   Regular School No Elementary 03 05 2021   grade_5 117 13 12 0   41     0   16   104 95 *                     199.0 117 13 12 0   41     0   16   104 95                 199
1672478 1672478 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica - Locke Middle   Regular School No Middle 05 07 2021   grade_5 147 12 13 0   17     0   7   101 95 *                     196.0 147 12 13 0   17     0   7   101 95                 196
1675868 1675868 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield - Lynnfield Middle School   Regular School No Middle 05 08 2021   grade_5 162 4 13 0   8     0   7   99 95 *                     194.0 162 4 13 0   8     0   7   99 95                 194
1679802 1679802 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_5 8 101 62 0   2     0   4   82 95 *                     177.0 8 101 62 0   2     0   4   82 95                 177
2040145 2040145 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Middle 04 06 2019   grade_5 162 2 8 1   2     0   3   83 95                       178.0 162 2 8 1   2     0   3   83 95                 178
2230461 2230461 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton: Louis F Angelo Elementary   Regular School No Elementary KG 05 2018   grade_5 52 113 25 0   10     0   8   113 95                       208.0 52 113 25 0   10     0   8   113 95                 208
2232263 2232263 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_5 88 11 70 0   4     0   4   82 95                       177.0 88 11 70 0   4     0   4   82 95                 177
738531 738531 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2015   grade_5 204 1 3 0   4     0   0   118 94                       212 204 1 3 0   4     0   0   118 94                 212
936669 936669 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No 2 05 08 2016   grade_5 159 1 5 1   4     0   2   78 94                       172 159 1 5 1   4     0   2   78 94                 172
1122030 1122030 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_5 150 3 14 0   3     1   2   79 94                       173 150 3 14 0   3     1   2   79 94                 173
1127766 1127766 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2017   grade_5 163 2 11 0   1     1   4   88 94                       182 163 2 11 0   1     1   4   88 94                 182
1366911 1366911 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2020   grade_5 170 1 4 0   3     0   18   102 94 *                     196.0 170 1 4 0   3     0   18   102 94                 196
1370357 1370357 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2020   grade_5 140 12 26 0   2     0   7   93 94 *                     187.0 140 12 26 0   2     0   7   93 94                 187
2047614 2047614 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_5 5 102 67 0   5     0   2   87 94                       181.0 5 102 67 0   5     0   2   87 94                 181
2231776 2231776 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough: John J Ahern   Regular School No Middle 05 08 2018   grade_5 181 8 6 1   8     0   4   114 94                       208.0 181 8 6 1   8     0   4   114 94                 208
740665 740665 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No 2 04 05 2015   grade_5 178 4 5 0   1     0   5   100 93                       193 178 4 5 0   1     0   5   100 93                 193
933840 933840 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_5 148 0 2 0   6     0   8   71 93                       164 148 0 2 0   6     0   8   71 93                 164
1373563 1373563 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2020   grade_5 137 6 10 1   0     0   8   69 93 *                     162.0 137 6 10 1   0     0   8   69 93                 162
1672271 1672271 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Auburn - Swanson Road Intermediate School   Regular School No Elementary 03 05 2021   grade_5 160 4 22 0   3     0   6   102 93 *                     195.0 160 4 22 0   3     0   6   102 93                 195
1676401 1676401 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 Natick - J F Kennedy Middle School   Regular School No Middle 05 08 2021   grade_5 146 3 12 0   37     0   14   119 93 *                     212.0 146 3 12 0   37     0   14   119 93                 212
1676907 1676907 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge - Northbridge Middle   Regular School No Middle 05 08 2021   grade_5 123 0 16 0   2     0   9   57 93 *                     150.0 123 0 16 0   2     0   9   57 93                 150
1677696 1677696 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich - Oak Ridge   Regular School No Elementary 03 06 2021   grade_5 173 2 8 0   7     2   0   99 93 *                     192.0 173 2 8 0   7     2   0   99 93                 192
736022 736022 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial Middle School   Regular School No 2 05 08 2015   grade_5 169 4 2 0   5     0   4   92 92                       184 169 4 2 0   5     0   4   92 92                 184
739552 739552 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No 2 05 08 2015   grade_5 161 1 5 0   6     0   4   85 92                       177 161 1 5 0   6     0   4   85 92                 177
739824 739824 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No 2 05 08 2015   grade_5 172 1 6 1   8     0   4   100 92                       192 172 1 6 1   8     0   4   100 92                 192
940235 940235 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_5 25 14 117 5   2     2   0   73 92                       165 25 14 117 5   2     2   0   73 92                 165
1365256 1365256 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 05 07 2020   grade_5 139 5 11 0   11     0   13   87 92 *                     179.0 139 5 11 0   11     0   13   87 92                 179
1673792 1673792 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_5 126 9 18 0   33     0   5   99 92 *                     191.0 126 9 18 0   33     0   5   99 92                 191
1680446 1680446 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham - Raynham Middle School   Regular School No Middle 05 08 2021   grade_5 150 16 6 0   6     0   5   91 92 *                     183.0 150 16 6 0   6     0   5   91 92                 183
2235896 2235896 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 South Hadley: Michael E. Smith Middle School   Regular School No Middle 05 08 2018   grade_5 124 1 26 0   3     0   2   64 92                       156.0 124 1 26 0   3     0   2   64 92                 156
737118 737118 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2015   grade_5 57 85 21 0   7     3   10   92 91                       183 57 85 21 0   7     3   10   92 91                 183
941078 941078 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2016   grade_5 165 0 6 0   3     1   2   86 91                       177 165 0 6 0   3     1   2   86 91                 177
941330 941330 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2016   grade_5 140 6 9 0   2     0   8   74 91                       165 140 6 9 0   2     0   8   74 91                 165
1126781 1126781 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No Elementary 04 05 2017   grade_5 168 2 5 2   8     0   6   100 91                       191 168 2 5 2   8     0   6   100 91                 191
1369660 1369660 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2020   grade_5 145 2 8 0   0     0   14   78 91 *                     169.0 145 2 8 0   0     0   14   78 91                 169
1673434 1673434 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_5 42 94 31 1   11     0   10   98 91 *                     189.0 42 94 31 1   11     0   10   98 91                 189
2041122 2041122 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_5 150 2 7 4   4     0   5   81 91                       172.0 150 2 7 4   4     0   5   81 91                 172
2043902 2043902 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No Elementary 04 05 2019   grade_5 162 1 14 0   5     0   6   97 91                       188.0 162 1 14 0   5     0   6   97 91                 188
2047525 2047525 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_5 28 12 129 1   2     0   1   82 91                       173.0 28 12 129 1   2     0   1   82 91                 173
2239166 2239166 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton: Miscoe Hill School   Regular School No Middle 05 08 2018   grade_5 170 0 9 0   7     0   7   102 91                       193.0 170 0 9 0   7     0   7   102 91                 193
735896 735896 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_5 153 7 18 0   6     0   7   101 90                       191 153 7 18 0   6     0   7   101 90                 191
932542 932542 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2016   grade_5 157 8 3 0   2     0   3   83 90                       173 157 8 3 0   2     0   3   83 90                 173
932891 932891 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_5 153 3 7 0   7     0   1   81 90                       171 153 3 7 0   7     0   1   81 90                 171
1366557 1366557 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2020   grade_5 134 9 14 1   27     0   10   105 90 *                     195.0 134 9 14 1   27     0   10   105 90                 195
1367315 1367315 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2020   grade_5 137 7 15 1   12     0   8   90 90 *                     180.0 137 7 15 1   12     0   8   90 90                 180
1675675 1675675 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Ludlow - Veterans Park Elementary   Regular School No Elementary 04 05 2021   grade_5 128 3 28 0   1     1   7   78 90 *                     168.0 128 3 28 0   1     1   7   78 90                 168
2048370 2048370 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2019   grade_5 159 2 12 1   3     0   3   90 90                       180.0 159 2 12 1   3     0   3   90 90                 180
2048524 2048524 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002139 6800030 Soule Road   Regular School No Elementary 04 05 2019   grade_5 152 7 14 0   0     0   6   89 90                       179.0 152 7 14 0   0     0   6   89 90                 179
2239197 2239197 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District: Monomoy Regional Middle School   Regular School No Middle 05 07 2018   grade_5 162 14 10 0   1     1   2   100 90                       190.0 162 14 10 0   1     1   2   100 90                 190
736614 736614 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No 1 PK 05 2015   grade_5 5 4 8 0   3     0   1   12 9                       21 5 4 8 0   3     0   1   12 9                 21
736628 736628 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2015   grade_5 2 18 8 1   0     0   3   23 9                       32 2 18 8 1   0     0   3   23 9                 32
740888 740888 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   grade_5 12 0 3 0   0     0   2   8 9                       17 12 0 3 0   0     0   2   8 9                 17
742822 742822 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2015   grade_5 19 1 7 0   0     0   0   18 9                       27 19 1 7 0   0     0   0   18 9                 27
742932 742932 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2015   grade_5 18 0 0 0   0     0   0   9 9                       18 18 0 0 0   0     0   0   9 9                 18
744035 744035 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2015   grade_5 17 0 2 0   1     0   0   11 9                       20 17 0 2 0   1     0   0   11 9                 20
744155 744155 MA Berkshire   school 2503390 635   Central Berkshire 250339002545 6350010 Berkshire Trail Elementary   Regular School No 1 PK 05 2015   grade_5 12 0 0 0   0     0   1   4 9                       13 12 0 0 0   0     0   1   4 9                 13
744273 744273 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_5 15 0 0 0   0     0   1   7 9                       16 15 0 0 0   0     0   1   7 9                 16
745191 745191 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2015   grade_5 9 3 1 0   0     0   1   5 9                       14 9 3 1 0   0     0   1   5 9                 14
933406 933406 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2016   grade_5 0 12 6 0   0     0   0   9 9                       18 0 12 6 0   0     0   0   9 9                 18
937393 937393 MA Bristol   school 2508730 212   North Attleborough 250873001199 2120030 Community   Regular School No 1 KG 05 2016   grade_5 21 3 3 0   3     1   1   23 9                       32 21 3 3 0   3     1   1   23 9                 32
939110 939110 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2016   grade_5 12 0 1 0   1     0   1   6 9                       15 12 0 1 0   1     0   1   6 9                 15
939859 939859 MA Middlesex   school 2513200 347   Woburn 251320002183 3470020 Daniel P Hurld   Regular School No 1 KG 05 2016   grade_5 30 0 1 0   0     0   0   22 9                       31 30 0 1 0   0     0   0   22 9                 31
940366 940366 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2016   grade_5 0 17 3 0   0     0   0   11 9                       20 0 17 3 0   0     0   0   11 9                 20
940389 940389 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_5 1 0 18 0   1     0   0   11 9                       20 1 0 18 0   1     0   0   11 9                 20

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