ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
720 rows where county = "Jackson" and fips = 46071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
314801 | 314801 | 2020-07-08 | Jackson | South Dakota | 46071 | 6 | 1 |
311628 | 311628 | 2020-07-07 | Jackson | South Dakota | 46071 | 6 | 1 |
308459 | 308459 | 2020-07-06 | Jackson | South Dakota | 46071 | 6 | 1 |
305291 | 305291 | 2020-07-05 | Jackson | South Dakota | 46071 | 6 | 1 |
302128 | 302128 | 2020-07-04 | Jackson | South Dakota | 46071 | 6 | 1 |
298964 | 298964 | 2020-07-03 | Jackson | South Dakota | 46071 | 6 | 1 |
295804 | 295804 | 2020-07-02 | Jackson | South Dakota | 46071 | 6 | 1 |
292648 | 292648 | 2020-07-01 | Jackson | South Dakota | 46071 | 6 | 1 |
289496 | 289496 | 2020-06-30 | Jackson | South Dakota | 46071 | 6 | 1 |
286345 | 286345 | 2020-06-29 | Jackson | South Dakota | 46071 | 6 | 1 |
283200 | 283200 | 2020-06-28 | Jackson | South Dakota | 46071 | 6 | 1 |
280054 | 280054 | 2020-06-27 | Jackson | South Dakota | 46071 | 6 | 1 |
276906 | 276906 | 2020-06-26 | Jackson | South Dakota | 46071 | 6 | 1 |
273759 | 273759 | 2020-06-25 | Jackson | South Dakota | 46071 | 6 | 1 |
270620 | 270620 | 2020-06-24 | Jackson | South Dakota | 46071 | 6 | 1 |
267486 | 267486 | 2020-06-23 | Jackson | South Dakota | 46071 | 6 | 1 |
264358 | 264358 | 2020-06-22 | Jackson | South Dakota | 46071 | 6 | 1 |
261230 | 261230 | 2020-06-21 | Jackson | South Dakota | 46071 | 6 | 1 |
258103 | 258103 | 2020-06-20 | Jackson | South Dakota | 46071 | 6 | 1 |
254977 | 254977 | 2020-06-19 | Jackson | South Dakota | 46071 | 6 | 1 |
251862 | 251862 | 2020-06-18 | Jackson | South Dakota | 46071 | 6 | 0 |
248747 | 248747 | 2020-06-17 | Jackson | South Dakota | 46071 | 6 | 0 |
245634 | 245634 | 2020-06-16 | Jackson | South Dakota | 46071 | 6 | 0 |
242522 | 242522 | 2020-06-15 | Jackson | South Dakota | 46071 | 5 | 0 |
239412 | 239412 | 2020-06-14 | Jackson | South Dakota | 46071 | 5 | 0 |
236304 | 236304 | 2020-06-13 | Jackson | South Dakota | 46071 | 5 | 0 |
233199 | 233199 | 2020-06-12 | Jackson | South Dakota | 46071 | 4 | 0 |
230094 | 230094 | 2020-06-11 | Jackson | South Dakota | 46071 | 4 | 0 |
226990 | 226990 | 2020-06-10 | Jackson | South Dakota | 46071 | 4 | 0 |
223890 | 223890 | 2020-06-09 | Jackson | South Dakota | 46071 | 4 | 0 |
220795 | 220795 | 2020-06-08 | Jackson | South Dakota | 46071 | 4 | 0 |
217703 | 217703 | 2020-06-07 | Jackson | South Dakota | 46071 | 4 | 0 |
214613 | 214613 | 2020-06-06 | Jackson | South Dakota | 46071 | 4 | 0 |
211526 | 211526 | 2020-06-05 | Jackson | South Dakota | 46071 | 4 | 0 |
208444 | 208444 | 2020-06-04 | Jackson | South Dakota | 46071 | 4 | 0 |
205362 | 205362 | 2020-06-03 | Jackson | South Dakota | 46071 | 4 | 0 |
202283 | 202283 | 2020-06-02 | Jackson | South Dakota | 46071 | 4 | 0 |
199208 | 199208 | 2020-06-01 | Jackson | South Dakota | 46071 | 4 | 0 |
196135 | 196135 | 2020-05-31 | Jackson | South Dakota | 46071 | 4 | 0 |
193065 | 193065 | 2020-05-30 | Jackson | South Dakota | 46071 | 4 | 0 |
190000 | 190000 | 2020-05-29 | Jackson | South Dakota | 46071 | 3 | 0 |
186937 | 186937 | 2020-05-28 | Jackson | South Dakota | 46071 | 3 | 0 |
183880 | 183880 | 2020-05-27 | Jackson | South Dakota | 46071 | 2 | 0 |
180830 | 180830 | 2020-05-26 | Jackson | South Dakota | 46071 | 2 | 0 |
177787 | 177787 | 2020-05-25 | Jackson | South Dakota | 46071 | 1 | 0 |
174743 | 174743 | 2020-05-24 | Jackson | South Dakota | 46071 | 1 | 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);