ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Union" and fips = 37179 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636877 | 636877 | 2020-10-16 | Union | North Carolina | 37179 | 5526 | 62 |
633631 | 633631 | 2020-10-15 | Union | North Carolina | 37179 | 5487 | 61 |
630386 | 630386 | 2020-10-14 | Union | North Carolina | 37179 | 5441 | 61 |
627142 | 627142 | 2020-10-13 | Union | North Carolina | 37179 | 5405 | 61 |
623900 | 623900 | 2020-10-12 | Union | North Carolina | 37179 | 5364 | 61 |
620657 | 620657 | 2020-10-11 | Union | North Carolina | 37179 | 5347 | 60 |
617415 | 617415 | 2020-10-10 | Union | North Carolina | 37179 | 5324 | 60 |
614173 | 614173 | 2020-10-09 | Union | North Carolina | 37179 | 5277 | 60 |
610932 | 610932 | 2020-10-08 | Union | North Carolina | 37179 | 5232 | 59 |
607690 | 607690 | 2020-10-07 | Union | North Carolina | 37179 | 5200 | 59 |
604447 | 604447 | 2020-10-06 | Union | North Carolina | 37179 | 5141 | 59 |
601205 | 601205 | 2020-10-05 | Union | North Carolina | 37179 | 5108 | 59 |
597962 | 597962 | 2020-10-04 | Union | North Carolina | 37179 | 5061 | 59 |
594719 | 594719 | 2020-10-03 | Union | North Carolina | 37179 | 5046 | 59 |
591478 | 591478 | 2020-10-02 | Union | North Carolina | 37179 | 4984 | 59 |
588237 | 588237 | 2020-10-01 | Union | North Carolina | 37179 | 4943 | 59 |
584997 | 584997 | 2020-09-30 | Union | North Carolina | 37179 | 4896 | 59 |
581756 | 581756 | 2020-09-29 | Union | North Carolina | 37179 | 4849 | 59 |
578516 | 578516 | 2020-09-28 | Union | North Carolina | 37179 | 4834 | 59 |
575275 | 575275 | 2020-09-27 | Union | North Carolina | 37179 | 4799 | 59 |
572031 | 572031 | 2020-09-26 | Union | North Carolina | 37179 | 4778 | 59 |
568789 | 568789 | 2020-09-25 | Union | North Carolina | 37179 | 4750 | 59 |
565548 | 565548 | 2020-09-24 | Union | North Carolina | 37179 | 4698 | 58 |
562307 | 562307 | 2020-09-23 | Union | North Carolina | 37179 | 4698 | 58 |
559070 | 559070 | 2020-09-22 | Union | North Carolina | 37179 | 4650 | 58 |
555833 | 555833 | 2020-09-21 | Union | North Carolina | 37179 | 4650 | 58 |
552596 | 552596 | 2020-09-20 | Union | North Carolina | 37179 | 4596 | 58 |
549357 | 549357 | 2020-09-19 | Union | North Carolina | 37179 | 4596 | 58 |
546118 | 546118 | 2020-09-18 | Union | North Carolina | 37179 | 4596 | 58 |
542881 | 542881 | 2020-09-17 | Union | North Carolina | 37179 | 4536 | 57 |
539645 | 539645 | 2020-09-16 | Union | North Carolina | 37179 | 4536 | 57 |
536408 | 536408 | 2020-09-15 | Union | North Carolina | 37179 | 4474 | 56 |
533172 | 533172 | 2020-09-14 | Union | North Carolina | 37179 | 4474 | 56 |
529937 | 529937 | 2020-09-13 | Union | North Carolina | 37179 | 4371 | 56 |
526700 | 526700 | 2020-09-12 | Union | North Carolina | 37179 | 4371 | 56 |
523464 | 523464 | 2020-09-11 | Union | North Carolina | 37179 | 4371 | 56 |
520228 | 520228 | 2020-09-10 | Union | North Carolina | 37179 | 4298 | 55 |
516992 | 516992 | 2020-09-09 | Union | North Carolina | 37179 | 4298 | 55 |
513757 | 513757 | 2020-09-08 | Union | North Carolina | 37179 | 4236 | 52 |
510524 | 510524 | 2020-09-07 | Union | North Carolina | 37179 | 4236 | 52 |
507291 | 507291 | 2020-09-06 | Union | North Carolina | 37179 | 4161 | 52 |
504059 | 504059 | 2020-09-05 | Union | North Carolina | 37179 | 4161 | 52 |
500825 | 500825 | 2020-09-04 | Union | North Carolina | 37179 | 4161 | 52 |
497591 | 497591 | 2020-09-03 | Union | North Carolina | 37179 | 4090 | 52 |
494358 | 494358 | 2020-09-02 | Union | North Carolina | 37179 | 4090 | 52 |
491124 | 491124 | 2020-09-01 | Union | North Carolina | 37179 | 4008 | 52 |
487891 | 487891 | 2020-08-31 | Union | North Carolina | 37179 | 4008 | 52 |
484658 | 484658 | 2020-08-30 | Union | North Carolina | 37179 | 3912 | 48 |
481423 | 481423 | 2020-08-29 | Union | North Carolina | 37179 | 3912 | 48 |
478190 | 478190 | 2020-08-28 | Union | North Carolina | 37179 | 3912 | 48 |
474957 | 474957 | 2020-08-27 | Union | North Carolina | 37179 | 3838 | 48 |
471723 | 471723 | 2020-08-26 | Union | North Carolina | 37179 | 3838 | 48 |
468491 | 468491 | 2020-08-25 | Union | North Carolina | 37179 | 3766 | 47 |
465263 | 465263 | 2020-08-24 | Union | North Carolina | 37179 | 3766 | 47 |
462034 | 462034 | 2020-08-23 | Union | North Carolina | 37179 | 3679 | 47 |
458806 | 458806 | 2020-08-22 | Union | North Carolina | 37179 | 3662 | 47 |
455578 | 455578 | 2020-08-21 | Union | North Carolina | 37179 | 3662 | 47 |
452350 | 452350 | 2020-08-20 | Union | North Carolina | 37179 | 3551 | 47 |
449122 | 449122 | 2020-08-19 | Union | North Carolina | 37179 | 3549 | 47 |
445894 | 445894 | 2020-08-18 | Union | North Carolina | 37179 | 3461 | 46 |
442668 | 442668 | 2020-08-17 | Union | North Carolina | 37179 | 3461 | 46 |
439441 | 439441 | 2020-08-16 | Union | North Carolina | 37179 | 3375 | 44 |
436216 | 436216 | 2020-08-15 | Union | North Carolina | 37179 | 3337 | 44 |
432990 | 432990 | 2020-08-14 | Union | North Carolina | 37179 | 3337 | 44 |
429764 | 429764 | 2020-08-13 | Union | North Carolina | 37179 | 3222 | 43 |
426539 | 426539 | 2020-08-12 | Union | North Carolina | 37179 | 3207 | 43 |
423316 | 423316 | 2020-08-11 | Union | North Carolina | 37179 | 3146 | 43 |
420093 | 420093 | 2020-08-10 | Union | North Carolina | 37179 | 3146 | 43 |
416873 | 416873 | 2020-08-09 | Union | North Carolina | 37179 | 3096 | 43 |
413652 | 413652 | 2020-08-08 | Union | North Carolina | 37179 | 3072 | 43 |
410432 | 410432 | 2020-08-07 | Union | North Carolina | 37179 | 3025 | 43 |
407212 | 407212 | 2020-08-06 | Union | North Carolina | 37179 | 2975 | 43 |
403993 | 403993 | 2020-08-05 | Union | North Carolina | 37179 | 2931 | 43 |
400775 | 400775 | 2020-08-04 | Union | North Carolina | 37179 | 2881 | 43 |
397560 | 397560 | 2020-08-03 | Union | North Carolina | 37179 | 2845 | 43 |
394343 | 394343 | 2020-08-02 | Union | North Carolina | 37179 | 2802 | 41 |
391127 | 391127 | 2020-08-01 | Union | North Carolina | 37179 | 2762 | 41 |
387910 | 387910 | 2020-07-31 | Union | North Carolina | 37179 | 2727 | 41 |
384693 | 384693 | 2020-07-30 | Union | North Carolina | 37179 | 2671 | 39 |
381475 | 381475 | 2020-07-29 | Union | North Carolina | 37179 | 2624 | 39 |
378258 | 378258 | 2020-07-28 | Union | North Carolina | 37179 | 2572 | 38 |
375042 | 375042 | 2020-07-27 | Union | North Carolina | 37179 | 2533 | 38 |
371830 | 371830 | 2020-07-26 | Union | North Carolina | 37179 | 2503 | 35 |
368618 | 368618 | 2020-07-25 | Union | North Carolina | 37179 | 2470 | 35 |
365409 | 365409 | 2020-07-24 | Union | North Carolina | 37179 | 2416 | 35 |
362203 | 362203 | 2020-07-23 | Union | North Carolina | 37179 | 2356 | 34 |
358997 | 358997 | 2020-07-22 | Union | North Carolina | 37179 | 2287 | 33 |
355793 | 355793 | 2020-07-21 | Union | North Carolina | 37179 | 2251 | 33 |
352590 | 352590 | 2020-07-20 | Union | North Carolina | 37179 | 2215 | 33 |
349387 | 349387 | 2020-07-19 | Union | North Carolina | 37179 | 2190 | 32 |
346186 | 346186 | 2020-07-18 | Union | North Carolina | 37179 | 2145 | 30 |
342987 | 342987 | 2020-07-17 | Union | North Carolina | 37179 | 2091 | 30 |
339789 | 339789 | 2020-07-16 | Union | North Carolina | 37179 | 2036 | 30 |
336593 | 336593 | 2020-07-15 | Union | North Carolina | 37179 | 2004 | 30 |
333399 | 333399 | 2020-07-14 | Union | North Carolina | 37179 | 1909 | 30 |
330209 | 330209 | 2020-07-13 | Union | North Carolina | 37179 | 1864 | 30 |
327022 | 327022 | 2020-07-12 | Union | North Carolina | 37179 | 1821 | 26 |
323838 | 323838 | 2020-07-11 | Union | North Carolina | 37179 | 1778 | 25 |
320658 | 320658 | 2020-07-10 | Union | North Carolina | 37179 | 1712 | 25 |
317481 | 317481 | 2020-07-09 | Union | North Carolina | 37179 | 1643 | 25 |
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);