ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,135 rows where county = "Linn" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Linn · 3,135 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500429 | 2500429 | 2022-05-13 | Linn | Iowa | 19113 | 53125 | 583 |
2500526 | 2500526 | 2022-05-13 | Linn | Kansas | 20107 | 2827 | 28 |
2501135 | 2501135 | 2022-05-13 | Linn | Missouri | 29115 | 2560 | 65 |
2501832 | 2501832 | 2022-05-13 | Linn | Oregon | 41043 | 27257 | 268 |
2497171 | 2497171 | 2022-05-12 | Linn | Iowa | 19113 | 53125 | 583 |
2497268 | 2497268 | 2022-05-12 | Linn | Kansas | 20107 | 2825 | 28 |
2497877 | 2497877 | 2022-05-12 | Linn | Missouri | 29115 | 2554 | 64 |
2498574 | 2498574 | 2022-05-12 | Linn | Oregon | 41043 | 27219 | 268 |
2493913 | 2493913 | 2022-05-11 | Linn | Iowa | 19113 | 53125 | 583 |
2494010 | 2494010 | 2022-05-11 | Linn | Kansas | 20107 | 2825 | 28 |
2494619 | 2494619 | 2022-05-11 | Linn | Missouri | 29115 | 2554 | 64 |
2495316 | 2495316 | 2022-05-11 | Linn | Oregon | 41043 | 27174 | 268 |
2490655 | 2490655 | 2022-05-10 | Linn | Iowa | 19113 | 52775 | 581 |
2490752 | 2490752 | 2022-05-10 | Linn | Kansas | 20107 | 2825 | 28 |
2491361 | 2491361 | 2022-05-10 | Linn | Missouri | 29115 | 2554 | 64 |
2492058 | 2492058 | 2022-05-10 | Linn | Oregon | 41043 | 27153 | 268 |
2487398 | 2487398 | 2022-05-09 | Linn | Iowa | 19113 | 52775 | 581 |
2487495 | 2487495 | 2022-05-09 | Linn | Kansas | 20107 | 2825 | 28 |
2488103 | 2488103 | 2022-05-09 | Linn | Missouri | 29115 | 2554 | 64 |
2488800 | 2488800 | 2022-05-09 | Linn | Oregon | 41043 | 27124 | 268 |
2484140 | 2484140 | 2022-05-08 | Linn | Iowa | 19113 | 52775 | 581 |
2484237 | 2484237 | 2022-05-08 | Linn | Kansas | 20107 | 2825 | 28 |
2484846 | 2484846 | 2022-05-08 | Linn | Missouri | 29115 | 2554 | 64 |
2485543 | 2485543 | 2022-05-08 | Linn | Oregon | 41043 | 27048 | 268 |
2480882 | 2480882 | 2022-05-07 | Linn | Iowa | 19113 | 52775 | 581 |
2480979 | 2480979 | 2022-05-07 | Linn | Kansas | 20107 | 2825 | 28 |
2481588 | 2481588 | 2022-05-07 | Linn | Missouri | 29115 | 2554 | 64 |
2482285 | 2482285 | 2022-05-07 | Linn | Oregon | 41043 | 27048 | 268 |
2477624 | 2477624 | 2022-05-06 | Linn | Iowa | 19113 | 52775 | 581 |
2477721 | 2477721 | 2022-05-06 | Linn | Kansas | 20107 | 2825 | 28 |
2478330 | 2478330 | 2022-05-06 | Linn | Missouri | 29115 | 2554 | 64 |
2479027 | 2479027 | 2022-05-06 | Linn | Oregon | 41043 | 27048 | 268 |
2474366 | 2474366 | 2022-05-05 | Linn | Iowa | 19113 | 52775 | 581 |
2474463 | 2474463 | 2022-05-05 | Linn | Kansas | 20107 | 2823 | 28 |
2475072 | 2475072 | 2022-05-05 | Linn | Missouri | 29115 | 2554 | 64 |
2475769 | 2475769 | 2022-05-05 | Linn | Oregon | 41043 | 27004 | 268 |
2471109 | 2471109 | 2022-05-04 | Linn | Iowa | 19113 | 52775 | 581 |
2471206 | 2471206 | 2022-05-04 | Linn | Kansas | 20107 | 2823 | 28 |
2471815 | 2471815 | 2022-05-04 | Linn | Missouri | 29115 | 2549 | 64 |
2472512 | 2472512 | 2022-05-04 | Linn | Oregon | 41043 | 26964 | 268 |
2467853 | 2467853 | 2022-05-03 | Linn | Iowa | 19113 | 52517 | 581 |
2467950 | 2467950 | 2022-05-03 | Linn | Kansas | 20107 | 2823 | 28 |
2468559 | 2468559 | 2022-05-03 | Linn | Missouri | 29115 | 2549 | 64 |
2469256 | 2469256 | 2022-05-03 | Linn | Oregon | 41043 | 26921 | 268 |
2464598 | 2464598 | 2022-05-02 | Linn | Iowa | 19113 | 52517 | 581 |
2464695 | 2464695 | 2022-05-02 | Linn | Kansas | 20107 | 2823 | 28 |
2465303 | 2465303 | 2022-05-02 | Linn | Missouri | 29115 | 2549 | 64 |
2466000 | 2466000 | 2022-05-02 | Linn | Oregon | 41043 | 26891 | 268 |
2461342 | 2461342 | 2022-05-01 | Linn | Iowa | 19113 | 52517 | 581 |
2461439 | 2461439 | 2022-05-01 | Linn | Kansas | 20107 | 2823 | 28 |
2462048 | 2462048 | 2022-05-01 | Linn | Missouri | 29115 | 2549 | 64 |
2462745 | 2462745 | 2022-05-01 | Linn | Oregon | 41043 | 26845 | 268 |
2458086 | 2458086 | 2022-04-30 | Linn | Iowa | 19113 | 52517 | 581 |
2458183 | 2458183 | 2022-04-30 | Linn | Kansas | 20107 | 2823 | 28 |
2458792 | 2458792 | 2022-04-30 | Linn | Missouri | 29115 | 2549 | 64 |
2459489 | 2459489 | 2022-04-30 | Linn | Oregon | 41043 | 26845 | 268 |
2454830 | 2454830 | 2022-04-29 | Linn | Iowa | 19113 | 52517 | 581 |
2454927 | 2454927 | 2022-04-29 | Linn | Kansas | 20107 | 2823 | 28 |
2455536 | 2455536 | 2022-04-29 | Linn | Missouri | 29115 | 2549 | 64 |
2456233 | 2456233 | 2022-04-29 | Linn | Oregon | 41043 | 26845 | 268 |
2451574 | 2451574 | 2022-04-28 | Linn | Iowa | 19113 | 52517 | 581 |
2451671 | 2451671 | 2022-04-28 | Linn | Kansas | 20107 | 2821 | 28 |
2452280 | 2452280 | 2022-04-28 | Linn | Missouri | 29115 | 2549 | 64 |
2452977 | 2452977 | 2022-04-28 | Linn | Oregon | 41043 | 26824 | 268 |
2448318 | 2448318 | 2022-04-27 | Linn | Iowa | 19113 | 52517 | 581 |
2448415 | 2448415 | 2022-04-27 | Linn | Kansas | 20107 | 2821 | 28 |
2449024 | 2449024 | 2022-04-27 | Linn | Missouri | 29115 | 2549 | 64 |
2449721 | 2449721 | 2022-04-27 | Linn | Oregon | 41043 | 26786 | 268 |
2445062 | 2445062 | 2022-04-26 | Linn | Iowa | 19113 | 52302 | 580 |
2445159 | 2445159 | 2022-04-26 | Linn | Kansas | 20107 | 2821 | 28 |
2445767 | 2445767 | 2022-04-26 | Linn | Missouri | 29115 | 2549 | 64 |
2446464 | 2446464 | 2022-04-26 | Linn | Oregon | 41043 | 26759 | 268 |
2441806 | 2441806 | 2022-04-25 | Linn | Iowa | 19113 | 52302 | 580 |
2441903 | 2441903 | 2022-04-25 | Linn | Kansas | 20107 | 2821 | 28 |
2442512 | 2442512 | 2022-04-25 | Linn | Missouri | 29115 | 2549 | 64 |
2443209 | 2443209 | 2022-04-25 | Linn | Oregon | 41043 | 26738 | 268 |
2438550 | 2438550 | 2022-04-24 | Linn | Iowa | 19113 | 52302 | 580 |
2438647 | 2438647 | 2022-04-24 | Linn | Kansas | 20107 | 2821 | 28 |
2439256 | 2439256 | 2022-04-24 | Linn | Missouri | 29115 | 2549 | 64 |
2439953 | 2439953 | 2022-04-24 | Linn | Oregon | 41043 | 26656 | 268 |
2435294 | 2435294 | 2022-04-23 | Linn | Iowa | 19113 | 52302 | 580 |
2435391 | 2435391 | 2022-04-23 | Linn | Kansas | 20107 | 2821 | 28 |
2436000 | 2436000 | 2022-04-23 | Linn | Missouri | 29115 | 2549 | 64 |
2436697 | 2436697 | 2022-04-23 | Linn | Oregon | 41043 | 26656 | 268 |
2432038 | 2432038 | 2022-04-22 | Linn | Iowa | 19113 | 52302 | 580 |
2432135 | 2432135 | 2022-04-22 | Linn | Kansas | 20107 | 2821 | 28 |
2432744 | 2432744 | 2022-04-22 | Linn | Missouri | 29115 | 2549 | 64 |
2433441 | 2433441 | 2022-04-22 | Linn | Oregon | 41043 | 26656 | 268 |
2428782 | 2428782 | 2022-04-21 | Linn | Iowa | 19113 | 52302 | 580 |
2428879 | 2428879 | 2022-04-21 | Linn | Kansas | 20107 | 2815 | 28 |
2429488 | 2429488 | 2022-04-21 | Linn | Missouri | 29115 | 2549 | 64 |
2430185 | 2430185 | 2022-04-21 | Linn | Oregon | 41043 | 26627 | 268 |
2425526 | 2425526 | 2022-04-20 | Linn | Iowa | 19113 | 52302 | 580 |
2425623 | 2425623 | 2022-04-20 | Linn | Kansas | 20107 | 2815 | 28 |
2426232 | 2426232 | 2022-04-20 | Linn | Missouri | 29115 | 2549 | 64 |
2426929 | 2426929 | 2022-04-20 | Linn | Oregon | 41043 | 26607 | 268 |
2422270 | 2422270 | 2022-04-19 | Linn | Iowa | 19113 | 52173 | 579 |
2422367 | 2422367 | 2022-04-19 | Linn | Kansas | 20107 | 2815 | 28 |
2422976 | 2422976 | 2022-04-19 | Linn | Missouri | 29115 | 2549 | 64 |
2423673 | 2423673 | 2022-04-19 | Linn | Oregon | 41043 | 26591 | 268 |
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);