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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
242964 | 242964 | 2020-06-15 | Fairfax | Virginia | 51059 | 13092 | 423 |
246077 | 246077 | 2020-06-16 | Fairfax | Virginia | 51059 | 13103 | 428 |
249189 | 249189 | 2020-06-17 | Fairfax | Virginia | 51059 | 13153 | 429 |
252304 | 252304 | 2020-06-18 | Fairfax | Virginia | 51059 | 13209 | 431 |
255423 | 255423 | 2020-06-19 | Fairfax | Virginia | 51059 | 13244 | 432 |
258550 | 258550 | 2020-06-20 | Fairfax | Virginia | 51059 | 13341 | 435 |
261677 | 261677 | 2020-06-21 | Fairfax | Virginia | 51059 | 13419 | 435 |
264806 | 264806 | 2020-06-22 | Fairfax | Virginia | 51059 | 13499 | 438 |
267935 | 267935 | 2020-06-23 | Fairfax | Virginia | 51059 | 13579 | 445 |
271069 | 271069 | 2020-06-24 | Fairfax | Virginia | 51059 | 13588 | 450 |
274209 | 274209 | 2020-06-25 | Fairfax | Virginia | 51059 | 13611 | 457 |
277357 | 277357 | 2020-06-26 | Fairfax | Virginia | 51059 | 13653 | 463 |
280505 | 280505 | 2020-06-27 | Fairfax | Virginia | 51059 | 13728 | 468 |
283651 | 283651 | 2020-06-28 | Fairfax | Virginia | 51059 | 13778 | 473 |
286797 | 286797 | 2020-06-29 | Fairfax | Virginia | 51059 | 13840 | 478 |
289947 | 289947 | 2020-06-30 | Fairfax | Virginia | 51059 | 13850 | 488 |
293100 | 293100 | 2020-07-01 | Fairfax | Virginia | 51059 | 13864 | 488 |
296255 | 296255 | 2020-07-02 | Fairfax | Virginia | 51059 | 13886 | 492 |
299417 | 299417 | 2020-07-03 | Fairfax | Virginia | 51059 | 13965 | 494 |
302581 | 302581 | 2020-07-04 | Fairfax | Virginia | 51059 | 14072 | 495 |
308913 | 308913 | 2020-07-06 | Fairfax | Virginia | 51059 | 14205 | 495 |
312082 | 312082 | 2020-07-07 | Fairfax | Virginia | 51059 | 14191 | 495 |
315257 | 315257 | 2020-07-08 | Fairfax | Virginia | 51059 | 14253 | 495 |
305745 | 305745 | 2020-07-05 | Fairfax | Virginia | 51059 | 14153 | 496 |
318430 | 318430 | 2020-07-09 | Fairfax | Virginia | 51059 | 14284 | 497 |
324790 | 324790 | 2020-07-11 | Fairfax | Virginia | 51059 | 14403 | 498 |
321609 | 321609 | 2020-07-10 | Fairfax | Virginia | 51059 | 14356 | 499 |
327975 | 327975 | 2020-07-12 | Fairfax | Virginia | 51059 | 14482 | 500 |
331161 | 331161 | 2020-07-13 | Fairfax | Virginia | 51059 | 14556 | 500 |
334354 | 334354 | 2020-07-14 | Fairfax | Virginia | 51059 | 14574 | 500 |
337549 | 337549 | 2020-07-15 | Fairfax | Virginia | 51059 | 14653 | 502 |
343944 | 343944 | 2020-07-17 | Fairfax | Virginia | 51059 | 14731 | 508 |
347144 | 347144 | 2020-07-18 | Fairfax | Virginia | 51059 | 14798 | 508 |
350345 | 350345 | 2020-07-19 | Fairfax | Virginia | 51059 | 14878 | 508 |
353547 | 353547 | 2020-07-20 | Fairfax | Virginia | 51059 | 14934 | 508 |
340745 | 340745 | 2020-07-16 | Fairfax | Virginia | 51059 | 14687 | 509 |
356750 | 356750 | 2020-07-21 | Fairfax | Virginia | 51059 | 14994 | 510 |
359955 | 359955 | 2020-07-22 | Fairfax | Virginia | 51059 | 15078 | 510 |
363161 | 363161 | 2020-07-23 | Fairfax | Virginia | 51059 | 15126 | 511 |
366367 | 366367 | 2020-07-24 | Fairfax | Virginia | 51059 | 15231 | 513 |
369576 | 369576 | 2020-07-25 | Fairfax | Virginia | 51059 | 15265 | 515 |
372788 | 372788 | 2020-07-26 | Fairfax | Virginia | 51059 | 15304 | 515 |
376002 | 376002 | 2020-07-27 | Fairfax | Virginia | 51059 | 15455 | 517 |
379218 | 379218 | 2020-07-28 | Fairfax | Virginia | 51059 | 15509 | 519 |
382435 | 382435 | 2020-07-29 | Fairfax | Virginia | 51059 | 15570 | 519 |
385653 | 385653 | 2020-07-30 | Fairfax | Virginia | 51059 | 15606 | 519 |
388870 | 388870 | 2020-07-31 | Fairfax | Virginia | 51059 | 15616 | 520 |
392087 | 392087 | 2020-08-01 | Fairfax | Virginia | 51059 | 15689 | 522 |
395303 | 395303 | 2020-08-02 | Fairfax | Virginia | 51059 | 15768 | 523 |
398519 | 398519 | 2020-08-03 | Fairfax | Virginia | 51059 | 15907 | 523 |
408173 | 408173 | 2020-08-06 | Fairfax | Virginia | 51059 | 16087 | 527 |
401735 | 401735 | 2020-08-04 | Fairfax | Virginia | 51059 | 15987 | 528 |
414612 | 414612 | 2020-08-08 | Fairfax | Virginia | 51059 | 16302 | 529 |
417833 | 417833 | 2020-08-09 | Fairfax | Virginia | 51059 | 16376 | 529 |
421054 | 421054 | 2020-08-10 | Fairfax | Virginia | 51059 | 16445 | 529 |
424275 | 424275 | 2020-08-11 | Fairfax | Virginia | 51059 | 16544 | 529 |
427499 | 427499 | 2020-08-12 | Fairfax | Virginia | 51059 | 16642 | 529 |
404953 | 404953 | 2020-08-05 | Fairfax | Virginia | 51059 | 16019 | 530 |
411392 | 411392 | 2020-08-07 | Fairfax | Virginia | 51059 | 16241 | 530 |
430727 | 430727 | 2020-08-13 | Fairfax | Virginia | 51059 | 16703 | 530 |
433952 | 433952 | 2020-08-14 | Fairfax | Virginia | 51059 | 16816 | 531 |
437178 | 437178 | 2020-08-15 | Fairfax | Virginia | 51059 | 16882 | 533 |
440404 | 440404 | 2020-08-16 | Fairfax | Virginia | 51059 | 16995 | 533 |
443630 | 443630 | 2020-08-17 | Fairfax | Virginia | 51059 | 17070 | 535 |
446857 | 446857 | 2020-08-18 | Fairfax | Virginia | 51059 | 17154 | 537 |
450085 | 450085 | 2020-08-19 | Fairfax | Virginia | 51059 | 17230 | 538 |
453313 | 453313 | 2020-08-20 | Fairfax | Virginia | 51059 | 17330 | 539 |
456541 | 456541 | 2020-08-21 | Fairfax | Virginia | 51059 | 17419 | 539 |
459768 | 459768 | 2020-08-22 | Fairfax | Virginia | 51059 | 17531 | 539 |
462997 | 462997 | 2020-08-23 | Fairfax | Virginia | 51059 | 17647 | 542 |
466226 | 466226 | 2020-08-24 | Fairfax | Virginia | 51059 | 17729 | 543 |
469455 | 469455 | 2020-08-25 | Fairfax | Virginia | 51059 | 17784 | 547 |
472687 | 472687 | 2020-08-26 | Fairfax | Virginia | 51059 | 17878 | 549 |
475920 | 475920 | 2020-08-27 | Fairfax | Virginia | 51059 | 17959 | 549 |
479153 | 479153 | 2020-08-28 | Fairfax | Virginia | 51059 | 18084 | 550 |
482387 | 482387 | 2020-08-29 | Fairfax | Virginia | 51059 | 18192 | 555 |
485622 | 485622 | 2020-08-30 | Fairfax | Virginia | 51059 | 18310 | 555 |
488855 | 488855 | 2020-08-31 | Fairfax | Virginia | 51059 | 18417 | 558 |
492088 | 492088 | 2020-09-01 | Fairfax | Virginia | 51059 | 18508 | 560 |
495322 | 495322 | 2020-09-02 | Fairfax | Virginia | 51059 | 18606 | 561 |
498555 | 498555 | 2020-09-03 | Fairfax | Virginia | 51059 | 18671 | 562 |
501789 | 501789 | 2020-09-04 | Fairfax | Virginia | 51059 | 18740 | 562 |
505023 | 505023 | 2020-09-05 | Fairfax | Virginia | 51059 | 18876 | 562 |
508255 | 508255 | 2020-09-06 | Fairfax | Virginia | 51059 | 18983 | 562 |
511488 | 511488 | 2020-09-07 | Fairfax | Virginia | 51059 | 19055 | 562 |
514721 | 514721 | 2020-09-08 | Fairfax | Virginia | 51059 | 19135 | 563 |
517956 | 517956 | 2020-09-09 | Fairfax | Virginia | 51059 | 19177 | 566 |
521193 | 521193 | 2020-09-10 | Fairfax | Virginia | 51059 | 19282 | 566 |
524429 | 524429 | 2020-09-11 | Fairfax | Virginia | 51059 | 19359 | 567 |
527665 | 527665 | 2020-09-12 | Fairfax | Virginia | 51059 | 19495 | 568 |
530902 | 530902 | 2020-09-13 | Fairfax | Virginia | 51059 | 19601 | 568 |
534137 | 534137 | 2020-09-14 | Fairfax | Virginia | 51059 | 19658 | 568 |
537373 | 537373 | 2020-09-15 | Fairfax | Virginia | 51059 | 19732 | 569 |
540610 | 540610 | 2020-09-16 | Fairfax | Virginia | 51059 | 19837 | 572 |
543846 | 543846 | 2020-09-17 | Fairfax | Virginia | 51059 | 19921 | 573 |
547083 | 547083 | 2020-09-18 | Fairfax | Virginia | 51059 | 20041 | 574 |
550322 | 550322 | 2020-09-19 | Fairfax | Virginia | 51059 | 20155 | 579 |
553561 | 553561 | 2020-09-20 | Fairfax | Virginia | 51059 | 20259 | 581 |
556798 | 556798 | 2020-09-21 | Fairfax | Virginia | 51059 | 20305 | 581 |
560034 | 560034 | 2020-09-22 | Fairfax | Virginia | 51059 | 20373 | 583 |
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);