ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 37129 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 |
---|---|---|---|---|---|---|---|
217197 | 217197 | 2020-06-07 | New Hanover | North Carolina | 37129 | 259 | 5 |
214107 | 214107 | 2020-06-06 | New Hanover | North Carolina | 37129 | 252 | 5 |
211023 | 211023 | 2020-06-05 | New Hanover | North Carolina | 37129 | 230 | 5 |
207941 | 207941 | 2020-06-04 | New Hanover | North Carolina | 37129 | 220 | 5 |
204860 | 204860 | 2020-06-03 | New Hanover | North Carolina | 37129 | 210 | 5 |
201783 | 201783 | 2020-06-02 | New Hanover | North Carolina | 37129 | 203 | 5 |
198709 | 198709 | 2020-06-01 | New Hanover | North Carolina | 37129 | 197 | 5 |
195636 | 195636 | 2020-05-31 | New Hanover | North Carolina | 37129 | 195 | 5 |
192566 | 192566 | 2020-05-30 | New Hanover | North Carolina | 37129 | 189 | 5 |
189502 | 189502 | 2020-05-29 | New Hanover | North Carolina | 37129 | 180 | 4 |
186442 | 186442 | 2020-05-28 | New Hanover | North Carolina | 37129 | 167 | 4 |
183385 | 183385 | 2020-05-27 | New Hanover | North Carolina | 37129 | 164 | 4 |
180337 | 180337 | 2020-05-26 | New Hanover | North Carolina | 37129 | 156 | 4 |
177294 | 177294 | 2020-05-25 | New Hanover | North Carolina | 37129 | 156 | 4 |
174250 | 174250 | 2020-05-24 | New Hanover | North Carolina | 37129 | 153 | 4 |
171208 | 171208 | 2020-05-23 | New Hanover | North Carolina | 37129 | 147 | 4 |
168169 | 168169 | 2020-05-22 | New Hanover | North Carolina | 37129 | 143 | 3 |
165134 | 165134 | 2020-05-21 | New Hanover | North Carolina | 37129 | 140 | 3 |
162105 | 162105 | 2020-05-20 | New Hanover | North Carolina | 37129 | 137 | 3 |
159078 | 159078 | 2020-05-19 | New Hanover | North Carolina | 37129 | 134 | 3 |
156059 | 156059 | 2020-05-18 | New Hanover | North Carolina | 37129 | 122 | 3 |
153042 | 153042 | 2020-05-17 | New Hanover | North Carolina | 37129 | 120 | 3 |
150032 | 150032 | 2020-05-16 | New Hanover | North Carolina | 37129 | 120 | 3 |
147025 | 147025 | 2020-05-15 | New Hanover | North Carolina | 37129 | 118 | 3 |
144024 | 144024 | 2020-05-14 | New Hanover | North Carolina | 37129 | 116 | 3 |
141029 | 141029 | 2020-05-13 | New Hanover | North Carolina | 37129 | 112 | 3 |
138033 | 138033 | 2020-05-12 | New Hanover | North Carolina | 37129 | 104 | 3 |
135043 | 135043 | 2020-05-11 | New Hanover | North Carolina | 37129 | 97 | 3 |
132052 | 132052 | 2020-05-10 | New Hanover | North Carolina | 37129 | 97 | 3 |
129063 | 129063 | 2020-05-09 | New Hanover | North Carolina | 37129 | 96 | 3 |
126074 | 126074 | 2020-05-08 | New Hanover | North Carolina | 37129 | 95 | 3 |
123091 | 123091 | 2020-05-07 | New Hanover | North Carolina | 37129 | 91 | 3 |
120116 | 120116 | 2020-05-06 | New Hanover | North Carolina | 37129 | 84 | 3 |
117155 | 117155 | 2020-05-05 | New Hanover | North Carolina | 37129 | 83 | 3 |
114275 | 114275 | 2020-05-04 | New Hanover | North Carolina | 37129 | 79 | 3 |
111394 | 111394 | 2020-05-03 | New Hanover | North Carolina | 37129 | 79 | 3 |
108521 | 108521 | 2020-05-02 | New Hanover | North Carolina | 37129 | 79 | 3 |
105654 | 105654 | 2020-05-01 | New Hanover | North Carolina | 37129 | 75 | 3 |
102792 | 102792 | 2020-04-30 | New Hanover | North Carolina | 37129 | 75 | 3 |
99939 | 99939 | 2020-04-29 | New Hanover | North Carolina | 37129 | 74 | 3 |
97091 | 97091 | 2020-04-28 | New Hanover | North Carolina | 37129 | 74 | 3 |
94254 | 94254 | 2020-04-27 | New Hanover | North Carolina | 37129 | 74 | 3 |
91428 | 91428 | 2020-04-26 | New Hanover | North Carolina | 37129 | 72 | 3 |
88613 | 88613 | 2020-04-25 | New Hanover | North Carolina | 37129 | 71 | 3 |
85800 | 85800 | 2020-04-24 | New Hanover | North Carolina | 37129 | 66 | 3 |
82996 | 82996 | 2020-04-23 | New Hanover | North Carolina | 37129 | 66 | 2 |
80197 | 80197 | 2020-04-22 | New Hanover | North Carolina | 37129 | 62 | 2 |
77408 | 77408 | 2020-04-21 | New Hanover | North Carolina | 37129 | 62 | 1 |
74627 | 74627 | 2020-04-20 | New Hanover | North Carolina | 37129 | 62 | 1 |
71852 | 71852 | 2020-04-19 | New Hanover | North Carolina | 37129 | 62 | 1 |
69086 | 69086 | 2020-04-18 | New Hanover | North Carolina | 37129 | 62 | 1 |
66329 | 66329 | 2020-04-17 | New Hanover | North Carolina | 37129 | 60 | 1 |
63586 | 63586 | 2020-04-16 | New Hanover | North Carolina | 37129 | 58 | 1 |
60860 | 60860 | 2020-04-15 | New Hanover | North Carolina | 37129 | 56 | 1 |
58146 | 58146 | 2020-04-14 | New Hanover | North Carolina | 37129 | 55 | 1 |
55446 | 55446 | 2020-04-13 | New Hanover | North Carolina | 37129 | 54 | 1 |
52762 | 52762 | 2020-04-12 | New Hanover | North Carolina | 37129 | 54 | 1 |
50089 | 50089 | 2020-04-11 | New Hanover | North Carolina | 37129 | 54 | 0 |
47434 | 47434 | 2020-04-10 | New Hanover | North Carolina | 37129 | 50 | 0 |
44821 | 44821 | 2020-04-09 | New Hanover | North Carolina | 37129 | 49 | 0 |
42237 | 42237 | 2020-04-08 | New Hanover | North Carolina | 37129 | 48 | 0 |
39680 | 39680 | 2020-04-07 | New Hanover | North Carolina | 37129 | 47 | 0 |
37165 | 37165 | 2020-04-06 | New Hanover | North Carolina | 37129 | 45 | 0 |
34696 | 34696 | 2020-04-05 | New Hanover | North Carolina | 37129 | 37 | 0 |
32265 | 32265 | 2020-04-04 | New Hanover | North Carolina | 37129 | 37 | 0 |
29878 | 29878 | 2020-04-03 | New Hanover | North Carolina | 37129 | 36 | 0 |
27551 | 27551 | 2020-04-02 | New Hanover | North Carolina | 37129 | 33 | 0 |
25286 | 25286 | 2020-04-01 | New Hanover | North Carolina | 37129 | 32 | 0 |
23092 | 23092 | 2020-03-31 | New Hanover | North Carolina | 37129 | 28 | 0 |
20965 | 20965 | 2020-03-30 | New Hanover | North Carolina | 37129 | 26 | 0 |
18925 | 18925 | 2020-03-29 | New Hanover | North Carolina | 37129 | 22 | 0 |
16994 | 16994 | 2020-03-28 | New Hanover | North Carolina | 37129 | 18 | 0 |
15162 | 15162 | 2020-03-27 | New Hanover | North Carolina | 37129 | 13 | 0 |
13427 | 13427 | 2020-03-26 | New Hanover | North Carolina | 37129 | 11 | 0 |
11823 | 11823 | 2020-03-25 | New Hanover | North Carolina | 37129 | 9 | 0 |
10379 | 10379 | 2020-03-24 | New Hanover | North Carolina | 37129 | 7 | 0 |
9070 | 9070 | 2020-03-23 | New Hanover | North Carolina | 37129 | 4 | 0 |
7869 | 7869 | 2020-03-22 | New Hanover | North Carolina | 37129 | 3 | 0 |
6766 | 6766 | 2020-03-21 | New Hanover | North Carolina | 37129 | 1 | 0 |
5769 | 5769 | 2020-03-20 | New Hanover | North Carolina | 37129 | 1 | 0 |
4915 | 4915 | 2020-03-19 | New Hanover | North Carolina | 37129 | 1 | 0 |
4184 | 4184 | 2020-03-18 | New Hanover | North Carolina | 37129 | 1 | 0 |
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);