home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

809 rows where fips = 49035 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Utah 809

fips 1

  • 49035 · 809 ✖

county 1

  • Salt Lake 809
Link rowid date ▲ county state fips cases deaths
2502479 2502479 2022-05-13 Salt Lake Utah 49035 346815 1637
2499221 2499221 2022-05-12 Salt Lake Utah 49035 346815 1637
2495963 2495963 2022-05-11 Salt Lake Utah 49035 346386 1638
2492705 2492705 2022-05-10 Salt Lake Utah 49035 346102 1638
2489447 2489447 2022-05-09 Salt Lake Utah 49035 345839 1638
2486189 2486189 2022-05-08 Salt Lake Utah 49035 345101 1638
2482931 2482931 2022-05-07 Salt Lake Utah 49035 345101 1638
2479673 2479673 2022-05-06 Salt Lake Utah 49035 345101 1638
2476415 2476415 2022-05-05 Salt Lake Utah 49035 345101 1638
2473158 2473158 2022-05-04 Salt Lake Utah 49035 344452 1632
2469902 2469902 2022-05-03 Salt Lake Utah 49035 344452 1632
2466646 2466646 2022-05-02 Salt Lake Utah 49035 344218 1632
2463391 2463391 2022-05-01 Salt Lake Utah 49035 343420 1632
2460135 2460135 2022-04-30 Salt Lake Utah 49035 343420 1632
2456879 2456879 2022-04-29 Salt Lake Utah 49035 343420 1632
2453623 2453623 2022-04-28 Salt Lake Utah 49035 343420 1632
2450367 2450367 2022-04-27 Salt Lake Utah 49035 342854 1630
2447110 2447110 2022-04-26 Salt Lake Utah 49035 342854 1630
2443855 2443855 2022-04-25 Salt Lake Utah 49035 342854 1630
2440599 2440599 2022-04-24 Salt Lake Utah 49035 342597 1630
2437343 2437343 2022-04-23 Salt Lake Utah 49035 342597 1630
2434087 2434087 2022-04-22 Salt Lake Utah 49035 342598 1630
2430831 2430831 2022-04-21 Salt Lake Utah 49035 342563 1630
2427575 2427575 2022-04-20 Salt Lake Utah 49035 342249 1628
2424319 2424319 2022-04-19 Salt Lake Utah 49035 342249 1628
2421063 2421063 2022-04-18 Salt Lake Utah 49035 341980 1628
2417807 2417807 2022-04-17 Salt Lake Utah 49035 341980 1628
2414551 2414551 2022-04-16 Salt Lake Utah 49035 341980 1628
2411295 2411295 2022-04-15 Salt Lake Utah 49035 341980 1628
2408039 2408039 2022-04-14 Salt Lake Utah 49035 341980 1628
2404783 2404783 2022-04-13 Salt Lake Utah 49035 341630 1626
2401528 2401528 2022-04-12 Salt Lake Utah 49035 341630 1626
2398273 2398273 2022-04-11 Salt Lake Utah 49035 341630 1626
2395018 2395018 2022-04-10 Salt Lake Utah 49035 341630 1626
2391762 2391762 2022-04-09 Salt Lake Utah 49035 341630 1626
2388506 2388506 2022-04-08 Salt Lake Utah 49035 341630 1626
2385251 2385251 2022-04-07 Salt Lake Utah 49035 341630 1626
2381996 2381996 2022-04-06 Salt Lake Utah 49035 341302 1621
2378741 2378741 2022-04-05 Salt Lake Utah 49035 341302 1621
2375487 2375487 2022-04-04 Salt Lake Utah 49035 341302 1621
2372235 2372235 2022-04-03 Salt Lake Utah 49035 341302 1621
2368982 2368982 2022-04-02 Salt Lake Utah 49035 341302 1621
2365729 2365729 2022-04-01 Salt Lake Utah 49035 341302 1621
2362476 2362476 2022-03-31 Salt Lake Utah 49035 341302 1621
2359222 2359222 2022-03-30 Salt Lake Utah 49035 341243 1621
2355968 2355968 2022-03-29 Salt Lake Utah 49035 341182 1621
2352715 2352715 2022-03-28 Salt Lake Utah 49035 341133 1620
2349463 2349463 2022-03-27 Salt Lake Utah 49035 341030 1619
2346210 2346210 2022-03-26 Salt Lake Utah 49035 341030 1619
2342957 2342957 2022-03-25 Salt Lake Utah 49035 341030 1619
2339704 2339704 2022-03-24 Salt Lake Utah 49035 340920 1616
2336450 2336450 2022-03-23 Salt Lake Utah 49035 340835 1606
2333196 2333196 2022-03-22 Salt Lake Utah 49035 340797 1603
2329943 2329943 2022-03-21 Salt Lake Utah 49035 340769 1593
2326691 2326691 2022-03-20 Salt Lake Utah 49035 340606 1591
2323438 2323438 2022-03-19 Salt Lake Utah 49035 340606 1591
2320184 2320184 2022-03-18 Salt Lake Utah 49035 340606 1591
2316930 2316930 2022-03-17 Salt Lake Utah 49035 340558 1591
2313677 2313677 2022-03-16 Salt Lake Utah 49035 340483 1589
2310424 2310424 2022-03-15 Salt Lake Utah 49035 340399 1588
2307171 2307171 2022-03-14 Salt Lake Utah 49035 340366 1585
2303920 2303920 2022-03-13 Salt Lake Utah 49035 340203 1582
2300668 2300668 2022-03-12 Salt Lake Utah 49035 340203 1582
2297416 2297416 2022-03-11 Salt Lake Utah 49035 340203 1582
2294164 2294164 2022-03-10 Salt Lake Utah 49035 340102 1577
2290912 2290912 2022-03-09 Salt Lake Utah 49035 340022 1573
2287660 2287660 2022-03-08 Salt Lake Utah 49035 339958 1570
2284408 2284408 2022-03-07 Salt Lake Utah 49035 339945 1561
2281156 2281156 2022-03-06 Salt Lake Utah 49035 339700 1556
2277903 2277903 2022-03-05 Salt Lake Utah 49035 339700 1556
2274650 2274650 2022-03-04 Salt Lake Utah 49035 339700 1556
2271397 2271397 2022-03-03 Salt Lake Utah 49035 339590 1552
2268145 2268145 2022-03-02 Salt Lake Utah 49035 339395 1550
2264892 2264892 2022-03-01 Salt Lake Utah 49035 339208 1544
2261642 2261642 2022-02-28 Salt Lake Utah 49035 339132 1544
2258391 2258391 2022-02-27 Salt Lake Utah 49035 338729 1543
2255140 2255140 2022-02-26 Salt Lake Utah 49035 338729 1543
2251889 2251889 2022-02-25 Salt Lake Utah 49035 338729 1543
2248638 2248638 2022-02-24 Salt Lake Utah 49035 338537 1540
2245387 2245387 2022-02-23 Salt Lake Utah 49035 338268 1535
2242136 2242136 2022-02-22 Salt Lake Utah 49035 338093 1528
2238885 2238885 2022-02-21 Salt Lake Utah 49035 337331 1521
2235634 2235634 2022-02-20 Salt Lake Utah 49035 337331 1521
2232383 2232383 2022-02-19 Salt Lake Utah 49035 337331 1521
2229132 2229132 2022-02-18 Salt Lake Utah 49035 337331 1521
2225881 2225881 2022-02-17 Salt Lake Utah 49035 337008 1518
2222630 2222630 2022-02-16 Salt Lake Utah 49035 336590 1516
2219379 2219379 2022-02-15 Salt Lake Utah 49035 336090 1512
2216128 2216128 2022-02-14 Salt Lake Utah 49035 335822 1507
2212877 2212877 2022-02-13 Salt Lake Utah 49035 334737 1498
2209624 2209624 2022-02-12 Salt Lake Utah 49035 334737 1498
2206371 2206371 2022-02-11 Salt Lake Utah 49035 334737 1498
2203118 2203118 2022-02-10 Salt Lake Utah 49035 334087 1494
2199864 2199864 2022-02-09 Salt Lake Utah 49035 333352 1492
2196610 2196610 2022-02-08 Salt Lake Utah 49035 332599 1487
2193356 2193356 2022-02-07 Salt Lake Utah 49035 332179 1474
2190103 2190103 2022-02-06 Salt Lake Utah 49035 330201 1465
2186850 2186850 2022-02-05 Salt Lake Utah 49035 330201 1465
2183597 2183597 2022-02-04 Salt Lake Utah 49035 330201 1465
2180345 2180345 2022-02-03 Salt Lake Utah 49035 329323 1462

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);
Powered by Datasette · Queries took 45.891ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette