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 |
---|---|---|---|---|---|---|---|
388876 | 388876 | 2020-07-31 | Franklin | Virginia | 51067 | 151 | 1 |
385659 | 385659 | 2020-07-30 | Franklin | Virginia | 51067 | 150 | 1 |
382441 | 382441 | 2020-07-29 | Franklin | Virginia | 51067 | 150 | 1 |
379224 | 379224 | 2020-07-28 | Franklin | Virginia | 51067 | 146 | 1 |
376008 | 376008 | 2020-07-27 | Franklin | Virginia | 51067 | 141 | 1 |
372794 | 372794 | 2020-07-26 | Franklin | Virginia | 51067 | 141 | 1 |
369582 | 369582 | 2020-07-25 | Franklin | Virginia | 51067 | 138 | 1 |
366373 | 366373 | 2020-07-24 | Franklin | Virginia | 51067 | 137 | 1 |
363167 | 363167 | 2020-07-23 | Franklin | Virginia | 51067 | 132 | 1 |
359961 | 359961 | 2020-07-22 | Franklin | Virginia | 51067 | 132 | 1 |
356756 | 356756 | 2020-07-21 | Franklin | Virginia | 51067 | 125 | 1 |
353553 | 353553 | 2020-07-20 | Franklin | Virginia | 51067 | 117 | 1 |
350351 | 350351 | 2020-07-19 | Franklin | Virginia | 51067 | 117 | 1 |
347150 | 347150 | 2020-07-18 | Franklin | Virginia | 51067 | 117 | 1 |
343950 | 343950 | 2020-07-17 | Franklin | Virginia | 51067 | 117 | 1 |
340751 | 340751 | 2020-07-16 | Franklin | Virginia | 51067 | 117 | 1 |
337555 | 337555 | 2020-07-15 | Franklin | Virginia | 51067 | 115 | 1 |
334360 | 334360 | 2020-07-14 | Franklin | Virginia | 51067 | 114 | 1 |
331167 | 331167 | 2020-07-13 | Franklin | Virginia | 51067 | 106 | 1 |
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 |
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);