Data source: Big Local News · About: Big Local

499 rows where grade = "grade_8", state = "MA" and year = 2021 sorted by female_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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1672504 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_8 3 4 8 0   1     0   1   13 4 *                     17.0 3 4 8 0   1     0   1   13 4                 17
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
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
1673019 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_8 3 12 10 0   1     0   1   22 5 *                     27.0 3 12 10 0   1     0   1   22 5                 27
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
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
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
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
1672886 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_8 7 3 2 0   1     0   1   6 8 *                     14.0 7 3 2 0   1     0   1   6 8                 14
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
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
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
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
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
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
1680721 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Hampden-Wilbraham - Green Meadows Elementary   Regular School No Elementary PK 08 2021   grade_8 9 1 4 0   0     0   0   4 10 *                     14.0 9 1 4 0   0     0   0   4 10                 14
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
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
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
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
1672811 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston - Joyce Kilmer   Regular School No Elementary PK 08 2021   grade_8 9 5 10 0   2     0   2   14 14 *                     28.0 9 5 10 0   2     0   2   14 14                 28
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
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
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
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
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
1677946 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 Somerville - West Somerville Neighborhood   Regular School No Elementary PK 08 2021   grade_8 24 2 6 0   4     0   2   23 15 *                     38.0 24 2 6 0   4     0   2   23 15                 38
1672538 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston - Jackson Mann   Regular School No Elementary PK 08 2021   grade_8 1 17 17 0   2     0   0   21 16 *                     37.0 1 17 17 0   2     0   0   21 16                 37
1681204 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional - West Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_8 35 0 1 0   0     0   1   21 16 *                     37.0 35 0 1 0   0     0   1   21 16                 37
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
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
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
1672987 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston - Gardner Pilot Academy   Regular School No Elementary PK 08 2021   grade_8 6 8 22 0   2     0   1   21 18 *                     39.0 6 8 22 0   2     0   1   21 18                 39
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
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
1672670 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston - Franklin D Roosevelt   Regular School No Elementary PK 08 2021   grade_8 2 20 21 0   1     0   2   27 19 *                     46.0 2 20 21 0   1     0   2   27 19                 46
1674247 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown - Edgartown Elementary   Regular School No Elementary PK 08 2021   grade_8 24 1 8 2   1     0   2   19 19 *                     38.0 24 1 8 2   1     0   2   19 19                 38
1679839 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District) - Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 08 2021   grade_8 1 0 33 0   1     0   0   16 19 *                     35.0 1 0 33 0   1     0   0   16 19                 35
1681249 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett - Thomas Prince   Regular School No Elementary KG 08 2021   grade_8 40 0 0 0   3     0   1   25 19 *                     44.0 40 0 0 0   3     0   1   25 19                 44
1673005 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_8 12 5 11 0   1     0   4   13 20 *                     33.0 12 5 11 0   1     0   4   13 20                 33
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
1674833 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley - Hopkins Academy   Regular School No High 07 12 2021   grade_8 36 2 7 0   2     0   1   28 20 *                     48.0 36 2 7 0   2     0   1   28 20                 48
1675051 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke - Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2021   grade_8 19 2 21 0   1     0   0   23 20 *                     43.0 19 2 21 0   1     0   0   23 20                 43
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
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
1679636 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester - University Pk Campus School   Regular School No High 07 12 2021   grade_8 7 4 20 1   4     0   5   20 21 *                     41.0 7 4 20 1   4     0   5   20 21                 41
1680114 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District) - River Valley Charter School   Regular School Yes Elementary KG 08 2021   grade_8 27 0 0 0   1     0   3   10 21 *                     31.0 27 0 0 0   1     0   3   10 21                 31
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
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
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
1675086 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke - Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2021   grade_8 6 1 41 0   2     0   0   28 22 *                     50.0 6 1 41 0   2     0   0   28 22                 50
1675471 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln - Lincoln School   Regular School No Elementary PK 08 2021   grade_8 27 7 3 0   2     0   6   23 22 *                     45.0 27 7 3 0   2     0   6   23 22                 45
1680006 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District) - Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 20 2 9 0   1     0   0   10 22 *                     32.0 20 2 9 0   1     0   0   10 22                 32
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
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
1675476 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln - Hanscom Middle   Regular School No Middle 04 08 2021   grade_8 17 6 13 0   1     0   5   19 23 *                     42.0 17 6 13 0   1     0   5   19 23                 42
1675625 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell - Bartlett Community Partnership   Regular School No Elementary PK 08 2021   grade_8 9 7 20 0   16     0   1   30 23 *                     53.0 9 7 20 0   16     0   1   30 23                 53
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
1680228 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District) - Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2021   grade_8 30 8 3 0   7     0   8   33 23 *                     56.0 30 8 3 0   7     0   8   33 23                 56
1680638 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway - Gateway Regional Middle School   Regular School No Middle 06 08 2021   grade_8 53 0 3 1   0     0   1   35 23 *                     58.0 53 0 3 1   0     0   1   35 23                 58
1673058 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston - Edison K-8   Regular School No Elementary PK 08 2021   grade_8 3 13 33 0   4     0   3   32 24 *                     56.0 3 13 33 0   4     0   3   32 24                 56
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
1677917 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 Somerville - John F Kennedy   Regular School No Elementary PK 08 2021   grade_8 34 3 7 0   3     0   0   23 24 *                     47.0 34 3 7 0   3     0   0   23 24                 47
1672653 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_8 16 8 19 1   5     0   1   25 25 *                     50.0 16 8 19 1   5     0   1   25 25                 50
1673545 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline - Lawrence   Regular School No Elementary KG 08 2021   grade_8 31 4 3 0   18     0   5   36 25 *                     61.0 31 4 3 0   18     0   5   36 25                 61
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
1672844 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_8 3 8 26 0   1     0   0   12 26 *                     38.0 3 8 26 0   1     0   0   12 26                 38
1680207 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District) - Pioneer Charter School of Science   Regular School Yes Other KG 12 2021   grade_8 24 14 14 2   5     0   0   33 26 *                     59.0 24 14 14 2   5     0   0   33 26                 59
1673752 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_8 49 0 2 0   6     0   8   38 27 *                     65.0 49 0 2 0   6     0   8   38 27                 65
1674266 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett - Sumner G. Whittier School   Regular School No Elementary KG 08 2021   grade_8 7 4 42 0   4     0   1   31 27 *                     58.0 7 4 42 0   4     0   1   31 27                 58
1677669 MA Essex   school 2510380 258   Salem 251038000773 2580050 Salem - Saltonstall School   Regular School No Elementary KG 08 2021   grade_8 19 4 20 0   1     0   1   18 27 *                     45.0 19 4 20 0   1     0   1   18 27                 45
1677956 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Somerville - Winter Hill Community   Regular School No Elementary PK 08 2021   grade_8 5 9 34 0   1     0   0   22 27 *                     49.0 5 9 34 0   1     0   0   22 27                 49
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
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
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
1675353 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox - Lenox Memorial High   Regular School No High 06 12 2021   grade_8 48 0 6 0   3     0   4   33 28 *                     61.0 48 0 6 0   3     0   4   33 28                 61
1676348 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson - Monson High School   Regular School No High 07 12 2021   grade_8 53 0 1 0   3     0   1   30 28 *                     58.0 53 0 1 0   3     0   1   30 28                 58
1677907 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Somerville - Arthur D Healey   Regular School No Elementary PK 08 2021   grade_8 10 11 23 0   4     0   3   23 28 *                     51.0 10 11 23 0   4     0   3   23 28                 51
1679747 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District) - Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2021   grade_8 40 10 8 1   3     0   5   38 28 *                     67.0 40 10 8 1   3     0   5   38 28                 67
1672793 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston - Joseph Lee   Regular School No Elementary PK 08 2021   grade_8 2 29 19 0   4     0   6   31 29 *                     60.0 2 29 19 0   4     0   6   31 29                 60
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
1679853 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District) - Community Charter School of Cambridge   Regular School Yes High 06 12 2021   grade_8 3 50 6 0   2     0   3   35 29 *                     64.0 3 50 6 0   2     0   3   35 29                 64

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