ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Crawford" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536492 | 536492 | 2020-09-15 | Crawford | Ohio | 39033 | 208 | 6 |
533256 | 533256 | 2020-09-14 | Crawford | Ohio | 39033 | 208 | 6 |
530021 | 530021 | 2020-09-13 | Crawford | Ohio | 39033 | 208 | 6 |
526784 | 526784 | 2020-09-12 | Crawford | Ohio | 39033 | 207 | 6 |
523548 | 523548 | 2020-09-11 | Crawford | Ohio | 39033 | 206 | 6 |
520312 | 520312 | 2020-09-10 | Crawford | Ohio | 39033 | 206 | 5 |
517076 | 517076 | 2020-09-09 | Crawford | Ohio | 39033 | 206 | 5 |
513841 | 513841 | 2020-09-08 | Crawford | Ohio | 39033 | 205 | 5 |
510608 | 510608 | 2020-09-07 | Crawford | Ohio | 39033 | 205 | 5 |
507375 | 507375 | 2020-09-06 | Crawford | Ohio | 39033 | 204 | 5 |
504143 | 504143 | 2020-09-05 | Crawford | Ohio | 39033 | 203 | 5 |
500909 | 500909 | 2020-09-04 | Crawford | Ohio | 39033 | 202 | 5 |
497675 | 497675 | 2020-09-03 | Crawford | Ohio | 39033 | 199 | 5 |
494442 | 494442 | 2020-09-02 | Crawford | Ohio | 39033 | 197 | 5 |
491208 | 491208 | 2020-09-01 | Crawford | Ohio | 39033 | 196 | 5 |
487975 | 487975 | 2020-08-31 | Crawford | Ohio | 39033 | 194 | 5 |
484742 | 484742 | 2020-08-30 | Crawford | Ohio | 39033 | 193 | 5 |
481507 | 481507 | 2020-08-29 | Crawford | Ohio | 39033 | 193 | 5 |
478273 | 478273 | 2020-08-28 | Crawford | Ohio | 39033 | 193 | 5 |
475040 | 475040 | 2020-08-27 | Crawford | Ohio | 39033 | 191 | 5 |
471806 | 471806 | 2020-08-26 | Crawford | Ohio | 39033 | 190 | 5 |
468574 | 468574 | 2020-08-25 | Crawford | Ohio | 39033 | 189 | 5 |
465346 | 465346 | 2020-08-24 | Crawford | Ohio | 39033 | 189 | 5 |
462117 | 462117 | 2020-08-23 | Crawford | Ohio | 39033 | 188 | 5 |
458889 | 458889 | 2020-08-22 | Crawford | Ohio | 39033 | 187 | 5 |
455661 | 455661 | 2020-08-21 | Crawford | Ohio | 39033 | 187 | 5 |
452433 | 452433 | 2020-08-20 | Crawford | Ohio | 39033 | 185 | 5 |
449205 | 449205 | 2020-08-19 | Crawford | Ohio | 39033 | 184 | 5 |
445977 | 445977 | 2020-08-18 | Crawford | Ohio | 39033 | 184 | 5 |
442751 | 442751 | 2020-08-17 | Crawford | Ohio | 39033 | 183 | 5 |
439524 | 439524 | 2020-08-16 | Crawford | Ohio | 39033 | 183 | 5 |
436299 | 436299 | 2020-08-15 | Crawford | Ohio | 39033 | 183 | 5 |
433073 | 433073 | 2020-08-14 | Crawford | Ohio | 39033 | 181 | 5 |
429847 | 429847 | 2020-08-13 | Crawford | Ohio | 39033 | 177 | 5 |
426622 | 426622 | 2020-08-12 | Crawford | Ohio | 39033 | 177 | 5 |
423399 | 423399 | 2020-08-11 | Crawford | Ohio | 39033 | 175 | 5 |
420176 | 420176 | 2020-08-10 | Crawford | Ohio | 39033 | 174 | 5 |
416956 | 416956 | 2020-08-09 | Crawford | Ohio | 39033 | 174 | 5 |
413735 | 413735 | 2020-08-08 | Crawford | Ohio | 39033 | 174 | 5 |
410515 | 410515 | 2020-08-07 | Crawford | Ohio | 39033 | 172 | 5 |
407295 | 407295 | 2020-08-06 | Crawford | Ohio | 39033 | 171 | 5 |
404076 | 404076 | 2020-08-05 | Crawford | Ohio | 39033 | 168 | 5 |
400858 | 400858 | 2020-08-04 | Crawford | Ohio | 39033 | 168 | 5 |
397643 | 397643 | 2020-08-03 | Crawford | Ohio | 39033 | 168 | 5 |
394426 | 394426 | 2020-08-02 | Crawford | Ohio | 39033 | 164 | 5 |
391210 | 391210 | 2020-08-01 | Crawford | Ohio | 39033 | 164 | 5 |
387993 | 387993 | 2020-07-31 | Crawford | Ohio | 39033 | 163 | 5 |
384776 | 384776 | 2020-07-30 | Crawford | Ohio | 39033 | 160 | 5 |
381558 | 381558 | 2020-07-29 | Crawford | Ohio | 39033 | 160 | 5 |
378341 | 378341 | 2020-07-28 | Crawford | Ohio | 39033 | 158 | 5 |
375124 | 375124 | 2020-07-27 | Crawford | Ohio | 39033 | 158 | 5 |
371912 | 371912 | 2020-07-26 | Crawford | Ohio | 39033 | 158 | 5 |
368700 | 368700 | 2020-07-25 | Crawford | Ohio | 39033 | 155 | 5 |
365491 | 365491 | 2020-07-24 | Crawford | Ohio | 39033 | 154 | 5 |
362285 | 362285 | 2020-07-23 | Crawford | Ohio | 39033 | 153 | 5 |
359079 | 359079 | 2020-07-22 | Crawford | Ohio | 39033 | 153 | 5 |
355875 | 355875 | 2020-07-21 | Crawford | Ohio | 39033 | 152 | 5 |
352672 | 352672 | 2020-07-20 | Crawford | Ohio | 39033 | 152 | 5 |
349469 | 349469 | 2020-07-19 | Crawford | Ohio | 39033 | 153 | 5 |
346268 | 346268 | 2020-07-18 | Crawford | Ohio | 39033 | 151 | 5 |
343069 | 343069 | 2020-07-17 | Crawford | Ohio | 39033 | 149 | 5 |
339871 | 339871 | 2020-07-16 | Crawford | Ohio | 39033 | 146 | 5 |
336675 | 336675 | 2020-07-15 | Crawford | Ohio | 39033 | 140 | 5 |
333481 | 333481 | 2020-07-14 | Crawford | Ohio | 39033 | 140 | 5 |
330289 | 330289 | 2020-07-13 | Crawford | Ohio | 39033 | 140 | 5 |
327102 | 327102 | 2020-07-12 | Crawford | Ohio | 39033 | 141 | 5 |
323917 | 323917 | 2020-07-11 | Crawford | Ohio | 39033 | 138 | 5 |
320737 | 320737 | 2020-07-10 | Crawford | Ohio | 39033 | 138 | 5 |
317560 | 317560 | 2020-07-09 | Crawford | Ohio | 39033 | 137 | 5 |
314387 | 314387 | 2020-07-08 | Crawford | Ohio | 39033 | 136 | 5 |
311215 | 311215 | 2020-07-07 | Crawford | Ohio | 39033 | 136 | 5 |
308046 | 308046 | 2020-07-06 | Crawford | Ohio | 39033 | 135 | 5 |
304879 | 304879 | 2020-07-05 | Crawford | Ohio | 39033 | 135 | 5 |
301716 | 301716 | 2020-07-04 | Crawford | Ohio | 39033 | 135 | 5 |
298553 | 298553 | 2020-07-03 | Crawford | Ohio | 39033 | 134 | 5 |
295393 | 295393 | 2020-07-02 | Crawford | Ohio | 39033 | 135 | 7 |
292238 | 292238 | 2020-07-01 | Crawford | Ohio | 39033 | 135 | 7 |
289086 | 289086 | 2020-06-30 | Crawford | Ohio | 39033 | 135 | 6 |
285936 | 285936 | 2020-06-29 | Crawford | Ohio | 39033 | 132 | 6 |
282791 | 282791 | 2020-06-28 | Crawford | Ohio | 39033 | 130 | 6 |
279645 | 279645 | 2020-06-27 | Crawford | Ohio | 39033 | 129 | 5 |
276497 | 276497 | 2020-06-26 | Crawford | Ohio | 39033 | 127 | 5 |
273350 | 273350 | 2020-06-25 | Crawford | Ohio | 39033 | 126 | 5 |
270211 | 270211 | 2020-06-24 | Crawford | Ohio | 39033 | 125 | 5 |
267077 | 267077 | 2020-06-23 | Crawford | Ohio | 39033 | 125 | 5 |
263949 | 263949 | 2020-06-22 | Crawford | Ohio | 39033 | 122 | 5 |
260821 | 260821 | 2020-06-21 | Crawford | Ohio | 39033 | 122 | 5 |
257694 | 257694 | 2020-06-20 | Crawford | Ohio | 39033 | 122 | 5 |
254569 | 254569 | 2020-06-19 | Crawford | Ohio | 39033 | 122 | 5 |
251454 | 251454 | 2020-06-18 | Crawford | Ohio | 39033 | 122 | 5 |
248339 | 248339 | 2020-06-17 | Crawford | Ohio | 39033 | 122 | 5 |
245226 | 245226 | 2020-06-16 | Crawford | Ohio | 39033 | 123 | 5 |
242114 | 242114 | 2020-06-15 | Crawford | Ohio | 39033 | 123 | 5 |
239005 | 239005 | 2020-06-14 | Crawford | Ohio | 39033 | 122 | 5 |
235897 | 235897 | 2020-06-13 | Crawford | Ohio | 39033 | 122 | 4 |
232792 | 232792 | 2020-06-12 | Crawford | Ohio | 39033 | 122 | 4 |
229687 | 229687 | 2020-06-11 | Crawford | Ohio | 39033 | 123 | 4 |
226583 | 226583 | 2020-06-10 | Crawford | Ohio | 39033 | 121 | 4 |
223483 | 223483 | 2020-06-09 | Crawford | Ohio | 39033 | 121 | 4 |
220388 | 220388 | 2020-06-08 | Crawford | Ohio | 39033 | 121 | 4 |
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);