ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,515 rows where county = "Custer" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Custer · 4,515 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
26312 | 26312 | 2020-04-02 | Custer | Colorado | 8027 | 1 | 0 |
28612 | 28612 | 2020-04-03 | Custer | Colorado | 8027 | 2 | 0 |
30969 | 30969 | 2020-04-04 | Custer | Colorado | 8027 | 2 | 0 |
33375 | 33375 | 2020-04-05 | Custer | Colorado | 8027 | 2 | 0 |
35820 | 35820 | 2020-04-06 | Custer | Colorado | 8027 | 2 | 0 |
38310 | 38310 | 2020-04-07 | Custer | Colorado | 8027 | 2 | 0 |
40853 | 40853 | 2020-04-08 | Custer | Colorado | 8027 | 2 | 0 |
43425 | 43425 | 2020-04-09 | Custer | Colorado | 8027 | 2 | 0 |
46025 | 46025 | 2020-04-10 | Custer | Colorado | 8027 | 2 | 0 |
48655 | 48655 | 2020-04-11 | Custer | Colorado | 8027 | 2 | 0 |
51317 | 51317 | 2020-04-12 | Custer | Colorado | 8027 | 2 | 0 |
53996 | 53996 | 2020-04-13 | Custer | Colorado | 8027 | 2 | 0 |
56688 | 56688 | 2020-04-14 | Custer | Colorado | 8027 | 2 | 0 |
59396 | 59396 | 2020-04-15 | Custer | Colorado | 8027 | 2 | 0 |
62115 | 62115 | 2020-04-16 | Custer | Colorado | 8027 | 2 | 0 |
64848 | 64848 | 2020-04-17 | Custer | Colorado | 8027 | 2 | 0 |
67596 | 67596 | 2020-04-18 | Custer | Colorado | 8027 | 2 | 0 |
70358 | 70358 | 2020-04-19 | Custer | Colorado | 8027 | 2 | 0 |
73127 | 73127 | 2020-04-20 | Custer | Colorado | 8027 | 2 | 0 |
75903 | 75903 | 2020-04-21 | Custer | Colorado | 8027 | 2 | 0 |
78687 | 78687 | 2020-04-22 | Custer | Colorado | 8027 | 2 | 0 |
81481 | 81481 | 2020-04-23 | Custer | Colorado | 8027 | 2 | 0 |
84281 | 84281 | 2020-04-24 | Custer | Colorado | 8027 | 2 | 0 |
87089 | 87089 | 2020-04-25 | Custer | Colorado | 8027 | 2 | 0 |
89906 | 89906 | 2020-04-26 | Custer | Colorado | 8027 | 2 | 0 |
92724 | 92724 | 2020-04-27 | Custer | Colorado | 8027 | 2 | 0 |
95556 | 95556 | 2020-04-28 | Custer | Colorado | 8027 | 2 | 0 |
98401 | 98401 | 2020-04-29 | Custer | Colorado | 8027 | 2 | 0 |
101251 | 101251 | 2020-04-30 | Custer | Colorado | 8027 | 2 | 0 |
104106 | 104106 | 2020-05-01 | Custer | Colorado | 8027 | 2 | 0 |
106971 | 106971 | 2020-05-02 | Custer | Colorado | 8027 | 2 | 0 |
109840 | 109840 | 2020-05-03 | Custer | Colorado | 8027 | 2 | 0 |
112715 | 112715 | 2020-05-04 | Custer | Colorado | 8027 | 2 | 0 |
115598 | 115598 | 2020-05-05 | Custer | Colorado | 8027 | 2 | 0 |
118557 | 118557 | 2020-05-06 | Custer | Colorado | 8027 | 2 | 0 |
121526 | 121526 | 2020-05-07 | Custer | Colorado | 8027 | 2 | 0 |
124506 | 124506 | 2020-05-08 | Custer | Colorado | 8027 | 2 | 0 |
127492 | 127492 | 2020-05-09 | Custer | Colorado | 8027 | 2 | 0 |
130483 | 130483 | 2020-05-10 | Custer | Colorado | 8027 | 2 | 0 |
133474 | 133474 | 2020-05-11 | Custer | Colorado | 8027 | 2 | 0 |
136463 | 136463 | 2020-05-12 | Custer | Colorado | 8027 | 2 | 0 |
139454 | 139454 | 2020-05-13 | Custer | Colorado | 8027 | 2 | 0 |
142450 | 142450 | 2020-05-14 | Custer | Colorado | 8027 | 2 | 0 |
145450 | 145450 | 2020-05-15 | Custer | Colorado | 8027 | 2 | 0 |
148453 | 148453 | 2020-05-16 | Custer | Colorado | 8027 | 2 | 0 |
151462 | 151462 | 2020-05-17 | Custer | Colorado | 8027 | 2 | 0 |
154474 | 154474 | 2020-05-18 | Custer | Colorado | 8027 | 2 | 0 |
157490 | 157490 | 2020-05-19 | Custer | Colorado | 8027 | 2 | 0 |
160516 | 160516 | 2020-05-20 | Custer | Colorado | 8027 | 2 | 0 |
163544 | 163544 | 2020-05-21 | Custer | Colorado | 8027 | 2 | 0 |
166577 | 166577 | 2020-05-22 | Custer | Colorado | 8027 | 2 | 0 |
169614 | 169614 | 2020-05-23 | Custer | Colorado | 8027 | 2 | 0 |
172655 | 172655 | 2020-05-24 | Custer | Colorado | 8027 | 2 | 0 |
175699 | 175699 | 2020-05-25 | Custer | Colorado | 8027 | 2 | 0 |
178743 | 178743 | 2020-05-26 | Custer | Colorado | 8027 | 2 | 0 |
181787 | 181787 | 2020-05-27 | Custer | Colorado | 8027 | 2 | 0 |
184841 | 184841 | 2020-05-28 | Custer | Colorado | 8027 | 2 | 0 |
187897 | 187897 | 2020-05-29 | Custer | Colorado | 8027 | 2 | 0 |
190962 | 190962 | 2020-05-30 | Custer | Colorado | 8027 | 2 | 0 |
194029 | 194029 | 2020-05-31 | Custer | Colorado | 8027 | 2 | 0 |
197099 | 197099 | 2020-06-01 | Custer | Colorado | 8027 | 2 | 0 |
200172 | 200172 | 2020-06-02 | Custer | Colorado | 8027 | 2 | 0 |
203248 | 203248 | 2020-06-03 | Custer | Colorado | 8027 | 2 | 0 |
206328 | 206328 | 2020-06-04 | Custer | Colorado | 8027 | 2 | 0 |
209409 | 209409 | 2020-06-05 | Custer | Colorado | 8027 | 2 | 0 |
212494 | 212494 | 2020-06-06 | Custer | Colorado | 8027 | 2 | 0 |
215581 | 215581 | 2020-06-07 | Custer | Colorado | 8027 | 2 | 0 |
218672 | 218672 | 2020-06-08 | Custer | Colorado | 8027 | 2 | 0 |
221767 | 221767 | 2020-06-09 | Custer | Colorado | 8027 | 2 | 0 |
224862 | 224862 | 2020-06-10 | Custer | Colorado | 8027 | 2 | 0 |
227964 | 227964 | 2020-06-11 | Custer | Colorado | 8027 | 2 | 0 |
231067 | 231067 | 2020-06-12 | Custer | Colorado | 8027 | 2 | 0 |
234173 | 234173 | 2020-06-13 | Custer | Colorado | 8027 | 2 | 0 |
237280 | 237280 | 2020-06-14 | Custer | Colorado | 8027 | 2 | 0 |
240388 | 240388 | 2020-06-15 | Custer | Colorado | 8027 | 2 | 0 |
243499 | 243499 | 2020-06-16 | Custer | Colorado | 8027 | 2 | 0 |
246612 | 246612 | 2020-06-17 | Custer | Colorado | 8027 | 2 | 0 |
249724 | 249724 | 2020-06-18 | Custer | Colorado | 8027 | 2 | 0 |
252839 | 252839 | 2020-06-19 | Custer | Colorado | 8027 | 2 | 0 |
255958 | 255958 | 2020-06-20 | Custer | Colorado | 8027 | 2 | 0 |
259085 | 259085 | 2020-06-21 | Custer | Colorado | 8027 | 2 | 0 |
262212 | 262212 | 2020-06-22 | Custer | Colorado | 8027 | 2 | 0 |
265340 | 265340 | 2020-06-23 | Custer | Colorado | 8027 | 2 | 0 |
268470 | 268470 | 2020-06-24 | Custer | Colorado | 8027 | 2 | 0 |
271605 | 271605 | 2020-06-25 | Custer | Colorado | 8027 | 2 | 0 |
274745 | 274745 | 2020-06-26 | Custer | Colorado | 8027 | 2 | 0 |
277893 | 277893 | 2020-06-27 | Custer | Colorado | 8027 | 2 | 0 |
281040 | 281040 | 2020-06-28 | Custer | Colorado | 8027 | 2 | 0 |
284186 | 284186 | 2020-06-29 | Custer | Colorado | 8027 | 2 | 0 |
287332 | 287332 | 2020-06-30 | Custer | Colorado | 8027 | 2 | 0 |
290483 | 290483 | 2020-07-01 | Custer | Colorado | 8027 | 2 | 0 |
293637 | 293637 | 2020-07-02 | Custer | Colorado | 8027 | 2 | 0 |
296793 | 296793 | 2020-07-03 | Custer | Colorado | 8027 | 2 | 0 |
299955 | 299955 | 2020-07-04 | Custer | Colorado | 8027 | 2 | 0 |
303119 | 303119 | 2020-07-05 | Custer | Colorado | 8027 | 2 | 0 |
306283 | 306283 | 2020-07-06 | Custer | Colorado | 8027 | 2 | 0 |
309451 | 309451 | 2020-07-07 | Custer | Colorado | 8027 | 2 | 0 |
312621 | 312621 | 2020-07-08 | Custer | Colorado | 8027 | 3 | 0 |
315796 | 315796 | 2020-07-09 | Custer | Colorado | 8027 | 3 | 0 |
318969 | 318969 | 2020-07-10 | Custer | Colorado | 8027 | 3 | 0 |
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);