ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Lancaster" and state = "Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17532 | 17532 | 2020-03-28 | Lancaster | Virginia | 51103 | 1 | 0 |
19493 | 19493 | 2020-03-29 | Lancaster | Virginia | 51103 | 1 | 0 |
21558 | 21558 | 2020-03-30 | Lancaster | Virginia | 51103 | 1 | 0 |
23704 | 23704 | 2020-03-31 | Lancaster | Virginia | 51103 | 1 | 0 |
25920 | 25920 | 2020-04-01 | Lancaster | Virginia | 51103 | 1 | 0 |
28210 | 28210 | 2020-04-02 | Lancaster | Virginia | 51103 | 1 | 0 |
30556 | 30556 | 2020-04-03 | Lancaster | Virginia | 51103 | 1 | 0 |
32955 | 32955 | 2020-04-04 | Lancaster | Virginia | 51103 | 1 | 0 |
35393 | 35393 | 2020-04-05 | Lancaster | Virginia | 51103 | 1 | 0 |
37876 | 37876 | 2020-04-06 | Lancaster | Virginia | 51103 | 1 | 0 |
40409 | 40409 | 2020-04-07 | Lancaster | Virginia | 51103 | 1 | 0 |
42978 | 42978 | 2020-04-08 | Lancaster | Virginia | 51103 | 1 | 0 |
45573 | 45573 | 2020-04-09 | Lancaster | Virginia | 51103 | 1 | 0 |
48199 | 48199 | 2020-04-10 | Lancaster | Virginia | 51103 | 1 | 0 |
50857 | 50857 | 2020-04-11 | Lancaster | Virginia | 51103 | 1 | 0 |
53532 | 53532 | 2020-04-12 | Lancaster | Virginia | 51103 | 1 | 0 |
56222 | 56222 | 2020-04-13 | Lancaster | Virginia | 51103 | 1 | 0 |
58928 | 58928 | 2020-04-14 | Lancaster | Virginia | 51103 | 1 | 0 |
61647 | 61647 | 2020-04-15 | Lancaster | Virginia | 51103 | 1 | 0 |
64380 | 64380 | 2020-04-16 | Lancaster | Virginia | 51103 | 1 | 0 |
67128 | 67128 | 2020-04-17 | Lancaster | Virginia | 51103 | 1 | 0 |
69890 | 69890 | 2020-04-18 | Lancaster | Virginia | 51103 | 1 | 0 |
72660 | 72660 | 2020-04-19 | Lancaster | Virginia | 51103 | 1 | 0 |
75436 | 75436 | 2020-04-20 | Lancaster | Virginia | 51103 | 1 | 0 |
78218 | 78218 | 2020-04-21 | Lancaster | Virginia | 51103 | 1 | 0 |
81011 | 81011 | 2020-04-22 | Lancaster | Virginia | 51103 | 1 | 0 |
83812 | 83812 | 2020-04-23 | Lancaster | Virginia | 51103 | 1 | 0 |
86619 | 86619 | 2020-04-24 | Lancaster | Virginia | 51103 | 1 | 0 |
89434 | 89434 | 2020-04-25 | Lancaster | Virginia | 51103 | 1 | 0 |
92251 | 92251 | 2020-04-26 | Lancaster | Virginia | 51103 | 1 | 0 |
95080 | 95080 | 2020-04-27 | Lancaster | Virginia | 51103 | 1 | 0 |
97923 | 97923 | 2020-04-28 | Lancaster | Virginia | 51103 | 1 | 0 |
100773 | 100773 | 2020-04-29 | Lancaster | Virginia | 51103 | 1 | 0 |
103628 | 103628 | 2020-04-30 | Lancaster | Virginia | 51103 | 2 | 0 |
106492 | 106492 | 2020-05-01 | Lancaster | Virginia | 51103 | 3 | 0 |
109361 | 109361 | 2020-05-02 | Lancaster | Virginia | 51103 | 3 | 0 |
112235 | 112235 | 2020-05-03 | Lancaster | Virginia | 51103 | 4 | 0 |
115118 | 115118 | 2020-05-04 | Lancaster | Virginia | 51103 | 5 | 0 |
118077 | 118077 | 2020-05-05 | Lancaster | Virginia | 51103 | 5 | 0 |
121041 | 121041 | 2020-05-06 | Lancaster | Virginia | 51103 | 5 | 0 |
124022 | 124022 | 2020-05-07 | Lancaster | Virginia | 51103 | 6 | 0 |
127007 | 127007 | 2020-05-08 | Lancaster | Virginia | 51103 | 6 | 0 |
129997 | 129997 | 2020-05-09 | Lancaster | Virginia | 51103 | 6 | 0 |
132987 | 132987 | 2020-05-10 | Lancaster | Virginia | 51103 | 6 | 0 |
135977 | 135977 | 2020-05-11 | Lancaster | Virginia | 51103 | 6 | 0 |
138968 | 138968 | 2020-05-12 | Lancaster | Virginia | 51103 | 7 | 0 |
141964 | 141964 | 2020-05-13 | Lancaster | Virginia | 51103 | 7 | 0 |
144961 | 144961 | 2020-05-14 | Lancaster | Virginia | 51103 | 7 | 0 |
147964 | 147964 | 2020-05-15 | Lancaster | Virginia | 51103 | 7 | 0 |
150973 | 150973 | 2020-05-16 | Lancaster | Virginia | 51103 | 7 | 0 |
153984 | 153984 | 2020-05-17 | Lancaster | Virginia | 51103 | 7 | 0 |
157001 | 157001 | 2020-05-18 | Lancaster | Virginia | 51103 | 7 | 0 |
160025 | 160025 | 2020-05-19 | Lancaster | Virginia | 51103 | 7 | 0 |
163053 | 163053 | 2020-05-20 | Lancaster | Virginia | 51103 | 7 | 0 |
166082 | 166082 | 2020-05-21 | Lancaster | Virginia | 51103 | 8 | 0 |
169118 | 169118 | 2020-05-22 | Lancaster | Virginia | 51103 | 10 | 0 |
172159 | 172159 | 2020-05-23 | Lancaster | Virginia | 51103 | 10 | 0 |
175202 | 175202 | 2020-05-24 | Lancaster | Virginia | 51103 | 10 | 0 |
178247 | 178247 | 2020-05-25 | Lancaster | Virginia | 51103 | 10 | 0 |
181291 | 181291 | 2020-05-26 | Lancaster | Virginia | 51103 | 10 | 0 |
184342 | 184342 | 2020-05-27 | Lancaster | Virginia | 51103 | 10 | 0 |
187399 | 187399 | 2020-05-28 | Lancaster | Virginia | 51103 | 10 | 0 |
190463 | 190463 | 2020-05-29 | Lancaster | Virginia | 51103 | 10 | 0 |
193529 | 193529 | 2020-05-30 | Lancaster | Virginia | 51103 | 10 | 0 |
196599 | 196599 | 2020-05-31 | Lancaster | Virginia | 51103 | 10 | 0 |
199672 | 199672 | 2020-06-01 | Lancaster | Virginia | 51103 | 10 | 0 |
202748 | 202748 | 2020-06-02 | Lancaster | Virginia | 51103 | 10 | 0 |
205827 | 205827 | 2020-06-03 | Lancaster | Virginia | 51103 | 10 | 0 |
208909 | 208909 | 2020-06-04 | Lancaster | Virginia | 51103 | 10 | 0 |
211994 | 211994 | 2020-06-05 | Lancaster | Virginia | 51103 | 10 | 0 |
215081 | 215081 | 2020-06-06 | Lancaster | Virginia | 51103 | 10 | 0 |
218171 | 218171 | 2020-06-07 | Lancaster | Virginia | 51103 | 10 | 0 |
221263 | 221263 | 2020-06-08 | Lancaster | Virginia | 51103 | 10 | 0 |
224359 | 224359 | 2020-06-09 | Lancaster | Virginia | 51103 | 10 | 0 |
227459 | 227459 | 2020-06-10 | Lancaster | Virginia | 51103 | 10 | 0 |
230563 | 230563 | 2020-06-11 | Lancaster | Virginia | 51103 | 11 | 0 |
233668 | 233668 | 2020-06-12 | Lancaster | Virginia | 51103 | 11 | 0 |
236775 | 236775 | 2020-06-13 | Lancaster | Virginia | 51103 | 11 | 0 |
239883 | 239883 | 2020-06-14 | Lancaster | Virginia | 51103 | 11 | 0 |
242994 | 242994 | 2020-06-15 | Lancaster | Virginia | 51103 | 11 | 0 |
246107 | 246107 | 2020-06-16 | Lancaster | Virginia | 51103 | 11 | 0 |
249219 | 249219 | 2020-06-17 | Lancaster | Virginia | 51103 | 11 | 0 |
252334 | 252334 | 2020-06-18 | Lancaster | Virginia | 51103 | 11 | 0 |
255453 | 255453 | 2020-06-19 | Lancaster | Virginia | 51103 | 11 | 0 |
258580 | 258580 | 2020-06-20 | Lancaster | Virginia | 51103 | 12 | 0 |
261707 | 261707 | 2020-06-21 | Lancaster | Virginia | 51103 | 12 | 0 |
264836 | 264836 | 2020-06-22 | Lancaster | Virginia | 51103 | 12 | 0 |
267965 | 267965 | 2020-06-23 | Lancaster | Virginia | 51103 | 12 | 0 |
271099 | 271099 | 2020-06-24 | Lancaster | Virginia | 51103 | 12 | 0 |
274239 | 274239 | 2020-06-25 | Lancaster | Virginia | 51103 | 12 | 0 |
277387 | 277387 | 2020-06-26 | Lancaster | Virginia | 51103 | 10 | 0 |
280535 | 280535 | 2020-06-27 | Lancaster | Virginia | 51103 | 10 | 0 |
283681 | 283681 | 2020-06-28 | Lancaster | Virginia | 51103 | 11 | 0 |
286827 | 286827 | 2020-06-29 | Lancaster | Virginia | 51103 | 11 | 0 |
289977 | 289977 | 2020-06-30 | Lancaster | Virginia | 51103 | 11 | 0 |
293130 | 293130 | 2020-07-01 | Lancaster | Virginia | 51103 | 11 | 0 |
296285 | 296285 | 2020-07-02 | Lancaster | Virginia | 51103 | 11 | 0 |
299447 | 299447 | 2020-07-03 | Lancaster | Virginia | 51103 | 11 | 0 |
302611 | 302611 | 2020-07-04 | Lancaster | Virginia | 51103 | 11 | 0 |
305775 | 305775 | 2020-07-05 | Lancaster | Virginia | 51103 | 11 | 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);