ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Mecklenburg" 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 |
---|---|---|---|---|---|---|---|
922400 | 922400 | 2021-01-12 | Mecklenburg | North Carolina | 37119 | 73083 | 656 |
919155 | 919155 | 2021-01-11 | Mecklenburg | North Carolina | 37119 | 72604 | 652 |
915910 | 915910 | 2021-01-10 | Mecklenburg | North Carolina | 37119 | 71775 | 640 |
912665 | 912665 | 2021-01-09 | Mecklenburg | North Carolina | 37119 | 70979 | 622 |
909420 | 909420 | 2021-01-08 | Mecklenburg | North Carolina | 37119 | 69748 | 622 |
906175 | 906175 | 2021-01-07 | Mecklenburg | North Carolina | 37119 | 68535 | 606 |
902929 | 902929 | 2021-01-06 | Mecklenburg | North Carolina | 37119 | 67623 | 606 |
899684 | 899684 | 2021-01-05 | Mecklenburg | North Carolina | 37119 | 66907 | 601 |
896439 | 896439 | 2021-01-04 | Mecklenburg | North Carolina | 37119 | 66125 | 588 |
893193 | 893193 | 2021-01-03 | Mecklenburg | North Carolina | 37119 | 65497 | 583 |
889947 | 889947 | 2021-01-02 | Mecklenburg | North Carolina | 37119 | 64911 | 573 |
886700 | 886700 | 2021-01-01 | Mecklenburg | North Carolina | 37119 | 64167 | 573 |
883455 | 883455 | 2020-12-31 | Mecklenburg | North Carolina | 37119 | 63088 | 566 |
880210 | 880210 | 2020-12-30 | Mecklenburg | North Carolina | 37119 | 62240 | 561 |
876965 | 876965 | 2020-12-29 | Mecklenburg | North Carolina | 37119 | 61526 | 557 |
873720 | 873720 | 2020-12-28 | Mecklenburg | North Carolina | 37119 | 60930 | 552 |
870475 | 870475 | 2020-12-27 | Mecklenburg | North Carolina | 37119 | 60337 | 552 |
867230 | 867230 | 2020-12-26 | Mecklenburg | North Carolina | 37119 | 59704 | 547 |
863985 | 863985 | 2020-12-25 | Mecklenburg | North Carolina | 37119 | 58281 | 531 |
860740 | 860740 | 2020-12-24 | Mecklenburg | North Carolina | 37119 | 58281 | 531 |
857495 | 857495 | 2020-12-23 | Mecklenburg | North Carolina | 37119 | 58281 | 531 |
854250 | 854250 | 2020-12-22 | Mecklenburg | North Carolina | 37119 | 57458 | 519 |
851005 | 851005 | 2020-12-21 | Mecklenburg | North Carolina | 37119 | 56824 | 518 |
847760 | 847760 | 2020-12-20 | Mecklenburg | North Carolina | 37119 | 56044 | 514 |
844515 | 844515 | 2020-12-19 | Mecklenburg | North Carolina | 37119 | 55175 | 513 |
841269 | 841269 | 2020-12-18 | Mecklenburg | North Carolina | 37119 | 54667 | 513 |
838024 | 838024 | 2020-12-17 | Mecklenburg | North Carolina | 37119 | 53979 | 508 |
834778 | 834778 | 2020-12-16 | Mecklenburg | North Carolina | 37119 | 53194 | 502 |
831532 | 831532 | 2020-12-15 | Mecklenburg | North Carolina | 37119 | 52624 | 494 |
828285 | 828285 | 2020-12-14 | Mecklenburg | North Carolina | 37119 | 51896 | 491 |
825039 | 825039 | 2020-12-13 | Mecklenburg | North Carolina | 37119 | 51290 | 485 |
821792 | 821792 | 2020-12-12 | Mecklenburg | North Carolina | 37119 | 50535 | 485 |
818546 | 818546 | 2020-12-11 | Mecklenburg | North Carolina | 37119 | 49955 | 485 |
815300 | 815300 | 2020-12-10 | Mecklenburg | North Carolina | 37119 | 49234 | 484 |
812055 | 812055 | 2020-12-09 | Mecklenburg | North Carolina | 37119 | 48673 | 481 |
808810 | 808810 | 2020-12-08 | Mecklenburg | North Carolina | 37119 | 48033 | 480 |
805565 | 805565 | 2020-12-07 | Mecklenburg | North Carolina | 37119 | 47547 | 477 |
802320 | 802320 | 2020-12-06 | Mecklenburg | North Carolina | 37119 | 46983 | 477 |
799075 | 799075 | 2020-12-05 | Mecklenburg | North Carolina | 37119 | 46199 | 469 |
795830 | 795830 | 2020-12-04 | Mecklenburg | North Carolina | 37119 | 45627 | 469 |
792585 | 792585 | 2020-12-03 | Mecklenburg | North Carolina | 37119 | 44984 | 468 |
789340 | 789340 | 2020-12-02 | Mecklenburg | North Carolina | 37119 | 44428 | 464 |
786095 | 786095 | 2020-12-01 | Mecklenburg | North Carolina | 37119 | 43983 | 456 |
782851 | 782851 | 2020-11-30 | Mecklenburg | North Carolina | 37119 | 43689 | 456 |
779605 | 779605 | 2020-11-29 | Mecklenburg | North Carolina | 37119 | 43380 | 454 |
776360 | 776360 | 2020-11-28 | Mecklenburg | North Carolina | 37119 | 42933 | 445 |
773115 | 773115 | 2020-11-27 | Mecklenburg | North Carolina | 37119 | 42495 | 443 |
769870 | 769870 | 2020-11-26 | Mecklenburg | North Carolina | 37119 | 42052 | 443 |
766624 | 766624 | 2020-11-25 | Mecklenburg | North Carolina | 37119 | 42052 | 443 |
763379 | 763379 | 2020-11-24 | Mecklenburg | North Carolina | 37119 | 41651 | 441 |
760134 | 760134 | 2020-11-23 | Mecklenburg | North Carolina | 37119 | 41206 | 436 |
756888 | 756888 | 2020-11-22 | Mecklenburg | North Carolina | 37119 | 40754 | 431 |
753641 | 753641 | 2020-11-21 | Mecklenburg | North Carolina | 37119 | 40566 | 431 |
750395 | 750395 | 2020-11-20 | Mecklenburg | North Carolina | 37119 | 40109 | 431 |
747149 | 747149 | 2020-11-19 | Mecklenburg | North Carolina | 37119 | 39796 | 430 |
743903 | 743903 | 2020-11-18 | Mecklenburg | North Carolina | 37119 | 39432 | 427 |
740656 | 740656 | 2020-11-17 | Mecklenburg | North Carolina | 37119 | 39014 | 425 |
737411 | 737411 | 2020-11-16 | Mecklenburg | North Carolina | 37119 | 38677 | 421 |
734167 | 734167 | 2020-11-15 | Mecklenburg | North Carolina | 37119 | 38310 | 420 |
730921 | 730921 | 2020-11-14 | Mecklenburg | North Carolina | 37119 | 38109 | 417 |
727677 | 727677 | 2020-11-13 | Mecklenburg | North Carolina | 37119 | 37817 | 417 |
724433 | 724433 | 2020-11-12 | Mecklenburg | North Carolina | 37119 | 37432 | 414 |
721190 | 721190 | 2020-11-11 | Mecklenburg | North Carolina | 37119 | 37162 | 413 |
717947 | 717947 | 2020-11-10 | Mecklenburg | North Carolina | 37119 | 36863 | 411 |
714704 | 714704 | 2020-11-09 | Mecklenburg | North Carolina | 37119 | 36530 | 410 |
711460 | 711460 | 2020-11-08 | Mecklenburg | North Carolina | 37119 | 36311 | 406 |
708216 | 708216 | 2020-11-07 | Mecklenburg | North Carolina | 37119 | 36106 | 406 |
704973 | 704973 | 2020-11-06 | Mecklenburg | North Carolina | 37119 | 35845 | 406 |
701730 | 701730 | 2020-11-05 | Mecklenburg | North Carolina | 37119 | 35609 | 404 |
698486 | 698486 | 2020-11-04 | Mecklenburg | North Carolina | 37119 | 35390 | 403 |
695243 | 695243 | 2020-11-03 | Mecklenburg | North Carolina | 37119 | 35076 | 401 |
692001 | 692001 | 2020-11-02 | Mecklenburg | North Carolina | 37119 | 34871 | 398 |
688757 | 688757 | 2020-11-01 | Mecklenburg | North Carolina | 37119 | 34668 | 396 |
685512 | 685512 | 2020-10-31 | Mecklenburg | North Carolina | 37119 | 34473 | 393 |
682269 | 682269 | 2020-10-30 | Mecklenburg | North Carolina | 37119 | 34193 | 391 |
679026 | 679026 | 2020-10-29 | Mecklenburg | North Carolina | 37119 | 33988 | 390 |
675783 | 675783 | 2020-10-28 | Mecklenburg | North Carolina | 37119 | 33779 | 390 |
672540 | 672540 | 2020-10-27 | Mecklenburg | North Carolina | 37119 | 33552 | 386 |
669298 | 669298 | 2020-10-26 | Mecklenburg | North Carolina | 37119 | 33299 | 386 |
666054 | 666054 | 2020-10-25 | Mecklenburg | North Carolina | 37119 | 33065 | 382 |
662809 | 662809 | 2020-10-24 | Mecklenburg | North Carolina | 37119 | 32877 | 381 |
659565 | 659565 | 2020-10-23 | Mecklenburg | North Carolina | 37119 | 32601 | 381 |
656321 | 656321 | 2020-10-22 | Mecklenburg | North Carolina | 37119 | 32457 | 381 |
653076 | 653076 | 2020-10-21 | Mecklenburg | North Carolina | 37119 | 32264 | 381 |
649831 | 649831 | 2020-10-20 | Mecklenburg | North Carolina | 37119 | 32038 | 377 |
646587 | 646587 | 2020-10-19 | Mecklenburg | North Carolina | 37119 | 31820 | 377 |
643341 | 643341 | 2020-10-18 | Mecklenburg | North Carolina | 37119 | 31688 | 377 |
640093 | 640093 | 2020-10-17 | Mecklenburg | North Carolina | 37119 | 31442 | 375 |
636847 | 636847 | 2020-10-16 | Mecklenburg | North Carolina | 37119 | 31279 | 375 |
633601 | 633601 | 2020-10-15 | Mecklenburg | North Carolina | 37119 | 31074 | 375 |
630356 | 630356 | 2020-10-14 | Mecklenburg | North Carolina | 37119 | 30818 | 374 |
627112 | 627112 | 2020-10-13 | Mecklenburg | North Carolina | 37119 | 30670 | 374 |
623870 | 623870 | 2020-10-12 | Mecklenburg | North Carolina | 37119 | 30502 | 368 |
620627 | 620627 | 2020-10-11 | Mecklenburg | North Carolina | 37119 | 30366 | 366 |
617385 | 617385 | 2020-10-10 | Mecklenburg | North Carolina | 37119 | 30273 | 366 |
614143 | 614143 | 2020-10-09 | Mecklenburg | North Carolina | 37119 | 30088 | 366 |
610902 | 610902 | 2020-10-08 | Mecklenburg | North Carolina | 37119 | 29963 | 365 |
607660 | 607660 | 2020-10-07 | Mecklenburg | North Carolina | 37119 | 29829 | 365 |
604417 | 604417 | 2020-10-06 | Mecklenburg | North Carolina | 37119 | 29701 | 365 |
601175 | 601175 | 2020-10-05 | Mecklenburg | North Carolina | 37119 | 29593 | 364 |
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);