enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 292 ✖

grade ✖

  • grade_9 · 292 ✖
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
935414 935414 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2016   grade_9 27 0 1 0   2     0   0   13 17                       30 27 0 1 0   2     0   0   13 17                 30
935434 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 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
935510 935510 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No 3 09 12 2016   grade_9 271 4 4 0   3     0   4   144 142                       286 271 4 4 0   3     0   4   144 142                 286
935525 935525 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2016   grade_9 29 13 12 1   2     0   1   31 27                       58 29 13 12 1   2     0   1   31 27                 58
935547 935547 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No 3 09 12 2016   grade_9 170 1 7 0   10     0   4   93 99                       192 170 1 7 0   10     0   4   93 99                 192
935621 935621 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2016   grade_9 73 15 272 0   1     0   5   194 172                       366 73 15 272 0   1     0   5   194 172                 366
935625 935625 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 3 5 104 0   1     0   0   56 57                       113 3 5 104 0   1     0   0   56 57                 113
935640 935640 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2016   grade_9 79 0 2 4   0     0   3   42 46                       88 79 0 2 4   0     0   3   42 46                 88
935654 935654 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No 3 09 12 2016   grade_9 234 0 6 0   13     0   6   132 127                       259 234 0 6 0   13     0   6   132 127                 259
935681 935681 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No 3 08 12 2016   grade_9 185 3 11 0   7     0   2   117 91                       208 185 3 11 0   7     0   2   117 91                 208
935695 935695 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No 3 09 12 2016   grade_9 78 0 3 0   0     0   1   42 40                       82 78 0 3 0   0     0   1   42 40                 82
935716 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 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 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 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 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 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 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 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 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 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 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
935885 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
935899 935899 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No 3 09 12 2016   grade_9 95 6 4 1   2     1   0   54 55                       109 95 6 4 1   2     1   0   54 55                 109
935913 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
935950 935950 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No 3 09 12 2016   grade_9 268 36 123 1   16     0   14   258 200                       458 268 36 123 1   16     0   14   258 200                 458
935954 935954 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No 3 09 12 2016   grade_9 4 1 1 0   0     0   1   3 4                       7 4 1 1 0   0     0   1   3 4                 7
936009 936009 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2016   grade_9 309 14 16 0   184     0   25   275 273                       548 309 14 16 0   184     0   25   275 273                 548
936043 936043 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No 3 09 12 2016   grade_9 99 0 1 0   4     1   4   50 59                       109 99 0 1 0   4     1   4   50 59                 109
936072 936072 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No 3 09 12 2016   grade_9 210 5 9 0   20     0   3   131 116                       247 210 5 9 0   20     0   3   131 116                 247
936187 936187 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No 3 08 12 2016   grade_9 0 0 5 0   1     0   0   4 2                       6 0 0 5 0   1     0   0   4 2                 6
936207 936207 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_9 253 96 223 0   259     0   24   432 423                       855 253 96 223 0   259     0   24   432 423                 855
936222 936222 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No 3 09 12 2016   grade_9 210 7 22 1   0     0   4   124 120                       244 210 7 22 1   0     0   4   124 120                 244
936237 936237 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2016   grade_9 101 1 5 1   8     1   0   58 59                       117 101 1 5 1   8     1   0   58 59                 117
936365 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 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 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 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 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
936451 936451 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2016   grade_9 152 101 123 4   112     0   12   265 239                       504 152 101 123 4   112     0   12   265 239                 504
936465 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
936488 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
936521 936521 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No 3 09 12 2016   grade_9 133 8 127 0   4     0   6   144 134                       278 133 8 127 0   4     0   6   144 134                 278
936561 936561 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield High   Regular School No 3 09 12 2016   grade_9 335 2 10 0   3     1   3   173 181                       354 335 2 10 0   3     1   3   173 181                 354
936575 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
936597 936597 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2016   grade_9 72 2 14 1   4     0   6   50 49                       99 72 2 14 1   4     0   6   50 49                 99
936611 936611 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No 3 09 12 2016   grade_9 177 1 3 0   13     1   3   101 97                       198 177 1 3 0   13     1   3   101 97                 198
936650 936650 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No 3 09 12 2016   grade_9 188 50 29 0   23     0   8   135 163                       298 188 50 29 0   23     0   8   135 163                 298
936655 936655 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   1 *                       1                         1                   1
936659 936659 MA Middlesex   school 2507560 176   Medford 250756001174 1760605 Medford Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 58 16 11 0   0     0   5   55 35                       90 58 16 11 0   0     0   5   55 35                 90
936673 936673 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway High   Regular School No 3 09 12 2016   grade_9 160 3 4 0   6     1   3   85 92                       177 160 3 4 0   6     1   3   85 92                 177
936711 936711 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No 3 09 12 2016   grade_9 217 17 9 0   5     1   3   122 130                       252 217 17 9 0   5     1   3   122 130                 252
936755 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
936775 936775 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No 3 09 12 2016   grade_9 164 8 9 0   4     0   9   90 104                       194 164 8 9 0   4     0   9   90 104                 194
936802 936802 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2016   grade_9 183 6 60 5   9     0   2   138 127                       265 183 6 60 5   9     0   2   138 127                 265
936817 936817 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2016   grade_9 92 2 11 0   1     0   5   63 48                       111 92 2 11 0   1     0   5   63 48                 111
936832 936832 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No 3 09 12 2016   grade_9 82 2 2 1   1     0   0   34 54                       88 82 2 2 1   1     0   0   34 54                 88
936866 936866 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2016   grade_9 158 51 12 0   14     1   11   115 132                       247 158 51 12 0   14     1   11   115 132                 247
936881 936881 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No 3 09 12 2016   grade_9 69 0 1 0   1     0   2   39 34                       73 69 0 1 0   1     0   2   39 34                 73
936903 936903 MA Nantucket   school 2508250 197   Nantucket 250825001282 1970505 Nantucket High   Regular School No 3 09 12 2016   grade_9 91 16 32 0   1     0   6   87 59                       146 91 16 32 0   1     0   6   87 59                 146
936941 936941 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No 3 09 12 2016   grade_9 308 14 21 0   26     0   12   193 188                       381 308 14 21 0   26     0   12   193 188                 381
936979 936979 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No 3 09 12 2016   grade_9 360 18 19 1   36     0   15   224 225                       449 360 18 19 1   36     0   15   224 225                 449
937113 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 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 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
937137 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
937245 937245 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2016   grade_9 349 20 47 2   81     0   23   260 262                       522 349 20 47 2   81     0   23   260 262                 522
937250 937250 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2016   grade_9 304 25 19 1   84     0   15   232 216                       448 304 25 19 1   84     0   15   232 216                 448
937288 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
937321 937321 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No 3 09 12 2016   grade_9 174 6 28 0   12     0   9   104 125                       229 174 6 28 0   12     0   9   104 125                 229
937359 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
937397 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
937440 937440 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No 3 09 12 2016   grade_9 139 2 11 0   0     0   3   79 76                       155 139 2 11 0   0     0   3   79 76                 155
937454 937454 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2016   grade_9 41 0 2 0   0     0   2   22 23                       45 41 0 2 0   0     0   2   22 23                 45
937480 937480 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2016   grade_9 180 0 3 0   5     0   4   93 99                       192 180 0 3 0   5     0   4   93 99                 192
937498 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
937519 937519 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No 3 09 12 2016   grade_9 167 0 3 0   4     0   2   89 87                       176 167 0 3 0   4     0   2   89 87                 176
937553 937553 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No 3 09 12 2016   grade_9 166 24 14 0   9     0   7   117 103                       220 166 24 14 0   9     0   7   117 103                 220
937588 937588 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_9 5 1 2 0   0     0   0   6 *                       8 5 1 2 0   0     0   0   6                   8
937596 937596 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No 3 09 12 2016   grade_9 70 3 6 0   3     0   5   38 49                       87 70 3 6 0   3     0   5   38 49                 87
937611 937611 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No 3 08 12 2016   grade_9 88 3 7 0   5     0   2   45 60                       105 88 3 7 0   5     0   2   45 60                 105
937670 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
937706 937706 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2016   grade_9 237 4 1 0   1     0   1   124 120                       244 237 4 1 0   1     0   1   124 120                 244
937776 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 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
937849 937849 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth North High   Regular School No 3 09 12 2016   grade_9 291 8 28 2   7     0   16   177 175                       352 291 8 28 2   7     0   16   177 175                 352
937853 937853 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No 3 09 12 2016   grade_9 246 3 7 1   1     1   10   135 134                       269 246 3 7 1   1     1   10   135 134                 269
937957 937957 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2016   grade_9 252 21 27 1   61     2   14   225 153                       378 252 21 27 1   61     2   14   225 153                 378
937961 937961 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No 3 09 12 2016   grade_9 120 14 10 0   164     1   6   167 148                       315 120 14 10 0   164     1   6   167 148                 315
937994 937994 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No 3 09 12 2016   grade_9 11 110 24 0   24     0   9   99 79                       178 11 110 24 0   24     0   9   99 79                 178
938035 938035 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No 3 09 12 2016   grade_9 299 8 5 0   15     0   1   165 163                       328 299 8 5 0   15     0   1   165 163                 328
938087 938087 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2016   grade_9 163 31 265 3   33     0   12   251 256                       507 163 31 265 3   33     0   12   251 256                 507
938092 938092 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Seacoast School   Regular School No 3 09 12 2016   grade_9 7 4 33 0   4     0   5   34 19                       53 7 4 33 0   4     0   5   34 19                 53
938131 938131 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No 3 09 12 2016   grade_9 114 12 18 0   0     0   5   74 75                       149 114 12 18 0   0     0   5   74 75                 149
938145 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 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
938220 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
938252 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
938294 938294 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No 3 09 12 2016   grade_9 199 9 0 0   3     0   2   101 112                       213 199 9 0 0   3     0   2   101 112                 213

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