ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Iredell" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 188 ✖
- 5 50
- 236 40
- 34 34
- 0 22
- 445 21
- 7 18
- 17 18
- 203 16
- 217 14
- 237 14
- 24 13
- 208 13
- 206 12
- 2 10
- 331 10
- 10 9
- 205 9
- 446 9
- 18 8
- 61 8
- 16 7
- 27 7
- 33 7
- 238 7
- 336 7
- 443 7
- 465 7
- 1 6
- 141 6
- 219 6
- 338 6
- 342 6
- 348 6
- 444 6
- 25 5
- 32 5
- 102 5
- 173 5
- 196 5
- 197 5
- 240 5
- 254 5
- 324 5
- 326 5
- 334 5
- 435 5
- 440 5
- 441 5
- 3 4
- 11 4
- 35 4
- 50 4
- 88 4
- 202 4
- 222 4
- 245 4
- 320 4
- 330 4
- 374 4
- 416 4
- 6 3
- 39 3
- 45 3
- 51 3
- 58 3
- 64 3
- 69 3
- 101 3
- 104 3
- 132 3
- 169 3
- 177 3
- 185 3
- 190 3
- 194 3
- 198 3
- 204 3
- 225 3
- 227 3
- 265 3
- 276 3
- 289 3
- 300 3
- 310 3
- 314 3
- 329 3
- 362 3
- 376 3
- 377 3
- 383 3
- 396 3
- 411 3
- 414 3
- 429 3
- 438 3
- 466 3
- 15 2
- 26 2
- 42 2
- 44 2
- 47 2
- 56 2
- 110 2
- 123 2
- 148 2
- 157 2
- 164 2
- 242 2
- 259 2
- 286 2
- 293 2
- 294 2
- 304 2
- 311 2
- 321 2
- 327 2
- 328 2
- 332 2
- 335 2
- 358 2
- 366 2
- 380 2
- 382 2
- 391 2
- 408 2
- 420 2
- 433 2
- 9 1
- 13 1
- 19 1
- 20 1
- 30 1
- 52 1
- 54 1
- 62 1
- 118 1
- 128 1
- 131 1
- 133 1
- 140 1
- 145 1
- 159 1
- 163 1
- 166 1
- 171 1
- 175 1
- 183 1
- 186 1
- 187 1
- 191 1
- 192 1
- 199 1
- 207 1
- 216 1
- 228 1
- 239 1
- 246 1
- 248 1
- 252 1
- 263 1
- 268 1
- 271 1
- 272 1
- 274 1
- 279 1
- 282 1
- 305 1
- 308 1
- 312 1
- 313 1
- 317 1
- 318 1
- 319 1
- 322 1
- 323 1
- 333 1
- 346 1
- 361 1
- 370 1
- 371 1
- 389 1
- 393 1
- 404 1
- 405 1
- 425 1
- 427 1
- 439 1
- 442 1
state 1
- North Carolina 788
fips 1
- 37097 788
county 1
- Iredell · 788 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3573 | 3573 | 2020-03-17 | Iredell | North Carolina | 37097 | 1 | 0 |
4179 | 4179 | 2020-03-18 | Iredell | North Carolina | 37097 | 1 | 0 |
4910 | 4910 | 2020-03-19 | Iredell | North Carolina | 37097 | 2 | 0 |
5764 | 5764 | 2020-03-20 | Iredell | North Carolina | 37097 | 2 | 0 |
6761 | 6761 | 2020-03-21 | Iredell | North Carolina | 37097 | 2 | 0 |
7862 | 7862 | 2020-03-22 | Iredell | North Carolina | 37097 | 6 | 0 |
9063 | 9063 | 2020-03-23 | Iredell | North Carolina | 37097 | 6 | 0 |
10371 | 10371 | 2020-03-24 | Iredell | North Carolina | 37097 | 9 | 0 |
11813 | 11813 | 2020-03-25 | Iredell | North Carolina | 37097 | 11 | 0 |
13417 | 13417 | 2020-03-26 | Iredell | North Carolina | 37097 | 13 | 0 |
15152 | 15152 | 2020-03-27 | Iredell | North Carolina | 37097 | 15 | 0 |
16984 | 16984 | 2020-03-28 | Iredell | North Carolina | 37097 | 18 | 0 |
18915 | 18915 | 2020-03-29 | Iredell | North Carolina | 37097 | 21 | 0 |
20955 | 20955 | 2020-03-30 | Iredell | North Carolina | 37097 | 25 | 0 |
23081 | 23081 | 2020-03-31 | Iredell | North Carolina | 37097 | 25 | 0 |
25275 | 25275 | 2020-04-01 | Iredell | North Carolina | 37097 | 25 | 0 |
27538 | 27538 | 2020-04-02 | Iredell | North Carolina | 37097 | 31 | 0 |
29865 | 29865 | 2020-04-03 | Iredell | North Carolina | 37097 | 36 | 0 |
32252 | 32252 | 2020-04-04 | Iredell | North Carolina | 37097 | 42 | 0 |
34683 | 34683 | 2020-04-05 | Iredell | North Carolina | 37097 | 44 | 0 |
37152 | 37152 | 2020-04-06 | Iredell | North Carolina | 37097 | 49 | 0 |
39667 | 39667 | 2020-04-07 | Iredell | North Carolina | 37097 | 54 | 0 |
42224 | 42224 | 2020-04-08 | Iredell | North Carolina | 37097 | 57 | 1 |
44807 | 44807 | 2020-04-09 | Iredell | North Carolina | 37097 | 60 | 1 |
47420 | 47420 | 2020-04-10 | Iredell | North Carolina | 37097 | 63 | 1 |
50075 | 50075 | 2020-04-11 | Iredell | North Carolina | 37097 | 71 | 1 |
52748 | 52748 | 2020-04-12 | Iredell | North Carolina | 37097 | 70 | 1 |
55431 | 55431 | 2020-04-13 | Iredell | North Carolina | 37097 | 70 | 1 |
58131 | 58131 | 2020-04-14 | Iredell | North Carolina | 37097 | 71 | 2 |
60845 | 60845 | 2020-04-15 | Iredell | North Carolina | 37097 | 70 | 2 |
63571 | 63571 | 2020-04-16 | Iredell | North Carolina | 37097 | 70 | 2 |
66314 | 66314 | 2020-04-17 | Iredell | North Carolina | 37097 | 75 | 2 |
69071 | 69071 | 2020-04-18 | Iredell | North Carolina | 37097 | 79 | 2 |
71837 | 71837 | 2020-04-19 | Iredell | North Carolina | 37097 | 80 | 2 |
74612 | 74612 | 2020-04-20 | Iredell | North Carolina | 37097 | 82 | 2 |
77393 | 77393 | 2020-04-21 | Iredell | North Carolina | 37097 | 86 | 2 |
80182 | 80182 | 2020-04-22 | Iredell | North Carolina | 37097 | 89 | 2 |
82981 | 82981 | 2020-04-23 | Iredell | North Carolina | 37097 | 90 | 2 |
85785 | 85785 | 2020-04-24 | Iredell | North Carolina | 37097 | 93 | 3 |
88597 | 88597 | 2020-04-25 | Iredell | North Carolina | 37097 | 97 | 3 |
91412 | 91412 | 2020-04-26 | Iredell | North Carolina | 37097 | 97 | 3 |
94238 | 94238 | 2020-04-27 | Iredell | North Carolina | 37097 | 97 | 3 |
97075 | 97075 | 2020-04-28 | Iredell | North Carolina | 37097 | 102 | 5 |
99923 | 99923 | 2020-04-29 | Iredell | North Carolina | 37097 | 105 | 5 |
102776 | 102776 | 2020-04-30 | Iredell | North Carolina | 37097 | 111 | 5 |
105638 | 105638 | 2020-05-01 | Iredell | North Carolina | 37097 | 112 | 5 |
108505 | 108505 | 2020-05-02 | Iredell | North Carolina | 37097 | 119 | 5 |
111378 | 111378 | 2020-05-03 | Iredell | North Carolina | 37097 | 119 | 5 |
114259 | 114259 | 2020-05-04 | Iredell | North Carolina | 37097 | 120 | 5 |
117139 | 117139 | 2020-05-05 | Iredell | North Carolina | 37097 | 128 | 5 |
120100 | 120100 | 2020-05-06 | Iredell | North Carolina | 37097 | 136 | 5 |
123075 | 123075 | 2020-05-07 | Iredell | North Carolina | 37097 | 137 | 5 |
126058 | 126058 | 2020-05-08 | Iredell | North Carolina | 37097 | 141 | 5 |
129047 | 129047 | 2020-05-09 | Iredell | North Carolina | 37097 | 147 | 5 |
132036 | 132036 | 2020-05-10 | Iredell | North Carolina | 37097 | 151 | 5 |
135027 | 135027 | 2020-05-11 | Iredell | North Carolina | 37097 | 153 | 5 |
138017 | 138017 | 2020-05-12 | Iredell | North Carolina | 37097 | 158 | 5 |
141013 | 141013 | 2020-05-13 | Iredell | North Carolina | 37097 | 162 | 5 |
144008 | 144008 | 2020-05-14 | Iredell | North Carolina | 37097 | 166 | 5 |
147009 | 147009 | 2020-05-15 | Iredell | North Carolina | 37097 | 170 | 5 |
150016 | 150016 | 2020-05-16 | Iredell | North Carolina | 37097 | 181 | 5 |
153026 | 153026 | 2020-05-17 | Iredell | North Carolina | 37097 | 188 | 5 |
156043 | 156043 | 2020-05-18 | Iredell | North Carolina | 37097 | 192 | 5 |
159062 | 159062 | 2020-05-19 | Iredell | North Carolina | 37097 | 199 | 5 |
162089 | 162089 | 2020-05-20 | Iredell | North Carolina | 37097 | 202 | 5 |
165118 | 165118 | 2020-05-21 | Iredell | North Carolina | 37097 | 206 | 5 |
168153 | 168153 | 2020-05-22 | Iredell | North Carolina | 37097 | 212 | 5 |
171192 | 171192 | 2020-05-23 | Iredell | North Carolina | 37097 | 219 | 5 |
174234 | 174234 | 2020-05-24 | Iredell | North Carolina | 37097 | 228 | 5 |
177278 | 177278 | 2020-05-25 | Iredell | North Carolina | 37097 | 230 | 5 |
180321 | 180321 | 2020-05-26 | Iredell | North Carolina | 37097 | 230 | 5 |
183369 | 183369 | 2020-05-27 | Iredell | North Carolina | 37097 | 236 | 5 |
186426 | 186426 | 2020-05-28 | Iredell | North Carolina | 37097 | 239 | 5 |
189486 | 189486 | 2020-05-29 | Iredell | North Carolina | 37097 | 244 | 5 |
192550 | 192550 | 2020-05-30 | Iredell | North Carolina | 37097 | 254 | 5 |
195620 | 195620 | 2020-05-31 | Iredell | North Carolina | 37097 | 259 | 5 |
198693 | 198693 | 2020-06-01 | Iredell | North Carolina | 37097 | 264 | 5 |
201767 | 201767 | 2020-06-02 | Iredell | North Carolina | 37097 | 273 | 5 |
204844 | 204844 | 2020-06-03 | Iredell | North Carolina | 37097 | 280 | 5 |
207925 | 207925 | 2020-06-04 | Iredell | North Carolina | 37097 | 289 | 5 |
211007 | 211007 | 2020-06-05 | Iredell | North Carolina | 37097 | 301 | 5 |
214091 | 214091 | 2020-06-06 | Iredell | North Carolina | 37097 | 325 | 5 |
217181 | 217181 | 2020-06-07 | Iredell | North Carolina | 37097 | 332 | 5 |
220273 | 220273 | 2020-06-08 | Iredell | North Carolina | 37097 | 348 | 5 |
223367 | 223367 | 2020-06-09 | Iredell | North Carolina | 37097 | 354 | 5 |
226467 | 226467 | 2020-06-10 | Iredell | North Carolina | 37097 | 363 | 5 |
229571 | 229571 | 2020-06-11 | Iredell | North Carolina | 37097 | 378 | 5 |
232676 | 232676 | 2020-06-12 | Iredell | North Carolina | 37097 | 404 | 5 |
235781 | 235781 | 2020-06-13 | Iredell | North Carolina | 37097 | 419 | 5 |
238889 | 238889 | 2020-06-14 | Iredell | North Carolina | 37097 | 441 | 5 |
241998 | 241998 | 2020-06-15 | Iredell | North Carolina | 37097 | 446 | 5 |
245110 | 245110 | 2020-06-16 | Iredell | North Carolina | 37097 | 454 | 5 |
248223 | 248223 | 2020-06-17 | Iredell | North Carolina | 37097 | 475 | 6 |
251338 | 251338 | 2020-06-18 | Iredell | North Carolina | 37097 | 479 | 6 |
254453 | 254453 | 2020-06-19 | Iredell | North Carolina | 37097 | 523 | 6 |
257576 | 257576 | 2020-06-20 | Iredell | North Carolina | 37097 | 529 | 7 |
260703 | 260703 | 2020-06-21 | Iredell | North Carolina | 37097 | 540 | 7 |
263831 | 263831 | 2020-06-22 | Iredell | North Carolina | 37097 | 569 | 7 |
266959 | 266959 | 2020-06-23 | Iredell | North Carolina | 37097 | 575 | 7 |
270093 | 270093 | 2020-06-24 | Iredell | North Carolina | 37097 | 593 | 7 |
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);