ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Prince Edward" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
283712 | 283712 | 2020-06-28 | Prince Edward | Virginia | 51147 | 182 | 3 |
280566 | 280566 | 2020-06-27 | Prince Edward | Virginia | 51147 | 182 | 3 |
277418 | 277418 | 2020-06-26 | Prince Edward | Virginia | 51147 | 178 | 3 |
274270 | 274270 | 2020-06-25 | Prince Edward | Virginia | 51147 | 178 | 3 |
271130 | 271130 | 2020-06-24 | Prince Edward | Virginia | 51147 | 176 | 3 |
267996 | 267996 | 2020-06-23 | Prince Edward | Virginia | 51147 | 175 | 3 |
264867 | 264867 | 2020-06-22 | Prince Edward | Virginia | 51147 | 173 | 3 |
261738 | 261738 | 2020-06-21 | Prince Edward | Virginia | 51147 | 173 | 3 |
258611 | 258611 | 2020-06-20 | Prince Edward | Virginia | 51147 | 173 | 3 |
255484 | 255484 | 2020-06-19 | Prince Edward | Virginia | 51147 | 173 | 3 |
252365 | 252365 | 2020-06-18 | Prince Edward | Virginia | 51147 | 173 | 3 |
249250 | 249250 | 2020-06-17 | Prince Edward | Virginia | 51147 | 171 | 3 |
246138 | 246138 | 2020-06-16 | Prince Edward | Virginia | 51147 | 171 | 3 |
243025 | 243025 | 2020-06-15 | Prince Edward | Virginia | 51147 | 170 | 3 |
239914 | 239914 | 2020-06-14 | Prince Edward | Virginia | 51147 | 162 | 3 |
236806 | 236806 | 2020-06-13 | Prince Edward | Virginia | 51147 | 161 | 3 |
233699 | 233699 | 2020-06-12 | Prince Edward | Virginia | 51147 | 161 | 3 |
230594 | 230594 | 2020-06-11 | Prince Edward | Virginia | 51147 | 155 | 3 |
227490 | 227490 | 2020-06-10 | Prince Edward | Virginia | 51147 | 153 | 3 |
224390 | 224390 | 2020-06-09 | Prince Edward | Virginia | 51147 | 151 | 2 |
221294 | 221294 | 2020-06-08 | Prince Edward | Virginia | 51147 | 151 | 2 |
218202 | 218202 | 2020-06-07 | Prince Edward | Virginia | 51147 | 148 | 2 |
215112 | 215112 | 2020-06-06 | Prince Edward | Virginia | 51147 | 148 | 2 |
212025 | 212025 | 2020-06-05 | Prince Edward | Virginia | 51147 | 146 | 2 |
208940 | 208940 | 2020-06-04 | Prince Edward | Virginia | 51147 | 146 | 2 |
205858 | 205858 | 2020-06-03 | Prince Edward | Virginia | 51147 | 143 | 2 |
202779 | 202779 | 2020-06-02 | Prince Edward | Virginia | 51147 | 143 | 2 |
199703 | 199703 | 2020-06-01 | Prince Edward | Virginia | 51147 | 137 | 2 |
196630 | 196630 | 2020-05-31 | Prince Edward | Virginia | 51147 | 134 | 2 |
193560 | 193560 | 2020-05-30 | Prince Edward | Virginia | 51147 | 134 | 2 |
190494 | 190494 | 2020-05-29 | Prince Edward | Virginia | 51147 | 129 | 2 |
187430 | 187430 | 2020-05-28 | Prince Edward | Virginia | 51147 | 129 | 2 |
184373 | 184373 | 2020-05-27 | Prince Edward | Virginia | 51147 | 129 | 2 |
181322 | 181322 | 2020-05-26 | Prince Edward | Virginia | 51147 | 122 | 2 |
178278 | 178278 | 2020-05-25 | Prince Edward | Virginia | 51147 | 108 | 2 |
175233 | 175233 | 2020-05-24 | Prince Edward | Virginia | 51147 | 108 | 2 |
172190 | 172190 | 2020-05-23 | Prince Edward | Virginia | 51147 | 108 | 2 |
169149 | 169149 | 2020-05-22 | Prince Edward | Virginia | 51147 | 104 | 2 |
166113 | 166113 | 2020-05-21 | Prince Edward | Virginia | 51147 | 99 | 2 |
163084 | 163084 | 2020-05-20 | Prince Edward | Virginia | 51147 | 86 | 2 |
160056 | 160056 | 2020-05-19 | Prince Edward | Virginia | 51147 | 83 | 2 |
157032 | 157032 | 2020-05-18 | Prince Edward | Virginia | 51147 | 77 | 2 |
154015 | 154015 | 2020-05-17 | Prince Edward | Virginia | 51147 | 73 | 2 |
151004 | 151004 | 2020-05-16 | Prince Edward | Virginia | 51147 | 73 | 2 |
147995 | 147995 | 2020-05-15 | Prince Edward | Virginia | 51147 | 72 | 2 |
144992 | 144992 | 2020-05-14 | Prince Edward | Virginia | 51147 | 72 | 2 |
141995 | 141995 | 2020-05-13 | Prince Edward | Virginia | 51147 | 69 | 2 |
138999 | 138999 | 2020-05-12 | Prince Edward | Virginia | 51147 | 68 | 2 |
136008 | 136008 | 2020-05-11 | Prince Edward | Virginia | 51147 | 66 | 2 |
133018 | 133018 | 2020-05-10 | Prince Edward | Virginia | 51147 | 66 | 2 |
130028 | 130028 | 2020-05-09 | Prince Edward | Virginia | 51147 | 66 | 2 |
127038 | 127038 | 2020-05-08 | Prince Edward | Virginia | 51147 | 65 | 2 |
124053 | 124053 | 2020-05-07 | Prince Edward | Virginia | 51147 | 63 | 2 |
121072 | 121072 | 2020-05-06 | Prince Edward | Virginia | 51147 | 58 | 2 |
118108 | 118108 | 2020-05-05 | Prince Edward | Virginia | 51147 | 58 | 2 |
115149 | 115149 | 2020-05-04 | Prince Edward | Virginia | 51147 | 55 | 2 |
112266 | 112266 | 2020-05-03 | Prince Edward | Virginia | 51147 | 55 | 2 |
109392 | 109392 | 2020-05-02 | Prince Edward | Virginia | 51147 | 55 | 2 |
106523 | 106523 | 2020-05-01 | Prince Edward | Virginia | 51147 | 51 | 2 |
103659 | 103659 | 2020-04-30 | Prince Edward | Virginia | 51147 | 49 | 2 |
100804 | 100804 | 2020-04-29 | Prince Edward | Virginia | 51147 | 46 | 2 |
97954 | 97954 | 2020-04-28 | Prince Edward | Virginia | 51147 | 41 | 2 |
95110 | 95110 | 2020-04-27 | Prince Edward | Virginia | 51147 | 41 | 2 |
92281 | 92281 | 2020-04-26 | Prince Edward | Virginia | 51147 | 41 | 2 |
89464 | 89464 | 2020-04-25 | Prince Edward | Virginia | 51147 | 37 | 2 |
86649 | 86649 | 2020-04-24 | Prince Edward | Virginia | 51147 | 34 | 2 |
83842 | 83842 | 2020-04-23 | Prince Edward | Virginia | 51147 | 29 | 2 |
81041 | 81041 | 2020-04-22 | Prince Edward | Virginia | 51147 | 19 | 2 |
78248 | 78248 | 2020-04-21 | Prince Edward | Virginia | 51147 | 19 | 2 |
75464 | 75464 | 2020-04-20 | Prince Edward | Virginia | 51147 | 17 | 1 |
72688 | 72688 | 2020-04-19 | Prince Edward | Virginia | 51147 | 17 | 1 |
69918 | 69918 | 2020-04-18 | Prince Edward | Virginia | 51147 | 17 | 1 |
67156 | 67156 | 2020-04-17 | Prince Edward | Virginia | 51147 | 17 | 1 |
64408 | 64408 | 2020-04-16 | Prince Edward | Virginia | 51147 | 15 | 1 |
61675 | 61675 | 2020-04-15 | Prince Edward | Virginia | 51147 | 15 | 1 |
58956 | 58956 | 2020-04-14 | Prince Edward | Virginia | 51147 | 13 | 1 |
56250 | 56250 | 2020-04-13 | Prince Edward | Virginia | 51147 | 13 | 1 |
53560 | 53560 | 2020-04-12 | Prince Edward | Virginia | 51147 | 9 | 1 |
50885 | 50885 | 2020-04-11 | Prince Edward | Virginia | 51147 | 8 | 1 |
48227 | 48227 | 2020-04-10 | Prince Edward | Virginia | 51147 | 5 | 0 |
45601 | 45601 | 2020-04-09 | Prince Edward | Virginia | 51147 | 3 | 0 |
43005 | 43005 | 2020-04-08 | Prince Edward | Virginia | 51147 | 3 | 0 |
40436 | 40436 | 2020-04-07 | Prince Edward | Virginia | 51147 | 3 | 0 |
37902 | 37902 | 2020-04-06 | Prince Edward | Virginia | 51147 | 3 | 0 |
35419 | 35419 | 2020-04-05 | Prince Edward | Virginia | 51147 | 3 | 0 |
32981 | 32981 | 2020-04-04 | Prince Edward | Virginia | 51147 | 3 | 0 |
30582 | 30582 | 2020-04-03 | Prince Edward | Virginia | 51147 | 2 | 0 |
28235 | 28235 | 2020-04-02 | Prince Edward | Virginia | 51147 | 2 | 0 |
25945 | 25945 | 2020-04-01 | Prince Edward | Virginia | 51147 | 2 | 0 |
23729 | 23729 | 2020-03-31 | Prince Edward | Virginia | 51147 | 2 | 0 |
21582 | 21582 | 2020-03-30 | Prince Edward | Virginia | 51147 | 2 | 0 |
19516 | 19516 | 2020-03-29 | Prince Edward | Virginia | 51147 | 2 | 0 |
17554 | 17554 | 2020-03-28 | Prince Edward | Virginia | 51147 | 2 | 0 |
15674 | 15674 | 2020-03-27 | Prince Edward | Virginia | 51147 | 2 | 0 |
13906 | 13906 | 2020-03-26 | Prince Edward | Virginia | 51147 | 2 | 0 |
12261 | 12261 | 2020-03-25 | Prince Edward | Virginia | 51147 | 2 | 0 |
10741 | 10741 | 2020-03-24 | Prince Edward | Virginia | 51147 | 1 | 0 |
9393 | 9393 | 2020-03-23 | Prince Edward | Virginia | 51147 | 1 | 0 |
8171 | 8171 | 2020-03-22 | Prince Edward | Virginia | 51147 | 1 | 0 |
7035 | 7035 | 2020-03-21 | Prince Edward | Virginia | 51147 | 1 | 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);