ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where county = "Jefferson" and date = "2020-10-15" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631676 | 631676 | 2020-10-15 | Jefferson | Alabama | 1073 | 21897 | 364 |
631783 | 631783 | 2020-10-15 | Jefferson | Arkansas | 5069 | 3896 | 97 |
631913 | 631913 | 2020-10-15 | Jefferson | Colorado | 8059 | 6887 | 296 |
631992 | 631992 | 2020-10-15 | Jefferson | Florida | 12065 | 608 | 9 |
632109 | 632109 | 2020-10-15 | Jefferson | Georgia | 13163 | 863 | 31 |
632219 | 632219 | 2020-10-15 | Jefferson | Idaho | 16051 | 813 | 3 |
632278 | 632278 | 2020-10-15 | Jefferson | Illinois | 17081 | 834 | 41 |
632379 | 632379 | 2020-10-15 | Jefferson | Indiana | 18077 | 317 | 4 |
632483 | 632483 | 2020-10-15 | Jefferson | Iowa | 19101 | 183 | 1 |
632576 | 632576 | 2020-10-15 | Jefferson | Kansas | 20087 | 247 | 4 |
632694 | 632694 | 2020-10-15 | Jefferson | Kentucky | 21111 | 20303 | 342 |
632784 | 632784 | 2020-10-15 | Jefferson | Louisiana | 22051 | 18182 | 578 |
633084 | 633084 | 2020-10-15 | Jefferson | Mississippi | 28063 | 256 | 10 |
633184 | 633184 | 2020-10-15 | Jefferson | Missouri | 29099 | 5390 | 69 |
633273 | 633273 | 2020-10-15 | Jefferson | Montana | 30043 | 117 | 0 |
633355 | 633355 | 2020-10-15 | Jefferson | Nebraska | 31095 | 55 | 0 |
633505 | 633505 | 2020-10-15 | Jefferson | New York | 36045 | 186 | 1 |
633738 | 633738 | 2020-10-15 | Jefferson | Ohio | 39081 | 428 | 4 |
633819 | 633819 | 2020-10-15 | Jefferson | Oklahoma | 40067 | 63 | 0 |
633879 | 633879 | 2020-10-15 | Jefferson | Oregon | 41031 | 590 | 8 |
633932 | 633932 | 2020-10-15 | Jefferson | Pennsylvania | 42065 | 141 | 3 |
634208 | 634208 | 2020-10-15 | Jefferson | Tennessee | 47089 | 1393 | 18 |
634382 | 634382 | 2020-10-15 | Jefferson | Texas | 48245 | 7950 | 144 |
634709 | 634709 | 2020-10-15 | Jefferson | Washington | 53031 | 80 | 0 |
634752 | 634752 | 2020-10-15 | Jefferson | West Virginia | 54037 | 495 | 4 |
634816 | 634816 | 2020-10-15 | Jefferson | Wisconsin | 55055 | 2190 | 9 |
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);