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

688 rows where fips = 2068 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 2068 · 688 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499647 2499647 2022-05-13 Denali Borough Alaska 2068 424 1
2496389 2496389 2022-05-12 Denali Borough Alaska 2068 424 1
2493131 2493131 2022-05-11 Denali Borough Alaska 2068 424 1
2489873 2489873 2022-05-10 Denali Borough Alaska 2068 415 1
2486616 2486616 2022-05-09 Denali Borough Alaska 2068 415 1
2483358 2483358 2022-05-08 Denali Borough Alaska 2068 415 1
2480100 2480100 2022-05-07 Denali Borough Alaska 2068 415 1
2476842 2476842 2022-05-06 Denali Borough Alaska 2068 415 1
2473584 2473584 2022-05-05 Denali Borough Alaska 2068 415 1
2470327 2470327 2022-05-04 Denali Borough Alaska 2068 415 1
2467071 2467071 2022-05-03 Denali Borough Alaska 2068 405 1
2463816 2463816 2022-05-02 Denali Borough Alaska 2068 405 1
2460560 2460560 2022-05-01 Denali Borough Alaska 2068 405 1
2457304 2457304 2022-04-30 Denali Borough Alaska 2068 405 1
2454048 2454048 2022-04-29 Denali Borough Alaska 2068 405 1
2450792 2450792 2022-04-28 Denali Borough Alaska 2068 405 1
2447536 2447536 2022-04-27 Denali Borough Alaska 2068 405 1
2444280 2444280 2022-04-26 Denali Borough Alaska 2068 403 1
2441024 2441024 2022-04-25 Denali Borough Alaska 2068 403 1
2437768 2437768 2022-04-24 Denali Borough Alaska 2068 403 1
2434512 2434512 2022-04-23 Denali Borough Alaska 2068 403 1
2431256 2431256 2022-04-22 Denali Borough Alaska 2068 403 1
2428000 2428000 2022-04-21 Denali Borough Alaska 2068 403 1
2424744 2424744 2022-04-20 Denali Borough Alaska 2068 403 1
2421488 2421488 2022-04-19 Denali Borough Alaska 2068 400 1
2418232 2418232 2022-04-18 Denali Borough Alaska 2068 400 1
2414976 2414976 2022-04-17 Denali Borough Alaska 2068 400 1
2411720 2411720 2022-04-16 Denali Borough Alaska 2068 400 1
2408464 2408464 2022-04-15 Denali Borough Alaska 2068 400 1
2405208 2405208 2022-04-14 Denali Borough Alaska 2068 400 1
2401953 2401953 2022-04-13 Denali Borough Alaska 2068 400 1
2398698 2398698 2022-04-12 Denali Borough Alaska 2068 400 1
2395443 2395443 2022-04-11 Denali Borough Alaska 2068 400 1
2392187 2392187 2022-04-10 Denali Borough Alaska 2068 400 1
2388931 2388931 2022-04-09 Denali Borough Alaska 2068 400 1
2385676 2385676 2022-04-08 Denali Borough Alaska 2068 400 1
2382421 2382421 2022-04-07 Denali Borough Alaska 2068 400 1
2379166 2379166 2022-04-06 Denali Borough Alaska 2068 400 1
2375912 2375912 2022-04-05 Denali Borough Alaska 2068 399 1
2372660 2372660 2022-04-04 Denali Borough Alaska 2068 399 1
2369407 2369407 2022-04-03 Denali Borough Alaska 2068 399 1
2366154 2366154 2022-04-02 Denali Borough Alaska 2068 399 1
2362901 2362901 2022-04-01 Denali Borough Alaska 2068 399 1
2359647 2359647 2022-03-31 Denali Borough Alaska 2068 399 1
2356393 2356393 2022-03-30 Denali Borough Alaska 2068 399 1
2353140 2353140 2022-03-29 Denali Borough Alaska 2068 396 1
2349888 2349888 2022-03-28 Denali Borough Alaska 2068 396 1
2346635 2346635 2022-03-27 Denali Borough Alaska 2068 396 1
2343382 2343382 2022-03-26 Denali Borough Alaska 2068 396 1
2340129 2340129 2022-03-25 Denali Borough Alaska 2068 396 1
2336876 2336876 2022-03-24 Denali Borough Alaska 2068 395 1
2333622 2333622 2022-03-23 Denali Borough Alaska 2068 395 1
2330368 2330368 2022-03-22 Denali Borough Alaska 2068 395 1
2327116 2327116 2022-03-21 Denali Borough Alaska 2068 395 1
2323863 2323863 2022-03-20 Denali Borough Alaska 2068 395 1
2320609 2320609 2022-03-19 Denali Borough Alaska 2068 395 1
2317355 2317355 2022-03-18 Denali Borough Alaska 2068 395 1
2314102 2314102 2022-03-17 Denali Borough Alaska 2068 393 1
2310849 2310849 2022-03-16 Denali Borough Alaska 2068 393 1
2307596 2307596 2022-03-15 Denali Borough Alaska 2068 388 1
2304345 2304345 2022-03-14 Denali Borough Alaska 2068 388 1
2301093 2301093 2022-03-13 Denali Borough Alaska 2068 388 1
2297841 2297841 2022-03-12 Denali Borough Alaska 2068 388 1
2294589 2294589 2022-03-11 Denali Borough Alaska 2068 388 1
2291337 2291337 2022-03-10 Denali Borough Alaska 2068 385 1
2288085 2288085 2022-03-09 Denali Borough Alaska 2068 385 1
2284833 2284833 2022-03-08 Denali Borough Alaska 2068 381 1
2281581 2281581 2022-03-07 Denali Borough Alaska 2068 381 1
2278328 2278328 2022-03-06 Denali Borough Alaska 2068 380 1
2275075 2275075 2022-03-05 Denali Borough Alaska 2068 380 1
2271822 2271822 2022-03-04 Denali Borough Alaska 2068 380 1
2268570 2268570 2022-03-03 Denali Borough Alaska 2068 379 1
2265317 2265317 2022-03-02 Denali Borough Alaska 2068 379 1
2262067 2262067 2022-03-01 Denali Borough Alaska 2068 377 1
2258816 2258816 2022-02-28 Denali Borough Alaska 2068 377 1
2255565 2255565 2022-02-27 Denali Borough Alaska 2068 377 1
2252314 2252314 2022-02-26 Denali Borough Alaska 2068 377 1
2249063 2249063 2022-02-25 Denali Borough Alaska 2068 377 1
2245812 2245812 2022-02-24 Denali Borough Alaska 2068 375 1
2242561 2242561 2022-02-23 Denali Borough Alaska 2068 375 1
2239310 2239310 2022-02-22 Denali Borough Alaska 2068 375 1
2236059 2236059 2022-02-21 Denali Borough Alaska 2068 375 1
2232808 2232808 2022-02-20 Denali Borough Alaska 2068 375 1
2229557 2229557 2022-02-19 Denali Borough Alaska 2068 375 1
2226306 2226306 2022-02-18 Denali Borough Alaska 2068 375 1
2223055 2223055 2022-02-17 Denali Borough Alaska 2068 375 1
2219804 2219804 2022-02-16 Denali Borough Alaska 2068 375 1
2216554 2216554 2022-02-15 Denali Borough Alaska 2068 373 1
2213303 2213303 2022-02-14 Denali Borough Alaska 2068 373 1
2210050 2210050 2022-02-13 Denali Borough Alaska 2068 370 1
2206797 2206797 2022-02-12 Denali Borough Alaska 2068 370 1
2203544 2203544 2022-02-11 Denali Borough Alaska 2068 370 1
2200290 2200290 2022-02-10 Denali Borough Alaska 2068 365 1
2197036 2197036 2022-02-09 Denali Borough Alaska 2068 365 1
2193781 2193781 2022-02-08 Denali Borough Alaska 2068 363 1
2190528 2190528 2022-02-07 Denali Borough Alaska 2068 363 1
2187275 2187275 2022-02-06 Denali Borough Alaska 2068 357 1
2184022 2184022 2022-02-05 Denali Borough Alaska 2068 357 1
2180770 2180770 2022-02-04 Denali Borough Alaska 2068 357 1
2177519 2177519 2022-02-03 Denali Borough Alaska 2068 353 1

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