Data source: Big Local News · About: Big Local

2,758 rows where grade = "grade_10" and state = "MA" sorted by native_hawaiian_pacific_islander descending

View and edit SQL

year

grade

  • grade_10 · 2,758
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
935273 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2016   grade_10 186 2 18 0   3     5   3   110 107                       217 186 2 18 0   3     5   3   110 107                 217
737596 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2015   grade_10 247 9 86 1   12     4   9   212 156                       368 247 9 86 1   12     4   9   212 156                 368
937114 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_10 123 50 189 4   4     4   19   216 177                       393 123 50 189 4   4     4   19   216 177                 393
1129703 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_10 314 71 57 0   14     4   23   261 221                       483 314 71 57 0   14     4   23   261 221                 483
1674835 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley - Hopkins Academy   Regular School No High 07 12 2021   grade_10 30 1 3 0   0     4   0   18 20 *                     38.0 30 1 3 0   0     4   0   18 20                 38
2041312 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_10 197 601 130 3   22     4   38   541 454                       995.0 197 601 130 3   22     4   38   541 454                 995
737165 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_10 220 623 140 4   27     3   25   503 539                       1042 220 623 140 4   27     3   25   503 539                 1042
740276 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_10 297 93 274 3   5     3   32   369 338                       707 297 93 274 3   5     3   32   369 338                 707
740525 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2015   grade_10 254 10 25 0   23     3   10   150 175                       325 254 10 25 0   23     3   10   150 175                 325
934025 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_10 183 648 120 4   34     3   30   535 487                       1022 183 648 120 4   34     3   30   535 487                 1022
936867 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2016   grade_10 160 62 8 0   18     3   10   131 130                       261 160 62 8 0   18     3   10   131 130                 261
1122327 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_10 273 28 34 5   12     3   17   175 197                       372 273 28 34 5   12     3   17   175 197                 372
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
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
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 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
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
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
740670 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No 3 09 12 2015   grade_10 192 3 0 0   1     2   2   98 102                       200 192 3 0 0   1     2   2   98 102                 200
741025 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No 3 09 12 2015   grade_10 212 4 3 4   2     2   9   125 111                       236 212 4 3 4   2     2   9   125 111                 236
742180 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2015   grade_10 157 11 10 0   0     2   4   100 84                       184 157 11 10 0   0     2   4   100 84                 184
742358 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No 3 09 12 2015   grade_10 215 5 6 1   3     2   5   116 121                       237 215 5 6 1   3     2   5   116 121                 237
742720 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No 3 09 12 2015   grade_10 265 10 37 0   8     2   6   140 188                       328 265 10 37 0   8     2   6   140 188                 328
744387 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No 3 09 12 2015   grade_10 143 1 1 0   6     2   7   73 87                       160 143 1 1 0   6     2   7   73 87                 160
932729 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2016   grade_10 257 14 12 0   22     2   6   157 156                       313 257 14 12 0   22     2   6   157 156                 313
932785 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2016   grade_10 312 24 54 2   21     2   23   230 208                       438 312 24 54 2   21     2   23   230 208                 438
932848 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_10 275 28 40 6   16     2   14   187 194                       381 275 28 40 6   16     2   14   187 194                 381
933033 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2016   grade_10 283 6 11 0   16     2   5   160 163                       323 283 6 11 0   16     2   5   160 163                 323
934710 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2016   grade_10 153 8 3 0   0     2   2   84 84                       168 153 8 3 0   0     2   2   84 84                 168
936223 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No 3 09 12 2016   grade_10 209 3 24 1   1     2   5   119 126                       245 209 3 24 1   1     2   5   119 126                 245
937246 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2016   grade_10 370 24 43 0   81     2   20   280 260                       540 370 24 43 0   81     2   20   280 260                 540
937481 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2016   grade_10 204 1 6 0   9     2   1   104 119                       223 204 1 6 0   9     2   1   104 119                 223
937707 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2016   grade_10 268 1 1 0   3     2   2   146 131                       277 268 1 1 0   3     2   2   146 131                 277
937958 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2016   grade_10 213 35 25 3   77     2   12   196 171                       367 213 35 25 3   77     2   12   196 171                 367
938989 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2016   grade_10 132 7 17 0   4     2   1   81 82                       163 132 7 17 0   4     2   1   81 82                 163
941237 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No 3 09 12 2016   grade_10 239 10 19 1   3     2   5   137 142                       279 239 10 19 1   3     2   5   137 142                 279
941604 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No 3 09 12 2016   grade_10 312 4 5 0   4     2   1   164 164                       328 312 4 5 0   4     2   1   164 164                 328
941792 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2016   grade_10 447 11 19 0   22     2   8   221 288                       509 447 11 19 0   22     2   8   221 288                 509
1122345 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2017   grade_10 142 18 13 0   17     2   14   106 100                       206 142 18 13 0   17     2   14   106 100                 206
1122492 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2017   grade_10 235 14 35 0   7     2   8   138 163                       301 235 14 35 0   7     2   8   138 163                 301
1123276 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2017   grade_10 4 34 41 0   2     2   0   43 40                       83 4 34 41 0   2     2   0   43 40                 83
1123427 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No High 09 12 2017   grade_10 5 44 67 0   4     2   3   56 69                       125 5 44 67 0   4     2   3   56 69                 125
1124823 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2017   grade_10 283 43 128 0   28     2   29   261 252                       513 283 43 128 0   28     2   29   261 252                 513
1125094 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2017   grade_10 371 7 8 1   27     2   8   205 219                       424 371 7 8 1   27     2   8   205 219                 424
1127385 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_10 160 62 268 6   7     2   22   299 228                       527 160 62 268 6   7     2   22   299 228                 527
1127675 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No High 09 12 2017   grade_10 316 11 31 1   22     2   5   187 201                       388 316 11 31 1   22     2   5   187 201                 388
1128383 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2017   grade_10 243 29 36 1   71     2   12   226 167                       394 243 29 36 1   71     2   12   226 167                 394
1129949 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No High 09 12 2017   grade_10 153 46 168 1   20     2   13   204 199                       403 153 46 168 1   20     2   13   204 199                 403
1131275 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_10 0 36 9 0   0     2   0   24 23                       47 0 36 9 0   0     2   0   24 23                 47
1365900 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2020   grade_10 8 38 68 1   9     2   2   72 56 *                     128.0 8 38 68 1   9     2   2   72 56                 128
1366124 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2020   grade_10 307 14 22 0   87     2   7   221 218 *                     439.0 307 14 22 0   87     2   7   221 218                 439
1366242 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_10 144 547 130 4   22     2   41   449 441 *                     890.0 144 547 130 4   22     2   41   449 441                 890
1366480 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_10 192 140 81 2   51     2   44   270 242 *                     512.0 192 140 81 2   51     2   44   270 242                 512
1367439 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   grade_10 370 5 16 0   33     2   6   214 218 *                     432.0 370 5 16 0   33     2   6   214 218                 432
1368453 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2020   grade_10 103 4 12 2   2     2   1   59 67 *                     126.0 103 4 12 2   2     2   1   59 67                 126
1369824 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2020   grade_10 78 4 9 0   1     2   6   47 53 *                     100.0 78 4 9 0   1     2   6   47 53                 100
1372051 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No High 09 12 2020   grade_10 243 1 13 1   67     2   17   169 175 *                     344.0 243 1 13 1   67     2   17   169 175                 344
1372464 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 2020   grade_10 5 35 37 0   1     2   2   48 34 *                     82.0 5 35 37 0   1     2   2   48 34                 82
1373677 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2020   grade_10 239 6 12 0   4     2   5   126 142 *                     268.0 239 6 12 0   4     2   5   126 142                 268
1673220 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_10 183 39 61 0   126     2   19   202 226 *                     430.0 183 39 61 0   126     2   19   202 226                 430
1673475 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_10 132 759 198 3   27     2   50   651 520 *                     1171.0 132 759 198 3   27     2   50   651 520                 1171
1674745 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester - Gloucester High   Regular School No High 09 12 2021   grade_10 148 3 33 1   2     2   13   121 81 *                     202.0 148 3 33 1   2     2   13   121 81                 202
1674956 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill - Haverhill High   Regular School No High 09 12 2021   grade_10 240 23 154 0   12     2   8   229 210 *                     439.0 240 23 154 0   12     2   8   229 210                 439
1679721 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_10 25 14 128 3   2     2   0   81 93 *                     174.0 25 14 128 3   2     2   0   81 93                 174
1680945 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Northboro-Southboro - Algonquin Regional High   Regular School No High 09 12 2021   grade_10 231 4 23 3   43     2   15   155 166 *                     321.0 231 4 23 3   43     2   15   155 166                 321
2040060 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2019   grade_10 295 30 72 1   25     2   27   239 213                       452.0 295 30 72 1   25     2   27   239 213                 452
2040966 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2019   grade_10 1 67 21 0   0     2   2   52 41                       93.0 1 67 21 0   0     2   2   52 41                 93
2041027 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_10 198 30 48 1   138     2   14   197 234                       431.0 198 30 48 1   138     2   14   197 234                 431
2041550 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_10 188 136 74 2   54     2   37   256 237                       493.0 188 136 74 2   54     2   37   256 237                 493
2044411 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_10 159 101 241 3   5     2   26   268 269                       537.0 159 101 241 3   5     2   26   268 269                 537
2048199 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2019   grade_10 102 4 10 0   3     2   6   66 61                       127.0 102 4 10 0   3     2   6   66 61                 127
2049372 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 2019   grade_10 235 18 38 1   9     2   17   124 196                       320.0 235 18 38 1   9     2   17   124 196                 320
2230514 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_10 167 642 144 6   27     2   34   556 466                       1022.0 167 642 144 6   27     2   34   556 466                 1022
2231502 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett: Everett High   Regular School No High 09 12 2018   grade_10 132 91 266 2   27     2   5   271 254                       525.0 132 91 266 2   27     2   5   271 254                 525
2231923 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_10 385 7 9 0   20     2   14   214 223                       437.0 385 7 9 0   20     2   14   214 223                 437
2232815 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Leominster: Center For Technical Education Innovation   Career and Technical School No High 09 12 2018   grade_10 83 10 48 0   2     2   7   98 54                       152.0 83 10 48 0   2     2   7   98 54                 152
2235204 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy: Quincy High   Regular School No High 09 12 2018   grade_10 210 47 22 0   93     2   10   195 189                       384.0 210 47 22 0   93     2   10   195 189                 384
2236520 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_10 308 93 62 0   8     2   19   232 260                       492.0 308 93 62 0   8     2   19   232 260                 492
2239322 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Northboro-Southboro: Algonquin Regional High   Regular School No High 09 12 2018   grade_10 272 5 25 1   37     2   11   182 171                       353.0 272 5 25 1   37     2   11   182 171                 353
2239783 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman-Hanson: Whitman Hanson Regional   Regular School No High 09 12 2018   grade_10 249 7 9 0   7     2   4   136 142                       278.0 249 7 9 0   7     2   4   136 142                 278
735989 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_10 160 15 8 0   22     1   14   112 108                       220 160 15 8 0   22     1   14   112 108                 220
736164 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2015   grade_10 280 6 9 0   12     1   2   148 162                       310 280 6 9 0   12     1   2   148 162                 310
736795 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2015   grade_10 22 107 109 1   6     1   5   146 105                       251 22 107 109 1   6     1   5   146 105                 251
736833 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   grade_10 16 108 140 4   0     1   8   158 119                       277 16 108 140 4   0     1   8   158 119                 277
736877 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_10 189 35 44 0   113     1   13   186 209                       395 189 35 44 0   113     1   13   186 209                 395
736936 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No 3 09 12 2015   grade_10 7 39 32 0   8     1   1   40 48                       88 7 39 32 0   8     1   1   40 48                 88
737040 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No 3 09 12 2015   grade_10 305 20 16 0   35     1   5   183 199                       382 305 20 16 0   35     1   5   183 199                 382
737823 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No 3 09 12 2015   grade_10 156 9 10 0   11     1   4   97 94                       191 156 9 10 0   11     1   4   97 94                 191
738502 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2015   grade_10 38 3 1 0   1     1   2   20 26                       46 38 3 1 0   1     1   2   20 26                 46
738847 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No 3 09 12 2015   grade_10 77 1 4 0   0     1   2   53 32                       85 77 1 4 0   0     1   2   53 32                 85
739198 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2015   grade_10 111 3 2 0   6     1   0   68 55                       123 111 3 2 0   6     1   0   68 55                 123
739518 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2015   grade_10 80 51 220 0   37     1   18   222 185                       407 80 51 220 0   37     1   18   222 185                 407
739607 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_10 123 98 94 1   102     1   22   223 218                       441 123 98 94 1   102     1   22   223 218                 441
739807 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No 3 09 12 2015   grade_10 170 42 17 0   21     1   7   133 125                       258 170 42 17 0   21     1   7   133 125                 258
739987 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No 3 09 12 2015   grade_10 80 0 2 1   2     1   1   44 43                       87 80 0 2 1   2     1   1   44 43                 87
740879 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2015   grade_10 248 1 2 0   0     1   1   132 121                       253 248 1 2 0   0     1   1   132 121                 253
741129 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2015   grade_10 210 40 29 1   70     1   6   182 175                       357 210 40 29 1   70     1   6   182 175                 357
741489 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No 3 09 12 2015   grade_10 234 4 0 0   2     1   1   111 131                       242 234 4 0 0   2     1   1   111 131                 242
742250 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_10 330 49 61 3   11     1   14   219 250                       469 330 49 61 3   11     1   14   219 250                 469
742451 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No 3 09 12 2015   grade_10 182 49 119 0   21     1   7   200 179                       379 182 49 119 0   21     1   7   200 179                 379

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