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

701 rows where fips = 49033 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 · 701 ✖

fips 1

  • 49033 · 701 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502478 2502478 2022-05-13 Rich Utah 49033 343 0
2499220 2499220 2022-05-12 Rich Utah 49033 343 0
2495962 2495962 2022-05-11 Rich Utah 49033 342 0
2492704 2492704 2022-05-10 Rich Utah 49033 342 0
2489446 2489446 2022-05-09 Rich Utah 49033 342 0
2486188 2486188 2022-05-08 Rich Utah 49033 340 0
2482930 2482930 2022-05-07 Rich Utah 49033 340 0
2479672 2479672 2022-05-06 Rich Utah 49033 340 0
2476414 2476414 2022-05-05 Rich Utah 49033 340 0
2473157 2473157 2022-05-04 Rich Utah 49033 339 0
2469901 2469901 2022-05-03 Rich Utah 49033 339 0
2466645 2466645 2022-05-02 Rich Utah 49033 339 0
2463390 2463390 2022-05-01 Rich Utah 49033 339 0
2460134 2460134 2022-04-30 Rich Utah 49033 339 0
2456878 2456878 2022-04-29 Rich Utah 49033 339 0
2453622 2453622 2022-04-28 Rich Utah 49033 339 0
2450366 2450366 2022-04-27 Rich Utah 49033 339 0
2447109 2447109 2022-04-26 Rich Utah 49033 339 0
2443854 2443854 2022-04-25 Rich Utah 49033 339 0
2440598 2440598 2022-04-24 Rich Utah 49033 339 0
2437342 2437342 2022-04-23 Rich Utah 49033 339 0
2434086 2434086 2022-04-22 Rich Utah 49033 339 0
2430830 2430830 2022-04-21 Rich Utah 49033 339 0
2427574 2427574 2022-04-20 Rich Utah 49033 339 0
2424318 2424318 2022-04-19 Rich Utah 49033 339 0
2421062 2421062 2022-04-18 Rich Utah 49033 338 0
2417806 2417806 2022-04-17 Rich Utah 49033 338 0
2414550 2414550 2022-04-16 Rich Utah 49033 338 0
2411294 2411294 2022-04-15 Rich Utah 49033 338 0
2408038 2408038 2022-04-14 Rich Utah 49033 338 0
2404782 2404782 2022-04-13 Rich Utah 49033 338 0
2401527 2401527 2022-04-12 Rich Utah 49033 338 0
2398272 2398272 2022-04-11 Rich Utah 49033 338 0
2395017 2395017 2022-04-10 Rich Utah 49033 338 0
2391761 2391761 2022-04-09 Rich Utah 49033 338 0
2388505 2388505 2022-04-08 Rich Utah 49033 338 0
2385250 2385250 2022-04-07 Rich Utah 49033 338 0
2381995 2381995 2022-04-06 Rich Utah 49033 338 0
2378740 2378740 2022-04-05 Rich Utah 49033 338 0
2375486 2375486 2022-04-04 Rich Utah 49033 338 0
2372234 2372234 2022-04-03 Rich Utah 49033 338 0
2368981 2368981 2022-04-02 Rich Utah 49033 338 0
2365728 2365728 2022-04-01 Rich Utah 49033 338 0
2362475 2362475 2022-03-31 Rich Utah 49033 338 0
2359221 2359221 2022-03-30 Rich Utah 49033 338 0
2355967 2355967 2022-03-29 Rich Utah 49033 338 0
2352714 2352714 2022-03-28 Rich Utah 49033 338 0
2349462 2349462 2022-03-27 Rich Utah 49033 338 0
2346209 2346209 2022-03-26 Rich Utah 49033 338 0
2342956 2342956 2022-03-25 Rich Utah 49033 338 0
2339703 2339703 2022-03-24 Rich Utah 49033 337 0
2336449 2336449 2022-03-23 Rich Utah 49033 337 0
2333195 2333195 2022-03-22 Rich Utah 49033 337 0
2329942 2329942 2022-03-21 Rich Utah 49033 338 0
2326690 2326690 2022-03-20 Rich Utah 49033 338 0
2323437 2323437 2022-03-19 Rich Utah 49033 338 0
2320183 2320183 2022-03-18 Rich Utah 49033 338 0
2316929 2316929 2022-03-17 Rich Utah 49033 338 0
2313676 2313676 2022-03-16 Rich Utah 49033 338 0
2310423 2310423 2022-03-15 Rich Utah 49033 338 0
2307170 2307170 2022-03-14 Rich Utah 49033 338 0
2303919 2303919 2022-03-13 Rich Utah 49033 338 0
2300667 2300667 2022-03-12 Rich Utah 49033 338 0
2297415 2297415 2022-03-11 Rich Utah 49033 338 0
2294163 2294163 2022-03-10 Rich Utah 49033 338 0
2290911 2290911 2022-03-09 Rich Utah 49033 338 0
2287659 2287659 2022-03-08 Rich Utah 49033 338 0
2284407 2284407 2022-03-07 Rich Utah 49033 338 0
2281155 2281155 2022-03-06 Rich Utah 49033 338 0
2277902 2277902 2022-03-05 Rich Utah 49033 338 0
2274649 2274649 2022-03-04 Rich Utah 49033 338 0
2271396 2271396 2022-03-03 Rich Utah 49033 338 0
2268144 2268144 2022-03-02 Rich Utah 49033 336 0
2264891 2264891 2022-03-01 Rich Utah 49033 336 0
2261641 2261641 2022-02-28 Rich Utah 49033 335 0
2258390 2258390 2022-02-27 Rich Utah 49033 334 0
2255139 2255139 2022-02-26 Rich Utah 49033 334 0
2251888 2251888 2022-02-25 Rich Utah 49033 334 0
2248637 2248637 2022-02-24 Rich Utah 49033 334 0
2245386 2245386 2022-02-23 Rich Utah 49033 333 0
2242135 2242135 2022-02-22 Rich Utah 49033 331 0
2238884 2238884 2022-02-21 Rich Utah 49033 330 0
2235633 2235633 2022-02-20 Rich Utah 49033 330 0
2232382 2232382 2022-02-19 Rich Utah 49033 330 0
2229131 2229131 2022-02-18 Rich Utah 49033 330 0
2225880 2225880 2022-02-17 Rich Utah 49033 330 0
2222629 2222629 2022-02-16 Rich Utah 49033 329 0
2219378 2219378 2022-02-15 Rich Utah 49033 328 0
2216127 2216127 2022-02-14 Rich Utah 49033 328 0
2212876 2212876 2022-02-13 Rich Utah 49033 328 0
2209623 2209623 2022-02-12 Rich Utah 49033 328 0
2206370 2206370 2022-02-11 Rich Utah 49033 328 0
2203117 2203117 2022-02-10 Rich Utah 49033 328 0
2199863 2199863 2022-02-09 Rich Utah 49033 329 0
2196609 2196609 2022-02-08 Rich Utah 49033 329 0
2193355 2193355 2022-02-07 Rich Utah 49033 329 0
2190102 2190102 2022-02-06 Rich Utah 49033 328 0
2186849 2186849 2022-02-05 Rich Utah 49033 328 0
2183596 2183596 2022-02-04 Rich Utah 49033 328 0
2180344 2180344 2022-02-03 Rich Utah 49033 327 0

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