Data source: Big Local News · About: Big Local

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

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
1364793 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_8 164 6 14 0   3     0   0   106 81 *                     187.0 164 6 14 0   3     0   0   106 81                 187
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
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
1365821 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2020   grade_8 9 14 45 0   4     0   0   43 29 *                     72.0 9 14 45 0   4     0   0   43 29                 72
1365949 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2020   grade_8 2 25 28 0   1     0   0   22 34 *                     56.0 2 25 28 0   1     0   0   22 34                 56
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
1366121 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2020   grade_8 169 14 10 0   34     0   0   108 118 *                     227.0 169 14 10 0   34     0   0   108 118                 227
1366220 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_8 5 3 1 0   0     0   0   7 2 *                     9.0 5 3 1 0   0     0   0   7 2                 9
1366700 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2020   grade_8 91 3 51 0   2     0   0   74 73 *                     147.0 91 3 51 0   2     0   0   74 73                 147
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
1367298 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_8 7 0 0 0   0     0   0   1 6 *                     7.0 7 0 0 0   0     0   0   1 6                 7
1367470 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2020   grade_8 91 2 3 0   0     0   0   50 46 *                     96.0 91 2 3 0   0     0   0   50 46                 96
1367639 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2020   grade_8 29 1 0 0   0     0   0   16 14 *                     30.0 29 1 0 0   0     0   0   16 14                 30
1367805 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2020   grade_8 14 0 35 0   0     0   0   25 24 *                     49.0 14 0 35 0   0     0   0   25 24                 49
1367816 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_8 3 3 42 0   0     0   0   30 18 *                     48.0 3 3 42 0   0     0   0   30 18                 48
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
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
1367851 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2020   grade_8 5 1 35 0   0     0   0   15 26 *                     41.0 5 1 35 0   0     0   0   15 26                 41
1367982 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_8 4 2 82 0   3     0   0   48 43 *                     91.0 4 2 82 0   3     0   0   48 43                 91
1367986 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_8 2 1 146 0   0     0   0   74 73 *                     149.0 2 1 146 0   0     0   0   74 73                 149
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
1368042 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2020   grade_8 3 3 146 0   4     0   0   81 75 *                     156.0 3 3 146 0   4     0   0   81 75                 156
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
1368054 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_8 9 4 112 0   4     0   0   58 71 *                     129.0 9 4 112 0   4     0   0   58 71                 129
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
1368290 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 08 2020   grade_8 16 8 24 0   10     0   0   39 19 *                     58.0 16 8 24 0   10     0   0   39 19                 58
1369350 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2020   grade_8 3 6 5 0   0     0   0   10 4 *                     14.0 3 6 5 0   0     0   0   10 4                 14
1370376 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2020   grade_8 73 3 3 0   0     0   0   48 31 *                     79.0 73 3 3 0   0     0   0   48 31                 79
1370656 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2020   grade_8 19 7 17 0   3     0   0   17 29 *                     46.0 19 7 17 0   3     0   0   17 29                 46
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
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
1371013 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2020   grade_8 2 2 10 0   0     0   0   10 4 *                     14.0 2 2 10 0   0     0   0   10 4                 14
1371021 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2020   grade_8 6 3 9 0   0     0   0   13 5 *                     18.0 6 3 9 0   0     0   0   13 5                 18
1371024 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_8 4 13 93 0   0     0   0   60 50 *                     110.0 4 13 93 0   0     0   0   60 50                 110
1371027 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2020   grade_8 8 19 100 1   0     0   0   66 62 *                     128.0 8 19 100 1   0     0   0   66 62                 128
1371030 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2020   grade_8 14 19 62 0   3     0   0   45 53 *                     98.0 14 19 62 0   3     0   0   45 53                 98
1371033 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_8 8 9 34 1   0     0   0   20 32 *                     52.0 8 9 34 1   0     0   0   20 32                 52
1372451 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   grade_8 16 6 21 0   0     0   0   22 21 *                     43.0 16 6 21 0   0     0   0   22 21                 43
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
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
1372632 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2020   grade_8 2 0 30 0   0     0   0   10 22 *                     32.0 2 0 30 0   0     0   0   10 22                 32
1372723 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2020   grade_8 4 1 59 0   0     0   0   31 33 *                     64.0 4 1 59 0   0     0   0   31 33                 64
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
1373756 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No Middle 07 08 2020   grade_8 178 0 8 0   3     0   0   88 101 *                     189.0 178 0 8 0   3     0   0   88 101                 189
1374001 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2020   grade_8 37 0 5 0   1     0   0   15 28 *                     43.0 37 0 5 0   1     0   0   15 28                 43
1374254 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_8 2 97 10 1   0     0   0   60 50 *                     110.0 2 97 10 1   0     0   0   60 50                 110
1365192 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_8 87 2 4 0   0     0   1   50 44 *                     94.0 87 2 4 0   0     0   1   50 44                 94
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
1365340 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_8 4 24 59 0   1     0   1   48 41 *                     89.0 4 24 59 0   1     0   1   48 41                 89
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
1365411 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_8 9 2 89 0   0     0   1   46 55 *                     101.0 9 2 89 0   0     0   1   46 55                 101
1365428 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2020   grade_8 9 2 12 0   3     0   1   15 12 *                     27.0 9 2 12 0   3     0   1   15 12                 27
1365445 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2020   grade_8 5 21 11 0   0     0   1   14 24 *                     38.0 5 21 11 0   0     0   1   14 24                 38
1365581 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2020   grade_8 8 3 8 0   0     0   1   8 12 *                     20.0 8 3 8 0   0     0   1   8 12                 20
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
1365663 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_8 2 52 38 1   0     0   1   45 49 *                     94.0 2 52 38 1   0     0   1   45 49                 94
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
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
1366019 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2020   grade_8 6 5 138 0   2     0   1   78 74 *                     152.0 6 5 138 0   2     0   1   78 74                 152
1366118 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2020   grade_8 145 10 15 0   41     0   1   109 103 *                     212.0 145 10 15 0   41     0   1   109 103                 212
1366593 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2020   grade_8 9 8 112 0   0     0   1   70 60 *                     130.0 9 8 112 0   0     0   1   70 60                 130
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
1366690 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_8 14 1 0 0   0     0   1   7 9 *                     16.0 14 1 0 0   0     0   1   7 9                 16
1367018 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_8 28 2 5 0   0     0   1   17 19 *                     36.0 28 2 5 0   0     0   1   17 19                 36
1367062 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_8 32 23 63 1   12     0   1   68 64 *                     132.0 32 23 63 1   12     0   1   68 64                 132
1367611 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_8 208 5 5 0   5     0   1   125 99 *                     224.0 208 5 5 0   5     0   1   125 99                 224
1367703 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_8 73 7 41 1   3     0   1   67 59 *                     126.0 73 7 41 1   3     0   1   67 59                 126
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
1367860 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2020   grade_8 5 5 64 0   0     0   1   37 38 *                     75.0 5 5 64 0   0     0   1   37 38                 75
1367874 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2020   grade_8 79 2 5 1   2     0   1   49 41 *                     90.0 79 2 5 1   2     0   1   49 41                 90
1367928 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2020   grade_8 56 1 0 0   1     0   1   28 31 *                     59.0 56 1 0 0   1     0   1   28 31                 59
1368020 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_8 6 0 110 0   1     0   1   62 56 *                     118.0 6 0 110 0   1     0   1   62 56                 118
1368078 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2020   grade_8 50 1 4 0   2     0   1   31 27 *                     58.0 50 1 4 0   2     0   1   31 27                 58
1368602 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2020   grade_8 3 2 6 0   0     0   1   9 3 *                     12.0 3 2 6 0   0     0   1   9 3                 12
1368643 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_8 27 19 15 0   41     1   1   58 46 *                     104.0 27 19 15 0   41     1   1   58 46                 104
1369932 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2020   grade_8 218 1 0 0   2     1   1   126 97 *                     223.0 218 1 0 0   2     1   1   126 97                 223
1370314 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2020   grade_8 62 4 130 0   6     0   1   103 100 *                     203.0 62 4 130 0   6     0   1   103 100                 203
1370333 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_8 18 0 3 0   0     0   1   12 10 *                     22.0 18 0 3 0   0     0   1   12 10                 22
1370480 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2020   grade_8 128 10 52 1   12     1   1   105 100 *                     205.0 128 10 52 1   12     1   1   105 100                 205
1370694 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2020   grade_8 17 4 5 0   2     0   1   14 15 *                     29.0 17 4 5 0   2     0   1   14 15                 29
1370704 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2020   grade_8 8 13 32 0   6     0   1   35 25 *                     60.0 8 13 32 0   6     0   1   35 25                 60
1370748 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge Middle School   Regular School No Middle 06 08 2020   grade_8 66 1 86 1   4     0   1   86 73 *                     159.0 66 1 86 1   4     0   1   86 73                 159

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