Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 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
2041289 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_8 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2042370 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_8 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042772 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_8 * * * *   *     *   *   2 *                       2.0                         2                   2
2043455 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_8 * * * *   *     *   *   5 *                       5.0                         5                   5
2043676 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2045508 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2019   grade_8 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2045829 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge Academy   Alternative School No High 08 12 2019   grade_8 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2040175 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_8 6 0 0 0   0     0   0   1 4                       6.0 6 0 0 0   0     0   0   1 4                 6
2040218 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_8 89 0 0 0   0     0   6   48 47                       95.0 89 0 0 0   0     0   6   48 47                 95
2041760 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_8 15 0 0 0   0     0   0   6 9                       15.0 15 0 0 0   0     0   0   6 9                 15
2044818 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No Middle 06 08 2019   grade_8 162 0 0 1   3     0   3   74 95                       169.0 162 0 0 1   3     0   3   74 95                 169
2045406 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_8 11 0 0 0   0     0   1   6 6                       12.0 11 0 0 0   0     0   1   6 6                 12
2048247 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2019   grade_8 153 6 0 0   3     1   16   94 85                       179.0 153 6 0 0   3     1   16   94 85                 179
2048576 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2019   grade_8 122 0 0 0   3     0   3   73 55                       128.0 122 0 0 0   3     0   3   73 55                 128
2039834 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_8 108 1 1 0   0     0   1   52 59                       111.0 108 1 1 0   0     0   1   52 59                 111
2040696 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_8 9 2 1 0   0     0   0   4 8                       12.0 9 2 1 0   0     0   0   4 8                 12
2041590 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   grade_8 49 2 1 0   15     0   4   34 37                       71.0 49 2 1 0   15     0   4   34 37                 71
2041785 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_8 118 3 1 0   4     0   1   64 63                       127.0 118 3 1 0   4     0   1   64 63                 127
2042542 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_8 105 3 1 0   1     0   1   62 49                       111.0 105 3 1 0   1     0   1   62 49                 111
2043008 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2019   grade_8 67 0 1 0   0     0   0   43 25                       68.0 67 0 1 0   0     0   0   43 25                 68
2044172 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2019   grade_8 48 0 1 1   0     0   0   20 30                       50.0 48 0 1 1   0     0   0   20 30                 50
2045006 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2019   grade_8 235 3 1 0   4     0   0   129 114                       243.0 235 3 1 0   4     0   0   129 114                 243
2046859 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2019   grade_8 133 1 1 0   58     0   1   102 92                       194.0 133 1 1 0   58     0   1   102 92                 194
2046862 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2019   grade_8 175 0 1 0   74     0   4   144 110                       254.0 175 0 1 0   74     0   4   144 110                 254
2047680 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_8 0 17 1 0   0     0   0   10 8                       18.0 0 17 1 0   0     0   0   10 8                 18
2047781 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2019   grade_8 27 0 1 0   0     0   2   18 12                       30.0 27 0 1 0   0     0   2   18 12                 30
2047921 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_8 24 1 1 0   0     0   2   11 17                       28.0 24 1 1 0   0     0   2   11 17                 28
2048111 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   grade_8 85 2 1 0   0     0   1   49 40                       89.0 85 2 1 0   0     0   1   49 40                 89
2048681 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2019   grade_8 53 0 1 0   0     0   0   21 33                       54.0 53 0 1 0   0     0   0   21 33                 54
2048769 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2019   grade_8 99 0 1 0   0     0   2   45 57                       102.0 99 0 1 0   0     0   2   45 57                 102
2048851 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2019   grade_8 66 0 1 0   0     0   4   36 35                       71.0 66 0 1 0   0     0   4   36 35                 71
2049030 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_8 45 2 1 1   2     0   2   23 30                       53.0 45 2 1 1   2     0   2   23 30                 53
2040299 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_8 181 9 10 0   12     1   4   107 110                       217.0 181 9 10 0   12     1   4   107 110                 217
2040874 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   grade_8 0 16 10 0   0     0   0   16 10                       26.0 0 16 10 0   0     0   0   16 10                 26
2040881 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_8 1 12 10 0   0     0   1   12 12                       24.0 1 12 10 0   0     0   1   12 12                 24
2041353 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   grade_8 42 9 10 0   9     0   12   45 37                       82.0 42 9 10 0   9     0   12   45 37                 82
2041883 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2019   grade_8 275 7 10 0   0     0   20   183 129                       312.0 275 7 10 0   0     0   20   183 129                 312
2043177 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2019   grade_8 94 5 10 0   2     0   7   57 61                       118.0 94 5 10 0   2     0   7   57 61                 118
2043291 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_8 149 9 10 0   137     0   23   160 168                       328.0 149 9 10 0   137     0   23   160 168                 328
2043893 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2019   grade_8 74 1 10 0   2     0   4   48 43                       91.0 74 1 10 0   2     0   4   48 43                 91
2044068 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2019   grade_8 218 6 10 5   6     0   12   118 139                       257.0 218 6 10 5   6     0   12   118 139                 257
2044109 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2019   grade_8 125 4 10 0   1     0   2   60 82                       142.0 125 4 10 0   1     0   2   60 82                 142
2045245 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2019   grade_8 80 11 10 1   18     1   3   54 70                       124.0 80 11 10 1   18     1   3   54 70                 124
2046259 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2019   grade_8 232 8 10 0   27     0   21   137 161                       298.0 232 8 10 0   27     0   21   137 161                 298
2046412 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_8 19 2 10 0   0     0   1   20 12                       32.0 19 2 10 0   0     0   1   20 12                 32
2046979 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2019   grade_8 204 11 10 0   19     0   11   121 134                       255.0 204 11 10 0   19     0   11   121 134                 255
2047191 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2019   grade_8 125 9 10 1   7     0   5   79 78                       157.0 125 9 10 1   7     0   5   79 78                 157
2047992 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_8 84 9 10 0   4     0   2   60 49                       109.0 84 9 10 0   4     0   2   60 49                 109
2048627 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2019   grade_8 114 12 10 0   1     0   6   67 76                       143.0 114 12 10 0   1     0   6   67 76                 143
2049081 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2019   grade_8 224 9 10 0   13     0   5   139 122                       261.0 224 9 10 0   13     0   5   139 122                 261
2049327 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_8 1 95 10 0   0     0   2   49 59                       108.0 1 95 10 0   0     0   2   49 59                 108
2041743 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_8 116 13 100 0   7     0   8   135 109                       244.0 116 13 100 0   7     0   8   135 109                 244
2045384 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2019   grade_8 58 6 100 0   13     0   1   88 90                       178.0 58 6 100 0   13     0   1   88 90                 178
2041740 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2019   grade_8 129 10 101 0   2     0   9   138 113                       251.0 129 10 101 0   2     0   9   138 113                 251
2042794 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_8 97 4 101 0   5     1   2   104 106                       210.0 97 4 101 0   5     1   2   104 106                 210
2041662 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_8 11 6 103 0   2     0   2   65 59                       124.0 11 6 103 0   2     0   2   65 59                 124
2043228 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2019   grade_8 138 27 103 0   14     0   12   147 147                       294.0 138 27 103 0   14     0   12   147 147                 294
2045387 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2019   grade_8 54 11 103 1   8     0   4   83 98                       181.0 54 11 103 1   8     0   4   83 98                 181
2044094 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_8 218 9 106 3   13     0   12   185 176                       361.0 218 9 106 3   13     0   12   185 176                 361
2042329 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_8 56 15 107 0   13     0   9   100 100                       200.0 56 15 107 0   13     0   9   100 100                 200
2044409 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_8 102 38 107 1   0     0   18   136 130                       266.0 102 38 107 1   0     0   18   136 130                 266
2046082 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2019   grade_8 11 29 107 1   2     0   4   84 70                       154.0 11 29 107 1   2     0   4   84 70                 154
2045824 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge Middle School   Regular School No Middle 06 08 2019   grade_8 51 3 108 0   6     0   2   89 81                       170.0 51 3 108 0   6     0   2   89 81                 170
2039951 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_8 77 2 11 0   35     0   4   54 75                       129.0 77 2 11 0   35     0   4   54 75                 129
2040471 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_8 12 1 11 0   5     0   1   16 14                       30.0 12 1 11 0   5     0   1   16 14                 30
2040825 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_8 3 14 11 1   0     0   0   23 6                       29.0 3 14 11 1   0     0   0   23 6                 29
2040901 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_8 0 22 11 0   0     0   0   23 10                       33.0 0 22 11 0   0     0   0   23 10                 33
2041703 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_8 4 0 11 0   0     0   1   7 9                       16.0 4 0 11 0   0     0   1   7 9                 16
2042390 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2019   grade_8 171 8 11 2   3     0   5   92 108                       200.0 171 8 11 2   3     0   5   92 108                 200
2043709 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_8 26 12 11 0   39     0   2   42 48                       90.0 26 12 11 0   39     0   2   42 48                 90
2044736 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2019   grade_8 163 2 11 0   0     0   8   100 84                       184.0 163 2 11 0   0     0   8   100 84                 184
2045242 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2019   grade_8 55 12 11 0   77     1   5   78 83                       161.0 55 12 11 0   77     1   5   78 83                 161
2045252 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No Middle 05 08 2019   grade_8 35 13 11 1   18     0   3   43 38                       81.0 35 13 11 1   18     0   3   43 38                 81
2045732 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_8 12 7 11 0   6     1   2   19 20                       39.0 12 7 11 0   6     1   2   19 20                 39
2046088 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_8 0 6 11 0   0     0   0   15 2                       17.0 0 6 11 0   0     0   0   15 2                 17
2047066 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2019   grade_8 213 4 11 0   10     0   10   125 123                       248.0 213 4 11 0   10     0   10   125 123                 248
2047123 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 McCall Middle   Regular School No Middle 06 08 2019   grade_8 274 5 11 1   70     0   13   188 185                       374.0 274 5 11 1   70     0   13   188 185                 374
2048529 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2019   grade_8 182 5 11 2   6     0   4   107 103                       210.0 182 5 11 2   6     0   4   107 103                 210
2048893 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2019   grade_8 114 2 11 0   3     0   2   73 59                       132.0 114 2 11 0   3     0   2   73 59                 132
2049135 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2019   grade_8 164 9 11 3   3     1   7   116 82                       198.0 164 9 11 3   3     1   7   116 82                 198
2043104 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_8 2 1 111 0   0     0   0   60 54                       114.0 2 1 111 0   0     0   0   60 54                 114
2043129 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_8 2 1 111 0   1     0   0   64 51                       115.0 2 1 111 0   1     0   0   64 51                 115
2043138 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_8 6 2 119 0   2     0   1   71 59                       130.0 6 2 119 0   2     0   1   71 59                 130
2039819 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_8 147 7 12 0   3     0   3   83 89                       172.0 147 7 12 0   3     0   3   83 89                 172
2040136 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2019   grade_8 126 14 12 0   32     0   7   96 95                       191.0 126 14 12 0   32     0   7   96 95                 191
2041184 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2019   grade_8 170 24 12 1   36     1   5   125 123                       249.0 170 24 12 1   36     1   5   125 123                 249
2041400 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2019   grade_8 47 5 12 0   11     0   6   32 49                       81.0 47 5 12 0   11     0   6   32 49                 81
2042075 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2019   grade_8 257 16 12 0   9     0   5   152 147                       299.0 257 16 12 0   9     0   5   152 147                 299
2043288 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_8 139 12 12 0   138     0   11   170 142                       312.0 139 12 12 0   138     0   11   170 142                 312
2043783 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2019   grade_8 207 11 12 0   4     0   2   111 125                       236.0 207 11 12 0   4     0   2   111 125                 236
2044124 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2019   grade_8 89 2 12 0   0     0   3   55 51                       106.0 89 2 12 0   0     0   3   55 51                 106
2045961 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_8 7 7 12 0   0     0   3   13 16                       29.0 7 7 12 0   0     0   3   13 16                 29
2047662 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2019   grade_8 1 31 12 1   5     0   2   21 31                       52.0 1 31 12 1   5     0   2   21 31                 52
2047727 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_8 10 39 12 0   1     0   4   36 30                       66.0 10 39 12 0   1     0   4   36 30                 66
2047962 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_8 7 59 12 0   4     0   5   44 43                       87.0 7 59 12 0   4     0   5   44 43                 87
2048975 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No Middle 07 08 2019   grade_8 269 0 12 1   3     0   12   152 145                       297.0 269 0 12 1   3     0   12   152 145                 297
2041067 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2019   grade_8 10 5 122 0   1     1   0   77 62                       139.0 10 5 122 0   1     1   0   77 62                 139
2041670 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2019   grade_8 9 4 123 0   2     0   0   67 71                       138.0 9 4 123 0   2     0   0   67 71                 138
2047528 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_8 29 14 123 4   3     2   0   81 94                       175.0 29 14 123 4   3     2   0   81 94                 175
2041666 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_8 3 7 124 1   1     0   1   77 60                       137.0 3 7 124 1   1     0   1   77 60                 137

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