ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 669 and county = "Kane" 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 |
---|---|---|---|---|---|---|---|
1377827 | 1377827 | 2021-06-01 | Kane | Utah | 49025 | 669 | 6 |
1374581 | 1374581 | 2021-05-31 | Kane | Utah | 49025 | 669 | 6 |
1371336 | 1371336 | 2021-05-30 | Kane | Utah | 49025 | 669 | 6 |
1368090 | 1368090 | 2021-05-29 | Kane | Utah | 49025 | 669 | 6 |
1364844 | 1364844 | 2021-05-28 | Kane | Utah | 49025 | 669 | 6 |
1361598 | 1361598 | 2021-05-27 | Kane | Utah | 49025 | 669 | 6 |
1358352 | 1358352 | 2021-05-26 | Kane | Utah | 49025 | 669 | 6 |
1355106 | 1355106 | 2021-05-25 | Kane | Utah | 49025 | 669 | 6 |
1351860 | 1351860 | 2021-05-24 | Kane | Utah | 49025 | 669 | 6 |
1348614 | 1348614 | 2021-05-23 | Kane | Utah | 49025 | 669 | 6 |
1345366 | 1345366 | 2021-05-22 | Kane | Utah | 49025 | 669 | 6 |
1342118 | 1342118 | 2021-05-21 | Kane | Utah | 49025 | 669 | 6 |
1338870 | 1338870 | 2021-05-20 | Kane | Utah | 49025 | 669 | 6 |
1335623 | 1335623 | 2021-05-19 | Kane | Utah | 49025 | 669 | 6 |
1332376 | 1332376 | 2021-05-18 | Kane | Utah | 49025 | 669 | 6 |
1329129 | 1329129 | 2021-05-17 | Kane | Utah | 49025 | 669 | 6 |
1325883 | 1325883 | 2021-05-16 | Kane | Utah | 49025 | 669 | 6 |
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);