ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Webster" and state = "Louisiana" 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 |
---|---|---|---|---|---|---|---|
2500759 | 2500759 | 2022-05-13 | Webster | Louisiana | 22119 | 11145 | 186 |
2497501 | 2497501 | 2022-05-12 | Webster | Louisiana | 22119 | 11141 | 186 |
2494243 | 2494243 | 2022-05-11 | Webster | Louisiana | 22119 | 11138 | 186 |
2490985 | 2490985 | 2022-05-10 | Webster | Louisiana | 22119 | 11131 | 186 |
2487728 | 2487728 | 2022-05-09 | Webster | Louisiana | 22119 | 11128 | 186 |
2484470 | 2484470 | 2022-05-08 | Webster | Louisiana | 22119 | 11113 | 186 |
2481212 | 2481212 | 2022-05-07 | Webster | Louisiana | 22119 | 11113 | 186 |
2477954 | 2477954 | 2022-05-06 | Webster | Louisiana | 22119 | 11113 | 186 |
2474696 | 2474696 | 2022-05-05 | Webster | Louisiana | 22119 | 11112 | 186 |
2471439 | 2471439 | 2022-05-04 | Webster | Louisiana | 22119 | 11112 | 186 |
2468183 | 2468183 | 2022-05-03 | Webster | Louisiana | 22119 | 11111 | 186 |
2464928 | 2464928 | 2022-05-02 | Webster | Louisiana | 22119 | 11109 | 186 |
2461672 | 2461672 | 2022-05-01 | Webster | Louisiana | 22119 | 11106 | 186 |
2458416 | 2458416 | 2022-04-30 | Webster | Louisiana | 22119 | 11106 | 186 |
2455160 | 2455160 | 2022-04-29 | Webster | Louisiana | 22119 | 11106 | 186 |
2451904 | 2451904 | 2022-04-28 | Webster | Louisiana | 22119 | 11106 | 186 |
2448648 | 2448648 | 2022-04-27 | Webster | Louisiana | 22119 | 11106 | 186 |
2445392 | 2445392 | 2022-04-26 | Webster | Louisiana | 22119 | 11105 | 185 |
2442136 | 2442136 | 2022-04-25 | Webster | Louisiana | 22119 | 11104 | 185 |
2438880 | 2438880 | 2022-04-24 | Webster | Louisiana | 22119 | 11100 | 184 |
2435624 | 2435624 | 2022-04-23 | Webster | Louisiana | 22119 | 11100 | 184 |
2432368 | 2432368 | 2022-04-22 | Webster | Louisiana | 22119 | 11100 | 184 |
2429112 | 2429112 | 2022-04-21 | Webster | Louisiana | 22119 | 11100 | 184 |
2425856 | 2425856 | 2022-04-20 | Webster | Louisiana | 22119 | 11100 | 184 |
2422600 | 2422600 | 2022-04-19 | Webster | Louisiana | 22119 | 11098 | 183 |
2419344 | 2419344 | 2022-04-18 | Webster | Louisiana | 22119 | 11098 | 183 |
2416088 | 2416088 | 2022-04-17 | Webster | Louisiana | 22119 | 11098 | 183 |
2412832 | 2412832 | 2022-04-16 | Webster | Louisiana | 22119 | 11098 | 183 |
2409576 | 2409576 | 2022-04-15 | Webster | Louisiana | 22119 | 11098 | 183 |
2406320 | 2406320 | 2022-04-14 | Webster | Louisiana | 22119 | 11098 | 183 |
2403064 | 2403064 | 2022-04-13 | Webster | Louisiana | 22119 | 11098 | 183 |
2399810 | 2399810 | 2022-04-12 | Webster | Louisiana | 22119 | 11098 | 183 |
2396554 | 2396554 | 2022-04-11 | Webster | Louisiana | 22119 | 11097 | 183 |
2393299 | 2393299 | 2022-04-10 | Webster | Louisiana | 22119 | 11096 | 183 |
2390043 | 2390043 | 2022-04-09 | Webster | Louisiana | 22119 | 11096 | 183 |
2386787 | 2386787 | 2022-04-08 | Webster | Louisiana | 22119 | 11096 | 183 |
2383532 | 2383532 | 2022-04-07 | Webster | Louisiana | 22119 | 11096 | 183 |
2380277 | 2380277 | 2022-04-06 | Webster | Louisiana | 22119 | 11094 | 183 |
2377022 | 2377022 | 2022-04-05 | Webster | Louisiana | 22119 | 11092 | 183 |
2373770 | 2373770 | 2022-04-04 | Webster | Louisiana | 22119 | 11091 | 183 |
2370517 | 2370517 | 2022-04-03 | Webster | Louisiana | 22119 | 11089 | 183 |
2367264 | 2367264 | 2022-04-02 | Webster | Louisiana | 22119 | 11089 | 183 |
2364011 | 2364011 | 2022-04-01 | Webster | Louisiana | 22119 | 11089 | 183 |
2360757 | 2360757 | 2022-03-31 | Webster | Louisiana | 22119 | 11088 | 182 |
2357503 | 2357503 | 2022-03-30 | Webster | Louisiana | 22119 | 11087 | 182 |
2354250 | 2354250 | 2022-03-29 | Webster | Louisiana | 22119 | 11087 | 183 |
2350998 | 2350998 | 2022-03-28 | Webster | Louisiana | 22119 | 11086 | 183 |
2347745 | 2347745 | 2022-03-27 | Webster | Louisiana | 22119 | 11085 | 182 |
2344492 | 2344492 | 2022-03-26 | Webster | Louisiana | 22119 | 11085 | 182 |
2341239 | 2341239 | 2022-03-25 | Webster | Louisiana | 22119 | 11085 | 182 |
2337986 | 2337986 | 2022-03-24 | Webster | Louisiana | 22119 | 11084 | 182 |
2334732 | 2334732 | 2022-03-23 | Webster | Louisiana | 22119 | 11083 | 182 |
2331478 | 2331478 | 2022-03-22 | Webster | Louisiana | 22119 | 11083 | 182 |
2328226 | 2328226 | 2022-03-21 | Webster | Louisiana | 22119 | 11082 | 182 |
2324973 | 2324973 | 2022-03-20 | Webster | Louisiana | 22119 | 11081 | 181 |
2321719 | 2321719 | 2022-03-19 | Webster | Louisiana | 22119 | 11081 | 181 |
2318465 | 2318465 | 2022-03-18 | Webster | Louisiana | 22119 | 11081 | 181 |
2315212 | 2315212 | 2022-03-17 | Webster | Louisiana | 22119 | 11081 | 181 |
2311959 | 2311959 | 2022-03-16 | Webster | Louisiana | 22119 | 11080 | 180 |
2308706 | 2308706 | 2022-03-15 | Webster | Louisiana | 22119 | 11079 | 179 |
2305455 | 2305455 | 2022-03-14 | Webster | Louisiana | 22119 | 11079 | 178 |
2302203 | 2302203 | 2022-03-13 | Webster | Louisiana | 22119 | 11078 | 177 |
2298951 | 2298951 | 2022-03-12 | Webster | Louisiana | 22119 | 11078 | 177 |
2295699 | 2295699 | 2022-03-11 | Webster | Louisiana | 22119 | 11078 | 177 |
2292447 | 2292447 | 2022-03-10 | Webster | Louisiana | 22119 | 11078 | 175 |
2289195 | 2289195 | 2022-03-09 | Webster | Louisiana | 22119 | 11077 | 175 |
2285944 | 2285944 | 2022-03-08 | Webster | Louisiana | 22119 | 11076 | 175 |
2282692 | 2282692 | 2022-03-07 | Webster | Louisiana | 22119 | 11073 | 175 |
2279439 | 2279439 | 2022-03-06 | Webster | Louisiana | 22119 | 11072 | 175 |
2276186 | 2276186 | 2022-03-05 | Webster | Louisiana | 22119 | 11072 | 175 |
2272933 | 2272933 | 2022-03-04 | Webster | Louisiana | 22119 | 11072 | 175 |
2269681 | 2269681 | 2022-03-03 | Webster | Louisiana | 22119 | 11068 | 174 |
2266428 | 2266428 | 2022-03-02 | Webster | Louisiana | 22119 | 11061 | 170 |
2263177 | 2263177 | 2022-03-01 | Webster | Louisiana | 22119 | 11046 | 169 |
2259926 | 2259926 | 2022-02-28 | Webster | Louisiana | 22119 | 11046 | 169 |
2256675 | 2256675 | 2022-02-27 | Webster | Louisiana | 22119 | 11046 | 169 |
2253424 | 2253424 | 2022-02-26 | Webster | Louisiana | 22119 | 11046 | 169 |
2250173 | 2250173 | 2022-02-25 | Webster | Louisiana | 22119 | 11046 | 169 |
2246922 | 2246922 | 2022-02-24 | Webster | Louisiana | 22119 | 11042 | 169 |
2243671 | 2243671 | 2022-02-23 | Webster | Louisiana | 22119 | 11034 | 169 |
2240420 | 2240420 | 2022-02-22 | Webster | Louisiana | 22119 | 11025 | 169 |
2237169 | 2237169 | 2022-02-21 | Webster | Louisiana | 22119 | 11018 | 168 |
2233918 | 2233918 | 2022-02-20 | Webster | Louisiana | 22119 | 11000 | 168 |
2230667 | 2230667 | 2022-02-19 | Webster | Louisiana | 22119 | 11000 | 168 |
2227416 | 2227416 | 2022-02-18 | Webster | Louisiana | 22119 | 11000 | 168 |
2224165 | 2224165 | 2022-02-17 | Webster | Louisiana | 22119 | 10990 | 167 |
2220914 | 2220914 | 2022-02-16 | Webster | Louisiana | 22119 | 10974 | 165 |
2217663 | 2217663 | 2022-02-15 | Webster | Louisiana | 22119 | 10954 | 165 |
2214412 | 2214412 | 2022-02-14 | Webster | Louisiana | 22119 | 10934 | 165 |
2211160 | 2211160 | 2022-02-13 | Webster | Louisiana | 22119 | 10911 | 162 |
2207907 | 2207907 | 2022-02-12 | Webster | Louisiana | 22119 | 10911 | 162 |
2204654 | 2204654 | 2022-02-11 | Webster | Louisiana | 22119 | 10911 | 162 |
2201401 | 2201401 | 2022-02-10 | Webster | Louisiana | 22119 | 10882 | 160 |
2198147 | 2198147 | 2022-02-09 | Webster | Louisiana | 22119 | 10863 | 160 |
2194893 | 2194893 | 2022-02-08 | Webster | Louisiana | 22119 | 10822 | 159 |
2191639 | 2191639 | 2022-02-07 | Webster | Louisiana | 22119 | 10792 | 158 |
2188386 | 2188386 | 2022-02-06 | Webster | Louisiana | 22119 | 10722 | 158 |
2185133 | 2185133 | 2022-02-05 | Webster | Louisiana | 22119 | 10722 | 158 |
2181881 | 2181881 | 2022-02-04 | Webster | Louisiana | 22119 | 10722 | 158 |
2178630 | 2178630 | 2022-02-03 | Webster | Louisiana | 22119 | 10692 | 158 |
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);