ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Washington" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194717 | 1194717 | 2021-04-06 | Washington | Missouri | 29221 | 2731 | 49 |
1191468 | 1191468 | 2021-04-05 | Washington | Missouri | 29221 | 2731 | 49 |
1188220 | 1188220 | 2021-04-04 | Washington | Missouri | 29221 | 2729 | 49 |
1184973 | 1184973 | 2021-04-03 | Washington | Missouri | 29221 | 2730 | 49 |
1181727 | 1181727 | 2021-04-02 | Washington | Missouri | 29221 | 2728 | 49 |
1178480 | 1178480 | 2021-04-01 | Washington | Missouri | 29221 | 2725 | 49 |
1175233 | 1175233 | 2021-03-31 | Washington | Missouri | 29221 | 2723 | 49 |
1171986 | 1171986 | 2021-03-30 | Washington | Missouri | 29221 | 2722 | 49 |
1168738 | 1168738 | 2021-03-29 | Washington | Missouri | 29221 | 2723 | 49 |
1165490 | 1165490 | 2021-03-28 | Washington | Missouri | 29221 | 2723 | 49 |
1162242 | 1162242 | 2021-03-27 | Washington | Missouri | 29221 | 2721 | 49 |
1158994 | 1158994 | 2021-03-26 | Washington | Missouri | 29221 | 2721 | 49 |
1155747 | 1155747 | 2021-03-25 | Washington | Missouri | 29221 | 2722 | 49 |
1152500 | 1152500 | 2021-03-24 | Washington | Missouri | 29221 | 2720 | 49 |
1149253 | 1149253 | 2021-03-23 | Washington | Missouri | 29221 | 2719 | 49 |
1146006 | 1146006 | 2021-03-22 | Washington | Missouri | 29221 | 2719 | 48 |
1142759 | 1142759 | 2021-03-21 | Washington | Missouri | 29221 | 2719 | 48 |
1139512 | 1139512 | 2021-03-20 | Washington | Missouri | 29221 | 2718 | 48 |
1136266 | 1136266 | 2021-03-19 | Washington | Missouri | 29221 | 2718 | 48 |
1133020 | 1133020 | 2021-03-18 | Washington | Missouri | 29221 | 2715 | 48 |
1129772 | 1129772 | 2021-03-17 | Washington | Missouri | 29221 | 2712 | 48 |
1126525 | 1126525 | 2021-03-16 | Washington | Missouri | 29221 | 2712 | 48 |
1123279 | 1123279 | 2021-03-15 | Washington | Missouri | 29221 | 2711 | 48 |
1120032 | 1120032 | 2021-03-14 | Washington | Missouri | 29221 | 2711 | 48 |
1116785 | 1116785 | 2021-03-13 | Washington | Missouri | 29221 | 2711 | 48 |
1113539 | 1113539 | 2021-03-12 | Washington | Missouri | 29221 | 2711 | 48 |
1110293 | 1110293 | 2021-03-11 | Washington | Missouri | 29221 | 2711 | 48 |
1107047 | 1107047 | 2021-03-10 | Washington | Missouri | 29221 | 2711 | 48 |
1103801 | 1103801 | 2021-03-09 | Washington | Missouri | 29221 | 2709 | 48 |
1100555 | 1100555 | 2021-03-08 | Washington | Missouri | 29221 | 2708 | 48 |
1097308 | 1097308 | 2021-03-07 | Washington | Missouri | 29221 | 2122 | 48 |
1094061 | 1094061 | 2021-03-06 | Washington | Missouri | 29221 | 2122 | 48 |
1090815 | 1090815 | 2021-03-05 | Washington | Missouri | 29221 | 2122 | 48 |
1087570 | 1087570 | 2021-03-04 | Washington | Missouri | 29221 | 2122 | 48 |
1084325 | 1084325 | 2021-03-03 | Washington | Missouri | 29221 | 2121 | 48 |
1081079 | 1081079 | 2021-03-02 | Washington | Missouri | 29221 | 2122 | 48 |
1077833 | 1077833 | 2021-03-01 | Washington | Missouri | 29221 | 2122 | 47 |
1074587 | 1074587 | 2021-02-28 | Washington | Missouri | 29221 | 2122 | 47 |
1071341 | 1071341 | 2021-02-27 | Washington | Missouri | 29221 | 2122 | 46 |
1068096 | 1068096 | 2021-02-26 | Washington | Missouri | 29221 | 2118 | 46 |
1064851 | 1064851 | 2021-02-25 | Washington | Missouri | 29221 | 2118 | 46 |
1061607 | 1061607 | 2021-02-24 | Washington | Missouri | 29221 | 2117 | 46 |
1058361 | 1058361 | 2021-02-23 | Washington | Missouri | 29221 | 2119 | 46 |
1055115 | 1055115 | 2021-02-22 | Washington | Missouri | 29221 | 2117 | 45 |
1051868 | 1051868 | 2021-02-21 | Washington | Missouri | 29221 | 2117 | 45 |
1048621 | 1048621 | 2021-02-20 | Washington | Missouri | 29221 | 2116 | 45 |
1045375 | 1045375 | 2021-02-19 | Washington | Missouri | 29221 | 2113 | 45 |
1042130 | 1042130 | 2021-02-18 | Washington | Missouri | 29221 | 2112 | 45 |
1038885 | 1038885 | 2021-02-17 | Washington | Missouri | 29221 | 2111 | 45 |
1035640 | 1035640 | 2021-02-16 | Washington | Missouri | 29221 | 2111 | 45 |
1032395 | 1032395 | 2021-02-15 | Washington | Missouri | 29221 | 2108 | 45 |
1029148 | 1029148 | 2021-02-14 | Washington | Missouri | 29221 | 2104 | 45 |
1025902 | 1025902 | 2021-02-13 | Washington | Missouri | 29221 | 2104 | 45 |
1022657 | 1022657 | 2021-02-12 | Washington | Missouri | 29221 | 2105 | 45 |
1019412 | 1019412 | 2021-02-11 | Washington | Missouri | 29221 | 2104 | 45 |
1016167 | 1016167 | 2021-02-10 | Washington | Missouri | 29221 | 2098 | 42 |
1012922 | 1012922 | 2021-02-09 | Washington | Missouri | 29221 | 2097 | 42 |
1009677 | 1009677 | 2021-02-08 | Washington | Missouri | 29221 | 2096 | 42 |
1006430 | 1006430 | 2021-02-07 | Washington | Missouri | 29221 | 2091 | 42 |
1003184 | 1003184 | 2021-02-06 | Washington | Missouri | 29221 | 2088 | 42 |
999939 | 999939 | 2021-02-05 | Washington | Missouri | 29221 | 2085 | 42 |
996693 | 996693 | 2021-02-04 | Washington | Missouri | 29221 | 2082 | 42 |
993447 | 993447 | 2021-02-03 | Washington | Missouri | 29221 | 2077 | 42 |
990201 | 990201 | 2021-02-02 | Washington | Missouri | 29221 | 2073 | 42 |
986954 | 986954 | 2021-02-01 | Washington | Missouri | 29221 | 2073 | 41 |
983707 | 983707 | 2021-01-31 | Washington | Missouri | 29221 | 2069 | 41 |
980461 | 980461 | 2021-01-30 | Washington | Missouri | 29221 | 2066 | 41 |
977215 | 977215 | 2021-01-29 | Washington | Missouri | 29221 | 2065 | 41 |
973970 | 973970 | 2021-01-28 | Washington | Missouri | 29221 | 2060 | 41 |
970725 | 970725 | 2021-01-27 | Washington | Missouri | 29221 | 2049 | 41 |
967480 | 967480 | 2021-01-26 | Washington | Missouri | 29221 | 2047 | 41 |
964236 | 964236 | 2021-01-25 | Washington | Missouri | 29221 | 2041 | 41 |
960991 | 960991 | 2021-01-24 | Washington | Missouri | 29221 | 2032 | 41 |
957745 | 957745 | 2021-01-23 | Washington | Missouri | 29221 | 2023 | 41 |
954500 | 954500 | 2021-01-22 | Washington | Missouri | 29221 | 2017 | 41 |
951255 | 951255 | 2021-01-21 | Washington | Missouri | 29221 | 2012 | 41 |
948009 | 948009 | 2021-01-20 | Washington | Missouri | 29221 | 2005 | 41 |
944762 | 944762 | 2021-01-19 | Washington | Missouri | 29221 | 2000 | 41 |
941517 | 941517 | 2021-01-18 | Washington | Missouri | 29221 | 1993 | 41 |
938272 | 938272 | 2021-01-17 | Washington | Missouri | 29221 | 1985 | 41 |
935027 | 935027 | 2021-01-16 | Washington | Missouri | 29221 | 1979 | 41 |
931782 | 931782 | 2021-01-15 | Washington | Missouri | 29221 | 1967 | 41 |
928537 | 928537 | 2021-01-14 | Washington | Missouri | 29221 | 1955 | 41 |
925291 | 925291 | 2021-01-13 | Washington | Missouri | 29221 | 1935 | 41 |
922046 | 922046 | 2021-01-12 | Washington | Missouri | 29221 | 1934 | 41 |
918801 | 918801 | 2021-01-11 | Washington | Missouri | 29221 | 1930 | 41 |
915556 | 915556 | 2021-01-10 | Washington | Missouri | 29221 | 1917 | 41 |
912311 | 912311 | 2021-01-09 | Washington | Missouri | 29221 | 1906 | 41 |
909066 | 909066 | 2021-01-08 | Washington | Missouri | 29221 | 1894 | 41 |
905820 | 905820 | 2021-01-07 | Washington | Missouri | 29221 | 1870 | 41 |
902575 | 902575 | 2021-01-06 | Washington | Missouri | 29221 | 1838 | 41 |
899330 | 899330 | 2021-01-05 | Washington | Missouri | 29221 | 1836 | 41 |
896085 | 896085 | 2021-01-04 | Washington | Missouri | 29221 | 1825 | 39 |
892838 | 892838 | 2021-01-03 | Washington | Missouri | 29221 | 1825 | 39 |
889592 | 889592 | 2021-01-02 | Washington | Missouri | 29221 | 1811 | 39 |
886346 | 886346 | 2021-01-01 | Washington | Missouri | 29221 | 1798 | 39 |
883101 | 883101 | 2020-12-31 | Washington | Missouri | 29221 | 1780 | 39 |
879856 | 879856 | 2020-12-30 | Washington | Missouri | 29221 | 1766 | 39 |
876611 | 876611 | 2020-12-29 | Washington | Missouri | 29221 | 1749 | 39 |
873366 | 873366 | 2020-12-28 | Washington | Missouri | 29221 | 1735 | 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);