enrollments

Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 6,731 ✖
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
738571 738571 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2015   grade_2 58 0 6 0   3     0   1   36 32                       68 58 0 6 0   3     0   1   36 32                 68
738617 738617 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2015   grade_2 51 0 3 0   1     1   0   29 27                       56 51 0 3 0   1     1   0   29 27                 56
738639 738639 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   grade_2 77 0 1 0   3     0   2   44 39                       83 77 0 1 0   3     0   2   44 39                 83
738645 738645 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2015   grade_2 71 0 1 0   1     0   1   40 34                       74 71 0 1 0   1     0   1   40 34                 74
738657 738657 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2015   grade_2 76 0 3 0   3     0   7   45 44                       89 76 0 3 0   3     0   7   45 44                 89
738687 738687 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2015   grade_2 27 0 0 0   0     0   0   11 16                       27 27 0 0 0   0     0   0   11 16                 27
738698 738698 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2015   grade_2 183 0 12 0   7     0   8   109 101                       210 183 0 12 0   7     0   8   109 101                 210
738735 738735 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_2 2 0 69 0   0     0   1   37 35                       72 2 0 69 0   0     0   1   37 35                 72
738744 738744 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_2 5 0 37 0   0     0   0   21 21                       42 5 0 37 0   0     0   0   21 21                 42
738784 738784 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_2 73 0 6 0   2     0   2   51 32                       83 73 0 6 0   2     0   2   51 32                 83
738818 738818 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No 1 KG 04 2015   grade_2 56 0 5 0   3     0   2   32 34                       66 56 0 5 0   3     0   2   32 34                 66
738839 738839 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2015   grade_2 65 0 0 0   0     0   0   31 34                       65 65 0 0 0   0     0   0   31 34                 65
738853 738853 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2015   grade_2 55 0 4 0   3     0   0   25 37                       62 55 0 4 0   3     0   0   25 37                 62
738860 738860 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No 1 PK 05 2015   grade_2 59 0 1 0   2     0   1   32 31                       63 59 0 1 0   2     0   1   32 31                 63
738882 738882 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_2 25 0 0 0   0     0   3   14 14                       28 25 0 0 0   0     0   3   14 14                 28
738938 738938 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_2 1 0 74 0   0     0   0   39 36                       75 1 0 74 0   0     0   0   39 36                 75
738962 738962 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2015   grade_2 5 0 75 0   3     0   2   38 47                       85 5 0 75 0   3     0   2   38 47                 85
739029 739029 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   grade_2 34 0 3 0   0     0   2   12 27                       39 34 0 3 0   0     0   2   12 27                 39
739057 739057 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2015   grade_2 42 0 2 0   3     0   2   31 18                       49 42 0 2 0   3     0   2   31 18                 49
739115 739115 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   grade_2 11 0 2 0   0     0   1   6 8                       14 11 0 2 0   0     0   1   6 8                 14
739210 739210 MA Hampden   school 2506990 159   Longmeadow 250699001017 1590010 Center   Regular School No 1 PK 05 2015   grade_2 52 0 1 0   3     0   1   31 26                       57 52 0 1 0   3     0   1   31 26                 57
739243 739243 MA Middlesex   school 2507020 160   Lowell 250702000477 1600010 Joseph McAvinnue   Regular School No 1 PK 04 2015   grade_2 13 0 57 0   10     0   5   44 41                       85 13 0 57 0   10     0   5   44 41                 85
739474 739474 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No 1 KG 05 2015   grade_2 16 0 3 0   2     0   3   15 9                       24 16 0 3 0   2     0   3   15 9                 24
739640 739640 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No 1 PK 03 2015   grade_2 89 0 1 0   1     0   1   52 40                       92 89 0 1 0   1     0   1   52 40                 92
739684 739684 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2015   grade_2 35 0 1 0   0     0   1   26 11                       37 35 0 1 0   0     0   1   26 11                 37
739703 739703 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No 1 KG 05 2015   grade_2 86 0 0 0   0     0   3   46 43                       89 86 0 0 0   0     0   3   46 43                 89
739710 739710 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No 1 PK 05 2015   grade_2 62 0 3 3   1     0   2   29 42                       71 62 0 3 3   1     0   2   29 42                 71
739835 739835 MA Middlesex   school 2507620 178   Melrose 250762001190 1780017 Herbert Clark Hoover   Regular School No 1 KG 05 2015   grade_2 37 0 2 0   3     0   3   27 18                       45 37 0 2 0   3     0   3   27 18                 45
739847 739847 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No 1 KG 05 2015   grade_2 39 0 3 0   1     0   1   22 22                       44 39 0 3 0   1     0   1   22 22                 44
739937 739937 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No 1 KG 02 2015   grade_2 72 0 2 1   4     0   2   47 34                       81 72 0 2 1   4     0   2   47 34                 81
740027 740027 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No 1 PK 04 2015   grade_2 59 0 0 0   3     0   0   32 30                       62 59 0 0 0   3     0   0   32 30                 62
740042 740042 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   grade_2 20 0 0 0   0     0   0   8 12                       20 20 0 0 0   0     0   0   8 12                 20
740074 740074 MA Middlesex   school 2508340 198   Natick 250834001298 1980031 Johnson   Regular School No 1 KG 04 2015   grade_2 44 0 2 0   0     0   6   24 28                       52 44 0 2 0   0     0   6   24 28                 52
740114 740114 MA Norfolk   school 2508370 199   Needham 250837001313 1990035 Hillside Elementary   Regular School No 1 KG 05 2015   grade_2 62 0 7 0   3     0   3   41 34                       75 62 0 7 0   3     0   3   41 34                 75
740256 740256 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No 1 KG 05 2015   grade_2 26 0 7 0   0     0   5   20 18                       38 26 0 7 0   0     0   5   20 18                 38
740332 740332 MA Middlesex   school 2508610 207   Newton 250861001362 2070040 Countryside   Regular School No 1 KG 05 2015   grade_2 43 0 5 0   12     0   7   28 39                       67 43 0 5 0   12     0   7   28 39                 67
740350 740350 MA Middlesex   school 2508610 207   Newton 250861001367 2070075 Horace Mann   Regular School No 1 KG 05 2015   grade_2 47 0 9 0   13     0   6   38 37                       75 47 0 9 0   13     0   6   38 37                 75
740362 740362 MA Middlesex   school 2508610 207   Newton 250861001377 2070100 Peirce   Regular School No 1 KG 05 2015   grade_2 37 0 0 0   8     0   1   24 22                       46 37 0 0 0   8     0   1   24 22                 46
740429 740429 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_2 41 0 2 0   0     1   2   20 26                       46 41 0 2 0   0     1   2   20 26                 46
740460 740460 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No 1 PK 05 2015   grade_2 29 0 5 0   3     0   3   18 22                       40 29 0 5 0   3     0   3   18 22                 40
740593 740593 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No 1 PK 05 2015   grade_2 25 0 4 0   4     1   1   19 16                       35 25 0 4 0   4     1   1   19 16                 35
740618 740618 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2015   grade_2 39 0 1 0   0     0   3   22 21                       43 39 0 1 0   0     0   3   22 21                 43
740632 740632 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 E Ethel Little School   Regular School No 1 PK 05 2015   grade_2 35 0 1 0   1     0   2   21 18                       39 35 0 1 0   1     0   2   21 18                 39
740638 740638 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 L D Batchelder   Regular School No 1 KG 05 2015   grade_2 81 0 2 0   3     0   1   38 49                       87 81 0 2 0   3     0   1   38 49                 87
740683 740683 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2015   grade_2 77 0 0 0   2     0   1   46 34                       80 77 0 0 0   2     0   1   46 34                 80
740746 740746 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No 1 PK 02 2015   grade_2 69 0 9 1   1     0   8   51 37                       88 69 0 9 1   1     0   8   51 37                 88
740796 740796 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No 1 KG 05 2015   grade_2 37 0 0 0   0     0   1   16 22                       38 37 0 0 0   0     0   1   16 22                 38
740836 740836 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No 1 PK 05 2015   grade_2 30 0 2 0   1     0   0   21 12                       33 30 0 2 0   1     0   0   21 12                 33
740849 740849 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No 1 KG 06 2015   grade_2 15 0 2 0   1     0   2   7 13                       20 15 0 2 0   1     0   2   7 13                 20
740863 740863 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2015   grade_2 71 0 0 0   0     0   0   40 31                       71 71 0 0 0   0     0   0   40 31                 71
740871 740871 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2015   grade_2 71 0 2 0   2     0   0   36 39                       75 71 0 2 0   2     0   0   36 39                 75
740885 740885 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   grade_2 16 0 2 0   0     0   1   11 8                       19 16 0 2 0   0     0   1   11 8                 19
740985 740985 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2015   grade_2 91 0 1 0   0     0   1   51 42                       93 91 0 1 0   0     0   1   51 42                 93
740991 740991 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Manomet Elementary   Regular School No 1 KG 05 2015   grade_2 47 0 1 0   0     0   3   24 27                       51 47 0 1 0   0     0   3   24 27                 51
741030 741030 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2015   grade_2 28 0 1 0   0     0   0   15 14                       29 28 0 1 0   0     0   0   15 14                 29
741054 741054 MA Norfolk   school 2509870 243   Quincy 250987001568 2430025 Charles A Bernazzani Elementary   Regular School No 1 KG 05 2015   grade_2 38 0 2 0   12     0   4   28 28                       56 38 0 2 0   12     0   4   28 28                 56
741173 741173 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No 1 KG 05 2015   grade_2 50 0 1 0   2     0   0   26 27                       53 50 0 1 0   2     0   0   26 27                 53
741179 741179 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No 1 KG 05 2015   grade_2 52 0 0 0   1     0   4   31 26                       57 52 0 0 0   1     0   4   31 26                 57
741197 741197 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No 1 KG 05 2015   grade_2 39 0 1 0   1     0   1   22 20                       42 39 0 1 0   1     0   1   22 20                 42
741312 741312 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport Elementary   Regular School No 1 PK 05 2015   grade_2 61 0 1 0   2     0   2   27 39                       66 61 0 1 0   2     0   2   27 39                 66
741345 741345 MA Essex   school 2510380 258   Salem 251038001656 2580015 Carlton   Regular School No 1 KG 05 2015   grade_2 13 0 4 0   0     0   3   10 10                       20 13 0 4 0   0     0   3   10 10                 20
741502 741502 MA Bristol   school 2510590 265   Seekonk 251059001696 2650015 Mildred Aitken School   Regular School No 1 PK 05 2015   grade_2 65 0 3 0   0     0   3   41 30                       71 65 0 3 0   0     0   3   41 30                 71
741611 741611 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No 1 KG 06 2015   grade_2 32 0 6 0   5     0   0   19 24                       43 32 0 6 0   5     0   0   19 24                 43
741690 741690 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No 1 PK 06 2015   grade_2 66 0 10 0   2     1   3   45 37                       82 66 0 10 0   2     1   3   45 37                 82
741706 741706 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No 1 01 05 2015   grade_2 79 0 15 0   1     0   0   53 42                       95 79 0 15 0   1     0   0   53 42                 95
741713 741713 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No 1 01 05 2015   grade_2 71 0 17 1   2     0   1   47 45                       92 71 0 17 1   2     0   1   47 45                 92
741727 741727 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No 1 02 04 2015   grade_2 113 0 20 1   1     0   11   57 89                       146 113 0 20 1   1     0   11   57 89                 146
742037 742037 MA Middlesex   school 2511220 284   Stoneham 251122001851 2840005 Colonial Park   Regular School No 1 PK 04 2015   grade_2 32 0 2 0   1     0   1   13 23                       36 32 0 2 0   1     0   1   13 23                 36
742116 742116 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Israel Loring School   Regular School No 1 KG 05 2015   grade_2 58 0 4 1   7     2   3   39 36                       75 58 0 4 1   7     2   3   39 36                 75
742139 742139 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2015   grade_2 14 0 2 0   3     0   3   15 7                       22 14 0 2 0   3     0   3   15 7                 22
742147 742147 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No 1 PK 02 2015   grade_2 96 0 2 0   1     0   7   49 57                       106 96 0 2 0   1     0   7   49 57                 106
742160 742160 MA Essex   school 2511430 291   Swampscott 251143001883 2910005 Clarke   Regular School No 1 KG 04 2015   grade_2 35 0 2 1   1     0   2   23 18                       41 35 0 2 1   1     0   2   23 18                 41
742188 742188 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No 1 KG 02 2015   grade_2 101 0 1 0   1     0   0   58 45                       103 101 0 1 0   1     0   0   58 45                 103
742264 742264 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No 1 KG 02 2015   grade_2 109 0 4 0   6     0   2   54 67                       121 109 0 4 0   6     0   2   54 67                 121
742320 742320 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No 1 PK 02 2015   grade_2 124 0 6 1   2     0   3   68 68                       136 124 0 6 1   2     0   3   68 68                 136
742336 742336 MA Middlesex   school 2511910 305   Wakefield 251191001941 3050005 Dolbeare   Regular School No 1 KG 04 2015   grade_2 68 0 6 0   2     1   6   41 42                       83 68 0 6 0   2     1   6   41 42                 83
742341 742341 MA Middlesex   school 2511910 305   Wakefield 251191001943 3050015 Woodville School   Regular School No 1 KG 04 2015   grade_2 70 0 9 0   3     0   2   44 40                       84 70 0 9 0   3     0   2   44 40                 84
742346 742346 MA Middlesex   school 2511910 305   Wakefield 251191001944 3050020 Greenwood   Regular School No 1 KG 04 2015   grade_2 34 0 2 0   4     0   0   21 19                       40 34 0 2 0   4     0   0   21 19                 40
742350 742350 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No 1 01 04 2015   grade_2 40 0 2 0   0     0   1   22 21                       43 40 0 2 0   0     0   1   22 21                 43
742599 742599 MA Norfolk   school 2512270 317   Wellesley 251227002021 3170050 Ernest F Upham   Regular School No 1 KG 05 2015   grade_2 30 0 0 0   2     0   3   18 17                       35 30 0 0 0   2     0   3   18 17                 35
742614 742614 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No 1 PK 05 2015   grade_2 27 0 3 0   0     0   0   11 19                       30 27 0 3 0   0     0   0   11 19                 30
742624 742624 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No 1 KG 03 2015   grade_2 50 0 4 0   18     0   3   39 36                       75 50 0 4 0   18     0   3   39 36                 75
742644 742644 MA Worcester   school 2512390 322   West Boylston 251239002034 3220005 Major Edwards Elementary   Regular School No 1 PK 05 2015   grade_2 54 0 7 0   1     0   5   28 39                       67 54 0 7 0   1     0   5   28 39                 67
742673 742673 MA Hampden   school 2512630 325   Westfield 251263002064 3250015 Franklin Ave   Regular School No 1 KG 05 2015   grade_2 23 0 9 0   3     0   1   21 15                       36 23 0 9 0   3     0   1   21 15                 36
742679 742679 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2015   grade_2 31 0 6 0   1     0   1   15 24                       39 31 0 6 0   1     0   1   15 24                 39
742691 742691 MA Hampden   school 2512630 325   Westfield 251263002605 3250033 Munger Hill   Regular School No 1 KG 05 2015   grade_2 50 0 5 0   1     1   1   36 22                       58 50 0 5 0   1     1   1   36 22                 58
742703 742703 MA Hampden   school 2512630 325   Westfield 251263002071 3250040 Southampton Road   Regular School No 1 KG 05 2015   grade_2 59 0 12 0   0     0   1   28 44                       72 59 0 12 0   0     0   1   28 44                 72
742737 742737 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No 1 KG 02 2015   grade_2 104 0 0 0   11     0   3   64 54                       118 104 0 0 0   11     0   3   64 54                 118
742760 742760 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No 1 PK 06 2015   grade_2 16 0 1 0   0     0   0   9 8                       17 16 0 1 0   0     0   0   9 8                 17
742788 742788 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No 1 02 05 2015   grade_2 115 0 4 0   1     0   7   76 51                       127 115 0 4 0   1     0   7   76 51                 127
742819 742819 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2015   grade_2 17 0 11 0   0     0   3   14 17                       31 17 0 11 0   0     0   3   14 17                 31
742824 742824 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2015   grade_2 40 0 3 0   0     0   2   22 23                       45 40 0 3 0   0     0   2   22 23                 45
742840 742840 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Deerfield School   Regular School No 1 KG 05 2015   grade_2 40 0 2 0   4     0   0   25 21                       46 40 0 2 0   4     0   0   25 21                 46
742846 742846 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Downey   Regular School No 1 KG 05 2015   grade_2 23 0 3 0   4     0   0   19 11                       30 23 0 3 0   4     0   0   19 11                 30
742852 742852 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Paul Hanlon   Regular School No 1 KG 05 2015   grade_2 18 0 0 0   3     0   1   8 14                       22 18 0 0 0   3     0   1   8 14                 22
742864 742864 MA Norfolk   school 2512810 335   Westwood 251281002101 3350025 William E Sheehan   Regular School No 1 KG 05 2015   grade_2 54 0 3 0   6     0   4   35 32                       67 54 0 3 0   6     0   4   35 32                 67
742929 742929 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2015   grade_2 20 0 1 0   0     0   0   9 12                       21 20 0 1 0   0     0   0   9 12                 21
742937 742937 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg Schools   Regular School No 1 PK 06 2015   grade_2 17 0 0 0   0     0   0   7 10                       17 17 0 0 0   0     0   0   7 10                 17
742958 742958 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No 1 01 03 2015   grade_2 98 0 9 0   7     0   3   57 60                       117 98 0 9 0   7     0   3   57 60                 117
742988 742988 MA Middlesex   school 2513110 344   Winchester 251311002165 3440005 Lincoln Elementary   Regular School No 1 KG 05 2015   grade_2 40 0 0 0   4     0   4   19 29                       48 40 0 0 0   4     0   4   19 29                 48

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