ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
758 rows where fips = 51057 and state = "Virginia" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
64351 | 64351 | 2020-04-16 | Essex | Virginia | 51057 | 2 | 0 |
67099 | 67099 | 2020-04-17 | Essex | Virginia | 51057 | 2 | 0 |
69861 | 69861 | 2020-04-18 | Essex | Virginia | 51057 | 2 | 0 |
72631 | 72631 | 2020-04-19 | Essex | Virginia | 51057 | 2 | 0 |
75407 | 75407 | 2020-04-20 | Essex | Virginia | 51057 | 2 | 0 |
78189 | 78189 | 2020-04-21 | Essex | Virginia | 51057 | 2 | 0 |
80981 | 80981 | 2020-04-22 | Essex | Virginia | 51057 | 2 | 0 |
83782 | 83782 | 2020-04-23 | Essex | Virginia | 51057 | 3 | 0 |
86589 | 86589 | 2020-04-24 | Essex | Virginia | 51057 | 3 | 0 |
89404 | 89404 | 2020-04-25 | Essex | Virginia | 51057 | 4 | 0 |
92221 | 92221 | 2020-04-26 | Essex | Virginia | 51057 | 6 | 0 |
95050 | 95050 | 2020-04-27 | Essex | Virginia | 51057 | 6 | 0 |
97892 | 97892 | 2020-04-28 | Essex | Virginia | 51057 | 6 | 0 |
100742 | 100742 | 2020-04-29 | Essex | Virginia | 51057 | 6 | 0 |
103597 | 103597 | 2020-04-30 | Essex | Virginia | 51057 | 7 | 0 |
106461 | 106461 | 2020-05-01 | Essex | Virginia | 51057 | 8 | 0 |
109330 | 109330 | 2020-05-02 | Essex | Virginia | 51057 | 8 | 0 |
112204 | 112204 | 2020-05-03 | Essex | Virginia | 51057 | 11 | 0 |
115087 | 115087 | 2020-05-04 | Essex | Virginia | 51057 | 16 | 0 |
118046 | 118046 | 2020-05-05 | Essex | Virginia | 51057 | 17 | 0 |
121010 | 121010 | 2020-05-06 | Essex | Virginia | 51057 | 17 | 0 |
123991 | 123991 | 2020-05-07 | Essex | Virginia | 51057 | 18 | 0 |
126976 | 126976 | 2020-05-08 | Essex | Virginia | 51057 | 18 | 0 |
129966 | 129966 | 2020-05-09 | Essex | Virginia | 51057 | 22 | 0 |
132956 | 132956 | 2020-05-10 | Essex | Virginia | 51057 | 23 | 0 |
135946 | 135946 | 2020-05-11 | Essex | Virginia | 51057 | 24 | 0 |
138937 | 138937 | 2020-05-12 | Essex | Virginia | 51057 | 26 | 0 |
141933 | 141933 | 2020-05-13 | Essex | Virginia | 51057 | 29 | 0 |
144930 | 144930 | 2020-05-14 | Essex | Virginia | 51057 | 29 | 0 |
147933 | 147933 | 2020-05-15 | Essex | Virginia | 51057 | 30 | 0 |
150942 | 150942 | 2020-05-16 | Essex | Virginia | 51057 | 31 | 0 |
153953 | 153953 | 2020-05-17 | Essex | Virginia | 51057 | 31 | 0 |
156970 | 156970 | 2020-05-18 | Essex | Virginia | 51057 | 31 | 0 |
159994 | 159994 | 2020-05-19 | Essex | Virginia | 51057 | 35 | 0 |
163022 | 163022 | 2020-05-20 | Essex | Virginia | 51057 | 35 | 0 |
166051 | 166051 | 2020-05-21 | Essex | Virginia | 51057 | 36 | 0 |
169087 | 169087 | 2020-05-22 | Essex | Virginia | 51057 | 36 | 0 |
172128 | 172128 | 2020-05-23 | Essex | Virginia | 51057 | 41 | 0 |
175171 | 175171 | 2020-05-24 | Essex | Virginia | 51057 | 43 | 0 |
184311 | 184311 | 2020-05-27 | Essex | Virginia | 51057 | 43 | 0 |
178216 | 178216 | 2020-05-25 | Essex | Virginia | 51057 | 44 | 0 |
181260 | 181260 | 2020-05-26 | Essex | Virginia | 51057 | 44 | 0 |
187368 | 187368 | 2020-05-28 | Essex | Virginia | 51057 | 46 | 0 |
190432 | 190432 | 2020-05-29 | Essex | Virginia | 51057 | 46 | 0 |
193498 | 193498 | 2020-05-30 | Essex | Virginia | 51057 | 46 | 0 |
196568 | 196568 | 2020-05-31 | Essex | Virginia | 51057 | 48 | 0 |
199641 | 199641 | 2020-06-01 | Essex | Virginia | 51057 | 48 | 0 |
202717 | 202717 | 2020-06-02 | Essex | Virginia | 51057 | 48 | 0 |
205796 | 205796 | 2020-06-03 | Essex | Virginia | 51057 | 48 | 0 |
208878 | 208878 | 2020-06-04 | Essex | Virginia | 51057 | 52 | 0 |
230532 | 230532 | 2020-06-11 | Essex | Virginia | 51057 | 52 | 0 |
233637 | 233637 | 2020-06-12 | Essex | Virginia | 51057 | 52 | 0 |
236744 | 236744 | 2020-06-13 | Essex | Virginia | 51057 | 52 | 0 |
211963 | 211963 | 2020-06-05 | Essex | Virginia | 51057 | 53 | 0 |
215050 | 215050 | 2020-06-06 | Essex | Virginia | 51057 | 53 | 0 |
218140 | 218140 | 2020-06-07 | Essex | Virginia | 51057 | 53 | 0 |
221232 | 221232 | 2020-06-08 | Essex | Virginia | 51057 | 53 | 0 |
224328 | 224328 | 2020-06-09 | Essex | Virginia | 51057 | 53 | 0 |
227428 | 227428 | 2020-06-10 | Essex | Virginia | 51057 | 53 | 0 |
239852 | 239852 | 2020-06-14 | Essex | Virginia | 51057 | 53 | 0 |
242963 | 242963 | 2020-06-15 | Essex | Virginia | 51057 | 53 | 0 |
246076 | 246076 | 2020-06-16 | Essex | Virginia | 51057 | 53 | 0 |
249188 | 249188 | 2020-06-17 | Essex | Virginia | 51057 | 53 | 0 |
252303 | 252303 | 2020-06-18 | Essex | Virginia | 51057 | 54 | 0 |
255422 | 255422 | 2020-06-19 | Essex | Virginia | 51057 | 54 | 0 |
258549 | 258549 | 2020-06-20 | Essex | Virginia | 51057 | 54 | 0 |
261676 | 261676 | 2020-06-21 | Essex | Virginia | 51057 | 54 | 0 |
264805 | 264805 | 2020-06-22 | Essex | Virginia | 51057 | 54 | 0 |
267934 | 267934 | 2020-06-23 | Essex | Virginia | 51057 | 54 | 0 |
271068 | 271068 | 2020-06-24 | Essex | Virginia | 51057 | 54 | 0 |
274208 | 274208 | 2020-06-25 | Essex | Virginia | 51057 | 54 | 0 |
277356 | 277356 | 2020-06-26 | Essex | Virginia | 51057 | 56 | 0 |
280504 | 280504 | 2020-06-27 | Essex | Virginia | 51057 | 56 | 0 |
283650 | 283650 | 2020-06-28 | Essex | Virginia | 51057 | 56 | 0 |
286796 | 286796 | 2020-06-29 | Essex | Virginia | 51057 | 57 | 0 |
289946 | 289946 | 2020-06-30 | Essex | Virginia | 51057 | 58 | 0 |
293099 | 293099 | 2020-07-01 | Essex | Virginia | 51057 | 59 | 0 |
296254 | 296254 | 2020-07-02 | Essex | Virginia | 51057 | 59 | 0 |
299416 | 299416 | 2020-07-03 | Essex | Virginia | 51057 | 59 | 0 |
302580 | 302580 | 2020-07-04 | Essex | Virginia | 51057 | 59 | 0 |
305744 | 305744 | 2020-07-05 | Essex | Virginia | 51057 | 59 | 0 |
308912 | 308912 | 2020-07-06 | Essex | Virginia | 51057 | 59 | 0 |
312081 | 312081 | 2020-07-07 | Essex | Virginia | 51057 | 59 | 0 |
315256 | 315256 | 2020-07-08 | Essex | Virginia | 51057 | 59 | 0 |
321608 | 321608 | 2020-07-10 | Essex | Virginia | 51057 | 63 | 0 |
324789 | 324789 | 2020-07-11 | Essex | Virginia | 51057 | 63 | 0 |
327974 | 327974 | 2020-07-12 | Essex | Virginia | 51057 | 63 | 0 |
318429 | 318429 | 2020-07-09 | Essex | Virginia | 51057 | 64 | 0 |
331160 | 331160 | 2020-07-13 | Essex | Virginia | 51057 | 64 | 0 |
334353 | 334353 | 2020-07-14 | Essex | Virginia | 51057 | 66 | 0 |
337548 | 337548 | 2020-07-15 | Essex | Virginia | 51057 | 66 | 0 |
343943 | 343943 | 2020-07-17 | Essex | Virginia | 51057 | 67 | 0 |
340744 | 340744 | 2020-07-16 | Essex | Virginia | 51057 | 68 | 0 |
347143 | 347143 | 2020-07-18 | Essex | Virginia | 51057 | 68 | 0 |
350344 | 350344 | 2020-07-19 | Essex | Virginia | 51057 | 69 | 0 |
353546 | 353546 | 2020-07-20 | Essex | Virginia | 51057 | 71 | 0 |
356749 | 356749 | 2020-07-21 | Essex | Virginia | 51057 | 71 | 0 |
359954 | 359954 | 2020-07-22 | Essex | Virginia | 51057 | 72 | 0 |
363160 | 363160 | 2020-07-23 | Essex | Virginia | 51057 | 72 | 0 |
366366 | 366366 | 2020-07-24 | Essex | Virginia | 51057 | 73 | 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);