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

793 rows where county = "Clackamas" 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

county 1

  • Clackamas · 793 ✖
Link rowid date ▲ county state fips cases deaths
2501813 2501813 2022-05-13 Clackamas Oregon 41005 63827 632
2498555 2498555 2022-05-12 Clackamas Oregon 41005 63625 632
2495297 2495297 2022-05-11 Clackamas Oregon 41005 63447 632
2492039 2492039 2022-05-10 Clackamas Oregon 41005 63267 631
2488781 2488781 2022-05-09 Clackamas Oregon 41005 63071 630
2485524 2485524 2022-05-08 Clackamas Oregon 41005 62664 629
2482266 2482266 2022-05-07 Clackamas Oregon 41005 62664 629
2479008 2479008 2022-05-06 Clackamas Oregon 41005 62664 629
2475750 2475750 2022-05-05 Clackamas Oregon 41005 62522 629
2472493 2472493 2022-05-04 Clackamas Oregon 41005 62310 629
2469237 2469237 2022-05-03 Clackamas Oregon 41005 62133 629
2465981 2465981 2022-05-02 Clackamas Oregon 41005 61893 629
2462726 2462726 2022-05-01 Clackamas Oregon 41005 61749 629
2459470 2459470 2022-04-30 Clackamas Oregon 41005 61749 629
2456214 2456214 2022-04-29 Clackamas Oregon 41005 61749 629
2452958 2452958 2022-04-28 Clackamas Oregon 41005 61565 629
2449702 2449702 2022-04-27 Clackamas Oregon 41005 61449 629
2446445 2446445 2022-04-26 Clackamas Oregon 41005 61304 629
2443190 2443190 2022-04-25 Clackamas Oregon 41005 61143 629
2439934 2439934 2022-04-24 Clackamas Oregon 41005 60996 628
2436678 2436678 2022-04-23 Clackamas Oregon 41005 60996 628
2433422 2433422 2022-04-22 Clackamas Oregon 41005 60996 628
2430166 2430166 2022-04-21 Clackamas Oregon 41005 60899 628
2426910 2426910 2022-04-20 Clackamas Oregon 41005 60811 627
2423654 2423654 2022-04-19 Clackamas Oregon 41005 60737 627
2420397 2420397 2022-04-18 Clackamas Oregon 41005 60494 620
2417142 2417142 2022-04-17 Clackamas Oregon 41005 60494 620
2413886 2413886 2022-04-16 Clackamas Oregon 41005 60494 620
2410630 2410630 2022-04-15 Clackamas Oregon 41005 60494 620
2407374 2407374 2022-04-14 Clackamas Oregon 41005 60450 616
2404118 2404118 2022-04-13 Clackamas Oregon 41005 60388 615
2400863 2400863 2022-04-12 Clackamas Oregon 41005 60312 614
2397608 2397608 2022-04-11 Clackamas Oregon 41005 60255 605
2394353 2394353 2022-04-10 Clackamas Oregon 41005 60196 605
2391097 2391097 2022-04-09 Clackamas Oregon 41005 60196 605
2387841 2387841 2022-04-08 Clackamas Oregon 41005 60196 605
2384586 2384586 2022-04-07 Clackamas Oregon 41005 60154 602
2381331 2381331 2022-04-06 Clackamas Oregon 41005 60114 590
2378076 2378076 2022-04-05 Clackamas Oregon 41005 60076 589
2374822 2374822 2022-04-04 Clackamas Oregon 41005 60034 589
2371570 2371570 2022-04-03 Clackamas Oregon 41005 59978 581
2368317 2368317 2022-04-02 Clackamas Oregon 41005 59978 581
2365064 2365064 2022-04-01 Clackamas Oregon 41005 59978 581
2361811 2361811 2022-03-31 Clackamas Oregon 41005 59937 581
2358557 2358557 2022-03-30 Clackamas Oregon 41005 59906 581
2355303 2355303 2022-03-29 Clackamas Oregon 41005 59877 581
2352050 2352050 2022-03-28 Clackamas Oregon 41005 59825 574
2348798 2348798 2022-03-27 Clackamas Oregon 41005 59788 572
2345545 2345545 2022-03-26 Clackamas Oregon 41005 59788 572
2342292 2342292 2022-03-25 Clackamas Oregon 41005 59788 572
2339039 2339039 2022-03-24 Clackamas Oregon 41005 59771 572
2335785 2335785 2022-03-23 Clackamas Oregon 41005 59747 569
2332531 2332531 2022-03-22 Clackamas Oregon 41005 59731 567
2329278 2329278 2022-03-21 Clackamas Oregon 41005 59715 567
2326026 2326026 2022-03-20 Clackamas Oregon 41005 59674 565
2322773 2322773 2022-03-19 Clackamas Oregon 41005 59674 565
2319519 2319519 2022-03-18 Clackamas Oregon 41005 59674 565
2316265 2316265 2022-03-17 Clackamas Oregon 41005 59652 562
2313012 2313012 2022-03-16 Clackamas Oregon 41005 59640 556
2309759 2309759 2022-03-15 Clackamas Oregon 41005 59627 552
2306506 2306506 2022-03-14 Clackamas Oregon 41005 59587 550
2303255 2303255 2022-03-13 Clackamas Oregon 41005 59482 549
2300003 2300003 2022-03-12 Clackamas Oregon 41005 59482 549
2296751 2296751 2022-03-11 Clackamas Oregon 41005 59482 549
2293499 2293499 2022-03-10 Clackamas Oregon 41005 59455 547
2290247 2290247 2022-03-09 Clackamas Oregon 41005 59431 541
2286995 2286995 2022-03-08 Clackamas Oregon 41005 59402 539
2283743 2283743 2022-03-07 Clackamas Oregon 41005 59381 538
2280491 2280491 2022-03-06 Clackamas Oregon 41005 59292 530
2277238 2277238 2022-03-05 Clackamas Oregon 41005 59292 530
2273985 2273985 2022-03-04 Clackamas Oregon 41005 59292 530
2270732 2270732 2022-03-03 Clackamas Oregon 41005 59260 527
2267480 2267480 2022-03-02 Clackamas Oregon 41005 59207 525
2264227 2264227 2022-03-01 Clackamas Oregon 41005 59154 524
2260977 2260977 2022-02-28 Clackamas Oregon 41005 59101 524
2257726 2257726 2022-02-27 Clackamas Oregon 41005 58948 522
2254475 2254475 2022-02-26 Clackamas Oregon 41005 58948 522
2251224 2251224 2022-02-25 Clackamas Oregon 41005 58948 522
2247973 2247973 2022-02-24 Clackamas Oregon 41005 58889 522
2244722 2244722 2022-02-23 Clackamas Oregon 41005 58810 514
2241471 2241471 2022-02-22 Clackamas Oregon 41005 58730 514
2238220 2238220 2022-02-21 Clackamas Oregon 41005 58446 512
2234969 2234969 2022-02-20 Clackamas Oregon 41005 58446 512
2231718 2231718 2022-02-19 Clackamas Oregon 41005 58446 512
2228467 2228467 2022-02-18 Clackamas Oregon 41005 58446 512
2225216 2225216 2022-02-17 Clackamas Oregon 41005 58350 512
2221965 2221965 2022-02-16 Clackamas Oregon 41005 58221 507
2218714 2218714 2022-02-15 Clackamas Oregon 41005 58089 507
2215463 2215463 2022-02-14 Clackamas Oregon 41005 57988 507
2212212 2212212 2022-02-13 Clackamas Oregon 41005 57585 506
2208959 2208959 2022-02-12 Clackamas Oregon 41005 57585 506
2205706 2205706 2022-02-11 Clackamas Oregon 41005 57585 506
2202453 2202453 2022-02-10 Clackamas Oregon 41005 57359 503
2199199 2199199 2022-02-09 Clackamas Oregon 41005 57147 497
2195945 2195945 2022-02-08 Clackamas Oregon 41005 56932 491
2192691 2192691 2022-02-07 Clackamas Oregon 41005 56665 490
2189437 2189437 2022-02-06 Clackamas Oregon 41005 56017 488
2186184 2186184 2022-02-05 Clackamas Oregon 41005 56017 488
2182932 2182932 2022-02-04 Clackamas Oregon 41005 56017 488
2179680 2179680 2022-02-03 Clackamas Oregon 41005 55639 485

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