ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where county = "Crow Wing", deaths = 18 and state = "Minnesota" 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 |
---|---|---|---|---|---|---|---|
613525 | 613525 | 2020-10-09 | Crow Wing | Minnesota | 27035 | 701 | 18 |
610283 | 610283 | 2020-10-08 | Crow Wing | Minnesota | 27035 | 692 | 18 |
607041 | 607041 | 2020-10-07 | Crow Wing | Minnesota | 27035 | 667 | 18 |
603798 | 603798 | 2020-10-06 | Crow Wing | Minnesota | 27035 | 658 | 18 |
600556 | 600556 | 2020-10-05 | Crow Wing | Minnesota | 27035 | 647 | 18 |
597313 | 597313 | 2020-10-04 | Crow Wing | Minnesota | 27035 | 630 | 18 |
594072 | 594072 | 2020-10-03 | Crow Wing | Minnesota | 27035 | 617 | 18 |
590831 | 590831 | 2020-10-02 | Crow Wing | Minnesota | 27035 | 601 | 18 |
587590 | 587590 | 2020-10-01 | Crow Wing | Minnesota | 27035 | 581 | 18 |
584350 | 584350 | 2020-09-30 | Crow Wing | Minnesota | 27035 | 563 | 18 |
581109 | 581109 | 2020-09-29 | Crow Wing | Minnesota | 27035 | 554 | 18 |
577868 | 577868 | 2020-09-28 | Crow Wing | Minnesota | 27035 | 555 | 18 |
574627 | 574627 | 2020-09-27 | Crow Wing | Minnesota | 27035 | 533 | 18 |
571384 | 571384 | 2020-09-26 | Crow Wing | Minnesota | 27035 | 516 | 18 |
568142 | 568142 | 2020-09-25 | Crow Wing | Minnesota | 27035 | 494 | 18 |
564902 | 564902 | 2020-09-24 | Crow Wing | Minnesota | 27035 | 481 | 18 |
561662 | 561662 | 2020-09-23 | Crow Wing | Minnesota | 27035 | 464 | 18 |
558425 | 558425 | 2020-09-22 | Crow Wing | Minnesota | 27035 | 444 | 18 |
555188 | 555188 | 2020-09-21 | Crow Wing | Minnesota | 27035 | 439 | 18 |
551950 | 551950 | 2020-09-20 | Crow Wing | Minnesota | 27035 | 433 | 18 |
548711 | 548711 | 2020-09-19 | Crow Wing | Minnesota | 27035 | 419 | 18 |
545473 | 545473 | 2020-09-18 | Crow Wing | Minnesota | 27035 | 410 | 18 |
542236 | 542236 | 2020-09-17 | Crow Wing | Minnesota | 27035 | 402 | 18 |
539000 | 539000 | 2020-09-16 | Crow Wing | Minnesota | 27035 | 388 | 18 |
535763 | 535763 | 2020-09-15 | Crow Wing | Minnesota | 27035 | 378 | 18 |
532528 | 532528 | 2020-09-14 | Crow Wing | Minnesota | 27035 | 377 | 18 |
529292 | 529292 | 2020-09-13 | Crow Wing | Minnesota | 27035 | 373 | 18 |
526056 | 526056 | 2020-09-12 | Crow Wing | Minnesota | 27035 | 365 | 18 |
522820 | 522820 | 2020-09-11 | Crow Wing | Minnesota | 27035 | 361 | 18 |
519583 | 519583 | 2020-09-10 | Crow Wing | Minnesota | 27035 | 362 | 18 |
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);