Data source: Big Local News · About: Big Local

500 rows where grade = "grade_8", state = "MA" and year = 2020 sorted by white

View and edit SQL

year

  • 2020 · 500

grade

  • grade_8 · 500
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
1365149 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2020   grade_8 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1365345 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter School   Regular School No High 07 12 2020   grade_8 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1366633 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_8 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1367066 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_8 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1367688 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_8 * * * *   *     *   *   2 * *                     2.0                         2                   2
1368370 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_8 * * * *   *     *   *   3 * *                     3.0                         3                   3
1368389 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No High 08 12 2020   grade_8 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1368426 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 12 2020   grade_8 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1368465 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1373190 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_8 * * * *   *     *   *   1 * *                     2.0                         1                   2
1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1365306 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_8 0 8 14 0   0     0   1   10 13 *                     23.0 0 8 14 0   0     0   1   10 13                 23
1365554 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2020   grade_8 0 0 15 0   0     0   0   9 6 *                     15.0 0 0 15 0   0     0   0   9 6                 15
1365612 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_8 0 9 21 0   3     0   0   19 14 *                     33.0 0 9 21 0   3     0   0   19 14                 33
1365741 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_8 0 10 13 0   0     0   0   16 7 *                     23.0 0 10 13 0   0     0   0   16 7                 23
1365804 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_8 0 10 12 0   0     0   5   15 12 *                     27.0 0 10 12 0   0     0   5   15 12                 27
1365831 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2020   grade_8 0 21 16 0   0     0   3   17 23 *                     40.0 0 21 16 0   0     0   3   17 23                 40
1365837 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 03 08 2020   grade_8 0 20 12 0   0     0   4   21 15 *                     36.0 0 20 12 0   0     0   4   21 15                 36
1365857 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_8 0 19 18 0   0     0   1   23 15 *                     38.0 0 19 18 0   0     0   1   23 15                 38
1365867 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2020   grade_8 0 3 9 0   0     0   2   10 4 *                     14.0 0 3 9 0   0     0   2   10 4                 14
1366041 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2020   grade_8 0 0 15 0   0     0   0   4 11 *                     15.0 0 0 15 0   0     0   0   4 11                 15
1367824 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2020   grade_8 0 2 37 0   0     0   0   24 15 *                     39.0 0 2 37 0   0     0   0   24 15                 39
1368003 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_8 0 3 105 0   1     0   0   50 59 *                     109.0 0 3 105 0   1     0   0   50 59                 109
1368039 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_8 0 1 65 0   2     0   0   31 37 *                     68.0 0 1 65 0   2     0   0   31 37                 68
1368045 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_8 0 1 102 0   1     0   0   60 44 *                     104.0 0 1 102 0   1     0   0   60 44                 104
1370707 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_8 0 2 7 0   1     0   0   8 * *                     10.0 0 2 7 0   1     0   0   8                   10
1371019 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2020   grade_8 0 8 58 0   0     0   2   36 32 *                     68.0 0 8 58 0   0     0   2   36 32                 68
1372505 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 08 2020   grade_8 0 15 6 0   0     0   1   10 12 *                     22.0 0 15 6 0   0     0   1   10 12                 22
1372533 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 08 2020   grade_8 0 0 32 0   1     0   0   14 19 *                     33.0 0 0 32 0   1     0   0   14 19                 33
1372576 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 08 2020   grade_8 0 0 30 0   0     0   0   18 12 *                     30.0 0 0 30 0   0     0   0   18 12                 30
1372608 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_8 0 15 4 0   0     0   0   10 9 *                     19.0 0 15 4 0   0     0   0   10 9                 19
1372622 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2020   grade_8 0 15 9 0   0     0   0   7 17 *                     24.0 0 15 9 0   0     0   0   7 17                 24
1372765 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2020   grade_8 0 39 18 0   0     0   1   24 34 *                     58.0 0 39 18 0   0     0   1   24 34                 58
1365387 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_8 1 43 18 0   0     2   1   30 35 *                     65.0 1 43 18 0   0     2   1   30 35                 65
1365401 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2020   grade_8 1 7 11 0   0     0   4   13 10 *                     23.0 1 7 11 0   0     0   4   13 10                 23
1365564 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2020   grade_8 1 30 15 0   2     0   3   28 23 *                     51.0 1 30 15 0   2     0   3   28 23                 51
1365751 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2020   grade_8 1 6 28 0   1     0   2   22 16 *                     38.0 1 6 28 0   1     0   2   22 16                 38
1365782 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_8 1 7 10 0   0     0   1   17 2 *                     19.0 1 7 10 0   0     0   1   17 2                 19
1365898 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2020   grade_8 1 40 70 0   0     0   3   49 65 *                     114.0 1 40 70 0   0     0   3   49 65                 114
1368063 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_8 1 0 12 0   0     0   0   11 2 *                     13.0 1 0 12 0   0     0   0   11 2                 13
1372462 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2020   grade_8 1 25 27 0   0     0   0   24 29 *                     53.0 1 25 27 0   0     0   0   24 29                 53
1372511 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2020   grade_8 1 40 13 0   0     0   0   31 23 *                     54.0 1 40 13 0   0     0   0   31 23                 54
1372733 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2020   grade_8 1 0 47 0   0     0   0   20 28 *                     48.0 1 0 47 0   0     0   0   20 28                 48
1372794 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_8 1 33 59 0   0     0   1   46 48 *                     94.0 1 33 59 0   0     0   1   46 48                 94
1372832 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2020   grade_8 1 71 58 0   10     0   1   60 81 *                     141.0 1 71 58 0   10     0   1   60 81                 141
1372861 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_8 1 126 94 2   4     2   2   125 106 *                     231.0 1 126 94 2   4     2   2   125 106                 231
1374219 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2020   grade_8 1 35 30 0   1     1   1   32 37 *                     69.0 1 35 30 0   1     1   1   32 37                 69
1374260 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 08 2020   grade_8 1 11 74 0   0     0   1   47 40 *                     87.0 1 11 74 0   0     0   1   47 40                 87
1365653 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_8 10 9 8 0   0     0   1   15 13 *                     28.0 10 9 8 0   0     0   1   15 13                 28
1365768 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_8 10 5 15 0   2     0   0   12 20 *                     32.0 10 5 15 0   2     0   0   12 20                 32
1367037 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2020   grade_8 10 7 34 1   4     0   2   29 29 *                     58.0 10 7 34 1   4     0   2   29 29                 58
1367087 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_8 10 18 103 0   3     0   0   65 69 *                     134.0 10 18 103 0   3     0   0   65 69                 134
1367841 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2020   grade_8 10 4 44 0   0     0   0   29 29 *                     58.0 10 4 44 0   0     0   0   29 29                 58
1370684 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2020   grade_8 10 5 63 0   4     0   0   42 40 *                     82.0 10 5 63 0   4     0   0   42 40                 82
1373456 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2020   grade_8 10 1 1 0   0     0   1   7 6 *                     13.0 10 1 1 0   0     0   1   7 6                 13
1373675 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2020   grade_8 100 0 2 0   1     0   3   50 56 *                     106.0 100 0 2 0   1     0   3   50 56                 106
1367707 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_8 101 9 100 1   4     0   1   119 97 *                     216.0 101 9 100 1   4     0   1   119 97                 216
1368093 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_8 102 6 15 0   7     0   5   77 58 *                     135.0 102 6 15 0   7     0   5   77 58                 135
1369336 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_8 102 51 132 1   0     1   10   150 147 *                     297.0 102 51 132 1   0     1   10   150 147                 297
1371502 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_8 102 20 53 0   9     0   1   93 92 *                     185.0 102 20 53 0   9     0   1   93 92                 185
1373874 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_8 102 0 8 0   1     0   3   60 54 *                     114.0 102 0 8 0   1     0   3   60 54                 114
1370734 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2020   grade_8 103 0 12 0   30     0   8   84 69 *                     153.0 103 0 12 0   30     0   8   84 69                 153
1371201 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2020   grade_8 103 2 5 0   3     0   3   57 59 *                     116.0 103 2 5 0   3     0   3   57 59                 116
1372562 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2020   grade_8 104 0 9 0   20     0   13   81 65 *                     146.0 104 0 9 0   20     0   13   81 65                 146
1371816 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2020   grade_8 105 8 7 0   27     0   11   84 74 *                     158.0 105 8 7 0   27     0   11   84 74                 158
1370360 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2020   grade_8 106 15 31 0   3     0   5   74 86 *                     160.0 106 15 31 0   3     0   5   74 86                 160
1373514 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2020   grade_8 106 0 2 0   1     0   2   59 52 *                     111.0 106 0 2 0   1     0   2   59 52                 111
1367384 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2020   grade_8 107 17 113 0   7     1   5   123 127 *                     250.0 107 17 113 0   7     1   5   123 127                 250
1368241 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2020   grade_8 107 5 2 0   6     0   5   52 73 *                     125.0 107 5 2 0   6     0   5   52 73                 125
1369038 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2020   grade_8 107 4 14 0   6     0   6   67 70 *                     137.0 107 4 14 0   6     0   6   67 70                 137
1373709 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2020   grade_8 107 3 5 0   3     0   6   72 52 *                     124.0 107 3 5 0   3     0   6   72 52                 124
1367381 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2020   grade_8 108 15 43 0   6     0   8   95 85 *                     180.0 108 15 43 0   6     0   8   95 85                 180
1367431 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2020   grade_8 108 1 11 0   6     1   3   67 63 *                     130.0 108 1 11 0   6     1   3   67 63                 130
1368746 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2020   grade_8 108 6 179 0   4     0   13   149 161 *                     310.0 108 6 179 0   4     0   13   149 161                 310
1372392 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2020   grade_8 108 67 200 0   41     0   16   210 222 *                     432.0 108 67 200 0   41     0   16   210 222                 432
1366865 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2020   grade_8 109 0 3 0   1     0   3   73 43 *                     116.0 109 0 3 0   1     0   3   73 43                 116
1374010 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2020   grade_8 109 3 3 0   3     0   3   51 70 *                     121.0 109 3 3 0   3     0   3   51 70                 121
1366597 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_8 11 2 137 1   0     0   1   78 74 *                     152.0 11 2 137 1   0     0   1   78 74                 152
1371016 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2020   grade_8 11 9 65 0   4     0   2   50 41 *                     91.0 11 9 65 0   4     0   2   50 41                 91
1373640 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 06 08 2020   grade_8 110 0 3 0   0     0   3   61 55 *                     116.0 110 0 3 0   0     0   3   61 55                 116
1369999 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2020   grade_8 111 25 17 0   2     0   17   90 82 *                     172.0 111 25 17 0   2     0   17   90 82                 172
1371452 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2020   grade_8 111 1 7 0   17     0   5   72 69 *                     141.0 111 1 7 0   17     0   5   72 69                 141
1364808 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_8 112 2 2 0   1     0   3   62 58 *                     120.0 112 2 2 0   1     0   3   62 58                 120
1367192 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_8 112 16 45 0   9     0   13   118 77 *                     195.0 112 16 45 0   9     0   13   118 77                 195
1372115 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_8 112 7 13 1   9     0   5   72 75 *                     147.0 112 7 13 1   9     0   5   72 75                 147
1373165 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2020   grade_8 112 2 5 0   0     0   6   70 55 *                     125.0 112 2 5 0   0     0   6   70 55                 125
1365111 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2020   grade_8 113 11 15 0   28     0   14   101 80 *                     181.0 113 11 15 0   28     0   14   101 80                 181
1373442 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2020   grade_8 114 1 9 0   10     1   2   49 88 *                     137.0 114 1 9 0   10     1   2   49 88                 137
1373718 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2020   grade_8 114 4 4 0   3     0   3   78 50 *                     128.0 114 4 4 0   3     0   3   78 50                 128
1369472 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2020   grade_8 115 9 11 1   41     1   12   108 82 *                     190.0 115 9 11 1   41     1   12   108 82                 190
1369822 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2020   grade_8 115 1 16 0   2     0   9   74 69 *                     143.0 115 1 16 0   2     0   9   74 69                 143
1370174 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2020   grade_8 115 2 8 0   74     1   6   93 113 *                     206.0 115 2 8 0   74     1   6   93 113                 206
1371786 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2020   grade_8 115 0 7 0   60     0   4   95 91 *                     186.0 115 0 7 0   60     0   4   95 91                 186
1374066 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_8 115 2 6 0   2     0   2   65 62 *                     127.0 115 2 6 0   2     0   2   65 62                 127
1372385 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2020   grade_8 116 75 142 1   17     0   8   189 170 *                     359.0 116 75 142 1   17     0   8   189 170                 359
1366673 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2020   grade_8 118 7 100 0   7     0   11   133 110 *                     243.0 118 7 100 0   7     0   11   133 110                 243
1370765 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2020   grade_8 118 2 16 0   4     0   4   80 64 *                     144.0 118 2 16 0   4     0   4   80 64                 144
1371567 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2020   grade_8 118 8 38 0   10     0   7   93 88 *                     181.0 118 8 38 0   10     0   7   93 88                 181
1372063 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2020   grade_8 118 2 35 0   3     0   3   89 72 *                     161.0 118 2 35 0   3     0   3   89 72                 161
1368207 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2020   grade_8 119 14 14 0   108     0   26   128 153 *                     281.0 119 14 14 0   108     0   26   128 153                 281

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