ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 17195 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193807 | 1193807 | 2021-04-06 | Whiteside | Illinois | 17195 | 6564 | 201 |
1190557 | 1190557 | 2021-04-05 | Whiteside | Illinois | 17195 | 6524 | 201 |
1187310 | 1187310 | 2021-04-04 | Whiteside | Illinois | 17195 | 6498 | 201 |
1184063 | 1184063 | 2021-04-03 | Whiteside | Illinois | 17195 | 6489 | 201 |
1180816 | 1180816 | 2021-04-02 | Whiteside | Illinois | 17195 | 6464 | 201 |
1177569 | 1177569 | 2021-04-01 | Whiteside | Illinois | 17195 | 6448 | 200 |
1174322 | 1174322 | 2021-03-31 | Whiteside | Illinois | 17195 | 6418 | 200 |
1171075 | 1171075 | 2021-03-30 | Whiteside | Illinois | 17195 | 6373 | 200 |
1167827 | 1167827 | 2021-03-29 | Whiteside | Illinois | 17195 | 6345 | 198 |
1164579 | 1164579 | 2021-03-28 | Whiteside | Illinois | 17195 | 6324 | 197 |
1161331 | 1161331 | 2021-03-27 | Whiteside | Illinois | 17195 | 6322 | 197 |
1158083 | 1158083 | 2021-03-26 | Whiteside | Illinois | 17195 | 6295 | 197 |
1154836 | 1154836 | 2021-03-25 | Whiteside | Illinois | 17195 | 6260 | 197 |
1151589 | 1151589 | 2021-03-24 | Whiteside | Illinois | 17195 | 6226 | 196 |
1148342 | 1148342 | 2021-03-23 | Whiteside | Illinois | 17195 | 6199 | 196 |
1145095 | 1145095 | 2021-03-22 | Whiteside | Illinois | 17195 | 6188 | 196 |
1141848 | 1141848 | 2021-03-21 | Whiteside | Illinois | 17195 | 6170 | 196 |
1138602 | 1138602 | 2021-03-20 | Whiteside | Illinois | 17195 | 6169 | 196 |
1135356 | 1135356 | 2021-03-19 | Whiteside | Illinois | 17195 | 6148 | 196 |
1132109 | 1132109 | 2021-03-18 | Whiteside | Illinois | 17195 | 6133 | 195 |
1128861 | 1128861 | 2021-03-17 | Whiteside | Illinois | 17195 | 6112 | 193 |
1125615 | 1125615 | 2021-03-16 | Whiteside | Illinois | 17195 | 6099 | 193 |
1122369 | 1122369 | 2021-03-15 | Whiteside | Illinois | 17195 | 6088 | 193 |
1119122 | 1119122 | 2021-03-14 | Whiteside | Illinois | 17195 | 6076 | 193 |
1115875 | 1115875 | 2021-03-13 | Whiteside | Illinois | 17195 | 6071 | 192 |
1112629 | 1112629 | 2021-03-12 | Whiteside | Illinois | 17195 | 6061 | 192 |
1109383 | 1109383 | 2021-03-11 | Whiteside | Illinois | 17195 | 6047 | 192 |
1106137 | 1106137 | 2021-03-10 | Whiteside | Illinois | 17195 | 6030 | 192 |
1102891 | 1102891 | 2021-03-09 | Whiteside | Illinois | 17195 | 6030 | 192 |
1099645 | 1099645 | 2021-03-08 | Whiteside | Illinois | 17195 | 6022 | 192 |
1096397 | 1096397 | 2021-03-07 | Whiteside | Illinois | 17195 | 6022 | 192 |
1093151 | 1093151 | 2021-03-06 | Whiteside | Illinois | 17195 | 6022 | 192 |
1089905 | 1089905 | 2021-03-05 | Whiteside | Illinois | 17195 | 6019 | 191 |
1086660 | 1086660 | 2021-03-04 | Whiteside | Illinois | 17195 | 6016 | 190 |
1083414 | 1083414 | 2021-03-03 | Whiteside | Illinois | 17195 | 6011 | 190 |
1080168 | 1080168 | 2021-03-02 | Whiteside | Illinois | 17195 | 6007 | 189 |
1076923 | 1076923 | 2021-03-01 | Whiteside | Illinois | 17195 | 5997 | 189 |
1073677 | 1073677 | 2021-02-28 | Whiteside | Illinois | 17195 | 5994 | 189 |
1070431 | 1070431 | 2021-02-27 | Whiteside | Illinois | 17195 | 5992 | 189 |
1067186 | 1067186 | 2021-02-26 | Whiteside | Illinois | 17195 | 5987 | 189 |
1063941 | 1063941 | 2021-02-25 | Whiteside | Illinois | 17195 | 5960 | 189 |
1060696 | 1060696 | 2021-02-24 | Whiteside | Illinois | 17195 | 5960 | 188 |
1057450 | 1057450 | 2021-02-23 | Whiteside | Illinois | 17195 | 5955 | 188 |
1054204 | 1054204 | 2021-02-22 | Whiteside | Illinois | 17195 | 5928 | 188 |
1050957 | 1050957 | 2021-02-21 | Whiteside | Illinois | 17195 | 5928 | 188 |
1047710 | 1047710 | 2021-02-20 | Whiteside | Illinois | 17195 | 5923 | 187 |
1044465 | 1044465 | 2021-02-19 | Whiteside | Illinois | 17195 | 5914 | 187 |
1041220 | 1041220 | 2021-02-18 | Whiteside | Illinois | 17195 | 5901 | 187 |
1037975 | 1037975 | 2021-02-17 | Whiteside | Illinois | 17195 | 5879 | 186 |
1034730 | 1034730 | 2021-02-16 | Whiteside | Illinois | 17195 | 5875 | 186 |
1031484 | 1031484 | 2021-02-15 | Whiteside | Illinois | 17195 | 5865 | 185 |
1028237 | 1028237 | 2021-02-14 | Whiteside | Illinois | 17195 | 5859 | 185 |
1024992 | 1024992 | 2021-02-13 | Whiteside | Illinois | 17195 | 5836 | 184 |
1021747 | 1021747 | 2021-02-12 | Whiteside | Illinois | 17195 | 5836 | 184 |
1018502 | 1018502 | 2021-02-11 | Whiteside | Illinois | 17195 | 5796 | 184 |
1015257 | 1015257 | 2021-02-10 | Whiteside | Illinois | 17195 | 5796 | 182 |
1012012 | 1012012 | 2021-02-09 | Whiteside | Illinois | 17195 | 5761 | 182 |
1008766 | 1008766 | 2021-02-08 | Whiteside | Illinois | 17195 | 5750 | 182 |
1005520 | 1005520 | 2021-02-07 | Whiteside | Illinois | 17195 | 5745 | 181 |
1002274 | 1002274 | 2021-02-06 | Whiteside | Illinois | 17195 | 5740 | 181 |
999028 | 999028 | 2021-02-05 | Whiteside | Illinois | 17195 | 5727 | 181 |
995782 | 995782 | 2021-02-04 | Whiteside | Illinois | 17195 | 5704 | 181 |
992536 | 992536 | 2021-02-03 | Whiteside | Illinois | 17195 | 5680 | 180 |
989290 | 989290 | 2021-02-02 | Whiteside | Illinois | 17195 | 5648 | 180 |
986043 | 986043 | 2021-02-01 | Whiteside | Illinois | 17195 | 5648 | 180 |
982796 | 982796 | 2021-01-31 | Whiteside | Illinois | 17195 | 5636 | 178 |
979550 | 979550 | 2021-01-30 | Whiteside | Illinois | 17195 | 5636 | 178 |
976304 | 976304 | 2021-01-29 | Whiteside | Illinois | 17195 | 5610 | 178 |
973059 | 973059 | 2021-01-28 | Whiteside | Illinois | 17195 | 5590 | 177 |
969814 | 969814 | 2021-01-27 | Whiteside | Illinois | 17195 | 5556 | 176 |
966570 | 966570 | 2021-01-26 | Whiteside | Illinois | 17195 | 5533 | 176 |
963325 | 963325 | 2021-01-25 | Whiteside | Illinois | 17195 | 5516 | 175 |
960080 | 960080 | 2021-01-24 | Whiteside | Illinois | 17195 | 5487 | 175 |
956834 | 956834 | 2021-01-23 | Whiteside | Illinois | 17195 | 5487 | 175 |
953589 | 953589 | 2021-01-22 | Whiteside | Illinois | 17195 | 5444 | 175 |
950344 | 950344 | 2021-01-21 | Whiteside | Illinois | 17195 | 5444 | 175 |
947098 | 947098 | 2021-01-20 | Whiteside | Illinois | 17195 | 5404 | 174 |
943851 | 943851 | 2021-01-19 | Whiteside | Illinois | 17195 | 5375 | 173 |
940606 | 940606 | 2021-01-18 | Whiteside | Illinois | 17195 | 5354 | 173 |
937361 | 937361 | 2021-01-17 | Whiteside | Illinois | 17195 | 5350 | 173 |
934116 | 934116 | 2021-01-16 | Whiteside | Illinois | 17195 | 5342 | 173 |
930871 | 930871 | 2021-01-15 | Whiteside | Illinois | 17195 | 5323 | 173 |
927626 | 927626 | 2021-01-14 | Whiteside | Illinois | 17195 | 5297 | 172 |
924380 | 924380 | 2021-01-13 | Whiteside | Illinois | 17195 | 5265 | 172 |
921135 | 921135 | 2021-01-12 | Whiteside | Illinois | 17195 | 5225 | 172 |
917890 | 917890 | 2021-01-11 | Whiteside | Illinois | 17195 | 5225 | 171 |
914645 | 914645 | 2021-01-10 | Whiteside | Illinois | 17195 | 5217 | 170 |
911400 | 911400 | 2021-01-09 | Whiteside | Illinois | 17195 | 5204 | 170 |
908155 | 908155 | 2021-01-08 | Whiteside | Illinois | 17195 | 5183 | 169 |
904909 | 904909 | 2021-01-07 | Whiteside | Illinois | 17195 | 5153 | 168 |
901664 | 901664 | 2021-01-06 | Whiteside | Illinois | 17195 | 5110 | 166 |
898419 | 898419 | 2021-01-05 | Whiteside | Illinois | 17195 | 5074 | 164 |
895174 | 895174 | 2021-01-04 | Whiteside | Illinois | 17195 | 5022 | 163 |
891927 | 891927 | 2021-01-03 | Whiteside | Illinois | 17195 | 5022 | 163 |
888681 | 888681 | 2021-01-02 | Whiteside | Illinois | 17195 | 5018 | 162 |
885435 | 885435 | 2021-01-01 | Whiteside | Illinois | 17195 | 4982 | 160 |
882190 | 882190 | 2020-12-31 | Whiteside | Illinois | 17195 | 4956 | 160 |
878945 | 878945 | 2020-12-30 | Whiteside | Illinois | 17195 | 4896 | 158 |
875700 | 875700 | 2020-12-29 | Whiteside | Illinois | 17195 | 4815 | 154 |
872455 | 872455 | 2020-12-28 | Whiteside | Illinois | 17195 | 4815 | 154 |
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);