enrollments

Data source: Big Local News · About: Big Local

989 rows where grade = "grade_1", state = "MA" and year = 2018 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 989 ✖

grade ✖

  • grade_1 · 989 ✖
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
2230204 2230204 MA Suffolk   school   35   Boston   350652               2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2231638 2231638 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_1 * * * *   *     *   *   * *                       0.0                                             0
2232016 2232016 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2233065 2233065 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_1 * * * *   *     *   *   1 *                       1.0                         1                   1
2237222 2237222 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2229937 2229937 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_1 1 1 4 0   0     0   1   6 1                       7.0 1 1 4 0   0     0   1   6 1                 7
2229998 2229998 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_1 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2230263 2230263 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_1 3 2 2 0   0     0   0   6 1                       7.0 3 2 2 0   0     0   0   6 1                 7
2232238 2232238 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   grade_1 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2233130 2233130 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell: Lowell Day School on Broadway   Special Education School No Elementary PK 06 2018   grade_1 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2233268 2233268 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn: William R Fallon   Regular School No Elementary KG 06 2018   grade_1 0 0 5 0   0     0   1   5 1                       6.0 0 0 5 0   0     0   1   5 1                 6
2229568 2229568 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston: George H Conley   Regular School No Elementary PK 05 2018   grade_1 7 8 11 0   0     0   0   16 10                       26.0 7 8 11 0   0     0   0   16 10                 26
2229730 2229730 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Boston: Manassah E Bradley   Regular School No Elementary PK 05 2018   grade_1 15 4 16 0   0     0   0   25 10                       35.0 15 4 16 0   0     0   0   25 10                 35
2237346 2237346 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately: Whately Elementary   Regular School No Elementary PK 06 2018   grade_1 20 0 0 0   0     0   0   10 10                       20.0 20 0 0 0   0     0   0   10 10                 20
2238774 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 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 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
2238029 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
2229252 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 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 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 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 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 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 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 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 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 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
2232342 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
2228993 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
2238731 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
2233422 2233422 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield: Everett W Robinson   Regular School No Elementary KG 02 2018   grade_1 183 8 14 0   18     0   13   118 118                       236.0 183 8 14 0   18     0   13   118 118                 236
2229340 2229340 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Billerica: Eugene C Vining   Regular School No Elementary KG 05 2018   grade_1 21 1 5 0   3     0   1   19 12                       31.0 21 1 5 0   3     0   1   19 12                 31
2229368 2229368 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Boston: Baldwin Early Learning Center   Regular School No Elementary PK 01 2018   grade_1 6 6 13 0   7     0   1   21 12                       33.0 6 6 13 0   7     0   1   21 12                 33
2231976 2231976 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester: East Gloucester Elementary   Regular School No Elementary KG 05 2018   grade_1 22 0 1 0   0     0   1   12 12                       24.0 22 0 1 0   0     0   1   12 12                 24
2232177 2232177 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_1 27 0 2 0   0     0   1   17 12                       30.0 27 0 2 0   0     0   1   17 12                 30
2232192 2232192 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Haverhill: Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2018   grade_1 6 0 18 0   0     0   2   14 12                       26.0 6 0 18 0   0     0   2   14 12                 26
2234394 2234394 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams: Greylock   Regular School No Elementary PK 06 2018   grade_1 28 0 4 0   1     0   4   25 12                       37.0 28 0 4 0   1     0   4   25 12                 37
2235085 2235085 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton: Dennett Elementary   Regular School No Elementary KG 06 2018   grade_1 27 0 0 0   0     0   2   17 12                       29.0 27 0 0 0   0     0   2   17 12                 29
2236408 2236408 MA Essex   school 2511430 291   Swampscott 251143001883 2910005 Swampscott: Clarke   Regular School No Elementary KG 04 2018   grade_1 31 1 3 0   0     0   0   23 12                       35.0 31 1 3 0   0     0   0   23 12                 35
2239216 2239216 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Mohawk Trail: Buckland-Shelburne Regional   Regular School No Elementary PK 06 2018   grade_1 30 0 2 0   0     0   1   21 12                       33.0 30 0 2 0   0     0   1   21 12                 33
2239335 2239335 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 North Middlesex: Ashby Elementary   Regular School No Elementary KG 04 2018   grade_1 33 0 2 0   0     0   0   23 12                       35.0 33 0 2 0   0     0   0   23 12                 35
2239641 2239641 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_1 20 0 5 2   0     0   0   15 12                       27.0 20 0 5 2   0     0   0   15 12                 27
2232465 2232465 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Hopkinton: Center   Regular School No Elementary KG 01 2018   grade_1 204 1 4 1   43     0   3   133 123                       256.0 204 1 4 1   43     0   3   133 123                 256
2229530 2229530 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Boston: Edward Everett   Regular School No Elementary PK 05 2018   grade_1 1 11 12 1   9     0   4   25 13                       38.0 1 11 12 1   9     0   4   25 13                 38
2229653 2229653 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston: John D Philbrick   Regular School No Elementary PK 05 2018   grade_1 7 8 5 0   1     0   0   8 13                       21.0 7 8 5 0   1     0   0   8 13                 21
2229703 2229703 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston: Joseph P Manning   Regular School No Elementary PK 05 2018   grade_1 6 0 9 0   2     0   3   7 13                       20.0 6 0 9 0   2     0   3   7 13                 20
2229970 2229970 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Boston: Winship Elementary   Regular School No Elementary PK 05 2018   grade_1 8 4 13 0   4     0   0   16 13                       29.0 8 4 13 0   4     0   0   16 13                 29
2230747 2230747 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 Cambridge: John M Tobin   Regular School No Elementary PK 05 2018   grade_1 14 8 3 0   9     0   6   27 13                       40.0 14 8 3 0   9     0   6   27 13                 40
2230970 2230970 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee: Litwin   Regular School No Elementary KG 05 2018   grade_1 22 0 5 0   0     0   0   14 13                       27.0 22 0 5 0   0     0   0   14 13                 27
2231328 2231328 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham: Eastham Elementary   Regular School No Elementary PK 05 2018   grade_1 24 1 0 0   0     0   1   13 13                       26.0 24 1 0 0   0     0   1   13 13                 26
2232106 2232106 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_1 22 2 3 1   1     1   1   18 13                       31.0 22 2 3 1   1     1   1   18 13                 31
2237355 2237355 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg: Anne T. Dunphy School   Regular School No Elementary PK 06 2018   grade_1 18 1 0 0   0     0   0   6 13                       19.0 18 1 0 0   0     0   0   6 13                 19
2238097 2238097 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_1 0 16 4 0   0     0   0   7 13                       20.0 0 16 4 0   0     0   0   7 13                 20
2239528 2239528 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Southern Berkshire: Undermountain   Regular School No Elementary PK 06 2018   grade_1 29 0 3 0   0     0   1   20 13                       33.0 29 0 3 0   0     0   1   20 13                 33
2229386 2229386 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston: Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2018   grade_1 2 17 17 0   1     0   1   24 14                       38.0 2 17 17 0   1     0   1   24 14                 38
2229783 2229783 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston: Nathan Hale   Regular School No Elementary PK 05 2018   grade_1 4 8 10 0   1     0   1   10 14                       24.0 4 8 10 0   1     0   1   10 14                 24
2231191 2231191 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   grade_1 38 1 4 0   1     0   1   31 14                       45.0 38 1 4 0   1     0   1   31 14                 45
2233045 2233045 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Lowell: Washington   Regular School No Elementary PK 04 2018   grade_1 8 1 7 0   17     0   7   26 14                       40.0 8 1 7 0   17     0   7   26 14                 40
2233262 2233262 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn: Lynn Woods   Regular School No Elementary KG 05 2018   grade_1 14 0 5 0   2     0   5   12 14                       26.0 14 0 5 0   2     0   5   12 14                 26
2234434 2234434 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Northampton: Leeds   Regular School No Elementary PK 05 2018   grade_1 34 0 3 0   0     0   3   26 14                       40.0 34 0 3 0   0     0   3   26 14                 40
2234833 2234833 MA Essex   school 2509360 229   Peabody 250936001821 2290016 Peabody: John E. McCarthy   Regular School No Elementary PK 05 2018   grade_1 27 1 4 0   3     0   1   22 14                       36.0 27 1 4 0   3     0   1   22 14                 36
2236382 2236382 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland: Sunderland Elementary   Regular School No Elementary PK 06 2018   grade_1 24 2 4 0   1     0   3   20 14                       34.0 24 2 4 0   1     0   3   20 14                 34
2237062 2237062 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Westfield: Russell Elementary School   Regular School No Elementary KG 05 2018   grade_1 22 0 2 0   0     0   0   10 14                       24.0 22 0 2 0   0     0   0   10 14                 24
2237250 2237250 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Westwood: Paul Hanlon   Regular School No Elementary KG 05 2018   grade_1 22 1 1 0   6     0   1   17 14                       31.0 22 1 1 0   6     0   1   17 14                 31
2239102 2239102 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont: Hawlemont Regional   Regular School No Elementary PK 06 2018   grade_1 23 0 3 0   0     0   0   12 14                       26.0 23 0 3 0   0     0   0   12 14                 26
2239408 2239408 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Pioneer Valley: Bernardston Elementary   Regular School No Elementary PK 06 2018   grade_1 18 0 0 0   0     0   0   4 14                       18.0 18 0 0 0   0     0   0   4 14                 18
2229382 2229382 MA Suffolk   school 2502790 35   Boston 250279002514 350006 Boston: ELC - West Zone   Regular School No Elementary PK 01 2018   grade_1 10 10 11 1   1     0   1   19 15                       34.0 10 10 11 1   1     0   1   19 15                 34
2229476 2229476 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Boston: Curtis Guild   Regular School No Elementary PK 05 2018   grade_1 7 1 23 0   0     0   1   17 15                       32.0 7 1 23 0   0     0   1   17 15                 32
2229592 2229592 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston: Hugh Roe O'Donnell   Regular School No Elementary PK 05 2018   grade_1 2 0 29 0   2     0   0   18 15                       33.0 2 0 29 0   2     0   0   18 15                 33
2230030 2230030 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_1 14 7 9 0   0     0   0   15 15                       30.0 14 7 9 0   0     0   0   15 15                 30
2230529 2230529 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_1 35 0 1 1   0     0   1   23 15                       38.0 35 0 1 1   0     0   1   23 15                 38
2230731 2230731 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Cambridge: Morse   Regular School No Elementary PK 05 2018   grade_1 20 8 4 0   8     0   2   27 15                       42.0 20 8 4 0   8     0   2   27 15                 42
2231262 2231262 MA Middlesex   school 2504320 79   Dracut 250432000582 790030 Dracut: Greenmont Avenue   Regular School No Elementary KG 05 2018   grade_1 25 1 7 0   5     0   0   23 15                       38.0 25 1 7 0   5     0   0   23 15                 38
2232329 2232329 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland: Holland Elementary   Regular School No Elementary PK 06 2018   grade_1 30 0 0 0   2     0   0   17 15                       32.0 30 0 0 0   2     0   0   17 15                 32
2232362 2232362 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke: Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2018   grade_1 12 2 23 0   2     0   1   25 15                       40.0 12 2 23 0   2     0   1   25 15                 40
2234140 2234140 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 New Bedford: John Avery Parker   Regular School No Elementary PK 05 2018   grade_1 19 8 13 0   0     0   3   28 15                       43.0 19 8 13 0   0     0   3   28 15                 43
2234403 2234403 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 North Adams: Brayton   Regular School No Elementary PK 06 2018   grade_1 25 1 1 0   0     0   1   13 15                       28.0 25 1 1 0   0     0   1   13 15                 28
2234914 2234914 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham: Petersham Center   Regular School No Elementary KG 06 2018   grade_1 18 0 1 0   0     0   2   6 15                       21.0 18 0 1 0   0     0   2   6 15                 21
2235585 2235585 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Scituate: Hatherly Elementary   Regular School No Elementary KG 05 2018   grade_1 34 0 1 0   0     0   0   20 15                       35.0 34 0 1 0   0     0   0   20 15                 35
2237519 2237519 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Woburn: Shamrock   Regular School No Elementary PK 05 2018   grade_1 21 3 7 0   1     0   3   20 15                       35.0 21 3 7 0   1     0   3   20 15                 35
2238370 2238370 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District): River Valley Charter School   Regular School Yes Elementary KG 08 2018   grade_1 27 0 2 0   1     0   2   17 15                       32.0 27 0 2 0   1     0   2   17 15                 32
2229362 2229362 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston: Lee Academy   Regular School No Elementary PK 03 2018   grade_1 2 16 13 1   3     0   1   20 16                       36.0 2 16 13 1   3     0   1   20 16                 36
2229711 2229711 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston: Joyce Kilmer   Regular School No Elementary PK 08 2018   grade_1 22 8 10 0   2     0   2   28 16                       44.0 22 8 10 0   2     0   2   28 16                 44
2229882 2229882 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Boston: Samuel W Mason   Regular School No Elementary PK 05 2018   grade_1 3 18 12 0   0     0   4   21 16                       37.0 3 18 12 0   0     0   4   21 16                 37
2229912 2229912 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston: Thomas J Kenny   Regular School No Elementary PK 05 2018   grade_1 9 9 10 1   7     0   2   22 16                       38.0 9 9 10 1   7     0   2   22 16                 38
2230314 2230314 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston: Boylston Elementary   Regular School No Elementary PK 05 2018   grade_1 26 0 2 1   2     0   2   17 16                       33.0 26 0 2 1   2     0   2   17 16                 33
2231203 2231203 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_1 20 1 7 0   0     0   2   14 16                       30.0 20 1 7 0   0     0   2   14 16                 30
2231348 2231348 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton: Neil A Pepin   Regular School No Elementary KG 04 2018   grade_1 29 0 5 0   3     0   4   25 16                       41.0 29 0 5 0   3     0   4   25 16                 41
2231869 2231869 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin: Jefferson Elementary   Regular School No Elementary KG 05 2018   grade_1 35 0 1 0   0     1   1   22 16                       38.0 35 0 1 0   0     1   1   22 16                 38
2232089 2232089 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Greenfield: Newton School   Regular School No Elementary KG 04 2018   grade_1 24 2 16 0   0     0   2   28 16                       44.0 24 2 16 0   0     0   2   28 16                 44
2232565 2232565 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   grade_1 31 1 0 0   0     0   0   16 16                       32.0 31 1 0 0   0     0   0   16 16                 32
2233282 2233282 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Lynn: Capt William G Shoemaker   Regular School No Elementary PK 05 2018   grade_1 18 8 15 0   5     0   8   38 16                       54.0 18 8 15 0   5     0   8   38 16                 54
2234922 2234922 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Pittsfield: Allendale   Regular School No Elementary KG 05 2018   grade_1 35 1 4 1   0     0   8   33 16                       49.0 35 1 4 1   0     0   8   33 16                 49
2235153 2235153 MA Norfolk   school 2509870 243   Quincy 250987001567 2430075 Quincy: Francis W Parker   Regular School No Elementary KG 05 2018   grade_1 8 1 3 0   29     0   0   25 16                       41.0 8 1 3 0   29     0   0   25 16                 41
2235236 2235236 MA Norfolk   school 2509930 244   Randolph 250993001593 2440040 Randolph: Martin E Young Elementary   Regular School No Elementary KG 05 2018   grade_1 4 20 6 0   5     0   5   24 16                       40.0 4 20 6 0   5     0   5   24 16                 40
2235819 2235819 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Somerville: Winter Hill Community   Regular School No Elementary PK 08 2018   grade_1 14 1 20 0   1     0   2   22 16                       38.0 14 1 20 0   1     0   2   22 16                 38
2236308 2236308 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 Stoughton: South Elementary   Regular School No Elementary KG 05 2018   grade_1 21 9 5 0   2     0   0   21 16                       37.0 21 9 5 0   2     0   0   21 16                 37
2236362 2236362 MA Middlesex   school 2511340 288   Sudbury 251134000507 2880025 Sudbury: General John Nixon Elementary   Regular School No Elementary KG 05 2018   grade_1 33 2 0 0   4     0   3   26 16                       42.0 33 2 0 0   4     0   3   26 16                 42
2237198 2237198 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 West Springfield: Mittineague   Regular School No Elementary 01 05 2018   grade_1 27 2 8 0   0     0   0   21 16                       37.0 27 2 8 0   0     0   0   21 16                 37

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