ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
253 rows where cases = 2 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
108645 | 108645 | 2020-05-02 | Meigs | Ohio | 39105 | 2 | 0 |
105778 | 105778 | 2020-05-01 | Meigs | Ohio | 39105 | 2 | 0 |
102915 | 102915 | 2020-04-30 | Meigs | Ohio | 39105 | 2 | 0 |
100062 | 100062 | 2020-04-29 | Meigs | Ohio | 39105 | 2 | 0 |
97213 | 97213 | 2020-04-28 | Meigs | Ohio | 39105 | 2 | 0 |
97216 | 97216 | 2020-04-28 | Monroe | Ohio | 39111 | 2 | 0 |
94376 | 94376 | 2020-04-27 | Meigs | Ohio | 39105 | 2 | 0 |
94379 | 94379 | 2020-04-27 | Monroe | Ohio | 39111 | 2 | 0 |
91550 | 91550 | 2020-04-26 | Meigs | Ohio | 39105 | 2 | 0 |
91553 | 91553 | 2020-04-26 | Monroe | Ohio | 39111 | 2 | 0 |
88715 | 88715 | 2020-04-25 | Harrison | Ohio | 39067 | 2 | 0 |
88734 | 88734 | 2020-04-25 | Meigs | Ohio | 39105 | 2 | 0 |
88737 | 88737 | 2020-04-25 | Monroe | Ohio | 39111 | 2 | 0 |
85901 | 85901 | 2020-04-24 | Harrison | Ohio | 39067 | 2 | 0 |
85920 | 85920 | 2020-04-24 | Meigs | Ohio | 39105 | 2 | 0 |
85923 | 85923 | 2020-04-24 | Monroe | Ohio | 39111 | 2 | 0 |
85933 | 85933 | 2020-04-24 | Pike | Ohio | 39131 | 2 | 0 |
83097 | 83097 | 2020-04-23 | Harrison | Ohio | 39067 | 2 | 0 |
83116 | 83116 | 2020-04-23 | Meigs | Ohio | 39105 | 2 | 0 |
83119 | 83119 | 2020-04-23 | Monroe | Ohio | 39111 | 2 | 0 |
83129 | 83129 | 2020-04-23 | Pike | Ohio | 39131 | 2 | 0 |
80298 | 80298 | 2020-04-22 | Harrison | Ohio | 39067 | 2 | 0 |
80317 | 80317 | 2020-04-22 | Meigs | Ohio | 39105 | 2 | 0 |
80320 | 80320 | 2020-04-22 | Monroe | Ohio | 39111 | 2 | 0 |
80330 | 80330 | 2020-04-22 | Pike | Ohio | 39131 | 2 | 0 |
77508 | 77508 | 2020-04-21 | Harrison | Ohio | 39067 | 2 | 0 |
77527 | 77527 | 2020-04-21 | Meigs | Ohio | 39105 | 2 | 0 |
77530 | 77530 | 2020-04-21 | Monroe | Ohio | 39111 | 2 | 0 |
77540 | 77540 | 2020-04-21 | Pike | Ohio | 39131 | 2 | 0 |
74727 | 74727 | 2020-04-20 | Harrison | Ohio | 39067 | 2 | 0 |
74746 | 74746 | 2020-04-20 | Meigs | Ohio | 39105 | 2 | 0 |
74749 | 74749 | 2020-04-20 | Monroe | Ohio | 39111 | 2 | 0 |
74759 | 74759 | 2020-04-20 | Pike | Ohio | 39131 | 2 | 0 |
71952 | 71952 | 2020-04-19 | Harrison | Ohio | 39067 | 2 | 0 |
71971 | 71971 | 2020-04-19 | Meigs | Ohio | 39105 | 2 | 0 |
71974 | 71974 | 2020-04-19 | Monroe | Ohio | 39111 | 2 | 0 |
69185 | 69185 | 2020-04-18 | Harrison | Ohio | 39067 | 2 | 0 |
69204 | 69204 | 2020-04-18 | Meigs | Ohio | 39105 | 2 | 0 |
69207 | 69207 | 2020-04-18 | Monroe | Ohio | 39111 | 2 | 0 |
69232 | 69232 | 2020-04-18 | Van Wert | Ohio | 39161 | 2 | 0 |
66428 | 66428 | 2020-04-17 | Harrison | Ohio | 39067 | 2 | 0 |
66447 | 66447 | 2020-04-17 | Meigs | Ohio | 39105 | 2 | 0 |
66450 | 66450 | 2020-04-17 | Monroe | Ohio | 39111 | 2 | 0 |
66475 | 66475 | 2020-04-17 | Van Wert | Ohio | 39161 | 2 | 0 |
63686 | 63686 | 2020-04-16 | Henry | Ohio | 39069 | 2 | 0 |
63704 | 63704 | 2020-04-16 | Meigs | Ohio | 39105 | 2 | 0 |
63707 | 63707 | 2020-04-16 | Monroe | Ohio | 39111 | 2 | 0 |
63732 | 63732 | 2020-04-16 | Van Wert | Ohio | 39161 | 2 | 0 |
60960 | 60960 | 2020-04-15 | Henry | Ohio | 39069 | 2 | 0 |
60978 | 60978 | 2020-04-15 | Meigs | Ohio | 39105 | 2 | 0 |
60981 | 60981 | 2020-04-15 | Monroe | Ohio | 39111 | 2 | 0 |
60983 | 60983 | 2020-04-15 | Morgan | Ohio | 39115 | 2 | 0 |
61006 | 61006 | 2020-04-15 | Van Wert | Ohio | 39161 | 2 | 0 |
58266 | 58266 | 2020-04-14 | Monroe | Ohio | 39111 | 2 | 0 |
58268 | 58268 | 2020-04-14 | Morgan | Ohio | 39115 | 2 | 0 |
58271 | 58271 | 2020-04-14 | Noble | Ohio | 39121 | 2 | 0 |
58279 | 58279 | 2020-04-14 | Putnam | Ohio | 39137 | 2 | 0 |
58291 | 58291 | 2020-04-14 | Van Wert | Ohio | 39161 | 2 | 0 |
55546 | 55546 | 2020-04-13 | Hocking | Ohio | 39073 | 2 | 0 |
55549 | 55549 | 2020-04-13 | Jackson | Ohio | 39079 | 2 | 0 |
55565 | 55565 | 2020-04-13 | Monroe | Ohio | 39111 | 2 | 0 |
55567 | 55567 | 2020-04-13 | Morgan | Ohio | 39115 | 2 | 0 |
55570 | 55570 | 2020-04-13 | Noble | Ohio | 39121 | 2 | 0 |
55590 | 55590 | 2020-04-13 | Van Wert | Ohio | 39161 | 2 | 0 |
52862 | 52862 | 2020-04-12 | Hocking | Ohio | 39073 | 2 | 0 |
52865 | 52865 | 2020-04-12 | Jackson | Ohio | 39079 | 2 | 0 |
52881 | 52881 | 2020-04-12 | Monroe | Ohio | 39111 | 2 | 0 |
52883 | 52883 | 2020-04-12 | Morgan | Ohio | 39115 | 2 | 0 |
52906 | 52906 | 2020-04-12 | Van Wert | Ohio | 39161 | 2 | 0 |
50189 | 50189 | 2020-04-11 | Hocking | Ohio | 39073 | 2 | 0 |
50192 | 50192 | 2020-04-11 | Jackson | Ohio | 39079 | 2 | 0 |
50208 | 50208 | 2020-04-11 | Monroe | Ohio | 39111 | 2 | 0 |
50210 | 50210 | 2020-04-11 | Morgan | Ohio | 39115 | 2 | 0 |
50233 | 50233 | 2020-04-11 | Van Wert | Ohio | 39161 | 2 | 0 |
47536 | 47536 | 2020-04-10 | Jackson | Ohio | 39079 | 2 | 0 |
47552 | 47552 | 2020-04-10 | Monroe | Ohio | 39111 | 2 | 0 |
47554 | 47554 | 2020-04-10 | Morgan | Ohio | 39115 | 2 | 0 |
47559 | 47559 | 2020-04-10 | Paulding | Ohio | 39125 | 2 | 0 |
47577 | 47577 | 2020-04-10 | Van Wert | Ohio | 39161 | 2 | 0 |
47581 | 47581 | 2020-04-10 | Williams | Ohio | 39171 | 2 | 0 |
44921 | 44921 | 2020-04-09 | Jackson | Ohio | 39079 | 2 | 0 |
44937 | 44937 | 2020-04-09 | Monroe | Ohio | 39111 | 2 | 0 |
44939 | 44939 | 2020-04-09 | Morgan | Ohio | 39115 | 2 | 0 |
44944 | 44944 | 2020-04-09 | Paulding | Ohio | 39125 | 2 | 0 |
44954 | 44954 | 2020-04-09 | Scioto | Ohio | 39145 | 2 | 0 |
44962 | 44962 | 2020-04-09 | Van Wert | Ohio | 39161 | 2 | 0 |
42299 | 42299 | 2020-04-08 | Adams | Ohio | 39001 | 2 | 0 |
42328 | 42328 | 2020-04-08 | Guernsey | Ohio | 39059 | 2 | 0 |
42331 | 42331 | 2020-04-08 | Hardin | Ohio | 39065 | 2 | 0 |
42336 | 42336 | 2020-04-08 | Jackson | Ohio | 39079 | 2 | 0 |
42352 | 42352 | 2020-04-08 | Monroe | Ohio | 39111 | 2 | 0 |
42354 | 42354 | 2020-04-08 | Morgan | Ohio | 39115 | 2 | 0 |
42358 | 42358 | 2020-04-08 | Paulding | Ohio | 39125 | 2 | 0 |
42376 | 42376 | 2020-04-08 | Van Wert | Ohio | 39161 | 2 | 0 |
39741 | 39741 | 2020-04-07 | Adams | Ohio | 39001 | 2 | 0 |
39764 | 39764 | 2020-04-07 | Fayette | Ohio | 39047 | 2 | 0 |
39773 | 39773 | 2020-04-07 | Hardin | Ohio | 39065 | 2 | 0 |
39775 | 39775 | 2020-04-07 | Holmes | Ohio | 39075 | 2 | 0 |
39792 | 39792 | 2020-04-07 | Monroe | Ohio | 39111 | 2 | 0 |
39816 | 39816 | 2020-04-07 | Van Wert | Ohio | 39161 | 2 | 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);