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 |
---|---|---|---|---|---|---|---|
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 |
767193 | 767193 | 2020-11-25 | Campbell | Tennessee | 47013 | 1500 | 23 |
763948 | 763948 | 2020-11-24 | Campbell | Tennessee | 47013 | 1483 | 22 |
760703 | 760703 | 2020-11-23 | Campbell | Tennessee | 47013 | 1476 | 21 |
757458 | 757458 | 2020-11-22 | Campbell | Tennessee | 47013 | 1465 | 21 |
754211 | 754211 | 2020-11-21 | Campbell | Tennessee | 47013 | 1421 | 21 |
750965 | 750965 | 2020-11-20 | Campbell | Tennessee | 47013 | 1389 | 21 |
747719 | 747719 | 2020-11-19 | Campbell | Tennessee | 47013 | 1383 | 20 |
744473 | 744473 | 2020-11-18 | Campbell | Tennessee | 47013 | 1377 | 20 |
741226 | 741226 | 2020-11-17 | Campbell | Tennessee | 47013 | 1363 | 20 |
737980 | 737980 | 2020-11-16 | Campbell | Tennessee | 47013 | 1354 | 20 |
734736 | 734736 | 2020-11-15 | Campbell | Tennessee | 47013 | 1329 | 20 |
731490 | 731490 | 2020-11-14 | Campbell | Tennessee | 47013 | 1319 | 19 |
728246 | 728246 | 2020-11-13 | Campbell | Tennessee | 47013 | 1302 | 18 |
725002 | 725002 | 2020-11-12 | Campbell | Tennessee | 47013 | 1288 | 17 |
721759 | 721759 | 2020-11-11 | Campbell | Tennessee | 47013 | 1264 | 17 |
718516 | 718516 | 2020-11-10 | Campbell | Tennessee | 47013 | 1258 | 17 |
715273 | 715273 | 2020-11-09 | Campbell | Tennessee | 47013 | 1256 | 16 |
712029 | 712029 | 2020-11-08 | Campbell | Tennessee | 47013 | 1238 | 15 |
708785 | 708785 | 2020-11-07 | Campbell | Tennessee | 47013 | 1218 | 15 |
705542 | 705542 | 2020-11-06 | Campbell | Tennessee | 47013 | 1192 | 14 |
702299 | 702299 | 2020-11-05 | Campbell | Tennessee | 47013 | 1176 | 14 |
699055 | 699055 | 2020-11-04 | Campbell | Tennessee | 47013 | 1159 | 14 |
695812 | 695812 | 2020-11-03 | Campbell | Tennessee | 47013 | 1149 | 14 |
692570 | 692570 | 2020-11-02 | Campbell | Tennessee | 47013 | 1140 | 13 |
689326 | 689326 | 2020-11-01 | Campbell | Tennessee | 47013 | 1133 | 13 |
686081 | 686081 | 2020-10-31 | Campbell | Tennessee | 47013 | 1130 | 13 |
682838 | 682838 | 2020-10-30 | Campbell | Tennessee | 47013 | 1116 | 13 |
679595 | 679595 | 2020-10-29 | Campbell | Tennessee | 47013 | 1104 | 13 |
676352 | 676352 | 2020-10-28 | Campbell | Tennessee | 47013 | 1071 | 13 |
673109 | 673109 | 2020-10-27 | Campbell | Tennessee | 47013 | 1044 | 12 |
669867 | 669867 | 2020-10-26 | Campbell | Tennessee | 47013 | 1035 | 12 |
666623 | 666623 | 2020-10-25 | Campbell | Tennessee | 47013 | 1030 | 12 |
663378 | 663378 | 2020-10-24 | Campbell | Tennessee | 47013 | 1000 | 11 |
660134 | 660134 | 2020-10-23 | Campbell | Tennessee | 47013 | 975 | 9 |
656890 | 656890 | 2020-10-22 | Campbell | Tennessee | 47013 | 911 | 8 |
653645 | 653645 | 2020-10-21 | Campbell | Tennessee | 47013 | 899 | 7 |
650400 | 650400 | 2020-10-20 | Campbell | Tennessee | 47013 | 885 | 7 |
647156 | 647156 | 2020-10-19 | Campbell | Tennessee | 47013 | 864 | 7 |
643910 | 643910 | 2020-10-18 | Campbell | Tennessee | 47013 | 849 | 7 |
640662 | 640662 | 2020-10-17 | Campbell | Tennessee | 47013 | 824 | 6 |
637416 | 637416 | 2020-10-16 | Campbell | Tennessee | 47013 | 796 | 6 |
634170 | 634170 | 2020-10-15 | Campbell | Tennessee | 47013 | 786 | 6 |
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);