ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
743 rows where county = "Lincoln" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638068 | 638068 | 2020-10-16 | Lincoln | Wisconsin | 55069 | 528 | 5 |
634823 | 634823 | 2020-10-15 | Lincoln | Wisconsin | 55069 | 502 | 4 |
631578 | 631578 | 2020-10-14 | Lincoln | Wisconsin | 55069 | 478 | 4 |
628334 | 628334 | 2020-10-13 | Lincoln | Wisconsin | 55069 | 464 | 3 |
625091 | 625091 | 2020-10-12 | Lincoln | Wisconsin | 55069 | 454 | 4 |
621848 | 621848 | 2020-10-11 | Lincoln | Wisconsin | 55069 | 437 | 4 |
618605 | 618605 | 2020-10-10 | Lincoln | Wisconsin | 55069 | 417 | 3 |
615363 | 615363 | 2020-10-09 | Lincoln | Wisconsin | 55069 | 401 | 3 |
612122 | 612122 | 2020-10-08 | Lincoln | Wisconsin | 55069 | 388 | 3 |
608880 | 608880 | 2020-10-07 | Lincoln | Wisconsin | 55069 | 382 | 2 |
605637 | 605637 | 2020-10-06 | Lincoln | Wisconsin | 55069 | 359 | 2 |
602395 | 602395 | 2020-10-05 | Lincoln | Wisconsin | 55069 | 350 | 1 |
599152 | 599152 | 2020-10-04 | Lincoln | Wisconsin | 55069 | 324 | 1 |
595909 | 595909 | 2020-10-03 | Lincoln | Wisconsin | 55069 | 306 | 1 |
592667 | 592667 | 2020-10-02 | Lincoln | Wisconsin | 55069 | 288 | 1 |
589427 | 589427 | 2020-10-01 | Lincoln | Wisconsin | 55069 | 274 | 1 |
586186 | 586186 | 2020-09-30 | Lincoln | Wisconsin | 55069 | 255 | 1 |
582946 | 582946 | 2020-09-29 | Lincoln | Wisconsin | 55069 | 245 | 1 |
579707 | 579707 | 2020-09-28 | Lincoln | Wisconsin | 55069 | 240 | 1 |
576466 | 576466 | 2020-09-27 | Lincoln | Wisconsin | 55069 | 222 | 1 |
573222 | 573222 | 2020-09-26 | Lincoln | Wisconsin | 55069 | 217 | 1 |
569980 | 569980 | 2020-09-25 | Lincoln | Wisconsin | 55069 | 197 | 1 |
566739 | 566739 | 2020-09-24 | Lincoln | Wisconsin | 55069 | 186 | 1 |
563498 | 563498 | 2020-09-23 | Lincoln | Wisconsin | 55069 | 181 | 1 |
560259 | 560259 | 2020-09-22 | Lincoln | Wisconsin | 55069 | 169 | 1 |
557023 | 557023 | 2020-09-21 | Lincoln | Wisconsin | 55069 | 153 | 1 |
553786 | 553786 | 2020-09-20 | Lincoln | Wisconsin | 55069 | 146 | 1 |
550547 | 550547 | 2020-09-19 | Lincoln | Wisconsin | 55069 | 142 | 1 |
547308 | 547308 | 2020-09-18 | Lincoln | Wisconsin | 55069 | 137 | 1 |
544071 | 544071 | 2020-09-17 | Lincoln | Wisconsin | 55069 | 133 | 1 |
540835 | 540835 | 2020-09-16 | Lincoln | Wisconsin | 55069 | 127 | 1 |
537598 | 537598 | 2020-09-15 | Lincoln | Wisconsin | 55069 | 123 | 1 |
534362 | 534362 | 2020-09-14 | Lincoln | Wisconsin | 55069 | 118 | 1 |
531127 | 531127 | 2020-09-13 | Lincoln | Wisconsin | 55069 | 118 | 1 |
527890 | 527890 | 2020-09-12 | Lincoln | Wisconsin | 55069 | 111 | 1 |
524654 | 524654 | 2020-09-11 | Lincoln | Wisconsin | 55069 | 106 | 1 |
521418 | 521418 | 2020-09-10 | Lincoln | Wisconsin | 55069 | 104 | 1 |
518181 | 518181 | 2020-09-09 | Lincoln | Wisconsin | 55069 | 102 | 1 |
514946 | 514946 | 2020-09-08 | Lincoln | Wisconsin | 55069 | 97 | 1 |
511713 | 511713 | 2020-09-07 | Lincoln | Wisconsin | 55069 | 95 | 1 |
508480 | 508480 | 2020-09-06 | Lincoln | Wisconsin | 55069 | 94 | 1 |
505248 | 505248 | 2020-09-05 | Lincoln | Wisconsin | 55069 | 93 | 1 |
502014 | 502014 | 2020-09-04 | Lincoln | Wisconsin | 55069 | 92 | 1 |
498780 | 498780 | 2020-09-03 | Lincoln | Wisconsin | 55069 | 85 | 1 |
495547 | 495547 | 2020-09-02 | Lincoln | Wisconsin | 55069 | 85 | 1 |
492313 | 492313 | 2020-09-01 | Lincoln | Wisconsin | 55069 | 84 | 1 |
489080 | 489080 | 2020-08-31 | Lincoln | Wisconsin | 55069 | 83 | 1 |
485847 | 485847 | 2020-08-30 | Lincoln | Wisconsin | 55069 | 82 | 1 |
482612 | 482612 | 2020-08-29 | Lincoln | Wisconsin | 55069 | 82 | 1 |
479378 | 479378 | 2020-08-28 | Lincoln | Wisconsin | 55069 | 81 | 1 |
476145 | 476145 | 2020-08-27 | Lincoln | Wisconsin | 55069 | 78 | 1 |
472912 | 472912 | 2020-08-26 | Lincoln | Wisconsin | 55069 | 76 | 1 |
469680 | 469680 | 2020-08-25 | Lincoln | Wisconsin | 55069 | 76 | 1 |
466451 | 466451 | 2020-08-24 | Lincoln | Wisconsin | 55069 | 76 | 1 |
463222 | 463222 | 2020-08-23 | Lincoln | Wisconsin | 55069 | 76 | 1 |
459993 | 459993 | 2020-08-22 | Lincoln | Wisconsin | 55069 | 75 | 1 |
456766 | 456766 | 2020-08-21 | Lincoln | Wisconsin | 55069 | 74 | 1 |
453538 | 453538 | 2020-08-20 | Lincoln | Wisconsin | 55069 | 73 | 1 |
450310 | 450310 | 2020-08-19 | Lincoln | Wisconsin | 55069 | 73 | 1 |
447082 | 447082 | 2020-08-18 | Lincoln | Wisconsin | 55069 | 73 | 1 |
443855 | 443855 | 2020-08-17 | Lincoln | Wisconsin | 55069 | 73 | 0 |
440629 | 440629 | 2020-08-16 | Lincoln | Wisconsin | 55069 | 73 | 0 |
437403 | 437403 | 2020-08-15 | Lincoln | Wisconsin | 55069 | 73 | 0 |
434177 | 434177 | 2020-08-14 | Lincoln | Wisconsin | 55069 | 73 | 0 |
430952 | 430952 | 2020-08-13 | Lincoln | Wisconsin | 55069 | 71 | 0 |
427724 | 427724 | 2020-08-12 | Lincoln | Wisconsin | 55069 | 70 | 0 |
424500 | 424500 | 2020-08-11 | Lincoln | Wisconsin | 55069 | 69 | 0 |
421279 | 421279 | 2020-08-10 | Lincoln | Wisconsin | 55069 | 68 | 0 |
418058 | 418058 | 2020-08-09 | Lincoln | Wisconsin | 55069 | 68 | 0 |
414837 | 414837 | 2020-08-08 | Lincoln | Wisconsin | 55069 | 68 | 0 |
411617 | 411617 | 2020-08-07 | Lincoln | Wisconsin | 55069 | 67 | 0 |
408398 | 408398 | 2020-08-06 | Lincoln | Wisconsin | 55069 | 65 | 0 |
405178 | 405178 | 2020-08-05 | Lincoln | Wisconsin | 55069 | 66 | 0 |
401960 | 401960 | 2020-08-04 | Lincoln | Wisconsin | 55069 | 65 | 0 |
398744 | 398744 | 2020-08-03 | Lincoln | Wisconsin | 55069 | 64 | 0 |
395528 | 395528 | 2020-08-02 | Lincoln | Wisconsin | 55069 | 63 | 0 |
392312 | 392312 | 2020-08-01 | Lincoln | Wisconsin | 55069 | 61 | 0 |
389095 | 389095 | 2020-07-31 | Lincoln | Wisconsin | 55069 | 60 | 0 |
385878 | 385878 | 2020-07-30 | Lincoln | Wisconsin | 55069 | 60 | 0 |
382660 | 382660 | 2020-07-29 | Lincoln | Wisconsin | 55069 | 56 | 0 |
379443 | 379443 | 2020-07-28 | Lincoln | Wisconsin | 55069 | 56 | 0 |
376227 | 376227 | 2020-07-27 | Lincoln | Wisconsin | 55069 | 55 | 0 |
373013 | 373013 | 2020-07-26 | Lincoln | Wisconsin | 55069 | 52 | 0 |
369801 | 369801 | 2020-07-25 | Lincoln | Wisconsin | 55069 | 52 | 0 |
366591 | 366591 | 2020-07-24 | Lincoln | Wisconsin | 55069 | 50 | 0 |
363384 | 363384 | 2020-07-23 | Lincoln | Wisconsin | 55069 | 49 | 0 |
360178 | 360178 | 2020-07-22 | Lincoln | Wisconsin | 55069 | 46 | 0 |
356973 | 356973 | 2020-07-21 | Lincoln | Wisconsin | 55069 | 40 | 0 |
353770 | 353770 | 2020-07-20 | Lincoln | Wisconsin | 55069 | 37 | 0 |
350568 | 350568 | 2020-07-19 | Lincoln | Wisconsin | 55069 | 35 | 0 |
347367 | 347367 | 2020-07-18 | Lincoln | Wisconsin | 55069 | 33 | 0 |
344167 | 344167 | 2020-07-17 | Lincoln | Wisconsin | 55069 | 31 | 0 |
340968 | 340968 | 2020-07-16 | Lincoln | Wisconsin | 55069 | 25 | 0 |
337772 | 337772 | 2020-07-15 | Lincoln | Wisconsin | 55069 | 24 | 0 |
334577 | 334577 | 2020-07-14 | Lincoln | Wisconsin | 55069 | 22 | 0 |
331384 | 331384 | 2020-07-13 | Lincoln | Wisconsin | 55069 | 23 | 0 |
328198 | 328198 | 2020-07-12 | Lincoln | Wisconsin | 55069 | 22 | 0 |
325012 | 325012 | 2020-07-11 | Lincoln | Wisconsin | 55069 | 21 | 0 |
321831 | 321831 | 2020-07-10 | Lincoln | Wisconsin | 55069 | 20 | 0 |
318652 | 318652 | 2020-07-09 | Lincoln | Wisconsin | 55069 | 21 | 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);