ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Clay" and fips = 13061 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
date (date) >30 ✖
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- …
state 1
- Georgia 775
fips 1
- 13061 · 775 ✖
county 1
- Clay · 775 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19980 | 19980 | 2020-03-30 | Clay | Georgia | 13061 | 1 | 0 |
22059 | 22059 | 2020-03-31 | Clay | Georgia | 13061 | 5 | 0 |
24222 | 24222 | 2020-04-01 | Clay | Georgia | 13061 | 5 | 0 |
26453 | 26453 | 2020-04-02 | Clay | Georgia | 13061 | 7 | 0 |
28756 | 28756 | 2020-04-03 | Clay | Georgia | 13061 | 7 | 0 |
31116 | 31116 | 2020-04-04 | Clay | Georgia | 13061 | 7 | 0 |
33522 | 33522 | 2020-04-05 | Clay | Georgia | 13061 | 7 | 0 |
35970 | 35970 | 2020-04-06 | Clay | Georgia | 13061 | 7 | 1 |
38462 | 38462 | 2020-04-07 | Clay | Georgia | 13061 | 12 | 1 |
41006 | 41006 | 2020-04-08 | Clay | Georgia | 13061 | 13 | 1 |
43580 | 43580 | 2020-04-09 | Clay | Georgia | 13061 | 15 | 1 |
46182 | 46182 | 2020-04-10 | Clay | Georgia | 13061 | 15 | 1 |
48812 | 48812 | 2020-04-11 | Clay | Georgia | 13061 | 15 | 1 |
51473 | 51473 | 2020-04-12 | Clay | Georgia | 13061 | 16 | 1 |
54153 | 54153 | 2020-04-13 | Clay | Georgia | 13061 | 16 | 1 |
56845 | 56845 | 2020-04-14 | Clay | Georgia | 13061 | 16 | 1 |
59552 | 59552 | 2020-04-15 | Clay | Georgia | 13061 | 17 | 2 |
62272 | 62272 | 2020-04-16 | Clay | Georgia | 13061 | 19 | 2 |
65005 | 65005 | 2020-04-17 | Clay | Georgia | 13061 | 19 | 2 |
67753 | 67753 | 2020-04-18 | Clay | Georgia | 13061 | 20 | 2 |
70515 | 70515 | 2020-04-19 | Clay | Georgia | 13061 | 20 | 2 |
73284 | 73284 | 2020-04-20 | Clay | Georgia | 13061 | 20 | 2 |
76060 | 76060 | 2020-04-21 | Clay | Georgia | 13061 | 20 | 2 |
78844 | 78844 | 2020-04-22 | Clay | Georgia | 13061 | 20 | 2 |
81637 | 81637 | 2020-04-23 | Clay | Georgia | 13061 | 20 | 2 |
84437 | 84437 | 2020-04-24 | Clay | Georgia | 13061 | 20 | 2 |
87246 | 87246 | 2020-04-25 | Clay | Georgia | 13061 | 20 | 2 |
90062 | 90062 | 2020-04-26 | Clay | Georgia | 13061 | 20 | 2 |
92881 | 92881 | 2020-04-27 | Clay | Georgia | 13061 | 20 | 2 |
95713 | 95713 | 2020-04-28 | Clay | Georgia | 13061 | 21 | 2 |
98558 | 98558 | 2020-04-29 | Clay | Georgia | 13061 | 21 | 2 |
101408 | 101408 | 2020-04-30 | Clay | Georgia | 13061 | 22 | 3 |
104263 | 104263 | 2020-05-01 | Clay | Georgia | 13061 | 23 | 3 |
107128 | 107128 | 2020-05-02 | Clay | Georgia | 13061 | 25 | 3 |
109997 | 109997 | 2020-05-03 | Clay | Georgia | 13061 | 25 | 3 |
112872 | 112872 | 2020-05-04 | Clay | Georgia | 13061 | 25 | 3 |
115755 | 115755 | 2020-05-05 | Clay | Georgia | 13061 | 25 | 3 |
118715 | 118715 | 2020-05-06 | Clay | Georgia | 13061 | 27 | 3 |
121684 | 121684 | 2020-05-07 | Clay | Georgia | 13061 | 27 | 3 |
124663 | 124663 | 2020-05-08 | Clay | Georgia | 13061 | 27 | 3 |
127650 | 127650 | 2020-05-09 | Clay | Georgia | 13061 | 27 | 3 |
130641 | 130641 | 2020-05-10 | Clay | Georgia | 13061 | 27 | 3 |
133632 | 133632 | 2020-05-11 | Clay | Georgia | 13061 | 27 | 3 |
136621 | 136621 | 2020-05-12 | Clay | Georgia | 13061 | 26 | 3 |
139612 | 139612 | 2020-05-13 | Clay | Georgia | 13061 | 26 | 3 |
142608 | 142608 | 2020-05-14 | Clay | Georgia | 13061 | 28 | 3 |
145608 | 145608 | 2020-05-15 | Clay | Georgia | 13061 | 28 | 3 |
148611 | 148611 | 2020-05-16 | Clay | Georgia | 13061 | 29 | 3 |
151620 | 151620 | 2020-05-17 | Clay | Georgia | 13061 | 30 | 3 |
154632 | 154632 | 2020-05-18 | Clay | Georgia | 13061 | 30 | 3 |
157648 | 157648 | 2020-05-19 | Clay | Georgia | 13061 | 30 | 3 |
160674 | 160674 | 2020-05-20 | Clay | Georgia | 13061 | 30 | 2 |
163702 | 163702 | 2020-05-21 | Clay | Georgia | 13061 | 32 | 2 |
166735 | 166735 | 2020-05-22 | Clay | Georgia | 13061 | 34 | 2 |
169772 | 169772 | 2020-05-23 | Clay | Georgia | 13061 | 35 | 2 |
172813 | 172813 | 2020-05-24 | Clay | Georgia | 13061 | 35 | 2 |
175856 | 175856 | 2020-05-25 | Clay | Georgia | 13061 | 35 | 2 |
178900 | 178900 | 2020-05-26 | Clay | Georgia | 13061 | 35 | 2 |
181944 | 181944 | 2020-05-27 | Clay | Georgia | 13061 | 37 | 2 |
184998 | 184998 | 2020-05-28 | Clay | Georgia | 13061 | 37 | 2 |
188054 | 188054 | 2020-05-29 | Clay | Georgia | 13061 | 39 | 2 |
191119 | 191119 | 2020-05-30 | Clay | Georgia | 13061 | 39 | 2 |
194186 | 194186 | 2020-05-31 | Clay | Georgia | 13061 | 39 | 2 |
197256 | 197256 | 2020-06-01 | Clay | Georgia | 13061 | 39 | 2 |
200329 | 200329 | 2020-06-02 | Clay | Georgia | 13061 | 39 | 2 |
203405 | 203405 | 2020-06-03 | Clay | Georgia | 13061 | 41 | 2 |
206485 | 206485 | 2020-06-04 | Clay | Georgia | 13061 | 42 | 2 |
209566 | 209566 | 2020-06-05 | Clay | Georgia | 13061 | 44 | 2 |
212651 | 212651 | 2020-06-06 | Clay | Georgia | 13061 | 43 | 2 |
215738 | 215738 | 2020-06-07 | Clay | Georgia | 13061 | 47 | 2 |
218829 | 218829 | 2020-06-08 | Clay | Georgia | 13061 | 49 | 2 |
221924 | 221924 | 2020-06-09 | Clay | Georgia | 13061 | 49 | 2 |
225019 | 225019 | 2020-06-10 | Clay | Georgia | 13061 | 50 | 2 |
228121 | 228121 | 2020-06-11 | Clay | Georgia | 13061 | 51 | 2 |
231224 | 231224 | 2020-06-12 | Clay | Georgia | 13061 | 51 | 2 |
234330 | 234330 | 2020-06-13 | Clay | Georgia | 13061 | 52 | 2 |
237437 | 237437 | 2020-06-14 | Clay | Georgia | 13061 | 52 | 2 |
240545 | 240545 | 2020-06-15 | Clay | Georgia | 13061 | 52 | 2 |
243656 | 243656 | 2020-06-16 | Clay | Georgia | 13061 | 53 | 2 |
246769 | 246769 | 2020-06-17 | Clay | Georgia | 13061 | 53 | 2 |
249881 | 249881 | 2020-06-18 | Clay | Georgia | 13061 | 55 | 2 |
252996 | 252996 | 2020-06-19 | Clay | Georgia | 13061 | 56 | 2 |
256115 | 256115 | 2020-06-20 | Clay | Georgia | 13061 | 56 | 2 |
259242 | 259242 | 2020-06-21 | Clay | Georgia | 13061 | 56 | 2 |
262369 | 262369 | 2020-06-22 | Clay | Georgia | 13061 | 56 | 2 |
265497 | 265497 | 2020-06-23 | Clay | Georgia | 13061 | 56 | 2 |
268627 | 268627 | 2020-06-24 | Clay | Georgia | 13061 | 56 | 2 |
271763 | 271763 | 2020-06-25 | Clay | Georgia | 13061 | 56 | 2 |
274903 | 274903 | 2020-06-26 | Clay | Georgia | 13061 | 56 | 2 |
278051 | 278051 | 2020-06-27 | Clay | Georgia | 13061 | 57 | 2 |
281198 | 281198 | 2020-06-28 | Clay | Georgia | 13061 | 57 | 2 |
284344 | 284344 | 2020-06-29 | Clay | Georgia | 13061 | 57 | 2 |
287490 | 287490 | 2020-06-30 | Clay | Georgia | 13061 | 57 | 2 |
290641 | 290641 | 2020-07-01 | Clay | Georgia | 13061 | 57 | 2 |
293795 | 293795 | 2020-07-02 | Clay | Georgia | 13061 | 56 | 2 |
296951 | 296951 | 2020-07-03 | Clay | Georgia | 13061 | 56 | 2 |
300113 | 300113 | 2020-07-04 | Clay | Georgia | 13061 | 56 | 2 |
303277 | 303277 | 2020-07-05 | Clay | Georgia | 13061 | 56 | 2 |
306441 | 306441 | 2020-07-06 | Clay | Georgia | 13061 | 56 | 2 |
309609 | 309609 | 2020-07-07 | Clay | Georgia | 13061 | 56 | 2 |
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);