Data source: Big Local News · About: Big Local

1,206 rows where grade = "grade_7", state = "GA" and year = 2019 sorted by black_int

View and edit SQL

year

  • 2019 · 1,206

grade

  • grade_7 · 1,206
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
1263237 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 03 12 2019 fall grade_7 2 0 0 0   1       0 0   2 1                       3 2 0 0 0   1       0 0   2 1                 3
1263239 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2019 fall grade_7 48 0 1 0   0       0 1   26 24                       50 48 0 1 0   0       0 1   26 24                 50
1263892 GA     school 1301230 631   Clayton County 130123004279 378 Eula Wilburn Ponds Perry Center for Learning   Regular School No High 07 12 2019 fall grade_7 0 0 1 0   0       0 0   1 0                       1 0 0 1 0   0       0 0   1 0                 1
1265435 GA     school 1301590 641   Dade County 130159000777 295 Dade Middle School   Regular School No Middle 06 08 2019 fall grade_7 165 0 3 1   1       0 4   79 95                       174 165 0 3 1   1       0 4   79 95                 174
1266485 GA     school 1301800 646   Dooly County 130180004286 205 Dooly County Prep Academy   Regular School No High 07 12 2019 fall grade_7 0 0 1 0   0       0 0   1 0                       1 0 0 1 0   0       0 0   1 0                 1
1267079 GA     school 1302100 655   Fannin County 130210000067 193 Fannin County Middle School   Regular School No Middle 06 08 2019 fall grade_7 227 0 8 0   1       0 5   122 119                       241 227 0 8 0   1       0 5   122 119                 241
1267486 GA     school 1302220 658   Forsyth County 130222003995 219 Forsyth Virtual Academy   Regular School No High 06 12 2019 fall grade_7 8 0 0 0   0       0 0   1 7                       8 8 0 0 0   0       0 0   1 7                 8
1268044 GA     school 1302280 660   Fulton County 130228003651 307 Georgia Baptist Children's Home and Family Ministries   Regular School No Other 04 12 2019 fall grade_7 1 0 0 0   0       0 0   0 1                       1 1 0 0 0   0       0 0   0 1                 1
1268353 GA     school 1302340 661   Gilmer County 130234003371 107 Clear Creek Middle School   Regular School No Middle 07 08 2019 fall grade_7 230 0 78 0   4       0 3   156 159                       315 230 0 78 0   4       0 3   156 159                 315
1269209 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other PK 12 2019 fall grade_7 0 0 2 0   0       0 0   0 2                       2 0 0 2 0   0       0 0   0 2                 2
1269633 GA     school 1302580 668   Habersham County 130258004144 114 Habersham Success Academy   Regular School No High 07 12 2019 fall grade_7 2 0 0 0   0       0 0   2 0                       2 2 0 0 0   0       0 0   2 0                 2
1271508 GA     school 1303840 705   Murray County 130384002086 204 Bagley Middle School   Regular School No Middle 07 08 2019 fall grade_7 225 0 73 1   0       0 1   156 144                       300 225 0 73 1   0       0 1   156 144                 300
1271510 GA     school 1303840 705   Murray County 130384003574 108 Pleasant Valley Innovative School   Regular School No High 07 12 2019 fall grade_7 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
1272834 GA     school 1304380 721   Richmond County 130438003486 107 Lighthouse Care Center of Augusta   Regular School No Secondary 06 11 2019 fall grade_7 1 0 0 0   0       0 0   0 1                       1 1 0 0 0   0       0 0   0 1                 1
1273825 GA     school 1305250 744   Union County 130525003456 108 Union County Middle School   Regular School No Middle 06 08 2019 fall grade_7 209 0 11 0   2       0 5   127 100                       227 209 0 11 0   2       0 5   127 100                 227
1273826 GA     school 1305250 744   Union County 130525001721 3050 Woody Gap High/Elementary School   Regular School No Other KG 12 2019 fall grade_7 11 0 0 0   0       0 0   3 8                       11 11 0 0 0   0       0 0   3 8                 11
1274360 GA     school 1305700 755   Whitfield County 130570001822 575 North Whitfield Middle School   Regular School No Middle 06 08 2019 fall grade_7 174 0 84 0   3       0 14   144 131                       275 174 0 84 0   3       0 14   144 131                 275
1274482 GA     school 1305850 759   Worth County 130585004231 197 Worth County Achievement Center   Regular School No High 06 12 2019 fall grade_7 2 0 0 0   0       0 0   1 1                       2 2 0 0 0   0       0 0   1 1                 2
1275212 GA     school 1301140 769   Chickamauga City 130114002456 111 Gordon Lee Middle School   Regular School No Middle 06 08 2019 fall grade_7 96 0 4 0   1       0 2   48 55                       103 96 0 4 0   1       0 2   48 55                 103
1276033 GA     school 1300026 891   Department of Juvenile Justice 130002603511 2798 Bob Richards Regional Youth Detention Center   Alternative School No Middle 07 09 2019 fall grade_7 2 0 0 0   0       0 0   2 0                       2 2 0 0 0   0       0 0   2 0                 2
1276034 GA     school 1300026 891   Department of Juvenile Justice 130002603501 1798 Claxton Regional Youth Detention Center   Alternative School No Secondary 07 11 2019 fall grade_7 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
1276042 GA     school 1300026 891   Department of Juvenile Justice 130002603515 3198 Waycross Regional Youth Detention Center   Alternative School No Middle 06 10 2019 fall grade_7 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
2557217 GA     school 1301020 625   Savannah-Chatham County 130102003610 107 UHS of Savannah Coastal Harbor Treatment Center   Regular School No Other 02 12 2019 spring grade_7 4 0 1 0   0       0 0   3 2                       5 4 0 1 0   0       0 0   3 2                 5
2557421 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 03 12 2019 spring grade_7 5 0 0 0   1       0 0   4 2                       6 5 0 0 0   1       0 0   4 2                 6
2557423 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2019 spring grade_7 46 0 1 0   0       0 1   25 23                       48 46 0 1 0   0       0 1   25 23                 48
2559616 GA     school 1301590 641   Dade County 130159000777 295 Dade Middle School   Regular School No Middle 06 08 2019 spring grade_7 166 0 3 1   1       0 4   79 96                       175 166 0 3 1   1       0 4   79 96                 175
2560661 GA     school 1301800 646   Dooly County 130180004286 205 Dooly County Prep Academy   Regular School No High 07 12 2019 spring grade_7 0 0 1 0   0       0 0   1 0                       1 0 0 1 0   0       0 0   1 0                 1
2561257 GA     school 1302100 655   Fannin County 130210000067 193 Fannin County Middle School   Regular School No Middle 06 08 2019 spring grade_7 222 0 9 0   1       0 4   118 118                       236 222 0 9 0   1       0 4   118 118                 236
2561663 GA     school 1302220 658   Forsyth County 130222003995 219 Forsyth Virtual Academy   Regular School No High 06 12 2019 spring grade_7 7 0 0 0   0       0 0   2 5                       7 7 0 0 0   0       0 0   2 5                 7
2563388 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other PK 12 2019 spring grade_7 0 0 2 0   0       0 0   0 2                       2 0 0 2 0   0       0 0   0 2                 2
2563813 GA     school 1302580 668   Habersham County 130258004144 114 Habersham Success Academy   Regular School No High 07 12 2019 spring grade_7 2 0 2 0   0       0 0   4 0                       4 2 0 2 0   0       0 0   4 0                 4
2565699 GA     school 1303840 705   Murray County 130384002086 204 Bagley Middle School   Regular School No Middle 07 08 2019 spring grade_7 222 0 71 1   0       0 1   152 143                       295 222 0 71 1   0       0 1   152 143                 295
2565701 GA     school 1303840 705   Murray County 130384003574 108 Pleasant Valley Innovative School   Regular School No High 07 12 2019 spring grade_7 5 0 0 0   0       0 0   5 0                       5 5 0 0 0   0       0 0   5 0                 5
2567620 GA     school 1304800 733   Taylor County 130480003673 107 Georgia Center   Regular School No High 07 12 2019 spring grade_7 2 0 1 0   0       0 0   1 2                       3 2 0 1 0   0       0 0   1 2                 3
2568010 GA     school 1305250 744   Union County 130525003456 108 Union County Middle School   Regular School No Middle 06 08 2019 spring grade_7 208 0 11 0   2       0 4   123 102                       225 208 0 11 0   2       0 4   123 102                 225
2568011 GA     school 1305250 744   Union County 130525001721 3050 Woody Gap High/Elementary School   Regular School No Other KG 12 2019 spring grade_7 10 0 0 0   0       0 0   3 7                       10 10 0 0 0   0       0 0   3 7                 10
2568545 GA     school 1305700 755   Whitfield County 130570001822 575 North Whitfield Middle School   Regular School No Middle 06 08 2019 spring grade_7 178 0 87 0   3       0 12   147 133                       280 178 0 87 0   3       0 12   147 133                 280
2569396 GA     school 1301140 769   Chickamauga City 130114002456 111 Gordon Lee Middle School   Regular School No Middle 06 08 2019 spring grade_7 95 0 3 0   1       0 1   48 52                       100 95 0 3 0   1       0 1   48 52                 100
2570215 GA     school 1300026 891   Department of Juvenile Justice 130002603511 2798 Bob Richards Regional Youth Detention Center   Alternative School No Middle 07 09 2019 spring grade_7 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
2570218 GA     school 1300026 891   Department of Juvenile Justice 130002603504 2098 DeKalb Regional Youth Detention Center   Alternative School No Secondary 07 11 2019 spring grade_7 0 0 0 0   0       1 0   1 0                       1 0 0 0 0   0       1 0   1 0                 1
2570228 GA     school 1300026 891   Department of Juvenile Justice 130002603515 3198 Waycross Regional Youth Detention Center   Alternative School No Middle 06 10 2019 spring grade_7 2 0 0 0   0       0 0   2 0                       2 2 0 0 0   0       0 0   2 0                 2
1263238 GA     school 1301080 627   Chattooga County 130108000417 2050 Lyerly Elementary School   Regular School No Elementary PK 08 2019 fall grade_7 37 1 0 0   0       0 2   20 20                       40 37 1 0 0   0       0 2   20 20                 40
1265470 GA     school 1301650 642   Dawson County 130165001952 106 Dawson County Middle School   Regular School No Middle 06 07 2019 fall grade_7 236 1 28 2   2       0 7   156 120                       276 236 1 28 2   2       0 7   156 120                 276
1265512 GA     school 1301710 643   Decatur County 130171004170 116 New Beginning Learning Center   Regular School No High 07 12 2019 fall grade_7 1 1 0 0   0       0 0   1 1                       2 1 1 0 0   0       0 0   1 1                 2
1266459 GA     school 1301770 645   Dodge County 130177004186 292 DAC (Dodge County Achievement Center)   Regular School No High 07 12 2019 fall grade_7 2 1 0 0   0       0 0   1 2                       3 2 1 0 0   0       0 0   1 2                 3
1269635 GA     school 1302580 668   Habersham County 130258001147 196 North Habersham Middle School   Regular School No Middle 06 08 2019 fall grade_7 167 1 22 0   0       0 4   106 88                       194 167 1 22 0   0       0 4   106 88                 194
1269636 GA     school 1302580 668   Habersham County 130258001154 296 South Habersham Middle School   Regular School No Middle 06 08 2019 fall grade_7 68 1 69 0   5       0 2   73 72                       145 68 1 69 0   5       0 2   73 72                 145
1269811 GA     school 1302610 669   Hall County 130261002045 389 North Hall Middle School   Regular School No Middle 06 08 2019 fall grade_7 236 1 46 0   1       0 9   157 136                       293 236 1 46 0   1       0 9   157 136                 293
1269813 GA     school 1302610 669   Hall County 130261004305 392 The Foundry   Regular School No High 07 12 2019 fall grade_7 1 1 7 0   0       0 1   8 2                       10 1 1 7 0   0       0 1   8 2                 10
1269946 GA     school 1302670 671   Haralson County 130267004310 198 Haralson County Rebel Academy   Regular School No High 07 12 2019 fall grade_7 1 1 0 0   0       0 0   0 2                       2 1 1 0 0   0       0 0   0 2                 2
1272377 GA     school 1304110 712   Pickens County 130411002048 189 Pickens County Junior High School   Regular School No Middle 07 08 2019 fall grade_7 323 1 14 0   1       0 7   170 176                       346 323 1 14 0   1       0 7   170 176                 346
1272491 GA     school 1304200 715   Polk County 130420003614 207 Harpst Academy   Regular School No High 06 12 2019 fall grade_7 4 1 0 0   0       0 0   2 3                       5 4 1 0 0   0       0 0   2 3                 5
1273621 GA     school 1305070 739   Towns County 130507002998 104 Towns County Middle School   Regular School No Middle 06 08 2019 fall grade_7 76 1 3 0   2       0 0   47 35                       82 76 1 3 0   2       0 0   47 35                 82
1273715 GA     school 1300001 741   Troup County 130000103620 207 Ault Academy   Regular School No Secondary 05 11 2019 fall grade_7 2 1 1 0   0       0 0   4 0                       4 2 1 1 0   0       0 0   4 0                 4
1273779 GA     school 1305190 742   Turner County 130519001714 1050 Turner County Specialty School   Alternative School No Middle 06 11 2019 fall grade_7 0 1 0 0   0       0 1   2 0                       2 0 1 0 0   0       0 1   2 0                 2
1274358 GA     school 1305700 755   Whitfield County 130570001816 475 Eastbrook Middle School   Regular School No Middle 06 08 2019 fall grade_7 53 1 155 2   0       0 8   103 116                       219 53 1 155 2   0       0 8   103 116                 219
1274361 GA     school 1305700 755   Whitfield County 130570001821 675 Valley Point Middle School   Regular School No Middle 06 08 2019 fall grade_7 70 1 74 2   1       1 6   82 73                       155 70 1 74 2   1       1 6   82 73                 155
1275905 GA     school 1305130 791   Trion City 130513002466 201 Trion Middle School   Regular School No Middle 06 08 2019 fall grade_7 81 1 21 0   0       0 4   55 52                       107 81 1 21 0   0       0 4   55 52                 107
1276032 GA     school 1300026 891   Department of Juvenile Justice 130002603488 298 Augusta Youth Development Campus   Alternative School No High 07 12 2019 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1276036 GA     school 1300026 891   Department of Juvenile Justice 130002603504 2098 DeKalb Regional Youth Detention Center   Alternative School No Secondary 07 11 2019 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1276039 GA     school 1300026 891   Department of Juvenile Justice 130002603500 1698 Martha K. Glaze Regional Youth Detention Center   Alternative School No Secondary 07 11 2019 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1276041 GA     school 1300026 891   Department of Juvenile Justice 130002604269 4203 Terrell Regional Youth Detention Center   Special Education School No Middle 06 10 2019 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2556175 GA     school 1300420 611   Bibb County 130042003621 307 Price Academy   Regular School No Middle 03 08 2019 spring grade_7 4 1 0 0   0       0 1   6 0                       6 4 1 0 0   0       0 1   6 0                 6
2557422 GA     school 1301080 627   Chattooga County 130108000417 2050 Lyerly Elementary School   Regular School No Elementary PK 08 2019 spring grade_7 38 1 0 0   0       0 2   22 19                       41 38 1 0 0   0       0 2   22 19                 41
2559651 GA     school 1301650 642   Dawson County 130165001952 106 Dawson County Middle School   Regular School No Middle 06 07 2019 spring grade_7 238 1 28 2   2       0 9   157 123                       280 238 1 28 2   2       0 9   157 123                 280
2560249 GA     school 1301740 644   DeKalb County 130174002642 503 East DeKalb Special Education Center   Special Education School No Other PK 12 2019 spring grade_7 0 1 0 0   0       0 0   0 1                       1 0 1 0 0   0       0 0   0 1                 1
2560269 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Regular School No Other 01 12 2019 spring grade_7 1 1 0 0   0       0 0   1 1                       2 1 1 0 0   0       0 0   1 1                 2
2562221 GA     school 1302280 660   Fulton County 130228003651 307 Georgia Baptist Children's Home and Family Ministries   Regular School No Other 04 12 2019 spring grade_7 0 1 0 0   0       0 0   0 1                       1 0 1 0 0   0       0 0   0 1                 1
2562239 GA     school 1302280 660   Fulton County 130228004261 1321 Wellspring Living   Regular School No Secondary 08 11 2019 spring grade_7 0 1 0 0   0       0 0   0 1                       1 0 1 0 0   0       0 0   0 1                 1
2562532 GA     school 1302340 661   Gilmer County 130234003371 107 Clear Creek Middle School   Regular School No Middle 07 08 2019 spring grade_7 238 1 82 0   4       0 3   161 167                       328 238 1 82 0   4       0 3   161 167                 328
2563815 GA     school 1302580 668   Habersham County 130258001147 196 North Habersham Middle School   Regular School No Middle 06 08 2019 spring grade_7 168 1 22 0   0       0 4   107 88                       195 168 1 22 0   0       0 4   107 88                 195
2563816 GA     school 1302580 668   Habersham County 130258001154 296 South Habersham Middle School   Regular School No Middle 06 08 2019 spring grade_7 70 1 68 0   5       0 2   76 70                       146 70 1 68 0   5       0 2   76 70                 146
2563992 GA     school 1302610 669   Hall County 130261002045 389 North Hall Middle School   Regular School No Middle 06 08 2019 spring grade_7 229 1 44 0   1       0 8   148 135                       283 229 1 44 0   1       0 8   148 135                 283
2564128 GA     school 1302670 671   Haralson County 130267004310 198 Haralson County Rebel Academy   Regular School No High 07 12 2019 spring grade_7 4 1 0 0   0       0 1   4 2                       6 4 1 0 0   0       0 1   4 2                 6
2565504 GA     school 1303630 699   Meriwether County 130363003633 207 Good Sheperd Therapeutic Center   Regular School No Secondary 08 10 2019 spring grade_7 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
2566567 GA     school 1304110 712   Pickens County 130411002048 189 Pickens County Junior High School   Regular School No Middle 07 08 2019 spring grade_7 327 1 18 0   1       0 6   174 179                       353 327 1 18 0   1       0 6   174 179                 353
2566681 GA     school 1304200 715   Polk County 130420003614 207 Harpst Academy   Regular School No High 06 12 2019 spring grade_7 3 1 0 0   0       0 0   3 1                       4 3 1 0 0   0       0 0   3 1                 4
2567811 GA     school 1305070 739   Towns County 130507002998 104 Towns County Middle School   Regular School No Middle 06 08 2019 spring grade_7 77 1 4 0   2       0 1   48 37                       85 77 1 4 0   2       0 1   48 37                 85
2568543 GA     school 1305700 755   Whitfield County 130570001816 475 Eastbrook Middle School   Regular School No Middle 06 08 2019 spring grade_7 51 1 159 2   0       0 8   103 118                       221 51 1 159 2   0       0 8   103 118                 221
2568546 GA     school 1305700 755   Whitfield County 130570001821 675 Valley Point Middle School   Regular School No Middle 06 08 2019 spring grade_7 69 1 75 2   1       1 6   83 72                       155 69 1 75 2   1       1 6   83 72                 155
2568667 GA     school 1305850 759   Worth County 130585004231 197 Worth County Achievement Center   Regular School No High 06 12 2019 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2570088 GA     school 1305130 791   Trion City 130513002466 201 Trion Middle School   Regular School No Middle 06 08 2019 spring grade_7 80 1 21 0   0       0 4   54 52                       106 80 1 21 0   0       0 4   54 52                 106
2570213 GA     school 1300026 891   Department of Juvenile Justice 130002604089 104 Atlanta Youth Detention Center   Special Education School No Secondary 08 11 2019 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2570214 GA     school 1300026 891   Department of Juvenile Justice 130002603488 298 Augusta Youth Development Campus   Alternative School No High 07 12 2019 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2570216 GA     school 1300026 891   Department of Juvenile Justice 130002603501 1798 Claxton Regional Youth Detention Center   Alternative School No Secondary 07 11 2019 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2570217 GA     school 1300026 891   Department of Juvenile Justice 130002603487 205 Crisp RYDC   Alternative School No Secondary 07 10 2019 spring grade_7 1 1 1 1   0       0 0   4 0                       4 1 1 1 1   0       0 0   4 0                 4
2570219 GA     school 1300026 891   Department of Juvenile Justice 130002603506 2298 Gainesville Regional Youth Detention Center   Alternative School No Secondary 09 11 2019 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2570221 GA     school 1300026 891   Department of Juvenile Justice 130002603510 2698 Marietta Regional Youth Detention Center   Alternative School No Secondary 08 11 2019 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2570222 GA     school 1300026 891   Department of Juvenile Justice 130002603500 1698 Martha K. Glaze Regional Youth Detention Center   Alternative School No Secondary 07 11 2019 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2570223 GA     school 1300026 891   Department of Juvenile Justice 130002603517 4198 Metro Regional Youth Detention Center   Alternative School No Secondary 07 11 2019 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2570226 GA     school 1300026 891   Department of Juvenile Justice 130002603518 5001 Sumter Youth Development Campus   Alternative School No High 09 12 2019 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
2570227 GA     school 1300026 891   Department of Juvenile Justice 130002604269 4203 Terrell Regional Youth Detention Center   Special Education School No Middle 06 10 2019 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1262600 GA     school 1300840 622   Carroll County 130084003483 112 KidsPeace   Regular School No High 07 12 2019 fall grade_7 0 2 0 0   0       0 0   2 0                       2 0 2 0 0   0       0 0   2 0                 2
1263033 GA     school 1301020 625   Savannah-Chatham County 130102003610 107 UHS of Savannah Coastal Harbor Treatment Center   Regular School No Other 02 12 2019 fall grade_7 1 2 0 0   0       0 0   0 3                       3 1 2 0 0   0       0 0   0 3                 3
1266081 GA     school 1301740 644   DeKalb County 130174003868 510 Margaret Harris Comprehensive School   Regular School No Other PK 12 2019 fall grade_7 1 2 0 0   1       0 0   3 1                       4 1 2 0 0   1       0 0   3 1                 4
1266781 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Regular School No Other 02 12 2019 fall grade_7 2 2 0 0   0       0 0   3 1                       4 2 2 0 0   0       0 0   3 1                 4
1266889 GA     school 1301950 650   Echols County 130195003976 112 Echols County Elementary/Middle School   Regular School No Elementary PK 08 2019 fall grade_7 24 2 22 2   0       0 3   27 26                       53 24 2 22 2   0       0 3   27 26                 53
1267489 GA     school 1302220 658   Forsyth County 130222003355 206 Little Mill Middle School   Regular School No Middle 06 08 2019 fall grade_7 235 2 64 1   1       0 9   167 145                       312 235 2 64 1   1       0 9   167 145                 312
1268593 GA     school 1302460 665   Grady County 130246001079 3050 Shiver Elementary School   Regular School No Elementary PK 08 2019 fall grade_7 63 2 8 0   0       0 3   31 45                       76 63 2 8 0   0       0 3   31 45                 76

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