ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 51595 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 |
---|---|---|---|---|---|---|---|
30531 | 30531 | 2020-04-03 | Emporia city | Virginia | 51595 | 1 | 0 |
32930 | 32930 | 2020-04-04 | Emporia city | Virginia | 51595 | 2 | 0 |
35368 | 35368 | 2020-04-05 | Emporia city | Virginia | 51595 | 2 | 0 |
37850 | 37850 | 2020-04-06 | Emporia city | Virginia | 51595 | 2 | 0 |
40383 | 40383 | 2020-04-07 | Emporia city | Virginia | 51595 | 2 | 0 |
42952 | 42952 | 2020-04-08 | Emporia city | Virginia | 51595 | 4 | 0 |
45546 | 45546 | 2020-04-09 | Emporia city | Virginia | 51595 | 5 | 0 |
48171 | 48171 | 2020-04-10 | Emporia city | Virginia | 51595 | 5 | 0 |
50829 | 50829 | 2020-04-11 | Emporia city | Virginia | 51595 | 7 | 0 |
53504 | 53504 | 2020-04-12 | Emporia city | Virginia | 51595 | 7 | 0 |
56193 | 56193 | 2020-04-13 | Emporia city | Virginia | 51595 | 7 | 0 |
58899 | 58899 | 2020-04-14 | Emporia city | Virginia | 51595 | 8 | 0 |
61618 | 61618 | 2020-04-15 | Emporia city | Virginia | 51595 | 7 | 0 |
64350 | 64350 | 2020-04-16 | Emporia city | Virginia | 51595 | 7 | 0 |
67098 | 67098 | 2020-04-17 | Emporia city | Virginia | 51595 | 7 | 0 |
69860 | 69860 | 2020-04-18 | Emporia city | Virginia | 51595 | 7 | 0 |
72630 | 72630 | 2020-04-19 | Emporia city | Virginia | 51595 | 7 | 0 |
75406 | 75406 | 2020-04-20 | Emporia city | Virginia | 51595 | 11 | 0 |
78188 | 78188 | 2020-04-21 | Emporia city | Virginia | 51595 | 12 | 1 |
80980 | 80980 | 2020-04-22 | Emporia city | Virginia | 51595 | 12 | 1 |
83781 | 83781 | 2020-04-23 | Emporia city | Virginia | 51595 | 18 | 1 |
86588 | 86588 | 2020-04-24 | Emporia city | Virginia | 51595 | 18 | 1 |
89403 | 89403 | 2020-04-25 | Emporia city | Virginia | 51595 | 18 | 1 |
92220 | 92220 | 2020-04-26 | Emporia city | Virginia | 51595 | 18 | 2 |
95049 | 95049 | 2020-04-27 | Emporia city | Virginia | 51595 | 20 | 2 |
97891 | 97891 | 2020-04-28 | Emporia city | Virginia | 51595 | 20 | 2 |
100741 | 100741 | 2020-04-29 | Emporia city | Virginia | 51595 | 22 | 2 |
103596 | 103596 | 2020-04-30 | Emporia city | Virginia | 51595 | 23 | 2 |
106460 | 106460 | 2020-05-01 | Emporia city | Virginia | 51595 | 23 | 2 |
109329 | 109329 | 2020-05-02 | Emporia city | Virginia | 51595 | 23 | 2 |
112203 | 112203 | 2020-05-03 | Emporia city | Virginia | 51595 | 24 | 3 |
115086 | 115086 | 2020-05-04 | Emporia city | Virginia | 51595 | 46 | 3 |
118045 | 118045 | 2020-05-05 | Emporia city | Virginia | 51595 | 46 | 3 |
121009 | 121009 | 2020-05-06 | Emporia city | Virginia | 51595 | 46 | 3 |
123990 | 123990 | 2020-05-07 | Emporia city | Virginia | 51595 | 47 | 3 |
126975 | 126975 | 2020-05-08 | Emporia city | Virginia | 51595 | 47 | 3 |
129965 | 129965 | 2020-05-09 | Emporia city | Virginia | 51595 | 47 | 3 |
132955 | 132955 | 2020-05-10 | Emporia city | Virginia | 51595 | 48 | 3 |
135945 | 135945 | 2020-05-11 | Emporia city | Virginia | 51595 | 49 | 3 |
138936 | 138936 | 2020-05-12 | Emporia city | Virginia | 51595 | 49 | 3 |
141932 | 141932 | 2020-05-13 | Emporia city | Virginia | 51595 | 50 | 3 |
144929 | 144929 | 2020-05-14 | Emporia city | Virginia | 51595 | 50 | 3 |
147932 | 147932 | 2020-05-15 | Emporia city | Virginia | 51595 | 50 | 3 |
150941 | 150941 | 2020-05-16 | Emporia city | Virginia | 51595 | 50 | 3 |
153952 | 153952 | 2020-05-17 | Emporia city | Virginia | 51595 | 52 | 3 |
156969 | 156969 | 2020-05-18 | Emporia city | Virginia | 51595 | 55 | 3 |
159993 | 159993 | 2020-05-19 | Emporia city | Virginia | 51595 | 58 | 3 |
163021 | 163021 | 2020-05-20 | Emporia city | Virginia | 51595 | 58 | 3 |
166050 | 166050 | 2020-05-21 | Emporia city | Virginia | 51595 | 58 | 3 |
169086 | 169086 | 2020-05-22 | Emporia city | Virginia | 51595 | 60 | 3 |
172127 | 172127 | 2020-05-23 | Emporia city | Virginia | 51595 | 60 | 3 |
175170 | 175170 | 2020-05-24 | Emporia city | Virginia | 51595 | 60 | 3 |
178215 | 178215 | 2020-05-25 | Emporia city | Virginia | 51595 | 62 | 5 |
181259 | 181259 | 2020-05-26 | Emporia city | Virginia | 51595 | 62 | 5 |
184310 | 184310 | 2020-05-27 | Emporia city | Virginia | 51595 | 70 | 5 |
187367 | 187367 | 2020-05-28 | Emporia city | Virginia | 51595 | 76 | 5 |
190431 | 190431 | 2020-05-29 | Emporia city | Virginia | 51595 | 78 | 5 |
193497 | 193497 | 2020-05-30 | Emporia city | Virginia | 51595 | 78 | 5 |
196567 | 196567 | 2020-05-31 | Emporia city | Virginia | 51595 | 79 | 5 |
199640 | 199640 | 2020-06-01 | Emporia city | Virginia | 51595 | 82 | 6 |
202716 | 202716 | 2020-06-02 | Emporia city | Virginia | 51595 | 82 | 6 |
205795 | 205795 | 2020-06-03 | Emporia city | Virginia | 51595 | 86 | 6 |
208877 | 208877 | 2020-06-04 | Emporia city | Virginia | 51595 | 89 | 6 |
211962 | 211962 | 2020-06-05 | Emporia city | Virginia | 51595 | 86 | 6 |
215049 | 215049 | 2020-06-06 | Emporia city | Virginia | 51595 | 88 | 6 |
218139 | 218139 | 2020-06-07 | Emporia city | Virginia | 51595 | 89 | 6 |
221231 | 221231 | 2020-06-08 | Emporia city | Virginia | 51595 | 89 | 6 |
224327 | 224327 | 2020-06-09 | Emporia city | Virginia | 51595 | 91 | 6 |
227427 | 227427 | 2020-06-10 | Emporia city | Virginia | 51595 | 93 | 6 |
230531 | 230531 | 2020-06-11 | Emporia city | Virginia | 51595 | 94 | 6 |
233636 | 233636 | 2020-06-12 | Emporia city | Virginia | 51595 | 94 | 6 |
236743 | 236743 | 2020-06-13 | Emporia city | Virginia | 51595 | 95 | 6 |
239851 | 239851 | 2020-06-14 | Emporia city | Virginia | 51595 | 97 | 6 |
242962 | 242962 | 2020-06-15 | Emporia city | Virginia | 51595 | 98 | 6 |
246075 | 246075 | 2020-06-16 | Emporia city | Virginia | 51595 | 101 | 6 |
249187 | 249187 | 2020-06-17 | Emporia city | Virginia | 51595 | 106 | 6 |
252302 | 252302 | 2020-06-18 | Emporia city | Virginia | 51595 | 107 | 6 |
255421 | 255421 | 2020-06-19 | Emporia city | Virginia | 51595 | 112 | 6 |
258548 | 258548 | 2020-06-20 | Emporia city | Virginia | 51595 | 112 | 6 |
261675 | 261675 | 2020-06-21 | Emporia city | Virginia | 51595 | 112 | 6 |
264804 | 264804 | 2020-06-22 | Emporia city | Virginia | 51595 | 116 | 6 |
267933 | 267933 | 2020-06-23 | Emporia city | Virginia | 51595 | 118 | 6 |
271067 | 271067 | 2020-06-24 | Emporia city | Virginia | 51595 | 123 | 6 |
274207 | 274207 | 2020-06-25 | Emporia city | Virginia | 51595 | 124 | 6 |
277355 | 277355 | 2020-06-26 | Emporia city | Virginia | 51595 | 127 | 6 |
280503 | 280503 | 2020-06-27 | Emporia city | Virginia | 51595 | 133 | 10 |
283649 | 283649 | 2020-06-28 | Emporia city | Virginia | 51595 | 133 | 10 |
286795 | 286795 | 2020-06-29 | Emporia city | Virginia | 51595 | 133 | 12 |
289945 | 289945 | 2020-06-30 | Emporia city | Virginia | 51595 | 136 | 14 |
293098 | 293098 | 2020-07-01 | Emporia city | Virginia | 51595 | 137 | 14 |
296253 | 296253 | 2020-07-02 | Emporia city | Virginia | 51595 | 140 | 14 |
299415 | 299415 | 2020-07-03 | Emporia city | Virginia | 51595 | 141 | 15 |
302579 | 302579 | 2020-07-04 | Emporia city | Virginia | 51595 | 141 | 15 |
305743 | 305743 | 2020-07-05 | Emporia city | Virginia | 51595 | 143 | 15 |
308911 | 308911 | 2020-07-06 | Emporia city | Virginia | 51595 | 143 | 15 |
312080 | 312080 | 2020-07-07 | Emporia city | Virginia | 51595 | 145 | 15 |
315255 | 315255 | 2020-07-08 | Emporia city | Virginia | 51595 | 145 | 15 |
318428 | 318428 | 2020-07-09 | Emporia city | Virginia | 51595 | 147 | 15 |
321607 | 321607 | 2020-07-10 | Emporia city | Virginia | 51595 | 147 | 15 |
324788 | 324788 | 2020-07-11 | Emporia city | Virginia | 51595 | 146 | 15 |
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);