ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Cedar" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054316 | 1054316 | 2021-02-22 | Cedar | Iowa | 19031 | 1650 | 22 |
1051069 | 1051069 | 2021-02-21 | Cedar | Iowa | 19031 | 1650 | 22 |
1047822 | 1047822 | 2021-02-20 | Cedar | Iowa | 19031 | 1650 | 22 |
1044577 | 1044577 | 2021-02-19 | Cedar | Iowa | 19031 | 1650 | 22 |
1041332 | 1041332 | 2021-02-18 | Cedar | Iowa | 19031 | 1648 | 22 |
1038087 | 1038087 | 2021-02-17 | Cedar | Iowa | 19031 | 1646 | 22 |
1034842 | 1034842 | 2021-02-16 | Cedar | Iowa | 19031 | 1636 | 21 |
1031596 | 1031596 | 2021-02-15 | Cedar | Iowa | 19031 | 1634 | 20 |
1028349 | 1028349 | 2021-02-14 | Cedar | Iowa | 19031 | 1630 | 20 |
1025104 | 1025104 | 2021-02-13 | Cedar | Iowa | 19031 | 1628 | 20 |
1021859 | 1021859 | 2021-02-12 | Cedar | Iowa | 19031 | 1625 | 20 |
1018614 | 1018614 | 2021-02-11 | Cedar | Iowa | 19031 | 1621 | 20 |
1015369 | 1015369 | 2021-02-10 | Cedar | Iowa | 19031 | 1620 | 20 |
1012124 | 1012124 | 2021-02-09 | Cedar | Iowa | 19031 | 1618 | 20 |
1008878 | 1008878 | 2021-02-08 | Cedar | Iowa | 19031 | 1613 | 20 |
1005632 | 1005632 | 2021-02-07 | Cedar | Iowa | 19031 | 1609 | 20 |
1002386 | 1002386 | 2021-02-06 | Cedar | Iowa | 19031 | 1607 | 20 |
999140 | 999140 | 2021-02-05 | Cedar | Iowa | 19031 | 1604 | 20 |
995894 | 995894 | 2021-02-04 | Cedar | Iowa | 19031 | 1605 | 20 |
992648 | 992648 | 2021-02-03 | Cedar | Iowa | 19031 | 1602 | 20 |
989402 | 989402 | 2021-02-02 | Cedar | Iowa | 19031 | 1598 | 20 |
986155 | 986155 | 2021-02-01 | Cedar | Iowa | 19031 | 1591 | 20 |
982908 | 982908 | 2021-01-31 | Cedar | Iowa | 19031 | 1589 | 20 |
979662 | 979662 | 2021-01-30 | Cedar | Iowa | 19031 | 1588 | 19 |
976416 | 976416 | 2021-01-29 | Cedar | Iowa | 19031 | 1577 | 19 |
973171 | 973171 | 2021-01-28 | Cedar | Iowa | 19031 | 1572 | 19 |
969926 | 969926 | 2021-01-27 | Cedar | Iowa | 19031 | 1570 | 19 |
966682 | 966682 | 2021-01-26 | Cedar | Iowa | 19031 | 1568 | 19 |
963437 | 963437 | 2021-01-25 | Cedar | Iowa | 19031 | 1559 | 19 |
960192 | 960192 | 2021-01-24 | Cedar | Iowa | 19031 | 1556 | 19 |
956946 | 956946 | 2021-01-23 | Cedar | Iowa | 19031 | 1555 | 19 |
953701 | 953701 | 2021-01-22 | Cedar | Iowa | 19031 | 1554 | 19 |
950456 | 950456 | 2021-01-21 | Cedar | Iowa | 19031 | 1545 | 19 |
947210 | 947210 | 2021-01-20 | Cedar | Iowa | 19031 | 1542 | 19 |
943963 | 943963 | 2021-01-19 | Cedar | Iowa | 19031 | 1533 | 19 |
940718 | 940718 | 2021-01-18 | Cedar | Iowa | 19031 | 1525 | 19 |
937473 | 937473 | 2021-01-17 | Cedar | Iowa | 19031 | 1518 | 19 |
934228 | 934228 | 2021-01-16 | Cedar | Iowa | 19031 | 1512 | 19 |
930983 | 930983 | 2021-01-15 | Cedar | Iowa | 19031 | 1499 | 19 |
927738 | 927738 | 2021-01-14 | Cedar | Iowa | 19031 | 1491 | 19 |
924492 | 924492 | 2021-01-13 | Cedar | Iowa | 19031 | 1480 | 19 |
921247 | 921247 | 2021-01-12 | Cedar | Iowa | 19031 | 1465 | 19 |
918002 | 918002 | 2021-01-11 | Cedar | Iowa | 19031 | 1458 | 19 |
914757 | 914757 | 2021-01-10 | Cedar | Iowa | 19031 | 1454 | 19 |
911512 | 911512 | 2021-01-09 | Cedar | Iowa | 19031 | 1453 | 19 |
908267 | 908267 | 2021-01-08 | Cedar | Iowa | 19031 | 1448 | 19 |
905021 | 905021 | 2021-01-07 | Cedar | Iowa | 19031 | 1441 | 19 |
901776 | 901776 | 2021-01-06 | Cedar | Iowa | 19031 | 1427 | 19 |
898531 | 898531 | 2021-01-05 | Cedar | Iowa | 19031 | 1417 | 19 |
895286 | 895286 | 2021-01-04 | Cedar | Iowa | 19031 | 1414 | 19 |
892039 | 892039 | 2021-01-03 | Cedar | Iowa | 19031 | 1406 | 19 |
888793 | 888793 | 2021-01-02 | Cedar | Iowa | 19031 | 1402 | 19 |
885547 | 885547 | 2021-01-01 | Cedar | Iowa | 19031 | 1398 | 18 |
882302 | 882302 | 2020-12-31 | Cedar | Iowa | 19031 | 1396 | 18 |
879057 | 879057 | 2020-12-30 | Cedar | Iowa | 19031 | 1379 | 18 |
875812 | 875812 | 2020-12-29 | Cedar | Iowa | 19031 | 1366 | 18 |
872567 | 872567 | 2020-12-28 | Cedar | Iowa | 19031 | 1355 | 18 |
869322 | 869322 | 2020-12-27 | Cedar | Iowa | 19031 | 1350 | 18 |
866077 | 866077 | 2020-12-26 | Cedar | Iowa | 19031 | 1345 | 18 |
862832 | 862832 | 2020-12-25 | Cedar | Iowa | 19031 | 1343 | 18 |
859587 | 859587 | 2020-12-24 | Cedar | Iowa | 19031 | 1343 | 18 |
856342 | 856342 | 2020-12-23 | Cedar | Iowa | 19031 | 1337 | 18 |
853097 | 853097 | 2020-12-22 | Cedar | Iowa | 19031 | 1327 | 17 |
849852 | 849852 | 2020-12-21 | Cedar | Iowa | 19031 | 1318 | 17 |
846607 | 846607 | 2020-12-20 | Cedar | Iowa | 19031 | 1307 | 17 |
843361 | 843361 | 2020-12-19 | Cedar | Iowa | 19031 | 1307 | 17 |
840116 | 840116 | 2020-12-18 | Cedar | Iowa | 19031 | 1297 | 17 |
836871 | 836871 | 2020-12-17 | Cedar | Iowa | 19031 | 1279 | 17 |
833625 | 833625 | 2020-12-16 | Cedar | Iowa | 19031 | 1270 | 17 |
830378 | 830378 | 2020-12-15 | Cedar | Iowa | 19031 | 1263 | 16 |
827132 | 827132 | 2020-12-14 | Cedar | Iowa | 19031 | 1249 | 15 |
823885 | 823885 | 2020-12-13 | Cedar | Iowa | 19031 | 1242 | 15 |
820639 | 820639 | 2020-12-12 | Cedar | Iowa | 19031 | 1237 | 15 |
817393 | 817393 | 2020-12-11 | Cedar | Iowa | 19031 | 1232 | 15 |
814147 | 814147 | 2020-12-10 | Cedar | Iowa | 19031 | 1219 | 15 |
810902 | 810902 | 2020-12-09 | Cedar | Iowa | 19031 | 1209 | 14 |
807657 | 807657 | 2020-12-08 | Cedar | Iowa | 19031 | 1190 | 14 |
804412 | 804412 | 2020-12-07 | Cedar | Iowa | 19031 | 1190 | 15 |
801167 | 801167 | 2020-12-06 | Cedar | Iowa | 19031 | 1187 | 15 |
797922 | 797922 | 2020-12-05 | Cedar | Iowa | 19031 | 1175 | 14 |
794677 | 794677 | 2020-12-04 | Cedar | Iowa | 19031 | 1161 | 14 |
791432 | 791432 | 2020-12-03 | Cedar | Iowa | 19031 | 1146 | 14 |
788187 | 788187 | 2020-12-02 | Cedar | Iowa | 19031 | 1125 | 13 |
784943 | 784943 | 2020-12-01 | Cedar | Iowa | 19031 | 1111 | 13 |
781698 | 781698 | 2020-11-30 | Cedar | Iowa | 19031 | 1093 | 13 |
778452 | 778452 | 2020-11-29 | Cedar | Iowa | 19031 | 1085 | 13 |
775207 | 775207 | 2020-11-28 | Cedar | Iowa | 19031 | 1075 | 13 |
771962 | 771962 | 2020-11-27 | Cedar | Iowa | 19031 | 1062 | 13 |
768717 | 768717 | 2020-11-26 | Cedar | Iowa | 19031 | 1049 | 13 |
765471 | 765471 | 2020-11-25 | Cedar | Iowa | 19031 | 1039 | 13 |
762226 | 762226 | 2020-11-24 | Cedar | Iowa | 19031 | 1022 | 13 |
758981 | 758981 | 2020-11-23 | Cedar | Iowa | 19031 | 1014 | 13 |
755734 | 755734 | 2020-11-22 | Cedar | Iowa | 19031 | 989 | 13 |
752488 | 752488 | 2020-11-21 | Cedar | Iowa | 19031 | 976 | 13 |
749242 | 749242 | 2020-11-20 | Cedar | Iowa | 19031 | 948 | 13 |
745996 | 745996 | 2020-11-19 | Cedar | Iowa | 19031 | 928 | 13 |
742749 | 742749 | 2020-11-18 | Cedar | Iowa | 19031 | 903 | 13 |
739502 | 739502 | 2020-11-17 | Cedar | Iowa | 19031 | 889 | 13 |
736258 | 736258 | 2020-11-16 | Cedar | Iowa | 19031 | 861 | 13 |
733012 | 733012 | 2020-11-15 | Cedar | Iowa | 19031 | 851 | 13 |
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);