ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8039 and state = "Colorado" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6196 | 6196 | 2020-03-21 | Elbert | Colorado | 8039 | 3 | 0 |
7231 | 7231 | 2020-03-22 | Elbert | Colorado | 8039 | 3 | 0 |
8374 | 8374 | 2020-03-23 | Elbert | Colorado | 8039 | 3 | 0 |
9617 | 9617 | 2020-03-24 | Elbert | Colorado | 8039 | 3 | 0 |
10990 | 10990 | 2020-03-25 | Elbert | Colorado | 8039 | 3 | 0 |
12535 | 12535 | 2020-03-26 | Elbert | Colorado | 8039 | 3 | 0 |
14203 | 14203 | 2020-03-27 | Elbert | Colorado | 8039 | 3 | 0 |
15986 | 15986 | 2020-03-28 | Elbert | Colorado | 8039 | 3 | 0 |
17876 | 17876 | 2020-03-29 | Elbert | Colorado | 8039 | 3 | 0 |
19854 | 19854 | 2020-03-30 | Elbert | Colorado | 8039 | 4 | 0 |
21929 | 21929 | 2020-03-31 | Elbert | Colorado | 8039 | 5 | 0 |
24088 | 24088 | 2020-04-01 | Elbert | Colorado | 8039 | 5 | 0 |
26318 | 26318 | 2020-04-02 | Elbert | Colorado | 8039 | 5 | 0 |
28618 | 28618 | 2020-04-03 | Elbert | Colorado | 8039 | 6 | 0 |
30975 | 30975 | 2020-04-04 | Elbert | Colorado | 8039 | 9 | 1 |
33381 | 33381 | 2020-04-05 | Elbert | Colorado | 8039 | 9 | 1 |
35826 | 35826 | 2020-04-06 | Elbert | Colorado | 8039 | 9 | 1 |
38316 | 38316 | 2020-04-07 | Elbert | Colorado | 8039 | 9 | 1 |
40859 | 40859 | 2020-04-08 | Elbert | Colorado | 8039 | 10 | 1 |
43431 | 43431 | 2020-04-09 | Elbert | Colorado | 8039 | 10 | 1 |
46031 | 46031 | 2020-04-10 | Elbert | Colorado | 8039 | 13 | 1 |
48661 | 48661 | 2020-04-11 | Elbert | Colorado | 8039 | 14 | 1 |
51323 | 51323 | 2020-04-12 | Elbert | Colorado | 8039 | 16 | 1 |
54002 | 54002 | 2020-04-13 | Elbert | Colorado | 8039 | 16 | 1 |
56694 | 56694 | 2020-04-14 | Elbert | Colorado | 8039 | 17 | 1 |
59402 | 59402 | 2020-04-15 | Elbert | Colorado | 8039 | 16 | 1 |
62121 | 62121 | 2020-04-16 | Elbert | Colorado | 8039 | 17 | 1 |
64854 | 64854 | 2020-04-17 | Elbert | Colorado | 8039 | 20 | 1 |
67602 | 67602 | 2020-04-18 | Elbert | Colorado | 8039 | 23 | 1 |
70364 | 70364 | 2020-04-19 | Elbert | Colorado | 8039 | 23 | 1 |
73133 | 73133 | 2020-04-20 | Elbert | Colorado | 8039 | 24 | 1 |
75909 | 75909 | 2020-04-21 | Elbert | Colorado | 8039 | 24 | 1 |
78693 | 78693 | 2020-04-22 | Elbert | Colorado | 8039 | 24 | 1 |
81487 | 81487 | 2020-04-23 | Elbert | Colorado | 8039 | 26 | 1 |
84287 | 84287 | 2020-04-24 | Elbert | Colorado | 8039 | 27 | 1 |
87095 | 87095 | 2020-04-25 | Elbert | Colorado | 8039 | 27 | 1 |
89912 | 89912 | 2020-04-26 | Elbert | Colorado | 8039 | 27 | 1 |
92730 | 92730 | 2020-04-27 | Elbert | Colorado | 8039 | 27 | 1 |
95562 | 95562 | 2020-04-28 | Elbert | Colorado | 8039 | 27 | 1 |
98407 | 98407 | 2020-04-29 | Elbert | Colorado | 8039 | 28 | 1 |
101257 | 101257 | 2020-04-30 | Elbert | Colorado | 8039 | 29 | 1 |
104112 | 104112 | 2020-05-01 | Elbert | Colorado | 8039 | 30 | 1 |
106977 | 106977 | 2020-05-02 | Elbert | Colorado | 8039 | 31 | 1 |
109846 | 109846 | 2020-05-03 | Elbert | Colorado | 8039 | 31 | 1 |
112721 | 112721 | 2020-05-04 | Elbert | Colorado | 8039 | 32 | 1 |
115604 | 115604 | 2020-05-05 | Elbert | Colorado | 8039 | 36 | 1 |
118563 | 118563 | 2020-05-06 | Elbert | Colorado | 8039 | 37 | 1 |
121532 | 121532 | 2020-05-07 | Elbert | Colorado | 8039 | 37 | 1 |
124512 | 124512 | 2020-05-08 | Elbert | Colorado | 8039 | 39 | 1 |
127498 | 127498 | 2020-05-09 | Elbert | Colorado | 8039 | 39 | 1 |
130489 | 130489 | 2020-05-10 | Elbert | Colorado | 8039 | 39 | 1 |
133480 | 133480 | 2020-05-11 | Elbert | Colorado | 8039 | 39 | 1 |
136469 | 136469 | 2020-05-12 | Elbert | Colorado | 8039 | 40 | 2 |
139460 | 139460 | 2020-05-13 | Elbert | Colorado | 8039 | 41 | 2 |
142456 | 142456 | 2020-05-14 | Elbert | Colorado | 8039 | 41 | 2 |
145456 | 145456 | 2020-05-15 | Elbert | Colorado | 8039 | 42 | 2 |
148459 | 148459 | 2020-05-16 | Elbert | Colorado | 8039 | 44 | 2 |
151468 | 151468 | 2020-05-17 | Elbert | Colorado | 8039 | 45 | 2 |
154480 | 154480 | 2020-05-18 | Elbert | Colorado | 8039 | 47 | 2 |
157496 | 157496 | 2020-05-19 | Elbert | Colorado | 8039 | 47 | 2 |
160522 | 160522 | 2020-05-20 | Elbert | Colorado | 8039 | 48 | 2 |
163550 | 163550 | 2020-05-21 | Elbert | Colorado | 8039 | 48 | 2 |
166583 | 166583 | 2020-05-22 | Elbert | Colorado | 8039 | 48 | 2 |
169620 | 169620 | 2020-05-23 | Elbert | Colorado | 8039 | 48 | 2 |
172661 | 172661 | 2020-05-24 | Elbert | Colorado | 8039 | 48 | 2 |
175705 | 175705 | 2020-05-25 | Elbert | Colorado | 8039 | 49 | 2 |
178749 | 178749 | 2020-05-26 | Elbert | Colorado | 8039 | 49 | 2 |
181793 | 181793 | 2020-05-27 | Elbert | Colorado | 8039 | 51 | 2 |
184847 | 184847 | 2020-05-28 | Elbert | Colorado | 8039 | 51 | 2 |
187903 | 187903 | 2020-05-29 | Elbert | Colorado | 8039 | 52 | 2 |
190968 | 190968 | 2020-05-30 | Elbert | Colorado | 8039 | 52 | 2 |
194035 | 194035 | 2020-05-31 | Elbert | Colorado | 8039 | 53 | 2 |
197105 | 197105 | 2020-06-01 | Elbert | Colorado | 8039 | 53 | 2 |
200178 | 200178 | 2020-06-02 | Elbert | Colorado | 8039 | 53 | 2 |
203254 | 203254 | 2020-06-03 | Elbert | Colorado | 8039 | 53 | 2 |
206334 | 206334 | 2020-06-04 | Elbert | Colorado | 8039 | 53 | 2 |
209415 | 209415 | 2020-06-05 | Elbert | Colorado | 8039 | 53 | 2 |
212500 | 212500 | 2020-06-06 | Elbert | Colorado | 8039 | 54 | 2 |
215587 | 215587 | 2020-06-07 | Elbert | Colorado | 8039 | 54 | 2 |
218678 | 218678 | 2020-06-08 | Elbert | Colorado | 8039 | 56 | 2 |
221773 | 221773 | 2020-06-09 | Elbert | Colorado | 8039 | 57 | 2 |
224868 | 224868 | 2020-06-10 | Elbert | Colorado | 8039 | 54 | 2 |
227970 | 227970 | 2020-06-11 | Elbert | Colorado | 8039 | 54 | 2 |
231073 | 231073 | 2020-06-12 | Elbert | Colorado | 8039 | 54 | 2 |
234179 | 234179 | 2020-06-13 | Elbert | Colorado | 8039 | 54 | 2 |
237286 | 237286 | 2020-06-14 | Elbert | Colorado | 8039 | 54 | 2 |
240394 | 240394 | 2020-06-15 | Elbert | Colorado | 8039 | 54 | 2 |
243505 | 243505 | 2020-06-16 | Elbert | Colorado | 8039 | 54 | 2 |
246618 | 246618 | 2020-06-17 | Elbert | Colorado | 8039 | 54 | 2 |
249730 | 249730 | 2020-06-18 | Elbert | Colorado | 8039 | 54 | 2 |
252845 | 252845 | 2020-06-19 | Elbert | Colorado | 8039 | 54 | 2 |
255964 | 255964 | 2020-06-20 | Elbert | Colorado | 8039 | 54 | 2 |
259091 | 259091 | 2020-06-21 | Elbert | Colorado | 8039 | 54 | 2 |
262218 | 262218 | 2020-06-22 | Elbert | Colorado | 8039 | 54 | 2 |
265346 | 265346 | 2020-06-23 | Elbert | Colorado | 8039 | 54 | 2 |
268476 | 268476 | 2020-06-24 | Elbert | Colorado | 8039 | 54 | 2 |
271611 | 271611 | 2020-06-25 | Elbert | Colorado | 8039 | 55 | 2 |
274751 | 274751 | 2020-06-26 | Elbert | Colorado | 8039 | 56 | 2 |
277899 | 277899 | 2020-06-27 | Elbert | Colorado | 8039 | 56 | 2 |
281046 | 281046 | 2020-06-28 | Elbert | Colorado | 8039 | 57 | 2 |
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);