Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_4 · 6,679
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
936604 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No 2 04 05 2016   grade_4 165 1 5 2   8     0   6   99 88                       187 165 1 5 2   8     0   6   99 88                 187
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
2045664 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_4 72 6 11 2   96     0   10   99 98                       197.0 72 6 11 2   96     0   10   99 98                 197
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
932541 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_4 169 4 8 0   0     0   2   98 85                       183 169 4 8 0   0     0   2   98 85                 183
935207 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 02 04 2016   grade_4 147 5 31 0   3     0   22   98 110                       208 147 5 31 0   3     0   22   98 110                 208
932856 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2016   grade_4 114 14 10 0   22     0   11   97 74                       171 114 14 10 0   22     0   11   97 74                 171
1124223 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_4 116 10 35 0   2     0   3   97 69                       166 116 10 35 0   2     0   3   97 69                 166
1124498 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No Elementary 03 06 2017   grade_4 150 6 1 1   0     0   6   97 67                       164 150 6 1 1   0     0   6   97 67                 164
2231315 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater: Gordon W Mitchell   Regular School No Elementary 03 06 2018   grade_4 150 6 4 1   1     0   8   97 73                       170.0 150 6 4 1   1     0   8   97 73                 170
932890 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_4 164 1 7 0   9     0   4   96 89                       185 164 1 7 0   9     0   4   96 89                 185
934704 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2016   grade_4 159 3 4 0   1     0   6   96 77                       173 159 3 4 0   1     0   6   96 77                 173
1673433 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_4 53 98 27 1   7     0   4   96 94 *                     190.0 53 98 27 1   7     0   4   96 94                 190
1674140 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Duxbury - Alden School   Regular School No Elementary 03 05 2021   grade_4 183 0 4 0   2     0   6   96 99 *                     195.0 183 0 4 0   2     0   6   96 99                 195
744399 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002139 6800030 Soule Road   Regular School No 2 04 05 2015   grade_4 147 3 10 1   4     0   3   95 73                       168 147 3 10 1   4     0   3   95 73                 168
932799 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No 1 03 05 2016   grade_4 148 3 12 0   7     0   6   95 81                       176 148 3 12 0   7     0   6   95 81                 176
2233601 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Medfield: Dale Street   Regular School No Elementary 04 05 2018   grade_4 158 1 14 0   4     0   6   95 88                       183.0 158 1 14 0   4     0   6   95 88                 183
1128871 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_4 73 3 22 0   85     0   6   94 95                       189 73 3 22 0   85     0   6   94 95                 189
1371530 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2020   grade_4 115 12 23 4   1     0   18   94 79 *                     173.0 115 12 23 4   1     0   18   94 79                 173
2233449 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead: Village School   Regular School No Middle 04 06 2018   grade_4 161 4 14 0   3     0   7   94 95                       189.0 161 4 14 0   3     0   7   94 95                 189
735861 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No 1 03 05 2015   grade_4 130 6 16 0   25     0   6   93 90                       183 130 6 16 0   25     0   6   93 90                 183
740296 MA Essex   school 2508580 204   Newburyport 250858002624 2040030 Edward G. Molin Elementary School   Regular School No 2 04 05 2015   grade_4 177 0 3 0   2     0   3   93 92                       185 177 0 3 0   2     0   3   93 92                 185
740664 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No 2 04 05 2015   grade_4 175 2 5 0   2     1   4   93 96                       189 175 2 5 0   2     1   4   93 96                 189
742770 MA Middlesex   school 2512750 330   Weston 251275000785 3300012 Field Elementary School   Regular School No 2 04 05 2015   grade_4 115 12 6 1   18     0   10   93 69                       162 115 12 6 1   18     0   10   93 69                 162
934367 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2016   grade_4 14 8 149 0   2     0   0   93 80                       173 14 8 149 0   2     0   0   93 80                 173
937132 MA Essex   school 2508580 204   Newburyport 250858002624 2040030 Edward G. Molin Elementary School   Regular School No 2 04 05 2016   grade_4 161 4 3 0   6     0   1   93 82                       175 161 4 3 0   6     0   1   93 82                 175
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
1367957 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2020   grade_4 165 2 6 1   0     0   0   93 81 *                     174.0 165 2 6 1   0     0   0   93 81                 174
1672331 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford - Lt Job Lane School   Regular School No Elementary 03 05 2021   grade_4 117 15 13 0   33     0   13   93 98 *                     191.0 117 15 13 0   33     0   13   93 98                 191
2039812 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_4 143 3 13 0   4     0   2   93 72                       165.0 143 3 13 0   4     0   2   93 72                 165
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
1126780 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No Elementary 04 05 2017   grade_4 151 1 12 0   5     0   9   92 86                       178 151 1 12 0   5     0   9   92 86                 178
1132060 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Heritage School   Regular School No Elementary 02 04 2017   grade_4 140 1 19 0   2     1   3   92 74                       166 140 1 19 0   2     1   3   92 74                 166
1369718 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2020   grade_4 149 1 6 0   2     1   11   92 78 *                     170.0 149 1 6 0   2     1   11   92 78                 170
2237909 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham: Charles E Roderick   Regular School No Middle 04 06 2018   grade_4 139 4 7 0   4     0   7   92 69                       161.0 139 4 7 0   4     0   7   92 69                 161
737117 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2015   grade_4 51 101 19 0   9     0   8   91 97                       188 51 101 19 0   9     0   8   91 97                 188
1122268 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2017   grade_4 142 1 16 0   6     0   7   91 81                       172 142 1 16 0   6     0   7   91 81                 172
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
1368889 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No Elementary 02 04 2020   grade_4 156 5 3 0   2     1   5   91 81 *                     172.0 156 5 3 0   2     1   5   91 81                 172
1675674 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Ludlow - Veterans Park Elementary   Regular School No Elementary 04 05 2021   grade_4 128 4 26 0   0     0   2   91 69 *                     160.0 128 4 26 0   0     0   2   91 69                 160
2040144 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Middle 04 06 2019   grade_4 140 3 14 1   1     0   10   91 78                       169.0 140 3 14 1   1     0   10   91 78                 169
2229158 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Belchertown: Chestnut Hill Community School   Regular School No Middle 04 06 2018   grade_4 166 2 7 1   2     0   3   91 90                       181.0 166 2 7 1   2     0   3   91 90                 181
2237385 MA Middlesex   school 2513050 342   Wilmington 251305001575 3420060 Wilmington: North Intermediate   Regular School No Elementary 04 05 2018   grade_4 151 3 2 0   4     0   6   91 75                       166.0 151 3 2 0   4     0   6   91 75                 166
939838 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2016   grade_4 129 1 24 0   2     0   3   90 69                       159 129 1 24 0   2     0   3   90 69                 159
1365118 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Middle 04 06 2020   grade_4 142 4 6 2   3     0   6   90 73 *                     163.0 142 4 6 2   3     0   6   90 73                 163
1371603 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2020   grade_4 80 9 55 0   2     0   9   90 65 *                     155.0 80 9 55 0   2     0   9   90 65                 155
1680442 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Bridgewater-Raynham - Laliberte Elementary School   Regular School No Elementary 02 04 2021   grade_4 148 21 5 0   4     0   7   90 95 *                     185.0 148 21 5 0   4     0   7   90 95                 185
2044792 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2019   grade_4 157 4 10 3   2     0   6   90 92                       182.0 157 4 10 3   2     0   6   90 92                 182
2047133 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2019   grade_4 115 4 25 0   0     0   4   90 58                       148.0 115 4 25 0   0     0   4   90 58                 148
2236791 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Wareham: Minot Forest   Regular School No Elementary 03 04 2018   grade_4 139 20 13 2   3     0   26   90 113                       203.0 139 20 13 2   3     0   26   90 113                 203
2238740 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Bridgewater-Raynham: Laliberte Elementary School   Regular School No Elementary 02 04 2018   grade_4 149 10 0 0   4     0   7   90 80                       170.0 149 10 0 0   4     0   7   90 80                 170
2238891 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Dudley-Charlton Reg: Heritage School   Regular School No Elementary 02 04 2018   grade_4 155 2 12 1   3     0   3   90 86                       176.0 155 2 12 1   3     0   3   90 86                 176
737864 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   grade_4 23 0 0 0   1     0   0   9 15                       24 23 0 0 0   1     0   0   9 15                 24
738884 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_4 18 0 0 0   0     0   1   9 10                       19 18 0 0 0   0     0   1   9 10                 19
740044 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   grade_4 14 0 0 0   0     0   0   9 5                       14 14 0 0 0   0     0   0   9 5                 14
740887 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   grade_4 16 0 0 0   0     0   1   9 8                       17 16 0 0 0   0     0   1   9 8                 17
744034 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2015   grade_4 22 1 0 0   0     0   0   9 14                       23 22 1 0 0   0     0   0   9 14                 23
744791 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No 1 PK 04 2015   grade_4 11 0 0 1   0     0   1   9 4                       13 11 0 0 1   0     0   1   9 4                 13
934464 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_4 17 0 0 0   0     0   0   9 8                       17 17 0 0 0   0     0   0   9 8                 17
936329 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_4 3 1 5 0   0     0   1   9 1                       10 3 1 5 0   0     0   1   9 1                 10
939109 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2016   grade_4 15 1 2 0   0     0   1   9 10                       19 15 1 2 0   0     0   1   9 10                 19
941132 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No 1 PK 04 2016   grade_4 15 1 2 0   0     0   1   9 10                       19 15 1 2 0   0     0   1   9 10                 19
1122565 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_4 4 4 6 0   1     0   1   9 7                       16 4 4 6 0   1     0   1   9 7                 16
1124284 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_4 18 0 1 0   0     0   0   9 10                       19 18 0 1 0   0     0   0   9 10                 19
1126008 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_4 15 1 2 0   1     0   2   9 12                       21 15 1 2 0   1     0   2   9 12                 21
1127116 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_4 22 0 0 0   0     0   0   9 13                       22 22 0 0 0   0     0   0   9 13                 22
1128118 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   grade_4 26 2 1 0   0     0   2   9 22                       31 26 2 1 0   0     0   2   9 22                 31
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
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
1131747 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   grade_4 25 0 1 0   0     0   0   9 17                       26 25 0 1 0   0     0   0   9 17                 26
1131947 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   grade_4 15 0 0 0   0     0   0   9 6                       15 15 0 0 0   0     0   0   9 6                 15
1132091 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_4 16 0 0 0   0     0   0   9 7                       16 16 0 0 0   0     0   0   9 7                 16
1368162 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2020   grade_4 14 0 0 0   0     0   1   9 6 *                     15.0 14 0 0 0   0     0   1   9 6                 15
1369112 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2020   grade_4 20 0 1 0   0     0   0   9 12 *                     21.0 20 0 1 0   0     0   0   9 12                 21
1370329 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_4 13 1 2 0   0     0   0   9 7 *                     16.0 13 1 2 0   0     0   0   9 7                 16
1370776 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2020   grade_4 1 2 7 0   0     0   0   9 1 *                     10.0 1 2 7 0   0     0   0   9 1                 10
1371799 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2020   grade_4 14 0 2 0   0     0   1   9 8 *                     17.0 14 0 2 0   0     0   1   9 8                 17
1372284 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2020   grade_4 15 0 3 0   3     0   2   9 14 *                     23.0 15 0 3 0   3     0   2   9 14                 23
1373203 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2020   grade_4 15 0 1 0   0     0   0   9 7 *                     16.0 15 0 1 0   0     0   0   9 7                 16
1373629 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No Elementary KG 05 2020   grade_4 12 0 2 0   0     0   1   9 6 *                     15.0 12 0 2 0   0     0   1   9 6                 15
1672950 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston - Roger Clap   Regular School No Elementary PK 06 2021   grade_4 2 10 5 0   1     0   0   9 9 *                     18.0 2 10 5 0   1     0   0   9 9                 18
1673047 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Boston - Winship Elementary   Regular School No Elementary PK 05 2021   grade_4 3 3 12 0   0     0   0   9 9 *                     18.0 3 3 12 0   0     0   0   9 9                 18
1676359 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant - Johnson   Regular School No Elementary PK 06 2021   grade_4 16 0 0 0   0     0   2   9 9 *                     18.0 16 0 0 0   0     0   2   9 9                 18
1677865 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury - Shutesbury Elementary   Regular School No Elementary PK 06 2021   grade_4 14 0 1 0   0     0   1   9 7 *                     16.0 14 0 1 0   0     0   1   9 7                 16
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
1680486 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Central Berkshire - Kittredge   Regular School No Elementary PK 05 2021   grade_4 23 0 0 0   0     0   1   9 15 *                     24.0 23 0 0 0   0     0   1   9 15                 24
1680941 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell - Swift River   Regular School No Elementary PK 06 2021   grade_4 17 0 0 0   0     0   1   9 9 *                     18.0 17 0 0 0   0     0   1   9 9                 18
1681023 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Pioneer Valley - Bernardston Elementary   Regular School No Elementary PK 06 2021   grade_4 24 0 0 0   0     0   0   9 15 *                     24.0 24 0 0 0   0     0   0   9 15                 24
1681097 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 Southern Berkshire - New Marlborough Central   Regular School No Elementary PK 04 2021   grade_4 17 0 0 0   0     0   0   9 8 *                     17.0 17 0 0 0   0     0   0   9 8                 17
2042013 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2019   grade_4 24 1 0 0   0     0   1   9 17                       26.0 24 1 0 0   0     0   1   9 17                 26
2043625 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 05 2019   grade_4 2 0 8 0   0     0   0   9 1                       10.0 2 0 8 0   0     0   0   9 1                 10
2044980 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2019   grade_4 16 0 1 0   0     0   1   9 9                       18.0 16 0 1 0   0     0   1   9 9                 18
2046426 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2019   grade_4 9 0 1 0   0     0   2   9 3                       12.0 9 0 1 0   0     0   2   9 3                 12
2046742 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2019   grade_4 14 0 1 0   0     0   0   9 6                       15.0 14 0 1 0   0     0   0   9 6                 15
2047039 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2019   grade_4 16 0 0 0   0     0   1   9 8                       17.0 16 0 0 0   0     0   1   9 8                 17
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
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
2048677 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2019   grade_4 15 0 1 1   0     0   1   9 9                       18.0 15 0 1 1   0     0   1   9 9                 18
2048874 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_4 29 0 1 0   0     0   0   9 21                       30.0 29 0 1 0   0     0   0   9 21                 30
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

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