ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Russell" and state = "Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
37913 | 37913 | 2020-04-06 | Russell | Virginia | 51167 | 1 | 0 |
40448 | 40448 | 2020-04-07 | Russell | Virginia | 51167 | 1 | 0 |
43017 | 43017 | 2020-04-08 | Russell | Virginia | 51167 | 1 | 0 |
45613 | 45613 | 2020-04-09 | Russell | Virginia | 51167 | 1 | 0 |
48239 | 48239 | 2020-04-10 | Russell | Virginia | 51167 | 1 | 0 |
50897 | 50897 | 2020-04-11 | Russell | Virginia | 51167 | 1 | 0 |
53572 | 53572 | 2020-04-12 | Russell | Virginia | 51167 | 1 | 0 |
56262 | 56262 | 2020-04-13 | Russell | Virginia | 51167 | 1 | 0 |
58968 | 58968 | 2020-04-14 | Russell | Virginia | 51167 | 2 | 0 |
61687 | 61687 | 2020-04-15 | Russell | Virginia | 51167 | 2 | 0 |
64420 | 64420 | 2020-04-16 | Russell | Virginia | 51167 | 2 | 0 |
67168 | 67168 | 2020-04-17 | Russell | Virginia | 51167 | 2 | 0 |
69930 | 69930 | 2020-04-18 | Russell | Virginia | 51167 | 2 | 0 |
72700 | 72700 | 2020-04-19 | Russell | Virginia | 51167 | 2 | 0 |
75476 | 75476 | 2020-04-20 | Russell | Virginia | 51167 | 2 | 0 |
78260 | 78260 | 2020-04-21 | Russell | Virginia | 51167 | 2 | 0 |
81053 | 81053 | 2020-04-22 | Russell | Virginia | 51167 | 2 | 0 |
83854 | 83854 | 2020-04-23 | Russell | Virginia | 51167 | 2 | 0 |
86661 | 86661 | 2020-04-24 | Russell | Virginia | 51167 | 2 | 0 |
89476 | 89476 | 2020-04-25 | Russell | Virginia | 51167 | 3 | 0 |
92293 | 92293 | 2020-04-26 | Russell | Virginia | 51167 | 3 | 0 |
95122 | 95122 | 2020-04-27 | Russell | Virginia | 51167 | 3 | 0 |
97966 | 97966 | 2020-04-28 | Russell | Virginia | 51167 | 3 | 0 |
100816 | 100816 | 2020-04-29 | Russell | Virginia | 51167 | 3 | 0 |
103671 | 103671 | 2020-04-30 | Russell | Virginia | 51167 | 3 | 0 |
106535 | 106535 | 2020-05-01 | Russell | Virginia | 51167 | 4 | 0 |
109404 | 109404 | 2020-05-02 | Russell | Virginia | 51167 | 5 | 0 |
112278 | 112278 | 2020-05-03 | Russell | Virginia | 51167 | 5 | 0 |
115161 | 115161 | 2020-05-04 | Russell | Virginia | 51167 | 5 | 0 |
118120 | 118120 | 2020-05-05 | Russell | Virginia | 51167 | 5 | 0 |
121084 | 121084 | 2020-05-06 | Russell | Virginia | 51167 | 5 | 0 |
124065 | 124065 | 2020-05-07 | Russell | Virginia | 51167 | 6 | 0 |
127050 | 127050 | 2020-05-08 | Russell | Virginia | 51167 | 6 | 0 |
130040 | 130040 | 2020-05-09 | Russell | Virginia | 51167 | 6 | 0 |
133030 | 133030 | 2020-05-10 | Russell | Virginia | 51167 | 6 | 0 |
136020 | 136020 | 2020-05-11 | Russell | Virginia | 51167 | 6 | 0 |
139011 | 139011 | 2020-05-12 | Russell | Virginia | 51167 | 6 | 0 |
142007 | 142007 | 2020-05-13 | Russell | Virginia | 51167 | 6 | 0 |
145004 | 145004 | 2020-05-14 | Russell | Virginia | 51167 | 6 | 0 |
148007 | 148007 | 2020-05-15 | Russell | Virginia | 51167 | 6 | 0 |
151016 | 151016 | 2020-05-16 | Russell | Virginia | 51167 | 8 | 0 |
154027 | 154027 | 2020-05-17 | Russell | Virginia | 51167 | 8 | 0 |
157044 | 157044 | 2020-05-18 | Russell | Virginia | 51167 | 8 | 0 |
160068 | 160068 | 2020-05-19 | Russell | Virginia | 51167 | 8 | 0 |
163096 | 163096 | 2020-05-20 | Russell | Virginia | 51167 | 8 | 0 |
166125 | 166125 | 2020-05-21 | Russell | Virginia | 51167 | 8 | 0 |
169161 | 169161 | 2020-05-22 | Russell | Virginia | 51167 | 8 | 0 |
172202 | 172202 | 2020-05-23 | Russell | Virginia | 51167 | 8 | 0 |
175245 | 175245 | 2020-05-24 | Russell | Virginia | 51167 | 8 | 0 |
178290 | 178290 | 2020-05-25 | Russell | Virginia | 51167 | 8 | 0 |
181334 | 181334 | 2020-05-26 | Russell | Virginia | 51167 | 8 | 0 |
184385 | 184385 | 2020-05-27 | Russell | Virginia | 51167 | 8 | 0 |
187442 | 187442 | 2020-05-28 | Russell | Virginia | 51167 | 8 | 0 |
190506 | 190506 | 2020-05-29 | Russell | Virginia | 51167 | 8 | 0 |
193572 | 193572 | 2020-05-30 | Russell | Virginia | 51167 | 8 | 0 |
196642 | 196642 | 2020-05-31 | Russell | Virginia | 51167 | 8 | 0 |
199715 | 199715 | 2020-06-01 | Russell | Virginia | 51167 | 8 | 0 |
202791 | 202791 | 2020-06-02 | Russell | Virginia | 51167 | 8 | 0 |
205870 | 205870 | 2020-06-03 | Russell | Virginia | 51167 | 8 | 0 |
208952 | 208952 | 2020-06-04 | Russell | Virginia | 51167 | 8 | 0 |
212037 | 212037 | 2020-06-05 | Russell | Virginia | 51167 | 8 | 0 |
215124 | 215124 | 2020-06-06 | Russell | Virginia | 51167 | 8 | 0 |
218214 | 218214 | 2020-06-07 | Russell | Virginia | 51167 | 8 | 0 |
221306 | 221306 | 2020-06-08 | Russell | Virginia | 51167 | 8 | 0 |
224402 | 224402 | 2020-06-09 | Russell | Virginia | 51167 | 8 | 0 |
227502 | 227502 | 2020-06-10 | Russell | Virginia | 51167 | 8 | 0 |
230606 | 230606 | 2020-06-11 | Russell | Virginia | 51167 | 8 | 0 |
233711 | 233711 | 2020-06-12 | Russell | Virginia | 51167 | 8 | 0 |
236818 | 236818 | 2020-06-13 | Russell | Virginia | 51167 | 8 | 0 |
239926 | 239926 | 2020-06-14 | Russell | Virginia | 51167 | 8 | 0 |
243037 | 243037 | 2020-06-15 | Russell | Virginia | 51167 | 8 | 0 |
246150 | 246150 | 2020-06-16 | Russell | Virginia | 51167 | 8 | 0 |
249262 | 249262 | 2020-06-17 | Russell | Virginia | 51167 | 9 | 0 |
252377 | 252377 | 2020-06-18 | Russell | Virginia | 51167 | 9 | 0 |
255496 | 255496 | 2020-06-19 | Russell | Virginia | 51167 | 9 | 0 |
258623 | 258623 | 2020-06-20 | Russell | Virginia | 51167 | 9 | 0 |
261750 | 261750 | 2020-06-21 | Russell | Virginia | 51167 | 9 | 0 |
264879 | 264879 | 2020-06-22 | Russell | Virginia | 51167 | 9 | 0 |
268008 | 268008 | 2020-06-23 | Russell | Virginia | 51167 | 9 | 0 |
271142 | 271142 | 2020-06-24 | Russell | Virginia | 51167 | 9 | 0 |
274282 | 274282 | 2020-06-25 | Russell | Virginia | 51167 | 9 | 0 |
277430 | 277430 | 2020-06-26 | Russell | Virginia | 51167 | 9 | 0 |
280578 | 280578 | 2020-06-27 | Russell | Virginia | 51167 | 9 | 0 |
283724 | 283724 | 2020-06-28 | Russell | Virginia | 51167 | 9 | 0 |
286870 | 286870 | 2020-06-29 | Russell | Virginia | 51167 | 11 | 0 |
290020 | 290020 | 2020-06-30 | Russell | Virginia | 51167 | 12 | 0 |
293173 | 293173 | 2020-07-01 | Russell | Virginia | 51167 | 12 | 0 |
296328 | 296328 | 2020-07-02 | Russell | Virginia | 51167 | 13 | 0 |
299490 | 299490 | 2020-07-03 | Russell | Virginia | 51167 | 13 | 0 |
302654 | 302654 | 2020-07-04 | Russell | Virginia | 51167 | 14 | 0 |
305818 | 305818 | 2020-07-05 | Russell | Virginia | 51167 | 14 | 0 |
308986 | 308986 | 2020-07-06 | Russell | Virginia | 51167 | 14 | 0 |
312155 | 312155 | 2020-07-07 | Russell | Virginia | 51167 | 14 | 0 |
315330 | 315330 | 2020-07-08 | Russell | Virginia | 51167 | 15 | 0 |
318503 | 318503 | 2020-07-09 | Russell | Virginia | 51167 | 15 | 0 |
321682 | 321682 | 2020-07-10 | Russell | Virginia | 51167 | 18 | 0 |
324863 | 324863 | 2020-07-11 | Russell | Virginia | 51167 | 21 | 0 |
328048 | 328048 | 2020-07-12 | Russell | Virginia | 51167 | 23 | 0 |
331234 | 331234 | 2020-07-13 | Russell | Virginia | 51167 | 23 | 0 |
334427 | 334427 | 2020-07-14 | Russell | Virginia | 51167 | 26 | 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);