ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 188 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1519770 | 1519770 | 2021-07-15 | Divide | North Dakota | 38023 | 188 | 2 |
1516522 | 1516522 | 2021-07-14 | Divide | North Dakota | 38023 | 188 | 2 |
1513275 | 1513275 | 2021-07-13 | Divide | North Dakota | 38023 | 188 | 2 |
1464582 | 1464582 | 2021-06-28 | Divide | North Dakota | 38023 | 188 | 2 |
1461337 | 1461337 | 2021-06-27 | Divide | North Dakota | 38023 | 188 | 2 |
1458092 | 1458092 | 2021-06-26 | Divide | North Dakota | 38023 | 188 | 2 |
1454847 | 1454847 | 2021-06-25 | Divide | North Dakota | 38023 | 188 | 2 |
1451602 | 1451602 | 2021-06-24 | Divide | North Dakota | 38023 | 188 | 2 |
1448356 | 1448356 | 2021-06-23 | Divide | North Dakota | 38023 | 188 | 2 |
1445111 | 1445111 | 2021-06-22 | Divide | North Dakota | 38023 | 188 | 2 |
1376987 | 1376987 | 2021-06-01 | Steele | North Dakota | 38091 | 188 | 2 |
1373741 | 1373741 | 2021-05-31 | Steele | North Dakota | 38091 | 188 | 2 |
1370496 | 1370496 | 2021-05-30 | Steele | North Dakota | 38091 | 188 | 2 |
1367250 | 1367250 | 2021-05-29 | Steele | North Dakota | 38091 | 188 | 2 |
1159407 | 1159407 | 2021-03-26 | Grant | North Dakota | 38037 | 188 | 7 |
828342 | 828342 | 2020-12-14 | Golden Valley | North Dakota | 38033 | 188 | 0 |
818587 | 818587 | 2020-12-11 | Adams | North Dakota | 38001 | 188 | 0 |
815341 | 815341 | 2020-12-10 | Adams | North Dakota | 38001 | 188 | 0 |
786141 | 786141 | 2020-12-01 | Bowman | North Dakota | 38011 | 188 | 3 |
782897 | 782897 | 2020-11-30 | Bowman | North Dakota | 38011 | 188 | 3 |
753719 | 753719 | 2020-11-21 | Renville | North Dakota | 38075 | 188 | 2 |
721256 | 721256 | 2020-11-11 | McIntosh | North Dakota | 38051 | 188 | 5 |
721271 | 721271 | 2020-11-11 | Sargent | North Dakota | 38081 | 188 | 3 |
718013 | 718013 | 2020-11-10 | McIntosh | North Dakota | 38051 | 188 | 5 |
714770 | 714770 | 2020-11-09 | McIntosh | North Dakota | 38051 | 188 | 5 |
698558 | 698558 | 2020-11-04 | Nelson | North Dakota | 38063 | 188 | 4 |
640146 | 640146 | 2020-10-17 | Dunn | North Dakota | 38025 | 188 | 5 |
636900 | 636900 | 2020-10-16 | Dunn | North Dakota | 38025 | 188 | 4 |
526741 | 526741 | 2020-09-12 | Mountrail | North Dakota | 38061 | 188 | 2 |
254510 | 254510 | 2020-06-19 | Burleigh | North Dakota | 38015 | 188 | 0 |
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);