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

789 rows where county = "Lincoln" and state = "Arkansas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Arkansas · 789 ✖

fips 1

county 1

  • Lincoln · 789 ✖
Link rowid date ▲ county state fips cases deaths
2499725 2499725 2022-05-13 Lincoln Arkansas 5079 4920 68
2496467 2496467 2022-05-12 Lincoln Arkansas 5079 4919 68
2493209 2493209 2022-05-11 Lincoln Arkansas 5079 4919 68
2489951 2489951 2022-05-10 Lincoln Arkansas 5079 4919 68
2486694 2486694 2022-05-09 Lincoln Arkansas 5079 4918 68
2483436 2483436 2022-05-08 Lincoln Arkansas 5079 4918 68
2480178 2480178 2022-05-07 Lincoln Arkansas 5079 4918 68
2476920 2476920 2022-05-06 Lincoln Arkansas 5079 4918 68
2473662 2473662 2022-05-05 Lincoln Arkansas 5079 4917 68
2470405 2470405 2022-05-04 Lincoln Arkansas 5079 4917 68
2467149 2467149 2022-05-03 Lincoln Arkansas 5079 4915 68
2463894 2463894 2022-05-02 Lincoln Arkansas 5079 4913 68
2460638 2460638 2022-05-01 Lincoln Arkansas 5079 4913 68
2457382 2457382 2022-04-30 Lincoln Arkansas 5079 4913 68
2454126 2454126 2022-04-29 Lincoln Arkansas 5079 4913 68
2450870 2450870 2022-04-28 Lincoln Arkansas 5079 4913 68
2447614 2447614 2022-04-27 Lincoln Arkansas 5079 4913 68
2444358 2444358 2022-04-26 Lincoln Arkansas 5079 4913 68
2441102 2441102 2022-04-25 Lincoln Arkansas 5079 4913 68
2437846 2437846 2022-04-24 Lincoln Arkansas 5079 4913 68
2434590 2434590 2022-04-23 Lincoln Arkansas 5079 4913 68
2431334 2431334 2022-04-22 Lincoln Arkansas 5079 4913 68
2428078 2428078 2022-04-21 Lincoln Arkansas 5079 4912 68
2424822 2424822 2022-04-20 Lincoln Arkansas 5079 4912 68
2421566 2421566 2022-04-19 Lincoln Arkansas 5079 4912 68
2418310 2418310 2022-04-18 Lincoln Arkansas 5079 4912 68
2415054 2415054 2022-04-17 Lincoln Arkansas 5079 4912 68
2411798 2411798 2022-04-16 Lincoln Arkansas 5079 4912 68
2408542 2408542 2022-04-15 Lincoln Arkansas 5079 4912 68
2405286 2405286 2022-04-14 Lincoln Arkansas 5079 4912 68
2402031 2402031 2022-04-13 Lincoln Arkansas 5079 4912 68
2398776 2398776 2022-04-12 Lincoln Arkansas 5079 4912 68
2395521 2395521 2022-04-11 Lincoln Arkansas 5079 4912 68
2392265 2392265 2022-04-10 Lincoln Arkansas 5079 4912 68
2389009 2389009 2022-04-09 Lincoln Arkansas 5079 4911 68
2385754 2385754 2022-04-08 Lincoln Arkansas 5079 4911 68
2382499 2382499 2022-04-07 Lincoln Arkansas 5079 4911 68
2379244 2379244 2022-04-06 Lincoln Arkansas 5079 4911 68
2375990 2375990 2022-04-05 Lincoln Arkansas 5079 4911 68
2372738 2372738 2022-04-04 Lincoln Arkansas 5079 4911 68
2369485 2369485 2022-04-03 Lincoln Arkansas 5079 4911 68
2366232 2366232 2022-04-02 Lincoln Arkansas 5079 4911 68
2362979 2362979 2022-04-01 Lincoln Arkansas 5079 4911 67
2359725 2359725 2022-03-31 Lincoln Arkansas 5079 4911 67
2356471 2356471 2022-03-30 Lincoln Arkansas 5079 4911 66
2353218 2353218 2022-03-29 Lincoln Arkansas 5079 4911 66
2349966 2349966 2022-03-28 Lincoln Arkansas 5079 4911 66
2346713 2346713 2022-03-27 Lincoln Arkansas 5079 4911 66
2343460 2343460 2022-03-26 Lincoln Arkansas 5079 4911 66
2340207 2340207 2022-03-25 Lincoln Arkansas 5079 4911 66
2336954 2336954 2022-03-24 Lincoln Arkansas 5079 4911 66
2333700 2333700 2022-03-23 Lincoln Arkansas 5079 4908 66
2330446 2330446 2022-03-22 Lincoln Arkansas 5079 4907 66
2327194 2327194 2022-03-21 Lincoln Arkansas 5079 4907 66
2323941 2323941 2022-03-20 Lincoln Arkansas 5079 4906 66
2320687 2320687 2022-03-19 Lincoln Arkansas 5079 4905 66
2317433 2317433 2022-03-18 Lincoln Arkansas 5079 4902 66
2314180 2314180 2022-03-17 Lincoln Arkansas 5079 4901 66
2310927 2310927 2022-03-16 Lincoln Arkansas 5079 4900 66
2307674 2307674 2022-03-15 Lincoln Arkansas 5079 4900 66
2304423 2304423 2022-03-14 Lincoln Arkansas 5079 4900 66
2301171 2301171 2022-03-13 Lincoln Arkansas 5079 4900 66
2297919 2297919 2022-03-12 Lincoln Arkansas 5079 4900 66
2294667 2294667 2022-03-11 Lincoln Arkansas 5079 4900 66
2291415 2291415 2022-03-10 Lincoln Arkansas 5079 4900 66
2288163 2288163 2022-03-09 Lincoln Arkansas 5079 4900 66
2284912 2284912 2022-03-08 Lincoln Arkansas 5079 4899 65
2281660 2281660 2022-03-07 Lincoln Arkansas 5079 4897 65
2278407 2278407 2022-03-06 Lincoln Arkansas 5079 4896 65
2275154 2275154 2022-03-05 Lincoln Arkansas 5079 4896 65
2271901 2271901 2022-03-04 Lincoln Arkansas 5079 4896 65
2268649 2268649 2022-03-03 Lincoln Arkansas 5079 4896 64
2265396 2265396 2022-03-02 Lincoln Arkansas 5079 4896 64
2262145 2262145 2022-03-01 Lincoln Arkansas 5079 4896 64
2258894 2258894 2022-02-28 Lincoln Arkansas 5079 4895 64
2255643 2255643 2022-02-27 Lincoln Arkansas 5079 4895 63
2252392 2252392 2022-02-26 Lincoln Arkansas 5079 4895 63
2249141 2249141 2022-02-25 Lincoln Arkansas 5079 4895 63
2245890 2245890 2022-02-24 Lincoln Arkansas 5079 4896 63
2242639 2242639 2022-02-23 Lincoln Arkansas 5079 4889 63
2239388 2239388 2022-02-22 Lincoln Arkansas 5079 4886 63
2236137 2236137 2022-02-21 Lincoln Arkansas 5079 4884 63
2232886 2232886 2022-02-20 Lincoln Arkansas 5079 4884 63
2229635 2229635 2022-02-19 Lincoln Arkansas 5079 4883 63
2226384 2226384 2022-02-18 Lincoln Arkansas 5079 4881 62
2223133 2223133 2022-02-17 Lincoln Arkansas 5079 4873 62
2219882 2219882 2022-02-16 Lincoln Arkansas 5079 4861 61
2216631 2216631 2022-02-15 Lincoln Arkansas 5079 4857 61
2213380 2213380 2022-02-14 Lincoln Arkansas 5079 4838 61
2210128 2210128 2022-02-13 Lincoln Arkansas 5079 4838 61
2206875 2206875 2022-02-12 Lincoln Arkansas 5079 4836 60
2203622 2203622 2022-02-11 Lincoln Arkansas 5079 4834 60
2200369 2200369 2022-02-10 Lincoln Arkansas 5079 4830 60
2197115 2197115 2022-02-09 Lincoln Arkansas 5079 4820 60
2193860 2193860 2022-02-08 Lincoln Arkansas 5079 4812 60
2190607 2190607 2022-02-07 Lincoln Arkansas 5079 4805 60
2187354 2187354 2022-02-06 Lincoln Arkansas 5079 4801 60
2184101 2184101 2022-02-05 Lincoln Arkansas 5079 4800 60
2180849 2180849 2022-02-04 Lincoln Arkansas 5079 4798 60
2177598 2177598 2022-02-03 Lincoln Arkansas 5079 4782 60

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