enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by native_hawaiian_pacific_islander 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
1125298 1125298 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_6 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
1677429 1677429 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy - Point Webster Middle   Regular School No Middle 05 08 2021   grade_6 17 13 21 0   40     5   4   46 54 *                     100.0 17 13 21 0   40     5   4   46 54                 100
2046216 2046216 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2019   grade_6 154 57 32 0   8     4   22   126 151                       277.0 154 57 32 0   8     4   22   126 151                 277
742462 742462 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No 2 04 06 2015   grade_6 95 5 7 0   0     3   4   66 48                       114 95 5 7 0   0     3   4   66 48                 114
936234 936234 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2016   grade_6 118 3 12 1   2     3   1   74 66                       140 118 3 12 1   2     3   1   74 66                 140
1372859 1372859 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_6 2 140 105 1   0     3   0   136 115 *                     251.0 2 140 105 1   0     3   0   136 115                 251
1374299 1374299 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_6 76 10 20 0   6     3   9   66 58 *                     124.0 76 10 20 0   6     3   9   66 58                 124
1673735 1673735 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton - Wm H Galvin Middle   Regular School No Middle 06 08 2021   grade_6 146 26 16 0   34     3   17   117 125 *                     242.0 146 26 16 0   34     3   17   117 125                 242
1680705 1680705 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham - Miles River Middle   Regular School No Middle 06 08 2021   grade_6 116 0 7 0   3     3   7   69 67 *                     136.0 116 0 7 0   3     3   7   69 67                 136
2232111 2232111 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_6 40 1 3 0   1     3   3   27 24                       51.0 40 1 3 0   1     3   3   27 24                 51
735901 735901 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_6 96 8 17 0   7     2   10   80 60                       140 96 8 17 0   7     2   10   80 60                 140
735970 735970 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_6 275 28 35 3   5     2   15   209 154                       363 275 28 35 3   5     2   15   209 154                 363
737155 737155 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_6 61 110 28 0   7     2   11   108 111                       219 61 110 28 0   7     2   11   108 111                 219
738418 738418 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_6 161 0 20 2   0     2   3   88 100                       188 161 0 20 2   0     2   3   88 100                 188
739372 739372 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2015   grade_6 204 4 16 1   3     2   5   113 122                       235 204 4 16 1   3     2   5   113 122                 235
740266 740266 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_6 128 48 95 2   4     2   24   159 144                       303 128 48 95 2   4     2   24   159 144                 303
740269 740269 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_6 191 27 96 4   2     2   10   183 149                       332 191 27 96 4   2     2   10   183 149                 332
743767 743767 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2015   grade_6 0 19 8 0   0     2   0   18 11                       29 0 19 8 0   0     2   0   18 11                 29
743817 743817 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_6 1 135 100 1   2     2   3   123 121                       244 1 135 100 1   2     2   3   123 121                 244
744074 744074 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_6 78 1 7 0   3     2   3   46 48                       94 78 1 7 0   3     2   3   46 48                 94
934015 934015 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2016   grade_6 53 115 34 1   9     2   15   126 103                       229 53 115 34 1   9     2   15   126 103                 229
936878 936878 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2016   grade_6 93 1 1 0   0     2   3   51 49                       100 93 1 1 0   0     2   3   51 49                 100
937564 937564 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2016   grade_6 18 4 4 0   0     2   0   21 7                       28 18 4 4 0   0     2   0   21 7                 28
937593 937593 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2016   grade_6 117 2 11 2   1     2   5   58 82                       140 117 2 11 2   1     2   5   58 82                 140
937946 937946 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_6 108 5 5 0   90     2   5   120 95                       215 108 5 5 0   90     2   5   120 95                 215
940617 940617 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2016   grade_6 11 83 60 1   11     2   7   93 82                       175 11 83 60 1   11     2   7   93 82                 175
941425 941425 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2016   grade_6 70 2 2 0   0     2   1   31 46                       77 70 2 2 0   0     2   1   31 46                 77
1122883 1122883 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2017   grade_6 6 42 27 0   6     2   2   49 36                       85 6 42 27 0   6     2   2   49 36                 85
1123008 1123008 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_6 39 23 48 0   9     2   2   76 47                       123 39 23 48 0   9     2   2   76 47                 123
1131111 1131111 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_6 26 16 120 5   2     2   0   79 92                       171 26 16 120 5   2     2   0   79 92                 171
1131169 1131169 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2017   grade_6 0 46 18 1   1     2   0   44 24                       68 0 46 18 1   1     2   0   44 24                 68
1131839 1131839 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2017   grade_6 118 8 20 0   1     2   4   72 81                       153 118 8 20 0   1     2   4   72 81                 153
1366503 1366503 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2020   grade_6 205 29 10 1   24     2   20   145 146 *                     291.0 205 29 10 1   24     2   20   145 146                 291
1367435 1367435 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2020   grade_6 110 3 5 0   9     2   4   71 62 *                     133.0 110 3 5 0   9     2   4   71 62                 133
1368268 1368268 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2020   grade_6 95 0 6 0   17     2   9   57 72 *                     129.0 95 0 6 0   17     2   9   57 72                 129
1370172 1370172 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2020   grade_6 94 8 6 0   105     2   4   111 108 *                     219.0 94 8 6 0   105     2   4   111 108                 219
1372113 1372113 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_6 101 18 13 0   15     2   7   77 79 *                     156.0 101 18 13 0   15     2   7   77 79                 156
1372678 1372678 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_6 47 64 5 2   15     2   10   65 80 *                     145.0 47 64 5 2   15     2   10   65 80                 145
1372888 1372888 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2020   grade_6 6 56 22 0   6     2   3   46 49 *                     95.0 6 56 22 0   6     2   3   46 49                 95
1673414 1673414 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_6 14 92 17 0   3     2   3   51 80 *                     131.0 14 92 17 0   3     2   3   51 80                 131
1673468 1673468 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton - Ashfield Middle School   Regular School No Middle 06 08 2021   grade_6 31 78 16 1   3     2   6   79 58 *                     137.0 31 78 16 1   3     2   6   79 58                 137
1674669 1674669 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_6 101 1 8 0   4     2   2   54 64 *                     118.0 101 1 8 0   4     2   2   54 64                 118
1675474 1675474 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln - Hanscom Middle   Regular School No Middle 04 08 2021   grade_6 21 5 14 0   0     2   7   21 28 *                     49.0 21 5 14 0   0     2   7   21 28                 49
1676716 1676716 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 Newton - F A Day Middle   Regular School No Middle 06 08 2021   grade_6 205 18 32 1   50     2   27   171 164 *                     335.0 205 18 32 1   50     2   27   171 164                 335
1681524 1681524 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_6 32 8 9 0   1     2   3   33 22 0                     55.0 32 8 9 0   1     2   3   33 22 0               55
2040120 2040120 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2019   grade_6 288 31 56 0   10     2   12   201 198                       399.0 288 31 56 0   10     2   12   201 198                 399
2040428 2040428 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_6 2 55 30 0   3     2   2   48 46                       94.0 2 55 30 0   3     2   2   48 46                 94
2040845 2040845 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_6 1 27 12 0   1     2   1   28 16                       44.0 1 27 12 0   1     2   1   28 16                 44
2044693 2044693 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2019   grade_6 328 8 20 1   17     2   15   170 221                       391.0 328 8 20 1   17     2   15   170 221                 391
2045246 2045246 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_6 92 5 6 0   83     2   9   94 103                       197.0 92 5 6 0   83     2   9   94 103                 197
2048243 2048243 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Middle 04 06 2019   grade_6 247 14 4 1   4     2   24   136 160                       296.0 247 14 4 1   4     2   24   136 160                 296
2229350 2229350 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica: Locke Middle   Regular School No Middle 06 08 2018   grade_6 128 6 11 0   11     2   4   87 75                       162.0 128 6 11 0   11     2   4   87 75                 162
2232041 2232041 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 89 1 6 2   7     2   3   63 47                       110.0 89 1 6 2   7     2   3   63 47                 110
2233919 2233919 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Monson: Granite Valley Middle   Regular School No Middle 05 08 2018   grade_6 53 1 5 0   2     2   2   31 34                       65.0 53 1 5 0   2     2   2   31 34                 65
2234575 2234575 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_6 145 7 14 0   21     2   11   96 104                       200.0 145 7 14 0   21     2   11   96 104                 200
2236329 2236329 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton: O'Donnell Middle School   Regular School No Middle 06 08 2018   grade_6 174 72 33 1   28     2   12   188 134                       322.0 174 72 33 1   28     2   12   188 134                 322
2236515 2236515 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton: Benjamin Friedman Middle   Regular School No Middle 05 07 2018   grade_6 191 22 24 0   3     2   14   127 129                       256.0 191 22 24 0   3     2   14   127 129                 256
2238670 2238670 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley School District: Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2018   grade_6 98 2 12 1   8     2   4   71 56                       127.0 98 2 12 1   8     2   4   71 56                 127
2239711 2239711 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett: Central Tree Middle   Regular School No Middle 06 08 2018   grade_6 105 3 5 0   3     2   3   51 70                       121.0 105 3 5 0   3     2   3   51 70                 121
735742 735742 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   grade_6 32 6 12 0   5     1   6   33 29                       62 32 6 12 0   5     1   6   33 29                 62
736214 736214 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2015   grade_6 14 28 35 0   11     1   2   50 41                       91 14 28 35 0   11     1   2   50 41                 91
736380 736380 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 06 2015   grade_6 7 22 60 1   1     1   0   49 43                       92 7 22 60 1   1     1   0   49 43                 92
736528 736528 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_6 29 29 21 0   55     1   7   83 59                       142 29 29 21 0   55     1   7   83 59                 142
736545 736545 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_6 16 1 4 0   1     1   2   19 6                       25 16 1 4 0   1     1   2   19 6                 25
736880 736880 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_6 12 17 18 0   77     1   6   75 56                       131 12 17 18 0   77     1   6   75 56                 131
736990 736990 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2015   grade_6 102 1 2 0   7     1   1   56 58                       114 102 1 2 0   7     1   1   56 58                 114
737096 737096 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_6 28 68 14 0   0     1   2   51 62                       113 28 68 14 0   0     1   2   51 62                 113
737125 737125 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_6 9 71 7 0   1     1   3   50 42                       92 9 71 7 0   1     1   3   50 42                 92
737146 737146 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2015   grade_6 19 96 18 0   1     1   7   77 65                       142 19 96 18 0   1     1   7   77 65                 142
737149 737149 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2015   grade_6 11 113 29 0   3     1   6   83 80                       163 11 113 29 0   3     1   6   83 80                 163
737193 737193 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2015   grade_6 42 3 9 0   26     1   6   46 41                       87 42 3 9 0   26     1   6   46 41                 87
737389 737389 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2015   grade_6 39 24 14 0   6     1   4   44 44                       88 39 24 14 0   6     1   4   44 44                 88
737392 737392 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No 2 06 08 2015   grade_6 24 36 8 1   8     1   4   32 50                       82 24 36 8 1   8     1   4   32 50                 82
737449 737449 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_6 158 0 0 0   0     1   0   81 78                       159 158 0 0 0   0     1   0   81 78                 159
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
737901 737901 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No 2 06 08 2015   grade_6 172 2 8 0   10     1   1   94 100                       194 172 2 8 0   10     1   1   94 100                 194
737956 737956 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_6 8 5 29 0   4     1   3   27 23                       50 8 5 29 0   4     1   3   27 23                 50
738108 738108 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2015   grade_6 112 13 30 0   6     1   13   98 77                       175 112 13 30 0   6     1   13   98 77                 175
739184 739184 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2015   grade_6 20 7 12 0   2     1   3   18 27                       45 20 7 12 0   2     1   3   18 27                 45
739566 739566 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2015   grade_6 33 14 12 0   25     1   3   43 45                       88 33 14 12 0   25     1   3   43 45                 88
739799 739799 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No 2 06 08 2015   grade_6 131 14 12 0   11     1   4   86 87                       173 131 14 12 0   11     1   4   86 87                 173
739983 739983 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2015   grade_6 104 0 2 0   6     1   4   78 39                       117 104 0 2 0   6     1   4   78 39                 117
740015 740015 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No 2 06 08 2015   grade_6 233 56 13 1   23     1   10   190 147                       337 233 56 13 1   23     1   10   190 147                 337
740092 740092 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2015   grade_6 175 9 24 0   12     1   10   109 122                       231 175 9 24 0   12     1   10   109 122                 231
740450 740450 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   grade_6 38 2 2 0   0     1   3   23 23                       46 38 2 2 0   0     1   3   23 23                 46
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
740666 740666 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2015   grade_6 196 1 3 0   4     1   3   113 95                       208 196 1 3 0   4     1   3   113 95                 208
740687 740687 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No 2 06 08 2015   grade_6 162 3 3 0   3     1   5   93 84                       177 162 3 3 0   3     1   5   93 84                 177
741117 741117 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_6 121 6 6 0   90     1   6   117 113                       230 121 6 6 0   90     1   6   117 113                 230
741442 741442 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No 2 06 08 2015   grade_6 180 6 28 1   9     1   3   124 104                       228 180 6 28 1   9     1   3   124 104                 228
741532 741532 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No 2 06 08 2015   grade_6 162 14 12 0   81     1   11   153 128                       281 162 14 12 0   81     1   11   153 128                 281
741604 741604 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No 2 06 08 2015   grade_6 191 1 4 0   3     1   4   114 90                       204 191 1 4 0   3     1   4   114 90                 204
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
741948 741948 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_6 19 29 49 1   0     1   2   59 42                       101 19 29 49 1   0     1   2   59 42                 101
742354 742354 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2015   grade_6 263 8 14 0   5     1   2   154 139                       293 263 8 14 0   5     1   2   154 139                 293
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
742713 742713 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No 2 06 08 2015   grade_6 186 2 20 0   3     1   5   107 110                       217 186 2 20 0   3     1   5   107 110                 217
743466 743466 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes 2 06 08 2015   grade_6 0 55 12 0   0     1   1   36 33                       69 0 55 12 0   0     1   1   36 33                 69
743621 743621 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_6 58 28 5 0   14     1   7   58 55                       113 58 28 5 0   14     1   7   58 55                 113

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