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

792 rows where fips = 13151 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 · 792 ✖

fips 1

  • 13151 · 792 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500040 2500040 2022-05-13 Henry Georgia 13151 58353 688
2496782 2496782 2022-05-12 Henry Georgia 13151 58353 688
2493524 2493524 2022-05-11 Henry Georgia 13151 58353 688
2490266 2490266 2022-05-10 Henry Georgia 13151 58148 687
2487009 2487009 2022-05-09 Henry Georgia 13151 58148 687
2483751 2483751 2022-05-08 Henry Georgia 13151 58146 687
2480493 2480493 2022-05-07 Henry Georgia 13151 58146 687
2477235 2477235 2022-05-06 Henry Georgia 13151 58146 687
2473977 2473977 2022-05-05 Henry Georgia 13151 58146 687
2470720 2470720 2022-05-04 Henry Georgia 13151 58146 687
2467464 2467464 2022-05-03 Henry Georgia 13151 58036 683
2464209 2464209 2022-05-02 Henry Georgia 13151 58036 683
2460953 2460953 2022-05-01 Henry Georgia 13151 58035 683
2457697 2457697 2022-04-30 Henry Georgia 13151 58035 683
2454441 2454441 2022-04-29 Henry Georgia 13151 58035 683
2451185 2451185 2022-04-28 Henry Georgia 13151 58035 683
2447929 2447929 2022-04-27 Henry Georgia 13151 58035 683
2444673 2444673 2022-04-26 Henry Georgia 13151 57930 683
2441417 2441417 2022-04-25 Henry Georgia 13151 57930 683
2438161 2438161 2022-04-24 Henry Georgia 13151 57929 683
2434905 2434905 2022-04-23 Henry Georgia 13151 57929 683
2431649 2431649 2022-04-22 Henry Georgia 13151 57929 683
2428393 2428393 2022-04-21 Henry Georgia 13151 57929 683
2425137 2425137 2022-04-20 Henry Georgia 13151 57929 683
2421881 2421881 2022-04-19 Henry Georgia 13151 57894 678
2418625 2418625 2022-04-18 Henry Georgia 13151 57894 678
2415369 2415369 2022-04-17 Henry Georgia 13151 57892 678
2412113 2412113 2022-04-16 Henry Georgia 13151 57892 678
2408857 2408857 2022-04-15 Henry Georgia 13151 57892 678
2405601 2405601 2022-04-14 Henry Georgia 13151 57880 678
2402346 2402346 2022-04-13 Henry Georgia 13151 57870 676
2399091 2399091 2022-04-12 Henry Georgia 13151 57859 676
2395836 2395836 2022-04-11 Henry Georgia 13151 57849 675
2392580 2392580 2022-04-10 Henry Georgia 13151 57828 675
2389324 2389324 2022-04-09 Henry Georgia 13151 57828 675
2386069 2386069 2022-04-08 Henry Georgia 13151 57828 675
2382814 2382814 2022-04-07 Henry Georgia 13151 57824 674
2379559 2379559 2022-04-06 Henry Georgia 13151 57819 674
2376305 2376305 2022-04-05 Henry Georgia 13151 57813 673
2373053 2373053 2022-04-04 Henry Georgia 13151 57811 671
2369800 2369800 2022-04-03 Henry Georgia 13151 57797 669
2366547 2366547 2022-04-02 Henry Georgia 13151 57797 669
2363294 2363294 2022-04-01 Henry Georgia 13151 57797 669
2360040 2360040 2022-03-31 Henry Georgia 13151 57791 668
2356786 2356786 2022-03-30 Henry Georgia 13151 57743 667
2353533 2353533 2022-03-29 Henry Georgia 13151 57643 665
2350281 2350281 2022-03-28 Henry Georgia 13151 57633 664
2347028 2347028 2022-03-27 Henry Georgia 13151 57616 664
2343775 2343775 2022-03-26 Henry Georgia 13151 57616 664
2340522 2340522 2022-03-25 Henry Georgia 13151 57616 664
2337269 2337269 2022-03-24 Henry Georgia 13151 57608 662
2334015 2334015 2022-03-23 Henry Georgia 13151 57600 661
2330761 2330761 2022-03-22 Henry Georgia 13151 57597 661
2327509 2327509 2022-03-21 Henry Georgia 13151 57587 661
2324256 2324256 2022-03-20 Henry Georgia 13151 57568 660
2321002 2321002 2022-03-19 Henry Georgia 13151 57568 660
2317748 2317748 2022-03-18 Henry Georgia 13151 57568 660
2314495 2314495 2022-03-17 Henry Georgia 13151 57553 659
2311242 2311242 2022-03-16 Henry Georgia 13151 57543 658
2307989 2307989 2022-03-15 Henry Georgia 13151 57531 657
2304738 2304738 2022-03-14 Henry Georgia 13151 57506 655
2301486 2301486 2022-03-13 Henry Georgia 13151 57484 655
2298234 2298234 2022-03-12 Henry Georgia 13151 57484 655
2294982 2294982 2022-03-11 Henry Georgia 13151 57484 655
2291730 2291730 2022-03-10 Henry Georgia 13151 57468 655
2288478 2288478 2022-03-09 Henry Georgia 13151 57455 654
2285227 2285227 2022-03-08 Henry Georgia 13151 57428 652
2281975 2281975 2022-03-07 Henry Georgia 13151 57413 651
2278722 2278722 2022-03-06 Henry Georgia 13151 57387 649
2275469 2275469 2022-03-05 Henry Georgia 13151 57387 649
2272216 2272216 2022-03-04 Henry Georgia 13151 57387 649
2268964 2268964 2022-03-03 Henry Georgia 13151 57367 648
2265711 2265711 2022-03-02 Henry Georgia 13151 57334 647
2262460 2262460 2022-03-01 Henry Georgia 13151 57308 647
2259209 2259209 2022-02-28 Henry Georgia 13151 57250 647
2255958 2255958 2022-02-27 Henry Georgia 13151 57203 643
2252707 2252707 2022-02-26 Henry Georgia 13151 57203 643
2249456 2249456 2022-02-25 Henry Georgia 13151 57203 643
2246205 2246205 2022-02-24 Henry Georgia 13151 57175 642
2242954 2242954 2022-02-23 Henry Georgia 13151 57148 639
2239703 2239703 2022-02-22 Henry Georgia 13151 57110 637
2236452 2236452 2022-02-21 Henry Georgia 13151 57084 636
2233201 2233201 2022-02-20 Henry Georgia 13151 57014 630
2229950 2229950 2022-02-19 Henry Georgia 13151 57014 630
2226699 2226699 2022-02-18 Henry Georgia 13151 57014 630
2223448 2223448 2022-02-17 Henry Georgia 13151 56874 628
2220197 2220197 2022-02-16 Henry Georgia 13151 56822 626
2216946 2216946 2022-02-15 Henry Georgia 13151 56764 623
2213695 2213695 2022-02-14 Henry Georgia 13151 56719 621
2210443 2210443 2022-02-13 Henry Georgia 13151 56622 618
2207190 2207190 2022-02-12 Henry Georgia 13151 56622 618
2203937 2203937 2022-02-11 Henry Georgia 13151 56622 618
2200684 2200684 2022-02-10 Henry Georgia 13151 56553 616
2197430 2197430 2022-02-09 Henry Georgia 13151 56496 613
2194176 2194176 2022-02-08 Henry Georgia 13151 56414 607
2190922 2190922 2022-02-07 Henry Georgia 13151 56353 603
2187669 2187669 2022-02-06 Henry Georgia 13151 56143 594
2184416 2184416 2022-02-05 Henry Georgia 13151 56143 594
2181164 2181164 2022-02-04 Henry Georgia 13151 56143 594
2177913 2177913 2022-02-03 Henry Georgia 13151 56009 590

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