ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Hoke" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922387 | 922387 | 2021-01-12 | Hoke | North Carolina | 37093 | 3148 | 37 |
919142 | 919142 | 2021-01-11 | Hoke | North Carolina | 37093 | 3119 | 36 |
915897 | 915897 | 2021-01-10 | Hoke | North Carolina | 37093 | 3096 | 36 |
912652 | 912652 | 2021-01-09 | Hoke | North Carolina | 37093 | 3053 | 36 |
909407 | 909407 | 2021-01-08 | Hoke | North Carolina | 37093 | 3014 | 36 |
906162 | 906162 | 2021-01-07 | Hoke | North Carolina | 37093 | 2977 | 36 |
902916 | 902916 | 2021-01-06 | Hoke | North Carolina | 37093 | 2930 | 35 |
899671 | 899671 | 2021-01-05 | Hoke | North Carolina | 37093 | 2897 | 35 |
896426 | 896426 | 2021-01-04 | Hoke | North Carolina | 37093 | 2882 | 35 |
893180 | 893180 | 2021-01-03 | Hoke | North Carolina | 37093 | 2856 | 35 |
889934 | 889934 | 2021-01-02 | Hoke | North Carolina | 37093 | 2845 | 35 |
886687 | 886687 | 2021-01-01 | Hoke | North Carolina | 37093 | 2758 | 35 |
883442 | 883442 | 2020-12-31 | Hoke | North Carolina | 37093 | 2758 | 35 |
880197 | 880197 | 2020-12-30 | Hoke | North Carolina | 37093 | 2728 | 35 |
876952 | 876952 | 2020-12-29 | Hoke | North Carolina | 37093 | 2702 | 34 |
873707 | 873707 | 2020-12-28 | Hoke | North Carolina | 37093 | 2690 | 34 |
870462 | 870462 | 2020-12-27 | Hoke | North Carolina | 37093 | 2665 | 34 |
867217 | 867217 | 2020-12-26 | Hoke | North Carolina | 37093 | 2651 | 34 |
863972 | 863972 | 2020-12-25 | Hoke | North Carolina | 37093 | 2570 | 34 |
860727 | 860727 | 2020-12-24 | Hoke | North Carolina | 37093 | 2570 | 34 |
857482 | 857482 | 2020-12-23 | Hoke | North Carolina | 37093 | 2570 | 34 |
854237 | 854237 | 2020-12-22 | Hoke | North Carolina | 37093 | 2544 | 34 |
850992 | 850992 | 2020-12-21 | Hoke | North Carolina | 37093 | 2518 | 34 |
847747 | 847747 | 2020-12-20 | Hoke | North Carolina | 37093 | 2500 | 34 |
844502 | 844502 | 2020-12-19 | Hoke | North Carolina | 37093 | 2466 | 34 |
841256 | 841256 | 2020-12-18 | Hoke | North Carolina | 37093 | 2447 | 34 |
838011 | 838011 | 2020-12-17 | Hoke | North Carolina | 37093 | 2409 | 34 |
834765 | 834765 | 2020-12-16 | Hoke | North Carolina | 37093 | 2376 | 34 |
831519 | 831519 | 2020-12-15 | Hoke | North Carolina | 37093 | 2359 | 34 |
828272 | 828272 | 2020-12-14 | Hoke | North Carolina | 37093 | 2333 | 34 |
825026 | 825026 | 2020-12-13 | Hoke | North Carolina | 37093 | 2311 | 34 |
821779 | 821779 | 2020-12-12 | Hoke | North Carolina | 37093 | 2281 | 34 |
818533 | 818533 | 2020-12-11 | Hoke | North Carolina | 37093 | 2260 | 34 |
815287 | 815287 | 2020-12-10 | Hoke | North Carolina | 37093 | 2210 | 34 |
812042 | 812042 | 2020-12-09 | Hoke | North Carolina | 37093 | 2181 | 34 |
808797 | 808797 | 2020-12-08 | Hoke | North Carolina | 37093 | 2151 | 33 |
805552 | 805552 | 2020-12-07 | Hoke | North Carolina | 37093 | 2137 | 33 |
802307 | 802307 | 2020-12-06 | Hoke | North Carolina | 37093 | 2116 | 33 |
799062 | 799062 | 2020-12-05 | Hoke | North Carolina | 37093 | 2102 | 33 |
795817 | 795817 | 2020-12-04 | Hoke | North Carolina | 37093 | 2081 | 33 |
792572 | 792572 | 2020-12-03 | Hoke | North Carolina | 37093 | 2053 | 33 |
789327 | 789327 | 2020-12-02 | Hoke | North Carolina | 37093 | 1997 | 31 |
786082 | 786082 | 2020-12-01 | Hoke | North Carolina | 37093 | 1979 | 31 |
782838 | 782838 | 2020-11-30 | Hoke | North Carolina | 37093 | 1970 | 31 |
779592 | 779592 | 2020-11-29 | Hoke | North Carolina | 37093 | 1960 | 31 |
776347 | 776347 | 2020-11-28 | Hoke | North Carolina | 37093 | 1946 | 31 |
773102 | 773102 | 2020-11-27 | Hoke | North Carolina | 37093 | 1934 | 31 |
769857 | 769857 | 2020-11-26 | Hoke | North Carolina | 37093 | 1910 | 30 |
766611 | 766611 | 2020-11-25 | Hoke | North Carolina | 37093 | 1910 | 30 |
763366 | 763366 | 2020-11-24 | Hoke | North Carolina | 37093 | 1895 | 30 |
760121 | 760121 | 2020-11-23 | Hoke | North Carolina | 37093 | 1885 | 30 |
756875 | 756875 | 2020-11-22 | Hoke | North Carolina | 37093 | 1880 | 30 |
753628 | 753628 | 2020-11-21 | Hoke | North Carolina | 37093 | 1861 | 30 |
750382 | 750382 | 2020-11-20 | Hoke | North Carolina | 37093 | 1848 | 30 |
747136 | 747136 | 2020-11-19 | Hoke | North Carolina | 37093 | 1823 | 30 |
743890 | 743890 | 2020-11-18 | Hoke | North Carolina | 37093 | 1804 | 28 |
740643 | 740643 | 2020-11-17 | Hoke | North Carolina | 37093 | 1783 | 28 |
737398 | 737398 | 2020-11-16 | Hoke | North Carolina | 37093 | 1764 | 28 |
734154 | 734154 | 2020-11-15 | Hoke | North Carolina | 37093 | 1759 | 28 |
730908 | 730908 | 2020-11-14 | Hoke | North Carolina | 37093 | 1750 | 28 |
727664 | 727664 | 2020-11-13 | Hoke | North Carolina | 37093 | 1730 | 28 |
724420 | 724420 | 2020-11-12 | Hoke | North Carolina | 37093 | 1717 | 28 |
721177 | 721177 | 2020-11-11 | Hoke | North Carolina | 37093 | 1705 | 28 |
717934 | 717934 | 2020-11-10 | Hoke | North Carolina | 37093 | 1689 | 28 |
714691 | 714691 | 2020-11-09 | Hoke | North Carolina | 37093 | 1679 | 27 |
711447 | 711447 | 2020-11-08 | Hoke | North Carolina | 37093 | 1672 | 27 |
708203 | 708203 | 2020-11-07 | Hoke | North Carolina | 37093 | 1659 | 27 |
704960 | 704960 | 2020-11-06 | Hoke | North Carolina | 37093 | 1647 | 26 |
701717 | 701717 | 2020-11-05 | Hoke | North Carolina | 37093 | 1630 | 26 |
698473 | 698473 | 2020-11-04 | Hoke | North Carolina | 37093 | 1620 | 25 |
695230 | 695230 | 2020-11-03 | Hoke | North Carolina | 37093 | 1608 | 25 |
691988 | 691988 | 2020-11-02 | Hoke | North Carolina | 37093 | 1604 | 25 |
688744 | 688744 | 2020-11-01 | Hoke | North Carolina | 37093 | 1596 | 25 |
685499 | 685499 | 2020-10-31 | Hoke | North Carolina | 37093 | 1584 | 25 |
682256 | 682256 | 2020-10-30 | Hoke | North Carolina | 37093 | 1562 | 25 |
679013 | 679013 | 2020-10-29 | Hoke | North Carolina | 37093 | 1554 | 25 |
675770 | 675770 | 2020-10-28 | Hoke | North Carolina | 37093 | 1548 | 25 |
672527 | 672527 | 2020-10-27 | Hoke | North Carolina | 37093 | 1539 | 25 |
669285 | 669285 | 2020-10-26 | Hoke | North Carolina | 37093 | 1529 | 25 |
666041 | 666041 | 2020-10-25 | Hoke | North Carolina | 37093 | 1522 | 25 |
662796 | 662796 | 2020-10-24 | Hoke | North Carolina | 37093 | 1515 | 25 |
659552 | 659552 | 2020-10-23 | Hoke | North Carolina | 37093 | 1504 | 25 |
656308 | 656308 | 2020-10-22 | Hoke | North Carolina | 37093 | 1485 | 25 |
653063 | 653063 | 2020-10-21 | Hoke | North Carolina | 37093 | 1478 | 24 |
649818 | 649818 | 2020-10-20 | Hoke | North Carolina | 37093 | 1462 | 24 |
646574 | 646574 | 2020-10-19 | Hoke | North Carolina | 37093 | 1460 | 22 |
643328 | 643328 | 2020-10-18 | Hoke | North Carolina | 37093 | 1460 | 22 |
640080 | 640080 | 2020-10-17 | Hoke | North Carolina | 37093 | 1444 | 22 |
636834 | 636834 | 2020-10-16 | Hoke | North Carolina | 37093 | 1423 | 22 |
633588 | 633588 | 2020-10-15 | Hoke | North Carolina | 37093 | 1410 | 21 |
630343 | 630343 | 2020-10-14 | Hoke | North Carolina | 37093 | 1385 | 21 |
627099 | 627099 | 2020-10-13 | Hoke | North Carolina | 37093 | 1376 | 21 |
623857 | 623857 | 2020-10-12 | Hoke | North Carolina | 37093 | 1371 | 18 |
620614 | 620614 | 2020-10-11 | Hoke | North Carolina | 37093 | 1363 | 18 |
617372 | 617372 | 2020-10-10 | Hoke | North Carolina | 37093 | 1358 | 18 |
614130 | 614130 | 2020-10-09 | Hoke | North Carolina | 37093 | 1347 | 18 |
610889 | 610889 | 2020-10-08 | Hoke | North Carolina | 37093 | 1342 | 18 |
607647 | 607647 | 2020-10-07 | Hoke | North Carolina | 37093 | 1325 | 18 |
604404 | 604404 | 2020-10-06 | Hoke | North Carolina | 37093 | 1314 | 18 |
601162 | 601162 | 2020-10-05 | Hoke | North Carolina | 37093 | 1305 | 18 |
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);