ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,113 rows where county = "Wilson" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 306 ✖
- 0 211
- 16 100
- 5 87
- 28 68
- 34 62
- 157 58
- 4 57
- 181 56
- 12 54
- 69 54
- 2 51
- 43 48
- 33 45
- 26 43
- 68 43
- 35 41
- 36 38
- 8 37
- 243 36
- 141 35
- 303 34
- 29 32
- 1 30
- 24 30
- 14 29
- 10 28
- 19 28
- 155 28
- 236 28
- 244 28
- 3 26
- 20 25
- 66 25
- 250 21
- 38 20
- 55 20
- 7 19
- 9 19
- 72 19
- 152 19
- 240 18
- 17 17
- 31 17
- 74 17
- 142 17
- 484 17
- 6 16
- 23 16
- 40 16
- 42 16
- 123 16
- 151 16
- 232 15
- 18 14
- 70 14
- 144 14
- 179 14
- 49 13
- 103 13
- 173 13
- 260 13
- 15 12
- 41 12
- 62 12
- 143 12
- 158 12
- 163 12
- 201 12
- 30 11
- 44 11
- 52 11
- 64 11
- 145 11
- 210 11
- 214 11
- 302 11
- 316 11
- 63 10
- 304 10
- 25 9
- 89 9
- 186 9
- 193 9
- 223 9
- 239 9
- 13 8
- 39 8
- 47 8
- 65 8
- 77 8
- 147 8
- 167 8
- 177 8
- 189 8
- 261 8
- 408 8
- 53 7
- 133 7
- 139 7
- 150 7
- 212 7
- 219 7
- 233 7
- 248 7
- 292 7
- 296 7
- 301 7
- 340 7
- 414 7
- 423 7
- 434 7
- 444 7
- 449 7
- 452 7
- 459 7
- 464 7
- 465 7
- 471 7
- 475 7
- 476 7
- 478 7
- 482 7
- 483 7
- 11 6
- 22 6
- 27 6
- 46 6
- 57 6
- 60 6
- 109 6
- 119 6
- 126 6
- 188 6
- 205 6
- 211 6
- 299 6
- 338 6
- 343 6
- 21 5
- 45 5
- 58 5
- 76 5
- 78 5
- 79 5
- 82 5
- 85 5
- 94 5
- 102 5
- 118 5
- 137 5
- 149 5
- 218 5
- 220 5
- 226 5
- 230 5
- 252 5
- 268 5
- 278 5
- 279 5
- 334 5
- 337 5
- 347 5
- 352 5
- 404 5
- 37 4
- 56 4
- 67 4
- 99 4
- 100 4
- 128 4
- 129 4
- 130 4
- 136 4
- 140 4
- 154 4
- 171 4
- 202 4
- 206 4
- 222 4
- 224 4
- 231 4
- 241 4
- 251 4
- 253 4
- 257 4
- 266 4
- 289 4
- 312 4
- 318 4
- 323 4
- 326 4
- 360 4
- 399 4
- 32 3
- 59 3
- 61 3
- 71 3
- 73 3
- 81 3
- 84 3
- 86 3
- 106 3
- 113 3
- 122 3
- 164 3
- 178 3
- 182 3
- 184 3
- 191 3
- 229 3
- 234 3
- 264 3
- 325 3
- 354 3
- 357 3
- 359 3
- 50 2
- 51 2
- 54 2
- 88 2
- 93 2
- 95 2
- 104 2
- 107 2
- 110 2
- 111 2
- 115 2
- 121 2
- 132 2
- 146 2
- 148 2
- 156 2
- 169 2
- 172 2
- 175 2
- 197 2
- 208 2
- 238 2
- 259 2
- 262 2
- 272 2
- 300 2
- 309 2
- 336 2
- 350 2
- 364 2
- 48 1
- 75 1
- 80 1
- 83 1
- 90 1
- 91 1
- 97 1
- 98 1
- 101 1
- 105 1
- 108 1
- 112 1
- 114 1
- 116 1
- 120 1
- 124 1
- 125 1
- 127 1
- 134 1
- 135 1
- 138 1
- 153 1
- 159 1
- 160 1
- 161 1
- 162 1
- 170 1
- 180 1
- 185 1
- 194 1
- 204 1
- 209 1
- 213 1
- 216 1
- 225 1
- 235 1
- 254 1
- 255 1
- 256 1
- 273 1
- 275 1
- 285 1
- 287 1
- 290 1
- 294 1
- 317 1
- 319 1
- 320 1
- 322 1
- 324 1
- 329 1
- 332 1
- 335 1
- 341 1
- 344 1
- 351 1
- 365 1
- 402 1
- 403 1
- 407 1
state 4
- North Carolina 790
- Tennessee 786
- Texas 780
- Kansas 757
county 1
- Wilson · 3,113 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
65504 | 65504 | 2020-04-17 | Wilson | Kansas | 20205 | 1 | 0 |
68253 | 68253 | 2020-04-18 | Wilson | Kansas | 20205 | 1 | 0 |
71014 | 71014 | 2020-04-19 | Wilson | Kansas | 20205 | 1 | 0 |
73786 | 73786 | 2020-04-20 | Wilson | Kansas | 20205 | 1 | 0 |
76566 | 76566 | 2020-04-21 | Wilson | Kansas | 20205 | 1 | 0 |
79351 | 79351 | 2020-04-22 | Wilson | Kansas | 20205 | 1 | 0 |
82147 | 82147 | 2020-04-23 | Wilson | Kansas | 20205 | 1 | 0 |
84950 | 84950 | 2020-04-24 | Wilson | Kansas | 20205 | 1 | 0 |
87759 | 87759 | 2020-04-25 | Wilson | Kansas | 20205 | 1 | 0 |
90575 | 90575 | 2020-04-26 | Wilson | Kansas | 20205 | 1 | 0 |
93396 | 93396 | 2020-04-27 | Wilson | Kansas | 20205 | 1 | 0 |
96229 | 96229 | 2020-04-28 | Wilson | Kansas | 20205 | 1 | 0 |
99075 | 99075 | 2020-04-29 | Wilson | Kansas | 20205 | 1 | 0 |
101927 | 101927 | 2020-04-30 | Wilson | Kansas | 20205 | 1 | 0 |
104788 | 104788 | 2020-05-01 | Wilson | Kansas | 20205 | 1 | 0 |
107653 | 107653 | 2020-05-02 | Wilson | Kansas | 20205 | 1 | 0 |
110524 | 110524 | 2020-05-03 | Wilson | Kansas | 20205 | 1 | 0 |
113401 | 113401 | 2020-05-04 | Wilson | Kansas | 20205 | 1 | 0 |
116283 | 116283 | 2020-05-05 | Wilson | Kansas | 20205 | 1 | 0 |
119244 | 119244 | 2020-05-06 | Wilson | Kansas | 20205 | 1 | 0 |
122214 | 122214 | 2020-05-07 | Wilson | Kansas | 20205 | 1 | 0 |
125196 | 125196 | 2020-05-08 | Wilson | Kansas | 20205 | 1 | 0 |
128184 | 128184 | 2020-05-09 | Wilson | Kansas | 20205 | 1 | 0 |
131174 | 131174 | 2020-05-10 | Wilson | Kansas | 20205 | 1 | 0 |
134165 | 134165 | 2020-05-11 | Wilson | Kansas | 20205 | 1 | 0 |
137155 | 137155 | 2020-05-12 | Wilson | Kansas | 20205 | 1 | 0 |
140148 | 140148 | 2020-05-13 | Wilson | Kansas | 20205 | 1 | 0 |
143144 | 143144 | 2020-05-14 | Wilson | Kansas | 20205 | 1 | 0 |
146144 | 146144 | 2020-05-15 | Wilson | Kansas | 20205 | 1 | 0 |
149148 | 149148 | 2020-05-16 | Wilson | Kansas | 20205 | 1 | 0 |
152159 | 152159 | 2020-05-17 | Wilson | Kansas | 20205 | 1 | 0 |
155172 | 155172 | 2020-05-18 | Wilson | Kansas | 20205 | 1 | 0 |
158189 | 158189 | 2020-05-19 | Wilson | Kansas | 20205 | 1 | 0 |
161214 | 161214 | 2020-05-20 | Wilson | Kansas | 20205 | 1 | 0 |
164243 | 164243 | 2020-05-21 | Wilson | Kansas | 20205 | 1 | 0 |
167279 | 167279 | 2020-05-22 | Wilson | Kansas | 20205 | 1 | 0 |
170317 | 170317 | 2020-05-23 | Wilson | Kansas | 20205 | 1 | 0 |
173358 | 173358 | 2020-05-24 | Wilson | Kansas | 20205 | 1 | 0 |
176402 | 176402 | 2020-05-25 | Wilson | Kansas | 20205 | 1 | 0 |
179446 | 179446 | 2020-05-26 | Wilson | Kansas | 20205 | 1 | 0 |
182491 | 182491 | 2020-05-27 | Wilson | Kansas | 20205 | 1 | 0 |
185545 | 185545 | 2020-05-28 | Wilson | Kansas | 20205 | 1 | 0 |
188603 | 188603 | 2020-05-29 | Wilson | Kansas | 20205 | 1 | 0 |
191667 | 191667 | 2020-05-30 | Wilson | Kansas | 20205 | 1 | 0 |
194735 | 194735 | 2020-05-31 | Wilson | Kansas | 20205 | 1 | 0 |
197806 | 197806 | 2020-06-01 | Wilson | Kansas | 20205 | 1 | 0 |
200877 | 200877 | 2020-06-02 | Wilson | Kansas | 20205 | 1 | 0 |
203954 | 203954 | 2020-06-03 | Wilson | Kansas | 20205 | 1 | 0 |
207035 | 207035 | 2020-06-04 | Wilson | Kansas | 20205 | 1 | 0 |
210116 | 210116 | 2020-06-05 | Wilson | Kansas | 20205 | 1 | 0 |
213201 | 213201 | 2020-06-06 | Wilson | Kansas | 20205 | 1 | 0 |
216288 | 216288 | 2020-06-07 | Wilson | Kansas | 20205 | 1 | 0 |
219380 | 219380 | 2020-06-08 | Wilson | Kansas | 20205 | 1 | 0 |
222475 | 222475 | 2020-06-09 | Wilson | Kansas | 20205 | 1 | 0 |
225571 | 225571 | 2020-06-10 | Wilson | Kansas | 20205 | 1 | 0 |
228673 | 228673 | 2020-06-11 | Wilson | Kansas | 20205 | 1 | 0 |
231777 | 231777 | 2020-06-12 | Wilson | Kansas | 20205 | 1 | 0 |
234882 | 234882 | 2020-06-13 | Wilson | Kansas | 20205 | 1 | 0 |
237989 | 237989 | 2020-06-14 | Wilson | Kansas | 20205 | 1 | 0 |
241098 | 241098 | 2020-06-15 | Wilson | Kansas | 20205 | 1 | 0 |
244209 | 244209 | 2020-06-16 | Wilson | Kansas | 20205 | 1 | 0 |
247322 | 247322 | 2020-06-17 | Wilson | Kansas | 20205 | 1 | 0 |
250434 | 250434 | 2020-06-18 | Wilson | Kansas | 20205 | 1 | 0 |
253549 | 253549 | 2020-06-19 | Wilson | Kansas | 20205 | 1 | 0 |
256669 | 256669 | 2020-06-20 | Wilson | Kansas | 20205 | 1 | 0 |
259795 | 259795 | 2020-06-21 | Wilson | Kansas | 20205 | 1 | 0 |
262924 | 262924 | 2020-06-22 | Wilson | Kansas | 20205 | 1 | 0 |
266051 | 266051 | 2020-06-23 | Wilson | Kansas | 20205 | 1 | 0 |
269184 | 269184 | 2020-06-24 | Wilson | Kansas | 20205 | 1 | 0 |
272320 | 272320 | 2020-06-25 | Wilson | Kansas | 20205 | 1 | 0 |
275463 | 275463 | 2020-06-26 | Wilson | Kansas | 20205 | 1 | 0 |
278611 | 278611 | 2020-06-27 | Wilson | Kansas | 20205 | 1 | 0 |
281759 | 281759 | 2020-06-28 | Wilson | Kansas | 20205 | 1 | 0 |
284905 | 284905 | 2020-06-29 | Wilson | Kansas | 20205 | 1 | 0 |
288054 | 288054 | 2020-06-30 | Wilson | Kansas | 20205 | 1 | 0 |
291204 | 291204 | 2020-07-01 | Wilson | Kansas | 20205 | 2 | 0 |
294358 | 294358 | 2020-07-02 | Wilson | Kansas | 20205 | 2 | 0 |
297516 | 297516 | 2020-07-03 | Wilson | Kansas | 20205 | 3 | 0 |
300678 | 300678 | 2020-07-04 | Wilson | Kansas | 20205 | 3 | 0 |
303842 | 303842 | 2020-07-05 | Wilson | Kansas | 20205 | 3 | 0 |
307009 | 307009 | 2020-07-06 | Wilson | Kansas | 20205 | 4 | 0 |
310177 | 310177 | 2020-07-07 | Wilson | Kansas | 20205 | 4 | 0 |
313347 | 313347 | 2020-07-08 | Wilson | Kansas | 20205 | 4 | 0 |
316521 | 316521 | 2020-07-09 | Wilson | Kansas | 20205 | 4 | 0 |
319696 | 319696 | 2020-07-10 | Wilson | Kansas | 20205 | 4 | 0 |
322875 | 322875 | 2020-07-11 | Wilson | Kansas | 20205 | 4 | 0 |
326058 | 326058 | 2020-07-12 | Wilson | Kansas | 20205 | 4 | 0 |
329244 | 329244 | 2020-07-13 | Wilson | Kansas | 20205 | 4 | 0 |
332431 | 332431 | 2020-07-14 | Wilson | Kansas | 20205 | 4 | 0 |
335624 | 335624 | 2020-07-15 | Wilson | Kansas | 20205 | 4 | 0 |
338820 | 338820 | 2020-07-16 | Wilson | Kansas | 20205 | 4 | 0 |
342016 | 342016 | 2020-07-17 | Wilson | Kansas | 20205 | 5 | 0 |
345216 | 345216 | 2020-07-18 | Wilson | Kansas | 20205 | 5 | 0 |
348417 | 348417 | 2020-07-19 | Wilson | Kansas | 20205 | 5 | 0 |
351617 | 351617 | 2020-07-20 | Wilson | Kansas | 20205 | 7 | 0 |
354819 | 354819 | 2020-07-21 | Wilson | Kansas | 20205 | 7 | 0 |
358022 | 358022 | 2020-07-22 | Wilson | Kansas | 20205 | 7 | 0 |
361227 | 361227 | 2020-07-23 | Wilson | Kansas | 20205 | 7 | 0 |
364434 | 364434 | 2020-07-24 | Wilson | Kansas | 20205 | 7 | 0 |
367641 | 367641 | 2020-07-25 | Wilson | Kansas | 20205 | 7 | 0 |
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);