ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 37003 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 |
---|---|---|---|---|---|---|---|
922342 | 922342 | 2021-01-12 | Alexander | North Carolina | 37003 | 3094 | 38 |
919097 | 919097 | 2021-01-11 | Alexander | North Carolina | 37003 | 3071 | 38 |
915852 | 915852 | 2021-01-10 | Alexander | North Carolina | 37003 | 3058 | 38 |
912607 | 912607 | 2021-01-09 | Alexander | North Carolina | 37003 | 2926 | 31 |
909362 | 909362 | 2021-01-08 | Alexander | North Carolina | 37003 | 2889 | 31 |
906117 | 906117 | 2021-01-07 | Alexander | North Carolina | 37003 | 2846 | 31 |
902871 | 902871 | 2021-01-06 | Alexander | North Carolina | 37003 | 2843 | 31 |
899626 | 899626 | 2021-01-05 | Alexander | North Carolina | 37003 | 2839 | 31 |
896381 | 896381 | 2021-01-04 | Alexander | North Carolina | 37003 | 2827 | 31 |
893135 | 893135 | 2021-01-03 | Alexander | North Carolina | 37003 | 2806 | 30 |
889889 | 889889 | 2021-01-02 | Alexander | North Carolina | 37003 | 2755 | 30 |
886642 | 886642 | 2021-01-01 | Alexander | North Carolina | 37003 | 2662 | 30 |
883397 | 883397 | 2020-12-31 | Alexander | North Carolina | 37003 | 2662 | 30 |
880152 | 880152 | 2020-12-30 | Alexander | North Carolina | 37003 | 2642 | 30 |
876907 | 876907 | 2020-12-29 | Alexander | North Carolina | 37003 | 2564 | 30 |
873662 | 873662 | 2020-12-28 | Alexander | North Carolina | 37003 | 2526 | 29 |
870417 | 870417 | 2020-12-27 | Alexander | North Carolina | 37003 | 2512 | 29 |
867172 | 867172 | 2020-12-26 | Alexander | North Carolina | 37003 | 2505 | 29 |
863927 | 863927 | 2020-12-25 | Alexander | North Carolina | 37003 | 2393 | 29 |
860682 | 860682 | 2020-12-24 | Alexander | North Carolina | 37003 | 2393 | 29 |
857437 | 857437 | 2020-12-23 | Alexander | North Carolina | 37003 | 2393 | 29 |
854192 | 854192 | 2020-12-22 | Alexander | North Carolina | 37003 | 2357 | 26 |
850947 | 850947 | 2020-12-21 | Alexander | North Carolina | 37003 | 2299 | 26 |
847702 | 847702 | 2020-12-20 | Alexander | North Carolina | 37003 | 2273 | 26 |
844457 | 844457 | 2020-12-19 | Alexander | North Carolina | 37003 | 2226 | 26 |
841211 | 841211 | 2020-12-18 | Alexander | North Carolina | 37003 | 2174 | 22 |
837966 | 837966 | 2020-12-17 | Alexander | North Carolina | 37003 | 2133 | 21 |
834720 | 834720 | 2020-12-16 | Alexander | North Carolina | 37003 | 2109 | 21 |
831474 | 831474 | 2020-12-15 | Alexander | North Carolina | 37003 | 2099 | 21 |
828227 | 828227 | 2020-12-14 | Alexander | North Carolina | 37003 | 2067 | 21 |
824981 | 824981 | 2020-12-13 | Alexander | North Carolina | 37003 | 2044 | 21 |
821734 | 821734 | 2020-12-12 | Alexander | North Carolina | 37003 | 2009 | 19 |
818488 | 818488 | 2020-12-11 | Alexander | North Carolina | 37003 | 1974 | 19 |
815242 | 815242 | 2020-12-10 | Alexander | North Carolina | 37003 | 1940 | 19 |
811997 | 811997 | 2020-12-09 | Alexander | North Carolina | 37003 | 1923 | 19 |
808752 | 808752 | 2020-12-08 | Alexander | North Carolina | 37003 | 1886 | 18 |
805507 | 805507 | 2020-12-07 | Alexander | North Carolina | 37003 | 1853 | 18 |
802262 | 802262 | 2020-12-06 | Alexander | North Carolina | 37003 | 1813 | 18 |
799017 | 799017 | 2020-12-05 | Alexander | North Carolina | 37003 | 1754 | 18 |
795772 | 795772 | 2020-12-04 | Alexander | North Carolina | 37003 | 1731 | 18 |
792527 | 792527 | 2020-12-03 | Alexander | North Carolina | 37003 | 1700 | 18 |
789282 | 789282 | 2020-12-02 | Alexander | North Carolina | 37003 | 1679 | 17 |
786037 | 786037 | 2020-12-01 | Alexander | North Carolina | 37003 | 1663 | 17 |
782793 | 782793 | 2020-11-30 | Alexander | North Carolina | 37003 | 1653 | 17 |
779547 | 779547 | 2020-11-29 | Alexander | North Carolina | 37003 | 1641 | 17 |
776302 | 776302 | 2020-11-28 | Alexander | North Carolina | 37003 | 1602 | 17 |
773057 | 773057 | 2020-11-27 | Alexander | North Carolina | 37003 | 1579 | 17 |
769812 | 769812 | 2020-11-26 | Alexander | North Carolina | 37003 | 1537 | 15 |
766566 | 766566 | 2020-11-25 | Alexander | North Carolina | 37003 | 1537 | 15 |
763321 | 763321 | 2020-11-24 | Alexander | North Carolina | 37003 | 1498 | 15 |
760076 | 760076 | 2020-11-23 | Alexander | North Carolina | 37003 | 1478 | 15 |
756830 | 756830 | 2020-11-22 | Alexander | North Carolina | 37003 | 1455 | 13 |
753583 | 753583 | 2020-11-21 | Alexander | North Carolina | 37003 | 1430 | 13 |
750337 | 750337 | 2020-11-20 | Alexander | North Carolina | 37003 | 1396 | 13 |
747091 | 747091 | 2020-11-19 | Alexander | North Carolina | 37003 | 1373 | 13 |
743845 | 743845 | 2020-11-18 | Alexander | North Carolina | 37003 | 1359 | 13 |
740598 | 740598 | 2020-11-17 | Alexander | North Carolina | 37003 | 1337 | 13 |
737353 | 737353 | 2020-11-16 | Alexander | North Carolina | 37003 | 1315 | 13 |
734109 | 734109 | 2020-11-15 | Alexander | North Carolina | 37003 | 1280 | 13 |
730863 | 730863 | 2020-11-14 | Alexander | North Carolina | 37003 | 1262 | 12 |
727619 | 727619 | 2020-11-13 | Alexander | North Carolina | 37003 | 1231 | 12 |
724375 | 724375 | 2020-11-12 | Alexander | North Carolina | 37003 | 1217 | 12 |
721132 | 721132 | 2020-11-11 | Alexander | North Carolina | 37003 | 1209 | 12 |
717889 | 717889 | 2020-11-10 | Alexander | North Carolina | 37003 | 1195 | 12 |
714646 | 714646 | 2020-11-09 | Alexander | North Carolina | 37003 | 1170 | 12 |
711402 | 711402 | 2020-11-08 | Alexander | North Carolina | 37003 | 1150 | 12 |
708158 | 708158 | 2020-11-07 | Alexander | North Carolina | 37003 | 1120 | 12 |
704915 | 704915 | 2020-11-06 | Alexander | North Carolina | 37003 | 1084 | 12 |
701672 | 701672 | 2020-11-05 | Alexander | North Carolina | 37003 | 1038 | 12 |
698428 | 698428 | 2020-11-04 | Alexander | North Carolina | 37003 | 1024 | 10 |
695185 | 695185 | 2020-11-03 | Alexander | North Carolina | 37003 | 1009 | 10 |
691943 | 691943 | 2020-11-02 | Alexander | North Carolina | 37003 | 980 | 10 |
688699 | 688699 | 2020-11-01 | Alexander | North Carolina | 37003 | 975 | 10 |
685454 | 685454 | 2020-10-31 | Alexander | North Carolina | 37003 | 963 | 10 |
682211 | 682211 | 2020-10-30 | Alexander | North Carolina | 37003 | 943 | 10 |
678968 | 678968 | 2020-10-29 | Alexander | North Carolina | 37003 | 882 | 10 |
675725 | 675725 | 2020-10-28 | Alexander | North Carolina | 37003 | 865 | 9 |
672482 | 672482 | 2020-10-27 | Alexander | North Carolina | 37003 | 851 | 9 |
669240 | 669240 | 2020-10-26 | Alexander | North Carolina | 37003 | 830 | 9 |
665996 | 665996 | 2020-10-25 | Alexander | North Carolina | 37003 | 823 | 9 |
662751 | 662751 | 2020-10-24 | Alexander | North Carolina | 37003 | 817 | 9 |
659507 | 659507 | 2020-10-23 | Alexander | North Carolina | 37003 | 771 | 9 |
656263 | 656263 | 2020-10-22 | Alexander | North Carolina | 37003 | 751 | 9 |
653018 | 653018 | 2020-10-21 | Alexander | North Carolina | 37003 | 741 | 9 |
649773 | 649773 | 2020-10-20 | Alexander | North Carolina | 37003 | 730 | 9 |
646529 | 646529 | 2020-10-19 | Alexander | North Carolina | 37003 | 706 | 9 |
643283 | 643283 | 2020-10-18 | Alexander | North Carolina | 37003 | 698 | 9 |
640035 | 640035 | 2020-10-17 | Alexander | North Carolina | 37003 | 671 | 9 |
636789 | 636789 | 2020-10-16 | Alexander | North Carolina | 37003 | 653 | 9 |
633543 | 633543 | 2020-10-15 | Alexander | North Carolina | 37003 | 636 | 9 |
630298 | 630298 | 2020-10-14 | Alexander | North Carolina | 37003 | 623 | 8 |
627054 | 627054 | 2020-10-13 | Alexander | North Carolina | 37003 | 608 | 8 |
623812 | 623812 | 2020-10-12 | Alexander | North Carolina | 37003 | 593 | 8 |
620569 | 620569 | 2020-10-11 | Alexander | North Carolina | 37003 | 589 | 8 |
617327 | 617327 | 2020-10-10 | Alexander | North Carolina | 37003 | 585 | 8 |
614085 | 614085 | 2020-10-09 | Alexander | North Carolina | 37003 | 580 | 8 |
610844 | 610844 | 2020-10-08 | Alexander | North Carolina | 37003 | 575 | 8 |
607602 | 607602 | 2020-10-07 | Alexander | North Carolina | 37003 | 571 | 8 |
604359 | 604359 | 2020-10-06 | Alexander | North Carolina | 37003 | 559 | 8 |
601117 | 601117 | 2020-10-05 | Alexander | North Carolina | 37003 | 557 | 8 |
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);