Data source: Big Local News · About: Big Local

896 rows where grade = "grade_5", state = "MA" and year = 2018 sorted by female

View and edit SQL

year

  • 2018 · 896

grade

  • grade_5 · 896
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
2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2231642 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2232020 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2233067 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_5 * * * *   *     *   *   5 *                       5.0                         5                   5
2237226 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2229488 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston: Dante Alighieri Montessori School   Regular School No Elementary PK 05 2018   grade_5 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231627 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River: Stone PK-12 School   Regular School No Other 02 12 2018   grade_5 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2232240 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   grade_5 3 0 2 0   0     0   1   5 1                       6.0 3 0 2 0   0     0   1   5 1                 6
2232698 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_5 1 0 8 0   0     0   1   9 1                       10.0 1 0 8 0   0     0   1   9 1                 10
2233173 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Lynn: Early Childhood Center   Regular School No Elementary PK 05 2018   grade_5 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2237289 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Weymouth: Maria Weston Chapman Middle School   Regular School No Middle 05 08 2018   grade_5 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2229795 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_5 8 4 4 0   0     0   1   7 10                       17.0 8 4 4 0   0     0   1   7 10                 17
2230012 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_5 1 11 11 0   0     0   0   13 10                       23.0 1 11 11 0   0     0   0   13 10                 23
2230034 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_5 5 5 13 0   0     0   2   15 10                       25.0 5 5 13 0   0     0   2   15 10                 25
2236814 MA Middlesex   school 2512180 314   Watertown 251218001998 3140015 Watertown: Cunniff   Regular School No Elementary PK 05 2018   grade_5 33 2 2 0   2     0   0   29 10                       39.0 33 2 2 0   2     0   0   29 10                 39
2239010 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill-Montague: Gill Elementary   Regular School No Elementary KG 06 2018   grade_5 19 0 0 0   0     0   2   11 10                       21.0 19 0 0 0   0     0   2   11 10                 21
2234656 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Norton: Henri A. Yelle   Regular School No Elementary 04 05 2018   grade_5 175 3 7 0   4     0   11   99 101                       200.0 175 3 7 0   4     0   11   99 101                 200
2236281 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham: Stoneham Central Middle School   Regular School No Middle 05 08 2018   grade_5 143 2 17 0   9     0   3   71 103                       174.0 143 2 17 0   9     0   3   71 103                 174
2228998 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland: David Mindess   Regular School No Elementary 03 05 2018   grade_5 143 7 26 0   32     0   8   109 107                       216.0 143 7 26 0   32     0   8   109 107                 216
2232338 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Holliston: Miller School   Regular School No Elementary 03 05 2018   grade_5 201 0 15 1   14     0   7   130 108                       238.0 201 0 15 1   14     0   7   130 108                 238
2229787 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston: Nathan Hale   Regular School No Elementary PK 05 2018   grade_5 0 9 12 0   1     0   2   13 11                       24.0 0 9 12 0   1     0   2   13 11                 24
2229974 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Boston: Winship Elementary   Regular School No Elementary PK 05 2018   grade_5 7 5 11 0   2     0   0   14 11                       25.0 7 5 11 0   2     0   0   14 11                 25
2231101 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_5 20 0 1 0   0     0   0   10 11                       21.0 20 0 1 0   0     0   0   10 11                 21
2231451 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Everett: Webster School   Regular School No Elementary PK 05 2018   grade_5 12 5 17 0   0     0   3   26 11                       37.0 12 5 17 0   0     0   3   26 11                 37
2231996 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Gloucester: Veterans Memorial   Regular School No Elementary KG 05 2018   grade_5 19 0 5 0   1     0   0   14 11                       25.0 19 0 5 0   1     0   0   14 11                 25
2233511 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Marshfield: Eames Way School   Regular School No Elementary KG 05 2018   grade_5 36 0 0 0   0     0   1   26 11                       37.0 36 0 0 0   0     0   1   26 11                 37
2234877 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham: Pelham Elementary   Regular School No Elementary KG 06 2018   grade_5 15 0 2 0   0     0   0   6 11                       17.0 15 0 2 0   0     0   0   6 11                 17
2235374 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_5 18 1 1 0   0     0   0   9 11                       20.0 18 1 1 0   0     0   0   9 11                 20
2237247 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Westwood: Downey   Regular School No Elementary KG 05 2018   grade_5 28 0 0 0   5     0   0   22 11                       33.0 28 0 0 0   5     0   0   22 11                 33
2237350 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately: Whately Elementary   Regular School No Elementary PK 06 2018   grade_5 18 0 2 0   0     0   0   9 11                       20.0 18 0 2 0   0     0   0   9 11                 20
2238287 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_5 14 1 4 0   0     0   2   10 11                       21.0 14 1 4 0   0     0   2   10 11                 21
2239318 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell: Swift River   Regular School No Elementary PK 06 2018   grade_5 18 0 1 0   1     0   1   10 11                       21.0 18 0 1 0   1     0   1   10 11                 21
2239412 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Pioneer Valley: Bernardston Elementary   Regular School No Elementary PK 06 2018   grade_5 20 0 0 0   0     0   2   11 11                       22.0 20 0 0 0   0     0   2   11 11                 22
2239645 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_5 27 0 3 0   0     0   2   21 11                       32.0 27 0 3 0   0     0   2   21 11                 32
2236500 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Taunton: Joseph H Martin   Regular School No Middle 05 07 2018   grade_5 148 35 27 1   2     1   9   111 112                       223.0 148 35 27 1   2     1   9   111 112                 223
2238388 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_5 3 135 92 1   4     0   1   124 112                       236.0 3 135 92 1   4     0   1   124 112                 236
2232149 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover: Hanover Middle   Regular School No Middle 05 08 2018   grade_5 193 5 8 0   5     0   3   98 116                       214.0 193 5 8 0   5     0   3   98 116                 214
2232502 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 Hudson: David J. Quinn Middle School   Regular School No Middle 05 07 2018   grade_5 178 5 28 0   5     0   14   112 118                       230.0 178 5 28 0   5     0   14   112 118                 230
2229404 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_5 7 11 13 0   0     0   0   19 12                       31.0 7 11 13 0   0     0   0   19 12                 31
2229886 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Boston: Samuel W Mason   Regular School No Elementary PK 05 2018   grade_5 3 18 11 0   0     1   1   22 12                       34.0 3 18 11 0   0     1   1   22 12                 34
2231430 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_5 17 0 0 0   0     0   3   8 12                       20.0 17 0 0 0   0     0   3   8 12                 20
2234167 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 New Bedford: Thomas R Rodman   Regular School No Elementary KG 05 2018   grade_5 15 0 8 0   1     0   2   14 12                       26.0 15 0 8 0   1     0   2   14 12                 26
2234861 MA Essex   school 2509360 229   Peabody 250936001505 2290045 Peabody: West Memorial   Regular School No Elementary PK 05 2018   grade_5 33 0 4 0   1     0   0   26 12                       38.0 33 0 4 0   1     0   0   26 12                 38
2237575 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_5 11 4 6 0   1     0   0   10 12                       22.0 11 4 6 0   1     0   0   10 12                 22
2239106 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont: Hawlemont Regional   Regular School No Elementary PK 06 2018   grade_5 19 1 1 0   0     0   1   10 12                       22.0 19 1 1 0   0     0   1   10 12                 22
2239427 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Pioneer Valley: Northfield Elementary   Regular School No Elementary PK 06 2018   grade_5 24 0 0 0   0     0   1   13 12                       25.0 24 0 0 0   0     0   1   13 12                 25
2239565 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield: East Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_5 19 0 1 0   0     0   1   9 12                       21.0 19 0 1 0   0     0   1   9 12                 21
2236540 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 Tewksbury: John F. Ryan   Regular School No Middle 05 06 2018   grade_5 211 12 7 0   14     0   3   126 121                       247.0 211 12 7 0   14     0   3   126 121                 247
2238938 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 Freetown-Lakeville: George R Austin Intermediate School   Regular School No Elementary 04 05 2018   grade_5 209 6 2 1   4     0   6   107 121                       228.0 209 6 2 1   4     0   6   107 121                 228
2233990 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick: Wilson Middle   Regular School No Middle 05 08 2018   grade_5 189 10 14 0   16     1   21   128 123                       251.0 189 10 14 0   16     1   21   128 123                 251
2236514 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton: Benjamin Friedman Middle   Regular School No Middle 05 07 2018   grade_5 201 27 24 0   2     0   10   139 125                       264.0 201 27 24 0   2     0   10   139 125                 264
2236646 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Wakefield: Galvin Middle School   Regular School No Middle 05 08 2018   grade_5 213 6 24 0   7     1   11   137 125                       262.0 213 6 24 0   7     1   11   137 125                 262
2233427 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Mansfield: Jordan/Jackson Elementary   Regular School No Elementary 03 05 2018   grade_5 224 7 18 1   14     0   5   143 126                       269.0 224 7 18 1   14     0   5   143 126                 269
2229553 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Boston: Ellis Mendell   Regular School No Elementary PK 05 2018   grade_5 12 7 10 0   0     0   1   17 13                       30.0 12 7 10 0   0     0   1   17 13                 30
2229572 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston: George H Conley   Regular School No Elementary PK 05 2018   grade_5 1 13 8 0   0     0   1   10 13                       23.0 1 13 8 0   0     0   1   10 13                 23
2229707 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston: Joseph P Manning   Regular School No Elementary PK 05 2018   grade_5 7 9 9 0   0     0   1   13 13                       26.0 7 9 9 0   0     0   1   13 13                 26
2231266 MA Middlesex   school 2504320 79   Dracut 250432000582 790030 Dracut: Greenmont Avenue   Regular School No Elementary KG 05 2018   grade_5 33 1 4 0   4     0   0   29 13                       42.0 33 1 4 0   4     0   0   29 13                 42
2233934 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_5 23 0 0 0   0     0   0   10 13                       23.0 23 0 0 0   0     0   0   10 13                 23
2236581 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro: Truro Central   Regular School No Elementary PK 05 2018   grade_5 14 1 4 0   0     0   0   6 13                       19.0 14 1 4 0   0     0   0   6 13                 19
2237066 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Westfield: Russell Elementary School   Regular School No Elementary KG 05 2018   grade_5 29 0 1 0   1     0   0   18 13                       31.0 29 0 1 0   1     0   0   18 13                 31
2239451 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin: Hardwick Elementary   Regular School No Elementary KG 06 2018   grade_5 24 1 3 0   0     0   0   15 13                       28.0 24 1 3 0   0     0   0   15 13                 28
2238828 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth: N H Wixon Innovation School   Regular School No Elementary 04 05 2018   grade_5 194 21 30 6   7     0   13   136 135                       271.0 194 21 30 6   7     0   13   136 135                 271
2231683 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth: Morse Pond School   Regular School No Middle 05 06 2018   grade_5 222 13 14 2   10     0   16   140 137                       277.0 222 13 14 2   10     0   16   140 137                 277
2232471 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkinton: Hopkins Elementary School   Regular School No Elementary 04 05 2018   grade_5 212 2 7 0   48     0   9   140 138                       278.0 212 2 7 0   48     0   9   140 138                 278
2231293 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Duxbury: Alden School   Regular School No Elementary 03 05 2018   grade_5 236 0 6 1   4     0   6   114 139                       253.0 236 0 6 1   4     0   6   114 139                 253
2229935 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston: William Ellery Channing   Regular School No Elementary PK 05 2018   grade_5 0 7 15 0   1     0   1   10 14                       24.0 0 7 15 0   1     0   1   10 14                 24
2230767 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Cambridge: Fletcher/Maynard Academy   Regular School No Elementary PK 05 2018   grade_5 10 17 6 1   1     0   2   23 14                       37.0 10 17 6 1   1     0   2   23 14                 37
2233266 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn: Lynn Woods   Regular School No Elementary KG 05 2018   grade_5 18 0 9 0   1     0   2   16 14                       30.0 18 0 9 0   1     0   2   16 14                 30
2234160 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 New Bedford: Renaissance Community School for the Arts   Regular School No Elementary PK 05 2018   grade_5 4 2 17 0   0     0   2   11 14                       25.0 4 2 17 0   0     0   2   11 14                 25
2234182 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 New Bedford: William H Taylor   Regular School No Elementary PK 05 2018   grade_5 20 2 4 0   0     0   2   14 14                       28.0 20 2 4 0   0     0   2   14 14                 28
2237735 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Worcester: Francis J McGrath Elementary   Regular School No Elementary KG 06 2018   grade_5 7 11 8 0   1     0   3   16 14                       30.0 7 11 8 0   1     0   3   16 14                 30
2228811 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   grade_5 237 10 14 0   5     0   5   131 140                       271.0 237 10 14 0   5     0   5   131 140                 271
2229344 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Billerica: Eugene C Vining   Regular School No Elementary KG 05 2018   grade_5 21 1 5 0   2     0   2   16 15                       31.0 21 1 5 0   2     0   2   16 15                 31
2230727 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Cambridge: Kennedy-Longfellow   Regular School No Elementary PK 05 2018   grade_5 7 6 7 0   6     0   4   15 15                       30.0 7 6 7 0   6     0   4   15 15                 30
2230751 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 Cambridge: John M Tobin   Regular School No Elementary PK 05 2018   grade_5 7 12 1 0   3     0   3   11 15                       26.0 7 12 1 0   3     0   3   11 15                 26
2231207 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_5 35 2 8 0   0     0   1   31 15                       46.0 35 2 8 0   0     0   1   31 15                 46
2231908 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   grade_5 35 2 3 1   0     0   0   26 15                       41.0 35 2 3 1   0     0   0   26 15                 41
2232569 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   grade_5 30 1 0 0   0     0   0   16 15                       31.0 30 1 0 0   0     0   0   16 15                 31
2234068 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 New Bedford: Elwyn G Campbell   Regular School No Elementary PK 05 2018   grade_5 11 1 15 0   0     0   1   13 15                       28.0 11 1 15 0   0     0   1   13 15                 28
2235022 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Plymouth: Hedge   Regular School No Elementary 01 05 2018   grade_5 33 1 2 0   2     0   3   26 15                       41.0 33 1 2 0   2     0   3   26 15                 41
2235089 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton: Dennett Elementary   Regular School No Elementary KG 06 2018   grade_5 26 0 2 0   0     0   0   13 15                       28.0 26 0 2 0   0     0   0   13 15                 28
2235165 MA Norfolk   school 2509870 243   Quincy 250987001582 2430090 Quincy: Snug Harbor Community School   Regular School No Elementary PK 05 2018   grade_5 18 4 5 0   18     0   0   30 15                       45.0 18 4 5 0   18     0   0   30 15                 45
2235977 MA Hampden   school 2511130 281   Springfield 251113001807 2810050 Springfield: Hiram L Dorman   Regular School No Elementary KG 05 2018   grade_5 5 13 25 0   0     0   0   28 15                       43.0 5 13 25 0   0     0   0   28 15                 43
2236560 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury: Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_5 27 2 8 1   0     0   2   25 15                       40.0 27 2 8 1   0     0   2   25 15                 40
2237024 MA Hampden   school 2512630 325   Westfield 251263002064 3250015 Westfield: Franklin Ave   Regular School No Elementary KG 05 2018   grade_5 18 0 11 0   2     0   1   17 15                       32.0 18 0 11 0   2     0   1   17 15                 32
2237254 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Westwood: Paul Hanlon   Regular School No Elementary KG 05 2018   grade_5 21 0 0 0   4     0   1   11 15                       26.0 21 0 0 0   4     0   1   11 15                 26
2237711 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Worcester: Lake View   Regular School No Elementary KG 06 2018   grade_5 17 7 6 0   1     0   2   18 15                       33.0 17 7 6 0   1     0   2   18 15                 33
2237743 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Worcester: Midland Street   Regular School No Elementary KG 06 2018   grade_5 17 3 3 0   3     0   0   11 15                       26.0 17 3 3 0   3     0   0   11 15                 26
2238743 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham: Williams Intermediate School   Regular School No Middle 04 06 2018   grade_5 258 15 0 1   3     2   21   148 152                       300.0 258 15 0 1   3     2   21   148 152                 300
2231402 MA Bristol   school 2504620 88   Easton 250462000983 880025 Easton: Richardson Olmsted School   Regular School No Elementary 03 05 2018   grade_5 248 19 10 0   6     0   11   141 153                       294.0 248 19 10 0   6     0   11   141 153                 294
2233826 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford: Woodland   Regular School No Elementary 03 05 2018   grade_5 184 7 102 14   5     0   14   169 157                       326.0 184 7 102 14   5     0   14   169 157                 326
2229256 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_5 30 0 1 0   0     0   1   16 16                       32.0 30 0 1 0   0     0   1   16 16                 32
2229916 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston: Thomas J Kenny   Regular School No Elementary PK 05 2018   grade_5 4 17 16 0   3     0   1   25 16                       41.0 4 17 16 0   3     0   1   25 16                 41
2230392 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield: Brimfield Elementary   Regular School No Elementary PK 06 2018   grade_5 31 1 0 0   1     0   0   17 16                       33.0 31 1 0 0   1     0   0   17 16                 33
2230703 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Cambridge: Haggerty   Regular School No Elementary PK 05 2018   grade_5 10 7 3 0   3     0   6   13 16                       29.0 10 7 3 0   3     0   6   13 16                 29
2231419 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_5 24 1 4 2   1     0   2   18 16                       34.0 24 1 4 2   1     0   2   18 16                 34
2231980 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester: East Gloucester Elementary   Regular School No Elementary KG 05 2018   grade_5 33 0 2 0   0     0   0   19 16                       35.0 33 0 2 0   0     0   0   19 16                 35
2232110 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_5 32 0 5 0   0     0   1   22 16                       38.0 32 0 5 0   0     0   1   22 16                 38
2234619 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 North Reading: E Ethel Little School   Regular School No Elementary PK 05 2018   grade_5 32 0 2 0   1     0   0   19 16                       35.0 32 0 2 0   1     0   0   19 16                 35
2235558 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Saugus: Douglas Waybright   Regular School No Elementary PK 05 2018   grade_5 30 2 4 1   2     0   1   24 16                       40.0 30 2 4 1   2     0   1   24 16                 40

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