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

771 rows where fips = 13105 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 · 771 ✖

fips 1

  • 13105 · 771 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500017 2500017 2022-05-13 Elbert Georgia 13105 4558 109
2496759 2496759 2022-05-12 Elbert Georgia 13105 4558 109
2493501 2493501 2022-05-11 Elbert Georgia 13105 4558 109
2490243 2490243 2022-05-10 Elbert Georgia 13105 4552 109
2486986 2486986 2022-05-09 Elbert Georgia 13105 4552 109
2483728 2483728 2022-05-08 Elbert Georgia 13105 4553 109
2480470 2480470 2022-05-07 Elbert Georgia 13105 4553 109
2477212 2477212 2022-05-06 Elbert Georgia 13105 4553 109
2473954 2473954 2022-05-05 Elbert Georgia 13105 4553 109
2470697 2470697 2022-05-04 Elbert Georgia 13105 4553 109
2467441 2467441 2022-05-03 Elbert Georgia 13105 4556 108
2464186 2464186 2022-05-02 Elbert Georgia 13105 4556 108
2460930 2460930 2022-05-01 Elbert Georgia 13105 4557 108
2457674 2457674 2022-04-30 Elbert Georgia 13105 4557 108
2454418 2454418 2022-04-29 Elbert Georgia 13105 4557 108
2451162 2451162 2022-04-28 Elbert Georgia 13105 4557 108
2447906 2447906 2022-04-27 Elbert Georgia 13105 4557 108
2444650 2444650 2022-04-26 Elbert Georgia 13105 4554 108
2441394 2441394 2022-04-25 Elbert Georgia 13105 4554 108
2438138 2438138 2022-04-24 Elbert Georgia 13105 4554 108
2434882 2434882 2022-04-23 Elbert Georgia 13105 4554 108
2431626 2431626 2022-04-22 Elbert Georgia 13105 4554 108
2428370 2428370 2022-04-21 Elbert Georgia 13105 4554 108
2425114 2425114 2022-04-20 Elbert Georgia 13105 4554 108
2421858 2421858 2022-04-19 Elbert Georgia 13105 4556 108
2418602 2418602 2022-04-18 Elbert Georgia 13105 4556 108
2415346 2415346 2022-04-17 Elbert Georgia 13105 4556 108
2412090 2412090 2022-04-16 Elbert Georgia 13105 4556 108
2408834 2408834 2022-04-15 Elbert Georgia 13105 4556 108
2405578 2405578 2022-04-14 Elbert Georgia 13105 4556 108
2402323 2402323 2022-04-13 Elbert Georgia 13105 4556 108
2399068 2399068 2022-04-12 Elbert Georgia 13105 4557 108
2395813 2395813 2022-04-11 Elbert Georgia 13105 4556 108
2392557 2392557 2022-04-10 Elbert Georgia 13105 4556 108
2389301 2389301 2022-04-09 Elbert Georgia 13105 4556 108
2386046 2386046 2022-04-08 Elbert Georgia 13105 4556 108
2382791 2382791 2022-04-07 Elbert Georgia 13105 4554 108
2379536 2379536 2022-04-06 Elbert Georgia 13105 4554 108
2376282 2376282 2022-04-05 Elbert Georgia 13105 4554 108
2373030 2373030 2022-04-04 Elbert Georgia 13105 4555 108
2369777 2369777 2022-04-03 Elbert Georgia 13105 4554 108
2366524 2366524 2022-04-02 Elbert Georgia 13105 4554 108
2363271 2363271 2022-04-01 Elbert Georgia 13105 4554 108
2360017 2360017 2022-03-31 Elbert Georgia 13105 4554 108
2356763 2356763 2022-03-30 Elbert Georgia 13105 4554 108
2353510 2353510 2022-03-29 Elbert Georgia 13105 4554 108
2350258 2350258 2022-03-28 Elbert Georgia 13105 4553 108
2347005 2347005 2022-03-27 Elbert Georgia 13105 4553 108
2343752 2343752 2022-03-26 Elbert Georgia 13105 4553 108
2340499 2340499 2022-03-25 Elbert Georgia 13105 4553 108
2337246 2337246 2022-03-24 Elbert Georgia 13105 4553 108
2333992 2333992 2022-03-23 Elbert Georgia 13105 4553 108
2330738 2330738 2022-03-22 Elbert Georgia 13105 4544 108
2327486 2327486 2022-03-21 Elbert Georgia 13105 4543 108
2324233 2324233 2022-03-20 Elbert Georgia 13105 4542 108
2320979 2320979 2022-03-19 Elbert Georgia 13105 4542 108
2317725 2317725 2022-03-18 Elbert Georgia 13105 4542 108
2314472 2314472 2022-03-17 Elbert Georgia 13105 4542 107
2311219 2311219 2022-03-16 Elbert Georgia 13105 4543 107
2307966 2307966 2022-03-15 Elbert Georgia 13105 4545 107
2304715 2304715 2022-03-14 Elbert Georgia 13105 4546 107
2301463 2301463 2022-03-13 Elbert Georgia 13105 4545 107
2298211 2298211 2022-03-12 Elbert Georgia 13105 4545 107
2294959 2294959 2022-03-11 Elbert Georgia 13105 4545 107
2291707 2291707 2022-03-10 Elbert Georgia 13105 4545 107
2288455 2288455 2022-03-09 Elbert Georgia 13105 4546 107
2285204 2285204 2022-03-08 Elbert Georgia 13105 4547 105
2281952 2281952 2022-03-07 Elbert Georgia 13105 4546 105
2278699 2278699 2022-03-06 Elbert Georgia 13105 4545 105
2275446 2275446 2022-03-05 Elbert Georgia 13105 4545 105
2272193 2272193 2022-03-04 Elbert Georgia 13105 4545 105
2268941 2268941 2022-03-03 Elbert Georgia 13105 4543 104
2265688 2265688 2022-03-02 Elbert Georgia 13105 4542 104
2262437 2262437 2022-03-01 Elbert Georgia 13105 4542 104
2259186 2259186 2022-02-28 Elbert Georgia 13105 4535 104
2255935 2255935 2022-02-27 Elbert Georgia 13105 4535 104
2252684 2252684 2022-02-26 Elbert Georgia 13105 4535 104
2249433 2249433 2022-02-25 Elbert Georgia 13105 4535 104
2246182 2246182 2022-02-24 Elbert Georgia 13105 4533 104
2242931 2242931 2022-02-23 Elbert Georgia 13105 4530 104
2239680 2239680 2022-02-22 Elbert Georgia 13105 4527 104
2236429 2236429 2022-02-21 Elbert Georgia 13105 4525 104
2233178 2233178 2022-02-20 Elbert Georgia 13105 4524 103
2229927 2229927 2022-02-19 Elbert Georgia 13105 4524 103
2226676 2226676 2022-02-18 Elbert Georgia 13105 4524 103
2223425 2223425 2022-02-17 Elbert Georgia 13105 4522 103
2220174 2220174 2022-02-16 Elbert Georgia 13105 4522 103
2216923 2216923 2022-02-15 Elbert Georgia 13105 4520 102
2213672 2213672 2022-02-14 Elbert Georgia 13105 4518 100
2210420 2210420 2022-02-13 Elbert Georgia 13105 4514 100
2207167 2207167 2022-02-12 Elbert Georgia 13105 4514 100
2203914 2203914 2022-02-11 Elbert Georgia 13105 4514 100
2200661 2200661 2022-02-10 Elbert Georgia 13105 4508 100
2197407 2197407 2022-02-09 Elbert Georgia 13105 4501 99
2194153 2194153 2022-02-08 Elbert Georgia 13105 4496 99
2190899 2190899 2022-02-07 Elbert Georgia 13105 4493 99
2187646 2187646 2022-02-06 Elbert Georgia 13105 4487 98
2184393 2184393 2022-02-05 Elbert Georgia 13105 4487 98
2181141 2181141 2022-02-04 Elbert Georgia 13105 4487 98
2177890 2177890 2022-02-03 Elbert Georgia 13105 4473 97

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