ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Craig" and state = "Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
40378 | 40378 | 2020-04-07 | Craig | Virginia | 51045 | 2 | 0 |
42947 | 42947 | 2020-04-08 | Craig | Virginia | 51045 | 2 | 0 |
45541 | 45541 | 2020-04-09 | Craig | Virginia | 51045 | 2 | 0 |
48166 | 48166 | 2020-04-10 | Craig | Virginia | 51045 | 2 | 0 |
50824 | 50824 | 2020-04-11 | Craig | Virginia | 51045 | 2 | 0 |
53499 | 53499 | 2020-04-12 | Craig | Virginia | 51045 | 2 | 0 |
56188 | 56188 | 2020-04-13 | Craig | Virginia | 51045 | 2 | 0 |
58894 | 58894 | 2020-04-14 | Craig | Virginia | 51045 | 2 | 0 |
61613 | 61613 | 2020-04-15 | Craig | Virginia | 51045 | 2 | 0 |
64345 | 64345 | 2020-04-16 | Craig | Virginia | 51045 | 2 | 0 |
67093 | 67093 | 2020-04-17 | Craig | Virginia | 51045 | 2 | 0 |
69855 | 69855 | 2020-04-18 | Craig | Virginia | 51045 | 2 | 0 |
72625 | 72625 | 2020-04-19 | Craig | Virginia | 51045 | 2 | 0 |
75401 | 75401 | 2020-04-20 | Craig | Virginia | 51045 | 2 | 0 |
78183 | 78183 | 2020-04-21 | Craig | Virginia | 51045 | 2 | 0 |
80975 | 80975 | 2020-04-22 | Craig | Virginia | 51045 | 2 | 0 |
83776 | 83776 | 2020-04-23 | Craig | Virginia | 51045 | 2 | 0 |
86583 | 86583 | 2020-04-24 | Craig | Virginia | 51045 | 2 | 0 |
89398 | 89398 | 2020-04-25 | Craig | Virginia | 51045 | 2 | 0 |
92215 | 92215 | 2020-04-26 | Craig | Virginia | 51045 | 2 | 0 |
95044 | 95044 | 2020-04-27 | Craig | Virginia | 51045 | 2 | 0 |
97886 | 97886 | 2020-04-28 | Craig | Virginia | 51045 | 2 | 0 |
100736 | 100736 | 2020-04-29 | Craig | Virginia | 51045 | 2 | 0 |
103591 | 103591 | 2020-04-30 | Craig | Virginia | 51045 | 3 | 0 |
106455 | 106455 | 2020-05-01 | Craig | Virginia | 51045 | 3 | 0 |
109324 | 109324 | 2020-05-02 | Craig | Virginia | 51045 | 3 | 0 |
112198 | 112198 | 2020-05-03 | Craig | Virginia | 51045 | 3 | 0 |
115081 | 115081 | 2020-05-04 | Craig | Virginia | 51045 | 3 | 0 |
118040 | 118040 | 2020-05-05 | Craig | Virginia | 51045 | 4 | 0 |
121004 | 121004 | 2020-05-06 | Craig | Virginia | 51045 | 4 | 0 |
123985 | 123985 | 2020-05-07 | Craig | Virginia | 51045 | 4 | 0 |
126970 | 126970 | 2020-05-08 | Craig | Virginia | 51045 | 4 | 0 |
129960 | 129960 | 2020-05-09 | Craig | Virginia | 51045 | 4 | 0 |
132950 | 132950 | 2020-05-10 | Craig | Virginia | 51045 | 4 | 0 |
135940 | 135940 | 2020-05-11 | Craig | Virginia | 51045 | 4 | 0 |
138931 | 138931 | 2020-05-12 | Craig | Virginia | 51045 | 4 | 0 |
141927 | 141927 | 2020-05-13 | Craig | Virginia | 51045 | 4 | 0 |
144924 | 144924 | 2020-05-14 | Craig | Virginia | 51045 | 4 | 0 |
147927 | 147927 | 2020-05-15 | Craig | Virginia | 51045 | 4 | 0 |
150936 | 150936 | 2020-05-16 | Craig | Virginia | 51045 | 4 | 0 |
153947 | 153947 | 2020-05-17 | Craig | Virginia | 51045 | 4 | 0 |
156964 | 156964 | 2020-05-18 | Craig | Virginia | 51045 | 4 | 0 |
159988 | 159988 | 2020-05-19 | Craig | Virginia | 51045 | 4 | 0 |
163016 | 163016 | 2020-05-20 | Craig | Virginia | 51045 | 4 | 0 |
166045 | 166045 | 2020-05-21 | Craig | Virginia | 51045 | 5 | 0 |
169081 | 169081 | 2020-05-22 | Craig | Virginia | 51045 | 5 | 0 |
172122 | 172122 | 2020-05-23 | Craig | Virginia | 51045 | 5 | 0 |
175165 | 175165 | 2020-05-24 | Craig | Virginia | 51045 | 5 | 0 |
178210 | 178210 | 2020-05-25 | Craig | Virginia | 51045 | 5 | 0 |
181254 | 181254 | 2020-05-26 | Craig | Virginia | 51045 | 5 | 0 |
184305 | 184305 | 2020-05-27 | Craig | Virginia | 51045 | 5 | 0 |
187362 | 187362 | 2020-05-28 | Craig | Virginia | 51045 | 5 | 0 |
190426 | 190426 | 2020-05-29 | Craig | Virginia | 51045 | 5 | 0 |
193492 | 193492 | 2020-05-30 | Craig | Virginia | 51045 | 5 | 0 |
196562 | 196562 | 2020-05-31 | Craig | Virginia | 51045 | 5 | 0 |
199635 | 199635 | 2020-06-01 | Craig | Virginia | 51045 | 5 | 0 |
202711 | 202711 | 2020-06-02 | Craig | Virginia | 51045 | 5 | 0 |
205790 | 205790 | 2020-06-03 | Craig | Virginia | 51045 | 5 | 0 |
208872 | 208872 | 2020-06-04 | Craig | Virginia | 51045 | 5 | 0 |
211957 | 211957 | 2020-06-05 | Craig | Virginia | 51045 | 5 | 0 |
215044 | 215044 | 2020-06-06 | Craig | Virginia | 51045 | 6 | 0 |
218134 | 218134 | 2020-06-07 | Craig | Virginia | 51045 | 6 | 0 |
221226 | 221226 | 2020-06-08 | Craig | Virginia | 51045 | 6 | 0 |
224322 | 224322 | 2020-06-09 | Craig | Virginia | 51045 | 6 | 0 |
227422 | 227422 | 2020-06-10 | Craig | Virginia | 51045 | 6 | 0 |
230526 | 230526 | 2020-06-11 | Craig | Virginia | 51045 | 6 | 0 |
233631 | 233631 | 2020-06-12 | Craig | Virginia | 51045 | 6 | 0 |
236738 | 236738 | 2020-06-13 | Craig | Virginia | 51045 | 6 | 0 |
239846 | 239846 | 2020-06-14 | Craig | Virginia | 51045 | 6 | 0 |
242957 | 242957 | 2020-06-15 | Craig | Virginia | 51045 | 6 | 0 |
246069 | 246069 | 2020-06-16 | Craig | Virginia | 51045 | 6 | 0 |
249181 | 249181 | 2020-06-17 | Craig | Virginia | 51045 | 6 | 0 |
252296 | 252296 | 2020-06-18 | Craig | Virginia | 51045 | 6 | 0 |
255415 | 255415 | 2020-06-19 | Craig | Virginia | 51045 | 6 | 0 |
258542 | 258542 | 2020-06-20 | Craig | Virginia | 51045 | 6 | 0 |
261669 | 261669 | 2020-06-21 | Craig | Virginia | 51045 | 6 | 0 |
264798 | 264798 | 2020-06-22 | Craig | Virginia | 51045 | 6 | 0 |
267927 | 267927 | 2020-06-23 | Craig | Virginia | 51045 | 6 | 0 |
271061 | 271061 | 2020-06-24 | Craig | Virginia | 51045 | 6 | 0 |
274201 | 274201 | 2020-06-25 | Craig | Virginia | 51045 | 6 | 0 |
277349 | 277349 | 2020-06-26 | Craig | Virginia | 51045 | 6 | 0 |
280497 | 280497 | 2020-06-27 | Craig | Virginia | 51045 | 6 | 0 |
283643 | 283643 | 2020-06-28 | Craig | Virginia | 51045 | 6 | 0 |
286789 | 286789 | 2020-06-29 | Craig | Virginia | 51045 | 7 | 0 |
289939 | 289939 | 2020-06-30 | Craig | Virginia | 51045 | 7 | 0 |
293092 | 293092 | 2020-07-01 | Craig | Virginia | 51045 | 7 | 0 |
296247 | 296247 | 2020-07-02 | Craig | Virginia | 51045 | 7 | 0 |
299409 | 299409 | 2020-07-03 | Craig | Virginia | 51045 | 7 | 0 |
302573 | 302573 | 2020-07-04 | Craig | Virginia | 51045 | 8 | 0 |
305737 | 305737 | 2020-07-05 | Craig | Virginia | 51045 | 8 | 0 |
308905 | 308905 | 2020-07-06 | Craig | Virginia | 51045 | 8 | 0 |
312074 | 312074 | 2020-07-07 | Craig | Virginia | 51045 | 9 | 0 |
315249 | 315249 | 2020-07-08 | Craig | Virginia | 51045 | 9 | 0 |
318422 | 318422 | 2020-07-09 | Craig | Virginia | 51045 | 9 | 0 |
321601 | 321601 | 2020-07-10 | Craig | Virginia | 51045 | 9 | 0 |
324782 | 324782 | 2020-07-11 | Craig | Virginia | 51045 | 9 | 0 |
327967 | 327967 | 2020-07-12 | Craig | Virginia | 51045 | 9 | 0 |
331153 | 331153 | 2020-07-13 | Craig | Virginia | 51045 | 9 | 0 |
334346 | 334346 | 2020-07-14 | Craig | Virginia | 51045 | 9 | 0 |
337541 | 337541 | 2020-07-15 | Craig | Virginia | 51045 | 9 | 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);