ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where county = "Union" and fips = 17181 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921128 | 921128 | 2021-01-12 | Union | Illinois | 17181 | 1903 | 32 |
917883 | 917883 | 2021-01-11 | Union | Illinois | 17181 | 1889 | 32 |
914638 | 914638 | 2021-01-10 | Union | Illinois | 17181 | 1883 | 32 |
911393 | 911393 | 2021-01-09 | Union | Illinois | 17181 | 1882 | 32 |
908148 | 908148 | 2021-01-08 | Union | Illinois | 17181 | 1860 | 32 |
904902 | 904902 | 2021-01-07 | Union | Illinois | 17181 | 1836 | 32 |
901657 | 901657 | 2021-01-06 | Union | Illinois | 17181 | 1797 | 32 |
898412 | 898412 | 2021-01-05 | Union | Illinois | 17181 | 1774 | 32 |
895167 | 895167 | 2021-01-04 | Union | Illinois | 17181 | 1751 | 31 |
891920 | 891920 | 2021-01-03 | Union | Illinois | 17181 | 1738 | 31 |
888673 | 888673 | 2021-01-02 | Union | Illinois | 17181 | 1717 | 31 |
885428 | 885428 | 2021-01-01 | Union | Illinois | 17181 | 1697 | 31 |
882183 | 882183 | 2020-12-31 | Union | Illinois | 17181 | 1697 | 31 |
878938 | 878938 | 2020-12-30 | Union | Illinois | 17181 | 1663 | 31 |
875693 | 875693 | 2020-12-29 | Union | Illinois | 17181 | 1643 | 31 |
872448 | 872448 | 2020-12-28 | Union | Illinois | 17181 | 1609 | 31 |
869203 | 869203 | 2020-12-27 | Union | Illinois | 17181 | 1598 | 30 |
865958 | 865958 | 2020-12-26 | Union | Illinois | 17181 | 1590 | 30 |
862713 | 862713 | 2020-12-25 | Union | Illinois | 17181 | 1590 | 30 |
859468 | 859468 | 2020-12-24 | Union | Illinois | 17181 | 1583 | 30 |
856223 | 856223 | 2020-12-23 | Union | Illinois | 17181 | 1558 | 30 |
852978 | 852978 | 2020-12-22 | Union | Illinois | 17181 | 1526 | 30 |
849733 | 849733 | 2020-12-21 | Union | Illinois | 17181 | 1514 | 30 |
846488 | 846488 | 2020-12-20 | Union | Illinois | 17181 | 1511 | 30 |
843242 | 843242 | 2020-12-19 | Union | Illinois | 17181 | 1507 | 30 |
839997 | 839997 | 2020-12-18 | Union | Illinois | 17181 | 1490 | 30 |
836752 | 836752 | 2020-12-17 | Union | Illinois | 17181 | 1477 | 29 |
833506 | 833506 | 2020-12-16 | Union | Illinois | 17181 | 1457 | 29 |
830259 | 830259 | 2020-12-15 | Union | Illinois | 17181 | 1430 | 29 |
827013 | 827013 | 2020-12-14 | Union | Illinois | 17181 | 1417 | 29 |
823766 | 823766 | 2020-12-13 | Union | Illinois | 17181 | 1414 | 29 |
820520 | 820520 | 2020-12-12 | Union | Illinois | 17181 | 1401 | 29 |
817274 | 817274 | 2020-12-11 | Union | Illinois | 17181 | 1391 | 29 |
814028 | 814028 | 2020-12-10 | Union | Illinois | 17181 | 1371 | 29 |
810783 | 810783 | 2020-12-09 | Union | Illinois | 17181 | 1353 | 29 |
807538 | 807538 | 2020-12-08 | Union | Illinois | 17181 | 1341 | 29 |
804293 | 804293 | 2020-12-07 | Union | Illinois | 17181 | 1320 | 29 |
801048 | 801048 | 2020-12-06 | Union | Illinois | 17181 | 1296 | 29 |
797803 | 797803 | 2020-12-05 | Union | Illinois | 17181 | 1289 | 29 |
794558 | 794558 | 2020-12-04 | Union | Illinois | 17181 | 1274 | 28 |
791313 | 791313 | 2020-12-03 | Union | Illinois | 17181 | 1256 | 28 |
788068 | 788068 | 2020-12-02 | Union | Illinois | 17181 | 1240 | 28 |
784824 | 784824 | 2020-12-01 | Union | Illinois | 17181 | 1209 | 28 |
781579 | 781579 | 2020-11-30 | Union | Illinois | 17181 | 1195 | 28 |
778333 | 778333 | 2020-11-29 | Union | Illinois | 17181 | 1182 | 28 |
775088 | 775088 | 2020-11-28 | Union | Illinois | 17181 | 1179 | 28 |
771843 | 771843 | 2020-11-27 | Union | Illinois | 17181 | 1164 | 28 |
768598 | 768598 | 2020-11-26 | Union | Illinois | 17181 | 1161 | 28 |
765352 | 765352 | 2020-11-25 | Union | Illinois | 17181 | 1128 | 26 |
762107 | 762107 | 2020-11-24 | Union | Illinois | 17181 | 1120 | 26 |
758862 | 758862 | 2020-11-23 | Union | Illinois | 17181 | 1112 | 26 |
755615 | 755615 | 2020-11-22 | Union | Illinois | 17181 | 1109 | 26 |
752369 | 752369 | 2020-11-21 | Union | Illinois | 17181 | 1094 | 26 |
749123 | 749123 | 2020-11-20 | Union | Illinois | 17181 | 1069 | 26 |
745877 | 745877 | 2020-11-19 | Union | Illinois | 17181 | 1040 | 26 |
742630 | 742630 | 2020-11-18 | Union | Illinois | 17181 | 1006 | 26 |
739383 | 739383 | 2020-11-17 | Union | Illinois | 17181 | 988 | 26 |
736139 | 736139 | 2020-11-16 | Union | Illinois | 17181 | 980 | 26 |
732893 | 732893 | 2020-11-15 | Union | Illinois | 17181 | 964 | 26 |
729648 | 729648 | 2020-11-14 | Union | Illinois | 17181 | 948 | 26 |
726405 | 726405 | 2020-11-13 | Union | Illinois | 17181 | 933 | 26 |
723162 | 723162 | 2020-11-12 | Union | Illinois | 17181 | 923 | 26 |
719919 | 719919 | 2020-11-11 | Union | Illinois | 17181 | 910 | 26 |
716676 | 716676 | 2020-11-10 | Union | Illinois | 17181 | 891 | 26 |
713432 | 713432 | 2020-11-09 | Union | Illinois | 17181 | 880 | 26 |
710188 | 710188 | 2020-11-08 | Union | Illinois | 17181 | 878 | 26 |
706944 | 706944 | 2020-11-07 | Union | Illinois | 17181 | 872 | 26 |
703701 | 703701 | 2020-11-06 | Union | Illinois | 17181 | 858 | 26 |
700458 | 700458 | 2020-11-05 | Union | Illinois | 17181 | 847 | 25 |
697214 | 697214 | 2020-11-04 | Union | Illinois | 17181 | 837 | 25 |
693972 | 693972 | 2020-11-03 | Union | Illinois | 17181 | 835 | 25 |
690729 | 690729 | 2020-11-02 | Union | Illinois | 17181 | 827 | 25 |
687484 | 687484 | 2020-11-01 | Union | Illinois | 17181 | 821 | 25 |
684240 | 684240 | 2020-10-31 | Union | Illinois | 17181 | 810 | 25 |
680997 | 680997 | 2020-10-30 | Union | Illinois | 17181 | 810 | 25 |
677754 | 677754 | 2020-10-29 | Union | Illinois | 17181 | 802 | 25 |
674511 | 674511 | 2020-10-28 | Union | Illinois | 17181 | 799 | 25 |
671269 | 671269 | 2020-10-27 | Union | Illinois | 17181 | 792 | 25 |
668026 | 668026 | 2020-10-26 | Union | Illinois | 17181 | 787 | 25 |
664782 | 664782 | 2020-10-25 | Union | Illinois | 17181 | 780 | 25 |
661537 | 661537 | 2020-10-24 | Union | Illinois | 17181 | 784 | 25 |
658293 | 658293 | 2020-10-23 | Union | Illinois | 17181 | 751 | 25 |
655048 | 655048 | 2020-10-22 | Union | Illinois | 17181 | 746 | 25 |
651803 | 651803 | 2020-10-21 | Union | Illinois | 17181 | 746 | 25 |
648559 | 648559 | 2020-10-20 | Union | Illinois | 17181 | 738 | 25 |
645314 | 645314 | 2020-10-19 | Union | Illinois | 17181 | 730 | 25 |
642067 | 642067 | 2020-10-18 | Union | Illinois | 17181 | 725 | 25 |
638820 | 638820 | 2020-10-17 | Union | Illinois | 17181 | 719 | 25 |
635574 | 635574 | 2020-10-16 | Union | Illinois | 17181 | 713 | 25 |
632328 | 632328 | 2020-10-15 | Union | Illinois | 17181 | 695 | 25 |
629084 | 629084 | 2020-10-14 | Union | Illinois | 17181 | 683 | 25 |
625841 | 625841 | 2020-10-13 | Union | Illinois | 17181 | 668 | 25 |
622599 | 622599 | 2020-10-12 | Union | Illinois | 17181 | 659 | 25 |
619355 | 619355 | 2020-10-11 | Union | Illinois | 17181 | 657 | 25 |
616113 | 616113 | 2020-10-10 | Union | Illinois | 17181 | 642 | 25 |
612872 | 612872 | 2020-10-09 | Union | Illinois | 17181 | 618 | 24 |
609630 | 609630 | 2020-10-08 | Union | Illinois | 17181 | 607 | 24 |
606387 | 606387 | 2020-10-07 | Union | Illinois | 17181 | 597 | 24 |
603145 | 603145 | 2020-10-06 | Union | Illinois | 17181 | 585 | 24 |
599902 | 599902 | 2020-10-05 | Union | Illinois | 17181 | 554 | 24 |
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);