Data source: Big Local News · About: Big Local

391 rows where grade = "grade_9", state = "MA" and year = 2020 sorted by rowid descending

View and edit SQL

year

  • 2020 · 391

grade

  • grade_9 · 391
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
1374316 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1374302 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_9 248 21 71 1   8     0   29   176 202 *                     378.0 248 21 71 1   8     0   29   176 202                 378
1374289 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_9 62 5 21 1   7     1   13   53 57 *                     110.0 62 5 21 1   7     1   13   53 57                 110
1374276 MA Essex   school 2500590 3518   Phoenix Academy Public Charter High School Lawrence (District) 250059002886 35180505 Phoenix Academy Public Charter High School Lawrence   Regular School Yes High 09 12 2020   grade_9 2 0 72 0   0     0   0   53 21 *                     74.0 2 0 72 0   0     0   0   53 21                 74
1374272 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School   Regular School Yes High 09 12 2020   grade_9 33 4 10 0   1     1   5   36 18 *                     54.0 33 4 10 0   1     1   5   36 18                 54
1374270 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 10 2020   grade_9 16 6 20 0   1     0   0   21 22 *                     43.0 16 6 20 0   1     0   0   21 22                 43
1374255 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_9 1 81 9 0   0     0   1   46 46 *                     92.0 1 81 9 0   0     0   1   46 46                 92
1374237 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_9 49 14 24 1   2     0   3   54 39 *                     93.0 49 14 24 1   2     0   3   54 39                 93
1374230 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2020   grade_9 6 15 105 2   1     0   3   60 72 *                     132.0 6 15 105 2   1     0   3   60 72                 132
1374226 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes High 09 12 2020   grade_9 12 4 23 0   1     0   8   24 24 *                     48.0 12 4 23 0   1     0   8   24 24                 48
1374222 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2020   grade_9 15 17 17 0   12     0   1   27 35 *                     62.0 15 17 17 0   12     0   1   27 35                 62
1374206 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2020   grade_9 2 25 14 0   0     0   0   28 13 *                     41.0 2 25 14 0   0     0   0   28 13                 41
1374205 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_9 9 6 11 0   16     0   1   24 19 *                     43.0 9 6 11 0   16     0   1   24 19                 43
1374192 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_9 5 15 45 0   0     0   0   43 22 *                     65.0 5 15 45 0   0     0   0   43 22                 65
1374185 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2020   grade_9 0 9 74 0   0     0   0   43 40 *                     83.0 0 9 74 0   0     0   0   43 40                 83
1374181 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2020   grade_9 134 1 0 0   1     1   7   40 104 *                     144.0 134 1 0 0   1     1   7   40 104                 144
1374177 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2020   grade_9 116 0 4 0   2     0   1   30 93 *                     123.0 116 0 4 0   2     0   1   30 93                 123
1374173 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2020   grade_9 239 6 93 3   6     0   5   186 164 *                     352.0 239 6 93 3   6     0   5   186 164                 352
1374169 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 141 9 7 1   1     1   13   100 73 *                     173.0 141 9 7 1   1     1   13   100 73                 173
1374165 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 197 3 18 0   1     0   10   138 90 *                     229.0 197 3 18 0   1     0   10   138 90                 229
1374161 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_9 273 4 35 1   0     0   2   182 133 *                     315.0 273 4 35 1   0     0   2   182 133                 315
1374157 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2020   grade_9 157 3 8 2   1     0   0   124 47 *                     171.0 157 3 8 2   1     0   0   124 47                 171
1374153 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 175 140 51 0   3     0   19   175 213 *                     388.0 175 140 51 0   3     0   19   175 213                 388
1374149 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_9 280 4 19 0   0     0   4   182 125 *                     307.0 280 4 19 0   0     0   4   182 125                 307
1374145 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 144 3 9 0   0     0   4   95 65 *                     160.0 144 3 9 0   0     0   4   95 65                 160
1374141 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 143 0 3 0   1     0   3   91 59 *                     150.0 143 0 3 0   1     0   3   91 59                 150
1374137 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2020   grade_9 193 9 127 0   2     1   4   190 146 *                     336.0 193 9 127 0   2     1   4   190 146                 336
1374133 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Career and Technical School No High 09 12 2020   grade_9 157 2 18 1   1     1   1   104 75 *                     181.0 157 2 18 1   1     1   1   104 75                 181
1374129 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 135 0 2 0   1     0   2   82 58 *                     140.0 135 0 2 0   1     0   2   82 58                 140
1374125 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 265 5 63 0   9     0   16   158 197 3                     358.0 265 5 63 0   9     0   16   158 197 3               358
1374121 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Career and Technical School No High 09 12 2020   grade_9 149 10 13 1   7     0   11   116 73 *                     191.0 149 10 13 1   7     0   11   116 73                 191
1374117 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2020   grade_9 86 15 98 4   4     0   7   125 89 *                     214.0 86 15 98 4   4     0   7   125 89                 214
1374112 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 240 30 229 0   108     0   0   329 275 3                     607.0 240 30 229 0   108     0   0   329 275 3               607
1374108 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 306 47 147 0   9     0   40   306 243 *                     549.0 306 47 147 0   9     0   40   306 243                 549
1374104 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 59 5 363 1   4     0   0   222 210 *                     432.0 59 5 363 1   4     0   0   222 210                 432
1374100 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2020   grade_9 276 12 53 3   10     0   18   214 158 *                     372.0 276 12 53 3   10     0   18   214 158                 372
1374096 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Technical   Career and Technical School No High 09 12 2020   grade_9 138 0 13 0   0     0   2   98 55 *                     153.0 138 0 13 0   0     0   2   98 55                 153
1374092 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School   Career and Technical School No High 09 12 2020   grade_9 323 7 65 1   6     1   16   164 255 *                     419.0 323 7 65 1   6     1   16   164 255                 419
1374088 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 113 16 21 4   1     0   7   98 63 *                     162.0 113 16 21 4   1     0   7   98 63                 162
1374084 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 306 9 19 1   4     0   18   197 160 *                     357.0 306 9 19 1   4     0   18   197 160                 357
1374080 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 124 44 47 1   6     0   16   126 112 *                     238.0 124 44 47 1   6     0   16   126 112                 238
1374076 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2020   grade_9 262 2 30 0   6     1   12   155 157 *                     313.0 262 2 30 0   6     1   12   155 157                 313
1374072 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2020   grade_9 221 10 63 1   0     0   5   182 115 3                     300.0 221 10 63 1   0     0   5   182 115 3               300
1374067 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2020   grade_9 241 10 15 3   2     1   10   156 126 *                     282.0 241 10 15 3   2     1   10   156 126                 282
1374038 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional High   Regular School No High 09 12 2020   grade_9 96 0 7 0   0     0   5   52 56 *                     108.0 96 0 7 0   0     0   5   52 56                 108
1374015 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2020   grade_9 440 13 22 0   20     0   14   252 257 *                     509.0 440 13 22 0   20     0   14   252 257                 509
1373937 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No High 09 12 2020   grade_9 177 4 8 0   2     0   3   94 100 *                     194.0 177 4 8 0   2     0   3   94 100                 194
1373907 MA Worcester   school 2511490 770   Tantasqua 251149001901 7700605 Tantasqua Regional Vocational   Career and Technical School No High 09 12 2020   grade_9 126 0 11 0   0     1   8   83 63 *                     146.0 126 0 11 0   0     1   8   83 63                 146
1373902 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No High 09 12 2020   grade_9 139 1 6 1   4     0   10   73 88 *                     161.0 139 1 6 1   4     0   10   73 88                 161
1373896 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2020   grade_9 57 2 12 0   2     0   2   35 40 *                     75.0 57 2 12 0   2     0   2   35 40                 75
1373875 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_9 91 2 2 0   2     0   2   47 52 *                     99.0 91 2 2 0   2     0   2   47 52                 99
1373861 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 06 12 2020   grade_9 44 2 5 1   0     0   3   26 29 *                     55.0 44 2 5 1   0     0   3   26 29                 55
1373840 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No High 09 12 2020   grade_9 230 4 8 1   2     0   5   126 124 *                     250.0 230 4 8 1   2     0   5   126 124                 250
1373835 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2020   grade_9 270 4 5 1   2     0   1   150 133 *                     283.0 270 4 5 1   2     0   1   150 133                 283
1373828 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2020   grade_9 102 2 8 0   2     1   5   61 59 *                     120.0 102 2 8 0   2     1   5   61 59                 120
1373821 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2020   grade_9 144 2 7 0   1     0   3   75 82 *                     157.0 144 2 7 0   1     0   3   75 82                 157
1373785 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2020   grade_9 47 0 1 0   1     0   3   25 27 *                     52.0 47 0 1 0   1     0   3   25 27                 52
1373757 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No High 09 12 2020   grade_9 154 1 5 0   2     0   3   96 69 *                     165.0 154 1 5 0   2     0   3   96 69                 165
1373726 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2020   grade_9 154 4 4 0   4     0   8   100 74 *                     174.0 154 4 4 0   4     0   8   100 74                 174
1373719 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No High 09 12 2020   grade_9 158 0 6 0   3     0   3   92 78 *                     170.0 158 0 6 0   3     0   3   92 78                 170
1373689 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2020   grade_9 234 4 20 3   42     2   16   159 162 *                     321.0 234 4 20 3   42     2   16   159 162                 321
1373676 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2020   grade_9 169 4 11 0   11     0   2   104 93 *                     197.0 169 4 11 0   11     0   2   104 93                 197
1373641 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No High 09 12 2020   grade_9 84 0 8 0   0     0   2   48 46 *                     94.0 84 0 8 0   0     0   2   48 46                 94
1373620 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional School   Regular School No High 07 12 2020   grade_9 34 0 2 0   0     0   0   18 18 *                     36.0 34 0 2 0   0     0   0   18 18                 36
1373589 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2020   grade_9 72 4 3 0   5     0   1   40 45 *                     85.0 72 4 3 0   5     0   1   40 45                 85
1373567 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2020   grade_9 102 8 12 0   1     0   5   59 69 *                     128.0 102 8 12 0   1     0   5   59 69                 128
1373546 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Nipmuc Regional High   Regular School No High 09 12 2020   grade_9 134 1 7 0   5     0   4   66 85 *                     151.0 134 1 7 0   5     0   4   66 85                 151
1373526 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No High 09 12 2020   grade_9 264 1 7 0   8     0   7   142 145 *                     287.0 264 1 7 0   8     0   7   142 145                 287
1373519 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2020   grade_9 121 7 36 1   3     0   12   87 93 *                     180.0 121 7 36 1   3     0   12   87 93                 180
1373515 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2020   grade_9 120 0 0 0   3     0   2   72 53 *                     125.0 120 0 0 0   3     0   2   72 53                 125
1373494 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No High 09 12 2020   grade_9 266 18 15 0   4     0   50   160 193 *                     353.0 266 18 15 0   4     0   50   160 193                 353
1373487 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No High 09 12 2020   grade_9 233 8 10 0   7     0   12   122 148 *                     270.0 233 8 10 0   7     0   12   122 148                 270
1373474 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2020   grade_9 95 0 6 0   1     0   2   44 60 *                     104.0 95 0 6 0   1     0   2   44 60                 104
1373467 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Minnechaug Regional High   Regular School No High 09 12 2020   grade_9 212 8 22 2   9     0   5   133 125 *                     258.0 212 8 22 2   9     0   5   133 125                 258
1373443 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No High 09 12 2020   grade_9 118 1 5 0   6     0   4   61 73 *                     134.0 118 1 5 0   6     0   4   61 73                 134
1373416 MA Franklin   school 2505270 674   Gill-Montague 250527000768 6740505 Turners Fall High   Regular School No High 09 12 2020   grade_9 32 2 6 0   0     0   3   24 19 *                     43.0 32 2 6 0   0     0   3   24 19                 43
1373394 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2020   grade_9 146 1 5 1   11     1   3   97 71 *                     168.0 146 1 5 1   11     1   3   97 71                 168
1373374 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No High 09 12 2020   grade_9 48 0 3 1   0     0   1   32 21 *                     53.0 48 0 3 1   0     0   1   32 21                 53
1373352 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2020   grade_9 85 2 5 0   2     0   2   47 49 *                     96.0 85 2 5 0   2     0   2   47 49                 96
1373346 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2020   grade_9 185 3 1 0   1     0   1   96 95 *                     191.0 185 3 1 0   1     0   1   96 95                 191
1373320 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2020   grade_9 172 14 6 0   5     0   7   89 115 *                     204.0 172 14 6 0   5     0   7   89 115                 204
1373312 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Shepherd Hill Regional High   Regular School No High 09 12 2020   grade_9 205 5 23 0   6     1   3   111 132 *                     243.0 205 5 23 0   6     1   3   111 132                 243
1373288 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000574 6550505 Dover-Sherborn Regional High   Regular School No High 09 12 2020   grade_9 128 7 7 1   19     0   9   77 94 *                     171.0 128 7 7 1   19     0   9   77 94                 171
1373280 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2020   grade_9 161 3 4 0   2     0   6   94 82 *                     176.0 161 3 4 0   2     0   6   94 82                 176
1373255 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_9 127 22 23 3   5     0   7   102 85 *                     187.0 127 22 23 3   5     0   7   102 85                 187
1373232 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No High 09 12 2020   grade_9 270 18 13 0   28     0   15   170 172 *                     344.0 270 18 13 0   28     0   15   170 172                 344
1373228 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No High 09 12 2020   grade_9 115 0 4 0   0     0   3   57 65 *                     122.0 115 0 4 0   0     0   3   57 65                 122
1373193 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2020   grade_9 274 17 7 1   7     0   18   163 161 *                     324.0 274 17 7 1   7     0   18   163 161                 324
1373166 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2020   grade_9 91 5 5 0   0     0   2   58 45 *                     103.0 91 5 5 0   0     0   2   58 45                 103
1373146 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2020   grade_9 53 2 6 1   4     0   2   27 40 *                     68.0 53 2 6 1   4     0   2   27 40                 68
1373124 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2020   grade_9 101 0 12 0   4     0   2   59 60 *                     119.0 101 0 12 0   4     0   2   59 60                 119
1373110 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2020   grade_9 83 5 11 2   0     0   1   47 55 *                     102.0 83 5 11 2   0     0   1   47 55                 102
1373089 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2020   grade_9 66 0 6 0   1     0   2   47 28 *                     75.0 66 0 6 0   1     0   2   47 28                 75
1373067 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2020   grade_9 160 0 5 0   2     0   4   83 88 *                     171.0 160 0 5 0   2     0   4   83 88                 171
1373046 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2020   grade_9 104 20 35 0   23     0   23   110 95 *                     205.0 104 20 35 0   23     0   23   110 95                 205
1373040 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2020   grade_9 54 2 1 1   1     0   0   31 28 *                     59.0 54 2 1 1   1     0   0   31 28                 59
1373025 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2020   grade_9 256 16 19 1   166     0   12   250 220 *                     470.0 256 16 19 1   166     0   12   250 220                 470
1372976 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science East   Regular School Yes High 06 12 2020   grade_9 29 28 24 0   1     0   2   44 40 *                     84.0 29 28 24 0   1     0   2   44 40                 84
1372965 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_9 13 0 3 0   5     1   4   10 16 *                     26.0 13 0 3 0   5     1   4   10 16                 26
1372952 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2020   grade_9 16 7 21 0   1     0   3   25 23 *                     48.0 16 7 21 0   1     0   3   25 23                 48

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