ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Union" 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 |
---|---|---|---|---|---|---|---|
922430 | 922430 | 2021-01-12 | Union | North Carolina | 37179 | 15191 | 119 |
919185 | 919185 | 2021-01-11 | Union | North Carolina | 37179 | 15016 | 116 |
915940 | 915940 | 2021-01-10 | Union | North Carolina | 37179 | 14875 | 116 |
912695 | 912695 | 2021-01-09 | Union | North Carolina | 37179 | 14564 | 116 |
909450 | 909450 | 2021-01-08 | Union | North Carolina | 37179 | 14324 | 112 |
906205 | 906205 | 2021-01-07 | Union | North Carolina | 37179 | 14033 | 110 |
902959 | 902959 | 2021-01-06 | Union | North Carolina | 37179 | 13755 | 106 |
899714 | 899714 | 2021-01-05 | Union | North Carolina | 37179 | 13554 | 103 |
896469 | 896469 | 2021-01-04 | Union | North Carolina | 37179 | 13382 | 102 |
893223 | 893223 | 2021-01-03 | Union | North Carolina | 37179 | 13215 | 101 |
889977 | 889977 | 2021-01-02 | Union | North Carolina | 37179 | 13039 | 101 |
886730 | 886730 | 2021-01-01 | Union | North Carolina | 37179 | 12505 | 98 |
883485 | 883485 | 2020-12-31 | Union | North Carolina | 37179 | 12505 | 98 |
880240 | 880240 | 2020-12-30 | Union | North Carolina | 37179 | 12333 | 97 |
876995 | 876995 | 2020-12-29 | Union | North Carolina | 37179 | 12034 | 96 |
873750 | 873750 | 2020-12-28 | Union | North Carolina | 37179 | 11910 | 95 |
870505 | 870505 | 2020-12-27 | Union | North Carolina | 37179 | 11786 | 95 |
867260 | 867260 | 2020-12-26 | Union | North Carolina | 37179 | 11653 | 95 |
864015 | 864015 | 2020-12-25 | Union | North Carolina | 37179 | 11146 | 93 |
860770 | 860770 | 2020-12-24 | Union | North Carolina | 37179 | 11146 | 93 |
857525 | 857525 | 2020-12-23 | Union | North Carolina | 37179 | 11146 | 93 |
854280 | 854280 | 2020-12-22 | Union | North Carolina | 37179 | 10994 | 93 |
851035 | 851035 | 2020-12-21 | Union | North Carolina | 37179 | 10852 | 90 |
847790 | 847790 | 2020-12-20 | Union | North Carolina | 37179 | 10711 | 89 |
844545 | 844545 | 2020-12-19 | Union | North Carolina | 37179 | 10541 | 89 |
841299 | 841299 | 2020-12-18 | Union | North Carolina | 37179 | 10401 | 88 |
838054 | 838054 | 2020-12-17 | Union | North Carolina | 37179 | 10201 | 87 |
834808 | 834808 | 2020-12-16 | Union | North Carolina | 37179 | 10055 | 87 |
831562 | 831562 | 2020-12-15 | Union | North Carolina | 37179 | 9907 | 87 |
828315 | 828315 | 2020-12-14 | Union | North Carolina | 37179 | 9783 | 87 |
825069 | 825069 | 2020-12-13 | Union | North Carolina | 37179 | 9645 | 84 |
821822 | 821822 | 2020-12-12 | Union | North Carolina | 37179 | 9492 | 84 |
818576 | 818576 | 2020-12-11 | Union | North Carolina | 37179 | 9348 | 84 |
815330 | 815330 | 2020-12-10 | Union | North Carolina | 37179 | 9186 | 82 |
812085 | 812085 | 2020-12-09 | Union | North Carolina | 37179 | 9130 | 82 |
808840 | 808840 | 2020-12-08 | Union | North Carolina | 37179 | 8867 | 79 |
805595 | 805595 | 2020-12-07 | Union | North Carolina | 37179 | 8749 | 79 |
802350 | 802350 | 2020-12-06 | Union | North Carolina | 37179 | 8656 | 76 |
799105 | 799105 | 2020-12-05 | Union | North Carolina | 37179 | 8498 | 76 |
795860 | 795860 | 2020-12-04 | Union | North Carolina | 37179 | 8481 | 76 |
792615 | 792615 | 2020-12-03 | Union | North Carolina | 37179 | 8238 | 76 |
789370 | 789370 | 2020-12-02 | Union | North Carolina | 37179 | 8238 | 76 |
786125 | 786125 | 2020-12-01 | Union | North Carolina | 37179 | 7989 | 76 |
782881 | 782881 | 2020-11-30 | Union | North Carolina | 37179 | 7989 | 76 |
779635 | 779635 | 2020-11-29 | Union | North Carolina | 37179 | 7802 | 73 |
776390 | 776390 | 2020-11-28 | Union | North Carolina | 37179 | 7707 | 73 |
773145 | 773145 | 2020-11-27 | Union | North Carolina | 37179 | 7622 | 73 |
769900 | 769900 | 2020-11-26 | Union | North Carolina | 37179 | 7554 | 72 |
766654 | 766654 | 2020-11-25 | Union | North Carolina | 37179 | 7554 | 72 |
763409 | 763409 | 2020-11-24 | Union | North Carolina | 37179 | 7387 | 73 |
760164 | 760164 | 2020-11-23 | Union | North Carolina | 37179 | 7363 | 72 |
756918 | 756918 | 2020-11-22 | Union | North Carolina | 37179 | 7255 | 72 |
753671 | 753671 | 2020-11-21 | Union | North Carolina | 37179 | 7181 | 72 |
750425 | 750425 | 2020-11-20 | Union | North Carolina | 37179 | 7178 | 71 |
747179 | 747179 | 2020-11-19 | Union | North Carolina | 37179 | 7070 | 70 |
743933 | 743933 | 2020-11-18 | Union | North Carolina | 37179 | 7070 | 70 |
740686 | 740686 | 2020-11-17 | Union | North Carolina | 37179 | 6906 | 68 |
737441 | 737441 | 2020-11-16 | Union | North Carolina | 37179 | 6888 | 68 |
734197 | 734197 | 2020-11-15 | Union | North Carolina | 37179 | 6818 | 67 |
730951 | 730951 | 2020-11-14 | Union | North Carolina | 37179 | 6739 | 67 |
727707 | 727707 | 2020-11-13 | Union | North Carolina | 37179 | 6709 | 67 |
724463 | 724463 | 2020-11-12 | Union | North Carolina | 37179 | 6625 | 67 |
721220 | 721220 | 2020-11-11 | Union | North Carolina | 37179 | 6596 | 66 |
717977 | 717977 | 2020-11-10 | Union | North Carolina | 37179 | 6513 | 66 |
714734 | 714734 | 2020-11-09 | Union | North Carolina | 37179 | 6437 | 66 |
711490 | 711490 | 2020-11-08 | Union | North Carolina | 37179 | 6388 | 66 |
708246 | 708246 | 2020-11-07 | Union | North Carolina | 37179 | 6365 | 66 |
705003 | 705003 | 2020-11-06 | Union | North Carolina | 37179 | 6339 | 66 |
701760 | 701760 | 2020-11-05 | Union | North Carolina | 37179 | 6273 | 66 |
698516 | 698516 | 2020-11-04 | Union | North Carolina | 37179 | 6244 | 66 |
695273 | 695273 | 2020-11-03 | Union | North Carolina | 37179 | 6163 | 65 |
692031 | 692031 | 2020-11-02 | Union | North Carolina | 37179 | 6119 | 65 |
688787 | 688787 | 2020-11-01 | Union | North Carolina | 37179 | 6073 | 65 |
685542 | 685542 | 2020-10-31 | Union | North Carolina | 37179 | 6027 | 65 |
682299 | 682299 | 2020-10-30 | Union | North Carolina | 37179 | 5987 | 65 |
679056 | 679056 | 2020-10-29 | Union | North Carolina | 37179 | 5940 | 65 |
675813 | 675813 | 2020-10-28 | Union | North Carolina | 37179 | 5914 | 65 |
672570 | 672570 | 2020-10-27 | Union | North Carolina | 37179 | 5883 | 64 |
669328 | 669328 | 2020-10-26 | Union | North Carolina | 37179 | 5856 | 64 |
666084 | 666084 | 2020-10-25 | Union | North Carolina | 37179 | 5820 | 62 |
662839 | 662839 | 2020-10-24 | Union | North Carolina | 37179 | 5794 | 62 |
659595 | 659595 | 2020-10-23 | Union | North Carolina | 37179 | 5765 | 62 |
656351 | 656351 | 2020-10-22 | Union | North Carolina | 37179 | 5725 | 62 |
653106 | 653106 | 2020-10-21 | Union | North Carolina | 37179 | 5700 | 62 |
649861 | 649861 | 2020-10-20 | Union | North Carolina | 37179 | 5654 | 62 |
646617 | 646617 | 2020-10-19 | Union | North Carolina | 37179 | 5616 | 62 |
643371 | 643371 | 2020-10-18 | Union | North Carolina | 37179 | 5586 | 62 |
640123 | 640123 | 2020-10-17 | Union | North Carolina | 37179 | 5556 | 62 |
636877 | 636877 | 2020-10-16 | Union | North Carolina | 37179 | 5526 | 62 |
633631 | 633631 | 2020-10-15 | Union | North Carolina | 37179 | 5487 | 61 |
630386 | 630386 | 2020-10-14 | Union | North Carolina | 37179 | 5441 | 61 |
627142 | 627142 | 2020-10-13 | Union | North Carolina | 37179 | 5405 | 61 |
623900 | 623900 | 2020-10-12 | Union | North Carolina | 37179 | 5364 | 61 |
620657 | 620657 | 2020-10-11 | Union | North Carolina | 37179 | 5347 | 60 |
617415 | 617415 | 2020-10-10 | Union | North Carolina | 37179 | 5324 | 60 |
614173 | 614173 | 2020-10-09 | Union | North Carolina | 37179 | 5277 | 60 |
610932 | 610932 | 2020-10-08 | Union | North Carolina | 37179 | 5232 | 59 |
607690 | 607690 | 2020-10-07 | Union | North Carolina | 37179 | 5200 | 59 |
604447 | 604447 | 2020-10-06 | Union | North Carolina | 37179 | 5141 | 59 |
601205 | 601205 | 2020-10-05 | Union | North Carolina | 37179 | 5108 | 59 |
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);