ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where county = "Custer" and deaths = 9 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Custer · 106 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500151 | 2500151 | 2022-05-13 | Custer | Idaho | 16037 | 532 | 9 |
2496893 | 2496893 | 2022-05-12 | Custer | Idaho | 16037 | 531 | 9 |
2493635 | 2493635 | 2022-05-11 | Custer | Idaho | 16037 | 531 | 9 |
2490377 | 2490377 | 2022-05-10 | Custer | Idaho | 16037 | 531 | 9 |
2487120 | 2487120 | 2022-05-09 | Custer | Idaho | 16037 | 531 | 9 |
2483862 | 2483862 | 2022-05-08 | Custer | Idaho | 16037 | 531 | 9 |
2480604 | 2480604 | 2022-05-07 | Custer | Idaho | 16037 | 531 | 9 |
2477346 | 2477346 | 2022-05-06 | Custer | Idaho | 16037 | 531 | 9 |
2474088 | 2474088 | 2022-05-05 | Custer | Idaho | 16037 | 530 | 9 |
2470831 | 2470831 | 2022-05-04 | Custer | Idaho | 16037 | 530 | 9 |
2467575 | 2467575 | 2022-05-03 | Custer | Idaho | 16037 | 530 | 9 |
2464320 | 2464320 | 2022-05-02 | Custer | Idaho | 16037 | 530 | 9 |
2461064 | 2461064 | 2022-05-01 | Custer | Idaho | 16037 | 530 | 9 |
2457808 | 2457808 | 2022-04-30 | Custer | Idaho | 16037 | 530 | 9 |
2454552 | 2454552 | 2022-04-29 | Custer | Idaho | 16037 | 530 | 9 |
2451296 | 2451296 | 2022-04-28 | Custer | Idaho | 16037 | 529 | 9 |
2448040 | 2448040 | 2022-04-27 | Custer | Idaho | 16037 | 529 | 9 |
2444784 | 2444784 | 2022-04-26 | Custer | Idaho | 16037 | 526 | 9 |
2441528 | 2441528 | 2022-04-25 | Custer | Idaho | 16037 | 526 | 9 |
2438272 | 2438272 | 2022-04-24 | Custer | Idaho | 16037 | 526 | 9 |
2435016 | 2435016 | 2022-04-23 | Custer | Idaho | 16037 | 526 | 9 |
2431760 | 2431760 | 2022-04-22 | Custer | Idaho | 16037 | 526 | 9 |
2428504 | 2428504 | 2022-04-21 | Custer | Idaho | 16037 | 526 | 9 |
2425248 | 2425248 | 2022-04-20 | Custer | Idaho | 16037 | 526 | 9 |
2421992 | 2421992 | 2022-04-19 | Custer | Idaho | 16037 | 525 | 9 |
2418736 | 2418736 | 2022-04-18 | Custer | Idaho | 16037 | 525 | 9 |
2415480 | 2415480 | 2022-04-17 | Custer | Idaho | 16037 | 525 | 9 |
2412224 | 2412224 | 2022-04-16 | Custer | Idaho | 16037 | 525 | 9 |
2408968 | 2408968 | 2022-04-15 | Custer | Idaho | 16037 | 525 | 9 |
2405712 | 2405712 | 2022-04-14 | Custer | Idaho | 16037 | 525 | 9 |
2402457 | 2402457 | 2022-04-13 | Custer | Idaho | 16037 | 525 | 9 |
2399202 | 2399202 | 2022-04-12 | Custer | Idaho | 16037 | 525 | 9 |
2395947 | 2395947 | 2022-04-11 | Custer | Idaho | 16037 | 524 | 9 |
2392691 | 2392691 | 2022-04-10 | Custer | Idaho | 16037 | 524 | 9 |
2389435 | 2389435 | 2022-04-09 | Custer | Idaho | 16037 | 524 | 9 |
2386180 | 2386180 | 2022-04-08 | Custer | Idaho | 16037 | 524 | 9 |
2382925 | 2382925 | 2022-04-07 | Custer | Idaho | 16037 | 524 | 9 |
2379670 | 2379670 | 2022-04-06 | Custer | Idaho | 16037 | 524 | 9 |
2376416 | 2376416 | 2022-04-05 | Custer | Idaho | 16037 | 524 | 9 |
2373164 | 2373164 | 2022-04-04 | Custer | Idaho | 16037 | 524 | 9 |
2369911 | 2369911 | 2022-04-03 | Custer | Idaho | 16037 | 524 | 9 |
2366658 | 2366658 | 2022-04-02 | Custer | Idaho | 16037 | 524 | 9 |
2363405 | 2363405 | 2022-04-01 | Custer | Idaho | 16037 | 524 | 9 |
2360151 | 2360151 | 2022-03-31 | Custer | Idaho | 16037 | 524 | 9 |
2356897 | 2356897 | 2022-03-30 | Custer | Idaho | 16037 | 524 | 9 |
2353644 | 2353644 | 2022-03-29 | Custer | Idaho | 16037 | 524 | 9 |
2350392 | 2350392 | 2022-03-28 | Custer | Idaho | 16037 | 524 | 9 |
2347139 | 2347139 | 2022-03-27 | Custer | Idaho | 16037 | 524 | 9 |
2343886 | 2343886 | 2022-03-26 | Custer | Idaho | 16037 | 524 | 9 |
2340633 | 2340633 | 2022-03-25 | Custer | Idaho | 16037 | 524 | 9 |
2337380 | 2337380 | 2022-03-24 | Custer | Idaho | 16037 | 524 | 9 |
2334126 | 2334126 | 2022-03-23 | Custer | Idaho | 16037 | 524 | 9 |
2330872 | 2330872 | 2022-03-22 | Custer | Idaho | 16037 | 524 | 9 |
2327620 | 2327620 | 2022-03-21 | Custer | Idaho | 16037 | 524 | 9 |
2324367 | 2324367 | 2022-03-20 | Custer | Idaho | 16037 | 524 | 9 |
2321113 | 2321113 | 2022-03-19 | Custer | Idaho | 16037 | 524 | 9 |
2317859 | 2317859 | 2022-03-18 | Custer | Idaho | 16037 | 524 | 9 |
2314606 | 2314606 | 2022-03-17 | Custer | Idaho | 16037 | 524 | 9 |
2311353 | 2311353 | 2022-03-16 | Custer | Idaho | 16037 | 524 | 9 |
2308100 | 2308100 | 2022-03-15 | Custer | Idaho | 16037 | 524 | 9 |
2304849 | 2304849 | 2022-03-14 | Custer | Idaho | 16037 | 524 | 9 |
2301597 | 2301597 | 2022-03-13 | Custer | Idaho | 16037 | 524 | 9 |
2298345 | 2298345 | 2022-03-12 | Custer | Idaho | 16037 | 524 | 9 |
2295093 | 2295093 | 2022-03-11 | Custer | Idaho | 16037 | 524 | 9 |
1914353 | 1914353 | 2021-11-14 | Custer | Colorado | 8027 | 433 | 9 |
1911103 | 1911103 | 2021-11-13 | Custer | Colorado | 8027 | 433 | 9 |
1907854 | 1907854 | 2021-11-12 | Custer | Colorado | 8027 | 433 | 9 |
1904605 | 1904605 | 2021-11-11 | Custer | Colorado | 8027 | 429 | 9 |
1901355 | 1901355 | 2021-11-10 | Custer | Colorado | 8027 | 426 | 9 |
1898105 | 1898105 | 2021-11-09 | Custer | Colorado | 8027 | 420 | 9 |
1894855 | 1894855 | 2021-11-08 | Custer | Colorado | 8027 | 418 | 9 |
926158 | 926158 | 2021-01-13 | Custer | South Dakota | 46033 | 697 | 9 |
922912 | 922912 | 2021-01-12 | Custer | South Dakota | 46033 | 696 | 9 |
919667 | 919667 | 2021-01-11 | Custer | South Dakota | 46033 | 695 | 9 |
916422 | 916422 | 2021-01-10 | Custer | South Dakota | 46033 | 695 | 9 |
913177 | 913177 | 2021-01-09 | Custer | South Dakota | 46033 | 695 | 9 |
909932 | 909932 | 2021-01-08 | Custer | South Dakota | 46033 | 695 | 9 |
906687 | 906687 | 2021-01-07 | Custer | South Dakota | 46033 | 692 | 9 |
903441 | 903441 | 2021-01-06 | Custer | South Dakota | 46033 | 690 | 9 |
899343 | 899343 | 2021-01-05 | Custer | Montana | 30017 | 999 | 9 |
900196 | 900196 | 2021-01-05 | Custer | South Dakota | 46033 | 685 | 9 |
896098 | 896098 | 2021-01-04 | Custer | Montana | 30017 | 986 | 9 |
896951 | 896951 | 2021-01-04 | Custer | South Dakota | 46033 | 683 | 9 |
892851 | 892851 | 2021-01-03 | Custer | Montana | 30017 | 986 | 9 |
893705 | 893705 | 2021-01-03 | Custer | South Dakota | 46033 | 683 | 9 |
889605 | 889605 | 2021-01-02 | Custer | Montana | 30017 | 987 | 9 |
890459 | 890459 | 2021-01-02 | Custer | South Dakota | 46033 | 679 | 9 |
886359 | 886359 | 2021-01-01 | Custer | Montana | 30017 | 987 | 9 |
887212 | 887212 | 2021-01-01 | Custer | South Dakota | 46033 | 672 | 9 |
883114 | 883114 | 2020-12-31 | Custer | Montana | 30017 | 987 | 9 |
883967 | 883967 | 2020-12-31 | Custer | South Dakota | 46033 | 672 | 9 |
879869 | 879869 | 2020-12-30 | Custer | Montana | 30017 | 968 | 9 |
880722 | 880722 | 2020-12-30 | Custer | South Dakota | 46033 | 672 | 9 |
876624 | 876624 | 2020-12-29 | Custer | Montana | 30017 | 952 | 9 |
877477 | 877477 | 2020-12-29 | Custer | South Dakota | 46033 | 671 | 9 |
874232 | 874232 | 2020-12-28 | Custer | South Dakota | 46033 | 669 | 9 |
870987 | 870987 | 2020-12-27 | Custer | South Dakota | 46033 | 666 | 9 |
867742 | 867742 | 2020-12-26 | Custer | South Dakota | 46033 | 666 | 9 |
864497 | 864497 | 2020-12-25 | Custer | South Dakota | 46033 | 666 | 9 |
861252 | 861252 | 2020-12-24 | Custer | South Dakota | 46033 | 666 | 9 |
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);