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

782 rows where county = "Washington" and fips = 13303 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

  • 13303 · 782 ✖

county 1

  • Washington · 782 ✖
Link rowid date ▲ county state fips cases deaths
2500116 2500116 2022-05-13 Washington Georgia 13303 4411 137
2496858 2496858 2022-05-12 Washington Georgia 13303 4411 137
2493600 2493600 2022-05-11 Washington Georgia 13303 4411 137
2490342 2490342 2022-05-10 Washington Georgia 13303 4401 137
2487085 2487085 2022-05-09 Washington Georgia 13303 4401 137
2483827 2483827 2022-05-08 Washington Georgia 13303 4401 137
2480569 2480569 2022-05-07 Washington Georgia 13303 4401 137
2477311 2477311 2022-05-06 Washington Georgia 13303 4401 137
2474053 2474053 2022-05-05 Washington Georgia 13303 4401 137
2470796 2470796 2022-05-04 Washington Georgia 13303 4401 137
2467540 2467540 2022-05-03 Washington Georgia 13303 4395 138
2464285 2464285 2022-05-02 Washington Georgia 13303 4395 138
2461029 2461029 2022-05-01 Washington Georgia 13303 4396 138
2457773 2457773 2022-04-30 Washington Georgia 13303 4396 138
2454517 2454517 2022-04-29 Washington Georgia 13303 4396 138
2451261 2451261 2022-04-28 Washington Georgia 13303 4396 138
2448005 2448005 2022-04-27 Washington Georgia 13303 4396 138
2444749 2444749 2022-04-26 Washington Georgia 13303 4392 138
2441493 2441493 2022-04-25 Washington Georgia 13303 4392 138
2438237 2438237 2022-04-24 Washington Georgia 13303 4393 138
2434981 2434981 2022-04-23 Washington Georgia 13303 4393 138
2431725 2431725 2022-04-22 Washington Georgia 13303 4393 138
2428469 2428469 2022-04-21 Washington Georgia 13303 4393 138
2425213 2425213 2022-04-20 Washington Georgia 13303 4393 138
2421957 2421957 2022-04-19 Washington Georgia 13303 4391 138
2418701 2418701 2022-04-18 Washington Georgia 13303 4391 138
2415445 2415445 2022-04-17 Washington Georgia 13303 4391 138
2412189 2412189 2022-04-16 Washington Georgia 13303 4391 138
2408933 2408933 2022-04-15 Washington Georgia 13303 4391 138
2405677 2405677 2022-04-14 Washington Georgia 13303 4388 138
2402422 2402422 2022-04-13 Washington Georgia 13303 4387 138
2399167 2399167 2022-04-12 Washington Georgia 13303 4386 137
2395912 2395912 2022-04-11 Washington Georgia 13303 4385 137
2392656 2392656 2022-04-10 Washington Georgia 13303 4382 137
2389400 2389400 2022-04-09 Washington Georgia 13303 4382 137
2386145 2386145 2022-04-08 Washington Georgia 13303 4382 137
2382890 2382890 2022-04-07 Washington Georgia 13303 4381 137
2379635 2379635 2022-04-06 Washington Georgia 13303 4382 136
2376381 2376381 2022-04-05 Washington Georgia 13303 4381 134
2373129 2373129 2022-04-04 Washington Georgia 13303 4380 134
2369876 2369876 2022-04-03 Washington Georgia 13303 4378 133
2366623 2366623 2022-04-02 Washington Georgia 13303 4378 133
2363370 2363370 2022-04-01 Washington Georgia 13303 4378 133
2360116 2360116 2022-03-31 Washington Georgia 13303 4376 133
2356862 2356862 2022-03-30 Washington Georgia 13303 4373 132
2353609 2353609 2022-03-29 Washington Georgia 13303 4373 132
2350357 2350357 2022-03-28 Washington Georgia 13303 4373 132
2347104 2347104 2022-03-27 Washington Georgia 13303 4374 132
2343851 2343851 2022-03-26 Washington Georgia 13303 4374 132
2340598 2340598 2022-03-25 Washington Georgia 13303 4374 132
2337345 2337345 2022-03-24 Washington Georgia 13303 4373 132
2334091 2334091 2022-03-23 Washington Georgia 13303 4373 132
2330837 2330837 2022-03-22 Washington Georgia 13303 4372 132
2327585 2327585 2022-03-21 Washington Georgia 13303 4372 132
2324332 2324332 2022-03-20 Washington Georgia 13303 4372 132
2321078 2321078 2022-03-19 Washington Georgia 13303 4372 132
2317824 2317824 2022-03-18 Washington Georgia 13303 4372 132
2314571 2314571 2022-03-17 Washington Georgia 13303 4372 132
2311318 2311318 2022-03-16 Washington Georgia 13303 4374 132
2308065 2308065 2022-03-15 Washington Georgia 13303 4375 132
2304814 2304814 2022-03-14 Washington Georgia 13303 4375 132
2301562 2301562 2022-03-13 Washington Georgia 13303 4368 132
2298310 2298310 2022-03-12 Washington Georgia 13303 4368 132
2295058 2295058 2022-03-11 Washington Georgia 13303 4368 132
2291806 2291806 2022-03-10 Washington Georgia 13303 4359 132
2288554 2288554 2022-03-09 Washington Georgia 13303 4359 132
2285303 2285303 2022-03-08 Washington Georgia 13303 4358 132
2282051 2282051 2022-03-07 Washington Georgia 13303 4356 132
2278798 2278798 2022-03-06 Washington Georgia 13303 4360 132
2275545 2275545 2022-03-05 Washington Georgia 13303 4360 132
2272292 2272292 2022-03-04 Washington Georgia 13303 4360 132
2269040 2269040 2022-03-03 Washington Georgia 13303 4359 132
2265787 2265787 2022-03-02 Washington Georgia 13303 4355 132
2262536 2262536 2022-03-01 Washington Georgia 13303 4353 132
2259285 2259285 2022-02-28 Washington Georgia 13303 4338 132
2256034 2256034 2022-02-27 Washington Georgia 13303 4334 132
2252783 2252783 2022-02-26 Washington Georgia 13303 4334 132
2249532 2249532 2022-02-25 Washington Georgia 13303 4334 132
2246281 2246281 2022-02-24 Washington Georgia 13303 4333 132
2243030 2243030 2022-02-23 Washington Georgia 13303 4327 132
2239779 2239779 2022-02-22 Washington Georgia 13303 4327 132
2236528 2236528 2022-02-21 Washington Georgia 13303 4323 132
2233277 2233277 2022-02-20 Washington Georgia 13303 4316 132
2230026 2230026 2022-02-19 Washington Georgia 13303 4316 132
2226775 2226775 2022-02-18 Washington Georgia 13303 4316 132
2223524 2223524 2022-02-17 Washington Georgia 13303 4313 132
2220273 2220273 2022-02-16 Washington Georgia 13303 4307 132
2217022 2217022 2022-02-15 Washington Georgia 13303 4297 132
2213771 2213771 2022-02-14 Washington Georgia 13303 4286 132
2210519 2210519 2022-02-13 Washington Georgia 13303 4271 132
2207266 2207266 2022-02-12 Washington Georgia 13303 4271 132
2204013 2204013 2022-02-11 Washington Georgia 13303 4271 132
2200760 2200760 2022-02-10 Washington Georgia 13303 4261 132
2197506 2197506 2022-02-09 Washington Georgia 13303 4249 132
2194252 2194252 2022-02-08 Washington Georgia 13303 4237 132
2190998 2190998 2022-02-07 Washington Georgia 13303 4228 131
2187745 2187745 2022-02-06 Washington Georgia 13303 4206 131
2184492 2184492 2022-02-05 Washington Georgia 13303 4206 131
2181240 2181240 2022-02-04 Washington Georgia 13303 4206 131
2177989 2177989 2022-02-03 Washington Georgia 13303 4190 131

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