ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
704 rows where fips = 2100 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 2499650 | 2499650 | 2022-05-13 | Haines Borough | Alaska | 2100 | 624 | 1 |
| 2496392 | 2496392 | 2022-05-12 | Haines Borough | Alaska | 2100 | 624 | 1 |
| 2493134 | 2493134 | 2022-05-11 | Haines Borough | Alaska | 2100 | 624 | 1 |
| 2489876 | 2489876 | 2022-05-10 | Haines Borough | Alaska | 2100 | 619 | 1 |
| 2486619 | 2486619 | 2022-05-09 | Haines Borough | Alaska | 2100 | 619 | 1 |
| 2483361 | 2483361 | 2022-05-08 | Haines Borough | Alaska | 2100 | 619 | 1 |
| 2480103 | 2480103 | 2022-05-07 | Haines Borough | Alaska | 2100 | 619 | 1 |
| 2476845 | 2476845 | 2022-05-06 | Haines Borough | Alaska | 2100 | 619 | 1 |
| 2473587 | 2473587 | 2022-05-05 | Haines Borough | Alaska | 2100 | 619 | 1 |
| 2470330 | 2470330 | 2022-05-04 | Haines Borough | Alaska | 2100 | 619 | 1 |
| 2467074 | 2467074 | 2022-05-03 | Haines Borough | Alaska | 2100 | 618 | 1 |
| 2463819 | 2463819 | 2022-05-02 | Haines Borough | Alaska | 2100 | 618 | 1 |
| 2460563 | 2460563 | 2022-05-01 | Haines Borough | Alaska | 2100 | 618 | 1 |
| 2457307 | 2457307 | 2022-04-30 | Haines Borough | Alaska | 2100 | 618 | 1 |
| 2454051 | 2454051 | 2022-04-29 | Haines Borough | Alaska | 2100 | 618 | 1 |
| 2450795 | 2450795 | 2022-04-28 | Haines Borough | Alaska | 2100 | 618 | 1 |
| 2447539 | 2447539 | 2022-04-27 | Haines Borough | Alaska | 2100 | 618 | 1 |
| 2444283 | 2444283 | 2022-04-26 | Haines Borough | Alaska | 2100 | 611 | 1 |
| 2441027 | 2441027 | 2022-04-25 | Haines Borough | Alaska | 2100 | 611 | 1 |
| 2437771 | 2437771 | 2022-04-24 | Haines Borough | Alaska | 2100 | 611 | 1 |
| 2434515 | 2434515 | 2022-04-23 | Haines Borough | Alaska | 2100 | 611 | 1 |
| 2431259 | 2431259 | 2022-04-22 | Haines Borough | Alaska | 2100 | 611 | 1 |
| 2428003 | 2428003 | 2022-04-21 | Haines Borough | Alaska | 2100 | 611 | 1 |
| 2424747 | 2424747 | 2022-04-20 | Haines Borough | Alaska | 2100 | 611 | 1 |
| 2421491 | 2421491 | 2022-04-19 | Haines Borough | Alaska | 2100 | 605 | 1 |
| 2418235 | 2418235 | 2022-04-18 | Haines Borough | Alaska | 2100 | 605 | 1 |
| 2414979 | 2414979 | 2022-04-17 | Haines Borough | Alaska | 2100 | 605 | 1 |
| 2411723 | 2411723 | 2022-04-16 | Haines Borough | Alaska | 2100 | 605 | 1 |
| 2408467 | 2408467 | 2022-04-15 | Haines Borough | Alaska | 2100 | 605 | 1 |
| 2405211 | 2405211 | 2022-04-14 | Haines Borough | Alaska | 2100 | 605 | 1 |
| 2401956 | 2401956 | 2022-04-13 | Haines Borough | Alaska | 2100 | 605 | 1 |
| 2398701 | 2398701 | 2022-04-12 | Haines Borough | Alaska | 2100 | 601 | 1 |
| 2395446 | 2395446 | 2022-04-11 | Haines Borough | Alaska | 2100 | 601 | 1 |
| 2392190 | 2392190 | 2022-04-10 | Haines Borough | Alaska | 2100 | 601 | 1 |
| 2388934 | 2388934 | 2022-04-09 | Haines Borough | Alaska | 2100 | 601 | 1 |
| 2385679 | 2385679 | 2022-04-08 | Haines Borough | Alaska | 2100 | 601 | 1 |
| 2382424 | 2382424 | 2022-04-07 | Haines Borough | Alaska | 2100 | 601 | 1 |
| 2379169 | 2379169 | 2022-04-06 | Haines Borough | Alaska | 2100 | 601 | 1 |
| 2375915 | 2375915 | 2022-04-05 | Haines Borough | Alaska | 2100 | 600 | 1 |
| 2372663 | 2372663 | 2022-04-04 | Haines Borough | Alaska | 2100 | 600 | 1 |
| 2369410 | 2369410 | 2022-04-03 | Haines Borough | Alaska | 2100 | 600 | 1 |
| 2366157 | 2366157 | 2022-04-02 | Haines Borough | Alaska | 2100 | 600 | 1 |
| 2362904 | 2362904 | 2022-04-01 | Haines Borough | Alaska | 2100 | 600 | 1 |
| 2359650 | 2359650 | 2022-03-31 | Haines Borough | Alaska | 2100 | 599 | 1 |
| 2356396 | 2356396 | 2022-03-30 | Haines Borough | Alaska | 2100 | 599 | 1 |
| 2353143 | 2353143 | 2022-03-29 | Haines Borough | Alaska | 2100 | 597 | 1 |
| 2349891 | 2349891 | 2022-03-28 | Haines Borough | Alaska | 2100 | 597 | 1 |
| 2346638 | 2346638 | 2022-03-27 | Haines Borough | Alaska | 2100 | 597 | 1 |
| 2343385 | 2343385 | 2022-03-26 | Haines Borough | Alaska | 2100 | 597 | 1 |
| 2340132 | 2340132 | 2022-03-25 | Haines Borough | Alaska | 2100 | 597 | 1 |
| 2336879 | 2336879 | 2022-03-24 | Haines Borough | Alaska | 2100 | 596 | 1 |
| 2333625 | 2333625 | 2022-03-23 | Haines Borough | Alaska | 2100 | 596 | 1 |
| 2330371 | 2330371 | 2022-03-22 | Haines Borough | Alaska | 2100 | 597 | 1 |
| 2327119 | 2327119 | 2022-03-21 | Haines Borough | Alaska | 2100 | 597 | 1 |
| 2323866 | 2323866 | 2022-03-20 | Haines Borough | Alaska | 2100 | 595 | 1 |
| 2320612 | 2320612 | 2022-03-19 | Haines Borough | Alaska | 2100 | 595 | 1 |
| 2317358 | 2317358 | 2022-03-18 | Haines Borough | Alaska | 2100 | 595 | 1 |
| 2314105 | 2314105 | 2022-03-17 | Haines Borough | Alaska | 2100 | 593 | 1 |
| 2310852 | 2310852 | 2022-03-16 | Haines Borough | Alaska | 2100 | 593 | 1 |
| 2307599 | 2307599 | 2022-03-15 | Haines Borough | Alaska | 2100 | 593 | 1 |
| 2304348 | 2304348 | 2022-03-14 | Haines Borough | Alaska | 2100 | 593 | 1 |
| 2301096 | 2301096 | 2022-03-13 | Haines Borough | Alaska | 2100 | 593 | 1 |
| 2297844 | 2297844 | 2022-03-12 | Haines Borough | Alaska | 2100 | 593 | 1 |
| 2294592 | 2294592 | 2022-03-11 | Haines Borough | Alaska | 2100 | 593 | 1 |
| 2291340 | 2291340 | 2022-03-10 | Haines Borough | Alaska | 2100 | 586 | 1 |
| 2288088 | 2288088 | 2022-03-09 | Haines Borough | Alaska | 2100 | 586 | 1 |
| 2284836 | 2284836 | 2022-03-08 | Haines Borough | Alaska | 2100 | 586 | 1 |
| 2281584 | 2281584 | 2022-03-07 | Haines Borough | Alaska | 2100 | 586 | 1 |
| 2278331 | 2278331 | 2022-03-06 | Haines Borough | Alaska | 2100 | 579 | 1 |
| 2275078 | 2275078 | 2022-03-05 | Haines Borough | Alaska | 2100 | 579 | 1 |
| 2271825 | 2271825 | 2022-03-04 | Haines Borough | Alaska | 2100 | 579 | 1 |
| 2268573 | 2268573 | 2022-03-03 | Haines Borough | Alaska | 2100 | 577 | 1 |
| 2265320 | 2265320 | 2022-03-02 | Haines Borough | Alaska | 2100 | 577 | 1 |
| 2262070 | 2262070 | 2022-03-01 | Haines Borough | Alaska | 2100 | 575 | 1 |
| 2258819 | 2258819 | 2022-02-28 | Haines Borough | Alaska | 2100 | 575 | 1 |
| 2255568 | 2255568 | 2022-02-27 | Haines Borough | Alaska | 2100 | 565 | 1 |
| 2252317 | 2252317 | 2022-02-26 | Haines Borough | Alaska | 2100 | 565 | 1 |
| 2249066 | 2249066 | 2022-02-25 | Haines Borough | Alaska | 2100 | 565 | 1 |
| 2245815 | 2245815 | 2022-02-24 | Haines Borough | Alaska | 2100 | 547 | 1 |
| 2242564 | 2242564 | 2022-02-23 | Haines Borough | Alaska | 2100 | 547 | 1 |
| 2239313 | 2239313 | 2022-02-22 | Haines Borough | Alaska | 2100 | 524 | 1 |
| 2236062 | 2236062 | 2022-02-21 | Haines Borough | Alaska | 2100 | 524 | 1 |
| 2232811 | 2232811 | 2022-02-20 | Haines Borough | Alaska | 2100 | 524 | 1 |
| 2229560 | 2229560 | 2022-02-19 | Haines Borough | Alaska | 2100 | 524 | 1 |
| 2226309 | 2226309 | 2022-02-18 | Haines Borough | Alaska | 2100 | 524 | 1 |
| 2223058 | 2223058 | 2022-02-17 | Haines Borough | Alaska | 2100 | 499 | 1 |
| 2219807 | 2219807 | 2022-02-16 | Haines Borough | Alaska | 2100 | 499 | 1 |
| 2216557 | 2216557 | 2022-02-15 | Haines Borough | Alaska | 2100 | 488 | 1 |
| 2213306 | 2213306 | 2022-02-14 | Haines Borough | Alaska | 2100 | 488 | 1 |
| 2210053 | 2210053 | 2022-02-13 | Haines Borough | Alaska | 2100 | 476 | 1 |
| 2206800 | 2206800 | 2022-02-12 | Haines Borough | Alaska | 2100 | 476 | 1 |
| 2203547 | 2203547 | 2022-02-11 | Haines Borough | Alaska | 2100 | 476 | 1 |
| 2200293 | 2200293 | 2022-02-10 | Haines Borough | Alaska | 2100 | 450 | 1 |
| 2197039 | 2197039 | 2022-02-09 | Haines Borough | Alaska | 2100 | 450 | 1 |
| 2193784 | 2193784 | 2022-02-08 | Haines Borough | Alaska | 2100 | 448 | 1 |
| 2190531 | 2190531 | 2022-02-07 | Haines Borough | Alaska | 2100 | 448 | 1 |
| 2187278 | 2187278 | 2022-02-06 | Haines Borough | Alaska | 2100 | 443 | 1 |
| 2184025 | 2184025 | 2022-02-05 | Haines Borough | Alaska | 2100 | 443 | 1 |
| 2180773 | 2180773 | 2022-02-04 | Haines Borough | Alaska | 2100 | 443 | 1 |
| 2177522 | 2177522 | 2022-02-03 | Haines Borough | Alaska | 2100 | 432 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
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);