ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 10, fips = 38063 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 |
---|---|---|---|---|---|---|---|
883527 | 883527 | 2020-12-31 | Nelson | North Dakota | 38063 | 408 | 10 |
880282 | 880282 | 2020-12-30 | Nelson | North Dakota | 38063 | 407 | 10 |
877037 | 877037 | 2020-12-29 | Nelson | North Dakota | 38063 | 405 | 10 |
873792 | 873792 | 2020-12-28 | Nelson | North Dakota | 38063 | 403 | 10 |
870547 | 870547 | 2020-12-27 | Nelson | North Dakota | 38063 | 403 | 10 |
867302 | 867302 | 2020-12-26 | Nelson | North Dakota | 38063 | 403 | 10 |
864057 | 864057 | 2020-12-25 | Nelson | North Dakota | 38063 | 403 | 10 |
860812 | 860812 | 2020-12-24 | Nelson | North Dakota | 38063 | 403 | 10 |
857567 | 857567 | 2020-12-23 | Nelson | North Dakota | 38063 | 402 | 10 |
854322 | 854322 | 2020-12-22 | Nelson | North Dakota | 38063 | 401 | 10 |
851077 | 851077 | 2020-12-21 | Nelson | North Dakota | 38063 | 399 | 10 |
847832 | 847832 | 2020-12-20 | Nelson | North Dakota | 38063 | 399 | 10 |
844587 | 844587 | 2020-12-19 | Nelson | North Dakota | 38063 | 397 | 10 |
841341 | 841341 | 2020-12-18 | Nelson | North Dakota | 38063 | 394 | 10 |
838096 | 838096 | 2020-12-17 | Nelson | North Dakota | 38063 | 390 | 10 |
834850 | 834850 | 2020-12-16 | Nelson | North Dakota | 38063 | 390 | 10 |
831604 | 831604 | 2020-12-15 | Nelson | North Dakota | 38063 | 387 | 10 |
828357 | 828357 | 2020-12-14 | Nelson | North Dakota | 38063 | 385 | 10 |
825111 | 825111 | 2020-12-13 | Nelson | North Dakota | 38063 | 385 | 10 |
821864 | 821864 | 2020-12-12 | Nelson | North Dakota | 38063 | 384 | 10 |
818618 | 818618 | 2020-12-11 | Nelson | North Dakota | 38063 | 383 | 10 |
815372 | 815372 | 2020-12-10 | Nelson | North Dakota | 38063 | 381 | 10 |
812127 | 812127 | 2020-12-09 | Nelson | North Dakota | 38063 | 378 | 10 |
808882 | 808882 | 2020-12-08 | Nelson | North Dakota | 38063 | 372 | 10 |
805637 | 805637 | 2020-12-07 | Nelson | North Dakota | 38063 | 372 | 10 |
802392 | 802392 | 2020-12-06 | Nelson | North Dakota | 38063 | 369 | 10 |
799147 | 799147 | 2020-12-05 | Nelson | North Dakota | 38063 | 369 | 10 |
795902 | 795902 | 2020-12-04 | Nelson | North Dakota | 38063 | 363 | 10 |
792657 | 792657 | 2020-12-03 | Nelson | North Dakota | 38063 | 361 | 10 |
789412 | 789412 | 2020-12-02 | Nelson | North Dakota | 38063 | 360 | 10 |
786167 | 786167 | 2020-12-01 | Nelson | North Dakota | 38063 | 359 | 10 |
782923 | 782923 | 2020-11-30 | Nelson | North Dakota | 38063 | 359 | 10 |
779677 | 779677 | 2020-11-29 | Nelson | North Dakota | 38063 | 357 | 10 |
776432 | 776432 | 2020-11-28 | Nelson | North Dakota | 38063 | 355 | 10 |
773187 | 773187 | 2020-11-27 | Nelson | North Dakota | 38063 | 353 | 10 |
769942 | 769942 | 2020-11-26 | Nelson | North Dakota | 38063 | 348 | 10 |
766696 | 766696 | 2020-11-25 | Nelson | North Dakota | 38063 | 342 | 10 |
763451 | 763451 | 2020-11-24 | Nelson | North Dakota | 38063 | 339 | 10 |
760206 | 760206 | 2020-11-23 | Nelson | North Dakota | 38063 | 333 | 10 |
756960 | 756960 | 2020-11-22 | Nelson | North Dakota | 38063 | 327 | 10 |
753713 | 753713 | 2020-11-21 | Nelson | North Dakota | 38063 | 323 | 10 |
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);