ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Prince Edward" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 540 ✖
- 1 13
- 2174 13
- 2175 13
- 2 10
- 2173 10
- 3 6
- 2172 6
- 173 5
- 2177 5
- 17 4
- 238 4
- 242 4
- 447 4
- 2171 4
- 2180 4
- 2210 4
- 2830 4
- 3013 4
- 4713 4
- 41 3
- 55 3
- 66 3
- 108 3
- 129 3
- 213 3
- 239 3
- 466 3
- 488 3
- 2178 3
- 2188 3
- 2201 3
- 2239 3
- 2291 3
- 2370 3
- 2435 3
- 2484 3
- 2584 3
- 2691 3
- 2761 3
- 2886 3
- 2919 3
- 2943 3
- 2960 3
- 2976 3
- 2989 3
- 2998 3
- 3046 3
- 3086 3
- 3125 3
- 3223 3
- 3438 3
- 3678 3
- 3924 3
- 4134 3
- 4315 3
- 4491 3
- 4553 3
- 4595 3
- 4644 3
- 4674 3
- 4863 3
- 4888 3
- 4913 3
- 5022 3
- 5057 3
- 5070 3
- 5084 3
- 13 2
- 15 2
- 19 2
- 58 2
- 72 2
- 73 2
- 134 2
- 143 2
- 146 2
- 148 2
- 151 2
- 161 2
- 171 2
- 178 2
- 182 2
- 237 2
- 258 2
- 410 2
- 423 2
- 451 2
- 508 2
- 580 2
- 660 2
- 745 2
- 783 2
- 787 2
- 862 2
- 1906 2
- 1907 2
- 1960 2
- 1979 2
- 1984 2
- 1992 2
- 1997 2
- 2003 2
- 2004 2
- 2025 2
- 2145 2
- 2163 2
- 2167 2
- 2181 2
- 2193 2
- 2195 2
- 2209 2
- 2235 2
- 2463 2
- 2940 2
- 2963 2
- 2974 2
- 2994 2
- 4672 2
- 4788 2
- 4868 2
- 5064 2
- 5078 2
- 5 1
- 8 1
- 9 1
- 29 1
- 34 1
- 37 1
- 46 1
- 49 1
- 51 1
- 63 1
- 65 1
- 68 1
- 69 1
- 77 1
- 83 1
- 86 1
- 99 1
- 104 1
- 122 1
- 137 1
- 153 1
- 155 1
- 162 1
- 170 1
- 175 1
- 176 1
- 186 1
- 187 1
- 191 1
- 194 1
- 214 1
- 216 1
- 219 1
- 234 1
- 236 1
- 241 1
- 246 1
- 284 1
- 289 1
- 300 1
- 323 1
- 341 1
- 351 1
- 356 1
- 358 1
- 386 1
- 389 1
- 397 1
- 411 1
- 427 1
- 436 1
- 449 1
- 470 1
- 472 1
- 473 1
- 478 1
- 493 1
- 503 1
- 505 1
- 506 1
- 509 1
- 516 1
- 518 1
- 519 1
- 523 1
- 528 1
- 529 1
- 530 1
- 541 1
- 543 1
- 549 1
- 556 1
- 559 1
- 561 1
- 562 1
- 567 1
- 568 1
- 576 1
- 577 1
- 581 1
- 582 1
- 583 1
- 584 1
- 595 1
- 605 1
- 613 1
- 618 1
- 622 1
- 625 1
- 631 1
- 652 1
- 673 1
- 679 1
- 683 1
- 700 1
- 705 1
- 714 1
- 715 1
- 720 1
- 725 1
- 730 1
- 733 1
- 739 1
- 746 1
- 760 1
- 765 1
- 768 1
- 774 1
- 778 1
- 789 1
- 790 1
- 793 1
- 796 1
- 799 1
- 810 1
- 811 1
- 813 1
- 816 1
- 818 1
- 820 1
- 825 1
- 830 1
- 831 1
- 836 1
- 841 1
- 845 1
- 853 1
- 860 1
- 865 1
- 866 1
- 871 1
- 876 1
- 877 1
- 879 1
- 884 1
- 886 1
- 893 1
- 897 1
- 902 1
- 907 1
- 913 1
- 917 1
- 918 1
- 923 1
- 928 1
- 932 1
- 937 1
- 943 1
- 949 1
- 951 1
- 966 1
- 970 1
- 981 1
- 992 1
- 1015 1
- 1023 1
- 1026 1
- 1047 1
- 1049 1
- 1063 1
- 1065 1
- 1077 1
- 1080 1
- 1083 1
- 1094 1
- 1104 1
- 1145 1
- 1148 1
- 1170 1
- 1191 1
- 1203 1
- 1218 1
- 1220 1
- 1222 1
- 1225 1
- 1232 1
- 1244 1
- 1275 1
- 1313 1
- 1355 1
- 1411 1
- 1439 1
- 1448 1
- 1471 1
- 1481 1
- 1505 1
- 1524 1
- 1537 1
- 1562 1
- 1576 1
- 1611 1
- 1635 1
- 1663 1
- 1689 1
- 1709 1
- 1734 1
- 1741 1
- 1744 1
- 1767 1
- 1801 1
- 1818 1
- 1838 1
- 1840 1
- 1846 1
- 1861 1
- 1880 1
- 1892 1
- 1899 1
- 1901 1
- 1911 1
- 1918 1
- 1922 1
- 1923 1
- 1925 1
- 1929 1
- 1941 1
- 1944 1
- 1950 1
- 1953 1
- 1962 1
- 1964 1
- 1971 1
- 1972 1
- 1974 1
- 1975 1
- 1981 1
- 1986 1
- 1987 1
- 1988 1
- 1993 1
- 1996 1
- 1998 1
- 2000 1
- 2001 1
- 2002 1
- 2006 1
- 2009 1
- 2016 1
- 2017 1
- 2020 1
- 2022 1
- 2032 1
- 2036 1
- 2039 1
- 2044 1
- 2047 1
- 2055 1
- 2066 1
- 2072 1
- 2074 1
- 2077 1
- 2081 1
- 2085 1
- 2087 1
- 2091 1
- 2098 1
- 2102 1
- 2103 1
- 2106 1
- 2107 1
- 2110 1
- 2111 1
- 2114 1
- 2119 1
- 2123 1
- 2125 1
- 2126 1
- 2130 1
- 2137 1
- 2139 1
- 2141 1
- 2144 1
- 2146 1
- 2148 1
- 2151 1
- 2168 1
- 2169 1
- 2179 1
- 2182 1
- 2184 1
- 2187 1
- 2208 1
- 2220 1
- 2229 1
- 2252 1
- 2266 1
- 2273 1
- 2284 1
- 2310 1
- 2321 1
- 2346 1
- 2360 1
- 2390 1
- 2397 1
- 2415 1
- 2423 1
- 2472 1
- 2479 1
- 2517 1
- 2537 1
- 2558 1
- 2574 1
- 2636 1
- 2642 1
- 2673 1
- 2681 1
- 2710 1
- 2719 1
- 2731 1
- 2746 1
- 2791 1
- 2796 1
- 2804 1
- 2822 1
- 2862 1
- 2870 1
- 2882 1
- 2900 1
- 2910 1
- 2911 1
- 2915 1
- 2928 1
- 2934 1
- 2947 1
- 2948 1
- 2953 1
- 2958 1
- 2967 1
- 2977 1
- 2986 1
- 2987 1
- 2996 1
- 2997 1
- 2999 1
- 3003 1
- 3009 1
- 3024 1
- 3032 1
- 3033 1
- 3036 1
- 3059 1
- 3067 1
- 3075 1
- 3081 1
- 3097 1
- 3109 1
- 3112 1
- 3121 1
- 3137 1
- 3152 1
- 3163 1
- 3187 1
- 3275 1
- 3298 1
- 3339 1
- 3399 1
- 3520 1
- 3546 1
- 3607 1
- 3646 1
- 3744 1
- 3757 1
- 3829 1
- 3873 1
- 4004 1
- 4024 1
- 4055 1
- 4077 1
- 4221 1
- 4238 1
- 4265 1
- 4288 1
- 4348 1
- 4427 1
- 4446 1
- 4474 1
- 4521 1
- 4523 1
- 4529 1
- 4539 1
- 4569 1
- 4575 1
- 4585 1
- 4589 1
- 4604 1
- 4616 1
- 4634 1
- 4638 1
- 4653 1
- 4676 1
- 4681 1
- 4715 1
- 4724 1
- 4847 1
- 4855 1
- 4878 1
- 4882 1
- 4892 1
- 4896 1
- 4900 1
- 4904 1
- 4926 1
- 4991 1
- 5008 1
- 5009 1
- 5046 1
- 5047 1
- 5050 1
- 5052 1
- 5067 1
- 5072 1
- 5077 1
- 5080 1
- 5094 1
- 5100 1
- 5101 1
- 5104 1
- 5107 1
state 1
- Virginia 793
fips 1
- 51147 793
county 1
- Prince Edward · 793 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1595 | 1595 | 2020-03-12 | Prince Edward | Virginia | 51147 | 1 | 0 |
1905 | 1905 | 2020-03-13 | Prince Edward | Virginia | 51147 | 1 | 0 |
2277 | 2277 | 2020-03-14 | Prince Edward | Virginia | 51147 | 1 | 0 |
2704 | 2704 | 2020-03-15 | Prince Edward | Virginia | 51147 | 1 | 0 |
3176 | 3176 | 2020-03-16 | Prince Edward | Virginia | 51147 | 1 | 0 |
3715 | 3715 | 2020-03-17 | Prince Edward | Virginia | 51147 | 1 | 0 |
4348 | 4348 | 2020-03-18 | Prince Edward | Virginia | 51147 | 1 | 0 |
5104 | 5104 | 2020-03-19 | Prince Edward | Virginia | 51147 | 1 | 0 |
6005 | 6005 | 2020-03-20 | Prince Edward | Virginia | 51147 | 1 | 0 |
7035 | 7035 | 2020-03-21 | Prince Edward | Virginia | 51147 | 1 | 0 |
8171 | 8171 | 2020-03-22 | Prince Edward | Virginia | 51147 | 1 | 0 |
9393 | 9393 | 2020-03-23 | Prince Edward | Virginia | 51147 | 1 | 0 |
10741 | 10741 | 2020-03-24 | Prince Edward | Virginia | 51147 | 1 | 0 |
12261 | 12261 | 2020-03-25 | Prince Edward | Virginia | 51147 | 2 | 0 |
13906 | 13906 | 2020-03-26 | Prince Edward | Virginia | 51147 | 2 | 0 |
15674 | 15674 | 2020-03-27 | Prince Edward | Virginia | 51147 | 2 | 0 |
17554 | 17554 | 2020-03-28 | Prince Edward | Virginia | 51147 | 2 | 0 |
19516 | 19516 | 2020-03-29 | Prince Edward | Virginia | 51147 | 2 | 0 |
21582 | 21582 | 2020-03-30 | Prince Edward | Virginia | 51147 | 2 | 0 |
23729 | 23729 | 2020-03-31 | Prince Edward | Virginia | 51147 | 2 | 0 |
25945 | 25945 | 2020-04-01 | Prince Edward | Virginia | 51147 | 2 | 0 |
28235 | 28235 | 2020-04-02 | Prince Edward | Virginia | 51147 | 2 | 0 |
30582 | 30582 | 2020-04-03 | Prince Edward | Virginia | 51147 | 2 | 0 |
32981 | 32981 | 2020-04-04 | Prince Edward | Virginia | 51147 | 3 | 0 |
35419 | 35419 | 2020-04-05 | Prince Edward | Virginia | 51147 | 3 | 0 |
37902 | 37902 | 2020-04-06 | Prince Edward | Virginia | 51147 | 3 | 0 |
40436 | 40436 | 2020-04-07 | Prince Edward | Virginia | 51147 | 3 | 0 |
43005 | 43005 | 2020-04-08 | Prince Edward | Virginia | 51147 | 3 | 0 |
45601 | 45601 | 2020-04-09 | Prince Edward | Virginia | 51147 | 3 | 0 |
48227 | 48227 | 2020-04-10 | Prince Edward | Virginia | 51147 | 5 | 0 |
50885 | 50885 | 2020-04-11 | Prince Edward | Virginia | 51147 | 8 | 1 |
53560 | 53560 | 2020-04-12 | Prince Edward | Virginia | 51147 | 9 | 1 |
56250 | 56250 | 2020-04-13 | Prince Edward | Virginia | 51147 | 13 | 1 |
58956 | 58956 | 2020-04-14 | Prince Edward | Virginia | 51147 | 13 | 1 |
61675 | 61675 | 2020-04-15 | Prince Edward | Virginia | 51147 | 15 | 1 |
64408 | 64408 | 2020-04-16 | Prince Edward | Virginia | 51147 | 15 | 1 |
67156 | 67156 | 2020-04-17 | Prince Edward | Virginia | 51147 | 17 | 1 |
69918 | 69918 | 2020-04-18 | Prince Edward | Virginia | 51147 | 17 | 1 |
72688 | 72688 | 2020-04-19 | Prince Edward | Virginia | 51147 | 17 | 1 |
75464 | 75464 | 2020-04-20 | Prince Edward | Virginia | 51147 | 17 | 1 |
78248 | 78248 | 2020-04-21 | Prince Edward | Virginia | 51147 | 19 | 2 |
81041 | 81041 | 2020-04-22 | Prince Edward | Virginia | 51147 | 19 | 2 |
83842 | 83842 | 2020-04-23 | Prince Edward | Virginia | 51147 | 29 | 2 |
86649 | 86649 | 2020-04-24 | Prince Edward | Virginia | 51147 | 34 | 2 |
89464 | 89464 | 2020-04-25 | Prince Edward | Virginia | 51147 | 37 | 2 |
92281 | 92281 | 2020-04-26 | Prince Edward | Virginia | 51147 | 41 | 2 |
95110 | 95110 | 2020-04-27 | Prince Edward | Virginia | 51147 | 41 | 2 |
97954 | 97954 | 2020-04-28 | Prince Edward | Virginia | 51147 | 41 | 2 |
100804 | 100804 | 2020-04-29 | Prince Edward | Virginia | 51147 | 46 | 2 |
103659 | 103659 | 2020-04-30 | Prince Edward | Virginia | 51147 | 49 | 2 |
106523 | 106523 | 2020-05-01 | Prince Edward | Virginia | 51147 | 51 | 2 |
109392 | 109392 | 2020-05-02 | Prince Edward | Virginia | 51147 | 55 | 2 |
112266 | 112266 | 2020-05-03 | Prince Edward | Virginia | 51147 | 55 | 2 |
115149 | 115149 | 2020-05-04 | Prince Edward | Virginia | 51147 | 55 | 2 |
118108 | 118108 | 2020-05-05 | Prince Edward | Virginia | 51147 | 58 | 2 |
121072 | 121072 | 2020-05-06 | Prince Edward | Virginia | 51147 | 58 | 2 |
124053 | 124053 | 2020-05-07 | Prince Edward | Virginia | 51147 | 63 | 2 |
127038 | 127038 | 2020-05-08 | Prince Edward | Virginia | 51147 | 65 | 2 |
130028 | 130028 | 2020-05-09 | Prince Edward | Virginia | 51147 | 66 | 2 |
133018 | 133018 | 2020-05-10 | Prince Edward | Virginia | 51147 | 66 | 2 |
136008 | 136008 | 2020-05-11 | Prince Edward | Virginia | 51147 | 66 | 2 |
138999 | 138999 | 2020-05-12 | Prince Edward | Virginia | 51147 | 68 | 2 |
141995 | 141995 | 2020-05-13 | Prince Edward | Virginia | 51147 | 69 | 2 |
144992 | 144992 | 2020-05-14 | Prince Edward | Virginia | 51147 | 72 | 2 |
147995 | 147995 | 2020-05-15 | Prince Edward | Virginia | 51147 | 72 | 2 |
151004 | 151004 | 2020-05-16 | Prince Edward | Virginia | 51147 | 73 | 2 |
154015 | 154015 | 2020-05-17 | Prince Edward | Virginia | 51147 | 73 | 2 |
157032 | 157032 | 2020-05-18 | Prince Edward | Virginia | 51147 | 77 | 2 |
160056 | 160056 | 2020-05-19 | Prince Edward | Virginia | 51147 | 83 | 2 |
163084 | 163084 | 2020-05-20 | Prince Edward | Virginia | 51147 | 86 | 2 |
166113 | 166113 | 2020-05-21 | Prince Edward | Virginia | 51147 | 99 | 2 |
169149 | 169149 | 2020-05-22 | Prince Edward | Virginia | 51147 | 104 | 2 |
172190 | 172190 | 2020-05-23 | Prince Edward | Virginia | 51147 | 108 | 2 |
175233 | 175233 | 2020-05-24 | Prince Edward | Virginia | 51147 | 108 | 2 |
178278 | 178278 | 2020-05-25 | Prince Edward | Virginia | 51147 | 108 | 2 |
181322 | 181322 | 2020-05-26 | Prince Edward | Virginia | 51147 | 122 | 2 |
184373 | 184373 | 2020-05-27 | Prince Edward | Virginia | 51147 | 129 | 2 |
187430 | 187430 | 2020-05-28 | Prince Edward | Virginia | 51147 | 129 | 2 |
190494 | 190494 | 2020-05-29 | Prince Edward | Virginia | 51147 | 129 | 2 |
193560 | 193560 | 2020-05-30 | Prince Edward | Virginia | 51147 | 134 | 2 |
196630 | 196630 | 2020-05-31 | Prince Edward | Virginia | 51147 | 134 | 2 |
199703 | 199703 | 2020-06-01 | Prince Edward | Virginia | 51147 | 137 | 2 |
202779 | 202779 | 2020-06-02 | Prince Edward | Virginia | 51147 | 143 | 2 |
205858 | 205858 | 2020-06-03 | Prince Edward | Virginia | 51147 | 143 | 2 |
208940 | 208940 | 2020-06-04 | Prince Edward | Virginia | 51147 | 146 | 2 |
212025 | 212025 | 2020-06-05 | Prince Edward | Virginia | 51147 | 146 | 2 |
215112 | 215112 | 2020-06-06 | Prince Edward | Virginia | 51147 | 148 | 2 |
218202 | 218202 | 2020-06-07 | Prince Edward | Virginia | 51147 | 148 | 2 |
221294 | 221294 | 2020-06-08 | Prince Edward | Virginia | 51147 | 151 | 2 |
224390 | 224390 | 2020-06-09 | Prince Edward | Virginia | 51147 | 151 | 2 |
227490 | 227490 | 2020-06-10 | Prince Edward | Virginia | 51147 | 153 | 3 |
230594 | 230594 | 2020-06-11 | Prince Edward | Virginia | 51147 | 155 | 3 |
233699 | 233699 | 2020-06-12 | Prince Edward | Virginia | 51147 | 161 | 3 |
236806 | 236806 | 2020-06-13 | Prince Edward | Virginia | 51147 | 161 | 3 |
239914 | 239914 | 2020-06-14 | Prince Edward | Virginia | 51147 | 162 | 3 |
243025 | 243025 | 2020-06-15 | Prince Edward | Virginia | 51147 | 170 | 3 |
246138 | 246138 | 2020-06-16 | Prince Edward | Virginia | 51147 | 171 | 3 |
249250 | 249250 | 2020-06-17 | Prince Edward | Virginia | 51147 | 171 | 3 |
252365 | 252365 | 2020-06-18 | Prince Edward | Virginia | 51147 | 173 | 3 |
255484 | 255484 | 2020-06-19 | Prince Edward | Virginia | 51147 | 173 | 3 |
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);