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

711 rows where county = "Iron" and state = "Michigan" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Michigan · 711 ✖

fips 1

county 1

  • Iron · 711 ✖
Link rowid date ▲ county state fips cases deaths
2500856 2500856 2022-05-13 Iron Michigan 26071 2673 86
2497598 2497598 2022-05-12 Iron Michigan 26071 2673 86
2494340 2494340 2022-05-11 Iron Michigan 26071 2673 86
2491082 2491082 2022-05-10 Iron Michigan 26071 2659 87
2487825 2487825 2022-05-09 Iron Michigan 26071 2659 87
2484567 2484567 2022-05-08 Iron Michigan 26071 2659 87
2481309 2481309 2022-05-07 Iron Michigan 26071 2659 87
2478051 2478051 2022-05-06 Iron Michigan 26071 2659 87
2474793 2474793 2022-05-05 Iron Michigan 26071 2659 87
2471536 2471536 2022-05-04 Iron Michigan 26071 2659 87
2468280 2468280 2022-05-03 Iron Michigan 26071 2653 87
2465025 2465025 2022-05-02 Iron Michigan 26071 2653 87
2461769 2461769 2022-05-01 Iron Michigan 26071 2653 87
2458513 2458513 2022-04-30 Iron Michigan 26071 2653 87
2455257 2455257 2022-04-29 Iron Michigan 26071 2653 87
2452001 2452001 2022-04-28 Iron Michigan 26071 2653 87
2448745 2448745 2022-04-27 Iron Michigan 26071 2653 87
2445489 2445489 2022-04-26 Iron Michigan 26071 2649 87
2442233 2442233 2022-04-25 Iron Michigan 26071 2649 87
2438977 2438977 2022-04-24 Iron Michigan 26071 2649 87
2435721 2435721 2022-04-23 Iron Michigan 26071 2649 87
2432465 2432465 2022-04-22 Iron Michigan 26071 2649 87
2429209 2429209 2022-04-21 Iron Michigan 26071 2649 87
2425953 2425953 2022-04-20 Iron Michigan 26071 2649 87
2422697 2422697 2022-04-19 Iron Michigan 26071 2644 87
2419441 2419441 2022-04-18 Iron Michigan 26071 2644 87
2416185 2416185 2022-04-17 Iron Michigan 26071 2644 87
2412929 2412929 2022-04-16 Iron Michigan 26071 2644 87
2409673 2409673 2022-04-15 Iron Michigan 26071 2644 87
2406417 2406417 2022-04-14 Iron Michigan 26071 2644 87
2403161 2403161 2022-04-13 Iron Michigan 26071 2644 87
2399907 2399907 2022-04-12 Iron Michigan 26071 2643 87
2396651 2396651 2022-04-11 Iron Michigan 26071 2643 87
2393396 2393396 2022-04-10 Iron Michigan 26071 2643 87
2390140 2390140 2022-04-09 Iron Michigan 26071 2643 87
2386884 2386884 2022-04-08 Iron Michigan 26071 2643 87
2383629 2383629 2022-04-07 Iron Michigan 26071 2643 87
2380374 2380374 2022-04-06 Iron Michigan 26071 2643 87
2377119 2377119 2022-04-05 Iron Michigan 26071 2644 87
2373867 2373867 2022-04-04 Iron Michigan 26071 2644 87
2370614 2370614 2022-04-03 Iron Michigan 26071 2644 87
2367361 2367361 2022-04-02 Iron Michigan 26071 2644 87
2364108 2364108 2022-04-01 Iron Michigan 26071 2644 87
2360854 2360854 2022-03-31 Iron Michigan 26071 2644 87
2357600 2357600 2022-03-30 Iron Michigan 26071 2644 87
2354347 2354347 2022-03-29 Iron Michigan 26071 2646 87
2351095 2351095 2022-03-28 Iron Michigan 26071 2646 87
2347842 2347842 2022-03-27 Iron Michigan 26071 2643 87
2344589 2344589 2022-03-26 Iron Michigan 26071 2643 87
2341336 2341336 2022-03-25 Iron Michigan 26071 2643 87
2338083 2338083 2022-03-24 Iron Michigan 26071 2643 86
2334829 2334829 2022-03-23 Iron Michigan 26071 2643 86
2331575 2331575 2022-03-22 Iron Michigan 26071 2643 86
2328323 2328323 2022-03-21 Iron Michigan 26071 2643 86
2325070 2325070 2022-03-20 Iron Michigan 26071 2643 86
2321816 2321816 2022-03-19 Iron Michigan 26071 2643 86
2318562 2318562 2022-03-18 Iron Michigan 26071 2643 86
2315309 2315309 2022-03-17 Iron Michigan 26071 2643 86
2312056 2312056 2022-03-16 Iron Michigan 26071 2643 86
2308803 2308803 2022-03-15 Iron Michigan 26071 2641 86
2305552 2305552 2022-03-14 Iron Michigan 26071 2641 86
2302300 2302300 2022-03-13 Iron Michigan 26071 2637 86
2299048 2299048 2022-03-12 Iron Michigan 26071 2637 86
2295796 2295796 2022-03-11 Iron Michigan 26071 2637 86
2292544 2292544 2022-03-10 Iron Michigan 26071 2637 86
2289292 2289292 2022-03-09 Iron Michigan 26071 2637 86
2286041 2286041 2022-03-08 Iron Michigan 26071 2637 85
2282789 2282789 2022-03-07 Iron Michigan 26071 2637 85
2279536 2279536 2022-03-06 Iron Michigan 26071 2636 85
2276283 2276283 2022-03-05 Iron Michigan 26071 2636 85
2273030 2273030 2022-03-04 Iron Michigan 26071 2636 85
2269778 2269778 2022-03-03 Iron Michigan 26071 2630 85
2266525 2266525 2022-03-02 Iron Michigan 26071 2630 85
2263274 2263274 2022-03-01 Iron Michigan 26071 2625 83
2260023 2260023 2022-02-28 Iron Michigan 26071 2625 83
2256772 2256772 2022-02-27 Iron Michigan 26071 2622 83
2253521 2253521 2022-02-26 Iron Michigan 26071 2622 83
2250270 2250270 2022-02-25 Iron Michigan 26071 2622 83
2247019 2247019 2022-02-24 Iron Michigan 26071 2620 83
2243768 2243768 2022-02-23 Iron Michigan 26071 2620 83
2240517 2240517 2022-02-22 Iron Michigan 26071 2612 82
2237266 2237266 2022-02-21 Iron Michigan 26071 2612 82
2234015 2234015 2022-02-20 Iron Michigan 26071 2612 82
2230764 2230764 2022-02-19 Iron Michigan 26071 2602 81
2227513 2227513 2022-02-18 Iron Michigan 26071 2602 81
2224262 2224262 2022-02-17 Iron Michigan 26071 2602 81
2221011 2221011 2022-02-16 Iron Michigan 26071 2602 81
2217760 2217760 2022-02-15 Iron Michigan 26071 2593 81
2214509 2214509 2022-02-14 Iron Michigan 26071 2593 81
2211257 2211257 2022-02-13 Iron Michigan 26071 2583 79
2208004 2208004 2022-02-12 Iron Michigan 26071 2583 79
2204751 2204751 2022-02-11 Iron Michigan 26071 2583 79
2201498 2201498 2022-02-10 Iron Michigan 26071 2571 79
2198244 2198244 2022-02-09 Iron Michigan 26071 2571 79
2194990 2194990 2022-02-08 Iron Michigan 26071 2554 79
2191736 2191736 2022-02-07 Iron Michigan 26071 2554 79
2188483 2188483 2022-02-06 Iron Michigan 26071 2540 79
2185230 2185230 2022-02-05 Iron Michigan 26071 2540 79
2181978 2181978 2022-02-04 Iron Michigan 26071 2540 79
2178726 2178726 2022-02-03 Iron Michigan 26071 2514 79

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