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-09-11 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
521516 | 521516 | 2020-09-11 | Jefferson | Alabama | 1073 | 17908 | 318 |
521623 | 521623 | 2020-09-11 | Jefferson | Arkansas | 5069 | 2431 | 55 |
521753 | 521753 | 2020-09-11 | Jefferson | Colorado | 8059 | 5052 | 244 |
521831 | 521831 | 2020-09-11 | Jefferson | Florida | 12065 | 529 | 7 |
521948 | 521948 | 2020-09-11 | Jefferson | Georgia | 13163 | 734 | 21 |
522058 | 522058 | 2020-09-11 | Jefferson | Idaho | 16051 | 403 | 1 |
522117 | 522117 | 2020-09-11 | Jefferson | Illinois | 17081 | 504 | 37 |
522218 | 522218 | 2020-09-11 | Jefferson | Indiana | 18077 | 228 | 3 |
522322 | 522322 | 2020-09-11 | Jefferson | Iowa | 19101 | 126 | 1 |
522415 | 522415 | 2020-09-11 | Jefferson | Kansas | 20087 | 144 | 0 |
522532 | 522532 | 2020-09-11 | Jefferson | Kentucky | 21111 | 14771 | 307 |
522622 | 522622 | 2020-09-11 | Jefferson | Louisiana | 22051 | 16974 | 559 |
522922 | 522922 | 2020-09-11 | Jefferson | Mississippi | 28063 | 231 | 9 |
523022 | 523022 | 2020-09-11 | Jefferson | Missouri | 29099 | 3336 | 52 |
523110 | 523110 | 2020-09-11 | Jefferson | Montana | 30043 | 45 | 0 |
523188 | 523188 | 2020-09-11 | Jefferson | Nebraska | 31095 | 26 | 0 |
523338 | 523338 | 2020-09-11 | Jefferson | New York | 36045 | 157 | 1 |
523572 | 523572 | 2020-09-11 | Jefferson | Ohio | 39081 | 304 | 4 |
523653 | 523653 | 2020-09-11 | Jefferson | Oklahoma | 40067 | 37 | 0 |
523713 | 523713 | 2020-09-11 | Jefferson | Oregon | 41031 | 482 | 8 |
523765 | 523765 | 2020-09-11 | Jefferson | Pennsylvania | 42065 | 101 | 2 |
524041 | 524041 | 2020-09-11 | Jefferson | Tennessee | 47089 | 970 | 13 |
524214 | 524214 | 2020-09-11 | Jefferson | Texas | 48245 | 6912 | 122 |
524540 | 524540 | 2020-09-11 | Jefferson | Washington | 53031 | 70 | 0 |
524583 | 524583 | 2020-09-11 | Jefferson | West Virginia | 54037 | 398 | 4 |
524647 | 524647 | 2020-09-11 | Jefferson | Wisconsin | 55055 | 1101 | 7 |
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);