ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,565 rows where county = "Blount" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 241 ✖
- 3 107
- 139 82
- 1 74
- 0 69
- 196 39
- 193 35
- 15 27
- 243 26
- 194 24
- 197 18
- 7 16
- 25 16
- 198 15
- 328 15
- 17 14
- 200 14
- 210 14
- 227 14
- 418 14
- 23 13
- 140 13
- 146 13
- 272 13
- 269 12
- 134 11
- 135 11
- 186 11
- 204 11
- 5 10
- 36 10
- 131 10
- 142 10
- 192 10
- 202 10
- 203 10
- 6 9
- 12 9
- 46 9
- 47 9
- 125 9
- 16 8
- 34 8
- 63 8
- 129 8
- 133 8
- 137 8
- 174 8
- 216 8
- 265 8
- 284 8
- 285 8
- 11 7
- 24 7
- 31 7
- 121 7
- 127 7
- 176 7
- 190 7
- 230 7
- 338 7
- 345 7
- 357 7
- 367 7
- 375 7
- 387 7
- 396 7
- 399 7
- 413 7
- 420 7
- 432 7
- 436 7
- 438 7
- 439 7
- 13 6
- 40 6
- 58 6
- 83 6
- 86 6
- 130 6
- 132 6
- 175 6
- 178 6
- 195 6
- 207 6
- 212 6
- 215 6
- 218 6
- 236 6
- 237 6
- 270 6
- 4 5
- 14 5
- 21 5
- 26 5
- 28 5
- 68 5
- 98 5
- 128 5
- 149 5
- 181 5
- 188 5
- 189 5
- 201 5
- 205 5
- 208 5
- 214 5
- 239 5
- 241 5
- 325 5
- 2 4
- 27 4
- 45 4
- 54 4
- 55 4
- 93 4
- 112 4
- 136 4
- 144 4
- 157 4
- 158 4
- 162 4
- 169 4
- 172 4
- 185 4
- 187 4
- 213 4
- 221 4
- 242 4
- 248 4
- 317 4
- 9 3
- 30 3
- 32 3
- 35 3
- 41 3
- 43 3
- 49 3
- 60 3
- 77 3
- 80 3
- 94 3
- 99 3
- 100 3
- 143 3
- 145 3
- 160 3
- 233 3
- 235 3
- 244 3
- 247 3
- 259 3
- 278 3
- 440 3
- 10 2
- 19 2
- 50 2
- 52 2
- 61 2
- 62 2
- 65 2
- 66 2
- 72 2
- 101 2
- 111 2
- 116 2
- 141 2
- 147 2
- 150 2
- 166 2
- 168 2
- 179 2
- 182 2
- 183 2
- 184 2
- 199 2
- 211 2
- 217 2
- 228 2
- 254 2
- 267 2
- 274 2
- 275 2
- 8 1
- 18 1
- 20 1
- 39 1
- 42 1
- 44 1
- 48 1
- 56 1
- 57 1
- 59 1
- 64 1
- 67 1
- 70 1
- 71 1
- 75 1
- 79 1
- 82 1
- 84 1
- 87 1
- 90 1
- 95 1
- 96 1
- 97 1
- 103 1
- 105 1
- 107 1
- 108 1
- 109 1
- 110 1
- 113 1
- 117 1
- 120 1
- 122 1
- 123 1
- 124 1
- 126 1
- 152 1
- 154 1
- 156 1
- 161 1
- 164 1
- 167 1
- 171 1
- 177 1
- 191 1
- 219 1
- 220 1
- 222 1
- 223 1
- 225 1
- 226 1
- 240 1
- 246 1
- 250 1
- 271 1
- 281 1
- 321 1
- 323 1
- 324 1
county 1
- Blount · 1,565 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499579 | 2499579 | 2022-05-13 | Blount | Alabama | 1009 | 15005 | 243 |
2502115 | 2502115 | 2022-05-13 | Blount | Tennessee | 47009 | 39310 | 440 |
2496321 | 2496321 | 2022-05-12 | Blount | Alabama | 1009 | 15004 | 243 |
2498857 | 2498857 | 2022-05-12 | Blount | Tennessee | 47009 | 39310 | 440 |
2493063 | 2493063 | 2022-05-11 | Blount | Alabama | 1009 | 14999 | 243 |
2495599 | 2495599 | 2022-05-11 | Blount | Tennessee | 47009 | 39310 | 440 |
2489805 | 2489805 | 2022-05-10 | Blount | Alabama | 1009 | 14994 | 243 |
2492341 | 2492341 | 2022-05-10 | Blount | Tennessee | 47009 | 39251 | 439 |
2486548 | 2486548 | 2022-05-09 | Blount | Alabama | 1009 | 14988 | 243 |
2489083 | 2489083 | 2022-05-09 | Blount | Tennessee | 47009 | 39251 | 439 |
2483290 | 2483290 | 2022-05-08 | Blount | Alabama | 1009 | 14985 | 243 |
2485826 | 2485826 | 2022-05-08 | Blount | Tennessee | 47009 | 39251 | 439 |
2480032 | 2480032 | 2022-05-07 | Blount | Alabama | 1009 | 14985 | 243 |
2482568 | 2482568 | 2022-05-07 | Blount | Tennessee | 47009 | 39251 | 439 |
2476774 | 2476774 | 2022-05-06 | Blount | Alabama | 1009 | 14985 | 243 |
2479310 | 2479310 | 2022-05-06 | Blount | Tennessee | 47009 | 39251 | 439 |
2473516 | 2473516 | 2022-05-05 | Blount | Alabama | 1009 | 14985 | 243 |
2476052 | 2476052 | 2022-05-05 | Blount | Tennessee | 47009 | 39251 | 439 |
2470259 | 2470259 | 2022-05-04 | Blount | Alabama | 1009 | 14983 | 243 |
2472795 | 2472795 | 2022-05-04 | Blount | Tennessee | 47009 | 39251 | 439 |
2467003 | 2467003 | 2022-05-03 | Blount | Alabama | 1009 | 14981 | 243 |
2469539 | 2469539 | 2022-05-03 | Blount | Tennessee | 47009 | 39189 | 438 |
2463748 | 2463748 | 2022-05-02 | Blount | Alabama | 1009 | 14979 | 243 |
2466283 | 2466283 | 2022-05-02 | Blount | Tennessee | 47009 | 39189 | 438 |
2460492 | 2460492 | 2022-05-01 | Blount | Alabama | 1009 | 14980 | 243 |
2463028 | 2463028 | 2022-05-01 | Blount | Tennessee | 47009 | 39189 | 438 |
2457236 | 2457236 | 2022-04-30 | Blount | Alabama | 1009 | 14980 | 243 |
2459772 | 2459772 | 2022-04-30 | Blount | Tennessee | 47009 | 39189 | 438 |
2453980 | 2453980 | 2022-04-29 | Blount | Alabama | 1009 | 14980 | 243 |
2456516 | 2456516 | 2022-04-29 | Blount | Tennessee | 47009 | 39189 | 438 |
2450724 | 2450724 | 2022-04-28 | Blount | Alabama | 1009 | 14977 | 243 |
2453260 | 2453260 | 2022-04-28 | Blount | Tennessee | 47009 | 39189 | 438 |
2447468 | 2447468 | 2022-04-27 | Blount | Alabama | 1009 | 14976 | 243 |
2450004 | 2450004 | 2022-04-27 | Blount | Tennessee | 47009 | 39189 | 438 |
2444212 | 2444212 | 2022-04-26 | Blount | Alabama | 1009 | 14968 | 243 |
2446747 | 2446747 | 2022-04-26 | Blount | Tennessee | 47009 | 39149 | 436 |
2440956 | 2440956 | 2022-04-25 | Blount | Alabama | 1009 | 14967 | 243 |
2443492 | 2443492 | 2022-04-25 | Blount | Tennessee | 47009 | 39149 | 436 |
2437700 | 2437700 | 2022-04-24 | Blount | Alabama | 1009 | 14967 | 243 |
2440236 | 2440236 | 2022-04-24 | Blount | Tennessee | 47009 | 39149 | 436 |
2434444 | 2434444 | 2022-04-23 | Blount | Alabama | 1009 | 14967 | 243 |
2436980 | 2436980 | 2022-04-23 | Blount | Tennessee | 47009 | 39149 | 436 |
2431188 | 2431188 | 2022-04-22 | Blount | Alabama | 1009 | 14967 | 243 |
2433724 | 2433724 | 2022-04-22 | Blount | Tennessee | 47009 | 39149 | 436 |
2427932 | 2427932 | 2022-04-21 | Blount | Alabama | 1009 | 14967 | 243 |
2430468 | 2430468 | 2022-04-21 | Blount | Tennessee | 47009 | 39149 | 436 |
2424676 | 2424676 | 2022-04-20 | Blount | Alabama | 1009 | 14963 | 243 |
2427212 | 2427212 | 2022-04-20 | Blount | Tennessee | 47009 | 39149 | 436 |
2421420 | 2421420 | 2022-04-19 | Blount | Alabama | 1009 | 14961 | 243 |
2423956 | 2423956 | 2022-04-19 | Blount | Tennessee | 47009 | 39108 | 432 |
2418164 | 2418164 | 2022-04-18 | Blount | Alabama | 1009 | 14959 | 242 |
2420700 | 2420700 | 2022-04-18 | Blount | Tennessee | 47009 | 39108 | 432 |
2414908 | 2414908 | 2022-04-17 | Blount | Alabama | 1009 | 14959 | 242 |
2417444 | 2417444 | 2022-04-17 | Blount | Tennessee | 47009 | 39108 | 432 |
2411652 | 2411652 | 2022-04-16 | Blount | Alabama | 1009 | 14959 | 242 |
2414188 | 2414188 | 2022-04-16 | Blount | Tennessee | 47009 | 39108 | 432 |
2408396 | 2408396 | 2022-04-15 | Blount | Alabama | 1009 | 14959 | 242 |
2410932 | 2410932 | 2022-04-15 | Blount | Tennessee | 47009 | 39108 | 432 |
2405140 | 2405140 | 2022-04-14 | Blount | Alabama | 1009 | 14953 | 241 |
2407676 | 2407676 | 2022-04-14 | Blount | Tennessee | 47009 | 39108 | 432 |
2401885 | 2401885 | 2022-04-13 | Blount | Alabama | 1009 | 14935 | 241 |
2404420 | 2404420 | 2022-04-13 | Blount | Tennessee | 47009 | 39108 | 432 |
2398630 | 2398630 | 2022-04-12 | Blount | Alabama | 1009 | 14934 | 241 |
2401165 | 2401165 | 2022-04-12 | Blount | Tennessee | 47009 | 39079 | 420 |
2395375 | 2395375 | 2022-04-11 | Blount | Alabama | 1009 | 14934 | 239 |
2397910 | 2397910 | 2022-04-11 | Blount | Tennessee | 47009 | 39079 | 420 |
2392119 | 2392119 | 2022-04-10 | Blount | Alabama | 1009 | 14929 | 239 |
2394655 | 2394655 | 2022-04-10 | Blount | Tennessee | 47009 | 39079 | 420 |
2388863 | 2388863 | 2022-04-09 | Blount | Alabama | 1009 | 14929 | 239 |
2391399 | 2391399 | 2022-04-09 | Blount | Tennessee | 47009 | 39079 | 420 |
2385608 | 2385608 | 2022-04-08 | Blount | Alabama | 1009 | 14929 | 239 |
2388143 | 2388143 | 2022-04-08 | Blount | Tennessee | 47009 | 39079 | 420 |
2382353 | 2382353 | 2022-04-07 | Blount | Alabama | 1009 | 14926 | 239 |
2384888 | 2384888 | 2022-04-07 | Blount | Tennessee | 47009 | 39079 | 420 |
2379098 | 2379098 | 2022-04-06 | Blount | Alabama | 1009 | 14905 | 237 |
2381633 | 2381633 | 2022-04-06 | Blount | Tennessee | 47009 | 39079 | 420 |
2375844 | 2375844 | 2022-04-05 | Blount | Alabama | 1009 | 14903 | 237 |
2378378 | 2378378 | 2022-04-05 | Blount | Tennessee | 47009 | 39053 | 418 |
2372592 | 2372592 | 2022-04-04 | Blount | Alabama | 1009 | 14902 | 237 |
2375124 | 2375124 | 2022-04-04 | Blount | Tennessee | 47009 | 39053 | 418 |
2369339 | 2369339 | 2022-04-03 | Blount | Alabama | 1009 | 14901 | 237 |
2371872 | 2371872 | 2022-04-03 | Blount | Tennessee | 47009 | 39053 | 418 |
2366086 | 2366086 | 2022-04-02 | Blount | Alabama | 1009 | 14901 | 237 |
2368619 | 2368619 | 2022-04-02 | Blount | Tennessee | 47009 | 39053 | 418 |
2362833 | 2362833 | 2022-04-01 | Blount | Alabama | 1009 | 14901 | 237 |
2365366 | 2365366 | 2022-04-01 | Blount | Tennessee | 47009 | 39053 | 418 |
2359579 | 2359579 | 2022-03-31 | Blount | Alabama | 1009 | 14900 | 236 |
2362113 | 2362113 | 2022-03-31 | Blount | Tennessee | 47009 | 39053 | 418 |
2356325 | 2356325 | 2022-03-30 | Blount | Alabama | 1009 | 14899 | 236 |
2358859 | 2358859 | 2022-03-30 | Blount | Tennessee | 47009 | 39053 | 418 |
2353072 | 2353072 | 2022-03-29 | Blount | Alabama | 1009 | 14899 | 236 |
2355605 | 2355605 | 2022-03-29 | Blount | Tennessee | 47009 | 39027 | 418 |
2349820 | 2349820 | 2022-03-28 | Blount | Alabama | 1009 | 14898 | 235 |
2352352 | 2352352 | 2022-03-28 | Blount | Tennessee | 47009 | 39027 | 418 |
2346567 | 2346567 | 2022-03-27 | Blount | Alabama | 1009 | 14896 | 233 |
2349100 | 2349100 | 2022-03-27 | Blount | Tennessee | 47009 | 39027 | 418 |
2343314 | 2343314 | 2022-03-26 | Blount | Alabama | 1009 | 14896 | 233 |
2345847 | 2345847 | 2022-03-26 | Blount | Tennessee | 47009 | 39027 | 418 |
2340061 | 2340061 | 2022-03-25 | Blount | Alabama | 1009 | 14896 | 233 |
2342594 | 2342594 | 2022-03-25 | Blount | Tennessee | 47009 | 39027 | 418 |
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);