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

785 rows where county = "Washington" and state = "Alabama" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Alabama · 785 ✖

fips 1

county 1

  • Washington · 785 ✖
Link rowid date ▲ county state fips cases deaths
2499639 2499639 2022-05-13 Washington Alabama 1129 3736 59
2496381 2496381 2022-05-12 Washington Alabama 1129 3735 59
2493123 2493123 2022-05-11 Washington Alabama 1129 3735 59
2489865 2489865 2022-05-10 Washington Alabama 1129 3734 59
2486608 2486608 2022-05-09 Washington Alabama 1129 3733 59
2483350 2483350 2022-05-08 Washington Alabama 1129 3731 59
2480092 2480092 2022-05-07 Washington Alabama 1129 3731 59
2476834 2476834 2022-05-06 Washington Alabama 1129 3731 59
2473576 2473576 2022-05-05 Washington Alabama 1129 3731 59
2470319 2470319 2022-05-04 Washington Alabama 1129 3730 59
2467063 2467063 2022-05-03 Washington Alabama 1129 3730 59
2463808 2463808 2022-05-02 Washington Alabama 1129 3730 59
2460552 2460552 2022-05-01 Washington Alabama 1129 3730 59
2457296 2457296 2022-04-30 Washington Alabama 1129 3730 59
2454040 2454040 2022-04-29 Washington Alabama 1129 3730 59
2450784 2450784 2022-04-28 Washington Alabama 1129 3730 59
2447528 2447528 2022-04-27 Washington Alabama 1129 3731 59
2444272 2444272 2022-04-26 Washington Alabama 1129 3730 59
2441016 2441016 2022-04-25 Washington Alabama 1129 3730 59
2437760 2437760 2022-04-24 Washington Alabama 1129 3730 59
2434504 2434504 2022-04-23 Washington Alabama 1129 3730 59
2431248 2431248 2022-04-22 Washington Alabama 1129 3730 59
2427992 2427992 2022-04-21 Washington Alabama 1129 3730 59
2424736 2424736 2022-04-20 Washington Alabama 1129 3730 59
2421480 2421480 2022-04-19 Washington Alabama 1129 3730 59
2418224 2418224 2022-04-18 Washington Alabama 1129 3731 59
2414968 2414968 2022-04-17 Washington Alabama 1129 3731 59
2411712 2411712 2022-04-16 Washington Alabama 1129 3731 59
2408456 2408456 2022-04-15 Washington Alabama 1129 3731 59
2405200 2405200 2022-04-14 Washington Alabama 1129 3731 59
2401945 2401945 2022-04-13 Washington Alabama 1129 3731 59
2398690 2398690 2022-04-12 Washington Alabama 1129 3731 59
2395435 2395435 2022-04-11 Washington Alabama 1129 3731 59
2392179 2392179 2022-04-10 Washington Alabama 1129 3731 59
2388923 2388923 2022-04-09 Washington Alabama 1129 3731 59
2385668 2385668 2022-04-08 Washington Alabama 1129 3731 59
2382413 2382413 2022-04-07 Washington Alabama 1129 3731 59
2379158 2379158 2022-04-06 Washington Alabama 1129 3731 59
2375904 2375904 2022-04-05 Washington Alabama 1129 3731 59
2372652 2372652 2022-04-04 Washington Alabama 1129 3730 59
2369399 2369399 2022-04-03 Washington Alabama 1129 3730 59
2366146 2366146 2022-04-02 Washington Alabama 1129 3730 59
2362893 2362893 2022-04-01 Washington Alabama 1129 3730 59
2359639 2359639 2022-03-31 Washington Alabama 1129 3730 59
2356385 2356385 2022-03-30 Washington Alabama 1129 3730 59
2353132 2353132 2022-03-29 Washington Alabama 1129 3728 59
2349880 2349880 2022-03-28 Washington Alabama 1129 3728 59
2346627 2346627 2022-03-27 Washington Alabama 1129 3725 59
2343374 2343374 2022-03-26 Washington Alabama 1129 3725 59
2340121 2340121 2022-03-25 Washington Alabama 1129 3725 59
2336868 2336868 2022-03-24 Washington Alabama 1129 3724 59
2333614 2333614 2022-03-23 Washington Alabama 1129 3724 59
2330360 2330360 2022-03-22 Washington Alabama 1129 3724 59
2327108 2327108 2022-03-21 Washington Alabama 1129 3722 58
2323855 2323855 2022-03-20 Washington Alabama 1129 3722 58
2320601 2320601 2022-03-19 Washington Alabama 1129 3722 58
2317347 2317347 2022-03-18 Washington Alabama 1129 3722 58
2314094 2314094 2022-03-17 Washington Alabama 1129 3721 58
2310841 2310841 2022-03-16 Washington Alabama 1129 3721 58
2307588 2307588 2022-03-15 Washington Alabama 1129 3721 58
2304337 2304337 2022-03-14 Washington Alabama 1129 3721 58
2301085 2301085 2022-03-13 Washington Alabama 1129 3720 58
2297833 2297833 2022-03-12 Washington Alabama 1129 3720 58
2294581 2294581 2022-03-11 Washington Alabama 1129 3720 58
2291329 2291329 2022-03-10 Washington Alabama 1129 3720 57
2288077 2288077 2022-03-09 Washington Alabama 1129 3719 57
2284825 2284825 2022-03-08 Washington Alabama 1129 3719 57
2281573 2281573 2022-03-07 Washington Alabama 1129 3718 57
2278320 2278320 2022-03-06 Washington Alabama 1129 3717 56
2275067 2275067 2022-03-05 Washington Alabama 1129 3717 56
2271814 2271814 2022-03-04 Washington Alabama 1129 3717 56
2268562 2268562 2022-03-03 Washington Alabama 1129 3714 56
2265309 2265309 2022-03-02 Washington Alabama 1129 3710 55
2262059 2262059 2022-03-01 Washington Alabama 1129 3689 55
2258808 2258808 2022-02-28 Washington Alabama 1129 3678 55
2255557 2255557 2022-02-27 Washington Alabama 1129 3678 55
2252306 2252306 2022-02-26 Washington Alabama 1129 3678 55
2249055 2249055 2022-02-25 Washington Alabama 1129 3669 55
2245804 2245804 2022-02-24 Washington Alabama 1129 3667 54
2242553 2242553 2022-02-23 Washington Alabama 1129 3663 54
2239302 2239302 2022-02-22 Washington Alabama 1129 3659 53
2236051 2236051 2022-02-21 Washington Alabama 1129 3654 53
2232800 2232800 2022-02-20 Washington Alabama 1129 3653 53
2229549 2229549 2022-02-19 Washington Alabama 1129 3653 53
2226298 2226298 2022-02-18 Washington Alabama 1129 3649 53
2223047 2223047 2022-02-17 Washington Alabama 1129 3646 53
2219796 2219796 2022-02-16 Washington Alabama 1129 3642 53
2216546 2216546 2022-02-15 Washington Alabama 1129 3637 53
2213295 2213295 2022-02-14 Washington Alabama 1129 3632 53
2210042 2210042 2022-02-13 Washington Alabama 1129 3632 53
2206789 2206789 2022-02-12 Washington Alabama 1129 3630 53
2203536 2203536 2022-02-11 Washington Alabama 1129 3629 53
2200282 2200282 2022-02-10 Washington Alabama 1129 3606 53
2197028 2197028 2022-02-09 Washington Alabama 1129 3574 53
2193773 2193773 2022-02-08 Washington Alabama 1129 3538 53
2190520 2190520 2022-02-07 Washington Alabama 1129 3501 53
2187267 2187267 2022-02-06 Washington Alabama 1129 3495 53
2184014 2184014 2022-02-05 Washington Alabama 1129 3495 53
2180762 2180762 2022-02-04 Washington Alabama 1129 3491 53
2177511 2177511 2022-02-03 Washington Alabama 1129 3462 53

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