ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Routt" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534720 | 534720 | 2020-09-15 | Routt | Colorado | 8107 | 139 | 8 |
531485 | 531485 | 2020-09-14 | Routt | Colorado | 8107 | 138 | 8 |
528248 | 528248 | 2020-09-13 | Routt | Colorado | 8107 | 138 | 8 |
525012 | 525012 | 2020-09-12 | Routt | Colorado | 8107 | 138 | 8 |
521776 | 521776 | 2020-09-11 | Routt | Colorado | 8107 | 136 | 8 |
518539 | 518539 | 2020-09-10 | Routt | Colorado | 8107 | 135 | 8 |
515304 | 515304 | 2020-09-09 | Routt | Colorado | 8107 | 135 | 8 |
512071 | 512071 | 2020-09-08 | Routt | Colorado | 8107 | 134 | 8 |
508838 | 508838 | 2020-09-07 | Routt | Colorado | 8107 | 134 | 8 |
505606 | 505606 | 2020-09-06 | Routt | Colorado | 8107 | 134 | 8 |
502372 | 502372 | 2020-09-05 | Routt | Colorado | 8107 | 134 | 8 |
499138 | 499138 | 2020-09-04 | Routt | Colorado | 8107 | 135 | 8 |
495905 | 495905 | 2020-09-03 | Routt | Colorado | 8107 | 135 | 8 |
492671 | 492671 | 2020-09-02 | Routt | Colorado | 8107 | 134 | 8 |
489438 | 489438 | 2020-09-01 | Routt | Colorado | 8107 | 134 | 8 |
486205 | 486205 | 2020-08-31 | Routt | Colorado | 8107 | 134 | 8 |
482970 | 482970 | 2020-08-30 | Routt | Colorado | 8107 | 132 | 8 |
479736 | 479736 | 2020-08-29 | Routt | Colorado | 8107 | 132 | 8 |
476503 | 476503 | 2020-08-28 | Routt | Colorado | 8107 | 132 | 8 |
473270 | 473270 | 2020-08-27 | Routt | Colorado | 8107 | 132 | 8 |
470038 | 470038 | 2020-08-26 | Routt | Colorado | 8107 | 132 | 8 |
466809 | 466809 | 2020-08-25 | Routt | Colorado | 8107 | 131 | 8 |
463580 | 463580 | 2020-08-24 | Routt | Colorado | 8107 | 131 | 8 |
460351 | 460351 | 2020-08-23 | Routt | Colorado | 8107 | 131 | 8 |
457124 | 457124 | 2020-08-22 | Routt | Colorado | 8107 | 131 | 8 |
453896 | 453896 | 2020-08-21 | Routt | Colorado | 8107 | 131 | 8 |
450668 | 450668 | 2020-08-20 | Routt | Colorado | 8107 | 131 | 8 |
447440 | 447440 | 2020-08-19 | Routt | Colorado | 8107 | 129 | 8 |
444213 | 444213 | 2020-08-18 | Routt | Colorado | 8107 | 129 | 8 |
440987 | 440987 | 2020-08-17 | Routt | Colorado | 8107 | 128 | 8 |
437761 | 437761 | 2020-08-16 | Routt | Colorado | 8107 | 127 | 8 |
434535 | 434535 | 2020-08-15 | Routt | Colorado | 8107 | 127 | 8 |
431310 | 431310 | 2020-08-14 | Routt | Colorado | 8107 | 125 | 8 |
428082 | 428082 | 2020-08-13 | Routt | Colorado | 8107 | 124 | 8 |
424858 | 424858 | 2020-08-12 | Routt | Colorado | 8107 | 124 | 8 |
421637 | 421637 | 2020-08-11 | Routt | Colorado | 8107 | 125 | 8 |
418416 | 418416 | 2020-08-10 | Routt | Colorado | 8107 | 125 | 8 |
415195 | 415195 | 2020-08-09 | Routt | Colorado | 8107 | 125 | 8 |
411975 | 411975 | 2020-08-08 | Routt | Colorado | 8107 | 122 | 7 |
408756 | 408756 | 2020-08-07 | Routt | Colorado | 8107 | 117 | 7 |
405536 | 405536 | 2020-08-06 | Routt | Colorado | 8107 | 111 | 6 |
402318 | 402318 | 2020-08-05 | Routt | Colorado | 8107 | 110 | 6 |
399102 | 399102 | 2020-08-04 | Routt | Colorado | 8107 | 110 | 6 |
395886 | 395886 | 2020-08-03 | Routt | Colorado | 8107 | 108 | 6 |
392670 | 392670 | 2020-08-02 | Routt | Colorado | 8107 | 107 | 6 |
389453 | 389453 | 2020-08-01 | Routt | Colorado | 8107 | 106 | 6 |
386236 | 386236 | 2020-07-31 | Routt | Colorado | 8107 | 99 | 6 |
383018 | 383018 | 2020-07-30 | Routt | Colorado | 8107 | 98 | 6 |
379801 | 379801 | 2020-07-29 | Routt | Colorado | 8107 | 96 | 6 |
376584 | 376584 | 2020-07-28 | Routt | Colorado | 8107 | 96 | 6 |
373370 | 373370 | 2020-07-27 | Routt | Colorado | 8107 | 95 | 6 |
370158 | 370158 | 2020-07-26 | Routt | Colorado | 8107 | 94 | 6 |
366948 | 366948 | 2020-07-25 | Routt | Colorado | 8107 | 94 | 6 |
363741 | 363741 | 2020-07-24 | Routt | Colorado | 8107 | 94 | 6 |
360534 | 360534 | 2020-07-23 | Routt | Colorado | 8107 | 94 | 6 |
357329 | 357329 | 2020-07-22 | Routt | Colorado | 8107 | 93 | 6 |
354126 | 354126 | 2020-07-21 | Routt | Colorado | 8107 | 91 | 6 |
350924 | 350924 | 2020-07-20 | Routt | Colorado | 8107 | 87 | 6 |
347723 | 347723 | 2020-07-19 | Routt | Colorado | 8107 | 87 | 6 |
344523 | 344523 | 2020-07-18 | Routt | Colorado | 8107 | 87 | 6 |
341324 | 341324 | 2020-07-17 | Routt | Colorado | 8107 | 85 | 6 |
338127 | 338127 | 2020-07-16 | Routt | Colorado | 8107 | 86 | 6 |
334932 | 334932 | 2020-07-15 | Routt | Colorado | 8107 | 86 | 6 |
331739 | 331739 | 2020-07-14 | Routt | Colorado | 8107 | 84 | 6 |
328553 | 328553 | 2020-07-13 | Routt | Colorado | 8107 | 84 | 6 |
325367 | 325367 | 2020-07-12 | Routt | Colorado | 8107 | 82 | 6 |
322186 | 322186 | 2020-07-11 | Routt | Colorado | 8107 | 81 | 6 |
319007 | 319007 | 2020-07-10 | Routt | Colorado | 8107 | 81 | 6 |
315834 | 315834 | 2020-07-09 | Routt | Colorado | 8107 | 79 | 6 |
312659 | 312659 | 2020-07-08 | Routt | Colorado | 8107 | 79 | 6 |
309489 | 309489 | 2020-07-07 | Routt | Colorado | 8107 | 78 | 6 |
306321 | 306321 | 2020-07-06 | Routt | Colorado | 8107 | 78 | 6 |
303157 | 303157 | 2020-07-05 | Routt | Colorado | 8107 | 77 | 6 |
299993 | 299993 | 2020-07-04 | Routt | Colorado | 8107 | 77 | 6 |
296831 | 296831 | 2020-07-03 | Routt | Colorado | 8107 | 76 | 6 |
293675 | 293675 | 2020-07-02 | Routt | Colorado | 8107 | 75 | 6 |
290521 | 290521 | 2020-07-01 | Routt | Colorado | 8107 | 75 | 6 |
287370 | 287370 | 2020-06-30 | Routt | Colorado | 8107 | 73 | 6 |
284224 | 284224 | 2020-06-29 | Routt | Colorado | 8107 | 73 | 6 |
281078 | 281078 | 2020-06-28 | Routt | Colorado | 8107 | 72 | 6 |
277931 | 277931 | 2020-06-27 | Routt | Colorado | 8107 | 71 | 6 |
274783 | 274783 | 2020-06-26 | Routt | Colorado | 8107 | 70 | 6 |
271643 | 271643 | 2020-06-25 | Routt | Colorado | 8107 | 69 | 6 |
268507 | 268507 | 2020-06-24 | Routt | Colorado | 8107 | 67 | 6 |
265377 | 265377 | 2020-06-23 | Routt | Colorado | 8107 | 67 | 6 |
262249 | 262249 | 2020-06-22 | Routt | Colorado | 8107 | 65 | 6 |
259122 | 259122 | 2020-06-21 | Routt | Colorado | 8107 | 64 | 6 |
255995 | 255995 | 2020-06-20 | Routt | Colorado | 8107 | 63 | 6 |
252876 | 252876 | 2020-06-19 | Routt | Colorado | 8107 | 63 | 6 |
249761 | 249761 | 2020-06-18 | Routt | Colorado | 8107 | 63 | 6 |
246649 | 246649 | 2020-06-17 | Routt | Colorado | 8107 | 63 | 6 |
243536 | 243536 | 2020-06-16 | Routt | Colorado | 8107 | 63 | 6 |
240425 | 240425 | 2020-06-15 | Routt | Colorado | 8107 | 63 | 6 |
237317 | 237317 | 2020-06-14 | Routt | Colorado | 8107 | 64 | 6 |
234210 | 234210 | 2020-06-13 | Routt | Colorado | 8107 | 64 | 6 |
231104 | 231104 | 2020-06-12 | Routt | Colorado | 8107 | 64 | 6 |
228001 | 228001 | 2020-06-11 | Routt | Colorado | 8107 | 64 | 6 |
224899 | 224899 | 2020-06-10 | Routt | Colorado | 8107 | 63 | 6 |
221804 | 221804 | 2020-06-09 | Routt | Colorado | 8107 | 62 | 6 |
218709 | 218709 | 2020-06-08 | Routt | Colorado | 8107 | 62 | 6 |
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);