ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Washington" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920743 | 920743 | 2021-01-12 | Washington | Colorado | 8121 | 354 | 11 |
917498 | 917498 | 2021-01-11 | Washington | Colorado | 8121 | 352 | 11 |
914253 | 914253 | 2021-01-10 | Washington | Colorado | 8121 | 352 | 11 |
911008 | 911008 | 2021-01-09 | Washington | Colorado | 8121 | 351 | 11 |
907763 | 907763 | 2021-01-08 | Washington | Colorado | 8121 | 351 | 11 |
904517 | 904517 | 2021-01-07 | Washington | Colorado | 8121 | 350 | 11 |
901272 | 901272 | 2021-01-06 | Washington | Colorado | 8121 | 349 | 11 |
898027 | 898027 | 2021-01-05 | Washington | Colorado | 8121 | 349 | 11 |
894782 | 894782 | 2021-01-04 | Washington | Colorado | 8121 | 349 | 11 |
891535 | 891535 | 2021-01-03 | Washington | Colorado | 8121 | 349 | 11 |
888288 | 888288 | 2021-01-02 | Washington | Colorado | 8121 | 349 | 11 |
885043 | 885043 | 2021-01-01 | Washington | Colorado | 8121 | 347 | 11 |
881798 | 881798 | 2020-12-31 | Washington | Colorado | 8121 | 347 | 10 |
878553 | 878553 | 2020-12-30 | Washington | Colorado | 8121 | 346 | 10 |
875308 | 875308 | 2020-12-29 | Washington | Colorado | 8121 | 344 | 10 |
872063 | 872063 | 2020-12-28 | Washington | Colorado | 8121 | 341 | 10 |
868818 | 868818 | 2020-12-27 | Washington | Colorado | 8121 | 340 | 10 |
865573 | 865573 | 2020-12-26 | Washington | Colorado | 8121 | 340 | 10 |
862328 | 862328 | 2020-12-25 | Washington | Colorado | 8121 | 340 | 10 |
859083 | 859083 | 2020-12-24 | Washington | Colorado | 8121 | 339 | 10 |
855838 | 855838 | 2020-12-23 | Washington | Colorado | 8121 | 338 | 10 |
852593 | 852593 | 2020-12-22 | Washington | Colorado | 8121 | 337 | 10 |
849348 | 849348 | 2020-12-21 | Washington | Colorado | 8121 | 335 | 10 |
846103 | 846103 | 2020-12-20 | Washington | Colorado | 8121 | 333 | 10 |
842857 | 842857 | 2020-12-19 | Washington | Colorado | 8121 | 328 | 10 |
839612 | 839612 | 2020-12-18 | Washington | Colorado | 8121 | 327 | 10 |
836367 | 836367 | 2020-12-17 | Washington | Colorado | 8121 | 326 | 10 |
833121 | 833121 | 2020-12-16 | Washington | Colorado | 8121 | 302 | 10 |
829874 | 829874 | 2020-12-15 | Washington | Colorado | 8121 | 299 | 10 |
826628 | 826628 | 2020-12-14 | Washington | Colorado | 8121 | 299 | 10 |
823381 | 823381 | 2020-12-13 | Washington | Colorado | 8121 | 299 | 10 |
820135 | 820135 | 2020-12-12 | Washington | Colorado | 8121 | 298 | 9 |
816889 | 816889 | 2020-12-11 | Washington | Colorado | 8121 | 300 | 9 |
813643 | 813643 | 2020-12-10 | Washington | Colorado | 8121 | 299 | 9 |
810399 | 810399 | 2020-12-09 | Washington | Colorado | 8121 | 293 | 9 |
807154 | 807154 | 2020-12-08 | Washington | Colorado | 8121 | 293 | 9 |
803909 | 803909 | 2020-12-07 | Washington | Colorado | 8121 | 292 | 9 |
800664 | 800664 | 2020-12-06 | Washington | Colorado | 8121 | 290 | 9 |
797419 | 797419 | 2020-12-05 | Washington | Colorado | 8121 | 290 | 9 |
794174 | 794174 | 2020-12-04 | Washington | Colorado | 8121 | 288 | 9 |
790929 | 790929 | 2020-12-03 | Washington | Colorado | 8121 | 258 | 9 |
787684 | 787684 | 2020-12-02 | Washington | Colorado | 8121 | 257 | 9 |
784440 | 784440 | 2020-12-01 | Washington | Colorado | 8121 | 251 | 9 |
781195 | 781195 | 2020-11-30 | Washington | Colorado | 8121 | 235 | 7 |
777949 | 777949 | 2020-11-29 | Washington | Colorado | 8121 | 222 | 6 |
774704 | 774704 | 2020-11-28 | Washington | Colorado | 8121 | 216 | 6 |
771459 | 771459 | 2020-11-27 | Washington | Colorado | 8121 | 206 | 6 |
768214 | 768214 | 2020-11-26 | Washington | Colorado | 8121 | 204 | 6 |
764968 | 764968 | 2020-11-25 | Washington | Colorado | 8121 | 201 | 6 |
761723 | 761723 | 2020-11-24 | Washington | Colorado | 8121 | 199 | 5 |
758478 | 758478 | 2020-11-23 | Washington | Colorado | 8121 | 187 | 5 |
755231 | 755231 | 2020-11-22 | Washington | Colorado | 8121 | 186 | 5 |
751985 | 751985 | 2020-11-21 | Washington | Colorado | 8121 | 185 | 5 |
748739 | 748739 | 2020-11-20 | Washington | Colorado | 8121 | 182 | 5 |
745493 | 745493 | 2020-11-19 | Washington | Colorado | 8121 | 173 | 5 |
742246 | 742246 | 2020-11-18 | Washington | Colorado | 8121 | 170 | 4 |
738999 | 738999 | 2020-11-17 | Washington | Colorado | 8121 | 165 | 3 |
735755 | 735755 | 2020-11-16 | Washington | Colorado | 8121 | 156 | 3 |
732509 | 732509 | 2020-11-15 | Washington | Colorado | 8121 | 153 | 2 |
729264 | 729264 | 2020-11-14 | Washington | Colorado | 8121 | 150 | 2 |
726021 | 726021 | 2020-11-13 | Washington | Colorado | 8121 | 146 | 1 |
722778 | 722778 | 2020-11-12 | Washington | Colorado | 8121 | 139 | 1 |
719535 | 719535 | 2020-11-11 | Washington | Colorado | 8121 | 136 | 1 |
716292 | 716292 | 2020-11-10 | Washington | Colorado | 8121 | 128 | 1 |
713048 | 713048 | 2020-11-09 | Washington | Colorado | 8121 | 129 | 1 |
709804 | 709804 | 2020-11-08 | Washington | Colorado | 8121 | 127 | 1 |
706560 | 706560 | 2020-11-07 | Washington | Colorado | 8121 | 126 | 1 |
703317 | 703317 | 2020-11-06 | Washington | Colorado | 8121 | 127 | 1 |
700074 | 700074 | 2020-11-05 | Washington | Colorado | 8121 | 124 | 1 |
696830 | 696830 | 2020-11-04 | Washington | Colorado | 8121 | 111 | 1 |
693588 | 693588 | 2020-11-03 | Washington | Colorado | 8121 | 110 | 0 |
690345 | 690345 | 2020-11-02 | Washington | Colorado | 8121 | 110 | 0 |
687100 | 687100 | 2020-11-01 | Washington | Colorado | 8121 | 106 | 0 |
683856 | 683856 | 2020-10-31 | Washington | Colorado | 8121 | 106 | 0 |
680613 | 680613 | 2020-10-30 | Washington | Colorado | 8121 | 104 | 0 |
677370 | 677370 | 2020-10-29 | Washington | Colorado | 8121 | 102 | 0 |
674127 | 674127 | 2020-10-28 | Washington | Colorado | 8121 | 102 | 0 |
670885 | 670885 | 2020-10-27 | Washington | Colorado | 8121 | 96 | 0 |
667642 | 667642 | 2020-10-26 | Washington | Colorado | 8121 | 96 | 0 |
664397 | 664397 | 2020-10-25 | Washington | Colorado | 8121 | 94 | 0 |
661153 | 661153 | 2020-10-24 | Washington | Colorado | 8121 | 93 | 0 |
657909 | 657909 | 2020-10-23 | Washington | Colorado | 8121 | 85 | 0 |
654664 | 654664 | 2020-10-22 | Washington | Colorado | 8121 | 83 | 0 |
651419 | 651419 | 2020-10-21 | Washington | Colorado | 8121 | 82 | 0 |
648175 | 648175 | 2020-10-20 | Washington | Colorado | 8121 | 78 | 0 |
644930 | 644930 | 2020-10-19 | Washington | Colorado | 8121 | 78 | 0 |
641682 | 641682 | 2020-10-18 | Washington | Colorado | 8121 | 78 | 0 |
638435 | 638435 | 2020-10-17 | Washington | Colorado | 8121 | 78 | 0 |
635190 | 635190 | 2020-10-16 | Washington | Colorado | 8121 | 78 | 0 |
631944 | 631944 | 2020-10-15 | Washington | Colorado | 8121 | 77 | 0 |
628700 | 628700 | 2020-10-14 | Washington | Colorado | 8121 | 74 | 0 |
625457 | 625457 | 2020-10-13 | Washington | Colorado | 8121 | 74 | 0 |
622214 | 622214 | 2020-10-12 | Washington | Colorado | 8121 | 73 | 0 |
618971 | 618971 | 2020-10-11 | Washington | Colorado | 8121 | 73 | 0 |
615729 | 615729 | 2020-10-10 | Washington | Colorado | 8121 | 72 | 0 |
612488 | 612488 | 2020-10-09 | Washington | Colorado | 8121 | 71 | 0 |
609246 | 609246 | 2020-10-08 | Washington | Colorado | 8121 | 69 | 0 |
606003 | 606003 | 2020-10-07 | Washington | Colorado | 8121 | 69 | 0 |
602761 | 602761 | 2020-10-06 | Washington | Colorado | 8121 | 69 | 0 |
599518 | 599518 | 2020-10-05 | Washington | Colorado | 8121 | 68 | 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);