ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where county = "Madison", deaths = 58 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2376994 | 2376994 | 2022-04-05 | Madison | Louisiana | 22065 | 3255 | 58 |
2373742 | 2373742 | 2022-04-04 | Madison | Louisiana | 22065 | 3255 | 58 |
2370489 | 2370489 | 2022-04-03 | Madison | Louisiana | 22065 | 3255 | 58 |
2367236 | 2367236 | 2022-04-02 | Madison | Louisiana | 22065 | 3255 | 58 |
2363983 | 2363983 | 2022-04-01 | Madison | Louisiana | 22065 | 3255 | 58 |
2360729 | 2360729 | 2022-03-31 | Madison | Louisiana | 22065 | 3255 | 58 |
2357475 | 2357475 | 2022-03-30 | Madison | Louisiana | 22065 | 3255 | 58 |
2354222 | 2354222 | 2022-03-29 | Madison | Louisiana | 22065 | 3255 | 58 |
2350970 | 2350970 | 2022-03-28 | Madison | Louisiana | 22065 | 3255 | 58 |
2347717 | 2347717 | 2022-03-27 | Madison | Louisiana | 22065 | 3255 | 58 |
2344464 | 2344464 | 2022-03-26 | Madison | Louisiana | 22065 | 3255 | 58 |
2341211 | 2341211 | 2022-03-25 | Madison | Louisiana | 22065 | 3255 | 58 |
2337958 | 2337958 | 2022-03-24 | Madison | Louisiana | 22065 | 3255 | 58 |
2334704 | 2334704 | 2022-03-23 | Madison | Louisiana | 22065 | 3255 | 58 |
2331450 | 2331450 | 2022-03-22 | Madison | Louisiana | 22065 | 3255 | 58 |
2328198 | 2328198 | 2022-03-21 | Madison | Louisiana | 22065 | 3255 | 58 |
2324945 | 2324945 | 2022-03-20 | Madison | Louisiana | 22065 | 3255 | 58 |
2321691 | 2321691 | 2022-03-19 | Madison | Louisiana | 22065 | 3255 | 58 |
2318437 | 2318437 | 2022-03-18 | Madison | Louisiana | 22065 | 3255 | 58 |
2315184 | 2315184 | 2022-03-17 | Madison | Louisiana | 22065 | 3255 | 58 |
2311931 | 2311931 | 2022-03-16 | Madison | Louisiana | 22065 | 3255 | 58 |
2308678 | 2308678 | 2022-03-15 | Madison | Louisiana | 22065 | 3255 | 58 |
2305427 | 2305427 | 2022-03-14 | Madison | Louisiana | 22065 | 3255 | 58 |
2302175 | 2302175 | 2022-03-13 | Madison | Louisiana | 22065 | 3255 | 58 |
2298923 | 2298923 | 2022-03-12 | Madison | Louisiana | 22065 | 3255 | 58 |
2295671 | 2295671 | 2022-03-11 | Madison | Louisiana | 22065 | 3255 | 58 |
2292419 | 2292419 | 2022-03-10 | Madison | Louisiana | 22065 | 3255 | 58 |
2289167 | 2289167 | 2022-03-09 | Madison | Louisiana | 22065 | 3255 | 58 |
2285916 | 2285916 | 2022-03-08 | Madison | Louisiana | 22065 | 3255 | 58 |
2282664 | 2282664 | 2022-03-07 | Madison | Louisiana | 22065 | 3255 | 58 |
2279411 | 2279411 | 2022-03-06 | Madison | Louisiana | 22065 | 3255 | 58 |
2276158 | 2276158 | 2022-03-05 | Madison | Louisiana | 22065 | 3255 | 58 |
2272905 | 2272905 | 2022-03-04 | Madison | Louisiana | 22065 | 3255 | 58 |
2269653 | 2269653 | 2022-03-03 | Madison | Louisiana | 22065 | 3252 | 58 |
2266400 | 2266400 | 2022-03-02 | Madison | Louisiana | 22065 | 3251 | 58 |
2263149 | 2263149 | 2022-03-01 | Madison | Louisiana | 22065 | 3250 | 58 |
2259898 | 2259898 | 2022-02-28 | Madison | Louisiana | 22065 | 3250 | 58 |
2256647 | 2256647 | 2022-02-27 | Madison | Louisiana | 22065 | 3250 | 58 |
2253396 | 2253396 | 2022-02-26 | Madison | Louisiana | 22065 | 3250 | 58 |
2250145 | 2250145 | 2022-02-25 | Madison | Louisiana | 22065 | 3250 | 58 |
2246894 | 2246894 | 2022-02-24 | Madison | Louisiana | 22065 | 3250 | 58 |
2243643 | 2243643 | 2022-02-23 | Madison | Louisiana | 22065 | 3247 | 58 |
2240392 | 2240392 | 2022-02-22 | Madison | Louisiana | 22065 | 3246 | 58 |
2237141 | 2237141 | 2022-02-21 | Madison | Louisiana | 22065 | 3245 | 58 |
2233890 | 2233890 | 2022-02-20 | Madison | Louisiana | 22065 | 3240 | 58 |
2230639 | 2230639 | 2022-02-19 | Madison | Louisiana | 22065 | 3240 | 58 |
2227388 | 2227388 | 2022-02-18 | Madison | Louisiana | 22065 | 3240 | 58 |
2224137 | 2224137 | 2022-02-17 | Madison | Louisiana | 22065 | 3236 | 58 |
2220886 | 2220886 | 2022-02-16 | Madison | Louisiana | 22065 | 3232 | 58 |
2217635 | 2217635 | 2022-02-15 | Madison | Louisiana | 22065 | 3230 | 58 |
2214384 | 2214384 | 2022-02-14 | Madison | Louisiana | 22065 | 3226 | 58 |
2211132 | 2211132 | 2022-02-13 | Madison | Louisiana | 22065 | 3209 | 58 |
2207879 | 2207879 | 2022-02-12 | Madison | Louisiana | 22065 | 3209 | 58 |
2204626 | 2204626 | 2022-02-11 | Madison | Louisiana | 22065 | 3209 | 58 |
2201373 | 2201373 | 2022-02-10 | Madison | Louisiana | 22065 | 3202 | 58 |
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);