ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Boulder" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635135 | 635135 | 2020-10-16 | Boulder | Colorado | 8013 | 4998 | 84 |
631889 | 631889 | 2020-10-15 | Boulder | Colorado | 8013 | 4954 | 83 |
628645 | 628645 | 2020-10-14 | Boulder | Colorado | 8013 | 4910 | 83 |
625402 | 625402 | 2020-10-13 | Boulder | Colorado | 8013 | 4884 | 83 |
622159 | 622159 | 2020-10-12 | Boulder | Colorado | 8013 | 4845 | 82 |
618916 | 618916 | 2020-10-11 | Boulder | Colorado | 8013 | 4835 | 82 |
615674 | 615674 | 2020-10-10 | Boulder | Colorado | 8013 | 4823 | 82 |
612433 | 612433 | 2020-10-09 | Boulder | Colorado | 8013 | 4784 | 82 |
609191 | 609191 | 2020-10-08 | Boulder | Colorado | 8013 | 4748 | 81 |
605948 | 605948 | 2020-10-07 | Boulder | Colorado | 8013 | 4717 | 81 |
602706 | 602706 | 2020-10-06 | Boulder | Colorado | 8013 | 4675 | 81 |
599463 | 599463 | 2020-10-05 | Boulder | Colorado | 8013 | 4658 | 81 |
596220 | 596220 | 2020-10-04 | Boulder | Colorado | 8013 | 4612 | 81 |
592978 | 592978 | 2020-10-03 | Boulder | Colorado | 8013 | 4612 | 80 |
589738 | 589738 | 2020-10-02 | Boulder | Colorado | 8013 | 4573 | 80 |
586497 | 586497 | 2020-10-01 | Boulder | Colorado | 8013 | 4545 | 80 |
583257 | 583257 | 2020-09-30 | Boulder | Colorado | 8013 | 4512 | 80 |
580018 | 580018 | 2020-09-29 | Boulder | Colorado | 8013 | 4452 | 79 |
576777 | 576777 | 2020-09-28 | Boulder | Colorado | 8013 | 4416 | 79 |
573534 | 573534 | 2020-09-27 | Boulder | Colorado | 8013 | 4375 | 79 |
570292 | 570292 | 2020-09-26 | Boulder | Colorado | 8013 | 4319 | 79 |
567050 | 567050 | 2020-09-25 | Boulder | Colorado | 8013 | 4270 | 79 |
563810 | 563810 | 2020-09-24 | Boulder | Colorado | 8013 | 4145 | 79 |
560571 | 560571 | 2020-09-23 | Boulder | Colorado | 8013 | 4049 | 79 |
557335 | 557335 | 2020-09-22 | Boulder | Colorado | 8013 | 3963 | 79 |
554098 | 554098 | 2020-09-21 | Boulder | Colorado | 8013 | 3753 | 79 |
550859 | 550859 | 2020-09-20 | Boulder | Colorado | 8013 | 3573 | 79 |
547620 | 547620 | 2020-09-19 | Boulder | Colorado | 8013 | 3349 | 79 |
544382 | 544382 | 2020-09-18 | Boulder | Colorado | 8013 | 3309 | 79 |
541146 | 541146 | 2020-09-17 | Boulder | Colorado | 8013 | 3134 | 79 |
537909 | 537909 | 2020-09-16 | Boulder | Colorado | 8013 | 3060 | 79 |
534673 | 534673 | 2020-09-15 | Boulder | Colorado | 8013 | 2989 | 79 |
531438 | 531438 | 2020-09-14 | Boulder | Colorado | 8013 | 2877 | 79 |
528201 | 528201 | 2020-09-13 | Boulder | Colorado | 8013 | 2794 | 79 |
524965 | 524965 | 2020-09-12 | Boulder | Colorado | 8013 | 2759 | 79 |
521729 | 521729 | 2020-09-11 | Boulder | Colorado | 8013 | 2671 | 79 |
518492 | 518492 | 2020-09-10 | Boulder | Colorado | 8013 | 2621 | 79 |
515257 | 515257 | 2020-09-09 | Boulder | Colorado | 8013 | 2574 | 79 |
512024 | 512024 | 2020-09-08 | Boulder | Colorado | 8013 | 2502 | 79 |
508791 | 508791 | 2020-09-07 | Boulder | Colorado | 8013 | 2482 | 79 |
505559 | 505559 | 2020-09-06 | Boulder | Colorado | 8013 | 2478 | 79 |
502325 | 502325 | 2020-09-05 | Boulder | Colorado | 8013 | 2413 | 79 |
499091 | 499091 | 2020-09-04 | Boulder | Colorado | 8013 | 2399 | 79 |
495858 | 495858 | 2020-09-03 | Boulder | Colorado | 8013 | 2361 | 79 |
492624 | 492624 | 2020-09-02 | Boulder | Colorado | 8013 | 2344 | 79 |
489391 | 489391 | 2020-09-01 | Boulder | Colorado | 8013 | 2324 | 79 |
486158 | 486158 | 2020-08-31 | Boulder | Colorado | 8013 | 2316 | 79 |
482923 | 482923 | 2020-08-30 | Boulder | Colorado | 8013 | 2295 | 79 |
479689 | 479689 | 2020-08-29 | Boulder | Colorado | 8013 | 2289 | 79 |
476456 | 476456 | 2020-08-28 | Boulder | Colorado | 8013 | 2283 | 79 |
473223 | 473223 | 2020-08-27 | Boulder | Colorado | 8013 | 2271 | 79 |
469991 | 469991 | 2020-08-26 | Boulder | Colorado | 8013 | 2256 | 79 |
466762 | 466762 | 2020-08-25 | Boulder | Colorado | 8013 | 2250 | 79 |
463533 | 463533 | 2020-08-24 | Boulder | Colorado | 8013 | 2239 | 79 |
460304 | 460304 | 2020-08-23 | Boulder | Colorado | 8013 | 2225 | 79 |
457077 | 457077 | 2020-08-22 | Boulder | Colorado | 8013 | 2215 | 79 |
453849 | 453849 | 2020-08-21 | Boulder | Colorado | 8013 | 2201 | 79 |
450621 | 450621 | 2020-08-20 | Boulder | Colorado | 8013 | 2186 | 78 |
447393 | 447393 | 2020-08-19 | Boulder | Colorado | 8013 | 2177 | 78 |
444166 | 444166 | 2020-08-18 | Boulder | Colorado | 8013 | 2153 | 78 |
440940 | 440940 | 2020-08-17 | Boulder | Colorado | 8013 | 2141 | 77 |
437714 | 437714 | 2020-08-16 | Boulder | Colorado | 8013 | 2146 | 77 |
434488 | 434488 | 2020-08-15 | Boulder | Colorado | 8013 | 2141 | 77 |
431263 | 431263 | 2020-08-14 | Boulder | Colorado | 8013 | 2137 | 76 |
428035 | 428035 | 2020-08-13 | Boulder | Colorado | 8013 | 2130 | 76 |
424811 | 424811 | 2020-08-12 | Boulder | Colorado | 8013 | 2120 | 76 |
421590 | 421590 | 2020-08-11 | Boulder | Colorado | 8013 | 2105 | 76 |
418369 | 418369 | 2020-08-10 | Boulder | Colorado | 8013 | 2086 | 74 |
415148 | 415148 | 2020-08-09 | Boulder | Colorado | 8013 | 2070 | 74 |
411928 | 411928 | 2020-08-08 | Boulder | Colorado | 8013 | 2054 | 74 |
408709 | 408709 | 2020-08-07 | Boulder | Colorado | 8013 | 2049 | 75 |
405489 | 405489 | 2020-08-06 | Boulder | Colorado | 8013 | 2031 | 75 |
402271 | 402271 | 2020-08-05 | Boulder | Colorado | 8013 | 2015 | 75 |
399055 | 399055 | 2020-08-04 | Boulder | Colorado | 8013 | 1969 | 75 |
395839 | 395839 | 2020-08-03 | Boulder | Colorado | 8013 | 1962 | 75 |
392623 | 392623 | 2020-08-02 | Boulder | Colorado | 8013 | 1938 | 75 |
389406 | 389406 | 2020-08-01 | Boulder | Colorado | 8013 | 1905 | 75 |
386189 | 386189 | 2020-07-31 | Boulder | Colorado | 8013 | 1890 | 75 |
382971 | 382971 | 2020-07-30 | Boulder | Colorado | 8013 | 1864 | 75 |
379754 | 379754 | 2020-07-29 | Boulder | Colorado | 8013 | 1839 | 75 |
376537 | 376537 | 2020-07-28 | Boulder | Colorado | 8013 | 1825 | 74 |
373323 | 373323 | 2020-07-27 | Boulder | Colorado | 8013 | 1802 | 74 |
370111 | 370111 | 2020-07-26 | Boulder | Colorado | 8013 | 1787 | 74 |
366901 | 366901 | 2020-07-25 | Boulder | Colorado | 8013 | 1775 | 74 |
363694 | 363694 | 2020-07-24 | Boulder | Colorado | 8013 | 1757 | 74 |
360487 | 360487 | 2020-07-23 | Boulder | Colorado | 8013 | 1716 | 74 |
357282 | 357282 | 2020-07-22 | Boulder | Colorado | 8013 | 1702 | 74 |
354079 | 354079 | 2020-07-21 | Boulder | Colorado | 8013 | 1682 | 74 |
350877 | 350877 | 2020-07-20 | Boulder | Colorado | 8013 | 1669 | 74 |
347676 | 347676 | 2020-07-19 | Boulder | Colorado | 8013 | 1653 | 74 |
344476 | 344476 | 2020-07-18 | Boulder | Colorado | 8013 | 1643 | 74 |
341277 | 341277 | 2020-07-17 | Boulder | Colorado | 8013 | 1638 | 74 |
338081 | 338081 | 2020-07-16 | Boulder | Colorado | 8013 | 1618 | 74 |
334886 | 334886 | 2020-07-15 | Boulder | Colorado | 8013 | 1595 | 74 |
331693 | 331693 | 2020-07-14 | Boulder | Colorado | 8013 | 1572 | 74 |
328507 | 328507 | 2020-07-13 | Boulder | Colorado | 8013 | 1542 | 73 |
325321 | 325321 | 2020-07-12 | Boulder | Colorado | 8013 | 1527 | 73 |
322140 | 322140 | 2020-07-11 | Boulder | Colorado | 8013 | 1522 | 73 |
318961 | 318961 | 2020-07-10 | Boulder | Colorado | 8013 | 1503 | 73 |
315788 | 315788 | 2020-07-09 | Boulder | Colorado | 8013 | 1492 | 72 |
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);