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

775 rows where fips = 5101 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 · 775 ✖

fips 1

  • 5101 · 775 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499736 2499736 2022-05-13 Newton Arkansas 5101 1719 47
2496478 2496478 2022-05-12 Newton Arkansas 5101 1719 47
2493220 2493220 2022-05-11 Newton Arkansas 5101 1719 47
2489962 2489962 2022-05-10 Newton Arkansas 5101 1719 47
2486705 2486705 2022-05-09 Newton Arkansas 5101 1719 47
2483447 2483447 2022-05-08 Newton Arkansas 5101 1719 47
2480189 2480189 2022-05-07 Newton Arkansas 5101 1719 47
2476931 2476931 2022-05-06 Newton Arkansas 5101 1718 47
2473673 2473673 2022-05-05 Newton Arkansas 5101 1718 47
2470416 2470416 2022-05-04 Newton Arkansas 5101 1718 47
2467160 2467160 2022-05-03 Newton Arkansas 5101 1718 47
2463905 2463905 2022-05-02 Newton Arkansas 5101 1718 47
2460649 2460649 2022-05-01 Newton Arkansas 5101 1718 47
2457393 2457393 2022-04-30 Newton Arkansas 5101 1718 47
2454137 2454137 2022-04-29 Newton Arkansas 5101 1718 47
2450881 2450881 2022-04-28 Newton Arkansas 5101 1718 47
2447625 2447625 2022-04-27 Newton Arkansas 5101 1718 47
2444369 2444369 2022-04-26 Newton Arkansas 5101 1718 47
2441113 2441113 2022-04-25 Newton Arkansas 5101 1717 47
2437857 2437857 2022-04-24 Newton Arkansas 5101 1717 47
2434601 2434601 2022-04-23 Newton Arkansas 5101 1717 47
2431345 2431345 2022-04-22 Newton Arkansas 5101 1717 47
2428089 2428089 2022-04-21 Newton Arkansas 5101 1717 47
2424833 2424833 2022-04-20 Newton Arkansas 5101 1717 47
2421577 2421577 2022-04-19 Newton Arkansas 5101 1717 47
2418321 2418321 2022-04-18 Newton Arkansas 5101 1717 47
2415065 2415065 2022-04-17 Newton Arkansas 5101 1718 47
2411809 2411809 2022-04-16 Newton Arkansas 5101 1718 47
2408553 2408553 2022-04-15 Newton Arkansas 5101 1718 47
2405297 2405297 2022-04-14 Newton Arkansas 5101 1718 47
2402042 2402042 2022-04-13 Newton Arkansas 5101 1718 47
2398787 2398787 2022-04-12 Newton Arkansas 5101 1718 47
2395532 2395532 2022-04-11 Newton Arkansas 5101 1718 47
2392276 2392276 2022-04-10 Newton Arkansas 5101 1718 47
2389020 2389020 2022-04-09 Newton Arkansas 5101 1718 47
2385765 2385765 2022-04-08 Newton Arkansas 5101 1718 47
2382510 2382510 2022-04-07 Newton Arkansas 5101 1718 47
2379255 2379255 2022-04-06 Newton Arkansas 5101 1718 47
2376001 2376001 2022-04-05 Newton Arkansas 5101 1718 47
2372749 2372749 2022-04-04 Newton Arkansas 5101 1718 47
2369496 2369496 2022-04-03 Newton Arkansas 5101 1718 47
2366243 2366243 2022-04-02 Newton Arkansas 5101 1718 47
2362990 2362990 2022-04-01 Newton Arkansas 5101 1718 47
2359736 2359736 2022-03-31 Newton Arkansas 5101 1718 47
2356482 2356482 2022-03-30 Newton Arkansas 5101 1718 47
2353229 2353229 2022-03-29 Newton Arkansas 5101 1718 47
2349977 2349977 2022-03-28 Newton Arkansas 5101 1717 47
2346724 2346724 2022-03-27 Newton Arkansas 5101 1717 47
2343471 2343471 2022-03-26 Newton Arkansas 5101 1717 47
2340218 2340218 2022-03-25 Newton Arkansas 5101 1717 47
2336965 2336965 2022-03-24 Newton Arkansas 5101 1716 47
2333711 2333711 2022-03-23 Newton Arkansas 5101 1716 47
2330457 2330457 2022-03-22 Newton Arkansas 5101 1715 47
2327205 2327205 2022-03-21 Newton Arkansas 5101 1713 47
2323952 2323952 2022-03-20 Newton Arkansas 5101 1713 47
2320698 2320698 2022-03-19 Newton Arkansas 5101 1713 46
2317444 2317444 2022-03-18 Newton Arkansas 5101 1713 46
2314191 2314191 2022-03-17 Newton Arkansas 5101 1711 46
2310938 2310938 2022-03-16 Newton Arkansas 5101 1710 46
2307685 2307685 2022-03-15 Newton Arkansas 5101 1709 45
2304434 2304434 2022-03-14 Newton Arkansas 5101 1708 45
2301182 2301182 2022-03-13 Newton Arkansas 5101 1708 45
2297930 2297930 2022-03-12 Newton Arkansas 5101 1707 45
2294678 2294678 2022-03-11 Newton Arkansas 5101 1703 45
2291426 2291426 2022-03-10 Newton Arkansas 5101 1703 45
2288174 2288174 2022-03-09 Newton Arkansas 5101 1703 45
2284923 2284923 2022-03-08 Newton Arkansas 5101 1703 45
2281671 2281671 2022-03-07 Newton Arkansas 5101 1703 45
2278418 2278418 2022-03-06 Newton Arkansas 5101 1703 45
2275165 2275165 2022-03-05 Newton Arkansas 5101 1702 45
2271912 2271912 2022-03-04 Newton Arkansas 5101 1700 45
2268660 2268660 2022-03-03 Newton Arkansas 5101 1700 45
2265407 2265407 2022-03-02 Newton Arkansas 5101 1700 45
2262156 2262156 2022-03-01 Newton Arkansas 5101 1700 45
2258905 2258905 2022-02-28 Newton Arkansas 5101 1700 45
2255654 2255654 2022-02-27 Newton Arkansas 5101 1700 45
2252403 2252403 2022-02-26 Newton Arkansas 5101 1700 45
2249152 2249152 2022-02-25 Newton Arkansas 5101 1700 45
2245901 2245901 2022-02-24 Newton Arkansas 5101 1699 45
2242650 2242650 2022-02-23 Newton Arkansas 5101 1699 45
2239399 2239399 2022-02-22 Newton Arkansas 5101 1698 45
2236148 2236148 2022-02-21 Newton Arkansas 5101 1696 45
2232897 2232897 2022-02-20 Newton Arkansas 5101 1696 45
2229646 2229646 2022-02-19 Newton Arkansas 5101 1696 45
2226395 2226395 2022-02-18 Newton Arkansas 5101 1695 45
2223144 2223144 2022-02-17 Newton Arkansas 5101 1692 45
2219893 2219893 2022-02-16 Newton Arkansas 5101 1689 45
2216642 2216642 2022-02-15 Newton Arkansas 5101 1688 45
2213391 2213391 2022-02-14 Newton Arkansas 5101 1686 45
2210139 2210139 2022-02-13 Newton Arkansas 5101 1686 45
2206886 2206886 2022-02-12 Newton Arkansas 5101 1686 45
2203633 2203633 2022-02-11 Newton Arkansas 5101 1683 45
2200380 2200380 2022-02-10 Newton Arkansas 5101 1681 45
2197126 2197126 2022-02-09 Newton Arkansas 5101 1679 45
2193871 2193871 2022-02-08 Newton Arkansas 5101 1675 45
2190618 2190618 2022-02-07 Newton Arkansas 5101 1669 45
2187365 2187365 2022-02-06 Newton Arkansas 5101 1667 45
2184112 2184112 2022-02-05 Newton Arkansas 5101 1667 45
2180860 2180860 2022-02-04 Newton Arkansas 5101 1668 45
2177609 2177609 2022-02-03 Newton Arkansas 5101 1667 45

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