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

3,034 rows where county = "Iron" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 4

fips 4

county 1

  • Iron · 3,034 ✖
Link rowid date ▲ county state fips cases deaths
2500856 2500856 2022-05-13 Iron Michigan 26071 2673 86
2501122 2501122 2022-05-13 Iron Missouri 29093 2200 44
2502472 2502472 2022-05-13 Iron Utah 49021 14774 92
2502763 2502763 2022-05-13 Iron Wisconsin 55051 1482 47
2497598 2497598 2022-05-12 Iron Michigan 26071 2673 86
2497864 2497864 2022-05-12 Iron Missouri 29093 2198 44
2499214 2499214 2022-05-12 Iron Utah 49021 14774 92
2499505 2499505 2022-05-12 Iron Wisconsin 55051 1481 47
2494340 2494340 2022-05-11 Iron Michigan 26071 2673 86
2494606 2494606 2022-05-11 Iron Missouri 29093 2198 44
2495956 2495956 2022-05-11 Iron Utah 49021 14771 92
2496247 2496247 2022-05-11 Iron Wisconsin 55051 1480 47
2491082 2491082 2022-05-10 Iron Michigan 26071 2659 87
2491348 2491348 2022-05-10 Iron Missouri 29093 2198 44
2492698 2492698 2022-05-10 Iron Utah 49021 14765 92
2492989 2492989 2022-05-10 Iron Wisconsin 55051 1481 47
2487825 2487825 2022-05-09 Iron Michigan 26071 2659 87
2488090 2488090 2022-05-09 Iron Missouri 29093 2198 44
2489440 2489440 2022-05-09 Iron Utah 49021 14765 92
2489731 2489731 2022-05-09 Iron Wisconsin 55051 1480 47
2484567 2484567 2022-05-08 Iron Michigan 26071 2659 87
2484833 2484833 2022-05-08 Iron Missouri 29093 2198 44
2486182 2486182 2022-05-08 Iron Utah 49021 14756 91
2486474 2486474 2022-05-08 Iron Wisconsin 55051 1480 47
2481309 2481309 2022-05-07 Iron Michigan 26071 2659 87
2481575 2481575 2022-05-07 Iron Missouri 29093 2198 44
2482924 2482924 2022-05-07 Iron Utah 49021 14756 91
2483216 2483216 2022-05-07 Iron Wisconsin 55051 1480 47
2478051 2478051 2022-05-06 Iron Michigan 26071 2659 87
2478317 2478317 2022-05-06 Iron Missouri 29093 2198 44
2479666 2479666 2022-05-06 Iron Utah 49021 14756 91
2479958 2479958 2022-05-06 Iron Wisconsin 55051 1480 47
2474793 2474793 2022-05-05 Iron Michigan 26071 2659 87
2475059 2475059 2022-05-05 Iron Missouri 29093 2197 44
2476408 2476408 2022-05-05 Iron Utah 49021 14756 91
2476700 2476700 2022-05-05 Iron Wisconsin 55051 1479 47
2471536 2471536 2022-05-04 Iron Michigan 26071 2659 87
2471802 2471802 2022-05-04 Iron Missouri 29093 2197 43
2473151 2473151 2022-05-04 Iron Utah 49021 14749 91
2473442 2473442 2022-05-04 Iron Wisconsin 55051 1475 47
2468280 2468280 2022-05-03 Iron Michigan 26071 2653 87
2468546 2468546 2022-05-03 Iron Missouri 29093 2197 43
2469895 2469895 2022-05-03 Iron Utah 49021 14749 91
2470185 2470185 2022-05-03 Iron Wisconsin 55051 1474 47
2465025 2465025 2022-05-02 Iron Michigan 26071 2653 87
2465290 2465290 2022-05-02 Iron Missouri 29093 2197 43
2466639 2466639 2022-05-02 Iron Utah 49021 14746 91
2466929 2466929 2022-05-02 Iron Wisconsin 55051 1474 47
2461769 2461769 2022-05-01 Iron Michigan 26071 2653 87
2462035 2462035 2022-05-01 Iron Missouri 29093 2197 43
2463384 2463384 2022-05-01 Iron Utah 49021 14729 90
2463674 2463674 2022-05-01 Iron Wisconsin 55051 1473 47
2458513 2458513 2022-04-30 Iron Michigan 26071 2653 87
2458779 2458779 2022-04-30 Iron Missouri 29093 2197 43
2460128 2460128 2022-04-30 Iron Utah 49021 14729 90
2460418 2460418 2022-04-30 Iron Wisconsin 55051 1473 47
2455257 2455257 2022-04-29 Iron Michigan 26071 2653 87
2455523 2455523 2022-04-29 Iron Missouri 29093 2197 43
2456872 2456872 2022-04-29 Iron Utah 49021 14729 90
2457162 2457162 2022-04-29 Iron Wisconsin 55051 1473 47
2452001 2452001 2022-04-28 Iron Michigan 26071 2653 87
2452267 2452267 2022-04-28 Iron Missouri 29093 2197 43
2453616 2453616 2022-04-28 Iron Utah 49021 14729 90
2453906 2453906 2022-04-28 Iron Wisconsin 55051 1473 47
2448745 2448745 2022-04-27 Iron Michigan 26071 2653 87
2449011 2449011 2022-04-27 Iron Missouri 29093 2197 43
2450360 2450360 2022-04-27 Iron Utah 49021 14716 90
2450650 2450650 2022-04-27 Iron Wisconsin 55051 1471 47
2445489 2445489 2022-04-26 Iron Michigan 26071 2649 87
2445754 2445754 2022-04-26 Iron Missouri 29093 2197 43
2447103 2447103 2022-04-26 Iron Utah 49021 14716 90
2447394 2447394 2022-04-26 Iron Wisconsin 55051 1471 47
2442233 2442233 2022-04-25 Iron Michigan 26071 2649 87
2442499 2442499 2022-04-25 Iron Missouri 29093 2197 43
2443848 2443848 2022-04-25 Iron Utah 49021 14716 90
2444138 2444138 2022-04-25 Iron Wisconsin 55051 1471 47
2438977 2438977 2022-04-24 Iron Michigan 26071 2649 87
2439243 2439243 2022-04-24 Iron Missouri 29093 2197 43
2440592 2440592 2022-04-24 Iron Utah 49021 14706 90
2440882 2440882 2022-04-24 Iron Wisconsin 55051 1470 47
2435721 2435721 2022-04-23 Iron Michigan 26071 2649 87
2435987 2435987 2022-04-23 Iron Missouri 29093 2197 43
2437336 2437336 2022-04-23 Iron Utah 49021 14706 90
2437626 2437626 2022-04-23 Iron Wisconsin 55051 1470 47
2432465 2432465 2022-04-22 Iron Michigan 26071 2649 87
2432731 2432731 2022-04-22 Iron Missouri 29093 2197 43
2434080 2434080 2022-04-22 Iron Utah 49021 14706 90
2434370 2434370 2022-04-22 Iron Wisconsin 55051 1470 47
2429209 2429209 2022-04-21 Iron Michigan 26071 2649 87
2429475 2429475 2022-04-21 Iron Missouri 29093 2197 43
2430824 2430824 2022-04-21 Iron Utah 49021 14701 90
2431114 2431114 2022-04-21 Iron Wisconsin 55051 1469 47
2425953 2425953 2022-04-20 Iron Michigan 26071 2649 87
2426219 2426219 2022-04-20 Iron Missouri 29093 2197 43
2427568 2427568 2022-04-20 Iron Utah 49021 14694 90
2427858 2427858 2022-04-20 Iron Wisconsin 55051 1469 47
2422697 2422697 2022-04-19 Iron Michigan 26071 2644 87
2422963 2422963 2022-04-19 Iron Missouri 29093 2197 43
2424312 2424312 2022-04-19 Iron Utah 49021 14694 90
2424602 2424602 2022-04-19 Iron Wisconsin 55051 1469 47

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