ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Union" and fips = 41061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637140 | 637140 | 2020-10-16 | Union | Oregon | 41061 | 455 | 2 |
633894 | 633894 | 2020-10-15 | Union | Oregon | 41061 | 455 | 2 |
630649 | 630649 | 2020-10-14 | Union | Oregon | 41061 | 453 | 2 |
627405 | 627405 | 2020-10-13 | Union | Oregon | 41061 | 453 | 2 |
624163 | 624163 | 2020-10-12 | Union | Oregon | 41061 | 451 | 2 |
620920 | 620920 | 2020-10-11 | Union | Oregon | 41061 | 451 | 2 |
617678 | 617678 | 2020-10-10 | Union | Oregon | 41061 | 451 | 2 |
614436 | 614436 | 2020-10-09 | Union | Oregon | 41061 | 451 | 2 |
611195 | 611195 | 2020-10-08 | Union | Oregon | 41061 | 449 | 2 |
607953 | 607953 | 2020-10-07 | Union | Oregon | 41061 | 447 | 2 |
604710 | 604710 | 2020-10-06 | Union | Oregon | 41061 | 447 | 2 |
601468 | 601468 | 2020-10-05 | Union | Oregon | 41061 | 446 | 2 |
598225 | 598225 | 2020-10-04 | Union | Oregon | 41061 | 446 | 2 |
594982 | 594982 | 2020-10-03 | Union | Oregon | 41061 | 446 | 2 |
591741 | 591741 | 2020-10-02 | Union | Oregon | 41061 | 445 | 2 |
588500 | 588500 | 2020-10-01 | Union | Oregon | 41061 | 446 | 2 |
585260 | 585260 | 2020-09-30 | Union | Oregon | 41061 | 446 | 2 |
582020 | 582020 | 2020-09-29 | Union | Oregon | 41061 | 446 | 2 |
578780 | 578780 | 2020-09-28 | Union | Oregon | 41061 | 446 | 2 |
575539 | 575539 | 2020-09-27 | Union | Oregon | 41061 | 446 | 2 |
572295 | 572295 | 2020-09-26 | Union | Oregon | 41061 | 446 | 2 |
569053 | 569053 | 2020-09-25 | Union | Oregon | 41061 | 443 | 2 |
565812 | 565812 | 2020-09-24 | Union | Oregon | 41061 | 439 | 2 |
562571 | 562571 | 2020-09-23 | Union | Oregon | 41061 | 435 | 2 |
559334 | 559334 | 2020-09-22 | Union | Oregon | 41061 | 435 | 2 |
556097 | 556097 | 2020-09-21 | Union | Oregon | 41061 | 435 | 2 |
552860 | 552860 | 2020-09-20 | Union | Oregon | 41061 | 435 | 2 |
549621 | 549621 | 2020-09-19 | Union | Oregon | 41061 | 435 | 2 |
546382 | 546382 | 2020-09-18 | Union | Oregon | 41061 | 435 | 2 |
543145 | 543145 | 2020-09-17 | Union | Oregon | 41061 | 435 | 2 |
539909 | 539909 | 2020-09-16 | Union | Oregon | 41061 | 435 | 2 |
536672 | 536672 | 2020-09-15 | Union | Oregon | 41061 | 433 | 2 |
533436 | 533436 | 2020-09-14 | Union | Oregon | 41061 | 432 | 2 |
530201 | 530201 | 2020-09-13 | Union | Oregon | 41061 | 431 | 2 |
526964 | 526964 | 2020-09-12 | Union | Oregon | 41061 | 431 | 2 |
523728 | 523728 | 2020-09-11 | Union | Oregon | 41061 | 429 | 2 |
520492 | 520492 | 2020-09-10 | Union | Oregon | 41061 | 427 | 2 |
517256 | 517256 | 2020-09-09 | Union | Oregon | 41061 | 424 | 2 |
514021 | 514021 | 2020-09-08 | Union | Oregon | 41061 | 423 | 2 |
510788 | 510788 | 2020-09-07 | Union | Oregon | 41061 | 423 | 2 |
507555 | 507555 | 2020-09-06 | Union | Oregon | 41061 | 423 | 2 |
504323 | 504323 | 2020-09-05 | Union | Oregon | 41061 | 423 | 2 |
501089 | 501089 | 2020-09-04 | Union | Oregon | 41061 | 420 | 2 |
497855 | 497855 | 2020-09-03 | Union | Oregon | 41061 | 419 | 2 |
494622 | 494622 | 2020-09-02 | Union | Oregon | 41061 | 420 | 2 |
491388 | 491388 | 2020-09-01 | Union | Oregon | 41061 | 420 | 2 |
488155 | 488155 | 2020-08-31 | Union | Oregon | 41061 | 419 | 2 |
484922 | 484922 | 2020-08-30 | Union | Oregon | 41061 | 419 | 2 |
481687 | 481687 | 2020-08-29 | Union | Oregon | 41061 | 418 | 2 |
478453 | 478453 | 2020-08-28 | Union | Oregon | 41061 | 414 | 2 |
475220 | 475220 | 2020-08-27 | Union | Oregon | 41061 | 412 | 2 |
471986 | 471986 | 2020-08-26 | Union | Oregon | 41061 | 410 | 2 |
468754 | 468754 | 2020-08-25 | Union | Oregon | 41061 | 409 | 2 |
465526 | 465526 | 2020-08-24 | Union | Oregon | 41061 | 408 | 2 |
462297 | 462297 | 2020-08-23 | Union | Oregon | 41061 | 408 | 2 |
459069 | 459069 | 2020-08-22 | Union | Oregon | 41061 | 408 | 2 |
455841 | 455841 | 2020-08-21 | Union | Oregon | 41061 | 407 | 2 |
452613 | 452613 | 2020-08-20 | Union | Oregon | 41061 | 406 | 2 |
449385 | 449385 | 2020-08-19 | Union | Oregon | 41061 | 403 | 2 |
446157 | 446157 | 2020-08-18 | Union | Oregon | 41061 | 400 | 2 |
442931 | 442931 | 2020-08-17 | Union | Oregon | 41061 | 398 | 2 |
439704 | 439704 | 2020-08-16 | Union | Oregon | 41061 | 398 | 2 |
436479 | 436479 | 2020-08-15 | Union | Oregon | 41061 | 398 | 2 |
433252 | 433252 | 2020-08-14 | Union | Oregon | 41061 | 397 | 2 |
430026 | 430026 | 2020-08-13 | Union | Oregon | 41061 | 397 | 2 |
426801 | 426801 | 2020-08-12 | Union | Oregon | 41061 | 395 | 2 |
423578 | 423578 | 2020-08-11 | Union | Oregon | 41061 | 395 | 2 |
420355 | 420355 | 2020-08-10 | Union | Oregon | 41061 | 394 | 2 |
417135 | 417135 | 2020-08-09 | Union | Oregon | 41061 | 394 | 2 |
413914 | 413914 | 2020-08-08 | Union | Oregon | 41061 | 394 | 2 |
410694 | 410694 | 2020-08-07 | Union | Oregon | 41061 | 394 | 2 |
407474 | 407474 | 2020-08-06 | Union | Oregon | 41061 | 392 | 2 |
404255 | 404255 | 2020-08-05 | Union | Oregon | 41061 | 392 | 2 |
401037 | 401037 | 2020-08-04 | Union | Oregon | 41061 | 392 | 2 |
397822 | 397822 | 2020-08-03 | Union | Oregon | 41061 | 388 | 2 |
394605 | 394605 | 2020-08-02 | Union | Oregon | 41061 | 388 | 2 |
391389 | 391389 | 2020-08-01 | Union | Oregon | 41061 | 388 | 2 |
388172 | 388172 | 2020-07-31 | Union | Oregon | 41061 | 388 | 2 |
384955 | 384955 | 2020-07-30 | Union | Oregon | 41061 | 386 | 2 |
381737 | 381737 | 2020-07-29 | Union | Oregon | 41061 | 386 | 2 |
378520 | 378520 | 2020-07-28 | Union | Oregon | 41061 | 385 | 2 |
375304 | 375304 | 2020-07-27 | Union | Oregon | 41061 | 385 | 2 |
372091 | 372091 | 2020-07-26 | Union | Oregon | 41061 | 385 | 2 |
368879 | 368879 | 2020-07-25 | Union | Oregon | 41061 | 385 | 2 |
365670 | 365670 | 2020-07-24 | Union | Oregon | 41061 | 385 | 2 |
362464 | 362464 | 2020-07-23 | Union | Oregon | 41061 | 385 | 2 |
359258 | 359258 | 2020-07-22 | Union | Oregon | 41061 | 385 | 2 |
356054 | 356054 | 2020-07-21 | Union | Oregon | 41061 | 385 | 2 |
352851 | 352851 | 2020-07-20 | Union | Oregon | 41061 | 383 | 2 |
349648 | 349648 | 2020-07-19 | Union | Oregon | 41061 | 383 | 2 |
346448 | 346448 | 2020-07-18 | Union | Oregon | 41061 | 383 | 2 |
343248 | 343248 | 2020-07-17 | Union | Oregon | 41061 | 379 | 2 |
340050 | 340050 | 2020-07-16 | Union | Oregon | 41061 | 377 | 2 |
336853 | 336853 | 2020-07-15 | Union | Oregon | 41061 | 376 | 2 |
333659 | 333659 | 2020-07-14 | Union | Oregon | 41061 | 372 | 2 |
330467 | 330467 | 2020-07-13 | Union | Oregon | 41061 | 369 | 2 |
327281 | 327281 | 2020-07-12 | Union | Oregon | 41061 | 369 | 2 |
324096 | 324096 | 2020-07-11 | Union | Oregon | 41061 | 369 | 2 |
320916 | 320916 | 2020-07-10 | Union | Oregon | 41061 | 368 | 2 |
317738 | 317738 | 2020-07-09 | Union | Oregon | 41061 | 367 | 1 |
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);