ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lucas" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922544 | 922544 | 2021-01-12 | Lucas | Ohio | 39095 | 29047 | 565 |
919299 | 919299 | 2021-01-11 | Lucas | Ohio | 39095 | 28841 | 559 |
916054 | 916054 | 2021-01-10 | Lucas | Ohio | 39095 | 28506 | 555 |
912809 | 912809 | 2021-01-09 | Lucas | Ohio | 39095 | 28189 | 554 |
909564 | 909564 | 2021-01-08 | Lucas | Ohio | 39095 | 27940 | 554 |
906319 | 906319 | 2021-01-07 | Lucas | Ohio | 39095 | 27608 | 554 |
903073 | 903073 | 2021-01-06 | Lucas | Ohio | 39095 | 27228 | 553 |
899828 | 899828 | 2021-01-05 | Lucas | Ohio | 39095 | 26934 | 553 |
896583 | 896583 | 2021-01-04 | Lucas | Ohio | 39095 | 26742 | 544 |
893337 | 893337 | 2021-01-03 | Lucas | Ohio | 39095 | 26509 | 541 |
890091 | 890091 | 2021-01-02 | Lucas | Ohio | 39095 | 26344 | 541 |
886844 | 886844 | 2021-01-01 | Lucas | Ohio | 39095 | 25805 | 541 |
883599 | 883599 | 2020-12-31 | Lucas | Ohio | 39095 | 25805 | 541 |
880354 | 880354 | 2020-12-30 | Lucas | Ohio | 39095 | 25505 | 541 |
877109 | 877109 | 2020-12-29 | Lucas | Ohio | 39095 | 25282 | 540 |
873864 | 873864 | 2020-12-28 | Lucas | Ohio | 39095 | 25051 | 535 |
870619 | 870619 | 2020-12-27 | Lucas | Ohio | 39095 | 24898 | 535 |
867374 | 867374 | 2020-12-26 | Lucas | Ohio | 39095 | 24744 | 535 |
864129 | 864129 | 2020-12-25 | Lucas | Ohio | 39095 | 24165 | 536 |
860884 | 860884 | 2020-12-24 | Lucas | Ohio | 39095 | 24165 | 536 |
857639 | 857639 | 2020-12-23 | Lucas | Ohio | 39095 | 23872 | 531 |
854394 | 854394 | 2020-12-22 | Lucas | Ohio | 39095 | 23571 | 513 |
851149 | 851149 | 2020-12-21 | Lucas | Ohio | 39095 | 23405 | 505 |
847904 | 847904 | 2020-12-20 | Lucas | Ohio | 39095 | 23166 | 504 |
844659 | 844659 | 2020-12-19 | Lucas | Ohio | 39095 | 22989 | 504 |
841413 | 841413 | 2020-12-18 | Lucas | Ohio | 39095 | 22718 | 502 |
838168 | 838168 | 2020-12-17 | Lucas | Ohio | 39095 | 22440 | 495 |
834922 | 834922 | 2020-12-16 | Lucas | Ohio | 39095 | 21988 | 495 |
831676 | 831676 | 2020-12-15 | Lucas | Ohio | 39095 | 21814 | 489 |
828429 | 828429 | 2020-12-14 | Lucas | Ohio | 39095 | 21577 | 483 |
825183 | 825183 | 2020-12-13 | Lucas | Ohio | 39095 | 21239 | 478 |
821936 | 821936 | 2020-12-12 | Lucas | Ohio | 39095 | 20916 | 478 |
818690 | 818690 | 2020-12-11 | Lucas | Ohio | 39095 | 20510 | 474 |
815444 | 815444 | 2020-12-10 | Lucas | Ohio | 39095 | 20006 | 465 |
812198 | 812198 | 2020-12-09 | Lucas | Ohio | 39095 | 19575 | 459 |
808954 | 808954 | 2020-12-08 | Lucas | Ohio | 39095 | 19084 | 458 |
805709 | 805709 | 2020-12-07 | Lucas | Ohio | 39095 | 18222 | 449 |
802464 | 802464 | 2020-12-06 | Lucas | Ohio | 39095 | 17920 | 449 |
799219 | 799219 | 2020-12-05 | Lucas | Ohio | 39095 | 17731 | 449 |
795974 | 795974 | 2020-12-04 | Lucas | Ohio | 39095 | 17277 | 446 |
792729 | 792729 | 2020-12-03 | Lucas | Ohio | 39095 | 17023 | 438 |
789484 | 789484 | 2020-12-02 | Lucas | Ohio | 39095 | 16765 | 436 |
786239 | 786239 | 2020-12-01 | Lucas | Ohio | 39095 | 16462 | 431 |
782995 | 782995 | 2020-11-30 | Lucas | Ohio | 39095 | 16137 | 426 |
779749 | 779749 | 2020-11-29 | Lucas | Ohio | 39095 | 15874 | 426 |
776504 | 776504 | 2020-11-28 | Lucas | Ohio | 39095 | 15640 | 420 |
773259 | 773259 | 2020-11-27 | Lucas | Ohio | 39095 | 15301 | 420 |
770014 | 770014 | 2020-11-26 | Lucas | Ohio | 39095 | 14566 | 417 |
766768 | 766768 | 2020-11-25 | Lucas | Ohio | 39095 | 14566 | 417 |
763523 | 763523 | 2020-11-24 | Lucas | Ohio | 39095 | 14317 | 414 |
760278 | 760278 | 2020-11-23 | Lucas | Ohio | 39095 | 14033 | 409 |
757033 | 757033 | 2020-11-22 | Lucas | Ohio | 39095 | 13446 | 406 |
753786 | 753786 | 2020-11-21 | Lucas | Ohio | 39095 | 13263 | 406 |
750540 | 750540 | 2020-11-20 | Lucas | Ohio | 39095 | 13035 | 405 |
747294 | 747294 | 2020-11-19 | Lucas | Ohio | 39095 | 12611 | 404 |
744048 | 744048 | 2020-11-18 | Lucas | Ohio | 39095 | 12443 | 404 |
740801 | 740801 | 2020-11-17 | Lucas | Ohio | 39095 | 12297 | 403 |
737555 | 737555 | 2020-11-16 | Lucas | Ohio | 39095 | 12097 | 400 |
734311 | 734311 | 2020-11-15 | Lucas | Ohio | 39095 | 11765 | 399 |
731065 | 731065 | 2020-11-14 | Lucas | Ohio | 39095 | 11454 | 398 |
727821 | 727821 | 2020-11-13 | Lucas | Ohio | 39095 | 11265 | 398 |
724577 | 724577 | 2020-11-12 | Lucas | Ohio | 39095 | 10922 | 394 |
721334 | 721334 | 2020-11-11 | Lucas | Ohio | 39095 | 10722 | 394 |
718091 | 718091 | 2020-11-10 | Lucas | Ohio | 39095 | 10565 | 393 |
714848 | 714848 | 2020-11-09 | Lucas | Ohio | 39095 | 10313 | 393 |
711604 | 711604 | 2020-11-08 | Lucas | Ohio | 39095 | 10169 | 393 |
708360 | 708360 | 2020-11-07 | Lucas | Ohio | 39095 | 9998 | 392 |
705117 | 705117 | 2020-11-06 | Lucas | Ohio | 39095 | 9863 | 392 |
701874 | 701874 | 2020-11-05 | Lucas | Ohio | 39095 | 9676 | 389 |
698630 | 698630 | 2020-11-04 | Lucas | Ohio | 39095 | 9473 | 389 |
695387 | 695387 | 2020-11-03 | Lucas | Ohio | 39095 | 9360 | 388 |
692145 | 692145 | 2020-11-02 | Lucas | Ohio | 39095 | 9168 | 388 |
688901 | 688901 | 2020-11-01 | Lucas | Ohio | 39095 | 9086 | 378 |
685656 | 685656 | 2020-10-31 | Lucas | Ohio | 39095 | 8990 | 378 |
682413 | 682413 | 2020-10-30 | Lucas | Ohio | 39095 | 8910 | 378 |
679170 | 679170 | 2020-10-29 | Lucas | Ohio | 39095 | 8789 | 378 |
675927 | 675927 | 2020-10-28 | Lucas | Ohio | 39095 | 8703 | 376 |
672684 | 672684 | 2020-10-27 | Lucas | Ohio | 39095 | 8647 | 376 |
669442 | 669442 | 2020-10-26 | Lucas | Ohio | 39095 | 8549 | 375 |
666198 | 666198 | 2020-10-25 | Lucas | Ohio | 39095 | 8494 | 375 |
662953 | 662953 | 2020-10-24 | Lucas | Ohio | 39095 | 8454 | 375 |
659709 | 659709 | 2020-10-23 | Lucas | Ohio | 39095 | 8364 | 373 |
656465 | 656465 | 2020-10-22 | Lucas | Ohio | 39095 | 8285 | 373 |
653220 | 653220 | 2020-10-21 | Lucas | Ohio | 39095 | 8223 | 373 |
649975 | 649975 | 2020-10-20 | Lucas | Ohio | 39095 | 8175 | 370 |
646731 | 646731 | 2020-10-19 | Lucas | Ohio | 39095 | 8123 | 370 |
643485 | 643485 | 2020-10-18 | Lucas | Ohio | 39095 | 8058 | 370 |
640237 | 640237 | 2020-10-17 | Lucas | Ohio | 39095 | 8026 | 370 |
636991 | 636991 | 2020-10-16 | Lucas | Ohio | 39095 | 7979 | 370 |
633745 | 633745 | 2020-10-15 | Lucas | Ohio | 39095 | 7931 | 370 |
630500 | 630500 | 2020-10-14 | Lucas | Ohio | 39095 | 7879 | 370 |
627256 | 627256 | 2020-10-13 | Lucas | Ohio | 39095 | 7823 | 370 |
624014 | 624014 | 2020-10-12 | Lucas | Ohio | 39095 | 7793 | 370 |
620771 | 620771 | 2020-10-11 | Lucas | Ohio | 39095 | 7756 | 370 |
617529 | 617529 | 2020-10-10 | Lucas | Ohio | 39095 | 7732 | 370 |
614287 | 614287 | 2020-10-09 | Lucas | Ohio | 39095 | 7704 | 370 |
611046 | 611046 | 2020-10-08 | Lucas | Ohio | 39095 | 7656 | 369 |
607804 | 607804 | 2020-10-07 | Lucas | Ohio | 39095 | 7624 | 369 |
604561 | 604561 | 2020-10-06 | Lucas | Ohio | 39095 | 7595 | 369 |
601319 | 601319 | 2020-10-05 | Lucas | Ohio | 39095 | 7562 | 369 |
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);