Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by rowid descending

View and edit SQL

year

grade

  • grade_6 · 3,938
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
2238288 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 2018   grade_6 18 1 1 0   0     0   0   9 11                       20.0 18 1 1 0   0     0   0   9 11                 20
2238278 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 2018   grade_6 42 4 0 0   2     0   3   30 21                       51.0 42 4 0 0   2     0   3   30 21                 51
2238272 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 2018   grade_6 0 55 13 0   1     0   1   33 37                       70.0 0 55 13 0   1     0   1   33 37                 70
2238258 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 2018   grade_6 3 22 32 0   20     0   2   41 38                       79.0 3 22 32 0   20     0   2   41 38                 79
2238247 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 2018   grade_6 21 3 9 0   0     0   2   13 22                       35.0 21 3 9 0   0     0   2   13 22                 35
2238237 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 2018   grade_6 1 2 49 0   0     0   0   24 28                       52.0 1 2 49 0   0     0   0   24 28                 52
2238226 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 2018   grade_6 7 1 67 0   0     0   0   35 40                       75.0 7 1 67 0   0     0   0   35 40                 75
2238211 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 2018   grade_6 23 1 4 0   0     0   4   17 15                       32.0 23 1 4 0   0     0   4   17 15                 32
2238197 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 2018   grade_6 30 38 24 0   4     0   3   51 48                       99.0 30 38 24 0   4     0   3   51 48                 99
2238192 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 2018   grade_6 34 0 4 0   10     0   2   18 32                       50.0 34 0 4 0   10     0   2   18 32                 50
2238178 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 2018   grade_6 47 61 10 0   13     0   5   67 69                       136.0 47 61 10 0   13     0   5   67 69                 136
2238164 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 2018   grade_6 29 61 18 0   4     1   2   55 60                       115.0 29 61 18 0   4     1   2   55 60                 115
2238153 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District): Neighborhood House Charter School   Regular School Yes Other PK 09 2018   grade_6 16 31 9 1   1     0   5   36 27                       63.0 16 31 9 1   1     0   5   36 27                 63
2238138 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 2018   grade_6 28 43 51 0   5     0   3   67 63                       130.0 28 43 51 0   5     0   3   67 63                 130
2238128 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 2018   grade_6 2 0 31 0   0     0   0   9 24                       33.0 2 0 31 0   0     0   0   9 24                 33
2238117 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 2018   grade_6 5 22 14 0   0     0   0   12 29                       41.0 5 22 14 0   0     0   0   12 29                 41
2238102 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 2018   grade_6 0 18 2 0   0     0   0   9 11                       20.0 0 18 2 0   0     0   0   9 11                 20
2238082 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 2018   grade_6 6 19 7 0   3     0   2   19 18                       37.0 6 19 7 0   3     0   2   19 18                 37
2238074 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 2018   grade_6 70 1 12 0   7     0   10   46 54                       100.0 70 1 12 0   7     0   10   46 54                 100
2238069 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 2018   grade_6 70 1 3 0   1     0   5   40 40                       80.0 70 1 3 0   1     0   5   40 40                 80
2238067 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 06 2018   grade_6 1 0 31 0   0     0   0   18 14                       32.0 1 0 31 0   0     0   0   18 14                 32
2238052 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 2018   grade_6 102 0 8 0   21     0   13   77 67                       144.0 102 0 8 0   21     0   13   77 67                 144
2238044 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 2018   grade_6 4 19 96 0   2     0   1   63 59                       122.0 4 19 96 0   2     0   1   63 59                 122
2238034 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_6 10 102 72 0   3     0   1   89 99                       188.0 10 102 72 0   3     0   1   89 99                 188
2238021 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 06 2018   grade_6 1 0 34 0   1     0   0   16 20                       36.0 1 0 34 0   1     0   0   16 20                 36
2238008 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 2018   grade_6 2 32 4 0   0     0   0   14 24                       38.0 2 32 4 0   0     0   0   14 24                 38
2237997 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 2018   grade_6 2 44 14 0   0     0   0   30 30                       60.0 2 44 14 0   0     0   0   30 30                 60
2237993 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 2018   grade_6 78 9 26 0   7     0   19   72 67                       139.0 78 9 26 0   7     0   19   72 67                 139
2237991 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 06 2018   grade_6 0 23 10 0   1     0   1   18 17                       35.0 0 23 10 0   1     0   1   18 17                 35
2237976 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 2018   grade_6 1 48 33 0   0     0   5   44 43                       87.0 1 48 33 0   0     0   5   44 43                 87
2237968 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 2018   grade_6 39 8 7 0   3     0   3   36 24                       60.0 39 8 7 0   3     0   3   36 24                 60
2237953 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 2018   grade_6 6 42 27 0   1     0   0   34 42                       76.0 6 42 27 0   1     0   0   34 42                 76
2237944 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 2018   grade_6 4 16 23 0   1     0   1   27 18                       45.0 4 16 23 0   1     0   1   27 18                 45
2237937 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_6 20 6 140 0   3     1   2   92 80                       172.0 20 6 140 0   3     1   2   92 80                 172
2237932 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 2018   grade_6 19 6 18 0   0     0   3   21 25                       46.0 19 6 18 0   0     0   3   21 25                 46
2237911 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham: Charles E Roderick   Regular School No Middle 04 06 2018   grade_6 134 2 9 0   6     0   5   85 71                       156.0 134 2 9 0   6     0   5   85 71                 156
2237866 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   grade_6 27 3 10 0   6     0   2   22 26                       48.0 27 3 10 0   6     0   2   22 26                 48
2237862 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_6 17 21 41 1   7     0   6   42 51                       93.0 17 21 41 1   7     0   6   42 51                 93
2237840 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_6 13 14 27 0   3     0   5   29 33                       62.0 13 14 27 0   3     0   5   29 33                 62
2237831 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   grade_6 25 4 3 0   3     0   4   17 22                       39.0 25 4 3 0   3     0   4   17 22                 39
2237822 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Worcester: Union Hill School   Regular School No Elementary KG 06 2018   grade_6 10 5 39 0   6     0   1   35 26                       61.0 10 5 39 0   6     0   1   35 26                 61
2237814 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Worcester: Thorndyke Road   Regular School No Elementary KG 06 2018   grade_6 23 6 11 0   1     0   2   17 26                       43.0 23 6 11 0   1     0   2   17 26                 43
2237806 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester: Tatnuck   Regular School No Elementary PK 06 2018   grade_6 15 12 10 0   3     0   1   15 26                       41.0 15 12 10 0   3     0   1   15 26                 41
2237797 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester: Worcester Arts Magnet School   Regular School No Elementary PK 06 2018   grade_6 23 5 7 0   1     0   1   18 19                       37.0 23 5 7 0   1     0   1   18 19                 37
2237788 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Worcester: Roosevelt   Regular School No Elementary PK 06 2018   grade_6 24 13 29 0   2     0   2   26 44                       70.0 24 13 29 0   2     0   2   26 44                 70
2237779 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Worcester: Rice Square   Regular School No Elementary KG 06 2018   grade_6 12 8 14 0   5     0   3   20 22                       42.0 12 8 14 0   5     0   3   20 22                 42
2237771 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Worcester: Quinsigamond   Regular School No Elementary PK 06 2018   grade_6 24 20 34 0   7     0   4   40 49                       89.0 24 20 34 0   7     0   4   40 49                 89
2237762 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Worcester: Norrback Avenue   Regular School No Elementary PK 06 2018   grade_6 29 23 21 0   1     0   0   41 33                       74.0 29 23 21 0   1     0   0   41 33                 74
2237753 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Worcester: Nelson Place   Regular School No Elementary PK 06 2018   grade_6 52 8 12 0   3     0   2   37 40                       77.0 52 8 12 0   3     0   2   37 40                 77
2237744 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Worcester: Midland Street   Regular School No Elementary KG 06 2018   grade_6 17 4 4 0   2     0   1   17 11                       28.0 17 4 4 0   2     0   1   17 11                 28
2237736 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Worcester: Francis J McGrath Elementary   Regular School No Elementary KG 06 2018   grade_6 8 5 14 1   0     0   0   15 13                       28.0 8 5 14 1   0     0   0   15 13                 28
2237728 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 Worcester: May Street   Regular School No Elementary KG 06 2018   grade_6 21 4 12 0   5     0   5   26 21                       47.0 21 4 12 0   5     0   5   26 21                 47
2237720 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester: Lincoln Street   Regular School No Elementary KG 06 2018   grade_6 6 7 22 0   1     0   1   20 17                       37.0 6 7 22 0   1     0   1   20 17                 37
2237712 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Worcester: Lake View   Regular School No Elementary KG 06 2018   grade_6 11 2 7 0   5     0   3   15 13                       28.0 11 2 7 0   5     0   3   15 13                 28
2237704 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_6 7 10 18 0   0     0   1   17 19                       36.0 7 10 18 0   0     0   1   17 19                 36
2237695 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Worcester: Heard Street   Regular School No Elementary KG 06 2018   grade_6 16 6 7 0   6     0   2   16 21                       37.0 16 6 7 0   6     0   2   16 21                 37
2237687 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Worcester: Grafton Street   Regular School No Elementary KG 06 2018   grade_6 8 8 16 0   3     0   1   21 15                       36.0 8 8 16 0   3     0   1   21 15                 36
2237679 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Worcester: Gates Lane   Regular School No Elementary PK 06 2018   grade_6 26 18 36 0   10     0   1   58 33                       91.0 26 18 36 0   10     0   1   58 33                 91
2237670 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Worcester: Goddard School/Science Technical   Regular School No Elementary PK 06 2018   grade_6 9 8 45 0   6     0   2   36 34                       70.0 9 8 45 0   6     0   2   36 34                 70
2237661 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Worcester: Elm Park Community   Regular School No Elementary KG 06 2018   grade_6 10 13 34 0   1     0   3   34 27                       61.0 10 13 34 0   1     0   3   34 27                 61
2237653 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Worcester: Flagg Street   Regular School No Elementary KG 06 2018   grade_6 41 3 5 0   2     0   2   32 21                       53.0 41 3 5 0   2     0   2   32 21                 53
2237645 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Worcester: Columbus Park   Regular School No Elementary PK 06 2018   grade_6 9 6 29 0   9     0   2   30 25                       55.0 9 6 29 0   9     0   2   30 25                 55
2237636 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Worcester: Clark St Community   Regular School No Elementary PK 06 2018   grade_6 5 5 20 0   1     0   3   16 18                       34.0 5 5 20 0   1     0   3   16 18                 34
2237627 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   grade_6 14 14 29 0   1     0   4   28 34                       62.0 14 14 29 0   1     0   4   28 34                 62
2237618 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   grade_6 4 1 35 0   4     0   0   24 20                       44.0 4 1 35 0   4     0   0   24 20                 44
2237609 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Worcester: Chandler Elementary Community   Regular School No Elementary KG 06 2018   grade_6 5 6 35 0   11     0   0   37 20                       57.0 5 6 35 0   11     0   0   37 20                 57
2237601 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Worcester: Canterbury   Regular School No Elementary PK 06 2018   grade_6 7 5 26 0   10     0   1   26 23                       49.0 7 5 26 0   10     0   1   26 23                 49
2237592 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Worcester: Burncoat Street   Regular School No Elementary KG 06 2018   grade_6 9 6 20 0   1     0   3   21 18                       39.0 9 6 20 0   1     0   3   21 18                 39
2237584 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Worcester: Woodland Academy   Regular School No Elementary KG 06 2018   grade_6 9 12 65 0   10     0   2   47 51                       98.0 9 12 65 0   10     0   2   47 51                 98
2237576 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_6 8 2 10 0   3     0   0   13 10                       23.0 8 2 10 0   3     0   0   13 10                 23
2237568 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Worcester: Belmont Street Community   Regular School No Elementary PK 06 2018   grade_6 7 15 27 1   8     0   0   26 32                       58.0 7 15 27 1   8     0   0   26 32                 58
2237550 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Woburn: Daniel L Joyce Middle School   Regular School No Middle 06 08 2018   grade_6 133 15 21 0   9     0   3   91 90                       181.0 133 15 21 0   9     0   3   91 90                 181
2237546 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_6 105 9 15 1   14     0   6   67 83                       150.0 105 9 15 1   14     0   6   67 83                 150
2237478 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop: Winthrop Middle School   Regular School No Middle 06 08 2018   grade_6 128 1 35 0   3     0   4   97 74                       171.0 128 1 35 0   3     0   4   97 74                 171
2237460 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester: McCall Middle   Regular School No Middle 06 08 2018   grade_6 279 4 14 2   61     0   15   177 198                       375.0 279 4 14 2   61     0   15   177 198                 375
2237410 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon: Murdock Middle School   Regular School No Middle 06 08 2018   grade_6 79 1 6 0   0     0   2   42 46                       88.0 79 1 6 0   0     0   2   42 46                 88
2237391 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington: Wilmington Middle School   Regular School No Middle 06 08 2018   grade_6 241 4 7 1   6     0   10   144 125                       269.0 241 4 7 1   6     0   10   144 125                 269
2237369 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown: Williamstown Elementary   Regular School No Elementary PK 06 2018   grade_6 61 1 4 0   0     0   7   25 48                       73.0 61 1 4 0   0     0   7   25 48                 73
2237360 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg: Anne T. Dunphy School   Regular School No Elementary PK 06 2018   grade_6 30 0 0 0   0     0   0   16 14                       30.0 30 0 0 0   0     0   0   16 14                 30
2237351 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately: Whately Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 1 0   0     0   1   6 12                       18.0 16 0 1 0   0     0   1   6 12                 18
2237337 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Weymouth: Abigail Adams Middle School   Regular School No Middle 05 06 2018   grade_6 352 31 46 2   22     1   15   229 240                       469.0 352 31 46 2   22     1   15   229 240                 469
2237290 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Weymouth: Maria Weston Chapman Middle School   Regular School No Middle 05 08 2018   grade_6 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2237272 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 Westwood: E W Thurston Middle   Regular School No Middle 06 08 2018   grade_6 207 8 12 0   35     0   9   150 121                       271.0 207 8 12 0   35     0   9   150 121                 271
2237227 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2237211 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield: West Springfield Middle   Regular School No Middle 06 08 2018   grade_6 206 9 53 0   20     0   8   151 145                       296.0 206 9 53 0   20     0   8   151 145                 296
2237166 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport: Westport Elementary   Regular School No Elementary 03 06 2018   grade_6 138 0 8 0   0     0   7   79 74                       153.0 138 0 8 0   0     0   7   79 74                 153
2237149 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston: Weston Middle   Regular School No Middle 06 08 2018   grade_6 108 9 8 0   24     0   11   82 78                       160.0 108 9 8 0   24     0   11   82 78                 160
2237132 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton: Westhampton Elementary School   Regular School No Elementary PK 06 2018   grade_6 16 0 0 0   0     0   1   9 8                       17.0 16 0 0 0   0     0   1   9 8                 17
2237116 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Westford: Stony Brook School   Regular School No Middle 06 08 2018   grade_6 142 3 0 0   52     0   7   100 104                       204.0 142 3 0 0   52     0   7   100 104                 204
2237112 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford: Blanchard Middle   Regular School No Middle 06 08 2018   grade_6 113 0 5 0   56     0   5   90 89                       179.0 113 0 5 0   56     0   5   90 89                 179
2237072 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield: South Middle School   Regular School No Middle 06 08 2018   grade_6 145 3 34 0   5     0   2   99 90                       189.0 145 3 34 0   5     0   2   99 90                 189
2237068 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 Westfield: North Middle School   Regular School No Middle 06 08 2018   grade_6 203 5 24 0   5     0   8   120 125                       245.0 203 5 24 0   5     0   8   120 125                 245
2237008 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 West Bridgewater: Howard School   Regular School No Middle 04 06 2018   grade_6 76 6 4 1   1     0   5   45 48                       93.0 76 6 4 1   1     0   5   45 48                 93
2236991 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston: West Boylston Junior/Senior High   Regular School No High 06 12 2018   grade_6 59 1 6 0   1     0   1   39 29                       68.0 59 1 6 0   1     0   1   39 29                 68
2236973 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Westborough: Mill Pond School   Regular School No Middle 04 06 2018   grade_6 182 4 21 0   91     1   10   154 155                       309.0 182 4 21 0   91     1   10   154 155                 309
2236938 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley: Wellesley Middle   Regular School No Middle 06 08 2018   grade_6 270 14 33 0   45     0   17   184 195                       379.0 270 14 33 0   45     0   17   184 195                 379
2236879 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster: Webster Middle School   Regular School No Middle 05 08 2018   grade_6 81 8 29 0   3     0   11   69 63                       132.0 81 8 29 0   3     0   11   69 63                 132
2236862 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland: Wayland Middle School   Regular School No Middle 06 08 2018   grade_6 150 17 7 0   34     0   13   110 111                       221.0 150 17 7 0   34     0   13   110 111                 221
2236832 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown: Watertown Middle   Regular School No Middle 06 08 2018   grade_6 119 9 26 0   14     0   7   91 84                       175.0 119 9 26 0   14     0   7   91 84                 175
2236794 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham: Wareham Middle   Regular School No Middle 05 08 2018   grade_6 128 15 21 1   2     1   18   101 85                       186.0 128 15 21 1   2     1   18   101 85                 186

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