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 = "Union" and fips = 41061 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

  • 41061 · 785 ✖

county 1

  • Union · 785 ✖
Link rowid date ▲ county state fips cases deaths
2501841 2501841 2022-05-13 Union Oregon 41061 5068 80
2498583 2498583 2022-05-12 Union Oregon 41061 5063 80
2495325 2495325 2022-05-11 Union Oregon 41061 5063 80
2492067 2492067 2022-05-10 Union Oregon 41061 5060 80
2488809 2488809 2022-05-09 Union Oregon 41061 5043 79
2485552 2485552 2022-05-08 Union Oregon 41061 5034 79
2482294 2482294 2022-05-07 Union Oregon 41061 5034 79
2479036 2479036 2022-05-06 Union Oregon 41061 5034 79
2475778 2475778 2022-05-05 Union Oregon 41061 5034 79
2472521 2472521 2022-05-04 Union Oregon 41061 5034 79
2469265 2469265 2022-05-03 Union Oregon 41061 5027 79
2466009 2466009 2022-05-02 Union Oregon 41061 5027 79
2462754 2462754 2022-05-01 Union Oregon 41061 5027 79
2459498 2459498 2022-04-30 Union Oregon 41061 5027 79
2456242 2456242 2022-04-29 Union Oregon 41061 5027 79
2452986 2452986 2022-04-28 Union Oregon 41061 5027 79
2449730 2449730 2022-04-27 Union Oregon 41061 5027 79
2446473 2446473 2022-04-26 Union Oregon 41061 5027 79
2443218 2443218 2022-04-25 Union Oregon 41061 5027 78
2439962 2439962 2022-04-24 Union Oregon 41061 5027 78
2436706 2436706 2022-04-23 Union Oregon 41061 5027 78
2433450 2433450 2022-04-22 Union Oregon 41061 5027 78
2430194 2430194 2022-04-21 Union Oregon 41061 5027 78
2426938 2426938 2022-04-20 Union Oregon 41061 5027 78
2423682 2423682 2022-04-19 Union Oregon 41061 5025 78
2420425 2420425 2022-04-18 Union Oregon 41061 5024 78
2417170 2417170 2022-04-17 Union Oregon 41061 5024 78
2413914 2413914 2022-04-16 Union Oregon 41061 5024 78
2410658 2410658 2022-04-15 Union Oregon 41061 5024 78
2407402 2407402 2022-04-14 Union Oregon 41061 5022 77
2404146 2404146 2022-04-13 Union Oregon 41061 5021 76
2400891 2400891 2022-04-12 Union Oregon 41061 5021 76
2397636 2397636 2022-04-11 Union Oregon 41061 5020 76
2394381 2394381 2022-04-10 Union Oregon 41061 5020 76
2391125 2391125 2022-04-09 Union Oregon 41061 5020 76
2387869 2387869 2022-04-08 Union Oregon 41061 5020 76
2384614 2384614 2022-04-07 Union Oregon 41061 5020 76
2381359 2381359 2022-04-06 Union Oregon 41061 5018 76
2378104 2378104 2022-04-05 Union Oregon 41061 5018 76
2374850 2374850 2022-04-04 Union Oregon 41061 5017 76
2371598 2371598 2022-04-03 Union Oregon 41061 5016 76
2368345 2368345 2022-04-02 Union Oregon 41061 5016 76
2365092 2365092 2022-04-01 Union Oregon 41061 5016 76
2361839 2361839 2022-03-31 Union Oregon 41061 5016 76
2358585 2358585 2022-03-30 Union Oregon 41061 5016 76
2355331 2355331 2022-03-29 Union Oregon 41061 5016 75
2352078 2352078 2022-03-28 Union Oregon 41061 5013 74
2348826 2348826 2022-03-27 Union Oregon 41061 5013 74
2345573 2345573 2022-03-26 Union Oregon 41061 5013 74
2342320 2342320 2022-03-25 Union Oregon 41061 5013 74
2339067 2339067 2022-03-24 Union Oregon 41061 5013 74
2335813 2335813 2022-03-23 Union Oregon 41061 5012 74
2332559 2332559 2022-03-22 Union Oregon 41061 5012 74
2329306 2329306 2022-03-21 Union Oregon 41061 5011 74
2326054 2326054 2022-03-20 Union Oregon 41061 5009 74
2322801 2322801 2022-03-19 Union Oregon 41061 5009 74
2319547 2319547 2022-03-18 Union Oregon 41061 5009 74
2316293 2316293 2022-03-17 Union Oregon 41061 5009 74
2313040 2313040 2022-03-16 Union Oregon 41061 5007 74
2309787 2309787 2022-03-15 Union Oregon 41061 5007 74
2306534 2306534 2022-03-14 Union Oregon 41061 5007 74
2303283 2303283 2022-03-13 Union Oregon 41061 5007 74
2300031 2300031 2022-03-12 Union Oregon 41061 5007 74
2296779 2296779 2022-03-11 Union Oregon 41061 5007 74
2293527 2293527 2022-03-10 Union Oregon 41061 5006 74
2290275 2290275 2022-03-09 Union Oregon 41061 5005 74
2287023 2287023 2022-03-08 Union Oregon 41061 5004 74
2283771 2283771 2022-03-07 Union Oregon 41061 5000 74
2280519 2280519 2022-03-06 Union Oregon 41061 5002 74
2277266 2277266 2022-03-05 Union Oregon 41061 5002 74
2274013 2274013 2022-03-04 Union Oregon 41061 5002 74
2270760 2270760 2022-03-03 Union Oregon 41061 5000 74
2267508 2267508 2022-03-02 Union Oregon 41061 4998 73
2264255 2264255 2022-03-01 Union Oregon 41061 4997 73
2261005 2261005 2022-02-28 Union Oregon 41061 4989 73
2257754 2257754 2022-02-27 Union Oregon 41061 4986 73
2254503 2254503 2022-02-26 Union Oregon 41061 4986 73
2251252 2251252 2022-02-25 Union Oregon 41061 4986 73
2248001 2248001 2022-02-24 Union Oregon 41061 4983 73
2244750 2244750 2022-02-23 Union Oregon 41061 4980 72
2241499 2241499 2022-02-22 Union Oregon 41061 4961 72
2238248 2238248 2022-02-21 Union Oregon 41061 4950 72
2234997 2234997 2022-02-20 Union Oregon 41061 4950 72
2231746 2231746 2022-02-19 Union Oregon 41061 4950 72
2228495 2228495 2022-02-18 Union Oregon 41061 4950 72
2225244 2225244 2022-02-17 Union Oregon 41061 4942 71
2221993 2221993 2022-02-16 Union Oregon 41061 4930 71
2218742 2218742 2022-02-15 Union Oregon 41061 4926 71
2215491 2215491 2022-02-14 Union Oregon 41061 4915 71
2212240 2212240 2022-02-13 Union Oregon 41061 4875 71
2208987 2208987 2022-02-12 Union Oregon 41061 4875 71
2205734 2205734 2022-02-11 Union Oregon 41061 4875 71
2202481 2202481 2022-02-10 Union Oregon 41061 4860 70
2199227 2199227 2022-02-09 Union Oregon 41061 4840 70
2195973 2195973 2022-02-08 Union Oregon 41061 4825 70
2192719 2192719 2022-02-07 Union Oregon 41061 4791 70
2189465 2189465 2022-02-06 Union Oregon 41061 4769 70
2186212 2186212 2022-02-05 Union Oregon 41061 4769 70
2182960 2182960 2022-02-04 Union Oregon 41061 4769 70
2179708 2179708 2022-02-03 Union Oregon 41061 4726 67

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