enrollments

Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten · 6,647 ✖
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
738569 738569 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2015   kindergarten 43 0 4 0   0     0   1   26 22                       48 43 0 4 0   0     0   1   26 22                 48
738615 738615 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2015   kindergarten 31 0 5 0   1     0   1   24 14                       38 31 0 5 0   1     0   1   24 14                 38
738636 738636 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   kindergarten 54 0 0 0   0     0   2   32 24                       56 54 0 0 0   0     0   2   32 24                 56
738643 738643 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2015   kindergarten 45 0 2 0   0     0   2   25 24                       49 45 0 2 0   0     0   2   25 24                 49
738649 738649 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No 1 KG 05 2015   kindergarten 57 0 5 0   0     0   1   32 31                       63 57 0 5 0   0     0   1   32 31                 63
738655 738655 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2015   kindergarten 73 0 0 0   2     0   2   34 43                       77 73 0 0 0   2     0   2   34 43                 77
738707 738707 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No 1 PK KG 2015   kindergarten 9 0 14 0   0     0   0   9 14                       23 9 0 14 0   0     0   0   9 14                 23
738709 738709 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   kindergarten 15 0 27 0   1     0   1   24 20                       44 15 0 27 0   1     0   1   24 20                 44
738782 738782 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   kindergarten 62 0 2 0   0     0   2   38 28                       66 62 0 2 0   0     0   2   38 28                 66
738816 738816 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No 1 KG 04 2015   kindergarten 51 0 4 0   0     0   1   28 28                       56 51 0 4 0   0     0   1   28 28                 56
738850 738850 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2015   kindergarten 48 0 2 0   5     0   0   31 24                       55 48 0 2 0   5     0   0   31 24                 55
738879 738879 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   kindergarten 15 0 1 0   0     0   0   7 9                       16 15 0 1 0   0     0   0   7 9                 16
738887 738887 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Rollins Early Childhood Center   Regular School No 1 PK KG 2015   kindergarten 11 0 80 0   3     0   0   49 45                       94 11 0 80 0   3     0   0   49 45                 94
738889 738889 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawlor Early Childhood Center   Regular School No 1 KG KG 2015   kindergarten 2 0 173 0   1     0   0   91 85                       176 2 0 173 0   1     0   0   91 85                 176
738890 738890 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No 1 PK KG 2015   kindergarten 8 0 110 0   5     0   1   72 52                       124 8 0 110 0   5     0   1   72 52                 124
738896 738896 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   kindergarten 2 0 79 0   0     0   0   42 39                       81 2 0 79 0   0     0   0   42 39                 81
738936 738936 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   kindergarten 3 0 107 0   0     0   0   62 48                       110 3 0 107 0   0     0   0   62 48                 110
738960 738960 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2015   kindergarten 6 0 56 0   0     0   0   28 34                       62 6 0 56 0   0     0   0   28 34                 62
739026 739026 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   kindergarten 33 0 5 0   1     0   2   27 14                       41 33 0 5 0   1     0   2   27 14                 41
739054 739054 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2015   kindergarten 35 0 3 0   1     0   1   23 17                       40 35 0 3 0   1     0   1   23 17                 40
739112 739112 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   kindergarten 20 0 0 0   0     0   0   13 7                       20 20 0 0 0   0     0   0   13 7                 20
739145 739145 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No 1 KG 05 2015   kindergarten 37 0 2 0   17     0   4   29 31                       60 37 0 2 0   17     0   4   29 31                 60
739207 739207 MA Hampden   school 2506990 159   Longmeadow 250699001017 1590010 Center   Regular School No 1 PK 05 2015   kindergarten 42 0 3 0   3     0   1   34 15                       49 42 0 3 0   3     0   1   34 15                 49
739380 739380 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2015   kindergarten 97 0 6 0   0     1   7   49 62                       111 97 0 6 0   0     1   7   49 62                 111
739542 739542 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No 1 KG 04 2015   kindergarten 63 0 7 0   4     0   2   30 46                       76 63 0 7 0   4     0   2   30 46                 76
739637 739637 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No 1 PK 03 2015   kindergarten 63 0 1 0   1     0   1   37 29                       66 63 0 1 0   1     0   1   37 29                 66
739682 739682 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2015   kindergarten 26 0 0 0   0     0   1   17 10                       27 26 0 0 0   0     0   1   17 10                 27
739688 739688 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No 1 KG 05 2015   kindergarten 57 0 1 0   1     0   2   26 35                       61 57 0 1 0   1     0   2   26 35                 61
739694 739694 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No 1 PK 05 2015   kindergarten 40 0 5 0   0     0   1   23 23                       46 40 0 5 0   0     0   1   23 23                 46
739701 739701 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No 1 KG 05 2015   kindergarten 43 0 1 0   0     0   1   29 16                       45 43 0 1 0   0     0   1   29 16                 45
739707 739707 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No 1 PK 05 2015   kindergarten 56 0 5 0   1     0   3   32 33                       65 56 0 5 0   1     0   3   32 33                 65
739735 739735 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No 1 PK 03 2015   kindergarten 52 0 2 0   1     0   0   26 29                       55 52 0 2 0   1     0   0   26 29                 55
739757 739757 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No 1 PK 01 2015   kindergarten 129 0 9 2   8     0   0   86 62                       148 129 0 9 2   8     0   0   86 62                 148
739845 739845 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No 1 KG 05 2015   kindergarten 41 0 1 0   0     0   2   21 23                       44 41 0 1 0   0     0   2   21 23                 44
739935 739935 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No 1 KG 02 2015   kindergarten 75 0 0 0   4     0   0   37 42                       79 75 0 0 0   4     0   0   37 42                 79
739976 739976 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No 1 PK 04 2015   kindergarten 98 0 2 0   2     0   4   51 55                       106 98 0 2 0   2     0   4   51 55                 106
740024 740024 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No 1 PK 04 2015   kindergarten 60 0 2 0   1     1   0   30 34                       64 60 0 2 0   1     1   0   30 34                 64
740039 740039 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   kindergarten 20 0 0 0   2     0   0   11 11                       22 20 0 0 0   2     0   0   11 11                 22
740062 740062 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No 1 KG 04 2015   kindergarten 91 0 3 0   16     1   10   65 56                       121 91 0 3 0   16     1   10   65 56                 121
740072 740072 MA Middlesex   school 2508340 198   Natick 250834001298 1980031 Johnson   Regular School No 1 KG 04 2015   kindergarten 41 0 1 0   1     0   2   31 14                       45 41 0 1 0   1     0   2   31 14                 45
740082 740082 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No 1 KG 04 2015   kindergarten 91 0 1 0   1     0   5   57 41                       98 91 0 1 0   1     0   5   57 41                 98
740100 740100 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No 1 KG 05 2015   kindergarten 64 0 3 0   6     0   3   34 42                       76 64 0 3 0   6     0   3   34 42                 76
740248 740248 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No 1 KG 05 2015   kindergarten 39 0 4 0   0     0   4   22 25                       47 39 0 4 0   0     0   4   22 25                 47
740291 740291 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No 1 PK 03 2015   kindergarten 124 0 3 1   1     0   1   60 70                       130 124 0 3 1   1     0   1   60 70                 130
740366 740366 MA Middlesex   school 2508610 207   Newton 250861001373 2070105 Memorial Spaulding   Regular School No 1 KG 05 2015   kindergarten 58 0 6 0   12     0   3   42 37                       79 58 0 6 0   12     0   3   42 37                 79
740379 740379 MA Middlesex   school 2508610 207   Newton 250861001369 2070120 John Ward   Regular School No 1 KG 05 2015   kindergarten 35 0 2 0   6     0   3   24 22                       46 35 0 2 0   6     0   3   24 22                 46
740385 740385 MA Middlesex   school 2508610 207   Newton 250861001382 2070125 Williams   Regular School No 1 KG 05 2015   kindergarten 19 0 3 1   11     0   3   17 20                       37 19 0 3 1   11     0   3   17 20                 37
740423 740423 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No 1 PK 02 2015   kindergarten 86 0 7 0   2     0   1   57 39                       96 86 0 7 0   2     0   1   57 39                 96
740470 740470 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Leeds   Regular School No 1 KG 05 2015   kindergarten 36 0 9 0   0     0   2   31 16                       47 36 0 9 0   0     0   2   31 16                 47
740476 740476 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 R. K. Finn Ryan Road   Regular School No 1 KG 05 2015   kindergarten 21 0 8 0   2     0   2   19 14                       33 21 0 8 0   2     0   2   19 14                 33
740515 740515 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No 1 KG 05 2015   kindergarten 39 0 11 0   3     0   1   25 29                       54 39 0 11 0   3     0   1   25 29                 54
740572 740572 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Lincoln Street   Regular School No 1 KG 05 2015   kindergarten 29 0 1 0   4     0   1   21 14                       35 29 0 1 0   4     0   1   21 14                 35
740578 740578 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Marguerite E Peaslee   Regular School No 1 KG 05 2015   kindergarten 26 0 8 0   10     0   3   23 24                       47 26 0 8 0   10     0   3   23 24                 47
740590 740590 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No 1 PK 05 2015   kindergarten 31 0 1 0   7     0   1   25 15                       40 31 0 1 0   7     0   1   25 15                 40
740615 740615 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2015   kindergarten 34 0 1 0   0     0   1   15 21                       36 34 0 1 0   0     0   1   15 21                 36
740629 740629 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 E Ethel Little School   Regular School No 1 PK 05 2015   kindergarten 34 0 1 0   3     0   6   28 16                       44 34 0 1 0   3     0   6   28 16                 44
740636 740636 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 L D Batchelder   Regular School No 1 KG 05 2015   kindergarten 52 0 1 0   1     0   3   34 23                       57 52 0 1 0   1     0   3   34 23                 57
740642 740642 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 J Turner Hood   Regular School No 1 PK 05 2015   kindergarten 56 0 1 0   2     0   1   32 28                       60 56 0 1 0   2     0   1   32 28                 60
740673 740673 MA Plymouth   school 2509030 219   Norwell 250903001454 2190005 Grace Farrar Cole   Regular School No 1 PK 05 2015   kindergarten 60 0 2 0   0     0   2   33 31                       64 60 0 2 0   0     0   2   33 31                 64
740680 740680 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2015   kindergarten 72 0 0 0   0     0   3   38 37                       75 72 0 0 0   0     0   3   38 37                 75
740729 740729 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   kindergarten 36 0 5 2   1     0   4   19 29                       48 36 0 5 2   1     0   4   19 29                 48
740747 740747 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No 1 KG 05 2015   kindergarten 31 0 0 0   0     0   0   19 12                       31 31 0 0 0   0     0   0   19 12                 31
740772 740772 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No 1 PK 04 2015   kindergarten 81 0 16 0   3     0   3   57 46                       103 81 0 16 0   3     0   3   57 46                 103
740794 740794 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No 1 KG 05 2015   kindergarten 37 0 2 0   0     0   2   26 15                       41 37 0 2 0   0     0   2   26 15                 41
740854 740854 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2015   kindergarten 69 0 0 0   0     0   4   38 35                       73 69 0 0 0   0     0   4   38 35                 73
740868 740868 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2015   kindergarten 78 0 0 0   1     0   3   45 37                       82 78 0 0 0   1     0   3   45 37                 82
740883 740883 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   kindergarten 16 0 0 0   0     0   0   6 10                       16 16 0 0 0   0     0   0   6 10                 16
740902 740902 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No 1 PK 05 2015   kindergarten 26 0 2 0   0     0   5   19 14                       33 26 0 2 0   0     0   5   19 14                 33
740923 740923 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No 1 KG 05 2015   kindergarten 40 0 3 0   0     0   2   24 21                       45 40 0 3 0   0     0   2   24 21                 45
740965 740965 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Cold Spring   Regular School No 1 KG 05 2015   kindergarten 26 0 6 0   1     0   4   20 17                       37 26 0 6 0   1     0   4   20 17                 37
740989 740989 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Manomet Elementary   Regular School No 1 KG 05 2015   kindergarten 50 0 0 0   0     0   1   26 25                       51 50 0 0 0   0     0   1   26 25                 51
741028 741028 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2015   kindergarten 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
741046 741046 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No 1 KG 05 2015   kindergarten 43 0 1 0   20     0   0   32 32                       64 43 0 1 0   20     0   0   32 32                 64
741183 741183 MA Middlesex   school 2509990 246   Reading 250999001609 2460010 Joshua Eaton   Regular School No 1 KG 05 2015   kindergarten 62 0 3 0   4     0   4   38 35                       73 62 0 3 0   4     0   4   38 35                 73
741268 741268 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   kindergarten 17 0 0 0   1     0   0   9 9                       18 17 0 0 0   1     0   0   9 9                 18
741309 741309 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport Elementary   Regular School No 1 PK 05 2015   kindergarten 55 0 0 0   2     0   1   32 26                       58 55 0 0 0   2     0   1   32 26                 58
741404 741404 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 KG 06 2015   kindergarten 59 0 0 0   1     0   0   30 30                       60 59 0 0 0   1     0   0   30 30                 60
741450 741450 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2015   kindergarten 7 0 0 0   0     0   0   2 5                       7 7 0 0 0   0     0   0   2 5                 7
741478 741478 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No 1 PK 06 2015   kindergarten 41 0 0 0   0     0   1   18 24                       42 41 0 0 0   0     0   1   18 24                 42
741493 741493 MA Bristol   school 2510590 265   Seekonk 251059001695 2650007 George R Martin   Regular School No 1 KG 05 2015   kindergarten 47 0 2 0   1     0   0   24 26                       50 47 0 2 0   1     0   0   24 26                 50
741539 741539 MA Middlesex   school 2510710 269   Sherborn 251071001709 2690010 Pine Hill   Regular School No 1 PK 05 2015   kindergarten 39 0 1 0   2     0   8   26 24                       50 39 0 1 0   2     0   8   26 24                 50
741557 741557 MA Worcester   school 2510770 271   Shrewsbury 251077001719 2710025 Walter J Paton   Regular School No 1 KG 04 2015   kindergarten 15 0 0 0   2     0   3   10 10                       20 15 0 0 0   2     0   3   10 10                 20
741564 741564 MA Worcester   school 2510770 271   Shrewsbury 251077001718 2710035 Spring Street   Regular School No 1 KG 04 2015   kindergarten 28 0 3 0   7     0   2   17 23                       40 28 0 3 0   7     0   2   17 23                 40
741585 741585 MA Bristol   school 2510860 273   Somerset 251086001723 2730005 Chace Street   Regular School No 1 PK 05 2015   kindergarten 37 0 1 0   1     0   0   17 22                       39 37 0 1 0   1     0   0   17 22                 39
741592 741592 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No 1 KG 05 2015   kindergarten 54 0 1 0   0     0   4   24 35                       59 54 0 1 0   0     0   4   24 35                 59
741687 741687 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No 1 PK 06 2015   kindergarten 54 0 2 0   1     0   3   31 29                       60 54 0 2 0   1     0   3   31 29                 60
741724 741724 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No 1 PK 01 2015   kindergarten 107 0 20 1   0     0   9   67 70                       137 107 0 20 1   0     0   9   67 70                 137
742100 742100 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   kindergarten 101 0 3 2   1     0   4   66 45                       111 101 0 3 2   1     0   4   66 45                 111
742108 742108 MA Middlesex   school 2511340 288   Sudbury 251134001876 2880010 Josiah Haynes   Regular School No 1 KG 05 2015   kindergarten 54 0 0 0   6     0   5   39 26                       65 54 0 0 0   6     0   5   39 26                 65
742114 742114 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Israel Loring School   Regular School No 1 KG 05 2015   kindergarten 36 0 3 1   7     1   4   31 21                       52 36 0 3 1   7     1   4   31 21                 52
742126 742126 MA Middlesex   school 2511340 288   Sudbury 251134001877 2880030 Peter Noyes   Regular School No 1 PK 05 2015   kindergarten 61 0 2 0   9     0   11   41 42                       83 61 0 2 0   9     0   11   41 42                 83
742136 742136 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2015   kindergarten 13 0 3 0   1     0   1   8 10                       18 13 0 3 0   1     0   1   8 10                 18
742158 742158 MA Essex   school 2511430 291   Swampscott 251143001883 2910005 Clarke   Regular School No 1 KG 04 2015   kindergarten 29 0 4 1   2     0   1   19 18                       37 29 0 4 1   2     0   1   19 18                 37
742169 742169 MA Essex   school 2511430 291   Swampscott 251143001886 2910020 Stanley   Regular School No 1 KG 04 2015   kindergarten 49 0 2 0   1     0   2   28 26                       54 49 0 2 0   1     0   2   28 26                 54
742189 742189 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Mark G Hoyle Elementary   Regular School No 1 PK 02 2015   kindergarten 70 0 1 1   2     0   3   35 42                       77 70 0 1 1   2     0   3   35 42                 77
742291 742291 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Steward Elementary   Regular School No 1 PK 03 2015   kindergarten 75 0 0 0   1     0   3   43 36                       79 75 0 0 0   1     0   3   43 36                 79
742296 742296 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2015   kindergarten 10 0 0 0   0     0   2   10 2                       12 10 0 0 0   0     0   2   10 2                 12
742332 742332 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Early Childhood Center at the Doyle School   Regular School No 1 PK KG 2015   kindergarten 26 0 1 1   2     0   2   14 18                       32 26 0 1 1   2     0   2   14 18                 32
742334 742334 MA Middlesex   school 2511910 305   Wakefield 251191001941 3050005 Dolbeare   Regular School No 1 KG 04 2015   kindergarten 73 0 3 0   2     0   3   43 38                       81 73 0 3 0   2     0   3   43 38                 81
742371 742371 MA Norfolk   school 2511970 307   Walpole 251197001235 3070005 Elm Street School   Regular School No 1 KG 05 2015   kindergarten 54 0 1 0   2     0   2   34 25                       59 54 0 1 0   2     0   2   34 25                 59

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