ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Will" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193808 | 1193808 | 2021-04-06 | Will | Illinois | 17197 | 69467 | 1021 |
1190558 | 1190558 | 2021-04-05 | Will | Illinois | 17197 | 69270 | 1019 |
1187311 | 1187311 | 2021-04-04 | Will | Illinois | 17197 | 69148 | 1019 |
1184064 | 1184064 | 2021-04-03 | Will | Illinois | 17197 | 69001 | 1019 |
1180817 | 1180817 | 2021-04-02 | Will | Illinois | 17197 | 68836 | 1019 |
1177570 | 1177570 | 2021-04-01 | Will | Illinois | 17197 | 68663 | 1017 |
1174323 | 1174323 | 2021-03-31 | Will | Illinois | 17197 | 68489 | 1015 |
1171076 | 1171076 | 2021-03-30 | Will | Illinois | 17197 | 68386 | 1015 |
1167828 | 1167828 | 2021-03-29 | Will | Illinois | 17197 | 68246 | 1014 |
1164580 | 1164580 | 2021-03-28 | Will | Illinois | 17197 | 68145 | 1014 |
1161332 | 1161332 | 2021-03-27 | Will | Illinois | 17197 | 68028 | 1014 |
1158084 | 1158084 | 2021-03-26 | Will | Illinois | 17197 | 67867 | 1009 |
1154837 | 1154837 | 2021-03-25 | Will | Illinois | 17197 | 67707 | 1008 |
1151590 | 1151590 | 2021-03-24 | Will | Illinois | 17197 | 67604 | 1007 |
1148343 | 1148343 | 2021-03-23 | Will | Illinois | 17197 | 67435 | 1007 |
1145096 | 1145096 | 2021-03-22 | Will | Illinois | 17197 | 67374 | 1006 |
1141849 | 1141849 | 2021-03-21 | Will | Illinois | 17197 | 67282 | 1005 |
1138603 | 1138603 | 2021-03-20 | Will | Illinois | 17197 | 67206 | 1005 |
1135357 | 1135357 | 2021-03-19 | Will | Illinois | 17197 | 67085 | 1004 |
1132110 | 1132110 | 2021-03-18 | Will | Illinois | 17197 | 66940 | 1004 |
1128862 | 1128862 | 2021-03-17 | Will | Illinois | 17197 | 66817 | 999 |
1125616 | 1125616 | 2021-03-16 | Will | Illinois | 17197 | 66737 | 998 |
1122370 | 1122370 | 2021-03-15 | Will | Illinois | 17197 | 66632 | 996 |
1119123 | 1119123 | 2021-03-14 | Will | Illinois | 17197 | 66597 | 995 |
1115876 | 1115876 | 2021-03-13 | Will | Illinois | 17197 | 66517 | 994 |
1112630 | 1112630 | 2021-03-12 | Will | Illinois | 17197 | 66457 | 992 |
1109384 | 1109384 | 2021-03-11 | Will | Illinois | 17197 | 66329 | 989 |
1106138 | 1106138 | 2021-03-10 | Will | Illinois | 17197 | 66220 | 987 |
1102892 | 1102892 | 2021-03-09 | Will | Illinois | 17197 | 66087 | 986 |
1099646 | 1099646 | 2021-03-08 | Will | Illinois | 17197 | 65970 | 986 |
1096398 | 1096398 | 2021-03-07 | Will | Illinois | 17197 | 65885 | 986 |
1093152 | 1093152 | 2021-03-06 | Will | Illinois | 17197 | 65821 | 985 |
1089906 | 1089906 | 2021-03-05 | Will | Illinois | 17197 | 65561 | 979 |
1086661 | 1086661 | 2021-03-04 | Will | Illinois | 17197 | 65442 | 976 |
1083415 | 1083415 | 2021-03-03 | Will | Illinois | 17197 | 65325 | 970 |
1080169 | 1080169 | 2021-03-02 | Will | Illinois | 17197 | 65201 | 968 |
1076924 | 1076924 | 2021-03-01 | Will | Illinois | 17197 | 65092 | 967 |
1073678 | 1073678 | 2021-02-28 | Will | Illinois | 17197 | 65037 | 966 |
1070432 | 1070432 | 2021-02-27 | Will | Illinois | 17197 | 64954 | 965 |
1067187 | 1067187 | 2021-02-26 | Will | Illinois | 17197 | 64803 | 960 |
1063942 | 1063942 | 2021-02-25 | Will | Illinois | 17197 | 64655 | 958 |
1060697 | 1060697 | 2021-02-24 | Will | Illinois | 17197 | 64552 | 956 |
1057451 | 1057451 | 2021-02-23 | Will | Illinois | 17197 | 64432 | 955 |
1054205 | 1054205 | 2021-02-22 | Will | Illinois | 17197 | 64320 | 955 |
1050958 | 1050958 | 2021-02-21 | Will | Illinois | 17197 | 64251 | 955 |
1047711 | 1047711 | 2021-02-20 | Will | Illinois | 17197 | 64131 | 953 |
1044466 | 1044466 | 2021-02-19 | Will | Illinois | 17197 | 63994 | 952 |
1041221 | 1041221 | 2021-02-18 | Will | Illinois | 17197 | 63856 | 951 |
1037976 | 1037976 | 2021-02-17 | Will | Illinois | 17197 | 63707 | 948 |
1034731 | 1034731 | 2021-02-16 | Will | Illinois | 17197 | 63558 | 947 |
1031485 | 1031485 | 2021-02-15 | Will | Illinois | 17197 | 63481 | 946 |
1028238 | 1028238 | 2021-02-14 | Will | Illinois | 17197 | 63393 | 943 |
1024993 | 1024993 | 2021-02-13 | Will | Illinois | 17197 | 63270 | 942 |
1021748 | 1021748 | 2021-02-12 | Will | Illinois | 17197 | 63176 | 942 |
1018503 | 1018503 | 2021-02-11 | Will | Illinois | 17197 | 63022 | 942 |
1015258 | 1015258 | 2021-02-10 | Will | Illinois | 17197 | 62814 | 934 |
1012013 | 1012013 | 2021-02-09 | Will | Illinois | 17197 | 62688 | 933 |
1008767 | 1008767 | 2021-02-08 | Will | Illinois | 17197 | 62566 | 933 |
1005521 | 1005521 | 2021-02-07 | Will | Illinois | 17197 | 62435 | 933 |
1002275 | 1002275 | 2021-02-06 | Will | Illinois | 17197 | 62303 | 933 |
999029 | 999029 | 2021-02-05 | Will | Illinois | 17197 | 62143 | 931 |
995783 | 995783 | 2021-02-04 | Will | Illinois | 17197 | 61943 | 927 |
992537 | 992537 | 2021-02-03 | Will | Illinois | 17197 | 61737 | 920 |
989291 | 989291 | 2021-02-02 | Will | Illinois | 17197 | 61556 | 916 |
986044 | 986044 | 2021-02-01 | Will | Illinois | 17197 | 61416 | 913 |
982797 | 982797 | 2021-01-31 | Will | Illinois | 17197 | 61289 | 908 |
979551 | 979551 | 2021-01-30 | Will | Illinois | 17197 | 61134 | 908 |
976305 | 976305 | 2021-01-29 | Will | Illinois | 17197 | 60910 | 908 |
973060 | 973060 | 2021-01-28 | Will | Illinois | 17197 | 60614 | 904 |
969815 | 969815 | 2021-01-27 | Will | Illinois | 17197 | 60378 | 898 |
966571 | 966571 | 2021-01-26 | Will | Illinois | 17197 | 60159 | 896 |
963326 | 963326 | 2021-01-25 | Will | Illinois | 17197 | 59914 | 891 |
960081 | 960081 | 2021-01-24 | Will | Illinois | 17197 | 59768 | 888 |
956835 | 956835 | 2021-01-23 | Will | Illinois | 17197 | 59559 | 887 |
953590 | 953590 | 2021-01-22 | Will | Illinois | 17197 | 59269 | 886 |
950345 | 950345 | 2021-01-21 | Will | Illinois | 17197 | 58974 | 881 |
947099 | 947099 | 2021-01-20 | Will | Illinois | 17197 | 58681 | 876 |
943852 | 943852 | 2021-01-19 | Will | Illinois | 17197 | 58408 | 870 |
940607 | 940607 | 2021-01-18 | Will | Illinois | 17197 | 58209 | 870 |
937362 | 937362 | 2021-01-17 | Will | Illinois | 17197 | 57945 | 867 |
934117 | 934117 | 2021-01-16 | Will | Illinois | 17197 | 57707 | 867 |
930872 | 930872 | 2021-01-15 | Will | Illinois | 17197 | 57429 | 861 |
927627 | 927627 | 2021-01-14 | Will | Illinois | 17197 | 57104 | 856 |
924381 | 924381 | 2021-01-13 | Will | Illinois | 17197 | 56766 | 851 |
921136 | 921136 | 2021-01-12 | Will | Illinois | 17197 | 56435 | 845 |
917891 | 917891 | 2021-01-11 | Will | Illinois | 17197 | 56145 | 837 |
914646 | 914646 | 2021-01-10 | Will | Illinois | 17197 | 55872 | 835 |
911401 | 911401 | 2021-01-09 | Will | Illinois | 17197 | 55611 | 833 |
908156 | 908156 | 2021-01-08 | Will | Illinois | 17197 | 55181 | 824 |
904910 | 904910 | 2021-01-07 | Will | Illinois | 17197 | 54678 | 815 |
901665 | 901665 | 2021-01-06 | Will | Illinois | 17197 | 54211 | 806 |
898420 | 898420 | 2021-01-05 | Will | Illinois | 17197 | 53778 | 795 |
895175 | 895175 | 2021-01-04 | Will | Illinois | 17197 | 53443 | 792 |
891928 | 891928 | 2021-01-03 | Will | Illinois | 17197 | 53165 | 789 |
888682 | 888682 | 2021-01-02 | Will | Illinois | 17197 | 52899 | 788 |
885436 | 885436 | 2021-01-01 | Will | Illinois | 17197 | 52293 | 780 |
882191 | 882191 | 2020-12-31 | Will | Illinois | 17197 | 52293 | 780 |
878946 | 878946 | 2020-12-30 | Will | Illinois | 17197 | 51794 | 773 |
875701 | 875701 | 2020-12-29 | Will | Illinois | 17197 | 51466 | 767 |
872456 | 872456 | 2020-12-28 | Will | Illinois | 17197 | 51137 | 761 |
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);