Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by school_nces_id 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
2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
744273 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_5 15 0 0 0   0     0   1   7 9                       16 15 0 0 0   0     0   1   7 9                 16
941100 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2016   grade_5 15 0 1 0   0     0   0   4 12                       16 15 0 1 0   0     0   0   4 12                 16
1132092 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_5 11 0 0 0   0     0   1   6 6                       12 11 0 0 0   0     0   1   6 6                 12
1373330 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   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
1680595 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg - Farmington River Elementary   Regular School No Elementary PK 06 2021   grade_5 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
2048393 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   grade_5 11 0 0 0   0     0   0   10 1                       11.0 11 0 0 0   0     0   0   10 1                 11
2238923 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_5 17 0 0 0   0     0   0   9 8                       17.0 17 0 0 0   0     0   0   9 8                 17
743399 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No 2 04 06 2015   grade_5 152 2 5 0   1     0   3   98 65                       163 152 2 5 0   1     0   3   98 65                 163
940216 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No 2 04 06 2016   grade_5 126 2 4 0   1     0   4   66 71                       137 126 2 4 0   1     0   4   66 71                 137
1131085 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Elementary 04 06 2017   grade_5 131 1 8 0   6     0   5   84 67                       151 131 1 8 0   6     0   5   84 67                 151
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
1679694 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham - Charles E Roderick   Regular School No Middle 04 06 2021   grade_5 95 2 7 2   3     1   8   56 62 *                     118.0 95 2 7 2   3     1   8   56 62                 118
2047503 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Middle 04 06 2019   grade_5 135 4 7 2   4     0   6   93 65                       158.0 135 4 7 2   4     0   6   93 65                 158
2237910 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham: Charles E Roderick   Regular School No Middle 04 06 2018   grade_5 139 1 2 0   1     0   6   82 67                       149.0 139 1 2 0   1     0   6   82 67                 149
940208 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No 1 PK 06 2016   grade_5 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
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
1679686 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington - R. H. Conwell   Regular School No Elementary PK 06 2021   grade_5 9 0 0 0   0     0   0   2 7 *                     9.0 9 0 0 0   0     0   0   2 7                 9
2047495 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   grade_5 6 0 0 0   0     0   1   4 3                       7.0 6 0 0 0   0     0   1   4 3                 7
2237901 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   grade_5 * * * *   *     *   *   1 2                       3.0                         1 2                 3
743159 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2015   grade_5 14 7 40 0   1     0   7   40 29                       69 14 7 40 0   1     0   7   40 29                 69
939968 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2016   grade_5 17 6 33 0   1     0   5   34 28                       62 17 6 33 0   1     0   5   34 28                 62
1130799 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   grade_5 20 14 35 0   2     0   4   31 44                       75 20 14 35 0   2     0   4   31 44                 75
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
1679444 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester - City View   Regular School No Elementary PK 06 2021   grade_5 19 15 38 0   0     0   4   38 38 *                     76.0 19 15 38 0   0     0   4   38 38                 76
2047255 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2019   grade_5 12 5 32 0   2     0   1   22 30                       52.0 12 5 32 0   2     0   1   22 30                 52
2237626 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   grade_5 8 4 37 0   2     0   1   29 23                       52.0 8 4 37 0   2     0   1   29 23                 52
743229 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2015   grade_5 9 10 26 0   0     0   6   23 28                       51 9 10 26 0   0     0   6   23 28                 51
940038 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2016   grade_5 9 13 23 0   4     0   3   23 29                       52 9 13 23 0   4     0   3   23 29                 52
1130877 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2017   grade_5 10 12 31 0   1     0   2   27 29                       56 10 12 31 0   1     0   2   27 29                 56
1372250 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   grade_5 8 14 23 0   0     0   4   25 24 *                     49.0 8 14 23 0   0     0   4   25 24                 49
1679512 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester - Jacob Hiatt Magnet   Regular School No Elementary PK 06 2021   grade_5 4 14 22 0   1     0   3   15 29 *                     44.0 4 14 22 0   1     0   3   15 29                 44
2047323 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2019   grade_5 8 15 18 0   0     0   2   22 21                       43.0 8 15 18 0   0     0   2   22 21                 43
2237703 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_5 7 5 24 0   5     0   4   21 24                       45.0 7 5 24 0   5     0   4   21 24                 45
743151 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2015   grade_5 6 1 62 0   4     0   1   33 41                       74 6 1 62 0   4     0   1   33 41                 74
939960 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2016   grade_5 1 5 57 0   3     0   2   31 37                       68 1 5 57 0   3     0   2   31 37                 68
1130790 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   grade_5 4 1 34 0   3     0   0   22 20                       42 4 1 34 0   3     0   0   22 20                 42
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
1679436 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester - Chandler Magnet   Regular School No Elementary PK 06 2021   grade_5 4 4 59 0   0     0   0   31 36 *                     67.0 4 4 59 0   0     0   0   31 36                 67
2047247 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2019   grade_5 9 2 58 0   0     0   2   34 37                       71.0 9 2 58 0   0     0   2   34 37                 71
2237617 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   grade_5 6 3 34 0   1     0   1   28 17                       45.0 6 3 34 0   1     0   1   28 17                 45
743349 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2015   grade_5 13 14 25 0   1     0   2   28 27                       55 13 14 25 0   1     0   2   28 27                 55
940158 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2016   grade_5 13 15 31 0   2     0   3   40 24                       64 13 15 31 0   2     0   3   40 24                 64
1131014 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2017   grade_5 8 15 33 1   4     0   5   29 37                       66 8 15 33 1   4     0   5   29 37                 66
1372370 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2020   grade_5 12 12 38 1   0     0   1   40 24 *                     64.0 12 12 38 1   0     0   1   40 24                 64
1679633 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester - Vernon Hill School   Regular School No Elementary PK 06 2021   grade_5 12 15 22 0   0     0   2   25 26 *                     51.0 12 15 22 0   0     0   2   25 26                 51
2047443 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2019   grade_5 23 22 29 0   2     0   4   40 40                       80.0 23 22 29 0   2     0   4   40 40                 80
2237839 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_5 22 14 41 0   3     0   7   37 50                       87.0 22 14 41 0   3     0   7   37 50                 87
743341 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2015   grade_5 20 5 4 0   2     0   3   15 19                       34 20 5 4 0   2     0   3   15 19                 34
940150 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2016   grade_5 27 2 4 0   2     0   1   17 19                       36 27 2 4 0   2     0   1   17 19                 36
1131005 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2017   grade_5 30 4 3 0   3     0   3   17 26                       43 30 4 3 0   3     0   3   17 26                 43
1372362 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2020   grade_5 29 3 7 0   3     0   1   20 23 *                     43.0 29 3 7 0   3     0   1   20 23                 43
1679625 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester - West Tatnuck   Regular School No Elementary PK 06 2021   grade_5 17 4 8 0   2     0   3   16 18 *                     34.0 17 4 8 0   2     0   3   16 18                 34
2047435 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2019   grade_5 33 1 8 0   2     0   4   19 29                       48.0 33 1 8 0   2     0   4   19 29                 48
2237830 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   grade_5 29 6 7 0   2     0   6   25 25                       50.0 29 6 7 0   2     0   6   25 25                 50
743113 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2015   grade_5 7 5 11 0   0     0   2   13 12                       25 7 5 11 0   0     0   2   13 12                 25
939922 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2016   grade_5 5 2 10 0   1     0   1   9 10                       19 5 2 10 0   1     0   1   9 10                 19
1130747 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_5 7 4 7 0   4     0   0   13 9                       22 7 4 7 0   4     0   0   13 9                 22
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
1679399 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester - Wawecus Road School   Regular School No Elementary KG 06 2021   grade_5 7 4 10 0   2     0   1   15 9 *                     24.0 7 4 10 0   2     0   1   15 9                 24
2047210 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2019   grade_5 10 3 13 0   2     0   0   14 14                       28.0 10 3 13 0   2     0   0   14 14                 28
2237575 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_5 11 4 6 0   1     0   0   10 12                       22.0 11 4 6 0   1     0   0   10 12                 22
743333 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2015   grade_5 9 5 31 0   0     0   5   35 15                       50 9 5 31 0   0     0   5   35 15                 50
940142 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2016   grade_5 10 11 43 0   3     0   3   36 34                       70 10 11 43 0   3     0   3   36 34                 70
1130996 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2017   grade_5 9 9 57 0   7     0   3   45 40                       85 9 9 57 0   7     0   3   45 40                 85
1372354 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2020   grade_5 13 8 37 0   0     0   0   25 33 *                     58.0 13 8 37 0   0     0   0   25 33                 58
1679617 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Worcester - Union Hill School   Regular School No Elementary KG 06 2021   grade_5 8 4 35 0   1     0   2   25 25 *                     50.0 8 4 35 0   1     0   2   25 25                 50
2047427 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2019   grade_5 18 8 39 0   2     0   1   32 36                       68.0 18 8 39 0   2     0   1   32 36                 68
2237821 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Worcester: Union Hill School   Regular School No Elementary KG 06 2018   grade_5 18 12 40 0   1     0   1   42 30                       72.0 18 12 40 0   1     0   1   42 30                 72
743326 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2015   grade_5 35 0 15 0   2     0   2   28 26                       54 35 0 15 0   2     0   2   28 26                 54
940135 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2016   grade_5 27 3 17 0   1     0   1   18 31                       49 27 3 17 0   1     0   1   18 31                 49
1130988 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2017   grade_5 28 7 10 0   0     0   2   18 29                       47 28 7 10 0   0     0   2   18 29                 47
1372347 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2020   grade_5 30 7 10 0   1     0   3   28 23 *                     51.0 30 7 10 0   1     0   3   28 23                 51
1679610 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Worcester - Thorndyke Road   Regular School No Elementary KG 06 2021   grade_5 18 12 20 0   4     0   2   35 21 *                     56.0 18 12 20 0   4     0   2   35 21                 56
2047420 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2019   grade_5 23 5 21 0   3     0   5   28 29                       57.0 23 5 21 0   3     0   5   28 29                 57
2237813 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Worcester: Thorndyke Road   Regular School No Elementary KG 06 2018   grade_5 28 7 16 0   0     0   1   25 27                       52.0 28 7 16 0   0     0   1   25 27                 52
743319 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2015   grade_5 27 11 19 0   3     0   3   30 33                       63 27 11 19 0   3     0   3   30 33                 63
940128 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2016   grade_5 20 12 19 0   2     0   1   35 19                       54 20 12 19 0   2     0   1   35 19                 54
1130980 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2017   grade_5 19 11 11 0   3     0   2   17 29                       46 19 11 11 0   3     0   2   17 29                 46
1372340 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2020   grade_5 20 14 10 0   4     0   3   24 27 *                     51.0 20 14 10 0   4     0   3   24 27                 51
1679603 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester - Tatnuck   Regular School No Elementary PK 06 2021   grade_5 22 7 16 0   2     0   3   23 27 *                     50.0 22 7 16 0   2     0   3   23 27                 50
2047413 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2019   grade_5 20 15 11 0   4     0   5   27 28                       55.0 20 15 11 0   4     0   5   27 28                 55
2237805 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester: Tatnuck   Regular School No Elementary PK 06 2018   grade_5 22 10 7 0   5     0   3   15 32                       47.0 22 10 7 0   5     0   3   15 32                 47
743312 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2015   grade_5 19 10 8 0   2     0   4   14 29                       43 19 10 8 0   2     0   4   14 29                 43
940121 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2016   grade_5 35 5 8 0   1     0   5   21 33                       54 35 5 8 0   1     0   5   21 33                 54
1130971 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   grade_5 25 7 10 0   1     0   1   20 24                       44 25 7 10 0   1     0   1   20 24                 44
1372332 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2020   grade_5 25 8 10 0   2     0   7   22 30 *                     52.0 25 8 10 0   2     0   7   22 30                 52
1679595 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester - Worcester Arts Magnet School   Regular School No Elementary PK 06 2021   grade_5 27 12 10 0   3     0   4   21 35 *                     56.0 27 12 10 0   3     0   4   21 35                 56
2047405 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   grade_5 32 11 14 0   0     0   2   31 28                       59.0 32 11 14 0   0     0   2   31 28                 59
2237796 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester: Worcester Arts Magnet School   Regular School No Elementary PK 06 2018   grade_5 21 10 9 0   5     0   6   24 27                       51.0 21 10 9 0   5     0   6   24 27                 51
743304 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2015   grade_5 38 8 31 0   5     0   2   42 42                       84 38 8 31 0   5     0   2   42 42                 84
940113 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2016   grade_5 37 12 28 0   3     0   3   35 48                       83 37 12 28 0   3     0   3   35 48                 83
1130962 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2017   grade_5 32 14 40 0   3     0   3   35 57                       92 32 14 40 0   3     0   3   35 57                 92
1372324 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2020   grade_5 44 19 19 0   6     0   5   49 44 *                     93.0 44 19 19 0   6     0   5   49 44                 93
1679587 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Worcester - Roosevelt   Regular School No Elementary PK 06 2021   grade_5 30 16 20 0   1     0   3   35 35 *                     70.0 30 16 20 0   1     0   3   35 35                 70
2047397 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2019   grade_5 44 19 23 0   3     0   5   51 43                       94.0 44 19 23 0   3     0   5   51 43                 94
2237787 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Worcester: Roosevelt   Regular School No Elementary PK 06 2018   grade_5 32 13 24 0   2     0   2   38 35                       73.0 32 13 24 0   2     0   2   38 35                 73
743296 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2015   grade_5 20 10 20 0   6     0   2   27 31                       58 20 10 20 0   6     0   2   27 31                 58
940105 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2016   grade_5 18 11 23 0   4     0   4   38 22                       60 18 11 23 0   4     0   4   38 22                 60
1130953 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No Elementary KG 06 2017   grade_5 19 13 26 0   6     0   4   34 34                       68 19 13 26 0   6     0   4   34 34                 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]);