ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 51036 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280490 | 1280490 | 2021-05-02 | Charles City | Virginia | 51036 | 498 | 15 |
1277243 | 1277243 | 2021-05-01 | Charles City | Virginia | 51036 | 498 | 15 |
1273996 | 1273996 | 2021-04-30 | Charles City | Virginia | 51036 | 497 | 15 |
1270749 | 1270749 | 2021-04-29 | Charles City | Virginia | 51036 | 494 | 15 |
1267502 | 1267502 | 2021-04-28 | Charles City | Virginia | 51036 | 494 | 15 |
1264255 | 1264255 | 2021-04-27 | Charles City | Virginia | 51036 | 494 | 15 |
1261008 | 1261008 | 2021-04-26 | Charles City | Virginia | 51036 | 494 | 15 |
1257761 | 1257761 | 2021-04-25 | Charles City | Virginia | 51036 | 493 | 15 |
1254514 | 1254514 | 2021-04-24 | Charles City | Virginia | 51036 | 492 | 15 |
1251267 | 1251267 | 2021-04-23 | Charles City | Virginia | 51036 | 492 | 15 |
1248020 | 1248020 | 2021-04-22 | Charles City | Virginia | 51036 | 491 | 15 |
1244773 | 1244773 | 2021-04-21 | Charles City | Virginia | 51036 | 489 | 15 |
1241526 | 1241526 | 2021-04-20 | Charles City | Virginia | 51036 | 487 | 15 |
1238279 | 1238279 | 2021-04-19 | Charles City | Virginia | 51036 | 487 | 15 |
1235032 | 1235032 | 2021-04-18 | Charles City | Virginia | 51036 | 485 | 15 |
1231784 | 1231784 | 2021-04-17 | Charles City | Virginia | 51036 | 481 | 15 |
1228536 | 1228536 | 2021-04-16 | Charles City | Virginia | 51036 | 479 | 15 |
1225288 | 1225288 | 2021-04-15 | Charles City | Virginia | 51036 | 478 | 15 |
1222041 | 1222041 | 2021-04-14 | Charles City | Virginia | 51036 | 474 | 15 |
1218793 | 1218793 | 2021-04-13 | Charles City | Virginia | 51036 | 469 | 15 |
1215545 | 1215545 | 2021-04-12 | Charles City | Virginia | 51036 | 470 | 15 |
1212298 | 1212298 | 2021-04-11 | Charles City | Virginia | 51036 | 466 | 15 |
1209049 | 1209049 | 2021-04-10 | Charles City | Virginia | 51036 | 466 | 15 |
1205801 | 1205801 | 2021-04-09 | Charles City | Virginia | 51036 | 466 | 15 |
1202553 | 1202553 | 2021-04-08 | Charles City | Virginia | 51036 | 461 | 15 |
1199305 | 1199305 | 2021-04-07 | Charles City | Virginia | 51036 | 460 | 15 |
1196056 | 1196056 | 2021-04-06 | Charles City | Virginia | 51036 | 459 | 15 |
1192808 | 1192808 | 2021-04-05 | Charles City | Virginia | 51036 | 458 | 15 |
1189558 | 1189558 | 2021-04-04 | Charles City | Virginia | 51036 | 458 | 15 |
1186311 | 1186311 | 2021-04-03 | Charles City | Virginia | 51036 | 457 | 15 |
1183064 | 1183064 | 2021-04-02 | Charles City | Virginia | 51036 | 457 | 15 |
1179817 | 1179817 | 2021-04-01 | Charles City | Virginia | 51036 | 453 | 15 |
1176570 | 1176570 | 2021-03-31 | Charles City | Virginia | 51036 | 451 | 15 |
1173323 | 1173323 | 2021-03-30 | Charles City | Virginia | 51036 | 449 | 15 |
1170076 | 1170076 | 2021-03-29 | Charles City | Virginia | 51036 | 448 | 15 |
1166828 | 1166828 | 2021-03-28 | Charles City | Virginia | 51036 | 445 | 15 |
1163580 | 1163580 | 2021-03-27 | Charles City | Virginia | 51036 | 441 | 15 |
1160332 | 1160332 | 2021-03-26 | Charles City | Virginia | 51036 | 439 | 15 |
1157084 | 1157084 | 2021-03-25 | Charles City | Virginia | 51036 | 439 | 15 |
1153837 | 1153837 | 2021-03-24 | Charles City | Virginia | 51036 | 438 | 15 |
1150590 | 1150590 | 2021-03-23 | Charles City | Virginia | 51036 | 438 | 15 |
1147343 | 1147343 | 2021-03-22 | Charles City | Virginia | 51036 | 435 | 15 |
1144096 | 1144096 | 2021-03-21 | Charles City | Virginia | 51036 | 431 | 15 |
1140849 | 1140849 | 2021-03-20 | Charles City | Virginia | 51036 | 427 | 15 |
1137603 | 1137603 | 2021-03-19 | Charles City | Virginia | 51036 | 426 | 15 |
1134357 | 1134357 | 2021-03-18 | Charles City | Virginia | 51036 | 426 | 15 |
1131109 | 1131109 | 2021-03-17 | Charles City | Virginia | 51036 | 424 | 15 |
1127862 | 1127862 | 2021-03-16 | Charles City | Virginia | 51036 | 424 | 15 |
1124616 | 1124616 | 2021-03-15 | Charles City | Virginia | 51036 | 422 | 13 |
1121370 | 1121370 | 2021-03-14 | Charles City | Virginia | 51036 | 421 | 13 |
1118123 | 1118123 | 2021-03-13 | Charles City | Virginia | 51036 | 419 | 13 |
1114876 | 1114876 | 2021-03-12 | Charles City | Virginia | 51036 | 419 | 13 |
1111630 | 1111630 | 2021-03-11 | Charles City | Virginia | 51036 | 417 | 13 |
1108384 | 1108384 | 2021-03-10 | Charles City | Virginia | 51036 | 416 | 13 |
1105138 | 1105138 | 2021-03-09 | Charles City | Virginia | 51036 | 414 | 13 |
1101892 | 1101892 | 2021-03-08 | Charles City | Virginia | 51036 | 413 | 12 |
1098646 | 1098646 | 2021-03-07 | Charles City | Virginia | 51036 | 413 | 12 |
1095398 | 1095398 | 2021-03-06 | Charles City | Virginia | 51036 | 412 | 12 |
1092152 | 1092152 | 2021-03-05 | Charles City | Virginia | 51036 | 410 | 12 |
1088906 | 1088906 | 2021-03-04 | Charles City | Virginia | 51036 | 408 | 12 |
1085661 | 1085661 | 2021-03-03 | Charles City | Virginia | 51036 | 402 | 11 |
1082415 | 1082415 | 2021-03-02 | Charles City | Virginia | 51036 | 401 | 11 |
1079169 | 1079169 | 2021-03-01 | Charles City | Virginia | 51036 | 398 | 11 |
1075924 | 1075924 | 2021-02-28 | Charles City | Virginia | 51036 | 398 | 11 |
1072678 | 1072678 | 2021-02-27 | Charles City | Virginia | 51036 | 397 | 11 |
1069432 | 1069432 | 2021-02-26 | Charles City | Virginia | 51036 | 397 | 11 |
1066187 | 1066187 | 2021-02-25 | Charles City | Virginia | 51036 | 396 | 11 |
1062942 | 1062942 | 2021-02-24 | Charles City | Virginia | 51036 | 393 | 10 |
1059697 | 1059697 | 2021-02-23 | Charles City | Virginia | 51036 | 392 | 10 |
1056451 | 1056451 | 2021-02-22 | Charles City | Virginia | 51036 | 392 | 10 |
1053205 | 1053205 | 2021-02-21 | Charles City | Virginia | 51036 | 391 | 10 |
1049958 | 1049958 | 2021-02-20 | Charles City | Virginia | 51036 | 389 | 10 |
1046711 | 1046711 | 2021-02-19 | Charles City | Virginia | 51036 | 388 | 10 |
1043466 | 1043466 | 2021-02-18 | Charles City | Virginia | 51036 | 387 | 10 |
1040221 | 1040221 | 2021-02-17 | Charles City | Virginia | 51036 | 385 | 10 |
1036976 | 1036976 | 2021-02-16 | Charles City | Virginia | 51036 | 382 | 10 |
1033731 | 1033731 | 2021-02-15 | Charles City | Virginia | 51036 | 378 | 10 |
1030485 | 1030485 | 2021-02-14 | Charles City | Virginia | 51036 | 377 | 10 |
1027238 | 1027238 | 2021-02-13 | Charles City | Virginia | 51036 | 376 | 10 |
1023993 | 1023993 | 2021-02-12 | Charles City | Virginia | 51036 | 373 | 10 |
1020748 | 1020748 | 2021-02-11 | Charles City | Virginia | 51036 | 371 | 10 |
1017503 | 1017503 | 2021-02-10 | Charles City | Virginia | 51036 | 369 | 10 |
1014258 | 1014258 | 2021-02-09 | Charles City | Virginia | 51036 | 365 | 10 |
1011013 | 1011013 | 2021-02-08 | Charles City | Virginia | 51036 | 366 | 10 |
1007767 | 1007767 | 2021-02-07 | Charles City | Virginia | 51036 | 362 | 10 |
1004521 | 1004521 | 2021-02-06 | Charles City | Virginia | 51036 | 359 | 10 |
1001275 | 1001275 | 2021-02-05 | Charles City | Virginia | 51036 | 357 | 10 |
998029 | 998029 | 2021-02-04 | Charles City | Virginia | 51036 | 351 | 10 |
994783 | 994783 | 2021-02-03 | Charles City | Virginia | 51036 | 348 | 9 |
991537 | 991537 | 2021-02-02 | Charles City | Virginia | 51036 | 345 | 9 |
988291 | 988291 | 2021-02-01 | Charles City | Virginia | 51036 | 345 | 9 |
985044 | 985044 | 2021-01-31 | Charles City | Virginia | 51036 | 342 | 9 |
981797 | 981797 | 2021-01-30 | Charles City | Virginia | 51036 | 340 | 9 |
978551 | 978551 | 2021-01-29 | Charles City | Virginia | 51036 | 338 | 9 |
975306 | 975306 | 2021-01-28 | Charles City | Virginia | 51036 | 335 | 9 |
972061 | 972061 | 2021-01-27 | Charles City | Virginia | 51036 | 333 | 9 |
968816 | 968816 | 2021-01-26 | Charles City | Virginia | 51036 | 328 | 9 |
965572 | 965572 | 2021-01-25 | Charles City | Virginia | 51036 | 326 | 9 |
962327 | 962327 | 2021-01-24 | Charles City | Virginia | 51036 | 321 | 9 |
959082 | 959082 | 2021-01-23 | Charles City | Virginia | 51036 | 319 | 9 |
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);