ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 1939 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2197488 | 2197488 | 2022-02-09 | Taylor | Georgia | 13269 | 1939 | 49 |
2129115 | 2129115 | 2022-01-19 | Johnson | Georgia | 13167 | 1939 | 64 |
2103063 | 2103063 | 2022-01-11 | Dooly | Georgia | 13093 | 1939 | 62 |
1700153 | 1700153 | 2021-09-09 | Oglethorpe | Georgia | 13221 | 1939 | 35 |
1644836 | 1644836 | 2021-08-23 | Brooks | Georgia | 13027 | 1939 | 53 |
1622085 | 1622085 | 2021-08-16 | Bacon | Georgia | 13005 | 1939 | 42 |
1508441 | 1508441 | 2021-07-12 | Cook | Georgia | 13075 | 1939 | 43 |
1063736 | 1063736 | 2021-02-25 | Morgan | Georgia | 13211 | 1939 | 18 |
1050749 | 1050749 | 2021-02-21 | Mitchell | Georgia | 13205 | 1939 | 74 |
1015062 | 1015062 | 2021-02-10 | Pike | Georgia | 13231 | 1939 | 29 |
969638 | 969638 | 2021-01-27 | Tattnall | Georgia | 13267 | 1939 | 44 |
898182 | 898182 | 2021-01-05 | Haralson | Georgia | 13143 | 1939 | 39 |
852829 | 852829 | 2020-12-22 | Wayne | Georgia | 13305 | 1939 | 49 |
735865 | 735865 | 2020-11-16 | Chattahoochee | Georgia | 13053 | 1939 | 2 |
732619 | 732619 | 2020-11-15 | Chattahoochee | Georgia | 13053 | 1939 | 2 |
354358 | 354358 | 2020-07-21 | Troup | Georgia | 13285 | 1939 | 45 |
296968 | 296968 | 2020-07-03 | Dougherty | Georgia | 13095 | 1939 | 155 |
287491 | 287491 | 2020-06-30 | Clayton | Georgia | 13063 | 1939 | 79 |
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);