ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Kit Carson" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953168 | 953168 | 2021-01-22 | Kit Carson | Colorado | 8063 | 496 | 10 |
949923 | 949923 | 2021-01-21 | Kit Carson | Colorado | 8063 | 483 | 10 |
946677 | 946677 | 2021-01-20 | Kit Carson | Colorado | 8063 | 479 | 10 |
943430 | 943430 | 2021-01-19 | Kit Carson | Colorado | 8063 | 477 | 10 |
940185 | 940185 | 2021-01-18 | Kit Carson | Colorado | 8063 | 476 | 10 |
936940 | 936940 | 2021-01-17 | Kit Carson | Colorado | 8063 | 475 | 10 |
933695 | 933695 | 2021-01-16 | Kit Carson | Colorado | 8063 | 474 | 10 |
930450 | 930450 | 2021-01-15 | Kit Carson | Colorado | 8063 | 474 | 10 |
927205 | 927205 | 2021-01-14 | Kit Carson | Colorado | 8063 | 469 | 10 |
923959 | 923959 | 2021-01-13 | Kit Carson | Colorado | 8063 | 465 | 10 |
920714 | 920714 | 2021-01-12 | Kit Carson | Colorado | 8063 | 459 | 10 |
917469 | 917469 | 2021-01-11 | Kit Carson | Colorado | 8063 | 458 | 10 |
914224 | 914224 | 2021-01-10 | Kit Carson | Colorado | 8063 | 457 | 10 |
910979 | 910979 | 2021-01-09 | Kit Carson | Colorado | 8063 | 456 | 10 |
907734 | 907734 | 2021-01-08 | Kit Carson | Colorado | 8063 | 455 | 10 |
904488 | 904488 | 2021-01-07 | Kit Carson | Colorado | 8063 | 450 | 10 |
901243 | 901243 | 2021-01-06 | Kit Carson | Colorado | 8063 | 445 | 10 |
897998 | 897998 | 2021-01-05 | Kit Carson | Colorado | 8063 | 445 | 10 |
894753 | 894753 | 2021-01-04 | Kit Carson | Colorado | 8063 | 438 | 10 |
891506 | 891506 | 2021-01-03 | Kit Carson | Colorado | 8063 | 438 | 9 |
888259 | 888259 | 2021-01-02 | Kit Carson | Colorado | 8063 | 438 | 9 |
885014 | 885014 | 2021-01-01 | Kit Carson | Colorado | 8063 | 438 | 9 |
881769 | 881769 | 2020-12-31 | Kit Carson | Colorado | 8063 | 436 | 9 |
878524 | 878524 | 2020-12-30 | Kit Carson | Colorado | 8063 | 432 | 9 |
875279 | 875279 | 2020-12-29 | Kit Carson | Colorado | 8063 | 432 | 9 |
872034 | 872034 | 2020-12-28 | Kit Carson | Colorado | 8063 | 430 | 9 |
868789 | 868789 | 2020-12-27 | Kit Carson | Colorado | 8063 | 430 | 9 |
865544 | 865544 | 2020-12-26 | Kit Carson | Colorado | 8063 | 430 | 9 |
862299 | 862299 | 2020-12-25 | Kit Carson | Colorado | 8063 | 430 | 9 |
859054 | 859054 | 2020-12-24 | Kit Carson | Colorado | 8063 | 428 | 8 |
855809 | 855809 | 2020-12-23 | Kit Carson | Colorado | 8063 | 429 | 8 |
852564 | 852564 | 2020-12-22 | Kit Carson | Colorado | 8063 | 425 | 8 |
849319 | 849319 | 2020-12-21 | Kit Carson | Colorado | 8063 | 418 | 8 |
846074 | 846074 | 2020-12-20 | Kit Carson | Colorado | 8063 | 418 | 8 |
842828 | 842828 | 2020-12-19 | Kit Carson | Colorado | 8063 | 416 | 8 |
839583 | 839583 | 2020-12-18 | Kit Carson | Colorado | 8063 | 410 | 8 |
836338 | 836338 | 2020-12-17 | Kit Carson | Colorado | 8063 | 405 | 8 |
833092 | 833092 | 2020-12-16 | Kit Carson | Colorado | 8063 | 402 | 8 |
829845 | 829845 | 2020-12-15 | Kit Carson | Colorado | 8063 | 397 | 8 |
826599 | 826599 | 2020-12-14 | Kit Carson | Colorado | 8063 | 390 | 8 |
823352 | 823352 | 2020-12-13 | Kit Carson | Colorado | 8063 | 390 | 8 |
820106 | 820106 | 2020-12-12 | Kit Carson | Colorado | 8063 | 389 | 8 |
816860 | 816860 | 2020-12-11 | Kit Carson | Colorado | 8063 | 379 | 8 |
813614 | 813614 | 2020-12-10 | Kit Carson | Colorado | 8063 | 368 | 8 |
810370 | 810370 | 2020-12-09 | Kit Carson | Colorado | 8063 | 358 | 8 |
807125 | 807125 | 2020-12-08 | Kit Carson | Colorado | 8063 | 343 | 8 |
803880 | 803880 | 2020-12-07 | Kit Carson | Colorado | 8063 | 336 | 8 |
800635 | 800635 | 2020-12-06 | Kit Carson | Colorado | 8063 | 336 | 8 |
797390 | 797390 | 2020-12-05 | Kit Carson | Colorado | 8063 | 336 | 8 |
794145 | 794145 | 2020-12-04 | Kit Carson | Colorado | 8063 | 329 | 8 |
790900 | 790900 | 2020-12-03 | Kit Carson | Colorado | 8063 | 324 | 8 |
787655 | 787655 | 2020-12-02 | Kit Carson | Colorado | 8063 | 312 | 8 |
784411 | 784411 | 2020-12-01 | Kit Carson | Colorado | 8063 | 303 | 8 |
781166 | 781166 | 2020-11-30 | Kit Carson | Colorado | 8063 | 301 | 7 |
777920 | 777920 | 2020-11-29 | Kit Carson | Colorado | 8063 | 301 | 7 |
774675 | 774675 | 2020-11-28 | Kit Carson | Colorado | 8063 | 300 | 7 |
771430 | 771430 | 2020-11-27 | Kit Carson | Colorado | 8063 | 298 | 7 |
768185 | 768185 | 2020-11-26 | Kit Carson | Colorado | 8063 | 293 | 7 |
764939 | 764939 | 2020-11-25 | Kit Carson | Colorado | 8063 | 262 | 7 |
761694 | 761694 | 2020-11-24 | Kit Carson | Colorado | 8063 | 251 | 7 |
758449 | 758449 | 2020-11-23 | Kit Carson | Colorado | 8063 | 251 | 7 |
755202 | 755202 | 2020-11-22 | Kit Carson | Colorado | 8063 | 250 | 7 |
751956 | 751956 | 2020-11-21 | Kit Carson | Colorado | 8063 | 250 | 5 |
748710 | 748710 | 2020-11-20 | Kit Carson | Colorado | 8063 | 247 | 3 |
745464 | 745464 | 2020-11-19 | Kit Carson | Colorado | 8063 | 242 | 3 |
742217 | 742217 | 2020-11-18 | Kit Carson | Colorado | 8063 | 240 | 3 |
738970 | 738970 | 2020-11-17 | Kit Carson | Colorado | 8063 | 236 | 3 |
735726 | 735726 | 2020-11-16 | Kit Carson | Colorado | 8063 | 237 | 3 |
732480 | 732480 | 2020-11-15 | Kit Carson | Colorado | 8063 | 237 | 3 |
729235 | 729235 | 2020-11-14 | Kit Carson | Colorado | 8063 | 234 | 3 |
725992 | 725992 | 2020-11-13 | Kit Carson | Colorado | 8063 | 227 | 3 |
722749 | 722749 | 2020-11-12 | Kit Carson | Colorado | 8063 | 220 | 3 |
719506 | 719506 | 2020-11-11 | Kit Carson | Colorado | 8063 | 213 | 3 |
716263 | 716263 | 2020-11-10 | Kit Carson | Colorado | 8063 | 191 | 3 |
713019 | 713019 | 2020-11-09 | Kit Carson | Colorado | 8063 | 191 | 3 |
709775 | 709775 | 2020-11-08 | Kit Carson | Colorado | 8063 | 191 | 3 |
706531 | 706531 | 2020-11-07 | Kit Carson | Colorado | 8063 | 191 | 3 |
703288 | 703288 | 2020-11-06 | Kit Carson | Colorado | 8063 | 184 | 3 |
700045 | 700045 | 2020-11-05 | Kit Carson | Colorado | 8063 | 184 | 3 |
696801 | 696801 | 2020-11-04 | Kit Carson | Colorado | 8063 | 139 | 3 |
693559 | 693559 | 2020-11-03 | Kit Carson | Colorado | 8063 | 139 | 3 |
690316 | 690316 | 2020-11-02 | Kit Carson | Colorado | 8063 | 139 | 3 |
687071 | 687071 | 2020-11-01 | Kit Carson | Colorado | 8063 | 139 | 3 |
683827 | 683827 | 2020-10-31 | Kit Carson | Colorado | 8063 | 139 | 3 |
680584 | 680584 | 2020-10-30 | Kit Carson | Colorado | 8063 | 137 | 3 |
677341 | 677341 | 2020-10-29 | Kit Carson | Colorado | 8063 | 135 | 3 |
674098 | 674098 | 2020-10-28 | Kit Carson | Colorado | 8063 | 132 | 3 |
670856 | 670856 | 2020-10-27 | Kit Carson | Colorado | 8063 | 131 | 3 |
667613 | 667613 | 2020-10-26 | Kit Carson | Colorado | 8063 | 130 | 3 |
664368 | 664368 | 2020-10-25 | Kit Carson | Colorado | 8063 | 130 | 3 |
661124 | 661124 | 2020-10-24 | Kit Carson | Colorado | 8063 | 131 | 3 |
657880 | 657880 | 2020-10-23 | Kit Carson | Colorado | 8063 | 122 | 3 |
654635 | 654635 | 2020-10-22 | Kit Carson | Colorado | 8063 | 114 | 3 |
651390 | 651390 | 2020-10-21 | Kit Carson | Colorado | 8063 | 109 | 3 |
648146 | 648146 | 2020-10-20 | Kit Carson | Colorado | 8063 | 107 | 3 |
644901 | 644901 | 2020-10-19 | Kit Carson | Colorado | 8063 | 103 | 3 |
641653 | 641653 | 2020-10-18 | Kit Carson | Colorado | 8063 | 103 | 3 |
638406 | 638406 | 2020-10-17 | Kit Carson | Colorado | 8063 | 103 | 3 |
635161 | 635161 | 2020-10-16 | Kit Carson | Colorado | 8063 | 98 | 3 |
631915 | 631915 | 2020-10-15 | Kit Carson | Colorado | 8063 | 98 | 3 |
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);