Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by district descending

View and edit SQL

year

  • 2020 · 9,537
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
1372424 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   kindergarten 96 1 5 0   1     0   6   53 56 *                     109.0 96 1 5 0   1     0   6   53 56                 109
1372425 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   pre_kindergarten 73 3 2 0   4     0   5   49 38 *                     87.0 73 3 2 0   4     0   5   49 38                 87
1372426 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   grade_1 89 0 6 0   4     0   4   55 48 *                     103.0 89 0 6 0   4     0   4   55 48                 103
1372427 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   grade_2 107 3 6 0   4     0   10   62 68 *                     130.0 107 3 6 0   4     0   10   62 68                 130
1372428 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   grade_3 107 2 9 0   2     0   3   64 59 *                     123.0 107 2 9 0   2     0   3   64 59                 123
1372429 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Middle 04 06 2020   grade_4 94 1 6 2   4     1   7   54 61 *                     115.0 94 1 6 2   4     1   7   54 61                 115
1372430 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Middle 04 06 2020   grade_5 114 0 7 1   4     0   7   64 69 *                     133.0 114 0 7 1   4     0   7   64 69                 133
1372431 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Middle 04 06 2020   grade_6 132 3 7 1   3     0   6   87 65 *                     152.0 132 3 7 1   3     0   6   87 65                 152
1372417 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   kindergarten 8 0 0 1   0     0   1   4 6 *                     10.0 8 0 0 1   0     0   1   4 6                 10
1372418 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   pre_kindergarten 12 0 2 1   0     0   0   11 4 *                     15.0 12 0 2 1   0     0   0   11 4                 15
1372419 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_1 8 0 1 0   0     0   1   5 5 *                     10.0 8 0 1 0   0     0   1   5 5                 10
1372420 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_2 13 0 1 0   0     0   0   9 5 *                     14.0 13 0 1 0   0     0   0   9 5                 14
1372421 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_4 9 0 0 0   0     0   0   2 7 *                     9.0 9 0 0 0   0     0   0   2 7                 9
1372422 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_5 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1372423 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_6 10 0 0 0   0     0   1   5 6 *                     11.0 10 0 0 0   0     0   1   5 6                 11
1372123 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 253 86 23 3   13     0   15   191 202 *                     393.0 253 86 23 3   13     0   15   191 202                 393
1372124 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   kindergarten 26 13 45 0   8     0   6   59 39 *                     98.0 26 13 45 0   8     0   6   59 39                 98
1372125 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   pre_kindergarten 13 11 28 0   9     0   4   35 30 *                     65.0 13 11 28 0   9     0   4   35 30                 65
1372126 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_1 13 20 57 0   7     0   3   50 50 *                     100.0 13 20 57 0   7     0   3   50 50                 100
1372127 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_2 18 17 40 0   4     0   1   46 34 *                     80.0 18 17 40 0   4     0   1   46 34                 80
1372128 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_3 9 15 36 0   4     0   4   33 35 *                     68.0 9 15 36 0   4     0   4   33 35                 68
1372129 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_4 12 21 43 0   3     0   1   38 42 *                     80.0 12 21 43 0   3     0   1   38 42                 80
1372130 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_5 20 13 38 0   3     0   3   42 35 *                     77.0 20 13 38 0   3     0   3   42 35                 77
1372131 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_6 13 9 25 0   3     0   3   28 25 *                     53.0 13 9 25 0   3     0   3   28 25                 53
1372132 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   kindergarten 11 6 8 0   1     0   1   11 16 *                     27.0 11 6 8 0   1     0   1   11 16                 27
1372133 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_1 5 1 3 0   3     0   1   5 8 *                     13.0 5 1 3 0   3     0   1   5 8                 13
1372134 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_2 3 2 9 0   0     0   1   9 6 *                     15.0 3 2 9 0   0     0   1   9 6                 15
1372135 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_3 7 2 11 0   3     0   0   12 11 *                     23.0 7 2 11 0   3     0   0   12 11                 23
1372136 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_4 5 3 9 0   2     0   2   12 9 *                     21.0 5 3 9 0   2     0   2   12 9                 21
1372137 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_5 11 1 10 0   3     0   2   13 14 *                     27.0 11 1 10 0   3     0   2   13 14                 27
1372138 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_6 10 3 12 0   2     0   1   16 12 *                     28.0 10 3 12 0   2     0   1   16 12                 28
1372139 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   kindergarten 12 8 53 1   8     0   0   47 35 *                     82.0 12 8 53 1   8     0   0   47 35                 82
1372140 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   grade_1 6 13 56 0   7     0   4   51 35 *                     86.0 6 13 56 0   7     0   4   51 35                 86
1372141 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   grade_2 2 4 64 1   5     0   0   39 37 *                     76.0 2 4 64 1   5     0   0   39 37                 76
1372142 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   grade_3 5 9 68 0   5     0   1   43 45 *                     88.0 5 9 68 0   5     0   1   43 45                 88
1372143 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   grade_4 3 10 61 0   5     0   4   33 50 *                     83.0 3 10 61 0   5     0   4   33 50                 83
1372144 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   grade_5 6 8 61 1   11     0   2   38 51 *                     89.0 6 8 61 1   11     0   2   38 51                 89
1372145 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   grade_6 10 10 69 0   7     0   1   53 44 *                     97.0 10 10 69 0   7     0   1   53 44                 97
1372146 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   kindergarten 10 1 24 0   0     1   1   12 25 *                     37.0 10 1 24 0   0     1   1   12 25                 37
1372147 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_1 8 4 16 0   0     0   0   15 13 *                     28.0 8 4 16 0   0     0   0   15 13                 28
1372148 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_2 3 6 24 0   3     0   3   20 19 *                     39.0 3 6 24 0   3     0   3   20 19                 39
1372149 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_3 15 4 23 0   2     0   1   22 23 *                     45.0 15 4 23 0   2     0   1   22 23                 45
1372150 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_4 11 9 27 0   0     0   3   26 24 *                     50.0 11 9 27 0   0     0   3   26 24                 50
1372151 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_5 6 8 26 0   0     0   0   19 21 *                     40.0 6 8 26 0   0     0   0   19 21                 40
1372152 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_6 12 12 15 0   1     0   3   21 22 *                     43.0 12 12 15 0   1     0   3   21 22                 43
1372153 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   kindergarten 9 5 21 0   2     0   2   18 21 *                     39.0 9 5 21 0   2     0   2   18 21                 39
1372154 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   pre_kindergarten 8 5 16 0   3     0   1   18 15 *                     33.0 8 5 16 0   3     0   1   18 15                 33
1372155 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   grade_1 3 8 24 0   5     0   0   18 22 *                     40.0 3 8 24 0   5     0   0   18 22                 40
1372156 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   grade_2 2 2 28 1   7     0   1   27 14 *                     41.0 2 2 28 1   7     0   1   27 14                 41
1372157 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   grade_3 6 6 28 0   6     0   1   28 19 *                     47.0 6 6 28 0   6     0   1   28 19                 47
1372158 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   grade_4 9 5 31 0   8     0   5   32 26 *                     58.0 9 5 31 0   8     0   5   32 26                 58
1372159 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   grade_5 8 7 29 0   7     0   1   26 26 *                     52.0 8 7 29 0   7     0   1   26 26                 52
1372160 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   grade_6 5 8 30 0   4     0   2   29 20 *                     49.0 5 8 30 0   4     0   2   29 20                 49
1372161 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   kindergarten 20 8 42 0   5     0   0   42 33 *                     75.0 20 8 42 0   5     0   0   42 33                 75
1372162 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   grade_1 7 8 44 0   7     0   1   38 29 *                     67.0 7 8 44 0   7     0   1   38 29                 67
1372163 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   grade_2 2 3 47 0   1     0   5   28 30 *                     58.0 2 3 47 0   1     0   5   28 30                 58
1372164 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   grade_3 6 10 47 0   7     0   2   31 41 *                     72.0 6 10 47 0   7     0   2   31 41                 72
1372165 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   grade_4 11 10 50 1   4     0   1   46 31 *                     77.0 11 10 50 1   4     0   1   46 31                 77
1372166 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   grade_5 23 15 33 0   5     0   4   43 37 *                     80.0 23 15 33 0   5     0   4   43 37                 80
1372167 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   grade_6 13 6 38 0   6     0   1   35 29 *                     64.0 13 6 38 0   6     0   1   35 29                 64
1372168 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   kindergarten 15 3 50 0   3     0   1   28 44 *                     72.0 15 3 50 0   3     0   1   28 44                 72
1372169 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   pre_kindergarten 9 1 2 0   1     0   0   7 6 *                     13.0 9 1 2 0   1     0   0   7 6                 13
1372170 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_1 14 2 58 0   2     0   1   39 38 *                     77.0 14 2 58 0   2     0   1   39 38                 77
1372171 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_2 7 0 61 0   0     0   1   34 35 *                     69.0 7 0 61 0   0     0   1   34 35                 69
1372172 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_3 4 2 45 0   2     0   0   27 26 *                     53.0 4 2 45 0   2     0   0   27 26                 53
1372173 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_4 6 4 66 0   0     0   0   32 44 *                     76.0 6 4 66 0   0     0   0   32 44                 76
1372174 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_5 11 0 66 0   1     0   1   41 38 *                     79.0 11 0 66 0   1     0   1   41 38                 79
1372175 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_6 11 3 59 0   0     0   1   34 40 *                     74.0 11 3 59 0   0     0   1   34 40                 74
1372176 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   kindergarten 19 9 23 0   2     0   3   28 28 *                     56.0 19 9 23 0   2     0   3   28 28                 56
1372177 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   pre_kindergarten 6 10 9 0   2     0   1   14 14 *                     28.0 6 10 9 0   2     0   1   14 14                 28
1372178 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_1 12 9 29 0   1     0   5   34 22 *                     56.0 12 9 29 0   1     0   5   34 22                 56
1372179 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_2 14 6 47 0   2     0   7   36 40 *                     76.0 14 6 47 0   2     0   7   36 40                 76
1372180 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_3 15 10 35 0   1     0   4   30 35 *                     65.0 15 10 35 0   1     0   4   30 35                 65
1372181 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_4 18 13 37 0   0     0   4   35 37 *                     72.0 18 13 37 0   0     0   4   35 37                 72
1372182 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_5 20 15 31 0   1     0   3   42 28 *                     70.0 20 15 31 0   1     0   3   42 28                 70
1372183 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_6 13 6 31 0   2     0   2   25 29 *                     54.0 13 6 31 0   2     0   2   25 29                 54
1372184 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   kindergarten 8 6 23 0   3     0   2   21 21 *                     42.0 8 6 23 0   3     0   2   21 21                 42
1372185 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   pre_kindergarten 5 13 18 0   1     0   4   21 20 *                     41.0 5 13 18 0   1     0   4   21 20                 41
1372186 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   grade_1 3 7 18 0   1     0   1   16 14 *                     30.0 3 7 18 0   1     0   1   16 14                 30
1372187 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   grade_2 2 4 29 1   1     0   0   19 18 *                     37.0 2 4 29 1   1     0   0   19 18                 37
1372188 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   grade_3 7 4 24 0   2     0   1   18 20 *                     38.0 7 4 24 0   2     0   1   18 20                 38
1372189 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   grade_4 6 6 16 0   2     0   1   10 21 *                     31.0 6 6 16 0   2     0   1   10 21                 31
1372190 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   grade_5 7 6 13 0   0     0   1   14 13 *                     27.0 7 6 13 0   0     0   1   14 13                 27
1372191 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   grade_6 5 8 5 0   1     0   0   11 8 *                     19.0 5 8 5 0   1     0   0   11 8                 19
1372192 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   kindergarten 15 7 27 0   5     0   1   31 24 *                     55.0 15 7 27 0   5     0   1   31 24                 55
1372193 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   pre_kindergarten 3 4 2 0   0     0   0   7 2 *                     9.0 3 4 2 0   0     0   0   7 2                 9
1372194 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   grade_1 9 8 31 0   6     0   1   23 32 *                     55.0 9 8 31 0   6     0   1   23 32                 55
1372195 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   grade_2 10 13 38 1   7     0   2   32 39 *                     71.0 10 13 38 1   7     0   2   32 39                 71
1372196 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   grade_3 15 6 33 1   2     0   2   36 23 *                     59.0 15 6 33 1   2     0   2   36 23                 59
1372197 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   grade_4 8 5 28 0   3     0   2   26 20 *                     46.0 8 5 28 0   3     0   2   26 20                 46
1372198 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   grade_5 13 5 33 1   8     0   1   27 34 *                     61.0 13 5 33 1   8     0   1   27 34                 61
1372199 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   grade_6 24 9 31 1   4     0   2   38 33 *                     71.0 24 9 31 1   4     0   2   38 33                 71
1372200 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2020   kindergarten 43 5 7 0   3     0   1   33 26 *                     59.0 43 5 7 0   3     0   1   33 26                 59
1372201 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2020   grade_1 41 3 9 1   1     0   2   21 36 *                     57.0 41 3 9 1   1     0   2   21 36                 57
1372202 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2020   grade_2 36 2 7 0   1     0   3   24 25 *                     49.0 36 2 7 0   1     0   3   24 25                 49
1372203 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2020   grade_3 34 3 5 0   2     0   3   22 25 *                     47.0 34 3 5 0   2     0   3   22 25                 47
1372204 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2020   grade_4 50 3 4 1   4     0   4   30 36 *                     66.0 50 3 4 1   4     0   4   30 36                 66
1372205 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2020   grade_5 34 5 13 0   2     0   1   28 27 *                     55.0 34 5 13 0   2     0   1   28 27                 55
1372206 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2020   grade_6 40 3 8 0   1     0   0   30 22 *                     52.0 40 3 8 0   1     0   0   30 22                 52
1372207 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary KG 06 2020   kindergarten 23 13 30 0   1     0   1   33 35 *                     68.0 23 13 30 0   1     0   1   33 35                 68

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