ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 47147 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955490 | 955490 | 2021-01-22 | Robertson | Tennessee | 47147 | 7826 | 87 |
952245 | 952245 | 2021-01-21 | Robertson | Tennessee | 47147 | 7779 | 86 |
949000 | 949000 | 2021-01-20 | Robertson | Tennessee | 47147 | 7741 | 85 |
945754 | 945754 | 2021-01-19 | Robertson | Tennessee | 47147 | 7666 | 85 |
942507 | 942507 | 2021-01-18 | Robertson | Tennessee | 47147 | 7645 | 85 |
939262 | 939262 | 2021-01-17 | Robertson | Tennessee | 47147 | 7618 | 85 |
936017 | 936017 | 2021-01-16 | Robertson | Tennessee | 47147 | 7570 | 85 |
932772 | 932772 | 2021-01-15 | Robertson | Tennessee | 47147 | 7516 | 85 |
929527 | 929527 | 2021-01-14 | Robertson | Tennessee | 47147 | 7433 | 85 |
926282 | 926282 | 2021-01-13 | Robertson | Tennessee | 47147 | 7374 | 84 |
923036 | 923036 | 2021-01-12 | Robertson | Tennessee | 47147 | 7319 | 81 |
919791 | 919791 | 2021-01-11 | Robertson | Tennessee | 47147 | 7297 | 81 |
916546 | 916546 | 2021-01-10 | Robertson | Tennessee | 47147 | 7271 | 80 |
913301 | 913301 | 2021-01-09 | Robertson | Tennessee | 47147 | 7192 | 79 |
910056 | 910056 | 2021-01-08 | Robertson | Tennessee | 47147 | 7117 | 78 |
906811 | 906811 | 2021-01-07 | Robertson | Tennessee | 47147 | 7063 | 77 |
903565 | 903565 | 2021-01-06 | Robertson | Tennessee | 47147 | 6934 | 76 |
900320 | 900320 | 2021-01-05 | Robertson | Tennessee | 47147 | 6847 | 75 |
897075 | 897075 | 2021-01-04 | Robertson | Tennessee | 47147 | 6803 | 75 |
893829 | 893829 | 2021-01-03 | Robertson | Tennessee | 47147 | 6756 | 75 |
890583 | 890583 | 2021-01-02 | Robertson | Tennessee | 47147 | 6717 | 75 |
887336 | 887336 | 2021-01-01 | Robertson | Tennessee | 47147 | 6533 | 74 |
884091 | 884091 | 2020-12-31 | Robertson | Tennessee | 47147 | 6533 | 74 |
880846 | 880846 | 2020-12-30 | Robertson | Tennessee | 47147 | 6473 | 73 |
877601 | 877601 | 2020-12-29 | Robertson | Tennessee | 47147 | 6353 | 73 |
874356 | 874356 | 2020-12-28 | Robertson | Tennessee | 47147 | 6316 | 73 |
871111 | 871111 | 2020-12-27 | Robertson | Tennessee | 47147 | 6267 | 73 |
867866 | 867866 | 2020-12-26 | Robertson | Tennessee | 47147 | 6249 | 71 |
864621 | 864621 | 2020-12-25 | Robertson | Tennessee | 47147 | 6192 | 71 |
861376 | 861376 | 2020-12-24 | Robertson | Tennessee | 47147 | 6068 | 71 |
858131 | 858131 | 2020-12-23 | Robertson | Tennessee | 47147 | 6012 | 71 |
854886 | 854886 | 2020-12-22 | Robertson | Tennessee | 47147 | 5917 | 71 |
851641 | 851641 | 2020-12-21 | Robertson | Tennessee | 47147 | 5826 | 70 |
848396 | 848396 | 2020-12-20 | Robertson | Tennessee | 47147 | 5706 | 69 |
845151 | 845151 | 2020-12-19 | Robertson | Tennessee | 47147 | 5595 | 69 |
841905 | 841905 | 2020-12-18 | Robertson | Tennessee | 47147 | 5520 | 67 |
838660 | 838660 | 2020-12-17 | Robertson | Tennessee | 47147 | 5339 | 66 |
835414 | 835414 | 2020-12-16 | Robertson | Tennessee | 47147 | 5210 | 65 |
832168 | 832168 | 2020-12-15 | Robertson | Tennessee | 47147 | 5094 | 65 |
828921 | 828921 | 2020-12-14 | Robertson | Tennessee | 47147 | 4995 | 64 |
825675 | 825675 | 2020-12-13 | Robertson | Tennessee | 47147 | 4879 | 64 |
822428 | 822428 | 2020-12-12 | Robertson | Tennessee | 47147 | 4723 | 63 |
819182 | 819182 | 2020-12-11 | Robertson | Tennessee | 47147 | 4640 | 62 |
815936 | 815936 | 2020-12-10 | Robertson | Tennessee | 47147 | 4557 | 57 |
812690 | 812690 | 2020-12-09 | Robertson | Tennessee | 47147 | 4475 | 57 |
809446 | 809446 | 2020-12-08 | Robertson | Tennessee | 47147 | 4345 | 57 |
806201 | 806201 | 2020-12-07 | Robertson | Tennessee | 47147 | 4258 | 57 |
802956 | 802956 | 2020-12-06 | Robertson | Tennessee | 47147 | 4188 | 57 |
799711 | 799711 | 2020-12-05 | Robertson | Tennessee | 47147 | 4164 | 57 |
796466 | 796466 | 2020-12-04 | Robertson | Tennessee | 47147 | 4109 | 57 |
793221 | 793221 | 2020-12-03 | Robertson | Tennessee | 47147 | 4043 | 56 |
789976 | 789976 | 2020-12-02 | Robertson | Tennessee | 47147 | 4002 | 53 |
786731 | 786731 | 2020-12-01 | Robertson | Tennessee | 47147 | 3954 | 53 |
783487 | 783487 | 2020-11-30 | Robertson | Tennessee | 47147 | 3895 | 53 |
780242 | 780242 | 2020-11-29 | Robertson | Tennessee | 47147 | 3812 | 53 |
776996 | 776996 | 2020-11-28 | Robertson | Tennessee | 47147 | 3774 | 53 |
773751 | 773751 | 2020-11-27 | Robertson | Tennessee | 47147 | 3710 | 52 |
770506 | 770506 | 2020-11-26 | Robertson | Tennessee | 47147 | 3646 | 52 |
767260 | 767260 | 2020-11-25 | Robertson | Tennessee | 47147 | 3604 | 51 |
764015 | 764015 | 2020-11-24 | Robertson | Tennessee | 47147 | 3577 | 51 |
760770 | 760770 | 2020-11-23 | Robertson | Tennessee | 47147 | 3573 | 51 |
757525 | 757525 | 2020-11-22 | Robertson | Tennessee | 47147 | 3525 | 50 |
754278 | 754278 | 2020-11-21 | Robertson | Tennessee | 47147 | 3467 | 50 |
751032 | 751032 | 2020-11-20 | Robertson | Tennessee | 47147 | 3415 | 50 |
747786 | 747786 | 2020-11-19 | Robertson | Tennessee | 47147 | 3353 | 49 |
744540 | 744540 | 2020-11-18 | Robertson | Tennessee | 47147 | 3319 | 49 |
741293 | 741293 | 2020-11-17 | Robertson | Tennessee | 47147 | 3282 | 48 |
738047 | 738047 | 2020-11-16 | Robertson | Tennessee | 47147 | 3255 | 46 |
734803 | 734803 | 2020-11-15 | Robertson | Tennessee | 47147 | 3161 | 46 |
731557 | 731557 | 2020-11-14 | Robertson | Tennessee | 47147 | 3078 | 46 |
728313 | 728313 | 2020-11-13 | Robertson | Tennessee | 47147 | 3045 | 46 |
725069 | 725069 | 2020-11-12 | Robertson | Tennessee | 47147 | 3004 | 44 |
721826 | 721826 | 2020-11-11 | Robertson | Tennessee | 47147 | 2991 | 44 |
718583 | 718583 | 2020-11-10 | Robertson | Tennessee | 47147 | 2947 | 43 |
715340 | 715340 | 2020-11-09 | Robertson | Tennessee | 47147 | 2917 | 43 |
712096 | 712096 | 2020-11-08 | Robertson | Tennessee | 47147 | 2868 | 43 |
708852 | 708852 | 2020-11-07 | Robertson | Tennessee | 47147 | 2844 | 43 |
705609 | 705609 | 2020-11-06 | Robertson | Tennessee | 47147 | 2790 | 43 |
702366 | 702366 | 2020-11-05 | Robertson | Tennessee | 47147 | 2774 | 43 |
699122 | 699122 | 2020-11-04 | Robertson | Tennessee | 47147 | 2758 | 43 |
695879 | 695879 | 2020-11-03 | Robertson | Tennessee | 47147 | 2731 | 43 |
692637 | 692637 | 2020-11-02 | Robertson | Tennessee | 47147 | 2729 | 43 |
689393 | 689393 | 2020-11-01 | Robertson | Tennessee | 47147 | 2712 | 43 |
686148 | 686148 | 2020-10-31 | Robertson | Tennessee | 47147 | 2705 | 43 |
682905 | 682905 | 2020-10-30 | Robertson | Tennessee | 47147 | 2702 | 43 |
679662 | 679662 | 2020-10-29 | Robertson | Tennessee | 47147 | 2681 | 43 |
676419 | 676419 | 2020-10-28 | Robertson | Tennessee | 47147 | 2669 | 43 |
673176 | 673176 | 2020-10-27 | Robertson | Tennessee | 47147 | 2640 | 44 |
669934 | 669934 | 2020-10-26 | Robertson | Tennessee | 47147 | 2628 | 42 |
666690 | 666690 | 2020-10-25 | Robertson | Tennessee | 47147 | 2614 | 41 |
663445 | 663445 | 2020-10-24 | Robertson | Tennessee | 47147 | 2589 | 41 |
660201 | 660201 | 2020-10-23 | Robertson | Tennessee | 47147 | 2577 | 41 |
656957 | 656957 | 2020-10-22 | Robertson | Tennessee | 47147 | 2537 | 41 |
653712 | 653712 | 2020-10-21 | Robertson | Tennessee | 47147 | 2510 | 40 |
650467 | 650467 | 2020-10-20 | Robertson | Tennessee | 47147 | 2498 | 39 |
647223 | 647223 | 2020-10-19 | Robertson | Tennessee | 47147 | 2485 | 39 |
643977 | 643977 | 2020-10-18 | Robertson | Tennessee | 47147 | 2462 | 39 |
640729 | 640729 | 2020-10-17 | Robertson | Tennessee | 47147 | 2450 | 39 |
637483 | 637483 | 2020-10-16 | Robertson | Tennessee | 47147 | 2426 | 40 |
634237 | 634237 | 2020-10-15 | Robertson | Tennessee | 47147 | 2419 | 39 |
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);