ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 51830 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 467 ✖
- 43 12
- 768 12
- 769 12
- 770 11
- 772 10
- 204 9
- 771 9
- 54 8
- 5 6
- 15 6
- 19 6
- 44 6
- 42 5
- 767 5
- 774 5
- 1751 5
- 45 4
- 55 4
- 78 4
- 157 4
- 757 4
- 758 4
- 778 4
- 787 4
- 863 4
- 1105 4
- 1176 4
- 1430 4
- 1742 4
- 1745 4
- 1756 4
- 1 3
- 9 3
- 17 3
- 18 3
- 20 3
- 49 3
- 61 3
- 105 3
- 128 3
- 155 3
- 210 3
- 350 3
- 352 3
- 507 3
- 524 3
- 548 3
- 764 3
- 775 3
- 805 3
- 835 3
- 882 3
- 915 3
- 963 3
- 1026 3
- 1054 3
- 1084 3
- 1125 3
- 1153 3
- 1172 3
- 1181 3
- 1182 3
- 1194 3
- 1207 3
- 1225 3
- 1243 3
- 1271 3
- 1297 3
- 1343 3
- 1384 3
- 1490 3
- 1545 3
- 1594 3
- 1642 3
- 1669 3
- 1690 3
- 1707 3
- 1708 3
- 1716 3
- 1743 3
- 1767 3
- 1786 3
- 1800 3
- 1812 3
- 4 2
- 7 2
- 14 2
- 16 2
- 27 2
- 31 2
- 46 2
- 48 2
- 50 2
- 91 2
- 94 2
- 119 2
- 141 2
- 146 2
- 148 2
- 154 2
- 162 2
- 170 2
- 175 2
- 177 2
- 178 2
- 183 2
- 193 2
- 213 2
- 215 2
- 235 2
- 244 2
- 248 2
- 275 2
- 279 2
- 285 2
- 287 2
- 289 2
- 309 2
- 346 2
- 360 2
- 385 2
- 392 2
- 411 2
- 417 2
- 424 2
- 444 2
- 514 2
- 544 2
- 547 2
- 564 2
- 731 2
- 748 2
- 756 2
- 763 2
- 766 2
- 784 2
- 788 2
- 1062 2
- 1177 2
- 1239 2
- 1706 2
- 1770 2
- 1788 2
- 6 1
- 8 1
- 10 1
- 12 1
- 13 1
- 21 1
- 22 1
- 23 1
- 29 1
- 39 1
- 53 1
- 56 1
- 60 1
- 64 1
- 72 1
- 74 1
- 75 1
- 77 1
- 82 1
- 85 1
- 87 1
- 88 1
- 96 1
- 97 1
- 99 1
- 100 1
- 101 1
- 102 1
- 106 1
- 107 1
- 109 1
- 111 1
- 114 1
- 117 1
- 121 1
- 122 1
- 126 1
- 130 1
- 132 1
- 133 1
- 135 1
- 136 1
- 137 1
- 139 1
- 140 1
- 144 1
- 145 1
- 153 1
- 156 1
- 158 1
- 161 1
- 163 1
- 164 1
- 167 1
- 169 1
- 172 1
- 176 1
- 181 1
- 182 1
- 185 1
- 188 1
- 189 1
- 191 1
- 194 1
- 202 1
- 205 1
- 209 1
- 211 1
- 216 1
- 218 1
- 219 1
- 223 1
- 225 1
- 228 1
- 230 1
- 231 1
- 232 1
- 239 1
- 240 1
- 243 1
- 245 1
- 257 1
- 260 1
- 264 1
- 283 1
- 284 1
- 291 1
- 295 1
- 298 1
- 300 1
- 301 1
- 308 1
- 314 1
- 318 1
- 319 1
- 321 1
- 325 1
- 330 1
- 334 1
- 338 1
- 340 1
- 343 1
- 344 1
- 348 1
- 349 1
- 353 1
- 358 1
- 377 1
- 380 1
- 383 1
- 389 1
- 391 1
- 393 1
- 394 1
- 395 1
- 405 1
- 416 1
- 418 1
- 423 1
- 425 1
- 429 1
- 434 1
- 437 1
- 439 1
- 441 1
- 445 1
- 446 1
- 450 1
- 459 1
- 464 1
- 468 1
- 473 1
- 477 1
- 482 1
- 483 1
- 485 1
- 493 1
- 496 1
- 497 1
- 501 1
- 504 1
- 508 1
- 510 1
- 516 1
- 522 1
- 532 1
- 535 1
- 540 1
- 541 1
- 545 1
- 546 1
- 550 1
- 552 1
- 558 1
- 559 1
- 583 1
- 584 1
- 593 1
- 598 1
- 605 1
- 612 1
- 640 1
- 644 1
- 647 1
- 671 1
- 682 1
- 684 1
- 691 1
- 695 1
- 697 1
- 699 1
- 707 1
- 711 1
- 719 1
- 721 1
- 727 1
- 729 1
- 730 1
- 737 1
- 738 1
- 741 1
- 743 1
- 746 1
- 749 1
- 750 1
- 753 1
- 759 1
- 765 1
- 773 1
- 776 1
- 782 1
- 795 1
- 800 1
- 810 1
- 815 1
- 822 1
- 828 1
- 846 1
- 850 1
- 858 1
- 867 1
- 868 1
- 874 1
- 875 1
- 888 1
- 895 1
- 898 1
- 906 1
- 925 1
- 928 1
- 934 1
- 945 1
- 982 1
- 992 1
- 999 1
- 1018 1
- 1034 1
- 1036 1
- 1043 1
- 1047 1
- 1071 1
- 1077 1
- 1087 1
- 1092 1
- 1097 1
- 1099 1
- 1113 1
- 1116 1
- 1121 1
- 1132 1
- 1134 1
- 1135 1
- 1141 1
- 1160 1
- 1165 1
- 1166 1
- 1171 1
- 1180 1
- 1183 1
- 1184 1
- 1185 1
- 1186 1
- 1188 1
- 1201 1
- 1202 1
- 1205 1
- 1206 1
- 1209 1
- 1213 1
- 1214 1
- 1216 1
- 1231 1
- 1233 1
- 1255 1
- 1258 1
- 1260 1
- 1264 1
- 1283 1
- 1285 1
- 1286 1
- 1291 1
- 1302 1
- 1306 1
- 1307 1
- 1320 1
- 1349 1
- 1359 1
- 1364 1
- 1375 1
- 1405 1
- 1414 1
- 1424 1
- 1453 1
- 1465 1
- 1476 1
- 1482 1
- 1510 1
- 1533 1
- 1538 1
- 1540 1
- 1562 1
- 1575 1
- 1581 1
- 1589 1
- 1607 1
- 1613 1
- 1627 1
- 1636 1
- 1651 1
- 1656 1
- 1661 1
- 1665 1
- 1672 1
- 1675 1
- 1677 1
- 1684 1
- 1697 1
- 1702 1
- 1709 1
- 1725 1
- 1740 1
- 1741 1
- 1748 1
- 1749 1
- 1750 1
- 1752 1
- 1755 1
- 1757 1
- 1758 1
- 1760 1
- 1765 1
- 1779 1
- 1781 1
- 1791 1
- 1797 1
- 1803 1
- 1804 1
- 1808 1
- 1811 1
- 1816 1
- 1819 1
- 1825 1
- 1831 1
- 1837 1
state 1
- Virginia 788
fips 1
- 51830 · 788 ✖
county 1
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
3720 | 3720 | 2020-03-17 | Williamsburg city | Virginia | 51830 | 1 | 0 |
4354 | 4354 | 2020-03-18 | Williamsburg city | Virginia | 51830 | 1 | 0 |
5110 | 5110 | 2020-03-19 | Williamsburg city | Virginia | 51830 | 1 | 0 |
6011 | 6011 | 2020-03-20 | Williamsburg city | Virginia | 51830 | 4 | 0 |
7042 | 7042 | 2020-03-21 | Williamsburg city | Virginia | 51830 | 4 | 0 |
8179 | 8179 | 2020-03-22 | Williamsburg city | Virginia | 51830 | 5 | 1 |
9402 | 9402 | 2020-03-23 | Williamsburg city | Virginia | 51830 | 5 | 1 |
10751 | 10751 | 2020-03-24 | Williamsburg city | Virginia | 51830 | 5 | 1 |
12273 | 12273 | 2020-03-25 | Williamsburg city | Virginia | 51830 | 5 | 1 |
13923 | 13923 | 2020-03-26 | Williamsburg city | Virginia | 51830 | 5 | 1 |
15691 | 15691 | 2020-03-27 | Williamsburg city | Virginia | 51830 | 5 | 1 |
17571 | 17571 | 2020-03-28 | Williamsburg city | Virginia | 51830 | 6 | 1 |
19534 | 19534 | 2020-03-29 | Williamsburg city | Virginia | 51830 | 7 | 1 |
21601 | 21601 | 2020-03-30 | Williamsburg city | Virginia | 51830 | 7 | 1 |
23750 | 23750 | 2020-03-31 | Williamsburg city | Virginia | 51830 | 8 | 1 |
25968 | 25968 | 2020-04-01 | Williamsburg city | Virginia | 51830 | 9 | 1 |
28258 | 28258 | 2020-04-02 | Williamsburg city | Virginia | 51830 | 9 | 1 |
30609 | 30609 | 2020-04-03 | Williamsburg city | Virginia | 51830 | 9 | 1 |
33009 | 33009 | 2020-04-04 | Williamsburg city | Virginia | 51830 | 10 | 1 |
35447 | 35447 | 2020-04-05 | Williamsburg city | Virginia | 51830 | 12 | 1 |
37931 | 37931 | 2020-04-06 | Williamsburg city | Virginia | 51830 | 13 | 1 |
40466 | 40466 | 2020-04-07 | Williamsburg city | Virginia | 51830 | 14 | 1 |
81071 | 81071 | 2020-04-22 | Williamsburg city | Virginia | 51830 | 14 | 1 |
78278 | 78278 | 2020-04-21 | Williamsburg city | Virginia | 51830 | 15 | 1 |
83872 | 83872 | 2020-04-23 | Williamsburg city | Virginia | 51830 | 15 | 1 |
86679 | 86679 | 2020-04-24 | Williamsburg city | Virginia | 51830 | 15 | 1 |
89494 | 89494 | 2020-04-25 | Williamsburg city | Virginia | 51830 | 15 | 1 |
92311 | 92311 | 2020-04-26 | Williamsburg city | Virginia | 51830 | 15 | 1 |
95140 | 95140 | 2020-04-27 | Williamsburg city | Virginia | 51830 | 15 | 1 |
43035 | 43035 | 2020-04-08 | Williamsburg city | Virginia | 51830 | 16 | 1 |
45631 | 45631 | 2020-04-09 | Williamsburg city | Virginia | 51830 | 16 | 1 |
48258 | 48258 | 2020-04-10 | Williamsburg city | Virginia | 51830 | 17 | 1 |
50916 | 50916 | 2020-04-11 | Williamsburg city | Virginia | 51830 | 17 | 1 |
53591 | 53591 | 2020-04-12 | Williamsburg city | Virginia | 51830 | 17 | 1 |
97985 | 97985 | 2020-04-28 | Williamsburg city | Virginia | 51830 | 18 | 1 |
100835 | 100835 | 2020-04-29 | Williamsburg city | Virginia | 51830 | 18 | 1 |
103690 | 103690 | 2020-04-30 | Williamsburg city | Virginia | 51830 | 18 | 1 |
61706 | 61706 | 2020-04-15 | Williamsburg city | Virginia | 51830 | 19 | 1 |
64439 | 64439 | 2020-04-16 | Williamsburg city | Virginia | 51830 | 19 | 1 |
67187 | 67187 | 2020-04-17 | Williamsburg city | Virginia | 51830 | 19 | 1 |
69949 | 69949 | 2020-04-18 | Williamsburg city | Virginia | 51830 | 19 | 1 |
72719 | 72719 | 2020-04-19 | Williamsburg city | Virginia | 51830 | 19 | 1 |
75495 | 75495 | 2020-04-20 | Williamsburg city | Virginia | 51830 | 19 | 1 |
56281 | 56281 | 2020-04-13 | Williamsburg city | Virginia | 51830 | 20 | 1 |
58987 | 58987 | 2020-04-14 | Williamsburg city | Virginia | 51830 | 20 | 1 |
106554 | 106554 | 2020-05-01 | Williamsburg city | Virginia | 51830 | 20 | 1 |
109423 | 109423 | 2020-05-02 | Williamsburg city | Virginia | 51830 | 21 | 2 |
112297 | 112297 | 2020-05-03 | Williamsburg city | Virginia | 51830 | 22 | 2 |
115180 | 115180 | 2020-05-04 | Williamsburg city | Virginia | 51830 | 23 | 2 |
118139 | 118139 | 2020-05-05 | Williamsburg city | Virginia | 51830 | 27 | 2 |
121103 | 121103 | 2020-05-06 | Williamsburg city | Virginia | 51830 | 27 | 2 |
124083 | 124083 | 2020-05-07 | Williamsburg city | Virginia | 51830 | 29 | 2 |
127068 | 127068 | 2020-05-08 | Williamsburg city | Virginia | 51830 | 31 | 2 |
130058 | 130058 | 2020-05-09 | Williamsburg city | Virginia | 51830 | 31 | 2 |
133048 | 133048 | 2020-05-10 | Williamsburg city | Virginia | 51830 | 39 | 2 |
136038 | 136038 | 2020-05-11 | Williamsburg city | Virginia | 51830 | 42 | 3 |
139029 | 139029 | 2020-05-12 | Williamsburg city | Virginia | 51830 | 42 | 3 |
142025 | 142025 | 2020-05-13 | Williamsburg city | Virginia | 51830 | 42 | 3 |
145022 | 145022 | 2020-05-14 | Williamsburg city | Virginia | 51830 | 42 | 3 |
148025 | 148025 | 2020-05-15 | Williamsburg city | Virginia | 51830 | 42 | 3 |
151034 | 151034 | 2020-05-16 | Williamsburg city | Virginia | 51830 | 43 | 3 |
154045 | 154045 | 2020-05-17 | Williamsburg city | Virginia | 51830 | 43 | 3 |
157062 | 157062 | 2020-05-18 | Williamsburg city | Virginia | 51830 | 43 | 3 |
160086 | 160086 | 2020-05-19 | Williamsburg city | Virginia | 51830 | 43 | 3 |
163114 | 163114 | 2020-05-20 | Williamsburg city | Virginia | 51830 | 43 | 3 |
166143 | 166143 | 2020-05-21 | Williamsburg city | Virginia | 51830 | 43 | 3 |
169179 | 169179 | 2020-05-22 | Williamsburg city | Virginia | 51830 | 43 | 3 |
172220 | 172220 | 2020-05-23 | Williamsburg city | Virginia | 51830 | 43 | 3 |
175263 | 175263 | 2020-05-24 | Williamsburg city | Virginia | 51830 | 43 | 3 |
178308 | 178308 | 2020-05-25 | Williamsburg city | Virginia | 51830 | 43 | 3 |
181352 | 181352 | 2020-05-26 | Williamsburg city | Virginia | 51830 | 43 | 3 |
184403 | 184403 | 2020-05-27 | Williamsburg city | Virginia | 51830 | 43 | 3 |
187460 | 187460 | 2020-05-28 | Williamsburg city | Virginia | 51830 | 44 | 4 |
190524 | 190524 | 2020-05-29 | Williamsburg city | Virginia | 51830 | 44 | 4 |
193590 | 193590 | 2020-05-30 | Williamsburg city | Virginia | 51830 | 44 | 4 |
196660 | 196660 | 2020-05-31 | Williamsburg city | Virginia | 51830 | 44 | 4 |
199733 | 199733 | 2020-06-01 | Williamsburg city | Virginia | 51830 | 44 | 4 |
202809 | 202809 | 2020-06-02 | Williamsburg city | Virginia | 51830 | 44 | 4 |
205888 | 205888 | 2020-06-03 | Williamsburg city | Virginia | 51830 | 45 | 4 |
208970 | 208970 | 2020-06-04 | Williamsburg city | Virginia | 51830 | 45 | 5 |
212055 | 212055 | 2020-06-05 | Williamsburg city | Virginia | 51830 | 45 | 5 |
215142 | 215142 | 2020-06-06 | Williamsburg city | Virginia | 51830 | 45 | 5 |
218232 | 218232 | 2020-06-07 | Williamsburg city | Virginia | 51830 | 46 | 5 |
221324 | 221324 | 2020-06-08 | Williamsburg city | Virginia | 51830 | 46 | 5 |
224420 | 224420 | 2020-06-09 | Williamsburg city | Virginia | 51830 | 48 | 5 |
227520 | 227520 | 2020-06-10 | Williamsburg city | Virginia | 51830 | 48 | 5 |
230624 | 230624 | 2020-06-11 | Williamsburg city | Virginia | 51830 | 49 | 5 |
233729 | 233729 | 2020-06-12 | Williamsburg city | Virginia | 51830 | 49 | 5 |
236836 | 236836 | 2020-06-13 | Williamsburg city | Virginia | 51830 | 49 | 5 |
239944 | 239944 | 2020-06-14 | Williamsburg city | Virginia | 51830 | 50 | 5 |
243055 | 243055 | 2020-06-15 | Williamsburg city | Virginia | 51830 | 50 | 5 |
246168 | 246168 | 2020-06-16 | Williamsburg city | Virginia | 51830 | 53 | 5 |
249280 | 249280 | 2020-06-17 | Williamsburg city | Virginia | 51830 | 54 | 5 |
252395 | 252395 | 2020-06-18 | Williamsburg city | Virginia | 51830 | 54 | 5 |
255514 | 255514 | 2020-06-19 | Williamsburg city | Virginia | 51830 | 54 | 5 |
258641 | 258641 | 2020-06-20 | Williamsburg city | Virginia | 51830 | 54 | 5 |
261768 | 261768 | 2020-06-21 | Williamsburg city | Virginia | 51830 | 54 | 5 |
264897 | 264897 | 2020-06-22 | Williamsburg city | Virginia | 51830 | 54 | 5 |
268026 | 268026 | 2020-06-23 | Williamsburg city | Virginia | 51830 | 54 | 5 |
271160 | 271160 | 2020-06-24 | Williamsburg city | Virginia | 51830 | 54 | 5 |
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);