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

786 rows where county = "Early" 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 · 786 ✖

fips 1

county 1

  • Early · 786 ✖
Link rowid date ▲ county state fips cases deaths
2500014 2500014 2022-05-13 Early Georgia 13099 2765 62
2496756 2496756 2022-05-12 Early Georgia 13099 2765 62
2493498 2493498 2022-05-11 Early Georgia 13099 2765 62
2490240 2490240 2022-05-10 Early Georgia 13099 2767 62
2486983 2486983 2022-05-09 Early Georgia 13099 2767 62
2483725 2483725 2022-05-08 Early Georgia 13099 2766 62
2480467 2480467 2022-05-07 Early Georgia 13099 2766 62
2477209 2477209 2022-05-06 Early Georgia 13099 2766 62
2473951 2473951 2022-05-05 Early Georgia 13099 2766 62
2470694 2470694 2022-05-04 Early Georgia 13099 2766 62
2467438 2467438 2022-05-03 Early Georgia 13099 2765 62
2464183 2464183 2022-05-02 Early Georgia 13099 2765 62
2460927 2460927 2022-05-01 Early Georgia 13099 2765 62
2457671 2457671 2022-04-30 Early Georgia 13099 2765 62
2454415 2454415 2022-04-29 Early Georgia 13099 2765 62
2451159 2451159 2022-04-28 Early Georgia 13099 2765 62
2447903 2447903 2022-04-27 Early Georgia 13099 2765 62
2444647 2444647 2022-04-26 Early Georgia 13099 2764 62
2441391 2441391 2022-04-25 Early Georgia 13099 2764 62
2438135 2438135 2022-04-24 Early Georgia 13099 2763 62
2434879 2434879 2022-04-23 Early Georgia 13099 2763 62
2431623 2431623 2022-04-22 Early Georgia 13099 2763 62
2428367 2428367 2022-04-21 Early Georgia 13099 2763 62
2425111 2425111 2022-04-20 Early Georgia 13099 2763 62
2421855 2421855 2022-04-19 Early Georgia 13099 2762 61
2418599 2418599 2022-04-18 Early Georgia 13099 2762 61
2415343 2415343 2022-04-17 Early Georgia 13099 2762 61
2412087 2412087 2022-04-16 Early Georgia 13099 2762 61
2408831 2408831 2022-04-15 Early Georgia 13099 2762 61
2405575 2405575 2022-04-14 Early Georgia 13099 2762 61
2402320 2402320 2022-04-13 Early Georgia 13099 2762 61
2399065 2399065 2022-04-12 Early Georgia 13099 2762 61
2395810 2395810 2022-04-11 Early Georgia 13099 2762 61
2392554 2392554 2022-04-10 Early Georgia 13099 2760 61
2389298 2389298 2022-04-09 Early Georgia 13099 2760 61
2386043 2386043 2022-04-08 Early Georgia 13099 2760 61
2382788 2382788 2022-04-07 Early Georgia 13099 2760 61
2379533 2379533 2022-04-06 Early Georgia 13099 2760 61
2376279 2376279 2022-04-05 Early Georgia 13099 2760 61
2373027 2373027 2022-04-04 Early Georgia 13099 2760 61
2369774 2369774 2022-04-03 Early Georgia 13099 2759 61
2366521 2366521 2022-04-02 Early Georgia 13099 2759 61
2363268 2363268 2022-04-01 Early Georgia 13099 2759 61
2360014 2360014 2022-03-31 Early Georgia 13099 2758 61
2356760 2356760 2022-03-30 Early Georgia 13099 2758 61
2353507 2353507 2022-03-29 Early Georgia 13099 2759 60
2350255 2350255 2022-03-28 Early Georgia 13099 2759 60
2347002 2347002 2022-03-27 Early Georgia 13099 2747 60
2343749 2343749 2022-03-26 Early Georgia 13099 2747 60
2340496 2340496 2022-03-25 Early Georgia 13099 2747 60
2337243 2337243 2022-03-24 Early Georgia 13099 2747 60
2333989 2333989 2022-03-23 Early Georgia 13099 2748 60
2330735 2330735 2022-03-22 Early Georgia 13099 2748 60
2327483 2327483 2022-03-21 Early Georgia 13099 2748 60
2324230 2324230 2022-03-20 Early Georgia 13099 2748 60
2320976 2320976 2022-03-19 Early Georgia 13099 2748 60
2317722 2317722 2022-03-18 Early Georgia 13099 2748 60
2314469 2314469 2022-03-17 Early Georgia 13099 2748 60
2311216 2311216 2022-03-16 Early Georgia 13099 2747 60
2307963 2307963 2022-03-15 Early Georgia 13099 2747 60
2304712 2304712 2022-03-14 Early Georgia 13099 2747 60
2301460 2301460 2022-03-13 Early Georgia 13099 2745 60
2298208 2298208 2022-03-12 Early Georgia 13099 2745 60
2294956 2294956 2022-03-11 Early Georgia 13099 2745 60
2291704 2291704 2022-03-10 Early Georgia 13099 2744 60
2288452 2288452 2022-03-09 Early Georgia 13099 2744 60
2285201 2285201 2022-03-08 Early Georgia 13099 2744 60
2281949 2281949 2022-03-07 Early Georgia 13099 2744 60
2278696 2278696 2022-03-06 Early Georgia 13099 2741 60
2275443 2275443 2022-03-05 Early Georgia 13099 2741 60
2272190 2272190 2022-03-04 Early Georgia 13099 2741 60
2268938 2268938 2022-03-03 Early Georgia 13099 2740 60
2265685 2265685 2022-03-02 Early Georgia 13099 2740 60
2262434 2262434 2022-03-01 Early Georgia 13099 2738 60
2259183 2259183 2022-02-28 Early Georgia 13099 2736 60
2255932 2255932 2022-02-27 Early Georgia 13099 2736 60
2252681 2252681 2022-02-26 Early Georgia 13099 2736 60
2249430 2249430 2022-02-25 Early Georgia 13099 2736 60
2246179 2246179 2022-02-24 Early Georgia 13099 2736 60
2242928 2242928 2022-02-23 Early Georgia 13099 2734 60
2239677 2239677 2022-02-22 Early Georgia 13099 2734 60
2236426 2236426 2022-02-21 Early Georgia 13099 2733 60
2233175 2233175 2022-02-20 Early Georgia 13099 2729 60
2229924 2229924 2022-02-19 Early Georgia 13099 2729 60
2226673 2226673 2022-02-18 Early Georgia 13099 2729 60
2223422 2223422 2022-02-17 Early Georgia 13099 2728 60
2220171 2220171 2022-02-16 Early Georgia 13099 2726 60
2216920 2216920 2022-02-15 Early Georgia 13099 2726 60
2213669 2213669 2022-02-14 Early Georgia 13099 2723 60
2210417 2210417 2022-02-13 Early Georgia 13099 2716 60
2207164 2207164 2022-02-12 Early Georgia 13099 2716 60
2203911 2203911 2022-02-11 Early Georgia 13099 2716 60
2200658 2200658 2022-02-10 Early Georgia 13099 2713 60
2197404 2197404 2022-02-09 Early Georgia 13099 2705 60
2194150 2194150 2022-02-08 Early Georgia 13099 2704 60
2190896 2190896 2022-02-07 Early Georgia 13099 2694 60
2187643 2187643 2022-02-06 Early Georgia 13099 2683 59
2184390 2184390 2022-02-05 Early Georgia 13099 2683 59
2181138 2181138 2022-02-04 Early Georgia 13099 2683 59
2177887 2177887 2022-02-03 Early Georgia 13099 2674 59

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