ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "El Paso" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953156 | 953156 | 2021-01-22 | El Paso | Colorado | 8041 | 46597 | 680 |
949911 | 949911 | 2021-01-21 | El Paso | Colorado | 8041 | 46446 | 677 |
946665 | 946665 | 2021-01-20 | El Paso | Colorado | 8041 | 46258 | 675 |
943418 | 943418 | 2021-01-19 | El Paso | Colorado | 8041 | 46066 | 670 |
940173 | 940173 | 2021-01-18 | El Paso | Colorado | 8041 | 45889 | 672 |
936928 | 936928 | 2021-01-17 | El Paso | Colorado | 8041 | 45737 | 670 |
933683 | 933683 | 2021-01-16 | El Paso | Colorado | 8041 | 45658 | 668 |
930438 | 930438 | 2021-01-15 | El Paso | Colorado | 8041 | 45519 | 662 |
927193 | 927193 | 2021-01-14 | El Paso | Colorado | 8041 | 45285 | 656 |
923947 | 923947 | 2021-01-13 | El Paso | Colorado | 8041 | 45005 | 652 |
920702 | 920702 | 2021-01-12 | El Paso | Colorado | 8041 | 44713 | 651 |
917457 | 917457 | 2021-01-11 | El Paso | Colorado | 8041 | 44453 | 635 |
914212 | 914212 | 2021-01-10 | El Paso | Colorado | 8041 | 44263 | 630 |
910967 | 910967 | 2021-01-09 | El Paso | Colorado | 8041 | 44086 | 627 |
907722 | 907722 | 2021-01-08 | El Paso | Colorado | 8041 | 43827 | 624 |
904476 | 904476 | 2021-01-07 | El Paso | Colorado | 8041 | 43435 | 614 |
901231 | 901231 | 2021-01-06 | El Paso | Colorado | 8041 | 43037 | 606 |
897986 | 897986 | 2021-01-05 | El Paso | Colorado | 8041 | 42742 | 598 |
894741 | 894741 | 2021-01-04 | El Paso | Colorado | 8041 | 42447 | 585 |
891494 | 891494 | 2021-01-03 | El Paso | Colorado | 8041 | 42067 | 581 |
888247 | 888247 | 2021-01-02 | El Paso | Colorado | 8041 | 41838 | 571 |
885002 | 885002 | 2021-01-01 | El Paso | Colorado | 8041 | 41628 | 567 |
881757 | 881757 | 2020-12-31 | El Paso | Colorado | 8041 | 41325 | 555 |
878512 | 878512 | 2020-12-30 | El Paso | Colorado | 8041 | 41125 | 551 |
875267 | 875267 | 2020-12-29 | El Paso | Colorado | 8041 | 40493 | 543 |
872022 | 872022 | 2020-12-28 | El Paso | Colorado | 8041 | 40188 | 535 |
868777 | 868777 | 2020-12-27 | El Paso | Colorado | 8041 | 40005 | 533 |
865532 | 865532 | 2020-12-26 | El Paso | Colorado | 8041 | 39831 | 528 |
862287 | 862287 | 2020-12-25 | El Paso | Colorado | 8041 | 39754 | 528 |
859042 | 859042 | 2020-12-24 | El Paso | Colorado | 8041 | 39542 | 526 |
855797 | 855797 | 2020-12-23 | El Paso | Colorado | 8041 | 39075 | 515 |
852552 | 852552 | 2020-12-22 | El Paso | Colorado | 8041 | 38810 | 504 |
849307 | 849307 | 2020-12-21 | El Paso | Colorado | 8041 | 38362 | 491 |
846062 | 846062 | 2020-12-20 | El Paso | Colorado | 8041 | 37984 | 484 |
842816 | 842816 | 2020-12-19 | El Paso | Colorado | 8041 | 37777 | 483 |
839571 | 839571 | 2020-12-18 | El Paso | Colorado | 8041 | 37504 | 479 |
836326 | 836326 | 2020-12-17 | El Paso | Colorado | 8041 | 37096 | 465 |
833080 | 833080 | 2020-12-16 | El Paso | Colorado | 8041 | 36606 | 459 |
829833 | 829833 | 2020-12-15 | El Paso | Colorado | 8041 | 36282 | 456 |
826587 | 826587 | 2020-12-14 | El Paso | Colorado | 8041 | 35746 | 442 |
823340 | 823340 | 2020-12-13 | El Paso | Colorado | 8041 | 35359 | 431 |
820094 | 820094 | 2020-12-12 | El Paso | Colorado | 8041 | 35056 | 430 |
816848 | 816848 | 2020-12-11 | El Paso | Colorado | 8041 | 34714 | 413 |
813602 | 813602 | 2020-12-10 | El Paso | Colorado | 8041 | 34093 | 406 |
810358 | 810358 | 2020-12-09 | El Paso | Colorado | 8041 | 33545 | 386 |
807113 | 807113 | 2020-12-08 | El Paso | Colorado | 8041 | 32830 | 374 |
803868 | 803868 | 2020-12-07 | El Paso | Colorado | 8041 | 32245 | 351 |
800623 | 800623 | 2020-12-06 | El Paso | Colorado | 8041 | 31580 | 337 |
797378 | 797378 | 2020-12-05 | El Paso | Colorado | 8041 | 31111 | 337 |
794133 | 794133 | 2020-12-04 | El Paso | Colorado | 8041 | 30174 | 324 |
790888 | 790888 | 2020-12-03 | El Paso | Colorado | 8041 | 29999 | 317 |
787643 | 787643 | 2020-12-02 | El Paso | Colorado | 8041 | 29248 | 309 |
784399 | 784399 | 2020-12-01 | El Paso | Colorado | 8041 | 28238 | 293 |
781154 | 781154 | 2020-11-30 | El Paso | Colorado | 8041 | 27679 | 283 |
777908 | 777908 | 2020-11-29 | El Paso | Colorado | 8041 | 27010 | 271 |
774663 | 774663 | 2020-11-28 | El Paso | Colorado | 8041 | 26506 | 269 |
771418 | 771418 | 2020-11-27 | El Paso | Colorado | 8041 | 25946 | 267 |
768173 | 768173 | 2020-11-26 | El Paso | Colorado | 8041 | 25313 | 266 |
764927 | 764927 | 2020-11-25 | El Paso | Colorado | 8041 | 24567 | 265 |
761682 | 761682 | 2020-11-24 | El Paso | Colorado | 8041 | 23923 | 258 |
758437 | 758437 | 2020-11-23 | El Paso | Colorado | 8041 | 23402 | 255 |
755190 | 755190 | 2020-11-22 | El Paso | Colorado | 8041 | 22781 | 249 |
751944 | 751944 | 2020-11-21 | El Paso | Colorado | 8041 | 22424 | 249 |
748698 | 748698 | 2020-11-20 | El Paso | Colorado | 8041 | 21895 | 248 |
745452 | 745452 | 2020-11-19 | El Paso | Colorado | 8041 | 21110 | 243 |
742205 | 742205 | 2020-11-18 | El Paso | Colorado | 8041 | 20314 | 237 |
738958 | 738958 | 2020-11-17 | El Paso | Colorado | 8041 | 19751 | 232 |
735714 | 735714 | 2020-11-16 | El Paso | Colorado | 8041 | 19013 | 232 |
732468 | 732468 | 2020-11-15 | El Paso | Colorado | 8041 | 18399 | 225 |
729223 | 729223 | 2020-11-14 | El Paso | Colorado | 8041 | 18078 | 225 |
725980 | 725980 | 2020-11-13 | El Paso | Colorado | 8041 | 17603 | 224 |
722737 | 722737 | 2020-11-12 | El Paso | Colorado | 8041 | 17011 | 222 |
719494 | 719494 | 2020-11-11 | El Paso | Colorado | 8041 | 15987 | 216 |
716251 | 716251 | 2020-11-10 | El Paso | Colorado | 8041 | 15601 | 215 |
713007 | 713007 | 2020-11-09 | El Paso | Colorado | 8041 | 15098 | 214 |
709763 | 709763 | 2020-11-08 | El Paso | Colorado | 8041 | 14537 | 210 |
706519 | 706519 | 2020-11-07 | El Paso | Colorado | 8041 | 13954 | 210 |
703276 | 703276 | 2020-11-06 | El Paso | Colorado | 8041 | 13708 | 210 |
700033 | 700033 | 2020-11-05 | El Paso | Colorado | 8041 | 13245 | 209 |
696789 | 696789 | 2020-11-04 | El Paso | Colorado | 8041 | 12835 | 209 |
693547 | 693547 | 2020-11-03 | El Paso | Colorado | 8041 | 12335 | 208 |
690304 | 690304 | 2020-11-02 | El Paso | Colorado | 8041 | 11740 | 206 |
687059 | 687059 | 2020-11-01 | El Paso | Colorado | 8041 | 11360 | 205 |
683815 | 683815 | 2020-10-31 | El Paso | Colorado | 8041 | 11122 | 205 |
680572 | 680572 | 2020-10-30 | El Paso | Colorado | 8041 | 10821 | 205 |
677329 | 677329 | 2020-10-29 | El Paso | Colorado | 8041 | 10557 | 204 |
674086 | 674086 | 2020-10-28 | El Paso | Colorado | 8041 | 10325 | 201 |
670844 | 670844 | 2020-10-27 | El Paso | Colorado | 8041 | 10154 | 198 |
667601 | 667601 | 2020-10-26 | El Paso | Colorado | 8041 | 10031 | 196 |
664356 | 664356 | 2020-10-25 | El Paso | Colorado | 8041 | 9885 | 195 |
661112 | 661112 | 2020-10-24 | El Paso | Colorado | 8041 | 9726 | 195 |
657868 | 657868 | 2020-10-23 | El Paso | Colorado | 8041 | 9563 | 195 |
654623 | 654623 | 2020-10-22 | El Paso | Colorado | 8041 | 9342 | 195 |
651378 | 651378 | 2020-10-21 | El Paso | Colorado | 8041 | 9130 | 194 |
648134 | 648134 | 2020-10-20 | El Paso | Colorado | 8041 | 8907 | 193 |
644889 | 644889 | 2020-10-19 | El Paso | Colorado | 8041 | 8705 | 190 |
641641 | 641641 | 2020-10-18 | El Paso | Colorado | 8041 | 8537 | 188 |
638394 | 638394 | 2020-10-17 | El Paso | Colorado | 8041 | 8435 | 188 |
635149 | 635149 | 2020-10-16 | El Paso | Colorado | 8041 | 8352 | 188 |
631903 | 631903 | 2020-10-15 | El Paso | Colorado | 8041 | 8182 | 188 |
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);