Data source: Big Local News · About: Big Local

396 rows where grade = "grade_10", state = "MA" and year = 2019 sorted by black descending

View and edit SQL

year

  • 2019 · 396

grade

  • grade_10 · 396
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
2040979 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2019   grade_10 3 98 164 0   4     0   3   175 97                       272.0 3 98 164 0   4     0   3   175 97                 272
2041072 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_10 4 94 35 1   5     0   4   64 79                       143.0 4 94 35 1   5     0   4   64 79                 143
2039953 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_10 324 9 21 0   96     0   10   209 250                       460.0 324 9 21 0   96     0   10   209 250                 460
2041773 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2019   grade_10 81 9 32 0   4     0   2   67 61                       128.0 81 9 32 0   4     0   2   67 61                 128
2046110 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2019   grade_10 9 9 28 0   0     0   1   17 30                       47.0 9 9 28 0   0     0   1   17 30                 47
2046303 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No High 09 12 2019   grade_10 148 9 23 0   1     0   5   86 100                       186.0 148 9 23 0   1     0   5   86 100                 186
2046942 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield High   Regular School No High 09 12 2019   grade_10 205 9 60 0   24     0   3   139 162                       301.0 205 9 60 0   24     0   3   139 162                 301
2048551 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No High 09 12 2019   grade_10 283 9 8 0   6     0   6   158 154                       312.0 283 9 8 0   6     0   6   158 154                 312
2048582 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2019   grade_10 121 9 26 6   3     1   5   85 86                       171.0 121 9 26 6   3     1   5   85 86                 171
2049142 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2019   grade_10 264 9 9 2   3     0   8   137 158                       295.0 264 9 9 2   3     0   8   137 158                 295
2043748 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2019   grade_10 115 88 118 1   104     0   14   253 186                       440.0 115 88 118 1   104     0   14   253 186                 440
2042161 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2019   grade_10 102 86 214 0   25     0   11   230 208                       438.0 102 86 214 0   25     0   11   230 208                 438
2043494 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_10 202 83 203 1   251     0   25   370 395                       765.0 202 83 203 1   251     0   25   370 395                 765
2047935 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_10 1 83 63 0   0     0   0   80 67                       147.0 1 83 63 0   0     0   0   80 67                 147
2049329 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_10 1 81 5 0   5     0   0   45 47                       92.0 1 81 5 0   5     0   0   45 47                 92
2047477 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2019   grade_10 55 80 169 1   22     0   12   172 167                       339.0 55 80 169 1   22     0   12   172 167                 339
2042310 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2019   grade_10 175 8 7 2   5     0   8   96 108                       205.0 175 8 7 2   5     0   8   96 108                 205
2042605 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2019   grade_10 161 8 6 0   11     0   6   94 98                       192.0 161 8 6 0   11     0   6   94 98                 192
2043818 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2019   grade_10 105 8 135 0   3     0   6   127 130                       257.0 105 8 135 0   3     0   6   127 130                 257
2044273 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No High 09 12 2019   grade_10 349 8 19 0   34     0   18   209 219                       428.0 349 8 19 0   34     0   18   209 219                 428
2044972 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No High 09 12 2019   grade_10 272 8 59 0   6     0   7   185 166                       352.0 272 8 59 0   6     0   7   185 166                 352
2045500 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2019   grade_10 95 8 115 0   12     0   5   125 110                       235.0 95 8 115 0   12     0   5   125 110                 235
2046141 MA Hampden   school 2511130 281   Springfield 251113002724 2810570 Springfield High School   Regular School No High 09 12 2019   grade_10 6 8 25 0   0     0   0   25 14                       39.0 6 8 25 0   0     0   0   25 14                 39
2046642 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No High 09 12 2019   grade_10 109 8 44 2   18     0   4   95 90                       185.0 109 8 44 2   18     0   4   95 90                 185
2047454 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_10 6 8 47 0   7     0   1   40 29                       69.0 6 8 47 0   7     0   1   40 29                 69
2047530 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_10 13 8 148 1   0     0   1   90 81                       171.0 13 8 148 1   0     0   1   90 81                 171
2047559 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_10 33 8 3 0   0     0   1   22 23                       45.0 33 8 3 0   0     0   1   22 23                 45
2048098 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_10 243 8 11 1   143     0   23   223 206                       429.0 243 8 11 1   143     0   23   223 206                 429
2049210 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Career and Technical School No High 09 12 2019   grade_10 158 8 5 0   6     0   3   109 69                       180.0 158 8 5 0   6     0   3   109 69                 180
2049246 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 159 8 6 2   3     0   10   125 63                       188.0 159 8 6 2   3     0   10   125 63                 188
2045296 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2019   grade_10 11 75 23 0   40     1   6   97 59                       156.0 11 75 23 0   40     1   6   97 59                 156
2046220 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No High 09 12 2019   grade_10 147 75 24 0   19     0   7   132 140                       272.0 147 75 24 0   19     0   7   132 140                 272
2041006 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_10 98 72 98 1   84     1   8   156 206                       362.0 98 72 98 1   84     1   8   156 206                 362
2040958 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2019   grade_10 1 7 3 0   0     0   1   9 3                       12.0 1 7 3 0   0     0   1   9 3                 12
2041749 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2019   grade_10 218 7 83 2   12     0   9   185 146                       331.0 218 7 83 2   12     0   9   185 146                 331
2043356 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2019   grade_10 182 7 6 1   23     0   8   112 115                       227.0 182 7 6 1   23     0   8   112 115                 227
2043785 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2019   grade_10 230 7 17 0   7     0   6   129 138                       267.0 230 7 17 0   7     0   6   129 138                 267
2044624 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2019   grade_10 170 7 21 0   6     0   8   105 107                       212.0 170 7 21 0   6     0   8   105 107                 212
2044697 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2019   grade_10 213 7 10 0   15     0   9   137 117                       254.0 213 7 10 0   15     0   9   137 117                 254
2045557 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No High 09 12 2019   grade_10 126 7 32 1   6     0   1   93 79                       173.0 126 7 32 1   6     0   1   93 79                 173
2045596 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2019   grade_10 236 7 3 0   3     0   3   124 128                       252.0 236 7 3 0   3     0   3   124 128                 252
2046763 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No High 09 12 2019   grade_10 205 7 16 0   76     1   9   167 147                       314.0 205 7 16 0   76     1   9   167 147                 314
2046892 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston High   Regular School No High 09 12 2019   grade_10 112 7 7 0   31     0   12   90 79                       169.0 112 7 7 0   31     0   12   90 79                 169
2047942 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes High 06 12 2019   grade_10 26 7 27 0   4     0   1   28 37                       65.0 26 7 27 0   4     0   1   28 37                 65
2048038 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2019   grade_10 15 7 1 0   4     0   5   14 18                       32.0 15 7 1 0   4     0   5   14 18                 32
2048531 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2019   grade_10 215 7 14 1   9     0   10   118 138                       256.0 215 7 14 1   9     0   10   118 138                 256
2048787 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2019   grade_10 177 7 2 1   4     0   5   93 103                       196.0 177 7 2 1   4     0   5   93 103                 196
2049202 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 283 7 61 0   6     0   10   176 189                       367.0 283 7 61 0   6     0   10   176 189                 367
2049214 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2019   grade_10 194 7 119 0   1     1   7   176 153                       329.0 194 7 119 0   1     1   7   176 153                 329
2049313 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_10 16 7 7 0   1     0   2   16 17                       33.0 16 7 7 0   1     0   2   16 17                 33
2047472 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2019   grade_10 168 69 131 1   27     0   18   223 191                       414.0 168 69 131 1   27     0   18   223 191                 414
2046153 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2019   grade_10 28 68 255 0   3     0   3   174 183                       357.0 28 68 255 0   3     0   3   174 183                 357
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
2047467 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2019   grade_10 63 64 121 0   10     0   12   144 126                       270.0 63 64 121 0   10     0   12   144 126                 270
2046129 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2019   grade_10 18 63 204 0   2     1   0   151 137                       288.0 18 63 204 0   2     1   0   151 137                 288
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
2039821 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_10 127 6 13 0   2     0   1   79 70                       149.0 127 6 13 0   2     0   1   79 70                 149
2040172 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_10 132 6 4 0   5     0   5   89 63                       152.0 132 6 4 0   5     0   5   89 63                 152
2041000 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2019   grade_10 0 6 11 1   1     0   1   9 11                       20.0 0 6 11 1   1     0   1   9 11                 20
2041055 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No High 09 12 2019   grade_10 12 6 13 0   1     0   3   18 17                       35.0 12 6 13 0   1     0   3   18 17                 35
2041885 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2019   grade_10 235 6 10 0   1     0   20   127 145                       272.0 235 6 10 0   1     0   20   127 145                 272
2044050 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2019   grade_10 260 6 201 1   25     0   25   280 238                       518.0 260 6 201 1   25     0   25   280 238                 518
2044070 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2019   grade_10 169 6 3 4   2     0   6   100 90                       190.0 169 6 3 4   2     0   6   100 90                 190
2044425 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2019   grade_10 4 6 15 0   0     0   2   21 6                       27.0 4 6 15 0   0     0   2   21 6                 27
2045150 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth North High   Regular School No High 09 12 2019   grade_10 258 6 15 0   4     0   13   144 152                       296.0 258 6 15 0   4     0   13   144 152                 296
2046682 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No High 09 12 2019   grade_10 60 6 30 0   1     0   10   58 49                       107.0 60 6 30 0   1     0   10   58 49                 107
2046830 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No High 09 12 2019   grade_10 226 6 38 1   10     0   3   126 158                       284.0 226 6 38 1   10     0   3   126 158                 284
2047899 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2019   grade_10 40 6 12 1   1     0   3   22 41                       63.0 40 6 12 1   1     0   3   22 41                 63
2047981 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2019   grade_10 188 6 5 0   11     1   9   97 123                       220.0 188 6 5 0   11     1   9   97 123                 220
2048751 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2019   grade_10 305 6 22 2   46     0   13   198 196                       394.0 305 6 22 2   46     0   13   198 196                 394
2048895 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2019   grade_10 78 6 13 0   2     0   6   52 53                       105.0 78 6 13 0   2     0   6   52 53                 105
2049302 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes High 09 12 2019   grade_10 24 6 27 0   2     0   1   28 32                       60.0 24 6 27 0   2     0   1   28 32                 60
2047482 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No High 09 12 2019   grade_10 74 57 153 0   40     0   14   157 181                       338.0 74 57 153 0   40     0   14   157 181                 338
2047487 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2019   grade_10 138 57 138 1   24     0   16   191 183                       374.0 138 57 138 1   24     0   16   191 183                 374
2040953 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2019   grade_10 9 56 83 0   23     0   2   103 70                       173.0 9 56 83 0   23     0   2   103 70                 173
2044160 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2019   grade_10 174 56 13 0   16     0   13   141 130                       272.0 174 56 13 0   16     0   13   141 130                 272
2040944 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2019   grade_10 3 55 60 0   4     1   1   83 41                       124.0 3 55 60 0   4     1   1   83 41                 124
2041050 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2019   grade_10 1 55 25 0   0     0   0   44 37                       81.0 1 55 25 0   0     0   0   44 37                 81
2047566 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2019   grade_10 2 55 27 0   1     0   0   39 46                       85.0 2 55 27 0   1     0   0   39 46                 85
2042275 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2019   grade_10 308 52 151 1   28     0   24   278 286                       564.0 308 52 151 1   28     0   24   278 286                 564
2046580 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No High 09 12 2019   grade_10 170 52 164 0   16     0   11   223 189                       413.0 170 52 164 0   16     0   11   223 189                 413
2040995 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_10 2 50 30 0   1     0   1   45 39                       84.0 2 50 30 0   1     0   1   45 39                 84
2047964 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_10 9 50 23 0   9     0   1   48 44                       92.0 9 50 23 0   9     0   1   48 44                 92
2049155 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 125 50 24 1   5     0   9   117 97                       214.0 125 50 24 1   5     0   9   117 97                 214
2040153 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2019   grade_10 157 5 3 1   3     0   5   85 89                       174.0 157 5 3 1   3     0   5   85 89                 174
2041107 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 09 12 2019   grade_10 2 5 10 0   0     0   1   8 10                       18.0 2 5 10 0   0     0   1   8 10                 18
2042281 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_10 23 5 14 0   0     0   3   22 23                       45.0 23 5 14 0   0     0   3   22 23                 45
2042942 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2019   grade_10 66 5 311 1   2     0   3   213 175                       388.0 66 5 311 1   2     0   3   213 175                 388
2043521 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2019   grade_10 200 5 15 0   0     0   9   116 112                       229.0 200 5 15 0   0     0   9   116 112                 229
2043873 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2019   grade_10 92 5 7 9   5     0   2   56 64                       120.0 92 5 7 9   5     0   2   56 64                 120
2044912 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   grade_10 63 5 3 0   2     0   3   34 42                       76.0 63 5 3 0   2     0   3   34 42                 76
2046613 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No High 08 12 2019   grade_10 61 5 6 2   1     0   8   39 44                       83.0 61 5 6 2   1     0   8   39 44                 83
2046981 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2019   grade_10 214 5 10 0   18     0   2   111 138                       249.0 214 5 10 0   18     0   2   111 138                 249
2047125 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No High 09 12 2019   grade_10 276 5 17 1   59     0   8   172 194                       366.0 276 5 17 1   59     0   8   172 194                 366
2047448 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2019   grade_10 3 5 22 0   9     0   0   14 25                       39.0 3 5 22 0   9     0   0   14 25                 39
2048738 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2019   grade_10 222 5 4 0   9     0   3   125 118                       243.0 222 5 4 0   9     0   3   125 118                 243
2048908 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2019   grade_10 269 5 4 0   3     0   1   144 138                       282.0 269 5 4 0   3     0   1   144 138                 282
2049234 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2019   grade_10 148 5 5 0   3     0   2   108 55                       163.0 148 5 5 0   3     0   2   108 55                 163
2049262 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2019   grade_10 3 5 65 0   0     0   0   26 47                       73.0 3 5 65 0   0     0   0   26 47                 73
2047668 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2019   grade_10 1 49 26 0   0     0   0   44 32                       76.0 1 49 26 0   0     0   0   44 32                 76

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