Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by district

View and edit SQL

year

grade

  • grade_5 · 6,218
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
743607 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_5 29 65 27 0   7     0   0   61 67                       128 29 65 27 0   7     0   0   61 67                 128
940430 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_5 30 57 30 0   3     0   6   64 62                       126 30 57 30 0   3     0   6   64 62                 126
1131331 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 2017   grade_5 30 61 19 0   5     1   2   57 61                       118 30 61 19 0   5     1   2   57 61                 118
1372664 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 2020   grade_5 22 67 18 0   3     0   6   61 55 *                     116.0 22 67 18 0   3     0   6   61 55                 116
1679928 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_5 28 61 18 0   2     0   6   59 56 *                     115.0 28 61 18 0   2     0   6   59 56                 115
2047735 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_5 14 78 22 0   4     0   0   52 66                       118.0 14 78 22 0   4     0   0   52 66                 118
2238163 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_5 20 62 34 0   2     0   0   57 61                       118.0 20 62 34 0   2     0   0   57 61                 118
735664 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2015   grade_5 146 1 6 0   3     0   0   84 72                       156 146 1 6 0   3     0   0   84 72                 156
932542 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2016   grade_5 157 8 3 0   2     0   3   83 90                       173 157 8 3 0   2     0   3   83 90                 173
1121954 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_5 169 1 7 0   3     0   0   97 83                       180 169 1 7 0   3     0   0   97 83                 180
1364790 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_5 138 5 16 0   5     0   3   96 71 *                     167.0 138 5 16 0   5     0   3   96 71                 167
1672014 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_5 109 7 15 0   5     0   4   58 82 *                     140.0 109 7 15 0   5     0   4   58 82                 140
2039816 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_5 134 4 14 2   4     0   1   85 74                       159.0 134 4 14 2   4     0   1   85 74                 159
2228763 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_5 138 1 8 1   3     0   3   80 74                       154.0 138 1 8 1   3     0   3   80 74                 154
743426 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_5 16 41 19 0   0     0   1   38 39                       77 16 41 19 0   0     0   1   38 39                 77
940247 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_5 4 39 24 0   0     0   7   35 39                       74 4 39 24 0   0     0   7   35 39                 74
1131125 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_5 5 41 32 0   1     0   0   35 44                       79 5 41 32 0   1     0   0   35 44                 79
1372468 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_5 6 43 16 0   1     0   0   31 35 *                     66.0 6 43 16 0   1     0   0   31 35                 66
1679731 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_5 0 34 18 0   0     1   0   28 25 *                     53.0 0 34 18 0   0     1   0   28 25                 53
2047541 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_5 8 49 14 0   0     0   1   46 26                       72.0 8 49 14 0   0     0   1   46 26                 72
2237952 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_5 9 46 23 0   1     0   1   38 42                       80.0 9 46 23 0   1     0   1   38 42                 80
743927 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2015   grade_5 36 1 2 0   17     0   3   32 27                       59 36 1 2 0   17     0   3   32 27                 59
743935 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No 1 PK 06 2015   grade_5 61 0 4 0   28     0   2   43 52                       95 61 0 4 0   28     0   2   43 52                 95
743942 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No 1 KG 06 2015   grade_5 54 1 5 0   4     0   5   35 34                       69 54 1 5 0   4     0   5   35 34                 69
743949 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No 1 KG 06 2015   grade_5 49 0 0 0   13     0   12   44 30                       74 49 0 0 0   13     0   12   44 30                 74
743956 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No 1 KG 06 2015   grade_5 41 1 1 0   26     0   2   37 34                       71 41 1 1 0   26     0   2   37 34                 71
743963 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No 1 KG 06 2015   grade_5 28 0 1 0   42     0   2   32 41                       73 28 0 1 0   42     0   2   32 41                 73
940760 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2016   grade_5 41 3 2 0   20     0   0   34 32                       66 41 3 2 0   20     0   0   34 32                 66
940768 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No 1 PK 06 2016   grade_5 59 2 3 0   23     0   3   48 42                       90 59 2 3 0   23     0   3   48 42                 90
940775 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No 1 KG 06 2016   grade_5 55 0 4 0   12     0   1   38 34                       72 55 0 4 0   12     0   1   38 34                 72
940782 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No 1 KG 06 2016   grade_5 39 1 3 0   26     0   3   37 35                       72 39 1 3 0   26     0   3   37 35                 72
940789 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No 1 KG 06 2016   grade_5 37 0 1 0   33     0   1   42 30                       72 37 0 1 0   33     0   1   42 30                 72
940796 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No 1 KG 06 2016   grade_5 28 1 0 0   42     0   1   34 38                       72 28 1 0 0   42     0   1   34 38                 72
1131691 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   grade_5 37 2 2 0   26     0   3   40 30                       70 37 2 2 0   26     0   3   40 30                 70
1131699 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   grade_5 49 0 5 0   11     0   4   43 26                       69 49 0 5 0   11     0   4   43 26                 69
1131707 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   grade_5 44 4 7 1   8     0   5   37 32                       69 44 4 7 1   8     0   5   37 32                 69
1131715 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   grade_5 48 0 4 0   12     0   4   38 30                       68 48 0 4 0   12     0   4   38 30                 68
1131723 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   grade_5 28 1 3 1   34     0   3   34 36                       70 28 1 3 1   34     0   3   34 36                 70
1131731 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   grade_5 20 1 1 0   45     0   1   38 30                       68 20 1 1 0   45     0   1   38 30                 68
1372986 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2020   grade_5 38 1 2 0   23     0   1   38 27 *                     65.0 38 1 2 0   23     0   1   38 27                 65
1372993 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2020   grade_5 46 1 5 0   17     0   2   37 34 *                     71.0 46 1 5 0   17     0   2   37 34                 71
1373000 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2020   grade_5 49 5 13 2   16     0   5   44 46 *                     90.0 49 5 13 2   16     0   5   44 46                 90
1373007 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2020   grade_5 48 0 1 0   15     1   4   40 29 *                     69.0 48 0 1 0   15     1   4   40 29                 69
1373014 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2020   grade_5 22 2 3 0   43     0   1   33 38 *                     71.0 22 2 3 0   43     0   1   33 38                 71
1373021 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2020   grade_5 12 2 2 0   29     0   1   24 22 *                     46.0 12 2 2 0   29     0   1   24 22                 46
1680250 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough - Blanchard Memorial School   Regular School No Elementary KG 06 2021   grade_5 34 2 2 0   23     0   3   36 28 *                     64.0 34 2 2 0   23     0   3   36 28                 64
1680257 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough - Merriam School   Regular School No Elementary KG 06 2021   grade_5 50 1 4 0   11     0   5   40 31 *                     71.0 50 1 4 0   11     0   5   40 31                 71
1680264 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough - McCarthy-Towne School   Regular School No Elementary KG 06 2021   grade_5 49 2 3 0   14     0   3   31 40 *                     71.0 49 2 3 0   14     0   3   31 40                 71
1680271 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough - C.T. Douglas Elementary School   Regular School No Elementary KG 06 2021   grade_5 45 3 2 0   12     0   4   31 35 *                     66.0 45 3 2 0   12     0   4   31 35                 66
1680278 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough - Paul P Gates Elementary School   Regular School No Elementary KG 06 2021   grade_5 12 4 3 0   52     0   0   42 29 *                     71.0 12 4 3 0   52     0   0   42 29                 71
1680285 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough - Luther Conant School   Regular School No Elementary KG 06 2021   grade_5 13 1 4 0   28     0   1   28 19 *                     47.0 13 1 4 0   28     0   1   28 19                 47
2048058 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2019   grade_5 30 1 2 0   18     0   1   17 35                       52.0 30 1 2 0   18     0   1   17 35                 52
2048065 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   grade_5 55 3 3 0   33     1   1   51 45                       96.0 55 3 3 0   33     1   1   51 45                 96
2048072 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   grade_5 58 3 11 0   9     0   8   43 46                       89.0 58 3 11 0   9     0   8   43 46                 89
2048079 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   grade_5 43 0 4 1   19     0   2   35 34                       69.0 43 0 4 1   19     0   2   35 34                 69
2048086 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   grade_5 17 1 4 0   26     0   1   24 25                       49.0 17 1 4 0   26     0   1   24 25                 49
2048093 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_5 21 4 3 0   43     0   3   36 38                       74.0 21 4 3 0   43     0   3   36 38                 74
2238528 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough: Blanchard Memorial School   Regular School No Elementary KG 06 2018   grade_5 35 3 2 2   25     0   2   36 33                       69.0 35 3 2 2   25     0   2   36 33                 69
2238536 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough: Merriam School   Regular School No Elementary KG 06 2018   grade_5 52 3 6 0   10     0   1   35 37                       72.0 52 3 6 0   10     0   1   35 37                 72
2238544 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough: McCarthy-Towne School   Regular School No Elementary KG 06 2018   grade_5 50 1 9 0   7     0   3   34 36                       70.0 50 1 9 0   7     0   3   34 36                 70
2238552 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough: C.T. Douglas Elementary School   Regular School No Elementary KG 06 2018   grade_5 46 0 2 0   15     1   5   39 30                       69.0 46 0 2 0   15     1   5   39 30                 69
2238560 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough: Paul P Gates Elementary School   Regular School No Elementary KG 06 2018   grade_5 20 2 0 1   22     0   2   22 25                       47.0 20 2 0 1   22     0   2   22 25                 47
2238568 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   grade_5 18 2 7 0   63     1   2   40 53                       93.0 18 2 7 0   63     1   2   40 53                 93
735679 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_5 76 0 2 0   0     0   0   40 38                       78 76 0 2 0   0     0   0   40 38                 78
932557 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_5 115 0 1 0   0     0   0   62 54                       116 115 0 1 0   0     0   0   62 54                 116
1121972 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_5 103 1 0 0   0     0   1   58 47                       105 103 1 0 0   0     0   1   58 47                 105
1364805 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_5 97 0 8 0   1     0   4   49 61 *                     110.0 97 0 8 0   1     0   4   49 61                 110
1672029 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_5 96 0 3 0   1     0   8   57 51 *                     108.0 96 0 3 0   1     0   8   57 51                 108
2039831 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_5 97 1 3 0   1     0   0   60 42                       102.0 97 1 3 0   1     0   0   60 42                 102
2228780 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_5 100 1 2 0   0     0   0   59 44                       103.0 100 1 2 0   0     0   0   59 44                 103
743977 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2015   grade_5 28 1 0 0   0     0   0   10 19                       29 28 1 0 0   0     0   0   10 19                 29
743983 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No 1 KG 05 2015   grade_5 80 3 2 0   1     0   0   51 35                       86 80 3 2 0   1     0   0   51 35                 86
940810 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2016   grade_5 24 1 1 0   0     0   0   12 14                       26 24 1 1 0   0     0   0   12 14                 26
940816 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No 1 KG 05 2016   grade_5 68 4 1 0   0     0   1   35 39                       74 68 4 1 0   0     0   1   35 39                 74
1131748 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   grade_5 32 2 0 0   0     0   0   13 21                       34 32 2 0 0   0     0   0   13 21                 34
1131755 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No Elementary KG 05 2017   grade_5 68 1 1 1   0     0   1   38 34                       72 68 1 1 1   0     0   1   38 34                 72
1373036 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_5 90 6 6 0   2     0   2   55 51 *                     106.0 90 6 6 0   2     0   2   55 51                 106
1680300 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Regional - Hoosac Valley Middle School   Regular School No Middle 04 07 2021   grade_5 70 3 2 0   0     0   1   29 47 *                     76.0 70 3 2 0   0     0   1   29 47                 76
2048108 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_5 97 3 5 0   0     0   3   55 53                       108.0 97 3 5 0   0     0   3   55 53                 108
2238586 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_5 95 6 5 0   0     0   0   56 50                       106.0 95 6 5 0   0     0   0   56 50                 106
735704 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_5 226 4 18 0   8     0   10   120 146                       266 226 4 18 0   8     0   10   120 146                 266
932582 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 04 08 2016   grade_5 254 7 24 0   14     0   7   160 146                       306 254 7 24 0   14     0   7   160 146                 306
1122003 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_5 243 8 16 0   12     0   11   162 128                       290 243 8 16 0   12     0   11   162 128                 290
1364830 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2020   grade_5 213 11 33 0   10     0   7   164 110 *                     274.0 213 11 33 0   10     0   7   164 110                 274
1672054 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam - Roberta G. Doering School   Regular School No Middle 05 08 2021   grade_5 215 3 24 0   6     0   6   132 122 *                     254.0 215 3 24 0   6     0   6   132 122                 254
2039856 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 07 2019   grade_5 252 3 35 0   13     0   13   145 171                       316.0 252 3 35 0   13     0   13   145 171                 316
2228811 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   grade_5 237 10 14 0   5     0   5   131 140                       271.0 237 10 14 0   5     0   5   131 140                 271
743415 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   grade_5 14 7 16 1   2     0   1   19 22                       41 14 7 16 1   2     0   1   19 22                 41
940233 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 06 2016   grade_5 12 7 18 0   0     0   3   19 21                       40 12 7 18 0   0     0   3   19 21                 40
1131106 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_5 18 5 15 0   0     0   2   17 23                       40 18 5 15 0   0     0   2   17 23                 40
1372448 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   grade_5 8 6 37 0   0     0   0   26 25 *                     51.0 8 6 37 0   0     0   0   26 25                 51
1679712 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_5 15 6 27 1   0     0   0   22 27 *                     49.0 15 6 27 1   0     0   0   22 27                 49
2047521 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_5 16 7 27 0   0     0   0   17 33                       50.0 16 7 27 0   0     0   0   17 33                 50
2237931 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_5 10 8 25 0   0     0   3   18 28                       46.0 10 8 25 0   0     0   3   18 28                 46
735726 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_5 166 1 3 0   3     0   4   96 81                       177 166 1 3 0   3     0   4   96 81                 177
932604 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2016   grade_5 149 1 8 0   0     0   8   85 81                       166 149 1 8 0   0     0   8   85 81                 166
1122030 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_5 150 3 14 0   3     1   2   79 94                       173 150 3 14 0   3     1   2   79 94                 173
1364850 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_5 150 1 16 1   5     0   8   96 85 *                     181.0 150 1 16 1   5     0   8   96 85                 181
1672074 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_5 129 3 15 1   2     0   7   81 76 *                     157.0 129 3 15 1   2     0   7   81 76                 157
2039877 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_5 133 4 15 0   2     0   8   94 68                       162.0 133 4 15 0   2     0   8   94 68                 162

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