ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 53003 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502644 | 2502644 | 2022-05-13 | Asotin | Washington | 53003 | 4554 | 66 |
2499386 | 2499386 | 2022-05-12 | Asotin | Washington | 53003 | 4545 | 66 |
2496128 | 2496128 | 2022-05-11 | Asotin | Washington | 53003 | 4545 | 66 |
2492870 | 2492870 | 2022-05-10 | Asotin | Washington | 53003 | 4542 | 66 |
2489612 | 2489612 | 2022-05-09 | Asotin | Washington | 53003 | 4542 | 66 |
2486355 | 2486355 | 2022-05-08 | Asotin | Washington | 53003 | 4539 | 66 |
2483097 | 2483097 | 2022-05-07 | Asotin | Washington | 53003 | 4539 | 66 |
2479839 | 2479839 | 2022-05-06 | Asotin | Washington | 53003 | 4539 | 66 |
2476581 | 2476581 | 2022-05-05 | Asotin | Washington | 53003 | 4539 | 66 |
2473323 | 2473323 | 2022-05-04 | Asotin | Washington | 53003 | 4539 | 66 |
2470067 | 2470067 | 2022-05-03 | Asotin | Washington | 53003 | 4537 | 66 |
2466811 | 2466811 | 2022-05-02 | Asotin | Washington | 53003 | 4537 | 66 |
2463556 | 2463556 | 2022-05-01 | Asotin | Washington | 53003 | 4536 | 66 |
2460300 | 2460300 | 2022-04-30 | Asotin | Washington | 53003 | 4536 | 66 |
2457044 | 2457044 | 2022-04-29 | Asotin | Washington | 53003 | 4536 | 66 |
2453788 | 2453788 | 2022-04-28 | Asotin | Washington | 53003 | 4535 | 66 |
2450532 | 2450532 | 2022-04-27 | Asotin | Washington | 53003 | 4535 | 66 |
2447276 | 2447276 | 2022-04-26 | Asotin | Washington | 53003 | 4534 | 65 |
2444020 | 2444020 | 2022-04-25 | Asotin | Washington | 53003 | 4534 | 65 |
2440764 | 2440764 | 2022-04-24 | Asotin | Washington | 53003 | 4534 | 65 |
2437508 | 2437508 | 2022-04-23 | Asotin | Washington | 53003 | 4534 | 65 |
2434252 | 2434252 | 2022-04-22 | Asotin | Washington | 53003 | 4534 | 65 |
2430996 | 2430996 | 2022-04-21 | Asotin | Washington | 53003 | 4528 | 65 |
2427740 | 2427740 | 2022-04-20 | Asotin | Washington | 53003 | 4528 | 65 |
2424484 | 2424484 | 2022-04-19 | Asotin | Washington | 53003 | 4526 | 65 |
2421228 | 2421228 | 2022-04-18 | Asotin | Washington | 53003 | 4526 | 65 |
2417972 | 2417972 | 2022-04-17 | Asotin | Washington | 53003 | 4526 | 65 |
2414716 | 2414716 | 2022-04-16 | Asotin | Washington | 53003 | 4526 | 65 |
2411460 | 2411460 | 2022-04-15 | Asotin | Washington | 53003 | 4526 | 65 |
2408204 | 2408204 | 2022-04-14 | Asotin | Washington | 53003 | 4526 | 65 |
2404948 | 2404948 | 2022-04-13 | Asotin | Washington | 53003 | 4526 | 65 |
2401693 | 2401693 | 2022-04-12 | Asotin | Washington | 53003 | 4526 | 65 |
2398438 | 2398438 | 2022-04-11 | Asotin | Washington | 53003 | 4526 | 65 |
2395183 | 2395183 | 2022-04-10 | Asotin | Washington | 53003 | 4526 | 65 |
2391927 | 2391927 | 2022-04-09 | Asotin | Washington | 53003 | 4526 | 65 |
2388671 | 2388671 | 2022-04-08 | Asotin | Washington | 53003 | 4526 | 65 |
2385416 | 2385416 | 2022-04-07 | Asotin | Washington | 53003 | 4526 | 65 |
2382161 | 2382161 | 2022-04-06 | Asotin | Washington | 53003 | 4526 | 65 |
2378906 | 2378906 | 2022-04-05 | Asotin | Washington | 53003 | 4522 | 65 |
2375652 | 2375652 | 2022-04-04 | Asotin | Washington | 53003 | 4522 | 65 |
2372400 | 2372400 | 2022-04-03 | Asotin | Washington | 53003 | 4521 | 65 |
2369147 | 2369147 | 2022-04-02 | Asotin | Washington | 53003 | 4521 | 65 |
2365894 | 2365894 | 2022-04-01 | Asotin | Washington | 53003 | 4521 | 65 |
2362641 | 2362641 | 2022-03-31 | Asotin | Washington | 53003 | 4523 | 65 |
2359387 | 2359387 | 2022-03-30 | Asotin | Washington | 53003 | 4523 | 65 |
2356133 | 2356133 | 2022-03-29 | Asotin | Washington | 53003 | 4517 | 65 |
2352880 | 2352880 | 2022-03-28 | Asotin | Washington | 53003 | 4517 | 65 |
2349628 | 2349628 | 2022-03-27 | Asotin | Washington | 53003 | 4517 | 65 |
2346375 | 2346375 | 2022-03-26 | Asotin | Washington | 53003 | 4517 | 65 |
2343122 | 2343122 | 2022-03-25 | Asotin | Washington | 53003 | 4517 | 65 |
2339869 | 2339869 | 2022-03-24 | Asotin | Washington | 53003 | 4514 | 65 |
2336616 | 2336616 | 2022-03-23 | Asotin | Washington | 53003 | 4514 | 65 |
2333362 | 2333362 | 2022-03-22 | Asotin | Washington | 53003 | 4509 | 65 |
2330108 | 2330108 | 2022-03-21 | Asotin | Washington | 53003 | 4509 | 65 |
2326856 | 2326856 | 2022-03-20 | Asotin | Washington | 53003 | 4509 | 65 |
2323603 | 2323603 | 2022-03-19 | Asotin | Washington | 53003 | 4509 | 65 |
2320349 | 2320349 | 2022-03-18 | Asotin | Washington | 53003 | 4509 | 65 |
2317095 | 2317095 | 2022-03-17 | Asotin | Washington | 53003 | 4498 | 65 |
2313842 | 2313842 | 2022-03-16 | Asotin | Washington | 53003 | 4498 | 65 |
2310589 | 2310589 | 2022-03-15 | Asotin | Washington | 53003 | 4489 | 65 |
2307336 | 2307336 | 2022-03-14 | Asotin | Washington | 53003 | 4489 | 65 |
2304085 | 2304085 | 2022-03-13 | Asotin | Washington | 53003 | 4485 | 65 |
2300833 | 2300833 | 2022-03-12 | Asotin | Washington | 53003 | 4485 | 65 |
2297581 | 2297581 | 2022-03-11 | Asotin | Washington | 53003 | 4485 | 65 |
2294329 | 2294329 | 2022-03-10 | Asotin | Washington | 53003 | 4442 | 64 |
2291077 | 2291077 | 2022-03-09 | Asotin | Washington | 53003 | 4442 | 64 |
2287825 | 2287825 | 2022-03-08 | Asotin | Washington | 53003 | 4392 | 64 |
2284573 | 2284573 | 2022-03-07 | Asotin | Washington | 53003 | 4392 | 64 |
2281321 | 2281321 | 2022-03-06 | Asotin | Washington | 53003 | 4390 | 64 |
2278068 | 2278068 | 2022-03-05 | Asotin | Washington | 53003 | 4390 | 64 |
2274815 | 2274815 | 2022-03-04 | Asotin | Washington | 53003 | 4390 | 64 |
2271562 | 2271562 | 2022-03-03 | Asotin | Washington | 53003 | 4379 | 63 |
2268310 | 2268310 | 2022-03-02 | Asotin | Washington | 53003 | 4379 | 63 |
2265057 | 2265057 | 2022-03-01 | Asotin | Washington | 53003 | 4331 | 61 |
2261807 | 2261807 | 2022-02-28 | Asotin | Washington | 53003 | 4331 | 61 |
2258556 | 2258556 | 2022-02-27 | Asotin | Washington | 53003 | 4302 | 61 |
2255305 | 2255305 | 2022-02-26 | Asotin | Washington | 53003 | 4302 | 61 |
2252054 | 2252054 | 2022-02-25 | Asotin | Washington | 53003 | 4302 | 61 |
2248803 | 2248803 | 2022-02-24 | Asotin | Washington | 53003 | 4286 | 61 |
2245552 | 2245552 | 2022-02-23 | Asotin | Washington | 53003 | 4286 | 61 |
2242301 | 2242301 | 2022-02-22 | Asotin | Washington | 53003 | 4276 | 58 |
2239050 | 2239050 | 2022-02-21 | Asotin | Washington | 53003 | 4276 | 58 |
2235799 | 2235799 | 2022-02-20 | Asotin | Washington | 53003 | 4276 | 58 |
2232548 | 2232548 | 2022-02-19 | Asotin | Washington | 53003 | 4276 | 58 |
2229297 | 2229297 | 2022-02-18 | Asotin | Washington | 53003 | 4276 | 58 |
2226046 | 2226046 | 2022-02-17 | Asotin | Washington | 53003 | 4269 | 58 |
2222795 | 2222795 | 2022-02-16 | Asotin | Washington | 53003 | 4269 | 58 |
2219544 | 2219544 | 2022-02-15 | Asotin | Washington | 53003 | 4256 | 58 |
2216294 | 2216294 | 2022-02-14 | Asotin | Washington | 53003 | 4256 | 58 |
2213043 | 2213043 | 2022-02-13 | Asotin | Washington | 53003 | 4222 | 58 |
2209790 | 2209790 | 2022-02-12 | Asotin | Washington | 53003 | 4222 | 58 |
2206537 | 2206537 | 2022-02-11 | Asotin | Washington | 53003 | 4222 | 58 |
2203284 | 2203284 | 2022-02-10 | Asotin | Washington | 53003 | 4153 | 58 |
2200030 | 2200030 | 2022-02-09 | Asotin | Washington | 53003 | 4153 | 58 |
2196776 | 2196776 | 2022-02-08 | Asotin | Washington | 53003 | 4097 | 57 |
2193521 | 2193521 | 2022-02-07 | Asotin | Washington | 53003 | 4097 | 57 |
2190268 | 2190268 | 2022-02-06 | Asotin | Washington | 53003 | 4109 | 56 |
2187015 | 2187015 | 2022-02-05 | Asotin | Washington | 53003 | 4109 | 56 |
2183762 | 2183762 | 2022-02-04 | Asotin | Washington | 53003 | 4109 | 56 |
2180510 | 2180510 | 2022-02-03 | Asotin | Washington | 53003 | 4094 | 55 |
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);