ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Rappahannock" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420156 | 1420156 | 2021-06-14 | Rappahannock | Virginia | 51157 | 346 | 2 |
1416911 | 1416911 | 2021-06-13 | Rappahannock | Virginia | 51157 | 346 | 2 |
1413665 | 1413665 | 2021-06-12 | Rappahannock | Virginia | 51157 | 346 | 2 |
1410420 | 1410420 | 2021-06-11 | Rappahannock | Virginia | 51157 | 346 | 2 |
1407175 | 1407175 | 2021-06-10 | Rappahannock | Virginia | 51157 | 344 | 2 |
1403929 | 1403929 | 2021-06-09 | Rappahannock | Virginia | 51157 | 344 | 2 |
1400684 | 1400684 | 2021-06-08 | Rappahannock | Virginia | 51157 | 344 | 2 |
1397439 | 1397439 | 2021-06-07 | Rappahannock | Virginia | 51157 | 344 | 2 |
1394192 | 1394192 | 2021-06-06 | Rappahannock | Virginia | 51157 | 344 | 2 |
1390947 | 1390947 | 2021-06-05 | Rappahannock | Virginia | 51157 | 344 | 2 |
1387702 | 1387702 | 2021-06-04 | Rappahannock | Virginia | 51157 | 344 | 2 |
1384457 | 1384457 | 2021-06-03 | Rappahannock | Virginia | 51157 | 344 | 2 |
1381211 | 1381211 | 2021-06-02 | Rappahannock | Virginia | 51157 | 344 | 2 |
1377966 | 1377966 | 2021-06-01 | Rappahannock | Virginia | 51157 | 343 | 2 |
1374720 | 1374720 | 2021-05-31 | Rappahannock | Virginia | 51157 | 343 | 2 |
1371475 | 1371475 | 2021-05-30 | Rappahannock | Virginia | 51157 | 343 | 2 |
1368229 | 1368229 | 2021-05-29 | Rappahannock | Virginia | 51157 | 343 | 2 |
1364983 | 1364983 | 2021-05-28 | Rappahannock | Virginia | 51157 | 343 | 2 |
1361737 | 1361737 | 2021-05-27 | Rappahannock | Virginia | 51157 | 343 | 2 |
1358491 | 1358491 | 2021-05-26 | Rappahannock | Virginia | 51157 | 349 | 2 |
1355245 | 1355245 | 2021-05-25 | Rappahannock | Virginia | 51157 | 361 | 2 |
1351999 | 1351999 | 2021-05-24 | Rappahannock | Virginia | 51157 | 359 | 2 |
1348753 | 1348753 | 2021-05-23 | Rappahannock | Virginia | 51157 | 359 | 2 |
1345505 | 1345505 | 2021-05-22 | Rappahannock | Virginia | 51157 | 359 | 2 |
1342257 | 1342257 | 2021-05-21 | Rappahannock | Virginia | 51157 | 359 | 2 |
1339009 | 1339009 | 2021-05-20 | Rappahannock | Virginia | 51157 | 360 | 2 |
1335762 | 1335762 | 2021-05-19 | Rappahannock | Virginia | 51157 | 360 | 2 |
1332515 | 1332515 | 2021-05-18 | Rappahannock | Virginia | 51157 | 359 | 2 |
1329268 | 1329268 | 2021-05-17 | Rappahannock | Virginia | 51157 | 359 | 2 |
1326022 | 1326022 | 2021-05-16 | Rappahannock | Virginia | 51157 | 359 | 2 |
1322776 | 1322776 | 2021-05-15 | Rappahannock | Virginia | 51157 | 359 | 2 |
1319530 | 1319530 | 2021-05-14 | Rappahannock | Virginia | 51157 | 356 | 2 |
1316282 | 1316282 | 2021-05-13 | Rappahannock | Virginia | 51157 | 356 | 2 |
1313036 | 1313036 | 2021-05-12 | Rappahannock | Virginia | 51157 | 354 | 2 |
1309789 | 1309789 | 2021-05-11 | Rappahannock | Virginia | 51157 | 354 | 2 |
1306543 | 1306543 | 2021-05-10 | Rappahannock | Virginia | 51157 | 354 | 2 |
1303297 | 1303297 | 2021-05-09 | Rappahannock | Virginia | 51157 | 354 | 2 |
1300050 | 1300050 | 2021-05-08 | Rappahannock | Virginia | 51157 | 353 | 2 |
1296803 | 1296803 | 2021-05-07 | Rappahannock | Virginia | 51157 | 352 | 2 |
1293557 | 1293557 | 2021-05-06 | Rappahannock | Virginia | 51157 | 352 | 2 |
1290311 | 1290311 | 2021-05-05 | Rappahannock | Virginia | 51157 | 349 | 2 |
1287065 | 1287065 | 2021-05-04 | Rappahannock | Virginia | 51157 | 347 | 2 |
1283819 | 1283819 | 2021-05-03 | Rappahannock | Virginia | 51157 | 347 | 2 |
1280572 | 1280572 | 2021-05-02 | Rappahannock | Virginia | 51157 | 347 | 2 |
1277325 | 1277325 | 2021-05-01 | Rappahannock | Virginia | 51157 | 346 | 2 |
1274078 | 1274078 | 2021-04-30 | Rappahannock | Virginia | 51157 | 342 | 2 |
1270831 | 1270831 | 2021-04-29 | Rappahannock | Virginia | 51157 | 339 | 2 |
1267584 | 1267584 | 2021-04-28 | Rappahannock | Virginia | 51157 | 339 | 2 |
1264337 | 1264337 | 2021-04-27 | Rappahannock | Virginia | 51157 | 338 | 2 |
1261090 | 1261090 | 2021-04-26 | Rappahannock | Virginia | 51157 | 338 | 2 |
1257843 | 1257843 | 2021-04-25 | Rappahannock | Virginia | 51157 | 337 | 2 |
1254596 | 1254596 | 2021-04-24 | Rappahannock | Virginia | 51157 | 336 | 2 |
1251349 | 1251349 | 2021-04-23 | Rappahannock | Virginia | 51157 | 334 | 2 |
1248102 | 1248102 | 2021-04-22 | Rappahannock | Virginia | 51157 | 334 | 2 |
1244855 | 1244855 | 2021-04-21 | Rappahannock | Virginia | 51157 | 333 | 2 |
1241608 | 1241608 | 2021-04-20 | Rappahannock | Virginia | 51157 | 333 | 2 |
1238361 | 1238361 | 2021-04-19 | Rappahannock | Virginia | 51157 | 331 | 2 |
1235114 | 1235114 | 2021-04-18 | Rappahannock | Virginia | 51157 | 331 | 2 |
1231866 | 1231866 | 2021-04-17 | Rappahannock | Virginia | 51157 | 331 | 2 |
1228618 | 1228618 | 2021-04-16 | Rappahannock | Virginia | 51157 | 332 | 2 |
1225370 | 1225370 | 2021-04-15 | Rappahannock | Virginia | 51157 | 332 | 2 |
1222123 | 1222123 | 2021-04-14 | Rappahannock | Virginia | 51157 | 330 | 2 |
1218875 | 1218875 | 2021-04-13 | Rappahannock | Virginia | 51157 | 329 | 2 |
1215627 | 1215627 | 2021-04-12 | Rappahannock | Virginia | 51157 | 328 | 2 |
1212380 | 1212380 | 2021-04-11 | Rappahannock | Virginia | 51157 | 327 | 2 |
1209131 | 1209131 | 2021-04-10 | Rappahannock | Virginia | 51157 | 326 | 2 |
1205883 | 1205883 | 2021-04-09 | Rappahannock | Virginia | 51157 | 326 | 2 |
1202635 | 1202635 | 2021-04-08 | Rappahannock | Virginia | 51157 | 327 | 2 |
1199387 | 1199387 | 2021-04-07 | Rappahannock | Virginia | 51157 | 326 | 2 |
1196138 | 1196138 | 2021-04-06 | Rappahannock | Virginia | 51157 | 325 | 2 |
1192890 | 1192890 | 2021-04-05 | Rappahannock | Virginia | 51157 | 324 | 2 |
1189640 | 1189640 | 2021-04-04 | Rappahannock | Virginia | 51157 | 323 | 2 |
1186393 | 1186393 | 2021-04-03 | Rappahannock | Virginia | 51157 | 322 | 2 |
1183146 | 1183146 | 2021-04-02 | Rappahannock | Virginia | 51157 | 321 | 2 |
1179899 | 1179899 | 2021-04-01 | Rappahannock | Virginia | 51157 | 321 | 2 |
1176652 | 1176652 | 2021-03-31 | Rappahannock | Virginia | 51157 | 320 | 2 |
1173405 | 1173405 | 2021-03-30 | Rappahannock | Virginia | 51157 | 320 | 2 |
1170158 | 1170158 | 2021-03-29 | Rappahannock | Virginia | 51157 | 320 | 2 |
1166910 | 1166910 | 2021-03-28 | Rappahannock | Virginia | 51157 | 319 | 2 |
1163662 | 1163662 | 2021-03-27 | Rappahannock | Virginia | 51157 | 317 | 2 |
1160414 | 1160414 | 2021-03-26 | Rappahannock | Virginia | 51157 | 316 | 2 |
1157166 | 1157166 | 2021-03-25 | Rappahannock | Virginia | 51157 | 316 | 2 |
1153919 | 1153919 | 2021-03-24 | Rappahannock | Virginia | 51157 | 315 | 2 |
1150672 | 1150672 | 2021-03-23 | Rappahannock | Virginia | 51157 | 314 | 2 |
1147425 | 1147425 | 2021-03-22 | Rappahannock | Virginia | 51157 | 315 | 2 |
1144178 | 1144178 | 2021-03-21 | Rappahannock | Virginia | 51157 | 315 | 2 |
1140931 | 1140931 | 2021-03-20 | Rappahannock | Virginia | 51157 | 314 | 2 |
1137685 | 1137685 | 2021-03-19 | Rappahannock | Virginia | 51157 | 313 | 2 |
1134439 | 1134439 | 2021-03-18 | Rappahannock | Virginia | 51157 | 313 | 2 |
1131191 | 1131191 | 2021-03-17 | Rappahannock | Virginia | 51157 | 313 | 2 |
1127944 | 1127944 | 2021-03-16 | Rappahannock | Virginia | 51157 | 311 | 2 |
1124698 | 1124698 | 2021-03-15 | Rappahannock | Virginia | 51157 | 310 | 2 |
1121452 | 1121452 | 2021-03-14 | Rappahannock | Virginia | 51157 | 310 | 2 |
1118205 | 1118205 | 2021-03-13 | Rappahannock | Virginia | 51157 | 310 | 2 |
1114958 | 1114958 | 2021-03-12 | Rappahannock | Virginia | 51157 | 311 | 2 |
1111712 | 1111712 | 2021-03-11 | Rappahannock | Virginia | 51157 | 311 | 2 |
1108466 | 1108466 | 2021-03-10 | Rappahannock | Virginia | 51157 | 308 | 2 |
1105220 | 1105220 | 2021-03-09 | Rappahannock | Virginia | 51157 | 308 | 2 |
1101974 | 1101974 | 2021-03-08 | Rappahannock | Virginia | 51157 | 308 | 2 |
1098728 | 1098728 | 2021-03-07 | Rappahannock | Virginia | 51157 | 308 | 2 |
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);