ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where county = "Park", deaths = 7, 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 |
---|---|---|---|---|---|---|---|
1807160 | 1807160 | 2021-10-12 | Park | Colorado | 8093 | 1297 | 7 |
1803909 | 1803909 | 2021-10-11 | Park | Colorado | 8093 | 1287 | 7 |
1800660 | 1800660 | 2021-10-10 | Park | Colorado | 8093 | 1260 | 7 |
1797411 | 1797411 | 2021-10-09 | Park | Colorado | 8093 | 1260 | 7 |
1794162 | 1794162 | 2021-10-08 | Park | Colorado | 8093 | 1260 | 7 |
1790914 | 1790914 | 2021-10-07 | Park | Colorado | 8093 | 1254 | 7 |
1787665 | 1787665 | 2021-10-06 | Park | Colorado | 8093 | 1242 | 7 |
1784416 | 1784416 | 2021-10-05 | Park | Colorado | 8093 | 1221 | 7 |
1781167 | 1781167 | 2021-10-04 | Park | Colorado | 8093 | 1212 | 7 |
1777917 | 1777917 | 2021-10-03 | Park | Colorado | 8093 | 1197 | 7 |
1774667 | 1774667 | 2021-10-02 | Park | Colorado | 8093 | 1197 | 7 |
1771417 | 1771417 | 2021-10-01 | Park | Colorado | 8093 | 1197 | 7 |
1768168 | 1768168 | 2021-09-30 | Park | Colorado | 8093 | 1186 | 7 |
1764919 | 1764919 | 2021-09-29 | Park | Colorado | 8093 | 1182 | 7 |
1761670 | 1761670 | 2021-09-28 | Park | Colorado | 8093 | 1179 | 7 |
1758422 | 1758422 | 2021-09-27 | Park | Colorado | 8093 | 1167 | 7 |
1755174 | 1755174 | 2021-09-26 | Park | Colorado | 8093 | 1157 | 7 |
1751926 | 1751926 | 2021-09-25 | Park | Colorado | 8093 | 1157 | 7 |
1748677 | 1748677 | 2021-09-24 | Park | Colorado | 8093 | 1157 | 7 |
1745427 | 1745427 | 2021-09-23 | Park | Colorado | 8093 | 1146 | 7 |
1742178 | 1742178 | 2021-09-22 | Park | Colorado | 8093 | 1139 | 7 |
1738929 | 1738929 | 2021-09-21 | Park | Colorado | 8093 | 1130 | 7 |
1735680 | 1735680 | 2021-09-20 | Park | Colorado | 8093 | 1126 | 7 |
1732430 | 1732430 | 2021-09-19 | Park | Colorado | 8093 | 1111 | 7 |
1729180 | 1729180 | 2021-09-18 | Park | Colorado | 8093 | 1111 | 7 |
1725930 | 1725930 | 2021-09-17 | Park | Colorado | 8093 | 1111 | 7 |
1722681 | 1722681 | 2021-09-16 | Park | Colorado | 8093 | 1108 | 7 |
1719432 | 1719432 | 2021-09-15 | Park | Colorado | 8093 | 1100 | 7 |
1716184 | 1716184 | 2021-09-14 | Park | Colorado | 8093 | 1090 | 7 |
1712938 | 1712938 | 2021-09-13 | Park | Colorado | 8093 | 1089 | 7 |
1709691 | 1709691 | 2021-09-12 | Park | Colorado | 8093 | 1077 | 7 |
1706444 | 1706444 | 2021-09-11 | Park | Colorado | 8093 | 1077 | 7 |
1703196 | 1703196 | 2021-09-10 | Park | Colorado | 8093 | 1077 | 7 |
1699946 | 1699946 | 2021-09-09 | Park | Colorado | 8093 | 1073 | 7 |
1696697 | 1696697 | 2021-09-08 | Park | Colorado | 8093 | 1068 | 7 |
1693449 | 1693449 | 2021-09-07 | Park | Colorado | 8093 | 1060 | 7 |
1690200 | 1690200 | 2021-09-06 | Park | Colorado | 8093 | 1054 | 7 |
1686950 | 1686950 | 2021-09-05 | Park | Colorado | 8093 | 1043 | 7 |
1683700 | 1683700 | 2021-09-04 | Park | Colorado | 8093 | 1043 | 7 |
1680449 | 1680449 | 2021-09-03 | Park | Colorado | 8093 | 1043 | 7 |
1677201 | 1677201 | 2021-09-02 | Park | Colorado | 8093 | 1036 | 7 |
1673954 | 1673954 | 2021-09-01 | Park | Colorado | 8093 | 1020 | 7 |
1670706 | 1670706 | 2021-08-31 | Park | Colorado | 8093 | 1018 | 7 |
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);