enrollments

Data source: Big Local News · About: Big Local

493 rows where grade = "grade_8", state = "MA" and year = 2016 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 493 ✖

grade ✖

  • grade_8 · 493 ✖
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
932585 932585 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 04 08 2016   grade_8 * * * *   *     *   *   2 1                       3                         2 1                 3
932899 932899 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Paul J. Primavera Jr./Sr. High School   Alternative Education School No 3 07 12 2016   grade_8 * * * *   *     *   *   1 2                       3                         1 2                 3
934836 934836 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 KG 12 2016   grade_8 * * * *   *     *   *   3 1                       4                         3 1                 4
935433 935433 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2016   grade_8 * * * *   *     *   *   4 1                       5                         4 1                 5
935455 935455 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_8 * * * *   *     *   *   2 2                       4                         2 2                 4
936380 936380 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 08 12 2016   grade_8 * * * *   *     *   *   1 3                       4                         1 3                 4
936799 936799 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 08 2016   grade_8 * * * *   *     *   *   1 1                       2                         1 1                 2
936801 936801 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2016   grade_8 * * * *   *     *   *   3 1                       4                         3 1                 4
937118 937118 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No 4 06 12 2016   grade_8 * * * *   *     *   *   2 2                       4                         2 2                 4
937587 937587 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2016   grade_8 * * * *   *     *   *   1 *                       1                         1                   1
939287 939287 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_8 * * * *   *     *   *   * *                       1                                             1
939291 939291 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham Cooperative Junior/Senior High School   Regular School No 3 07 12 2016   grade_8 * * * *   *     *   *   3 1                       4                         3 1                 4
939786 939786 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative Education School No 4 06 12 2016   grade_8 * * * *   *     *   *   1 3                       4                         1 3                 4
933376 933376 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   grade_8 0 8 18 0   0     0   0   12 14                       26 0 8 18 0   0     0   0   12 14                 26
933621 933621 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_8 0 31 13 0   0     0   0   31 13                       44 0 31 13 0   0     0   0   31 13                 44
933660 933660 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2016   grade_8 0 54 100 0   0     0   5   81 78                       159 0 54 100 0   0     0   5   81 78                 159
933810 933810 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2016   grade_8 0 0 27 0   0     0   0   11 16                       27 0 0 27 0   0     0   0   11 16                 27
933818 933818 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_8 0 5 5 0   1     0   0   5 6                       11 0 5 5 0   1     0   0   5 6                 11
933824 933824 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative Education School No 3 08 12 2016   grade_8 0 4 3 0   0     0   0   4 3                       7 0 4 3 0   0     0   0   4 3                 7
935587 935587 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2016   grade_8 0 0 47 0   0     0   0   20 27                       47 0 0 47 0   0     0   0   20 27                 47
940286 940286 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 2 06 08 2016   grade_8 0 62 12 0   0     0   2   39 37                       76 0 62 12 0   0     0   2   39 37                 76
940316 940316 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2016   grade_8 0 41 7 0   0     0   0   20 28                       48 0 41 7 0   0     0   0   20 28                 48
940382 940382 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2016   grade_8 0 8 12 0   0     0   0   8 12                       20 0 8 12 0   0     0   0   8 12                 20
940414 940414 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2016   grade_8 0 20 10 0   2     0   0   15 17                       32 0 20 10 0   2     0   0   15 17                 32
940499 940499 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_8 0 0 62 0   0     0   0   27 35                       62 0 0 62 0   0     0   0   27 35                 62
940537 940537 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes 1 KG 08 2016   grade_8 0 46 23 0   0     0   0   37 32                       69 0 46 23 0   0     0   0   37 32                 69
940598 940598 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2016   grade_8 0 35 9 0   0     0   0   24 20                       44 0 35 9 0   0     0   0   24 20                 44
933075 933075 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   grade_8 1 20 29 0   1     1   2   22 32                       54 1 20 29 0   1     1   2   22 32                 54
933149 933149 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 11 2016   grade_8 1 32 10 0   0     0   3   24 22                       46 1 32 10 0   0     0   3   24 22                 46
933171 933171 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2016   grade_8 1 3 54 0   0     0   0   31 27                       58 1 3 54 0   0     0   0   31 27                 58
933311 933311 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2016   grade_8 1 0 16 0   0     0   0   10 7                       17 1 0 16 0   0     0   0   10 7                 17
933321 933321 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2016   grade_8 1 42 16 0   2     0   4   42 23                       65 1 42 16 0   2     0   4   42 23                 65
933426 933426 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2016   grade_8 1 32 46 0   1     1   2   30 53                       83 1 32 46 0   1     1   2   30 53                 83
933506 933506 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_8 1 9 15 1   0     0   0   18 8                       26 1 9 15 1   0     0   0   18 8                 26
933594 933594 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2016   grade_8 1 13 7 0   0     0   2   10 13                       23 1 13 7 0   0     0   2   10 13                 23
933603 933603 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2016   grade_8 1 20 8 1   0     0   0   16 14                       30 1 20 8 1   0     0   0   16 14                 30
933992 933992 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 4 06 12 2016   grade_8 1 5 1 0   0     0   0   5 2                       7 1 5 1 0   0     0   0   5 2                 7
934002 934002 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2016   grade_8 1 5 1 0   0     0   0   6 1                       7 1 5 1 0   0     0   0   6 1                 7
936186 936186 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No 3 08 12 2016   grade_8 1 1 4 0   1     0   0   6 1                       7 1 1 4 0   1     0   0   6 1                 7
938787 938787 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2016   grade_8 1 9 15 0   0     0   0   15 10                       25 1 9 15 0   0     0   0   15 10                 25
940352 940352 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2016   grade_8 1 44 17 1   2     1   5   30 41                       71 1 44 17 1   2     1   5   30 41                 71
940746 940746 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes 2 05 08 2016   grade_8 1 14 41 0   1     0   5   31 31                       62 1 14 41 0   1     0   5   31 31                 62
934379 934379 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2016   grade_8 10 18 124 1   0     0   0   83 70                       153 10 18 124 1   0     0   0   83 70                 153
935563 935563 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2016   grade_8 10 1 23 0   1     0   1   18 18                       36 10 1 23 0   1     0   1   18 18                 36
940250 940250 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2016   grade_8 10 51 12 0   1     0   2   37 39                       76 10 51 12 0   1     0   2   37 39                 76
939363 939363 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No 2 05 08 2016   grade_8 100 5 17 0   4     0   7   68 65                       133 100 5 17 0   4     0   7   68 65                 133
935946 935946 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No 2 06 08 2016   grade_8 101 13 33 0   1     0   6   76 78                       154 101 13 33 0   1     0   6   76 78                 154
936645 936645 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No 2 06 08 2016   grade_8 101 19 9 1   8     0   5   69 74                       143 101 19 9 1   8     0   5   69 74                 143
936724 936724 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2016   grade_8 101 2 17 0   5     1   3   63 66                       129 101 2 17 0   5     1   3   63 66                 129
940328 940328 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2016   grade_8 101 5 3 0   29     0   8   84 62                       146 101 5 3 0   29     0   8   84 62                 146
938201 938201 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2016   grade_8 102 12 78 0   3     0   8   107 96                       203 102 12 78 0   3     0   8   107 96                 203
941790 941790 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2016   grade_8 102 0 4 0   3     0   0   58 51                       109 102 0 4 0   3     0   0   58 51                 109
936570 936570 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2016   grade_8 103 6 4 6   3     0   5   65 62                       127 103 6 4 6   3     0   5   65 62                 127
937106 937106 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2016   grade_8 103 55 88 3   5     2   19   142 133                       275 103 55 88 3   5     2   19   142 133                 275
940819 940819 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_8 103 8 3 0   0     0   0   57 57                       114 103 8 3 0   0     0   0   57 57                 114
940874 940874 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2016   grade_8 104 2 11 0   1     0   1   60 59                       119 104 2 11 0   1     0   1   60 59                 119
941121 941121 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2016   grade_8 104 1 5 0   6     0   3   72 47                       119 104 1 5 0   6     0   3   72 47                 119
936236 936236 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No 3 08 12 2016   grade_8 105 4 2 0   2     0   2   63 52                       115 105 4 2 0   2     0   2   63 52                 115
941396 941396 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2016   grade_8 105 2 3 0   0     0   1   53 58                       111 105 2 3 0   0     0   1   53 58                 111
935440 935440 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2016   grade_8 106 5 16 0   1     0   0   63 65                       128 106 5 16 0   1     0   0   63 65                 128
932779 932779 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_8 107 6 27 2   5     1   4   71 81                       152 107 6 27 2   5     1   4   71 81                 152
940181 940181 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_8 107 63 173 0   49     0   14   196 210                       406 107 63 173 0   49     0   14   196 210                 406
932560 932560 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_8 108 2 0 0   1     0   0   55 56                       111 108 2 0 0   1     0   0   55 56                 111
935149 935149 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2016   grade_8 109 9 71 0   18     1   10   115 103                       218 109 9 71 0   18     1   10   115 103                 218
936831 936831 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2016   grade_8 109 2 6 0   3     0   1   63 58                       121 109 2 6 0   3     0   1   63 58                 121
937235 937235 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No 2 06 08 2016   grade_8 109 18 10 0   23     0   9   80 89                       169 109 18 10 0   23     0   9   80 89                 169
933287 933287 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2016   grade_8 11 78 95 0   20     0   3   118 89                       207 11 78 95 0   20     0   3   118 89                 207
934178 934178 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2016   grade_8 11 3 13 0   1     0   3   14 17                       31 11 3 13 0   1     0   3   14 17                 31
937610 937610 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No 3 08 12 2016   grade_8 110 4 6 0   1     0   1   77 45                       122 110 4 6 0   1     0   1   77 45                 122
939208 939208 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No 2 06 08 2016   grade_8 110 2 4 1   8     0   1   60 66                       126 110 2 4 1   8     0   1   60 66                 126
934957 934957 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2016   grade_8 111 14 50 2   16     0   10   103 100                       203 111 14 50 2   16     0   10   103 100                 203
938963 938963 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2016   grade_8 113 1 1 0   0     0   3   50 68                       118 113 1 1 0   0     0   3   50 68                 118
937772 937772 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No 2 06 08 2016   grade_8 114 18 15 0   2     0   10   93 66                       159 114 18 15 0   2     0   10   93 66                 159
936071 936071 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2016   grade_8 116 2 3 0   15     0   4   68 72                       140 116 2 3 0   15     0   4   68 72                 140
941281 941281 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No 2 06 08 2016   grade_8 116 0 2 0   2     0   0   53 67                       120 116 0 2 0   2     0   0   53 67                 120
939600 939600 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Junior High School   Regular School No 2 07 08 2016   grade_8 118 0 4 1   2     0   3   70 58                       128 118 0 4 1   2     0   3   70 58                 128
934493 934493 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_8 119 7 2 0   7     0   0   63 72                       135 119 7 2 0   7     0   0   63 72                 135
933784 933784 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_8 12 7 120 1   3     0   0   84 59                       143 12 7 120 1   3     0   0   84 59                 143
940551 940551 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_8 12 1 0 0   0     0   2   7 8                       15 12 1 0 0   0     0   2   7 8                 15
935233 935233 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 07 08 2016   grade_8 120 0 2 0   0     0   4   62 64                       126 120 0 2 0   0     0   4   62 64                 126
935143 935143 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2016   grade_8 121 6 33 0   3     0   6   79 90                       169 121 6 33 0   3     0   6   79 90                 169
936042 936042 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2016   grade_8 121 1 2 0   4     1   3   60 72                       132 121 1 2 0   4     1   3   60 72                 132
940999 940999 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No 2 06 08 2016   grade_8 121 0 7 0   0     0   2   71 59                       130 121 0 7 0   0     0   2   71 59                 130
936008 936008 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2016   grade_8 123 13 5 1   97     0   14   130 123                       253 123 13 5 1   97     0   14   130 123                 253
941333 941333 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2016   grade_8 123 6 6 2   4     0   4   73 72                       145 123 6 6 2   4     0   4   73 72                 145
937595 937595 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2016   grade_8 124 2 17 0   1     0   4   70 78                       148 124 2 17 0   1     0   4   70 78                 148
939132 939132 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2016   grade_8 124 1 4 2   3     0   6   81 59                       140 124 1 4 2   3     0   6   81 59                 140
941786 941786 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2016   grade_8 124 2 9 0   1     0   2   67 71                       138 124 2 9 0   1     0   2   67 71                 138
932860 932860 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No 2 06 08 2016   grade_8 125 14 8 0   22     0   5   86 88                       174 125 14 8 0   22     0   5   86 88                 174
937112 937112 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2016   grade_8 125 27 94 1   2     2   7   131 127                       258 125 27 94 1   2     2   7   131 127                 258
939586 939586 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No 2 06 08 2016   grade_8 125 12 4 2   26     0   4   94 79                       173 125 12 4 2   26     0   4   94 79                 173
938537 938537 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2016   grade_8 126 2 11 0   2     1   0   65 77                       142 126 2 11 0   2     1   0   65 77                 142
941463 941463 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2016   grade_8 126 1 6 0   0     0   5   67 71                       138 126 1 6 0   0     0   5   67 71                 138
938507 938507 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No 2 06 08 2016   grade_8 128 1 9 0   18     1   6   83 80                       163 128 1 9 0   18     1   6   83 80                 163
939324 939324 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2016   grade_8 128 4 17 3   8     0   8   78 90                       168 128 4 17 3   8     0   8   78 90                 168
941211 941211 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No 2 06 08 2016   grade_8 128 0 3 0   4     0   0   52 83                       135 128 0 3 0   4     0   0   52 83                 135
933399 933399 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2016   grade_8 13 38 12 1   24     0   3   44 47                       91 13 38 12 1   24     0   3   44 47                 91
933753 933753 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2016   grade_8 13 38 57 1   28     0   5   63 79                       142 13 38 57 1   28     0   5   63 79                 142
935606 935606 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2016   grade_8 13 0 45 0   0     0   2   30 30                       60 13 0 45 0   0     0   2   30 30                 60
938457 938457 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2016   grade_8 13 3 44 0   0     0   0   27 33                       60 13 3 44 0   0     0   0   27 33                 60

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