enrollments

Data source: Big Local News · About: Big Local

490 rows where grade = "grade_8", state = "MA" and year = 2017 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 490 ✖

grade ✖

  • grade_8 · 490 ✖
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
1122006 1122006 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_8 * * * *   *     *   *   1 1                       *                         1 1                  
1123449 1123449 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_8 * * * *   *     *   *   1 2                       *                         1 2                  
1123655 1123655 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No High 07 12 2017   grade_8 * * * *   *     *   *   3 1                       *                         3 1                  
1125194 1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125268 1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125426 1125426 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_8 * * * *   *     *   *   2 3                       *                         2 3                  
1128684 1128684 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_8 * * * *   *     *   *   2 *                       *                         2                    
1122630 1122630 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_8 0 18 67 0   0     0   0   40 45                       85 0 18 67 0   0     0   0   40 45                 85
1122803 1122803 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2017   grade_8 0 16 36 0   0     1   0   31 22                       53 0 16 36 0   0     1   0   31 22                 53
1122874 1122874 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_8 0 0 17 0   0     0   0   5 12                       17 0 0 17 0   0     0   0   5 12                 17
1122947 1122947 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_8 0 10 37 0   0     0   0   26 21                       47 0 10 37 0   0     0   0   26 21                 47
1123192 1123192 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_8 0 15 10 0   1     0   3   16 13                       29 0 15 10 0   1     0   3   16 13                 29
1123222 1123222 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_8 0 21 21 0   0     0   1   27 16                       43 0 21 21 0   0     0   1   27 16                 43
1123440 1123440 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_8 0 1 24 0   0     0   0   12 13                       25 0 1 24 0   0     0   0   12 13                 25
1123455 1123455 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_8 0 2 5 0   0     0   0   5 2                       7 0 2 5 0   0     0   0   5 2                 7
1125564 1125564 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_8 0 0 39 0   0     0   0   19 20                       39 0 0 39 0   0     0   0   19 20                 39
1131171 1131171 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 2017   grade_8 0 56 14 0   0     2   0   43 29                       72 0 56 14 0   0     2   0   43 29                 72
1131441 1131441 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2017   grade_8 0 42 19 0   0     0   1   37 25                       62 0 42 19 0   0     0   1   37 25                 62
1133145 1133145 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 2017   grade_8 0 31 18 0   1     0   0   22 28                       50 0 31 18 0   1     0   0   22 28                 50
1122687 1122687 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_8 1 33 17 0   0     0   2   28 25                       53 1 33 17 0   0     0   2   28 25                 53
1123093 1123093 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_8 1 9 24 0   0     0   0   16 18                       34 1 9 24 0   0     0   0   16 18                 34
1123139 1123139 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_8 1 17 15 0   0     0   0   23 10                       33 1 17 15 0   0     0   0   23 10                 33
1123162 1123162 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_8 1 19 6 0   0     0   0   9 17                       26 1 19 6 0   0     0   0   9 17                 26
1123201 1123201 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_8 1 17 8 0   1     0   2   16 13                       29 1 17 8 0   1     0   2   16 13                 29
1123233 1123233 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_8 1 4 7 0   0     0   0   7 5                       12 1 4 7 0   0     0   0   7 5                 12
1123268 1123268 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2017   grade_8 1 41 110 0   0     0   3   90 65                       155 1 41 110 0   0     0   3   90 65                 155
1125580 1125580 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_8 1 0 40 0   2     0   0   17 26                       43 1 0 40 0   2     0   0   17 26                 43
1125783 1125783 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_8 1 1 80 0   3     0   0   44 41                       85 1 1 80 0   3     0   0   44 41                 85
1125831 1125831 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_8 1 1 100 0   1     0   0   49 54                       103 1 1 100 0   1     0   0   49 54                 103
1125885 1125885 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_8 1 0 17 0   1     0   0   15 4                       19 1 0 17 0   1     0   0   15 4                 19
1129379 1129379 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No Middle 06 08 2017   grade_8 1 11 89 0   0     0   0   54 47                       101 1 11 89 0   0     0   0   54 47                 101
1131273 1131273 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_8 1 17 5 0   0     0   0   8 15                       23 1 17 5 0   0     0   0   8 15                 23
1131288 1131288 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2017   grade_8 1 16 4 0   0     0   1   11 11                       22 1 16 4 0   0     0   1   11 11                 22
1131407 1131407 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   grade_8 1 0 54 0   0     0   0   26 29                       55 1 0 54 0   0     0   0   26 29                 55
1131428 1131428 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2017   grade_8 1 21 31 0   16     0   2   33 38                       71 1 21 31 0   16     0   2   33 38                 71
1122904 1122904 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_8 10 5 5 0   3     0   1   9 15                       24 10 5 5 0   3     0   1   9 15                 24
1122973 1122973 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_8 10 23 19 0   27     1   7   55 32                       87 10 23 19 0   27     1   7   55 32                 87
1123872 1123872 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_8 10 2 13 0   0     0   2   8 19                       27 10 2 13 0   0     0   2   8 19                 27
1125553 1125553 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_8 10 0 33 1   0     0   0   29 15                       44 10 0 33 1   0     0   0   29 15                 44
1129351 1129351 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2017   grade_8 10 28 93 0   1     0   1   67 66                       133 10 28 93 0   1     0   1   67 66                 133
1129383 1129383 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2017   grade_8 10 8 50 0   2     0   2   27 45                       72 10 8 50 0   2     0   2   27 45                 72
1131525 1131525 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 2017   grade_8 10 62 44 0   5     0   0   62 59                       121 10 62 44 0   5     0   0   62 59                 121
1127382 1127382 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_8 101 34 113 1   1     0   17   138 129                       267 101 34 113 1   1     0   17   138 129                 267
1131224 1131224 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_8 101 1 10 0   32     0   5   73 76                       149 101 1 10 0   32     0   5   73 76                 149
1124796 1124796 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2017   grade_8 103 10 59 0   12     0   6   88 102                       190 103 10 59 0   12     0   6   88 102                 190
1126923 1126923 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_8 103 0 29 0   3     0   6   69 72                       141 103 0 29 0   3     0   6   69 72                 141
1129583 1129583 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2017   grade_8 103 3 2 0   2     0   7   66 51                       117 103 3 2 0   2     0   7   66 51                 117
1126103 1126103 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2017   grade_8 104 0 3 1   11     0   3   49 73                       122 104 0 3 1   11     0   3   49 73                 122
1132518 1132518 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2017   grade_8 106 1 5 0   1     1   7   59 62                       121 106 1 5 0   1     1   7   59 62                 121
1132370 1132370 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   grade_8 109 9 5 1   0     0   6   58 72                       130 109 9 5 1   0     0   6   58 72                 130
1132738 1132738 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_8 109 2 9 0   1     0   1   63 59                       122 109 2 9 0   1     0   1   63 59                 122
1122569 1122569 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_8 11 1 3 0   1     0   1   10 7                       17 11 1 3 0   1     0   1   10 7                 17
1123123 1123123 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_8 11 9 9 1   2     0   0   19 13                       32 11 9 9 1   2     0   0   19 13                 32
1123252 1123252 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_8 11 28 14 0   5     0   2   26 34                       60 11 28 14 0   5     0   2   26 34                 60
1125814 1125814 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_8 11 0 113 0   1     0   1   70 56                       126 11 0 113 0   1     0   1   70 56                 126
1126504 1126504 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_8 11 0 6 0   0     0   0   10 7                       17 11 0 6 0   0     0   0   10 7                 17
1128952 1128952 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2017   grade_8 11 5 18 0   4     0   2   21 19                       40 11 5 18 0   4     0   2   21 19                 40
1129387 1129387 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No Other 06 11 2017   grade_8 11 20 26 0   0     0   1   12 46                       58 11 20 26 0   0     0   1   12 46                 58
1131457 1131457 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_8 11 0 1 0   2     0   1   12 3                       15 11 0 1 0   2     0   1   12 3                 15
1131043 1131043 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2017   grade_8 110 62 175 1   41     0   13   217 185                       402 110 62 175 1   41     0   13   217 185                 402
1121975 1121975 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_8 111 2 0 0   1     0   0   51 63                       114 111 2 0 0   1     0   0   51 63                 114
1129080 1129080 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2017   grade_8 111 4 15 0   1     0   6   73 64                       137 111 4 15 0   1     0   6   73 64                 137
1132024 1132024 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2017   grade_8 111 1 5 0   0     0   2   66 53                       119 111 1 5 0   0     0   2   66 53                 119
1125132 1125132 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_8 112 0 0 0   1     0   1   59 55                       114 112 0 0 0   1     0   1   59 55                 114
1128370 1128370 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2017   grade_8 112 6 6 0   90     1   6   117 104                       221 112 6 6 0   90     1   6   117 104                 221
1127374 1127374 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_8 113 48 102 3   4     2   21   146 147                       293 113 48 102 3   4     2   21   146 147                 293
1132119 1132119 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2017   grade_8 113 1 5 0   6     0   2   68 59                       127 113 1 5 0   6     0   2   68 59                 127
1122341 1122341 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2017   grade_8 114 6 13 0   18     0   7   81 77                       158 114 6 13 0   18     0   7   81 77                 158
1129887 1129887 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2017   grade_8 115 7 5 0   13     0   3   68 75                       143 115 7 5 0   13     0   3   68 75                 143
1126340 1126340 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2017   grade_8 116 1 5 1   0     0   0   71 52                       123 116 1 5 1   0     0   0   71 52                 123
1128161 1128161 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2017   grade_8 117 24 21 0   1     0   16   86 93                       179 117 24 21 0   1     0   16   86 93                 179
1126263 1126263 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2017   grade_8 12 4 22 0   17     0   4   38 21                       59 12 4 22 0   17     0   4   38 21                 59
1129006 1129006 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2017   grade_8 12 6 29 0   5     0   0   28 24                       52 12 6 29 0   5     0   0   28 24                 52
1125022 1125022 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_8 120 17 40 0   2     0   7   97 89                       186 120 17 40 0   2     0   7   97 89                 186
1126737 1126737 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_8 120 7 6 9   3     0   3   68 80                       148 120 7 6 9   3     0   3   68 80                 148
1127975 1127975 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 08 12 2017   grade_8 120 4 5 0   1     0   5   76 59                       135 120 4 5 0   1     0   5   76 59                 135
1129778 1129778 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2017   grade_8 120 2 4 1   3     0   6   60 76                       136 120 2 4 1   3     0   6   60 76                 136
1131891 1131891 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2017   grade_8 120 2 12 0   3     0   1   70 68                       138 120 2 12 0   3     0   1   70 68                 138
1132965 1132965 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 06 08 2017   grade_8 120 2 3 0   2     0   4   72 59                       131 120 2 3 0   2     0   4   72 59                 131
1124421 1124421 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_8 121 2 3 0   2     1   3   64 68                       132 121 2 3 0   2     1   3   64 68                 132
1127031 1127031 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2017   grade_8 121 3 8 0   2     0   5   67 72                       139 121 3 8 0   2     0   5   67 72                 139
1131766 1131766 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2017   grade_8 121 16 41 0   16     1   23   100 118                       218 121 16 41 0   16     1   23   100 118                 218
1130336 1130336 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2017   grade_8 122 11 9 0   25     0   14   88 93                       181 122 11 9 0   25     0   14   88 93                 181
1130724 1130724 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2017   grade_8 122 8 13 0   8     0   3   75 79                       154 122 8 13 0   8     0   3   75 79                 154
1132929 1132929 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2017   grade_8 122 1 6 0   0     0   2   63 68                       131 122 1 6 0   0     0   2   63 68                 131
1129043 1129043 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2017   grade_8 123 0 9 0   24     0   4   85 75                       160 123 0 9 0   24     0   4   85 75                 160
1132029 1132029 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2017   grade_8 123 2 6 0   0     0   5   77 59                       136 123 2 6 0   0     0   5   77 59                 136
1132224 1132224 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2017   grade_8 123 2 3 0   6     0   6   75 65                       140 123 2 3 0   6     0   6   75 65                 140
1124800 1124800 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2017   grade_8 125 16 40 0   8     1   14   113 91                       204 125 16 40 0   8     1   14   113 91                 204
1126829 1126829 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2017   grade_8 125 11 7 0   10     1   4   79 79                       158 125 11 7 0   10     1   4   79 79                 158
1127958 1127958 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2017   grade_8 125 2 11 0   5     0   3   77 69                       146 125 2 11 0   5     0   3   77 69                 146
1132308 1132308 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2017   grade_8 125 0 1 0   4     0   1   62 69                       131 125 0 1 0   4     0   1   62 69                 131
1124246 1124246 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_8 126 3 0 0   5     0   0   68 66                       134 126 3 0 0   5     0   0   68 66                 134
1130354 1130354 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_8 126 1 3 2   2     0   4   79 59                       138 126 1 3 2   2     0   4   79 59                 138
1127539 1127539 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2017   grade_8 127 13 14 0   51     0   12   96 121                       217 127 13 14 0   51     0   12   96 121                 217
1132263 1132263 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2017   grade_8 128 1 5 1   2     0   1   60 78                       138 128 1 5 1   2     0   1   60 78                 138
1128984 1128984 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2017   grade_8 13 3 36 0   2     0   1   31 24                       55 13 3 36 0   2     0   1   31 24                 55
1132898 1132898 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2017   grade_8 130 4 6 0   3     0   2   78 67                       145 130 4 6 0   3     0   2   78 67                 145
1126058 1126058 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_8 133 13 10 1   99     0   15   129 142                       271 133 13 10 1   99     0   15   129 142                 271
1130720 1130720 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_8 133 17 13 0   5     0   1   88 81                       169 133 17 13 0   5     0   1   88 81                 169

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