ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Marion" and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195556 | 1195556 | 2021-04-06 | Marion | South Carolina | 45067 | 3447 | 101 |
1192308 | 1192308 | 2021-04-05 | Marion | South Carolina | 45067 | 3440 | 101 |
1189059 | 1189059 | 2021-04-04 | Marion | South Carolina | 45067 | 3435 | 101 |
1185812 | 1185812 | 2021-04-03 | Marion | South Carolina | 45067 | 3435 | 101 |
1182565 | 1182565 | 2021-04-02 | Marion | South Carolina | 45067 | 3428 | 101 |
1179318 | 1179318 | 2021-04-01 | Marion | South Carolina | 45067 | 3423 | 101 |
1176071 | 1176071 | 2021-03-31 | Marion | South Carolina | 45067 | 3423 | 101 |
1172824 | 1172824 | 2021-03-30 | Marion | South Carolina | 45067 | 3423 | 101 |
1169577 | 1169577 | 2021-03-29 | Marion | South Carolina | 45067 | 3417 | 101 |
1166329 | 1166329 | 2021-03-28 | Marion | South Carolina | 45067 | 3411 | 101 |
1163081 | 1163081 | 2021-03-27 | Marion | South Carolina | 45067 | 3405 | 101 |
1159832 | 1159832 | 2021-03-26 | Marion | South Carolina | 45067 | 3389 | 101 |
1156585 | 1156585 | 2021-03-25 | Marion | South Carolina | 45067 | 3378 | 101 |
1153338 | 1153338 | 2021-03-24 | Marion | South Carolina | 45067 | 3368 | 101 |
1150091 | 1150091 | 2021-03-23 | Marion | South Carolina | 45067 | 3368 | 101 |
1146844 | 1146844 | 2021-03-22 | Marion | South Carolina | 45067 | 3361 | 101 |
1143597 | 1143597 | 2021-03-21 | Marion | South Carolina | 45067 | 3357 | 101 |
1140350 | 1140350 | 2021-03-20 | Marion | South Carolina | 45067 | 3339 | 101 |
1137104 | 1137104 | 2021-03-19 | Marion | South Carolina | 45067 | 3329 | 101 |
1133858 | 1133858 | 2021-03-18 | Marion | South Carolina | 45067 | 3326 | 101 |
1130610 | 1130610 | 2021-03-17 | Marion | South Carolina | 45067 | 3317 | 101 |
1127363 | 1127363 | 2021-03-16 | Marion | South Carolina | 45067 | 3309 | 101 |
1124117 | 1124117 | 2021-03-15 | Marion | South Carolina | 45067 | 3309 | 101 |
1120871 | 1120871 | 2021-03-14 | Marion | South Carolina | 45067 | 3302 | 101 |
1117624 | 1117624 | 2021-03-13 | Marion | South Carolina | 45067 | 3294 | 101 |
1114377 | 1114377 | 2021-03-12 | Marion | South Carolina | 45067 | 3291 | 101 |
1111131 | 1111131 | 2021-03-11 | Marion | South Carolina | 45067 | 3284 | 101 |
1107885 | 1107885 | 2021-03-10 | Marion | South Carolina | 45067 | 3281 | 101 |
1104639 | 1104639 | 2021-03-09 | Marion | South Carolina | 45067 | 3279 | 101 |
1101393 | 1101393 | 2021-03-08 | Marion | South Carolina | 45067 | 3276 | 101 |
1098147 | 1098147 | 2021-03-07 | Marion | South Carolina | 45067 | 3274 | 101 |
1094899 | 1094899 | 2021-03-06 | Marion | South Carolina | 45067 | 3273 | 100 |
1091653 | 1091653 | 2021-03-05 | Marion | South Carolina | 45067 | 3267 | 100 |
1088407 | 1088407 | 2021-03-04 | Marion | South Carolina | 45067 | 3260 | 100 |
1085162 | 1085162 | 2021-03-03 | Marion | South Carolina | 45067 | 3257 | 99 |
1081916 | 1081916 | 2021-03-02 | Marion | South Carolina | 45067 | 3253 | 98 |
1078670 | 1078670 | 2021-03-01 | Marion | South Carolina | 45067 | 3249 | 98 |
1075425 | 1075425 | 2021-02-28 | Marion | South Carolina | 45067 | 3248 | 97 |
1072179 | 1072179 | 2021-02-27 | Marion | South Carolina | 45067 | 3239 | 97 |
1068933 | 1068933 | 2021-02-26 | Marion | South Carolina | 45067 | 3233 | 97 |
1065688 | 1065688 | 2021-02-25 | Marion | South Carolina | 45067 | 3229 | 96 |
1062443 | 1062443 | 2021-02-24 | Marion | South Carolina | 45067 | 3223 | 96 |
1059198 | 1059198 | 2021-02-23 | Marion | South Carolina | 45067 | 3212 | 95 |
1055952 | 1055952 | 2021-02-22 | Marion | South Carolina | 45067 | 3206 | 95 |
1052706 | 1052706 | 2021-02-21 | Marion | South Carolina | 45067 | 3202 | 95 |
1049459 | 1049459 | 2021-02-20 | Marion | South Carolina | 45067 | 3194 | 95 |
1046212 | 1046212 | 2021-02-19 | Marion | South Carolina | 45067 | 3182 | 94 |
1042967 | 1042967 | 2021-02-18 | Marion | South Carolina | 45067 | 3171 | 94 |
1039722 | 1039722 | 2021-02-17 | Marion | South Carolina | 45067 | 3165 | 94 |
1036477 | 1036477 | 2021-02-16 | Marion | South Carolina | 45067 | 3158 | 94 |
1033232 | 1033232 | 2021-02-15 | Marion | South Carolina | 45067 | 3153 | 94 |
1029986 | 1029986 | 2021-02-14 | Marion | South Carolina | 45067 | 3143 | 94 |
1026739 | 1026739 | 2021-02-13 | Marion | South Carolina | 45067 | 3114 | 93 |
1023494 | 1023494 | 2021-02-12 | Marion | South Carolina | 45067 | 3103 | 93 |
1020249 | 1020249 | 2021-02-11 | Marion | South Carolina | 45067 | 3073 | 92 |
1017004 | 1017004 | 2021-02-10 | Marion | South Carolina | 45067 | 3046 | 91 |
1013759 | 1013759 | 2021-02-09 | Marion | South Carolina | 45067 | 3038 | 91 |
1010514 | 1010514 | 2021-02-08 | Marion | South Carolina | 45067 | 3024 | 91 |
1007268 | 1007268 | 2021-02-07 | Marion | South Carolina | 45067 | 3010 | 90 |
1004022 | 1004022 | 2021-02-06 | Marion | South Carolina | 45067 | 2991 | 90 |
1000776 | 1000776 | 2021-02-05 | Marion | South Carolina | 45067 | 2962 | 90 |
997530 | 997530 | 2021-02-04 | Marion | South Carolina | 45067 | 2945 | 89 |
994284 | 994284 | 2021-02-03 | Marion | South Carolina | 45067 | 2927 | 89 |
991038 | 991038 | 2021-02-02 | Marion | South Carolina | 45067 | 2918 | 87 |
987792 | 987792 | 2021-02-01 | Marion | South Carolina | 45067 | 2897 | 87 |
984545 | 984545 | 2021-01-31 | Marion | South Carolina | 45067 | 2887 | 86 |
981298 | 981298 | 2021-01-30 | Marion | South Carolina | 45067 | 2866 | 86 |
978052 | 978052 | 2021-01-29 | Marion | South Carolina | 45067 | 2851 | 86 |
974807 | 974807 | 2021-01-28 | Marion | South Carolina | 45067 | 2832 | 86 |
971562 | 971562 | 2021-01-27 | Marion | South Carolina | 45067 | 2814 | 86 |
968317 | 968317 | 2021-01-26 | Marion | South Carolina | 45067 | 2791 | 86 |
965073 | 965073 | 2021-01-25 | Marion | South Carolina | 45067 | 2782 | 85 |
961828 | 961828 | 2021-01-24 | Marion | South Carolina | 45067 | 2771 | 85 |
958583 | 958583 | 2021-01-23 | Marion | South Carolina | 45067 | 2757 | 84 |
955337 | 955337 | 2021-01-22 | Marion | South Carolina | 45067 | 2746 | 83 |
952092 | 952092 | 2021-01-21 | Marion | South Carolina | 45067 | 2706 | 83 |
948847 | 948847 | 2021-01-20 | Marion | South Carolina | 45067 | 2688 | 82 |
945601 | 945601 | 2021-01-19 | Marion | South Carolina | 45067 | 2680 | 82 |
942354 | 942354 | 2021-01-18 | Marion | South Carolina | 45067 | 2648 | 82 |
939109 | 939109 | 2021-01-17 | Marion | South Carolina | 45067 | 2624 | 82 |
935864 | 935864 | 2021-01-16 | Marion | South Carolina | 45067 | 2570 | 81 |
932619 | 932619 | 2021-01-15 | Marion | South Carolina | 45067 | 2522 | 80 |
929374 | 929374 | 2021-01-14 | Marion | South Carolina | 45067 | 2483 | 79 |
926129 | 926129 | 2021-01-13 | Marion | South Carolina | 45067 | 2437 | 79 |
922883 | 922883 | 2021-01-12 | Marion | South Carolina | 45067 | 2389 | 79 |
919638 | 919638 | 2021-01-11 | Marion | South Carolina | 45067 | 2369 | 75 |
916393 | 916393 | 2021-01-10 | Marion | South Carolina | 45067 | 2330 | 75 |
913148 | 913148 | 2021-01-09 | Marion | South Carolina | 45067 | 2310 | 75 |
909903 | 909903 | 2021-01-08 | Marion | South Carolina | 45067 | 2234 | 73 |
906658 | 906658 | 2021-01-07 | Marion | South Carolina | 45067 | 2182 | 70 |
903412 | 903412 | 2021-01-06 | Marion | South Carolina | 45067 | 2152 | 69 |
900167 | 900167 | 2021-01-05 | Marion | South Carolina | 45067 | 2111 | 64 |
896922 | 896922 | 2021-01-04 | Marion | South Carolina | 45067 | 2087 | 64 |
893676 | 893676 | 2021-01-03 | Marion | South Carolina | 45067 | 2050 | 64 |
890430 | 890430 | 2021-01-02 | Marion | South Carolina | 45067 | 1980 | 64 |
887183 | 887183 | 2021-01-01 | Marion | South Carolina | 45067 | 1946 | 63 |
883938 | 883938 | 2020-12-31 | Marion | South Carolina | 45067 | 1946 | 63 |
880693 | 880693 | 2020-12-30 | Marion | South Carolina | 45067 | 1931 | 63 |
877448 | 877448 | 2020-12-29 | Marion | South Carolina | 45067 | 1911 | 63 |
874203 | 874203 | 2020-12-28 | Marion | South Carolina | 45067 | 1897 | 63 |
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);