ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 51775 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 |
---|---|---|---|---|---|---|---|
28244 | 28244 | 2020-04-02 | Salem city | Virginia | 51775 | 1 | 0 |
30593 | 30593 | 2020-04-03 | Salem city | Virginia | 51775 | 1 | 0 |
32992 | 32992 | 2020-04-04 | Salem city | Virginia | 51775 | 1 | 0 |
35430 | 35430 | 2020-04-05 | Salem city | Virginia | 51775 | 1 | 0 |
37914 | 37914 | 2020-04-06 | Salem city | Virginia | 51775 | 1 | 0 |
40449 | 40449 | 2020-04-07 | Salem city | Virginia | 51775 | 1 | 0 |
43018 | 43018 | 2020-04-08 | Salem city | Virginia | 51775 | 1 | 0 |
45614 | 45614 | 2020-04-09 | Salem city | Virginia | 51775 | 1 | 0 |
48240 | 48240 | 2020-04-10 | Salem city | Virginia | 51775 | 1 | 0 |
50898 | 50898 | 2020-04-11 | Salem city | Virginia | 51775 | 1 | 0 |
53573 | 53573 | 2020-04-12 | Salem city | Virginia | 51775 | 1 | 0 |
56263 | 56263 | 2020-04-13 | Salem city | Virginia | 51775 | 1 | 0 |
58969 | 58969 | 2020-04-14 | Salem city | Virginia | 51775 | 3 | 0 |
61688 | 61688 | 2020-04-15 | Salem city | Virginia | 51775 | 3 | 0 |
64421 | 64421 | 2020-04-16 | Salem city | Virginia | 51775 | 4 | 0 |
67169 | 67169 | 2020-04-17 | Salem city | Virginia | 51775 | 6 | 0 |
69931 | 69931 | 2020-04-18 | Salem city | Virginia | 51775 | 6 | 0 |
72701 | 72701 | 2020-04-19 | Salem city | Virginia | 51775 | 6 | 0 |
75477 | 75477 | 2020-04-20 | Salem city | Virginia | 51775 | 6 | 0 |
78261 | 78261 | 2020-04-21 | Salem city | Virginia | 51775 | 6 | 0 |
81054 | 81054 | 2020-04-22 | Salem city | Virginia | 51775 | 8 | 0 |
83855 | 83855 | 2020-04-23 | Salem city | Virginia | 51775 | 8 | 0 |
86662 | 86662 | 2020-04-24 | Salem city | Virginia | 51775 | 8 | 0 |
89477 | 89477 | 2020-04-25 | Salem city | Virginia | 51775 | 8 | 0 |
92294 | 92294 | 2020-04-26 | Salem city | Virginia | 51775 | 9 | 0 |
95123 | 95123 | 2020-04-27 | Salem city | Virginia | 51775 | 11 | 0 |
97967 | 97967 | 2020-04-28 | Salem city | Virginia | 51775 | 12 | 0 |
100817 | 100817 | 2020-04-29 | Salem city | Virginia | 51775 | 16 | 0 |
103672 | 103672 | 2020-04-30 | Salem city | Virginia | 51775 | 26 | 0 |
106536 | 106536 | 2020-05-01 | Salem city | Virginia | 51775 | 26 | 0 |
109405 | 109405 | 2020-05-02 | Salem city | Virginia | 51775 | 26 | 0 |
112279 | 112279 | 2020-05-03 | Salem city | Virginia | 51775 | 26 | 0 |
115162 | 115162 | 2020-05-04 | Salem city | Virginia | 51775 | 27 | 0 |
118121 | 118121 | 2020-05-05 | Salem city | Virginia | 51775 | 31 | 0 |
121085 | 121085 | 2020-05-06 | Salem city | Virginia | 51775 | 31 | 0 |
124066 | 124066 | 2020-05-07 | Salem city | Virginia | 51775 | 30 | 0 |
127051 | 127051 | 2020-05-08 | Salem city | Virginia | 51775 | 30 | 0 |
130041 | 130041 | 2020-05-09 | Salem city | Virginia | 51775 | 31 | 0 |
133031 | 133031 | 2020-05-10 | Salem city | Virginia | 51775 | 31 | 0 |
136021 | 136021 | 2020-05-11 | Salem city | Virginia | 51775 | 32 | 0 |
139012 | 139012 | 2020-05-12 | Salem city | Virginia | 51775 | 32 | 0 |
142008 | 142008 | 2020-05-13 | Salem city | Virginia | 51775 | 32 | 0 |
145005 | 145005 | 2020-05-14 | Salem city | Virginia | 51775 | 32 | 0 |
148008 | 148008 | 2020-05-15 | Salem city | Virginia | 51775 | 32 | 0 |
151017 | 151017 | 2020-05-16 | Salem city | Virginia | 51775 | 32 | 0 |
154028 | 154028 | 2020-05-17 | Salem city | Virginia | 51775 | 32 | 0 |
157045 | 157045 | 2020-05-18 | Salem city | Virginia | 51775 | 32 | 0 |
160069 | 160069 | 2020-05-19 | Salem city | Virginia | 51775 | 33 | 0 |
163097 | 163097 | 2020-05-20 | Salem city | Virginia | 51775 | 33 | 0 |
166126 | 166126 | 2020-05-21 | Salem city | Virginia | 51775 | 33 | 0 |
169162 | 169162 | 2020-05-22 | Salem city | Virginia | 51775 | 32 | 3 |
172203 | 172203 | 2020-05-23 | Salem city | Virginia | 51775 | 32 | 3 |
175246 | 175246 | 2020-05-24 | Salem city | Virginia | 51775 | 32 | 3 |
178291 | 178291 | 2020-05-25 | Salem city | Virginia | 51775 | 32 | 3 |
181335 | 181335 | 2020-05-26 | Salem city | Virginia | 51775 | 32 | 3 |
184386 | 184386 | 2020-05-27 | Salem city | Virginia | 51775 | 32 | 3 |
187443 | 187443 | 2020-05-28 | Salem city | Virginia | 51775 | 32 | 3 |
190507 | 190507 | 2020-05-29 | Salem city | Virginia | 51775 | 34 | 3 |
193573 | 193573 | 2020-05-30 | Salem city | Virginia | 51775 | 34 | 3 |
196643 | 196643 | 2020-05-31 | Salem city | Virginia | 51775 | 34 | 3 |
199716 | 199716 | 2020-06-01 | Salem city | Virginia | 51775 | 34 | 3 |
202792 | 202792 | 2020-06-02 | Salem city | Virginia | 51775 | 34 | 3 |
205871 | 205871 | 2020-06-03 | Salem city | Virginia | 51775 | 36 | 3 |
208953 | 208953 | 2020-06-04 | Salem city | Virginia | 51775 | 36 | 3 |
212038 | 212038 | 2020-06-05 | Salem city | Virginia | 51775 | 37 | 3 |
215125 | 215125 | 2020-06-06 | Salem city | Virginia | 51775 | 38 | 3 |
218215 | 218215 | 2020-06-07 | Salem city | Virginia | 51775 | 38 | 3 |
221307 | 221307 | 2020-06-08 | Salem city | Virginia | 51775 | 40 | 3 |
224403 | 224403 | 2020-06-09 | Salem city | Virginia | 51775 | 41 | 3 |
227503 | 227503 | 2020-06-10 | Salem city | Virginia | 51775 | 42 | 3 |
230607 | 230607 | 2020-06-11 | Salem city | Virginia | 51775 | 42 | 3 |
233712 | 233712 | 2020-06-12 | Salem city | Virginia | 51775 | 43 | 3 |
236819 | 236819 | 2020-06-13 | Salem city | Virginia | 51775 | 43 | 3 |
239927 | 239927 | 2020-06-14 | Salem city | Virginia | 51775 | 44 | 3 |
243038 | 243038 | 2020-06-15 | Salem city | Virginia | 51775 | 44 | 3 |
246151 | 246151 | 2020-06-16 | Salem city | Virginia | 51775 | 47 | 3 |
249263 | 249263 | 2020-06-17 | Salem city | Virginia | 51775 | 48 | 3 |
252378 | 252378 | 2020-06-18 | Salem city | Virginia | 51775 | 48 | 3 |
255497 | 255497 | 2020-06-19 | Salem city | Virginia | 51775 | 49 | 3 |
258624 | 258624 | 2020-06-20 | Salem city | Virginia | 51775 | 50 | 3 |
261751 | 261751 | 2020-06-21 | Salem city | Virginia | 51775 | 50 | 3 |
264880 | 264880 | 2020-06-22 | Salem city | Virginia | 51775 | 50 | 3 |
268009 | 268009 | 2020-06-23 | Salem city | Virginia | 51775 | 50 | 3 |
271143 | 271143 | 2020-06-24 | Salem city | Virginia | 51775 | 50 | 3 |
274283 | 274283 | 2020-06-25 | Salem city | Virginia | 51775 | 50 | 3 |
277431 | 277431 | 2020-06-26 | Salem city | Virginia | 51775 | 50 | 3 |
280579 | 280579 | 2020-06-27 | Salem city | Virginia | 51775 | 51 | 3 |
283725 | 283725 | 2020-06-28 | Salem city | Virginia | 51775 | 51 | 3 |
286871 | 286871 | 2020-06-29 | Salem city | Virginia | 51775 | 59 | 3 |
290021 | 290021 | 2020-06-30 | Salem city | Virginia | 51775 | 68 | 3 |
293174 | 293174 | 2020-07-01 | Salem city | Virginia | 51775 | 69 | 3 |
296329 | 296329 | 2020-07-02 | Salem city | Virginia | 51775 | 70 | 3 |
299491 | 299491 | 2020-07-03 | Salem city | Virginia | 51775 | 78 | 3 |
302655 | 302655 | 2020-07-04 | Salem city | Virginia | 51775 | 78 | 3 |
305819 | 305819 | 2020-07-05 | Salem city | Virginia | 51775 | 78 | 3 |
308987 | 308987 | 2020-07-06 | Salem city | Virginia | 51775 | 80 | 3 |
312156 | 312156 | 2020-07-07 | Salem city | Virginia | 51775 | 83 | 3 |
315331 | 315331 | 2020-07-08 | Salem city | Virginia | 51775 | 83 | 3 |
318504 | 318504 | 2020-07-09 | Salem city | Virginia | 51775 | 84 | 3 |
321683 | 321683 | 2020-07-10 | Salem city | Virginia | 51775 | 87 | 3 |
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);