ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Kitsap" and state = "Washington" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1351 | 1351 | 2020-03-11 | Kitsap | Washington | 53035 | 2 | 0 |
1605 | 1605 | 2020-03-12 | Kitsap | Washington | 53035 | 2 | 0 |
1916 | 1916 | 2020-03-13 | Kitsap | Washington | 53035 | 3 | 0 |
2289 | 2289 | 2020-03-14 | Kitsap | Washington | 53035 | 3 | 0 |
2716 | 2716 | 2020-03-15 | Kitsap | Washington | 53035 | 5 | 0 |
3190 | 3190 | 2020-03-16 | Kitsap | Washington | 53035 | 7 | 0 |
3731 | 3731 | 2020-03-17 | Kitsap | Washington | 53035 | 7 | 0 |
4366 | 4366 | 2020-03-18 | Kitsap | Washington | 53035 | 9 | 0 |
5123 | 5123 | 2020-03-19 | Kitsap | Washington | 53035 | 12 | 0 |
6025 | 6025 | 2020-03-20 | Kitsap | Washington | 53035 | 12 | 0 |
7056 | 7056 | 2020-03-21 | Kitsap | Washington | 53035 | 15 | 0 |
8193 | 8193 | 2020-03-22 | Kitsap | Washington | 53035 | 20 | 0 |
9418 | 9418 | 2020-03-23 | Kitsap | Washington | 53035 | 20 | 0 |
10767 | 10767 | 2020-03-24 | Kitsap | Washington | 53035 | 20 | 0 |
12290 | 12290 | 2020-03-25 | Kitsap | Washington | 53035 | 27 | 0 |
13940 | 13940 | 2020-03-26 | Kitsap | Washington | 53035 | 33 | 0 |
28277 | 28277 | 2020-04-02 | Kitsap | Washington | 53035 | 85 | 0 |
30630 | 30630 | 2020-04-03 | Kitsap | Washington | 53035 | 95 | 0 |
33030 | 33030 | 2020-04-04 | Kitsap | Washington | 53035 | 95 | 0 |
35468 | 35468 | 2020-04-05 | Kitsap | Washington | 53035 | 102 | 0 |
15708 | 15708 | 2020-03-27 | Kitsap | Washington | 53035 | 42 | 1 |
17588 | 17588 | 2020-03-28 | Kitsap | Washington | 53035 | 49 | 1 |
19553 | 19553 | 2020-03-29 | Kitsap | Washington | 53035 | 56 | 1 |
21620 | 21620 | 2020-03-30 | Kitsap | Washington | 53035 | 63 | 1 |
23769 | 23769 | 2020-03-31 | Kitsap | Washington | 53035 | 63 | 1 |
25987 | 25987 | 2020-04-01 | Kitsap | Washington | 53035 | 74 | 1 |
37952 | 37952 | 2020-04-06 | Kitsap | Washington | 53035 | 111 | 1 |
40487 | 40487 | 2020-04-07 | Kitsap | Washington | 53035 | 119 | 1 |
43056 | 43056 | 2020-04-08 | Kitsap | Washington | 53035 | 119 | 1 |
45652 | 45652 | 2020-04-09 | Kitsap | Washington | 53035 | 123 | 1 |
48279 | 48279 | 2020-04-10 | Kitsap | Washington | 53035 | 128 | 1 |
50937 | 50937 | 2020-04-11 | Kitsap | Washington | 53035 | 132 | 1 |
53612 | 53612 | 2020-04-12 | Kitsap | Washington | 53035 | 132 | 1 |
56302 | 56302 | 2020-04-13 | Kitsap | Washington | 53035 | 132 | 1 |
59008 | 59008 | 2020-04-14 | Kitsap | Washington | 53035 | 132 | 1 |
61727 | 61727 | 2020-04-15 | Kitsap | Washington | 53035 | 132 | 1 |
64460 | 64460 | 2020-04-16 | Kitsap | Washington | 53035 | 132 | 1 |
67208 | 67208 | 2020-04-17 | Kitsap | Washington | 53035 | 135 | 1 |
69970 | 69970 | 2020-04-18 | Kitsap | Washington | 53035 | 136 | 1 |
72740 | 72740 | 2020-04-19 | Kitsap | Washington | 53035 | 138 | 1 |
75516 | 75516 | 2020-04-20 | Kitsap | Washington | 53035 | 139 | 1 |
78299 | 78299 | 2020-04-21 | Kitsap | Washington | 53035 | 140 | 2 |
81092 | 81092 | 2020-04-22 | Kitsap | Washington | 53035 | 140 | 2 |
83893 | 83893 | 2020-04-23 | Kitsap | Washington | 53035 | 144 | 2 |
86700 | 86700 | 2020-04-24 | Kitsap | Washington | 53035 | 144 | 2 |
89515 | 89515 | 2020-04-25 | Kitsap | Washington | 53035 | 146 | 2 |
92332 | 92332 | 2020-04-26 | Kitsap | Washington | 53035 | 146 | 2 |
95161 | 95161 | 2020-04-27 | Kitsap | Washington | 53035 | 148 | 2 |
98006 | 98006 | 2020-04-28 | Kitsap | Washington | 53035 | 148 | 2 |
100856 | 100856 | 2020-04-29 | Kitsap | Washington | 53035 | 148 | 2 |
103711 | 103711 | 2020-04-30 | Kitsap | Washington | 53035 | 151 | 2 |
106575 | 106575 | 2020-05-01 | Kitsap | Washington | 53035 | 152 | 2 |
109444 | 109444 | 2020-05-02 | Kitsap | Washington | 53035 | 152 | 2 |
112318 | 112318 | 2020-05-03 | Kitsap | Washington | 53035 | 152 | 2 |
115201 | 115201 | 2020-05-04 | Kitsap | Washington | 53035 | 152 | 2 |
118160 | 118160 | 2020-05-05 | Kitsap | Washington | 53035 | 152 | 2 |
121124 | 121124 | 2020-05-06 | Kitsap | Washington | 53035 | 152 | 2 |
124104 | 124104 | 2020-05-07 | Kitsap | Washington | 53035 | 154 | 2 |
127089 | 127089 | 2020-05-08 | Kitsap | Washington | 53035 | 154 | 2 |
130079 | 130079 | 2020-05-09 | Kitsap | Washington | 53035 | 155 | 2 |
133069 | 133069 | 2020-05-10 | Kitsap | Washington | 53035 | 155 | 2 |
136059 | 136059 | 2020-05-11 | Kitsap | Washington | 53035 | 156 | 2 |
139050 | 139050 | 2020-05-12 | Kitsap | Washington | 53035 | 156 | 2 |
142046 | 142046 | 2020-05-13 | Kitsap | Washington | 53035 | 157 | 2 |
145043 | 145043 | 2020-05-14 | Kitsap | Washington | 53035 | 157 | 2 |
148046 | 148046 | 2020-05-15 | Kitsap | Washington | 53035 | 157 | 2 |
151055 | 151055 | 2020-05-16 | Kitsap | Washington | 53035 | 159 | 2 |
154066 | 154066 | 2020-05-17 | Kitsap | Washington | 53035 | 159 | 2 |
157083 | 157083 | 2020-05-18 | Kitsap | Washington | 53035 | 160 | 2 |
160107 | 160107 | 2020-05-19 | Kitsap | Washington | 53035 | 161 | 2 |
163135 | 163135 | 2020-05-20 | Kitsap | Washington | 53035 | 161 | 2 |
166164 | 166164 | 2020-05-21 | Kitsap | Washington | 53035 | 161 | 2 |
169200 | 169200 | 2020-05-22 | Kitsap | Washington | 53035 | 160 | 2 |
172241 | 172241 | 2020-05-23 | Kitsap | Washington | 53035 | 161 | 2 |
175284 | 175284 | 2020-05-24 | Kitsap | Washington | 53035 | 161 | 2 |
178329 | 178329 | 2020-05-25 | Kitsap | Washington | 53035 | 161 | 2 |
181373 | 181373 | 2020-05-26 | Kitsap | Washington | 53035 | 161 | 2 |
184424 | 184424 | 2020-05-27 | Kitsap | Washington | 53035 | 161 | 2 |
187481 | 187481 | 2020-05-28 | Kitsap | Washington | 53035 | 161 | 2 |
190545 | 190545 | 2020-05-29 | Kitsap | Washington | 53035 | 161 | 2 |
193611 | 193611 | 2020-05-30 | Kitsap | Washington | 53035 | 161 | 2 |
196681 | 196681 | 2020-05-31 | Kitsap | Washington | 53035 | 161 | 2 |
199754 | 199754 | 2020-06-01 | Kitsap | Washington | 53035 | 162 | 2 |
202830 | 202830 | 2020-06-02 | Kitsap | Washington | 53035 | 162 | 2 |
205909 | 205909 | 2020-06-03 | Kitsap | Washington | 53035 | 163 | 2 |
208991 | 208991 | 2020-06-04 | Kitsap | Washington | 53035 | 163 | 2 |
212076 | 212076 | 2020-06-05 | Kitsap | Washington | 53035 | 164 | 2 |
215163 | 215163 | 2020-06-06 | Kitsap | Washington | 53035 | 165 | 2 |
218253 | 218253 | 2020-06-07 | Kitsap | Washington | 53035 | 165 | 2 |
221345 | 221345 | 2020-06-08 | Kitsap | Washington | 53035 | 165 | 2 |
224441 | 224441 | 2020-06-09 | Kitsap | Washington | 53035 | 170 | 2 |
227541 | 227541 | 2020-06-10 | Kitsap | Washington | 53035 | 172 | 2 |
230645 | 230645 | 2020-06-11 | Kitsap | Washington | 53035 | 172 | 2 |
233750 | 233750 | 2020-06-12 | Kitsap | Washington | 53035 | 173 | 2 |
236857 | 236857 | 2020-06-13 | Kitsap | Washington | 53035 | 176 | 2 |
239965 | 239965 | 2020-06-14 | Kitsap | Washington | 53035 | 176 | 2 |
243076 | 243076 | 2020-06-15 | Kitsap | Washington | 53035 | 178 | 2 |
246189 | 246189 | 2020-06-16 | Kitsap | Washington | 53035 | 178 | 2 |
249301 | 249301 | 2020-06-17 | Kitsap | Washington | 53035 | 180 | 2 |
252416 | 252416 | 2020-06-18 | Kitsap | Washington | 53035 | 182 | 2 |
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);