ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 54053 and state = "West Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
13967 | 13967 | 2020-03-26 | Mason | West Virginia | 54053 | 1 | 0 |
15738 | 15738 | 2020-03-27 | Mason | West Virginia | 54053 | 3 | 0 |
17618 | 17618 | 2020-03-28 | Mason | West Virginia | 54053 | 3 | 0 |
19584 | 19584 | 2020-03-29 | Mason | West Virginia | 54053 | 3 | 0 |
21651 | 21651 | 2020-03-30 | Mason | West Virginia | 54053 | 3 | 0 |
23801 | 23801 | 2020-03-31 | Mason | West Virginia | 54053 | 3 | 0 |
26019 | 26019 | 2020-04-01 | Mason | West Virginia | 54053 | 3 | 0 |
28311 | 28311 | 2020-04-02 | Mason | West Virginia | 54053 | 3 | 0 |
30664 | 30664 | 2020-04-03 | Mason | West Virginia | 54053 | 3 | 0 |
33065 | 33065 | 2020-04-04 | Mason | West Virginia | 54053 | 4 | 0 |
35503 | 35503 | 2020-04-05 | Mason | West Virginia | 54053 | 4 | 0 |
37988 | 37988 | 2020-04-06 | Mason | West Virginia | 54053 | 4 | 0 |
40525 | 40525 | 2020-04-07 | Mason | West Virginia | 54053 | 6 | 0 |
43097 | 43097 | 2020-04-08 | Mason | West Virginia | 54053 | 6 | 0 |
45693 | 45693 | 2020-04-09 | Mason | West Virginia | 54053 | 7 | 0 |
48321 | 48321 | 2020-04-10 | Mason | West Virginia | 54053 | 6 | 0 |
50979 | 50979 | 2020-04-11 | Mason | West Virginia | 54053 | 8 | 0 |
53655 | 53655 | 2020-04-12 | Mason | West Virginia | 54053 | 8 | 0 |
56345 | 56345 | 2020-04-13 | Mason | West Virginia | 54053 | 10 | 0 |
59052 | 59052 | 2020-04-14 | Mason | West Virginia | 54053 | 10 | 0 |
61771 | 61771 | 2020-04-15 | Mason | West Virginia | 54053 | 10 | 0 |
64504 | 64504 | 2020-04-16 | Mason | West Virginia | 54053 | 10 | 0 |
67252 | 67252 | 2020-04-17 | Mason | West Virginia | 54053 | 10 | 0 |
70014 | 70014 | 2020-04-18 | Mason | West Virginia | 54053 | 11 | 0 |
72783 | 72783 | 2020-04-19 | Mason | West Virginia | 54053 | 11 | 0 |
75559 | 75559 | 2020-04-20 | Mason | West Virginia | 54053 | 10 | 0 |
78342 | 78342 | 2020-04-21 | Mason | West Virginia | 54053 | 10 | 0 |
81135 | 81135 | 2020-04-22 | Mason | West Virginia | 54053 | 10 | 0 |
83936 | 83936 | 2020-04-23 | Mason | West Virginia | 54053 | 11 | 0 |
86743 | 86743 | 2020-04-24 | Mason | West Virginia | 54053 | 11 | 0 |
89559 | 89559 | 2020-04-25 | Mason | West Virginia | 54053 | 11 | 0 |
92377 | 92377 | 2020-04-26 | Mason | West Virginia | 54053 | 11 | 0 |
95206 | 95206 | 2020-04-27 | Mason | West Virginia | 54053 | 12 | 0 |
98051 | 98051 | 2020-04-28 | Mason | West Virginia | 54053 | 12 | 0 |
100901 | 100901 | 2020-04-29 | Mason | West Virginia | 54053 | 12 | 0 |
103756 | 103756 | 2020-04-30 | Mason | West Virginia | 54053 | 12 | 0 |
106620 | 106620 | 2020-05-01 | Mason | West Virginia | 54053 | 12 | 0 |
109489 | 109489 | 2020-05-02 | Mason | West Virginia | 54053 | 12 | 0 |
112363 | 112363 | 2020-05-03 | Mason | West Virginia | 54053 | 12 | 0 |
115246 | 115246 | 2020-05-04 | Mason | West Virginia | 54053 | 12 | 0 |
118205 | 118205 | 2020-05-05 | Mason | West Virginia | 54053 | 12 | 0 |
121170 | 121170 | 2020-05-06 | Mason | West Virginia | 54053 | 12 | 0 |
124150 | 124150 | 2020-05-07 | Mason | West Virginia | 54053 | 13 | 0 |
127135 | 127135 | 2020-05-08 | Mason | West Virginia | 54053 | 13 | 0 |
130125 | 130125 | 2020-05-09 | Mason | West Virginia | 54053 | 13 | 0 |
133115 | 133115 | 2020-05-10 | Mason | West Virginia | 54053 | 13 | 0 |
136105 | 136105 | 2020-05-11 | Mason | West Virginia | 54053 | 13 | 0 |
139096 | 139096 | 2020-05-12 | Mason | West Virginia | 54053 | 14 | 0 |
142092 | 142092 | 2020-05-13 | Mason | West Virginia | 54053 | 14 | 0 |
145089 | 145089 | 2020-05-14 | Mason | West Virginia | 54053 | 14 | 0 |
148092 | 148092 | 2020-05-15 | Mason | West Virginia | 54053 | 15 | 0 |
151101 | 151101 | 2020-05-16 | Mason | West Virginia | 54053 | 15 | 0 |
154112 | 154112 | 2020-05-17 | Mason | West Virginia | 54053 | 15 | 0 |
157129 | 157129 | 2020-05-18 | Mason | West Virginia | 54053 | 15 | 0 |
160153 | 160153 | 2020-05-19 | Mason | West Virginia | 54053 | 15 | 0 |
163181 | 163181 | 2020-05-20 | Mason | West Virginia | 54053 | 15 | 0 |
166210 | 166210 | 2020-05-21 | Mason | West Virginia | 54053 | 15 | 0 |
169246 | 169246 | 2020-05-22 | Mason | West Virginia | 54053 | 15 | 0 |
172287 | 172287 | 2020-05-23 | Mason | West Virginia | 54053 | 16 | 0 |
175330 | 175330 | 2020-05-24 | Mason | West Virginia | 54053 | 16 | 0 |
178375 | 178375 | 2020-05-25 | Mason | West Virginia | 54053 | 16 | 0 |
181419 | 181419 | 2020-05-26 | Mason | West Virginia | 54053 | 15 | 0 |
184470 | 184470 | 2020-05-27 | Mason | West Virginia | 54053 | 15 | 0 |
187527 | 187527 | 2020-05-28 | Mason | West Virginia | 54053 | 15 | 0 |
190591 | 190591 | 2020-05-29 | Mason | West Virginia | 54053 | 15 | 0 |
193657 | 193657 | 2020-05-30 | Mason | West Virginia | 54053 | 15 | 0 |
196727 | 196727 | 2020-05-31 | Mason | West Virginia | 54053 | 15 | 0 |
199800 | 199800 | 2020-06-01 | Mason | West Virginia | 54053 | 15 | 0 |
202876 | 202876 | 2020-06-02 | Mason | West Virginia | 54053 | 15 | 0 |
205955 | 205955 | 2020-06-03 | Mason | West Virginia | 54053 | 15 | 0 |
209037 | 209037 | 2020-06-04 | Mason | West Virginia | 54053 | 15 | 0 |
212122 | 212122 | 2020-06-05 | Mason | West Virginia | 54053 | 15 | 0 |
215209 | 215209 | 2020-06-06 | Mason | West Virginia | 54053 | 15 | 0 |
218299 | 218299 | 2020-06-07 | Mason | West Virginia | 54053 | 15 | 0 |
221391 | 221391 | 2020-06-08 | Mason | West Virginia | 54053 | 15 | 0 |
224487 | 224487 | 2020-06-09 | Mason | West Virginia | 54053 | 15 | 0 |
227587 | 227587 | 2020-06-10 | Mason | West Virginia | 54053 | 15 | 0 |
230691 | 230691 | 2020-06-11 | Mason | West Virginia | 54053 | 15 | 0 |
233796 | 233796 | 2020-06-12 | Mason | West Virginia | 54053 | 15 | 0 |
236903 | 236903 | 2020-06-13 | Mason | West Virginia | 54053 | 15 | 0 |
240011 | 240011 | 2020-06-14 | Mason | West Virginia | 54053 | 15 | 0 |
243122 | 243122 | 2020-06-15 | Mason | West Virginia | 54053 | 15 | 0 |
246235 | 246235 | 2020-06-16 | Mason | West Virginia | 54053 | 15 | 0 |
249347 | 249347 | 2020-06-17 | Mason | West Virginia | 54053 | 15 | 0 |
252462 | 252462 | 2020-06-18 | Mason | West Virginia | 54053 | 15 | 0 |
255581 | 255581 | 2020-06-19 | Mason | West Virginia | 54053 | 15 | 0 |
258708 | 258708 | 2020-06-20 | Mason | West Virginia | 54053 | 15 | 0 |
261835 | 261835 | 2020-06-21 | Mason | West Virginia | 54053 | 15 | 0 |
264964 | 264964 | 2020-06-22 | Mason | West Virginia | 54053 | 16 | 0 |
268093 | 268093 | 2020-06-23 | Mason | West Virginia | 54053 | 16 | 0 |
271227 | 271227 | 2020-06-24 | Mason | West Virginia | 54053 | 16 | 0 |
274367 | 274367 | 2020-06-25 | Mason | West Virginia | 54053 | 16 | 0 |
277515 | 277515 | 2020-06-26 | Mason | West Virginia | 54053 | 16 | 0 |
280663 | 280663 | 2020-06-27 | Mason | West Virginia | 54053 | 16 | 0 |
283809 | 283809 | 2020-06-28 | Mason | West Virginia | 54053 | 16 | 0 |
286955 | 286955 | 2020-06-29 | Mason | West Virginia | 54053 | 17 | 0 |
290105 | 290105 | 2020-06-30 | Mason | West Virginia | 54053 | 18 | 0 |
293258 | 293258 | 2020-07-01 | Mason | West Virginia | 54053 | 19 | 0 |
296413 | 296413 | 2020-07-02 | Mason | West Virginia | 54053 | 19 | 0 |
299575 | 299575 | 2020-07-03 | Mason | West Virginia | 54053 | 19 | 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);