ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where county = "Heard" and deaths = 43 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2155134 | 2155134 | 2022-01-27 | Heard | Georgia | 13149 | 2051 | 43 |
2151881 | 2151881 | 2022-01-26 | Heard | Georgia | 13149 | 2022 | 43 |
2148629 | 2148629 | 2022-01-25 | Heard | Georgia | 13149 | 2005 | 43 |
2145377 | 2145377 | 2022-01-24 | Heard | Georgia | 13149 | 2001 | 43 |
2142122 | 2142122 | 2022-01-23 | Heard | Georgia | 13149 | 1972 | 43 |
2138867 | 2138867 | 2022-01-22 | Heard | Georgia | 13149 | 1972 | 43 |
2135611 | 2135611 | 2022-01-21 | Heard | Georgia | 13149 | 1972 | 43 |
2132359 | 2132359 | 2022-01-20 | Heard | Georgia | 13149 | 1945 | 43 |
2129106 | 2129106 | 2022-01-19 | Heard | Georgia | 13149 | 1936 | 43 |
2125852 | 2125852 | 2022-01-18 | Heard | Georgia | 13149 | 1903 | 43 |
2122600 | 2122600 | 2022-01-17 | Heard | Georgia | 13149 | 1896 | 43 |
2119348 | 2119348 | 2022-01-16 | Heard | Georgia | 13149 | 1852 | 43 |
2116096 | 2116096 | 2022-01-15 | Heard | Georgia | 13149 | 1852 | 43 |
2112845 | 2112845 | 2022-01-14 | Heard | Georgia | 13149 | 1852 | 43 |
2109593 | 2109593 | 2022-01-13 | Heard | Georgia | 13149 | 1835 | 43 |
2106342 | 2106342 | 2022-01-12 | Heard | Georgia | 13149 | 1819 | 43 |
2103091 | 2103091 | 2022-01-11 | Heard | Georgia | 13149 | 1807 | 43 |
2099840 | 2099840 | 2022-01-10 | Heard | Georgia | 13149 | 1776 | 43 |
2096589 | 2096589 | 2022-01-09 | Heard | Georgia | 13149 | 1708 | 43 |
2093337 | 2093337 | 2022-01-08 | Heard | Georgia | 13149 | 1708 | 43 |
2090085 | 2090085 | 2022-01-07 | Heard | Georgia | 13149 | 1708 | 43 |
2086834 | 2086834 | 2022-01-06 | Heard | Georgia | 13149 | 1708 | 43 |
2083582 | 2083582 | 2022-01-05 | Heard | Georgia | 13149 | 1708 | 43 |
2080330 | 2080330 | 2022-01-04 | Heard | Georgia | 13149 | 1684 | 43 |
2077078 | 2077078 | 2022-01-03 | Heard | Georgia | 13149 | 1636 | 43 |
2073827 | 2073827 | 2022-01-02 | Heard | Georgia | 13149 | 1636 | 43 |
2070576 | 2070576 | 2022-01-01 | Heard | Georgia | 13149 | 1636 | 43 |
2067325 | 2067325 | 2021-12-31 | Heard | Georgia | 13149 | 1636 | 43 |
2064074 | 2064074 | 2021-12-30 | Heard | Georgia | 13149 | 1623 | 43 |
2060824 | 2060824 | 2021-12-29 | Heard | Georgia | 13149 | 1602 | 43 |
2057575 | 2057575 | 2021-12-28 | Heard | Georgia | 13149 | 1576 | 43 |
2054326 | 2054326 | 2021-12-27 | Heard | Georgia | 13149 | 1570 | 43 |
2051076 | 2051076 | 2021-12-26 | Heard | Georgia | 13149 | 1547 | 43 |
2047826 | 2047826 | 2021-12-25 | Heard | Georgia | 13149 | 1547 | 43 |
2044576 | 2044576 | 2021-12-24 | Heard | Georgia | 13149 | 1547 | 43 |
2041327 | 2041327 | 2021-12-23 | Heard | Georgia | 13149 | 1543 | 43 |
2038077 | 2038077 | 2021-12-22 | Heard | Georgia | 13149 | 1538 | 43 |
2034827 | 2034827 | 2021-12-21 | Heard | Georgia | 13149 | 1533 | 43 |
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);