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

781 rows where county = "Greene" 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 · 781 ✖

fips 1

county 1

  • Greene · 781 ✖
Link rowid date ▲ county state fips cases deaths
2500031 2500031 2022-05-13 Greene Georgia 13133 3974 85
2496773 2496773 2022-05-12 Greene Georgia 13133 3974 85
2493515 2493515 2022-05-11 Greene Georgia 13133 3974 85
2490257 2490257 2022-05-10 Greene Georgia 13133 3954 85
2487000 2487000 2022-05-09 Greene Georgia 13133 3954 85
2483742 2483742 2022-05-08 Greene Georgia 13133 3954 85
2480484 2480484 2022-05-07 Greene Georgia 13133 3954 85
2477226 2477226 2022-05-06 Greene Georgia 13133 3954 85
2473968 2473968 2022-05-05 Greene Georgia 13133 3954 85
2470711 2470711 2022-05-04 Greene Georgia 13133 3954 85
2467455 2467455 2022-05-03 Greene Georgia 13133 3946 85
2464200 2464200 2022-05-02 Greene Georgia 13133 3946 85
2460944 2460944 2022-05-01 Greene Georgia 13133 3946 85
2457688 2457688 2022-04-30 Greene Georgia 13133 3946 85
2454432 2454432 2022-04-29 Greene Georgia 13133 3946 85
2451176 2451176 2022-04-28 Greene Georgia 13133 3946 85
2447920 2447920 2022-04-27 Greene Georgia 13133 3946 85
2444664 2444664 2022-04-26 Greene Georgia 13133 3934 85
2441408 2441408 2022-04-25 Greene Georgia 13133 3934 85
2438152 2438152 2022-04-24 Greene Georgia 13133 3935 85
2434896 2434896 2022-04-23 Greene Georgia 13133 3935 85
2431640 2431640 2022-04-22 Greene Georgia 13133 3935 85
2428384 2428384 2022-04-21 Greene Georgia 13133 3935 85
2425128 2425128 2022-04-20 Greene Georgia 13133 3935 85
2421872 2421872 2022-04-19 Greene Georgia 13133 3931 84
2418616 2418616 2022-04-18 Greene Georgia 13133 3931 84
2415360 2415360 2022-04-17 Greene Georgia 13133 3931 84
2412104 2412104 2022-04-16 Greene Georgia 13133 3931 84
2408848 2408848 2022-04-15 Greene Georgia 13133 3931 84
2405592 2405592 2022-04-14 Greene Georgia 13133 3928 84
2402337 2402337 2022-04-13 Greene Georgia 13133 3927 84
2399082 2399082 2022-04-12 Greene Georgia 13133 3928 84
2395827 2395827 2022-04-11 Greene Georgia 13133 3927 84
2392571 2392571 2022-04-10 Greene Georgia 13133 3926 84
2389315 2389315 2022-04-09 Greene Georgia 13133 3926 84
2386060 2386060 2022-04-08 Greene Georgia 13133 3926 84
2382805 2382805 2022-04-07 Greene Georgia 13133 3925 83
2379550 2379550 2022-04-06 Greene Georgia 13133 3925 83
2376296 2376296 2022-04-05 Greene Georgia 13133 3925 83
2373044 2373044 2022-04-04 Greene Georgia 13133 3924 83
2369791 2369791 2022-04-03 Greene Georgia 13133 3923 83
2366538 2366538 2022-04-02 Greene Georgia 13133 3923 83
2363285 2363285 2022-04-01 Greene Georgia 13133 3923 83
2360031 2360031 2022-03-31 Greene Georgia 13133 3922 83
2356777 2356777 2022-03-30 Greene Georgia 13133 3920 83
2353524 2353524 2022-03-29 Greene Georgia 13133 3918 83
2350272 2350272 2022-03-28 Greene Georgia 13133 3917 83
2347019 2347019 2022-03-27 Greene Georgia 13133 3916 83
2343766 2343766 2022-03-26 Greene Georgia 13133 3916 83
2340513 2340513 2022-03-25 Greene Georgia 13133 3916 83
2337260 2337260 2022-03-24 Greene Georgia 13133 3914 83
2334006 2334006 2022-03-23 Greene Georgia 13133 3913 83
2330752 2330752 2022-03-22 Greene Georgia 13133 3913 83
2327500 2327500 2022-03-21 Greene Georgia 13133 3912 83
2324247 2324247 2022-03-20 Greene Georgia 13133 3906 83
2320993 2320993 2022-03-19 Greene Georgia 13133 3906 83
2317739 2317739 2022-03-18 Greene Georgia 13133 3906 83
2314486 2314486 2022-03-17 Greene Georgia 13133 3906 83
2311233 2311233 2022-03-16 Greene Georgia 13133 3903 82
2307980 2307980 2022-03-15 Greene Georgia 13133 3903 82
2304729 2304729 2022-03-14 Greene Georgia 13133 3903 82
2301477 2301477 2022-03-13 Greene Georgia 13133 3901 81
2298225 2298225 2022-03-12 Greene Georgia 13133 3901 81
2294973 2294973 2022-03-11 Greene Georgia 13133 3901 81
2291721 2291721 2022-03-10 Greene Georgia 13133 3899 81
2288469 2288469 2022-03-09 Greene Georgia 13133 3899 80
2285218 2285218 2022-03-08 Greene Georgia 13133 3898 80
2281966 2281966 2022-03-07 Greene Georgia 13133 3898 80
2278713 2278713 2022-03-06 Greene Georgia 13133 3897 80
2275460 2275460 2022-03-05 Greene Georgia 13133 3897 80
2272207 2272207 2022-03-04 Greene Georgia 13133 3897 80
2268955 2268955 2022-03-03 Greene Georgia 13133 3896 80
2265702 2265702 2022-03-02 Greene Georgia 13133 3896 80
2262451 2262451 2022-03-01 Greene Georgia 13133 3895 80
2259200 2259200 2022-02-28 Greene Georgia 13133 3895 80
2255949 2255949 2022-02-27 Greene Georgia 13133 3890 80
2252698 2252698 2022-02-26 Greene Georgia 13133 3890 80
2249447 2249447 2022-02-25 Greene Georgia 13133 3890 80
2246196 2246196 2022-02-24 Greene Georgia 13133 3890 80
2242945 2242945 2022-02-23 Greene Georgia 13133 3884 80
2239694 2239694 2022-02-22 Greene Georgia 13133 3882 80
2236443 2236443 2022-02-21 Greene Georgia 13133 3881 80
2233192 2233192 2022-02-20 Greene Georgia 13133 3877 79
2229941 2229941 2022-02-19 Greene Georgia 13133 3877 79
2226690 2226690 2022-02-18 Greene Georgia 13133 3877 79
2223439 2223439 2022-02-17 Greene Georgia 13133 3872 79
2220188 2220188 2022-02-16 Greene Georgia 13133 3866 78
2216937 2216937 2022-02-15 Greene Georgia 13133 3861 77
2213686 2213686 2022-02-14 Greene Georgia 13133 3857 77
2210434 2210434 2022-02-13 Greene Georgia 13133 3843 77
2207181 2207181 2022-02-12 Greene Georgia 13133 3843 77
2203928 2203928 2022-02-11 Greene Georgia 13133 3843 77
2200675 2200675 2022-02-10 Greene Georgia 13133 3838 77
2197421 2197421 2022-02-09 Greene Georgia 13133 3836 76
2194167 2194167 2022-02-08 Greene Georgia 13133 3828 75
2190913 2190913 2022-02-07 Greene Georgia 13133 3824 75
2187660 2187660 2022-02-06 Greene Georgia 13133 3808 75
2184407 2184407 2022-02-05 Greene Georgia 13133 3808 75
2181155 2181155 2022-02-04 Greene Georgia 13133 3808 75
2177904 2177904 2022-02-03 Greene Georgia 13133 3790 75

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