ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where deaths = 30 and fips = 8014 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 |
---|---|---|---|---|---|---|---|
347677 | 347677 | 2020-07-19 | Broomfield | Colorado | 8014 | 359 | 30 |
344477 | 344477 | 2020-07-18 | Broomfield | Colorado | 8014 | 358 | 30 |
341278 | 341278 | 2020-07-17 | Broomfield | Colorado | 8014 | 358 | 30 |
338082 | 338082 | 2020-07-16 | Broomfield | Colorado | 8014 | 354 | 30 |
334887 | 334887 | 2020-07-15 | Broomfield | Colorado | 8014 | 352 | 30 |
331694 | 331694 | 2020-07-14 | Broomfield | Colorado | 8014 | 348 | 30 |
328508 | 328508 | 2020-07-13 | Broomfield | Colorado | 8014 | 342 | 30 |
325322 | 325322 | 2020-07-12 | Broomfield | Colorado | 8014 | 341 | 30 |
322141 | 322141 | 2020-07-11 | Broomfield | Colorado | 8014 | 341 | 30 |
318962 | 318962 | 2020-07-10 | Broomfield | Colorado | 8014 | 336 | 30 |
315789 | 315789 | 2020-07-09 | Broomfield | Colorado | 8014 | 333 | 30 |
312614 | 312614 | 2020-07-08 | Broomfield | Colorado | 8014 | 324 | 30 |
309444 | 309444 | 2020-07-07 | Broomfield | Colorado | 8014 | 320 | 30 |
306276 | 306276 | 2020-07-06 | Broomfield | Colorado | 8014 | 316 | 30 |
303112 | 303112 | 2020-07-05 | Broomfield | Colorado | 8014 | 314 | 30 |
299948 | 299948 | 2020-07-04 | Broomfield | Colorado | 8014 | 312 | 30 |
296786 | 296786 | 2020-07-03 | Broomfield | Colorado | 8014 | 307 | 30 |
293630 | 293630 | 2020-07-02 | Broomfield | Colorado | 8014 | 307 | 30 |
290476 | 290476 | 2020-07-01 | Broomfield | Colorado | 8014 | 301 | 30 |
287325 | 287325 | 2020-06-30 | Broomfield | Colorado | 8014 | 298 | 30 |
284179 | 284179 | 2020-06-29 | Broomfield | Colorado | 8014 | 297 | 30 |
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);