enrollments

Data source: Big Local News · About: Big Local

592 rows where grade = "grade_6", state = "MA" and year = 2021 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 592 ✖

grade ✖

  • grade_6 · 592 ✖
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
1674294 1674294 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_6 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1674530 1674530 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_6 * * * *   *     *   *   1 3 *                     4.0                         1 3                 4
1674756 1674756 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1674936 1674936 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill - TEACH   Regular School No Other 02 11 2021   grade_6 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1675613 1675613 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1675666 1675666 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_6 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1675704 1675704 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1678005 1678005 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge - Southbridge Academy   Alternative School No High 07 12 2021   grade_6 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1678257 1678257 MA Hampden   school 2511130 281   Springfield 251113002916 2810318 Springfield - Emergence Academy   Regular School No Middle 06 08 2021   grade_6 * * * *   *     *   *   1 * *                     3.0                         1                   3
1679687 1679687 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington - R. H. Conwell   Regular School No Elementary PK 06 2021   grade_6 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1680516 1680516 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth - Nathaniel H. Wixon School   Regular School No Elementary 04 05 2021   grade_6 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1680608 1680608 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 Freetown-Lakeville - George R Austin Intermediate School   Regular School No Middle 04 06 2021   grade_6 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1672700 1672700 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston - Hugh Roe O'Donnell   Regular School No Elementary PK 06 2021   grade_6 0 0 34 0   1     0   0   16 19 *                     35.0 0 0 34 0   1     0   0   16 19                 35
1672756 1672756 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston - John W McCormack   Regular School No Middle 06 08 2021   grade_6 0 10 42 1   9     0   4   33 33 *                     66.0 0 10 42 1   9     0   4   33 33                 66
1672975 1672975 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_6 0 8 34 0   0     0   0   23 19 *                     42.0 0 8 34 0   0     0   0   23 19                 42
1673066 1673066 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_6 0 35 18 0   2     0   3   31 27 *                     58.0 0 35 18 0   2     0   3   31 27                 58
1673072 1673072 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_6 0 19 16 0   1     0   3   29 10 *                     39.0 0 19 16 0   1     0   3   29 10                 39
1673092 1673092 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_6 0 36 30 1   0     0   2   43 26 *                     69.0 0 36 30 1   0     0   2   43 26                 69
1673132 1673132 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston - James P Timilty Middle   Regular School No Middle 06 08 2021   grade_6 0 22 30 0   0     0   3   28 27 *                     55.0 0 22 30 0   0     0   3   28 27                 55
1673275 1673275 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_6 0 2 34 0   0     0   1   16 21 *                     37.0 0 2 34 0   0     0   1   16 21                 37
1673283 1673283 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_6 0 4 4 0   0     0   0   6 2 *                     8.0 0 4 4 0   0     0   0   6 2                 8
1675229 1675229 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence - Arlington Middle School   Regular School No Middle 05 08 2021   grade_6 0 1 149 0   0     0   0   85 64 *                     150.0 0 1 149 0   0     0   0   85 64                 150
1675305 1675305 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_6 0 0 12 0   0     0   0   8 4 *                     12.0 0 0 12 0   0     0   0   8 4                 12
1679766 1679766 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_6 0 19 9 0   0     0   2   13 17 *                     30.0 0 19 9 0   0     0   2   13 17                 30
1679772 1679772 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_6 0 22 10 0   0     1   0   18 15 *                     33.0 0 22 10 0   0     1   0   18 15                 33
1679782 1679782 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public (District) - Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2021   grade_6 0 35 5 0   0     0   0   20 20 *                     40.0 0 35 5 0   0     0   0   20 20                 40
1679794 1679794 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_6 0 1 41 0   1     0   0   22 21 *                     43.0 0 1 41 0   1     0   0   22 21                 43
1679869 1679869 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_6 0 20 2 0   0     0   1   13 10 *                     23.0 0 20 2 0   0     0   1   13 10                 23
1679893 1679893 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_6 0 0 42 0   0     0   0   25 17 *                     42.0 0 0 42 0   0     0   0   25 17                 42
1679995 1679995 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_6 0 0 77 0   0     0   0   41 36 *                     77.0 0 0 77 0   0     0   0   41 36                 77
1680027 1680027 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_6 0 50 21 0   0     0   0   36 35 *                     71.0 0 50 21 0   0     0   0   36 35                 71
1681462 1681462 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_6 0 43 24 0   1     1   0   36 33 *                     69.0 0 43 24 0   1     1   0   36 33                 69
1672643 1672643 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Boston - Edward Everett   Regular School No Elementary PK 06 2021   grade_6 1 16 18 0   5     0   3   16 27 *                     43.0 1 16 18 0   5     0   3   16 27                 43
1672678 1672678 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston - George H Conley   Regular School No Elementary PK 06 2021   grade_6 1 10 10 0   1     0   2   13 11 *                     24.0 1 10 10 0   1     0   2   13 11                 24
1672717 1672717 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston - James W Hennigan   Regular School No Elementary KG 08 2021   grade_6 1 30 45 0   1     1   0   36 42 *                     78.0 1 30 45 0   1     1   0   36 42                 78
1672842 1672842 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_6 1 17 29 0   0     0   1   20 28 *                     48.0 1 17 29 0   0     0   1   20 28                 48
1672894 1672894 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_6 1 54 29 0   1     0   1   37 49 *                     86.0 1 54 29 0   1     0   1   37 49                 86
1672920 1672920 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston - Patrick J Kennedy   Regular School No Elementary PK 06 2021   grade_6 1 4 36 0   1     0   0   29 13 *                     42.0 1 4 36 0   1     0   0   29 13                 42
1672952 1672952 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston - Roger Clap   Regular School No Elementary PK 06 2021   grade_6 1 5 4 0   0     0   0   5 5 *                     10.0 1 5 4 0   0     0   0   5 5                 10
1673013 1673013 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_6 1 6 14 0   2     1   1   12 13 *                     25.0 1 6 14 0   2     1   1   12 13                 25
1673039 1673039 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_6 1 16 18 0   0     0   0   25 10 *                     35.0 1 16 18 0   0     0   0   25 10                 35
1673816 1673816 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_6 1 0 37 0   0     0   1   16 23 *                     39.0 1 0 37 0   0     0   1   16 23                 39
1678254 1678254 MA Hampden   school 2511130 281   Springfield 251113002917 2810317 Springfield - Lyceum Academy   Regular School No Middle 06 08 2021   grade_6 1 18 124 0   0     0   1   79 65 *                     144.0 1 18 124 0   0     0   1   79 65                 144
1678281 1678281 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 Springfield - South End Middle School   Regular School No Middle 06 08 2021   grade_6 1 16 58 0   0     0   1   46 30 *                     76.0 1 16 58 0   0     0   1   46 30                 76
1679883 1679883 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_6 1 14 12 0   1     0   2   16 14 *                     30.0 1 14 12 0   1     0   2   16 14                 30
1679985 1679985 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_6 1 0 81 0   1     0   2   35 50 *                     85.0 1 0 81 0   1     0   2   35 50                 85
1680057 1680057 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District) - MATCH Charter Public School   Regular School Yes Other PK 12 2021   grade_6 1 44 42 1   1     0   3   37 55 *                     92.0 1 44 42 1   1     0   3   37 55                 92
1680105 1680105 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District) - Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2021   grade_6 1 46 10 0   0     0   2   34 25 *                     59.0 1 46 10 0   0     0   2   34 25                 59
1681488 1681488 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_6 1 94 11 2   2     0   7   63 54 *                     117.0 1 94 11 2   2     0   7   63 54                 117
1672867 1672867 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_6 10 24 23 1   74     0   7   78 61 *                     139.0 10 24 23 1   74     0   7   78 61                 139
1673626 1673626 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge - Amigos School   Regular School No Elementary PK 08 2021   grade_6 10 2 21 0   1     0   5   21 18 *                     39.0 10 2 21 0   1     0   5   21 18                 39
1673830 1673830 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_6 10 8 99 0   0     0   6   66 57 *                     123.0 10 8 99 0   0     0   6   66 57                 123
1674264 1674264 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett - Sumner G. Whittier School   Regular School No Elementary KG 08 2021   grade_6 10 10 56 0   2     0   0   38 40 *                     78.0 10 10 56 0   2     0   0   38 40                 78
1677579 1677579 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond - Richmond Consolidated   Regular School No Elementary PK 08 2021   grade_6 10 0 3 0   0     0   1   8 6 *                     14.0 10 0 3 0   0     0   1   8 6                 14
1678140 1678140 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Springfield - Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2021   grade_6 10 10 15 0   0     0   2   18 19 *                     37.0 10 10 15 0   0     0   2   18 19                 37
1678253 1678253 MA Hampden   school 2511130 281   Springfield 251113002918 2810316 Springfield - Kiley Academy   Regular School No Middle 06 06 2021   grade_6 10 27 76 0   0     0   2   65 50 *                     115.0 10 27 76 0   0     0   2   65 50                 115
1678450 1678450 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland - Sunderland Elementary   Regular School No Elementary PK 06 2021   grade_6 10 0 1 0   0     0   2   4 9 *                     13.0 10 0 1 0   0     0   2   4 9                 13
1680596 1680596 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg - Farmington River Elementary   Regular School No Elementary PK 06 2021   grade_6 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1677242 1677242 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield - John T Reid Middle   Regular School No Middle 06 08 2021   grade_6 100 22 34 1   2     0   25   96 88 *                     184.0 100 22 34 1   2     0   25   96 88                 184
1674669 1674669 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_6 101 1 8 0   4     2   2   54 64 *                     118.0 101 1 8 0   4     2   2   54 64                 118
1680776 1680776 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_6 101 0 1 0   0     0   0   60 42 *                     102.0 101 0 1 0   0     0   0   60 42                 102
1672248 1672248 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_6 102 11 36 0   3     0   11   86 77 *                     163.0 102 11 36 0   3     0   11   86 77                 163
1678698 1678698 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Walpole - Bird Middle   Regular School No Middle 06 08 2021   grade_6 102 7 9 0   4     0   4   61 65 *                     126.0 102 7 9 0   4     0   4   61 65                 126
1675690 1675690 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg - Lunenburg Middle School   Regular School No Middle 06 08 2021   grade_6 103 1 12 0   0     1   8   58 67 *                     125.0 103 1 12 0   0     1   8   58 67                 125
1676734 1676734 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Norfolk - Freeman-Kennedy School   Regular School No Elementary 03 06 2021   grade_6 103 0 6 0   3     0   1   63 50 *                     113.0 103 0 6 0   3     0   1   63 50                 113
1681312 1681312 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_6 103 0 6 0   3     0   3   56 59 *                     115.0 103 0 6 0   3     0   3   56 59                 115
1677420 1677420 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Quincy - Central Middle   Regular School No Middle 06 08 2021   grade_6 104 5 8 0   78     1   3   100 99 *                     199.0 104 5 8 0   78     1   3   100 99                 199
1678400 1678400 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton - O'Donnell Middle School   Regular School No Middle 06 08 2021   grade_6 104 73 44 1   15     0   13   127 123 *                     250.0 104 73 44 1   15     0   13   127 123                 250
1678701 1678701 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Walpole - Eleanor N Johnson Middle   Regular School No Middle 06 08 2021   grade_6 104 4 10 1   19     0   8   87 59 *                     146.0 104 4 10 1   19     0   8   87 59                 146
1680371 1680371 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley School District - Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2021   grade_6 104 8 16 2   3     1   2   82 54 *                     136.0 104 8 16 2   3     1   2   82 54                 136
1673760 1673760 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_6 105 4 2 1   1     0   1   51 63 *                     114.0 105 4 2 1   1     0   1   51 63                 114
1673941 1673941 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset - Cohasset Middle School   Regular School No Middle 06 08 2021   grade_6 105 5 0 0   3     0   6   58 61 *                     119.0 105 5 0 0   3     0   6   58 61                 119
1679377 1679377 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn - Daniel L Joyce Middle School   Regular School No Middle 06 08 2021   grade_6 106 9 20 2   3     0   6   70 76 *                     146.0 106 9 20 2   3     0   6   70 76                 146
1680973 1680973 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex - Nissitissit Middle School   Regular School No Middle 05 08 2021   grade_6 106 1 6 0   1     0   4   62 56 *                     118.0 106 1 6 0   1     0   4   62 56                 118
1678482 1678482 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott - Swampscott Middle   Regular School No Middle 05 08 2021   grade_6 107 9 24 0   7     0   6   75 78 *                     153.0 107 9 24 0   7     0   6   75 78                 153
1678752 1678752 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 Waltham - John F Kennedy Middle   Regular School No Middle 06 08 2021   grade_6 107 14 51 0   9     0   5   92 94 *                     186.0 107 14 51 0   9     0   5   92 94                 186
1675484 1675484 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton - Littleton Middle School   Regular School No Middle 06 08 2021   grade_6 108 1 4 1   21     1   0   72 64 *                     136.0 108 1 4 1   21     1   0   72 64                 136
1677245 1677245 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield - Theodore Herberg Middle   Regular School No Middle 06 08 2021   grade_6 108 15 32 0   4     1   17   103 74 *                     177.0 108 15 32 0   4     1   17   103 74                 177
1672139 1672139 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover - Doherty Middle   Regular School No Middle 06 08 2021   grade_6 109 3 13 0   22     0   5   83 69 *                     152.0 109 3 13 0   22     0   5   83 69                 152
1677730 1677730 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus - Saugus Middle School   Regular School No Middle 06 08 2021   grade_6 109 10 58 5   9     1   8   101 99 *                     200.0 109 10 58 5   9     1   8   101 99                 200
1674852 1674852 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   grade_6 11 0 0 0   0     0   1   6 6 *                     12.0 11 0 0 0   0     0   1   6 6                 12
1678270 1678270 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 Springfield - John F Kennedy Middle   Regular School No Middle 06 08 2021   grade_6 11 32 108 0   1     0   2   77 77 *                     154.0 11 32 108 0   1     0   2   77 77                 154
1679437 1679437 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester - Chandler Magnet   Regular School No Elementary PK 06 2021   grade_6 11 1 63 0   1     0   1   40 37 *                     77.0 11 1 63 0   1     0   1   40 37                 77
1678815 1678815 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown - Watertown Middle   Regular School No Middle 06 08 2021   grade_6 110 6 36 0   12     0   14   80 98 *                     178.0 110 6 36 0   12     0   14   80 98                 178
1681120 1681120 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Southwick-Tolland-Granville Regional School District - Powder Mill School   Regular School No Elementary 03 06 2021   grade_6 110 1 7 1   1     0   5   68 57 *                     125.0 110 1 7 1   1     0   5   68 57                 125
1674666 1674666 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin - Remington Middle   Regular School No Middle 06 08 2021   grade_6 112 2 8 0   14     1   1   78 60 *                     138.0 112 2 8 0   14     1   1   78 60                 138
1674912 1674912 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_6 113 6 40 0   3     0   5   90 77 *                     167.0 113 6 40 0   3     0   5   90 77                 167
1679321 1679321 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop - Winthrop Middle School   Regular School No Middle 06 08 2021   grade_6 113 2 18 0   0     1   3   81 56 *                     137.0 113 2 18 0   0     1   3   81 56                 137
1679695 1679695 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham - Charles E Roderick   Regular School No Middle 04 06 2021   grade_6 113 0 9 1   4     0   6   63 70 *                     133.0 113 0 9 1   4     0   6   63 70                 133
1674774 1674774 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_6 114 0 10 0   13     0   6   74 69 *                     143.0 114 0 10 0   13     0   6   74 69                 143
1675447 1675447 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington - Jonas Clarke Middle   Regular School No Middle 06 08 2021   grade_6 115 11 11 1   120     0   20   150 128 *                     278.0 115 11 11 1   120     0   20   150 128                 278
1678784 1678784 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham - Wareham Middle   Regular School No Middle 05 07 2021   grade_6 115 22 17 1   1     1   23   99 81 *                     180.0 115 22 17 1   1     1   23   99 81                 180
1680549 1680549 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn - Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2021   grade_6 115 8 7 0   18     0   14   96 66 *                     162.0 115 8 7 0   18     0   14   96 66                 162
1680705 1680705 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham - Miles River Middle   Regular School No Middle 06 08 2021   grade_6 116 0 7 0   3     3   7   69 67 *                     136.0 116 0 7 0   3     3   7   69 67                 136
1681537 1681537 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District - TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_6 118 15 32 0   6     1   15   104 83 *                     187.0 118 15 32 0   6     1   15   104 83                 187
1674684 1674684 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner - Gardner Middle School   Regular School No Middle 05 07 2021   grade_6 119 4 39 1   1     0   27   109 82 *                     191.0 119 4 39 1   1     0   27   109 82                 191
1679081 1679081 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport - Westport Elementary   Regular School No Elementary 03 06 2021   grade_6 119 0 5 1   1     0   6   67 65 *                     132.0 119 0 5 1   1     0   6   67 65                 132
1672623 1672623 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_6 12 17 16 0   0     0   1   23 23 *                     46.0 12 17 16 0   0     0   1   23 23                 46
1677151 1677151 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham - Pelham Elementary   Regular School No Elementary KG 06 2021   grade_6 12 0 1 0   0     0   1   6 8 *                     14.0 12 0 1 0   0     0   1   6 8                 14
1677934 1677934 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 Somerville - E Somerville Community   Regular School No Elementary KG 08 2021   grade_6 12 4 54 0   2     0   2   47 27 *                     74.0 12 4 54 0   2     0   2   47 27                 74

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