ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
12 rows where cases = 3076 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
state 1
- Georgia · 12 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399150 | 2399150 | 2022-04-12 | Telfair | Georgia | 13271 | 3076 | 84 |
2395785 | 2395785 | 2022-04-11 | Charlton | Georgia | 13049 | 3076 | 63 |
2395895 | 2395895 | 2022-04-11 | Telfair | Georgia | 13271 | 3076 | 83 |
2382873 | 2382873 | 2022-04-07 | Telfair | Georgia | 13271 | 3076 | 83 |
1765057 | 1765057 | 2021-09-29 | Crisp | Georgia | 13081 | 3076 | 105 |
1670814 | 1670814 | 2021-08-31 | Berrien | Georgia | 13019 | 3076 | 53 |
1531227 | 1531227 | 2021-07-19 | Lumpkin | Georgia | 13187 | 3076 | 82 |
1414418 | 1414418 | 2021-06-13 | Unknown | Georgia | 3076 | 5 | |
1200122 | 1200122 | 2021-04-08 | Stephens | Georgia | 13257 | 3076 | 78 |
885232 | 885232 | 2021-01-01 | Murray | Georgia | 13213 | 3076 | 42 |
810605 | 810605 | 2020-12-09 | Rockdale | Georgia | 13247 | 3076 | 63 |
534858 | 534858 | 2020-09-15 | Dougherty | Georgia | 13095 | 3076 | 182 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);