ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
259 rows where cases = 3 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 |
---|---|---|---|---|---|---|---|
162235 | 162235 | 2020-05-20 | Meigs | Ohio | 39105 | 3 | 0 |
159208 | 159208 | 2020-05-19 | Meigs | Ohio | 39105 | 3 | 0 |
156188 | 156188 | 2020-05-18 | Meigs | Ohio | 39105 | 3 | 0 |
153171 | 153171 | 2020-05-17 | Meigs | Ohio | 39105 | 3 | 0 |
150160 | 150160 | 2020-05-16 | Meigs | Ohio | 39105 | 3 | 0 |
147153 | 147153 | 2020-05-15 | Meigs | Ohio | 39105 | 3 | 0 |
147181 | 147181 | 2020-05-15 | Van Wert | Ohio | 39161 | 3 | 0 |
144152 | 144152 | 2020-05-14 | Meigs | Ohio | 39105 | 3 | 0 |
144180 | 144180 | 2020-05-14 | Van Wert | Ohio | 39161 | 3 | 0 |
141157 | 141157 | 2020-05-13 | Meigs | Ohio | 39105 | 3 | 0 |
141185 | 141185 | 2020-05-13 | Van Wert | Ohio | 39161 | 3 | 0 |
138161 | 138161 | 2020-05-12 | Meigs | Ohio | 39105 | 3 | 0 |
138189 | 138189 | 2020-05-12 | Van Wert | Ohio | 39161 | 3 | 0 |
135171 | 135171 | 2020-05-11 | Meigs | Ohio | 39105 | 3 | 0 |
135199 | 135199 | 2020-05-11 | Van Wert | Ohio | 39161 | 3 | 0 |
132180 | 132180 | 2020-05-10 | Meigs | Ohio | 39105 | 3 | 0 |
132208 | 132208 | 2020-05-10 | Van Wert | Ohio | 39161 | 3 | 0 |
129191 | 129191 | 2020-05-09 | Meigs | Ohio | 39105 | 3 | 0 |
129219 | 129219 | 2020-05-09 | Van Wert | Ohio | 39161 | 3 | 0 |
126202 | 126202 | 2020-05-08 | Meigs | Ohio | 39105 | 3 | 0 |
126230 | 126230 | 2020-05-08 | Van Wert | Ohio | 39161 | 3 | 0 |
123219 | 123219 | 2020-05-07 | Meigs | Ohio | 39105 | 3 | 0 |
123247 | 123247 | 2020-05-07 | Van Wert | Ohio | 39161 | 3 | 0 |
120242 | 120242 | 2020-05-06 | Meigs | Ohio | 39105 | 3 | 0 |
120270 | 120270 | 2020-05-06 | Van Wert | Ohio | 39161 | 3 | 0 |
117281 | 117281 | 2020-05-05 | Meigs | Ohio | 39105 | 3 | 0 |
117309 | 117309 | 2020-05-05 | Van Wert | Ohio | 39161 | 3 | 0 |
114400 | 114400 | 2020-05-04 | Meigs | Ohio | 39105 | 3 | 0 |
114413 | 114413 | 2020-05-04 | Pike | Ohio | 39131 | 3 | 0 |
114428 | 114428 | 2020-05-04 | Van Wert | Ohio | 39161 | 3 | 0 |
111519 | 111519 | 2020-05-03 | Meigs | Ohio | 39105 | 3 | 0 |
111522 | 111522 | 2020-05-03 | Monroe | Ohio | 39111 | 3 | 0 |
111532 | 111532 | 2020-05-03 | Pike | Ohio | 39131 | 3 | 0 |
111547 | 111547 | 2020-05-03 | Van Wert | Ohio | 39161 | 3 | 0 |
108658 | 108658 | 2020-05-02 | Pike | Ohio | 39131 | 3 | 0 |
108673 | 108673 | 2020-05-02 | Van Wert | Ohio | 39161 | 3 | 0 |
105781 | 105781 | 2020-05-01 | Monroe | Ohio | 39111 | 3 | 0 |
105791 | 105791 | 2020-05-01 | Pike | Ohio | 39131 | 3 | 0 |
105806 | 105806 | 2020-05-01 | Van Wert | Ohio | 39161 | 3 | 0 |
102867 | 102867 | 2020-04-30 | Athens | Ohio | 39009 | 3 | 1 |
102918 | 102918 | 2020-04-30 | Monroe | Ohio | 39111 | 3 | 0 |
102928 | 102928 | 2020-04-30 | Pike | Ohio | 39131 | 3 | 0 |
102943 | 102943 | 2020-04-30 | Van Wert | Ohio | 39161 | 3 | 0 |
100014 | 100014 | 2020-04-29 | Athens | Ohio | 39009 | 3 | 1 |
100065 | 100065 | 2020-04-29 | Monroe | Ohio | 39111 | 3 | 0 |
100075 | 100075 | 2020-04-29 | Pike | Ohio | 39131 | 3 | 0 |
100090 | 100090 | 2020-04-29 | Van Wert | Ohio | 39161 | 3 | 0 |
97165 | 97165 | 2020-04-28 | Athens | Ohio | 39009 | 3 | 1 |
97226 | 97226 | 2020-04-28 | Pike | Ohio | 39131 | 3 | 0 |
97241 | 97241 | 2020-04-28 | Van Wert | Ohio | 39161 | 3 | 0 |
97242 | 97242 | 2020-04-28 | Vinton | Ohio | 39163 | 3 | 0 |
94328 | 94328 | 2020-04-27 | Athens | Ohio | 39009 | 3 | 1 |
94389 | 94389 | 2020-04-27 | Pike | Ohio | 39131 | 3 | 0 |
94404 | 94404 | 2020-04-27 | Van Wert | Ohio | 39161 | 3 | 0 |
91502 | 91502 | 2020-04-26 | Athens | Ohio | 39009 | 3 | 1 |
91563 | 91563 | 2020-04-26 | Pike | Ohio | 39131 | 3 | 0 |
91578 | 91578 | 2020-04-26 | Van Wert | Ohio | 39161 | 3 | 0 |
88686 | 88686 | 2020-04-25 | Athens | Ohio | 39009 | 3 | 1 |
88747 | 88747 | 2020-04-25 | Pike | Ohio | 39131 | 3 | 0 |
88762 | 88762 | 2020-04-25 | Van Wert | Ohio | 39161 | 3 | 0 |
85872 | 85872 | 2020-04-24 | Athens | Ohio | 39009 | 3 | 1 |
85948 | 85948 | 2020-04-24 | Van Wert | Ohio | 39161 | 3 | 0 |
83124 | 83124 | 2020-04-23 | Noble | Ohio | 39121 | 3 | 0 |
83144 | 83144 | 2020-04-23 | Van Wert | Ohio | 39161 | 3 | 0 |
80269 | 80269 | 2020-04-22 | Athens | Ohio | 39009 | 3 | 1 |
80325 | 80325 | 2020-04-22 | Noble | Ohio | 39121 | 3 | 0 |
80345 | 80345 | 2020-04-22 | Van Wert | Ohio | 39161 | 3 | 0 |
77475 | 77475 | 2020-04-21 | Adams | Ohio | 39001 | 3 | 0 |
77479 | 77479 | 2020-04-21 | Athens | Ohio | 39009 | 3 | 1 |
77532 | 77532 | 2020-04-21 | Morgan | Ohio | 39115 | 3 | 0 |
77535 | 77535 | 2020-04-21 | Noble | Ohio | 39121 | 3 | 0 |
77555 | 77555 | 2020-04-21 | Van Wert | Ohio | 39161 | 3 | 0 |
74694 | 74694 | 2020-04-20 | Adams | Ohio | 39001 | 3 | 0 |
74698 | 74698 | 2020-04-20 | Athens | Ohio | 39009 | 3 | 1 |
74728 | 74728 | 2020-04-20 | Henry | Ohio | 39069 | 3 | 0 |
74751 | 74751 | 2020-04-20 | Morgan | Ohio | 39115 | 3 | 0 |
74774 | 74774 | 2020-04-20 | Van Wert | Ohio | 39161 | 3 | 0 |
71919 | 71919 | 2020-04-19 | Adams | Ohio | 39001 | 3 | 0 |
71923 | 71923 | 2020-04-19 | Athens | Ohio | 39009 | 3 | 1 |
71953 | 71953 | 2020-04-19 | Henry | Ohio | 39069 | 3 | 0 |
71956 | 71956 | 2020-04-19 | Holmes | Ohio | 39075 | 3 | 0 |
71976 | 71976 | 2020-04-19 | Morgan | Ohio | 39115 | 3 | 0 |
71999 | 71999 | 2020-04-19 | Van Wert | Ohio | 39161 | 3 | 0 |
69152 | 69152 | 2020-04-18 | Adams | Ohio | 39001 | 3 | 0 |
69156 | 69156 | 2020-04-18 | Athens | Ohio | 39009 | 3 | 1 |
69186 | 69186 | 2020-04-18 | Henry | Ohio | 39069 | 3 | 0 |
69189 | 69189 | 2020-04-18 | Holmes | Ohio | 39075 | 3 | 0 |
69209 | 69209 | 2020-04-18 | Morgan | Ohio | 39115 | 3 | 0 |
69212 | 69212 | 2020-04-18 | Noble | Ohio | 39121 | 3 | 0 |
66395 | 66395 | 2020-04-17 | Adams | Ohio | 39001 | 3 | 0 |
66399 | 66399 | 2020-04-17 | Athens | Ohio | 39009 | 3 | 1 |
66429 | 66429 | 2020-04-17 | Henry | Ohio | 39069 | 3 | 0 |
66432 | 66432 | 2020-04-17 | Holmes | Ohio | 39075 | 3 | 0 |
66434 | 66434 | 2020-04-17 | Jackson | Ohio | 39079 | 3 | 0 |
66452 | 66452 | 2020-04-17 | Morgan | Ohio | 39115 | 3 | 0 |
66455 | 66455 | 2020-04-17 | Noble | Ohio | 39121 | 3 | 0 |
63652 | 63652 | 2020-04-16 | Adams | Ohio | 39001 | 3 | 0 |
63656 | 63656 | 2020-04-16 | Athens | Ohio | 39009 | 3 | 1 |
63689 | 63689 | 2020-04-16 | Holmes | Ohio | 39075 | 3 | 0 |
63691 | 63691 | 2020-04-16 | Jackson | Ohio | 39079 | 3 | 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);