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" is on date 2020-12-10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
813374 | 813374 | 2020-12-10 | Jefferson | Alabama | 1073 | 38794 | 548 |
813482 | 813482 | 2020-12-10 | Jefferson | Arkansas | 5069 | 5557 | 116 |
813612 | 813612 | 2020-12-10 | Jefferson | Colorado | 8059 | 24779 | 538 |
813691 | 813691 | 2020-12-10 | Jefferson | Florida | 12065 | 816 | 12 |
813808 | 813808 | 2020-12-10 | Jefferson | Georgia | 13163 | 1083 | 40 |
813919 | 813919 | 2020-12-10 | Jefferson | Idaho | 16051 | 1828 | 11 |
813978 | 813978 | 2020-12-10 | Jefferson | Illinois | 17081 | 2267 | 65 |
814078 | 814078 | 2020-12-10 | Jefferson | Indiana | 18077 | 1595 | 22 |
814182 | 814182 | 2020-12-10 | Jefferson | Iowa | 19101 | 826 | 11 |
814275 | 814275 | 2020-12-10 | Jefferson | Kansas | 20087 | 880 | 9 |
814393 | 814393 | 2020-12-10 | Jefferson | Kentucky | 21111 | 43771 | 553 |
814483 | 814483 | 2020-12-10 | Jefferson | Louisiana | 22051 | 25991 | 641 |
814783 | 814783 | 2020-12-10 | Jefferson | Mississippi | 28063 | 403 | 12 |
814883 | 814883 | 2020-12-10 | Jefferson | Missouri | 29099 | 14011 | 113 |
814972 | 814972 | 2020-12-10 | Jefferson | Montana | 30043 | 597 | 1 |
815054 | 815054 | 2020-12-10 | Jefferson | Nebraska | 31095 | 477 | 0 |
815204 | 815204 | 2020-12-10 | Jefferson | New York | 36045 | 878 | 4 |
815437 | 815437 | 2020-12-10 | Jefferson | Ohio | 39081 | 2301 | 29 |
815518 | 815518 | 2020-12-10 | Jefferson | Oklahoma | 40067 | 284 | 2 |
815578 | 815578 | 2020-12-10 | Jefferson | Oregon | 41031 | 1086 | 11 |
815631 | 815631 | 2020-12-10 | Jefferson | Pennsylvania | 42065 | 1278 | 9 |
815907 | 815907 | 2020-12-10 | Jefferson | Tennessee | 47089 | 2757 | 38 |
816081 | 816081 | 2020-12-10 | Jefferson | Texas | 48245 | 11386 | 195 |
816409 | 816409 | 2020-12-10 | Jefferson | Washington | 53031 | 188 | 1 |
816452 | 816452 | 2020-12-10 | Jefferson | West Virginia | 54037 | 1724 | 17 |
816516 | 816516 | 2020-12-10 | Jefferson | Wisconsin | 55055 | 6400 | 48 |
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);