ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Kane" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193753 | 1193753 | 2021-04-06 | Kane | Illinois | 17089 | 53632 | 797 |
1190503 | 1190503 | 2021-04-05 | Kane | Illinois | 17089 | 53467 | 797 |
1187256 | 1187256 | 2021-04-04 | Kane | Illinois | 17089 | 53361 | 797 |
1184009 | 1184009 | 2021-04-03 | Kane | Illinois | 17089 | 53279 | 797 |
1180762 | 1180762 | 2021-04-02 | Kane | Illinois | 17089 | 53172 | 797 |
1177515 | 1177515 | 2021-04-01 | Kane | Illinois | 17089 | 53004 | 797 |
1174268 | 1174268 | 2021-03-31 | Kane | Illinois | 17089 | 52886 | 797 |
1171021 | 1171021 | 2021-03-30 | Kane | Illinois | 17089 | 52787 | 797 |
1167773 | 1167773 | 2021-03-29 | Kane | Illinois | 17089 | 52683 | 797 |
1164525 | 1164525 | 2021-03-28 | Kane | Illinois | 17089 | 52603 | 797 |
1161277 | 1161277 | 2021-03-27 | Kane | Illinois | 17089 | 52522 | 794 |
1158029 | 1158029 | 2021-03-26 | Kane | Illinois | 17089 | 52456 | 793 |
1154782 | 1154782 | 2021-03-25 | Kane | Illinois | 17089 | 52339 | 792 |
1151535 | 1151535 | 2021-03-24 | Kane | Illinois | 17089 | 52233 | 791 |
1148288 | 1148288 | 2021-03-23 | Kane | Illinois | 17089 | 52123 | 789 |
1145041 | 1145041 | 2021-03-22 | Kane | Illinois | 17089 | 52067 | 789 |
1141794 | 1141794 | 2021-03-21 | Kane | Illinois | 17089 | 52030 | 789 |
1138548 | 1138548 | 2021-03-20 | Kane | Illinois | 17089 | 51996 | 789 |
1135302 | 1135302 | 2021-03-19 | Kane | Illinois | 17089 | 51946 | 789 |
1132055 | 1132055 | 2021-03-18 | Kane | Illinois | 17089 | 51874 | 789 |
1128807 | 1128807 | 2021-03-17 | Kane | Illinois | 17089 | 51795 | 785 |
1125561 | 1125561 | 2021-03-16 | Kane | Illinois | 17089 | 51733 | 784 |
1122315 | 1122315 | 2021-03-15 | Kane | Illinois | 17089 | 51672 | 784 |
1119068 | 1119068 | 2021-03-14 | Kane | Illinois | 17089 | 51655 | 783 |
1115821 | 1115821 | 2021-03-13 | Kane | Illinois | 17089 | 51613 | 782 |
1112575 | 1112575 | 2021-03-12 | Kane | Illinois | 17089 | 51547 | 782 |
1109329 | 1109329 | 2021-03-11 | Kane | Illinois | 17089 | 51479 | 779 |
1106083 | 1106083 | 2021-03-10 | Kane | Illinois | 17089 | 51415 | 778 |
1102837 | 1102837 | 2021-03-09 | Kane | Illinois | 17089 | 51353 | 776 |
1099591 | 1099591 | 2021-03-08 | Kane | Illinois | 17089 | 51287 | 775 |
1096343 | 1096343 | 2021-03-07 | Kane | Illinois | 17089 | 51237 | 775 |
1093097 | 1093097 | 2021-03-06 | Kane | Illinois | 17089 | 51199 | 775 |
1089851 | 1089851 | 2021-03-05 | Kane | Illinois | 17089 | 51118 | 775 |
1086606 | 1086606 | 2021-03-04 | Kane | Illinois | 17089 | 51052 | 775 |
1083360 | 1083360 | 2021-03-03 | Kane | Illinois | 17089 | 50994 | 773 |
1080114 | 1080114 | 2021-03-02 | Kane | Illinois | 17089 | 50879 | 771 |
1076869 | 1076869 | 2021-03-01 | Kane | Illinois | 17089 | 50800 | 769 |
1073623 | 1073623 | 2021-02-28 | Kane | Illinois | 17089 | 50746 | 769 |
1070377 | 1070377 | 2021-02-27 | Kane | Illinois | 17089 | 50666 | 768 |
1067132 | 1067132 | 2021-02-26 | Kane | Illinois | 17089 | 50595 | 766 |
1063887 | 1063887 | 2021-02-25 | Kane | Illinois | 17089 | 50439 | 763 |
1060642 | 1060642 | 2021-02-24 | Kane | Illinois | 17089 | 50335 | 761 |
1057396 | 1057396 | 2021-02-23 | Kane | Illinois | 17089 | 50242 | 760 |
1054150 | 1054150 | 2021-02-22 | Kane | Illinois | 17089 | 50182 | 759 |
1050903 | 1050903 | 2021-02-21 | Kane | Illinois | 17089 | 50134 | 758 |
1047656 | 1047656 | 2021-02-20 | Kane | Illinois | 17089 | 50069 | 758 |
1044411 | 1044411 | 2021-02-19 | Kane | Illinois | 17089 | 49986 | 755 |
1041166 | 1041166 | 2021-02-18 | Kane | Illinois | 17089 | 49900 | 753 |
1037921 | 1037921 | 2021-02-17 | Kane | Illinois | 17089 | 49822 | 752 |
1034676 | 1034676 | 2021-02-16 | Kane | Illinois | 17089 | 49726 | 752 |
1031430 | 1031430 | 2021-02-15 | Kane | Illinois | 17089 | 49669 | 752 |
1028183 | 1028183 | 2021-02-14 | Kane | Illinois | 17089 | 49606 | 751 |
1024938 | 1024938 | 2021-02-13 | Kane | Illinois | 17089 | 49533 | 751 |
1021693 | 1021693 | 2021-02-12 | Kane | Illinois | 17089 | 49470 | 751 |
1018448 | 1018448 | 2021-02-11 | Kane | Illinois | 17089 | 49376 | 751 |
1015203 | 1015203 | 2021-02-10 | Kane | Illinois | 17089 | 49264 | 748 |
1011958 | 1011958 | 2021-02-09 | Kane | Illinois | 17089 | 49170 | 746 |
1008712 | 1008712 | 2021-02-08 | Kane | Illinois | 17089 | 49098 | 746 |
1005466 | 1005466 | 2021-02-07 | Kane | Illinois | 17089 | 49017 | 744 |
1002220 | 1002220 | 2021-02-06 | Kane | Illinois | 17089 | 48937 | 742 |
998974 | 998974 | 2021-02-05 | Kane | Illinois | 17089 | 48821 | 738 |
995728 | 995728 | 2021-02-04 | Kane | Illinois | 17089 | 48682 | 732 |
992482 | 992482 | 2021-02-03 | Kane | Illinois | 17089 | 48542 | 732 |
989236 | 989236 | 2021-02-02 | Kane | Illinois | 17089 | 48425 | 730 |
985989 | 985989 | 2021-02-01 | Kane | Illinois | 17089 | 48339 | 730 |
982742 | 982742 | 2021-01-31 | Kane | Illinois | 17089 | 48243 | 729 |
979496 | 979496 | 2021-01-30 | Kane | Illinois | 17089 | 48145 | 729 |
976251 | 976251 | 2021-01-29 | Kane | Illinois | 17089 | 47991 | 729 |
973006 | 973006 | 2021-01-28 | Kane | Illinois | 17089 | 47840 | 720 |
969761 | 969761 | 2021-01-27 | Kane | Illinois | 17089 | 47657 | 716 |
966517 | 966517 | 2021-01-26 | Kane | Illinois | 17089 | 47475 | 713 |
963272 | 963272 | 2021-01-25 | Kane | Illinois | 17089 | 47289 | 710 |
960027 | 960027 | 2021-01-24 | Kane | Illinois | 17089 | 47171 | 705 |
956781 | 956781 | 2021-01-23 | Kane | Illinois | 17089 | 47054 | 705 |
953536 | 953536 | 2021-01-22 | Kane | Illinois | 17089 | 46750 | 699 |
950291 | 950291 | 2021-01-21 | Kane | Illinois | 17089 | 46512 | 696 |
947045 | 947045 | 2021-01-20 | Kane | Illinois | 17089 | 46288 | 685 |
943798 | 943798 | 2021-01-19 | Kane | Illinois | 17089 | 46063 | 677 |
940553 | 940553 | 2021-01-18 | Kane | Illinois | 17089 | 45873 | 676 |
937308 | 937308 | 2021-01-17 | Kane | Illinois | 17089 | 45704 | 675 |
934063 | 934063 | 2021-01-16 | Kane | Illinois | 17089 | 45493 | 675 |
930818 | 930818 | 2021-01-15 | Kane | Illinois | 17089 | 45300 | 667 |
927573 | 927573 | 2021-01-14 | Kane | Illinois | 17089 | 45073 | 662 |
924327 | 924327 | 2021-01-13 | Kane | Illinois | 17089 | 44812 | 660 |
921082 | 921082 | 2021-01-12 | Kane | Illinois | 17089 | 44579 | 659 |
917837 | 917837 | 2021-01-11 | Kane | Illinois | 17089 | 44266 | 653 |
914592 | 914592 | 2021-01-10 | Kane | Illinois | 17089 | 44090 | 651 |
911347 | 911347 | 2021-01-09 | Kane | Illinois | 17089 | 43928 | 648 |
908102 | 908102 | 2021-01-08 | Kane | Illinois | 17089 | 43691 | 642 |
904856 | 904856 | 2021-01-07 | Kane | Illinois | 17089 | 43351 | 638 |
901611 | 901611 | 2021-01-06 | Kane | Illinois | 17089 | 42992 | 631 |
898366 | 898366 | 2021-01-05 | Kane | Illinois | 17089 | 42669 | 628 |
895121 | 895121 | 2021-01-04 | Kane | Illinois | 17089 | 42355 | 621 |
891874 | 891874 | 2021-01-03 | Kane | Illinois | 17089 | 42153 | 619 |
888627 | 888627 | 2021-01-02 | Kane | Illinois | 17089 | 41958 | 618 |
885382 | 885382 | 2021-01-01 | Kane | Illinois | 17089 | 41511 | 604 |
882137 | 882137 | 2020-12-31 | Kane | Illinois | 17089 | 41511 | 604 |
878892 | 878892 | 2020-12-30 | Kane | Illinois | 17089 | 41232 | 601 |
875647 | 875647 | 2020-12-29 | Kane | Illinois | 17089 | 40869 | 596 |
872402 | 872402 | 2020-12-28 | Kane | Illinois | 17089 | 40678 | 594 |
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);