ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Franklin" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
327981 | 327981 | 2020-07-12 | Franklin | Virginia | 51067 | 106 | 1 |
324796 | 324796 | 2020-07-11 | Franklin | Virginia | 51067 | 106 | 1 |
321615 | 321615 | 2020-07-10 | Franklin | Virginia | 51067 | 105 | 1 |
318436 | 318436 | 2020-07-09 | Franklin | Virginia | 51067 | 106 | 1 |
315263 | 315263 | 2020-07-08 | Franklin | Virginia | 51067 | 104 | 1 |
312088 | 312088 | 2020-07-07 | Franklin | Virginia | 51067 | 104 | 1 |
308919 | 308919 | 2020-07-06 | Franklin | Virginia | 51067 | 104 | 1 |
305751 | 305751 | 2020-07-05 | Franklin | Virginia | 51067 | 96 | 1 |
302587 | 302587 | 2020-07-04 | Franklin | Virginia | 51067 | 92 | 1 |
299423 | 299423 | 2020-07-03 | Franklin | Virginia | 51067 | 92 | 1 |
296261 | 296261 | 2020-07-02 | Franklin | Virginia | 51067 | 92 | 1 |
293106 | 293106 | 2020-07-01 | Franklin | Virginia | 51067 | 91 | 1 |
289953 | 289953 | 2020-06-30 | Franklin | Virginia | 51067 | 88 | 1 |
286803 | 286803 | 2020-06-29 | Franklin | Virginia | 51067 | 72 | 1 |
283657 | 283657 | 2020-06-28 | Franklin | Virginia | 51067 | 66 | 1 |
280511 | 280511 | 2020-06-27 | Franklin | Virginia | 51067 | 60 | 1 |
277363 | 277363 | 2020-06-26 | Franklin | Virginia | 51067 | 54 | 1 |
274215 | 274215 | 2020-06-25 | Franklin | Virginia | 51067 | 53 | 1 |
271075 | 271075 | 2020-06-24 | Franklin | Virginia | 51067 | 53 | 1 |
267941 | 267941 | 2020-06-23 | Franklin | Virginia | 51067 | 52 | 1 |
264812 | 264812 | 2020-06-22 | Franklin | Virginia | 51067 | 50 | 1 |
261683 | 261683 | 2020-06-21 | Franklin | Virginia | 51067 | 50 | 1 |
258556 | 258556 | 2020-06-20 | Franklin | Virginia | 51067 | 48 | 1 |
255429 | 255429 | 2020-06-19 | Franklin | Virginia | 51067 | 48 | 1 |
252310 | 252310 | 2020-06-18 | Franklin | Virginia | 51067 | 46 | 1 |
249195 | 249195 | 2020-06-17 | Franklin | Virginia | 51067 | 46 | 1 |
246083 | 246083 | 2020-06-16 | Franklin | Virginia | 51067 | 43 | 1 |
242970 | 242970 | 2020-06-15 | Franklin | Virginia | 51067 | 43 | 1 |
239859 | 239859 | 2020-06-14 | Franklin | Virginia | 51067 | 43 | 1 |
236751 | 236751 | 2020-06-13 | Franklin | Virginia | 51067 | 43 | 1 |
233644 | 233644 | 2020-06-12 | Franklin | Virginia | 51067 | 42 | 1 |
230539 | 230539 | 2020-06-11 | Franklin | Virginia | 51067 | 42 | 1 |
227435 | 227435 | 2020-06-10 | Franklin | Virginia | 51067 | 41 | 1 |
224335 | 224335 | 2020-06-09 | Franklin | Virginia | 51067 | 41 | 1 |
221239 | 221239 | 2020-06-08 | Franklin | Virginia | 51067 | 40 | 1 |
218147 | 218147 | 2020-06-07 | Franklin | Virginia | 51067 | 40 | 1 |
215057 | 215057 | 2020-06-06 | Franklin | Virginia | 51067 | 39 | 1 |
211970 | 211970 | 2020-06-05 | Franklin | Virginia | 51067 | 38 | 1 |
208885 | 208885 | 2020-06-04 | Franklin | Virginia | 51067 | 37 | 1 |
205803 | 205803 | 2020-06-03 | Franklin | Virginia | 51067 | 36 | 1 |
202724 | 202724 | 2020-06-02 | Franklin | Virginia | 51067 | 36 | 1 |
199648 | 199648 | 2020-06-01 | Franklin | Virginia | 51067 | 36 | 1 |
196575 | 196575 | 2020-05-31 | Franklin | Virginia | 51067 | 36 | 1 |
193505 | 193505 | 2020-05-30 | Franklin | Virginia | 51067 | 36 | 1 |
190439 | 190439 | 2020-05-29 | Franklin | Virginia | 51067 | 35 | 1 |
187375 | 187375 | 2020-05-28 | Franklin | Virginia | 51067 | 35 | 1 |
184318 | 184318 | 2020-05-27 | Franklin | Virginia | 51067 | 35 | 2 |
181267 | 181267 | 2020-05-26 | Franklin | Virginia | 51067 | 34 | 2 |
178223 | 178223 | 2020-05-25 | Franklin | Virginia | 51067 | 33 | 2 |
175178 | 175178 | 2020-05-24 | Franklin | Virginia | 51067 | 32 | 1 |
172135 | 172135 | 2020-05-23 | Franklin | Virginia | 51067 | 32 | 1 |
169094 | 169094 | 2020-05-22 | Franklin | Virginia | 51067 | 31 | 1 |
166058 | 166058 | 2020-05-21 | Franklin | Virginia | 51067 | 30 | 1 |
163029 | 163029 | 2020-05-20 | Franklin | Virginia | 51067 | 30 | 1 |
160001 | 160001 | 2020-05-19 | Franklin | Virginia | 51067 | 30 | 1 |
156977 | 156977 | 2020-05-18 | Franklin | Virginia | 51067 | 30 | 1 |
153960 | 153960 | 2020-05-17 | Franklin | Virginia | 51067 | 30 | 1 |
150949 | 150949 | 2020-05-16 | Franklin | Virginia | 51067 | 30 | 1 |
147940 | 147940 | 2020-05-15 | Franklin | Virginia | 51067 | 30 | 1 |
144937 | 144937 | 2020-05-14 | Franklin | Virginia | 51067 | 30 | 1 |
141940 | 141940 | 2020-05-13 | Franklin | Virginia | 51067 | 30 | 0 |
138944 | 138944 | 2020-05-12 | Franklin | Virginia | 51067 | 28 | 0 |
135953 | 135953 | 2020-05-11 | Franklin | Virginia | 51067 | 28 | 0 |
132963 | 132963 | 2020-05-10 | Franklin | Virginia | 51067 | 27 | 0 |
129973 | 129973 | 2020-05-09 | Franklin | Virginia | 51067 | 26 | 0 |
126983 | 126983 | 2020-05-08 | Franklin | Virginia | 51067 | 25 | 0 |
123998 | 123998 | 2020-05-07 | Franklin | Virginia | 51067 | 24 | 0 |
121017 | 121017 | 2020-05-06 | Franklin | Virginia | 51067 | 23 | 0 |
118053 | 118053 | 2020-05-05 | Franklin | Virginia | 51067 | 23 | 0 |
115094 | 115094 | 2020-05-04 | Franklin | Virginia | 51067 | 23 | 0 |
112211 | 112211 | 2020-05-03 | Franklin | Virginia | 51067 | 23 | 0 |
109337 | 109337 | 2020-05-02 | Franklin | Virginia | 51067 | 22 | 0 |
106468 | 106468 | 2020-05-01 | Franklin | Virginia | 51067 | 21 | 0 |
103604 | 103604 | 2020-04-30 | Franklin | Virginia | 51067 | 21 | 0 |
100749 | 100749 | 2020-04-29 | Franklin | Virginia | 51067 | 21 | 0 |
97899 | 97899 | 2020-04-28 | Franklin | Virginia | 51067 | 20 | 0 |
95057 | 95057 | 2020-04-27 | Franklin | Virginia | 51067 | 19 | 0 |
92228 | 92228 | 2020-04-26 | Franklin | Virginia | 51067 | 19 | 0 |
89411 | 89411 | 2020-04-25 | Franklin | Virginia | 51067 | 19 | 0 |
86596 | 86596 | 2020-04-24 | Franklin | Virginia | 51067 | 19 | 0 |
83789 | 83789 | 2020-04-23 | Franklin | Virginia | 51067 | 17 | 0 |
80988 | 80988 | 2020-04-22 | Franklin | Virginia | 51067 | 17 | 0 |
78196 | 78196 | 2020-04-21 | Franklin | Virginia | 51067 | 16 | 0 |
75414 | 75414 | 2020-04-20 | Franklin | Virginia | 51067 | 16 | 0 |
72638 | 72638 | 2020-04-19 | Franklin | Virginia | 51067 | 15 | 0 |
69868 | 69868 | 2020-04-18 | Franklin | Virginia | 51067 | 15 | 0 |
67106 | 67106 | 2020-04-17 | Franklin | Virginia | 51067 | 15 | 0 |
64358 | 64358 | 2020-04-16 | Franklin | Virginia | 51067 | 15 | 0 |
61625 | 61625 | 2020-04-15 | Franklin | Virginia | 51067 | 15 | 0 |
58906 | 58906 | 2020-04-14 | Franklin | Virginia | 51067 | 15 | 0 |
56200 | 56200 | 2020-04-13 | Franklin | Virginia | 51067 | 14 | 0 |
53510 | 53510 | 2020-04-12 | Franklin | Virginia | 51067 | 14 | 0 |
50835 | 50835 | 2020-04-11 | Franklin | Virginia | 51067 | 14 | 0 |
48177 | 48177 | 2020-04-10 | Franklin | Virginia | 51067 | 13 | 0 |
45551 | 45551 | 2020-04-09 | Franklin | Virginia | 51067 | 13 | 0 |
42956 | 42956 | 2020-04-08 | Franklin | Virginia | 51067 | 12 | 0 |
40387 | 40387 | 2020-04-07 | Franklin | Virginia | 51067 | 11 | 0 |
37854 | 37854 | 2020-04-06 | Franklin | Virginia | 51067 | 10 | 0 |
35372 | 35372 | 2020-04-05 | Franklin | Virginia | 51067 | 10 | 0 |
32934 | 32934 | 2020-04-04 | Franklin | Virginia | 51067 | 10 | 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);