ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "York", fips = 51199 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388965 | 388965 | 2020-07-31 | York | Virginia | 51199 | 301 | 3 |
385748 | 385748 | 2020-07-30 | York | Virginia | 51199 | 293 | 3 |
382530 | 382530 | 2020-07-29 | York | Virginia | 51199 | 290 | 3 |
379313 | 379313 | 2020-07-28 | York | Virginia | 51199 | 287 | 3 |
376097 | 376097 | 2020-07-27 | York | Virginia | 51199 | 282 | 3 |
372883 | 372883 | 2020-07-26 | York | Virginia | 51199 | 279 | 3 |
369671 | 369671 | 2020-07-25 | York | Virginia | 51199 | 270 | 3 |
366462 | 366462 | 2020-07-24 | York | Virginia | 51199 | 259 | 3 |
363256 | 363256 | 2020-07-23 | York | Virginia | 51199 | 243 | 3 |
360050 | 360050 | 2020-07-22 | York | Virginia | 51199 | 237 | 3 |
356845 | 356845 | 2020-07-21 | York | Virginia | 51199 | 234 | 3 |
353642 | 353642 | 2020-07-20 | York | Virginia | 51199 | 226 | 3 |
350440 | 350440 | 2020-07-19 | York | Virginia | 51199 | 216 | 3 |
347239 | 347239 | 2020-07-18 | York | Virginia | 51199 | 200 | 3 |
344039 | 344039 | 2020-07-17 | York | Virginia | 51199 | 191 | 3 |
340840 | 340840 | 2020-07-16 | York | Virginia | 51199 | 181 | 3 |
337644 | 337644 | 2020-07-15 | York | Virginia | 51199 | 180 | 3 |
334449 | 334449 | 2020-07-14 | York | Virginia | 51199 | 176 | 3 |
331256 | 331256 | 2020-07-13 | York | Virginia | 51199 | 168 | 3 |
328070 | 328070 | 2020-07-12 | York | Virginia | 51199 | 160 | 3 |
324885 | 324885 | 2020-07-11 | York | Virginia | 51199 | 149 | 3 |
321704 | 321704 | 2020-07-10 | York | Virginia | 51199 | 144 | 3 |
318525 | 318525 | 2020-07-09 | York | Virginia | 51199 | 140 | 3 |
315352 | 315352 | 2020-07-08 | York | Virginia | 51199 | 135 | 3 |
312177 | 312177 | 2020-07-07 | York | Virginia | 51199 | 131 | 3 |
309008 | 309008 | 2020-07-06 | York | Virginia | 51199 | 131 | 3 |
305840 | 305840 | 2020-07-05 | York | Virginia | 51199 | 129 | 3 |
302676 | 302676 | 2020-07-04 | York | Virginia | 51199 | 124 | 3 |
299512 | 299512 | 2020-07-03 | York | Virginia | 51199 | 120 | 3 |
296350 | 296350 | 2020-07-02 | York | Virginia | 51199 | 116 | 3 |
293195 | 293195 | 2020-07-01 | York | Virginia | 51199 | 115 | 3 |
290042 | 290042 | 2020-06-30 | York | Virginia | 51199 | 115 | 3 |
286892 | 286892 | 2020-06-29 | York | Virginia | 51199 | 115 | 3 |
283746 | 283746 | 2020-06-28 | York | Virginia | 51199 | 114 | 3 |
280600 | 280600 | 2020-06-27 | York | Virginia | 51199 | 110 | 3 |
277452 | 277452 | 2020-06-26 | York | Virginia | 51199 | 108 | 3 |
274304 | 274304 | 2020-06-25 | York | Virginia | 51199 | 106 | 3 |
271164 | 271164 | 2020-06-24 | York | Virginia | 51199 | 106 | 3 |
268030 | 268030 | 2020-06-23 | York | Virginia | 51199 | 106 | 3 |
264901 | 264901 | 2020-06-22 | York | Virginia | 51199 | 101 | 3 |
261772 | 261772 | 2020-06-21 | York | Virginia | 51199 | 99 | 3 |
258645 | 258645 | 2020-06-20 | York | Virginia | 51199 | 98 | 3 |
255518 | 255518 | 2020-06-19 | York | Virginia | 51199 | 97 | 3 |
252399 | 252399 | 2020-06-18 | York | Virginia | 51199 | 94 | 3 |
249284 | 249284 | 2020-06-17 | York | Virginia | 51199 | 94 | 3 |
246172 | 246172 | 2020-06-16 | York | Virginia | 51199 | 94 | 3 |
243059 | 243059 | 2020-06-15 | York | Virginia | 51199 | 93 | 3 |
239948 | 239948 | 2020-06-14 | York | Virginia | 51199 | 93 | 3 |
236840 | 236840 | 2020-06-13 | York | Virginia | 51199 | 91 | 3 |
233733 | 233733 | 2020-06-12 | York | Virginia | 51199 | 90 | 3 |
230628 | 230628 | 2020-06-11 | York | Virginia | 51199 | 89 | 3 |
227524 | 227524 | 2020-06-10 | York | Virginia | 51199 | 86 | 3 |
224424 | 224424 | 2020-06-09 | York | Virginia | 51199 | 86 | 3 |
221328 | 221328 | 2020-06-08 | York | Virginia | 51199 | 86 | 3 |
218236 | 218236 | 2020-06-07 | York | Virginia | 51199 | 86 | 3 |
215146 | 215146 | 2020-06-06 | York | Virginia | 51199 | 82 | 3 |
212059 | 212059 | 2020-06-05 | York | Virginia | 51199 | 79 | 3 |
208974 | 208974 | 2020-06-04 | York | Virginia | 51199 | 77 | 3 |
205892 | 205892 | 2020-06-03 | York | Virginia | 51199 | 77 | 3 |
202813 | 202813 | 2020-06-02 | York | Virginia | 51199 | 77 | 3 |
199737 | 199737 | 2020-06-01 | York | Virginia | 51199 | 77 | 3 |
196664 | 196664 | 2020-05-31 | York | Virginia | 51199 | 74 | 3 |
193594 | 193594 | 2020-05-30 | York | Virginia | 51199 | 72 | 3 |
190528 | 190528 | 2020-05-29 | York | Virginia | 51199 | 72 | 3 |
187464 | 187464 | 2020-05-28 | York | Virginia | 51199 | 72 | 3 |
184407 | 184407 | 2020-05-27 | York | Virginia | 51199 | 71 | 3 |
181356 | 181356 | 2020-05-26 | York | Virginia | 51199 | 71 | 3 |
178312 | 178312 | 2020-05-25 | York | Virginia | 51199 | 69 | 3 |
175267 | 175267 | 2020-05-24 | York | Virginia | 51199 | 68 | 3 |
172224 | 172224 | 2020-05-23 | York | Virginia | 51199 | 67 | 3 |
169183 | 169183 | 2020-05-22 | York | Virginia | 51199 | 67 | 3 |
166147 | 166147 | 2020-05-21 | York | Virginia | 51199 | 65 | 3 |
163118 | 163118 | 2020-05-20 | York | Virginia | 51199 | 63 | 3 |
160090 | 160090 | 2020-05-19 | York | Virginia | 51199 | 63 | 3 |
157066 | 157066 | 2020-05-18 | York | Virginia | 51199 | 63 | 3 |
154049 | 154049 | 2020-05-17 | York | Virginia | 51199 | 62 | 3 |
151038 | 151038 | 2020-05-16 | York | Virginia | 51199 | 62 | 3 |
148029 | 148029 | 2020-05-15 | York | Virginia | 51199 | 62 | 3 |
145026 | 145026 | 2020-05-14 | York | Virginia | 51199 | 61 | 2 |
142029 | 142029 | 2020-05-13 | York | Virginia | 51199 | 60 | 2 |
139033 | 139033 | 2020-05-12 | York | Virginia | 51199 | 59 | 2 |
136042 | 136042 | 2020-05-11 | York | Virginia | 51199 | 57 | 2 |
133052 | 133052 | 2020-05-10 | York | Virginia | 51199 | 56 | 2 |
130062 | 130062 | 2020-05-09 | York | Virginia | 51199 | 55 | 2 |
127072 | 127072 | 2020-05-08 | York | Virginia | 51199 | 55 | 2 |
124087 | 124087 | 2020-05-07 | York | Virginia | 51199 | 51 | 1 |
121107 | 121107 | 2020-05-06 | York | Virginia | 51199 | 48 | 1 |
118143 | 118143 | 2020-05-05 | York | Virginia | 51199 | 48 | 1 |
115184 | 115184 | 2020-05-04 | York | Virginia | 51199 | 47 | 1 |
112301 | 112301 | 2020-05-03 | York | Virginia | 51199 | 47 | 1 |
109427 | 109427 | 2020-05-02 | York | Virginia | 51199 | 46 | 1 |
106558 | 106558 | 2020-05-01 | York | Virginia | 51199 | 46 | 1 |
103694 | 103694 | 2020-04-30 | York | Virginia | 51199 | 46 | 1 |
100839 | 100839 | 2020-04-29 | York | Virginia | 51199 | 45 | 1 |
97989 | 97989 | 2020-04-28 | York | Virginia | 51199 | 45 | 1 |
95144 | 95144 | 2020-04-27 | York | Virginia | 51199 | 44 | 1 |
92315 | 92315 | 2020-04-26 | York | Virginia | 51199 | 44 | 1 |
89498 | 89498 | 2020-04-25 | York | Virginia | 51199 | 44 | 1 |
86683 | 86683 | 2020-04-24 | York | Virginia | 51199 | 43 | 1 |
83876 | 83876 | 2020-04-23 | York | Virginia | 51199 | 43 | 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);