ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where county = "Pickens" and deaths = 74 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Georgia 36
- Alabama 3
- South Carolina 3
county 1
- Pickens · 42 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1758183 | 1758183 | 2021-09-27 | Pickens | Alabama | 1107 | 3064 | 74 |
1754935 | 1754935 | 2021-09-26 | Pickens | Alabama | 1107 | 3052 | 74 |
1751687 | 1751687 | 2021-09-25 | Pickens | Alabama | 1107 | 3044 | 74 |
1245575 | 1245575 | 2021-04-22 | Pickens | Georgia | 13227 | 3390 | 74 |
1242328 | 1242328 | 2021-04-21 | Pickens | Georgia | 13227 | 3386 | 74 |
1239081 | 1239081 | 2021-04-20 | Pickens | Georgia | 13227 | 3380 | 74 |
1235834 | 1235834 | 2021-04-19 | Pickens | Georgia | 13227 | 3373 | 74 |
1232587 | 1232587 | 2021-04-18 | Pickens | Georgia | 13227 | 3368 | 74 |
1229338 | 1229338 | 2021-04-17 | Pickens | Georgia | 13227 | 3360 | 74 |
1226090 | 1226090 | 2021-04-16 | Pickens | Georgia | 13227 | 3357 | 74 |
1222843 | 1222843 | 2021-04-15 | Pickens | Georgia | 13227 | 3355 | 74 |
1219595 | 1219595 | 2021-04-14 | Pickens | Georgia | 13227 | 3350 | 74 |
1216347 | 1216347 | 2021-04-13 | Pickens | Georgia | 13227 | 3348 | 74 |
1213100 | 1213100 | 2021-04-12 | Pickens | Georgia | 13227 | 3339 | 74 |
1209852 | 1209852 | 2021-04-11 | Pickens | Georgia | 13227 | 3334 | 74 |
1206603 | 1206603 | 2021-04-10 | Pickens | Georgia | 13227 | 3334 | 74 |
1203355 | 1203355 | 2021-04-09 | Pickens | Georgia | 13227 | 3332 | 74 |
1200107 | 1200107 | 2021-04-08 | Pickens | Georgia | 13227 | 3327 | 74 |
1196858 | 1196858 | 2021-04-07 | Pickens | Georgia | 13227 | 3320 | 74 |
1193610 | 1193610 | 2021-04-06 | Pickens | Georgia | 13227 | 3312 | 74 |
1190360 | 1190360 | 2021-04-05 | Pickens | Georgia | 13227 | 3307 | 74 |
1187113 | 1187113 | 2021-04-04 | Pickens | Georgia | 13227 | 3306 | 74 |
1183866 | 1183866 | 2021-04-03 | Pickens | Georgia | 13227 | 3306 | 74 |
1180619 | 1180619 | 2021-04-02 | Pickens | Georgia | 13227 | 3300 | 74 |
1177372 | 1177372 | 2021-04-01 | Pickens | Georgia | 13227 | 3296 | 74 |
1174125 | 1174125 | 2021-03-31 | Pickens | Georgia | 13227 | 3290 | 74 |
1170878 | 1170878 | 2021-03-30 | Pickens | Georgia | 13227 | 3283 | 74 |
1167630 | 1167630 | 2021-03-29 | Pickens | Georgia | 13227 | 3278 | 74 |
1164382 | 1164382 | 2021-03-28 | Pickens | Georgia | 13227 | 3279 | 74 |
1161134 | 1161134 | 2021-03-27 | Pickens | Georgia | 13227 | 3279 | 74 |
1157886 | 1157886 | 2021-03-26 | Pickens | Georgia | 13227 | 3277 | 74 |
1154639 | 1154639 | 2021-03-25 | Pickens | Georgia | 13227 | 3273 | 74 |
1151392 | 1151392 | 2021-03-24 | Pickens | Georgia | 13227 | 3263 | 74 |
1148145 | 1148145 | 2021-03-23 | Pickens | Georgia | 13227 | 3258 | 74 |
1144898 | 1144898 | 2021-03-22 | Pickens | Georgia | 13227 | 3254 | 74 |
1141651 | 1141651 | 2021-03-21 | Pickens | Georgia | 13227 | 3247 | 74 |
1138405 | 1138405 | 2021-03-20 | Pickens | Georgia | 13227 | 3244 | 74 |
1135159 | 1135159 | 2021-03-19 | Pickens | Georgia | 13227 | 3240 | 74 |
1131912 | 1131912 | 2021-03-18 | Pickens | Georgia | 13227 | 3240 | 74 |
744393 | 744393 | 2020-11-18 | Pickens | South Carolina | 45077 | 5504 | 74 |
741146 | 741146 | 2020-11-17 | Pickens | South Carolina | 45077 | 5465 | 74 |
737900 | 737900 | 2020-11-16 | Pickens | South Carolina | 45077 | 5423 | 74 |
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);