ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 51630 and state = "Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12239 | 12239 | 2020-03-25 | Fredericksburg city | Virginia | 51630 | 1 | 0 |
13877 | 13877 | 2020-03-26 | Fredericksburg city | Virginia | 51630 | 1 | 0 |
15644 | 15644 | 2020-03-27 | Fredericksburg city | Virginia | 51630 | 1 | 0 |
17518 | 17518 | 2020-03-28 | Fredericksburg city | Virginia | 51630 | 1 | 0 |
19478 | 19478 | 2020-03-29 | Fredericksburg city | Virginia | 51630 | 1 | 0 |
21541 | 21541 | 2020-03-30 | Fredericksburg city | Virginia | 51630 | 1 | 0 |
23686 | 23686 | 2020-03-31 | Fredericksburg city | Virginia | 51630 | 1 | 0 |
25902 | 25902 | 2020-04-01 | Fredericksburg city | Virginia | 51630 | 1 | 0 |
28192 | 28192 | 2020-04-02 | Fredericksburg city | Virginia | 51630 | 2 | 0 |
30538 | 30538 | 2020-04-03 | Fredericksburg city | Virginia | 51630 | 4 | 0 |
32937 | 32937 | 2020-04-04 | Fredericksburg city | Virginia | 51630 | 7 | 0 |
35375 | 35375 | 2020-04-05 | Fredericksburg city | Virginia | 51630 | 7 | 0 |
37857 | 37857 | 2020-04-06 | Fredericksburg city | Virginia | 51630 | 7 | 0 |
40390 | 40390 | 2020-04-07 | Fredericksburg city | Virginia | 51630 | 8 | 0 |
42959 | 42959 | 2020-04-08 | Fredericksburg city | Virginia | 51630 | 8 | 0 |
45554 | 45554 | 2020-04-09 | Fredericksburg city | Virginia | 51630 | 10 | 0 |
48180 | 48180 | 2020-04-10 | Fredericksburg city | Virginia | 51630 | 10 | 0 |
50838 | 50838 | 2020-04-11 | Fredericksburg city | Virginia | 51630 | 11 | 0 |
53513 | 53513 | 2020-04-12 | Fredericksburg city | Virginia | 51630 | 12 | 0 |
56203 | 56203 | 2020-04-13 | Fredericksburg city | Virginia | 51630 | 13 | 0 |
58909 | 58909 | 2020-04-14 | Fredericksburg city | Virginia | 51630 | 14 | 0 |
61628 | 61628 | 2020-04-15 | Fredericksburg city | Virginia | 51630 | 15 | 0 |
64361 | 64361 | 2020-04-16 | Fredericksburg city | Virginia | 51630 | 15 | 0 |
67109 | 67109 | 2020-04-17 | Fredericksburg city | Virginia | 51630 | 15 | 0 |
69871 | 69871 | 2020-04-18 | Fredericksburg city | Virginia | 51630 | 15 | 0 |
72641 | 72641 | 2020-04-19 | Fredericksburg city | Virginia | 51630 | 17 | 0 |
75417 | 75417 | 2020-04-20 | Fredericksburg city | Virginia | 51630 | 17 | 0 |
78199 | 78199 | 2020-04-21 | Fredericksburg city | Virginia | 51630 | 17 | 0 |
80991 | 80991 | 2020-04-22 | Fredericksburg city | Virginia | 51630 | 17 | 0 |
83792 | 83792 | 2020-04-23 | Fredericksburg city | Virginia | 51630 | 20 | 0 |
86599 | 86599 | 2020-04-24 | Fredericksburg city | Virginia | 51630 | 21 | 0 |
89414 | 89414 | 2020-04-25 | Fredericksburg city | Virginia | 51630 | 23 | 0 |
92231 | 92231 | 2020-04-26 | Fredericksburg city | Virginia | 51630 | 23 | 0 |
95060 | 95060 | 2020-04-27 | Fredericksburg city | Virginia | 51630 | 24 | 0 |
97902 | 97902 | 2020-04-28 | Fredericksburg city | Virginia | 51630 | 27 | 0 |
100752 | 100752 | 2020-04-29 | Fredericksburg city | Virginia | 51630 | 28 | 0 |
103607 | 103607 | 2020-04-30 | Fredericksburg city | Virginia | 51630 | 33 | 0 |
106471 | 106471 | 2020-05-01 | Fredericksburg city | Virginia | 51630 | 34 | 0 |
109340 | 109340 | 2020-05-02 | Fredericksburg city | Virginia | 51630 | 37 | 0 |
112214 | 112214 | 2020-05-03 | Fredericksburg city | Virginia | 51630 | 39 | 0 |
115097 | 115097 | 2020-05-04 | Fredericksburg city | Virginia | 51630 | 45 | 0 |
118056 | 118056 | 2020-05-05 | Fredericksburg city | Virginia | 51630 | 45 | 0 |
121020 | 121020 | 2020-05-06 | Fredericksburg city | Virginia | 51630 | 45 | 0 |
124001 | 124001 | 2020-05-07 | Fredericksburg city | Virginia | 51630 | 52 | 0 |
126986 | 126986 | 2020-05-08 | Fredericksburg city | Virginia | 51630 | 55 | 0 |
129976 | 129976 | 2020-05-09 | Fredericksburg city | Virginia | 51630 | 58 | 0 |
132966 | 132966 | 2020-05-10 | Fredericksburg city | Virginia | 51630 | 61 | 0 |
135956 | 135956 | 2020-05-11 | Fredericksburg city | Virginia | 51630 | 61 | 0 |
138947 | 138947 | 2020-05-12 | Fredericksburg city | Virginia | 51630 | 66 | 0 |
141943 | 141943 | 2020-05-13 | Fredericksburg city | Virginia | 51630 | 72 | 0 |
144940 | 144940 | 2020-05-14 | Fredericksburg city | Virginia | 51630 | 80 | 0 |
147943 | 147943 | 2020-05-15 | Fredericksburg city | Virginia | 51630 | 82 | 0 |
150952 | 150952 | 2020-05-16 | Fredericksburg city | Virginia | 51630 | 89 | 0 |
153963 | 153963 | 2020-05-17 | Fredericksburg city | Virginia | 51630 | 93 | 0 |
156980 | 156980 | 2020-05-18 | Fredericksburg city | Virginia | 51630 | 96 | 0 |
160004 | 160004 | 2020-05-19 | Fredericksburg city | Virginia | 51630 | 101 | 0 |
163032 | 163032 | 2020-05-20 | Fredericksburg city | Virginia | 51630 | 101 | 0 |
166061 | 166061 | 2020-05-21 | Fredericksburg city | Virginia | 51630 | 107 | 0 |
169097 | 169097 | 2020-05-22 | Fredericksburg city | Virginia | 51630 | 109 | 0 |
172138 | 172138 | 2020-05-23 | Fredericksburg city | Virginia | 51630 | 113 | 0 |
175181 | 175181 | 2020-05-24 | Fredericksburg city | Virginia | 51630 | 118 | 0 |
178226 | 178226 | 2020-05-25 | Fredericksburg city | Virginia | 51630 | 123 | 0 |
181270 | 181270 | 2020-05-26 | Fredericksburg city | Virginia | 51630 | 136 | 0 |
184321 | 184321 | 2020-05-27 | Fredericksburg city | Virginia | 51630 | 135 | 0 |
187378 | 187378 | 2020-05-28 | Fredericksburg city | Virginia | 51630 | 142 | 0 |
190442 | 190442 | 2020-05-29 | Fredericksburg city | Virginia | 51630 | 147 | 0 |
193508 | 193508 | 2020-05-30 | Fredericksburg city | Virginia | 51630 | 158 | 0 |
196578 | 196578 | 2020-05-31 | Fredericksburg city | Virginia | 51630 | 164 | 0 |
199651 | 199651 | 2020-06-01 | Fredericksburg city | Virginia | 51630 | 166 | 0 |
202727 | 202727 | 2020-06-02 | Fredericksburg city | Virginia | 51630 | 172 | 0 |
205806 | 205806 | 2020-06-03 | Fredericksburg city | Virginia | 51630 | 172 | 0 |
208888 | 208888 | 2020-06-04 | Fredericksburg city | Virginia | 51630 | 178 | 1 |
211973 | 211973 | 2020-06-05 | Fredericksburg city | Virginia | 51630 | 186 | 0 |
215060 | 215060 | 2020-06-06 | Fredericksburg city | Virginia | 51630 | 192 | 0 |
218150 | 218150 | 2020-06-07 | Fredericksburg city | Virginia | 51630 | 208 | 0 |
221242 | 221242 | 2020-06-08 | Fredericksburg city | Virginia | 51630 | 196 | 0 |
224338 | 224338 | 2020-06-09 | Fredericksburg city | Virginia | 51630 | 193 | 0 |
227438 | 227438 | 2020-06-10 | Fredericksburg city | Virginia | 51630 | 194 | 0 |
230542 | 230542 | 2020-06-11 | Fredericksburg city | Virginia | 51630 | 197 | 0 |
233647 | 233647 | 2020-06-12 | Fredericksburg city | Virginia | 51630 | 199 | 0 |
236754 | 236754 | 2020-06-13 | Fredericksburg city | Virginia | 51630 | 201 | 0 |
239862 | 239862 | 2020-06-14 | Fredericksburg city | Virginia | 51630 | 208 | 0 |
242973 | 242973 | 2020-06-15 | Fredericksburg city | Virginia | 51630 | 211 | 0 |
246086 | 246086 | 2020-06-16 | Fredericksburg city | Virginia | 51630 | 213 | 0 |
249198 | 249198 | 2020-06-17 | Fredericksburg city | Virginia | 51630 | 215 | 0 |
252313 | 252313 | 2020-06-18 | Fredericksburg city | Virginia | 51630 | 218 | 0 |
255432 | 255432 | 2020-06-19 | Fredericksburg city | Virginia | 51630 | 219 | 0 |
258559 | 258559 | 2020-06-20 | Fredericksburg city | Virginia | 51630 | 223 | 0 |
261686 | 261686 | 2020-06-21 | Fredericksburg city | Virginia | 51630 | 227 | 0 |
264815 | 264815 | 2020-06-22 | Fredericksburg city | Virginia | 51630 | 232 | 0 |
267944 | 267944 | 2020-06-23 | Fredericksburg city | Virginia | 51630 | 234 | 1 |
271078 | 271078 | 2020-06-24 | Fredericksburg city | Virginia | 51630 | 235 | 0 |
274218 | 274218 | 2020-06-25 | Fredericksburg city | Virginia | 51630 | 236 | 0 |
277366 | 277366 | 2020-06-26 | Fredericksburg city | Virginia | 51630 | 238 | 0 |
280514 | 280514 | 2020-06-27 | Fredericksburg city | Virginia | 51630 | 239 | 0 |
283660 | 283660 | 2020-06-28 | Fredericksburg city | Virginia | 51630 | 246 | 0 |
286806 | 286806 | 2020-06-29 | Fredericksburg city | Virginia | 51630 | 247 | 0 |
289956 | 289956 | 2020-06-30 | Fredericksburg city | Virginia | 51630 | 246 | 0 |
293109 | 293109 | 2020-07-01 | Fredericksburg city | Virginia | 51630 | 249 | 0 |
296264 | 296264 | 2020-07-02 | Fredericksburg city | Virginia | 51630 | 250 | 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);