ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Campbell" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091739 | 1091739 | 2021-03-05 | Campbell | Tennessee | 47013 | 3828 | 59 |
1088493 | 1088493 | 2021-03-04 | Campbell | Tennessee | 47013 | 3818 | 59 |
1085248 | 1085248 | 2021-03-03 | Campbell | Tennessee | 47013 | 3810 | 59 |
1082002 | 1082002 | 2021-03-02 | Campbell | Tennessee | 47013 | 3804 | 59 |
1078756 | 1078756 | 2021-03-01 | Campbell | Tennessee | 47013 | 3803 | 59 |
1075511 | 1075511 | 2021-02-28 | Campbell | Tennessee | 47013 | 3800 | 59 |
1072265 | 1072265 | 2021-02-27 | Campbell | Tennessee | 47013 | 3800 | 59 |
1069019 | 1069019 | 2021-02-26 | Campbell | Tennessee | 47013 | 3796 | 59 |
1065774 | 1065774 | 2021-02-25 | Campbell | Tennessee | 47013 | 3791 | 59 |
1062529 | 1062529 | 2021-02-24 | Campbell | Tennessee | 47013 | 3781 | 58 |
1059284 | 1059284 | 2021-02-23 | Campbell | Tennessee | 47013 | 3774 | 58 |
1056038 | 1056038 | 2021-02-22 | Campbell | Tennessee | 47013 | 3760 | 58 |
1052792 | 1052792 | 2021-02-21 | Campbell | Tennessee | 47013 | 3758 | 58 |
1049545 | 1049545 | 2021-02-20 | Campbell | Tennessee | 47013 | 3751 | 57 |
1046298 | 1046298 | 2021-02-19 | Campbell | Tennessee | 47013 | 3742 | 55 |
1043053 | 1043053 | 2021-02-18 | Campbell | Tennessee | 47013 | 3724 | 55 |
1039808 | 1039808 | 2021-02-17 | Campbell | Tennessee | 47013 | 3718 | 54 |
1036563 | 1036563 | 2021-02-16 | Campbell | Tennessee | 47013 | 3706 | 54 |
1033318 | 1033318 | 2021-02-15 | Campbell | Tennessee | 47013 | 3690 | 54 |
1030072 | 1030072 | 2021-02-14 | Campbell | Tennessee | 47013 | 3668 | 54 |
1026825 | 1026825 | 2021-02-13 | Campbell | Tennessee | 47013 | 3639 | 53 |
1023580 | 1023580 | 2021-02-12 | Campbell | Tennessee | 47013 | 3619 | 53 |
1020335 | 1020335 | 2021-02-11 | Campbell | Tennessee | 47013 | 3613 | 52 |
1017090 | 1017090 | 2021-02-10 | Campbell | Tennessee | 47013 | 3586 | 52 |
1013845 | 1013845 | 2021-02-09 | Campbell | Tennessee | 47013 | 3574 | 52 |
1010600 | 1010600 | 2021-02-08 | Campbell | Tennessee | 47013 | 3556 | 52 |
1007354 | 1007354 | 2021-02-07 | Campbell | Tennessee | 47013 | 3555 | 51 |
1004108 | 1004108 | 2021-02-06 | Campbell | Tennessee | 47013 | 3550 | 51 |
1000862 | 1000862 | 2021-02-05 | Campbell | Tennessee | 47013 | 3529 | 51 |
997616 | 997616 | 2021-02-04 | Campbell | Tennessee | 47013 | 3509 | 48 |
994370 | 994370 | 2021-02-03 | Campbell | Tennessee | 47013 | 3495 | 46 |
991124 | 991124 | 2021-02-02 | Campbell | Tennessee | 47013 | 3486 | 45 |
987878 | 987878 | 2021-02-01 | Campbell | Tennessee | 47013 | 3477 | 44 |
984631 | 984631 | 2021-01-31 | Campbell | Tennessee | 47013 | 3470 | 44 |
981384 | 981384 | 2021-01-30 | Campbell | Tennessee | 47013 | 3460 | 44 |
978138 | 978138 | 2021-01-29 | Campbell | Tennessee | 47013 | 3445 | 44 |
974893 | 974893 | 2021-01-28 | Campbell | Tennessee | 47013 | 3424 | 44 |
971648 | 971648 | 2021-01-27 | Campbell | Tennessee | 47013 | 3402 | 44 |
968403 | 968403 | 2021-01-26 | Campbell | Tennessee | 47013 | 3398 | 42 |
965159 | 965159 | 2021-01-25 | Campbell | Tennessee | 47013 | 3387 | 42 |
961914 | 961914 | 2021-01-24 | Campbell | Tennessee | 47013 | 3384 | 41 |
958669 | 958669 | 2021-01-23 | Campbell | Tennessee | 47013 | 3364 | 40 |
955423 | 955423 | 2021-01-22 | Campbell | Tennessee | 47013 | 3349 | 40 |
952178 | 952178 | 2021-01-21 | Campbell | Tennessee | 47013 | 3329 | 40 |
948933 | 948933 | 2021-01-20 | Campbell | Tennessee | 47013 | 3286 | 40 |
945687 | 945687 | 2021-01-19 | Campbell | Tennessee | 47013 | 3258 | 40 |
942440 | 942440 | 2021-01-18 | Campbell | Tennessee | 47013 | 3245 | 40 |
939195 | 939195 | 2021-01-17 | Campbell | Tennessee | 47013 | 3239 | 40 |
935950 | 935950 | 2021-01-16 | Campbell | Tennessee | 47013 | 3197 | 40 |
932705 | 932705 | 2021-01-15 | Campbell | Tennessee | 47013 | 3181 | 39 |
929460 | 929460 | 2021-01-14 | Campbell | Tennessee | 47013 | 3146 | 39 |
926215 | 926215 | 2021-01-13 | Campbell | Tennessee | 47013 | 3116 | 40 |
922969 | 922969 | 2021-01-12 | Campbell | Tennessee | 47013 | 3096 | 39 |
919724 | 919724 | 2021-01-11 | Campbell | Tennessee | 47013 | 3073 | 39 |
916479 | 916479 | 2021-01-10 | Campbell | Tennessee | 47013 | 3062 | 39 |
913234 | 913234 | 2021-01-09 | Campbell | Tennessee | 47013 | 3028 | 39 |
909989 | 909989 | 2021-01-08 | Campbell | Tennessee | 47013 | 3021 | 39 |
906744 | 906744 | 2021-01-07 | Campbell | Tennessee | 47013 | 2990 | 39 |
903498 | 903498 | 2021-01-06 | Campbell | Tennessee | 47013 | 2949 | 38 |
900253 | 900253 | 2021-01-05 | Campbell | Tennessee | 47013 | 2914 | 38 |
897008 | 897008 | 2021-01-04 | Campbell | Tennessee | 47013 | 2898 | 37 |
893762 | 893762 | 2021-01-03 | Campbell | Tennessee | 47013 | 2893 | 37 |
890516 | 890516 | 2021-01-02 | Campbell | Tennessee | 47013 | 2883 | 37 |
887269 | 887269 | 2021-01-01 | Campbell | Tennessee | 47013 | 2782 | 36 |
884024 | 884024 | 2020-12-31 | Campbell | Tennessee | 47013 | 2782 | 36 |
880779 | 880779 | 2020-12-30 | Campbell | Tennessee | 47013 | 2711 | 36 |
877534 | 877534 | 2020-12-29 | Campbell | Tennessee | 47013 | 2673 | 36 |
874289 | 874289 | 2020-12-28 | Campbell | Tennessee | 47013 | 2620 | 35 |
871044 | 871044 | 2020-12-27 | Campbell | Tennessee | 47013 | 2611 | 34 |
867799 | 867799 | 2020-12-26 | Campbell | Tennessee | 47013 | 2579 | 34 |
864554 | 864554 | 2020-12-25 | Campbell | Tennessee | 47013 | 2572 | 34 |
861309 | 861309 | 2020-12-24 | Campbell | Tennessee | 47013 | 2503 | 34 |
858064 | 858064 | 2020-12-23 | Campbell | Tennessee | 47013 | 2436 | 34 |
854819 | 854819 | 2020-12-22 | Campbell | Tennessee | 47013 | 2477 | 32 |
851574 | 851574 | 2020-12-21 | Campbell | Tennessee | 47013 | 2352 | 32 |
848329 | 848329 | 2020-12-20 | Campbell | Tennessee | 47013 | 2303 | 32 |
845084 | 845084 | 2020-12-19 | Campbell | Tennessee | 47013 | 2274 | 30 |
841838 | 841838 | 2020-12-18 | Campbell | Tennessee | 47013 | 2232 | 30 |
838593 | 838593 | 2020-12-17 | Campbell | Tennessee | 47013 | 2194 | 30 |
835347 | 835347 | 2020-12-16 | Campbell | Tennessee | 47013 | 2141 | 27 |
832101 | 832101 | 2020-12-15 | Campbell | Tennessee | 47013 | 2084 | 27 |
828854 | 828854 | 2020-12-14 | Campbell | Tennessee | 47013 | 2037 | 27 |
825608 | 825608 | 2020-12-13 | Campbell | Tennessee | 47013 | 1988 | 27 |
822361 | 822361 | 2020-12-12 | Campbell | Tennessee | 47013 | 1914 | 26 |
819115 | 819115 | 2020-12-11 | Campbell | Tennessee | 47013 | 1899 | 26 |
815869 | 815869 | 2020-12-10 | Campbell | Tennessee | 47013 | 1858 | 26 |
812623 | 812623 | 2020-12-09 | Campbell | Tennessee | 47013 | 1817 | 26 |
809379 | 809379 | 2020-12-08 | Campbell | Tennessee | 47013 | 1790 | 26 |
806134 | 806134 | 2020-12-07 | Campbell | Tennessee | 47013 | 1781 | 26 |
802889 | 802889 | 2020-12-06 | Campbell | Tennessee | 47013 | 1730 | 24 |
799644 | 799644 | 2020-12-05 | Campbell | Tennessee | 47013 | 1712 | 24 |
796399 | 796399 | 2020-12-04 | Campbell | Tennessee | 47013 | 1685 | 24 |
793154 | 793154 | 2020-12-03 | Campbell | Tennessee | 47013 | 1653 | 24 |
789909 | 789909 | 2020-12-02 | Campbell | Tennessee | 47013 | 1637 | 23 |
786664 | 786664 | 2020-12-01 | Campbell | Tennessee | 47013 | 1631 | 23 |
783420 | 783420 | 2020-11-30 | Campbell | Tennessee | 47013 | 1603 | 23 |
780175 | 780175 | 2020-11-29 | Campbell | Tennessee | 47013 | 1552 | 23 |
776929 | 776929 | 2020-11-28 | Campbell | Tennessee | 47013 | 1542 | 23 |
773684 | 773684 | 2020-11-27 | Campbell | Tennessee | 47013 | 1527 | 23 |
770439 | 770439 | 2020-11-26 | Campbell | Tennessee | 47013 | 1515 | 23 |
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);