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

1,535 rows where county = "Pennington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 2

fips 2

county 1

  • Pennington · 1,535 ✖
Link rowid date ▲ county state fips cases deaths
2500961 2500961 2022-05-13 Pennington Minnesota 27113 3687 41
2502096 2502096 2022-05-13 Pennington South Dakota 46103 32903 342
2497703 2497703 2022-05-12 Pennington Minnesota 27113 3685 41
2498838 2498838 2022-05-12 Pennington South Dakota 46103 32903 342
2494445 2494445 2022-05-11 Pennington Minnesota 27113 3673 41
2495580 2495580 2022-05-11 Pennington South Dakota 46103 32903 342
2491187 2491187 2022-05-10 Pennington Minnesota 27113 3664 41
2492322 2492322 2022-05-10 Pennington South Dakota 46103 32840 342
2487930 2487930 2022-05-09 Pennington Minnesota 27113 3659 41
2489064 2489064 2022-05-09 Pennington South Dakota 46103 32840 342
2484672 2484672 2022-05-08 Pennington Minnesota 27113 3656 41
2485807 2485807 2022-05-08 Pennington South Dakota 46103 32840 342
2481414 2481414 2022-05-07 Pennington Minnesota 27113 3656 41
2482549 2482549 2022-05-07 Pennington South Dakota 46103 32840 342
2478156 2478156 2022-05-06 Pennington Minnesota 27113 3656 41
2479291 2479291 2022-05-06 Pennington South Dakota 46103 32840 342
2474898 2474898 2022-05-05 Pennington Minnesota 27113 3645 41
2476033 2476033 2022-05-05 Pennington South Dakota 46103 32840 342
2471641 2471641 2022-05-04 Pennington Minnesota 27113 3635 41
2472776 2472776 2022-05-04 Pennington South Dakota 46103 32840 342
2468385 2468385 2022-05-03 Pennington Minnesota 27113 3628 41
2469520 2469520 2022-05-03 Pennington South Dakota 46103 32793 341
2465130 2465130 2022-05-02 Pennington Minnesota 27113 3624 41
2466264 2466264 2022-05-02 Pennington South Dakota 46103 32793 341
2461874 2461874 2022-05-01 Pennington Minnesota 27113 3620 41
2463009 2463009 2022-05-01 Pennington South Dakota 46103 32793 341
2458618 2458618 2022-04-30 Pennington Minnesota 27113 3620 41
2459753 2459753 2022-04-30 Pennington South Dakota 46103 32793 341
2455362 2455362 2022-04-29 Pennington Minnesota 27113 3620 41
2456497 2456497 2022-04-29 Pennington South Dakota 46103 32793 341
2452106 2452106 2022-04-28 Pennington Minnesota 27113 3617 41
2453241 2453241 2022-04-28 Pennington South Dakota 46103 32793 341
2448850 2448850 2022-04-27 Pennington Minnesota 27113 3604 41
2449985 2449985 2022-04-27 Pennington South Dakota 46103 32793 341
2445594 2445594 2022-04-26 Pennington Minnesota 27113 3598 41
2446728 2446728 2022-04-26 Pennington South Dakota 46103 32735 341
2442338 2442338 2022-04-25 Pennington Minnesota 27113 3594 41
2443473 2443473 2022-04-25 Pennington South Dakota 46103 32735 341
2439082 2439082 2022-04-24 Pennington Minnesota 27113 3587 41
2440217 2440217 2022-04-24 Pennington South Dakota 46103 32735 341
2435826 2435826 2022-04-23 Pennington Minnesota 27113 3587 41
2436961 2436961 2022-04-23 Pennington South Dakota 46103 32735 341
2432570 2432570 2022-04-22 Pennington Minnesota 27113 3587 41
2433705 2433705 2022-04-22 Pennington South Dakota 46103 32735 341
2429314 2429314 2022-04-21 Pennington Minnesota 27113 3574 41
2430449 2430449 2022-04-21 Pennington South Dakota 46103 32735 341
2426058 2426058 2022-04-20 Pennington Minnesota 27113 3571 41
2427193 2427193 2022-04-20 Pennington South Dakota 46103 32735 341
2422802 2422802 2022-04-19 Pennington Minnesota 27113 3568 41
2423937 2423937 2022-04-19 Pennington South Dakota 46103 32705 341
2419546 2419546 2022-04-18 Pennington Minnesota 27113 3566 41
2420681 2420681 2022-04-18 Pennington South Dakota 46103 32705 341
2416290 2416290 2022-04-17 Pennington Minnesota 27113 3560 41
2417425 2417425 2022-04-17 Pennington South Dakota 46103 32705 341
2413034 2413034 2022-04-16 Pennington Minnesota 27113 3560 41
2414169 2414169 2022-04-16 Pennington South Dakota 46103 32705 341
2409778 2409778 2022-04-15 Pennington Minnesota 27113 3560 41
2410913 2410913 2022-04-15 Pennington South Dakota 46103 32705 341
2406522 2406522 2022-04-14 Pennington Minnesota 27113 3558 41
2407657 2407657 2022-04-14 Pennington South Dakota 46103 32705 341
2403266 2403266 2022-04-13 Pennington Minnesota 27113 3552 41
2404401 2404401 2022-04-13 Pennington South Dakota 46103 32705 341
2400012 2400012 2022-04-12 Pennington Minnesota 27113 3552 41
2401146 2401146 2022-04-12 Pennington South Dakota 46103 32674 340
2396756 2396756 2022-04-11 Pennington Minnesota 27113 3550 41
2397891 2397891 2022-04-11 Pennington South Dakota 46103 32674 340
2393501 2393501 2022-04-10 Pennington Minnesota 27113 3549 41
2394636 2394636 2022-04-10 Pennington South Dakota 46103 32674 340
2390245 2390245 2022-04-09 Pennington Minnesota 27113 3549 41
2391380 2391380 2022-04-09 Pennington South Dakota 46103 32674 340
2386989 2386989 2022-04-08 Pennington Minnesota 27113 3549 41
2388124 2388124 2022-04-08 Pennington South Dakota 46103 32674 340
2383734 2383734 2022-04-07 Pennington Minnesota 27113 3549 41
2384869 2384869 2022-04-07 Pennington South Dakota 46103 32674 340
2380479 2380479 2022-04-06 Pennington Minnesota 27113 3546 41
2381614 2381614 2022-04-06 Pennington South Dakota 46103 32674 340
2377224 2377224 2022-04-05 Pennington Minnesota 27113 3545 41
2378359 2378359 2022-04-05 Pennington South Dakota 46103 32660 340
2373972 2373972 2022-04-04 Pennington Minnesota 27113 3544 41
2375105 2375105 2022-04-04 Pennington South Dakota 46103 32660 340
2370719 2370719 2022-04-03 Pennington Minnesota 27113 3543 41
2371853 2371853 2022-04-03 Pennington South Dakota 46103 32660 340
2367466 2367466 2022-04-02 Pennington Minnesota 27113 3543 41
2368600 2368600 2022-04-02 Pennington South Dakota 46103 32660 340
2364213 2364213 2022-04-01 Pennington Minnesota 27113 3543 41
2365347 2365347 2022-04-01 Pennington South Dakota 46103 32660 340
2360959 2360959 2022-03-31 Pennington Minnesota 27113 3540 41
2362094 2362094 2022-03-31 Pennington South Dakota 46103 32660 340
2357705 2357705 2022-03-30 Pennington Minnesota 27113 3536 41
2358840 2358840 2022-03-30 Pennington South Dakota 46103 32660 340
2354452 2354452 2022-03-29 Pennington Minnesota 27113 3536 41
2355586 2355586 2022-03-29 Pennington South Dakota 46103 32635 338
2351200 2351200 2022-03-28 Pennington Minnesota 27113 3532 41
2352333 2352333 2022-03-28 Pennington South Dakota 46103 32635 338
2347947 2347947 2022-03-27 Pennington Minnesota 27113 3532 41
2349081 2349081 2022-03-27 Pennington South Dakota 46103 32635 338
2344694 2344694 2022-03-26 Pennington Minnesota 27113 3532 41
2345828 2345828 2022-03-26 Pennington South Dakota 46103 32635 338
2341441 2341441 2022-03-25 Pennington Minnesota 27113 3532 41
2342575 2342575 2022-03-25 Pennington South Dakota 46103 32635 338

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