ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Clay" and fips = 5021 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
35696 | 35696 | 2020-04-06 | Clay | Arkansas | 5021 | 1 | 0 |
38185 | 38185 | 2020-04-07 | Clay | Arkansas | 5021 | 1 | 0 |
40728 | 40728 | 2020-04-08 | Clay | Arkansas | 5021 | 1 | 0 |
43300 | 43300 | 2020-04-09 | Clay | Arkansas | 5021 | 1 | 0 |
45899 | 45899 | 2020-04-10 | Clay | Arkansas | 5021 | 1 | 0 |
48529 | 48529 | 2020-04-11 | Clay | Arkansas | 5021 | 1 | 0 |
51191 | 51191 | 2020-04-12 | Clay | Arkansas | 5021 | 1 | 0 |
53869 | 53869 | 2020-04-13 | Clay | Arkansas | 5021 | 1 | 0 |
56561 | 56561 | 2020-04-14 | Clay | Arkansas | 5021 | 1 | 0 |
59269 | 59269 | 2020-04-15 | Clay | Arkansas | 5021 | 1 | 0 |
61988 | 61988 | 2020-04-16 | Clay | Arkansas | 5021 | 1 | 0 |
64721 | 64721 | 2020-04-17 | Clay | Arkansas | 5021 | 1 | 0 |
67469 | 67469 | 2020-04-18 | Clay | Arkansas | 5021 | 1 | 0 |
70231 | 70231 | 2020-04-19 | Clay | Arkansas | 5021 | 1 | 0 |
73000 | 73000 | 2020-04-20 | Clay | Arkansas | 5021 | 1 | 0 |
75776 | 75776 | 2020-04-21 | Clay | Arkansas | 5021 | 1 | 0 |
78560 | 78560 | 2020-04-22 | Clay | Arkansas | 5021 | 1 | 0 |
81353 | 81353 | 2020-04-23 | Clay | Arkansas | 5021 | 1 | 0 |
84153 | 84153 | 2020-04-24 | Clay | Arkansas | 5021 | 1 | 0 |
86961 | 86961 | 2020-04-25 | Clay | Arkansas | 5021 | 2 | 0 |
89778 | 89778 | 2020-04-26 | Clay | Arkansas | 5021 | 2 | 0 |
92596 | 92596 | 2020-04-27 | Clay | Arkansas | 5021 | 2 | 0 |
95426 | 95426 | 2020-04-28 | Clay | Arkansas | 5021 | 3 | 0 |
98271 | 98271 | 2020-04-29 | Clay | Arkansas | 5021 | 3 | 0 |
101121 | 101121 | 2020-04-30 | Clay | Arkansas | 5021 | 3 | 0 |
103976 | 103976 | 2020-05-01 | Clay | Arkansas | 5021 | 3 | 0 |
106841 | 106841 | 2020-05-02 | Clay | Arkansas | 5021 | 3 | 0 |
109710 | 109710 | 2020-05-03 | Clay | Arkansas | 5021 | 3 | 0 |
112585 | 112585 | 2020-05-04 | Clay | Arkansas | 5021 | 3 | 0 |
115468 | 115468 | 2020-05-05 | Clay | Arkansas | 5021 | 3 | 0 |
118427 | 118427 | 2020-05-06 | Clay | Arkansas | 5021 | 3 | 0 |
121394 | 121394 | 2020-05-07 | Clay | Arkansas | 5021 | 3 | 0 |
124374 | 124374 | 2020-05-08 | Clay | Arkansas | 5021 | 3 | 0 |
127359 | 127359 | 2020-05-09 | Clay | Arkansas | 5021 | 3 | 0 |
130349 | 130349 | 2020-05-10 | Clay | Arkansas | 5021 | 3 | 0 |
133339 | 133339 | 2020-05-11 | Clay | Arkansas | 5021 | 4 | 0 |
136329 | 136329 | 2020-05-12 | Clay | Arkansas | 5021 | 3 | 0 |
139320 | 139320 | 2020-05-13 | Clay | Arkansas | 5021 | 3 | 0 |
142316 | 142316 | 2020-05-14 | Clay | Arkansas | 5021 | 3 | 0 |
145315 | 145315 | 2020-05-15 | Clay | Arkansas | 5021 | 3 | 0 |
148318 | 148318 | 2020-05-16 | Clay | Arkansas | 5021 | 3 | 0 |
151327 | 151327 | 2020-05-17 | Clay | Arkansas | 5021 | 3 | 0 |
154339 | 154339 | 2020-05-18 | Clay | Arkansas | 5021 | 4 | 0 |
157355 | 157355 | 2020-05-19 | Clay | Arkansas | 5021 | 4 | 0 |
160381 | 160381 | 2020-05-20 | Clay | Arkansas | 5021 | 4 | 0 |
163409 | 163409 | 2020-05-21 | Clay | Arkansas | 5021 | 4 | 0 |
166441 | 166441 | 2020-05-22 | Clay | Arkansas | 5021 | 4 | 0 |
169477 | 169477 | 2020-05-23 | Clay | Arkansas | 5021 | 4 | 0 |
172518 | 172518 | 2020-05-24 | Clay | Arkansas | 5021 | 4 | 0 |
175562 | 175562 | 2020-05-25 | Clay | Arkansas | 5021 | 4 | 0 |
178606 | 178606 | 2020-05-26 | Clay | Arkansas | 5021 | 4 | 0 |
181650 | 181650 | 2020-05-27 | Clay | Arkansas | 5021 | 4 | 0 |
184704 | 184704 | 2020-05-28 | Clay | Arkansas | 5021 | 4 | 0 |
187760 | 187760 | 2020-05-29 | Clay | Arkansas | 5021 | 4 | 0 |
190825 | 190825 | 2020-05-30 | Clay | Arkansas | 5021 | 4 | 0 |
193892 | 193892 | 2020-05-31 | Clay | Arkansas | 5021 | 4 | 0 |
196962 | 196962 | 2020-06-01 | Clay | Arkansas | 5021 | 4 | 0 |
200035 | 200035 | 2020-06-02 | Clay | Arkansas | 5021 | 5 | 0 |
203111 | 203111 | 2020-06-03 | Clay | Arkansas | 5021 | 5 | 0 |
206191 | 206191 | 2020-06-04 | Clay | Arkansas | 5021 | 5 | 0 |
209272 | 209272 | 2020-06-05 | Clay | Arkansas | 5021 | 5 | 0 |
212357 | 212357 | 2020-06-06 | Clay | Arkansas | 5021 | 6 | 0 |
215444 | 215444 | 2020-06-07 | Clay | Arkansas | 5021 | 6 | 0 |
218535 | 218535 | 2020-06-08 | Clay | Arkansas | 5021 | 6 | 0 |
221630 | 221630 | 2020-06-09 | Clay | Arkansas | 5021 | 7 | 0 |
224725 | 224725 | 2020-06-10 | Clay | Arkansas | 5021 | 8 | 0 |
227827 | 227827 | 2020-06-11 | Clay | Arkansas | 5021 | 9 | 0 |
230930 | 230930 | 2020-06-12 | Clay | Arkansas | 5021 | 9 | 0 |
234036 | 234036 | 2020-06-13 | Clay | Arkansas | 5021 | 18 | 0 |
237143 | 237143 | 2020-06-14 | Clay | Arkansas | 5021 | 20 | 0 |
240251 | 240251 | 2020-06-15 | Clay | Arkansas | 5021 | 20 | 0 |
243362 | 243362 | 2020-06-16 | Clay | Arkansas | 5021 | 22 | 0 |
246475 | 246475 | 2020-06-17 | Clay | Arkansas | 5021 | 23 | 0 |
249587 | 249587 | 2020-06-18 | Clay | Arkansas | 5021 | 24 | 0 |
252702 | 252702 | 2020-06-19 | Clay | Arkansas | 5021 | 31 | 0 |
255821 | 255821 | 2020-06-20 | Clay | Arkansas | 5021 | 33 | 1 |
258948 | 258948 | 2020-06-21 | Clay | Arkansas | 5021 | 40 | 2 |
262075 | 262075 | 2020-06-22 | Clay | Arkansas | 5021 | 46 | 2 |
265203 | 265203 | 2020-06-23 | Clay | Arkansas | 5021 | 48 | 3 |
268333 | 268333 | 2020-06-24 | Clay | Arkansas | 5021 | 49 | 3 |
271468 | 271468 | 2020-06-25 | Clay | Arkansas | 5021 | 49 | 3 |
274608 | 274608 | 2020-06-26 | Clay | Arkansas | 5021 | 52 | 3 |
277756 | 277756 | 2020-06-27 | Clay | Arkansas | 5021 | 52 | 3 |
280903 | 280903 | 2020-06-28 | Clay | Arkansas | 5021 | 54 | 3 |
284049 | 284049 | 2020-06-29 | Clay | Arkansas | 5021 | 54 | 3 |
287195 | 287195 | 2020-06-30 | Clay | Arkansas | 5021 | 54 | 3 |
290346 | 290346 | 2020-07-01 | Clay | Arkansas | 5021 | 59 | 3 |
293500 | 293500 | 2020-07-02 | Clay | Arkansas | 5021 | 62 | 3 |
296656 | 296656 | 2020-07-03 | Clay | Arkansas | 5021 | 64 | 3 |
299818 | 299818 | 2020-07-04 | Clay | Arkansas | 5021 | 65 | 3 |
302982 | 302982 | 2020-07-05 | Clay | Arkansas | 5021 | 66 | 3 |
306146 | 306146 | 2020-07-06 | Clay | Arkansas | 5021 | 70 | 3 |
309314 | 309314 | 2020-07-07 | Clay | Arkansas | 5021 | 71 | 3 |
312484 | 312484 | 2020-07-08 | Clay | Arkansas | 5021 | 73 | 3 |
315659 | 315659 | 2020-07-09 | Clay | Arkansas | 5021 | 77 | 3 |
318832 | 318832 | 2020-07-10 | Clay | Arkansas | 5021 | 78 | 3 |
322011 | 322011 | 2020-07-11 | Clay | Arkansas | 5021 | 80 | 3 |
325192 | 325192 | 2020-07-12 | Clay | Arkansas | 5021 | 81 | 3 |
328378 | 328378 | 2020-07-13 | Clay | Arkansas | 5021 | 82 | 3 |
331564 | 331564 | 2020-07-14 | Clay | Arkansas | 5021 | 84 | 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);