Data source: Big Local News · About: Big Local

392 rows where grade = "grade_10", state = "MA" and year = 2016 sorted by black descending

View and edit SQL

year

  • 2016 · 392

grade

  • grade_10 · 392
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
933698 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2016   grade_10 7 93 111 0   1     0   6   122 96                       218 7 93 111 0   1     0   6   122 96                 218
933721 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2016   grade_10 88 93 58 1   69     1   6   134 182                       316 88 93 58 1   69     1   6   134 182                 316
938812 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_10 39 92 281 0   5     0   4   226 195                       421 39 92 281 0   5     0   4   226 195                 421
938842 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2016   grade_10 57 90 210 0   6     0   2   166 199                       365 57 90 210 0   6     0   2   166 199                 365
934030 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No 3 08 12 2016   grade_10 9 9 16 0   1     0   5   31 9                       40 9 9 16 0   1     0   5   31 9                 40
935478 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2016   grade_10 299 9 112 0   5     0   4   219 210                       429 299 9 112 0   5     0   4   219 210                 429
936522 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No 3 09 12 2016   grade_10 166 9 100 0   17     0   2   146 148                       294 166 9 100 0   17     0   2   146 148                 294
936803 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2016   grade_10 186 9 87 3   10     1   5   143 158                       301 186 9 87 3   10     1   5   143 158                 301
937850 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth North High   Regular School No 3 09 12 2016   grade_10 284 9 15 1   2     1   8   157 163                       320 284 9 15 1   2     1   8   157 163                 320
938378 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No 3 09 12 2016   grade_10 313 9 30 0   76     1   12   192 249                       441 313 9 30 0   76     1   12   192 249                 441
940801 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2016   grade_10 293 9 12 2   114     0   26   229 227                       456 293 9 12 2   114     0   26   229 227                 456
941090 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2016   grade_10 187 9 7 0   7     1   3   105 109                       214 187 9 7 0   7     1   3   105 109                 214
941335 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2016   grade_10 89 9 7 1   6     0   7   58 61                       119 89 9 7 1   6     0   7   58 61                 119
941861 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Vocational Education School No 3 09 12 2016   grade_10 286 9 24 2   4     0   10   185 150                       335 286 9 24 2   4     0   10   185 150                 335
933685 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2016   grade_10 2 89 34 0   2     0   1   69 59                       128 2 89 34 0   2     0   1   69 59                 128
933671 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2016   grade_10 6 86 96 1   38     0   3   136 94                       230 6 86 96 1   38     0   3   136 94                 230
937995 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No 3 09 12 2016   grade_10 21 86 18 1   34     1   5   94 72                       166 21 86 18 1   34     1   5   94 72                 166
936452 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2016   grade_10 125 83 115 0   108     0   14   228 217                       445 125 83 115 0   108     0   14   228 217                 445
936208 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_10 244 82 185 1   269     0   12   417 376                       793 244 82 185 1   269     0   12   417 376                 793
932985 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2016   grade_10 288 8 25 0   6     0   9   161 175                       336 288 8 25 0   6     0   9   161 175                 336
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
934965 MA Bristol   school 2504830 95   Fall River 250483002660 950325 Resiliency Preparatory School   Regular School No 3 09 12 2016   grade_10 31 8 17 0   2     0   1   31 28                       59 31 8 17 0   2     0   1   31 28                 59
937398 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No 3 09 12 2016   grade_10 266 8 18 2   15     0   4   137 176                       313 266 8 18 2   15     0   4   137 176                 313
939166 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No 3 09 12 2016   grade_10 239 8 8 1   7     1   4   132 136                       268 239 8 8 1   7     1   4   132 136                 268
933769 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2016   grade_10 0 7 2 0   0     0   0   4 5                       9 0 7 2 0   0     0   0   4 5                 9
934759 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No 3 09 12 2016   grade_10 186 7 8 0   10     0   1   102 110                       212 186 7 8 0   10     0   1   102 110                 212
935201 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2016   grade_10 436 7 9 1   16     0   5   241 233                       474 436 7 9 1   16     0   5   241 233                 474
936660 MA Middlesex   school 2507560 176   Medford 250756001174 1760605 Medford Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_10 44 7 4 0   2     0   2   32 27                       59 44 7 4 0   2     0   2   32 27                 59
938132 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No 3 09 12 2016   grade_10 139 7 6 0   2     0   8   81 81                       162 139 7 6 0   2     0   8   81 81                 162
938539 MA Hampshire   school 2510920 278   South Hadley 251092001754 2780505 South Hadley High   Regular School No 3 09 12 2016   grade_10 120 7 9 0   1     1   0   77 61                       138 120 7 9 0   1     1   0   77 61                 138
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
939445 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No 3 09 12 2016   grade_10 188 7 17 0   49     0   7   127 141                       268 188 7 17 0   49     0   7   127 141                 268
939678 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No 3 09 12 2016   grade_10 215 7 6 0   10     0   7   113 132                       245 215 7 6 0   10     0   7   113 132                 245
940714 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes 3 09 12 2016   grade_10 5 7 20 0   0     0   0   20 12                       32 5 7 20 0   0     0   0   20 12                 32
941869 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex Technical High School   Vocational Education School No 3 09 12 2016   grade_10 296 7 37 0   2     1   9   143 209                       352 296 7 37 0   2     1   9   143 209                 352
942019 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_10 28 7 4 0   0     0   1   16 24                       40 28 7 4 0   0     0   1   16 24                 40
940191 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No 3 09 12 2016   grade_10 84 66 173 1   28     0   12   182 182                       364 84 66 173 1   28     0   12   182 182                 364
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
939059 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2016   grade_10 310 63 39 0   10     0   16   225 213                       438 310 63 39 0   10     0   16   225 213                 438
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
933793 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No 3 09 12 2016   grade_10 18 61 51 2   4     0   4   69 71                       140 18 61 51 2   4     0   4   69 71                 140
938817 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2016   grade_10 47 61 271 0   6     1   0   209 177                       386 47 61 271 0   6     1   0   209 177                 386
933764 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2016   grade_10 4 60 21 0   1     0   1   56 31                       87 4 60 21 0   1     0   1   56 31                 87
940187 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No 3 09 12 2016   grade_10 168 60 119 0   42     0   9   224 174                       398 168 60 119 0   42     0   9   224 174                 398
932678 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2016   grade_10 314 6 22 0   63     0   8   197 216                       413 314 6 22 0   63     0   8   197 216                 413
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
934451 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No 3 09 12 2016   grade_10 146 6 95 0   9     1   3   119 141                       260 146 6 95 0   9     1   3   119 141                 260
934481 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2016   grade_10 69 6 39 1   1     0   2   55 63                       118 69 6 39 1   1     0   2   55 63                 118
934564 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2016   grade_10 208 6 10 0   3     0   4   117 114                       231 208 6 10 0   3     0   4   117 114                 231
934591 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2016   grade_10 258 6 7 0   1     0   16   154 134                       288 258 6 7 0   1     0   16   154 134                 288
937854 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No 3 09 12 2016   grade_10 244 6 10 2   3     0   6   144 127                       271 244 6 10 2   3     0   6   144 127                 271
937962 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2016   grade_10 99 6 14 1   174     0   2   152 144                       296 99 6 14 1   174     0   2   152 144                 296
938822 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No 3 09 12 2016   grade_10 6 6 18 0   0     0   0   24 6                       30 6 6 18 0   0     0   0   24 6                 30
939560 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No 3 09 12 2016   grade_10 295 6 4 0   83     0   14   189 213                       402 295 6 4 0   83     0   14   189 213                 402
939773 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2016   grade_10 203 6 6 0   15     1   5   112 124                       236 203 6 6 0   15     1   5   112 124                 236
939830 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No 3 09 12 2016   grade_10 251 6 10 0   55     0   12   186 148                       334 251 6 10 0   55     0   12   186 148                 334
941865 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2016   grade_10 135 6 19 1   0     0   10   111 60                       171 135 6 19 1   0     0   10   111 60                 171
941994 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 4 09 10 2016   grade_10 16 6 11 0   1     0   4   17 21                       38 16 6 11 0   1     0   4   17 21                 38
942032 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_10 102 6 9 2   0     0   4   49 74                       123 102 6 9 2   0     0   4   49 74                 123
936651 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No 3 09 12 2016   grade_10 189 57 31 0   33     0   9   150 169                       319 189 57 31 0   33     0   9   150 169                 319
933680 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No 3 09 12 2016   grade_10 11 55 32 1   30     0   1   81 49                       130 11 55 32 1   30     0   1   81 49                 130
936366 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2016   grade_10 85 54 228 1   54     0   11   215 218                       433 85 54 228 1   54     0   11   215 218                 433
933711 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2016   grade_10 1 53 20 1   0     0   1   47 29                       76 1 53 20 1   0     0   1   47 29                 76
933741 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2016   grade_10 179 53 71 0   112     0   14   187 242                       429 179 53 71 0   112     0   14   187 242                 429
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
941885 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Vocational Education School No 3 09 12 2016   grade_10 354 50 118 1   4     0   21   282 266                       548 354 50 118 1   4     0   21   282 266                 548
932806 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2016   grade_10 150 5 12 0   6     0   3   78 98                       176 150 5 12 0   6     0   3   78 98                 176
933715 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No 3 09 12 2016   grade_10 1 5 11 0   0     0   0   10 7                       17 1 5 11 0   0     0   0   10 7                 17
934741 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton High   Regular School No 3 09 12 2016   grade_10 86 5 9 0   6     0   0   52 54                       106 86 5 9 0   6     0   0   52 54                 106
936576 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2016   grade_10 88 5 1 2   1     0   8   49 56                       105 88 5 1 2   1     0   8   49 56                 105
936598 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2016   grade_10 75 5 11 0   4     0   3   38 60                       98 75 5 11 0   4     0   3   38 60                 98
938036 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No 3 09 12 2016   grade_10 250 5 3 0   11     0   3   138 134                       272 250 5 3 0   11     0   3   138 134                 272
939365 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No 3 09 12 2016   grade_10 89 5 23 0   3     0   8   66 62                       128 89 5 23 0   3     0   8   66 62                 128
939526 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No 3 09 12 2016   grade_10 274 5 31 0   9     1   3   152 171                       323 274 5 31 0   9     1   3   152 171                 323
939531 MA Hampden   school 2512630 325   Westfield 251263002074 3250605 Westfield Technical Academy   Vocational Education School No 3 09 12 2016   grade_10 141 5 2 0   1     0   0   85 64                       149 141 5 2 0   1     0   0   85 64                 149
940654 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2016   grade_10 17 5 19 0   3     0   0   26 18                       44 17 5 19 0   3     0   0   26 18                 44
941256 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No 3 09 12 2016   grade_10 312 5 3 1   5     0   5   162 169                       331 312 5 3 1   5     0   5   162 169                 331
941432 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No 3 09 12 2016   grade_10 242 5 15 0   6     0   8   131 145                       276 242 5 15 0   6     0   8   131 145                 276
941481 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No 3 09 12 2016   grade_10 187 5 2 2   7     0   3   100 106                       206 187 5 2 2   7     0   3   100 106                 206
941927 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Vocational Education School No 3 09 12 2016   grade_10 321 5 13 1   2     0   7   201 148                       349 321 5 13 1   2     0   7   201 148                 349
933694 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No 3 09 12 2016   grade_10 1 49 69 0   1     0   1   62 59                       121 1 49 69 0   1     0   1   62 59                 121
938907 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No 3 09 12 2016   grade_10 176 49 12 0   17     0   1   128 127                       255 176 49 12 0   17     0   1   128 127                 255
933735 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No 3 09 12 2016   grade_10 9 48 64 1   7     0   4   71 62                       133 9 48 64 1   7     0   4   71 62                 133
940195 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No 3 09 12 2016   grade_10 90 48 175 0   45     0   10   194 174                       368 90 48 175 0   45     0   10   194 174                 368
940403 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_10 28 48 34 0   2     0   1   58 55                       113 28 48 34 0   2     0   1   58 55                 113
933667 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2016   grade_10 0 45 31 0   3     0   1   39 41                       80 0 45 31 0   3     0   1   39 41                 80
933759 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2016   grade_10 11 45 40 0   0     0   4   58 42                       100 11 45 40 0   0     0   4   58 42                 100
936370 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2016   grade_10 84 45 262 0   31     0   20   263 179                       442 84 45 262 0   31     0   20   263 179                 442
934975 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2016   grade_10 350 44 113 1   31     0   21   294 266                       560 350 44 113 1   31     0   21   294 266                 560
940183 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No 3 09 12 2016   grade_10 90 44 86 0   14     0   10   128 116                       244 90 44 86 0   14     0   10   128 116                 244
940199 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Vocational Education School No 3 09 12 2016   grade_10 133 44 140 0   21     0   11   156 193                       349 133 44 140 0   21     0   11   156 193                 349
940272 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2016   grade_10 3 44 11 0   0     0   0   35 23                       58 3 44 11 0   0     0   0   35 23                 58
940676 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_10 13 44 15 0   6     0   1   35 44                       79 13 44 15 0   6     0   1   35 44                 79
941977 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes 4 09 11 2016   grade_10 0 44 19 0   3     0   2   25 43                       68 0 44 19 0   3     0   2   25 43                 68
939259 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No 3 09 12 2016   grade_10 167 41 153 1   23     1   11   209 188                       397 167 41 153 1   23     1   11   209 188                 397
933725 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2016   grade_10 16 40 40 0   3     0   2   35 66                       101 16 40 40 0   3     0   2   35 66                 101
935951 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No 3 09 12 2016   grade_10 301 40 140 0   24     1   9   282 233                       515 301 40 140 0   24     1   9   282 233                 515
938482 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No 3 09 12 2016   grade_10 77 40 145 0   20     0   1   166 117                       283 77 40 145 0   20     0   1   166 117                 283
941857 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_10 157 40 23 2   1     0   12   119 116                       235 157 40 23 2   1     0   12   119 116                 235
932589 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2016   grade_10 269 4 14 0   6     1   8   166 136                       302 269 4 14 0   6     1   8   166 136                 302

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