ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37167 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 |
---|---|---|---|---|---|---|---|
954878 | 954878 | 2021-01-22 | Stanly | North Carolina | 37167 | 5668 | 92 |
951633 | 951633 | 2021-01-21 | Stanly | North Carolina | 37167 | 5602 | 92 |
948388 | 948388 | 2021-01-20 | Stanly | North Carolina | 37167 | 5562 | 92 |
945141 | 945141 | 2021-01-19 | Stanly | North Carolina | 37167 | 5470 | 92 |
941895 | 941895 | 2021-01-18 | Stanly | North Carolina | 37167 | 5406 | 92 |
938650 | 938650 | 2021-01-17 | Stanly | North Carolina | 37167 | 5406 | 92 |
935405 | 935405 | 2021-01-16 | Stanly | North Carolina | 37167 | 5373 | 92 |
932160 | 932160 | 2021-01-15 | Stanly | North Carolina | 37167 | 5295 | 92 |
928915 | 928915 | 2021-01-14 | Stanly | North Carolina | 37167 | 5226 | 92 |
925670 | 925670 | 2021-01-13 | Stanly | North Carolina | 37167 | 5147 | 92 |
922424 | 922424 | 2021-01-12 | Stanly | North Carolina | 37167 | 5114 | 92 |
919179 | 919179 | 2021-01-11 | Stanly | North Carolina | 37167 | 5078 | 92 |
915934 | 915934 | 2021-01-10 | Stanly | North Carolina | 37167 | 5029 | 92 |
912689 | 912689 | 2021-01-09 | Stanly | North Carolina | 37167 | 4937 | 92 |
909444 | 909444 | 2021-01-08 | Stanly | North Carolina | 37167 | 4850 | 92 |
906199 | 906199 | 2021-01-07 | Stanly | North Carolina | 37167 | 4777 | 84 |
902953 | 902953 | 2021-01-06 | Stanly | North Carolina | 37167 | 4696 | 78 |
899708 | 899708 | 2021-01-05 | Stanly | North Carolina | 37167 | 4647 | 78 |
896463 | 896463 | 2021-01-04 | Stanly | North Carolina | 37167 | 4607 | 78 |
893217 | 893217 | 2021-01-03 | Stanly | North Carolina | 37167 | 4529 | 78 |
889971 | 889971 | 2021-01-02 | Stanly | North Carolina | 37167 | 4460 | 78 |
886724 | 886724 | 2021-01-01 | Stanly | North Carolina | 37167 | 4331 | 78 |
883479 | 883479 | 2020-12-31 | Stanly | North Carolina | 37167 | 4331 | 78 |
880234 | 880234 | 2020-12-30 | Stanly | North Carolina | 37167 | 4287 | 78 |
876989 | 876989 | 2020-12-29 | Stanly | North Carolina | 37167 | 4190 | 78 |
873744 | 873744 | 2020-12-28 | Stanly | North Carolina | 37167 | 4161 | 78 |
870499 | 870499 | 2020-12-27 | Stanly | North Carolina | 37167 | 4135 | 78 |
867254 | 867254 | 2020-12-26 | Stanly | North Carolina | 37167 | 4117 | 78 |
864009 | 864009 | 2020-12-25 | Stanly | North Carolina | 37167 | 3954 | 78 |
860764 | 860764 | 2020-12-24 | Stanly | North Carolina | 37167 | 3954 | 78 |
857519 | 857519 | 2020-12-23 | Stanly | North Carolina | 37167 | 3954 | 78 |
854274 | 854274 | 2020-12-22 | Stanly | North Carolina | 37167 | 3896 | 78 |
851029 | 851029 | 2020-12-21 | Stanly | North Carolina | 37167 | 3858 | 78 |
847784 | 847784 | 2020-12-20 | Stanly | North Carolina | 37167 | 3819 | 78 |
844539 | 844539 | 2020-12-19 | Stanly | North Carolina | 37167 | 3783 | 78 |
841293 | 841293 | 2020-12-18 | Stanly | North Carolina | 37167 | 3738 | 78 |
838048 | 838048 | 2020-12-17 | Stanly | North Carolina | 37167 | 3689 | 78 |
834802 | 834802 | 2020-12-16 | Stanly | North Carolina | 37167 | 3635 | 78 |
831556 | 831556 | 2020-12-15 | Stanly | North Carolina | 37167 | 3590 | 78 |
828309 | 828309 | 2020-12-14 | Stanly | North Carolina | 37167 | 3566 | 78 |
825063 | 825063 | 2020-12-13 | Stanly | North Carolina | 37167 | 3520 | 78 |
821816 | 821816 | 2020-12-12 | Stanly | North Carolina | 37167 | 3470 | 78 |
818570 | 818570 | 2020-12-11 | Stanly | North Carolina | 37167 | 3436 | 78 |
815324 | 815324 | 2020-12-10 | Stanly | North Carolina | 37167 | 3371 | 78 |
812079 | 812079 | 2020-12-09 | Stanly | North Carolina | 37167 | 3348 | 78 |
808834 | 808834 | 2020-12-08 | Stanly | North Carolina | 37167 | 3279 | 78 |
805589 | 805589 | 2020-12-07 | Stanly | North Carolina | 37167 | 3241 | 78 |
802344 | 802344 | 2020-12-06 | Stanly | North Carolina | 37167 | 3213 | 78 |
799099 | 799099 | 2020-12-05 | Stanly | North Carolina | 37167 | 3162 | 78 |
795854 | 795854 | 2020-12-04 | Stanly | North Carolina | 37167 | 3128 | 78 |
792609 | 792609 | 2020-12-03 | Stanly | North Carolina | 37167 | 3104 | 78 |
789364 | 789364 | 2020-12-02 | Stanly | North Carolina | 37167 | 3046 | 78 |
786119 | 786119 | 2020-12-01 | Stanly | North Carolina | 37167 | 3013 | 78 |
782875 | 782875 | 2020-11-30 | Stanly | North Carolina | 37167 | 2992 | 78 |
779629 | 779629 | 2020-11-29 | Stanly | North Carolina | 37167 | 2968 | 78 |
776384 | 776384 | 2020-11-28 | Stanly | North Carolina | 37167 | 2945 | 78 |
773139 | 773139 | 2020-11-27 | Stanly | North Carolina | 37167 | 2921 | 78 |
769894 | 769894 | 2020-11-26 | Stanly | North Carolina | 37167 | 2879 | 78 |
766648 | 766648 | 2020-11-25 | Stanly | North Carolina | 37167 | 2879 | 78 |
763403 | 763403 | 2020-11-24 | Stanly | North Carolina | 37167 | 2857 | 78 |
760158 | 760158 | 2020-11-23 | Stanly | North Carolina | 37167 | 2832 | 78 |
756912 | 756912 | 2020-11-22 | Stanly | North Carolina | 37167 | 2816 | 78 |
753665 | 753665 | 2020-11-21 | Stanly | North Carolina | 37167 | 2776 | 78 |
750419 | 750419 | 2020-11-20 | Stanly | North Carolina | 37167 | 2764 | 78 |
747173 | 747173 | 2020-11-19 | Stanly | North Carolina | 37167 | 2754 | 78 |
743927 | 743927 | 2020-11-18 | Stanly | North Carolina | 37167 | 2734 | 78 |
740680 | 740680 | 2020-11-17 | Stanly | North Carolina | 37167 | 2715 | 78 |
737435 | 737435 | 2020-11-16 | Stanly | North Carolina | 37167 | 2687 | 78 |
734191 | 734191 | 2020-11-15 | Stanly | North Carolina | 37167 | 2682 | 78 |
730945 | 730945 | 2020-11-14 | Stanly | North Carolina | 37167 | 2662 | 78 |
727701 | 727701 | 2020-11-13 | Stanly | North Carolina | 37167 | 2631 | 74 |
724457 | 724457 | 2020-11-12 | Stanly | North Carolina | 37167 | 2614 | 74 |
721214 | 721214 | 2020-11-11 | Stanly | North Carolina | 37167 | 2598 | 74 |
717971 | 717971 | 2020-11-10 | Stanly | North Carolina | 37167 | 2576 | 74 |
714728 | 714728 | 2020-11-09 | Stanly | North Carolina | 37167 | 2560 | 74 |
711484 | 711484 | 2020-11-08 | Stanly | North Carolina | 37167 | 2554 | 74 |
708240 | 708240 | 2020-11-07 | Stanly | North Carolina | 37167 | 2551 | 74 |
704997 | 704997 | 2020-11-06 | Stanly | North Carolina | 37167 | 2533 | 74 |
701754 | 701754 | 2020-11-05 | Stanly | North Carolina | 37167 | 2523 | 74 |
698510 | 698510 | 2020-11-04 | Stanly | North Carolina | 37167 | 2499 | 74 |
695267 | 695267 | 2020-11-03 | Stanly | North Carolina | 37167 | 2488 | 74 |
692025 | 692025 | 2020-11-02 | Stanly | North Carolina | 37167 | 2482 | 73 |
688781 | 688781 | 2020-11-01 | Stanly | North Carolina | 37167 | 2468 | 73 |
685536 | 685536 | 2020-10-31 | Stanly | North Carolina | 37167 | 2455 | 73 |
682293 | 682293 | 2020-10-30 | Stanly | North Carolina | 37167 | 2447 | 73 |
679050 | 679050 | 2020-10-29 | Stanly | North Carolina | 37167 | 2446 | 63 |
675807 | 675807 | 2020-10-28 | Stanly | North Carolina | 37167 | 2438 | 62 |
672564 | 672564 | 2020-10-27 | Stanly | North Carolina | 37167 | 2431 | 60 |
669322 | 669322 | 2020-10-26 | Stanly | North Carolina | 37167 | 2414 | 60 |
666078 | 666078 | 2020-10-25 | Stanly | North Carolina | 37167 | 2403 | 60 |
662833 | 662833 | 2020-10-24 | Stanly | North Carolina | 37167 | 2396 | 60 |
659589 | 659589 | 2020-10-23 | Stanly | North Carolina | 37167 | 2386 | 60 |
656345 | 656345 | 2020-10-22 | Stanly | North Carolina | 37167 | 2377 | 60 |
653100 | 653100 | 2020-10-21 | Stanly | North Carolina | 37167 | 2374 | 57 |
649855 | 649855 | 2020-10-20 | Stanly | North Carolina | 37167 | 2370 | 57 |
646611 | 646611 | 2020-10-19 | Stanly | North Carolina | 37167 | 2370 | 57 |
643365 | 643365 | 2020-10-18 | Stanly | North Carolina | 37167 | 2358 | 57 |
640117 | 640117 | 2020-10-17 | Stanly | North Carolina | 37167 | 2341 | 57 |
636871 | 636871 | 2020-10-16 | Stanly | North Carolina | 37167 | 2328 | 57 |
633625 | 633625 | 2020-10-15 | Stanly | North Carolina | 37167 | 2312 | 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);