ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Powhatan" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420150 | 1420150 | 2021-06-14 | Powhatan | Virginia | 51145 | 1923 | 17 |
1416905 | 1416905 | 2021-06-13 | Powhatan | Virginia | 51145 | 1922 | 17 |
1413659 | 1413659 | 2021-06-12 | Powhatan | Virginia | 51145 | 1922 | 17 |
1410414 | 1410414 | 2021-06-11 | Powhatan | Virginia | 51145 | 1923 | 17 |
1407169 | 1407169 | 2021-06-10 | Powhatan | Virginia | 51145 | 1923 | 17 |
1403923 | 1403923 | 2021-06-09 | Powhatan | Virginia | 51145 | 1923 | 17 |
1400678 | 1400678 | 2021-06-08 | Powhatan | Virginia | 51145 | 1922 | 17 |
1397433 | 1397433 | 2021-06-07 | Powhatan | Virginia | 51145 | 1921 | 17 |
1394186 | 1394186 | 2021-06-06 | Powhatan | Virginia | 51145 | 1921 | 17 |
1390941 | 1390941 | 2021-06-05 | Powhatan | Virginia | 51145 | 1921 | 17 |
1387696 | 1387696 | 2021-06-04 | Powhatan | Virginia | 51145 | 1921 | 17 |
1384451 | 1384451 | 2021-06-03 | Powhatan | Virginia | 51145 | 1922 | 17 |
1381205 | 1381205 | 2021-06-02 | Powhatan | Virginia | 51145 | 1923 | 17 |
1377960 | 1377960 | 2021-06-01 | Powhatan | Virginia | 51145 | 1920 | 17 |
1374714 | 1374714 | 2021-05-31 | Powhatan | Virginia | 51145 | 1920 | 17 |
1371469 | 1371469 | 2021-05-30 | Powhatan | Virginia | 51145 | 1920 | 17 |
1368223 | 1368223 | 2021-05-29 | Powhatan | Virginia | 51145 | 1920 | 17 |
1364977 | 1364977 | 2021-05-28 | Powhatan | Virginia | 51145 | 1920 | 17 |
1361731 | 1361731 | 2021-05-27 | Powhatan | Virginia | 51145 | 1918 | 17 |
1358485 | 1358485 | 2021-05-26 | Powhatan | Virginia | 51145 | 1920 | 17 |
1355239 | 1355239 | 2021-05-25 | Powhatan | Virginia | 51145 | 1918 | 17 |
1351993 | 1351993 | 2021-05-24 | Powhatan | Virginia | 51145 | 1918 | 17 |
1348747 | 1348747 | 2021-05-23 | Powhatan | Virginia | 51145 | 1918 | 17 |
1345499 | 1345499 | 2021-05-22 | Powhatan | Virginia | 51145 | 1918 | 17 |
1342251 | 1342251 | 2021-05-21 | Powhatan | Virginia | 51145 | 1919 | 17 |
1339003 | 1339003 | 2021-05-20 | Powhatan | Virginia | 51145 | 1918 | 17 |
1335756 | 1335756 | 2021-05-19 | Powhatan | Virginia | 51145 | 1912 | 17 |
1332509 | 1332509 | 2021-05-18 | Powhatan | Virginia | 51145 | 1911 | 17 |
1329262 | 1329262 | 2021-05-17 | Powhatan | Virginia | 51145 | 1911 | 17 |
1326016 | 1326016 | 2021-05-16 | Powhatan | Virginia | 51145 | 1910 | 17 |
1322770 | 1322770 | 2021-05-15 | Powhatan | Virginia | 51145 | 1910 | 17 |
1319524 | 1319524 | 2021-05-14 | Powhatan | Virginia | 51145 | 1910 | 17 |
1316276 | 1316276 | 2021-05-13 | Powhatan | Virginia | 51145 | 1909 | 17 |
1313030 | 1313030 | 2021-05-12 | Powhatan | Virginia | 51145 | 1907 | 16 |
1309783 | 1309783 | 2021-05-11 | Powhatan | Virginia | 51145 | 1908 | 16 |
1306537 | 1306537 | 2021-05-10 | Powhatan | Virginia | 51145 | 1907 | 16 |
1303291 | 1303291 | 2021-05-09 | Powhatan | Virginia | 51145 | 1907 | 16 |
1300044 | 1300044 | 2021-05-08 | Powhatan | Virginia | 51145 | 1901 | 16 |
1296797 | 1296797 | 2021-05-07 | Powhatan | Virginia | 51145 | 1901 | 16 |
1293551 | 1293551 | 2021-05-06 | Powhatan | Virginia | 51145 | 1900 | 16 |
1290305 | 1290305 | 2021-05-05 | Powhatan | Virginia | 51145 | 1900 | 16 |
1287059 | 1287059 | 2021-05-04 | Powhatan | Virginia | 51145 | 1900 | 16 |
1283813 | 1283813 | 2021-05-03 | Powhatan | Virginia | 51145 | 1898 | 16 |
1280566 | 1280566 | 2021-05-02 | Powhatan | Virginia | 51145 | 1891 | 16 |
1277319 | 1277319 | 2021-05-01 | Powhatan | Virginia | 51145 | 1887 | 16 |
1274072 | 1274072 | 2021-04-30 | Powhatan | Virginia | 51145 | 1887 | 16 |
1270825 | 1270825 | 2021-04-29 | Powhatan | Virginia | 51145 | 1881 | 15 |
1267578 | 1267578 | 2021-04-28 | Powhatan | Virginia | 51145 | 1876 | 15 |
1264331 | 1264331 | 2021-04-27 | Powhatan | Virginia | 51145 | 1875 | 15 |
1261084 | 1261084 | 2021-04-26 | Powhatan | Virginia | 51145 | 1871 | 15 |
1257837 | 1257837 | 2021-04-25 | Powhatan | Virginia | 51145 | 1867 | 15 |
1254590 | 1254590 | 2021-04-24 | Powhatan | Virginia | 51145 | 1866 | 15 |
1251343 | 1251343 | 2021-04-23 | Powhatan | Virginia | 51145 | 1862 | 15 |
1248096 | 1248096 | 2021-04-22 | Powhatan | Virginia | 51145 | 1859 | 15 |
1244849 | 1244849 | 2021-04-21 | Powhatan | Virginia | 51145 | 1852 | 15 |
1241602 | 1241602 | 2021-04-20 | Powhatan | Virginia | 51145 | 1850 | 15 |
1238355 | 1238355 | 2021-04-19 | Powhatan | Virginia | 51145 | 1848 | 15 |
1235108 | 1235108 | 2021-04-18 | Powhatan | Virginia | 51145 | 1847 | 15 |
1231860 | 1231860 | 2021-04-17 | Powhatan | Virginia | 51145 | 1846 | 15 |
1228612 | 1228612 | 2021-04-16 | Powhatan | Virginia | 51145 | 1844 | 14 |
1225364 | 1225364 | 2021-04-15 | Powhatan | Virginia | 51145 | 1841 | 14 |
1222117 | 1222117 | 2021-04-14 | Powhatan | Virginia | 51145 | 1834 | 14 |
1218869 | 1218869 | 2021-04-13 | Powhatan | Virginia | 51145 | 1830 | 14 |
1215621 | 1215621 | 2021-04-12 | Powhatan | Virginia | 51145 | 1820 | 14 |
1212374 | 1212374 | 2021-04-11 | Powhatan | Virginia | 51145 | 1817 | 14 |
1209125 | 1209125 | 2021-04-10 | Powhatan | Virginia | 51145 | 1813 | 14 |
1205877 | 1205877 | 2021-04-09 | Powhatan | Virginia | 51145 | 1812 | 14 |
1202629 | 1202629 | 2021-04-08 | Powhatan | Virginia | 51145 | 1814 | 14 |
1199381 | 1199381 | 2021-04-07 | Powhatan | Virginia | 51145 | 1813 | 12 |
1196132 | 1196132 | 2021-04-06 | Powhatan | Virginia | 51145 | 1808 | 12 |
1192884 | 1192884 | 2021-04-05 | Powhatan | Virginia | 51145 | 1806 | 12 |
1189634 | 1189634 | 2021-04-04 | Powhatan | Virginia | 51145 | 1800 | 12 |
1186387 | 1186387 | 2021-04-03 | Powhatan | Virginia | 51145 | 1796 | 12 |
1183140 | 1183140 | 2021-04-02 | Powhatan | Virginia | 51145 | 1788 | 12 |
1179893 | 1179893 | 2021-04-01 | Powhatan | Virginia | 51145 | 1778 | 12 |
1176646 | 1176646 | 2021-03-31 | Powhatan | Virginia | 51145 | 1772 | 11 |
1173399 | 1173399 | 2021-03-30 | Powhatan | Virginia | 51145 | 1772 | 11 |
1170152 | 1170152 | 2021-03-29 | Powhatan | Virginia | 51145 | 1769 | 11 |
1166904 | 1166904 | 2021-03-28 | Powhatan | Virginia | 51145 | 1767 | 11 |
1163656 | 1163656 | 2021-03-27 | Powhatan | Virginia | 51145 | 1763 | 10 |
1160408 | 1160408 | 2021-03-26 | Powhatan | Virginia | 51145 | 1756 | 10 |
1157160 | 1157160 | 2021-03-25 | Powhatan | Virginia | 51145 | 1751 | 10 |
1153913 | 1153913 | 2021-03-24 | Powhatan | Virginia | 51145 | 1749 | 10 |
1150666 | 1150666 | 2021-03-23 | Powhatan | Virginia | 51145 | 1743 | 10 |
1147419 | 1147419 | 2021-03-22 | Powhatan | Virginia | 51145 | 1735 | 10 |
1144172 | 1144172 | 2021-03-21 | Powhatan | Virginia | 51145 | 1732 | 10 |
1140925 | 1140925 | 2021-03-20 | Powhatan | Virginia | 51145 | 1730 | 10 |
1137679 | 1137679 | 2021-03-19 | Powhatan | Virginia | 51145 | 1725 | 10 |
1134433 | 1134433 | 2021-03-18 | Powhatan | Virginia | 51145 | 1721 | 10 |
1131185 | 1131185 | 2021-03-17 | Powhatan | Virginia | 51145 | 1715 | 10 |
1127938 | 1127938 | 2021-03-16 | Powhatan | Virginia | 51145 | 1714 | 10 |
1124692 | 1124692 | 2021-03-15 | Powhatan | Virginia | 51145 | 1710 | 10 |
1121446 | 1121446 | 2021-03-14 | Powhatan | Virginia | 51145 | 1708 | 10 |
1118199 | 1118199 | 2021-03-13 | Powhatan | Virginia | 51145 | 1703 | 10 |
1114952 | 1114952 | 2021-03-12 | Powhatan | Virginia | 51145 | 1697 | 10 |
1111706 | 1111706 | 2021-03-11 | Powhatan | Virginia | 51145 | 1688 | 10 |
1108460 | 1108460 | 2021-03-10 | Powhatan | Virginia | 51145 | 1679 | 10 |
1105214 | 1105214 | 2021-03-09 | Powhatan | Virginia | 51145 | 1674 | 10 |
1101968 | 1101968 | 2021-03-08 | Powhatan | Virginia | 51145 | 1670 | 10 |
1098722 | 1098722 | 2021-03-07 | Powhatan | Virginia | 51145 | 1668 | 10 |
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);