Data source: Big Local News · About: Big Local

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

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
1672367 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham - Bellingham High School   Regular School No High 08 12 2021   grade_8 144 0 9 0   10     0   0   81 82 *                     163.0 144 0 9 0   10     0   0   81 82                 163
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
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
1672635 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_8 5 1 91 0   1     0   0   52 46 *                     98.0 5 1 91 0   1     0   0   52 46                 98
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
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
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
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
1673084 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_8 2 50 38 0   1     0   0   56 35 *                     91.0 2 50 38 0   1     0   0   56 35                 91
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
1673121 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_8 13 25 20 1   2     0   0   30 31 *                     61.0 13 25 20 1   2     0   0   30 31                 61
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
1673134 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston - James P Timilty Middle   Regular School No Middle 06 08 2021   grade_8 1 36 54 0   2     0   0   46 47 *                     93.0 1 36 54 0   2     0   0   46 47                 93
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
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
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
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
1674665 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin - Annie Sullivan Middle School   Regular School No Middle 06 08 2021   grade_8 108 2 10 1   4     0   0   70 55 *                     125.0 108 2 10 1   4     0   0   70 55                 125
1674948 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill - John G Whittier   Regular School No Middle 05 08 2021   grade_8 102 7 36 0   2     0   0   72 74 *                     147.0 102 7 36 0   2     0   0   72 74                 147
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
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
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
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
1675227 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence - Alexander B Bruce   Regular School No Middle 03 08 2021   grade_8 5 0 69 0   2     0   0   36 40 *                     76.0 5 0 69 0   2     0   0   36 40                 76
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
1675252 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence - Parthum Middle School   Regular School No Middle 05 08 2021   grade_8 10 3 146 0   1     0   0   72 86 *                     160.0 10 3 146 0   1     0   0   72 86                 160
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
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
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
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
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
1677936 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 Somerville - E Somerville Community   Regular School No Elementary KG 08 2021   grade_8 10 4 58 1   3     0   0   34 42 *                     76.0 10 4 58 1   3     0   0   34 42                 76
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
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
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
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
1678286 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield - Chestnut Academy   Regular School No Middle 06 08 2021   grade_8 2 9 83 0   1     0   0   49 46 *                     95.0 2 9 83 0   1     0   0   49 46                 95
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
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
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
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
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
1679957 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District) - Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 35 2 0 0   15     0   0   22 30 *                     52.0 35 2 0 0   15     0   0   22 30                 52
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
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
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
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
1680789 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet - Masconomet Regional Middle School   Regular School No Middle 07 08 2021   grade_8 250 2 5 0   5     0   0   138 124 *                     262.0 250 2 5 0   5     0   0   138 124                 262
1680881 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail - Mohawk Trail Regional School   Regular School No High 07 12 2021   grade_8 65 0 1 0   0     0   0   31 35 *                     66.0 65 0 1 0   0     0   0   31 35                 66
1681439 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District) - Baystate Academy Charter Public School   Regular School Yes High 06 12 2021   grade_8 3 16 58 0   0     0   0   35 42 *                     77.0 3 16 58 0   0     0   0   35 42                 77
1681464 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester (District) - UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2021   grade_8 2 34 29 0   0     0   0   33 32 *                     65.0 2 34 29 0   0     0   0   33 32                 65
1672335 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford - John Glenn Middle   Regular School No Middle 06 08 2021   grade_8 141 10 12 1   41     0   1   120 86 *                     206.0 141 10 12 1   41     0   1   120 86                 206
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
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
1672710 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston - Condon K-8   Regular School No Elementary PK 08 2021   grade_8 18 27 29 0   3     0   1   42 36 *                     78.0 18 27 29 0   3     0   1   42 36                 78
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
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
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
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
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
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
1673128 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston - Clarence R Edwards Middle   Regular School No Middle 06 08 2021   grade_8 13 17 84 0   2     0   1   60 57 *                     117.0 13 17 84 0   2     0   1   60 57                 117
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
1673225 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   grade_8 2 14 21 0   38     0   1   39 37 *                     76.0 2 14 21 0   38     0   1   39 37                 76
1673256 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   grade_8 7 1 137 0   1     0   1   74 73 *                     147.0 7 1 137 0   1     0   1   74 73                 147
1673351 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree - East Middle School   Regular School No Middle 05 08 2021   grade_8 135 28 15 0   64     0   1   124 119 *                     243.0 135 28 15 0   64     0   1   124 119                 243
1673354 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree - South Middle School   Regular School No Middle 06 08 2021   grade_8 168 9 10 0   54     0   1   115 127 *                     242.0 168 9 10 0   54     0   1   115 127                 242
1674193 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton - White Brook Middle School   Regular School No Middle 05 08 2021   grade_8 88 1 17 1   6     0   1   55 59 *                     114.0 88 1 17 1   6     0   1   55 59                 114
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
1674281 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett - Madeline English School   Regular School No Elementary KG 08 2021   grade_8 29 17 37 0   6     0   1   48 42 *                     90.0 29 17 37 0   6     0   1   48 42                 90
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
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
1674668 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin - Remington Middle   Regular School No Middle 06 08 2021   grade_8 99 5 8 0   10     0   1   66 57 *                     123.0 99 5 8 0   10     0   1   66 57                 123
1674705 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown - Georgetown Middle School   Regular School No Middle 07 08 2021   grade_8 82 0 2 0   2     1   1   41 47 *                     88.0 82 0 2 0   2     1   1   41 47                 88
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
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
1675193 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich - Ipswich Middle School   Regular School No Middle 06 08 2021   grade_8 117 3 12 0   3     0   1   64 72 *                     136.0 117 3 12 0   3     0   1   64 72                 136
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
1675284 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence - Emily G Wetherbee   Regular School No Elementary KG 08 2021   grade_8 5 1 64 0   1     0   1   35 37 *                     72.0 5 1 64 0   1     0   1   35 37                 72
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

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