ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where county = "Cameron", deaths = 7 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 |
---|---|---|---|---|---|---|---|
1442125 | 1442125 | 2021-06-21 | Cameron | Pennsylvania | 42023 | 308 | 7 |
1438880 | 1438880 | 2021-06-20 | Cameron | Pennsylvania | 42023 | 308 | 7 |
1435633 | 1435633 | 2021-06-19 | Cameron | Pennsylvania | 42023 | 308 | 7 |
1432386 | 1432386 | 2021-06-18 | Cameron | Pennsylvania | 42023 | 308 | 7 |
1429140 | 1429140 | 2021-06-17 | Cameron | Pennsylvania | 42023 | 308 | 7 |
1425895 | 1425895 | 2021-06-16 | Cameron | Pennsylvania | 42023 | 307 | 7 |
1422648 | 1422648 | 2021-06-15 | Cameron | Pennsylvania | 42023 | 307 | 7 |
1419402 | 1419402 | 2021-06-14 | Cameron | Pennsylvania | 42023 | 307 | 7 |
1416157 | 1416157 | 2021-06-13 | Cameron | Pennsylvania | 42023 | 307 | 7 |
1412911 | 1412911 | 2021-06-12 | Cameron | Pennsylvania | 42023 | 306 | 7 |
1409666 | 1409666 | 2021-06-11 | Cameron | Pennsylvania | 42023 | 304 | 7 |
1406421 | 1406421 | 2021-06-10 | Cameron | Pennsylvania | 42023 | 304 | 7 |
1403175 | 1403175 | 2021-06-09 | Cameron | Pennsylvania | 42023 | 304 | 7 |
1399930 | 1399930 | 2021-06-08 | Cameron | Pennsylvania | 42023 | 304 | 7 |
1396685 | 1396685 | 2021-06-07 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1393438 | 1393438 | 2021-06-06 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1390193 | 1390193 | 2021-06-05 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1386948 | 1386948 | 2021-06-04 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1383703 | 1383703 | 2021-06-03 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1380457 | 1380457 | 2021-06-02 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1377212 | 1377212 | 2021-06-01 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1373966 | 1373966 | 2021-05-31 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1370721 | 1370721 | 2021-05-30 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1367475 | 1367475 | 2021-05-29 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1364229 | 1364229 | 2021-05-28 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1360983 | 1360983 | 2021-05-27 | Cameron | Pennsylvania | 42023 | 303 | 7 |
1357737 | 1357737 | 2021-05-26 | Cameron | Pennsylvania | 42023 | 301 | 7 |
1354491 | 1354491 | 2021-05-25 | Cameron | Pennsylvania | 42023 | 301 | 7 |
1351245 | 1351245 | 2021-05-24 | Cameron | Pennsylvania | 42023 | 301 | 7 |
1347999 | 1347999 | 2021-05-23 | Cameron | Pennsylvania | 42023 | 301 | 7 |
1263583 | 1263583 | 2021-04-27 | Cameron | Pennsylvania | 42023 | 287 | 7 |
1260336 | 1260336 | 2021-04-26 | Cameron | Pennsylvania | 42023 | 287 | 7 |
1257089 | 1257089 | 2021-04-25 | Cameron | Pennsylvania | 42023 | 287 | 7 |
1253842 | 1253842 | 2021-04-24 | Cameron | Pennsylvania | 42023 | 286 | 7 |
1250595 | 1250595 | 2021-04-23 | Cameron | Pennsylvania | 42023 | 286 | 7 |
1247348 | 1247348 | 2021-04-22 | Cameron | Pennsylvania | 42023 | 286 | 7 |
1244101 | 1244101 | 2021-04-21 | Cameron | Pennsylvania | 42023 | 286 | 7 |
1240854 | 1240854 | 2021-04-20 | Cameron | Pennsylvania | 42023 | 286 | 7 |
1237607 | 1237607 | 2021-04-19 | Cameron | Pennsylvania | 42023 | 286 | 7 |
1234360 | 1234360 | 2021-04-18 | Cameron | Pennsylvania | 42023 | 286 | 7 |
1231112 | 1231112 | 2021-04-17 | Cameron | Pennsylvania | 42023 | 286 | 7 |
1227864 | 1227864 | 2021-04-16 | Cameron | Pennsylvania | 42023 | 285 | 7 |
1224616 | 1224616 | 2021-04-15 | Cameron | Pennsylvania | 42023 | 285 | 7 |
1221369 | 1221369 | 2021-04-14 | Cameron | Pennsylvania | 42023 | 284 | 7 |
1218121 | 1218121 | 2021-04-13 | Cameron | Pennsylvania | 42023 | 284 | 7 |
1214873 | 1214873 | 2021-04-12 | Cameron | Pennsylvania | 42023 | 283 | 7 |
1211626 | 1211626 | 2021-04-11 | Cameron | Pennsylvania | 42023 | 283 | 7 |
1208377 | 1208377 | 2021-04-10 | Cameron | Pennsylvania | 42023 | 283 | 7 |
1205129 | 1205129 | 2021-04-09 | Cameron | Pennsylvania | 42023 | 283 | 7 |
1201881 | 1201881 | 2021-04-08 | Cameron | Pennsylvania | 42023 | 282 | 7 |
1198632 | 1198632 | 2021-04-07 | Cameron | Pennsylvania | 42023 | 281 | 7 |
1130437 | 1130437 | 2021-03-17 | Cameron | Pennsylvania | 42023 | 267 | 7 |
1127190 | 1127190 | 2021-03-16 | Cameron | Pennsylvania | 42023 | 267 | 7 |
1123944 | 1123944 | 2021-03-15 | Cameron | Pennsylvania | 42023 | 266 | 7 |
1120698 | 1120698 | 2021-03-14 | Cameron | Pennsylvania | 42023 | 266 | 7 |
1117451 | 1117451 | 2021-03-13 | Cameron | Pennsylvania | 42023 | 266 | 7 |
1114204 | 1114204 | 2021-03-12 | Cameron | Pennsylvania | 42023 | 266 | 7 |
1110958 | 1110958 | 2021-03-11 | Cameron | Pennsylvania | 42023 | 264 | 7 |
1107712 | 1107712 | 2021-03-10 | Cameron | Pennsylvania | 42023 | 264 | 7 |
1104466 | 1104466 | 2021-03-09 | Cameron | Pennsylvania | 42023 | 264 | 7 |
1101220 | 1101220 | 2021-03-08 | Cameron | Pennsylvania | 42023 | 264 | 7 |
1097974 | 1097974 | 2021-03-07 | Cameron | Pennsylvania | 42023 | 264 | 7 |
1094726 | 1094726 | 2021-03-06 | Cameron | Pennsylvania | 42023 | 264 | 7 |
1091480 | 1091480 | 2021-03-05 | Cameron | Pennsylvania | 42023 | 261 | 7 |
1088234 | 1088234 | 2021-03-04 | Cameron | Pennsylvania | 42023 | 261 | 7 |
1084989 | 1084989 | 2021-03-03 | Cameron | Pennsylvania | 42023 | 261 | 7 |
1081743 | 1081743 | 2021-03-02 | Cameron | Pennsylvania | 42023 | 261 | 7 |
1078497 | 1078497 | 2021-03-01 | Cameron | Pennsylvania | 42023 | 261 | 7 |
1075252 | 1075252 | 2021-02-28 | Cameron | Pennsylvania | 42023 | 260 | 7 |
1072006 | 1072006 | 2021-02-27 | Cameron | Pennsylvania | 42023 | 260 | 7 |
1068760 | 1068760 | 2021-02-26 | Cameron | Pennsylvania | 42023 | 260 | 7 |
1065515 | 1065515 | 2021-02-25 | Cameron | Pennsylvania | 42023 | 260 | 7 |
1062270 | 1062270 | 2021-02-24 | Cameron | Pennsylvania | 42023 | 257 | 7 |
1059025 | 1059025 | 2021-02-23 | Cameron | Pennsylvania | 42023 | 256 | 7 |
1055779 | 1055779 | 2021-02-22 | Cameron | Pennsylvania | 42023 | 256 | 7 |
1052533 | 1052533 | 2021-02-21 | Cameron | Pennsylvania | 42023 | 256 | 7 |
1049286 | 1049286 | 2021-02-20 | Cameron | Pennsylvania | 42023 | 255 | 7 |
1046039 | 1046039 | 2021-02-19 | Cameron | Pennsylvania | 42023 | 254 | 7 |
1042794 | 1042794 | 2021-02-18 | Cameron | Pennsylvania | 42023 | 253 | 7 |
1039549 | 1039549 | 2021-02-17 | Cameron | Pennsylvania | 42023 | 253 | 7 |
1036304 | 1036304 | 2021-02-16 | Cameron | Pennsylvania | 42023 | 252 | 7 |
1033059 | 1033059 | 2021-02-15 | Cameron | Pennsylvania | 42023 | 251 | 7 |
1029813 | 1029813 | 2021-02-14 | Cameron | Pennsylvania | 42023 | 250 | 7 |
1026566 | 1026566 | 2021-02-13 | Cameron | Pennsylvania | 42023 | 250 | 7 |
1023321 | 1023321 | 2021-02-12 | Cameron | Pennsylvania | 42023 | 250 | 7 |
1020076 | 1020076 | 2021-02-11 | Cameron | Pennsylvania | 42023 | 249 | 7 |
1016831 | 1016831 | 2021-02-10 | Cameron | Pennsylvania | 42023 | 247 | 7 |
1013586 | 1013586 | 2021-02-09 | Cameron | Pennsylvania | 42023 | 247 | 7 |
1010341 | 1010341 | 2021-02-08 | Cameron | Pennsylvania | 42023 | 247 | 7 |
1007095 | 1007095 | 2021-02-07 | Cameron | Pennsylvania | 42023 | 247 | 7 |
1003849 | 1003849 | 2021-02-06 | Cameron | Pennsylvania | 42023 | 246 | 7 |
1000603 | 1000603 | 2021-02-05 | Cameron | Pennsylvania | 42023 | 246 | 7 |
997357 | 997357 | 2021-02-04 | Cameron | Pennsylvania | 42023 | 245 | 7 |
994111 | 994111 | 2021-02-03 | Cameron | Pennsylvania | 42023 | 244 | 7 |
990865 | 990865 | 2021-02-02 | Cameron | Pennsylvania | 42023 | 244 | 7 |
987619 | 987619 | 2021-02-01 | Cameron | Pennsylvania | 42023 | 243 | 7 |
984372 | 984372 | 2021-01-31 | Cameron | Pennsylvania | 42023 | 243 | 7 |
981125 | 981125 | 2021-01-30 | Cameron | Pennsylvania | 42023 | 242 | 7 |
977879 | 977879 | 2021-01-29 | Cameron | Pennsylvania | 42023 | 239 | 7 |
974634 | 974634 | 2021-01-28 | Cameron | Pennsylvania | 42023 | 237 | 7 |
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);