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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
258576 | 258576 | 2020-06-20 | James City | Virginia | 51095 | 239 | 15 |
261703 | 261703 | 2020-06-21 | James City | Virginia | 51095 | 242 | 15 |
264832 | 264832 | 2020-06-22 | James City | Virginia | 51095 | 245 | 15 |
267961 | 267961 | 2020-06-23 | James City | Virginia | 51095 | 245 | 15 |
271095 | 271095 | 2020-06-24 | James City | Virginia | 51095 | 247 | 15 |
274235 | 274235 | 2020-06-25 | James City | Virginia | 51095 | 248 | 15 |
277383 | 277383 | 2020-06-26 | James City | Virginia | 51095 | 251 | 15 |
280531 | 280531 | 2020-06-27 | James City | Virginia | 51095 | 252 | 15 |
283677 | 283677 | 2020-06-28 | James City | Virginia | 51095 | 254 | 15 |
286823 | 286823 | 2020-06-29 | James City | Virginia | 51095 | 258 | 15 |
289973 | 289973 | 2020-06-30 | James City | Virginia | 51095 | 263 | 15 |
293126 | 293126 | 2020-07-01 | James City | Virginia | 51095 | 265 | 15 |
296281 | 296281 | 2020-07-02 | James City | Virginia | 51095 | 268 | 15 |
299443 | 299443 | 2020-07-03 | James City | Virginia | 51095 | 270 | 15 |
302607 | 302607 | 2020-07-04 | James City | Virginia | 51095 | 279 | 15 |
305771 | 305771 | 2020-07-05 | James City | Virginia | 51095 | 293 | 15 |
308939 | 308939 | 2020-07-06 | James City | Virginia | 51095 | 297 | 15 |
312108 | 312108 | 2020-07-07 | James City | Virginia | 51095 | 306 | 15 |
315283 | 315283 | 2020-07-08 | James City | Virginia | 51095 | 313 | 16 |
318456 | 318456 | 2020-07-09 | James City | Virginia | 51095 | 323 | 16 |
321635 | 321635 | 2020-07-10 | James City | Virginia | 51095 | 332 | 16 |
324816 | 324816 | 2020-07-11 | James City | Virginia | 51095 | 336 | 16 |
328001 | 328001 | 2020-07-12 | James City | Virginia | 51095 | 341 | 16 |
331187 | 331187 | 2020-07-13 | James City | Virginia | 51095 | 361 | 16 |
334380 | 334380 | 2020-07-14 | James City | Virginia | 51095 | 378 | 16 |
337575 | 337575 | 2020-07-15 | James City | Virginia | 51095 | 388 | 16 |
340771 | 340771 | 2020-07-16 | James City | Virginia | 51095 | 390 | 16 |
343970 | 343970 | 2020-07-17 | James City | Virginia | 51095 | 396 | 16 |
347170 | 347170 | 2020-07-18 | James City | Virginia | 51095 | 402 | 16 |
350371 | 350371 | 2020-07-19 | James City | Virginia | 51095 | 437 | 16 |
353573 | 353573 | 2020-07-20 | James City | Virginia | 51095 | 452 | 16 |
356776 | 356776 | 2020-07-21 | James City | Virginia | 51095 | 456 | 16 |
359981 | 359981 | 2020-07-22 | James City | Virginia | 51095 | 464 | 16 |
363187 | 363187 | 2020-07-23 | James City | Virginia | 51095 | 471 | 16 |
366393 | 366393 | 2020-07-24 | James City | Virginia | 51095 | 484 | 16 |
369602 | 369602 | 2020-07-25 | James City | Virginia | 51095 | 490 | 16 |
372814 | 372814 | 2020-07-26 | James City | Virginia | 51095 | 497 | 16 |
376028 | 376028 | 2020-07-27 | James City | Virginia | 51095 | 510 | 16 |
379244 | 379244 | 2020-07-28 | James City | Virginia | 51095 | 518 | 16 |
382461 | 382461 | 2020-07-29 | James City | Virginia | 51095 | 525 | 16 |
385679 | 385679 | 2020-07-30 | James City | Virginia | 51095 | 531 | 16 |
388896 | 388896 | 2020-07-31 | James City | Virginia | 51095 | 538 | 16 |
392113 | 392113 | 2020-08-01 | James City | Virginia | 51095 | 541 | 16 |
395329 | 395329 | 2020-08-02 | James City | Virginia | 51095 | 549 | 16 |
398545 | 398545 | 2020-08-03 | James City | Virginia | 51095 | 562 | 16 |
401761 | 401761 | 2020-08-04 | James City | Virginia | 51095 | 572 | 16 |
404979 | 404979 | 2020-08-05 | James City | Virginia | 51095 | 573 | 16 |
408199 | 408199 | 2020-08-06 | James City | Virginia | 51095 | 575 | 16 |
411418 | 411418 | 2020-08-07 | James City | Virginia | 51095 | 596 | 16 |
414638 | 414638 | 2020-08-08 | James City | Virginia | 51095 | 602 | 16 |
417859 | 417859 | 2020-08-09 | James City | Virginia | 51095 | 608 | 16 |
421080 | 421080 | 2020-08-10 | James City | Virginia | 51095 | 617 | 16 |
424301 | 424301 | 2020-08-11 | James City | Virginia | 51095 | 618 | 17 |
427525 | 427525 | 2020-08-12 | James City | Virginia | 51095 | 621 | 17 |
430753 | 430753 | 2020-08-13 | James City | Virginia | 51095 | 624 | 17 |
433978 | 433978 | 2020-08-14 | James City | Virginia | 51095 | 632 | 17 |
437204 | 437204 | 2020-08-15 | James City | Virginia | 51095 | 637 | 17 |
440430 | 440430 | 2020-08-16 | James City | Virginia | 51095 | 641 | 17 |
443656 | 443656 | 2020-08-17 | James City | Virginia | 51095 | 651 | 17 |
446883 | 446883 | 2020-08-18 | James City | Virginia | 51095 | 653 | 17 |
450111 | 450111 | 2020-08-19 | James City | Virginia | 51095 | 652 | 17 |
453339 | 453339 | 2020-08-20 | James City | Virginia | 51095 | 662 | 17 |
456567 | 456567 | 2020-08-21 | James City | Virginia | 51095 | 667 | 17 |
459794 | 459794 | 2020-08-22 | James City | Virginia | 51095 | 694 | 17 |
463023 | 463023 | 2020-08-23 | James City | Virginia | 51095 | 701 | 17 |
466252 | 466252 | 2020-08-24 | James City | Virginia | 51095 | 712 | 17 |
469481 | 469481 | 2020-08-25 | James City | Virginia | 51095 | 716 | 18 |
472713 | 472713 | 2020-08-26 | James City | Virginia | 51095 | 717 | 18 |
475946 | 475946 | 2020-08-27 | James City | Virginia | 51095 | 723 | 18 |
479179 | 479179 | 2020-08-28 | James City | Virginia | 51095 | 726 | 18 |
482413 | 482413 | 2020-08-29 | James City | Virginia | 51095 | 734 | 18 |
485648 | 485648 | 2020-08-30 | James City | Virginia | 51095 | 735 | 18 |
488881 | 488881 | 2020-08-31 | James City | Virginia | 51095 | 743 | 18 |
492114 | 492114 | 2020-09-01 | James City | Virginia | 51095 | 746 | 18 |
495348 | 495348 | 2020-09-02 | James City | Virginia | 51095 | 749 | 18 |
498581 | 498581 | 2020-09-03 | James City | Virginia | 51095 | 754 | 18 |
501815 | 501815 | 2020-09-04 | James City | Virginia | 51095 | 759 | 18 |
505049 | 505049 | 2020-09-05 | James City | Virginia | 51095 | 760 | 18 |
508281 | 508281 | 2020-09-06 | James City | Virginia | 51095 | 765 | 18 |
511514 | 511514 | 2020-09-07 | James City | Virginia | 51095 | 769 | 18 |
514747 | 514747 | 2020-09-08 | James City | Virginia | 51095 | 774 | 18 |
517982 | 517982 | 2020-09-09 | James City | Virginia | 51095 | 777 | 18 |
521219 | 521219 | 2020-09-10 | James City | Virginia | 51095 | 782 | 18 |
524455 | 524455 | 2020-09-11 | James City | Virginia | 51095 | 784 | 18 |
527691 | 527691 | 2020-09-12 | James City | Virginia | 51095 | 792 | 18 |
530928 | 530928 | 2020-09-13 | James City | Virginia | 51095 | 793 | 18 |
534163 | 534163 | 2020-09-14 | James City | Virginia | 51095 | 799 | 18 |
537399 | 537399 | 2020-09-15 | James City | Virginia | 51095 | 801 | 19 |
540636 | 540636 | 2020-09-16 | James City | Virginia | 51095 | 804 | 19 |
543872 | 543872 | 2020-09-17 | James City | Virginia | 51095 | 812 | 19 |
547109 | 547109 | 2020-09-18 | James City | Virginia | 51095 | 818 | 19 |
550348 | 550348 | 2020-09-19 | James City | Virginia | 51095 | 824 | 19 |
553587 | 553587 | 2020-09-20 | James City | Virginia | 51095 | 828 | 19 |
556824 | 556824 | 2020-09-21 | James City | Virginia | 51095 | 831 | 19 |
560060 | 560060 | 2020-09-22 | James City | Virginia | 51095 | 834 | 19 |
563299 | 563299 | 2020-09-23 | James City | Virginia | 51095 | 838 | 20 |
566540 | 566540 | 2020-09-24 | James City | Virginia | 51095 | 839 | 20 |
569781 | 569781 | 2020-09-25 | James City | Virginia | 51095 | 842 | 20 |
573023 | 573023 | 2020-09-26 | James City | Virginia | 51095 | 848 | 20 |
576267 | 576267 | 2020-09-27 | James City | Virginia | 51095 | 851 | 20 |
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);