enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2229162 2229162 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown: Swift River Elementary   Regular School No Elementary 01 03 2018   grade_1 132 3 5 0   1     0   8   74 75                       149.0 132 3 5 0   1     0   8   74 75                 149
2229163 2229163 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown: Swift River Elementary   Regular School No Elementary 01 03 2018   grade_2 138 4 4 2   3     0   5   82 74                       156.0 138 4 4 2   3     0   5   82 74                 156
2229164 2229164 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown: Swift River Elementary   Regular School No Elementary 01 03 2018   grade_3 133 4 14 1   1     0   9   84 78                       162.0 133 4 14 1   1     0   9   84 78                 162
2229165 2229165 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown: Swift River Elementary   Regular School No Elementary 01 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229937 2229937 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_1 1 1 4 0   0     0   1   6 1                       7.0 1 1 4 0   0     0   1   6 1                 7
2229938 2229938 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_3 0 9 3 0   0     0   0   10 2                       12.0 0 9 3 0   0     0   0   10 2                 12
2229939 2229939 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_4 0 10 3 0   0     0   0   10 3                       13.0 0 10 3 0   0     0   0   10 3                 13
2229940 2229940 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_5 4 9 5 0   0     0   0   16 2                       18.0 4 9 5 0   0     0   0   16 2                 18
2229941 2229941 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_6 1 5 12 0   0     0   0   15 3                       18.0 1 5 12 0   0     0   0   15 3                 18
2229942 2229942 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_7 3 15 12 1   0     0   0   25 6                       31.0 3 15 12 1   0     0   0   25 6                 31
2229943 2229943 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_8 2 17 14 0   1     0   3   30 7                       37.0 2 17 14 0   1     0   3   30 7                 37
2229944 2229944 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_9 2 39 23 0   2     0   1   49 18                       67.0 2 39 23 0   2     0   1   49 18                 67
2229945 2229945 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_10 4 27 21 0   0     0   0   34 18                       52.0 4 27 21 0   0     0   0   34 18                 52
2229946 2229946 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_11 3 21 9 0   0     0   1   21 13                       34.0 3 21 9 0   0     0   1   21 13                 34
2229947 2229947 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_12 3 35 15 0   3     0   3   45 14                       59.0 3 35 15 0   3     0   3   45 14                 59
2229948 2229948 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229998 2229998 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_1 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2229999 2229999 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_3 1 42 35 1   1     0   3   46 37                       83.0 1 42 35 1   1     0   3   46 37                 83
2230000 2230000 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_4 1 37 18 0   0     0   3   29 30                       59.0 1 37 18 0   0     0   3   29 30                 59
2230001 2230001 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_5 2 20 26 0   0     0   3   29 22                       51.0 2 20 26 0   0     0   3   29 22                 51
2230002 2230002 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_6 0 20 21 0   0     0   4   22 23                       45.0 0 20 21 0   0     0   4   22 23                 45
2230003 2230003 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_7 0 12 11 0   0     0   2   13 12                       25.0 0 12 11 0   0     0   2   13 12                 25
2230004 2230004 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_8 0 15 18 0   0     0   2   18 17                       35.0 0 15 18 0   0     0   2   18 17                 35
2230005 2230005 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230343 2230343 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree: Liberty   Regular School No Elementary 01 05 2018   grade_1 55 2 4 0   19     0   3   44 39                       83.0 55 2 4 0   19     0   3   44 39                 83
2230344 2230344 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree: Liberty   Regular School No Elementary 01 05 2018   grade_2 56 1 1 0   25     0   3   42 44                       86.0 56 1 1 0   25     0   3   42 44                 86
2230345 2230345 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree: Liberty   Regular School No Elementary 01 05 2018   grade_3 61 1 4 0   26     0   2   46 48                       94.0 61 1 4 0   26     0   2   46 48                 94
2230346 2230346 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree: Liberty   Regular School No Elementary 01 05 2018   grade_4 53 1 5 0   26     1   1   43 44                       87.0 53 1 5 0   26     1   1   43 44                 87
2230347 2230347 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree: Liberty   Regular School No Elementary 01 05 2018   grade_5 79 5 4 0   22     0   0   55 55                       110.0 79 5 4 0   22     0   0   55 55                 110
2230348 2230348 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree: Liberty   Regular School No Elementary 01 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230894 2230894 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea: William A Berkowitz Elementary   Regular School No Elementary 01 04 2018   grade_1 7 7 103 0   0     0   0   66 51                       117.0 7 7 103 0   0     0   0   66 51                 117
2230895 2230895 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea: William A Berkowitz Elementary   Regular School No Elementary 01 04 2018   grade_2 6 8 103 0   1     0   1   65 54                       119.0 6 8 103 0   1     0   1   65 54                 119
2230896 2230896 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea: William A Berkowitz Elementary   Regular School No Elementary 01 04 2018   grade_3 18 5 112 0   3     0   1   80 59                       139.0 18 5 112 0   3     0   1   80 59                 139
2230897 2230897 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea: William A Berkowitz Elementary   Regular School No Elementary 01 04 2018   grade_4 11 7 115 0   1     1   0   72 63                       135.0 11 7 115 0   1     1   0   72 63                 135
2230898 2230898 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea: William A Berkowitz Elementary   Regular School No Elementary 01 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230899 2230899 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea: Edgar A Hooks Elementary   Regular School No Elementary 01 04 2018   grade_1 17 8 89 1   0     0   1   60 56                       116.0 17 8 89 1   0     0   1   60 56                 116
2230900 2230900 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea: Edgar A Hooks Elementary   Regular School No Elementary 01 04 2018   grade_2 13 8 127 0   1     0   4   89 64                       153.0 13 8 127 0   1     0   4   89 64                 153
2230901 2230901 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea: Edgar A Hooks Elementary   Regular School No Elementary 01 04 2018   grade_3 16 12 138 0   1     0   2   86 83                       169.0 16 12 138 0   1     0   2   86 83                 169
2230902 2230902 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea: Edgar A Hooks Elementary   Regular School No Elementary 01 04 2018   grade_4 14 13 121 1   2     0   1   84 68                       152.0 14 13 121 1   2     0   1   84 68                 152
2230903 2230903 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea: Edgar A Hooks Elementary   Regular School No Elementary 01 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230904 2230904 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea: George F. Kelly Elementary   Regular School No Elementary 01 04 2018   grade_1 3 6 124 0   0     0   2   68 67                       135.0 3 6 124 0   0     0   2   68 67                 135
2230905 2230905 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea: George F. Kelly Elementary   Regular School No Elementary 01 04 2018   grade_2 9 3 107 0   0     0   1   57 63                       120.0 9 3 107 0   0     0   1   57 63                 120
2230906 2230906 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea: George F. Kelly Elementary   Regular School No Elementary 01 04 2018   grade_3 5 4 140 0   2     0   1   83 69                       152.0 5 4 140 0   2     0   1   83 69                 152
2230907 2230907 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea: George F. Kelly Elementary   Regular School No Elementary 01 04 2018   grade_4 1 2 135 0   1     0   1   66 74                       140.0 1 2 135 0   1     0   1   66 74                 140
2230908 2230908 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea: George F. Kelly Elementary   Regular School No Elementary 01 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230909 2230909 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_1 7 9 92 0   1     0   0   59 50                       109.0 7 9 92 0   1     0   0   59 50                 109
2230910 2230910 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_2 15 4 118 0   0     0   2   66 73                       139.0 15 4 118 0   0     0   2   66 73                 139
2230911 2230911 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_3 10 15 119 0   2     0   4   76 74                       150.0 10 15 119 0   2     0   4   76 74                 150
2230912 2230912 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_4 8 7 150 0   2     0   3   101 69                       170.0 8 7 150 0   2     0   3   101 69                 170
2230913 2230913 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231152 2231152 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_1 80 1 4 0   2     0   9   56 40                       96.0 80 1 4 0   2     0   9   56 40                 96
2231153 2231153 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_2 62 0 2 0   0     0   3   31 36                       67.0 62 0 2 0   0     0   3   31 36                 67
2231154 2231154 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_3 76 1 2 0   0     0   5   41 43                       84.0 76 1 2 0   0     0   5   41 43                 84
2231155 2231155 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_4 77 1 7 0   0     0   1   39 47                       86.0 77 1 7 0   0     0   1   39 47                 86
2231156 2231156 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   grade_5 91 1 1 0   0     0   6   56 43                       99.0 91 1 1 0   0     0   6   56 43                 99
2231157 2231157 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth: Joseph Demello   Regular School No Elementary 01 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231185 2231185 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham: Avery   Regular School No Elementary 01 05 2018   grade_1 32 9 21 1   0     0   8   31 40                       71.0 32 9 21 1   0     0   8   31 40                 71
2231186 2231186 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham: Avery   Regular School No Elementary 01 05 2018   grade_2 24 6 13 0   1     0   4   21 27                       48.0 24 6 13 0   1     0   4   21 27                 48
2231187 2231187 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham: Avery   Regular School No Elementary 01 05 2018   grade_3 31 6 14 1   3     0   2   27 30                       57.0 31 6 14 1   3     0   2   27 30                 57
2231188 2231188 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham: Avery   Regular School No Elementary 01 05 2018   grade_4 42 5 16 0   3     0   5   37 34                       71.0 42 5 16 0   3     0   5   37 34                 71
2231189 2231189 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham: Avery   Regular School No Elementary 01 05 2018   grade_5 41 5 20 1   2     0   5   39 35                       74.0 41 5 20 1   2     0   5   39 35                 74
2231190 2231190 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham: Avery   Regular School No Elementary 01 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231191 2231191 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   grade_1 38 1 4 0   1     0   1   31 14                       45.0 38 1 4 0   1     0   1   31 14                 45
2231192 2231192 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   grade_2 30 3 3 0   1     0   0   19 18                       37.0 30 3 3 0   1     0   0   19 18                 37
2231193 2231193 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   grade_3 48 1 0 0   0     0   3   28 24                       52.0 48 1 0 0   0     0   3   28 24                 52
2231194 2231194 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   grade_4 55 3 6 0   1     0   1   36 30                       66.0 55 3 6 0   1     0   1   36 30                 66
2231195 2231195 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   grade_5 52 2 6 0   2     0   4   34 32                       66.0 52 2 6 0   2     0   4   34 32                 66
2231196 2231196 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231197 2231197 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham: Oakdale   Regular School No Elementary 01 05 2018   grade_1 41 2 8 0   2     0   2   33 22                       55.0 41 2 8 0   2     0   2   33 22                 55
2231198 2231198 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham: Oakdale   Regular School No Elementary 01 05 2018   grade_2 37 4 6 0   1     0   7   21 34                       55.0 37 4 6 0   1     0   7   21 34                 55
2231199 2231199 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham: Oakdale   Regular School No Elementary 01 05 2018   grade_3 40 6 5 0   2     0   5   29 29                       58.0 40 6 5 0   2     0   5   29 29                 58
2231200 2231200 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham: Oakdale   Regular School No Elementary 01 05 2018   grade_4 42 1 4 0   0     0   1   32 16                       48.0 42 1 4 0   0     0   1   32 16                 48
2231201 2231201 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham: Oakdale   Regular School No Elementary 01 05 2018   grade_5 49 6 8 0   1     0   5   27 42                       69.0 49 6 8 0   1     0   5   27 42                 69
2231202 2231202 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham: Oakdale   Regular School No Elementary 01 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231203 2231203 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_1 20 1 7 0   0     0   2   14 16                       30.0 20 1 7 0   0     0   2   14 16                 30
2231204 2231204 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_2 26 3 3 0   1     0   1   18 16                       34.0 26 3 3 0   1     0   1   18 16                 34
2231205 2231205 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_3 21 2 9 0   1     0   0   16 17                       33.0 21 2 9 0   1     0   0   16 17                 33
2231206 2231206 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_4 29 2 1 0   0     0   4   18 18                       36.0 29 2 1 0   0     0   4   18 18                 36
2231207 2231207 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   grade_5 35 2 8 0   0     0   1   31 15                       46.0 35 2 8 0   0     0   1   31 15                 46
2231208 2231208 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham: Riverdale   Regular School No Elementary 01 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231473 2231473 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_3 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231474 2231474 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_4 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2231475 2231475 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_6 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231476 2231476 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_7 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2231477 2231477 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_8 5 0 2 0   0     0   0   3 4                       7.0 5 0 2 0   0     0   0   3 4                 7

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