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 2021-09-27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1758166 | 1758166 | 2021-09-27 | Jefferson | Alabama | 1073 | 111743 | 1765 |
1758275 | 1758275 | 2021-09-27 | Jefferson | Arkansas | 5069 | 12155 | 224 |
1758405 | 1758405 | 2021-09-27 | Jefferson | Colorado | 8059 | 57728 | 866 |
1758484 | 1758484 | 2021-09-27 | Jefferson | Florida | 12065 | 2400 | 36 |
1758601 | 1758601 | 2021-09-27 | Jefferson | Georgia | 13163 | 2590 | 74 |
1758713 | 1758713 | 2021-09-27 | Jefferson | Idaho | 16051 | 3604 | 35 |
1758772 | 1758772 | 2021-09-27 | Jefferson | Illinois | 17081 | 6154 | 137 |
1758873 | 1758873 | 2021-09-27 | Jefferson | Indiana | 18077 | 4790 | 93 |
1758977 | 1758977 | 2021-09-27 | Jefferson | Iowa | 19101 | 1783 | 38 |
1759070 | 1759070 | 2021-09-27 | Jefferson | Kansas | 20087 | 2418 | 46 |
1759187 | 1759187 | 2021-09-27 | Jefferson | Kentucky | 21111 | 109514 | 1489 |
1759277 | 1759277 | 2021-09-27 | Jefferson | Louisiana | 22051 | 68273 | 1115 |
1759576 | 1759576 | 2021-09-27 | Jefferson | Mississippi | 28063 | 915 | 33 |
1759676 | 1759676 | 2021-09-27 | Jefferson | Missouri | 29099 | 30311 | 298 |
1759765 | 1759765 | 2021-09-27 | Jefferson | Montana | 30043 | 1429 | 9 |
1759847 | 1759847 | 2021-09-27 | Jefferson | Nebraska | 31095 | 764 | 3 |
1759998 | 1759998 | 2021-09-27 | Jefferson | New York | 36045 | 7667 | 71 |
1760231 | 1760231 | 2021-09-27 | Jefferson | Ohio | 39081 | 7785 | 175 |
1760313 | 1760313 | 2021-09-27 | Jefferson | Oklahoma | 40067 | 886 | 18 |
1760373 | 1760373 | 2021-09-27 | Jefferson | Oregon | 41031 | 3297 | 48 |
1760426 | 1760426 | 2021-09-27 | Jefferson | Pennsylvania | 42065 | 4087 | 104 |
1760702 | 1760702 | 2021-09-27 | Jefferson | Tennessee | 47089 | 9388 | 134 |
1760876 | 1760876 | 2021-09-27 | Jefferson | Texas | 48245 | 30434 | 616 |
1761204 | 1761204 | 2021-09-27 | Jefferson | Washington | 53031 | 945 | 12 |
1761246 | 1761246 | 2021-09-27 | Jefferson | West Virginia | 54037 | 6187 | 73 |
1761310 | 1761310 | 2021-09-27 | Jefferson | Wisconsin | 55055 | 11058 | 144 |
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);