ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 5 and fips = 33001 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 |
---|---|---|---|---|---|---|---|
704790 | 704790 | 2020-11-06 | Belknap | New Hampshire | 33001 | 274 | 5 |
701547 | 701547 | 2020-11-05 | Belknap | New Hampshire | 33001 | 269 | 5 |
698303 | 698303 | 2020-11-04 | Belknap | New Hampshire | 33001 | 262 | 5 |
695060 | 695060 | 2020-11-03 | Belknap | New Hampshire | 33001 | 259 | 5 |
691818 | 691818 | 2020-11-02 | Belknap | New Hampshire | 33001 | 253 | 5 |
688574 | 688574 | 2020-11-01 | Belknap | New Hampshire | 33001 | 248 | 5 |
685329 | 685329 | 2020-10-31 | Belknap | New Hampshire | 33001 | 247 | 5 |
682086 | 682086 | 2020-10-30 | Belknap | New Hampshire | 33001 | 238 | 5 |
678843 | 678843 | 2020-10-29 | Belknap | New Hampshire | 33001 | 234 | 5 |
675600 | 675600 | 2020-10-28 | Belknap | New Hampshire | 33001 | 233 | 5 |
672357 | 672357 | 2020-10-27 | Belknap | New Hampshire | 33001 | 229 | 5 |
669115 | 669115 | 2020-10-26 | Belknap | New Hampshire | 33001 | 224 | 5 |
665871 | 665871 | 2020-10-25 | Belknap | New Hampshire | 33001 | 223 | 5 |
662626 | 662626 | 2020-10-24 | Belknap | New Hampshire | 33001 | 218 | 5 |
659382 | 659382 | 2020-10-23 | Belknap | New Hampshire | 33001 | 210 | 5 |
656138 | 656138 | 2020-10-22 | Belknap | New Hampshire | 33001 | 202 | 5 |
652893 | 652893 | 2020-10-21 | Belknap | New Hampshire | 33001 | 202 | 5 |
649648 | 649648 | 2020-10-20 | Belknap | New Hampshire | 33001 | 195 | 5 |
646404 | 646404 | 2020-10-19 | Belknap | New Hampshire | 33001 | 192 | 5 |
643158 | 643158 | 2020-10-18 | Belknap | New Hampshire | 33001 | 191 | 5 |
639910 | 639910 | 2020-10-17 | Belknap | New Hampshire | 33001 | 188 | 5 |
636664 | 636664 | 2020-10-16 | Belknap | New Hampshire | 33001 | 186 | 5 |
633418 | 633418 | 2020-10-15 | Belknap | New Hampshire | 33001 | 185 | 5 |
630173 | 630173 | 2020-10-14 | Belknap | New Hampshire | 33001 | 182 | 5 |
626929 | 626929 | 2020-10-13 | Belknap | New Hampshire | 33001 | 181 | 5 |
623687 | 623687 | 2020-10-12 | Belknap | New Hampshire | 33001 | 181 | 5 |
620444 | 620444 | 2020-10-11 | Belknap | New Hampshire | 33001 | 175 | 5 |
617202 | 617202 | 2020-10-10 | Belknap | New Hampshire | 33001 | 172 | 5 |
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);