ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Orange" 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 |
---|---|---|---|---|---|---|---|
1279515 | 1279515 | 2021-05-02 | Orange | North Carolina | 37135 | 8483 | 101 |
1276268 | 1276268 | 2021-05-01 | Orange | North Carolina | 37135 | 8483 | 101 |
1273021 | 1273021 | 2021-04-30 | Orange | North Carolina | 37135 | 8483 | 101 |
1269774 | 1269774 | 2021-04-29 | Orange | North Carolina | 37135 | 8467 | 101 |
1266527 | 1266527 | 2021-04-28 | Orange | North Carolina | 37135 | 8451 | 101 |
1263280 | 1263280 | 2021-04-27 | Orange | North Carolina | 37135 | 8436 | 101 |
1260033 | 1260033 | 2021-04-26 | Orange | North Carolina | 37135 | 8427 | 101 |
1256786 | 1256786 | 2021-04-25 | Orange | North Carolina | 37135 | 8387 | 101 |
1253539 | 1253539 | 2021-04-24 | Orange | North Carolina | 37135 | 8387 | 101 |
1250292 | 1250292 | 2021-04-23 | Orange | North Carolina | 37135 | 8387 | 101 |
1247045 | 1247045 | 2021-04-22 | Orange | North Carolina | 37135 | 8376 | 101 |
1243798 | 1243798 | 2021-04-21 | Orange | North Carolina | 37135 | 8367 | 101 |
1240551 | 1240551 | 2021-04-20 | Orange | North Carolina | 37135 | 8361 | 101 |
1237304 | 1237304 | 2021-04-19 | Orange | North Carolina | 37135 | 8355 | 101 |
1234057 | 1234057 | 2021-04-18 | Orange | North Carolina | 37135 | 8297 | 101 |
1230809 | 1230809 | 2021-04-17 | Orange | North Carolina | 37135 | 8297 | 101 |
1227561 | 1227561 | 2021-04-16 | Orange | North Carolina | 37135 | 8297 | 101 |
1224313 | 1224313 | 2021-04-15 | Orange | North Carolina | 37135 | 8285 | 101 |
1221066 | 1221066 | 2021-04-14 | Orange | North Carolina | 37135 | 8264 | 101 |
1217818 | 1217818 | 2021-04-13 | Orange | North Carolina | 37135 | 8252 | 101 |
1214570 | 1214570 | 2021-04-12 | Orange | North Carolina | 37135 | 8237 | 101 |
1211323 | 1211323 | 2021-04-11 | Orange | North Carolina | 37135 | 8185 | 101 |
1208074 | 1208074 | 2021-04-10 | Orange | North Carolina | 37135 | 8185 | 101 |
1204826 | 1204826 | 2021-04-09 | Orange | North Carolina | 37135 | 8185 | 101 |
1201578 | 1201578 | 2021-04-08 | Orange | North Carolina | 37135 | 8172 | 101 |
1198329 | 1198329 | 2021-04-07 | Orange | North Carolina | 37135 | 8157 | 101 |
1195080 | 1195080 | 2021-04-06 | Orange | North Carolina | 37135 | 8142 | 101 |
1191832 | 1191832 | 2021-04-05 | Orange | North Carolina | 37135 | 8132 | 101 |
1188583 | 1188583 | 2021-04-04 | Orange | North Carolina | 37135 | 8092 | 101 |
1185336 | 1185336 | 2021-04-03 | Orange | North Carolina | 37135 | 8092 | 101 |
1182089 | 1182089 | 2021-04-02 | Orange | North Carolina | 37135 | 8092 | 101 |
1178842 | 1178842 | 2021-04-01 | Orange | North Carolina | 37135 | 8092 | 101 |
1175595 | 1175595 | 2021-03-31 | Orange | North Carolina | 37135 | 8077 | 100 |
1172348 | 1172348 | 2021-03-30 | Orange | North Carolina | 37135 | 8069 | 100 |
1169101 | 1169101 | 2021-03-29 | Orange | North Carolina | 37135 | 8059 | 100 |
1165853 | 1165853 | 2021-03-28 | Orange | North Carolina | 37135 | 8006 | 100 |
1162605 | 1162605 | 2021-03-27 | Orange | North Carolina | 37135 | 8006 | 100 |
1159356 | 1159356 | 2021-03-26 | Orange | North Carolina | 37135 | 8006 | 100 |
1156109 | 1156109 | 2021-03-25 | Orange | North Carolina | 37135 | 7987 | 99 |
1152862 | 1152862 | 2021-03-24 | Orange | North Carolina | 37135 | 7961 | 99 |
1149615 | 1149615 | 2021-03-23 | Orange | North Carolina | 37135 | 7942 | 99 |
1146368 | 1146368 | 2021-03-22 | Orange | North Carolina | 37135 | 7936 | 99 |
1143121 | 1143121 | 2021-03-21 | Orange | North Carolina | 37135 | 7905 | 99 |
1139874 | 1139874 | 2021-03-20 | Orange | North Carolina | 37135 | 7905 | 99 |
1136628 | 1136628 | 2021-03-19 | Orange | North Carolina | 37135 | 7875 | 99 |
1133382 | 1133382 | 2021-03-18 | Orange | North Carolina | 37135 | 7884 | 98 |
1130134 | 1130134 | 2021-03-17 | Orange | North Carolina | 37135 | 7867 | 98 |
1126887 | 1126887 | 2021-03-16 | Orange | North Carolina | 37135 | 7852 | 97 |
1123641 | 1123641 | 2021-03-15 | Orange | North Carolina | 37135 | 7852 | 97 |
1120395 | 1120395 | 2021-03-14 | Orange | North Carolina | 37135 | 7847 | 97 |
1117148 | 1117148 | 2021-03-13 | Orange | North Carolina | 37135 | 7847 | 97 |
1113901 | 1113901 | 2021-03-12 | Orange | North Carolina | 37135 | 7847 | 97 |
1110655 | 1110655 | 2021-03-11 | Orange | North Carolina | 37135 | 7847 | 97 |
1107409 | 1107409 | 2021-03-10 | Orange | North Carolina | 37135 | 7847 | 96 |
1104163 | 1104163 | 2021-03-09 | Orange | North Carolina | 37135 | 7847 | 96 |
1100917 | 1100917 | 2021-03-08 | Orange | North Carolina | 37135 | 7838 | 96 |
1097671 | 1097671 | 2021-03-07 | Orange | North Carolina | 37135 | 7827 | 95 |
1094423 | 1094423 | 2021-03-06 | Orange | North Carolina | 37135 | 7827 | 95 |
1091177 | 1091177 | 2021-03-05 | Orange | North Carolina | 37135 | 7817 | 95 |
1087932 | 1087932 | 2021-03-04 | Orange | North Carolina | 37135 | 7793 | 95 |
1084687 | 1084687 | 2021-03-03 | Orange | North Carolina | 37135 | 7767 | 93 |
1081441 | 1081441 | 2021-03-02 | Orange | North Carolina | 37135 | 7753 | 93 |
1078195 | 1078195 | 2021-03-01 | Orange | North Carolina | 37135 | 7743 | 93 |
1074950 | 1074950 | 2021-02-28 | Orange | North Carolina | 37135 | 7702 | 93 |
1071704 | 1071704 | 2021-02-27 | Orange | North Carolina | 37135 | 7702 | 93 |
1068458 | 1068458 | 2021-02-26 | Orange | North Carolina | 37135 | 7669 | 93 |
1065213 | 1065213 | 2021-02-25 | Orange | North Carolina | 37135 | 7657 | 93 |
1061969 | 1061969 | 2021-02-24 | Orange | North Carolina | 37135 | 7623 | 93 |
1058723 | 1058723 | 2021-02-23 | Orange | North Carolina | 37135 | 7601 | 93 |
1055477 | 1055477 | 2021-02-22 | Orange | North Carolina | 37135 | 7586 | 93 |
1052231 | 1052231 | 2021-02-21 | Orange | North Carolina | 37135 | 7565 | 93 |
1048984 | 1048984 | 2021-02-20 | Orange | North Carolina | 37135 | 7555 | 93 |
1045737 | 1045737 | 2021-02-19 | Orange | North Carolina | 37135 | 7541 | 92 |
1042492 | 1042492 | 2021-02-18 | Orange | North Carolina | 37135 | 7515 | 92 |
1039247 | 1039247 | 2021-02-17 | Orange | North Carolina | 37135 | 7467 | 91 |
1036002 | 1036002 | 2021-02-16 | Orange | North Carolina | 37135 | 7438 | 90 |
1032757 | 1032757 | 2021-02-15 | Orange | North Carolina | 37135 | 7422 | 90 |
1029511 | 1029511 | 2021-02-14 | Orange | North Carolina | 37135 | 7381 | 90 |
1026264 | 1026264 | 2021-02-13 | Orange | North Carolina | 37135 | 7360 | 90 |
1023019 | 1023019 | 2021-02-12 | Orange | North Carolina | 37135 | 7323 | 90 |
1019774 | 1019774 | 2021-02-11 | Orange | North Carolina | 37135 | 7279 | 89 |
1016529 | 1016529 | 2021-02-10 | Orange | North Carolina | 37135 | 7218 | 87 |
1013284 | 1013284 | 2021-02-09 | Orange | North Carolina | 37135 | 7189 | 87 |
1010039 | 1010039 | 2021-02-08 | Orange | North Carolina | 37135 | 7152 | 87 |
1006793 | 1006793 | 2021-02-07 | Orange | North Carolina | 37135 | 7127 | 87 |
1003547 | 1003547 | 2021-02-06 | Orange | North Carolina | 37135 | 7094 | 86 |
1000301 | 1000301 | 2021-02-05 | Orange | North Carolina | 37135 | 7050 | 85 |
997055 | 997055 | 2021-02-04 | Orange | North Carolina | 37135 | 6992 | 85 |
993809 | 993809 | 2021-02-03 | Orange | North Carolina | 37135 | 6949 | 83 |
990563 | 990563 | 2021-02-02 | Orange | North Carolina | 37135 | 6848 | 82 |
987317 | 987317 | 2021-02-01 | Orange | North Carolina | 37135 | 6823 | 82 |
984070 | 984070 | 2021-01-31 | Orange | North Carolina | 37135 | 6760 | 82 |
980823 | 980823 | 2021-01-30 | Orange | North Carolina | 37135 | 6632 | 82 |
977577 | 977577 | 2021-01-29 | Orange | North Carolina | 37135 | 6632 | 82 |
974332 | 974332 | 2021-01-28 | Orange | North Carolina | 37135 | 6552 | 81 |
971087 | 971087 | 2021-01-27 | Orange | North Carolina | 37135 | 6501 | 80 |
967842 | 967842 | 2021-01-26 | Orange | North Carolina | 37135 | 6440 | 80 |
964598 | 964598 | 2021-01-25 | Orange | North Carolina | 37135 | 6420 | 79 |
961353 | 961353 | 2021-01-24 | Orange | North Carolina | 37135 | 6380 | 77 |
958108 | 958108 | 2021-01-23 | Orange | North Carolina | 37135 | 6334 | 76 |
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);