ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 51590 and state = "Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9375 | 9375 | 2020-03-23 | Danville city | Virginia | 51590 | 1 | 0 |
10722 | 10722 | 2020-03-24 | Danville city | Virginia | 51590 | 1 | 0 |
12234 | 12234 | 2020-03-25 | Danville city | Virginia | 51590 | 2 | 0 |
13871 | 13871 | 2020-03-26 | Danville city | Virginia | 51590 | 2 | 0 |
15638 | 15638 | 2020-03-27 | Danville city | Virginia | 51590 | 4 | 0 |
17512 | 17512 | 2020-03-28 | Danville city | Virginia | 51590 | 4 | 0 |
19472 | 19472 | 2020-03-29 | Danville city | Virginia | 51590 | 4 | 0 |
21535 | 21535 | 2020-03-30 | Danville city | Virginia | 51590 | 4 | 0 |
23679 | 23679 | 2020-03-31 | Danville city | Virginia | 51590 | 4 | 0 |
25895 | 25895 | 2020-04-01 | Danville city | Virginia | 51590 | 4 | 0 |
28185 | 28185 | 2020-04-02 | Danville city | Virginia | 51590 | 7 | 0 |
30530 | 30530 | 2020-04-03 | Danville city | Virginia | 51590 | 9 | 0 |
32929 | 32929 | 2020-04-04 | Danville city | Virginia | 51590 | 12 | 0 |
35367 | 35367 | 2020-04-05 | Danville city | Virginia | 51590 | 12 | 0 |
37849 | 37849 | 2020-04-06 | Danville city | Virginia | 51590 | 13 | 0 |
40381 | 40381 | 2020-04-07 | Danville city | Virginia | 51590 | 15 | 0 |
42950 | 42950 | 2020-04-08 | Danville city | Virginia | 51590 | 15 | 0 |
45544 | 45544 | 2020-04-09 | Danville city | Virginia | 51590 | 19 | 0 |
48169 | 48169 | 2020-04-10 | Danville city | Virginia | 51590 | 20 | 0 |
50827 | 50827 | 2020-04-11 | Danville city | Virginia | 51590 | 20 | 0 |
53502 | 53502 | 2020-04-12 | Danville city | Virginia | 51590 | 20 | 0 |
56191 | 56191 | 2020-04-13 | Danville city | Virginia | 51590 | 21 | 0 |
58897 | 58897 | 2020-04-14 | Danville city | Virginia | 51590 | 22 | 0 |
61616 | 61616 | 2020-04-15 | Danville city | Virginia | 51590 | 22 | 0 |
64348 | 64348 | 2020-04-16 | Danville city | Virginia | 51590 | 22 | 0 |
67096 | 67096 | 2020-04-17 | Danville city | Virginia | 51590 | 22 | 0 |
69858 | 69858 | 2020-04-18 | Danville city | Virginia | 51590 | 24 | 0 |
72628 | 72628 | 2020-04-19 | Danville city | Virginia | 51590 | 27 | 0 |
75404 | 75404 | 2020-04-20 | Danville city | Virginia | 51590 | 28 | 0 |
78186 | 78186 | 2020-04-21 | Danville city | Virginia | 51590 | 29 | 1 |
80978 | 80978 | 2020-04-22 | Danville city | Virginia | 51590 | 29 | 1 |
83779 | 83779 | 2020-04-23 | Danville city | Virginia | 51590 | 31 | 1 |
86586 | 86586 | 2020-04-24 | Danville city | Virginia | 51590 | 31 | 1 |
89401 | 89401 | 2020-04-25 | Danville city | Virginia | 51590 | 32 | 1 |
92218 | 92218 | 2020-04-26 | Danville city | Virginia | 51590 | 33 | 1 |
95047 | 95047 | 2020-04-27 | Danville city | Virginia | 51590 | 33 | 1 |
97889 | 97889 | 2020-04-28 | Danville city | Virginia | 51590 | 33 | 1 |
100739 | 100739 | 2020-04-29 | Danville city | Virginia | 51590 | 34 | 1 |
103594 | 103594 | 2020-04-30 | Danville city | Virginia | 51590 | 35 | 1 |
106458 | 106458 | 2020-05-01 | Danville city | Virginia | 51590 | 35 | 1 |
109327 | 109327 | 2020-05-02 | Danville city | Virginia | 51590 | 37 | 1 |
112201 | 112201 | 2020-05-03 | Danville city | Virginia | 51590 | 37 | 1 |
115084 | 115084 | 2020-05-04 | Danville city | Virginia | 51590 | 37 | 1 |
118043 | 118043 | 2020-05-05 | Danville city | Virginia | 51590 | 37 | 1 |
121007 | 121007 | 2020-05-06 | Danville city | Virginia | 51590 | 37 | 1 |
123988 | 123988 | 2020-05-07 | Danville city | Virginia | 51590 | 38 | 1 |
126973 | 126973 | 2020-05-08 | Danville city | Virginia | 51590 | 39 | 1 |
129963 | 129963 | 2020-05-09 | Danville city | Virginia | 51590 | 39 | 1 |
132953 | 132953 | 2020-05-10 | Danville city | Virginia | 51590 | 38 | 1 |
135943 | 135943 | 2020-05-11 | Danville city | Virginia | 51590 | 39 | 1 |
138934 | 138934 | 2020-05-12 | Danville city | Virginia | 51590 | 41 | 1 |
141930 | 141930 | 2020-05-13 | Danville city | Virginia | 51590 | 41 | 1 |
144927 | 144927 | 2020-05-14 | Danville city | Virginia | 51590 | 43 | 1 |
147930 | 147930 | 2020-05-15 | Danville city | Virginia | 51590 | 43 | 1 |
150939 | 150939 | 2020-05-16 | Danville city | Virginia | 51590 | 44 | 1 |
153950 | 153950 | 2020-05-17 | Danville city | Virginia | 51590 | 44 | 1 |
156967 | 156967 | 2020-05-18 | Danville city | Virginia | 51590 | 44 | 1 |
159991 | 159991 | 2020-05-19 | Danville city | Virginia | 51590 | 44 | 1 |
163019 | 163019 | 2020-05-20 | Danville city | Virginia | 51590 | 45 | 1 |
166048 | 166048 | 2020-05-21 | Danville city | Virginia | 51590 | 45 | 1 |
169084 | 169084 | 2020-05-22 | Danville city | Virginia | 51590 | 46 | 2 |
172125 | 172125 | 2020-05-23 | Danville city | Virginia | 51590 | 46 | 2 |
175168 | 175168 | 2020-05-24 | Danville city | Virginia | 51590 | 46 | 2 |
178213 | 178213 | 2020-05-25 | Danville city | Virginia | 51590 | 48 | 2 |
181257 | 181257 | 2020-05-26 | Danville city | Virginia | 51590 | 48 | 2 |
184308 | 184308 | 2020-05-27 | Danville city | Virginia | 51590 | 48 | 2 |
187365 | 187365 | 2020-05-28 | Danville city | Virginia | 51590 | 50 | 2 |
190429 | 190429 | 2020-05-29 | Danville city | Virginia | 51590 | 51 | 2 |
193495 | 193495 | 2020-05-30 | Danville city | Virginia | 51590 | 51 | 2 |
196565 | 196565 | 2020-05-31 | Danville city | Virginia | 51590 | 55 | 2 |
199638 | 199638 | 2020-06-01 | Danville city | Virginia | 51590 | 56 | 2 |
202714 | 202714 | 2020-06-02 | Danville city | Virginia | 51590 | 57 | 2 |
205793 | 205793 | 2020-06-03 | Danville city | Virginia | 51590 | 58 | 2 |
208875 | 208875 | 2020-06-04 | Danville city | Virginia | 51590 | 58 | 2 |
211960 | 211960 | 2020-06-05 | Danville city | Virginia | 51590 | 60 | 2 |
215047 | 215047 | 2020-06-06 | Danville city | Virginia | 51590 | 60 | 2 |
218137 | 218137 | 2020-06-07 | Danville city | Virginia | 51590 | 60 | 2 |
221229 | 221229 | 2020-06-08 | Danville city | Virginia | 51590 | 60 | 2 |
224325 | 224325 | 2020-06-09 | Danville city | Virginia | 51590 | 60 | 2 |
227425 | 227425 | 2020-06-10 | Danville city | Virginia | 51590 | 61 | 2 |
230529 | 230529 | 2020-06-11 | Danville city | Virginia | 51590 | 61 | 2 |
233634 | 233634 | 2020-06-12 | Danville city | Virginia | 51590 | 63 | 2 |
236741 | 236741 | 2020-06-13 | Danville city | Virginia | 51590 | 63 | 2 |
239849 | 239849 | 2020-06-14 | Danville city | Virginia | 51590 | 65 | 2 |
242960 | 242960 | 2020-06-15 | Danville city | Virginia | 51590 | 66 | 2 |
246072 | 246072 | 2020-06-16 | Danville city | Virginia | 51590 | 66 | 2 |
249184 | 249184 | 2020-06-17 | Danville city | Virginia | 51590 | 66 | 2 |
252299 | 252299 | 2020-06-18 | Danville city | Virginia | 51590 | 68 | 2 |
255418 | 255418 | 2020-06-19 | Danville city | Virginia | 51590 | 68 | 2 |
258545 | 258545 | 2020-06-20 | Danville city | Virginia | 51590 | 72 | 2 |
261672 | 261672 | 2020-06-21 | Danville city | Virginia | 51590 | 73 | 2 |
264801 | 264801 | 2020-06-22 | Danville city | Virginia | 51590 | 73 | 2 |
267930 | 267930 | 2020-06-23 | Danville city | Virginia | 51590 | 72 | 2 |
271064 | 271064 | 2020-06-24 | Danville city | Virginia | 51590 | 73 | 2 |
274204 | 274204 | 2020-06-25 | Danville city | Virginia | 51590 | 73 | 2 |
277352 | 277352 | 2020-06-26 | Danville city | Virginia | 51590 | 77 | 2 |
280500 | 280500 | 2020-06-27 | Danville city | Virginia | 51590 | 79 | 2 |
283646 | 283646 | 2020-06-28 | Danville city | Virginia | 51590 | 80 | 2 |
286792 | 286792 | 2020-06-29 | Danville city | Virginia | 51590 | 82 | 2 |
289942 | 289942 | 2020-06-30 | Danville city | Virginia | 51590 | 86 | 2 |
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);