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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921054 | 921054 | 2021-01-12 | Crawford | Illinois | 17033 | 1705 | 32 |
917809 | 917809 | 2021-01-11 | Crawford | Illinois | 17033 | 1698 | 32 |
914564 | 914564 | 2021-01-10 | Crawford | Illinois | 17033 | 1685 | 32 |
911319 | 911319 | 2021-01-09 | Crawford | Illinois | 17033 | 1682 | 32 |
908074 | 908074 | 2021-01-08 | Crawford | Illinois | 17033 | 1671 | 32 |
904828 | 904828 | 2021-01-07 | Crawford | Illinois | 17033 | 1660 | 32 |
901583 | 901583 | 2021-01-06 | Crawford | Illinois | 17033 | 1643 | 30 |
898338 | 898338 | 2021-01-05 | Crawford | Illinois | 17033 | 1625 | 30 |
895093 | 895093 | 2021-01-04 | Crawford | Illinois | 17033 | 1594 | 30 |
891846 | 891846 | 2021-01-03 | Crawford | Illinois | 17033 | 1592 | 31 |
888599 | 888599 | 2021-01-02 | Crawford | Illinois | 17033 | 1588 | 31 |
885354 | 885354 | 2021-01-01 | Crawford | Illinois | 17033 | 1578 | 31 |
882109 | 882109 | 2020-12-31 | Crawford | Illinois | 17033 | 1578 | 31 |
878864 | 878864 | 2020-12-30 | Crawford | Illinois | 17033 | 1562 | 29 |
875619 | 875619 | 2020-12-29 | Crawford | Illinois | 17033 | 1551 | 29 |
872374 | 872374 | 2020-12-28 | Crawford | Illinois | 17033 | 1536 | 29 |
869129 | 869129 | 2020-12-27 | Crawford | Illinois | 17033 | 1537 | 29 |
865884 | 865884 | 2020-12-26 | Crawford | Illinois | 17033 | 1527 | 29 |
862639 | 862639 | 2020-12-25 | Crawford | Illinois | 17033 | 1526 | 29 |
859394 | 859394 | 2020-12-24 | Crawford | Illinois | 17033 | 1518 | 29 |
856149 | 856149 | 2020-12-23 | Crawford | Illinois | 17033 | 1500 | 28 |
852904 | 852904 | 2020-12-22 | Crawford | Illinois | 17033 | 1482 | 28 |
849659 | 849659 | 2020-12-21 | Crawford | Illinois | 17033 | 1463 | 27 |
846414 | 846414 | 2020-12-20 | Crawford | Illinois | 17033 | 1461 | 26 |
843168 | 843168 | 2020-12-19 | Crawford | Illinois | 17033 | 1450 | 26 |
839923 | 839923 | 2020-12-18 | Crawford | Illinois | 17033 | 1433 | 25 |
836678 | 836678 | 2020-12-17 | Crawford | Illinois | 17033 | 1424 | 25 |
833432 | 833432 | 2020-12-16 | Crawford | Illinois | 17033 | 1404 | 21 |
830185 | 830185 | 2020-12-15 | Crawford | Illinois | 17033 | 1387 | 21 |
826939 | 826939 | 2020-12-14 | Crawford | Illinois | 17033 | 1356 | 21 |
823692 | 823692 | 2020-12-13 | Crawford | Illinois | 17033 | 1352 | 21 |
820446 | 820446 | 2020-12-12 | Crawford | Illinois | 17033 | 1344 | 20 |
817200 | 817200 | 2020-12-11 | Crawford | Illinois | 17033 | 1326 | 18 |
813954 | 813954 | 2020-12-10 | Crawford | Illinois | 17033 | 1304 | 17 |
810709 | 810709 | 2020-12-09 | Crawford | Illinois | 17033 | 1276 | 17 |
807464 | 807464 | 2020-12-08 | Crawford | Illinois | 17033 | 1244 | 16 |
804219 | 804219 | 2020-12-07 | Crawford | Illinois | 17033 | 1235 | 16 |
800974 | 800974 | 2020-12-06 | Crawford | Illinois | 17033 | 1227 | 16 |
797729 | 797729 | 2020-12-05 | Crawford | Illinois | 17033 | 1223 | 16 |
794484 | 794484 | 2020-12-04 | Crawford | Illinois | 17033 | 1199 | 16 |
791239 | 791239 | 2020-12-03 | Crawford | Illinois | 17033 | 1180 | 14 |
787994 | 787994 | 2020-12-02 | Crawford | Illinois | 17033 | 1160 | 13 |
784750 | 784750 | 2020-12-01 | Crawford | Illinois | 17033 | 1150 | 13 |
781505 | 781505 | 2020-11-30 | Crawford | Illinois | 17033 | 1122 | 13 |
778259 | 778259 | 2020-11-29 | Crawford | Illinois | 17033 | 1122 | 13 |
775014 | 775014 | 2020-11-28 | Crawford | Illinois | 17033 | 1117 | 13 |
771769 | 771769 | 2020-11-27 | Crawford | Illinois | 17033 | 1098 | 13 |
768524 | 768524 | 2020-11-26 | Crawford | Illinois | 17033 | 1093 | 13 |
765278 | 765278 | 2020-11-25 | Crawford | Illinois | 17033 | 1077 | 10 |
762033 | 762033 | 2020-11-24 | Crawford | Illinois | 17033 | 1050 | 9 |
758788 | 758788 | 2020-11-23 | Crawford | Illinois | 17033 | 1015 | 9 |
755541 | 755541 | 2020-11-22 | Crawford | Illinois | 17033 | 1004 | 9 |
752295 | 752295 | 2020-11-21 | Crawford | Illinois | 17033 | 1001 | 9 |
749049 | 749049 | 2020-11-20 | Crawford | Illinois | 17033 | 993 | 9 |
745803 | 745803 | 2020-11-19 | Crawford | Illinois | 17033 | 948 | 9 |
742556 | 742556 | 2020-11-18 | Crawford | Illinois | 17033 | 934 | 9 |
739309 | 739309 | 2020-11-17 | Crawford | Illinois | 17033 | 897 | 9 |
736065 | 736065 | 2020-11-16 | Crawford | Illinois | 17033 | 859 | 8 |
732819 | 732819 | 2020-11-15 | Crawford | Illinois | 17033 | 841 | 8 |
729574 | 729574 | 2020-11-14 | Crawford | Illinois | 17033 | 835 | 8 |
726331 | 726331 | 2020-11-13 | Crawford | Illinois | 17033 | 812 | 8 |
723088 | 723088 | 2020-11-12 | Crawford | Illinois | 17033 | 792 | 8 |
719845 | 719845 | 2020-11-11 | Crawford | Illinois | 17033 | 788 | 8 |
716602 | 716602 | 2020-11-10 | Crawford | Illinois | 17033 | 776 | 6 |
713358 | 713358 | 2020-11-09 | Crawford | Illinois | 17033 | 748 | 6 |
710114 | 710114 | 2020-11-08 | Crawford | Illinois | 17033 | 744 | 6 |
706870 | 706870 | 2020-11-07 | Crawford | Illinois | 17033 | 739 | 6 |
703627 | 703627 | 2020-11-06 | Crawford | Illinois | 17033 | 730 | 6 |
700384 | 700384 | 2020-11-05 | Crawford | Illinois | 17033 | 700 | 6 |
697140 | 697140 | 2020-11-04 | Crawford | Illinois | 17033 | 690 | 6 |
693898 | 693898 | 2020-11-03 | Crawford | Illinois | 17033 | 689 | 6 |
690655 | 690655 | 2020-11-02 | Crawford | Illinois | 17033 | 686 | 6 |
687410 | 687410 | 2020-11-01 | Crawford | Illinois | 17033 | 684 | 6 |
684166 | 684166 | 2020-10-31 | Crawford | Illinois | 17033 | 676 | 6 |
680923 | 680923 | 2020-10-30 | Crawford | Illinois | 17033 | 676 | 6 |
677680 | 677680 | 2020-10-29 | Crawford | Illinois | 17033 | 668 | 6 |
674437 | 674437 | 2020-10-28 | Crawford | Illinois | 17033 | 663 | 6 |
671195 | 671195 | 2020-10-27 | Crawford | Illinois | 17033 | 653 | 6 |
667952 | 667952 | 2020-10-26 | Crawford | Illinois | 17033 | 651 | 6 |
664708 | 664708 | 2020-10-25 | Crawford | Illinois | 17033 | 647 | 6 |
661463 | 661463 | 2020-10-24 | Crawford | Illinois | 17033 | 644 | 6 |
658219 | 658219 | 2020-10-23 | Crawford | Illinois | 17033 | 645 | 6 |
654974 | 654974 | 2020-10-22 | Crawford | Illinois | 17033 | 639 | 6 |
651729 | 651729 | 2020-10-21 | Crawford | Illinois | 17033 | 636 | 6 |
648485 | 648485 | 2020-10-20 | Crawford | Illinois | 17033 | 630 | 6 |
645240 | 645240 | 2020-10-19 | Crawford | Illinois | 17033 | 624 | 6 |
641993 | 641993 | 2020-10-18 | Crawford | Illinois | 17033 | 615 | 6 |
638746 | 638746 | 2020-10-17 | Crawford | Illinois | 17033 | 609 | 6 |
635500 | 635500 | 2020-10-16 | Crawford | Illinois | 17033 | 608 | 6 |
632254 | 632254 | 2020-10-15 | Crawford | Illinois | 17033 | 604 | 6 |
629010 | 629010 | 2020-10-14 | Crawford | Illinois | 17033 | 589 | 6 |
625767 | 625767 | 2020-10-13 | Crawford | Illinois | 17033 | 576 | 6 |
622525 | 622525 | 2020-10-12 | Crawford | Illinois | 17033 | 572 | 6 |
619281 | 619281 | 2020-10-11 | Crawford | Illinois | 17033 | 561 | 6 |
616039 | 616039 | 2020-10-10 | Crawford | Illinois | 17033 | 544 | 6 |
612798 | 612798 | 2020-10-09 | Crawford | Illinois | 17033 | 539 | 6 |
609556 | 609556 | 2020-10-08 | Crawford | Illinois | 17033 | 525 | 6 |
606313 | 606313 | 2020-10-07 | Crawford | Illinois | 17033 | 505 | 6 |
603071 | 603071 | 2020-10-06 | Crawford | Illinois | 17033 | 497 | 6 |
599828 | 599828 | 2020-10-05 | Crawford | Illinois | 17033 | 491 | 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);