ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Marion" and fips = 41047 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
245394 | 245394 | 2020-06-16 | Marion | Oregon | 41047 | 1201 | 31 |
248507 | 248507 | 2020-06-17 | Marion | Oregon | 41047 | 1218 | 31 |
251622 | 251622 | 2020-06-18 | Marion | Oregon | 41047 | 1244 | 33 |
254737 | 254737 | 2020-06-19 | Marion | Oregon | 41047 | 1264 | 34 |
257863 | 257863 | 2020-06-20 | Marion | Oregon | 41047 | 1264 | 34 |
260990 | 260990 | 2020-06-21 | Marion | Oregon | 41047 | 1301 | 34 |
264118 | 264118 | 2020-06-22 | Marion | Oregon | 41047 | 1348 | 35 |
267246 | 267246 | 2020-06-23 | Marion | Oregon | 41047 | 1365 | 35 |
270380 | 270380 | 2020-06-24 | Marion | Oregon | 41047 | 1378 | 36 |
273519 | 273519 | 2020-06-25 | Marion | Oregon | 41047 | 1382 | 38 |
276666 | 276666 | 2020-06-26 | Marion | Oregon | 41047 | 1400 | 41 |
279814 | 279814 | 2020-06-27 | Marion | Oregon | 41047 | 1432 | 41 |
282960 | 282960 | 2020-06-28 | Marion | Oregon | 41047 | 1475 | 41 |
286105 | 286105 | 2020-06-29 | Marion | Oregon | 41047 | 1489 | 43 |
289256 | 289256 | 2020-06-30 | Marion | Oregon | 41047 | 1514 | 46 |
292408 | 292408 | 2020-07-01 | Marion | Oregon | 41047 | 1539 | 47 |
295564 | 295564 | 2020-07-02 | Marion | Oregon | 41047 | 1564 | 47 |
298723 | 298723 | 2020-07-03 | Marion | Oregon | 41047 | 1595 | 47 |
301887 | 301887 | 2020-07-04 | Marion | Oregon | 41047 | 1610 | 47 |
305050 | 305050 | 2020-07-05 | Marion | Oregon | 41047 | 1648 | 48 |
308217 | 308217 | 2020-07-06 | Marion | Oregon | 41047 | 1661 | 48 |
311386 | 311386 | 2020-07-07 | Marion | Oregon | 41047 | 1683 | 50 |
314558 | 314558 | 2020-07-08 | Marion | Oregon | 41047 | 1697 | 51 |
317731 | 317731 | 2020-07-09 | Marion | Oregon | 41047 | 1743 | 53 |
320909 | 320909 | 2020-07-10 | Marion | Oregon | 41047 | 1770 | 53 |
324089 | 324089 | 2020-07-11 | Marion | Oregon | 41047 | 1831 | 53 |
327274 | 327274 | 2020-07-12 | Marion | Oregon | 41047 | 1859 | 53 |
330460 | 330460 | 2020-07-13 | Marion | Oregon | 41047 | 1893 | 54 |
333652 | 333652 | 2020-07-14 | Marion | Oregon | 41047 | 1939 | 56 |
336846 | 336846 | 2020-07-15 | Marion | Oregon | 41047 | 1975 | 56 |
340043 | 340043 | 2020-07-16 | Marion | Oregon | 41047 | 2028 | 56 |
343241 | 343241 | 2020-07-17 | Marion | Oregon | 41047 | 2063 | 57 |
346441 | 346441 | 2020-07-18 | Marion | Oregon | 41047 | 2093 | 58 |
349641 | 349641 | 2020-07-19 | Marion | Oregon | 41047 | 2140 | 60 |
352844 | 352844 | 2020-07-20 | Marion | Oregon | 41047 | 2170 | 62 |
356047 | 356047 | 2020-07-21 | Marion | Oregon | 41047 | 2210 | 62 |
359251 | 359251 | 2020-07-22 | Marion | Oregon | 41047 | 2238 | 62 |
362457 | 362457 | 2020-07-23 | Marion | Oregon | 41047 | 2277 | 63 |
365663 | 365663 | 2020-07-24 | Marion | Oregon | 41047 | 2333 | 64 |
368872 | 368872 | 2020-07-25 | Marion | Oregon | 41047 | 2385 | 64 |
372084 | 372084 | 2020-07-26 | Marion | Oregon | 41047 | 2413 | 65 |
375297 | 375297 | 2020-07-27 | Marion | Oregon | 41047 | 2437 | 65 |
378513 | 378513 | 2020-07-28 | Marion | Oregon | 41047 | 2474 | 67 |
381730 | 381730 | 2020-07-29 | Marion | Oregon | 41047 | 2495 | 67 |
384948 | 384948 | 2020-07-30 | Marion | Oregon | 41047 | 2541 | 67 |
388165 | 388165 | 2020-07-31 | Marion | Oregon | 41047 | 2575 | 67 |
391382 | 391382 | 2020-08-01 | Marion | Oregon | 41047 | 2614 | 67 |
394598 | 394598 | 2020-08-02 | Marion | Oregon | 41047 | 2667 | 67 |
397815 | 397815 | 2020-08-03 | Marion | Oregon | 41047 | 2692 | 68 |
401030 | 401030 | 2020-08-04 | Marion | Oregon | 41047 | 2713 | 68 |
404248 | 404248 | 2020-08-05 | Marion | Oregon | 41047 | 2755 | 68 |
407467 | 407467 | 2020-08-06 | Marion | Oregon | 41047 | 2789 | 68 |
410687 | 410687 | 2020-08-07 | Marion | Oregon | 41047 | 2837 | 69 |
413907 | 413907 | 2020-08-08 | Marion | Oregon | 41047 | 2883 | 70 |
417128 | 417128 | 2020-08-09 | Marion | Oregon | 41047 | 2911 | 70 |
420348 | 420348 | 2020-08-10 | Marion | Oregon | 41047 | 2938 | 70 |
423571 | 423571 | 2020-08-11 | Marion | Oregon | 41047 | 2979 | 73 |
426794 | 426794 | 2020-08-12 | Marion | Oregon | 41047 | 3005 | 73 |
430019 | 430019 | 2020-08-13 | Marion | Oregon | 41047 | 3040 | 73 |
433245 | 433245 | 2020-08-14 | Marion | Oregon | 41047 | 3090 | 73 |
436472 | 436472 | 2020-08-15 | Marion | Oregon | 41047 | 3165 | 73 |
439697 | 439697 | 2020-08-16 | Marion | Oregon | 41047 | 3204 | 73 |
442924 | 442924 | 2020-08-17 | Marion | Oregon | 41047 | 3234 | 73 |
446150 | 446150 | 2020-08-18 | Marion | Oregon | 41047 | 3284 | 73 |
449378 | 449378 | 2020-08-19 | Marion | Oregon | 41047 | 3315 | 73 |
452606 | 452606 | 2020-08-20 | Marion | Oregon | 41047 | 3369 | 73 |
455834 | 455834 | 2020-08-21 | Marion | Oregon | 41047 | 3425 | 74 |
459062 | 459062 | 2020-08-22 | Marion | Oregon | 41047 | 3476 | 75 |
462290 | 462290 | 2020-08-23 | Marion | Oregon | 41047 | 3516 | 75 |
465519 | 465519 | 2020-08-24 | Marion | Oregon | 41047 | 3547 | 75 |
468747 | 468747 | 2020-08-25 | Marion | Oregon | 41047 | 3587 | 77 |
471979 | 471979 | 2020-08-26 | Marion | Oregon | 41047 | 3624 | 77 |
475213 | 475213 | 2020-08-27 | Marion | Oregon | 41047 | 3662 | 77 |
478446 | 478446 | 2020-08-28 | Marion | Oregon | 41047 | 3706 | 78 |
481680 | 481680 | 2020-08-29 | Marion | Oregon | 41047 | 3746 | 79 |
484915 | 484915 | 2020-08-30 | Marion | Oregon | 41047 | 3794 | 80 |
488148 | 488148 | 2020-08-31 | Marion | Oregon | 41047 | 3830 | 80 |
491381 | 491381 | 2020-09-01 | Marion | Oregon | 41047 | 3870 | 80 |
494615 | 494615 | 2020-09-02 | Marion | Oregon | 41047 | 3887 | 80 |
497848 | 497848 | 2020-09-03 | Marion | Oregon | 41047 | 3920 | 81 |
501082 | 501082 | 2020-09-04 | Marion | Oregon | 41047 | 3964 | 81 |
504316 | 504316 | 2020-09-05 | Marion | Oregon | 41047 | 4013 | 82 |
507548 | 507548 | 2020-09-06 | Marion | Oregon | 41047 | 4043 | 82 |
510781 | 510781 | 2020-09-07 | Marion | Oregon | 41047 | 4061 | 82 |
514014 | 514014 | 2020-09-08 | Marion | Oregon | 41047 | 4085 | 85 |
517249 | 517249 | 2020-09-09 | Marion | Oregon | 41047 | 4106 | 85 |
520485 | 520485 | 2020-09-10 | Marion | Oregon | 41047 | 4141 | 85 |
523721 | 523721 | 2020-09-11 | Marion | Oregon | 41047 | 4174 | 85 |
526957 | 526957 | 2020-09-12 | Marion | Oregon | 41047 | 4222 | 85 |
530194 | 530194 | 2020-09-13 | Marion | Oregon | 41047 | 4248 | 87 |
533429 | 533429 | 2020-09-14 | Marion | Oregon | 41047 | 4258 | 87 |
536665 | 536665 | 2020-09-15 | Marion | Oregon | 41047 | 4287 | 88 |
539902 | 539902 | 2020-09-16 | Marion | Oregon | 41047 | 4309 | 88 |
543138 | 543138 | 2020-09-17 | Marion | Oregon | 41047 | 4336 | 89 |
546375 | 546375 | 2020-09-18 | Marion | Oregon | 41047 | 4387 | 89 |
549614 | 549614 | 2020-09-19 | Marion | Oregon | 41047 | 4427 | 89 |
552853 | 552853 | 2020-09-20 | Marion | Oregon | 41047 | 4447 | 90 |
556090 | 556090 | 2020-09-21 | Marion | Oregon | 41047 | 4466 | 90 |
559327 | 559327 | 2020-09-22 | Marion | Oregon | 41047 | 4504 | 91 |
562564 | 562564 | 2020-09-23 | Marion | Oregon | 41047 | 4522 | 92 |
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);