ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 8031 and state = "Colorado" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
600 | 600 | 2020-03-06 | Denver | Colorado | 8031 | 2 | 0 |
678 | 678 | 2020-03-07 | Denver | Colorado | 8031 | 2 | 0 |
773 | 773 | 2020-03-08 | Denver | Colorado | 8031 | 2 | 0 |
889 | 889 | 2020-03-09 | Denver | Colorado | 8031 | 3 | 0 |
1023 | 1023 | 2020-03-10 | Denver | Colorado | 8031 | 4 | 0 |
1190 | 1190 | 2020-03-11 | Denver | Colorado | 8031 | 6 | 0 |
1398 | 1398 | 2020-03-12 | Denver | Colorado | 8031 | 9 | 0 |
1660 | 1660 | 2020-03-13 | Denver | Colorado | 8031 | 17 | 0 |
1979 | 1979 | 2020-03-14 | Denver | Colorado | 8031 | 23 | 0 |
2360 | 2360 | 2020-03-15 | Denver | Colorado | 8031 | 28 | 0 |
2795 | 2795 | 2020-03-16 | Denver | Colorado | 8031 | 28 | 0 |
3277 | 3277 | 2020-03-17 | Denver | Colorado | 8031 | 41 | 0 |
3831 | 3831 | 2020-03-18 | Denver | Colorado | 8031 | 45 | 0 |
4492 | 4492 | 2020-03-19 | Denver | Colorado | 8031 | 61 | 0 |
5268 | 5268 | 2020-03-20 | Denver | Colorado | 8031 | 79 | 0 |
6192 | 6192 | 2020-03-21 | Denver | Colorado | 8031 | 98 | 0 |
7227 | 7227 | 2020-03-22 | Denver | Colorado | 8031 | 125 | 0 |
8370 | 8370 | 2020-03-23 | Denver | Colorado | 8031 | 148 | 0 |
9613 | 9613 | 2020-03-24 | Denver | Colorado | 8031 | 176 | 0 |
10986 | 10986 | 2020-03-25 | Denver | Colorado | 8031 | 214 | 3 |
12531 | 12531 | 2020-03-26 | Denver | Colorado | 8031 | 262 | 3 |
14199 | 14199 | 2020-03-27 | Denver | Colorado | 8031 | 312 | 3 |
15982 | 15982 | 2020-03-28 | Denver | Colorado | 8031 | 367 | 5 |
17872 | 17872 | 2020-03-29 | Denver | Colorado | 8031 | 408 | 5 |
19850 | 19850 | 2020-03-30 | Denver | Colorado | 8031 | 465 | 6 |
21925 | 21925 | 2020-03-31 | Denver | Colorado | 8031 | 539 | 7 |
24084 | 24084 | 2020-04-01 | Denver | Colorado | 8031 | 586 | 8 |
26314 | 26314 | 2020-04-02 | Denver | Colorado | 8031 | 643 | 11 |
28614 | 28614 | 2020-04-03 | Denver | Colorado | 8031 | 716 | 14 |
30971 | 30971 | 2020-04-04 | Denver | Colorado | 8031 | 769 | 14 |
33377 | 33377 | 2020-04-05 | Denver | Colorado | 8031 | 825 | 16 |
35822 | 35822 | 2020-04-06 | Denver | Colorado | 8031 | 847 | 15 |
38312 | 38312 | 2020-04-07 | Denver | Colorado | 8031 | 884 | 31 |
40855 | 40855 | 2020-04-08 | Denver | Colorado | 8031 | 927 | 33 |
43427 | 43427 | 2020-04-09 | Denver | Colorado | 8031 | 1031 | 38 |
46027 | 46027 | 2020-04-10 | Denver | Colorado | 8031 | 1113 | 42 |
48657 | 48657 | 2020-04-11 | Denver | Colorado | 8031 | 1182 | 46 |
51319 | 51319 | 2020-04-12 | Denver | Colorado | 8031 | 1247 | 46 |
53998 | 53998 | 2020-04-13 | Denver | Colorado | 8031 | 1346 | 51 |
56690 | 56690 | 2020-04-14 | Denver | Colorado | 8031 | 1402 | 56 |
59398 | 59398 | 2020-04-15 | Denver | Colorado | 8031 | 1468 | 61 |
62117 | 62117 | 2020-04-16 | Denver | Colorado | 8031 | 1549 | 63 |
64850 | 64850 | 2020-04-17 | Denver | Colorado | 8031 | 1636 | 66 |
67598 | 67598 | 2020-04-18 | Denver | Colorado | 8031 | 1723 | 74 |
70360 | 70360 | 2020-04-19 | Denver | Colorado | 8031 | 1784 | 75 |
73129 | 73129 | 2020-04-20 | Denver | Colorado | 8031 | 1880 | 83 |
75905 | 75905 | 2020-04-21 | Denver | Colorado | 8031 | 2004 | 91 |
78689 | 78689 | 2020-04-22 | Denver | Colorado | 8031 | 2071 | 96 |
81483 | 81483 | 2020-04-23 | Denver | Colorado | 8031 | 2172 | 98 |
84283 | 84283 | 2020-04-24 | Denver | Colorado | 8031 | 2385 | 128 |
87091 | 87091 | 2020-04-25 | Denver | Colorado | 8031 | 2487 | 132 |
89908 | 89908 | 2020-04-26 | Denver | Colorado | 8031 | 2583 | 132 |
92726 | 92726 | 2020-04-27 | Denver | Colorado | 8031 | 2682 | 135 |
95558 | 95558 | 2020-04-28 | Denver | Colorado | 8031 | 2791 | 145 |
98403 | 98403 | 2020-04-29 | Denver | Colorado | 8031 | 2890 | 150 |
101253 | 101253 | 2020-04-30 | Denver | Colorado | 8031 | 3001 | 154 |
104108 | 104108 | 2020-05-01 | Denver | Colorado | 8031 | 3092 | 163 |
106973 | 106973 | 2020-05-02 | Denver | Colorado | 8031 | 3222 | 164 |
109842 | 109842 | 2020-05-03 | Denver | Colorado | 8031 | 3345 | 166 |
112717 | 112717 | 2020-05-04 | Denver | Colorado | 8031 | 3428 | 166 |
115600 | 115600 | 2020-05-05 | Denver | Colorado | 8031 | 3546 | 188 |
118559 | 118559 | 2020-05-06 | Denver | Colorado | 8031 | 3674 | 195 |
121528 | 121528 | 2020-05-07 | Denver | Colorado | 8031 | 3799 | 199 |
124508 | 124508 | 2020-05-08 | Denver | Colorado | 8031 | 3892 | 202 |
127494 | 127494 | 2020-05-09 | Denver | Colorado | 8031 | 4001 | 205 |
130485 | 130485 | 2020-05-10 | Denver | Colorado | 8031 | 4070 | 206 |
133476 | 133476 | 2020-05-11 | Denver | Colorado | 8031 | 4118 | 212 |
136465 | 136465 | 2020-05-12 | Denver | Colorado | 8031 | 4187 | 214 |
139456 | 139456 | 2020-05-13 | Denver | Colorado | 8031 | 4254 | 233 |
142452 | 142452 | 2020-05-14 | Denver | Colorado | 8031 | 4359 | 237 |
145452 | 145452 | 2020-05-15 | Denver | Colorado | 8031 | 4452 | 248 |
148455 | 148455 | 2020-05-16 | Denver | Colorado | 8031 | 4548 | 261 |
151464 | 151464 | 2020-05-17 | Denver | Colorado | 8031 | 4656 | 265 |
154476 | 154476 | 2020-05-18 | Denver | Colorado | 8031 | 4720 | 272 |
157492 | 157492 | 2020-05-19 | Denver | Colorado | 8031 | 4790 | 285 |
160518 | 160518 | 2020-05-20 | Denver | Colorado | 8031 | 4858 | 294 |
163546 | 163546 | 2020-05-21 | Denver | Colorado | 8031 | 4948 | 296 |
166579 | 166579 | 2020-05-22 | Denver | Colorado | 8031 | 5056 | 299 |
169616 | 169616 | 2020-05-23 | Denver | Colorado | 8031 | 5151 | 299 |
172657 | 172657 | 2020-05-24 | Denver | Colorado | 8031 | 5173 | 299 |
175701 | 175701 | 2020-05-25 | Denver | Colorado | 8031 | 5216 | 298 |
178745 | 178745 | 2020-05-26 | Denver | Colorado | 8031 | 5269 | 301 |
181789 | 181789 | 2020-05-27 | Denver | Colorado | 8031 | 5316 | 313 |
184843 | 184843 | 2020-05-28 | Denver | Colorado | 8031 | 5434 | 324 |
187899 | 187899 | 2020-05-29 | Denver | Colorado | 8031 | 5569 | 326 |
190964 | 190964 | 2020-05-30 | Denver | Colorado | 8031 | 5690 | 327 |
194031 | 194031 | 2020-05-31 | Denver | Colorado | 8031 | 5775 | 327 |
197101 | 197101 | 2020-06-01 | Denver | Colorado | 8031 | 5802 | 329 |
200174 | 200174 | 2020-06-02 | Denver | Colorado | 8031 | 5854 | 332 |
203250 | 203250 | 2020-06-03 | Denver | Colorado | 8031 | 5917 | 334 |
206330 | 206330 | 2020-06-04 | Denver | Colorado | 8031 | 5977 | 336 |
209411 | 209411 | 2020-06-05 | Denver | Colorado | 8031 | 6041 | 338 |
212496 | 212496 | 2020-06-06 | Denver | Colorado | 8031 | 6079 | 339 |
215583 | 215583 | 2020-06-07 | Denver | Colorado | 8031 | 6106 | 339 |
218674 | 218674 | 2020-06-08 | Denver | Colorado | 8031 | 6138 | 348 |
221769 | 221769 | 2020-06-09 | Denver | Colorado | 8031 | 6176 | 349 |
224864 | 224864 | 2020-06-10 | Denver | Colorado | 8031 | 6204 | 357 |
227966 | 227966 | 2020-06-11 | Denver | Colorado | 8031 | 6232 | 358 |
231069 | 231069 | 2020-06-12 | Denver | Colorado | 8031 | 6257 | 360 |
234175 | 234175 | 2020-06-13 | Denver | Colorado | 8031 | 6301 | 360 |
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);