Data source: Big Local News · About: Big Local

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

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
1674756 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
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
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
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
1677634 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe - Rowe Elementary   Regular School No Elementary PK 06 2021   grade_6 9 0 0 0   0     0   1   5 5 *                     10.0 9 0 0 0   0     0   1   5 5                 10
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
1673708 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge - Vassal Lane Upper School   Regular School No Middle 06 08 2021   grade_6 36 23 12 0   19     0   10   51 49 *                     100.0 36 23 12 0   19     0   10   51 49                 100
1675101 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_6 3 5 90 0   1     0   1   61 39 *                     100.0 3 5 90 0   1     0   1   61 39                 100
1675909 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden - Linden   Regular School No Elementary KG 08 2021   grade_6 37 18 23 0   18     0   4   52 48 *                     100.0 37 18 23 0   18     0   4   52 48                 100
1677429 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy - Point Webster Middle   Regular School No Middle 05 08 2021   grade_6 17 13 21 0   40     5   4   46 54 *                     100.0 17 13 21 0   40     5   4   46 54                 100
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
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
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
1675263 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence - UP Academy Oliver Middle School   Regular School No Middle 06 08 2021   grade_6 2 2 96 0   1     0   0   56 44 *                     101.0 2 2 96 0   1     0   0   56 44                 101
1678769 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware - Ware Middle School   Regular School No Middle 04 06 2021   grade_6 73 1 16 1   1     0   9   50 51 *                     101.0 73 1 16 1   1     0   9   50 51                 101
1675882 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_6 30 20 16 0   31     0   5   52 50 *                     102.0 30 20 16 0   31     0   5   52 50                 102
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
1678242 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield - The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2021   grade_6 15 15 70 0   1     0   2   50 52 *                     103.0 15 15 70 0   1     0   2   50 52                 103
1678458 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton - Sutton Middle School   Regular School No Middle 06 08 2021   grade_6 93 2 2 0   3     0   3   52 51 *                     103.0 93 2 2 0   3     0   3   52 51                 103
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
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
1673257 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_6 2 60 31 0   1     0   10   65 39 *                     104.0 2 60 31 0   1     0   10   65 39                 104
1675891 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_6 25 21 39 0   15     0   4   45 59 *                     104.0 25 21 39 0   15     0   4   45 59                 104
1678252 MA Hampden   school 2511130 281   Springfield 251113002920 2810315 Springfield - Kiley Prep   Regular School No Middle 06 06 2021   grade_6 8 25 65 0   3     0   3   59 45 *                     104.0 8 25 65 0   3     0   3   59 45                 104
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
1672651 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_6 59 6 22 1   10     0   7   47 58 *                     105.0 59 6 22 1   10     0   7   47 58                 105
1676298 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis - Millis Middle   Regular School No Middle 06 08 2021   grade_6 93 0 6 0   1     0   5   50 55 *                     105.0 93 0 6 0   1     0   5   50 55                 105
1677424 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Quincy - South West Middle School   Regular School No Middle 05 08 2021   grade_6 36 9 15 1   38     1   5   74 31 *                     105.0 36 9 15 1   38     1   5   74 31                 105
1673699 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge - Cambridge Street Upper School   Regular School No Middle 06 08 2021   grade_6 49 20 14 0   13     0   11   63 44 *                     107.0 49 20 14 0   13     0   11   63 44                 107
1680488 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire - Nessacus Regional Middle School   Regular School No Middle 06 08 2021   grade_6 90 0 5 0   1     0   11   63 44 *                     107.0 90 0 5 0   1     0   11   63 44                 107
1680964 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex - Hawthorne Brook   Regular School No Middle 05 08 2021   grade_6 95 2 5 0   2     0   3   51 56 *                     107.0 95 2 5 0   2     0   3   51 56                 107
1681256 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett - Central Tree Middle   Regular School No Middle 06 08 2021   grade_6 96 2 3 1   3     0   2   52 55 *                     107.0 96 2 3 1   3     0   2   52 55                 107
1676204 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen - Comprehensive Grammar School   Regular School No Elementary PK 08 2021   grade_6 44 7 49 0   1     0   7   54 54 *                     108.0 44 7 49 0   1     0   7   54 54                 108
1680541 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_6 93 5 3 0   3     0   4   47 61 *                     108.0 93 5 3 0   3     0   4   47 61                 108
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
1672561 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston - Curley K-8 School   Regular School No Elementary PK 08 2021   grade_6 30 20 51 1   3     0   5   43 67 *                     110.0 30 20 51 1   3     0   5   43 67                 110
1674191 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton - White Brook Middle School   Regular School No Middle 05 08 2021   grade_6 85 1 18 0   3     0   3   54 56 *                     110.0 85 1 18 0   3     0   3   54 56                 110
1678414 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Sturbridge - Burgess Elementary   Regular School No Elementary PK 06 2021   grade_6 93 2 5 2   2     0   6   65 45 *                     110.0 93 2 5 2   2     0   6   65 45                 110
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
1675533 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Lowell - Rogers STEM Academy   Regular School No Elementary KG 08 2021   grade_6 27 11 45 0   22     0   6   53 58 *                     111.0 27 11 45 0   22     0   6   53 58                 111
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
1680928 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Nashoba - Hale   Regular School No Middle 06 08 2021   grade_6 89 5 6 0   6     0   5   54 57 *                     111.0 89 5 6 0   6     0   5   54 57                 111
1673082 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_6 3 76 29 1   2     0   1   54 58 *                     112.0 3 76 29 1   2     0   1   54 58                 112
1674316 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_6 17 18 73 0   1     0   3   55 57 *                     112.0 17 18 73 0   1     0   3   55 57                 112
1674946 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill - John G Whittier   Regular School No Middle 05 08 2021   grade_6 69 2 38 1   1     0   1   63 49 *                     112.0 69 2 38 1   1     0   1   63 49                 112
1680426 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Blackstone-Millville - Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2021   grade_6 90 2 13 0   0     0   7   61 50 *                     112.0 90 2 13 0   0     0   7   61 50                 112
1675191 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich - Ipswich Middle School   Regular School No Middle 06 08 2021   grade_6 97 1 5 0   4     0   6   53 60 *                     113.0 97 1 5 0   4     0   6   53 60                 113
1675503 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow - Glenbrook Middle   Regular School No Middle 06 08 2021   grade_6 83 7 5 0   12     0   6   61 52 *                     113.0 83 7 5 0   12     0   6   61 52                 113
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
1680894 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett - Narragansett Middle   Regular School No Middle 05 08 2021   grade_6 96 1 8 0   0     0   8   59 54 *                     113.0 96 1 8 0   0     0   8   59 54                 113
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
1677417 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Quincy - Broad Meadows Middle   Regular School No Middle 06 08 2021   grade_6 70 10 9 0   21     0   4   64 50 *                     114.0 70 10 9 0   21     0   4   64 50                 114
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
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
1674288 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett - George Keverian School   Regular School No Elementary KG 08 2021   grade_6 19 16 75 0   4     0   2   58 58 *                     116.0 19 16 75 0   4     0   2   58 58                 116
1677063 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford - Oxford Middle   Regular School No Middle 05 07 2021   grade_6 97 2 14 0   0     0   4   63 54 *                     117.0 97 2 14 0   0     0   4   63 54                 117
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
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
1672900 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston - William H Ohrenberger   Regular School No Middle 03 08 2021   grade_6 37 31 45 0   4     0   1   58 60 *                     118.0 37 31 45 0   4     0   1   58 60                 118
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
1678290 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Springfield - Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2021   grade_6 14 18 81 0   4     0   1   69 49 *                     118.0 14 18 81 0   4     0   1   69 49                 118
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
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
1674817 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield - Greenfield Middle   Regular School No Middle 05 07 2021   grade_6 79 4 29 0   1     0   6   53 66 *                     119.0 79 4 29 0   1     0   6   53 66                 119
1676050 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_6 84 4 9 7   2     0   13   58 61 *                     119.0 84 4 9 7   2     0   13   58 61                 119
1678611 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough - Tyngsborough Middle   Regular School No Middle 06 08 2021   grade_6 96 5 3 0   11     0   4   65 54 *                     119.0 96 5 3 0   11     0   4   65 54                 119
1672601 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston - Dante Alighieri Montessori School   Regular School No Elementary PK 06 2021   grade_6 4 0 8 0   0     0   0   7 5 *                     12.0 4 0 8 0   0     0   0   7 5                 12
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
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
1680871 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Mohawk Trail - Colrain Central   Regular School No Elementary PK 06 2021   grade_6 12 0 0 0   0     0   0   7 5 *                     12.0 12 0 0 0   0     0   0   7 5                 12
1676194 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen - Marsh Grammar School   Regular School No Elementary PK 08 2021   grade_6 75 0 40 0   2     0   3   70 50 *                     120.0 75 0 40 0   2     0   3   70 50                 120
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
1674307 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett - Lafayette School   Regular School No Elementary KG 08 2021   grade_6 37 12 57 0   12     0   3   67 54 *                     121.0 37 12 57 0   12     0   3   67 54                 121
1675288 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence - UP Academy Leonard Middle School   Regular School No Middle 06 08 2021   grade_6 3 0 118 0   0     0   0   67 54 *                     121.0 3 0 118 0   0     0   0   67 54                 121
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
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
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
1678019 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 South Hadley - Michael E. Smith Middle School   Regular School No Middle 05 08 2021   grade_6 91 3 25 1   4     0   1   59 66 *                     125.0 91 3 25 1   4     0   1   59 66                 125
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
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
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
1675246 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_6 4 0 123 0   0     0   0   68 59 *                     127.0 4 0 123 0   0     0   0   68 59                 127
1677984 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 Southborough - P Brent Trottier   Regular School No Middle 06 08 2021   grade_6 85 2 5 0   28     0   7   65 62 *                     127.0 85 2 5 0   28     0   7   65 62                 127
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
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
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
1673414 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_6 14 92 17 0   3     2   3   51 80 *                     131.0 14 92 17 0   3     2   3   51 80                 131
1675919 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden - Salemwood   Regular School No Elementary KG 08 2021   grade_6 27 27 45 0   26     0   6   63 68 *                     131.0 27 27 45 0   26     0   6   63 68                 131
1675297 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence - Frost Middle School   Regular School No Middle 05 08 2021   grade_6 13 0 114 0   4     0   1   64 68 *                     132.0 13 0 114 0   4     0   1   64 68                 132
1676284 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Millbury - Raymond E. Shaw Elementary   Regular School No Middle 04 06 2021   grade_6 99 8 5 0   9     1   10   66 66 *                     132.0 99 8 5 0   9     1   10   66 66                 132
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
1673822 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_6 7 6 117 0   1     0   2   64 69 *                     133.0 7 6 117 0   1     0   2   64 69                 133
1673926 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton - Clinton Middle School   Regular School No Middle 05 08 2021   grade_6 67 5 57 0   0     0   4   69 64 *                     133.0 67 5 57 0   0     0   4   69 64                 133
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
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
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
1673223 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   grade_6 9 20 20 0   83     0   4   67 69 *                     136.0 9 20 20 0   83     0   4   67 69                 136
1675250 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence - Parthum Middle School   Regular School No Middle 05 08 2021   grade_6 5 0 130 0   1     0   0   63 73 *                     136.0 5 0 130 0   1     0   0   63 73                 136
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
1677998 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge - Southbridge Middle School   Regular School No Middle 06 08 2021   grade_6 50 1 80 1   2     0   2   70 66 *                     136.0 50 1 80 1   2     0   2   70 66                 136

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