ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Tyrrell" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536407 | 536407 | 2020-09-15 | Tyrrell | North Carolina | 37177 | 111 | 2 |
533171 | 533171 | 2020-09-14 | Tyrrell | North Carolina | 37177 | 110 | 2 |
529936 | 529936 | 2020-09-13 | Tyrrell | North Carolina | 37177 | 110 | 2 |
526699 | 526699 | 2020-09-12 | Tyrrell | North Carolina | 37177 | 110 | 2 |
523463 | 523463 | 2020-09-11 | Tyrrell | North Carolina | 37177 | 108 | 2 |
520227 | 520227 | 2020-09-10 | Tyrrell | North Carolina | 37177 | 108 | 2 |
516991 | 516991 | 2020-09-09 | Tyrrell | North Carolina | 37177 | 108 | 2 |
513756 | 513756 | 2020-09-08 | Tyrrell | North Carolina | 37177 | 108 | 2 |
510523 | 510523 | 2020-09-07 | Tyrrell | North Carolina | 37177 | 108 | 2 |
507290 | 507290 | 2020-09-06 | Tyrrell | North Carolina | 37177 | 108 | 2 |
504058 | 504058 | 2020-09-05 | Tyrrell | North Carolina | 37177 | 108 | 2 |
500824 | 500824 | 2020-09-04 | Tyrrell | North Carolina | 37177 | 108 | 2 |
497590 | 497590 | 2020-09-03 | Tyrrell | North Carolina | 37177 | 108 | 2 |
494357 | 494357 | 2020-09-02 | Tyrrell | North Carolina | 37177 | 108 | 2 |
491123 | 491123 | 2020-09-01 | Tyrrell | North Carolina | 37177 | 107 | 2 |
487890 | 487890 | 2020-08-31 | Tyrrell | North Carolina | 37177 | 107 | 2 |
484657 | 484657 | 2020-08-30 | Tyrrell | North Carolina | 37177 | 107 | 2 |
481422 | 481422 | 2020-08-29 | Tyrrell | North Carolina | 37177 | 107 | 2 |
478189 | 478189 | 2020-08-28 | Tyrrell | North Carolina | 37177 | 105 | 2 |
474956 | 474956 | 2020-08-27 | Tyrrell | North Carolina | 37177 | 105 | 2 |
471722 | 471722 | 2020-08-26 | Tyrrell | North Carolina | 37177 | 104 | 2 |
468490 | 468490 | 2020-08-25 | Tyrrell | North Carolina | 37177 | 103 | 2 |
465262 | 465262 | 2020-08-24 | Tyrrell | North Carolina | 37177 | 103 | 2 |
462033 | 462033 | 2020-08-23 | Tyrrell | North Carolina | 37177 | 103 | 2 |
458805 | 458805 | 2020-08-22 | Tyrrell | North Carolina | 37177 | 103 | 2 |
455577 | 455577 | 2020-08-21 | Tyrrell | North Carolina | 37177 | 103 | 2 |
452349 | 452349 | 2020-08-20 | Tyrrell | North Carolina | 37177 | 103 | 2 |
449121 | 449121 | 2020-08-19 | Tyrrell | North Carolina | 37177 | 103 | 2 |
445893 | 445893 | 2020-08-18 | Tyrrell | North Carolina | 37177 | 103 | 2 |
442667 | 442667 | 2020-08-17 | Tyrrell | North Carolina | 37177 | 103 | 2 |
439440 | 439440 | 2020-08-16 | Tyrrell | North Carolina | 37177 | 101 | 2 |
436215 | 436215 | 2020-08-15 | Tyrrell | North Carolina | 37177 | 101 | 2 |
432989 | 432989 | 2020-08-14 | Tyrrell | North Carolina | 37177 | 100 | 2 |
429763 | 429763 | 2020-08-13 | Tyrrell | North Carolina | 37177 | 100 | 2 |
426538 | 426538 | 2020-08-12 | Tyrrell | North Carolina | 37177 | 98 | 1 |
423315 | 423315 | 2020-08-11 | Tyrrell | North Carolina | 37177 | 98 | 1 |
420092 | 420092 | 2020-08-10 | Tyrrell | North Carolina | 37177 | 98 | 1 |
416872 | 416872 | 2020-08-09 | Tyrrell | North Carolina | 37177 | 98 | 1 |
413651 | 413651 | 2020-08-08 | Tyrrell | North Carolina | 37177 | 98 | 1 |
410431 | 410431 | 2020-08-07 | Tyrrell | North Carolina | 37177 | 93 | 1 |
407211 | 407211 | 2020-08-06 | Tyrrell | North Carolina | 37177 | 92 | 1 |
403992 | 403992 | 2020-08-05 | Tyrrell | North Carolina | 37177 | 92 | 1 |
400774 | 400774 | 2020-08-04 | Tyrrell | North Carolina | 37177 | 91 | 1 |
397559 | 397559 | 2020-08-03 | Tyrrell | North Carolina | 37177 | 90 | 1 |
394342 | 394342 | 2020-08-02 | Tyrrell | North Carolina | 37177 | 90 | 1 |
391126 | 391126 | 2020-08-01 | Tyrrell | North Carolina | 37177 | 90 | 1 |
387909 | 387909 | 2020-07-31 | Tyrrell | North Carolina | 37177 | 90 | 1 |
384692 | 384692 | 2020-07-30 | Tyrrell | North Carolina | 37177 | 89 | 1 |
381474 | 381474 | 2020-07-29 | Tyrrell | North Carolina | 37177 | 89 | 1 |
378257 | 378257 | 2020-07-28 | Tyrrell | North Carolina | 37177 | 88 | 1 |
375041 | 375041 | 2020-07-27 | Tyrrell | North Carolina | 37177 | 88 | 1 |
371829 | 371829 | 2020-07-26 | Tyrrell | North Carolina | 37177 | 87 | 1 |
368617 | 368617 | 2020-07-25 | Tyrrell | North Carolina | 37177 | 83 | 1 |
365408 | 365408 | 2020-07-24 | Tyrrell | North Carolina | 37177 | 83 | 1 |
362202 | 362202 | 2020-07-23 | Tyrrell | North Carolina | 37177 | 80 | 1 |
358996 | 358996 | 2020-07-22 | Tyrrell | North Carolina | 37177 | 80 | 1 |
355792 | 355792 | 2020-07-21 | Tyrrell | North Carolina | 37177 | 78 | 1 |
352589 | 352589 | 2020-07-20 | Tyrrell | North Carolina | 37177 | 66 | 1 |
349386 | 349386 | 2020-07-19 | Tyrrell | North Carolina | 37177 | 65 | 1 |
346185 | 346185 | 2020-07-18 | Tyrrell | North Carolina | 37177 | 64 | 1 |
342986 | 342986 | 2020-07-17 | Tyrrell | North Carolina | 37177 | 63 | 1 |
339788 | 339788 | 2020-07-16 | Tyrrell | North Carolina | 37177 | 63 | 1 |
336592 | 336592 | 2020-07-15 | Tyrrell | North Carolina | 37177 | 62 | 1 |
333398 | 333398 | 2020-07-14 | Tyrrell | North Carolina | 37177 | 58 | 1 |
330208 | 330208 | 2020-07-13 | Tyrrell | North Carolina | 37177 | 53 | 1 |
327021 | 327021 | 2020-07-12 | Tyrrell | North Carolina | 37177 | 50 | 1 |
323837 | 323837 | 2020-07-11 | Tyrrell | North Carolina | 37177 | 38 | 1 |
320657 | 320657 | 2020-07-10 | Tyrrell | North Carolina | 37177 | 34 | 1 |
317480 | 317480 | 2020-07-09 | Tyrrell | North Carolina | 37177 | 31 | 1 |
314306 | 314306 | 2020-07-08 | Tyrrell | North Carolina | 37177 | 30 | 1 |
311135 | 311135 | 2020-07-07 | Tyrrell | North Carolina | 37177 | 19 | 0 |
307967 | 307967 | 2020-07-06 | Tyrrell | North Carolina | 37177 | 16 | 0 |
304800 | 304800 | 2020-07-05 | Tyrrell | North Carolina | 37177 | 13 | 0 |
301637 | 301637 | 2020-07-04 | Tyrrell | North Carolina | 37177 | 13 | 0 |
298474 | 298474 | 2020-07-03 | Tyrrell | North Carolina | 37177 | 12 | 0 |
295314 | 295314 | 2020-07-02 | Tyrrell | North Carolina | 37177 | 11 | 0 |
292159 | 292159 | 2020-07-01 | Tyrrell | North Carolina | 37177 | 11 | 0 |
289007 | 289007 | 2020-06-30 | Tyrrell | North Carolina | 37177 | 10 | 0 |
285857 | 285857 | 2020-06-29 | Tyrrell | North Carolina | 37177 | 9 | 0 |
282712 | 282712 | 2020-06-28 | Tyrrell | North Carolina | 37177 | 8 | 0 |
279566 | 279566 | 2020-06-27 | Tyrrell | North Carolina | 37177 | 8 | 0 |
276418 | 276418 | 2020-06-26 | Tyrrell | North Carolina | 37177 | 8 | 0 |
273272 | 273272 | 2020-06-25 | Tyrrell | North Carolina | 37177 | 7 | 0 |
270133 | 270133 | 2020-06-24 | Tyrrell | North Carolina | 37177 | 6 | 0 |
266999 | 266999 | 2020-06-23 | Tyrrell | North Carolina | 37177 | 5 | 0 |
263871 | 263871 | 2020-06-22 | Tyrrell | North Carolina | 37177 | 5 | 0 |
260743 | 260743 | 2020-06-21 | Tyrrell | North Carolina | 37177 | 5 | 0 |
257616 | 257616 | 2020-06-20 | Tyrrell | North Carolina | 37177 | 5 | 0 |
254493 | 254493 | 2020-06-19 | Tyrrell | North Carolina | 37177 | 5 | 0 |
251378 | 251378 | 2020-06-18 | Tyrrell | North Carolina | 37177 | 5 | 0 |
248263 | 248263 | 2020-06-17 | Tyrrell | North Carolina | 37177 | 5 | 0 |
245150 | 245150 | 2020-06-16 | Tyrrell | North Carolina | 37177 | 5 | 0 |
242038 | 242038 | 2020-06-15 | Tyrrell | North Carolina | 37177 | 5 | 0 |
238929 | 238929 | 2020-06-14 | Tyrrell | North Carolina | 37177 | 5 | 0 |
235821 | 235821 | 2020-06-13 | Tyrrell | North Carolina | 37177 | 5 | 0 |
232716 | 232716 | 2020-06-12 | Tyrrell | North Carolina | 37177 | 5 | 0 |
229611 | 229611 | 2020-06-11 | Tyrrell | North Carolina | 37177 | 4 | 0 |
226507 | 226507 | 2020-06-10 | Tyrrell | North Carolina | 37177 | 4 | 0 |
223407 | 223407 | 2020-06-09 | Tyrrell | North Carolina | 37177 | 4 | 0 |
220313 | 220313 | 2020-06-08 | Tyrrell | North Carolina | 37177 | 4 | 0 |
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);