ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 37019 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 |
---|---|---|---|---|---|---|---|
1094365 | 1094365 | 2021-03-06 | Brunswick | North Carolina | 37019 | 8116 | 137 |
1091119 | 1091119 | 2021-03-05 | Brunswick | North Carolina | 37019 | 8084 | 137 |
1087874 | 1087874 | 2021-03-04 | Brunswick | North Carolina | 37019 | 8067 | 137 |
1084629 | 1084629 | 2021-03-03 | Brunswick | North Carolina | 37019 | 8040 | 136 |
1081383 | 1081383 | 2021-03-02 | Brunswick | North Carolina | 37019 | 8019 | 135 |
1078137 | 1078137 | 2021-03-01 | Brunswick | North Carolina | 37019 | 8007 | 134 |
1074892 | 1074892 | 2021-02-28 | Brunswick | North Carolina | 37019 | 7971 | 133 |
1071646 | 1071646 | 2021-02-27 | Brunswick | North Carolina | 37019 | 7971 | 133 |
1068400 | 1068400 | 2021-02-26 | Brunswick | North Carolina | 37019 | 7952 | 133 |
1065155 | 1065155 | 2021-02-25 | Brunswick | North Carolina | 37019 | 7916 | 133 |
1061911 | 1061911 | 2021-02-24 | Brunswick | North Carolina | 37019 | 7884 | 133 |
1058665 | 1058665 | 2021-02-23 | Brunswick | North Carolina | 37019 | 7825 | 132 |
1055419 | 1055419 | 2021-02-22 | Brunswick | North Carolina | 37019 | 7807 | 131 |
1052173 | 1052173 | 2021-02-21 | Brunswick | North Carolina | 37019 | 7784 | 131 |
1048926 | 1048926 | 2021-02-20 | Brunswick | North Carolina | 37019 | 7752 | 130 |
1045679 | 1045679 | 2021-02-19 | Brunswick | North Carolina | 37019 | 7723 | 125 |
1042434 | 1042434 | 2021-02-18 | Brunswick | North Carolina | 37019 | 7658 | 124 |
1039189 | 1039189 | 2021-02-17 | Brunswick | North Carolina | 37019 | 7593 | 121 |
1035944 | 1035944 | 2021-02-16 | Brunswick | North Carolina | 37019 | 7543 | 121 |
1032699 | 1032699 | 2021-02-15 | Brunswick | North Carolina | 37019 | 7510 | 121 |
1029453 | 1029453 | 2021-02-14 | Brunswick | North Carolina | 37019 | 7472 | 119 |
1026206 | 1026206 | 2021-02-13 | Brunswick | North Carolina | 37019 | 7419 | 117 |
1022961 | 1022961 | 2021-02-12 | Brunswick | North Carolina | 37019 | 7355 | 112 |
1019716 | 1019716 | 2021-02-11 | Brunswick | North Carolina | 37019 | 7264 | 111 |
1016471 | 1016471 | 2021-02-10 | Brunswick | North Carolina | 37019 | 7199 | 109 |
1013226 | 1013226 | 2021-02-09 | Brunswick | North Carolina | 37019 | 7148 | 108 |
1009981 | 1009981 | 2021-02-08 | Brunswick | North Carolina | 37019 | 7103 | 107 |
1006735 | 1006735 | 2021-02-07 | Brunswick | North Carolina | 37019 | 7047 | 107 |
1003489 | 1003489 | 2021-02-06 | Brunswick | North Carolina | 37019 | 6986 | 105 |
1000243 | 1000243 | 2021-02-05 | Brunswick | North Carolina | 37019 | 6912 | 105 |
996997 | 996997 | 2021-02-04 | Brunswick | North Carolina | 37019 | 6862 | 103 |
993751 | 993751 | 2021-02-03 | Brunswick | North Carolina | 37019 | 6788 | 102 |
990505 | 990505 | 2021-02-02 | Brunswick | North Carolina | 37019 | 6669 | 102 |
987259 | 987259 | 2021-02-01 | Brunswick | North Carolina | 37019 | 6623 | 102 |
984012 | 984012 | 2021-01-31 | Brunswick | North Carolina | 37019 | 6571 | 102 |
980765 | 980765 | 2021-01-30 | Brunswick | North Carolina | 37019 | 6434 | 94 |
977519 | 977519 | 2021-01-29 | Brunswick | North Carolina | 37019 | 6434 | 94 |
974274 | 974274 | 2021-01-28 | Brunswick | North Carolina | 37019 | 6377 | 93 |
971029 | 971029 | 2021-01-27 | Brunswick | North Carolina | 37019 | 6295 | 93 |
967784 | 967784 | 2021-01-26 | Brunswick | North Carolina | 37019 | 6245 | 86 |
964540 | 964540 | 2021-01-25 | Brunswick | North Carolina | 37019 | 6202 | 86 |
961295 | 961295 | 2021-01-24 | Brunswick | North Carolina | 37019 | 6149 | 86 |
958050 | 958050 | 2021-01-23 | Brunswick | North Carolina | 37019 | 6076 | 86 |
954804 | 954804 | 2021-01-22 | Brunswick | North Carolina | 37019 | 5992 | 86 |
951559 | 951559 | 2021-01-21 | Brunswick | North Carolina | 37019 | 5915 | 86 |
948314 | 948314 | 2021-01-20 | Brunswick | North Carolina | 37019 | 5862 | 82 |
945067 | 945067 | 2021-01-19 | Brunswick | North Carolina | 37019 | 5751 | 82 |
941821 | 941821 | 2021-01-18 | Brunswick | North Carolina | 37019 | 5689 | 81 |
938576 | 938576 | 2021-01-17 | Brunswick | North Carolina | 37019 | 5689 | 81 |
935331 | 935331 | 2021-01-16 | Brunswick | North Carolina | 37019 | 5624 | 80 |
932086 | 932086 | 2021-01-15 | Brunswick | North Carolina | 37019 | 5544 | 79 |
928841 | 928841 | 2021-01-14 | Brunswick | North Carolina | 37019 | 5469 | 79 |
925596 | 925596 | 2021-01-13 | Brunswick | North Carolina | 37019 | 5392 | 79 |
922350 | 922350 | 2021-01-12 | Brunswick | North Carolina | 37019 | 5332 | 78 |
919105 | 919105 | 2021-01-11 | Brunswick | North Carolina | 37019 | 5268 | 78 |
915860 | 915860 | 2021-01-10 | Brunswick | North Carolina | 37019 | 5204 | 78 |
912615 | 912615 | 2021-01-09 | Brunswick | North Carolina | 37019 | 5110 | 78 |
909370 | 909370 | 2021-01-08 | Brunswick | North Carolina | 37019 | 5018 | 74 |
906125 | 906125 | 2021-01-07 | Brunswick | North Carolina | 37019 | 4926 | 74 |
902879 | 902879 | 2021-01-06 | Brunswick | North Carolina | 37019 | 4794 | 74 |
899634 | 899634 | 2021-01-05 | Brunswick | North Carolina | 37019 | 4739 | 74 |
896389 | 896389 | 2021-01-04 | Brunswick | North Carolina | 37019 | 4691 | 74 |
893143 | 893143 | 2021-01-03 | Brunswick | North Carolina | 37019 | 4659 | 74 |
889897 | 889897 | 2021-01-02 | Brunswick | North Carolina | 37019 | 4580 | 74 |
886650 | 886650 | 2021-01-01 | Brunswick | North Carolina | 37019 | 4402 | 72 |
883405 | 883405 | 2020-12-31 | Brunswick | North Carolina | 37019 | 4402 | 72 |
880160 | 880160 | 2020-12-30 | Brunswick | North Carolina | 37019 | 4364 | 72 |
876915 | 876915 | 2020-12-29 | Brunswick | North Carolina | 37019 | 4266 | 71 |
873670 | 873670 | 2020-12-28 | Brunswick | North Carolina | 37019 | 4243 | 71 |
870425 | 870425 | 2020-12-27 | Brunswick | North Carolina | 37019 | 4213 | 71 |
867180 | 867180 | 2020-12-26 | Brunswick | North Carolina | 37019 | 4192 | 71 |
863935 | 863935 | 2020-12-25 | Brunswick | North Carolina | 37019 | 4026 | 71 |
860690 | 860690 | 2020-12-24 | Brunswick | North Carolina | 37019 | 4026 | 71 |
857445 | 857445 | 2020-12-23 | Brunswick | North Carolina | 37019 | 4026 | 71 |
854200 | 854200 | 2020-12-22 | Brunswick | North Carolina | 37019 | 3983 | 70 |
850955 | 850955 | 2020-12-21 | Brunswick | North Carolina | 37019 | 3937 | 70 |
847710 | 847710 | 2020-12-20 | Brunswick | North Carolina | 37019 | 3908 | 70 |
844465 | 844465 | 2020-12-19 | Brunswick | North Carolina | 37019 | 3851 | 70 |
841219 | 841219 | 2020-12-18 | Brunswick | North Carolina | 37019 | 3802 | 70 |
837974 | 837974 | 2020-12-17 | Brunswick | North Carolina | 37019 | 3761 | 70 |
834728 | 834728 | 2020-12-16 | Brunswick | North Carolina | 37019 | 3714 | 67 |
831482 | 831482 | 2020-12-15 | Brunswick | North Carolina | 37019 | 3667 | 66 |
828235 | 828235 | 2020-12-14 | Brunswick | North Carolina | 37019 | 3634 | 66 |
824989 | 824989 | 2020-12-13 | Brunswick | North Carolina | 37019 | 3610 | 66 |
821742 | 821742 | 2020-12-12 | Brunswick | North Carolina | 37019 | 3558 | 66 |
818496 | 818496 | 2020-12-11 | Brunswick | North Carolina | 37019 | 3525 | 66 |
815250 | 815250 | 2020-12-10 | Brunswick | North Carolina | 37019 | 3482 | 66 |
812005 | 812005 | 2020-12-09 | Brunswick | North Carolina | 37019 | 3425 | 66 |
808760 | 808760 | 2020-12-08 | Brunswick | North Carolina | 37019 | 3372 | 64 |
805515 | 805515 | 2020-12-07 | Brunswick | North Carolina | 37019 | 3345 | 64 |
802270 | 802270 | 2020-12-06 | Brunswick | North Carolina | 37019 | 3311 | 64 |
799025 | 799025 | 2020-12-05 | Brunswick | North Carolina | 37019 | 3269 | 64 |
795780 | 795780 | 2020-12-04 | Brunswick | North Carolina | 37019 | 3227 | 63 |
792535 | 792535 | 2020-12-03 | Brunswick | North Carolina | 37019 | 3145 | 63 |
789290 | 789290 | 2020-12-02 | Brunswick | North Carolina | 37019 | 3092 | 62 |
786045 | 786045 | 2020-12-01 | Brunswick | North Carolina | 37019 | 3068 | 60 |
782801 | 782801 | 2020-11-30 | Brunswick | North Carolina | 37019 | 3040 | 59 |
779555 | 779555 | 2020-11-29 | Brunswick | North Carolina | 37019 | 2998 | 59 |
776310 | 776310 | 2020-11-28 | Brunswick | North Carolina | 37019 | 2973 | 58 |
773065 | 773065 | 2020-11-27 | Brunswick | North Carolina | 37019 | 2929 | 57 |
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);