ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Crawford" and state = "Illinois" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
312973 | 312973 | 2020-07-08 | Crawford | Illinois | 17033 | 18 | 0 |
316147 | 316147 | 2020-07-09 | Crawford | Illinois | 17033 | 18 | 0 |
319320 | 319320 | 2020-07-10 | Crawford | Illinois | 17033 | 19 | 0 |
322499 | 322499 | 2020-07-11 | Crawford | Illinois | 17033 | 20 | 0 |
325680 | 325680 | 2020-07-12 | Crawford | Illinois | 17033 | 20 | 0 |
328866 | 328866 | 2020-07-13 | Crawford | Illinois | 17033 | 20 | 0 |
332053 | 332053 | 2020-07-14 | Crawford | Illinois | 17033 | 20 | 0 |
335246 | 335246 | 2020-07-15 | Crawford | Illinois | 17033 | 20 | 0 |
338442 | 338442 | 2020-07-16 | Crawford | Illinois | 17033 | 21 | 0 |
341638 | 341638 | 2020-07-17 | Crawford | Illinois | 17033 | 21 | 0 |
344838 | 344838 | 2020-07-18 | Crawford | Illinois | 17033 | 23 | 0 |
348039 | 348039 | 2020-07-19 | Crawford | Illinois | 17033 | 24 | 0 |
351239 | 351239 | 2020-07-20 | Crawford | Illinois | 17033 | 26 | 0 |
354441 | 354441 | 2020-07-21 | Crawford | Illinois | 17033 | 26 | 0 |
357643 | 357643 | 2020-07-22 | Crawford | Illinois | 17033 | 26 | 0 |
360848 | 360848 | 2020-07-23 | Crawford | Illinois | 17033 | 28 | 0 |
364055 | 364055 | 2020-07-24 | Crawford | Illinois | 17033 | 28 | 0 |
367262 | 367262 | 2020-07-25 | Crawford | Illinois | 17033 | 29 | 0 |
370472 | 370472 | 2020-07-26 | Crawford | Illinois | 17033 | 30 | 0 |
373684 | 373684 | 2020-07-27 | Crawford | Illinois | 17033 | 30 | 0 |
376899 | 376899 | 2020-07-28 | Crawford | Illinois | 17033 | 30 | 0 |
380116 | 380116 | 2020-07-29 | Crawford | Illinois | 17033 | 30 | 0 |
383333 | 383333 | 2020-07-30 | Crawford | Illinois | 17033 | 29 | 0 |
386551 | 386551 | 2020-07-31 | Crawford | Illinois | 17033 | 29 | 0 |
389768 | 389768 | 2020-08-01 | Crawford | Illinois | 17033 | 29 | 0 |
392985 | 392985 | 2020-08-02 | Crawford | Illinois | 17033 | 29 | 0 |
396201 | 396201 | 2020-08-03 | Crawford | Illinois | 17033 | 29 | 0 |
399417 | 399417 | 2020-08-04 | Crawford | Illinois | 17033 | 29 | 0 |
402633 | 402633 | 2020-08-05 | Crawford | Illinois | 17033 | 29 | 0 |
405851 | 405851 | 2020-08-06 | Crawford | Illinois | 17033 | 29 | 0 |
409071 | 409071 | 2020-08-07 | Crawford | Illinois | 17033 | 29 | 0 |
412290 | 412290 | 2020-08-08 | Crawford | Illinois | 17033 | 29 | 0 |
415510 | 415510 | 2020-08-09 | Crawford | Illinois | 17033 | 29 | 0 |
418731 | 418731 | 2020-08-10 | Crawford | Illinois | 17033 | 29 | 0 |
421954 | 421954 | 2020-08-11 | Crawford | Illinois | 17033 | 30 | 0 |
425175 | 425175 | 2020-08-12 | Crawford | Illinois | 17033 | 29 | 0 |
428399 | 428399 | 2020-08-13 | Crawford | Illinois | 17033 | 31 | 0 |
431627 | 431627 | 2020-08-14 | Crawford | Illinois | 17033 | 35 | 0 |
434852 | 434852 | 2020-08-15 | Crawford | Illinois | 17033 | 35 | 0 |
438078 | 438078 | 2020-08-16 | Crawford | Illinois | 17033 | 35 | 0 |
441304 | 441304 | 2020-08-17 | Crawford | Illinois | 17033 | 37 | 0 |
444530 | 444530 | 2020-08-18 | Crawford | Illinois | 17033 | 38 | 0 |
447757 | 447757 | 2020-08-19 | Crawford | Illinois | 17033 | 40 | 0 |
450985 | 450985 | 2020-08-20 | Crawford | Illinois | 17033 | 43 | 0 |
454213 | 454213 | 2020-08-21 | Crawford | Illinois | 17033 | 44 | 0 |
457441 | 457441 | 2020-08-22 | Crawford | Illinois | 17033 | 49 | 0 |
460668 | 460668 | 2020-08-23 | Crawford | Illinois | 17033 | 52 | 0 |
463897 | 463897 | 2020-08-24 | Crawford | Illinois | 17033 | 57 | 0 |
467126 | 467126 | 2020-08-25 | Crawford | Illinois | 17033 | 61 | 0 |
470355 | 470355 | 2020-08-26 | Crawford | Illinois | 17033 | 72 | 0 |
473587 | 473587 | 2020-08-27 | Crawford | Illinois | 17033 | 72 | 0 |
476820 | 476820 | 2020-08-28 | Crawford | Illinois | 17033 | 72 | 0 |
480053 | 480053 | 2020-08-29 | Crawford | Illinois | 17033 | 77 | 0 |
483287 | 483287 | 2020-08-30 | Crawford | Illinois | 17033 | 77 | 0 |
486522 | 486522 | 2020-08-31 | Crawford | Illinois | 17033 | 78 | 0 |
489755 | 489755 | 2020-09-01 | Crawford | Illinois | 17033 | 80 | 0 |
492988 | 492988 | 2020-09-02 | Crawford | Illinois | 17033 | 81 | 1 |
496222 | 496222 | 2020-09-03 | Crawford | Illinois | 17033 | 84 | 1 |
499455 | 499455 | 2020-09-04 | Crawford | Illinois | 17033 | 111 | 1 |
502689 | 502689 | 2020-09-05 | Crawford | Illinois | 17033 | 149 | 1 |
505923 | 505923 | 2020-09-06 | Crawford | Illinois | 17033 | 164 | 1 |
509155 | 509155 | 2020-09-07 | Crawford | Illinois | 17033 | 167 | 1 |
512388 | 512388 | 2020-09-08 | Crawford | Illinois | 17033 | 177 | 1 |
515621 | 515621 | 2020-09-09 | Crawford | Illinois | 17033 | 181 | 1 |
518856 | 518856 | 2020-09-10 | Crawford | Illinois | 17033 | 204 | 1 |
522093 | 522093 | 2020-09-11 | Crawford | Illinois | 17033 | 216 | 1 |
525329 | 525329 | 2020-09-12 | Crawford | Illinois | 17033 | 239 | 1 |
528565 | 528565 | 2020-09-13 | Crawford | Illinois | 17033 | 255 | 1 |
531802 | 531802 | 2020-09-14 | Crawford | Illinois | 17033 | 261 | 1 |
535037 | 535037 | 2020-09-15 | Crawford | Illinois | 17033 | 272 | 1 |
538273 | 538273 | 2020-09-16 | Crawford | Illinois | 17033 | 282 | 1 |
541510 | 541510 | 2020-09-17 | Crawford | Illinois | 17033 | 305 | 1 |
544746 | 544746 | 2020-09-18 | Crawford | Illinois | 17033 | 330 | 1 |
547984 | 547984 | 2020-09-19 | Crawford | Illinois | 17033 | 348 | 1 |
551223 | 551223 | 2020-09-20 | Crawford | Illinois | 17033 | 352 | 1 |
554462 | 554462 | 2020-09-21 | Crawford | Illinois | 17033 | 389 | 1 |
557699 | 557699 | 2020-09-22 | Crawford | Illinois | 17033 | 389 | 2 |
560935 | 560935 | 2020-09-23 | Crawford | Illinois | 17033 | 400 | 2 |
564175 | 564175 | 2020-09-24 | Crawford | Illinois | 17033 | 420 | 3 |
567415 | 567415 | 2020-09-25 | Crawford | Illinois | 17033 | 429 | 3 |
570657 | 570657 | 2020-09-26 | Crawford | Illinois | 17033 | 440 | 3 |
573900 | 573900 | 2020-09-27 | Crawford | Illinois | 17033 | 450 | 3 |
577142 | 577142 | 2020-09-28 | Crawford | Illinois | 17033 | 458 | 4 |
580383 | 580383 | 2020-09-29 | Crawford | Illinois | 17033 | 459 | 4 |
583622 | 583622 | 2020-09-30 | Crawford | Illinois | 17033 | 466 | 4 |
586862 | 586862 | 2020-10-01 | Crawford | Illinois | 17033 | 472 | 5 |
590103 | 590103 | 2020-10-02 | Crawford | Illinois | 17033 | 473 | 5 |
593344 | 593344 | 2020-10-03 | Crawford | Illinois | 17033 | 478 | 6 |
596586 | 596586 | 2020-10-04 | Crawford | Illinois | 17033 | 481 | 6 |
599828 | 599828 | 2020-10-05 | Crawford | Illinois | 17033 | 491 | 6 |
603071 | 603071 | 2020-10-06 | Crawford | Illinois | 17033 | 497 | 6 |
606313 | 606313 | 2020-10-07 | Crawford | Illinois | 17033 | 505 | 6 |
609556 | 609556 | 2020-10-08 | Crawford | Illinois | 17033 | 525 | 6 |
612798 | 612798 | 2020-10-09 | Crawford | Illinois | 17033 | 539 | 6 |
616039 | 616039 | 2020-10-10 | Crawford | Illinois | 17033 | 544 | 6 |
619281 | 619281 | 2020-10-11 | Crawford | Illinois | 17033 | 561 | 6 |
622525 | 622525 | 2020-10-12 | Crawford | Illinois | 17033 | 572 | 6 |
625767 | 625767 | 2020-10-13 | Crawford | Illinois | 17033 | 576 | 6 |
629010 | 629010 | 2020-10-14 | Crawford | Illinois | 17033 | 589 | 6 |
632254 | 632254 | 2020-10-15 | Crawford | Illinois | 17033 | 604 | 6 |
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);