ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Jewell" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418069 | 1418069 | 2021-06-14 | Jewell | Kansas | 20089 | 215 | 6 |
1414823 | 1414823 | 2021-06-13 | Jewell | Kansas | 20089 | 215 | 6 |
1411578 | 1411578 | 2021-06-12 | Jewell | Kansas | 20089 | 215 | 6 |
1408333 | 1408333 | 2021-06-11 | Jewell | Kansas | 20089 | 215 | 6 |
1405087 | 1405087 | 2021-06-10 | Jewell | Kansas | 20089 | 215 | 6 |
1401842 | 1401842 | 2021-06-09 | Jewell | Kansas | 20089 | 215 | 6 |
1398597 | 1398597 | 2021-06-08 | Jewell | Kansas | 20089 | 214 | 6 |
1395350 | 1395350 | 2021-06-07 | Jewell | Kansas | 20089 | 214 | 6 |
1392105 | 1392105 | 2021-06-06 | Jewell | Kansas | 20089 | 214 | 6 |
1388860 | 1388860 | 2021-06-05 | Jewell | Kansas | 20089 | 214 | 6 |
1385615 | 1385615 | 2021-06-04 | Jewell | Kansas | 20089 | 214 | 6 |
1382369 | 1382369 | 2021-06-03 | Jewell | Kansas | 20089 | 213 | 6 |
1379124 | 1379124 | 2021-06-02 | Jewell | Kansas | 20089 | 213 | 6 |
1375878 | 1375878 | 2021-06-01 | Jewell | Kansas | 20089 | 213 | 6 |
1372633 | 1372633 | 2021-05-31 | Jewell | Kansas | 20089 | 213 | 6 |
1369388 | 1369388 | 2021-05-30 | Jewell | Kansas | 20089 | 213 | 6 |
1366142 | 1366142 | 2021-05-29 | Jewell | Kansas | 20089 | 213 | 6 |
1362896 | 1362896 | 2021-05-28 | Jewell | Kansas | 20089 | 213 | 6 |
1359649 | 1359649 | 2021-05-27 | Jewell | Kansas | 20089 | 212 | 6 |
1356403 | 1356403 | 2021-05-26 | Jewell | Kansas | 20089 | 212 | 6 |
1353157 | 1353157 | 2021-05-25 | Jewell | Kansas | 20089 | 211 | 6 |
1349911 | 1349911 | 2021-05-24 | Jewell | Kansas | 20089 | 211 | 6 |
1346664 | 1346664 | 2021-05-23 | Jewell | Kansas | 20089 | 211 | 6 |
1343416 | 1343416 | 2021-05-22 | Jewell | Kansas | 20089 | 211 | 6 |
1340168 | 1340168 | 2021-05-21 | Jewell | Kansas | 20089 | 211 | 6 |
1336921 | 1336921 | 2021-05-20 | Jewell | Kansas | 20089 | 211 | 6 |
1333674 | 1333674 | 2021-05-19 | Jewell | Kansas | 20089 | 211 | 6 |
1330427 | 1330427 | 2021-05-18 | Jewell | Kansas | 20089 | 211 | 6 |
1327180 | 1327180 | 2021-05-17 | Jewell | Kansas | 20089 | 211 | 6 |
1323934 | 1323934 | 2021-05-16 | Jewell | Kansas | 20089 | 211 | 6 |
1320688 | 1320688 | 2021-05-15 | Jewell | Kansas | 20089 | 211 | 6 |
1317441 | 1317441 | 2021-05-14 | Jewell | Kansas | 20089 | 211 | 6 |
1314194 | 1314194 | 2021-05-13 | Jewell | Kansas | 20089 | 211 | 6 |
1310947 | 1310947 | 2021-05-12 | Jewell | Kansas | 20089 | 211 | 6 |
1307701 | 1307701 | 2021-05-11 | Jewell | Kansas | 20089 | 211 | 6 |
1304455 | 1304455 | 2021-05-10 | Jewell | Kansas | 20089 | 211 | 6 |
1301208 | 1301208 | 2021-05-09 | Jewell | Kansas | 20089 | 211 | 6 |
1297961 | 1297961 | 2021-05-08 | Jewell | Kansas | 20089 | 211 | 6 |
1294715 | 1294715 | 2021-05-07 | Jewell | Kansas | 20089 | 211 | 6 |
1291469 | 1291469 | 2021-05-06 | Jewell | Kansas | 20089 | 210 | 6 |
1288223 | 1288223 | 2021-05-05 | Jewell | Kansas | 20089 | 210 | 6 |
1284977 | 1284977 | 2021-05-04 | Jewell | Kansas | 20089 | 210 | 6 |
1281730 | 1281730 | 2021-05-03 | Jewell | Kansas | 20089 | 210 | 6 |
1278483 | 1278483 | 2021-05-02 | Jewell | Kansas | 20089 | 210 | 6 |
1275236 | 1275236 | 2021-05-01 | Jewell | Kansas | 20089 | 210 | 6 |
1271989 | 1271989 | 2021-04-30 | Jewell | Kansas | 20089 | 210 | 6 |
1268742 | 1268742 | 2021-04-29 | Jewell | Kansas | 20089 | 210 | 6 |
1265495 | 1265495 | 2021-04-28 | Jewell | Kansas | 20089 | 210 | 6 |
1262248 | 1262248 | 2021-04-27 | Jewell | Kansas | 20089 | 210 | 5 |
1259001 | 1259001 | 2021-04-26 | Jewell | Kansas | 20089 | 210 | 5 |
1255754 | 1255754 | 2021-04-25 | Jewell | Kansas | 20089 | 210 | 5 |
1252507 | 1252507 | 2021-04-24 | Jewell | Kansas | 20089 | 210 | 5 |
1249260 | 1249260 | 2021-04-23 | Jewell | Kansas | 20089 | 210 | 5 |
1246013 | 1246013 | 2021-04-22 | Jewell | Kansas | 20089 | 210 | 5 |
1242766 | 1242766 | 2021-04-21 | Jewell | Kansas | 20089 | 210 | 5 |
1239519 | 1239519 | 2021-04-20 | Jewell | Kansas | 20089 | 210 | 5 |
1236272 | 1236272 | 2021-04-19 | Jewell | Kansas | 20089 | 210 | 5 |
1233025 | 1233025 | 2021-04-18 | Jewell | Kansas | 20089 | 210 | 5 |
1229776 | 1229776 | 2021-04-17 | Jewell | Kansas | 20089 | 210 | 3 |
1226528 | 1226528 | 2021-04-16 | Jewell | Kansas | 20089 | 210 | 3 |
1223281 | 1223281 | 2021-04-15 | Jewell | Kansas | 20089 | 210 | 3 |
1220033 | 1220033 | 2021-04-14 | Jewell | Kansas | 20089 | 210 | 3 |
1216785 | 1216785 | 2021-04-13 | Jewell | Kansas | 20089 | 210 | 3 |
1213538 | 1213538 | 2021-04-12 | Jewell | Kansas | 20089 | 210 | 3 |
1210290 | 1210290 | 2021-04-11 | Jewell | Kansas | 20089 | 210 | 3 |
1207041 | 1207041 | 2021-04-10 | Jewell | Kansas | 20089 | 210 | 3 |
1203793 | 1203793 | 2021-04-09 | Jewell | Kansas | 20089 | 210 | 3 |
1200545 | 1200545 | 2021-04-08 | Jewell | Kansas | 20089 | 209 | 3 |
1197296 | 1197296 | 2021-04-07 | Jewell | Kansas | 20089 | 209 | 3 |
1194048 | 1194048 | 2021-04-06 | Jewell | Kansas | 20089 | 209 | 3 |
1190798 | 1190798 | 2021-04-05 | Jewell | Kansas | 20089 | 209 | 3 |
1187551 | 1187551 | 2021-04-04 | Jewell | Kansas | 20089 | 209 | 3 |
1184304 | 1184304 | 2021-04-03 | Jewell | Kansas | 20089 | 209 | 3 |
1181057 | 1181057 | 2021-04-02 | Jewell | Kansas | 20089 | 209 | 3 |
1177810 | 1177810 | 2021-04-01 | Jewell | Kansas | 20089 | 209 | 3 |
1174563 | 1174563 | 2021-03-31 | Jewell | Kansas | 20089 | 209 | 3 |
1171316 | 1171316 | 2021-03-30 | Jewell | Kansas | 20089 | 209 | 3 |
1168068 | 1168068 | 2021-03-29 | Jewell | Kansas | 20089 | 209 | 3 |
1164820 | 1164820 | 2021-03-28 | Jewell | Kansas | 20089 | 209 | 3 |
1161572 | 1161572 | 2021-03-27 | Jewell | Kansas | 20089 | 209 | 3 |
1158324 | 1158324 | 2021-03-26 | Jewell | Kansas | 20089 | 209 | 3 |
1155077 | 1155077 | 2021-03-25 | Jewell | Kansas | 20089 | 209 | 3 |
1151830 | 1151830 | 2021-03-24 | Jewell | Kansas | 20089 | 209 | 3 |
1148583 | 1148583 | 2021-03-23 | Jewell | Kansas | 20089 | 206 | 3 |
1145336 | 1145336 | 2021-03-22 | Jewell | Kansas | 20089 | 206 | 3 |
1142089 | 1142089 | 2021-03-21 | Jewell | Kansas | 20089 | 206 | 3 |
1138843 | 1138843 | 2021-03-20 | Jewell | Kansas | 20089 | 206 | 3 |
1135597 | 1135597 | 2021-03-19 | Jewell | Kansas | 20089 | 206 | 3 |
1132350 | 1132350 | 2021-03-18 | Jewell | Kansas | 20089 | 204 | 3 |
1129102 | 1129102 | 2021-03-17 | Jewell | Kansas | 20089 | 204 | 3 |
1125856 | 1125856 | 2021-03-16 | Jewell | Kansas | 20089 | 203 | 3 |
1122610 | 1122610 | 2021-03-15 | Jewell | Kansas | 20089 | 203 | 3 |
1119363 | 1119363 | 2021-03-14 | Jewell | Kansas | 20089 | 203 | 3 |
1116116 | 1116116 | 2021-03-13 | Jewell | Kansas | 20089 | 203 | 3 |
1112870 | 1112870 | 2021-03-12 | Jewell | Kansas | 20089 | 203 | 3 |
1109624 | 1109624 | 2021-03-11 | Jewell | Kansas | 20089 | 203 | 3 |
1106378 | 1106378 | 2021-03-10 | Jewell | Kansas | 20089 | 203 | 3 |
1103132 | 1103132 | 2021-03-09 | Jewell | Kansas | 20089 | 203 | 3 |
1099886 | 1099886 | 2021-03-08 | Jewell | Kansas | 20089 | 203 | 3 |
1096638 | 1096638 | 2021-03-07 | Jewell | Kansas | 20089 | 202 | 3 |
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);