ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 53035 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 185 ✖
- 2 90
- 0 23
- 1 21
- 12 19
- 123 17
- 112 16
- 338 14
- 23 13
- 31 13
- 84 13
- 117 13
- 8 11
- 237 11
- 334 11
- 264 10
- 265 10
- 263 9
- 10 8
- 15 8
- 24 8
- 33 8
- 333 8
- 5 7
- 89 7
- 114 7
- 244 7
- 321 7
- 335 7
- 3 6
- 9 6
- 32 6
- 40 6
- 52 6
- 88 6
- 91 6
- 95 6
- 103 6
- 105 6
- 116 6
- 124 6
- 262 6
- 4 5
- 14 5
- 17 5
- 83 5
- 102 5
- 107 5
- 113 5
- 119 5
- 125 5
- 247 5
- 253 5
- 269 5
- 307 5
- 337 5
- 20 4
- 27 4
- 30 4
- 35 4
- 49 4
- 60 4
- 75 4
- 97 4
- 111 4
- 122 4
- 138 4
- 215 4
- 323 4
- 13 3
- 22 3
- 29 3
- 67 3
- 85 3
- 87 3
- 126 3
- 129 3
- 132 3
- 149 3
- 162 3
- 180 3
- 199 3
- 204 3
- 228 3
- 238 3
- 240 3
- 255 3
- 280 3
- 289 3
- 303 3
- 318 3
- 327 3
- 330 3
- 6 2
- 34 2
- 36 2
- 54 2
- 68 2
- 86 2
- 90 2
- 98 2
- 101 2
- 104 2
- 108 2
- 110 2
- 115 2
- 118 2
- 130 2
- 131 2
- 135 2
- 156 2
- 200 2
- 205 2
- 246 2
- 250 2
- 275 2
- 281 2
- 282 2
- 294 2
- 298 2
- 305 2
- 309 2
- 310 2
- 326 2
- 328 2
- 332 2
- 336 2
- 340 2
- 343 2
- 18 1
- 19 1
- 28 1
- 39 1
- 42 1
- 46 1
- 47 1
- 51 1
- 58 1
- 62 1
- 64 1
- 66 1
- 71 1
- 72 1
- 76 1
- 78 1
- 79 1
- 92 1
- 94 1
- 120 1
- 121 1
- 127 1
- 133 1
- 137 1
- 141 1
- 143 1
- 144 1
- 153 1
- 159 1
- 167 1
- 169 1
- 172 1
- 176 1
- 181 1
- 184 1
- 188 1
- 195 1
- 202 1
- 203 1
- 206 1
- 209 1
- 224 1
- 225 1
- 227 1
- 231 1
- 233 1
- 234 1
- 236 1
- 248 1
- 251 1
- 252 1
- 254 1
- 257 1
- 258 1
- 266 1
- 267 1
- 344 1
state 1
- Washington 797
fips 1
- 53035 · 797 ✖
county 1
- Kitsap 797
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
857 | 857 | 2020-03-08 | Kitsap | Washington | 53035 | 1 | 0 |
988 | 988 | 2020-03-09 | Kitsap | Washington | 53035 | 1 | 0 |
1151 | 1151 | 2020-03-10 | Kitsap | Washington | 53035 | 2 | 0 |
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 |
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 |
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 |
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 |
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);