ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Jefferson" and fips = 19101 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947245 | 947245 | 2021-01-20 | Jefferson | Iowa | 19101 | 1213 | 25 |
943998 | 943998 | 2021-01-19 | Jefferson | Iowa | 19101 | 1207 | 24 |
940753 | 940753 | 2021-01-18 | Jefferson | Iowa | 19101 | 1201 | 24 |
937508 | 937508 | 2021-01-17 | Jefferson | Iowa | 19101 | 1195 | 24 |
934263 | 934263 | 2021-01-16 | Jefferson | Iowa | 19101 | 1195 | 24 |
931018 | 931018 | 2021-01-15 | Jefferson | Iowa | 19101 | 1191 | 23 |
927773 | 927773 | 2021-01-14 | Jefferson | Iowa | 19101 | 1186 | 23 |
924527 | 924527 | 2021-01-13 | Jefferson | Iowa | 19101 | 1183 | 23 |
921282 | 921282 | 2021-01-12 | Jefferson | Iowa | 19101 | 1172 | 23 |
918037 | 918037 | 2021-01-11 | Jefferson | Iowa | 19101 | 1163 | 23 |
914792 | 914792 | 2021-01-10 | Jefferson | Iowa | 19101 | 1155 | 23 |
911547 | 911547 | 2021-01-09 | Jefferson | Iowa | 19101 | 1149 | 23 |
908302 | 908302 | 2021-01-08 | Jefferson | Iowa | 19101 | 1139 | 23 |
905056 | 905056 | 2021-01-07 | Jefferson | Iowa | 19101 | 1128 | 22 |
901811 | 901811 | 2021-01-06 | Jefferson | Iowa | 19101 | 1111 | 22 |
898566 | 898566 | 2021-01-05 | Jefferson | Iowa | 19101 | 1068 | 20 |
895321 | 895321 | 2021-01-04 | Jefferson | Iowa | 19101 | 1055 | 20 |
892074 | 892074 | 2021-01-03 | Jefferson | Iowa | 19101 | 1042 | 20 |
888828 | 888828 | 2021-01-02 | Jefferson | Iowa | 19101 | 1040 | 20 |
885582 | 885582 | 2021-01-01 | Jefferson | Iowa | 19101 | 1033 | 20 |
882337 | 882337 | 2020-12-31 | Jefferson | Iowa | 19101 | 1029 | 20 |
879092 | 879092 | 2020-12-30 | Jefferson | Iowa | 19101 | 1016 | 20 |
875847 | 875847 | 2020-12-29 | Jefferson | Iowa | 19101 | 1003 | 20 |
872602 | 872602 | 2020-12-28 | Jefferson | Iowa | 19101 | 978 | 20 |
869357 | 869357 | 2020-12-27 | Jefferson | Iowa | 19101 | 974 | 20 |
866112 | 866112 | 2020-12-26 | Jefferson | Iowa | 19101 | 970 | 20 |
862867 | 862867 | 2020-12-25 | Jefferson | Iowa | 19101 | 967 | 20 |
859622 | 859622 | 2020-12-24 | Jefferson | Iowa | 19101 | 963 | 20 |
856377 | 856377 | 2020-12-23 | Jefferson | Iowa | 19101 | 952 | 20 |
853132 | 853132 | 2020-12-22 | Jefferson | Iowa | 19101 | 942 | 20 |
849887 | 849887 | 2020-12-21 | Jefferson | Iowa | 19101 | 923 | 20 |
846642 | 846642 | 2020-12-20 | Jefferson | Iowa | 19101 | 909 | 20 |
843396 | 843396 | 2020-12-19 | Jefferson | Iowa | 19101 | 908 | 20 |
840151 | 840151 | 2020-12-18 | Jefferson | Iowa | 19101 | 879 | 18 |
836906 | 836906 | 2020-12-17 | Jefferson | Iowa | 19101 | 870 | 18 |
833660 | 833660 | 2020-12-16 | Jefferson | Iowa | 19101 | 864 | 16 |
830413 | 830413 | 2020-12-15 | Jefferson | Iowa | 19101 | 852 | 16 |
827167 | 827167 | 2020-12-14 | Jefferson | Iowa | 19101 | 847 | 13 |
823920 | 823920 | 2020-12-13 | Jefferson | Iowa | 19101 | 845 | 12 |
820674 | 820674 | 2020-12-12 | Jefferson | Iowa | 19101 | 842 | 12 |
817428 | 817428 | 2020-12-11 | Jefferson | Iowa | 19101 | 837 | 12 |
814182 | 814182 | 2020-12-10 | Jefferson | Iowa | 19101 | 826 | 11 |
810937 | 810937 | 2020-12-09 | Jefferson | Iowa | 19101 | 806 | 9 |
807692 | 807692 | 2020-12-08 | Jefferson | Iowa | 19101 | 797 | 9 |
804447 | 804447 | 2020-12-07 | Jefferson | Iowa | 19101 | 796 | 6 |
801202 | 801202 | 2020-12-06 | Jefferson | Iowa | 19101 | 788 | 6 |
797957 | 797957 | 2020-12-05 | Jefferson | Iowa | 19101 | 780 | 6 |
794712 | 794712 | 2020-12-04 | Jefferson | Iowa | 19101 | 776 | 6 |
791467 | 791467 | 2020-12-03 | Jefferson | Iowa | 19101 | 763 | 5 |
788222 | 788222 | 2020-12-02 | Jefferson | Iowa | 19101 | 751 | 2 |
784978 | 784978 | 2020-12-01 | Jefferson | Iowa | 19101 | 734 | 2 |
781733 | 781733 | 2020-11-30 | Jefferson | Iowa | 19101 | 725 | 2 |
778487 | 778487 | 2020-11-29 | Jefferson | Iowa | 19101 | 714 | 2 |
775242 | 775242 | 2020-11-28 | Jefferson | Iowa | 19101 | 711 | 2 |
771997 | 771997 | 2020-11-27 | Jefferson | Iowa | 19101 | 706 | 2 |
768752 | 768752 | 2020-11-26 | Jefferson | Iowa | 19101 | 685 | 2 |
765506 | 765506 | 2020-11-25 | Jefferson | Iowa | 19101 | 674 | 2 |
762261 | 762261 | 2020-11-24 | Jefferson | Iowa | 19101 | 644 | 1 |
759016 | 759016 | 2020-11-23 | Jefferson | Iowa | 19101 | 635 | 1 |
755769 | 755769 | 2020-11-22 | Jefferson | Iowa | 19101 | 612 | 1 |
752523 | 752523 | 2020-11-21 | Jefferson | Iowa | 19101 | 607 | 1 |
749277 | 749277 | 2020-11-20 | Jefferson | Iowa | 19101 | 590 | 1 |
746031 | 746031 | 2020-11-19 | Jefferson | Iowa | 19101 | 568 | 1 |
742784 | 742784 | 2020-11-18 | Jefferson | Iowa | 19101 | 552 | 1 |
739537 | 739537 | 2020-11-17 | Jefferson | Iowa | 19101 | 527 | 1 |
736293 | 736293 | 2020-11-16 | Jefferson | Iowa | 19101 | 513 | 1 |
733047 | 733047 | 2020-11-15 | Jefferson | Iowa | 19101 | 488 | 1 |
729802 | 729802 | 2020-11-14 | Jefferson | Iowa | 19101 | 486 | 1 |
726559 | 726559 | 2020-11-13 | Jefferson | Iowa | 19101 | 478 | 1 |
723316 | 723316 | 2020-11-12 | Jefferson | Iowa | 19101 | 456 | 1 |
720073 | 720073 | 2020-11-11 | Jefferson | Iowa | 19101 | 429 | 1 |
716830 | 716830 | 2020-11-10 | Jefferson | Iowa | 19101 | 392 | 1 |
713586 | 713586 | 2020-11-09 | Jefferson | Iowa | 19101 | 366 | 1 |
710342 | 710342 | 2020-11-08 | Jefferson | Iowa | 19101 | 354 | 1 |
707098 | 707098 | 2020-11-07 | Jefferson | Iowa | 19101 | 347 | 1 |
703855 | 703855 | 2020-11-06 | Jefferson | Iowa | 19101 | 338 | 1 |
700613 | 700613 | 2020-11-05 | Jefferson | Iowa | 19101 | 323 | 1 |
697369 | 697369 | 2020-11-04 | Jefferson | Iowa | 19101 | 308 | 1 |
694127 | 694127 | 2020-11-03 | Jefferson | Iowa | 19101 | 295 | 1 |
690884 | 690884 | 2020-11-02 | Jefferson | Iowa | 19101 | 285 | 1 |
687639 | 687639 | 2020-11-01 | Jefferson | Iowa | 19101 | 282 | 1 |
684395 | 684395 | 2020-10-31 | Jefferson | Iowa | 19101 | 274 | 1 |
681152 | 681152 | 2020-10-30 | Jefferson | Iowa | 19101 | 267 | 1 |
677909 | 677909 | 2020-10-29 | Jefferson | Iowa | 19101 | 260 | 1 |
674666 | 674666 | 2020-10-28 | Jefferson | Iowa | 19101 | 251 | 1 |
671424 | 671424 | 2020-10-27 | Jefferson | Iowa | 19101 | 245 | 1 |
668181 | 668181 | 2020-10-26 | Jefferson | Iowa | 19101 | 239 | 1 |
664937 | 664937 | 2020-10-25 | Jefferson | Iowa | 19101 | 238 | 1 |
661692 | 661692 | 2020-10-24 | Jefferson | Iowa | 19101 | 234 | 1 |
658448 | 658448 | 2020-10-23 | Jefferson | Iowa | 19101 | 231 | 1 |
655203 | 655203 | 2020-10-22 | Jefferson | Iowa | 19101 | 218 | 1 |
651958 | 651958 | 2020-10-21 | Jefferson | Iowa | 19101 | 210 | 1 |
648714 | 648714 | 2020-10-20 | Jefferson | Iowa | 19101 | 203 | 1 |
645469 | 645469 | 2020-10-19 | Jefferson | Iowa | 19101 | 190 | 1 |
642222 | 642222 | 2020-10-18 | Jefferson | Iowa | 19101 | 188 | 1 |
638975 | 638975 | 2020-10-17 | Jefferson | Iowa | 19101 | 187 | 1 |
635729 | 635729 | 2020-10-16 | Jefferson | Iowa | 19101 | 185 | 1 |
632483 | 632483 | 2020-10-15 | Jefferson | Iowa | 19101 | 183 | 1 |
629239 | 629239 | 2020-10-14 | Jefferson | Iowa | 19101 | 179 | 1 |
625996 | 625996 | 2020-10-13 | Jefferson | Iowa | 19101 | 177 | 1 |
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);