enrollments

Data source: Big Local News · About: Big Local

396 rows where grade = "grade_10", state = "MA" and year = 2019 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 396 ✖

grade ✖

  • grade_10 · 396 ✖
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
2039821 2039821 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_10 127 6 13 0   2     0   1   79 70                       149.0 127 6 13 0   2     0   1   79 70                 149
2040004 2040004 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_10 258 12 24 0   36     0   14   170 173                       344.0 258 12 24 0   36     0   14   170 173                 344
2042460 2042460 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_10 345 47 128 0   31     0   23   287 287                       574.0 345 47 128 0   31     0   23   287 287                 574
2042510 2042510 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_10 373 10 10 2   33     0   10   226 212                       438.0 373 10 10 2   33     0   10   226 212                 438
2042525 2042525 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   grade_10 104 3 21 0   6     0   8   68 73                       142.0 104 3 21 0   6     0   8   68 73                 142
2042530 2042530 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2019   grade_10 16 0 4 1   0     0   1   17 4                       22.0 16 0 4 1   0     0   1   17 4                 22
2042544 2042544 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2019   grade_10 93 0 1 0   1     0   0   44 51                       95.0 93 0 1 0   1     0   0   44 51                 95
2042582 2042582 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2019   grade_10 155 3 21 0   0     0   3   95 87                       182.0 155 3 21 0   0     0   3   95 87                 182
2042605 2042605 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2019   grade_10 161 8 6 0   11     0   6   94 98                       192.0 161 8 6 0   11     0   6   94 98                 192
2042620 2042620 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_10 42 0 7 0   2     0   4   33 22                       55.0 42 0 7 0   2     0   4   33 22                 55
2042644 2042644 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2019   grade_10 57 2 18 0   2     0   6   52 33                       85.0 57 2 18 0   2     0   6   52 33                 85
2042659 2042659 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_10 33 0 3 0   3     0   1   23 17                       40.0 33 0 3 0   3     0   1   23 17                 40
2042691 2042691 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2019   grade_10 193 3 5 0   7     1   0   97 112                       209.0 193 3 5 0   7     1   0   97 112                 209
2042706 2042706 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_10 79 3 2 0   13     0   3   50 50                       100.0 79 3 2 0   13     0   3   50 50                 100
2042720 2042720 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_10 24 0 1 0   0     0   0   18 7                       25.0 24 0 1 0   0     0   0   18 7                 25
2042747 2042747 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2019   grade_10 3 0 6 0   0     0   1   6 4                       10.0 3 0 6 0   0     0   1   6 4                 10
2042774 2042774 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_10 * * * *   *     *   *   4 *                       5.0                         4                   5
2042796 2042796 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No High 09 12 2019   grade_10 308 22 179 0   6     0   8   270 253                       523.0 308 22 179 0   6     0   8   270 253                 523
2042829 2042829 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No High 09 12 2019   grade_10 298 2 6 0   7     0   4   142 175                       317.0 298 2 6 0   7     0   4   142 175                 317
2042844 2042844 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_10 33 16 12 1   5     0   2   33 36                       69.0 33 16 12 1   5     0   2   33 36                 69
2042867 2042867 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2019   grade_10 170 2 4 2   15     0   2   98 97                       195.0 170 2 4 2   15     0   2   98 97                 195
2042942 2042942 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2019   grade_10 66 5 311 1   2     0   3   213 175                       388.0 66 5 311 1   2     0   3   213 175                 388
2042956 2042956 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2019   grade_10 70 0 2 1   3     0   1   38 39                       77.0 70 0 2 1   3     0   1   38 39                 77
2042970 2042970 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No High 09 12 2019   grade_10 261 4 11 1   43     0   3   160 163                       323.0 261 4 11 1   43     0   3   160 163                 323
2040018 2040018 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2019   grade_10 151 4 25 0   21     0   9   102 108                       210.0 151 4 25 0   21     0   9   102 108                 210
2042996 2042996 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2019   grade_10 140 2 12 1   1     0   2   80 78                       158.0 140 2 12 1   1     0   2   80 78                 158
2043010 2043010 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No High 09 12 2019   grade_10 71 2 3 0   0     0   1   36 41                       77.0 71 2 3 0   0     0   1   36 41                 77
2043033 2043033 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No High 09 12 2019   grade_10 122 2 7 0   4     0   4   69 70                       139.0 122 2 7 0   4     0   4   69 70                 139
2043131 2043131 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_10 21 2 699 0   19     1   1   383 359                       743.0 21 2 699 0   19     1   1   383 359                 743
2043140 2043140 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No High 09 12 2019   grade_10 1 0 49 0   0     0   0   29 21                       50.0 1 0 49 0   0     0   0   29 21                 50
2043149 2043149 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_10 1 0 21 0   0     0   0   18 4                       22.0 1 0 21 0   0     0   0   18 4                 22
2043164 2043164 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2019   grade_10 56 1 4 1   2     0   1   27 38                       65.0 56 1 4 1   2     0   1   27 38                 65
2043179 2043179 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No High 09 12 2019   grade_10 85 4 11 1   4     0   2   59 46                       107.0 85 4 11 1   4     0   2   59 46                 107
2043193 2043193 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_10 48 0 8 0   5     0   3   30 34                       64.0 48 0 8 0   5     0   3   30 34                 64
2043230 2043230 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No High 09 12 2019   grade_10 151 29 97 0   9     0   9   137 158                       295.0 151 29 97 0   9     0   9   137 158                 295
2043234 2043234 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No High 09 12 2019   grade_10 7 0 5 0   1     0   1   7 7                       14.0 7 0 5 0   1     0   1   7 7                 14
2043238 2043238 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2019   grade_10 90 11 55 0   2     0   4   102 60                       162.0 90 11 55 0   2     0   4   102 60                 162
2043293 2043293 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2019   grade_10 269 15 24 2   199     0   33   264 278                       542.0 269 15 24 2   199     0   33   264 278                 542
2043327 2043327 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2019   grade_10 93 0 3 1   11     0   3   41 70                       111.0 93 0 3 1   11     0   3   41 70                 111
2043356 2043356 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2019   grade_10 182 7 6 1   23     0   8   112 115                       227.0 182 7 6 1   23     0   8   112 115                 227
2040060 2040060 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2019   grade_10 295 30 72 1   25     2   27   239 213                       452.0 295 30 72 1   25     2   27   239 213                 452
2040064 2040064 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 10 12 2019   grade_10 4 1 2 0   0     0   0   5 2                       7.0 4 1 2 0   0     0   0   5 2                 7
2043475 2043475 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No High 09 12 2019   grade_10 2 0 5 0   1     0   2   7 3                       10.0 2 0 5 0   1     0   2   7 3                 10
2043494 2043494 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_10 202 83 203 1   251     0   25   370 395                       765.0 202 83 203 1   251     0   25   370 395                 765
2043499 2043499 MA Middlesex   school 2507020 160   Lowell 250702002860 1600515 The Career Academy   Regular School No High 09 12 2019   grade_10 5 2 14 0   4     0   3   21 7                       28.0 5 2 14 0   4     0   3   21 7                 28
2043521 2043521 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2019   grade_10 200 5 15 0   0     0   9   116 112                       229.0 200 5 15 0   0     0   9   116 112                 229
2043536 2043536 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2019   grade_10 111 1 7 2   0     0   1   70 52                       122.0 111 1 7 2   0     0   1   70 52                 122
2043661 2043661 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2019   grade_10 70 37 274 2   29     0   6   225 193                       418.0 70 37 274 2   29     0   6   225 193                 418
2043665 2043665 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2019   grade_10 72 45 334 2   38     0   12   297 206                       503.0 72 45 334 2   38     0   12   297 206                 503
2043671 2043671 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2019   grade_10 7 0 7 0   0     0   1   8 7                       15.0 7 0 7 0   0     0   1   8 7                 15
2043678 2043678 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_10 40 21 171 0   19     0   5   149 107                       256.0 40 21 171 0   19     0   5   149 107                 256
2043698 2043698 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No High 09 12 2019   grade_10 148 1 8 0   7     0   3   75 92                       167.0 148 1 8 0   7     0   3   75 92                 167
2043748 2043748 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2019   grade_10 115 88 118 1   104     0   14   253 186                       440.0 115 88 118 1   104     0   14   253 186                 440
2043763 2043763 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2019   grade_10 277 15 16 0   21     0   12   160 181                       341.0 277 15 16 0   21     0   12   160 181                 341
2043785 2043785 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2019   grade_10 230 7 17 0   7     0   6   129 138                       267.0 230 7 17 0   7     0   6   129 138                 267
2040082 2040082 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_10 158 3 9 1   8     0   5   83 101                       184.0 158 3 9 1   8     0   5   83 101                 184
2043818 2043818 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No High 09 12 2019   grade_10 105 8 135 0   3     0   6   127 130                       257.0 105 8 135 0   3     0   6   127 130                 257
2043859 2043859 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield High   Regular School No High 09 12 2019   grade_10 294 1 14 0   6     0   2   153 164                       317.0 294 1 14 0   6     0   2   153 164                 317
2043873 2043873 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2019   grade_10 92 5 7 9   5     0   2   56 64                       120.0 92 5 7 9   5     0   2   56 64                 120
2043895 2043895 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No High 09 12 2019   grade_10 75 1 5 0   2     0   3   40 46                       86.0 75 1 5 0   2     0   3   40 46                 86
2043909 2043909 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2019   grade_10 174 3 4 0   9     0   8   96 102                       198.0 174 3 4 0   9     0   8   96 102                 198
2043948 2043948 MA Middlesex   school 2507560 176   Medford 250756001176 1760505 Medford High   Regular School No High 09 12 2019   grade_10 182 36 46 0   32     1   11   157 151                       308.0 182 36 46 0   32     1   11   157 151                 308
2043966 2043966 MA Norfolk   school 2507590 177   Medway 250759001184 1770505 Medway High   Regular School No High 09 12 2019   grade_10 133 4 9 0   12     0   0   79 79                       158.0 133 4 9 0   12     0   0   79 79                 158
2044005 2044005 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose High   Regular School No High 09 12 2019   grade_10 199 15 6 0   10     0   8   108 130                       238.0 199 15 6 0   10     0   8   108 130                 238
2040097 2040097 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_10 16 21 3 0   1     0   1   28 14                       42.0 16 21 3 0   1     0   1   28 14                 42
2044050 2044050 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2019   grade_10 260 6 201 1   25     0   25   280 238                       518.0 260 6 201 1   25     0   25   280 238                 518
2044070 2044070 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2019   grade_10 169 6 3 4   2     0   6   100 90                       190.0 169 6 3 4   2     0   6   100 90                 190
2044096 2044096 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_10 185 13 93 7   5     0   11   163 151                       314.0 185 13 93 7   5     0   11   163 151                 314
2044111 2044111 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2019   grade_10 98 4 8 0   2     0   4   54 62                       116.0 98 4 8 0   2     0   4   54 62                 116
2044126 2044126 MA Norfolk   school 2507920 187   Millis 250792001255 1870505 Millis High School   Regular School No High 09 12 2019   grade_10 79 0 5 0   6     1   1   54 38                       92.0 79 0 5 0   6     1   1   54 38                 92
2044160 2044160 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2019   grade_10 174 56 13 0   16     0   13   141 130                       272.0 174 56 13 0   16     0   13   141 130                 272
2044174 2044174 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 09 12 2019   grade_10 61 1 1 0   0     0   1   30 34                       64.0 61 1 1 0   0     0   1   30 34                 64
2044197 2044197 MA Nantucket   school 2508250 197   Nantucket 250825001282 1970505 Nantucket High   Regular School No High 09 12 2019   grade_10 72 18 24 0   3     0   2   69 49                       119.0 72 18 24 0   3     0   2   69 49                 119
2044235 2044235 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No High 09 12 2019   grade_10 319 14 32 0   20     1   22   190 218                       408.0 319 14 32 0   20     1   22   190 218                 408
2044273 2044273 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No High 09 12 2019   grade_10 349 8 19 0   34     0   18   209 219                       428.0 349 8 19 0   34     0   18   209 219                 428
2040124 2040124 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_10 254 31 58 1   3     3   12   189 173                       362.0 254 31 58 1   3     3   12   189 173                 362
2044411 2044411 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_10 159 101 241 3   5     2   26   268 269                       537.0 159 101 241 3   5     2   26   268 269                 537
2044419 2044419 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_10 7 2 3 0   0     0   2   5 9                       14.0 7 2 3 0   0     0   2   5 9                 14
2044425 2044425 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2019   grade_10 4 6 15 0   0     0   2   21 6                       27.0 4 6 15 0   0     0   2   21 6                 27
2044439 2044439 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2019   grade_10 195 1 2 0   7     0   5   104 106                       210.0 195 1 2 0   7     0   5   104 106                 210
2044547 2044547 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_10 307 42 44 3   68     0   34   254 242                       498.0 307 42 44 3   68     0   34   254 242                 498
2044552 2044552 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2019   grade_10 301 25 34 0   111     0   25   257 237                       496.0 301 25 34 0   111     0   25   257 237                 496
2044590 2044590 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2019   grade_10 74 2 4 0   1     0   8   42 47                       89.0 74 2 4 0   1     0   8   42 47                 89
2044624 2044624 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2019   grade_10 170 7 21 0   6     0   8   105 107                       212.0 170 7 21 0   6     0   8   105 107                 212
2044659 2044659 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No High 09 12 2019   grade_10 296 11 36 0   28     0   6   194 183                       377.0 296 11 36 0   28     0   6   194 183                 377
2044697 2044697 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2019   grade_10 213 7 10 0   15     0   9   137 117                       254.0 213 7 10 0   15     0   9   137 117                 254
2044738 2044738 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No High 09 12 2019   grade_10 112 0 6 0   2     0   2   62 60                       122.0 112 0 6 0   2     0   2   62 60                 122
2044753 2044753 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2019   grade_10 24 0 2 0   0     0   2   14 14                       28.0 24 0 2 0   0     0   2   14 14                 28
2044779 2044779 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2019   grade_10 174 2 4 0   7     0   5   90 102                       192.0 174 2 4 0   7     0   5   90 102                 192
2044798 2044798 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No High 09 12 2019   grade_10 165 3 4 0   5     1   2   98 82                       180.0 165 3 4 0   5     1   2   98 82                 180
2044820 2044820 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No High 09 12 2019   grade_10 148 1 5 0   3     1   4   76 86                       162.0 148 1 5 0   3     1   4   76 86                 162
2044854 2044854 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No High 09 12 2019   grade_10 167 25 27 0   14     0   9   115 127                       242.0 167 25 27 0   14     0   9   115 127                 242
2044889 2044889 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No High 09 12 2019   grade_10 * * * *   *     *   *   4 *                       4.0                         4                   4
2044897 2044897 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2019   grade_10 79 3 9 0   5     0   2   51 46                       98.0 79 3 9 0   5     0   2   51 46                 98
2044912 2044912 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   grade_10 63 5 3 0   2     0   3   34 42                       76.0 63 5 3 0   2     0   3   34 42                 76
2044972 2044972 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No High 09 12 2019   grade_10 272 8 59 0   6     0   7   185 166                       352.0 272 8 59 0   6     0   7   185 166                 352
2040139 2040139 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2019   grade_10 121 11 22 0   22     0   12   99 89                       188.0 121 11 22 0   22     0   12   99 89                 188
2045008 2045008 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2019   grade_10 200 2 2 0   3     0   1   104 104                       208.0 200 2 2 0   3     0   1   104 104                 208
2045078 2045078 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2019   grade_10 142 20 27 1   6     0   9   107 98                       205.0 142 20 27 1   6     0   9   107 98                 205
2045083 2045083 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No High 09 12 2019   grade_10 140 36 31 0   2     0   17   114 112                       226.0 140 36 31 0   2     0   17   114 112                 226

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