ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,510 rows where county = "Lane" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337751 | 2337751 | 2022-03-24 | Lane | Kansas | 20101 | 295 | 12 |
2339056 | 2339056 | 2022-03-24 | Lane | Oregon | 41039 | 57027 | 496 |
2334497 | 2334497 | 2022-03-23 | Lane | Kansas | 20101 | 295 | 12 |
2335802 | 2335802 | 2022-03-23 | Lane | Oregon | 41039 | 56995 | 495 |
2331243 | 2331243 | 2022-03-22 | Lane | Kansas | 20101 | 295 | 12 |
2332548 | 2332548 | 2022-03-22 | Lane | Oregon | 41039 | 56970 | 492 |
2327991 | 2327991 | 2022-03-21 | Lane | Kansas | 20101 | 295 | 12 |
2329295 | 2329295 | 2022-03-21 | Lane | Oregon | 41039 | 56928 | 490 |
2324738 | 2324738 | 2022-03-20 | Lane | Kansas | 20101 | 295 | 12 |
2326043 | 2326043 | 2022-03-20 | Lane | Oregon | 41039 | 56882 | 490 |
2321484 | 2321484 | 2022-03-19 | Lane | Kansas | 20101 | 295 | 12 |
2322790 | 2322790 | 2022-03-19 | Lane | Oregon | 41039 | 56882 | 490 |
2318230 | 2318230 | 2022-03-18 | Lane | Kansas | 20101 | 295 | 12 |
2319536 | 2319536 | 2022-03-18 | Lane | Oregon | 41039 | 56882 | 490 |
2314977 | 2314977 | 2022-03-17 | Lane | Kansas | 20101 | 295 | 12 |
2316282 | 2316282 | 2022-03-17 | Lane | Oregon | 41039 | 56859 | 489 |
2311724 | 2311724 | 2022-03-16 | Lane | Kansas | 20101 | 295 | 12 |
2313029 | 2313029 | 2022-03-16 | Lane | Oregon | 41039 | 56827 | 486 |
2308471 | 2308471 | 2022-03-15 | Lane | Kansas | 20101 | 294 | 11 |
2309776 | 2309776 | 2022-03-15 | Lane | Oregon | 41039 | 56801 | 485 |
2305220 | 2305220 | 2022-03-14 | Lane | Kansas | 20101 | 294 | 11 |
2306523 | 2306523 | 2022-03-14 | Lane | Oregon | 41039 | 56756 | 484 |
2301968 | 2301968 | 2022-03-13 | Lane | Kansas | 20101 | 295 | 11 |
2303272 | 2303272 | 2022-03-13 | Lane | Oregon | 41039 | 56677 | 480 |
2298716 | 2298716 | 2022-03-12 | Lane | Kansas | 20101 | 295 | 11 |
2300020 | 2300020 | 2022-03-12 | Lane | Oregon | 41039 | 56677 | 480 |
2295464 | 2295464 | 2022-03-11 | Lane | Kansas | 20101 | 295 | 11 |
2296768 | 2296768 | 2022-03-11 | Lane | Oregon | 41039 | 56677 | 480 |
2292212 | 2292212 | 2022-03-10 | Lane | Kansas | 20101 | 295 | 11 |
2293516 | 2293516 | 2022-03-10 | Lane | Oregon | 41039 | 56646 | 477 |
2288960 | 2288960 | 2022-03-09 | Lane | Kansas | 20101 | 295 | 11 |
2290264 | 2290264 | 2022-03-09 | Lane | Oregon | 41039 | 56610 | 475 |
2285709 | 2285709 | 2022-03-08 | Lane | Kansas | 20101 | 295 | 11 |
2287012 | 2287012 | 2022-03-08 | Lane | Oregon | 41039 | 56566 | 475 |
2282457 | 2282457 | 2022-03-07 | Lane | Kansas | 20101 | 295 | 11 |
2283760 | 2283760 | 2022-03-07 | Lane | Oregon | 41039 | 56538 | 472 |
2279204 | 2279204 | 2022-03-06 | Lane | Kansas | 20101 | 295 | 11 |
2280508 | 2280508 | 2022-03-06 | Lane | Oregon | 41039 | 56436 | 471 |
2275951 | 2275951 | 2022-03-05 | Lane | Kansas | 20101 | 295 | 11 |
2277255 | 2277255 | 2022-03-05 | Lane | Oregon | 41039 | 56436 | 471 |
2272698 | 2272698 | 2022-03-04 | Lane | Kansas | 20101 | 295 | 11 |
2274002 | 2274002 | 2022-03-04 | Lane | Oregon | 41039 | 56436 | 471 |
2269446 | 2269446 | 2022-03-03 | Lane | Kansas | 20101 | 294 | 11 |
2270749 | 2270749 | 2022-03-03 | Lane | Oregon | 41039 | 56362 | 470 |
2266193 | 2266193 | 2022-03-02 | Lane | Kansas | 20101 | 294 | 11 |
2267497 | 2267497 | 2022-03-02 | Lane | Oregon | 41039 | 56307 | 465 |
2262942 | 2262942 | 2022-03-01 | Lane | Kansas | 20101 | 294 | 11 |
2264244 | 2264244 | 2022-03-01 | Lane | Oregon | 41039 | 56239 | 465 |
2259691 | 2259691 | 2022-02-28 | Lane | Kansas | 20101 | 294 | 11 |
2260994 | 2260994 | 2022-02-28 | Lane | Oregon | 41039 | 56178 | 464 |
2256440 | 2256440 | 2022-02-27 | Lane | Kansas | 20101 | 294 | 11 |
2257743 | 2257743 | 2022-02-27 | Lane | Oregon | 41039 | 56044 | 457 |
2253189 | 2253189 | 2022-02-26 | Lane | Kansas | 20101 | 294 | 11 |
2254492 | 2254492 | 2022-02-26 | Lane | Oregon | 41039 | 56044 | 457 |
2249938 | 2249938 | 2022-02-25 | Lane | Kansas | 20101 | 294 | 11 |
2251241 | 2251241 | 2022-02-25 | Lane | Oregon | 41039 | 56044 | 457 |
2246687 | 2246687 | 2022-02-24 | Lane | Kansas | 20101 | 294 | 11 |
2247990 | 2247990 | 2022-02-24 | Lane | Oregon | 41039 | 55957 | 457 |
2243436 | 2243436 | 2022-02-23 | Lane | Kansas | 20101 | 294 | 11 |
2244739 | 2244739 | 2022-02-23 | Lane | Oregon | 41039 | 55906 | 453 |
2240185 | 2240185 | 2022-02-22 | Lane | Kansas | 20101 | 293 | 11 |
2241488 | 2241488 | 2022-02-22 | Lane | Oregon | 41039 | 55821 | 447 |
2236934 | 2236934 | 2022-02-21 | Lane | Kansas | 20101 | 293 | 11 |
2238237 | 2238237 | 2022-02-21 | Lane | Oregon | 41039 | 55461 | 446 |
2233683 | 2233683 | 2022-02-20 | Lane | Kansas | 20101 | 291 | 10 |
2234986 | 2234986 | 2022-02-20 | Lane | Oregon | 41039 | 55461 | 446 |
2230432 | 2230432 | 2022-02-19 | Lane | Kansas | 20101 | 291 | 10 |
2231735 | 2231735 | 2022-02-19 | Lane | Oregon | 41039 | 55461 | 446 |
2227181 | 2227181 | 2022-02-18 | Lane | Kansas | 20101 | 291 | 10 |
2228484 | 2228484 | 2022-02-18 | Lane | Oregon | 41039 | 55461 | 446 |
2223930 | 2223930 | 2022-02-17 | Lane | Kansas | 20101 | 291 | 10 |
2225233 | 2225233 | 2022-02-17 | Lane | Oregon | 41039 | 55280 | 445 |
2220679 | 2220679 | 2022-02-16 | Lane | Kansas | 20101 | 291 | 10 |
2221982 | 2221982 | 2022-02-16 | Lane | Oregon | 41039 | 55088 | 444 |
2217428 | 2217428 | 2022-02-15 | Lane | Kansas | 20101 | 291 | 10 |
2218731 | 2218731 | 2022-02-15 | Lane | Oregon | 41039 | 54876 | 443 |
2214177 | 2214177 | 2022-02-14 | Lane | Kansas | 20101 | 291 | 10 |
2215480 | 2215480 | 2022-02-14 | Lane | Oregon | 41039 | 54711 | 435 |
2210925 | 2210925 | 2022-02-13 | Lane | Kansas | 20101 | 289 | 10 |
2212229 | 2212229 | 2022-02-13 | Lane | Oregon | 41039 | 54133 | 431 |
2207672 | 2207672 | 2022-02-12 | Lane | Kansas | 20101 | 289 | 10 |
2208976 | 2208976 | 2022-02-12 | Lane | Oregon | 41039 | 54133 | 431 |
2204419 | 2204419 | 2022-02-11 | Lane | Kansas | 20101 | 289 | 10 |
2205723 | 2205723 | 2022-02-11 | Lane | Oregon | 41039 | 54133 | 431 |
2201166 | 2201166 | 2022-02-10 | Lane | Kansas | 20101 | 289 | 10 |
2202470 | 2202470 | 2022-02-10 | Lane | Oregon | 41039 | 53870 | 431 |
2197912 | 2197912 | 2022-02-09 | Lane | Kansas | 20101 | 289 | 10 |
2199216 | 2199216 | 2022-02-09 | Lane | Oregon | 41039 | 53603 | 430 |
2194658 | 2194658 | 2022-02-08 | Lane | Kansas | 20101 | 289 | 10 |
2195962 | 2195962 | 2022-02-08 | Lane | Oregon | 41039 | 53223 | 428 |
2191404 | 2191404 | 2022-02-07 | Lane | Kansas | 20101 | 289 | 10 |
2192708 | 2192708 | 2022-02-07 | Lane | Oregon | 41039 | 52905 | 424 |
2188151 | 2188151 | 2022-02-06 | Lane | Kansas | 20101 | 287 | 10 |
2189454 | 2189454 | 2022-02-06 | Lane | Oregon | 41039 | 52131 | 420 |
2184898 | 2184898 | 2022-02-05 | Lane | Kansas | 20101 | 287 | 10 |
2186201 | 2186201 | 2022-02-05 | Lane | Oregon | 41039 | 52131 | 420 |
2181646 | 2181646 | 2022-02-04 | Lane | Kansas | 20101 | 287 | 10 |
2182949 | 2182949 | 2022-02-04 | Lane | Oregon | 41039 | 52131 | 420 |
2178395 | 2178395 | 2022-02-03 | Lane | Kansas | 20101 | 286 | 10 |
2179697 | 2179697 | 2022-02-03 | Lane | Oregon | 41039 | 51614 | 418 |
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);