ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 51620 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
283658 | 283658 | 2020-06-28 | Franklin city | Virginia | 51620 | 47 | 2 |
280512 | 280512 | 2020-06-27 | Franklin city | Virginia | 51620 | 47 | 2 |
277364 | 277364 | 2020-06-26 | Franklin city | Virginia | 51620 | 46 | 2 |
274216 | 274216 | 2020-06-25 | Franklin city | Virginia | 51620 | 46 | 2 |
271076 | 271076 | 2020-06-24 | Franklin city | Virginia | 51620 | 46 | 2 |
267942 | 267942 | 2020-06-23 | Franklin city | Virginia | 51620 | 46 | 2 |
264813 | 264813 | 2020-06-22 | Franklin city | Virginia | 51620 | 45 | 2 |
261684 | 261684 | 2020-06-21 | Franklin city | Virginia | 51620 | 45 | 2 |
258557 | 258557 | 2020-06-20 | Franklin city | Virginia | 51620 | 44 | 2 |
255430 | 255430 | 2020-06-19 | Franklin city | Virginia | 51620 | 44 | 2 |
252311 | 252311 | 2020-06-18 | Franklin city | Virginia | 51620 | 44 | 2 |
249196 | 249196 | 2020-06-17 | Franklin city | Virginia | 51620 | 44 | 2 |
246084 | 246084 | 2020-06-16 | Franklin city | Virginia | 51620 | 44 | 2 |
242971 | 242971 | 2020-06-15 | Franklin city | Virginia | 51620 | 44 | 2 |
239860 | 239860 | 2020-06-14 | Franklin city | Virginia | 51620 | 44 | 2 |
236752 | 236752 | 2020-06-13 | Franklin city | Virginia | 51620 | 44 | 2 |
233645 | 233645 | 2020-06-12 | Franklin city | Virginia | 51620 | 43 | 2 |
230540 | 230540 | 2020-06-11 | Franklin city | Virginia | 51620 | 43 | 2 |
227436 | 227436 | 2020-06-10 | Franklin city | Virginia | 51620 | 42 | 2 |
224336 | 224336 | 2020-06-09 | Franklin city | Virginia | 51620 | 42 | 2 |
221240 | 221240 | 2020-06-08 | Franklin city | Virginia | 51620 | 42 | 2 |
218148 | 218148 | 2020-06-07 | Franklin city | Virginia | 51620 | 42 | 2 |
215058 | 215058 | 2020-06-06 | Franklin city | Virginia | 51620 | 42 | 2 |
211971 | 211971 | 2020-06-05 | Franklin city | Virginia | 51620 | 42 | 2 |
208886 | 208886 | 2020-06-04 | Franklin city | Virginia | 51620 | 42 | 2 |
205804 | 205804 | 2020-06-03 | Franklin city | Virginia | 51620 | 42 | 2 |
202725 | 202725 | 2020-06-02 | Franklin city | Virginia | 51620 | 42 | 2 |
199649 | 199649 | 2020-06-01 | Franklin city | Virginia | 51620 | 42 | 2 |
196576 | 196576 | 2020-05-31 | Franklin city | Virginia | 51620 | 42 | 2 |
193506 | 193506 | 2020-05-30 | Franklin city | Virginia | 51620 | 42 | 2 |
190440 | 190440 | 2020-05-29 | Franklin city | Virginia | 51620 | 42 | 2 |
187376 | 187376 | 2020-05-28 | Franklin city | Virginia | 51620 | 41 | 2 |
184319 | 184319 | 2020-05-27 | Franklin city | Virginia | 51620 | 39 | 1 |
181268 | 181268 | 2020-05-26 | Franklin city | Virginia | 51620 | 39 | 1 |
178224 | 178224 | 2020-05-25 | Franklin city | Virginia | 51620 | 39 | 1 |
175179 | 175179 | 2020-05-24 | Franklin city | Virginia | 51620 | 38 | 1 |
172136 | 172136 | 2020-05-23 | Franklin city | Virginia | 51620 | 38 | 1 |
169095 | 169095 | 2020-05-22 | Franklin city | Virginia | 51620 | 34 | 1 |
166059 | 166059 | 2020-05-21 | Franklin city | Virginia | 51620 | 34 | 1 |
163030 | 163030 | 2020-05-20 | Franklin city | Virginia | 51620 | 32 | 1 |
160002 | 160002 | 2020-05-19 | Franklin city | Virginia | 51620 | 32 | 1 |
156978 | 156978 | 2020-05-18 | Franklin city | Virginia | 51620 | 32 | 1 |
153961 | 153961 | 2020-05-17 | Franklin city | Virginia | 51620 | 29 | 1 |
150950 | 150950 | 2020-05-16 | Franklin city | Virginia | 51620 | 27 | 1 |
147941 | 147941 | 2020-05-15 | Franklin city | Virginia | 51620 | 27 | 1 |
144938 | 144938 | 2020-05-14 | Franklin city | Virginia | 51620 | 26 | 1 |
141941 | 141941 | 2020-05-13 | Franklin city | Virginia | 51620 | 25 | 1 |
138945 | 138945 | 2020-05-12 | Franklin city | Virginia | 51620 | 26 | 2 |
135954 | 135954 | 2020-05-11 | Franklin city | Virginia | 51620 | 26 | 1 |
132964 | 132964 | 2020-05-10 | Franklin city | Virginia | 51620 | 26 | 1 |
129974 | 129974 | 2020-05-09 | Franklin city | Virginia | 51620 | 25 | 1 |
126984 | 126984 | 2020-05-08 | Franklin city | Virginia | 51620 | 23 | 1 |
123999 | 123999 | 2020-05-07 | Franklin city | Virginia | 51620 | 23 | 1 |
121018 | 121018 | 2020-05-06 | Franklin city | Virginia | 51620 | 23 | 1 |
118054 | 118054 | 2020-05-05 | Franklin city | Virginia | 51620 | 23 | 1 |
115095 | 115095 | 2020-05-04 | Franklin city | Virginia | 51620 | 23 | 1 |
112212 | 112212 | 2020-05-03 | Franklin city | Virginia | 51620 | 23 | 1 |
109338 | 109338 | 2020-05-02 | Franklin city | Virginia | 51620 | 23 | 1 |
106469 | 106469 | 2020-05-01 | Franklin city | Virginia | 51620 | 23 | 1 |
103605 | 103605 | 2020-04-30 | Franklin city | Virginia | 51620 | 20 | 0 |
100750 | 100750 | 2020-04-29 | Franklin city | Virginia | 51620 | 19 | 0 |
97900 | 97900 | 2020-04-28 | Franklin city | Virginia | 51620 | 18 | 0 |
95058 | 95058 | 2020-04-27 | Franklin city | Virginia | 51620 | 16 | 0 |
92229 | 92229 | 2020-04-26 | Franklin city | Virginia | 51620 | 16 | 0 |
89412 | 89412 | 2020-04-25 | Franklin city | Virginia | 51620 | 16 | 0 |
86597 | 86597 | 2020-04-24 | Franklin city | Virginia | 51620 | 15 | 0 |
83790 | 83790 | 2020-04-23 | Franklin city | Virginia | 51620 | 15 | 0 |
80989 | 80989 | 2020-04-22 | Franklin city | Virginia | 51620 | 14 | 0 |
78197 | 78197 | 2020-04-21 | Franklin city | Virginia | 51620 | 12 | 0 |
75415 | 75415 | 2020-04-20 | Franklin city | Virginia | 51620 | 12 | 0 |
72639 | 72639 | 2020-04-19 | Franklin city | Virginia | 51620 | 12 | 0 |
69869 | 69869 | 2020-04-18 | Franklin city | Virginia | 51620 | 12 | 0 |
67107 | 67107 | 2020-04-17 | Franklin city | Virginia | 51620 | 9 | 0 |
64359 | 64359 | 2020-04-16 | Franklin city | Virginia | 51620 | 9 | 0 |
61626 | 61626 | 2020-04-15 | Franklin city | Virginia | 51620 | 7 | 0 |
58907 | 58907 | 2020-04-14 | Franklin city | Virginia | 51620 | 7 | 0 |
56201 | 56201 | 2020-04-13 | Franklin city | Virginia | 51620 | 7 | 0 |
53511 | 53511 | 2020-04-12 | Franklin city | Virginia | 51620 | 6 | 0 |
50836 | 50836 | 2020-04-11 | Franklin city | Virginia | 51620 | 6 | 0 |
48178 | 48178 | 2020-04-10 | Franklin city | Virginia | 51620 | 6 | 0 |
45552 | 45552 | 2020-04-09 | Franklin city | Virginia | 51620 | 6 | 0 |
42957 | 42957 | 2020-04-08 | Franklin city | Virginia | 51620 | 5 | 0 |
40388 | 40388 | 2020-04-07 | Franklin city | Virginia | 51620 | 4 | 0 |
37855 | 37855 | 2020-04-06 | Franklin city | Virginia | 51620 | 4 | 0 |
35373 | 35373 | 2020-04-05 | Franklin city | Virginia | 51620 | 4 | 0 |
32935 | 32935 | 2020-04-04 | Franklin city | Virginia | 51620 | 4 | 0 |
30536 | 30536 | 2020-04-03 | Franklin city | Virginia | 51620 | 3 | 0 |
28190 | 28190 | 2020-04-02 | Franklin city | Virginia | 51620 | 1 | 0 |
25900 | 25900 | 2020-04-01 | Franklin city | Virginia | 51620 | 1 | 0 |
23684 | 23684 | 2020-03-31 | Franklin city | Virginia | 51620 | 1 | 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);