ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17099 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1274945 | 1274945 | 2021-05-01 | LaSalle | Illinois | 17099 | 12212 | 293 |
1271698 | 1271698 | 2021-04-30 | LaSalle | Illinois | 17099 | 12175 | 292 |
1268451 | 1268451 | 2021-04-29 | LaSalle | Illinois | 17099 | 12129 | 290 |
1265204 | 1265204 | 2021-04-28 | LaSalle | Illinois | 17099 | 12094 | 289 |
1261957 | 1261957 | 2021-04-27 | LaSalle | Illinois | 17099 | 12049 | 289 |
1258710 | 1258710 | 2021-04-26 | LaSalle | Illinois | 17099 | 12011 | 289 |
1255463 | 1255463 | 2021-04-25 | LaSalle | Illinois | 17099 | 11988 | 289 |
1252216 | 1252216 | 2021-04-24 | LaSalle | Illinois | 17099 | 11963 | 288 |
1248969 | 1248969 | 2021-04-23 | LaSalle | Illinois | 17099 | 11917 | 288 |
1245722 | 1245722 | 2021-04-22 | LaSalle | Illinois | 17099 | 11878 | 288 |
1242475 | 1242475 | 2021-04-21 | LaSalle | Illinois | 17099 | 11835 | 287 |
1239228 | 1239228 | 2021-04-20 | LaSalle | Illinois | 17099 | 11800 | 287 |
1235981 | 1235981 | 2021-04-19 | LaSalle | Illinois | 17099 | 11786 | 287 |
1232734 | 1232734 | 2021-04-18 | LaSalle | Illinois | 17099 | 11755 | 287 |
1229485 | 1229485 | 2021-04-17 | LaSalle | Illinois | 17099 | 11739 | 286 |
1226237 | 1226237 | 2021-04-16 | LaSalle | Illinois | 17099 | 11706 | 286 |
1222990 | 1222990 | 2021-04-15 | LaSalle | Illinois | 17099 | 11664 | 285 |
1219742 | 1219742 | 2021-04-14 | LaSalle | Illinois | 17099 | 11634 | 283 |
1216494 | 1216494 | 2021-04-13 | LaSalle | Illinois | 17099 | 11594 | 283 |
1213247 | 1213247 | 2021-04-12 | LaSalle | Illinois | 17099 | 11553 | 283 |
1209999 | 1209999 | 2021-04-11 | LaSalle | Illinois | 17099 | 11537 | 283 |
1206750 | 1206750 | 2021-04-10 | LaSalle | Illinois | 17099 | 11518 | 283 |
1203502 | 1203502 | 2021-04-09 | LaSalle | Illinois | 17099 | 11485 | 282 |
1200254 | 1200254 | 2021-04-08 | LaSalle | Illinois | 17099 | 11456 | 282 |
1197005 | 1197005 | 2021-04-07 | LaSalle | Illinois | 17099 | 11434 | 282 |
1193757 | 1193757 | 2021-04-06 | LaSalle | Illinois | 17099 | 11407 | 282 |
1190507 | 1190507 | 2021-04-05 | LaSalle | Illinois | 17099 | 11397 | 282 |
1187260 | 1187260 | 2021-04-04 | LaSalle | Illinois | 17099 | 11385 | 282 |
1184013 | 1184013 | 2021-04-03 | LaSalle | Illinois | 17099 | 11364 | 282 |
1180766 | 1180766 | 2021-04-02 | LaSalle | Illinois | 17099 | 11347 | 282 |
1177519 | 1177519 | 2021-04-01 | LaSalle | Illinois | 17099 | 11318 | 282 |
1174272 | 1174272 | 2021-03-31 | LaSalle | Illinois | 17099 | 11283 | 281 |
1171025 | 1171025 | 2021-03-30 | LaSalle | Illinois | 17099 | 11263 | 281 |
1167777 | 1167777 | 2021-03-29 | LaSalle | Illinois | 17099 | 11242 | 281 |
1164529 | 1164529 | 2021-03-28 | LaSalle | Illinois | 17099 | 11232 | 281 |
1161281 | 1161281 | 2021-03-27 | LaSalle | Illinois | 17099 | 11210 | 281 |
1158033 | 1158033 | 2021-03-26 | LaSalle | Illinois | 17099 | 11198 | 280 |
1154786 | 1154786 | 2021-03-25 | LaSalle | Illinois | 17099 | 11178 | 279 |
1151539 | 1151539 | 2021-03-24 | LaSalle | Illinois | 17099 | 11164 | 279 |
1148292 | 1148292 | 2021-03-23 | LaSalle | Illinois | 17099 | 11154 | 279 |
1145045 | 1145045 | 2021-03-22 | LaSalle | Illinois | 17099 | 11140 | 279 |
1141798 | 1141798 | 2021-03-21 | LaSalle | Illinois | 17099 | 11135 | 279 |
1138552 | 1138552 | 2021-03-20 | LaSalle | Illinois | 17099 | 11122 | 279 |
1135306 | 1135306 | 2021-03-19 | LaSalle | Illinois | 17099 | 11110 | 279 |
1132059 | 1132059 | 2021-03-18 | LaSalle | Illinois | 17099 | 11092 | 278 |
1128811 | 1128811 | 2021-03-17 | LaSalle | Illinois | 17099 | 11068 | 278 |
1125565 | 1125565 | 2021-03-16 | LaSalle | Illinois | 17099 | 11044 | 278 |
1122319 | 1122319 | 2021-03-15 | LaSalle | Illinois | 17099 | 11026 | 278 |
1119072 | 1119072 | 2021-03-14 | LaSalle | Illinois | 17099 | 11019 | 278 |
1115825 | 1115825 | 2021-03-13 | LaSalle | Illinois | 17099 | 11010 | 278 |
1112579 | 1112579 | 2021-03-12 | LaSalle | Illinois | 17099 | 11000 | 278 |
1109333 | 1109333 | 2021-03-11 | LaSalle | Illinois | 17099 | 10990 | 278 |
1106087 | 1106087 | 2021-03-10 | LaSalle | Illinois | 17099 | 10967 | 278 |
1102841 | 1102841 | 2021-03-09 | LaSalle | Illinois | 17099 | 10943 | 278 |
1099595 | 1099595 | 2021-03-08 | LaSalle | Illinois | 17099 | 10928 | 277 |
1096347 | 1096347 | 2021-03-07 | LaSalle | Illinois | 17099 | 10924 | 277 |
1093101 | 1093101 | 2021-03-06 | LaSalle | Illinois | 17099 | 10910 | 277 |
1089855 | 1089855 | 2021-03-05 | LaSalle | Illinois | 17099 | 10884 | 277 |
1086610 | 1086610 | 2021-03-04 | LaSalle | Illinois | 17099 | 10861 | 276 |
1083364 | 1083364 | 2021-03-03 | LaSalle | Illinois | 17099 | 10845 | 275 |
1080118 | 1080118 | 2021-03-02 | LaSalle | Illinois | 17099 | 10823 | 274 |
1076873 | 1076873 | 2021-03-01 | LaSalle | Illinois | 17099 | 10810 | 274 |
1073627 | 1073627 | 2021-02-28 | LaSalle | Illinois | 17099 | 10798 | 274 |
1070381 | 1070381 | 2021-02-27 | LaSalle | Illinois | 17099 | 10786 | 274 |
1067136 | 1067136 | 2021-02-26 | LaSalle | Illinois | 17099 | 10764 | 274 |
1063891 | 1063891 | 2021-02-25 | LaSalle | Illinois | 17099 | 10746 | 273 |
1060646 | 1060646 | 2021-02-24 | LaSalle | Illinois | 17099 | 10706 | 273 |
1057400 | 1057400 | 2021-02-23 | LaSalle | Illinois | 17099 | 10681 | 271 |
1054154 | 1054154 | 2021-02-22 | LaSalle | Illinois | 17099 | 10665 | 271 |
1050907 | 1050907 | 2021-02-21 | LaSalle | Illinois | 17099 | 10648 | 270 |
1047660 | 1047660 | 2021-02-20 | LaSalle | Illinois | 17099 | 10601 | 269 |
1044415 | 1044415 | 2021-02-19 | LaSalle | Illinois | 17099 | 10582 | 269 |
1041170 | 1041170 | 2021-02-18 | LaSalle | Illinois | 17099 | 10562 | 269 |
1037925 | 1037925 | 2021-02-17 | LaSalle | Illinois | 17099 | 10535 | 267 |
1034680 | 1034680 | 2021-02-16 | LaSalle | Illinois | 17099 | 10509 | 267 |
1031434 | 1031434 | 2021-02-15 | LaSalle | Illinois | 17099 | 10491 | 267 |
1028187 | 1028187 | 2021-02-14 | LaSalle | Illinois | 17099 | 10478 | 267 |
1024942 | 1024942 | 2021-02-13 | LaSalle | Illinois | 17099 | 10451 | 266 |
1021697 | 1021697 | 2021-02-12 | LaSalle | Illinois | 17099 | 10418 | 265 |
1018452 | 1018452 | 2021-02-11 | LaSalle | Illinois | 17099 | 10390 | 265 |
1015207 | 1015207 | 2021-02-10 | LaSalle | Illinois | 17099 | 10353 | 265 |
1011962 | 1011962 | 2021-02-09 | LaSalle | Illinois | 17099 | 10325 | 263 |
1008716 | 1008716 | 2021-02-08 | LaSalle | Illinois | 17099 | 10310 | 260 |
1005470 | 1005470 | 2021-02-07 | LaSalle | Illinois | 17099 | 10286 | 260 |
1002224 | 1002224 | 2021-02-06 | LaSalle | Illinois | 17099 | 10264 | 258 |
998978 | 998978 | 2021-02-05 | LaSalle | Illinois | 17099 | 10234 | 257 |
995732 | 995732 | 2021-02-04 | LaSalle | Illinois | 17099 | 10191 | 257 |
992486 | 992486 | 2021-02-03 | LaSalle | Illinois | 17099 | 10148 | 257 |
989240 | 989240 | 2021-02-02 | LaSalle | Illinois | 17099 | 10128 | 257 |
985993 | 985993 | 2021-02-01 | LaSalle | Illinois | 17099 | 10104 | 257 |
982746 | 982746 | 2021-01-31 | LaSalle | Illinois | 17099 | 10088 | 255 |
979500 | 979500 | 2021-01-30 | LaSalle | Illinois | 17099 | 10056 | 255 |
976255 | 976255 | 2021-01-29 | LaSalle | Illinois | 17099 | 10016 | 255 |
973010 | 973010 | 2021-01-28 | LaSalle | Illinois | 17099 | 9971 | 252 |
969765 | 969765 | 2021-01-27 | LaSalle | Illinois | 17099 | 9901 | 252 |
966521 | 966521 | 2021-01-26 | LaSalle | Illinois | 17099 | 9834 | 250 |
963276 | 963276 | 2021-01-25 | LaSalle | Illinois | 17099 | 9807 | 250 |
960031 | 960031 | 2021-01-24 | LaSalle | Illinois | 17099 | 9791 | 250 |
956785 | 956785 | 2021-01-23 | LaSalle | Illinois | 17099 | 9757 | 250 |
953540 | 953540 | 2021-01-22 | LaSalle | Illinois | 17099 | 9704 | 249 |
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);