ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Appomattox" and state = "Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
37829 | 37829 | 2020-04-06 | Appomattox | Virginia | 51011 | 1 | 0 |
40359 | 40359 | 2020-04-07 | Appomattox | Virginia | 51011 | 3 | 0 |
42928 | 42928 | 2020-04-08 | Appomattox | Virginia | 51011 | 3 | 0 |
45522 | 45522 | 2020-04-09 | Appomattox | Virginia | 51011 | 4 | 0 |
48146 | 48146 | 2020-04-10 | Appomattox | Virginia | 51011 | 5 | 0 |
50804 | 50804 | 2020-04-11 | Appomattox | Virginia | 51011 | 7 | 0 |
53479 | 53479 | 2020-04-12 | Appomattox | Virginia | 51011 | 7 | 0 |
56168 | 56168 | 2020-04-13 | Appomattox | Virginia | 51011 | 7 | 0 |
58874 | 58874 | 2020-04-14 | Appomattox | Virginia | 51011 | 7 | 0 |
61593 | 61593 | 2020-04-15 | Appomattox | Virginia | 51011 | 7 | 0 |
64325 | 64325 | 2020-04-16 | Appomattox | Virginia | 51011 | 7 | 0 |
67073 | 67073 | 2020-04-17 | Appomattox | Virginia | 51011 | 7 | 0 |
69835 | 69835 | 2020-04-18 | Appomattox | Virginia | 51011 | 7 | 0 |
72605 | 72605 | 2020-04-19 | Appomattox | Virginia | 51011 | 7 | 0 |
75381 | 75381 | 2020-04-20 | Appomattox | Virginia | 51011 | 7 | 0 |
78163 | 78163 | 2020-04-21 | Appomattox | Virginia | 51011 | 7 | 0 |
80955 | 80955 | 2020-04-22 | Appomattox | Virginia | 51011 | 10 | 0 |
83756 | 83756 | 2020-04-23 | Appomattox | Virginia | 51011 | 12 | 0 |
86563 | 86563 | 2020-04-24 | Appomattox | Virginia | 51011 | 12 | 0 |
89378 | 89378 | 2020-04-25 | Appomattox | Virginia | 51011 | 12 | 0 |
92195 | 92195 | 2020-04-26 | Appomattox | Virginia | 51011 | 17 | 0 |
95024 | 95024 | 2020-04-27 | Appomattox | Virginia | 51011 | 17 | 0 |
97866 | 97866 | 2020-04-28 | Appomattox | Virginia | 51011 | 17 | 0 |
100716 | 100716 | 2020-04-29 | Appomattox | Virginia | 51011 | 18 | 0 |
103571 | 103571 | 2020-04-30 | Appomattox | Virginia | 51011 | 20 | 0 |
106435 | 106435 | 2020-05-01 | Appomattox | Virginia | 51011 | 20 | 0 |
109304 | 109304 | 2020-05-02 | Appomattox | Virginia | 51011 | 21 | 0 |
112178 | 112178 | 2020-05-03 | Appomattox | Virginia | 51011 | 21 | 0 |
115061 | 115061 | 2020-05-04 | Appomattox | Virginia | 51011 | 21 | 0 |
118020 | 118020 | 2020-05-05 | Appomattox | Virginia | 51011 | 21 | 0 |
120984 | 120984 | 2020-05-06 | Appomattox | Virginia | 51011 | 21 | 0 |
123965 | 123965 | 2020-05-07 | Appomattox | Virginia | 51011 | 21 | 0 |
126950 | 126950 | 2020-05-08 | Appomattox | Virginia | 51011 | 21 | 0 |
129939 | 129939 | 2020-05-09 | Appomattox | Virginia | 51011 | 22 | 0 |
132929 | 132929 | 2020-05-10 | Appomattox | Virginia | 51011 | 22 | 0 |
135919 | 135919 | 2020-05-11 | Appomattox | Virginia | 51011 | 22 | 0 |
138910 | 138910 | 2020-05-12 | Appomattox | Virginia | 51011 | 22 | 0 |
141906 | 141906 | 2020-05-13 | Appomattox | Virginia | 51011 | 22 | 0 |
144903 | 144903 | 2020-05-14 | Appomattox | Virginia | 51011 | 22 | 0 |
147906 | 147906 | 2020-05-15 | Appomattox | Virginia | 51011 | 23 | 0 |
150915 | 150915 | 2020-05-16 | Appomattox | Virginia | 51011 | 23 | 0 |
153926 | 153926 | 2020-05-17 | Appomattox | Virginia | 51011 | 23 | 0 |
156943 | 156943 | 2020-05-18 | Appomattox | Virginia | 51011 | 25 | 0 |
159967 | 159967 | 2020-05-19 | Appomattox | Virginia | 51011 | 24 | 0 |
162995 | 162995 | 2020-05-20 | Appomattox | Virginia | 51011 | 24 | 0 |
166024 | 166024 | 2020-05-21 | Appomattox | Virginia | 51011 | 25 | 0 |
169060 | 169060 | 2020-05-22 | Appomattox | Virginia | 51011 | 26 | 0 |
172101 | 172101 | 2020-05-23 | Appomattox | Virginia | 51011 | 26 | 0 |
175144 | 175144 | 2020-05-24 | Appomattox | Virginia | 51011 | 26 | 0 |
178189 | 178189 | 2020-05-25 | Appomattox | Virginia | 51011 | 26 | 0 |
181233 | 181233 | 2020-05-26 | Appomattox | Virginia | 51011 | 26 | 0 |
184284 | 184284 | 2020-05-27 | Appomattox | Virginia | 51011 | 31 | 0 |
187341 | 187341 | 2020-05-28 | Appomattox | Virginia | 51011 | 31 | 0 |
190405 | 190405 | 2020-05-29 | Appomattox | Virginia | 51011 | 31 | 0 |
193471 | 193471 | 2020-05-30 | Appomattox | Virginia | 51011 | 31 | 0 |
196541 | 196541 | 2020-05-31 | Appomattox | Virginia | 51011 | 31 | 0 |
199614 | 199614 | 2020-06-01 | Appomattox | Virginia | 51011 | 31 | 0 |
202690 | 202690 | 2020-06-02 | Appomattox | Virginia | 51011 | 31 | 0 |
205769 | 205769 | 2020-06-03 | Appomattox | Virginia | 51011 | 31 | 0 |
208851 | 208851 | 2020-06-04 | Appomattox | Virginia | 51011 | 31 | 0 |
211936 | 211936 | 2020-06-05 | Appomattox | Virginia | 51011 | 33 | 0 |
215023 | 215023 | 2020-06-06 | Appomattox | Virginia | 51011 | 33 | 0 |
218113 | 218113 | 2020-06-07 | Appomattox | Virginia | 51011 | 33 | 0 |
221205 | 221205 | 2020-06-08 | Appomattox | Virginia | 51011 | 33 | 0 |
224301 | 224301 | 2020-06-09 | Appomattox | Virginia | 51011 | 33 | 0 |
227401 | 227401 | 2020-06-10 | Appomattox | Virginia | 51011 | 33 | 0 |
230505 | 230505 | 2020-06-11 | Appomattox | Virginia | 51011 | 33 | 0 |
233610 | 233610 | 2020-06-12 | Appomattox | Virginia | 51011 | 34 | 0 |
236717 | 236717 | 2020-06-13 | Appomattox | Virginia | 51011 | 34 | 0 |
239825 | 239825 | 2020-06-14 | Appomattox | Virginia | 51011 | 34 | 0 |
242936 | 242936 | 2020-06-15 | Appomattox | Virginia | 51011 | 34 | 0 |
246048 | 246048 | 2020-06-16 | Appomattox | Virginia | 51011 | 34 | 0 |
249160 | 249160 | 2020-06-17 | Appomattox | Virginia | 51011 | 34 | 0 |
252275 | 252275 | 2020-06-18 | Appomattox | Virginia | 51011 | 34 | 0 |
255393 | 255393 | 2020-06-19 | Appomattox | Virginia | 51011 | 35 | 0 |
258520 | 258520 | 2020-06-20 | Appomattox | Virginia | 51011 | 36 | 0 |
261647 | 261647 | 2020-06-21 | Appomattox | Virginia | 51011 | 36 | 0 |
264776 | 264776 | 2020-06-22 | Appomattox | Virginia | 51011 | 36 | 0 |
267905 | 267905 | 2020-06-23 | Appomattox | Virginia | 51011 | 36 | 0 |
271039 | 271039 | 2020-06-24 | Appomattox | Virginia | 51011 | 36 | 0 |
274179 | 274179 | 2020-06-25 | Appomattox | Virginia | 51011 | 37 | 0 |
277327 | 277327 | 2020-06-26 | Appomattox | Virginia | 51011 | 38 | 0 |
280475 | 280475 | 2020-06-27 | Appomattox | Virginia | 51011 | 38 | 0 |
283621 | 283621 | 2020-06-28 | Appomattox | Virginia | 51011 | 39 | 0 |
286767 | 286767 | 2020-06-29 | Appomattox | Virginia | 51011 | 39 | 0 |
289917 | 289917 | 2020-06-30 | Appomattox | Virginia | 51011 | 40 | 0 |
293070 | 293070 | 2020-07-01 | Appomattox | Virginia | 51011 | 40 | 0 |
296225 | 296225 | 2020-07-02 | Appomattox | Virginia | 51011 | 41 | 0 |
299387 | 299387 | 2020-07-03 | Appomattox | Virginia | 51011 | 43 | 0 |
302551 | 302551 | 2020-07-04 | Appomattox | Virginia | 51011 | 43 | 0 |
305715 | 305715 | 2020-07-05 | Appomattox | Virginia | 51011 | 43 | 0 |
308883 | 308883 | 2020-07-06 | Appomattox | Virginia | 51011 | 43 | 0 |
312052 | 312052 | 2020-07-07 | Appomattox | Virginia | 51011 | 44 | 0 |
315226 | 315226 | 2020-07-08 | Appomattox | Virginia | 51011 | 44 | 0 |
318399 | 318399 | 2020-07-09 | Appomattox | Virginia | 51011 | 44 | 0 |
321578 | 321578 | 2020-07-10 | Appomattox | Virginia | 51011 | 46 | 0 |
324759 | 324759 | 2020-07-11 | Appomattox | Virginia | 51011 | 47 | 0 |
327944 | 327944 | 2020-07-12 | Appomattox | Virginia | 51011 | 47 | 0 |
331130 | 331130 | 2020-07-13 | Appomattox | Virginia | 51011 | 48 | 0 |
334323 | 334323 | 2020-07-14 | Appomattox | Virginia | 51011 | 48 | 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);