ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where county = "Trimble", deaths = 3 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1129275 | 1129275 | 2021-03-17 | Trimble | Kentucky | 21223 | 629 | 3 |
1126029 | 1126029 | 2021-03-16 | Trimble | Kentucky | 21223 | 626 | 3 |
1122783 | 1122783 | 2021-03-15 | Trimble | Kentucky | 21223 | 623 | 3 |
1119536 | 1119536 | 2021-03-14 | Trimble | Kentucky | 21223 | 622 | 3 |
1116289 | 1116289 | 2021-03-13 | Trimble | Kentucky | 21223 | 620 | 3 |
1113043 | 1113043 | 2021-03-12 | Trimble | Kentucky | 21223 | 620 | 3 |
1109797 | 1109797 | 2021-03-11 | Trimble | Kentucky | 21223 | 619 | 3 |
1106551 | 1106551 | 2021-03-10 | Trimble | Kentucky | 21223 | 615 | 3 |
1103305 | 1103305 | 2021-03-09 | Trimble | Kentucky | 21223 | 611 | 3 |
1100059 | 1100059 | 2021-03-08 | Trimble | Kentucky | 21223 | 610 | 3 |
1096811 | 1096811 | 2021-03-07 | Trimble | Kentucky | 21223 | 610 | 3 |
1093565 | 1093565 | 2021-03-06 | Trimble | Kentucky | 21223 | 610 | 3 |
1090319 | 1090319 | 2021-03-05 | Trimble | Kentucky | 21223 | 609 | 3 |
1087074 | 1087074 | 2021-03-04 | Trimble | Kentucky | 21223 | 608 | 3 |
1083828 | 1083828 | 2021-03-03 | Trimble | Kentucky | 21223 | 608 | 3 |
1080582 | 1080582 | 2021-03-02 | Trimble | Kentucky | 21223 | 603 | 3 |
1077337 | 1077337 | 2021-03-01 | Trimble | Kentucky | 21223 | 603 | 3 |
1074091 | 1074091 | 2021-02-28 | Trimble | Kentucky | 21223 | 602 | 3 |
1070845 | 1070845 | 2021-02-27 | Trimble | Kentucky | 21223 | 603 | 3 |
1067600 | 1067600 | 2021-02-26 | Trimble | Kentucky | 21223 | 599 | 3 |
1064355 | 1064355 | 2021-02-25 | Trimble | Kentucky | 21223 | 599 | 3 |
1061110 | 1061110 | 2021-02-24 | Trimble | Kentucky | 21223 | 593 | 3 |
1057864 | 1057864 | 2021-02-23 | Trimble | Kentucky | 21223 | 592 | 3 |
1054618 | 1054618 | 2021-02-22 | Trimble | Kentucky | 21223 | 590 | 3 |
1051371 | 1051371 | 2021-02-21 | Trimble | Kentucky | 21223 | 590 | 3 |
1048124 | 1048124 | 2021-02-20 | Trimble | Kentucky | 21223 | 589 | 3 |
1044879 | 1044879 | 2021-02-19 | Trimble | Kentucky | 21223 | 589 | 3 |
1041634 | 1041634 | 2021-02-18 | Trimble | Kentucky | 21223 | 584 | 3 |
1038389 | 1038389 | 2021-02-17 | Trimble | Kentucky | 21223 | 583 | 3 |
1035144 | 1035144 | 2021-02-16 | Trimble | Kentucky | 21223 | 581 | 3 |
1031898 | 1031898 | 2021-02-15 | Trimble | Kentucky | 21223 | 580 | 3 |
1028651 | 1028651 | 2021-02-14 | Trimble | Kentucky | 21223 | 575 | 3 |
1025406 | 1025406 | 2021-02-13 | Trimble | Kentucky | 21223 | 572 | 3 |
1022161 | 1022161 | 2021-02-12 | Trimble | Kentucky | 21223 | 571 | 3 |
1018916 | 1018916 | 2021-02-11 | Trimble | Kentucky | 21223 | 566 | 3 |
1015671 | 1015671 | 2021-02-10 | Trimble | Kentucky | 21223 | 564 | 3 |
1012426 | 1012426 | 2021-02-09 | Trimble | Kentucky | 21223 | 558 | 3 |
1009180 | 1009180 | 2021-02-08 | Trimble | Kentucky | 21223 | 555 | 3 |
1005934 | 1005934 | 2021-02-07 | Trimble | Kentucky | 21223 | 553 | 3 |
1002688 | 1002688 | 2021-02-06 | Trimble | Kentucky | 21223 | 549 | 3 |
999442 | 999442 | 2021-02-05 | Trimble | Kentucky | 21223 | 540 | 3 |
996196 | 996196 | 2021-02-04 | Trimble | Kentucky | 21223 | 534 | 3 |
992950 | 992950 | 2021-02-03 | Trimble | Kentucky | 21223 | 534 | 3 |
989704 | 989704 | 2021-02-02 | Trimble | Kentucky | 21223 | 527 | 3 |
986457 | 986457 | 2021-02-01 | Trimble | Kentucky | 21223 | 529 | 3 |
983210 | 983210 | 2021-01-31 | Trimble | Kentucky | 21223 | 526 | 3 |
979964 | 979964 | 2021-01-30 | Trimble | Kentucky | 21223 | 523 | 3 |
976718 | 976718 | 2021-01-29 | Trimble | Kentucky | 21223 | 521 | 3 |
973473 | 973473 | 2021-01-28 | Trimble | Kentucky | 21223 | 520 | 3 |
970228 | 970228 | 2021-01-27 | Trimble | Kentucky | 21223 | 514 | 3 |
966984 | 966984 | 2021-01-26 | Trimble | Kentucky | 21223 | 505 | 3 |
963739 | 963739 | 2021-01-25 | Trimble | Kentucky | 21223 | 501 | 3 |
960494 | 960494 | 2021-01-24 | Trimble | Kentucky | 21223 | 497 | 3 |
957248 | 957248 | 2021-01-23 | Trimble | Kentucky | 21223 | 496 | 3 |
954003 | 954003 | 2021-01-22 | Trimble | Kentucky | 21223 | 495 | 3 |
950758 | 950758 | 2021-01-21 | Trimble | Kentucky | 21223 | 488 | 3 |
947512 | 947512 | 2021-01-20 | Trimble | Kentucky | 21223 | 485 | 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);