ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,553 rows where county = "Johnston" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
961564 | 961564 | 2021-01-24 | Johnston | Oklahoma | 40069 | 1140 | 13 |
958091 | 958091 | 2021-01-23 | Johnston | North Carolina | 37101 | 14936 | 146 |
958319 | 958319 | 2021-01-23 | Johnston | Oklahoma | 40069 | 1138 | 12 |
954845 | 954845 | 2021-01-22 | Johnston | North Carolina | 37101 | 14936 | 146 |
955073 | 955073 | 2021-01-22 | Johnston | Oklahoma | 40069 | 1124 | 12 |
951600 | 951600 | 2021-01-21 | Johnston | North Carolina | 37101 | 14755 | 146 |
951828 | 951828 | 2021-01-21 | Johnston | Oklahoma | 40069 | 1117 | 12 |
948355 | 948355 | 2021-01-20 | Johnston | North Carolina | 37101 | 14670 | 144 |
948583 | 948583 | 2021-01-20 | Johnston | Oklahoma | 40069 | 1105 | 12 |
945108 | 945108 | 2021-01-19 | Johnston | North Carolina | 37101 | 14561 | 140 |
945337 | 945337 | 2021-01-19 | Johnston | Oklahoma | 40069 | 1102 | 12 |
941862 | 941862 | 2021-01-18 | Johnston | North Carolina | 37101 | 14067 | 139 |
942090 | 942090 | 2021-01-18 | Johnston | Oklahoma | 40069 | 1101 | 12 |
938617 | 938617 | 2021-01-17 | Johnston | North Carolina | 37101 | 14067 | 139 |
938845 | 938845 | 2021-01-17 | Johnston | Oklahoma | 40069 | 1097 | 12 |
935372 | 935372 | 2021-01-16 | Johnston | North Carolina | 37101 | 14059 | 139 |
935600 | 935600 | 2021-01-16 | Johnston | Oklahoma | 40069 | 1086 | 11 |
932127 | 932127 | 2021-01-15 | Johnston | North Carolina | 37101 | 14059 | 139 |
932355 | 932355 | 2021-01-15 | Johnston | Oklahoma | 40069 | 1074 | 11 |
928882 | 928882 | 2021-01-14 | Johnston | North Carolina | 37101 | 13903 | 138 |
929110 | 929110 | 2021-01-14 | Johnston | Oklahoma | 40069 | 1060 | 11 |
925637 | 925637 | 2021-01-13 | Johnston | North Carolina | 37101 | 13720 | 131 |
925865 | 925865 | 2021-01-13 | Johnston | Oklahoma | 40069 | 1050 | 11 |
922391 | 922391 | 2021-01-12 | Johnston | North Carolina | 37101 | 13610 | 131 |
922619 | 922619 | 2021-01-12 | Johnston | Oklahoma | 40069 | 1027 | 11 |
919146 | 919146 | 2021-01-11 | Johnston | North Carolina | 37101 | 13513 | 127 |
919374 | 919374 | 2021-01-11 | Johnston | Oklahoma | 40069 | 1025 | 11 |
915901 | 915901 | 2021-01-10 | Johnston | North Carolina | 37101 | 13088 | 124 |
916129 | 916129 | 2021-01-10 | Johnston | Oklahoma | 40069 | 1010 | 11 |
912656 | 912656 | 2021-01-09 | Johnston | North Carolina | 37101 | 12978 | 124 |
912884 | 912884 | 2021-01-09 | Johnston | Oklahoma | 40069 | 1000 | 11 |
909411 | 909411 | 2021-01-08 | Johnston | North Carolina | 37101 | 12978 | 124 |
909639 | 909639 | 2021-01-08 | Johnston | Oklahoma | 40069 | 975 | 10 |
906166 | 906166 | 2021-01-07 | Johnston | North Carolina | 37101 | 12886 | 124 |
906394 | 906394 | 2021-01-07 | Johnston | Oklahoma | 40069 | 945 | 10 |
902920 | 902920 | 2021-01-06 | Johnston | North Carolina | 37101 | 12744 | 123 |
903148 | 903148 | 2021-01-06 | Johnston | Oklahoma | 40069 | 921 | 10 |
899675 | 899675 | 2021-01-05 | Johnston | North Carolina | 37101 | 12593 | 122 |
899903 | 899903 | 2021-01-05 | Johnston | Oklahoma | 40069 | 899 | 10 |
896430 | 896430 | 2021-01-04 | Johnston | North Carolina | 37101 | 12453 | 120 |
896658 | 896658 | 2021-01-04 | Johnston | Oklahoma | 40069 | 896 | 10 |
893184 | 893184 | 2021-01-03 | Johnston | North Carolina | 37101 | 12111 | 113 |
893412 | 893412 | 2021-01-03 | Johnston | Oklahoma | 40069 | 892 | 10 |
889938 | 889938 | 2021-01-02 | Johnston | North Carolina | 37101 | 11925 | 113 |
890166 | 890166 | 2021-01-02 | Johnston | Oklahoma | 40069 | 860 | 10 |
886691 | 886691 | 2021-01-01 | Johnston | North Carolina | 37101 | 11881 | 112 |
886919 | 886919 | 2021-01-01 | Johnston | Oklahoma | 40069 | 837 | 10 |
883446 | 883446 | 2020-12-31 | Johnston | North Carolina | 37101 | 11881 | 112 |
883674 | 883674 | 2020-12-31 | Johnston | Oklahoma | 40069 | 837 | 10 |
880201 | 880201 | 2020-12-30 | Johnston | North Carolina | 37101 | 11725 | 112 |
880429 | 880429 | 2020-12-30 | Johnston | Oklahoma | 40069 | 827 | 10 |
876956 | 876956 | 2020-12-29 | Johnston | North Carolina | 37101 | 11511 | 103 |
877184 | 877184 | 2020-12-29 | Johnston | Oklahoma | 40069 | 814 | 10 |
873711 | 873711 | 2020-12-28 | Johnston | North Carolina | 37101 | 11132 | 102 |
873939 | 873939 | 2020-12-28 | Johnston | Oklahoma | 40069 | 807 | 10 |
870466 | 870466 | 2020-12-27 | Johnston | North Carolina | 37101 | 11040 | 102 |
870694 | 870694 | 2020-12-27 | Johnston | Oklahoma | 40069 | 803 | 9 |
867221 | 867221 | 2020-12-26 | Johnston | North Carolina | 37101 | 11009 | 102 |
867449 | 867449 | 2020-12-26 | Johnston | Oklahoma | 40069 | 788 | 9 |
863976 | 863976 | 2020-12-25 | Johnston | North Carolina | 37101 | 11009 | 102 |
864204 | 864204 | 2020-12-25 | Johnston | Oklahoma | 40069 | 776 | 7 |
860731 | 860731 | 2020-12-24 | Johnston | North Carolina | 37101 | 11009 | 102 |
860959 | 860959 | 2020-12-24 | Johnston | Oklahoma | 40069 | 776 | 7 |
857486 | 857486 | 2020-12-23 | Johnston | North Carolina | 37101 | 11009 | 102 |
857714 | 857714 | 2020-12-23 | Johnston | Oklahoma | 40069 | 768 | 6 |
854241 | 854241 | 2020-12-22 | Johnston | North Carolina | 37101 | 10778 | 101 |
854469 | 854469 | 2020-12-22 | Johnston | Oklahoma | 40069 | 747 | 6 |
850996 | 850996 | 2020-12-21 | Johnston | North Carolina | 37101 | 10638 | 97 |
851224 | 851224 | 2020-12-21 | Johnston | Oklahoma | 40069 | 745 | 5 |
847751 | 847751 | 2020-12-20 | Johnston | North Carolina | 37101 | 10237 | 95 |
847979 | 847979 | 2020-12-20 | Johnston | Oklahoma | 40069 | 735 | 5 |
844506 | 844506 | 2020-12-19 | Johnston | North Carolina | 37101 | 10237 | 95 |
844734 | 844734 | 2020-12-19 | Johnston | Oklahoma | 40069 | 721 | 5 |
841260 | 841260 | 2020-12-18 | Johnston | North Carolina | 37101 | 10237 | 95 |
841488 | 841488 | 2020-12-18 | Johnston | Oklahoma | 40069 | 698 | 5 |
838015 | 838015 | 2020-12-17 | Johnston | North Carolina | 37101 | 9895 | 92 |
838243 | 838243 | 2020-12-17 | Johnston | Oklahoma | 40069 | 689 | 5 |
834769 | 834769 | 2020-12-16 | Johnston | North Carolina | 37101 | 9895 | 92 |
834997 | 834997 | 2020-12-16 | Johnston | Oklahoma | 40069 | 671 | 5 |
831523 | 831523 | 2020-12-15 | Johnston | North Carolina | 37101 | 9738 | 90 |
831751 | 831751 | 2020-12-15 | Johnston | Oklahoma | 40069 | 652 | 5 |
828276 | 828276 | 2020-12-14 | Johnston | North Carolina | 37101 | 9612 | 90 |
828504 | 828504 | 2020-12-14 | Johnston | Oklahoma | 40069 | 649 | 5 |
825030 | 825030 | 2020-12-13 | Johnston | North Carolina | 37101 | 9291 | 86 |
825258 | 825258 | 2020-12-13 | Johnston | Oklahoma | 40069 | 646 | 5 |
821783 | 821783 | 2020-12-12 | Johnston | North Carolina | 37101 | 9291 | 86 |
822011 | 822011 | 2020-12-12 | Johnston | Oklahoma | 40069 | 637 | 5 |
818537 | 818537 | 2020-12-11 | Johnston | North Carolina | 37101 | 9291 | 86 |
818765 | 818765 | 2020-12-11 | Johnston | Oklahoma | 40069 | 613 | 5 |
815291 | 815291 | 2020-12-10 | Johnston | North Carolina | 37101 | 9137 | 86 |
815519 | 815519 | 2020-12-10 | Johnston | Oklahoma | 40069 | 603 | 5 |
812046 | 812046 | 2020-12-09 | Johnston | North Carolina | 37101 | 8912 | 83 |
812273 | 812273 | 2020-12-09 | Johnston | Oklahoma | 40069 | 594 | 5 |
808801 | 808801 | 2020-12-08 | Johnston | North Carolina | 37101 | 8823 | 83 |
809029 | 809029 | 2020-12-08 | Johnston | Oklahoma | 40069 | 590 | 5 |
805556 | 805556 | 2020-12-07 | Johnston | North Carolina | 37101 | 8666 | 83 |
805784 | 805784 | 2020-12-07 | Johnston | Oklahoma | 40069 | 589 | 5 |
802311 | 802311 | 2020-12-06 | Johnston | North Carolina | 37101 | 8322 | 82 |
802539 | 802539 | 2020-12-06 | Johnston | Oklahoma | 40069 | 582 | 5 |
799066 | 799066 | 2020-12-05 | Johnston | North Carolina | 37101 | 8304 | 82 |
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);