Data source: Big Local News · About: Big Local

2,748 rows where grade = "grade_12" and state = "MA" sorted by native_hawaiian_pacific_islander descending

View and edit SQL

year

grade

  • grade_12 · 2,748
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
740278 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_12 183 71 105 1   10     4   32   200 206                       406 183 71 105 1   10     4   32   200 206                 406
1673477 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_12 166 561 110 4   19     4   31   471 424 *                     895.0 166 561 110 4   19     4   31   471 424                 895
2040126 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_12 269 26 36 2   12     4   13   174 188                       362.0 269 26 36 2   12     4   13   174 188                 362
2046378 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_12 284 69 46 0   16     4   18   231 206                       437.0 284 69 46 0   16     4   18   231 206                 437
737598 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2015   grade_12 231 8 67 0   11     3   9   184 145                       329 231 8 67 0   11     3   9   184 145                 329
740417 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_12 290 18 26 0   93     3   14   209 235                       444 290 18 26 0   93     3   14   209 235                 444
742722 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No 3 09 12 2015   grade_12 269 4 39 1   14     3   3   170 163                       333 269 4 39 1   14     3   3   170 163                 333
744623 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2015   grade_12 317 2 8 0   22     3   2   164 190                       354 317 2 8 0   22     3   2   164 190                 354
937116 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_12 188 54 125 1   4     3   26   215 186                       401 188 54 125 1   4     3   26   215 186                 401
941447 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2016   grade_12 316 4 12 0   31     3   7   178 195                       373 316 4 12 0   31     3   7   178 195                 373
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
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
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
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
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
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
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
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
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
739609 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_12 148 95 97 2   114     2   16   246 228                       474 148 95 97 2   114     2   16   246 228                 474
740456 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_12 83 2 4 0   0     2   7   48 50                       98 83 2 4 0   0     2   7   48 50                 98
740881 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2015   grade_12 236 6 0 0   1     2   0   117 128                       245 236 6 0 0   1     2   0   117 128                 245
742639 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No 3 09 12 2015   grade_12 219 7 14 1   47     2   3   151 142                       293 219 7 14 1   47     2   3   151 142                 293
742970 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2015   grade_12 234 4 7 0   9     2   7   126 137                       263 234 4 7 0   9     2   7   126 137                 263
744258 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No 3 09 12 2015   grade_12 217 2 14 0   2     2   4   109 132                       241 217 2 14 0   2     2   4   109 132                 241
933729 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative Education School No 3 11 12 2016   grade_12 4 63 28 0   2     2   3   59 43                       102 4 63 28 0   2     2   3   59 43                 102
935218 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 08 12 2016   grade_12 97 3 5 2   2     2   3   67 47                       114 97 3 5 2   2     2   3   67 47                 114
936468 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2016   grade_12 280 9 7 2   16     2   2   158 160                       318 280 9 7 2   16     2   2   158 160                 318
937291 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2016   grade_12 65 6 7 2   0     2   9   38 53                       91 65 6 7 2   0     2   9   38 53                 91
937362 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2016   grade_12 286 5 21 0   24     2   1   174 165                       339 286 5 21 0   24     2   1   174 165                 339
937556 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No 3 09 12 2016   grade_12 193 38 14 0   15     2   1   147 116                       263 193 38 14 0   15     2   1   147 116                 263
939775 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2016   grade_12 188 2 5 0   5     2   2   89 115                       204 188 2 5 0   5     2   2   89 115                 204
940966 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No 3 09 12 2016   grade_12 328 17 4 1   7     2   11   194 176                       370 328 17 4 1   7     2   11   194 176                 370
941296 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No 3 09 12 2016   grade_12 345 4 6 0   4     2   1   191 171                       362 345 4 6 0   4     2   1   191 171                 362
1123340 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_12 71 70 63 1   54     2   7   111 157                       268 71 70 63 1   54     2   7   111 157                 268
1123973 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2017   grade_12 190 131 56 2   65     2   16   236 226                       462 190 131 56 2   65     2   16   236 226                 462
1124363 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2017   grade_12 231 4 7 0   0     2   11   116 139                       255 231 4 7 0   0     2   11   116 139                 255
1124472 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2017   grade_12 148 9 13 0   11     2   4   90 97                       187 148 9 13 0   11     2   4   90 97                 187
1127387 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_12 219 66 206 3   7     2   13   251 265                       516 219 66 206 3   7     2   13   251 265                 516
1127677 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No High 09 12 2017   grade_12 258 10 22 0   24     2   10   149 177                       326 258 10 22 0   24     2   10   149 177                 326
1127844 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No High 09 12 2017   grade_12 186 3 0 0   2     2   2   93 102                       195 186 3 0 0   2     2   2   93 102                 195
1128261 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No High 09 12 2017   grade_12 210 3 3 4   2     2   9   130 103                       233 210 3 3 4   2     2   9   130 103                 233
1132499 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2017   grade_12 295 5 14 0   34     2   7   174 183                       357 295 5 14 0   34     2   7   174 183                 357
1367091 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_12 124 117 253 2   24     2   5   273 254 *                     527.0 124 117 253 2   24     2   5   273 254                 527
1371302 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2020   grade_12 293 83 52 0   8     2   13   211 239 *                     451.0 293 83 52 0   8     2   13   211 239                 451
1373692 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2020   grade_12 266 4 23 0   33     2   12   170 170 *                     340.0 266 4 23 0   33     2   12   170 170                 340
1374070 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2020   grade_12 255 9 12 1   7     2   4   143 147 *                     290.0 255 9 12 1   7     2   4   143 147                 290
1672258 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro - Attleboro High   Regular School No High 09 12 2021   grade_12 281 25 61 0   27     2   24   215 205 *                     420.0 281 25 61 0   27     2   24   215 205                 420
1672324 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_12 241 30 56 2   4     2   10   180 165 *                     345.0 241 30 56 2   4     2   10   180 165                 345
1673162 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston - Jeremiah E Burke High   Regular School No High 09 12 2021   grade_12 1 75 34 0   0     2   4   66 50 *                     116.0 1 75 34 0   0     2   4   66 50                 116
1673222 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_12 192 26 46 1   135     2   13   191 223 *                     415.0 192 26 46 1   135     2   13   191 223                 415
1673714 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_12 182 128 60 2   47     2   30   225 225 *                     451.0 182 128 60 2   47     2   30   225 225                 451
1676589 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_12 155 109 235 4   8     2   26   274 265 *                     539.0 155 109 235 4   8     2   26   274 265                 539
1680391 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Berkshire Hills - Monument Mt Regional High   Regular School No High 09 12 2021   grade_12 98 4 9 0   3     2   6   65 57 *                     122.0 98 4 9 0   3     2   6   65 57                 122
2040259 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2019   grade_12 220 15 28 0   8     2   5   129 148                       278.0 220 15 28 0   8     2   5   129 148                 278
2041084 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No High 09 12 2019   grade_12 4 31 53 0   6     2   2   35 63                       98.0 4 31 53 0   6     2   2   35 63                 98
2042277 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2019   grade_12 245 36 106 1   23     2   22   217 218                       435.0 245 36 106 1   23     2   22   217 218                 435
2042512 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_12 366 10 11 1   26     2   8   208 215                       424.0 366 10 11 1   26     2   8   208 215                 424
2044413 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_12 133 75 215 2   8     2   18   241 212                       453.0 133 75 215 2   8     2   18   241 212                 453
2045261 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2019   grade_12 222 25 34 1   74     2   10   209 158                       368.0 222 25 34 1   74     2   10   209 158                 368
2046582 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No High 09 12 2019   grade_12 152 49 148 1   20     2   13   188 197                       385.0 152 49 148 1   20     2   13   188 197                 385
2047684 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_12 0 30 8 0   0     2   0   20 20                       40.0 0 30 8 0   0     2   0   20 20                 40
2048257 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2019   grade_12 351 12 0 0   7     2   22   198 196                       394.0 351 12 0 0   7     2   22   198 196                 394
2229059 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_12 289 23 40 2   16     2   18   199 191                       390.0 289 23 40 2   16     2   18   199 191                 390
2229135 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_12 250 29 36 3   13     2   12   169 176                       345.0 250 29 36 3   13     2   12   169 176                 345
2229358 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   grade_12 241 9 10 0   16     2   3   130 151                       281.0 241 9 10 0   16     2   3   130 151                 281
2230516 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_12 150 635 102 4   30     2   27   476 474                       950.0 150 635 102 4   30     2   27   476 474                 950
2234366 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton: Newton North High   Regular School No High 09 12 2018   grade_12 364 29 50 0   87     2   20   282 270                       552.0 364 29 50 0   87     2   20   282 270                 552
2234499 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover: North Andover High   Regular School No High 09 12 2018   grade_12 300 13 27 2   28     2   5   182 195                       377.0 300 13 27 2   28     2   5   182 195                 377
2234642 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading: North Reading High   Regular School No High 09 12 2018   grade_12 198 1 6 0   9     2   1   98 119                       217.0 198 1 6 0   9     2   1   98 119                 217
2234911 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke: Pembroke High School   Regular School No High 09 12 2018   grade_12 259 1 1 0   3     2   2   139 128                       268.0 259 1 1 0   3     2   2   139 128                 268
2235206 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy: Quincy High   Regular School No High 09 12 2018   grade_12 207 38 25 2   80     2   13   189 178                       367.0 207 38 25 2   80     2   13   189 178                 367
2239091 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Hampden-Wilbraham: Minnechaug Regional High   Regular School No High 09 12 2018   grade_12 241 8 17 1   4     2   3   130 146                       276.0 241 8 17 1   4     2   3   130 146                 276
2239512 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake: Silver Lake Regional High   Regular School No High 09 12 2018   grade_12 311 3 4 0   4     2   1   160 165                       325.0 311 3 4 0   4     2   1   160 165                 325
2239723 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett: Wachusett Regional High   Regular School No High 09 12 2018   grade_12 434 12 18 0   20     2   7   222 271                       493.0 434 12 18 0   20     2   7   222 271                 493
735855 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2015   grade_12 244 10 16 0   33     1   8   158 154                       312 244 10 16 0   33     1   8   158 154                 312
736865 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative Education School No 3 11 12 2015   grade_12 5 75 39 1   7     1   5   70 63                       133 5 75 39 1   7     1   5   70 63                 133
736893 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_12 31 91 57 0   57     1   1   111 127                       238 31 91 57 0   57     1   1   111 127                 238
736907 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2015   grade_12 2 64 22 1   6     1   3   45 54                       99 2 64 22 1   6     1   3   45 54                 99
736928 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_12 2 101 16 1   5     1   2   61 67                       128 2 101 16 1   5     1   2   61 67                 128
737172 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No 3 08 12 2015   grade_12 12 23 6 1   1     1   0   20 24                       44 12 23 6 1   1     1   0   20 24                 44
737301 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2015   grade_12 187 9 9 0   39     1   9   127 127                       254 187 9 9 0   39     1   9   127 127                 254
737734 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2015   grade_12 229 9 4 1   9     1   1   124 130                       254 229 9 4 1   9     1   1   124 130                 254
738349 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2015   grade_12 367 1 7 1   13     1   7   196 201                       397 367 1 7 1   13     1   7   196 201                 397
738553 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_12 96 0 1 0   8     1   4   47 63                       110 96 0 1 0   8     1   4   47 63                 110
738682 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2015   grade_12 35 11 8 0   7     1   3   32 33                       65 35 11 8 0   7     1   3   32 33                 65
738849 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No 3 09 12 2015   grade_12 93 2 4 0   0     1   0   57 43                       100 93 2 4 0   0     1   0   57 43                 100
739067 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_12 58 1 1 1   2     1   0   39 25                       64 58 1 1 1   2     1   0   39 25                 64
739393 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2015   grade_12 102 2 1 1   1     1   0   53 55                       108 102 2 1 1   1     1   0   53 55                 108
739623 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_12 288 9 5 3   18     1   3   152 175                       327 288 9 5 3   18     1   3   152 175                 327
739989 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No 3 09 12 2015   grade_12 88 1 2 0   2     1   1   53 42                       95 88 1 2 0   2     1   1   53 42                 95
740099 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No 3 09 12 2015   grade_12 272 21 16 0   25     1   15   186 164                       350 272 21 16 0   25     1   15   186 164                 350
740290 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_12 2 4 9 0   0     1   2   12 6                       18 2 4 9 0   0     1   2   12 6                 18
741131 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2015   grade_12 209 37 31 6   80     1   5   202 167                       369 209 37 31 6   80     1   5   202 167                 369
742252 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_12 269 39 39 0   4     1   18   206 164                       370 269 39 39 0   4     1   18   206 164                 370
742360 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No 3 09 12 2015   grade_12 251 3 3 1   6     1   1   131 135                       266 251 3 3 1   6     1   1   131 135                 266
742453 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No 3 09 12 2015   grade_12 158 37 104 0   10     1   7   163 154                       317 158 37 104 0   10     1   7   163 154                 317
742609 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley Sr High   Regular School No 3 09 12 2015   grade_12 261 13 14 0   33     1   8   167 163                       330 261 13 14 0   33     1   8   167 163                 330
742875 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No 3 09 12 2015   grade_12 215 10 2 2   21     1   2   123 130                       253 215 10 2 2   21     1   2   123 130                 253
743098 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No 3 09 12 2015   grade_12 248 20 23 0   21     1   7   166 154                       320 248 20 23 0   21     1   7   166 154                 320

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