enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,465 ✖
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
2048106 2048106 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Elementary School   Regular School No Elementary PK 03 2019   grade_3 68 1 1 0   1     0   5   29 47                       76.0 68 1 1 0   1     0   5   29 47                 76
2048107 2048107 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_4 90 6 4 0   1     1   4   55 51                       106.0 90 6 4 0   1     1   4   55 51                 106
2048108 2048108 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_5 97 3 5 0   0     0   3   55 53                       108.0 97 3 5 0   0     0   3   55 53                 108
2048109 2048109 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_6 85 6 6 0   0     0   0   51 46                       97.0 85 6 6 0   0     0   0   51 46                 97
2048110 2048110 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_7 87 2 0 1   0     0   1   44 47                       91.0 87 2 0 1   0     0   1   44 47                 91
2048111 2048111 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   grade_8 85 2 1 0   0     0   1   49 40                       89.0 85 2 1 0   0     0   1   49 40                 89
2048112 2048112 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   grade_9 71 6 2 0   0     0   2   46 35                       81.0 71 6 2 0   0     0   2   46 35                 81
2048113 2048113 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   grade_10 44 3 0 0   3     0   0   27 23                       50.0 44 3 0 0   3     0   0   27 23                 50
2048114 2048114 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   grade_11 66 5 3 0   0     0   0   36 38                       74.0 66 5 3 0   0     0   0   36 38                 74
2048115 2048115 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   grade_12 76 3 4 1   3     0   0   42 45                       87.0 76 3 4 1   3     0   0   42 45                 87
2048116 2048116 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2047633 2047633 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_6 75 2 6 1   13     0   9   53 53                       106.0 75 2 6 1   13     0   9   53 53                 106
2047634 2047634 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_7 102 0 9 0   21     0   12   78 66                       144.0 102 0 9 0   21     0   12   78 66                 144
2047635 2047635 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_8 109 4 13 0   18     0   14   89 69                       158.0 109 4 13 0   18     0   14   89 69                 158
2047636 2047636 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_9 102 2 12 0   31     0   9   75 81                       156.0 102 2 12 0   31     0   9   75 81                 156
2047637 2047637 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_10 95 1 10 0   43     0   5   80 74                       154.0 95 1 10 0   43     0   5   80 74                 154
2047638 2047638 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_11 94 5 3 1   23     0   11   81 56                       137.0 94 5 3 1   23     0   11   81 56                 137
2047639 2047639 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_12 82 4 3 1   20     0   9   50 69                       119.0 82 4 3 1   20     0   9   50 69                 119
2039835 2039835 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 131 3 12 0   13     0   3   79 83                       162.0 131 3 12 0   13     0   3   79 83                 162
2039836 2039836 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   kindergarten 27 1 8 0   3     0   0   22 17                       39.0 27 1 8 0   3     0   0   22 17                 39
2039837 2039837 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_1 28 1 7 0   3     0   0   17 22                       39.0 28 1 7 0   3     0   0   17 22                 39
2039838 2039838 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_2 60 2 3 0   0     1   1   30 37                       67.0 60 2 3 0   0     1   1   30 37                 67
2039839 2039839 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_3 36 1 9 0   0     0   2   23 25                       48.0 36 1 9 0   0     0   2   23 25                 48
2039840 2039840 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_4 52 0 11 0   1     0   1   38 27                       65.0 52 0 11 0   1     0   1   38 27                 65
2039841 2039841 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   kindergarten 52 0 3 0   2     0   1   36 22                       58.0 52 0 3 0   2     0   1   36 22                 58
2039842 2039842 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_1 57 1 4 0   2     0   6   42 28                       70.0 57 1 4 0   2     0   6   42 28                 70
2039843 2039843 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_2 77 1 5 0   1     0   1   38 47                       85.0 77 1 5 0   1     0   1   38 47                 85
2039844 2039844 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_3 56 0 2 0   2     0   0   35 25                       60.0 56 0 2 0   2     0   0   35 25                 60
2039845 2039845 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_4 66 4 2 0   1     0   2   51 24                       75.0 66 4 2 0   1     0   2   51 24                 75
2039846 2039846 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   kindergarten 60 2 8 0   3     0   4   37 40                       77.0 60 2 8 0   3     0   4   37 40                 77
2039847 2039847 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_1 53 4 9 0   3     0   2   37 34                       71.0 53 4 9 0   3     0   2   37 34                 71
2039848 2039848 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_2 64 3 7 0   1     0   3   38 40                       78.0 64 3 7 0   1     0   3   38 40                 78
2039849 2039849 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_3 66 1 6 0   3     0   2   38 40                       78.0 66 1 6 0   3     0   2   38 40                 78
2039850 2039850 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_4 44 2 7 0   5     0   3   33 28                       61.0 44 2 7 0   5     0   3   33 28                 61
2039851 2039851 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   kindergarten 56 0 4 0   4     0   2   33 33                       66.0 56 0 4 0   4     0   2   33 33                 66
2039852 2039852 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_1 46 2 8 0   2     0   2   30 30                       60.0 46 2 8 0   2     0   2   30 30                 60
2039853 2039853 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_2 51 2 6 0   2     0   2   37 26                       63.0 51 2 6 0   2     0   2   37 26                 63
2039854 2039854 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_3 56 1 7 0   1     0   3   35 33                       68.0 56 1 7 0   1     0   3   35 33                 68
2039855 2039855 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2019   grade_4 46 5 5 0   3     0   0   34 25                       59.0 46 5 5 0   3     0   0   34 25                 59
2039856 2039856 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 07 2019   grade_5 252 3 35 0   13     0   13   145 171                       316.0 252 3 35 0   13     0   13   145 171                 316
2039857 2039857 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 07 2019   grade_6 235 12 16 0   4     0   8   140 135                       275.0 235 12 16 0   4     0   8   140 135                 275
2039858 2039858 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2019   grade_7 241 10 18 0   13     0   9   165 126                       291.0 241 10 18 0   13     0   9   165 126                 291
2039859 2039859 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2019   grade_8 251 4 25 0   13     0   7   153 147                       300.0 251 4 25 0   13     0   7   153 147                 300
2039860 2039860 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_9 219 7 21 1   6     0   11   136 129                       265.0 219 7 21 1   6     0   11   136 129                 265
2039861 2039861 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_10 259 4 20 0   1     0   8   139 153                       292.0 259 4 20 0   1     0   8   139 153                 292
2039862 2039862 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_11 246 3 12 0   7     0   2   133 137                       270.0 246 3 12 0   7     0   2   133 137                 270
2039863 2039863 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_12 243 4 18 0   8     0   4   145 132                       277.0 243 4 18 0   8     0   4   145 132                 277
2039864 2039864 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   sped_beyond_grade_12 9 0 0 0   0     0   0                             9.0 9 0 0 0   0     0   0                       9
2047516 2047516 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   kindergarten 15 6 32 0   0     0   0   23 30                       53.0 15 6 32 0   0     0   0   23 30                 53
2047517 2047517 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_1 9 9 33 1   0     0   0   25 27                       52.0 9 9 33 1   0     0   0   25 27                 52
2047518 2047518 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_2 8 8 32 1   0     0   0   21 28                       49.0 8 8 32 1   0     0   0   21 28                 49
2047519 2047519 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_3 15 7 27 1   0     0   0   22 28                       50.0 15 7 27 1   0     0   0   22 28                 50
2047520 2047520 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_4 9 7 34 0   0     0   0   25 25                       50.0 9 7 34 0   0     0   0   25 25                 50
2047521 2047521 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_5 16 7 27 0   0     0   0   17 33                       50.0 16 7 27 0   0     0   0   17 33                 50
2047522 2047522 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_6 8 10 31 0   0     0   0   21 28                       49.0 8 10 31 0   0     0   0   21 28                 49
2047523 2047523 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_7 17 7 24 0   0     0   0   24 24                       48.0 17 7 24 0   0     0   0   24 24                 48
2047524 2047524 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_8 10 9 20 0   0     0   1   18 22                       40.0 10 9 20 0   0     0   1   18 22                 40
2039865 2039865 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 27 0 1 0   0     0   0   16 12                       28.0 27 0 1 0   0     0   0   16 12                 28
2039866 2039866 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   kindergarten 47 0 3 0   0     1   2   25 28                       53.0 47 0 3 0   0     1   2   25 28                 53
2039867 2039867 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_1 59 0 7 0   0     0   5   42 29                       71.0 59 0 7 0   0     0   5   42 29                 71
2039868 2039868 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_2 53 2 5 0   1     0   3   39 25                       64.0 53 2 5 0   1     0   3   39 25                 64
2039869 2039869 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_3 61 2 2 1   0     0   4   30 40                       70.0 61 2 2 1   0     0   4   30 40                 70
2039870 2039870 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_4 71 1 7 0   2     0   7   48 40                       88.0 71 1 7 0   2     0   7   48 40                 88
2039871 2039871 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 23 0 2 0   0     0   1   11 15                       26.0 23 0 2 0   0     0   1   11 15                 26
2039872 2039872 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   kindergarten 54 0 5 0   1     0   3   38 25                       63.0 54 0 5 0   1     0   3   38 25                 63
2039873 2039873 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_1 62 2 8 0   1     0   2   38 37                       75.0 62 2 8 0   1     0   2   38 37                 75
2039874 2039874 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_2 59 4 8 0   1     0   2   37 37                       74.0 59 4 8 0   1     0   2   37 37                 74
2039875 2039875 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_3 82 2 10 0   2     0   1   59 38                       97.0 82 2 10 0   2     0   1   59 38                 97
2039876 2039876 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_4 78 1 6 1   2     0   1   49 40                       89.0 78 1 6 1   2     0   1   49 40                 89
2039877 2039877 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_5 133 4 15 0   2     0   8   94 68                       162.0 133 4 15 0   2     0   8   94 68                 162
2039878 2039878 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_6 132 3 9 0   2     1   4   71 80                       151.0 132 3 9 0   2     1   4   71 80                 151
2039879 2039879 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_7 138 5 18 0   0     1   4   79 87                       166.0 138 5 18 0   0     1   4   79 87                 166
2039880 2039880 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_8 141 1 14 0   1     0   8   83 82                       165.0 141 1 14 0   1     0   8   83 82                 165
2039881 2039881 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_9 119 2 6 0   2     0   5   68 66                       134.0 119 2 6 0   2     0   5   68 66                 134
2039882 2039882 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_10 118 4 12 0   2     0   9   75 70                       145.0 118 4 12 0   2     0   9   75 70                 145
2039883 2039883 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_11 132 0 7 0   2     0   2   71 72                       143.0 132 0 7 0   2     0   2   71 72                 143
2039884 2039884 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_12 114 3 11 0   3     0   7   76 62                       138.0 114 3 11 0   3     0   7   76 62                 138
2039885 2039885 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2039886 2039886 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_9 9 0 2 0   0     0   1   8 4                       12.0 9 0 2 0   0     0   1   8 4                 12
2039887 2039887 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_10 9 0 0 0   0     0   1   7 3                       10.0 9 0 0 0   0     0   1   7 3                 10
2039888 2039888 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_11 10 1 2 0   0     0   1   6 8                       14.0 10 1 2 0   0     0   1   6 8                 14
2039889 2039889 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_12 13 1 1 0   0     0   0   11 4                       15.0 13 1 1 0   0     0   0   11 4                 15
2039890 2039890 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 18 7 9 0   11     0   3   29 19                       48.0 18 7 9 0   11     0   3   29 19                 48
2039891 2039891 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   kindergarten 32 3 15 0   6     0   7   32 31                       63.0 32 3 15 0   6     0   7   32 31                 63
2039892 2039892 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_1 18 4 8 2   3     0   5   21 18                       40.0 18 4 8 2   3     0   5   21 18                 40
2039893 2039893 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_2 19 3 9 0   5     0   7   23 20                       43.0 19 3 9 0   5     0   7   23 20                 43
2039894 2039894 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_3 25 7 12 0   9     0   0   29 24                       53.0 25 7 12 0   9     0   0   29 24                 53
2039895 2039895 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_4 22 4 17 0   7     0   3   28 25                       53.0 22 4 17 0   7     0   3   28 25                 53
2039896 2039896 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_5 26 3 21 0   6     0   6   36 26                       62.0 26 3 21 0   6     0   6   36 26                 62
2039897 2039897 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_6 13 6 7 0   4     0   2   17 15                       32.0 13 6 7 0   4     0   2   17 15                 32
2039898 2039898 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   kindergarten 20 1 7 0   5     0   5   25 13                       38.0 20 1 7 0   5     0   5   25 13                 38
2039899 2039899 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_1 14 2 9 0   5     0   3   12 21                       33.0 14 2 9 0   5     0   3   12 21                 33
2039900 2039900 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_2 19 6 11 0   8     0   3   19 28                       47.0 19 6 11 0   8     0   3   19 28                 47
2039901 2039901 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_3 20 4 7 0   9     0   1   20 21                       41.0 20 4 7 0   9     0   1   20 21                 41
2039902 2039902 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_4 20 1 10 0   8     0   3   21 21                       42.0 20 1 10 0   8     0   3   21 21                 42
2039903 2039903 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_5 25 6 10 0   4     0   2   18 29                       47.0 25 6 10 0   4     0   2   18 29                 47
2039904 2039904 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_6 35 3 14 0   9     0   6   43 24                       67.0 35 3 14 0   9     0   6   43 24                 67
2039905 2039905 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   kindergarten 23 8 14 1   8     0   5   29 30                       59.0 23 8 14 1   8     0   5   29 30                 59
2039906 2039906 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_1 30 5 10 0   10     0   5   28 32                       60.0 30 5 10 0   10     0   5   28 32                 60
2039907 2039907 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_2 27 6 11 0   8     0   1   24 29                       53.0 27 6 11 0   8     0   1   24 29                 53

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