ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 51199 and state = "Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3181 | 3181 | 2020-03-16 | York | Virginia | 51199 | 1 | 0 |
3721 | 3721 | 2020-03-17 | York | Virginia | 51199 | 1 | 0 |
4355 | 4355 | 2020-03-18 | York | Virginia | 51199 | 1 | 0 |
5111 | 5111 | 2020-03-19 | York | Virginia | 51199 | 1 | 0 |
6012 | 6012 | 2020-03-20 | York | Virginia | 51199 | 3 | 0 |
7043 | 7043 | 2020-03-21 | York | Virginia | 51199 | 3 | 0 |
8180 | 8180 | 2020-03-22 | York | Virginia | 51199 | 5 | 0 |
9403 | 9403 | 2020-03-23 | York | Virginia | 51199 | 5 | 0 |
10752 | 10752 | 2020-03-24 | York | Virginia | 51199 | 6 | 0 |
12274 | 12274 | 2020-03-25 | York | Virginia | 51199 | 8 | 0 |
13924 | 13924 | 2020-03-26 | York | Virginia | 51199 | 9 | 0 |
15692 | 15692 | 2020-03-27 | York | Virginia | 51199 | 9 | 0 |
17572 | 17572 | 2020-03-28 | York | Virginia | 51199 | 9 | 0 |
19537 | 19537 | 2020-03-29 | York | Virginia | 51199 | 9 | 0 |
21604 | 21604 | 2020-03-30 | York | Virginia | 51199 | 11 | 0 |
23753 | 23753 | 2020-03-31 | York | Virginia | 51199 | 14 | 0 |
25971 | 25971 | 2020-04-01 | York | Virginia | 51199 | 16 | 0 |
28261 | 28261 | 2020-04-02 | York | Virginia | 51199 | 17 | 0 |
30613 | 30613 | 2020-04-03 | York | Virginia | 51199 | 17 | 0 |
33013 | 33013 | 2020-04-04 | York | Virginia | 51199 | 19 | 0 |
35451 | 35451 | 2020-04-05 | York | Virginia | 51199 | 20 | 0 |
37935 | 37935 | 2020-04-06 | York | Virginia | 51199 | 21 | 0 |
40470 | 40470 | 2020-04-07 | York | Virginia | 51199 | 25 | 1 |
43039 | 43039 | 2020-04-08 | York | Virginia | 51199 | 25 | 1 |
45635 | 45635 | 2020-04-09 | York | Virginia | 51199 | 25 | 1 |
48262 | 48262 | 2020-04-10 | York | Virginia | 51199 | 25 | 1 |
50920 | 50920 | 2020-04-11 | York | Virginia | 51199 | 27 | 1 |
53595 | 53595 | 2020-04-12 | York | Virginia | 51199 | 29 | 1 |
56285 | 56285 | 2020-04-13 | York | Virginia | 51199 | 33 | 1 |
58991 | 58991 | 2020-04-14 | York | Virginia | 51199 | 35 | 1 |
61710 | 61710 | 2020-04-15 | York | Virginia | 51199 | 35 | 1 |
64443 | 64443 | 2020-04-16 | York | Virginia | 51199 | 37 | 1 |
67191 | 67191 | 2020-04-17 | York | Virginia | 51199 | 38 | 1 |
69953 | 69953 | 2020-04-18 | York | Virginia | 51199 | 38 | 1 |
72723 | 72723 | 2020-04-19 | York | Virginia | 51199 | 44 | 1 |
75499 | 75499 | 2020-04-20 | York | Virginia | 51199 | 44 | 1 |
78282 | 78282 | 2020-04-21 | York | Virginia | 51199 | 43 | 1 |
81075 | 81075 | 2020-04-22 | York | Virginia | 51199 | 43 | 1 |
83876 | 83876 | 2020-04-23 | York | Virginia | 51199 | 43 | 1 |
86683 | 86683 | 2020-04-24 | York | Virginia | 51199 | 43 | 1 |
89498 | 89498 | 2020-04-25 | York | Virginia | 51199 | 44 | 1 |
92315 | 92315 | 2020-04-26 | York | Virginia | 51199 | 44 | 1 |
95144 | 95144 | 2020-04-27 | York | Virginia | 51199 | 44 | 1 |
97989 | 97989 | 2020-04-28 | York | Virginia | 51199 | 45 | 1 |
100839 | 100839 | 2020-04-29 | York | Virginia | 51199 | 45 | 1 |
103694 | 103694 | 2020-04-30 | York | Virginia | 51199 | 46 | 1 |
106558 | 106558 | 2020-05-01 | York | Virginia | 51199 | 46 | 1 |
109427 | 109427 | 2020-05-02 | York | Virginia | 51199 | 46 | 1 |
112301 | 112301 | 2020-05-03 | York | Virginia | 51199 | 47 | 1 |
115184 | 115184 | 2020-05-04 | York | Virginia | 51199 | 47 | 1 |
118143 | 118143 | 2020-05-05 | York | Virginia | 51199 | 48 | 1 |
121107 | 121107 | 2020-05-06 | York | Virginia | 51199 | 48 | 1 |
124087 | 124087 | 2020-05-07 | York | Virginia | 51199 | 51 | 1 |
127072 | 127072 | 2020-05-08 | York | Virginia | 51199 | 55 | 2 |
130062 | 130062 | 2020-05-09 | York | Virginia | 51199 | 55 | 2 |
133052 | 133052 | 2020-05-10 | York | Virginia | 51199 | 56 | 2 |
136042 | 136042 | 2020-05-11 | York | Virginia | 51199 | 57 | 2 |
139033 | 139033 | 2020-05-12 | York | Virginia | 51199 | 59 | 2 |
142029 | 142029 | 2020-05-13 | York | Virginia | 51199 | 60 | 2 |
145026 | 145026 | 2020-05-14 | York | Virginia | 51199 | 61 | 2 |
148029 | 148029 | 2020-05-15 | York | Virginia | 51199 | 62 | 3 |
151038 | 151038 | 2020-05-16 | York | Virginia | 51199 | 62 | 3 |
154049 | 154049 | 2020-05-17 | York | Virginia | 51199 | 62 | 3 |
157066 | 157066 | 2020-05-18 | York | Virginia | 51199 | 63 | 3 |
160090 | 160090 | 2020-05-19 | York | Virginia | 51199 | 63 | 3 |
163118 | 163118 | 2020-05-20 | York | Virginia | 51199 | 63 | 3 |
166147 | 166147 | 2020-05-21 | York | Virginia | 51199 | 65 | 3 |
169183 | 169183 | 2020-05-22 | York | Virginia | 51199 | 67 | 3 |
172224 | 172224 | 2020-05-23 | York | Virginia | 51199 | 67 | 3 |
175267 | 175267 | 2020-05-24 | York | Virginia | 51199 | 68 | 3 |
178312 | 178312 | 2020-05-25 | York | Virginia | 51199 | 69 | 3 |
181356 | 181356 | 2020-05-26 | York | Virginia | 51199 | 71 | 3 |
184407 | 184407 | 2020-05-27 | York | Virginia | 51199 | 71 | 3 |
187464 | 187464 | 2020-05-28 | York | Virginia | 51199 | 72 | 3 |
190528 | 190528 | 2020-05-29 | York | Virginia | 51199 | 72 | 3 |
193594 | 193594 | 2020-05-30 | York | Virginia | 51199 | 72 | 3 |
196664 | 196664 | 2020-05-31 | York | Virginia | 51199 | 74 | 3 |
199737 | 199737 | 2020-06-01 | York | Virginia | 51199 | 77 | 3 |
202813 | 202813 | 2020-06-02 | York | Virginia | 51199 | 77 | 3 |
205892 | 205892 | 2020-06-03 | York | Virginia | 51199 | 77 | 3 |
208974 | 208974 | 2020-06-04 | York | Virginia | 51199 | 77 | 3 |
212059 | 212059 | 2020-06-05 | York | Virginia | 51199 | 79 | 3 |
215146 | 215146 | 2020-06-06 | York | Virginia | 51199 | 82 | 3 |
218236 | 218236 | 2020-06-07 | York | Virginia | 51199 | 86 | 3 |
221328 | 221328 | 2020-06-08 | York | Virginia | 51199 | 86 | 3 |
224424 | 224424 | 2020-06-09 | York | Virginia | 51199 | 86 | 3 |
227524 | 227524 | 2020-06-10 | York | Virginia | 51199 | 86 | 3 |
230628 | 230628 | 2020-06-11 | York | Virginia | 51199 | 89 | 3 |
233733 | 233733 | 2020-06-12 | York | Virginia | 51199 | 90 | 3 |
236840 | 236840 | 2020-06-13 | York | Virginia | 51199 | 91 | 3 |
239948 | 239948 | 2020-06-14 | York | Virginia | 51199 | 93 | 3 |
243059 | 243059 | 2020-06-15 | York | Virginia | 51199 | 93 | 3 |
246172 | 246172 | 2020-06-16 | York | Virginia | 51199 | 94 | 3 |
249284 | 249284 | 2020-06-17 | York | Virginia | 51199 | 94 | 3 |
252399 | 252399 | 2020-06-18 | York | Virginia | 51199 | 94 | 3 |
255518 | 255518 | 2020-06-19 | York | Virginia | 51199 | 97 | 3 |
258645 | 258645 | 2020-06-20 | York | Virginia | 51199 | 98 | 3 |
261772 | 261772 | 2020-06-21 | York | Virginia | 51199 | 99 | 3 |
264901 | 264901 | 2020-06-22 | York | Virginia | 51199 | 101 | 3 |
268030 | 268030 | 2020-06-23 | York | Virginia | 51199 | 106 | 3 |
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);