Data source: Big Local News · About: Big Local

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

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
1365913 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2020   grade_9 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1366606 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2020   grade_9 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1367663 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Greenleaf Academy   Regular School No High 06 12 2020   grade_9 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1367689 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_9 * * * *   *     *   *   2 * *                     2.0                         2                   2
1368466 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1370435 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 09 12 2020   grade_9 * * * *   *     *   *   2 * *                     3.0                         2                   3
1371061 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2020   grade_9 * * * *   *     *   *   2 * *                     2.0                         2                   2
1371534 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham Cooperative Alternative School   Regular School No High 09 12 2020   grade_9 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1372007 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No High 09 12 2020   grade_9 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1374316 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1366531 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_9 98 0 0 2   1     0   0   41 60 *                     101.0 98 0 0 2   1     0   0   41 60                 101
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
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
1364859 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_9 7 0 1 0   0     0   0   4 4 *                     8.0 7 0 1 0   0     0   0   4 4                 8
1366067 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2020   grade_9 96 0 1 1   2     0   3   43 60 *                     103.0 96 0 1 1   2     0   3   43 60                 103
1366221 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_9 1 3 1 0   0     0   1   3 3 *                     6.0 1 3 1 0   0     0   1   3 3                 6
1366716 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset High School   Regular School No High 09 12 2020   grade_9 107 4 1 0   4     0   1   59 58 *                     117.0 107 4 1 0   4     0   1   59 58                 117
1367929 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No High 09 12 2020   grade_9 60 0 1 0   0     0   0   40 21 *                     61.0 60 0 1 0   0     0   0   40 21                 61
1368149 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No High 09 12 2020   grade_9 9 0 1 0   0     0   0   3 6 *                     10.0 9 0 1 0   0     0   0   3 6                 10
1369102 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 07 12 2020   grade_9 44 0 1 0   0     0   0   19 26 *                     45.0 44 0 1 0   0     0   0   19 26                 45
1369745 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No High 09 12 2020   grade_9 152 0 1 0   3     0   3   69 90 *                     159.0 152 0 1 0   3     0   3   69 90                 159
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
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
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
1367319 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2020   grade_9 151 11 10 2   2     0   5   88 93 *                     181.0 151 11 10 2   2     0   5   88 93                 181
1367532 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2020   grade_9 192 5 10 0   27     0   5   110 129 *                     239.0 192 5 10 0   27     0   5   110 129                 239
1367747 MA Plymouth   school 2506090 131   Hingham 250609000872 1310505 Hingham High   Regular School No High 09 12 2020   grade_9 304 3 10 0   17     0   9   189 154 *                     343.0 304 3 10 0   17     0   9   189 154                 343
1368094 MA Worcester   school 2506720 151   Leicester 250672000972 1510505 Leicester High   Regular School No High 09 12 2020   grade_9 80 7 10 0   2     0   3   41 61 *                     102.0 80 7 10 0   2     0   3   41 61                 102
1368452 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2020   grade_9 91 1 10 0   2     0   3   61 46 *                     107.0 91 1 10 0   2     0   3   61 46                 107
1368998 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2020   grade_9 186 7 10 3   5     0   10   109 112 *                     221.0 186 7 10 3   5     0   10   109 112                 221
1369365 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2020   grade_9 201 0 10 0   1     0   4   103 113 *                     216.0 201 0 10 0   1     0   4   103 113                 216
1370263 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No High 09 12 2020   grade_9 264 4 10 0   16     0   7   161 140 *                     301.0 264 4 10 0   16     0   7   161 140                 301
1371539 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No High 08 12 2020   grade_9 102 12 10 5   0     0   17   76 69 *                     146.0 102 12 10 5   0     0   17   76 69                 146
1371702 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No High 06 12 2020   grade_9 50 4 10 0   1     0   3   28 40 *                     68.0 50 4 10 0   1     0   3   28 40                 68
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
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
1366678 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2020   grade_9 186 9 100 0   5     0   6   182 124 *                     306.0 186 9 100 0   5     0   6   182 124                 306
1365904 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2020   grade_9 3 40 103 1   8     0   0   105 50 *                     155.0 3 40 103 1   8     0   0   105 50                 155
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
1365179 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2020   grade_9 210 13 11 0   66     0   18   159 159 *                     318.0 210 13 11 0   66     0   18   159 159                 318
1366251 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Edison Academy   Regular School No High 09 12 2020   grade_9 1 29 11 0   0     0   0   21 20 *                     41.0 1 29 11 0   0     0   0   21 20                 41
1366634 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_9 7 0 11 0   0     0   1   9 10 *                     19.0 7 0 11 0   0     0   1   9 10                 19
1368631 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No High 09 12 2020   grade_9 108 4 11 0   8     0   4   71 64 *                     135.0 108 4 11 0   8     0   4   71 64                 135
1369087 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2020   grade_9 184 51 11 0   18     1   4   116 153 *                     269.0 184 51 11 0   18     1   4   116 153                 269
1369664 MA Worcester   school 2508940 214   Northbridge 250894001445 2140505 Northbridge High   Regular School No High 09 12 2020   grade_9 134 1 11 0   0     1   7   81 73 *                     154.0 134 1 11 0   0     1   7   81 73                 154
1369838 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2020   grade_9 63 5 11 0   1     0   4   53 31 *                     84.0 63 5 11 0   1     0   4   53 31                 84
1371105 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham High   Regular School No High 09 12 2020   grade_9 117 2 11 2   7     0   7   77 69 *                     146.0 117 2 11 2   7     0   7   77 69                 146
1371453 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2020   grade_9 215 2 11 3   9     0   6   125 121 *                     246.0 215 2 11 3   9     0   6   125 121                 246
1371905 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2020   grade_9 203 10 11 0   22     0   10   118 138 *                     256.0 203 10 11 0   22     0   10   118 138                 256
1372908 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2020   grade_9 185 5 11 1   10     0   5   96 120 *                     217.0 185 5 11 1   10     0   5   96 120                 217
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
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
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
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
1370426 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2020   grade_9 104 14 110 0   2     0   7   136 101 *                     237.0 104 14 110 0   2     0   7   136 101                 237
1366674 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2020   grade_9 86 17 111 0   5     0   11   116 114 *                     230.0 86 17 111 0   5     0   11   116 114                 230
1365930 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2020   grade_9 4 61 112 0   1     0   3   102 79 *                     181.0 4 61 112 0   1     0   3   102 79                 181
1366005 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No High 09 12 2020   grade_9 5 8 12 0   3     0   2   20 10 *                     30.0 5 8 12 0   3     0   2   20 10                 30
1367004 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No High 09 12 2020   grade_9 231 17 12 0   11     0   6   140 137 *                     277.0 231 17 12 0   11     0   6   140 137                 277
1369039 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2020   grade_9 109 5 12 1   2     0   1   61 69 *                     130.0 109 5 12 1   2     0   1   61 69                 130
1369623 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2020   grade_9 208 15 12 1   16     1   8   134 127 *                     261.0 208 15 12 1   16     1   8   134 127                 261
1370079 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No High 09 12 2020   grade_9 234 1 12 1   3     0   9   140 120 *                     260.0 234 1 12 1   3     0   9   140 120                 260
1372808 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2020   grade_9 46 11 12 0   24     0   2   43 52 *                     95.0 46 11 12 0   24     0   2   43 52                 95
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
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
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
1369024 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2020   grade_9 195 8 123 5   8     0   15   184 168 *                     354.0 195 8 123 5   8     0   15   184 168                 354
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
1365989 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2020   grade_9 3 10 13 0   10     0   1   23 14 *                     37.0 3 10 13 0   10     0   1   23 14                 37
1366964 MA Hampshire   school 2504590 86   Easthampton 250459000612 860505 Easthampton High   Regular School No High 09 12 2020   grade_9 84 3 13 0   3     0   3   59 47 *                     106.0 84 3 13 0   3     0   3   59 47                 106
1367109 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No High 09 12 2020   grade_9 154 7 13 1   3     0   7   85 100 *                     185.0 154 7 13 1   3     0   7   85 100                 185
1368715 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2020   grade_9 200 12 13 0   4     0   2   108 123 *                     231.0 200 12 13 0   4     0   2   108 123                 231
1368823 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No High 09 12 2020   grade_9 50 2 13 0   2     0   4   44 27 *                     71.0 50 2 13 0   2     0   4   44 27                 71
1369351 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2020   grade_9 6 7 13 0   1     0   2   22 7 *                     29.0 6 7 13 0   1     0   2   22 7                 29
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
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
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
1372456 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_9 26 14 130 4   2     2   0   83 95 *                     178.0 26 14 130 4   2     2   0   83 95                 178
1366506 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2020   grade_9 148 20 14 0   20     0   11   96 117 *                     213.0 148 20 14 0   20     0   11   96 117                 213
1366814 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2020   grade_9 192 7 14 0   0     0   22   125 110 *                     235.0 192 7 14 0   0     0   22   125 110                 235
1367239 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   grade_9 207 13 14 4   2     0   12   130 121 *                     252.0 207 13 14 4   2     0   12   130 121                 252
1368787 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield High   Regular School No High 09 12 2020   grade_9 310 2 14 0   4     1   3   174 160 *                     334.0 310 2 14 0   4     1   3   174 160                 334
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
1365996 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2020   grade_9 43 108 140 0   77     0   6   153 221 *                     374.0 43 108 140 0   77     0   6   153 221                 374
1372931 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes High 09 12 2020   grade_9 5 13 144 3   0     0   0   85 80 *                     165.0 5 13 144 3   0     0   0   85 80                 165
1368681 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2020   grade_9 119 98 146 1   108     0   15   241 246 *                     487.0 119 98 146 1   108     0   15   241 246                 487
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
1372398 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2020   grade_9 126 58 148 2   19     0   21   211 163 *                     374.0 126 58 148 2   19     0   21   211 163                 374
1366376 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2020   grade_9 149 15 15 1   30     0   11   114 107 *                     221.0 149 15 15 1   30     0   11   114 107                 221
1367785 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2020   grade_9 161 3 15 3   16     0   5   110 93 *                     203.0 161 3 15 3   16     0   5   110 93                 203
1369823 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2020   grade_9 78 2 15 1   2     0   0   41 57 *                     98.0 78 2 15 1   2     0   0   41 57                 98
1370188 MA Norfolk   school 2509870 243   Quincy 250987001577 2430510 North Quincy High   Regular School No High 09 12 2020   grade_9 116 18 15 0   168     0   9   160 165 *                     326.0 116 18 15 0   168     0   9   160 165                 326
1372432 MA Hampshire   school 2508860 406   Northampton-Smith Vocational Agricultural 250886002314 4060705 Smith Vocational and Agricultural High   Career and Technical School No High 09 12 2020   grade_9 126 2 15 0   1     0   1   87 58 *                     145.0 126 2 15 0   1     0   1   87 58                 145
1372563 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2020   grade_9 99 7 15 0   23     0   13   82 75 *                     157.0 99 7 15 0   23     0   13   82 75                 157
1372826 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2020   grade_9 42 8 15 0   1     0   2   20 48 *                     68.0 42 8 15 0   1     0   2   20 48                 68
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
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
1372413 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2020   grade_9 124 70 154 0   30     0   15   155 238 *                     393.0 124 70 154 0   30     0   15   155 238                 393
1372393 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2020   grade_9 106 55 156 0   8     0   14   165 174 *                     339.0 106 55 156 0   8     0   14   165 174                 339
1366565 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No High 09 12 2020   grade_9 233 11 16 0   58     0   11   157 172 *                     329.0 233 11 16 0   58     0   11   157 172                 329

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