ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where county = "Crawford", deaths = 0, fips = 17033 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
489755 | 489755 | 2020-09-01 | Crawford | Illinois | 17033 | 80 | 0 |
486522 | 486522 | 2020-08-31 | Crawford | Illinois | 17033 | 78 | 0 |
483287 | 483287 | 2020-08-30 | Crawford | Illinois | 17033 | 77 | 0 |
480053 | 480053 | 2020-08-29 | Crawford | Illinois | 17033 | 77 | 0 |
476820 | 476820 | 2020-08-28 | Crawford | Illinois | 17033 | 72 | 0 |
473587 | 473587 | 2020-08-27 | Crawford | Illinois | 17033 | 72 | 0 |
470355 | 470355 | 2020-08-26 | Crawford | Illinois | 17033 | 72 | 0 |
467126 | 467126 | 2020-08-25 | Crawford | Illinois | 17033 | 61 | 0 |
463897 | 463897 | 2020-08-24 | Crawford | Illinois | 17033 | 57 | 0 |
460668 | 460668 | 2020-08-23 | Crawford | Illinois | 17033 | 52 | 0 |
457441 | 457441 | 2020-08-22 | Crawford | Illinois | 17033 | 49 | 0 |
454213 | 454213 | 2020-08-21 | Crawford | Illinois | 17033 | 44 | 0 |
450985 | 450985 | 2020-08-20 | Crawford | Illinois | 17033 | 43 | 0 |
447757 | 447757 | 2020-08-19 | Crawford | Illinois | 17033 | 40 | 0 |
444530 | 444530 | 2020-08-18 | Crawford | Illinois | 17033 | 38 | 0 |
441304 | 441304 | 2020-08-17 | Crawford | Illinois | 17033 | 37 | 0 |
438078 | 438078 | 2020-08-16 | Crawford | Illinois | 17033 | 35 | 0 |
434852 | 434852 | 2020-08-15 | Crawford | Illinois | 17033 | 35 | 0 |
431627 | 431627 | 2020-08-14 | Crawford | Illinois | 17033 | 35 | 0 |
428399 | 428399 | 2020-08-13 | Crawford | Illinois | 17033 | 31 | 0 |
425175 | 425175 | 2020-08-12 | Crawford | Illinois | 17033 | 29 | 0 |
421954 | 421954 | 2020-08-11 | Crawford | Illinois | 17033 | 30 | 0 |
418731 | 418731 | 2020-08-10 | Crawford | Illinois | 17033 | 29 | 0 |
415510 | 415510 | 2020-08-09 | Crawford | Illinois | 17033 | 29 | 0 |
412290 | 412290 | 2020-08-08 | Crawford | Illinois | 17033 | 29 | 0 |
409071 | 409071 | 2020-08-07 | Crawford | Illinois | 17033 | 29 | 0 |
405851 | 405851 | 2020-08-06 | Crawford | Illinois | 17033 | 29 | 0 |
402633 | 402633 | 2020-08-05 | Crawford | Illinois | 17033 | 29 | 0 |
399417 | 399417 | 2020-08-04 | Crawford | Illinois | 17033 | 29 | 0 |
396201 | 396201 | 2020-08-03 | Crawford | Illinois | 17033 | 29 | 0 |
392985 | 392985 | 2020-08-02 | Crawford | Illinois | 17033 | 29 | 0 |
389768 | 389768 | 2020-08-01 | Crawford | Illinois | 17033 | 29 | 0 |
386551 | 386551 | 2020-07-31 | Crawford | Illinois | 17033 | 29 | 0 |
383333 | 383333 | 2020-07-30 | Crawford | Illinois | 17033 | 29 | 0 |
380116 | 380116 | 2020-07-29 | Crawford | Illinois | 17033 | 30 | 0 |
376899 | 376899 | 2020-07-28 | Crawford | Illinois | 17033 | 30 | 0 |
373684 | 373684 | 2020-07-27 | Crawford | Illinois | 17033 | 30 | 0 |
370472 | 370472 | 2020-07-26 | Crawford | Illinois | 17033 | 30 | 0 |
367262 | 367262 | 2020-07-25 | Crawford | Illinois | 17033 | 29 | 0 |
364055 | 364055 | 2020-07-24 | Crawford | Illinois | 17033 | 28 | 0 |
360848 | 360848 | 2020-07-23 | Crawford | Illinois | 17033 | 28 | 0 |
357643 | 357643 | 2020-07-22 | Crawford | Illinois | 17033 | 26 | 0 |
354441 | 354441 | 2020-07-21 | Crawford | Illinois | 17033 | 26 | 0 |
351239 | 351239 | 2020-07-20 | Crawford | Illinois | 17033 | 26 | 0 |
348039 | 348039 | 2020-07-19 | Crawford | Illinois | 17033 | 24 | 0 |
344838 | 344838 | 2020-07-18 | Crawford | Illinois | 17033 | 23 | 0 |
341638 | 341638 | 2020-07-17 | Crawford | Illinois | 17033 | 21 | 0 |
338442 | 338442 | 2020-07-16 | Crawford | Illinois | 17033 | 21 | 0 |
335246 | 335246 | 2020-07-15 | Crawford | Illinois | 17033 | 20 | 0 |
332053 | 332053 | 2020-07-14 | Crawford | Illinois | 17033 | 20 | 0 |
328866 | 328866 | 2020-07-13 | Crawford | Illinois | 17033 | 20 | 0 |
325680 | 325680 | 2020-07-12 | Crawford | Illinois | 17033 | 20 | 0 |
322499 | 322499 | 2020-07-11 | Crawford | Illinois | 17033 | 20 | 0 |
319320 | 319320 | 2020-07-10 | Crawford | Illinois | 17033 | 19 | 0 |
316147 | 316147 | 2020-07-09 | Crawford | Illinois | 17033 | 18 | 0 |
312973 | 312973 | 2020-07-08 | Crawford | Illinois | 17033 | 18 | 0 |
309803 | 309803 | 2020-07-07 | Crawford | Illinois | 17033 | 18 | 0 |
306635 | 306635 | 2020-07-06 | Crawford | Illinois | 17033 | 18 | 0 |
303470 | 303470 | 2020-07-05 | Crawford | Illinois | 17033 | 18 | 0 |
300306 | 300306 | 2020-07-04 | Crawford | Illinois | 17033 | 18 | 0 |
297144 | 297144 | 2020-07-03 | Crawford | Illinois | 17033 | 18 | 0 |
293987 | 293987 | 2020-07-02 | Crawford | Illinois | 17033 | 18 | 0 |
290833 | 290833 | 2020-07-01 | Crawford | Illinois | 17033 | 18 | 0 |
287683 | 287683 | 2020-06-30 | Crawford | Illinois | 17033 | 18 | 0 |
284534 | 284534 | 2020-06-29 | Crawford | Illinois | 17033 | 18 | 0 |
281389 | 281389 | 2020-06-28 | Crawford | Illinois | 17033 | 18 | 0 |
278241 | 278241 | 2020-06-27 | Crawford | Illinois | 17033 | 18 | 0 |
275093 | 275093 | 2020-06-26 | Crawford | Illinois | 17033 | 18 | 0 |
271951 | 271951 | 2020-06-25 | Crawford | Illinois | 17033 | 18 | 0 |
268814 | 268814 | 2020-06-24 | Crawford | Illinois | 17033 | 18 | 0 |
265684 | 265684 | 2020-06-23 | Crawford | Illinois | 17033 | 18 | 0 |
262556 | 262556 | 2020-06-22 | Crawford | Illinois | 17033 | 18 | 0 |
259429 | 259429 | 2020-06-21 | Crawford | Illinois | 17033 | 18 | 0 |
256303 | 256303 | 2020-06-20 | Crawford | Illinois | 17033 | 17 | 0 |
253183 | 253183 | 2020-06-19 | Crawford | Illinois | 17033 | 17 | 0 |
250068 | 250068 | 2020-06-18 | Crawford | Illinois | 17033 | 17 | 0 |
246956 | 246956 | 2020-06-17 | Crawford | Illinois | 17033 | 17 | 0 |
243843 | 243843 | 2020-06-16 | Crawford | Illinois | 17033 | 17 | 0 |
240732 | 240732 | 2020-06-15 | Crawford | Illinois | 17033 | 17 | 0 |
237624 | 237624 | 2020-06-14 | Crawford | Illinois | 17033 | 17 | 0 |
234517 | 234517 | 2020-06-13 | Crawford | Illinois | 17033 | 17 | 0 |
231411 | 231411 | 2020-06-12 | Crawford | Illinois | 17033 | 13 | 0 |
228308 | 228308 | 2020-06-11 | Crawford | Illinois | 17033 | 11 | 0 |
225206 | 225206 | 2020-06-10 | Crawford | Illinois | 17033 | 11 | 0 |
222111 | 222111 | 2020-06-09 | Crawford | Illinois | 17033 | 11 | 0 |
219016 | 219016 | 2020-06-08 | Crawford | Illinois | 17033 | 11 | 0 |
215925 | 215925 | 2020-06-07 | Crawford | Illinois | 17033 | 11 | 0 |
212838 | 212838 | 2020-06-06 | Crawford | Illinois | 17033 | 11 | 0 |
209753 | 209753 | 2020-06-05 | Crawford | Illinois | 17033 | 11 | 0 |
206672 | 206672 | 2020-06-04 | Crawford | Illinois | 17033 | 11 | 0 |
203592 | 203592 | 2020-06-03 | Crawford | Illinois | 17033 | 12 | 0 |
200516 | 200516 | 2020-06-02 | Crawford | Illinois | 17033 | 12 | 0 |
197443 | 197443 | 2020-06-01 | Crawford | Illinois | 17033 | 11 | 0 |
194373 | 194373 | 2020-05-31 | Crawford | Illinois | 17033 | 11 | 0 |
191306 | 191306 | 2020-05-30 | Crawford | Illinois | 17033 | 11 | 0 |
188241 | 188241 | 2020-05-29 | Crawford | Illinois | 17033 | 11 | 0 |
185184 | 185184 | 2020-05-28 | Crawford | Illinois | 17033 | 11 | 0 |
182130 | 182130 | 2020-05-27 | Crawford | Illinois | 17033 | 11 | 0 |
179086 | 179086 | 2020-05-26 | Crawford | Illinois | 17033 | 11 | 0 |
176042 | 176042 | 2020-05-25 | Crawford | Illinois | 17033 | 11 | 0 |
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);