ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where county = "Choctaw", deaths = 6 and state = "Mississippi" 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 |
---|---|---|---|---|---|---|---|
691463 | 691463 | 2020-11-02 | Choctaw | Mississippi | 28019 | 217 | 6 |
688218 | 688218 | 2020-11-01 | Choctaw | Mississippi | 28019 | 217 | 6 |
684974 | 684974 | 2020-10-31 | Choctaw | Mississippi | 28019 | 217 | 6 |
681731 | 681731 | 2020-10-30 | Choctaw | Mississippi | 28019 | 210 | 6 |
678487 | 678487 | 2020-10-29 | Choctaw | Mississippi | 28019 | 209 | 6 |
675245 | 675245 | 2020-10-28 | Choctaw | Mississippi | 28019 | 209 | 6 |
672002 | 672002 | 2020-10-27 | Choctaw | Mississippi | 28019 | 208 | 6 |
668760 | 668760 | 2020-10-26 | Choctaw | Mississippi | 28019 | 208 | 6 |
665516 | 665516 | 2020-10-25 | Choctaw | Mississippi | 28019 | 208 | 6 |
662271 | 662271 | 2020-10-24 | Choctaw | Mississippi | 28019 | 208 | 6 |
659027 | 659027 | 2020-10-23 | Choctaw | Mississippi | 28019 | 205 | 6 |
655782 | 655782 | 2020-10-22 | Choctaw | Mississippi | 28019 | 204 | 6 |
652537 | 652537 | 2020-10-21 | Choctaw | Mississippi | 28019 | 203 | 6 |
649292 | 649292 | 2020-10-20 | Choctaw | Mississippi | 28019 | 203 | 6 |
646048 | 646048 | 2020-10-19 | Choctaw | Mississippi | 28019 | 203 | 6 |
642801 | 642801 | 2020-10-18 | Choctaw | Mississippi | 28019 | 203 | 6 |
639554 | 639554 | 2020-10-17 | Choctaw | Mississippi | 28019 | 203 | 6 |
636308 | 636308 | 2020-10-16 | Choctaw | Mississippi | 28019 | 202 | 6 |
633062 | 633062 | 2020-10-15 | Choctaw | Mississippi | 28019 | 202 | 6 |
629817 | 629817 | 2020-10-14 | Choctaw | Mississippi | 28019 | 198 | 6 |
626573 | 626573 | 2020-10-13 | Choctaw | Mississippi | 28019 | 198 | 6 |
623331 | 623331 | 2020-10-12 | Choctaw | Mississippi | 28019 | 197 | 6 |
620088 | 620088 | 2020-10-11 | Choctaw | Mississippi | 28019 | 196 | 6 |
616846 | 616846 | 2020-10-10 | Choctaw | Mississippi | 28019 | 196 | 6 |
613605 | 613605 | 2020-10-09 | Choctaw | Mississippi | 28019 | 195 | 6 |
610363 | 610363 | 2020-10-08 | Choctaw | Mississippi | 28019 | 194 | 6 |
607121 | 607121 | 2020-10-07 | Choctaw | Mississippi | 28019 | 193 | 6 |
603878 | 603878 | 2020-10-06 | Choctaw | Mississippi | 28019 | 193 | 6 |
600636 | 600636 | 2020-10-05 | Choctaw | Mississippi | 28019 | 189 | 6 |
597393 | 597393 | 2020-10-04 | Choctaw | Mississippi | 28019 | 189 | 6 |
594152 | 594152 | 2020-10-03 | Choctaw | Mississippi | 28019 | 188 | 6 |
590911 | 590911 | 2020-10-02 | Choctaw | Mississippi | 28019 | 188 | 6 |
587670 | 587670 | 2020-10-01 | Choctaw | Mississippi | 28019 | 187 | 6 |
584430 | 584430 | 2020-09-30 | Choctaw | Mississippi | 28019 | 187 | 6 |
581189 | 581189 | 2020-09-29 | Choctaw | Mississippi | 28019 | 187 | 6 |
577948 | 577948 | 2020-09-28 | Choctaw | Mississippi | 28019 | 186 | 6 |
574707 | 574707 | 2020-09-27 | Choctaw | Mississippi | 28019 | 186 | 6 |
571464 | 571464 | 2020-09-26 | Choctaw | Mississippi | 28019 | 186 | 6 |
568222 | 568222 | 2020-09-25 | Choctaw | Mississippi | 28019 | 185 | 6 |
564982 | 564982 | 2020-09-24 | Choctaw | Mississippi | 28019 | 181 | 6 |
561742 | 561742 | 2020-09-23 | Choctaw | Mississippi | 28019 | 181 | 6 |
558505 | 558505 | 2020-09-22 | Choctaw | Mississippi | 28019 | 180 | 6 |
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);