ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Franklin" and fips = 37069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636822 | 636822 | 2020-10-16 | Franklin | North Carolina | 37069 | 1362 | 31 |
633576 | 633576 | 2020-10-15 | Franklin | North Carolina | 37069 | 1358 | 31 |
630331 | 630331 | 2020-10-14 | Franklin | North Carolina | 37069 | 1350 | 31 |
627087 | 627087 | 2020-10-13 | Franklin | North Carolina | 37069 | 1345 | 31 |
623845 | 623845 | 2020-10-12 | Franklin | North Carolina | 37069 | 1342 | 31 |
620602 | 620602 | 2020-10-11 | Franklin | North Carolina | 37069 | 1338 | 31 |
617360 | 617360 | 2020-10-10 | Franklin | North Carolina | 37069 | 1336 | 31 |
614118 | 614118 | 2020-10-09 | Franklin | North Carolina | 37069 | 1328 | 31 |
610877 | 610877 | 2020-10-08 | Franklin | North Carolina | 37069 | 1315 | 31 |
607635 | 607635 | 2020-10-07 | Franklin | North Carolina | 37069 | 1295 | 31 |
604392 | 604392 | 2020-10-06 | Franklin | North Carolina | 37069 | 1282 | 31 |
601150 | 601150 | 2020-10-05 | Franklin | North Carolina | 37069 | 1270 | 31 |
597907 | 597907 | 2020-10-04 | Franklin | North Carolina | 37069 | 1264 | 31 |
594664 | 594664 | 2020-10-03 | Franklin | North Carolina | 37069 | 1261 | 31 |
591423 | 591423 | 2020-10-02 | Franklin | North Carolina | 37069 | 1256 | 31 |
588182 | 588182 | 2020-10-01 | Franklin | North Carolina | 37069 | 1243 | 31 |
584942 | 584942 | 2020-09-30 | Franklin | North Carolina | 37069 | 1225 | 31 |
581701 | 581701 | 2020-09-29 | Franklin | North Carolina | 37069 | 1212 | 31 |
578461 | 578461 | 2020-09-28 | Franklin | North Carolina | 37069 | 1212 | 31 |
575220 | 575220 | 2020-09-27 | Franklin | North Carolina | 37069 | 1210 | 31 |
571976 | 571976 | 2020-09-26 | Franklin | North Carolina | 37069 | 1207 | 31 |
568734 | 568734 | 2020-09-25 | Franklin | North Carolina | 37069 | 1207 | 31 |
565493 | 565493 | 2020-09-24 | Franklin | North Carolina | 37069 | 1202 | 31 |
562252 | 562252 | 2020-09-23 | Franklin | North Carolina | 37069 | 1199 | 31 |
559015 | 559015 | 2020-09-22 | Franklin | North Carolina | 37069 | 1191 | 31 |
555778 | 555778 | 2020-09-21 | Franklin | North Carolina | 37069 | 1189 | 32 |
552541 | 552541 | 2020-09-20 | Franklin | North Carolina | 37069 | 1184 | 32 |
549302 | 549302 | 2020-09-19 | Franklin | North Carolina | 37069 | 1177 | 32 |
546063 | 546063 | 2020-09-18 | Franklin | North Carolina | 37069 | 1172 | 31 |
542826 | 542826 | 2020-09-17 | Franklin | North Carolina | 37069 | 1167 | 31 |
539590 | 539590 | 2020-09-16 | Franklin | North Carolina | 37069 | 1158 | 31 |
536353 | 536353 | 2020-09-15 | Franklin | North Carolina | 37069 | 1156 | 30 |
533117 | 533117 | 2020-09-14 | Franklin | North Carolina | 37069 | 1151 | 30 |
529882 | 529882 | 2020-09-13 | Franklin | North Carolina | 37069 | 1143 | 30 |
526645 | 526645 | 2020-09-12 | Franklin | North Carolina | 37069 | 1137 | 30 |
523409 | 523409 | 2020-09-11 | Franklin | North Carolina | 37069 | 1133 | 30 |
520173 | 520173 | 2020-09-10 | Franklin | North Carolina | 37069 | 1128 | 30 |
516937 | 516937 | 2020-09-09 | Franklin | North Carolina | 37069 | 1123 | 30 |
513702 | 513702 | 2020-09-08 | Franklin | North Carolina | 37069 | 1120 | 30 |
510469 | 510469 | 2020-09-07 | Franklin | North Carolina | 37069 | 1116 | 30 |
507236 | 507236 | 2020-09-06 | Franklin | North Carolina | 37069 | 1109 | 30 |
504004 | 504004 | 2020-09-05 | Franklin | North Carolina | 37069 | 1105 | 30 |
500770 | 500770 | 2020-09-04 | Franklin | North Carolina | 37069 | 1097 | 29 |
497536 | 497536 | 2020-09-03 | Franklin | North Carolina | 37069 | 1084 | 29 |
494303 | 494303 | 2020-09-02 | Franklin | North Carolina | 37069 | 1078 | 29 |
491069 | 491069 | 2020-09-01 | Franklin | North Carolina | 37069 | 1063 | 29 |
487836 | 487836 | 2020-08-31 | Franklin | North Carolina | 37069 | 1056 | 29 |
484603 | 484603 | 2020-08-30 | Franklin | North Carolina | 37069 | 1050 | 29 |
481368 | 481368 | 2020-08-29 | Franklin | North Carolina | 37069 | 1041 | 29 |
478135 | 478135 | 2020-08-28 | Franklin | North Carolina | 37069 | 1026 | 29 |
474902 | 474902 | 2020-08-27 | Franklin | North Carolina | 37069 | 1008 | 28 |
471668 | 471668 | 2020-08-26 | Franklin | North Carolina | 37069 | 996 | 28 |
468436 | 468436 | 2020-08-25 | Franklin | North Carolina | 37069 | 984 | 28 |
465208 | 465208 | 2020-08-24 | Franklin | North Carolina | 37069 | 976 | 28 |
461979 | 461979 | 2020-08-23 | Franklin | North Carolina | 37069 | 973 | 28 |
458751 | 458751 | 2020-08-22 | Franklin | North Carolina | 37069 | 965 | 28 |
455523 | 455523 | 2020-08-21 | Franklin | North Carolina | 37069 | 962 | 28 |
452295 | 452295 | 2020-08-20 | Franklin | North Carolina | 37069 | 956 | 28 |
449067 | 449067 | 2020-08-19 | Franklin | North Carolina | 37069 | 942 | 28 |
445839 | 445839 | 2020-08-18 | Franklin | North Carolina | 37069 | 934 | 28 |
442613 | 442613 | 2020-08-17 | Franklin | North Carolina | 37069 | 932 | 26 |
439386 | 439386 | 2020-08-16 | Franklin | North Carolina | 37069 | 929 | 26 |
436161 | 436161 | 2020-08-15 | Franklin | North Carolina | 37069 | 921 | 26 |
432935 | 432935 | 2020-08-14 | Franklin | North Carolina | 37069 | 915 | 26 |
429709 | 429709 | 2020-08-13 | Franklin | North Carolina | 37069 | 905 | 26 |
426484 | 426484 | 2020-08-12 | Franklin | North Carolina | 37069 | 891 | 26 |
423261 | 423261 | 2020-08-11 | Franklin | North Carolina | 37069 | 872 | 26 |
420038 | 420038 | 2020-08-10 | Franklin | North Carolina | 37069 | 871 | 26 |
416818 | 416818 | 2020-08-09 | Franklin | North Carolina | 37069 | 866 | 26 |
413597 | 413597 | 2020-08-08 | Franklin | North Carolina | 37069 | 860 | 26 |
410377 | 410377 | 2020-08-07 | Franklin | North Carolina | 37069 | 846 | 25 |
407157 | 407157 | 2020-08-06 | Franklin | North Carolina | 37069 | 828 | 25 |
403938 | 403938 | 2020-08-05 | Franklin | North Carolina | 37069 | 811 | 25 |
400720 | 400720 | 2020-08-04 | Franklin | North Carolina | 37069 | 805 | 25 |
397505 | 397505 | 2020-08-03 | Franklin | North Carolina | 37069 | 797 | 25 |
394288 | 394288 | 2020-08-02 | Franklin | North Carolina | 37069 | 783 | 25 |
391072 | 391072 | 2020-08-01 | Franklin | North Carolina | 37069 | 774 | 25 |
387855 | 387855 | 2020-07-31 | Franklin | North Carolina | 37069 | 762 | 25 |
384638 | 384638 | 2020-07-30 | Franklin | North Carolina | 37069 | 747 | 25 |
381420 | 381420 | 2020-07-29 | Franklin | North Carolina | 37069 | 731 | 25 |
378203 | 378203 | 2020-07-28 | Franklin | North Carolina | 37069 | 723 | 25 |
374987 | 374987 | 2020-07-27 | Franklin | North Carolina | 37069 | 705 | 25 |
371775 | 371775 | 2020-07-26 | Franklin | North Carolina | 37069 | 693 | 25 |
368563 | 368563 | 2020-07-25 | Franklin | North Carolina | 37069 | 682 | 25 |
365354 | 365354 | 2020-07-24 | Franklin | North Carolina | 37069 | 667 | 24 |
362148 | 362148 | 2020-07-23 | Franklin | North Carolina | 37069 | 648 | 23 |
358942 | 358942 | 2020-07-22 | Franklin | North Carolina | 37069 | 641 | 23 |
355738 | 355738 | 2020-07-21 | Franklin | North Carolina | 37069 | 611 | 23 |
352535 | 352535 | 2020-07-20 | Franklin | North Carolina | 37069 | 598 | 23 |
349332 | 349332 | 2020-07-19 | Franklin | North Carolina | 37069 | 591 | 23 |
346131 | 346131 | 2020-07-18 | Franklin | North Carolina | 37069 | 578 | 23 |
342932 | 342932 | 2020-07-17 | Franklin | North Carolina | 37069 | 560 | 23 |
339734 | 339734 | 2020-07-16 | Franklin | North Carolina | 37069 | 542 | 22 |
336538 | 336538 | 2020-07-15 | Franklin | North Carolina | 37069 | 533 | 22 |
333344 | 333344 | 2020-07-14 | Franklin | North Carolina | 37069 | 518 | 22 |
330154 | 330154 | 2020-07-13 | Franklin | North Carolina | 37069 | 504 | 21 |
326967 | 326967 | 2020-07-12 | Franklin | North Carolina | 37069 | 480 | 21 |
323783 | 323783 | 2020-07-11 | Franklin | North Carolina | 37069 | 478 | 21 |
320603 | 320603 | 2020-07-10 | Franklin | North Carolina | 37069 | 441 | 21 |
317426 | 317426 | 2020-07-09 | Franklin | North Carolina | 37069 | 435 | 21 |
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);