ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Union" and fips = 21225 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535533 | 535533 | 2020-09-15 | Union | Kentucky | 21225 | 216 | 1 |
532298 | 532298 | 2020-09-14 | Union | Kentucky | 21225 | 213 | 1 |
529061 | 529061 | 2020-09-13 | Union | Kentucky | 21225 | 210 | 1 |
525825 | 525825 | 2020-09-12 | Union | Kentucky | 21225 | 202 | 1 |
522589 | 522589 | 2020-09-11 | Union | Kentucky | 21225 | 195 | 1 |
519352 | 519352 | 2020-09-10 | Union | Kentucky | 21225 | 188 | 1 |
516117 | 516117 | 2020-09-09 | Union | Kentucky | 21225 | 182 | 1 |
512884 | 512884 | 2020-09-08 | Union | Kentucky | 21225 | 172 | 1 |
509652 | 509652 | 2020-09-07 | Union | Kentucky | 21225 | 169 | 1 |
506419 | 506419 | 2020-09-06 | Union | Kentucky | 21225 | 160 | 1 |
503185 | 503185 | 2020-09-05 | Union | Kentucky | 21225 | 157 | 1 |
499952 | 499952 | 2020-09-04 | Union | Kentucky | 21225 | 148 | 1 |
496718 | 496718 | 2020-09-03 | Union | Kentucky | 21225 | 133 | 1 |
493485 | 493485 | 2020-09-02 | Union | Kentucky | 21225 | 115 | 1 |
490251 | 490251 | 2020-09-01 | Union | Kentucky | 21225 | 113 | 1 |
487018 | 487018 | 2020-08-31 | Union | Kentucky | 21225 | 107 | 1 |
483783 | 483783 | 2020-08-30 | Union | Kentucky | 21225 | 100 | 1 |
480549 | 480549 | 2020-08-29 | Union | Kentucky | 21225 | 100 | 1 |
477316 | 477316 | 2020-08-28 | Union | Kentucky | 21225 | 97 | 1 |
474083 | 474083 | 2020-08-27 | Union | Kentucky | 21225 | 94 | 1 |
470851 | 470851 | 2020-08-26 | Union | Kentucky | 21225 | 86 | 1 |
467622 | 467622 | 2020-08-25 | Union | Kentucky | 21225 | 84 | 0 |
464393 | 464393 | 2020-08-24 | Union | Kentucky | 21225 | 81 | 0 |
461162 | 461162 | 2020-08-23 | Union | Kentucky | 21225 | 79 | 0 |
457935 | 457935 | 2020-08-22 | Union | Kentucky | 21225 | 79 | 0 |
454707 | 454707 | 2020-08-21 | Union | Kentucky | 21225 | 77 | 0 |
451479 | 451479 | 2020-08-20 | Union | Kentucky | 21225 | 77 | 0 |
448251 | 448251 | 2020-08-19 | Union | Kentucky | 21225 | 76 | 0 |
445024 | 445024 | 2020-08-18 | Union | Kentucky | 21225 | 76 | 0 |
441798 | 441798 | 2020-08-17 | Union | Kentucky | 21225 | 76 | 0 |
438571 | 438571 | 2020-08-16 | Union | Kentucky | 21225 | 73 | 0 |
435346 | 435346 | 2020-08-15 | Union | Kentucky | 21225 | 73 | 0 |
432121 | 432121 | 2020-08-14 | Union | Kentucky | 21225 | 73 | 0 |
428893 | 428893 | 2020-08-13 | Union | Kentucky | 21225 | 70 | 0 |
425669 | 425669 | 2020-08-12 | Union | Kentucky | 21225 | 70 | 0 |
422448 | 422448 | 2020-08-11 | Union | Kentucky | 21225 | 67 | 0 |
419226 | 419226 | 2020-08-10 | Union | Kentucky | 21225 | 65 | 0 |
416005 | 416005 | 2020-08-09 | Union | Kentucky | 21225 | 65 | 0 |
412785 | 412785 | 2020-08-08 | Union | Kentucky | 21225 | 65 | 0 |
409565 | 409565 | 2020-08-07 | Union | Kentucky | 21225 | 65 | 0 |
406345 | 406345 | 2020-08-06 | Union | Kentucky | 21225 | 62 | 0 |
403127 | 403127 | 2020-08-05 | Union | Kentucky | 21225 | 58 | 0 |
399910 | 399910 | 2020-08-04 | Union | Kentucky | 21225 | 57 | 0 |
396695 | 396695 | 2020-08-03 | Union | Kentucky | 21225 | 56 | 0 |
393479 | 393479 | 2020-08-02 | Union | Kentucky | 21225 | 55 | 0 |
390262 | 390262 | 2020-08-01 | Union | Kentucky | 21225 | 55 | 0 |
387045 | 387045 | 2020-07-31 | Union | Kentucky | 21225 | 53 | 0 |
383827 | 383827 | 2020-07-30 | Union | Kentucky | 21225 | 52 | 0 |
380610 | 380610 | 2020-07-29 | Union | Kentucky | 21225 | 50 | 0 |
377393 | 377393 | 2020-07-28 | Union | Kentucky | 21225 | 50 | 0 |
374178 | 374178 | 2020-07-27 | Union | Kentucky | 21225 | 49 | 0 |
370966 | 370966 | 2020-07-26 | Union | Kentucky | 21225 | 46 | 0 |
367756 | 367756 | 2020-07-25 | Union | Kentucky | 21225 | 45 | 0 |
364549 | 364549 | 2020-07-24 | Union | Kentucky | 21225 | 44 | 0 |
361342 | 361342 | 2020-07-23 | Union | Kentucky | 21225 | 42 | 0 |
358137 | 358137 | 2020-07-22 | Union | Kentucky | 21225 | 40 | 0 |
354934 | 354934 | 2020-07-21 | Union | Kentucky | 21225 | 40 | 0 |
351732 | 351732 | 2020-07-20 | Union | Kentucky | 21225 | 37 | 0 |
348532 | 348532 | 2020-07-19 | Union | Kentucky | 21225 | 37 | 0 |
345331 | 345331 | 2020-07-18 | Union | Kentucky | 21225 | 34 | 0 |
342131 | 342131 | 2020-07-17 | Union | Kentucky | 21225 | 34 | 0 |
338935 | 338935 | 2020-07-16 | Union | Kentucky | 21225 | 33 | 0 |
335739 | 335739 | 2020-07-15 | Union | Kentucky | 21225 | 33 | 0 |
332546 | 332546 | 2020-07-14 | Union | Kentucky | 21225 | 32 | 0 |
329359 | 329359 | 2020-07-13 | Union | Kentucky | 21225 | 32 | 0 |
326173 | 326173 | 2020-07-12 | Union | Kentucky | 21225 | 32 | 0 |
322990 | 322990 | 2020-07-11 | Union | Kentucky | 21225 | 31 | 0 |
319811 | 319811 | 2020-07-10 | Union | Kentucky | 21225 | 30 | 0 |
316636 | 316636 | 2020-07-09 | Union | Kentucky | 21225 | 30 | 0 |
313462 | 313462 | 2020-07-08 | Union | Kentucky | 21225 | 30 | 0 |
310292 | 310292 | 2020-07-07 | Union | Kentucky | 21225 | 30 | 0 |
307124 | 307124 | 2020-07-06 | Union | Kentucky | 21225 | 29 | 0 |
303957 | 303957 | 2020-07-05 | Union | Kentucky | 21225 | 29 | 0 |
300793 | 300793 | 2020-07-04 | Union | Kentucky | 21225 | 29 | 0 |
297631 | 297631 | 2020-07-03 | Union | Kentucky | 21225 | 29 | 0 |
294473 | 294473 | 2020-07-02 | Union | Kentucky | 21225 | 29 | 0 |
291319 | 291319 | 2020-07-01 | Union | Kentucky | 21225 | 29 | 0 |
288168 | 288168 | 2020-06-30 | Union | Kentucky | 21225 | 29 | 0 |
285019 | 285019 | 2020-06-29 | Union | Kentucky | 21225 | 29 | 0 |
281873 | 281873 | 2020-06-28 | Union | Kentucky | 21225 | 29 | 0 |
278725 | 278725 | 2020-06-27 | Union | Kentucky | 21225 | 29 | 0 |
275577 | 275577 | 2020-06-26 | Union | Kentucky | 21225 | 28 | 0 |
272434 | 272434 | 2020-06-25 | Union | Kentucky | 21225 | 26 | 0 |
269298 | 269298 | 2020-06-24 | Union | Kentucky | 21225 | 25 | 0 |
266165 | 266165 | 2020-06-23 | Union | Kentucky | 21225 | 25 | 0 |
263038 | 263038 | 2020-06-22 | Union | Kentucky | 21225 | 25 | 0 |
259909 | 259909 | 2020-06-21 | Union | Kentucky | 21225 | 25 | 0 |
256783 | 256783 | 2020-06-20 | Union | Kentucky | 21225 | 25 | 0 |
253663 | 253663 | 2020-06-19 | Union | Kentucky | 21225 | 24 | 0 |
250548 | 250548 | 2020-06-18 | Union | Kentucky | 21225 | 22 | 0 |
247436 | 247436 | 2020-06-17 | Union | Kentucky | 21225 | 20 | 0 |
244323 | 244323 | 2020-06-16 | Union | Kentucky | 21225 | 19 | 0 |
241212 | 241212 | 2020-06-15 | Union | Kentucky | 21225 | 19 | 0 |
238103 | 238103 | 2020-06-14 | Union | Kentucky | 21225 | 17 | 0 |
234996 | 234996 | 2020-06-13 | Union | Kentucky | 21225 | 17 | 0 |
231891 | 231891 | 2020-06-12 | Union | Kentucky | 21225 | 16 | 0 |
228787 | 228787 | 2020-06-11 | Union | Kentucky | 21225 | 15 | 0 |
225685 | 225685 | 2020-06-10 | Union | Kentucky | 21225 | 15 | 0 |
222589 | 222589 | 2020-06-09 | Union | Kentucky | 21225 | 15 | 0 |
219494 | 219494 | 2020-06-08 | Union | Kentucky | 21225 | 15 | 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);