ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 37195 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 |
---|---|---|---|---|---|---|---|
922438 | 922438 | 2021-01-12 | Wilson | North Carolina | 37195 | 6435 | 119 |
919193 | 919193 | 2021-01-11 | Wilson | North Carolina | 37195 | 6357 | 119 |
915948 | 915948 | 2021-01-10 | Wilson | North Carolina | 37195 | 6317 | 119 |
912703 | 912703 | 2021-01-09 | Wilson | North Carolina | 37195 | 6217 | 118 |
909458 | 909458 | 2021-01-08 | Wilson | North Carolina | 37195 | 6138 | 113 |
906213 | 906213 | 2021-01-07 | Wilson | North Carolina | 37195 | 6034 | 113 |
902967 | 902967 | 2021-01-06 | Wilson | North Carolina | 37195 | 5920 | 109 |
899722 | 899722 | 2021-01-05 | Wilson | North Carolina | 37195 | 5848 | 109 |
896477 | 896477 | 2021-01-04 | Wilson | North Carolina | 37195 | 5778 | 109 |
893231 | 893231 | 2021-01-03 | Wilson | North Carolina | 37195 | 5732 | 108 |
889985 | 889985 | 2021-01-02 | Wilson | North Carolina | 37195 | 5658 | 104 |
886738 | 886738 | 2021-01-01 | Wilson | North Carolina | 37195 | 5516 | 103 |
883493 | 883493 | 2020-12-31 | Wilson | North Carolina | 37195 | 5516 | 103 |
880248 | 880248 | 2020-12-30 | Wilson | North Carolina | 37195 | 5454 | 103 |
877003 | 877003 | 2020-12-29 | Wilson | North Carolina | 37195 | 5384 | 103 |
873758 | 873758 | 2020-12-28 | Wilson | North Carolina | 37195 | 5365 | 103 |
870513 | 870513 | 2020-12-27 | Wilson | North Carolina | 37195 | 5342 | 103 |
867268 | 867268 | 2020-12-26 | Wilson | North Carolina | 37195 | 5336 | 103 |
864023 | 864023 | 2020-12-25 | Wilson | North Carolina | 37195 | 5162 | 103 |
860778 | 860778 | 2020-12-24 | Wilson | North Carolina | 37195 | 5162 | 103 |
857533 | 857533 | 2020-12-23 | Wilson | North Carolina | 37195 | 5162 | 103 |
854288 | 854288 | 2020-12-22 | Wilson | North Carolina | 37195 | 5116 | 100 |
851043 | 851043 | 2020-12-21 | Wilson | North Carolina | 37195 | 5093 | 100 |
847798 | 847798 | 2020-12-20 | Wilson | North Carolina | 37195 | 5055 | 100 |
844553 | 844553 | 2020-12-19 | Wilson | North Carolina | 37195 | 4975 | 97 |
841307 | 841307 | 2020-12-18 | Wilson | North Carolina | 37195 | 4938 | 94 |
838062 | 838062 | 2020-12-17 | Wilson | North Carolina | 37195 | 4851 | 94 |
834816 | 834816 | 2020-12-16 | Wilson | North Carolina | 37195 | 4819 | 89 |
831570 | 831570 | 2020-12-15 | Wilson | North Carolina | 37195 | 4787 | 89 |
828323 | 828323 | 2020-12-14 | Wilson | North Carolina | 37195 | 4747 | 89 |
825077 | 825077 | 2020-12-13 | Wilson | North Carolina | 37195 | 4707 | 89 |
821830 | 821830 | 2020-12-12 | Wilson | North Carolina | 37195 | 4627 | 89 |
818584 | 818584 | 2020-12-11 | Wilson | North Carolina | 37195 | 4576 | 89 |
815338 | 815338 | 2020-12-10 | Wilson | North Carolina | 37195 | 4534 | 89 |
812093 | 812093 | 2020-12-09 | Wilson | North Carolina | 37195 | 4465 | 86 |
808848 | 808848 | 2020-12-08 | Wilson | North Carolina | 37195 | 4417 | 86 |
805603 | 805603 | 2020-12-07 | Wilson | North Carolina | 37195 | 4370 | 85 |
802358 | 802358 | 2020-12-06 | Wilson | North Carolina | 37195 | 4348 | 85 |
799113 | 799113 | 2020-12-05 | Wilson | North Carolina | 37195 | 4289 | 85 |
795868 | 795868 | 2020-12-04 | Wilson | North Carolina | 37195 | 4242 | 82 |
792623 | 792623 | 2020-12-03 | Wilson | North Carolina | 37195 | 4191 | 82 |
789378 | 789378 | 2020-12-02 | Wilson | North Carolina | 37195 | 4119 | 82 |
786133 | 786133 | 2020-12-01 | Wilson | North Carolina | 37195 | 4111 | 81 |
782889 | 782889 | 2020-11-30 | Wilson | North Carolina | 37195 | 4078 | 81 |
779643 | 779643 | 2020-11-29 | Wilson | North Carolina | 37195 | 4041 | 81 |
776398 | 776398 | 2020-11-28 | Wilson | North Carolina | 37195 | 4004 | 77 |
773153 | 773153 | 2020-11-27 | Wilson | North Carolina | 37195 | 3976 | 77 |
769908 | 769908 | 2020-11-26 | Wilson | North Carolina | 37195 | 3891 | 77 |
766662 | 766662 | 2020-11-25 | Wilson | North Carolina | 37195 | 3891 | 77 |
763417 | 763417 | 2020-11-24 | Wilson | North Carolina | 37195 | 3859 | 77 |
760172 | 760172 | 2020-11-23 | Wilson | North Carolina | 37195 | 3822 | 76 |
756926 | 756926 | 2020-11-22 | Wilson | North Carolina | 37195 | 3796 | 76 |
753679 | 753679 | 2020-11-21 | Wilson | North Carolina | 37195 | 3748 | 76 |
750433 | 750433 | 2020-11-20 | Wilson | North Carolina | 37195 | 3709 | 74 |
747187 | 747187 | 2020-11-19 | Wilson | North Carolina | 37195 | 3665 | 74 |
743941 | 743941 | 2020-11-18 | Wilson | North Carolina | 37195 | 3633 | 74 |
740694 | 740694 | 2020-11-17 | Wilson | North Carolina | 37195 | 3599 | 72 |
737449 | 737449 | 2020-11-16 | Wilson | North Carolina | 37195 | 3576 | 72 |
734205 | 734205 | 2020-11-15 | Wilson | North Carolina | 37195 | 3554 | 72 |
730959 | 730959 | 2020-11-14 | Wilson | North Carolina | 37195 | 3519 | 72 |
727715 | 727715 | 2020-11-13 | Wilson | North Carolina | 37195 | 3492 | 72 |
724471 | 724471 | 2020-11-12 | Wilson | North Carolina | 37195 | 3479 | 72 |
721228 | 721228 | 2020-11-11 | Wilson | North Carolina | 37195 | 3446 | 72 |
717985 | 717985 | 2020-11-10 | Wilson | North Carolina | 37195 | 3411 | 70 |
714742 | 714742 | 2020-11-09 | Wilson | North Carolina | 37195 | 3396 | 70 |
711498 | 711498 | 2020-11-08 | Wilson | North Carolina | 37195 | 3383 | 70 |
708254 | 708254 | 2020-11-07 | Wilson | North Carolina | 37195 | 3363 | 70 |
705011 | 705011 | 2020-11-06 | Wilson | North Carolina | 37195 | 3332 | 70 |
701768 | 701768 | 2020-11-05 | Wilson | North Carolina | 37195 | 3290 | 69 |
698524 | 698524 | 2020-11-04 | Wilson | North Carolina | 37195 | 3248 | 69 |
695281 | 695281 | 2020-11-03 | Wilson | North Carolina | 37195 | 3210 | 64 |
692039 | 692039 | 2020-11-02 | Wilson | North Carolina | 37195 | 3178 | 64 |
688795 | 688795 | 2020-11-01 | Wilson | North Carolina | 37195 | 3173 | 64 |
685550 | 685550 | 2020-10-31 | Wilson | North Carolina | 37195 | 3144 | 64 |
682307 | 682307 | 2020-10-30 | Wilson | North Carolina | 37195 | 3096 | 64 |
679064 | 679064 | 2020-10-29 | Wilson | North Carolina | 37195 | 3056 | 64 |
675821 | 675821 | 2020-10-28 | Wilson | North Carolina | 37195 | 2994 | 64 |
672578 | 672578 | 2020-10-27 | Wilson | North Carolina | 37195 | 2964 | 63 |
669336 | 669336 | 2020-10-26 | Wilson | North Carolina | 37195 | 2937 | 63 |
666092 | 666092 | 2020-10-25 | Wilson | North Carolina | 37195 | 2908 | 63 |
662847 | 662847 | 2020-10-24 | Wilson | North Carolina | 37195 | 2891 | 63 |
659603 | 659603 | 2020-10-23 | Wilson | North Carolina | 37195 | 2828 | 62 |
656359 | 656359 | 2020-10-22 | Wilson | North Carolina | 37195 | 2797 | 62 |
653114 | 653114 | 2020-10-21 | Wilson | North Carolina | 37195 | 2757 | 62 |
649869 | 649869 | 2020-10-20 | Wilson | North Carolina | 37195 | 2737 | 62 |
646625 | 646625 | 2020-10-19 | Wilson | North Carolina | 37195 | 2719 | 62 |
643379 | 643379 | 2020-10-18 | Wilson | North Carolina | 37195 | 2699 | 62 |
640131 | 640131 | 2020-10-17 | Wilson | North Carolina | 37195 | 2670 | 62 |
636885 | 636885 | 2020-10-16 | Wilson | North Carolina | 37195 | 2640 | 62 |
633639 | 633639 | 2020-10-15 | Wilson | North Carolina | 37195 | 2585 | 62 |
630394 | 630394 | 2020-10-14 | Wilson | North Carolina | 37195 | 2554 | 61 |
627150 | 627150 | 2020-10-13 | Wilson | North Carolina | 37195 | 2535 | 61 |
623908 | 623908 | 2020-10-12 | Wilson | North Carolina | 37195 | 2511 | 58 |
620665 | 620665 | 2020-10-11 | Wilson | North Carolina | 37195 | 2490 | 58 |
617423 | 617423 | 2020-10-10 | Wilson | North Carolina | 37195 | 2473 | 58 |
614181 | 614181 | 2020-10-09 | Wilson | North Carolina | 37195 | 2452 | 58 |
610940 | 610940 | 2020-10-08 | Wilson | North Carolina | 37195 | 2433 | 58 |
607698 | 607698 | 2020-10-07 | Wilson | North Carolina | 37195 | 2402 | 57 |
604455 | 604455 | 2020-10-06 | Wilson | North Carolina | 37195 | 2389 | 57 |
601213 | 601213 | 2020-10-05 | Wilson | North Carolina | 37195 | 2374 | 57 |
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);