ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17105 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193761 | 1193761 | 2021-04-06 | Livingston | Illinois | 17105 | 4454 | 93 |
1190511 | 1190511 | 2021-04-05 | Livingston | Illinois | 17105 | 4444 | 92 |
1187264 | 1187264 | 2021-04-04 | Livingston | Illinois | 17105 | 4436 | 92 |
1184017 | 1184017 | 2021-04-03 | Livingston | Illinois | 17105 | 4433 | 92 |
1180770 | 1180770 | 2021-04-02 | Livingston | Illinois | 17105 | 4428 | 92 |
1177523 | 1177523 | 2021-04-01 | Livingston | Illinois | 17105 | 4420 | 92 |
1174276 | 1174276 | 2021-03-31 | Livingston | Illinois | 17105 | 4412 | 92 |
1171029 | 1171029 | 2021-03-30 | Livingston | Illinois | 17105 | 4402 | 91 |
1167781 | 1167781 | 2021-03-29 | Livingston | Illinois | 17105 | 4392 | 91 |
1164533 | 1164533 | 2021-03-28 | Livingston | Illinois | 17105 | 4391 | 91 |
1161285 | 1161285 | 2021-03-27 | Livingston | Illinois | 17105 | 4387 | 91 |
1158037 | 1158037 | 2021-03-26 | Livingston | Illinois | 17105 | 4383 | 91 |
1154790 | 1154790 | 2021-03-25 | Livingston | Illinois | 17105 | 4377 | 91 |
1151543 | 1151543 | 2021-03-24 | Livingston | Illinois | 17105 | 4372 | 91 |
1148296 | 1148296 | 2021-03-23 | Livingston | Illinois | 17105 | 4357 | 91 |
1145049 | 1145049 | 2021-03-22 | Livingston | Illinois | 17105 | 4352 | 91 |
1141802 | 1141802 | 2021-03-21 | Livingston | Illinois | 17105 | 4349 | 91 |
1138556 | 1138556 | 2021-03-20 | Livingston | Illinois | 17105 | 4345 | 91 |
1135310 | 1135310 | 2021-03-19 | Livingston | Illinois | 17105 | 4338 | 91 |
1132063 | 1132063 | 2021-03-18 | Livingston | Illinois | 17105 | 4331 | 91 |
1128815 | 1128815 | 2021-03-17 | Livingston | Illinois | 17105 | 4329 | 91 |
1125569 | 1125569 | 2021-03-16 | Livingston | Illinois | 17105 | 4322 | 91 |
1122323 | 1122323 | 2021-03-15 | Livingston | Illinois | 17105 | 4310 | 91 |
1119076 | 1119076 | 2021-03-14 | Livingston | Illinois | 17105 | 4309 | 91 |
1115829 | 1115829 | 2021-03-13 | Livingston | Illinois | 17105 | 4308 | 91 |
1112583 | 1112583 | 2021-03-12 | Livingston | Illinois | 17105 | 4293 | 91 |
1109337 | 1109337 | 2021-03-11 | Livingston | Illinois | 17105 | 4287 | 91 |
1106091 | 1106091 | 2021-03-10 | Livingston | Illinois | 17105 | 4279 | 91 |
1102845 | 1102845 | 2021-03-09 | Livingston | Illinois | 17105 | 4275 | 91 |
1099599 | 1099599 | 2021-03-08 | Livingston | Illinois | 17105 | 4272 | 91 |
1096351 | 1096351 | 2021-03-07 | Livingston | Illinois | 17105 | 4269 | 91 |
1093105 | 1093105 | 2021-03-06 | Livingston | Illinois | 17105 | 4259 | 90 |
1089859 | 1089859 | 2021-03-05 | Livingston | Illinois | 17105 | 4252 | 89 |
1086614 | 1086614 | 2021-03-04 | Livingston | Illinois | 17105 | 4244 | 89 |
1083368 | 1083368 | 2021-03-03 | Livingston | Illinois | 17105 | 4235 | 89 |
1080122 | 1080122 | 2021-03-02 | Livingston | Illinois | 17105 | 4225 | 89 |
1076877 | 1076877 | 2021-03-01 | Livingston | Illinois | 17105 | 4206 | 89 |
1073631 | 1073631 | 2021-02-28 | Livingston | Illinois | 17105 | 4198 | 89 |
1070385 | 1070385 | 2021-02-27 | Livingston | Illinois | 17105 | 4198 | 88 |
1067140 | 1067140 | 2021-02-26 | Livingston | Illinois | 17105 | 4181 | 88 |
1063895 | 1063895 | 2021-02-25 | Livingston | Illinois | 17105 | 4164 | 87 |
1060650 | 1060650 | 2021-02-24 | Livingston | Illinois | 17105 | 4151 | 87 |
1057404 | 1057404 | 2021-02-23 | Livingston | Illinois | 17105 | 4144 | 87 |
1054158 | 1054158 | 2021-02-22 | Livingston | Illinois | 17105 | 4132 | 87 |
1050911 | 1050911 | 2021-02-21 | Livingston | Illinois | 17105 | 4127 | 86 |
1047664 | 1047664 | 2021-02-20 | Livingston | Illinois | 17105 | 4120 | 86 |
1044419 | 1044419 | 2021-02-19 | Livingston | Illinois | 17105 | 4108 | 85 |
1041174 | 1041174 | 2021-02-18 | Livingston | Illinois | 17105 | 4098 | 84 |
1037929 | 1037929 | 2021-02-17 | Livingston | Illinois | 17105 | 4089 | 84 |
1034684 | 1034684 | 2021-02-16 | Livingston | Illinois | 17105 | 4081 | 84 |
1031438 | 1031438 | 2021-02-15 | Livingston | Illinois | 17105 | 4073 | 84 |
1028191 | 1028191 | 2021-02-14 | Livingston | Illinois | 17105 | 4062 | 84 |
1024946 | 1024946 | 2021-02-13 | Livingston | Illinois | 17105 | 4060 | 83 |
1021701 | 1021701 | 2021-02-12 | Livingston | Illinois | 17105 | 4048 | 83 |
1018456 | 1018456 | 2021-02-11 | Livingston | Illinois | 17105 | 4039 | 82 |
1015211 | 1015211 | 2021-02-10 | Livingston | Illinois | 17105 | 4034 | 81 |
1011966 | 1011966 | 2021-02-09 | Livingston | Illinois | 17105 | 4027 | 81 |
1008720 | 1008720 | 2021-02-08 | Livingston | Illinois | 17105 | 4023 | 81 |
1005474 | 1005474 | 2021-02-07 | Livingston | Illinois | 17105 | 4015 | 81 |
1002228 | 1002228 | 2021-02-06 | Livingston | Illinois | 17105 | 4005 | 81 |
998982 | 998982 | 2021-02-05 | Livingston | Illinois | 17105 | 4000 | 79 |
995736 | 995736 | 2021-02-04 | Livingston | Illinois | 17105 | 3980 | 77 |
992490 | 992490 | 2021-02-03 | Livingston | Illinois | 17105 | 3962 | 76 |
989244 | 989244 | 2021-02-02 | Livingston | Illinois | 17105 | 3955 | 76 |
985997 | 985997 | 2021-02-01 | Livingston | Illinois | 17105 | 3943 | 76 |
982750 | 982750 | 2021-01-31 | Livingston | Illinois | 17105 | 3932 | 74 |
979504 | 979504 | 2021-01-30 | Livingston | Illinois | 17105 | 3920 | 74 |
976259 | 976259 | 2021-01-29 | Livingston | Illinois | 17105 | 3899 | 74 |
973014 | 973014 | 2021-01-28 | Livingston | Illinois | 17105 | 3873 | 74 |
969769 | 969769 | 2021-01-27 | Livingston | Illinois | 17105 | 3857 | 73 |
966525 | 966525 | 2021-01-26 | Livingston | Illinois | 17105 | 3828 | 71 |
963280 | 963280 | 2021-01-25 | Livingston | Illinois | 17105 | 3811 | 70 |
960035 | 960035 | 2021-01-24 | Livingston | Illinois | 17105 | 3792 | 70 |
956789 | 956789 | 2021-01-23 | Livingston | Illinois | 17105 | 3779 | 70 |
953544 | 953544 | 2021-01-22 | Livingston | Illinois | 17105 | 3759 | 69 |
950299 | 950299 | 2021-01-21 | Livingston | Illinois | 17105 | 3697 | 68 |
947053 | 947053 | 2021-01-20 | Livingston | Illinois | 17105 | 3667 | 66 |
943806 | 943806 | 2021-01-19 | Livingston | Illinois | 17105 | 3647 | 66 |
940561 | 940561 | 2021-01-18 | Livingston | Illinois | 17105 | 3635 | 66 |
937316 | 937316 | 2021-01-17 | Livingston | Illinois | 17105 | 3624 | 66 |
934071 | 934071 | 2021-01-16 | Livingston | Illinois | 17105 | 3608 | 66 |
930826 | 930826 | 2021-01-15 | Livingston | Illinois | 17105 | 3579 | 66 |
927581 | 927581 | 2021-01-14 | Livingston | Illinois | 17105 | 3524 | 66 |
924335 | 924335 | 2021-01-13 | Livingston | Illinois | 17105 | 3481 | 65 |
921090 | 921090 | 2021-01-12 | Livingston | Illinois | 17105 | 3437 | 65 |
917845 | 917845 | 2021-01-11 | Livingston | Illinois | 17105 | 3403 | 65 |
914600 | 914600 | 2021-01-10 | Livingston | Illinois | 17105 | 3390 | 64 |
911355 | 911355 | 2021-01-09 | Livingston | Illinois | 17105 | 3362 | 64 |
908110 | 908110 | 2021-01-08 | Livingston | Illinois | 17105 | 3328 | 64 |
904864 | 904864 | 2021-01-07 | Livingston | Illinois | 17105 | 3280 | 62 |
901619 | 901619 | 2021-01-06 | Livingston | Illinois | 17105 | 3246 | 61 |
898374 | 898374 | 2021-01-05 | Livingston | Illinois | 17105 | 3220 | 60 |
895129 | 895129 | 2021-01-04 | Livingston | Illinois | 17105 | 3201 | 60 |
891882 | 891882 | 2021-01-03 | Livingston | Illinois | 17105 | 3180 | 60 |
888635 | 888635 | 2021-01-02 | Livingston | Illinois | 17105 | 3166 | 59 |
885390 | 885390 | 2021-01-01 | Livingston | Illinois | 17105 | 3140 | 58 |
882145 | 882145 | 2020-12-31 | Livingston | Illinois | 17105 | 3140 | 58 |
878900 | 878900 | 2020-12-30 | Livingston | Illinois | 17105 | 3118 | 58 |
875655 | 875655 | 2020-12-29 | Livingston | Illinois | 17105 | 3093 | 58 |
872410 | 872410 | 2020-12-28 | Livingston | Illinois | 17105 | 3059 | 58 |
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);