Data source: Big Local News · About: Big Local

204,362 rows where state = "GA" sorted by ccd_charter_school

View and edit SQL

grade

year

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
310859 GA     school   891   Department of Juvenile Justice   4203 Terrell Regional Youth Detention Center             2017 spring grade_9 0 2 0 0   0       0 0   2 0                       2 0 2 0 0   0       0 0   2 0                 2
310885 GA     school   891   Department of Juvenile Justice   4203 Terrell Regional Youth Detention Center             2017 spring pk_12_total 0 2 0 0   0       0 0   2 0                       2 0 2 0 0   0       0 0   2 0                 2
2565547 GA     school   701   Mitchell County   298 Eagle's Landing Academy             2019 spring grade_10 0 2 0 0   0       0 1   1 2                       3 0 2 0 0   0       0 1   1 2                 3
2565550 GA     school   701   Mitchell County   298 Eagle's Landing Academy             2019 spring grade_11 0 1 0 0   0       0 0   0 1                       1 0 1 0 0   0       0 0   0 1                 1
2565561 GA     school   701   Mitchell County   298 Eagle's Landing Academy             2019 spring grade_5 0 2 0 0   0       0 0   2 0                       2 0 2 0 0   0       0 0   2 0                 2
2565564 GA     school   701   Mitchell County   298 Eagle's Landing Academy             2019 spring grade_6 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2565567 GA     school   701   Mitchell County   298 Eagle's Landing Academy             2019 spring grade_7 0 1 0 0   0       0 0   0 1                       1 0 1 0 0   0       0 0   0 1                 1
2565570 GA     school   701   Mitchell County   298 Eagle's Landing Academy             2019 spring grade_8 0 2 0 0   0       0 0   1 1                       2 0 2 0 0   0       0 0   1 1                 2
2565573 GA     school   701   Mitchell County   298 Eagle's Landing Academy             2019 spring grade_9 1 0 1 0   0       0 0   1 1                       2 1 0 1 0   0       0 0   1 1                 2
2565578 GA     school   701   Mitchell County   298 Eagle's Landing Academy             2019 spring pk_12_total 1 9 1 0   0       0 1   6 6                       12 1 9 1 0   0       0 1   6 6                 12
2570210 GA     school   891   Department of Juvenile Justice   4205 Cadwell RYDC             2019 spring grade_6 0 1 0 0   0       0 0   0 1                       1 0 1 0 0   0       0 0   0 1                 1
2570234 GA     school   891   Department of Juvenile Justice   4205 Cadwell RYDC             2019 spring grade_8 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
2570282 GA     school   891   Department of Juvenile Justice   4205 Cadwell RYDC             2019 spring pk_12_total 1 1 0 0   0       0 0   1 1                       2 1 1 0 0   0       0 0   1 1                 2
413974 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 fall grade_10 1 8 1 0   0       0 0   7 3                       10 1 8 1 0   0       0 0   7 3                 10
413988 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 fall grade_11 1 6 0 0   0       0 0   6 1                       7 1 6 0 0   0       0 0   6 1                 7
414001 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 fall grade_12 1 2 0 0   0       1 0   2 2                       4 1 2 0 0   0       1 0   2 2                 4
414158 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 fall grade_7 1 6 0 0   0       0 1   6 2                       8 1 6 0 0   0       0 1   6 2                 8
414175 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 fall grade_8 1 9 0 0   0       0 0   9 1                       10 1 9 0 0   0       0 0   9 1                 10
414193 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 fall grade_9 0 12 0 0   0       0 0   11 1                       12 0 12 0 0   0       0 0   11 1                 12
414239 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 fall pk_12_total 5 43 1 0   0       1 1   41 10                       51 5 43 1 0   0       1 1   41 10                 51
2271892 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 spring grade_10 1 5 1 0   0       0 0   6 1                       7 1 5 1 0   0       0 0   6 1                 7
2271906 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 spring grade_11 1 3 1 0   0       0 0   5 0                       5 1 3 1 0   0       0 0   5 0                 5
2271920 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 spring grade_12 1 4 0 0   0       0 0   4 1                       5 1 4 0 0   0       0 0   4 1                 5
2272061 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 spring grade_6 0 2 0 0   0       0 0   2 0                       2 0 2 0 0   0       0 0   2 0                 2
2272078 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 spring grade_7 0 5 0 0   0       0 0   4 1                       5 0 5 0 0   0       0 0   4 1                 5
2272095 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 spring grade_8 1 5 0 0   0       0 0   6 0                       6 1 5 0 0   0       0 0   6 0                 6
2272113 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 spring grade_9 0 10 1 0   0       0 0   9 2                       11 0 10 1 0   0       0 0   9 2                 11
2272159 GA     school   721   Richmond County   391 Alternative Education Center at Morgan             2021 spring pk_12_total 4 34 3 0   0       0 0   36 5                       41 4 34 3 0   0       0 0   36 5                 41
1 GA     school 1300060 601   Appling County 130006000011 1050 Altamaha Elementary School   Regular School No 1 PK 05 2015 fall grade_1 42 6 5 0   0       0 0   25 28                       53 42 6 5 0   0       0 0   25 28                 53
2 GA     school 1300060 601   Appling County 130006000006 277 Appling County Primary School   Regular School No 1 PK 02 2015 fall grade_1 96 65 52 0   1       0 5   99 120                       219 96 65 52 0   1       0 5   99 120                 219
3 GA     school 1300060 601   Appling County 130006000008 5050 Fourth District Elementary School   Regular School No 1 PK 05 2015 fall grade_1 22 3 3 0   0       0 1   14 15                       29 22 3 3 0   0       0 1   14 15                 29
4 GA     school 1300060 601   Appling County 130006000010 103 Appling County High School   Regular School No 3 09 12 2015 fall grade_10 138 52 32 1   1       0 6   119 111                       230 138 52 32 1   1       0 6   119 111                 230
5 GA     school 1300060 601   Appling County 130006000010 103 Appling County High School   Regular School No 3 09 12 2015 fall grade_11 167 60 23 0   2       0 3   136 119                       255 167 60 23 0   2       0 3   136 119                 255
6 GA     school 1300060 601   Appling County 130006000010 103 Appling County High School   Regular School No 3 09 12 2015 fall grade_12 169 47 20 0   2       0 4   126 116                       242 169 47 20 0   2       0 4   126 116                 242
7 GA     school 1300060 601   Appling County 130006000011 1050 Altamaha Elementary School   Regular School No 1 PK 05 2015 fall grade_2 52 2 3 0   0       0 2   28 31                       59 52 2 3 0   0       0 2   28 31                 59
8 GA     school 1300060 601   Appling County 130006000006 277 Appling County Primary School   Regular School No 1 PK 02 2015 fall grade_2 87 58 32 0   1       0 8   92 94                       186 87 58 32 0   1       0 8   92 94                 186
9 GA     school 1300060 601   Appling County 130006000008 5050 Fourth District Elementary School   Regular School No 1 PK 05 2015 fall grade_2 25 1 2 0   0       0 1   14 15                       29 25 1 2 0   0       0 1   14 15                 29
10 GA     school 1300060 601   Appling County 130006000011 1050 Altamaha Elementary School   Regular School No 1 PK 05 2015 fall grade_3 41 2 2 0   0       0 1   21 25                       46 41 2 2 0   0       0 1   21 25                 46
11 GA     school 1300060 601   Appling County 130006000007 177 Appling County Elementary School   Regular School No 1 03 05 2015 fall grade_3 88 65 45 0   4       0 10   112 100                       212 88 65 45 0   4       0 10   112 100                 212
12 GA     school 1300060 601   Appling County 130006000008 5050 Fourth District Elementary School   Regular School No 1 PK 05 2015 fall grade_3 18 2 2 0   0       0 1   10 13                       23 18 2 2 0   0       0 1   10 13                 23
13 GA     school 1300060 601   Appling County 130006000011 1050 Altamaha Elementary School   Regular School No 1 PK 05 2015 fall grade_4 56 3 0 0   0       0 0   29 30                       59 56 3 0 0   0       0 0   29 30                 59
14 GA     school 1300060 601   Appling County 130006000007 177 Appling County Elementary School   Regular School No 1 03 05 2015 fall grade_4 85 57 39 0   1       0 9   80 111                       191 85 57 39 0   1       0 9   80 111                 191
15 GA     school 1300060 601   Appling County 130006000008 5050 Fourth District Elementary School   Regular School No 1 PK 05 2015 fall grade_4 16 1 2 0   0       0 2   12 9                       21 16 1 2 0   0       0 2   12 9                 21
16 GA     school 1300060 601   Appling County 130006000011 1050 Altamaha Elementary School   Regular School No 1 PK 05 2015 fall grade_5 53 1 4 0   0       0 1   27 32                       59 53 1 4 0   0       0 1   27 32                 59
17 GA     school 1300060 601   Appling County 130006000007 177 Appling County Elementary School   Regular School No 1 03 05 2015 fall grade_5 101 48 28 1   1       0 5   101 83                       184 101 48 28 1   1       0 5   101 83                 184
18 GA     school 1300060 601   Appling County 130006000008 5050 Fourth District Elementary School   Regular School No 1 PK 05 2015 fall grade_5 14 2 0 0   0       0 1   9 8                       17 14 2 0 0   0       0 1   9 8                 17
19 GA     school 1300060 601   Appling County 130006000009 195 Appling County Middle School   Regular School No 2 06 08 2015 fall grade_6 149 67 27 0   3       0 11   131 126                       257 149 67 27 0   3       0 11   131 126                 257
20 GA     school 1300060 601   Appling County 130006000009 195 Appling County Middle School   Regular School No 2 06 08 2015 fall grade_7 167 41 33 0   1       0 8   133 117                       250 167 41 33 0   1       0 8   133 117                 250
21 GA     school 1300060 601   Appling County 130006000009 195 Appling County Middle School   Regular School No 2 06 08 2015 fall grade_8 161 59 34 1   1       0 8   134 130                       264 161 59 34 1   1       0 8   134 130                 264
22 GA     school 1300060 601   Appling County 130006000010 103 Appling County High School   Regular School No 3 09 12 2015 fall grade_9 171 60 40 0   2       0 3   162 114                       276 171 60 40 0   2       0 3   162 114                 276
23 GA     school 1300060 601   Appling County 130006000011 1050 Altamaha Elementary School   Regular School No 1 PK 05 2015 fall kindergarten 47 6 8 0   0       0 3   35 29                       64 47 6 8 0   0       0 3   35 29                 64
24 GA     school 1300060 601   Appling County 130006000006 277 Appling County Primary School   Regular School No 1 PK 02 2015 fall kindergarten 86 58 47 0   1       0 6   107 91                       198 86 58 47 0   1       0 6   107 91                 198
25 GA     school 1300060 601   Appling County 130006000008 5050 Fourth District Elementary School   Regular School No 1 PK 05 2015 fall kindergarten 23 4 4 0   0       0 2   17 16                       33 23 4 4 0   0       0 2   17 16                 33
26 GA     school 1300060 601   Appling County 130006000011 1050 Altamaha Elementary School   Regular School No 1 PK 05 2015 fall pk_12_total 329 23 28 0   0       0 10   198 192                       390 329 23 28 0   0       0 10   198 192                 390
27 GA     school 1300060 601   Appling County 130006000007 177 Appling County Elementary School   Regular School No 1 03 05 2015 fall pk_12_total 274 170 112 1   6       0 24   293 294                       587 274 170 112 1   6       0 24   293 294                 587
28 GA     school 1300060 601   Appling County 130006000010 103 Appling County High School   Regular School No 3 09 12 2015 fall pk_12_total 645 219 115 1   7       0 16   543 460                       1003 645 219 115 1   7       0 16   543 460                 1003
29 GA     school 1300060 601   Appling County 130006000009 195 Appling County Middle School   Regular School No 2 06 08 2015 fall pk_12_total 477 167 94 1   5       0 27   398 373                       771 477 167 94 1   5       0 27   398 373                 771
30 GA     school 1300060 601   Appling County 130006000006 277 Appling County Primary School   Regular School No 1 PK 02 2015 fall pk_12_total 335 231 164 0   3       0 30   378 385                       763 335 231 164 0   3       0 30   378 385                 763
31 GA     school 1300060 601   Appling County 130006000008 5050 Fourth District Elementary School   Regular School No 1 PK 05 2015 fall pk_12_total 137 14 14 0   0       0 9   85 89                       174 137 14 14 0   0       0 9   85 89                 174
32 GA     school 1300060 601   Appling County 130006000011 1050 Altamaha Elementary School   Regular School No 1 PK 05 2015 fall pre_kindergarten 38 3 6 0   0       0 3   33 17                       50 38 3 6 0   0       0 3   33 17                 50
33 GA     school 1300060 601   Appling County 130006000006 277 Appling County Primary School   Regular School No 1 PK 02 2015 fall pre_kindergarten 66 50 33 0   0       0 11   80 80                       160 66 50 33 0   0       0 11   80 80                 160
34 GA     school 1300060 601   Appling County 130006000008 5050 Fourth District Elementary School   Regular School No 1 PK 05 2015 fall pre_kindergarten 19 1 1 0   0       0 1   9 13                       22 19 1 1 0   0       0 1   9 13                 22
35 GA     school 1300090 602   Atkinson County 130009000013 190 Pearson Elementary School   Regular School No 1 PK 05 2015 fall grade_1 32 13 41 0   0       0 0   47 39                       86 32 13 41 0   0       0 0   47 39                 86
36 GA     school 1300090 602   Atkinson County 130009001965 187 Willacoochee Elementary School   Regular School No 1 PK 05 2015 fall grade_1 20 14 11 0   0       0 0   17 28                       45 20 14 11 0   0       0 0   17 28                 45
37 GA     school 1300090 602   Atkinson County 130009000015 103 Atkinson County High School   Regular School No 3 09 12 2015 fall grade_10 53 21 30 0   0       0 0   42 62                       104 53 21 30 0   0       0 0   42 62                 104
38 GA     school 1300090 602   Atkinson County 130009000015 103 Atkinson County High School   Regular School No 3 09 12 2015 fall grade_11 46 20 39 0   0       0 0   52 53                       105 46 20 39 0   0       0 0   52 53                 105
39 GA     school 1300090 602   Atkinson County 130009000015 103 Atkinson County High School   Regular School No 3 09 12 2015 fall grade_12 36 26 28 0   0       0 0   44 46                       90 36 26 28 0   0       0 0   44 46                 90
40 GA     school 1300090 602   Atkinson County 130009000013 190 Pearson Elementary School   Regular School No 1 PK 05 2015 fall grade_2 39 9 47 0   0       0 4   60 39                       99 39 9 47 0   0       0 4   60 39                 99
41 GA     school 1300090 602   Atkinson County 130009001965 187 Willacoochee Elementary School   Regular School No 1 PK 05 2015 fall grade_2 15 5 12 0   0       0 0   16 16                       32 15 5 12 0   0       0 0   16 16                 32
42 GA     school 1300090 602   Atkinson County 130009000013 190 Pearson Elementary School   Regular School No 1 PK 05 2015 fall grade_3 47 13 39 0   0       1 1   49 52                       101 47 13 39 0   0       1 1   49 52                 101
43 GA     school 1300090 602   Atkinson County 130009001965 187 Willacoochee Elementary School   Regular School No 1 PK 05 2015 fall grade_3 7 4 10 0   0       0 0   13 8                       21 7 4 10 0   0       0 0   13 8                 21
44 GA     school 1300090 602   Atkinson County 130009000013 190 Pearson Elementary School   Regular School No 1 PK 05 2015 fall grade_4 34 12 34 1   0       0 1   37 45                       82 34 12 34 1   0       0 1   37 45                 82
45 GA     school 1300090 602   Atkinson County 130009001965 187 Willacoochee Elementary School   Regular School No 1 PK 05 2015 fall grade_4 15 11 7 0   0       0 3   18 18                       36 15 11 7 0   0       0 3   18 18                 36
46 GA     school 1300090 602   Atkinson County 130009000013 190 Pearson Elementary School   Regular School No 1 PK 05 2015 fall grade_5 46 10 30 0   0       0 2   46 42                       88 46 10 30 0   0       0 2   46 42                 88
47 GA     school 1300090 602   Atkinson County 130009001965 187 Willacoochee Elementary School   Regular School No 1 PK 05 2015 fall grade_5 5 9 10 0   0       0 0   11 13                       24 5 9 10 0   0       0 0   11 13                 24
48 GA     school 1300090 602   Atkinson County 130009003996 111 Atkinson County Middle School   Regular School No 2 06 08 2015 fall grade_6 75 19 34 0   0       0 0   72 56                       128 75 19 34 0   0       0 0   72 56                 128
49 GA     school 1300090 602   Atkinson County 130009003996 111 Atkinson County Middle School   Regular School No 2 06 08 2015 fall grade_7 58 21 59 0   0       0 3   77 64                       141 58 21 59 0   0       0 3   77 64                 141
50 GA     school 1300090 602   Atkinson County 130009003996 111 Atkinson County Middle School   Regular School No 2 06 08 2015 fall grade_8 59 19 45 0   0       0 1   63 61                       124 59 19 45 0   0       0 1   63 61                 124
51 GA     school 1300090 602   Atkinson County 130009000015 103 Atkinson County High School   Regular School No 3 09 12 2015 fall grade_9 69 21 43 0   0       0 3   74 62                       136 69 21 43 0   0       0 3   74 62                 136
52 GA     school 1300090 602   Atkinson County 130009000013 190 Pearson Elementary School   Regular School No 1 PK 05 2015 fall kindergarten 51 16 44 0   0       0 4   68 47                       115 51 16 44 0   0       0 4   68 47                 115
53 GA     school 1300090 602   Atkinson County 130009001965 187 Willacoochee Elementary School   Regular School No 1 PK 05 2015 fall kindergarten 9 13 10 0   0       0 0   14 18                       32 9 13 10 0   0       0 0   14 18                 32
54 GA     school 1300090 602   Atkinson County 130009000015 103 Atkinson County High School   Regular School No 3 09 12 2015 fall pk_12_total 204 88 140 0   0       0 3   212 223                       435 204 88 140 0   0       0 3   212 223                 435
55 GA     school 1300090 602   Atkinson County 130009003996 111 Atkinson County Middle School   Regular School No 2 06 08 2015 fall pk_12_total 192 59 138 0   0       0 4   212 181                       393 192 59 138 0   0       0 4   212 181                 393
56 GA     school 1300090 602   Atkinson County 130009000013 190 Pearson Elementary School   Regular School No 1 PK 05 2015 fall pk_12_total 281 87 276 1   0       1 13   348 311                       659 281 87 276 1   0       1 13   348 311                 659
57 GA     school 1300090 602   Atkinson County 130009001965 187 Willacoochee Elementary School   Regular School No 1 PK 05 2015 fall pk_12_total 85 59 63 0   0       0 3   98 112                       210 85 59 63 0   0       0 3   98 112                 210
58 GA     school 1300090 602   Atkinson County 130009000013 190 Pearson Elementary School   Regular School No 1 PK 05 2015 fall pre_kindergarten 32 14 41 0   0       0 1   41 47                       88 32 14 41 0   0       0 1   41 47                 88
59 GA     school 1300090 602   Atkinson County 130009001965 187 Willacoochee Elementary School   Regular School No 1 PK 05 2015 fall pre_kindergarten 14 3 3 0   0       0 0   9 11                       20 14 3 3 0   0       0 0   9 11                 20
60 GA     school 1300150 603   Bacon County 130015000153 102 Bacon County Primary School   Regular School No 1 PK 02 2015 fall grade_1 110 55 25 0   1       0 10   104 97                       201 110 55 25 0   1       0 10   104 97                 201
61 GA     school 1300150 603   Bacon County 130015002357 302 Bacon County High School   Regular School No 3 09 12 2015 fall grade_10 110 21 7 0   0       1 1   70 70                       140 110 21 7 0   0       1 1   70 70                 140
62 GA     school 1300150 603   Bacon County 130015002357 302 Bacon County High School   Regular School No 3 09 12 2015 fall grade_11 87 20 6 0   1       0 3   56 61                       117 87 20 6 0   1       0 3   56 61                 117
63 GA     school 1300150 603   Bacon County 130015002357 302 Bacon County High School   Regular School No 3 09 12 2015 fall grade_12 105 20 4 0   1       0 3   62 71                       133 105 20 4 0   1       0 3   62 71                 133
64 GA     school 1300150 603   Bacon County 130015000153 102 Bacon County Primary School   Regular School No 1 PK 02 2015 fall grade_2 91 29 25 0   0       0 13   83 75                       158 91 29 25 0   0       0 13   83 75                 158
65 GA     school 1300150 603   Bacon County 130015000151 3050 Bacon County Elementary School   Regular School No 1 03 05 2015 fall grade_3 100 47 23 0   1       0 4   97 78                       175 100 47 23 0   1       0 4   97 78                 175
66 GA     school 1300150 603   Bacon County 130015000151 3050 Bacon County Elementary School   Regular School No 1 03 05 2015 fall grade_4 99 33 18 0   0       0 7   83 74                       157 99 33 18 0   0       0 7   83 74                 157
67 GA     school 1300150 603   Bacon County 130015000151 3050 Bacon County Elementary School   Regular School No 1 03 05 2015 fall grade_5 98 37 17 0   0       0 3   67 88                       155 98 37 17 0   0       0 3   67 88                 155
68 GA     school 1300150 603   Bacon County 130015002349 202 Bacon County Middle School   Regular School No 2 06 08 2015 fall grade_6 105 32 15 0   1       0 2   79 76                       155 105 32 15 0   1       0 2   79 76                 155
69 GA     school 1300150 603   Bacon County 130015002349 202 Bacon County Middle School   Regular School No 2 06 08 2015 fall grade_7 93 30 11 0   0       0 5   75 64                       139 93 30 11 0   0       0 5   75 64                 139
70 GA     school 1300150 603   Bacon County 130015002349 202 Bacon County Middle School   Regular School No 2 06 08 2015 fall grade_8 114 24 22 0   0       0 6   91 75                       166 114 24 22 0   0       0 6   91 75                 166
71 GA     school 1300150 603   Bacon County 130015002357 302 Bacon County High School   Regular School No 3 09 12 2015 fall grade_9 111 36 18 1   0       0 4   88 82                       170 111 36 18 1   0       0 4   88 82                 170
72 GA     school 1300150 603   Bacon County 130015000153 102 Bacon County Primary School   Regular School No 1 PK 02 2015 fall kindergarten 89 41 22 1   0       0 7   72 88                       160 89 41 22 1   0       0 7   72 88                 160

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