Data source: Big Local News · About: Big Local

392 rows where grade = "grade_9", state = "MA" and year = 2016 sorted by county

View and edit SQL

year

  • 2016 · 392

grade

  • grade_9 · 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
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
933844 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2016   grade_9 99 5 4 0   0     0   5   55 58                       113 99 5 4 0   0     0   5   55 58                 113
935007 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_9 183 10 5 6   9     0   10   101 122                       223 183 10 5 6   9     0   10   101 122                 223
936575 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2016   grade_9 86 4 4 10   2     0   8   66 48                       114 86 4 4 10   2     0   8   66 48                 114
938220 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No 3 09 12 2016   grade_9 167 1 0 1   2     0   0   88 83                       171 167 1 0 1   2     0   0   88 83                 171
940692 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes 3 09 12 2016   grade_9 184 6 12 2   8     1   7   87 133                       220 184 6 12 2   8     1   7   87 133                 220
941027 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2016   grade_9 154 18 21 2   9     0   16   107 113                       220 154 18 21 2   9     0   16   107 113                 220
941089 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2016   grade_9 216 5 9 1   6     0   5   111 131                       242 216 5 9 1   6     0   5   111 131                 242
941334 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2016   grade_9 100 11 3 0   2     0   4   66 54                       120 100 11 3 0   2     0   4   66 54                 120
941864 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_9 104 6 14 6   1     1   9   85 56                       141 104 6 14 6   1     1   9   85 56                 141
941946 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 150 13 4 0   1     0   7   112 63                       175 150 13 4 0   1     0   7   112 63                 175
935885 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2016   grade_9 54 0 4 0   4     0   3   36 29                       65 54 0 4 0   4     0   3   36 29                 65
935913 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2016   grade_9 40 0 6 1   0     0   2   20 29                       49 40 0 6 1   0     0   2   20 29                 49
937288 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2016   grade_9 76 3 8 0   0     0   7   36 58                       94 76 3 8 0   0     0   7   36 58                 94
937776 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No 3 09 12 2016   grade_9 161 25 25 0   5     0   17   117 116                       233 161 25 25 0   5     0   17   117 116                 233
937780 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No 3 09 12 2016   grade_9 118 29 13 0   2     0   14   103 73                       176 118 29 13 0   2     0   14   103 73                 176
940264 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2016   grade_9 40 12 7 0   2     0   3   31 33                       64 40 12 7 0   2     0   3   31 33                 64
940820 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_9 87 5 4 1   3     0   0   45 55                       100 87 5 4 1   3     0   0   45 55                 100
940911 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No 3 09 12 2016   grade_9 120 5 6 0   1     0   4   67 69                       136 120 5 6 0   1     0   4   67 69                 136
941000 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No 3 09 12 2016   grade_9 149 2 6 0   3     0   4   79 85                       164 149 2 6 0   3     0   4   79 85                 164
941341 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2016   grade_9 85 1 0 0   1     0   2   45 44                       89 85 1 0 0   1     0   2   45 44                 89
941629 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2016   grade_9 41 0 2 0   0     0   5   19 29                       48 41 0 2 0   0     0   5   19 29                 48
941905 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 109 0 2 0   0     0   1   77 35                       112 109 0 2 0   0     0   1   77 35                 112
932784 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2016   grade_9 300 23 54 1   17     1   18   228 186                       414 300 23 54 1   17     1   18   228 186                 414
934590 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2016   grade_9 242 4 6 0   1     0   8   128 133                       261 242 4 6 0   1     0   8   128 133                 261
934780 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No 3 09 12 2016   grade_9 252 15 12 0   15     0   9   127 176                       303 252 15 12 0   15     0   9   127 176                 303
934880 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No 3 09 12 2016   grade_9 144 2 8 0   2     0   6   81 81                       162 144 2 8 0   2     0   6   81 81                 162
934964 MA Bristol   school 2504830 95   Fall River 250483002660 950325 Resiliency Preparatory School   Regular School No 3 09 12 2016   grade_9 13 5 12 0   2     0   2   23 11                       34 13 5 12 0   2     0   2   23 11                 34
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
936465 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2016   grade_9 291 10 12 0   13     0   9   165 170                       335 291 10 12 0   13     0   9   165 170                 335
937113 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_9 209 68 261 9   4     1   25   339 238                       577 209 68 261 9   4     1   25   339 238                 577
937119 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No 4 06 12 2016   grade_9 8 1 7 0   0     0   2   11 7                       18 8 1 7 0   0     0   2   11 7                 18
937123 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2016   grade_9 8 5 15 1   0     0   0   22 7                       29 8 5 15 1   0     0   0   22 7                 29
937397 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No 3 09 12 2016   grade_9 235 10 12 1   18     0   6   151 131                       282 235 10 12 1   18     0   6   151 131                 282
937498 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No 3 09 12 2016   grade_9 171 5 3 0   5     0   3   101 86                       187 171 5 3 0   5     0   3   101 86                 187
938314 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk High   Regular School No 3 09 12 2016   grade_9 143 3 3 0   6     0   4   68 91                       159 143 3 3 0   6     0   4   68 91                 159
939008 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Joseph Case High   Regular School No 3 09 12 2016   grade_9 126 4 3 0   2     0   1   70 66                       136 126 4 3 0   2     0   1   70 66                 136
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
939063 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2016   grade_9 * * * *   *     *   *   4 1                       5                         4 1                 5
939601 MA Bristol   school 2512780 331   Westport 251278002093 3310505 Westport Senior High School   Regular School No 3 08 12 2016   grade_9 95 1 3 0   3     0   4   55 51                       106 95 1 3 0   3     0   4   55 51                 106
940705 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_9 49 2 8 0   3     0   1   29 34                       63 49 2 8 0   3     0   1   29 34                 63
940727 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_9 25 8 14 1   1     0   1   24 26                       50 25 8 14 1   1     0   1   24 26                 50
940963 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No 3 09 12 2016   grade_9 344 11 12 0   6     0   21   192 202                       394 344 11 12 0   6     0   21   192 202                 394
941050 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No 3 09 12 2016   grade_9 201 3 9 0   3     0   4   127 93                       220 201 3 9 0   3     0   4   127 93                 220
941116 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No 3 09 12 2016   grade_9 179 4 4 1   1     0   8   95 102                       197 179 4 4 1   1     0   8   95 102                 197
941607 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No 3 09 12 2016   grade_9 239 4 5 0   2     1   6   118 139                       257 239 4 5 0   2     1   6   118 139                 257
941860 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_9 276 14 29 2   1     0   12   204 130                       334 276 14 29 2   1     0   12   204 130                 334
941876 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 300 7 31 2   3     0   22   185 180                       365 300 7 31 2   3     0   22   185 180                 365
941884 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_9 372 44 118 3   6     0   20   268 295                       563 372 44 118 3   6     0   20   268 295                 563
941917 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 138 0 0 0   0     0   2   82 58                       140 138 0 0 0   0     0   2   82 58                 140
941930 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 180 141 47 0   4     0   12   197 187                       384 180 141 47 0   4     0   12   197 187                 384
941954 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Vocational Education School No 3 09 12 2016   grade_9 118 0 3 1   0     0   4   25 101                       126 118 0 3 1   0     0   4   25 101                 126
941993 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_9 35 16 46 0   1     0   4   52 50                       102 35 16 46 0   1     0   4   52 50                 102
940552 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_9 5 0 1 0   0     0   0   3 3                       6 5 0 1 0   0     0   0   3 3                 6
941286 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No 3 09 12 2016   grade_9 121 2 22 3   1     1   3   92 61                       153 121 2 22 3   1     1   3   92 61                 153
932608 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2016   grade_9 127 3 9 0   2     0   5   81 65                       146 127 3 9 0   2     0   5   81 65                 146
932677 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2016   grade_9 367 9 17 0   66     0   12   209 262                       471 367 9 17 0   66     0   12   209 262                 471
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
934563 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2016   grade_9 225 9 15 0   7     0   3   129 130                       259 225 9 15 0   7     0   3   129 130                 259
935234 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2016   grade_9 88 0 1 0   1     0   0   40 50                       90 88 0 1 0   1     0   0   40 50                 90
935272 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2016   grade_9 214 3 12 2   5     1   5   130 112                       242 214 3 12 2   5     1   5   130 112                 242
935434 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2016   grade_9 6 2 2 0   0     0   0   9 1                       10 6 2 2 0   0     0   0   9 1                 10
935477 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2016   grade_9 295 16 144 0   12     1   4   250 222                       472 295 16 144 0   12     1   4   250 222                 472
935716 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No 3 09 12 2016   grade_9 108 0 6 0   4     0   5   60 63                       123 108 0 6 0   4     0   5   60 63                 123
935823 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No 4 09 09 2016   grade_9 25 12 700 1   12     0   3   391 362                       753 25 12 700 1   12     0   3   391 362                 753
935828 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2016   grade_9 1 0 14 0   0     0   0   14 1                       15 1 0 14 0   0     0   0   14 1                 15
935832 MA Essex   school 2506660 149   Lawrence 250666002636 1490531 Health & Human Services High School   Regular School No 3 09 12 2016   grade_9 0 2 32 0   1     0   0   21 14                       35 0 2 32 0   1     0   0   21 14                 35
935836 MA Essex   school 2506660 149   Lawrence 250666002633 1490532 Humanities & Leadership Development High School   Regular School No 3 09 12 2016   grade_9 0 1 26 0   1     0   0   23 5                       28 0 1 26 0   1     0   0   23 5                 28
935841 MA Essex   school 2506660 149   Lawrence 250666002618 1490533 Math, Science & Technology High School   Regular School No 3 09 12 2016   grade_9 1 0 28 0   0     0   0   22 7                       29 1 0 28 0   0     0   0   22 7                 29
935845 MA Essex   school 2506660 149   Lawrence 250666002631 1490534 International High School   Regular School No 3 09 12 2016   grade_9 1 1 22 0   0     0   0   20 4                       24 1 1 22 0   0     0   0   20 4                 24
935849 MA Essex   school 2506660 149   Lawrence 250666002616 1490535 Performing & Fine Arts High School   Regular School No 3 09 12 2016   grade_9 0 0 8 0   0     0   0   4 4                       8 0 0 8 0   0     0   0   4 4                 8
935854 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No 3 09 12 2016   grade_9 0 0 8 0   0     0   0   7 1                       8 0 0 8 0   0     0   0   7 1                 8
935866 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_9 2 0 19 0   0     0   0   17 4                       21 2 0 19 0   0     0   0   17 4                 21
935871 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2016   grade_9 1 2 42 0   1     0   0   25 21                       46 1 2 42 0   1     0   0   25 21                 46
936365 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2016   grade_9 117 50 238 2   44     1   14   256 210                       466 117 50 238 2   44     1   14   256 210                 466
936369 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2016   grade_9 72 52 299 1   30     0   18   283 189                       472 72 52 299 1   30     0   18   283 189                 472
936375 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2016   grade_9 5 5 92 1   1     0   3   66 41                       107 5 5 92 1   1     0   3   66 41                 107
936381 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 08 12 2016   grade_9 38 17 144 1   18     0   8   130 96                       226 38 17 144 1   18     0   8   130 96                 226
936401 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No 3 09 12 2016   grade_9 148 0 10 0   6     0   5   93 76                       169 148 0 10 0   6     0   5   93 76                 169
936488 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No 3 09 12 2016   grade_9 229 10 15 1   6     0   4   126 139                       265 229 10 15 1   6     0   4   126 139                 265
936755 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No 3 09 12 2016   grade_9 288 17 171 3   17     1   9   272 234                       506 288 17 171 3   17     1   9   272 234                 506
937137 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No 3 09 12 2016   grade_9 172 3 12 0   3     0   2   89 103                       192 172 3 12 0   3     0   2   89 103                 192
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
937670 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No 3 09 12 2016   grade_9 266 11 45 0   7     0   12   170 171                       341 266 11 45 0   7     0   12   170 171                 341
938145 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No 3 09 12 2016   grade_9 75 0 1 0   1     0   1   41 37                       78 75 0 1 0   1     0   1   41 37                 78
938202 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No 3 09 12 2016   grade_9 105 20 111 1   4     0   8   139 110                       249 105 20 111 1   4     0   8   139 110                 249
938252 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No 3 09 12 2016   grade_9 148 7 16 1   8     1   0   84 97                       181 148 7 16 1   8     1   0   84 97                 181
938988 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2016   grade_9 149 9 11 0   6     1   6   87 95                       182 149 9 11 0   6     1   6   87 95                 182
940322 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2016   grade_9 5 38 80 0   3     0   4   63 67                       130 5 38 80 0   3     0   4   63 67                 130
940653 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2016   grade_9 31 5 28 0   3     0   0   29 38                       67 31 5 28 0   3     0   0   29 38                 67
940713 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes 3 09 12 2016   grade_9 4 10 66 0   1     0   0   45 36                       81 4 10 66 0   1     0   0   45 36                 81
941212 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No 3 09 12 2016   grade_9 138 0 4 0   6     0   3   77 74                       151 138 0 4 0   6     0   3   77 74                 151
941282 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2016   grade_9 109 0 0 0   0     0   2   46 65                       111 109 0 0 0   0     0   2   46 65                 111
941293 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No 3 09 12 2016   grade_9 262 2 5 2   9     0   6   145 141                       286 262 2 5 2   9     0   6   145 141                 286
941510 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No 3 09 12 2016   grade_9 150 1 6 0   1     0   1   74 85                       159 150 1 6 0   1     0   1   74 85                 159
941712 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No 3 09 12 2016   grade_9 171 1 7 0   4     0   2   86 99                       185 171 1 7 0   4     0   2   86 99                 185
941868 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_9 295 4 43 1   6     0   8   151 206                       357 295 4 43 1   6     0   8   151 206                 357
941880 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 67 6 322 0   2     0   0   201 196                       397 67 6 322 0   2     0   0   201 196                 397
941950 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Vocational Education School No 3 09 12 2016   grade_9 260 6 59 2   5     0   10   181 161                       342 260 6 59 2   5     0   10   181 161                 342
935337 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2016   grade_9 58 1 20 0   3     0   6   49 39                       88 58 1 20 0   3     0   6   49 39                 88

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