ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Clay" and fips = 19041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1047827 | 1047827 | 2021-02-20 | Clay | Iowa | 19041 | 1823 | 25 |
1044582 | 1044582 | 2021-02-19 | Clay | Iowa | 19041 | 1823 | 25 |
1041337 | 1041337 | 2021-02-18 | Clay | Iowa | 19041 | 1821 | 25 |
1038092 | 1038092 | 2021-02-17 | Clay | Iowa | 19041 | 1820 | 25 |
1034847 | 1034847 | 2021-02-16 | Clay | Iowa | 19041 | 1816 | 25 |
1031601 | 1031601 | 2021-02-15 | Clay | Iowa | 19041 | 1814 | 25 |
1028354 | 1028354 | 2021-02-14 | Clay | Iowa | 19041 | 1809 | 25 |
1025109 | 1025109 | 2021-02-13 | Clay | Iowa | 19041 | 1809 | 25 |
1021864 | 1021864 | 2021-02-12 | Clay | Iowa | 19041 | 1809 | 25 |
1018619 | 1018619 | 2021-02-11 | Clay | Iowa | 19041 | 1806 | 25 |
1015374 | 1015374 | 2021-02-10 | Clay | Iowa | 19041 | 1806 | 25 |
1012129 | 1012129 | 2021-02-09 | Clay | Iowa | 19041 | 1797 | 25 |
1008883 | 1008883 | 2021-02-08 | Clay | Iowa | 19041 | 1787 | 25 |
1005637 | 1005637 | 2021-02-07 | Clay | Iowa | 19041 | 1780 | 25 |
1002391 | 1002391 | 2021-02-06 | Clay | Iowa | 19041 | 1778 | 25 |
999145 | 999145 | 2021-02-05 | Clay | Iowa | 19041 | 1778 | 24 |
995899 | 995899 | 2021-02-04 | Clay | Iowa | 19041 | 1772 | 24 |
992653 | 992653 | 2021-02-03 | Clay | Iowa | 19041 | 1770 | 24 |
989407 | 989407 | 2021-02-02 | Clay | Iowa | 19041 | 1766 | 24 |
986160 | 986160 | 2021-02-01 | Clay | Iowa | 19041 | 1761 | 23 |
982913 | 982913 | 2021-01-31 | Clay | Iowa | 19041 | 1755 | 23 |
979667 | 979667 | 2021-01-30 | Clay | Iowa | 19041 | 1752 | 21 |
976421 | 976421 | 2021-01-29 | Clay | Iowa | 19041 | 1749 | 21 |
973176 | 973176 | 2021-01-28 | Clay | Iowa | 19041 | 1747 | 21 |
969931 | 969931 | 2021-01-27 | Clay | Iowa | 19041 | 1739 | 21 |
966687 | 966687 | 2021-01-26 | Clay | Iowa | 19041 | 1734 | 21 |
963442 | 963442 | 2021-01-25 | Clay | Iowa | 19041 | 1730 | 21 |
960197 | 960197 | 2021-01-24 | Clay | Iowa | 19041 | 1725 | 21 |
956951 | 956951 | 2021-01-23 | Clay | Iowa | 19041 | 1720 | 21 |
953706 | 953706 | 2021-01-22 | Clay | Iowa | 19041 | 1714 | 21 |
950461 | 950461 | 2021-01-21 | Clay | Iowa | 19041 | 1707 | 21 |
947215 | 947215 | 2021-01-20 | Clay | Iowa | 19041 | 1698 | 20 |
943968 | 943968 | 2021-01-19 | Clay | Iowa | 19041 | 1688 | 20 |
940723 | 940723 | 2021-01-18 | Clay | Iowa | 19041 | 1673 | 19 |
937478 | 937478 | 2021-01-17 | Clay | Iowa | 19041 | 1660 | 19 |
934233 | 934233 | 2021-01-16 | Clay | Iowa | 19041 | 1660 | 19 |
930988 | 930988 | 2021-01-15 | Clay | Iowa | 19041 | 1655 | 19 |
927743 | 927743 | 2021-01-14 | Clay | Iowa | 19041 | 1653 | 19 |
924497 | 924497 | 2021-01-13 | Clay | Iowa | 19041 | 1648 | 19 |
921252 | 921252 | 2021-01-12 | Clay | Iowa | 19041 | 1636 | 19 |
918007 | 918007 | 2021-01-11 | Clay | Iowa | 19041 | 1633 | 17 |
914762 | 914762 | 2021-01-10 | Clay | Iowa | 19041 | 1621 | 17 |
911517 | 911517 | 2021-01-09 | Clay | Iowa | 19041 | 1619 | 17 |
908272 | 908272 | 2021-01-08 | Clay | Iowa | 19041 | 1616 | 17 |
905026 | 905026 | 2021-01-07 | Clay | Iowa | 19041 | 1609 | 17 |
901781 | 901781 | 2021-01-06 | Clay | Iowa | 19041 | 1594 | 17 |
898536 | 898536 | 2021-01-05 | Clay | Iowa | 19041 | 1580 | 16 |
895291 | 895291 | 2021-01-04 | Clay | Iowa | 19041 | 1570 | 15 |
892044 | 892044 | 2021-01-03 | Clay | Iowa | 19041 | 1559 | 13 |
888798 | 888798 | 2021-01-02 | Clay | Iowa | 19041 | 1555 | 13 |
885552 | 885552 | 2021-01-01 | Clay | Iowa | 19041 | 1551 | 12 |
882307 | 882307 | 2020-12-31 | Clay | Iowa | 19041 | 1546 | 12 |
879062 | 879062 | 2020-12-30 | Clay | Iowa | 19041 | 1536 | 12 |
875817 | 875817 | 2020-12-29 | Clay | Iowa | 19041 | 1529 | 12 |
872572 | 872572 | 2020-12-28 | Clay | Iowa | 19041 | 1519 | 11 |
869327 | 869327 | 2020-12-27 | Clay | Iowa | 19041 | 1516 | 11 |
866082 | 866082 | 2020-12-26 | Clay | Iowa | 19041 | 1514 | 11 |
862837 | 862837 | 2020-12-25 | Clay | Iowa | 19041 | 1510 | 11 |
859592 | 859592 | 2020-12-24 | Clay | Iowa | 19041 | 1508 | 11 |
856347 | 856347 | 2020-12-23 | Clay | Iowa | 19041 | 1507 | 11 |
853102 | 853102 | 2020-12-22 | Clay | Iowa | 19041 | 1497 | 11 |
849857 | 849857 | 2020-12-21 | Clay | Iowa | 19041 | 1494 | 11 |
846612 | 846612 | 2020-12-20 | Clay | Iowa | 19041 | 1485 | 11 |
843366 | 843366 | 2020-12-19 | Clay | Iowa | 19041 | 1484 | 10 |
840121 | 840121 | 2020-12-18 | Clay | Iowa | 19041 | 1467 | 10 |
836876 | 836876 | 2020-12-17 | Clay | Iowa | 19041 | 1455 | 10 |
833630 | 833630 | 2020-12-16 | Clay | Iowa | 19041 | 1442 | 10 |
830383 | 830383 | 2020-12-15 | Clay | Iowa | 19041 | 1427 | 10 |
827137 | 827137 | 2020-12-14 | Clay | Iowa | 19041 | 1409 | 10 |
823890 | 823890 | 2020-12-13 | Clay | Iowa | 19041 | 1401 | 10 |
820644 | 820644 | 2020-12-12 | Clay | Iowa | 19041 | 1396 | 10 |
817398 | 817398 | 2020-12-11 | Clay | Iowa | 19041 | 1380 | 10 |
814152 | 814152 | 2020-12-10 | Clay | Iowa | 19041 | 1354 | 10 |
810907 | 810907 | 2020-12-09 | Clay | Iowa | 19041 | 1335 | 9 |
807662 | 807662 | 2020-12-08 | Clay | Iowa | 19041 | 1318 | 9 |
804417 | 804417 | 2020-12-07 | Clay | Iowa | 19041 | 1316 | 7 |
801172 | 801172 | 2020-12-06 | Clay | Iowa | 19041 | 1295 | 7 |
797927 | 797927 | 2020-12-05 | Clay | Iowa | 19041 | 1292 | 6 |
794682 | 794682 | 2020-12-04 | Clay | Iowa | 19041 | 1280 | 6 |
791437 | 791437 | 2020-12-03 | Clay | Iowa | 19041 | 1250 | 5 |
788192 | 788192 | 2020-12-02 | Clay | Iowa | 19041 | 1225 | 4 |
784948 | 784948 | 2020-12-01 | Clay | Iowa | 19041 | 1200 | 4 |
781703 | 781703 | 2020-11-30 | Clay | Iowa | 19041 | 1192 | 4 |
778457 | 778457 | 2020-11-29 | Clay | Iowa | 19041 | 1178 | 4 |
775212 | 775212 | 2020-11-28 | Clay | Iowa | 19041 | 1171 | 4 |
771967 | 771967 | 2020-11-27 | Clay | Iowa | 19041 | 1150 | 4 |
768722 | 768722 | 2020-11-26 | Clay | Iowa | 19041 | 1131 | 4 |
765476 | 765476 | 2020-11-25 | Clay | Iowa | 19041 | 1118 | 4 |
762231 | 762231 | 2020-11-24 | Clay | Iowa | 19041 | 1096 | 4 |
758986 | 758986 | 2020-11-23 | Clay | Iowa | 19041 | 1062 | 4 |
755739 | 755739 | 2020-11-22 | Clay | Iowa | 19041 | 1043 | 4 |
752493 | 752493 | 2020-11-21 | Clay | Iowa | 19041 | 1026 | 4 |
749247 | 749247 | 2020-11-20 | Clay | Iowa | 19041 | 1006 | 4 |
746001 | 746001 | 2020-11-19 | Clay | Iowa | 19041 | 979 | 4 |
742754 | 742754 | 2020-11-18 | Clay | Iowa | 19041 | 949 | 4 |
739507 | 739507 | 2020-11-17 | Clay | Iowa | 19041 | 933 | 4 |
736263 | 736263 | 2020-11-16 | Clay | Iowa | 19041 | 912 | 4 |
733017 | 733017 | 2020-11-15 | Clay | Iowa | 19041 | 897 | 4 |
729772 | 729772 | 2020-11-14 | Clay | Iowa | 19041 | 880 | 4 |
726529 | 726529 | 2020-11-13 | Clay | Iowa | 19041 | 852 | 4 |
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);