ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where county = "Harnett", deaths = 30 and fips = 37085 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 |
---|---|---|---|---|---|---|---|
317434 | 317434 | 2020-07-09 | Harnett | North Carolina | 37085 | 744 | 30 |
314260 | 314260 | 2020-07-08 | Harnett | North Carolina | 37085 | 721 | 30 |
311089 | 311089 | 2020-07-07 | Harnett | North Carolina | 37085 | 712 | 30 |
307921 | 307921 | 2020-07-06 | Harnett | North Carolina | 37085 | 705 | 30 |
304754 | 304754 | 2020-07-05 | Harnett | North Carolina | 37085 | 698 | 30 |
301591 | 301591 | 2020-07-04 | Harnett | North Carolina | 37085 | 692 | 30 |
298428 | 298428 | 2020-07-03 | Harnett | North Carolina | 37085 | 682 | 30 |
295268 | 295268 | 2020-07-02 | Harnett | North Carolina | 37085 | 667 | 30 |
292113 | 292113 | 2020-07-01 | Harnett | North Carolina | 37085 | 648 | 30 |
288961 | 288961 | 2020-06-30 | Harnett | North Carolina | 37085 | 630 | 30 |
285811 | 285811 | 2020-06-29 | Harnett | North Carolina | 37085 | 621 | 30 |
282666 | 282666 | 2020-06-28 | Harnett | North Carolina | 37085 | 615 | 30 |
279520 | 279520 | 2020-06-27 | Harnett | North Carolina | 37085 | 598 | 30 |
276372 | 276372 | 2020-06-26 | Harnett | North Carolina | 37085 | 581 | 30 |
273226 | 273226 | 2020-06-25 | Harnett | North Carolina | 37085 | 553 | 30 |
270087 | 270087 | 2020-06-24 | Harnett | North Carolina | 37085 | 536 | 30 |
266953 | 266953 | 2020-06-23 | Harnett | North Carolina | 37085 | 515 | 30 |
263825 | 263825 | 2020-06-22 | Harnett | North Carolina | 37085 | 504 | 30 |
260697 | 260697 | 2020-06-21 | Harnett | North Carolina | 37085 | 499 | 30 |
257570 | 257570 | 2020-06-20 | Harnett | North Carolina | 37085 | 486 | 30 |
254447 | 254447 | 2020-06-19 | Harnett | North Carolina | 37085 | 457 | 30 |
251332 | 251332 | 2020-06-18 | Harnett | North Carolina | 37085 | 435 | 30 |
248217 | 248217 | 2020-06-17 | Harnett | North Carolina | 37085 | 422 | 30 |
245104 | 245104 | 2020-06-16 | Harnett | North Carolina | 37085 | 417 | 30 |
241992 | 241992 | 2020-06-15 | Harnett | North Carolina | 37085 | 411 | 30 |
238883 | 238883 | 2020-06-14 | Harnett | North Carolina | 37085 | 408 | 30 |
235775 | 235775 | 2020-06-13 | Harnett | North Carolina | 37085 | 391 | 30 |
232670 | 232670 | 2020-06-12 | Harnett | North Carolina | 37085 | 381 | 30 |
229565 | 229565 | 2020-06-11 | Harnett | North Carolina | 37085 | 363 | 30 |
226461 | 226461 | 2020-06-10 | Harnett | North Carolina | 37085 | 352 | 30 |
223361 | 223361 | 2020-06-09 | Harnett | North Carolina | 37085 | 345 | 30 |
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);