enrollments

Data source: Big Local News · About: Big Local

976 rows where grade = "grade_2", state = "MA" and year = 2018 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 976 ✖

grade ✖

  • grade_2 · 976 ✖
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
2230205 2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2231639 2231639 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_2 * * * *   *     *   *   * *                       0.0                                             0
2232017 2232017 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2237223 2237223 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2232130 2232130 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_2 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2232695 2232695 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_2 1 0 5 0   0     0   0   5 1                       6.0 1 0 5 0   0     0   0   5 1                 6
2233269 2233269 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn: William R Fallon   Regular School No Elementary KG 06 2018   grade_2 1 1 8 0   0     0   1   10 1                       11.0 1 1 8 0   0     0   1   10 1                 11
2233263 2233263 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn: Lynn Woods   Regular School No Elementary KG 05 2018   grade_2 14 1 5 1   0     0   1   12 10                       22.0 14 1 5 1   0     0   1   12 10                 22
2234874 2234874 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham: Pelham Elementary   Regular School No Elementary KG 06 2018   grade_2 13 0 4 0   0     0   1   8 10                       18.0 13 0 4 0   0     0   1   8 10                 18
2236950 2236950 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet: Wellfleet Elementary   Regular School No Elementary PK 05 2018   grade_2 12 1 0 0   0     0   3   6 10                       16.0 12 1 0 0   0     0   3   6 10                 16
2238098 2238098 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_2 0 15 5 0   0     0   0   10 10                       20.0 0 15 5 0   0     0   0   10 10                 20
2238284 2238284 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_2 13 0 2 1   0     0   1   7 10                       17.0 13 0 2 1   0     0   1   7 10                 17
2238638 2238638 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Athol-Royalston: Royalston Community School   Regular School No Elementary KG 06 2018   grade_2 22 0 0 0   0     0   0   12 10                       22.0 22 0 0 0   0     0   0   12 10                 22
2239007 2239007 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill-Montague: Gill Elementary   Regular School No Elementary KG 06 2018   grade_2 19 0 0 0   0     0   2   11 10                       21.0 19 0 0 0   0     0   2   11 10                 21
2239315 2239315 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell: Swift River   Regular School No Elementary PK 06 2018   grade_2 15 0 1 0   1     0   1   8 10                       18.0 15 0 1 0   1     0   1   8 10                 18
2233604 2233604 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Medfield: Ralph Wheelock School   Regular School No Elementary 02 03 2018   grade_2 170 5 5 0   9     0   6   95 100                       195.0 170 5 5 0   9     0   6   95 100                 195
2231927 2231927 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   grade_2 116 9 38 0   4     0   15   81 101                       182.0 116 9 38 0   4     0   15   81 101                 182
2235690 2235690 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury: Floral Street School   Regular School No Elementary 01 04 2018   grade_2 73 7 17 0   108     0   7   110 102                       212.0 73 7 17 0   108     0   7   110 102                 212
2229139 2229139 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford: Lt Elezer Davis   Regular School No Elementary KG 02 2018   grade_2 123 12 14 0   36     0   16   98 103                       201.0 123 12 14 0   36     0   16   98 103                 201
2238732 2238732 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham: Mitchell Elementary School   Regular School No Elementary PK 03 2018   grade_2 190 9 0 0   3     0   11   108 105                       213.0 190 9 0 0   3     0   11   108 105                 213
2231298 2231298 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Duxbury: Chandler Elementary   Regular School No Elementary PK 02 2018   grade_2 188 2 8 0   2     0   6   100 106                       206.0 188 2 8 0   2     0   6   100 106                 206
2233423 2233423 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield: Everett W Robinson   Regular School No Elementary KG 02 2018   grade_2 184 5 19 1   29     0   17   147 108                       255.0 184 5 19 1   29     0   17   147 108                 255
2235515 2235515 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich: Forestdale School   Regular School No Elementary PK 02 2018   grade_2 195 3 9 0   6     1   0   106 108                       214.0 195 3 9 0   6     1   0   106 108                 214
2229401 2229401 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_2 7 2 7 0   0     0   3   8 11                       19.0 7 2 7 0   0     0   3   8 11                 19
2229674 2229674 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Boston: Joseph P Tynan   Regular School No Elementary PK 05 2018   grade_2 8 13 7 0   2     0   1   20 11                       31.0 8 13 7 0   2     0   1   20 11                 31
2229704 2229704 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston: Joseph P Manning   Regular School No Elementary PK 05 2018   grade_2 10 5 7 0   1     0   1   13 11                       24.0 10 5 7 0   1     0   1   13 11                 24
2229784 2229784 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston: Nathan Hale   Regular School No Elementary PK 05 2018   grade_2 0 16 3 0   1     0   1   10 11                       21.0 0 16 3 0   1     0   1   10 11                 21
2229971 2229971 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Boston: Winship Elementary   Regular School No Elementary PK 05 2018   grade_2 10 4 15 0   2     0   1   21 11                       32.0 10 4 15 0   2     0   1   21 11                 32
2231098 2231098 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_2 19 0 0 0   0     0   1   9 11                       20.0 19 0 0 0   0     0   1   9 11                 20
2233931 2233931 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_2 19 0 0 0   0     0   0   8 11                       19.0 19 0 0 0   0     0   0   8 11                 19
2234164 2234164 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 New Bedford: Thomas R Rodman   Regular School No Elementary KG 05 2018   grade_2 13 0 8 0   0     0   0   10 11                       21.0 13 0 8 0   0     0   0   10 11                 21
2234404 2234404 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 North Adams: Brayton   Regular School No Elementary PK 06 2018   grade_2 19 1 1 0   0     0   1   11 11                       22.0 19 1 1 0   0     0   1   11 11                 22
2239226 2239226 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Mohawk Trail: Colrain Central   Regular School No Elementary PK 06 2018   grade_2 19 1 0 0   0     0   0   9 11                       20.0 19 1 0 0   0     0   0   9 11                 20
2239336 2239336 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 North Middlesex: Ashby Elementary   Regular School No Elementary KG 04 2018   grade_2 33 0 1 0   0     0   0   23 11                       34.0 33 0 1 0   0     0   0   23 11                 34
2239409 2239409 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Pioneer Valley: Bernardston Elementary   Regular School No Elementary PK 06 2018   grade_2 20 0 0 0   0     0   1   10 11                       21.0 20 0 0 0   0     0   1   10 11                 21
2239562 2239562 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield: East Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_2 22 1 2 0   0     0   1   15 11                       26.0 22 1 2 0   0     0   1   15 11                 26
2232467 2232467 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Hopkinton: Elmwood   Regular School No Elementary 02 03 2018   grade_2 171 1 6 1   46     0   13   119 119                       238.0 171 1 6 1   46     0   13   119 119                 238
2230389 2230389 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield: Brimfield Elementary   Regular School No Elementary PK 06 2018   grade_2 25 1 0 0   1     0   0   15 12                       27.0 25 1 0 0   1     0   0   15 12                 27
2230971 2230971 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee: Litwin   Regular School No Elementary KG 05 2018   grade_2 19 1 5 0   0     0   1   14 12                       26.0 19 1 5 0   0     0   1   14 12                 26
2232178 2232178 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_2 22 0 2 0   1     0   0   13 12                       25.0 22 0 2 0   1     0   0   13 12                 25
2238207 2238207 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 2018   grade_2 20 0 0 0   0     0   1   9 12                       21.0 20 0 0 0   0     0   1   9 12                 21
2239103 2239103 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont: Hawlemont Regional   Regular School No Elementary PK 06 2018   grade_2 19 0 1 0   0     0   0   8 12                       20.0 19 0 1 0   0     0   0   8 12                 20
2239424 2239424 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Pioneer Valley: Northfield Elementary   Regular School No Elementary PK 06 2018   grade_2 24 0 0 0   0     0   0   12 12                       24.0 24 0 0 0   0     0   0   12 12                 24
2239448 2239448 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin: Hardwick Elementary   Regular School No Elementary KG 06 2018   grade_2 25 0 5 0   0     0   1   19 12                       31.0 25 0 5 0   0     0   1   19 12                 31
2229253 2229253 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_2 27 0 2 0   0     0   2   18 13                       31.0 27 0 2 0   0     0   2   18 13                 31
2232566 2232566 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   grade_2 18 1 0 0   0     0   0   6 13                       19.0 18 1 0 0   0     0   0   6 13                 19
2234442 2234442 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 Northampton: R. K. Finn Ryan Road   Regular School No Elementary KG 05 2018   grade_2 22 1 2 0   1     0   2   15 13                       28.0 22 1 2 0   1     0   2   15 13                 28
2236557 2236557 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury: Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_2 15 1 11 0   0     0   4   18 13                       31.0 15 1 11 0   0     0   4   18 13                 31
2237237 2237237 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Westwood: Deerfield School   Regular School No Elementary KG 05 2018   grade_2 27 0 2 0   2     0   2   20 13                       33.0 27 0 2 0   2     0   2   20 13                 33
2239132 2239132 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Manchester Essex Regional: Essex Elementary   Regular School No Elementary KG 05 2018   grade_2 31 0 0 0   0     0   1   19 13                       32.0 31 0 0 0   0     0   1   19 13                 32
2229731 2229731 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Boston: Manassah E Bradley   Regular School No Elementary PK 05 2018   grade_2 16 1 22 0   2     0   1   28 14                       42.0 16 1 22 0   2     0   1   28 14                 42
2231349 2231349 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton: Neil A Pepin   Regular School No Elementary KG 04 2018   grade_2 33 0 5 0   0     0   3   27 14                       41.0 33 0 5 0   0     0   3   27 14                 41
2232107 2232107 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_2 24 0 5 0   0     1   2   18 14                       32.0 24 0 5 0   0     1   2   18 14                 32
2232363 2232363 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke: Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2018   grade_2 11 1 17 0   0     0   2   17 14                       31.0 11 1 17 0   0     0   2   17 14                 31
2234600 2234600 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield: North Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_2 34 0 0 0   0     0   0   20 14                       34.0 34 0 0 0   0     0   0   20 14                 34
2234858 2234858 MA Essex   school 2509360 229   Peabody 250936001505 2290045 Peabody: West Memorial   Regular School No Elementary PK 05 2018   grade_2 38 1 1 0   0     0   0   26 14                       40.0 38 1 1 0   0     0   0   26 14                 40
2237572 2237572 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_2 8 5 9 0   1     0   3   12 14                       26.0 8 5 9 0   1     0   3   12 14                 26
2238711 2238711 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Blackstone-Millville: Millville Elementary   Regular School No Elementary PK 05 2018   grade_2 35 0 4 0   0     0   1   26 14                       40.0 35 0 4 0   0     0   1   26 14                 40
2240012 2240012 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District: Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_2 15 8 6 0   0     0   1   16 14                       30.0 15 8 6 0   0     0   1   16 14                 30
2229341 2229341 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Billerica: Eugene C Vining   Regular School No Elementary KG 05 2018   grade_2 26 3 3 0   1     0   1   19 15                       34.0 26 3 3 0   1     0   1   19 15                 34
2230358 2230358 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Braintree: Donald Ross   Regular School No Elementary KG 05 2018   grade_2 31 3 2 0   6     0   0   27 15                       42.0 31 3 2 0   6     0   0   27 15                 42
2231024 2231024 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_2 19 0 1 0   0     0   1   6 15                       21.0 19 0 1 0   0     0   1   6 15                 21
2231336 2231336 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Easthampton: Center School   Regular School No Elementary KG 04 2018   grade_2 31 0 7 0   0     0   2   25 15                       40.0 31 0 7 0   0     0   2   25 15                 40
2231905 2231905 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   grade_2 33 0 0 0   0     0   0   18 15                       33.0 33 0 0 0   0     0   0   18 15                 33
2232193 2232193 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Haverhill: Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2018   grade_2 25 0 10 0   0     0   0   20 15                       35.0 25 0 10 0   0     0   0   20 15                 35
2234473 2234473 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover: Kittredge   Regular School No Elementary KG 05 2018   grade_2 36 0 2 0   2     0   1   26 15                       41.0 36 0 2 0   2     0   1   26 15                 41
2234938 2234938 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Pittsfield: Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2018   grade_2 21 0 3 0   0     0   4   13 15                       28.0 21 0 3 0   0     0   4   13 15                 28
2234961 2234961 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Pittsfield: Stearns   Regular School No Elementary KG 05 2018   grade_2 34 1 4 0   0     0   3   27 15                       42.0 34 1 4 0   0     0   3   27 15                 42
2235019 2235019 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Plymouth: Hedge   Regular School No Elementary 01 05 2018   grade_2 21 0 1 0   2     0   4   13 15                       28.0 21 0 1 0   2     0   4   13 15                 28
2235283 2235283 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Reading: Wood End Elementary School   Regular School No Elementary KG 05 2018   grade_2 46 1 0 0   1     0   0   33 15                       48.0 46 1 0 0   1     0   0   33 15                 48
2235820 2235820 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Somerville: Winter Hill Community   Regular School No Elementary PK 08 2018   grade_2 11 6 19 0   1     0   3   24 15                       40.0 11 6 19 0   1     0   3   24 15                 40
2236293 2236293 MA Norfolk   school 2511250 285   Stoughton 251125001858 2850010 Stoughton: Helen Hansen Elementary   Regular School No Elementary KG 05 2018   grade_2 22 2 4 0   2     1   2   18 15                       33.0 22 2 4 0   2     1   2   18 15                 33
2236659 2236659 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales: Wales Elementary   Regular School No Elementary PK 06 2018   grade_2 24 1 0 1   0     0   0   11 15                       26.0 24 1 0 1   0     0   0   11 15                 26
2237740 2237740 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Worcester: Midland Street   Regular School No Elementary KG 06 2018   grade_2 19 2 4 0   3     0   4   17 15                       32.0 19 2 4 0   3     0   4   17 15                 32
2240007 2240007 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter Public School (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School (District): Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 03 2018   grade_2 30 3 7 0   0     0   0   25 15                       40.0 30 3 7 0   0     0   0   25 15                 40
2229792 2229792 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_2 15 10 4 0   1     0   0   14 16                       30.0 15 10 4 0   1     0   0   14 16                 30
2229867 2229867 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston: Roger Clap   Regular School No Elementary PK 05 2018   grade_2 7 12 10 0   2     0   2   17 16                       33.0 7 12 10 0   2     0   2   17 16                 33
2231204 2231204 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_2 26 3 3 0   1     0   1   18 16                       34.0 26 3 3 0   1     0   1   18 16                 34
2231329 2231329 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham: Eastham Elementary   Regular School No Elementary PK 05 2018   grade_2 22 2 1 0   1     0   0   10 16                       26.0 22 2 1 0   1     0   0   10 16                 26
2231891 2231891 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin: Oak Street Elementary   Regular School No Elementary KG 05 2018   grade_2 39 0 1 0   3     0   1   28 16                       44.0 39 0 1 0   3     0   1   28 16                 44
2231986 2231986 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Gloucester: Plum Cove School   Regular School No Elementary KG 05 2018   grade_2 30 1 2 0   0     0   1   18 16                       34.0 30 1 2 0   0     0   1   18 16                 34
2233275 2233275 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Lynn: Sewell-Anderson   Regular School No Elementary KG 05 2018   grade_2 14 2 27 0   3     0   3   33 16                       49.0 14 2 27 0   3     0   3   33 16                 49
2233508 2233508 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Marshfield: Eames Way School   Regular School No Elementary KG 05 2018   grade_2 37 0 0 0   0     0   2   23 16                       39.0 37 0 0 0   0     0   2   23 16                 39
2234057 2234057 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 New Bedford: Elizabeth Carter Brooks   Regular School No Elementary PK 05 2018   grade_2 19 4 10 1   0     0   5   23 16                       39.0 19 4 10 1   0     0   5   23 16                 39
2234065 2234065 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 New Bedford: Elwyn G Campbell   Regular School No Elementary PK 05 2018   grade_2 19 2 11 1   2     0   2   21 16                       37.0 19 2 11 1   2     0   2   21 16                 37
2235154 2235154 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Quincy: Francis W Parker   Regular School No Elementary KG 05 2018   grade_2 9 1 3 0   32     0   3   32 16                       48.0 9 1 3 0   32     0   3   32 16                 48
2235230 2235230 MA Norfolk   school 2509930 244   Randolph 250993001590 2440020 Randolph: Elizabeth G Lyons Elementary   Regular School No Elementary KG 05 2018   grade_2 7 24 2 1   4     0   4   26 16                       42.0 7 24 2 1   4     0   4   26 16                 42
2235539 2235539 MA Essex   school 2510500 262   Saugus 251050001682 2620050 Saugus: Oaklandvale   Regular School No Elementary KG 05 2018   grade_2 20 4 9 0   2     0   4   23 16                       39.0 20 4 9 0   2     0   4   23 16                 39
2236912 2236912 MA Norfolk   school 2512270 317   Wellesley 251227002022 3170025 Wellesley: Hunnewell   Regular School No Elementary KG 05 2018   grade_2 30 3 2 0   3     0   2   24 16                       40.0 30 3 2 0   3     0   2   24 16                 40
2237244 2237244 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Westwood: Downey   Regular School No Elementary KG 05 2018   grade_2 32 0 1 1   7     0   1   26 16                       42.0 32 0 1 1   7     0   1   26 16                 42
2237534 2237534 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Woburn: Wyman   Regular School No Elementary KG 05 2018   grade_2 30 0 2 0   1     0   1   18 16                       34.0 30 0 2 0   1     0   1   18 16                 34
2237810 2237810 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Worcester: Thorndyke Road   Regular School No Elementary KG 06 2018   grade_2 23 8 18 0   3     0   2   38 16                       54.0 23 8 18 0   3     0   2   38 16                 54
2239465 2239465 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   grade_2 19 0 2 0   0     0   1   6 16                       22.0 19 0 2 0   0     0   1   6 16                 22
2229531 2229531 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Boston: Edward Everett   Regular School No Elementary PK 05 2018   grade_2 2 20 10 0   7     0   0   22 17                       39.0 2 20 10 0   7     0   0   22 17                 39
2229558 2229558 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston: Franklin D Roosevelt   Regular School No Elementary PK 08 2018   grade_2 12 10 17 0   2     1   1   26 17                       43.0 12 10 17 0   2     1   1   26 17                 43
2229712 2229712 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston: Joyce Kilmer   Regular School No Elementary PK 08 2018   grade_2 22 8 8 0   1     0   5   27 17                       44.0 22 8 8 0   1     0   5   27 17                 44
2229831 2229831 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston: Patrick J Kennedy   Regular School No Elementary PK 05 2018   grade_2 5 0 44 0   1     0   0   33 17                       50.0 5 0 44 0   1     0   0   33 17                 50
2230724 2230724 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Cambridge: Kennedy-Longfellow   Regular School No Elementary PK 05 2018   grade_2 15 7 8 0   11     0   4   28 17                       45.0 15 7 8 0   11     0   4   28 17                 45
2230764 2230764 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Cambridge: Fletcher/Maynard Academy   Regular School No Elementary PK 05 2018   grade_2 8 20 5 0   2     0   2   20 17                       37.0 8 20 5 0   2     0   2   20 17                 37
2231772 2231772 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Foxborough: Charles Taylor Elementary   Regular School No Elementary KG 04 2018   grade_2 36 1 1 3   3     0   1   28 17                       45.0 36 1 1 3   3     0   1   28 17                 45

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