ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Brooke" and state = "West Virginia" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
40511 | 40511 | 2020-04-07 | Brooke | West Virginia | 54009 | 1 | 0 |
43082 | 43082 | 2020-04-08 | Brooke | West Virginia | 54009 | 1 | 0 |
45678 | 45678 | 2020-04-09 | Brooke | West Virginia | 54009 | 2 | 0 |
48306 | 48306 | 2020-04-10 | Brooke | West Virginia | 54009 | 2 | 0 |
50964 | 50964 | 2020-04-11 | Brooke | West Virginia | 54009 | 3 | 0 |
53639 | 53639 | 2020-04-12 | Brooke | West Virginia | 54009 | 3 | 0 |
56329 | 56329 | 2020-04-13 | Brooke | West Virginia | 54009 | 3 | 0 |
59035 | 59035 | 2020-04-14 | Brooke | West Virginia | 54009 | 3 | 0 |
61754 | 61754 | 2020-04-15 | Brooke | West Virginia | 54009 | 3 | 0 |
64487 | 64487 | 2020-04-16 | Brooke | West Virginia | 54009 | 3 | 0 |
67235 | 67235 | 2020-04-17 | Brooke | West Virginia | 54009 | 3 | 0 |
69997 | 69997 | 2020-04-18 | Brooke | West Virginia | 54009 | 3 | 0 |
72766 | 72766 | 2020-04-19 | Brooke | West Virginia | 54009 | 3 | 0 |
75542 | 75542 | 2020-04-20 | Brooke | West Virginia | 54009 | 3 | 0 |
78325 | 78325 | 2020-04-21 | Brooke | West Virginia | 54009 | 3 | 0 |
81118 | 81118 | 2020-04-22 | Brooke | West Virginia | 54009 | 3 | 0 |
83919 | 83919 | 2020-04-23 | Brooke | West Virginia | 54009 | 3 | 0 |
86726 | 86726 | 2020-04-24 | Brooke | West Virginia | 54009 | 3 | 0 |
89541 | 89541 | 2020-04-25 | Brooke | West Virginia | 54009 | 3 | 0 |
92358 | 92358 | 2020-04-26 | Brooke | West Virginia | 54009 | 4 | 0 |
95187 | 95187 | 2020-04-27 | Brooke | West Virginia | 54009 | 3 | 0 |
98032 | 98032 | 2020-04-28 | Brooke | West Virginia | 54009 | 3 | 0 |
100882 | 100882 | 2020-04-29 | Brooke | West Virginia | 54009 | 3 | 0 |
103737 | 103737 | 2020-04-30 | Brooke | West Virginia | 54009 | 3 | 0 |
106601 | 106601 | 2020-05-01 | Brooke | West Virginia | 54009 | 3 | 0 |
109470 | 109470 | 2020-05-02 | Brooke | West Virginia | 54009 | 3 | 0 |
112344 | 112344 | 2020-05-03 | Brooke | West Virginia | 54009 | 3 | 0 |
115227 | 115227 | 2020-05-04 | Brooke | West Virginia | 54009 | 3 | 0 |
118186 | 118186 | 2020-05-05 | Brooke | West Virginia | 54009 | 3 | 0 |
121150 | 121150 | 2020-05-06 | Brooke | West Virginia | 54009 | 3 | 0 |
124130 | 124130 | 2020-05-07 | Brooke | West Virginia | 54009 | 3 | 0 |
127115 | 127115 | 2020-05-08 | Brooke | West Virginia | 54009 | 3 | 0 |
130105 | 130105 | 2020-05-09 | Brooke | West Virginia | 54009 | 3 | 0 |
133095 | 133095 | 2020-05-10 | Brooke | West Virginia | 54009 | 3 | 0 |
136085 | 136085 | 2020-05-11 | Brooke | West Virginia | 54009 | 3 | 0 |
139076 | 139076 | 2020-05-12 | Brooke | West Virginia | 54009 | 3 | 0 |
142072 | 142072 | 2020-05-13 | Brooke | West Virginia | 54009 | 3 | 0 |
145069 | 145069 | 2020-05-14 | Brooke | West Virginia | 54009 | 3 | 0 |
148072 | 148072 | 2020-05-15 | Brooke | West Virginia | 54009 | 3 | 0 |
151081 | 151081 | 2020-05-16 | Brooke | West Virginia | 54009 | 3 | 0 |
154092 | 154092 | 2020-05-17 | Brooke | West Virginia | 54009 | 3 | 0 |
157109 | 157109 | 2020-05-18 | Brooke | West Virginia | 54009 | 3 | 0 |
160133 | 160133 | 2020-05-19 | Brooke | West Virginia | 54009 | 3 | 0 |
163161 | 163161 | 2020-05-20 | Brooke | West Virginia | 54009 | 3 | 0 |
166190 | 166190 | 2020-05-21 | Brooke | West Virginia | 54009 | 3 | 0 |
169226 | 169226 | 2020-05-22 | Brooke | West Virginia | 54009 | 3 | 0 |
172267 | 172267 | 2020-05-23 | Brooke | West Virginia | 54009 | 3 | 0 |
175310 | 175310 | 2020-05-24 | Brooke | West Virginia | 54009 | 3 | 0 |
178355 | 178355 | 2020-05-25 | Brooke | West Virginia | 54009 | 3 | 0 |
181399 | 181399 | 2020-05-26 | Brooke | West Virginia | 54009 | 3 | 0 |
184450 | 184450 | 2020-05-27 | Brooke | West Virginia | 54009 | 4 | 0 |
187507 | 187507 | 2020-05-28 | Brooke | West Virginia | 54009 | 4 | 0 |
190571 | 190571 | 2020-05-29 | Brooke | West Virginia | 54009 | 5 | 0 |
193637 | 193637 | 2020-05-30 | Brooke | West Virginia | 54009 | 5 | 0 |
196707 | 196707 | 2020-05-31 | Brooke | West Virginia | 54009 | 5 | 0 |
199780 | 199780 | 2020-06-01 | Brooke | West Virginia | 54009 | 5 | 0 |
202856 | 202856 | 2020-06-02 | Brooke | West Virginia | 54009 | 5 | 0 |
205935 | 205935 | 2020-06-03 | Brooke | West Virginia | 54009 | 5 | 0 |
209017 | 209017 | 2020-06-04 | Brooke | West Virginia | 54009 | 5 | 0 |
212102 | 212102 | 2020-06-05 | Brooke | West Virginia | 54009 | 5 | 0 |
215189 | 215189 | 2020-06-06 | Brooke | West Virginia | 54009 | 5 | 0 |
218279 | 218279 | 2020-06-07 | Brooke | West Virginia | 54009 | 5 | 0 |
221371 | 221371 | 2020-06-08 | Brooke | West Virginia | 54009 | 5 | 0 |
224467 | 224467 | 2020-06-09 | Brooke | West Virginia | 54009 | 5 | 0 |
227567 | 227567 | 2020-06-10 | Brooke | West Virginia | 54009 | 5 | 0 |
230671 | 230671 | 2020-06-11 | Brooke | West Virginia | 54009 | 5 | 0 |
233776 | 233776 | 2020-06-12 | Brooke | West Virginia | 54009 | 5 | 0 |
236883 | 236883 | 2020-06-13 | Brooke | West Virginia | 54009 | 5 | 0 |
239991 | 239991 | 2020-06-14 | Brooke | West Virginia | 54009 | 5 | 0 |
243102 | 243102 | 2020-06-15 | Brooke | West Virginia | 54009 | 6 | 0 |
246215 | 246215 | 2020-06-16 | Brooke | West Virginia | 54009 | 6 | 0 |
249327 | 249327 | 2020-06-17 | Brooke | West Virginia | 54009 | 6 | 0 |
252442 | 252442 | 2020-06-18 | Brooke | West Virginia | 54009 | 6 | 0 |
255561 | 255561 | 2020-06-19 | Brooke | West Virginia | 54009 | 6 | 0 |
258688 | 258688 | 2020-06-20 | Brooke | West Virginia | 54009 | 6 | 0 |
261815 | 261815 | 2020-06-21 | Brooke | West Virginia | 54009 | 6 | 0 |
264944 | 264944 | 2020-06-22 | Brooke | West Virginia | 54009 | 7 | 0 |
268073 | 268073 | 2020-06-23 | Brooke | West Virginia | 54009 | 7 | 0 |
271207 | 271207 | 2020-06-24 | Brooke | West Virginia | 54009 | 11 | 0 |
274347 | 274347 | 2020-06-25 | Brooke | West Virginia | 54009 | 9 | 0 |
277495 | 277495 | 2020-06-26 | Brooke | West Virginia | 54009 | 9 | 0 |
280643 | 280643 | 2020-06-27 | Brooke | West Virginia | 54009 | 9 | 0 |
283789 | 283789 | 2020-06-28 | Brooke | West Virginia | 54009 | 9 | 0 |
286935 | 286935 | 2020-06-29 | Brooke | West Virginia | 54009 | 9 | 0 |
290085 | 290085 | 2020-06-30 | Brooke | West Virginia | 54009 | 9 | 0 |
293238 | 293238 | 2020-07-01 | Brooke | West Virginia | 54009 | 9 | 0 |
296393 | 296393 | 2020-07-02 | Brooke | West Virginia | 54009 | 9 | 0 |
299555 | 299555 | 2020-07-03 | Brooke | West Virginia | 54009 | 9 | 0 |
302719 | 302719 | 2020-07-04 | Brooke | West Virginia | 54009 | 10 | 0 |
305883 | 305883 | 2020-07-05 | Brooke | West Virginia | 54009 | 10 | 0 |
309051 | 309051 | 2020-07-06 | Brooke | West Virginia | 54009 | 15 | 0 |
312220 | 312220 | 2020-07-07 | Brooke | West Virginia | 54009 | 15 | 0 |
315395 | 315395 | 2020-07-08 | Brooke | West Virginia | 54009 | 15 | 0 |
318568 | 318568 | 2020-07-09 | Brooke | West Virginia | 54009 | 19 | 0 |
321747 | 321747 | 2020-07-10 | Brooke | West Virginia | 54009 | 25 | 0 |
324928 | 324928 | 2020-07-11 | Brooke | West Virginia | 54009 | 24 | 0 |
328114 | 328114 | 2020-07-12 | Brooke | West Virginia | 54009 | 27 | 0 |
331300 | 331300 | 2020-07-13 | Brooke | West Virginia | 54009 | 28 | 0 |
334493 | 334493 | 2020-07-14 | Brooke | West Virginia | 54009 | 30 | 0 |
337688 | 337688 | 2020-07-15 | Brooke | West Virginia | 54009 | 33 | 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);