ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where county = "Clay" and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- 2020-05-02 1
- 2020-05-03 1
- 2020-05-04 1
- 2020-05-05 1
- 2020-05-06 1
- 2020-05-07 1
- 2020-05-08 1
- 2020-05-09 1
- 2020-05-10 1
- 2020-05-11 1
- 2020-05-12 1
- 2020-05-13 1
- 2020-05-14 1
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- …
state 1
- Kentucky · 755 ✖
fips 1
- 21051 755
county 1
- Clay · 755 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
71040 | 71040 | 2020-04-19 | Clay | Kentucky | 21051 | 1 | 0 |
73812 | 73812 | 2020-04-20 | Clay | Kentucky | 21051 | 1 | 0 |
76592 | 76592 | 2020-04-21 | Clay | Kentucky | 21051 | 1 | 0 |
79377 | 79377 | 2020-04-22 | Clay | Kentucky | 21051 | 1 | 0 |
82174 | 82174 | 2020-04-23 | Clay | Kentucky | 21051 | 1 | 0 |
84977 | 84977 | 2020-04-24 | Clay | Kentucky | 21051 | 1 | 0 |
87786 | 87786 | 2020-04-25 | Clay | Kentucky | 21051 | 1 | 0 |
90602 | 90602 | 2020-04-26 | Clay | Kentucky | 21051 | 1 | 0 |
93423 | 93423 | 2020-04-27 | Clay | Kentucky | 21051 | 1 | 0 |
96256 | 96256 | 2020-04-28 | Clay | Kentucky | 21051 | 1 | 0 |
99102 | 99102 | 2020-04-29 | Clay | Kentucky | 21051 | 1 | 0 |
101954 | 101954 | 2020-04-30 | Clay | Kentucky | 21051 | 1 | 0 |
104815 | 104815 | 2020-05-01 | Clay | Kentucky | 21051 | 1 | 0 |
107680 | 107680 | 2020-05-02 | Clay | Kentucky | 21051 | 1 | 0 |
110551 | 110551 | 2020-05-03 | Clay | Kentucky | 21051 | 1 | 0 |
113428 | 113428 | 2020-05-04 | Clay | Kentucky | 21051 | 1 | 0 |
116310 | 116310 | 2020-05-05 | Clay | Kentucky | 21051 | 1 | 0 |
119271 | 119271 | 2020-05-06 | Clay | Kentucky | 21051 | 1 | 0 |
122241 | 122241 | 2020-05-07 | Clay | Kentucky | 21051 | 1 | 0 |
125223 | 125223 | 2020-05-08 | Clay | Kentucky | 21051 | 2 | 0 |
128211 | 128211 | 2020-05-09 | Clay | Kentucky | 21051 | 2 | 0 |
131201 | 131201 | 2020-05-10 | Clay | Kentucky | 21051 | 2 | 0 |
134192 | 134192 | 2020-05-11 | Clay | Kentucky | 21051 | 2 | 0 |
137182 | 137182 | 2020-05-12 | Clay | Kentucky | 21051 | 2 | 0 |
140175 | 140175 | 2020-05-13 | Clay | Kentucky | 21051 | 2 | 0 |
143171 | 143171 | 2020-05-14 | Clay | Kentucky | 21051 | 2 | 0 |
146171 | 146171 | 2020-05-15 | Clay | Kentucky | 21051 | 2 | 0 |
149175 | 149175 | 2020-05-16 | Clay | Kentucky | 21051 | 2 | 0 |
152186 | 152186 | 2020-05-17 | Clay | Kentucky | 21051 | 2 | 0 |
155200 | 155200 | 2020-05-18 | Clay | Kentucky | 21051 | 2 | 0 |
158217 | 158217 | 2020-05-19 | Clay | Kentucky | 21051 | 3 | 0 |
161242 | 161242 | 2020-05-20 | Clay | Kentucky | 21051 | 3 | 0 |
164271 | 164271 | 2020-05-21 | Clay | Kentucky | 21051 | 3 | 0 |
167307 | 167307 | 2020-05-22 | Clay | Kentucky | 21051 | 3 | 0 |
170345 | 170345 | 2020-05-23 | Clay | Kentucky | 21051 | 4 | 0 |
173386 | 173386 | 2020-05-24 | Clay | Kentucky | 21051 | 4 | 0 |
176430 | 176430 | 2020-05-25 | Clay | Kentucky | 21051 | 4 | 0 |
179474 | 179474 | 2020-05-26 | Clay | Kentucky | 21051 | 7 | 0 |
182519 | 182519 | 2020-05-27 | Clay | Kentucky | 21051 | 7 | 0 |
185573 | 185573 | 2020-05-28 | Clay | Kentucky | 21051 | 7 | 0 |
188631 | 188631 | 2020-05-29 | Clay | Kentucky | 21051 | 7 | 0 |
191695 | 191695 | 2020-05-30 | Clay | Kentucky | 21051 | 7 | 0 |
194763 | 194763 | 2020-05-31 | Clay | Kentucky | 21051 | 7 | 0 |
197834 | 197834 | 2020-06-01 | Clay | Kentucky | 21051 | 7 | 0 |
200905 | 200905 | 2020-06-02 | Clay | Kentucky | 21051 | 7 | 1 |
203982 | 203982 | 2020-06-03 | Clay | Kentucky | 21051 | 7 | 1 |
207063 | 207063 | 2020-06-04 | Clay | Kentucky | 21051 | 7 | 1 |
210144 | 210144 | 2020-06-05 | Clay | Kentucky | 21051 | 8 | 1 |
213229 | 213229 | 2020-06-06 | Clay | Kentucky | 21051 | 8 | 2 |
216316 | 216316 | 2020-06-07 | Clay | Kentucky | 21051 | 8 | 2 |
219408 | 219408 | 2020-06-08 | Clay | Kentucky | 21051 | 10 | 2 |
222503 | 222503 | 2020-06-09 | Clay | Kentucky | 21051 | 10 | 2 |
225599 | 225599 | 2020-06-10 | Clay | Kentucky | 21051 | 12 | 2 |
228701 | 228701 | 2020-06-11 | Clay | Kentucky | 21051 | 12 | 2 |
231805 | 231805 | 2020-06-12 | Clay | Kentucky | 21051 | 12 | 2 |
234910 | 234910 | 2020-06-13 | Clay | Kentucky | 21051 | 13 | 2 |
238017 | 238017 | 2020-06-14 | Clay | Kentucky | 21051 | 13 | 2 |
241126 | 241126 | 2020-06-15 | Clay | Kentucky | 21051 | 17 | 2 |
244237 | 244237 | 2020-06-16 | Clay | Kentucky | 21051 | 17 | 2 |
247350 | 247350 | 2020-06-17 | Clay | Kentucky | 21051 | 23 | 3 |
250462 | 250462 | 2020-06-18 | Clay | Kentucky | 21051 | 27 | 3 |
253577 | 253577 | 2020-06-19 | Clay | Kentucky | 21051 | 30 | 3 |
256697 | 256697 | 2020-06-20 | Clay | Kentucky | 21051 | 31 | 3 |
259823 | 259823 | 2020-06-21 | Clay | Kentucky | 21051 | 32 | 3 |
262952 | 262952 | 2020-06-22 | Clay | Kentucky | 21051 | 32 | 3 |
266079 | 266079 | 2020-06-23 | Clay | Kentucky | 21051 | 37 | 3 |
269212 | 269212 | 2020-06-24 | Clay | Kentucky | 21051 | 39 | 3 |
272348 | 272348 | 2020-06-25 | Clay | Kentucky | 21051 | 44 | 3 |
275491 | 275491 | 2020-06-26 | Clay | Kentucky | 21051 | 46 | 3 |
278639 | 278639 | 2020-06-27 | Clay | Kentucky | 21051 | 53 | 3 |
281787 | 281787 | 2020-06-28 | Clay | Kentucky | 21051 | 53 | 3 |
284933 | 284933 | 2020-06-29 | Clay | Kentucky | 21051 | 53 | 3 |
288082 | 288082 | 2020-06-30 | Clay | Kentucky | 21051 | 59 | 3 |
291232 | 291232 | 2020-07-01 | Clay | Kentucky | 21051 | 62 | 3 |
294386 | 294386 | 2020-07-02 | Clay | Kentucky | 21051 | 64 | 3 |
297544 | 297544 | 2020-07-03 | Clay | Kentucky | 21051 | 68 | 3 |
300706 | 300706 | 2020-07-04 | Clay | Kentucky | 21051 | 68 | 3 |
303870 | 303870 | 2020-07-05 | Clay | Kentucky | 21051 | 68 | 3 |
307037 | 307037 | 2020-07-06 | Clay | Kentucky | 21051 | 72 | 3 |
310205 | 310205 | 2020-07-07 | Clay | Kentucky | 21051 | 76 | 3 |
313375 | 313375 | 2020-07-08 | Clay | Kentucky | 21051 | 79 | 3 |
316549 | 316549 | 2020-07-09 | Clay | Kentucky | 21051 | 80 | 3 |
319724 | 319724 | 2020-07-10 | Clay | Kentucky | 21051 | 81 | 4 |
322903 | 322903 | 2020-07-11 | Clay | Kentucky | 21051 | 82 | 4 |
326086 | 326086 | 2020-07-12 | Clay | Kentucky | 21051 | 82 | 4 |
329272 | 329272 | 2020-07-13 | Clay | Kentucky | 21051 | 85 | 4 |
332459 | 332459 | 2020-07-14 | Clay | Kentucky | 21051 | 88 | 4 |
335652 | 335652 | 2020-07-15 | Clay | Kentucky | 21051 | 97 | 4 |
338848 | 338848 | 2020-07-16 | Clay | Kentucky | 21051 | 98 | 4 |
342044 | 342044 | 2020-07-17 | Clay | Kentucky | 21051 | 105 | 4 |
345244 | 345244 | 2020-07-18 | Clay | Kentucky | 21051 | 111 | 4 |
348445 | 348445 | 2020-07-19 | Clay | Kentucky | 21051 | 114 | 4 |
351645 | 351645 | 2020-07-20 | Clay | Kentucky | 21051 | 115 | 4 |
354847 | 354847 | 2020-07-21 | Clay | Kentucky | 21051 | 119 | 4 |
358050 | 358050 | 2020-07-22 | Clay | Kentucky | 21051 | 121 | 4 |
361255 | 361255 | 2020-07-23 | Clay | Kentucky | 21051 | 126 | 4 |
364462 | 364462 | 2020-07-24 | Clay | Kentucky | 21051 | 131 | 4 |
367669 | 367669 | 2020-07-25 | Clay | Kentucky | 21051 | 132 | 4 |
370879 | 370879 | 2020-07-26 | Clay | Kentucky | 21051 | 134 | 4 |
374091 | 374091 | 2020-07-27 | Clay | Kentucky | 21051 | 134 | 4 |
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);