ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 14 and county = "Jefferson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
403722 | 403722 | 2020-08-05 | Jefferson | Nebraska | 31095 | 14 | 0 |
400504 | 400504 | 2020-08-04 | Jefferson | Nebraska | 31095 | 14 | 0 |
397289 | 397289 | 2020-08-03 | Jefferson | Nebraska | 31095 | 14 | 0 |
394073 | 394073 | 2020-08-02 | Jefferson | Nebraska | 31095 | 14 | 0 |
390856 | 390856 | 2020-08-01 | Jefferson | Nebraska | 31095 | 14 | 0 |
387639 | 387639 | 2020-07-31 | Jefferson | Nebraska | 31095 | 14 | 0 |
384421 | 384421 | 2020-07-30 | Jefferson | Nebraska | 31095 | 14 | 0 |
352250 | 352250 | 2020-07-20 | Jefferson | Montana | 30043 | 14 | 0 |
349050 | 349050 | 2020-07-19 | Jefferson | Montana | 30043 | 14 | 0 |
345849 | 345849 | 2020-07-18 | Jefferson | Montana | 30043 | 14 | 0 |
342649 | 342649 | 2020-07-17 | Jefferson | Montana | 30043 | 14 | 0 |
208250 | 208250 | 2020-06-04 | Jefferson | Pennsylvania | 42065 | 14 | 0 |
205169 | 205169 | 2020-06-03 | Jefferson | Pennsylvania | 42065 | 14 | 0 |
170182 | 170182 | 2020-05-23 | Jefferson | Iowa | 19101 | 14 | 0 |
167145 | 167145 | 2020-05-22 | Jefferson | Iowa | 19101 | 14 | 0 |
164112 | 164112 | 2020-05-21 | Jefferson | Iowa | 19101 | 14 | 0 |
117401 | 117401 | 2020-05-05 | Jefferson | Oregon | 41031 | 14 | 0 |
114520 | 114520 | 2020-05-04 | Jefferson | Oregon | 41031 | 14 | 0 |
104313 | 104313 | 2020-05-01 | Jefferson | Georgia | 13163 | 14 | 1 |
101458 | 101458 | 2020-04-30 | Jefferson | Georgia | 13163 | 14 | 1 |
98608 | 98608 | 2020-04-29 | Jefferson | Georgia | 13163 | 14 | 1 |
95763 | 95763 | 2020-04-28 | Jefferson | Georgia | 13163 | 14 | 1 |
92931 | 92931 | 2020-04-27 | Jefferson | Georgia | 13163 | 14 | 1 |
90112 | 90112 | 2020-04-26 | Jefferson | Georgia | 13163 | 14 | 1 |
66782 | 66782 | 2020-04-17 | Jefferson | Tennessee | 47089 | 14 | 0 |
53205 | 53205 | 2020-04-12 | Jefferson | Tennessee | 47089 | 14 | 0 |
50530 | 50530 | 2020-04-11 | Jefferson | Tennessee | 47089 | 14 | 0 |
38031 | 38031 | 2020-04-06 | Jefferson | Wisconsin | 55055 | 14 | 0 |
34791 | 34791 | 2020-04-05 | Jefferson | Ohio | 39081 | 14 | 0 |
35545 | 35545 | 2020-04-05 | Jefferson | Wisconsin | 55055 | 14 | 0 |
32358 | 32358 | 2020-04-04 | Jefferson | Ohio | 39081 | 14 | 0 |
29969 | 29969 | 2020-04-03 | Jefferson | Ohio | 39081 | 14 | 0 |
23767 | 23767 | 2020-03-31 | Jefferson | Washington | 53031 | 14 | 0 |
21618 | 21618 | 2020-03-30 | Jefferson | Washington | 53031 | 14 | 0 |
19551 | 19551 | 2020-03-29 | Jefferson | Washington | 53031 | 14 | 0 |
4674 | 4674 | 2020-03-19 | Jefferson | Kentucky | 21111 | 14 | 1 |
2473 | 2473 | 2020-03-15 | Jefferson | Louisiana | 22051 | 14 | 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);