ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 51735 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 |
---|---|---|---|---|---|---|---|
13904 | 13904 | 2020-03-26 | Poquoson city | Virginia | 51735 | 1 | 0 |
15672 | 15672 | 2020-03-27 | Poquoson city | Virginia | 51735 | 1 | 0 |
17551 | 17551 | 2020-03-28 | Poquoson city | Virginia | 51735 | 2 | 0 |
19513 | 19513 | 2020-03-29 | Poquoson city | Virginia | 51735 | 2 | 0 |
21579 | 21579 | 2020-03-30 | Poquoson city | Virginia | 51735 | 2 | 0 |
23726 | 23726 | 2020-03-31 | Poquoson city | Virginia | 51735 | 2 | 0 |
25942 | 25942 | 2020-04-01 | Poquoson city | Virginia | 51735 | 3 | 0 |
28232 | 28232 | 2020-04-02 | Poquoson city | Virginia | 51735 | 3 | 0 |
30579 | 30579 | 2020-04-03 | Poquoson city | Virginia | 51735 | 3 | 0 |
32978 | 32978 | 2020-04-04 | Poquoson city | Virginia | 51735 | 3 | 0 |
35416 | 35416 | 2020-04-05 | Poquoson city | Virginia | 51735 | 3 | 0 |
37899 | 37899 | 2020-04-06 | Poquoson city | Virginia | 51735 | 3 | 0 |
40433 | 40433 | 2020-04-07 | Poquoson city | Virginia | 51735 | 4 | 0 |
43002 | 43002 | 2020-04-08 | Poquoson city | Virginia | 51735 | 4 | 0 |
45598 | 45598 | 2020-04-09 | Poquoson city | Virginia | 51735 | 5 | 0 |
48224 | 48224 | 2020-04-10 | Poquoson city | Virginia | 51735 | 6 | 0 |
50882 | 50882 | 2020-04-11 | Poquoson city | Virginia | 51735 | 6 | 0 |
53557 | 53557 | 2020-04-12 | Poquoson city | Virginia | 51735 | 6 | 0 |
56247 | 56247 | 2020-04-13 | Poquoson city | Virginia | 51735 | 6 | 0 |
58953 | 58953 | 2020-04-14 | Poquoson city | Virginia | 51735 | 6 | 0 |
61672 | 61672 | 2020-04-15 | Poquoson city | Virginia | 51735 | 6 | 0 |
64405 | 64405 | 2020-04-16 | Poquoson city | Virginia | 51735 | 6 | 0 |
67153 | 67153 | 2020-04-17 | Poquoson city | Virginia | 51735 | 6 | 0 |
69915 | 69915 | 2020-04-18 | Poquoson city | Virginia | 51735 | 6 | 0 |
72685 | 72685 | 2020-04-19 | Poquoson city | Virginia | 51735 | 6 | 0 |
75461 | 75461 | 2020-04-20 | Poquoson city | Virginia | 51735 | 6 | 0 |
78245 | 78245 | 2020-04-21 | Poquoson city | Virginia | 51735 | 6 | 0 |
81038 | 81038 | 2020-04-22 | Poquoson city | Virginia | 51735 | 6 | 0 |
83839 | 83839 | 2020-04-23 | Poquoson city | Virginia | 51735 | 6 | 0 |
86646 | 86646 | 2020-04-24 | Poquoson city | Virginia | 51735 | 6 | 0 |
89461 | 89461 | 2020-04-25 | Poquoson city | Virginia | 51735 | 6 | 0 |
92278 | 92278 | 2020-04-26 | Poquoson city | Virginia | 51735 | 6 | 0 |
95107 | 95107 | 2020-04-27 | Poquoson city | Virginia | 51735 | 6 | 0 |
97951 | 97951 | 2020-04-28 | Poquoson city | Virginia | 51735 | 6 | 0 |
100801 | 100801 | 2020-04-29 | Poquoson city | Virginia | 51735 | 6 | 0 |
103656 | 103656 | 2020-04-30 | Poquoson city | Virginia | 51735 | 6 | 0 |
106520 | 106520 | 2020-05-01 | Poquoson city | Virginia | 51735 | 6 | 0 |
109389 | 109389 | 2020-05-02 | Poquoson city | Virginia | 51735 | 6 | 0 |
112263 | 112263 | 2020-05-03 | Poquoson city | Virginia | 51735 | 6 | 0 |
115146 | 115146 | 2020-05-04 | Poquoson city | Virginia | 51735 | 6 | 0 |
118105 | 118105 | 2020-05-05 | Poquoson city | Virginia | 51735 | 7 | 0 |
121069 | 121069 | 2020-05-06 | Poquoson city | Virginia | 51735 | 7 | 0 |
124050 | 124050 | 2020-05-07 | Poquoson city | Virginia | 51735 | 7 | 0 |
127035 | 127035 | 2020-05-08 | Poquoson city | Virginia | 51735 | 7 | 0 |
130025 | 130025 | 2020-05-09 | Poquoson city | Virginia | 51735 | 7 | 0 |
133015 | 133015 | 2020-05-10 | Poquoson city | Virginia | 51735 | 7 | 0 |
136005 | 136005 | 2020-05-11 | Poquoson city | Virginia | 51735 | 7 | 0 |
138996 | 138996 | 2020-05-12 | Poquoson city | Virginia | 51735 | 7 | 0 |
141992 | 141992 | 2020-05-13 | Poquoson city | Virginia | 51735 | 7 | 0 |
144989 | 144989 | 2020-05-14 | Poquoson city | Virginia | 51735 | 7 | 0 |
147992 | 147992 | 2020-05-15 | Poquoson city | Virginia | 51735 | 7 | 0 |
151001 | 151001 | 2020-05-16 | Poquoson city | Virginia | 51735 | 7 | 0 |
154012 | 154012 | 2020-05-17 | Poquoson city | Virginia | 51735 | 7 | 0 |
157029 | 157029 | 2020-05-18 | Poquoson city | Virginia | 51735 | 7 | 0 |
160053 | 160053 | 2020-05-19 | Poquoson city | Virginia | 51735 | 7 | 0 |
163081 | 163081 | 2020-05-20 | Poquoson city | Virginia | 51735 | 7 | 0 |
166110 | 166110 | 2020-05-21 | Poquoson city | Virginia | 51735 | 7 | 0 |
169146 | 169146 | 2020-05-22 | Poquoson city | Virginia | 51735 | 7 | 0 |
172187 | 172187 | 2020-05-23 | Poquoson city | Virginia | 51735 | 7 | 0 |
175230 | 175230 | 2020-05-24 | Poquoson city | Virginia | 51735 | 7 | 0 |
178275 | 178275 | 2020-05-25 | Poquoson city | Virginia | 51735 | 7 | 0 |
181319 | 181319 | 2020-05-26 | Poquoson city | Virginia | 51735 | 7 | 0 |
184370 | 184370 | 2020-05-27 | Poquoson city | Virginia | 51735 | 7 | 0 |
187427 | 187427 | 2020-05-28 | Poquoson city | Virginia | 51735 | 7 | 0 |
190491 | 190491 | 2020-05-29 | Poquoson city | Virginia | 51735 | 7 | 0 |
193557 | 193557 | 2020-05-30 | Poquoson city | Virginia | 51735 | 7 | 0 |
196627 | 196627 | 2020-05-31 | Poquoson city | Virginia | 51735 | 8 | 0 |
199700 | 199700 | 2020-06-01 | Poquoson city | Virginia | 51735 | 8 | 0 |
202776 | 202776 | 2020-06-02 | Poquoson city | Virginia | 51735 | 8 | 0 |
205855 | 205855 | 2020-06-03 | Poquoson city | Virginia | 51735 | 8 | 0 |
208937 | 208937 | 2020-06-04 | Poquoson city | Virginia | 51735 | 8 | 0 |
212022 | 212022 | 2020-06-05 | Poquoson city | Virginia | 51735 | 8 | 0 |
215109 | 215109 | 2020-06-06 | Poquoson city | Virginia | 51735 | 8 | 0 |
218199 | 218199 | 2020-06-07 | Poquoson city | Virginia | 51735 | 9 | 0 |
221291 | 221291 | 2020-06-08 | Poquoson city | Virginia | 51735 | 9 | 0 |
224387 | 224387 | 2020-06-09 | Poquoson city | Virginia | 51735 | 9 | 0 |
227487 | 227487 | 2020-06-10 | Poquoson city | Virginia | 51735 | 9 | 0 |
230591 | 230591 | 2020-06-11 | Poquoson city | Virginia | 51735 | 10 | 0 |
233696 | 233696 | 2020-06-12 | Poquoson city | Virginia | 51735 | 11 | 0 |
236803 | 236803 | 2020-06-13 | Poquoson city | Virginia | 51735 | 11 | 0 |
239911 | 239911 | 2020-06-14 | Poquoson city | Virginia | 51735 | 11 | 0 |
243022 | 243022 | 2020-06-15 | Poquoson city | Virginia | 51735 | 12 | 0 |
246135 | 246135 | 2020-06-16 | Poquoson city | Virginia | 51735 | 12 | 0 |
249247 | 249247 | 2020-06-17 | Poquoson city | Virginia | 51735 | 12 | 0 |
252362 | 252362 | 2020-06-18 | Poquoson city | Virginia | 51735 | 12 | 0 |
255481 | 255481 | 2020-06-19 | Poquoson city | Virginia | 51735 | 12 | 0 |
258608 | 258608 | 2020-06-20 | Poquoson city | Virginia | 51735 | 14 | 0 |
261735 | 261735 | 2020-06-21 | Poquoson city | Virginia | 51735 | 16 | 0 |
264864 | 264864 | 2020-06-22 | Poquoson city | Virginia | 51735 | 16 | 0 |
267993 | 267993 | 2020-06-23 | Poquoson city | Virginia | 51735 | 16 | 0 |
271127 | 271127 | 2020-06-24 | Poquoson city | Virginia | 51735 | 16 | 0 |
274267 | 274267 | 2020-06-25 | Poquoson city | Virginia | 51735 | 16 | 0 |
277415 | 277415 | 2020-06-26 | Poquoson city | Virginia | 51735 | 17 | 0 |
280563 | 280563 | 2020-06-27 | Poquoson city | Virginia | 51735 | 19 | 0 |
283709 | 283709 | 2020-06-28 | Poquoson city | Virginia | 51735 | 19 | 0 |
286855 | 286855 | 2020-06-29 | Poquoson city | Virginia | 51735 | 19 | 0 |
290005 | 290005 | 2020-06-30 | Poquoson city | Virginia | 51735 | 19 | 0 |
293158 | 293158 | 2020-07-01 | Poquoson city | Virginia | 51735 | 19 | 0 |
296313 | 296313 | 2020-07-02 | Poquoson city | Virginia | 51735 | 19 | 0 |
299475 | 299475 | 2020-07-03 | Poquoson city | Virginia | 51735 | 19 | 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);