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,375
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
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
318963 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other 02 12 2020 spring pre_kindergarten 1 2 1 0   0       0 0   3 1                       4 1 2 1 0   0       0 0   3 1                 4
320659 GA     school 1303570 697   McDuffie County 130357001353 4050 Thomson Elementary School   Regular School No Elementary 02 03 2020 spring grade_2 40 130 4 0   0       0 3   93 84                       177 40 130 4 0   0       0 3   93 84                 177
320661 GA     school 1303570 697   McDuffie County 130357001353 4050 Thomson Elementary School   Regular School No Elementary 02 03 2020 spring grade_3 34 147 7 0   0       1 12   105 96                       201 34 147 7 0   0       1 12   105 96                 201
320675 GA     school 1303570 697   McDuffie County 130357001353 4050 Thomson Elementary School   Regular School No Elementary 02 03 2020 spring pk_12_total 74 277 11 0   0       1 15   198 180                       378 74 277 11 0   0       1 15   198 180                 378
320766 GA     school 1303690 701   Mitchell County 130369003832 111 Mitchell County Elementary School   Regular School No Elementary 02 04 2020 spring grade_2 5 85 10 0   0       0 1   47 54                       101 5 85 10 0   0       0 1   47 54                 101
320767 GA     school 1303690 701   Mitchell County 130369003832 111 Mitchell County Elementary School   Regular School No Elementary 02 04 2020 spring grade_3 4 89 8 0   0       0 0   59 42                       101 4 89 8 0   0       0 0   59 42                 101
320768 GA     school 1303690 701   Mitchell County 130369003832 111 Mitchell County Elementary School   Regular School No Elementary 02 04 2020 spring grade_4 10 77 15 0   0       0 0   47 55                       102 10 77 15 0   0       0 0   47 55                 102
320781 GA     school 1303690 701   Mitchell County 130369003832 111 Mitchell County Elementary School   Regular School No Elementary 02 04 2020 spring pk_12_total 19 251 33 0   0       0 1   153 151                       304 19 251 33 0   0       0 1   153 151                 304
322669 GA     school 1304560 727   Stephens County 130456001845 197 Toccoa Elementary School   Regular School No Elementary 02 04 2020 spring grade_2 2 0 0 0   0       0 0   1 1                       2 2 0 0 0   0       0 0   1 1                 2
322670 GA     school 1304560 727   Stephens County 130456001845 197 Toccoa Elementary School   Regular School No Elementary 02 04 2020 spring grade_3 222 38 16 0   3       0 22   144 157                       301 222 38 16 0   3       0 22   144 157                 301
322671 GA     school 1304560 727   Stephens County 130456001845 197 Toccoa Elementary School   Regular School No Elementary 02 04 2020 spring grade_4 208 38 15 0   7       0 23   158 133                       291 208 38 15 0   7       0 23   158 133                 291
322683 GA     school 1304560 727   Stephens County 130456001845 197 Toccoa Elementary School   Regular School No Elementary 02 04 2020 spring pk_12_total 432 76 31 0   10       0 45   303 291                       594 432 76 31 0   10       0 45   303 291                 594
322711 GA     school 1304620 729   Sumter County 130462001630 188 Sumter County Elementary School   Regular School No Elementary 02 03 2020 spring grade_2 14 237 29 0   0       0 6   148 138                       286 14 237 29 0   0       0 6   148 138                 286
322713 GA     school 1304620 729   Sumter County 130462001630 188 Sumter County Elementary School   Regular School No Elementary 02 03 2020 spring grade_3 17 246 47 0   3       0 5   152 166                       318 17 246 47 0   3       0 5   152 166                 318
322732 GA     school 1304620 729   Sumter County 130462001630 188 Sumter County Elementary School   Regular School No Elementary 02 03 2020 spring pk_12_total 31 483 76 0   3       0 11   300 304                       604 31 483 76 0   3       0 11   300 304                 604
323914 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_1 1 0 0 0   0       0 0   0 1                       1 1 0 0 0   0       0 0   0 1                 1
323957 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_10 4 1 0 0   0       0 1   4 2                       6 4 1 0 0   0       0 1   4 2                 6
323975 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_11 2 0 1 0   0       0 0   1 2                       3 2 0 1 0   0       0 0   1 2                 3
324024 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_2 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
324080 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_3 1 0 0 0   0       0 1   1 1                       2 1 0 0 0   0       0 1   1 1                 2
324136 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_4 3 3 0 0   0       0 0   4 2                       6 3 3 0 0   0       0 0   4 2                 6
324192 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_5 1 2 0 0   0       0 0   3 0                       3 1 2 0 0   0       0 0   3 0                 3
324232 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_6 4 1 0 1   0       0 1   6 1                       7 4 1 0 1   0       0 1   6 1                 7
324258 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_7 3 2 1 0   0       0 0   3 3                       6 3 2 1 0   0       0 0   3 3                 6
324284 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_8 5 0 1 0   0       0 0   3 3                       6 5 0 1 0   0       0 0   3 3                 6
324312 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring grade_9 13 3 0 0   0       0 1   10 7                       17 13 3 0 0   0       0 1   10 7                 17
324413 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2020 spring pk_12_total 37 13 3 1   0       0 4   36 22                       58 37 13 3 1   0       0 4   36 22                 58
325406 GA     school 1305340 793   Vidalia City 130534001737 5050 Sally Dailey Meadows Elementary School   Regular School No Elementary 02 05 2020 spring grade_2 66 83 9 0   0       0 10   75 93                       168 66 83 9 0   0       0 10   75 93                 168
325407 GA     school 1305340 793   Vidalia City 130534001737 5050 Sally Dailey Meadows Elementary School   Regular School No Elementary 02 05 2020 spring grade_3 54 97 17 0   0       0 12   96 84                       180 54 97 17 0   0       0 12   96 84                 180
325408 GA     school 1305340 793   Vidalia City 130534001737 5050 Sally Dailey Meadows Elementary School   Regular School No Elementary 02 05 2020 spring grade_4 63 94 14 1   0       0 7   91 88                       179 63 94 14 1   0       0 7   91 88                 179
325409 GA     school 1305340 793   Vidalia City 130534001737 5050 Sally Dailey Meadows Elementary School   Regular School No Elementary 02 05 2020 spring grade_5 54 104 18 0   1       0 6   93 90                       183 54 104 18 0   1       0 6   93 90                 183
325417 GA     school 1305340 793   Vidalia City 130534001737 5050 Sally Dailey Meadows Elementary School   Regular School No Elementary 02 05 2020 spring pk_12_total 237 378 58 1   1       0 35   355 355                       710 237 378 58 1   1       0 35   355 355                 710
418289 GA     school 1300570 615   Bryan County 130057002389 302 Richmond Hill Elementary School   Regular School No Elementary 02 03 2020 fall grade_2 222 64 37 0   15       0 25   173 190                       363 222 64 37 0   15       0 25   173 190                 363
418292 GA     school 1300570 615   Bryan County 130057002389 302 Richmond Hill Elementary School   Regular School No Elementary 02 03 2020 fall grade_3 220 63 57 2   15       1 14   188 184                       372 220 63 57 2   15       1 14   188 184                 372
418316 GA     school 1300570 615   Bryan County 130057002389 302 Richmond Hill Elementary School   Regular School No Elementary 02 03 2020 fall pk_12_total 442 127 94 2   30       1 39   361 374                       735 442 127 94 2   30       1 39   361 374                 735
418978 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 fall grade_2 0 0 0 0   1       0 0   0 1                       1 0 0 0 0   1       0 0   0 1                 1
419011 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 fall grade_3 30 67 24 0   2       0 13   81 55                       136 30 67 24 0   2       0 13   81 55                 136
419045 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 fall grade_4 30 88 26 1   0       0 6   68 83                       151 30 88 26 1   0       0 6   68 83                 151
419079 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 fall grade_5 27 111 33 2   0       0 16   100 89                       189 27 111 33 2   0       0 16   100 89                 189
419102 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 fall grade_6 27 89 23 0   0       0 8   94 53                       147 27 89 23 0   0       0 8   94 53                 147
419121 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 fall grade_7 24 86 13 0   0       0 12   80 55                       135 24 86 13 0   0       0 12   80 55                 135
419140 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Middle 02 08 2020 fall grade_8 16 82 11 1   1       0 5   61 55                       116 16 82 11 1   1       0 5   61 55                 116

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