ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 51171 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 |
---|---|---|---|---|---|---|---|
12267 | 12267 | 2020-03-25 | Shenandoah | Virginia | 51171 | 3 | 0 |
13914 | 13914 | 2020-03-26 | Shenandoah | Virginia | 51171 | 3 | 0 |
15683 | 15683 | 2020-03-27 | Shenandoah | Virginia | 51171 | 3 | 0 |
17563 | 17563 | 2020-03-28 | Shenandoah | Virginia | 51171 | 3 | 0 |
19525 | 19525 | 2020-03-29 | Shenandoah | Virginia | 51171 | 4 | 0 |
21591 | 21591 | 2020-03-30 | Shenandoah | Virginia | 51171 | 6 | 0 |
23738 | 23738 | 2020-03-31 | Shenandoah | Virginia | 51171 | 7 | 0 |
25954 | 25954 | 2020-04-01 | Shenandoah | Virginia | 51171 | 8 | 0 |
28245 | 28245 | 2020-04-02 | Shenandoah | Virginia | 51171 | 9 | 0 |
30594 | 30594 | 2020-04-03 | Shenandoah | Virginia | 51171 | 10 | 0 |
32993 | 32993 | 2020-04-04 | Shenandoah | Virginia | 51171 | 10 | 0 |
35431 | 35431 | 2020-04-05 | Shenandoah | Virginia | 51171 | 12 | 0 |
37915 | 37915 | 2020-04-06 | Shenandoah | Virginia | 51171 | 13 | 0 |
40450 | 40450 | 2020-04-07 | Shenandoah | Virginia | 51171 | 12 | 0 |
43019 | 43019 | 2020-04-08 | Shenandoah | Virginia | 51171 | 13 | 0 |
45615 | 45615 | 2020-04-09 | Shenandoah | Virginia | 51171 | 15 | 0 |
48242 | 48242 | 2020-04-10 | Shenandoah | Virginia | 51171 | 15 | 0 |
50900 | 50900 | 2020-04-11 | Shenandoah | Virginia | 51171 | 16 | 1 |
53575 | 53575 | 2020-04-12 | Shenandoah | Virginia | 51171 | 17 | 1 |
56265 | 56265 | 2020-04-13 | Shenandoah | Virginia | 51171 | 17 | 1 |
58971 | 58971 | 2020-04-14 | Shenandoah | Virginia | 51171 | 23 | 1 |
61690 | 61690 | 2020-04-15 | Shenandoah | Virginia | 51171 | 27 | 1 |
64423 | 64423 | 2020-04-16 | Shenandoah | Virginia | 51171 | 28 | 1 |
67171 | 67171 | 2020-04-17 | Shenandoah | Virginia | 51171 | 33 | 1 |
69933 | 69933 | 2020-04-18 | Shenandoah | Virginia | 51171 | 39 | 1 |
72703 | 72703 | 2020-04-19 | Shenandoah | Virginia | 51171 | 39 | 1 |
75479 | 75479 | 2020-04-20 | Shenandoah | Virginia | 51171 | 41 | 1 |
78263 | 78263 | 2020-04-21 | Shenandoah | Virginia | 51171 | 45 | 1 |
81056 | 81056 | 2020-04-22 | Shenandoah | Virginia | 51171 | 53 | 0 |
83857 | 83857 | 2020-04-23 | Shenandoah | Virginia | 51171 | 58 | 1 |
86664 | 86664 | 2020-04-24 | Shenandoah | Virginia | 51171 | 65 | 1 |
89479 | 89479 | 2020-04-25 | Shenandoah | Virginia | 51171 | 72 | 1 |
92296 | 92296 | 2020-04-26 | Shenandoah | Virginia | 51171 | 74 | 1 |
95125 | 95125 | 2020-04-27 | Shenandoah | Virginia | 51171 | 78 | 2 |
97969 | 97969 | 2020-04-28 | Shenandoah | Virginia | 51171 | 79 | 2 |
100819 | 100819 | 2020-04-29 | Shenandoah | Virginia | 51171 | 95 | 2 |
103674 | 103674 | 2020-04-30 | Shenandoah | Virginia | 51171 | 108 | 2 |
106538 | 106538 | 2020-05-01 | Shenandoah | Virginia | 51171 | 120 | 2 |
109407 | 109407 | 2020-05-02 | Shenandoah | Virginia | 51171 | 134 | 2 |
112281 | 112281 | 2020-05-03 | Shenandoah | Virginia | 51171 | 145 | 2 |
115164 | 115164 | 2020-05-04 | Shenandoah | Virginia | 51171 | 149 | 2 |
118123 | 118123 | 2020-05-05 | Shenandoah | Virginia | 51171 | 165 | 3 |
121087 | 121087 | 2020-05-06 | Shenandoah | Virginia | 51171 | 165 | 3 |
124068 | 124068 | 2020-05-07 | Shenandoah | Virginia | 51171 | 213 | 3 |
127053 | 127053 | 2020-05-08 | Shenandoah | Virginia | 51171 | 236 | 4 |
130043 | 130043 | 2020-05-09 | Shenandoah | Virginia | 51171 | 242 | 6 |
133033 | 133033 | 2020-05-10 | Shenandoah | Virginia | 51171 | 245 | 6 |
136023 | 136023 | 2020-05-11 | Shenandoah | Virginia | 51171 | 250 | 6 |
139014 | 139014 | 2020-05-12 | Shenandoah | Virginia | 51171 | 260 | 7 |
142010 | 142010 | 2020-05-13 | Shenandoah | Virginia | 51171 | 271 | 8 |
145007 | 145007 | 2020-05-14 | Shenandoah | Virginia | 51171 | 278 | 9 |
148010 | 148010 | 2020-05-15 | Shenandoah | Virginia | 51171 | 285 | 10 |
151019 | 151019 | 2020-05-16 | Shenandoah | Virginia | 51171 | 297 | 11 |
154030 | 154030 | 2020-05-17 | Shenandoah | Virginia | 51171 | 303 | 11 |
157047 | 157047 | 2020-05-18 | Shenandoah | Virginia | 51171 | 319 | 12 |
160071 | 160071 | 2020-05-19 | Shenandoah | Virginia | 51171 | 329 | 12 |
163099 | 163099 | 2020-05-20 | Shenandoah | Virginia | 51171 | 345 | 12 |
166128 | 166128 | 2020-05-21 | Shenandoah | Virginia | 51171 | 355 | 12 |
169164 | 169164 | 2020-05-22 | Shenandoah | Virginia | 51171 | 358 | 12 |
172205 | 172205 | 2020-05-23 | Shenandoah | Virginia | 51171 | 365 | 16 |
175248 | 175248 | 2020-05-24 | Shenandoah | Virginia | 51171 | 372 | 16 |
178293 | 178293 | 2020-05-25 | Shenandoah | Virginia | 51171 | 376 | 17 |
181337 | 181337 | 2020-05-26 | Shenandoah | Virginia | 51171 | 378 | 17 |
184388 | 184388 | 2020-05-27 | Shenandoah | Virginia | 51171 | 394 | 17 |
187445 | 187445 | 2020-05-28 | Shenandoah | Virginia | 51171 | 414 | 20 |
190509 | 190509 | 2020-05-29 | Shenandoah | Virginia | 51171 | 429 | 21 |
193575 | 193575 | 2020-05-30 | Shenandoah | Virginia | 51171 | 444 | 21 |
196645 | 196645 | 2020-05-31 | Shenandoah | Virginia | 51171 | 448 | 21 |
199718 | 199718 | 2020-06-01 | Shenandoah | Virginia | 51171 | 458 | 21 |
202794 | 202794 | 2020-06-02 | Shenandoah | Virginia | 51171 | 465 | 22 |
205873 | 205873 | 2020-06-03 | Shenandoah | Virginia | 51171 | 465 | 22 |
208955 | 208955 | 2020-06-04 | Shenandoah | Virginia | 51171 | 470 | 22 |
212040 | 212040 | 2020-06-05 | Shenandoah | Virginia | 51171 | 472 | 22 |
215127 | 215127 | 2020-06-06 | Shenandoah | Virginia | 51171 | 476 | 22 |
218217 | 218217 | 2020-06-07 | Shenandoah | Virginia | 51171 | 480 | 22 |
221309 | 221309 | 2020-06-08 | Shenandoah | Virginia | 51171 | 484 | 24 |
224405 | 224405 | 2020-06-09 | Shenandoah | Virginia | 51171 | 487 | 24 |
227505 | 227505 | 2020-06-10 | Shenandoah | Virginia | 51171 | 492 | 25 |
230609 | 230609 | 2020-06-11 | Shenandoah | Virginia | 51171 | 499 | 25 |
233714 | 233714 | 2020-06-12 | Shenandoah | Virginia | 51171 | 505 | 26 |
236821 | 236821 | 2020-06-13 | Shenandoah | Virginia | 51171 | 509 | 26 |
239929 | 239929 | 2020-06-14 | Shenandoah | Virginia | 51171 | 510 | 26 |
243040 | 243040 | 2020-06-15 | Shenandoah | Virginia | 51171 | 511 | 26 |
246153 | 246153 | 2020-06-16 | Shenandoah | Virginia | 51171 | 516 | 27 |
249265 | 249265 | 2020-06-17 | Shenandoah | Virginia | 51171 | 522 | 27 |
252380 | 252380 | 2020-06-18 | Shenandoah | Virginia | 51171 | 530 | 27 |
255499 | 255499 | 2020-06-19 | Shenandoah | Virginia | 51171 | 534 | 27 |
258626 | 258626 | 2020-06-20 | Shenandoah | Virginia | 51171 | 536 | 27 |
261753 | 261753 | 2020-06-21 | Shenandoah | Virginia | 51171 | 540 | 27 |
264882 | 264882 | 2020-06-22 | Shenandoah | Virginia | 51171 | 542 | 27 |
268011 | 268011 | 2020-06-23 | Shenandoah | Virginia | 51171 | 546 | 27 |
271145 | 271145 | 2020-06-24 | Shenandoah | Virginia | 51171 | 547 | 27 |
274285 | 274285 | 2020-06-25 | Shenandoah | Virginia | 51171 | 552 | 28 |
277433 | 277433 | 2020-06-26 | Shenandoah | Virginia | 51171 | 552 | 28 |
280581 | 280581 | 2020-06-27 | Shenandoah | Virginia | 51171 | 558 | 29 |
283727 | 283727 | 2020-06-28 | Shenandoah | Virginia | 51171 | 558 | 29 |
286873 | 286873 | 2020-06-29 | Shenandoah | Virginia | 51171 | 559 | 29 |
290023 | 290023 | 2020-06-30 | Shenandoah | Virginia | 51171 | 562 | 29 |
293176 | 293176 | 2020-07-01 | Shenandoah | Virginia | 51171 | 567 | 29 |
296331 | 296331 | 2020-07-02 | Shenandoah | Virginia | 51171 | 582 | 29 |
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);