ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Clatsop" and fips = 41007 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 |
---|---|---|---|---|---|---|---|
2501814 | 2501814 | 2022-05-13 | Clatsop | Oregon | 41007 | 4810 | 50 |
2498556 | 2498556 | 2022-05-12 | Clatsop | Oregon | 41007 | 4799 | 50 |
2495298 | 2495298 | 2022-05-11 | Clatsop | Oregon | 41007 | 4787 | 50 |
2492040 | 2492040 | 2022-05-10 | Clatsop | Oregon | 41007 | 4779 | 50 |
2488782 | 2488782 | 2022-05-09 | Clatsop | Oregon | 41007 | 4773 | 50 |
2485525 | 2485525 | 2022-05-08 | Clatsop | Oregon | 41007 | 4755 | 50 |
2482267 | 2482267 | 2022-05-07 | Clatsop | Oregon | 41007 | 4755 | 50 |
2479009 | 2479009 | 2022-05-06 | Clatsop | Oregon | 41007 | 4755 | 50 |
2475751 | 2475751 | 2022-05-05 | Clatsop | Oregon | 41007 | 4744 | 50 |
2472494 | 2472494 | 2022-05-04 | Clatsop | Oregon | 41007 | 4727 | 50 |
2469238 | 2469238 | 2022-05-03 | Clatsop | Oregon | 41007 | 4715 | 50 |
2465982 | 2465982 | 2022-05-02 | Clatsop | Oregon | 41007 | 4704 | 50 |
2462727 | 2462727 | 2022-05-01 | Clatsop | Oregon | 41007 | 4688 | 49 |
2459471 | 2459471 | 2022-04-30 | Clatsop | Oregon | 41007 | 4688 | 49 |
2456215 | 2456215 | 2022-04-29 | Clatsop | Oregon | 41007 | 4688 | 49 |
2452959 | 2452959 | 2022-04-28 | Clatsop | Oregon | 41007 | 4675 | 49 |
2449703 | 2449703 | 2022-04-27 | Clatsop | Oregon | 41007 | 4672 | 49 |
2446446 | 2446446 | 2022-04-26 | Clatsop | Oregon | 41007 | 4664 | 49 |
2443191 | 2443191 | 2022-04-25 | Clatsop | Oregon | 41007 | 4660 | 49 |
2439935 | 2439935 | 2022-04-24 | Clatsop | Oregon | 41007 | 4643 | 49 |
2436679 | 2436679 | 2022-04-23 | Clatsop | Oregon | 41007 | 4643 | 49 |
2433423 | 2433423 | 2022-04-22 | Clatsop | Oregon | 41007 | 4643 | 49 |
2430167 | 2430167 | 2022-04-21 | Clatsop | Oregon | 41007 | 4639 | 49 |
2426911 | 2426911 | 2022-04-20 | Clatsop | Oregon | 41007 | 4637 | 49 |
2423655 | 2423655 | 2022-04-19 | Clatsop | Oregon | 41007 | 4632 | 49 |
2420398 | 2420398 | 2022-04-18 | Clatsop | Oregon | 41007 | 4624 | 49 |
2417143 | 2417143 | 2022-04-17 | Clatsop | Oregon | 41007 | 4624 | 49 |
2413887 | 2413887 | 2022-04-16 | Clatsop | Oregon | 41007 | 4624 | 49 |
2410631 | 2410631 | 2022-04-15 | Clatsop | Oregon | 41007 | 4624 | 49 |
2407375 | 2407375 | 2022-04-14 | Clatsop | Oregon | 41007 | 4622 | 49 |
2404119 | 2404119 | 2022-04-13 | Clatsop | Oregon | 41007 | 4617 | 49 |
2400864 | 2400864 | 2022-04-12 | Clatsop | Oregon | 41007 | 4611 | 49 |
2397609 | 2397609 | 2022-04-11 | Clatsop | Oregon | 41007 | 4605 | 48 |
2394354 | 2394354 | 2022-04-10 | Clatsop | Oregon | 41007 | 4601 | 48 |
2391098 | 2391098 | 2022-04-09 | Clatsop | Oregon | 41007 | 4601 | 48 |
2387842 | 2387842 | 2022-04-08 | Clatsop | Oregon | 41007 | 4601 | 48 |
2384587 | 2384587 | 2022-04-07 | Clatsop | Oregon | 41007 | 4601 | 48 |
2381332 | 2381332 | 2022-04-06 | Clatsop | Oregon | 41007 | 4601 | 48 |
2378077 | 2378077 | 2022-04-05 | Clatsop | Oregon | 41007 | 4600 | 48 |
2374823 | 2374823 | 2022-04-04 | Clatsop | Oregon | 41007 | 4598 | 48 |
2371571 | 2371571 | 2022-04-03 | Clatsop | Oregon | 41007 | 4596 | 47 |
2368318 | 2368318 | 2022-04-02 | Clatsop | Oregon | 41007 | 4596 | 47 |
2365065 | 2365065 | 2022-04-01 | Clatsop | Oregon | 41007 | 4596 | 47 |
2361812 | 2361812 | 2022-03-31 | Clatsop | Oregon | 41007 | 4592 | 46 |
2358558 | 2358558 | 2022-03-30 | Clatsop | Oregon | 41007 | 4590 | 46 |
2355304 | 2355304 | 2022-03-29 | Clatsop | Oregon | 41007 | 4584 | 44 |
2352051 | 2352051 | 2022-03-28 | Clatsop | Oregon | 41007 | 4582 | 43 |
2348799 | 2348799 | 2022-03-27 | Clatsop | Oregon | 41007 | 4579 | 42 |
2345546 | 2345546 | 2022-03-26 | Clatsop | Oregon | 41007 | 4579 | 42 |
2342293 | 2342293 | 2022-03-25 | Clatsop | Oregon | 41007 | 4579 | 42 |
2339040 | 2339040 | 2022-03-24 | Clatsop | Oregon | 41007 | 4577 | 42 |
2335786 | 2335786 | 2022-03-23 | Clatsop | Oregon | 41007 | 4573 | 42 |
2332532 | 2332532 | 2022-03-22 | Clatsop | Oregon | 41007 | 4572 | 41 |
2329279 | 2329279 | 2022-03-21 | Clatsop | Oregon | 41007 | 4570 | 41 |
2326027 | 2326027 | 2022-03-20 | Clatsop | Oregon | 41007 | 4564 | 41 |
2322774 | 2322774 | 2022-03-19 | Clatsop | Oregon | 41007 | 4564 | 41 |
2319520 | 2319520 | 2022-03-18 | Clatsop | Oregon | 41007 | 4564 | 41 |
2316266 | 2316266 | 2022-03-17 | Clatsop | Oregon | 41007 | 4564 | 41 |
2313013 | 2313013 | 2022-03-16 | Clatsop | Oregon | 41007 | 4559 | 40 |
2309760 | 2309760 | 2022-03-15 | Clatsop | Oregon | 41007 | 4553 | 39 |
2306507 | 2306507 | 2022-03-14 | Clatsop | Oregon | 41007 | 4550 | 38 |
2303256 | 2303256 | 2022-03-13 | Clatsop | Oregon | 41007 | 4545 | 38 |
2300004 | 2300004 | 2022-03-12 | Clatsop | Oregon | 41007 | 4545 | 38 |
2296752 | 2296752 | 2022-03-11 | Clatsop | Oregon | 41007 | 4545 | 38 |
2293500 | 2293500 | 2022-03-10 | Clatsop | Oregon | 41007 | 4541 | 38 |
2290248 | 2290248 | 2022-03-09 | Clatsop | Oregon | 41007 | 4538 | 38 |
2286996 | 2286996 | 2022-03-08 | Clatsop | Oregon | 41007 | 4538 | 39 |
2283744 | 2283744 | 2022-03-07 | Clatsop | Oregon | 41007 | 4536 | 39 |
2280492 | 2280492 | 2022-03-06 | Clatsop | Oregon | 41007 | 4527 | 39 |
2277239 | 2277239 | 2022-03-05 | Clatsop | Oregon | 41007 | 4527 | 39 |
2273986 | 2273986 | 2022-03-04 | Clatsop | Oregon | 41007 | 4527 | 39 |
2270733 | 2270733 | 2022-03-03 | Clatsop | Oregon | 41007 | 4527 | 39 |
2267481 | 2267481 | 2022-03-02 | Clatsop | Oregon | 41007 | 4523 | 38 |
2264228 | 2264228 | 2022-03-01 | Clatsop | Oregon | 41007 | 4520 | 38 |
2260978 | 2260978 | 2022-02-28 | Clatsop | Oregon | 41007 | 4515 | 38 |
2257727 | 2257727 | 2022-02-27 | Clatsop | Oregon | 41007 | 4507 | 38 |
2254476 | 2254476 | 2022-02-26 | Clatsop | Oregon | 41007 | 4507 | 38 |
2251225 | 2251225 | 2022-02-25 | Clatsop | Oregon | 41007 | 4507 | 38 |
2247974 | 2247974 | 2022-02-24 | Clatsop | Oregon | 41007 | 4503 | 38 |
2244723 | 2244723 | 2022-02-23 | Clatsop | Oregon | 41007 | 4490 | 38 |
2241472 | 2241472 | 2022-02-22 | Clatsop | Oregon | 41007 | 4484 | 38 |
2238221 | 2238221 | 2022-02-21 | Clatsop | Oregon | 41007 | 4457 | 38 |
2234970 | 2234970 | 2022-02-20 | Clatsop | Oregon | 41007 | 4457 | 38 |
2231719 | 2231719 | 2022-02-19 | Clatsop | Oregon | 41007 | 4457 | 38 |
2228468 | 2228468 | 2022-02-18 | Clatsop | Oregon | 41007 | 4457 | 38 |
2225217 | 2225217 | 2022-02-17 | Clatsop | Oregon | 41007 | 4448 | 38 |
2221966 | 2221966 | 2022-02-16 | Clatsop | Oregon | 41007 | 4438 | 38 |
2218715 | 2218715 | 2022-02-15 | Clatsop | Oregon | 41007 | 4424 | 38 |
2215464 | 2215464 | 2022-02-14 | Clatsop | Oregon | 41007 | 4409 | 38 |
2212213 | 2212213 | 2022-02-13 | Clatsop | Oregon | 41007 | 4379 | 38 |
2208960 | 2208960 | 2022-02-12 | Clatsop | Oregon | 41007 | 4379 | 38 |
2205707 | 2205707 | 2022-02-11 | Clatsop | Oregon | 41007 | 4379 | 38 |
2202454 | 2202454 | 2022-02-10 | Clatsop | Oregon | 41007 | 4361 | 38 |
2199200 | 2199200 | 2022-02-09 | Clatsop | Oregon | 41007 | 4334 | 38 |
2195946 | 2195946 | 2022-02-08 | Clatsop | Oregon | 41007 | 4311 | 38 |
2192692 | 2192692 | 2022-02-07 | Clatsop | Oregon | 41007 | 4293 | 38 |
2189438 | 2189438 | 2022-02-06 | Clatsop | Oregon | 41007 | 4231 | 38 |
2186185 | 2186185 | 2022-02-05 | Clatsop | Oregon | 41007 | 4231 | 38 |
2182933 | 2182933 | 2022-02-04 | Clatsop | Oregon | 41007 | 4231 | 38 |
2179681 | 2179681 | 2022-02-03 | Clatsop | Oregon | 41007 | 4206 | 38 |
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);