Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1681066 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin - Quabbin Regional Middle School   Regular School No Middle 06 08 2021   grade_6 146 0 13 1   2     0   4   74 92 *                     166.0 146 0 13 1   2     0   4   74 92                 166
1681141 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield - Knox Trail Middle School   Regular School No Middle 05 08 2021   grade_6 75 1 10 0   3     0   1   50 40 *                     90.0 75 1 10 0   3     0   1   50 40                 90
1681134 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield - East Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_6 12 0 2 1   0     0   2   8 9 *                     17.0 12 0 2 1   0     0   2   8 9                 17
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
1680467 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen - New Hingham Regional Elementary   Regular School No Elementary PK 06 2021   grade_6 13 0 1 1   0     0   0   7 8 *                     15.0 13 0 1 1   0     0   0   7 8                 15
1679732 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2021   grade_6 6 49 16 0   1     0   0   36 36 *                     72.0 6 49 16 0   1     0   0   36 36                 72
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
1679840 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District) - Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2021   grade_6 80 0 2 0   0     0   2   48 36 *                     84.0 80 0 2 0   0     0   2   48 36                 84
1679844 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_6 71 7 9 0   6     0   7   57 43 *                     100.0 71 7 9 0   6     0   7   57 43                 100
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
1679902 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District) - Sabis International Charter School   Regular School Yes Other KG 12 2021   grade_6 17 40 86 0   9     0   5   77 80 *                     157.0 17 40 86 0   9     0   5   77 80                 157
1679916 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District) - Neighborhood House Charter School   Regular School Yes Other PK 12 2021   grade_6 13 26 23 0   4     0   2   36 32 *                     68.0 13 26 23 0   4     0   2   36 32                 68
1679955 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District) - Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2021   grade_6 69 6 1 1   17     0   2   40 56 *                     96.0 69 6 1 1   17     0   2   40 56                 96
1679972 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_6 24 0 1 0   0     0   5   19 11 *                     30.0 24 0 1 0   0     0   5   19 11                 30
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
1680032 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District) - Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2021   grade_6 42 4 5 0   1     0   0   24 28 *                     52.0 42 4 5 0   1     0   0   24 28                 52
1680041 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_6 12 0 1 1   0     0   4   9 9 *                     18.0 12 0 1 1   0     0   4   9 9                 18
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
1680166 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District) - South Shore Charter Public School   Regular School Yes Other KG 12 2021   grade_6 43 27 4 0   6     0   2   41 41 *                     82.0 43 27 4 0   6     0   2   41 41                 82
1680183 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_6 90 5 9 0   2     0   4   47 63 *                     110.0 90 5 9 0   2     0   4   47 63                 110
1681202 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional - West Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_6 36 0 6 1   0     0   3   19 27 *                     46.0 36 0 6 1   0     0   3   19 27                 46
1680144 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Learning First Charter Public School (District) - Learning First Charter Public School   Regular School Yes Elementary KG 08 2021   grade_6 6 31 33 0   0     0   3   30 43 *                     73.0 6 31 33 0   0     0   3   30 43                 73
1680153 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District) - Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2021   grade_6 6 46 18 0   12     0   4   51 35 *                     86.0 6 46 18 0   12     0   4   51 35                 86
1679929 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_6 21 68 18 0   3     0   7   61 56 *                     117.0 21 68 18 0   3     0   7   61 56                 117
1679942 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_6 46 77 14 0   10     0   5   74 78 *                     152.0 46 77 14 0   10     0   5   74 78                 152
1679959 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District) - Boston Collegiate Charter School   Regular School Yes High 05 12 2021   grade_6 49 32 12 0   1     0   3   53 44 *                     97.0 49 32 12 0   1     0   3   53 44                 97
1680070 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District) - Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2021   grade_6 61 28 6 1   19     0   9   56 68 *                     124.0 61 28 6 1   19     0   9   56 68                 124
1680116 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District) - Rising Tide Charter Public School   Regular School Yes High 05 12 2021   grade_6 75 1 2 2   3     0   8   49 42 *                     91.0 75 1 2 2   3     0   8   49 42                 91
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
1680112 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District) - River Valley Charter School   Regular School Yes Elementary KG 08 2021   grade_6 28 0 0 0   2     0   2   20 12 *                     32.0 28 0 0 0   2     0   2   20 12                 32
1680124 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_6 7 161 106 2   1     0   5   141 141 *                     282.0 7 161 106 2   1     0   5   141 141                 282
1680014 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public (District) - Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2021   grade_6 2 20 42 0   18     0   2   44 40 *                     84.0 2 20 42 0   18     0   2   44 40                 84
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
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
1679769 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public (District) - Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2021   grade_6 50 9 48 1   12     0   10   75 55 *                     130.0 50 9 48 1   12     0   10   75 55                 130
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
1679803 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_6 14 96 63 1   4     0   4   85 97 *                     182.0 14 96 63 1   4     0   4   85 97                 182
1679717 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_6 32 12 132 0   2     1   2   97 84 *                     181.0 32 12 132 0   2     1   2   97 84                 181
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
1679745 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_6 44 7 10 0   1     0   2   37 27 *                     64.0 44 7 10 0   1     0   2   37 27                 64
1679752 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District) - Boston Preparatory Charter Public School   Regular School Yes High 06 12 2021   grade_6 2 61 35 0   0     0   2   46 54 *                     100.0 2 61 35 0   0     0   2   46 54                 100
1679816 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District) - KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2021   grade_6 3 33 81 1   4     0   4   62 64 *                     126.0 3 33 81 1   4     0   4   62 64                 126
1680004 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District) - Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2021   grade_6 20 3 8 0   0     0   0   16 15 *                     31.0 20 3 8 0   0     0   0   16 15                 31
1680131 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter (District) - Salem Academy Charter School   Regular School Yes High 06 12 2021   grade_6 26 8 31 0   5     0   2   34 38 *                     72.0 26 8 31 0   5     0   2   34 38                 72
1679823 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_6 87 2 6 0   24     0   8   74 53 *                     127.0 87 2 6 0   24     0   8   74 53                 127
1679851 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_6 2 21 4 0   3     0   0   9 21 *                     30.0 2 21 4 0   3     0   0   9 21                 30
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
1680226 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District) - Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2021   grade_6 28 3 6 0   15     0   10   30 32 *                     62.0 28 3 6 0   15     0   10   30 32                 62
1680205 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District) - Pioneer Charter School of Science   Regular School Yes Other KG 12 2021   grade_6 25 12 21 0   8     0   1   28 39 *                     67.0 25 12 21 0   8     0   1   28 39                 67
1680213 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District) - Global Learning Charter Public School   Regular School Yes High 05 12 2021   grade_6 32 15 37 0   1     0   4   43 46 *                     89.0 32 15 37 0   1     0   4   43 46                 89
1680237 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science East (District) - Hampden Charter School of Science East   Regular School Yes High 06 12 2021   grade_6 22 21 37 2   2     0   2   40 46 *                     86.0 22 21 37 2   2     0   2   40 46                 86
1679713 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_6 31 15 91 0   0     0   9   67 79 *                     146.0 31 15 91 0   0     0   9   67 79                 146
1679724 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School (District) - Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2021   grade_6 3 23 19 0   1     0   1   21 26 *                     47.0 3 23 19 0   1     0   1   21 26                 47
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
1680095 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District) - UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2021   grade_6 2 52 44 1   4     1   0   55 49 *                     104.0 2 52 44 1   4     1   0   55 49                 104
1679837 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District) - Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 08 2021   grade_6 2 0 39 0   0     0   0   16 25 *                     41.0 2 0 39 0   0     0   0   16 25                 41
1680234 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School (District) - Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2021   grade_6 6 19 81 1   2     0   2   48 63 *                     111.0 6 19 81 1   2     0   2   48 63                 111
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
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
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
1680827 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_6 130 6 10 1   0     1   10   69 89 *                     158.0 130 6 10 1   0     1   10   69 89                 158
1681450 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District) - Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2021   grade_6 15 17 41 1   26     0   0   55 45 *                     100.0 15 17 41 1   26     0   0   55 45                 100
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
1681437 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_6 4 20 46 0   1     0   0   41 30 *                     71.0 4 20 46 0   1     0   0   41 30                 71
1681524 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_6 32 8 9 0   1     2   3   33 22 0                     55.0 32 8 9 0   1     2   3   33 22 0               55
1681474 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_6 47 14 32 1   5     0   9   56 52 *                     108.0 47 14 32 1   5     0   9   56 52                 108
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
1681487 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School (District) - Springfield Preparatory Charter School   Regular School Yes Elementary KG 06 2021   grade_6 6 10 35 0   0     0   2   31 22 *                     53.0 6 10 35 0   0     0   2   31 22                 53
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
1681495 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_6 2 7 68 2   0     0   1   43 37 *                     80.0 2 7 68 2   0     0   1   43 37                 80
1681504 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School (District) - Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 06 2021   grade_6 36 2 2 0   0     0   0   20 20 *                     40.0 36 2 2 0   0     0   0   20 20                 40
1681505 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_6 23 10 20 0   0     0   1   30 24 *                     54.0 23 10 20 0   0     0   1   30 24                 54
1672015 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_6 136 5 20 0   4     1   3   95 74 *                     169.0 136 5 20 0   4     1   3   95 74                 169
1680272 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough - C.T. Douglas Elementary School   Regular School No Elementary KG 06 2021   grade_6 48 0 1 0   13     1   5   39 29 *                     68.0 48 0 1 0   13     1   5   39 29                 68
1680279 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough - Paul P Gates Elementary School   Regular School No Elementary KG 06 2021   grade_6 22 3 3 0   46     0   1   36 39 *                     75.0 22 3 3 0   46     0   1   36 39                 75
1680286 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough - Luther Conant School   Regular School No Elementary KG 06 2021   grade_6 12 4 2 0   31     0   1   26 24 *                     50.0 12 4 2 0   31     0   1   26 24                 50
1680265 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough - McCarthy-Towne School   Regular School No Elementary KG 06 2021   grade_6 47 5 12 2   14     0   5   44 41 *                     85.0 47 5 12 2   14     0   5   44 41                 85
1680258 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough - Merriam School   Regular School No Elementary KG 06 2021   grade_6 46 0 5 0   17     0   2   35 35 *                     70.0 46 0 5 0   17     0   2   35 35                 70
1680251 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough - Blanchard Memorial School   Regular School No Elementary KG 06 2021   grade_6 37 2 2 0   24     0   1   39 27 *                     66.0 37 2 2 0   24     0   1   39 27                 66
1672030 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_6 92 0 7 0   1     0   4   49 55 *                     104.0 92 0 7 0   1     0   4   49 55                 104
1680301 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Regional - Hoosac Valley Middle School   Regular School No Middle 04 07 2021   grade_6 92 4 3 0   1     0   3   48 55 *                     103.0 92 4 3 0   1     0   3   48 55                 103
1672055 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam - Roberta G. Doering School   Regular School No Middle 05 08 2021   grade_6 209 8 36 0   10     0   9   164 108 *                     272.0 209 8 36 0   10     0   9   164 108                 272
1672075 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_6 139 1 16 1   4     0   5   90 76 *                     166.0 139 1 16 1   4     0   5   90 76                 166
1672093 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_6 26 1 15 0   6     0   2   26 24 *                     50.0 26 1 15 0   6     0   2   26 24                 50
1672100 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_6 20 2 10 0   6     0   2   18 22 *                     40.0 20 2 10 0   6     0   2   18 22                 40
1672107 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_6 27 4 10 0   4     0   5   32 18 *                     50.0 27 4 10 0   4     0   5   32 18                 50
1672145 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover - Wood Hill Middle School   Regular School No Middle 06 08 2021   grade_6 57 3 13 0   41     0   7   68 53 *                     121.0 57 3 13 0   41     0   7   68 53                 121
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
1672142 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_6 129 5 18 0   26     0   4   89 93 *                     182.0 129 5 18 0   26     0   4   89 93                 182
1672196 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Arlington - Gibbs School   Regular School No Middle 06 06 2021   grade_6 334 21 31 2   60     1   34   260 223 *                     483.0 334 21 31 2   60     1   34   260 223                 483
1680328 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Ashburnham-Westminster - Overlook Middle School   Regular School No Middle 06 08 2021   grade_6 157 3 17 0   4     0   10   98 93 *                     191.0 157 3 17 0   4     0   10   98 93                 191
1672210 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_6 158 7 27 3   29     0   5   115 114 *                     229.0 158 7 27 3   29     0   5   115 114                 229
1680350 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston - Athol-Royalston Middle School   Regular School No Middle 05 08 2021   grade_6 84 1 5 0   3     0   2   54 41 *                     95.0 84 1 5 0   3     0   2   54 41                 95
1680348 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Athol-Royalston - Royalston Community School   Regular School No Elementary KG 06 2021   grade_6 16 0 0 0   0     0   2   6 12 *                     18.0 16 0 0 0   0     0   2   6 12                 18
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
1672244 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_6 97 9 15 0   8     0   7   75 61 *                     136.0 97 9 15 0   8     0   7   75 61                 136
1672252 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro - Wamsutta Middle School   Regular School No Middle 05 08 2021   grade_6 86 11 18 0   1     0   18   62 72 *                     134.0 86 11 18 0   1     0   18   62 72                 134
1672272 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_6 163 6 23 0   18     0   3   110 103 *                     213.0 163 6 23 0   18     0   3   110 103                 213
1672288 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_6 29 19 6 0   1     0   0   26 29 *                     55.0 29 19 6 0   1     0   0   26 29                 55
1672318 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable - Barnstable Intermediate School   Regular School No Middle 06 07 2021   grade_6 221 33 70 2   7     0   25   190 168 *                     358.0 221 33 70 2   7     0   25   190 168                 358

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