ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where county = "Sullivan", deaths = 20 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1442170 | 1442170 | 2021-06-21 | Sullivan | Pennsylvania | 42113 | 440 | 20 |
1438925 | 1438925 | 2021-06-20 | Sullivan | Pennsylvania | 42113 | 440 | 20 |
1435678 | 1435678 | 2021-06-19 | Sullivan | Pennsylvania | 42113 | 440 | 20 |
1432431 | 1432431 | 2021-06-18 | Sullivan | Pennsylvania | 42113 | 440 | 20 |
1429185 | 1429185 | 2021-06-17 | Sullivan | Pennsylvania | 42113 | 440 | 20 |
1425940 | 1425940 | 2021-06-16 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1422693 | 1422693 | 2021-06-15 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1419447 | 1419447 | 2021-06-14 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1416202 | 1416202 | 2021-06-13 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1412956 | 1412956 | 2021-06-12 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1409711 | 1409711 | 2021-06-11 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1406466 | 1406466 | 2021-06-10 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1403220 | 1403220 | 2021-06-09 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1399975 | 1399975 | 2021-06-08 | Sullivan | Pennsylvania | 42113 | 439 | 20 |
1396730 | 1396730 | 2021-06-07 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1393483 | 1393483 | 2021-06-06 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1390238 | 1390238 | 2021-06-05 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1386993 | 1386993 | 2021-06-04 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1383748 | 1383748 | 2021-06-03 | Sullivan | Pennsylvania | 42113 | 435 | 20 |
1380502 | 1380502 | 2021-06-02 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1377257 | 1377257 | 2021-06-01 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1374011 | 1374011 | 2021-05-31 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1370766 | 1370766 | 2021-05-30 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1367520 | 1367520 | 2021-05-29 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1364274 | 1364274 | 2021-05-28 | Sullivan | Pennsylvania | 42113 | 434 | 20 |
1361028 | 1361028 | 2021-05-27 | Sullivan | Pennsylvania | 42113 | 431 | 20 |
1357782 | 1357782 | 2021-05-26 | Sullivan | Pennsylvania | 42113 | 431 | 20 |
1354536 | 1354536 | 2021-05-25 | Sullivan | Pennsylvania | 42113 | 431 | 20 |
1351290 | 1351290 | 2021-05-24 | Sullivan | Pennsylvania | 42113 | 430 | 20 |
1348044 | 1348044 | 2021-05-23 | Sullivan | Pennsylvania | 42113 | 430 | 20 |
1344796 | 1344796 | 2021-05-22 | Sullivan | Pennsylvania | 42113 | 428 | 20 |
1341548 | 1341548 | 2021-05-21 | Sullivan | Pennsylvania | 42113 | 428 | 20 |
1338300 | 1338300 | 2021-05-20 | Sullivan | Pennsylvania | 42113 | 428 | 20 |
1335053 | 1335053 | 2021-05-19 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1331806 | 1331806 | 2021-05-18 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1328559 | 1328559 | 2021-05-17 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1325313 | 1325313 | 2021-05-16 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1322067 | 1322067 | 2021-05-15 | Sullivan | Pennsylvania | 42113 | 429 | 20 |
1318821 | 1318821 | 2021-05-14 | Sullivan | Pennsylvania | 42113 | 427 | 20 |
1315573 | 1315573 | 2021-05-13 | Sullivan | Pennsylvania | 42113 | 426 | 20 |
1312327 | 1312327 | 2021-05-12 | Sullivan | Pennsylvania | 42113 | 425 | 20 |
1309080 | 1309080 | 2021-05-11 | Sullivan | Pennsylvania | 42113 | 423 | 20 |
1305834 | 1305834 | 2021-05-10 | Sullivan | Pennsylvania | 42113 | 420 | 20 |
1302588 | 1302588 | 2021-05-09 | Sullivan | Pennsylvania | 42113 | 418 | 20 |
1299341 | 1299341 | 2021-05-08 | Sullivan | Pennsylvania | 42113 | 417 | 20 |
1296094 | 1296094 | 2021-05-07 | Sullivan | Pennsylvania | 42113 | 415 | 20 |
1292848 | 1292848 | 2021-05-06 | Sullivan | Pennsylvania | 42113 | 414 | 20 |
1289602 | 1289602 | 2021-05-05 | Sullivan | Pennsylvania | 42113 | 411 | 20 |
1286356 | 1286356 | 2021-05-04 | Sullivan | Pennsylvania | 42113 | 411 | 20 |
1283110 | 1283110 | 2021-05-03 | Sullivan | Pennsylvania | 42113 | 411 | 20 |
1279863 | 1279863 | 2021-05-02 | Sullivan | Pennsylvania | 42113 | 409 | 20 |
1276616 | 1276616 | 2021-05-01 | Sullivan | Pennsylvania | 42113 | 408 | 20 |
1273369 | 1273369 | 2021-04-30 | Sullivan | Pennsylvania | 42113 | 405 | 20 |
1270122 | 1270122 | 2021-04-29 | Sullivan | Pennsylvania | 42113 | 401 | 20 |
1266875 | 1266875 | 2021-04-28 | Sullivan | Pennsylvania | 42113 | 397 | 20 |
1263628 | 1263628 | 2021-04-27 | Sullivan | Pennsylvania | 42113 | 397 | 20 |
1260381 | 1260381 | 2021-04-26 | Sullivan | Pennsylvania | 42113 | 394 | 20 |
1257134 | 1257134 | 2021-04-25 | Sullivan | Pennsylvania | 42113 | 391 | 20 |
1253887 | 1253887 | 2021-04-24 | Sullivan | Pennsylvania | 42113 | 390 | 20 |
1250640 | 1250640 | 2021-04-23 | Sullivan | Pennsylvania | 42113 | 387 | 20 |
1247393 | 1247393 | 2021-04-22 | Sullivan | Pennsylvania | 42113 | 387 | 20 |
1244146 | 1244146 | 2021-04-21 | Sullivan | Pennsylvania | 42113 | 382 | 20 |
1240899 | 1240899 | 2021-04-20 | Sullivan | Pennsylvania | 42113 | 378 | 20 |
1237652 | 1237652 | 2021-04-19 | Sullivan | Pennsylvania | 42113 | 376 | 20 |
1234405 | 1234405 | 2021-04-18 | Sullivan | Pennsylvania | 42113 | 374 | 20 |
1231157 | 1231157 | 2021-04-17 | Sullivan | Pennsylvania | 42113 | 374 | 20 |
1227909 | 1227909 | 2021-04-16 | Sullivan | Pennsylvania | 42113 | 371 | 20 |
1224661 | 1224661 | 2021-04-15 | Sullivan | Pennsylvania | 42113 | 368 | 20 |
1221414 | 1221414 | 2021-04-14 | Sullivan | Pennsylvania | 42113 | 367 | 20 |
1218166 | 1218166 | 2021-04-13 | Sullivan | Pennsylvania | 42113 | 364 | 20 |
1214918 | 1214918 | 2021-04-12 | Sullivan | Pennsylvania | 42113 | 366 | 20 |
1211671 | 1211671 | 2021-04-11 | Sullivan | Pennsylvania | 42113 | 366 | 20 |
1208422 | 1208422 | 2021-04-10 | Sullivan | Pennsylvania | 42113 | 361 | 20 |
1205174 | 1205174 | 2021-04-09 | Sullivan | Pennsylvania | 42113 | 357 | 20 |
1201926 | 1201926 | 2021-04-08 | Sullivan | Pennsylvania | 42113 | 355 | 20 |
1198677 | 1198677 | 2021-04-07 | Sullivan | Pennsylvania | 42113 | 351 | 20 |
1195428 | 1195428 | 2021-04-06 | Sullivan | Pennsylvania | 42113 | 350 | 20 |
1192180 | 1192180 | 2021-04-05 | Sullivan | Pennsylvania | 42113 | 350 | 20 |
1188931 | 1188931 | 2021-04-04 | Sullivan | Pennsylvania | 42113 | 350 | 20 |
1185684 | 1185684 | 2021-04-03 | Sullivan | Pennsylvania | 42113 | 349 | 20 |
1182437 | 1182437 | 2021-04-02 | Sullivan | Pennsylvania | 42113 | 346 | 20 |
1179190 | 1179190 | 2021-04-01 | Sullivan | Pennsylvania | 42113 | 345 | 20 |
1175943 | 1175943 | 2021-03-31 | Sullivan | Pennsylvania | 42113 | 342 | 20 |
1172696 | 1172696 | 2021-03-30 | Sullivan | Pennsylvania | 42113 | 342 | 20 |
1169449 | 1169449 | 2021-03-29 | Sullivan | Pennsylvania | 42113 | 340 | 20 |
1166201 | 1166201 | 2021-03-28 | Sullivan | Pennsylvania | 42113 | 340 | 20 |
1162953 | 1162953 | 2021-03-27 | Sullivan | Pennsylvania | 42113 | 340 | 20 |
1159704 | 1159704 | 2021-03-26 | Sullivan | Pennsylvania | 42113 | 340 | 20 |
1156457 | 1156457 | 2021-03-25 | Sullivan | Pennsylvania | 42113 | 339 | 20 |
1153210 | 1153210 | 2021-03-24 | Sullivan | Pennsylvania | 42113 | 339 | 20 |
1149963 | 1149963 | 2021-03-23 | Sullivan | Pennsylvania | 42113 | 339 | 20 |
1146716 | 1146716 | 2021-03-22 | Sullivan | Pennsylvania | 42113 | 338 | 20 |
1143469 | 1143469 | 2021-03-21 | Sullivan | Pennsylvania | 42113 | 338 | 20 |
1140222 | 1140222 | 2021-03-20 | Sullivan | Pennsylvania | 42113 | 338 | 20 |
1136976 | 1136976 | 2021-03-19 | Sullivan | Pennsylvania | 42113 | 337 | 20 |
1133730 | 1133730 | 2021-03-18 | Sullivan | Pennsylvania | 42113 | 336 | 20 |
1130482 | 1130482 | 2021-03-17 | Sullivan | Pennsylvania | 42113 | 336 | 20 |
1127235 | 1127235 | 2021-03-16 | Sullivan | Pennsylvania | 42113 | 330 | 20 |
1123989 | 1123989 | 2021-03-15 | Sullivan | Pennsylvania | 42113 | 319 | 20 |
1120743 | 1120743 | 2021-03-14 | Sullivan | Pennsylvania | 42113 | 320 | 20 |
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);