ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where county = "Wilson" and deaths = 36 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 4
- North Carolina 21
- Texas 10
- Kansas 5
- Tennessee 2
county 1
- Wilson · 38 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2194710 | 2194710 | 2022-02-08 | Wilson | Kansas | 20205 | 2720 | 36 |
2191456 | 2191456 | 2022-02-07 | Wilson | Kansas | 20205 | 2720 | 36 |
2188203 | 2188203 | 2022-02-06 | Wilson | Kansas | 20205 | 2702 | 36 |
2184950 | 2184950 | 2022-02-05 | Wilson | Kansas | 20205 | 2702 | 36 |
2181698 | 2181698 | 2022-02-04 | Wilson | Kansas | 20205 | 2702 | 36 |
916815 | 916815 | 2021-01-10 | Wilson | Texas | 48493 | 2584 | 36 |
913570 | 913570 | 2021-01-09 | Wilson | Texas | 48493 | 2584 | 36 |
910325 | 910325 | 2021-01-08 | Wilson | Texas | 48493 | 2568 | 36 |
907080 | 907080 | 2021-01-07 | Wilson | Texas | 48493 | 2533 | 36 |
903834 | 903834 | 2021-01-06 | Wilson | Texas | 48493 | 2407 | 36 |
900589 | 900589 | 2021-01-05 | Wilson | Texas | 48493 | 2382 | 36 |
897344 | 897344 | 2021-01-04 | Wilson | Texas | 48493 | 2137 | 36 |
894098 | 894098 | 2021-01-03 | Wilson | Texas | 48493 | 2137 | 36 |
890852 | 890852 | 2021-01-02 | Wilson | Texas | 48493 | 2137 | 36 |
887605 | 887605 | 2021-01-01 | Wilson | Texas | 48493 | 2137 | 36 |
530565 | 530565 | 2020-09-13 | Wilson | Tennessee | 47189 | 3173 | 36 |
527328 | 527328 | 2020-09-12 | Wilson | Tennessee | 47189 | 3162 | 36 |
494366 | 494366 | 2020-09-02 | Wilson | North Carolina | 37195 | 1754 | 36 |
491132 | 491132 | 2020-09-01 | Wilson | North Carolina | 37195 | 1752 | 36 |
487899 | 487899 | 2020-08-31 | Wilson | North Carolina | 37195 | 1733 | 36 |
484666 | 484666 | 2020-08-30 | Wilson | North Carolina | 37195 | 1721 | 36 |
481431 | 481431 | 2020-08-29 | Wilson | North Carolina | 37195 | 1715 | 36 |
478198 | 478198 | 2020-08-28 | Wilson | North Carolina | 37195 | 1698 | 36 |
474965 | 474965 | 2020-08-27 | Wilson | North Carolina | 37195 | 1694 | 36 |
471731 | 471731 | 2020-08-26 | Wilson | North Carolina | 37195 | 1677 | 36 |
468499 | 468499 | 2020-08-25 | Wilson | North Carolina | 37195 | 1679 | 36 |
465271 | 465271 | 2020-08-24 | Wilson | North Carolina | 37195 | 1670 | 36 |
462042 | 462042 | 2020-08-23 | Wilson | North Carolina | 37195 | 1656 | 36 |
458814 | 458814 | 2020-08-22 | Wilson | North Carolina | 37195 | 1645 | 36 |
455586 | 455586 | 2020-08-21 | Wilson | North Carolina | 37195 | 1620 | 36 |
452358 | 452358 | 2020-08-20 | Wilson | North Carolina | 37195 | 1604 | 36 |
449130 | 449130 | 2020-08-19 | Wilson | North Carolina | 37195 | 1584 | 36 |
445902 | 445902 | 2020-08-18 | Wilson | North Carolina | 37195 | 1582 | 36 |
442676 | 442676 | 2020-08-17 | Wilson | North Carolina | 37195 | 1563 | 36 |
439449 | 439449 | 2020-08-16 | Wilson | North Carolina | 37195 | 1562 | 36 |
436224 | 436224 | 2020-08-15 | Wilson | North Carolina | 37195 | 1552 | 36 |
432998 | 432998 | 2020-08-14 | Wilson | North Carolina | 37195 | 1536 | 36 |
429772 | 429772 | 2020-08-13 | Wilson | North Carolina | 37195 | 1525 | 36 |
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);