enrollments

Data source: Big Local News · About: Big Local

572 rows where grade = "grade_6", state = "MA" and year = 2019 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 572 ✖

grade ✖

  • grade_6 · 572 ✖
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
2041138 2041138 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2019   grade_6 94 1 0 0   5     0   0   48 52                       100.0 94 1 0 0   5     0   0   48 52                 100
2041543 2041543 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2019   grade_6 42 32 8 0   9     0   9   49 51                       100.0 42 32 8 0   9     0   9   49 51                 100
2043891 2043891 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2019   grade_6 81 3 13 0   1     0   2   59 41                       100.0 81 3 13 0   1     0   2   59 41                 100
2047653 2047653 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_6 75 3 7 0   14     0   1   53 47                       100.0 75 3 7 0   14     0   1   53 47                 100
2047766 2047766 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2019   grade_6 53 33 8 0   1     0   5   57 43                       100.0 53 33 8 0   1     0   5   57 43                 100
2040452 2040452 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_6 10 2 88 0   1     0   0   53 48                       101.0 10 2 88 0   1     0   0   53 48                 101
2041540 2041540 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2019   grade_6 30 34 12 0   17     1   7   41 60                       101.0 30 34 12 0   17     1   7   41 60                 101
2041932 2041932 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2019   grade_6 93 1 3 0   2     0   2   43 58                       101.0 93 1 3 0   2     0   2   43 58                 101
2040524 2040524 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_6 24 37 33 1   6     0   1   44 58                       102.0 24 37 33 1   6     0   1   44 58                 102
2041341 2041341 MA Middlesex   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2019   grade_6 59 4 9 0   22     0   8   52 50                       102.0 59 4 9 0   22     0   8   52 50                 102
2041537 2041537 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2019   grade_6 49 19 14 1   10     0   9   58 44                       102.0 49 19 14 1   10     0   9   58 44                 102
2043707 2043707 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_6 31 12 17 0   40     0   3   55 48                       103.0 31 12 17 0   40     0   3   55 48                 103
2047383 2047383 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2019   grade_6 29 26 38 0   9     0   1   51 52                       103.0 29 26 38 0   9     0   1   51 52                 103
2048966 2048966 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_6 84 2 10 1   2     0   4   52 51                       103.0 84 2 10 1   2     0   4   52 51                 103
2046060 2046060 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2019   grade_6 20 21 63 0   0     0   0   44 60                       104.0 20 21 63 0   0     0   0   44 60                 104
2039832 2039832 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_6 94 0 5 0   1     0   5   57 48                       105.0 94 0 5 0   1     0   5   57 48                 105
2040704 2040704 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_6 3 52 49 0   1     1   0   50 56                       106.0 3 52 49 0   1     1   0   50 56                 106
2043352 2043352 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_6 92 1 2 0   7     0   4   50 56                       106.0 92 1 2 0   7     0   4   50 56                 106
2043734 2043734 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2019   grade_6 40 19 14 0   27     0   6   54 52                       106.0 40 19 14 0   27     0   6   54 52                 106
2047633 2047633 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_6 75 2 6 1   13     0   9   53 53                       106.0 75 2 6 1   13     0   9   53 53                 106
2043102 2043102 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_6 1 0 106 0   0     0   0   57 50                       107.0 1 0 106 0   0     0   0   57 50                 107
2042157 2042157 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_6 18 19 65 0   3     0   4   50 59                       109.0 18 19 65 0   3     0   4   50 59                 109
2047078 2047078 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2019   grade_6 88 5 7 0   5     1   3   57 52                       109.0 88 5 7 0   5     1   3   57 52                 109
2049325 2049325 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_6 5 100 4 0   0     0   0   51 58                       109.0 5 100 4 0   0     0   0   51 58                 109
2042136 2042136 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_6 2 5 3 0   0     0   1   10 1                       11.0 2 5 3 0   0     0   1   10 1                 11
2047990 2047990 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_6 89 3 12 0   0     0   6   51 59                       110.0 89 3 12 0   0     0   6   51 59                 110
2049309 2049309 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_6 71 8 24 0   1     0   6   57 53                       110.0 71 8 24 0   1     0   6   57 53                 110
2040937 2040937 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2019   grade_6 5 52 51 0   1     0   2   50 61                       111.0 5 52 51 0   1     0   2   50 61                 111
2045243 2045243 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2019   grade_6 73 11 8 0   18     0   1   58 53                       111.0 73 11 8 0   18     0   1   58 53                 111
2043342 2043342 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2019   grade_6 80 3 8 0   15     1   5   57 55                       112.0 80 3 8 0   15     1   5   57 55                 112
2041068 2041068 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_6 12 58 36 0   2     0   5   62 51                       113.0 12 58 36 0   2     0   5   62 51                 113
2041546 2041546 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No Middle 06 08 2019   grade_6 44 30 8 0   21     0   10   58 55                       113.0 44 30 8 0   21     0   10   58 55                 113
2043085 2043085 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_6 4 0 108 0   0     0   1   53 60                       113.0 4 0 108 0   0     0   1   53 60                 113
2043372 2043372 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 07 2019   grade_6 23 18 45 0   24     0   3   59 54                       113.0 23 18 45 0   24     0   3   59 54                 113
2046435 2046435 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2019   grade_6 92 6 9 0   6     0   1   63 51                       114.0 92 6 9 0   6     0   1   63 51                 114
2043175 2043175 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2019   grade_6 86 8 13 0   3     0   5   66 49                       115.0 86 8 13 0   3     0   5   66 49                 115
2046275 2046275 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2019   grade_6 106 1 2 0   1     0   5   56 59                       115.0 106 1 2 0   1     0   5   56 59                 115
2048944 2048944 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2019   grade_6 108 1 3 0   1     0   2   54 61                       115.0 108 1 3 0   1     0   2   54 61                 115
2049368 2049368 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_6 62 12 27 0   1     1   12   51 64                       115.0 62 12 27 0   1     1   12   51 64                 115
2042032 2042032 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2019   grade_6 91 1 18 1   5     0   0   56 60                       116.0 91 1 18 1   5     0   0   56 60                 116
2049137 2049137 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2019   grade_6 104 1 7 0   3     0   1   58 58                       116.0 104 1 7 0   3     0   1   58 58                 116
2044558 2044558 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2019   grade_6 97 2 7 0   6     0   5   56 61                       117.0 97 2 7 0   6     0   5   56 61                 117
2046097 2046097 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_6 4 12 100 1   1     0   0   65 53                       118.0 4 12 100 1   1     0   0   65 53                 118
2046103 2046103 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2019   grade_6 14 23 72 0   6     0   3   57 61                       118.0 14 23 72 0   6     0   3   57 61                 118
2046591 2046591 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2019   grade_6 104 3 7 0   0     0   4   59 59                       118.0 104 3 7 0   0     0   4   59 59                 118
2046902 2046902 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2019   grade_6 104 0 4 0   1     0   9   72 46                       118.0 104 0 4 0   1     0   9   72 46                 118
2041783 2041783 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_6 112 3 0 0   1     0   4   71 49                       120.0 112 3 0 0   1     0   4   71 49                 120
2042596 2042596 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_6 94 1 7 0   14     0   4   69 51                       120.0 94 1 7 0   14     0   4   69 51                 120
2047736 2047736 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_6 22 63 34 0   1     0   0   57 63                       120.0 22 63 34 0   1     0   0   57 63                 120
2040571 2040571 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2019   grade_6 6 35 67 1   8     1   3   49 72                       121.0 6 35 67 1   8     1   3   49 72                 121
2042503 2042503 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_6 101 5 5 0   8     0   2   68 53                       121.0 101 5 5 0   8     0   2   68 53                 121
2044908 2044908 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   grade_6 98 4 11 0   1     0   7   49 72                       121.0 98 4 11 0   1     0   7   49 72                 121
2042500 2042500 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_6 111 2 4 1   4     0   0   70 52                       122.0 111 2 4 1   4     0   0   70 52                 122
2046231 2046231 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   grade_6 108 3 5 1   0     1   4   73 49                       122.0 108 3 5 1   0     1   4   73 49                 122
2047626 2047626 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   grade_6 9 22 79 0   8     0   4   67 55                       122.0 9 22 79 0   8     0   4   67 55                 122
2048367 2048367 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2019   grade_6 110 2 8 0   1     0   1   61 61                       122.0 110 2 8 0   1     0   1   61 61                 122
2048699 2048699 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2019   grade_6 105 3 7 0   0     1   6   64 58                       122.0 105 3 7 0   0     1   6   64 58                 122
2041598 2041598 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_6 115 0 6 0   1     1   0   70 53                       123.0 115 0 6 0   1     1   0   70 53                 123
2044190 2044190 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2019   grade_6 60 11 44 0   3     0   5   65 58                       123.0 60 11 44 0   3     0   5   65 58                 123
2043029 2043029 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2019   grade_6 113 0 5 0   3     0   3   59 65                       124.0 113 0 5 0   3     0   3   59 65                 124
2043323 2043323 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2019   grade_6 107 1 5 0   7     0   4   67 57                       124.0 107 1 5 0   7     0   4   67 57                 124
2048286 2048286 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2019   grade_6 114 2 5 0   0     0   3   70 54                       124.0 114 2 5 0   0     0   3   70 54                 124
2040912 2040912 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2019   grade_6 2 54 54 0   11     0   4   68 57                       125.0 2 54 54 0   11     0   4   68 57                 125
2042640 2042640 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2019   grade_6 94 2 21 0   1     0   7   67 58                       125.0 94 2 21 0   1     0   7   67 58                 125
2043532 2043532 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2019   grade_6 107 2 14 0   0     0   3   64 62                       126.0 107 2 14 0   0     0   3   64 62                 126
2043716 2043716 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_6 30 24 42 0   20     0   10   68 58                       126.0 30 24 42 0   20     0   10   68 58                 126
2042132 2042132 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2019   grade_6 32 24 61 0   8     0   2   61 66                       127.0 32 24 61 0   8     0   2   61 66                 127
2044026 2044026 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2019   grade_6 64 1 53 0   4     0   5   56 71                       127.0 64 1 53 0   4     0   5   56 71                 127
2048574 2048574 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2019   grade_6 124 0 0 0   2     0   1   59 68                       127.0 124 0 0 0   2     0   1   59 68                 127
2045330 2045330 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2019   grade_6 120 1 3 0   1     0   3   70 58                       128.0 120 1 3 0   1     0   3   70 58                 128
2049082 2049082 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2019   grade_6 113 2 6 0   4     0   3   65 63                       128.0 113 2 6 0   4     0   3   65 63                 128
2043744 2043744 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2019   grade_6 21 29 45 0   28     0   6   56 73                       129.0 21 29 45 0   28     0   6   56 73                 129
2042368 2042368 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_6 12 1 0 0   0     0   0   7 6                       13.0 12 1 0 0   0     0   0   7 6                 13
2045692 2045692 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   grade_6 10 1 1 0   0     0   1   8 5                       13.0 10 1 1 0   0     0   1   8 5                 13
2046086 2046086 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_6 0 2 10 0   0     0   1   11 2                       13.0 0 2 10 0   0     0   1   11 2                 13
2048394 2048394 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   grade_6 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2041660 2041660 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_6 9 7 110 0   1     0   3   58 72                       130.0 9 7 110 0   1     0   3   58 72                 130
2046449 2046449 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2019   grade_6 120 0 5 2   2     0   1   67 63                       130.0 120 0 5 2   2     0   1   67 63                 130
2046521 2046521 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2019   grade_6 106 5 11 0   5     0   3   62 68                       130.0 106 5 11 0   5     0   3   62 68                 130
2047711 2047711 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_6 25 33 57 0   7     0   8   69 61                       130.0 25 33 57 0   7     0   8   69 61                 130
2040380 2040380 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_6 20 25 78 0   3     0   5   64 67                       131.0 20 25 78 0   3     0   5   64 67                 131
2041247 2041247 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_6 18 86 17 1   2     0   7   63 68                       131.0 18 86 17 1   2     0   7   63 68                 131
2042148 2042148 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2019   grade_6 37 20 67 1   2     0   4   65 66                       131.0 37 20 67 1   2     0   4   65 66                 131
2043136 2043136 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_6 14 4 104 0   8     0   2   69 63                       132.0 14 4 104 0   8     0   2   69 63                 132
2039949 2039949 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_6 59 3 17 1   53     0   0   73 60                       133.0 59 3 17 1   53     0   0   73 60                 133
2048767 2048767 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2019   grade_6 122 2 1 0   5     0   3   72 61                       133.0 122 2 1 0   5     0   3   72 61                 133
2048503 2048503 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2019   grade_6 121 1 6 0   3     0   4   67 68                       135.0 121 1 6 0   3     0   4   67 68                 135
2040056 2040056 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2019   grade_6 87 11 19 0   12     0   7   64 72                       136.0 87 11 19 0   12     0   7   64 72                 136
2042751 2042751 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_6 72 5 47 1   4     1   6   72 64                       136.0 72 5 47 1   4     1   6   72 64                 136
2044016 2044016 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2019   grade_6 95 2 27 0   3     0   9   69 67                       136.0 95 2 27 0   3     0   9   69 67                 136
2045808 2045808 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2019   grade_6 102 1 8 0   17     0   8   68 68                       136.0 102 1 8 0   17     0   8   68 68                 136
2040710 2040710 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2019   grade_6 28 40 57 0   8     0   4   69 68                       137.0 28 40 57 0   8     0   4   69 68                 137
2047578 2047578 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2019   grade_6 138 0 1 0   0     0   0   72 67                       139.0 138 0 1 0   0     0   0   72 67                 139
2043146 2043146 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_6 2 0 11 0   0     0   1   11 3                       14.0 2 0 11 0   0     0   1   11 3                 14
2045018 2045018 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2019   grade_6 12 0 2 0   0     0   0   6 8                       14.0 12 0 2 0   0     0   0   6 8                 14
2048469 2048469 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2019   grade_6 13 0 0 0   0     0   1   7 7                       14.0 13 0 0 0   0     0   1   7 7                 14
2041768 2041768 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2019   grade_6 94 7 34 0   1     1   3   79 61                       140.0 94 7 34 0   1     1   3   79 61                 140
2043871 2043871 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_6 106 4 5 9   4     0   12   68 72                       140.0 106 4 5 9   4     0   12   68 72                 140
2048338 2048338 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2019   grade_6 128 0 5 0   0     0   7   72 68                       140.0 128 0 5 0   0     0   7   72 68                 140
2043467 2043467 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2019   grade_6 37 13 44 0   39     0   8   70 71                       141.0 37 13 44 0   39     0   8   70 71                 141

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