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 = "2022-01-01" 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 |
---|---|---|---|---|---|---|---|
2070147 | 2070147 | 2022-01-01 | Jefferson | Alabama | 1073 | 126583 | 2024 |
2070257 | 2070257 | 2022-01-01 | Jefferson | Arkansas | 5069 | 13153 | 235 |
2070387 | 2070387 | 2022-01-01 | Jefferson | Colorado | 8059 | 82540 | 1105 |
2070466 | 2070466 | 2022-01-01 | Jefferson | Florida | 12065 | 2634 | 36 |
2070583 | 2070583 | 2022-01-01 | Jefferson | Georgia | 13163 | 2887 | 94 |
2070695 | 2070695 | 2022-01-01 | Jefferson | Idaho | 16051 | 4610 | 53 |
2070754 | 2070754 | 2022-01-01 | Jefferson | Illinois | 17081 | 7536 | 151 |
2070855 | 2070855 | 2022-01-01 | Jefferson | Indiana | 18077 | 6754 | 116 |
2070959 | 2070959 | 2022-01-01 | Jefferson | Iowa | 19101 | 2555 | 44 |
2071052 | 2071052 | 2022-01-01 | Jefferson | Kansas | 20087 | 3238 | 53 |
2071169 | 2071169 | 2022-01-01 | Jefferson | Kentucky | 21111 | 143268 | 1834 |
2071259 | 2071259 | 2022-01-01 | Jefferson | Louisiana | 22051 | 77982 | 1193 |
2071559 | 2071559 | 2022-01-01 | Jefferson | Mississippi | 28063 | 994 | 35 |
2071659 | 2071659 | 2022-01-01 | Jefferson | Missouri | 29099 | 39372 | 459 |
2071748 | 2071748 | 2022-01-01 | Jefferson | Montana | 30043 | 1954 | 21 |
2071830 | 2071830 | 2022-01-01 | Jefferson | Nebraska | 31095 | 1007 | 3 |
2071981 | 2071981 | 2022-01-01 | Jefferson | New York | 36045 | 13354 | 118 |
2072215 | 2072215 | 2022-01-01 | Jefferson | Ohio | 39081 | 10833 | 251 |
2072297 | 2072297 | 2022-01-01 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2072357 | 2072357 | 2022-01-01 | Jefferson | Oregon | 41031 | 4437 | 69 |
2072410 | 2072410 | 2022-01-01 | Jefferson | Pennsylvania | 42065 | 6897 | 185 |
2072686 | 2072686 | 2022-01-01 | Jefferson | Tennessee | 47089 | 10836 | 215 |
2072860 | 2072860 | 2022-01-01 | Jefferson | Texas | 48245 | 33485 | 736 |
2073188 | 2073188 | 2022-01-01 | Jefferson | Washington | 53031 | 1447 | 21 |
2073230 | 2073230 | 2022-01-01 | Jefferson | West Virginia | 54037 | 9170 | 97 |
2073294 | 2073294 | 2022-01-01 | Jefferson | Wisconsin | 55055 | 15552 | 191 |
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);