enrollments

Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,637 ✖
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
738564 738564 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2015   grade_9 28 1 1 0   0     0   2   16 16                       32 28 1 1 0   0     0   2   16 16                 32
738606 738606 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
738631 738631 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2015   grade_9 314 10 110 0   6     0   3   234 209                       443 314 10 110 0   6     0   3   234 209                 443
738664 738664 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No 3 09 12 2015   grade_9 304 4 8 0   12     0   9   169 168                       337 304 4 8 0   12     0   9   169 168                 337
738679 738679 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2015   grade_9 36 23 7 0   3     0   6   42 33                       75 36 23 7 0   3     0   6   42 33                 75
738702 738702 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No 3 09 12 2015   grade_9 178 2 2 0   8     0   5   96 99                       195 178 2 2 0   8     0   5   96 99                 195
738773 738773 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2015   grade_9 96 14 280 0   6     0   9   224 181                       405 96 14 280 0   6     0   9   224 181                 405
738777 738777 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_9 5 0 116 0   1     0   0   66 56                       122 5 0 116 0   1     0   0   66 56                 122
738791 738791 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2015   grade_9 89 0 0 0   1     0   0   44 46                       90 89 0 0 0   1     0   0   44 46                 90
738805 738805 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No 3 09 12 2015   grade_9 233 3 2 1   25     0   2   132 134                       266 233 3 2 1   25     0   2   132 134                 266
738832 738832 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No 3 08 12 2015   grade_9 184 4 12 1   3     0   3   100 107                       207 184 4 12 1   3     0   3   100 107                 207
738846 738846 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No 3 09 12 2015   grade_9 63 1 1 0   0     0   1   34 32                       66 63 1 1 0   0     0   1   34 32                 66
738867 738867 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No 3 09 12 2015   grade_9 114 1 4 0   3     0   2   68 56                       124 114 1 4 0   3     0   2   68 56                 124
738979 738979 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2015   grade_9 10 3 133 0   1     0   0   101 46                       147 10 3 133 0   1     0   0   101 46                 147
738983 738983 MA Essex   school 2506660 149   Lawrence 250666002636 1490531 Health & Human Services High School   Regular School No 3 09 12 2015   grade_9 5 2 151 0   3     0   0   53 108                       161 5 2 151 0   3     0   0   53 108                 161
738987 738987 MA Essex   school 2506660 149   Lawrence 250666002633 1490532 Humanities & Leadership Development High School   Regular School No 3 09 12 2015   grade_9 5 3 164 0   3     0   0   99 76                       175 5 3 164 0   3     0   0   99 76                 175
738992 738992 MA Essex   school 2506660 149   Lawrence 250666002618 1490533 Math, Science & Technology High School   Regular School No 3 09 12 2015   grade_9 13 2 137 0   8     0   1   118 43                       161 13 2 137 0   8     0   1   118 43                 161
738996 738996 MA Essex   school 2506660 149   Lawrence 250666002631 1490534 International High School   Regular School No 3 09 12 2015   grade_9 2 1 124 0   0     0   0   69 58                       127 2 1 124 0   0     0   0   69 58                 127
739000 739000 MA Essex   school 2506660 149   Lawrence 250666002616 1490535 Performing & Fine Arts High School   Regular School No 3 09 12 2015   grade_9 6 3 114 0   0     0   0   44 79                       123 6 3 114 0   0     0   0   44 79                 123
739005 739005 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No 3 09 12 2015   grade_9 1 0 15 0   0     0   0   8 8                       16 1 0 15 0   0     0   0   8 8                 16
739017 739017 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_9 0 1 19 0   0     0   0   18 2                       20 0 1 19 0   0     0   0   18 2                 20
739022 739022 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2015   grade_9 4 4 86 0   2     0   0   53 43                       96 4 4 86 0   2     0   0   53 43                 96
739036 739036 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2015   grade_9 50 0 3 0   0     0   1   28 26                       54 50 0 3 0   0     0   1   28 26                 54
739050 739050 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No 3 09 12 2015   grade_9 106 3 6 0   1     0   0   59 57                       116 106 3 6 0   1     0   0   59 57                 116
739064 739064 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_9 56 0 3 0   4     0   1   33 31                       64 56 0 3 0   4     0   1   33 31                 64
739102 739102 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No 3 09 12 2015   grade_9 140 16 33 0   4     0   3   95 101                       196 140 16 33 0   4     0   3   95 101                 196
739108 739108 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Vocational Education School No 3 09 12 2015   grade_9 187 26 121 1   19     1   6   208 153                       361 187 26 121 1   19     1   6   208 153                 361
739163 739163 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_9 317 18 25 1   169     0   25   295 260                       555 317 18 25 1   169     0   25   295 260                 555
739197 739197 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2015   grade_9 93 3 2 0   3     1   3   52 53                       105 93 3 2 0   3     1   3   52 53                 105
739226 739226 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No 3 09 12 2015   grade_9 198 10 8 0   20     0   2   122 116                       238 198 10 8 0   20     0   2   122 116                 238
739340 739340 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No 3 08 12 2015   grade_9 1 2 3 0   0     0   0   5 *                       6 1 2 3 0   0     0   0   5                   6
739360 739360 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_9 277 84 226 1   289     0   12   466 423                       889 277 84 226 1   289     0   12   466 423                 889
739375 739375 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No 3 09 12 2015   grade_9 211 3 24 1   1     2   4   123 123                       246 211 3 24 1   1     2   4   123 123                 246
739390 739390 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2015   grade_9 102 1 3 0   1     0   1   50 58                       108 102 1 3 0   1     0   1   50 58                 108
739517 739517 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2015   grade_9 92 55 293 1   55     0   12   266 242                       508 92 55 293 1   55     0   12   266 242                 508
739522 739522 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2015   grade_9 93 52 313 0   25     0   23   293 213                       506 93 52 313 0   25     0   23   293 213                 506
739529 739529 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2015   grade_9 6 6 17 0   4     0   2   18 17                       35 6 6 17 0   4     0   2   18 17                 35
739536 739536 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   grade_9 30 28 167 1   9     0   6   149 92                       241 30 28 167 1   9     0   6   149 92                 241
739556 739556 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No 3 09 12 2015   grade_9 141 3 6 0   4     0   2   72 84                       156 141 3 6 0   4     0   2   72 84                 156
739606 739606 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_9 133 97 138 2   117     0   15   274 228                       502 133 97 138 2   117     0   15   274 228                 502
739620 739620 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_9 269 14 13 1   10     0   7   148 166                       314 269 14 13 1   10     0   7   148 166                 314
739644 739644 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No 3 09 12 2015   grade_9 216 17 15 0   1     0   2   111 140                       251 216 17 15 0   1     0   2   111 140                 251
739677 739677 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No 3 09 12 2015   grade_9 161 12 106 0   16     0   2   148 149                       297 161 12 106 0   16     0   2   148 149                 297
739717 739717 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield High   Regular School No 3 09 12 2015   grade_9 346 3 9 1   2     0   3   184 180                       364 346 3 9 1   2     0   3   184 180                 364
739731 739731 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_9 100 4 4 4   1     0   6   54 65                       119 100 4 4 4   1     0   6   54 65                 119
739753 739753 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2015   grade_9 71 6 11 0   4     0   3   37 58                       95 71 6 11 0   4     0   3   37 58                 95
739767 739767 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No 3 09 12 2015   grade_9 206 1 2 0   9     1   7   103 123                       226 206 1 2 0   9     1   7   103 123                 226
739806 739806 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No 3 09 12 2015   grade_9 197 63 39 0   35     0   9   163 180                       343 197 63 39 0   35     0   9   163 180                 343
739814 739814 MA Middlesex   school 2507560 176   Medford 250756001174 1760605 Medford Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_9 37 4 3 0   1     0   4   24 25                       49 37 4 3 0   1     0   4   24 25                 49
739828 739828 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway High   Regular School No 3 09 12 2015   grade_9 187 1 7 2   4     0   2   106 97                       203 187 1 7 2   4     0   2   106 97                 203
739866 739866 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No 3 09 12 2015   grade_9 183 23 13 0   6     0   8   111 122                       233 183 23 13 0   6     0   8   111 122                 233
739910 739910 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No 3 09 12 2015   grade_9 282 16 154 1   22     0   3   255 223                       478 282 16 154 1   22     0   3   255 223                 478
739930 739930 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No 3 09 12 2015   grade_9 177 4 5 0   0     0   5   95 96                       191 177 4 5 0   0     0   5   95 96                 191
739956 739956 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2015   grade_9 185 8 80 5   11     1   6   136 160                       296 185 8 80 5   11     1   6   136 160                 296
739971 739971 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2015   grade_9 103 1 3 2   1     0   1   53 58                       111 103 1 3 2   1     0   1   53 58                 111
739986 739986 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No 3 09 12 2015   grade_9 104 2 4 2   3     0   2   61 56                       117 104 2 4 2   3     0   2   61 56                 117
740019 740019 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2015   grade_9 158 65 8 0   17     3   10   129 132                       261 158 65 8 0   17     3   10   129 132                 261
740034 740034 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson Innovation High School   Regular School No 3 09 12 2015   grade_9 65 0 3 1   0     0   1   36 34                       70 65 0 3 1   0     0   1   36 34                 70
740057 740057 MA Nantucket   school 2508250 197   Nantucket 250825001282 1970505 Nantucket High   Regular School No 3 09 12 2015   grade_9 83 18 30 0   2     0   3   75 61                       136 83 18 30 0   2     0   3   75 61                 136
740096 740096 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No 3 09 12 2015   grade_9 334 13 13 0   21     1   14   199 197                       396 334 13 13 0   21     1   14   199 197                 396
740134 740134 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No 3 09 12 2015   grade_9 331 14 21 0   25     1   5   205 192                       397 331 14 21 0   25     1   5   205 192                 397
740275 740275 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_9 213 54 248 8   3     4   27   322 235                       557 213 54 248 8   3     4   27   322 235                 557
740281 740281 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No 3 07 12 2015   grade_9 7 0 3 0   0     0   0   9 1                       10 7 0 3 0   0     0   0   9 1                 10
740288 740288 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_9 6 6 9 0   0     0   4   22 3                       25 6 6 9 0   0     0   4   22 3                 25
740301 740301 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No 3 09 12 2015   grade_9 177 2 8 0   1     0   7   94 101                       195 177 2 8 0   1     0   7   94 101                 195
740409 740409 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_9 368 25 44 0   81     2   19   275 264                       539 368 25 44 0   81     2   19   275 264                 539
740414 740414 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_9 299 16 24 0   87     0   18   212 232                       444 299 16 24 0   87     0   18   212 232                 444
740453 740453 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_9 65 2 5 0   0     0   6   37 41                       78 65 2 5 0   0     0   6   37 41                 78
740485 740485 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No 3 09 12 2015   grade_9 180 6 29 0   13     0   6   105 129                       234 180 6 29 0   13     0   6   105 129                 234
740524 740524 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2015   grade_9 300 11 23 3   28     1   3   180 189                       369 300 11 23 3   28     1   3   180 189                 369
740567 740567 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No 3 09 12 2015   grade_9 270 7 16 2   18     0   4   140 177                       317 270 7 16 2   18     0   4   140 177                 317
740610 740610 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No 3 09 12 2015   grade_9 142 0 22 0   3     0   3   88 82                       170 142 0 22 0   3     0   3   88 82                 170
740625 740625 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2015   grade_9 24 2 2 0   0     0   1   15 14                       29 24 2 2 0   0     0   1   15 14                 29
740651 740651 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2015   grade_9 206 1 7 0   9     2   1   103 123                       226 206 1 7 0   9     2   1   103 123                 226
740669 740669 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No 3 09 12 2015   grade_9 186 4 2 0   3     0   0   99 96                       195 186 4 2 0   3     0   0   99 96                 195
740690 740690 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No 3 09 12 2015   grade_9 156 0 5 0   1     0   2   85 79                       164 156 0 5 0   1     0   2   85 79                 164
740724 740724 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No 3 09 12 2015   grade_9 185 26 18 0   8     0   5   119 123                       242 185 26 18 0   8     0   5   119 123                 242
740767 740767 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No 3 09 12 2015   grade_9 92 1 14 1   0     0   3   56 55                       111 92 1 14 1   0     0   3   56 55                 111
740782 740782 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No 3 08 12 2015   grade_9 84 2 1 0   1     0   2   48 42                       90 84 2 1 0   1     0   2   48 42                 90
740843 740843 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No 3 09 12 2015   grade_9 278 16 70 0   10     0   10   189 195                       384 278 16 70 0   10     0   10   189 195                 384
740878 740878 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2015   grade_9 267 2 1 0   3     2   2   149 128                       277 267 2 1 0   3     2   2   149 128                 277
740948 740948 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No 3 09 12 2015   grade_9 146 32 24 0   4     0   15   120 101                       221 146 32 24 0   4     0   15   120 101                 221
740952 740952 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No 3 09 12 2015   grade_9 145 18 15 0   2     0   13   91 102                       193 145 18 15 0   2     0   13   91 102                 193
741020 741020 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth North High   Regular School No 3 09 12 2015   grade_9 296 8 20 2   2     0   13   165 176                       341 296 8 20 2   2     0   13   165 176                 341
741024 741024 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No 3 09 12 2015   grade_9 252 7 9 1   3     0   7   148 131                       279 252 7 9 1   3     0   7   148 131                 279
741128 741128 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2015   grade_9 234 37 27 3   66     1   12   206 174                       380 234 37 27 3   66     1   12   206 174                 380
741132 741132 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2015   grade_9 102 7 14 1   162     0   2   151 137                       288 102 7 14 1   162     0   2   151 137                 288
741165 741165 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No 3 09 12 2015   grade_9 25 92 14 1   36     1   10   97 82                       179 25 92 14 1   36     1   10   97 82                 179
741207 741207 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No 3 09 12 2015   grade_9 249 5 2 0   11     0   3   137 133                       270 249 5 2 0   11     0   3   137 133                 270
741259 741259 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2015   grade_9 164 24 295 1   31     0   12   278 249                       527 164 24 295 1   31     0   12   278 249                 527
741264 741264 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Seacoast School   Regular School No 3 09 12 2015   grade_9 17 8 25 0   2     0   2   40 14                       54 17 8 25 0   2     0   2   40 14                 54
741304 741304 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No 3 09 12 2015   grade_9 132 7 7 0   2     0   9   83 74                       157 132 7 7 0   2     0   9   83 74                 157
741319 741319 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No 3 09 12 2015   grade_9 61 1 3 0   0     0   3   34 34                       68 61 1 3 0   0     0   3   34 34                 68
741382 741382 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No 3 09 12 2015   grade_9 105 20 108 1   8     0   12   133 121                       254 105 20 108 1   8     0   12   133 121                 254
741413 741413 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No 3 09 12 2015   grade_9 170 1 1 1   3     0   0   91 85                       176 170 1 1 1   3     0   0   91 85                 176
741445 741445 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No 3 09 12 2015   grade_9 113 3 19 1   10     1   2   68 81                       149 113 3 19 1   10     1   2   68 81                 149
741488 741488 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No 3 09 12 2015   grade_9 210 5 1 0   2     0   3   94 127                       221 210 5 1 0   2     0   3   94 127                 221
741509 741509 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk High   Regular School No 3 09 12 2015   grade_9 125 1 4 0   2     0   1   59 74                       133 125 1 4 0   2     0   1   59 74                 133
741535 741535 MA Norfolk   school 2510620 266   Sharon 251062001705 2660505 Sharon High   Regular School No 3 09 12 2015   grade_9 166 19 7 0   57     0   7   136 120                       256 166 19 7 0   57     0   7   136 120                 256
741572 741572 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No 3 09 12 2015   grade_9 310 9 26 0   73     1   13   187 245                       432 310 9 26 0   73     1   13   187 245                 432

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