enrollments

Data source: Big Local News · About: Big Local

393 rows where grade = "grade_9", state = "MA" and year = 2018 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 393 ✖

grade ✖

  • grade_9 · 393 ✖
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
2228768 2228768 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_9 126 7 17 1   1     0   1   81 72                       153.0 126 7 17 1   1     0   1   81 72                 153
2228985 2228985 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington: Arlington High   Regular School No High 09 12 2018   grade_9 261 16 23 0   36     0   14   168 182                       350.0 261 16 23 0   36     0   14   168 182                 350
2231861 2231861 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham: Framingham High School   Regular School No High 09 12 2018   grade_9 346 50 132 0   31     0   21   288 292                       580.0 346 50 132 0   31     0   21   288 292                 580
2231922 2231922 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_9 386 9 10 2   36     0   9   231 221                       452.0 386 9 10 2   36     0   9   231 221                 452
2231940 2231940 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   grade_9 128 9 21 0   2     0   9   93 76                       169.0 128 9 21 0   2     0   9   93 76                 169
2231945 2231945 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner: Gardner Academy for Learning and Technology   Alternative School No High 09 12 2018   grade_9 12 0 1 1   0     0   1   8 7                       15.0 12 0 1 1   0     0   1   8 7                 15
2231963 2231963 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown: Georgetown High School   Regular School No High 09 12 2018   grade_9 87 0 2 0   1     0   0   43 47                       90.0 87 0 2 0   1     0   0   43 47                 90
2232009 2232009 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester: Gloucester High   Regular School No High 09 12 2018   grade_9 162 5 30 1   0     1   3   108 94                       202.0 162 5 30 1   0     1   3   108 94                 202
2232024 2232024 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2232052 2232052 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton: Grafton High School   Regular School No High 09 12 2018   grade_9 161 7 10 0   11     0   6   95 100                       195.0 161 7 10 0   11     0   6   95 100                 195
2232069 2232069 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby: Granby Jr Sr High School   Regular School No High 07 12 2018   grade_9 42 0 6 0   3     0   3   32 22                       54.0 42 0 6 0   3     0   3   32 22                 54
2232099 2232099 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield: Greenfield High   Regular School No High 08 12 2018   grade_9 59 3 18 0   2     0   7   51 38                       89.0 59 3 18 0   2     0   7   51 38                 89
2232115 2232115 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley: Hopkins Academy   Regular School No High 07 12 2018   grade_9 32 0 3 0   0     0   3   21 17                       38.0 32 0 3 0   0     0   3   21 17                 38
2232154 2232154 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover: Hanover High   Regular School No High 09 12 2018   grade_9 193 3 4 0   6     0   0   100 106                       206.0 193 3 4 0   6     0   0   100 106                 206
2232170 2232170 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard: Bromfield   Regular School No High 06 12 2018   grade_9 83 3 3 0   12     0   3   54 50                       104.0 83 3 3 0   12     0   3   54 50                 104
2232186 2232186 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield: Smith Academy   Regular School No High 07 12 2018   grade_9 23 0 1 0   0     0   0   19 5                       24.0 23 0 1 0   0     0   0   19 5                 24
2232221 2232221 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill: Haverhill Alternative School   Regular School No High 06 12 2018   grade_9 3 0 3 0   0     0   0   4 2                       6.0 3 0 3 0   0     0   0   4 2                 6
2232242 2232242 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   grade_9 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2232268 2232268 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill: Haverhill High   Regular School No High 09 12 2018   grade_9 339 25 197 1   6     0   8   309 267                       576.0 339 25 197 1   6     0   8   309 267                 576
2232306 2232306 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham: Hingham High   Regular School No High 09 12 2018   grade_9 304 6 7 0   6     0   5   149 179                       328.0 304 6 7 0   6     0   5   149 179                 328
2232322 2232322 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_9 34 15 12 0   5     0   1   36 31                       67.0 34 15 12 0   5     0   1   36 31                 67
2232349 2232349 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston: Holliston High   Regular School No High 09 12 2018   grade_9 175 2 5 2   15     0   3   102 100                       202.0 175 2 5 2   15     0   3   102 100                 202
2232436 2232436 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke: Holyoke High   Regular School No High 09 12 2018   grade_9 74 6 378 1   4     0   2   254 211                       465.0 74 6 378 1   4     0   2   254 211                 465
2232457 2232457 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale: Hopedale Jr Sr High   Regular School No High 07 12 2018   grade_9 70 0 2 1   3     0   1   38 39                       77.0 70 0 2 1   3     0   1   38 39                 77
2232477 2232477 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton: Hopkinton High   Regular School No High 09 12 2018   grade_9 257 3 5 1   43     0   3   155 157                       312.0 257 3 5 1   43     0   3   155 157                 312
2229004 2229004 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland: Ashland High   Regular School No High 09 12 2018   grade_9 151 4 23 0   19     0   9   99 106                       206.0 151 4 23 0   19     0   9   99 106                 206
2232507 2232507 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson: Hudson High   Regular School No High 08 12 2018   grade_9 143 5 15 1   1     0   3   84 84                       168.0 143 5 15 1   1     0   3   84 84                 168
2232524 2232524 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull: Hull High   Regular School No High 09 12 2018   grade_9 74 2 1 0   0     0   1   40 38                       78.0 74 2 1 0   0     0   1   40 38                 78
2232549 2232549 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich: Ipswich High   Regular School No High 09 12 2018   grade_9 119 2 5 0   4     0   4   66 68                       134.0 119 2 5 0   4     0   4   66 68                 134
2232680 2232680 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_9 30 6 854 0   20     0   1   500 411                       911.0 30 6 854 0   20     0   1   500 411                 911
2232690 2232690 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 Lawrence: High School Learning Center   Regular School No High 09 12 2018   grade_9 0 0 14 0   0     0   0   9 5                       14.0 0 0 14 0   0     0   0   9 5                 14
2232702 2232702 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_9 2 0 22 0   1     0   0   18 7                       25.0 2 0 22 0   1     0   0   18 7                 25
2232707 2232707 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Lawrence: Phoenix Academy Lawrence   Alternative School No High 09 12 2018   grade_9 1 0 12 0   0     0   0   6 7                       13.0 1 0 12 0   0     0   0   6 7                 13
2232723 2232723 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee: Lee Middle/High School   Regular School No High 07 12 2018   grade_9 64 1 4 1   1     0   1   32 40                       72.0 64 1 4 1   1     0   1   32 40                 72
2232741 2232741 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester: Leicester High   Regular School No High 09 12 2018   grade_9 91 4 12 1   4     0   2   65 49                       114.0 91 4 12 1   4     0   2   65 49                 114
2232757 2232757 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox: Lenox Memorial High   Regular School No High 06 12 2018   grade_9 50 0 5 0   7     0   4   33 33                       66.0 50 0 5 0   7     0   4   33 33                 66
2232804 2232804 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster: Leominster High School   Regular School No High 09 12 2018   grade_9 111 10 41 0   5     0   7   65 109                       174.0 111 10 41 0   5     0   7   65 109                 174
2232809 2232809 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster: Leominster Center for Excellence   Regular School No High 09 12 2018   grade_9 11 0 2 0   0     0   1   8 6                       14.0 11 0 2 0   0     0   1   8 6                 14
2232814 2232814 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Leominster: Center For Technical Education Innovation   Career and Technical School No High 09 12 2018   grade_9 130 23 110 0   8     0   7   168 110                       278.0 130 23 110 0   8     0   7   168 110                 278
2232880 2232880 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington: Lexington High   Regular School No High 09 12 2018   grade_9 267 17 20 2   191     0   33   260 270                       530.0 267 17 20 2   191     0   33   260 270                 530
2232921 2232921 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton: Littleton High School   Regular School No High 09 12 2018   grade_9 98 0 4 1   10     0   3   47 69                       116.0 98 0 4 1   10     0   3   47 69                 116
2232956 2232956 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow: Longmeadow High   Regular School No High 09 12 2018   grade_9 189 9 7 1   21     0   8   118 117                       235.0 189 9 7 1   21     0   8   118 117                 235
2229056 2229056 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_9 309 27 66 1   25     2   26   242 214                       456.0 309 27 66 1   25     2   26   242 214                 456
2233093 2233093 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Lowell: Leblanc Therapeutic Day School   Regular School No High 09 12 2018   grade_9 1 0 4 0   0     0   1   5 1                       6.0 1 0 4 0   0     0   1   5 1                 6
2233118 2233118 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_9 214 80 242 1   256     0   29   409 413                       822.0 214 80 242 1   256     0   29   409 413                 822
2233123 2233123 MA Middlesex   school 2507020 160   Lowell 250702002860 1600515 Lowell: The Career Academy   Regular School No High 09 12 2018   grade_9 7 3 14 0   2     0   2   23 5                       28.0 7 3 14 0   2     0   2   23 5                 28
2233147 2233147 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow: Ludlow Senior High   Regular School No High 09 12 2018   grade_9 222 4 17 0   0     0   10   124 129                       253.0 222 4 17 0   0     0   10   124 129                 253
2233165 2233165 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg: Lunenburg High   Regular School No High 09 12 2018   grade_9 115 1 5 2   0     0   1   73 51                       124.0 115 1 5 2   0     0   1   73 51                 124
2233313 2233313 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn: Classical High   Regular School No High 09 12 2018   grade_9 68 30 274 2   30     0   7   240 171                       411.0 68 30 274 2   30     0   7   240 171                 411
2233318 2233318 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn: Lynn English High   Regular School No High 09 12 2018   grade_9 73 44 345 1   41     0   13   317 200                       517.0 73 44 345 1   41     0   13   317 200                 517
2233325 2233325 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn: Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2018   grade_9 7 0 17 0   0     0   1   14 11                       25.0 7 0 17 0   0     0   1   14 11                 25
2233333 2233333 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_9 42 21 167 0   20     0   6   145 111                       256.0 42 21 167 0   20     0   6   145 111                 256
2233357 2233357 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield: Lynnfield High   Regular School No High 09 12 2018   grade_9 149 1 9 0   7     0   3   77 92                       169.0 149 1 9 0   7     0   3   77 92                 169
2233414 2233414 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden: Malden High   Regular School No High 09 12 2018   grade_9 131 87 127 2   108     0   17   278 193                       472.0 131 87 127 2   108     0   17   278 193                 472
2233433 2233433 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield: Mansfield High   Regular School No High 09 12 2018   grade_9 285 16 13 0   21     0   13   166 182                       348.0 285 16 13 0   21     0   13   166 182                 348
2233462 2233462 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead: Marblehead High   Regular School No High 09 12 2018   grade_9 233 7 14 0   6     0   6   128 138                       266.0 233 7 14 0   6     0   6   128 138                 266
2229082 2229082 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn: Auburn Senior High   Regular School No High 09 12 2018   grade_9 155 3 6 1   11     0   5   79 102                       181.0 155 3 6 1   11     0   5   79 102                 181
2233501 2233501 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough: Marlborough High   Regular School No High 09 12 2018   grade_9 107 8 130 0   3     0   6   132 122                       254.0 107 8 130 0   3     0   6   132 122                 254
2233547 2233547 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield: Marshfield High   Regular School No High 09 12 2018   grade_9 297 1 13 1   5     0   3   155 165                       320.0 297 1 13 1   5     0   3   155 165                 320
2233565 2233565 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee: Mashpee High   Regular School No High 09 12 2018   grade_9 99 7 7 8   5     0   3   64 65                       129.0 99 7 7 8   5     0   3   64 65                 129
2233592 2233592 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard: Maynard High   Regular School No High 09 12 2018   grade_9 77 1 8 0   2     0   5   45 48                       93.0 77 1 8 0   2     0   5   45 48                 93
2233611 2233611 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield: Medfield Senior High   Regular School No High 09 12 2018   grade_9 175 2 4 0   10     0   8   97 102                       199.0 175 2 4 0   10     0   8   97 102                 199
2233657 2233657 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford: Medford High   Regular School No High 09 12 2018   grade_9 209 39 42 0   31     1   12   171 163                       334.0 209 39 42 0   31     1   12   171 163                 334
2233662 2233662 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Medford: Curtis-Tufts   Regular School No High 09 12 2018   grade_9 * * * *   *     *   *   1 *                       1.0                         1                   1
2233680 2233680 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway: Medway High   Regular School No High 09 12 2018   grade_9 133 4 5 0   13     0   0   79 76                       155.0 133 4 5 0   13     0   0   79 76                 155
2233726 2233726 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose: Melrose High   Regular School No High 09 12 2018   grade_9 197 19 6 0   10     0   7   108 131                       239.0 197 19 6 0   10     0   7   108 131                 239
2229098 2229098 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_9 19 16 1 0   2     0   1   29 10                       39.0 19 16 1 0   2     0   1   29 10                 39
2233775 2233775 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen: Methuen High   Regular School No High 09 12 2018   grade_9 258 4 188 1   24     0   23   264 234                       498.0 258 4 188 1   24     0   23   264 234                 498
2233799 2233799 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough: Middleborough High   Regular School No High 09 12 2018   grade_9 179 7 5 1   2     0   7   107 94                       201.0 179 7 5 1   2     0   7   107 94                 201
2233832 2233832 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford: Milford High   Regular School No High 09 12 2018   grade_9 181 11 77 6   5     0   11   149 142                       291.0 181 11 77 6   5     0   11   149 142                 291
2233849 2233849 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury: Millbury Junior/Senior High   Regular School No High 07 12 2018   grade_9 101 3 8 0   2     0   5   59 60                       119.0 101 3 8 0   2     0   5   59 60                 119
2233866 2233866 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis: Millis High School   Regular School No High 09 12 2018   grade_9 80 0 2 0   7     1   1   53 38                       91.0 80 0 2 0   7     1   1   53 38                 91
2233906 2233906 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton: Milton High   Regular School No High 09 12 2018   grade_9 174 54 13 0   16     0   11   136 131                       268.0 174 54 13 0   16     0   11   136 131                 268
2233923 2233923 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson: Monson High School   Regular School No High 09 12 2018   grade_9 59 2 0 0   0     0   0   29 32                       61.0 59 2 0 0   0     0   0   29 32                 61
2233950 2233950 MA Nantucket   school 2508250 197   Nantucket 250825001282 1970505 Nantucket: Nantucket High   Regular School No High 09 12 2018   grade_9 75 17 23 0   2     1   2   65 55                       120.0 75 17 23 0   2     1   2   65 55                 120
2233996 2233996 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick: Natick High   Regular School No High 09 12 2018   grade_9 313 11 30 0   20     1   21   181 215                       396.0 313 11 30 0   20     1   21   181 215                 396
2234042 2234042 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham: Needham High   Regular School No High 09 12 2018   grade_9 357 6 19 0   35     0   18   212 223                       435.0 357 6 19 0   35     0   18   212 223                 435
2229132 2229132 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_9 262 31 57 1   4     1   13   200 169                       369.0 262 31 57 1   4     1   13   200 169                 369
2234203 2234203 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_9 172 81 227 4   5     2   26   284 233                       517.0 172 81 227 4   5     2   26   284 233                 517
2234210 2234210 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford: Trinity Day Academy   Regular School No High 06 12 2018   grade_9 5 2 4 0   0     0   2   5 8                       13.0 5 2 4 0   0     0   2   5 8                 13
2234217 2234217 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford: Whaling City Junior/Senior High School   Regular School No High 06 12 2018   grade_9 5 10 13 0   0     0   4   23 9                       32.0 5 10 13 0   0     0   4   23 9                 32
2234235 2234235 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport: Newburyport High   Regular School No High 09 12 2018   grade_9 195 0 4 0   5     0   4   101 107                       208.0 195 0 4 0   5     0   4   101 107                 208
2234363 2234363 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton: Newton North High   Regular School No High 09 12 2018   grade_9 313 39 43 3   72     1   32   254 249                       503.0 313 39 43 3   72     1   32   254 249                 503
2234368 2234368 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton: Newton South High   Regular School No High 09 12 2018   grade_9 299 22 34 0   105     0   25   244 239                       485.0 299 22 34 0   105     0   25   244 239                 485
2234412 2234412 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams: Drury High   Regular School No High 07 12 2018   grade_9 85 2 4 0   0     0   7   43 55                       98.0 85 2 4 0   0     0   7   43 55                 98
2234451 2234451 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton: Northampton High   Regular School No High 09 12 2018   grade_9 178 7 21 1   6     0   9   108 114                       222.0 178 7 21 1   6     0   9   108 114                 222
2234496 2234496 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover: North Andover High   Regular School No High 09 12 2018   grade_9 305 10 41 0   28     0   6   202 188                       390.0 305 10 41 0   28     0   6   202 188                 390
2234542 2234542 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleborough: North Attleboro High   Regular School No High 09 12 2018   grade_9 208 8 12 0   17     0   8   134 119                       253.0 208 8 12 0   17     0   8   134 119                 253
2234592 2234592 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge: Northbridge High   Regular School No High 09 12 2018   grade_9 133 0 10 0   2     1   3   79 70                       149.0 133 0 10 0   2     1   3   79 70                 149
2234608 2234608 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield: North Brookfield High   Regular School No High 07 12 2018   grade_9 22 0 1 0   0     0   1   12 12                       24.0 22 0 1 0   0     0   1   12 12                 24
2234639 2234639 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading: North Reading High   Regular School No High 09 12 2018   grade_9 178 3 3 0   6     0   5   92 103                       195.0 178 3 3 0   6     0   5   92 103                 195
2234662 2234662 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton: Norton High   Regular School No High 09 12 2018   grade_9 159 2 3 0   5     1   2   94 78                       172.0 159 2 3 0   5     1   2   94 78                 172
2234687 2234687 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell: Norwell High   Regular School No High 09 12 2018   grade_9 153 1 4 0   3     1   4   78 88                       166.0 153 1 4 0   3     1   4   78 88                 166
2234730 2234730 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood: Norwood High   Regular School No High 09 12 2018   grade_9 169 21 30 0   15     0   9   119 125                       244.0 169 21 30 0   15     0   9   119 125                 244
2234772 2234772 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_9 * * * *   *     *   *   1 *                       1.0                         1                   1
2234782 2234782 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford: Oxford High   Regular School No High 08 12 2018   grade_9 80 3 11 0   5     0   3   52 50                       102.0 80 3 11 0   5     0   3   52 50                 102
2234798 2234798 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer: Palmer High   Regular School No High 06 12 2018   grade_9 68 4 4 0   3     0   5   40 44                       84.0 68 4 4 0   3     0   5   40 44                 84
2234867 2234867 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody: Peabody Veterans Memorial High   Regular School No High 09 12 2018   grade_9 279 10 55 0   7     0   6   193 164                       357.0 279 10 55 0   7     0   6   193 164                 357
2229150 2229150 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford: Bedford High   Regular School No High 09 12 2018   grade_9 121 11 17 0   20     0   11   94 86                       180.0 121 11 17 0   20     0   11   94 86                 180
2234908 2234908 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke: Pembroke High School   Regular School No High 09 12 2018   grade_9 202 3 2 0   2     0   1   104 106                       210.0 202 3 2 0   2     0   1   104 106                 210

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