ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where cases = 44 and county = "Jefferson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
- Kansas 3
- Indiana 2
- Oregon 2
- Georgia 1
- Iowa 1
- New York 1
- Oklahoma 1
- Washington 1
- West Virginia 1
county 1
- Jefferson · 13 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
588425 | 588425 | 2020-10-01 | Jefferson | Oklahoma | 40067 | 44 | 0 |
357965 | 357965 | 2020-07-22 | Jefferson | Kansas | 20087 | 44 | 0 |
354763 | 354763 | 2020-07-21 | Jefferson | Kansas | 20087 | 44 | 0 |
351561 | 351561 | 2020-07-20 | Jefferson | Kansas | 20087 | 44 | 0 |
334465 | 334465 | 2020-07-14 | Jefferson | Washington | 53031 | 44 | 0 |
231639 | 231639 | 2020-06-12 | Jefferson | Iowa | 19101 | 44 | 0 |
200380 | 200380 | 2020-06-02 | Jefferson | Georgia | 13163 | 44 | 1 |
202040 | 202040 | 2020-06-02 | Jefferson | Oregon | 41031 | 44 | 0 |
198965 | 198965 | 2020-06-01 | Jefferson | Oregon | 41031 | 44 | 0 |
188364 | 188364 | 2020-05-29 | Jefferson | Indiana | 18077 | 44 | 1 |
185306 | 185306 | 2020-05-28 | Jefferson | Indiana | 18077 | 44 | 1 |
49994 | 49994 | 2020-04-11 | Jefferson | New York | 36045 | 44 | 0 |
48315 | 48315 | 2020-04-10 | Jefferson | West Virginia | 54037 | 44 | 0 |
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);