ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

785 rows where county = "Pickens" and fips = 13227 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 13227 · 785 ✖

county 1

  • Pickens · 785 ✖
Link rowid date ▲ county state fips cases deaths
2500077 2500077 2022-05-13 Pickens Georgia 13227 8392 167
2496819 2496819 2022-05-12 Pickens Georgia 13227 8392 167
2493561 2493561 2022-05-11 Pickens Georgia 13227 8392 167
2490303 2490303 2022-05-10 Pickens Georgia 13227 8375 167
2487046 2487046 2022-05-09 Pickens Georgia 13227 8375 167
2483788 2483788 2022-05-08 Pickens Georgia 13227 8376 167
2480530 2480530 2022-05-07 Pickens Georgia 13227 8376 167
2477272 2477272 2022-05-06 Pickens Georgia 13227 8376 167
2474014 2474014 2022-05-05 Pickens Georgia 13227 8376 167
2470757 2470757 2022-05-04 Pickens Georgia 13227 8376 167
2467501 2467501 2022-05-03 Pickens Georgia 13227 8371 166
2464246 2464246 2022-05-02 Pickens Georgia 13227 8371 166
2460990 2460990 2022-05-01 Pickens Georgia 13227 8369 166
2457734 2457734 2022-04-30 Pickens Georgia 13227 8369 166
2454478 2454478 2022-04-29 Pickens Georgia 13227 8369 166
2451222 2451222 2022-04-28 Pickens Georgia 13227 8369 166
2447966 2447966 2022-04-27 Pickens Georgia 13227 8369 166
2444710 2444710 2022-04-26 Pickens Georgia 13227 8358 164
2441454 2441454 2022-04-25 Pickens Georgia 13227 8358 164
2438198 2438198 2022-04-24 Pickens Georgia 13227 8360 164
2434942 2434942 2022-04-23 Pickens Georgia 13227 8360 164
2431686 2431686 2022-04-22 Pickens Georgia 13227 8360 164
2428430 2428430 2022-04-21 Pickens Georgia 13227 8360 164
2425174 2425174 2022-04-20 Pickens Georgia 13227 8360 164
2421918 2421918 2022-04-19 Pickens Georgia 13227 8353 164
2418662 2418662 2022-04-18 Pickens Georgia 13227 8353 164
2415406 2415406 2022-04-17 Pickens Georgia 13227 8354 164
2412150 2412150 2022-04-16 Pickens Georgia 13227 8354 164
2408894 2408894 2022-04-15 Pickens Georgia 13227 8354 164
2405638 2405638 2022-04-14 Pickens Georgia 13227 8354 164
2402383 2402383 2022-04-13 Pickens Georgia 13227 8354 164
2399128 2399128 2022-04-12 Pickens Georgia 13227 8351 163
2395873 2395873 2022-04-11 Pickens Georgia 13227 8345 163
2392617 2392617 2022-04-10 Pickens Georgia 13227 8336 163
2389361 2389361 2022-04-09 Pickens Georgia 13227 8336 163
2386106 2386106 2022-04-08 Pickens Georgia 13227 8336 163
2382851 2382851 2022-04-07 Pickens Georgia 13227 8335 163
2379596 2379596 2022-04-06 Pickens Georgia 13227 8336 162
2376342 2376342 2022-04-05 Pickens Georgia 13227 8336 162
2373090 2373090 2022-04-04 Pickens Georgia 13227 8332 162
2369837 2369837 2022-04-03 Pickens Georgia 13227 8329 162
2366584 2366584 2022-04-02 Pickens Georgia 13227 8329 162
2363331 2363331 2022-04-01 Pickens Georgia 13227 8329 162
2360077 2360077 2022-03-31 Pickens Georgia 13227 8327 162
2356823 2356823 2022-03-30 Pickens Georgia 13227 8328 162
2353570 2353570 2022-03-29 Pickens Georgia 13227 8323 162
2350318 2350318 2022-03-28 Pickens Georgia 13227 8323 162
2347065 2347065 2022-03-27 Pickens Georgia 13227 8322 162
2343812 2343812 2022-03-26 Pickens Georgia 13227 8322 162
2340559 2340559 2022-03-25 Pickens Georgia 13227 8322 162
2337306 2337306 2022-03-24 Pickens Georgia 13227 8320 162
2334052 2334052 2022-03-23 Pickens Georgia 13227 8317 162
2330798 2330798 2022-03-22 Pickens Georgia 13227 8316 162
2327546 2327546 2022-03-21 Pickens Georgia 13227 8314 162
2324293 2324293 2022-03-20 Pickens Georgia 13227 8312 161
2321039 2321039 2022-03-19 Pickens Georgia 13227 8312 161
2317785 2317785 2022-03-18 Pickens Georgia 13227 8312 161
2314532 2314532 2022-03-17 Pickens Georgia 13227 8310 160
2311279 2311279 2022-03-16 Pickens Georgia 13227 8306 160
2308026 2308026 2022-03-15 Pickens Georgia 13227 8304 160
2304775 2304775 2022-03-14 Pickens Georgia 13227 8305 160
2301523 2301523 2022-03-13 Pickens Georgia 13227 8303 160
2298271 2298271 2022-03-12 Pickens Georgia 13227 8303 160
2295019 2295019 2022-03-11 Pickens Georgia 13227 8303 160
2291767 2291767 2022-03-10 Pickens Georgia 13227 8302 159
2288515 2288515 2022-03-09 Pickens Georgia 13227 8301 159
2285264 2285264 2022-03-08 Pickens Georgia 13227 8298 159
2282012 2282012 2022-03-07 Pickens Georgia 13227 8296 159
2278759 2278759 2022-03-06 Pickens Georgia 13227 8296 158
2275506 2275506 2022-03-05 Pickens Georgia 13227 8296 158
2272253 2272253 2022-03-04 Pickens Georgia 13227 8296 158
2269001 2269001 2022-03-03 Pickens Georgia 13227 8294 158
2265748 2265748 2022-03-02 Pickens Georgia 13227 8292 158
2262497 2262497 2022-03-01 Pickens Georgia 13227 8291 158
2259246 2259246 2022-02-28 Pickens Georgia 13227 8290 157
2255995 2255995 2022-02-27 Pickens Georgia 13227 8278 156
2252744 2252744 2022-02-26 Pickens Georgia 13227 8278 156
2249493 2249493 2022-02-25 Pickens Georgia 13227 8278 156
2246242 2246242 2022-02-24 Pickens Georgia 13227 8269 155
2242991 2242991 2022-02-23 Pickens Georgia 13227 8261 155
2239740 2239740 2022-02-22 Pickens Georgia 13227 8240 155
2236489 2236489 2022-02-21 Pickens Georgia 13227 8233 155
2233238 2233238 2022-02-20 Pickens Georgia 13227 8200 154
2229987 2229987 2022-02-19 Pickens Georgia 13227 8200 154
2226736 2226736 2022-02-18 Pickens Georgia 13227 8200 154
2223485 2223485 2022-02-17 Pickens Georgia 13227 8192 151
2220234 2220234 2022-02-16 Pickens Georgia 13227 8179 148
2216983 2216983 2022-02-15 Pickens Georgia 13227 8168 148
2213732 2213732 2022-02-14 Pickens Georgia 13227 8147 148
2210480 2210480 2022-02-13 Pickens Georgia 13227 8127 148
2207227 2207227 2022-02-12 Pickens Georgia 13227 8127 148
2203974 2203974 2022-02-11 Pickens Georgia 13227 8127 148
2200721 2200721 2022-02-10 Pickens Georgia 13227 8110 148
2197467 2197467 2022-02-09 Pickens Georgia 13227 8081 147
2194213 2194213 2022-02-08 Pickens Georgia 13227 8017 146
2190959 2190959 2022-02-07 Pickens Georgia 13227 7973 143
2187706 2187706 2022-02-06 Pickens Georgia 13227 7914 143
2184453 2184453 2022-02-05 Pickens Georgia 13227 7914 143
2181201 2181201 2022-02-04 Pickens Georgia 13227 7914 143
2177950 2177950 2022-02-03 Pickens Georgia 13227 7889 142

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);