ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Jefferson" and fips = 5069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946545 | 946545 | 2021-01-20 | Jefferson | Arkansas | 5069 | 7585 | 143 |
943298 | 943298 | 2021-01-19 | Jefferson | Arkansas | 5069 | 7535 | 140 |
940053 | 940053 | 2021-01-18 | Jefferson | Arkansas | 5069 | 7493 | 139 |
936808 | 936808 | 2021-01-17 | Jefferson | Arkansas | 5069 | 7440 | 139 |
933563 | 933563 | 2021-01-16 | Jefferson | Arkansas | 5069 | 7428 | 139 |
930318 | 930318 | 2021-01-15 | Jefferson | Arkansas | 5069 | 7377 | 137 |
927073 | 927073 | 2021-01-14 | Jefferson | Arkansas | 5069 | 7311 | 137 |
923827 | 923827 | 2021-01-13 | Jefferson | Arkansas | 5069 | 7283 | 136 |
920582 | 920582 | 2021-01-12 | Jefferson | Arkansas | 5069 | 7243 | 136 |
917337 | 917337 | 2021-01-11 | Jefferson | Arkansas | 5069 | 7190 | 134 |
914092 | 914092 | 2021-01-10 | Jefferson | Arkansas | 5069 | 7173 | 134 |
910847 | 910847 | 2021-01-09 | Jefferson | Arkansas | 5069 | 7144 | 133 |
907602 | 907602 | 2021-01-08 | Jefferson | Arkansas | 5069 | 7093 | 133 |
904356 | 904356 | 2021-01-07 | Jefferson | Arkansas | 5069 | 7043 | 133 |
901111 | 901111 | 2021-01-06 | Jefferson | Arkansas | 5069 | 6992 | 133 |
897866 | 897866 | 2021-01-05 | Jefferson | Arkansas | 5069 | 6923 | 131 |
894621 | 894621 | 2021-01-04 | Jefferson | Arkansas | 5069 | 6865 | 131 |
891374 | 891374 | 2021-01-03 | Jefferson | Arkansas | 5069 | 6846 | 129 |
888127 | 888127 | 2021-01-02 | Jefferson | Arkansas | 5069 | 6836 | 129 |
884882 | 884882 | 2021-01-01 | Jefferson | Arkansas | 5069 | 6797 | 129 |
881637 | 881637 | 2020-12-31 | Jefferson | Arkansas | 5069 | 6718 | 127 |
878392 | 878392 | 2020-12-30 | Jefferson | Arkansas | 5069 | 6648 | 127 |
875147 | 875147 | 2020-12-29 | Jefferson | Arkansas | 5069 | 6613 | 127 |
871902 | 871902 | 2020-12-28 | Jefferson | Arkansas | 5069 | 6548 | 126 |
868657 | 868657 | 2020-12-27 | Jefferson | Arkansas | 5069 | 6516 | 125 |
865412 | 865412 | 2020-12-26 | Jefferson | Arkansas | 5069 | 6511 | 125 |
862167 | 862167 | 2020-12-25 | Jefferson | Arkansas | 5069 | 6508 | 125 |
858922 | 858922 | 2020-12-24 | Jefferson | Arkansas | 5069 | 6466 | 125 |
855677 | 855677 | 2020-12-23 | Jefferson | Arkansas | 5069 | 6373 | 125 |
852432 | 852432 | 2020-12-22 | Jefferson | Arkansas | 5069 | 6262 | 124 |
849187 | 849187 | 2020-12-21 | Jefferson | Arkansas | 5069 | 6236 | 123 |
845942 | 845942 | 2020-12-20 | Jefferson | Arkansas | 5069 | 6205 | 123 |
842696 | 842696 | 2020-12-19 | Jefferson | Arkansas | 5069 | 6164 | 123 |
839451 | 839451 | 2020-12-18 | Jefferson | Arkansas | 5069 | 6023 | 122 |
836206 | 836206 | 2020-12-17 | Jefferson | Arkansas | 5069 | 5949 | 122 |
832960 | 832960 | 2020-12-16 | Jefferson | Arkansas | 5069 | 5820 | 121 |
829713 | 829713 | 2020-12-15 | Jefferson | Arkansas | 5069 | 5766 | 121 |
826467 | 826467 | 2020-12-14 | Jefferson | Arkansas | 5069 | 5740 | 121 |
823220 | 823220 | 2020-12-13 | Jefferson | Arkansas | 5069 | 5691 | 118 |
819974 | 819974 | 2020-12-12 | Jefferson | Arkansas | 5069 | 5658 | 116 |
816728 | 816728 | 2020-12-11 | Jefferson | Arkansas | 5069 | 5631 | 116 |
813482 | 813482 | 2020-12-10 | Jefferson | Arkansas | 5069 | 5557 | 116 |
810238 | 810238 | 2020-12-09 | Jefferson | Arkansas | 5069 | 5519 | 116 |
806993 | 806993 | 2020-12-08 | Jefferson | Arkansas | 5069 | 5512 | 115 |
803748 | 803748 | 2020-12-07 | Jefferson | Arkansas | 5069 | 5486 | 112 |
800503 | 800503 | 2020-12-06 | Jefferson | Arkansas | 5069 | 5469 | 112 |
797258 | 797258 | 2020-12-05 | Jefferson | Arkansas | 5069 | 5437 | 112 |
794013 | 794013 | 2020-12-04 | Jefferson | Arkansas | 5069 | 5372 | 112 |
790768 | 790768 | 2020-12-03 | Jefferson | Arkansas | 5069 | 5338 | 111 |
787523 | 787523 | 2020-12-02 | Jefferson | Arkansas | 5069 | 5263 | 111 |
784279 | 784279 | 2020-12-01 | Jefferson | Arkansas | 5069 | 5238 | 111 |
781034 | 781034 | 2020-11-30 | Jefferson | Arkansas | 5069 | 5207 | 111 |
777788 | 777788 | 2020-11-29 | Jefferson | Arkansas | 5069 | 5197 | 111 |
774543 | 774543 | 2020-11-28 | Jefferson | Arkansas | 5069 | 5162 | 109 |
771298 | 771298 | 2020-11-27 | Jefferson | Arkansas | 5069 | 5147 | 109 |
768053 | 768053 | 2020-11-26 | Jefferson | Arkansas | 5069 | 5137 | 109 |
764807 | 764807 | 2020-11-25 | Jefferson | Arkansas | 5069 | 5089 | 109 |
761562 | 761562 | 2020-11-24 | Jefferson | Arkansas | 5069 | 5061 | 109 |
758317 | 758317 | 2020-11-23 | Jefferson | Arkansas | 5069 | 5010 | 109 |
755070 | 755070 | 2020-11-22 | Jefferson | Arkansas | 5069 | 4990 | 107 |
751824 | 751824 | 2020-11-21 | Jefferson | Arkansas | 5069 | 4972 | 107 |
748578 | 748578 | 2020-11-20 | Jefferson | Arkansas | 5069 | 4929 | 107 |
745332 | 745332 | 2020-11-19 | Jefferson | Arkansas | 5069 | 4894 | 106 |
742085 | 742085 | 2020-11-18 | Jefferson | Arkansas | 5069 | 4853 | 106 |
738838 | 738838 | 2020-11-17 | Jefferson | Arkansas | 5069 | 4831 | 105 |
735594 | 735594 | 2020-11-16 | Jefferson | Arkansas | 5069 | 4791 | 104 |
732348 | 732348 | 2020-11-15 | Jefferson | Arkansas | 5069 | 4758 | 104 |
729103 | 729103 | 2020-11-14 | Jefferson | Arkansas | 5069 | 4748 | 103 |
725860 | 725860 | 2020-11-13 | Jefferson | Arkansas | 5069 | 4714 | 103 |
722617 | 722617 | 2020-11-12 | Jefferson | Arkansas | 5069 | 4679 | 103 |
719374 | 719374 | 2020-11-11 | Jefferson | Arkansas | 5069 | 4629 | 103 |
716131 | 716131 | 2020-11-10 | Jefferson | Arkansas | 5069 | 4595 | 102 |
712887 | 712887 | 2020-11-09 | Jefferson | Arkansas | 5069 | 4559 | 102 |
709643 | 709643 | 2020-11-08 | Jefferson | Arkansas | 5069 | 4547 | 102 |
706399 | 706399 | 2020-11-07 | Jefferson | Arkansas | 5069 | 4525 | 102 |
703156 | 703156 | 2020-11-06 | Jefferson | Arkansas | 5069 | 4460 | 102 |
699913 | 699913 | 2020-11-05 | Jefferson | Arkansas | 5069 | 4416 | 102 |
696669 | 696669 | 2020-11-04 | Jefferson | Arkansas | 5069 | 4393 | 102 |
693427 | 693427 | 2020-11-03 | Jefferson | Arkansas | 5069 | 4329 | 102 |
690184 | 690184 | 2020-11-02 | Jefferson | Arkansas | 5069 | 4312 | 102 |
686939 | 686939 | 2020-11-01 | Jefferson | Arkansas | 5069 | 4302 | 102 |
683695 | 683695 | 2020-10-31 | Jefferson | Arkansas | 5069 | 4289 | 102 |
680452 | 680452 | 2020-10-30 | Jefferson | Arkansas | 5069 | 4270 | 102 |
677209 | 677209 | 2020-10-29 | Jefferson | Arkansas | 5069 | 4243 | 102 |
673966 | 673966 | 2020-10-28 | Jefferson | Arkansas | 5069 | 4231 | 102 |
670724 | 670724 | 2020-10-27 | Jefferson | Arkansas | 5069 | 4194 | 102 |
667481 | 667481 | 2020-10-26 | Jefferson | Arkansas | 5069 | 4160 | 102 |
664236 | 664236 | 2020-10-25 | Jefferson | Arkansas | 5069 | 4136 | 102 |
660992 | 660992 | 2020-10-24 | Jefferson | Arkansas | 5069 | 4121 | 102 |
657748 | 657748 | 2020-10-23 | Jefferson | Arkansas | 5069 | 4090 | 102 |
654503 | 654503 | 2020-10-22 | Jefferson | Arkansas | 5069 | 4064 | 101 |
651258 | 651258 | 2020-10-21 | Jefferson | Arkansas | 5069 | 4039 | 100 |
648014 | 648014 | 2020-10-20 | Jefferson | Arkansas | 5069 | 3987 | 100 |
644769 | 644769 | 2020-10-19 | Jefferson | Arkansas | 5069 | 3967 | 100 |
641521 | 641521 | 2020-10-18 | Jefferson | Arkansas | 5069 | 3933 | 98 |
638274 | 638274 | 2020-10-17 | Jefferson | Arkansas | 5069 | 3921 | 97 |
635029 | 635029 | 2020-10-16 | Jefferson | Arkansas | 5069 | 3904 | 97 |
631783 | 631783 | 2020-10-15 | Jefferson | Arkansas | 5069 | 3896 | 97 |
628539 | 628539 | 2020-10-14 | Jefferson | Arkansas | 5069 | 3863 | 97 |
625296 | 625296 | 2020-10-13 | Jefferson | Arkansas | 5069 | 3802 | 95 |
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);