ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Caldwell" and fips = 22021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500709 | 2500709 | 2022-05-13 | Caldwell | Louisiana | 22021 | 3625 | 55 |
2497451 | 2497451 | 2022-05-12 | Caldwell | Louisiana | 22021 | 3624 | 55 |
2494193 | 2494193 | 2022-05-11 | Caldwell | Louisiana | 22021 | 3624 | 55 |
2490935 | 2490935 | 2022-05-10 | Caldwell | Louisiana | 22021 | 3624 | 55 |
2487678 | 2487678 | 2022-05-09 | Caldwell | Louisiana | 22021 | 3619 | 55 |
2484420 | 2484420 | 2022-05-08 | Caldwell | Louisiana | 22021 | 3619 | 55 |
2481162 | 2481162 | 2022-05-07 | Caldwell | Louisiana | 22021 | 3619 | 55 |
2477904 | 2477904 | 2022-05-06 | Caldwell | Louisiana | 22021 | 3619 | 55 |
2474646 | 2474646 | 2022-05-05 | Caldwell | Louisiana | 22021 | 3614 | 55 |
2471389 | 2471389 | 2022-05-04 | Caldwell | Louisiana | 22021 | 3614 | 55 |
2468133 | 2468133 | 2022-05-03 | Caldwell | Louisiana | 22021 | 3614 | 55 |
2464878 | 2464878 | 2022-05-02 | Caldwell | Louisiana | 22021 | 3614 | 55 |
2461622 | 2461622 | 2022-05-01 | Caldwell | Louisiana | 22021 | 3613 | 55 |
2458366 | 2458366 | 2022-04-30 | Caldwell | Louisiana | 22021 | 3613 | 55 |
2455110 | 2455110 | 2022-04-29 | Caldwell | Louisiana | 22021 | 3613 | 55 |
2451854 | 2451854 | 2022-04-28 | Caldwell | Louisiana | 22021 | 3611 | 55 |
2448598 | 2448598 | 2022-04-27 | Caldwell | Louisiana | 22021 | 3609 | 55 |
2445342 | 2445342 | 2022-04-26 | Caldwell | Louisiana | 22021 | 3609 | 55 |
2442086 | 2442086 | 2022-04-25 | Caldwell | Louisiana | 22021 | 3601 | 55 |
2438830 | 2438830 | 2022-04-24 | Caldwell | Louisiana | 22021 | 3599 | 55 |
2435574 | 2435574 | 2022-04-23 | Caldwell | Louisiana | 22021 | 3599 | 55 |
2432318 | 2432318 | 2022-04-22 | Caldwell | Louisiana | 22021 | 3599 | 55 |
2429062 | 2429062 | 2022-04-21 | Caldwell | Louisiana | 22021 | 3599 | 55 |
2425806 | 2425806 | 2022-04-20 | Caldwell | Louisiana | 22021 | 3596 | 55 |
2422550 | 2422550 | 2022-04-19 | Caldwell | Louisiana | 22021 | 3596 | 55 |
2419294 | 2419294 | 2022-04-18 | Caldwell | Louisiana | 22021 | 3596 | 55 |
2416038 | 2416038 | 2022-04-17 | Caldwell | Louisiana | 22021 | 3584 | 55 |
2412782 | 2412782 | 2022-04-16 | Caldwell | Louisiana | 22021 | 3584 | 55 |
2409526 | 2409526 | 2022-04-15 | Caldwell | Louisiana | 22021 | 3584 | 55 |
2406270 | 2406270 | 2022-04-14 | Caldwell | Louisiana | 22021 | 3584 | 55 |
2403014 | 2403014 | 2022-04-13 | Caldwell | Louisiana | 22021 | 3584 | 55 |
2399760 | 2399760 | 2022-04-12 | Caldwell | Louisiana | 22021 | 3584 | 55 |
2396504 | 2396504 | 2022-04-11 | Caldwell | Louisiana | 22021 | 3581 | 55 |
2393249 | 2393249 | 2022-04-10 | Caldwell | Louisiana | 22021 | 3581 | 55 |
2389993 | 2389993 | 2022-04-09 | Caldwell | Louisiana | 22021 | 3581 | 55 |
2386737 | 2386737 | 2022-04-08 | Caldwell | Louisiana | 22021 | 3581 | 55 |
2383482 | 2383482 | 2022-04-07 | Caldwell | Louisiana | 22021 | 3579 | 55 |
2380227 | 2380227 | 2022-04-06 | Caldwell | Louisiana | 22021 | 3579 | 55 |
2376972 | 2376972 | 2022-04-05 | Caldwell | Louisiana | 22021 | 3529 | 55 |
2373720 | 2373720 | 2022-04-04 | Caldwell | Louisiana | 22021 | 3423 | 55 |
2370467 | 2370467 | 2022-04-03 | Caldwell | Louisiana | 22021 | 3367 | 55 |
2367214 | 2367214 | 2022-04-02 | Caldwell | Louisiana | 22021 | 3367 | 55 |
2363961 | 2363961 | 2022-04-01 | Caldwell | Louisiana | 22021 | 3367 | 55 |
2360707 | 2360707 | 2022-03-31 | Caldwell | Louisiana | 22021 | 3367 | 54 |
2357453 | 2357453 | 2022-03-30 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2354200 | 2354200 | 2022-03-29 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2350948 | 2350948 | 2022-03-28 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2347695 | 2347695 | 2022-03-27 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2344442 | 2344442 | 2022-03-26 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2341189 | 2341189 | 2022-03-25 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2337936 | 2337936 | 2022-03-24 | Caldwell | Louisiana | 22021 | 3365 | 54 |
2334682 | 2334682 | 2022-03-23 | Caldwell | Louisiana | 22021 | 3365 | 54 |
2331428 | 2331428 | 2022-03-22 | Caldwell | Louisiana | 22021 | 3331 | 54 |
2328176 | 2328176 | 2022-03-21 | Caldwell | Louisiana | 22021 | 3296 | 54 |
2324923 | 2324923 | 2022-03-20 | Caldwell | Louisiana | 22021 | 3274 | 53 |
2321669 | 2321669 | 2022-03-19 | Caldwell | Louisiana | 22021 | 3274 | 53 |
2318415 | 2318415 | 2022-03-18 | Caldwell | Louisiana | 22021 | 3274 | 53 |
2315162 | 2315162 | 2022-03-17 | Caldwell | Louisiana | 22021 | 3254 | 53 |
2311909 | 2311909 | 2022-03-16 | Caldwell | Louisiana | 22021 | 3254 | 53 |
2308656 | 2308656 | 2022-03-15 | Caldwell | Louisiana | 22021 | 3254 | 52 |
2305405 | 2305405 | 2022-03-14 | Caldwell | Louisiana | 22021 | 3254 | 52 |
2302153 | 2302153 | 2022-03-13 | Caldwell | Louisiana | 22021 | 3253 | 52 |
2298901 | 2298901 | 2022-03-12 | Caldwell | Louisiana | 22021 | 3253 | 52 |
2295649 | 2295649 | 2022-03-11 | Caldwell | Louisiana | 22021 | 3253 | 52 |
2292397 | 2292397 | 2022-03-10 | Caldwell | Louisiana | 22021 | 3252 | 52 |
2289145 | 2289145 | 2022-03-09 | Caldwell | Louisiana | 22021 | 3251 | 52 |
2285894 | 2285894 | 2022-03-08 | Caldwell | Louisiana | 22021 | 3251 | 52 |
2282642 | 2282642 | 2022-03-07 | Caldwell | Louisiana | 22021 | 3250 | 52 |
2279389 | 2279389 | 2022-03-06 | Caldwell | Louisiana | 22021 | 3245 | 52 |
2276136 | 2276136 | 2022-03-05 | Caldwell | Louisiana | 22021 | 3245 | 52 |
2272883 | 2272883 | 2022-03-04 | Caldwell | Louisiana | 22021 | 3245 | 52 |
2269631 | 2269631 | 2022-03-03 | Caldwell | Louisiana | 22021 | 3225 | 52 |
2266378 | 2266378 | 2022-03-02 | Caldwell | Louisiana | 22021 | 3223 | 50 |
2263127 | 2263127 | 2022-03-01 | Caldwell | Louisiana | 22021 | 3158 | 50 |
2259876 | 2259876 | 2022-02-28 | Caldwell | Louisiana | 22021 | 3158 | 50 |
2256625 | 2256625 | 2022-02-27 | Caldwell | Louisiana | 22021 | 3158 | 50 |
2253374 | 2253374 | 2022-02-26 | Caldwell | Louisiana | 22021 | 3158 | 50 |
2250123 | 2250123 | 2022-02-25 | Caldwell | Louisiana | 22021 | 3158 | 50 |
2246872 | 2246872 | 2022-02-24 | Caldwell | Louisiana | 22021 | 3132 | 50 |
2243621 | 2243621 | 2022-02-23 | Caldwell | Louisiana | 22021 | 3110 | 50 |
2240370 | 2240370 | 2022-02-22 | Caldwell | Louisiana | 22021 | 3035 | 49 |
2237119 | 2237119 | 2022-02-21 | Caldwell | Louisiana | 22021 | 3033 | 49 |
2233868 | 2233868 | 2022-02-20 | Caldwell | Louisiana | 22021 | 3028 | 47 |
2230617 | 2230617 | 2022-02-19 | Caldwell | Louisiana | 22021 | 3028 | 47 |
2227366 | 2227366 | 2022-02-18 | Caldwell | Louisiana | 22021 | 3028 | 47 |
2224115 | 2224115 | 2022-02-17 | Caldwell | Louisiana | 22021 | 3022 | 47 |
2220864 | 2220864 | 2022-02-16 | Caldwell | Louisiana | 22021 | 3021 | 47 |
2217613 | 2217613 | 2022-02-15 | Caldwell | Louisiana | 22021 | 3014 | 46 |
2214362 | 2214362 | 2022-02-14 | Caldwell | Louisiana | 22021 | 2998 | 46 |
2211110 | 2211110 | 2022-02-13 | Caldwell | Louisiana | 22021 | 2991 | 46 |
2207857 | 2207857 | 2022-02-12 | Caldwell | Louisiana | 22021 | 2991 | 46 |
2204604 | 2204604 | 2022-02-11 | Caldwell | Louisiana | 22021 | 2991 | 46 |
2201351 | 2201351 | 2022-02-10 | Caldwell | Louisiana | 22021 | 2953 | 46 |
2198097 | 2198097 | 2022-02-09 | Caldwell | Louisiana | 22021 | 2951 | 46 |
2194843 | 2194843 | 2022-02-08 | Caldwell | Louisiana | 22021 | 2938 | 45 |
2191589 | 2191589 | 2022-02-07 | Caldwell | Louisiana | 22021 | 2917 | 45 |
2188336 | 2188336 | 2022-02-06 | Caldwell | Louisiana | 22021 | 2910 | 45 |
2185083 | 2185083 | 2022-02-05 | Caldwell | Louisiana | 22021 | 2910 | 45 |
2181831 | 2181831 | 2022-02-04 | Caldwell | Louisiana | 22021 | 2910 | 45 |
2178580 | 2178580 | 2022-02-03 | Caldwell | Louisiana | 22021 | 2899 | 44 |
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);