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

789 rows where fips = 13139 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 · 789 ✖

fips 1

  • 13139 · 789 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500034 2500034 2022-05-13 Hall Georgia 13139 54571 844
2496776 2496776 2022-05-12 Hall Georgia 13139 54571 844
2493518 2493518 2022-05-11 Hall Georgia 13139 54571 844
2490260 2490260 2022-05-10 Hall Georgia 13139 54481 844
2487003 2487003 2022-05-09 Hall Georgia 13139 54481 844
2483745 2483745 2022-05-08 Hall Georgia 13139 54453 844
2480487 2480487 2022-05-07 Hall Georgia 13139 54453 844
2477229 2477229 2022-05-06 Hall Georgia 13139 54453 844
2473971 2473971 2022-05-05 Hall Georgia 13139 54453 844
2470714 2470714 2022-05-04 Hall Georgia 13139 54453 844
2467458 2467458 2022-05-03 Hall Georgia 13139 54363 840
2464203 2464203 2022-05-02 Hall Georgia 13139 54363 840
2460947 2460947 2022-05-01 Hall Georgia 13139 54338 840
2457691 2457691 2022-04-30 Hall Georgia 13139 54338 840
2454435 2454435 2022-04-29 Hall Georgia 13139 54338 840
2451179 2451179 2022-04-28 Hall Georgia 13139 54338 840
2447923 2447923 2022-04-27 Hall Georgia 13139 54338 840
2444667 2444667 2022-04-26 Hall Georgia 13139 54236 839
2441411 2441411 2022-04-25 Hall Georgia 13139 54236 839
2438155 2438155 2022-04-24 Hall Georgia 13139 54215 839
2434899 2434899 2022-04-23 Hall Georgia 13139 54215 839
2431643 2431643 2022-04-22 Hall Georgia 13139 54215 839
2428387 2428387 2022-04-21 Hall Georgia 13139 54215 839
2425131 2425131 2022-04-20 Hall Georgia 13139 54215 839
2421875 2421875 2022-04-19 Hall Georgia 13139 54163 835
2418619 2418619 2022-04-18 Hall Georgia 13139 54163 835
2415363 2415363 2022-04-17 Hall Georgia 13139 54081 835
2412107 2412107 2022-04-16 Hall Georgia 13139 54081 835
2408851 2408851 2022-04-15 Hall Georgia 13139 54081 835
2405595 2405595 2022-04-14 Hall Georgia 13139 54074 836
2402340 2402340 2022-04-13 Hall Georgia 13139 54067 836
2399085 2399085 2022-04-12 Hall Georgia 13139 54053 836
2395830 2395830 2022-04-11 Hall Georgia 13139 54043 836
2392574 2392574 2022-04-10 Hall Georgia 13139 53910 836
2389318 2389318 2022-04-09 Hall Georgia 13139 53910 836
2386063 2386063 2022-04-08 Hall Georgia 13139 53910 836
2382808 2382808 2022-04-07 Hall Georgia 13139 53916 833
2379553 2379553 2022-04-06 Hall Georgia 13139 53899 832
2376299 2376299 2022-04-05 Hall Georgia 13139 53876 831
2373047 2373047 2022-04-04 Hall Georgia 13139 53883 831
2369794 2369794 2022-04-03 Hall Georgia 13139 53757 830
2366541 2366541 2022-04-02 Hall Georgia 13139 53757 830
2363288 2363288 2022-04-01 Hall Georgia 13139 53757 830
2360034 2360034 2022-03-31 Hall Georgia 13139 53740 827
2356780 2356780 2022-03-30 Hall Georgia 13139 53727 824
2353527 2353527 2022-03-29 Hall Georgia 13139 53698 824
2350275 2350275 2022-03-28 Hall Georgia 13139 53695 824
2347022 2347022 2022-03-27 Hall Georgia 13139 53549 823
2343769 2343769 2022-03-26 Hall Georgia 13139 53549 823
2340516 2340516 2022-03-25 Hall Georgia 13139 53549 823
2337263 2337263 2022-03-24 Hall Georgia 13139 53555 819
2334009 2334009 2022-03-23 Hall Georgia 13139 53556 816
2330755 2330755 2022-03-22 Hall Georgia 13139 53557 817
2327503 2327503 2022-03-21 Hall Georgia 13139 53559 816
2324250 2324250 2022-03-20 Hall Georgia 13139 53516 815
2320996 2320996 2022-03-19 Hall Georgia 13139 53516 815
2317742 2317742 2022-03-18 Hall Georgia 13139 53516 815
2314489 2314489 2022-03-17 Hall Georgia 13139 53517 814
2311236 2311236 2022-03-16 Hall Georgia 13139 53518 814
2307983 2307983 2022-03-15 Hall Georgia 13139 53508 812
2304732 2304732 2022-03-14 Hall Georgia 13139 53498 812
2301480 2301480 2022-03-13 Hall Georgia 13139 53431 810
2298228 2298228 2022-03-12 Hall Georgia 13139 53431 810
2294976 2294976 2022-03-11 Hall Georgia 13139 53431 810
2291724 2291724 2022-03-10 Hall Georgia 13139 53436 808
2288472 2288472 2022-03-09 Hall Georgia 13139 53426 804
2285221 2285221 2022-03-08 Hall Georgia 13139 53427 804
2281969 2281969 2022-03-07 Hall Georgia 13139 53426 800
2278716 2278716 2022-03-06 Hall Georgia 13139 53349 800
2275463 2275463 2022-03-05 Hall Georgia 13139 53349 800
2272210 2272210 2022-03-04 Hall Georgia 13139 53349 800
2268958 2268958 2022-03-03 Hall Georgia 13139 53341 799
2265705 2265705 2022-03-02 Hall Georgia 13139 53330 795
2262454 2262454 2022-03-01 Hall Georgia 13139 53333 793
2259203 2259203 2022-02-28 Hall Georgia 13139 53324 789
2255952 2255952 2022-02-27 Hall Georgia 13139 53270 789
2252701 2252701 2022-02-26 Hall Georgia 13139 53270 789
2249450 2249450 2022-02-25 Hall Georgia 13139 53270 789
2246199 2246199 2022-02-24 Hall Georgia 13139 53232 788
2242948 2242948 2022-02-23 Hall Georgia 13139 53201 782
2239697 2239697 2022-02-22 Hall Georgia 13139 53162 780
2236446 2236446 2022-02-21 Hall Georgia 13139 53144 778
2233195 2233195 2022-02-20 Hall Georgia 13139 53074 773
2229944 2229944 2022-02-19 Hall Georgia 13139 53074 773
2226693 2226693 2022-02-18 Hall Georgia 13139 53074 773
2223442 2223442 2022-02-17 Hall Georgia 13139 53024 768
2220191 2220191 2022-02-16 Hall Georgia 13139 52964 763
2216940 2216940 2022-02-15 Hall Georgia 13139 52906 760
2213689 2213689 2022-02-14 Hall Georgia 13139 52864 760
2210437 2210437 2022-02-13 Hall Georgia 13139 52743 756
2207184 2207184 2022-02-12 Hall Georgia 13139 52743 756
2203931 2203931 2022-02-11 Hall Georgia 13139 52743 756
2200678 2200678 2022-02-10 Hall Georgia 13139 52661 752
2197424 2197424 2022-02-09 Hall Georgia 13139 52580 751
2194170 2194170 2022-02-08 Hall Georgia 13139 52480 747
2190916 2190916 2022-02-07 Hall Georgia 13139 52420 747
2187663 2187663 2022-02-06 Hall Georgia 13139 52152 744
2184410 2184410 2022-02-05 Hall Georgia 13139 52152 744
2181158 2181158 2022-02-04 Hall Georgia 13139 52152 744
2177907 2177907 2022-02-03 Hall Georgia 13139 51998 738

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