ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 8093 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277835 | 1277835 | 2021-05-02 | Park | Colorado | 8093 | 739 | 5 |
1274588 | 1274588 | 2021-05-01 | Park | Colorado | 8093 | 737 | 5 |
1271341 | 1271341 | 2021-04-30 | Park | Colorado | 8093 | 734 | 5 |
1268094 | 1268094 | 2021-04-29 | Park | Colorado | 8093 | 729 | 5 |
1264847 | 1264847 | 2021-04-28 | Park | Colorado | 8093 | 722 | 5 |
1261600 | 1261600 | 2021-04-27 | Park | Colorado | 8093 | 720 | 5 |
1258353 | 1258353 | 2021-04-26 | Park | Colorado | 8093 | 705 | 5 |
1255106 | 1255106 | 2021-04-25 | Park | Colorado | 8093 | 705 | 5 |
1251859 | 1251859 | 2021-04-24 | Park | Colorado | 8093 | 697 | 5 |
1248612 | 1248612 | 2021-04-23 | Park | Colorado | 8093 | 697 | 5 |
1245365 | 1245365 | 2021-04-22 | Park | Colorado | 8093 | 692 | 5 |
1242118 | 1242118 | 2021-04-21 | Park | Colorado | 8093 | 679 | 5 |
1238871 | 1238871 | 2021-04-20 | Park | Colorado | 8093 | 673 | 5 |
1235624 | 1235624 | 2021-04-19 | Park | Colorado | 8093 | 669 | 5 |
1232377 | 1232377 | 2021-04-18 | Park | Colorado | 8093 | 669 | 5 |
1229128 | 1229128 | 2021-04-17 | Park | Colorado | 8093 | 666 | 5 |
1225880 | 1225880 | 2021-04-16 | Park | Colorado | 8093 | 661 | 5 |
1222633 | 1222633 | 2021-04-15 | Park | Colorado | 8093 | 656 | 5 |
1219385 | 1219385 | 2021-04-14 | Park | Colorado | 8093 | 649 | 5 |
1216137 | 1216137 | 2021-04-13 | Park | Colorado | 8093 | 644 | 5 |
1212890 | 1212890 | 2021-04-12 | Park | Colorado | 8093 | 637 | 5 |
1209642 | 1209642 | 2021-04-11 | Park | Colorado | 8093 | 637 | 5 |
1206393 | 1206393 | 2021-04-10 | Park | Colorado | 8093 | 636 | 5 |
1203145 | 1203145 | 2021-04-09 | Park | Colorado | 8093 | 633 | 5 |
1199897 | 1199897 | 2021-04-08 | Park | Colorado | 8093 | 626 | 5 |
1196648 | 1196648 | 2021-04-07 | Park | Colorado | 8093 | 616 | 5 |
1193400 | 1193400 | 2021-04-06 | Park | Colorado | 8093 | 616 | 5 |
1190150 | 1190150 | 2021-04-05 | Park | Colorado | 8093 | 615 | 5 |
1186903 | 1186903 | 2021-04-04 | Park | Colorado | 8093 | 615 | 5 |
1183656 | 1183656 | 2021-04-03 | Park | Colorado | 8093 | 614 | 5 |
1180409 | 1180409 | 2021-04-02 | Park | Colorado | 8093 | 612 | 5 |
1177162 | 1177162 | 2021-04-01 | Park | Colorado | 8093 | 610 | 5 |
1173915 | 1173915 | 2021-03-31 | Park | Colorado | 8093 | 609 | 5 |
1170668 | 1170668 | 2021-03-30 | Park | Colorado | 8093 | 608 | 5 |
1167420 | 1167420 | 2021-03-29 | Park | Colorado | 8093 | 607 | 5 |
1164172 | 1164172 | 2021-03-28 | Park | Colorado | 8093 | 607 | 5 |
1160924 | 1160924 | 2021-03-27 | Park | Colorado | 8093 | 607 | 5 |
1157676 | 1157676 | 2021-03-26 | Park | Colorado | 8093 | 603 | 5 |
1154429 | 1154429 | 2021-03-25 | Park | Colorado | 8093 | 598 | 5 |
1151182 | 1151182 | 2021-03-24 | Park | Colorado | 8093 | 594 | 5 |
1147935 | 1147935 | 2021-03-23 | Park | Colorado | 8093 | 591 | 5 |
1144688 | 1144688 | 2021-03-22 | Park | Colorado | 8093 | 590 | 5 |
1141441 | 1141441 | 2021-03-21 | Park | Colorado | 8093 | 589 | 5 |
1138195 | 1138195 | 2021-03-20 | Park | Colorado | 8093 | 582 | 5 |
1134949 | 1134949 | 2021-03-19 | Park | Colorado | 8093 | 580 | 5 |
1131702 | 1131702 | 2021-03-18 | Park | Colorado | 8093 | 577 | 5 |
1128454 | 1128454 | 2021-03-17 | Park | Colorado | 8093 | 575 | 5 |
1125208 | 1125208 | 2021-03-16 | Park | Colorado | 8093 | 574 | 5 |
1121962 | 1121962 | 2021-03-15 | Park | Colorado | 8093 | 573 | 5 |
1118715 | 1118715 | 2021-03-14 | Park | Colorado | 8093 | 573 | 5 |
1115468 | 1115468 | 2021-03-13 | Park | Colorado | 8093 | 572 | 5 |
1112222 | 1112222 | 2021-03-12 | Park | Colorado | 8093 | 571 | 5 |
1108976 | 1108976 | 2021-03-11 | Park | Colorado | 8093 | 571 | 5 |
1105730 | 1105730 | 2021-03-10 | Park | Colorado | 8093 | 568 | 5 |
1102484 | 1102484 | 2021-03-09 | Park | Colorado | 8093 | 565 | 5 |
1099238 | 1099238 | 2021-03-08 | Park | Colorado | 8093 | 564 | 5 |
1095990 | 1095990 | 2021-03-07 | Park | Colorado | 8093 | 562 | 5 |
1092744 | 1092744 | 2021-03-06 | Park | Colorado | 8093 | 562 | 5 |
1089498 | 1089498 | 2021-03-05 | Park | Colorado | 8093 | 560 | 5 |
1086253 | 1086253 | 2021-03-04 | Park | Colorado | 8093 | 558 | 5 |
1083007 | 1083007 | 2021-03-03 | Park | Colorado | 8093 | 554 | 5 |
1079761 | 1079761 | 2021-03-02 | Park | Colorado | 8093 | 552 | 5 |
1076516 | 1076516 | 2021-03-01 | Park | Colorado | 8093 | 551 | 5 |
1073270 | 1073270 | 2021-02-28 | Park | Colorado | 8093 | 551 | 5 |
1070024 | 1070024 | 2021-02-27 | Park | Colorado | 8093 | 548 | 5 |
1066779 | 1066779 | 2021-02-26 | Park | Colorado | 8093 | 545 | 5 |
1063534 | 1063534 | 2021-02-25 | Park | Colorado | 8093 | 545 | 5 |
1060289 | 1060289 | 2021-02-24 | Park | Colorado | 8093 | 540 | 5 |
1057043 | 1057043 | 2021-02-23 | Park | Colorado | 8093 | 540 | 5 |
1053797 | 1053797 | 2021-02-22 | Park | Colorado | 8093 | 540 | 5 |
1050550 | 1050550 | 2021-02-21 | Park | Colorado | 8093 | 539 | 5 |
1047303 | 1047303 | 2021-02-20 | Park | Colorado | 8093 | 537 | 5 |
1044058 | 1044058 | 2021-02-19 | Park | Colorado | 8093 | 534 | 5 |
1040813 | 1040813 | 2021-02-18 | Park | Colorado | 8093 | 529 | 5 |
1037568 | 1037568 | 2021-02-17 | Park | Colorado | 8093 | 529 | 5 |
1034323 | 1034323 | 2021-02-16 | Park | Colorado | 8093 | 528 | 5 |
1031077 | 1031077 | 2021-02-15 | Park | Colorado | 8093 | 527 | 5 |
1027830 | 1027830 | 2021-02-14 | Park | Colorado | 8093 | 526 | 5 |
1024585 | 1024585 | 2021-02-13 | Park | Colorado | 8093 | 526 | 5 |
1021340 | 1021340 | 2021-02-12 | Park | Colorado | 8093 | 523 | 5 |
1018095 | 1018095 | 2021-02-11 | Park | Colorado | 8093 | 521 | 5 |
1014850 | 1014850 | 2021-02-10 | Park | Colorado | 8093 | 514 | 5 |
1011605 | 1011605 | 2021-02-09 | Park | Colorado | 8093 | 511 | 5 |
1008359 | 1008359 | 2021-02-08 | Park | Colorado | 8093 | 510 | 5 |
1005113 | 1005113 | 2021-02-07 | Park | Colorado | 8093 | 510 | 5 |
1001867 | 1001867 | 2021-02-06 | Park | Colorado | 8093 | 509 | 5 |
998621 | 998621 | 2021-02-05 | Park | Colorado | 8093 | 504 | 5 |
995375 | 995375 | 2021-02-04 | Park | Colorado | 8093 | 502 | 5 |
992129 | 992129 | 2021-02-03 | Park | Colorado | 8093 | 496 | 5 |
988883 | 988883 | 2021-02-02 | Park | Colorado | 8093 | 491 | 5 |
985636 | 985636 | 2021-02-01 | Park | Colorado | 8093 | 489 | 5 |
982389 | 982389 | 2021-01-31 | Park | Colorado | 8093 | 484 | 5 |
979143 | 979143 | 2021-01-30 | Park | Colorado | 8093 | 484 | 5 |
975898 | 975898 | 2021-01-29 | Park | Colorado | 8093 | 484 | 5 |
972653 | 972653 | 2021-01-28 | Park | Colorado | 8093 | 479 | 5 |
969408 | 969408 | 2021-01-27 | Park | Colorado | 8093 | 478 | 5 |
966164 | 966164 | 2021-01-26 | Park | Colorado | 8093 | 473 | 5 |
962919 | 962919 | 2021-01-25 | Park | Colorado | 8093 | 471 | 5 |
959674 | 959674 | 2021-01-24 | Park | Colorado | 8093 | 471 | 5 |
956428 | 956428 | 2021-01-23 | Park | Colorado | 8093 | 469 | 5 |
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);