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

782 rows where county = "Pierce" 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 · 782 ✖

fips 1

county 1

  • Pierce · 782 ✖
Link rowid date ▲ county state fips cases deaths
2500078 2500078 2022-05-13 Pierce Georgia 13229 5694 130
2496820 2496820 2022-05-12 Pierce Georgia 13229 5694 130
2493562 2493562 2022-05-11 Pierce Georgia 13229 5694 130
2490304 2490304 2022-05-10 Pierce Georgia 13229 5686 130
2487047 2487047 2022-05-09 Pierce Georgia 13229 5686 130
2483789 2483789 2022-05-08 Pierce Georgia 13229 5686 130
2480531 2480531 2022-05-07 Pierce Georgia 13229 5686 130
2477273 2477273 2022-05-06 Pierce Georgia 13229 5686 130
2474015 2474015 2022-05-05 Pierce Georgia 13229 5686 130
2470758 2470758 2022-05-04 Pierce Georgia 13229 5686 130
2467502 2467502 2022-05-03 Pierce Georgia 13229 5678 129
2464247 2464247 2022-05-02 Pierce Georgia 13229 5678 129
2460991 2460991 2022-05-01 Pierce Georgia 13229 5678 129
2457735 2457735 2022-04-30 Pierce Georgia 13229 5678 129
2454479 2454479 2022-04-29 Pierce Georgia 13229 5678 129
2451223 2451223 2022-04-28 Pierce Georgia 13229 5678 129
2447967 2447967 2022-04-27 Pierce Georgia 13229 5678 129
2444711 2444711 2022-04-26 Pierce Georgia 13229 5746 131
2441455 2441455 2022-04-25 Pierce Georgia 13229 5746 131
2438199 2438199 2022-04-24 Pierce Georgia 13229 5746 131
2434943 2434943 2022-04-23 Pierce Georgia 13229 5746 131
2431687 2431687 2022-04-22 Pierce Georgia 13229 5746 131
2428431 2428431 2022-04-21 Pierce Georgia 13229 5746 131
2425175 2425175 2022-04-20 Pierce Georgia 13229 5746 131
2421919 2421919 2022-04-19 Pierce Georgia 13229 5820 131
2418663 2418663 2022-04-18 Pierce Georgia 13229 5820 131
2415407 2415407 2022-04-17 Pierce Georgia 13229 5820 131
2412151 2412151 2022-04-16 Pierce Georgia 13229 5820 131
2408895 2408895 2022-04-15 Pierce Georgia 13229 5820 131
2405639 2405639 2022-04-14 Pierce Georgia 13229 5820 133
2402384 2402384 2022-04-13 Pierce Georgia 13229 5821 133
2399129 2399129 2022-04-12 Pierce Georgia 13229 5816 133
2395874 2395874 2022-04-11 Pierce Georgia 13229 5816 133
2392618 2392618 2022-04-10 Pierce Georgia 13229 5796 133
2389362 2389362 2022-04-09 Pierce Georgia 13229 5796 133
2386107 2386107 2022-04-08 Pierce Georgia 13229 5796 133
2382852 2382852 2022-04-07 Pierce Georgia 13229 5785 132
2379597 2379597 2022-04-06 Pierce Georgia 13229 5785 132
2376343 2376343 2022-04-05 Pierce Georgia 13229 5785 132
2373091 2373091 2022-04-04 Pierce Georgia 13229 5785 132
2369838 2369838 2022-04-03 Pierce Georgia 13229 5783 131
2366585 2366585 2022-04-02 Pierce Georgia 13229 5783 131
2363332 2363332 2022-04-01 Pierce Georgia 13229 5783 131
2360078 2360078 2022-03-31 Pierce Georgia 13229 5782 130
2356824 2356824 2022-03-30 Pierce Georgia 13229 5778 130
2353571 2353571 2022-03-29 Pierce Georgia 13229 5777 130
2350319 2350319 2022-03-28 Pierce Georgia 13229 5776 130
2347066 2347066 2022-03-27 Pierce Georgia 13229 5775 130
2343813 2343813 2022-03-26 Pierce Georgia 13229 5775 130
2340560 2340560 2022-03-25 Pierce Georgia 13229 5775 130
2337307 2337307 2022-03-24 Pierce Georgia 13229 5765 130
2334053 2334053 2022-03-23 Pierce Georgia 13229 5764 129
2330799 2330799 2022-03-22 Pierce Georgia 13229 5761 129
2327547 2327547 2022-03-21 Pierce Georgia 13229 5760 129
2324294 2324294 2022-03-20 Pierce Georgia 13229 5720 125
2321040 2321040 2022-03-19 Pierce Georgia 13229 5720 125
2317786 2317786 2022-03-18 Pierce Georgia 13229 5720 125
2314533 2314533 2022-03-17 Pierce Georgia 13229 5718 125
2311280 2311280 2022-03-16 Pierce Georgia 13229 5715 125
2308027 2308027 2022-03-15 Pierce Georgia 13229 5714 125
2304776 2304776 2022-03-14 Pierce Georgia 13229 5710 125
2301524 2301524 2022-03-13 Pierce Georgia 13229 5703 125
2298272 2298272 2022-03-12 Pierce Georgia 13229 5703 125
2295020 2295020 2022-03-11 Pierce Georgia 13229 5703 125
2291768 2291768 2022-03-10 Pierce Georgia 13229 5683 125
2288516 2288516 2022-03-09 Pierce Georgia 13229 5657 125
2285265 2285265 2022-03-08 Pierce Georgia 13229 5654 124
2282013 2282013 2022-03-07 Pierce Georgia 13229 5626 124
2278760 2278760 2022-03-06 Pierce Georgia 13229 5606 124
2275507 2275507 2022-03-05 Pierce Georgia 13229 5606 124
2272254 2272254 2022-03-04 Pierce Georgia 13229 5606 124
2269002 2269002 2022-03-03 Pierce Georgia 13229 5594 124
2265749 2265749 2022-03-02 Pierce Georgia 13229 5577 124
2262498 2262498 2022-03-01 Pierce Georgia 13229 5574 123
2259247 2259247 2022-02-28 Pierce Georgia 13229 5563 122
2255996 2255996 2022-02-27 Pierce Georgia 13229 5555 122
2252745 2252745 2022-02-26 Pierce Georgia 13229 5555 122
2249494 2249494 2022-02-25 Pierce Georgia 13229 5555 122
2246243 2246243 2022-02-24 Pierce Georgia 13229 5546 121
2242992 2242992 2022-02-23 Pierce Georgia 13229 5531 121
2239741 2239741 2022-02-22 Pierce Georgia 13229 5514 121
2236490 2236490 2022-02-21 Pierce Georgia 13229 5501 121
2233239 2233239 2022-02-20 Pierce Georgia 13229 5488 119
2229988 2229988 2022-02-19 Pierce Georgia 13229 5488 119
2226737 2226737 2022-02-18 Pierce Georgia 13229 5488 119
2223486 2223486 2022-02-17 Pierce Georgia 13229 5466 118
2220235 2220235 2022-02-16 Pierce Georgia 13229 5449 118
2216984 2216984 2022-02-15 Pierce Georgia 13229 5431 117
2213733 2213733 2022-02-14 Pierce Georgia 13229 5420 117
2210481 2210481 2022-02-13 Pierce Georgia 13229 5403 116
2207228 2207228 2022-02-12 Pierce Georgia 13229 5403 116
2203975 2203975 2022-02-11 Pierce Georgia 13229 5403 116
2200722 2200722 2022-02-10 Pierce Georgia 13229 5388 114
2197468 2197468 2022-02-09 Pierce Georgia 13229 5375 113
2194214 2194214 2022-02-08 Pierce Georgia 13229 5347 113
2190960 2190960 2022-02-07 Pierce Georgia 13229 5336 111
2187707 2187707 2022-02-06 Pierce Georgia 13229 5317 110
2184454 2184454 2022-02-05 Pierce Georgia 13229 5317 110
2181202 2181202 2022-02-04 Pierce Georgia 13229 5317 110
2177951 2177951 2022-02-03 Pierce Georgia 13229 5291 109

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