ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Lake" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193758 | 1193758 | 2021-04-06 | Lake | Illinois | 17097 | 62986 | 1027 |
1190508 | 1190508 | 2021-04-05 | Lake | Illinois | 17097 | 62863 | 1026 |
1187261 | 1187261 | 2021-04-04 | Lake | Illinois | 17097 | 62746 | 1024 |
1184014 | 1184014 | 2021-04-03 | Lake | Illinois | 17097 | 62686 | 1024 |
1180767 | 1180767 | 2021-04-02 | Lake | Illinois | 17097 | 62533 | 1023 |
1177520 | 1177520 | 2021-04-01 | Lake | Illinois | 17097 | 62368 | 1023 |
1174273 | 1174273 | 2021-03-31 | Lake | Illinois | 17097 | 62242 | 1023 |
1171026 | 1171026 | 2021-03-30 | Lake | Illinois | 17097 | 62133 | 1022 |
1167778 | 1167778 | 2021-03-29 | Lake | Illinois | 17097 | 62024 | 1021 |
1164530 | 1164530 | 2021-03-28 | Lake | Illinois | 17097 | 61940 | 1021 |
1161282 | 1161282 | 2021-03-27 | Lake | Illinois | 17097 | 61869 | 1020 |
1158034 | 1158034 | 2021-03-26 | Lake | Illinois | 17097 | 61775 | 1020 |
1154787 | 1154787 | 2021-03-25 | Lake | Illinois | 17097 | 61652 | 1018 |
1151540 | 1151540 | 2021-03-24 | Lake | Illinois | 17097 | 61584 | 1017 |
1148293 | 1148293 | 2021-03-23 | Lake | Illinois | 17097 | 61486 | 1018 |
1145046 | 1145046 | 2021-03-22 | Lake | Illinois | 17097 | 61407 | 1018 |
1141799 | 1141799 | 2021-03-21 | Lake | Illinois | 17097 | 61355 | 1017 |
1138553 | 1138553 | 2021-03-20 | Lake | Illinois | 17097 | 61293 | 1017 |
1135307 | 1135307 | 2021-03-19 | Lake | Illinois | 17097 | 61225 | 1017 |
1132060 | 1132060 | 2021-03-18 | Lake | Illinois | 17097 | 61110 | 1014 |
1128812 | 1128812 | 2021-03-17 | Lake | Illinois | 17097 | 61006 | 1013 |
1125566 | 1125566 | 2021-03-16 | Lake | Illinois | 17097 | 60934 | 1014 |
1122320 | 1122320 | 2021-03-15 | Lake | Illinois | 17097 | 60810 | 1014 |
1119073 | 1119073 | 2021-03-14 | Lake | Illinois | 17097 | 60800 | 1014 |
1115826 | 1115826 | 2021-03-13 | Lake | Illinois | 17097 | 60716 | 1012 |
1112580 | 1112580 | 2021-03-12 | Lake | Illinois | 17097 | 60603 | 1012 |
1109334 | 1109334 | 2021-03-11 | Lake | Illinois | 17097 | 60481 | 1011 |
1106088 | 1106088 | 2021-03-10 | Lake | Illinois | 17097 | 60407 | 1009 |
1102842 | 1102842 | 2021-03-09 | Lake | Illinois | 17097 | 60298 | 1007 |
1099596 | 1099596 | 2021-03-08 | Lake | Illinois | 17097 | 60237 | 1005 |
1096348 | 1096348 | 2021-03-07 | Lake | Illinois | 17097 | 60155 | 1005 |
1093102 | 1093102 | 2021-03-06 | Lake | Illinois | 17097 | 60112 | 1004 |
1089856 | 1089856 | 2021-03-05 | Lake | Illinois | 17097 | 59972 | 1002 |
1086611 | 1086611 | 2021-03-04 | Lake | Illinois | 17097 | 59899 | 1000 |
1083365 | 1083365 | 2021-03-03 | Lake | Illinois | 17097 | 59784 | 995 |
1080119 | 1080119 | 2021-03-02 | Lake | Illinois | 17097 | 59682 | 995 |
1076874 | 1076874 | 2021-03-01 | Lake | Illinois | 17097 | 59589 | 994 |
1073628 | 1073628 | 2021-02-28 | Lake | Illinois | 17097 | 59517 | 992 |
1070382 | 1070382 | 2021-02-27 | Lake | Illinois | 17097 | 59408 | 992 |
1067137 | 1067137 | 2021-02-26 | Lake | Illinois | 17097 | 59315 | 990 |
1063892 | 1063892 | 2021-02-25 | Lake | Illinois | 17097 | 59119 | 989 |
1060647 | 1060647 | 2021-02-24 | Lake | Illinois | 17097 | 58996 | 988 |
1057401 | 1057401 | 2021-02-23 | Lake | Illinois | 17097 | 58864 | 986 |
1054155 | 1054155 | 2021-02-22 | Lake | Illinois | 17097 | 58770 | 986 |
1050908 | 1050908 | 2021-02-21 | Lake | Illinois | 17097 | 58711 | 985 |
1047661 | 1047661 | 2021-02-20 | Lake | Illinois | 17097 | 58618 | 985 |
1044416 | 1044416 | 2021-02-19 | Lake | Illinois | 17097 | 58508 | 984 |
1041171 | 1041171 | 2021-02-18 | Lake | Illinois | 17097 | 58393 | 981 |
1037926 | 1037926 | 2021-02-17 | Lake | Illinois | 17097 | 58298 | 980 |
1034681 | 1034681 | 2021-02-16 | Lake | Illinois | 17097 | 58174 | 979 |
1031435 | 1031435 | 2021-02-15 | Lake | Illinois | 17097 | 58086 | 976 |
1028188 | 1028188 | 2021-02-14 | Lake | Illinois | 17097 | 58006 | 972 |
1024943 | 1024943 | 2021-02-13 | Lake | Illinois | 17097 | 57913 | 970 |
1021698 | 1021698 | 2021-02-12 | Lake | Illinois | 17097 | 57810 | 966 |
1018453 | 1018453 | 2021-02-11 | Lake | Illinois | 17097 | 57637 | 964 |
1015208 | 1015208 | 2021-02-10 | Lake | Illinois | 17097 | 57486 | 963 |
1011963 | 1011963 | 2021-02-09 | Lake | Illinois | 17097 | 57323 | 963 |
1008717 | 1008717 | 2021-02-08 | Lake | Illinois | 17097 | 57226 | 963 |
1005471 | 1005471 | 2021-02-07 | Lake | Illinois | 17097 | 57123 | 962 |
1002225 | 1002225 | 2021-02-06 | Lake | Illinois | 17097 | 57032 | 960 |
998979 | 998979 | 2021-02-05 | Lake | Illinois | 17097 | 56869 | 959 |
995733 | 995733 | 2021-02-04 | Lake | Illinois | 17097 | 56644 | 954 |
992487 | 992487 | 2021-02-03 | Lake | Illinois | 17097 | 56469 | 951 |
989241 | 989241 | 2021-02-02 | Lake | Illinois | 17097 | 56271 | 946 |
985994 | 985994 | 2021-02-01 | Lake | Illinois | 17097 | 56107 | 944 |
982747 | 982747 | 2021-01-31 | Lake | Illinois | 17097 | 55958 | 941 |
979501 | 979501 | 2021-01-30 | Lake | Illinois | 17097 | 55842 | 941 |
976256 | 976256 | 2021-01-29 | Lake | Illinois | 17097 | 55663 | 941 |
973011 | 973011 | 2021-01-28 | Lake | Illinois | 17097 | 55452 | 938 |
969766 | 969766 | 2021-01-27 | Lake | Illinois | 17097 | 55275 | 934 |
966522 | 966522 | 2021-01-26 | Lake | Illinois | 17097 | 55096 | 932 |
963277 | 963277 | 2021-01-25 | Lake | Illinois | 17097 | 54851 | 924 |
960032 | 960032 | 2021-01-24 | Lake | Illinois | 17097 | 54700 | 921 |
956786 | 956786 | 2021-01-23 | Lake | Illinois | 17097 | 54489 | 918 |
953541 | 953541 | 2021-01-22 | Lake | Illinois | 17097 | 54272 | 903 |
950296 | 950296 | 2021-01-21 | Lake | Illinois | 17097 | 53926 | 901 |
947050 | 947050 | 2021-01-20 | Lake | Illinois | 17097 | 53688 | 895 |
943803 | 943803 | 2021-01-19 | Lake | Illinois | 17097 | 53439 | 886 |
940558 | 940558 | 2021-01-18 | Lake | Illinois | 17097 | 53227 | 886 |
937313 | 937313 | 2021-01-17 | Lake | Illinois | 17097 | 53068 | 884 |
934068 | 934068 | 2021-01-16 | Lake | Illinois | 17097 | 52834 | 884 |
930823 | 930823 | 2021-01-15 | Lake | Illinois | 17097 | 52591 | 877 |
927578 | 927578 | 2021-01-14 | Lake | Illinois | 17097 | 52264 | 874 |
924332 | 924332 | 2021-01-13 | Lake | Illinois | 17097 | 51944 | 872 |
921087 | 921087 | 2021-01-12 | Lake | Illinois | 17097 | 51685 | 864 |
917842 | 917842 | 2021-01-11 | Lake | Illinois | 17097 | 51253 | 858 |
914597 | 914597 | 2021-01-10 | Lake | Illinois | 17097 | 51027 | 857 |
911352 | 911352 | 2021-01-09 | Lake | Illinois | 17097 | 50860 | 857 |
908107 | 908107 | 2021-01-08 | Lake | Illinois | 17097 | 50662 | 853 |
904861 | 904861 | 2021-01-07 | Lake | Illinois | 17097 | 50213 | 847 |
901616 | 901616 | 2021-01-06 | Lake | Illinois | 17097 | 49805 | 840 |
898371 | 898371 | 2021-01-05 | Lake | Illinois | 17097 | 49517 | 837 |
895126 | 895126 | 2021-01-04 | Lake | Illinois | 17097 | 49151 | 829 |
891879 | 891879 | 2021-01-03 | Lake | Illinois | 17097 | 48978 | 827 |
888632 | 888632 | 2021-01-02 | Lake | Illinois | 17097 | 48809 | 826 |
885387 | 885387 | 2021-01-01 | Lake | Illinois | 17097 | 48300 | 818 |
882142 | 882142 | 2020-12-31 | Lake | Illinois | 17097 | 48300 | 818 |
878897 | 878897 | 2020-12-30 | Lake | Illinois | 17097 | 47939 | 812 |
875652 | 875652 | 2020-12-29 | Lake | Illinois | 17097 | 47564 | 802 |
872407 | 872407 | 2020-12-28 | Lake | Illinois | 17097 | 47325 | 797 |
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);