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

782 rows where county = "Adams" and fips = 53001 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

  • 53001 · 782 ✖

county 1

  • Adams · 782 ✖
Link rowid date ▲ county state fips cases deaths
2502643 2502643 2022-05-13 Adams Washington 53001 4926 39
2499385 2499385 2022-05-12 Adams Washington 53001 4925 39
2496127 2496127 2022-05-11 Adams Washington 53001 4925 39
2492869 2492869 2022-05-10 Adams Washington 53001 4921 38
2489611 2489611 2022-05-09 Adams Washington 53001 4921 38
2486354 2486354 2022-05-08 Adams Washington 53001 4920 38
2483096 2483096 2022-05-07 Adams Washington 53001 4920 38
2479838 2479838 2022-05-06 Adams Washington 53001 4920 38
2476580 2476580 2022-05-05 Adams Washington 53001 4920 38
2473322 2473322 2022-05-04 Adams Washington 53001 4920 38
2470066 2470066 2022-05-03 Adams Washington 53001 4919 38
2466810 2466810 2022-05-02 Adams Washington 53001 4919 38
2463555 2463555 2022-05-01 Adams Washington 53001 4919 38
2460299 2460299 2022-04-30 Adams Washington 53001 4919 38
2457043 2457043 2022-04-29 Adams Washington 53001 4919 38
2453787 2453787 2022-04-28 Adams Washington 53001 4917 38
2450531 2450531 2022-04-27 Adams Washington 53001 4917 38
2447275 2447275 2022-04-26 Adams Washington 53001 4916 38
2444019 2444019 2022-04-25 Adams Washington 53001 4916 38
2440763 2440763 2022-04-24 Adams Washington 53001 4914 38
2437507 2437507 2022-04-23 Adams Washington 53001 4914 38
2434251 2434251 2022-04-22 Adams Washington 53001 4914 38
2430995 2430995 2022-04-21 Adams Washington 53001 4912 38
2427739 2427739 2022-04-20 Adams Washington 53001 4912 38
2424483 2424483 2022-04-19 Adams Washington 53001 4913 38
2421227 2421227 2022-04-18 Adams Washington 53001 4913 38
2417971 2417971 2022-04-17 Adams Washington 53001 4913 38
2414715 2414715 2022-04-16 Adams Washington 53001 4913 38
2411459 2411459 2022-04-15 Adams Washington 53001 4913 38
2408203 2408203 2022-04-14 Adams Washington 53001 4913 38
2404947 2404947 2022-04-13 Adams Washington 53001 4913 38
2401692 2401692 2022-04-12 Adams Washington 53001 4915 38
2398437 2398437 2022-04-11 Adams Washington 53001 4915 38
2395182 2395182 2022-04-10 Adams Washington 53001 4915 38
2391926 2391926 2022-04-09 Adams Washington 53001 4915 38
2388670 2388670 2022-04-08 Adams Washington 53001 4915 38
2385415 2385415 2022-04-07 Adams Washington 53001 4915 38
2382160 2382160 2022-04-06 Adams Washington 53001 4915 38
2378905 2378905 2022-04-05 Adams Washington 53001 4915 38
2375651 2375651 2022-04-04 Adams Washington 53001 4915 38
2372399 2372399 2022-04-03 Adams Washington 53001 4913 38
2369146 2369146 2022-04-02 Adams Washington 53001 4913 38
2365893 2365893 2022-04-01 Adams Washington 53001 4913 38
2362640 2362640 2022-03-31 Adams Washington 53001 4912 38
2359386 2359386 2022-03-30 Adams Washington 53001 4912 38
2356132 2356132 2022-03-29 Adams Washington 53001 4912 38
2352879 2352879 2022-03-28 Adams Washington 53001 4912 38
2349627 2349627 2022-03-27 Adams Washington 53001 4913 38
2346374 2346374 2022-03-26 Adams Washington 53001 4913 38
2343121 2343121 2022-03-25 Adams Washington 53001 4913 38
2339868 2339868 2022-03-24 Adams Washington 53001 4911 38
2336615 2336615 2022-03-23 Adams Washington 53001 4911 38
2333361 2333361 2022-03-22 Adams Washington 53001 4909 38
2330107 2330107 2022-03-21 Adams Washington 53001 4909 38
2326855 2326855 2022-03-20 Adams Washington 53001 4902 38
2323602 2323602 2022-03-19 Adams Washington 53001 4902 38
2320348 2320348 2022-03-18 Adams Washington 53001 4902 38
2317094 2317094 2022-03-17 Adams Washington 53001 4903 38
2313841 2313841 2022-03-16 Adams Washington 53001 4903 38
2310588 2310588 2022-03-15 Adams Washington 53001 4901 38
2307335 2307335 2022-03-14 Adams Washington 53001 4901 38
2304084 2304084 2022-03-13 Adams Washington 53001 4899 38
2300832 2300832 2022-03-12 Adams Washington 53001 4899 38
2297580 2297580 2022-03-11 Adams Washington 53001 4899 38
2294328 2294328 2022-03-10 Adams Washington 53001 4898 38
2291076 2291076 2022-03-09 Adams Washington 53001 4898 38
2287824 2287824 2022-03-08 Adams Washington 53001 4896 38
2284572 2284572 2022-03-07 Adams Washington 53001 4896 38
2281320 2281320 2022-03-06 Adams Washington 53001 4891 38
2278067 2278067 2022-03-05 Adams Washington 53001 4891 38
2274814 2274814 2022-03-04 Adams Washington 53001 4891 38
2271561 2271561 2022-03-03 Adams Washington 53001 4881 37
2268309 2268309 2022-03-02 Adams Washington 53001 4881 37
2265056 2265056 2022-03-01 Adams Washington 53001 4874 36
2261806 2261806 2022-02-28 Adams Washington 53001 4874 36
2258555 2258555 2022-02-27 Adams Washington 53001 4870 36
2255304 2255304 2022-02-26 Adams Washington 53001 4870 36
2252053 2252053 2022-02-25 Adams Washington 53001 4870 36
2248802 2248802 2022-02-24 Adams Washington 53001 4864 36
2245551 2245551 2022-02-23 Adams Washington 53001 4864 36
2242300 2242300 2022-02-22 Adams Washington 53001 4830 36
2239049 2239049 2022-02-21 Adams Washington 53001 4830 36
2235798 2235798 2022-02-20 Adams Washington 53001 4830 36
2232547 2232547 2022-02-19 Adams Washington 53001 4830 36
2229296 2229296 2022-02-18 Adams Washington 53001 4830 36
2226045 2226045 2022-02-17 Adams Washington 53001 4832 36
2222794 2222794 2022-02-16 Adams Washington 53001 4832 36
2219543 2219543 2022-02-15 Adams Washington 53001 4826 36
2216293 2216293 2022-02-14 Adams Washington 53001 4826 36
2213042 2213042 2022-02-13 Adams Washington 53001 4798 36
2209789 2209789 2022-02-12 Adams Washington 53001 4798 36
2206536 2206536 2022-02-11 Adams Washington 53001 4798 36
2203283 2203283 2022-02-10 Adams Washington 53001 4766 35
2200029 2200029 2022-02-09 Adams Washington 53001 4766 35
2196775 2196775 2022-02-08 Adams Washington 53001 4746 35
2193520 2193520 2022-02-07 Adams Washington 53001 4746 35
2190267 2190267 2022-02-06 Adams Washington 53001 4682 35
2187014 2187014 2022-02-05 Adams Washington 53001 4682 35
2183761 2183761 2022-02-04 Adams Washington 53001 4682 35
2180509 2180509 2022-02-03 Adams Washington 53001 4708 35

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