ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where deaths = 3, fips = 55005 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
518149 | 518149 | 2020-09-09 | Barron | Wisconsin | 55005 | 413 | 3 |
514914 | 514914 | 2020-09-08 | Barron | Wisconsin | 55005 | 412 | 3 |
511681 | 511681 | 2020-09-07 | Barron | Wisconsin | 55005 | 411 | 3 |
508448 | 508448 | 2020-09-06 | Barron | Wisconsin | 55005 | 407 | 3 |
505216 | 505216 | 2020-09-05 | Barron | Wisconsin | 55005 | 404 | 3 |
501982 | 501982 | 2020-09-04 | Barron | Wisconsin | 55005 | 401 | 3 |
498748 | 498748 | 2020-09-03 | Barron | Wisconsin | 55005 | 381 | 3 |
495515 | 495515 | 2020-09-02 | Barron | Wisconsin | 55005 | 375 | 3 |
492281 | 492281 | 2020-09-01 | Barron | Wisconsin | 55005 | 372 | 3 |
489048 | 489048 | 2020-08-31 | Barron | Wisconsin | 55005 | 370 | 3 |
485815 | 485815 | 2020-08-30 | Barron | Wisconsin | 55005 | 370 | 3 |
482580 | 482580 | 2020-08-29 | Barron | Wisconsin | 55005 | 371 | 3 |
479346 | 479346 | 2020-08-28 | Barron | Wisconsin | 55005 | 367 | 3 |
476113 | 476113 | 2020-08-27 | Barron | Wisconsin | 55005 | 363 | 3 |
472880 | 472880 | 2020-08-26 | Barron | Wisconsin | 55005 | 362 | 3 |
469648 | 469648 | 2020-08-25 | Barron | Wisconsin | 55005 | 359 | 3 |
466419 | 466419 | 2020-08-24 | Barron | Wisconsin | 55005 | 358 | 3 |
463190 | 463190 | 2020-08-23 | Barron | Wisconsin | 55005 | 358 | 3 |
459961 | 459961 | 2020-08-22 | Barron | Wisconsin | 55005 | 353 | 3 |
456734 | 456734 | 2020-08-21 | Barron | Wisconsin | 55005 | 347 | 3 |
453506 | 453506 | 2020-08-20 | Barron | Wisconsin | 55005 | 346 | 3 |
450278 | 450278 | 2020-08-19 | Barron | Wisconsin | 55005 | 343 | 3 |
447050 | 447050 | 2020-08-18 | Barron | Wisconsin | 55005 | 336 | 3 |
443823 | 443823 | 2020-08-17 | Barron | Wisconsin | 55005 | 328 | 3 |
440597 | 440597 | 2020-08-16 | Barron | Wisconsin | 55005 | 326 | 3 |
437371 | 437371 | 2020-08-15 | Barron | Wisconsin | 55005 | 323 | 3 |
434145 | 434145 | 2020-08-14 | Barron | Wisconsin | 55005 | 320 | 3 |
430920 | 430920 | 2020-08-13 | Barron | Wisconsin | 55005 | 315 | 3 |
427692 | 427692 | 2020-08-12 | Barron | Wisconsin | 55005 | 308 | 3 |
424468 | 424468 | 2020-08-11 | Barron | Wisconsin | 55005 | 296 | 3 |
421247 | 421247 | 2020-08-10 | Barron | Wisconsin | 55005 | 295 | 3 |
418026 | 418026 | 2020-08-09 | Barron | Wisconsin | 55005 | 293 | 3 |
414805 | 414805 | 2020-08-08 | Barron | Wisconsin | 55005 | 291 | 3 |
411585 | 411585 | 2020-08-07 | Barron | Wisconsin | 55005 | 282 | 3 |
408366 | 408366 | 2020-08-06 | Barron | Wisconsin | 55005 | 276 | 3 |
405146 | 405146 | 2020-08-05 | Barron | Wisconsin | 55005 | 273 | 3 |
401928 | 401928 | 2020-08-04 | Barron | Wisconsin | 55005 | 264 | 3 |
398712 | 398712 | 2020-08-03 | Barron | Wisconsin | 55005 | 259 | 3 |
395496 | 395496 | 2020-08-02 | Barron | Wisconsin | 55005 | 255 | 3 |
392280 | 392280 | 2020-08-01 | Barron | Wisconsin | 55005 | 253 | 3 |
389063 | 389063 | 2020-07-31 | Barron | Wisconsin | 55005 | 228 | 3 |
385846 | 385846 | 2020-07-30 | Barron | Wisconsin | 55005 | 207 | 3 |
382628 | 382628 | 2020-07-29 | Barron | Wisconsin | 55005 | 145 | 3 |
379411 | 379411 | 2020-07-28 | Barron | Wisconsin | 55005 | 133 | 3 |
376195 | 376195 | 2020-07-27 | Barron | Wisconsin | 55005 | 125 | 3 |
372981 | 372981 | 2020-07-26 | Barron | Wisconsin | 55005 | 116 | 3 |
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);