ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Jackson" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638060 | 638060 | 2020-10-16 | Jackson | Wisconsin | 55053 | 261 | 1 |
634815 | 634815 | 2020-10-15 | Jackson | Wisconsin | 55053 | 252 | 1 |
631570 | 631570 | 2020-10-14 | Jackson | Wisconsin | 55053 | 230 | 1 |
628326 | 628326 | 2020-10-13 | Jackson | Wisconsin | 55053 | 223 | 1 |
625083 | 625083 | 2020-10-12 | Jackson | Wisconsin | 55053 | 215 | 1 |
621840 | 621840 | 2020-10-11 | Jackson | Wisconsin | 55053 | 215 | 1 |
618597 | 618597 | 2020-10-10 | Jackson | Wisconsin | 55053 | 209 | 1 |
615355 | 615355 | 2020-10-09 | Jackson | Wisconsin | 55053 | 207 | 1 |
612114 | 612114 | 2020-10-08 | Jackson | Wisconsin | 55053 | 199 | 1 |
608872 | 608872 | 2020-10-07 | Jackson | Wisconsin | 55053 | 194 | 1 |
605629 | 605629 | 2020-10-06 | Jackson | Wisconsin | 55053 | 186 | 1 |
602387 | 602387 | 2020-10-05 | Jackson | Wisconsin | 55053 | 182 | 1 |
599144 | 599144 | 2020-10-04 | Jackson | Wisconsin | 55053 | 181 | 1 |
595901 | 595901 | 2020-10-03 | Jackson | Wisconsin | 55053 | 177 | 1 |
592659 | 592659 | 2020-10-02 | Jackson | Wisconsin | 55053 | 172 | 1 |
589419 | 589419 | 2020-10-01 | Jackson | Wisconsin | 55053 | 168 | 1 |
586178 | 586178 | 2020-09-30 | Jackson | Wisconsin | 55053 | 160 | 1 |
582938 | 582938 | 2020-09-29 | Jackson | Wisconsin | 55053 | 156 | 1 |
579699 | 579699 | 2020-09-28 | Jackson | Wisconsin | 55053 | 154 | 1 |
576458 | 576458 | 2020-09-27 | Jackson | Wisconsin | 55053 | 154 | 1 |
573214 | 573214 | 2020-09-26 | Jackson | Wisconsin | 55053 | 149 | 1 |
569972 | 569972 | 2020-09-25 | Jackson | Wisconsin | 55053 | 137 | 1 |
566731 | 566731 | 2020-09-24 | Jackson | Wisconsin | 55053 | 129 | 1 |
563490 | 563490 | 2020-09-23 | Jackson | Wisconsin | 55053 | 119 | 1 |
560251 | 560251 | 2020-09-22 | Jackson | Wisconsin | 55053 | 111 | 1 |
557015 | 557015 | 2020-09-21 | Jackson | Wisconsin | 55053 | 110 | 1 |
553778 | 553778 | 2020-09-20 | Jackson | Wisconsin | 55053 | 110 | 1 |
550539 | 550539 | 2020-09-19 | Jackson | Wisconsin | 55053 | 110 | 1 |
547300 | 547300 | 2020-09-18 | Jackson | Wisconsin | 55053 | 102 | 1 |
544063 | 544063 | 2020-09-17 | Jackson | Wisconsin | 55053 | 99 | 1 |
540827 | 540827 | 2020-09-16 | Jackson | Wisconsin | 55053 | 97 | 1 |
537590 | 537590 | 2020-09-15 | Jackson | Wisconsin | 55053 | 97 | 1 |
534354 | 534354 | 2020-09-14 | Jackson | Wisconsin | 55053 | 95 | 1 |
531119 | 531119 | 2020-09-13 | Jackson | Wisconsin | 55053 | 93 | 1 |
527882 | 527882 | 2020-09-12 | Jackson | Wisconsin | 55053 | 92 | 1 |
524646 | 524646 | 2020-09-11 | Jackson | Wisconsin | 55053 | 90 | 1 |
521410 | 521410 | 2020-09-10 | Jackson | Wisconsin | 55053 | 89 | 1 |
518173 | 518173 | 2020-09-09 | Jackson | Wisconsin | 55053 | 80 | 1 |
514938 | 514938 | 2020-09-08 | Jackson | Wisconsin | 55053 | 81 | 1 |
511705 | 511705 | 2020-09-07 | Jackson | Wisconsin | 55053 | 81 | 1 |
508472 | 508472 | 2020-09-06 | Jackson | Wisconsin | 55053 | 80 | 1 |
505240 | 505240 | 2020-09-05 | Jackson | Wisconsin | 55053 | 80 | 1 |
502006 | 502006 | 2020-09-04 | Jackson | Wisconsin | 55053 | 80 | 1 |
498772 | 498772 | 2020-09-03 | Jackson | Wisconsin | 55053 | 77 | 1 |
495539 | 495539 | 2020-09-02 | Jackson | Wisconsin | 55053 | 76 | 1 |
492305 | 492305 | 2020-09-01 | Jackson | Wisconsin | 55053 | 76 | 1 |
489072 | 489072 | 2020-08-31 | Jackson | Wisconsin | 55053 | 76 | 1 |
485839 | 485839 | 2020-08-30 | Jackson | Wisconsin | 55053 | 76 | 1 |
482604 | 482604 | 2020-08-29 | Jackson | Wisconsin | 55053 | 76 | 1 |
479370 | 479370 | 2020-08-28 | Jackson | Wisconsin | 55053 | 75 | 1 |
476137 | 476137 | 2020-08-27 | Jackson | Wisconsin | 55053 | 74 | 1 |
472904 | 472904 | 2020-08-26 | Jackson | Wisconsin | 55053 | 72 | 1 |
469672 | 469672 | 2020-08-25 | Jackson | Wisconsin | 55053 | 71 | 1 |
466443 | 466443 | 2020-08-24 | Jackson | Wisconsin | 55053 | 71 | 1 |
463214 | 463214 | 2020-08-23 | Jackson | Wisconsin | 55053 | 71 | 1 |
459985 | 459985 | 2020-08-22 | Jackson | Wisconsin | 55053 | 70 | 1 |
456758 | 456758 | 2020-08-21 | Jackson | Wisconsin | 55053 | 66 | 1 |
453530 | 453530 | 2020-08-20 | Jackson | Wisconsin | 55053 | 65 | 1 |
450302 | 450302 | 2020-08-19 | Jackson | Wisconsin | 55053 | 65 | 1 |
447074 | 447074 | 2020-08-18 | Jackson | Wisconsin | 55053 | 62 | 1 |
443847 | 443847 | 2020-08-17 | Jackson | Wisconsin | 55053 | 62 | 1 |
440621 | 440621 | 2020-08-16 | Jackson | Wisconsin | 55053 | 62 | 1 |
437395 | 437395 | 2020-08-15 | Jackson | Wisconsin | 55053 | 60 | 1 |
434169 | 434169 | 2020-08-14 | Jackson | Wisconsin | 55053 | 61 | 1 |
430944 | 430944 | 2020-08-13 | Jackson | Wisconsin | 55053 | 60 | 1 |
427716 | 427716 | 2020-08-12 | Jackson | Wisconsin | 55053 | 59 | 1 |
424492 | 424492 | 2020-08-11 | Jackson | Wisconsin | 55053 | 58 | 1 |
421271 | 421271 | 2020-08-10 | Jackson | Wisconsin | 55053 | 58 | 1 |
418050 | 418050 | 2020-08-09 | Jackson | Wisconsin | 55053 | 58 | 1 |
414829 | 414829 | 2020-08-08 | Jackson | Wisconsin | 55053 | 58 | 1 |
411609 | 411609 | 2020-08-07 | Jackson | Wisconsin | 55053 | 55 | 1 |
408390 | 408390 | 2020-08-06 | Jackson | Wisconsin | 55053 | 52 | 1 |
405170 | 405170 | 2020-08-05 | Jackson | Wisconsin | 55053 | 50 | 1 |
401952 | 401952 | 2020-08-04 | Jackson | Wisconsin | 55053 | 49 | 1 |
398736 | 398736 | 2020-08-03 | Jackson | Wisconsin | 55053 | 49 | 1 |
395520 | 395520 | 2020-08-02 | Jackson | Wisconsin | 55053 | 48 | 1 |
392304 | 392304 | 2020-08-01 | Jackson | Wisconsin | 55053 | 47 | 1 |
389087 | 389087 | 2020-07-31 | Jackson | Wisconsin | 55053 | 46 | 1 |
385870 | 385870 | 2020-07-30 | Jackson | Wisconsin | 55053 | 45 | 1 |
382652 | 382652 | 2020-07-29 | Jackson | Wisconsin | 55053 | 43 | 1 |
379435 | 379435 | 2020-07-28 | Jackson | Wisconsin | 55053 | 43 | 1 |
376219 | 376219 | 2020-07-27 | Jackson | Wisconsin | 55053 | 40 | 1 |
373005 | 373005 | 2020-07-26 | Jackson | Wisconsin | 55053 | 39 | 1 |
369793 | 369793 | 2020-07-25 | Jackson | Wisconsin | 55053 | 37 | 1 |
366583 | 366583 | 2020-07-24 | Jackson | Wisconsin | 55053 | 38 | 1 |
363376 | 363376 | 2020-07-23 | Jackson | Wisconsin | 55053 | 38 | 1 |
360170 | 360170 | 2020-07-22 | Jackson | Wisconsin | 55053 | 37 | 1 |
356965 | 356965 | 2020-07-21 | Jackson | Wisconsin | 55053 | 36 | 1 |
353762 | 353762 | 2020-07-20 | Jackson | Wisconsin | 55053 | 37 | 1 |
350560 | 350560 | 2020-07-19 | Jackson | Wisconsin | 55053 | 36 | 1 |
347359 | 347359 | 2020-07-18 | Jackson | Wisconsin | 55053 | 36 | 1 |
344159 | 344159 | 2020-07-17 | Jackson | Wisconsin | 55053 | 36 | 1 |
340960 | 340960 | 2020-07-16 | Jackson | Wisconsin | 55053 | 36 | 1 |
337764 | 337764 | 2020-07-15 | Jackson | Wisconsin | 55053 | 37 | 1 |
334569 | 334569 | 2020-07-14 | Jackson | Wisconsin | 55053 | 36 | 1 |
331376 | 331376 | 2020-07-13 | Jackson | Wisconsin | 55053 | 36 | 1 |
328190 | 328190 | 2020-07-12 | Jackson | Wisconsin | 55053 | 35 | 1 |
325004 | 325004 | 2020-07-11 | Jackson | Wisconsin | 55053 | 34 | 1 |
321823 | 321823 | 2020-07-10 | Jackson | Wisconsin | 55053 | 34 | 1 |
318644 | 318644 | 2020-07-09 | Jackson | Wisconsin | 55053 | 32 | 1 |
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);