ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77 rows where deaths = 3, fips = 37073 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
727654 | 727654 | 2020-11-13 | Gates | North Carolina | 37073 | 183 | 3 |
724410 | 724410 | 2020-11-12 | Gates | North Carolina | 37073 | 183 | 3 |
721167 | 721167 | 2020-11-11 | Gates | North Carolina | 37073 | 181 | 3 |
717924 | 717924 | 2020-11-10 | Gates | North Carolina | 37073 | 178 | 3 |
714681 | 714681 | 2020-11-09 | Gates | North Carolina | 37073 | 174 | 3 |
711437 | 711437 | 2020-11-08 | Gates | North Carolina | 37073 | 172 | 3 |
708193 | 708193 | 2020-11-07 | Gates | North Carolina | 37073 | 172 | 3 |
704950 | 704950 | 2020-11-06 | Gates | North Carolina | 37073 | 172 | 3 |
701707 | 701707 | 2020-11-05 | Gates | North Carolina | 37073 | 172 | 3 |
698463 | 698463 | 2020-11-04 | Gates | North Carolina | 37073 | 172 | 3 |
695220 | 695220 | 2020-11-03 | Gates | North Carolina | 37073 | 170 | 3 |
691978 | 691978 | 2020-11-02 | Gates | North Carolina | 37073 | 169 | 3 |
688734 | 688734 | 2020-11-01 | Gates | North Carolina | 37073 | 169 | 3 |
685489 | 685489 | 2020-10-31 | Gates | North Carolina | 37073 | 170 | 3 |
682246 | 682246 | 2020-10-30 | Gates | North Carolina | 37073 | 169 | 3 |
679003 | 679003 | 2020-10-29 | Gates | North Carolina | 37073 | 168 | 3 |
675760 | 675760 | 2020-10-28 | Gates | North Carolina | 37073 | 168 | 3 |
672517 | 672517 | 2020-10-27 | Gates | North Carolina | 37073 | 167 | 3 |
669275 | 669275 | 2020-10-26 | Gates | North Carolina | 37073 | 167 | 3 |
666031 | 666031 | 2020-10-25 | Gates | North Carolina | 37073 | 167 | 3 |
662786 | 662786 | 2020-10-24 | Gates | North Carolina | 37073 | 167 | 3 |
659542 | 659542 | 2020-10-23 | Gates | North Carolina | 37073 | 166 | 3 |
656298 | 656298 | 2020-10-22 | Gates | North Carolina | 37073 | 166 | 3 |
653053 | 653053 | 2020-10-21 | Gates | North Carolina | 37073 | 164 | 3 |
649808 | 649808 | 2020-10-20 | Gates | North Carolina | 37073 | 162 | 3 |
646564 | 646564 | 2020-10-19 | Gates | North Carolina | 37073 | 162 | 3 |
643318 | 643318 | 2020-10-18 | Gates | North Carolina | 37073 | 161 | 3 |
640070 | 640070 | 2020-10-17 | Gates | North Carolina | 37073 | 160 | 3 |
636824 | 636824 | 2020-10-16 | Gates | North Carolina | 37073 | 160 | 3 |
633578 | 633578 | 2020-10-15 | Gates | North Carolina | 37073 | 158 | 3 |
630333 | 630333 | 2020-10-14 | Gates | North Carolina | 37073 | 158 | 3 |
627089 | 627089 | 2020-10-13 | Gates | North Carolina | 37073 | 158 | 3 |
623847 | 623847 | 2020-10-12 | Gates | North Carolina | 37073 | 157 | 3 |
620604 | 620604 | 2020-10-11 | Gates | North Carolina | 37073 | 155 | 3 |
617362 | 617362 | 2020-10-10 | Gates | North Carolina | 37073 | 155 | 3 |
614120 | 614120 | 2020-10-09 | Gates | North Carolina | 37073 | 155 | 3 |
610879 | 610879 | 2020-10-08 | Gates | North Carolina | 37073 | 154 | 3 |
607637 | 607637 | 2020-10-07 | Gates | North Carolina | 37073 | 150 | 3 |
604394 | 604394 | 2020-10-06 | Gates | North Carolina | 37073 | 147 | 3 |
601152 | 601152 | 2020-10-05 | Gates | North Carolina | 37073 | 146 | 3 |
597909 | 597909 | 2020-10-04 | Gates | North Carolina | 37073 | 147 | 3 |
594666 | 594666 | 2020-10-03 | Gates | North Carolina | 37073 | 145 | 3 |
591425 | 591425 | 2020-10-02 | Gates | North Carolina | 37073 | 145 | 3 |
588184 | 588184 | 2020-10-01 | Gates | North Carolina | 37073 | 144 | 3 |
584944 | 584944 | 2020-09-30 | Gates | North Carolina | 37073 | 145 | 3 |
581703 | 581703 | 2020-09-29 | Gates | North Carolina | 37073 | 144 | 3 |
578463 | 578463 | 2020-09-28 | Gates | North Carolina | 37073 | 142 | 3 |
575222 | 575222 | 2020-09-27 | Gates | North Carolina | 37073 | 142 | 3 |
571978 | 571978 | 2020-09-26 | Gates | North Carolina | 37073 | 139 | 3 |
568736 | 568736 | 2020-09-25 | Gates | North Carolina | 37073 | 138 | 3 |
565495 | 565495 | 2020-09-24 | Gates | North Carolina | 37073 | 129 | 3 |
562254 | 562254 | 2020-09-23 | Gates | North Carolina | 37073 | 134 | 3 |
559017 | 559017 | 2020-09-22 | Gates | North Carolina | 37073 | 128 | 3 |
555780 | 555780 | 2020-09-21 | Gates | North Carolina | 37073 | 127 | 3 |
552543 | 552543 | 2020-09-20 | Gates | North Carolina | 37073 | 127 | 3 |
549304 | 549304 | 2020-09-19 | Gates | North Carolina | 37073 | 121 | 3 |
546065 | 546065 | 2020-09-18 | Gates | North Carolina | 37073 | 118 | 3 |
542828 | 542828 | 2020-09-17 | Gates | North Carolina | 37073 | 114 | 3 |
539592 | 539592 | 2020-09-16 | Gates | North Carolina | 37073 | 110 | 3 |
536355 | 536355 | 2020-09-15 | Gates | North Carolina | 37073 | 109 | 3 |
533119 | 533119 | 2020-09-14 | Gates | North Carolina | 37073 | 108 | 3 |
529884 | 529884 | 2020-09-13 | Gates | North Carolina | 37073 | 108 | 3 |
526647 | 526647 | 2020-09-12 | Gates | North Carolina | 37073 | 106 | 3 |
523411 | 523411 | 2020-09-11 | Gates | North Carolina | 37073 | 103 | 3 |
520175 | 520175 | 2020-09-10 | Gates | North Carolina | 37073 | 102 | 3 |
516939 | 516939 | 2020-09-09 | Gates | North Carolina | 37073 | 101 | 3 |
513704 | 513704 | 2020-09-08 | Gates | North Carolina | 37073 | 101 | 3 |
510471 | 510471 | 2020-09-07 | Gates | North Carolina | 37073 | 101 | 3 |
507238 | 507238 | 2020-09-06 | Gates | North Carolina | 37073 | 98 | 3 |
504006 | 504006 | 2020-09-05 | Gates | North Carolina | 37073 | 95 | 3 |
500772 | 500772 | 2020-09-04 | Gates | North Carolina | 37073 | 96 | 3 |
497538 | 497538 | 2020-09-03 | Gates | North Carolina | 37073 | 94 | 3 |
494305 | 494305 | 2020-09-02 | Gates | North Carolina | 37073 | 87 | 3 |
491071 | 491071 | 2020-09-01 | Gates | North Carolina | 37073 | 87 | 3 |
487838 | 487838 | 2020-08-31 | Gates | North Carolina | 37073 | 84 | 3 |
484605 | 484605 | 2020-08-30 | Gates | North Carolina | 37073 | 85 | 3 |
481370 | 481370 | 2020-08-29 | Gates | North Carolina | 37073 | 83 | 3 |
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);