Data source: Big Local News · About: Big Local

499 rows where grade = "grade_8", state = "MA" and year = 2021 sorted by asian_int

View and edit SQL

year

  • 2021 · 499

grade

  • grade_8 · 499
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
1674758 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1674916 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill - Greenleaf Academy   Regular School No High 06 12 2021   grade_8 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1675667 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_8 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1675706 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1678259 MA Hampden   school 2511130 281   Springfield 251113002916 2810318 Springfield - Emergence Academy   Regular School No Middle 06 08 2021   grade_8 * * * *   *     *   *   4 * *                     5.0                         4                   5
1680452 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_8 * * * *   *     *   *   1 * *                     1.0                         1                   1
1672414 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_8 88 1 5 0   0     0   2   48 48 *                     96.0 88 1 5 0   0     0   2   48 48                 96
1672528 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_8 3 14 12 1   0     0   0   15 15 *                     30.0 3 14 12 1   0     0   0   15 15                 30
1672625 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_8 1 17 23 0   0     1   3   22 23 *                     45.0 1 17 23 0   0     1   3   22 23                 45
1672719 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston - James W Hennigan   Regular School No Elementary KG 08 2021   grade_8 4 14 55 0   0     0   0   32 41 *                     73.0 4 14 55 0   0     0   0   32 41                 73
1672783 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_8 0 1 19 0   0     0   0   13 7 *                     20.0 0 1 19 0   0     0   0   13 7                 20
1672896 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_8 1 42 46 0   0     1   0   44 46 *                     90.0 1 42 46 0   0     1   0   44 46                 90
1672902 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston - William H Ohrenberger   Regular School No Middle 03 08 2021   grade_8 4 23 39 0   0     0   4   42 28 *                     70.0 4 23 39 0   0     0   4   42 28                 70
1672912 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_8 4 6 16 0   0     0   1   13 14 *                     27.0 4 6 16 0   0     0   1   13 14                 27
1672977 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_8 2 6 19 0   0     0   0   16 11 *                     27.0 2 6 19 0   0     0   0   16 11                 27
1673041 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_8 1 12 5 0   0     0   1   11 8 *                     19.0 1 12 5 0   0     0   1   11 8                 19
1673068 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_8 2 21 17 0   0     0   1   20 21 *                     41.0 2 21 17 0   0     0   1   20 21                 41
1673074 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_8 2 21 21 0   0     0   2   32 14 *                     46.0 2 21 21 0   0     0   2   32 14                 46
1673094 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_8 1 19 24 0   0     0   0   22 22 *                     44.0 1 19 24 0   0     0   0   22 22                 44
1673104 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_8 3 2 12 0   0     0   1   10 8 *                     18.0 3 2 12 0   0     0   1   10 8                 18
1673131 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston - Washington Irving Middle   Regular School No Middle 06 08 2021   grade_8 5 28 44 0   0     0   0   37 40 *                     77.0 5 28 44 0   0     0   0   37 40                 77
1673188 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston - New Mission High School   Alternative School No High 07 12 2021   grade_8 2 25 22 0   0     0   1   22 28 *                     50.0 2 25 22 0   0     0   1   22 28                 50
1673277 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_8 2 0 23 0   0     0   0   12 13 *                     25.0 2 0 23 0   0     0   0   12 13                 25
1673284 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_8 0 3 6 0   0     0   0   7 2 *                     9.0 0 3 6 0   0     0   0   7 2                 9
1673453 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_8 1 3 4 0   0     0   0   7 1 *                     8.0 1 3 4 0   0     0   0   7 1                 8
1673464 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton - South Middle School   Regular School No Middle 06 08 2021   grade_8 26 142 30 0   0     0   6   113 91 *                     204.0 26 142 30 0   0     0   6   113 91                 204
1673628 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge - Amigos School   Regular School No Elementary PK 08 2021   grade_8 15 0 21 0   0     0   5   19 22 *                     41.0 15 0 21 0   0     0   5   19 22                 41
1673762 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_8 118 0 5 1   0     1   0   71 54 *                     125.0 118 0 5 1   0     1   0   71 54                 125
1673824 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_8 8 7 110 0   0     0   2   55 72 *                     127.0 8 7 110 0   0     0   2   55 72                 127
1673832 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_8 4 1 132 0   0     0   0   71 66 *                     137.0 4 1 132 0   0     0   0   71 66                 137
1673918 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_8 20 0 0 0   0     0   2   12 10 *                     22.0 20 0 0 0   0     0   2   12 10                 22
1674162 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater - East Bridgewater JR./SR. High School   Regular School No High 07 12 2021   grade_8 148 14 2 1   0     1   6   102 70 *                     172.0 148 14 2 1   0     1   6   102 70                 172
1674296 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_8 1 1 3 0   0     0   1   5 1 *                     6.0 1 1 3 0   0     0   1   5 1                 6
1674391 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River - John J Doran   Regular School No Elementary PK 08 2021   grade_8 28 2 17 0   0     0   4   27 24 *                     51.0 28 2 17 0   0     0   4   27 24                 51
1674432 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_8 4 2 3 0   0     0   1   8 2 *                     10.0 4 2 3 0   0     0   1   8 2                 10
1674442 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_8 6 6 11 0   0     0   2   19 6 *                     25.0 6 6 11 0   0     0   2   19 6                 25
1674532 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_8 13 0 0 0   0     0   0   8 5 *                     13.0 13 0 0 0   0     0   0   8 5                 13
1674795 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby - Granby Jr Sr High School   Regular School No High 07 12 2021   grade_8 47 0 3 0   0     0   1   31 20 *                     51.0 47 0 3 0   0     0   1   31 20                 51
1674891 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield - Smith Academy   Regular School No High 07 12 2021   grade_8 33 0 1 0   0     0   1   20 15 *                     35.0 33 0 1 0   0     0   1   20 15                 35
1675062 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke - William R. Peck School   Regular School No Middle 04 08 2021   grade_8 2 1 56 0   0     0   0   38 21 *                     59.0 2 1 56 0   0     0   0   38 21                 59
1675069 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke - Kelly Elementary   Regular School No Elementary PK 08 2021   grade_8 1 1 46 0   0     0   0   26 22 *                     48.0 1 1 46 0   0     0   0   26 22                 48
1675095 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Holyoke - Maurice A Donahue Elementary   Regular School No Elementary PK 08 2021   grade_8 5 0 39 0   0     0   0   16 28 *                     44.0 5 0 39 0   0     0   0   16 28                 44
1675173 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull - Memorial Middle   Regular School No Middle 06 08 2021   grade_8 60 1 4 0   0     0   0   29 35 *                     65.0 60 1 4 0   0     0   0   29 35                 65
1675231 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence - Arlington Middle School   Regular School No Middle 05 08 2021   grade_8 2 1 159 0   0     0   1   77 86 *                     163.0 2 1 159 0   0     0   1   77 86                 163
1675248 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_8 2 2 108 0   0     0   0   57 55 *                     112.0 2 2 108 0   0     0   0   57 55                 112
1675265 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence - UP Academy Oliver Middle School   Regular School No Middle 06 08 2021   grade_8 2 1 109 0   0     0   0   59 53 *                     112.0 2 1 109 0   0     0   0   59 53                 112
1675290 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence - UP Academy Leonard Middle School   Regular School No Middle 06 08 2021   grade_8 2 0 87 0   0     0   1   47 42 *                     90.0 2 0 87 0   0     0   1   47 42                 90
1675307 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_8 2 0 12 0   0     0   1   13 2 *                     15.0 2 0 12 0   0     0   1   13 2                 15
1675615 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_8 4 0 6 0   0     0   0   9 * *                     10.0 4 0 6 0   0     0   0   9                   10
1675678 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow - Paul R Baird Middle   Regular School No Middle 06 08 2021   grade_8 174 4 23 0   0     0   8   111 98 *                     209.0 174 4 23 0   0     0   8   111 98                 209
1675692 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg - Lunenburg Middle School   Regular School No Middle 06 08 2021   grade_8 99 1 16 0   0     1   3   62 57 *                     120.0 99 1 16 0   0     1   3   62 57                 120
1675843 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn - Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2021   grade_8 3 0 4 1   0     0   2   8 2 *                     10.0 3 0 4 1   0     0   2   8 2                 10
1676245 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough - John T. Nichols Middle   Regular School No Middle 06 08 2021   grade_8 237 11 7 3   0     0   7   134 131 *                     265.0 237 11 7 3   0     0   7   134 131                 265
1676300 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis - Millis Middle   Regular School No Middle 06 08 2021   grade_8 77 2 7 0   0     0   8   45 48 *                     94.0 77 2 7 0   0     0   8   45 48                 94
1676593 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_8 2 2 5 0   0     0   1   6 4 *                     10.0 2 2 5 0   0     0   1   6 4                 10
1676599 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford - Whaling City Junior/Senior High School   Regular School No High 06 12 2021   grade_8 2 1 3 0   0     0   0   4 2 *                     6.0 2 1 3 0   0     0   0   4 2                 6
1676924 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield - North Brookfield High   Regular School No High 07 12 2021   grade_8 34 0 4 0   0     0   2   23 17 *                     40.0 34 0 4 0   0     0   2   23 17                 40
1677041 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs - Oak Bluffs Elementary   Regular School No Elementary PK 08 2021   grade_8 35 1 9 2   0     0   5   27 25 *                     52.0 35 1 9 2   0     0   5   27 25                 52
1677244 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield - John T Reid Middle   Regular School No Middle 06 08 2021   grade_8 116 27 18 1   0     0   13   86 89 *                     175.0 116 27 18 1   0     0   13   86 89                 175
1677247 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield - Theodore Herberg Middle   Regular School No Middle 06 08 2021   grade_8 135 26 26 0   0     0   14   99 102 *                     201.0 135 26 26 0   0     0   14   99 102                 201
1677347 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_8 3 5 2 0   0     0   0   3 7 *                     10.0 3 5 2 0   0     0   0   3 7                 10
1677581 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond - Richmond Consolidated   Regular School No Elementary PK 08 2021   grade_8 15 1 2 0   0     0   0   9 9 *                     18.0 15 1 2 0   0     0   0   9 9                 18
1677958 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Somerville - Next Wave Junior High   Alternative School No Middle 06 08 2021   grade_8 2 0 4 0   0     0   1   6 * *                     7.0 2 0 4 0   0     0   1   6                   7
1678007 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge - Southbridge Academy   Alternative School No High 07 12 2021   grade_8 4 0 2 0   0     0   0   4 2 *                     6.0 4 0 2 0   0     0   0   4 2                 6
1678142 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Springfield - Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2021   grade_8 7 2 17 0   0     0   1   10 17 *                     27.0 7 2 17 0   0     0   1   10 17                 27
1678244 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield - The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2021   grade_8 18 20 58 0   0     0   0   36 60 *                     96.0 18 20 58 0   0     0   0   36 60                 96
1678256 MA Hampden   school 2511130 281   Springfield 251113002917 2810317 Springfield - Lyceum Academy   Regular School No Middle 06 08 2021   grade_8 2 6 66 0   0     0   0   42 32 *                     74.0 2 6 66 0   0     0   0   42 32                 74
1678277 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield - Springfield Public Day Middle School   Regular School No Middle 06 08 2021   grade_8 1 7 11 0   0     0   2   17 4 *                     21.0 1 7 11 0   0     0   2   17 4                 21
1678283 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 Springfield - South End Middle School   Regular School No Middle 06 08 2021   grade_8 2 11 77 0   0     0   0   46 44 *                     90.0 2 11 77 0   0     0   0   46 44                 90
1678285 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield - Balliet Middle School   Regular School No Middle 06 08 2021   grade_8 0 4 6 0   0     0   0   8 * *                     10.0 0 4 6 0   0     0   0   8                   10
1678289 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Springfield - Impact Prep at Chestnut   Regular School No Middle 06 08 2021   grade_8 3 9 59 0   0     0   1   39 33 *                     72.0 3 9 59 0   0     0   1   39 33                 72
1678295 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield - Conservatory of the Arts   Regular School No High 06 12 2021   grade_8 6 7 38 0   0     0   1   14 38 *                     52.0 6 7 38 0   0     0   1   14 38                 52
1678302 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Springfield - Rise Academy at Van Sickle   Regular School No Middle 06 08 2021   grade_8 7 20 72 0   0     0   4   59 44 *                     103.0 7 20 72 0   0     0   4   59 44                 103
1678504 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Swansea - Joseph Case Jr High   Regular School No Middle 06 08 2021   grade_8 178 3 5 0   0     0   3   103 86 *                     189.0 178 3 5 0   0     0   3   103 86                 189
1678588 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury - Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_8 18 3 7 1   0     0   2   19 12 *                     31.0 18 3 7 1   0     0   2   19 12                 31
1678771 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware - Ware Junior/Senior High School   Regular School No High 07 12 2021   grade_8 99 3 7 0   0     1   4   57 57 *                     114.0 99 3 7 0   0     1   4   57 57                 114
1679715 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_8 8 11 29 0   0     0   0   19 29 *                     48.0 8 11 29 0   0     0   0   19 29                 48
1679719 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_8 23 9 146 0   0     1   1   95 85 *                     180.0 23 9 146 0   0     1   1   95 85                 180
1679734 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2021   grade_8 9 44 22 0   0     0   1   39 37 *                     76.0 9 44 22 0   0     0   1   39 37                 76
1679740 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public (District) - Four Rivers Charter Public School   Regular School Yes High 07 12 2021   grade_8 33 0 1 0   0     0   3   14 23 *                     37.0 33 0 1 0   0     0   3   14 23                 37
1679768 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District) - Bridge Boston Charter School   Regular School Yes Elementary PK 08 2021   grade_8 0 12 5 0   0     0   3   11 9 *                     20.0 0 12 5 0   0     0   3   11 9                 20
1679774 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public (District) - Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2021   grade_8 0 61 19 0   0     0   0   44 36 *                     80.0 0 61 19 0   0     0   0   44 36                 80
1679796 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway (District) - Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 08 2021   grade_8 0 0 38 0   0     0   0   20 18 *                     38.0 0 0 38 0   0     0   0   20 18                 38
1679871 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District) - Codman Academy Charter Public School   Regular School Yes Other PK 12 2021   grade_8 0 19 2 0   0     0   0   9 12 *                     21.0 0 19 2 0   0     0   0   9 12                 21
1679885 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District) - Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2021   grade_8 0 17 12 0   0     0   1   16 14 *                     30.0 0 17 12 0   0     0   1   16 14                 30
1679895 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District) - Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2021   grade_8 3 1 37 0   0     0   0   23 18 *                     41.0 3 1 37 0   0     0   0   23 18                 41
1679931 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_8 19 61 31 0   0     0   0   54 57 *                     111.0 19 61 31 0   0     0   0   54 57                 111
1679961 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District) - Boston Collegiate Charter School   Regular School Yes High 05 12 2021   grade_8 47 34 10 0   0     0   4   47 48 *                     95.0 47 34 10 0   0     0   4   47 48                 95
1679974 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District) - Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 26 2 2 0   0     0   2   14 17 *                     32.0 26 2 2 0   0     0   2   14 17                 32
1679997 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District) - Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2021   grade_8 1 1 75 0   0     0   0   29 48 *                     77.0 1 1 75 0   0     0   0   29 48                 77
1680029 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School (District) - KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2021   grade_8 0 33 26 0   0     0   0   37 22 *                     59.0 0 33 26 0   0     0   0   37 22                 59
1680034 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District) - Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2021   grade_8 19 2 2 0   0     0   2   16 9 *                     25.0 19 2 2 0   0     0   2   16 9                 25
1680043 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District) - Martha's Vineyard Charter School   Regular School Yes Other KG 12 2021   grade_8 13 0 4 0   0     0   3   11 9 *                     20.0 13 0 4 0   0     0   3   11 9                 20
1680097 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District) - UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2021   grade_8 3 54 67 0   0     1   2   62 65 *                     127.0 3 54 67 0   0     1   2   62 65                 127
1680146 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Learning First Charter Public School (District) - Learning First Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 1 35 33 0   0     0   2   35 36 *                     71.0 1 35 33 0   0     0   2   35 36                 71
1680236 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School (District) - Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2021   grade_8 2 12 61 0   0     0   1   33 43 *                     76.0 2 12 61 0   0     0   1   33 43                 76
1680303 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Regional - Hoosac Valley High School   Regular School No High 08 12 2021   grade_8 83 6 4 0   0     0   2   48 47 *                     95.0 83 6 4 0   0     0   2   48 47                 95
1680490 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire - Nessacus Regional Middle School   Regular School No Middle 06 08 2021   grade_8 121 2 7 0   0     0   6   79 57 *                     136.0 121 2 7 0   0     0   6   79 57                 136
1680539 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth - Dighton Middle School   Regular School No Middle 05 08 2021   grade_8 82 1 7 0   0     0   5   48 47 *                     95.0 82 1 7 0   0     0   5   48 47                 95
1680543 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_8 124 1 4 0   0     0   7   70 66 *                     136.0 124 1 4 0   0     0   7   70 66                 136

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