ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 8045 and state = "Colorado" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2364 | 2364 | 2020-03-15 | Garfield | Colorado | 8045 | 1 | 0 |
2799 | 2799 | 2020-03-16 | Garfield | Colorado | 8045 | 2 | 0 |
3281 | 3281 | 2020-03-17 | Garfield | Colorado | 8045 | 2 | 0 |
3835 | 3835 | 2020-03-18 | Garfield | Colorado | 8045 | 2 | 0 |
4496 | 4496 | 2020-03-19 | Garfield | Colorado | 8045 | 3 | 0 |
5272 | 5272 | 2020-03-20 | Garfield | Colorado | 8045 | 4 | 0 |
6197 | 6197 | 2020-03-21 | Garfield | Colorado | 8045 | 7 | 0 |
7232 | 7232 | 2020-03-22 | Garfield | Colorado | 8045 | 8 | 0 |
8375 | 8375 | 2020-03-23 | Garfield | Colorado | 8045 | 8 | 0 |
9619 | 9619 | 2020-03-24 | Garfield | Colorado | 8045 | 10 | 0 |
10992 | 10992 | 2020-03-25 | Garfield | Colorado | 8045 | 13 | 0 |
12537 | 12537 | 2020-03-26 | Garfield | Colorado | 8045 | 16 | 0 |
14205 | 14205 | 2020-03-27 | Garfield | Colorado | 8045 | 16 | 0 |
15988 | 15988 | 2020-03-28 | Garfield | Colorado | 8045 | 23 | 0 |
17878 | 17878 | 2020-03-29 | Garfield | Colorado | 8045 | 25 | 0 |
19856 | 19856 | 2020-03-30 | Garfield | Colorado | 8045 | 31 | 1 |
21931 | 21931 | 2020-03-31 | Garfield | Colorado | 8045 | 33 | 1 |
24090 | 24090 | 2020-04-01 | Garfield | Colorado | 8045 | 34 | 1 |
26320 | 26320 | 2020-04-02 | Garfield | Colorado | 8045 | 43 | 1 |
28620 | 28620 | 2020-04-03 | Garfield | Colorado | 8045 | 45 | 1 |
30977 | 30977 | 2020-04-04 | Garfield | Colorado | 8045 | 45 | 1 |
33383 | 33383 | 2020-04-05 | Garfield | Colorado | 8045 | 46 | 1 |
35828 | 35828 | 2020-04-06 | Garfield | Colorado | 8045 | 47 | 1 |
38318 | 38318 | 2020-04-07 | Garfield | Colorado | 8045 | 48 | 1 |
40861 | 40861 | 2020-04-08 | Garfield | Colorado | 8045 | 49 | 1 |
43433 | 43433 | 2020-04-09 | Garfield | Colorado | 8045 | 50 | 2 |
46033 | 46033 | 2020-04-10 | Garfield | Colorado | 8045 | 52 | 2 |
48663 | 48663 | 2020-04-11 | Garfield | Colorado | 8045 | 54 | 2 |
51325 | 51325 | 2020-04-12 | Garfield | Colorado | 8045 | 55 | 2 |
54004 | 54004 | 2020-04-13 | Garfield | Colorado | 8045 | 58 | 2 |
56696 | 56696 | 2020-04-14 | Garfield | Colorado | 8045 | 59 | 2 |
59404 | 59404 | 2020-04-15 | Garfield | Colorado | 8045 | 62 | 2 |
62123 | 62123 | 2020-04-16 | Garfield | Colorado | 8045 | 64 | 2 |
64856 | 64856 | 2020-04-17 | Garfield | Colorado | 8045 | 65 | 2 |
67604 | 67604 | 2020-04-18 | Garfield | Colorado | 8045 | 70 | 2 |
70366 | 70366 | 2020-04-19 | Garfield | Colorado | 8045 | 70 | 2 |
73135 | 73135 | 2020-04-20 | Garfield | Colorado | 8045 | 71 | 2 |
75911 | 75911 | 2020-04-21 | Garfield | Colorado | 8045 | 71 | 2 |
78695 | 78695 | 2020-04-22 | Garfield | Colorado | 8045 | 71 | 2 |
81489 | 81489 | 2020-04-23 | Garfield | Colorado | 8045 | 74 | 2 |
84289 | 84289 | 2020-04-24 | Garfield | Colorado | 8045 | 81 | 2 |
87097 | 87097 | 2020-04-25 | Garfield | Colorado | 8045 | 83 | 2 |
89914 | 89914 | 2020-04-26 | Garfield | Colorado | 8045 | 87 | 2 |
92732 | 92732 | 2020-04-27 | Garfield | Colorado | 8045 | 88 | 2 |
95564 | 95564 | 2020-04-28 | Garfield | Colorado | 8045 | 89 | 2 |
98409 | 98409 | 2020-04-29 | Garfield | Colorado | 8045 | 91 | 2 |
101259 | 101259 | 2020-04-30 | Garfield | Colorado | 8045 | 93 | 2 |
104114 | 104114 | 2020-05-01 | Garfield | Colorado | 8045 | 93 | 2 |
106979 | 106979 | 2020-05-02 | Garfield | Colorado | 8045 | 95 | 2 |
109848 | 109848 | 2020-05-03 | Garfield | Colorado | 8045 | 97 | 2 |
112723 | 112723 | 2020-05-04 | Garfield | Colorado | 8045 | 95 | 2 |
115606 | 115606 | 2020-05-05 | Garfield | Colorado | 8045 | 99 | 2 |
118565 | 118565 | 2020-05-06 | Garfield | Colorado | 8045 | 99 | 2 |
121534 | 121534 | 2020-05-07 | Garfield | Colorado | 8045 | 100 | 2 |
124514 | 124514 | 2020-05-08 | Garfield | Colorado | 8045 | 102 | 2 |
127500 | 127500 | 2020-05-09 | Garfield | Colorado | 8045 | 103 | 2 |
130491 | 130491 | 2020-05-10 | Garfield | Colorado | 8045 | 104 | 2 |
133482 | 133482 | 2020-05-11 | Garfield | Colorado | 8045 | 103 | 2 |
136471 | 136471 | 2020-05-12 | Garfield | Colorado | 8045 | 111 | 2 |
139462 | 139462 | 2020-05-13 | Garfield | Colorado | 8045 | 112 | 2 |
142458 | 142458 | 2020-05-14 | Garfield | Colorado | 8045 | 112 | 2 |
145458 | 145458 | 2020-05-15 | Garfield | Colorado | 8045 | 113 | 2 |
148461 | 148461 | 2020-05-16 | Garfield | Colorado | 8045 | 113 | 2 |
151470 | 151470 | 2020-05-17 | Garfield | Colorado | 8045 | 115 | 2 |
154482 | 154482 | 2020-05-18 | Garfield | Colorado | 8045 | 114 | 2 |
157498 | 157498 | 2020-05-19 | Garfield | Colorado | 8045 | 115 | 2 |
160524 | 160524 | 2020-05-20 | Garfield | Colorado | 8045 | 114 | 2 |
163552 | 163552 | 2020-05-21 | Garfield | Colorado | 8045 | 114 | 2 |
166585 | 166585 | 2020-05-22 | Garfield | Colorado | 8045 | 120 | 2 |
169622 | 169622 | 2020-05-23 | Garfield | Colorado | 8045 | 120 | 2 |
172663 | 172663 | 2020-05-24 | Garfield | Colorado | 8045 | 121 | 2 |
175707 | 175707 | 2020-05-25 | Garfield | Colorado | 8045 | 123 | 2 |
178751 | 178751 | 2020-05-26 | Garfield | Colorado | 8045 | 134 | 2 |
181795 | 181795 | 2020-05-27 | Garfield | Colorado | 8045 | 135 | 2 |
184849 | 184849 | 2020-05-28 | Garfield | Colorado | 8045 | 135 | 2 |
187905 | 187905 | 2020-05-29 | Garfield | Colorado | 8045 | 137 | 2 |
190970 | 190970 | 2020-05-30 | Garfield | Colorado | 8045 | 138 | 2 |
194037 | 194037 | 2020-05-31 | Garfield | Colorado | 8045 | 139 | 2 |
197107 | 197107 | 2020-06-01 | Garfield | Colorado | 8045 | 143 | 2 |
200180 | 200180 | 2020-06-02 | Garfield | Colorado | 8045 | 148 | 2 |
203256 | 203256 | 2020-06-03 | Garfield | Colorado | 8045 | 150 | 2 |
206336 | 206336 | 2020-06-04 | Garfield | Colorado | 8045 | 157 | 2 |
209417 | 209417 | 2020-06-05 | Garfield | Colorado | 8045 | 158 | 2 |
212502 | 212502 | 2020-06-06 | Garfield | Colorado | 8045 | 161 | 2 |
215589 | 215589 | 2020-06-07 | Garfield | Colorado | 8045 | 162 | 2 |
218680 | 218680 | 2020-06-08 | Garfield | Colorado | 8045 | 164 | 2 |
221775 | 221775 | 2020-06-09 | Garfield | Colorado | 8045 | 166 | 2 |
224870 | 224870 | 2020-06-10 | Garfield | Colorado | 8045 | 171 | 2 |
227972 | 227972 | 2020-06-11 | Garfield | Colorado | 8045 | 176 | 2 |
231075 | 231075 | 2020-06-12 | Garfield | Colorado | 8045 | 177 | 2 |
234181 | 234181 | 2020-06-13 | Garfield | Colorado | 8045 | 181 | 2 |
237288 | 237288 | 2020-06-14 | Garfield | Colorado | 8045 | 184 | 2 |
240396 | 240396 | 2020-06-15 | Garfield | Colorado | 8045 | 193 | 2 |
243507 | 243507 | 2020-06-16 | Garfield | Colorado | 8045 | 195 | 2 |
246620 | 246620 | 2020-06-17 | Garfield | Colorado | 8045 | 199 | 2 |
249732 | 249732 | 2020-06-18 | Garfield | Colorado | 8045 | 205 | 2 |
252847 | 252847 | 2020-06-19 | Garfield | Colorado | 8045 | 214 | 2 |
255966 | 255966 | 2020-06-20 | Garfield | Colorado | 8045 | 217 | 2 |
259093 | 259093 | 2020-06-21 | Garfield | Colorado | 8045 | 222 | 2 |
262220 | 262220 | 2020-06-22 | Garfield | Colorado | 8045 | 224 | 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);