enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by district descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
1131078 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
1131079 1131079 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   pre_kindergarten 75 0 3 0   4     0   6   43 45                       88 75 0 3 0   4     0   6   43 45                 88
1131080 1131080 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   grade_1 90 1 5 0   3     1   5   52 53                       105 90 1 5 0   3     1   5   52 53                 105
1131081 1131081 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   grade_2 115 0 4 1   4     0   5   62 67                       129 115 0 4 1   4     0   5   62 67                 129
1131082 1131082 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   grade_3 133 4 7 0   4     0   5   88 65                       153 133 4 7 0   4     0   5   88 65                 153
1131083 1131083 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131084 1131084 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Elementary 04 06 2017   grade_4 137 3 2 0   0     0   6   83 65                       148 137 3 2 0   0     0   6   83 65                 148
1131085 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
1131086 1131086 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Elementary 04 06 2017   grade_6 130 2 3 0   1     0   4   66 74                       140 130 2 3 0   1     0   4   66 74                 140
1131087 1131087 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Elementary 04 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131070 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
1131071 1131071 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   pre_kindergarten 9 0 1 0   0     0   1   7 4                       11 9 0 1 0   0     0   1   7 4                 11
1131072 1131072 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_1 10 0 0 0   0     0   0   3 7                       10 10 0 0 0   0     0   0   3 7                 10
1131073 1131073 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_2 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1131074 1131074 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_3 5 0 0 0   0     0   1   3 3                       6 5 0 0 0   0     0   1   3 3                 6
1131075 1131075 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_4 * * * *   *     *   *   1 2                       *                         1 2                  
1131076 1131076 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_6 8 0 0 0   0     0   0   3 5                       8 8 0 0 0   0     0   0   3 5                 8
1131077 1131077 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130731 1130731 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Elementary PK PK 2017   pre_kindergarten 98 103 330 2   18     2   7   280 280                       560 98 103 330 2   18     2   7   280 280                 560
1130732 1130732 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130733 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
1130734 1130734 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   pre_kindergarten 13 10 22 0   10     0   2   42 15                       57 13 10 22 0   10     0   2   42 15                 57
1130735 1130735 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_1 16 21 44 0   9     0   3   51 42                       93 16 21 44 0   9     0   3   51 42                 93
1130736 1130736 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_2 15 13 24 0   5     0   3   27 33                       60 15 13 24 0   5     0   3   27 33                 60
1130737 1130737 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_3 20 19 34 0   4     0   3   53 27                       80 20 19 34 0   4     0   3   53 27                 80
1130738 1130738 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_4 16 8 35 0   4     0   2   29 36                       65 16 8 35 0   4     0   2   29 36                 65
1130739 1130739 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_5 7 16 35 1   12     0   2   32 41                       73 7 16 35 1   12     0   2   32 41                 73
1130740 1130740 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_6 6 9 26 0   2     0   2   20 25                       45 6 9 26 0   2     0   2   20 25                 45
1130741 1130741 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130742 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
1130743 1130743 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_1 5 4 6 0   1     0   3   11 8                       19 5 4 6 0   1     0   3   11 8                 19
1130744 1130744 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_2 11 0 8 0   2     0   1   11 11                       22 11 0 8 0   2     0   1   11 11                 22
1130745 1130745 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_3 9 1 11 0   1     0   1   12 11                       23 9 1 11 0   1     0   1   12 11                 23
1130746 1130746 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_4 10 5 7 0   1     0   0   12 11                       23 10 5 7 0   1     0   0   12 11                 23
1130747 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
1130748 1130748 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_6 6 2 7 0   0     0   1   9 7                       16 6 2 7 0   0     0   1   9 7                 16
1130749 1130749 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130750 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
1130751 1130751 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   pre_kindergarten 0 0 10 0   1     0   2   8 5                       13 0 0 10 0   1     0   2   8 5                 13
1130752 1130752 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_1 8 10 54 0   6     0   3   39 42                       81 8 10 54 0   6     0   3   39 42                 81
1130753 1130753 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_2 6 6 67 0   9     0   3   43 48                       91 6 6 67 0   9     0   3   43 48                 91
1130754 1130754 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_3 12 3 65 0   8     0   4   49 43                       92 12 3 65 0   8     0   4   49 43                 92
1130755 1130755 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_4 9 3 51 1   10     0   3   36 41                       77 9 3 51 1   10     0   3   36 41                 77
1130756 1130756 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_5 8 9 72 0   10     0   1   52 48                       100 8 9 72 0   10     0   1   52 48                 100
1130757 1130757 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   grade_6 3 7 57 0   8     0   0   41 34                       75 3 7 57 0   8     0   0   41 34                 75
1130758 1130758 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130759 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
1130760 1130760 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_1 8 4 25 0   0     0   2   20 19                       39 8 4 25 0   0     0   2   20 19                 39
1130761 1130761 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_2 8 6 20 0   0     0   0   18 16                       34 8 6 20 0   0     0   0   18 16                 34
1130762 1130762 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_3 16 10 15 0   1     0   1   21 22                       43 16 10 15 0   1     0   1   21 22                 43
1130763 1130763 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_4 10 4 12 0   3     0   1   16 14                       30 10 4 12 0   3     0   1   16 14                 30
1130764 1130764 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_5 9 7 17 0   1     0   2   20 16                       36 9 7 17 0   1     0   2   20 16                 36
1130765 1130765 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_6 8 6 15 0   2     0   1   18 14                       32 8 6 15 0   2     0   1   18 14                 32
1130766 1130766 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130767 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
1130768 1130768 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   pre_kindergarten 1 4 17 0   4     0   0   14 12                       26 1 4 17 0   4     0   0   14 12                 26
1130769 1130769 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_1 10 10 27 0   5     0   3   33 22                       55 10 10 27 0   5     0   3   33 22                 55
1130770 1130770 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_2 10 9 22 1   6     0   1   29 20                       49 10 9 22 1   6     0   1   29 20                 49
1130771 1130771 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_3 7 9 22 1   4     0   0   26 17                       43 7 9 22 1   4     0   0   26 17                 43
1130772 1130772 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_4 10 4 27 0   8     0   0   27 22                       49 10 4 27 0   8     0   0   27 22                 49
1130773 1130773 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_5 7 6 31 0   10     0   0   28 26                       54 7 6 31 0   10     0   0   28 26                 54
1130774 1130774 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   grade_6 7 6 24 0   6     0   0   18 25                       43 7 6 24 0   6     0   0   18 25                 43
1130775 1130775 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130776 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
1130777 1130777 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   grade_1 14 12 47 0   5     0   2   38 42                       80 14 12 47 0   5     0   2   38 42                 80
1130778 1130778 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   grade_2 17 14 38 0   5     0   1   42 33                       75 17 14 38 0   5     0   1   42 33                 75
1130779 1130779 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   grade_3 12 10 49 0   5     0   2   44 34                       78 12 10 49 0   5     0   2   44 34                 78
1130780 1130780 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   grade_4 11 10 46 0   8     0   4   35 44                       79 11 10 46 0   8     0   4   35 44                 79
1130781 1130781 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   grade_5 4 11 38 0   14     0   0   41 26                       67 4 11 38 0   14     0   0   41 26                 67
1130782 1130782 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   grade_6 5 12 43 0   7     0   2   35 34                       69 5 12 43 0   7     0   2   35 34                 69
1130783 1130783 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130784 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
1130785 1130785 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   pre_kindergarten 10 1 11 0   1     0   0   15 8                       23 10 1 11 0   1     0   0   15 8                 23
1130786 1130786 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   grade_1 11 4 57 0   1     0   0   33 40                       73 11 4 57 0   1     0   0   33 40                 73
1130787 1130787 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   grade_2 11 2 47 0   0     0   2   27 35                       62 11 2 47 0   0     0   2   27 35                 62
1130788 1130788 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   grade_3 10 3 54 0   1     0   3   35 36                       71 10 3 54 0   1     0   3   35 36                 71
1130789 1130789 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   grade_4 7 4 31 0   2     0   2   28 18                       46 7 4 31 0   2     0   2   28 18                 46
1130790 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
1130791 1130791 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   grade_6 3 4 60 0   3     0   2   27 45                       72 3 4 60 0   3     0   2   27 45                 72
1130792 1130792 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130793 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
1130794 1130794 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   pre_kindergarten 5 2 10 0   6     0   1   12 12                       24 5 2 10 0   6     0   1   12 12                 24
1130795 1130795 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   grade_1 21 11 38 0   2     0   1   33 40                       73 21 11 38 0   2     0   1   33 40                 73
1130796 1130796 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   grade_2 27 11 35 0   4     0   5   46 36                       82 27 11 35 0   4     0   5   46 36                 82
1130797 1130797 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   grade_3 22 6 30 0   4     0   1   29 34                       63 22 6 30 0   4     0   1   29 34                 63
1130798 1130798 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   grade_4 11 7 38 0   2     0   2   37 23                       60 11 7 38 0   2     0   2   37 23                 60
1130799 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
1130800 1130800 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   grade_6 15 3 34 0   1     0   2   26 29                       55 15 3 34 0   1     0   2   26 29                 55
1130801 1130801 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130802 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
1130803 1130803 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_1 3 5 15 0   2     0   1   11 15                       26 3 5 15 0   2     0   1   11 15                 26
1130804 1130804 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_2 8 7 11 0   1     0   1   12 16                       28 8 7 11 0   1     0   1   12 16                 28
1130805 1130805 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_3 10 5 11 0   1     0   1   19 9                       28 10 5 11 0   1     0   1   19 9                 28
1130806 1130806 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_4 4 3 16 0   1     0   2   15 11                       26 4 3 16 0   1     0   2   15 11                 26
1130807 1130807 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_5 4 3 17 0   1     0   3   15 13                       28 4 3 17 0   1     0   3   15 13                 28
1130808 1130808 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_6 2 11 15 0   0     0   0   21 7                       28 2 11 15 0   0     0   0   21 7                 28
1130809 1130809 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130810 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
1130811 1130811 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2017   pre_kindergarten 17 8 21 1   9     0   1   35 22                       57 17 8 21 1   9     0   1   35 22                 57
1130812 1130812 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2017   grade_1 11 10 33 0   8     0   4   36 30                       66 11 10 33 0   8     0   4   36 30                 66

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