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

778 rows where fips = 55051 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 55051 · 778 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502763 2502763 2022-05-13 Iron Wisconsin 55051 1482 47
2499505 2499505 2022-05-12 Iron Wisconsin 55051 1481 47
2496247 2496247 2022-05-11 Iron Wisconsin 55051 1480 47
2492989 2492989 2022-05-10 Iron Wisconsin 55051 1481 47
2489731 2489731 2022-05-09 Iron Wisconsin 55051 1480 47
2486474 2486474 2022-05-08 Iron Wisconsin 55051 1480 47
2483216 2483216 2022-05-07 Iron Wisconsin 55051 1480 47
2479958 2479958 2022-05-06 Iron Wisconsin 55051 1480 47
2476700 2476700 2022-05-05 Iron Wisconsin 55051 1479 47
2473442 2473442 2022-05-04 Iron Wisconsin 55051 1475 47
2470185 2470185 2022-05-03 Iron Wisconsin 55051 1474 47
2466929 2466929 2022-05-02 Iron Wisconsin 55051 1474 47
2463674 2463674 2022-05-01 Iron Wisconsin 55051 1473 47
2460418 2460418 2022-04-30 Iron Wisconsin 55051 1473 47
2457162 2457162 2022-04-29 Iron Wisconsin 55051 1473 47
2453906 2453906 2022-04-28 Iron Wisconsin 55051 1473 47
2450650 2450650 2022-04-27 Iron Wisconsin 55051 1471 47
2447394 2447394 2022-04-26 Iron Wisconsin 55051 1471 47
2444138 2444138 2022-04-25 Iron Wisconsin 55051 1471 47
2440882 2440882 2022-04-24 Iron Wisconsin 55051 1470 47
2437626 2437626 2022-04-23 Iron Wisconsin 55051 1470 47
2434370 2434370 2022-04-22 Iron Wisconsin 55051 1470 47
2431114 2431114 2022-04-21 Iron Wisconsin 55051 1469 47
2427858 2427858 2022-04-20 Iron Wisconsin 55051 1469 47
2424602 2424602 2022-04-19 Iron Wisconsin 55051 1469 47
2421346 2421346 2022-04-18 Iron Wisconsin 55051 1469 47
2418090 2418090 2022-04-17 Iron Wisconsin 55051 1468 47
2414834 2414834 2022-04-16 Iron Wisconsin 55051 1468 47
2411578 2411578 2022-04-15 Iron Wisconsin 55051 1468 47
2408322 2408322 2022-04-14 Iron Wisconsin 55051 1468 47
2405066 2405066 2022-04-13 Iron Wisconsin 55051 1468 47
2401811 2401811 2022-04-12 Iron Wisconsin 55051 1468 47
2398556 2398556 2022-04-11 Iron Wisconsin 55051 1468 47
2395301 2395301 2022-04-10 Iron Wisconsin 55051 1468 47
2392045 2392045 2022-04-09 Iron Wisconsin 55051 1468 47
2388789 2388789 2022-04-08 Iron Wisconsin 55051 1468 47
2385534 2385534 2022-04-07 Iron Wisconsin 55051 1467 47
2382279 2382279 2022-04-06 Iron Wisconsin 55051 1467 47
2379024 2379024 2022-04-05 Iron Wisconsin 55051 1466 47
2375770 2375770 2022-04-04 Iron Wisconsin 55051 1466 47
2372518 2372518 2022-04-03 Iron Wisconsin 55051 1466 47
2369265 2369265 2022-04-02 Iron Wisconsin 55051 1466 47
2366012 2366012 2022-04-01 Iron Wisconsin 55051 1466 47
2362759 2362759 2022-03-31 Iron Wisconsin 55051 1466 47
2359505 2359505 2022-03-30 Iron Wisconsin 55051 1466 47
2356251 2356251 2022-03-29 Iron Wisconsin 55051 1464 47
2352998 2352998 2022-03-28 Iron Wisconsin 55051 1464 47
2349746 2349746 2022-03-27 Iron Wisconsin 55051 1464 47
2346493 2346493 2022-03-26 Iron Wisconsin 55051 1464 47
2343240 2343240 2022-03-25 Iron Wisconsin 55051 1464 47
2339987 2339987 2022-03-24 Iron Wisconsin 55051 1463 47
2336734 2336734 2022-03-23 Iron Wisconsin 55051 1463 47
2333480 2333480 2022-03-22 Iron Wisconsin 55051 1463 47
2330226 2330226 2022-03-21 Iron Wisconsin 55051 1463 47
2326974 2326974 2022-03-20 Iron Wisconsin 55051 1463 47
2323721 2323721 2022-03-19 Iron Wisconsin 55051 1463 47
2320467 2320467 2022-03-18 Iron Wisconsin 55051 1463 47
2317213 2317213 2022-03-17 Iron Wisconsin 55051 1462 47
2313960 2313960 2022-03-16 Iron Wisconsin 55051 1462 47
2310707 2310707 2022-03-15 Iron Wisconsin 55051 1461 47
2307454 2307454 2022-03-14 Iron Wisconsin 55051 1461 47
2304203 2304203 2022-03-13 Iron Wisconsin 55051 1461 47
2300951 2300951 2022-03-12 Iron Wisconsin 55051 1461 47
2297699 2297699 2022-03-11 Iron Wisconsin 55051 1461 47
2294447 2294447 2022-03-10 Iron Wisconsin 55051 1461 47
2291195 2291195 2022-03-09 Iron Wisconsin 55051 1461 47
2287943 2287943 2022-03-08 Iron Wisconsin 55051 1461 47
2284691 2284691 2022-03-07 Iron Wisconsin 55051 1460 47
2281439 2281439 2022-03-06 Iron Wisconsin 55051 1458 47
2278186 2278186 2022-03-05 Iron Wisconsin 55051 1458 47
2274933 2274933 2022-03-04 Iron Wisconsin 55051 1458 47
2271680 2271680 2022-03-03 Iron Wisconsin 55051 1458 46
2268428 2268428 2022-03-02 Iron Wisconsin 55051 1458 46
2265175 2265175 2022-03-01 Iron Wisconsin 55051 1458 46
2261925 2261925 2022-02-28 Iron Wisconsin 55051 1458 46
2258674 2258674 2022-02-27 Iron Wisconsin 55051 1456 46
2255423 2255423 2022-02-26 Iron Wisconsin 55051 1456 46
2252172 2252172 2022-02-25 Iron Wisconsin 55051 1456 46
2248921 2248921 2022-02-24 Iron Wisconsin 55051 1456 45
2245670 2245670 2022-02-23 Iron Wisconsin 55051 1455 45
2242419 2242419 2022-02-22 Iron Wisconsin 55051 1455 45
2239168 2239168 2022-02-21 Iron Wisconsin 55051 1455 45
2235917 2235917 2022-02-20 Iron Wisconsin 55051 1455 45
2232666 2232666 2022-02-19 Iron Wisconsin 55051 1455 45
2229415 2229415 2022-02-18 Iron Wisconsin 55051 1455 45
2226164 2226164 2022-02-17 Iron Wisconsin 55051 1454 45
2222913 2222913 2022-02-16 Iron Wisconsin 55051 1452 45
2219662 2219662 2022-02-15 Iron Wisconsin 55051 1452 45
2216412 2216412 2022-02-14 Iron Wisconsin 55051 1452 45
2213161 2213161 2022-02-13 Iron Wisconsin 55051 1450 45
2209908 2209908 2022-02-12 Iron Wisconsin 55051 1450 45
2206655 2206655 2022-02-11 Iron Wisconsin 55051 1450 45
2203402 2203402 2022-02-10 Iron Wisconsin 55051 1449 45
2200148 2200148 2022-02-09 Iron Wisconsin 55051 1448 45
2196894 2196894 2022-02-08 Iron Wisconsin 55051 1447 45
2193639 2193639 2022-02-07 Iron Wisconsin 55051 1446 45
2190386 2190386 2022-02-06 Iron Wisconsin 55051 1436 45
2187133 2187133 2022-02-05 Iron Wisconsin 55051 1436 45
2183880 2183880 2022-02-04 Iron Wisconsin 55051 1436 45
2180628 2180628 2022-02-03 Iron Wisconsin 55051 1431 45

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