ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Surry" 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 |
---|---|---|---|---|---|---|---|
922426 | 922426 | 2021-01-12 | Surry | North Carolina | 37171 | 5260 | 92 |
919181 | 919181 | 2021-01-11 | Surry | North Carolina | 37171 | 5231 | 92 |
915936 | 915936 | 2021-01-10 | Surry | North Carolina | 37171 | 5200 | 92 |
912691 | 912691 | 2021-01-09 | Surry | North Carolina | 37171 | 5117 | 92 |
909446 | 909446 | 2021-01-08 | Surry | North Carolina | 37171 | 5009 | 86 |
906201 | 906201 | 2021-01-07 | Surry | North Carolina | 37171 | 4955 | 86 |
902955 | 902955 | 2021-01-06 | Surry | North Carolina | 37171 | 4853 | 86 |
899710 | 899710 | 2021-01-05 | Surry | North Carolina | 37171 | 4747 | 84 |
896465 | 896465 | 2021-01-04 | Surry | North Carolina | 37171 | 4670 | 84 |
893219 | 893219 | 2021-01-03 | Surry | North Carolina | 37171 | 4620 | 78 |
889973 | 889973 | 2021-01-02 | Surry | North Carolina | 37171 | 4588 | 78 |
886726 | 886726 | 2021-01-01 | Surry | North Carolina | 37171 | 4430 | 75 |
883481 | 883481 | 2020-12-31 | Surry | North Carolina | 37171 | 4430 | 75 |
880236 | 880236 | 2020-12-30 | Surry | North Carolina | 37171 | 4388 | 75 |
876991 | 876991 | 2020-12-29 | Surry | North Carolina | 37171 | 4266 | 63 |
873746 | 873746 | 2020-12-28 | Surry | North Carolina | 37171 | 4251 | 63 |
870501 | 870501 | 2020-12-27 | Surry | North Carolina | 37171 | 4216 | 63 |
867256 | 867256 | 2020-12-26 | Surry | North Carolina | 37171 | 4202 | 63 |
864011 | 864011 | 2020-12-25 | Surry | North Carolina | 37171 | 4036 | 60 |
860766 | 860766 | 2020-12-24 | Surry | North Carolina | 37171 | 4036 | 60 |
857521 | 857521 | 2020-12-23 | Surry | North Carolina | 37171 | 4036 | 60 |
854276 | 854276 | 2020-12-22 | Surry | North Carolina | 37171 | 3970 | 57 |
851031 | 851031 | 2020-12-21 | Surry | North Carolina | 37171 | 3908 | 57 |
847786 | 847786 | 2020-12-20 | Surry | North Carolina | 37171 | 3881 | 53 |
844541 | 844541 | 2020-12-19 | Surry | North Carolina | 37171 | 3804 | 53 |
841295 | 841295 | 2020-12-18 | Surry | North Carolina | 37171 | 3723 | 53 |
838050 | 838050 | 2020-12-17 | Surry | North Carolina | 37171 | 3645 | 53 |
834804 | 834804 | 2020-12-16 | Surry | North Carolina | 37171 | 3606 | 52 |
831558 | 831558 | 2020-12-15 | Surry | North Carolina | 37171 | 3537 | 52 |
828311 | 828311 | 2020-12-14 | Surry | North Carolina | 37171 | 3488 | 52 |
825065 | 825065 | 2020-12-13 | Surry | North Carolina | 37171 | 3439 | 52 |
821818 | 821818 | 2020-12-12 | Surry | North Carolina | 37171 | 3378 | 50 |
818572 | 818572 | 2020-12-11 | Surry | North Carolina | 37171 | 3322 | 50 |
815326 | 815326 | 2020-12-10 | Surry | North Carolina | 37171 | 3250 | 49 |
812081 | 812081 | 2020-12-09 | Surry | North Carolina | 37171 | 3187 | 49 |
808836 | 808836 | 2020-12-08 | Surry | North Carolina | 37171 | 3123 | 49 |
805591 | 805591 | 2020-12-07 | Surry | North Carolina | 37171 | 3084 | 49 |
802346 | 802346 | 2020-12-06 | Surry | North Carolina | 37171 | 3045 | 49 |
799101 | 799101 | 2020-12-05 | Surry | North Carolina | 37171 | 3002 | 49 |
795856 | 795856 | 2020-12-04 | Surry | North Carolina | 37171 | 2969 | 49 |
792611 | 792611 | 2020-12-03 | Surry | North Carolina | 37171 | 2931 | 49 |
789366 | 789366 | 2020-12-02 | Surry | North Carolina | 37171 | 2894 | 49 |
786121 | 786121 | 2020-12-01 | Surry | North Carolina | 37171 | 2839 | 44 |
782877 | 782877 | 2020-11-30 | Surry | North Carolina | 37171 | 2809 | 44 |
779631 | 779631 | 2020-11-29 | Surry | North Carolina | 37171 | 2779 | 44 |
776386 | 776386 | 2020-11-28 | Surry | North Carolina | 37171 | 2755 | 44 |
773141 | 773141 | 2020-11-27 | Surry | North Carolina | 37171 | 2747 | 44 |
769896 | 769896 | 2020-11-26 | Surry | North Carolina | 37171 | 2677 | 43 |
766650 | 766650 | 2020-11-25 | Surry | North Carolina | 37171 | 2677 | 43 |
763405 | 763405 | 2020-11-24 | Surry | North Carolina | 37171 | 2620 | 42 |
760160 | 760160 | 2020-11-23 | Surry | North Carolina | 37171 | 2603 | 41 |
756914 | 756914 | 2020-11-22 | Surry | North Carolina | 37171 | 2589 | 41 |
753667 | 753667 | 2020-11-21 | Surry | North Carolina | 37171 | 2548 | 41 |
750421 | 750421 | 2020-11-20 | Surry | North Carolina | 37171 | 2526 | 41 |
747175 | 747175 | 2020-11-19 | Surry | North Carolina | 37171 | 2480 | 41 |
743929 | 743929 | 2020-11-18 | Surry | North Carolina | 37171 | 2426 | 41 |
740682 | 740682 | 2020-11-17 | Surry | North Carolina | 37171 | 2385 | 41 |
737437 | 737437 | 2020-11-16 | Surry | North Carolina | 37171 | 2362 | 40 |
734193 | 734193 | 2020-11-15 | Surry | North Carolina | 37171 | 2351 | 39 |
730947 | 730947 | 2020-11-14 | Surry | North Carolina | 37171 | 2334 | 39 |
727703 | 727703 | 2020-11-13 | Surry | North Carolina | 37171 | 2308 | 39 |
724459 | 724459 | 2020-11-12 | Surry | North Carolina | 37171 | 2289 | 39 |
721216 | 721216 | 2020-11-11 | Surry | North Carolina | 37171 | 2253 | 39 |
717973 | 717973 | 2020-11-10 | Surry | North Carolina | 37171 | 2221 | 39 |
714730 | 714730 | 2020-11-09 | Surry | North Carolina | 37171 | 2200 | 38 |
711486 | 711486 | 2020-11-08 | Surry | North Carolina | 37171 | 2187 | 38 |
708242 | 708242 | 2020-11-07 | Surry | North Carolina | 37171 | 2157 | 38 |
704999 | 704999 | 2020-11-06 | Surry | North Carolina | 37171 | 2142 | 38 |
701756 | 701756 | 2020-11-05 | Surry | North Carolina | 37171 | 2093 | 37 |
698512 | 698512 | 2020-11-04 | Surry | North Carolina | 37171 | 2050 | 36 |
695269 | 695269 | 2020-11-03 | Surry | North Carolina | 37171 | 2021 | 35 |
692027 | 692027 | 2020-11-02 | Surry | North Carolina | 37171 | 2009 | 33 |
688783 | 688783 | 2020-11-01 | Surry | North Carolina | 37171 | 1998 | 33 |
685538 | 685538 | 2020-10-31 | Surry | North Carolina | 37171 | 1961 | 33 |
682295 | 682295 | 2020-10-30 | Surry | North Carolina | 37171 | 1930 | 33 |
679052 | 679052 | 2020-10-29 | Surry | North Carolina | 37171 | 1885 | 33 |
675809 | 675809 | 2020-10-28 | Surry | North Carolina | 37171 | 1853 | 30 |
672566 | 672566 | 2020-10-27 | Surry | North Carolina | 37171 | 1810 | 30 |
669324 | 669324 | 2020-10-26 | Surry | North Carolina | 37171 | 1795 | 29 |
666080 | 666080 | 2020-10-25 | Surry | North Carolina | 37171 | 1771 | 29 |
662835 | 662835 | 2020-10-24 | Surry | North Carolina | 37171 | 1738 | 29 |
659591 | 659591 | 2020-10-23 | Surry | North Carolina | 37171 | 1694 | 29 |
656347 | 656347 | 2020-10-22 | Surry | North Carolina | 37171 | 1677 | 29 |
653102 | 653102 | 2020-10-21 | Surry | North Carolina | 37171 | 1661 | 29 |
649857 | 649857 | 2020-10-20 | Surry | North Carolina | 37171 | 1646 | 26 |
646613 | 646613 | 2020-10-19 | Surry | North Carolina | 37171 | 1636 | 26 |
643367 | 643367 | 2020-10-18 | Surry | North Carolina | 37171 | 1610 | 26 |
640119 | 640119 | 2020-10-17 | Surry | North Carolina | 37171 | 1599 | 26 |
636873 | 636873 | 2020-10-16 | Surry | North Carolina | 37171 | 1577 | 26 |
633627 | 633627 | 2020-10-15 | Surry | North Carolina | 37171 | 1542 | 26 |
630382 | 630382 | 2020-10-14 | Surry | North Carolina | 37171 | 1530 | 26 |
627138 | 627138 | 2020-10-13 | Surry | North Carolina | 37171 | 1512 | 26 |
623896 | 623896 | 2020-10-12 | Surry | North Carolina | 37171 | 1503 | 26 |
620653 | 620653 | 2020-10-11 | Surry | North Carolina | 37171 | 1497 | 26 |
617411 | 617411 | 2020-10-10 | Surry | North Carolina | 37171 | 1480 | 25 |
614169 | 614169 | 2020-10-09 | Surry | North Carolina | 37171 | 1459 | 25 |
610928 | 610928 | 2020-10-08 | Surry | North Carolina | 37171 | 1451 | 23 |
607686 | 607686 | 2020-10-07 | Surry | North Carolina | 37171 | 1431 | 23 |
604443 | 604443 | 2020-10-06 | Surry | North Carolina | 37171 | 1424 | 23 |
601201 | 601201 | 2020-10-05 | Surry | North Carolina | 37171 | 1411 | 23 |
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);