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

782 rows where county = "Iron" 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 · 782 ✖

fips 1

county 1

  • Iron · 782 ✖
Link rowid date ▲ county state fips cases deaths
2502472 2502472 2022-05-13 Iron Utah 49021 14774 92
2499214 2499214 2022-05-12 Iron Utah 49021 14774 92
2495956 2495956 2022-05-11 Iron Utah 49021 14771 92
2492698 2492698 2022-05-10 Iron Utah 49021 14765 92
2489440 2489440 2022-05-09 Iron Utah 49021 14765 92
2486182 2486182 2022-05-08 Iron Utah 49021 14756 91
2482924 2482924 2022-05-07 Iron Utah 49021 14756 91
2479666 2479666 2022-05-06 Iron Utah 49021 14756 91
2476408 2476408 2022-05-05 Iron Utah 49021 14756 91
2473151 2473151 2022-05-04 Iron Utah 49021 14749 91
2469895 2469895 2022-05-03 Iron Utah 49021 14749 91
2466639 2466639 2022-05-02 Iron Utah 49021 14746 91
2463384 2463384 2022-05-01 Iron Utah 49021 14729 90
2460128 2460128 2022-04-30 Iron Utah 49021 14729 90
2456872 2456872 2022-04-29 Iron Utah 49021 14729 90
2453616 2453616 2022-04-28 Iron Utah 49021 14729 90
2450360 2450360 2022-04-27 Iron Utah 49021 14716 90
2447103 2447103 2022-04-26 Iron Utah 49021 14716 90
2443848 2443848 2022-04-25 Iron Utah 49021 14716 90
2440592 2440592 2022-04-24 Iron Utah 49021 14706 90
2437336 2437336 2022-04-23 Iron Utah 49021 14706 90
2434080 2434080 2022-04-22 Iron Utah 49021 14706 90
2430824 2430824 2022-04-21 Iron Utah 49021 14701 90
2427568 2427568 2022-04-20 Iron Utah 49021 14694 90
2424312 2424312 2022-04-19 Iron Utah 49021 14694 90
2421056 2421056 2022-04-18 Iron Utah 49021 14679 90
2417800 2417800 2022-04-17 Iron Utah 49021 14679 90
2414544 2414544 2022-04-16 Iron Utah 49021 14679 90
2411288 2411288 2022-04-15 Iron Utah 49021 14679 90
2408032 2408032 2022-04-14 Iron Utah 49021 14679 90
2404776 2404776 2022-04-13 Iron Utah 49021 14668 90
2401521 2401521 2022-04-12 Iron Utah 49021 14668 90
2398266 2398266 2022-04-11 Iron Utah 49021 14668 90
2395011 2395011 2022-04-10 Iron Utah 49021 14668 90
2391755 2391755 2022-04-09 Iron Utah 49021 14668 90
2388499 2388499 2022-04-08 Iron Utah 49021 14668 90
2385244 2385244 2022-04-07 Iron Utah 49021 14668 90
2381989 2381989 2022-04-06 Iron Utah 49021 14663 90
2378734 2378734 2022-04-05 Iron Utah 49021 14663 90
2375480 2375480 2022-04-04 Iron Utah 49021 14663 90
2372228 2372228 2022-04-03 Iron Utah 49021 14663 90
2368975 2368975 2022-04-02 Iron Utah 49021 14663 90
2365722 2365722 2022-04-01 Iron Utah 49021 14663 90
2362469 2362469 2022-03-31 Iron Utah 49021 14663 90
2359215 2359215 2022-03-30 Iron Utah 49021 14663 90
2355961 2355961 2022-03-29 Iron Utah 49021 14662 90
2352708 2352708 2022-03-28 Iron Utah 49021 14660 90
2349456 2349456 2022-03-27 Iron Utah 49021 14654 90
2346203 2346203 2022-03-26 Iron Utah 49021 14654 90
2342950 2342950 2022-03-25 Iron Utah 49021 14654 90
2339697 2339697 2022-03-24 Iron Utah 49021 14654 90
2336443 2336443 2022-03-23 Iron Utah 49021 14654 88
2333189 2333189 2022-03-22 Iron Utah 49021 14652 85
2329936 2329936 2022-03-21 Iron Utah 49021 14650 85
2326684 2326684 2022-03-20 Iron Utah 49021 14645 85
2323431 2323431 2022-03-19 Iron Utah 49021 14645 85
2320177 2320177 2022-03-18 Iron Utah 49021 14645 85
2316923 2316923 2022-03-17 Iron Utah 49021 14643 85
2313670 2313670 2022-03-16 Iron Utah 49021 14643 85
2310417 2310417 2022-03-15 Iron Utah 49021 14642 85
2307164 2307164 2022-03-14 Iron Utah 49021 14636 85
2303913 2303913 2022-03-13 Iron Utah 49021 14636 85
2300661 2300661 2022-03-12 Iron Utah 49021 14636 85
2297409 2297409 2022-03-11 Iron Utah 49021 14636 85
2294157 2294157 2022-03-10 Iron Utah 49021 14633 85
2290905 2290905 2022-03-09 Iron Utah 49021 14632 85
2287653 2287653 2022-03-08 Iron Utah 49021 14628 85
2284401 2284401 2022-03-07 Iron Utah 49021 14617 84
2281149 2281149 2022-03-06 Iron Utah 49021 14617 84
2277896 2277896 2022-03-05 Iron Utah 49021 14617 84
2274643 2274643 2022-03-04 Iron Utah 49021 14617 84
2271390 2271390 2022-03-03 Iron Utah 49021 14617 84
2268138 2268138 2022-03-02 Iron Utah 49021 14611 84
2264885 2264885 2022-03-01 Iron Utah 49021 14605 84
2261635 2261635 2022-02-28 Iron Utah 49021 14601 84
2258384 2258384 2022-02-27 Iron Utah 49021 14586 83
2255133 2255133 2022-02-26 Iron Utah 49021 14586 83
2251882 2251882 2022-02-25 Iron Utah 49021 14586 83
2248631 2248631 2022-02-24 Iron Utah 49021 14581 83
2245380 2245380 2022-02-23 Iron Utah 49021 14573 83
2242129 2242129 2022-02-22 Iron Utah 49021 14568 83
2238878 2238878 2022-02-21 Iron Utah 49021 14545 83
2235627 2235627 2022-02-20 Iron Utah 49021 14545 83
2232376 2232376 2022-02-19 Iron Utah 49021 14545 83
2229125 2229125 2022-02-18 Iron Utah 49021 14545 83
2225874 2225874 2022-02-17 Iron Utah 49021 14535 83
2222623 2222623 2022-02-16 Iron Utah 49021 14526 83
2219372 2219372 2022-02-15 Iron Utah 49021 14512 83
2216121 2216121 2022-02-14 Iron Utah 49021 14502 83
2212870 2212870 2022-02-13 Iron Utah 49021 14474 82
2209617 2209617 2022-02-12 Iron Utah 49021 14474 82
2206364 2206364 2022-02-11 Iron Utah 49021 14474 82
2203111 2203111 2022-02-10 Iron Utah 49021 14455 82
2199857 2199857 2022-02-09 Iron Utah 49021 14425 82
2196603 2196603 2022-02-08 Iron Utah 49021 14380 82
2193349 2193349 2022-02-07 Iron Utah 49021 14367 82
2190096 2190096 2022-02-06 Iron Utah 49021 14269 82
2186843 2186843 2022-02-05 Iron Utah 49021 14269 82
2183590 2183590 2022-02-04 Iron Utah 49021 14269 82
2180338 2180338 2022-02-03 Iron Utah 49021 14235 81

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