ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where deaths = 43 and state = "Rhode Island" 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 |
---|---|---|---|---|---|---|---|
2157087 | 2157087 | 2022-01-27 | Unknown | Rhode Island | 35196 | 43 | |
2134311 | 2134311 | 2022-01-20 | Unknown | Rhode Island | 37346 | 43 | |
1672827 | 1672827 | 2021-08-31 | Newport | Rhode Island | 44005 | 7579 | 43 |
1669579 | 1669579 | 2021-08-30 | Newport | Rhode Island | 44005 | 7579 | 43 |
1666332 | 1666332 | 2021-08-29 | Newport | Rhode Island | 44005 | 7579 | 43 |
1663084 | 1663084 | 2021-08-28 | Newport | Rhode Island | 44005 | 7579 | 43 |
1659836 | 1659836 | 2021-08-27 | Newport | Rhode Island | 44005 | 7579 | 43 |
1656587 | 1656587 | 2021-08-26 | Newport | Rhode Island | 44005 | 7579 | 43 |
1653340 | 1653340 | 2021-08-25 | Newport | Rhode Island | 44005 | 7579 | 43 |
1650093 | 1650093 | 2021-08-24 | Newport | Rhode Island | 44005 | 7434 | 43 |
1646844 | 1646844 | 2021-08-23 | Newport | Rhode Island | 44005 | 7434 | 43 |
1643595 | 1643595 | 2021-08-22 | Newport | Rhode Island | 44005 | 7434 | 43 |
1640345 | 1640345 | 2021-08-21 | Newport | Rhode Island | 44005 | 7434 | 43 |
1637095 | 1637095 | 2021-08-20 | Newport | Rhode Island | 44005 | 7434 | 43 |
1633845 | 1633845 | 2021-08-19 | Newport | Rhode Island | 44005 | 7434 | 43 |
1630598 | 1630598 | 2021-08-18 | Newport | Rhode Island | 44005 | 7434 | 43 |
1627351 | 1627351 | 2021-08-17 | Newport | Rhode Island | 44005 | 7309 | 43 |
1624104 | 1624104 | 2021-08-16 | Newport | Rhode Island | 44005 | 7309 | 43 |
1620857 | 1620857 | 2021-08-15 | Newport | Rhode Island | 44005 | 7309 | 43 |
1617609 | 1617609 | 2021-08-14 | Newport | Rhode Island | 44005 | 7309 | 43 |
1614361 | 1614361 | 2021-08-13 | Newport | Rhode Island | 44005 | 7309 | 43 |
1611112 | 1611112 | 2021-08-12 | Newport | Rhode Island | 44005 | 7309 | 43 |
1607864 | 1607864 | 2021-08-11 | Newport | Rhode Island | 44005 | 7309 | 43 |
1604615 | 1604615 | 2021-08-10 | Newport | Rhode Island | 44005 | 7171 | 43 |
1601366 | 1601366 | 2021-08-09 | Newport | Rhode Island | 44005 | 7171 | 43 |
1598118 | 1598118 | 2021-08-08 | Newport | Rhode Island | 44005 | 7171 | 43 |
1594869 | 1594869 | 2021-08-07 | Newport | Rhode Island | 44005 | 7171 | 43 |
1591620 | 1591620 | 2021-08-06 | Newport | Rhode Island | 44005 | 7171 | 43 |
1588371 | 1588371 | 2021-08-05 | Newport | Rhode Island | 44005 | 7171 | 43 |
1585121 | 1585121 | 2021-08-04 | Newport | Rhode Island | 44005 | 7171 | 43 |
1581871 | 1581871 | 2021-08-03 | Newport | Rhode Island | 44005 | 7058 | 43 |
1578622 | 1578622 | 2021-08-02 | Newport | Rhode Island | 44005 | 7058 | 43 |
1575374 | 1575374 | 2021-08-01 | Newport | Rhode Island | 44005 | 7058 | 43 |
1572126 | 1572126 | 2021-07-31 | Newport | Rhode Island | 44005 | 7058 | 43 |
1568878 | 1568878 | 2021-07-30 | Newport | Rhode Island | 44005 | 7058 | 43 |
1565630 | 1565630 | 2021-07-29 | Newport | Rhode Island | 44005 | 7058 | 43 |
1562382 | 1562382 | 2021-07-28 | Newport | Rhode Island | 44005 | 7058 | 43 |
1559134 | 1559134 | 2021-07-27 | Newport | Rhode Island | 44005 | 7020 | 43 |
1555887 | 1555887 | 2021-07-26 | Newport | Rhode Island | 44005 | 7020 | 43 |
1552640 | 1552640 | 2021-07-25 | Newport | Rhode Island | 44005 | 7020 | 43 |
1549393 | 1549393 | 2021-07-24 | Newport | Rhode Island | 44005 | 7020 | 43 |
1546146 | 1546146 | 2021-07-23 | Newport | Rhode Island | 44005 | 7020 | 43 |
1542899 | 1542899 | 2021-07-22 | Newport | Rhode Island | 44005 | 7020 | 43 |
1539651 | 1539651 | 2021-07-21 | Newport | Rhode Island | 44005 | 7020 | 43 |
1536404 | 1536404 | 2021-07-20 | Newport | Rhode Island | 44005 | 6983 | 43 |
1533156 | 1533156 | 2021-07-19 | Newport | Rhode Island | 44005 | 6983 | 43 |
1529909 | 1529909 | 2021-07-18 | Newport | Rhode Island | 44005 | 6983 | 43 |
1526662 | 1526662 | 2021-07-17 | Newport | Rhode Island | 44005 | 6983 | 43 |
1523415 | 1523415 | 2021-07-16 | Newport | Rhode Island | 44005 | 6983 | 43 |
1520167 | 1520167 | 2021-07-15 | Newport | Rhode Island | 44005 | 6983 | 43 |
1516919 | 1516919 | 2021-07-14 | Newport | Rhode Island | 44005 | 6983 | 43 |
1513672 | 1513672 | 2021-07-13 | Newport | Rhode Island | 44005 | 6972 | 43 |
1510426 | 1510426 | 2021-07-12 | Newport | Rhode Island | 44005 | 6972 | 43 |
1507179 | 1507179 | 2021-07-11 | Newport | Rhode Island | 44005 | 6972 | 43 |
1503933 | 1503933 | 2021-07-10 | Newport | Rhode Island | 44005 | 6972 | 43 |
1500687 | 1500687 | 2021-07-09 | Newport | Rhode Island | 44005 | 6972 | 43 |
1497441 | 1497441 | 2021-07-08 | Newport | Rhode Island | 44005 | 6972 | 43 |
1494194 | 1494194 | 2021-07-07 | Newport | Rhode Island | 44005 | 6972 | 43 |
1490947 | 1490947 | 2021-07-06 | Newport | Rhode Island | 44005 | 6975 | 43 |
1487700 | 1487700 | 2021-07-05 | Newport | Rhode Island | 44005 | 6975 | 43 |
1484453 | 1484453 | 2021-07-04 | Newport | Rhode Island | 44005 | 6975 | 43 |
1481207 | 1481207 | 2021-07-03 | Newport | Rhode Island | 44005 | 6975 | 43 |
1477960 | 1477960 | 2021-07-02 | Newport | Rhode Island | 44005 | 6975 | 43 |
1474714 | 1474714 | 2021-07-01 | Newport | Rhode Island | 44005 | 6975 | 43 |
1471468 | 1471468 | 2021-06-30 | Newport | Rhode Island | 44005 | 6975 | 43 |
144441 | 144441 | 2020-05-14 | Unknown | Rhode Island | 1227 | 43 | |
53077 | 53077 | 2020-04-12 | Unknown | Rhode Island | 989 | 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);