Data source: Big Local News · About: Big Local

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

View and edit SQL

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 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 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 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 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 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 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 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 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 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 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 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_8 * * * *   *     *   *   * *                       1                                             1
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
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
934640 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2016   grade_8 136 0 2 0   3     1   4   65 81                       146 136 0 2 0   3     1   4   65 81                 146
934973 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No 1 01 08 2016   grade_8 6 1 2 0   0     0   2   9 2                       11 6 1 2 0   0     0   2   9 2                 11
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
935384 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2016   grade_8 195 0 2 0   3     0   0   104 96                       200 195 0 2 0   3     0   0   104 96                 200
935413 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2016   grade_8 31 0 2 0   0     0   2   19 16                       35 31 0 2 0   0     0   2   19 16                 35
935639 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2016   grade_8 82 1 2 0   3     0   0   40 48                       88 82 1 2 0   3     0   0   40 48                 88
935653 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No 2 06 08 2016   grade_8 253 1 2 1   19     0   3   145 134                       279 253 1 2 1   19     0   3   145 134                 279
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
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
936880 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2016   grade_8 87 0 2 0   0     1   2   42 50                       92 87 0 2 0   0     1   2   42 50                 92
937453 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2016   grade_8 51 0 2 0   1     0   1   31 24                       55 51 0 2 0   1     0   1   31 24                 55
937945 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2016   grade_8 63 9 2 0   16     1   4   49 46                       95 63 9 2 0   16     1   4   49 46                 95
939558 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No 2 06 08 2016   grade_8 180 2 2 0   55     0   6   132 113                       245 180 2 2 0   55     0   6   132 113                 245
940263 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2016   grade_8 49 11 2 0   1     0   2   30 35                       65 49 11 2 0   1     0   2   30 35                 65
940476 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_8 15 0 2 0   1     0   5   11 12                       23 15 0 2 0   1     0   5   11 12                 23
941241 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   grade_8 136 0 2 0   0     0   4   70 72                       142 136 0 2 0   0     0   4   70 72                 142
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
941427 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2016   grade_8 70 1 2 0   1     0   2   38 38                       76 70 1 2 0   1     0   2   38 38                 76
941430 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2016   grade_8 82 0 2 0   1     0   2   43 44                       87 82 0 2 0   1     0   2   43 44                 87
941768 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2016   grade_8 56 3 2 0   2     0   0   32 31                       63 56 3 2 0   2     0   0   32 31                 63
941839 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2016   grade_8 166 4 2 0   5     2   4   93 90                       183 166 4 2 0   5     2   4   93 90                 183
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
934708 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2016   grade_8 178 8 3 0   1     0   5   85 110                       195 178 8 3 0   1     0   5   85 110                 195
934792 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2016   grade_8 35 0 3 0   0     0   1   21 18                       39 35 0 3 0   0     0   1   21 18                 39
935196 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2016   grade_8 140 0 3 0   8     2   7   81 79                       160 140 0 3 0   8     2   7   81 79                 160
935351 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2016   grade_8 36 0 3 0   2     1   0   23 19                       42 36 0 3 0   2     1   0   23 19                 42
935399 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_8 79 1 3 0   9     0   1   42 51                       93 79 1 3 0   9     0   1   42 51                 93
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
936400 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No 2 05 08 2016   grade_8 148 7 3 0   4     0   4   83 83                       166 148 7 3 0   4     0   4   83 83                 166
937942 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2016   grade_8 50 2 3 0   93     0   1   79 70                       149 50 2 3 0   93     0   1   79 70                 149
937948 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_8 130 10 3 0   74     0   2   95 124                       219 130 10 3 0   74     0   2   95 124                 219
938034 MA Middlesex   school 2509990 246   Reading 250999001612 2460310 Walter S Parker Middle   Regular School No 2 06 08 2016   grade_8 166 2 3 1   12     0   0   81 103                       184 166 2 3 1   12     0   0   81 103                 184
938219 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No 2 07 08 2016   grade_8 243 5 3 1   8     0   1   135 126                       261 243 5 3 1   8     0   1   135 126                 261
939555 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No 2 06 08 2016   grade_8 149 0 3 0   40     0   2   101 93                       194 149 0 3 0   40     0   2   101 93                 194
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
940640 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2016   grade_8 81 0 3 1   3     0   1   38 51                       89 81 0 3 1   3     0   1   38 51                 89
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
940847 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No 2 06 08 2016   grade_8 176 3 3 0   2     0   3   96 91                       187 176 3 3 0   2     0   3   96 91                 187
940960 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No 2 05 08 2016   grade_8 149 3 3 0   5     0   8   88 80                       168 149 3 3 0   5     0   8   88 80                 168
940962 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No 2 07 08 2016   grade_8 226 6 3 0   3     0   1   118 121                       239 226 6 3 0   3     0   1   118 121                 239
941044 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2016   grade_8 84 1 3 0   3     0   1   46 46                       92 84 1 3 0   3     0   1   46 46                 92
941115 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2016   grade_8 251 3 3 0   4     1   2   153 111                       264 251 3 3 0   4     1   2   153 111                 264
941140 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Junior High School   Regular School No 2 07 08 2016   grade_8 72 0 3 0   0     0   3   31 47                       78 72 0 3 0   0     0   3   31 47                 78
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
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
941424 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2016   grade_8 78 0 3 0   2     0   1   41 43                       84 78 0 3 0   2     0   1   41 43                 84
941842 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2016   grade_8 131 3 3 0   2     0   2   75 66                       141 131 3 3 0   2     0   2   75 66                 141
932942 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2016   grade_8 93 2 4 0   0     0   1   49 51                       100 93 2 4 0   0     0   1   49 51                 100
933416 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_8 8 4 4 0   0     0   0   9 7                       16 8 4 4 0   0     0   0   9 7                 16
933843 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2016   grade_8 166 3 4 0   5     0   7   90 95                       185 166 3 4 0   5     0   7   90 95                 185
934055 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_8 42 3 4 0   24     0   6   37 42                       79 42 3 4 0   24     0   6   37 42                 79
934093 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2016   grade_8 31 4 4 0   5     0   6   25 25                       50 31 4 4 0   5     0   6   25 25                 50
934301 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2016   grade_8 59 2 4 0   9     0   6   34 46                       80 59 2 4 0   9     0   6   34 46                 80

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