ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Beauregard" 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 |
---|---|---|---|---|---|---|---|
2500704 | 2500704 | 2022-05-13 | Beauregard | Louisiana | 22011 | 9271 | 143 |
2497446 | 2497446 | 2022-05-12 | Beauregard | Louisiana | 22011 | 9269 | 143 |
2494188 | 2494188 | 2022-05-11 | Beauregard | Louisiana | 22011 | 9267 | 143 |
2490930 | 2490930 | 2022-05-10 | Beauregard | Louisiana | 22011 | 9267 | 143 |
2487673 | 2487673 | 2022-05-09 | Beauregard | Louisiana | 22011 | 9262 | 143 |
2484415 | 2484415 | 2022-05-08 | Beauregard | Louisiana | 22011 | 9261 | 143 |
2481157 | 2481157 | 2022-05-07 | Beauregard | Louisiana | 22011 | 9261 | 143 |
2477899 | 2477899 | 2022-05-06 | Beauregard | Louisiana | 22011 | 9261 | 143 |
2474641 | 2474641 | 2022-05-05 | Beauregard | Louisiana | 22011 | 9257 | 143 |
2471384 | 2471384 | 2022-05-04 | Beauregard | Louisiana | 22011 | 9257 | 143 |
2468128 | 2468128 | 2022-05-03 | Beauregard | Louisiana | 22011 | 9256 | 143 |
2464873 | 2464873 | 2022-05-02 | Beauregard | Louisiana | 22011 | 9256 | 143 |
2461617 | 2461617 | 2022-05-01 | Beauregard | Louisiana | 22011 | 9256 | 143 |
2458361 | 2458361 | 2022-04-30 | Beauregard | Louisiana | 22011 | 9256 | 143 |
2455105 | 2455105 | 2022-04-29 | Beauregard | Louisiana | 22011 | 9256 | 143 |
2451849 | 2451849 | 2022-04-28 | Beauregard | Louisiana | 22011 | 9256 | 143 |
2448593 | 2448593 | 2022-04-27 | Beauregard | Louisiana | 22011 | 9256 | 142 |
2445337 | 2445337 | 2022-04-26 | Beauregard | Louisiana | 22011 | 9256 | 142 |
2442081 | 2442081 | 2022-04-25 | Beauregard | Louisiana | 22011 | 9253 | 142 |
2438825 | 2438825 | 2022-04-24 | Beauregard | Louisiana | 22011 | 9253 | 142 |
2435569 | 2435569 | 2022-04-23 | Beauregard | Louisiana | 22011 | 9253 | 142 |
2432313 | 2432313 | 2022-04-22 | Beauregard | Louisiana | 22011 | 9253 | 142 |
2429057 | 2429057 | 2022-04-21 | Beauregard | Louisiana | 22011 | 9253 | 142 |
2425801 | 2425801 | 2022-04-20 | Beauregard | Louisiana | 22011 | 9251 | 142 |
2422545 | 2422545 | 2022-04-19 | Beauregard | Louisiana | 22011 | 9251 | 142 |
2419289 | 2419289 | 2022-04-18 | Beauregard | Louisiana | 22011 | 9251 | 142 |
2416033 | 2416033 | 2022-04-17 | Beauregard | Louisiana | 22011 | 9250 | 142 |
2412777 | 2412777 | 2022-04-16 | Beauregard | Louisiana | 22011 | 9250 | 142 |
2409521 | 2409521 | 2022-04-15 | Beauregard | Louisiana | 22011 | 9250 | 142 |
2406265 | 2406265 | 2022-04-14 | Beauregard | Louisiana | 22011 | 9250 | 142 |
2403009 | 2403009 | 2022-04-13 | Beauregard | Louisiana | 22011 | 9250 | 142 |
2399755 | 2399755 | 2022-04-12 | Beauregard | Louisiana | 22011 | 9250 | 142 |
2396499 | 2396499 | 2022-04-11 | Beauregard | Louisiana | 22011 | 9250 | 142 |
2393244 | 2393244 | 2022-04-10 | Beauregard | Louisiana | 22011 | 9248 | 142 |
2389988 | 2389988 | 2022-04-09 | Beauregard | Louisiana | 22011 | 9248 | 142 |
2386732 | 2386732 | 2022-04-08 | Beauregard | Louisiana | 22011 | 9248 | 142 |
2383477 | 2383477 | 2022-04-07 | Beauregard | Louisiana | 22011 | 9248 | 142 |
2380222 | 2380222 | 2022-04-06 | Beauregard | Louisiana | 22011 | 9247 | 142 |
2376967 | 2376967 | 2022-04-05 | Beauregard | Louisiana | 22011 | 9247 | 142 |
2373715 | 2373715 | 2022-04-04 | Beauregard | Louisiana | 22011 | 9246 | 142 |
2370462 | 2370462 | 2022-04-03 | Beauregard | Louisiana | 22011 | 9246 | 142 |
2367209 | 2367209 | 2022-04-02 | Beauregard | Louisiana | 22011 | 9246 | 142 |
2363956 | 2363956 | 2022-04-01 | Beauregard | Louisiana | 22011 | 9246 | 142 |
2360702 | 2360702 | 2022-03-31 | Beauregard | Louisiana | 22011 | 9245 | 142 |
2357448 | 2357448 | 2022-03-30 | Beauregard | Louisiana | 22011 | 9245 | 142 |
2354195 | 2354195 | 2022-03-29 | Beauregard | Louisiana | 22011 | 9244 | 142 |
2350943 | 2350943 | 2022-03-28 | Beauregard | Louisiana | 22011 | 9244 | 142 |
2347690 | 2347690 | 2022-03-27 | Beauregard | Louisiana | 22011 | 9244 | 142 |
2344437 | 2344437 | 2022-03-26 | Beauregard | Louisiana | 22011 | 9244 | 142 |
2341184 | 2341184 | 2022-03-25 | Beauregard | Louisiana | 22011 | 9244 | 142 |
2337931 | 2337931 | 2022-03-24 | Beauregard | Louisiana | 22011 | 9244 | 142 |
2334677 | 2334677 | 2022-03-23 | Beauregard | Louisiana | 22011 | 9244 | 142 |
2331423 | 2331423 | 2022-03-22 | Beauregard | Louisiana | 22011 | 9244 | 142 |
2328171 | 2328171 | 2022-03-21 | Beauregard | Louisiana | 22011 | 9243 | 142 |
2324918 | 2324918 | 2022-03-20 | Beauregard | Louisiana | 22011 | 9241 | 141 |
2321664 | 2321664 | 2022-03-19 | Beauregard | Louisiana | 22011 | 9241 | 141 |
2318410 | 2318410 | 2022-03-18 | Beauregard | Louisiana | 22011 | 9241 | 141 |
2315157 | 2315157 | 2022-03-17 | Beauregard | Louisiana | 22011 | 9239 | 141 |
2311904 | 2311904 | 2022-03-16 | Beauregard | Louisiana | 22011 | 9238 | 141 |
2308651 | 2308651 | 2022-03-15 | Beauregard | Louisiana | 22011 | 9237 | 141 |
2305400 | 2305400 | 2022-03-14 | Beauregard | Louisiana | 22011 | 9235 | 141 |
2302148 | 2302148 | 2022-03-13 | Beauregard | Louisiana | 22011 | 9232 | 140 |
2298896 | 2298896 | 2022-03-12 | Beauregard | Louisiana | 22011 | 9232 | 140 |
2295644 | 2295644 | 2022-03-11 | Beauregard | Louisiana | 22011 | 9232 | 140 |
2292392 | 2292392 | 2022-03-10 | Beauregard | Louisiana | 22011 | 9230 | 140 |
2289140 | 2289140 | 2022-03-09 | Beauregard | Louisiana | 22011 | 9230 | 140 |
2285889 | 2285889 | 2022-03-08 | Beauregard | Louisiana | 22011 | 9228 | 140 |
2282637 | 2282637 | 2022-03-07 | Beauregard | Louisiana | 22011 | 9226 | 140 |
2279384 | 2279384 | 2022-03-06 | Beauregard | Louisiana | 22011 | 9225 | 140 |
2276131 | 2276131 | 2022-03-05 | Beauregard | Louisiana | 22011 | 9225 | 140 |
2272878 | 2272878 | 2022-03-04 | Beauregard | Louisiana | 22011 | 9225 | 140 |
2269626 | 2269626 | 2022-03-03 | Beauregard | Louisiana | 22011 | 9224 | 138 |
2266373 | 2266373 | 2022-03-02 | Beauregard | Louisiana | 22011 | 9223 | 138 |
2263122 | 2263122 | 2022-03-01 | Beauregard | Louisiana | 22011 | 9211 | 137 |
2259871 | 2259871 | 2022-02-28 | Beauregard | Louisiana | 22011 | 9211 | 137 |
2256620 | 2256620 | 2022-02-27 | Beauregard | Louisiana | 22011 | 9211 | 137 |
2253369 | 2253369 | 2022-02-26 | Beauregard | Louisiana | 22011 | 9211 | 137 |
2250118 | 2250118 | 2022-02-25 | Beauregard | Louisiana | 22011 | 9211 | 137 |
2246867 | 2246867 | 2022-02-24 | Beauregard | Louisiana | 22011 | 9209 | 137 |
2243616 | 2243616 | 2022-02-23 | Beauregard | Louisiana | 22011 | 9203 | 137 |
2240365 | 2240365 | 2022-02-22 | Beauregard | Louisiana | 22011 | 9198 | 137 |
2237114 | 2237114 | 2022-02-21 | Beauregard | Louisiana | 22011 | 9191 | 137 |
2233863 | 2233863 | 2022-02-20 | Beauregard | Louisiana | 22011 | 9180 | 135 |
2230612 | 2230612 | 2022-02-19 | Beauregard | Louisiana | 22011 | 9180 | 135 |
2227361 | 2227361 | 2022-02-18 | Beauregard | Louisiana | 22011 | 9180 | 135 |
2224110 | 2224110 | 2022-02-17 | Beauregard | Louisiana | 22011 | 9168 | 135 |
2220859 | 2220859 | 2022-02-16 | Beauregard | Louisiana | 22011 | 9161 | 135 |
2217608 | 2217608 | 2022-02-15 | Beauregard | Louisiana | 22011 | 9145 | 135 |
2214357 | 2214357 | 2022-02-14 | Beauregard | Louisiana | 22011 | 9141 | 134 |
2211105 | 2211105 | 2022-02-13 | Beauregard | Louisiana | 22011 | 9098 | 134 |
2207852 | 2207852 | 2022-02-12 | Beauregard | Louisiana | 22011 | 9098 | 134 |
2204599 | 2204599 | 2022-02-11 | Beauregard | Louisiana | 22011 | 9098 | 134 |
2201346 | 2201346 | 2022-02-10 | Beauregard | Louisiana | 22011 | 9078 | 134 |
2198092 | 2198092 | 2022-02-09 | Beauregard | Louisiana | 22011 | 9061 | 134 |
2194838 | 2194838 | 2022-02-08 | Beauregard | Louisiana | 22011 | 9043 | 134 |
2191584 | 2191584 | 2022-02-07 | Beauregard | Louisiana | 22011 | 9022 | 133 |
2188331 | 2188331 | 2022-02-06 | Beauregard | Louisiana | 22011 | 8948 | 133 |
2185078 | 2185078 | 2022-02-05 | Beauregard | Louisiana | 22011 | 8948 | 133 |
2181826 | 2181826 | 2022-02-04 | Beauregard | Louisiana | 22011 | 8948 | 133 |
2178575 | 2178575 | 2022-02-03 | Beauregard | Louisiana | 22011 | 8753 | 133 |
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);