ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Durham" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
270076 | 270076 | 2020-06-24 | Durham | North Carolina | 37063 | 3402 | 62 |
273215 | 273215 | 2020-06-25 | Durham | North Carolina | 37063 | 3479 | 63 |
276361 | 276361 | 2020-06-26 | Durham | North Carolina | 37063 | 3532 | 63 |
279509 | 279509 | 2020-06-27 | Durham | North Carolina | 37063 | 3532 | 63 |
282655 | 282655 | 2020-06-28 | Durham | North Carolina | 37063 | 3571 | 63 |
285800 | 285800 | 2020-06-29 | Durham | North Carolina | 37063 | 3679 | 63 |
288950 | 288950 | 2020-06-30 | Durham | North Carolina | 37063 | 3807 | 63 |
292102 | 292102 | 2020-07-01 | Durham | North Carolina | 37063 | 3876 | 65 |
295257 | 295257 | 2020-07-02 | Durham | North Carolina | 37063 | 3976 | 65 |
298417 | 298417 | 2020-07-03 | Durham | North Carolina | 37063 | 4015 | 66 |
301580 | 301580 | 2020-07-04 | Durham | North Carolina | 37063 | 4064 | 67 |
304743 | 304743 | 2020-07-05 | Durham | North Carolina | 37063 | 4113 | 67 |
307910 | 307910 | 2020-07-06 | Durham | North Carolina | 37063 | 4176 | 67 |
311078 | 311078 | 2020-07-07 | Durham | North Carolina | 37063 | 4208 | 67 |
314249 | 314249 | 2020-07-08 | Durham | North Carolina | 37063 | 4277 | 67 |
317423 | 317423 | 2020-07-09 | Durham | North Carolina | 37063 | 4277 | 67 |
320600 | 320600 | 2020-07-10 | Durham | North Carolina | 37063 | 4421 | 68 |
323780 | 323780 | 2020-07-11 | Durham | North Carolina | 37063 | 4494 | 68 |
326964 | 326964 | 2020-07-12 | Durham | North Carolina | 37063 | 4563 | 70 |
330151 | 330151 | 2020-07-13 | Durham | North Carolina | 37063 | 4652 | 72 |
333341 | 333341 | 2020-07-14 | Durham | North Carolina | 37063 | 4723 | 72 |
336535 | 336535 | 2020-07-15 | Durham | North Carolina | 37063 | 4788 | 72 |
339731 | 339731 | 2020-07-16 | Durham | North Carolina | 37063 | 4880 | 72 |
342929 | 342929 | 2020-07-17 | Durham | North Carolina | 37063 | 4944 | 72 |
346128 | 346128 | 2020-07-18 | Durham | North Carolina | 37063 | 5011 | 72 |
349329 | 349329 | 2020-07-19 | Durham | North Carolina | 37063 | 5072 | 73 |
352532 | 352532 | 2020-07-20 | Durham | North Carolina | 37063 | 5133 | 73 |
355735 | 355735 | 2020-07-21 | Durham | North Carolina | 37063 | 5219 | 73 |
358939 | 358939 | 2020-07-22 | Durham | North Carolina | 37063 | 5269 | 74 |
362145 | 362145 | 2020-07-23 | Durham | North Carolina | 37063 | 5360 | 76 |
365351 | 365351 | 2020-07-24 | Durham | North Carolina | 37063 | 5413 | 76 |
368560 | 368560 | 2020-07-25 | Durham | North Carolina | 37063 | 5469 | 76 |
371772 | 371772 | 2020-07-26 | Durham | North Carolina | 37063 | 5514 | 76 |
374984 | 374984 | 2020-07-27 | Durham | North Carolina | 37063 | 5566 | 76 |
378200 | 378200 | 2020-07-28 | Durham | North Carolina | 37063 | 5567 | 76 |
381417 | 381417 | 2020-07-29 | Durham | North Carolina | 37063 | 5659 | 77 |
384635 | 384635 | 2020-07-30 | Durham | North Carolina | 37063 | 5719 | 77 |
387852 | 387852 | 2020-07-31 | Durham | North Carolina | 37063 | 5789 | 77 |
391069 | 391069 | 2020-08-01 | Durham | North Carolina | 37063 | 5845 | 78 |
394285 | 394285 | 2020-08-02 | Durham | North Carolina | 37063 | 5889 | 79 |
397502 | 397502 | 2020-08-03 | Durham | North Carolina | 37063 | 5917 | 79 |
400717 | 400717 | 2020-08-04 | Durham | North Carolina | 37063 | 5946 | 79 |
403935 | 403935 | 2020-08-05 | Durham | North Carolina | 37063 | 5989 | 79 |
407154 | 407154 | 2020-08-06 | Durham | North Carolina | 37063 | 6041 | 79 |
410374 | 410374 | 2020-08-07 | Durham | North Carolina | 37063 | 6080 | 79 |
413594 | 413594 | 2020-08-08 | Durham | North Carolina | 37063 | 6114 | 80 |
416815 | 416815 | 2020-08-09 | Durham | North Carolina | 37063 | 6179 | 80 |
420035 | 420035 | 2020-08-10 | Durham | North Carolina | 37063 | 6218 | 80 |
423258 | 423258 | 2020-08-11 | Durham | North Carolina | 37063 | 6221 | 80 |
426481 | 426481 | 2020-08-12 | Durham | North Carolina | 37063 | 6273 | 80 |
429706 | 429706 | 2020-08-13 | Durham | North Carolina | 37063 | 6319 | 80 |
432932 | 432932 | 2020-08-14 | Durham | North Carolina | 37063 | 6364 | 80 |
436158 | 436158 | 2020-08-15 | Durham | North Carolina | 37063 | 6390 | 80 |
439383 | 439383 | 2020-08-16 | Durham | North Carolina | 37063 | 6427 | 80 |
442610 | 442610 | 2020-08-17 | Durham | North Carolina | 37063 | 6464 | 81 |
445836 | 445836 | 2020-08-18 | Durham | North Carolina | 37063 | 6478 | 81 |
449064 | 449064 | 2020-08-19 | Durham | North Carolina | 37063 | 6512 | 81 |
452292 | 452292 | 2020-08-20 | Durham | North Carolina | 37063 | 6557 | 81 |
455520 | 455520 | 2020-08-21 | Durham | North Carolina | 37063 | 6582 | 81 |
458748 | 458748 | 2020-08-22 | Durham | North Carolina | 37063 | 6614 | 81 |
461976 | 461976 | 2020-08-23 | Durham | North Carolina | 37063 | 6648 | 81 |
465205 | 465205 | 2020-08-24 | Durham | North Carolina | 37063 | 6648 | 81 |
468433 | 468433 | 2020-08-25 | Durham | North Carolina | 37063 | 6671 | 82 |
471665 | 471665 | 2020-08-26 | Durham | North Carolina | 37063 | 6759 | 82 |
474899 | 474899 | 2020-08-27 | Durham | North Carolina | 37063 | 6798 | 83 |
478132 | 478132 | 2020-08-28 | Durham | North Carolina | 37063 | 6857 | 83 |
481365 | 481365 | 2020-08-29 | Durham | North Carolina | 37063 | 6889 | 84 |
484600 | 484600 | 2020-08-30 | Durham | North Carolina | 37063 | 6914 | 84 |
487833 | 487833 | 2020-08-31 | Durham | North Carolina | 37063 | 6951 | 84 |
491066 | 491066 | 2020-09-01 | Durham | North Carolina | 37063 | 6978 | 84 |
494300 | 494300 | 2020-09-02 | Durham | North Carolina | 37063 | 7004 | 84 |
497533 | 497533 | 2020-09-03 | Durham | North Carolina | 37063 | 7046 | 84 |
500767 | 500767 | 2020-09-04 | Durham | North Carolina | 37063 | 7084 | 86 |
504001 | 504001 | 2020-09-05 | Durham | North Carolina | 37063 | 7120 | 86 |
507233 | 507233 | 2020-09-06 | Durham | North Carolina | 37063 | 7120 | 86 |
510466 | 510466 | 2020-09-07 | Durham | North Carolina | 37063 | 7129 | 86 |
513699 | 513699 | 2020-09-08 | Durham | North Carolina | 37063 | 7171 | 86 |
516934 | 516934 | 2020-09-09 | Durham | North Carolina | 37063 | 7194 | 86 |
520170 | 520170 | 2020-09-10 | Durham | North Carolina | 37063 | 7227 | 86 |
523406 | 523406 | 2020-09-11 | Durham | North Carolina | 37063 | 7267 | 87 |
526642 | 526642 | 2020-09-12 | Durham | North Carolina | 37063 | 7290 | 88 |
529879 | 529879 | 2020-09-13 | Durham | North Carolina | 37063 | 7311 | 88 |
533114 | 533114 | 2020-09-14 | Durham | North Carolina | 37063 | 7346 | 88 |
536350 | 536350 | 2020-09-15 | Durham | North Carolina | 37063 | 7356 | 88 |
539587 | 539587 | 2020-09-16 | Durham | North Carolina | 37063 | 7389 | 88 |
542823 | 542823 | 2020-09-17 | Durham | North Carolina | 37063 | 7431 | 90 |
546060 | 546060 | 2020-09-18 | Durham | North Carolina | 37063 | 7467 | 90 |
549299 | 549299 | 2020-09-19 | Durham | North Carolina | 37063 | 7502 | 91 |
552538 | 552538 | 2020-09-20 | Durham | North Carolina | 37063 | 7506 | 91 |
555775 | 555775 | 2020-09-21 | Durham | North Carolina | 37063 | 7553 | 92 |
559012 | 559012 | 2020-09-22 | Durham | North Carolina | 37063 | 7580 | 93 |
562249 | 562249 | 2020-09-23 | Durham | North Carolina | 37063 | 7611 | 93 |
565490 | 565490 | 2020-09-24 | Durham | North Carolina | 37063 | 7657 | 94 |
568731 | 568731 | 2020-09-25 | Durham | North Carolina | 37063 | 7682 | 95 |
571973 | 571973 | 2020-09-26 | Durham | North Carolina | 37063 | 7712 | 95 |
575217 | 575217 | 2020-09-27 | Durham | North Carolina | 37063 | 7741 | 95 |
578458 | 578458 | 2020-09-28 | Durham | North Carolina | 37063 | 7773 | 96 |
581698 | 581698 | 2020-09-29 | Durham | North Carolina | 37063 | 7794 | 96 |
584939 | 584939 | 2020-09-30 | Durham | North Carolina | 37063 | 7843 | 96 |
588179 | 588179 | 2020-10-01 | Durham | North Carolina | 37063 | 7883 | 97 |
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);