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

785 rows where county = "Lincoln" and state = "Georgia" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Georgia · 785 ✖

fips 1

county 1

  • Lincoln · 785 ✖
Link rowid date ▲ county state fips cases deaths
2500055 2500055 2022-05-13 Lincoln Georgia 13181 1601 35
2496797 2496797 2022-05-12 Lincoln Georgia 13181 1601 35
2493539 2493539 2022-05-11 Lincoln Georgia 13181 1601 35
2490281 2490281 2022-05-10 Lincoln Georgia 13181 1601 35
2487024 2487024 2022-05-09 Lincoln Georgia 13181 1601 35
2483766 2483766 2022-05-08 Lincoln Georgia 13181 1601 35
2480508 2480508 2022-05-07 Lincoln Georgia 13181 1601 35
2477250 2477250 2022-05-06 Lincoln Georgia 13181 1601 35
2473992 2473992 2022-05-05 Lincoln Georgia 13181 1601 35
2470735 2470735 2022-05-04 Lincoln Georgia 13181 1601 35
2467479 2467479 2022-05-03 Lincoln Georgia 13181 1602 35
2464224 2464224 2022-05-02 Lincoln Georgia 13181 1602 35
2460968 2460968 2022-05-01 Lincoln Georgia 13181 1602 35
2457712 2457712 2022-04-30 Lincoln Georgia 13181 1602 35
2454456 2454456 2022-04-29 Lincoln Georgia 13181 1602 35
2451200 2451200 2022-04-28 Lincoln Georgia 13181 1602 35
2447944 2447944 2022-04-27 Lincoln Georgia 13181 1602 35
2444688 2444688 2022-04-26 Lincoln Georgia 13181 1604 35
2441432 2441432 2022-04-25 Lincoln Georgia 13181 1604 35
2438176 2438176 2022-04-24 Lincoln Georgia 13181 1604 35
2434920 2434920 2022-04-23 Lincoln Georgia 13181 1604 35
2431664 2431664 2022-04-22 Lincoln Georgia 13181 1604 35
2428408 2428408 2022-04-21 Lincoln Georgia 13181 1604 35
2425152 2425152 2022-04-20 Lincoln Georgia 13181 1604 35
2421896 2421896 2022-04-19 Lincoln Georgia 13181 1604 35
2418640 2418640 2022-04-18 Lincoln Georgia 13181 1604 35
2415384 2415384 2022-04-17 Lincoln Georgia 13181 1604 35
2412128 2412128 2022-04-16 Lincoln Georgia 13181 1604 35
2408872 2408872 2022-04-15 Lincoln Georgia 13181 1604 35
2405616 2405616 2022-04-14 Lincoln Georgia 13181 1604 35
2402361 2402361 2022-04-13 Lincoln Georgia 13181 1603 35
2399106 2399106 2022-04-12 Lincoln Georgia 13181 1603 35
2395851 2395851 2022-04-11 Lincoln Georgia 13181 1602 35
2392595 2392595 2022-04-10 Lincoln Georgia 13181 1602 35
2389339 2389339 2022-04-09 Lincoln Georgia 13181 1602 35
2386084 2386084 2022-04-08 Lincoln Georgia 13181 1602 35
2382829 2382829 2022-04-07 Lincoln Georgia 13181 1602 35
2379574 2379574 2022-04-06 Lincoln Georgia 13181 1601 35
2376320 2376320 2022-04-05 Lincoln Georgia 13181 1601 35
2373068 2373068 2022-04-04 Lincoln Georgia 13181 1601 35
2369815 2369815 2022-04-03 Lincoln Georgia 13181 1601 35
2366562 2366562 2022-04-02 Lincoln Georgia 13181 1601 35
2363309 2363309 2022-04-01 Lincoln Georgia 13181 1601 35
2360055 2360055 2022-03-31 Lincoln Georgia 13181 1601 35
2356801 2356801 2022-03-30 Lincoln Georgia 13181 1601 35
2353548 2353548 2022-03-29 Lincoln Georgia 13181 1601 35
2350296 2350296 2022-03-28 Lincoln Georgia 13181 1600 35
2347043 2347043 2022-03-27 Lincoln Georgia 13181 1599 35
2343790 2343790 2022-03-26 Lincoln Georgia 13181 1599 35
2340537 2340537 2022-03-25 Lincoln Georgia 13181 1599 35
2337284 2337284 2022-03-24 Lincoln Georgia 13181 1599 35
2334030 2334030 2022-03-23 Lincoln Georgia 13181 1599 35
2330776 2330776 2022-03-22 Lincoln Georgia 13181 1598 35
2327524 2327524 2022-03-21 Lincoln Georgia 13181 1598 35
2324271 2324271 2022-03-20 Lincoln Georgia 13181 1598 35
2321017 2321017 2022-03-19 Lincoln Georgia 13181 1598 35
2317763 2317763 2022-03-18 Lincoln Georgia 13181 1598 35
2314510 2314510 2022-03-17 Lincoln Georgia 13181 1598 35
2311257 2311257 2022-03-16 Lincoln Georgia 13181 1596 35
2308004 2308004 2022-03-15 Lincoln Georgia 13181 1596 35
2304753 2304753 2022-03-14 Lincoln Georgia 13181 1593 35
2301501 2301501 2022-03-13 Lincoln Georgia 13181 1594 35
2298249 2298249 2022-03-12 Lincoln Georgia 13181 1594 35
2294997 2294997 2022-03-11 Lincoln Georgia 13181 1594 35
2291745 2291745 2022-03-10 Lincoln Georgia 13181 1594 35
2288493 2288493 2022-03-09 Lincoln Georgia 13181 1594 35
2285242 2285242 2022-03-08 Lincoln Georgia 13181 1592 35
2281990 2281990 2022-03-07 Lincoln Georgia 13181 1592 35
2278737 2278737 2022-03-06 Lincoln Georgia 13181 1590 35
2275484 2275484 2022-03-05 Lincoln Georgia 13181 1590 35
2272231 2272231 2022-03-04 Lincoln Georgia 13181 1590 35
2268979 2268979 2022-03-03 Lincoln Georgia 13181 1590 35
2265726 2265726 2022-03-02 Lincoln Georgia 13181 1590 35
2262475 2262475 2022-03-01 Lincoln Georgia 13181 1589 35
2259224 2259224 2022-02-28 Lincoln Georgia 13181 1589 35
2255973 2255973 2022-02-27 Lincoln Georgia 13181 1589 35
2252722 2252722 2022-02-26 Lincoln Georgia 13181 1589 35
2249471 2249471 2022-02-25 Lincoln Georgia 13181 1589 35
2246220 2246220 2022-02-24 Lincoln Georgia 13181 1588 35
2242969 2242969 2022-02-23 Lincoln Georgia 13181 1588 35
2239718 2239718 2022-02-22 Lincoln Georgia 13181 1588 35
2236467 2236467 2022-02-21 Lincoln Georgia 13181 1588 35
2233216 2233216 2022-02-20 Lincoln Georgia 13181 1587 35
2229965 2229965 2022-02-19 Lincoln Georgia 13181 1587 35
2226714 2226714 2022-02-18 Lincoln Georgia 13181 1587 35
2223463 2223463 2022-02-17 Lincoln Georgia 13181 1586 35
2220212 2220212 2022-02-16 Lincoln Georgia 13181 1585 35
2216961 2216961 2022-02-15 Lincoln Georgia 13181 1586 35
2213710 2213710 2022-02-14 Lincoln Georgia 13181 1585 35
2210458 2210458 2022-02-13 Lincoln Georgia 13181 1581 35
2207205 2207205 2022-02-12 Lincoln Georgia 13181 1581 35
2203952 2203952 2022-02-11 Lincoln Georgia 13181 1581 35
2200699 2200699 2022-02-10 Lincoln Georgia 13181 1581 35
2197445 2197445 2022-02-09 Lincoln Georgia 13181 1579 35
2194191 2194191 2022-02-08 Lincoln Georgia 13181 1577 35
2190937 2190937 2022-02-07 Lincoln Georgia 13181 1572 35
2187684 2187684 2022-02-06 Lincoln Georgia 13181 1564 35
2184431 2184431 2022-02-05 Lincoln Georgia 13181 1564 35
2181179 2181179 2022-02-04 Lincoln Georgia 13181 1564 35
2177928 2177928 2022-02-03 Lincoln Georgia 13181 1552 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);