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

777 rows where county = "Lincoln" and fips = 16063 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

  • 16063 · 777 ✖

county 1

  • Lincoln · 777 ✖
Link rowid date ▲ county state fips cases deaths
2500164 2500164 2022-05-13 Lincoln Idaho 16063 1107 15
2496906 2496906 2022-05-12 Lincoln Idaho 16063 1107 15
2493648 2493648 2022-05-11 Lincoln Idaho 16063 1107 15
2490390 2490390 2022-05-10 Lincoln Idaho 16063 1108 15
2487133 2487133 2022-05-09 Lincoln Idaho 16063 1108 15
2483875 2483875 2022-05-08 Lincoln Idaho 16063 1108 15
2480617 2480617 2022-05-07 Lincoln Idaho 16063 1108 15
2477359 2477359 2022-05-06 Lincoln Idaho 16063 1108 15
2474101 2474101 2022-05-05 Lincoln Idaho 16063 1108 15
2470844 2470844 2022-05-04 Lincoln Idaho 16063 1108 15
2467588 2467588 2022-05-03 Lincoln Idaho 16063 1108 15
2464333 2464333 2022-05-02 Lincoln Idaho 16063 1108 15
2461077 2461077 2022-05-01 Lincoln Idaho 16063 1108 15
2457821 2457821 2022-04-30 Lincoln Idaho 16063 1108 15
2454565 2454565 2022-04-29 Lincoln Idaho 16063 1108 15
2451309 2451309 2022-04-28 Lincoln Idaho 16063 1106 15
2448053 2448053 2022-04-27 Lincoln Idaho 16063 1106 15
2444797 2444797 2022-04-26 Lincoln Idaho 16063 1106 15
2441541 2441541 2022-04-25 Lincoln Idaho 16063 1106 15
2438285 2438285 2022-04-24 Lincoln Idaho 16063 1106 15
2435029 2435029 2022-04-23 Lincoln Idaho 16063 1106 15
2431773 2431773 2022-04-22 Lincoln Idaho 16063 1106 15
2428517 2428517 2022-04-21 Lincoln Idaho 16063 1106 15
2425261 2425261 2022-04-20 Lincoln Idaho 16063 1106 15
2422005 2422005 2022-04-19 Lincoln Idaho 16063 1106 15
2418749 2418749 2022-04-18 Lincoln Idaho 16063 1106 15
2415493 2415493 2022-04-17 Lincoln Idaho 16063 1106 15
2412237 2412237 2022-04-16 Lincoln Idaho 16063 1106 15
2408981 2408981 2022-04-15 Lincoln Idaho 16063 1106 15
2405725 2405725 2022-04-14 Lincoln Idaho 16063 1106 15
2402470 2402470 2022-04-13 Lincoln Idaho 16063 1104 15
2399215 2399215 2022-04-12 Lincoln Idaho 16063 1104 15
2395960 2395960 2022-04-11 Lincoln Idaho 16063 1104 15
2392704 2392704 2022-04-10 Lincoln Idaho 16063 1104 15
2389448 2389448 2022-04-09 Lincoln Idaho 16063 1104 15
2386193 2386193 2022-04-08 Lincoln Idaho 16063 1104 15
2382938 2382938 2022-04-07 Lincoln Idaho 16063 1104 15
2379683 2379683 2022-04-06 Lincoln Idaho 16063 1104 15
2376429 2376429 2022-04-05 Lincoln Idaho 16063 1104 15
2373177 2373177 2022-04-04 Lincoln Idaho 16063 1104 15
2369924 2369924 2022-04-03 Lincoln Idaho 16063 1104 15
2366671 2366671 2022-04-02 Lincoln Idaho 16063 1104 15
2363418 2363418 2022-04-01 Lincoln Idaho 16063 1104 15
2360164 2360164 2022-03-31 Lincoln Idaho 16063 1104 15
2356910 2356910 2022-03-30 Lincoln Idaho 16063 1104 15
2353657 2353657 2022-03-29 Lincoln Idaho 16063 1104 15
2350405 2350405 2022-03-28 Lincoln Idaho 16063 1104 15
2347152 2347152 2022-03-27 Lincoln Idaho 16063 1103 15
2343899 2343899 2022-03-26 Lincoln Idaho 16063 1103 15
2340646 2340646 2022-03-25 Lincoln Idaho 16063 1103 15
2337393 2337393 2022-03-24 Lincoln Idaho 16063 1103 15
2334139 2334139 2022-03-23 Lincoln Idaho 16063 1103 15
2330885 2330885 2022-03-22 Lincoln Idaho 16063 1100 15
2327633 2327633 2022-03-21 Lincoln Idaho 16063 1099 15
2324380 2324380 2022-03-20 Lincoln Idaho 16063 1096 15
2321126 2321126 2022-03-19 Lincoln Idaho 16063 1096 15
2317872 2317872 2022-03-18 Lincoln Idaho 16063 1096 15
2314619 2314619 2022-03-17 Lincoln Idaho 16063 1093 15
2311366 2311366 2022-03-16 Lincoln Idaho 16063 1093 15
2308113 2308113 2022-03-15 Lincoln Idaho 16063 1086 15
2304862 2304862 2022-03-14 Lincoln Idaho 16063 1079 15
2301610 2301610 2022-03-13 Lincoln Idaho 16063 1071 15
2298358 2298358 2022-03-12 Lincoln Idaho 16063 1071 15
2295106 2295106 2022-03-11 Lincoln Idaho 16063 1071 15
2291854 2291854 2022-03-10 Lincoln Idaho 16063 1068 15
2288602 2288602 2022-03-09 Lincoln Idaho 16063 1057 15
2285351 2285351 2022-03-08 Lincoln Idaho 16063 1052 15
2282099 2282099 2022-03-07 Lincoln Idaho 16063 1043 15
2278846 2278846 2022-03-06 Lincoln Idaho 16063 1026 15
2275593 2275593 2022-03-05 Lincoln Idaho 16063 1026 15
2272340 2272340 2022-03-04 Lincoln Idaho 16063 1026 15
2269088 2269088 2022-03-03 Lincoln Idaho 16063 1015 15
2265835 2265835 2022-03-02 Lincoln Idaho 16063 1011 15
2262584 2262584 2022-03-01 Lincoln Idaho 16063 1005 15
2259333 2259333 2022-02-28 Lincoln Idaho 16063 994 15
2256082 2256082 2022-02-27 Lincoln Idaho 16063 978 15
2252831 2252831 2022-02-26 Lincoln Idaho 16063 978 15
2249580 2249580 2022-02-25 Lincoln Idaho 16063 978 15
2246329 2246329 2022-02-24 Lincoln Idaho 16063 970 15
2243078 2243078 2022-02-23 Lincoln Idaho 16063 958 15
2239827 2239827 2022-02-22 Lincoln Idaho 16063 954 15
2236576 2236576 2022-02-21 Lincoln Idaho 16063 939 15
2233325 2233325 2022-02-20 Lincoln Idaho 16063 939 15
2230074 2230074 2022-02-19 Lincoln Idaho 16063 939 15
2226823 2226823 2022-02-18 Lincoln Idaho 16063 934 15
2223572 2223572 2022-02-17 Lincoln Idaho 16063 922 15
2220321 2220321 2022-02-16 Lincoln Idaho 16063 918 14
2217070 2217070 2022-02-15 Lincoln Idaho 16063 904 14
2213819 2213819 2022-02-14 Lincoln Idaho 16063 903 14
2210567 2210567 2022-02-13 Lincoln Idaho 16063 900 14
2207314 2207314 2022-02-12 Lincoln Idaho 16063 900 14
2204061 2204061 2022-02-11 Lincoln Idaho 16063 897 14
2200808 2200808 2022-02-10 Lincoln Idaho 16063 894 14
2197554 2197554 2022-02-09 Lincoln Idaho 16063 889 14
2194300 2194300 2022-02-08 Lincoln Idaho 16063 885 14
2191046 2191046 2022-02-07 Lincoln Idaho 16063 880 14
2187793 2187793 2022-02-06 Lincoln Idaho 16063 874 14
2184540 2184540 2022-02-05 Lincoln Idaho 16063 874 14
2181288 2181288 2022-02-04 Lincoln Idaho 16063 873 14
2178037 2178037 2022-02-03 Lincoln Idaho 16063 870 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);