ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Racine" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
732160 | 732160 | 2020-11-14 | Racine | Wisconsin | 55101 | 12325 | 143 |
728915 | 728915 | 2020-11-13 | Racine | Wisconsin | 55101 | 12178 | 138 |
725672 | 725672 | 2020-11-12 | Racine | Wisconsin | 55101 | 11735 | 131 |
722429 | 722429 | 2020-11-11 | Racine | Wisconsin | 55101 | 11411 | 131 |
719186 | 719186 | 2020-11-10 | Racine | Wisconsin | 55101 | 11135 | 131 |
715943 | 715943 | 2020-11-09 | Racine | Wisconsin | 55101 | 10793 | 128 |
712699 | 712699 | 2020-11-08 | Racine | Wisconsin | 55101 | 10620 | 128 |
709455 | 709455 | 2020-11-07 | Racine | Wisconsin | 55101 | 10477 | 128 |
706211 | 706211 | 2020-11-06 | Racine | Wisconsin | 55101 | 10209 | 125 |
702968 | 702968 | 2020-11-05 | Racine | Wisconsin | 55101 | 9909 | 124 |
699725 | 699725 | 2020-11-04 | Racine | Wisconsin | 55101 | 9641 | 123 |
696481 | 696481 | 2020-11-03 | Racine | Wisconsin | 55101 | 9448 | 118 |
693239 | 693239 | 2020-11-02 | Racine | Wisconsin | 55101 | 9199 | 116 |
689995 | 689995 | 2020-11-01 | Racine | Wisconsin | 55101 | 9033 | 116 |
686750 | 686750 | 2020-10-31 | Racine | Wisconsin | 55101 | 8962 | 116 |
683507 | 683507 | 2020-10-30 | Racine | Wisconsin | 55101 | 8724 | 115 |
680264 | 680264 | 2020-10-29 | Racine | Wisconsin | 55101 | 8414 | 115 |
677021 | 677021 | 2020-10-28 | Racine | Wisconsin | 55101 | 8251 | 115 |
673778 | 673778 | 2020-10-27 | Racine | Wisconsin | 55101 | 8054 | 114 |
670536 | 670536 | 2020-10-26 | Racine | Wisconsin | 55101 | 7720 | 109 |
667293 | 667293 | 2020-10-25 | Racine | Wisconsin | 55101 | 7682 | 109 |
664048 | 664048 | 2020-10-24 | Racine | Wisconsin | 55101 | 7650 | 109 |
660804 | 660804 | 2020-10-23 | Racine | Wisconsin | 55101 | 7502 | 109 |
657560 | 657560 | 2020-10-22 | Racine | Wisconsin | 55101 | 7304 | 108 |
654315 | 654315 | 2020-10-21 | Racine | Wisconsin | 55101 | 7263 | 107 |
651070 | 651070 | 2020-10-20 | Racine | Wisconsin | 55101 | 7142 | 104 |
647826 | 647826 | 2020-10-19 | Racine | Wisconsin | 55101 | 6919 | 102 |
644580 | 644580 | 2020-10-18 | Racine | Wisconsin | 55101 | 6664 | 101 |
641332 | 641332 | 2020-10-17 | Racine | Wisconsin | 55101 | 6664 | 101 |
638085 | 638085 | 2020-10-16 | Racine | Wisconsin | 55101 | 6664 | 101 |
634840 | 634840 | 2020-10-15 | Racine | Wisconsin | 55101 | 6579 | 101 |
631595 | 631595 | 2020-10-14 | Racine | Wisconsin | 55101 | 6468 | 101 |
628351 | 628351 | 2020-10-13 | Racine | Wisconsin | 55101 | 6306 | 100 |
625108 | 625108 | 2020-10-12 | Racine | Wisconsin | 55101 | 6209 | 100 |
621865 | 621865 | 2020-10-11 | Racine | Wisconsin | 55101 | 6141 | 100 |
618622 | 618622 | 2020-10-10 | Racine | Wisconsin | 55101 | 6092 | 99 |
615380 | 615380 | 2020-10-09 | Racine | Wisconsin | 55101 | 6070 | 99 |
612139 | 612139 | 2020-10-08 | Racine | Wisconsin | 55101 | 6018 | 98 |
608897 | 608897 | 2020-10-07 | Racine | Wisconsin | 55101 | 5933 | 98 |
605654 | 605654 | 2020-10-06 | Racine | Wisconsin | 55101 | 5882 | 98 |
602412 | 602412 | 2020-10-05 | Racine | Wisconsin | 55101 | 5764 | 98 |
599169 | 599169 | 2020-10-04 | Racine | Wisconsin | 55101 | 5757 | 98 |
595926 | 595926 | 2020-10-03 | Racine | Wisconsin | 55101 | 5713 | 98 |
592684 | 592684 | 2020-10-02 | Racine | Wisconsin | 55101 | 5659 | 98 |
589444 | 589444 | 2020-10-01 | Racine | Wisconsin | 55101 | 5585 | 98 |
586203 | 586203 | 2020-09-30 | Racine | Wisconsin | 55101 | 5500 | 98 |
582963 | 582963 | 2020-09-29 | Racine | Wisconsin | 55101 | 5471 | 95 |
579724 | 579724 | 2020-09-28 | Racine | Wisconsin | 55101 | 5432 | 95 |
576483 | 576483 | 2020-09-27 | Racine | Wisconsin | 55101 | 5334 | 95 |
573239 | 573239 | 2020-09-26 | Racine | Wisconsin | 55101 | 5282 | 95 |
569997 | 569997 | 2020-09-25 | Racine | Wisconsin | 55101 | 5200 | 95 |
566756 | 566756 | 2020-09-24 | Racine | Wisconsin | 55101 | 5133 | 95 |
563515 | 563515 | 2020-09-23 | Racine | Wisconsin | 55101 | 5062 | 94 |
560276 | 560276 | 2020-09-22 | Racine | Wisconsin | 55101 | 5036 | 94 |
557040 | 557040 | 2020-09-21 | Racine | Wisconsin | 55101 | 4989 | 94 |
553803 | 553803 | 2020-09-20 | Racine | Wisconsin | 55101 | 4883 | 94 |
550564 | 550564 | 2020-09-19 | Racine | Wisconsin | 55101 | 4877 | 94 |
547325 | 547325 | 2020-09-18 | Racine | Wisconsin | 55101 | 4835 | 94 |
544088 | 544088 | 2020-09-17 | Racine | Wisconsin | 55101 | 4806 | 94 |
540852 | 540852 | 2020-09-16 | Racine | Wisconsin | 55101 | 4779 | 94 |
537615 | 537615 | 2020-09-15 | Racine | Wisconsin | 55101 | 4757 | 94 |
534379 | 534379 | 2020-09-14 | Racine | Wisconsin | 55101 | 4719 | 93 |
531144 | 531144 | 2020-09-13 | Racine | Wisconsin | 55101 | 4694 | 93 |
527907 | 527907 | 2020-09-12 | Racine | Wisconsin | 55101 | 4678 | 93 |
524671 | 524671 | 2020-09-11 | Racine | Wisconsin | 55101 | 4661 | 92 |
521435 | 521435 | 2020-09-10 | Racine | Wisconsin | 55101 | 4648 | 92 |
518198 | 518198 | 2020-09-09 | Racine | Wisconsin | 55101 | 4628 | 92 |
514963 | 514963 | 2020-09-08 | Racine | Wisconsin | 55101 | 4593 | 91 |
511730 | 511730 | 2020-09-07 | Racine | Wisconsin | 55101 | 4593 | 91 |
508497 | 508497 | 2020-09-06 | Racine | Wisconsin | 55101 | 4589 | 91 |
505265 | 505265 | 2020-09-05 | Racine | Wisconsin | 55101 | 4582 | 91 |
502031 | 502031 | 2020-09-04 | Racine | Wisconsin | 55101 | 4564 | 91 |
498797 | 498797 | 2020-09-03 | Racine | Wisconsin | 55101 | 4498 | 91 |
495564 | 495564 | 2020-09-02 | Racine | Wisconsin | 55101 | 4484 | 91 |
492330 | 492330 | 2020-09-01 | Racine | Wisconsin | 55101 | 4461 | 90 |
489097 | 489097 | 2020-08-31 | Racine | Wisconsin | 55101 | 4441 | 89 |
485864 | 485864 | 2020-08-30 | Racine | Wisconsin | 55101 | 4429 | 89 |
482629 | 482629 | 2020-08-29 | Racine | Wisconsin | 55101 | 4419 | 89 |
479395 | 479395 | 2020-08-28 | Racine | Wisconsin | 55101 | 4391 | 89 |
476162 | 476162 | 2020-08-27 | Racine | Wisconsin | 55101 | 4362 | 89 |
472929 | 472929 | 2020-08-26 | Racine | Wisconsin | 55101 | 4328 | 86 |
469697 | 469697 | 2020-08-25 | Racine | Wisconsin | 55101 | 4298 | 86 |
466468 | 466468 | 2020-08-24 | Racine | Wisconsin | 55101 | 4271 | 85 |
463239 | 463239 | 2020-08-23 | Racine | Wisconsin | 55101 | 4257 | 85 |
460010 | 460010 | 2020-08-22 | Racine | Wisconsin | 55101 | 4243 | 85 |
456783 | 456783 | 2020-08-21 | Racine | Wisconsin | 55101 | 4211 | 85 |
453555 | 453555 | 2020-08-20 | Racine | Wisconsin | 55101 | 4179 | 85 |
450327 | 450327 | 2020-08-19 | Racine | Wisconsin | 55101 | 4162 | 84 |
447099 | 447099 | 2020-08-18 | Racine | Wisconsin | 55101 | 4140 | 83 |
443872 | 443872 | 2020-08-17 | Racine | Wisconsin | 55101 | 4106 | 81 |
440646 | 440646 | 2020-08-16 | Racine | Wisconsin | 55101 | 4089 | 81 |
437420 | 437420 | 2020-08-15 | Racine | Wisconsin | 55101 | 4078 | 81 |
434194 | 434194 | 2020-08-14 | Racine | Wisconsin | 55101 | 4056 | 78 |
430969 | 430969 | 2020-08-13 | Racine | Wisconsin | 55101 | 4012 | 78 |
427741 | 427741 | 2020-08-12 | Racine | Wisconsin | 55101 | 3984 | 78 |
424517 | 424517 | 2020-08-11 | Racine | Wisconsin | 55101 | 3980 | 79 |
421296 | 421296 | 2020-08-10 | Racine | Wisconsin | 55101 | 3939 | 78 |
418075 | 418075 | 2020-08-09 | Racine | Wisconsin | 55101 | 3918 | 78 |
414854 | 414854 | 2020-08-08 | Racine | Wisconsin | 55101 | 3903 | 78 |
411634 | 411634 | 2020-08-07 | Racine | Wisconsin | 55101 | 3863 | 78 |
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);