ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 51199 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 618 ✖
- 44 5
- 1 4
- 9 4
- 25 4
- 43 4
- 77 4
- 86 4
- 3802 4
- 5211 4
- 9651 4
- 46 3
- 62 3
- 63 3
- 72 3
- 94 3
- 106 3
- 115 3
- 3732 3
- 3775 3
- 3776 3
- 3803 3
- 3808 3
- 3843 3
- 3873 3
- 3926 3
- 4024 3
- 4108 3
- 4218 3
- 4395 3
- 4542 3
- 4696 3
- 4828 3
- 4967 3
- 5088 3
- 5325 3
- 5417 3
- 5485 3
- 5544 3
- 5586 3
- 5631 3
- 5685 3
- 5754 3
- 5852 3
- 5941 3
- 6099 3
- 6483 3
- 6955 3
- 7917 3
- 8597 3
- 9037 3
- 9290 3
- 9439 3
- 9549 3
- 9618 3
- 9685 3
- 9728 3
- 9745 3
- 9770 3
- 9801 3
- 9845 3
- 9894 3
- 9956 3
- 10048 3
- 3 2
- 5 2
- 17 2
- 35 2
- 38 2
- 45 2
- 47 2
- 48 2
- 55 2
- 67 2
- 71 2
- 93 2
- 131 2
- 444 2
- 492 2
- 497 2
- 541 2
- 564 2
- 616 2
- 626 2
- 637 2
- 658 2
- 3724 2
- 3733 2
- 3740 2
- 3774 2
- 3780 2
- 3783 2
- 3789 2
- 3796 2
- 3797 2
- 3807 2
- 3815 2
- 9734 2
- 6 1
- 8 1
- 11 1
- 14 1
- 16 1
- 19 1
- 20 1
- 21 1
- 27 1
- 29 1
- 33 1
- 37 1
- 51 1
- 56 1
- 57 1
- 59 1
- 60 1
- 61 1
- 65 1
- 68 1
- 69 1
- 74 1
- 79 1
- 82 1
- 89 1
- 90 1
- 91 1
- 97 1
- 98 1
- 99 1
- 101 1
- 108 1
- 110 1
- 114 1
- 116 1
- 120 1
- 124 1
- 129 1
- 135 1
- 140 1
- 144 1
- 149 1
- 160 1
- 168 1
- 176 1
- 180 1
- 181 1
- 191 1
- 200 1
- 216 1
- 226 1
- 234 1
- 237 1
- 243 1
- 259 1
- 270 1
- 279 1
- 282 1
- 287 1
- 290 1
- 293 1
- 301 1
- 308 1
- 310 1
- 318 1
- 330 1
- 335 1
- 338 1
- 355 1
- 361 1
- 366 1
- 373 1
- 374 1
- 375 1
- 383 1
- 394 1
- 400 1
- 406 1
- 409 1
- 410 1
- 412 1
- 413 1
- 419 1
- 423 1
- 427 1
- 432 1
- 433 1
- 437 1
- 451 1
- 454 1
- 461 1
- 467 1
- 468 1
- 474 1
- 480 1
- 482 1
- 486 1
- 488 1
- 503 1
- 506 1
- 507 1
- 509 1
- 513 1
- 514 1
- 520 1
- 523 1
- 528 1
- 532 1
- 534 1
- 537 1
- 544 1
- 545 1
- 546 1
- 549 1
- 553 1
- 554 1
- 557 1
- 561 1
- 562 1
- 566 1
- 570 1
- 580 1
- 584 1
- 587 1
- 588 1
- 592 1
- 595 1
- 603 1
- 612 1
- 617 1
- 620 1
- 625 1
- 629 1
- 640 1
- 644 1
- 646 1
- 650 1
- 661 1
- 665 1
- 668 1
- 670 1
- 686 1
- 697 1
- 707 1
- 710 1
- 713 1
- 718 1
- 719 1
- 724 1
- 735 1
- 745 1
- 759 1
- 767 1
- 775 1
- 783 1
- 806 1
- 817 1
- 825 1
- 848 1
- 859 1
- 867 1
- 875 1
- 877 1
- 889 1
- 908 1
- 921 1
- 929 1
- 950 1
- 957 1
- 968 1
- 975 1
- 992 1
- 1007 1
- 1012 1
- 1023 1
- 1038 1
- 1046 1
- 1069 1
- 1089 1
- 1105 1
- 1129 1
- 1159 1
- 1181 1
- 1213 1
- 1241 1
- 1262 1
- 1276 1
- 1306 1
- 1334 1
- 1362 1
- 1367 1
- 1368 1
- 1372 1
- 1397 1
- 1441 1
- 1452 1
- 1472 1
- 1491 1
- 1493 1
- 1566 1
- 1601 1
- 1634 1
- 1661 1
- 1701 1
- 1729 1
- 1757 1
- 1801 1
- 1843 1
- 1886 1
- 1899 1
- 1919 1
- 1956 1
- 1999 1
- 2040 1
- 2077 1
- 2099 1
- 2137 1
- 2175 1
- 2198 1
- 2253 1
- 2287 1
- 2347 1
- 2397 1
- 2448 1
- 2485 1
- 2514 1
- 2534 1
- 2548 1
- 2559 1
- 2574 1
- 2592 1
- 2602 1
- 2643 1
- 2672 1
- 2701 1
- 2728 1
- 2743 1
- 2755 1
- 2774 1
- 2790 1
- 2809 1
- 2832 1
- 2840 1
- 2849 1
- 2872 1
- 2878 1
- 2895 1
- 2897 1
- 2924 1
- 2932 1
- 2952 1
- 2967 1
- 2984 1
- 2990 1
- 3000 1
- 3008 1
- 3011 1
- 3037 1
- 3054 1
- 3059 1
- 3082 1
- 3104 1
- 3114 1
- 3122 1
- 3130 1
- 3152 1
- 3163 1
- 3180 1
- 3200 1
- 3205 1
- 3220 1
- 3238 1
- 3271 1
- 3286 1
- 3305 1
- 3323 1
- 3326 1
- 3331 1
- 3345 1
- 3354 1
- 3367 1
- 3376 1
- 3393 1
- 3403 1
- 3411 1
- 3430 1
- 3439 1
- 3458 1
- 3469 1
- 3483 1
- 3489 1
- 3500 1
- 3513 1
- 3525 1
- 3533 1
- 3540 1
- 3547 1
- 3552 1
- 3554 1
- 3565 1
- 3575 1
- 3581 1
- 3588 1
- 3597 1
- 3604 1
- 3608 1
- 3619 1
- 3622 1
- 3632 1
- 3639 1
- 3643 1
- 3647 1
- 3654 1
- 3665 1
- 3674 1
- 3685 1
- 3689 1
- 3696 1
- 3697 1
- 3701 1
- 3706 1
- 3707 1
- 3712 1
- 3720 1
- 3723 1
- 3727 1
- 3729 1
- 3734 1
- 3735 1
- 3738 1
- 3739 1
- 3741 1
- 3768 1
- 3771 1
- 3777 1
- 3778 1
- 3786 1
- 3788 1
- 3792 1
- 3794 1
- 3798 1
- 3799 1
- 3800 1
- 3804 1
- 3805 1
- 3810 1
- 3814 1
- 3819 1
- 3826 1
- 3830 1
- 3832 1
- 3837 1
- 3851 1
- 3852 1
- 3856 1
- 3862 1
- 3896 1
- 3902 1
- 3911 1
- 3922 1
- 3959 1
- 3971 1
- 3988 1
- 4007 1
- 4046 1
- 4065 1
- 4079 1
- 4091 1
- 4151 1
- 4168 1
- 4191 1
- 4203 1
- 4274 1
- 4290 1
- 4326 1
- 4358 1
- 4446 1
- 4477 1
- 4492 1
- 4511 1
- 4611 1
- 4628 1
- 4654 1
- 4677 1
- 4736 1
- 4752 1
- 4772 1
- 4804 1
- 4878 1
- 4900 1
- 4922 1
- 4945 1
- 5018 1
- 5037 1
- 5058 1
- 5072 1
- 5140 1
- 5147 1
- 5173 1
- 5188 1
- 5273 1
- 5287 1
- 5306 1
- 5367 1
- 5381 1
- 5395 1
- 5409 1
- 5444 1
- 5462 1
- 5470 1
- 5477 1
- 5504 1
- 5508 1
- 5514 1
- 5535 1
- 5564 1
- 5572 1
- 5576 1
- 5581 1
- 5594 1
- 5600 1
- 5614 1
- 5624 1
- 5649 1
- 5657 1
- 5665 1
- 5676 1
- 5700 1
- 5708 1
- 5719 1
- 5733 1
- 5790 1
- 5802 1
- 5818 1
- 5840 1
- 5889 1
- 5903 1
- 5916 1
- 5925 1
- 5989 1
- 6007 1
- 6019 1
- 6058 1
- 6176 1
- 6236 1
- 6305 1
- 6392 1
- 6671 1
- 6770 1
- 6849 1
- 6875 1
- 7464 1
- 7558 1
- 7676 1
- 7805 1
- 8240 1
- 8332 1
- 8398 1
- 8514 1
- 8773 1
- 8847 1
- 8892 1
- 8961 1
- 9156 1
- 9183 1
- 9212 1
- 9256 1
- 9358 1
- 9382 1
- 9401 1
- 9423 1
- 9486 1
- 9512 1
- 9525 1
- 9543 1
- 9580 1
- 9584 1
- 9594 1
- 9604 1
- 9634 1
- 9639 1
- 9641 1
- 9664 1
- 9665 1
- 9669 1
- 9674 1
- 9701 1
- 9714 1
- 9723 1
- 9726 1
- 9741 1
- 9744 1
- 9757 1
- 9758 1
- 9764 1
- 9765 1
- 9778 1
- 9781 1
- 9790 1
- 9796 1
- 9812 1
- 9815 1
- 9824 1
- 9837 1
- 9862 1
- 9872 1
- 9881 1
- 9886 1
- 9908 1
- 9922 1
- 9931 1
- 9949 1
- 9975 1
- 9997 1
- 10032 1
- 10036 1
- 10091 1
- 10121 1
- 10142 1
- 10170 1
- 10189 1
state 1
- Virginia 789
fips 1
- 51199 · 789 ✖
county 1
- York 789
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3181 | 3181 | 2020-03-16 | York | Virginia | 51199 | 1 | 0 |
3721 | 3721 | 2020-03-17 | York | Virginia | 51199 | 1 | 0 |
4355 | 4355 | 2020-03-18 | York | Virginia | 51199 | 1 | 0 |
5111 | 5111 | 2020-03-19 | York | Virginia | 51199 | 1 | 0 |
6012 | 6012 | 2020-03-20 | York | Virginia | 51199 | 3 | 0 |
7043 | 7043 | 2020-03-21 | York | Virginia | 51199 | 3 | 0 |
8180 | 8180 | 2020-03-22 | York | Virginia | 51199 | 5 | 0 |
9403 | 9403 | 2020-03-23 | York | Virginia | 51199 | 5 | 0 |
10752 | 10752 | 2020-03-24 | York | Virginia | 51199 | 6 | 0 |
12274 | 12274 | 2020-03-25 | York | Virginia | 51199 | 8 | 0 |
13924 | 13924 | 2020-03-26 | York | Virginia | 51199 | 9 | 0 |
15692 | 15692 | 2020-03-27 | York | Virginia | 51199 | 9 | 0 |
17572 | 17572 | 2020-03-28 | York | Virginia | 51199 | 9 | 0 |
19537 | 19537 | 2020-03-29 | York | Virginia | 51199 | 9 | 0 |
21604 | 21604 | 2020-03-30 | York | Virginia | 51199 | 11 | 0 |
23753 | 23753 | 2020-03-31 | York | Virginia | 51199 | 14 | 0 |
25971 | 25971 | 2020-04-01 | York | Virginia | 51199 | 16 | 0 |
28261 | 28261 | 2020-04-02 | York | Virginia | 51199 | 17 | 0 |
30613 | 30613 | 2020-04-03 | York | Virginia | 51199 | 17 | 0 |
33013 | 33013 | 2020-04-04 | York | Virginia | 51199 | 19 | 0 |
35451 | 35451 | 2020-04-05 | York | Virginia | 51199 | 20 | 0 |
37935 | 37935 | 2020-04-06 | York | Virginia | 51199 | 21 | 0 |
40470 | 40470 | 2020-04-07 | York | Virginia | 51199 | 25 | 1 |
43039 | 43039 | 2020-04-08 | York | Virginia | 51199 | 25 | 1 |
45635 | 45635 | 2020-04-09 | York | Virginia | 51199 | 25 | 1 |
48262 | 48262 | 2020-04-10 | York | Virginia | 51199 | 25 | 1 |
50920 | 50920 | 2020-04-11 | York | Virginia | 51199 | 27 | 1 |
53595 | 53595 | 2020-04-12 | York | Virginia | 51199 | 29 | 1 |
56285 | 56285 | 2020-04-13 | York | Virginia | 51199 | 33 | 1 |
58991 | 58991 | 2020-04-14 | York | Virginia | 51199 | 35 | 1 |
61710 | 61710 | 2020-04-15 | York | Virginia | 51199 | 35 | 1 |
64443 | 64443 | 2020-04-16 | York | Virginia | 51199 | 37 | 1 |
67191 | 67191 | 2020-04-17 | York | Virginia | 51199 | 38 | 1 |
69953 | 69953 | 2020-04-18 | York | Virginia | 51199 | 38 | 1 |
72723 | 72723 | 2020-04-19 | York | Virginia | 51199 | 44 | 1 |
75499 | 75499 | 2020-04-20 | York | Virginia | 51199 | 44 | 1 |
78282 | 78282 | 2020-04-21 | York | Virginia | 51199 | 43 | 1 |
81075 | 81075 | 2020-04-22 | York | Virginia | 51199 | 43 | 1 |
83876 | 83876 | 2020-04-23 | York | Virginia | 51199 | 43 | 1 |
86683 | 86683 | 2020-04-24 | York | Virginia | 51199 | 43 | 1 |
89498 | 89498 | 2020-04-25 | York | Virginia | 51199 | 44 | 1 |
92315 | 92315 | 2020-04-26 | York | Virginia | 51199 | 44 | 1 |
95144 | 95144 | 2020-04-27 | York | Virginia | 51199 | 44 | 1 |
97989 | 97989 | 2020-04-28 | York | Virginia | 51199 | 45 | 1 |
100839 | 100839 | 2020-04-29 | York | Virginia | 51199 | 45 | 1 |
103694 | 103694 | 2020-04-30 | York | Virginia | 51199 | 46 | 1 |
106558 | 106558 | 2020-05-01 | York | Virginia | 51199 | 46 | 1 |
109427 | 109427 | 2020-05-02 | York | Virginia | 51199 | 46 | 1 |
112301 | 112301 | 2020-05-03 | York | Virginia | 51199 | 47 | 1 |
115184 | 115184 | 2020-05-04 | York | Virginia | 51199 | 47 | 1 |
118143 | 118143 | 2020-05-05 | York | Virginia | 51199 | 48 | 1 |
121107 | 121107 | 2020-05-06 | York | Virginia | 51199 | 48 | 1 |
124087 | 124087 | 2020-05-07 | York | Virginia | 51199 | 51 | 1 |
127072 | 127072 | 2020-05-08 | York | Virginia | 51199 | 55 | 2 |
130062 | 130062 | 2020-05-09 | York | Virginia | 51199 | 55 | 2 |
133052 | 133052 | 2020-05-10 | York | Virginia | 51199 | 56 | 2 |
136042 | 136042 | 2020-05-11 | York | Virginia | 51199 | 57 | 2 |
139033 | 139033 | 2020-05-12 | York | Virginia | 51199 | 59 | 2 |
142029 | 142029 | 2020-05-13 | York | Virginia | 51199 | 60 | 2 |
145026 | 145026 | 2020-05-14 | York | Virginia | 51199 | 61 | 2 |
148029 | 148029 | 2020-05-15 | York | Virginia | 51199 | 62 | 3 |
151038 | 151038 | 2020-05-16 | York | Virginia | 51199 | 62 | 3 |
154049 | 154049 | 2020-05-17 | York | Virginia | 51199 | 62 | 3 |
157066 | 157066 | 2020-05-18 | York | Virginia | 51199 | 63 | 3 |
160090 | 160090 | 2020-05-19 | York | Virginia | 51199 | 63 | 3 |
163118 | 163118 | 2020-05-20 | York | Virginia | 51199 | 63 | 3 |
166147 | 166147 | 2020-05-21 | York | Virginia | 51199 | 65 | 3 |
169183 | 169183 | 2020-05-22 | York | Virginia | 51199 | 67 | 3 |
172224 | 172224 | 2020-05-23 | York | Virginia | 51199 | 67 | 3 |
175267 | 175267 | 2020-05-24 | York | Virginia | 51199 | 68 | 3 |
178312 | 178312 | 2020-05-25 | York | Virginia | 51199 | 69 | 3 |
181356 | 181356 | 2020-05-26 | York | Virginia | 51199 | 71 | 3 |
184407 | 184407 | 2020-05-27 | York | Virginia | 51199 | 71 | 3 |
187464 | 187464 | 2020-05-28 | York | Virginia | 51199 | 72 | 3 |
190528 | 190528 | 2020-05-29 | York | Virginia | 51199 | 72 | 3 |
193594 | 193594 | 2020-05-30 | York | Virginia | 51199 | 72 | 3 |
196664 | 196664 | 2020-05-31 | York | Virginia | 51199 | 74 | 3 |
199737 | 199737 | 2020-06-01 | York | Virginia | 51199 | 77 | 3 |
202813 | 202813 | 2020-06-02 | York | Virginia | 51199 | 77 | 3 |
205892 | 205892 | 2020-06-03 | York | Virginia | 51199 | 77 | 3 |
208974 | 208974 | 2020-06-04 | York | Virginia | 51199 | 77 | 3 |
212059 | 212059 | 2020-06-05 | York | Virginia | 51199 | 79 | 3 |
215146 | 215146 | 2020-06-06 | York | Virginia | 51199 | 82 | 3 |
218236 | 218236 | 2020-06-07 | York | Virginia | 51199 | 86 | 3 |
221328 | 221328 | 2020-06-08 | York | Virginia | 51199 | 86 | 3 |
224424 | 224424 | 2020-06-09 | York | Virginia | 51199 | 86 | 3 |
227524 | 227524 | 2020-06-10 | York | Virginia | 51199 | 86 | 3 |
230628 | 230628 | 2020-06-11 | York | Virginia | 51199 | 89 | 3 |
233733 | 233733 | 2020-06-12 | York | Virginia | 51199 | 90 | 3 |
236840 | 236840 | 2020-06-13 | York | Virginia | 51199 | 91 | 3 |
239948 | 239948 | 2020-06-14 | York | Virginia | 51199 | 93 | 3 |
243059 | 243059 | 2020-06-15 | York | Virginia | 51199 | 93 | 3 |
246172 | 246172 | 2020-06-16 | York | Virginia | 51199 | 94 | 3 |
249284 | 249284 | 2020-06-17 | York | Virginia | 51199 | 94 | 3 |
252399 | 252399 | 2020-06-18 | York | Virginia | 51199 | 94 | 3 |
255518 | 255518 | 2020-06-19 | York | Virginia | 51199 | 97 | 3 |
258645 | 258645 | 2020-06-20 | York | Virginia | 51199 | 98 | 3 |
261772 | 261772 | 2020-06-21 | York | Virginia | 51199 | 99 | 3 |
264901 | 264901 | 2020-06-22 | York | Virginia | 51199 | 101 | 3 |
268030 | 268030 | 2020-06-23 | York | Virginia | 51199 | 106 | 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);