ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 37111 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 |
---|---|---|---|---|---|---|---|
922399 | 922399 | 2021-01-12 | McDowell | North Carolina | 37111 | 3719 | 39 |
919154 | 919154 | 2021-01-11 | McDowell | North Carolina | 37111 | 3691 | 39 |
915909 | 915909 | 2021-01-10 | McDowell | North Carolina | 37111 | 3612 | 39 |
912664 | 912664 | 2021-01-09 | McDowell | North Carolina | 37111 | 3574 | 39 |
909419 | 909419 | 2021-01-08 | McDowell | North Carolina | 37111 | 3538 | 39 |
906174 | 906174 | 2021-01-07 | McDowell | North Carolina | 37111 | 3435 | 39 |
902928 | 902928 | 2021-01-06 | McDowell | North Carolina | 37111 | 3401 | 39 |
899683 | 899683 | 2021-01-05 | McDowell | North Carolina | 37111 | 3361 | 39 |
896438 | 896438 | 2021-01-04 | McDowell | North Carolina | 37111 | 3341 | 39 |
893192 | 893192 | 2021-01-03 | McDowell | North Carolina | 37111 | 3252 | 39 |
889946 | 889946 | 2021-01-02 | McDowell | North Carolina | 37111 | 3227 | 39 |
886699 | 886699 | 2021-01-01 | McDowell | North Carolina | 37111 | 3066 | 38 |
883454 | 883454 | 2020-12-31 | McDowell | North Carolina | 37111 | 3066 | 38 |
880209 | 880209 | 2020-12-30 | McDowell | North Carolina | 37111 | 3054 | 38 |
876964 | 876964 | 2020-12-29 | McDowell | North Carolina | 37111 | 3003 | 38 |
873719 | 873719 | 2020-12-28 | McDowell | North Carolina | 37111 | 2981 | 38 |
870474 | 870474 | 2020-12-27 | McDowell | North Carolina | 37111 | 2963 | 38 |
867229 | 867229 | 2020-12-26 | McDowell | North Carolina | 37111 | 2954 | 38 |
863984 | 863984 | 2020-12-25 | McDowell | North Carolina | 37111 | 2804 | 38 |
860739 | 860739 | 2020-12-24 | McDowell | North Carolina | 37111 | 2804 | 38 |
857494 | 857494 | 2020-12-23 | McDowell | North Carolina | 37111 | 2804 | 38 |
854249 | 854249 | 2020-12-22 | McDowell | North Carolina | 37111 | 2780 | 38 |
851004 | 851004 | 2020-12-21 | McDowell | North Carolina | 37111 | 2715 | 38 |
847759 | 847759 | 2020-12-20 | McDowell | North Carolina | 37111 | 2669 | 38 |
844514 | 844514 | 2020-12-19 | McDowell | North Carolina | 37111 | 2636 | 38 |
841268 | 841268 | 2020-12-18 | McDowell | North Carolina | 37111 | 2624 | 38 |
838023 | 838023 | 2020-12-17 | McDowell | North Carolina | 37111 | 2551 | 38 |
834777 | 834777 | 2020-12-16 | McDowell | North Carolina | 37111 | 2525 | 37 |
831531 | 831531 | 2020-12-15 | McDowell | North Carolina | 37111 | 2505 | 37 |
828284 | 828284 | 2020-12-14 | McDowell | North Carolina | 37111 | 2473 | 37 |
825038 | 825038 | 2020-12-13 | McDowell | North Carolina | 37111 | 2398 | 36 |
821791 | 821791 | 2020-12-12 | McDowell | North Carolina | 37111 | 2369 | 36 |
818545 | 818545 | 2020-12-11 | McDowell | North Carolina | 37111 | 2324 | 36 |
815299 | 815299 | 2020-12-10 | McDowell | North Carolina | 37111 | 2264 | 36 |
812054 | 812054 | 2020-12-09 | McDowell | North Carolina | 37111 | 2235 | 36 |
808809 | 808809 | 2020-12-08 | McDowell | North Carolina | 37111 | 2164 | 35 |
805564 | 805564 | 2020-12-07 | McDowell | North Carolina | 37111 | 2125 | 35 |
802319 | 802319 | 2020-12-06 | McDowell | North Carolina | 37111 | 2100 | 35 |
799074 | 799074 | 2020-12-05 | McDowell | North Carolina | 37111 | 2050 | 34 |
795829 | 795829 | 2020-12-04 | McDowell | North Carolina | 37111 | 2004 | 34 |
792584 | 792584 | 2020-12-03 | McDowell | North Carolina | 37111 | 1958 | 34 |
789339 | 789339 | 2020-12-02 | McDowell | North Carolina | 37111 | 1935 | 34 |
786094 | 786094 | 2020-12-01 | McDowell | North Carolina | 37111 | 1906 | 34 |
782850 | 782850 | 2020-11-30 | McDowell | North Carolina | 37111 | 1884 | 34 |
779604 | 779604 | 2020-11-29 | McDowell | North Carolina | 37111 | 1860 | 34 |
776359 | 776359 | 2020-11-28 | McDowell | North Carolina | 37111 | 1843 | 34 |
773114 | 773114 | 2020-11-27 | McDowell | North Carolina | 37111 | 1836 | 34 |
769869 | 769869 | 2020-11-26 | McDowell | North Carolina | 37111 | 1774 | 34 |
766623 | 766623 | 2020-11-25 | McDowell | North Carolina | 37111 | 1774 | 34 |
763378 | 763378 | 2020-11-24 | McDowell | North Carolina | 37111 | 1736 | 34 |
760133 | 760133 | 2020-11-23 | McDowell | North Carolina | 37111 | 1725 | 34 |
756887 | 756887 | 2020-11-22 | McDowell | North Carolina | 37111 | 1698 | 34 |
753640 | 753640 | 2020-11-21 | McDowell | North Carolina | 37111 | 1677 | 34 |
750394 | 750394 | 2020-11-20 | McDowell | North Carolina | 37111 | 1647 | 34 |
747148 | 747148 | 2020-11-19 | McDowell | North Carolina | 37111 | 1627 | 34 |
743902 | 743902 | 2020-11-18 | McDowell | North Carolina | 37111 | 1624 | 34 |
740655 | 740655 | 2020-11-17 | McDowell | North Carolina | 37111 | 1595 | 34 |
737410 | 737410 | 2020-11-16 | McDowell | North Carolina | 37111 | 1577 | 34 |
734166 | 734166 | 2020-11-15 | McDowell | North Carolina | 37111 | 1571 | 34 |
730920 | 730920 | 2020-11-14 | McDowell | North Carolina | 37111 | 1562 | 34 |
727676 | 727676 | 2020-11-13 | McDowell | North Carolina | 37111 | 1533 | 34 |
724432 | 724432 | 2020-11-12 | McDowell | North Carolina | 37111 | 1527 | 34 |
721189 | 721189 | 2020-11-11 | McDowell | North Carolina | 37111 | 1505 | 34 |
717946 | 717946 | 2020-11-10 | McDowell | North Carolina | 37111 | 1488 | 34 |
714703 | 714703 | 2020-11-09 | McDowell | North Carolina | 37111 | 1471 | 34 |
711459 | 711459 | 2020-11-08 | McDowell | North Carolina | 37111 | 1470 | 34 |
708215 | 708215 | 2020-11-07 | McDowell | North Carolina | 37111 | 1452 | 34 |
704972 | 704972 | 2020-11-06 | McDowell | North Carolina | 37111 | 1440 | 34 |
701729 | 701729 | 2020-11-05 | McDowell | North Carolina | 37111 | 1428 | 34 |
698485 | 698485 | 2020-11-04 | McDowell | North Carolina | 37111 | 1407 | 34 |
695242 | 695242 | 2020-11-03 | McDowell | North Carolina | 37111 | 1392 | 33 |
692000 | 692000 | 2020-11-02 | McDowell | North Carolina | 37111 | 1385 | 32 |
688756 | 688756 | 2020-11-01 | McDowell | North Carolina | 37111 | 1379 | 32 |
685511 | 685511 | 2020-10-31 | McDowell | North Carolina | 37111 | 1364 | 32 |
682268 | 682268 | 2020-10-30 | McDowell | North Carolina | 37111 | 1353 | 32 |
679025 | 679025 | 2020-10-29 | McDowell | North Carolina | 37111 | 1340 | 32 |
675782 | 675782 | 2020-10-28 | McDowell | North Carolina | 37111 | 1322 | 32 |
672539 | 672539 | 2020-10-27 | McDowell | North Carolina | 37111 | 1313 | 32 |
669297 | 669297 | 2020-10-26 | McDowell | North Carolina | 37111 | 1304 | 32 |
666053 | 666053 | 2020-10-25 | McDowell | North Carolina | 37111 | 1298 | 32 |
662808 | 662808 | 2020-10-24 | McDowell | North Carolina | 37111 | 1286 | 32 |
659564 | 659564 | 2020-10-23 | McDowell | North Carolina | 37111 | 1272 | 32 |
656320 | 656320 | 2020-10-22 | McDowell | North Carolina | 37111 | 1256 | 32 |
653075 | 653075 | 2020-10-21 | McDowell | North Carolina | 37111 | 1238 | 31 |
649830 | 649830 | 2020-10-20 | McDowell | North Carolina | 37111 | 1229 | 31 |
646586 | 646586 | 2020-10-19 | McDowell | North Carolina | 37111 | 1215 | 31 |
643340 | 643340 | 2020-10-18 | McDowell | North Carolina | 37111 | 1207 | 31 |
640092 | 640092 | 2020-10-17 | McDowell | North Carolina | 37111 | 1199 | 31 |
636846 | 636846 | 2020-10-16 | McDowell | North Carolina | 37111 | 1195 | 32 |
633600 | 633600 | 2020-10-15 | McDowell | North Carolina | 37111 | 1177 | 31 |
630355 | 630355 | 2020-10-14 | McDowell | North Carolina | 37111 | 1168 | 31 |
627111 | 627111 | 2020-10-13 | McDowell | North Carolina | 37111 | 1155 | 30 |
623869 | 623869 | 2020-10-12 | McDowell | North Carolina | 37111 | 1136 | 30 |
620626 | 620626 | 2020-10-11 | McDowell | North Carolina | 37111 | 1129 | 30 |
617384 | 617384 | 2020-10-10 | McDowell | North Carolina | 37111 | 1123 | 30 |
614142 | 614142 | 2020-10-09 | McDowell | North Carolina | 37111 | 1114 | 30 |
610901 | 610901 | 2020-10-08 | McDowell | North Carolina | 37111 | 1106 | 29 |
607659 | 607659 | 2020-10-07 | McDowell | North Carolina | 37111 | 1092 | 29 |
604416 | 604416 | 2020-10-06 | McDowell | North Carolina | 37111 | 1085 | 27 |
601174 | 601174 | 2020-10-05 | McDowell | North Carolina | 37111 | 1080 | 27 |
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);