ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Jefferson" and fips = 41031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637125 | 637125 | 2020-10-16 | Jefferson | Oregon | 41031 | 593 | 9 |
633879 | 633879 | 2020-10-15 | Jefferson | Oregon | 41031 | 590 | 8 |
630634 | 630634 | 2020-10-14 | Jefferson | Oregon | 41031 | 591 | 8 |
627390 | 627390 | 2020-10-13 | Jefferson | Oregon | 41031 | 590 | 8 |
624148 | 624148 | 2020-10-12 | Jefferson | Oregon | 41031 | 589 | 8 |
620905 | 620905 | 2020-10-11 | Jefferson | Oregon | 41031 | 588 | 8 |
617663 | 617663 | 2020-10-10 | Jefferson | Oregon | 41031 | 588 | 8 |
614421 | 614421 | 2020-10-09 | Jefferson | Oregon | 41031 | 585 | 8 |
611180 | 611180 | 2020-10-08 | Jefferson | Oregon | 41031 | 579 | 8 |
607938 | 607938 | 2020-10-07 | Jefferson | Oregon | 41031 | 568 | 8 |
604695 | 604695 | 2020-10-06 | Jefferson | Oregon | 41031 | 567 | 8 |
601453 | 601453 | 2020-10-05 | Jefferson | Oregon | 41031 | 565 | 8 |
598210 | 598210 | 2020-10-04 | Jefferson | Oregon | 41031 | 562 | 8 |
594967 | 594967 | 2020-10-03 | Jefferson | Oregon | 41031 | 558 | 8 |
591726 | 591726 | 2020-10-02 | Jefferson | Oregon | 41031 | 555 | 8 |
588485 | 588485 | 2020-10-01 | Jefferson | Oregon | 41031 | 554 | 8 |
585245 | 585245 | 2020-09-30 | Jefferson | Oregon | 41031 | 545 | 8 |
582005 | 582005 | 2020-09-29 | Jefferson | Oregon | 41031 | 545 | 8 |
578765 | 578765 | 2020-09-28 | Jefferson | Oregon | 41031 | 541 | 8 |
575524 | 575524 | 2020-09-27 | Jefferson | Oregon | 41031 | 534 | 8 |
572280 | 572280 | 2020-09-26 | Jefferson | Oregon | 41031 | 529 | 8 |
569038 | 569038 | 2020-09-25 | Jefferson | Oregon | 41031 | 524 | 8 |
565797 | 565797 | 2020-09-24 | Jefferson | Oregon | 41031 | 521 | 8 |
562556 | 562556 | 2020-09-23 | Jefferson | Oregon | 41031 | 516 | 8 |
559319 | 559319 | 2020-09-22 | Jefferson | Oregon | 41031 | 513 | 8 |
556082 | 556082 | 2020-09-21 | Jefferson | Oregon | 41031 | 513 | 8 |
552845 | 552845 | 2020-09-20 | Jefferson | Oregon | 41031 | 513 | 8 |
549606 | 549606 | 2020-09-19 | Jefferson | Oregon | 41031 | 511 | 8 |
546367 | 546367 | 2020-09-18 | Jefferson | Oregon | 41031 | 505 | 8 |
543130 | 543130 | 2020-09-17 | Jefferson | Oregon | 41031 | 503 | 8 |
539894 | 539894 | 2020-09-16 | Jefferson | Oregon | 41031 | 496 | 8 |
536657 | 536657 | 2020-09-15 | Jefferson | Oregon | 41031 | 491 | 8 |
533421 | 533421 | 2020-09-14 | Jefferson | Oregon | 41031 | 488 | 8 |
530186 | 530186 | 2020-09-13 | Jefferson | Oregon | 41031 | 487 | 8 |
526949 | 526949 | 2020-09-12 | Jefferson | Oregon | 41031 | 486 | 8 |
523713 | 523713 | 2020-09-11 | Jefferson | Oregon | 41031 | 482 | 8 |
520477 | 520477 | 2020-09-10 | Jefferson | Oregon | 41031 | 479 | 7 |
517241 | 517241 | 2020-09-09 | Jefferson | Oregon | 41031 | 477 | 7 |
514006 | 514006 | 2020-09-08 | Jefferson | Oregon | 41031 | 476 | 7 |
510773 | 510773 | 2020-09-07 | Jefferson | Oregon | 41031 | 474 | 7 |
507540 | 507540 | 2020-09-06 | Jefferson | Oregon | 41031 | 471 | 7 |
504308 | 504308 | 2020-09-05 | Jefferson | Oregon | 41031 | 470 | 7 |
501074 | 501074 | 2020-09-04 | Jefferson | Oregon | 41031 | 468 | 7 |
497840 | 497840 | 2020-09-03 | Jefferson | Oregon | 41031 | 467 | 7 |
494607 | 494607 | 2020-09-02 | Jefferson | Oregon | 41031 | 461 | 7 |
491373 | 491373 | 2020-09-01 | Jefferson | Oregon | 41031 | 461 | 7 |
488140 | 488140 | 2020-08-31 | Jefferson | Oregon | 41031 | 457 | 7 |
484907 | 484907 | 2020-08-30 | Jefferson | Oregon | 41031 | 457 | 7 |
481672 | 481672 | 2020-08-29 | Jefferson | Oregon | 41031 | 457 | 7 |
478438 | 478438 | 2020-08-28 | Jefferson | Oregon | 41031 | 454 | 7 |
475205 | 475205 | 2020-08-27 | Jefferson | Oregon | 41031 | 452 | 7 |
471971 | 471971 | 2020-08-26 | Jefferson | Oregon | 41031 | 450 | 7 |
468739 | 468739 | 2020-08-25 | Jefferson | Oregon | 41031 | 452 | 6 |
465511 | 465511 | 2020-08-24 | Jefferson | Oregon | 41031 | 448 | 6 |
462282 | 462282 | 2020-08-23 | Jefferson | Oregon | 41031 | 441 | 6 |
459054 | 459054 | 2020-08-22 | Jefferson | Oregon | 41031 | 440 | 6 |
455826 | 455826 | 2020-08-21 | Jefferson | Oregon | 41031 | 436 | 6 |
452598 | 452598 | 2020-08-20 | Jefferson | Oregon | 41031 | 430 | 6 |
449370 | 449370 | 2020-08-19 | Jefferson | Oregon | 41031 | 426 | 6 |
446142 | 446142 | 2020-08-18 | Jefferson | Oregon | 41031 | 417 | 6 |
442916 | 442916 | 2020-08-17 | Jefferson | Oregon | 41031 | 413 | 5 |
439689 | 439689 | 2020-08-16 | Jefferson | Oregon | 41031 | 411 | 5 |
436464 | 436464 | 2020-08-15 | Jefferson | Oregon | 41031 | 408 | 5 |
433237 | 433237 | 2020-08-14 | Jefferson | Oregon | 41031 | 396 | 4 |
430011 | 430011 | 2020-08-13 | Jefferson | Oregon | 41031 | 392 | 4 |
426786 | 426786 | 2020-08-12 | Jefferson | Oregon | 41031 | 379 | 4 |
423563 | 423563 | 2020-08-11 | Jefferson | Oregon | 41031 | 377 | 4 |
420340 | 420340 | 2020-08-10 | Jefferson | Oregon | 41031 | 371 | 4 |
417120 | 417120 | 2020-08-09 | Jefferson | Oregon | 41031 | 360 | 4 |
413899 | 413899 | 2020-08-08 | Jefferson | Oregon | 41031 | 355 | 4 |
410679 | 410679 | 2020-08-07 | Jefferson | Oregon | 41031 | 346 | 4 |
407459 | 407459 | 2020-08-06 | Jefferson | Oregon | 41031 | 341 | 3 |
404240 | 404240 | 2020-08-05 | Jefferson | Oregon | 41031 | 332 | 3 |
401022 | 401022 | 2020-08-04 | Jefferson | Oregon | 41031 | 324 | 3 |
397807 | 397807 | 2020-08-03 | Jefferson | Oregon | 41031 | 311 | 3 |
394590 | 394590 | 2020-08-02 | Jefferson | Oregon | 41031 | 310 | 3 |
391374 | 391374 | 2020-08-01 | Jefferson | Oregon | 41031 | 303 | 3 |
388157 | 388157 | 2020-07-31 | Jefferson | Oregon | 41031 | 299 | 3 |
384940 | 384940 | 2020-07-30 | Jefferson | Oregon | 41031 | 293 | 3 |
381722 | 381722 | 2020-07-29 | Jefferson | Oregon | 41031 | 281 | 3 |
378505 | 378505 | 2020-07-28 | Jefferson | Oregon | 41031 | 276 | 3 |
375289 | 375289 | 2020-07-27 | Jefferson | Oregon | 41031 | 267 | 0 |
372076 | 372076 | 2020-07-26 | Jefferson | Oregon | 41031 | 258 | 0 |
368864 | 368864 | 2020-07-25 | Jefferson | Oregon | 41031 | 253 | 0 |
365655 | 365655 | 2020-07-24 | Jefferson | Oregon | 41031 | 244 | 0 |
362449 | 362449 | 2020-07-23 | Jefferson | Oregon | 41031 | 222 | 0 |
359243 | 359243 | 2020-07-22 | Jefferson | Oregon | 41031 | 219 | 0 |
356039 | 356039 | 2020-07-21 | Jefferson | Oregon | 41031 | 214 | 0 |
352836 | 352836 | 2020-07-20 | Jefferson | Oregon | 41031 | 206 | 0 |
349633 | 349633 | 2020-07-19 | Jefferson | Oregon | 41031 | 199 | 0 |
346433 | 346433 | 2020-07-18 | Jefferson | Oregon | 41031 | 185 | 0 |
343233 | 343233 | 2020-07-17 | Jefferson | Oregon | 41031 | 184 | 0 |
340035 | 340035 | 2020-07-16 | Jefferson | Oregon | 41031 | 177 | 0 |
336838 | 336838 | 2020-07-15 | Jefferson | Oregon | 41031 | 171 | 0 |
333644 | 333644 | 2020-07-14 | Jefferson | Oregon | 41031 | 169 | 0 |
330452 | 330452 | 2020-07-13 | Jefferson | Oregon | 41031 | 168 | 0 |
327266 | 327266 | 2020-07-12 | Jefferson | Oregon | 41031 | 168 | 0 |
324081 | 324081 | 2020-07-11 | Jefferson | Oregon | 41031 | 163 | 0 |
320901 | 320901 | 2020-07-10 | Jefferson | Oregon | 41031 | 160 | 0 |
317723 | 317723 | 2020-07-09 | Jefferson | Oregon | 41031 | 145 | 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);