ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,350 rows where county = "Pickens" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Georgia 752
- South Carolina 752
- Alabama 746
county 1
- Pickens · 2,250 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2392617 | 2392617 | 2022-04-10 | Pickens | Georgia | 13227 | 8336 | 163 |
2394577 | 2394577 | 2022-04-10 | Pickens | South Carolina | 45077 | 45820 | 621 |
2388912 | 2388912 | 2022-04-09 | Pickens | Alabama | 1107 | 5253 | 101 |
2389361 | 2389361 | 2022-04-09 | Pickens | Georgia | 13227 | 8336 | 163 |
2391321 | 2391321 | 2022-04-09 | Pickens | South Carolina | 45077 | 45820 | 621 |
2385657 | 2385657 | 2022-04-08 | Pickens | Alabama | 1107 | 5253 | 101 |
2386106 | 2386106 | 2022-04-08 | Pickens | Georgia | 13227 | 8336 | 163 |
2388065 | 2388065 | 2022-04-08 | Pickens | South Carolina | 45077 | 45820 | 621 |
2382402 | 2382402 | 2022-04-07 | Pickens | Alabama | 1107 | 5253 | 101 |
2382851 | 2382851 | 2022-04-07 | Pickens | Georgia | 13227 | 8335 | 163 |
2384810 | 2384810 | 2022-04-07 | Pickens | South Carolina | 45077 | 45820 | 621 |
2379147 | 2379147 | 2022-04-06 | Pickens | Alabama | 1107 | 5253 | 101 |
2379596 | 2379596 | 2022-04-06 | Pickens | Georgia | 13227 | 8336 | 162 |
2381555 | 2381555 | 2022-04-06 | Pickens | South Carolina | 45077 | 45820 | 621 |
2375893 | 2375893 | 2022-04-05 | Pickens | Alabama | 1107 | 5252 | 101 |
2376342 | 2376342 | 2022-04-05 | Pickens | Georgia | 13227 | 8336 | 162 |
2378300 | 2378300 | 2022-04-05 | Pickens | South Carolina | 45077 | 45820 | 621 |
2372641 | 2372641 | 2022-04-04 | Pickens | Alabama | 1107 | 5252 | 101 |
2373090 | 2373090 | 2022-04-04 | Pickens | Georgia | 13227 | 8332 | 162 |
2375046 | 2375046 | 2022-04-04 | Pickens | South Carolina | 45077 | 45775 | 616 |
2369388 | 2369388 | 2022-04-03 | Pickens | Alabama | 1107 | 5251 | 101 |
2369837 | 2369837 | 2022-04-03 | Pickens | Georgia | 13227 | 8329 | 162 |
2371794 | 2371794 | 2022-04-03 | Pickens | South Carolina | 45077 | 45775 | 616 |
2366135 | 2366135 | 2022-04-02 | Pickens | Alabama | 1107 | 5251 | 101 |
2366584 | 2366584 | 2022-04-02 | Pickens | Georgia | 13227 | 8329 | 162 |
2368541 | 2368541 | 2022-04-02 | Pickens | South Carolina | 45077 | 45775 | 616 |
2362882 | 2362882 | 2022-04-01 | Pickens | Alabama | 1107 | 5251 | 101 |
2363331 | 2363331 | 2022-04-01 | Pickens | Georgia | 13227 | 8329 | 162 |
2365288 | 2365288 | 2022-04-01 | Pickens | South Carolina | 45077 | 45775 | 616 |
2359628 | 2359628 | 2022-03-31 | Pickens | Alabama | 1107 | 5251 | 101 |
2360077 | 2360077 | 2022-03-31 | Pickens | Georgia | 13227 | 8327 | 162 |
2362035 | 2362035 | 2022-03-31 | Pickens | South Carolina | 45077 | 45775 | 616 |
2356374 | 2356374 | 2022-03-30 | Pickens | Alabama | 1107 | 5251 | 101 |
2356823 | 2356823 | 2022-03-30 | Pickens | Georgia | 13227 | 8328 | 162 |
2358781 | 2358781 | 2022-03-30 | Pickens | South Carolina | 45077 | 45775 | 616 |
2353121 | 2353121 | 2022-03-29 | Pickens | Alabama | 1107 | 5251 | 101 |
2353570 | 2353570 | 2022-03-29 | Pickens | Georgia | 13227 | 8323 | 162 |
2355527 | 2355527 | 2022-03-29 | Pickens | South Carolina | 45077 | 45775 | 616 |
2349869 | 2349869 | 2022-03-28 | Pickens | Alabama | 1107 | 5248 | 101 |
2350318 | 2350318 | 2022-03-28 | Pickens | Georgia | 13227 | 8323 | 162 |
2352274 | 2352274 | 2022-03-28 | Pickens | South Carolina | 45077 | 45757 | 612 |
2346616 | 2346616 | 2022-03-27 | Pickens | Alabama | 1107 | 5243 | 101 |
2347065 | 2347065 | 2022-03-27 | Pickens | Georgia | 13227 | 8322 | 162 |
2349022 | 2349022 | 2022-03-27 | Pickens | South Carolina | 45077 | 45757 | 612 |
2343363 | 2343363 | 2022-03-26 | Pickens | Alabama | 1107 | 5243 | 101 |
2343812 | 2343812 | 2022-03-26 | Pickens | Georgia | 13227 | 8322 | 162 |
2345769 | 2345769 | 2022-03-26 | Pickens | South Carolina | 45077 | 45757 | 612 |
2340110 | 2340110 | 2022-03-25 | Pickens | Alabama | 1107 | 5243 | 101 |
2340559 | 2340559 | 2022-03-25 | Pickens | Georgia | 13227 | 8322 | 162 |
2342516 | 2342516 | 2022-03-25 | Pickens | South Carolina | 45077 | 45757 | 612 |
2336857 | 2336857 | 2022-03-24 | Pickens | Alabama | 1107 | 5243 | 101 |
2337306 | 2337306 | 2022-03-24 | Pickens | Georgia | 13227 | 8320 | 162 |
2339263 | 2339263 | 2022-03-24 | Pickens | South Carolina | 45077 | 45757 | 612 |
2333603 | 2333603 | 2022-03-23 | Pickens | Alabama | 1107 | 5240 | 101 |
2334052 | 2334052 | 2022-03-23 | Pickens | Georgia | 13227 | 8317 | 162 |
2336009 | 2336009 | 2022-03-23 | Pickens | South Carolina | 45077 | 45757 | 612 |
2330349 | 2330349 | 2022-03-22 | Pickens | Alabama | 1107 | 5240 | 101 |
2330798 | 2330798 | 2022-03-22 | Pickens | Georgia | 13227 | 8316 | 162 |
2332755 | 2332755 | 2022-03-22 | Pickens | South Carolina | 45077 | 45757 | 612 |
2327097 | 2327097 | 2022-03-21 | Pickens | Alabama | 1107 | 5240 | 101 |
2327546 | 2327546 | 2022-03-21 | Pickens | Georgia | 13227 | 8314 | 162 |
2329502 | 2329502 | 2022-03-21 | Pickens | South Carolina | 45077 | 45676 | 606 |
2323844 | 2323844 | 2022-03-20 | Pickens | Alabama | 1107 | 5239 | 101 |
2324293 | 2324293 | 2022-03-20 | Pickens | Georgia | 13227 | 8312 | 161 |
2326250 | 2326250 | 2022-03-20 | Pickens | South Carolina | 45077 | 45676 | 606 |
2320590 | 2320590 | 2022-03-19 | Pickens | Alabama | 1107 | 5239 | 101 |
2321039 | 2321039 | 2022-03-19 | Pickens | Georgia | 13227 | 8312 | 161 |
2322997 | 2322997 | 2022-03-19 | Pickens | South Carolina | 45077 | 45676 | 606 |
2317336 | 2317336 | 2022-03-18 | Pickens | Alabama | 1107 | 5239 | 101 |
2317785 | 2317785 | 2022-03-18 | Pickens | Georgia | 13227 | 8312 | 161 |
2319743 | 2319743 | 2022-03-18 | Pickens | South Carolina | 45077 | 45676 | 606 |
2314083 | 2314083 | 2022-03-17 | Pickens | Alabama | 1107 | 5239 | 100 |
2314532 | 2314532 | 2022-03-17 | Pickens | Georgia | 13227 | 8310 | 160 |
2316489 | 2316489 | 2022-03-17 | Pickens | South Carolina | 45077 | 45676 | 606 |
2310830 | 2310830 | 2022-03-16 | Pickens | Alabama | 1107 | 5237 | 99 |
2311279 | 2311279 | 2022-03-16 | Pickens | Georgia | 13227 | 8306 | 160 |
2313236 | 2313236 | 2022-03-16 | Pickens | South Carolina | 45077 | 45676 | 606 |
2307577 | 2307577 | 2022-03-15 | Pickens | Alabama | 1107 | 5236 | 99 |
2308026 | 2308026 | 2022-03-15 | Pickens | Georgia | 13227 | 8304 | 160 |
2309983 | 2309983 | 2022-03-15 | Pickens | South Carolina | 45077 | 45676 | 606 |
2304326 | 2304326 | 2022-03-14 | Pickens | Alabama | 1107 | 5235 | 99 |
2304775 | 2304775 | 2022-03-14 | Pickens | Georgia | 13227 | 8305 | 160 |
2306730 | 2306730 | 2022-03-14 | Pickens | South Carolina | 45077 | 45678 | 606 |
2301074 | 2301074 | 2022-03-13 | Pickens | Alabama | 1107 | 5235 | 99 |
2301523 | 2301523 | 2022-03-13 | Pickens | Georgia | 13227 | 8303 | 160 |
2303479 | 2303479 | 2022-03-13 | Pickens | South Carolina | 45077 | 45678 | 606 |
2297822 | 2297822 | 2022-03-12 | Pickens | Alabama | 1107 | 5235 | 99 |
2298271 | 2298271 | 2022-03-12 | Pickens | Georgia | 13227 | 8303 | 160 |
2300227 | 2300227 | 2022-03-12 | Pickens | South Carolina | 45077 | 45678 | 606 |
2294570 | 2294570 | 2022-03-11 | Pickens | Alabama | 1107 | 5235 | 99 |
2295019 | 2295019 | 2022-03-11 | Pickens | Georgia | 13227 | 8303 | 160 |
2296975 | 2296975 | 2022-03-11 | Pickens | South Carolina | 45077 | 45678 | 606 |
2291318 | 2291318 | 2022-03-10 | Pickens | Alabama | 1107 | 5228 | 99 |
2291767 | 2291767 | 2022-03-10 | Pickens | Georgia | 13227 | 8302 | 159 |
2293723 | 2293723 | 2022-03-10 | Pickens | South Carolina | 45077 | 45669 | 606 |
2288066 | 2288066 | 2022-03-09 | Pickens | Alabama | 1107 | 5210 | 98 |
2288515 | 2288515 | 2022-03-09 | Pickens | Georgia | 13227 | 8301 | 159 |
2290471 | 2290471 | 2022-03-09 | Pickens | South Carolina | 45077 | 45665 | 603 |
2284814 | 2284814 | 2022-03-08 | Pickens | Alabama | 1107 | 5200 | 98 |
2285264 | 2285264 | 2022-03-08 | Pickens | Georgia | 13227 | 8298 | 159 |
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);