ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 39095 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536523 | 536523 | 2020-09-15 | Lucas | Ohio | 39095 | 6945 | 355 |
533287 | 533287 | 2020-09-14 | Lucas | Ohio | 39095 | 6903 | 350 |
530052 | 530052 | 2020-09-13 | Lucas | Ohio | 39095 | 6877 | 350 |
526815 | 526815 | 2020-09-12 | Lucas | Ohio | 39095 | 6859 | 350 |
523579 | 523579 | 2020-09-11 | Lucas | Ohio | 39095 | 6810 | 350 |
520343 | 520343 | 2020-09-10 | Lucas | Ohio | 39095 | 6786 | 350 |
517107 | 517107 | 2020-09-09 | Lucas | Ohio | 39095 | 6754 | 350 |
513872 | 513872 | 2020-09-08 | Lucas | Ohio | 39095 | 6737 | 350 |
510639 | 510639 | 2020-09-07 | Lucas | Ohio | 39095 | 6714 | 348 |
507406 | 507406 | 2020-09-06 | Lucas | Ohio | 39095 | 6687 | 348 |
504174 | 504174 | 2020-09-05 | Lucas | Ohio | 39095 | 6660 | 348 |
500940 | 500940 | 2020-09-04 | Lucas | Ohio | 39095 | 6625 | 348 |
497706 | 497706 | 2020-09-03 | Lucas | Ohio | 39095 | 6585 | 348 |
494473 | 494473 | 2020-09-02 | Lucas | Ohio | 39095 | 6527 | 343 |
491239 | 491239 | 2020-09-01 | Lucas | Ohio | 39095 | 6475 | 343 |
488006 | 488006 | 2020-08-31 | Lucas | Ohio | 39095 | 6418 | 342 |
484773 | 484773 | 2020-08-30 | Lucas | Ohio | 39095 | 6389 | 341 |
481538 | 481538 | 2020-08-29 | Lucas | Ohio | 39095 | 6344 | 341 |
478304 | 478304 | 2020-08-28 | Lucas | Ohio | 39095 | 6292 | 341 |
475071 | 475071 | 2020-08-27 | Lucas | Ohio | 39095 | 6256 | 341 |
471837 | 471837 | 2020-08-26 | Lucas | Ohio | 39095 | 6197 | 341 |
468605 | 468605 | 2020-08-25 | Lucas | Ohio | 39095 | 6149 | 339 |
465377 | 465377 | 2020-08-24 | Lucas | Ohio | 39095 | 6117 | 338 |
462148 | 462148 | 2020-08-23 | Lucas | Ohio | 39095 | 6070 | 338 |
458920 | 458920 | 2020-08-22 | Lucas | Ohio | 39095 | 6036 | 338 |
455692 | 455692 | 2020-08-21 | Lucas | Ohio | 39095 | 5981 | 337 |
452464 | 452464 | 2020-08-20 | Lucas | Ohio | 39095 | 5909 | 333 |
449236 | 449236 | 2020-08-19 | Lucas | Ohio | 39095 | 5843 | 332 |
446008 | 446008 | 2020-08-18 | Lucas | Ohio | 39095 | 5783 | 331 |
442782 | 442782 | 2020-08-17 | Lucas | Ohio | 39095 | 5744 | 329 |
439555 | 439555 | 2020-08-16 | Lucas | Ohio | 39095 | 5704 | 329 |
436330 | 436330 | 2020-08-15 | Lucas | Ohio | 39095 | 5673 | 329 |
433104 | 433104 | 2020-08-14 | Lucas | Ohio | 39095 | 5609 | 324 |
429878 | 429878 | 2020-08-13 | Lucas | Ohio | 39095 | 5544 | 324 |
426653 | 426653 | 2020-08-12 | Lucas | Ohio | 39095 | 5512 | 326 |
423430 | 423430 | 2020-08-11 | Lucas | Ohio | 39095 | 5448 | 326 |
420207 | 420207 | 2020-08-10 | Lucas | Ohio | 39095 | 5377 | 323 |
416987 | 416987 | 2020-08-09 | Lucas | Ohio | 39095 | 5348 | 323 |
413766 | 413766 | 2020-08-08 | Lucas | Ohio | 39095 | 5288 | 323 |
410546 | 410546 | 2020-08-07 | Lucas | Ohio | 39095 | 5207 | 321 |
407326 | 407326 | 2020-08-06 | Lucas | Ohio | 39095 | 5155 | 320 |
404107 | 404107 | 2020-08-05 | Lucas | Ohio | 39095 | 5114 | 320 |
400889 | 400889 | 2020-08-04 | Lucas | Ohio | 39095 | 5035 | 319 |
397674 | 397674 | 2020-08-03 | Lucas | Ohio | 39095 | 4944 | 318 |
394457 | 394457 | 2020-08-02 | Lucas | Ohio | 39095 | 4852 | 318 |
391241 | 391241 | 2020-08-01 | Lucas | Ohio | 39095 | 4762 | 316 |
388024 | 388024 | 2020-07-31 | Lucas | Ohio | 39095 | 4658 | 314 |
384807 | 384807 | 2020-07-30 | Lucas | Ohio | 39095 | 4521 | 313 |
381589 | 381589 | 2020-07-29 | Lucas | Ohio | 39095 | 4407 | 313 |
378372 | 378372 | 2020-07-28 | Lucas | Ohio | 39095 | 4304 | 312 |
375155 | 375155 | 2020-07-27 | Lucas | Ohio | 39095 | 4146 | 312 |
371943 | 371943 | 2020-07-26 | Lucas | Ohio | 39095 | 4077 | 311 |
368731 | 368731 | 2020-07-25 | Lucas | Ohio | 39095 | 4006 | 311 |
365522 | 365522 | 2020-07-24 | Lucas | Ohio | 39095 | 3927 | 311 |
362316 | 362316 | 2020-07-23 | Lucas | Ohio | 39095 | 3853 | 310 |
359110 | 359110 | 2020-07-22 | Lucas | Ohio | 39095 | 3742 | 308 |
355906 | 355906 | 2020-07-21 | Lucas | Ohio | 39095 | 3629 | 307 |
352703 | 352703 | 2020-07-20 | Lucas | Ohio | 39095 | 3567 | 307 |
349500 | 349500 | 2020-07-19 | Lucas | Ohio | 39095 | 3486 | 307 |
346299 | 346299 | 2020-07-18 | Lucas | Ohio | 39095 | 3387 | 306 |
343100 | 343100 | 2020-07-17 | Lucas | Ohio | 39095 | 3296 | 306 |
339902 | 339902 | 2020-07-16 | Lucas | Ohio | 39095 | 3214 | 306 |
336706 | 336706 | 2020-07-15 | Lucas | Ohio | 39095 | 3162 | 306 |
333512 | 333512 | 2020-07-14 | Lucas | Ohio | 39095 | 3110 | 306 |
330320 | 330320 | 2020-07-13 | Lucas | Ohio | 39095 | 3079 | 306 |
327133 | 327133 | 2020-07-12 | Lucas | Ohio | 39095 | 3007 | 306 |
323948 | 323948 | 2020-07-11 | Lucas | Ohio | 39095 | 2952 | 305 |
320768 | 320768 | 2020-07-10 | Lucas | Ohio | 39095 | 2889 | 305 |
317591 | 317591 | 2020-07-09 | Lucas | Ohio | 39095 | 2859 | 304 |
314418 | 314418 | 2020-07-08 | Lucas | Ohio | 39095 | 2836 | 303 |
311246 | 311246 | 2020-07-07 | Lucas | Ohio | 39095 | 2788 | 303 |
308077 | 308077 | 2020-07-06 | Lucas | Ohio | 39095 | 2752 | 302 |
304910 | 304910 | 2020-07-05 | Lucas | Ohio | 39095 | 2723 | 302 |
301747 | 301747 | 2020-07-04 | Lucas | Ohio | 39095 | 2700 | 302 |
298584 | 298584 | 2020-07-03 | Lucas | Ohio | 39095 | 2669 | 302 |
295424 | 295424 | 2020-07-02 | Lucas | Ohio | 39095 | 2628 | 302 |
292269 | 292269 | 2020-07-01 | Lucas | Ohio | 39095 | 2628 | 302 |
289117 | 289117 | 2020-06-30 | Lucas | Ohio | 39095 | 2600 | 301 |
285967 | 285967 | 2020-06-29 | Lucas | Ohio | 39095 | 2584 | 299 |
282822 | 282822 | 2020-06-28 | Lucas | Ohio | 39095 | 2567 | 299 |
279676 | 279676 | 2020-06-27 | Lucas | Ohio | 39095 | 2549 | 299 |
276528 | 276528 | 2020-06-26 | Lucas | Ohio | 39095 | 2538 | 299 |
273381 | 273381 | 2020-06-25 | Lucas | Ohio | 39095 | 2534 | 299 |
270242 | 270242 | 2020-06-24 | Lucas | Ohio | 39095 | 2527 | 299 |
267108 | 267108 | 2020-06-23 | Lucas | Ohio | 39095 | 2516 | 298 |
263980 | 263980 | 2020-06-22 | Lucas | Ohio | 39095 | 2511 | 294 |
260852 | 260852 | 2020-06-21 | Lucas | Ohio | 39095 | 2490 | 294 |
257725 | 257725 | 2020-06-20 | Lucas | Ohio | 39095 | 2483 | 294 |
254600 | 254600 | 2020-06-19 | Lucas | Ohio | 39095 | 2478 | 293 |
251485 | 251485 | 2020-06-18 | Lucas | Ohio | 39095 | 2468 | 291 |
248370 | 248370 | 2020-06-17 | Lucas | Ohio | 39095 | 2462 | 289 |
245257 | 245257 | 2020-06-16 | Lucas | Ohio | 39095 | 2460 | 286 |
242145 | 242145 | 2020-06-15 | Lucas | Ohio | 39095 | 2457 | 282 |
239036 | 239036 | 2020-06-14 | Lucas | Ohio | 39095 | 2428 | 280 |
235928 | 235928 | 2020-06-13 | Lucas | Ohio | 39095 | 2419 | 280 |
232823 | 232823 | 2020-06-12 | Lucas | Ohio | 39095 | 2411 | 272 |
229718 | 229718 | 2020-06-11 | Lucas | Ohio | 39095 | 2394 | 272 |
226614 | 226614 | 2020-06-10 | Lucas | Ohio | 39095 | 2390 | 270 |
223514 | 223514 | 2020-06-09 | Lucas | Ohio | 39095 | 2372 | 267 |
220419 | 220419 | 2020-06-08 | Lucas | Ohio | 39095 | 2354 | 266 |
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);