ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Union" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418615 | 1418615 | 2021-06-14 | Union | Mississippi | 28145 | 4155 | 76 |
1415370 | 1415370 | 2021-06-13 | Union | Mississippi | 28145 | 4155 | 76 |
1412124 | 1412124 | 2021-06-12 | Union | Mississippi | 28145 | 4155 | 76 |
1408879 | 1408879 | 2021-06-11 | Union | Mississippi | 28145 | 4155 | 76 |
1405634 | 1405634 | 2021-06-10 | Union | Mississippi | 28145 | 4153 | 76 |
1402388 | 1402388 | 2021-06-09 | Union | Mississippi | 28145 | 4151 | 76 |
1399143 | 1399143 | 2021-06-08 | Union | Mississippi | 28145 | 4151 | 76 |
1395897 | 1395897 | 2021-06-07 | Union | Mississippi | 28145 | 4151 | 76 |
1392651 | 1392651 | 2021-06-06 | Union | Mississippi | 28145 | 4151 | 76 |
1389406 | 1389406 | 2021-06-05 | Union | Mississippi | 28145 | 4151 | 76 |
1386161 | 1386161 | 2021-06-04 | Union | Mississippi | 28145 | 4151 | 76 |
1382916 | 1382916 | 2021-06-03 | Union | Mississippi | 28145 | 4150 | 76 |
1379670 | 1379670 | 2021-06-02 | Union | Mississippi | 28145 | 4146 | 76 |
1376425 | 1376425 | 2021-06-01 | Union | Mississippi | 28145 | 4145 | 76 |
1373179 | 1373179 | 2021-05-31 | Union | Mississippi | 28145 | 4144 | 76 |
1369934 | 1369934 | 2021-05-30 | Union | Mississippi | 28145 | 4139 | 76 |
1366688 | 1366688 | 2021-05-29 | Union | Mississippi | 28145 | 4139 | 76 |
1363442 | 1363442 | 2021-05-28 | Union | Mississippi | 28145 | 4139 | 76 |
1360195 | 1360195 | 2021-05-27 | Union | Mississippi | 28145 | 4135 | 76 |
1356949 | 1356949 | 2021-05-26 | Union | Mississippi | 28145 | 4132 | 76 |
1353703 | 1353703 | 2021-05-25 | Union | Mississippi | 28145 | 4132 | 76 |
1350457 | 1350457 | 2021-05-24 | Union | Mississippi | 28145 | 4131 | 76 |
1347211 | 1347211 | 2021-05-23 | Union | Mississippi | 28145 | 4124 | 76 |
1343963 | 1343963 | 2021-05-22 | Union | Mississippi | 28145 | 4124 | 76 |
1340714 | 1340714 | 2021-05-21 | Union | Mississippi | 28145 | 4124 | 76 |
1337467 | 1337467 | 2021-05-20 | Union | Mississippi | 28145 | 4120 | 76 |
1334220 | 1334220 | 2021-05-19 | Union | Mississippi | 28145 | 4116 | 76 |
1330973 | 1330973 | 2021-05-18 | Union | Mississippi | 28145 | 4115 | 76 |
1327726 | 1327726 | 2021-05-17 | Union | Mississippi | 28145 | 4112 | 76 |
1324480 | 1324480 | 2021-05-16 | Union | Mississippi | 28145 | 4111 | 76 |
1321234 | 1321234 | 2021-05-15 | Union | Mississippi | 28145 | 4111 | 76 |
1317988 | 1317988 | 2021-05-14 | Union | Mississippi | 28145 | 4111 | 76 |
1314740 | 1314740 | 2021-05-13 | Union | Mississippi | 28145 | 4110 | 76 |
1311494 | 1311494 | 2021-05-12 | Union | Mississippi | 28145 | 4103 | 76 |
1308247 | 1308247 | 2021-05-11 | Union | Mississippi | 28145 | 4100 | 76 |
1305001 | 1305001 | 2021-05-10 | Union | Mississippi | 28145 | 4097 | 76 |
1301755 | 1301755 | 2021-05-09 | Union | Mississippi | 28145 | 4090 | 76 |
1298507 | 1298507 | 2021-05-08 | Union | Mississippi | 28145 | 4090 | 76 |
1295261 | 1295261 | 2021-05-07 | Union | Mississippi | 28145 | 4090 | 76 |
1292015 | 1292015 | 2021-05-06 | Union | Mississippi | 28145 | 4088 | 76 |
1288769 | 1288769 | 2021-05-05 | Union | Mississippi | 28145 | 4088 | 76 |
1285523 | 1285523 | 2021-05-04 | Union | Mississippi | 28145 | 4087 | 76 |
1282277 | 1282277 | 2021-05-03 | Union | Mississippi | 28145 | 4084 | 76 |
1279030 | 1279030 | 2021-05-02 | Union | Mississippi | 28145 | 4079 | 76 |
1275783 | 1275783 | 2021-05-01 | Union | Mississippi | 28145 | 4079 | 76 |
1272536 | 1272536 | 2021-04-30 | Union | Mississippi | 28145 | 4079 | 76 |
1269289 | 1269289 | 2021-04-29 | Union | Mississippi | 28145 | 4077 | 76 |
1266042 | 1266042 | 2021-04-28 | Union | Mississippi | 28145 | 4076 | 76 |
1262795 | 1262795 | 2021-04-27 | Union | Mississippi | 28145 | 4072 | 76 |
1259548 | 1259548 | 2021-04-26 | Union | Mississippi | 28145 | 4067 | 76 |
1256301 | 1256301 | 2021-04-25 | Union | Mississippi | 28145 | 4059 | 76 |
1253054 | 1253054 | 2021-04-24 | Union | Mississippi | 28145 | 4059 | 76 |
1249807 | 1249807 | 2021-04-23 | Union | Mississippi | 28145 | 4059 | 76 |
1246560 | 1246560 | 2021-04-22 | Union | Mississippi | 28145 | 4058 | 76 |
1243313 | 1243313 | 2021-04-21 | Union | Mississippi | 28145 | 4057 | 76 |
1240066 | 1240066 | 2021-04-20 | Union | Mississippi | 28145 | 4055 | 75 |
1236819 | 1236819 | 2021-04-19 | Union | Mississippi | 28145 | 4051 | 75 |
1233572 | 1233572 | 2021-04-18 | Union | Mississippi | 28145 | 4051 | 75 |
1230324 | 1230324 | 2021-04-17 | Union | Mississippi | 28145 | 4049 | 75 |
1227076 | 1227076 | 2021-04-16 | Union | Mississippi | 28145 | 4046 | 75 |
1223828 | 1223828 | 2021-04-15 | Union | Mississippi | 28145 | 4046 | 75 |
1220581 | 1220581 | 2021-04-14 | Union | Mississippi | 28145 | 4042 | 75 |
1217333 | 1217333 | 2021-04-13 | Union | Mississippi | 28145 | 4039 | 75 |
1214086 | 1214086 | 2021-04-12 | Union | Mississippi | 28145 | 4037 | 75 |
1210838 | 1210838 | 2021-04-11 | Union | Mississippi | 28145 | 4036 | 75 |
1207589 | 1207589 | 2021-04-10 | Union | Mississippi | 28145 | 4035 | 75 |
1204341 | 1204341 | 2021-04-09 | Union | Mississippi | 28145 | 4032 | 75 |
1201093 | 1201093 | 2021-04-08 | Union | Mississippi | 28145 | 4030 | 75 |
1197844 | 1197844 | 2021-04-07 | Union | Mississippi | 28145 | 4029 | 75 |
1194595 | 1194595 | 2021-04-06 | Union | Mississippi | 28145 | 4023 | 75 |
1191346 | 1191346 | 2021-04-05 | Union | Mississippi | 28145 | 4019 | 74 |
1188098 | 1188098 | 2021-04-04 | Union | Mississippi | 28145 | 4018 | 74 |
1184851 | 1184851 | 2021-04-03 | Union | Mississippi | 28145 | 4012 | 74 |
1181605 | 1181605 | 2021-04-02 | Union | Mississippi | 28145 | 4010 | 74 |
1178358 | 1178358 | 2021-04-01 | Union | Mississippi | 28145 | 4008 | 74 |
1175111 | 1175111 | 2021-03-31 | Union | Mississippi | 28145 | 4008 | 74 |
1171864 | 1171864 | 2021-03-30 | Union | Mississippi | 28145 | 4003 | 74 |
1168616 | 1168616 | 2021-03-29 | Union | Mississippi | 28145 | 4002 | 74 |
1165368 | 1165368 | 2021-03-28 | Union | Mississippi | 28145 | 4002 | 74 |
1162120 | 1162120 | 2021-03-27 | Union | Mississippi | 28145 | 4002 | 74 |
1158872 | 1158872 | 2021-03-26 | Union | Mississippi | 28145 | 4002 | 74 |
1155625 | 1155625 | 2021-03-25 | Union | Mississippi | 28145 | 4001 | 74 |
1152378 | 1152378 | 2021-03-24 | Union | Mississippi | 28145 | 4000 | 74 |
1149131 | 1149131 | 2021-03-23 | Union | Mississippi | 28145 | 3999 | 74 |
1145884 | 1145884 | 2021-03-22 | Union | Mississippi | 28145 | 3998 | 74 |
1142637 | 1142637 | 2021-03-21 | Union | Mississippi | 28145 | 3998 | 74 |
1139390 | 1139390 | 2021-03-20 | Union | Mississippi | 28145 | 3997 | 74 |
1136144 | 1136144 | 2021-03-19 | Union | Mississippi | 28145 | 3997 | 74 |
1132898 | 1132898 | 2021-03-18 | Union | Mississippi | 28145 | 3996 | 74 |
1129650 | 1129650 | 2021-03-17 | Union | Mississippi | 28145 | 3996 | 74 |
1126403 | 1126403 | 2021-03-16 | Union | Mississippi | 28145 | 3994 | 74 |
1123157 | 1123157 | 2021-03-15 | Union | Mississippi | 28145 | 3990 | 74 |
1119910 | 1119910 | 2021-03-14 | Union | Mississippi | 28145 | 3990 | 74 |
1116663 | 1116663 | 2021-03-13 | Union | Mississippi | 28145 | 3990 | 74 |
1113417 | 1113417 | 2021-03-12 | Union | Mississippi | 28145 | 3985 | 74 |
1110171 | 1110171 | 2021-03-11 | Union | Mississippi | 28145 | 3975 | 74 |
1106925 | 1106925 | 2021-03-10 | Union | Mississippi | 28145 | 3974 | 74 |
1103679 | 1103679 | 2021-03-09 | Union | Mississippi | 28145 | 3972 | 74 |
1100433 | 1100433 | 2021-03-08 | Union | Mississippi | 28145 | 3970 | 74 |
1097186 | 1097186 | 2021-03-07 | Union | Mississippi | 28145 | 3970 | 74 |
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);