ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and fips = 19183 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193996 | 1193996 | 2021-04-06 | Washington | Iowa | 19183 | 2466 | 49 |
1190746 | 1190746 | 2021-04-05 | Washington | Iowa | 19183 | 2457 | 49 |
1187499 | 1187499 | 2021-04-04 | Washington | Iowa | 19183 | 2451 | 49 |
1184252 | 1184252 | 2021-04-03 | Washington | Iowa | 19183 | 2452 | 49 |
1181005 | 1181005 | 2021-04-02 | Washington | Iowa | 19183 | 2453 | 49 |
1177758 | 1177758 | 2021-04-01 | Washington | Iowa | 19183 | 2449 | 49 |
1174511 | 1174511 | 2021-03-31 | Washington | Iowa | 19183 | 2447 | 49 |
1171264 | 1171264 | 2021-03-30 | Washington | Iowa | 19183 | 2446 | 49 |
1168016 | 1168016 | 2021-03-29 | Washington | Iowa | 19183 | 2443 | 49 |
1164768 | 1164768 | 2021-03-28 | Washington | Iowa | 19183 | 2439 | 49 |
1161520 | 1161520 | 2021-03-27 | Washington | Iowa | 19183 | 2437 | 49 |
1158272 | 1158272 | 2021-03-26 | Washington | Iowa | 19183 | 2435 | 49 |
1155025 | 1155025 | 2021-03-25 | Washington | Iowa | 19183 | 2435 | 49 |
1151778 | 1151778 | 2021-03-24 | Washington | Iowa | 19183 | 2433 | 49 |
1148531 | 1148531 | 2021-03-23 | Washington | Iowa | 19183 | 2427 | 49 |
1145284 | 1145284 | 2021-03-22 | Washington | Iowa | 19183 | 2425 | 48 |
1142037 | 1142037 | 2021-03-21 | Washington | Iowa | 19183 | 2420 | 48 |
1138791 | 1138791 | 2021-03-20 | Washington | Iowa | 19183 | 2418 | 48 |
1135545 | 1135545 | 2021-03-19 | Washington | Iowa | 19183 | 2417 | 48 |
1132298 | 1132298 | 2021-03-18 | Washington | Iowa | 19183 | 2417 | 48 |
1129050 | 1129050 | 2021-03-17 | Washington | Iowa | 19183 | 2417 | 48 |
1125804 | 1125804 | 2021-03-16 | Washington | Iowa | 19183 | 2416 | 48 |
1122558 | 1122558 | 2021-03-15 | Washington | Iowa | 19183 | 2412 | 48 |
1119311 | 1119311 | 2021-03-14 | Washington | Iowa | 19183 | 2409 | 48 |
1116064 | 1116064 | 2021-03-13 | Washington | Iowa | 19183 | 2411 | 48 |
1112818 | 1112818 | 2021-03-12 | Washington | Iowa | 19183 | 2407 | 48 |
1109572 | 1109572 | 2021-03-11 | Washington | Iowa | 19183 | 2406 | 48 |
1106326 | 1106326 | 2021-03-10 | Washington | Iowa | 19183 | 2396 | 48 |
1103080 | 1103080 | 2021-03-09 | Washington | Iowa | 19183 | 2395 | 47 |
1099834 | 1099834 | 2021-03-08 | Washington | Iowa | 19183 | 2395 | 47 |
1096586 | 1096586 | 2021-03-07 | Washington | Iowa | 19183 | 2390 | 47 |
1093340 | 1093340 | 2021-03-06 | Washington | Iowa | 19183 | 2390 | 47 |
1090094 | 1090094 | 2021-03-05 | Washington | Iowa | 19183 | 2390 | 47 |
1086849 | 1086849 | 2021-03-04 | Washington | Iowa | 19183 | 2390 | 47 |
1083603 | 1083603 | 2021-03-03 | Washington | Iowa | 19183 | 2387 | 47 |
1080357 | 1080357 | 2021-03-02 | Washington | Iowa | 19183 | 2387 | 47 |
1077112 | 1077112 | 2021-03-01 | Washington | Iowa | 19183 | 2386 | 47 |
1073866 | 1073866 | 2021-02-28 | Washington | Iowa | 19183 | 2386 | 47 |
1070620 | 1070620 | 2021-02-27 | Washington | Iowa | 19183 | 2386 | 47 |
1067375 | 1067375 | 2021-02-26 | Washington | Iowa | 19183 | 2386 | 47 |
1064130 | 1064130 | 2021-02-25 | Washington | Iowa | 19183 | 2383 | 47 |
1060885 | 1060885 | 2021-02-24 | Washington | Iowa | 19183 | 2370 | 45 |
1057639 | 1057639 | 2021-02-23 | Washington | Iowa | 19183 | 2370 | 44 |
1054393 | 1054393 | 2021-02-22 | Washington | Iowa | 19183 | 2370 | 44 |
1051146 | 1051146 | 2021-02-21 | Washington | Iowa | 19183 | 2370 | 43 |
1047899 | 1047899 | 2021-02-20 | Washington | Iowa | 19183 | 2370 | 43 |
1044654 | 1044654 | 2021-02-19 | Washington | Iowa | 19183 | 2370 | 43 |
1041409 | 1041409 | 2021-02-18 | Washington | Iowa | 19183 | 2369 | 43 |
1038164 | 1038164 | 2021-02-17 | Washington | Iowa | 19183 | 2364 | 43 |
1034919 | 1034919 | 2021-02-16 | Washington | Iowa | 19183 | 2358 | 41 |
1031673 | 1031673 | 2021-02-15 | Washington | Iowa | 19183 | 2353 | 41 |
1028426 | 1028426 | 2021-02-14 | Washington | Iowa | 19183 | 2340 | 41 |
1025181 | 1025181 | 2021-02-13 | Washington | Iowa | 19183 | 2337 | 41 |
1021936 | 1021936 | 2021-02-12 | Washington | Iowa | 19183 | 2336 | 41 |
1018691 | 1018691 | 2021-02-11 | Washington | Iowa | 19183 | 2329 | 40 |
1015446 | 1015446 | 2021-02-10 | Washington | Iowa | 19183 | 2324 | 40 |
1012201 | 1012201 | 2021-02-09 | Washington | Iowa | 19183 | 2320 | 40 |
1008955 | 1008955 | 2021-02-08 | Washington | Iowa | 19183 | 2313 | 40 |
1005709 | 1005709 | 2021-02-07 | Washington | Iowa | 19183 | 2311 | 40 |
1002463 | 1002463 | 2021-02-06 | Washington | Iowa | 19183 | 2307 | 40 |
999217 | 999217 | 2021-02-05 | Washington | Iowa | 19183 | 2305 | 40 |
995971 | 995971 | 2021-02-04 | Washington | Iowa | 19183 | 2301 | 40 |
992725 | 992725 | 2021-02-03 | Washington | Iowa | 19183 | 2297 | 39 |
989479 | 989479 | 2021-02-02 | Washington | Iowa | 19183 | 2294 | 39 |
986232 | 986232 | 2021-02-01 | Washington | Iowa | 19183 | 2283 | 39 |
982985 | 982985 | 2021-01-31 | Washington | Iowa | 19183 | 2274 | 39 |
979739 | 979739 | 2021-01-30 | Washington | Iowa | 19183 | 2275 | 33 |
976493 | 976493 | 2021-01-29 | Washington | Iowa | 19183 | 2267 | 33 |
973248 | 973248 | 2021-01-28 | Washington | Iowa | 19183 | 2262 | 33 |
970003 | 970003 | 2021-01-27 | Washington | Iowa | 19183 | 2254 | 33 |
966759 | 966759 | 2021-01-26 | Washington | Iowa | 19183 | 2243 | 33 |
963514 | 963514 | 2021-01-25 | Washington | Iowa | 19183 | 2239 | 33 |
960269 | 960269 | 2021-01-24 | Washington | Iowa | 19183 | 2229 | 33 |
957023 | 957023 | 2021-01-23 | Washington | Iowa | 19183 | 2229 | 33 |
953778 | 953778 | 2021-01-22 | Washington | Iowa | 19183 | 2220 | 33 |
950533 | 950533 | 2021-01-21 | Washington | Iowa | 19183 | 2214 | 33 |
947287 | 947287 | 2021-01-20 | Washington | Iowa | 19183 | 2203 | 32 |
944040 | 944040 | 2021-01-19 | Washington | Iowa | 19183 | 2174 | 32 |
940795 | 940795 | 2021-01-18 | Washington | Iowa | 19183 | 2168 | 31 |
937550 | 937550 | 2021-01-17 | Washington | Iowa | 19183 | 2146 | 31 |
934305 | 934305 | 2021-01-16 | Washington | Iowa | 19183 | 2143 | 31 |
931060 | 931060 | 2021-01-15 | Washington | Iowa | 19183 | 2139 | 31 |
927815 | 927815 | 2021-01-14 | Washington | Iowa | 19183 | 2136 | 31 |
924569 | 924569 | 2021-01-13 | Washington | Iowa | 19183 | 2120 | 31 |
921324 | 921324 | 2021-01-12 | Washington | Iowa | 19183 | 2097 | 31 |
918079 | 918079 | 2021-01-11 | Washington | Iowa | 19183 | 2087 | 30 |
914834 | 914834 | 2021-01-10 | Washington | Iowa | 19183 | 2074 | 30 |
911589 | 911589 | 2021-01-09 | Washington | Iowa | 19183 | 2068 | 29 |
908344 | 908344 | 2021-01-08 | Washington | Iowa | 19183 | 2056 | 29 |
905098 | 905098 | 2021-01-07 | Washington | Iowa | 19183 | 2033 | 29 |
901853 | 901853 | 2021-01-06 | Washington | Iowa | 19183 | 1995 | 29 |
898608 | 898608 | 2021-01-05 | Washington | Iowa | 19183 | 1976 | 29 |
895363 | 895363 | 2021-01-04 | Washington | Iowa | 19183 | 1959 | 29 |
892116 | 892116 | 2021-01-03 | Washington | Iowa | 19183 | 1903 | 28 |
888870 | 888870 | 2021-01-02 | Washington | Iowa | 19183 | 1897 | 28 |
885624 | 885624 | 2021-01-01 | Washington | Iowa | 19183 | 1893 | 28 |
882379 | 882379 | 2020-12-31 | Washington | Iowa | 19183 | 1882 | 28 |
879134 | 879134 | 2020-12-30 | Washington | Iowa | 19183 | 1873 | 28 |
875889 | 875889 | 2020-12-29 | Washington | Iowa | 19183 | 1865 | 28 |
872644 | 872644 | 2020-12-28 | Washington | Iowa | 19183 | 1844 | 27 |
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);