ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Warren" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387046 | 387046 | 2020-07-31 | Warren | Kentucky | 21227 | 2372 | 22 |
383828 | 383828 | 2020-07-30 | Warren | Kentucky | 21227 | 2327 | 22 |
380611 | 380611 | 2020-07-29 | Warren | Kentucky | 21227 | 2305 | 22 |
377394 | 377394 | 2020-07-28 | Warren | Kentucky | 21227 | 2261 | 21 |
374179 | 374179 | 2020-07-27 | Warren | Kentucky | 21227 | 2244 | 21 |
370967 | 370967 | 2020-07-26 | Warren | Kentucky | 21227 | 2223 | 21 |
367757 | 367757 | 2020-07-25 | Warren | Kentucky | 21227 | 2199 | 21 |
364550 | 364550 | 2020-07-24 | Warren | Kentucky | 21227 | 2146 | 21 |
361343 | 361343 | 2020-07-23 | Warren | Kentucky | 21227 | 2105 | 21 |
358138 | 358138 | 2020-07-22 | Warren | Kentucky | 21227 | 2057 | 19 |
354935 | 354935 | 2020-07-21 | Warren | Kentucky | 21227 | 2013 | 19 |
351733 | 351733 | 2020-07-20 | Warren | Kentucky | 21227 | 1992 | 19 |
348533 | 348533 | 2020-07-19 | Warren | Kentucky | 21227 | 1985 | 19 |
345332 | 345332 | 2020-07-18 | Warren | Kentucky | 21227 | 1911 | 19 |
342132 | 342132 | 2020-07-17 | Warren | Kentucky | 21227 | 1879 | 19 |
338936 | 338936 | 2020-07-16 | Warren | Kentucky | 21227 | 1850 | 18 |
335740 | 335740 | 2020-07-15 | Warren | Kentucky | 21227 | 1830 | 18 |
332547 | 332547 | 2020-07-14 | Warren | Kentucky | 21227 | 1808 | 18 |
329360 | 329360 | 2020-07-13 | Warren | Kentucky | 21227 | 1770 | 18 |
326174 | 326174 | 2020-07-12 | Warren | Kentucky | 21227 | 1733 | 17 |
322991 | 322991 | 2020-07-11 | Warren | Kentucky | 21227 | 1722 | 17 |
319812 | 319812 | 2020-07-10 | Warren | Kentucky | 21227 | 1714 | 17 |
316637 | 316637 | 2020-07-09 | Warren | Kentucky | 21227 | 1698 | 17 |
313463 | 313463 | 2020-07-08 | Warren | Kentucky | 21227 | 1679 | 15 |
310293 | 310293 | 2020-07-07 | Warren | Kentucky | 21227 | 1655 | 15 |
307125 | 307125 | 2020-07-06 | Warren | Kentucky | 21227 | 1650 | 15 |
303958 | 303958 | 2020-07-05 | Warren | Kentucky | 21227 | 1583 | 15 |
300794 | 300794 | 2020-07-04 | Warren | Kentucky | 21227 | 1583 | 15 |
297632 | 297632 | 2020-07-03 | Warren | Kentucky | 21227 | 1583 | 15 |
294474 | 294474 | 2020-07-02 | Warren | Kentucky | 21227 | 1563 | 15 |
291320 | 291320 | 2020-07-01 | Warren | Kentucky | 21227 | 1547 | 14 |
288169 | 288169 | 2020-06-30 | Warren | Kentucky | 21227 | 1533 | 14 |
285020 | 285020 | 2020-06-29 | Warren | Kentucky | 21227 | 1514 | 14 |
281874 | 281874 | 2020-06-28 | Warren | Kentucky | 21227 | 1491 | 14 |
278726 | 278726 | 2020-06-27 | Warren | Kentucky | 21227 | 1481 | 14 |
275578 | 275578 | 2020-06-26 | Warren | Kentucky | 21227 | 1455 | 14 |
272435 | 272435 | 2020-06-25 | Warren | Kentucky | 21227 | 1426 | 12 |
269299 | 269299 | 2020-06-24 | Warren | Kentucky | 21227 | 1398 | 11 |
266166 | 266166 | 2020-06-23 | Warren | Kentucky | 21227 | 1376 | 11 |
263039 | 263039 | 2020-06-22 | Warren | Kentucky | 21227 | 1361 | 11 |
259910 | 259910 | 2020-06-21 | Warren | Kentucky | 21227 | 1357 | 10 |
256784 | 256784 | 2020-06-20 | Warren | Kentucky | 21227 | 1339 | 10 |
253664 | 253664 | 2020-06-19 | Warren | Kentucky | 21227 | 1323 | 10 |
250549 | 250549 | 2020-06-18 | Warren | Kentucky | 21227 | 1305 | 10 |
247437 | 247437 | 2020-06-17 | Warren | Kentucky | 21227 | 1299 | 10 |
244324 | 244324 | 2020-06-16 | Warren | Kentucky | 21227 | 1279 | 10 |
241213 | 241213 | 2020-06-15 | Warren | Kentucky | 21227 | 1275 | 10 |
238104 | 238104 | 2020-06-14 | Warren | Kentucky | 21227 | 1248 | 8 |
234997 | 234997 | 2020-06-13 | Warren | Kentucky | 21227 | 1248 | 8 |
231892 | 231892 | 2020-06-12 | Warren | Kentucky | 21227 | 1220 | 8 |
228788 | 228788 | 2020-06-11 | Warren | Kentucky | 21227 | 1192 | 8 |
225686 | 225686 | 2020-06-10 | Warren | Kentucky | 21227 | 1179 | 8 |
222590 | 222590 | 2020-06-09 | Warren | Kentucky | 21227 | 1174 | 8 |
219495 | 219495 | 2020-06-08 | Warren | Kentucky | 21227 | 1142 | 7 |
216403 | 216403 | 2020-06-07 | Warren | Kentucky | 21227 | 1112 | 7 |
213316 | 213316 | 2020-06-06 | Warren | Kentucky | 21227 | 1112 | 7 |
210231 | 210231 | 2020-06-05 | Warren | Kentucky | 21227 | 1105 | 7 |
207150 | 207150 | 2020-06-04 | Warren | Kentucky | 21227 | 1093 | 7 |
204069 | 204069 | 2020-06-03 | Warren | Kentucky | 21227 | 1079 | 7 |
200992 | 200992 | 2020-06-02 | Warren | Kentucky | 21227 | 1063 | 7 |
197920 | 197920 | 2020-06-01 | Warren | Kentucky | 21227 | 1044 | 6 |
194849 | 194849 | 2020-05-31 | Warren | Kentucky | 21227 | 1007 | 6 |
191781 | 191781 | 2020-05-30 | Warren | Kentucky | 21227 | 1007 | 6 |
188717 | 188717 | 2020-05-29 | Warren | Kentucky | 21227 | 1000 | 6 |
185659 | 185659 | 2020-05-28 | Warren | Kentucky | 21227 | 989 | 6 |
182604 | 182604 | 2020-05-27 | Warren | Kentucky | 21227 | 950 | 5 |
179559 | 179559 | 2020-05-26 | Warren | Kentucky | 21227 | 950 | 5 |
176515 | 176515 | 2020-05-25 | Warren | Kentucky | 21227 | 920 | 5 |
173471 | 173471 | 2020-05-24 | Warren | Kentucky | 21227 | 920 | 5 |
170430 | 170430 | 2020-05-23 | Warren | Kentucky | 21227 | 920 | 5 |
167392 | 167392 | 2020-05-22 | Warren | Kentucky | 21227 | 917 | 5 |
164356 | 164356 | 2020-05-21 | Warren | Kentucky | 21227 | 879 | 5 |
161327 | 161327 | 2020-05-20 | Warren | Kentucky | 21227 | 863 | 3 |
158301 | 158301 | 2020-05-19 | Warren | Kentucky | 21227 | 828 | 3 |
155284 | 155284 | 2020-05-18 | Warren | Kentucky | 21227 | 810 | 3 |
152270 | 152270 | 2020-05-17 | Warren | Kentucky | 21227 | 776 | 2 |
149259 | 149259 | 2020-05-16 | Warren | Kentucky | 21227 | 776 | 2 |
146254 | 146254 | 2020-05-15 | Warren | Kentucky | 21227 | 751 | 2 |
143254 | 143254 | 2020-05-14 | Warren | Kentucky | 21227 | 730 | 2 |
140259 | 140259 | 2020-05-13 | Warren | Kentucky | 21227 | 637 | 2 |
137265 | 137265 | 2020-05-12 | Warren | Kentucky | 21227 | 637 | 2 |
134275 | 134275 | 2020-05-11 | Warren | Kentucky | 21227 | 573 | 2 |
131284 | 131284 | 2020-05-10 | Warren | Kentucky | 21227 | 530 | 2 |
128294 | 128294 | 2020-05-09 | Warren | Kentucky | 21227 | 530 | 2 |
125307 | 125307 | 2020-05-08 | Warren | Kentucky | 21227 | 512 | 2 |
122325 | 122325 | 2020-05-07 | Warren | Kentucky | 21227 | 492 | 2 |
119354 | 119354 | 2020-05-06 | Warren | Kentucky | 21227 | 447 | 1 |
116393 | 116393 | 2020-05-05 | Warren | Kentucky | 21227 | 426 | 1 |
113511 | 113511 | 2020-05-04 | Warren | Kentucky | 21227 | 400 | 1 |
110634 | 110634 | 2020-05-03 | Warren | Kentucky | 21227 | 369 | 1 |
107762 | 107762 | 2020-05-02 | Warren | Kentucky | 21227 | 352 | 1 |
104898 | 104898 | 2020-05-01 | Warren | Kentucky | 21227 | 344 | 1 |
102037 | 102037 | 2020-04-30 | Warren | Kentucky | 21227 | 332 | 1 |
99185 | 99185 | 2020-04-29 | Warren | Kentucky | 21227 | 313 | 1 |
96339 | 96339 | 2020-04-28 | Warren | Kentucky | 21227 | 263 | 0 |
93504 | 93504 | 2020-04-27 | Warren | Kentucky | 21227 | 234 | 0 |
90683 | 90683 | 2020-04-26 | Warren | Kentucky | 21227 | 219 | 0 |
87867 | 87867 | 2020-04-25 | Warren | Kentucky | 21227 | 184 | 0 |
85058 | 85058 | 2020-04-24 | Warren | Kentucky | 21227 | 184 | 0 |
82254 | 82254 | 2020-04-23 | Warren | Kentucky | 21227 | 184 | 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);