Data source: Big Local News · About: Big Local

2,748 rows where grade = "grade_12" and state = "MA"

View and edit SQL

year

grade

  • grade_12 · 2,648
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
738588 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2015   grade_12 * * * *   *     *   *   2 2                       4                         2 2                 4
738608 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_12 6 0 4 0   1     0   0   7 4                       11 6 0 4 0   1     0   0   7 4                 11
738634 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2015   grade_12 263 15 103 0   5     0   3   211 178                       389 263 15 103 0   5     0   3   211 178                 389
738667 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No 3 09 12 2015   grade_12 269 1 6 0   2     0   3   129 152                       281 269 1 6 0   2     0   3   129 152                 281
738682 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2015   grade_12 35 11 8 0   7     1   3   32 33                       65 35 11 8 0   7     1   3   32 33                 65
738705 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No 3 09 12 2015   grade_12 161 1 4 0   9     0   2   87 90                       177 161 1 4 0   9     0   2   87 90                 177
738776 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2015   grade_12 89 6 196 0   3     0   0   147 147                       294 89 6 196 0   3     0   0   147 147                 294
738780 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_12 5 3 88 0   0     0   0   54 42                       96 5 3 88 0   0     0   0   54 42                 96
738794 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2015   grade_12 80 2 2 0   2     0   0   40 46                       86 80 2 2 0   2     0   0   40 46                 86
738808 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No 3 09 12 2015   grade_12 276 1 5 0   9     0   2   129 164                       293 276 1 5 0   9     0   2   129 164                 293
738835 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No 3 08 12 2015   grade_12 168 1 6 0   3     0   1   80 99                       179 168 1 6 0   3     0   1   80 99                 179
738849 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No 3 09 12 2015   grade_12 93 2 4 0   0     1   0   57 43                       100 93 2 4 0   0     1   0   57 43                 100
738870 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No 3 09 12 2015   grade_12 140 0 5 0   2     0   5   76 76                       152 140 0 5 0   2     0   5   76 76                 152
738982 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2015   grade_12 17 2 87 0   2     0   0   68 40                       108 17 2 87 0   2     0   0   68 40                 108
738986 MA Essex   school 2506660 149   Lawrence 250666002636 1490531 Health & Human Services High School   Regular School No 3 09 12 2015   grade_12 5 3 118 0   0     0   0   49 77                       126 5 3 118 0   0     0   0   49 77                 126
738990 MA Essex   school 2506660 149   Lawrence 250666002633 1490532 Humanities & Leadership Development High School   Regular School No 3 09 12 2015   grade_12 7 5 117 0   1     0   0   81 49                       130 7 5 117 0   1     0   0   81 49                 130
738995 MA Essex   school 2506660 149   Lawrence 250666002618 1490533 Math, Science & Technology High School   Regular School No 3 09 12 2015   grade_12 7 1 106 0   5     0   0   54 65                       119 7 1 106 0   5     0   0   54 65                 119
738999 MA Essex   school 2506660 149   Lawrence 250666002631 1490534 International High School   Regular School No 3 09 12 2015   grade_12 1 0 112 0   0     0   0   53 60                       113 1 0 112 0   0     0   0   53 60                 113
739003 MA Essex   school 2506660 149   Lawrence 250666002616 1490535 Performing & Fine Arts High School   Regular School No 3 09 12 2015   grade_12 7 3 111 0   1     0   0   48 74                       122 7 3 111 0   1     0   0   48 74                 122
739008 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No 3 09 12 2015   grade_12 3 2 73 0   2     0   0   43 37                       80 3 2 73 0   2     0   0   43 37                 80
739020 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_12 1 1 13 0   0     0   0   12 3                       15 1 1 13 0   0     0   0   12 3                 15
739025 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2015   grade_12 1 1 12 0   0     0   0   8 6                       14 1 1 12 0   0     0   0   8 6                 14
739039 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2015   grade_12 46 0 2 0   2     0   0   24 26                       50 46 0 2 0   2     0   0   24 26                 50
739053 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No 3 09 12 2015   grade_12 92 1 8 0   2     0   3   50 56                       106 92 1 8 0   2     0   3   50 56                 106
739067 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_12 58 1 1 1   2     1   0   39 25                       64 58 1 1 1   2     1   0   39 25                 64
739105 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No 3 09 12 2015   grade_12 186 28 68 0   13     0   6   150 151                       301 186 28 68 0   13     0   6   150 151                 301
739111 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Vocational Education School No 3 09 12 2015   grade_12 81 9 24 0   5     0   3   73 49                       122 81 9 24 0   5     0   3   73 49                 122
739166 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_12 282 27 24 1   142     0   13   254 235                       489 282 27 24 1   142     0   13   254 235                 489
739200 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2015   grade_12 98 2 3 0   2     0   1   49 57                       106 98 2 3 0   2     0   1   49 57                 106
739229 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No 3 09 12 2015   grade_12 212 4 15 1   19     0   5   133 123                       256 212 4 15 1   19     0   5   133 123                 256
739343 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No 3 08 12 2015   grade_12 4 1 2 0   0     0   0   7 *                       7 4 1 2 0   0     0   0   7                   7
739363 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_12 203 83 154 1   199     0   5   321 324                       645 203 83 154 1   199     0   5   321 324                 645
739378 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No 3 09 12 2015   grade_12 179 5 12 0   0     0   3   100 99                       199 179 5 12 0   0     0   3   100 99                 199
739393 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2015   grade_12 102 2 1 1   1     1   0   53 55                       108 102 2 1 1   1     1   0   53 55                 108
739520 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2015   grade_12 68 47 105 1   51     0   11   141 142                       283 68 47 105 1   51     0   11   141 142                 283
739525 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2015   grade_12 82 44 153 1   35     0   9   147 177                       324 82 44 153 1   35     0   9   147 177                 324
739532 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2015   grade_12 5 3 13 0   3     0   0   13 11                       24 5 3 13 0   3     0   0   13 11                 24
739539 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   grade_12 24 8 84 2   9     0   4   66 65                       131 24 8 84 2   9     0   4   66 65                 131
739559 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No 3 09 12 2015   grade_12 140 3 3 0   5     0   1   76 76                       152 140 3 3 0   5     0   1   76 76                 152
739609 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_12 148 95 97 2   114     2   16   246 228                       474 148 95 97 2   114     2   16   246 228                 474
739623 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_12 288 9 5 3   18     1   3   152 175                       327 288 9 5 3   18     1   3   152 175                 327
739647 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No 3 09 12 2015   grade_12 224 4 6 0   6     0   2   110 132                       242 224 4 6 0   6     0   2   110 132                 242
739680 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No 3 09 12 2015   grade_12 174 9 73 0   13     0   1   142 128                       270 174 9 73 0   13     0   1   142 128                 270
739720 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield High   Regular School No 3 09 12 2015   grade_12 297 3 7 0   1     0   0   138 170                       308 297 3 7 0   1     0   0   138 170                 308
739734 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_12 88 2 1 4   2     0   7   55 49                       104 88 2 1 4   2     0   7   55 49                 104
739756 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2015   grade_12 64 3 4 0   7     0   3   35 46                       81 64 3 4 0   7     0   3   35 46                 81
739770 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No 3 09 12 2015   grade_12 185 2 2 0   6     0   4   98 101                       199 185 2 2 0   6     0   4   98 101                 199
739809 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No 3 09 12 2015   grade_12 164 49 20 0   27     0   3   125 138                       263 164 49 20 0   27     0   3   125 138                 263
739813 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No 3 09 12 2015   grade_12 6 0 2 0   0     0   0   6 2                       8 6 0 2 0   0     0   0   6 2                 8
739817 MA Middlesex   school 2507560 176   Medford 250756001174 1760605 Medford Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_12 29 10 3 1   0     0   0   25 18                       43 29 10 3 1   0     0   0   25 18                 43
739831 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway High   Regular School No 3 09 12 2015   grade_12 175 3 4 0   2     0   3   86 101                       187 175 3 4 0   2     0   3   86 101                 187
739869 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No 3 09 12 2015   grade_12 194 13 6 0   7     0   7   104 123                       227 194 13 6 0   7     0   7   104 123                 227
739913 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No 3 09 12 2015   grade_12 273 16 120 4   14     0   4   220 211                       431 273 16 120 4   14     0   4   220 211                 431
739933 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No 3 09 12 2015   grade_12 162 7 6 0   1     0   4   93 87                       180 162 7 6 0   1     0   4   93 87                 180
739959 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2015   grade_12 226 4 29 5   13     0   1   138 140                       278 226 4 29 5   13     0   1   138 140                 278
739974 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2015   grade_12 125 1 6 0   3     0   1   63 73                       136 125 1 6 0   3     0   1   63 73                 136
739989 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No 3 09 12 2015   grade_12 88 1 2 0   2     1   1   53 42                       95 88 1 2 0   2     1   1   53 42                 95
740022 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2015   grade_12 136 58 15 0   14     0   4   104 123                       227 136 58 15 0   14     0   4   104 123                 227
740037 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson Innovation High School   Regular School No 3 09 12 2015   grade_12 76 2 1 0   1     0   1   36 45                       81 76 2 1 0   1     0   1   36 45                 81
740060 MA Nantucket   school 2508250 197   Nantucket 250825001282 1970505 Nantucket High   Regular School No 3 09 12 2015   grade_12 70 14 9 0   5     0   2   54 46                       100 70 14 9 0   5     0   2   54 46                 100
740099 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No 3 09 12 2015   grade_12 272 21 16 0   25     1   15   186 164                       350 272 21 16 0   25     1   15   186 164                 350
740137 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No 3 09 12 2015   grade_12 327 8 14 0   22     0   14   200 185                       385 327 8 14 0   22     0   14   200 185                 385
740278 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_12 183 71 105 1   10     4   32   200 206                       406 183 71 105 1   10     4   32   200 206                 406
740284 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No 3 07 12 2015   grade_12 6 1 1 0   0     0   0   3 5                       8 6 1 1 0   0     0   0   3 5                 8
740290 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_12 2 4 9 0   0     1   2   12 6                       18 2 4 9 0   0     1   2   12 6                 18
740304 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No 3 09 12 2015   grade_12 180 2 6 0   6     0   4   95 103                       198 180 2 6 0   6     0   4   95 103                 198
740412 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_12 324 28 31 1   47     0   26   233 224                       457 324 28 31 1   47     0   26   233 224                 457
740417 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_12 290 18 26 0   93     3   14   209 235                       444 290 18 26 0   93     3   14   209 235                 444
740456 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_12 83 2 4 0   0     2   7   48 50                       98 83 2 4 0   0     2   7   48 50                 98
740488 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No 3 09 12 2015   grade_12 179 5 18 0   11     0   4   102 115                       217 179 5 18 0   11     0   4   102 115                 217
740527 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2015   grade_12 316 14 18 2   22     0   2   192 182                       374 316 14 18 2   22     0   2   192 182                 374
740570 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No 3 09 12 2015   grade_12 277 3 4 2   16     0   5   160 147                       307 277 3 4 2   16     0   5   160 147                 307
740613 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No 3 09 12 2015   grade_12 169 2 5 0   1     0   5   86 96                       182 169 2 5 0   1     0   5   86 96                 182
740628 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2015   grade_12 31 0 0 0   0     0   0   13 18                       31 31 0 0 0   0     0   0   13 18                 31
740654 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2015   grade_12 168 1 2 0   5     0   2   86 92                       178 168 1 2 0   5     0   2   86 92                 178
740672 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No 3 09 12 2015   grade_12 136 3 4 0   7     0   3   88 65                       153 136 3 4 0   7     0   3   88 65                 153
740693 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No 3 09 12 2015   grade_12 163 1 2 0   4     0   2   87 85                       172 163 1 2 0   4     0   2   87 85                 172
740727 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No 3 09 12 2015   grade_12 217 27 11 0   11     0   1   127 140                       267 217 27 11 0   11     0   1   127 140                 267
740762 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2015   grade_12 9 0 2 0   0     0   0   8 3                       11 9 0 2 0   0     0   0   8 3                 11
740770 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No 3 09 12 2015   grade_12 108 0 9 0   0     0   6   57 66                       123 108 0 9 0   0     0   6   57 66                 123
740785 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No 3 08 12 2015   grade_12 72 0 4 1   1     0   3   33 48                       81 72 0 4 1   1     0   3   33 48                 81
740846 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No 3 09 12 2015   grade_12 360 9 63 1   10     0   10   235 218                       453 360 9 63 1   10     0   10   235 218                 453
740881 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2015   grade_12 236 6 0 0   1     2   0   117 128                       245 236 6 0 0   1     2   0   117 128                 245
740951 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No 3 09 12 2015   grade_12 173 29 17 0   2     0   8   104 125                       229 173 29 17 0   2     0   8   104 125                 229
740955 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No 3 09 12 2015   grade_12 162 12 11 0   3     0   5   103 90                       193 162 12 11 0   3     0   5   103 90                 193
741023 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth North High   Regular School No 3 09 12 2015   grade_12 219 10 9 0   3     0   8   122 127                       249 219 10 9 0   3     0   8   122 127                 249
741027 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No 3 09 12 2015   grade_12 274 4 5 3   4     0   11   159 142                       301 274 4 5 3   4     0   11   159 142                 301
741131 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2015   grade_12 209 37 31 6   80     1   5   202 167                       369 209 37 31 6   80     1   5   202 167                 369
741135 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2015   grade_12 111 14 6 2   166     0   0   141 158                       299 111 14 6 2   166     0   0   141 158                 299
741168 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No 3 09 12 2015   grade_12 20 113 11 1   39     0   0   88 96                       184 20 113 11 1   39     0   0   88 96                 184
741210 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No 3 09 12 2015   grade_12 277 3 8 0   13     0   4   138 167                       305 277 3 8 0   13     0   4   138 167                 305
741262 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2015   grade_12 128 16 153 1   24     0   8   152 178                       330 128 16 153 1   24     0   8   152 178                 330
741267 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Seacoast School   Regular School No 3 09 12 2015   grade_12 4 0 2 0   0     0   0   5 1                       6 4 0 2 0   0     0   0   5 1                 6
741307 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No 3 09 12 2015   grade_12 109 5 12 0   1     0   3   76 54                       130 109 5 12 0   1     0   3   76 54                 130
741322 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No 3 09 12 2015   grade_12 74 1 3 0   0     0   1   46 33                       79 74 1 3 0   0     0   1   46 33                 79
741385 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No 3 09 12 2015   grade_12 150 9 84 2   11     0   13   136 133                       269 150 9 84 2   11     0   13   136 133                 269
741388 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No 3 09 12 2015   grade_12 4 0 2 0   0     0   0   5 *                       6 4 0 2 0   0     0   0   5                   6
741416 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No 3 09 12 2015   grade_12 204 4 0 0   1     0   0   96 113                       209 204 4 0 0   1     0   0   96 113                 209
741448 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No 3 09 12 2015   grade_12 141 8 14 1   2     0   5   80 91                       171 141 8 14 1   2     0   5   80 91                 171
741491 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No 3 09 12 2015   grade_12 214 2 2 0   2     0   3   107 116                       223 214 2 2 0   2     0   3   107 116                 223

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