ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Union" and state = "Kentucky" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
12944 | 12944 | 2020-03-26 | Union | Kentucky | 21225 | 1 | 0 |
14650 | 14650 | 2020-03-27 | Union | Kentucky | 21225 | 1 | 0 |
16467 | 16467 | 2020-03-28 | Union | Kentucky | 21225 | 1 | 0 |
18379 | 18379 | 2020-03-29 | Union | Kentucky | 21225 | 1 | 0 |
20395 | 20395 | 2020-03-30 | Union | Kentucky | 21225 | 1 | 0 |
22503 | 22503 | 2020-03-31 | Union | Kentucky | 21225 | 2 | 0 |
24679 | 24679 | 2020-04-01 | Union | Kentucky | 21225 | 2 | 0 |
26929 | 26929 | 2020-04-02 | Union | Kentucky | 21225 | 2 | 0 |
29245 | 29245 | 2020-04-03 | Union | Kentucky | 21225 | 2 | 0 |
31623 | 31623 | 2020-04-04 | Union | Kentucky | 21225 | 2 | 0 |
44140 | 44140 | 2020-04-09 | Union | Kentucky | 21225 | 3 | 0 |
46749 | 46749 | 2020-04-10 | Union | Kentucky | 21225 | 3 | 0 |
34048 | 34048 | 2020-04-05 | Union | Kentucky | 21225 | 4 | 0 |
36506 | 36506 | 2020-04-06 | Union | Kentucky | 21225 | 4 | 0 |
39014 | 39014 | 2020-04-07 | Union | Kentucky | 21225 | 4 | 0 |
41564 | 41564 | 2020-04-08 | Union | Kentucky | 21225 | 4 | 0 |
49390 | 49390 | 2020-04-11 | Union | Kentucky | 21225 | 5 | 0 |
52059 | 52059 | 2020-04-12 | Union | Kentucky | 21225 | 5 | 0 |
54740 | 54740 | 2020-04-13 | Union | Kentucky | 21225 | 5 | 0 |
57438 | 57438 | 2020-04-14 | Union | Kentucky | 21225 | 5 | 0 |
60147 | 60147 | 2020-04-15 | Union | Kentucky | 21225 | 5 | 0 |
62867 | 62867 | 2020-04-16 | Union | Kentucky | 21225 | 6 | 0 |
65606 | 65606 | 2020-04-17 | Union | Kentucky | 21225 | 6 | 0 |
68355 | 68355 | 2020-04-18 | Union | Kentucky | 21225 | 8 | 0 |
71118 | 71118 | 2020-04-19 | Union | Kentucky | 21225 | 8 | 0 |
73890 | 73890 | 2020-04-20 | Union | Kentucky | 21225 | 8 | 0 |
76671 | 76671 | 2020-04-21 | Union | Kentucky | 21225 | 8 | 0 |
79456 | 79456 | 2020-04-22 | Union | Kentucky | 21225 | 8 | 0 |
82253 | 82253 | 2020-04-23 | Union | Kentucky | 21225 | 8 | 0 |
85056 | 85056 | 2020-04-24 | Union | Kentucky | 21225 | 8 | 0 |
87865 | 87865 | 2020-04-25 | Union | Kentucky | 21225 | 8 | 0 |
90681 | 90681 | 2020-04-26 | Union | Kentucky | 21225 | 8 | 0 |
93502 | 93502 | 2020-04-27 | Union | Kentucky | 21225 | 8 | 0 |
96337 | 96337 | 2020-04-28 | Union | Kentucky | 21225 | 8 | 0 |
99183 | 99183 | 2020-04-29 | Union | Kentucky | 21225 | 8 | 0 |
102035 | 102035 | 2020-04-30 | Union | Kentucky | 21225 | 8 | 0 |
104896 | 104896 | 2020-05-01 | Union | Kentucky | 21225 | 8 | 0 |
107761 | 107761 | 2020-05-02 | Union | Kentucky | 21225 | 8 | 0 |
110632 | 110632 | 2020-05-03 | Union | Kentucky | 21225 | 8 | 0 |
113509 | 113509 | 2020-05-04 | Union | Kentucky | 21225 | 8 | 0 |
116391 | 116391 | 2020-05-05 | Union | Kentucky | 21225 | 9 | 0 |
119352 | 119352 | 2020-05-06 | Union | Kentucky | 21225 | 10 | 0 |
122323 | 122323 | 2020-05-07 | Union | Kentucky | 21225 | 10 | 0 |
125305 | 125305 | 2020-05-08 | Union | Kentucky | 21225 | 10 | 0 |
128293 | 128293 | 2020-05-09 | Union | Kentucky | 21225 | 10 | 0 |
131283 | 131283 | 2020-05-10 | Union | Kentucky | 21225 | 10 | 0 |
134274 | 134274 | 2020-05-11 | Union | Kentucky | 21225 | 10 | 0 |
137264 | 137264 | 2020-05-12 | Union | Kentucky | 21225 | 10 | 0 |
140257 | 140257 | 2020-05-13 | Union | Kentucky | 21225 | 10 | 0 |
143253 | 143253 | 2020-05-14 | Union | Kentucky | 21225 | 10 | 0 |
146253 | 146253 | 2020-05-15 | Union | Kentucky | 21225 | 10 | 0 |
149258 | 149258 | 2020-05-16 | Union | Kentucky | 21225 | 10 | 0 |
152269 | 152269 | 2020-05-17 | Union | Kentucky | 21225 | 10 | 0 |
155283 | 155283 | 2020-05-18 | Union | Kentucky | 21225 | 10 | 0 |
158300 | 158300 | 2020-05-19 | Union | Kentucky | 21225 | 10 | 0 |
161326 | 161326 | 2020-05-20 | Union | Kentucky | 21225 | 10 | 0 |
164355 | 164355 | 2020-05-21 | Union | Kentucky | 21225 | 10 | 0 |
167391 | 167391 | 2020-05-22 | Union | Kentucky | 21225 | 10 | 0 |
170429 | 170429 | 2020-05-23 | Union | Kentucky | 21225 | 10 | 0 |
173470 | 173470 | 2020-05-24 | Union | Kentucky | 21225 | 10 | 0 |
176514 | 176514 | 2020-05-25 | Union | Kentucky | 21225 | 10 | 0 |
179558 | 179558 | 2020-05-26 | Union | Kentucky | 21225 | 10 | 0 |
182603 | 182603 | 2020-05-27 | Union | Kentucky | 21225 | 10 | 0 |
185658 | 185658 | 2020-05-28 | Union | Kentucky | 21225 | 10 | 0 |
188716 | 188716 | 2020-05-29 | Union | Kentucky | 21225 | 11 | 0 |
191780 | 191780 | 2020-05-30 | Union | Kentucky | 21225 | 11 | 0 |
194848 | 194848 | 2020-05-31 | Union | Kentucky | 21225 | 11 | 0 |
197919 | 197919 | 2020-06-01 | Union | Kentucky | 21225 | 13 | 0 |
200991 | 200991 | 2020-06-02 | Union | Kentucky | 21225 | 15 | 0 |
204068 | 204068 | 2020-06-03 | Union | Kentucky | 21225 | 15 | 0 |
207149 | 207149 | 2020-06-04 | Union | Kentucky | 21225 | 15 | 0 |
210230 | 210230 | 2020-06-05 | Union | Kentucky | 21225 | 15 | 0 |
213315 | 213315 | 2020-06-06 | Union | Kentucky | 21225 | 15 | 0 |
216402 | 216402 | 2020-06-07 | Union | Kentucky | 21225 | 15 | 0 |
219494 | 219494 | 2020-06-08 | Union | Kentucky | 21225 | 15 | 0 |
222589 | 222589 | 2020-06-09 | Union | Kentucky | 21225 | 15 | 0 |
225685 | 225685 | 2020-06-10 | Union | Kentucky | 21225 | 15 | 0 |
228787 | 228787 | 2020-06-11 | Union | Kentucky | 21225 | 15 | 0 |
231891 | 231891 | 2020-06-12 | Union | Kentucky | 21225 | 16 | 0 |
234996 | 234996 | 2020-06-13 | Union | Kentucky | 21225 | 17 | 0 |
238103 | 238103 | 2020-06-14 | Union | Kentucky | 21225 | 17 | 0 |
241212 | 241212 | 2020-06-15 | Union | Kentucky | 21225 | 19 | 0 |
244323 | 244323 | 2020-06-16 | Union | Kentucky | 21225 | 19 | 0 |
247436 | 247436 | 2020-06-17 | Union | Kentucky | 21225 | 20 | 0 |
250548 | 250548 | 2020-06-18 | Union | Kentucky | 21225 | 22 | 0 |
253663 | 253663 | 2020-06-19 | Union | Kentucky | 21225 | 24 | 0 |
256783 | 256783 | 2020-06-20 | Union | Kentucky | 21225 | 25 | 0 |
259909 | 259909 | 2020-06-21 | Union | Kentucky | 21225 | 25 | 0 |
263038 | 263038 | 2020-06-22 | Union | Kentucky | 21225 | 25 | 0 |
266165 | 266165 | 2020-06-23 | Union | Kentucky | 21225 | 25 | 0 |
269298 | 269298 | 2020-06-24 | Union | Kentucky | 21225 | 25 | 0 |
272434 | 272434 | 2020-06-25 | Union | Kentucky | 21225 | 26 | 0 |
275577 | 275577 | 2020-06-26 | Union | Kentucky | 21225 | 28 | 0 |
278725 | 278725 | 2020-06-27 | Union | Kentucky | 21225 | 29 | 0 |
281873 | 281873 | 2020-06-28 | Union | Kentucky | 21225 | 29 | 0 |
285019 | 285019 | 2020-06-29 | Union | Kentucky | 21225 | 29 | 0 |
288168 | 288168 | 2020-06-30 | Union | Kentucky | 21225 | 29 | 0 |
291319 | 291319 | 2020-07-01 | Union | Kentucky | 21225 | 29 | 0 |
294473 | 294473 | 2020-07-02 | Union | Kentucky | 21225 | 29 | 0 |
297631 | 297631 | 2020-07-03 | Union | Kentucky | 21225 | 29 | 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);