Data source: Big Local News · About: Big Local

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

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
2042362 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   kindergarten 10 0 0 0   0     0   0   5 5                       10.0 10 0 0 0   0     0   0   5 5                 10
2045165 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   kindergarten 4 5 0 0   0     0   1   4 6                       10.0 4 5 0 0   0     0   1   4 6                 10
2047491 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   kindergarten 8 0 1 0   0     0   1   5 5                       10.0 8 0 1 0   0     0   1   5 5                 10
2049015 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2019   kindergarten 10 0 0 0   0     0   0   5 5                       10.0 10 0 0 0   0     0   0   5 5                 10
2043738 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2019   kindergarten 23 20 42 0   14     0   1   46 54                       100.0 23 20 42 0   14     0   1   46 54                 100
2044200 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2019   kindergarten 67 3 7 0   15     0   8   51 49                       100.0 67 3 7 0   15     0   8   51 49                 100
2044363 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2019   kindergarten 66 5 21 1   3     0   4   55 45                       100.0 66 5 21 1   3     0   4   55 45                 100
2047392 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2019   kindergarten 33 23 34 0   4     0   6   40 60                       100.0 33 23 34 0   4     0   6   40 60                 100
2049272 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   kindergarten 17 19 32 0   27     0   5   45 55                       100.0 17 19 32 0   27     0   5   45 55                 100
2039963 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   kindergarten 77 0 4 0   7     0   13   54 47                       101.0 77 0 4 0   7     0   13   54 47                 101
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
2044142 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2019   kindergarten 84 6 1 1   3     0   6   48 53                       101.0 84 6 1 1   3     0   6   48 53                 101
2044263 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2019   kindergarten 84 1 4 0   6     0   6   53 48                       101.0 84 1 4 0   6     0   6   53 48                 101
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
2042188 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2019   kindergarten 54 12 22 0   2     0   12   43 59                       102.0 54 12 22 0   2     0   12   43 59                 102
2044674 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2019   kindergarten 91 4 4 0   3     0   0   51 51                       102.0 91 4 4 0   3     0   0   51 51                 102
2044902 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No Elementary PK 05 2019   kindergarten 86 2 9 0   2     0   3   55 47                       102.0 86 2 9 0   2     0   3   55 47                 102
2046054 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2019   kindergarten 4 14 83 0   1     0   0   53 49                       102.0 4 14 83 0   1     0   0   53 49                 102
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
2047198 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2019   kindergarten 15 17 58 0   8     0   4   48 54                       102.0 15 17 58 0   8     0   4   48 54                 102
2049128 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2019   kindergarten 93 1 3 0   2     0   3   46 56                       102.0 93 1 3 0   2     0   3   46 56                 102
2041607 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2019   kindergarten 75 2 5 0   18     0   3   56 47                       103.0 75 2 5 0   18     0   3   56 47                 103
2042414 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2019   kindergarten 63 3 14 0   11     0   12   56 47                       103.0 63 3 14 0   11     0   12   56 47                 103
2045940 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No Elementary PK 05 2019   kindergarten 19 11 59 0   6     0   8   58 45                       103.0 19 11 59 0   6     0   8   58 45                 103
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
2047377 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2019   kindergarten 26 19 51 0   5     0   2   53 50                       103.0 26 19 51 0   5     0   2   53 50                 103
2048770 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2019   kindergarten 92 1 3 0   3     0   4   51 52                       103.0 92 1 3 0   3     0   4   51 52                 103
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
2041210 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2019   kindergarten 9 65 24 0   0     0   6   56 48                       104.0 9 65 24 0   0     0   6   56 48                 104
2043710 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   kindergarten 23 21 29 0   26     0   5   56 48                       104.0 23 21 29 0   26     0   5   56 48                 104
2044010 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2019   kindergarten 56 4 40 0   2     0   2   49 55                       104.0 56 4 40 0   2     0   2   49 55                 104
2047705 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   kindergarten 23 30 45 0   1     0   5   61 43                       104.0 23 30 45 0   1     0   5   61 43                 104
2048449 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2019   kindergarten 80 0 9 2   6     0   7   57 47                       104.0 80 0 9 2   6     0   7   57 47                 104
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
2044304 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2019   kindergarten 45 16 36 0   2     0   6   63 42                       105.0 45 16 36 0   2     0   6   63 42                 105
2044343 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   kindergarten 48 10 39 0   0     0   8   59 46                       105.0 48 10 39 0   0     0   8   59 46                 105
2040196 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2019   kindergarten 76 5 1 0   15     0   9   51 55                       106.0 76 5 1 0   15     0   9   51 55                 106
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
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
2047498 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2019   kindergarten 93 0 5 0   4     0   4   60 46                       106.0 93 0 5 0   4     0   4   60 46                 106
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
2043798 MA Middlesex   school 2507320 170   Marlborough 250732001130 1700008 Francis J Kane   Regular School No Elementary KG 04 2019   kindergarten 49 4 48 0   4     0   2   57 50                       107.0 49 4 48 0   4     0   2   57 50                 107
2044205 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2019   kindergarten 64 2 9 0   28     0   4   57 50                       107.0 64 2 9 0   28     0   4   57 50                 107
2046429 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2019   kindergarten 87 3 5 1   9     0   2   55 52                       107.0 87 3 5 1   9     0   2   55 52                 107
2046443 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No Elementary PK 03 2019   kindergarten 102 1 1 0   2     0   1   59 48                       107.0 102 1 1 0   2     0   1   59 48                 107
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
2042151 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   kindergarten 10 13 83 0   2     0   0   48 60                       108.0 10 13 83 0   2     0   0   48 60                 108
2044928 MA Essex   school 2509360 229   Peabody 250936001503 2290010 Thomas Carroll   Regular School No Elementary KG 05 2019   kindergarten 78 2 26 0   2     0   0   50 58                       108.0 78 2 26 0   2     0   0   50 58                 108
2045363 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2019   kindergarten 29 1 69 1   7     0   1   62 46                       108.0 29 1 69 1   7     0   1   62 46                 108
2041345 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   kindergarten 63 4 16 0   15     0   11   51 57                       109.0 63 4 16 0   15     0   11   51 57                 109
2042534 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   kindergarten 103 0 0 0   1     0   5   55 54                       109.0 103 0 0 0   1     0   5   55 54                 109
2043105 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary PK 04 2019   kindergarten 2 2 105 0   0     0   0   62 47                       109.0 2 2 105 0   0     0   0   62 47                 109
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
2046422 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2019   kindergarten 6 1 1 0   0     0   3   5 6                       11.0 6 1 1 0   0     0   3   5 6                 11
2049349 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   kindergarten 6 1 4 0   0     0   0   2 9                       11.0 6 1 4 0   0     0   0   2 9                 11
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
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
2047984 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   kindergarten 89 5 8 0   2     1   5   55 55                       110.0 89 5 8 0   2     1   5   55 55                 110
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
2044337 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2019   kindergarten 21 16 68 0   0     0   6   58 53                       111.0 21 16 68 0   0     0   6   58 53                 111
2045113 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No Elementary KG 05 2019   kindergarten 104 1 1 0   1     0   4   54 57                       111.0 104 1 1 0   1     0   4   54 57                 111
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
2045912 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2019   kindergarten 4 31 72 0   0     0   4   52 59                       111.0 4 31 72 0   0     0   4   52 59                 111
2046339 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 East Taunton Elementary   Regular School No Elementary KG 04 2019   kindergarten 75 20 7 0   0     0   9   52 59                       111.0 75 20 7 0   0     0   9   52 59                 111
2048308 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2019   kindergarten 84 5 9 1   3     0   9   54 57                       111.0 84 5 9 1   3     0   9   54 57                 111
2040232 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No Elementary KG 04 2019   kindergarten 94 4 10 0   2     0   2   59 53                       112.0 94 4 10 0   2     0   2   59 53                 112
2041875 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2019   kindergarten 99 1 6 0   0     0   6   58 54                       112.0 99 1 6 0   0     0   6   58 54                 112
2042194 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2019   kindergarten 44 14 34 0   5     0   15   50 62                       112.0 44 14 34 0   5     0   15   50 62                 112
2042235 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2019   kindergarten 44 10 39 0   4     0   15   58 54                       112.0 44 10 39 0   4     0   15   58 54                 112
2040748 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   kindergarten 20 15 10 0   63     0   5   53 60                       113.0 20 15 10 0   63     0   5   53 60                 113
2043574 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2019   kindergarten 6 10 88 0   8     0   1   64 49                       113.0 6 10 88 0   8     0   1   64 49                 113
2045187 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2019   kindergarten 40 10 7 3   47     0   6   62 51                       113.0 40 10 7 3   47     0   6   62 51                 113
2046345 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Mulcahey Elementary School   Regular School No Elementary PK 04 2019   kindergarten 63 23 21 1   2     0   3   50 63                       113.0 63 23 21 1   2     0   3   50 63                 113
2042834 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 05 2019   kindergarten 69 23 11 0   3     0   8   63 51                       114.0 69 23 11 0   3     0   8   63 51                 114
2046784 MA Plymouth   school 2512420 323   West Bridgewater 251242001663 3230005 Spring Street School   Regular School No Elementary PK KG 2019   kindergarten 97 5 6 0   1     0   5   56 58                       114.0 97 5 6 0   1     0   5   56 58                 114
2045376 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2019   kindergarten 34 1 67 0   9     0   4   52 63                       115.0 34 1 67 0   9     0   4   52 63                 115
2043701 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   kindergarten 41 9 18 0   46     0   2   60 56                       116.0 41 9 18 0   46     0   2   60 56                 116
2046625 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2019   kindergarten 65 4 22 0   12     0   13   61 55                       116.0 65 4 22 0   12     0   13   61 55                 116
2040558 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2019   kindergarten 3 63 46 1   3     0   1   54 63                       117.0 3 63 46 1   3     0   1   54 63                 117
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
2047730 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   kindergarten 18 55 35 2   2     0   5   55 62                       117.0 18 55 35 2   2     0   5   55 62                 117
2048400 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2019   kindergarten 107 0 1 0   1     0   9   63 55                       118.0 107 0 1 0   1     0   9   63 55                 118
2048328 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary PK 04 2019   kindergarten 105 0 6 0   3     0   5   68 51                       119.0 105 0 6 0   3     0   5   68 51                 119
2044179 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2019   kindergarten 10 0 2 0   0     0   0   9 3                       12.0 10 0 2 0   0     0   0   9 3                 12
2046489 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   kindergarten 12 0 0 0   0     0   0   7 5                       12.0 12 0 0 0   0     0   0   7 5                 12
2047205 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2019   kindergarten 5 0 3 0   3     0   1   5 7                       12.0 5 0 3 0   3     0   1   5 7                 12
2048665 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2019   kindergarten 12 0 0 0   0     0   0   5 7                       12.0 12 0 0 0   0     0   0   5 7                 12
2048917 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2019   kindergarten 10 0 2 0   0     0   0   7 5                       12.0 10 0 2 0   0     0   0   7 5                 12
2043071 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2019   kindergarten 6 5 103 0   6     0   0   61 57                       120.0 6 5 103 0   6     0   0   61 57                 120
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
2039826 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   kindergarten 113 0 2 0   1     0   5   60 61                       121.0 113 0 2 0   1     0   5   60 61                 121
2042420 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   kindergarten 17 5 93 0   0     0   6   53 68                       121.0 17 5 93 0   0     0   6   53 68                 121
2045198 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2019   kindergarten 33 18 12 0   58     0   1   48 74                       122.0 33 18 12 0   58     0   1   48 74                 122
2047621 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   kindergarten 10 14 93 0   2     2   1   52 70                       122.0 10 14 93 0   2     2   1   52 70                 122
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
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
2042321 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2019   kindergarten 41 7 66 0   4     0   7   74 51                       125.0 41 7 66 0   4     0   7   74 51                 125
2043048 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No Elementary PK KG 2019   kindergarten 2 6 112 0   4     0   1   62 63                       125.0 2 6 112 0   4     0   1   62 63                 125
2042315 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2019   kindergarten 28 5 84 0   3     0   8   68 60                       128.0 28 5 84 0   3     0   8   68 60                 128

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