ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where deaths = 3, fips = 37121 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 |
---|---|---|---|---|---|---|---|
627113 | 627113 | 2020-10-13 | Mitchell | North Carolina | 37121 | 177 | 3 |
623871 | 623871 | 2020-10-12 | Mitchell | North Carolina | 37121 | 174 | 3 |
620628 | 620628 | 2020-10-11 | Mitchell | North Carolina | 37121 | 174 | 3 |
617386 | 617386 | 2020-10-10 | Mitchell | North Carolina | 37121 | 173 | 3 |
614144 | 614144 | 2020-10-09 | Mitchell | North Carolina | 37121 | 172 | 3 |
610903 | 610903 | 2020-10-08 | Mitchell | North Carolina | 37121 | 172 | 3 |
607661 | 607661 | 2020-10-07 | Mitchell | North Carolina | 37121 | 171 | 3 |
604418 | 604418 | 2020-10-06 | Mitchell | North Carolina | 37121 | 172 | 3 |
601176 | 601176 | 2020-10-05 | Mitchell | North Carolina | 37121 | 173 | 3 |
597933 | 597933 | 2020-10-04 | Mitchell | North Carolina | 37121 | 168 | 3 |
594690 | 594690 | 2020-10-03 | Mitchell | North Carolina | 37121 | 168 | 3 |
591449 | 591449 | 2020-10-02 | Mitchell | North Carolina | 37121 | 167 | 3 |
588208 | 588208 | 2020-10-01 | Mitchell | North Carolina | 37121 | 166 | 3 |
584968 | 584968 | 2020-09-30 | Mitchell | North Carolina | 37121 | 161 | 3 |
581727 | 581727 | 2020-09-29 | Mitchell | North Carolina | 37121 | 159 | 3 |
578487 | 578487 | 2020-09-28 | Mitchell | North Carolina | 37121 | 158 | 3 |
575246 | 575246 | 2020-09-27 | Mitchell | North Carolina | 37121 | 157 | 3 |
572002 | 572002 | 2020-09-26 | Mitchell | North Carolina | 37121 | 151 | 3 |
568760 | 568760 | 2020-09-25 | Mitchell | North Carolina | 37121 | 150 | 3 |
565519 | 565519 | 2020-09-24 | Mitchell | North Carolina | 37121 | 105 | 3 |
562278 | 562278 | 2020-09-23 | Mitchell | North Carolina | 37121 | 104 | 3 |
559041 | 559041 | 2020-09-22 | Mitchell | North Carolina | 37121 | 105 | 3 |
555804 | 555804 | 2020-09-21 | Mitchell | North Carolina | 37121 | 105 | 3 |
552567 | 552567 | 2020-09-20 | Mitchell | North Carolina | 37121 | 104 | 3 |
549328 | 549328 | 2020-09-19 | Mitchell | North Carolina | 37121 | 102 | 3 |
546089 | 546089 | 2020-09-18 | Mitchell | North Carolina | 37121 | 102 | 3 |
542852 | 542852 | 2020-09-17 | Mitchell | North Carolina | 37121 | 101 | 3 |
539616 | 539616 | 2020-09-16 | Mitchell | North Carolina | 37121 | 101 | 3 |
536379 | 536379 | 2020-09-15 | Mitchell | North Carolina | 37121 | 101 | 3 |
533143 | 533143 | 2020-09-14 | Mitchell | North Carolina | 37121 | 99 | 3 |
529908 | 529908 | 2020-09-13 | Mitchell | North Carolina | 37121 | 97 | 3 |
526671 | 526671 | 2020-09-12 | Mitchell | North Carolina | 37121 | 96 | 3 |
523435 | 523435 | 2020-09-11 | Mitchell | North Carolina | 37121 | 94 | 3 |
520199 | 520199 | 2020-09-10 | Mitchell | North Carolina | 37121 | 94 | 3 |
516963 | 516963 | 2020-09-09 | Mitchell | North Carolina | 37121 | 94 | 3 |
513728 | 513728 | 2020-09-08 | Mitchell | North Carolina | 37121 | 94 | 3 |
510495 | 510495 | 2020-09-07 | Mitchell | North Carolina | 37121 | 94 | 3 |
507262 | 507262 | 2020-09-06 | Mitchell | North Carolina | 37121 | 94 | 3 |
504030 | 504030 | 2020-09-05 | Mitchell | North Carolina | 37121 | 93 | 3 |
500796 | 500796 | 2020-09-04 | Mitchell | North Carolina | 37121 | 93 | 3 |
497562 | 497562 | 2020-09-03 | Mitchell | North Carolina | 37121 | 93 | 3 |
494329 | 494329 | 2020-09-02 | Mitchell | North Carolina | 37121 | 94 | 3 |
491095 | 491095 | 2020-09-01 | Mitchell | North Carolina | 37121 | 93 | 3 |
487862 | 487862 | 2020-08-31 | Mitchell | North Carolina | 37121 | 93 | 3 |
484629 | 484629 | 2020-08-30 | Mitchell | North Carolina | 37121 | 93 | 3 |
481394 | 481394 | 2020-08-29 | Mitchell | North Carolina | 37121 | 92 | 3 |
478161 | 478161 | 2020-08-28 | Mitchell | North Carolina | 37121 | 90 | 3 |
474928 | 474928 | 2020-08-27 | Mitchell | North Carolina | 37121 | 89 | 3 |
471694 | 471694 | 2020-08-26 | Mitchell | North Carolina | 37121 | 89 | 3 |
465234 | 465234 | 2020-08-24 | Mitchell | North Carolina | 37121 | 89 | 3 |
462005 | 462005 | 2020-08-23 | Mitchell | North Carolina | 37121 | 88 | 3 |
458777 | 458777 | 2020-08-22 | Mitchell | North Carolina | 37121 | 84 | 3 |
455549 | 455549 | 2020-08-21 | Mitchell | North Carolina | 37121 | 84 | 3 |
452321 | 452321 | 2020-08-20 | Mitchell | North Carolina | 37121 | 83 | 3 |
449093 | 449093 | 2020-08-19 | Mitchell | North Carolina | 37121 | 82 | 3 |
445865 | 445865 | 2020-08-18 | Mitchell | North Carolina | 37121 | 80 | 3 |
442639 | 442639 | 2020-08-17 | Mitchell | North Carolina | 37121 | 80 | 3 |
439412 | 439412 | 2020-08-16 | Mitchell | North Carolina | 37121 | 80 | 3 |
436187 | 436187 | 2020-08-15 | Mitchell | North Carolina | 37121 | 80 | 3 |
432961 | 432961 | 2020-08-14 | Mitchell | North Carolina | 37121 | 80 | 3 |
429735 | 429735 | 2020-08-13 | Mitchell | North Carolina | 37121 | 81 | 3 |
426510 | 426510 | 2020-08-12 | Mitchell | North Carolina | 37121 | 80 | 3 |
423287 | 423287 | 2020-08-11 | Mitchell | North Carolina | 37121 | 78 | 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);