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

769 rows where county = "Crawford" and fips = 13079 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 13079 · 769 ✖

county 1

  • Crawford · 769 ✖
Link rowid date ▲ county state fips cases deaths
2500004 2500004 2022-05-13 Crawford Georgia 13079 1780 55
2496746 2496746 2022-05-12 Crawford Georgia 13079 1780 55
2493488 2493488 2022-05-11 Crawford Georgia 13079 1780 55
2490230 2490230 2022-05-10 Crawford Georgia 13079 1773 55
2486973 2486973 2022-05-09 Crawford Georgia 13079 1773 55
2483715 2483715 2022-05-08 Crawford Georgia 13079 1773 55
2480457 2480457 2022-05-07 Crawford Georgia 13079 1773 55
2477199 2477199 2022-05-06 Crawford Georgia 13079 1773 55
2473941 2473941 2022-05-05 Crawford Georgia 13079 1773 55
2470684 2470684 2022-05-04 Crawford Georgia 13079 1773 55
2467428 2467428 2022-05-03 Crawford Georgia 13079 1768 55
2464173 2464173 2022-05-02 Crawford Georgia 13079 1768 55
2460917 2460917 2022-05-01 Crawford Georgia 13079 1768 55
2457661 2457661 2022-04-30 Crawford Georgia 13079 1768 55
2454405 2454405 2022-04-29 Crawford Georgia 13079 1768 55
2451149 2451149 2022-04-28 Crawford Georgia 13079 1768 55
2447893 2447893 2022-04-27 Crawford Georgia 13079 1768 55
2444637 2444637 2022-04-26 Crawford Georgia 13079 1768 54
2441381 2441381 2022-04-25 Crawford Georgia 13079 1768 54
2438125 2438125 2022-04-24 Crawford Georgia 13079 1768 54
2434869 2434869 2022-04-23 Crawford Georgia 13079 1768 54
2431613 2431613 2022-04-22 Crawford Georgia 13079 1768 54
2428357 2428357 2022-04-21 Crawford Georgia 13079 1768 54
2425101 2425101 2022-04-20 Crawford Georgia 13079 1768 54
2421845 2421845 2022-04-19 Crawford Georgia 13079 1769 54
2418589 2418589 2022-04-18 Crawford Georgia 13079 1769 54
2415333 2415333 2022-04-17 Crawford Georgia 13079 1769 54
2412077 2412077 2022-04-16 Crawford Georgia 13079 1769 54
2408821 2408821 2022-04-15 Crawford Georgia 13079 1769 54
2405565 2405565 2022-04-14 Crawford Georgia 13079 1768 54
2402310 2402310 2022-04-13 Crawford Georgia 13079 1768 54
2399055 2399055 2022-04-12 Crawford Georgia 13079 1768 54
2395800 2395800 2022-04-11 Crawford Georgia 13079 1768 54
2392544 2392544 2022-04-10 Crawford Georgia 13079 1768 54
2389288 2389288 2022-04-09 Crawford Georgia 13079 1768 54
2386033 2386033 2022-04-08 Crawford Georgia 13079 1768 54
2382778 2382778 2022-04-07 Crawford Georgia 13079 1768 54
2379523 2379523 2022-04-06 Crawford Georgia 13079 1769 54
2376269 2376269 2022-04-05 Crawford Georgia 13079 1769 54
2373017 2373017 2022-04-04 Crawford Georgia 13079 1768 54
2369764 2369764 2022-04-03 Crawford Georgia 13079 1768 54
2366511 2366511 2022-04-02 Crawford Georgia 13079 1768 54
2363258 2363258 2022-04-01 Crawford Georgia 13079 1768 54
2360004 2360004 2022-03-31 Crawford Georgia 13079 1768 54
2356750 2356750 2022-03-30 Crawford Georgia 13079 1769 54
2353497 2353497 2022-03-29 Crawford Georgia 13079 1769 54
2350245 2350245 2022-03-28 Crawford Georgia 13079 1769 54
2346992 2346992 2022-03-27 Crawford Georgia 13079 1769 53
2343739 2343739 2022-03-26 Crawford Georgia 13079 1769 53
2340486 2340486 2022-03-25 Crawford Georgia 13079 1769 53
2337233 2337233 2022-03-24 Crawford Georgia 13079 1769 53
2333979 2333979 2022-03-23 Crawford Georgia 13079 1769 53
2330725 2330725 2022-03-22 Crawford Georgia 13079 1775 53
2327473 2327473 2022-03-21 Crawford Georgia 13079 1775 53
2324220 2324220 2022-03-20 Crawford Georgia 13079 1774 53
2320966 2320966 2022-03-19 Crawford Georgia 13079 1774 53
2317712 2317712 2022-03-18 Crawford Georgia 13079 1774 53
2314459 2314459 2022-03-17 Crawford Georgia 13079 1774 53
2311206 2311206 2022-03-16 Crawford Georgia 13079 1775 53
2307953 2307953 2022-03-15 Crawford Georgia 13079 1776 53
2304702 2304702 2022-03-14 Crawford Georgia 13079 1776 52
2301450 2301450 2022-03-13 Crawford Georgia 13079 1774 52
2298198 2298198 2022-03-12 Crawford Georgia 13079 1774 52
2294946 2294946 2022-03-11 Crawford Georgia 13079 1774 52
2291694 2291694 2022-03-10 Crawford Georgia 13079 1774 52
2288442 2288442 2022-03-09 Crawford Georgia 13079 1775 52
2285191 2285191 2022-03-08 Crawford Georgia 13079 1775 52
2281939 2281939 2022-03-07 Crawford Georgia 13079 1774 52
2278686 2278686 2022-03-06 Crawford Georgia 13079 1772 52
2275433 2275433 2022-03-05 Crawford Georgia 13079 1772 52
2272180 2272180 2022-03-04 Crawford Georgia 13079 1772 52
2268928 2268928 2022-03-03 Crawford Georgia 13079 1771 52
2265675 2265675 2022-03-02 Crawford Georgia 13079 1770 52
2262424 2262424 2022-03-01 Crawford Georgia 13079 1771 52
2259173 2259173 2022-02-28 Crawford Georgia 13079 1772 52
2255922 2255922 2022-02-27 Crawford Georgia 13079 1769 51
2252671 2252671 2022-02-26 Crawford Georgia 13079 1769 51
2249420 2249420 2022-02-25 Crawford Georgia 13079 1769 51
2246169 2246169 2022-02-24 Crawford Georgia 13079 1768 51
2242918 2242918 2022-02-23 Crawford Georgia 13079 1768 51
2239667 2239667 2022-02-22 Crawford Georgia 13079 1769 51
2236416 2236416 2022-02-21 Crawford Georgia 13079 1768 51
2233165 2233165 2022-02-20 Crawford Georgia 13079 1765 51
2229914 2229914 2022-02-19 Crawford Georgia 13079 1765 51
2226663 2226663 2022-02-18 Crawford Georgia 13079 1765 51
2223412 2223412 2022-02-17 Crawford Georgia 13079 1763 51
2220161 2220161 2022-02-16 Crawford Georgia 13079 1762 51
2216910 2216910 2022-02-15 Crawford Georgia 13079 1761 51
2213659 2213659 2022-02-14 Crawford Georgia 13079 1760 50
2210407 2210407 2022-02-13 Crawford Georgia 13079 1753 50
2207154 2207154 2022-02-12 Crawford Georgia 13079 1753 50
2203901 2203901 2022-02-11 Crawford Georgia 13079 1753 50
2200648 2200648 2022-02-10 Crawford Georgia 13079 1749 50
2197394 2197394 2022-02-09 Crawford Georgia 13079 1742 50
2194140 2194140 2022-02-08 Crawford Georgia 13079 1739 50
2190886 2190886 2022-02-07 Crawford Georgia 13079 1735 50
2187633 2187633 2022-02-06 Crawford Georgia 13079 1715 50
2184380 2184380 2022-02-05 Crawford Georgia 13079 1715 50
2181128 2181128 2022-02-04 Crawford Georgia 13079 1715 50
2177877 2177877 2022-02-03 Crawford Georgia 13079 1705 50

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