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

716 rows where fips = 2185 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 · 716 ✖

fips 1

  • 2185 · 716 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499658 2499658 2022-05-13 North Slope Borough Alaska 2185 4468 11
2496400 2496400 2022-05-12 North Slope Borough Alaska 2185 4468 11
2493142 2493142 2022-05-11 North Slope Borough Alaska 2185 4468 11
2489884 2489884 2022-05-10 North Slope Borough Alaska 2185 4464 11
2486627 2486627 2022-05-09 North Slope Borough Alaska 2185 4464 11
2483369 2483369 2022-05-08 North Slope Borough Alaska 2185 4464 11
2480111 2480111 2022-05-07 North Slope Borough Alaska 2185 4464 11
2476853 2476853 2022-05-06 North Slope Borough Alaska 2185 4464 11
2473595 2473595 2022-05-05 North Slope Borough Alaska 2185 4464 11
2470338 2470338 2022-05-04 North Slope Borough Alaska 2185 4464 11
2467082 2467082 2022-05-03 North Slope Borough Alaska 2185 4449 11
2463827 2463827 2022-05-02 North Slope Borough Alaska 2185 4449 11
2460571 2460571 2022-05-01 North Slope Borough Alaska 2185 4449 11
2457315 2457315 2022-04-30 North Slope Borough Alaska 2185 4449 11
2454059 2454059 2022-04-29 North Slope Borough Alaska 2185 4449 11
2450803 2450803 2022-04-28 North Slope Borough Alaska 2185 4449 11
2447547 2447547 2022-04-27 North Slope Borough Alaska 2185 4449 11
2444291 2444291 2022-04-26 North Slope Borough Alaska 2185 4436 11
2441035 2441035 2022-04-25 North Slope Borough Alaska 2185 4436 11
2437779 2437779 2022-04-24 North Slope Borough Alaska 2185 4436 11
2434523 2434523 2022-04-23 North Slope Borough Alaska 2185 4436 11
2431267 2431267 2022-04-22 North Slope Borough Alaska 2185 4436 11
2428011 2428011 2022-04-21 North Slope Borough Alaska 2185 4436 11
2424755 2424755 2022-04-20 North Slope Borough Alaska 2185 4436 11
2421499 2421499 2022-04-19 North Slope Borough Alaska 2185 4423 11
2418243 2418243 2022-04-18 North Slope Borough Alaska 2185 4423 11
2414987 2414987 2022-04-17 North Slope Borough Alaska 2185 4423 11
2411731 2411731 2022-04-16 North Slope Borough Alaska 2185 4423 11
2408475 2408475 2022-04-15 North Slope Borough Alaska 2185 4423 11
2405219 2405219 2022-04-14 North Slope Borough Alaska 2185 4423 11
2401964 2401964 2022-04-13 North Slope Borough Alaska 2185 4423 11
2398709 2398709 2022-04-12 North Slope Borough Alaska 2185 4411 11
2395454 2395454 2022-04-11 North Slope Borough Alaska 2185 4411 11
2392198 2392198 2022-04-10 North Slope Borough Alaska 2185 4411 11
2388942 2388942 2022-04-09 North Slope Borough Alaska 2185 4411 11
2385687 2385687 2022-04-08 North Slope Borough Alaska 2185 4411 11
2382432 2382432 2022-04-07 North Slope Borough Alaska 2185 4411 11
2379177 2379177 2022-04-06 North Slope Borough Alaska 2185 4411 11
2375923 2375923 2022-04-05 North Slope Borough Alaska 2185 4394 11
2372671 2372671 2022-04-04 North Slope Borough Alaska 2185 4394 11
2369418 2369418 2022-04-03 North Slope Borough Alaska 2185 4394 11
2366165 2366165 2022-04-02 North Slope Borough Alaska 2185 4394 11
2362912 2362912 2022-04-01 North Slope Borough Alaska 2185 4394 11
2359658 2359658 2022-03-31 North Slope Borough Alaska 2185 4373 11
2356404 2356404 2022-03-30 North Slope Borough Alaska 2185 4373 11
2353151 2353151 2022-03-29 North Slope Borough Alaska 2185 4355 11
2349899 2349899 2022-03-28 North Slope Borough Alaska 2185 4355 11
2346646 2346646 2022-03-27 North Slope Borough Alaska 2185 4355 11
2343393 2343393 2022-03-26 North Slope Borough Alaska 2185 4355 11
2340140 2340140 2022-03-25 North Slope Borough Alaska 2185 4355 11
2336887 2336887 2022-03-24 North Slope Borough Alaska 2185 4342 11
2333633 2333633 2022-03-23 North Slope Borough Alaska 2185 4342 11
2330379 2330379 2022-03-22 North Slope Borough Alaska 2185 4326 11
2327127 2327127 2022-03-21 North Slope Borough Alaska 2185 4326 11
2323874 2323874 2022-03-20 North Slope Borough Alaska 2185 4318 11
2320620 2320620 2022-03-19 North Slope Borough Alaska 2185 4318 11
2317366 2317366 2022-03-18 North Slope Borough Alaska 2185 4318 11
2314113 2314113 2022-03-17 North Slope Borough Alaska 2185 4316 11
2310860 2310860 2022-03-16 North Slope Borough Alaska 2185 4316 11
2307607 2307607 2022-03-15 North Slope Borough Alaska 2185 4307 11
2304356 2304356 2022-03-14 North Slope Borough Alaska 2185 4307 11
2301104 2301104 2022-03-13 North Slope Borough Alaska 2185 4298 11
2297852 2297852 2022-03-12 North Slope Borough Alaska 2185 4298 11
2294600 2294600 2022-03-11 North Slope Borough Alaska 2185 4298 11
2291348 2291348 2022-03-10 North Slope Borough Alaska 2185 4284 11
2288096 2288096 2022-03-09 North Slope Borough Alaska 2185 4284 11
2284844 2284844 2022-03-08 North Slope Borough Alaska 2185 4282 11
2281592 2281592 2022-03-07 North Slope Borough Alaska 2185 4282 11
2278339 2278339 2022-03-06 North Slope Borough Alaska 2185 4279 11
2275086 2275086 2022-03-05 North Slope Borough Alaska 2185 4279 11
2271833 2271833 2022-03-04 North Slope Borough Alaska 2185 4279 11
2268581 2268581 2022-03-03 North Slope Borough Alaska 2185 4274 11
2265328 2265328 2022-03-02 North Slope Borough Alaska 2185 4274 11
2262078 2262078 2022-03-01 North Slope Borough Alaska 2185 4262 11
2258827 2258827 2022-02-28 North Slope Borough Alaska 2185 4262 11
2255576 2255576 2022-02-27 North Slope Borough Alaska 2185 4260 11
2252325 2252325 2022-02-26 North Slope Borough Alaska 2185 4260 11
2249074 2249074 2022-02-25 North Slope Borough Alaska 2185 4260 11
2245823 2245823 2022-02-24 North Slope Borough Alaska 2185 4230 11
2242572 2242572 2022-02-23 North Slope Borough Alaska 2185 4230 11
2239321 2239321 2022-02-22 North Slope Borough Alaska 2185 4182 10
2236070 2236070 2022-02-21 North Slope Borough Alaska 2185 4182 10
2232819 2232819 2022-02-20 North Slope Borough Alaska 2185 4182 10
2229568 2229568 2022-02-19 North Slope Borough Alaska 2185 4182 10
2226317 2226317 2022-02-18 North Slope Borough Alaska 2185 4182 10
2223066 2223066 2022-02-17 North Slope Borough Alaska 2185 4161 10
2219815 2219815 2022-02-16 North Slope Borough Alaska 2185 4161 10
2216565 2216565 2022-02-15 North Slope Borough Alaska 2185 4120 10
2213314 2213314 2022-02-14 North Slope Borough Alaska 2185 4120 10
2210061 2210061 2022-02-13 North Slope Borough Alaska 2185 4070 10
2206808 2206808 2022-02-12 North Slope Borough Alaska 2185 4070 10
2203555 2203555 2022-02-11 North Slope Borough Alaska 2185 4070 10
2200301 2200301 2022-02-10 North Slope Borough Alaska 2185 4045 10
2197047 2197047 2022-02-09 North Slope Borough Alaska 2185 4045 10
2193792 2193792 2022-02-08 North Slope Borough Alaska 2185 3956 10
2190539 2190539 2022-02-07 North Slope Borough Alaska 2185 3956 10
2187286 2187286 2022-02-06 North Slope Borough Alaska 2185 3859 10
2184033 2184033 2022-02-05 North Slope Borough Alaska 2185 3859 10
2180781 2180781 2022-02-04 North Slope Borough Alaska 2185 3859 10
2177530 2177530 2022-02-03 North Slope Borough Alaska 2185 3783 10

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