ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 51177 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637922 | 637922 | 2020-10-16 | Spotsylvania | Virginia | 51177 | 2306 | 46 |
634677 | 634677 | 2020-10-15 | Spotsylvania | Virginia | 51177 | 2298 | 46 |
631432 | 631432 | 2020-10-14 | Spotsylvania | Virginia | 51177 | 2282 | 46 |
628188 | 628188 | 2020-10-13 | Spotsylvania | Virginia | 51177 | 2278 | 46 |
624945 | 624945 | 2020-10-12 | Spotsylvania | Virginia | 51177 | 2273 | 46 |
621702 | 621702 | 2020-10-11 | Spotsylvania | Virginia | 51177 | 2260 | 46 |
618459 | 618459 | 2020-10-10 | Spotsylvania | Virginia | 51177 | 2250 | 46 |
615217 | 615217 | 2020-10-09 | Spotsylvania | Virginia | 51177 | 2231 | 46 |
611976 | 611976 | 2020-10-08 | Spotsylvania | Virginia | 51177 | 2217 | 46 |
608734 | 608734 | 2020-10-07 | Spotsylvania | Virginia | 51177 | 2197 | 46 |
605491 | 605491 | 2020-10-06 | Spotsylvania | Virginia | 51177 | 2195 | 46 |
602249 | 602249 | 2020-10-05 | Spotsylvania | Virginia | 51177 | 2191 | 46 |
599006 | 599006 | 2020-10-04 | Spotsylvania | Virginia | 51177 | 2187 | 46 |
595763 | 595763 | 2020-10-03 | Spotsylvania | Virginia | 51177 | 2177 | 46 |
592521 | 592521 | 2020-10-02 | Spotsylvania | Virginia | 51177 | 2170 | 46 |
589281 | 589281 | 2020-10-01 | Spotsylvania | Virginia | 51177 | 2161 | 46 |
586040 | 586040 | 2020-09-30 | Spotsylvania | Virginia | 51177 | 2153 | 44 |
582800 | 582800 | 2020-09-29 | Spotsylvania | Virginia | 51177 | 2151 | 44 |
579561 | 579561 | 2020-09-28 | Spotsylvania | Virginia | 51177 | 2145 | 44 |
576320 | 576320 | 2020-09-27 | Spotsylvania | Virginia | 51177 | 2136 | 44 |
573076 | 573076 | 2020-09-26 | Spotsylvania | Virginia | 51177 | 2131 | 44 |
569834 | 569834 | 2020-09-25 | Spotsylvania | Virginia | 51177 | 2121 | 44 |
566593 | 566593 | 2020-09-24 | Spotsylvania | Virginia | 51177 | 2119 | 44 |
563352 | 563352 | 2020-09-23 | Spotsylvania | Virginia | 51177 | 2106 | 43 |
560113 | 560113 | 2020-09-22 | Spotsylvania | Virginia | 51177 | 2099 | 44 |
556877 | 556877 | 2020-09-21 | Spotsylvania | Virginia | 51177 | 2088 | 43 |
553640 | 553640 | 2020-09-20 | Spotsylvania | Virginia | 51177 | 2082 | 43 |
550401 | 550401 | 2020-09-19 | Spotsylvania | Virginia | 51177 | 2076 | 43 |
547162 | 547162 | 2020-09-18 | Spotsylvania | Virginia | 51177 | 2067 | 42 |
543925 | 543925 | 2020-09-17 | Spotsylvania | Virginia | 51177 | 2060 | 42 |
540689 | 540689 | 2020-09-16 | Spotsylvania | Virginia | 51177 | 2041 | 43 |
537452 | 537452 | 2020-09-15 | Spotsylvania | Virginia | 51177 | 2029 | 41 |
534216 | 534216 | 2020-09-14 | Spotsylvania | Virginia | 51177 | 2014 | 39 |
530981 | 530981 | 2020-09-13 | Spotsylvania | Virginia | 51177 | 2011 | 39 |
527744 | 527744 | 2020-09-12 | Spotsylvania | Virginia | 51177 | 2002 | 39 |
524508 | 524508 | 2020-09-11 | Spotsylvania | Virginia | 51177 | 1973 | 39 |
521272 | 521272 | 2020-09-10 | Spotsylvania | Virginia | 51177 | 1952 | 39 |
518035 | 518035 | 2020-09-09 | Spotsylvania | Virginia | 51177 | 1926 | 39 |
514800 | 514800 | 2020-09-08 | Spotsylvania | Virginia | 51177 | 1905 | 39 |
511567 | 511567 | 2020-09-07 | Spotsylvania | Virginia | 51177 | 1892 | 39 |
508334 | 508334 | 2020-09-06 | Spotsylvania | Virginia | 51177 | 1885 | 39 |
505102 | 505102 | 2020-09-05 | Spotsylvania | Virginia | 51177 | 1871 | 39 |
501868 | 501868 | 2020-09-04 | Spotsylvania | Virginia | 51177 | 1863 | 39 |
498634 | 498634 | 2020-09-03 | Spotsylvania | Virginia | 51177 | 1853 | 38 |
495401 | 495401 | 2020-09-02 | Spotsylvania | Virginia | 51177 | 1836 | 38 |
492167 | 492167 | 2020-09-01 | Spotsylvania | Virginia | 51177 | 1824 | 38 |
488934 | 488934 | 2020-08-31 | Spotsylvania | Virginia | 51177 | 1801 | 38 |
485701 | 485701 | 2020-08-30 | Spotsylvania | Virginia | 51177 | 1793 | 38 |
482466 | 482466 | 2020-08-29 | Spotsylvania | Virginia | 51177 | 1781 | 38 |
479232 | 479232 | 2020-08-28 | Spotsylvania | Virginia | 51177 | 1769 | 38 |
475999 | 475999 | 2020-08-27 | Spotsylvania | Virginia | 51177 | 1759 | 38 |
472766 | 472766 | 2020-08-26 | Spotsylvania | Virginia | 51177 | 1735 | 37 |
469534 | 469534 | 2020-08-25 | Spotsylvania | Virginia | 51177 | 1730 | 37 |
466305 | 466305 | 2020-08-24 | Spotsylvania | Virginia | 51177 | 1718 | 37 |
463076 | 463076 | 2020-08-23 | Spotsylvania | Virginia | 51177 | 1701 | 37 |
459847 | 459847 | 2020-08-22 | Spotsylvania | Virginia | 51177 | 1691 | 36 |
456620 | 456620 | 2020-08-21 | Spotsylvania | Virginia | 51177 | 1673 | 35 |
453392 | 453392 | 2020-08-20 | Spotsylvania | Virginia | 51177 | 1662 | 35 |
450164 | 450164 | 2020-08-19 | Spotsylvania | Virginia | 51177 | 1649 | 35 |
446936 | 446936 | 2020-08-18 | Spotsylvania | Virginia | 51177 | 1642 | 36 |
443709 | 443709 | 2020-08-17 | Spotsylvania | Virginia | 51177 | 1621 | 35 |
440483 | 440483 | 2020-08-16 | Spotsylvania | Virginia | 51177 | 1607 | 35 |
437257 | 437257 | 2020-08-15 | Spotsylvania | Virginia | 51177 | 1598 | 35 |
434031 | 434031 | 2020-08-14 | Spotsylvania | Virginia | 51177 | 1581 | 35 |
430806 | 430806 | 2020-08-13 | Spotsylvania | Virginia | 51177 | 1570 | 35 |
427578 | 427578 | 2020-08-12 | Spotsylvania | Virginia | 51177 | 1536 | 35 |
424354 | 424354 | 2020-08-11 | Spotsylvania | Virginia | 51177 | 1514 | 36 |
421133 | 421133 | 2020-08-10 | Spotsylvania | Virginia | 51177 | 1499 | 35 |
417912 | 417912 | 2020-08-09 | Spotsylvania | Virginia | 51177 | 1486 | 35 |
414691 | 414691 | 2020-08-08 | Spotsylvania | Virginia | 51177 | 1471 | 35 |
411471 | 411471 | 2020-08-07 | Spotsylvania | Virginia | 51177 | 1449 | 35 |
408252 | 408252 | 2020-08-06 | Spotsylvania | Virginia | 51177 | 1421 | 35 |
405032 | 405032 | 2020-08-05 | Spotsylvania | Virginia | 51177 | 1390 | 35 |
401814 | 401814 | 2020-08-04 | Spotsylvania | Virginia | 51177 | 1375 | 34 |
398598 | 398598 | 2020-08-03 | Spotsylvania | Virginia | 51177 | 1357 | 34 |
395382 | 395382 | 2020-08-02 | Spotsylvania | Virginia | 51177 | 1332 | 35 |
392166 | 392166 | 2020-08-01 | Spotsylvania | Virginia | 51177 | 1318 | 35 |
388949 | 388949 | 2020-07-31 | Spotsylvania | Virginia | 51177 | 1305 | 33 |
385732 | 385732 | 2020-07-30 | Spotsylvania | Virginia | 51177 | 1291 | 33 |
382514 | 382514 | 2020-07-29 | Spotsylvania | Virginia | 51177 | 1271 | 33 |
379297 | 379297 | 2020-07-28 | Spotsylvania | Virginia | 51177 | 1254 | 33 |
376081 | 376081 | 2020-07-27 | Spotsylvania | Virginia | 51177 | 1244 | 33 |
372867 | 372867 | 2020-07-26 | Spotsylvania | Virginia | 51177 | 1225 | 32 |
369655 | 369655 | 2020-07-25 | Spotsylvania | Virginia | 51177 | 1212 | 32 |
366446 | 366446 | 2020-07-24 | Spotsylvania | Virginia | 51177 | 1213 | 33 |
363240 | 363240 | 2020-07-23 | Spotsylvania | Virginia | 51177 | 1212 | 33 |
360034 | 360034 | 2020-07-22 | Spotsylvania | Virginia | 51177 | 1197 | 33 |
356829 | 356829 | 2020-07-21 | Spotsylvania | Virginia | 51177 | 1168 | 33 |
353626 | 353626 | 2020-07-20 | Spotsylvania | Virginia | 51177 | 1154 | 32 |
350424 | 350424 | 2020-07-19 | Spotsylvania | Virginia | 51177 | 1148 | 32 |
347223 | 347223 | 2020-07-18 | Spotsylvania | Virginia | 51177 | 1136 | 32 |
344023 | 344023 | 2020-07-17 | Spotsylvania | Virginia | 51177 | 1124 | 32 |
340824 | 340824 | 2020-07-16 | Spotsylvania | Virginia | 51177 | 1108 | 31 |
337628 | 337628 | 2020-07-15 | Spotsylvania | Virginia | 51177 | 1094 | 32 |
334433 | 334433 | 2020-07-14 | Spotsylvania | Virginia | 51177 | 1088 | 32 |
331240 | 331240 | 2020-07-13 | Spotsylvania | Virginia | 51177 | 1083 | 31 |
328054 | 328054 | 2020-07-12 | Spotsylvania | Virginia | 51177 | 1082 | 31 |
324869 | 324869 | 2020-07-11 | Spotsylvania | Virginia | 51177 | 1076 | 31 |
321688 | 321688 | 2020-07-10 | Spotsylvania | Virginia | 51177 | 1077 | 31 |
318509 | 318509 | 2020-07-09 | Spotsylvania | Virginia | 51177 | 1060 | 31 |
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);