Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by district descending

View and edit SQL

year

grade

  • kindergarten · 6,747
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
743393 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No 1 PK 03 2015   kindergarten 101 0 3 0   1     0   5   54 56                       110 101 0 3 0   1     0   5   54 56                 110
940210 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No 1 PK 03 2016   kindergarten 89 1 3 0   2     1   4   45 55                       100 89 1 3 0   2     1   4   45 55                 100
1131078 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   kindergarten 102 2 8 0   2     0   3   62 55                       117 102 2 8 0   2     0   3   62 55                 117
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
1679688 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham - Delaney   Regular School No Elementary PK 03 2021   kindergarten 89 3 1 0   5     0   4   52 50 *                     102.0 89 3 1 0   5     0   4   52 50                 102
2047498 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2019   kindergarten 93 0 5 0   4     0   4   60 46                       106.0 93 0 5 0   4     0   4   60 46                 106
2237903 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   kindergarten 109 3 4 0   4     0   10   60 70                       130.0 109 3 4 0   4     0   10   60 70                 130
940202 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No 1 PK 06 2016   kindergarten 8 0 0 0   0     0   0   2 6                       8 8 0 0 0   0     0   0   2 6                 8
1131070 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   kindergarten 11 0 0 0   1     0   0   3 9                       12 11 0 0 0   1     0   0   3 9                 12
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
1679680 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington - R. H. Conwell   Regular School No Elementary PK 06 2021   kindergarten 9 0 1 0   0     0   0   7 3 *                     10.0 9 0 1 0   0     0   0   7 3                 10
2047491 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   kindergarten 8 0 1 0   0     0   1   5 5                       10.0 8 0 1 0   0     0   1   5 5                 10
2237895 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   kindergarten 12 0 1 0   0     0   0   7 6                       13.0 12 0 1 0   0     0   0   7 6                 13
743100 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2015   kindergarten 22 18 41 0   8     0   3   35 57                       92 22 18 41 0   8     0   3   35 57                 92
743108 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2015   kindergarten 10 2 3 0   0     0   2   11 6                       17 10 2 3 0   0     0   2   11 6                 17
743115 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   kindergarten 8 10 81 0   9     0   5   60 53                       113 8 10 81 0   9     0   5   60 53                 113
743123 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2015   kindergarten 6 6 24 0   0     0   1   18 19                       37 6 6 24 0   0     0   1   18 19                 37
743130 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2015   kindergarten 12 11 28 1   8     0   1   36 25                       61 12 11 28 1   8     0   1   36 25                 61
743138 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2015   kindergarten 24 12 39 0   3     0   1   44 35                       79 24 12 39 0   3     0   1   44 35                 79
743145 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2015   kindergarten 15 3 52 0   0     0   4   35 39                       74 15 3 52 0   0     0   4   35 39                 74
743153 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2015   kindergarten 29 9 26 0   2     0   7   47 26                       73 29 9 26 0   2     0   7   47 26                 73
743161 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2015   kindergarten 18 2 20 0   0     0   2   19 23                       42 18 2 20 0   0     0   2   19 23                 42
743169 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2015   kindergarten 26 7 26 0   8     0   3   35 35                       70 26 7 26 0   8     0   3   35 35                 70
743177 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2015   kindergarten 39 6 7 0   3     0   6   28 33                       61 39 6 7 0   3     0   6   28 33                 61
743184 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2015   kindergarten 23 10 41 0   2     0   5   48 33                       81 23 10 41 0   2     0   5   48 33                 81
743192 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2015   kindergarten 11 6 24 1   5     0   5   28 24                       52 11 6 24 1   5     0   5   28 24                 52
743200 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2015   kindergarten 33 15 32 0   10     0   5   56 39                       95 33 15 32 0   10     0   5   56 39                 95
743208 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2015   kindergarten 21 5 25 0   8     0   7   36 30                       66 21 5 25 0   8     0   7   36 30                 66
743216 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2015   kindergarten 25 6 10 0   8     0   1   24 26                       50 25 6 10 0   8     0   1   24 26                 50
743223 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2015   kindergarten 9 19 35 0   2     0   6   39 32                       71 9 19 35 0   2     0   6   39 32                 71
743231 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2015   kindergarten 27 6 6 1   7     0   3   18 32                       50 27 6 6 1   7     0   3   18 32                 50
743238 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2015   kindergarten 7 12 31 0   1     0   2   28 25                       53 7 12 31 0   1     0   2   28 25                 53
743246 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No 1 KG 06 2015   kindergarten 33 5 5 0   4     0   4   21 30                       51 33 5 5 0   4     0   4   21 30                 51
743253 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2015   kindergarten 19 8 12 0   7     0   1   22 25                       47 19 8 12 0   7     0   1   22 25                 47
743261 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2015   kindergarten 30 2 3 0   3     0   4   20 22                       42 30 2 3 0   3     0   4   20 22                 42
743268 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2015   kindergarten 47 8 11 0   3     0   10   48 31                       79 47 8 11 0   3     0   10   48 31                 79
743275 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2015   kindergarten 41 21 12 0   5     0   7   43 43                       86 41 21 12 0   5     0   7   43 43                 86
743283 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2015   kindergarten 45 16 37 0   6     0   8   56 56                       112 45 16 37 0   6     0   8   56 56                 112
743291 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2015   kindergarten 31 9 22 0   3     0   4   34 35                       69 31 9 22 0   3     0   4   34 35                 69
743298 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2015   kindergarten 53 19 21 0   8     0   4   55 50                       105 53 19 21 0   8     0   4   55 50                 105
743306 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2015   kindergarten 31 8 9 0   2     0   7   24 33                       57 31 8 9 0   2     0   7   24 33                 57
743314 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2015   kindergarten 29 9 11 0   5     0   5   36 23                       59 29 9 11 0   5     0   5   36 23                 59
743321 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2015   kindergarten 39 2 9 0   1     0   2   31 22                       53 39 2 9 0   1     0   2   31 22                 53
743328 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2015   kindergarten 21 8 34 0   1     0   3   35 32                       67 21 8 34 0   1     0   3   35 32                 67
743335 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2015   kindergarten 29 2 5 0   5     0   3   21 23                       44 29 2 5 0   5     0   3   21 23                 44
743343 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2015   kindergarten 27 13 37 0   1     0   1   49 30                       79 27 13 37 0   1     0   1   49 30                 79
939909 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   kindergarten 13 27 51 0   9     0   4   57 47                       104 13 27 51 0   9     0   4   57 47                 104
939917 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2016   kindergarten 4 4 6 0   2     0   2   11 7                       18 4 4 6 0   2     0   2   11 7                 18
939924 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2016   kindergarten 11 8 57 0   4     0   2   36 46                       82 11 8 57 0   4     0   2   36 46                 82
939932 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2016   kindergarten 9 3 18 0   0     0   1   16 15                       31 9 3 18 0   0     0   1   16 15                 31
939939 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2016   kindergarten 11 6 26 0   8     0   3   33 21                       54 11 6 26 0   8     0   3   33 21                 54
939947 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2016   kindergarten 14 9 46 0   5     0   1   36 39                       75 14 9 46 0   5     0   1   36 39                 75
939954 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2016   kindergarten 12 6 65 0   2     0   1   39 47                       86 12 6 65 0   2     0   1   39 47                 86
939962 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2016   kindergarten 17 8 36 0   0     0   1   27 35                       62 17 8 36 0   0     0   1   27 35                 62
939970 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2016   kindergarten 7 5 21 0   3     0   1   19 18                       37 7 5 21 0   3     0   1   19 18                 37
939978 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2016   kindergarten 12 6 32 0   4     0   5   34 25                       59 12 6 32 0   4     0   5   34 25                 59
939986 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2016   kindergarten 44 2 6 0   4     0   2   25 33                       58 44 2 6 0   4     0   2   25 33                 58
939993 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2016   kindergarten 18 16 42 0   1     0   3   42 38                       80 18 16 42 0   1     0   3   42 38                 80
940001 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2016   kindergarten 8 6 39 1   6     0   5   34 31                       65 8 6 39 1   6     0   5   34 31                 65
940009 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2016   kindergarten 29 10 31 1   5     0   6   48 34                       82 29 10 31 1   5     0   6   48 34                 82
940017 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2016   kindergarten 12 9 25 0   5     0   4   27 28                       55 12 9 25 0   5     0   4   27 28                 55
940025 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2016   kindergarten 24 2 16 1   4     0   2   17 32                       49 24 2 16 1   4     0   2   17 32                 49
940032 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2016   kindergarten 6 20 32 0   2     0   5   27 38                       65 6 20 32 0   2     0   5   27 38                 65
940040 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2016   kindergarten 34 2 6 0   6     0   3   23 28                       51 34 2 6 0   6     0   3   23 28                 51
940047 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2016   kindergarten 6 5 35 2   2     0   2   25 27                       52 6 5 35 2   2     0   2   25 27                 52
940055 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No 1 KG 06 2016   kindergarten 22 8 6 0   3     0   6   26 19                       45 22 8 6 0   3     0   6   26 19                 45
940062 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2016   kindergarten 16 11 12 0   1     0   3   18 25                       43 16 11 12 0   1     0   3   18 25                 43
940070 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2016   kindergarten 27 6 3 0   4     0   0   22 18                       40 27 6 3 0   4     0   0   22 18                 40
940077 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2016   kindergarten 39 3 8 0   2     0   0   28 24                       52 39 3 8 0   2     0   0   28 24                 52
940084 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2016   kindergarten 28 13 24 0   4     0   8   37 40                       77 28 13 24 0   4     0   8   37 40                 77
940092 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2016   kindergarten 32 22 42 0   8     0   4   49 59                       108 32 22 42 0   8     0   4   49 59                 108
940100 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2016   kindergarten 20 6 22 0   3     0   1   28 24                       52 20 6 22 0   3     0   1   28 24                 52
940107 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2016   kindergarten 40 9 26 0   3     0   7   45 40                       85 40 9 26 0   3     0   7   45 40                 85
940115 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2016   kindergarten 28 10 11 0   7     0   3   29 30                       59 28 10 11 0   7     0   3   29 30                 59
940123 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2016   kindergarten 32 6 16 0   2     0   4   30 30                       60 32 6 16 0   2     0   4   30 30                 60
940130 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2016   kindergarten 29 6 24 0   3     0   2   36 28                       64 29 6 24 0   3     0   2   36 28                 64
940137 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2016   kindergarten 14 4 41 0   1     0   7   36 31                       67 14 4 41 0   1     0   7   36 31                 67
940144 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2016   kindergarten 25 5 8 0   1     0   2   19 22                       41 25 5 8 0   1     0   2   19 22                 41
940152 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2016   kindergarten 14 12 31 0   0     0   1   27 31                       58 14 12 31 0   0     0   1   27 31                 58
1130733 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   kindergarten 13 18 41 0   8     0   5   43 42                       85 13 18 41 0   8     0   5   43 42                 85
1130742 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   kindergarten 7 2 11 0   0     0   2   11 11                       22 7 2 11 0   0     0   2   11 11                 22
1130750 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   kindergarten 10 8 73 0   6     0   1   45 53                       98 10 8 73 0   6     0   1   45 53                 98
1130759 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   kindergarten 21 4 17 0   2     0   1   27 18                       45 21 4 17 0   2     0   1   27 18                 45
1130767 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   kindergarten 10 9 26 0   11     0   1   29 28                       57 10 9 26 0   11     0   1   29 28                 57
1130776 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   kindergarten 6 9 49 0   1     0   1   33 33                       66 6 9 49 0   1     0   1   33 33                 66
1130784 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   kindergarten 7 1 60 0   5     0   2   33 42                       75 7 1 60 0   5     0   2   33 42                 75
1130793 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   kindergarten 16 12 34 0   1     0   2   35 30                       65 16 12 34 0   1     0   2   35 30                 65
1130802 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   kindergarten 7 5 24 0   2     0   1   20 19                       39 7 5 24 0   2     0   1   20 19                 39
1130810 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2017   kindergarten 13 7 40 0   2     0   1   37 26                       63 13 7 40 0   2     0   1   37 26                 63
1130819 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2017   kindergarten 36 3 7 0   5     0   1   28 24                       52 36 3 7 0   5     0   1   28 24                 52
1130827 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary PK 06 2017   kindergarten 13 6 45 0   5     0   2   41 30                       71 13 6 45 0   5     0   2   41 30                 71
1130836 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2017   kindergarten 11 5 46 1   6     0   3   31 41                       72 11 5 46 1   6     0   3   31 41                 72
1130845 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2017   kindergarten 19 9 30 1   4     0   6   45 24                       69 19 9 30 1   4     0   6   45 24                 69
1130854 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary PK 06 2017   kindergarten 14 8 30 0   6     0   1   29 30                       59 14 8 30 0   6     0   1   29 30                 59
1130863 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2017   kindergarten 23 3 8 0   2     0   2   21 17                       38 23 3 8 0   2     0   2   21 17                 38
1130871 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2017   kindergarten 6 22 41 0   1     0   2   33 39                       72 6 22 41 0   1     0   2   33 39                 72
1130880 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2017   kindergarten 26 9 9 0   7     0   2   29 24                       53 26 9 9 0   7     0   2   29 24                 53
1130888 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   kindergarten 2 11 22 0   1     0   1   22 15                       37 2 11 22 0   1     0   1   22 15                 37
1130897 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No Elementary KG 06 2017   kindergarten 16 7 12 0   7     0   7   20 29                       49 16 7 12 0   7     0   7   20 29                 49
1130905 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary PK 06 2017   kindergarten 19 8 17 0   4     0   4   29 23                       52 19 8 17 0   4     0   4   29 23                 52

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