enrollments

Data source: Big Local News · About: Big Local

496 rows where grade = "grade_7", state = "MA" and year = 2021 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 496 ✖

grade ✖

  • grade_7 · 496 ✖
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
1674757 1674757 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_7 * * * *   *     *   *   * * *                     2.0                                             2
1674915 1674915 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill - Greenleaf Academy   Regular School No High 06 12 2021   grade_7 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1675705 1675705 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1676598 1676598 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford - Whaling City Junior/Senior High School   Regular School No High 06 12 2021   grade_7 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1678258 1678258 MA Hampden   school 2511130 281   Springfield 251113002916 2810318 Springfield - Emergence Academy   Regular School No Middle 06 08 2021   grade_7 * * * *   *     *   *   3 * *                     5.0                         3                   5
1672792 1672792 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston - Joseph Lee   Regular School No Elementary PK 08 2021   grade_7 0 36 23 0   3     0   7   32 37 *                     69.0 0 36 23 0   3     0   7   32 37                 69
1672976 1672976 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_7 0 6 30 0   0     0   0   18 18 *                     36.0 0 6 30 0   0     0   0   18 18                 36
1673040 1673040 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_7 0 14 12 0   0     0   0   12 14 *                     26.0 0 14 12 0   0     0   0   12 14                 26
1673067 1673067 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_7 0 29 13 0   0     0   1   19 24 *                     43.0 0 29 13 0   0     0   1   19 24                 43
1675264 1675264 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence - UP Academy Oliver Middle School   Regular School No Middle 06 08 2021   grade_7 0 0 100 0   0     0   0   49 50 *                     100.0 0 0 100 0   0     0   0   49 50                 100
1675306 1675306 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_7 0 0 11 0   0     0   0   10 1 *                     11.0 0 0 11 0   0     0   0   10 1                 11
1679767 1679767 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District) - Bridge Boston Charter School   Regular School Yes Elementary PK 08 2021   grade_7 0 17 10 0   0     0   0   12 15 *                     27.0 0 17 10 0   0     0   0   12 15                 27
1679795 1679795 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway (District) - Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 08 2021   grade_7 0 1 34 0   0     0   0   23 12 *                     35.0 0 1 34 0   0     0   0   23 12                 35
1679870 1679870 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District) - Codman Academy Charter Public School   Regular School Yes Other PK 12 2021   grade_7 0 18 4 0   0     0   0   12 10 *                     22.0 0 18 4 0   0     0   0   12 10                 22
1679884 1679884 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District) - Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2021   grade_7 0 24 8 0   0     0   0   16 16 *                     32.0 0 24 8 0   0     0   0   16 16                 32
1679894 1679894 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District) - Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2021   grade_7 0 0 43 0   0     0   0   20 23 *                     43.0 0 0 43 0   0     0   0   20 23                 43
1680028 1680028 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School (District) - KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2021   grade_7 0 46 12 0   0     0   0   28 30 *                     58.0 0 46 12 0   0     0   0   28 30                 58
1681496 1681496 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School (District) - Libertas Academy Charter School   Regular School Yes Middle 06 08 2021   grade_7 0 9 74 0   1     0   2   37 49 *                     86.0 0 9 74 0   1     0   2   37 49                 86
1672503 1672503 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_7 1 4 3 0   2     0   2   7 5 *                     12.0 1 4 3 0   2     0   2   7 5                 12
1672718 1672718 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston - James W Hennigan   Regular School No Elementary KG 08 2021   grade_7 1 21 62 0   2     0   0   40 46 *                     86.0 1 21 62 0   2     0   0   40 46                 86
1673073 1673073 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_7 1 27 16 0   2     0   3   22 27 *                     49.0 1 27 16 0   2     0   3   22 27                 49
1673093 1673093 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_7 1 32 19 0   0     0   2   36 18 *                     54.0 1 32 19 0   0     0   2   36 18                 54
1673187 1673187 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston - New Mission High School   Alternative School No High 07 12 2021   grade_7 1 26 16 0   1     0   2   17 28 *                     46.0 1 26 16 0   1     0   2   17 28                 46
1673224 1673224 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   grade_7 1 20 17 0   40     0   4   41 41 *                     82.0 1 20 17 0   40     0   4   41 41                 82
1673276 1673276 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_7 1 0 27 0   0     0   1   13 16 *                     29.0 1 0 27 0   0     0   1   13 16                 29
1673452 1673452 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_7 1 3 1 0   0     0   1   4 2 *                     6.0 1 3 1 0   0     0   1   4 2                 6
1675247 1675247 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_7 1 3 130 0   1     0   0   82 53 *                     135.0 1 3 130 0   1     0   0   82 53                 135
1675614 1675614 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_7 1 0 5 0   0     0   1   7 * *                     7.0 1 0 5 0   0     0   1   7                   7
1678006 1678006 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge - Southbridge Academy   Alternative School No High 07 12 2021   grade_7 1 0 7 0   0     0   0   5 3 *                     8.0 1 0 7 0   0     0   0   5 3                 8
1678276 1678276 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield - Springfield Public Day Middle School   Regular School No Middle 06 08 2021   grade_7 1 4 7 0   0     0   0   11 1 *                     12.0 1 4 7 0   0     0   0   11 1                 12
1678284 1678284 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield - Balliet Middle School   Regular School No Middle 06 08 2021   grade_7 1 4 4 0   0     0   0   7 * *                     9.0 1 4 4 0   0     0   0   7                   9
1679986 1679986 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter (District) - Holyoke Community Charter School   Regular School Yes Elementary KG 08 2021   grade_7 1 2 67 0   1     0   2   32 41 *                     73.0 1 2 67 0   1     0   2   32 41                 73
1679996 1679996 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District) - Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2021   grade_7 1 0 74 0   0     0   0   42 33 *                     75.0 1 0 74 0   0     0   0   42 33                 75
1681463 1681463 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester (District) - UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2021   grade_7 1 36 29 0   0     1   1   39 29 *                     68.0 1 36 29 0   0     1   1   39 29                 68
1681489 1681489 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District) - New Heights Charter School of Brockton   Regular School Yes High 06 12 2021   grade_7 1 105 9 0   1     0   6   60 62 *                     122.0 1 105 9 0   1     0   6   60 62                 122
1672911 1672911 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_7 10 7 24 0   0     0   2   15 28 *                     43.0 10 7 24 0   0     0   2   15 28                 43
1673627 1673627 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge - Amigos School   Regular School No Elementary PK 08 2021   grade_7 10 4 19 0   2     0   4   20 19 *                     39.0 10 4 19 0   2     0   4   20 19                 39
1673827 1673827 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea - Clark Avenue School   Regular School No Middle 05 08 2021   grade_7 10 5 173 1   0     0   2   97 94 *                     191.0 10 5 173 1   0     0   2   97 94                 191
1677346 1677346 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_7 10 3 2 0   0     0   3   11 7 *                     18.0 10 3 2 0   0     0   3   11 7                 18
1677906 1677906 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Somerville - Arthur D Healey   Regular School No Elementary PK 08 2021   grade_7 10 7 28 0   1     0   1   26 21 *                     47.0 10 7 28 0   1     0   1   26 21                 47
1678268 1678268 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield - Forest Park Middle   Regular School No Middle 06 08 2021   grade_7 10 49 137 0   12     0   6   121 93 *                     214.0 10 49 137 0   12     0   6   121 93                 214
1678279 1678279 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield - STEM Middle Academy   Regular School No Middle 06 08 2021   grade_7 10 25 59 0   4     0   1   59 40 *                     99.0 10 25 59 0   4     0   1   59 40                 99
1678294 1678294 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield - Conservatory of the Arts   Regular School No High 06 12 2021   grade_7 10 5 36 0   0     0   2   13 40 *                     53.0 10 5 36 0   0     0   2   13 40                 53
1681465 1681465 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II) (District) - Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2021   grade_7 10 23 15 1   12     0   3   38 26 *                     64.0 10 23 15 1   12     0   3   38 26                 64
1675338 1675338 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester - Leicester Middle   Regular School No Middle 05 08 2021   grade_7 100 7 17 0   2     0   2   75 53 *                     128.0 100 7 17 0   2     0   2   75 53                 128
1675485 1675485 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton - Littleton Middle School   Regular School No Middle 06 08 2021   grade_7 100 4 3 0   19     0   3   64 65 *                     129.0 100 4 3 0   19     0   3   64 65                 129
1677243 1677243 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield - John T Reid Middle   Regular School No Middle 06 08 2021   grade_7 100 15 25 1   4     0   21   95 71 *                     166.0 100 15 25 1   4     0   21   95 71                 166
1680302 1680302 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Regional - Hoosac Valley Middle School   Regular School No Middle 04 07 2021   grade_7 100 3 2 0   0     0   2   55 52 *                     107.0 100 3 2 0   0     0   2   55 52                 107
1680828 1680828 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District - Monomoy Regional Middle School   Regular School No Middle 05 07 2021   grade_7 100 9 13 2   3     0   13   64 76 *                     140.0 100 9 13 2   3     0   13   64 76                 140
1677064 1677064 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford - Oxford Middle   Regular School No Middle 05 07 2021   grade_7 101 1 8 0   0     0   5   61 54 *                     115.0 101 1 8 0   0     0   5   61 54                 115
1679037 1679037 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford - Blanchard Middle   Regular School No Middle 06 08 2021   grade_7 102 3 7 1   50     0   6   79 90 *                     169.0 102 3 7 1   50     0   6   79 90                 169
1679651 1679651 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester - Worcester East Middle   Regular School No Middle 07 08 2021   grade_7 102 79 168 0   17     0   18   201 183 *                     384.0 102 79 168 0   17     0   18   201 183                 384
1680974 1680974 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex - Nissitissit Middle School   Regular School No Middle 05 08 2021   grade_7 103 2 5 0   1     0   8   65 54 *                     119.0 103 2 5 0   1     0   8   65 54                 119
1672413 1672413 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_7 104 0 0 0   0     0   5   56 53 *                     109.0 104 0 0 0   0     0   5   56 53                 109
1674667 1674667 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin - Remington Middle   Regular School No Middle 06 08 2021   grade_7 104 4 5 1   6     0   1   64 57 *                     121.0 104 4 5 1   6     0   1   64 57                 121
1675192 1675192 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich - Ipswich Middle School   Regular School No Middle 06 08 2021   grade_7 104 3 9 0   1     0   5   63 59 *                     122.0 104 3 9 0   1     0   5   63 59                 122
1678626 1678626 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Uxbridge - Whitin Intermediate   Regular School No Middle 04 07 2021   grade_7 104 0 9 1   1     0   3   73 45 *                     118.0 104 0 9 1   1     0   3   73 45                 118
1678816 1678816 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown - Watertown Middle   Regular School No Middle 06 08 2021   grade_7 104 5 50 0   17     0   8   102 82 *                     184.0 104 5 50 0   17     0   8   102 82                 184
1681121 1681121 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District - Southwick Regional School   Regular School No High 07 12 2021   grade_7 104 6 6 0   2     0   4   56 66 *                     122.0 104 6 6 0   2     0   4   56 66                 122
1681313 1681313 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_7 104 0 7 0   1     0   4   58 58 *                     116.0 104 0 7 0   1     0   4   58 58                 116
1673761 1673761 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_7 105 4 2 1   1     0   1   53 61 *                     114.0 105 4 2 1   1     0   1   53 61                 114
1678753 1678753 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 Waltham - John F Kennedy Middle   Regular School No Middle 06 08 2021   grade_7 105 19 45 0   10     0   6   109 76 *                     185.0 105 19 45 0   10     0   6   109 76                 185
1680895 1680895 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett - Narragansett Middle   Regular School No Middle 05 08 2021   grade_7 106 0 7 1   2     0   7   66 57 *                     123.0 106 0 7 1   2     0   7   66 57                 123
1672253 1672253 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro - Wamsutta Middle School   Regular School No Middle 05 08 2021   grade_7 107 10 26 0   5     0   11   86 73 *                     159.0 107 10 26 0   5     0   11   86 73                 159
1676711 1676711 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Newton - Bigelow Middle   Regular School No Middle 06 08 2021   grade_7 108 6 13 0   29     0   8   72 92 *                     164.0 108 6 13 0   29     0   8   72 92                 164
1674664 1674664 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin - Annie Sullivan Middle School   Regular School No Middle 06 08 2021   grade_7 109 6 9 0   6     0   1   66 65 *                     131.0 109 6 9 0   6     0   1   66 65                 131
1680427 1680427 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Blackstone-Millville - Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2021   grade_7 109 3 11 0   2     0   7   61 71 *                     132.0 109 3 11 0   2     0   7   61 71                 132
1672810 1672810 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston - Joyce Kilmer   Regular School No Elementary PK 08 2021   grade_7 11 11 18 0   1     0   0   24 17 *                     41.0 11 11 18 0   1     0   0   24 17                 41
1672901 1672901 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston - William H Ohrenberger   Regular School No Middle 03 08 2021   grade_7 11 25 40 0   1     0   4   42 39 *                     81.0 11 25 40 0   1     0   4   42 39                 81
1673004 1673004 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_7 11 6 14 0   1     0   0   16 16 *                     32.0 11 6 14 0   1     0   0   16 16                 32
1674317 1674317 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_7 11 14 77 0   3     0   1   53 53 *                     106.0 11 14 77 0   3     0   1   53 53                 106
1679641 1679641 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester - Claremont Academy   Regular School No High 07 12 2021   grade_7 11 9 70 0   8     0   0   47 51 *                     98.0 11 9 70 0   8     0   0   47 51                 98
1680042 1680042 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District) - Martha's Vineyard Charter School   Regular School Yes Other KG 12 2021   grade_7 11 0 2 0   0     0   1   4 10 *                     14.0 11 0 2 0   0     0   1   4 10                 14
1677791 1677791 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Seekonk - Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2021   grade_7 110 5 13 0   14     0   7   74 73 *                     149.0 110 5 13 0   14     0   7   74 73                 149
1680489 1680489 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire - Nessacus Regional Middle School   Regular School No Middle 06 08 2021   grade_7 110 0 3 1   0     0   1   59 56 *                     115.0 110 0 3 1   0     0   1   59 56                 115
1674670 1674670 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_7 111 2 4 0   8     2   4   70 61 *                     131.0 111 2 4 0   8     2   4   70 61                 131
1674704 1674704 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown - Georgetown Middle School   Regular School No Middle 07 08 2021   grade_7 111 2 1 0   0     1   1   59 57 *                     116.0 111 2 1 0   0     1   1   59 57                 116
1672140 1672140 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover - Doherty Middle   Regular School No Middle 06 08 2021   grade_7 112 1 11 0   12     0   6   66 76 *                     142.0 112 1 11 0   12     0   6   66 76                 142
1673927 1673927 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton - Clinton Middle School   Regular School No Middle 05 08 2021   grade_7 112 6 40 0   2     0   5   94 71 *                     165.0 112 6 40 0   2     0   5   94 71                 165
1674913 1674913 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_7 112 9 46 1   3     0   1   88 84 *                     172.0 112 9 46 1   3     0   1   88 84                 172
1678612 1678612 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough - Tyngsborough Middle   Regular School No Middle 06 08 2021   grade_7 112 10 5 0   16     0   6   83 66 *                     149.0 112 10 5 0   16     0   6   83 66                 149
1680777 1680777 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional - Manchester Essex Regional Middle School   Regular School No Middle 06 08 2021   grade_7 112 0 1 0   0     0   0   59 54 *                     113.0 112 0 1 0   0     0   0   59 54                 113
1681074 1681074 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar - Ralph C Mahar Regional   Regular School No High 07 12 2021   grade_7 112 0 10 0   4     0   1   63 64 *                     127.0 112 0 10 0   4     0   1   63 64                 127
1672245 1672245 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_7 113 19 12 2   10     0   14   90 80 *                     170.0 113 19 12 2   10     0   14   90 80                 170
1675451 1675451 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington - Wm Diamond Middle   Regular School No Middle 06 08 2021   grade_7 113 13 9 0   140     0   24   144 155 *                     299.0 113 13 9 0   140     0   24   144 155                 299
1676578 1676578 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford - Keith Middle School   Regular School No Middle 06 08 2021   grade_7 113 62 137 2   3     0   34   198 153 *                     351.0 113 62 137 2   3     0   34   198 153                 351
1680542 1680542 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_7 116 1 7 1   2     0   4   63 68 *                     131.0 116 1 7 1   2     0   4   63 68                 131
1680571 1680571 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg - Dudley Middle School   Regular School No Middle 05 08 2021   grade_7 116 6 15 1   1     0   6   63 82 *                     145.0 116 6 15 1   1     0   6   63 82                 145
1674685 1674685 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner - Gardner Middle School   Regular School No Middle 05 07 2021   grade_7 117 4 38 0   4     0   13   96 80 *                     176.0 117 4 38 0   4     0   13   96 80                 176
1676899 1676899 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough - Robert E. Melican Middle School   Regular School No Middle 06 08 2021   grade_7 117 4 13 1   19     1   5   77 83 *                     160.0 117 4 13 1   19     1   5   77 83                 160
1679647 1679647 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester - Burncoat Middle School   Regular School No Middle 07 08 2021   grade_7 118 56 128 0   19     0   16   161 176 *                     337.0 118 56 128 0   19     0   16   161 176                 337
1672076 1672076 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_7 119 3 21 0   2     0   10   90 65 *                     155.0 119 3 21 0   2     0   10   90 65                 155
1680308 1680308 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham - Amherst Regional Middle School   Regular School No Middle 07 08 2021   grade_7 119 18 44 0   14     0   15   101 109 *                     210.0 119 18 44 0   14     0   15   101 109                 210
1680706 1680706 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham - Miles River Middle   Regular School No Middle 06 08 2021   grade_7 119 0 3 0   4     0   1   69 58 *                     127.0 119 0 3 0   4     0   1   69 58                 127
1680736 1680736 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire - Hampshire Regional High   Regular School No High 07 12 2021   grade_7 119 0 3 1   3     0   2   54 74 *                     128.0 119 0 3 1   3     0   2   54 74                 128
1672652 1672652 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_7 12 6 16 0   8     0   2   27 17 *                     44.0 12 6 16 0   8     0   2   27 17                 44
1677935 1677935 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 Somerville - E Somerville Community   Regular School No Elementary KG 08 2021   grade_7 12 1 60 0   2     0   3   36 42 *                     78.0 12 1 60 0   2     0   3   36 42                 78
1677955 1677955 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Somerville - Winter Hill Community   Regular School No Elementary PK 08 2021   grade_7 12 4 22 0   7     0   1   30 16 *                     46.0 12 4 22 0   7     0   1   30 16                 46
1678291 1678291 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Springfield - Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2021   grade_7 12 23 64 0   4     0   3   53 53 *                     106.0 12 23 64 0   4     0   3   53 53                 106
1679930 1679930 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_7 12 75 21 0   3     0   3   52 62 *                     114.0 12 75 21 0   3     0   3   52 62                 114

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