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

772 rows where county = "Yukon-Koyukuk Census Area", fips = 2290 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 · 772 ✖

fips 1

  • 2290 · 772 ✖

county 1

  • Yukon-Koyukuk Census Area · 772 ✖
Link rowid date ▲ county state fips cases deaths
2499669 2499669 2022-05-13 Yukon-Koyukuk Census Area Alaska 2290 1438 10
2496411 2496411 2022-05-12 Yukon-Koyukuk Census Area Alaska 2290 1438 10
2493153 2493153 2022-05-11 Yukon-Koyukuk Census Area Alaska 2290 1438 10
2489895 2489895 2022-05-10 Yukon-Koyukuk Census Area Alaska 2290 1435 10
2486638 2486638 2022-05-09 Yukon-Koyukuk Census Area Alaska 2290 1435 10
2483380 2483380 2022-05-08 Yukon-Koyukuk Census Area Alaska 2290 1435 10
2480122 2480122 2022-05-07 Yukon-Koyukuk Census Area Alaska 2290 1435 10
2476864 2476864 2022-05-06 Yukon-Koyukuk Census Area Alaska 2290 1435 10
2473606 2473606 2022-05-05 Yukon-Koyukuk Census Area Alaska 2290 1435 10
2470349 2470349 2022-05-04 Yukon-Koyukuk Census Area Alaska 2290 1435 10
2467093 2467093 2022-05-03 Yukon-Koyukuk Census Area Alaska 2290 1423 10
2463838 2463838 2022-05-02 Yukon-Koyukuk Census Area Alaska 2290 1423 10
2460582 2460582 2022-05-01 Yukon-Koyukuk Census Area Alaska 2290 1423 10
2457326 2457326 2022-04-30 Yukon-Koyukuk Census Area Alaska 2290 1423 10
2454070 2454070 2022-04-29 Yukon-Koyukuk Census Area Alaska 2290 1423 10
2450814 2450814 2022-04-28 Yukon-Koyukuk Census Area Alaska 2290 1423 10
2447558 2447558 2022-04-27 Yukon-Koyukuk Census Area Alaska 2290 1423 10
2444302 2444302 2022-04-26 Yukon-Koyukuk Census Area Alaska 2290 1420 10
2441046 2441046 2022-04-25 Yukon-Koyukuk Census Area Alaska 2290 1420 10
2437790 2437790 2022-04-24 Yukon-Koyukuk Census Area Alaska 2290 1420 10
2434534 2434534 2022-04-23 Yukon-Koyukuk Census Area Alaska 2290 1420 10
2431278 2431278 2022-04-22 Yukon-Koyukuk Census Area Alaska 2290 1420 10
2428022 2428022 2022-04-21 Yukon-Koyukuk Census Area Alaska 2290 1420 10
2424766 2424766 2022-04-20 Yukon-Koyukuk Census Area Alaska 2290 1420 10
2421510 2421510 2022-04-19 Yukon-Koyukuk Census Area Alaska 2290 1417 10
2418254 2418254 2022-04-18 Yukon-Koyukuk Census Area Alaska 2290 1417 10
2414998 2414998 2022-04-17 Yukon-Koyukuk Census Area Alaska 2290 1417 10
2411742 2411742 2022-04-16 Yukon-Koyukuk Census Area Alaska 2290 1417 10
2408486 2408486 2022-04-15 Yukon-Koyukuk Census Area Alaska 2290 1417 10
2405230 2405230 2022-04-14 Yukon-Koyukuk Census Area Alaska 2290 1417 10
2401975 2401975 2022-04-13 Yukon-Koyukuk Census Area Alaska 2290 1417 10
2398720 2398720 2022-04-12 Yukon-Koyukuk Census Area Alaska 2290 1413 10
2395465 2395465 2022-04-11 Yukon-Koyukuk Census Area Alaska 2290 1413 10
2392209 2392209 2022-04-10 Yukon-Koyukuk Census Area Alaska 2290 1413 10
2388953 2388953 2022-04-09 Yukon-Koyukuk Census Area Alaska 2290 1413 10
2385698 2385698 2022-04-08 Yukon-Koyukuk Census Area Alaska 2290 1413 10
2382443 2382443 2022-04-07 Yukon-Koyukuk Census Area Alaska 2290 1413 10
2379188 2379188 2022-04-06 Yukon-Koyukuk Census Area Alaska 2290 1413 10
2375934 2375934 2022-04-05 Yukon-Koyukuk Census Area Alaska 2290 1410 10
2372682 2372682 2022-04-04 Yukon-Koyukuk Census Area Alaska 2290 1410 10
2369429 2369429 2022-04-03 Yukon-Koyukuk Census Area Alaska 2290 1410 10
2366176 2366176 2022-04-02 Yukon-Koyukuk Census Area Alaska 2290 1410 10
2362923 2362923 2022-04-01 Yukon-Koyukuk Census Area Alaska 2290 1410 10
2359669 2359669 2022-03-31 Yukon-Koyukuk Census Area Alaska 2290 1409 10
2356415 2356415 2022-03-30 Yukon-Koyukuk Census Area Alaska 2290 1409 10
2353162 2353162 2022-03-29 Yukon-Koyukuk Census Area Alaska 2290 1409 10
2349910 2349910 2022-03-28 Yukon-Koyukuk Census Area Alaska 2290 1409 10
2346657 2346657 2022-03-27 Yukon-Koyukuk Census Area Alaska 2290 1409 10
2343404 2343404 2022-03-26 Yukon-Koyukuk Census Area Alaska 2290 1409 10
2340151 2340151 2022-03-25 Yukon-Koyukuk Census Area Alaska 2290 1409 10
2336898 2336898 2022-03-24 Yukon-Koyukuk Census Area Alaska 2290 1403 10
2333644 2333644 2022-03-23 Yukon-Koyukuk Census Area Alaska 2290 1403 10
2330390 2330390 2022-03-22 Yukon-Koyukuk Census Area Alaska 2290 1403 9
2327138 2327138 2022-03-21 Yukon-Koyukuk Census Area Alaska 2290 1403 9
2323885 2323885 2022-03-20 Yukon-Koyukuk Census Area Alaska 2290 1401 9
2320631 2320631 2022-03-19 Yukon-Koyukuk Census Area Alaska 2290 1401 9
2317377 2317377 2022-03-18 Yukon-Koyukuk Census Area Alaska 2290 1401 9
2314124 2314124 2022-03-17 Yukon-Koyukuk Census Area Alaska 2290 1393 9
2310871 2310871 2022-03-16 Yukon-Koyukuk Census Area Alaska 2290 1393 9
2307618 2307618 2022-03-15 Yukon-Koyukuk Census Area Alaska 2290 1390 9
2304367 2304367 2022-03-14 Yukon-Koyukuk Census Area Alaska 2290 1390 9
2301115 2301115 2022-03-13 Yukon-Koyukuk Census Area Alaska 2290 1386 9
2297863 2297863 2022-03-12 Yukon-Koyukuk Census Area Alaska 2290 1386 9
2294611 2294611 2022-03-11 Yukon-Koyukuk Census Area Alaska 2290 1386 9
2291359 2291359 2022-03-10 Yukon-Koyukuk Census Area Alaska 2290 1375 9
2288107 2288107 2022-03-09 Yukon-Koyukuk Census Area Alaska 2290 1375 9
2284855 2284855 2022-03-08 Yukon-Koyukuk Census Area Alaska 2290 1329 9
2281603 2281603 2022-03-07 Yukon-Koyukuk Census Area Alaska 2290 1329 9
2278350 2278350 2022-03-06 Yukon-Koyukuk Census Area Alaska 2290 1328 9
2275097 2275097 2022-03-05 Yukon-Koyukuk Census Area Alaska 2290 1328 9
2271844 2271844 2022-03-04 Yukon-Koyukuk Census Area Alaska 2290 1328 9
2268592 2268592 2022-03-03 Yukon-Koyukuk Census Area Alaska 2290 1326 9
2265339 2265339 2022-03-02 Yukon-Koyukuk Census Area Alaska 2290 1326 9
2262089 2262089 2022-03-01 Yukon-Koyukuk Census Area Alaska 2290 1321 9
2258838 2258838 2022-02-28 Yukon-Koyukuk Census Area Alaska 2290 1321 9
2255587 2255587 2022-02-27 Yukon-Koyukuk Census Area Alaska 2290 1315 9
2252336 2252336 2022-02-26 Yukon-Koyukuk Census Area Alaska 2290 1315 9
2249085 2249085 2022-02-25 Yukon-Koyukuk Census Area Alaska 2290 1315 9
2245834 2245834 2022-02-24 Yukon-Koyukuk Census Area Alaska 2290 1313 9
2242583 2242583 2022-02-23 Yukon-Koyukuk Census Area Alaska 2290 1313 9
2239332 2239332 2022-02-22 Yukon-Koyukuk Census Area Alaska 2290 1280 8
2236081 2236081 2022-02-21 Yukon-Koyukuk Census Area Alaska 2290 1280 8
2232830 2232830 2022-02-20 Yukon-Koyukuk Census Area Alaska 2290 1280 8
2229579 2229579 2022-02-19 Yukon-Koyukuk Census Area Alaska 2290 1280 8
2226328 2226328 2022-02-18 Yukon-Koyukuk Census Area Alaska 2290 1280 8
2223077 2223077 2022-02-17 Yukon-Koyukuk Census Area Alaska 2290 1278 8
2219826 2219826 2022-02-16 Yukon-Koyukuk Census Area Alaska 2290 1278 8
2216575 2216575 2022-02-15 Yukon-Koyukuk Census Area Alaska 2290 1273 8
2213324 2213324 2022-02-14 Yukon-Koyukuk Census Area Alaska 2290 1273 8
2210072 2210072 2022-02-13 Yukon-Koyukuk Census Area Alaska 2290 1259 8
2206819 2206819 2022-02-12 Yukon-Koyukuk Census Area Alaska 2290 1259 8
2203566 2203566 2022-02-11 Yukon-Koyukuk Census Area Alaska 2290 1259 8
2200312 2200312 2022-02-10 Yukon-Koyukuk Census Area Alaska 2290 1257 8
2197058 2197058 2022-02-09 Yukon-Koyukuk Census Area Alaska 2290 1257 8
2193803 2193803 2022-02-08 Yukon-Koyukuk Census Area Alaska 2290 1243 8
2190550 2190550 2022-02-07 Yukon-Koyukuk Census Area Alaska 2290 1243 8
2187297 2187297 2022-02-06 Yukon-Koyukuk Census Area Alaska 2290 1197 8
2184044 2184044 2022-02-05 Yukon-Koyukuk Census Area Alaska 2290 1197 8
2180792 2180792 2022-02-04 Yukon-Koyukuk Census Area Alaska 2290 1197 8
2177541 2177541 2022-02-03 Yukon-Koyukuk Census Area Alaska 2290 1149 8

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