enrollments

Data source: Big Local News · About: Big Local

982 rows where grade = "grade_2", state = "MA" and year = 2017 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 982 ✖

grade ✖

  • grade_2 · 982 ✖
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
1122188 1122188 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_2 159 5 15 4   32     0   4   104 115                       219 159 5 15 4   32     0   4   104 115                 219
1122261 1122261 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   grade_2 67 2 11 0   6     0   2   45 43                       88 67 2 11 0   6     0   2   45 43                 88
1122265 1122265 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary KG 02 2017   grade_2 76 2 10 0   3     0   2   49 44                       93 76 2 10 0   3     0   2   49 44                 93
1122333 1122333 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   grade_2 137 14 10 0   35     0   10   103 103                       206 137 14 10 0   35     0   10   103 103                 206
1122555 1122555 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 02 2017   grade_2 1 34 11 1   1     0   5   29 24                       53 1 34 11 1   1     0   5   29 24                 53
1122614 1122614 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 02 2017   grade_2 4 37 20 0   1     0   3   35 30                       65 4 37 20 0   1     0   3   35 30                 65
1122619 1122619 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2017   grade_2 0 23 24 0   0     1   2   25 25                       50 0 23 24 0   0     1   2   25 25                 50
1123034 1123034 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 02 2017   grade_2 17 11 14 0   6     0   0   22 26                       48 17 11 14 0   6     0   0   22 26                 48
1123487 1123487 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2017   grade_2 78 0 1 0   6     0   3   52 36                       88 78 0 1 0   6     0   3   52 36                 88
1123562 1123562 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2017   grade_2 64 2 7 0   2     0   4   36 43                       79 64 2 7 0   2     0   4   36 43                 79
1124130 1124130 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2017   grade_2 44 6 40 0   0     0   0   50 40                       90 44 6 40 0   0     0   0   50 40                 90
1124242 1124242 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2017   grade_2 110 5 1 0   5     0   6   64 63                       127 110 5 1 0   5     0   6   64 63                 127
1124481 1124481 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2017   grade_2 156 0 2 0   2     0   16   94 82                       176 156 0 2 0   2     0   16   94 82                 176
1124495 1124495 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2017   grade_2 131 5 3 1   0     1   4   74 71                       145 131 5 3 1   0     1   4   74 71                 145
1124553 1124553 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2017   grade_2 144 4 19 0   10     0   5   109 73                       182 144 4 19 0   10     0   5   109 73                 182
1124571 1124571 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2017   grade_2 78 7 0 0   3     1   1   56 34                       90 78 7 0 0   3     1   1   56 34                 90
1124576 1124576 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2017   grade_2 89 3 6 0   1     0   6   49 56                       105 89 3 6 0   1     0   6   49 56                 105
1124581 1124581 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2017   grade_2 65 9 4 0   2     0   0   38 42                       80 65 9 4 0   2     0   0   38 42                 80
1124962 1124962 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   grade_2 49 5 13 0   7     0   5   47 32                       79 49 5 13 0   7     0   5   47 32                 79
1125331 1125331 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2017   grade_2 114 0 1 0   2     0   2   60 59                       119 114 0 1 0   2     0   2   60 59                 119
1125397 1125397 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Greenleaf   Regular School No Elementary KG 02 2017   grade_2 56 2 25 0   1     0   3   42 45                       87 56 2 25 0   1     0   3   42 45                 87
1125436 1125436 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2017   grade_2 38 0 7 0   1     0   1   30 17                       47 38 0 7 0   1     0   1   30 17                 47
1125528 1125528 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2017   grade_2 174 3 9 0   24     0   9   106 113                       219 174 3 9 0   24     0   9   106 113                 219
1125542 1125542 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 02 2017   grade_2 10 1 22 0   0     0   0   13 20                       33 10 1 22 0   0     0   0   13 20                 33
1125739 1125739 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2017   grade_2 133 2 3 1   0     0   0   67 72                       139 133 2 3 1   0     0   0   67 72                 139
1125799 1125799 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2017   grade_2 4 2 88 0   2     0   0   47 49                       96 4 2 88 0   2     0   0   47 49                 96
1125919 1125919 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No Elementary PK 02 2017   grade_2 79 5 7 2   3     0   1   47 50                       97 79 5 7 2   3     0   1   47 50                 97
1126095 1126095 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2017   grade_2 113 2 3 1   11     0   1   74 57                       131 113 2 3 1   11     0   1   74 57                 131
1126332 1126332 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2017   grade_2 100 0 8 0   0     1   7   57 59                       116 100 0 8 0   0     1   7   57 59                 116
1126602 1126602 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   grade_2 195 10 3 1   15     0   9   119 114                       233 195 10 3 1   15     0   9   119 114                 233
1126734 1126734 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   grade_2 67 1 7 9   1     0   10   44 51                       95 67 1 7 9   1     0   10   44 51                 95
1126989 1126989 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No Elementary KG 02 2017   grade_2 73 0 0 0   5     0   0   36 42                       78 73 0 0 0   5     0   0   36 42                 78
1126999 1126999 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2017   grade_2 84 6 38 5   5     1   10   86 63                       149 84 6 38 5   5     1   10   86 63                 149
1127003 1127003 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2017   grade_2 110 6 45 2   1     0   8   89 83                       172 110 6 45 2   1     0   8   89 83                 172
1127559 1127559 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2017   grade_2 97 0 6 0   2     0   1   63 43                       106 97 0 6 0   2     0   1   63 43                 106
1127932 1127932 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No Elementary PK 02 2017   grade_2 62 1 5 0   0     0   3   38 33                       71 62 1 5 0   0     0   3   38 33                 71
1128693 1128693 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   grade_2 169 3 6 0   2     0   1   94 87                       181 169 3 6 0   2     0   1   94 87                 181
1129575 1129575 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2017   grade_2 96 1 2 0   3     0   6   56 52                       108 96 1 2 0   3     0   6   56 52                 108
1129625 1129625 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No Elementary KG 02 2017   grade_2 74 1 0 1   0     0   1   40 37                       77 74 1 0 1   0     0   1   40 37                 77
1129630 1129630 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Mark G Hoyle Elementary   Regular School No Elementary PK 02 2017   grade_2 64 0 2 1   2     0   6   36 39                       75 64 0 2 1   2     0   6   36 39                 75
1129715 1129715 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2017   grade_2 122 8 10 0   6     0   0   74 72                       146 122 8 10 0   6     0   0   74 72                 146
1129719 1129719 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2017   grade_2 97 3 2 0   1     0   3   51 55                       106 97 3 2 0   1     0   3   51 55                 106
1129788 1129788 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No Elementary PK 02 2017   grade_2 131 2 1 0   1     0   3   71 67                       138 131 2 1 0   1     0   3   71 67                 138
1129972 1129972 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   grade_2 161 17 14 2   3     0   23   118 102                       220 161 17 14 2   3     0   23   118 102                 220
1130283 1130283 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2017   grade_2 94 1 2 0   24     0   7   68 60                       128 94 1 2 0   24     0   7   68 60                 128
1130287 1130287 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No Elementary KG 02 2017   grade_2 57 1 3 0   26     0   5   36 56                       92 57 1 3 0   26     0   5   36 56                 92
1130295 1130295 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary KG 02 2017   grade_2 60 2 1 0   51     0   7   62 59                       121 60 2 1 0   51     0   7   62 59                 121
1130346 1130346 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2017   grade_2 108 0 3 1   1     0   7   58 62                       120 108 0 3 1   1     0   7   58 62                 120
1130576 1130576 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2017   grade_2 76 0 5 0   3     0   1   56 29                       85 76 0 5 0   3     0   1   56 29                 85
1130644 1130644 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2017   grade_2 120 5 22 0   0     0   4   91 60                       151 120 5 22 0   0     0   4   91 60                 151
1131875 1131875 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 John F Kennedy Elementary   Regular School No Elementary KG 02 2017   grade_2 69 2 6 0   1     0   8   47 39                       86 69 2 6 0   1     0   8   47 39                 86
1132571 1132571 MA Essex   school 2509450 745   Pentucket 250945000414 7450020 Dr Frederick N Sweetsir   Regular School No Elementary PK 02 2017   grade_2 44 0 5 0   1     0   3   28 25                       53 44 0 5 0   1     0   3   28 25                 53
1132723 1132723 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   grade_2 85 1 6 0   1     0   4   47 50                       97 85 1 6 0   1     0   4   47 50                 97
1132839 1132839 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2017   grade_2 85 3 2 2   1     0   3   43 53                       96 85 3 2 2   1     0   3   43 53                 96
1132946 1132946 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No Elementary PK 02 2017   grade_2 98 0 5 0   2     0   2   58 49                       107 98 0 5 0   2     0   2   58 49                 107
1133169 1133169 MA Hampden   school 2500557 3510   Springfield Preparatory Charter 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 02 2017   grade_2 4 12 35 0   0     0   4   29 26                       55 4 12 35 0   0     0   4   29 26                 55
1122301 1122301 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   grade_2 55 5 2 0   0     0   5   37 30                       67 55 5 2 0   0     0   5   37 30                 67
1122306 1122306 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   grade_2 64 5 8 0   1     0   1   39 40                       79 64 5 8 0   1     0   1   39 40                 79
1122311 1122311 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2017   grade_2 37 16 23 0   3     0   11   50 40                       90 37 16 23 0   3     0   11   50 40                 90
1122316 1122316 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2017   grade_2 110 3 4 1   0     0   4   58 64                       122 110 3 4 1   0     0   4   58 64                 122
1122357 1122357 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2017   grade_2 138 3 12 1   1     0   6   83 78                       161 138 3 12 1   1     0   6   83 78                 161
1122372 1122372 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No Elementary KG 03 2017   grade_2 89 0 2 0   2     0   1   47 47                       94 89 0 2 0   2     0   1   47 47                 94
1122377 1122377 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2017   grade_2 79 2 3 0   2     0   3   38 51                       89 79 2 3 0   2     0   3   38 51                 89
1122578 1122578 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2017   grade_2 1 17 16 0   0     0   1   22 13                       35 1 17 16 0   0     0   1   22 13                 35
1122635 1122635 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 03 2017   grade_2 39 29 38 0   4     0   1   54 57                       111 39 29 38 0   4     0   1   54 57                 111
1124220 1124220 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 03 2017   grade_2 102 5 37 0   1     0   2   75 72                       147 102 5 37 0   1     0   2   75 72                 147
1125235 1125235 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No Elementary PK 03 2017   grade_2 40 0 1 1   0     0   2   15 29                       44 40 0 1 1   0     0   2   15 29                 44
1125498 1125498 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 03 2017   grade_2 52 15 14 0   2     0   4   46 41                       87 52 15 14 0   2     0   4   46 41                 87
1125616 1125616 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No Elementary KG 03 2017   grade_2 6 0 60 0   1     1   1   41 28                       69 6 0 60 0   1     1   1   41 28                 69
1125650 1125650 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2017   grade_2 195 2 7 1   36     1   8   136 114                       250 195 2 7 1   36     1   8   136 114                 250
1126072 1126072 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Hanscom Primary   Regular School No Elementary PK 03 2017   grade_2 36 5 8 0   0     0   4   30 23                       53 36 5 8 0   0     0   4   30 23                 53
1126314 1126314 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No Elementary 02 03 2017   grade_2 132 2 16 1   1     0   4   68 88                       156 132 2 16 1   1     0   4   68 88                 156
1126619 1126619 MA Essex   school 2507260 168   Marblehead 250726001123 1680005 Malcolm L Bell   Regular School No Elementary KG 03 2017   grade_2 60 3 9 0   3     0   3   49 29                       78 60 3 9 0   3     0   3   49 29                 78
1126622 1126622 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 02 03 2017   grade_2 58 2 9 0   3     0   7   41 38                       79 58 2 9 0   3     0   7   41 38                 79
1126635 1126635 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No Elementary PK 03 2017   grade_2 78 0 2 0   0     0   1   46 35                       81 78 0 2 0   0     0   1   46 35                 81
1126752 1126752 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2017   grade_2 46 0 3 0   2     0   1   25 27                       52 46 0 3 0   2     0   1   25 27                 52
1126762 1126762 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2017   grade_2 77 3 11 0   3     0   9   53 50                       103 77 3 11 0   3     0   9   53 50                 103
1126783 1126783 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2017   grade_2 148 2 14 3   5     0   2   102 72                       174 148 2 14 3   5     0   2   102 72                 174
1127023 1127023 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No Elementary PK 03 2017   grade_2 115 7 6 0   6     0   9   75 68                       143 115 7 6 0   6     0   9   75 68                 143
1127403 1127403 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2017   grade_2 126 1 3 1   2     0   1   61 73                       134 126 1 3 1   2     0   1   61 73                 134
1127826 1127826 MA Bristol   school 2509000 218   Norton 250900001450 2180010 L G Nourse Elementary   Regular School No Elementary PK 03 2017   grade_2 62 2 8 0   2     0   1   36 39                       75 62 2 8 0   2     0   1   36 39                 75
1127831 1127831 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary KG 03 2017   grade_2 86 1 1 3   1     0   4   47 49                       96 86 1 1 3   1     0   4   47 49                 96
1128184 1128184 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No Elementary PK 03 2017   grade_2 68 2 3 0   7     0   3   44 39                       83 68 2 3 0   7     0   3   44 39                 83
1129038 1129038 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2017   grade_2 87 1 5 0   25     0   9   65 62                       127 87 1 5 0   25     0   9   65 62                 127
1129756 1129756 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Steward Elementary   Regular School No Elementary PK 03 2017   grade_2 81 0 1 1   2     0   0   43 42                       85 81 0 1 1   2     0   0   43 42                 85
1129956 1129956 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Stanley M Koziol Elementary School   Regular School No Elementary PK 03 2017   grade_2 69 1 10 0   1     0   11   44 48                       92 69 1 10 0   1     0   11   44 48                 92
1130142 1130142 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2017   grade_2 47 3 4 0   44     0   0   44 54                       98 47 3 4 0   44     0   0   44 54                 98
1130147 1130147 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No Elementary KG 03 2017   grade_2 50 1 3 2   32     0   3   56 35                       91 50 1 3 2   32     0   3   56 35                 91
1130153 1130153 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2017   grade_2 45 0 10 0   38     0   2   52 43                       95 45 0 10 0   38     0   2   52 43                 95
1130185 1130185 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2017   grade_2 70 4 4 0   3     0   0   38 43                       81 70 4 4 0   3     0   0   38 43                 81
1130322 1130322 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Country   Regular School No Elementary PK 03 2017   grade_2 41 6 9 0   15     0   6   34 43                       77 41 6 9 0   15     0   6   34 43                 77
1130331 1130331 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2017   grade_2 59 3 4 0   9     0   1   39 37                       76 59 3 4 0   9     0   1   39 37                 76
1130550 1130550 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2017   grade_2 88 0 8 0   5     0   5   58 48                       106 88 0 8 0   5     0   5   58 48                 106
1130554 1130554 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2017   grade_2 92 1 10 0   5     0   4   57 55                       112 92 1 10 0   5     0   4   57 55                 112
1131081 1131081 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   grade_2 115 0 4 1   4     0   5   62 67                       129 115 0 4 1   4     0   5   62 67                 129
1131197 1131197 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2017   grade_2 47 3 14 1   3     1   5   41 33                       74 47 3 14 1   3     1   5   41 33                 74
1131901 1131901 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   grade_2 178 16 8 0   2     0   9   114 99                       213 178 16 8 0   2     0   9   114 99                 213
1131982 1131982 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2017   grade_2 70 6 8 1   2     0   8   49 46                       95 70 6 8 1   2     0   8   49 46                 95
1131988 1131988 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   grade_2 31 2 10 4   0     0   6   30 23                       53 31 2 10 4   0     0   6   30 23                 53
1131993 1131993 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   grade_2 83 6 2 3   1     0   11   54 52                       106 83 6 2 3   1     0   11   54 52                 106

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