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

790 rows where fips = 13217 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 · 790 ✖

fips 1

  • 13217 · 790 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500072 2500072 2022-05-13 Newton Georgia 13217 24799 457
2496814 2496814 2022-05-12 Newton Georgia 13217 24799 457
2493556 2493556 2022-05-11 Newton Georgia 13217 24799 457
2490298 2490298 2022-05-10 Newton Georgia 13217 24722 456
2487041 2487041 2022-05-09 Newton Georgia 13217 24722 456
2483783 2483783 2022-05-08 Newton Georgia 13217 24722 456
2480525 2480525 2022-05-07 Newton Georgia 13217 24722 456
2477267 2477267 2022-05-06 Newton Georgia 13217 24722 456
2474009 2474009 2022-05-05 Newton Georgia 13217 24722 456
2470752 2470752 2022-05-04 Newton Georgia 13217 24722 456
2467496 2467496 2022-05-03 Newton Georgia 13217 24664 456
2464241 2464241 2022-05-02 Newton Georgia 13217 24664 456
2460985 2460985 2022-05-01 Newton Georgia 13217 24664 456
2457729 2457729 2022-04-30 Newton Georgia 13217 24664 456
2454473 2454473 2022-04-29 Newton Georgia 13217 24664 456
2451217 2451217 2022-04-28 Newton Georgia 13217 24664 456
2447961 2447961 2022-04-27 Newton Georgia 13217 24664 456
2444705 2444705 2022-04-26 Newton Georgia 13217 24630 455
2441449 2441449 2022-04-25 Newton Georgia 13217 24630 455
2438193 2438193 2022-04-24 Newton Georgia 13217 24629 455
2434937 2434937 2022-04-23 Newton Georgia 13217 24629 455
2431681 2431681 2022-04-22 Newton Georgia 13217 24629 455
2428425 2428425 2022-04-21 Newton Georgia 13217 24629 455
2425169 2425169 2022-04-20 Newton Georgia 13217 24629 455
2421913 2421913 2022-04-19 Newton Georgia 13217 24620 454
2418657 2418657 2022-04-18 Newton Georgia 13217 24620 454
2415401 2415401 2022-04-17 Newton Georgia 13217 24619 454
2412145 2412145 2022-04-16 Newton Georgia 13217 24619 454
2408889 2408889 2022-04-15 Newton Georgia 13217 24619 454
2405633 2405633 2022-04-14 Newton Georgia 13217 24614 452
2402378 2402378 2022-04-13 Newton Georgia 13217 24609 452
2399123 2399123 2022-04-12 Newton Georgia 13217 24607 451
2395868 2395868 2022-04-11 Newton Georgia 13217 24604 451
2392612 2392612 2022-04-10 Newton Georgia 13217 24595 451
2389356 2389356 2022-04-09 Newton Georgia 13217 24595 451
2386101 2386101 2022-04-08 Newton Georgia 13217 24595 451
2382846 2382846 2022-04-07 Newton Georgia 13217 24591 451
2379591 2379591 2022-04-06 Newton Georgia 13217 24582 450
2376337 2376337 2022-04-05 Newton Georgia 13217 24581 450
2373085 2373085 2022-04-04 Newton Georgia 13217 24578 449
2369832 2369832 2022-04-03 Newton Georgia 13217 24572 446
2366579 2366579 2022-04-02 Newton Georgia 13217 24572 446
2363326 2363326 2022-04-01 Newton Georgia 13217 24572 446
2360072 2360072 2022-03-31 Newton Georgia 13217 24567 445
2356818 2356818 2022-03-30 Newton Georgia 13217 24557 444
2353565 2353565 2022-03-29 Newton Georgia 13217 24480 444
2350313 2350313 2022-03-28 Newton Georgia 13217 24478 442
2347060 2347060 2022-03-27 Newton Georgia 13217 24466 442
2343807 2343807 2022-03-26 Newton Georgia 13217 24466 442
2340554 2340554 2022-03-25 Newton Georgia 13217 24466 442
2337301 2337301 2022-03-24 Newton Georgia 13217 24461 442
2334047 2334047 2022-03-23 Newton Georgia 13217 24459 441
2330793 2330793 2022-03-22 Newton Georgia 13217 24453 441
2327541 2327541 2022-03-21 Newton Georgia 13217 24446 441
2324288 2324288 2022-03-20 Newton Georgia 13217 24442 438
2321034 2321034 2022-03-19 Newton Georgia 13217 24442 438
2317780 2317780 2022-03-18 Newton Georgia 13217 24442 438
2314527 2314527 2022-03-17 Newton Georgia 13217 24433 436
2311274 2311274 2022-03-16 Newton Georgia 13217 24439 435
2308021 2308021 2022-03-15 Newton Georgia 13217 24435 431
2304770 2304770 2022-03-14 Newton Georgia 13217 24424 431
2301518 2301518 2022-03-13 Newton Georgia 13217 24417 430
2298266 2298266 2022-03-12 Newton Georgia 13217 24417 430
2295014 2295014 2022-03-11 Newton Georgia 13217 24417 430
2291762 2291762 2022-03-10 Newton Georgia 13217 24410 430
2288510 2288510 2022-03-09 Newton Georgia 13217 24405 428
2285259 2285259 2022-03-08 Newton Georgia 13217 24399 426
2282007 2282007 2022-03-07 Newton Georgia 13217 24393 425
2278754 2278754 2022-03-06 Newton Georgia 13217 24380 424
2275501 2275501 2022-03-05 Newton Georgia 13217 24380 424
2272248 2272248 2022-03-04 Newton Georgia 13217 24380 424
2268996 2268996 2022-03-03 Newton Georgia 13217 24371 424
2265743 2265743 2022-03-02 Newton Georgia 13217 24364 424
2262492 2262492 2022-03-01 Newton Georgia 13217 24363 424
2259241 2259241 2022-02-28 Newton Georgia 13217 24351 424
2255990 2255990 2022-02-27 Newton Georgia 13217 24333 424
2252739 2252739 2022-02-26 Newton Georgia 13217 24333 424
2249488 2249488 2022-02-25 Newton Georgia 13217 24333 424
2246237 2246237 2022-02-24 Newton Georgia 13217 24320 424
2242986 2242986 2022-02-23 Newton Georgia 13217 24308 424
2239735 2239735 2022-02-22 Newton Georgia 13217 24296 423
2236484 2236484 2022-02-21 Newton Georgia 13217 24285 421
2233233 2233233 2022-02-20 Newton Georgia 13217 24254 420
2229982 2229982 2022-02-19 Newton Georgia 13217 24254 420
2226731 2226731 2022-02-18 Newton Georgia 13217 24254 420
2223480 2223480 2022-02-17 Newton Georgia 13217 24225 418
2220229 2220229 2022-02-16 Newton Georgia 13217 24189 417
2216978 2216978 2022-02-15 Newton Georgia 13217 24172 417
2213727 2213727 2022-02-14 Newton Georgia 13217 24150 416
2210475 2210475 2022-02-13 Newton Georgia 13217 24098 413
2207222 2207222 2022-02-12 Newton Georgia 13217 24098 413
2203969 2203969 2022-02-11 Newton Georgia 13217 24098 413
2200716 2200716 2022-02-10 Newton Georgia 13217 24067 412
2197462 2197462 2022-02-09 Newton Georgia 13217 24031 412
2194208 2194208 2022-02-08 Newton Georgia 13217 23985 411
2190954 2190954 2022-02-07 Newton Georgia 13217 23954 405
2187701 2187701 2022-02-06 Newton Georgia 13217 23846 404
2184448 2184448 2022-02-05 Newton Georgia 13217 23846 404
2181196 2181196 2022-02-04 Newton Georgia 13217 23846 404
2177945 2177945 2022-02-03 Newton Georgia 13217 23779 403

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