ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Warren" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054200 | 1054200 | 2021-02-22 | Warren | Illinois | 17187 | 1662 | 46 |
1050953 | 1050953 | 2021-02-21 | Warren | Illinois | 17187 | 1661 | 46 |
1047706 | 1047706 | 2021-02-20 | Warren | Illinois | 17187 | 1658 | 46 |
1044461 | 1044461 | 2021-02-19 | Warren | Illinois | 17187 | 1657 | 46 |
1041216 | 1041216 | 2021-02-18 | Warren | Illinois | 17187 | 1658 | 46 |
1037971 | 1037971 | 2021-02-17 | Warren | Illinois | 17187 | 1655 | 46 |
1034726 | 1034726 | 2021-02-16 | Warren | Illinois | 17187 | 1655 | 46 |
1031480 | 1031480 | 2021-02-15 | Warren | Illinois | 17187 | 1655 | 46 |
1028233 | 1028233 | 2021-02-14 | Warren | Illinois | 17187 | 1655 | 46 |
1024988 | 1024988 | 2021-02-13 | Warren | Illinois | 17187 | 1654 | 46 |
1021743 | 1021743 | 2021-02-12 | Warren | Illinois | 17187 | 1653 | 46 |
1018498 | 1018498 | 2021-02-11 | Warren | Illinois | 17187 | 1652 | 46 |
1015253 | 1015253 | 2021-02-10 | Warren | Illinois | 17187 | 1650 | 46 |
1012008 | 1012008 | 2021-02-09 | Warren | Illinois | 17187 | 1649 | 46 |
1008762 | 1008762 | 2021-02-08 | Warren | Illinois | 17187 | 1646 | 46 |
1005516 | 1005516 | 2021-02-07 | Warren | Illinois | 17187 | 1645 | 46 |
1002270 | 1002270 | 2021-02-06 | Warren | Illinois | 17187 | 1645 | 46 |
999024 | 999024 | 2021-02-05 | Warren | Illinois | 17187 | 1644 | 46 |
995778 | 995778 | 2021-02-04 | Warren | Illinois | 17187 | 1641 | 46 |
992532 | 992532 | 2021-02-03 | Warren | Illinois | 17187 | 1636 | 46 |
989286 | 989286 | 2021-02-02 | Warren | Illinois | 17187 | 1634 | 46 |
986039 | 986039 | 2021-02-01 | Warren | Illinois | 17187 | 1628 | 46 |
982792 | 982792 | 2021-01-31 | Warren | Illinois | 17187 | 1624 | 46 |
979546 | 979546 | 2021-01-30 | Warren | Illinois | 17187 | 1621 | 46 |
976300 | 976300 | 2021-01-29 | Warren | Illinois | 17187 | 1613 | 46 |
973055 | 973055 | 2021-01-28 | Warren | Illinois | 17187 | 1613 | 46 |
969810 | 969810 | 2021-01-27 | Warren | Illinois | 17187 | 1609 | 45 |
966566 | 966566 | 2021-01-26 | Warren | Illinois | 17187 | 1605 | 45 |
963321 | 963321 | 2021-01-25 | Warren | Illinois | 17187 | 1604 | 44 |
960076 | 960076 | 2021-01-24 | Warren | Illinois | 17187 | 1603 | 44 |
956830 | 956830 | 2021-01-23 | Warren | Illinois | 17187 | 1601 | 44 |
953585 | 953585 | 2021-01-22 | Warren | Illinois | 17187 | 1596 | 44 |
950340 | 950340 | 2021-01-21 | Warren | Illinois | 17187 | 1591 | 44 |
947094 | 947094 | 2021-01-20 | Warren | Illinois | 17187 | 1588 | 44 |
943847 | 943847 | 2021-01-19 | Warren | Illinois | 17187 | 1586 | 44 |
940602 | 940602 | 2021-01-18 | Warren | Illinois | 17187 | 1582 | 44 |
937357 | 937357 | 2021-01-17 | Warren | Illinois | 17187 | 1580 | 43 |
934112 | 934112 | 2021-01-16 | Warren | Illinois | 17187 | 1577 | 43 |
930867 | 930867 | 2021-01-15 | Warren | Illinois | 17187 | 1575 | 43 |
927622 | 927622 | 2021-01-14 | Warren | Illinois | 17187 | 1572 | 43 |
924376 | 924376 | 2021-01-13 | Warren | Illinois | 17187 | 1569 | 42 |
921131 | 921131 | 2021-01-12 | Warren | Illinois | 17187 | 1564 | 42 |
917886 | 917886 | 2021-01-11 | Warren | Illinois | 17187 | 1560 | 42 |
914641 | 914641 | 2021-01-10 | Warren | Illinois | 17187 | 1555 | 42 |
911396 | 911396 | 2021-01-09 | Warren | Illinois | 17187 | 1550 | 42 |
908151 | 908151 | 2021-01-08 | Warren | Illinois | 17187 | 1548 | 42 |
904905 | 904905 | 2021-01-07 | Warren | Illinois | 17187 | 1536 | 42 |
901660 | 901660 | 2021-01-06 | Warren | Illinois | 17187 | 1529 | 42 |
898415 | 898415 | 2021-01-05 | Warren | Illinois | 17187 | 1529 | 42 |
895170 | 895170 | 2021-01-04 | Warren | Illinois | 17187 | 1525 | 40 |
891923 | 891923 | 2021-01-03 | Warren | Illinois | 17187 | 1521 | 39 |
888677 | 888677 | 2021-01-02 | Warren | Illinois | 17187 | 1513 | 39 |
885431 | 885431 | 2021-01-01 | Warren | Illinois | 17187 | 1496 | 36 |
882186 | 882186 | 2020-12-31 | Warren | Illinois | 17187 | 1496 | 36 |
878941 | 878941 | 2020-12-30 | Warren | Illinois | 17187 | 1480 | 36 |
875696 | 875696 | 2020-12-29 | Warren | Illinois | 17187 | 1471 | 35 |
872451 | 872451 | 2020-12-28 | Warren | Illinois | 17187 | 1467 | 33 |
869206 | 869206 | 2020-12-27 | Warren | Illinois | 17187 | 1463 | 32 |
865961 | 865961 | 2020-12-26 | Warren | Illinois | 17187 | 1456 | 32 |
862716 | 862716 | 2020-12-25 | Warren | Illinois | 17187 | 1451 | 32 |
859471 | 859471 | 2020-12-24 | Warren | Illinois | 17187 | 1442 | 32 |
856226 | 856226 | 2020-12-23 | Warren | Illinois | 17187 | 1427 | 31 |
852981 | 852981 | 2020-12-22 | Warren | Illinois | 17187 | 1412 | 30 |
849736 | 849736 | 2020-12-21 | Warren | Illinois | 17187 | 1406 | 30 |
846491 | 846491 | 2020-12-20 | Warren | Illinois | 17187 | 1400 | 30 |
843245 | 843245 | 2020-12-19 | Warren | Illinois | 17187 | 1392 | 30 |
840000 | 840000 | 2020-12-18 | Warren | Illinois | 17187 | 1376 | 30 |
836755 | 836755 | 2020-12-17 | Warren | Illinois | 17187 | 1363 | 28 |
833509 | 833509 | 2020-12-16 | Warren | Illinois | 17187 | 1346 | 28 |
830262 | 830262 | 2020-12-15 | Warren | Illinois | 17187 | 1337 | 28 |
827016 | 827016 | 2020-12-14 | Warren | Illinois | 17187 | 1317 | 28 |
823769 | 823769 | 2020-12-13 | Warren | Illinois | 17187 | 1314 | 28 |
820523 | 820523 | 2020-12-12 | Warren | Illinois | 17187 | 1303 | 28 |
817277 | 817277 | 2020-12-11 | Warren | Illinois | 17187 | 1287 | 26 |
814031 | 814031 | 2020-12-10 | Warren | Illinois | 17187 | 1273 | 26 |
810786 | 810786 | 2020-12-09 | Warren | Illinois | 17187 | 1247 | 26 |
807541 | 807541 | 2020-12-08 | Warren | Illinois | 17187 | 1218 | 26 |
804296 | 804296 | 2020-12-07 | Warren | Illinois | 17187 | 1200 | 24 |
801051 | 801051 | 2020-12-06 | Warren | Illinois | 17187 | 1197 | 23 |
797806 | 797806 | 2020-12-05 | Warren | Illinois | 17187 | 1190 | 23 |
794561 | 794561 | 2020-12-04 | Warren | Illinois | 17187 | 1177 | 23 |
791316 | 791316 | 2020-12-03 | Warren | Illinois | 17187 | 1148 | 22 |
788071 | 788071 | 2020-12-02 | Warren | Illinois | 17187 | 1125 | 22 |
784827 | 784827 | 2020-12-01 | Warren | Illinois | 17187 | 1120 | 22 |
781582 | 781582 | 2020-11-30 | Warren | Illinois | 17187 | 1101 | 20 |
778336 | 778336 | 2020-11-29 | Warren | Illinois | 17187 | 1090 | 20 |
775091 | 775091 | 2020-11-28 | Warren | Illinois | 17187 | 1071 | 20 |
771846 | 771846 | 2020-11-27 | Warren | Illinois | 17187 | 1062 | 20 |
768601 | 768601 | 2020-11-26 | Warren | Illinois | 17187 | 1044 | 20 |
765355 | 765355 | 2020-11-25 | Warren | Illinois | 17187 | 1028 | 20 |
762110 | 762110 | 2020-11-24 | Warren | Illinois | 17187 | 1006 | 20 |
758865 | 758865 | 2020-11-23 | Warren | Illinois | 17187 | 988 | 18 |
755618 | 755618 | 2020-11-22 | Warren | Illinois | 17187 | 973 | 17 |
752372 | 752372 | 2020-11-21 | Warren | Illinois | 17187 | 937 | 16 |
749126 | 749126 | 2020-11-20 | Warren | Illinois | 17187 | 912 | 14 |
745880 | 745880 | 2020-11-19 | Warren | Illinois | 17187 | 895 | 14 |
742633 | 742633 | 2020-11-18 | Warren | Illinois | 17187 | 875 | 14 |
739386 | 739386 | 2020-11-17 | Warren | Illinois | 17187 | 855 | 13 |
736142 | 736142 | 2020-11-16 | Warren | Illinois | 17187 | 848 | 12 |
732896 | 732896 | 2020-11-15 | Warren | Illinois | 17187 | 835 | 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);