ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17161 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193789 | 1193789 | 2021-04-06 | Rock Island | Illinois | 17161 | 13873 | 342 |
1190539 | 1190539 | 2021-04-05 | Rock Island | Illinois | 17161 | 13861 | 341 |
1187292 | 1187292 | 2021-04-04 | Rock Island | Illinois | 17161 | 13827 | 341 |
1184045 | 1184045 | 2021-04-03 | Rock Island | Illinois | 17161 | 13821 | 341 |
1180798 | 1180798 | 2021-04-02 | Rock Island | Illinois | 17161 | 13783 | 341 |
1177551 | 1177551 | 2021-04-01 | Rock Island | Illinois | 17161 | 13735 | 340 |
1174304 | 1174304 | 2021-03-31 | Rock Island | Illinois | 17161 | 13673 | 340 |
1171057 | 1171057 | 2021-03-30 | Rock Island | Illinois | 17161 | 13646 | 339 |
1167809 | 1167809 | 2021-03-29 | Rock Island | Illinois | 17161 | 13624 | 339 |
1164561 | 1164561 | 2021-03-28 | Rock Island | Illinois | 17161 | 13606 | 339 |
1161313 | 1161313 | 2021-03-27 | Rock Island | Illinois | 17161 | 13587 | 339 |
1158065 | 1158065 | 2021-03-26 | Rock Island | Illinois | 17161 | 13561 | 339 |
1154818 | 1154818 | 2021-03-25 | Rock Island | Illinois | 17161 | 13508 | 339 |
1151571 | 1151571 | 2021-03-24 | Rock Island | Illinois | 17161 | 13488 | 339 |
1148324 | 1148324 | 2021-03-23 | Rock Island | Illinois | 17161 | 13462 | 338 |
1145077 | 1145077 | 2021-03-22 | Rock Island | Illinois | 17161 | 13438 | 338 |
1141830 | 1141830 | 2021-03-21 | Rock Island | Illinois | 17161 | 13432 | 337 |
1138584 | 1138584 | 2021-03-20 | Rock Island | Illinois | 17161 | 13420 | 337 |
1135338 | 1135338 | 2021-03-19 | Rock Island | Illinois | 17161 | 13404 | 337 |
1132091 | 1132091 | 2021-03-18 | Rock Island | Illinois | 17161 | 13385 | 336 |
1128843 | 1128843 | 2021-03-17 | Rock Island | Illinois | 17161 | 13375 | 334 |
1125597 | 1125597 | 2021-03-16 | Rock Island | Illinois | 17161 | 13353 | 334 |
1122351 | 1122351 | 2021-03-15 | Rock Island | Illinois | 17161 | 13342 | 333 |
1119104 | 1119104 | 2021-03-14 | Rock Island | Illinois | 17161 | 13337 | 333 |
1115857 | 1115857 | 2021-03-13 | Rock Island | Illinois | 17161 | 13312 | 332 |
1112611 | 1112611 | 2021-03-12 | Rock Island | Illinois | 17161 | 13303 | 332 |
1109365 | 1109365 | 2021-03-11 | Rock Island | Illinois | 17161 | 13271 | 332 |
1106119 | 1106119 | 2021-03-10 | Rock Island | Illinois | 17161 | 13264 | 332 |
1102873 | 1102873 | 2021-03-09 | Rock Island | Illinois | 17161 | 13240 | 331 |
1099627 | 1099627 | 2021-03-08 | Rock Island | Illinois | 17161 | 13214 | 330 |
1096379 | 1096379 | 2021-03-07 | Rock Island | Illinois | 17161 | 13203 | 330 |
1093133 | 1093133 | 2021-03-06 | Rock Island | Illinois | 17161 | 13169 | 330 |
1089887 | 1089887 | 2021-03-05 | Rock Island | Illinois | 17161 | 13140 | 330 |
1086642 | 1086642 | 2021-03-04 | Rock Island | Illinois | 17161 | 13132 | 331 |
1083396 | 1083396 | 2021-03-03 | Rock Island | Illinois | 17161 | 13110 | 331 |
1080150 | 1080150 | 2021-03-02 | Rock Island | Illinois | 17161 | 13083 | 329 |
1076905 | 1076905 | 2021-03-01 | Rock Island | Illinois | 17161 | 13069 | 329 |
1073659 | 1073659 | 2021-02-28 | Rock Island | Illinois | 17161 | 13065 | 329 |
1070413 | 1070413 | 2021-02-27 | Rock Island | Illinois | 17161 | 13056 | 329 |
1067168 | 1067168 | 2021-02-26 | Rock Island | Illinois | 17161 | 13042 | 329 |
1063923 | 1063923 | 2021-02-25 | Rock Island | Illinois | 17161 | 13030 | 329 |
1060678 | 1060678 | 2021-02-24 | Rock Island | Illinois | 17161 | 13011 | 328 |
1057432 | 1057432 | 2021-02-23 | Rock Island | Illinois | 17161 | 12991 | 328 |
1054186 | 1054186 | 2021-02-22 | Rock Island | Illinois | 17161 | 12983 | 328 |
1050939 | 1050939 | 2021-02-21 | Rock Island | Illinois | 17161 | 12969 | 328 |
1047692 | 1047692 | 2021-02-20 | Rock Island | Illinois | 17161 | 12933 | 328 |
1044447 | 1044447 | 2021-02-19 | Rock Island | Illinois | 17161 | 12912 | 328 |
1041202 | 1041202 | 2021-02-18 | Rock Island | Illinois | 17161 | 12892 | 326 |
1037957 | 1037957 | 2021-02-17 | Rock Island | Illinois | 17161 | 12866 | 324 |
1034712 | 1034712 | 2021-02-16 | Rock Island | Illinois | 17161 | 12842 | 323 |
1031466 | 1031466 | 2021-02-15 | Rock Island | Illinois | 17161 | 12829 | 323 |
1028219 | 1028219 | 2021-02-14 | Rock Island | Illinois | 17161 | 12818 | 323 |
1024974 | 1024974 | 2021-02-13 | Rock Island | Illinois | 17161 | 12796 | 323 |
1021729 | 1021729 | 2021-02-12 | Rock Island | Illinois | 17161 | 12772 | 322 |
1018484 | 1018484 | 2021-02-11 | Rock Island | Illinois | 17161 | 12743 | 321 |
1015239 | 1015239 | 2021-02-10 | Rock Island | Illinois | 17161 | 12714 | 321 |
1011994 | 1011994 | 2021-02-09 | Rock Island | Illinois | 17161 | 12667 | 321 |
1008748 | 1008748 | 2021-02-08 | Rock Island | Illinois | 17161 | 12638 | 321 |
1005502 | 1005502 | 2021-02-07 | Rock Island | Illinois | 17161 | 12618 | 321 |
1002256 | 1002256 | 2021-02-06 | Rock Island | Illinois | 17161 | 12595 | 321 |
999010 | 999010 | 2021-02-05 | Rock Island | Illinois | 17161 | 12571 | 321 |
995764 | 995764 | 2021-02-04 | Rock Island | Illinois | 17161 | 12526 | 316 |
992518 | 992518 | 2021-02-03 | Rock Island | Illinois | 17161 | 12480 | 314 |
989272 | 989272 | 2021-02-02 | Rock Island | Illinois | 17161 | 12447 | 314 |
986025 | 986025 | 2021-02-01 | Rock Island | Illinois | 17161 | 12439 | 314 |
982778 | 982778 | 2021-01-31 | Rock Island | Illinois | 17161 | 12426 | 312 |
979532 | 979532 | 2021-01-30 | Rock Island | Illinois | 17161 | 12392 | 312 |
976287 | 976287 | 2021-01-29 | Rock Island | Illinois | 17161 | 12360 | 312 |
973042 | 973042 | 2021-01-28 | Rock Island | Illinois | 17161 | 12327 | 311 |
969797 | 969797 | 2021-01-27 | Rock Island | Illinois | 17161 | 12295 | 311 |
966553 | 966553 | 2021-01-26 | Rock Island | Illinois | 17161 | 12252 | 310 |
963308 | 963308 | 2021-01-25 | Rock Island | Illinois | 17161 | 12229 | 308 |
960063 | 960063 | 2021-01-24 | Rock Island | Illinois | 17161 | 12195 | 308 |
956817 | 956817 | 2021-01-23 | Rock Island | Illinois | 17161 | 12168 | 307 |
953572 | 953572 | 2021-01-22 | Rock Island | Illinois | 17161 | 12127 | 306 |
950327 | 950327 | 2021-01-21 | Rock Island | Illinois | 17161 | 12027 | 304 |
947081 | 947081 | 2021-01-20 | Rock Island | Illinois | 17161 | 11977 | 304 |
943834 | 943834 | 2021-01-19 | Rock Island | Illinois | 17161 | 11919 | 303 |
940589 | 940589 | 2021-01-18 | Rock Island | Illinois | 17161 | 11860 | 302 |
937344 | 937344 | 2021-01-17 | Rock Island | Illinois | 17161 | 11834 | 302 |
934099 | 934099 | 2021-01-16 | Rock Island | Illinois | 17161 | 11805 | 302 |
930854 | 930854 | 2021-01-15 | Rock Island | Illinois | 17161 | 11752 | 301 |
927609 | 927609 | 2021-01-14 | Rock Island | Illinois | 17161 | 11688 | 301 |
924363 | 924363 | 2021-01-13 | Rock Island | Illinois | 17161 | 11636 | 298 |
921118 | 921118 | 2021-01-12 | Rock Island | Illinois | 17161 | 11595 | 294 |
917873 | 917873 | 2021-01-11 | Rock Island | Illinois | 17161 | 11548 | 291 |
914628 | 914628 | 2021-01-10 | Rock Island | Illinois | 17161 | 11514 | 291 |
911383 | 911383 | 2021-01-09 | Rock Island | Illinois | 17161 | 11467 | 291 |
908138 | 908138 | 2021-01-08 | Rock Island | Illinois | 17161 | 11418 | 284 |
904892 | 904892 | 2021-01-07 | Rock Island | Illinois | 17161 | 11345 | 279 |
901647 | 901647 | 2021-01-06 | Rock Island | Illinois | 17161 | 11260 | 274 |
898402 | 898402 | 2021-01-05 | Rock Island | Illinois | 17161 | 11208 | 271 |
895157 | 895157 | 2021-01-04 | Rock Island | Illinois | 17161 | 11162 | 266 |
891910 | 891910 | 2021-01-03 | Rock Island | Illinois | 17161 | 11134 | 263 |
888663 | 888663 | 2021-01-02 | Rock Island | Illinois | 17161 | 11117 | 264 |
885418 | 885418 | 2021-01-01 | Rock Island | Illinois | 17161 | 11014 | 259 |
882173 | 882173 | 2020-12-31 | Rock Island | Illinois | 17161 | 11014 | 259 |
878928 | 878928 | 2020-12-30 | Rock Island | Illinois | 17161 | 10938 | 254 |
875683 | 875683 | 2020-12-29 | Rock Island | Illinois | 17161 | 10890 | 248 |
872438 | 872438 | 2020-12-28 | Rock Island | Illinois | 17161 | 10828 | 243 |
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);