ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Johnston" 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 |
---|---|---|---|---|---|---|---|
958091 | 958091 | 2021-01-23 | Johnston | North Carolina | 37101 | 14936 | 146 |
954845 | 954845 | 2021-01-22 | Johnston | North Carolina | 37101 | 14936 | 146 |
951600 | 951600 | 2021-01-21 | Johnston | North Carolina | 37101 | 14755 | 146 |
948355 | 948355 | 2021-01-20 | Johnston | North Carolina | 37101 | 14670 | 144 |
945108 | 945108 | 2021-01-19 | Johnston | North Carolina | 37101 | 14561 | 140 |
941862 | 941862 | 2021-01-18 | Johnston | North Carolina | 37101 | 14067 | 139 |
938617 | 938617 | 2021-01-17 | Johnston | North Carolina | 37101 | 14067 | 139 |
935372 | 935372 | 2021-01-16 | Johnston | North Carolina | 37101 | 14059 | 139 |
932127 | 932127 | 2021-01-15 | Johnston | North Carolina | 37101 | 14059 | 139 |
928882 | 928882 | 2021-01-14 | Johnston | North Carolina | 37101 | 13903 | 138 |
925637 | 925637 | 2021-01-13 | Johnston | North Carolina | 37101 | 13720 | 131 |
922391 | 922391 | 2021-01-12 | Johnston | North Carolina | 37101 | 13610 | 131 |
919146 | 919146 | 2021-01-11 | Johnston | North Carolina | 37101 | 13513 | 127 |
915901 | 915901 | 2021-01-10 | Johnston | North Carolina | 37101 | 13088 | 124 |
912656 | 912656 | 2021-01-09 | Johnston | North Carolina | 37101 | 12978 | 124 |
909411 | 909411 | 2021-01-08 | Johnston | North Carolina | 37101 | 12978 | 124 |
906166 | 906166 | 2021-01-07 | Johnston | North Carolina | 37101 | 12886 | 124 |
902920 | 902920 | 2021-01-06 | Johnston | North Carolina | 37101 | 12744 | 123 |
899675 | 899675 | 2021-01-05 | Johnston | North Carolina | 37101 | 12593 | 122 |
896430 | 896430 | 2021-01-04 | Johnston | North Carolina | 37101 | 12453 | 120 |
893184 | 893184 | 2021-01-03 | Johnston | North Carolina | 37101 | 12111 | 113 |
889938 | 889938 | 2021-01-02 | Johnston | North Carolina | 37101 | 11925 | 113 |
886691 | 886691 | 2021-01-01 | Johnston | North Carolina | 37101 | 11881 | 112 |
883446 | 883446 | 2020-12-31 | Johnston | North Carolina | 37101 | 11881 | 112 |
880201 | 880201 | 2020-12-30 | Johnston | North Carolina | 37101 | 11725 | 112 |
876956 | 876956 | 2020-12-29 | Johnston | North Carolina | 37101 | 11511 | 103 |
873711 | 873711 | 2020-12-28 | Johnston | North Carolina | 37101 | 11132 | 102 |
870466 | 870466 | 2020-12-27 | Johnston | North Carolina | 37101 | 11040 | 102 |
867221 | 867221 | 2020-12-26 | Johnston | North Carolina | 37101 | 11009 | 102 |
863976 | 863976 | 2020-12-25 | Johnston | North Carolina | 37101 | 11009 | 102 |
860731 | 860731 | 2020-12-24 | Johnston | North Carolina | 37101 | 11009 | 102 |
857486 | 857486 | 2020-12-23 | Johnston | North Carolina | 37101 | 11009 | 102 |
854241 | 854241 | 2020-12-22 | Johnston | North Carolina | 37101 | 10778 | 101 |
850996 | 850996 | 2020-12-21 | Johnston | North Carolina | 37101 | 10638 | 97 |
847751 | 847751 | 2020-12-20 | Johnston | North Carolina | 37101 | 10237 | 95 |
844506 | 844506 | 2020-12-19 | Johnston | North Carolina | 37101 | 10237 | 95 |
841260 | 841260 | 2020-12-18 | Johnston | North Carolina | 37101 | 10237 | 95 |
838015 | 838015 | 2020-12-17 | Johnston | North Carolina | 37101 | 9895 | 92 |
834769 | 834769 | 2020-12-16 | Johnston | North Carolina | 37101 | 9895 | 92 |
831523 | 831523 | 2020-12-15 | Johnston | North Carolina | 37101 | 9738 | 90 |
828276 | 828276 | 2020-12-14 | Johnston | North Carolina | 37101 | 9612 | 90 |
825030 | 825030 | 2020-12-13 | Johnston | North Carolina | 37101 | 9291 | 86 |
821783 | 821783 | 2020-12-12 | Johnston | North Carolina | 37101 | 9291 | 86 |
818537 | 818537 | 2020-12-11 | Johnston | North Carolina | 37101 | 9291 | 86 |
815291 | 815291 | 2020-12-10 | Johnston | North Carolina | 37101 | 9137 | 86 |
812046 | 812046 | 2020-12-09 | Johnston | North Carolina | 37101 | 8912 | 83 |
808801 | 808801 | 2020-12-08 | Johnston | North Carolina | 37101 | 8823 | 83 |
805556 | 805556 | 2020-12-07 | Johnston | North Carolina | 37101 | 8666 | 83 |
802311 | 802311 | 2020-12-06 | Johnston | North Carolina | 37101 | 8322 | 82 |
799066 | 799066 | 2020-12-05 | Johnston | North Carolina | 37101 | 8304 | 82 |
795821 | 795821 | 2020-12-04 | Johnston | North Carolina | 37101 | 8304 | 82 |
792576 | 792576 | 2020-12-03 | Johnston | North Carolina | 37101 | 8156 | 79 |
789331 | 789331 | 2020-12-02 | Johnston | North Carolina | 37101 | 8069 | 79 |
786086 | 786086 | 2020-12-01 | Johnston | North Carolina | 37101 | 7932 | 79 |
782842 | 782842 | 2020-11-30 | Johnston | North Carolina | 37101 | 7840 | 79 |
779596 | 779596 | 2020-11-29 | Johnston | North Carolina | 37101 | 7668 | 78 |
776351 | 776351 | 2020-11-28 | Johnston | North Carolina | 37101 | 7668 | 78 |
773106 | 773106 | 2020-11-27 | Johnston | North Carolina | 37101 | 7668 | 78 |
769861 | 769861 | 2020-11-26 | Johnston | North Carolina | 37101 | 7530 | 78 |
766615 | 766615 | 2020-11-25 | Johnston | North Carolina | 37101 | 7530 | 78 |
763370 | 763370 | 2020-11-24 | Johnston | North Carolina | 37101 | 7434 | 78 |
760125 | 760125 | 2020-11-23 | Johnston | North Carolina | 37101 | 7353 | 74 |
756879 | 756879 | 2020-11-22 | Johnston | North Carolina | 37101 | 7164 | 73 |
753632 | 753632 | 2020-11-21 | Johnston | North Carolina | 37101 | 7164 | 73 |
750386 | 750386 | 2020-11-20 | Johnston | North Carolina | 37101 | 7164 | 73 |
747140 | 747140 | 2020-11-19 | Johnston | North Carolina | 37101 | 7090 | 73 |
743894 | 743894 | 2020-11-18 | Johnston | North Carolina | 37101 | 6969 | 71 |
740647 | 740647 | 2020-11-17 | Johnston | North Carolina | 37101 | 6897 | 70 |
737402 | 737402 | 2020-11-16 | Johnston | North Carolina | 37101 | 6822 | 70 |
734158 | 734158 | 2020-11-15 | Johnston | North Carolina | 37101 | 6622 | 70 |
730912 | 730912 | 2020-11-14 | Johnston | North Carolina | 37101 | 6622 | 70 |
727668 | 727668 | 2020-11-13 | Johnston | North Carolina | 37101 | 6622 | 70 |
724424 | 724424 | 2020-11-12 | Johnston | North Carolina | 37101 | 6542 | 69 |
721181 | 721181 | 2020-11-11 | Johnston | North Carolina | 37101 | 6401 | 69 |
717938 | 717938 | 2020-11-10 | Johnston | North Carolina | 37101 | 6401 | 69 |
714695 | 714695 | 2020-11-09 | Johnston | North Carolina | 37101 | 6328 | 69 |
711451 | 711451 | 2020-11-08 | Johnston | North Carolina | 37101 | 6218 | 69 |
708207 | 708207 | 2020-11-07 | Johnston | North Carolina | 37101 | 6218 | 69 |
704964 | 704964 | 2020-11-06 | Johnston | North Carolina | 37101 | 6218 | 69 |
701721 | 701721 | 2020-11-05 | Johnston | North Carolina | 37101 | 6142 | 68 |
698477 | 698477 | 2020-11-04 | Johnston | North Carolina | 37101 | 6062 | 68 |
695234 | 695234 | 2020-11-03 | Johnston | North Carolina | 37101 | 6007 | 66 |
691992 | 691992 | 2020-11-02 | Johnston | North Carolina | 37101 | 5960 | 66 |
688748 | 688748 | 2020-11-01 | Johnston | North Carolina | 37101 | 5861 | 66 |
685503 | 685503 | 2020-10-31 | Johnston | North Carolina | 37101 | 5861 | 66 |
682260 | 682260 | 2020-10-30 | Johnston | North Carolina | 37101 | 5861 | 66 |
679017 | 679017 | 2020-10-29 | Johnston | North Carolina | 37101 | 5808 | 66 |
675774 | 675774 | 2020-10-28 | Johnston | North Carolina | 37101 | 5766 | 66 |
672531 | 672531 | 2020-10-27 | Johnston | North Carolina | 37101 | 5687 | 66 |
669289 | 669289 | 2020-10-26 | Johnston | North Carolina | 37101 | 5638 | 66 |
666045 | 666045 | 2020-10-25 | Johnston | North Carolina | 37101 | 5513 | 65 |
662800 | 662800 | 2020-10-24 | Johnston | North Carolina | 37101 | 5513 | 65 |
659556 | 659556 | 2020-10-23 | Johnston | North Carolina | 37101 | 5513 | 65 |
656312 | 656312 | 2020-10-22 | Johnston | North Carolina | 37101 | 5419 | 64 |
653067 | 653067 | 2020-10-21 | Johnston | North Carolina | 37101 | 5357 | 62 |
649822 | 649822 | 2020-10-20 | Johnston | North Carolina | 37101 | 5303 | 62 |
646578 | 646578 | 2020-10-19 | Johnston | North Carolina | 37101 | 5270 | 62 |
643332 | 643332 | 2020-10-18 | Johnston | North Carolina | 37101 | 5157 | 62 |
640084 | 640084 | 2020-10-17 | Johnston | North Carolina | 37101 | 5157 | 62 |
636838 | 636838 | 2020-10-16 | Johnston | North Carolina | 37101 | 5157 | 62 |
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);