enrollments

Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 6,579 ✖
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
1679226 1679226 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately - Whately Elementary   Regular School No Elementary PK 06 2021   grade_4 15 0 0 0   0     0   0   5 10 *                     15.0 15 0 0 0   0     0   0   5 10                 15
1679360 1679360 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Woburn - Shamrock   Regular School No Elementary PK 05 2021   grade_4 17 5 5 0   1     0   2   20 10 *                     30.0 17 5 5 0   1     0   2   20 10                 30
1679970 1679970 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District) - Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2021   grade_4 14 0 1 0   2     0   5   12 10 *                     22.0 14 0 1 0   2     0   5   12 10                 22
1680877 1680877 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail - Sanderson Academy   Regular School No Elementary PK 06 2021   grade_4 18 0 2 0   0     0   0   10 10 *                     20.0 18 0 2 0   0     0   0   10 10                 20
2040692 2040692 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_4 13 7 7 0   0     0   3   20 10                       30.0 13 7 7 0   0     0   3   20 10                 30
2040907 2040907 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_4 6 9 6 0   0     0   1   12 10                       22.0 6 9 6 0   0     0   1   12 10                 22
2045016 2045016 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2019   grade_4 18 0 0 0   0     0   0   8 10                       18.0 18 0 0 0   0     0   0   8 10                 18
2045169 2045169 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_4 7 5 1 0   0     0   1   4 10                       14.0 7 5 1 0   0     0   1   4 10                 14
2046493 2046493 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   grade_4 13 0 0 0   0     0   2   5 10                       15.0 13 0 0 0   0     0   2   5 10                 15
2046873 2046873 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2019   grade_4 19 0 0 0   1     0   0   10 10                       20.0 19 0 0 0   1     0   0   10 10                 20
2047676 2047676 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_4 0 18 1 0   0     0   0   9 10                       19.0 0 18 1 0   0     0   0   9 10                 19
2048747 2048747 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2019   grade_4 13 0 1 0   0     0   1   5 10                       15.0 13 0 1 0   0     0   1   5 10                 15
2048957 2048957 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_4 15 0 1 1   0     0   2   9 10                       19.0 15 0 1 1   0     0   2   9 10                 19
2229934 2229934 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston: William Ellery Channing   Regular School No Elementary PK 05 2018   grade_4 0 13 7 0   0     0   1   11 10                       21.0 0 13 7 0   0     0   1   11 10                 21
2234917 2234917 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham: Petersham Center   Regular School No Elementary KG 06 2018   grade_4 15 0 0 0   1     0   1   7 10                       17.0 15 0 0 0   1     0   1   7 10                 17
2237358 2237358 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg: Anne T. Dunphy School   Regular School No Elementary PK 06 2018   grade_4 21 0 1 0   1     0   0   13 10                       23.0 21 0 1 0   1     0   0   13 10                 23
2238777 2238777 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Central Berkshire: Becket Washington School   Regular School No Elementary PK 05 2018   grade_4 21 0 0 0   0     0   1   12 10                       22.0 21 0 0 0   0     0   1   12 10                 22
2239253 2239253 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Narragansett: Phillipston Memorial   Regular School No Elementary PK 04 2018   grade_4 19 1 1 0   0     0   0   11 10                       21.0 19 1 1 0   0     0   0   11 10                 21
2238032 2238032 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_4 8 107 65 0   5     0   2   87 100                       187.0 8 107 65 0   5     0   2   87 100                 187
1367445 1367445 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2020   grade_4 107 8 53 0   7     0   14   88 101 *                     189.0 107 8 53 0   7     0   14   88 101                 189
1368830 1368830 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No Elementary 04 05 2020   grade_4 175 5 6 0   12     0   6   103 101 *                     204.0 175 5 6 0   12     0   6   103 101                 204
1672270 1672270 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Auburn - Swanson Road Intermediate School   Regular School No Elementary 03 05 2021   grade_4 166 6 14 0   11     0   9   105 101 *                     206.0 166 6 14 0   11     0   9   105 101                 206
936478 936478 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No 2 04 06 2016   grade_4 170 13 18 2   2     0   8   111 102                       213 170 13 18 2   2     0   8   111 102                 213
1127834 1127834 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2017   grade_4 174 5 8 0   4     0   10   99 102                       201 174 5 8 0   4     0   10   99 102                 201
1367776 1367776 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No Elementary 03 05 2020   grade_4 180 3 11 1   25     0   8   126 102 *                     228.0 180 3 11 1   25     0   8   126 102                 228
937432 937432 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No 1 02 04 2016   grade_4 178 2 11 0   1     1   3   93 103                       196 178 2 11 0   1     1   3   93 103                 196
1125522 1125522 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No Elementary 03 05 2017   grade_4 196 0 15 1   12     0   7   128 103                       231 196 0 15 1   12     0   7   128 103                 231
1364985 1364985 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2020   grade_4 131 5 28 0   32     0   7   100 103 *                     203.0 131 5 28 0   32     0   7   100 103                 203
2233140 2233140 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Ludlow: Veterans Park Elementary   Regular School No Elementary 04 05 2018   grade_4 164 3 28 2   0     0   6   100 103                       203.0 164 3 28 2   0     0   6   100 103                 203
2238937 2238937 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 Freetown-Lakeville: George R Austin Intermediate School   Regular School No Elementary 04 05 2018   grade_4 207 2 0 0   1     0   2   109 103                       212.0 207 2 0 0   1     0   2   109 103                 212
1128696 1128696 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   grade_4 204 5 4 1   2     0   2   114 104                       218 204 5 4 1   2     0   2   114 104                 218
1367607 1367607 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary 02 04 2020   grade_4 183 2 3 0   6     0   1   91 104 *                     195.0 183 2 3 0   6     0   1   91 104                 195
2228997 2228997 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland: David Mindess   Regular School No Elementary 03 05 2018   grade_4 147 1 22 5   26     0   10   107 104                       211.0 147 1 22 5   26     0   10   107 104                 211
739370 739370 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No 2 04 05 2015   grade_4 181 2 13 0   0     1   6   98 105                       203 181 2 13 0   0     1   6   98 105                 203
739760 739760 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No 2 04 05 2015   grade_4 180 2 2 0   7     0   6   92 105                       197 180 2 2 0   7     0   6   92 105                 197
1122191 1122191 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2017   grade_4 144 6 18 0   34     0   6   103 105                       208 144 6 18 0   34     0   6   103 105                 208
938361 938361 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2016   grade_4 91 10 15 1   95     0   7   113 106                       219 91 10 15 1   95     0   7   113 106                 219
1370589 1370589 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2020   grade_4 76 9 16 0   111     0   6   112 106 *                     218.0 76 9 16 0   111     0   6   112 106                 218
2041266 2041266 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2019   grade_4 44 122 23 3   12     1   7   106 106                       212.0 44 122 23 3   12     1   7   106 106                 212
2233673 2233673 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Medway: Burke/Memorial Elementary School   Regular School No Elementary 02 04 2018   grade_4 157 4 5 0   4     0   6   70 106                       176.0 157 4 5 0   4     0   6   70 106                 176
744285 744285 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No 1 03 05 2015   grade_4 229 1 1 0   2     0   1   127 107                       234 229 1 1 0   2     0   1   127 107                 234
932868 932868 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2016   grade_4 164 3 13 0   3     0   2   77 108                       185 164 3 13 0   3     0   2   77 108                 185
935649 935649 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkins Elementary School   Regular School No 2 04 05 2016   grade_4 180 3 5 1   22     0   10   113 108                       221 180 3 5 1   22     0   10   113 108                 221
1366910 1366910 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2020   grade_4 196 2 8 0   0     0   7   105 108 *                     213.0 196 2 8 0   0     0   7   105 108                 213
1373180 1373180 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Middle 04 06 2020   grade_4 187 9 2 0   4     0   13   107 108 *                     215.0 187 9 2 0   4     0   13   107 108                 215
1675021 1675021 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Holliston - Miller School   Regular School No Elementary 03 05 2021   grade_4 181 2 9 2   21     1   8   116 108 *                     224.0 181 2 9 2   21     1   8   116 108                 224
2040132 2040132 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2019   grade_4 143 11 8 0   42     0   8   104 108                       212.0 143 11 8 0   42     0   8   104 108                 212
744196 744196 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No 2 04 05 2015   grade_4 176 15 11 3   6     0   8   110 109                       219 176 15 11 3   6     0   8   110 109                 219
2229186 2229186 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham: Bellingham Memorial School   Regular School No Middle 04 07 2018   grade_4 165 4 10 0   3     0   6   79 109                       188.0 165 4 10 0   3     0   6   79 109                 188
2231292 2231292 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Duxbury: Alden School   Regular School No Elementary 03 05 2018   grade_4 216 1 8 0   2     0   5   123 109                       232.0 216 1 8 0   2     0   5   123 109                 232
2235518 2235518 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich: Oak Ridge   Regular School No Elementary 03 06 2018   grade_4 189 5 6 2   8     0   2   103 109                       212.0 189 5 6 2   8     0   2   103 109                 212
2235692 2235692 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury: Floral Street School   Regular School No Elementary 01 04 2018   grade_4 93 2 16 1   95     0   8   106 109                       215.0 93 2 16 1   95     0   8   106 109                 215
736079 736079 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_4 25 0 1 0   0     0   0   15 11                       26 25 0 1 0   0     0   0   15 11                 26
737870 737870 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No 1 KG 04 2015   grade_4 17 0 3 0   2     0   0   11 11                       22 17 0 3 0   2     0   0   11 11                 22
740207 740207 MA Bristol   school 2508430 201   New Bedford 250843001328 2010085 Horatio A Kempton   Regular School No 1 KG 05 2015   grade_4 13 2 2 0   0     0   1   7 11                       18 13 2 2 0   0     0   1   7 11                 18
741660 741660 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2015   grade_4 10 6 6 0   2     0   0   13 11                       24 10 6 6 0   2     0   0   13 11                 24
742821 742821 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2015   grade_4 16 0 8 0   0     0   0   13 11                       24 16 0 8 0   0     0   0   13 11                 24
743565 743565 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 2015   grade_4 1 0 20 0   1     0   0   11 11                       22 1 0 20 0   1     0   0   11 11                 22
744272 744272 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_4 14 0 0 0   0     0   0   3 11                       14 14 0 0 0   0     0   0   3 11                 14
933627 933627 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_4 1 8 13 0   0     0   1   12 11                       23 1 8 13 0   0     0   1   12 11                 23
934219 934219 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2016   grade_4 10 14 5 0   4     0   5   27 11                       38 10 14 5 0   4     0   5   27 11                 38
934718 934718 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   grade_4 22 1 0 0   1     0   0   13 11                       24 22 1 0 0   1     0   0   13 11                 24
938100 938100 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2016   grade_4 21 1 1 0   0     0   1   13 11                       24 21 1 1 0   0     0   1   13 11                 24
938167 938167 MA Essex   school 2510380 258   Salem 251038001656 2580015 Carlton   Regular School No 1 KG 05 2016   grade_4 22 2 9 0   0     0   3   25 11                       36 22 2 9 0   0     0   3   25 11                 36
941519 941519 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No 1 PK 06 2016   grade_4 25 0 0 0   0     0   1   15 11                       26 25 0 0 0   0     0   1   15 11                 26
1123229 1123229 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_4 5 5 17 0   0     0   2   18 11                       29 5 5 17 0   0     0   2   18 11                 29
1128552 1128552 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_4 18 1 1 0   0     0   0   9 11                       20 18 1 1 0   0     0   0   9 11                 20
1129998 1129998 MA Middlesex   school 2512180 314   Watertown 251218001998 3140015 Cunniff   Regular School No Elementary PK 05 2017   grade_4 35 2 3 0   2     0   0   31 11                       42 35 2 3 0   2     0   0   31 11                 42
1130521 1130521 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_4 16 0 2 0   0     0   0   7 11                       18 16 0 2 0   0     0   0   7 11                 18
1130530 1130530 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   grade_4 19 1 0 0   0     0   0   9 11                       20 19 1 0 0   0     0   0   9 11                 20
1130746 1130746 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_4 10 5 7 0   1     0   0   12 11                       23 10 5 7 0   1     0   0   12 11                 23
1130806 1130806 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_4 4 3 16 0   1     0   2   15 11                       26 4 3 16 0   1     0   2   15 11                 26
1130910 1130910 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary PK 06 2017   grade_4 7 10 9 0   2     0   2   19 11                       30 7 10 9 0   2     0   2   19 11                 30
1132749 1132749 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_4 19 0 2 0   0     0   2   12 11                       23 19 0 2 0   0     0   2   12 11                 23
1365302 1365302 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_4 8 6 6 0   0     0   2   11 11 *                     22.0 8 6 6 0   0     0   2   11 11                 22
1365465 1365465 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2020   grade_4 1 26 9 0   2     0   5   32 11 *                     43.0 1 26 9 0   2     0   5   32 11                 43
1365730 1365730 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2020   grade_4 1 16 9 1   0     0   2   18 11 *                     29.0 1 16 9 1   0     0   2   18 11                 29
1365774 1365774 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2020   grade_4 2 11 11 0   0     0   0   13 11 *                     24.0 2 11 11 0   0     0   0   13 11                 24
1369222 1369222 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No Elementary PK 05 2020   grade_4 14 1 11 0   2     0   2   19 11 *                     30.0 14 1 11 0   2     0   2   19 11                 30
1371973 1371973 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2020   grade_4 23 1 0 0   0     0   0   13 11 *                     24.0 23 1 0 0   0     0   0   13 11                 24
1372604 1372604 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_4 0 15 6 0   0     0   0   10 11 *                     21.0 0 15 6 0   0     0   0   10 11                 21
1373686 1373686 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2020   grade_4 14 0 1 0   0     0   2   6 11 *                     17.0 14 0 1 0   0     0   2   6 11                 17
1373774 1373774 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2020   grade_4 24 0 0 0   0     0   0   13 11 *                     24.0 24 0 0 0   0     0   0   13 11                 24
1374284 1374284 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_4 17 5 3 0   1     0   0   15 11 *                     26.0 17 5 3 0   1     0   0   15 11                 26
1672524 1672524 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_4 10 6 7 0   1     0   1   14 11 *                     25.0 10 6 7 0   1     0   1   14 11                 25
1672799 1672799 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston - Joseph P Manning   Regular School No Elementary PK 06 2021   grade_4 7 1 9 0   5     0   3   14 11 *                     25.0 7 1 9 0   5     0   3   14 11                 25
1672936 1672936 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Boston - Phineas Bates   Regular School No Elementary PK 05 2021   grade_4 7 9 12 0   1     0   0   18 11 *                     29.0 7 9 12 0   1     0   0   18 11                 29
1673011 1673011 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_4 1 15 7 0   0     0   1   13 11 *                     24.0 1 15 7 0   0     0   1   13 11                 24
1673683 1673683 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 Cambridge - John M Tobin   Regular School No Elementary PK 05 2021   grade_4 14 3 2 0   10     0   4   22 11 *                     33.0 14 3 2 0   10     0   4   22 11                 33
1674057 1674057 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham - Greenlodge   Regular School No Elementary 01 05 2021   grade_4 32 2 4 0   0     0   1   28 11 *                     39.0 32 2 4 0   0     0   1   28 11                 39
1676569 1676569 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 New Bedford - William H Taylor   Regular School No Elementary PK 05 2021   grade_4 20 5 4 0   0     0   2   20 11 *                     31.0 20 5 4 0   0     0   2   20 11                 31
1678448 1678448 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland - Sunderland Elementary   Regular School No Elementary PK 06 2021   grade_4 21 1 2 0   2     0   3   18 11 *                     29.0 21 1 2 0   2     0   3   18 11                 29
1679234 1679234 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg - Anne T. Dunphy School   Regular School No Elementary PK 06 2021   grade_4 16 1 0 0   0     0   0   6 11 *                     17.0 16 1 0 0   0     0   0   6 11                 17
1679398 1679398 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester - Wawecus Road School   Regular School No Elementary KG 06 2021   grade_4 5 3 9 0   3     0   0   9 11 *                     20.0 5 3 9 0   3     0   0   9 11                 20
1680668 1680668 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill-Montague - Gill Elementary   Regular School No Elementary KG 06 2021   grade_4 18 0 1 0   0     0   0   8 11 *                     19.0 18 0 1 0   0     0   0   8 11                 19
2040668 2040668 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2019   grade_4 11 5 3 1   2     0   3   14 11                       25.0 11 5 3 1   2     0   3   14 11                 25
2045161 2045161 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2019   grade_4 22 0 0 0   0     0   0   11 11                       22.0 22 0 0 0   0     0   0   11 11                 22
2045690 2045690 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   grade_4 18 1 1 0   1     0   1   11 11                       22.0 18 1 1 0   1     0   1   11 11                 22
2047047 2047047 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   grade_4 17 0 3 0   0     0   0   9 11                       20.0 17 0 3 0   0     0   0   9 11                 20
2048467 2048467 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2019   grade_4 15 1 1 0   0     0   2   8 11                       19.0 15 1 1 0   0     0   2   8 11                 19

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