enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
1673917 1673917 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_7 30 0 0 0   0     0   0   13 17 *                     30.0 30 0 0 0   0     0   0   13 17                 30
1674431 1674431 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_7 7 1 0 0   0     0   0   7 1 *                     8.0 7 1 0 0   0     0   0   7 1                 8
1674531 1674531 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_7 18 0 0 0   0     0   0   11 7 *                     18.0 18 0 0 0   0     0   0   11 7                 18
1676612 1676612 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Newburyport - Rupert A Nock Middle   Regular School No Middle 06 08 2021   grade_7 156 3 0 0   4     0   2   85 80 *                     165.0 156 3 0 0   4     0   2   85 80                 165
1677506 1677506 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Reading - Arthur W Coolidge Middle   Regular School No Middle 06 08 2021   grade_7 128 1 0 0   2     0   1   74 58 *                     132.0 128 1 0 0   2     0   1   74 58                 132
1679973 1679973 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District) - Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2021   grade_7 24 0 0 0   2     0   5   15 16 *                     31.0 24 0 0 0   2     0   5   15 16                 31
1680610 1680610 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville - Freetown-Lakeville Middle School   Regular School No Middle 06 09 2021   grade_7 220 4 0 0   2     0   3   118 111 *                     229.0 220 4 0 0   2     0   3   118 111                 229
1681034 1681034 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley - Pioneer Valley Regional   Regular School No High 07 12 2021   grade_7 53 1 0 0   1     0   2   28 29 *                     57.0 53 1 0 0   1     0   2   28 29                 57
1681248 1681248 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett - Thomas Prince   Regular School No Elementary KG 08 2021   grade_7 37 2 0 0   2     0   3   25 19 *                     44.0 37 2 0 0   2     0   3   25 19                 44
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
1673525 1673525 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline - Michael Driscoll   Regular School No Elementary KG 08 2021   grade_7 37 2 1 0   12     0   4   31 25 *                     56.0 37 2 1 0   12     0   4   31 25                 56
1673942 1673942 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset - Cohasset Middle School   Regular School No Middle 06 08 2021   grade_7 124 4 1 0   1     0   0   64 66 *                     130.0 124 4 1 0   1     0   0   64 66                 130
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
1674890 1674890 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield - Smith Academy   Regular School No High 07 12 2021   grade_7 31 1 1 0   0     0   0   17 16 *                     33.0 31 1 1 0   0     0   0   17 16                 33
1675172 1675172 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull - Memorial Middle   Regular School No Middle 06 08 2021   grade_7 58 1 1 0   0     0   2   37 25 *                     62.0 58 1 1 0   0     0   2   37 25                 62
1677174 1677174 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke - Pembroke Community Middle School   Regular School No Middle 07 08 2021   grade_7 193 1 1 0   1     0   5   102 99 *                     201.0 193 1 1 0   1     0   5   102 99                 201
1677580 1677580 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond - Richmond Consolidated   Regular School No Elementary PK 08 2021   grade_7 15 0 1 0   0     0   1   5 12 *                     17.0 15 0 1 0   0     0   1   5 12                 17
1679852 1679852 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District) - Community Charter School of Cambridge   Regular School Yes High 06 12 2021   grade_7 3 31 1 0   2     0   3   20 20 *                     40.0 3 31 1 0   2     0   3   20 20                 40
1680448 1680448 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham - Raynham Middle School   Regular School No Middle 05 08 2021   grade_7 149 16 1 0   5     0   5   94 82 *                     176.0 149 16 1 0   5     0   5   94 82                 176
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
1672146 1672146 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover - Wood Hill Middle School   Regular School No Middle 06 08 2021   grade_7 66 4 10 0   35     1   7   53 70 *                     123.0 66 4 10 0   35     1   7   53 70                 123
1672480 1672480 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica - Locke Middle   Regular School No Middle 05 07 2021   grade_7 146 4 10 0   12     0   9   104 77 *                     181.0 146 4 10 0   12     0   9   104 77                 181
1672537 1672537 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston - Jackson Mann   Regular School No Elementary PK 08 2021   grade_7 3 13 10 0   1     0   1   17 11 *                     28.0 3 13 10 0   1     0   1   17 11                 28
1673562 1673562 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline - Pierce   Regular School No Elementary KG 08 2021   grade_7 51 5 10 0   14     0   12   40 52 *                     92.0 51 5 10 0   14     0   12   40 52                 92
1673572 1673572 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   grade_7 35 2 10 0   7     0   7   22 39 *                     61.0 35 2 10 0   7     0   7   22 39                 61
1673605 1673605 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington - Marshall Simonds Middle   Regular School No Middle 06 08 2021   grade_7 172 20 10 0   33     0   4   110 129 *                     239.0 172 20 10 0   33     0   4   110 129                 239
1675448 1675448 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington - Jonas Clarke Middle   Regular School No Middle 06 08 2021   grade_7 139 15 10 1   127     1   9   172 130 *                     302.0 139 15 10 1   127     1   9   172 130                 302
1677418 1677418 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Quincy - Broad Meadows Middle   Regular School No Middle 06 08 2021   grade_7 62 13 10 0   19     0   3   50 57 *                     107.0 62 13 10 0   19     0   3   50 57                 107
1678441 1678441 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Sudbury - Ephraim Curtis Middle   Regular School No Middle 06 08 2021   grade_7 218 12 10 0   35     1   17   146 146 *                     293.0 218 12 10 0   35     1   17   146 146                 293
1678770 1678770 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware - Ware Junior/Senior High School   Regular School No High 07 12 2021   grade_7 88 1 10 0   0     0   3   57 45 *                     102.0 88 1 10 0   0     0   3   57 45                 102
1679251 1679251 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington - Wilmington Middle School   Regular School No Middle 06 08 2021   grade_7 234 3 10 0   13     0   8   143 125 *                     268.0 234 3 10 0   13     0   8   143 125                 268
1679375 1679375 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 94 19 10 0   13     2   6   71 73 *                     144.0 94 19 10 0   13     2   6   71 73                 144
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
1679824 1679824 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District) - Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2021   grade_7 94 5 10 0   8     0   8   60 65 *                     125.0 94 5 10 0   8     0   8   60 65                 125
1679845 1679845 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_7 75 4 10 1   8     0   4   45 57 *                     102.0 75 4 10 1   8     0   4   45 57                 102
1680386 1680386 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills - W.E.B. Du Bois Regional Middle School   Regular School No Middle 05 08 2021   grade_7 73 0 10 0   3     0   4   47 43 *                     90.0 73 0 10 0   3     0   4   47 43                 90
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
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
1674617 1674617 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham - Fuller Middle   Regular School No Middle 06 08 2021   grade_7 58 15 101 1   4     0   8   111 76 *                     187.0 58 15 101 1   4     0   8   111 76                 187
1678261 1678261 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 Springfield - John J Duggan Middle   Regular School No High 06 12 2021   grade_7 18 45 101 1   4     0   0   100 69 *                     169.0 18 45 101 1   4     0   0   100 69                 169
1675289 1675289 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence - UP Academy Leonard Middle School   Regular School No Middle 06 08 2021   grade_7 4 0 105 0   0     0   0   51 58 *                     109.0 4 0 105 0   0     0   0   51 58                 109
1676270 1676270 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_7 199 14 107 7   8     0   12   183 164 *                     347.0 199 14 107 7   8     0   12   183 164                 347
1675102 1675102 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_7 3 6 108 0   1     0   1   64 55 *                     119.0 3 6 108 0   1     0   1   64 55                 119
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
1673516 1673516 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline - Florida Ruffin Ridley School   Regular School No Elementary PK 08 2021   grade_7 53 1 11 0   11     0   10   44 41 *                     86.0 53 1 11 0   11     0   10   44 41                 86
1675118 1675118 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale - Hopedale Jr Sr High   Regular School No High 07 12 2021   grade_7 73 1 11 0   1     1   3   47 43 *                     90.0 73 1 11 0   1     1   3   47 43                 90
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
1676720 1676720 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton - Oak Hill Middle   Regular School No Middle 06 08 2021   grade_7 135 17 11 0   59     0   9   123 108 *                     231.0 135 17 11 0   59     0   9   123 108                 231
1676950 1676950 MA Middlesex   school 2508820 217   North Reading 250882002592 2170305 North Reading - North Reading Middle   Regular School No Middle 06 08 2021   grade_7 159 1 11 0   13     0   6   80 110 *                     190.0 159 1 11 0   13     0   6   80 110                 190
1679068 1679068 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston - Weston Middle   Regular School No Middle 06 08 2021   grade_7 92 7 11 0   29     0   8   79 68 *                     147.0 92 7 11 0   29     0   8   79 68                 147
1679746 1679746 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District) - Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2021   grade_7 45 8 11 0   1     0   3   33 35 *                     68.0 45 8 11 0   1     0   3   33 35                 68
1679773 1679773 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public (District) - Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2021   grade_7 2 66 11 0   0     0   1   34 46 *                     80.0 2 66 11 0   0     0   1   34 46                 80
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
1680679 1680679 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Gill-Montague - Great Falls Middle   Regular School No Middle 06 08 2021   grade_7 62 1 11 0   0     1   7   47 35 *                     82.0 62 1 11 0   0     1   7   47 35                 82
1680788 1680788 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet - Masconomet Regional Middle School   Regular School No Middle 07 08 2021   grade_7 274 3 11 0   9     1   16   149 165 *                     314.0 274 3 11 0   9     1   16   149 165                 314
1680802 1680802 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton - Miscoe Hill School   Regular School No Middle 05 08 2021   grade_7 172 0 11 0   7     0   5   109 86 *                     195.0 172 0 11 0   7     0   5   109 86                 195
1677529 1677529 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere - Rumney Marsh Academy   Regular School No Middle 06 08 2021   grade_7 86 8 110 0   9     0   4   133 84 *                     217.0 86 8 110 0   9     0   4   133 84                 217
1678271 1678271 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 Springfield - John F Kennedy Middle   Regular School No Middle 06 08 2021   grade_7 14 37 110 0   1     0   1   82 81 *                     163.0 14 37 110 0   1     0   1   82 81                 163
1680125 1680125 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_7 2 147 111 1   0     1   2   142 122 *                     264.0 2 147 111 1   0     1   2   142 122                 264
1677558 1677558 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere - Garfield Middle School   Regular School No Middle 06 08 2021   grade_7 65 7 112 0   8     0   1   106 87 *                     193.0 65 7 112 0   8     0   1   106 87                 193
1675298 1675298 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence - Frost Middle School   Regular School No Middle 05 08 2021   grade_7 9 3 113 0   3     0   6   74 60 *                     134.0 9 3 113 0   3     0   6   74 60                 134
1674951 1674951 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_7 81 10 115 0   6     0   4   120 96 *                     216.0 81 10 115 0   6     0   4   120 96                 216
1673823 1673823 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_7 9 11 117 2   0     0   6   79 66 *                     145.0 9 11 117 2   0     0   6   79 66                 145
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
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
1673703 1673703 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge - Putnam Avenue Upper School   Regular School No Middle 06 08 2021   grade_7 24 22 12 1   9     0   10   38 40 *                     78.0 24 22 12 1   9     0   10   38 40                 78
1674338 1674338 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven - Hastings Middle   Regular School No Middle 06 08 2021   grade_7 121 6 12 1   4     0   6   76 74 *                     150.0 121 6 12 1   4     0   6   76 74                 150
1674990 1674990 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham - Hingham Middle School   Regular School No Middle 06 08 2021   grade_7 297 5 12 0   15     0   7   183 153 *                     336.0 297 5 12 0   15     0   7   183 153                 336
1676714 1676714 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Newton - Charles E Brown Middle   Regular School No Middle 06 08 2021   grade_7 168 3 12 1   58     0   11   129 124 *                     253.0 168 3 12 1   58     0   11   129 124                 253
1677888 1677888 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset - Somerset Middle School   Regular School No Middle 06 08 2021   grade_7 198 3 12 1   4     0   5   109 114 *                     223.0 198 3 12 1   4     0   5   109 114                 223
1677985 1677985 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 Southborough - P Brent Trottier   Regular School No Middle 06 08 2021   grade_7 78 2 12 0   25     0   7   61 63 *                     124.0 78 2 12 0   25     0   7   61 63                 124
1678785 1678785 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham - Wareham Middle   Regular School No Middle 05 07 2021   grade_7 126 14 12 3   2     0   30   84 103 *                     187.0 126 14 12 3   2     0   30   84 103                 187
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
1680583 1680583 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset - Nauset Regional Middle   Regular School No Middle 06 08 2021   grade_7 159 8 12 0   4     0   7   99 90 *                     190.0 159 8 12 0   4     0   7   99 90                 190
1681067 1681067 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin - Quabbin Regional Middle School   Regular School No Middle 06 08 2021   grade_7 165 0 12 0   1     1   2   93 88 *                     181.0 165 0 12 0   1     1   2   93 88                 181
1681309 1681309 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson - Whitman Middle   Regular School No Middle 06 08 2021   grade_7 161 8 12 2   2     0   8   98 95 *                     193.0 161 8 12 2   2     0   8   98 95                 193
1681438 1681438 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District) - Baystate Academy Charter Public School   Regular School Yes High 06 12 2021   grade_7 31 30 12 0   0     1   5   36 43 *                     79.0 31 30 12 0   0     1   5   36 43                 79
1673900 1673900 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee - Dupont Middle   Regular School No Middle 06 08 2021   grade_7 125 15 124 0   4     0   7   145 130 *                     275.0 125 15 124 0   4     0   7   145 130                 275
1677561 1677561 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Revere - Susan B. Anthony Middle School   Regular School No Middle 06 08 2021   grade_7 59 11 124 0   2     0   2   83 115 *                     198.0 59 11 124 0   2     0   2   83 115                 198
1678756 1678756 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham - John W. McDevitt Middle School   Regular School No Middle 06 08 2021   grade_7 68 15 128 0   7     0   4   116 106 *                     222.0 68 15 128 0   7     0   4   116 106                 222
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
1672527 1672527 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_7 4 11 13 0   3     0   0   12 19 *                     31.0 4 11 13 0   3     0   0   12 19                 31
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
1675475 1675475 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln - Hanscom Middle   Regular School No Middle 04 08 2021   grade_7 33 3 13 0   0     0   3   28 24 *                     52.0 33 3 13 0   0     0   3   28 24                 52
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
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
1677415 1677415 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Quincy - Atlantic Middle   Regular School No Middle 06 08 2021   grade_7 55 8 13 0   102     1   4   93 90 *                     183.0 55 8 13 0   102     1   4   93 90                 183
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
1678842 1678842 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland - Wayland Middle School   Regular School No Middle 06 08 2021   grade_7 127 15 13 0   32     1   15   96 107 *                     203.0 127 15 13 0   32     1   15   96 107                 203
1680616 1680616 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_7 90 2 13 0   2     0   7   67 47 *                     114.0 90 2 13 0   2     0   7   67 47                 114
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
1680926 1680926 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Nashoba - Luther Burbank Middle School   Regular School No Middle 06 08 2021   grade_7 58 1 13 0   0     0   2   39 35 *                     74.0 58 1 13 0   0     0   2   39 35                 74
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
1676584 1676584 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford - Roosevelt Middle School   Regular School No Middle 06 08 2021   grade_7 95 41 132 0   0     1   15   147 137 *                     284.0 95 41 132 0   0     1   15   147 137                 284

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