ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where county = "Wells", deaths = 3 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 |
---|---|---|---|---|---|---|---|
812147 | 812147 | 2020-12-09 | Wells | North Dakota | 38103 | 373 | 3 |
808903 | 808903 | 2020-12-08 | Wells | North Dakota | 38103 | 319 | 3 |
805658 | 805658 | 2020-12-07 | Wells | North Dakota | 38103 | 319 | 3 |
802413 | 802413 | 2020-12-06 | Wells | North Dakota | 38103 | 318 | 3 |
799168 | 799168 | 2020-12-05 | Wells | North Dakota | 38103 | 315 | 3 |
795923 | 795923 | 2020-12-04 | Wells | North Dakota | 38103 | 313 | 3 |
792678 | 792678 | 2020-12-03 | Wells | North Dakota | 38103 | 311 | 3 |
789433 | 789433 | 2020-12-02 | Wells | North Dakota | 38103 | 307 | 3 |
786188 | 786188 | 2020-12-01 | Wells | North Dakota | 38103 | 307 | 3 |
782944 | 782944 | 2020-11-30 | Wells | North Dakota | 38103 | 307 | 3 |
779698 | 779698 | 2020-11-29 | Wells | North Dakota | 38103 | 307 | 3 |
776453 | 776453 | 2020-11-28 | Wells | North Dakota | 38103 | 307 | 3 |
773208 | 773208 | 2020-11-27 | Wells | North Dakota | 38103 | 297 | 3 |
769963 | 769963 | 2020-11-26 | Wells | North Dakota | 38103 | 296 | 3 |
766717 | 766717 | 2020-11-25 | Wells | North Dakota | 38103 | 293 | 3 |
763472 | 763472 | 2020-11-24 | Wells | North Dakota | 38103 | 294 | 3 |
760227 | 760227 | 2020-11-23 | Wells | North Dakota | 38103 | 290 | 3 |
756981 | 756981 | 2020-11-22 | Wells | North Dakota | 38103 | 290 | 3 |
753734 | 753734 | 2020-11-21 | Wells | North Dakota | 38103 | 288 | 3 |
750488 | 750488 | 2020-11-20 | Wells | North Dakota | 38103 | 283 | 3 |
747242 | 747242 | 2020-11-19 | Wells | North Dakota | 38103 | 280 | 3 |
743996 | 743996 | 2020-11-18 | Wells | North Dakota | 38103 | 277 | 3 |
740749 | 740749 | 2020-11-17 | Wells | North Dakota | 38103 | 276 | 3 |
737504 | 737504 | 2020-11-16 | Wells | North Dakota | 38103 | 275 | 3 |
734260 | 734260 | 2020-11-15 | Wells | North Dakota | 38103 | 272 | 3 |
731014 | 731014 | 2020-11-14 | Wells | North Dakota | 38103 | 272 | 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);