ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Washington" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193899 | 1193899 | 2021-04-06 | Washington | Indiana | 18175 | 2252 | 29 |
1190649 | 1190649 | 2021-04-05 | Washington | Indiana | 18175 | 2249 | 29 |
1187402 | 1187402 | 2021-04-04 | Washington | Indiana | 18175 | 2247 | 29 |
1184155 | 1184155 | 2021-04-03 | Washington | Indiana | 18175 | 2243 | 29 |
1180908 | 1180908 | 2021-04-02 | Washington | Indiana | 18175 | 2241 | 29 |
1177661 | 1177661 | 2021-04-01 | Washington | Indiana | 18175 | 2234 | 29 |
1174414 | 1174414 | 2021-03-31 | Washington | Indiana | 18175 | 2226 | 29 |
1171167 | 1171167 | 2021-03-30 | Washington | Indiana | 18175 | 2223 | 29 |
1167919 | 1167919 | 2021-03-29 | Washington | Indiana | 18175 | 2216 | 29 |
1164671 | 1164671 | 2021-03-28 | Washington | Indiana | 18175 | 2209 | 29 |
1161423 | 1161423 | 2021-03-27 | Washington | Indiana | 18175 | 2204 | 29 |
1158175 | 1158175 | 2021-03-26 | Washington | Indiana | 18175 | 2202 | 29 |
1154928 | 1154928 | 2021-03-25 | Washington | Indiana | 18175 | 2194 | 29 |
1151681 | 1151681 | 2021-03-24 | Washington | Indiana | 18175 | 2189 | 29 |
1148434 | 1148434 | 2021-03-23 | Washington | Indiana | 18175 | 2186 | 29 |
1145187 | 1145187 | 2021-03-22 | Washington | Indiana | 18175 | 2184 | 29 |
1141940 | 1141940 | 2021-03-21 | Washington | Indiana | 18175 | 2183 | 29 |
1138694 | 1138694 | 2021-03-20 | Washington | Indiana | 18175 | 2175 | 29 |
1135448 | 1135448 | 2021-03-19 | Washington | Indiana | 18175 | 2171 | 29 |
1132201 | 1132201 | 2021-03-18 | Washington | Indiana | 18175 | 2165 | 29 |
1128953 | 1128953 | 2021-03-17 | Washington | Indiana | 18175 | 2164 | 29 |
1125707 | 1125707 | 2021-03-16 | Washington | Indiana | 18175 | 2159 | 28 |
1122461 | 1122461 | 2021-03-15 | Washington | Indiana | 18175 | 2156 | 28 |
1119214 | 1119214 | 2021-03-14 | Washington | Indiana | 18175 | 2153 | 28 |
1115967 | 1115967 | 2021-03-13 | Washington | Indiana | 18175 | 2145 | 28 |
1112721 | 1112721 | 2021-03-12 | Washington | Indiana | 18175 | 2142 | 28 |
1109475 | 1109475 | 2021-03-11 | Washington | Indiana | 18175 | 2139 | 28 |
1106229 | 1106229 | 2021-03-10 | Washington | Indiana | 18175 | 2139 | 28 |
1102983 | 1102983 | 2021-03-09 | Washington | Indiana | 18175 | 2139 | 28 |
1099737 | 1099737 | 2021-03-08 | Washington | Indiana | 18175 | 2135 | 27 |
1096489 | 1096489 | 2021-03-07 | Washington | Indiana | 18175 | 2133 | 27 |
1093243 | 1093243 | 2021-03-06 | Washington | Indiana | 18175 | 2130 | 27 |
1089997 | 1089997 | 2021-03-05 | Washington | Indiana | 18175 | 2130 | 27 |
1086752 | 1086752 | 2021-03-04 | Washington | Indiana | 18175 | 2128 | 27 |
1083506 | 1083506 | 2021-03-03 | Washington | Indiana | 18175 | 2121 | 27 |
1080260 | 1080260 | 2021-03-02 | Washington | Indiana | 18175 | 2116 | 27 |
1077015 | 1077015 | 2021-03-01 | Washington | Indiana | 18175 | 2112 | 27 |
1073769 | 1073769 | 2021-02-28 | Washington | Indiana | 18175 | 2110 | 27 |
1070523 | 1070523 | 2021-02-27 | Washington | Indiana | 18175 | 2104 | 27 |
1067278 | 1067278 | 2021-02-26 | Washington | Indiana | 18175 | 2099 | 27 |
1064033 | 1064033 | 2021-02-25 | Washington | Indiana | 18175 | 2093 | 27 |
1060788 | 1060788 | 2021-02-24 | Washington | Indiana | 18175 | 2087 | 27 |
1057542 | 1057542 | 2021-02-23 | Washington | Indiana | 18175 | 2077 | 27 |
1054296 | 1054296 | 2021-02-22 | Washington | Indiana | 18175 | 2071 | 27 |
1051049 | 1051049 | 2021-02-21 | Washington | Indiana | 18175 | 2070 | 27 |
1047802 | 1047802 | 2021-02-20 | Washington | Indiana | 18175 | 2058 | 27 |
1044557 | 1044557 | 2021-02-19 | Washington | Indiana | 18175 | 2050 | 27 |
1041312 | 1041312 | 2021-02-18 | Washington | Indiana | 18175 | 2046 | 27 |
1038067 | 1038067 | 2021-02-17 | Washington | Indiana | 18175 | 2043 | 26 |
1034822 | 1034822 | 2021-02-16 | Washington | Indiana | 18175 | 2039 | 25 |
1031576 | 1031576 | 2021-02-15 | Washington | Indiana | 18175 | 2034 | 25 |
1028329 | 1028329 | 2021-02-14 | Washington | Indiana | 18175 | 2034 | 25 |
1025084 | 1025084 | 2021-02-13 | Washington | Indiana | 18175 | 2030 | 25 |
1021839 | 1021839 | 2021-02-12 | Washington | Indiana | 18175 | 2024 | 25 |
1018594 | 1018594 | 2021-02-11 | Washington | Indiana | 18175 | 2012 | 24 |
1015349 | 1015349 | 2021-02-10 | Washington | Indiana | 18175 | 2001 | 24 |
1012104 | 1012104 | 2021-02-09 | Washington | Indiana | 18175 | 1999 | 24 |
1008858 | 1008858 | 2021-02-08 | Washington | Indiana | 18175 | 1997 | 24 |
1005612 | 1005612 | 2021-02-07 | Washington | Indiana | 18175 | 1994 | 24 |
1002366 | 1002366 | 2021-02-06 | Washington | Indiana | 18175 | 1987 | 24 |
999120 | 999120 | 2021-02-05 | Washington | Indiana | 18175 | 1981 | 24 |
995874 | 995874 | 2021-02-04 | Washington | Indiana | 18175 | 1981 | 24 |
992628 | 992628 | 2021-02-03 | Washington | Indiana | 18175 | 1969 | 23 |
989382 | 989382 | 2021-02-02 | Washington | Indiana | 18175 | 1964 | 23 |
986135 | 986135 | 2021-02-01 | Washington | Indiana | 18175 | 1956 | 23 |
982888 | 982888 | 2021-01-31 | Washington | Indiana | 18175 | 1947 | 23 |
979642 | 979642 | 2021-01-30 | Washington | Indiana | 18175 | 1933 | 23 |
976396 | 976396 | 2021-01-29 | Washington | Indiana | 18175 | 1925 | 23 |
973151 | 973151 | 2021-01-28 | Washington | Indiana | 18175 | 1911 | 23 |
969906 | 969906 | 2021-01-27 | Washington | Indiana | 18175 | 1902 | 23 |
966662 | 966662 | 2021-01-26 | Washington | Indiana | 18175 | 1890 | 23 |
963417 | 963417 | 2021-01-25 | Washington | Indiana | 18175 | 1880 | 23 |
960172 | 960172 | 2021-01-24 | Washington | Indiana | 18175 | 1875 | 23 |
956926 | 956926 | 2021-01-23 | Washington | Indiana | 18175 | 1864 | 23 |
953681 | 953681 | 2021-01-22 | Washington | Indiana | 18175 | 1837 | 22 |
950436 | 950436 | 2021-01-21 | Washington | Indiana | 18175 | 1820 | 22 |
947190 | 947190 | 2021-01-20 | Washington | Indiana | 18175 | 1802 | 22 |
943943 | 943943 | 2021-01-19 | Washington | Indiana | 18175 | 1793 | 21 |
940698 | 940698 | 2021-01-18 | Washington | Indiana | 18175 | 1782 | 18 |
937453 | 937453 | 2021-01-17 | Washington | Indiana | 18175 | 1771 | 18 |
934208 | 934208 | 2021-01-16 | Washington | Indiana | 18175 | 1750 | 18 |
930963 | 930963 | 2021-01-15 | Washington | Indiana | 18175 | 1730 | 16 |
927718 | 927718 | 2021-01-14 | Washington | Indiana | 18175 | 1702 | 16 |
924472 | 924472 | 2021-01-13 | Washington | Indiana | 18175 | 1688 | 16 |
921227 | 921227 | 2021-01-12 | Washington | Indiana | 18175 | 1671 | 16 |
917982 | 917982 | 2021-01-11 | Washington | Indiana | 18175 | 1654 | 16 |
914737 | 914737 | 2021-01-10 | Washington | Indiana | 18175 | 1641 | 16 |
911492 | 911492 | 2021-01-09 | Washington | Indiana | 18175 | 1619 | 16 |
908247 | 908247 | 2021-01-08 | Washington | Indiana | 18175 | 1597 | 16 |
905001 | 905001 | 2021-01-07 | Washington | Indiana | 18175 | 1572 | 16 |
901756 | 901756 | 2021-01-06 | Washington | Indiana | 18175 | 1544 | 16 |
898511 | 898511 | 2021-01-05 | Washington | Indiana | 18175 | 1525 | 16 |
895266 | 895266 | 2021-01-04 | Washington | Indiana | 18175 | 1514 | 16 |
892019 | 892019 | 2021-01-03 | Washington | Indiana | 18175 | 1487 | 16 |
888773 | 888773 | 2021-01-02 | Washington | Indiana | 18175 | 1471 | 16 |
885527 | 885527 | 2021-01-01 | Washington | Indiana | 18175 | 1450 | 16 |
882282 | 882282 | 2020-12-31 | Washington | Indiana | 18175 | 1432 | 16 |
879037 | 879037 | 2020-12-30 | Washington | Indiana | 18175 | 1419 | 16 |
875792 | 875792 | 2020-12-29 | Washington | Indiana | 18175 | 1393 | 16 |
872547 | 872547 | 2020-12-28 | Washington | Indiana | 18175 | 1378 | 15 |
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);