ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Marshall" and fips = 1095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499622 | 2499622 | 2022-05-13 | Marshall | Alabama | 1095 | 27438 | 394 |
2496364 | 2496364 | 2022-05-12 | Marshall | Alabama | 1095 | 27430 | 394 |
2493106 | 2493106 | 2022-05-11 | Marshall | Alabama | 1095 | 27418 | 393 |
2489848 | 2489848 | 2022-05-10 | Marshall | Alabama | 1095 | 27414 | 393 |
2486591 | 2486591 | 2022-05-09 | Marshall | Alabama | 1095 | 27405 | 393 |
2483333 | 2483333 | 2022-05-08 | Marshall | Alabama | 1095 | 27399 | 393 |
2480075 | 2480075 | 2022-05-07 | Marshall | Alabama | 1095 | 27399 | 393 |
2476817 | 2476817 | 2022-05-06 | Marshall | Alabama | 1095 | 27399 | 393 |
2473559 | 2473559 | 2022-05-05 | Marshall | Alabama | 1095 | 27398 | 393 |
2470302 | 2470302 | 2022-05-04 | Marshall | Alabama | 1095 | 27396 | 393 |
2467046 | 2467046 | 2022-05-03 | Marshall | Alabama | 1095 | 27388 | 393 |
2463791 | 2463791 | 2022-05-02 | Marshall | Alabama | 1095 | 27380 | 392 |
2460535 | 2460535 | 2022-05-01 | Marshall | Alabama | 1095 | 27377 | 392 |
2457279 | 2457279 | 2022-04-30 | Marshall | Alabama | 1095 | 27377 | 392 |
2454023 | 2454023 | 2022-04-29 | Marshall | Alabama | 1095 | 27377 | 392 |
2450767 | 2450767 | 2022-04-28 | Marshall | Alabama | 1095 | 27368 | 392 |
2447511 | 2447511 | 2022-04-27 | Marshall | Alabama | 1095 | 27366 | 392 |
2444255 | 2444255 | 2022-04-26 | Marshall | Alabama | 1095 | 27365 | 392 |
2440999 | 2440999 | 2022-04-25 | Marshall | Alabama | 1095 | 27362 | 392 |
2437743 | 2437743 | 2022-04-24 | Marshall | Alabama | 1095 | 27360 | 392 |
2434487 | 2434487 | 2022-04-23 | Marshall | Alabama | 1095 | 27360 | 392 |
2431231 | 2431231 | 2022-04-22 | Marshall | Alabama | 1095 | 27360 | 392 |
2427975 | 2427975 | 2022-04-21 | Marshall | Alabama | 1095 | 27359 | 392 |
2424719 | 2424719 | 2022-04-20 | Marshall | Alabama | 1095 | 27356 | 391 |
2421463 | 2421463 | 2022-04-19 | Marshall | Alabama | 1095 | 27354 | 390 |
2418207 | 2418207 | 2022-04-18 | Marshall | Alabama | 1095 | 27347 | 390 |
2414951 | 2414951 | 2022-04-17 | Marshall | Alabama | 1095 | 27347 | 390 |
2411695 | 2411695 | 2022-04-16 | Marshall | Alabama | 1095 | 27347 | 390 |
2408439 | 2408439 | 2022-04-15 | Marshall | Alabama | 1095 | 27347 | 390 |
2405183 | 2405183 | 2022-04-14 | Marshall | Alabama | 1095 | 27348 | 389 |
2401928 | 2401928 | 2022-04-13 | Marshall | Alabama | 1095 | 27349 | 389 |
2398673 | 2398673 | 2022-04-12 | Marshall | Alabama | 1095 | 27346 | 389 |
2395418 | 2395418 | 2022-04-11 | Marshall | Alabama | 1095 | 27342 | 389 |
2392162 | 2392162 | 2022-04-10 | Marshall | Alabama | 1095 | 27341 | 389 |
2388906 | 2388906 | 2022-04-09 | Marshall | Alabama | 1095 | 27341 | 389 |
2385651 | 2385651 | 2022-04-08 | Marshall | Alabama | 1095 | 27341 | 389 |
2382396 | 2382396 | 2022-04-07 | Marshall | Alabama | 1095 | 27342 | 389 |
2379141 | 2379141 | 2022-04-06 | Marshall | Alabama | 1095 | 27340 | 389 |
2375887 | 2375887 | 2022-04-05 | Marshall | Alabama | 1095 | 27340 | 389 |
2372635 | 2372635 | 2022-04-04 | Marshall | Alabama | 1095 | 27340 | 389 |
2369382 | 2369382 | 2022-04-03 | Marshall | Alabama | 1095 | 27339 | 389 |
2366129 | 2366129 | 2022-04-02 | Marshall | Alabama | 1095 | 27339 | 389 |
2362876 | 2362876 | 2022-04-01 | Marshall | Alabama | 1095 | 27339 | 389 |
2359622 | 2359622 | 2022-03-31 | Marshall | Alabama | 1095 | 27336 | 389 |
2356368 | 2356368 | 2022-03-30 | Marshall | Alabama | 1095 | 27331 | 389 |
2353115 | 2353115 | 2022-03-29 | Marshall | Alabama | 1095 | 27330 | 389 |
2349863 | 2349863 | 2022-03-28 | Marshall | Alabama | 1095 | 27328 | 388 |
2346610 | 2346610 | 2022-03-27 | Marshall | Alabama | 1095 | 27323 | 388 |
2343357 | 2343357 | 2022-03-26 | Marshall | Alabama | 1095 | 27323 | 388 |
2340104 | 2340104 | 2022-03-25 | Marshall | Alabama | 1095 | 27323 | 388 |
2336851 | 2336851 | 2022-03-24 | Marshall | Alabama | 1095 | 27323 | 388 |
2333597 | 2333597 | 2022-03-23 | Marshall | Alabama | 1095 | 27324 | 388 |
2330343 | 2330343 | 2022-03-22 | Marshall | Alabama | 1095 | 27324 | 388 |
2327091 | 2327091 | 2022-03-21 | Marshall | Alabama | 1095 | 27323 | 387 |
2323838 | 2323838 | 2022-03-20 | Marshall | Alabama | 1095 | 27303 | 385 |
2320584 | 2320584 | 2022-03-19 | Marshall | Alabama | 1095 | 27303 | 385 |
2317330 | 2317330 | 2022-03-18 | Marshall | Alabama | 1095 | 27303 | 385 |
2314077 | 2314077 | 2022-03-17 | Marshall | Alabama | 1095 | 27301 | 383 |
2310824 | 2310824 | 2022-03-16 | Marshall | Alabama | 1095 | 27298 | 380 |
2307571 | 2307571 | 2022-03-15 | Marshall | Alabama | 1095 | 27299 | 380 |
2304320 | 2304320 | 2022-03-14 | Marshall | Alabama | 1095 | 27270 | 377 |
2301068 | 2301068 | 2022-03-13 | Marshall | Alabama | 1095 | 27242 | 377 |
2297816 | 2297816 | 2022-03-12 | Marshall | Alabama | 1095 | 27242 | 377 |
2294564 | 2294564 | 2022-03-11 | Marshall | Alabama | 1095 | 27242 | 377 |
2291312 | 2291312 | 2022-03-10 | Marshall | Alabama | 1095 | 27191 | 377 |
2288060 | 2288060 | 2022-03-09 | Marshall | Alabama | 1095 | 27149 | 376 |
2284808 | 2284808 | 2022-03-08 | Marshall | Alabama | 1095 | 27145 | 375 |
2281556 | 2281556 | 2022-03-07 | Marshall | Alabama | 1095 | 27138 | 374 |
2278303 | 2278303 | 2022-03-06 | Marshall | Alabama | 1095 | 27126 | 371 |
2275050 | 2275050 | 2022-03-05 | Marshall | Alabama | 1095 | 27126 | 371 |
2271797 | 2271797 | 2022-03-04 | Marshall | Alabama | 1095 | 27126 | 371 |
2268545 | 2268545 | 2022-03-03 | Marshall | Alabama | 1095 | 27117 | 370 |
2265292 | 2265292 | 2022-03-02 | Marshall | Alabama | 1095 | 27110 | 368 |
2262042 | 2262042 | 2022-03-01 | Marshall | Alabama | 1095 | 27107 | 367 |
2258791 | 2258791 | 2022-02-28 | Marshall | Alabama | 1095 | 27102 | 365 |
2255540 | 2255540 | 2022-02-27 | Marshall | Alabama | 1095 | 27099 | 365 |
2252289 | 2252289 | 2022-02-26 | Marshall | Alabama | 1095 | 27093 | 365 |
2249038 | 2249038 | 2022-02-25 | Marshall | Alabama | 1095 | 27085 | 365 |
2245787 | 2245787 | 2022-02-24 | Marshall | Alabama | 1095 | 27078 | 364 |
2242536 | 2242536 | 2022-02-23 | Marshall | Alabama | 1095 | 27068 | 362 |
2239285 | 2239285 | 2022-02-22 | Marshall | Alabama | 1095 | 27053 | 359 |
2236034 | 2236034 | 2022-02-21 | Marshall | Alabama | 1095 | 27047 | 359 |
2232783 | 2232783 | 2022-02-20 | Marshall | Alabama | 1095 | 27039 | 359 |
2229532 | 2229532 | 2022-02-19 | Marshall | Alabama | 1095 | 27029 | 359 |
2226281 | 2226281 | 2022-02-18 | Marshall | Alabama | 1095 | 27014 | 357 |
2223030 | 2223030 | 2022-02-17 | Marshall | Alabama | 1095 | 26990 | 357 |
2219779 | 2219779 | 2022-02-16 | Marshall | Alabama | 1095 | 26971 | 356 |
2216529 | 2216529 | 2022-02-15 | Marshall | Alabama | 1095 | 26953 | 353 |
2213278 | 2213278 | 2022-02-14 | Marshall | Alabama | 1095 | 26915 | 349 |
2210025 | 2210025 | 2022-02-13 | Marshall | Alabama | 1095 | 26902 | 349 |
2206772 | 2206772 | 2022-02-12 | Marshall | Alabama | 1095 | 26886 | 349 |
2203519 | 2203519 | 2022-02-11 | Marshall | Alabama | 1095 | 26853 | 347 |
2200265 | 2200265 | 2022-02-10 | Marshall | Alabama | 1095 | 26824 | 347 |
2197011 | 2197011 | 2022-02-09 | Marshall | Alabama | 1095 | 26789 | 346 |
2193756 | 2193756 | 2022-02-08 | Marshall | Alabama | 1095 | 26703 | 346 |
2190503 | 2190503 | 2022-02-07 | Marshall | Alabama | 1095 | 26601 | 346 |
2187250 | 2187250 | 2022-02-06 | Marshall | Alabama | 1095 | 26530 | 345 |
2183997 | 2183997 | 2022-02-05 | Marshall | Alabama | 1095 | 26530 | 345 |
2180745 | 2180745 | 2022-02-04 | Marshall | Alabama | 1095 | 26479 | 345 |
2177494 | 2177494 | 2022-02-03 | Marshall | Alabama | 1095 | 26135 | 345 |
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);