ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jefferson" and fips = 39081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636984 | 636984 | 2020-10-16 | Jefferson | Ohio | 39081 | 432 | 4 |
633738 | 633738 | 2020-10-15 | Jefferson | Ohio | 39081 | 428 | 4 |
630493 | 630493 | 2020-10-14 | Jefferson | Ohio | 39081 | 412 | 4 |
627249 | 627249 | 2020-10-13 | Jefferson | Ohio | 39081 | 406 | 4 |
624007 | 624007 | 2020-10-12 | Jefferson | Ohio | 39081 | 403 | 4 |
620764 | 620764 | 2020-10-11 | Jefferson | Ohio | 39081 | 398 | 4 |
617522 | 617522 | 2020-10-10 | Jefferson | Ohio | 39081 | 392 | 4 |
614280 | 614280 | 2020-10-09 | Jefferson | Ohio | 39081 | 390 | 4 |
611039 | 611039 | 2020-10-08 | Jefferson | Ohio | 39081 | 380 | 4 |
607797 | 607797 | 2020-10-07 | Jefferson | Ohio | 39081 | 376 | 4 |
604554 | 604554 | 2020-10-06 | Jefferson | Ohio | 39081 | 362 | 4 |
601312 | 601312 | 2020-10-05 | Jefferson | Ohio | 39081 | 357 | 4 |
598069 | 598069 | 2020-10-04 | Jefferson | Ohio | 39081 | 355 | 4 |
594826 | 594826 | 2020-10-03 | Jefferson | Ohio | 39081 | 354 | 4 |
591585 | 591585 | 2020-10-02 | Jefferson | Ohio | 39081 | 353 | 4 |
588344 | 588344 | 2020-10-01 | Jefferson | Ohio | 39081 | 349 | 4 |
585104 | 585104 | 2020-09-30 | Jefferson | Ohio | 39081 | 345 | 4 |
581864 | 581864 | 2020-09-29 | Jefferson | Ohio | 39081 | 342 | 4 |
578624 | 578624 | 2020-09-28 | Jefferson | Ohio | 39081 | 338 | 4 |
575383 | 575383 | 2020-09-27 | Jefferson | Ohio | 39081 | 336 | 4 |
572139 | 572139 | 2020-09-26 | Jefferson | Ohio | 39081 | 336 | 4 |
568897 | 568897 | 2020-09-25 | Jefferson | Ohio | 39081 | 336 | 4 |
565656 | 565656 | 2020-09-24 | Jefferson | Ohio | 39081 | 335 | 4 |
562415 | 562415 | 2020-09-23 | Jefferson | Ohio | 39081 | 333 | 4 |
559178 | 559178 | 2020-09-22 | Jefferson | Ohio | 39081 | 328 | 4 |
555941 | 555941 | 2020-09-21 | Jefferson | Ohio | 39081 | 324 | 4 |
552704 | 552704 | 2020-09-20 | Jefferson | Ohio | 39081 | 318 | 4 |
549465 | 549465 | 2020-09-19 | Jefferson | Ohio | 39081 | 318 | 4 |
546226 | 546226 | 2020-09-18 | Jefferson | Ohio | 39081 | 318 | 4 |
542989 | 542989 | 2020-09-17 | Jefferson | Ohio | 39081 | 317 | 4 |
539753 | 539753 | 2020-09-16 | Jefferson | Ohio | 39081 | 316 | 4 |
536516 | 536516 | 2020-09-15 | Jefferson | Ohio | 39081 | 312 | 4 |
533280 | 533280 | 2020-09-14 | Jefferson | Ohio | 39081 | 306 | 4 |
530045 | 530045 | 2020-09-13 | Jefferson | Ohio | 39081 | 305 | 4 |
526808 | 526808 | 2020-09-12 | Jefferson | Ohio | 39081 | 305 | 4 |
523572 | 523572 | 2020-09-11 | Jefferson | Ohio | 39081 | 304 | 4 |
520336 | 520336 | 2020-09-10 | Jefferson | Ohio | 39081 | 301 | 4 |
517100 | 517100 | 2020-09-09 | Jefferson | Ohio | 39081 | 292 | 4 |
513865 | 513865 | 2020-09-08 | Jefferson | Ohio | 39081 | 292 | 4 |
510632 | 510632 | 2020-09-07 | Jefferson | Ohio | 39081 | 292 | 4 |
507399 | 507399 | 2020-09-06 | Jefferson | Ohio | 39081 | 292 | 4 |
504167 | 504167 | 2020-09-05 | Jefferson | Ohio | 39081 | 292 | 4 |
500933 | 500933 | 2020-09-04 | Jefferson | Ohio | 39081 | 292 | 4 |
497699 | 497699 | 2020-09-03 | Jefferson | Ohio | 39081 | 288 | 4 |
494466 | 494466 | 2020-09-02 | Jefferson | Ohio | 39081 | 275 | 4 |
491232 | 491232 | 2020-09-01 | Jefferson | Ohio | 39081 | 275 | 4 |
487999 | 487999 | 2020-08-31 | Jefferson | Ohio | 39081 | 270 | 4 |
484766 | 484766 | 2020-08-30 | Jefferson | Ohio | 39081 | 267 | 4 |
481531 | 481531 | 2020-08-29 | Jefferson | Ohio | 39081 | 267 | 4 |
478297 | 478297 | 2020-08-28 | Jefferson | Ohio | 39081 | 265 | 4 |
475064 | 475064 | 2020-08-27 | Jefferson | Ohio | 39081 | 264 | 4 |
471830 | 471830 | 2020-08-26 | Jefferson | Ohio | 39081 | 263 | 4 |
468598 | 468598 | 2020-08-25 | Jefferson | Ohio | 39081 | 263 | 4 |
465370 | 465370 | 2020-08-24 | Jefferson | Ohio | 39081 | 261 | 4 |
462141 | 462141 | 2020-08-23 | Jefferson | Ohio | 39081 | 261 | 4 |
458913 | 458913 | 2020-08-22 | Jefferson | Ohio | 39081 | 261 | 4 |
455685 | 455685 | 2020-08-21 | Jefferson | Ohio | 39081 | 260 | 4 |
452457 | 452457 | 2020-08-20 | Jefferson | Ohio | 39081 | 259 | 4 |
449229 | 449229 | 2020-08-19 | Jefferson | Ohio | 39081 | 257 | 4 |
446001 | 446001 | 2020-08-18 | Jefferson | Ohio | 39081 | 256 | 3 |
442775 | 442775 | 2020-08-17 | Jefferson | Ohio | 39081 | 250 | 3 |
439548 | 439548 | 2020-08-16 | Jefferson | Ohio | 39081 | 250 | 3 |
436323 | 436323 | 2020-08-15 | Jefferson | Ohio | 39081 | 250 | 3 |
433097 | 433097 | 2020-08-14 | Jefferson | Ohio | 39081 | 240 | 3 |
429871 | 429871 | 2020-08-13 | Jefferson | Ohio | 39081 | 240 | 3 |
426646 | 426646 | 2020-08-12 | Jefferson | Ohio | 39081 | 240 | 3 |
423423 | 423423 | 2020-08-11 | Jefferson | Ohio | 39081 | 237 | 3 |
420200 | 420200 | 2020-08-10 | Jefferson | Ohio | 39081 | 234 | 2 |
416980 | 416980 | 2020-08-09 | Jefferson | Ohio | 39081 | 229 | 2 |
413759 | 413759 | 2020-08-08 | Jefferson | Ohio | 39081 | 224 | 2 |
410539 | 410539 | 2020-08-07 | Jefferson | Ohio | 39081 | 219 | 2 |
407319 | 407319 | 2020-08-06 | Jefferson | Ohio | 39081 | 219 | 2 |
404100 | 404100 | 2020-08-05 | Jefferson | Ohio | 39081 | 212 | 2 |
400882 | 400882 | 2020-08-04 | Jefferson | Ohio | 39081 | 210 | 3 |
397667 | 397667 | 2020-08-03 | Jefferson | Ohio | 39081 | 206 | 3 |
394450 | 394450 | 2020-08-02 | Jefferson | Ohio | 39081 | 204 | 3 |
391234 | 391234 | 2020-08-01 | Jefferson | Ohio | 39081 | 203 | 3 |
388017 | 388017 | 2020-07-31 | Jefferson | Ohio | 39081 | 196 | 3 |
384800 | 384800 | 2020-07-30 | Jefferson | Ohio | 39081 | 191 | 2 |
381582 | 381582 | 2020-07-29 | Jefferson | Ohio | 39081 | 189 | 2 |
378365 | 378365 | 2020-07-28 | Jefferson | Ohio | 39081 | 185 | 2 |
375148 | 375148 | 2020-07-27 | Jefferson | Ohio | 39081 | 178 | 2 |
371936 | 371936 | 2020-07-26 | Jefferson | Ohio | 39081 | 176 | 2 |
368724 | 368724 | 2020-07-25 | Jefferson | Ohio | 39081 | 168 | 2 |
365515 | 365515 | 2020-07-24 | Jefferson | Ohio | 39081 | 166 | 2 |
362309 | 362309 | 2020-07-23 | Jefferson | Ohio | 39081 | 164 | 2 |
359103 | 359103 | 2020-07-22 | Jefferson | Ohio | 39081 | 162 | 2 |
355899 | 355899 | 2020-07-21 | Jefferson | Ohio | 39081 | 162 | 2 |
352696 | 352696 | 2020-07-20 | Jefferson | Ohio | 39081 | 159 | 2 |
349493 | 349493 | 2020-07-19 | Jefferson | Ohio | 39081 | 153 | 2 |
346292 | 346292 | 2020-07-18 | Jefferson | Ohio | 39081 | 147 | 2 |
343093 | 343093 | 2020-07-17 | Jefferson | Ohio | 39081 | 145 | 2 |
339895 | 339895 | 2020-07-16 | Jefferson | Ohio | 39081 | 140 | 2 |
336699 | 336699 | 2020-07-15 | Jefferson | Ohio | 39081 | 135 | 2 |
333505 | 333505 | 2020-07-14 | Jefferson | Ohio | 39081 | 132 | 2 |
330313 | 330313 | 2020-07-13 | Jefferson | Ohio | 39081 | 127 | 2 |
327126 | 327126 | 2020-07-12 | Jefferson | Ohio | 39081 | 115 | 2 |
323941 | 323941 | 2020-07-11 | Jefferson | Ohio | 39081 | 109 | 2 |
320761 | 320761 | 2020-07-10 | Jefferson | Ohio | 39081 | 105 | 2 |
317584 | 317584 | 2020-07-09 | Jefferson | Ohio | 39081 | 95 | 2 |
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);