Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_6 · 4,038
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id ▼ school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1681066 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin - Quabbin Regional Middle School   Regular School No Middle 06 08 2021   grade_6 146 0 13 1   2     0   4   74 92 *                     166.0 146 0 13 1   2     0   4   74 92                 166
744732 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_6 29 0 0 0   0     0   1   22 8                       30 29 0 0 0   0     0   1   22 8                 30
941557 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2016   grade_6 35 0 2 0   0     0   0   24 13                       37 35 0 2 0   0     0   0   24 13                 37
1132627 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_6 26 0 2 0   0     0   1   17 12                       29 26 0 2 0   0     0   1   17 12                 29
1373796 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_6 28 0 4 0   0     0   0   21 11 *                     32.0 28 0 4 0   0     0   0   21 11                 32
2048862 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2019   grade_6 25 1 3 0   0     0   0   17 12                       29.0 25 1 3 0   0     0   0   17 12                 29
2239452 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin: Hardwick Elementary   Regular School No Elementary KG 06 2018   grade_6 33 0 2 0   0     0   1   12 24                       36.0 33 0 2 0   0     0   1   12 24                 36
744739 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_6 58 0 3 0   0     0   0   27 34                       61 58 0 3 0   0     0   0   27 34                 61
941564 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2016   grade_6 39 0 1 0   0     0   0   19 21                       40 39 0 1 0   0     0   0   19 21                 40
1132635 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_6 47 0 1 0   0     0   0   15 33                       48 47 0 1 0   0     0   0   15 33                 48
1373803 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   grade_6 46 0 3 0   0     0   0   19 30 *                     49.0 46 0 3 0   0     0   0   19 30                 49
2048869 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2019   grade_6 43 1 0 0   1     0   1   22 24                       46.0 43 1 0 0   1     0   1   22 24                 46
2239460 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Quabbin: Hubbardston Center   Regular School No Elementary KG 06 2018   grade_6 41 0 3 0   0     0   0   24 20                       44.0 41 0 3 0   0     0   0   24 20                 44
744747 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_6 46 0 1 0   0     0   0   21 26                       47 46 0 1 0   0     0   0   21 26                 47
941572 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2016   grade_6 39 0 4 0   1     0   0   23 21                       44 39 0 4 0   1     0   0   23 21                 44
1132645 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_6 34 0 1 0   1     0   1   22 15                       37 34 0 1 0   1     0   1   22 15                 37
1373810 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_6 27 0 3 0   0     0   0   16 14 *                     30.0 27 0 3 0   0     0   0   16 14                 30
2048876 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_6 28 2 0 0   0     0   0   11 19                       30.0 28 2 0 0   0     0   0   11 19                 30
2239469 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   grade_6 26 0 0 0   0     0   0   13 13                       26.0 26 0 0 0   0     0   0   13 13                 26
744754 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_6 54 0 0 0   1     0   1   21 35                       56 54 0 0 0   1     0   1   21 35                 56
941579 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2016   grade_6 57 0 3 0   0     0   1   25 36                       61 57 0 3 0   0     0   1   25 36                 61
1132653 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_6 50 0 2 0   0     0   4   25 31                       56 50 0 2 0   0     0   4   25 31                 56
1373818 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   grade_6 57 0 5 0   1     1   0   37 27 *                     64.0 57 0 5 0   1     1   0   37 27                 64
2048884 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2019   grade_6 48 0 4 0   0     0   1   27 26                       53.0 48 0 4 0   0     0   1   27 26                 53
2239478 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Quabbin: Ruggles Lane   Regular School No Elementary PK 06 2018   grade_6 70 0 1 0   1     0   1   36 37                       73.0 70 0 1 0   1     0   1   36 37                 73
744846 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Junior High   Regular School No 2 06 08 2015   grade_6 84 1 6 1   0     0   2   42 52                       94 84 1 6 1   0     0   2   42 52                 94
941667 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No 2 05 08 2016   grade_6 74 0 9 0   1     0   4   43 45                       88 74 0 9 0   1     0   4   43 45                 88
1132760 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_6 87 1 9 0   1     0   0   57 41                       98 87 1 9 0   1     0   0   57 41                 98
1373893 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_6 87 4 16 0   2     0   5   61 53 *                     114.0 87 4 16 0   2     0   5   61 53                 114
1681141 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield - Knox Trail Middle School   Regular School No Middle 05 08 2021   grade_6 75 1 10 0   3     0   1   50 40 *                     90.0 75 1 10 0   3     0   1   50 40                 90
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
2239575 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield: Knox Trail Middle School   Regular School No Middle 05 08 2018   grade_6 84 2 16 0   1     0   7   68 42                       110.0 84 2 16 0   1     0   7   68 42                 110
744838 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_6 24 1 3 0   0     0   0   14 14                       28 24 1 3 0   0     0   0   14 14                 28
941660 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 20 0 1 0   0     0   2   12 11                       23 20 0 1 0   0     0   2   12 11                 23
1132751 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 25 0 3 0   1     0   2   18 13                       31 25 0 3 0   1     0   2   18 13                 31
1373886 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 25 0 1 0   0     0   2   13 15 *                     28.0 25 0 1 0   0     0   2   13 15                 28
1681134 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield - East Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_6 12 0 2 1   0     0   2   8 9 *                     17.0 12 0 2 1   0     0   2   8 9                 17
2048959 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_6 18 0 1 0   0     0   1   9 11                       20.0 18 0 1 0   0     0   1   9 11                 20
2239566 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield: East Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 17 0 1 0   0     0   0   12 6                       18.0 17 0 1 0   0     0   0   12 6                 18
744824 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_6 94 1 7 0   0     0   1   57 46                       103 94 1 7 0   0     0   1   57 46                 103
744820 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_6 12 0 1 0   0     1   1   7 8                       15 12 0 1 0   0     1   1   7 8                 15
941646 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No 1 03 06 2016   grade_6 107 4 2 0   0     0   2   56 59                       115 107 4 2 0   0     0   2   56 59                 115
1132735 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_6 90 3 3 0   2     0   1   49 50                       99 90 3 3 0   2     0   1   49 50                 99
1373872 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2020   grade_6 104 6 6 0   1     0   4   56 65 *                     121.0 104 6 6 0   1     0   4   56 65                 121
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
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
2239550 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 2018   grade_6 93 2 6 0   0     0   4   54 51                       105.0 93 2 6 0   0     0   4   54 51                 105
941642 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No 1 KG 06 2016   grade_6 14 0 0 0   0     0   0   7 7                       14 14 0 0 0   0     0   0   7 7                 14
1132730 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_6 12 0 0 0   0     0   0   5 7                       12 12 0 0 0   0     0   0   5 7                 12
744141 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_6 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
940975 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2016   grade_6 24 0 0 0   1     0   1   9 17                       26 24 0 0 0   1     0   1   9 17                 26
1131940 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   11 9                       20 19 0 1 0   0     0   0   11 9                 20
1680467 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen - New Hingham Regional Elementary   Regular School No Elementary PK 06 2021   grade_6 13 0 1 1   0     0   0   7 8 *                     15.0 13 0 1 1   0     0   0   7 8                 15
2048265 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   grade_6 19 1 0 0   0     0   0   13 7                       20.0 19 1 0 0   0     0   0   13 7                 20
2238770 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen: New Hingham Regional Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 0 0   0     0   0   6 10                       16.0 16 0 0 0   0     0   0   6 10                 16
743427 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2015   grade_6 4 47 22 0   0     0   1   36 38                       74 4 47 22 0   0     0   1   36 38                 74
940248 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2016   grade_6 14 45 20 0   0     0   0   34 45                       79 14 45 20 0   0     0   0   34 45                 79
1131126 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_6 5 40 26 0   0     0   6   39 38                       77 5 40 26 0   0     0   6   39 38                 77
1372469 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_6 6 46 22 0   0     0   1   46 29 *                     75.0 6 46 22 0   0     0   1   46 29                 75
1679732 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2021   grade_6 6 49 16 0   1     0   0   36 36 *                     72.0 6 49 16 0   1     0   0   36 36                 72
2047542 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_6 10 43 24 0   1     0   2   39 41                       80.0 10 43 24 0   1     0   2   39 41                 80
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
743475 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_6 0 29 9 0   0     0   0   16 22                       38 0 29 9 0   0     0   0   16 22                 38
940293 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2016   grade_6 1 32 4 0   1     0   0   20 18                       38 1 32 4 0   1     0   0   20 18                 38
1131180 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_6 1 21 8 1   1     0   1   17 16                       33 1 21 8 1   1     0   1   17 16                 33
1372519 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   grade_6 0 36 2 0   0     0   0   19 19 *                     38.0 0 36 2 0   0     0   0   19 19                 38
1679782 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public (District) - Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2021   grade_6 0 35 5 0   0     0   0   20 20 *                     40.0 0 35 5 0   0     0   0   20 20                 40
2047591 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_6 0 42 5 0   1     0   0   27 21                       48.0 0 42 5 0   1     0   0   27 21                 48
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
743518 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2015   grade_6 72 0 5 0   1     0   2   30 50                       80 72 0 5 0   1     0   2   30 50                 80
940339 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2016   grade_6 70 1 4 0   0     0   5   32 48                       80 70 1 4 0   0     0   5   32 48                 80
1131238 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2017   grade_6 71 1 2 0   2     0   4   39 41                       80 71 1 2 0   2     0   4   39 41                 80
1372577 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_6 71 1 4 0   2     0   3   42 39 *                     81.0 71 1 4 0   2     0   3   42 39                 81
1679840 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District) - Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2021   grade_6 80 0 2 0   0     0   2   48 36 *                     84.0 80 0 2 0   0     0   2   48 36                 84
2047649 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2019   grade_6 71 1 4 1   2     0   2   34 47                       81.0 71 1 4 1   2     0   2   34 47                 81
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
743522 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_6 80 3 6 0   8     0   3   52 48                       100 80 3 6 0   8     0   3   52 48                 100
940343 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_6 83 4 1 0   10     0   2   48 52                       100 83 4 1 0   10     0   2   48 52                 100
1131243 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_6 85 2 6 0   6     0   5   60 44                       104 85 2 6 0   6     0   5   60 44                 104
1372581 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_6 75 3 10 1   7     0   4   45 55 *                     100.0 75 3 10 1   7     0   4   45 55                 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
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
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
743567 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2015   grade_6 2 0 46 0   0     0   0   26 22                       48 2 0 46 0   0     0   0   26 22                 48
940390 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_6 2 0 19 0   1     0   0   12 10                       22 2 0 19 0   1     0   0   12 10                 22
1131297 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   grade_6 1 0 18 0   1     0   0   11 9                       20 1 0 18 0   1     0   0   11 9                 20
1372630 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2020   grade_6 0 0 43 0   0     0   0   20 23 *                     43.0 0 0 43 0   0     0   0   20 23                 43
1679893 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District) - Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2021   grade_6 0 0 42 0   0     0   0   25 17 *                     42.0 0 0 42 0   0     0   0   25 17                 42
2047702 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2019   grade_6 3 1 38 0   0     0   0   23 19                       42.0 3 1 38 0   0     0   0   23 19                 42
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
743576 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   grade_6 49 31 38 0   4     0   6   64 64                       128 49 31 38 0   4     0   6   64 64                 128
940399 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_6 34 36 47 0   5     0   12   61 73                       134 34 36 47 0   5     0   12   61 73                 134
1131307 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_6 26 35 52 0   7     0   8   67 61                       128 26 35 52 0   7     0   8   67 61                 128
1372639 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_6 18 41 54 0   12     0   7   68 64 *                     132.0 18 41 54 0   12     0   7   68 64                 132
1679902 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District) - Sabis International Charter School   Regular School Yes Other KG 12 2021   grade_6 17 40 86 0   9     0   5   77 80 *                     157.0 17 40 86 0   9     0   5   77 80                 157
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
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
743599 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2015   grade_6 7 20 12 0   3     0   0   25 17                       42 7 20 12 0   3     0   0   25 17                 42
940422 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   grade_6 9 21 6 2   2     0   0   20 20                       40 9 21 6 2   2     0   0   20 20                 40
1131322 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Elementary PK 08 2017   grade_6 13 27 11 0   4     0   5   34 26                       60 13 27 11 0   4     0   5   34 26                 60

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