Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by native_hawaiian_pacific_islander_int descending

View and edit SQL

year

grade

  • grade_9 · 2,737
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
738421 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2015   grade_9 205 2 22 0   3     5   4   118 123                       241 205 2 22 0   3     5   4   118 123                 241
740275 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_9 213 54 248 8   3     4   27   322 235                       557 213 54 248 8   3     4   27   322 235                 557
1367509 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2020   grade_9 172 3 32 1   1     4   17   147 83 *                     230.0 172 3 32 1   1     4   17   147 83                 230
1367584 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_9 28 2 4 0   0     4   0   17 21 *                     38.0 28 2 4 0   0     4   0   17 21                 38
1681344 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Regional Vocational Technical - Franklin County Technical   Career and Technical School No High 09 12 2021   grade_9 152 1 11 1   0     4   2   89 82 *                     171.0 152 1 11 1   0     4   2   89 82                 171
2041311 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_9 174 708 154 3   20     4   45   585 523                       1108.0 174 708 154 3   20     4   45   585 523                 1108
740019 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2015   grade_9 158 65 8 0   17     3   10   129 132                       261 158 65 8 0   17     3   10   129 132                 261
934024 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_9 267 694 166 5   26     3   51   637 575                       1212 267 694 166 5   26     3   51   637 575                 1212
939058 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2016   grade_9 339 69 58 0   14     3   22   272 233                       505 339 69 58 0   14     3   22   272 233                 505
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
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 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
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 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
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
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
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
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
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
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
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
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
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
740409 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_9 368 25 44 0   81     2   19   275 264                       539 368 25 44 0   81     2   19   275 264                 539
740651 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2015   grade_9 206 1 7 0   9     2   1   103 123                       226 206 1 7 0   9     2   1   103 123                 226
740878 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2015   grade_9 267 2 1 0   3     2   2   149 128                       277 267 2 1 0   3     2   2   149 128                 277
742179 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2015   grade_9 131 7 18 0   4     2   1   81 82                       163 131 7 18 0   4     2   1   81 82                 163
744410 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No 3 09 12 2015   grade_9 251 10 21 1   4     2   5   148 146                       294 251 10 21 1   4     2   5   148 146                 294
744777 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No 3 09 12 2015   grade_9 313 4 2 0   5     2   3   164 165                       329 313 4 2 0   5     2   3   164 165                 329
744970 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2015   grade_9 443 10 18 0   23     2   9   216 289                       505 443 10 18 0   23     2   9   216 289                 505
932847 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_9 284 30 28 3   16     2   21   186 198                       384 284 30 28 3   16     2   21   186 198                 384
932862 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2016   grade_9 152 18 14 1   19     2   16   115 107                       222 152 18 14 1   19     2   16   115 107                 222
932984 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2016   grade_9 234 14 30 0   8     2   7   132 163                       295 234 14 30 0   8     2   7   132 163                 295
933666 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2016   grade_9 3 49 102 0   3     2   1   91 69                       160 3 49 102 0   3     2   1   91 69                 160
933797 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No 3 09 12 2016   grade_9 8 47 79 0   9     2   1   77 69                       146 8 47 79 0   9     2   1   77 69                 146
934974 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2016   grade_9 330 48 149 2   29     2   29   312 277                       589 330 48 149 2   29     2   29   312 277                 589
935200 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2016   grade_9 380 7 5 2   26     2   8   209 221                       430 380 7 5 2   26     2   8   209 221                 430
937359 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2016   grade_9 311 10 34 0   22     2   5   186 198                       384 311 10 34 0   22     2   5   186 198                 384
937957 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2016   grade_9 252 21 27 1   61     2   14   225 153                       378 252 21 27 1   61     2   14   225 153                 378
939258 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No 3 09 12 2016   grade_9 154 36 145 1   18     2   13   178 191                       369 154 36 145 1   18     2   13   178 191                 369
1122344 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2017   grade_9 151 17 21 0   26     2   9   111 115                       226 151 17 21 0   26     2   9   111 115                 226
1124806 MA Bristol   school 2504830 95   Fall River 250483002660 950325 Resiliency Preparatory School   Regular School No High 09 12 2017   grade_9 27 6 16 0   0     2   3   30 24                       54 27 6 16 0   0     2   3   30 24                 54
1125093 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2017   grade_9 389 4 8 0   19     2   14   219 217                       436 389 4 8 0   19     2   14   219 217                 436
1125998 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2017   grade_9 136 27 100 0   5     2   10   162 118                       280 136 27 100 0   5     2   10   162 118                 280
1128425 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2017   grade_9 17 122 24 0   28     2   4   109 88                       197 17 122 24 0   28     2   4   109 88                 197
1129702 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_9 334 76 63 0   9     2   18   249 253                       502 334 76 63 0   9     2   18   249 253                 502
1132496 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2017   grade_9 273 6 22 0   36     2   11   176 174                       350 273 6 22 0   36     2   11   176 174                 350
1132967 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2017   grade_9 244 7 7 0   7     2   4   133 138                       271 244 7 7 0   7     2   4   133 138                 271
1365935 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2020   grade_9 14 130 194 0   4     2   7   209 142 *                     351.0 14 130 194 0   4     2   7   209 142                 351
1365982 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_9 191 41 65 0   130     2   23   211 239 *                     452.0 191 41 65 0   130     2   23   211 239                 452
1367711 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No High 09 12 2020   grade_9 259 22 204 0   11     2   8   268 238 *                     506.0 259 22 204 0   11     2   8   268 238                 506
1372456 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_9 26 14 130 4   2     2   0   83 95 *                     178.0 26 14 130 4   2     2   0   83 95                 178
1373689 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2020   grade_9 234 4 20 3   42     2   16   159 162 *                     321.0 234 4 20 3   42     2   16   159 162                 321
1673474 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_9 187 617 165 1   24     2   48   589 455 *                     1044.0 187 617 165 1   24     2   48   589 455                 1044
1674955 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill - Haverhill High   Regular School No High 09 12 2021   grade_9 274 28 202 2   6     2   5   277 242 *                     519.0 274 28 202 2   6     2   5   277 242                 519
1677432 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy - Quincy High   Regular School No High 09 12 2021   grade_9 167 32 44 0   79     2   11   169 165 *                     335.0 167 32 44 0   79     2   11   169 165                 335
1677436 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 Quincy - North Quincy High   Regular School No High 09 12 2021   grade_9 145 7 12 2   167     2   18   192 161 *                     353.0 145 7 12 2   167     2   18   192 161                 353
1678403 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton - Stoughton High   Regular School No High 09 12 2021   grade_9 146 81 24 1   24     2   12   175 115 *                     290.0 146 81 24 1   24     2   12   175 115                 290
1678552 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_9 314 122 79 5   5     2   38   293 272 *                     565.0 314 122 79 5   5     2   38   293 272                 565
1680374 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley School District - Ayer Shirley Regional High School   Regular School No High 09 12 2021   grade_9 75 2 11 1   5     2   3   54 45 *                     99.0 75 2 11 1   5     2   3   54 45                 99
1680944 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Northboro-Southboro - Algonquin Regional High   Regular School No High 09 12 2021   grade_9 214 7 25 0   47     2   19   151 163 *                     314.0 214 7 25 0   47     2   19   151 163                 314
1681511 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School (District) - Map Academy Charter School   Regular School Yes High 09 12 2021   grade_9 21 7 7 0   0     2   2   24 15 *                     39.0 21 7 7 0   0     2   2   24 15                 39
2041189 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2019   grade_9 294 13 19 0   79     2   7   205 209                       414.0 294 13 19 0   79     2   7   205 209                 414
2041549 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_9 198 143 77 3   44     2   45   262 250                       512.0 198 143 77 3   44     2   45   262 250                 512
2042509 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_9 383 6 15 0   33     2   6   221 224                       445.0 383 6 15 0   33     2   6   221 224                 445
2042581 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2019   grade_9 193 5 32 0   2     2   4   131 107                       238.0 193 5 32 0   2     2   4   131 107                 238
2043535 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2019   grade_9 106 3 11 1   2     2   1   63 63                       126.0 106 3 11 1   2     2   1   63 63                 126
2044159 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2019   grade_9 185 40 17 2   15     2   10   134 137                       271.0 185 40 17 2   15     2   10   134 137                 271
2044896 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2019   grade_9 78 4 10 0   1     2   4   44 55                       99.0 78 4 10 0   1     2   4   44 55                 99
2045295 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2019   grade_9 16 108 31 0   29     2   11   116 81                       197.0 16 108 31 0   29     2   11   116 81                 197
2047124 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No High 09 12 2019   grade_9 247 1 13 1   64     2   16   169 175                       344.0 247 1 13 1   64     2   16   169 175                 344
2047536 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2019   grade_9 6 33 41 1   2     2   1   47 39                       86.0 6 33 41 1   2     2   1   47 39                 86
2048581 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2019   grade_9 99 10 30 5   2     2   5   97 56                       153.0 99 10 30 5   2     2   5   97 56                 153
2048737 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2019   grade_9 241 6 9 0   4     2   4   120 146                       266.0 241 6 9 0   4     2   4   120 146                 266
2048750 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2019   grade_9 261 3 12 1   42     2   13   156 178                       334.0 261 3 12 1   42     2   13   156 178                 334
2049241 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 238 3 17 1   4     2   10   174 101                       275.0 238 3 17 1   4     2   10   174 101                 275
2229056 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_9 309 27 66 1   25     2   26   242 214                       456.0 309 27 66 1   25     2   26   242 214                 456
2230167 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston: Boston Latin   Regular School No High 07 12 2018   grade_9 201 32 50 2   140     2   16   205 238                       443.0 201 32 50 2   140     2   16   205 238                 443
2230182 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_9 39 141 148 1   60     2   6   178 219                       397.0 39 141 148 1   60     2   6   178 219                 397
2230785 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge: Cambridge Rindge and Latin   Regular School No High 09 12 2018   grade_9 183 140 71 2   50     2   36   253 231                       484.0 183 140 71 2   50     2   36   253 231                 484
2234203 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_9 172 81 227 4   5     2   26   284 233                       517.0 172 81 227 4   5     2   26   284 233                 517
2236780 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware: Ware Junior/Senior High School   Regular School No High 07 12 2018   grade_9 64 2 9 0   0     2   2   42 37                       79.0 64 2 9 0   0     2   2   42 37                 79
2238691 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Berkshire Hills: Monument Mt Regional High   Regular School No High 09 12 2018   grade_9 103 4 10 0   3     2   6   69 59                       128.0 103 4 10 0   3     2   6   69 59                 128
2240033 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District: TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_9 207 16 40 2   9     2   20   133 163                       296.0 207 16 40 2   9     2   20   133 163                 296
735710 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_9 281 6 15 0   7     1   7   172 145                       317 281 6 15 0   7     1   7   172 145                 317
736002 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2015   grade_9 169 3 5 1   2     1   3   97 87                       184 169 3 5 1   2     1   3   97 87                 184
736841 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2015   grade_9 4 32 19 0   4     1   2   33 29                       62 4 32 19 0   4     1   2   33 29                 62
736856 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_9 90 97 68 1   73     1   6   144 192                       336 90 97 68 1   73     1   6   144 192                 336
736925 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_9 7 113 39 1   5     1   2   97 71                       168 7 113 39 1   5     1   2   97 71                 168
737039 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No 3 09 12 2015   grade_9 336 17 11 1   47     1   2   200 215                       415 336 17 11 1   47     1   2   200 215                 415
737298 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2015   grade_9 173 11 10 2   33     1   4   117 117                       234 173 11 10 2   33     1   4   117 117                 234
737428 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No 3 09 12 2015   grade_9 180 25 10 0   24     1   7   130 117                       247 180 25 10 0   24     1   7   130 117                 247
737452 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_9 120 2 2 1   0     1   1   61 66                       127 120 2 2 1   0     1   1   61 66                 127
737590 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No 3 09 12 2015   grade_9 139 6 83 0   11     1   4   112 132                       244 139 6 83 0   11     1   4   112 132                 244
737704 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2015   grade_9 209 7 10 0   3     1   4   120 114                       234 209 7 10 0   3     1   4   120 114                 234
738153 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_9 186 8 10 1   6     1   18   114 116                       230 186 8 10 1   6     1   18   114 116                 230
738194 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2015   grade_9 101 19 146 0   20     1   11   150 148                       298 101 19 146 0   20     1   11   150 148                 298
738233 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No 3 09 12 2015   grade_9 171 14 2 0   3     1   0   104 87                       191 171 14 2 0   3     1   0   104 87                 191
739108 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Vocational Education School No 3 09 12 2015   grade_9 187 26 121 1   19     1   6   208 153                       361 187 26 121 1   19     1   6   208 153                 361
739197 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2015   grade_9 93 3 2 0   3     1   3   52 53                       105 93 3 2 0   3     1   3   52 53                 105

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