ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where county = "Marin" and deaths = 242 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 |
---|---|---|---|---|---|---|---|
1810324 | 1810324 | 2021-10-13 | Marin | California | 6041 | 17551 | 242 |
1807075 | 1807075 | 2021-10-12 | Marin | California | 6041 | 17546 | 242 |
1803824 | 1803824 | 2021-10-11 | Marin | California | 6041 | 17537 | 242 |
1800575 | 1800575 | 2021-10-10 | Marin | California | 6041 | 17474 | 242 |
1797326 | 1797326 | 2021-10-09 | Marin | California | 6041 | 17474 | 242 |
1794077 | 1794077 | 2021-10-08 | Marin | California | 6041 | 17474 | 242 |
1790829 | 1790829 | 2021-10-07 | Marin | California | 6041 | 17467 | 242 |
1787580 | 1787580 | 2021-10-06 | Marin | California | 6041 | 17437 | 242 |
1784331 | 1784331 | 2021-10-05 | Marin | California | 6041 | 17421 | 242 |
1781082 | 1781082 | 2021-10-04 | Marin | California | 6041 | 17408 | 242 |
1777832 | 1777832 | 2021-10-03 | Marin | California | 6041 | 17349 | 242 |
1774582 | 1774582 | 2021-10-02 | Marin | California | 6041 | 17349 | 242 |
1771332 | 1771332 | 2021-10-01 | Marin | California | 6041 | 17349 | 242 |
1768083 | 1768083 | 2021-09-30 | Marin | California | 6041 | 17334 | 242 |
1764834 | 1764834 | 2021-09-29 | Marin | California | 6041 | 17285 | 242 |
1761585 | 1761585 | 2021-09-28 | Marin | California | 6041 | 17259 | 242 |
1758337 | 1758337 | 2021-09-27 | Marin | California | 6041 | 17258 | 242 |
1755089 | 1755089 | 2021-09-26 | Marin | California | 6041 | 17200 | 242 |
1751841 | 1751841 | 2021-09-25 | Marin | California | 6041 | 17200 | 242 |
1748592 | 1748592 | 2021-09-24 | Marin | California | 6041 | 17200 | 242 |
1745342 | 1745342 | 2021-09-23 | Marin | California | 6041 | 17180 | 242 |
1742093 | 1742093 | 2021-09-22 | Marin | California | 6041 | 17143 | 242 |
1738844 | 1738844 | 2021-09-21 | Marin | California | 6041 | 17127 | 242 |
1735595 | 1735595 | 2021-09-20 | Marin | California | 6041 | 17106 | 242 |
1732345 | 1732345 | 2021-09-19 | Marin | California | 6041 | 17080 | 242 |
1729095 | 1729095 | 2021-09-18 | Marin | California | 6041 | 17053 | 242 |
1725845 | 1725845 | 2021-09-17 | Marin | California | 6041 | 17020 | 242 |
1722596 | 1722596 | 2021-09-16 | Marin | California | 6041 | 16987 | 242 |
1719347 | 1719347 | 2021-09-15 | Marin | California | 6041 | 16971 | 242 |
1716099 | 1716099 | 2021-09-14 | Marin | California | 6041 | 16944 | 242 |
1712853 | 1712853 | 2021-09-13 | Marin | California | 6041 | 16913 | 242 |
1709606 | 1709606 | 2021-09-12 | Marin | California | 6041 | 16883 | 242 |
1706359 | 1706359 | 2021-09-11 | Marin | California | 6041 | 16845 | 242 |
1703111 | 1703111 | 2021-09-10 | Marin | California | 6041 | 16803 | 242 |
1699861 | 1699861 | 2021-09-09 | Marin | California | 6041 | 16773 | 242 |
1696612 | 1696612 | 2021-09-08 | Marin | California | 6041 | 16736 | 242 |
1693364 | 1693364 | 2021-09-07 | Marin | California | 6041 | 16729 | 242 |
1690115 | 1690115 | 2021-09-06 | Marin | California | 6041 | 16715 | 242 |
1686865 | 1686865 | 2021-09-05 | Marin | California | 6041 | 16692 | 242 |
1683615 | 1683615 | 2021-09-04 | Marin | California | 6041 | 16666 | 242 |
1680364 | 1680364 | 2021-09-03 | Marin | California | 6041 | 16617 | 242 |
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);