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

781 rows where county = "Mitchell" and fips = 13205 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 13205 · 781 ✖

county 1

  • Mitchell · 781 ✖
Link rowid date ▲ county state fips cases deaths
2500066 2500066 2022-05-13 Mitchell Georgia 13205 5255 117
2496808 2496808 2022-05-12 Mitchell Georgia 13205 5255 117
2493550 2493550 2022-05-11 Mitchell Georgia 13205 5255 117
2490292 2490292 2022-05-10 Mitchell Georgia 13205 5253 117
2487035 2487035 2022-05-09 Mitchell Georgia 13205 5253 117
2483777 2483777 2022-05-08 Mitchell Georgia 13205 5253 117
2480519 2480519 2022-05-07 Mitchell Georgia 13205 5253 117
2477261 2477261 2022-05-06 Mitchell Georgia 13205 5253 117
2474003 2474003 2022-05-05 Mitchell Georgia 13205 5253 117
2470746 2470746 2022-05-04 Mitchell Georgia 13205 5253 117
2467490 2467490 2022-05-03 Mitchell Georgia 13205 5250 117
2464235 2464235 2022-05-02 Mitchell Georgia 13205 5250 117
2460979 2460979 2022-05-01 Mitchell Georgia 13205 5249 117
2457723 2457723 2022-04-30 Mitchell Georgia 13205 5249 117
2454467 2454467 2022-04-29 Mitchell Georgia 13205 5249 117
2451211 2451211 2022-04-28 Mitchell Georgia 13205 5249 117
2447955 2447955 2022-04-27 Mitchell Georgia 13205 5249 117
2444699 2444699 2022-04-26 Mitchell Georgia 13205 5245 117
2441443 2441443 2022-04-25 Mitchell Georgia 13205 5245 117
2438187 2438187 2022-04-24 Mitchell Georgia 13205 5245 117
2434931 2434931 2022-04-23 Mitchell Georgia 13205 5245 117
2431675 2431675 2022-04-22 Mitchell Georgia 13205 5245 117
2428419 2428419 2022-04-21 Mitchell Georgia 13205 5245 117
2425163 2425163 2022-04-20 Mitchell Georgia 13205 5245 117
2421907 2421907 2022-04-19 Mitchell Georgia 13205 5244 116
2418651 2418651 2022-04-18 Mitchell Georgia 13205 5244 116
2415395 2415395 2022-04-17 Mitchell Georgia 13205 5244 116
2412139 2412139 2022-04-16 Mitchell Georgia 13205 5244 116
2408883 2408883 2022-04-15 Mitchell Georgia 13205 5244 116
2405627 2405627 2022-04-14 Mitchell Georgia 13205 5244 116
2402372 2402372 2022-04-13 Mitchell Georgia 13205 5243 116
2399117 2399117 2022-04-12 Mitchell Georgia 13205 5243 116
2395862 2395862 2022-04-11 Mitchell Georgia 13205 5243 116
2392606 2392606 2022-04-10 Mitchell Georgia 13205 5243 116
2389350 2389350 2022-04-09 Mitchell Georgia 13205 5243 116
2386095 2386095 2022-04-08 Mitchell Georgia 13205 5243 116
2382840 2382840 2022-04-07 Mitchell Georgia 13205 5243 116
2379585 2379585 2022-04-06 Mitchell Georgia 13205 5243 116
2376331 2376331 2022-04-05 Mitchell Georgia 13205 5243 116
2373079 2373079 2022-04-04 Mitchell Georgia 13205 5243 116
2369826 2369826 2022-04-03 Mitchell Georgia 13205 5242 116
2366573 2366573 2022-04-02 Mitchell Georgia 13205 5242 116
2363320 2363320 2022-04-01 Mitchell Georgia 13205 5242 116
2360066 2360066 2022-03-31 Mitchell Georgia 13205 5242 115
2356812 2356812 2022-03-30 Mitchell Georgia 13205 5241 115
2353559 2353559 2022-03-29 Mitchell Georgia 13205 5239 114
2350307 2350307 2022-03-28 Mitchell Georgia 13205 5240 115
2347054 2347054 2022-03-27 Mitchell Georgia 13205 5239 115
2343801 2343801 2022-03-26 Mitchell Georgia 13205 5239 115
2340548 2340548 2022-03-25 Mitchell Georgia 13205 5239 115
2337295 2337295 2022-03-24 Mitchell Georgia 13205 5237 115
2334041 2334041 2022-03-23 Mitchell Georgia 13205 5237 115
2330787 2330787 2022-03-22 Mitchell Georgia 13205 5237 115
2327535 2327535 2022-03-21 Mitchell Georgia 13205 5236 115
2324282 2324282 2022-03-20 Mitchell Georgia 13205 5235 115
2321028 2321028 2022-03-19 Mitchell Georgia 13205 5235 115
2317774 2317774 2022-03-18 Mitchell Georgia 13205 5235 115
2314521 2314521 2022-03-17 Mitchell Georgia 13205 5234 115
2311268 2311268 2022-03-16 Mitchell Georgia 13205 5234 114
2308015 2308015 2022-03-15 Mitchell Georgia 13205 5234 114
2304764 2304764 2022-03-14 Mitchell Georgia 13205 5233 114
2301512 2301512 2022-03-13 Mitchell Georgia 13205 5232 114
2298260 2298260 2022-03-12 Mitchell Georgia 13205 5232 114
2295008 2295008 2022-03-11 Mitchell Georgia 13205 5232 114
2291756 2291756 2022-03-10 Mitchell Georgia 13205 5222 112
2288504 2288504 2022-03-09 Mitchell Georgia 13205 5220 112
2285253 2285253 2022-03-08 Mitchell Georgia 13205 5215 112
2282001 2282001 2022-03-07 Mitchell Georgia 13205 5215 112
2278748 2278748 2022-03-06 Mitchell Georgia 13205 5210 112
2275495 2275495 2022-03-05 Mitchell Georgia 13205 5210 112
2272242 2272242 2022-03-04 Mitchell Georgia 13205 5210 112
2268990 2268990 2022-03-03 Mitchell Georgia 13205 5208 112
2265737 2265737 2022-03-02 Mitchell Georgia 13205 5208 112
2262486 2262486 2022-03-01 Mitchell Georgia 13205 5204 112
2259235 2259235 2022-02-28 Mitchell Georgia 13205 5200 111
2255984 2255984 2022-02-27 Mitchell Georgia 13205 5193 111
2252733 2252733 2022-02-26 Mitchell Georgia 13205 5193 111
2249482 2249482 2022-02-25 Mitchell Georgia 13205 5193 111
2246231 2246231 2022-02-24 Mitchell Georgia 13205 5193 111
2242980 2242980 2022-02-23 Mitchell Georgia 13205 5192 111
2239729 2239729 2022-02-22 Mitchell Georgia 13205 5188 109
2236478 2236478 2022-02-21 Mitchell Georgia 13205 5181 109
2233227 2233227 2022-02-20 Mitchell Georgia 13205 5167 108
2229976 2229976 2022-02-19 Mitchell Georgia 13205 5167 108
2226725 2226725 2022-02-18 Mitchell Georgia 13205 5167 108
2223474 2223474 2022-02-17 Mitchell Georgia 13205 5164 108
2220223 2220223 2022-02-16 Mitchell Georgia 13205 5160 108
2216972 2216972 2022-02-15 Mitchell Georgia 13205 5146 108
2213721 2213721 2022-02-14 Mitchell Georgia 13205 5140 108
2210469 2210469 2022-02-13 Mitchell Georgia 13205 5129 106
2207216 2207216 2022-02-12 Mitchell Georgia 13205 5129 106
2203963 2203963 2022-02-11 Mitchell Georgia 13205 5129 106
2200710 2200710 2022-02-10 Mitchell Georgia 13205 5119 105
2197456 2197456 2022-02-09 Mitchell Georgia 13205 5105 105
2194202 2194202 2022-02-08 Mitchell Georgia 13205 5091 105
2190948 2190948 2022-02-07 Mitchell Georgia 13205 5080 104
2187695 2187695 2022-02-06 Mitchell Georgia 13205 5039 104
2184442 2184442 2022-02-05 Mitchell Georgia 13205 5039 104
2181190 2181190 2022-02-04 Mitchell Georgia 13205 5039 104
2177939 2177939 2022-02-03 Mitchell Georgia 13205 5013 104

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