ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,569 rows where county = "Clayton" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2408 | 2408 | 2020-03-15 | Clayton | Georgia | 13063 | 2 | 0 |
2845 | 2845 | 2020-03-16 | Clayton | Georgia | 13063 | 5 | 0 |
3330 | 3330 | 2020-03-17 | Clayton | Georgia | 13063 | 5 | 0 |
3890 | 3890 | 2020-03-18 | Clayton | Georgia | 13063 | 6 | 0 |
4560 | 4560 | 2020-03-19 | Clayton | Georgia | 13063 | 6 | 0 |
5342 | 5342 | 2020-03-20 | Clayton | Georgia | 13063 | 10 | 0 |
6275 | 6275 | 2020-03-21 | Clayton | Georgia | 13063 | 12 | 0 |
12854 | 12854 | 2020-03-26 | Clayton | Iowa | 19043 | 1 | 0 |
14542 | 14542 | 2020-03-27 | Clayton | Iowa | 19043 | 1 | 0 |
16346 | 16346 | 2020-03-28 | Clayton | Iowa | 19043 | 1 | 0 |
18251 | 18251 | 2020-03-29 | Clayton | Iowa | 19043 | 1 | 0 |
20258 | 20258 | 2020-03-30 | Clayton | Iowa | 19043 | 1 | 0 |
22354 | 22354 | 2020-03-31 | Clayton | Iowa | 19043 | 1 | 0 |
24526 | 24526 | 2020-04-01 | Clayton | Iowa | 19043 | 2 | 0 |
26767 | 26767 | 2020-04-02 | Clayton | Iowa | 19043 | 2 | 0 |
29078 | 29078 | 2020-04-03 | Clayton | Iowa | 19043 | 3 | 0 |
31446 | 31446 | 2020-04-04 | Clayton | Iowa | 19043 | 3 | 0 |
33858 | 33858 | 2020-04-05 | Clayton | Iowa | 19043 | 4 | 0 |
36312 | 36312 | 2020-04-06 | Clayton | Iowa | 19043 | 4 | 0 |
38811 | 38811 | 2020-04-07 | Clayton | Iowa | 19043 | 5 | 0 |
41357 | 41357 | 2020-04-08 | Clayton | Iowa | 19043 | 5 | 0 |
43933 | 43933 | 2020-04-09 | Clayton | Iowa | 19043 | 5 | 0 |
46538 | 46538 | 2020-04-10 | Clayton | Iowa | 19043 | 6 | 0 |
49172 | 49172 | 2020-04-11 | Clayton | Iowa | 19043 | 7 | 0 |
51836 | 51836 | 2020-04-12 | Clayton | Iowa | 19043 | 7 | 0 |
54518 | 54518 | 2020-04-13 | Clayton | Iowa | 19043 | 7 | 0 |
57211 | 57211 | 2020-04-14 | Clayton | Iowa | 19043 | 7 | 0 |
7319 | 7319 | 2020-03-22 | Clayton | Georgia | 13063 | 13 | 1 |
8467 | 8467 | 2020-03-23 | Clayton | Georgia | 13063 | 19 | 1 |
9716 | 9716 | 2020-03-24 | Clayton | Georgia | 13063 | 21 | 1 |
11091 | 11091 | 2020-03-25 | Clayton | Georgia | 13063 | 29 | 1 |
12640 | 12640 | 2020-03-26 | Clayton | Georgia | 13063 | 37 | 1 |
14312 | 14312 | 2020-03-27 | Clayton | Georgia | 13063 | 53 | 1 |
16098 | 16098 | 2020-03-28 | Clayton | Georgia | 13063 | 57 | 1 |
17995 | 17995 | 2020-03-29 | Clayton | Georgia | 13063 | 59 | 1 |
59919 | 59919 | 2020-04-15 | Clayton | Iowa | 19043 | 7 | 1 |
62640 | 62640 | 2020-04-16 | Clayton | Iowa | 19043 | 7 | 1 |
65374 | 65374 | 2020-04-17 | Clayton | Iowa | 19043 | 7 | 1 |
68123 | 68123 | 2020-04-18 | Clayton | Iowa | 19043 | 7 | 1 |
70885 | 70885 | 2020-04-19 | Clayton | Iowa | 19043 | 7 | 1 |
73656 | 73656 | 2020-04-20 | Clayton | Iowa | 19043 | 7 | 1 |
76434 | 76434 | 2020-04-21 | Clayton | Iowa | 19043 | 8 | 1 |
79218 | 79218 | 2020-04-22 | Clayton | Iowa | 19043 | 8 | 1 |
82011 | 82011 | 2020-04-23 | Clayton | Iowa | 19043 | 8 | 1 |
84811 | 84811 | 2020-04-24 | Clayton | Iowa | 19043 | 9 | 1 |
87621 | 87621 | 2020-04-25 | Clayton | Iowa | 19043 | 11 | 1 |
90437 | 90437 | 2020-04-26 | Clayton | Iowa | 19043 | 12 | 1 |
93256 | 93256 | 2020-04-27 | Clayton | Iowa | 19043 | 13 | 1 |
96088 | 96088 | 2020-04-28 | Clayton | Iowa | 19043 | 12 | 1 |
98932 | 98932 | 2020-04-29 | Clayton | Iowa | 19043 | 12 | 1 |
101783 | 101783 | 2020-04-30 | Clayton | Iowa | 19043 | 14 | 1 |
104640 | 104640 | 2020-05-01 | Clayton | Iowa | 19043 | 17 | 1 |
107505 | 107505 | 2020-05-02 | Clayton | Iowa | 19043 | 18 | 1 |
110375 | 110375 | 2020-05-03 | Clayton | Iowa | 19043 | 15 | 1 |
113250 | 113250 | 2020-05-04 | Clayton | Iowa | 19043 | 17 | 1 |
116133 | 116133 | 2020-05-05 | Clayton | Iowa | 19043 | 18 | 1 |
19981 | 19981 | 2020-03-30 | Clayton | Georgia | 13063 | 62 | 2 |
119093 | 119093 | 2020-05-06 | Clayton | Iowa | 19043 | 18 | 2 |
122063 | 122063 | 2020-05-07 | Clayton | Iowa | 19043 | 19 | 2 |
125043 | 125043 | 2020-05-08 | Clayton | Iowa | 19043 | 21 | 2 |
128030 | 128030 | 2020-05-09 | Clayton | Iowa | 19043 | 22 | 2 |
131021 | 131021 | 2020-05-10 | Clayton | Iowa | 19043 | 23 | 2 |
134011 | 134011 | 2020-05-11 | Clayton | Iowa | 19043 | 23 | 2 |
22060 | 22060 | 2020-03-31 | Clayton | Georgia | 13063 | 112 | 3 |
137000 | 137000 | 2020-05-12 | Clayton | Iowa | 19043 | 28 | 3 |
139992 | 139992 | 2020-05-13 | Clayton | Iowa | 19043 | 28 | 3 |
142988 | 142988 | 2020-05-14 | Clayton | Iowa | 19043 | 28 | 3 |
145988 | 145988 | 2020-05-15 | Clayton | Iowa | 19043 | 28 | 3 |
148992 | 148992 | 2020-05-16 | Clayton | Iowa | 19043 | 28 | 3 |
152002 | 152002 | 2020-05-17 | Clayton | Iowa | 19043 | 28 | 3 |
155014 | 155014 | 2020-05-18 | Clayton | Iowa | 19043 | 30 | 3 |
158030 | 158030 | 2020-05-19 | Clayton | Iowa | 19043 | 30 | 3 |
161056 | 161056 | 2020-05-20 | Clayton | Iowa | 19043 | 30 | 3 |
164084 | 164084 | 2020-05-21 | Clayton | Iowa | 19043 | 30 | 3 |
167117 | 167117 | 2020-05-22 | Clayton | Iowa | 19043 | 30 | 3 |
170154 | 170154 | 2020-05-23 | Clayton | Iowa | 19043 | 30 | 3 |
173195 | 173195 | 2020-05-24 | Clayton | Iowa | 19043 | 30 | 3 |
176239 | 176239 | 2020-05-25 | Clayton | Iowa | 19043 | 30 | 3 |
179283 | 179283 | 2020-05-26 | Clayton | Iowa | 19043 | 31 | 3 |
182327 | 182327 | 2020-05-27 | Clayton | Iowa | 19043 | 31 | 3 |
185381 | 185381 | 2020-05-28 | Clayton | Iowa | 19043 | 32 | 3 |
188439 | 188439 | 2020-05-29 | Clayton | Iowa | 19043 | 33 | 3 |
191504 | 191504 | 2020-05-30 | Clayton | Iowa | 19043 | 34 | 3 |
194571 | 194571 | 2020-05-31 | Clayton | Iowa | 19043 | 35 | 3 |
197641 | 197641 | 2020-06-01 | Clayton | Iowa | 19043 | 34 | 3 |
200714 | 200714 | 2020-06-02 | Clayton | Iowa | 19043 | 34 | 3 |
203790 | 203790 | 2020-06-03 | Clayton | Iowa | 19043 | 34 | 3 |
206870 | 206870 | 2020-06-04 | Clayton | Iowa | 19043 | 34 | 3 |
209951 | 209951 | 2020-06-05 | Clayton | Iowa | 19043 | 34 | 3 |
213036 | 213036 | 2020-06-06 | Clayton | Iowa | 19043 | 34 | 3 |
216123 | 216123 | 2020-06-07 | Clayton | Iowa | 19043 | 34 | 3 |
219215 | 219215 | 2020-06-08 | Clayton | Iowa | 19043 | 34 | 3 |
222310 | 222310 | 2020-06-09 | Clayton | Iowa | 19043 | 34 | 3 |
225405 | 225405 | 2020-06-10 | Clayton | Iowa | 19043 | 34 | 3 |
228507 | 228507 | 2020-06-11 | Clayton | Iowa | 19043 | 35 | 3 |
231610 | 231610 | 2020-06-12 | Clayton | Iowa | 19043 | 35 | 3 |
234716 | 234716 | 2020-06-13 | Clayton | Iowa | 19043 | 35 | 3 |
237823 | 237823 | 2020-06-14 | Clayton | Iowa | 19043 | 35 | 3 |
240931 | 240931 | 2020-06-15 | Clayton | Iowa | 19043 | 35 | 3 |
244042 | 244042 | 2020-06-16 | Clayton | Iowa | 19043 | 35 | 3 |
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);