ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37147 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 |
---|---|---|---|---|---|---|---|
922414 | 922414 | 2021-01-12 | Pitt | North Carolina | 37147 | 13247 | 69 |
919169 | 919169 | 2021-01-11 | Pitt | North Carolina | 37147 | 13198 | 69 |
915924 | 915924 | 2021-01-10 | Pitt | North Carolina | 37147 | 13084 | 69 |
912679 | 912679 | 2021-01-09 | Pitt | North Carolina | 37147 | 12955 | 69 |
909434 | 909434 | 2021-01-08 | Pitt | North Carolina | 37147 | 12791 | 69 |
906189 | 906189 | 2021-01-07 | Pitt | North Carolina | 37147 | 12584 | 69 |
902943 | 902943 | 2021-01-06 | Pitt | North Carolina | 37147 | 12327 | 69 |
899698 | 899698 | 2021-01-05 | Pitt | North Carolina | 37147 | 12186 | 69 |
896453 | 896453 | 2021-01-04 | Pitt | North Carolina | 37147 | 12124 | 69 |
893207 | 893207 | 2021-01-03 | Pitt | North Carolina | 37147 | 12013 | 69 |
889961 | 889961 | 2021-01-02 | Pitt | North Carolina | 37147 | 11902 | 69 |
886714 | 886714 | 2021-01-01 | Pitt | North Carolina | 37147 | 11454 | 69 |
883469 | 883469 | 2020-12-31 | Pitt | North Carolina | 37147 | 11454 | 69 |
880224 | 880224 | 2020-12-30 | Pitt | North Carolina | 37147 | 11215 | 69 |
876979 | 876979 | 2020-12-29 | Pitt | North Carolina | 37147 | 11051 | 69 |
873734 | 873734 | 2020-12-28 | Pitt | North Carolina | 37147 | 11008 | 69 |
870489 | 870489 | 2020-12-27 | Pitt | North Carolina | 37147 | 10929 | 69 |
867244 | 867244 | 2020-12-26 | Pitt | North Carolina | 37147 | 10914 | 69 |
863999 | 863999 | 2020-12-25 | Pitt | North Carolina | 37147 | 10490 | 69 |
860754 | 860754 | 2020-12-24 | Pitt | North Carolina | 37147 | 10490 | 69 |
857509 | 857509 | 2020-12-23 | Pitt | North Carolina | 37147 | 10490 | 69 |
854264 | 854264 | 2020-12-22 | Pitt | North Carolina | 37147 | 10385 | 69 |
851019 | 851019 | 2020-12-21 | Pitt | North Carolina | 37147 | 10332 | 69 |
847774 | 847774 | 2020-12-20 | Pitt | North Carolina | 37147 | 10267 | 69 |
844529 | 844529 | 2020-12-19 | Pitt | North Carolina | 37147 | 10141 | 69 |
841283 | 841283 | 2020-12-18 | Pitt | North Carolina | 37147 | 10001 | 64 |
838038 | 838038 | 2020-12-17 | Pitt | North Carolina | 37147 | 9778 | 64 |
834792 | 834792 | 2020-12-16 | Pitt | North Carolina | 37147 | 9674 | 59 |
831546 | 831546 | 2020-12-15 | Pitt | North Carolina | 37147 | 9590 | 59 |
828299 | 828299 | 2020-12-14 | Pitt | North Carolina | 37147 | 9551 | 59 |
825053 | 825053 | 2020-12-13 | Pitt | North Carolina | 37147 | 9467 | 59 |
821806 | 821806 | 2020-12-12 | Pitt | North Carolina | 37147 | 9331 | 59 |
818560 | 818560 | 2020-12-11 | Pitt | North Carolina | 37147 | 9208 | 59 |
815314 | 815314 | 2020-12-10 | Pitt | North Carolina | 37147 | 9038 | 58 |
812069 | 812069 | 2020-12-09 | Pitt | North Carolina | 37147 | 8884 | 58 |
808824 | 808824 | 2020-12-08 | Pitt | North Carolina | 37147 | 8791 | 58 |
805579 | 805579 | 2020-12-07 | Pitt | North Carolina | 37147 | 8741 | 58 |
802334 | 802334 | 2020-12-06 | Pitt | North Carolina | 37147 | 8641 | 58 |
799089 | 799089 | 2020-12-05 | Pitt | North Carolina | 37147 | 8455 | 52 |
795844 | 795844 | 2020-12-04 | Pitt | North Carolina | 37147 | 8383 | 49 |
792599 | 792599 | 2020-12-03 | Pitt | North Carolina | 37147 | 8247 | 48 |
789354 | 789354 | 2020-12-02 | Pitt | North Carolina | 37147 | 8057 | 48 |
786109 | 786109 | 2020-12-01 | Pitt | North Carolina | 37147 | 7977 | 48 |
782865 | 782865 | 2020-11-30 | Pitt | North Carolina | 37147 | 7935 | 48 |
779619 | 779619 | 2020-11-29 | Pitt | North Carolina | 37147 | 7897 | 48 |
776374 | 776374 | 2020-11-28 | Pitt | North Carolina | 37147 | 7816 | 48 |
773129 | 773129 | 2020-11-27 | Pitt | North Carolina | 37147 | 7771 | 48 |
769884 | 769884 | 2020-11-26 | Pitt | North Carolina | 37147 | 7599 | 44 |
766638 | 766638 | 2020-11-25 | Pitt | North Carolina | 37147 | 7599 | 44 |
763393 | 763393 | 2020-11-24 | Pitt | North Carolina | 37147 | 7531 | 44 |
760148 | 760148 | 2020-11-23 | Pitt | North Carolina | 37147 | 7498 | 44 |
756902 | 756902 | 2020-11-22 | Pitt | North Carolina | 37147 | 7457 | 44 |
753655 | 753655 | 2020-11-21 | Pitt | North Carolina | 37147 | 7317 | 44 |
750409 | 750409 | 2020-11-20 | Pitt | North Carolina | 37147 | 7285 | 44 |
747163 | 747163 | 2020-11-19 | Pitt | North Carolina | 37147 | 7220 | 44 |
743917 | 743917 | 2020-11-18 | Pitt | North Carolina | 37147 | 7101 | 44 |
740670 | 740670 | 2020-11-17 | Pitt | North Carolina | 37147 | 7059 | 44 |
737425 | 737425 | 2020-11-16 | Pitt | North Carolina | 37147 | 7041 | 44 |
734181 | 734181 | 2020-11-15 | Pitt | North Carolina | 37147 | 7015 | 44 |
730935 | 730935 | 2020-11-14 | Pitt | North Carolina | 37147 | 6958 | 44 |
727691 | 727691 | 2020-11-13 | Pitt | North Carolina | 37147 | 6867 | 44 |
724447 | 724447 | 2020-11-12 | Pitt | North Carolina | 37147 | 6800 | 44 |
721204 | 721204 | 2020-11-11 | Pitt | North Carolina | 37147 | 6744 | 44 |
717961 | 717961 | 2020-11-10 | Pitt | North Carolina | 37147 | 6693 | 44 |
714718 | 714718 | 2020-11-09 | Pitt | North Carolina | 37147 | 6665 | 41 |
711474 | 711474 | 2020-11-08 | Pitt | North Carolina | 37147 | 6660 | 41 |
708230 | 708230 | 2020-11-07 | Pitt | North Carolina | 37147 | 6624 | 41 |
704987 | 704987 | 2020-11-06 | Pitt | North Carolina | 37147 | 6549 | 41 |
701744 | 701744 | 2020-11-05 | Pitt | North Carolina | 37147 | 6493 | 41 |
698500 | 698500 | 2020-11-04 | Pitt | North Carolina | 37147 | 6445 | 41 |
695257 | 695257 | 2020-11-03 | Pitt | North Carolina | 37147 | 6372 | 41 |
692015 | 692015 | 2020-11-02 | Pitt | North Carolina | 37147 | 6332 | 41 |
688771 | 688771 | 2020-11-01 | Pitt | North Carolina | 37147 | 6331 | 41 |
685526 | 685526 | 2020-10-31 | Pitt | North Carolina | 37147 | 6300 | 41 |
682283 | 682283 | 2020-10-30 | Pitt | North Carolina | 37147 | 6246 | 39 |
679040 | 679040 | 2020-10-29 | Pitt | North Carolina | 37147 | 6196 | 39 |
675797 | 675797 | 2020-10-28 | Pitt | North Carolina | 37147 | 6142 | 39 |
672554 | 672554 | 2020-10-27 | Pitt | North Carolina | 37147 | 6113 | 38 |
669312 | 669312 | 2020-10-26 | Pitt | North Carolina | 37147 | 6102 | 38 |
666068 | 666068 | 2020-10-25 | Pitt | North Carolina | 37147 | 6090 | 38 |
662823 | 662823 | 2020-10-24 | Pitt | North Carolina | 37147 | 6063 | 38 |
659579 | 659579 | 2020-10-23 | Pitt | North Carolina | 37147 | 6007 | 38 |
656335 | 656335 | 2020-10-22 | Pitt | North Carolina | 37147 | 5958 | 38 |
653090 | 653090 | 2020-10-21 | Pitt | North Carolina | 37147 | 5902 | 35 |
649845 | 649845 | 2020-10-20 | Pitt | North Carolina | 37147 | 5859 | 35 |
646601 | 646601 | 2020-10-19 | Pitt | North Carolina | 37147 | 5837 | 35 |
643355 | 643355 | 2020-10-18 | Pitt | North Carolina | 37147 | 5828 | 35 |
640107 | 640107 | 2020-10-17 | Pitt | North Carolina | 37147 | 5772 | 35 |
636861 | 636861 | 2020-10-16 | Pitt | North Carolina | 37147 | 5703 | 35 |
633615 | 633615 | 2020-10-15 | Pitt | North Carolina | 37147 | 5655 | 35 |
630370 | 630370 | 2020-10-14 | Pitt | North Carolina | 37147 | 5593 | 35 |
627126 | 627126 | 2020-10-13 | Pitt | North Carolina | 37147 | 5537 | 35 |
623884 | 623884 | 2020-10-12 | Pitt | North Carolina | 37147 | 5507 | 33 |
620641 | 620641 | 2020-10-11 | Pitt | North Carolina | 37147 | 5490 | 33 |
617399 | 617399 | 2020-10-10 | Pitt | North Carolina | 37147 | 5453 | 33 |
614157 | 614157 | 2020-10-09 | Pitt | North Carolina | 37147 | 5389 | 33 |
610916 | 610916 | 2020-10-08 | Pitt | North Carolina | 37147 | 5343 | 33 |
607674 | 607674 | 2020-10-07 | Pitt | North Carolina | 37147 | 5281 | 33 |
604431 | 604431 | 2020-10-06 | Pitt | North Carolina | 37147 | 5174 | 33 |
601189 | 601189 | 2020-10-05 | Pitt | North Carolina | 37147 | 5133 | 33 |
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);