ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Hoke" 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 |
---|---|---|---|---|---|---|---|
1279494 | 1279494 | 2021-05-02 | Hoke | North Carolina | 37093 | 4594 | 55 |
1276247 | 1276247 | 2021-05-01 | Hoke | North Carolina | 37093 | 4594 | 55 |
1273000 | 1273000 | 2021-04-30 | Hoke | North Carolina | 37093 | 4594 | 55 |
1269753 | 1269753 | 2021-04-29 | Hoke | North Carolina | 37093 | 4591 | 55 |
1266506 | 1266506 | 2021-04-28 | Hoke | North Carolina | 37093 | 4583 | 55 |
1263259 | 1263259 | 2021-04-27 | Hoke | North Carolina | 37093 | 4575 | 55 |
1260012 | 1260012 | 2021-04-26 | Hoke | North Carolina | 37093 | 4569 | 55 |
1256765 | 1256765 | 2021-04-25 | Hoke | North Carolina | 37093 | 4542 | 55 |
1253518 | 1253518 | 2021-04-24 | Hoke | North Carolina | 37093 | 4542 | 55 |
1250271 | 1250271 | 2021-04-23 | Hoke | North Carolina | 37093 | 4542 | 55 |
1247024 | 1247024 | 2021-04-22 | Hoke | North Carolina | 37093 | 4536 | 55 |
1243777 | 1243777 | 2021-04-21 | Hoke | North Carolina | 37093 | 4521 | 55 |
1240530 | 1240530 | 2021-04-20 | Hoke | North Carolina | 37093 | 4515 | 55 |
1237283 | 1237283 | 2021-04-19 | Hoke | North Carolina | 37093 | 4511 | 55 |
1234036 | 1234036 | 2021-04-18 | Hoke | North Carolina | 37093 | 4484 | 55 |
1230788 | 1230788 | 2021-04-17 | Hoke | North Carolina | 37093 | 4484 | 55 |
1227540 | 1227540 | 2021-04-16 | Hoke | North Carolina | 37093 | 4484 | 55 |
1224292 | 1224292 | 2021-04-15 | Hoke | North Carolina | 37093 | 4471 | 55 |
1221045 | 1221045 | 2021-04-14 | Hoke | North Carolina | 37093 | 4458 | 55 |
1217797 | 1217797 | 2021-04-13 | Hoke | North Carolina | 37093 | 4449 | 55 |
1214549 | 1214549 | 2021-04-12 | Hoke | North Carolina | 37093 | 4441 | 55 |
1211302 | 1211302 | 2021-04-11 | Hoke | North Carolina | 37093 | 4419 | 55 |
1208053 | 1208053 | 2021-04-10 | Hoke | North Carolina | 37093 | 4419 | 55 |
1204805 | 1204805 | 2021-04-09 | Hoke | North Carolina | 37093 | 4419 | 55 |
1201557 | 1201557 | 2021-04-08 | Hoke | North Carolina | 37093 | 4407 | 55 |
1198308 | 1198308 | 2021-04-07 | Hoke | North Carolina | 37093 | 4401 | 55 |
1195059 | 1195059 | 2021-04-06 | Hoke | North Carolina | 37093 | 4397 | 55 |
1191811 | 1191811 | 2021-04-05 | Hoke | North Carolina | 37093 | 4394 | 55 |
1188562 | 1188562 | 2021-04-04 | Hoke | North Carolina | 37093 | 4364 | 55 |
1185315 | 1185315 | 2021-04-03 | Hoke | North Carolina | 37093 | 4364 | 55 |
1182068 | 1182068 | 2021-04-02 | Hoke | North Carolina | 37093 | 4364 | 55 |
1178821 | 1178821 | 2021-04-01 | Hoke | North Carolina | 37093 | 4364 | 55 |
1175574 | 1175574 | 2021-03-31 | Hoke | North Carolina | 37093 | 4357 | 55 |
1172327 | 1172327 | 2021-03-30 | Hoke | North Carolina | 37093 | 4349 | 55 |
1169080 | 1169080 | 2021-03-29 | Hoke | North Carolina | 37093 | 4345 | 55 |
1165832 | 1165832 | 2021-03-28 | Hoke | North Carolina | 37093 | 4323 | 55 |
1162584 | 1162584 | 2021-03-27 | Hoke | North Carolina | 37093 | 4323 | 55 |
1159335 | 1159335 | 2021-03-26 | Hoke | North Carolina | 37093 | 4323 | 55 |
1156088 | 1156088 | 2021-03-25 | Hoke | North Carolina | 37093 | 4311 | 55 |
1152841 | 1152841 | 2021-03-24 | Hoke | North Carolina | 37093 | 4302 | 55 |
1149594 | 1149594 | 2021-03-23 | Hoke | North Carolina | 37093 | 4293 | 55 |
1146347 | 1146347 | 2021-03-22 | Hoke | North Carolina | 37093 | 4289 | 55 |
1143100 | 1143100 | 2021-03-21 | Hoke | North Carolina | 37093 | 4277 | 55 |
1139853 | 1139853 | 2021-03-20 | Hoke | North Carolina | 37093 | 4277 | 55 |
1136607 | 1136607 | 2021-03-19 | Hoke | North Carolina | 37093 | 4266 | 54 |
1133361 | 1133361 | 2021-03-18 | Hoke | North Carolina | 37093 | 4257 | 54 |
1130113 | 1130113 | 2021-03-17 | Hoke | North Carolina | 37093 | 4246 | 54 |
1126866 | 1126866 | 2021-03-16 | Hoke | North Carolina | 37093 | 4240 | 54 |
1123620 | 1123620 | 2021-03-15 | Hoke | North Carolina | 37093 | 4235 | 54 |
1120374 | 1120374 | 2021-03-14 | Hoke | North Carolina | 37093 | 4223 | 54 |
1117127 | 1117127 | 2021-03-13 | Hoke | North Carolina | 37093 | 4223 | 54 |
1113880 | 1113880 | 2021-03-12 | Hoke | North Carolina | 37093 | 4219 | 54 |
1110634 | 1110634 | 2021-03-11 | Hoke | North Carolina | 37093 | 4210 | 54 |
1107388 | 1107388 | 2021-03-10 | Hoke | North Carolina | 37093 | 4204 | 54 |
1104142 | 1104142 | 2021-03-09 | Hoke | North Carolina | 37093 | 4187 | 54 |
1100896 | 1100896 | 2021-03-08 | Hoke | North Carolina | 37093 | 4183 | 54 |
1097650 | 1097650 | 2021-03-07 | Hoke | North Carolina | 37093 | 4169 | 54 |
1094402 | 1094402 | 2021-03-06 | Hoke | North Carolina | 37093 | 4169 | 54 |
1091156 | 1091156 | 2021-03-05 | Hoke | North Carolina | 37093 | 4158 | 54 |
1087911 | 1087911 | 2021-03-04 | Hoke | North Carolina | 37093 | 4150 | 54 |
1084666 | 1084666 | 2021-03-03 | Hoke | North Carolina | 37093 | 4137 | 54 |
1081420 | 1081420 | 2021-03-02 | Hoke | North Carolina | 37093 | 4128 | 54 |
1078174 | 1078174 | 2021-03-01 | Hoke | North Carolina | 37093 | 4123 | 54 |
1074929 | 1074929 | 2021-02-28 | Hoke | North Carolina | 37093 | 4111 | 54 |
1071683 | 1071683 | 2021-02-27 | Hoke | North Carolina | 37093 | 4111 | 54 |
1068437 | 1068437 | 2021-02-26 | Hoke | North Carolina | 37093 | 4098 | 54 |
1065192 | 1065192 | 2021-02-25 | Hoke | North Carolina | 37093 | 4088 | 54 |
1061948 | 1061948 | 2021-02-24 | Hoke | North Carolina | 37093 | 4073 | 54 |
1058702 | 1058702 | 2021-02-23 | Hoke | North Carolina | 37093 | 4054 | 53 |
1055456 | 1055456 | 2021-02-22 | Hoke | North Carolina | 37093 | 4050 | 53 |
1052210 | 1052210 | 2021-02-21 | Hoke | North Carolina | 37093 | 4044 | 53 |
1048963 | 1048963 | 2021-02-20 | Hoke | North Carolina | 37093 | 4029 | 53 |
1045716 | 1045716 | 2021-02-19 | Hoke | North Carolina | 37093 | 4003 | 53 |
1042471 | 1042471 | 2021-02-18 | Hoke | North Carolina | 37093 | 3984 | 52 |
1039226 | 1039226 | 2021-02-17 | Hoke | North Carolina | 37093 | 3972 | 52 |
1035981 | 1035981 | 2021-02-16 | Hoke | North Carolina | 37093 | 3964 | 52 |
1032736 | 1032736 | 2021-02-15 | Hoke | North Carolina | 37093 | 3957 | 52 |
1029490 | 1029490 | 2021-02-14 | Hoke | North Carolina | 37093 | 3949 | 52 |
1026243 | 1026243 | 2021-02-13 | Hoke | North Carolina | 37093 | 3934 | 52 |
1022998 | 1022998 | 2021-02-12 | Hoke | North Carolina | 37093 | 3917 | 52 |
1019753 | 1019753 | 2021-02-11 | Hoke | North Carolina | 37093 | 3895 | 52 |
1016508 | 1016508 | 2021-02-10 | Hoke | North Carolina | 37093 | 3882 | 52 |
1013263 | 1013263 | 2021-02-09 | Hoke | North Carolina | 37093 | 3860 | 52 |
1010018 | 1010018 | 2021-02-08 | Hoke | North Carolina | 37093 | 3839 | 51 |
1006772 | 1006772 | 2021-02-07 | Hoke | North Carolina | 37093 | 3817 | 51 |
1003526 | 1003526 | 2021-02-06 | Hoke | North Carolina | 37093 | 3805 | 51 |
1000280 | 1000280 | 2021-02-05 | Hoke | North Carolina | 37093 | 3780 | 51 |
997034 | 997034 | 2021-02-04 | Hoke | North Carolina | 37093 | 3754 | 48 |
993788 | 993788 | 2021-02-03 | Hoke | North Carolina | 37093 | 3733 | 48 |
990542 | 990542 | 2021-02-02 | Hoke | North Carolina | 37093 | 3703 | 47 |
987296 | 987296 | 2021-02-01 | Hoke | North Carolina | 37093 | 3692 | 47 |
984049 | 984049 | 2021-01-31 | Hoke | North Carolina | 37093 | 3680 | 47 |
980802 | 980802 | 2021-01-30 | Hoke | North Carolina | 37093 | 3619 | 40 |
977556 | 977556 | 2021-01-29 | Hoke | North Carolina | 37093 | 3619 | 40 |
974311 | 974311 | 2021-01-28 | Hoke | North Carolina | 37093 | 3592 | 40 |
971066 | 971066 | 2021-01-27 | Hoke | North Carolina | 37093 | 3565 | 40 |
967821 | 967821 | 2021-01-26 | Hoke | North Carolina | 37093 | 3546 | 40 |
964577 | 964577 | 2021-01-25 | Hoke | North Carolina | 37093 | 3526 | 40 |
961332 | 961332 | 2021-01-24 | Hoke | North Carolina | 37093 | 3507 | 40 |
958087 | 958087 | 2021-01-23 | Hoke | North Carolina | 37093 | 3486 | 37 |
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);