ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Amelia" and state = "Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13861 | 13861 | 2020-03-26 | Amelia | Virginia | 51007 | 1 | 0 |
15627 | 15627 | 2020-03-27 | Amelia | Virginia | 51007 | 1 | 0 |
17501 | 17501 | 2020-03-28 | Amelia | Virginia | 51007 | 1 | 0 |
19461 | 19461 | 2020-03-29 | Amelia | Virginia | 51007 | 1 | 0 |
21524 | 21524 | 2020-03-30 | Amelia | Virginia | 51007 | 1 | 0 |
23663 | 23663 | 2020-03-31 | Amelia | Virginia | 51007 | 2 | 0 |
25878 | 25878 | 2020-04-01 | Amelia | Virginia | 51007 | 2 | 0 |
28167 | 28167 | 2020-04-02 | Amelia | Virginia | 51007 | 4 | 0 |
30510 | 30510 | 2020-04-03 | Amelia | Virginia | 51007 | 5 | 0 |
32908 | 32908 | 2020-04-04 | Amelia | Virginia | 51007 | 6 | 0 |
35346 | 35346 | 2020-04-05 | Amelia | Virginia | 51007 | 6 | 0 |
37827 | 37827 | 2020-04-06 | Amelia | Virginia | 51007 | 6 | 0 |
40357 | 40357 | 2020-04-07 | Amelia | Virginia | 51007 | 7 | 0 |
42926 | 42926 | 2020-04-08 | Amelia | Virginia | 51007 | 8 | 0 |
45520 | 45520 | 2020-04-09 | Amelia | Virginia | 51007 | 8 | 0 |
48144 | 48144 | 2020-04-10 | Amelia | Virginia | 51007 | 9 | 0 |
50802 | 50802 | 2020-04-11 | Amelia | Virginia | 51007 | 9 | 0 |
53477 | 53477 | 2020-04-12 | Amelia | Virginia | 51007 | 9 | 0 |
56166 | 56166 | 2020-04-13 | Amelia | Virginia | 51007 | 9 | 0 |
58872 | 58872 | 2020-04-14 | Amelia | Virginia | 51007 | 9 | 0 |
61591 | 61591 | 2020-04-15 | Amelia | Virginia | 51007 | 10 | 0 |
64323 | 64323 | 2020-04-16 | Amelia | Virginia | 51007 | 13 | 0 |
67071 | 67071 | 2020-04-17 | Amelia | Virginia | 51007 | 13 | 0 |
69833 | 69833 | 2020-04-18 | Amelia | Virginia | 51007 | 13 | 0 |
72603 | 72603 | 2020-04-19 | Amelia | Virginia | 51007 | 14 | 0 |
75379 | 75379 | 2020-04-20 | Amelia | Virginia | 51007 | 14 | 0 |
78161 | 78161 | 2020-04-21 | Amelia | Virginia | 51007 | 15 | 1 |
80953 | 80953 | 2020-04-22 | Amelia | Virginia | 51007 | 15 | 1 |
83754 | 83754 | 2020-04-23 | Amelia | Virginia | 51007 | 15 | 1 |
86561 | 86561 | 2020-04-24 | Amelia | Virginia | 51007 | 15 | 1 |
89376 | 89376 | 2020-04-25 | Amelia | Virginia | 51007 | 15 | 1 |
92193 | 92193 | 2020-04-26 | Amelia | Virginia | 51007 | 15 | 1 |
95022 | 95022 | 2020-04-27 | Amelia | Virginia | 51007 | 15 | 1 |
97864 | 97864 | 2020-04-28 | Amelia | Virginia | 51007 | 15 | 1 |
100714 | 100714 | 2020-04-29 | Amelia | Virginia | 51007 | 15 | 1 |
103569 | 103569 | 2020-04-30 | Amelia | Virginia | 51007 | 15 | 1 |
106433 | 106433 | 2020-05-01 | Amelia | Virginia | 51007 | 16 | 1 |
109302 | 109302 | 2020-05-02 | Amelia | Virginia | 51007 | 16 | 1 |
112176 | 112176 | 2020-05-03 | Amelia | Virginia | 51007 | 16 | 1 |
115059 | 115059 | 2020-05-04 | Amelia | Virginia | 51007 | 16 | 1 |
118018 | 118018 | 2020-05-05 | Amelia | Virginia | 51007 | 18 | 1 |
120982 | 120982 | 2020-05-06 | Amelia | Virginia | 51007 | 18 | 1 |
123963 | 123963 | 2020-05-07 | Amelia | Virginia | 51007 | 17 | 1 |
126948 | 126948 | 2020-05-08 | Amelia | Virginia | 51007 | 17 | 1 |
129937 | 129937 | 2020-05-09 | Amelia | Virginia | 51007 | 17 | 1 |
132927 | 132927 | 2020-05-10 | Amelia | Virginia | 51007 | 17 | 1 |
135917 | 135917 | 2020-05-11 | Amelia | Virginia | 51007 | 17 | 1 |
138908 | 138908 | 2020-05-12 | Amelia | Virginia | 51007 | 17 | 1 |
141904 | 141904 | 2020-05-13 | Amelia | Virginia | 51007 | 17 | 1 |
144901 | 144901 | 2020-05-14 | Amelia | Virginia | 51007 | 17 | 1 |
147904 | 147904 | 2020-05-15 | Amelia | Virginia | 51007 | 17 | 1 |
150913 | 150913 | 2020-05-16 | Amelia | Virginia | 51007 | 18 | 1 |
153924 | 153924 | 2020-05-17 | Amelia | Virginia | 51007 | 18 | 1 |
156941 | 156941 | 2020-05-18 | Amelia | Virginia | 51007 | 20 | 1 |
159965 | 159965 | 2020-05-19 | Amelia | Virginia | 51007 | 20 | 1 |
162993 | 162993 | 2020-05-20 | Amelia | Virginia | 51007 | 21 | 1 |
166022 | 166022 | 2020-05-21 | Amelia | Virginia | 51007 | 22 | 1 |
169058 | 169058 | 2020-05-22 | Amelia | Virginia | 51007 | 22 | 1 |
172099 | 172099 | 2020-05-23 | Amelia | Virginia | 51007 | 22 | 1 |
175142 | 175142 | 2020-05-24 | Amelia | Virginia | 51007 | 21 | 1 |
178187 | 178187 | 2020-05-25 | Amelia | Virginia | 51007 | 21 | 1 |
181231 | 181231 | 2020-05-26 | Amelia | Virginia | 51007 | 23 | 1 |
184282 | 184282 | 2020-05-27 | Amelia | Virginia | 51007 | 23 | 1 |
187339 | 187339 | 2020-05-28 | Amelia | Virginia | 51007 | 23 | 1 |
190403 | 190403 | 2020-05-29 | Amelia | Virginia | 51007 | 25 | 1 |
193469 | 193469 | 2020-05-30 | Amelia | Virginia | 51007 | 25 | 1 |
196539 | 196539 | 2020-05-31 | Amelia | Virginia | 51007 | 25 | 1 |
199612 | 199612 | 2020-06-01 | Amelia | Virginia | 51007 | 25 | 1 |
202688 | 202688 | 2020-06-02 | Amelia | Virginia | 51007 | 26 | 1 |
205767 | 205767 | 2020-06-03 | Amelia | Virginia | 51007 | 28 | 1 |
208849 | 208849 | 2020-06-04 | Amelia | Virginia | 51007 | 28 | 1 |
211934 | 211934 | 2020-06-05 | Amelia | Virginia | 51007 | 28 | 1 |
215021 | 215021 | 2020-06-06 | Amelia | Virginia | 51007 | 31 | 1 |
218111 | 218111 | 2020-06-07 | Amelia | Virginia | 51007 | 31 | 1 |
221203 | 221203 | 2020-06-08 | Amelia | Virginia | 51007 | 32 | 1 |
224299 | 224299 | 2020-06-09 | Amelia | Virginia | 51007 | 33 | 1 |
227399 | 227399 | 2020-06-10 | Amelia | Virginia | 51007 | 34 | 1 |
230503 | 230503 | 2020-06-11 | Amelia | Virginia | 51007 | 34 | 1 |
233608 | 233608 | 2020-06-12 | Amelia | Virginia | 51007 | 37 | 1 |
236715 | 236715 | 2020-06-13 | Amelia | Virginia | 51007 | 38 | 1 |
239823 | 239823 | 2020-06-14 | Amelia | Virginia | 51007 | 38 | 1 |
242934 | 242934 | 2020-06-15 | Amelia | Virginia | 51007 | 39 | 1 |
246046 | 246046 | 2020-06-16 | Amelia | Virginia | 51007 | 38 | 1 |
249158 | 249158 | 2020-06-17 | Amelia | Virginia | 51007 | 38 | 1 |
252273 | 252273 | 2020-06-18 | Amelia | Virginia | 51007 | 39 | 1 |
255391 | 255391 | 2020-06-19 | Amelia | Virginia | 51007 | 41 | 1 |
258518 | 258518 | 2020-06-20 | Amelia | Virginia | 51007 | 41 | 1 |
261645 | 261645 | 2020-06-21 | Amelia | Virginia | 51007 | 41 | 1 |
264774 | 264774 | 2020-06-22 | Amelia | Virginia | 51007 | 42 | 1 |
267903 | 267903 | 2020-06-23 | Amelia | Virginia | 51007 | 42 | 1 |
271037 | 271037 | 2020-06-24 | Amelia | Virginia | 51007 | 42 | 1 |
274177 | 274177 | 2020-06-25 | Amelia | Virginia | 51007 | 42 | 1 |
277325 | 277325 | 2020-06-26 | Amelia | Virginia | 51007 | 42 | 1 |
280473 | 280473 | 2020-06-27 | Amelia | Virginia | 51007 | 42 | 1 |
283619 | 283619 | 2020-06-28 | Amelia | Virginia | 51007 | 42 | 1 |
286765 | 286765 | 2020-06-29 | Amelia | Virginia | 51007 | 44 | 1 |
289915 | 289915 | 2020-06-30 | Amelia | Virginia | 51007 | 44 | 1 |
293068 | 293068 | 2020-07-01 | Amelia | Virginia | 51007 | 44 | 1 |
296223 | 296223 | 2020-07-02 | Amelia | Virginia | 51007 | 44 | 1 |
299385 | 299385 | 2020-07-03 | Amelia | Virginia | 51007 | 45 | 1 |
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);