ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Douglas" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635147 | 635147 | 2020-10-16 | Douglas | Colorado | 8035 | 3335 | 63 |
631901 | 631901 | 2020-10-15 | Douglas | Colorado | 8035 | 3297 | 63 |
628657 | 628657 | 2020-10-14 | Douglas | Colorado | 8035 | 3241 | 63 |
625414 | 625414 | 2020-10-13 | Douglas | Colorado | 8035 | 3208 | 63 |
622171 | 622171 | 2020-10-12 | Douglas | Colorado | 8035 | 3178 | 63 |
618928 | 618928 | 2020-10-11 | Douglas | Colorado | 8035 | 3125 | 63 |
615686 | 615686 | 2020-10-10 | Douglas | Colorado | 8035 | 3110 | 63 |
612445 | 612445 | 2020-10-09 | Douglas | Colorado | 8035 | 3063 | 63 |
609203 | 609203 | 2020-10-08 | Douglas | Colorado | 8035 | 3028 | 63 |
605960 | 605960 | 2020-10-07 | Douglas | Colorado | 8035 | 3000 | 61 |
602718 | 602718 | 2020-10-06 | Douglas | Colorado | 8035 | 2971 | 61 |
599475 | 599475 | 2020-10-05 | Douglas | Colorado | 8035 | 2947 | 61 |
596232 | 596232 | 2020-10-04 | Douglas | Colorado | 8035 | 2916 | 61 |
592990 | 592990 | 2020-10-03 | Douglas | Colorado | 8035 | 2897 | 61 |
589750 | 589750 | 2020-10-02 | Douglas | Colorado | 8035 | 2882 | 61 |
586509 | 586509 | 2020-10-01 | Douglas | Colorado | 8035 | 2834 | 61 |
583269 | 583269 | 2020-09-30 | Douglas | Colorado | 8035 | 2803 | 61 |
580030 | 580030 | 2020-09-29 | Douglas | Colorado | 8035 | 2773 | 61 |
576789 | 576789 | 2020-09-28 | Douglas | Colorado | 8035 | 2741 | 60 |
573546 | 573546 | 2020-09-27 | Douglas | Colorado | 8035 | 2708 | 60 |
570304 | 570304 | 2020-09-26 | Douglas | Colorado | 8035 | 2686 | 60 |
567062 | 567062 | 2020-09-25 | Douglas | Colorado | 8035 | 2658 | 60 |
563822 | 563822 | 2020-09-24 | Douglas | Colorado | 8035 | 2614 | 60 |
560583 | 560583 | 2020-09-23 | Douglas | Colorado | 8035 | 2591 | 60 |
557347 | 557347 | 2020-09-22 | Douglas | Colorado | 8035 | 2555 | 60 |
554110 | 554110 | 2020-09-21 | Douglas | Colorado | 8035 | 2525 | 60 |
550871 | 550871 | 2020-09-20 | Douglas | Colorado | 8035 | 2477 | 60 |
547632 | 547632 | 2020-09-19 | Douglas | Colorado | 8035 | 2468 | 60 |
544394 | 544394 | 2020-09-18 | Douglas | Colorado | 8035 | 2453 | 60 |
541158 | 541158 | 2020-09-17 | Douglas | Colorado | 8035 | 2405 | 60 |
537921 | 537921 | 2020-09-16 | Douglas | Colorado | 8035 | 2370 | 60 |
534685 | 534685 | 2020-09-15 | Douglas | Colorado | 8035 | 2350 | 60 |
531450 | 531450 | 2020-09-14 | Douglas | Colorado | 8035 | 2326 | 60 |
528213 | 528213 | 2020-09-13 | Douglas | Colorado | 8035 | 2312 | 60 |
524977 | 524977 | 2020-09-12 | Douglas | Colorado | 8035 | 2299 | 60 |
521741 | 521741 | 2020-09-11 | Douglas | Colorado | 8035 | 2287 | 60 |
518504 | 518504 | 2020-09-10 | Douglas | Colorado | 8035 | 2277 | 60 |
515269 | 515269 | 2020-09-09 | Douglas | Colorado | 8035 | 2255 | 60 |
512036 | 512036 | 2020-09-08 | Douglas | Colorado | 8035 | 2243 | 60 |
508803 | 508803 | 2020-09-07 | Douglas | Colorado | 8035 | 2223 | 60 |
505571 | 505571 | 2020-09-06 | Douglas | Colorado | 8035 | 2205 | 60 |
502337 | 502337 | 2020-09-05 | Douglas | Colorado | 8035 | 2197 | 60 |
499103 | 499103 | 2020-09-04 | Douglas | Colorado | 8035 | 2179 | 60 |
495870 | 495870 | 2020-09-03 | Douglas | Colorado | 8035 | 2157 | 60 |
492636 | 492636 | 2020-09-02 | Douglas | Colorado | 8035 | 2135 | 60 |
489403 | 489403 | 2020-09-01 | Douglas | Colorado | 8035 | 2118 | 60 |
486170 | 486170 | 2020-08-31 | Douglas | Colorado | 8035 | 2103 | 60 |
482935 | 482935 | 2020-08-30 | Douglas | Colorado | 8035 | 2088 | 60 |
479701 | 479701 | 2020-08-29 | Douglas | Colorado | 8035 | 2078 | 60 |
476468 | 476468 | 2020-08-28 | Douglas | Colorado | 8035 | 2078 | 60 |
473235 | 473235 | 2020-08-27 | Douglas | Colorado | 8035 | 2057 | 60 |
470003 | 470003 | 2020-08-26 | Douglas | Colorado | 8035 | 2042 | 60 |
466774 | 466774 | 2020-08-25 | Douglas | Colorado | 8035 | 2031 | 60 |
463545 | 463545 | 2020-08-24 | Douglas | Colorado | 8035 | 2011 | 59 |
460316 | 460316 | 2020-08-23 | Douglas | Colorado | 8035 | 1997 | 59 |
457089 | 457089 | 2020-08-22 | Douglas | Colorado | 8035 | 1894 | 59 |
453861 | 453861 | 2020-08-21 | Douglas | Colorado | 8035 | 1889 | 59 |
450633 | 450633 | 2020-08-20 | Douglas | Colorado | 8035 | 1876 | 59 |
447405 | 447405 | 2020-08-19 | Douglas | Colorado | 8035 | 1862 | 59 |
444178 | 444178 | 2020-08-18 | Douglas | Colorado | 8035 | 1849 | 59 |
440952 | 440952 | 2020-08-17 | Douglas | Colorado | 8035 | 1840 | 59 |
437726 | 437726 | 2020-08-16 | Douglas | Colorado | 8035 | 1833 | 59 |
434500 | 434500 | 2020-08-15 | Douglas | Colorado | 8035 | 1817 | 59 |
431275 | 431275 | 2020-08-14 | Douglas | Colorado | 8035 | 1803 | 59 |
428047 | 428047 | 2020-08-13 | Douglas | Colorado | 8035 | 1788 | 59 |
424823 | 424823 | 2020-08-12 | Douglas | Colorado | 8035 | 1765 | 59 |
421602 | 421602 | 2020-08-11 | Douglas | Colorado | 8035 | 1759 | 59 |
418381 | 418381 | 2020-08-10 | Douglas | Colorado | 8035 | 1744 | 59 |
415160 | 415160 | 2020-08-09 | Douglas | Colorado | 8035 | 1734 | 59 |
411940 | 411940 | 2020-08-08 | Douglas | Colorado | 8035 | 1726 | 59 |
408721 | 408721 | 2020-08-07 | Douglas | Colorado | 8035 | 1718 | 59 |
405501 | 405501 | 2020-08-06 | Douglas | Colorado | 8035 | 1702 | 59 |
402283 | 402283 | 2020-08-05 | Douglas | Colorado | 8035 | 1689 | 59 |
399067 | 399067 | 2020-08-04 | Douglas | Colorado | 8035 | 1670 | 59 |
395851 | 395851 | 2020-08-03 | Douglas | Colorado | 8035 | 1653 | 59 |
392635 | 392635 | 2020-08-02 | Douglas | Colorado | 8035 | 1647 | 59 |
389418 | 389418 | 2020-08-01 | Douglas | Colorado | 8035 | 1624 | 59 |
386201 | 386201 | 2020-07-31 | Douglas | Colorado | 8035 | 1616 | 58 |
382983 | 382983 | 2020-07-30 | Douglas | Colorado | 8035 | 1594 | 58 |
379766 | 379766 | 2020-07-29 | Douglas | Colorado | 8035 | 1577 | 58 |
376549 | 376549 | 2020-07-28 | Douglas | Colorado | 8035 | 1558 | 56 |
373335 | 373335 | 2020-07-27 | Douglas | Colorado | 8035 | 1529 | 56 |
370123 | 370123 | 2020-07-26 | Douglas | Colorado | 8035 | 1519 | 56 |
366913 | 366913 | 2020-07-25 | Douglas | Colorado | 8035 | 1494 | 56 |
363706 | 363706 | 2020-07-24 | Douglas | Colorado | 8035 | 1462 | 56 |
360499 | 360499 | 2020-07-23 | Douglas | Colorado | 8035 | 1433 | 55 |
357294 | 357294 | 2020-07-22 | Douglas | Colorado | 8035 | 1410 | 54 |
354091 | 354091 | 2020-07-21 | Douglas | Colorado | 8035 | 1377 | 54 |
350889 | 350889 | 2020-07-20 | Douglas | Colorado | 8035 | 1357 | 54 |
347688 | 347688 | 2020-07-19 | Douglas | Colorado | 8035 | 1331 | 54 |
344488 | 344488 | 2020-07-18 | Douglas | Colorado | 8035 | 1310 | 54 |
341289 | 341289 | 2020-07-17 | Douglas | Colorado | 8035 | 1293 | 54 |
338092 | 338092 | 2020-07-16 | Douglas | Colorado | 8035 | 1263 | 54 |
334897 | 334897 | 2020-07-15 | Douglas | Colorado | 8035 | 1224 | 54 |
331704 | 331704 | 2020-07-14 | Douglas | Colorado | 8035 | 1201 | 53 |
328518 | 328518 | 2020-07-13 | Douglas | Colorado | 8035 | 1178 | 52 |
325332 | 325332 | 2020-07-12 | Douglas | Colorado | 8035 | 1161 | 52 |
322151 | 322151 | 2020-07-11 | Douglas | Colorado | 8035 | 1134 | 52 |
318972 | 318972 | 2020-07-10 | Douglas | Colorado | 8035 | 1120 | 52 |
315799 | 315799 | 2020-07-09 | Douglas | Colorado | 8035 | 1078 | 52 |
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);