ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Larimer" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 240 ✖
- 248 41
- 29 22
- 55 20
- 19 18
- 227 17
- 0 16
- 478 15
- 231 14
- 459 14
- 21 12
- 240 12
- 35 11
- 37 11
- 28 10
- 27 9
- 30 9
- 233 9
- 250 9
- 483 9
- 9 8
- 63 8
- 245 8
- 32 7
- 57 7
- 222 7
- 242 7
- 249 7
- 460 7
- 462 7
- 44 6
- 79 6
- 229 6
- 277 6
- 8 5
- 42 5
- 52 5
- 176 5
- 224 5
- 226 5
- 230 5
- 243 5
- 396 5
- 410 5
- 479 5
- 31 4
- 49 4
- 66 4
- 128 4
- 208 4
- 235 4
- 244 4
- 251 4
- 261 4
- 278 4
- 284 4
- 313 4
- 319 4
- 378 4
- 391 4
- 403 4
- 420 4
- 436 4
- 454 4
- 458 4
- 477 4
- 480 4
- 502 4
- 503 4
- 1 3
- 7 3
- 18 3
- 36 3
- 46 3
- 50 3
- 56 3
- 60 3
- 75 3
- 182 3
- 192 3
- 214 3
- 246 3
- 252 3
- 255 3
- 265 3
- 275 3
- 282 3
- 287 3
- 292 3
- 303 3
- 336 3
- 353 3
- 365 3
- 386 3
- 399 3
- 400 3
- 435 3
- 484 3
- 3 2
- 12 2
- 13 2
- 34 2
- 39 2
- 43 2
- 45 2
- 53 2
- 54 2
- 59 2
- 64 2
- 74 2
- 92 2
- 95 2
- 112 2
- 154 2
- 175 2
- 212 2
- 218 2
- 219 2
- 225 2
- 260 2
- 263 2
- 264 2
- 272 2
- 291 2
- 298 2
- 314 2
- 325 2
- 382 2
- 395 2
- 401 2
- 416 2
- 418 2
- 424 2
- 427 2
- 431 2
- 448 2
- 457 2
- 500 2
- 4 1
- 6 1
- 10 1
- 14 1
- 15 1
- 22 1
- 33 1
- 38 1
- 47 1
- 48 1
- 51 1
- 61 1
- 65 1
- 67 1
- 69 1
- 73 1
- 76 1
- 86 1
- 89 1
- 98 1
- 101 1
- 105 1
- 109 1
- 111 1
- 116 1
- 121 1
- 125 1
- 134 1
- 137 1
- 142 1
- 147 1
- 148 1
- 150 1
- 151 1
- 164 1
- 166 1
- 167 1
- 169 1
- 170 1
- 171 1
- 177 1
- 179 1
- 180 1
- 181 1
- 186 1
- 189 1
- 196 1
- 198 1
- 199 1
- 201 1
- 204 1
- 209 1
- 213 1
- 215 1
- 217 1
- 221 1
- 228 1
- 232 1
- 234 1
- 238 1
- 241 1
- 247 1
- 254 1
- 259 1
- 267 1
- 268 1
- 276 1
- 288 1
- 290 1
- 300 1
- 302 1
- 305 1
- 306 1
- 309 1
- 312 1
- 327 1
- 332 1
- 342 1
- 345 1
- 348 1
- 351 1
- 355 1
- 361 1
- 364 1
- 367 1
- 369 1
- 373 1
- 375 1
- 379 1
- 384 1
- 387 1
- 389 1
- 390 1
- 393 1
- 402 1
- 408 1
- 409 1
- 452 1
- 456 1
- 481 1
- 501 1
- 505 1
- 507 1
state 1
- Colorado 796
fips 1
- 8069 796
county 1
- Larimer · 796 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
894 | 894 | 2020-03-09 | Larimer | Colorado | 8069 | 1 | 0 |
1029 | 1029 | 2020-03-10 | Larimer | Colorado | 8069 | 1 | 0 |
1196 | 1196 | 2020-03-11 | Larimer | Colorado | 8069 | 1 | 0 |
1404 | 1404 | 2020-03-12 | Larimer | Colorado | 8069 | 1 | 0 |
1666 | 1666 | 2020-03-13 | Larimer | Colorado | 8069 | 1 | 0 |
1985 | 1985 | 2020-03-14 | Larimer | Colorado | 8069 | 1 | 0 |
2367 | 2367 | 2020-03-15 | Larimer | Colorado | 8069 | 1 | 0 |
2802 | 2802 | 2020-03-16 | Larimer | Colorado | 8069 | 2 | 0 |
3284 | 3284 | 2020-03-17 | Larimer | Colorado | 8069 | 2 | 0 |
3838 | 3838 | 2020-03-18 | Larimer | Colorado | 8069 | 4 | 0 |
4500 | 4500 | 2020-03-19 | Larimer | Colorado | 8069 | 5 | 0 |
5276 | 5276 | 2020-03-20 | Larimer | Colorado | 8069 | 7 | 0 |
6202 | 6202 | 2020-03-21 | Larimer | Colorado | 8069 | 19 | 0 |
7237 | 7237 | 2020-03-22 | Larimer | Colorado | 8069 | 32 | 0 |
8381 | 8381 | 2020-03-23 | Larimer | Colorado | 8069 | 34 | 0 |
9626 | 9626 | 2020-03-24 | Larimer | Colorado | 8069 | 43 | 0 |
10999 | 10999 | 2020-03-25 | Larimer | Colorado | 8069 | 45 | 1 |
12545 | 12545 | 2020-03-26 | Larimer | Colorado | 8069 | 61 | 1 |
14213 | 14213 | 2020-03-27 | Larimer | Colorado | 8069 | 67 | 1 |
15996 | 15996 | 2020-03-28 | Larimer | Colorado | 8069 | 79 | 3 |
17886 | 17886 | 2020-03-29 | Larimer | Colorado | 8069 | 84 | 3 |
19864 | 19864 | 2020-03-30 | Larimer | Colorado | 8069 | 92 | 4 |
21940 | 21940 | 2020-03-31 | Larimer | Colorado | 8069 | 99 | 6 |
24099 | 24099 | 2020-04-01 | Larimer | Colorado | 8069 | 107 | 7 |
26329 | 26329 | 2020-04-02 | Larimer | Colorado | 8069 | 124 | 7 |
28629 | 28629 | 2020-04-03 | Larimer | Colorado | 8069 | 134 | 7 |
30986 | 30986 | 2020-04-04 | Larimer | Colorado | 8069 | 144 | 8 |
33392 | 33392 | 2020-04-05 | Larimer | Colorado | 8069 | 153 | 8 |
35837 | 35837 | 2020-04-06 | Larimer | Colorado | 8069 | 158 | 8 |
38327 | 38327 | 2020-04-07 | Larimer | Colorado | 8069 | 161 | 8 |
40870 | 40870 | 2020-04-08 | Larimer | Colorado | 8069 | 167 | 8 |
43443 | 43443 | 2020-04-09 | Larimer | Colorado | 8069 | 174 | 9 |
46043 | 46043 | 2020-04-10 | Larimer | Colorado | 8069 | 177 | 9 |
48673 | 48673 | 2020-04-11 | Larimer | Colorado | 8069 | 180 | 9 |
51335 | 51335 | 2020-04-12 | Larimer | Colorado | 8069 | 187 | 9 |
54014 | 54014 | 2020-04-13 | Larimer | Colorado | 8069 | 193 | 9 |
56706 | 56706 | 2020-04-14 | Larimer | Colorado | 8069 | 198 | 9 |
59414 | 59414 | 2020-04-15 | Larimer | Colorado | 8069 | 202 | 9 |
62133 | 62133 | 2020-04-16 | Larimer | Colorado | 8069 | 217 | 9 |
64866 | 64866 | 2020-04-17 | Larimer | Colorado | 8069 | 224 | 10 |
67614 | 67614 | 2020-04-18 | Larimer | Colorado | 8069 | 231 | 12 |
70376 | 70376 | 2020-04-19 | Larimer | Colorado | 8069 | 239 | 12 |
73145 | 73145 | 2020-04-20 | Larimer | Colorado | 8069 | 245 | 13 |
75921 | 75921 | 2020-04-21 | Larimer | Colorado | 8069 | 250 | 13 |
78705 | 78705 | 2020-04-22 | Larimer | Colorado | 8069 | 266 | 14 |
81499 | 81499 | 2020-04-23 | Larimer | Colorado | 8069 | 274 | 15 |
84299 | 84299 | 2020-04-24 | Larimer | Colorado | 8069 | 291 | 18 |
87107 | 87107 | 2020-04-25 | Larimer | Colorado | 8069 | 303 | 18 |
89924 | 89924 | 2020-04-26 | Larimer | Colorado | 8069 | 312 | 18 |
92742 | 92742 | 2020-04-27 | Larimer | Colorado | 8069 | 321 | 19 |
95574 | 95574 | 2020-04-28 | Larimer | Colorado | 8069 | 334 | 19 |
98419 | 98419 | 2020-04-29 | Larimer | Colorado | 8069 | 348 | 19 |
101269 | 101269 | 2020-04-30 | Larimer | Colorado | 8069 | 363 | 19 |
104124 | 104124 | 2020-05-01 | Larimer | Colorado | 8069 | 377 | 19 |
106989 | 106989 | 2020-05-02 | Larimer | Colorado | 8069 | 384 | 19 |
109858 | 109858 | 2020-05-03 | Larimer | Colorado | 8069 | 395 | 19 |
112733 | 112733 | 2020-05-04 | Larimer | Colorado | 8069 | 393 | 19 |
115616 | 115616 | 2020-05-05 | Larimer | Colorado | 8069 | 409 | 19 |
118575 | 118575 | 2020-05-06 | Larimer | Colorado | 8069 | 415 | 19 |
121544 | 121544 | 2020-05-07 | Larimer | Colorado | 8069 | 423 | 19 |
124524 | 124524 | 2020-05-08 | Larimer | Colorado | 8069 | 437 | 19 |
127510 | 127510 | 2020-05-09 | Larimer | Colorado | 8069 | 444 | 19 |
130501 | 130501 | 2020-05-10 | Larimer | Colorado | 8069 | 448 | 19 |
133492 | 133492 | 2020-05-11 | Larimer | Colorado | 8069 | 452 | 19 |
136481 | 136481 | 2020-05-12 | Larimer | Colorado | 8069 | 455 | 19 |
139472 | 139472 | 2020-05-13 | Larimer | Colorado | 8069 | 456 | 19 |
142468 | 142468 | 2020-05-14 | Larimer | Colorado | 8069 | 463 | 19 |
145468 | 145468 | 2020-05-15 | Larimer | Colorado | 8069 | 472 | 21 |
148471 | 148471 | 2020-05-16 | Larimer | Colorado | 8069 | 485 | 21 |
151480 | 151480 | 2020-05-17 | Larimer | Colorado | 8069 | 489 | 21 |
154492 | 154492 | 2020-05-18 | Larimer | Colorado | 8069 | 495 | 21 |
157508 | 157508 | 2020-05-19 | Larimer | Colorado | 8069 | 508 | 21 |
160534 | 160534 | 2020-05-20 | Larimer | Colorado | 8069 | 512 | 21 |
163562 | 163562 | 2020-05-21 | Larimer | Colorado | 8069 | 517 | 21 |
166595 | 166595 | 2020-05-22 | Larimer | Colorado | 8069 | 520 | 21 |
169632 | 169632 | 2020-05-23 | Larimer | Colorado | 8069 | 530 | 21 |
172673 | 172673 | 2020-05-24 | Larimer | Colorado | 8069 | 537 | 21 |
175717 | 175717 | 2020-05-25 | Larimer | Colorado | 8069 | 540 | 21 |
178761 | 178761 | 2020-05-26 | Larimer | Colorado | 8069 | 544 | 21 |
181805 | 181805 | 2020-05-27 | Larimer | Colorado | 8069 | 552 | 22 |
184859 | 184859 | 2020-05-28 | Larimer | Colorado | 8069 | 567 | 27 |
187915 | 187915 | 2020-05-29 | Larimer | Colorado | 8069 | 570 | 27 |
190980 | 190980 | 2020-05-30 | Larimer | Colorado | 8069 | 576 | 27 |
194047 | 194047 | 2020-05-31 | Larimer | Colorado | 8069 | 583 | 27 |
197117 | 197117 | 2020-06-01 | Larimer | Colorado | 8069 | 589 | 28 |
200190 | 200190 | 2020-06-02 | Larimer | Colorado | 8069 | 589 | 28 |
203266 | 203266 | 2020-06-03 | Larimer | Colorado | 8069 | 606 | 28 |
206346 | 206346 | 2020-06-04 | Larimer | Colorado | 8069 | 610 | 28 |
209427 | 209427 | 2020-06-05 | Larimer | Colorado | 8069 | 613 | 28 |
212512 | 212512 | 2020-06-06 | Larimer | Colorado | 8069 | 616 | 28 |
215599 | 215599 | 2020-06-07 | Larimer | Colorado | 8069 | 619 | 28 |
218690 | 218690 | 2020-06-08 | Larimer | Colorado | 8069 | 628 | 28 |
221785 | 221785 | 2020-06-09 | Larimer | Colorado | 8069 | 632 | 28 |
224880 | 224880 | 2020-06-10 | Larimer | Colorado | 8069 | 636 | 28 |
227982 | 227982 | 2020-06-11 | Larimer | Colorado | 8069 | 635 | 27 |
231085 | 231085 | 2020-06-12 | Larimer | Colorado | 8069 | 637 | 27 |
234191 | 234191 | 2020-06-13 | Larimer | Colorado | 8069 | 641 | 27 |
237298 | 237298 | 2020-06-14 | Larimer | Colorado | 8069 | 647 | 27 |
240406 | 240406 | 2020-06-15 | Larimer | Colorado | 8069 | 652 | 27 |
243517 | 243517 | 2020-06-16 | Larimer | Colorado | 8069 | 659 | 29 |
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);