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

775 rows where county = "Johnson" 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 · 775 ✖

fips 1

county 1

  • Johnson · 775 ✖
Link rowid date ▲ county state fips cases deaths
2500048 2500048 2022-05-13 Johnson Georgia 13167 2258 73
2496790 2496790 2022-05-12 Johnson Georgia 13167 2258 73
2493532 2493532 2022-05-11 Johnson Georgia 13167 2258 73
2490274 2490274 2022-05-10 Johnson Georgia 13167 2255 72
2487017 2487017 2022-05-09 Johnson Georgia 13167 2255 72
2483759 2483759 2022-05-08 Johnson Georgia 13167 2255 72
2480501 2480501 2022-05-07 Johnson Georgia 13167 2255 72
2477243 2477243 2022-05-06 Johnson Georgia 13167 2255 72
2473985 2473985 2022-05-05 Johnson Georgia 13167 2255 72
2470728 2470728 2022-05-04 Johnson Georgia 13167 2255 72
2467472 2467472 2022-05-03 Johnson Georgia 13167 2254 72
2464217 2464217 2022-05-02 Johnson Georgia 13167 2254 72
2460961 2460961 2022-05-01 Johnson Georgia 13167 2255 72
2457705 2457705 2022-04-30 Johnson Georgia 13167 2255 72
2454449 2454449 2022-04-29 Johnson Georgia 13167 2255 72
2451193 2451193 2022-04-28 Johnson Georgia 13167 2255 72
2447937 2447937 2022-04-27 Johnson Georgia 13167 2255 72
2444681 2444681 2022-04-26 Johnson Georgia 13167 2255 72
2441425 2441425 2022-04-25 Johnson Georgia 13167 2255 72
2438169 2438169 2022-04-24 Johnson Georgia 13167 2255 72
2434913 2434913 2022-04-23 Johnson Georgia 13167 2255 72
2431657 2431657 2022-04-22 Johnson Georgia 13167 2255 72
2428401 2428401 2022-04-21 Johnson Georgia 13167 2255 72
2425145 2425145 2022-04-20 Johnson Georgia 13167 2255 72
2421889 2421889 2022-04-19 Johnson Georgia 13167 2255 72
2418633 2418633 2022-04-18 Johnson Georgia 13167 2255 72
2415377 2415377 2022-04-17 Johnson Georgia 13167 2255 72
2412121 2412121 2022-04-16 Johnson Georgia 13167 2255 72
2408865 2408865 2022-04-15 Johnson Georgia 13167 2255 72
2405609 2405609 2022-04-14 Johnson Georgia 13167 2255 72
2402354 2402354 2022-04-13 Johnson Georgia 13167 2255 72
2399099 2399099 2022-04-12 Johnson Georgia 13167 2255 72
2395844 2395844 2022-04-11 Johnson Georgia 13167 2255 72
2392588 2392588 2022-04-10 Johnson Georgia 13167 2255 72
2389332 2389332 2022-04-09 Johnson Georgia 13167 2255 72
2386077 2386077 2022-04-08 Johnson Georgia 13167 2255 72
2382822 2382822 2022-04-07 Johnson Georgia 13167 2255 72
2379567 2379567 2022-04-06 Johnson Georgia 13167 2255 72
2376313 2376313 2022-04-05 Johnson Georgia 13167 2255 72
2373061 2373061 2022-04-04 Johnson Georgia 13167 2255 72
2369808 2369808 2022-04-03 Johnson Georgia 13167 2255 72
2366555 2366555 2022-04-02 Johnson Georgia 13167 2255 72
2363302 2363302 2022-04-01 Johnson Georgia 13167 2255 72
2360048 2360048 2022-03-31 Johnson Georgia 13167 2255 72
2356794 2356794 2022-03-30 Johnson Georgia 13167 2254 72
2353541 2353541 2022-03-29 Johnson Georgia 13167 2253 72
2350289 2350289 2022-03-28 Johnson Georgia 13167 2252 72
2347036 2347036 2022-03-27 Johnson Georgia 13167 2248 72
2343783 2343783 2022-03-26 Johnson Georgia 13167 2248 72
2340530 2340530 2022-03-25 Johnson Georgia 13167 2248 72
2337277 2337277 2022-03-24 Johnson Georgia 13167 2248 72
2334023 2334023 2022-03-23 Johnson Georgia 13167 2248 72
2330769 2330769 2022-03-22 Johnson Georgia 13167 2248 72
2327517 2327517 2022-03-21 Johnson Georgia 13167 2248 72
2324264 2324264 2022-03-20 Johnson Georgia 13167 2248 72
2321010 2321010 2022-03-19 Johnson Georgia 13167 2248 72
2317756 2317756 2022-03-18 Johnson Georgia 13167 2248 72
2314503 2314503 2022-03-17 Johnson Georgia 13167 2248 72
2311250 2311250 2022-03-16 Johnson Georgia 13167 2248 72
2307997 2307997 2022-03-15 Johnson Georgia 13167 2248 72
2304746 2304746 2022-03-14 Johnson Georgia 13167 2248 72
2301494 2301494 2022-03-13 Johnson Georgia 13167 2247 72
2298242 2298242 2022-03-12 Johnson Georgia 13167 2247 72
2294990 2294990 2022-03-11 Johnson Georgia 13167 2247 72
2291738 2291738 2022-03-10 Johnson Georgia 13167 2247 72
2288486 2288486 2022-03-09 Johnson Georgia 13167 2247 71
2285235 2285235 2022-03-08 Johnson Georgia 13167 2247 71
2281983 2281983 2022-03-07 Johnson Georgia 13167 2247 71
2278730 2278730 2022-03-06 Johnson Georgia 13167 2247 70
2275477 2275477 2022-03-05 Johnson Georgia 13167 2247 70
2272224 2272224 2022-03-04 Johnson Georgia 13167 2247 70
2268972 2268972 2022-03-03 Johnson Georgia 13167 2247 70
2265719 2265719 2022-03-02 Johnson Georgia 13167 2247 70
2262468 2262468 2022-03-01 Johnson Georgia 13167 2246 70
2259217 2259217 2022-02-28 Johnson Georgia 13167 2246 70
2255966 2255966 2022-02-27 Johnson Georgia 13167 2244 70
2252715 2252715 2022-02-26 Johnson Georgia 13167 2244 70
2249464 2249464 2022-02-25 Johnson Georgia 13167 2244 70
2246213 2246213 2022-02-24 Johnson Georgia 13167 2244 70
2242962 2242962 2022-02-23 Johnson Georgia 13167 2244 70
2239711 2239711 2022-02-22 Johnson Georgia 13167 2243 70
2236460 2236460 2022-02-21 Johnson Georgia 13167 2241 70
2233209 2233209 2022-02-20 Johnson Georgia 13167 2240 70
2229958 2229958 2022-02-19 Johnson Georgia 13167 2240 70
2226707 2226707 2022-02-18 Johnson Georgia 13167 2240 70
2223456 2223456 2022-02-17 Johnson Georgia 13167 2238 69
2220205 2220205 2022-02-16 Johnson Georgia 13167 2236 69
2216954 2216954 2022-02-15 Johnson Georgia 13167 2235 69
2213703 2213703 2022-02-14 Johnson Georgia 13167 2234 69
2210451 2210451 2022-02-13 Johnson Georgia 13167 2229 69
2207198 2207198 2022-02-12 Johnson Georgia 13167 2229 69
2203945 2203945 2022-02-11 Johnson Georgia 13167 2229 69
2200692 2200692 2022-02-10 Johnson Georgia 13167 2224 67
2197438 2197438 2022-02-09 Johnson Georgia 13167 2220 67
2194184 2194184 2022-02-08 Johnson Georgia 13167 2218 66
2190930 2190930 2022-02-07 Johnson Georgia 13167 2217 66
2187677 2187677 2022-02-06 Johnson Georgia 13167 2203 66
2184424 2184424 2022-02-05 Johnson Georgia 13167 2203 66
2181172 2181172 2022-02-04 Johnson Georgia 13167 2203 66
2177921 2177921 2022-02-03 Johnson Georgia 13167 2186 66

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