ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Wilkes" and fips = 37193 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23118 | 23118 | 2020-03-31 | Wilkes | North Carolina | 37193 | 2 | 0 |
25312 | 25312 | 2020-04-01 | Wilkes | North Carolina | 37193 | 2 | 0 |
27578 | 27578 | 2020-04-02 | Wilkes | North Carolina | 37193 | 4 | 1 |
29905 | 29905 | 2020-04-03 | Wilkes | North Carolina | 37193 | 4 | 1 |
32293 | 32293 | 2020-04-04 | Wilkes | North Carolina | 37193 | 4 | 1 |
34725 | 34725 | 2020-04-05 | Wilkes | North Carolina | 37193 | 4 | 1 |
37194 | 37194 | 2020-04-06 | Wilkes | North Carolina | 37193 | 4 | 1 |
39710 | 39710 | 2020-04-07 | Wilkes | North Carolina | 37193 | 4 | 1 |
42267 | 42267 | 2020-04-08 | Wilkes | North Carolina | 37193 | 4 | 1 |
44851 | 44851 | 2020-04-09 | Wilkes | North Carolina | 37193 | 4 | 1 |
47464 | 47464 | 2020-04-10 | Wilkes | North Carolina | 37193 | 4 | 1 |
50119 | 50119 | 2020-04-11 | Wilkes | North Carolina | 37193 | 4 | 1 |
52792 | 52792 | 2020-04-12 | Wilkes | North Carolina | 37193 | 4 | 1 |
55476 | 55476 | 2020-04-13 | Wilkes | North Carolina | 37193 | 4 | 1 |
58177 | 58177 | 2020-04-14 | Wilkes | North Carolina | 37193 | 4 | 1 |
60891 | 60891 | 2020-04-15 | Wilkes | North Carolina | 37193 | 4 | 1 |
63617 | 63617 | 2020-04-16 | Wilkes | North Carolina | 37193 | 4 | 1 |
66360 | 66360 | 2020-04-17 | Wilkes | North Carolina | 37193 | 4 | 1 |
69117 | 69117 | 2020-04-18 | Wilkes | North Carolina | 37193 | 4 | 1 |
71883 | 71883 | 2020-04-19 | Wilkes | North Carolina | 37193 | 4 | 1 |
74658 | 74658 | 2020-04-20 | Wilkes | North Carolina | 37193 | 4 | 1 |
77439 | 77439 | 2020-04-21 | Wilkes | North Carolina | 37193 | 5 | 1 |
80228 | 80228 | 2020-04-22 | Wilkes | North Carolina | 37193 | 5 | 1 |
83027 | 83027 | 2020-04-23 | Wilkes | North Carolina | 37193 | 8 | 1 |
85831 | 85831 | 2020-04-24 | Wilkes | North Carolina | 37193 | 11 | 1 |
88644 | 88644 | 2020-04-25 | Wilkes | North Carolina | 37193 | 18 | 1 |
91459 | 91459 | 2020-04-26 | Wilkes | North Carolina | 37193 | 21 | 1 |
94285 | 94285 | 2020-04-27 | Wilkes | North Carolina | 37193 | 21 | 1 |
97122 | 97122 | 2020-04-28 | Wilkes | North Carolina | 37193 | 22 | 1 |
99971 | 99971 | 2020-04-29 | Wilkes | North Carolina | 37193 | 26 | 1 |
102824 | 102824 | 2020-04-30 | Wilkes | North Carolina | 37193 | 33 | 1 |
105686 | 105686 | 2020-05-01 | Wilkes | North Carolina | 37193 | 42 | 1 |
108553 | 108553 | 2020-05-02 | Wilkes | North Carolina | 37193 | 59 | 1 |
111426 | 111426 | 2020-05-03 | Wilkes | North Carolina | 37193 | 92 | 1 |
114307 | 114307 | 2020-05-04 | Wilkes | North Carolina | 37193 | 115 | 1 |
117187 | 117187 | 2020-05-05 | Wilkes | North Carolina | 37193 | 128 | 1 |
120148 | 120148 | 2020-05-06 | Wilkes | North Carolina | 37193 | 147 | 1 |
123123 | 123123 | 2020-05-07 | Wilkes | North Carolina | 37193 | 186 | 1 |
126106 | 126106 | 2020-05-08 | Wilkes | North Carolina | 37193 | 198 | 1 |
129095 | 129095 | 2020-05-09 | Wilkes | North Carolina | 37193 | 202 | 1 |
132084 | 132084 | 2020-05-10 | Wilkes | North Carolina | 37193 | 239 | 1 |
135075 | 135075 | 2020-05-11 | Wilkes | North Carolina | 37193 | 242 | 1 |
138065 | 138065 | 2020-05-12 | Wilkes | North Carolina | 37193 | 243 | 1 |
141061 | 141061 | 2020-05-13 | Wilkes | North Carolina | 37193 | 262 | 1 |
144056 | 144056 | 2020-05-14 | Wilkes | North Carolina | 37193 | 277 | 1 |
147057 | 147057 | 2020-05-15 | Wilkes | North Carolina | 37193 | 287 | 1 |
150064 | 150064 | 2020-05-16 | Wilkes | North Carolina | 37193 | 405 | 1 |
153074 | 153074 | 2020-05-17 | Wilkes | North Carolina | 37193 | 423 | 1 |
156091 | 156091 | 2020-05-18 | Wilkes | North Carolina | 37193 | 425 | 1 |
159110 | 159110 | 2020-05-19 | Wilkes | North Carolina | 37193 | 448 | 1 |
162137 | 162137 | 2020-05-20 | Wilkes | North Carolina | 37193 | 451 | 1 |
165166 | 165166 | 2020-05-21 | Wilkes | North Carolina | 37193 | 456 | 1 |
168201 | 168201 | 2020-05-22 | Wilkes | North Carolina | 37193 | 462 | 3 |
171240 | 171240 | 2020-05-23 | Wilkes | North Carolina | 37193 | 472 | 3 |
174282 | 174282 | 2020-05-24 | Wilkes | North Carolina | 37193 | 473 | 3 |
177326 | 177326 | 2020-05-25 | Wilkes | North Carolina | 37193 | 478 | 3 |
180369 | 180369 | 2020-05-26 | Wilkes | North Carolina | 37193 | 478 | 3 |
183417 | 183417 | 2020-05-27 | Wilkes | North Carolina | 37193 | 483 | 3 |
186474 | 186474 | 2020-05-28 | Wilkes | North Carolina | 37193 | 486 | 4 |
189534 | 189534 | 2020-05-29 | Wilkes | North Carolina | 37193 | 492 | 5 |
192598 | 192598 | 2020-05-30 | Wilkes | North Carolina | 37193 | 494 | 5 |
195668 | 195668 | 2020-05-31 | Wilkes | North Carolina | 37193 | 497 | 5 |
198741 | 198741 | 2020-06-01 | Wilkes | North Carolina | 37193 | 500 | 6 |
201815 | 201815 | 2020-06-02 | Wilkes | North Carolina | 37193 | 500 | 6 |
204892 | 204892 | 2020-06-03 | Wilkes | North Carolina | 37193 | 500 | 6 |
207973 | 207973 | 2020-06-04 | Wilkes | North Carolina | 37193 | 502 | 6 |
211055 | 211055 | 2020-06-05 | Wilkes | North Carolina | 37193 | 504 | 6 |
214139 | 214139 | 2020-06-06 | Wilkes | North Carolina | 37193 | 507 | 6 |
217229 | 217229 | 2020-06-07 | Wilkes | North Carolina | 37193 | 509 | 6 |
220321 | 220321 | 2020-06-08 | Wilkes | North Carolina | 37193 | 511 | 6 |
223415 | 223415 | 2020-06-09 | Wilkes | North Carolina | 37193 | 513 | 6 |
226515 | 226515 | 2020-06-10 | Wilkes | North Carolina | 37193 | 513 | 6 |
229619 | 229619 | 2020-06-11 | Wilkes | North Carolina | 37193 | 516 | 6 |
232724 | 232724 | 2020-06-12 | Wilkes | North Carolina | 37193 | 530 | 6 |
235829 | 235829 | 2020-06-13 | Wilkes | North Carolina | 37193 | 542 | 6 |
238937 | 238937 | 2020-06-14 | Wilkes | North Carolina | 37193 | 542 | 6 |
242046 | 242046 | 2020-06-15 | Wilkes | North Carolina | 37193 | 544 | 6 |
245158 | 245158 | 2020-06-16 | Wilkes | North Carolina | 37193 | 547 | 6 |
248271 | 248271 | 2020-06-17 | Wilkes | North Carolina | 37193 | 550 | 6 |
251386 | 251386 | 2020-06-18 | Wilkes | North Carolina | 37193 | 551 | 6 |
254501 | 254501 | 2020-06-19 | Wilkes | North Carolina | 37193 | 554 | 6 |
257624 | 257624 | 2020-06-20 | Wilkes | North Carolina | 37193 | 554 | 6 |
260751 | 260751 | 2020-06-21 | Wilkes | North Carolina | 37193 | 555 | 6 |
263879 | 263879 | 2020-06-22 | Wilkes | North Carolina | 37193 | 555 | 6 |
267007 | 267007 | 2020-06-23 | Wilkes | North Carolina | 37193 | 557 | 6 |
270141 | 270141 | 2020-06-24 | Wilkes | North Carolina | 37193 | 560 | 6 |
273280 | 273280 | 2020-06-25 | Wilkes | North Carolina | 37193 | 561 | 6 |
276426 | 276426 | 2020-06-26 | Wilkes | North Carolina | 37193 | 564 | 6 |
279574 | 279574 | 2020-06-27 | Wilkes | North Carolina | 37193 | 567 | 6 |
282720 | 282720 | 2020-06-28 | Wilkes | North Carolina | 37193 | 570 | 6 |
285865 | 285865 | 2020-06-29 | Wilkes | North Carolina | 37193 | 576 | 6 |
289015 | 289015 | 2020-06-30 | Wilkes | North Carolina | 37193 | 576 | 6 |
292167 | 292167 | 2020-07-01 | Wilkes | North Carolina | 37193 | 578 | 6 |
295322 | 295322 | 2020-07-02 | Wilkes | North Carolina | 37193 | 583 | 6 |
298482 | 298482 | 2020-07-03 | Wilkes | North Carolina | 37193 | 586 | 6 |
301645 | 301645 | 2020-07-04 | Wilkes | North Carolina | 37193 | 588 | 6 |
304808 | 304808 | 2020-07-05 | Wilkes | North Carolina | 37193 | 589 | 6 |
307975 | 307975 | 2020-07-06 | Wilkes | North Carolina | 37193 | 593 | 6 |
311143 | 311143 | 2020-07-07 | Wilkes | North Carolina | 37193 | 592 | 6 |
314314 | 314314 | 2020-07-08 | Wilkes | North Carolina | 37193 | 600 | 6 |
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);