ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 51133 and state = "Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17547 | 17547 | 2020-03-28 | Northumberland | Virginia | 51133 | 2 | 0 |
19509 | 19509 | 2020-03-29 | Northumberland | Virginia | 51133 | 2 | 0 |
21574 | 21574 | 2020-03-30 | Northumberland | Virginia | 51133 | 2 | 0 |
23720 | 23720 | 2020-03-31 | Northumberland | Virginia | 51133 | 3 | 0 |
25936 | 25936 | 2020-04-01 | Northumberland | Virginia | 51133 | 3 | 0 |
28226 | 28226 | 2020-04-02 | Northumberland | Virginia | 51133 | 3 | 0 |
30573 | 30573 | 2020-04-03 | Northumberland | Virginia | 51133 | 3 | 0 |
32972 | 32972 | 2020-04-04 | Northumberland | Virginia | 51133 | 3 | 0 |
35410 | 35410 | 2020-04-05 | Northumberland | Virginia | 51133 | 3 | 0 |
37893 | 37893 | 2020-04-06 | Northumberland | Virginia | 51133 | 3 | 0 |
40427 | 40427 | 2020-04-07 | Northumberland | Virginia | 51133 | 3 | 0 |
42996 | 42996 | 2020-04-08 | Northumberland | Virginia | 51133 | 3 | 0 |
45592 | 45592 | 2020-04-09 | Northumberland | Virginia | 51133 | 3 | 0 |
48218 | 48218 | 2020-04-10 | Northumberland | Virginia | 51133 | 3 | 0 |
50876 | 50876 | 2020-04-11 | Northumberland | Virginia | 51133 | 4 | 0 |
53551 | 53551 | 2020-04-12 | Northumberland | Virginia | 51133 | 4 | 0 |
56241 | 56241 | 2020-04-13 | Northumberland | Virginia | 51133 | 4 | 0 |
58947 | 58947 | 2020-04-14 | Northumberland | Virginia | 51133 | 4 | 0 |
61666 | 61666 | 2020-04-15 | Northumberland | Virginia | 51133 | 4 | 0 |
64399 | 64399 | 2020-04-16 | Northumberland | Virginia | 51133 | 5 | 0 |
67147 | 67147 | 2020-04-17 | Northumberland | Virginia | 51133 | 5 | 0 |
69909 | 69909 | 2020-04-18 | Northumberland | Virginia | 51133 | 5 | 0 |
72679 | 72679 | 2020-04-19 | Northumberland | Virginia | 51133 | 5 | 0 |
75455 | 75455 | 2020-04-20 | Northumberland | Virginia | 51133 | 5 | 0 |
78237 | 78237 | 2020-04-21 | Northumberland | Virginia | 51133 | 5 | 0 |
81030 | 81030 | 2020-04-22 | Northumberland | Virginia | 51133 | 5 | 0 |
83831 | 83831 | 2020-04-23 | Northumberland | Virginia | 51133 | 6 | 0 |
86638 | 86638 | 2020-04-24 | Northumberland | Virginia | 51133 | 6 | 0 |
89453 | 89453 | 2020-04-25 | Northumberland | Virginia | 51133 | 8 | 0 |
92270 | 92270 | 2020-04-26 | Northumberland | Virginia | 51133 | 8 | 0 |
95099 | 95099 | 2020-04-27 | Northumberland | Virginia | 51133 | 8 | 0 |
97943 | 97943 | 2020-04-28 | Northumberland | Virginia | 51133 | 8 | 0 |
100793 | 100793 | 2020-04-29 | Northumberland | Virginia | 51133 | 8 | 0 |
103648 | 103648 | 2020-04-30 | Northumberland | Virginia | 51133 | 9 | 0 |
106512 | 106512 | 2020-05-01 | Northumberland | Virginia | 51133 | 9 | 0 |
109381 | 109381 | 2020-05-02 | Northumberland | Virginia | 51133 | 9 | 0 |
112255 | 112255 | 2020-05-03 | Northumberland | Virginia | 51133 | 9 | 0 |
115138 | 115138 | 2020-05-04 | Northumberland | Virginia | 51133 | 9 | 0 |
118097 | 118097 | 2020-05-05 | Northumberland | Virginia | 51133 | 9 | 0 |
121061 | 121061 | 2020-05-06 | Northumberland | Virginia | 51133 | 9 | 0 |
124042 | 124042 | 2020-05-07 | Northumberland | Virginia | 51133 | 9 | 1 |
127027 | 127027 | 2020-05-08 | Northumberland | Virginia | 51133 | 9 | 1 |
130017 | 130017 | 2020-05-09 | Northumberland | Virginia | 51133 | 9 | 1 |
133007 | 133007 | 2020-05-10 | Northumberland | Virginia | 51133 | 10 | 1 |
135997 | 135997 | 2020-05-11 | Northumberland | Virginia | 51133 | 10 | 1 |
138988 | 138988 | 2020-05-12 | Northumberland | Virginia | 51133 | 10 | 1 |
141984 | 141984 | 2020-05-13 | Northumberland | Virginia | 51133 | 11 | 1 |
144981 | 144981 | 2020-05-14 | Northumberland | Virginia | 51133 | 15 | 1 |
147984 | 147984 | 2020-05-15 | Northumberland | Virginia | 51133 | 15 | 1 |
150993 | 150993 | 2020-05-16 | Northumberland | Virginia | 51133 | 17 | 1 |
154004 | 154004 | 2020-05-17 | Northumberland | Virginia | 51133 | 18 | 1 |
157021 | 157021 | 2020-05-18 | Northumberland | Virginia | 51133 | 18 | 1 |
160045 | 160045 | 2020-05-19 | Northumberland | Virginia | 51133 | 20 | 1 |
163073 | 163073 | 2020-05-20 | Northumberland | Virginia | 51133 | 21 | 1 |
166102 | 166102 | 2020-05-21 | Northumberland | Virginia | 51133 | 21 | 1 |
169138 | 169138 | 2020-05-22 | Northumberland | Virginia | 51133 | 22 | 1 |
172179 | 172179 | 2020-05-23 | Northumberland | Virginia | 51133 | 22 | 1 |
175222 | 175222 | 2020-05-24 | Northumberland | Virginia | 51133 | 22 | 1 |
178267 | 178267 | 2020-05-25 | Northumberland | Virginia | 51133 | 23 | 1 |
181311 | 181311 | 2020-05-26 | Northumberland | Virginia | 51133 | 23 | 1 |
184362 | 184362 | 2020-05-27 | Northumberland | Virginia | 51133 | 23 | 1 |
187419 | 187419 | 2020-05-28 | Northumberland | Virginia | 51133 | 25 | 1 |
190483 | 190483 | 2020-05-29 | Northumberland | Virginia | 51133 | 25 | 1 |
193549 | 193549 | 2020-05-30 | Northumberland | Virginia | 51133 | 25 | 1 |
196619 | 196619 | 2020-05-31 | Northumberland | Virginia | 51133 | 25 | 1 |
199692 | 199692 | 2020-06-01 | Northumberland | Virginia | 51133 | 25 | 1 |
202768 | 202768 | 2020-06-02 | Northumberland | Virginia | 51133 | 25 | 1 |
205847 | 205847 | 2020-06-03 | Northumberland | Virginia | 51133 | 25 | 1 |
208929 | 208929 | 2020-06-04 | Northumberland | Virginia | 51133 | 25 | 1 |
212014 | 212014 | 2020-06-05 | Northumberland | Virginia | 51133 | 25 | 1 |
215101 | 215101 | 2020-06-06 | Northumberland | Virginia | 51133 | 25 | 1 |
218191 | 218191 | 2020-06-07 | Northumberland | Virginia | 51133 | 25 | 1 |
221283 | 221283 | 2020-06-08 | Northumberland | Virginia | 51133 | 25 | 1 |
224379 | 224379 | 2020-06-09 | Northumberland | Virginia | 51133 | 25 | 1 |
227479 | 227479 | 2020-06-10 | Northumberland | Virginia | 51133 | 25 | 1 |
230583 | 230583 | 2020-06-11 | Northumberland | Virginia | 51133 | 25 | 1 |
233688 | 233688 | 2020-06-12 | Northumberland | Virginia | 51133 | 25 | 1 |
236795 | 236795 | 2020-06-13 | Northumberland | Virginia | 51133 | 26 | 1 |
239903 | 239903 | 2020-06-14 | Northumberland | Virginia | 51133 | 26 | 1 |
243014 | 243014 | 2020-06-15 | Northumberland | Virginia | 51133 | 27 | 1 |
246127 | 246127 | 2020-06-16 | Northumberland | Virginia | 51133 | 27 | 1 |
249239 | 249239 | 2020-06-17 | Northumberland | Virginia | 51133 | 27 | 1 |
252354 | 252354 | 2020-06-18 | Northumberland | Virginia | 51133 | 27 | 1 |
255473 | 255473 | 2020-06-19 | Northumberland | Virginia | 51133 | 28 | 1 |
258600 | 258600 | 2020-06-20 | Northumberland | Virginia | 51133 | 28 | 1 |
261727 | 261727 | 2020-06-21 | Northumberland | Virginia | 51133 | 28 | 1 |
264856 | 264856 | 2020-06-22 | Northumberland | Virginia | 51133 | 28 | 1 |
267985 | 267985 | 2020-06-23 | Northumberland | Virginia | 51133 | 28 | 1 |
271119 | 271119 | 2020-06-24 | Northumberland | Virginia | 51133 | 28 | 1 |
274259 | 274259 | 2020-06-25 | Northumberland | Virginia | 51133 | 28 | 1 |
277407 | 277407 | 2020-06-26 | Northumberland | Virginia | 51133 | 38 | 1 |
280555 | 280555 | 2020-06-27 | Northumberland | Virginia | 51133 | 38 | 1 |
283701 | 283701 | 2020-06-28 | Northumberland | Virginia | 51133 | 38 | 1 |
286847 | 286847 | 2020-06-29 | Northumberland | Virginia | 51133 | 39 | 1 |
289997 | 289997 | 2020-06-30 | Northumberland | Virginia | 51133 | 37 | 1 |
293150 | 293150 | 2020-07-01 | Northumberland | Virginia | 51133 | 37 | 1 |
296305 | 296305 | 2020-07-02 | Northumberland | Virginia | 51133 | 37 | 1 |
299467 | 299467 | 2020-07-03 | Northumberland | Virginia | 51133 | 36 | 1 |
302631 | 302631 | 2020-07-04 | Northumberland | Virginia | 51133 | 36 | 1 |
305795 | 305795 | 2020-07-05 | Northumberland | Virginia | 51133 | 37 | 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);