Data source: Big Local News · About: Big Local

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

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
940645 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 09 2016   grade_5 4 154 80 0   0     0   0   120 118                       238 4 154 80 0   0     0   0   120 118                 238
1372858 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_5 8 138 78 2   1     0   1   128 100 *                     228.0 8 138 78 2   1     0   1   128 100                 228
1131555 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_5 3 137 93 0   6     1   4   139 105                       244 3 137 93 0   6     1   4   139 105                 244
2238388 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_5 3 135 92 1   4     0   1   124 112                       236.0 3 135 92 1   4     0   1   124 112                 236
743816 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_5 2 128 114 0   2     0   3   137 112                       249 2 128 114 0   2     0   3   137 112                 249
2230468 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton: Oscar F Raymond   Regular School No Elementary KG 05 2018   grade_5 13 127 10 1   0     0   6   77 80                       157.0 13 127 10 1   0     0   6   77 80                 157
2047930 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_5 4 120 97 1   0     1   0   115 108                       223.0 4 120 97 1   0     1   0   115 108                 223
1366200 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_5 59 119 27 1   11     1   7   114 111 *                     225.0 59 119 27 1   11     1   7   114 111                 225
1123653 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2017   grade_5 4 117 10 1   1     0   2   77 58                       135 4 117 10 1   1     0   2   77 58                 135
1366206 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2020   grade_5 7 117 15 0   0     0   5   76 68 *                     144.0 7 117 15 0   0     0   5   76 68                 144
2230461 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton: Louis F Angelo Elementary   Regular School No Elementary KG 05 2018   grade_5 52 113 25 0   10     0   8   113 95                       208.0 52 113 25 0   10     0   8   113 95                 208
1673440 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton - Oscar F Raymond   Regular School No Elementary KG 05 2021   grade_5 13 111 12 1   2     0   4   76 67 *                     143.0 13 111 12 1   2     0   4   76 67                 143
2041273 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2019   grade_5 15 108 12 0   2     0   7   72 72                       144.0 15 108 12 0   2     0   7   72 72                 144
2041267 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2019   grade_5 57 103 29 2   16     0   9   108 108                       216.0 57 103 29 2   16     0   9   108 108                 216
2047614 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_5 5 102 67 0   5     0   2   87 94                       181.0 5 102 67 0   5     0   2   87 94                 181
933985 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_5 53 101 16 0   9     0   9   93 95                       188 53 101 16 0   9     0   9   93 95                 188
1679802 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_5 8 101 62 0   2     0   4   82 95 *                     177.0 8 101 62 0   2     0   4   82 95                 177
737124 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_5 9 99 14 0   3     1   6   65 67                       132 9 99 14 0   3     1   6   65 67                 132
1131205 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_5 11 97 71 0   3     0   2   87 97                       184 11 97 71 0   3     0   2   87 97                 184
933991 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 05 2016   grade_5 9 95 16 1   5     0   5   70 61                       131 9 95 16 1   5     0   5   70 61                 131
1372539 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_5 13 95 64 1   4     0   4   83 98 *                     181.0 13 95 64 1   4     0   4   83 98                 181
1673434 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_5 42 94 31 1   11     0   10   98 91 *                     189.0 42 94 31 1   11     0   10   98 91                 189
1679941 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 2021   grade_5 31 90 5 0   11     0   12   71 78 *                     149.0 31 90 5 0   11     0   12   71 78                 149
2238033 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_5 10 88 79 1   3     0   5   101 85                       186.0 10 88 79 1   3     0   5   101 85                 186
933962 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_5 17 86 11 0   0     1   10   59 66                       125 17 86 11 0   0     1   10   59 66                 125
737095 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_5 24 85 10 2   0     0   4   60 65                       125 24 85 10 2   0     0   4   60 65                 125
737118 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2015   grade_5 57 85 21 0   7     3   10   92 91                       183 57 85 21 0   7     3   10   92 91                 183
2230437 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_5 19 85 13 0   1     0   4   59 63                       122.0 19 85 13 0   1     0   4   59 63                 122
1123582 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_5 10 84 29 1   1     0   6   63 68                       131 10 84 29 1   1     0   6   63 68                 131
1680123 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_5 2 84 58 0   0     0   4   89 59 *                     148.0 2 84 58 0   0     0   4   89 59                 148
2041215 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2019   grade_5 8 83 21 0   0     0   7   66 53                       119.0 8 83 21 0   0     0   7   66 53                 119
1123646 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2017   grade_5 55 81 26 2   12     0   12   100 88                       188 55 81 26 2   12     0   12   100 88                 188
2230400 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton: Dr W Arnone Community School   Regular School No Elementary KG 05 2018   grade_5 12 81 21 1   0     0   4   64 55                       119.0 12 81 21 1   0     0   4   64 55                 119
2230454 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Brockton: Gilmore Elementary School   Regular School No Elementary KG 05 2018   grade_5 3 81 13 1   0     0   2   48 52                       100.0 3 81 13 1   0     0   2   48 52                 100
1366179 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_5 11 79 16 0   1     2   4   51 62 *                     113.0 11 79 16 0   1     2   4   51 62                 113
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
933931 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_5 7 76 34 0   0     0   10   65 62                       127 7 76 34 0   0     0   10   65 62                 127
1123639 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No Elementary KG 05 2017   grade_5 6 75 13 0   0     0   2   51 45                       96 6 75 13 0   0     0   2   51 45                 96
1366148 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2020   grade_5 9 75 28 0   0     0   9   64 57 *                     121.0 9 75 28 0   0     0   9   64 57                 121
1366215 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2020   grade_5 13 74 18 0   1     1   3   56 54 *                     110.0 13 74 18 0   1     1   3   56 54                 110
1673381 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton - Dr W Arnone Community School   Regular School No Elementary PK 05 2021   grade_5 14 74 15 2   2     0   10   68 49 *                     117.0 14 74 15 2   2     0   10   68 49                 117
743797 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2015   grade_5 1 73 41 0   3     0   3   56 65                       121 1 73 41 0   3     0   3   56 65                 121
1123619 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_5 23 73 19 0   0     1   9   67 58                       125 23 73 19 0   0     1   9   67 58                 125
1366173 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_5 16 73 5 0   2     0   8   54 50 *                     104.0 16 73 5 0   2     0   8   54 50                 104
1372677 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_5 47 73 10 0   12     0   7   77 72 *                     149.0 47 73 10 0   12     0   7   77 72                 149
1673413 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_5 11 73 15 0   0     0   7   45 61 *                     106.0 11 73 15 0   0     0   7   45 61                 106
2040406 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   grade_5 0 73 13 0   2     0   2   53 37                       90.0 0 73 13 0   2     0   2   53 37                 90
2230414 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton: Manthala George Jr. School   Regular School No Elementary KG 05 2018   grade_5 25 73 58 4   2     0   11   91 82                       173.0 25 73 58 4   2     0   11   91 82                 173
933979 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   grade_5 3 70 12 0   0     1   3   46 43                       89 3 70 12 0   0     1   3   46 43                 89
737064 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2015   grade_5 17 69 25 0   0     1   11   65 58                       123 17 69 25 0   0     1   11   65 58                 123
1123596 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2017   grade_5 23 69 66 0   0     0   6   81 83                       164 23 69 66 0   0     0   6   81 83                 164
940626 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   grade_5 0 68 18 0   0     0   1   48 39                       87 0 68 18 0   0     0   1   48 39                 87
737076 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2015   grade_5 14 67 56 0   0     0   7   76 68                       144 14 67 56 0   0     0   7   76 68                 144
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
2041234 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2019   grade_5 30 67 17 0   1     0   4   68 51                       119.0 30 67 17 0   1     0   4   68 51                 119
1131533 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   grade_5 1 66 35 0   0     0   2   51 53                       104 1 66 35 0   0     0   2   51 53                 104
2230407 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Brockton: Mary E. Baker School   Regular School No Elementary KG 05 2018   grade_5 40 66 21 0   2     0   2   67 64                       131.0 40 66 21 0   2     0   2   67 64                 131
2238366 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District): Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2018   grade_5 0 66 30 0   1     0   0   46 51                       97.0 0 66 30 0   1     0   0   46 51                 97
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
743841 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_5 9 65 17 0   4     0   1   43 53                       96 9 65 17 0   4     0   1   43 53                 96
933937 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No 1 KG 05 2016   grade_5 36 65 25 2   3     0   9   81 59                       140 36 65 25 2   3     0   9   81 59                 140
2230447 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Brockton: Hancock   Regular School No Elementary KG 05 2018   grade_5 35 65 9 1   3     0   4   63 54                       117.0 35 65 9 1   3     0   4   63 54                 117
2041246 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_5 16 64 19 0   0     0   7   51 55                       106.0 16 64 19 0   0     0   7   51 55                 106
2047911 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2019   grade_5 2 64 26 0   1     0   6   44 55                       99.0 2 64 26 0   1     0   6   44 55                 99
1365844 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_5 2 63 25 1   1     0   1   51 42 *                     93.0 2 63 25 1   1     0   1   51 42                 93
736256 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2015   grade_5 0 62 10 0   3     0   0   44 31                       75 0 62 10 0   3     0   0   44 31                 75
1365660 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_5 1 62 35 0   1     0   2   42 59 *                     101.0 1 62 35 0   1     0   2   42 59                 101
1366154 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2020   grade_5 30 62 24 1   1     1   7   69 57 *                     126.0 30 62 24 1   1     1   7   69 57                 126
2041261 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Gilmore Elementary School   Regular School No Elementary KG 05 2019   grade_5 4 62 7 0   0     0   4   44 33                       77.0 4 62 7 0   0     0   4   44 33                 77
2230423 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brockton: Brookfield   Regular School No Elementary KG 05 2018   grade_5 30 62 11 1   4     1   1   61 49                       110.0 30 62 11 1   4     1   1   61 49                 110
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
933950 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2016   grade_5 39 61 8 0   1     0   3   61 51                       112 39 61 8 0   1     0   3   61 51                 112
940671 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_5 7 61 17 0   3     0   5   45 48                       93 7 61 17 0   3     0   5   45 48                 93
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
1365363 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2020   grade_5 0 61 10 0   1     0   3   46 29 *                     75.0 0 61 10 0   1     0   3   46 29                 75
1372839 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2020   grade_5 1 61 17 0   0     0   2   42 39 *                     81.0 1 61 17 0   0     0   2   42 39                 81
1673401 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brockton - Brookfield   Regular School No Elementary KG 05 2021   grade_5 29 61 6 0   0     0   1   48 49 *                     97.0 29 61 6 0   0     0   1   48 49                 97
1673449 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton - Downey   Regular School No Elementary KG 05 2021   grade_5 19 61 23 1   1     0   8   61 52 *                     113.0 19 61 23 1   1     0   8   61 52                 113
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
1680104 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District) - Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2021   grade_5 1 61 36 0   0     0   4   49 53 *                     102.0 1 61 36 0   0     0   4   49 53                 102
934000 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2016   grade_5 31 60 17 0   1     0   7   62 54                       116 31 60 17 0   1     0   7   62 54                 116
1366167 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2020   grade_5 16 60 12 0   3     1   6   51 47 *                     98.0 16 60 12 0   3     1   6   51 47                 98
2041221 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2019   grade_5 25 60 22 0   1     0   7   66 49                       115.0 25 60 22 0   1     0   7   66 49                 115
2041227 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2019   grade_5 13 60 76 4   1     0   9   91 72                       163.0 13 60 76 4   1     0   9   91 72                 163
2230430 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 Brockton: John F Kennedy   Regular School No Elementary KG 05 2018   grade_5 26 60 10 0   4     0   8   51 57                       108.0 26 60 10 0   4     0   8   51 57                 108
2238177 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_5 47 60 2 0   16     0   10   59 76                       135.0 47 60 2 0   16     0   10   59 76                 135
1366194 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Gilmore Elementary School   Regular School No Elementary KG 05 2020   grade_5 0 59 10 0   1     0   3   44 29 *                     73.0 0 59 10 0   1     0   3   44 29                 73
737139 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2015   grade_5 22 58 20 0   2     0   5   52 55                       107 22 58 20 0   2     0   5   52 55                 107
1123665 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2017   grade_5 25 58 20 2   3     0   4   58 54                       112 25 58 20 2   3     0   4   58 54                 112
1673428 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Brockton - Gilmore Elementary School   Regular School No Elementary KG 05 2021   grade_5 0 58 21 0   0     0   4   37 46 *                     83.0 0 58 21 0   0     0   4   37 46                 83
2047748 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_5 59 58 5 2   15     1   7   67 80                       147.0 59 58 5 2   15     1   7   67 80                 147
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
1673407 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 Brockton - John F Kennedy   Regular School No Elementary KG 05 2021   grade_5 22 57 14 0   5     0   10   55 53 *                     108.0 22 57 14 0   5     0   10   55 53                 108
737112 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2015   grade_5 13 56 7 0   1     1   4   35 47                       82 13 56 7 0   1     1   4   35 47                 82
1131585 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_5 22 56 9 1   7     0   3   53 45                       98 22 56 9 1   7     0   3   53 45                 98
1672893 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_5 0 56 35 1   1     0   3   53 43 *                     96.0 0 56 35 1   1     0   3   53 43                 96
1123589 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2017   grade_5 42 55 14 0   3     0   7   65 56                       121 42 55 14 0   3     0   7   65 56                 121
1131438 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2017   grade_5 0 55 14 0   1     0   0   31 39                       70 0 55 14 0   1     0   0   31 39                 70
1365520 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2020   grade_5 1 55 51 0   2     1   1   53 58 *                     111.0 1 55 51 0   2     1   1   53 58                 111
2047959 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_5 10 55 24 0   7     1   2   51 48                       99.0 10 55 24 0   7     1   2   51 48                 99

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