ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51095 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388896 | 388896 | 2020-07-31 | James City | Virginia | 51095 | 538 | 16 |
385679 | 385679 | 2020-07-30 | James City | Virginia | 51095 | 531 | 16 |
382461 | 382461 | 2020-07-29 | James City | Virginia | 51095 | 525 | 16 |
379244 | 379244 | 2020-07-28 | James City | Virginia | 51095 | 518 | 16 |
376028 | 376028 | 2020-07-27 | James City | Virginia | 51095 | 510 | 16 |
372814 | 372814 | 2020-07-26 | James City | Virginia | 51095 | 497 | 16 |
369602 | 369602 | 2020-07-25 | James City | Virginia | 51095 | 490 | 16 |
366393 | 366393 | 2020-07-24 | James City | Virginia | 51095 | 484 | 16 |
363187 | 363187 | 2020-07-23 | James City | Virginia | 51095 | 471 | 16 |
359981 | 359981 | 2020-07-22 | James City | Virginia | 51095 | 464 | 16 |
356776 | 356776 | 2020-07-21 | James City | Virginia | 51095 | 456 | 16 |
353573 | 353573 | 2020-07-20 | James City | Virginia | 51095 | 452 | 16 |
350371 | 350371 | 2020-07-19 | James City | Virginia | 51095 | 437 | 16 |
347170 | 347170 | 2020-07-18 | James City | Virginia | 51095 | 402 | 16 |
343970 | 343970 | 2020-07-17 | James City | Virginia | 51095 | 396 | 16 |
340771 | 340771 | 2020-07-16 | James City | Virginia | 51095 | 390 | 16 |
337575 | 337575 | 2020-07-15 | James City | Virginia | 51095 | 388 | 16 |
334380 | 334380 | 2020-07-14 | James City | Virginia | 51095 | 378 | 16 |
331187 | 331187 | 2020-07-13 | James City | Virginia | 51095 | 361 | 16 |
328001 | 328001 | 2020-07-12 | James City | Virginia | 51095 | 341 | 16 |
324816 | 324816 | 2020-07-11 | James City | Virginia | 51095 | 336 | 16 |
321635 | 321635 | 2020-07-10 | James City | Virginia | 51095 | 332 | 16 |
318456 | 318456 | 2020-07-09 | James City | Virginia | 51095 | 323 | 16 |
315283 | 315283 | 2020-07-08 | James City | Virginia | 51095 | 313 | 16 |
312108 | 312108 | 2020-07-07 | James City | Virginia | 51095 | 306 | 15 |
308939 | 308939 | 2020-07-06 | James City | Virginia | 51095 | 297 | 15 |
305771 | 305771 | 2020-07-05 | James City | Virginia | 51095 | 293 | 15 |
302607 | 302607 | 2020-07-04 | James City | Virginia | 51095 | 279 | 15 |
299443 | 299443 | 2020-07-03 | James City | Virginia | 51095 | 270 | 15 |
296281 | 296281 | 2020-07-02 | James City | Virginia | 51095 | 268 | 15 |
293126 | 293126 | 2020-07-01 | James City | Virginia | 51095 | 265 | 15 |
289973 | 289973 | 2020-06-30 | James City | Virginia | 51095 | 263 | 15 |
286823 | 286823 | 2020-06-29 | James City | Virginia | 51095 | 258 | 15 |
283677 | 283677 | 2020-06-28 | James City | Virginia | 51095 | 254 | 15 |
280531 | 280531 | 2020-06-27 | James City | Virginia | 51095 | 252 | 15 |
277383 | 277383 | 2020-06-26 | James City | Virginia | 51095 | 251 | 15 |
274235 | 274235 | 2020-06-25 | James City | Virginia | 51095 | 248 | 15 |
271095 | 271095 | 2020-06-24 | James City | Virginia | 51095 | 247 | 15 |
267961 | 267961 | 2020-06-23 | James City | Virginia | 51095 | 245 | 15 |
264832 | 264832 | 2020-06-22 | James City | Virginia | 51095 | 245 | 15 |
261703 | 261703 | 2020-06-21 | James City | Virginia | 51095 | 242 | 15 |
258576 | 258576 | 2020-06-20 | James City | Virginia | 51095 | 239 | 15 |
255449 | 255449 | 2020-06-19 | James City | Virginia | 51095 | 238 | 15 |
252330 | 252330 | 2020-06-18 | James City | Virginia | 51095 | 237 | 15 |
249215 | 249215 | 2020-06-17 | James City | Virginia | 51095 | 236 | 15 |
246103 | 246103 | 2020-06-16 | James City | Virginia | 51095 | 236 | 15 |
242990 | 242990 | 2020-06-15 | James City | Virginia | 51095 | 233 | 15 |
239879 | 239879 | 2020-06-14 | James City | Virginia | 51095 | 233 | 15 |
236771 | 236771 | 2020-06-13 | James City | Virginia | 51095 | 231 | 15 |
233664 | 233664 | 2020-06-12 | James City | Virginia | 51095 | 230 | 15 |
230559 | 230559 | 2020-06-11 | James City | Virginia | 51095 | 225 | 15 |
227455 | 227455 | 2020-06-10 | James City | Virginia | 51095 | 224 | 15 |
224355 | 224355 | 2020-06-09 | James City | Virginia | 51095 | 224 | 15 |
221259 | 221259 | 2020-06-08 | James City | Virginia | 51095 | 217 | 15 |
218167 | 218167 | 2020-06-07 | James City | Virginia | 51095 | 216 | 15 |
215077 | 215077 | 2020-06-06 | James City | Virginia | 51095 | 211 | 15 |
211990 | 211990 | 2020-06-05 | James City | Virginia | 51095 | 211 | 15 |
208905 | 208905 | 2020-06-04 | James City | Virginia | 51095 | 211 | 15 |
205823 | 205823 | 2020-06-03 | James City | Virginia | 51095 | 211 | 15 |
202744 | 202744 | 2020-06-02 | James City | Virginia | 51095 | 210 | 15 |
199668 | 199668 | 2020-06-01 | James City | Virginia | 51095 | 206 | 15 |
196595 | 196595 | 2020-05-31 | James City | Virginia | 51095 | 205 | 15 |
193525 | 193525 | 2020-05-30 | James City | Virginia | 51095 | 202 | 15 |
190459 | 190459 | 2020-05-29 | James City | Virginia | 51095 | 202 | 15 |
187395 | 187395 | 2020-05-28 | James City | Virginia | 51095 | 202 | 15 |
184338 | 184338 | 2020-05-27 | James City | Virginia | 51095 | 200 | 16 |
181287 | 181287 | 2020-05-26 | James City | Virginia | 51095 | 200 | 16 |
178243 | 178243 | 2020-05-25 | James City | Virginia | 51095 | 197 | 16 |
175198 | 175198 | 2020-05-24 | James City | Virginia | 51095 | 196 | 16 |
172155 | 172155 | 2020-05-23 | James City | Virginia | 51095 | 192 | 16 |
169114 | 169114 | 2020-05-22 | James City | Virginia | 51095 | 191 | 16 |
166078 | 166078 | 2020-05-21 | James City | Virginia | 51095 | 189 | 15 |
163049 | 163049 | 2020-05-20 | James City | Virginia | 51095 | 189 | 15 |
160021 | 160021 | 2020-05-19 | James City | Virginia | 51095 | 189 | 15 |
156997 | 156997 | 2020-05-18 | James City | Virginia | 51095 | 187 | 15 |
153980 | 153980 | 2020-05-17 | James City | Virginia | 51095 | 186 | 15 |
150969 | 150969 | 2020-05-16 | James City | Virginia | 51095 | 179 | 15 |
147960 | 147960 | 2020-05-15 | James City | Virginia | 51095 | 179 | 15 |
144957 | 144957 | 2020-05-14 | James City | Virginia | 51095 | 174 | 15 |
141960 | 141960 | 2020-05-13 | James City | Virginia | 51095 | 174 | 15 |
138964 | 138964 | 2020-05-12 | James City | Virginia | 51095 | 174 | 15 |
135973 | 135973 | 2020-05-11 | James City | Virginia | 51095 | 173 | 15 |
132983 | 132983 | 2020-05-10 | James City | Virginia | 51095 | 173 | 15 |
129993 | 129993 | 2020-05-09 | James City | Virginia | 51095 | 169 | 15 |
127003 | 127003 | 2020-05-08 | James City | Virginia | 51095 | 170 | 15 |
124018 | 124018 | 2020-05-07 | James City | Virginia | 51095 | 167 | 15 |
121037 | 121037 | 2020-05-06 | James City | Virginia | 51095 | 166 | 14 |
118073 | 118073 | 2020-05-05 | James City | Virginia | 51095 | 166 | 14 |
115114 | 115114 | 2020-05-04 | James City | Virginia | 51095 | 167 | 13 |
112231 | 112231 | 2020-05-03 | James City | Virginia | 51095 | 163 | 13 |
109357 | 109357 | 2020-05-02 | James City | Virginia | 51095 | 161 | 13 |
106488 | 106488 | 2020-05-01 | James City | Virginia | 51095 | 160 | 12 |
103624 | 103624 | 2020-04-30 | James City | Virginia | 51095 | 158 | 12 |
100769 | 100769 | 2020-04-29 | James City | Virginia | 51095 | 155 | 12 |
97919 | 97919 | 2020-04-28 | James City | Virginia | 51095 | 155 | 12 |
95076 | 95076 | 2020-04-27 | James City | Virginia | 51095 | 154 | 12 |
92247 | 92247 | 2020-04-26 | James City | Virginia | 51095 | 153 | 12 |
89430 | 89430 | 2020-04-25 | James City | Virginia | 51095 | 151 | 12 |
86615 | 86615 | 2020-04-24 | James City | Virginia | 51095 | 150 | 12 |
83808 | 83808 | 2020-04-23 | James City | Virginia | 51095 | 149 | 12 |
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);