ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Jo Daviess" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054148 | 1054148 | 2021-02-22 | Jo Daviess | Illinois | 17085 | 1595 | 25 |
1050901 | 1050901 | 2021-02-21 | Jo Daviess | Illinois | 17085 | 1593 | 25 |
1047654 | 1047654 | 2021-02-20 | Jo Daviess | Illinois | 17085 | 1593 | 25 |
1044409 | 1044409 | 2021-02-19 | Jo Daviess | Illinois | 17085 | 1593 | 25 |
1041164 | 1041164 | 2021-02-18 | Jo Daviess | Illinois | 17085 | 1591 | 25 |
1037919 | 1037919 | 2021-02-17 | Jo Daviess | Illinois | 17085 | 1589 | 25 |
1034674 | 1034674 | 2021-02-16 | Jo Daviess | Illinois | 17085 | 1583 | 25 |
1031428 | 1031428 | 2021-02-15 | Jo Daviess | Illinois | 17085 | 1582 | 25 |
1028181 | 1028181 | 2021-02-14 | Jo Daviess | Illinois | 17085 | 1583 | 25 |
1024936 | 1024936 | 2021-02-13 | Jo Daviess | Illinois | 17085 | 1581 | 25 |
1021691 | 1021691 | 2021-02-12 | Jo Daviess | Illinois | 17085 | 1581 | 25 |
1018446 | 1018446 | 2021-02-11 | Jo Daviess | Illinois | 17085 | 1578 | 25 |
1015201 | 1015201 | 2021-02-10 | Jo Daviess | Illinois | 17085 | 1575 | 25 |
1011956 | 1011956 | 2021-02-09 | Jo Daviess | Illinois | 17085 | 1572 | 25 |
1008710 | 1008710 | 2021-02-08 | Jo Daviess | Illinois | 17085 | 1571 | 25 |
1005464 | 1005464 | 2021-02-07 | Jo Daviess | Illinois | 17085 | 1571 | 25 |
1002218 | 1002218 | 2021-02-06 | Jo Daviess | Illinois | 17085 | 1570 | 25 |
998972 | 998972 | 2021-02-05 | Jo Daviess | Illinois | 17085 | 1568 | 25 |
995726 | 995726 | 2021-02-04 | Jo Daviess | Illinois | 17085 | 1567 | 25 |
992480 | 992480 | 2021-02-03 | Jo Daviess | Illinois | 17085 | 1560 | 25 |
989234 | 989234 | 2021-02-02 | Jo Daviess | Illinois | 17085 | 1552 | 25 |
985987 | 985987 | 2021-02-01 | Jo Daviess | Illinois | 17085 | 1552 | 25 |
982740 | 982740 | 2021-01-31 | Jo Daviess | Illinois | 17085 | 1551 | 25 |
979494 | 979494 | 2021-01-30 | Jo Daviess | Illinois | 17085 | 1549 | 25 |
976249 | 976249 | 2021-01-29 | Jo Daviess | Illinois | 17085 | 1547 | 25 |
973004 | 973004 | 2021-01-28 | Jo Daviess | Illinois | 17085 | 1544 | 25 |
969759 | 969759 | 2021-01-27 | Jo Daviess | Illinois | 17085 | 1541 | 25 |
966515 | 966515 | 2021-01-26 | Jo Daviess | Illinois | 17085 | 1534 | 25 |
963270 | 963270 | 2021-01-25 | Jo Daviess | Illinois | 17085 | 1527 | 25 |
960025 | 960025 | 2021-01-24 | Jo Daviess | Illinois | 17085 | 1523 | 25 |
956779 | 956779 | 2021-01-23 | Jo Daviess | Illinois | 17085 | 1519 | 25 |
953534 | 953534 | 2021-01-22 | Jo Daviess | Illinois | 17085 | 1513 | 24 |
950289 | 950289 | 2021-01-21 | Jo Daviess | Illinois | 17085 | 1505 | 24 |
947043 | 947043 | 2021-01-20 | Jo Daviess | Illinois | 17085 | 1499 | 24 |
943796 | 943796 | 2021-01-19 | Jo Daviess | Illinois | 17085 | 1485 | 24 |
940551 | 940551 | 2021-01-18 | Jo Daviess | Illinois | 17085 | 1482 | 24 |
937306 | 937306 | 2021-01-17 | Jo Daviess | Illinois | 17085 | 1481 | 24 |
934061 | 934061 | 2021-01-16 | Jo Daviess | Illinois | 17085 | 1478 | 24 |
930816 | 930816 | 2021-01-15 | Jo Daviess | Illinois | 17085 | 1474 | 24 |
927571 | 927571 | 2021-01-14 | Jo Daviess | Illinois | 17085 | 1467 | 24 |
924325 | 924325 | 2021-01-13 | Jo Daviess | Illinois | 17085 | 1459 | 24 |
921080 | 921080 | 2021-01-12 | Jo Daviess | Illinois | 17085 | 1450 | 24 |
917835 | 917835 | 2021-01-11 | Jo Daviess | Illinois | 17085 | 1432 | 24 |
914590 | 914590 | 2021-01-10 | Jo Daviess | Illinois | 17085 | 1430 | 24 |
911345 | 911345 | 2021-01-09 | Jo Daviess | Illinois | 17085 | 1429 | 24 |
908100 | 908100 | 2021-01-08 | Jo Daviess | Illinois | 17085 | 1420 | 24 |
904854 | 904854 | 2021-01-07 | Jo Daviess | Illinois | 17085 | 1412 | 24 |
901609 | 901609 | 2021-01-06 | Jo Daviess | Illinois | 17085 | 1405 | 24 |
898364 | 898364 | 2021-01-05 | Jo Daviess | Illinois | 17085 | 1398 | 24 |
895119 | 895119 | 2021-01-04 | Jo Daviess | Illinois | 17085 | 1394 | 24 |
891872 | 891872 | 2021-01-03 | Jo Daviess | Illinois | 17085 | 1392 | 24 |
888625 | 888625 | 2021-01-02 | Jo Daviess | Illinois | 17085 | 1390 | 24 |
885380 | 885380 | 2021-01-01 | Jo Daviess | Illinois | 17085 | 1388 | 24 |
882135 | 882135 | 2020-12-31 | Jo Daviess | Illinois | 17085 | 1388 | 24 |
878890 | 878890 | 2020-12-30 | Jo Daviess | Illinois | 17085 | 1382 | 24 |
875645 | 875645 | 2020-12-29 | Jo Daviess | Illinois | 17085 | 1376 | 24 |
872400 | 872400 | 2020-12-28 | Jo Daviess | Illinois | 17085 | 1371 | 24 |
869155 | 869155 | 2020-12-27 | Jo Daviess | Illinois | 17085 | 1368 | 24 |
865910 | 865910 | 2020-12-26 | Jo Daviess | Illinois | 17085 | 1363 | 24 |
862665 | 862665 | 2020-12-25 | Jo Daviess | Illinois | 17085 | 1362 | 24 |
859420 | 859420 | 2020-12-24 | Jo Daviess | Illinois | 17085 | 1360 | 24 |
856175 | 856175 | 2020-12-23 | Jo Daviess | Illinois | 17085 | 1358 | 24 |
852930 | 852930 | 2020-12-22 | Jo Daviess | Illinois | 17085 | 1341 | 24 |
849685 | 849685 | 2020-12-21 | Jo Daviess | Illinois | 17085 | 1335 | 24 |
846440 | 846440 | 2020-12-20 | Jo Daviess | Illinois | 17085 | 1333 | 24 |
843194 | 843194 | 2020-12-19 | Jo Daviess | Illinois | 17085 | 1325 | 24 |
839949 | 839949 | 2020-12-18 | Jo Daviess | Illinois | 17085 | 1304 | 24 |
836704 | 836704 | 2020-12-17 | Jo Daviess | Illinois | 17085 | 1276 | 24 |
833458 | 833458 | 2020-12-16 | Jo Daviess | Illinois | 17085 | 1263 | 24 |
830211 | 830211 | 2020-12-15 | Jo Daviess | Illinois | 17085 | 1258 | 24 |
826965 | 826965 | 2020-12-14 | Jo Daviess | Illinois | 17085 | 1248 | 23 |
823718 | 823718 | 2020-12-13 | Jo Daviess | Illinois | 17085 | 1241 | 23 |
820472 | 820472 | 2020-12-12 | Jo Daviess | Illinois | 17085 | 1237 | 23 |
817226 | 817226 | 2020-12-11 | Jo Daviess | Illinois | 17085 | 1215 | 23 |
813980 | 813980 | 2020-12-10 | Jo Daviess | Illinois | 17085 | 1204 | 23 |
810735 | 810735 | 2020-12-09 | Jo Daviess | Illinois | 17085 | 1196 | 21 |
807490 | 807490 | 2020-12-08 | Jo Daviess | Illinois | 17085 | 1183 | 21 |
804245 | 804245 | 2020-12-07 | Jo Daviess | Illinois | 17085 | 1179 | 21 |
801000 | 801000 | 2020-12-06 | Jo Daviess | Illinois | 17085 | 1175 | 21 |
797755 | 797755 | 2020-12-05 | Jo Daviess | Illinois | 17085 | 1166 | 20 |
794510 | 794510 | 2020-12-04 | Jo Daviess | Illinois | 17085 | 1149 | 20 |
791265 | 791265 | 2020-12-03 | Jo Daviess | Illinois | 17085 | 1138 | 20 |
788020 | 788020 | 2020-12-02 | Jo Daviess | Illinois | 17085 | 1123 | 20 |
784776 | 784776 | 2020-12-01 | Jo Daviess | Illinois | 17085 | 1094 | 18 |
781531 | 781531 | 2020-11-30 | Jo Daviess | Illinois | 17085 | 1083 | 17 |
778285 | 778285 | 2020-11-29 | Jo Daviess | Illinois | 17085 | 1076 | 17 |
775040 | 775040 | 2020-11-28 | Jo Daviess | Illinois | 17085 | 1065 | 17 |
771795 | 771795 | 2020-11-27 | Jo Daviess | Illinois | 17085 | 1062 | 17 |
768550 | 768550 | 2020-11-26 | Jo Daviess | Illinois | 17085 | 1049 | 17 |
765304 | 765304 | 2020-11-25 | Jo Daviess | Illinois | 17085 | 1038 | 17 |
762059 | 762059 | 2020-11-24 | Jo Daviess | Illinois | 17085 | 1018 | 16 |
758814 | 758814 | 2020-11-23 | Jo Daviess | Illinois | 17085 | 1010 | 16 |
755567 | 755567 | 2020-11-22 | Jo Daviess | Illinois | 17085 | 989 | 16 |
752321 | 752321 | 2020-11-21 | Jo Daviess | Illinois | 17085 | 958 | 16 |
749075 | 749075 | 2020-11-20 | Jo Daviess | Illinois | 17085 | 949 | 15 |
745829 | 745829 | 2020-11-19 | Jo Daviess | Illinois | 17085 | 933 | 15 |
742582 | 742582 | 2020-11-18 | Jo Daviess | Illinois | 17085 | 920 | 14 |
739335 | 739335 | 2020-11-17 | Jo Daviess | Illinois | 17085 | 909 | 14 |
736091 | 736091 | 2020-11-16 | Jo Daviess | Illinois | 17085 | 899 | 12 |
732845 | 732845 | 2020-11-15 | Jo Daviess | Illinois | 17085 | 870 | 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);