ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 53077 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 586 ✖
- 73738 7
- 46605 5
- 71586 5
- 30967 4
- 31103 4
- 31263 4
- 31837 4
- 38138 4
- 44486 4
- 47727 4
- 48370 4
- 54191 4
- 72747 4
- 73492 4
- 147 3
- 868 3
- 9958 3
- 13356 3
- 24112 3
- 26970 3
- 29921 3
- 30689 3
- 30813 3
- 31447 3
- 31585 3
- 31700 3
- 31998 3
- 32264 3
- 32593 3
- 32881 3
- 33577 3
- 34275 3
- 35309 3
- 36570 3
- 39231 3
- 40542 3
- 41507 3
- 42501 3
- 43134 3
- 43824 3
- 45068 3
- 45591 3
- 46028 3
- 46368 3
- 47053 3
- 47328 3
- 47559 3
- 50642 3
- 59962 3
- 66443 3
- 69313 3
- 69874 3
- 70581 3
- 72075 3
- 72498 3
- 73051 3
- 73269 3
- 73321 3
- 73355 3
- 73402 3
- 73617 3
- 2 2
- 4 2
- 9 2
- 289 2
- 400 2
- 447 2
- 535 2
- 759 2
- 952 2
- 1085 2
- 1293 2
- 1411 2
- 1756 2
- 2025 2
- 3615 2
- 4057 2
- 5009 2
- 6062 2
- 6596 2
- 8344 2
- 11820 2
- 12109 2
- 12249 2
- 12349 2
- 12388 2
- 12529 2
- 12673 2
- 12827 2
- 13027 2
- 13276 2
- 13655 2
- 14182 2
- 14822 2
- 15070 2
- 17293 2
- 18598 2
- 19764 2
- 19981 2
- 21053 2
- 21411 2
- 22992 2
- 24886 2
- 25567 2
- 26402 2
- 27279 2
- 27643 2
- 27971 2
- 28235 2
- 28335 2
- 28415 2
- 28550 2
- 28828 2
- 29214 2
- 29535 2
- 30048 2
- 30166 2
- 30523 2
- 31360 2
- 31631 2
- 32679 2
- 44141 2
- 45911 2
- 73227 2
- 73342 2
- 73544 2
- 73660 2
- 3 1
- 5 1
- 10 1
- 20 1
- 24 1
- 25 1
- 44 1
- 51 1
- 61 1
- 72 1
- 100 1
- 200 1
- 216 1
- 363 1
- 380 1
- 573 1
- 635 1
- 674 1
- 707 1
- 771 1
- 1066 1
- 1135 1
- 1197 1
- 1237 1
- 1440 1
- 1597 1
- 1658 1
- 1781 1
- 1966 1
- 2186 1
- 2308 1
- 2349 1
- 2443 1
- 2517 1
- 2598 1
- 2637 1
- 2684 1
- 2775 1
- 2858 1
- 2965 1
- 3066 1
- 3123 1
- 3252 1
- 3380 1
- 3502 1
- 3891 1
- 4103 1
- 4392 1
- 4539 1
- 4714 1
- 4929 1
- 5092 1
- 5259 1
- 5504 1
- 5611 1
- 5727 1
- 5830 1
- 5939 1
- 6359 1
- 6476 1
- 6736 1
- 6940 1
- 7040 1
- 7170 1
- 7241 1
- 7316 1
- 7385 1
- 7476 1
- 7556 1
- 7667 1
- 7742 1
- 7855 1
- 7935 1
- 8018 1
- 8138 1
- 8242 1
- 8578 1
- 8676 1
- 8763 1
- 8831 1
- 9202 1
- 9275 1
- 9431 1
- 9545 1
- 9610 1
- 9693 1
- 9755 1
- 9855 1
- 10208 1
- 10268 1
- 10338 1
- 10381 1
- 10449 1
- 10516 1
- 10557 1
- 10599 1
- 10671 1
- 10700 1
- 10755 1
- 10787 1
- 10865 1
- 10935 1
- 10954 1
- 10995 1
- 11035 1
- 11125 1
- 11172 1
- 11226 1
- 11252 1
- 11279 1
- 11303 1
- 11346 1
- 11392 1
- 11422 1
- 11459 1
- 11476 1
- 11490 1
- 11503 1
- 11530 1
- 11576 1
- 11610 1
- 11647 1
- 11650 1
- 11672 1
- 11689 1
- 11718 1
- 11735 1
- 11775 1
- 11808 1
- 11856 1
- 11880 1
- 11901 1
- 11920 1
- 11937 1
- 11945 1
- 11977 1
- 11995 1
- 12027 1
- 12052 1
- 12078 1
- 12135 1
- 12148 1
- 12179 1
- 12204 1
- 12216 1
- 12279 1
- 12306 1
- 12335 1
- 12419 1
- 12435 1
- 12455 1
- 12484 1
- 12499 1
- 12557 1
- 12577 1
- 12604 1
- 12634 1
- 12661 1
- 12687 1
- 12718 1
- 12741 1
- 12765 1
- 12803 1
- 12863 1
- 12886 1
- 12907 1
- 12936 1
- 12983 1
- 13085 1
- 13112 1
- 13144 1
- 13173 1
- 13220 1
- 13477 1
- 13609 1
- 13775 1
- 13857 1
- 13930 1
- 14001 1
- 14098 1
- 14562 1
- 14712 1
- 15006 1
- 15331 1
- 15448 1
- 15562 1
- 15654 1
- 15729 1
- 15815 1
- 15928 1
- 16330 1
- 16577 1
- 16683 1
- 16852 1
- 17071 1
- 17585 1
- 17677 1
- 17780 1
- 18114 1
- 18451 1
- 18985 1
- 19180 1
- 19431 1
- 20320 1
- 20412 1
- 20748 1
- 21744 1
- 21902 1
- 22117 1
- 22441 1
- 22769 1
- 23256 1
- 23369 1
- 23534 1
- 23755 1
- 23901 1
- 24401 1
- 24459 1
- 24627 1
- 24751 1
- 25000 1
- 25086 1
- 25149 1
- 25333 1
- 25415 1
- 25802 1
- 25922 1
- 26056 1
- 26194 1
- 26306 1
- 26569 1
- 26639 1
- 26727 1
- 26783 1
- 26907 1
- 27045 1
- 27107 1
- 27177 1
- 27224 1
- 27361 1
- 27399 1
- 27472 1
- 27528 1
- 27592 1
- 27718 1
- 27771 1
- 27817 1
- 27857 1
- 27924 1
- 28041 1
- 28084 1
- 28118 1
- 28201 1
- 28283 1
- 28523 1
- 28600 1
- 28622 1
- 28655 1
- 28717 1
- 28781 1
- 28895 1
- 28945 1
- 28980 1
- 29055 1
- 29152 1
- 29264 1
- 29320 1
- 29359 1
- 29423 1
- 29501 1
- 29629 1
- 29652 1
- 29753 1
- 29816 1
- 29883 1
- 29962 1
- 30208 1
- 30320 1
- 30349 1
- 30404 1
- 30448 1
- 30492 1
- 30568 1
- 30588 1
- 30616 1
- 30656 1
- 30729 1
- 30753 1
- 30775 1
- 30796 1
- 30868 1
- 30887 1
- 30904 1
- 30939 1
- 31026 1
- 31047 1
- 31083 1
- 31197 1
- 31206 1
- 31233 1
- 31421 1
- 31493 1
- 31515 1
- 31532 1
- 31563 1
- 31620 1
- 31673 1
- 31742 1
- 31772 1
- 31787 1
- 31819 1
- 31901 1
- 31933 1
- 31956 1
- 32088 1
- 32126 1
- 32172 1
- 32220 1
- 32354 1
- 32401 1
- 32463 1
- 32541 1
- 32767 1
- 32815 1
- 33064 1
- 33265 1
- 33398 1
- 33505 1
- 33736 1
- 33849 1
- 34009 1
- 34202 1
- 34442 1
- 34575 1
- 34872 1
- 35111 1
- 35635 1
- 35759 1
- 35973 1
- 36274 1
- 36977 1
- 37133 1
- 37412 1
- 37824 1
- 38579 1
- 38701 1
- 38971 1
- 39659 1
- 39744 1
- 40070 1
- 40318 1
- 40922 1
- 41028 1
- 41118 1
- 41332 1
- 41892 1
- 41977 1
- 42106 1
- 42351 1
- 42721 1
- 42773 1
- 42844 1
- 43025 1
- 43360 1
- 43403 1
- 43525 1
- 43732 1
- 44080 1
- 44364 1
- 44764 1
- 44847 1
- 45014 1
- 45249 1
- 45330 1
- 45430 1
- 45528 1
- 45743 1
- 45819 1
- 46146 1
- 46187 1
- 46252 1
- 46326 1
- 46505 1
- 46569 1
- 46783 1
- 46835 1
- 46888 1
- 46989 1
- 47155 1
- 47203 1
- 47222 1
- 47288 1
- 47410 1
- 47436 1
- 47477 1
- 47526 1
- 47607 1
- 47639 1
- 47667 1
- 47936 1
- 48020 1
- 48164 1
- 49052 1
- 49361 1
- 49651 1
- 50120 1
- 51722 1
- 52302 1
- 53004 1
- 53743 1
- 57300 1
- 57893 1
- 58962 1
- 62594 1
- 63015 1
- 63784 1
- 65062 1
- 67874 1
- 68107 1
- 68459 1
- 69172 1
- 69678 1
- 70970 1
- 71143 1
- 71336 1
- 71480 1
- 71904 1
- 71991 1
- 72215 1
- 72286 1
- 72358 1
- 72440 1
- 72574 1
- 72607 1
- 72664 1
- 72711 1
- 72931 1
- 72992 1
- 73025 1
- 73151 1
- 73199 1
- 73280 1
- 73291 1
- 73302 1
- 73311 1
- 73331 1
- 73335 1
- 73368 1
- 73378 1
- 73382 1
- 73395 1
- 73424 1
- 73472 1
- 73480 1
- 73573 1
- 73593 1
- 73699 1
- 73713 1
- 73887 1
state 1
- Washington 793
fips 1
- 53077 · 793 ✖
county 1
- Yakima 793
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1614 | 1614 | 2020-03-12 | Yakima | Washington | 53077 | 2 | 0 |
1925 | 1925 | 2020-03-13 | Yakima | Washington | 53077 | 2 | 0 |
2299 | 2299 | 2020-03-14 | Yakima | Washington | 53077 | 3 | 0 |
2728 | 2728 | 2020-03-15 | Yakima | Washington | 53077 | 4 | 0 |
3202 | 3202 | 2020-03-16 | Yakima | Washington | 53077 | 4 | 0 |
3744 | 3744 | 2020-03-17 | Yakima | Washington | 53077 | 5 | 0 |
4379 | 4379 | 2020-03-18 | Yakima | Washington | 53077 | 9 | 0 |
5136 | 5136 | 2020-03-19 | Yakima | Washington | 53077 | 9 | 0 |
6040 | 6040 | 2020-03-20 | Yakima | Washington | 53077 | 10 | 0 |
7071 | 7071 | 2020-03-21 | Yakima | Washington | 53077 | 20 | 0 |
8209 | 8209 | 2020-03-22 | Yakima | Washington | 53077 | 24 | 0 |
9434 | 9434 | 2020-03-23 | Yakima | Washington | 53077 | 25 | 0 |
10784 | 10784 | 2020-03-24 | Yakima | Washington | 53077 | 44 | 1 |
12307 | 12307 | 2020-03-25 | Yakima | Washington | 53077 | 51 | 1 |
13958 | 13958 | 2020-03-26 | Yakima | Washington | 53077 | 61 | 2 |
15727 | 15727 | 2020-03-27 | Yakima | Washington | 53077 | 72 | 2 |
17607 | 17607 | 2020-03-28 | Yakima | Washington | 53077 | 100 | 2 |
19572 | 19572 | 2020-03-29 | Yakima | Washington | 53077 | 147 | 3 |
21639 | 21639 | 2020-03-30 | Yakima | Washington | 53077 | 147 | 3 |
23788 | 23788 | 2020-03-31 | Yakima | Washington | 53077 | 147 | 3 |
26005 | 26005 | 2020-04-01 | Yakima | Washington | 53077 | 200 | 3 |
28297 | 28297 | 2020-04-02 | Yakima | Washington | 53077 | 216 | 6 |
30650 | 30650 | 2020-04-03 | Yakima | Washington | 53077 | 289 | 7 |
33051 | 33051 | 2020-04-04 | Yakima | Washington | 53077 | 289 | 7 |
35489 | 35489 | 2020-04-05 | Yakima | Washington | 53077 | 363 | 12 |
37973 | 37973 | 2020-04-06 | Yakima | Washington | 53077 | 380 | 12 |
40508 | 40508 | 2020-04-07 | Yakima | Washington | 53077 | 400 | 17 |
43077 | 43077 | 2020-04-08 | Yakima | Washington | 53077 | 400 | 18 |
45673 | 45673 | 2020-04-09 | Yakima | Washington | 53077 | 447 | 19 |
48301 | 48301 | 2020-04-10 | Yakima | Washington | 53077 | 447 | 19 |
50959 | 50959 | 2020-04-11 | Yakima | Washington | 53077 | 535 | 21 |
53634 | 53634 | 2020-04-12 | Yakima | Washington | 53077 | 535 | 21 |
56324 | 56324 | 2020-04-13 | Yakima | Washington | 53077 | 573 | 23 |
59030 | 59030 | 2020-04-14 | Yakima | Washington | 53077 | 635 | 29 |
61749 | 61749 | 2020-04-15 | Yakima | Washington | 53077 | 674 | 29 |
64482 | 64482 | 2020-04-16 | Yakima | Washington | 53077 | 707 | 29 |
67230 | 67230 | 2020-04-17 | Yakima | Washington | 53077 | 759 | 34 |
69992 | 69992 | 2020-04-18 | Yakima | Washington | 53077 | 759 | 35 |
72761 | 72761 | 2020-04-19 | Yakima | Washington | 53077 | 771 | 36 |
75537 | 75537 | 2020-04-20 | Yakima | Washington | 53077 | 868 | 38 |
78320 | 78320 | 2020-04-21 | Yakima | Washington | 53077 | 868 | 38 |
81113 | 81113 | 2020-04-22 | Yakima | Washington | 53077 | 868 | 38 |
83914 | 83914 | 2020-04-23 | Yakima | Washington | 53077 | 952 | 42 |
86721 | 86721 | 2020-04-24 | Yakima | Washington | 53077 | 952 | 43 |
89536 | 89536 | 2020-04-25 | Yakima | Washington | 53077 | 1066 | 44 |
92353 | 92353 | 2020-04-26 | Yakima | Washington | 53077 | 1085 | 45 |
95182 | 95182 | 2020-04-27 | Yakima | Washington | 53077 | 1085 | 45 |
98027 | 98027 | 2020-04-28 | Yakima | Washington | 53077 | 1135 | 48 |
100877 | 100877 | 2020-04-29 | Yakima | Washington | 53077 | 1197 | 48 |
103732 | 103732 | 2020-04-30 | Yakima | Washington | 53077 | 1237 | 49 |
106596 | 106596 | 2020-05-01 | Yakima | Washington | 53077 | 1293 | 48 |
109465 | 109465 | 2020-05-02 | Yakima | Washington | 53077 | 1293 | 48 |
112339 | 112339 | 2020-05-03 | Yakima | Washington | 53077 | 1411 | 48 |
115222 | 115222 | 2020-05-04 | Yakima | Washington | 53077 | 1411 | 48 |
118181 | 118181 | 2020-05-05 | Yakima | Washington | 53077 | 1440 | 49 |
121145 | 121145 | 2020-05-06 | Yakima | Washington | 53077 | 1597 | 52 |
124125 | 124125 | 2020-05-07 | Yakima | Washington | 53077 | 1658 | 57 |
127110 | 127110 | 2020-05-08 | Yakima | Washington | 53077 | 1756 | 58 |
130100 | 130100 | 2020-05-09 | Yakima | Washington | 53077 | 1756 | 58 |
133090 | 133090 | 2020-05-10 | Yakima | Washington | 53077 | 1781 | 59 |
136080 | 136080 | 2020-05-11 | Yakima | Washington | 53077 | 1966 | 63 |
139071 | 139071 | 2020-05-12 | Yakima | Washington | 53077 | 2025 | 67 |
142067 | 142067 | 2020-05-13 | Yakima | Washington | 53077 | 2025 | 67 |
145064 | 145064 | 2020-05-14 | Yakima | Washington | 53077 | 2186 | 73 |
148067 | 148067 | 2020-05-15 | Yakima | Washington | 53077 | 2308 | 76 |
151076 | 151076 | 2020-05-16 | Yakima | Washington | 53077 | 2349 | 76 |
154087 | 154087 | 2020-05-17 | Yakima | Washington | 53077 | 2443 | 76 |
157104 | 157104 | 2020-05-18 | Yakima | Washington | 53077 | 2517 | 77 |
160128 | 160128 | 2020-05-19 | Yakima | Washington | 53077 | 2598 | 81 |
163156 | 163156 | 2020-05-20 | Yakima | Washington | 53077 | 2637 | 81 |
166185 | 166185 | 2020-05-21 | Yakima | Washington | 53077 | 2684 | 83 |
169221 | 169221 | 2020-05-22 | Yakima | Washington | 53077 | 2775 | 83 |
172262 | 172262 | 2020-05-23 | Yakima | Washington | 53077 | 2858 | 83 |
175305 | 175305 | 2020-05-24 | Yakima | Washington | 53077 | 2965 | 84 |
178350 | 178350 | 2020-05-25 | Yakima | Washington | 53077 | 3066 | 87 |
181394 | 181394 | 2020-05-26 | Yakima | Washington | 53077 | 3123 | 91 |
184445 | 184445 | 2020-05-27 | Yakima | Washington | 53077 | 3252 | 91 |
187502 | 187502 | 2020-05-28 | Yakima | Washington | 53077 | 3380 | 93 |
190566 | 190566 | 2020-05-29 | Yakima | Washington | 53077 | 3502 | 94 |
193632 | 193632 | 2020-05-30 | Yakima | Washington | 53077 | 3615 | 95 |
196702 | 196702 | 2020-05-31 | Yakima | Washington | 53077 | 3615 | 95 |
199775 | 199775 | 2020-06-01 | Yakima | Washington | 53077 | 3891 | 95 |
202851 | 202851 | 2020-06-02 | Yakima | Washington | 53077 | 4057 | 96 |
205930 | 205930 | 2020-06-03 | Yakima | Washington | 53077 | 4057 | 97 |
209012 | 209012 | 2020-06-04 | Yakima | Washington | 53077 | 4103 | 97 |
212097 | 212097 | 2020-06-05 | Yakima | Washington | 53077 | 4392 | 99 |
215184 | 215184 | 2020-06-06 | Yakima | Washington | 53077 | 4539 | 100 |
218274 | 218274 | 2020-06-07 | Yakima | Washington | 53077 | 4714 | 100 |
221366 | 221366 | 2020-06-08 | Yakima | Washington | 53077 | 4929 | 101 |
224462 | 224462 | 2020-06-09 | Yakima | Washington | 53077 | 5009 | 104 |
227562 | 227562 | 2020-06-10 | Yakima | Washington | 53077 | 5009 | 104 |
230666 | 230666 | 2020-06-11 | Yakima | Washington | 53077 | 5092 | 112 |
233771 | 233771 | 2020-06-12 | Yakima | Washington | 53077 | 5259 | 114 |
236878 | 236878 | 2020-06-13 | Yakima | Washington | 53077 | 5504 | 117 |
239986 | 239986 | 2020-06-14 | Yakima | Washington | 53077 | 5611 | 120 |
243097 | 243097 | 2020-06-15 | Yakima | Washington | 53077 | 5727 | 121 |
246210 | 246210 | 2020-06-16 | Yakima | Washington | 53077 | 5830 | 124 |
249322 | 249322 | 2020-06-17 | Yakima | Washington | 53077 | 5939 | 122 |
252437 | 252437 | 2020-06-18 | Yakima | Washington | 53077 | 6062 | 128 |
255556 | 255556 | 2020-06-19 | Yakima | Washington | 53077 | 6062 | 131 |
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);