enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by native_hawaiian_pacific_islander descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1123699 1123699 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_9 216 739 183 4   29     3   49   687 536                       1223 216 739 183 4   29     3   49   687 536                 1223
1124205 1124205 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2017   grade_12 248 9 77 1   10     3   7   207 148                       355 248 9 77 1   10     3   7   207 148                 355
1125297 1125297 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_5 42 1 4 0   1     3   2   28 25                       53 42 1 4 0   1     3   2   28 25                 53
1126339 1126339 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2017   grade_7 119 3 15 2   2     3   1   76 69                       145 119 3 15 2   2     3   1   76 69                 145
1127091 1127091 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2017   grade_11 162 58 9 0   21     3   9   134 128                       262 162 58 9 0   21     3   9   134 128                 262
1127386 1127386 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_11 132 47 184 4   6     3   20   211 185                       396 132 47 184 4   6     3   20   211 185                 396
1129494 1129494 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No Elementary KG 05 2017   grade_4 29 8 1 0   2     3   5   21 27                       48 29 8 1 0   2     3   5   21 27                 48
1132209 1132209 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2017   grade_2 37 0 0 0   0     3   1   19 22                       41 37 0 0 0   0     3   1   19 22                 41
1365139 1365139 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2020   grade_3 68 2 6 0   0     3   2   45 36 *                     81.0 68 2 6 0   0     3   2   45 36                 81
1366241 1366241 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_9 169 865 231 3   29     3   52   766 586 *                     1352.0 169 865 231 3   29     3   52   766 586                 1352
1366479 1366479 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_9 190 130 78 0   48     3   45   231 263 *                     494.0 190 130 78 0   48     3   45   231 263                 494
1367408 1367408 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2020   grade_3 53 0 4 1   2     3   2   35 30 *                     65.0 53 0 4 1   2     3   2   35 30                 65
1367441 1367441 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   grade_12 379 5 9 0   19     3   14   216 213 *                     429.0 379 5 9 0   19     3   14   216 213                 429
1367583 1367583 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_8 36 1 5 0   3     3   3   27 24 *                     51.0 36 1 5 0   3     3   3   27 24                 51
1368156 1368156 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2020   grade_12 78 9 48 0   1     3   5   98 46 *                     144.0 78 9 48 0   1     3   5   98 46                 144
1369652 1369652 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_7 133 2 17 0   23     3   6   85 99 *                     184.0 133 2 17 0   23     3   6   85 99                 184
1369749 1369749 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2020   grade_1 28 6 20 0   7     3   0   34 30 *                     64.0 28 6 20 0   7     3   0   34 30                 64
1369771 1369771 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No Elementary KG 05 2020   grade_2 21 5 8 0   23     3   0   28 32 *                     60.0 21 5 8 0   23     3   0   28 32                 60
1369775 1369775 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2020   kindergarten 166 18 40 0   35     3   6   137 131 *                     268.0 166 18 40 0   35     3   6   137 131                 268
1369776 1369776 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2020   pre_kindergarten 85 9 8 0   17     3   0   74 48 *                     122.0 85 9 8 0   17     3   0   74 48                 122
1370479 1370479 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2020   grade_7 139 7 39 1   10     3   5   107 97 *                     204.0 139 7 39 1   10     3   5   107 97                 204
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
1373432 1373432 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2020   grade_5 39 0 0 0   0     3   1   22 21 *                     43.0 39 0 0 0   0     3   1   22 21                 43
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
1673712 1673712 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_10 179 128 79 0   45     3   44   226 252 *                     478.0 179 128 79 0   45     3   44   226 252                 478
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
1674639 1674639 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   kindergarten 44 0 1 0   4     3   0   30 22 *                     52.0 44 0 1 0   4     3   0   30 22                 52
1674643 1674643 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   grade_4 50 0 4 1   1     3   2   30 31 *                     61.0 50 0 4 1   1     3   2   30 31                 61
1674744 1674744 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester - Gloucester High   Regular School No High 09 12 2021   grade_9 210 3 26 0   5     3   11   146 112 *                     258.0 210 3 26 0   5     3   11   146 112                 258
1674834 1674834 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley - Hopkins Academy   Regular School No High 07 12 2021   grade_9 36 1 5 0   2     3   3   27 23 *                     50.0 36 1 5 0   2     3   3   27 23                 50
1675459 1675459 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Lincoln - Hanscom Primary   Regular School No Elementary PK 03 2021   grade_1 32 2 19 0   1     3   11   34 34 *                     68.0 32 2 19 0   1     3   11   34 34                 68
1676014 1676014 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Marshfield - Daniel Webster   Regular School No Elementary PK 05 2021   kindergarten 39 0 1 0   0     3   1   21 23 *                     44.0 39 0 1 0   0     3   1   21 23                 44
1676900 1676900 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough - Robert E. Melican Middle School   Regular School No Middle 06 08 2021   grade_8 129 1 19 2   20     3   9   89 94 *                     183.0 129 1 19 2   20     3   9   89 94                 183
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
2040124 2040124 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_10 254 31 58 1   3     3   12   189 173                       362.0 254 31 58 1   3     3   12   189 173                 362
2042478 2042478 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_2 55 0 4 1   2     3   2   35 32                       67.0 55 0 4 1   2     3   2   35 32                 67
2042511 2042511 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_11 383 6 11 0   20     3   14   215 222                       437.0 383 6 11 0   20     3   14   215 222                 437
2042656 2042656 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_7 33 0 3 0   3     3   3   25 20                       45.0 33 0 3 0   3     3   3   25 20                 45
2043797 2043797 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 91 12 42 0   20     3   7   95 80                       175.0 91 12 42 0   20     3   7   95 80                 175
2044661 2044661 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No High 09 12 2019   grade_12 320 11 36 1   21     3   5   189 207                       397.0 320 11 36 1   21     3   5   189 207                 397
2044843 2044843 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No Elementary 01 05 2019   grade_1 21 5 7 0   18     3   1   24 31                       55.0 21 5 7 0   18     3   1   24 31                 55
2044849 2044849 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2019   kindergarten 167 27 23 1   39     3   4   146 118                       264.0 167 27 23 1   39     3   4   146 118                 264
2048494 2048494 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2019   grade_4 41 0 0 0   0     3   1   23 22                       45.0 41 0 0 0   0     3   1   23 22                 45
2229126 2229126 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable: Barnstable United Elementary School   Regular School No Elementary 04 05 2018   grade_5 324 29 53 0   11     3   13   216 217                       433.0 324 29 53 0   11     3   13   216 217                 433
2230513 2230513 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_9 218 689 157 3   23     3   50   630 513                       1143.0 218 689 157 3   23     3   50   630 513                 1143
2231866 2231866 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin: Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 84 3 8 1   1     3   4   63 41                       104.0 84 3 8 1   1     3   4   63 41                 104
2231883 2231883 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   grade_1 50 0 4 1   2     3   2   31 31                       62.0 50 0 4 1   2     3   2   31 31                 62
2232012 2232012 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester: Gloucester High   Regular School No High 09 12 2018   grade_12 179 5 18 0   6     3   2   109 104                       213.0 179 5 18 0   6     3   2   109 104                 213
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
2233163 2233163 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg: Lunenburg Middle School   Regular School No Middle 06 08 2018   grade_8 122 4 13 2   2     3   1   80 67                       147.0 122 4 13 2   2     3   1   80 67                 147
2233909 2233909 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton: Milton High   Regular School No High 09 12 2018   grade_12 166 58 8 0   21     3   9   135 130                       265.0 166 58 8 0   21     3   9   135 130                 265
2234498 2234498 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover: North Andover High   Regular School No High 09 12 2018   grade_11 318 12 35 1   21     3   5   190 205                       395.0 318 12 35 1   21     3   5   190 205                 395
2234577 2234577 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_8 180 3 5 1   22     3   7   117 104                       221.0 180 3 5 1   22     3   7   117 104                 221
2236312 2236312 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 Stoughton: South Elementary   Regular School No Elementary KG 05 2018   grade_5 30 8 2 0   2     3   2   21 26                       47.0 30 8 2 0   2     3   2   21 26                 47
2239041 2239041 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Hamilton-Wenham: Cutler School   Regular School No Elementary KG 05 2018   grade_3 40 0 0 0   0     3   1   22 22                       44.0 40 0 0 0   0     3   1   22 22                 44
735713 735713 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_12 267 6 8 2   7     2   3   153 142                       295 267 6 8 2   7     2   3   153 142                 295
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
735908 735908 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_9 310 30 48 3   22     2   18   224 209                       433 310 30 48 3   22     2   18   224 209                 433
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
735972 735972 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_8 316 22 13 4   21     2   20   197 201                       398 316 22 13 4   21     2   20   197 201                 398
735973 735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
735976 735976 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_12 273 18 20 2   9     2   10   161 173                       334 273 18 20 2   9     2   10   161 173                 334
736060 736060 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2015   grade_9 244 16 9 0   53     2   17   172 169                       341 244 16 9 0   53     2   17   172 169                 341
736114 736114 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2015   grade_8 235 11 25 0   5     2   5   133 150                       283 235 11 25 0   5     2   5   133 150                 283
736161 736161 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No 2 06 08 2015   grade_8 192 1 6 0   10     2   3   114 100                       214 192 1 6 0   10     2   3   114 100                 214
736163 736163 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2015   grade_9 292 6 11 0   14     2   5   163 167                       330 292 6 11 0   14     2   5   163 167                 330
736373 736373 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 05 2015   grade_5 24 44 34 0   10     2   7   60 61                       121 24 44 34 0   10     2   7   60 61                 121
736422 736422 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2015   grade_2 0 30 19 0   4     2   3   24 34                       58 0 30 19 0   4     2   3   24 34                 58
736425 736425 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2015   grade_5 0 26 13 0   0     2   0   15 26                       41 0 26 13 0   0     2   0   15 26                 41
736557 736557 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_8 0 41 43 0   0     2   0   39 47                       86 0 41 43 0   0     2   0   39 47                 86
736695 736695 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_2 3 52 29 0   0     2   2   40 48                       88 3 52 29 0   0     2   2   40 48                 88
736857 736857 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_10 74 87 68 1   58     2   7   123 174                       297 74 87 68 1   58     2   7   123 174                 297
736905 736905 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2015   grade_10 4 63 19 1   4     2   1   50 44                       94 4 63 19 1   4     2   1   50 44                 94
737090 737090 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   kindergarten 17 68 12 1   2     2   7   56 53                       109 17 68 12 1   2     2   7   56 53                 109
737134 737134 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2015   kindergarten 23 58 13 1   1     2   11   58 51                       109 23 58 13 1   1     2   11   58 51                 109
737154 737154 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_8 50 86 26 0   2     2   7   88 85                       173 50 86 26 0   2     2   7   88 85                 173
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
737156 737156 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2015   grade_7 69 95 32 1   8     2   8   113 102                       215 69 95 32 1   8     2   8   113 102                 215
737164 737164 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_9 206 707 159 6   31     2   35   624 522                       1146 206 707 159 6   31     2   35   624 522                 1146
737390 737390 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2015   grade_7 35 32 13 2   4     2   4   53 39                       92 35 32 13 2   4     2   4   53 39                 92
737402 737402 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_10 193 139 64 2   56     2   15   250 221                       471 193 139 64 2   56     2   15   250 221                 471
737419 737419 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2015   kindergarten 57 7 6 0   14     2   2   45 43                       88 57 7 6 0   14     2   2   45 43                 88
737420 737420 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2015   grade_1 68 6 1 0   12     2   5   48 46                       94 68 6 1 0   12     2   5   48 46                 94
737703 737703 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2015   grade_8 257 6 17 0   9     2   5   155 141                       296 257 6 17 0   9     2   5   155 141                 296
737732 737732 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2015   grade_10 272 7 8 0   11     2   3   147 156                       303 272 7 8 0   11     2   3   147 156                 303
737855 737855 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_9 157 9 3 0   0     2   2   82 91                       173 157 9 3 0   0     2   2   82 91                 173
737930 737930 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No 3 09 12 2015   grade_12 244 17 12 0   10     2   8   147 146                       293 244 17 12 0   10     2   8   147 146                 293
738110 738110 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2015   grade_8 126 13 40 0   8     2   11   84 116                       200 126 13 40 0   8     2   11   84 116                 200
738123 738123 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_9 376 59 148 1   36     2   19   344 297                       641 376 59 148 1   36     2   19   344 297                 641
738341 738341 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_7 141 1 2 0   8     2   7   81 80                       161 141 1 2 0   8     2   7   81 80                 161
738342 738342 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_8 134 0 6 0   6     2   2   73 77                       150 134 0 6 0   6     2   2   73 77                 150
738366 738366 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 09 12 2015   grade_11 105 1 9 2   3     2   3   73 52                       125 105 1 9 2   3     2   3   73 52                 125
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
738434 738434 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_3 84 0 4 1   7     2   3   56 45                       101 84 0 4 1   7     2   3   56 45                 101
738614 738614 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 KG 04 2015   grade_4 36 3 56 1   3     2   1   54 48                       102 36 3 56 1   3     2   1   54 48                 102
739202 739202 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2015   grade_1 72 0 5 0   14     2   4   43 54                       97 72 0 5 0   14     2   4   43 54                 97
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
739375 739375 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No 3 09 12 2015   grade_9 211 3 24 1   1     2   4   123 123                       246 211 3 24 1   1     2   4   123 123                 246
739596 739596 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden Early Learning Center   Regular School No 1 PK PK 2015   pre_kindergarten 138 57 18 0   93     2   9   175 142                       317 138 57 18 0   93     2   9   175 142                 317
739608 739608 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_11 128 110 83 2   115     2   12   223 229                       452 128 110 83 2   115     2   12   223 229                 452

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