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

779 rows where county = "Franklin", fips = 13119 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 · 779 ✖

fips 1

  • 13119 · 779 ✖

county 1

  • Franklin · 779 ✖
Link rowid date ▲ county state fips cases deaths
2500024 2500024 2022-05-13 Franklin Georgia 13119 5414 104
2496766 2496766 2022-05-12 Franklin Georgia 13119 5414 104
2493508 2493508 2022-05-11 Franklin Georgia 13119 5414 104
2490250 2490250 2022-05-10 Franklin Georgia 13119 5413 103
2486993 2486993 2022-05-09 Franklin Georgia 13119 5413 103
2483735 2483735 2022-05-08 Franklin Georgia 13119 5412 103
2480477 2480477 2022-05-07 Franklin Georgia 13119 5412 103
2477219 2477219 2022-05-06 Franklin Georgia 13119 5412 103
2473961 2473961 2022-05-05 Franklin Georgia 13119 5412 103
2470704 2470704 2022-05-04 Franklin Georgia 13119 5412 103
2467448 2467448 2022-05-03 Franklin Georgia 13119 5412 101
2464193 2464193 2022-05-02 Franklin Georgia 13119 5412 101
2460937 2460937 2022-05-01 Franklin Georgia 13119 5411 101
2457681 2457681 2022-04-30 Franklin Georgia 13119 5411 101
2454425 2454425 2022-04-29 Franklin Georgia 13119 5411 101
2451169 2451169 2022-04-28 Franklin Georgia 13119 5411 101
2447913 2447913 2022-04-27 Franklin Georgia 13119 5411 101
2444657 2444657 2022-04-26 Franklin Georgia 13119 5407 101
2441401 2441401 2022-04-25 Franklin Georgia 13119 5407 101
2438145 2438145 2022-04-24 Franklin Georgia 13119 5406 101
2434889 2434889 2022-04-23 Franklin Georgia 13119 5406 101
2431633 2431633 2022-04-22 Franklin Georgia 13119 5406 101
2428377 2428377 2022-04-21 Franklin Georgia 13119 5406 101
2425121 2425121 2022-04-20 Franklin Georgia 13119 5406 101
2421865 2421865 2022-04-19 Franklin Georgia 13119 5406 101
2418609 2418609 2022-04-18 Franklin Georgia 13119 5406 101
2415353 2415353 2022-04-17 Franklin Georgia 13119 5405 101
2412097 2412097 2022-04-16 Franklin Georgia 13119 5405 101
2408841 2408841 2022-04-15 Franklin Georgia 13119 5405 101
2405585 2405585 2022-04-14 Franklin Georgia 13119 5404 101
2402330 2402330 2022-04-13 Franklin Georgia 13119 5403 101
2399075 2399075 2022-04-12 Franklin Georgia 13119 5402 100
2395820 2395820 2022-04-11 Franklin Georgia 13119 5401 100
2392564 2392564 2022-04-10 Franklin Georgia 13119 5397 99
2389308 2389308 2022-04-09 Franklin Georgia 13119 5397 99
2386053 2386053 2022-04-08 Franklin Georgia 13119 5397 99
2382798 2382798 2022-04-07 Franklin Georgia 13119 5399 98
2379543 2379543 2022-04-06 Franklin Georgia 13119 5399 97
2376289 2376289 2022-04-05 Franklin Georgia 13119 5398 97
2373037 2373037 2022-04-04 Franklin Georgia 13119 5398 96
2369784 2369784 2022-04-03 Franklin Georgia 13119 5399 96
2366531 2366531 2022-04-02 Franklin Georgia 13119 5399 96
2363278 2363278 2022-04-01 Franklin Georgia 13119 5399 96
2360024 2360024 2022-03-31 Franklin Georgia 13119 5400 96
2356770 2356770 2022-03-30 Franklin Georgia 13119 5399 96
2353517 2353517 2022-03-29 Franklin Georgia 13119 5396 96
2350265 2350265 2022-03-28 Franklin Georgia 13119 5396 96
2347012 2347012 2022-03-27 Franklin Georgia 13119 5394 96
2343759 2343759 2022-03-26 Franklin Georgia 13119 5394 96
2340506 2340506 2022-03-25 Franklin Georgia 13119 5394 96
2337253 2337253 2022-03-24 Franklin Georgia 13119 5394 95
2333999 2333999 2022-03-23 Franklin Georgia 13119 5392 95
2330745 2330745 2022-03-22 Franklin Georgia 13119 5392 95
2327493 2327493 2022-03-21 Franklin Georgia 13119 5390 95
2324240 2324240 2022-03-20 Franklin Georgia 13119 5390 95
2320986 2320986 2022-03-19 Franklin Georgia 13119 5390 95
2317732 2317732 2022-03-18 Franklin Georgia 13119 5390 95
2314479 2314479 2022-03-17 Franklin Georgia 13119 5387 95
2311226 2311226 2022-03-16 Franklin Georgia 13119 5387 94
2307973 2307973 2022-03-15 Franklin Georgia 13119 5390 94
2304722 2304722 2022-03-14 Franklin Georgia 13119 5390 94
2301470 2301470 2022-03-13 Franklin Georgia 13119 5388 94
2298218 2298218 2022-03-12 Franklin Georgia 13119 5388 94
2294966 2294966 2022-03-11 Franklin Georgia 13119 5388 94
2291714 2291714 2022-03-10 Franklin Georgia 13119 5389 94
2288462 2288462 2022-03-09 Franklin Georgia 13119 5388 94
2285211 2285211 2022-03-08 Franklin Georgia 13119 5388 94
2281959 2281959 2022-03-07 Franklin Georgia 13119 5388 94
2278706 2278706 2022-03-06 Franklin Georgia 13119 5387 94
2275453 2275453 2022-03-05 Franklin Georgia 13119 5387 94
2272200 2272200 2022-03-04 Franklin Georgia 13119 5387 94
2268948 2268948 2022-03-03 Franklin Georgia 13119 5386 94
2265695 2265695 2022-03-02 Franklin Georgia 13119 5385 94
2262444 2262444 2022-03-01 Franklin Georgia 13119 5383 94
2259193 2259193 2022-02-28 Franklin Georgia 13119 5380 94
2255942 2255942 2022-02-27 Franklin Georgia 13119 5378 94
2252691 2252691 2022-02-26 Franklin Georgia 13119 5378 94
2249440 2249440 2022-02-25 Franklin Georgia 13119 5378 94
2246189 2246189 2022-02-24 Franklin Georgia 13119 5374 94
2242938 2242938 2022-02-23 Franklin Georgia 13119 5369 94
2239687 2239687 2022-02-22 Franklin Georgia 13119 5368 94
2236436 2236436 2022-02-21 Franklin Georgia 13119 5367 92
2233185 2233185 2022-02-20 Franklin Georgia 13119 5360 92
2229934 2229934 2022-02-19 Franklin Georgia 13119 5360 92
2226683 2226683 2022-02-18 Franklin Georgia 13119 5360 92
2223432 2223432 2022-02-17 Franklin Georgia 13119 5357 92
2220181 2220181 2022-02-16 Franklin Georgia 13119 5354 92
2216930 2216930 2022-02-15 Franklin Georgia 13119 5344 91
2213679 2213679 2022-02-14 Franklin Georgia 13119 5339 91
2210427 2210427 2022-02-13 Franklin Georgia 13119 5323 91
2207174 2207174 2022-02-12 Franklin Georgia 13119 5323 91
2203921 2203921 2022-02-11 Franklin Georgia 13119 5323 91
2200668 2200668 2022-02-10 Franklin Georgia 13119 5297 90
2197414 2197414 2022-02-09 Franklin Georgia 13119 5273 90
2194160 2194160 2022-02-08 Franklin Georgia 13119 5258 90
2190906 2190906 2022-02-07 Franklin Georgia 13119 5255 92
2187653 2187653 2022-02-06 Franklin Georgia 13119 5221 92
2184400 2184400 2022-02-05 Franklin Georgia 13119 5221 92
2181148 2181148 2022-02-04 Franklin Georgia 13119 5221 92
2177897 2177897 2022-02-03 Franklin Georgia 13119 5207 92

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