ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Hoke" and state = "North Carolina" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4178 | 4178 | 2020-03-18 | Hoke | North Carolina | 37093 | 1 | 0 |
4909 | 4909 | 2020-03-19 | Hoke | North Carolina | 37093 | 1 | 0 |
5763 | 5763 | 2020-03-20 | Hoke | North Carolina | 37093 | 1 | 0 |
6760 | 6760 | 2020-03-21 | Hoke | North Carolina | 37093 | 1 | 0 |
7861 | 7861 | 2020-03-22 | Hoke | North Carolina | 37093 | 1 | 0 |
9062 | 9062 | 2020-03-23 | Hoke | North Carolina | 37093 | 1 | 0 |
10370 | 10370 | 2020-03-24 | Hoke | North Carolina | 37093 | 2 | 0 |
11812 | 11812 | 2020-03-25 | Hoke | North Carolina | 37093 | 2 | 0 |
13416 | 13416 | 2020-03-26 | Hoke | North Carolina | 37093 | 2 | 0 |
15151 | 15151 | 2020-03-27 | Hoke | North Carolina | 37093 | 2 | 0 |
16983 | 16983 | 2020-03-28 | Hoke | North Carolina | 37093 | 3 | 0 |
18914 | 18914 | 2020-03-29 | Hoke | North Carolina | 37093 | 3 | 0 |
20954 | 20954 | 2020-03-30 | Hoke | North Carolina | 37093 | 3 | 0 |
23080 | 23080 | 2020-03-31 | Hoke | North Carolina | 37093 | 4 | 0 |
25274 | 25274 | 2020-04-01 | Hoke | North Carolina | 37093 | 4 | 0 |
27537 | 27537 | 2020-04-02 | Hoke | North Carolina | 37093 | 7 | 0 |
29864 | 29864 | 2020-04-03 | Hoke | North Carolina | 37093 | 9 | 0 |
32251 | 32251 | 2020-04-04 | Hoke | North Carolina | 37093 | 10 | 0 |
34682 | 34682 | 2020-04-05 | Hoke | North Carolina | 37093 | 10 | 0 |
37151 | 37151 | 2020-04-06 | Hoke | North Carolina | 37093 | 11 | 0 |
39666 | 39666 | 2020-04-07 | Hoke | North Carolina | 37093 | 12 | 0 |
42223 | 42223 | 2020-04-08 | Hoke | North Carolina | 37093 | 13 | 0 |
44806 | 44806 | 2020-04-09 | Hoke | North Carolina | 37093 | 15 | 0 |
47419 | 47419 | 2020-04-10 | Hoke | North Carolina | 37093 | 16 | 0 |
50074 | 50074 | 2020-04-11 | Hoke | North Carolina | 37093 | 18 | 0 |
52747 | 52747 | 2020-04-12 | Hoke | North Carolina | 37093 | 18 | 0 |
55430 | 55430 | 2020-04-13 | Hoke | North Carolina | 37093 | 18 | 0 |
58130 | 58130 | 2020-04-14 | Hoke | North Carolina | 37093 | 20 | 0 |
60844 | 60844 | 2020-04-15 | Hoke | North Carolina | 37093 | 20 | 0 |
63570 | 63570 | 2020-04-16 | Hoke | North Carolina | 37093 | 22 | 0 |
66313 | 66313 | 2020-04-17 | Hoke | North Carolina | 37093 | 22 | 0 |
69070 | 69070 | 2020-04-18 | Hoke | North Carolina | 37093 | 23 | 0 |
71836 | 71836 | 2020-04-19 | Hoke | North Carolina | 37093 | 23 | 0 |
74611 | 74611 | 2020-04-20 | Hoke | North Carolina | 37093 | 23 | 0 |
77392 | 77392 | 2020-04-21 | Hoke | North Carolina | 37093 | 25 | 0 |
80181 | 80181 | 2020-04-22 | Hoke | North Carolina | 37093 | 30 | 0 |
82980 | 82980 | 2020-04-23 | Hoke | North Carolina | 37093 | 34 | 0 |
85784 | 85784 | 2020-04-24 | Hoke | North Carolina | 37093 | 40 | 0 |
88596 | 88596 | 2020-04-25 | Hoke | North Carolina | 37093 | 46 | 0 |
91411 | 91411 | 2020-04-26 | Hoke | North Carolina | 37093 | 49 | 0 |
94237 | 94237 | 2020-04-27 | Hoke | North Carolina | 37093 | 61 | 0 |
97074 | 97074 | 2020-04-28 | Hoke | North Carolina | 37093 | 67 | 0 |
99921 | 99921 | 2020-04-29 | Hoke | North Carolina | 37093 | 72 | 0 |
102774 | 102774 | 2020-04-30 | Hoke | North Carolina | 37093 | 80 | 0 |
105636 | 105636 | 2020-05-01 | Hoke | North Carolina | 37093 | 82 | 0 |
108503 | 108503 | 2020-05-02 | Hoke | North Carolina | 37093 | 97 | 0 |
111376 | 111376 | 2020-05-03 | Hoke | North Carolina | 37093 | 97 | 0 |
114257 | 114257 | 2020-05-04 | Hoke | North Carolina | 37093 | 97 | 0 |
117137 | 117137 | 2020-05-05 | Hoke | North Carolina | 37093 | 101 | 0 |
120098 | 120098 | 2020-05-06 | Hoke | North Carolina | 37093 | 103 | 0 |
123073 | 123073 | 2020-05-07 | Hoke | North Carolina | 37093 | 113 | 0 |
126056 | 126056 | 2020-05-08 | Hoke | North Carolina | 37093 | 117 | 0 |
129045 | 129045 | 2020-05-09 | Hoke | North Carolina | 37093 | 120 | 0 |
132034 | 132034 | 2020-05-10 | Hoke | North Carolina | 37093 | 120 | 0 |
135025 | 135025 | 2020-05-11 | Hoke | North Carolina | 37093 | 123 | 0 |
138015 | 138015 | 2020-05-12 | Hoke | North Carolina | 37093 | 123 | 0 |
141011 | 141011 | 2020-05-13 | Hoke | North Carolina | 37093 | 128 | 0 |
144006 | 144006 | 2020-05-14 | Hoke | North Carolina | 37093 | 134 | 0 |
147007 | 147007 | 2020-05-15 | Hoke | North Carolina | 37093 | 140 | 0 |
150014 | 150014 | 2020-05-16 | Hoke | North Carolina | 37093 | 148 | 0 |
153024 | 153024 | 2020-05-17 | Hoke | North Carolina | 37093 | 149 | 0 |
156041 | 156041 | 2020-05-18 | Hoke | North Carolina | 37093 | 152 | 0 |
159060 | 159060 | 2020-05-19 | Hoke | North Carolina | 37093 | 160 | 0 |
162087 | 162087 | 2020-05-20 | Hoke | North Carolina | 37093 | 166 | 0 |
165116 | 165116 | 2020-05-21 | Hoke | North Carolina | 37093 | 173 | 0 |
168151 | 168151 | 2020-05-22 | Hoke | North Carolina | 37093 | 175 | 1 |
171190 | 171190 | 2020-05-23 | Hoke | North Carolina | 37093 | 187 | 1 |
174232 | 174232 | 2020-05-24 | Hoke | North Carolina | 37093 | 192 | 1 |
177276 | 177276 | 2020-05-25 | Hoke | North Carolina | 37093 | 197 | 1 |
180319 | 180319 | 2020-05-26 | Hoke | North Carolina | 37093 | 201 | 1 |
183367 | 183367 | 2020-05-27 | Hoke | North Carolina | 37093 | 214 | 1 |
186424 | 186424 | 2020-05-28 | Hoke | North Carolina | 37093 | 222 | 1 |
189484 | 189484 | 2020-05-29 | Hoke | North Carolina | 37093 | 232 | 1 |
192548 | 192548 | 2020-05-30 | Hoke | North Carolina | 37093 | 239 | 1 |
195618 | 195618 | 2020-05-31 | Hoke | North Carolina | 37093 | 240 | 1 |
198691 | 198691 | 2020-06-01 | Hoke | North Carolina | 37093 | 243 | 1 |
201765 | 201765 | 2020-06-02 | Hoke | North Carolina | 37093 | 248 | 1 |
204842 | 204842 | 2020-06-03 | Hoke | North Carolina | 37093 | 255 | 1 |
207923 | 207923 | 2020-06-04 | Hoke | North Carolina | 37093 | 259 | 1 |
211005 | 211005 | 2020-06-05 | Hoke | North Carolina | 37093 | 262 | 1 |
214089 | 214089 | 2020-06-06 | Hoke | North Carolina | 37093 | 271 | 1 |
217179 | 217179 | 2020-06-07 | Hoke | North Carolina | 37093 | 278 | 1 |
220271 | 220271 | 2020-06-08 | Hoke | North Carolina | 37093 | 278 | 1 |
223365 | 223365 | 2020-06-09 | Hoke | North Carolina | 37093 | 283 | 1 |
226465 | 226465 | 2020-06-10 | Hoke | North Carolina | 37093 | 288 | 1 |
229569 | 229569 | 2020-06-11 | Hoke | North Carolina | 37093 | 291 | 1 |
232674 | 232674 | 2020-06-12 | Hoke | North Carolina | 37093 | 296 | 1 |
235779 | 235779 | 2020-06-13 | Hoke | North Carolina | 37093 | 298 | 1 |
238887 | 238887 | 2020-06-14 | Hoke | North Carolina | 37093 | 299 | 1 |
241996 | 241996 | 2020-06-15 | Hoke | North Carolina | 37093 | 300 | 1 |
245108 | 245108 | 2020-06-16 | Hoke | North Carolina | 37093 | 303 | 2 |
248221 | 248221 | 2020-06-17 | Hoke | North Carolina | 37093 | 308 | 2 |
251336 | 251336 | 2020-06-18 | Hoke | North Carolina | 37093 | 312 | 2 |
254451 | 254451 | 2020-06-19 | Hoke | North Carolina | 37093 | 319 | 3 |
257574 | 257574 | 2020-06-20 | Hoke | North Carolina | 37093 | 323 | 3 |
260701 | 260701 | 2020-06-21 | Hoke | North Carolina | 37093 | 326 | 3 |
263829 | 263829 | 2020-06-22 | Hoke | North Carolina | 37093 | 326 | 3 |
266957 | 266957 | 2020-06-23 | Hoke | North Carolina | 37093 | 330 | 3 |
270091 | 270091 | 2020-06-24 | Hoke | North Carolina | 37093 | 332 | 3 |
273230 | 273230 | 2020-06-25 | Hoke | North Carolina | 37093 | 337 | 3 |
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);