ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Noble" and state = "Ohio" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
44942 | 44942 | 2020-04-09 | Noble | Ohio | 39121 | 1 | 0 |
47557 | 47557 | 2020-04-10 | Noble | Ohio | 39121 | 1 | 0 |
50213 | 50213 | 2020-04-11 | Noble | Ohio | 39121 | 1 | 0 |
52886 | 52886 | 2020-04-12 | Noble | Ohio | 39121 | 1 | 0 |
55570 | 55570 | 2020-04-13 | Noble | Ohio | 39121 | 2 | 0 |
58271 | 58271 | 2020-04-14 | Noble | Ohio | 39121 | 2 | 0 |
60986 | 60986 | 2020-04-15 | Noble | Ohio | 39121 | 3 | 0 |
63712 | 63712 | 2020-04-16 | Noble | Ohio | 39121 | 3 | 0 |
66455 | 66455 | 2020-04-17 | Noble | Ohio | 39121 | 3 | 0 |
69212 | 69212 | 2020-04-18 | Noble | Ohio | 39121 | 3 | 0 |
71979 | 71979 | 2020-04-19 | Noble | Ohio | 39121 | 6 | 0 |
74754 | 74754 | 2020-04-20 | Noble | Ohio | 39121 | 4 | 0 |
77535 | 77535 | 2020-04-21 | Noble | Ohio | 39121 | 3 | 0 |
80325 | 80325 | 2020-04-22 | Noble | Ohio | 39121 | 3 | 0 |
83124 | 83124 | 2020-04-23 | Noble | Ohio | 39121 | 3 | 0 |
85928 | 85928 | 2020-04-24 | Noble | Ohio | 39121 | 4 | 0 |
88742 | 88742 | 2020-04-25 | Noble | Ohio | 39121 | 4 | 0 |
91558 | 91558 | 2020-04-26 | Noble | Ohio | 39121 | 5 | 0 |
94384 | 94384 | 2020-04-27 | Noble | Ohio | 39121 | 5 | 0 |
97221 | 97221 | 2020-04-28 | Noble | Ohio | 39121 | 5 | 0 |
100070 | 100070 | 2020-04-29 | Noble | Ohio | 39121 | 5 | 0 |
102923 | 102923 | 2020-04-30 | Noble | Ohio | 39121 | 5 | 0 |
105786 | 105786 | 2020-05-01 | Noble | Ohio | 39121 | 5 | 0 |
108653 | 108653 | 2020-05-02 | Noble | Ohio | 39121 | 5 | 0 |
111527 | 111527 | 2020-05-03 | Noble | Ohio | 39121 | 5 | 0 |
114408 | 114408 | 2020-05-04 | Noble | Ohio | 39121 | 5 | 0 |
117289 | 117289 | 2020-05-05 | Noble | Ohio | 39121 | 5 | 0 |
120250 | 120250 | 2020-05-06 | Noble | Ohio | 39121 | 6 | 0 |
123227 | 123227 | 2020-05-07 | Noble | Ohio | 39121 | 5 | 0 |
126210 | 126210 | 2020-05-08 | Noble | Ohio | 39121 | 5 | 0 |
129199 | 129199 | 2020-05-09 | Noble | Ohio | 39121 | 6 | 0 |
132188 | 132188 | 2020-05-10 | Noble | Ohio | 39121 | 6 | 0 |
135179 | 135179 | 2020-05-11 | Noble | Ohio | 39121 | 6 | 0 |
138169 | 138169 | 2020-05-12 | Noble | Ohio | 39121 | 6 | 0 |
141165 | 141165 | 2020-05-13 | Noble | Ohio | 39121 | 6 | 0 |
144160 | 144160 | 2020-05-14 | Noble | Ohio | 39121 | 6 | 0 |
147161 | 147161 | 2020-05-15 | Noble | Ohio | 39121 | 6 | 0 |
150168 | 150168 | 2020-05-16 | Noble | Ohio | 39121 | 6 | 0 |
153179 | 153179 | 2020-05-17 | Noble | Ohio | 39121 | 6 | 0 |
156196 | 156196 | 2020-05-18 | Noble | Ohio | 39121 | 6 | 0 |
159216 | 159216 | 2020-05-19 | Noble | Ohio | 39121 | 6 | 0 |
162243 | 162243 | 2020-05-20 | Noble | Ohio | 39121 | 6 | 0 |
165272 | 165272 | 2020-05-21 | Noble | Ohio | 39121 | 6 | 0 |
168308 | 168308 | 2020-05-22 | Noble | Ohio | 39121 | 6 | 0 |
171347 | 171347 | 2020-05-23 | Noble | Ohio | 39121 | 5 | 0 |
174389 | 174389 | 2020-05-24 | Noble | Ohio | 39121 | 5 | 0 |
177433 | 177433 | 2020-05-25 | Noble | Ohio | 39121 | 5 | 0 |
180476 | 180476 | 2020-05-26 | Noble | Ohio | 39121 | 5 | 0 |
183525 | 183525 | 2020-05-27 | Noble | Ohio | 39121 | 5 | 0 |
186582 | 186582 | 2020-05-28 | Noble | Ohio | 39121 | 5 | 0 |
189642 | 189642 | 2020-05-29 | Noble | Ohio | 39121 | 6 | 0 |
192706 | 192706 | 2020-05-30 | Noble | Ohio | 39121 | 6 | 0 |
195776 | 195776 | 2020-05-31 | Noble | Ohio | 39121 | 6 | 0 |
198849 | 198849 | 2020-06-01 | Noble | Ohio | 39121 | 6 | 0 |
201924 | 201924 | 2020-06-02 | Noble | Ohio | 39121 | 6 | 0 |
205001 | 205001 | 2020-06-03 | Noble | Ohio | 39121 | 6 | 0 |
208082 | 208082 | 2020-06-04 | Noble | Ohio | 39121 | 6 | 0 |
211164 | 211164 | 2020-06-05 | Noble | Ohio | 39121 | 6 | 0 |
214250 | 214250 | 2020-06-06 | Noble | Ohio | 39121 | 6 | 0 |
217340 | 217340 | 2020-06-07 | Noble | Ohio | 39121 | 6 | 0 |
220432 | 220432 | 2020-06-08 | Noble | Ohio | 39121 | 6 | 0 |
223527 | 223527 | 2020-06-09 | Noble | Ohio | 39121 | 6 | 0 |
226627 | 226627 | 2020-06-10 | Noble | Ohio | 39121 | 6 | 0 |
229731 | 229731 | 2020-06-11 | Noble | Ohio | 39121 | 6 | 0 |
232836 | 232836 | 2020-06-12 | Noble | Ohio | 39121 | 6 | 0 |
235941 | 235941 | 2020-06-13 | Noble | Ohio | 39121 | 6 | 0 |
239049 | 239049 | 2020-06-14 | Noble | Ohio | 39121 | 6 | 0 |
242158 | 242158 | 2020-06-15 | Noble | Ohio | 39121 | 6 | 0 |
245270 | 245270 | 2020-06-16 | Noble | Ohio | 39121 | 6 | 0 |
248383 | 248383 | 2020-06-17 | Noble | Ohio | 39121 | 6 | 0 |
251498 | 251498 | 2020-06-18 | Noble | Ohio | 39121 | 6 | 0 |
254613 | 254613 | 2020-06-19 | Noble | Ohio | 39121 | 6 | 0 |
257738 | 257738 | 2020-06-20 | Noble | Ohio | 39121 | 6 | 0 |
260865 | 260865 | 2020-06-21 | Noble | Ohio | 39121 | 6 | 0 |
263993 | 263993 | 2020-06-22 | Noble | Ohio | 39121 | 6 | 0 |
267121 | 267121 | 2020-06-23 | Noble | Ohio | 39121 | 6 | 0 |
270255 | 270255 | 2020-06-24 | Noble | Ohio | 39121 | 6 | 0 |
273394 | 273394 | 2020-06-25 | Noble | Ohio | 39121 | 6 | 0 |
276541 | 276541 | 2020-06-26 | Noble | Ohio | 39121 | 7 | 0 |
279689 | 279689 | 2020-06-27 | Noble | Ohio | 39121 | 8 | 0 |
282835 | 282835 | 2020-06-28 | Noble | Ohio | 39121 | 9 | 0 |
285980 | 285980 | 2020-06-29 | Noble | Ohio | 39121 | 9 | 0 |
289130 | 289130 | 2020-06-30 | Noble | Ohio | 39121 | 9 | 0 |
292282 | 292282 | 2020-07-01 | Noble | Ohio | 39121 | 11 | 0 |
295437 | 295437 | 2020-07-02 | Noble | Ohio | 39121 | 11 | 0 |
298597 | 298597 | 2020-07-03 | Noble | Ohio | 39121 | 11 | 0 |
301760 | 301760 | 2020-07-04 | Noble | Ohio | 39121 | 11 | 0 |
304923 | 304923 | 2020-07-05 | Noble | Ohio | 39121 | 11 | 0 |
308090 | 308090 | 2020-07-06 | Noble | Ohio | 39121 | 11 | 0 |
311259 | 311259 | 2020-07-07 | Noble | Ohio | 39121 | 11 | 0 |
314431 | 314431 | 2020-07-08 | Noble | Ohio | 39121 | 11 | 0 |
317604 | 317604 | 2020-07-09 | Noble | Ohio | 39121 | 13 | 0 |
320781 | 320781 | 2020-07-10 | Noble | Ohio | 39121 | 13 | 0 |
323961 | 323961 | 2020-07-11 | Noble | Ohio | 39121 | 14 | 0 |
327146 | 327146 | 2020-07-12 | Noble | Ohio | 39121 | 14 | 0 |
330333 | 330333 | 2020-07-13 | Noble | Ohio | 39121 | 14 | 0 |
333525 | 333525 | 2020-07-14 | Noble | Ohio | 39121 | 14 | 0 |
336719 | 336719 | 2020-07-15 | Noble | Ohio | 39121 | 14 | 0 |
339915 | 339915 | 2020-07-16 | Noble | Ohio | 39121 | 14 | 0 |
343113 | 343113 | 2020-07-17 | Noble | Ohio | 39121 | 15 | 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);