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 |
---|---|---|---|---|---|---|---|
1094439 | 1094439 | 2021-03-06 | Stanly | North Carolina | 37167 | 6917 | 111 |
1091193 | 1091193 | 2021-03-05 | Stanly | North Carolina | 37167 | 6904 | 111 |
1087948 | 1087948 | 2021-03-04 | Stanly | North Carolina | 37167 | 6888 | 111 |
1084703 | 1084703 | 2021-03-03 | Stanly | North Carolina | 37167 | 6868 | 111 |
1081457 | 1081457 | 2021-03-02 | Stanly | North Carolina | 37167 | 6849 | 111 |
1078211 | 1078211 | 2021-03-01 | Stanly | North Carolina | 37167 | 6832 | 111 |
1074966 | 1074966 | 2021-02-28 | Stanly | North Carolina | 37167 | 6795 | 111 |
1071720 | 1071720 | 2021-02-27 | Stanly | North Carolina | 37167 | 6795 | 111 |
1068474 | 1068474 | 2021-02-26 | Stanly | North Carolina | 37167 | 6782 | 111 |
1065229 | 1065229 | 2021-02-25 | Stanly | North Carolina | 37167 | 6759 | 111 |
1061985 | 1061985 | 2021-02-24 | Stanly | North Carolina | 37167 | 6719 | 111 |
1058739 | 1058739 | 2021-02-23 | Stanly | North Carolina | 37167 | 6686 | 111 |
1055493 | 1055493 | 2021-02-22 | Stanly | North Carolina | 37167 | 6668 | 111 |
1052247 | 1052247 | 2021-02-21 | Stanly | North Carolina | 37167 | 6652 | 111 |
1049000 | 1049000 | 2021-02-20 | Stanly | North Carolina | 37167 | 6613 | 111 |
1045753 | 1045753 | 2021-02-19 | Stanly | North Carolina | 37167 | 6568 | 105 |
1042508 | 1042508 | 2021-02-18 | Stanly | North Carolina | 37167 | 6534 | 105 |
1039263 | 1039263 | 2021-02-17 | Stanly | North Carolina | 37167 | 6500 | 104 |
1036018 | 1036018 | 2021-02-16 | Stanly | North Carolina | 37167 | 6472 | 104 |
1032773 | 1032773 | 2021-02-15 | Stanly | North Carolina | 37167 | 6452 | 103 |
1029527 | 1029527 | 2021-02-14 | Stanly | North Carolina | 37167 | 6424 | 103 |
1026280 | 1026280 | 2021-02-13 | Stanly | North Carolina | 37167 | 6401 | 103 |
1023035 | 1023035 | 2021-02-12 | Stanly | North Carolina | 37167 | 6375 | 103 |
1019790 | 1019790 | 2021-02-11 | Stanly | North Carolina | 37167 | 6347 | 103 |
1016545 | 1016545 | 2021-02-10 | Stanly | North Carolina | 37167 | 6310 | 103 |
1013300 | 1013300 | 2021-02-09 | Stanly | North Carolina | 37167 | 6287 | 103 |
1010055 | 1010055 | 2021-02-08 | Stanly | North Carolina | 37167 | 6265 | 103 |
1006809 | 1006809 | 2021-02-07 | Stanly | North Carolina | 37167 | 6237 | 103 |
1003563 | 1003563 | 2021-02-06 | Stanly | North Carolina | 37167 | 6207 | 102 |
1000317 | 1000317 | 2021-02-05 | Stanly | North Carolina | 37167 | 6176 | 100 |
997071 | 997071 | 2021-02-04 | Stanly | North Carolina | 37167 | 6136 | 100 |
993825 | 993825 | 2021-02-03 | Stanly | North Carolina | 37167 | 6098 | 96 |
990579 | 990579 | 2021-02-02 | Stanly | North Carolina | 37167 | 6055 | 96 |
987333 | 987333 | 2021-02-01 | Stanly | North Carolina | 37167 | 6024 | 93 |
984086 | 984086 | 2021-01-31 | Stanly | North Carolina | 37167 | 5985 | 93 |
980839 | 980839 | 2021-01-30 | Stanly | North Carolina | 37167 | 5918 | 92 |
977593 | 977593 | 2021-01-29 | Stanly | North Carolina | 37167 | 5918 | 92 |
974348 | 974348 | 2021-01-28 | Stanly | North Carolina | 37167 | 5867 | 92 |
971103 | 971103 | 2021-01-27 | Stanly | North Carolina | 37167 | 5840 | 92 |
967858 | 967858 | 2021-01-26 | Stanly | North Carolina | 37167 | 5812 | 92 |
964614 | 964614 | 2021-01-25 | Stanly | North Carolina | 37167 | 5770 | 92 |
961369 | 961369 | 2021-01-24 | Stanly | North Carolina | 37167 | 5738 | 92 |
958124 | 958124 | 2021-01-23 | Stanly | North Carolina | 37167 | 5713 | 92 |
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 |
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);