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

575 rows where county = "Skagway Municipality" and state = "Alaska" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Alaska · 575 ✖

fips 1

county 1

  • Skagway Municipality · 575 ✖
Link rowid date ▲ county state fips cases deaths
2499663 2499663 2022-05-13 Skagway Municipality Alaska 2230 187 0
2496405 2496405 2022-05-12 Skagway Municipality Alaska 2230 187 0
2493147 2493147 2022-05-11 Skagway Municipality Alaska 2230 187 0
2489889 2489889 2022-05-10 Skagway Municipality Alaska 2230 169 0
2486632 2486632 2022-05-09 Skagway Municipality Alaska 2230 169 0
2483374 2483374 2022-05-08 Skagway Municipality Alaska 2230 169 0
2480116 2480116 2022-05-07 Skagway Municipality Alaska 2230 169 0
2476858 2476858 2022-05-06 Skagway Municipality Alaska 2230 169 0
2473600 2473600 2022-05-05 Skagway Municipality Alaska 2230 169 0
2470343 2470343 2022-05-04 Skagway Municipality Alaska 2230 169 0
2467087 2467087 2022-05-03 Skagway Municipality Alaska 2230 167 0
2463832 2463832 2022-05-02 Skagway Municipality Alaska 2230 167 0
2460576 2460576 2022-05-01 Skagway Municipality Alaska 2230 167 0
2457320 2457320 2022-04-30 Skagway Municipality Alaska 2230 167 0
2454064 2454064 2022-04-29 Skagway Municipality Alaska 2230 167 0
2450808 2450808 2022-04-28 Skagway Municipality Alaska 2230 167 0
2447552 2447552 2022-04-27 Skagway Municipality Alaska 2230 167 0
2444296 2444296 2022-04-26 Skagway Municipality Alaska 2230 155 0
2441040 2441040 2022-04-25 Skagway Municipality Alaska 2230 155 0
2437784 2437784 2022-04-24 Skagway Municipality Alaska 2230 155 0
2434528 2434528 2022-04-23 Skagway Municipality Alaska 2230 155 0
2431272 2431272 2022-04-22 Skagway Municipality Alaska 2230 155 0
2428016 2428016 2022-04-21 Skagway Municipality Alaska 2230 155 0
2424760 2424760 2022-04-20 Skagway Municipality Alaska 2230 155 0
2421504 2421504 2022-04-19 Skagway Municipality Alaska 2230 153 0
2418248 2418248 2022-04-18 Skagway Municipality Alaska 2230 153 0
2414992 2414992 2022-04-17 Skagway Municipality Alaska 2230 153 0
2411736 2411736 2022-04-16 Skagway Municipality Alaska 2230 153 0
2408480 2408480 2022-04-15 Skagway Municipality Alaska 2230 153 0
2405224 2405224 2022-04-14 Skagway Municipality Alaska 2230 153 0
2401969 2401969 2022-04-13 Skagway Municipality Alaska 2230 153 0
2398714 2398714 2022-04-12 Skagway Municipality Alaska 2230 150 0
2395459 2395459 2022-04-11 Skagway Municipality Alaska 2230 150 0
2392203 2392203 2022-04-10 Skagway Municipality Alaska 2230 150 0
2388947 2388947 2022-04-09 Skagway Municipality Alaska 2230 150 0
2385692 2385692 2022-04-08 Skagway Municipality Alaska 2230 150 0
2382437 2382437 2022-04-07 Skagway Municipality Alaska 2230 150 0
2379182 2379182 2022-04-06 Skagway Municipality Alaska 2230 150 0
2375928 2375928 2022-04-05 Skagway Municipality Alaska 2230 146 0
2372676 2372676 2022-04-04 Skagway Municipality Alaska 2230 146 0
2369423 2369423 2022-04-03 Skagway Municipality Alaska 2230 146 0
2366170 2366170 2022-04-02 Skagway Municipality Alaska 2230 146 0
2362917 2362917 2022-04-01 Skagway Municipality Alaska 2230 146 0
2359663 2359663 2022-03-31 Skagway Municipality Alaska 2230 142 0
2356409 2356409 2022-03-30 Skagway Municipality Alaska 2230 142 0
2353156 2353156 2022-03-29 Skagway Municipality Alaska 2230 141 0
2349904 2349904 2022-03-28 Skagway Municipality Alaska 2230 141 0
2346651 2346651 2022-03-27 Skagway Municipality Alaska 2230 141 0
2343398 2343398 2022-03-26 Skagway Municipality Alaska 2230 141 0
2340145 2340145 2022-03-25 Skagway Municipality Alaska 2230 141 0
2336892 2336892 2022-03-24 Skagway Municipality Alaska 2230 140 0
2333638 2333638 2022-03-23 Skagway Municipality Alaska 2230 140 0
2330384 2330384 2022-03-22 Skagway Municipality Alaska 2230 137 0
2327132 2327132 2022-03-21 Skagway Municipality Alaska 2230 137 0
2323879 2323879 2022-03-20 Skagway Municipality Alaska 2230 137 0
2320625 2320625 2022-03-19 Skagway Municipality Alaska 2230 137 0
2317371 2317371 2022-03-18 Skagway Municipality Alaska 2230 137 0
2314118 2314118 2022-03-17 Skagway Municipality Alaska 2230 136 0
2310865 2310865 2022-03-16 Skagway Municipality Alaska 2230 136 0
2307612 2307612 2022-03-15 Skagway Municipality Alaska 2230 135 0
2304361 2304361 2022-03-14 Skagway Municipality Alaska 2230 135 0
2301109 2301109 2022-03-13 Skagway Municipality Alaska 2230 131 0
2297857 2297857 2022-03-12 Skagway Municipality Alaska 2230 131 0
2294605 2294605 2022-03-11 Skagway Municipality Alaska 2230 131 0
2291353 2291353 2022-03-10 Skagway Municipality Alaska 2230 126 0
2288101 2288101 2022-03-09 Skagway Municipality Alaska 2230 126 0
2284849 2284849 2022-03-08 Skagway Municipality Alaska 2230 126 0
2281597 2281597 2022-03-07 Skagway Municipality Alaska 2230 126 0
2278344 2278344 2022-03-06 Skagway Municipality Alaska 2230 126 0
2275091 2275091 2022-03-05 Skagway Municipality Alaska 2230 126 0
2271838 2271838 2022-03-04 Skagway Municipality Alaska 2230 126 0
2268586 2268586 2022-03-03 Skagway Municipality Alaska 2230 126 0
2265333 2265333 2022-03-02 Skagway Municipality Alaska 2230 126 0
2262083 2262083 2022-03-01 Skagway Municipality Alaska 2230 126 0
2258832 2258832 2022-02-28 Skagway Municipality Alaska 2230 126 0
2255581 2255581 2022-02-27 Skagway Municipality Alaska 2230 126 0
2252330 2252330 2022-02-26 Skagway Municipality Alaska 2230 126 0
2249079 2249079 2022-02-25 Skagway Municipality Alaska 2230 126 0
2245828 2245828 2022-02-24 Skagway Municipality Alaska 2230 124 0
2242577 2242577 2022-02-23 Skagway Municipality Alaska 2230 124 0
2239326 2239326 2022-02-22 Skagway Municipality Alaska 2230 122 0
2236075 2236075 2022-02-21 Skagway Municipality Alaska 2230 122 0
2232824 2232824 2022-02-20 Skagway Municipality Alaska 2230 122 0
2229573 2229573 2022-02-19 Skagway Municipality Alaska 2230 122 0
2226322 2226322 2022-02-18 Skagway Municipality Alaska 2230 122 0
2223071 2223071 2022-02-17 Skagway Municipality Alaska 2230 121 0
2219820 2219820 2022-02-16 Skagway Municipality Alaska 2230 121 0
2216570 2216570 2022-02-15 Skagway Municipality Alaska 2230 121 0
2213319 2213319 2022-02-14 Skagway Municipality Alaska 2230 121 0
2210066 2210066 2022-02-13 Skagway Municipality Alaska 2230 119 0
2206813 2206813 2022-02-12 Skagway Municipality Alaska 2230 119 0
2203560 2203560 2022-02-11 Skagway Municipality Alaska 2230 119 0
2200306 2200306 2022-02-10 Skagway Municipality Alaska 2230 117 0
2197052 2197052 2022-02-09 Skagway Municipality Alaska 2230 117 0
2193797 2193797 2022-02-08 Skagway Municipality Alaska 2230 112 0
2190544 2190544 2022-02-07 Skagway Municipality Alaska 2230 112 0
2187291 2187291 2022-02-06 Skagway Municipality Alaska 2230 110 0
2184038 2184038 2022-02-05 Skagway Municipality Alaska 2230 110 0
2180786 2180786 2022-02-04 Skagway Municipality Alaska 2230 110 0
2177535 2177535 2022-02-03 Skagway Municipality Alaska 2230 110 0

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