enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 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 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 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 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 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 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 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 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
2040349 2040349 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_8 2 9 16 0   1     0   0   12 16                       28.0 2 9 16 0   1     0   0   12 16                 28
2040488 2040488 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_8 6 16 16 1   0     0   0   21 18                       39.0 6 16 16 1   0     0   0   21 18                 39
2040535 2040535 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_8 1 16 41 0   0     0   0   24 34                       58.0 1 16 41 0   0     0   0   24 34                 58
2040597 2040597 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_8 0 0 16 0   0     0   0   6 10                       16.0 0 0 16 0   0     0   0   6 10                 16
2040624 2040624 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_8 12 7 9 0   0     0   0   11 17                       28.0 12 7 9 0   0     0   0   11 17                 28
2040655 2040655 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_8 0 6 20 0   0     0   0   11 15                       26.0 0 6 20 0   0     0   0   11 15                 26
2040696 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
2040722 2040722 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2019   grade_8 9 7 18 0   0     0   0   16 18                       34.0 9 7 18 0   0     0   0   16 18                 34
2040794 2040794 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_8 6 6 23 0   1     0   0   24 12                       36.0 6 6 23 0   1     0   0   24 12                 36
2040825 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
2040864 2040864 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2019   grade_8 6 12 38 1   2     0   0   34 25                       59.0 6 12 38 1   2     0   0   34 25                 59
2040874 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
2040901 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
2040911 2040911 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_8 3 2 7 1   0     0   0   7 6                       13.0 3 2 7 1   0     0   0   7 6                 13
2040939 2040939 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2019   grade_8 2 43 48 2   2     0   0   51 46                       97.0 2 43 48 2   2     0   0   51 46                 97
2040942 2040942 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2019   grade_8 1 43 66 0   0     1   0   48 63                       111.0 1 43 66 0   0     1   0   48 63                 111
2041067 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
2041094 2041094 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2019   grade_8 0 0 22 0   0     0   0   9 13                       22.0 0 0 22 0   0     0   0   9 13                 22
2041101 2041101 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_8 0 3 3 0   0     0   0   2 4                       6.0 0 3 3 0   0     0   0   2 4                 6
2041670 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
2041760 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
2041770 2041770 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2019   grade_8 93 6 30 0   2     0   0   78 53                       131.0 93 6 30 0   2     0   0   78 53                 131
2042138 2042138 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_8 3 2 3 0   0     0   0   6 2                       8.0 3 2 3 0   0     0   0   6 2                 8
2042271 2042271 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_8 4 0 2 0   0     0   0   3 3                       6.0 4 0 2 0   0     0   0   3 3                 6
2042618 2042618 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_8 53 0 5 0   1     0   0   40 19                       59.0 53 0 5 0   1     0   0   40 19                 59
2042689 2042689 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2019   grade_8 172 2 2 0   5     0   0   91 90                       181.0 172 2 2 0   5     0   0   91 90                 181
2042718 2042718 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_8 28 0 3 0   0     0   0   15 16                       31.0 28 0 3 0   0     0   0   15 16                 31
2042897 2042897 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_8 6 1 59 0   0     0   0   41 25                       66.0 6 1 59 0   0     0   0   41 25                 66
2042906 2042906 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_8 2 1 38 0   0     0   0   23 18                       41.0 2 1 38 0   0     0   0   23 18                 41
2042922 2042922 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_8 5 3 50 0   0     0   0   25 33                       58.0 5 3 50 0   0     0   0   25 33                 58
2042932 2042932 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_8 5 1 33 0   0     0   0   24 15                       39.0 5 1 33 0   0     0   0   24 15                 39
2043008 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
2043066 2043066 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_8 6 0 88 0   3     0   0   46 51                       97.0 6 0 88 0   3     0   0   46 51                 97
2043091 2043091 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_8 5 0 158 0   1     0   0   88 76                       164.0 5 0 158 0   1     0   0   88 76                 164
2043104 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
2043123 2043123 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_8 4 1 77 0   3     0   0   41 44                       85.0 4 1 77 0   3     0   0   41 44                 85
2043129 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
2043191 2043191 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_8 62 0 5 0   4     0   0   36 35                       71.0 62 0 5 0   4     0   0   36 35                 71
2043727 2043727 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2019   grade_8 21 10 19 0   7     0   0   30 27                       57.0 21 10 19 0   7     0   0   30 27                 57
2044172 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 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
2045173 2045173 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_8 4 1 2 0   0     0   0   6 1                       7.0 4 1 2 0   0     0   0   6 1                 7
2045449 2045449 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2019   grade_8 71 1 2 0   0     0   0   35 39                       74.0 71 1 2 0   0     0   0   35 39                 74
2045751 2045751 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   grade_8 21 2 16 0   4     0   0   27 16                       43.0 21 2 16 0   4     0   0   27 16                 43
2045760 2045760 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2019   grade_8 6 4 48 0   1     0   0   23 36                       59.0 6 4 48 0   1     0   0   23 36                 59
2045780 2045780 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2019   grade_8 8 10 32 0   5     0   0   28 27                       55.0 8 10 32 0   5     0   0   28 27                 55
2045782 2045782 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 07 08 2019   grade_8 3 1 4 0   0     0   0   5 *                       8.0 3 1 4 0   0     0   0   5                   8
2046062 2046062 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2019   grade_8 23 21 68 0   1     0   0   62 51                       113.0 23 21 68 0   1     0   0   62 51                 113
2046088 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
2046091 2046091 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2019   grade_8 10 16 70 0   3     0   0   64 35                       99.0 10 16 70 0   3     0   0   64 35                 99
2046099 2046099 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_8 0 7 78 0   0     0   0   43 42                       85.0 0 7 78 0   0     0   0   43 42                 85
2046102 2046102 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_8 3 16 97 0   0     0   0   51 65                       116.0 3 16 97 0   0     0   0   51 65                 116
2047452 2047452 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_8 4 3 69 0   7     0   0   42 41                       83.0 4 3 69 0   7     0   0   42 41                 83
2047528 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
2047583 2047583 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2019   grade_8 0 39 17 1   1     1   0   31 28                       59.0 0 39 17 1   1     1   0   31 28                 59
2047680 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
2047704 2047704 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2019   grade_8 1 0 18 0   1     0   0   11 9                       20.0 1 0 18 0   1     0   0   11 9                 20
2047804 2047804 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2019   grade_8 0 0 49 0   0     0   0   20 29                       49.0 0 0 49 0   0     0   0   20 29                 49
2047841 2047841 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2019   grade_8 33 3 3 1   1     0   0   25 16                       41.0 33 3 3 1   1     0   0   25 16                 41
2047933 2047933 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_8 4 153 91 0   1     1   0   119 131                       250.0 4 153 91 0   1     1   0   119 131                 250
2048044 2048044 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2019   grade_8 5 19 42 0   1     0   0   30 37                       67.0 5 19 42 0   1     0   0   30 37                 67
2048205 2048205 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2019   grade_8 81 1 4 0   4     0   0   52 38                       90.0 81 1 4 0   4     0   0   52 38                 90
2048437 2048437 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Middle School   Regular School No Middle 06 08 2019   grade_8 67 0 2 1   0     0   0   38 32                       70.0 67 0 2 1   0     0   0   38 32                 70
2048519 2048519 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2019   grade_8 13 0 2 0   0     0   0   13 2                       15.0 13 0 2 0   0     0   0   13 2                 15
2048681 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
2048730 2048730 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2019   grade_8 81 0 3 0   3     0   0   47 40                       87.0 81 0 3 0   3     0   0   47 40                 87
2039834 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
2040170 2040170 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_8 149 5 5 0   5     0   1   79 86                       165.0 149 5 5 0   5     0   1   79 86                 165
2040325 2040325 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2019   grade_8 3 2 5 0   3     0   1   8 6                       14.0 3 2 5 0   3     0   1   8 6                 14
2040359 2040359 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2019   grade_8 1 14 18 0   3     0   1   22 15                       37.0 1 14 18 0   3     0   1   22 15                 37
2040444 2040444 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_8 3 11 27 0   1     0   1   21 22                       43.0 3 11 27 0   1     0   1   21 22                 43
2040454 2040454 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_8 11 2 89 0   1     0   1   55 49                       104.0 11 2 89 0   1     0   1   55 49                 104
2040471 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
2040712 2040712 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2019   grade_8 12 20 40 0   2     0   1   47 28                       75.0 12 20 40 0   2     0   1   47 28                 75
2040784 2040784 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_8 0 6 18 0   0     0   1   13 12                       25.0 0 6 18 0   0     0   1   13 12                 25
2040811 2040811 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2019   grade_8 6 5 13 0   2     0   1   16 11                       27.0 6 5 13 0   2     0   1   16 11                 27
2040847 2040847 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_8 2 15 7 0   0     0   1   14 11                       25.0 2 15 7 0   0     0   1   14 11                 25
2040881 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
2040891 2040891 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_8 2 47 28 1   1     0   1   45 35                       80.0 2 47 28 1   1     0   1   45 35                 80
2040936 2040936 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_8 7 17 72 0   8     0   1   63 42                       105.0 7 17 72 0   8     0   1   63 42                 105
2040993 2040993 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_8 3 38 30 0   2     0   1   35 39                       74.0 3 38 30 0   2     0   1   35 39                 74
2041275 2041275 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_8 0 1 3 1   0     0   1   4 *                       6.0 0 1 3 1   0     0   1   4                   6
2041373 2041373 MA Middlesex   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2019   grade_8 36 5 4 0   12     0   1   29 29                       58.0 36 5 4 0   12     0   1   29 29                 58
2041600 2041600 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_8 128 0 2 1   1     0   1   59 74                       133.0 128 0 2 1   1     0   1   59 74                 133
2041666 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
2041703 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
2041785 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
2042134 2042134 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2019   grade_8 27 19 42 0   6     0   1   52 43                       95.0 27 19 42 0   6     0   1   52 43                 95
2042159 2042159 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_8 13 14 89 0   4     0   1   64 57                       121.0 13 14 89 0   4     0   1   64 57                 121
2042223 2042223 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   grade_8 28 5 18 1   2     0   1   30 25                       55.0 28 5 18 1   2     0   1   30 25                 55
2042505 2042505 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_8 119 3 6 0   9     0   1   62 76                       138.0 119 3 6 0   9     0   1   62 76                 138
2042542 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

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