enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by non_binary_int

✎ View and edit SQL

This data as json, CSV (advanced)

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
1364784 1364784 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 68 9 7 0   4     0   0   43 45 *                     88.0 68 9 7 0   4     0   0   43 45                 88
1364785 1364785 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_3 135 6 21 0   2     1   0   81 84 *                     165.0 135 6 21 0   2     1   0   81 84                 165
1364786 1364786 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_4 110 7 11 0   5     0   3   61 75 *                     136.0 110 7 11 0   5     0   3   61 75                 136
1364787 1364787 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   kindergarten 131 9 22 1   4     0   2   82 86 *                     169.0 131 9 22 1   4     0   2   82 86                 169
1364788 1364788 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_1 130 9 9 3   5     0   1   80 77 *                     157.0 130 9 9 3   5     0   1   80 77                 157
1364789 1364789 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_2 119 10 10 2   3     0   1   68 77 *                     145.0 119 10 10 2   3     0   1   68 77                 145
1364790 1364790 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_5 138 5 16 0   5     0   3   96 71 *                     167.0 138 5 16 0   5     0   3   96 71                 167
1364791 1364791 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_6 137 6 20 2   4     0   3   92 80 *                     172.0 137 6 20 2   4     0   3   92 80                 172
1364792 1364792 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_7 139 3 12 1   4     0   5   86 78 *                     164.0 139 3 12 1   4     0   5   86 78                 164
1364793 1364793 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_8 164 6 14 0   3     0   0   106 81 *                     187.0 164 6 14 0   3     0   0   106 81                 187
1364794 1364794 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_9 125 7 20 0   6     0   2   75 85 *                     160.0 125 7 20 0   6     0   2   75 85                 160
1364795 1364795 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_10 127 10 12 0   4     0   3   80 76 *                     156.0 127 10 12 0   4     0   3   80 76                 156
1364796 1364796 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_11 127 8 15 0   3     0   1   80 74 *                     154.0 127 8 15 0   3     0   1   80 74                 154
1364797 1364797 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_12 102 3 6 0   4     0   2   55 62 *                     117.0 102 3 6 0   4     0   2   55 62                 117
1364798 1364798 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   sped_beyond_grade_12 5 0 1 0   0     0   0   3 3 *                     6.0 5 0 1 0   0     0   0   3 3                 6
1364799 1364799 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   kindergarten 79 1 5 0   1     0   3   51 38 *                     89.0 79 1 5 0   1     0   3   51 38                 89
1364800 1364800 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten 39 1 4 0   0     0   2   28 18 *                     46.0 39 1 4 0   0     0   2   28 18                 46
1364801 1364801 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_1 118 1 2 0   2     0   4   62 65 *                     127.0 118 1 2 0   2     0   4   62 65                 127
1364802 1364802 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_2 96 4 5 0   1     0   3   56 53 *                     109.0 96 4 5 0   1     0   3   56 53                 109
1364803 1364803 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_3 74 1 4 1   0     0   5   44 41 *                     85.0 74 1 4 1   0     0   5   44 41                 85
1364804 1364804 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_4 99 0 4 0   1     0   7   56 55 *                     111.0 99 0 4 0   1     0   7   56 55                 111
1364805 1364805 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_5 97 0 8 0   1     0   4   49 61 *                     110.0 97 0 8 0   1     0   4   49 61                 110
1364806 1364806 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_6 97 1 2 0   1     0   0   57 44 *                     101.0 97 1 2 0   1     0   0   57 44                 101
1364807 1364807 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_7 99 0 6 0   1     0   6   62 50 *                     112.0 99 0 6 0   1     0   6   62 50                 112
1364808 1364808 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_8 112 2 2 0   1     0   3   62 58 *                     120.0 112 2 2 0   1     0   3   62 58                 120
1364809 1364809 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 114 6 18 0   15     0   7   93 67 *                     160.0 114 6 18 0   15     0   7   93 67                 160
1364810 1364810 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   kindergarten 45 1 7 0   4     0   1   24 34 *                     58.0 45 1 7 0   4     0   1   24 34                 58
1364811 1364811 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_1 26 1 9 0   5     0   0   23 18 *                     41.0 26 1 9 0   5     0   0   23 18                 41
1364812 1364812 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_2 28 1 6 0   3     0   0   20 18 *                     38.0 28 1 6 0   3     0   0   20 18                 38
1364813 1364813 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_3 62 2 4 0   0     1   1   32 38 *                     70.0 62 2 4 0   0     1   1   32 38                 70
1364814 1364814 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_4 35 1 11 0   0     0   2   24 25 *                     49.0 35 1 11 0   0     0   2   24 25                 49
1364815 1364815 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   kindergarten 57 1 5 0   3     0   1   36 31 *                     67.0 57 1 5 0   3     0   1   36 31                 67
1364816 1364816 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   grade_1 59 0 2 0   2     0   0   38 25 *                     63.0 59 0 2 0   2     0   0   38 25                 63
1364817 1364817 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   grade_2 56 0 6 0   2     0   5   39 30 *                     69.0 56 0 6 0   2     0   5   39 30                 69
1364818 1364818 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   grade_3 75 1 5 0   1     0   1   36 47 *                     83.0 75 1 5 0   1     0   1   36 47                 83
1364819 1364819 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2020   grade_4 57 0 1 0   2     0   0   34 26 *                     60.0 57 0 1 0   2     0   0   34 26                 60
1364820 1364820 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2020   kindergarten 58 1 12 0   2     0   8   39 42 *                     81.0 58 1 12 0   2     0   8   39 42                 81
1364821 1364821 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2020   grade_1 67 2 9 0   3     0   4   43 42 *                     85.0 67 2 9 0   3     0   4   43 42                 85
1364822 1364822 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2020   grade_2 53 3 8 0   3     0   1   33 35 *                     68.0 53 3 8 0   3     0   1   33 35                 68
1364823 1364823 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2020   grade_3 65 3 5 0   2     0   2   37 40 *                     77.0 65 3 5 0   2     0   2   37 40                 77
1364824 1364824 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2020   grade_4 69 1 6 0   3     0   1   39 41 *                     80.0 69 1 6 0   3     0   1   39 41                 80
1364825 1364825 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2020   kindergarten 42 0 6 0   6     0   3   28 29 *                     57.0 42 0 6 0   6     0   3   28 29                 57
1364826 1364826 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2020   grade_1 54 0 3 0   2     0   2   34 27 *                     61.0 54 0 3 0   2     0   2   34 27                 61
1364827 1364827 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2020   grade_2 47 2 6 0   2     0   2   28 31 *                     59.0 47 2 6 0   2     0   2   28 31                 59
1364828 1364828 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2020   grade_3 47 2 5 0   1     0   3   36 22 *                     58.0 47 2 5 0   1     0   3   36 22                 58
1364829 1364829 MA Hampden   school 2501800 5   Agawam 250180000030 50030 James Clark School   Regular School No Elementary KG 04 2020   grade_4 55 1 6 0   1     0   3   33 33 *                     66.0 55 1 6 0   1     0   3   33 33                 66
1364830 1364830 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2020   grade_5 213 11 33 0   10     0   7   164 110 *                     274.0 213 11 33 0   10     0   7   164 110                 274
1364831 1364831 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2020   grade_6 250 3 35 0   11     0   13   144 168 *                     312.0 250 3 35 0   11     0   13   144 168                 312
1364832 1364832 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2020   grade_7 231 11 18 0   4     0   6   133 137 *                     270.0 231 11 18 0   4     0   6   133 137                 270
1364833 1364833 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2020   grade_8 236 10 20 0   12     0   9   157 130 *                     287.0 236 10 20 0   12     0   9   157 130                 287
1364834 1364834 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2020   grade_9 247 4 28 0   10     0   8   160 137 *                     297.0 247 4 28 0   10     0   8   160 137                 297
1364835 1364835 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2020   grade_10 197 6 15 1   5     0   10   112 121 *                     234.0 197 6 15 1   5     0   10   112 121                 234
1364836 1364836 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2020   grade_11 242 4 21 0   3     0   8   131 147 *                     278.0 242 4 21 0   3     0   8   131 147                 278
1364837 1364837 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2020   grade_12 238 3 14 0   8     0   2   135 130 *                     265.0 238 3 14 0   8     0   2   135 130                 265
1364838 1364838 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   kindergarten 60 1 1 0   0     0   1   33 30 *                     63.0 60 1 1 0   0     0   1   33 30                 63
1364839 1364839 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 32 0 1 0   0     0   0   18 15 *                     33.0 32 0 1 0   0     0   0   18 15                 33
1364840 1364840 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_1 48 1 0 0   0     0   2   24 27 *                     51.0 48 1 0 0   0     0   2   24 27                 51
1364841 1364841 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_2 58 0 9 0   0     0   4   42 29 *                     71.0 58 0 9 0   0     0   4   42 29                 71
1364842 1364842 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_3 51 2 5 0   1     0   3   43 19 *                     62.0 51 2 5 0   1     0   3   43 19                 62
1364843 1364843 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2020   grade_4 59 1 2 1   0     0   3   29 37 *                     66.0 59 1 2 1   0     0   3   29 37                 66
1364844 1364844 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   kindergarten 52 2 15 0   0     0   2   32 39 *                     71.0 52 2 15 0   0     0   2   32 39                 71
1364845 1364845 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 23 0 3 0   0     0   0   16 10 *                     26.0 23 0 3 0   0     0   0   16 10                 26
1364846 1364846 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_1 52 0 7 0   1     1   3   36 28 *                     64.0 52 0 7 0   1     1   3   36 28                 64
1364847 1364847 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_2 61 2 10 0   1     0   2   41 35 *                     76.0 61 2 10 0   1     0   2   41 35                 76
1364848 1364848 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_3 64 4 11 0   1     0   2   41 41 *                     82.0 64 4 11 0   1     0   2   41 41                 82
1364849 1364849 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_4 78 2 12 0   2     0   3   57 40 *                     97.0 78 2 12 0   2     0   3   57 40                 97
1364850 1364850 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_5 150 1 16 1   5     0   8   96 85 *                     181.0 150 1 16 1   5     0   8   96 85                 181
1364851 1364851 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_6 128 4 18 0   2     0   10   96 66 *                     162.0 128 4 18 0   2     0   10   96 66                 162
1364852 1364852 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_7 132 3 11 0   4     1   5   69 87 *                     156.0 132 3 11 0   4     1   5   69 87                 156
1364853 1364853 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_8 137 6 21 0   0     1   4   85 84 *                     169.0 137 6 21 0   0     1   4   85 84                 169
1364854 1364854 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   grade_9 101 2 8 0   0     0   7   63 55 *                     118.0 101 2 8 0   0     0   7   63 55                 118
1364855 1364855 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   grade_10 108 2 7 0   2     0   5   61 63 *                     124.0 108 2 7 0   2     0   5   61 63                 124
1364856 1364856 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   grade_11 116 4 10 0   3     0   6   70 69 *                     139.0 116 4 10 0   3     0   6   70 69                 139
1364857 1364857 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   grade_12 132 0 6 0   2     0   2   71 71 *                     142.0 132 0 6 0   2     0   2   71 71                 142
1364858 1364858 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   sped_beyond_grade_12 6 0 0 0   0     0   0   4 2 *                     6.0 6 0 0 0   0     0   0   4 2                 6
1364859 1364859 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_9 7 0 1 0   0     0   0   4 4 *                     8.0 7 0 1 0   0     0   0   4 4                 8
1364860 1364860 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_10 11 0 1 0   0     0   1   10 3 *                     13.0 11 0 1 0   0     0   1   10 3                 13
1364861 1364861 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_11 10 0 1 0   0     0   2   8 4 *                     13.0 10 0 1 0   0     0   2   8 4                 13
1364862 1364862 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_12 15 2 1 0   0     0   1   8 11 *                     19.0 15 2 1 0   0     0   1   8 11                 19
1364863 1364863 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   kindergarten 20 4 3 0   4     0   1   14 17 *                     32.0 20 4 3 0   4     0   1   14 17                 32
1364864 1364864 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 26 4 15 0   5     0   3   37 15 *                     53.0 26 4 15 0   5     0   3   37 15                 53
1364865 1364865 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_1 28 4 13 0   4     0   6   25 30 *                     55.0 28 4 13 0   4     0   6   25 30                 55
1364866 1364866 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_2 20 3 9 2   4     0   6   24 19 *                     44.0 20 3 9 2   4     0   6   24 19                 44
1364867 1364867 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_3 22 5 6 0   5     0   7   25 20 *                     45.0 22 5 6 0   5     0   7   25 20                 45
1364868 1364868 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_4 27 7 11 0   10     0   1   30 26 *                     56.0 27 7 11 0   10     0   1   30 26                 56
1364869 1364869 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_5 26 2 16 0   7     0   3   28 26 *                     54.0 26 2 16 0   7     0   3   28 26                 54
1364870 1364870 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_6 29 3 20 0   6     0   3   34 27 *                     61.0 29 3 20 0   6     0   3   34 27                 61
1364871 1364871 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   kindergarten 22 2 18 0   2     0   5   25 24 *                     49.0 22 2 18 0   2     0   5   25 24                 49
1364872 1364872 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_1 21 2 9 0   4     0   5   27 14 *                     41.0 21 2 9 0   4     0   5   27 14                 41
1364873 1364873 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_2 13 2 8 0   5     0   3   14 17 *                     31.0 13 2 8 0   5     0   3   14 17                 31
1364874 1364874 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_3 22 7 15 0   8     0   3   24 31 *                     55.0 22 7 15 0   8     0   3   24 31                 55
1364875 1364875 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_4 22 3 7 0   10     1   0   19 24 *                     43.0 22 3 7 0   10     1   0   19 24                 43
1364876 1364876 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_5 21 2 10 0   7     0   2   21 21 *                     42.0 21 2 10 0   7     0   2   21 21                 42
1364877 1364877 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_6 26 6 11 0   5     0   2   18 32 *                     50.0 26 6 11 0   5     0   2   18 32                 50
1364878 1364878 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   kindergarten 23 6 4 1   10     0   3   23 24 *                     47.0 23 6 4 1   10     0   3   23 24                 47
1364879 1364879 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_1 23 8 11 0   5     0   5   24 28 *                     52.0 23 8 11 0   5     0   5   24 28                 52
1364880 1364880 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_2 30 9 11 0   11     0   3   30 34 *                     64.0 30 9 11 0   11     0   3   30 34                 64
1364881 1364881 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_3 29 4 9 0   7     0   1   24 26 *                     50.0 29 4 9 0   7     0   1   24 26                 50
1364882 1364882 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_4 31 10 12 0   7     0   2   29 33 *                     62.0 31 10 12 0   7     0   2   29 33                 62
1364883 1364883 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_5 27 4 9 0   5     0   5   33 17 *                     50.0 27 4 9 0   5     0   5   33 17                 50

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