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

787 rows where county = "Cache", fips = 49005 and state = "Utah" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Utah · 787 ✖

fips 1

  • 49005 · 787 ✖

county 1

  • Cache · 787 ✖
Link rowid date ▲ county state fips cases deaths
2502464 2502464 2022-05-13 Cache Utah 49005 37265 109
2499206 2499206 2022-05-12 Cache Utah 49005 37265 109
2495948 2495948 2022-05-11 Cache Utah 49005 37254 109
2492690 2492690 2022-05-10 Cache Utah 49005 37241 109
2489432 2489432 2022-05-09 Cache Utah 49005 37229 109
2486174 2486174 2022-05-08 Cache Utah 49005 37203 109
2482916 2482916 2022-05-07 Cache Utah 49005 37203 109
2479658 2479658 2022-05-06 Cache Utah 49005 37203 109
2476400 2476400 2022-05-05 Cache Utah 49005 37203 109
2473143 2473143 2022-05-04 Cache Utah 49005 37192 109
2469887 2469887 2022-05-03 Cache Utah 49005 37192 109
2466631 2466631 2022-05-02 Cache Utah 49005 37187 109
2463376 2463376 2022-05-01 Cache Utah 49005 37159 109
2460120 2460120 2022-04-30 Cache Utah 49005 37159 109
2456864 2456864 2022-04-29 Cache Utah 49005 37159 109
2453608 2453608 2022-04-28 Cache Utah 49005 37159 109
2450352 2450352 2022-04-27 Cache Utah 49005 37152 109
2447095 2447095 2022-04-26 Cache Utah 49005 37152 109
2443840 2443840 2022-04-25 Cache Utah 49005 37152 109
2440584 2440584 2022-04-24 Cache Utah 49005 37142 109
2437328 2437328 2022-04-23 Cache Utah 49005 37142 109
2434072 2434072 2022-04-22 Cache Utah 49005 37142 109
2430816 2430816 2022-04-21 Cache Utah 49005 37135 109
2427560 2427560 2022-04-20 Cache Utah 49005 37127 109
2424304 2424304 2022-04-19 Cache Utah 49005 37127 109
2421048 2421048 2022-04-18 Cache Utah 49005 37113 109
2417792 2417792 2022-04-17 Cache Utah 49005 37113 109
2414536 2414536 2022-04-16 Cache Utah 49005 37113 109
2411280 2411280 2022-04-15 Cache Utah 49005 37113 109
2408024 2408024 2022-04-14 Cache Utah 49005 37113 109
2404768 2404768 2022-04-13 Cache Utah 49005 37095 109
2401513 2401513 2022-04-12 Cache Utah 49005 37095 109
2398258 2398258 2022-04-11 Cache Utah 49005 37095 109
2395003 2395003 2022-04-10 Cache Utah 49005 37095 109
2391747 2391747 2022-04-09 Cache Utah 49005 37095 109
2388491 2388491 2022-04-08 Cache Utah 49005 37095 109
2385236 2385236 2022-04-07 Cache Utah 49005 37095 109
2381981 2381981 2022-04-06 Cache Utah 49005 37080 109
2378726 2378726 2022-04-05 Cache Utah 49005 37080 109
2375472 2375472 2022-04-04 Cache Utah 49005 37080 109
2372220 2372220 2022-04-03 Cache Utah 49005 37080 109
2368967 2368967 2022-04-02 Cache Utah 49005 37080 109
2365714 2365714 2022-04-01 Cache Utah 49005 37080 109
2362461 2362461 2022-03-31 Cache Utah 49005 37080 109
2359207 2359207 2022-03-30 Cache Utah 49005 37074 109
2355953 2355953 2022-03-29 Cache Utah 49005 37071 109
2352700 2352700 2022-03-28 Cache Utah 49005 37069 109
2349448 2349448 2022-03-27 Cache Utah 49005 37066 108
2346195 2346195 2022-03-26 Cache Utah 49005 37066 108
2342942 2342942 2022-03-25 Cache Utah 49005 37066 108
2339689 2339689 2022-03-24 Cache Utah 49005 37052 106
2336435 2336435 2022-03-23 Cache Utah 49005 37037 106
2333181 2333181 2022-03-22 Cache Utah 49005 37032 105
2329928 2329928 2022-03-21 Cache Utah 49005 37030 104
2326676 2326676 2022-03-20 Cache Utah 49005 37024 104
2323423 2323423 2022-03-19 Cache Utah 49005 37024 104
2320169 2320169 2022-03-18 Cache Utah 49005 37024 104
2316915 2316915 2022-03-17 Cache Utah 49005 37022 104
2313662 2313662 2022-03-16 Cache Utah 49005 37014 104
2310409 2310409 2022-03-15 Cache Utah 49005 37001 104
2307156 2307156 2022-03-14 Cache Utah 49005 36984 104
2303905 2303905 2022-03-13 Cache Utah 49005 36984 104
2300653 2300653 2022-03-12 Cache Utah 49005 36984 104
2297401 2297401 2022-03-11 Cache Utah 49005 36984 104
2294149 2294149 2022-03-10 Cache Utah 49005 36978 103
2290897 2290897 2022-03-09 Cache Utah 49005 36973 101
2287645 2287645 2022-03-08 Cache Utah 49005 36965 100
2284393 2284393 2022-03-07 Cache Utah 49005 36940 100
2281141 2281141 2022-03-06 Cache Utah 49005 36940 100
2277888 2277888 2022-03-05 Cache Utah 49005 36940 100
2274635 2274635 2022-03-04 Cache Utah 49005 36940 100
2271382 2271382 2022-03-03 Cache Utah 49005 36932 99
2268130 2268130 2022-03-02 Cache Utah 49005 36926 99
2264877 2264877 2022-03-01 Cache Utah 49005 36915 98
2261627 2261627 2022-02-28 Cache Utah 49005 36911 98
2258376 2258376 2022-02-27 Cache Utah 49005 36885 98
2255125 2255125 2022-02-26 Cache Utah 49005 36885 98
2251874 2251874 2022-02-25 Cache Utah 49005 36885 98
2248623 2248623 2022-02-24 Cache Utah 49005 36864 98
2245372 2245372 2022-02-23 Cache Utah 49005 36835 98
2242121 2242121 2022-02-22 Cache Utah 49005 36811 98
2238870 2238870 2022-02-21 Cache Utah 49005 36733 98
2235619 2235619 2022-02-20 Cache Utah 49005 36733 98
2232368 2232368 2022-02-19 Cache Utah 49005 36733 98
2229117 2229117 2022-02-18 Cache Utah 49005 36733 98
2225866 2225866 2022-02-17 Cache Utah 49005 36698 98
2222615 2222615 2022-02-16 Cache Utah 49005 36669 98
2219364 2219364 2022-02-15 Cache Utah 49005 36602 98
2216113 2216113 2022-02-14 Cache Utah 49005 36578 98
2212862 2212862 2022-02-13 Cache Utah 49005 36428 95
2209609 2209609 2022-02-12 Cache Utah 49005 36428 95
2206356 2206356 2022-02-11 Cache Utah 49005 36428 95
2203103 2203103 2022-02-10 Cache Utah 49005 36353 93
2199849 2199849 2022-02-09 Cache Utah 49005 36278 93
2196595 2196595 2022-02-08 Cache Utah 49005 36179 92
2193341 2193341 2022-02-07 Cache Utah 49005 36137 90
2190088 2190088 2022-02-06 Cache Utah 49005 35870 89
2186835 2186835 2022-02-05 Cache Utah 49005 35870 89
2183582 2183582 2022-02-04 Cache Utah 49005 35870 89
2180330 2180330 2022-02-03 Cache Utah 49005 35712 89

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