ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 50007 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
255371 | 255371 | 2020-06-19 | Chittenden | Vermont | 50007 | 579 | 39 |
258498 | 258498 | 2020-06-20 | Chittenden | Vermont | 50007 | 579 | 39 |
261625 | 261625 | 2020-06-21 | Chittenden | Vermont | 50007 | 586 | 39 |
264754 | 264754 | 2020-06-22 | Chittenden | Vermont | 50007 | 590 | 39 |
267883 | 267883 | 2020-06-23 | Chittenden | Vermont | 50007 | 590 | 39 |
271017 | 271017 | 2020-06-24 | Chittenden | Vermont | 50007 | 598 | 39 |
274157 | 274157 | 2020-06-25 | Chittenden | Vermont | 50007 | 599 | 39 |
277305 | 277305 | 2020-06-26 | Chittenden | Vermont | 50007 | 601 | 39 |
280453 | 280453 | 2020-06-27 | Chittenden | Vermont | 50007 | 601 | 39 |
283599 | 283599 | 2020-06-28 | Chittenden | Vermont | 50007 | 602 | 39 |
286745 | 286745 | 2020-06-29 | Chittenden | Vermont | 50007 | 607 | 39 |
289895 | 289895 | 2020-06-30 | Chittenden | Vermont | 50007 | 607 | 39 |
293048 | 293048 | 2020-07-01 | Chittenden | Vermont | 50007 | 608 | 39 |
296203 | 296203 | 2020-07-02 | Chittenden | Vermont | 50007 | 617 | 39 |
299365 | 299365 | 2020-07-03 | Chittenden | Vermont | 50007 | 622 | 39 |
302529 | 302529 | 2020-07-04 | Chittenden | Vermont | 50007 | 623 | 39 |
305693 | 305693 | 2020-07-05 | Chittenden | Vermont | 50007 | 629 | 39 |
308861 | 308861 | 2020-07-06 | Chittenden | Vermont | 50007 | 630 | 39 |
312030 | 312030 | 2020-07-07 | Chittenden | Vermont | 50007 | 631 | 39 |
315204 | 315204 | 2020-07-08 | Chittenden | Vermont | 50007 | 632 | 39 |
318377 | 318377 | 2020-07-09 | Chittenden | Vermont | 50007 | 643 | 39 |
321556 | 321556 | 2020-07-10 | Chittenden | Vermont | 50007 | 645 | 39 |
324737 | 324737 | 2020-07-11 | Chittenden | Vermont | 50007 | 650 | 39 |
327922 | 327922 | 2020-07-12 | Chittenden | Vermont | 50007 | 658 | 39 |
331108 | 331108 | 2020-07-13 | Chittenden | Vermont | 50007 | 659 | 39 |
334301 | 334301 | 2020-07-14 | Chittenden | Vermont | 50007 | 662 | 39 |
337496 | 337496 | 2020-07-15 | Chittenden | Vermont | 50007 | 667 | 39 |
340692 | 340692 | 2020-07-16 | Chittenden | Vermont | 50007 | 672 | 39 |
343891 | 343891 | 2020-07-17 | Chittenden | Vermont | 50007 | 679 | 39 |
347091 | 347091 | 2020-07-18 | Chittenden | Vermont | 50007 | 681 | 39 |
350292 | 350292 | 2020-07-19 | Chittenden | Vermont | 50007 | 683 | 39 |
353494 | 353494 | 2020-07-20 | Chittenden | Vermont | 50007 | 688 | 39 |
356697 | 356697 | 2020-07-21 | Chittenden | Vermont | 50007 | 696 | 39 |
359902 | 359902 | 2020-07-22 | Chittenden | Vermont | 50007 | 695 | 39 |
363109 | 363109 | 2020-07-23 | Chittenden | Vermont | 50007 | 705 | 39 |
366315 | 366315 | 2020-07-24 | Chittenden | Vermont | 50007 | 706 | 39 |
369524 | 369524 | 2020-07-25 | Chittenden | Vermont | 50007 | 711 | 39 |
372736 | 372736 | 2020-07-26 | Chittenden | Vermont | 50007 | 713 | 39 |
375950 | 375950 | 2020-07-27 | Chittenden | Vermont | 50007 | 713 | 39 |
379166 | 379166 | 2020-07-28 | Chittenden | Vermont | 50007 | 715 | 39 |
382383 | 382383 | 2020-07-29 | Chittenden | Vermont | 50007 | 715 | 39 |
385601 | 385601 | 2020-07-30 | Chittenden | Vermont | 50007 | 715 | 39 |
388818 | 388818 | 2020-07-31 | Chittenden | Vermont | 50007 | 715 | 39 |
392035 | 392035 | 2020-08-01 | Chittenden | Vermont | 50007 | 717 | 39 |
395251 | 395251 | 2020-08-02 | Chittenden | Vermont | 50007 | 720 | 39 |
398467 | 398467 | 2020-08-03 | Chittenden | Vermont | 50007 | 721 | 39 |
401683 | 401683 | 2020-08-04 | Chittenden | Vermont | 50007 | 723 | 39 |
404901 | 404901 | 2020-08-05 | Chittenden | Vermont | 50007 | 723 | 39 |
408121 | 408121 | 2020-08-06 | Chittenden | Vermont | 50007 | 723 | 39 |
411340 | 411340 | 2020-08-07 | Chittenden | Vermont | 50007 | 724 | 39 |
414560 | 414560 | 2020-08-08 | Chittenden | Vermont | 50007 | 728 | 39 |
417781 | 417781 | 2020-08-09 | Chittenden | Vermont | 50007 | 729 | 39 |
421002 | 421002 | 2020-08-10 | Chittenden | Vermont | 50007 | 730 | 39 |
424223 | 424223 | 2020-08-11 | Chittenden | Vermont | 50007 | 735 | 39 |
427447 | 427447 | 2020-08-12 | Chittenden | Vermont | 50007 | 735 | 39 |
430675 | 430675 | 2020-08-13 | Chittenden | Vermont | 50007 | 738 | 39 |
433900 | 433900 | 2020-08-14 | Chittenden | Vermont | 50007 | 749 | 39 |
437126 | 437126 | 2020-08-15 | Chittenden | Vermont | 50007 | 752 | 39 |
440352 | 440352 | 2020-08-16 | Chittenden | Vermont | 50007 | 756 | 39 |
443578 | 443578 | 2020-08-17 | Chittenden | Vermont | 50007 | 763 | 39 |
446805 | 446805 | 2020-08-18 | Chittenden | Vermont | 50007 | 763 | 39 |
450033 | 450033 | 2020-08-19 | Chittenden | Vermont | 50007 | 764 | 39 |
453261 | 453261 | 2020-08-20 | Chittenden | Vermont | 50007 | 766 | 39 |
456489 | 456489 | 2020-08-21 | Chittenden | Vermont | 50007 | 766 | 39 |
459716 | 459716 | 2020-08-22 | Chittenden | Vermont | 50007 | 770 | 39 |
462945 | 462945 | 2020-08-23 | Chittenden | Vermont | 50007 | 773 | 39 |
466174 | 466174 | 2020-08-24 | Chittenden | Vermont | 50007 | 775 | 39 |
469403 | 469403 | 2020-08-25 | Chittenden | Vermont | 50007 | 779 | 39 |
472635 | 472635 | 2020-08-26 | Chittenden | Vermont | 50007 | 780 | 39 |
475868 | 475868 | 2020-08-27 | Chittenden | Vermont | 50007 | 779 | 39 |
479101 | 479101 | 2020-08-28 | Chittenden | Vermont | 50007 | 779 | 39 |
482335 | 482335 | 2020-08-29 | Chittenden | Vermont | 50007 | 787 | 39 |
485570 | 485570 | 2020-08-30 | Chittenden | Vermont | 50007 | 789 | 39 |
488803 | 488803 | 2020-08-31 | Chittenden | Vermont | 50007 | 797 | 39 |
492036 | 492036 | 2020-09-01 | Chittenden | Vermont | 50007 | 803 | 39 |
495270 | 495270 | 2020-09-02 | Chittenden | Vermont | 50007 | 803 | 39 |
498503 | 498503 | 2020-09-03 | Chittenden | Vermont | 50007 | 800 | 39 |
501737 | 501737 | 2020-09-04 | Chittenden | Vermont | 50007 | 801 | 39 |
504971 | 504971 | 2020-09-05 | Chittenden | Vermont | 50007 | 802 | 39 |
508203 | 508203 | 2020-09-06 | Chittenden | Vermont | 50007 | 802 | 39 |
511436 | 511436 | 2020-09-07 | Chittenden | Vermont | 50007 | 802 | 39 |
514669 | 514669 | 2020-09-08 | Chittenden | Vermont | 50007 | 803 | 39 |
517904 | 517904 | 2020-09-09 | Chittenden | Vermont | 50007 | 803 | 39 |
521141 | 521141 | 2020-09-10 | Chittenden | Vermont | 50007 | 804 | 39 |
524377 | 524377 | 2020-09-11 | Chittenden | Vermont | 50007 | 808 | 39 |
527613 | 527613 | 2020-09-12 | Chittenden | Vermont | 50007 | 811 | 39 |
530850 | 530850 | 2020-09-13 | Chittenden | Vermont | 50007 | 814 | 39 |
534085 | 534085 | 2020-09-14 | Chittenden | Vermont | 50007 | 818 | 39 |
537321 | 537321 | 2020-09-15 | Chittenden | Vermont | 50007 | 821 | 39 |
540558 | 540558 | 2020-09-16 | Chittenden | Vermont | 50007 | 822 | 39 |
543794 | 543794 | 2020-09-17 | Chittenden | Vermont | 50007 | 825 | 39 |
547031 | 547031 | 2020-09-18 | Chittenden | Vermont | 50007 | 827 | 39 |
550270 | 550270 | 2020-09-19 | Chittenden | Vermont | 50007 | 828 | 39 |
553509 | 553509 | 2020-09-20 | Chittenden | Vermont | 50007 | 829 | 39 |
556746 | 556746 | 2020-09-21 | Chittenden | Vermont | 50007 | 829 | 39 |
559982 | 559982 | 2020-09-22 | Chittenden | Vermont | 50007 | 830 | 39 |
563221 | 563221 | 2020-09-23 | Chittenden | Vermont | 50007 | 831 | 39 |
566462 | 566462 | 2020-09-24 | Chittenden | Vermont | 50007 | 832 | 39 |
569703 | 569703 | 2020-09-25 | Chittenden | Vermont | 50007 | 835 | 39 |
572945 | 572945 | 2020-09-26 | Chittenden | Vermont | 50007 | 835 | 39 |
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);