Data source: Big Local News · About: Big Local

960 rows where grade = "kindergarten", state = "MA" and year = 2019 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2019 · 960

grade

  • kindergarten · 960
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
2040315 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2019   kindergarten 13 5 15 1   7     0   1   23 19                       42.0 13 5 15 1   7     0   1   23 19                 42
2040327 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2019   kindergarten 4 10 14 0   4     0   1   15 18                       33.0 4 10 14 0   4     0   1   15 18                 33
2040335 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2019   kindergarten 23 4 32 0   2     0   0   34 27                       61.0 23 4 32 0   2     0   0   34 27                 61
2040338 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2019   kindergarten 2 34 25 1   4     0   1   32 35                       67.0 2 34 25 1   4     0   1   32 35                 67
2040731 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2019   kindergarten 18 29 7 0   9     1   4   38 30                       68.0 18 29 7 0   9     1   4   38 30                 68
2041640 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2019   kindergarten 44 23 446 0   4     0   3   239 281                       520.0 44 23 446 0   4     0   3   239 281                 520
2041926 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2019   kindergarten 79 0 4 0   1     0   1   50 35                       85.0 79 0 4 0   1     0   1   50 35                 85
2042518 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2019   kindergarten 115 3 39 0   0     0   16   102 71                       173.0 115 3 39 0   0     0   16   102 71                 173
2042587 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2019   kindergarten 80 3 3 0   15     0   5   61 45                       106.0 80 3 3 0   15     0   5   61 45                 106
2042590 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2019   kindergarten 69 2 4 0   19     0   0   45 49                       94.0 69 2 4 0   19     0   0   45 49                 94
2042960 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2019   kindergarten 175 0 14 0   56     0   15   125 135                       260.0 175 0 14 0   56     0   15   125 135                 260
2043511 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2019   kindergarten 120 3 18 0   2     0   5   69 79                       148.0 120 3 18 0   2     0   5   69 79                 148
2043899 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2019   kindergarten 167 0 5 2   6     0   4   95 89                       184.0 167 0 5 2   6     0   4   95 89                 184
2043956 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2019   kindergarten 135 1 4 0   3     0   2   82 63                       145.0 135 1 4 0   3     0   2   82 63                 145
2044731 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2019   kindergarten 107 1 13 0   0     0   11   69 63                       132.0 107 1 13 0   0     0   11   69 63                 132
2044886 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2019   kindergarten 94 1 17 1   0     0   4   58 59                       117.0 94 1 17 1   0     0   4   58 59                 117
2045654 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2019   kindergarten 87 8 18 4   96     0   8   122 99                       221.0 87 8 18 4   96     0   8   122 99                 221
2045802 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2019   kindergarten 87 1 5 1   11     0   6   54 57                       111.0 87 1 5 1   11     0   6   54 57                 111
2045816 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2019   kindergarten 53 1 83 1   1     1   1   68 73                       141.0 53 1 83 1   1     1   1   68 73                 141
2045834 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2019   kindergarten 114 1 21 0   4     0   4   65 79                       144.0 114 1 21 0   4     0   4   65 79                 144
2045919 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2019   kindergarten 4 11 20 0   0     0   0   20 15                       35.0 4 11 20 0   0     0   0   20 15                 35
2048128 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2019   kindergarten 93 0 5 0   1     0   2   53 48                       101.0 93 0 5 0   1     0   2   53 48                 101
2048236 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No Elementary KG 01 2019   kindergarten 152 8 7 0   5     0   7   100 79                       179.0 152 8 7 0   5     0   7   100 79                 179
2048358 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2019   kindergarten 89 1 9 1   1     0   6   64 43                       107.0 89 1 9 1   1     0   6   64 43                 107
2048361 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2019   kindergarten 117 2 18 0   1     0   6   70 74                       144.0 117 2 18 0   1     0   6   70 74                 144
2048471 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2019   kindergarten 43 2 7 0   2     0   4   36 22                       58.0 43 2 7 0   2     0   4   36 22                 58
2048521 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2019   kindergarten 118 3 14 0   4     2   6   75 72                       147.0 118 3 14 0   4     2   6   75 72                 147
2048696 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Center   Regular School No Elementary KG 01 2019   kindergarten 85 1 5 0   0     0   3   48 46                       94.0 85 1 5 0   0     0   3   48 46                 94
2048870 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2019   kindergarten 20 0 2 0   0     0   1   10 13                       23.0 20 0 2 0   0     0   1   10 13                 23
2039813 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   kindergarten 130 10 5 1   6     0   1   79 74                       153.0 130 10 5 1   6     0   1   79 74                 153
2040008 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   kindergarten 135 5 27 1   47     0   12   125 102                       227.0 135 5 27 1   47     0   12   125 102                 227
2040067 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2019   kindergarten 70 0 9 0   6     0   5   52 38                       90.0 70 0 9 0   6     0   5   52 38                 90
2040071 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   kindergarten 81 1 11 0   2     0   2   53 44                       97.0 81 1 11 0   2     0   2   53 44                 97
2040128 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   kindergarten 106 12 11 0   47     0   15   110 81                       191.0 106 12 11 0   47     0   15   110 81                 191
2040366 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2019   kindergarten 0 18 21 1   0     0   2   23 19                       42.0 0 18 21 1   0     0   2   23 19                 42
2040370 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 02 2019   kindergarten 6 76 40 1   1     0   0   75 49                       124.0 6 76 40 1   1     0   0   75 49                 124
2040384 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2019   kindergarten 32 20 20 0   6     0   4   38 44                       82.0 32 20 20 0   6     0   4   38 44                 82
2041132 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2019   kindergarten 60 0 5 0   1     0   10   44 32                       76.0 60 0 5 0   1     0   10   44 32                 76
2041195 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2019   kindergarten 56 1 5 0   0     0   4   29 37                       66.0 56 1 5 0   0     0   4   29 37                 66
2041687 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2019   kindergarten 41 7 23 0   2     0   1   35 39                       74.0 41 7 23 0   2     0   1   35 39                 74
2041780 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2019   kindergarten 95 3 1 0   1     0   1   47 54                       101.0 95 3 1 0   1     0   1   47 54                 101
2041983 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2019   kindergarten 170 1 1 0   1     0   4   93 84                       177.0 170 1 1 0   1     0   4   93 84                 177
2041995 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2019   kindergarten 126 5 3 0   1     0   7   67 75                       142.0 126 5 3 0   1     0   7   67 75                 142
2042044 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2019   kindergarten 121 8 20 1   4     0   9   75 88                       163.0 121 8 20 1   4     0   9   75 88                 163
2042059 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2019   kindergarten 51 8 6 0   2     0   2   31 38                       69.0 51 8 6 0   2     0   2   31 38                 69
2042063 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2019   kindergarten 79 3 5 0   2     0   4   43 50                       93.0 79 3 5 0   2     0   4   43 50                 93
2042067 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2019   kindergarten 53 6 3 1   4     1   4   37 35                       72.0 53 6 3 1   4     1   4   37 35                 72
2042681 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2019   kindergarten 101 1 4 0   1     0   3   53 57                       110.0 101 1 4 0   1     0   3   53 57                 110
2042723 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2019   kindergarten 17 2 19 0   1     0   1   18 22                       40.0 17 2 19 0   1     0   1   18 22                 40
2042783 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2019   kindergarten 33 0 9 0   0     0   1   24 19                       43.0 33 0 9 0   0     0   1   24 19                 43
2042860 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2019   kindergarten 148 2 7 0   12     1   3   101 71                       173.0 148 2 7 0   12     1   3   101 71                 173
2043037 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2019   kindergarten 147 0 1 0   0     0   3   72 79                       151.0 147 0 1 0   0     0   3   72 79                 151
2043077 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2019   kindergarten 4 1 80 0   1     0   0   46 39                       86.0 4 1 80 0   1     0   0   46 39                 86
2043172 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No Elementary PK 02 2019   kindergarten 70 6 8 0   1     0   1   42 44                       86.0 70 6 8 0   1     0   1   42 44                 86
2043317 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2019   kindergarten 102 1 1 0   13     1   2   69 51                       120.0 102 1 1 0   13     1   2   69 51                 120
2043526 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2019   kindergarten 127 7 8 0   0     0   2   70 74                       144.0 127 7 8 0   0     0   2   70 74                 144
2043753 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2019   kindergarten 172 9 12 0   14     0   15   116 106                       222.0 172 9 12 0   14     0   15   116 106                 222
2043863 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   kindergarten 60 3 15 3   1     0   15   52 45                       97.0 60 3 15 3   1     0   15   52 45                 97
2044074 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No Elementary KG 02 2019   kindergarten 85 1 8 1   5     0   6   54 52                       106.0 85 1 8 1   5     0   6   54 52                 106
2044082 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2019   kindergarten 74 3 51 1   3     0   5   68 69                       137.0 74 3 51 1   3     0   5   68 69                 137
2044085 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2019   kindergarten 100 6 43 0   4     0   3   87 69                       156.0 100 6 43 0   4     0   3   87 69                 156
2044187 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 02 2019   kindergarten 58 6 38 0   4     0   5   52 59                       111.0 58 6 38 0   4     0   5   52 59                 111
2044560 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2019   kindergarten 114 1 2 0   3     0   4   59 65                       124.0 114 1 2 0   3     0   4   59 65                 124
2044873 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No Elementary PK 02 2019   kindergarten 60 2 4 1   0     0   2   36 33                       69.0 60 2 4 1   0     0   2   36 33                 69
2045514 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2019   kindergarten 163 5 7 0   7     0   0   92 90                       182.0 163 5 7 0   7     0   0   92 90                 182
2046269 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2019   kindergarten 92 2 0 0   1     0   4   62 37                       99.0 92 2 0 0   1     0   4   62 37                 99
2046310 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No Elementary KG 02 2019   kindergarten 73 0 5 0   1     0   2   39 42                       81.0 73 0 5 0   1     0   2   39 42                 81
2046314 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Mark G Hoyle Elementary   Regular School No Elementary PK 02 2019   kindergarten 52 2 1 0   3     0   1   26 33                       59.0 52 2 1 0   3     0   1   26 33                 59
2046384 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2019   kindergarten 118 8 9 0   9     0   1   80 65                       145.0 118 8 9 0   9     0   1   80 65                 145
2046387 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2019   kindergarten 90 4 5 0   3     0   1   46 57                       103.0 90 4 5 0   3     0   1   46 57                 103
2046532 MA Middlesex   school 2512000 308   Waltham 251200002863 3080001 Waltham Public Schools Dual Language Program   Regular School No Elementary KG 02 2019   kindergarten 5 3 27 0   0     0   2   21 16                       37.0 5 3 27 0   0     0   2   21 16                 37
2046600 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2019   kindergarten 116 12 15 2   3     0   21   88 81                       169.0 116 12 15 2   3     0   21   88 81                 169
2046845 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2019   kindergarten 74 0 2 0   15     0   0   41 50                       91.0 74 0 2 0   15     0   0   41 50                 91
2046848 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No Elementary KG 02 2019   kindergarten 47 1 1 0   24     0   6   45 34                       79.0 47 1 1 0   24     0   6   45 34                 79
2046854 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary KG 02 2019   kindergarten 63 3 1 0   26     0   2   56 39                       95.0 63 3 1 0   26     0   2   56 39                 95
2046896 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2019   kindergarten 93 1 5 0   0     0   3   45 57                       102.0 93 1 5 0   0     0   3   45 57                 102
2047072 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2019   kindergarten 92 1 3 0   3     0   3   55 47                       102.0 92 1 3 0   3     0   3   55 47                 102
2047129 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2019   kindergarten 125 2 24 0   0     0   3   61 93                       154.0 125 2 24 0   0     0   3   61 93                 154
2048210 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 John F Kennedy Elementary   Regular School No Elementary KG 02 2019   kindergarten 80 1 8 0   0     0   5   47 47                       94.0 80 1 8 0   0     0   5   47 47                 94
2048812 MA Essex   school 2509450 745   Pentucket 250945000414 7450020 Dr Frederick N Sweetsir   Regular School No Elementary PK 02 2019   kindergarten 56 0 7 0   1     0   4   35 33                       68.0 56 0 7 0   1     0   4   35 33                 68
2048938 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   kindergarten 91 2 7 1   0     0   3   52 52                       104.0 91 2 7 1   0     0   3   52 52                 104
2049032 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2019   kindergarten 94 0 0 0   2     0   1   49 48                       97.0 94 0 0 0   2     0   1   49 48                 97
2040102 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   kindergarten 40 3 3 0   3     0   8   33 24                       57.0 40 3 3 0   3     0   8   33 24                 57
2040106 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   kindergarten 42 6 13 0   0     0   3   38 26                       64.0 42 6 13 0   0     0   3   38 26                 64
2040110 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2019   kindergarten 24 8 33 1   1     1   8   36 40                       76.0 24 8 33 1   1     1   8   36 40                 76
2040114 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2019   kindergarten 83 1 10 0   4     0   6   52 51                       104.0 83 1 10 0   4     0   6   52 51                 104
2040158 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2019   kindergarten 86 3 3 0   1     0   0   42 51                       93.0 86 3 3 0   1     0   0   42 51                 93
2040162 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   kindergarten 56 1 5 0   2     1   2   31 36                       67.0 56 1 5 0   2     1   2   31 36                 67
2040310 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2019   kindergarten 2 20 6 0   3     0   4   21 14                       35.0 2 20 6 0   3     0   4   21 14                 35
2040330 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2019   kindergarten 0 20 15 0   1     0   2   23 15                       38.0 0 20 15 0   1     0   2   23 15                 38
2040361 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2019   kindergarten 0 29 8 0   0     0   1   19 19                       38.0 0 29 8 0   0     0   1   19 19                 38
2042933 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No Elementary KG 03 2019   kindergarten 6 3 64 0   0     0   0   38 35                       73.0 6 3 64 0   0     0   0   38 35                 73
2043297 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Hanscom Primary   Regular School No Elementary PK 03 2019   kindergarten 39 6 12 0   1     0   7   30 35                       65.0 39 6 12 0   1     0   7   30 35                 65
2043767 MA Essex   school 2507260 168   Marblehead 250726001123 1680005 Malcolm L Bell   Regular School No Elementary KG 03 2019   kindergarten 87 2 8 0   3     0   7   53 54                       107.0 87 2 8 0   3     0   7   53 54                 107
2043778 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No Elementary PK 03 2019   kindergarten 61 1 1 0   1     0   5   38 31                       69.0 61 1 1 0   1     0   5   38 31                 69
2043877 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2019   kindergarten 44 0 3 0   0     0   4   30 21                       51.0 44 0 3 0   0     0   4   30 21                 51
2043885 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2019   kindergarten 86 6 16 0   0     0   2   55 55                       110.0 86 6 16 0   0     0   2   55 55                 110
2044101 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No Elementary PK 03 2019   kindergarten 92 4 3 0   7     0   3   50 59                       109.0 92 4 3 0   7     0   3   50 59                 109
2044429 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2019   kindergarten 124 0 6 0   2     0   2   62 72                       134.0 124 0 6 0   2     0   2   62 72                 134
2044783 MA Bristol   school 2509000 218   Norton 250900001450 2180010 L G Nourse Elementary   Regular School No Elementary KG 03 2019   kindergarten 47 3 6 0   1     0   1   27 31                       58.0 47 3 6 0   1     0   1   27 31                 58

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