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 |
---|---|---|---|---|---|---|---|
1053770 | 1053770 | 2021-02-22 | El Paso | Colorado | 8041 | 51145 | 742 |
1050523 | 1050523 | 2021-02-21 | El Paso | Colorado | 8041 | 50951 | 741 |
1047276 | 1047276 | 2021-02-20 | El Paso | Colorado | 8041 | 50831 | 741 |
1044031 | 1044031 | 2021-02-19 | El Paso | Colorado | 8041 | 50710 | 740 |
1040786 | 1040786 | 2021-02-18 | El Paso | Colorado | 8041 | 50561 | 736 |
1037541 | 1037541 | 2021-02-17 | El Paso | Colorado | 8041 | 50379 | 731 |
1034296 | 1034296 | 2021-02-16 | El Paso | Colorado | 8041 | 50188 | 728 |
1031050 | 1031050 | 2021-02-15 | El Paso | Colorado | 8041 | 50029 | 728 |
1027803 | 1027803 | 2021-02-14 | El Paso | Colorado | 8041 | 49978 | 728 |
1024558 | 1024558 | 2021-02-13 | El Paso | Colorado | 8041 | 49854 | 727 |
1021313 | 1021313 | 2021-02-12 | El Paso | Colorado | 8041 | 49727 | 725 |
1018068 | 1018068 | 2021-02-11 | El Paso | Colorado | 8041 | 49536 | 725 |
1014823 | 1014823 | 2021-02-10 | El Paso | Colorado | 8041 | 49302 | 722 |
1011578 | 1011578 | 2021-02-09 | El Paso | Colorado | 8041 | 49154 | 721 |
1008332 | 1008332 | 2021-02-08 | El Paso | Colorado | 8041 | 49042 | 718 |
1005086 | 1005086 | 2021-02-07 | El Paso | Colorado | 8041 | 48851 | 716 |
1001840 | 1001840 | 2021-02-06 | El Paso | Colorado | 8041 | 48740 | 716 |
998594 | 998594 | 2021-02-05 | El Paso | Colorado | 8041 | 48555 | 715 |
995348 | 995348 | 2021-02-04 | El Paso | Colorado | 8041 | 48383 | 712 |
992102 | 992102 | 2021-02-03 | El Paso | Colorado | 8041 | 48185 | 706 |
988856 | 988856 | 2021-02-02 | El Paso | Colorado | 8041 | 48003 | 705 |
985609 | 985609 | 2021-02-01 | El Paso | Colorado | 8041 | 47890 | 705 |
982362 | 982362 | 2021-01-31 | El Paso | Colorado | 8041 | 47796 | 696 |
979116 | 979116 | 2021-01-30 | El Paso | Colorado | 8041 | 47732 | 696 |
975871 | 975871 | 2021-01-29 | El Paso | Colorado | 8041 | 47614 | 696 |
972626 | 972626 | 2021-01-28 | El Paso | Colorado | 8041 | 47432 | 696 |
969381 | 969381 | 2021-01-27 | El Paso | Colorado | 8041 | 47280 | 692 |
966137 | 966137 | 2021-01-26 | El Paso | Colorado | 8041 | 47195 | 684 |
962892 | 962892 | 2021-01-25 | El Paso | Colorado | 8041 | 47025 | 685 |
959647 | 959647 | 2021-01-24 | El Paso | Colorado | 8041 | 46875 | 685 |
956401 | 956401 | 2021-01-23 | El Paso | Colorado | 8041 | 46718 | 681 |
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 |
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);