ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1077 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 195 ✖
- 2 52
- 4 25
- 306 17
- 245 16
- 253 14
- 6 13
- 3 12
- 33 12
- 37 12
- 227 12
- 258 12
- 250 10
- 251 9
- 294 9
- 396 9
- 9 8
- 22 8
- 53 8
- 255 8
- 329 8
- 390 8
- 1 7
- 43 7
- 54 7
- 57 7
- 68 7
- 70 7
- 214 7
- 236 7
- 241 7
- 252 7
- 254 7
- 256 7
- 295 7
- 318 7
- 388 7
- 392 7
- 0 6
- 20 6
- 26 6
- 31 6
- 40 6
- 216 6
- 217 6
- 218 6
- 243 6
- 248 6
- 259 6
- 320 6
- 393 6
- 8 5
- 42 5
- 83 5
- 201 5
- 263 5
- 301 5
- 307 5
- 309 5
- 341 5
- 386 5
- 395 5
- 12 4
- 51 4
- 61 4
- 64 4
- 179 4
- 233 4
- 238 4
- 281 4
- 284 4
- 292 4
- 296 4
- 312 4
- 317 4
- 322 4
- 360 4
- 372 4
- 384 4
- 7 3
- 21 3
- 23 3
- 25 3
- 47 3
- 49 3
- 72 3
- 107 3
- 208 3
- 210 3
- 211 3
- 249 3
- 272 3
- 303 3
- 308 3
- 325 3
- 336 3
- 338 3
- 349 3
- 366 3
- 375 3
- 376 3
- 10 2
- 17 2
- 19 2
- 34 2
- 45 2
- 60 2
- 63 2
- 71 2
- 151 2
- 156 2
- 205 2
- 212 2
- 215 2
- 219 2
- 228 2
- 244 2
- 246 2
- 257 2
- 278 2
- 287 2
- 297 2
- 310 2
- 319 2
- 327 2
- 348 2
- 364 2
- 370 2
- 379 2
- 397 2
- 5 1
- 13 1
- 15 1
- 24 1
- 27 1
- 30 1
- 38 1
- 39 1
- 41 1
- 44 1
- 52 1
- 65 1
- 69 1
- 73 1
- 81 1
- 82 1
- 98 1
- 99 1
- 103 1
- 112 1
- 121 1
- 127 1
- 160 1
- 174 1
- 176 1
- 182 1
- 193 1
- 196 1
- 207 1
- 209 1
- 223 1
- 234 1
- 235 1
- 237 1
- 239 1
- 242 1
- 260 1
- 261 1
- 262 1
- 264 1
- 266 1
- 273 1
- 280 1
- 282 1
- 283 1
- 285 1
- 288 1
- 300 1
- 304 1
- 305 1
- 311 1
- 314 1
- 316 1
- 343 1
- 352 1
- 353 1
- 354 1
- 359 1
- 365 1
- 368 1
- 378 1
- 382 1
- 385 1
- 387 1
- 391 1
- 394 1
state 1
- Alabama 785
fips 1
- 1077 · 785 ✖
county 1
- Lauderdale 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499613 | 2499613 | 2022-05-13 | Lauderdale | Alabama | 1077 | 24193 | 397 |
2496355 | 2496355 | 2022-05-12 | Lauderdale | Alabama | 1077 | 24187 | 397 |
2493097 | 2493097 | 2022-05-11 | Lauderdale | Alabama | 1077 | 24181 | 396 |
2489839 | 2489839 | 2022-05-10 | Lauderdale | Alabama | 1077 | 24178 | 396 |
2486582 | 2486582 | 2022-05-09 | Lauderdale | Alabama | 1077 | 24174 | 396 |
2483324 | 2483324 | 2022-05-08 | Lauderdale | Alabama | 1077 | 24167 | 396 |
2480066 | 2480066 | 2022-05-07 | Lauderdale | Alabama | 1077 | 24167 | 396 |
2476808 | 2476808 | 2022-05-06 | Lauderdale | Alabama | 1077 | 24167 | 396 |
2473550 | 2473550 | 2022-05-05 | Lauderdale | Alabama | 1077 | 24161 | 396 |
2470293 | 2470293 | 2022-05-04 | Lauderdale | Alabama | 1077 | 24151 | 396 |
2467037 | 2467037 | 2022-05-03 | Lauderdale | Alabama | 1077 | 24147 | 396 |
2463782 | 2463782 | 2022-05-02 | Lauderdale | Alabama | 1077 | 24141 | 395 |
2460526 | 2460526 | 2022-05-01 | Lauderdale | Alabama | 1077 | 24137 | 395 |
2457270 | 2457270 | 2022-04-30 | Lauderdale | Alabama | 1077 | 24137 | 395 |
2454014 | 2454014 | 2022-04-29 | Lauderdale | Alabama | 1077 | 24137 | 395 |
2450758 | 2450758 | 2022-04-28 | Lauderdale | Alabama | 1077 | 24133 | 395 |
2447502 | 2447502 | 2022-04-27 | Lauderdale | Alabama | 1077 | 24133 | 394 |
2444246 | 2444246 | 2022-04-26 | Lauderdale | Alabama | 1077 | 24129 | 393 |
2440990 | 2440990 | 2022-04-25 | Lauderdale | Alabama | 1077 | 24128 | 393 |
2437734 | 2437734 | 2022-04-24 | Lauderdale | Alabama | 1077 | 24118 | 393 |
2434478 | 2434478 | 2022-04-23 | Lauderdale | Alabama | 1077 | 24118 | 393 |
2431222 | 2431222 | 2022-04-22 | Lauderdale | Alabama | 1077 | 24118 | 393 |
2427966 | 2427966 | 2022-04-21 | Lauderdale | Alabama | 1077 | 24116 | 393 |
2424710 | 2424710 | 2022-04-20 | Lauderdale | Alabama | 1077 | 24114 | 392 |
2421454 | 2421454 | 2022-04-19 | Lauderdale | Alabama | 1077 | 24113 | 392 |
2418198 | 2418198 | 2022-04-18 | Lauderdale | Alabama | 1077 | 24108 | 392 |
2414942 | 2414942 | 2022-04-17 | Lauderdale | Alabama | 1077 | 24108 | 392 |
2411686 | 2411686 | 2022-04-16 | Lauderdale | Alabama | 1077 | 24108 | 392 |
2408430 | 2408430 | 2022-04-15 | Lauderdale | Alabama | 1077 | 24108 | 392 |
2405174 | 2405174 | 2022-04-14 | Lauderdale | Alabama | 1077 | 24106 | 392 |
2401919 | 2401919 | 2022-04-13 | Lauderdale | Alabama | 1077 | 24104 | 391 |
2398664 | 2398664 | 2022-04-12 | Lauderdale | Alabama | 1077 | 24099 | 390 |
2395409 | 2395409 | 2022-04-11 | Lauderdale | Alabama | 1077 | 24097 | 390 |
2392153 | 2392153 | 2022-04-10 | Lauderdale | Alabama | 1077 | 24094 | 390 |
2388897 | 2388897 | 2022-04-09 | Lauderdale | Alabama | 1077 | 24094 | 390 |
2385642 | 2385642 | 2022-04-08 | Lauderdale | Alabama | 1077 | 24094 | 390 |
2382387 | 2382387 | 2022-04-07 | Lauderdale | Alabama | 1077 | 24081 | 390 |
2379132 | 2379132 | 2022-04-06 | Lauderdale | Alabama | 1077 | 24081 | 390 |
2375878 | 2375878 | 2022-04-05 | Lauderdale | Alabama | 1077 | 24076 | 390 |
2372626 | 2372626 | 2022-04-04 | Lauderdale | Alabama | 1077 | 24075 | 388 |
2369373 | 2369373 | 2022-04-03 | Lauderdale | Alabama | 1077 | 24071 | 388 |
2366120 | 2366120 | 2022-04-02 | Lauderdale | Alabama | 1077 | 24071 | 388 |
2362867 | 2362867 | 2022-04-01 | Lauderdale | Alabama | 1077 | 24071 | 388 |
2359613 | 2359613 | 2022-03-31 | Lauderdale | Alabama | 1077 | 24070 | 388 |
2356359 | 2356359 | 2022-03-30 | Lauderdale | Alabama | 1077 | 24068 | 388 |
2353106 | 2353106 | 2022-03-29 | Lauderdale | Alabama | 1077 | 24068 | 388 |
2349854 | 2349854 | 2022-03-28 | Lauderdale | Alabama | 1077 | 24065 | 387 |
2346601 | 2346601 | 2022-03-27 | Lauderdale | Alabama | 1077 | 24054 | 386 |
2343348 | 2343348 | 2022-03-26 | Lauderdale | Alabama | 1077 | 24054 | 386 |
2340095 | 2340095 | 2022-03-25 | Lauderdale | Alabama | 1077 | 24054 | 386 |
2336842 | 2336842 | 2022-03-24 | Lauderdale | Alabama | 1077 | 24050 | 386 |
2333588 | 2333588 | 2022-03-23 | Lauderdale | Alabama | 1077 | 24046 | 386 |
2330334 | 2330334 | 2022-03-22 | Lauderdale | Alabama | 1077 | 24042 | 385 |
2327082 | 2327082 | 2022-03-21 | Lauderdale | Alabama | 1077 | 24039 | 384 |
2323829 | 2323829 | 2022-03-20 | Lauderdale | Alabama | 1077 | 24015 | 384 |
2320575 | 2320575 | 2022-03-19 | Lauderdale | Alabama | 1077 | 24015 | 384 |
2317321 | 2317321 | 2022-03-18 | Lauderdale | Alabama | 1077 | 24015 | 384 |
2314068 | 2314068 | 2022-03-17 | Lauderdale | Alabama | 1077 | 24010 | 382 |
2310815 | 2310815 | 2022-03-16 | Lauderdale | Alabama | 1077 | 24009 | 379 |
2307562 | 2307562 | 2022-03-15 | Lauderdale | Alabama | 1077 | 24004 | 379 |
2304311 | 2304311 | 2022-03-14 | Lauderdale | Alabama | 1077 | 24001 | 378 |
2301059 | 2301059 | 2022-03-13 | Lauderdale | Alabama | 1077 | 23993 | 376 |
2297807 | 2297807 | 2022-03-12 | Lauderdale | Alabama | 1077 | 23993 | 376 |
2294555 | 2294555 | 2022-03-11 | Lauderdale | Alabama | 1077 | 23993 | 376 |
2291303 | 2291303 | 2022-03-10 | Lauderdale | Alabama | 1077 | 23984 | 375 |
2288051 | 2288051 | 2022-03-09 | Lauderdale | Alabama | 1077 | 23978 | 375 |
2284799 | 2284799 | 2022-03-08 | Lauderdale | Alabama | 1077 | 23970 | 375 |
2281547 | 2281547 | 2022-03-07 | Lauderdale | Alabama | 1077 | 23966 | 372 |
2278294 | 2278294 | 2022-03-06 | Lauderdale | Alabama | 1077 | 23953 | 372 |
2275041 | 2275041 | 2022-03-05 | Lauderdale | Alabama | 1077 | 23953 | 372 |
2271788 | 2271788 | 2022-03-04 | Lauderdale | Alabama | 1077 | 23953 | 372 |
2268536 | 2268536 | 2022-03-03 | Lauderdale | Alabama | 1077 | 23941 | 370 |
2265283 | 2265283 | 2022-03-02 | Lauderdale | Alabama | 1077 | 23934 | 370 |
2262033 | 2262033 | 2022-03-01 | Lauderdale | Alabama | 1077 | 23923 | 368 |
2258782 | 2258782 | 2022-02-28 | Lauderdale | Alabama | 1077 | 23910 | 366 |
2255531 | 2255531 | 2022-02-27 | Lauderdale | Alabama | 1077 | 23908 | 366 |
2252280 | 2252280 | 2022-02-26 | Lauderdale | Alabama | 1077 | 23899 | 366 |
2249029 | 2249029 | 2022-02-25 | Lauderdale | Alabama | 1077 | 23884 | 365 |
2245778 | 2245778 | 2022-02-24 | Lauderdale | Alabama | 1077 | 23861 | 364 |
2242527 | 2242527 | 2022-02-23 | Lauderdale | Alabama | 1077 | 23828 | 364 |
2239276 | 2239276 | 2022-02-22 | Lauderdale | Alabama | 1077 | 23793 | 360 |
2236025 | 2236025 | 2022-02-21 | Lauderdale | Alabama | 1077 | 23775 | 360 |
2232774 | 2232774 | 2022-02-20 | Lauderdale | Alabama | 1077 | 23761 | 360 |
2229523 | 2229523 | 2022-02-19 | Lauderdale | Alabama | 1077 | 23749 | 360 |
2226272 | 2226272 | 2022-02-18 | Lauderdale | Alabama | 1077 | 23722 | 359 |
2223021 | 2223021 | 2022-02-17 | Lauderdale | Alabama | 1077 | 23698 | 354 |
2219770 | 2219770 | 2022-02-16 | Lauderdale | Alabama | 1077 | 23672 | 353 |
2216520 | 2216520 | 2022-02-15 | Lauderdale | Alabama | 1077 | 23633 | 352 |
2213269 | 2213269 | 2022-02-14 | Lauderdale | Alabama | 1077 | 23597 | 349 |
2210016 | 2210016 | 2022-02-13 | Lauderdale | Alabama | 1077 | 23583 | 349 |
2206763 | 2206763 | 2022-02-12 | Lauderdale | Alabama | 1077 | 23535 | 349 |
2203510 | 2203510 | 2022-02-11 | Lauderdale | Alabama | 1077 | 23502 | 348 |
2200256 | 2200256 | 2022-02-10 | Lauderdale | Alabama | 1077 | 23420 | 348 |
2197002 | 2197002 | 2022-02-09 | Lauderdale | Alabama | 1077 | 23366 | 343 |
2193747 | 2193747 | 2022-02-08 | Lauderdale | Alabama | 1077 | 23249 | 341 |
2190494 | 2190494 | 2022-02-07 | Lauderdale | Alabama | 1077 | 23167 | 341 |
2187241 | 2187241 | 2022-02-06 | Lauderdale | Alabama | 1077 | 23098 | 341 |
2183988 | 2183988 | 2022-02-05 | Lauderdale | Alabama | 1077 | 23098 | 341 |
2180736 | 2180736 | 2022-02-04 | Lauderdale | Alabama | 1077 | 23060 | 341 |
2177485 | 2177485 | 2022-02-03 | Lauderdale | Alabama | 1077 | 22783 | 338 |
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);