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

774 rows where county = "Adams" and fips = 16003 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 16003 · 774 ✖

county 1

  • Adams · 774 ✖
Link rowid date ▲ county state fips cases deaths
2500134 2500134 2022-05-13 Adams Idaho 16003 704 15
2496876 2496876 2022-05-12 Adams Idaho 16003 703 15
2493618 2493618 2022-05-11 Adams Idaho 16003 703 15
2490360 2490360 2022-05-10 Adams Idaho 16003 703 15
2487103 2487103 2022-05-09 Adams Idaho 16003 703 15
2483845 2483845 2022-05-08 Adams Idaho 16003 703 15
2480587 2480587 2022-05-07 Adams Idaho 16003 703 15
2477329 2477329 2022-05-06 Adams Idaho 16003 703 15
2474071 2474071 2022-05-05 Adams Idaho 16003 702 15
2470814 2470814 2022-05-04 Adams Idaho 16003 702 15
2467558 2467558 2022-05-03 Adams Idaho 16003 702 15
2464303 2464303 2022-05-02 Adams Idaho 16003 702 15
2461047 2461047 2022-05-01 Adams Idaho 16003 702 15
2457791 2457791 2022-04-30 Adams Idaho 16003 702 15
2454535 2454535 2022-04-29 Adams Idaho 16003 702 15
2451279 2451279 2022-04-28 Adams Idaho 16003 702 15
2448023 2448023 2022-04-27 Adams Idaho 16003 702 15
2444767 2444767 2022-04-26 Adams Idaho 16003 701 15
2441511 2441511 2022-04-25 Adams Idaho 16003 701 15
2438255 2438255 2022-04-24 Adams Idaho 16003 701 15
2434999 2434999 2022-04-23 Adams Idaho 16003 701 15
2431743 2431743 2022-04-22 Adams Idaho 16003 701 15
2428487 2428487 2022-04-21 Adams Idaho 16003 700 15
2425231 2425231 2022-04-20 Adams Idaho 16003 700 15
2421975 2421975 2022-04-19 Adams Idaho 16003 700 15
2418719 2418719 2022-04-18 Adams Idaho 16003 700 15
2415463 2415463 2022-04-17 Adams Idaho 16003 700 15
2412207 2412207 2022-04-16 Adams Idaho 16003 700 15
2408951 2408951 2022-04-15 Adams Idaho 16003 700 15
2405695 2405695 2022-04-14 Adams Idaho 16003 700 15
2402440 2402440 2022-04-13 Adams Idaho 16003 699 15
2399185 2399185 2022-04-12 Adams Idaho 16003 699 15
2395930 2395930 2022-04-11 Adams Idaho 16003 699 15
2392674 2392674 2022-04-10 Adams Idaho 16003 699 15
2389418 2389418 2022-04-09 Adams Idaho 16003 699 15
2386163 2386163 2022-04-08 Adams Idaho 16003 699 15
2382908 2382908 2022-04-07 Adams Idaho 16003 699 15
2379653 2379653 2022-04-06 Adams Idaho 16003 699 15
2376399 2376399 2022-04-05 Adams Idaho 16003 700 15
2373147 2373147 2022-04-04 Adams Idaho 16003 700 15
2369894 2369894 2022-04-03 Adams Idaho 16003 700 15
2366641 2366641 2022-04-02 Adams Idaho 16003 700 15
2363388 2363388 2022-04-01 Adams Idaho 16003 700 15
2360134 2360134 2022-03-31 Adams Idaho 16003 700 15
2356880 2356880 2022-03-30 Adams Idaho 16003 700 15
2353627 2353627 2022-03-29 Adams Idaho 16003 699 15
2350375 2350375 2022-03-28 Adams Idaho 16003 699 15
2347122 2347122 2022-03-27 Adams Idaho 16003 697 15
2343869 2343869 2022-03-26 Adams Idaho 16003 697 15
2340616 2340616 2022-03-25 Adams Idaho 16003 697 15
2337363 2337363 2022-03-24 Adams Idaho 16003 696 15
2334109 2334109 2022-03-23 Adams Idaho 16003 696 15
2330855 2330855 2022-03-22 Adams Idaho 16003 696 15
2327603 2327603 2022-03-21 Adams Idaho 16003 696 15
2324350 2324350 2022-03-20 Adams Idaho 16003 696 15
2321096 2321096 2022-03-19 Adams Idaho 16003 696 15
2317842 2317842 2022-03-18 Adams Idaho 16003 696 15
2314589 2314589 2022-03-17 Adams Idaho 16003 695 15
2311336 2311336 2022-03-16 Adams Idaho 16003 695 15
2308083 2308083 2022-03-15 Adams Idaho 16003 695 15
2304832 2304832 2022-03-14 Adams Idaho 16003 695 15
2301580 2301580 2022-03-13 Adams Idaho 16003 694 15
2298328 2298328 2022-03-12 Adams Idaho 16003 694 15
2295076 2295076 2022-03-11 Adams Idaho 16003 694 15
2291824 2291824 2022-03-10 Adams Idaho 16003 694 15
2288572 2288572 2022-03-09 Adams Idaho 16003 694 15
2285321 2285321 2022-03-08 Adams Idaho 16003 692 15
2282069 2282069 2022-03-07 Adams Idaho 16003 692 15
2278816 2278816 2022-03-06 Adams Idaho 16003 694 15
2275563 2275563 2022-03-05 Adams Idaho 16003 694 15
2272310 2272310 2022-03-04 Adams Idaho 16003 694 15
2269058 2269058 2022-03-03 Adams Idaho 16003 694 15
2265805 2265805 2022-03-02 Adams Idaho 16003 694 14
2262554 2262554 2022-03-01 Adams Idaho 16003 691 15
2259303 2259303 2022-02-28 Adams Idaho 16003 687 14
2256052 2256052 2022-02-27 Adams Idaho 16003 684 14
2252801 2252801 2022-02-26 Adams Idaho 16003 684 14
2249550 2249550 2022-02-25 Adams Idaho 16003 684 14
2246299 2246299 2022-02-24 Adams Idaho 16003 682 14
2243048 2243048 2022-02-23 Adams Idaho 16003 681 14
2239797 2239797 2022-02-22 Adams Idaho 16003 680 14
2236546 2236546 2022-02-21 Adams Idaho 16003 679 14
2233295 2233295 2022-02-20 Adams Idaho 16003 679 14
2230044 2230044 2022-02-19 Adams Idaho 16003 679 14
2226793 2226793 2022-02-18 Adams Idaho 16003 676 14
2223542 2223542 2022-02-17 Adams Idaho 16003 674 14
2220291 2220291 2022-02-16 Adams Idaho 16003 671 14
2217040 2217040 2022-02-15 Adams Idaho 16003 664 14
2213789 2213789 2022-02-14 Adams Idaho 16003 663 14
2210537 2210537 2022-02-13 Adams Idaho 16003 661 14
2207284 2207284 2022-02-12 Adams Idaho 16003 661 14
2204031 2204031 2022-02-11 Adams Idaho 16003 660 14
2200778 2200778 2022-02-10 Adams Idaho 16003 659 14
2197524 2197524 2022-02-09 Adams Idaho 16003 658 14
2194270 2194270 2022-02-08 Adams Idaho 16003 655 14
2191016 2191016 2022-02-07 Adams Idaho 16003 650 14
2187763 2187763 2022-02-06 Adams Idaho 16003 647 14
2184510 2184510 2022-02-05 Adams Idaho 16003 647 14
2181258 2181258 2022-02-04 Adams Idaho 16003 647 14
2178007 2178007 2022-02-03 Adams Idaho 16003 641 14

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