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

782 rows where fips = 2110 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

  • 2110 · 782 ✖
Link rowid date ▲ county state fips cases deaths
2499651 2499651 2022-05-13 Juneau City and Borough Alaska 2110 8798 19
2496393 2496393 2022-05-12 Juneau City and Borough Alaska 2110 8798 19
2493135 2493135 2022-05-11 Juneau City and Borough Alaska 2110 8798 19
2489877 2489877 2022-05-10 Juneau City and Borough Alaska 2110 8622 19
2486620 2486620 2022-05-09 Juneau City and Borough Alaska 2110 8622 19
2483362 2483362 2022-05-08 Juneau City and Borough Alaska 2110 8622 19
2480104 2480104 2022-05-07 Juneau City and Borough Alaska 2110 8622 19
2476846 2476846 2022-05-06 Juneau City and Borough Alaska 2110 8622 19
2473588 2473588 2022-05-05 Juneau City and Borough Alaska 2110 8622 19
2470331 2470331 2022-05-04 Juneau City and Borough Alaska 2110 8622 19
2467075 2467075 2022-05-03 Juneau City and Borough Alaska 2110 8503 19
2463820 2463820 2022-05-02 Juneau City and Borough Alaska 2110 8503 19
2460564 2460564 2022-05-01 Juneau City and Borough Alaska 2110 8503 19
2457308 2457308 2022-04-30 Juneau City and Borough Alaska 2110 8503 19
2454052 2454052 2022-04-29 Juneau City and Borough Alaska 2110 8503 19
2450796 2450796 2022-04-28 Juneau City and Borough Alaska 2110 8503 19
2447540 2447540 2022-04-27 Juneau City and Borough Alaska 2110 8503 19
2444284 2444284 2022-04-26 Juneau City and Borough Alaska 2110 8410 19
2441028 2441028 2022-04-25 Juneau City and Borough Alaska 2110 8410 19
2437772 2437772 2022-04-24 Juneau City and Borough Alaska 2110 8410 19
2434516 2434516 2022-04-23 Juneau City and Borough Alaska 2110 8410 19
2431260 2431260 2022-04-22 Juneau City and Borough Alaska 2110 8410 19
2428004 2428004 2022-04-21 Juneau City and Borough Alaska 2110 8410 19
2424748 2424748 2022-04-20 Juneau City and Borough Alaska 2110 8410 19
2421492 2421492 2022-04-19 Juneau City and Borough Alaska 2110 8319 19
2418236 2418236 2022-04-18 Juneau City and Borough Alaska 2110 8319 19
2414980 2414980 2022-04-17 Juneau City and Borough Alaska 2110 8319 19
2411724 2411724 2022-04-16 Juneau City and Borough Alaska 2110 8319 19
2408468 2408468 2022-04-15 Juneau City and Borough Alaska 2110 8319 19
2405212 2405212 2022-04-14 Juneau City and Borough Alaska 2110 8319 19
2401957 2401957 2022-04-13 Juneau City and Borough Alaska 2110 8319 19
2398702 2398702 2022-04-12 Juneau City and Borough Alaska 2110 8258 19
2395447 2395447 2022-04-11 Juneau City and Borough Alaska 2110 8258 19
2392191 2392191 2022-04-10 Juneau City and Borough Alaska 2110 8258 19
2388935 2388935 2022-04-09 Juneau City and Borough Alaska 2110 8258 19
2385680 2385680 2022-04-08 Juneau City and Borough Alaska 2110 8258 19
2382425 2382425 2022-04-07 Juneau City and Borough Alaska 2110 8258 19
2379170 2379170 2022-04-06 Juneau City and Borough Alaska 2110 8258 19
2375916 2375916 2022-04-05 Juneau City and Borough Alaska 2110 8213 19
2372664 2372664 2022-04-04 Juneau City and Borough Alaska 2110 8213 19
2369411 2369411 2022-04-03 Juneau City and Borough Alaska 2110 8213 19
2366158 2366158 2022-04-02 Juneau City and Borough Alaska 2110 8213 19
2362905 2362905 2022-04-01 Juneau City and Borough Alaska 2110 8213 19
2359651 2359651 2022-03-31 Juneau City and Borough Alaska 2110 8162 19
2356397 2356397 2022-03-30 Juneau City and Borough Alaska 2110 8162 19
2353144 2353144 2022-03-29 Juneau City and Borough Alaska 2110 8108 19
2349892 2349892 2022-03-28 Juneau City and Borough Alaska 2110 8108 19
2346639 2346639 2022-03-27 Juneau City and Borough Alaska 2110 8108 19
2343386 2343386 2022-03-26 Juneau City and Borough Alaska 2110 8108 19
2340133 2340133 2022-03-25 Juneau City and Borough Alaska 2110 8108 19
2336880 2336880 2022-03-24 Juneau City and Borough Alaska 2110 8079 19
2333626 2333626 2022-03-23 Juneau City and Borough Alaska 2110 8079 19
2330372 2330372 2022-03-22 Juneau City and Borough Alaska 2110 8053 18
2327120 2327120 2022-03-21 Juneau City and Borough Alaska 2110 8053 18
2323867 2323867 2022-03-20 Juneau City and Borough Alaska 2110 8031 18
2320613 2320613 2022-03-19 Juneau City and Borough Alaska 2110 8031 18
2317359 2317359 2022-03-18 Juneau City and Borough Alaska 2110 8031 18
2314106 2314106 2022-03-17 Juneau City and Borough Alaska 2110 8005 18
2310853 2310853 2022-03-16 Juneau City and Borough Alaska 2110 8005 18
2307600 2307600 2022-03-15 Juneau City and Borough Alaska 2110 7985 18
2304349 2304349 2022-03-14 Juneau City and Borough Alaska 2110 7985 18
2301097 2301097 2022-03-13 Juneau City and Borough Alaska 2110 7949 18
2297845 2297845 2022-03-12 Juneau City and Borough Alaska 2110 7949 18
2294593 2294593 2022-03-11 Juneau City and Borough Alaska 2110 7949 18
2291341 2291341 2022-03-10 Juneau City and Borough Alaska 2110 7931 18
2288089 2288089 2022-03-09 Juneau City and Borough Alaska 2110 7931 18
2284837 2284837 2022-03-08 Juneau City and Borough Alaska 2110 7902 18
2281585 2281585 2022-03-07 Juneau City and Borough Alaska 2110 7902 18
2278332 2278332 2022-03-06 Juneau City and Borough Alaska 2110 7867 18
2275079 2275079 2022-03-05 Juneau City and Borough Alaska 2110 7867 18
2271826 2271826 2022-03-04 Juneau City and Borough Alaska 2110 7867 18
2268574 2268574 2022-03-03 Juneau City and Borough Alaska 2110 7835 18
2265321 2265321 2022-03-02 Juneau City and Borough Alaska 2110 7835 18
2262071 2262071 2022-03-01 Juneau City and Borough Alaska 2110 7797 18
2258820 2258820 2022-02-28 Juneau City and Borough Alaska 2110 7797 18
2255569 2255569 2022-02-27 Juneau City and Borough Alaska 2110 7767 18
2252318 2252318 2022-02-26 Juneau City and Borough Alaska 2110 7767 18
2249067 2249067 2022-02-25 Juneau City and Borough Alaska 2110 7767 18
2245816 2245816 2022-02-24 Juneau City and Borough Alaska 2110 7712 18
2242565 2242565 2022-02-23 Juneau City and Borough Alaska 2110 7712 18
2239314 2239314 2022-02-22 Juneau City and Borough Alaska 2110 7640 18
2236063 2236063 2022-02-21 Juneau City and Borough Alaska 2110 7640 18
2232812 2232812 2022-02-20 Juneau City and Borough Alaska 2110 7640 18
2229561 2229561 2022-02-19 Juneau City and Borough Alaska 2110 7640 18
2226310 2226310 2022-02-18 Juneau City and Borough Alaska 2110 7640 18
2223059 2223059 2022-02-17 Juneau City and Borough Alaska 2110 7600 18
2219808 2219808 2022-02-16 Juneau City and Borough Alaska 2110 7600 18
2216558 2216558 2022-02-15 Juneau City and Borough Alaska 2110 7578 16
2213307 2213307 2022-02-14 Juneau City and Borough Alaska 2110 7578 16
2210054 2210054 2022-02-13 Juneau City and Borough Alaska 2110 7518 16
2206801 2206801 2022-02-12 Juneau City and Borough Alaska 2110 7518 16
2203548 2203548 2022-02-11 Juneau City and Borough Alaska 2110 7518 16
2200294 2200294 2022-02-10 Juneau City and Borough Alaska 2110 7447 16
2197040 2197040 2022-02-09 Juneau City and Borough Alaska 2110 7447 16
2193785 2193785 2022-02-08 Juneau City and Borough Alaska 2110 7381 16
2190532 2190532 2022-02-07 Juneau City and Borough Alaska 2110 7381 16
2187279 2187279 2022-02-06 Juneau City and Borough Alaska 2110 7280 16
2184026 2184026 2022-02-05 Juneau City and Borough Alaska 2110 7280 16
2180774 2180774 2022-02-04 Juneau City and Borough Alaska 2110 7280 16
2177523 2177523 2022-02-03 Juneau City and Borough Alaska 2110 7166 16

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