ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Greensville" and state = "Virginia" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
19483 | 19483 | 2020-03-29 | Greensville | Virginia | 51081 | 1 | 0 |
21546 | 21546 | 2020-03-30 | Greensville | Virginia | 51081 | 3 | 0 |
23691 | 23691 | 2020-03-31 | Greensville | Virginia | 51081 | 3 | 0 |
25907 | 25907 | 2020-04-01 | Greensville | Virginia | 51081 | 3 | 0 |
28197 | 28197 | 2020-04-02 | Greensville | Virginia | 51081 | 3 | 0 |
30543 | 30543 | 2020-04-03 | Greensville | Virginia | 51081 | 4 | 0 |
32942 | 32942 | 2020-04-04 | Greensville | Virginia | 51081 | 4 | 0 |
35380 | 35380 | 2020-04-05 | Greensville | Virginia | 51081 | 4 | 0 |
37863 | 37863 | 2020-04-06 | Greensville | Virginia | 51081 | 4 | 0 |
40396 | 40396 | 2020-04-07 | Greensville | Virginia | 51081 | 5 | 0 |
42965 | 42965 | 2020-04-08 | Greensville | Virginia | 51081 | 5 | 0 |
45560 | 45560 | 2020-04-09 | Greensville | Virginia | 51081 | 6 | 0 |
48186 | 48186 | 2020-04-10 | Greensville | Virginia | 51081 | 7 | 0 |
50844 | 50844 | 2020-04-11 | Greensville | Virginia | 51081 | 8 | 0 |
53519 | 53519 | 2020-04-12 | Greensville | Virginia | 51081 | 8 | 0 |
56209 | 56209 | 2020-04-13 | Greensville | Virginia | 51081 | 10 | 0 |
58915 | 58915 | 2020-04-14 | Greensville | Virginia | 51081 | 15 | 0 |
61634 | 61634 | 2020-04-15 | Greensville | Virginia | 51081 | 16 | 0 |
64367 | 64367 | 2020-04-16 | Greensville | Virginia | 51081 | 16 | 0 |
67115 | 67115 | 2020-04-17 | Greensville | Virginia | 51081 | 18 | 0 |
69877 | 69877 | 2020-04-18 | Greensville | Virginia | 51081 | 18 | 0 |
72647 | 72647 | 2020-04-19 | Greensville | Virginia | 51081 | 18 | 0 |
75423 | 75423 | 2020-04-20 | Greensville | Virginia | 51081 | 21 | 0 |
78205 | 78205 | 2020-04-21 | Greensville | Virginia | 51081 | 23 | 4 |
80997 | 80997 | 2020-04-22 | Greensville | Virginia | 51081 | 24 | 4 |
83798 | 83798 | 2020-04-23 | Greensville | Virginia | 51081 | 30 | 4 |
86605 | 86605 | 2020-04-24 | Greensville | Virginia | 51081 | 30 | 4 |
89420 | 89420 | 2020-04-25 | Greensville | Virginia | 51081 | 30 | 4 |
92237 | 92237 | 2020-04-26 | Greensville | Virginia | 51081 | 30 | 5 |
95066 | 95066 | 2020-04-27 | Greensville | Virginia | 51081 | 36 | 6 |
97909 | 97909 | 2020-04-28 | Greensville | Virginia | 51081 | 36 | 6 |
100759 | 100759 | 2020-04-29 | Greensville | Virginia | 51081 | 38 | 6 |
103614 | 103614 | 2020-04-30 | Greensville | Virginia | 51081 | 39 | 6 |
106478 | 106478 | 2020-05-01 | Greensville | Virginia | 51081 | 39 | 6 |
109347 | 109347 | 2020-05-02 | Greensville | Virginia | 51081 | 39 | 6 |
112221 | 112221 | 2020-05-03 | Greensville | Virginia | 51081 | 39 | 6 |
115104 | 115104 | 2020-05-04 | Greensville | Virginia | 51081 | 41 | 7 |
118063 | 118063 | 2020-05-05 | Greensville | Virginia | 51081 | 41 | 7 |
121027 | 121027 | 2020-05-06 | Greensville | Virginia | 51081 | 41 | 7 |
124008 | 124008 | 2020-05-07 | Greensville | Virginia | 51081 | 44 | 7 |
126993 | 126993 | 2020-05-08 | Greensville | Virginia | 51081 | 44 | 7 |
129983 | 129983 | 2020-05-09 | Greensville | Virginia | 51081 | 44 | 7 |
132973 | 132973 | 2020-05-10 | Greensville | Virginia | 51081 | 46 | 7 |
135963 | 135963 | 2020-05-11 | Greensville | Virginia | 51081 | 47 | 7 |
138954 | 138954 | 2020-05-12 | Greensville | Virginia | 51081 | 48 | 7 |
141950 | 141950 | 2020-05-13 | Greensville | Virginia | 51081 | 49 | 7 |
144947 | 144947 | 2020-05-14 | Greensville | Virginia | 51081 | 49 | 7 |
147950 | 147950 | 2020-05-15 | Greensville | Virginia | 51081 | 50 | 7 |
150959 | 150959 | 2020-05-16 | Greensville | Virginia | 51081 | 50 | 7 |
153970 | 153970 | 2020-05-17 | Greensville | Virginia | 51081 | 50 | 7 |
156987 | 156987 | 2020-05-18 | Greensville | Virginia | 51081 | 50 | 7 |
160011 | 160011 | 2020-05-19 | Greensville | Virginia | 51081 | 54 | 7 |
163039 | 163039 | 2020-05-20 | Greensville | Virginia | 51081 | 55 | 7 |
166068 | 166068 | 2020-05-21 | Greensville | Virginia | 51081 | 55 | 7 |
169104 | 169104 | 2020-05-22 | Greensville | Virginia | 51081 | 55 | 7 |
172145 | 172145 | 2020-05-23 | Greensville | Virginia | 51081 | 55 | 7 |
175188 | 175188 | 2020-05-24 | Greensville | Virginia | 51081 | 55 | 7 |
178233 | 178233 | 2020-05-25 | Greensville | Virginia | 51081 | 55 | 7 |
181277 | 181277 | 2020-05-26 | Greensville | Virginia | 51081 | 57 | 7 |
184328 | 184328 | 2020-05-27 | Greensville | Virginia | 51081 | 58 | 7 |
187385 | 187385 | 2020-05-28 | Greensville | Virginia | 51081 | 63 | 7 |
190449 | 190449 | 2020-05-29 | Greensville | Virginia | 51081 | 69 | 7 |
193515 | 193515 | 2020-05-30 | Greensville | Virginia | 51081 | 73 | 7 |
196585 | 196585 | 2020-05-31 | Greensville | Virginia | 51081 | 73 | 7 |
199658 | 199658 | 2020-06-01 | Greensville | Virginia | 51081 | 74 | 7 |
202734 | 202734 | 2020-06-02 | Greensville | Virginia | 51081 | 100 | 7 |
205813 | 205813 | 2020-06-03 | Greensville | Virginia | 51081 | 150 | 7 |
208895 | 208895 | 2020-06-04 | Greensville | Virginia | 51081 | 213 | 7 |
211980 | 211980 | 2020-06-05 | Greensville | Virginia | 51081 | 229 | 7 |
215067 | 215067 | 2020-06-06 | Greensville | Virginia | 51081 | 239 | 7 |
218157 | 218157 | 2020-06-07 | Greensville | Virginia | 51081 | 254 | 7 |
221249 | 221249 | 2020-06-08 | Greensville | Virginia | 51081 | 255 | 7 |
224345 | 224345 | 2020-06-09 | Greensville | Virginia | 51081 | 277 | 7 |
227445 | 227445 | 2020-06-10 | Greensville | Virginia | 51081 | 300 | 7 |
230549 | 230549 | 2020-06-11 | Greensville | Virginia | 51081 | 303 | 7 |
233654 | 233654 | 2020-06-12 | Greensville | Virginia | 51081 | 306 | 7 |
236761 | 236761 | 2020-06-13 | Greensville | Virginia | 51081 | 336 | 7 |
246093 | 246093 | 2020-06-16 | Greensville | Virginia | 51081 | 342 | 7 |
239869 | 239869 | 2020-06-14 | Greensville | Virginia | 51081 | 343 | 7 |
249205 | 249205 | 2020-06-17 | Greensville | Virginia | 51081 | 343 | 7 |
258566 | 258566 | 2020-06-20 | Greensville | Virginia | 51081 | 343 | 7 |
261693 | 261693 | 2020-06-21 | Greensville | Virginia | 51081 | 343 | 7 |
242980 | 242980 | 2020-06-15 | Greensville | Virginia | 51081 | 344 | 7 |
252320 | 252320 | 2020-06-18 | Greensville | Virginia | 51081 | 344 | 7 |
255439 | 255439 | 2020-06-19 | Greensville | Virginia | 51081 | 344 | 7 |
264822 | 264822 | 2020-06-22 | Greensville | Virginia | 51081 | 346 | 7 |
267951 | 267951 | 2020-06-23 | Greensville | Virginia | 51081 | 347 | 7 |
271085 | 271085 | 2020-06-24 | Greensville | Virginia | 51081 | 350 | 7 |
274225 | 274225 | 2020-06-25 | Greensville | Virginia | 51081 | 351 | 7 |
277373 | 277373 | 2020-06-26 | Greensville | Virginia | 51081 | 352 | 7 |
286813 | 286813 | 2020-06-29 | Greensville | Virginia | 51081 | 354 | 7 |
280521 | 280521 | 2020-06-27 | Greensville | Virginia | 51081 | 355 | 7 |
283667 | 283667 | 2020-06-28 | Greensville | Virginia | 51081 | 355 | 7 |
289963 | 289963 | 2020-06-30 | Greensville | Virginia | 51081 | 359 | 7 |
293116 | 293116 | 2020-07-01 | Greensville | Virginia | 51081 | 361 | 7 |
296271 | 296271 | 2020-07-02 | Greensville | Virginia | 51081 | 366 | 7 |
299433 | 299433 | 2020-07-03 | Greensville | Virginia | 51081 | 366 | 7 |
312098 | 312098 | 2020-07-07 | Greensville | Virginia | 51081 | 367 | 8 |
302597 | 302597 | 2020-07-04 | Greensville | Virginia | 51081 | 368 | 7 |
305761 | 305761 | 2020-07-05 | Greensville | Virginia | 51081 | 368 | 7 |
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);