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
1364984 1364984 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2020   grade_3 147 3 34 0   34     0   11   111 118 *                     229.0 147 3 34 0   34     0   11   111 118                 229
1364985 1364985 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2020   grade_4 131 5 28 0   32     0   7   100 103 *                     203.0 131 5 28 0   32     0   7   100 103                 203
1364986 1364986 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2020   grade_5 156 7 26 4   30     0   4   113 114 *                     227.0 156 7 26 4   30     0   4   113 114                 227
1364987 1364987 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_6 150 4 32 4   30     0   9   118 111 *                     229.0 150 4 32 4   30     0   9   118 111                 229
1364988 1364988 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_7 147 7 28 0   29     0   8   111 108 *                     219.0 147 7 28 0   29     0   8   111 108                 219
1364989 1364989 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_8 140 4 27 2   30     0   7   104 106 *                     210.0 140 4 27 2   30     0   7   104 106                 210
1364990 1364990 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2020   grade_9 121 4 22 2   29     0   2   89 91 *                     180.0 121 4 22 2   29     0   2   89 91                 180
1364991 1364991 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2020   grade_10 152 8 22 1   28     0   7   101 117 *                     218.0 152 8 22 1   28     0   7   101 117                 218
1364992 1364992 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2020   grade_11 148 6 28 0   21     0   9   103 108 *                     212.0 148 6 28 0   21     0   9   103 108                 212
1364993 1364993 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2020   grade_12 146 7 28 1   31     0   2   100 115 *                     215.0 146 7 28 1   31     0   2   100 115                 215
1364994 1364994 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   kindergarten 55 7 11 1   1     0   2   35 42 *                     77.0 55 7 11 1   1     0   2   35 42                 77
1364995 1364995 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_1 48 4 13 0   2     0   3   31 39 *                     70.0 48 4 13 0   2     0   3   31 39                 70
1364996 1364996 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 5 7 0   1     0   1   35 36 *                     71.0 57 5 7 0   1     0   1   35 36                 71
1364997 1364997 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_3 49 5 13 0   1     0   5   35 38 *                     73.0 49 5 13 0   1     0   5   35 38                 73
1364998 1364998 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   grade_4 57 5 12 1   4     1   8   53 35 *                     88.0 57 5 12 1   4     1   8   53 35                 88
1364999 1364999 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 132 8 31 0   8     0   5   105 79 *                     184.0 132 8 31 0   8     0   5   105 79                 184
1365000 1365000 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2020   kindergarten 51 1 14 0   3     0   6   37 38 *                     75.0 51 1 14 0   3     0   6   37 38                 75
1365001 1365001 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2020   grade_1 55 5 12 0   1     0   4   40 37 *                     77.0 55 5 12 0   1     0   4   40 37                 77
1365002 1365002 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2020   grade_2 42 6 8 0   4     0   8   41 27 *                     68.0 42 6 8 0   4     0   8   41 27                 68
1365003 1365003 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2020   grade_3 44 4 19 0   2     0   7   37 39 *                     76.0 44 4 19 0   2     0   7   37 39                 76
1365004 1365004 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2020   grade_4 63 8 15 0   2     0   6   51 43 *                     94.0 63 8 15 0   2     0   6   51 43                 94
1365005 1365005 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   kindergarten 68 6 12 0   1     0   6   39 54 *                     93.0 68 6 12 0   1     0   6   39 54                 93
1365006 1365006 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   grade_1 54 3 22 0   0     0   8   45 42 *                     87.0 54 3 22 0   0     0   8   45 42                 87
1365007 1365007 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 3 21 0   4     0   7   44 48 *                     92.0 57 3 21 0   4     0   7   44 48                 92
1365008 1365008 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   grade_3 57 4 16 0   4     0   8   44 45 *                     89.0 57 4 16 0   4     0   8   44 45                 89
1365009 1365009 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   grade_4 66 4 18 0   6     0   6   54 46 *                     100.0 66 4 18 0   6     0   6   54 46                 100
1365010 1365010 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   kindergarten 63 9 11 0   6     0   6   46 49 *                     95.0 63 9 11 0   6     0   6   46 49                 95
1365011 1365011 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   grade_1 59 4 11 0   7     0   7   43 45 *                     88.0 59 4 11 0   7     0   7   43 45                 88
1365012 1365012 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 2 11 1   3     0   4   35 43 *                     78.0 57 2 11 1   3     0   4   35 43                 78
1365013 1365013 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   grade_3 55 13 14 0   4     0   10   57 39 *                     96.0 55 13 14 0   4     0   10   57 39                 96
1365014 1365014 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   grade_4 68 6 10 0   7     0   8   55 44 *                     99.0 68 6 10 0   7     0   8   55 44                 99
1365015 1365015 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   kindergarten 59 8 17 0   4     1   4   50 43 *                     93.0 59 8 17 0   4     1   4   50 43                 93
1365016 1365016 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_1 58 10 8 0   4     0   6   54 32 *                     86.0 58 10 8 0   4     0   6   54 32                 86
1365017 1365017 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 14 9 1   10     0   7   51 47 *                     98.0 57 14 9 1   10     0   7   51 47                 98
1365018 1365018 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_3 53 9 12 0   5     0   11   39 51 *                     90.0 53 9 12 0   5     0   11   39 51                 90
1365019 1365019 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_4 41 9 11 0   8     0   14   40 43 *                     83.0 41 9 11 0   8     0   14   40 43                 83
1365020 1365020 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_5 101 9 15 0   9     0   7   82 59 *                     141.0 101 9 15 0   9     0   7   82 59                 141
1365021 1365021 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_6 111 16 9 2   10     0   14   82 80 *                     162.0 111 16 9 2   10     0   14   82 80                 162
1365022 1365022 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_7 124 12 23 0   5     0   11   97 78 *                     175.0 124 12 23 0   5     0   11   97 78                 175
1365023 1365023 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_8 124 8 23 0   10     0   12   91 86 *                     177.0 124 8 23 0   10     0   12   91 86                 177
1365024 1365024 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_5 105 13 33 0   3     0   13   86 81 *                     167.0 105 13 33 0   3     0   13   86 81                 167
1365025 1365025 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_6 94 2 20 0   10     0   15   69 72 *                     141.0 94 2 20 0   10     0   15   69 72                 141
1365026 1365026 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_7 98 10 40 0   9     0   5   88 74 *                     162.0 98 10 40 0   9     0   5   88 74                 162
1365027 1365027 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_8 95 10 27 1   9     0   9   74 77 *                     151.0 95 10 27 1   9     0   9   74 77                 151
1365028 1365028 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_5 85 9 19 0   1     0   15   65 64 *                     129.0 85 9 19 0   1     0   15   65 64                 129
1365029 1365029 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_6 108 8 27 0   6     0   8   86 71 *                     157.0 108 8 27 0   6     0   8   86 71                 157
1365030 1365030 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_7 84 10 20 0   11     0   7   62 70 *                     132.0 84 10 20 0   11     0   7   62 70                 132
1365031 1365031 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_8 97 6 23 0   8     0   11   81 64 *                     145.0 97 6 23 0   8     0   11   81 64                 145
1365032 1365032 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   grade_9 310 28 79 1   16     0   20   259 194 *                     454.0 310 28 79 1   16     0   20   259 194                 454
1365033 1365033 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   grade_10 320 29 77 1   23     1   14   249 216 *                     465.0 320 29 77 1   23     1   14   249 216                 465
1365034 1365034 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   grade_11 290 31 64 0   27     2   25   225 214 *                     439.0 290 31 64 0   27     2   25   225 214                 439
1365035 1365035 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   grade_12 281 20 65 2   13     0   15   203 193 *                     396.0 281 20 65 2   13     0   15   203 193                 396
1365036 1365036 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   sped_beyond_grade_12 12 2 2 0   0     0   0   9 7 *                     16.0 12 2 2 0   0     0   0   9 7                 16
1365037 1365037 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2020   grade_11 12 2 3 1   1     0   1   16 4 *                     20.0 12 2 3 1   1     0   1   16 4                 20
1365038 1365038 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2020   grade_12 21 2 3 0   0     0   3   16 13 *                     29.0 21 2 3 0   0     0   3   16 13                 29
1365039 1365039 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2020   kindergarten 80 1 11 1   1     0   6   48 52 *                     100.0 80 1 11 1   1     0   6   48 52                 100
1365040 1365040 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2020   grade_1 70 1 10 0   6     0   3   53 37 *                     90.0 70 1 10 0   6     0   3   53 37                 90
1365041 1365041 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2020   grade_2 78 2 12 0   3     0   1   52 44 *                     96.0 78 2 12 0   3     0   1   52 44                 96
1365042 1365042 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   kindergarten 72 0 8 0   2     0   2   38 46 *                     84.0 72 0 8 0   2     0   2   38 46                 84
1365043 1365043 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   pre_kindergarten 40 0 4 0   2     0   2   28 20 *                     48.0 40 0 4 0   2     0   2   28 20                 48
1365044 1365044 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   grade_1 82 2 12 0   3     0   2   55 46 *                     101.0 82 2 12 0   3     0   2   55 46                 101
1365045 1365045 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   grade_2 62 0 5 0   4     0   4   36 39 *                     75.0 62 0 5 0   4     0   4   36 39                 75
1365046 1365046 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2020   grade_3 174 8 11 0   8     0   9   109 101 *                     210.0 174 8 11 0   8     0   9   109 101                 210
1365047 1365047 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2020   grade_4 162 6 25 0   4     0   6   107 96 *                     203.0 162 6 25 0   4     0   6   107 96                 203
1365048 1365048 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2020   grade_5 160 5 23 0   16     0   4   111 97 *                     208.0 160 5 23 0   16     0   4   111 97                 208
1365049 1365049 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_6 176 7 17 0   7     0   9   92 124 *                     216.0 176 7 17 0   7     0   9   92 124                 216
1365050 1365050 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_7 154 4 26 0   9     0   9   104 98 *                     202.0 154 4 26 0   9     0   9   104 98                 202
1365051 1365051 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_8 171 4 17 0   10     0   7   114 95 *                     209.0 171 4 17 0   10     0   7   114 95                 209
1365052 1365052 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   pre_kindergarten 52 1 3 0   1     0   2   27 32 *                     59.0 52 1 3 0   1     0   2   27 32                 59
1365053 1365053 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   grade_9 156 5 24 0   7     0   4   101 95 *                     196.0 156 5 24 0   7     0   4   101 95                 196
1365054 1365054 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   grade_10 146 4 15 0   6     0   8   79 100 *                     179.0 146 4 15 0   6     0   8   79 100                 179
1365055 1365055 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   grade_11 147 4 9 1   9     0   5   74 101 *                     175.0 147 4 9 1   9     0   5   74 101                 175
1365056 1365056 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   grade_12 141 3 20 1   10     0   8   91 92 *                     183.0 141 3 20 1   10     0   8   91 92                 183
1365057 1365057 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   kindergarten 32 7 4 0   2     0   3   22 26 *                     48.0 32 7 4 0   2     0   3   22 26                 48
1365058 1365058 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   pre_kindergarten 6 9 3 0   1     0   3   11 11 *                     22.0 6 9 3 0   1     0   3   11 11                 22
1365059 1365059 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_1 28 11 6 0   1     0   7   25 28 *                     53.0 28 11 6 0   1     0   7   25 28                 53
1365060 1365060 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_2 30 13 7 0   3     0   4   34 23 *                     57.0 30 13 7 0   3     0   4   34 23                 57
1365061 1365061 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_3 29 15 8 0   4     0   3   29 30 *                     59.0 29 15 8 0   4     0   3   29 30                 59
1365062 1365062 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_4 36 16 5 0   4     0   3   34 30 *                     64.0 36 16 5 0   4     0   3   34 30                 64
1365063 1365063 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_5 30 17 7 0   1     0   0   27 28 *                     55.0 30 17 7 0   1     0   0   27 28                 55
1365064 1365064 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_6 31 14 3 1   4     0   5   34 24 *                     58.0 31 14 3 1   4     0   5   34 24                 58
1365065 1365065 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_7 29 17 7 0   3     0   6   28 34 *                     62.0 29 17 7 0   3     0   6   28 34                 62
1365066 1365066 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_8 27 21 6 1   3     0   4   36 26 *                     62.0 27 21 6 1   3     0   4   36 26                 62
1365067 1365067 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_9 17 21 7 0   1     0   4   28 22 *                     50.0 17 21 7 0   1     0   4   28 22                 50
1365068 1365068 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_10 20 18 3 0   4     0   2   30 17 *                     47.0 20 18 3 0   4     0   2   30 17                 47
1365069 1365069 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_11 13 20 4 0   2     0   1   25 15 *                     40.0 13 20 4 0   2     0   1   25 15                 40
1365070 1365070 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_12 18 18 3 0   4     0   4   19 28 *                     47.0 18 18 3 0   4     0   4   19 28                 47
1365071 1365071 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 94 9 29 0   3     0   26   99 62 *                     161.0 94 9 29 0   3     0   26   99 62                 161
1365072 1365072 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   kindergarten 41 2 11 0   0     0   4   34 24 *                     58.0 41 2 11 0   0     0   4   34 24                 58
1365073 1365073 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_1 45 1 4 0   3     0   9   31 31 *                     62.0 45 1 4 0   3     0   9   31 31                 62
1365074 1365074 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_2 47 2 6 0   0     0   7   36 26 *                     62.0 47 2 6 0   0     0   7   36 26                 62
1365075 1365075 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_3 49 2 6 0   2     0   4   36 27 *                     63.0 49 2 6 0   2     0   4   36 27                 63
1365076 1365076 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   kindergarten 32 4 11 0   0     0   8   25 30 *                     55.0 32 4 11 0   0     0   8   25 30                 55
1365077 1365077 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_1 47 5 15 0   0     0   4   42 29 *                     71.0 47 5 15 0   0     0   4   42 29                 71
1365078 1365078 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_2 42 4 6 0   1     0   7   34 26 *                     60.0 42 4 6 0   1     0   7   34 26                 60
1365079 1365079 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_3 36 4 12 0   2     0   3   30 27 *                     57.0 36 4 12 0   2     0   3   30 27                 57
1365080 1365080 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   kindergarten 23 10 22 3   4     0   4   40 26 *                     66.0 23 10 22 3   4     0   4   40 26                 66
1365081 1365081 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_1 36 6 25 0   5     0   5   40 37 *                     77.0 36 6 25 0   5     0   5   40 37                 77
1365082 1365082 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_2 44 11 25 1   1     0   2   42 42 *                     84.0 44 11 25 1   1     0   2   42 42                 84
1365083 1365083 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_3 39 6 17 0   2     0   1   33 32 *                     65.0 39 6 17 0   2     0   1   33 32                 65

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