Data source: Big Local News · About: Big Local

29,417 rows where state = "GA" and year = 2020 sorted by ccd_school_low_grade

View and edit SQL

grade

year

  • 2020 · 29,417
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
312220 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 spring grade_1 3 124 1 2   1       0 2   73 60                       133 3 124 1 2   1       0 2   73 60                 133
312294 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 spring grade_2 0 101 1 1   0       1 2   61 45                       106 0 101 1 1   0       1 2   61 45                 106
312329 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 spring grade_3 4 82 2 1   0       0 4   54 39                       93 4 82 2 1   0       0 4   54 39                 93
312363 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 spring grade_4 0 83 0 0   1       0 2   48 38                       86 0 83 0 0   1       0 2   48 38                 86
312397 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 spring grade_5 0 108 1 0   1       0 3   58 55                       113 0 108 1 0   1       0 3   58 55                 113
312533 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 spring pk_12_total 7 498 5 4   3       1 13   294 237                       531 7 498 5 4   3       1 13   294 237                 531
320762 GA     school 1303690 701   Mitchell County 130369004330 298 Eagle's Landing Academy   Regular School No Elementary 01 02 2020 spring grade_10 0 17 0 0   0       0 1   12 6                       18 0 17 0 0   0       0 1   12 6                 18
320769 GA     school 1303690 701   Mitchell County 130369004330 298 Eagle's Landing Academy   Regular School No Elementary 01 02 2020 spring grade_5 0 15 0 0   0       0 0   7 8                       15 0 15 0 0   0       0 0   7 8                 15
320771 GA     school 1303690 701   Mitchell County 130369004330 298 Eagle's Landing Academy   Regular School No Elementary 01 02 2020 spring grade_6 1 13 3 0   0       0 0   12 5                       17 1 13 3 0   0       0 0   12 5                 17
320773 GA     school 1303690 701   Mitchell County 130369004330 298 Eagle's Landing Academy   Regular School No Elementary 01 02 2020 spring grade_7 0 14 1 0   0       0 1   14 2                       16 0 14 1 0   0       0 1   14 2                 16
320775 GA     school 1303690 701   Mitchell County 130369004330 298 Eagle's Landing Academy   Regular School No Elementary 01 02 2020 spring grade_8 1 15 1 0   0       0 0   13 4                       17 1 15 1 0   0       0 0   13 4                 17
320777 GA     school 1303690 701   Mitchell County 130369004330 298 Eagle's Landing Academy   Regular School No Elementary 01 02 2020 spring grade_9 1 16 1 0   0       0 0   10 8                       18 1 16 1 0   0       0 0   10 8                 18
320780 GA     school 1303690 701   Mitchell County 130369004330 298 Eagle's Landing Academy   Regular School No Elementary 01 02 2020 spring pk_12_total 3 90 6 0   0       0 2   68 33                       101 3 90 6 0   0       0 2   68 33                 101
322664 GA     school 1304560 727   Stephens County 130456001987 187 Liberty Elementary School   Regular School No Elementary 01 02 2020 spring grade_1 209 47 13 0   2       0 32   165 138                       303 209 47 13 0   2       0 32   165 138                 303
322668 GA     school 1304560 727   Stephens County 130456001987 187 Liberty Elementary School   Regular School No Elementary 01 02 2020 spring grade_2 215 36 13 1   2       0 29   144 152                       296 215 36 13 1   2       0 29   144 152                 296
322679 GA     school 1304560 727   Stephens County 130456001987 187 Liberty Elementary School   Regular School No Elementary 01 02 2020 spring pk_12_total 424 83 26 1   4       0 61   309 290                       599 424 83 26 1   4       0 61   309 290                 599
322870 GA     school 1304890 736   Thomas County 130489001666 5050 Garrison-Pilcher Elementary School   Regular School No Elementary 01 02 2020 spring grade_1 203 150 26 5   1       0 19   208 196                       404 203 150 26 5   1       0 19   208 196                 404
322880 GA     school 1304890 736   Thomas County 130489001666 5050 Garrison-Pilcher Elementary School   Regular School No Elementary 01 02 2020 spring grade_2 204 154 37 3   5       2 13   220 198                       418 204 154 37 3   5       2 13   220 198                 418
322894 GA     school 1304890 736   Thomas County 130489001666 5050 Garrison-Pilcher Elementary School   Regular School No Elementary 01 02 2020 spring pk_12_total 407 304 63 8   6       2 32   428 394                       822 407 304 63 8   6       2 32   428 394                 822
324517 GA     school 1300600 764   Buford City 130060002345 100 Buford Academy   Regular School No Elementary 01 03 2020 spring grade_1 200 36 101 0   21       0 19   200 177                       377 200 36 101 0   21       0 19   200 177                 377
324521 GA     school 1300600 764   Buford City 130060002345 100 Buford Academy   Regular School No Elementary 01 03 2020 spring grade_2 209 38 103 1   26       0 16   195 198                       393 209 38 103 1   26       0 16   195 198                 393
324522 GA     school 1300600 764   Buford City 130060002345 100 Buford Academy   Regular School No Elementary 01 03 2020 spring grade_3 211 43 126 1   21       0 20   207 215                       422 211 43 126 1   21       0 20   207 215                 422
324530 GA     school 1300600 764   Buford City 130060002345 100 Buford Academy   Regular School No Elementary 01 03 2020 spring pk_12_total 620 117 330 2   68       0 55   602 590                       1192 620 117 330 2   68       0 55   602 590                 1192
418880 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 fall grade_1 1 131 2 1   0       0 3   81 57                       138 1 131 2 1   0       0 3   81 57                 138
418954 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 fall grade_2 0 104 2 0   0       0 2   59 49                       108 0 104 2 0   0       0 2   59 49                 108
418988 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 fall grade_3 2 88 2 0   0       0 4   57 39                       96 2 88 2 0   0       0 4   57 39                 96
419022 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 fall grade_4 0 84 1 0   1       0 3   49 40                       89 0 84 1 0   1       0 3   49 40                 89
419056 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 fall grade_5 0 108 1 0   1       0 3   57 56                       113 0 108 1 0   1       0 3   57 56                 113
419192 GA     school 1301020 625   Savannah-Chatham County 130102000370 2068 Andrea B Williams Elementary School   Regular School No Elementary 01 05 2020 fall pk_12_total 3 515 8 1   2       0 15   303 241                       544 3 515 8 1   2       0 15   303 241                 544
427420 GA     school 1303690 701   Mitchell County 130369004330 298 Eagle's Landing Academy   Regular School No Elementary 01 02 2020 fall grade_1 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
427425 GA     school 1303690 701   Mitchell County 130369004330 298 Eagle's Landing Academy   Regular School No Elementary 01 02 2020 fall grade_2 2 0 0 0   0       0 0   1 1                       2 2 0 0 0   0       0 0   1 1                 2
427435 GA     school 1303690 701   Mitchell County 130369004330 298 Eagle's Landing Academy   Regular School No Elementary 01 02 2020 fall pk_12_total 3 0 0 0   0       0 0   2 1                       3 3 0 0 0   0       0 0   2 1                 3
429316 GA     school 1304560 727   Stephens County 130456001987 187 Liberty Elementary School   Regular School No Elementary 01 02 2020 fall grade_1 205 44 13 0   2       0 33   165 132                       297 205 44 13 0   2       0 33   165 132                 297
429320 GA     school 1304560 727   Stephens County 130456001987 187 Liberty Elementary School   Regular School No Elementary 01 02 2020 fall grade_2 213 36 14 1   2       0 31   147 150                       297 213 36 14 1   2       0 31   147 150                 297
429331 GA     school 1304560 727   Stephens County 130456001987 187 Liberty Elementary School   Regular School No Elementary 01 02 2020 fall pk_12_total 418 80 27 1   4       0 64   312 282                       594 418 80 27 1   4       0 64   312 282                 594
429523 GA     school 1304890 736   Thomas County 130489001666 5050 Garrison-Pilcher Elementary School   Regular School No Elementary 01 02 2020 fall grade_1 203 152 29 5   2       0 19   211 199                       410 203 152 29 5   2       0 19   211 199                 410
429533 GA     school 1304890 736   Thomas County 130489001666 5050 Garrison-Pilcher Elementary School   Regular School No Elementary 01 02 2020 fall grade_2 203 156 36 4   5       2 14   221 199                       420 203 156 36 4   5       2 14   221 199                 420
429547 GA     school 1304890 736   Thomas County 130489001666 5050 Garrison-Pilcher Elementary School   Regular School No Elementary 01 02 2020 fall pk_12_total 406 308 65 9   7       2 33   432 398                       830 406 308 65 9   7       2 33   432 398                 830
431170 GA     school 1300600 764   Buford City 130060002345 100 Buford Academy   Regular School No Elementary 01 03 2020 fall grade_1 202 36 104 0   18       0 18   198 180                       378 202 36 104 0   18       0 18   198 180                 378
431174 GA     school 1300600 764   Buford City 130060002345 100 Buford Academy   Regular School No Elementary 01 03 2020 fall grade_2 205 40 102 1   25       0 15   193 195                       388 205 40 102 1   25       0 15   193 195                 388
431175 GA     school 1300600 764   Buford City 130060002345 100 Buford Academy   Regular School No Elementary 01 03 2020 fall grade_3 213 42 126 1   20       0 21   212 211                       423 213 42 126 1   20       0 21   212 211                 423
431183 GA     school 1300600 764   Buford City 130060002345 100 Buford Academy   Regular School No Elementary 01 03 2020 fall pk_12_total 620 118 332 2   63       0 54   603 586                       1189 620 118 332 2   63       0 54   603 586                 1189
311630 GA     school 1300570 615   Bryan County 130057002389 302 Richmond Hill Elementary School   Regular School No Elementary 02 03 2020 spring grade_2 223 60 38 0   18       0 23   178 184                       362 223 60 38 0   18       0 23   178 184                 362
311633 GA     school 1300570 615   Bryan County 130057002389 302 Richmond Hill Elementary School   Regular School No Elementary 02 03 2020 spring grade_3 226 63 60 2   14       1 14   195 185                       380 226 63 60 2   14       1 14   195 185                 380
311657 GA     school 1300570 615   Bryan County 130057002389 302 Richmond Hill Elementary School   Regular School No Elementary 02 03 2020 spring pk_12_total 449 123 98 2   32       1 37   373 369                       742 449 123 98 2   32       1 37   373 369                 742
312318 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 spring grade_2 0 0 1 0   1       0 0   1 1                       2 0 0 1 0   1       0 0   1 1                 2
312352 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 spring grade_3 34 68 25 0   2       0 13   79 63                       142 34 68 25 0   2       0 13   79 63                 142
312386 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 spring grade_4 34 95 26 1   1       0 6   74 89                       163 34 95 26 1   1       0 6   74 89                 163
312420 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 spring grade_5 25 111 34 2   0       0 16   99 89                       188 25 111 34 2   0       0 16   99 89                 188
312443 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 spring grade_6 29 94 21 0   0       0 8   97 55                       152 29 94 21 0   0       0 8   97 55                 152
312463 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 spring grade_7 24 88 13 0   0       0 12   81 56                       137 24 88 13 0   0       0 12   81 56                 137
312482 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 spring grade_8 19 80 13 1   1       0 6   67 53                       120 19 80 13 1   1       0 6   67 53                 120
312570 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 spring pk_12_total 165 536 133 4   5       0 61   498 406                       904 165 536 133 4   5       0 61   498 406                 904
313624 GA     school 1301290 633   Cobb County 130129000539 302 Acworth Intermediate School   Regular School No Elementary 02 05 2020 spring grade_2 57 46 30 0   2       0 9   73 71                       144 57 46 30 0   2       0 9   73 71                 144
313638 GA     school 1301290 633   Cobb County 130129000520 102 City View Elementary School   Regular School No Elementary 02 05 2020 spring grade_2 8 131 111 1   1       1 0   130 123                       253 8 131 111 1   1       1 0   130 123                 253
313689 GA     school 1301290 633   Cobb County 130129000539 302 Acworth Intermediate School   Regular School No Elementary 02 05 2020 spring grade_3 48 53 39 0   4       0 16   75 85                       160 48 53 39 0   4       0 16   75 85                 160
313704 GA     school 1301290 633   Cobb County 130129000520 102 City View Elementary School   Regular School No Elementary 02 05 2020 spring grade_3 7 135 119 0   0       0 4   145 120                       265 7 135 119 0   0       0 4   145 120                 265
313754 GA     school 1301290 633   Cobb County 130129000539 302 Acworth Intermediate School   Regular School No Elementary 02 05 2020 spring grade_4 40 59 35 0   4       0 9   70 77                       147 40 59 35 0   4       0 9   70 77                 147
313769 GA     school 1301290 633   Cobb County 130129000520 102 City View Elementary School   Regular School No Elementary 02 05 2020 spring grade_4 5 129 123 0   0       0 1   123 135                       258 5 129 123 0   0       0 1   123 135                 258
313820 GA     school 1301290 633   Cobb County 130129000539 302 Acworth Intermediate School   Regular School No Elementary 02 05 2020 spring grade_5 52 71 53 0   3       0 7   96 90                       186 52 71 53 0   3       0 7   96 90                 186
313835 GA     school 1301290 633   Cobb County 130129000520 102 City View Elementary School   Regular School No Elementary 02 05 2020 spring grade_5 1 136 142 0   0       0 2   132 149                       281 1 136 142 0   0       0 2   132 149                 281
314044 GA     school 1301290 633   Cobb County 130129000539 302 Acworth Intermediate School   Regular School No Elementary 02 05 2020 spring pk_12_total 197 229 157 0   13       0 41   314 323                       637 197 229 157 0   13       0 41   314 323                 637
314064 GA     school 1301290 633   Cobb County 130129000520 102 City View Elementary School   Regular School No Elementary 02 05 2020 spring pk_12_total 21 531 495 1   1       1 7   530 527                       1057 21 531 495 1   1       1 7   530 527                 1057
315052 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Regular School No Other 02 11 2020 spring grade_10 2 1 0 0   0       0 0   2 1                       3 2 1 0 0   0       0 0   2 1                 3
315263 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Regular School No Other 02 11 2020 spring grade_3 1 1 0 0   0       0 0   2 0                       2 1 1 0 0   0       0 0   2 0                 2
315347 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Regular School No Other 02 11 2020 spring grade_4 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
315432 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Regular School No Other 02 11 2020 spring grade_5 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
315468 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Regular School No Other 02 11 2020 spring grade_6 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
315500 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Regular School No Other 02 11 2020 spring grade_7 1 2 0 0   0       0 3   3 3                       6 1 2 0 0   0       0 3   3 3                 6
315531 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Regular School No Other 02 11 2020 spring grade_8 2 0 0 0   0       0 0   0 2                       2 2 0 0 0   0       0 0   0 2                 2
315557 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Regular School No Other 02 11 2020 spring grade_9 1 4 0 0   0       0 0   2 3                       5 1 4 0 0   0       0 0   2 3                 5
315764 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Regular School No Other 02 11 2020 spring pk_12_total 8 10 0 0   0       0 3   12 9                       21 8 10 0 0   0       0 3   12 9                 21
316070 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring grade_10 0 1 0 0   0       0 0   0 1                       1 0 1 0 0   0       0 0   0 1                 1
316076 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring grade_11 1 1 0 0   0       0 0   1 1                       2 1 1 0 0   0       0 0   1 1                 2
316103 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring grade_2 1 1 0 0   0       0 0   2 0                       2 1 1 0 0   0       0 0   2 0                 2
316125 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring grade_3 0 0 0 0   0       0 1   0 1                       1 0 0 0 0   0       0 1   0 1                 1
316147 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring grade_4 2 0 0 0   1       0 0   2 1                       3 2 0 0 0   1       0 0   2 1                 3
316169 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring grade_5 1 0 0 0   0       0 2   1 2                       3 1 0 0 0   0       0 2   1 2                 3
316179 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring grade_6 1 1 0 0   0       0 1   2 1                       3 1 1 0 0   0       0 1   2 1                 3
316189 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring grade_7 2 1 1 0   0       0 0   0 4                       4 2 1 1 0   0       0 0   0 4                 4
316199 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring grade_8 1 2 0 0   0       0 0   0 3                       3 1 2 0 0   0       0 0   0 3                 3
316205 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring grade_9 5 1 0 0   0       0 0   3 3                       6 5 1 0 0   0       0 0   3 3                 6
316261 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 10 2020 spring pk_12_total 14 8 1 0   1       0 4   11 17                       28 14 8 1 0   1       0 4   11 17                 28
316395 GA     school 1302010 652   Elbert County 130201004097 313 Elbert County Elementary School   Regular School No Elementary 02 04 2020 spring grade_2 120 74 22 1   2       0 13   123 109                       232 120 74 22 1   2       0 13   123 109                 232
316396 GA     school 1302010 652   Elbert County 130201004097 313 Elbert County Elementary School   Regular School No Elementary 02 04 2020 spring grade_3 89 77 25 0   2       0 13   97 109                       206 89 77 25 0   2       0 13   97 109                 206
316397 GA     school 1302010 652   Elbert County 130201004097 313 Elbert County Elementary School   Regular School No Elementary 02 04 2020 spring grade_4 109 79 17 0   4       0 7   111 105                       216 109 79 17 0   4       0 7   111 105                 216
316404 GA     school 1302010 652   Elbert County 130201004097 313 Elbert County Elementary School   Regular School No Elementary 02 04 2020 spring pk_12_total 318 230 64 1   8       0 33   331 323                       654 318 230 64 1   8       0 33   331 323                 654
318159 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_10 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
318187 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_11 0 0 0 0   1       0 0   0 1                       1 0 0 0 0   1       0 0   0 1                 1
318214 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_12 3 9 3 0   3       0 0   11 7                       18 3 9 3 0   3       0 0   11 7                 18
318278 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_2 0 0 3 0   0       0 0   1 2                       3 0 0 3 0   0       0 0   1 2                 3
318361 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_3 0 0 1 0   0       0 0   0 1                       1 0 0 1 0   0       0 0   0 1                 1
318445 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_4 1 2 1 0   0       0 0   4 0                       4 1 2 1 0   0       0 0   4 0                 4
318529 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_5 1 1 1 0   0       0 0   3 0                       3 1 1 1 0   0       0 0   3 0                 3
318578 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_6 0 0 1 0   0       0 0   1 0                       1 0 0 1 0   0       0 0   1 0                 1
318612 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_7 1 1 4 0   1       0 0   2 5                       7 1 1 4 0   1       0 0   2 5                 7
318647 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_8 0 0 2 0   0       0 0   0 2                       2 0 0 2 0   0       0 0   0 2                 2
318679 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring grade_9 1 2 0 0   1       0 0   2 2                       4 1 2 0 0   1       0 0   2 2                 4
318743 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring kindergarten 0 1 2 0   0       1 0   3 1                       4 0 1 2 0   0       1 0   3 1                 4
318866 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring pk_12_total 8 19 19 0   6       1 0   31 22                       53 8 19 19 0   6       1 0   31 22                 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]);