ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 22101 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 |
---|---|---|---|---|---|---|---|
2500749 | 2500749 | 2022-05-13 | St. Mary | Louisiana | 22101 | 12526 | 262 |
2497491 | 2497491 | 2022-05-12 | St. Mary | Louisiana | 22101 | 12522 | 262 |
2494233 | 2494233 | 2022-05-11 | St. Mary | Louisiana | 22101 | 12516 | 262 |
2490975 | 2490975 | 2022-05-10 | St. Mary | Louisiana | 22101 | 12513 | 262 |
2487718 | 2487718 | 2022-05-09 | St. Mary | Louisiana | 22101 | 12512 | 262 |
2484460 | 2484460 | 2022-05-08 | St. Mary | Louisiana | 22101 | 12510 | 262 |
2481202 | 2481202 | 2022-05-07 | St. Mary | Louisiana | 22101 | 12510 | 262 |
2477944 | 2477944 | 2022-05-06 | St. Mary | Louisiana | 22101 | 12510 | 262 |
2474686 | 2474686 | 2022-05-05 | St. Mary | Louisiana | 22101 | 12507 | 262 |
2471429 | 2471429 | 2022-05-04 | St. Mary | Louisiana | 22101 | 12507 | 262 |
2468173 | 2468173 | 2022-05-03 | St. Mary | Louisiana | 22101 | 12504 | 262 |
2464918 | 2464918 | 2022-05-02 | St. Mary | Louisiana | 22101 | 12500 | 262 |
2461662 | 2461662 | 2022-05-01 | St. Mary | Louisiana | 22101 | 12500 | 262 |
2458406 | 2458406 | 2022-04-30 | St. Mary | Louisiana | 22101 | 12500 | 262 |
2455150 | 2455150 | 2022-04-29 | St. Mary | Louisiana | 22101 | 12500 | 262 |
2451894 | 2451894 | 2022-04-28 | St. Mary | Louisiana | 22101 | 12500 | 262 |
2448638 | 2448638 | 2022-04-27 | St. Mary | Louisiana | 22101 | 12498 | 262 |
2445382 | 2445382 | 2022-04-26 | St. Mary | Louisiana | 22101 | 12494 | 262 |
2442126 | 2442126 | 2022-04-25 | St. Mary | Louisiana | 22101 | 12493 | 262 |
2438870 | 2438870 | 2022-04-24 | St. Mary | Louisiana | 22101 | 12491 | 262 |
2435614 | 2435614 | 2022-04-23 | St. Mary | Louisiana | 22101 | 12491 | 262 |
2432358 | 2432358 | 2022-04-22 | St. Mary | Louisiana | 22101 | 12491 | 262 |
2429102 | 2429102 | 2022-04-21 | St. Mary | Louisiana | 22101 | 12489 | 262 |
2425846 | 2425846 | 2022-04-20 | St. Mary | Louisiana | 22101 | 12486 | 262 |
2422590 | 2422590 | 2022-04-19 | St. Mary | Louisiana | 22101 | 12485 | 262 |
2419334 | 2419334 | 2022-04-18 | St. Mary | Louisiana | 22101 | 12483 | 262 |
2416078 | 2416078 | 2022-04-17 | St. Mary | Louisiana | 22101 | 12481 | 262 |
2412822 | 2412822 | 2022-04-16 | St. Mary | Louisiana | 22101 | 12481 | 262 |
2409566 | 2409566 | 2022-04-15 | St. Mary | Louisiana | 22101 | 12481 | 262 |
2406310 | 2406310 | 2022-04-14 | St. Mary | Louisiana | 22101 | 12481 | 262 |
2403054 | 2403054 | 2022-04-13 | St. Mary | Louisiana | 22101 | 12477 | 262 |
2399800 | 2399800 | 2022-04-12 | St. Mary | Louisiana | 22101 | 12474 | 262 |
2396544 | 2396544 | 2022-04-11 | St. Mary | Louisiana | 22101 | 12473 | 262 |
2393289 | 2393289 | 2022-04-10 | St. Mary | Louisiana | 22101 | 12471 | 261 |
2390033 | 2390033 | 2022-04-09 | St. Mary | Louisiana | 22101 | 12471 | 261 |
2386777 | 2386777 | 2022-04-08 | St. Mary | Louisiana | 22101 | 12471 | 261 |
2383522 | 2383522 | 2022-04-07 | St. Mary | Louisiana | 22101 | 12469 | 261 |
2380267 | 2380267 | 2022-04-06 | St. Mary | Louisiana | 22101 | 12469 | 261 |
2377012 | 2377012 | 2022-04-05 | St. Mary | Louisiana | 22101 | 12467 | 261 |
2373760 | 2373760 | 2022-04-04 | St. Mary | Louisiana | 22101 | 12466 | 261 |
2370507 | 2370507 | 2022-04-03 | St. Mary | Louisiana | 22101 | 12465 | 261 |
2367254 | 2367254 | 2022-04-02 | St. Mary | Louisiana | 22101 | 12465 | 261 |
2364001 | 2364001 | 2022-04-01 | St. Mary | Louisiana | 22101 | 12465 | 261 |
2360747 | 2360747 | 2022-03-31 | St. Mary | Louisiana | 22101 | 12464 | 261 |
2357493 | 2357493 | 2022-03-30 | St. Mary | Louisiana | 22101 | 12463 | 260 |
2354240 | 2354240 | 2022-03-29 | St. Mary | Louisiana | 22101 | 12462 | 260 |
2350988 | 2350988 | 2022-03-28 | St. Mary | Louisiana | 22101 | 12461 | 260 |
2347735 | 2347735 | 2022-03-27 | St. Mary | Louisiana | 22101 | 12458 | 260 |
2344482 | 2344482 | 2022-03-26 | St. Mary | Louisiana | 22101 | 12458 | 260 |
2341229 | 2341229 | 2022-03-25 | St. Mary | Louisiana | 22101 | 12458 | 260 |
2337976 | 2337976 | 2022-03-24 | St. Mary | Louisiana | 22101 | 12458 | 260 |
2334722 | 2334722 | 2022-03-23 | St. Mary | Louisiana | 22101 | 12457 | 260 |
2331468 | 2331468 | 2022-03-22 | St. Mary | Louisiana | 22101 | 12457 | 260 |
2328216 | 2328216 | 2022-03-21 | St. Mary | Louisiana | 22101 | 12457 | 260 |
2324963 | 2324963 | 2022-03-20 | St. Mary | Louisiana | 22101 | 12456 | 259 |
2321709 | 2321709 | 2022-03-19 | St. Mary | Louisiana | 22101 | 12456 | 259 |
2318455 | 2318455 | 2022-03-18 | St. Mary | Louisiana | 22101 | 12456 | 259 |
2315202 | 2315202 | 2022-03-17 | St. Mary | Louisiana | 22101 | 12456 | 259 |
2311949 | 2311949 | 2022-03-16 | St. Mary | Louisiana | 22101 | 12455 | 259 |
2308696 | 2308696 | 2022-03-15 | St. Mary | Louisiana | 22101 | 12455 | 259 |
2305445 | 2305445 | 2022-03-14 | St. Mary | Louisiana | 22101 | 12455 | 258 |
2302193 | 2302193 | 2022-03-13 | St. Mary | Louisiana | 22101 | 12451 | 258 |
2298941 | 2298941 | 2022-03-12 | St. Mary | Louisiana | 22101 | 12451 | 258 |
2295689 | 2295689 | 2022-03-11 | St. Mary | Louisiana | 22101 | 12451 | 258 |
2292437 | 2292437 | 2022-03-10 | St. Mary | Louisiana | 22101 | 12450 | 258 |
2289185 | 2289185 | 2022-03-09 | St. Mary | Louisiana | 22101 | 12450 | 258 |
2285934 | 2285934 | 2022-03-08 | St. Mary | Louisiana | 22101 | 12447 | 258 |
2282682 | 2282682 | 2022-03-07 | St. Mary | Louisiana | 22101 | 12442 | 256 |
2279429 | 2279429 | 2022-03-06 | St. Mary | Louisiana | 22101 | 12439 | 256 |
2276176 | 2276176 | 2022-03-05 | St. Mary | Louisiana | 22101 | 12439 | 256 |
2272923 | 2272923 | 2022-03-04 | St. Mary | Louisiana | 22101 | 12439 | 256 |
2269671 | 2269671 | 2022-03-03 | St. Mary | Louisiana | 22101 | 12435 | 256 |
2266418 | 2266418 | 2022-03-02 | St. Mary | Louisiana | 22101 | 12432 | 256 |
2263167 | 2263167 | 2022-03-01 | St. Mary | Louisiana | 22101 | 12420 | 255 |
2259916 | 2259916 | 2022-02-28 | St. Mary | Louisiana | 22101 | 12420 | 255 |
2256665 | 2256665 | 2022-02-27 | St. Mary | Louisiana | 22101 | 12420 | 255 |
2253414 | 2253414 | 2022-02-26 | St. Mary | Louisiana | 22101 | 12420 | 255 |
2250163 | 2250163 | 2022-02-25 | St. Mary | Louisiana | 22101 | 12420 | 255 |
2246912 | 2246912 | 2022-02-24 | St. Mary | Louisiana | 22101 | 12414 | 255 |
2243661 | 2243661 | 2022-02-23 | St. Mary | Louisiana | 22101 | 12404 | 255 |
2240410 | 2240410 | 2022-02-22 | St. Mary | Louisiana | 22101 | 12397 | 255 |
2237159 | 2237159 | 2022-02-21 | St. Mary | Louisiana | 22101 | 12385 | 253 |
2233908 | 2233908 | 2022-02-20 | St. Mary | Louisiana | 22101 | 12363 | 252 |
2230657 | 2230657 | 2022-02-19 | St. Mary | Louisiana | 22101 | 12363 | 252 |
2227406 | 2227406 | 2022-02-18 | St. Mary | Louisiana | 22101 | 12363 | 252 |
2224155 | 2224155 | 2022-02-17 | St. Mary | Louisiana | 22101 | 12349 | 252 |
2220904 | 2220904 | 2022-02-16 | St. Mary | Louisiana | 22101 | 12339 | 252 |
2217653 | 2217653 | 2022-02-15 | St. Mary | Louisiana | 22101 | 12325 | 252 |
2214402 | 2214402 | 2022-02-14 | St. Mary | Louisiana | 22101 | 12312 | 252 |
2211150 | 2211150 | 2022-02-13 | St. Mary | Louisiana | 22101 | 12276 | 252 |
2207897 | 2207897 | 2022-02-12 | St. Mary | Louisiana | 22101 | 12276 | 252 |
2204644 | 2204644 | 2022-02-11 | St. Mary | Louisiana | 22101 | 12276 | 252 |
2201391 | 2201391 | 2022-02-10 | St. Mary | Louisiana | 22101 | 12256 | 252 |
2198137 | 2198137 | 2022-02-09 | St. Mary | Louisiana | 22101 | 12226 | 251 |
2194883 | 2194883 | 2022-02-08 | St. Mary | Louisiana | 22101 | 12200 | 251 |
2191629 | 2191629 | 2022-02-07 | St. Mary | Louisiana | 22101 | 12153 | 251 |
2188376 | 2188376 | 2022-02-06 | St. Mary | Louisiana | 22101 | 12091 | 251 |
2185123 | 2185123 | 2022-02-05 | St. Mary | Louisiana | 22101 | 12091 | 251 |
2181871 | 2181871 | 2022-02-04 | St. Mary | Louisiana | 22101 | 12091 | 251 |
2178620 | 2178620 | 2022-02-03 | St. Mary | Louisiana | 22101 | 12059 | 250 |
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);