ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Hoke" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
276376 | 276376 | 2020-06-26 | Hoke | North Carolina | 37093 | 341 | 3 |
279524 | 279524 | 2020-06-27 | Hoke | North Carolina | 37093 | 352 | 3 |
282670 | 282670 | 2020-06-28 | Hoke | North Carolina | 37093 | 357 | 3 |
285815 | 285815 | 2020-06-29 | Hoke | North Carolina | 37093 | 361 | 3 |
288965 | 288965 | 2020-06-30 | Hoke | North Carolina | 37093 | 371 | 3 |
292117 | 292117 | 2020-07-01 | Hoke | North Carolina | 37093 | 383 | 3 |
295272 | 295272 | 2020-07-02 | Hoke | North Carolina | 37093 | 388 | 3 |
298432 | 298432 | 2020-07-03 | Hoke | North Carolina | 37093 | 391 | 3 |
301595 | 301595 | 2020-07-04 | Hoke | North Carolina | 37093 | 389 | 3 |
304758 | 304758 | 2020-07-05 | Hoke | North Carolina | 37093 | 403 | 3 |
307925 | 307925 | 2020-07-06 | Hoke | North Carolina | 37093 | 407 | 3 |
311093 | 311093 | 2020-07-07 | Hoke | North Carolina | 37093 | 415 | 3 |
314264 | 314264 | 2020-07-08 | Hoke | North Carolina | 37093 | 423 | 3 |
317438 | 317438 | 2020-07-09 | Hoke | North Carolina | 37093 | 434 | 4 |
320615 | 320615 | 2020-07-10 | Hoke | North Carolina | 37093 | 444 | 5 |
323795 | 323795 | 2020-07-11 | Hoke | North Carolina | 37093 | 454 | 5 |
326979 | 326979 | 2020-07-12 | Hoke | North Carolina | 37093 | 458 | 4 |
330166 | 330166 | 2020-07-13 | Hoke | North Carolina | 37093 | 467 | 4 |
333356 | 333356 | 2020-07-14 | Hoke | North Carolina | 37093 | 480 | 4 |
336550 | 336550 | 2020-07-15 | Hoke | North Carolina | 37093 | 482 | 4 |
339746 | 339746 | 2020-07-16 | Hoke | North Carolina | 37093 | 491 | 4 |
342944 | 342944 | 2020-07-17 | Hoke | North Carolina | 37093 | 509 | 5 |
346143 | 346143 | 2020-07-18 | Hoke | North Carolina | 37093 | 531 | 5 |
349344 | 349344 | 2020-07-19 | Hoke | North Carolina | 37093 | 540 | 5 |
352547 | 352547 | 2020-07-20 | Hoke | North Carolina | 37093 | 547 | 5 |
355750 | 355750 | 2020-07-21 | Hoke | North Carolina | 37093 | 555 | 6 |
358954 | 358954 | 2020-07-22 | Hoke | North Carolina | 37093 | 577 | 7 |
362160 | 362160 | 2020-07-23 | Hoke | North Carolina | 37093 | 582 | 7 |
365366 | 365366 | 2020-07-24 | Hoke | North Carolina | 37093 | 589 | 7 |
368575 | 368575 | 2020-07-25 | Hoke | North Carolina | 37093 | 608 | 7 |
371787 | 371787 | 2020-07-26 | Hoke | North Carolina | 37093 | 616 | 7 |
374999 | 374999 | 2020-07-27 | Hoke | North Carolina | 37093 | 623 | 7 |
378215 | 378215 | 2020-07-28 | Hoke | North Carolina | 37093 | 632 | 7 |
381432 | 381432 | 2020-07-29 | Hoke | North Carolina | 37093 | 645 | 7 |
384650 | 384650 | 2020-07-30 | Hoke | North Carolina | 37093 | 648 | 8 |
387867 | 387867 | 2020-07-31 | Hoke | North Carolina | 37093 | 659 | 8 |
391084 | 391084 | 2020-08-01 | Hoke | North Carolina | 37093 | 666 | 8 |
394300 | 394300 | 2020-08-02 | Hoke | North Carolina | 37093 | 670 | 8 |
397517 | 397517 | 2020-08-03 | Hoke | North Carolina | 37093 | 674 | 8 |
400732 | 400732 | 2020-08-04 | Hoke | North Carolina | 37093 | 681 | 9 |
403950 | 403950 | 2020-08-05 | Hoke | North Carolina | 37093 | 693 | 9 |
407169 | 407169 | 2020-08-06 | Hoke | North Carolina | 37093 | 703 | 9 |
410389 | 410389 | 2020-08-07 | Hoke | North Carolina | 37093 | 710 | 9 |
413609 | 413609 | 2020-08-08 | Hoke | North Carolina | 37093 | 713 | 9 |
416830 | 416830 | 2020-08-09 | Hoke | North Carolina | 37093 | 717 | 9 |
420050 | 420050 | 2020-08-10 | Hoke | North Carolina | 37093 | 720 | 9 |
423273 | 423273 | 2020-08-11 | Hoke | North Carolina | 37093 | 726 | 11 |
426496 | 426496 | 2020-08-12 | Hoke | North Carolina | 37093 | 738 | 11 |
429721 | 429721 | 2020-08-13 | Hoke | North Carolina | 37093 | 761 | 11 |
432947 | 432947 | 2020-08-14 | Hoke | North Carolina | 37093 | 767 | 11 |
436173 | 436173 | 2020-08-15 | Hoke | North Carolina | 37093 | 773 | 11 |
439398 | 439398 | 2020-08-16 | Hoke | North Carolina | 37093 | 780 | 11 |
442625 | 442625 | 2020-08-17 | Hoke | North Carolina | 37093 | 782 | 11 |
445851 | 445851 | 2020-08-18 | Hoke | North Carolina | 37093 | 788 | 12 |
449079 | 449079 | 2020-08-19 | Hoke | North Carolina | 37093 | 791 | 12 |
452307 | 452307 | 2020-08-20 | Hoke | North Carolina | 37093 | 794 | 12 |
455535 | 455535 | 2020-08-21 | Hoke | North Carolina | 37093 | 797 | 12 |
458763 | 458763 | 2020-08-22 | Hoke | North Carolina | 37093 | 809 | 12 |
461991 | 461991 | 2020-08-23 | Hoke | North Carolina | 37093 | 819 | 12 |
465220 | 465220 | 2020-08-24 | Hoke | North Carolina | 37093 | 833 | 12 |
468448 | 468448 | 2020-08-25 | Hoke | North Carolina | 37093 | 839 | 12 |
471680 | 471680 | 2020-08-26 | Hoke | North Carolina | 37093 | 842 | 12 |
474914 | 474914 | 2020-08-27 | Hoke | North Carolina | 37093 | 853 | 12 |
478147 | 478147 | 2020-08-28 | Hoke | North Carolina | 37093 | 858 | 12 |
481380 | 481380 | 2020-08-29 | Hoke | North Carolina | 37093 | 865 | 12 |
484615 | 484615 | 2020-08-30 | Hoke | North Carolina | 37093 | 872 | 12 |
487848 | 487848 | 2020-08-31 | Hoke | North Carolina | 37093 | 874 | 12 |
491081 | 491081 | 2020-09-01 | Hoke | North Carolina | 37093 | 880 | 12 |
494315 | 494315 | 2020-09-02 | Hoke | North Carolina | 37093 | 883 | 13 |
497548 | 497548 | 2020-09-03 | Hoke | North Carolina | 37093 | 887 | 13 |
500782 | 500782 | 2020-09-04 | Hoke | North Carolina | 37093 | 897 | 13 |
504016 | 504016 | 2020-09-05 | Hoke | North Carolina | 37093 | 906 | 13 |
507248 | 507248 | 2020-09-06 | Hoke | North Carolina | 37093 | 911 | 13 |
510481 | 510481 | 2020-09-07 | Hoke | North Carolina | 37093 | 915 | 13 |
513714 | 513714 | 2020-09-08 | Hoke | North Carolina | 37093 | 920 | 13 |
516949 | 516949 | 2020-09-09 | Hoke | North Carolina | 37093 | 926 | 13 |
520185 | 520185 | 2020-09-10 | Hoke | North Carolina | 37093 | 929 | 13 |
523421 | 523421 | 2020-09-11 | Hoke | North Carolina | 37093 | 942 | 13 |
526657 | 526657 | 2020-09-12 | Hoke | North Carolina | 37093 | 963 | 13 |
529894 | 529894 | 2020-09-13 | Hoke | North Carolina | 37093 | 975 | 13 |
533129 | 533129 | 2020-09-14 | Hoke | North Carolina | 37093 | 982 | 13 |
536365 | 536365 | 2020-09-15 | Hoke | North Carolina | 37093 | 997 | 13 |
539602 | 539602 | 2020-09-16 | Hoke | North Carolina | 37093 | 1006 | 16 |
542838 | 542838 | 2020-09-17 | Hoke | North Carolina | 37093 | 1039 | 16 |
546075 | 546075 | 2020-09-18 | Hoke | North Carolina | 37093 | 1052 | 16 |
549314 | 549314 | 2020-09-19 | Hoke | North Carolina | 37093 | 1058 | 16 |
552553 | 552553 | 2020-09-20 | Hoke | North Carolina | 37093 | 1066 | 16 |
555790 | 555790 | 2020-09-21 | Hoke | North Carolina | 37093 | 1068 | 16 |
559027 | 559027 | 2020-09-22 | Hoke | North Carolina | 37093 | 1077 | 17 |
562264 | 562264 | 2020-09-23 | Hoke | North Carolina | 37093 | 1088 | 17 |
565505 | 565505 | 2020-09-24 | Hoke | North Carolina | 37093 | 1106 | 17 |
568746 | 568746 | 2020-09-25 | Hoke | North Carolina | 37093 | 1138 | 17 |
571988 | 571988 | 2020-09-26 | Hoke | North Carolina | 37093 | 1153 | 17 |
575232 | 575232 | 2020-09-27 | Hoke | North Carolina | 37093 | 1167 | 17 |
578473 | 578473 | 2020-09-28 | Hoke | North Carolina | 37093 | 1179 | 17 |
581713 | 581713 | 2020-09-29 | Hoke | North Carolina | 37093 | 1195 | 18 |
584954 | 584954 | 2020-09-30 | Hoke | North Carolina | 37093 | 1217 | 18 |
588194 | 588194 | 2020-10-01 | Hoke | North Carolina | 37093 | 1243 | 18 |
591435 | 591435 | 2020-10-02 | Hoke | North Carolina | 37093 | 1262 | 18 |
594676 | 594676 | 2020-10-03 | Hoke | North Carolina | 37093 | 1279 | 18 |
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);