ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,352 rows where county = "Douglas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
234176 | 234176 | 2020-06-13 | Douglas | Colorado | 8035 | 794 | 49 |
237283 | 237283 | 2020-06-14 | Douglas | Colorado | 8035 | 801 | 49 |
240391 | 240391 | 2020-06-15 | Douglas | Colorado | 8035 | 807 | 49 |
243502 | 243502 | 2020-06-16 | Douglas | Colorado | 8035 | 815 | 50 |
246615 | 246615 | 2020-06-17 | Douglas | Colorado | 8035 | 820 | 50 |
249727 | 249727 | 2020-06-18 | Douglas | Colorado | 8035 | 825 | 50 |
252842 | 252842 | 2020-06-19 | Douglas | Colorado | 8035 | 831 | 51 |
255961 | 255961 | 2020-06-20 | Douglas | Colorado | 8035 | 839 | 51 |
259088 | 259088 | 2020-06-21 | Douglas | Colorado | 8035 | 852 | 51 |
262215 | 262215 | 2020-06-22 | Douglas | Colorado | 8035 | 864 | 51 |
265343 | 265343 | 2020-06-23 | Douglas | Colorado | 8035 | 869 | 51 |
268473 | 268473 | 2020-06-24 | Douglas | Colorado | 8035 | 873 | 52 |
271608 | 271608 | 2020-06-25 | Douglas | Colorado | 8035 | 895 | 52 |
274748 | 274748 | 2020-06-26 | Douglas | Colorado | 8035 | 911 | 52 |
277896 | 277896 | 2020-06-27 | Douglas | Colorado | 8035 | 922 | 52 |
281043 | 281043 | 2020-06-28 | Douglas | Colorado | 8035 | 939 | 52 |
284189 | 284189 | 2020-06-29 | Douglas | Colorado | 8035 | 946 | 52 |
287335 | 287335 | 2020-06-30 | Douglas | Colorado | 8035 | 951 | 52 |
290486 | 290486 | 2020-07-01 | Douglas | Colorado | 8035 | 964 | 52 |
293640 | 293640 | 2020-07-02 | Douglas | Colorado | 8035 | 984 | 52 |
296796 | 296796 | 2020-07-03 | Douglas | Colorado | 8035 | 993 | 52 |
299958 | 299958 | 2020-07-04 | Douglas | Colorado | 8035 | 1006 | 52 |
303122 | 303122 | 2020-07-05 | Douglas | Colorado | 8035 | 1013 | 52 |
306286 | 306286 | 2020-07-06 | Douglas | Colorado | 8035 | 1019 | 52 |
309454 | 309454 | 2020-07-07 | Douglas | Colorado | 8035 | 1042 | 52 |
312624 | 312624 | 2020-07-08 | Douglas | Colorado | 8035 | 1056 | 52 |
315799 | 315799 | 2020-07-09 | Douglas | Colorado | 8035 | 1078 | 52 |
318972 | 318972 | 2020-07-10 | Douglas | Colorado | 8035 | 1120 | 52 |
322151 | 322151 | 2020-07-11 | Douglas | Colorado | 8035 | 1134 | 52 |
325332 | 325332 | 2020-07-12 | Douglas | Colorado | 8035 | 1161 | 52 |
328518 | 328518 | 2020-07-13 | Douglas | Colorado | 8035 | 1178 | 52 |
331704 | 331704 | 2020-07-14 | Douglas | Colorado | 8035 | 1201 | 53 |
334897 | 334897 | 2020-07-15 | Douglas | Colorado | 8035 | 1224 | 54 |
338092 | 338092 | 2020-07-16 | Douglas | Colorado | 8035 | 1263 | 54 |
341289 | 341289 | 2020-07-17 | Douglas | Colorado | 8035 | 1293 | 54 |
344488 | 344488 | 2020-07-18 | Douglas | Colorado | 8035 | 1310 | 54 |
347688 | 347688 | 2020-07-19 | Douglas | Colorado | 8035 | 1331 | 54 |
350889 | 350889 | 2020-07-20 | Douglas | Colorado | 8035 | 1357 | 54 |
354091 | 354091 | 2020-07-21 | Douglas | Colorado | 8035 | 1377 | 54 |
357294 | 357294 | 2020-07-22 | Douglas | Colorado | 8035 | 1410 | 54 |
360499 | 360499 | 2020-07-23 | Douglas | Colorado | 8035 | 1433 | 55 |
363706 | 363706 | 2020-07-24 | Douglas | Colorado | 8035 | 1462 | 56 |
366913 | 366913 | 2020-07-25 | Douglas | Colorado | 8035 | 1494 | 56 |
370123 | 370123 | 2020-07-26 | Douglas | Colorado | 8035 | 1519 | 56 |
373335 | 373335 | 2020-07-27 | Douglas | Colorado | 8035 | 1529 | 56 |
376549 | 376549 | 2020-07-28 | Douglas | Colorado | 8035 | 1558 | 56 |
379766 | 379766 | 2020-07-29 | Douglas | Colorado | 8035 | 1577 | 58 |
382983 | 382983 | 2020-07-30 | Douglas | Colorado | 8035 | 1594 | 58 |
386201 | 386201 | 2020-07-31 | Douglas | Colorado | 8035 | 1616 | 58 |
389418 | 389418 | 2020-08-01 | Douglas | Colorado | 8035 | 1624 | 59 |
392635 | 392635 | 2020-08-02 | Douglas | Colorado | 8035 | 1647 | 59 |
395851 | 395851 | 2020-08-03 | Douglas | Colorado | 8035 | 1653 | 59 |
399067 | 399067 | 2020-08-04 | Douglas | Colorado | 8035 | 1670 | 59 |
402283 | 402283 | 2020-08-05 | Douglas | Colorado | 8035 | 1689 | 59 |
405501 | 405501 | 2020-08-06 | Douglas | Colorado | 8035 | 1702 | 59 |
408721 | 408721 | 2020-08-07 | Douglas | Colorado | 8035 | 1718 | 59 |
411940 | 411940 | 2020-08-08 | Douglas | Colorado | 8035 | 1726 | 59 |
415160 | 415160 | 2020-08-09 | Douglas | Colorado | 8035 | 1734 | 59 |
418381 | 418381 | 2020-08-10 | Douglas | Colorado | 8035 | 1744 | 59 |
421602 | 421602 | 2020-08-11 | Douglas | Colorado | 8035 | 1759 | 59 |
424823 | 424823 | 2020-08-12 | Douglas | Colorado | 8035 | 1765 | 59 |
428047 | 428047 | 2020-08-13 | Douglas | Colorado | 8035 | 1788 | 59 |
431275 | 431275 | 2020-08-14 | Douglas | Colorado | 8035 | 1803 | 59 |
434500 | 434500 | 2020-08-15 | Douglas | Colorado | 8035 | 1817 | 59 |
437726 | 437726 | 2020-08-16 | Douglas | Colorado | 8035 | 1833 | 59 |
440952 | 440952 | 2020-08-17 | Douglas | Colorado | 8035 | 1840 | 59 |
444178 | 444178 | 2020-08-18 | Douglas | Colorado | 8035 | 1849 | 59 |
447405 | 447405 | 2020-08-19 | Douglas | Colorado | 8035 | 1862 | 59 |
450633 | 450633 | 2020-08-20 | Douglas | Colorado | 8035 | 1876 | 59 |
453861 | 453861 | 2020-08-21 | Douglas | Colorado | 8035 | 1889 | 59 |
457089 | 457089 | 2020-08-22 | Douglas | Colorado | 8035 | 1894 | 59 |
460316 | 460316 | 2020-08-23 | Douglas | Colorado | 8035 | 1997 | 59 |
463545 | 463545 | 2020-08-24 | Douglas | Colorado | 8035 | 2011 | 59 |
466774 | 466774 | 2020-08-25 | Douglas | Colorado | 8035 | 2031 | 60 |
470003 | 470003 | 2020-08-26 | Douglas | Colorado | 8035 | 2042 | 60 |
473235 | 473235 | 2020-08-27 | Douglas | Colorado | 8035 | 2057 | 60 |
476468 | 476468 | 2020-08-28 | Douglas | Colorado | 8035 | 2078 | 60 |
479701 | 479701 | 2020-08-29 | Douglas | Colorado | 8035 | 2078 | 60 |
482935 | 482935 | 2020-08-30 | Douglas | Colorado | 8035 | 2088 | 60 |
486170 | 486170 | 2020-08-31 | Douglas | Colorado | 8035 | 2103 | 60 |
489403 | 489403 | 2020-09-01 | Douglas | Colorado | 8035 | 2118 | 60 |
492636 | 492636 | 2020-09-02 | Douglas | Colorado | 8035 | 2135 | 60 |
495870 | 495870 | 2020-09-03 | Douglas | Colorado | 8035 | 2157 | 60 |
499103 | 499103 | 2020-09-04 | Douglas | Colorado | 8035 | 2179 | 60 |
502337 | 502337 | 2020-09-05 | Douglas | Colorado | 8035 | 2197 | 60 |
505571 | 505571 | 2020-09-06 | Douglas | Colorado | 8035 | 2205 | 60 |
508803 | 508803 | 2020-09-07 | Douglas | Colorado | 8035 | 2223 | 60 |
512036 | 512036 | 2020-09-08 | Douglas | Colorado | 8035 | 2243 | 60 |
515269 | 515269 | 2020-09-09 | Douglas | Colorado | 8035 | 2255 | 60 |
518504 | 518504 | 2020-09-10 | Douglas | Colorado | 8035 | 2277 | 60 |
521741 | 521741 | 2020-09-11 | Douglas | Colorado | 8035 | 2287 | 60 |
524977 | 524977 | 2020-09-12 | Douglas | Colorado | 8035 | 2299 | 60 |
528213 | 528213 | 2020-09-13 | Douglas | Colorado | 8035 | 2312 | 60 |
531450 | 531450 | 2020-09-14 | Douglas | Colorado | 8035 | 2326 | 60 |
534685 | 534685 | 2020-09-15 | Douglas | Colorado | 8035 | 2350 | 60 |
537921 | 537921 | 2020-09-16 | Douglas | Colorado | 8035 | 2370 | 60 |
541158 | 541158 | 2020-09-17 | Douglas | Colorado | 8035 | 2405 | 60 |
544394 | 544394 | 2020-09-18 | Douglas | Colorado | 8035 | 2453 | 60 |
547632 | 547632 | 2020-09-19 | Douglas | Colorado | 8035 | 2468 | 60 |
550871 | 550871 | 2020-09-20 | Douglas | Colorado | 8035 | 2477 | 60 |
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);