Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by female 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
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
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
1126628 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 04 06 2017   grade_4 205 5 10 0   2     0   7   131 98                       229 205 5 10 0   2     0   7   131 98                 229
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
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
1674858 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Hanover - Center Elementary   Regular School No Elementary 02 04 2021   grade_4 198 1 5 0   3     0   2   111 98 *                     209.0 198 1 5 0   3     0   2   111 98                 209
1680514 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth - Nathaniel H. Wixon School   Regular School No Elementary 04 05 2021   grade_4 148 25 20 8   5     2   20   130 98 *                     228.0 148 25 20 8   5     2   20   130 98                 228
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
2047613 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_4 14 93 67 1   4     0   4   85 98                       183.0 14 93 67 1   4     0   4   85 98                 183
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
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
937493 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No 2 04 05 2016   grade_4 147 3 9 1   5     0   11   79 97                       176 147 3 9 1   5     0   11   79 97                 176
940954 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No 2 04 06 2016   grade_4 207 5 7 0   0     0   13   135 97                       232 207 5 7 0   0     0   13   135 97                 232
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
1676965 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Norton - Henri A. Yelle   Regular School No Elementary 04 05 2021   grade_4 148 6 9 0   0     0   11   77 97 *                     174.0 148 6 9 0   0     0   11   77 97                 174
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
2043774 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Middle 04 06 2019   grade_4 179 10 18 0   5     0   9   124 97                       221.0 179 10 18 0   5     0   9   124 97                 221
737832 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No 1 03 05 2015   grade_4 222 0 2 0   1     0   7   136 96                       232 222 0 2 0   1     0   7   136 96                 232
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
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
1372538 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_4 10 99 66 0   2     0   4   85 96 *                     181.0 10 99 66 0   2     0   4   85 96                 181
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
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
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
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
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
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
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
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
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
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
1677840 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_4 66 5 19 1   115     0   7   119 94 *                     213.0 66 5 19 1   115     0   7   119 94                 213
2040166 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2019   grade_4 154 5 6 0   3     0   4   78 94                       172.0 154 5 6 0   3     0   4   78 94                 172
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
1124097 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_4 10 6 149 0   1     0   4   77 93                       170 10 6 149 0   1     0   4   77 93                 170
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
2044729 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2019   grade_4 149 2 11 0   0     0   11   80 93                       173.0 149 2 11 0   0     0   11   80 93                 173
2048240 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2019   grade_4 148 10 0 1   4     0   6   76 93                       169.0 148 10 0 1   4     0   6   76 93                 169
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
742550 MA Worcester   school 2512240 316   Webster 251224002298 3160305 Webster Middle School   Regular School No 1 03 06 2015   grade_4 105 5 37 0   2     0   8   65 92                       157 105 5 37 0   2     0   8   65 92                 157
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
2041980 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2019   grade_4 167 0 4 0   3     0   18   100 92                       192.0 167 0 4 0   3     0   18   100 92                 192
2043515 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No Elementary 04 05 2019   grade_4 137 2 20 1   2     0   5   75 92                       167.0 137 2 20 1   2     0   5   75 92                 167
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
2045518 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2019   grade_4 181 4 1 0   4     0   2   100 92                       192.0 181 4 1 0   4     0   2   100 92                 192
735663 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_4 162 6 0 1   3     0   0   81 91                       172 162 6 0 1   3     0   0   81 91                 172
737850 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2015   grade_4 163 4 1 1   3     0   3   84 91                       175 163 4 1 1   3     0   3   84 91                 175
739823 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No 1 02 04 2015   grade_4 154 1 5 1   4     0   2   76 91                       167 154 1 5 1   4     0   2   76 91                 167
1366062 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne Intermediate School   Regular School No Elementary 03 05 2020   grade_4 138 5 17 1   1     2   7   80 91 *                     171.0 138 5 17 1   1     2   7   80 91                 171
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
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
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
1369656 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2020   grade_4 123 0 14 0   1     0   9   57 90 *                     147.0 123 0 14 0   1     0   9   57 90                 147
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
736586 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_4 7 9 5 0   2     0   0   14 9                       23 7 9 5 0   2     0   0   14 9                 23
742616 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No 1 PK 05 2015   grade_4 15 1 0 0   0     0   1   8 9                       17 15 1 0 0   0     0   1   8 9                 17
742939 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg Schools   Regular School No 1 PK 06 2015   grade_4 27 0 0 0   0     0   0   18 9                       27 27 0 0 0   0     0   0   18 9                 27
743166 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2015   grade_4 4 11 13 0   0     0   0   19 9                       28 4 11 13 0   0     0   0   19 9                 28
744139 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_4 22 0 0 0   0     0   0   13 9                       22 22 0 0 0   0     0   0   13 9                 22
744168 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No 1 PK 05 2015   grade_4 18 0 1 0   0     0   0   10 9                       19 18 0 1 0   0     0   0   10 9                 19
744346 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No 1 KG 06 2015   grade_4 18 3 0 0   0     0   1   13 9                       22 18 3 0 0   0     0   1   13 9                 22
744549 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No 1 KG 06 2015   grade_4 16 0 1 0   0     0   0   8 9                       17 16 0 1 0   0     0   0   8 9                 17
744563 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No 1 PK 04 2015   grade_4 18 0 1 0   0     0   0   10 9                       19 18 0 1 0   0     0   0   10 9                 19
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
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
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
934798 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2016   grade_4 18 0 1 0   0     0   2   12 9                       21 18 0 1 0   0     0   2   12 9                 21
939175 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No 1 PK 06 2016   grade_4 18 0 3 0   0     0   1   13 9                       22 18 0 3 0   0     0   1   13 9                 22
940067 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2016   grade_4 11 5 10 1   0     0   0   18 9                       27 11 5 10 1   0     0   0   18 9                 27
940472 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_4 17 0 2 0   0     0   2   12 9                       21 17 0 2 0   0     0   2   12 9                 21
941172 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No 1 KG 06 2016   grade_4 15 0 0 0   0     0   2   8 9                       17 15 0 0 0   0     0   2   8 9                 17
941252 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2016   grade_4 12 0 0 0   0     0   1   4 9                       13 12 0 0 0   0     0   1   4 9                 13
941658 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 PK 06 2016   grade_4 20 0 3 0   0     0   0   14 9                       23 20 0 3 0   0     0   0   14 9                 23
1122961 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   grade_4 10 7 2 0   2     0   4   16 9                       25 10 7 2 0   2     0   4   16 9                 25
1125166 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2017   grade_4 21 0 4 0   1     0   0   17 9                       26 21 0 4 0   1     0   0   17 9                 26
1128903 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   grade_4 13 1 1 0   0     0   1   7 9                       16 13 1 1 0   0     0   1   7 9                 16
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
1365642 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2020   grade_4 0 15 5 0   2     0   0   13 9 *                     22.0 0 15 5 0   2     0   0   13 9                 22
1367024 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2020   grade_4 20 0 1 0   0     0   1   13 9 *                     22.0 20 0 1 0   0     0   1   13 9                 22
1369906 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2020   grade_4 11 0 5 0   0     0   1   8 9 *                     17.0 11 0 5 0   0     0   1   8 9                 17
1371668 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary KG 05 2020   grade_4 12 1 0 0   0     0   3   7 9 *                     16.0 12 1 0 0   0     0   3   7 9                 16
1372136 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_4 5 3 9 0   2     0   2   12 9 *                     21.0 5 3 9 0   2     0   2   12 9                 21
1373607 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2020   grade_4 16 1 0 0   0     0   0   8 9 *                     17.0 16 1 0 0   0     0   0   8 9                 17
1373794 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_4 21 0 4 0   0     0   0   16 9 *                     25.0 21 0 4 0   0     0   0   16 9                 25
1672676 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston - George H Conley   Regular School No Elementary PK 06 2021   grade_4 4 9 11 0   0     0   0   15 9 *                     24.0 4 9 11 0   0     0   0   15 9                 24
1672858 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Boston - Mozart   Regular School No Elementary PK 05 2021   grade_4 6 8 6 0   1     0   2   14 9 *                     23.0 6 8 6 0   1     0   2   14 9                 23
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
1678584 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury - Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_4 14 3 10 0   0     0   1   19 9 *                     28.0 14 3 10 0   0     0   1   19 9                 28
1679129 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Westwood - Deerfield School   Regular School No Elementary KG 05 2021   grade_4 21 1 2 0   3     0   4   22 9 *                     31.0 21 1 2 0   3     0   4   22 9                 31
1680346 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Athol-Royalston - Royalston Community School   Regular School No Elementary KG 06 2021   grade_4 21 0 0 0   0     0   0   12 9 *                     21.0 21 0 0 0   0     0   0   12 9                 21
1680473 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Central Berkshire - Becket Washington School   Regular School No Elementary PK 05 2021   grade_4 18 0 0 0   0     0   1   10 9 *                     19.0 18 0 0 0   0     0   1   10 9                 19
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
1681045 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin - Hardwick Elementary   Regular School No Elementary PK 06 2021   grade_4 18 0 4 0   0     0   1   14 9 *                     23.0 18 0 4 0   0     0   1   14 9                 23
2044183 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2019   grade_4 17 0 0 0   0     0   0   8 9                       17.0 17 0 0 0   0     0   0   8 9                 17
2044576 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary PK 06 2019   grade_4 17 0 0 0   1     0   4   13 9                       22.0 17 0 0 0   1     0   4   13 9                 22
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
2047777 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2019   grade_4 17 0 1 0   0     0   4   13 9                       22.0 17 0 1 0   0     0   4   13 9                 22
2048264 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   grade_4 15 0 1 1   0     0   0   8 9                       17.0 15 0 1 1   0     0   0   8 9                 17

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