ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Clark" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922508 | 922508 | 2021-01-12 | Clark | Ohio | 39023 | 10177 | 260 |
919263 | 919263 | 2021-01-11 | Clark | Ohio | 39023 | 10057 | 251 |
916018 | 916018 | 2021-01-10 | Clark | Ohio | 39023 | 9945 | 248 |
912773 | 912773 | 2021-01-09 | Clark | Ohio | 39023 | 9876 | 247 |
909528 | 909528 | 2021-01-08 | Clark | Ohio | 39023 | 9758 | 247 |
906283 | 906283 | 2021-01-07 | Clark | Ohio | 39023 | 9624 | 244 |
903037 | 903037 | 2021-01-06 | Clark | Ohio | 39023 | 9494 | 240 |
899792 | 899792 | 2021-01-05 | Clark | Ohio | 39023 | 9380 | 207 |
896547 | 896547 | 2021-01-04 | Clark | Ohio | 39023 | 9303 | 189 |
893301 | 893301 | 2021-01-03 | Clark | Ohio | 39023 | 9240 | 186 |
890055 | 890055 | 2021-01-02 | Clark | Ohio | 39023 | 9151 | 186 |
886808 | 886808 | 2021-01-01 | Clark | Ohio | 39023 | 8988 | 186 |
883563 | 883563 | 2020-12-31 | Clark | Ohio | 39023 | 8988 | 186 |
880318 | 880318 | 2020-12-30 | Clark | Ohio | 39023 | 8868 | 186 |
877073 | 877073 | 2020-12-29 | Clark | Ohio | 39023 | 8763 | 184 |
873828 | 873828 | 2020-12-28 | Clark | Ohio | 39023 | 8686 | 179 |
870583 | 870583 | 2020-12-27 | Clark | Ohio | 39023 | 8651 | 179 |
867338 | 867338 | 2020-12-26 | Clark | Ohio | 39023 | 8586 | 179 |
864093 | 864093 | 2020-12-25 | Clark | Ohio | 39023 | 8449 | 179 |
860848 | 860848 | 2020-12-24 | Clark | Ohio | 39023 | 8449 | 179 |
857603 | 857603 | 2020-12-23 | Clark | Ohio | 39023 | 8353 | 179 |
854358 | 854358 | 2020-12-22 | Clark | Ohio | 39023 | 8280 | 173 |
851113 | 851113 | 2020-12-21 | Clark | Ohio | 39023 | 8196 | 173 |
847868 | 847868 | 2020-12-20 | Clark | Ohio | 39023 | 8144 | 172 |
844623 | 844623 | 2020-12-19 | Clark | Ohio | 39023 | 8058 | 172 |
841377 | 841377 | 2020-12-18 | Clark | Ohio | 39023 | 7973 | 152 |
838132 | 838132 | 2020-12-17 | Clark | Ohio | 39023 | 7859 | 150 |
834886 | 834886 | 2020-12-16 | Clark | Ohio | 39023 | 7697 | 150 |
831640 | 831640 | 2020-12-15 | Clark | Ohio | 39023 | 7669 | 150 |
828393 | 828393 | 2020-12-14 | Clark | Ohio | 39023 | 7547 | 150 |
825147 | 825147 | 2020-12-13 | Clark | Ohio | 39023 | 7384 | 150 |
821900 | 821900 | 2020-12-12 | Clark | Ohio | 39023 | 7261 | 150 |
818654 | 818654 | 2020-12-11 | Clark | Ohio | 39023 | 7081 | 148 |
815408 | 815408 | 2020-12-10 | Clark | Ohio | 39023 | 6951 | 147 |
812162 | 812162 | 2020-12-09 | Clark | Ohio | 39023 | 6803 | 147 |
808918 | 808918 | 2020-12-08 | Clark | Ohio | 39023 | 6669 | 147 |
805673 | 805673 | 2020-12-07 | Clark | Ohio | 39023 | 6473 | 146 |
802428 | 802428 | 2020-12-06 | Clark | Ohio | 39023 | 6386 | 144 |
799183 | 799183 | 2020-12-05 | Clark | Ohio | 39023 | 6295 | 144 |
795938 | 795938 | 2020-12-04 | Clark | Ohio | 39023 | 6171 | 143 |
792693 | 792693 | 2020-12-03 | Clark | Ohio | 39023 | 6038 | 142 |
789448 | 789448 | 2020-12-02 | Clark | Ohio | 39023 | 5907 | 140 |
786203 | 786203 | 2020-12-01 | Clark | Ohio | 39023 | 5799 | 137 |
782959 | 782959 | 2020-11-30 | Clark | Ohio | 39023 | 5711 | 131 |
779713 | 779713 | 2020-11-29 | Clark | Ohio | 39023 | 5637 | 131 |
776468 | 776468 | 2020-11-28 | Clark | Ohio | 39023 | 5546 | 129 |
773223 | 773223 | 2020-11-27 | Clark | Ohio | 39023 | 5438 | 129 |
769978 | 769978 | 2020-11-26 | Clark | Ohio | 39023 | 5218 | 101 |
766732 | 766732 | 2020-11-25 | Clark | Ohio | 39023 | 5218 | 101 |
763487 | 763487 | 2020-11-24 | Clark | Ohio | 39023 | 5114 | 64 |
760242 | 760242 | 2020-11-23 | Clark | Ohio | 39023 | 5010 | 64 |
756997 | 756997 | 2020-11-22 | Clark | Ohio | 39023 | 4866 | 64 |
753750 | 753750 | 2020-11-21 | Clark | Ohio | 39023 | 4799 | 64 |
750504 | 750504 | 2020-11-20 | Clark | Ohio | 39023 | 4633 | 64 |
747258 | 747258 | 2020-11-19 | Clark | Ohio | 39023 | 4499 | 64 |
744012 | 744012 | 2020-11-18 | Clark | Ohio | 39023 | 4389 | 62 |
740765 | 740765 | 2020-11-17 | Clark | Ohio | 39023 | 4327 | 62 |
737519 | 737519 | 2020-11-16 | Clark | Ohio | 39023 | 4230 | 62 |
734275 | 734275 | 2020-11-15 | Clark | Ohio | 39023 | 4145 | 62 |
731029 | 731029 | 2020-11-14 | Clark | Ohio | 39023 | 4011 | 62 |
727785 | 727785 | 2020-11-13 | Clark | Ohio | 39023 | 3915 | 62 |
724541 | 724541 | 2020-11-12 | Clark | Ohio | 39023 | 3750 | 62 |
721298 | 721298 | 2020-11-11 | Clark | Ohio | 39023 | 3650 | 62 |
718055 | 718055 | 2020-11-10 | Clark | Ohio | 39023 | 3580 | 58 |
714812 | 714812 | 2020-11-09 | Clark | Ohio | 39023 | 3493 | 58 |
711568 | 711568 | 2020-11-08 | Clark | Ohio | 39023 | 3414 | 58 |
708324 | 708324 | 2020-11-07 | Clark | Ohio | 39023 | 3350 | 58 |
705081 | 705081 | 2020-11-06 | Clark | Ohio | 39023 | 3259 | 58 |
701838 | 701838 | 2020-11-05 | Clark | Ohio | 39023 | 3193 | 57 |
698594 | 698594 | 2020-11-04 | Clark | Ohio | 39023 | 3126 | 57 |
695351 | 695351 | 2020-11-03 | Clark | Ohio | 39023 | 3069 | 57 |
692109 | 692109 | 2020-11-02 | Clark | Ohio | 39023 | 2982 | 57 |
688865 | 688865 | 2020-11-01 | Clark | Ohio | 39023 | 2924 | 57 |
685620 | 685620 | 2020-10-31 | Clark | Ohio | 39023 | 2863 | 57 |
682377 | 682377 | 2020-10-30 | Clark | Ohio | 39023 | 2821 | 57 |
679134 | 679134 | 2020-10-29 | Clark | Ohio | 39023 | 2766 | 57 |
675891 | 675891 | 2020-10-28 | Clark | Ohio | 39023 | 2705 | 57 |
672648 | 672648 | 2020-10-27 | Clark | Ohio | 39023 | 2668 | 57 |
669406 | 669406 | 2020-10-26 | Clark | Ohio | 39023 | 2631 | 57 |
666162 | 666162 | 2020-10-25 | Clark | Ohio | 39023 | 2598 | 57 |
662917 | 662917 | 2020-10-24 | Clark | Ohio | 39023 | 2565 | 57 |
659673 | 659673 | 2020-10-23 | Clark | Ohio | 39023 | 2530 | 57 |
656429 | 656429 | 2020-10-22 | Clark | Ohio | 39023 | 2494 | 56 |
653184 | 653184 | 2020-10-21 | Clark | Ohio | 39023 | 2451 | 56 |
649939 | 649939 | 2020-10-20 | Clark | Ohio | 39023 | 2424 | 54 |
646695 | 646695 | 2020-10-19 | Clark | Ohio | 39023 | 2379 | 54 |
643449 | 643449 | 2020-10-18 | Clark | Ohio | 39023 | 2316 | 54 |
640201 | 640201 | 2020-10-17 | Clark | Ohio | 39023 | 2296 | 54 |
636955 | 636955 | 2020-10-16 | Clark | Ohio | 39023 | 2279 | 53 |
633709 | 633709 | 2020-10-15 | Clark | Ohio | 39023 | 2246 | 52 |
630464 | 630464 | 2020-10-14 | Clark | Ohio | 39023 | 2197 | 52 |
627220 | 627220 | 2020-10-13 | Clark | Ohio | 39023 | 2167 | 52 |
623978 | 623978 | 2020-10-12 | Clark | Ohio | 39023 | 2152 | 52 |
620735 | 620735 | 2020-10-11 | Clark | Ohio | 39023 | 2123 | 52 |
617493 | 617493 | 2020-10-10 | Clark | Ohio | 39023 | 2100 | 52 |
614251 | 614251 | 2020-10-09 | Clark | Ohio | 39023 | 2077 | 52 |
611010 | 611010 | 2020-10-08 | Clark | Ohio | 39023 | 2048 | 52 |
607768 | 607768 | 2020-10-07 | Clark | Ohio | 39023 | 2010 | 49 |
604525 | 604525 | 2020-10-06 | Clark | Ohio | 39023 | 1987 | 47 |
601283 | 601283 | 2020-10-05 | Clark | Ohio | 39023 | 1959 | 42 |
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);