ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clayton" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
78845 | 78845 | 2020-04-22 | Clayton | Georgia | 13063 | 549 | 21 |
76061 | 76061 | 2020-04-21 | Clayton | Georgia | 13063 | 547 | 21 |
73285 | 73285 | 2020-04-20 | Clayton | Georgia | 13063 | 540 | 20 |
70516 | 70516 | 2020-04-19 | Clayton | Georgia | 13063 | 520 | 17 |
67754 | 67754 | 2020-04-18 | Clayton | Georgia | 13063 | 505 | 17 |
65006 | 65006 | 2020-04-17 | Clayton | Georgia | 13063 | 499 | 16 |
62273 | 62273 | 2020-04-16 | Clayton | Georgia | 13063 | 473 | 13 |
59553 | 59553 | 2020-04-15 | Clayton | Georgia | 13063 | 462 | 13 |
56846 | 56846 | 2020-04-14 | Clayton | Georgia | 13063 | 435 | 12 |
54154 | 54154 | 2020-04-13 | Clayton | Georgia | 13063 | 396 | 12 |
51474 | 51474 | 2020-04-12 | Clayton | Georgia | 13063 | 372 | 11 |
48813 | 48813 | 2020-04-11 | Clayton | Georgia | 13063 | 339 | 11 |
46183 | 46183 | 2020-04-10 | Clayton | Georgia | 13063 | 328 | 11 |
43581 | 43581 | 2020-04-09 | Clayton | Georgia | 13063 | 298 | 11 |
41007 | 41007 | 2020-04-08 | Clayton | Georgia | 13063 | 289 | 10 |
38463 | 38463 | 2020-04-07 | Clayton | Georgia | 13063 | 278 | 10 |
35971 | 35971 | 2020-04-06 | Clayton | Georgia | 13063 | 254 | 9 |
33523 | 33523 | 2020-04-05 | Clayton | Georgia | 13063 | 238 | 9 |
31117 | 31117 | 2020-04-04 | Clayton | Georgia | 13063 | 235 | 9 |
28757 | 28757 | 2020-04-03 | Clayton | Georgia | 13063 | 206 | 8 |
26454 | 26454 | 2020-04-02 | Clayton | Georgia | 13063 | 165 | 6 |
24223 | 24223 | 2020-04-01 | Clayton | Georgia | 13063 | 128 | 5 |
22060 | 22060 | 2020-03-31 | Clayton | Georgia | 13063 | 112 | 3 |
19981 | 19981 | 2020-03-30 | Clayton | Georgia | 13063 | 62 | 2 |
17995 | 17995 | 2020-03-29 | Clayton | Georgia | 13063 | 59 | 1 |
16098 | 16098 | 2020-03-28 | Clayton | Georgia | 13063 | 57 | 1 |
14312 | 14312 | 2020-03-27 | Clayton | Georgia | 13063 | 53 | 1 |
12640 | 12640 | 2020-03-26 | Clayton | Georgia | 13063 | 37 | 1 |
11091 | 11091 | 2020-03-25 | Clayton | Georgia | 13063 | 29 | 1 |
9716 | 9716 | 2020-03-24 | Clayton | Georgia | 13063 | 21 | 1 |
8467 | 8467 | 2020-03-23 | Clayton | Georgia | 13063 | 19 | 1 |
7319 | 7319 | 2020-03-22 | Clayton | Georgia | 13063 | 13 | 1 |
6275 | 6275 | 2020-03-21 | Clayton | Georgia | 13063 | 12 | 0 |
5342 | 5342 | 2020-03-20 | Clayton | Georgia | 13063 | 10 | 0 |
4560 | 4560 | 2020-03-19 | Clayton | Georgia | 13063 | 6 | 0 |
3890 | 3890 | 2020-03-18 | Clayton | Georgia | 13063 | 6 | 0 |
3330 | 3330 | 2020-03-17 | Clayton | Georgia | 13063 | 5 | 0 |
2845 | 2845 | 2020-03-16 | Clayton | Georgia | 13063 | 5 | 0 |
2408 | 2408 | 2020-03-15 | Clayton | Georgia | 13063 | 2 | 0 |
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);