enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
934311 934311 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2016   grade_8 133 1 0 0   0     0   0   67 67                       134 133 1 0 0   0     0   0   67 67                 134
935065 935065 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_8 8 2 0 0   0     0   1   6 5                       11 8 2 0 0   0     0   1   6 5                 11
937518 937518 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No 2 06 08 2016   grade_8 185 2 0 0   5     1   2   93 102                       195 185 2 0 0   5     1   2   93 102                 195
937705 937705 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No 2 07 08 2016   grade_8 236 1 0 1   5     1   2   126 120                       246 236 1 0 1   5     1   2   126 120                 246
938293 938293 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No 2 07 08 2016   grade_8 218 8 0 0   3     0   5   122 112                       234 218 8 0 0   3     0   5   122 112                 234
940256 940256 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2016   grade_8 34 0 0 0   1     0   2   16 21                       37 34 0 0 0   1     0   2   16 21                 37
940542 940542 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2016   grade_8 33 1 0 0   2     0   0   16 20                       36 33 1 0 0   2     0   0   16 20                 36
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
940636 940636 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2016   grade_8 29 0 0 0   1     0   0   13 17                       30 29 0 0 0   1     0   0   13 17                 30
940687 940687 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2016   grade_8 30 12 0 0   2     0   1   24 21                       45 30 12 0 0   2     0   1   24 21                 45
940739 940739 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 11 2016   grade_8 5 1 0 0   4     0   1   2 9                       11 5 1 0 0   4     0   1   2 9                 11
941732 941732 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2016   grade_8 35 0 0 1   1     0   1   23 15                       38 35 0 0 1   1     0   1   23 15                 38
941777 941777 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2016   grade_8 48 0 0 0   0     0   2   24 26                       50 48 0 0 0   0     0   2   24 26                 50
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
934468 934468 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_8 15 0 1 0   0     0   0   7 9                       16 15 0 1 0   0     0   0   7 9                 16
935199 935199 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No 2 06 08 2016   grade_8 137 0 1 1   7     0   5   76 75                       151 137 0 1 1   7     0   5   76 75                 151
935694 935694 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No 2 06 08 2016   grade_8 75 2 1 0   1     0   1   40 40                       80 75 2 1 0   1     0   1   40 40                 80
937873 937873 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2016   grade_8 2 7 1 0   0     0   1   4 7                       11 2 7 1 0   0     0   1   4 7                 11
938031 938031 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No 2 06 08 2016   grade_8 138 5 1 0   6     0   3   84 69                       153 138 5 1 0   6     0   3   84 69                 153
938104 938104 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2016   grade_8 20 0 1 0   0     0   0   11 10                       21 20 0 1 0   0     0   0   11 10                 21
938144 938144 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No 2 06 08 2016   grade_8 73 2 1 0   2     0   0   39 39                       78 73 2 1 0   2     0   0   39 39                 78
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
939471 939471 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2016   grade_8 97 5 1 0   1     0   5   54 55                       109 97 5 1 0   1     0   5   54 55                 109
940341 940341 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2016   grade_8 70 3 1 0   2     0   4   42 38                       80 70 3 1 0   2     0   4   42 38                 80
940459 940459 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_8 38 1 1 0   6     0   1   20 27                       47 38 1 1 0   6     0   1   20 27                 47
941088 941088 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2016   grade_8 168 8 1 1   8     0   7   88 105                       193 168 8 1 1   8     0   7   88 105                 193
941162 941162 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2016   grade_8 193 2 1 0   9     1   0   105 101                       206 193 2 1 0   9     1   0   105 101                 206
941232 941232 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Thornton Burgess   Regular School No 2 05 08 2016   grade_8 67 0 1 0   2     0   5   41 34                       75 67 0 1 0   2     0   5   41 34                 75
941546 941546 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No 3 07 12 2016   grade_8 72 0 1 0   0     0   2   35 40                       75 72 0 1 0   0     0   2   35 40                 75
941601 941601 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No 2 06 08 2016   grade_8 299 9 1 0   5     1   2   160 157                       317 299 9 1 0   5     1   2   160 157                 317
941648 941648 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No 3 07 12 2016   grade_8 133 2 1 0   1     0   1   83 55                       138 133 2 1 0   1     0   1   83 55                 138
932894 932894 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 08 12 2016   grade_8 159 3 10 1   6     0   3   84 98                       182 159 3 10 1   6     0   3   84 98                 182
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
933338 933338 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2016   grade_8 8 3 10 0   3     0   0   12 12                       24 8 3 10 0   3     0   0   12 12                 24
933533 933533 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2016   grade_8 6 8 10 0   1     0   0   12 13                       25 6 8 10 0   1     0   0   12 13                 25
933631 933631 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_8 3 4 10 0   0     0   0   8 9                       17 3 4 10 0   0     0   0   8 9                 17
934121 934121 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2016   grade_8 38 2 10 0   12     0   3   39 26                       65 38 2 10 0   12     0   3   39 26                 65
934260 934260 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2016   grade_8 40 24 10 1   14     0   6   45 50                       95 40 24 10 1   14     0   6   45 50                 95
934345 934345 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2016   grade_8 190 4 10 0   29     1   3   121 116                       237 190 4 10 0   29     1   3   121 116                 237
936005 936005 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2016   grade_8 146 7 10 0   120     0   15   147 151                       298 146 7 10 0   120     0   15   147 151                 298
936431 936431 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No 1 KG 08 2016   grade_8 27 10 10 0   6     0   2   30 25                       55 27 10 10 0   6     0   2   30 25                 55
936774 936774 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No 2 06 08 2016   grade_8 229 3 10 6   0     0   7   129 126                       255 229 3 10 6   0     0   7   129 126                 255
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
938339 938339 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon Middle   Regular School No 2 06 08 2016   grade_8 153 17 10 0   66     0   9   139 116                       255 153 17 10 0   66     0   9   139 116                 255
938657 938657 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   grade_8 4 8 10 0   0     0   0   7 15                       22 4 8 10 0   0     0   0   7 15                 22
939771 939771 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No 2 06 08 2016   grade_8 238 3 10 0   9     0   2   137 125                       262 238 3 10 0   9     0   2   137 125                 262
939900 939900 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No 2 06 08 2016   grade_8 138 10 10 0   9     0   1   83 85                       168 138 10 10 0   9     0   1   83 85                 168
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
940612 940612 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes 3 07 12 2016   grade_8 46 7 10 0   2     0   3   24 44                       68 46 7 10 0   2     0   3   24 44                 68
941472 941472 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2016   grade_8 137 2 10 1   1     0   3   85 69                       154 137 2 10 1   1     0   3   85 69                 154
942030 942030 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_8 64 3 10 0   1     0   7   35 50                       85 64 3 10 0   1     0   7   35 50                 85
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
937109 937109 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2016   grade_8 218 28 101 1   1     2   18   192 177                       369 218 28 101 1   1     2   18   192 177                 369
940173 940173 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2016   grade_8 94 55 101 1   11     0   6   129 139                       268 94 55 101 1   11     0   6   129 139                 268
935827 935827 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2016   grade_8 15 4 103 0   4     0   0   57 69                       126 15 4 103 0   4     0   0   57 69                 126
938806 938806 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle International Baccalaureate   Regular School No 2 06 08 2016   grade_8 22 23 107 0   2     0   0   74 80                       154 22 23 107 0   2     0   0   74 80                 154
934371 934371 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2016   grade_8 5 11 108 0   3     0   0   65 62                       127 5 11 108 0   3     0   0   65 62                 127
934254 934254 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No 2 06 08 2016   grade_8 26 32 11 1   6     0   5   39 42                       81 26 32 11 1   6     0   5   39 42                 81
934409 934409 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2016   grade_8 5 0 11 0   0     0   0   13 3                       16 5 0 11 0   0     0   0   13 3                 16
935006 935006 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2016   grade_8 239 15 11 1   8     0   16   147 143                       290 239 15 11 1   8     0   16   147 143                 290
935296 935296 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2016   grade_8 208 2 11 0   34     0   3   147 111                       258 208 2 11 0   34     0   3   147 111                 258
937244 937244 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No 2 06 08 2016   grade_8 133 19 11 0   26     0   12   112 89                       201 133 19 11 0   26     0   12   112 89                 201
938438 938438 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No 1 PK 08 2016   grade_8 21 7 11 0   8     0   1   31 17                       48 21 7 11 0   8     0   1   31 17                 48
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
939081 939081 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No 2 07 08 2016   grade_8 290 3 11 0   7     1   1   169 144                       313 290 3 11 0   7     1   1   169 144                 313
939443 939443 MA Worcester   school 2512600 321   Westborough 251260002604 3210305 Sarah W Gibbons Middle   Regular School No 2 07 08 2016   grade_8 181 6 11 0   61     0   7   148 118                       266 181 6 11 0   61     0   7   148 118                 266
940589 940589 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2016   grade_8 65 4 11 0   1     0   1   39 43                       82 65 4 11 0   1     0   1   39 43                 82
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
940896 940896 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2016   grade_8 96 10 11 0   6     0   6   74 55                       129 96 10 11 0   6     0   6   74 55                 129
942017 942017 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_8 54 10 11 1   2     0   2   39 41                       80 54 10 11 1   2     0   2   39 41                 80
935779 935779 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2016   grade_8 8 1 114 0   2     0   0   65 60                       125 8 1 114 0   2     0   0   65 60                 125
934375 934375 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2016   grade_8 7 4 116 0   3     0   3   65 68                       133 7 4 116 0   3     0   3   65 68                 133
934446 934446 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_8 158 6 116 0   4     0   7   150 141                       291 158 6 116 0   4     0   7   150 141                 291
935797 935797 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2016   grade_8 4 3 119 1   0     0   0   68 59                       127 4 3 119 1   0     0   0   68 59                 127
932587 932587 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No 2 07 08 2016   grade_8 270 3 12 0   7     0   4   150 146                       296 270 3 12 0   7     0   4   150 146                 296
932670 932670 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2016   grade_8 159 3 12 0   14     0   6   105 89                       194 159 3 12 0   14     0   6   105 89                 194
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
934779 934779 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2016   grade_8 243 12 12 1   5     1   4   142 136                       278 243 12 12 1   5     1   4   142 136                 278
936108 936108 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No 1 PK 08 2016   grade_8 32 4 12 0   7     0   0   24 31                       55 32 4 12 0   7     0   0   24 31                 55
936596 936596 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No 3 08 12 2016   grade_8 96 1 12 0   5     0   3   62 55                       117 96 1 12 0   5     0   3   62 55                 117
936648 936648 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 John J. McGlynn Middle School   Regular School No 2 06 08 2016   grade_8 85 31 12 0   17     0   3   78 70                       148 85 31 12 0   17     0   3   78 70                 148
936710 936710 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No 2 06 08 2016   grade_8 227 14 12 0   19     0   13   133 152                       285 227 14 12 0   19     0   13   133 152                 285
936816 936816 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2016   grade_8 130 0 12 0   0     0   2   64 80                       144 130 0 12 0   0     0   2   64 80                 144
937439 937439 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2016   grade_8 153 0 12 0   1     0   8   85 89                       174 153 0 12 0   1     0   8   85 89                 174
939164 939164 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2016   grade_8 264 8 12 0   10     0   9   151 152                       303 264 8 12 0   10     0   9   151 152                 303

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