ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where deaths = 3, fips = 38057 and state = "North Dakota" 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 |
---|---|---|---|---|---|---|---|
705042 | 705042 | 2020-11-06 | Mercer | North Dakota | 38057 | 577 | 3 |
701799 | 701799 | 2020-11-05 | Mercer | North Dakota | 38057 | 568 | 3 |
698555 | 698555 | 2020-11-04 | Mercer | North Dakota | 38057 | 555 | 3 |
695312 | 695312 | 2020-11-03 | Mercer | North Dakota | 38057 | 536 | 3 |
692070 | 692070 | 2020-11-02 | Mercer | North Dakota | 38057 | 534 | 3 |
688826 | 688826 | 2020-11-01 | Mercer | North Dakota | 38057 | 531 | 3 |
685581 | 685581 | 2020-10-31 | Mercer | North Dakota | 38057 | 518 | 3 |
682338 | 682338 | 2020-10-30 | Mercer | North Dakota | 38057 | 511 | 3 |
679095 | 679095 | 2020-10-29 | Mercer | North Dakota | 38057 | 502 | 3 |
675852 | 675852 | 2020-10-28 | Mercer | North Dakota | 38057 | 482 | 3 |
672609 | 672609 | 2020-10-27 | Mercer | North Dakota | 38057 | 478 | 3 |
669367 | 669367 | 2020-10-26 | Mercer | North Dakota | 38057 | 462 | 3 |
666123 | 666123 | 2020-10-25 | Mercer | North Dakota | 38057 | 456 | 3 |
662878 | 662878 | 2020-10-24 | Mercer | North Dakota | 38057 | 453 | 3 |
659634 | 659634 | 2020-10-23 | Mercer | North Dakota | 38057 | 448 | 3 |
656390 | 656390 | 2020-10-22 | Mercer | North Dakota | 38057 | 392 | 3 |
653145 | 653145 | 2020-10-21 | Mercer | North Dakota | 38057 | 384 | 3 |
649900 | 649900 | 2020-10-20 | Mercer | North Dakota | 38057 | 379 | 3 |
646656 | 646656 | 2020-10-19 | Mercer | North Dakota | 38057 | 375 | 3 |
643410 | 643410 | 2020-10-18 | Mercer | North Dakota | 38057 | 367 | 3 |
640162 | 640162 | 2020-10-17 | Mercer | North Dakota | 38057 | 358 | 3 |
636916 | 636916 | 2020-10-16 | Mercer | North Dakota | 38057 | 337 | 3 |
633670 | 633670 | 2020-10-15 | Mercer | North Dakota | 38057 | 321 | 3 |
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);