enrollments

Data source: Big Local News · About: Big Local

396 rows where grade = "grade_12", state = "MA" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 296 ✖

grade ✖

  • grade_12 · 296 ✖
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
2042693 2042693 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2019   grade_12 206 1 1 0   6     0   1   124 90                       215.0 206 1 1 0   6     0   1   124 90                 215
2042708 2042708 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_12 85 3 4 0   13     0   2   54 52                       107.0 85 3 4 0   13     0   2   54 52                 107
2042722 2042722 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_12 23 0 1 0   2     0   0   13 12                       26.0 23 0 1 0   2     0   0   13 12                 26
2042748 2042748 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2019   grade_12 0 2 4 0   0     0   0   5 1                       6.0 0 2 4 0   0     0   0   5 1                 6
2042776 2042776 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_12 * * * *   *     *   *   1 *                       2.0                         1                   2
2042798 2042798 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No High 09 12 2019   grade_12 250 19 103 0   11     0   5   184 204                       388.0 250 19 103 0   11     0   5   184 204                 388
2042831 2042831 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No High 09 12 2019   grade_12 263 4 5 0   3     0   4   140 139                       279.0 263 4 5 0   3     0   4   140 139                 279
2042846 2042846 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_12 30 14 8 0   3     0   2   25 32                       57.0 30 14 8 0   3     0   2   25 32                 57
2042869 2042869 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2019   grade_12 161 1 7 0   11     0   4   88 96                       184.0 161 1 7 0   11     0   4   88 96                 184
2042944 2042944 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2019   grade_12 58 12 252 0   1     0   5   167 160                       328.0 58 12 252 0   1     0   5   167 160                 328
2042958 2042958 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2019   grade_12 69 1 2 4   0     0   2   39 39                       78.0 69 1 2 4   0     0   2   39 39                 78
2042972 2042972 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No High 09 12 2019   grade_12 244 3 12 0   19     0   8   145 141                       286.0 244 3 12 0   19     0   8   145 141                 286
2042998 2042998 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2019   grade_12 154 3 16 0   7     0   1   97 84                       181.0 154 3 16 0   7     0   1   97 84                 181
2043012 2043012 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No High 09 12 2019   grade_12 76 0 2 0   0     0   2   45 35                       80.0 76 0 2 0   0     0   2   45 35                 80
2043035 2043035 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No High 09 12 2019   grade_12 105 0 5 0   4     0   5   58 60                       119.0 105 0 5 0   4     0   5   58 60                 119
2043133 2043133 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_12 15 11 619 1   14     0   4   331 333                       664.0 15 11 619 1   14     0   4   331 333                 664
2043142 2043142 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No High 09 12 2019   grade_12 0 0 69 0   1     0   0   39 31                       70.0 0 0 69 0   1     0   0   39 31                 70
2043151 2043151 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_12 1 0 10 0   0     0   0   9 2                       11.0 1 0 10 0   0     0   0   9 2                 11
2043166 2043166 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2019   grade_12 48 0 2 0   5     0   2   29 28                       57.0 48 0 2 0   5     0   2   29 28                 57
2043181 2043181 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No High 09 12 2019   grade_12 87 6 2 0   2     1   2   49 51                       100.0 87 6 2 0   2     1   2   49 51                 100
2043195 2043195 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_12 38 0 9 0   1     0   2   24 26                       50.0 38 0 9 0   1     0   2   24 26                 50
2043232 2043232 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No High 09 12 2019   grade_12 163 30 79 1   13     0   6   146 146                       292.0 163 30 79 1   13     0   6   146 146                 292
2043236 2043236 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No High 09 12 2019   grade_12 6 2 7 0   0     0   1   6 10                       16.0 6 2 7 0   0     0   1   6 10                 16
2043240 2043240 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2019   grade_12 84 10 44 0   6     1   6   108 43                       151.0 84 10 44 0   6     1   6   108 43                 151
2043295 2043295 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_12 300 15 21 0   194     0   21   287 264                       551.0 300 15 21 0   194     0   21   287 264                 551
2043329 2043329 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2019   grade_12 97 0 3 1   7     1   6   55 60                       115.0 97 0 3 1   7     1   6   55 60                 115
2043358 2043358 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2019   grade_12 199 7 12 0   20     0   4   126 116                       242.0 199 7 12 0   20     0   4   126 116                 242
2043477 2043477 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No High 09 12 2019   grade_12 3 0 6 0   1     0   1   6 5                       11.0 3 0 6 0   1     0   1   6 5                 11
2043496 2043496 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_12 218 102 193 0   241     0   17   380 391                       771.0 218 102 193 0   241     0   17   380 391                 771
2043501 2043501 MA Middlesex   school 2507020 160   Lowell 250702002860 1600515 The Career Academy   Regular School No High 09 12 2019   grade_12 12 4 18 0   8     0   2   23 21                       44.0 12 4 18 0   8     0   2   23 21                 44
2043523 2043523 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2019   grade_12 180 5 18 1   2     0   3   100 109                       209.0 180 5 18 1   2     0   3   100 109                 209
2043538 2043538 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2019   grade_12 95 1 3 1   8     1   0   51 58                       109.0 95 1 3 1   8     1   0   51 58                 109
2043663 2043663 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2019   grade_12 112 46 198 1   43     1   11   216 196                       412.0 112 46 198 1   43     1   11   216 196                 412
2043667 2043667 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2019   grade_12 49 45 213 0   23     0   9   176 162                       339.0 49 45 213 0   23     0   9   176 162                 339
2043673 2043673 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2019   grade_12 0 5 8 0   1     0   2   6 10                       16.0 0 5 8 0   1     0   2   6 10                 16
2043680 2043680 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_12 28 17 141 0   15     0   11   123 89                       212.0 28 17 141 0   15     0   11   123 89                 212
2043700 2043700 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No High 09 12 2019   grade_12 145 1 11 0   7     0   3   88 79                       167.0 145 1 11 0   7     0   3   88 79                 167
2043750 2043750 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2019   grade_12 119 89 100 0   105     1   11   195 230                       425.0 119 89 100 0   105     1   11   195 230                 425
2043765 2043765 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2019   grade_12 281 15 9 0   14     0   8   160 167                       327.0 281 15 9 0   14     0   8   160 167                 327
2043787 2043787 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2019   grade_12 229 8 17 1   6     0   2   118 145                       263.0 229 8 17 1   6     0   2   118 145                 263
2043820 2043820 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2019   grade_12 129 9 149 0   6     0   6   164 135                       299.0 129 9 149 0   6     0   6   164 135                 299
2043861 2043861 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield High   Regular School No High 09 12 2019   grade_12 316 3 9 0   4     1   2   156 179                       335.0 316 3 9 0   4     1   2   156 179                 335
2043875 2043875 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2019   grade_12 82 6 4 8   2     0   9   62 49                       111.0 82 6 4 8   2     0   9   62 49                 111
2043897 2043897 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No High 09 12 2019   grade_12 74 3 14 0   4     0   7   51 51                       102.0 74 3 14 0   4     0   7   51 51                 102
2043911 2043911 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2019   grade_12 169 1 3 0   14     0   3   96 94                       190.0 169 1 3 0   14     0   3   96 94                 190
2043950 2043950 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No High 09 12 2019   grade_12 213 52 41 0   26     0   11   167 176                       343.0 213 52 41 0   26     0   11   167 176                 343
2043954 2043954 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 09 12 2019   grade_12 6 1 1 0   0     0   0   4 4                       8.0 6 1 1 0   0     0   0   4 4                 8
2043968 2043968 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway High   Regular School No High 09 12 2019   grade_12 157 4 6 0   6     1   3   84 93                       177.0 157 4 6 0   6     1   3   84 93                 177
2044007 2044007 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No High 09 12 2019   grade_12 218 20 8 0   6     0   4   123 133                       256.0 218 20 8 0   6     0   4   123 133                 256
2044052 2044052 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2019   grade_12 273 6 163 2   19     1   28   259 233                       492.0 273 6 163 2   19     1   28   259 233                 492
2044072 2044072 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2019   grade_12 155 4 10 0   3     0   7   91 88                       179.0 155 4 10 0   3     0   7   91 88                 179
2044098 2044098 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_12 171 5 65 6   11     0   4   131 131                       262.0 171 5 65 6   11     0   4   131 131                 262
2044113 2044113 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2019   grade_12 78 2 10 0   2     0   4   53 43                       96.0 78 2 10 0   2     0   4   53 43                 96
2044128 2044128 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No High 09 12 2019   grade_12 88 2 5 1   1     0   0   41 56                       97.0 88 2 5 1   1     0   0   41 56                 97
2044162 2044162 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2019   grade_12 158 48 12 0   15     1   11   117 128                       245.0 158 48 12 0   15     1   11   117 128                 245
2044176 2044176 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 09 12 2019   grade_12 63 0 1 0   1     0   2   34 33                       67.0 63 0 1 0   1     0   2   34 33                 67
2044199 2044199 MA Nantucket   school 2508250 197   Nantucket 250825001282 1970505 Nantucket High   Regular School No High 09 12 2019   grade_12 74 21 26 0   3     0   5   75 54                       129.0 74 21 26 0   3     0   5   75 54                 129
2044237 2044237 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No High 09 12 2019   grade_12 300 14 23 0   29     0   12   194 184                       378.0 300 14 23 0   29     0   12   194 184                 378
2044275 2044275 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No High 09 12 2019   grade_12 344 16 20 0   40     0   16   221 214                       436.0 344 16 20 0   40     0   16   221 214                 436
2044413 2044413 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_12 133 75 215 2   8     2   18   241 212                       453.0 133 75 215 2   8     2   18   241 212                 453
2044421 2044421 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_12 7 0 4 0   0     0   0   7 4                       11.0 7 0 4 0   0     0   0   7 4                 11
2044427 2044427 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2019   grade_12 6 3 7 0   0     0   1   11 6                       17.0 6 3 7 0   0     0   1   11 6                 17
2044441 2044441 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2019   grade_12 167 3 9 0   3     0   2   87 97                       184.0 167 3 9 0   3     0   2   87 97                 184
2044549 2044549 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_12 361 18 56 3   83     0   23   269 274                       544.0 361 18 56 3   83     0   23   269 274                 544
2044554 2044554 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2019   grade_12 286 29 23 1   91     0   16   224 221                       446.0 286 29 23 1   91     0   16   224 221                 446
2044592 2044592 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2019   grade_12 69 3 10 0   0     0   7   38 51                       89.0 69 3 10 0   0     0   7   38 51                 89
2044626 2044626 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2019   grade_12 155 6 38 0   15     0   8   107 115                       222.0 155 6 38 0   15     0   8   107 115                 222
2044661 2044661 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No High 09 12 2019   grade_12 320 11 36 1   21     3   5   189 207                       397.0 320 11 36 1   21     3   5   189 207                 397
2044699 2044699 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2019   grade_12 240 10 14 1   17     0   8   159 131                       290.0 240 10 14 1   17     0   8   159 131                 290
2044740 2044740 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No High 09 12 2019   grade_12 120 3 7 0   0     0   2   61 71                       132.0 120 3 7 0   0     0   2   61 71                 132
2044755 2044755 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2019   grade_12 38 0 1 0   0     0   2   22 19                       41.0 38 0 1 0   0     0   2   22 19                 41
2044781 2044781 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2019   grade_12 171 1 3 0   5     0   4   89 95                       184.0 171 1 3 0   5     0   4   89 95                 184
2044800 2044800 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No High 09 12 2019   grade_12 168 5 4 0   5     0   3   100 85                       185.0 168 5 4 0   5     0   3   100 85                 185
2044822 2044822 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No High 09 12 2019   grade_12 162 0 5 0   2     0   3   84 88                       172.0 162 0 5 0   2     0   3   84 88                 172
2044856 2044856 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No High 09 12 2019   grade_12 161 26 35 0   7     0   7   118 118                       236.0 161 26 35 0   7     0   7   118 118                 236
2044891 2044891 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No High 09 12 2019   grade_12 6 0 2 0   0     0   0   7 *                       8.0 6 0 2 0   0     0   0   7                   8
2044899 2044899 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2019   grade_12 66 6 8 0   5     0   6   42 49                       91.0 66 6 8 0   5     0   6   42 49                 91
2044914 2044914 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   grade_12 86 4 9 0   5     0   1   45 60                       105.0 86 4 9 0   5     0   1   45 60                 105
2044974 2044974 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No High 09 12 2019   grade_12 280 15 54 0   8     0   9   188 177                       366.0 280 15 54 0   8     0   9   188 177                 366
2045010 2045010 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2019   grade_12 227 3 1 0   1     0   0   113 119                       232.0 227 3 1 0   1     0   0   113 119                 232
2045080 2045080 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2019   grade_12 127 17 28 0   3     0   11   90 96                       186.0 127 17 28 0   3     0   11   90 96                 186
2045085 2045085 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No High 09 12 2019   grade_12 130 23 14 0   2     0   15   92 92                       184.0 130 23 14 0   2     0   15   92 92                 184
2045152 2045152 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth North High   Regular School No High 09 12 2019   grade_12 253 7 19 1   9     0   10   152 147                       299.0 253 7 19 1   9     0   10   152 147                 299
2045156 2045156 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No High 09 12 2019   grade_12 235 3 8 1   4     1   11   136 127                       263.0 235 3 8 1   4     1   11   136 127                 263
2045261 2045261 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2019   grade_12 222 25 34 1   74     2   10   209 158                       368.0 222 25 34 1   74     2   10   209 158                 368
2045265 2045265 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2019   grade_12 125 12 5 1   193     0   6   180 162                       342.0 125 12 5 1   193     0   6   180 162                 342
2045298 2045298 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2019   grade_12 10 73 16 1   29     0   6   65 70                       135.0 10 73 16 1   29     0   6   65 70                 135
2045339 2045339 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2019   grade_12 291 9 6 0   15     0   1   159 163                       322.0 291 9 6 0   15     0   1   159 163                 322
2045391 2045391 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2019   grade_12 137 24 206 2   35     0   9   197 216                       413.0 137 24 206 2   35     0   9   197 216                 413
2045396 2045396 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Seacoast School   Regular School No High 09 12 2019   grade_12 7 2 11 0   0     0   1   14 7                       21.0 7 2 11 0   0     0   1   14 7                 21
2045438 2045438 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No High 09 12 2019   grade_12 91 9 15 0   0     0   2   52 65                       117.0 91 9 15 0   0     0   2   52 65                 117
2045453 2045453 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No High 09 12 2019   grade_12 77 0 2 0   1     0   1   43 38                       81.0 77 0 2 0   1     0   1   43 38                 81
2045502 2045502 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2019   grade_12 93 21 100 0   4     0   11   124 105                       229.0 93 21 100 0   4     0   11   124 105                 229
2045507 2045507 MA Essex   school 2510380 258   Salem 251038002864 2580510 New Liberty Innovation School   Regular School No High 09 12 2019   grade_12 5 0 10 0   0     0   1   7 9                       16.0 5 0 10 0   0     0   1   7 9                 16
2045512 2045512 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2019   grade_12 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2045526 2045526 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2019   grade_12 161 1 0 1   2     0   0   89 76                       165.0 161 1 0 1   2     0   0   89 76                 165
2045559 2045559 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No High 09 12 2019   grade_12 138 5 29 0   7     0   1   81 99                       180.0 138 5 29 0   7     0   1   81 99                 180
2045598 2045598 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2019   grade_12 206 6 2 0   5     0   1   102 118                       220.0 206 6 2 0   5     0   1   102 118                 220
2045620 2045620 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk High   Regular School No High 09 12 2019   grade_12 139 5 3 0   5     0   5   68 89                       157.0 139 5 3 0   5     0   5   68 89                 157
2045646 2045646 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No High 09 12 2019   grade_12 177 24 16 1   63     0   8   146 143                       289.0 177 24 16 1   63     0   8   146 143                 289

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