ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 51059 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388870 | 388870 | 2020-07-31 | Fairfax | Virginia | 51059 | 15616 | 520 |
385653 | 385653 | 2020-07-30 | Fairfax | Virginia | 51059 | 15606 | 519 |
382435 | 382435 | 2020-07-29 | Fairfax | Virginia | 51059 | 15570 | 519 |
379218 | 379218 | 2020-07-28 | Fairfax | Virginia | 51059 | 15509 | 519 |
376002 | 376002 | 2020-07-27 | Fairfax | Virginia | 51059 | 15455 | 517 |
372788 | 372788 | 2020-07-26 | Fairfax | Virginia | 51059 | 15304 | 515 |
369576 | 369576 | 2020-07-25 | Fairfax | Virginia | 51059 | 15265 | 515 |
366367 | 366367 | 2020-07-24 | Fairfax | Virginia | 51059 | 15231 | 513 |
363161 | 363161 | 2020-07-23 | Fairfax | Virginia | 51059 | 15126 | 511 |
359955 | 359955 | 2020-07-22 | Fairfax | Virginia | 51059 | 15078 | 510 |
356750 | 356750 | 2020-07-21 | Fairfax | Virginia | 51059 | 14994 | 510 |
353547 | 353547 | 2020-07-20 | Fairfax | Virginia | 51059 | 14934 | 508 |
350345 | 350345 | 2020-07-19 | Fairfax | Virginia | 51059 | 14878 | 508 |
347144 | 347144 | 2020-07-18 | Fairfax | Virginia | 51059 | 14798 | 508 |
343944 | 343944 | 2020-07-17 | Fairfax | Virginia | 51059 | 14731 | 508 |
340745 | 340745 | 2020-07-16 | Fairfax | Virginia | 51059 | 14687 | 509 |
337549 | 337549 | 2020-07-15 | Fairfax | Virginia | 51059 | 14653 | 502 |
334354 | 334354 | 2020-07-14 | Fairfax | Virginia | 51059 | 14574 | 500 |
331161 | 331161 | 2020-07-13 | Fairfax | Virginia | 51059 | 14556 | 500 |
327975 | 327975 | 2020-07-12 | Fairfax | Virginia | 51059 | 14482 | 500 |
324790 | 324790 | 2020-07-11 | Fairfax | Virginia | 51059 | 14403 | 498 |
321609 | 321609 | 2020-07-10 | Fairfax | Virginia | 51059 | 14356 | 499 |
318430 | 318430 | 2020-07-09 | Fairfax | Virginia | 51059 | 14284 | 497 |
315257 | 315257 | 2020-07-08 | Fairfax | Virginia | 51059 | 14253 | 495 |
312082 | 312082 | 2020-07-07 | Fairfax | Virginia | 51059 | 14191 | 495 |
308913 | 308913 | 2020-07-06 | Fairfax | Virginia | 51059 | 14205 | 495 |
305745 | 305745 | 2020-07-05 | Fairfax | Virginia | 51059 | 14153 | 496 |
302581 | 302581 | 2020-07-04 | Fairfax | Virginia | 51059 | 14072 | 495 |
299417 | 299417 | 2020-07-03 | Fairfax | Virginia | 51059 | 13965 | 494 |
296255 | 296255 | 2020-07-02 | Fairfax | Virginia | 51059 | 13886 | 492 |
293100 | 293100 | 2020-07-01 | Fairfax | Virginia | 51059 | 13864 | 488 |
289947 | 289947 | 2020-06-30 | Fairfax | Virginia | 51059 | 13850 | 488 |
286797 | 286797 | 2020-06-29 | Fairfax | Virginia | 51059 | 13840 | 478 |
283651 | 283651 | 2020-06-28 | Fairfax | Virginia | 51059 | 13778 | 473 |
280505 | 280505 | 2020-06-27 | Fairfax | Virginia | 51059 | 13728 | 468 |
277357 | 277357 | 2020-06-26 | Fairfax | Virginia | 51059 | 13653 | 463 |
274209 | 274209 | 2020-06-25 | Fairfax | Virginia | 51059 | 13611 | 457 |
271069 | 271069 | 2020-06-24 | Fairfax | Virginia | 51059 | 13588 | 450 |
267935 | 267935 | 2020-06-23 | Fairfax | Virginia | 51059 | 13579 | 445 |
264806 | 264806 | 2020-06-22 | Fairfax | Virginia | 51059 | 13499 | 438 |
261677 | 261677 | 2020-06-21 | Fairfax | Virginia | 51059 | 13419 | 435 |
258550 | 258550 | 2020-06-20 | Fairfax | Virginia | 51059 | 13341 | 435 |
255423 | 255423 | 2020-06-19 | Fairfax | Virginia | 51059 | 13244 | 432 |
252304 | 252304 | 2020-06-18 | Fairfax | Virginia | 51059 | 13209 | 431 |
249189 | 249189 | 2020-06-17 | Fairfax | Virginia | 51059 | 13153 | 429 |
246077 | 246077 | 2020-06-16 | Fairfax | Virginia | 51059 | 13103 | 428 |
242964 | 242964 | 2020-06-15 | Fairfax | Virginia | 51059 | 13092 | 423 |
239853 | 239853 | 2020-06-14 | Fairfax | Virginia | 51059 | 13017 | 423 |
236745 | 236745 | 2020-06-13 | Fairfax | Virginia | 51059 | 12939 | 423 |
233638 | 233638 | 2020-06-12 | Fairfax | Virginia | 51059 | 12863 | 421 |
230533 | 230533 | 2020-06-11 | Fairfax | Virginia | 51059 | 12812 | 418 |
227429 | 227429 | 2020-06-10 | Fairfax | Virginia | 51059 | 12746 | 422 |
224329 | 224329 | 2020-06-09 | Fairfax | Virginia | 51059 | 12695 | 416 |
221233 | 221233 | 2020-06-08 | Fairfax | Virginia | 51059 | 12603 | 414 |
218141 | 218141 | 2020-06-07 | Fairfax | Virginia | 51059 | 12455 | 414 |
215051 | 215051 | 2020-06-06 | Fairfax | Virginia | 51059 | 12056 | 413 |
211964 | 211964 | 2020-06-05 | Fairfax | Virginia | 51059 | 11904 | 410 |
208879 | 208879 | 2020-06-04 | Fairfax | Virginia | 51059 | 11815 | 403 |
205797 | 205797 | 2020-06-03 | Fairfax | Virginia | 51059 | 11596 | 396 |
202718 | 202718 | 2020-06-02 | Fairfax | Virginia | 51059 | 11426 | 391 |
199642 | 199642 | 2020-06-01 | Fairfax | Virginia | 51059 | 11219 | 387 |
196569 | 196569 | 2020-05-31 | Fairfax | Virginia | 51059 | 11110 | 383 |
193499 | 193499 | 2020-05-30 | Fairfax | Virginia | 51059 | 10906 | 383 |
190433 | 190433 | 2020-05-29 | Fairfax | Virginia | 51059 | 10738 | 378 |
187369 | 187369 | 2020-05-28 | Fairfax | Virginia | 51059 | 10503 | 371 |
184312 | 184312 | 2020-05-27 | Fairfax | Virginia | 51059 | 10069 | 364 |
181261 | 181261 | 2020-05-26 | Fairfax | Virginia | 51059 | 9839 | 340 |
178217 | 178217 | 2020-05-25 | Fairfax | Virginia | 51059 | 9482 | 331 |
175172 | 175172 | 2020-05-24 | Fairfax | Virginia | 51059 | 8989 | 327 |
172129 | 172129 | 2020-05-23 | Fairfax | Virginia | 51059 | 8945 | 326 |
169088 | 169088 | 2020-05-22 | Fairfax | Virginia | 51059 | 8734 | 321 |
166052 | 166052 | 2020-05-21 | Fairfax | Virginia | 51059 | 8580 | 309 |
163023 | 163023 | 2020-05-20 | Fairfax | Virginia | 51059 | 8163 | 302 |
159995 | 159995 | 2020-05-19 | Fairfax | Virginia | 51059 | 8020 | 292 |
156971 | 156971 | 2020-05-18 | Fairfax | Virginia | 51059 | 7843 | 284 |
153954 | 153954 | 2020-05-17 | Fairfax | Virginia | 51059 | 7643 | 282 |
150943 | 150943 | 2020-05-16 | Fairfax | Virginia | 51059 | 7386 | 278 |
147934 | 147934 | 2020-05-15 | Fairfax | Virginia | 51059 | 7159 | 273 |
144931 | 144931 | 2020-05-14 | Fairfax | Virginia | 51059 | 6951 | 267 |
141934 | 141934 | 2020-05-13 | Fairfax | Virginia | 51059 | 6666 | 262 |
138938 | 138938 | 2020-05-12 | Fairfax | Virginia | 51059 | 6470 | 253 |
135947 | 135947 | 2020-05-11 | Fairfax | Virginia | 51059 | 6200 | 243 |
132957 | 132957 | 2020-05-10 | Fairfax | Virginia | 51059 | 5892 | 239 |
129967 | 129967 | 2020-05-09 | Fairfax | Virginia | 51059 | 5610 | 230 |
126977 | 126977 | 2020-05-08 | Fairfax | Virginia | 51059 | 5338 | 227 |
123992 | 123992 | 2020-05-07 | Fairfax | Virginia | 51059 | 5045 | 211 |
121011 | 121011 | 2020-05-06 | Fairfax | Virginia | 51059 | 4834 | 201 |
118047 | 118047 | 2020-05-05 | Fairfax | Virginia | 51059 | 4834 | 201 |
115088 | 115088 | 2020-05-04 | Fairfax | Virginia | 51059 | 4615 | 198 |
112205 | 112205 | 2020-05-03 | Fairfax | Virginia | 51059 | 4340 | 184 |
109331 | 109331 | 2020-05-02 | Fairfax | Virginia | 51059 | 4046 | 153 |
106462 | 106462 | 2020-05-01 | Fairfax | Virginia | 51059 | 3897 | 137 |
103598 | 103598 | 2020-04-30 | Fairfax | Virginia | 51059 | 3611 | 134 |
100743 | 100743 | 2020-04-29 | Fairfax | Virginia | 51059 | 3448 | 124 |
97893 | 97893 | 2020-04-28 | Fairfax | Virginia | 51059 | 3278 | 114 |
95051 | 95051 | 2020-04-27 | Fairfax | Virginia | 51059 | 3002 | 100 |
92222 | 92222 | 2020-04-26 | Fairfax | Virginia | 51059 | 2889 | 95 |
89405 | 89405 | 2020-04-25 | Fairfax | Virginia | 51059 | 2745 | 90 |
86590 | 86590 | 2020-04-24 | Fairfax | Virginia | 51059 | 2534 | 85 |
83783 | 83783 | 2020-04-23 | Fairfax | Virginia | 51059 | 2362 | 76 |
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);