ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lincoln" and fips = 41041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637130 | 637130 | 2020-10-16 | Lincoln | Oregon | 41041 | 507 | 13 |
633884 | 633884 | 2020-10-15 | Lincoln | Oregon | 41041 | 507 | 13 |
630639 | 630639 | 2020-10-14 | Lincoln | Oregon | 41041 | 503 | 13 |
627395 | 627395 | 2020-10-13 | Lincoln | Oregon | 41041 | 501 | 13 |
624153 | 624153 | 2020-10-12 | Lincoln | Oregon | 41041 | 496 | 13 |
620910 | 620910 | 2020-10-11 | Lincoln | Oregon | 41041 | 496 | 13 |
617668 | 617668 | 2020-10-10 | Lincoln | Oregon | 41041 | 495 | 13 |
614426 | 614426 | 2020-10-09 | Lincoln | Oregon | 41041 | 493 | 13 |
611185 | 611185 | 2020-10-08 | Lincoln | Oregon | 41041 | 492 | 13 |
607943 | 607943 | 2020-10-07 | Lincoln | Oregon | 41041 | 489 | 13 |
604700 | 604700 | 2020-10-06 | Lincoln | Oregon | 41041 | 488 | 13 |
601458 | 601458 | 2020-10-05 | Lincoln | Oregon | 41041 | 485 | 13 |
598215 | 598215 | 2020-10-04 | Lincoln | Oregon | 41041 | 485 | 13 |
594972 | 594972 | 2020-10-03 | Lincoln | Oregon | 41041 | 484 | 13 |
591731 | 591731 | 2020-10-02 | Lincoln | Oregon | 41041 | 482 | 13 |
588490 | 588490 | 2020-10-01 | Lincoln | Oregon | 41041 | 481 | 13 |
585250 | 585250 | 2020-09-30 | Lincoln | Oregon | 41041 | 481 | 13 |
582010 | 582010 | 2020-09-29 | Lincoln | Oregon | 41041 | 481 | 13 |
578770 | 578770 | 2020-09-28 | Lincoln | Oregon | 41041 | 482 | 13 |
575529 | 575529 | 2020-09-27 | Lincoln | Oregon | 41041 | 482 | 13 |
572285 | 572285 | 2020-09-26 | Lincoln | Oregon | 41041 | 481 | 13 |
569043 | 569043 | 2020-09-25 | Lincoln | Oregon | 41041 | 478 | 13 |
565802 | 565802 | 2020-09-24 | Lincoln | Oregon | 41041 | 476 | 13 |
562561 | 562561 | 2020-09-23 | Lincoln | Oregon | 41041 | 475 | 13 |
559324 | 559324 | 2020-09-22 | Lincoln | Oregon | 41041 | 474 | 13 |
556087 | 556087 | 2020-09-21 | Lincoln | Oregon | 41041 | 473 | 13 |
552850 | 552850 | 2020-09-20 | Lincoln | Oregon | 41041 | 472 | 13 |
549611 | 549611 | 2020-09-19 | Lincoln | Oregon | 41041 | 472 | 13 |
546372 | 546372 | 2020-09-18 | Lincoln | Oregon | 41041 | 470 | 13 |
543135 | 543135 | 2020-09-17 | Lincoln | Oregon | 41041 | 470 | 13 |
539899 | 539899 | 2020-09-16 | Lincoln | Oregon | 41041 | 470 | 13 |
536662 | 536662 | 2020-09-15 | Lincoln | Oregon | 41041 | 472 | 13 |
533426 | 533426 | 2020-09-14 | Lincoln | Oregon | 41041 | 472 | 13 |
530191 | 530191 | 2020-09-13 | Lincoln | Oregon | 41041 | 473 | 13 |
526954 | 526954 | 2020-09-12 | Lincoln | Oregon | 41041 | 472 | 13 |
523718 | 523718 | 2020-09-11 | Lincoln | Oregon | 41041 | 471 | 13 |
520482 | 520482 | 2020-09-10 | Lincoln | Oregon | 41041 | 471 | 13 |
517246 | 517246 | 2020-09-09 | Lincoln | Oregon | 41041 | 470 | 13 |
514011 | 514011 | 2020-09-08 | Lincoln | Oregon | 41041 | 470 | 13 |
510778 | 510778 | 2020-09-07 | Lincoln | Oregon | 41041 | 470 | 13 |
507545 | 507545 | 2020-09-06 | Lincoln | Oregon | 41041 | 469 | 13 |
504313 | 504313 | 2020-09-05 | Lincoln | Oregon | 41041 | 469 | 13 |
501079 | 501079 | 2020-09-04 | Lincoln | Oregon | 41041 | 467 | 13 |
497845 | 497845 | 2020-09-03 | Lincoln | Oregon | 41041 | 467 | 13 |
494612 | 494612 | 2020-09-02 | Lincoln | Oregon | 41041 | 466 | 13 |
491378 | 491378 | 2020-09-01 | Lincoln | Oregon | 41041 | 466 | 13 |
488145 | 488145 | 2020-08-31 | Lincoln | Oregon | 41041 | 466 | 13 |
484912 | 484912 | 2020-08-30 | Lincoln | Oregon | 41041 | 465 | 13 |
481677 | 481677 | 2020-08-29 | Lincoln | Oregon | 41041 | 464 | 13 |
478443 | 478443 | 2020-08-28 | Lincoln | Oregon | 41041 | 463 | 13 |
475210 | 475210 | 2020-08-27 | Lincoln | Oregon | 41041 | 459 | 13 |
471976 | 471976 | 2020-08-26 | Lincoln | Oregon | 41041 | 458 | 13 |
468744 | 468744 | 2020-08-25 | Lincoln | Oregon | 41041 | 456 | 13 |
465516 | 465516 | 2020-08-24 | Lincoln | Oregon | 41041 | 453 | 11 |
462287 | 462287 | 2020-08-23 | Lincoln | Oregon | 41041 | 453 | 11 |
459059 | 459059 | 2020-08-22 | Lincoln | Oregon | 41041 | 453 | 11 |
455831 | 455831 | 2020-08-21 | Lincoln | Oregon | 41041 | 450 | 11 |
452603 | 452603 | 2020-08-20 | Lincoln | Oregon | 41041 | 444 | 11 |
449375 | 449375 | 2020-08-19 | Lincoln | Oregon | 41041 | 440 | 11 |
446147 | 446147 | 2020-08-18 | Lincoln | Oregon | 41041 | 440 | 11 |
442921 | 442921 | 2020-08-17 | Lincoln | Oregon | 41041 | 440 | 9 |
439694 | 439694 | 2020-08-16 | Lincoln | Oregon | 41041 | 438 | 9 |
436469 | 436469 | 2020-08-15 | Lincoln | Oregon | 41041 | 437 | 9 |
433242 | 433242 | 2020-08-14 | Lincoln | Oregon | 41041 | 431 | 9 |
430016 | 430016 | 2020-08-13 | Lincoln | Oregon | 41041 | 428 | 9 |
426791 | 426791 | 2020-08-12 | Lincoln | Oregon | 41041 | 421 | 9 |
423568 | 423568 | 2020-08-11 | Lincoln | Oregon | 41041 | 419 | 9 |
420345 | 420345 | 2020-08-10 | Lincoln | Oregon | 41041 | 418 | 9 |
417125 | 417125 | 2020-08-09 | Lincoln | Oregon | 41041 | 416 | 9 |
413904 | 413904 | 2020-08-08 | Lincoln | Oregon | 41041 | 414 | 9 |
410684 | 410684 | 2020-08-07 | Lincoln | Oregon | 41041 | 412 | 9 |
407464 | 407464 | 2020-08-06 | Lincoln | Oregon | 41041 | 411 | 9 |
404245 | 404245 | 2020-08-05 | Lincoln | Oregon | 41041 | 414 | 9 |
401027 | 401027 | 2020-08-04 | Lincoln | Oregon | 41041 | 395 | 9 |
397812 | 397812 | 2020-08-03 | Lincoln | Oregon | 41041 | 395 | 9 |
394595 | 394595 | 2020-08-02 | Lincoln | Oregon | 41041 | 391 | 9 |
391379 | 391379 | 2020-08-01 | Lincoln | Oregon | 41041 | 391 | 9 |
388162 | 388162 | 2020-07-31 | Lincoln | Oregon | 41041 | 391 | 9 |
384945 | 384945 | 2020-07-30 | Lincoln | Oregon | 41041 | 385 | 8 |
381727 | 381727 | 2020-07-29 | Lincoln | Oregon | 41041 | 383 | 8 |
378510 | 378510 | 2020-07-28 | Lincoln | Oregon | 41041 | 381 | 8 |
375294 | 375294 | 2020-07-27 | Lincoln | Oregon | 41041 | 381 | 8 |
372081 | 372081 | 2020-07-26 | Lincoln | Oregon | 41041 | 380 | 8 |
368869 | 368869 | 2020-07-25 | Lincoln | Oregon | 41041 | 379 | 8 |
365660 | 365660 | 2020-07-24 | Lincoln | Oregon | 41041 | 377 | 8 |
362454 | 362454 | 2020-07-23 | Lincoln | Oregon | 41041 | 378 | 8 |
359248 | 359248 | 2020-07-22 | Lincoln | Oregon | 41041 | 373 | 8 |
356044 | 356044 | 2020-07-21 | Lincoln | Oregon | 41041 | 371 | 8 |
352841 | 352841 | 2020-07-20 | Lincoln | Oregon | 41041 | 371 | 8 |
349638 | 349638 | 2020-07-19 | Lincoln | Oregon | 41041 | 369 | 8 |
346438 | 346438 | 2020-07-18 | Lincoln | Oregon | 41041 | 368 | 8 |
343238 | 343238 | 2020-07-17 | Lincoln | Oregon | 41041 | 365 | 7 |
340040 | 340040 | 2020-07-16 | Lincoln | Oregon | 41041 | 364 | 7 |
336843 | 336843 | 2020-07-15 | Lincoln | Oregon | 41041 | 362 | 7 |
333649 | 333649 | 2020-07-14 | Lincoln | Oregon | 41041 | 360 | 7 |
330457 | 330457 | 2020-07-13 | Lincoln | Oregon | 41041 | 361 | 5 |
327271 | 327271 | 2020-07-12 | Lincoln | Oregon | 41041 | 361 | 5 |
324086 | 324086 | 2020-07-11 | Lincoln | Oregon | 41041 | 361 | 5 |
320906 | 320906 | 2020-07-10 | Lincoln | Oregon | 41041 | 362 | 5 |
317728 | 317728 | 2020-07-09 | Lincoln | Oregon | 41041 | 363 | 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);