ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
869399 | 869399 | 2020-12-27 | Washington | Iowa | 19183 | 1820 | 27 |
866154 | 866154 | 2020-12-26 | Washington | Iowa | 19183 | 1816 | 27 |
862909 | 862909 | 2020-12-25 | Washington | Iowa | 19183 | 1810 | 27 |
859664 | 859664 | 2020-12-24 | Washington | Iowa | 19183 | 1805 | 27 |
856419 | 856419 | 2020-12-23 | Washington | Iowa | 19183 | 1798 | 27 |
853174 | 853174 | 2020-12-22 | Washington | Iowa | 19183 | 1780 | 27 |
849929 | 849929 | 2020-12-21 | Washington | Iowa | 19183 | 1758 | 27 |
846684 | 846684 | 2020-12-20 | Washington | Iowa | 19183 | 1744 | 27 |
843438 | 843438 | 2020-12-19 | Washington | Iowa | 19183 | 1742 | 27 |
840193 | 840193 | 2020-12-18 | Washington | Iowa | 19183 | 1720 | 26 |
836948 | 836948 | 2020-12-17 | Washington | Iowa | 19183 | 1690 | 26 |
833702 | 833702 | 2020-12-16 | Washington | Iowa | 19183 | 1663 | 26 |
830455 | 830455 | 2020-12-15 | Washington | Iowa | 19183 | 1635 | 26 |
827209 | 827209 | 2020-12-14 | Washington | Iowa | 19183 | 1631 | 24 |
823962 | 823962 | 2020-12-13 | Washington | Iowa | 19183 | 1626 | 23 |
820716 | 820716 | 2020-12-12 | Washington | Iowa | 19183 | 1617 | 23 |
817470 | 817470 | 2020-12-11 | Washington | Iowa | 19183 | 1606 | 23 |
814224 | 814224 | 2020-12-10 | Washington | Iowa | 19183 | 1591 | 23 |
810979 | 810979 | 2020-12-09 | Washington | Iowa | 19183 | 1573 | 22 |
807734 | 807734 | 2020-12-08 | Washington | Iowa | 19183 | 1551 | 21 |
804489 | 804489 | 2020-12-07 | Washington | Iowa | 19183 | 1550 | 16 |
801244 | 801244 | 2020-12-06 | Washington | Iowa | 19183 | 1537 | 16 |
797999 | 797999 | 2020-12-05 | Washington | Iowa | 19183 | 1531 | 16 |
794754 | 794754 | 2020-12-04 | Washington | Iowa | 19183 | 1520 | 16 |
791509 | 791509 | 2020-12-03 | Washington | Iowa | 19183 | 1501 | 16 |
788264 | 788264 | 2020-12-02 | Washington | Iowa | 19183 | 1497 | 15 |
785020 | 785020 | 2020-12-01 | Washington | Iowa | 19183 | 1468 | 15 |
781775 | 781775 | 2020-11-30 | Washington | Iowa | 19183 | 1460 | 15 |
778529 | 778529 | 2020-11-29 | Washington | Iowa | 19183 | 1414 | 14 |
775284 | 775284 | 2020-11-28 | Washington | Iowa | 19183 | 1403 | 14 |
772039 | 772039 | 2020-11-27 | Washington | Iowa | 19183 | 1381 | 14 |
768794 | 768794 | 2020-11-26 | Washington | Iowa | 19183 | 1374 | 14 |
765548 | 765548 | 2020-11-25 | Washington | Iowa | 19183 | 1369 | 14 |
762303 | 762303 | 2020-11-24 | Washington | Iowa | 19183 | 1359 | 13 |
759058 | 759058 | 2020-11-23 | Washington | Iowa | 19183 | 1310 | 13 |
755811 | 755811 | 2020-11-22 | Washington | Iowa | 19183 | 1265 | 13 |
752565 | 752565 | 2020-11-21 | Washington | Iowa | 19183 | 1251 | 13 |
749319 | 749319 | 2020-11-20 | Washington | Iowa | 19183 | 1233 | 12 |
746073 | 746073 | 2020-11-19 | Washington | Iowa | 19183 | 1213 | 12 |
742826 | 742826 | 2020-11-18 | Washington | Iowa | 19183 | 1184 | 12 |
739579 | 739579 | 2020-11-17 | Washington | Iowa | 19183 | 1148 | 12 |
736335 | 736335 | 2020-11-16 | Washington | Iowa | 19183 | 1125 | 12 |
733089 | 733089 | 2020-11-15 | Washington | Iowa | 19183 | 1085 | 12 |
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);