ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Burke" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922352 | 922352 | 2021-01-12 | Burke | North Carolina | 37023 | 7105 | 86 |
919107 | 919107 | 2021-01-11 | Burke | North Carolina | 37023 | 7024 | 85 |
915862 | 915862 | 2021-01-10 | Burke | North Carolina | 37023 | 6973 | 86 |
912617 | 912617 | 2021-01-09 | Burke | North Carolina | 37023 | 6864 | 86 |
909372 | 909372 | 2021-01-08 | Burke | North Carolina | 37023 | 6783 | 86 |
906127 | 906127 | 2021-01-07 | Burke | North Carolina | 37023 | 6685 | 75 |
902881 | 902881 | 2021-01-06 | Burke | North Carolina | 37023 | 6605 | 75 |
899636 | 899636 | 2021-01-05 | Burke | North Carolina | 37023 | 6554 | 74 |
896391 | 896391 | 2021-01-04 | Burke | North Carolina | 37023 | 6505 | 75 |
893145 | 893145 | 2021-01-03 | Burke | North Carolina | 37023 | 6452 | 75 |
889899 | 889899 | 2021-01-02 | Burke | North Carolina | 37023 | 6396 | 75 |
886652 | 886652 | 2021-01-01 | Burke | North Carolina | 37023 | 6195 | 75 |
883407 | 883407 | 2020-12-31 | Burke | North Carolina | 37023 | 6195 | 75 |
880162 | 880162 | 2020-12-30 | Burke | North Carolina | 37023 | 6182 | 75 |
876917 | 876917 | 2020-12-29 | Burke | North Carolina | 37023 | 6069 | 75 |
873672 | 873672 | 2020-12-28 | Burke | North Carolina | 37023 | 6033 | 75 |
870427 | 870427 | 2020-12-27 | Burke | North Carolina | 37023 | 5978 | 75 |
867182 | 867182 | 2020-12-26 | Burke | North Carolina | 37023 | 5971 | 75 |
863937 | 863937 | 2020-12-25 | Burke | North Carolina | 37023 | 5684 | 74 |
860692 | 860692 | 2020-12-24 | Burke | North Carolina | 37023 | 5684 | 74 |
857447 | 857447 | 2020-12-23 | Burke | North Carolina | 37023 | 5684 | 74 |
854202 | 854202 | 2020-12-22 | Burke | North Carolina | 37023 | 5597 | 74 |
850957 | 850957 | 2020-12-21 | Burke | North Carolina | 37023 | 5549 | 74 |
847712 | 847712 | 2020-12-20 | Burke | North Carolina | 37023 | 5485 | 73 |
844467 | 844467 | 2020-12-19 | Burke | North Carolina | 37023 | 5420 | 72 |
841221 | 841221 | 2020-12-18 | Burke | North Carolina | 37023 | 5356 | 73 |
837976 | 837976 | 2020-12-17 | Burke | North Carolina | 37023 | 5270 | 73 |
834730 | 834730 | 2020-12-16 | Burke | North Carolina | 37023 | 5241 | 73 |
831484 | 831484 | 2020-12-15 | Burke | North Carolina | 37023 | 5172 | 71 |
828237 | 828237 | 2020-12-14 | Burke | North Carolina | 37023 | 5125 | 71 |
824991 | 824991 | 2020-12-13 | Burke | North Carolina | 37023 | 5057 | 71 |
821744 | 821744 | 2020-12-12 | Burke | North Carolina | 37023 | 4990 | 71 |
818498 | 818498 | 2020-12-11 | Burke | North Carolina | 37023 | 4899 | 70 |
815252 | 815252 | 2020-12-10 | Burke | North Carolina | 37023 | 4813 | 69 |
812007 | 812007 | 2020-12-09 | Burke | North Carolina | 37023 | 4750 | 68 |
808762 | 808762 | 2020-12-08 | Burke | North Carolina | 37023 | 4579 | 68 |
805517 | 805517 | 2020-12-07 | Burke | North Carolina | 37023 | 4503 | 68 |
802272 | 802272 | 2020-12-06 | Burke | North Carolina | 37023 | 4450 | 68 |
799027 | 799027 | 2020-12-05 | Burke | North Carolina | 37023 | 4366 | 67 |
795782 | 795782 | 2020-12-04 | Burke | North Carolina | 37023 | 4282 | 65 |
792537 | 792537 | 2020-12-03 | Burke | North Carolina | 37023 | 4186 | 65 |
789292 | 789292 | 2020-12-02 | Burke | North Carolina | 37023 | 4097 | 64 |
786047 | 786047 | 2020-12-01 | Burke | North Carolina | 37023 | 4026 | 64 |
782803 | 782803 | 2020-11-30 | Burke | North Carolina | 37023 | 3990 | 64 |
779557 | 779557 | 2020-11-29 | Burke | North Carolina | 37023 | 3965 | 64 |
776312 | 776312 | 2020-11-28 | Burke | North Carolina | 37023 | 3895 | 64 |
773067 | 773067 | 2020-11-27 | Burke | North Carolina | 37023 | 3849 | 64 |
769822 | 769822 | 2020-11-26 | Burke | North Carolina | 37023 | 3699 | 63 |
766576 | 766576 | 2020-11-25 | Burke | North Carolina | 37023 | 3699 | 63 |
763331 | 763331 | 2020-11-24 | Burke | North Carolina | 37023 | 3612 | 63 |
760086 | 760086 | 2020-11-23 | Burke | North Carolina | 37023 | 3589 | 63 |
756840 | 756840 | 2020-11-22 | Burke | North Carolina | 37023 | 3548 | 63 |
753593 | 753593 | 2020-11-21 | Burke | North Carolina | 37023 | 3492 | 62 |
750347 | 750347 | 2020-11-20 | Burke | North Carolina | 37023 | 3425 | 61 |
747101 | 747101 | 2020-11-19 | Burke | North Carolina | 37023 | 3381 | 61 |
743855 | 743855 | 2020-11-18 | Burke | North Carolina | 37023 | 3334 | 61 |
740608 | 740608 | 2020-11-17 | Burke | North Carolina | 37023 | 3285 | 61 |
737363 | 737363 | 2020-11-16 | Burke | North Carolina | 37023 | 3245 | 60 |
734119 | 734119 | 2020-11-15 | Burke | North Carolina | 37023 | 3214 | 60 |
730873 | 730873 | 2020-11-14 | Burke | North Carolina | 37023 | 3184 | 60 |
727629 | 727629 | 2020-11-13 | Burke | North Carolina | 37023 | 3131 | 60 |
724385 | 724385 | 2020-11-12 | Burke | North Carolina | 37023 | 3111 | 60 |
721142 | 721142 | 2020-11-11 | Burke | North Carolina | 37023 | 3088 | 60 |
717899 | 717899 | 2020-11-10 | Burke | North Carolina | 37023 | 3026 | 56 |
714656 | 714656 | 2020-11-09 | Burke | North Carolina | 37023 | 2975 | 57 |
711412 | 711412 | 2020-11-08 | Burke | North Carolina | 37023 | 2972 | 57 |
708168 | 708168 | 2020-11-07 | Burke | North Carolina | 37023 | 2976 | 57 |
704925 | 704925 | 2020-11-06 | Burke | North Carolina | 37023 | 2937 | 57 |
701682 | 701682 | 2020-11-05 | Burke | North Carolina | 37023 | 2899 | 56 |
698438 | 698438 | 2020-11-04 | Burke | North Carolina | 37023 | 2869 | 53 |
695195 | 695195 | 2020-11-03 | Burke | North Carolina | 37023 | 2840 | 52 |
691953 | 691953 | 2020-11-02 | Burke | North Carolina | 37023 | 2810 | 52 |
688709 | 688709 | 2020-11-01 | Burke | North Carolina | 37023 | 2798 | 52 |
685464 | 685464 | 2020-10-31 | Burke | North Carolina | 37023 | 2760 | 52 |
682221 | 682221 | 2020-10-30 | Burke | North Carolina | 37023 | 2720 | 52 |
678978 | 678978 | 2020-10-29 | Burke | North Carolina | 37023 | 2696 | 52 |
675735 | 675735 | 2020-10-28 | Burke | North Carolina | 37023 | 2669 | 52 |
672492 | 672492 | 2020-10-27 | Burke | North Carolina | 37023 | 2654 | 48 |
669250 | 669250 | 2020-10-26 | Burke | North Carolina | 37023 | 2633 | 48 |
666006 | 666006 | 2020-10-25 | Burke | North Carolina | 37023 | 2620 | 47 |
662761 | 662761 | 2020-10-24 | Burke | North Carolina | 37023 | 2608 | 47 |
659517 | 659517 | 2020-10-23 | Burke | North Carolina | 37023 | 2569 | 47 |
656273 | 656273 | 2020-10-22 | Burke | North Carolina | 37023 | 2556 | 47 |
653028 | 653028 | 2020-10-21 | Burke | North Carolina | 37023 | 2525 | 46 |
649783 | 649783 | 2020-10-20 | Burke | North Carolina | 37023 | 2510 | 46 |
646539 | 646539 | 2020-10-19 | Burke | North Carolina | 37023 | 2503 | 46 |
643293 | 643293 | 2020-10-18 | Burke | North Carolina | 37023 | 2495 | 46 |
640045 | 640045 | 2020-10-17 | Burke | North Carolina | 37023 | 2473 | 46 |
636799 | 636799 | 2020-10-16 | Burke | North Carolina | 37023 | 2453 | 46 |
633553 | 633553 | 2020-10-15 | Burke | North Carolina | 37023 | 2428 | 45 |
630308 | 630308 | 2020-10-14 | Burke | North Carolina | 37023 | 2407 | 45 |
627064 | 627064 | 2020-10-13 | Burke | North Carolina | 37023 | 2382 | 45 |
623822 | 623822 | 2020-10-12 | Burke | North Carolina | 37023 | 2386 | 43 |
620579 | 620579 | 2020-10-11 | Burke | North Carolina | 37023 | 2373 | 43 |
617337 | 617337 | 2020-10-10 | Burke | North Carolina | 37023 | 2356 | 43 |
614095 | 614095 | 2020-10-09 | Burke | North Carolina | 37023 | 2332 | 43 |
610854 | 610854 | 2020-10-08 | Burke | North Carolina | 37023 | 2312 | 43 |
607612 | 607612 | 2020-10-07 | Burke | North Carolina | 37023 | 2266 | 43 |
604369 | 604369 | 2020-10-06 | Burke | North Carolina | 37023 | 2253 | 43 |
601127 | 601127 | 2020-10-05 | Burke | North Carolina | 37023 | 2242 | 42 |
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);