ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where county = "Grant", deaths = 4 and fips = 41023 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 |
---|---|---|---|---|---|---|---|
1292767 | 1292767 | 2021-05-06 | Grant | Oregon | 41023 | 501 | 4 |
1289521 | 1289521 | 2021-05-05 | Grant | Oregon | 41023 | 498 | 4 |
1286275 | 1286275 | 2021-05-04 | Grant | Oregon | 41023 | 496 | 4 |
1283029 | 1283029 | 2021-05-03 | Grant | Oregon | 41023 | 493 | 4 |
1279782 | 1279782 | 2021-05-02 | Grant | Oregon | 41023 | 493 | 4 |
1276535 | 1276535 | 2021-05-01 | Grant | Oregon | 41023 | 493 | 4 |
1273288 | 1273288 | 2021-04-30 | Grant | Oregon | 41023 | 492 | 4 |
1270041 | 1270041 | 2021-04-29 | Grant | Oregon | 41023 | 480 | 4 |
1266794 | 1266794 | 2021-04-28 | Grant | Oregon | 41023 | 480 | 4 |
1263547 | 1263547 | 2021-04-27 | Grant | Oregon | 41023 | 475 | 4 |
1260300 | 1260300 | 2021-04-26 | Grant | Oregon | 41023 | 468 | 4 |
1257053 | 1257053 | 2021-04-25 | Grant | Oregon | 41023 | 464 | 4 |
1253806 | 1253806 | 2021-04-24 | Grant | Oregon | 41023 | 436 | 4 |
1250559 | 1250559 | 2021-04-23 | Grant | Oregon | 41023 | 436 | 4 |
1247312 | 1247312 | 2021-04-22 | Grant | Oregon | 41023 | 431 | 4 |
1244065 | 1244065 | 2021-04-21 | Grant | Oregon | 41023 | 430 | 4 |
1240818 | 1240818 | 2021-04-20 | Grant | Oregon | 41023 | 420 | 4 |
1237571 | 1237571 | 2021-04-19 | Grant | Oregon | 41023 | 412 | 4 |
1234324 | 1234324 | 2021-04-18 | Grant | Oregon | 41023 | 412 | 4 |
1231076 | 1231076 | 2021-04-17 | Grant | Oregon | 41023 | 406 | 4 |
1227828 | 1227828 | 2021-04-16 | Grant | Oregon | 41023 | 404 | 4 |
1224580 | 1224580 | 2021-04-15 | Grant | Oregon | 41023 | 379 | 4 |
1221333 | 1221333 | 2021-04-14 | Grant | Oregon | 41023 | 378 | 4 |
1218085 | 1218085 | 2021-04-13 | Grant | Oregon | 41023 | 346 | 4 |
1214837 | 1214837 | 2021-04-12 | Grant | Oregon | 41023 | 341 | 4 |
1211590 | 1211590 | 2021-04-11 | Grant | Oregon | 41023 | 341 | 4 |
1208341 | 1208341 | 2021-04-10 | Grant | Oregon | 41023 | 334 | 4 |
1205093 | 1205093 | 2021-04-09 | Grant | Oregon | 41023 | 331 | 4 |
1201845 | 1201845 | 2021-04-08 | Grant | Oregon | 41023 | 307 | 4 |
1198596 | 1198596 | 2021-04-07 | Grant | Oregon | 41023 | 300 | 4 |
1195347 | 1195347 | 2021-04-06 | Grant | Oregon | 41023 | 300 | 4 |
1192099 | 1192099 | 2021-04-05 | Grant | Oregon | 41023 | 292 | 4 |
1188850 | 1188850 | 2021-04-04 | Grant | Oregon | 41023 | 291 | 4 |
1185603 | 1185603 | 2021-04-03 | Grant | Oregon | 41023 | 289 | 4 |
1182356 | 1182356 | 2021-04-02 | Grant | Oregon | 41023 | 288 | 4 |
1179109 | 1179109 | 2021-04-01 | Grant | Oregon | 41023 | 288 | 4 |
1175862 | 1175862 | 2021-03-31 | Grant | Oregon | 41023 | 281 | 4 |
1172615 | 1172615 | 2021-03-30 | Grant | Oregon | 41023 | 275 | 4 |
1169368 | 1169368 | 2021-03-29 | Grant | Oregon | 41023 | 272 | 4 |
1166120 | 1166120 | 2021-03-28 | Grant | Oregon | 41023 | 272 | 4 |
1162872 | 1162872 | 2021-03-27 | Grant | Oregon | 41023 | 271 | 4 |
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);