enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019 sorted by multiracial

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 499 ✖

grade ✖

  • grade_7 · 499 ✖
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
2040387 2040387 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_7 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2041274 2041274 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_7 * * * *   *     *   *   1 *                       1.0                         1                   1
2041702 2041702 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_7 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2042771 2042771 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_7 * * * *   *     *   *   5 *                       5.0                         5                   5
2043454 2043454 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_7 * * * *   *     *   *   3 *                       4.0                         3                   4
2043509 2043509 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2048250 2048250 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 06 12 2019   grade_7 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2039818 2039818 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_7 170 2 12 0   3     0   0   104 83                       187.0 170 2 12 0   3     0   0   104 83                 187
2040596 2040596 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_7 0 0 16 0   0     0   0   9 7                       16.0 0 0 16 0   0     0   0   9 7                 16
2040623 2040623 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_7 6 2 6 0   0     0   0   7 7                       14.0 6 2 6 0   0     0   0   7 7                 14
2040654 2040654 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_7 1 9 23 0   3     0   0   18 18                       36.0 1 9 23 0   3     0   0   18 18                 36
2040783 2040783 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_7 0 9 14 0   0     0   0   16 7                       23.0 0 9 14 0   0     0   0   16 7                 23
2040824 2040824 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_7 2 6 12 0   0     0   0   14 6                       20.0 2 6 12 0   0     0   0   14 6                 20
2040992 2040992 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_7 1 23 20 0   0     0   0   18 26                       44.0 1 23 20 0   0     0   0   18 26                 44
2041093 2041093 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2019   grade_7 0 0 16 0   0     0   0   4 12                       16.0 0 0 16 0   0     0   0   4 12                 16
2041186 2041186 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2019   grade_7 165 11 11 0   36     0   0   104 119                       223.0 165 11 11 0   36     0   0   104 119                 223
2041661 2041661 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_7 9 10 116 0   0     0   0   73 62                       135.0 9 10 116 0   0     0   0   73 62                 135
2041665 2041665 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_7 11 3 124 1   1     0   0   73 67                       140.0 11 3 124 1   1     0   0   73 67                 140
2041769 2041769 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2019   grade_7 90 3 41 0   2     0   0   68 68                       136.0 90 3 41 0   2     0   0   68 68                 136
2042137 2042137 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_7 1 1 4 0   0     0   0   4 2                       6.0 1 1 4 0   0     0   0   4 2                 6
2042158 2042158 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_7 12 18 80 0   3     0   0   53 60                       113.0 12 18 80 0   3     0   0   53 60                 113
2042369 2042369 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_7 9 0 0 0   0     0   0   2 7                       9.0 9 0 0 0   0     0   0   2 7                 9
2042541 2042541 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_7 94 1 2 0   0     0   0   51 46                       97.0 94 1 2 0   0     0   0   51 46                 97
2042717 2042717 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_7 29 1 1 0   0     0   0   15 16                       31.0 29 1 1 0   0     0   0   15 16                 31
2042885 2042885 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_7 12 0 29 0   0     0   0   22 19                       41.0 12 0 29 0   0     0   0   22 19                 41
2042896 2042896 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_7 2 3 40 0   0     0   0   32 13                       45.0 2 3 40 0   0     0   0   32 13                 45
2042905 2042905 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_7 1 1 49 0   0     0   0   30 21                       51.0 1 1 49 0   0     0   0   30 21                 51
2042921 2042921 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_7 8 4 48 0   0     0   0   28 32                       60.0 8 4 48 0   0     0   0   28 32                 60
2042931 2042931 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_7 2 1 37 0   0     0   0   15 25                       40.0 2 1 37 0   0     0   0   15 25                 40
2043065 2043065 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_7 4 2 76 0   3     0   0   45 40                       85.0 4 2 76 0   3     0   0   45 40                 85
2043069 2043069 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_7 2 1 140 0   0     0   0   71 70                       143.0 2 1 140 0   0     0   0   71 70                 143
2043086 2043086 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_7 2 2 108 0   1     0   0   50 63                       113.0 2 2 108 0   1     0   0   50 63                 113
2043103 2043103 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_7 7 0 106 0   0     0   0   61 52                       113.0 7 0 106 0   0     0   0   61 52                 113
2043122 2043122 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_7 1 1 72 0   2     0   0   36 40                       76.0 1 1 72 0   2     0   0   36 40                 76
2043125 2043125 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2019   grade_7 5 2 140 0   4     0   0   77 74                       151.0 5 2 140 0   4     0   0   77 74                 151
2043128 2043128 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_7 0 1 99 0   1     0   0   59 42                       101.0 0 1 99 0   1     0   0   59 42                 101
2043137 2043137 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_7 11 4 104 0   6     0   0   62 63                       125.0 11 4 104 0   6     0   0   62 63                 125
2043147 2043147 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_7 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2044422 2044422 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2019   grade_7 3 2 4 0   0     0   0   8 1                       9.0 3 2 4 0   0     0   0   8 1                 9
2045448 2045448 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2019   grade_7 69 3 2 0   0     0   0   44 30                       74.0 69 3 2 0   0     0   0   44 30                 74
2045759 2045759 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2019   grade_7 10 3 62 0   5     0   0   43 37                       80.0 10 3 62 0   5     0   0   43 37                 80
2045781 2045781 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 07 08 2019   grade_7 0 2 4 0   0     0   0   6 *                       6.0 0 2 4 0   0     0   0   6                   6
2046071 2046071 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2019   grade_7 13 49 112 0   3     0   0   88 89                       177.0 13 49 112 0   3     0   0   88 89                 177
2046087 2046087 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_7 2 4 13 0   0     0   0   15 4                       19.0 2 4 13 0   0     0   0   15 4                 19
2046095 2046095 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2019   grade_7 3 3 3 0   0     0   0   7 2                       9.0 3 3 3 0   0     0   0   7 2                 9
2046101 2046101 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_7 7 17 92 0   0     0   0   55 61                       116.0 7 17 92 0   0     0   0   55 61                 116
2046107 2046107 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2019   grade_7 8 9 38 1   0     0   0   22 34                       56.0 8 9 38 1   0     0   0   22 34                 56
2046117 2046117 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle Academy   Regular School No Middle 06 08 2019   grade_7 2 6 65 0   0     0   0   47 26                       73.0 2 6 65 0   0     0   0   47 26                 73
2047523 2047523 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_7 17 7 24 0   0     0   0   24 24                       48.0 17 7 24 0   0     0   0   24 24                 48
2047534 2047534 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2019   grade_7 4 23 25 0   0     0   0   25 27                       52.0 4 23 25 0   0     0   0   25 27                 52
2047549 2047549 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2019   grade_7 32 4 1 0   0     0   0   18 19                       37.0 32 4 1 0   0     0   0   18 19                 37
2047582 2047582 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_7 1 51 11 0   0     0   0   35 28                       63.0 1 51 11 0   0     0   0   35 28                 63
2047604 2047604 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 07 2019   grade_7 0 0 32 0   1     0   0   14 19                       33.0 0 0 32 0   1     0   0   14 19                 33
2047616 2047616 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_7 5 99 73 0   2     0   0   91 88                       179.0 5 99 73 0   2     0   0   91 88                 179
2047648 2047648 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 07 2019   grade_7 1 0 31 0   0     0   0   18 14                       32.0 1 0 31 0   0     0   0   18 14                 32
2047679 2047679 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_7 0 15 3 0   0     0   0   8 10                       18.0 0 15 3 0   0     0   0   8 10                 18
2047693 2047693 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   grade_7 0 15 11 0   0     0   0   8 18                       26.0 0 15 11 0   0     0   0   8 18                 26
2047703 2047703 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_7 2 0 32 0   0     0   0   10 24                       34.0 2 0 32 0   0     0   0   10 24                 34
2047793 2047793 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2019   grade_7 6 0 65 0   0     0   0   33 38                       71.0 6 0 65 0   0     0   0   33 38                 71
2047803 2047803 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_7 1 2 47 0   0     0   0   22 28                       50.0 1 2 47 0   0     0   0   22 28                 50
2047849 2047849 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_7 17 1 1 1   0     0   0   8 12                       20.0 17 1 1 1   0     0   0   8 12                 20
2048014 2048014 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2019   grade_7 28 12 14 3   2     0   0   29 30                       59.0 28 12 14 3   2     0   0   29 30                 59
2048046 2048046 MA Hampden   school 2500522 499   Hampden Charter School of Science East (District) 250052202680 4990305 Hampden Charter School of Science East   Regular School Yes High 06 12 2019   grade_7 29 22 34 0   3     0   0   39 49                       88.0 29 22 34 0   3     0   0   39 49                 88
2048815 2048815 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No Middle 07 08 2019   grade_7 181 0 7 0   3     0   0   90 101                       191.0 181 0 7 0   3     0   0   90 101                 191
2049074 2049074 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2019   grade_7 40 0 5 0   1     0   0   17 29                       46.0 40 0 5 0   1     0   0   17 29                 46
2049326 2049326 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_7 3 101 9 1   0     0   0   62 52                       114.0 3 101 9 1   0     0   0   62 52                 114
2039833 2039833 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_7 117 2 1 0   0     0   1   64 57                       121.0 117 2 1 0   0     0   1   64 57                 121
2040298 2040298 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_7 187 5 18 1   19     0   1   124 107                       231.0 187 5 18 1   19     0   1   124 107                 231
2040348 2040348 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_7 1 8 8 0   0     0   1   8 10                       18.0 1 8 8 0   0     0   1   8 10                 18
2040381 2040381 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_7 5 23 65 0   1     0   1   50 45                       95.0 5 23 65 0   1     0   1   50 45                 95
2040429 2040429 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_7 0 36 19 0   0     2   1   26 32                       58.0 0 36 19 0   0     2   1   26 32                 58
2040453 2040453 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_7 8 2 90 0   0     0   1   50 51                       101.0 8 2 90 0   0     0   1   50 51                 101
2040470 2040470 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_7 6 3 12 0   2     0   1   12 12                       24.0 6 3 12 0   2     0   1   12 12                 24
2040487 2040487 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_7 4 23 15 0   0     0   1   18 25                       43.0 4 23 15 0   0     0   1   18 25                 43
2040534 2040534 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_7 1 13 36 0   1     0   1   24 28                       52.0 1 13 36 0   1     0   1   24 28                 52
2040695 2040695 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_7 10 7 4 0   0     0   1   15 7                       22.0 10 7 4 0   0     0   1   15 7                 22
2040810 2040810 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2019   grade_7 9 5 18 0   2     0   1   13 22                       35.0 9 5 18 0   2     0   1   13 22                 35
2040863 2040863 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2019   grade_7 11 12 38 0   4     0   1   39 27                       66.0 11 12 38 0   4     0   1   39 27                 66
2040900 2040900 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_7 0 24 18 0   0     0   1   24 19                       43.0 0 24 18 0   0     0   1   24 19                 43
2041066 2041066 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2019   grade_7 7 6 150 0   2     0   1   82 84                       166.0 7 6 150 0   2     0   1   82 84                 166
2041183 2041183 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2019   grade_7 155 9 16 0   39     0   1   113 107                       220.0 155 9 16 0   39     0   1   113 107                 220
2041288 2041288 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_7 4 2 0 0   0     0   1   5 2                       7.0 4 2 0 0   0     0   1   5 2                 7
2041669 2041669 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2019   grade_7 8 5 126 0   1     0   1   63 78                       141.0 8 5 126 0   1     0   1   63 78                 141
2041784 2041784 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_7 95 3 3 0   3     0   1   55 50                       105.0 95 3 3 0   3     0   1   55 50                 105
2042089 2042089 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2019   grade_7 30 2 5 0   0     0   1   18 20                       38.0 30 2 5 0   0     0   1   18 20                 38
2042133 2042133 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2019   grade_7 31 21 57 1   13     0   1   61 63                       124.0 31 21 57 1   13     0   1   61 63                 124
2042617 2042617 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_7 50 0 4 0   1     0   1   27 29                       56.0 50 0 4 0   1     0   1   27 29                 56
2042688 2042688 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2019   grade_7 204 4 5 0   6     0   1   121 99                       220.0 204 4 5 0   6     0   1   121 99                 220
2042788 2042788 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_7 75 6 35 1   3     0   1   64 57                       121.0 75 6 35 1   3     0   1   64 57                 121
2042793 2042793 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_7 109 10 95 1   3     0   1   124 95                       219.0 109 10 95 1   3     0   1   124 95                 219
2042939 2042939 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2019   grade_7 7 5 72 0   0     0   1   41 44                       85.0 7 5 72 0   0     0   1   41 44                 85
2042953 2042953 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2019   grade_7 77 2 4 1   2     0   1   49 38                       87.0 77 2 4 1   2     0   1   49 38                 87
2043161 2043161 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2019   grade_7 50 1 2 0   2     0   1   31 25                       56.0 50 1 2 0   2     0   1   31 25                 56
2043373 2043373 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 07 2019   grade_7 20 4 19 0   11     0   1   36 19                       55.0 20 4 19 0   11     0   1   36 19                 55
2043668 2043668 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2019   grade_7 2 0 4 0   1     0   1   7 1                       8.0 2 0 4 0   1     0   1   7 1                 8
2043708 2043708 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_7 25 18 15 0   41     1   1   57 44                       101.0 25 18 15 0   41     1   1   57 44                 101
2044416 2044416 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_7 1 0 4 0   0     0   1   3 3                       6.0 1 0 4 0   0     0   1   3 3                 6
2045005 2045005 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2019   grade_7 215 1 0 0   1     1   1   125 94                       219.0 215 1 0 0   1     1   1   125 94                 219
2045172 2045172 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_7 5 4 2 0   0     0   1   6 6                       12.0 5 4 2 0   0     0   1   6 6                 12
2045386 2045386 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2019   grade_7 65 4 126 0   6     0   1   101 101                       202.0 65 4 126 0   6     0   1   101 101                 202

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