enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,038 ✖
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
735927 735927 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2015   grade_6 173 1 4 1   9     0   3   90 101                       191 173 1 4 1   9     0   3   90 101                 191
737184 737184 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 39 1 2 0   0     0   1   18 25                       43 39 1 2 0   0     0   1   18 25                 43
737616 737616 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_6 101 9 27 0   2     0   3   72 70                       142 101 9 27 0   2     0   3   72 70                 142
737781 737781 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2015   grade_6 129 2 2 0   0     1   2   67 69                       136 129 2 2 0   0     1   2   67 69                 136
738170 738170 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_6 58 13 76 0   7     0   16   70 100                       170 58 13 76 0   7     0   16   70 100                 170
738180 738180 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_6 33 7 65 0   3     0   13   63 58                       121 33 7 65 0   3     0   13   63 58                 121
738190 738190 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   grade_6 38 6 41 0   3     0   6   43 51                       94 38 6 41 0   3     0   6   43 51                 94
738361 738361 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 06 08 2015   grade_6 140 2 22 0   2     0   9   89 86                       175 140 2 22 0   2     0   9   89 86                 175
738437 738437 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_6 88 3 4 0   4     0   1   50 50                       100 88 3 4 0   4     0   1   50 50                 100
738442 738442 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2015   grade_6 79 1 4 0   21     0   9   60 54                       114 79 1 4 0   21     0   9   60 54                 114
738547 738547 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_6 80 3 3 0   11     0   2   53 46                       99 80 3 3 0   11     0   2   53 46                 99
738788 738788 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_6 84 0 1 1   4     0   1   46 45                       91 84 0 1 1   4     0   1   46 45                 91
739047 739047 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2015   grade_6 99 0 10 0   2     0   1   62 50                       112 99 0 10 0   2     0   1   62 50                 112
739096 739096 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No 2 06 08 2015   grade_6 90 12 45 0   3     0   2   74 78                       152 90 12 45 0   3     0   2   74 78                 152
739099 739099 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No 2 06 08 2015   grade_6 189 16 86 0   11     0   11   169 144                       313 189 16 86 0   11     0   11   169 144                 313
739387 739387 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_6 111 0 4 2   0     0   1   71 47                       118 111 0 4 2   0     0   1   71 47                 118
739953 739953 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 07 2015   grade_6 208 8 72 6   5     0   11   162 148                       310 208 8 72 6   5     0   11   162 148                 310
739968 739968 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No 2 04 06 2015   grade_6 125 2 9 0   2     0   5   69 74                       143 125 2 9 0   2     0   5   69 74                 143
740597 740597 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2015   grade_6 193 3 14 2   24     0   11   129 118                       247 193 3 14 2   24     0   11   129 118                 247
740607 740607 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2015   grade_6 172 0 10 0   3     1   7   104 89                       193 172 0 10 0   3     1   7   104 89                 193
740622 740622 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 31 0 3 0   0     0   5   19 20                       39 31 0 3 0   0     0   5   19 20                 39
740764 740764 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2015   grade_6 135 2 10 0   4     0   2   80 73                       153 135 2 10 0   4     0   2   80 73                 153
740889 740889 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   grade_6 15 0 0 0   0     0   0   7 8                       15 15 0 0 0   0     0   0   7 8                 15
741571 741571 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2015   grade_6 288 11 30 2   122     0   16   237 232                       469 288 11 30 2   122     0   16   237 232                 469
741702 741702 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No 2 06 08 2015   grade_6 122 0 5 0   21     1   4   81 72                       153 122 0 5 0   21     1   4   81 72                 153
741717 741717 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2015   grade_6 76 1 92 3   2     0   2   91 85                       176 76 1 92 3   2     0   2   91 85                 176
742107 742107 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   grade_6 121 0 7 0   1     0   2   63 68                       131 121 0 7 0   1     0   2   63 68                 131
742151 742151 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2015   grade_6 109 3 0 0   3     0   7   66 56                       122 109 3 0 0   3     0   7   66 56                 122
742321 742321 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2015   grade_6 149 2 6 0   3     0   4   83 81                       164 149 2 6 0   3     0   4   83 81                 164
742552 742552 MA Worcester   school 2512240 316   Webster 251224002298 3160305 Webster Middle School   Regular School No 1 03 06 2015   grade_6 106 11 29 0   2     1   7   78 78                       156 106 11 29 0   2     1   7   78 78                 156
742633 742633 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2015   grade_6 204 4 16 1   72     1   11   180 129                       309 204 4 16 1   72     1   11   180 129                 309
742648 742648 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2015   grade_6 67 3 4 0   0     0   3   36 41                       77 67 3 4 0   0     0   3   36 41                 77
743107 743107 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2015   grade_6 4 9 17 0   5     0   1   21 15                       36 4 9 17 0   5     0   1   21 15                 36
743114 743114 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2015   grade_6 5 4 7 0   0     0   3   10 9                       19 5 4 7 0   0     0   3   10 9                 19
743122 743122 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   grade_6 3 6 43 0   6     0   0   38 20                       58 3 6 43 0   6     0   0   38 20                 58
743129 743129 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2015   grade_6 3 4 13 0   0     0   2   12 10                       22 3 4 13 0   0     0   2   12 10                 22
743137 743137 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2015   grade_6 10 8 22 0   5     0   1   27 19                       46 10 8 22 0   5     0   1   27 19                 46
743144 743144 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2015   grade_6 2 9 23 0   5     0   3   18 24                       42 2 9 23 0   5     0   3   18 24                 42
743152 743152 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2015   grade_6 3 0 50 0   5     0   1   32 27                       59 3 0 50 0   5     0   1   32 27                 59
743160 743160 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2015   grade_6 19 9 32 0   2     0   3   34 31                       65 19 9 32 0   2     0   3   34 31                 65
743168 743168 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2015   grade_6 12 2 20 0   1     0   2   17 20                       37 12 2 20 0   1     0   2   17 20                 37
743176 743176 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2015   grade_6 8 5 20 0   4     0   0   24 13                       37 8 5 20 0   4     0   0   24 13                 37
743183 743183 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2015   grade_6 31 1 8 0   2     0   0   21 21                       42 31 1 8 0   2     0   0   21 21                 42
743191 743191 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2015   grade_6 22 8 30 0   4     0   4   40 28                       68 22 8 30 0   4     0   4   40 28                 68
743199 743199 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2015   grade_6 7 9 47 0   10     0   3   42 34                       76 7 9 47 0   10     0   3   42 34                 76
743207 743207 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2015   grade_6 20 14 21 0   12     0   4   52 19                       71 20 14 21 0   12     0   4   52 19                 71
743215 743215 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2015   grade_6 11 4 15 0   3     0   2   21 14                       35 11 4 15 0   3     0   2   21 14                 35
743222 743222 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2015   grade_6 22 3 3 1   1     0   2   19 13                       32 22 3 3 1   1     0   2   19 13                 32
743230 743230 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2015   grade_6 8 8 19 0   1     0   3   23 16                       39 8 8 19 0   1     0   3   23 16                 39
743237 743237 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2015   grade_6 20 6 8 0   3     0   3   11 29                       40 20 6 8 0   3     0   3   11 29                 40
743245 743245 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2015   grade_6 3 7 10 0   1     0   0   9 12                       21 3 7 10 0   1     0   0   9 12                 21
743252 743252 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No 1 KG 06 2015   grade_6 17 6 16 0   2     0   1   17 25                       42 17 6 16 0   2     0   1   17 25                 42
743260 743260 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2015   grade_6 10 4 3 0   0     0   1   7 11                       18 10 4 3 0   0     0   1   7 11                 18
743267 743267 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2015   grade_6 27 5 5 0   3     0   2   21 21                       42 27 5 5 0   3     0   2   21 21                 42
743274 743274 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2015   grade_6 39 3 3 0   3     0   2   25 25                       50 39 3 3 0   3     0   2   25 25                 50
743282 743282 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2015   grade_6 33 12 20 0   5     0   1   40 31                       71 33 12 20 0   5     0   1   40 31                 71
743290 743290 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2015   grade_6 29 10 29 0   12     0   3   40 43                       83 29 10 29 0   12     0   3   40 43                 83
743297 743297 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2015   grade_6 11 9 16 0   1     0   4   23 18                       41 11 9 16 0   1     0   4   23 18                 41
743305 743305 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2015   grade_6 23 6 21 0   4     0   5   30 29                       59 23 6 21 0   4     0   5   30 29                 59
743313 743313 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2015   grade_6 21 2 17 1   1     0   2   20 24                       44 21 2 17 1   1     0   2   20 24                 44
743320 743320 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2015   grade_6 28 14 19 1   5     0   7   35 39                       74 28 14 19 1   5     0   7   35 39                 74
743327 743327 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2015   grade_6 14 5 13 0   2     0   3   16 21                       37 14 5 13 0   2     0   3   16 21                 37
743334 743334 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2015   grade_6 8 9 26 1   3     0   4   25 26                       51 8 9 26 1   3     0   4   25 26                 51
743342 743342 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2015   grade_6 31 3 4 0   3     0   5   28 18                       46 31 3 4 0   3     0   5   28 18                 46
743350 743350 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2015   grade_6 18 18 37 0   1     0   2   38 38                       76 18 18 37 0   1     0   2   38 38                 76
743367 743367 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2015   grade_6 14 17 38 0   9     0   6   43 41                       84 14 17 38 0   9     0   6   43 41                 84
743370 743370 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2015   grade_6 25 4 10 0   8     0   2   21 28                       49 25 4 10 0   8     0   2   21 28                 49
743608 743608 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_6 29 49 35 1   7     0   2   56 67                       123 29 49 35 1   7     0   2   56 67                 123
743833 743833 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2015   grade_6 7 19 29 0   2     0   1   32 26                       58 7 19 29 0   2     0   1   32 26                 58
744011 744011 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No 2 06 08 2015   grade_6 178 1 8 0   3     0   1   94 97                       191 178 1 8 0   3     0   1   94 97                 191
744036 744036 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2015   grade_6 16 0 0 0   1     0   0   10 7                       17 16 0 0 0   1     0   0   10 7                 17
744038 744038 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2015   grade_6 85 1 6 0   0     0   4   48 48                       96 85 1 6 0   0     0   4   48 48                 96
744082 744082 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2015   grade_6 74 1 1 0   5     0   5   45 41                       86 74 1 1 0   5     0   5   45 41                 86
744102 744102 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No 2 06 08 2015   grade_6 126 1 9 0   2     0   1   70 69                       139 126 1 9 0   2     0   1   70 69                 139
744248 744248 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No 2 05 08 2015   grade_6 131 3 11 1   4     0   5   83 72                       155 131 3 11 1   4     0   5   83 72                 155
744252 744252 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2015   grade_6 169 0 18 0   2     0   6   98 97                       195 169 0 18 0   2     0   6   98 97                 195
744480 744480 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 05 08 2015   grade_6 176 2 9 0   3     0   5   87 108                       195 176 2 9 0   3     0   5   87 108                 195
744570 744570 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2015   grade_6 95 1 5 0   0     0   5   55 51                       106 95 1 5 0   0     0   5   55 51                 106
744598 744598 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2015   grade_6 96 1 2 0   1     0   1   45 56                       101 96 1 2 0   1     0   1   45 56                 101
744601 744601 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2015   grade_6 85 3 2 0   2     0   3   52 43                       95 85 3 2 0   2     0   3   52 43                 95
744604 744604 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2015   grade_6 82 0 1 0   5     0   0   58 30                       88 82 0 1 0   5     0   0   58 30                 88
744732 744732 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_6 29 0 0 0   0     0   1   22 8                       30 29 0 0 0   0     0   1   22 8                 30
744739 744739 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_6 58 0 3 0   0     0   0   27 34                       61 58 0 3 0   0     0   0   27 34                 61
744747 744747 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_6 46 0 1 0   0     0   0   21 26                       47 46 0 1 0   0     0   0   21 26                 47
744754 744754 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_6 54 0 0 0   1     0   1   21 35                       56 54 0 0 0   1     0   1   21 35                 56
744838 744838 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_6 24 1 3 0   0     0   0   14 14                       28 24 1 3 0   0     0   0   14 14                 28
744846 744846 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Junior High   Regular School No 2 06 08 2015   grade_6 84 1 6 1   0     0   2   42 52                       94 84 1 6 1   0     0   2   42 52                 94
744945 744945 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2015   grade_6 62 1 3 0   0     0   0   34 32                       66 62 1 3 0   0     0   0   34 32                 66
744954 744954 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2015   grade_6 48 0 2 0   2     0   1   28 25                       53 48 0 2 0   2     0   1   28 25                 53
744960 744960 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2015   grade_6 242 4 14 1   17     0   9   133 154                       287 242 4 14 1   17     0   9   133 154                 287
744963 744963 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2015   grade_6 118 3 6 0   3     0   3   71 62                       133 118 3 6 0   3     0   3   71 62                 133
744967 744967 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2015   grade_6 85 1 5 0   1     0   0   58 34                       92 85 1 5 0   1     0   0   58 34                 92
744982 744982 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2015   grade_6 76 0 5 0   0     0   1   37 45                       82 76 0 5 0   0     0   1   37 45                 82
744990 744990 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 49 0 0 0   0     0   0   28 21                       49 49 0 0 0   0     0   0   28 21                 49
932801 932801 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2016   grade_6 173 4 11 0   5     0   9   99 103                       202 173 4 11 0   5     0   9   99 103                 202
934044 934044 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 44 0 1 0   0     0   2   25 22                       47 44 0 1 0   0     0   2   25 22                 47
934476 934476 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_6 83 6 26 0   1     0   4   63 57                       120 83 6 26 0   1     0   4   63 57                 120
934638 934638 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2016   grade_6 118 1 3 0   2     1   2   70 57                       127 118 1 3 0   2     1   2   70 57                 127
935024 935024 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2016   grade_6 43 7 98 0   8     0   14   85 85                       170 43 7 98 0   8     0   14   85 85                 170
935034 935034 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_6 40 4 55 0   7     0   11   71 46                       117 40 4 55 0   7     0   11   71 46                 117

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