Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by female

View and edit SQL

year

grade

  • grade_1 · 6,780
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
2238774 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Central Berkshire: Becket Washington School   Regular School No Elementary PK 05 2018   grade_1 17 0 1 0   0     0   1   9 10                       19.0 17 0 1 0   0     0   1   9 10                 19
2239314 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell: Swift River   Regular School No Elementary PK 06 2018   grade_1 15 0 1 0   0     0   1   7 10                       17.0 15 0 1 0   0     0   1   7 10                 17
2239463 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 Quabbin: New Braintree Grade   Regular School No Elementary KG 01 2018   grade_1 19 1 0 0   0     0   0   10 10                       20.0 19 1 0 0   0     0   0   10 10                 20
735979 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   grade_1 143 14 6 0   32     0   7   102 100                       202 143 14 6 0   32     0   7   102 100                 202
1129971 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   grade_1 156 10 15 2   2     0   30   115 100                       215 156 10 15 2   2     0   30   115 100                 215
1370441 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2020   grade_1 171 4 7 0   7     0   1   90 100 *                     190.0 171 4 7 0   7     0   1   90 100                 190
1122332 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   grade_1 123 11 15 0   35     0   16   99 101                       200 123 11 15 0   35     0   16   99 101                 200
1124480 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2017   grade_1 183 2 7 0   2     0   6   99 101                       200 183 2 7 0   2     0   6   99 101                 200
1125104 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   grade_1 118 6 35 1   4     0   17   80 101                       181 118 6 35 1   4     0   17   80 101                 181
1675025 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston - Placentino Elementary   Regular School No Elementary PK 02 2021   grade_1 154 3 5 0   26     0   4   91 101 *                     192.0 154 3 5 0   26     0   4   91 101                 192
1675929 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield - Everett W Robinson   Regular School No Elementary KG 02 2021   grade_1 162 10 11 1   16     1   10   109 101 *                     211.0 162 10 11 1   16     1   10   109 101                 211
2238029 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_1 8 104 66 0   4     0   2   83 101                       184.0 8 104 66 0   4     0   2   83 101                 184
738697 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2015   grade_1 171 2 15 1   12     0   4   103 102                       205 171 2 15 1   12     0   4   103 102                 205
1126601 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   grade_1 182 4 21 0   24     0   14   143 102                       245 182 4 21 0   24     0   14   143 102                 245
1131900 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   grade_1 179 9 7 0   2     0   8   103 102                       205 179 9 7 0   2     0   8   103 102                 205
939278 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2016   grade_1 166 18 14 1   2     0   26   124 103                       227 166 18 14 1   2     0   26   124 103                 227
2040009 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_1 123 9 25 1   36     0   10   100 104                       204.0 123 9 25 1   36     0   10   100 104                 204
940946 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No 1 PK 03 2016   grade_1 179 16 7 0   1     0   9   107 105                       212 179 16 7 0   1     0   9   107 105                 212
2043900 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2019   grade_1 164 4 6 0   4     0   9   82 105                       187.0 164 4 6 0   4     0   9   82 105                 187
1674855 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Hanover - Cedar Elementary   Regular School No Elementary PK 01 2021   grade_1 201 3 3 0   3     0   1   105 106 *                     211.0 201 3 3 0   3     0   1   105 106                 211
2043754 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2019   grade_1 183 7 9 1   20     0   14   128 106                       234.0 183 7 9 1   20     0   14   128 106                 234
935542 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2016   grade_1 168 2 9 0   23     0   9   104 107                       211 168 2 9 0   23     0   9   104 107                 211
1372535 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_1 17 86 78 0   3     0   5   82 107 *                     189.0 17 86 78 0   3     0   5   82 107                 189
1128692 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   grade_1 199 3 8 0   5     1   0   107 109                       216 199 3 8 0   5     1   0   107 109                 216
1368688 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2020   grade_1 178 10 12 0   14     0   14   119 109 *                     228.0 178 10 12 0   14     0   14   119 109                 228
736076 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_1 23 0 2 0   1     0   0   15 11                       26 23 0 2 0   1     0   0   15 11                 26
736199 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2015   grade_1 13 6 5 0   0     0   0   13 11                       24 13 6 5 0   0     0   0   13 11                 24
736411 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2015   grade_1 11 7 7 0   0     0   2   16 11                       27 11 7 7 0   0     0   2   16 11                 27
737555 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   grade_1 17 1 5 0   0     0   0   12 11                       23 17 1 5 0   0     0   0   12 11                 23
737861 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   grade_1 20 1 0 0   1     0   1   12 11                       23 20 1 0 0   1     0   1   12 11                 23
740585 MA Worcester   school 2508880 213   Northborough 250888001436 2130015 Fannie E Proctor   Regular School No 1 KG 05 2015   grade_1 19 0 2 0   6     1   2   19 11                       30 19 0 2 0   6     1   2   19 11                 30
741667 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No 1 PK 08 2015   grade_1 12 5 16 0   5     0   1   28 11                       39 12 5 16 0   5     0   1   28 11                 39
742138 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2015   grade_1 23 2 3 0   1     0   2   20 11                       31 23 2 3 0   1     0   2   20 11                 31
743109 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2015   grade_1 9 0 11 0   2     0   2   13 11                       24 9 0 11 0   2     0   2   13 11                 24
743715 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_1 11 0 0 0   0     0   2   2 11                       13 11 0 0 0   0     0   2   2 11                 13
743973 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2015   grade_1 28 0 1 0   0     0   0   18 11                       29 28 0 1 0   0     0   0   18 11                 29
744031 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2015   grade_1 18 2 0 0   0     0   1   10 11                       21 18 2 0 0   0     0   1   10 11                 21
933385 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   grade_1 13 3 3 0   3     0   1   12 11                       23 13 3 3 0   3     0   1   12 11                 23
937732 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No 1 PK 05 2016   grade_1 26 0 1 0   0     0   4   20 11                       31 26 0 1 0   0     0   4   20 11                 31
938382 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2016   grade_1 15 1 1 0   0     0   2   8 11                       19 15 1 1 0   0     0   2   8 11                 19
939172 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No 1 PK 06 2016   grade_1 15 0 1 1   0     0   2   8 11                       19 15 0 1 1   0     0   2   8 11                 19
939741 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No 1 PK 06 2016   grade_1 18 0 2 0   0     0   0   9 11                       20 18 0 2 0   0     0   0   9 11                 20
940363 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2016   grade_1 0 20 1 0   0     0   1   11 11                       22 0 20 1 0   0     0   1   11 11                 22
941129 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No 1 PK 04 2016   grade_1 16 1 1 1   0     0   0   8 11                       19 16 1 1 1   0     0   0   8 11                 19
1122889 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2017   grade_1 11 3 6 0   1     0   2   12 11                       23 11 3 6 0   1     0   2   12 11                 23
1123166 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_1 9 5 15 0   3     0   1   22 11                       33 9 5 15 0   3     0   1   22 11                 33
1124155 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   grade_1 17 0 4 0   0     0   1   11 11                       22 17 0 4 0   0     0   1   11 11                 22
1125364 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_1 18 0 2 0   1     0   0   10 11                       21 18 0 2 0   1     0   0   10 11                 21
1130134 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   grade_1 13 1 1 0   0     0   3   7 11                       18 13 1 1 0   0     0   3   7 11                 18
1130408 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Deerfield School   Regular School No Elementary KG 05 2017   grade_1 22 0 2 0   3     0   3   19 11                       30 22 0 2 0   3     0   3   19 11                 30
1131266 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_1 0 17 5 0   0     0   0   11 11                       22 0 17 5 0   0     0   0   11 11                 22
1132300 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Essex Elementary   Regular School No Elementary KG 05 2017   grade_1 27 0 0 0   0     0   1   17 11                       28 27 0 0 0   0     0   1   17 11                 28
1132394 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   grade_1 18 1 0 0   0     0   0   8 11                       19 18 1 0 0   0     0   0   8 11                 19
1132510 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 Ashby Elementary   Regular School No Elementary KG 04 2017   grade_1 35 0 0 0   0     0   0   24 11                       35 35 0 0 0   0     0   0   24 11                 35
1372601 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_1 0 8 12 0   0     0   0   9 11 *                     20.0 0 8 12 0   0     0   0   9 11                 20
1372772 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_1 15 0 2 0   0     0   0   6 11 *                     17.0 15 0 2 0   0     0   0   6 11                 17
1372842 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2020   grade_1 29 0 2 0   0     0   1   21 11 *                     32.0 29 0 2 0   0     0   1   21 11                 32
1373079 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2020   grade_1 20 1 1 0   0     0   2   13 11 *                     24.0 20 1 1 0   0     0   2   13 11                 24
1373763 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2020   grade_1 20 0 1 0   0     0   0   10 11 *                     21.0 20 0 1 0   0     0   0   10 11                 21
1373994 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2020   grade_1 21 1 3 0   1     0   0   15 11 *                     26.0 21 1 3 0   1     0   0   15 11                 26
1672495 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Boston - Baldwin Early Learning Center   Regular School No Elementary PK 01 2021   grade_1 10 10 6 0   2     0   1   18 11 *                     29.0 10 10 6 0   2     0   1   18 11                 29
1672673 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston - George H Conley   Regular School No Elementary PK 06 2021   grade_1 8 4 8 0   0     1   0   10 11 *                     21.0 8 4 8 0   0     1   0   10 11                 21
1672855 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Boston - Mozart   Regular School No Elementary PK 05 2021   grade_1 9 7 3 0   0     0   4   12 11 *                     23.0 9 7 3 0   0     0   4   12 11                 23
1674250 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving - Erving Elementary   Regular School No Elementary PK 06 2021   grade_1 15 0 2 0   0     0   0   6 11 *                     17.0 15 0 2 0   0     0   0   6 11                 17
1674449 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   grade_1 22 1 4 1   1     0   0   18 11 *                     29.0 22 1 4 1   1     0   0   18 11                 29
1675801 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Lynn - Sewell-Anderson   Regular School No Elementary KG 05 2021   grade_1 4 4 9 0   2     0   2   10 11 *                     21.0 4 4 9 0   2     0   2   10 11                 21
1676356 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant - Johnson   Regular School No Elementary PK 06 2021   grade_1 16 0 3 0   0     0   1   9 11 *                     20.0 16 0 3 0   0     0   1   9 11                 20
1676843 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 North Attleborough - Falls   Regular School No Elementary KG 05 2021   grade_1 23 2 1 0   0     0   0   15 11 *                     26.0 23 2 1 0   0     0   0   15 11                 26
1677051 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans - Orleans Elementary   Regular School No Elementary KG 05 2021   grade_1 19 2 1 0   1     0   1   13 11 *                     24.0 19 2 1 0   1     0   1   13 11                 24
1677862 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury - Shutesbury Elementary   Regular School No Elementary PK 06 2021   grade_1 19 0 0 0   0     0   0   8 11 *                     19.0 19 0 0 0   0     0   0   8 11                 19
1679343 MA Middlesex   school 2513200 347   Woburn 251320002187 3470025 Woburn - Linscott-Rumford   Regular School No Elementary KG 05 2021   grade_1 18 1 0 0   5     1   0   14 11 *                     25.0 18 1 0 0   5     1   0   14 11                 25
1679544 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Worcester - Midland Street   Regular School No Elementary KG 06 2021   grade_1 9 5 11 0   4     0   4   22 11 *                     33.0 9 5 11 0   4     0   4   22 11                 33
1679967 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_1 16 0 0 0   2     0   2   9 11 *                     20.0 16 0 0 0   2     0   2   9 11                 20
1680938 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell - Swift River   Regular School No Elementary PK 06 2021   grade_1 13 0 1 0   0     0   3   6 11 *                     17.0 13 0 1 0   0     0   3   6 11                 17
2040316 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2019   grade_1 5 4 14 0   9     0   3   24 11                       35.0 5 4 14 0   9     0   3   24 11                 35
2040610 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2019   grade_1 12 4 4 0   0     0   3   12 11                       23.0 12 4 4 0   0     0   3   12 11                 23
2040682 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2019   grade_1 1 14 6 0   0     0   0   10 11                       21.0 1 14 6 0   0     0   0   10 11                 21
2040904 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_1 8 4 4 0   1     0   2   8 11                       19.0 8 4 4 0   1     0   2   8 11                 19
2046533 MA Middlesex   school 2512000 308   Waltham 251200002863 3080001 Waltham Public Schools Dual Language Program   Regular School No Elementary KG 02 2019   grade_1 8 1 29 0   0     0   0   27 11                       38.0 8 1 29 0   0     0   0   27 11                 38
2229252 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_1 25 0 1 0   1     0   1   17 11                       28.0 25 0 1 0   1     0   1   17 11                 28
2229400 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_1 11 6 6 0   1     0   0   13 11                       24.0 11 6 6 0   1     0   0   13 11                 24
2229673 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Boston: Joseph P Tynan   Regular School No Elementary PK 05 2018   grade_1 5 9 9 0   3     0   4   19 11                       30.0 5 9 9 0   3     0   4   19 11                 30
2229791 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_1 19 5 0 0   0     0   0   13 11                       24.0 19 5 0 0   0     0   0   13 11                 24
2229866 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston: Roger Clap   Regular School No Elementary PK 05 2018   grade_1 3 9 5 0   0     0   0   6 11                       17.0 3 9 5 0   0     0   0   6 11                 17
2233930 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_1 19 0 0 0   0     0   0   8 11                       19.0 19 0 0 0   0     0   0   8 11                 19
2235554 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Saugus: Douglas Waybright   Regular School No Elementary PK 05 2018   grade_1 21 0 1 0   2     0   0   13 11                       24.0 21 0 1 0   2     0   0   13 11                 24
2236556 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury: Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_1 16 2 9 0   0     0   2   18 11                       29.0 16 2 9 0   0     0   2   18 11                 29
2237715 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester: Lincoln Street   Regular School No Elementary KG 06 2018   grade_1 0 7 17 1   1     0   0   15 11                       26.0 0 7 17 1   1     0   0   15 11                 26
2238765 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen: New Hingham Regional Elementary   Regular School No Elementary PK 06 2018   grade_1 21 0 0 1   0     0   0   11 11                       22.0 21 0 0 1   0     0   0   11 11                 22
2048233 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2019   grade_1 229 6 3 0   3     1   7   139 110                       249.0 229 6 3 0   3     1   7   139 110                 249
2232342 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston: Placentino Elementary   Regular School No Elementary PK 02 2018   grade_1 183 2 11 0   20     0   11   117 110                       227.0 183 2 11 0   20     0   11   117 110                 227
935646 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No 1 KG 01 2016   grade_1 183 2 7 1   37     1   8   128 111                       239 183 2 7 1   37     1   8   128 111                 239
936457 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2016   grade_1 195 8 3 1   12     0   11   119 111                       230 195 8 3 1   12     0   11   119 111                 230
2228993 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland: Henry E Warren Elementary   Regular School No Elementary KG 02 2018   grade_1 146 1 28 0   35     0   11   110 111                       221.0 146 1 28 0   35     0   11   110 111                 221
932734 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2016   grade_1 160 5 9 4   29     0   5   99 113                       212 160 5 9 4   29     0   5   99 113                 212
2238731 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham: Mitchell Elementary School   Regular School No Elementary PK 03 2018   grade_1 207 18 0 0   6     0   7   125 113                       238.0 207 18 0 0   6     0   7   125 113                 238
1679798 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_1 8 101 72 1   5     0   8   81 114 *                     195.0 8 101 72 1   5     0   8   81 114                 195
744112 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No 1 PK 03 2015   grade_1 205 10 11 0   2     0   7   120 115                       235 205 10 11 0   2     0   7   120 115                 235
2042961 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2019   grade_1 144 2 6 0   62     0   12   111 115                       226.0 144 2 6 0   62     0   12   111 115                 226
739612 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2015   grade_1 211 4 14 0   12     0   8   133 116                       249 211 4 14 0   12     0   8   133 116                 249

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