ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
189 rows where deaths = 0, fips = 8125 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
557391 | 557391 | 2020-09-22 | Yuma | Colorado | 8125 | 91 | 0 |
554154 | 554154 | 2020-09-21 | Yuma | Colorado | 8125 | 88 | 0 |
550915 | 550915 | 2020-09-20 | Yuma | Colorado | 8125 | 87 | 0 |
547676 | 547676 | 2020-09-19 | Yuma | Colorado | 8125 | 84 | 0 |
544438 | 544438 | 2020-09-18 | Yuma | Colorado | 8125 | 84 | 0 |
541202 | 541202 | 2020-09-17 | Yuma | Colorado | 8125 | 84 | 0 |
537965 | 537965 | 2020-09-16 | Yuma | Colorado | 8125 | 76 | 0 |
534729 | 534729 | 2020-09-15 | Yuma | Colorado | 8125 | 75 | 0 |
531494 | 531494 | 2020-09-14 | Yuma | Colorado | 8125 | 72 | 0 |
528257 | 528257 | 2020-09-13 | Yuma | Colorado | 8125 | 72 | 0 |
525021 | 525021 | 2020-09-12 | Yuma | Colorado | 8125 | 70 | 0 |
521785 | 521785 | 2020-09-11 | Yuma | Colorado | 8125 | 70 | 0 |
518548 | 518548 | 2020-09-10 | Yuma | Colorado | 8125 | 71 | 0 |
515313 | 515313 | 2020-09-09 | Yuma | Colorado | 8125 | 71 | 0 |
512080 | 512080 | 2020-09-08 | Yuma | Colorado | 8125 | 68 | 0 |
508847 | 508847 | 2020-09-07 | Yuma | Colorado | 8125 | 68 | 0 |
505615 | 505615 | 2020-09-06 | Yuma | Colorado | 8125 | 67 | 0 |
502381 | 502381 | 2020-09-05 | Yuma | Colorado | 8125 | 67 | 0 |
499147 | 499147 | 2020-09-04 | Yuma | Colorado | 8125 | 65 | 0 |
495914 | 495914 | 2020-09-03 | Yuma | Colorado | 8125 | 65 | 0 |
492680 | 492680 | 2020-09-02 | Yuma | Colorado | 8125 | 64 | 0 |
489447 | 489447 | 2020-09-01 | Yuma | Colorado | 8125 | 63 | 0 |
486214 | 486214 | 2020-08-31 | Yuma | Colorado | 8125 | 63 | 0 |
482979 | 482979 | 2020-08-30 | Yuma | Colorado | 8125 | 63 | 0 |
479745 | 479745 | 2020-08-29 | Yuma | Colorado | 8125 | 63 | 0 |
476512 | 476512 | 2020-08-28 | Yuma | Colorado | 8125 | 63 | 0 |
473279 | 473279 | 2020-08-27 | Yuma | Colorado | 8125 | 63 | 0 |
470047 | 470047 | 2020-08-26 | Yuma | Colorado | 8125 | 63 | 0 |
466818 | 466818 | 2020-08-25 | Yuma | Colorado | 8125 | 63 | 0 |
463589 | 463589 | 2020-08-24 | Yuma | Colorado | 8125 | 63 | 0 |
460360 | 460360 | 2020-08-23 | Yuma | Colorado | 8125 | 63 | 0 |
457133 | 457133 | 2020-08-22 | Yuma | Colorado | 8125 | 63 | 0 |
453905 | 453905 | 2020-08-21 | Yuma | Colorado | 8125 | 63 | 0 |
450677 | 450677 | 2020-08-20 | Yuma | Colorado | 8125 | 63 | 0 |
447449 | 447449 | 2020-08-19 | Yuma | Colorado | 8125 | 63 | 0 |
444222 | 444222 | 2020-08-18 | Yuma | Colorado | 8125 | 63 | 0 |
440996 | 440996 | 2020-08-17 | Yuma | Colorado | 8125 | 63 | 0 |
437770 | 437770 | 2020-08-16 | Yuma | Colorado | 8125 | 63 | 0 |
434544 | 434544 | 2020-08-15 | Yuma | Colorado | 8125 | 63 | 0 |
431319 | 431319 | 2020-08-14 | Yuma | Colorado | 8125 | 63 | 0 |
428091 | 428091 | 2020-08-13 | Yuma | Colorado | 8125 | 63 | 0 |
424867 | 424867 | 2020-08-12 | Yuma | Colorado | 8125 | 63 | 0 |
421646 | 421646 | 2020-08-11 | Yuma | Colorado | 8125 | 63 | 0 |
418425 | 418425 | 2020-08-10 | Yuma | Colorado | 8125 | 63 | 0 |
415204 | 415204 | 2020-08-09 | Yuma | Colorado | 8125 | 63 | 0 |
411984 | 411984 | 2020-08-08 | Yuma | Colorado | 8125 | 63 | 0 |
408765 | 408765 | 2020-08-07 | Yuma | Colorado | 8125 | 63 | 0 |
405545 | 405545 | 2020-08-06 | Yuma | Colorado | 8125 | 63 | 0 |
402327 | 402327 | 2020-08-05 | Yuma | Colorado | 8125 | 63 | 0 |
399111 | 399111 | 2020-08-04 | Yuma | Colorado | 8125 | 62 | 0 |
395895 | 395895 | 2020-08-03 | Yuma | Colorado | 8125 | 62 | 0 |
392679 | 392679 | 2020-08-02 | Yuma | Colorado | 8125 | 62 | 0 |
389462 | 389462 | 2020-08-01 | Yuma | Colorado | 8125 | 62 | 0 |
386245 | 386245 | 2020-07-31 | Yuma | Colorado | 8125 | 62 | 0 |
383027 | 383027 | 2020-07-30 | Yuma | Colorado | 8125 | 57 | 0 |
379810 | 379810 | 2020-07-29 | Yuma | Colorado | 8125 | 57 | 0 |
376593 | 376593 | 2020-07-28 | Yuma | Colorado | 8125 | 57 | 0 |
373379 | 373379 | 2020-07-27 | Yuma | Colorado | 8125 | 57 | 0 |
370167 | 370167 | 2020-07-26 | Yuma | Colorado | 8125 | 57 | 0 |
366957 | 366957 | 2020-07-25 | Yuma | Colorado | 8125 | 57 | 0 |
363750 | 363750 | 2020-07-24 | Yuma | Colorado | 8125 | 56 | 0 |
360543 | 360543 | 2020-07-23 | Yuma | Colorado | 8125 | 56 | 0 |
357338 | 357338 | 2020-07-22 | Yuma | Colorado | 8125 | 56 | 0 |
354135 | 354135 | 2020-07-21 | Yuma | Colorado | 8125 | 56 | 0 |
350933 | 350933 | 2020-07-20 | Yuma | Colorado | 8125 | 56 | 0 |
347732 | 347732 | 2020-07-19 | Yuma | Colorado | 8125 | 56 | 0 |
344532 | 344532 | 2020-07-18 | Yuma | Colorado | 8125 | 55 | 0 |
341333 | 341333 | 2020-07-17 | Yuma | Colorado | 8125 | 55 | 0 |
338136 | 338136 | 2020-07-16 | Yuma | Colorado | 8125 | 55 | 0 |
334941 | 334941 | 2020-07-15 | Yuma | Colorado | 8125 | 55 | 0 |
331748 | 331748 | 2020-07-14 | Yuma | Colorado | 8125 | 54 | 0 |
328561 | 328561 | 2020-07-13 | Yuma | Colorado | 8125 | 54 | 0 |
325375 | 325375 | 2020-07-12 | Yuma | Colorado | 8125 | 54 | 0 |
322194 | 322194 | 2020-07-11 | Yuma | Colorado | 8125 | 54 | 0 |
319015 | 319015 | 2020-07-10 | Yuma | Colorado | 8125 | 54 | 0 |
315842 | 315842 | 2020-07-09 | Yuma | Colorado | 8125 | 54 | 0 |
312667 | 312667 | 2020-07-08 | Yuma | Colorado | 8125 | 54 | 0 |
309497 | 309497 | 2020-07-07 | Yuma | Colorado | 8125 | 53 | 0 |
306329 | 306329 | 2020-07-06 | Yuma | Colorado | 8125 | 53 | 0 |
303165 | 303165 | 2020-07-05 | Yuma | Colorado | 8125 | 53 | 0 |
300001 | 300001 | 2020-07-04 | Yuma | Colorado | 8125 | 53 | 0 |
296839 | 296839 | 2020-07-03 | Yuma | Colorado | 8125 | 52 | 0 |
293683 | 293683 | 2020-07-02 | Yuma | Colorado | 8125 | 52 | 0 |
290529 | 290529 | 2020-07-01 | Yuma | Colorado | 8125 | 52 | 0 |
287378 | 287378 | 2020-06-30 | Yuma | Colorado | 8125 | 52 | 0 |
284232 | 284232 | 2020-06-29 | Yuma | Colorado | 8125 | 52 | 0 |
281086 | 281086 | 2020-06-28 | Yuma | Colorado | 8125 | 51 | 0 |
277939 | 277939 | 2020-06-27 | Yuma | Colorado | 8125 | 51 | 0 |
274791 | 274791 | 2020-06-26 | Yuma | Colorado | 8125 | 51 | 0 |
271651 | 271651 | 2020-06-25 | Yuma | Colorado | 8125 | 51 | 0 |
268515 | 268515 | 2020-06-24 | Yuma | Colorado | 8125 | 51 | 0 |
265385 | 265385 | 2020-06-23 | Yuma | Colorado | 8125 | 50 | 0 |
262257 | 262257 | 2020-06-22 | Yuma | Colorado | 8125 | 50 | 0 |
259130 | 259130 | 2020-06-21 | Yuma | Colorado | 8125 | 50 | 0 |
256003 | 256003 | 2020-06-20 | Yuma | Colorado | 8125 | 49 | 0 |
252884 | 252884 | 2020-06-19 | Yuma | Colorado | 8125 | 49 | 0 |
249769 | 249769 | 2020-06-18 | Yuma | Colorado | 8125 | 49 | 0 |
246657 | 246657 | 2020-06-17 | Yuma | Colorado | 8125 | 49 | 0 |
243544 | 243544 | 2020-06-16 | Yuma | Colorado | 8125 | 49 | 0 |
240433 | 240433 | 2020-06-15 | Yuma | Colorado | 8125 | 49 | 0 |
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);