ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Daviess" and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
278643 | 278643 | 2020-06-27 | Daviess | Kentucky | 21059 | 428 | 8 |
281791 | 281791 | 2020-06-28 | Daviess | Kentucky | 21059 | 428 | 8 |
284937 | 284937 | 2020-06-29 | Daviess | Kentucky | 21059 | 431 | 8 |
288086 | 288086 | 2020-06-30 | Daviess | Kentucky | 21059 | 433 | 8 |
291236 | 291236 | 2020-07-01 | Daviess | Kentucky | 21059 | 435 | 8 |
294390 | 294390 | 2020-07-02 | Daviess | Kentucky | 21059 | 440 | 8 |
297548 | 297548 | 2020-07-03 | Daviess | Kentucky | 21059 | 452 | 8 |
300710 | 300710 | 2020-07-04 | Daviess | Kentucky | 21059 | 452 | 8 |
303874 | 303874 | 2020-07-05 | Daviess | Kentucky | 21059 | 452 | 8 |
307041 | 307041 | 2020-07-06 | Daviess | Kentucky | 21059 | 458 | 8 |
310209 | 310209 | 2020-07-07 | Daviess | Kentucky | 21059 | 467 | 8 |
313379 | 313379 | 2020-07-08 | Daviess | Kentucky | 21059 | 469 | 8 |
316553 | 316553 | 2020-07-09 | Daviess | Kentucky | 21059 | 483 | 8 |
319728 | 319728 | 2020-07-10 | Daviess | Kentucky | 21059 | 493 | 8 |
322907 | 322907 | 2020-07-11 | Daviess | Kentucky | 21059 | 499 | 8 |
326090 | 326090 | 2020-07-12 | Daviess | Kentucky | 21059 | 499 | 8 |
329276 | 329276 | 2020-07-13 | Daviess | Kentucky | 21059 | 511 | 8 |
332463 | 332463 | 2020-07-14 | Daviess | Kentucky | 21059 | 518 | 8 |
335656 | 335656 | 2020-07-15 | Daviess | Kentucky | 21059 | 534 | 8 |
338852 | 338852 | 2020-07-16 | Daviess | Kentucky | 21059 | 539 | 8 |
342048 | 342048 | 2020-07-17 | Daviess | Kentucky | 21059 | 553 | 8 |
345248 | 345248 | 2020-07-18 | Daviess | Kentucky | 21059 | 562 | 8 |
348449 | 348449 | 2020-07-19 | Daviess | Kentucky | 21059 | 570 | 8 |
351649 | 351649 | 2020-07-20 | Daviess | Kentucky | 21059 | 575 | 8 |
354851 | 354851 | 2020-07-21 | Daviess | Kentucky | 21059 | 586 | 7 |
358054 | 358054 | 2020-07-22 | Daviess | Kentucky | 21059 | 595 | 7 |
361259 | 361259 | 2020-07-23 | Daviess | Kentucky | 21059 | 608 | 7 |
364466 | 364466 | 2020-07-24 | Daviess | Kentucky | 21059 | 613 | 7 |
367673 | 367673 | 2020-07-25 | Daviess | Kentucky | 21059 | 633 | 7 |
370883 | 370883 | 2020-07-26 | Daviess | Kentucky | 21059 | 633 | 7 |
374095 | 374095 | 2020-07-27 | Daviess | Kentucky | 21059 | 655 | 7 |
377310 | 377310 | 2020-07-28 | Daviess | Kentucky | 21059 | 661 | 7 |
380527 | 380527 | 2020-07-29 | Daviess | Kentucky | 21059 | 671 | 7 |
383744 | 383744 | 2020-07-30 | Daviess | Kentucky | 21059 | 685 | 7 |
386962 | 386962 | 2020-07-31 | Daviess | Kentucky | 21059 | 689 | 7 |
390179 | 390179 | 2020-08-01 | Daviess | Kentucky | 21059 | 699 | 7 |
393396 | 393396 | 2020-08-02 | Daviess | Kentucky | 21059 | 712 | 7 |
396612 | 396612 | 2020-08-03 | Daviess | Kentucky | 21059 | 715 | 8 |
399827 | 399827 | 2020-08-04 | Daviess | Kentucky | 21059 | 723 | 8 |
403044 | 403044 | 2020-08-05 | Daviess | Kentucky | 21059 | 735 | 8 |
406262 | 406262 | 2020-08-06 | Daviess | Kentucky | 21059 | 740 | 8 |
409482 | 409482 | 2020-08-07 | Daviess | Kentucky | 21059 | 750 | 9 |
412702 | 412702 | 2020-08-08 | Daviess | Kentucky | 21059 | 765 | 9 |
415922 | 415922 | 2020-08-09 | Daviess | Kentucky | 21059 | 765 | 9 |
419143 | 419143 | 2020-08-10 | Daviess | Kentucky | 21059 | 765 | 9 |
422365 | 422365 | 2020-08-11 | Daviess | Kentucky | 21059 | 774 | 9 |
425586 | 425586 | 2020-08-12 | Daviess | Kentucky | 21059 | 793 | 9 |
428810 | 428810 | 2020-08-13 | Daviess | Kentucky | 21059 | 805 | 9 |
432038 | 432038 | 2020-08-14 | Daviess | Kentucky | 21059 | 813 | 9 |
435263 | 435263 | 2020-08-15 | Daviess | Kentucky | 21059 | 824 | 9 |
438488 | 438488 | 2020-08-16 | Daviess | Kentucky | 21059 | 824 | 9 |
441715 | 441715 | 2020-08-17 | Daviess | Kentucky | 21059 | 831 | 9 |
444941 | 444941 | 2020-08-18 | Daviess | Kentucky | 21059 | 847 | 10 |
448168 | 448168 | 2020-08-19 | Daviess | Kentucky | 21059 | 858 | 10 |
451396 | 451396 | 2020-08-20 | Daviess | Kentucky | 21059 | 880 | 10 |
454624 | 454624 | 2020-08-21 | Daviess | Kentucky | 21059 | 896 | 10 |
457852 | 457852 | 2020-08-22 | Daviess | Kentucky | 21059 | 912 | 10 |
461079 | 461079 | 2020-08-23 | Daviess | Kentucky | 21059 | 912 | 10 |
464310 | 464310 | 2020-08-24 | Daviess | Kentucky | 21059 | 912 | 10 |
467539 | 467539 | 2020-08-25 | Daviess | Kentucky | 21059 | 928 | 11 |
470768 | 470768 | 2020-08-26 | Daviess | Kentucky | 21059 | 941 | 11 |
474000 | 474000 | 2020-08-27 | Daviess | Kentucky | 21059 | 953 | 11 |
477233 | 477233 | 2020-08-28 | Daviess | Kentucky | 21059 | 969 | 11 |
480466 | 480466 | 2020-08-29 | Daviess | Kentucky | 21059 | 975 | 12 |
483700 | 483700 | 2020-08-30 | Daviess | Kentucky | 21059 | 975 | 12 |
486935 | 486935 | 2020-08-31 | Daviess | Kentucky | 21059 | 985 | 12 |
490168 | 490168 | 2020-09-01 | Daviess | Kentucky | 21059 | 994 | 13 |
493402 | 493402 | 2020-09-02 | Daviess | Kentucky | 21059 | 1007 | 13 |
496635 | 496635 | 2020-09-03 | Daviess | Kentucky | 21059 | 1029 | 13 |
499869 | 499869 | 2020-09-04 | Daviess | Kentucky | 21059 | 1044 | 13 |
503102 | 503102 | 2020-09-05 | Daviess | Kentucky | 21059 | 1060 | 13 |
506336 | 506336 | 2020-09-06 | Daviess | Kentucky | 21059 | 1060 | 13 |
509569 | 509569 | 2020-09-07 | Daviess | Kentucky | 21059 | 1064 | 13 |
512801 | 512801 | 2020-09-08 | Daviess | Kentucky | 21059 | 1067 | 13 |
516034 | 516034 | 2020-09-09 | Daviess | Kentucky | 21059 | 1072 | 13 |
519269 | 519269 | 2020-09-10 | Daviess | Kentucky | 21059 | 1090 | 13 |
522506 | 522506 | 2020-09-11 | Daviess | Kentucky | 21059 | 1103 | 13 |
525742 | 525742 | 2020-09-12 | Daviess | Kentucky | 21059 | 1125 | 13 |
528978 | 528978 | 2020-09-13 | Daviess | Kentucky | 21059 | 1142 | 13 |
532215 | 532215 | 2020-09-14 | Daviess | Kentucky | 21059 | 1146 | 13 |
535450 | 535450 | 2020-09-15 | Daviess | Kentucky | 21059 | 1163 | 13 |
538687 | 538687 | 2020-09-16 | Daviess | Kentucky | 21059 | 1184 | 13 |
541923 | 541923 | 2020-09-17 | Daviess | Kentucky | 21059 | 1212 | 14 |
545159 | 545159 | 2020-09-18 | Daviess | Kentucky | 21059 | 1245 | 14 |
548397 | 548397 | 2020-09-19 | Daviess | Kentucky | 21059 | 1266 | 14 |
551636 | 551636 | 2020-09-20 | Daviess | Kentucky | 21059 | 1275 | 14 |
554875 | 554875 | 2020-09-21 | Daviess | Kentucky | 21059 | 1281 | 14 |
558112 | 558112 | 2020-09-22 | Daviess | Kentucky | 21059 | 1293 | 14 |
561348 | 561348 | 2020-09-23 | Daviess | Kentucky | 21059 | 1320 | 14 |
564588 | 564588 | 2020-09-24 | Daviess | Kentucky | 21059 | 1329 | 15 |
567828 | 567828 | 2020-09-25 | Daviess | Kentucky | 21059 | 1359 | 16 |
571070 | 571070 | 2020-09-26 | Daviess | Kentucky | 21059 | 1372 | 16 |
574313 | 574313 | 2020-09-27 | Daviess | Kentucky | 21059 | 1382 | 16 |
577555 | 577555 | 2020-09-28 | Daviess | Kentucky | 21059 | 1395 | 16 |
580796 | 580796 | 2020-09-29 | Daviess | Kentucky | 21059 | 1405 | 16 |
584036 | 584036 | 2020-09-30 | Daviess | Kentucky | 21059 | 1431 | 16 |
587276 | 587276 | 2020-10-01 | Daviess | Kentucky | 21059 | 1452 | 16 |
590517 | 590517 | 2020-10-02 | Daviess | Kentucky | 21059 | 1470 | 16 |
593758 | 593758 | 2020-10-03 | Daviess | Kentucky | 21059 | 1506 | 16 |
597000 | 597000 | 2020-10-04 | Daviess | Kentucky | 21059 | 1522 | 16 |
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);