ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 37063 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 |
---|---|---|---|---|---|---|---|
533114 | 533114 | 2020-09-14 | Durham | North Carolina | 37063 | 7346 | 88 |
529879 | 529879 | 2020-09-13 | Durham | North Carolina | 37063 | 7311 | 88 |
526642 | 526642 | 2020-09-12 | Durham | North Carolina | 37063 | 7290 | 88 |
523406 | 523406 | 2020-09-11 | Durham | North Carolina | 37063 | 7267 | 87 |
520170 | 520170 | 2020-09-10 | Durham | North Carolina | 37063 | 7227 | 86 |
516934 | 516934 | 2020-09-09 | Durham | North Carolina | 37063 | 7194 | 86 |
513699 | 513699 | 2020-09-08 | Durham | North Carolina | 37063 | 7171 | 86 |
510466 | 510466 | 2020-09-07 | Durham | North Carolina | 37063 | 7129 | 86 |
507233 | 507233 | 2020-09-06 | Durham | North Carolina | 37063 | 7120 | 86 |
504001 | 504001 | 2020-09-05 | Durham | North Carolina | 37063 | 7120 | 86 |
500767 | 500767 | 2020-09-04 | Durham | North Carolina | 37063 | 7084 | 86 |
497533 | 497533 | 2020-09-03 | Durham | North Carolina | 37063 | 7046 | 84 |
494300 | 494300 | 2020-09-02 | Durham | North Carolina | 37063 | 7004 | 84 |
491066 | 491066 | 2020-09-01 | Durham | North Carolina | 37063 | 6978 | 84 |
487833 | 487833 | 2020-08-31 | Durham | North Carolina | 37063 | 6951 | 84 |
484600 | 484600 | 2020-08-30 | Durham | North Carolina | 37063 | 6914 | 84 |
481365 | 481365 | 2020-08-29 | Durham | North Carolina | 37063 | 6889 | 84 |
478132 | 478132 | 2020-08-28 | Durham | North Carolina | 37063 | 6857 | 83 |
474899 | 474899 | 2020-08-27 | Durham | North Carolina | 37063 | 6798 | 83 |
471665 | 471665 | 2020-08-26 | Durham | North Carolina | 37063 | 6759 | 82 |
468433 | 468433 | 2020-08-25 | Durham | North Carolina | 37063 | 6671 | 82 |
465205 | 465205 | 2020-08-24 | Durham | North Carolina | 37063 | 6648 | 81 |
461976 | 461976 | 2020-08-23 | Durham | North Carolina | 37063 | 6648 | 81 |
458748 | 458748 | 2020-08-22 | Durham | North Carolina | 37063 | 6614 | 81 |
455520 | 455520 | 2020-08-21 | Durham | North Carolina | 37063 | 6582 | 81 |
452292 | 452292 | 2020-08-20 | Durham | North Carolina | 37063 | 6557 | 81 |
449064 | 449064 | 2020-08-19 | Durham | North Carolina | 37063 | 6512 | 81 |
445836 | 445836 | 2020-08-18 | Durham | North Carolina | 37063 | 6478 | 81 |
442610 | 442610 | 2020-08-17 | Durham | North Carolina | 37063 | 6464 | 81 |
439383 | 439383 | 2020-08-16 | Durham | North Carolina | 37063 | 6427 | 80 |
436158 | 436158 | 2020-08-15 | Durham | North Carolina | 37063 | 6390 | 80 |
432932 | 432932 | 2020-08-14 | Durham | North Carolina | 37063 | 6364 | 80 |
429706 | 429706 | 2020-08-13 | Durham | North Carolina | 37063 | 6319 | 80 |
426481 | 426481 | 2020-08-12 | Durham | North Carolina | 37063 | 6273 | 80 |
423258 | 423258 | 2020-08-11 | Durham | North Carolina | 37063 | 6221 | 80 |
420035 | 420035 | 2020-08-10 | Durham | North Carolina | 37063 | 6218 | 80 |
416815 | 416815 | 2020-08-09 | Durham | North Carolina | 37063 | 6179 | 80 |
413594 | 413594 | 2020-08-08 | Durham | North Carolina | 37063 | 6114 | 80 |
410374 | 410374 | 2020-08-07 | Durham | North Carolina | 37063 | 6080 | 79 |
407154 | 407154 | 2020-08-06 | Durham | North Carolina | 37063 | 6041 | 79 |
403935 | 403935 | 2020-08-05 | Durham | North Carolina | 37063 | 5989 | 79 |
400717 | 400717 | 2020-08-04 | Durham | North Carolina | 37063 | 5946 | 79 |
397502 | 397502 | 2020-08-03 | Durham | North Carolina | 37063 | 5917 | 79 |
394285 | 394285 | 2020-08-02 | Durham | North Carolina | 37063 | 5889 | 79 |
391069 | 391069 | 2020-08-01 | Durham | North Carolina | 37063 | 5845 | 78 |
387852 | 387852 | 2020-07-31 | Durham | North Carolina | 37063 | 5789 | 77 |
384635 | 384635 | 2020-07-30 | Durham | North Carolina | 37063 | 5719 | 77 |
381417 | 381417 | 2020-07-29 | Durham | North Carolina | 37063 | 5659 | 77 |
378200 | 378200 | 2020-07-28 | Durham | North Carolina | 37063 | 5567 | 76 |
374984 | 374984 | 2020-07-27 | Durham | North Carolina | 37063 | 5566 | 76 |
371772 | 371772 | 2020-07-26 | Durham | North Carolina | 37063 | 5514 | 76 |
368560 | 368560 | 2020-07-25 | Durham | North Carolina | 37063 | 5469 | 76 |
365351 | 365351 | 2020-07-24 | Durham | North Carolina | 37063 | 5413 | 76 |
362145 | 362145 | 2020-07-23 | Durham | North Carolina | 37063 | 5360 | 76 |
358939 | 358939 | 2020-07-22 | Durham | North Carolina | 37063 | 5269 | 74 |
355735 | 355735 | 2020-07-21 | Durham | North Carolina | 37063 | 5219 | 73 |
352532 | 352532 | 2020-07-20 | Durham | North Carolina | 37063 | 5133 | 73 |
349329 | 349329 | 2020-07-19 | Durham | North Carolina | 37063 | 5072 | 73 |
346128 | 346128 | 2020-07-18 | Durham | North Carolina | 37063 | 5011 | 72 |
342929 | 342929 | 2020-07-17 | Durham | North Carolina | 37063 | 4944 | 72 |
339731 | 339731 | 2020-07-16 | Durham | North Carolina | 37063 | 4880 | 72 |
336535 | 336535 | 2020-07-15 | Durham | North Carolina | 37063 | 4788 | 72 |
333341 | 333341 | 2020-07-14 | Durham | North Carolina | 37063 | 4723 | 72 |
330151 | 330151 | 2020-07-13 | Durham | North Carolina | 37063 | 4652 | 72 |
326964 | 326964 | 2020-07-12 | Durham | North Carolina | 37063 | 4563 | 70 |
323780 | 323780 | 2020-07-11 | Durham | North Carolina | 37063 | 4494 | 68 |
320600 | 320600 | 2020-07-10 | Durham | North Carolina | 37063 | 4421 | 68 |
317423 | 317423 | 2020-07-09 | Durham | North Carolina | 37063 | 4277 | 67 |
314249 | 314249 | 2020-07-08 | Durham | North Carolina | 37063 | 4277 | 67 |
311078 | 311078 | 2020-07-07 | Durham | North Carolina | 37063 | 4208 | 67 |
307910 | 307910 | 2020-07-06 | Durham | North Carolina | 37063 | 4176 | 67 |
304743 | 304743 | 2020-07-05 | Durham | North Carolina | 37063 | 4113 | 67 |
301580 | 301580 | 2020-07-04 | Durham | North Carolina | 37063 | 4064 | 67 |
298417 | 298417 | 2020-07-03 | Durham | North Carolina | 37063 | 4015 | 66 |
295257 | 295257 | 2020-07-02 | Durham | North Carolina | 37063 | 3976 | 65 |
292102 | 292102 | 2020-07-01 | Durham | North Carolina | 37063 | 3876 | 65 |
288950 | 288950 | 2020-06-30 | Durham | North Carolina | 37063 | 3807 | 63 |
285800 | 285800 | 2020-06-29 | Durham | North Carolina | 37063 | 3679 | 63 |
282655 | 282655 | 2020-06-28 | Durham | North Carolina | 37063 | 3571 | 63 |
279509 | 279509 | 2020-06-27 | Durham | North Carolina | 37063 | 3532 | 63 |
276361 | 276361 | 2020-06-26 | Durham | North Carolina | 37063 | 3532 | 63 |
273215 | 273215 | 2020-06-25 | Durham | North Carolina | 37063 | 3479 | 63 |
270076 | 270076 | 2020-06-24 | Durham | North Carolina | 37063 | 3402 | 62 |
266942 | 266942 | 2020-06-23 | Durham | North Carolina | 37063 | 3340 | 62 |
263814 | 263814 | 2020-06-22 | Durham | North Carolina | 37063 | 3212 | 62 |
260686 | 260686 | 2020-06-21 | Durham | North Carolina | 37063 | 3196 | 62 |
257559 | 257559 | 2020-06-20 | Durham | North Carolina | 37063 | 3151 | 62 |
254436 | 254436 | 2020-06-19 | Durham | North Carolina | 37063 | 3063 | 62 |
251321 | 251321 | 2020-06-18 | Durham | North Carolina | 37063 | 3004 | 62 |
248206 | 248206 | 2020-06-17 | Durham | North Carolina | 37063 | 2945 | 59 |
245093 | 245093 | 2020-06-16 | Durham | North Carolina | 37063 | 2800 | 58 |
241981 | 241981 | 2020-06-15 | Durham | North Carolina | 37063 | 2800 | 58 |
238872 | 238872 | 2020-06-14 | Durham | North Carolina | 37063 | 2695 | 58 |
235764 | 235764 | 2020-06-13 | Durham | North Carolina | 37063 | 2647 | 58 |
232659 | 232659 | 2020-06-12 | Durham | North Carolina | 37063 | 2563 | 57 |
229554 | 229554 | 2020-06-11 | Durham | North Carolina | 37063 | 2473 | 57 |
226450 | 226450 | 2020-06-10 | Durham | North Carolina | 37063 | 2307 | 53 |
223350 | 223350 | 2020-06-09 | Durham | North Carolina | 37063 | 2227 | 51 |
220256 | 220256 | 2020-06-08 | Durham | North Carolina | 37063 | 2180 | 49 |
217164 | 217164 | 2020-06-07 | Durham | North Carolina | 37063 | 2114 | 49 |
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);