enrollments

Data source: Big Local News · About: Big Local

988 rows where grade = "grade_1", state = "MA" and year = 2016 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 988 ✖

grade ✖

  • grade_1 · 988 ✖
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
938259 938259 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2016   grade_1 9 0 1 0   0     0   0   1 9                       10 9 0 1 0   0     0   0   1 9                 10
938515 938515 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No 1 PK 02 2016   grade_1 * * * *   *     *   *   1 2                       3                         1 2                 3
934461 934461 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_1 16 0 1 0   0     0   0   10 7                       17 16 0 1 0   0     0   0   10 7                 17
934523 934523 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2016   grade_1 14 0 1 0   0     0   0   10 5                       15 14 0 1 0   0     0   0   10 5                 15
934715 934715 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   grade_1 23 0 1 1   0     0   1   10 16                       26 23 0 1 1   0     0   1   10 16                 26
935554 935554 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No 1 PK 01 2016   grade_1 9 1 16 0   0     0   0   10 16                       26 9 1 16 0   0     0   0   10 16                 26
938097 938097 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2016   grade_1 19 0 0 0   0     0   1   10 10                       20 19 0 0 0   0     0   1   10 10                 20
940469 940469 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_1 16 0 1 0   0     0   3   10 10                       20 16 0 1 0   0     0   3   10 10                 20
940992 940992 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No 1 PK 05 2016   grade_1 16 0 1 0   0     0   0   10 7                       17 16 0 1 0   0     0   0   10 7                 17
941531 941531 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No 1 PK 06 2016   grade_1 18 0 1 0   0     0   1   10 10                       20 18 0 1 0   0     0   1   10 10                 20
942023 942023 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_1 13 2 1 0   2     0   2   10 10                       20 13 2 1 0   2     0   2   10 10                 20
932853 932853 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2016   grade_1 138 12 11 0   29     1   7   100 98                       198 138 12 11 0   29     1   7   100 98                 198
934356 934356 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2016   grade_1 18 16 159 0   1     0   4   103 95                       198 18 16 159 0   1     0   4   103 95                 198
934750 934750 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No 1 PK 02 2016   grade_1 138 5 17 0   9     0   5   103 71                       174 138 5 17 0   9     0   5   103 71                 174
935542 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
935210 935210 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   grade_1 137 7 26 1   0     0   26   106 91                       197 137 7 26 1   0     0   26   106 91                 197
940946 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
933020 933020 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No 1 KG 05 2016   grade_1 25 1 2 0   0     0   3   11 20                       31 25 1 2 0   0     0   3   11 20                 31
933068 933068 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   grade_1 11 4 7 1   0     0   0   11 12                       23 11 4 7 1   0     0   0   11 12                 23
933624 933624 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_1 9 8 5 0   0     0   2   11 13                       24 9 8 5 0   0     0   2   11 13                 24
936887 936887 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2016   grade_1 22 0 0 0   1     0   0   11 12                       23 22 0 0 0   1     0   0   11 12                 23
937858 937858 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2016   grade_1 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
939733 939733 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2016   grade_1 16 0 0 0   0     0   1   11 6                       17 16 0 0 0   0     0   1   11 6                 17
939918 939918 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2016   grade_1 9 0 4 0   1     0   1   11 4                       15 9 0 4 0   1     0   1   11 4                 15
940363 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
941384 941384 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No 1 PK 04 2016   grade_1 14 0 2 0   0     0   2   11 7                       18 14 0 2 0   0     0   2   11 7                 18
941655 941655 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 PK 06 2016   grade_1 17 0 1 1   0     0   2   11 10                       21 17 0 1 1   0     0   2   11 10                 21
936457 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
933054 933054 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2016   grade_1 3 6 22 0   3     0   1   12 23                       35 3 6 22 0   3     0   1   12 23                 35
933385 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
933858 933858 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2016   grade_1 30 0 1 0   2     0   1   12 22                       34 30 0 1 0   2     0   1   12 22                 34
935258 935258 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2016   grade_1 26 0 4 0   0     0   0   12 18                       30 26 0 4 0   0     0   0   12 18                 30
937093 937093 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No 1 KG 05 2016   grade_1 30 3 7 0   0     0   3   12 31                       43 30 3 7 0   0     0   3   12 31                 43
939623 939623 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2016   grade_1 20 2 7 0   0     0   0   12 17                       29 20 2 7 0   0     0   0   12 17                 29
940970 940970 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2016   grade_1 18 0 1 1   0     0   0   12 8                       20 18 0 1 1   0     0   0   12 8                 20
941567 941567 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No 1 PK 01 2016   grade_1 34 0 0 0   0     0   0   12 22                       34 34 0 0 0   0     0   0   12 22                 34
939278 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
935646 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
934415 934415 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2016   grade_1 18 0 5 0   1     0   1   13 12                       25 18 0 5 0   1     0   1   13 12                 25
936998 936998 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No 1 PK 05 2016   grade_1 26 4 5 0   0     0   4   13 26                       39 26 4 5 0   0     0   4   13 26                 39
937280 937280 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2016   grade_1 27 1 1 0   0     0   1   13 17                       30 27 1 1 0   0     0   1   13 17                 30
939861 939861 MA Middlesex   school 2513200 347   Woburn 251320002187 3470025 Linscott-Rumford   Regular School No 1 KG 05 2016   grade_1 21 2 1 0   9     0   0   13 20                       33 21 2 1 0   9     0   0   13 20                 33
941552 941552 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2016   grade_1 22 0 2 1   0     0   0   13 12                       25 22 0 2 1   0     0   0   13 12                 25
933208 933208 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No 1 PK 05 2016   grade_1 4 9 13 0   1     0   1   14 14                       28 4 9 13 0   1     0   1   14 14                 28
935960 935960 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   grade_1 18 0 0 0   1     0   0   14 5                       19 18 0 0 0   1     0   0   14 5                 19
936321 936321 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No 1 KG 05 2016   grade_1 23 1 2 0   0     0   2   14 14                       28 23 1 2 0   0     0   2   14 14                 28
939887 939887 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2016   grade_1 30 0 3 0   4     0   0   14 23                       37 30 0 3 0   4     0   0   14 23                 37
933324 933324 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No 1 PK 05 2016   grade_1 13 5 3 0   0     1   1   15 8                       23 13 5 3 0   0     1   1   15 8                 23
933606 933606 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_1 1 33 8 0   0     0   1   15 28                       43 1 33 8 0   0     0   1   15 28                 43
935344 935344 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_1 27 1 2 0   0     1   0   15 16                       31 27 1 2 0   0     1   0   15 16                 31
939650 939650 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Downey   Regular School No 1 KG 05 2016   grade_1 25 0 4 0   3     0   1   15 18                       33 25 0 4 0   3     0   1   15 18                 33
934611 934611 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No 1 01 05 2016   grade_1 21 1 9 0   1     0   0   16 16                       32 21 1 9 0   1     0   0   16 16                 32
935306 935306 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2016   grade_1 44 0 1 1   0     0   2   16 32                       48 44 0 1 1   0     0   2   16 32                 48
935322 935322 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 04 2016   grade_1 39 0 4 0   0     0   0   16 27                       43 39 0 4 0   0     0   0   16 27                 43
937794 937794 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Cold Spring   Regular School No 1 KG 05 2016   grade_1 27 1 5 0   2     0   1   16 20                       36 27 1 5 0   2     0   1   16 20                 36
938226 938226 MA Essex   school 2510500 262   Saugus 251050001680 2620040 Lynnhurst   Regular School No 1 KG 05 2016   grade_1 26 2 5 0   4     1   0   16 22                       38 26 2 5 0   4     1   0   16 22                 38
940071 940071 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2016   grade_1 23 1 4 0   4     0   2   16 18                       34 23 1 4 0   4     0   2   16 18                 34
940806 940806 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2016   grade_1 30 5 0 0   0     0   0   16 19                       35 30 5 0 0   0     0   0   16 19                 35
932945 932945 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2016   grade_1 21 0 2 0   0     0   0   17 6                       23 21 0 2 0   0     0   0   17 6                 23
933191 933191 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2016   grade_1 16 6 14 0   0     0   6   17 25                       42 16 6 14 0   0     0   6   17 25                 42
933378 933378 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2016   grade_1 4 17 15 0   1     0   2   17 22                       39 4 17 15 0   1     0   2   17 22                 39
933409 933409 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_1 11 6 5 0   1     0   1   17 7                       24 11 6 5 0   1     0   1   17 7                 24
935252 935252 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2016   grade_1 34 0 0 0   0     1   0   17 18                       35 34 0 0 0   0     1   0   17 18                 35
935406 935406 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   grade_1 29 0 2 0   0     0   0   17 14                       31 29 0 2 0   0     0   0   17 14                 31
938232 938232 MA Essex   school 2510500 262   Saugus 251050001682 2620050 Oaklandvale   Regular School No 1 KG 05 2016   grade_1 21 2 5 1   0     1   4   17 17                       34 21 2 5 1   0     1   4   17 17                 34
938413 938413 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No 1 KG 06 2016   grade_1 23 2 2 0   3     0   7   17 20                       37 23 2 2 0   3     0   7   17 20                 37
938969 938969 MA Essex   school 2511430 291   Swampscott 251143001883 2910005 Clarke   Regular School No 1 KG 04 2016   grade_1 29 0 6 0   3     0   1   17 22                       39 29 0 6 0   3     0   1   17 22                 39
939484 939484 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2016   grade_1 20 0 6 0   3     0   1   17 13                       30 20 0 6 0   3     0   1   17 13                 30
939855 939855 MA Middlesex   school 2513200 347   Woburn 251320002183 3470020 Daniel P Hurld   Regular School No 1 KG 05 2016   grade_1 35 0 0 0   1     0   0   17 19                       36 35 0 0 0   1     0   0   17 19                 36
940224 940224 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes 1 PK 04 2016   grade_1 0 32 10 0   0     0   2   17 27                       44 0 32 10 0   0     0   2   17 27                 44
941559 941559 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2016   grade_1 43 0 1 0   0     0   0   17 27                       44 43 0 1 0   0     0   0   17 27                 44
941725 941725 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2016   grade_1 28 1 3 1   0     0   3   17 19                       36 28 1 3 1   0     0   3   17 19                 36
933509 933509 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2016   grade_1 2 3 30 0   2     0   1   18 20                       38 2 3 30 0   2     0   1   18 20                 38
933570 933570 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No 1 PK 05 2016   grade_1 14 7 13 0   4     0   4   18 24                       42 14 7 13 0   4     0   4   18 24                 42
934142 934142 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No 1 KG 05 2016   grade_1 27 1 3 0   5     0   2   18 20                       38 27 1 3 0   5     0   2   18 20                 38
934230 934230 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No 1 PK 05 2016   grade_1 7 10 6 0   10     0   5   18 20                       38 7 10 6 0   10     0   5   18 20                 38
937446 937446 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2016   grade_1 36 0 1 0   0     0   1   18 20                       38 36 0 1 0   0     0   1   18 20                 38
937538 937538 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2016   grade_1 30 4 5 0   4     0   0   18 25                       43 30 4 5 0   4     0   0   18 25                 43
939383 939383 MA Norfolk   school 2512270 317   Wellesley 251227002023 3170020 John D Hardy   Regular School No 1 KG 05 2016   grade_1 26 2 3 0   8     0   2   18 23                       41 26 2 3 0   8     0   2   18 23                 41
939514 939514 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Russell Elementary School   Regular School No 1 KG 05 2016   grade_1 33 0 2 0   0     0   0   18 17                       35 33 0 2 0   0     0   0   18 17                 35
939691 939691 MA Norfolk   school 2512840 336   Weymouth 251284002565 3360050 Frederick C Murphy   Regular School No 1 KG 04 2016   grade_1 31 0 2 0   1     0   5   18 21                       39 31 0 2 0   1     0   5   18 21                 39
939696 939696 MA Norfolk   school 2512840 336   Weymouth 251284000509 3360060 Thomas V Nash   Regular School No 1 KG 04 2016   grade_1 37 1 1 0   4     0   1   18 26                       44 37 1 1 0   4     0   1   18 26                 44
939933 939933 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2016   grade_1 7 5 20 0   0     0   2   18 16                       34 7 5 20 0   0     0   2   18 16                 34
940041 940041 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2016   grade_1 24 6 9 1   5     0   3   18 30                       48 24 6 9 1   5     0   3   18 30                 48
940629 940629 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2016   grade_1 30 0 0 0   3     0   1   18 16                       34 30 0 0 0   3     0   1   18 16                 34
941197 941197 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No 1 KG 05 2016   grade_1 37 0 0 0   0     3   1   18 23                       41 37 0 0 0   0     3   1   18 23                 41
942010 942010 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_1 25 6 10 0   1     0   1   18 25                       43 25 6 10 0   1     0   1   18 25                 43
932708 932708 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2016   grade_1 27 1 7 0   6     0   1   19 23                       42 27 1 7 0   6     0   1   19 23                 42
933042 933042 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No 1 PK 01 2016   grade_1 11 3 13 0   5     0   1   19 14                       33 11 3 13 0   5     0   1   19 14                 33
933519 933519 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No 1 PK 05 2016   grade_1 11 13 8 0   12     0   2   19 27                       46 11 13 8 0   12     0   2   19 27                 46
933920 933920 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_1 35 2 0 0   0     0   0   19 18                       37 35 2 0 0   0     0   0   19 18                 37
934209 934209 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No 1 PK 05 2016   grade_1 19 10 11 0   5     0   5   19 31                       50 19 10 11 0   5     0   5   19 31                 50
935531 935531 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2016   grade_1 28 1 1 1   0     0   0   19 12                       31 28 1 1 1   0     0   0   19 12                 31
936691 936691 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No 1 KG 05 2016   grade_1 41 0 1 0   0     0   2   19 25                       44 41 0 1 0   0     0   2   19 25                 44
938164 938164 MA Essex   school 2510380 258   Salem 251038001656 2580015 Carlton   Regular School No 1 KG 05 2016   grade_1 25 1 11 0   0     0   2   19 20                       39 25 1 11 0   0     0   2   19 20                 39
938185 938185 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No 1 KG 08 2016   grade_1 20 3 10 0   3     0   1   19 18                       37 20 3 10 0   3     0   1   19 18                 37
938390 938390 MA Bristol   school 2510860 273   Somerset 251086001723 2730005 Chace Street   Regular School No 1 PK 05 2016   grade_1 39 0 1 0   1     0   0   19 22                       41 39 0 1 0   1     0   0   19 22                 41
938729 938729 MA Hampden   school 2511130 281   Springfield 251113001835 2810180 Warner   Regular School No 1 PK 05 2016   grade_1 7 14 26 0   1     0   1   19 30                       49 7 14 26 0   1     0   1   19 30                 49
938885 938885 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No 1 KG 05 2016   grade_1 20 13 5 1   2     1   4   19 27                       46 20 13 5 1   2     1   4   19 27                 46
939478 939478 MA Hampden   school 2512630 325   Westfield 251263002064 3250015 Franklin Ave   Regular School No 1 KG 05 2016   grade_1 20 1 11 1   0     0   2   19 16                       35 20 1 11 1   0     0   2   19 16                 35

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