ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Davidson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955435 | 955435 | 2021-01-22 | Davidson | Tennessee | 47037 | 81561 | 688 |
952190 | 952190 | 2021-01-21 | Davidson | Tennessee | 47037 | 81141 | 679 |
948945 | 948945 | 2021-01-20 | Davidson | Tennessee | 47037 | 80663 | 678 |
945699 | 945699 | 2021-01-19 | Davidson | Tennessee | 47037 | 80415 | 672 |
942452 | 942452 | 2021-01-18 | Davidson | Tennessee | 47037 | 80154 | 665 |
939207 | 939207 | 2021-01-17 | Davidson | Tennessee | 47037 | 79517 | 661 |
935962 | 935962 | 2021-01-16 | Davidson | Tennessee | 47037 | 78976 | 656 |
932717 | 932717 | 2021-01-15 | Davidson | Tennessee | 47037 | 78270 | 654 |
929472 | 929472 | 2021-01-14 | Davidson | Tennessee | 47037 | 77795 | 648 |
926227 | 926227 | 2021-01-13 | Davidson | Tennessee | 47037 | 77401 | 646 |
922981 | 922981 | 2021-01-12 | Davidson | Tennessee | 47037 | 77113 | 641 |
919736 | 919736 | 2021-01-11 | Davidson | Tennessee | 47037 | 76733 | 628 |
916491 | 916491 | 2021-01-10 | Davidson | Tennessee | 47037 | 75879 | 626 |
913246 | 913246 | 2021-01-09 | Davidson | Tennessee | 47037 | 75185 | 620 |
910001 | 910001 | 2021-01-08 | Davidson | Tennessee | 47037 | 74528 | 614 |
906756 | 906756 | 2021-01-07 | Davidson | Tennessee | 47037 | 73533 | 600 |
903510 | 903510 | 2021-01-06 | Davidson | Tennessee | 47037 | 72330 | 600 |
900265 | 900265 | 2021-01-05 | Davidson | Tennessee | 47037 | 71936 | 600 |
897020 | 897020 | 2021-01-04 | Davidson | Tennessee | 47037 | 71591 | 597 |
893774 | 893774 | 2021-01-03 | Davidson | Tennessee | 47037 | 71365 | 576 |
890528 | 890528 | 2021-01-02 | Davidson | Tennessee | 47037 | 70325 | 572 |
887281 | 887281 | 2021-01-01 | Davidson | Tennessee | 47037 | 68812 | 570 |
884036 | 884036 | 2020-12-31 | Davidson | Tennessee | 47037 | 68812 | 570 |
880791 | 880791 | 2020-12-30 | Davidson | Tennessee | 47037 | 67644 | 564 |
877546 | 877546 | 2020-12-29 | Davidson | Tennessee | 47037 | 67281 | 556 |
874301 | 874301 | 2020-12-28 | Davidson | Tennessee | 47037 | 66724 | 549 |
871056 | 871056 | 2020-12-27 | Davidson | Tennessee | 47037 | 66724 | 541 |
867811 | 867811 | 2020-12-26 | Davidson | Tennessee | 47037 | 66217 | 538 |
864566 | 864566 | 2020-12-25 | Davidson | Tennessee | 47037 | 65424 | 537 |
861321 | 861321 | 2020-12-24 | Davidson | Tennessee | 47037 | 64835 | 537 |
858076 | 858076 | 2020-12-23 | Davidson | Tennessee | 47037 | 63944 | 529 |
854831 | 854831 | 2020-12-22 | Davidson | Tennessee | 47037 | 63522 | 525 |
851586 | 851586 | 2020-12-21 | Davidson | Tennessee | 47037 | 62507 | 518 |
848341 | 848341 | 2020-12-20 | Davidson | Tennessee | 47037 | 61556 | 503 |
845096 | 845096 | 2020-12-19 | Davidson | Tennessee | 47037 | 60791 | 498 |
841850 | 841850 | 2020-12-18 | Davidson | Tennessee | 47037 | 59883 | 495 |
838605 | 838605 | 2020-12-17 | Davidson | Tennessee | 47037 | 58939 | 489 |
835359 | 835359 | 2020-12-16 | Davidson | Tennessee | 47037 | 57840 | 481 |
832113 | 832113 | 2020-12-15 | Davidson | Tennessee | 47037 | 56983 | 480 |
828866 | 828866 | 2020-12-14 | Davidson | Tennessee | 47037 | 55723 | 481 |
825620 | 825620 | 2020-12-13 | Davidson | Tennessee | 47037 | 54412 | 475 |
822373 | 822373 | 2020-12-12 | Davidson | Tennessee | 47037 | 53723 | 470 |
819127 | 819127 | 2020-12-11 | Davidson | Tennessee | 47037 | 53109 | 461 |
815881 | 815881 | 2020-12-10 | Davidson | Tennessee | 47037 | 52479 | 456 |
812635 | 812635 | 2020-12-09 | Davidson | Tennessee | 47037 | 51633 | 454 |
809391 | 809391 | 2020-12-08 | Davidson | Tennessee | 47037 | 50967 | 448 |
806146 | 806146 | 2020-12-07 | Davidson | Tennessee | 47037 | 50275 | 440 |
802901 | 802901 | 2020-12-06 | Davidson | Tennessee | 47037 | 50083 | 438 |
799656 | 799656 | 2020-12-05 | Davidson | Tennessee | 47037 | 49622 | 435 |
796411 | 796411 | 2020-12-04 | Davidson | Tennessee | 47037 | 49027 | 434 |
793166 | 793166 | 2020-12-03 | Davidson | Tennessee | 47037 | 48492 | 429 |
789921 | 789921 | 2020-12-02 | Davidson | Tennessee | 47037 | 47682 | 425 |
786676 | 786676 | 2020-12-01 | Davidson | Tennessee | 47037 | 47160 | 423 |
783432 | 783432 | 2020-11-30 | Davidson | Tennessee | 47037 | 46309 | 421 |
780187 | 780187 | 2020-11-29 | Davidson | Tennessee | 47037 | 44042 | 420 |
776941 | 776941 | 2020-11-28 | Davidson | Tennessee | 47037 | 44042 | 420 |
773696 | 773696 | 2020-11-27 | Davidson | Tennessee | 47037 | 44042 | 419 |
770451 | 770451 | 2020-11-26 | Davidson | Tennessee | 47037 | 44042 | 419 |
767205 | 767205 | 2020-11-25 | Davidson | Tennessee | 47037 | 43941 | 412 |
763960 | 763960 | 2020-11-24 | Davidson | Tennessee | 47037 | 43920 | 409 |
760715 | 760715 | 2020-11-23 | Davidson | Tennessee | 47037 | 43395 | 407 |
757470 | 757470 | 2020-11-22 | Davidson | Tennessee | 47037 | 42995 | 402 |
754223 | 754223 | 2020-11-21 | Davidson | Tennessee | 47037 | 42604 | 400 |
750977 | 750977 | 2020-11-20 | Davidson | Tennessee | 47037 | 42262 | 399 |
747731 | 747731 | 2020-11-19 | Davidson | Tennessee | 47037 | 42004 | 393 |
744485 | 744485 | 2020-11-18 | Davidson | Tennessee | 47037 | 41553 | 391 |
741238 | 741238 | 2020-11-17 | Davidson | Tennessee | 47037 | 41411 | 390 |
737992 | 737992 | 2020-11-16 | Davidson | Tennessee | 47037 | 40433 | 387 |
734748 | 734748 | 2020-11-15 | Davidson | Tennessee | 47037 | 39843 | 382 |
731502 | 731502 | 2020-11-14 | Davidson | Tennessee | 47037 | 39411 | 380 |
728258 | 728258 | 2020-11-13 | Davidson | Tennessee | 47037 | 39101 | 379 |
725014 | 725014 | 2020-11-12 | Davidson | Tennessee | 47037 | 38802 | 374 |
721771 | 721771 | 2020-11-11 | Davidson | Tennessee | 47037 | 38262 | 374 |
718528 | 718528 | 2020-11-10 | Davidson | Tennessee | 47037 | 38010 | 369 |
715285 | 715285 | 2020-11-09 | Davidson | Tennessee | 47037 | 37375 | 366 |
712041 | 712041 | 2020-11-08 | Davidson | Tennessee | 47037 | 37034 | 365 |
708797 | 708797 | 2020-11-07 | Davidson | Tennessee | 47037 | 36392 | 365 |
705554 | 705554 | 2020-11-06 | Davidson | Tennessee | 47037 | 36303 | 362 |
702311 | 702311 | 2020-11-05 | Davidson | Tennessee | 47037 | 36089 | 360 |
699067 | 699067 | 2020-11-04 | Davidson | Tennessee | 47037 | 35699 | 357 |
695824 | 695824 | 2020-11-03 | Davidson | Tennessee | 47037 | 35444 | 355 |
692582 | 692582 | 2020-11-02 | Davidson | Tennessee | 47037 | 35102 | 353 |
689338 | 689338 | 2020-11-01 | Davidson | Tennessee | 47037 | 34980 | 352 |
686093 | 686093 | 2020-10-31 | Davidson | Tennessee | 47037 | 34900 | 352 |
682850 | 682850 | 2020-10-30 | Davidson | Tennessee | 47037 | 34662 | 350 |
679607 | 679607 | 2020-10-29 | Davidson | Tennessee | 47037 | 34418 | 345 |
676364 | 676364 | 2020-10-28 | Davidson | Tennessee | 47037 | 34156 | 346 |
673121 | 673121 | 2020-10-27 | Davidson | Tennessee | 47037 | 33957 | 341 |
669879 | 669879 | 2020-10-26 | Davidson | Tennessee | 47037 | 33699 | 343 |
666635 | 666635 | 2020-10-25 | Davidson | Tennessee | 47037 | 33259 | 337 |
663390 | 663390 | 2020-10-24 | Davidson | Tennessee | 47037 | 33016 | 336 |
660146 | 660146 | 2020-10-23 | Davidson | Tennessee | 47037 | 32722 | 333 |
656902 | 656902 | 2020-10-22 | Davidson | Tennessee | 47037 | 32559 | 330 |
653657 | 653657 | 2020-10-21 | Davidson | Tennessee | 47037 | 32310 | 328 |
650412 | 650412 | 2020-10-20 | Davidson | Tennessee | 47037 | 32200 | 326 |
647168 | 647168 | 2020-10-19 | Davidson | Tennessee | 47037 | 31759 | 325 |
643922 | 643922 | 2020-10-18 | Davidson | Tennessee | 47037 | 31483 | 325 |
640674 | 640674 | 2020-10-17 | Davidson | Tennessee | 47037 | 31200 | 325 |
637428 | 637428 | 2020-10-16 | Davidson | Tennessee | 47037 | 31178 | 324 |
634182 | 634182 | 2020-10-15 | Davidson | Tennessee | 47037 | 31011 | 324 |
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);