ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51085 and state = "Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1592 | 1592 | 2020-03-12 | Hanover | Virginia | 51085 | 1 | 0 |
1901 | 1901 | 2020-03-13 | Hanover | Virginia | 51085 | 1 | 0 |
2273 | 2273 | 2020-03-14 | Hanover | Virginia | 51085 | 1 | 0 |
2700 | 2700 | 2020-03-15 | Hanover | Virginia | 51085 | 1 | 0 |
3172 | 3172 | 2020-03-16 | Hanover | Virginia | 51085 | 1 | 0 |
3710 | 3710 | 2020-03-17 | Hanover | Virginia | 51085 | 1 | 0 |
4343 | 4343 | 2020-03-18 | Hanover | Virginia | 51085 | 1 | 0 |
5099 | 5099 | 2020-03-19 | Hanover | Virginia | 51085 | 1 | 0 |
5997 | 5997 | 2020-03-20 | Hanover | Virginia | 51085 | 1 | 0 |
7025 | 7025 | 2020-03-21 | Hanover | Virginia | 51085 | 1 | 0 |
8159 | 8159 | 2020-03-22 | Hanover | Virginia | 51085 | 1 | 0 |
9381 | 9381 | 2020-03-23 | Hanover | Virginia | 51085 | 2 | 0 |
10729 | 10729 | 2020-03-24 | Hanover | Virginia | 51085 | 2 | 0 |
12243 | 12243 | 2020-03-25 | Hanover | Virginia | 51085 | 2 | 0 |
13883 | 13883 | 2020-03-26 | Hanover | Virginia | 51085 | 2 | 0 |
15651 | 15651 | 2020-03-27 | Hanover | Virginia | 51085 | 2 | 0 |
17525 | 17525 | 2020-03-28 | Hanover | Virginia | 51085 | 3 | 0 |
19486 | 19486 | 2020-03-29 | Hanover | Virginia | 51085 | 4 | 0 |
21549 | 21549 | 2020-03-30 | Hanover | Virginia | 51085 | 5 | 0 |
23694 | 23694 | 2020-03-31 | Hanover | Virginia | 51085 | 6 | 0 |
25910 | 25910 | 2020-04-01 | Hanover | Virginia | 51085 | 6 | 0 |
28200 | 28200 | 2020-04-02 | Hanover | Virginia | 51085 | 8 | 0 |
30546 | 30546 | 2020-04-03 | Hanover | Virginia | 51085 | 12 | 0 |
32945 | 32945 | 2020-04-04 | Hanover | Virginia | 51085 | 12 | 0 |
35383 | 35383 | 2020-04-05 | Hanover | Virginia | 51085 | 12 | 0 |
37866 | 37866 | 2020-04-06 | Hanover | Virginia | 51085 | 13 | 0 |
40399 | 40399 | 2020-04-07 | Hanover | Virginia | 51085 | 19 | 0 |
42968 | 42968 | 2020-04-08 | Hanover | Virginia | 51085 | 22 | 0 |
45563 | 45563 | 2020-04-09 | Hanover | Virginia | 51085 | 29 | 0 |
48189 | 48189 | 2020-04-10 | Hanover | Virginia | 51085 | 31 | 0 |
50847 | 50847 | 2020-04-11 | Hanover | Virginia | 51085 | 38 | 0 |
53522 | 53522 | 2020-04-12 | Hanover | Virginia | 51085 | 38 | 0 |
56212 | 56212 | 2020-04-13 | Hanover | Virginia | 51085 | 39 | 0 |
58918 | 58918 | 2020-04-14 | Hanover | Virginia | 51085 | 52 | 0 |
61637 | 61637 | 2020-04-15 | Hanover | Virginia | 51085 | 53 | 0 |
64370 | 64370 | 2020-04-16 | Hanover | Virginia | 51085 | 61 | 0 |
67118 | 67118 | 2020-04-17 | Hanover | Virginia | 51085 | 70 | 0 |
69880 | 69880 | 2020-04-18 | Hanover | Virginia | 51085 | 79 | 0 |
72650 | 72650 | 2020-04-19 | Hanover | Virginia | 51085 | 84 | 0 |
75426 | 75426 | 2020-04-20 | Hanover | Virginia | 51085 | 91 | 0 |
78208 | 78208 | 2020-04-21 | Hanover | Virginia | 51085 | 93 | 6 |
81000 | 81000 | 2020-04-22 | Hanover | Virginia | 51085 | 97 | 6 |
83801 | 83801 | 2020-04-23 | Hanover | Virginia | 51085 | 99 | 7 |
86608 | 86608 | 2020-04-24 | Hanover | Virginia | 51085 | 100 | 7 |
89423 | 89423 | 2020-04-25 | Hanover | Virginia | 51085 | 103 | 7 |
92240 | 92240 | 2020-04-26 | Hanover | Virginia | 51085 | 105 | 7 |
95069 | 95069 | 2020-04-27 | Hanover | Virginia | 51085 | 108 | 7 |
97912 | 97912 | 2020-04-28 | Hanover | Virginia | 51085 | 109 | 9 |
100762 | 100762 | 2020-04-29 | Hanover | Virginia | 51085 | 113 | 9 |
103617 | 103617 | 2020-04-30 | Hanover | Virginia | 51085 | 118 | 9 |
106481 | 106481 | 2020-05-01 | Hanover | Virginia | 51085 | 132 | 12 |
109350 | 109350 | 2020-05-02 | Hanover | Virginia | 51085 | 133 | 11 |
112224 | 112224 | 2020-05-03 | Hanover | Virginia | 51085 | 137 | 12 |
115107 | 115107 | 2020-05-04 | Hanover | Virginia | 51085 | 141 | 12 |
118066 | 118066 | 2020-05-05 | Hanover | Virginia | 51085 | 145 | 13 |
121030 | 121030 | 2020-05-06 | Hanover | Virginia | 51085 | 145 | 13 |
124011 | 124011 | 2020-05-07 | Hanover | Virginia | 51085 | 154 | 15 |
126996 | 126996 | 2020-05-08 | Hanover | Virginia | 51085 | 155 | 15 |
129986 | 129986 | 2020-05-09 | Hanover | Virginia | 51085 | 163 | 16 |
132976 | 132976 | 2020-05-10 | Hanover | Virginia | 51085 | 170 | 16 |
135966 | 135966 | 2020-05-11 | Hanover | Virginia | 51085 | 171 | 16 |
138957 | 138957 | 2020-05-12 | Hanover | Virginia | 51085 | 174 | 17 |
141953 | 141953 | 2020-05-13 | Hanover | Virginia | 51085 | 183 | 17 |
144950 | 144950 | 2020-05-14 | Hanover | Virginia | 51085 | 198 | 18 |
147953 | 147953 | 2020-05-15 | Hanover | Virginia | 51085 | 208 | 19 |
150962 | 150962 | 2020-05-16 | Hanover | Virginia | 51085 | 215 | 19 |
153973 | 153973 | 2020-05-17 | Hanover | Virginia | 51085 | 220 | 19 |
156990 | 156990 | 2020-05-18 | Hanover | Virginia | 51085 | 225 | 19 |
160014 | 160014 | 2020-05-19 | Hanover | Virginia | 51085 | 232 | 19 |
163042 | 163042 | 2020-05-20 | Hanover | Virginia | 51085 | 238 | 19 |
166071 | 166071 | 2020-05-21 | Hanover | Virginia | 51085 | 244 | 19 |
169107 | 169107 | 2020-05-22 | Hanover | Virginia | 51085 | 246 | 19 |
172148 | 172148 | 2020-05-23 | Hanover | Virginia | 51085 | 252 | 19 |
175191 | 175191 | 2020-05-24 | Hanover | Virginia | 51085 | 252 | 19 |
178236 | 178236 | 2020-05-25 | Hanover | Virginia | 51085 | 275 | 19 |
181280 | 181280 | 2020-05-26 | Hanover | Virginia | 51085 | 301 | 19 |
184331 | 184331 | 2020-05-27 | Hanover | Virginia | 51085 | 309 | 22 |
187388 | 187388 | 2020-05-28 | Hanover | Virginia | 51085 | 316 | 24 |
190452 | 190452 | 2020-05-29 | Hanover | Virginia | 51085 | 320 | 24 |
193518 | 193518 | 2020-05-30 | Hanover | Virginia | 51085 | 322 | 24 |
196588 | 196588 | 2020-05-31 | Hanover | Virginia | 51085 | 326 | 24 |
199661 | 199661 | 2020-06-01 | Hanover | Virginia | 51085 | 327 | 24 |
202737 | 202737 | 2020-06-02 | Hanover | Virginia | 51085 | 335 | 24 |
205816 | 205816 | 2020-06-03 | Hanover | Virginia | 51085 | 331 | 24 |
208898 | 208898 | 2020-06-04 | Hanover | Virginia | 51085 | 336 | 24 |
211983 | 211983 | 2020-06-05 | Hanover | Virginia | 51085 | 338 | 24 |
215070 | 215070 | 2020-06-06 | Hanover | Virginia | 51085 | 340 | 24 |
218160 | 218160 | 2020-06-07 | Hanover | Virginia | 51085 | 348 | 24 |
221252 | 221252 | 2020-06-08 | Hanover | Virginia | 51085 | 347 | 24 |
224348 | 224348 | 2020-06-09 | Hanover | Virginia | 51085 | 351 | 24 |
227448 | 227448 | 2020-06-10 | Hanover | Virginia | 51085 | 354 | 25 |
230552 | 230552 | 2020-06-11 | Hanover | Virginia | 51085 | 357 | 25 |
233657 | 233657 | 2020-06-12 | Hanover | Virginia | 51085 | 362 | 25 |
236764 | 236764 | 2020-06-13 | Hanover | Virginia | 51085 | 368 | 25 |
239872 | 239872 | 2020-06-14 | Hanover | Virginia | 51085 | 371 | 25 |
242983 | 242983 | 2020-06-15 | Hanover | Virginia | 51085 | 374 | 25 |
246096 | 246096 | 2020-06-16 | Hanover | Virginia | 51085 | 375 | 25 |
249208 | 249208 | 2020-06-17 | Hanover | Virginia | 51085 | 378 | 25 |
252323 | 252323 | 2020-06-18 | Hanover | Virginia | 51085 | 380 | 25 |
255442 | 255442 | 2020-06-19 | Hanover | Virginia | 51085 | 387 | 25 |
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);