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

748 rows where fips = 2220 and state = "Alaska" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Alaska · 748 ✖

fips 1

  • 2220 · 748 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499662 2499662 2022-05-13 Sitka City and Borough Alaska 2220 2681 5
2496404 2496404 2022-05-12 Sitka City and Borough Alaska 2220 2681 5
2493146 2493146 2022-05-11 Sitka City and Borough Alaska 2220 2681 5
2489888 2489888 2022-05-10 Sitka City and Borough Alaska 2220 2607 5
2486631 2486631 2022-05-09 Sitka City and Borough Alaska 2220 2607 5
2483373 2483373 2022-05-08 Sitka City and Borough Alaska 2220 2607 5
2480115 2480115 2022-05-07 Sitka City and Borough Alaska 2220 2607 5
2476857 2476857 2022-05-06 Sitka City and Borough Alaska 2220 2607 5
2473599 2473599 2022-05-05 Sitka City and Borough Alaska 2220 2607 5
2470342 2470342 2022-05-04 Sitka City and Borough Alaska 2220 2607 5
2467086 2467086 2022-05-03 Sitka City and Borough Alaska 2220 2539 5
2463831 2463831 2022-05-02 Sitka City and Borough Alaska 2220 2539 5
2460575 2460575 2022-05-01 Sitka City and Borough Alaska 2220 2539 5
2457319 2457319 2022-04-30 Sitka City and Borough Alaska 2220 2539 5
2454063 2454063 2022-04-29 Sitka City and Borough Alaska 2220 2539 5
2450807 2450807 2022-04-28 Sitka City and Borough Alaska 2220 2539 5
2447551 2447551 2022-04-27 Sitka City and Borough Alaska 2220 2539 5
2444295 2444295 2022-04-26 Sitka City and Borough Alaska 2220 2450 5
2441039 2441039 2022-04-25 Sitka City and Borough Alaska 2220 2450 5
2437783 2437783 2022-04-24 Sitka City and Borough Alaska 2220 2450 5
2434527 2434527 2022-04-23 Sitka City and Borough Alaska 2220 2450 5
2431271 2431271 2022-04-22 Sitka City and Borough Alaska 2220 2450 5
2428015 2428015 2022-04-21 Sitka City and Borough Alaska 2220 2450 5
2424759 2424759 2022-04-20 Sitka City and Borough Alaska 2220 2450 5
2421503 2421503 2022-04-19 Sitka City and Borough Alaska 2220 2375 5
2418247 2418247 2022-04-18 Sitka City and Borough Alaska 2220 2375 5
2414991 2414991 2022-04-17 Sitka City and Borough Alaska 2220 2375 5
2411735 2411735 2022-04-16 Sitka City and Borough Alaska 2220 2375 5
2408479 2408479 2022-04-15 Sitka City and Borough Alaska 2220 2375 5
2405223 2405223 2022-04-14 Sitka City and Borough Alaska 2220 2375 5
2401968 2401968 2022-04-13 Sitka City and Borough Alaska 2220 2375 5
2398713 2398713 2022-04-12 Sitka City and Borough Alaska 2220 2327 5
2395458 2395458 2022-04-11 Sitka City and Borough Alaska 2220 2327 5
2392202 2392202 2022-04-10 Sitka City and Borough Alaska 2220 2327 5
2388946 2388946 2022-04-09 Sitka City and Borough Alaska 2220 2327 5
2385691 2385691 2022-04-08 Sitka City and Borough Alaska 2220 2327 5
2382436 2382436 2022-04-07 Sitka City and Borough Alaska 2220 2327 5
2379181 2379181 2022-04-06 Sitka City and Borough Alaska 2220 2327 5
2375927 2375927 2022-04-05 Sitka City and Borough Alaska 2220 2315 5
2372675 2372675 2022-04-04 Sitka City and Borough Alaska 2220 2315 5
2369422 2369422 2022-04-03 Sitka City and Borough Alaska 2220 2315 5
2366169 2366169 2022-04-02 Sitka City and Borough Alaska 2220 2315 5
2362916 2362916 2022-04-01 Sitka City and Borough Alaska 2220 2315 5
2359662 2359662 2022-03-31 Sitka City and Borough Alaska 2220 2313 5
2356408 2356408 2022-03-30 Sitka City and Borough Alaska 2220 2313 5
2353155 2353155 2022-03-29 Sitka City and Borough Alaska 2220 2298 5
2349903 2349903 2022-03-28 Sitka City and Borough Alaska 2220 2298 5
2346650 2346650 2022-03-27 Sitka City and Borough Alaska 2220 2298 5
2343397 2343397 2022-03-26 Sitka City and Borough Alaska 2220 2298 5
2340144 2340144 2022-03-25 Sitka City and Borough Alaska 2220 2298 5
2336891 2336891 2022-03-24 Sitka City and Borough Alaska 2220 2288 5
2333637 2333637 2022-03-23 Sitka City and Borough Alaska 2220 2288 5
2330383 2330383 2022-03-22 Sitka City and Borough Alaska 2220 2278 5
2327131 2327131 2022-03-21 Sitka City and Borough Alaska 2220 2278 5
2323878 2323878 2022-03-20 Sitka City and Borough Alaska 2220 2267 5
2320624 2320624 2022-03-19 Sitka City and Borough Alaska 2220 2267 5
2317370 2317370 2022-03-18 Sitka City and Borough Alaska 2220 2267 5
2314117 2314117 2022-03-17 Sitka City and Borough Alaska 2220 2260 5
2310864 2310864 2022-03-16 Sitka City and Borough Alaska 2220 2260 5
2307611 2307611 2022-03-15 Sitka City and Borough Alaska 2220 2252 5
2304360 2304360 2022-03-14 Sitka City and Borough Alaska 2220 2252 5
2301108 2301108 2022-03-13 Sitka City and Borough Alaska 2220 2242 5
2297856 2297856 2022-03-12 Sitka City and Borough Alaska 2220 2242 5
2294604 2294604 2022-03-11 Sitka City and Borough Alaska 2220 2242 5
2291352 2291352 2022-03-10 Sitka City and Borough Alaska 2220 2231 5
2288100 2288100 2022-03-09 Sitka City and Borough Alaska 2220 2231 5
2284848 2284848 2022-03-08 Sitka City and Borough Alaska 2220 2227 5
2281596 2281596 2022-03-07 Sitka City and Borough Alaska 2220 2227 5
2278343 2278343 2022-03-06 Sitka City and Borough Alaska 2220 2216 5
2275090 2275090 2022-03-05 Sitka City and Borough Alaska 2220 2216 5
2271837 2271837 2022-03-04 Sitka City and Borough Alaska 2220 2216 5
2268585 2268585 2022-03-03 Sitka City and Borough Alaska 2220 2207 5
2265332 2265332 2022-03-02 Sitka City and Borough Alaska 2220 2207 5
2262082 2262082 2022-03-01 Sitka City and Borough Alaska 2220 2188 5
2258831 2258831 2022-02-28 Sitka City and Borough Alaska 2220 2188 5
2255580 2255580 2022-02-27 Sitka City and Borough Alaska 2220 2181 5
2252329 2252329 2022-02-26 Sitka City and Borough Alaska 2220 2181 5
2249078 2249078 2022-02-25 Sitka City and Borough Alaska 2220 2181 5
2245827 2245827 2022-02-24 Sitka City and Borough Alaska 2220 2171 5
2242576 2242576 2022-02-23 Sitka City and Borough Alaska 2220 2171 5
2239325 2239325 2022-02-22 Sitka City and Borough Alaska 2220 2156 5
2236074 2236074 2022-02-21 Sitka City and Borough Alaska 2220 2156 5
2232823 2232823 2022-02-20 Sitka City and Borough Alaska 2220 2156 5
2229572 2229572 2022-02-19 Sitka City and Borough Alaska 2220 2156 5
2226321 2226321 2022-02-18 Sitka City and Borough Alaska 2220 2156 5
2223070 2223070 2022-02-17 Sitka City and Borough Alaska 2220 2143 5
2219819 2219819 2022-02-16 Sitka City and Borough Alaska 2220 2143 5
2216569 2216569 2022-02-15 Sitka City and Borough Alaska 2220 2137 5
2213318 2213318 2022-02-14 Sitka City and Borough Alaska 2220 2137 5
2210065 2210065 2022-02-13 Sitka City and Borough Alaska 2220 2127 5
2206812 2206812 2022-02-12 Sitka City and Borough Alaska 2220 2127 5
2203559 2203559 2022-02-11 Sitka City and Borough Alaska 2220 2127 5
2200305 2200305 2022-02-10 Sitka City and Borough Alaska 2220 2099 5
2197051 2197051 2022-02-09 Sitka City and Borough Alaska 2220 2099 5
2193796 2193796 2022-02-08 Sitka City and Borough Alaska 2220 2074 5
2190543 2190543 2022-02-07 Sitka City and Borough Alaska 2220 2074 5
2187290 2187290 2022-02-06 Sitka City and Borough Alaska 2220 2034 5
2184037 2184037 2022-02-05 Sitka City and Borough Alaska 2220 2034 5
2180785 2180785 2022-02-04 Sitka City and Borough Alaska 2220 2034 5
2177534 2177534 2022-02-03 Sitka City and Borough Alaska 2220 2002 5

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