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

788 rows where county = "Richmond" 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 · 788 ✖

fips 1

county 1

  • Richmond · 788 ✖
Link rowid date ▲ county state fips cases deaths
2500086 2500086 2022-05-13 Richmond Georgia 13245 50566 895
2496828 2496828 2022-05-12 Richmond Georgia 13245 50566 895
2493570 2493570 2022-05-11 Richmond Georgia 13245 50566 895
2490312 2490312 2022-05-10 Richmond Georgia 13245 50468 893
2487055 2487055 2022-05-09 Richmond Georgia 13245 50468 893
2483797 2483797 2022-05-08 Richmond Georgia 13245 50468 893
2480539 2480539 2022-05-07 Richmond Georgia 13245 50468 893
2477281 2477281 2022-05-06 Richmond Georgia 13245 50468 893
2474023 2474023 2022-05-05 Richmond Georgia 13245 50468 893
2470766 2470766 2022-05-04 Richmond Georgia 13245 50468 893
2467510 2467510 2022-05-03 Richmond Georgia 13245 50396 891
2464255 2464255 2022-05-02 Richmond Georgia 13245 50396 891
2460999 2460999 2022-05-01 Richmond Georgia 13245 50394 891
2457743 2457743 2022-04-30 Richmond Georgia 13245 50394 891
2454487 2454487 2022-04-29 Richmond Georgia 13245 50394 891
2451231 2451231 2022-04-28 Richmond Georgia 13245 50394 891
2447975 2447975 2022-04-27 Richmond Georgia 13245 50394 891
2444719 2444719 2022-04-26 Richmond Georgia 13245 50147 886
2441463 2441463 2022-04-25 Richmond Georgia 13245 50147 886
2438207 2438207 2022-04-24 Richmond Georgia 13245 50148 886
2434951 2434951 2022-04-23 Richmond Georgia 13245 50148 886
2431695 2431695 2022-04-22 Richmond Georgia 13245 50148 886
2428439 2428439 2022-04-21 Richmond Georgia 13245 50148 886
2425183 2425183 2022-04-20 Richmond Georgia 13245 50148 886
2421927 2421927 2022-04-19 Richmond Georgia 13245 50105 887
2418671 2418671 2022-04-18 Richmond Georgia 13245 50105 887
2415415 2415415 2022-04-17 Richmond Georgia 13245 50105 887
2412159 2412159 2022-04-16 Richmond Georgia 13245 50105 887
2408903 2408903 2022-04-15 Richmond Georgia 13245 50105 887
2405647 2405647 2022-04-14 Richmond Georgia 13245 50097 884
2402392 2402392 2022-04-13 Richmond Georgia 13245 50097 884
2399137 2399137 2022-04-12 Richmond Georgia 13245 50093 884
2395882 2395882 2022-04-11 Richmond Georgia 13245 50081 883
2392626 2392626 2022-04-10 Richmond Georgia 13245 50078 882
2389370 2389370 2022-04-09 Richmond Georgia 13245 50078 882
2386115 2386115 2022-04-08 Richmond Georgia 13245 50078 882
2382860 2382860 2022-04-07 Richmond Georgia 13245 50076 879
2379605 2379605 2022-04-06 Richmond Georgia 13245 50070 878
2376351 2376351 2022-04-05 Richmond Georgia 13245 50064 877
2373099 2373099 2022-04-04 Richmond Georgia 13245 50063 876
2369846 2369846 2022-04-03 Richmond Georgia 13245 50054 874
2366593 2366593 2022-04-02 Richmond Georgia 13245 50054 874
2363340 2363340 2022-04-01 Richmond Georgia 13245 50054 874
2360086 2360086 2022-03-31 Richmond Georgia 13245 50051 873
2356832 2356832 2022-03-30 Richmond Georgia 13245 50024 872
2353579 2353579 2022-03-29 Richmond Georgia 13245 49988 872
2350327 2350327 2022-03-28 Richmond Georgia 13245 49974 871
2347074 2347074 2022-03-27 Richmond Georgia 13245 49969 868
2343821 2343821 2022-03-26 Richmond Georgia 13245 49969 868
2340568 2340568 2022-03-25 Richmond Georgia 13245 49969 868
2337315 2337315 2022-03-24 Richmond Georgia 13245 49961 866
2334061 2334061 2022-03-23 Richmond Georgia 13245 49944 865
2330807 2330807 2022-03-22 Richmond Georgia 13245 49938 864
2327555 2327555 2022-03-21 Richmond Georgia 13245 49934 863
2324302 2324302 2022-03-20 Richmond Georgia 13245 49931 858
2321048 2321048 2022-03-19 Richmond Georgia 13245 49931 858
2317794 2317794 2022-03-18 Richmond Georgia 13245 49931 858
2314541 2314541 2022-03-17 Richmond Georgia 13245 49917 857
2311288 2311288 2022-03-16 Richmond Georgia 13245 49863 855
2308035 2308035 2022-03-15 Richmond Georgia 13245 49848 854
2304784 2304784 2022-03-14 Richmond Georgia 13245 49802 852
2301532 2301532 2022-03-13 Richmond Georgia 13245 49775 849
2298280 2298280 2022-03-12 Richmond Georgia 13245 49775 849
2295028 2295028 2022-03-11 Richmond Georgia 13245 49775 849
2291776 2291776 2022-03-10 Richmond Georgia 13245 49733 848
2288524 2288524 2022-03-09 Richmond Georgia 13245 49697 845
2285273 2285273 2022-03-08 Richmond Georgia 13245 49638 843
2282021 2282021 2022-03-07 Richmond Georgia 13245 49618 840
2278768 2278768 2022-03-06 Richmond Georgia 13245 49576 840
2275515 2275515 2022-03-05 Richmond Georgia 13245 49576 840
2272262 2272262 2022-03-04 Richmond Georgia 13245 49576 840
2269010 2269010 2022-03-03 Richmond Georgia 13245 49541 839
2265757 2265757 2022-03-02 Richmond Georgia 13245 49512 837
2262506 2262506 2022-03-01 Richmond Georgia 13245 49494 837
2259255 2259255 2022-02-28 Richmond Georgia 13245 49440 835
2256004 2256004 2022-02-27 Richmond Georgia 13245 49397 832
2252753 2252753 2022-02-26 Richmond Georgia 13245 49397 832
2249502 2249502 2022-02-25 Richmond Georgia 13245 49397 832
2246251 2246251 2022-02-24 Richmond Georgia 13245 49361 830
2243000 2243000 2022-02-23 Richmond Georgia 13245 49322 826
2239749 2239749 2022-02-22 Richmond Georgia 13245 49302 824
2236498 2236498 2022-02-21 Richmond Georgia 13245 49284 823
2233247 2233247 2022-02-20 Richmond Georgia 13245 49239 819
2229996 2229996 2022-02-19 Richmond Georgia 13245 49239 819
2226745 2226745 2022-02-18 Richmond Georgia 13245 49239 819
2223494 2223494 2022-02-17 Richmond Georgia 13245 49166 816
2220243 2220243 2022-02-16 Richmond Georgia 13245 49113 815
2216992 2216992 2022-02-15 Richmond Georgia 13245 49063 811
2213741 2213741 2022-02-14 Richmond Georgia 13245 49017 809
2210489 2210489 2022-02-13 Richmond Georgia 13245 48901 809
2207236 2207236 2022-02-12 Richmond Georgia 13245 48901 809
2203983 2203983 2022-02-11 Richmond Georgia 13245 48901 809
2200730 2200730 2022-02-10 Richmond Georgia 13245 48828 805
2197476 2197476 2022-02-09 Richmond Georgia 13245 48722 805
2194222 2194222 2022-02-08 Richmond Georgia 13245 48600 803
2190968 2190968 2022-02-07 Richmond Georgia 13245 48515 798
2187715 2187715 2022-02-06 Richmond Georgia 13245 48301 795
2184462 2184462 2022-02-05 Richmond Georgia 13245 48301 795
2181210 2181210 2022-02-04 Richmond Georgia 13245 48301 795
2177959 2177959 2022-02-03 Richmond Georgia 13245 48103 791

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