enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2230912 2230912 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_4 8 7 150 0   2     0   3   101 69                       170.0 8 7 150 0   2     0   3   101 69                 170
735994 735994 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2015   grade_4 174 1 6 0   6     1   8   102 94                       196 174 1 6 0   6     1   8   102 94                 196
1122352 1122352 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Elementary 04 06 2017   grade_4 161 9 4 0   6     1   1   102 80                       182 161 9 4 0   6     1   1   102 80                 182
1131204 1131204 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_4 13 95 73 2   4     0   4   102 89                       191 13 95 73 2   4     0   4   102 89                 191
2234581 2234581 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 Northbridge: W Edward Balmer   Regular School No Elementary 02 04 2018   grade_4 158 0 16 0   2     0   4   102 78                       180.0 158 0 16 0   2     0   4   102 78                 180
933984 933984 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_4 60 85 25 2   12     0   12   103 93                       196 60 85 25 2   12     0   12   103 93                 196
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
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
2046604 2046604 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2019   grade_4 127 20 17 2   1     1   24   103 89                       192.0 127 20 17 2   1     1   24   103 89                 192
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
738693 738693 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No 1 03 05 2015   grade_4 166 2 13 1   11     0   6   104 95                       199 166 2 13 1   11     0   6   104 95                 199
1365107 1365107 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2020   grade_4 120 12 14 0   40     0   16   104 98 *                     202.0 120 12 14 0   40     0   16   104 98                 202
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
2229142 2229142 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford: Lt Job Lane School   Regular School No Elementary 03 05 2018   grade_4 144 9 4 0   38     0   8   104 99                       203.0 144 9 4 0   38     0   8   104 99                 203
2234655 2234655 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Norton: Henri A. Yelle   Regular School No Elementary 04 05 2018   grade_4 168 5 6 0   7     0   9   104 91                       195.0 168 5 6 0   7     0   9   104 91                 195
932737 932737 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No 1 03 05 2016   grade_4 140 5 21 1   28     0   7   105 97                       202 140 5 21 1   28     0   7   105 97                 202
1130325 1130325 MA Middlesex   school 2512750 330   Weston 251275000785 3300012 Field Elementary School   Regular School No Elementary 04 05 2017   grade_4 121 18 11 0   28     0   12   105 85                       190 121 18 11 0   28     0   12   105 85                 190
1366199 1366199 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_4 49 96 32 1   10     0   11   105 94 *                     199.0 49 96 32 1   10     0   11   105 94                 199
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
1370444 1370444 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_4 182 2 7 0   6     2   0   105 94 *                     199.0 182 2 7 0   6     2   0   105 94                 199
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
939282 939282 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No 1 03 04 2016   grade_4 145 18 19 0   2     0   17   106 95                       201 145 18 19 0   2     0   17   106 95                 201
2040012 2040012 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2019   grade_4 152 6 20 5   32     0   4   106 113                       219.0 152 6 20 5   32     0   4   106 113                 219
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
2231038 2231038 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton: Clinton Middle School   Regular School No Middle 04 08 2018   grade_4 138 6 31 0   3     0   6   106 78                       184.0 138 6 31 0   3     0   6   106 78                 184
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
741556 741556 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2015   grade_4 104 5 10 1   71     0   6   107 90                       197 104 5 10 1   71     0   6   107 90                 197
1126317 1126317 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No Elementary 04 05 2017   grade_4 159 7 13 2   0     0   5   107 79                       186 159 7 13 2   0     0   5   107 79                 186
1365047 1365047 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2020   grade_4 162 6 25 0   4     0   6   107 96 *                     203.0 162 6 25 0   4     0   6   107 96                 203
1368704 1368704 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_4 166 6 18 0   0     0   14   107 97 *                     204.0 166 6 18 0   0     0   14   107 97                 204
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
1680606 1680606 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 Freetown-Lakeville - George R Austin Intermediate School   Regular School No Middle 04 06 2021   grade_4 183 2 7 0   0     0   8   107 93 *                     200.0 183 2 7 0   0     0   8   107 93                 200
2040075 2040075 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2019   grade_4 159 5 22 0   14     0   4   107 97                       204.0 159 5 22 0   14     0   4   107 97                 204
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
2231929 2231929 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   grade_4 127 2 36 0   4     0   16   107 78                       185.0 127 2 36 0   4     0   16   107 78                 185
742475 742475 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No 1 03 04 2015   grade_4 176 14 12 3   0     0   15   108 112                       220 176 14 12 3   0     0   15   108 112                 220
1123645 1123645 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2017   grade_4 54 100 26 1   10     0   6   108 89                       197 54 100 26 1   10     0   6   108 89                 197
1125100 1125100 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   grade_4 136 4 39 0   3     0   21   108 95                       203 136 4 39 0   3     0   21   108 95                 203
1131909 1131909 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2017   grade_4 157 8 2 1   2     0   3   108 65                       173 157 8 2 1   2     0   3   108 65                 173
1672208 1672208 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland - David Mindess   Regular School No Elementary 03 05 2021   grade_4 141 4 35 0   32     0   10   108 114 *                     222.0 141 4 35 0   32     0   10   108 114                 222
1675945 1675945 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead - Village School   Regular School No Elementary 03 06 2021   grade_4 173 4 15 0   4     0   4   108 92 *                     200.0 173 4 15 0   4     0   4   108 92                 200
2042857 2042857 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No Elementary 03 05 2019   grade_4 171 4 9 0   29     0   10   108 115                       223.0 171 4 9 0   29     0   10   108 115                 223
938215 938215 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 03 06 2016   grade_4 227 0 1 0   2     0   1   109 122                       231 227 0 1 0   2     0   1   109 122                 231
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
736512 736512 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   grade_4 1 12 12 0   0     0   1   11 15                       26 1 12 12 0   0     0   1   11 15                 26
736738 736738 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_4 0 16 7 1   1     0   0   11 14                       25 0 16 7 1   1     0   0   11 14                 25
737338 737338 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No 1 PK 05 2015   grade_4 5 10 4 0   5     0   2   11 15                       26 5 10 4 0   5     0   2   11 15                 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
738626 738626 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_4 13 0 19 0   0     0   0   11 21                       32 13 0 19 0   0     0   0   11 21                 32
740851 740851 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No 1 KG 06 2015   grade_4 14 0 1 0   1     0   1   11 6                       17 14 0 1 0   1     0   1   11 6                 17
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
744697 744697 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No 1 PK 06 2015   grade_4 16 0 0 0   0     0   4   11 9                       20 16 0 0 0   0     0   4   11 9                 20
933047 933047 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No 1 KG 08 2016   grade_4 5 2 5 0   2     0   2   11 5                       16 5 2 5 0   2     0   2   11 5                 16
933481 933481 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No 1 PK 05 2016   grade_4 7 4 9 0   0     0   0   11 9                       20 7 4 9 0   0     0   0   11 9                 20
934233 934233 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No 1 PK 05 2016   grade_4 10 4 3 0   4     0   2   11 12                       23 10 4 3 0   4     0   2   11 12                 23
934247 934247 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No 1 PK 05 2016   grade_4 3 10 5 0   1     0   1   11 9                       20 3 10 5 0   1     0   1   11 9                 20
934816 934816 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Webster School   Regular School No 1 PK 04 2016   grade_4 9 5 13 0   1     0   1   11 18                       29 9 5 13 0   1     0   1   11 18                 29
937715 937715 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2016   grade_4 18 0 0 0   0     0   0   11 7                       18 18 0 0 0   0     0   0   11 7                 18
939487 939487 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2016   grade_4 22 0 6 0   1     0   1   11 19                       30 22 0 6 0   1     0   1   11 19                 30
939517 939517 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Russell Elementary School   Regular School No 1 KG 05 2016   grade_4 21 0 3 0   0     0   1   11 14                       25 21 0 3 0   0     0   1   11 14                 25
940809 940809 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2016   grade_4 30 1 0 0   0     0   0   11 20                       31 30 1 0 0   0     0   0   11 20                 31
941534 941534 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No 1 PK 06 2016   grade_4 26 0 1 0   0     0   1   11 17                       28 26 0 1 0   0     0   1   11 17                 28
1122988 1122988 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_4 15 3 7 0   0     0   1   11 15                       26 15 3 7 0   0     0   1   11 15                 26
1125901 1125901 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   grade_4 31 0 5 0   0     0   2   11 27                       38 31 0 5 0   0     0   2   11 27                 38
1130425 1130425 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Paul Hanlon   Regular School No Elementary KG 05 2017   grade_4 22 0 0 0   4     0   1   11 16                       27 22 0 0 0   4     0   1   11 16                 27
1131413 1131413 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2017   grade_4 24 3 5 0   1     0   0   11 22                       33 24 3 5 0   1     0   0   11 22                 33
1132130 1132130 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2017   grade_4 19 0 1 1   0     0   0   11 10                       21 19 0 1 1   0     0   0   11 10                 21
1132586 1132586 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2017   grade_4 19 0 0 0   0     0   2   11 10                       21 19 0 0 0   0     0   2   11 10                 21
1132699 1132699 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   grade_4 15 0 1 1   0     0   1   11 7                       18 15 0 1 1   0     0   1   11 7                 18
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
1365570 1365570 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2020   grade_4 8 5 6 0   0     0   1   11 9 *                     20.0 8 5 6 0   0     0   1   11 9                 20
1369942 1369942 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2020   grade_4 14 0 0 0   1     0   2   11 6 *                     17.0 14 0 0 0   1     0   2   11 6                 17
1371350 1371350 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_4 12 1 2 0   0     0   4   11 8 *                     19.0 12 1 2 0   0     0   4   11 8                 19
1372085 1372085 MA Middlesex   school 2513200 347   Woburn 251320002187 3470025 Linscott-Rumford   Regular School No Elementary KG 05 2020   grade_4 12 3 4 0   3     0   3   11 14 *                     25.0 12 3 4 0   3     0   3   11 14                 25
1372277 1372277 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary KG 06 2020   grade_4 12 10 10 0   0     0   2   11 23 *                     34.0 12 10 10 0   0     0   2   11 23                 34
1373082 1373082 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2020   grade_4 24 0 0 0   0     0   0   11 13 *                     24.0 24 0 0 0   0     0   0   11 13                 24
1675407 1675407 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett - Leverett Elementary   Regular School No Elementary PK 06 2021   grade_4 14 0 0 0   0     0   3   11 6 *                     17.0 14 0 0 0   0     0   3   11 6                 17
1677728 1677728 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Saugus - Douglas Waybright   Regular School No Elementary KG 05 2021   grade_4 19 0 1 0   1     0   0   11 10 *                     21.0 19 0 1 0   1     0   0   11 10                 21
1678155 1678155 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Springfield - Kensington International School   Regular School No Elementary PK 05 2021   grade_4 6 4 21 0   1     0   0   11 21 *                     32.0 6 4 21 0   1     0   0   11 21                 32
1679181 1679181 MA Norfolk   school 2512840 336   Weymouth 251284000509 3360060 Weymouth - Thomas V Nash   Regular School No Elementary KG 05 2021   grade_4 29 1 2 0   0     0   0   11 21 *                     32.0 29 1 2 0   0     0   0   11 21                 32
1679526 1679526 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester - Lincoln Street   Regular School No Elementary KG 06 2021   grade_4 4 8 8 0   3     0   0   11 12 *                     23.0 4 8 8 0   3     0   0   11 12                 23
1680748 1680748 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont - Hawlemont Regional   Regular School No Elementary PK 06 2021   grade_4 20 0 3 0   0     0   0   11 12 *                     23.0 20 0 3 0   0     0   0   11 12                 23
1681132 1681132 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield - East Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_4 21 0 3 0   0     0   0   11 13 *                     24.0 21 0 3 0   0     0   0   11 13                 24
2040345 2040345 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_4 11 8 7 0   0     0   0   11 15                       26.0 11 8 7 0   0     0   0   11 15                 26
2040759 2040759 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2019   grade_4 4 14 7 0   2     0   0   11 16                       27.0 4 14 7 0   2     0   0   11 16                 27
2042570 2042570 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2019   grade_4 24 1 5 0   0     0   0   11 19                       30.0 24 1 5 0   0     0   0   11 19                 30
2042876 2042876 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 04 2019   grade_4 6 1 22 0   0     0   0   11 18                       29.0 6 1 22 0   0     0   0   11 18                 29
2044393 2044393 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No Elementary PK 05 2019   grade_4 23 4 5 0   0     0   4   11 25                       36.0 23 4 5 0   0     0   4   11 25                 36
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
2047262 2047262 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2019   grade_4 7 7 11 0   0     0   1   11 15                       26.0 7 7 11 0   0     0   1   11 15                 26
2048547 2048547 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2019   grade_4 17 0 1 0   0     0   1   11 8                       19.0 17 0 1 0   0     0   1   11 8                 19
2048860 2048860 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2019   grade_4 21 0 2 1   0     0   0   11 13                       24.0 21 0 2 1   0     0   0   11 13                 24
2229656 2229656 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston: John D Philbrick   Regular School No Elementary PK 05 2018   grade_4 3 10 9 0   0     0   1   11 12                       23.0 3 10 9 0   0     0   1   11 12                 23
2229786 2229786 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston: Nathan Hale   Regular School No Elementary PK 05 2018   grade_4 1 15 4 0   1     0   3   11 13                       24.0 1 15 4 0   1     0   3   11 13                 24
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
2231351 2231351 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton: Neil A Pepin   Regular School No Elementary KG 04 2018   grade_4 15 0 3 0   1     0   0   11 8                       19.0 15 0 3 0   1     0   0   11 8                 19
2234876 2234876 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham: Pelham Elementary   Regular School No Elementary KG 06 2018   grade_4 21 0 1 0   1     0   1   11 13                       24.0 21 0 1 0   1     0   1   11 13                 24
2237536 2237536 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Woburn: Wyman   Regular School No Elementary KG 05 2018   grade_4 13 1 0 0   4     0   0   11 7                       18.0 13 1 0 0   4     0   0   11 7                 18
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

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