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

795 rows where county = "Charlton" 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 · 795 ✖

fips 1

county 1

  • Charlton · 795 ✖
Link rowid date ▲ county state fips cases deaths
2499989 2499989 2022-05-13 Charlton Georgia 13049 3067 62
2496731 2496731 2022-05-12 Charlton Georgia 13049 3067 62
2493473 2493473 2022-05-11 Charlton Georgia 13049 3067 62
2490215 2490215 2022-05-10 Charlton Georgia 13049 3064 62
2486958 2486958 2022-05-09 Charlton Georgia 13049 3064 62
2483700 2483700 2022-05-08 Charlton Georgia 13049 3064 62
2480442 2480442 2022-05-07 Charlton Georgia 13049 3064 62
2477184 2477184 2022-05-06 Charlton Georgia 13049 3064 62
2473926 2473926 2022-05-05 Charlton Georgia 13049 3064 62
2470669 2470669 2022-05-04 Charlton Georgia 13049 3064 62
2467413 2467413 2022-05-03 Charlton Georgia 13049 3056 62
2464158 2464158 2022-05-02 Charlton Georgia 13049 3056 62
2460902 2460902 2022-05-01 Charlton Georgia 13049 3056 62
2457646 2457646 2022-04-30 Charlton Georgia 13049 3056 62
2454390 2454390 2022-04-29 Charlton Georgia 13049 3056 62
2451134 2451134 2022-04-28 Charlton Georgia 13049 3056 62
2447878 2447878 2022-04-27 Charlton Georgia 13049 3056 62
2444622 2444622 2022-04-26 Charlton Georgia 13049 3054 62
2441366 2441366 2022-04-25 Charlton Georgia 13049 3054 62
2438110 2438110 2022-04-24 Charlton Georgia 13049 3054 62
2434854 2434854 2022-04-23 Charlton Georgia 13049 3054 62
2431598 2431598 2022-04-22 Charlton Georgia 13049 3054 62
2428342 2428342 2022-04-21 Charlton Georgia 13049 3054 62
2425086 2425086 2022-04-20 Charlton Georgia 13049 3054 62
2421830 2421830 2022-04-19 Charlton Georgia 13049 3052 62
2418574 2418574 2022-04-18 Charlton Georgia 13049 3052 62
2415318 2415318 2022-04-17 Charlton Georgia 13049 3055 62
2412062 2412062 2022-04-16 Charlton Georgia 13049 3055 62
2408806 2408806 2022-04-15 Charlton Georgia 13049 3055 62
2405550 2405550 2022-04-14 Charlton Georgia 13049 3054 62
2402295 2402295 2022-04-13 Charlton Georgia 13049 3061 62
2399040 2399040 2022-04-12 Charlton Georgia 13049 3059 62
2395785 2395785 2022-04-11 Charlton Georgia 13049 3076 63
2392529 2392529 2022-04-10 Charlton Georgia 13049 3070 63
2389273 2389273 2022-04-09 Charlton Georgia 13049 3070 63
2386018 2386018 2022-04-08 Charlton Georgia 13049 3070 63
2382763 2382763 2022-04-07 Charlton Georgia 13049 3069 63
2379508 2379508 2022-04-06 Charlton Georgia 13049 3069 62
2376254 2376254 2022-04-05 Charlton Georgia 13049 3068 62
2373002 2373002 2022-04-04 Charlton Georgia 13049 3067 62
2369749 2369749 2022-04-03 Charlton Georgia 13049 3058 62
2366496 2366496 2022-04-02 Charlton Georgia 13049 3058 62
2363243 2363243 2022-04-01 Charlton Georgia 13049 3058 62
2359989 2359989 2022-03-31 Charlton Georgia 13049 3058 62
2356735 2356735 2022-03-30 Charlton Georgia 13049 3056 62
2353482 2353482 2022-03-29 Charlton Georgia 13049 3055 62
2350230 2350230 2022-03-28 Charlton Georgia 13049 3056 62
2346977 2346977 2022-03-27 Charlton Georgia 13049 3058 62
2343724 2343724 2022-03-26 Charlton Georgia 13049 3058 62
2340471 2340471 2022-03-25 Charlton Georgia 13049 3058 62
2337218 2337218 2022-03-24 Charlton Georgia 13049 3059 62
2333964 2333964 2022-03-23 Charlton Georgia 13049 3060 62
2330710 2330710 2022-03-22 Charlton Georgia 13049 3060 62
2327458 2327458 2022-03-21 Charlton Georgia 13049 3057 62
2324205 2324205 2022-03-20 Charlton Georgia 13049 3052 62
2320951 2320951 2022-03-19 Charlton Georgia 13049 3052 62
2317697 2317697 2022-03-18 Charlton Georgia 13049 3052 62
2314444 2314444 2022-03-17 Charlton Georgia 13049 3048 62
2311191 2311191 2022-03-16 Charlton Georgia 13049 3044 62
2307938 2307938 2022-03-15 Charlton Georgia 13049 3042 62
2304687 2304687 2022-03-14 Charlton Georgia 13049 3034 62
2301435 2301435 2022-03-13 Charlton Georgia 13049 3026 62
2298183 2298183 2022-03-12 Charlton Georgia 13049 3026 62
2294931 2294931 2022-03-11 Charlton Georgia 13049 3026 62
2291679 2291679 2022-03-10 Charlton Georgia 13049 3018 62
2288427 2288427 2022-03-09 Charlton Georgia 13049 3013 62
2285176 2285176 2022-03-08 Charlton Georgia 13049 3008 62
2281924 2281924 2022-03-07 Charlton Georgia 13049 3002 62
2278671 2278671 2022-03-06 Charlton Georgia 13049 2999 62
2275418 2275418 2022-03-05 Charlton Georgia 13049 2999 62
2272165 2272165 2022-03-04 Charlton Georgia 13049 2999 62
2268913 2268913 2022-03-03 Charlton Georgia 13049 3000 62
2265660 2265660 2022-03-02 Charlton Georgia 13049 2992 62
2262409 2262409 2022-03-01 Charlton Georgia 13049 2974 62
2259158 2259158 2022-02-28 Charlton Georgia 13049 2967 61
2255907 2255907 2022-02-27 Charlton Georgia 13049 2960 61
2252656 2252656 2022-02-26 Charlton Georgia 13049 2960 61
2249405 2249405 2022-02-25 Charlton Georgia 13049 2960 61
2246154 2246154 2022-02-24 Charlton Georgia 13049 2957 61
2242903 2242903 2022-02-23 Charlton Georgia 13049 2946 61
2239652 2239652 2022-02-22 Charlton Georgia 13049 2938 61
2236401 2236401 2022-02-21 Charlton Georgia 13049 2923 60
2233150 2233150 2022-02-20 Charlton Georgia 13049 2912 59
2229899 2229899 2022-02-19 Charlton Georgia 13049 2912 59
2226648 2226648 2022-02-18 Charlton Georgia 13049 2912 59
2223397 2223397 2022-02-17 Charlton Georgia 13049 2904 59
2220146 2220146 2022-02-16 Charlton Georgia 13049 2895 59
2216895 2216895 2022-02-15 Charlton Georgia 13049 2883 58
2213644 2213644 2022-02-14 Charlton Georgia 13049 2870 58
2210392 2210392 2022-02-13 Charlton Georgia 13049 2838 58
2207139 2207139 2022-02-12 Charlton Georgia 13049 2838 58
2203886 2203886 2022-02-11 Charlton Georgia 13049 2838 58
2200633 2200633 2022-02-10 Charlton Georgia 13049 2829 58
2197379 2197379 2022-02-09 Charlton Georgia 13049 2823 58
2194125 2194125 2022-02-08 Charlton Georgia 13049 2807 58
2190871 2190871 2022-02-07 Charlton Georgia 13049 2790 58
2187618 2187618 2022-02-06 Charlton Georgia 13049 2759 58
2184365 2184365 2022-02-05 Charlton Georgia 13049 2759 58
2181113 2181113 2022-02-04 Charlton Georgia 13049 2759 58
2177862 2177862 2022-02-03 Charlton Georgia 13049 2752 58

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