ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where deaths = 1, fips = 38025 and state = "North Dakota" 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 |
---|---|---|---|---|---|---|---|
588260 | 588260 | 2020-10-01 | Dunn | North Dakota | 38025 | 115 | 1 |
585020 | 585020 | 2020-09-30 | Dunn | North Dakota | 38025 | 113 | 1 |
581779 | 581779 | 2020-09-29 | Dunn | North Dakota | 38025 | 108 | 1 |
578539 | 578539 | 2020-09-28 | Dunn | North Dakota | 38025 | 106 | 1 |
575298 | 575298 | 2020-09-27 | Dunn | North Dakota | 38025 | 105 | 1 |
572054 | 572054 | 2020-09-26 | Dunn | North Dakota | 38025 | 101 | 1 |
568812 | 568812 | 2020-09-25 | Dunn | North Dakota | 38025 | 100 | 1 |
565571 | 565571 | 2020-09-24 | Dunn | North Dakota | 38025 | 96 | 1 |
562330 | 562330 | 2020-09-23 | Dunn | North Dakota | 38025 | 96 | 1 |
559093 | 559093 | 2020-09-22 | Dunn | North Dakota | 38025 | 86 | 1 |
555856 | 555856 | 2020-09-21 | Dunn | North Dakota | 38025 | 79 | 1 |
552619 | 552619 | 2020-09-20 | Dunn | North Dakota | 38025 | 76 | 1 |
549380 | 549380 | 2020-09-19 | Dunn | North Dakota | 38025 | 76 | 1 |
546141 | 546141 | 2020-09-18 | Dunn | North Dakota | 38025 | 72 | 1 |
542904 | 542904 | 2020-09-17 | Dunn | North Dakota | 38025 | 66 | 1 |
539668 | 539668 | 2020-09-16 | Dunn | North Dakota | 38025 | 65 | 1 |
536431 | 536431 | 2020-09-15 | Dunn | North Dakota | 38025 | 59 | 1 |
533195 | 533195 | 2020-09-14 | Dunn | North Dakota | 38025 | 60 | 1 |
529960 | 529960 | 2020-09-13 | Dunn | North Dakota | 38025 | 58 | 1 |
526723 | 526723 | 2020-09-12 | Dunn | North Dakota | 38025 | 58 | 1 |
523487 | 523487 | 2020-09-11 | Dunn | North Dakota | 38025 | 53 | 1 |
520251 | 520251 | 2020-09-10 | Dunn | North Dakota | 38025 | 52 | 1 |
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);