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)
Suggested facets: date, cases, date (date)
deaths 250 ✖
- 7 193
- 0 144
- 5 126
- 3 90
- 1 74
- 10 64
- 12 60
- 2 52
- 8 45
- 144 29
- 11 25
- 169 13
- 113 12
- 9 11
- 121 11
- 4 10
- 27 9
- 6 8
- 141 8
- 532 8
- 17 7
- 28 7
- 149 7
- 155 7
- 168 7
- 171 7
- 179 7
- 21 6
- 37 6
- 354 6
- 396 6
- 14 5
- 19 5
- 145 5
- 152 5
- 166 5
- 174 5
- 302 5
- 376 5
- 381 5
- 383 5
- 390 5
- 397 5
- 531 5
- 533 5
- 538 5
- 15 4
- 22 4
- 85 4
- 114 4
- 126 4
- 140 4
- 150 4
- 158 4
- 181 4
- 188 4
- 209 4
- 246 4
- 256 4
- 271 4
- 312 4
- 431 4
- 446 4
- 457 4
- 490 4
- 496 4
- 514 4
- 540 4
- 32 3
- 34 3
- 52 3
- 68 3
- 93 3
- 95 3
- 96 3
- 131 3
- 132 3
- 134 3
- 164 3
- 177 3
- 180 3
- 226 3
- 283 3
- 298 3
- 323 3
- 339 3
- 344 3
- 361 3
- 364 3
- 366 3
- 369 3
- 382 3
- 406 3
- 420 3
- 471 3
- 480 3
- 502 3
- 508 3
- 16 2
- 26 2
- 29 2
- 33 2
- 41 2
- 42 2
- 43 2
- 80 2
- 81 2
- 84 2
- 92 2
- 107 2
- 108 2
- 110 2
- 115 2
- 119 2
- 129 2
- 133 2
- 138 2
- 139 2
- 143 2
- 146 2
- 151 2
- 154 2
- 156 2
- 162 2
- 175 2
- 176 2
- 187 2
- 244 2
- 265 2
- 300 2
- 337 2
- 343 2
- 387 2
- 402 2
- 465 2
- 475 2
- 501 2
- 524 2
- 13 1
- 18 1
- 20 1
- 25 1
- 35 1
- 36 1
- 40 1
- 47 1
- 50 1
- 53 1
- 57 1
- 62 1
- 65 1
- 66 1
- 73 1
- 77 1
- 78 1
- 79 1
- 91 1
- 94 1
- 100 1
- 103 1
- 105 1
- 109 1
- 116 1
- 117 1
- 122 1
- 124 1
- 127 1
- 128 1
- 136 1
- 137 1
- 142 1
- 147 1
- 148 1
- 161 1
- 163 1
- 165 1
- 167 1
- 173 1
- 186 1
- 193 1
- 196 1
- 203 1
- 206 1
- 221 1
- 224 1
- 225 1
- 231 1
- 238 1
- 248 1
- 251 1
- 254 1
- 261 1
- 273 1
- 278 1
- 281 1
- 287 1
- 291 1
- 293 1
- 295 1
- 299 1
- 306 1
- 308 1
- 313 1
- 315 1
- 318 1
- 321 1
- 326 1
- 333 1
- 340 1
- 342 1
- 348 1
- 351 1
- 355 1
- 358 1
- 360 1
- 363 1
- 377 1
- 388 1
- 392 1
- 394 1
- 401 1
- 409 1
- 412 1
- 417 1
- 418 1
- 424 1
- 428 1
- 430 1
- 435 1
- 443 1
- 444 1
- 445 1
- 447 1
- 453 1
- 464 1
- 470 1
- 472 1
- 477 1
- 484 1
- 485 1
- 486 1
- 489 1
- 492 1
- 495 1
- 498 1
- 500 1
- 516 1
- 529 1
- 535 1
- 541 1
county 1
- Lane · 1,510 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500523 | 2500523 | 2022-05-13 | Lane | Kansas | 20101 | 296 | 12 |
2501830 | 2501830 | 2022-05-13 | Lane | Oregon | 41039 | 59853 | 541 |
2497265 | 2497265 | 2022-05-12 | Lane | Kansas | 20101 | 296 | 12 |
2498572 | 2498572 | 2022-05-12 | Lane | Oregon | 41039 | 59691 | 540 |
2494007 | 2494007 | 2022-05-11 | Lane | Kansas | 20101 | 296 | 12 |
2495314 | 2495314 | 2022-05-11 | Lane | Oregon | 41039 | 59524 | 540 |
2490749 | 2490749 | 2022-05-10 | Lane | Kansas | 20101 | 296 | 12 |
2492056 | 2492056 | 2022-05-10 | Lane | Oregon | 41039 | 59436 | 540 |
2487492 | 2487492 | 2022-05-09 | Lane | Kansas | 20101 | 296 | 12 |
2488798 | 2488798 | 2022-05-09 | Lane | Oregon | 41039 | 59275 | 540 |
2484234 | 2484234 | 2022-05-08 | Lane | Kansas | 20101 | 296 | 12 |
2485541 | 2485541 | 2022-05-08 | Lane | Oregon | 41039 | 59006 | 538 |
2480976 | 2480976 | 2022-05-07 | Lane | Kansas | 20101 | 296 | 12 |
2482283 | 2482283 | 2022-05-07 | Lane | Oregon | 41039 | 59006 | 538 |
2477718 | 2477718 | 2022-05-06 | Lane | Kansas | 20101 | 296 | 12 |
2479025 | 2479025 | 2022-05-06 | Lane | Oregon | 41039 | 59006 | 538 |
2474460 | 2474460 | 2022-05-05 | Lane | Kansas | 20101 | 295 | 12 |
2475767 | 2475767 | 2022-05-05 | Lane | Oregon | 41039 | 58928 | 538 |
2471203 | 2471203 | 2022-05-04 | Lane | Kansas | 20101 | 295 | 12 |
2472510 | 2472510 | 2022-05-04 | Lane | Oregon | 41039 | 58797 | 538 |
2467947 | 2467947 | 2022-05-03 | Lane | Kansas | 20101 | 295 | 12 |
2469254 | 2469254 | 2022-05-03 | Lane | Oregon | 41039 | 58677 | 535 |
2464692 | 2464692 | 2022-05-02 | Lane | Kansas | 20101 | 295 | 12 |
2465998 | 2465998 | 2022-05-02 | Lane | Oregon | 41039 | 58544 | 533 |
2461436 | 2461436 | 2022-05-01 | Lane | Kansas | 20101 | 295 | 12 |
2462743 | 2462743 | 2022-05-01 | Lane | Oregon | 41039 | 58401 | 533 |
2458180 | 2458180 | 2022-04-30 | Lane | Kansas | 20101 | 295 | 12 |
2459487 | 2459487 | 2022-04-30 | Lane | Oregon | 41039 | 58401 | 533 |
2454924 | 2454924 | 2022-04-29 | Lane | Kansas | 20101 | 295 | 12 |
2456231 | 2456231 | 2022-04-29 | Lane | Oregon | 41039 | 58401 | 533 |
2451668 | 2451668 | 2022-04-28 | Lane | Kansas | 20101 | 294 | 12 |
2452975 | 2452975 | 2022-04-28 | Lane | Oregon | 41039 | 58326 | 533 |
2448412 | 2448412 | 2022-04-27 | Lane | Kansas | 20101 | 294 | 12 |
2449719 | 2449719 | 2022-04-27 | Lane | Oregon | 41039 | 58215 | 532 |
2445156 | 2445156 | 2022-04-26 | Lane | Kansas | 20101 | 294 | 12 |
2446462 | 2446462 | 2022-04-26 | Lane | Oregon | 41039 | 58150 | 532 |
2441900 | 2441900 | 2022-04-25 | Lane | Kansas | 20101 | 294 | 12 |
2443207 | 2443207 | 2022-04-25 | Lane | Oregon | 41039 | 58057 | 532 |
2438644 | 2438644 | 2022-04-24 | Lane | Kansas | 20101 | 294 | 12 |
2439951 | 2439951 | 2022-04-24 | Lane | Oregon | 41039 | 57879 | 532 |
2435388 | 2435388 | 2022-04-23 | Lane | Kansas | 20101 | 294 | 12 |
2436695 | 2436695 | 2022-04-23 | Lane | Oregon | 41039 | 57879 | 532 |
2432132 | 2432132 | 2022-04-22 | Lane | Kansas | 20101 | 294 | 12 |
2433439 | 2433439 | 2022-04-22 | Lane | Oregon | 41039 | 57879 | 532 |
2428876 | 2428876 | 2022-04-21 | Lane | Kansas | 20101 | 294 | 12 |
2430183 | 2430183 | 2022-04-21 | Lane | Oregon | 41039 | 57841 | 532 |
2425620 | 2425620 | 2022-04-20 | Lane | Kansas | 20101 | 294 | 12 |
2426927 | 2426927 | 2022-04-20 | Lane | Oregon | 41039 | 57790 | 532 |
2422364 | 2422364 | 2022-04-19 | Lane | Kansas | 20101 | 294 | 12 |
2423671 | 2423671 | 2022-04-19 | Lane | Oregon | 41039 | 57730 | 531 |
2419108 | 2419108 | 2022-04-18 | Lane | Kansas | 20101 | 294 | 12 |
2420414 | 2420414 | 2022-04-18 | Lane | Oregon | 41039 | 57555 | 531 |
2415852 | 2415852 | 2022-04-17 | Lane | Kansas | 20101 | 294 | 12 |
2417159 | 2417159 | 2022-04-17 | Lane | Oregon | 41039 | 57555 | 531 |
2412596 | 2412596 | 2022-04-16 | Lane | Kansas | 20101 | 294 | 12 |
2413903 | 2413903 | 2022-04-16 | Lane | Oregon | 41039 | 57555 | 531 |
2409340 | 2409340 | 2022-04-15 | Lane | Kansas | 20101 | 294 | 12 |
2410647 | 2410647 | 2022-04-15 | Lane | Oregon | 41039 | 57555 | 531 |
2406084 | 2406084 | 2022-04-14 | Lane | Kansas | 20101 | 295 | 12 |
2407391 | 2407391 | 2022-04-14 | Lane | Oregon | 41039 | 57524 | 529 |
2402828 | 2402828 | 2022-04-13 | Lane | Kansas | 20101 | 295 | 12 |
2404135 | 2404135 | 2022-04-13 | Lane | Oregon | 41039 | 57490 | 524 |
2399574 | 2399574 | 2022-04-12 | Lane | Kansas | 20101 | 295 | 12 |
2400880 | 2400880 | 2022-04-12 | Lane | Oregon | 41039 | 57456 | 524 |
2396318 | 2396318 | 2022-04-11 | Lane | Kansas | 20101 | 295 | 12 |
2397625 | 2397625 | 2022-04-11 | Lane | Oregon | 41039 | 57421 | 516 |
2393063 | 2393063 | 2022-04-10 | Lane | Kansas | 20101 | 295 | 12 |
2394370 | 2394370 | 2022-04-10 | Lane | Oregon | 41039 | 57373 | 514 |
2389807 | 2389807 | 2022-04-09 | Lane | Kansas | 20101 | 295 | 12 |
2391114 | 2391114 | 2022-04-09 | Lane | Oregon | 41039 | 57373 | 514 |
2386551 | 2386551 | 2022-04-08 | Lane | Kansas | 20101 | 295 | 12 |
2387858 | 2387858 | 2022-04-08 | Lane | Oregon | 41039 | 57373 | 514 |
2383297 | 2383297 | 2022-04-07 | Lane | Kansas | 20101 | 295 | 12 |
2384603 | 2384603 | 2022-04-07 | Lane | Oregon | 41039 | 57344 | 514 |
2380042 | 2380042 | 2022-04-06 | Lane | Kansas | 20101 | 295 | 12 |
2381348 | 2381348 | 2022-04-06 | Lane | Oregon | 41039 | 57317 | 508 |
2376787 | 2376787 | 2022-04-05 | Lane | Kansas | 20101 | 295 | 12 |
2378093 | 2378093 | 2022-04-05 | Lane | Oregon | 41039 | 57292 | 508 |
2373535 | 2373535 | 2022-04-04 | Lane | Kansas | 20101 | 295 | 12 |
2374839 | 2374839 | 2022-04-04 | Lane | Oregon | 41039 | 57274 | 508 |
2370282 | 2370282 | 2022-04-03 | Lane | Kansas | 20101 | 295 | 12 |
2371587 | 2371587 | 2022-04-03 | Lane | Oregon | 41039 | 57237 | 502 |
2367029 | 2367029 | 2022-04-02 | Lane | Kansas | 20101 | 295 | 12 |
2368334 | 2368334 | 2022-04-02 | Lane | Oregon | 41039 | 57237 | 502 |
2363776 | 2363776 | 2022-04-01 | Lane | Kansas | 20101 | 295 | 12 |
2365081 | 2365081 | 2022-04-01 | Lane | Oregon | 41039 | 57237 | 502 |
2360522 | 2360522 | 2022-03-31 | Lane | Kansas | 20101 | 295 | 12 |
2361828 | 2361828 | 2022-03-31 | Lane | Oregon | 41039 | 57201 | 501 |
2357268 | 2357268 | 2022-03-30 | Lane | Kansas | 20101 | 295 | 12 |
2358574 | 2358574 | 2022-03-30 | Lane | Oregon | 41039 | 57165 | 501 |
2354015 | 2354015 | 2022-03-29 | Lane | Kansas | 20101 | 295 | 12 |
2355320 | 2355320 | 2022-03-29 | Lane | Oregon | 41039 | 57133 | 500 |
2350763 | 2350763 | 2022-03-28 | Lane | Kansas | 20101 | 295 | 12 |
2352067 | 2352067 | 2022-03-28 | Lane | Oregon | 41039 | 57100 | 498 |
2347510 | 2347510 | 2022-03-27 | Lane | Kansas | 20101 | 295 | 12 |
2348815 | 2348815 | 2022-03-27 | Lane | Oregon | 41039 | 57039 | 496 |
2344257 | 2344257 | 2022-03-26 | Lane | Kansas | 20101 | 295 | 12 |
2345562 | 2345562 | 2022-03-26 | Lane | Oregon | 41039 | 57039 | 496 |
2341004 | 2341004 | 2022-03-25 | Lane | Kansas | 20101 | 295 | 12 |
2342309 | 2342309 | 2022-03-25 | Lane | Oregon | 41039 | 57039 | 496 |
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);