enrollments

Data source: Big Local News · About: Big Local

11,284 rows where state = "MA" and year = 2018 sorted by school_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 11,284 ✖
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
2230202 2230202 MA Suffolk   school   35   Boston   350652               2018   kindergarten * * * *   *     *   *   * *                       0.0                                             0
2230203 2230203 MA Suffolk   school   35   Boston   350652               2018   pre_kindergarten * * * *   *     *   *   * *                       0.0                                             0
2230204 2230204 MA Suffolk   school   35   Boston   350652               2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2230205 2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2230206 2230206 MA Suffolk   school   35   Boston   350652               2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
2230207 2230207 MA Suffolk   school   35   Boston   350652               2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
2230208 2230208 MA Suffolk   school   35   Boston   350652               2018   grade_5 * * * *   *     *   *   * *                       0.0                                             0
2230209 2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2230210 2230210 MA Suffolk   school   35   Boston   350652               2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2230211 2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2230212 2230212 MA Suffolk   school   35   Boston   350652               2018   grade_9 * * * *   *     *   *   * *                       1.0                                             1
2230213 2230213 MA Suffolk   school   35   Boston   350652               2018   grade_10 * * * *   *     *   *   * *                       0.0                                             0
2230214 2230214 MA Suffolk   school   35   Boston   350652               2018   grade_11 * * * *   *     *   *   * *                       0.0                                             0
2230215 2230215 MA Suffolk   school   35   Boston   350652               2018   grade_12 * * * *   *     *   *   * *                       0.0                                             0
2230216 2230216 MA Suffolk   school   35   Boston   350652               2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238917 2238917 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   kindergarten 14 0 2 0   0     0   0   12 4                       16.0 14 0 2 0   0     0   0   12 4                 16
2238918 2238918 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 28 0 0 0   1     0   0   16 13                       29.0 28 0 0 0   1     0   0   16 13                 29
2238919 2238919 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_1 14 0 0 0   0     0   0   7 7                       14.0 14 0 0 0   0     0   0   7 7                 14
2238920 2238920 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_2 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2238921 2238921 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_3 11 0 0 0   0     0   0   6 5                       11.0 11 0 0 0   0     0   0   6 5                 11
2238922 2238922 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_4 12 0 0 0   0     0   0   10 2                       12.0 12 0 0 0   0     0   0   10 2                 12
2238923 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
2238924 2238924 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_6 11 0 0 0   0     0   1   7 5                       12.0 11 0 0 0   0     0   1   7 5                 12
2238925 2238925 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237903 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
2237904 2237904 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   pre_kindergarten 69 1 3 1   4     0   5   42 41                       83.0 69 1 3 1   4     0   5   42 41                 83
2237905 2237905 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   grade_1 105 2 9 0   3     0   3   64 58                       122.0 105 2 9 0   3     0   3   64 58                 122
2237906 2237906 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   grade_2 97 1 4 0   4     1   6   55 58                       113.0 97 1 4 0   4     1   6   55 58                 113
2237907 2237907 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   grade_3 114 0 7 2   4     0   5   62 70                       132.0 114 0 7 2   4     0   5   62 70                 132
2237908 2237908 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237909 2237909 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham: Charles E Roderick   Regular School No Middle 04 06 2018   grade_4 139 4 7 0   4     0   7   92 69                       161.0 139 4 7 0   4     0   7   92 69                 161
2237910 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
2237911 2237911 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham: Charles E Roderick   Regular School No Middle 04 06 2018   grade_6 134 2 9 0   6     0   5   85 71                       156.0 134 2 9 0   6     0   5   85 71                 156
2237912 2237912 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham: Charles E Roderick   Regular School No Middle 04 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237895 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
2237896 2237896 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   pre_kindergarten 12 0 0 1   0     0   1   5 9                       14.0 12 0 0 1   0     0   1   5 9                 14
2237897 2237897 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   grade_1 9 0 0 0   0     0   0   1 8                       9.0 9 0 0 0   0     0   0   1 8                 9
2237898 2237898 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   grade_2 9 0 0 0   0     0   0   1 8                       9.0 9 0 0 0   0     0   0   1 8                 9
2237899 2237899 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   grade_3 7 0 0 0   0     0   0   5 2                       7.0 7 0 0 0   0     0   0   5 2                 7
2237900 2237900 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   grade_4 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2237901 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
2237902 2237902 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237559 2237559 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Worcester: Head Start   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 104 107 290 0   12     0   16   254 275                       529.0 104 107 290 0   12     0   16   254 275                 529
2237560 2237560 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Worcester: Head Start   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237620 2237620 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   kindergarten 16 9 44 0   5     0   3   38 39                       77.0 16 9 44 0   5     0   3   38 39                 77
2237621 2237621 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   pre_kindergarten 8 3 13 0   2     0   2   19 9                       28.0 8 3 13 0   2     0   2   19 9                 28
2237622 2237622 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   grade_1 13 10 31 0   1     0   4   28 31                       59.0 13 10 31 0   1     0   4   28 31                 59
2237623 2237623 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   grade_2 20 11 33 0   1     0   2   30 37                       67.0 20 11 33 0   1     0   2   30 37                 67
2237624 2237624 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   grade_3 23 15 29 0   3     0   6   50 26                       76.0 23 15 29 0   3     0   6   50 26                 76
2237625 2237625 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   grade_4 16 6 28 0   3     0   0   25 28                       53.0 16 6 28 0   3     0   0   25 28                 53
2237626 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
2237627 2237627 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   grade_6 14 14 29 0   1     0   4   28 34                       62.0 14 14 29 0   1     0   4   28 34                 62
2237628 2237628 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237697 2237697 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   kindergarten 4 20 35 0   3     0   1   36 27                       63.0 4 20 35 0   3     0   1   36 27                 63
2237698 2237698 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   pre_kindergarten 6 10 26 0   1     0   0   24 19                       43.0 6 10 26 0   1     0   0   24 19                 43
2237699 2237699 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_1 5 19 30 0   1     0   1   27 29                       56.0 5 19 30 0   1     0   1   27 29                 56
2237700 2237700 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_2 4 20 25 0   1     0   5   22 33                       55.0 4 20 25 0   1     0   5   22 33                 55
2237701 2237701 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_3 7 17 27 0   1     0   5   29 28                       57.0 7 17 27 0   1     0   5   29 28                 57
2237702 2237702 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_4 10 15 22 0   0     0   1   26 22                       48.0 10 15 22 0   0     0   1   26 22                 48
2237703 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
2237704 2237704 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_6 7 10 18 0   0     0   1   17 19                       36.0 7 10 18 0   0     0   1   17 19                 36
2237705 2237705 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237611 2237611 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   kindergarten 11 1 59 0   5     0   1   31 46                       77.0 11 1 59 0   5     0   1   31 46                 77
2237612 2237612 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   pre_kindergarten 4 0 6 0   1     0   0   4 7                       11.0 4 0 6 0   1     0   0   4 7                 11
2237613 2237613 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   grade_1 7 1 50 0   5     0   0   32 31                       63.0 7 1 50 0   5     0   0   32 31                 63
2237614 2237614 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   grade_2 8 4 44 0   1     0   0   21 36                       57.0 8 4 44 0   1     0   0   21 36                 57
2237615 2237615 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   grade_3 10 1 49 0   1     0   2   28 35                       63.0 10 1 49 0   1     0   2   28 35                 63
2237616 2237616 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   grade_4 9 3 59 0   0     0   3   37 37                       74.0 9 3 59 0   0     0   3   37 37                 74
2237617 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
2237618 2237618 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   grade_6 4 1 35 0   4     0   0   24 20                       44.0 4 1 35 0   4     0   0   24 20                 44
2237619 2237619 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237833 2237833 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   kindergarten 13 21 31 0   3     0   3   37 34                       71.0 13 21 31 0   3     0   3   37 34                 71
2237834 2237834 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   pre_kindergarten 14 12 26 0   3     0   0   37 18                       55.0 14 12 26 0   3     0   0   37 18                 55
2237835 2237835 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_1 11 13 35 0   3     0   4   34 32                       66.0 11 13 35 0   3     0   4   34 32                 66
2237836 2237836 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_2 11 10 23 0   1     0   3   25 23                       48.0 11 10 23 0   1     0   3   25 23                 48
2237837 2237837 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_3 15 12 37 0   0     0   3   44 23                       67.0 15 12 37 0   0     0   3   44 23                 67
2237838 2237838 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_4 24 18 30 0   2     0   6   37 43                       80.0 24 18 30 0   2     0   6   37 43                 80
2237839 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
2237840 2237840 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_6 13 14 27 0   3     0   5   29 33                       62.0 13 14 27 0   3     0   5   29 33                 62
2237841 2237841 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237890 2237890 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester: Worcester Technical High   Career and Technical School No High 09 12 2018   grade_9 137 58 144 1   23     0   17   193 187                       380.0 137 58 144 1   23     0   17   193 187                 380
2237891 2237891 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester: Worcester Technical High   Career and Technical School No High 09 12 2018   grade_10 126 65 117 0   27     0   11   143 203                       346.0 126 65 117 0   27     0   11   143 203                 346
2237892 2237892 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester: Worcester Technical High   Career and Technical School No High 09 12 2018   grade_11 124 59 119 0   15     0   11   146 182                       328.0 124 59 119 0   15     0   11   146 182                 328
2237893 2237893 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester: Worcester Technical High   Career and Technical School No High 09 12 2018   grade_12 125 44 135 0   20     0   11   149 186                       335.0 125 44 135 0   20     0   11   149 186                 335
2237894 2237894 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester: Worcester Technical High   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237862 2237862 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_6 17 21 41 1   7     0   6   42 51                       93.0 17 21 41 1   7     0   6   42 51                 93
2237863 2237863 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_7 78 69 204 0   22     0   17   196 194                       390.0 78 69 204 0   22     0   17   196 194                 390
2237864 2237864 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   grade_8 76 57 175 0   22     0   8   174 164                       338.0 76 57 175 0   22     0   8   174 164                 338
2237865 2237865 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237824 2237824 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   kindergarten 34 4 14 0   2     0   5   32 27                       59.0 34 4 14 0   2     0   5   32 27                 59
2237825 2237825 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   pre_kindergarten 23 3 12 0   3     0   3   25 19                       44.0 23 3 12 0   3     0   3   25 19                 44
2237826 2237826 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   grade_1 32 2 3 0   3     0   3   20 23                       43.0 32 2 3 0   3     0   3   20 23                 43
2237827 2237827 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   grade_2 23 6 8 0   2     0   3   21 21                       42.0 23 6 8 0   2     0   3   21 21                 42
2237828 2237828 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   grade_3 33 6 4 0   4     0   1   24 24                       48.0 33 6 4 0   4     0   1   24 24                 48
2237829 2237829 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   grade_4 34 0 7 0   2     0   2   19 26                       45.0 34 0 7 0   2     0   2   19 26                 45
2237830 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
2237831 2237831 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   grade_6 25 4 3 0   3     0   4   17 22                       39.0 25 4 3 0   3     0   4   17 22                 39
2237832 2237832 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2237570 2237570 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   kindergarten 5 1 10 0   1     0   1   10 8                       18.0 5 1 10 0   1     0   1   10 8                 18
2237571 2237571 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_1 3 2 7 0   0     0   1   6 7                       13.0 3 2 7 0   0     0   1   6 7                 13

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