ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where county = "Pickens" and deaths = 18 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 3
- Alabama 39
- Georgia 21
- South Carolina 1
county 1
- Pickens · 61 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
852789 | 852789 | 2020-12-22 | Pickens | Georgia | 13227 | 1561 | 18 |
849544 | 849544 | 2020-12-21 | Pickens | Georgia | 13227 | 1539 | 18 |
846299 | 846299 | 2020-12-20 | Pickens | Georgia | 13227 | 1522 | 18 |
843053 | 843053 | 2020-12-19 | Pickens | Georgia | 13227 | 1483 | 18 |
839808 | 839808 | 2020-12-18 | Pickens | Georgia | 13227 | 1472 | 18 |
836563 | 836563 | 2020-12-17 | Pickens | Georgia | 13227 | 1447 | 18 |
833317 | 833317 | 2020-12-16 | Pickens | Georgia | 13227 | 1419 | 18 |
830070 | 830070 | 2020-12-15 | Pickens | Georgia | 13227 | 1407 | 18 |
826824 | 826824 | 2020-12-14 | Pickens | Georgia | 13227 | 1382 | 18 |
823577 | 823577 | 2020-12-13 | Pickens | Georgia | 13227 | 1375 | 18 |
820331 | 820331 | 2020-12-12 | Pickens | Georgia | 13227 | 1360 | 18 |
817085 | 817085 | 2020-12-11 | Pickens | Georgia | 13227 | 1342 | 18 |
813839 | 813839 | 2020-12-10 | Pickens | Georgia | 13227 | 1314 | 18 |
810595 | 810595 | 2020-12-09 | Pickens | Georgia | 13227 | 1288 | 18 |
807350 | 807350 | 2020-12-08 | Pickens | Georgia | 13227 | 1265 | 18 |
804105 | 804105 | 2020-12-07 | Pickens | Georgia | 13227 | 1259 | 18 |
800860 | 800860 | 2020-12-06 | Pickens | Georgia | 13227 | 1247 | 18 |
797615 | 797615 | 2020-12-05 | Pickens | Georgia | 13227 | 1235 | 18 |
794370 | 794370 | 2020-12-04 | Pickens | Georgia | 13227 | 1224 | 18 |
791125 | 791125 | 2020-12-03 | Pickens | Georgia | 13227 | 1190 | 18 |
787880 | 787880 | 2020-12-02 | Pickens | Georgia | 13227 | 1171 | 18 |
784188 | 784188 | 2020-12-01 | Pickens | Alabama | 1107 | 1265 | 18 |
780943 | 780943 | 2020-11-30 | Pickens | Alabama | 1107 | 1257 | 18 |
777697 | 777697 | 2020-11-29 | Pickens | Alabama | 1107 | 1242 | 18 |
774452 | 774452 | 2020-11-28 | Pickens | Alabama | 1107 | 1235 | 18 |
771207 | 771207 | 2020-11-27 | Pickens | Alabama | 1107 | 1223 | 18 |
767961 | 767961 | 2020-11-26 | Pickens | Alabama | 1107 | 1216 | 18 |
764716 | 764716 | 2020-11-25 | Pickens | Alabama | 1107 | 1194 | 18 |
761471 | 761471 | 2020-11-24 | Pickens | Alabama | 1107 | 1176 | 18 |
758226 | 758226 | 2020-11-23 | Pickens | Alabama | 1107 | 1153 | 18 |
754979 | 754979 | 2020-11-22 | Pickens | Alabama | 1107 | 1141 | 18 |
751733 | 751733 | 2020-11-21 | Pickens | Alabama | 1107 | 1133 | 18 |
748487 | 748487 | 2020-11-20 | Pickens | Alabama | 1107 | 1119 | 18 |
745241 | 745241 | 2020-11-19 | Pickens | Alabama | 1107 | 1108 | 18 |
738747 | 738747 | 2020-11-17 | Pickens | Alabama | 1107 | 1083 | 18 |
735503 | 735503 | 2020-11-16 | Pickens | Alabama | 1107 | 1077 | 18 |
732257 | 732257 | 2020-11-15 | Pickens | Alabama | 1107 | 1073 | 18 |
729012 | 729012 | 2020-11-14 | Pickens | Alabama | 1107 | 1067 | 18 |
725769 | 725769 | 2020-11-13 | Pickens | Alabama | 1107 | 1053 | 18 |
722526 | 722526 | 2020-11-12 | Pickens | Alabama | 1107 | 1040 | 18 |
719283 | 719283 | 2020-11-11 | Pickens | Alabama | 1107 | 1030 | 18 |
716040 | 716040 | 2020-11-10 | Pickens | Alabama | 1107 | 1017 | 18 |
712796 | 712796 | 2020-11-09 | Pickens | Alabama | 1107 | 1008 | 18 |
709552 | 709552 | 2020-11-08 | Pickens | Alabama | 1107 | 994 | 18 |
706308 | 706308 | 2020-11-07 | Pickens | Alabama | 1107 | 991 | 18 |
703065 | 703065 | 2020-11-06 | Pickens | Alabama | 1107 | 979 | 18 |
699822 | 699822 | 2020-11-05 | Pickens | Alabama | 1107 | 972 | 18 |
696578 | 696578 | 2020-11-04 | Pickens | Alabama | 1107 | 958 | 18 |
693336 | 693336 | 2020-11-03 | Pickens | Alabama | 1107 | 944 | 18 |
690093 | 690093 | 2020-11-02 | Pickens | Alabama | 1107 | 932 | 18 |
686848 | 686848 | 2020-11-01 | Pickens | Alabama | 1107 | 929 | 18 |
683604 | 683604 | 2020-10-31 | Pickens | Alabama | 1107 | 916 | 18 |
680361 | 680361 | 2020-10-30 | Pickens | Alabama | 1107 | 900 | 18 |
677118 | 677118 | 2020-10-29 | Pickens | Alabama | 1107 | 890 | 18 |
673875 | 673875 | 2020-10-28 | Pickens | Alabama | 1107 | 874 | 18 |
670633 | 670633 | 2020-10-27 | Pickens | Alabama | 1107 | 869 | 18 |
667390 | 667390 | 2020-10-26 | Pickens | Alabama | 1107 | 860 | 18 |
664145 | 664145 | 2020-10-25 | Pickens | Alabama | 1107 | 852 | 18 |
660901 | 660901 | 2020-10-24 | Pickens | Alabama | 1107 | 847 | 18 |
657657 | 657657 | 2020-10-23 | Pickens | Alabama | 1107 | 836 | 18 |
378715 | 378715 | 2020-07-28 | Pickens | South Carolina | 45077 | 1599 | 18 |
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);