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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7022 | 7022 | 2020-03-21 | Franklin | Virginia | 51067 | 1 | 0 |
8156 | 8156 | 2020-03-22 | Franklin | Virginia | 51067 | 1 | 0 |
9378 | 9378 | 2020-03-23 | Franklin | Virginia | 51067 | 1 | 0 |
10725 | 10725 | 2020-03-24 | Franklin | Virginia | 51067 | 1 | 0 |
12237 | 12237 | 2020-03-25 | Franklin | Virginia | 51067 | 1 | 0 |
13875 | 13875 | 2020-03-26 | Franklin | Virginia | 51067 | 1 | 0 |
15642 | 15642 | 2020-03-27 | Franklin | Virginia | 51067 | 1 | 0 |
17516 | 17516 | 2020-03-28 | Franklin | Virginia | 51067 | 1 | 0 |
19476 | 19476 | 2020-03-29 | Franklin | Virginia | 51067 | 5 | 0 |
21539 | 21539 | 2020-03-30 | Franklin | Virginia | 51067 | 5 | 0 |
23683 | 23683 | 2020-03-31 | Franklin | Virginia | 51067 | 5 | 0 |
25899 | 25899 | 2020-04-01 | Franklin | Virginia | 51067 | 5 | 0 |
28189 | 28189 | 2020-04-02 | Franklin | Virginia | 51067 | 6 | 0 |
30535 | 30535 | 2020-04-03 | Franklin | Virginia | 51067 | 9 | 0 |
32934 | 32934 | 2020-04-04 | Franklin | Virginia | 51067 | 10 | 0 |
35372 | 35372 | 2020-04-05 | Franklin | Virginia | 51067 | 10 | 0 |
37854 | 37854 | 2020-04-06 | Franklin | Virginia | 51067 | 10 | 0 |
40387 | 40387 | 2020-04-07 | Franklin | Virginia | 51067 | 11 | 0 |
42956 | 42956 | 2020-04-08 | Franklin | Virginia | 51067 | 12 | 0 |
45551 | 45551 | 2020-04-09 | Franklin | Virginia | 51067 | 13 | 0 |
48177 | 48177 | 2020-04-10 | Franklin | Virginia | 51067 | 13 | 0 |
50835 | 50835 | 2020-04-11 | Franklin | Virginia | 51067 | 14 | 0 |
53510 | 53510 | 2020-04-12 | Franklin | Virginia | 51067 | 14 | 0 |
56200 | 56200 | 2020-04-13 | Franklin | Virginia | 51067 | 14 | 0 |
58906 | 58906 | 2020-04-14 | Franklin | Virginia | 51067 | 15 | 0 |
61625 | 61625 | 2020-04-15 | Franklin | Virginia | 51067 | 15 | 0 |
64358 | 64358 | 2020-04-16 | Franklin | Virginia | 51067 | 15 | 0 |
67106 | 67106 | 2020-04-17 | Franklin | Virginia | 51067 | 15 | 0 |
69868 | 69868 | 2020-04-18 | Franklin | Virginia | 51067 | 15 | 0 |
72638 | 72638 | 2020-04-19 | Franklin | Virginia | 51067 | 15 | 0 |
75414 | 75414 | 2020-04-20 | Franklin | Virginia | 51067 | 16 | 0 |
78196 | 78196 | 2020-04-21 | Franklin | Virginia | 51067 | 16 | 0 |
80988 | 80988 | 2020-04-22 | Franklin | Virginia | 51067 | 17 | 0 |
83789 | 83789 | 2020-04-23 | Franklin | Virginia | 51067 | 17 | 0 |
86596 | 86596 | 2020-04-24 | Franklin | Virginia | 51067 | 19 | 0 |
89411 | 89411 | 2020-04-25 | Franklin | Virginia | 51067 | 19 | 0 |
92228 | 92228 | 2020-04-26 | Franklin | Virginia | 51067 | 19 | 0 |
95057 | 95057 | 2020-04-27 | Franklin | Virginia | 51067 | 19 | 0 |
97899 | 97899 | 2020-04-28 | Franklin | Virginia | 51067 | 20 | 0 |
100749 | 100749 | 2020-04-29 | Franklin | Virginia | 51067 | 21 | 0 |
103604 | 103604 | 2020-04-30 | Franklin | Virginia | 51067 | 21 | 0 |
106468 | 106468 | 2020-05-01 | Franklin | Virginia | 51067 | 21 | 0 |
109337 | 109337 | 2020-05-02 | Franklin | Virginia | 51067 | 22 | 0 |
112211 | 112211 | 2020-05-03 | Franklin | Virginia | 51067 | 23 | 0 |
115094 | 115094 | 2020-05-04 | Franklin | Virginia | 51067 | 23 | 0 |
118053 | 118053 | 2020-05-05 | Franklin | Virginia | 51067 | 23 | 0 |
121017 | 121017 | 2020-05-06 | Franklin | Virginia | 51067 | 23 | 0 |
123998 | 123998 | 2020-05-07 | Franklin | Virginia | 51067 | 24 | 0 |
126983 | 126983 | 2020-05-08 | Franklin | Virginia | 51067 | 25 | 0 |
129973 | 129973 | 2020-05-09 | Franklin | Virginia | 51067 | 26 | 0 |
132963 | 132963 | 2020-05-10 | Franklin | Virginia | 51067 | 27 | 0 |
135953 | 135953 | 2020-05-11 | Franklin | Virginia | 51067 | 28 | 0 |
138944 | 138944 | 2020-05-12 | Franklin | Virginia | 51067 | 28 | 0 |
141940 | 141940 | 2020-05-13 | Franklin | Virginia | 51067 | 30 | 0 |
144937 | 144937 | 2020-05-14 | Franklin | Virginia | 51067 | 30 | 1 |
147940 | 147940 | 2020-05-15 | Franklin | Virginia | 51067 | 30 | 1 |
150949 | 150949 | 2020-05-16 | Franklin | Virginia | 51067 | 30 | 1 |
153960 | 153960 | 2020-05-17 | Franklin | Virginia | 51067 | 30 | 1 |
156977 | 156977 | 2020-05-18 | Franklin | Virginia | 51067 | 30 | 1 |
160001 | 160001 | 2020-05-19 | Franklin | Virginia | 51067 | 30 | 1 |
163029 | 163029 | 2020-05-20 | Franklin | Virginia | 51067 | 30 | 1 |
166058 | 166058 | 2020-05-21 | Franklin | Virginia | 51067 | 30 | 1 |
169094 | 169094 | 2020-05-22 | Franklin | Virginia | 51067 | 31 | 1 |
172135 | 172135 | 2020-05-23 | Franklin | Virginia | 51067 | 32 | 1 |
175178 | 175178 | 2020-05-24 | Franklin | Virginia | 51067 | 32 | 1 |
178223 | 178223 | 2020-05-25 | Franklin | Virginia | 51067 | 33 | 2 |
181267 | 181267 | 2020-05-26 | Franklin | Virginia | 51067 | 34 | 2 |
184318 | 184318 | 2020-05-27 | Franklin | Virginia | 51067 | 35 | 2 |
187375 | 187375 | 2020-05-28 | Franklin | Virginia | 51067 | 35 | 1 |
190439 | 190439 | 2020-05-29 | Franklin | Virginia | 51067 | 35 | 1 |
193505 | 193505 | 2020-05-30 | Franklin | Virginia | 51067 | 36 | 1 |
196575 | 196575 | 2020-05-31 | Franklin | Virginia | 51067 | 36 | 1 |
199648 | 199648 | 2020-06-01 | Franklin | Virginia | 51067 | 36 | 1 |
202724 | 202724 | 2020-06-02 | Franklin | Virginia | 51067 | 36 | 1 |
205803 | 205803 | 2020-06-03 | Franklin | Virginia | 51067 | 36 | 1 |
208885 | 208885 | 2020-06-04 | Franklin | Virginia | 51067 | 37 | 1 |
211970 | 211970 | 2020-06-05 | Franklin | Virginia | 51067 | 38 | 1 |
215057 | 215057 | 2020-06-06 | Franklin | Virginia | 51067 | 39 | 1 |
218147 | 218147 | 2020-06-07 | Franklin | Virginia | 51067 | 40 | 1 |
221239 | 221239 | 2020-06-08 | Franklin | Virginia | 51067 | 40 | 1 |
224335 | 224335 | 2020-06-09 | Franklin | Virginia | 51067 | 41 | 1 |
227435 | 227435 | 2020-06-10 | Franklin | Virginia | 51067 | 41 | 1 |
230539 | 230539 | 2020-06-11 | Franklin | Virginia | 51067 | 42 | 1 |
233644 | 233644 | 2020-06-12 | Franklin | Virginia | 51067 | 42 | 1 |
236751 | 236751 | 2020-06-13 | Franklin | Virginia | 51067 | 43 | 1 |
239859 | 239859 | 2020-06-14 | Franklin | Virginia | 51067 | 43 | 1 |
242970 | 242970 | 2020-06-15 | Franklin | Virginia | 51067 | 43 | 1 |
246083 | 246083 | 2020-06-16 | Franklin | Virginia | 51067 | 43 | 1 |
249195 | 249195 | 2020-06-17 | Franklin | Virginia | 51067 | 46 | 1 |
252310 | 252310 | 2020-06-18 | Franklin | Virginia | 51067 | 46 | 1 |
255429 | 255429 | 2020-06-19 | Franklin | Virginia | 51067 | 48 | 1 |
258556 | 258556 | 2020-06-20 | Franklin | Virginia | 51067 | 48 | 1 |
261683 | 261683 | 2020-06-21 | Franklin | Virginia | 51067 | 50 | 1 |
264812 | 264812 | 2020-06-22 | Franklin | Virginia | 51067 | 50 | 1 |
267941 | 267941 | 2020-06-23 | Franklin | Virginia | 51067 | 52 | 1 |
271075 | 271075 | 2020-06-24 | Franklin | Virginia | 51067 | 53 | 1 |
274215 | 274215 | 2020-06-25 | Franklin | Virginia | 51067 | 53 | 1 |
277363 | 277363 | 2020-06-26 | Franklin | Virginia | 51067 | 54 | 1 |
280511 | 280511 | 2020-06-27 | Franklin | Virginia | 51067 | 60 | 1 |
283657 | 283657 | 2020-06-28 | Franklin | Virginia | 51067 | 66 | 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);