ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Blount" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955421 | 955421 | 2021-01-22 | Blount | Tennessee | 47009 | 12267 | 132 |
952176 | 952176 | 2021-01-21 | Blount | Tennessee | 47009 | 12197 | 131 |
948931 | 948931 | 2021-01-20 | Blount | Tennessee | 47009 | 12146 | 127 |
945685 | 945685 | 2021-01-19 | Blount | Tennessee | 47009 | 12029 | 126 |
942438 | 942438 | 2021-01-18 | Blount | Tennessee | 47009 | 11914 | 125 |
939193 | 939193 | 2021-01-17 | Blount | Tennessee | 47009 | 11887 | 124 |
935948 | 935948 | 2021-01-16 | Blount | Tennessee | 47009 | 11784 | 123 |
932703 | 932703 | 2021-01-15 | Blount | Tennessee | 47009 | 11708 | 122 |
929458 | 929458 | 2021-01-14 | Blount | Tennessee | 47009 | 11537 | 120 |
926213 | 926213 | 2021-01-13 | Blount | Tennessee | 47009 | 11300 | 117 |
922967 | 922967 | 2021-01-12 | Blount | Tennessee | 47009 | 11245 | 112 |
919722 | 919722 | 2021-01-11 | Blount | Tennessee | 47009 | 11203 | 111 |
916477 | 916477 | 2021-01-10 | Blount | Tennessee | 47009 | 11127 | 110 |
913232 | 913232 | 2021-01-09 | Blount | Tennessee | 47009 | 11013 | 108 |
909987 | 909987 | 2021-01-08 | Blount | Tennessee | 47009 | 10905 | 107 |
906742 | 906742 | 2021-01-07 | Blount | Tennessee | 47009 | 10803 | 103 |
903496 | 903496 | 2021-01-06 | Blount | Tennessee | 47009 | 10632 | 101 |
900251 | 900251 | 2021-01-05 | Blount | Tennessee | 47009 | 10494 | 100 |
897006 | 897006 | 2021-01-04 | Blount | Tennessee | 47009 | 10433 | 99 |
893760 | 893760 | 2021-01-03 | Blount | Tennessee | 47009 | 10379 | 99 |
890514 | 890514 | 2021-01-02 | Blount | Tennessee | 47009 | 10324 | 99 |
887267 | 887267 | 2021-01-01 | Blount | Tennessee | 47009 | 9976 | 98 |
884022 | 884022 | 2020-12-31 | Blount | Tennessee | 47009 | 9976 | 98 |
880777 | 880777 | 2020-12-30 | Blount | Tennessee | 47009 | 9859 | 97 |
877532 | 877532 | 2020-12-29 | Blount | Tennessee | 47009 | 9602 | 96 |
874287 | 874287 | 2020-12-28 | Blount | Tennessee | 47009 | 9449 | 94 |
871042 | 871042 | 2020-12-27 | Blount | Tennessee | 47009 | 9365 | 94 |
867797 | 867797 | 2020-12-26 | Blount | Tennessee | 47009 | 9266 | 93 |
864552 | 864552 | 2020-12-25 | Blount | Tennessee | 47009 | 9164 | 93 |
861307 | 861307 | 2020-12-24 | Blount | Tennessee | 47009 | 9059 | 93 |
858062 | 858062 | 2020-12-23 | Blount | Tennessee | 47009 | 8984 | 93 |
854817 | 854817 | 2020-12-22 | Blount | Tennessee | 47009 | 8796 | 90 |
851572 | 851572 | 2020-12-21 | Blount | Tennessee | 47009 | 8721 | 87 |
848327 | 848327 | 2020-12-20 | Blount | Tennessee | 47009 | 8538 | 86 |
845082 | 845082 | 2020-12-19 | Blount | Tennessee | 47009 | 8387 | 84 |
841836 | 841836 | 2020-12-18 | Blount | Tennessee | 47009 | 8222 | 82 |
838591 | 838591 | 2020-12-17 | Blount | Tennessee | 47009 | 7982 | 80 |
835345 | 835345 | 2020-12-16 | Blount | Tennessee | 47009 | 7823 | 72 |
832099 | 832099 | 2020-12-15 | Blount | Tennessee | 47009 | 7610 | 71 |
828852 | 828852 | 2020-12-14 | Blount | Tennessee | 47009 | 7534 | 70 |
825606 | 825606 | 2020-12-13 | Blount | Tennessee | 47009 | 7342 | 68 |
822359 | 822359 | 2020-12-12 | Blount | Tennessee | 47009 | 7111 | 68 |
819113 | 819113 | 2020-12-11 | Blount | Tennessee | 47009 | 7015 | 68 |
815867 | 815867 | 2020-12-10 | Blount | Tennessee | 47009 | 6924 | 68 |
812621 | 812621 | 2020-12-09 | Blount | Tennessee | 47009 | 6821 | 68 |
809377 | 809377 | 2020-12-08 | Blount | Tennessee | 47009 | 6669 | 66 |
806132 | 806132 | 2020-12-07 | Blount | Tennessee | 47009 | 6559 | 66 |
802887 | 802887 | 2020-12-06 | Blount | Tennessee | 47009 | 6377 | 65 |
799642 | 799642 | 2020-12-05 | Blount | Tennessee | 47009 | 6283 | 64 |
796397 | 796397 | 2020-12-04 | Blount | Tennessee | 47009 | 6176 | 65 |
793152 | 793152 | 2020-12-03 | Blount | Tennessee | 47009 | 6089 | 63 |
789907 | 789907 | 2020-12-02 | Blount | Tennessee | 47009 | 5986 | 62 |
786662 | 786662 | 2020-12-01 | Blount | Tennessee | 47009 | 5863 | 62 |
783418 | 783418 | 2020-11-30 | Blount | Tennessee | 47009 | 5752 | 61 |
780173 | 780173 | 2020-11-29 | Blount | Tennessee | 47009 | 5531 | 61 |
776927 | 776927 | 2020-11-28 | Blount | Tennessee | 47009 | 5491 | 60 |
773682 | 773682 | 2020-11-27 | Blount | Tennessee | 47009 | 5406 | 60 |
770437 | 770437 | 2020-11-26 | Blount | Tennessee | 47009 | 5319 | 60 |
767191 | 767191 | 2020-11-25 | Blount | Tennessee | 47009 | 5258 | 59 |
763946 | 763946 | 2020-11-24 | Blount | Tennessee | 47009 | 5180 | 55 |
760701 | 760701 | 2020-11-23 | Blount | Tennessee | 47009 | 5123 | 56 |
757456 | 757456 | 2020-11-22 | Blount | Tennessee | 47009 | 5080 | 55 |
754209 | 754209 | 2020-11-21 | Blount | Tennessee | 47009 | 4963 | 55 |
750963 | 750963 | 2020-11-20 | Blount | Tennessee | 47009 | 4900 | 55 |
747717 | 747717 | 2020-11-19 | Blount | Tennessee | 47009 | 4804 | 50 |
744471 | 744471 | 2020-11-18 | Blount | Tennessee | 47009 | 4727 | 49 |
741224 | 741224 | 2020-11-17 | Blount | Tennessee | 47009 | 4557 | 49 |
737978 | 737978 | 2020-11-16 | Blount | Tennessee | 47009 | 4467 | 48 |
734734 | 734734 | 2020-11-15 | Blount | Tennessee | 47009 | 4303 | 47 |
731488 | 731488 | 2020-11-14 | Blount | Tennessee | 47009 | 4239 | 47 |
728244 | 728244 | 2020-11-13 | Blount | Tennessee | 47009 | 4183 | 47 |
725000 | 725000 | 2020-11-12 | Blount | Tennessee | 47009 | 4121 | 46 |
721757 | 721757 | 2020-11-11 | Blount | Tennessee | 47009 | 4076 | 45 |
718514 | 718514 | 2020-11-10 | Blount | Tennessee | 47009 | 4005 | 45 |
715271 | 715271 | 2020-11-09 | Blount | Tennessee | 47009 | 3980 | 46 |
712027 | 712027 | 2020-11-08 | Blount | Tennessee | 47009 | 3916 | 46 |
708783 | 708783 | 2020-11-07 | Blount | Tennessee | 47009 | 3865 | 46 |
705540 | 705540 | 2020-11-06 | Blount | Tennessee | 47009 | 3799 | 45 |
702297 | 702297 | 2020-11-05 | Blount | Tennessee | 47009 | 3753 | 44 |
699053 | 699053 | 2020-11-04 | Blount | Tennessee | 47009 | 3726 | 43 |
695810 | 695810 | 2020-11-03 | Blount | Tennessee | 47009 | 3662 | 43 |
692568 | 692568 | 2020-11-02 | Blount | Tennessee | 47009 | 3650 | 42 |
689324 | 689324 | 2020-11-01 | Blount | Tennessee | 47009 | 3602 | 41 |
686079 | 686079 | 2020-10-31 | Blount | Tennessee | 47009 | 3595 | 41 |
682836 | 682836 | 2020-10-30 | Blount | Tennessee | 47009 | 3554 | 41 |
679593 | 679593 | 2020-10-29 | Blount | Tennessee | 47009 | 3515 | 36 |
676350 | 676350 | 2020-10-28 | Blount | Tennessee | 47009 | 3464 | 36 |
673107 | 673107 | 2020-10-27 | Blount | Tennessee | 47009 | 3404 | 36 |
669865 | 669865 | 2020-10-26 | Blount | Tennessee | 47009 | 3374 | 36 |
666621 | 666621 | 2020-10-25 | Blount | Tennessee | 47009 | 3343 | 36 |
663376 | 663376 | 2020-10-24 | Blount | Tennessee | 47009 | 3309 | 36 |
660132 | 660132 | 2020-10-23 | Blount | Tennessee | 47009 | 3273 | 34 |
656888 | 656888 | 2020-10-22 | Blount | Tennessee | 47009 | 3191 | 32 |
653643 | 653643 | 2020-10-21 | Blount | Tennessee | 47009 | 3170 | 32 |
650398 | 650398 | 2020-10-20 | Blount | Tennessee | 47009 | 3139 | 32 |
647154 | 647154 | 2020-10-19 | Blount | Tennessee | 47009 | 3102 | 31 |
643908 | 643908 | 2020-10-18 | Blount | Tennessee | 47009 | 3067 | 31 |
640660 | 640660 | 2020-10-17 | Blount | Tennessee | 47009 | 3041 | 31 |
637414 | 637414 | 2020-10-16 | Blount | Tennessee | 47009 | 3001 | 31 |
634168 | 634168 | 2020-10-15 | Blount | Tennessee | 47009 | 2974 | 31 |
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);