ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 51740 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 657 ✖
- 1 4
- 3 4
- 9264 4
- 12213 4
- 20613 4
- 4 3
- 65 3
- 325 3
- 9129 3
- 9154 3
- 9306 3
- 9399 3
- 9537 3
- 9741 3
- 10025 3
- 10320 3
- 10678 3
- 11020 3
- 11363 3
- 11683 3
- 11928 3
- 12376 3
- 12517 3
- 12630 3
- 12745 3
- 12827 3
- 12884 3
- 12989 3
- 13068 3
- 13188 3
- 13359 3
- 13618 3
- 14523 3
- 16100 3
- 17830 3
- 19014 3
- 19704 3
- 20079 3
- 20298 3
- 20458 3
- 20572 3
- 20648 3
- 20662 3
- 20664 3
- 20708 3
- 20738 3
- 20839 3
- 20893 3
- 20920 3
- 20969 3
- 21067 3
- 26 2
- 59 2
- 183 2
- 187 2
- 202 2
- 343 2
- 375 2
- 405 2
- 549 2
- 2086 2
- 2213 2
- 2391 2
- 9065 2
- 9175 2
- 9197 2
- 9222 2
- 9223 2
- 20649 2
- 20679 2
- 20705 2
- 20921 2
- 12 1
- 13 1
- 16 1
- 17 1
- 27 1
- 36 1
- 41 1
- 44 1
- 48 1
- 49 1
- 51 1
- 54 1
- 62 1
- 63 1
- 82 1
- 93 1
- 98 1
- 100 1
- 103 1
- 108 1
- 114 1
- 149 1
- 150 1
- 158 1
- 170 1
- 173 1
- 193 1
- 194 1
- 208 1
- 210 1
- 213 1
- 217 1
- 219 1
- 222 1
- 225 1
- 228 1
- 237 1
- 241 1
- 245 1
- 251 1
- 253 1
- 262 1
- 272 1
- 281 1
- 282 1
- 284 1
- 294 1
- 307 1
- 308 1
- 313 1
- 322 1
- 335 1
- 351 1
- 354 1
- 364 1
- 370 1
- 386 1
- 387 1
- 395 1
- 402 1
- 406 1
- 419 1
- 421 1
- 426 1
- 442 1
- 449 1
- 455 1
- 459 1
- 471 1
- 482 1
- 497 1
- 513 1
- 526 1
- 539 1
- 572 1
- 593 1
- 605 1
- 627 1
- 662 1
- 686 1
- 714 1
- 761 1
- 794 1
- 827 1
- 872 1
- 925 1
- 966 1
- 1009 1
- 1046 1
- 1085 1
- 1115 1
- 1165 1
- 1225 1
- 1267 1
- 1291 1
- 1367 1
- 1390 1
- 1417 1
- 1462 1
- 1492 1
- 1539 1
- 1540 1
- 1631 1
- 1663 1
- 1676 1
- 1726 1
- 1758 1
- 1759 1
- 1788 1
- 1833 1
- 1855 1
- 1907 1
- 1952 1
- 1964 1
- 1965 1
- 1995 1
- 2022 1
- 2024 1
- 2045 1
- 2057 1
- 2085 1
- 2135 1
- 2142 1
- 2161 1
- 2186 1
- 2198 1
- 2234 1
- 2242 1
- 2258 1
- 2269 1
- 2277 1
- 2283 1
- 2286 1
- 2309 1
- 2324 1
- 2337 1
- 2343 1
- 2373 1
- 2424 1
- 2427 1
- 2439 1
- 2500 1
- 2518 1
- 2522 1
- 2525 1
- 2529 1
- 2534 1
- 2539 1
- 2547 1
- 2555 1
- 2559 1
- 2561 1
- 2567 1
- 2594 1
- 2599 1
- 2604 1
- 2614 1
- 2619 1
- 2627 1
- 2633 1
- 2634 1
- 2652 1
- 2658 1
- 2664 1
- 2667 1
- 2681 1
- 2684 1
- 2699 1
- 2706 1
- 2713 1
- 2715 1
- 2719 1
- 2724 1
- 2730 1
- 2741 1
- 2762 1
- 2793 1
- 2798 1
- 2810 1
- 2819 1
- 2824 1
- 2838 1
- 2852 1
- 2858 1
- 2863 1
- 2865 1
- 2871 1
- 2875 1
- 2876 1
- 2888 1
- 2902 1
- 2918 1
- 2926 1
- 2930 1
- 2943 1
- 2952 1
- 2965 1
- 2967 1
- 2977 1
- 2997 1
- 3021 1
- 3027 1
- 3031 1
- 3039 1
- 3053 1
- 3067 1
- 3091 1
- 3115 1
- 3128 1
- 3136 1
- 3156 1
- 3170 1
- 3188 1
- 3193 1
- 3202 1
- 3216 1
- 3234 1
- 3246 1
- 3256 1
- 3298 1
- 3339 1
- 3380 1
- 3410 1
- 3435 1
- 3480 1
- 3509 1
- 3546 1
- 3593 1
- 3623 1
- 3642 1
- 3677 1
- 3722 1
- 3760 1
- 3826 1
- 3895 1
- 3947 1
- 3991 1
- 4045 1
- 4128 1
- 4182 1
- 4193 1
- 4295 1
- 4337 1
- 4390 1
- 4421 1
- 4519 1
- 4545 1
- 4608 1
- 4693 1
- 4787 1
- 4820 1
- 4895 1
- 4995 1
- 5075 1
- 5196 1
- 5229 1
- 5340 1
- 5391 1
- 5462 1
- 5521 1
- 5546 1
- 5645 1
- 5716 1
- 5808 1
- 5878 1
- 5954 1
- 5996 1
- 6028 1
- 6115 1
- 6145 1
- 6215 1
- 6269 1
- 6332 1
- 6434 1
- 6488 1
- 6528 1
- 6547 1
- 6580 1
- 6623 1
- 6679 1
- 6785 1
- 6832 1
- 6916 1
- 6935 1
- 6942 1
- 7026 1
- 7059 1
- 7093 1
- 7145 1
- 7178 1
- 7217 1
- 7255 1
- 7285 1
- 7353 1
- 7404 1
- 7435 1
- 7471 1
- 7502 1
- 7523 1
- 7548 1
- 7581 1
- 7598 1
- 7624 1
- 7647 1
- 7666 1
- 7685 1
- 7703 1
- 7754 1
- 7767 1
- 7789 1
- 7814 1
- 7824 1
- 7831 1
- 7869 1
- 7896 1
- 7917 1
- 7946 1
- 7972 1
- 7986 1
- 8002 1
- 8019 1
- 8038 1
- 8073 1
- 8086 1
- 8119 1
- 8141 1
- 8157 1
- 8177 1
- 8194 1
- 8215 1
- 8239 1
- 8262 1
- 8287 1
- 8298 1
- 8318 1
- 8338 1
- 8355 1
- 8367 1
- 8390 1
- 8411 1
- 8420 1
- 8449 1
- 8478 1
- 8499 1
- 8519 1
- 8547 1
- 8564 1
- 8585 1
- 8600 1
- 8617 1
- 8635 1
- 8658 1
- 8681 1
- 8702 1
- 8710 1
- 8722 1
- 8737 1
- 8752 1
- 8769 1
- 8786 1
- 8800 1
- 8810 1
- 8828 1
- 8848 1
- 8865 1
- 8884 1
- 8895 1
- 8926 1
- 8943 1
- 8955 1
- 8975 1
- 8988 1
- 9003 1
- 9012 1
- 9019 1
- 9024 1
- 9038 1
- 9042 1
- 9054 1
- 9061 1
- 9067 1
- 9073 1
- 9075 1
- 9080 1
- 9084 1
- 9088 1
- 9094 1
- 9095 1
- 9100 1
- 9110 1
- 9116 1
- 9123 1
- 9131 1
- 9135 1
- 9140 1
- 9142 1
- 9143 1
- 9146 1
- 9150 1
- 9152 1
- 9158 1
- 9165 1
- 9167 1
- 9171 1
- 9174 1
- 9176 1
- 9181 1
- 9182 1
- 9186 1
- 9192 1
- 9193 1
- 9198 1
- 9199 1
- 9200 1
- 9212 1
- 9213 1
- 9225 1
- 9226 1
- 9232 1
- 9236 1
- 9238 1
- 9243 1
- 9246 1
- 9254 1
- 9256 1
- 9270 1
- 9279 1
- 9292 1
- 9296 1
- 9339 1
- 9346 1
- 9357 1
- 9382 1
- 9444 1
- 9458 1
- 9486 1
- 9510 1
- 9619 1
- 9646 1
- 9676 1
- 9710 1
- 9849 1
- 9894 1
- 9934 1
- 9974 1
- 10120 1
- 10170 1
- 10216 1
- 10265 1
- 10452 1
- 10503 1
- 10553 1
- 10615 1
- 10772 1
- 10819 1
- 10918 1
- 10969 1
- 11158 1
- 11212 1
- 11269 1
- 11317 1
- 11505 1
- 11569 1
- 11612 1
- 11641 1
- 11783 1
- 11838 1
- 11876 1
- 11907 1
- 12057 1
- 12064 1
- 12127 1
- 12179 1
- 12298 1
- 12323 1
- 12347 1
- 12432 1
- 12460 1
- 12490 1
- 12505 1
- 12566 1
- 12579 1
- 12601 1
- 12606 1
- 12676 1
- 12689 1
- 12699 1
- 12734 1
- 12785 1
- 12805 1
- 12813 1
- 12822 1
- 12844 1
- 12852 1
- 12863 1
- 12875 1
- 12919 1
- 12938 1
- 12976 1
- 12984 1
- 13020 1
- 13033 1
- 13042 1
- 13056 1
- 13101 1
- 13117 1
- 13142 1
- 13169 1
- 13247 1
- 13260 1
- 13287 1
- 13309 1
- 13413 1
- 13433 1
- 13483 1
- 13537 1
- 13814 1
- 13893 1
- 14089 1
- 14265 1
- 15062 1
- 15339 1
- 15506 1
- 15814 1
- 16881 1
- 17113 1
- 17331 1
- 17624 1
- 18398 1
- 18517 1
- 18674 1
- 18841 1
- 19296 1
- 19380 1
- 19507 1
- 19610 1
- 19853 1
- 19910 1
- 19976 1
- 20036 1
- 20163 1
- 20188 1
- 20222 1
- 20261 1
- 20354 1
- 20384 1
- 20416 1
- 20435 1
- 20491 1
- 20503 1
- 20520 1
- 20543 1
- 20587 1
- 20596 1
- 20608 1
- 20630 1
- 20640 1
- 20650 1
- 20714 1
- 20719 1
- 20724 1
- 20728 1
- 20766 1
- 20780 1
- 20807 1
- 20827 1
- 20852 1
- 20854 1
- 20857 1
- 20871 1
- 20906 1
- 20911 1
- 20914 1
- 20919 1
- 20931 1
- 20938 1
- 21008 1
- 21019 1
- 21043 1
- 21052 1
- 21087 1
- 21105 1
- 21115 1
- 21131 1
- 21144 1
state 1
- Virginia 785
fips 1
- 51740 · 785 ✖
county 1
- Portsmouth city 785
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
6004 | 6004 | 2020-03-20 | Portsmouth city | Virginia | 51740 | 1 | 0 |
7034 | 7034 | 2020-03-21 | Portsmouth city | Virginia | 51740 | 1 | 0 |
8170 | 8170 | 2020-03-22 | Portsmouth city | Virginia | 51740 | 1 | 0 |
9392 | 9392 | 2020-03-23 | Portsmouth city | Virginia | 51740 | 1 | 0 |
10740 | 10740 | 2020-03-24 | Portsmouth city | Virginia | 51740 | 3 | 0 |
12260 | 12260 | 2020-03-25 | Portsmouth city | Virginia | 51740 | 3 | 0 |
13905 | 13905 | 2020-03-26 | Portsmouth city | Virginia | 51740 | 3 | 0 |
15673 | 15673 | 2020-03-27 | Portsmouth city | Virginia | 51740 | 3 | 0 |
17552 | 17552 | 2020-03-28 | Portsmouth city | Virginia | 51740 | 4 | 0 |
19514 | 19514 | 2020-03-29 | Portsmouth city | Virginia | 51740 | 4 | 0 |
21580 | 21580 | 2020-03-30 | Portsmouth city | Virginia | 51740 | 4 | 0 |
23727 | 23727 | 2020-03-31 | Portsmouth city | Virginia | 51740 | 12 | 0 |
25943 | 25943 | 2020-04-01 | Portsmouth city | Virginia | 51740 | 13 | 0 |
28233 | 28233 | 2020-04-02 | Portsmouth city | Virginia | 51740 | 16 | 0 |
30580 | 30580 | 2020-04-03 | Portsmouth city | Virginia | 51740 | 17 | 1 |
32979 | 32979 | 2020-04-04 | Portsmouth city | Virginia | 51740 | 26 | 1 |
35417 | 35417 | 2020-04-05 | Portsmouth city | Virginia | 51740 | 26 | 1 |
37900 | 37900 | 2020-04-06 | Portsmouth city | Virginia | 51740 | 27 | 1 |
40434 | 40434 | 2020-04-07 | Portsmouth city | Virginia | 51740 | 36 | 1 |
43003 | 43003 | 2020-04-08 | Portsmouth city | Virginia | 51740 | 41 | 1 |
45599 | 45599 | 2020-04-09 | Portsmouth city | Virginia | 51740 | 44 | 1 |
48225 | 48225 | 2020-04-10 | Portsmouth city | Virginia | 51740 | 48 | 1 |
50883 | 50883 | 2020-04-11 | Portsmouth city | Virginia | 51740 | 49 | 1 |
53558 | 53558 | 2020-04-12 | Portsmouth city | Virginia | 51740 | 51 | 1 |
56248 | 56248 | 2020-04-13 | Portsmouth city | Virginia | 51740 | 54 | 1 |
58954 | 58954 | 2020-04-14 | Portsmouth city | Virginia | 51740 | 59 | 4 |
61673 | 61673 | 2020-04-15 | Portsmouth city | Virginia | 51740 | 59 | 4 |
64406 | 64406 | 2020-04-16 | Portsmouth city | Virginia | 51740 | 62 | 4 |
67154 | 67154 | 2020-04-17 | Portsmouth city | Virginia | 51740 | 63 | 4 |
69916 | 69916 | 2020-04-18 | Portsmouth city | Virginia | 51740 | 65 | 4 |
72686 | 72686 | 2020-04-19 | Portsmouth city | Virginia | 51740 | 65 | 4 |
75462 | 75462 | 2020-04-20 | Portsmouth city | Virginia | 51740 | 65 | 4 |
78246 | 78246 | 2020-04-21 | Portsmouth city | Virginia | 51740 | 82 | 4 |
81039 | 81039 | 2020-04-22 | Portsmouth city | Virginia | 51740 | 93 | 4 |
83840 | 83840 | 2020-04-23 | Portsmouth city | Virginia | 51740 | 98 | 4 |
86647 | 86647 | 2020-04-24 | Portsmouth city | Virginia | 51740 | 100 | 4 |
89462 | 89462 | 2020-04-25 | Portsmouth city | Virginia | 51740 | 103 | 5 |
92279 | 92279 | 2020-04-26 | Portsmouth city | Virginia | 51740 | 108 | 5 |
95108 | 95108 | 2020-04-27 | Portsmouth city | Virginia | 51740 | 114 | 5 |
97952 | 97952 | 2020-04-28 | Portsmouth city | Virginia | 51740 | 149 | 5 |
100802 | 100802 | 2020-04-29 | Portsmouth city | Virginia | 51740 | 150 | 5 |
103657 | 103657 | 2020-04-30 | Portsmouth city | Virginia | 51740 | 158 | 5 |
106521 | 106521 | 2020-05-01 | Portsmouth city | Virginia | 51740 | 170 | 7 |
109390 | 109390 | 2020-05-02 | Portsmouth city | Virginia | 51740 | 173 | 8 |
112264 | 112264 | 2020-05-03 | Portsmouth city | Virginia | 51740 | 183 | 8 |
115147 | 115147 | 2020-05-04 | Portsmouth city | Virginia | 51740 | 183 | 8 |
118106 | 118106 | 2020-05-05 | Portsmouth city | Virginia | 51740 | 187 | 8 |
121070 | 121070 | 2020-05-06 | Portsmouth city | Virginia | 51740 | 187 | 8 |
124051 | 124051 | 2020-05-07 | Portsmouth city | Virginia | 51740 | 193 | 8 |
127036 | 127036 | 2020-05-08 | Portsmouth city | Virginia | 51740 | 194 | 8 |
130026 | 130026 | 2020-05-09 | Portsmouth city | Virginia | 51740 | 202 | 8 |
133016 | 133016 | 2020-05-10 | Portsmouth city | Virginia | 51740 | 202 | 8 |
136006 | 136006 | 2020-05-11 | Portsmouth city | Virginia | 51740 | 208 | 8 |
138997 | 138997 | 2020-05-12 | Portsmouth city | Virginia | 51740 | 210 | 9 |
141993 | 141993 | 2020-05-13 | Portsmouth city | Virginia | 51740 | 213 | 9 |
144990 | 144990 | 2020-05-14 | Portsmouth city | Virginia | 51740 | 217 | 9 |
147993 | 147993 | 2020-05-15 | Portsmouth city | Virginia | 51740 | 219 | 10 |
151002 | 151002 | 2020-05-16 | Portsmouth city | Virginia | 51740 | 222 | 10 |
154013 | 154013 | 2020-05-17 | Portsmouth city | Virginia | 51740 | 225 | 10 |
157030 | 157030 | 2020-05-18 | Portsmouth city | Virginia | 51740 | 228 | 10 |
160054 | 160054 | 2020-05-19 | Portsmouth city | Virginia | 51740 | 237 | 10 |
163082 | 163082 | 2020-05-20 | Portsmouth city | Virginia | 51740 | 241 | 11 |
166111 | 166111 | 2020-05-21 | Portsmouth city | Virginia | 51740 | 245 | 11 |
169147 | 169147 | 2020-05-22 | Portsmouth city | Virginia | 51740 | 251 | 11 |
172188 | 172188 | 2020-05-23 | Portsmouth city | Virginia | 51740 | 253 | 11 |
175231 | 175231 | 2020-05-24 | Portsmouth city | Virginia | 51740 | 262 | 11 |
178276 | 178276 | 2020-05-25 | Portsmouth city | Virginia | 51740 | 272 | 11 |
181320 | 181320 | 2020-05-26 | Portsmouth city | Virginia | 51740 | 281 | 11 |
184371 | 184371 | 2020-05-27 | Portsmouth city | Virginia | 51740 | 282 | 11 |
187428 | 187428 | 2020-05-28 | Portsmouth city | Virginia | 51740 | 284 | 11 |
190492 | 190492 | 2020-05-29 | Portsmouth city | Virginia | 51740 | 294 | 11 |
193558 | 193558 | 2020-05-30 | Portsmouth city | Virginia | 51740 | 307 | 11 |
196628 | 196628 | 2020-05-31 | Portsmouth city | Virginia | 51740 | 308 | 11 |
199701 | 199701 | 2020-06-01 | Portsmouth city | Virginia | 51740 | 313 | 11 |
202777 | 202777 | 2020-06-02 | Portsmouth city | Virginia | 51740 | 325 | 11 |
205856 | 205856 | 2020-06-03 | Portsmouth city | Virginia | 51740 | 322 | 11 |
208938 | 208938 | 2020-06-04 | Portsmouth city | Virginia | 51740 | 325 | 11 |
212023 | 212023 | 2020-06-05 | Portsmouth city | Virginia | 51740 | 325 | 11 |
215110 | 215110 | 2020-06-06 | Portsmouth city | Virginia | 51740 | 335 | 11 |
218200 | 218200 | 2020-06-07 | Portsmouth city | Virginia | 51740 | 343 | 11 |
221292 | 221292 | 2020-06-08 | Portsmouth city | Virginia | 51740 | 343 | 11 |
224388 | 224388 | 2020-06-09 | Portsmouth city | Virginia | 51740 | 351 | 11 |
227488 | 227488 | 2020-06-10 | Portsmouth city | Virginia | 51740 | 354 | 11 |
230592 | 230592 | 2020-06-11 | Portsmouth city | Virginia | 51740 | 364 | 11 |
233697 | 233697 | 2020-06-12 | Portsmouth city | Virginia | 51740 | 370 | 11 |
236804 | 236804 | 2020-06-13 | Portsmouth city | Virginia | 51740 | 375 | 12 |
239912 | 239912 | 2020-06-14 | Portsmouth city | Virginia | 51740 | 375 | 12 |
243023 | 243023 | 2020-06-15 | Portsmouth city | Virginia | 51740 | 386 | 12 |
246136 | 246136 | 2020-06-16 | Portsmouth city | Virginia | 51740 | 387 | 12 |
249248 | 249248 | 2020-06-17 | Portsmouth city | Virginia | 51740 | 395 | 13 |
252363 | 252363 | 2020-06-18 | Portsmouth city | Virginia | 51740 | 402 | 13 |
255482 | 255482 | 2020-06-19 | Portsmouth city | Virginia | 51740 | 405 | 13 |
258609 | 258609 | 2020-06-20 | Portsmouth city | Virginia | 51740 | 405 | 13 |
261736 | 261736 | 2020-06-21 | Portsmouth city | Virginia | 51740 | 406 | 13 |
264865 | 264865 | 2020-06-22 | Portsmouth city | Virginia | 51740 | 419 | 13 |
267994 | 267994 | 2020-06-23 | Portsmouth city | Virginia | 51740 | 421 | 16 |
271128 | 271128 | 2020-06-24 | Portsmouth city | Virginia | 51740 | 426 | 16 |
274268 | 274268 | 2020-06-25 | Portsmouth city | Virginia | 51740 | 442 | 16 |
277416 | 277416 | 2020-06-26 | Portsmouth city | Virginia | 51740 | 449 | 16 |
280564 | 280564 | 2020-06-27 | Portsmouth city | Virginia | 51740 | 455 | 16 |
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);