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
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Linn · 3,035 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
60014 | 60014 | 2020-04-15 | Linn | Kansas | 20107 | 6 | 0 |
60552 | 60552 | 2020-04-15 | Linn | Missouri | 29115 | 5 | 1 |
61094 | 61094 | 2020-04-15 | Linn | Oregon | 41043 | 53 | 4 |
62668 | 62668 | 2020-04-16 | Linn | Iowa | 19113 | 280 | 22 |
62735 | 62735 | 2020-04-16 | Linn | Kansas | 20107 | 6 | 0 |
63274 | 63274 | 2020-04-16 | Linn | Missouri | 29115 | 5 | 1 |
63820 | 63820 | 2020-04-16 | Linn | Oregon | 41043 | 54 | 4 |
65402 | 65402 | 2020-04-17 | Linn | Iowa | 19113 | 304 | 22 |
65471 | 65471 | 2020-04-17 | Linn | Kansas | 20107 | 6 | 0 |
66014 | 66014 | 2020-04-17 | Linn | Missouri | 29115 | 5 | 1 |
66566 | 66566 | 2020-04-17 | Linn | Oregon | 41043 | 57 | 6 |
68151 | 68151 | 2020-04-18 | Linn | Iowa | 19113 | 332 | 25 |
68220 | 68220 | 2020-04-18 | Linn | Kansas | 20107 | 6 | 0 |
68767 | 68767 | 2020-04-18 | Linn | Missouri | 29115 | 5 | 1 |
69324 | 69324 | 2020-04-18 | Linn | Oregon | 41043 | 59 | 6 |
70913 | 70913 | 2020-04-19 | Linn | Iowa | 19113 | 397 | 25 |
70981 | 70981 | 2020-04-19 | Linn | Kansas | 20107 | 6 | 0 |
71534 | 71534 | 2020-04-19 | Linn | Missouri | 29115 | 5 | 1 |
72091 | 72091 | 2020-04-19 | Linn | Oregon | 41043 | 59 | 6 |
73684 | 73684 | 2020-04-20 | Linn | Iowa | 19113 | 411 | 27 |
73753 | 73753 | 2020-04-20 | Linn | Kansas | 20107 | 6 | 0 |
74307 | 74307 | 2020-04-20 | Linn | Missouri | 29115 | 5 | 1 |
74866 | 74866 | 2020-04-20 | Linn | Oregon | 41043 | 61 | 6 |
76463 | 76463 | 2020-04-21 | Linn | Iowa | 19113 | 462 | 27 |
76533 | 76533 | 2020-04-21 | Linn | Kansas | 20107 | 6 | 0 |
77088 | 77088 | 2020-04-21 | Linn | Missouri | 29115 | 5 | 1 |
77648 | 77648 | 2020-04-21 | Linn | Oregon | 41043 | 62 | 6 |
79247 | 79247 | 2020-04-22 | Linn | Iowa | 19113 | 469 | 29 |
79318 | 79318 | 2020-04-22 | Linn | Kansas | 20107 | 6 | 0 |
79874 | 79874 | 2020-04-22 | Linn | Missouri | 29115 | 5 | 1 |
80438 | 80438 | 2020-04-22 | Linn | Oregon | 41043 | 63 | 6 |
82040 | 82040 | 2020-04-23 | Linn | Iowa | 19113 | 481 | 29 |
82113 | 82113 | 2020-04-23 | Linn | Kansas | 20107 | 6 | 0 |
82670 | 82670 | 2020-04-23 | Linn | Missouri | 29115 | 5 | 1 |
83237 | 83237 | 2020-04-23 | Linn | Oregon | 41043 | 67 | 6 |
84840 | 84840 | 2020-04-24 | Linn | Iowa | 19113 | 511 | 32 |
84915 | 84915 | 2020-04-24 | Linn | Kansas | 20107 | 6 | 0 |
85474 | 85474 | 2020-04-24 | Linn | Missouri | 29115 | 5 | 1 |
86041 | 86041 | 2020-04-24 | Linn | Oregon | 41043 | 67 | 7 |
87650 | 87650 | 2020-04-25 | Linn | Iowa | 19113 | 550 | 33 |
87724 | 87724 | 2020-04-25 | Linn | Kansas | 20107 | 6 | 0 |
88284 | 88284 | 2020-04-25 | Linn | Missouri | 29115 | 5 | 1 |
88855 | 88855 | 2020-04-25 | Linn | Oregon | 41043 | 71 | 7 |
90466 | 90466 | 2020-04-26 | Linn | Iowa | 19113 | 575 | 34 |
90540 | 90540 | 2020-04-26 | Linn | Kansas | 20107 | 6 | 0 |
91100 | 91100 | 2020-04-26 | Linn | Missouri | 29115 | 5 | 1 |
91671 | 91671 | 2020-04-26 | Linn | Oregon | 41043 | 74 | 7 |
93285 | 93285 | 2020-04-27 | Linn | Iowa | 19113 | 613 | 34 |
93361 | 93361 | 2020-04-27 | Linn | Kansas | 20107 | 6 | 0 |
93921 | 93921 | 2020-04-27 | Linn | Missouri | 29115 | 5 | 1 |
94498 | 94498 | 2020-04-27 | Linn | Oregon | 41043 | 79 | 7 |
96117 | 96117 | 2020-04-28 | Linn | Iowa | 19113 | 632 | 36 |
96193 | 96193 | 2020-04-28 | Linn | Kansas | 20107 | 6 | 0 |
96757 | 96757 | 2020-04-28 | Linn | Missouri | 29115 | 5 | 1 |
97337 | 97337 | 2020-04-28 | Linn | Oregon | 41043 | 81 | 7 |
98962 | 98962 | 2020-04-29 | Linn | Iowa | 19113 | 652 | 40 |
99039 | 99039 | 2020-04-29 | Linn | Kansas | 20107 | 6 | 0 |
99603 | 99603 | 2020-04-29 | Linn | Missouri | 29115 | 5 | 1 |
100186 | 100186 | 2020-04-29 | Linn | Oregon | 41043 | 82 | 7 |
101813 | 101813 | 2020-04-30 | Linn | Iowa | 19113 | 669 | 43 |
101891 | 101891 | 2020-04-30 | Linn | Kansas | 20107 | 6 | 0 |
102455 | 102455 | 2020-04-30 | Linn | Missouri | 29115 | 5 | 1 |
103039 | 103039 | 2020-04-30 | Linn | Oregon | 41043 | 86 | 7 |
104671 | 104671 | 2020-05-01 | Linn | Iowa | 19113 | 673 | 45 |
104751 | 104751 | 2020-05-01 | Linn | Kansas | 20107 | 6 | 0 |
105316 | 105316 | 2020-05-01 | Linn | Missouri | 29115 | 5 | 1 |
105902 | 105902 | 2020-05-01 | Linn | Oregon | 41043 | 87 | 7 |
107536 | 107536 | 2020-05-02 | Linn | Iowa | 19113 | 705 | 47 |
107616 | 107616 | 2020-05-02 | Linn | Kansas | 20107 | 6 | 0 |
108181 | 108181 | 2020-05-02 | Linn | Missouri | 29115 | 5 | 1 |
108769 | 108769 | 2020-05-02 | Linn | Oregon | 41043 | 87 | 7 |
110406 | 110406 | 2020-05-03 | Linn | Iowa | 19113 | 731 | 47 |
110487 | 110487 | 2020-05-03 | Linn | Kansas | 20107 | 6 | 0 |
111053 | 111053 | 2020-05-03 | Linn | Missouri | 29115 | 5 | 1 |
111643 | 111643 | 2020-05-03 | Linn | Oregon | 41043 | 87 | 7 |
113281 | 113281 | 2020-05-04 | Linn | Iowa | 19113 | 757 | 47 |
113364 | 113364 | 2020-05-04 | Linn | Kansas | 20107 | 6 | 0 |
113932 | 113932 | 2020-05-04 | Linn | Missouri | 29115 | 5 | 1 |
114525 | 114525 | 2020-05-04 | Linn | Oregon | 41043 | 97 | 7 |
116164 | 116164 | 2020-05-05 | Linn | Iowa | 19113 | 767 | 53 |
116246 | 116246 | 2020-05-05 | Linn | Kansas | 20107 | 6 | 0 |
116814 | 116814 | 2020-05-05 | Linn | Missouri | 29115 | 5 | 1 |
117406 | 117406 | 2020-05-05 | Linn | Oregon | 41043 | 98 | 7 |
119124 | 119124 | 2020-05-06 | Linn | Iowa | 19113 | 770 | 55 |
119207 | 119207 | 2020-05-06 | Linn | Kansas | 20107 | 6 | 0 |
119774 | 119774 | 2020-05-06 | Linn | Missouri | 29115 | 5 | 1 |
120368 | 120368 | 2020-05-06 | Linn | Oregon | 41043 | 99 | 7 |
122094 | 122094 | 2020-05-07 | Linn | Iowa | 19113 | 805 | 56 |
122177 | 122177 | 2020-05-07 | Linn | Kansas | 20107 | 6 | 0 |
122748 | 122748 | 2020-05-07 | Linn | Missouri | 29115 | 5 | 1 |
123345 | 123345 | 2020-05-07 | Linn | Oregon | 41043 | 99 | 7 |
125075 | 125075 | 2020-05-08 | Linn | Iowa | 19113 | 813 | 58 |
125159 | 125159 | 2020-05-08 | Linn | Kansas | 20107 | 6 | 0 |
125730 | 125730 | 2020-05-08 | Linn | Missouri | 29115 | 5 | 1 |
126328 | 126328 | 2020-05-08 | Linn | Oregon | 41043 | 100 | 7 |
128062 | 128062 | 2020-05-09 | Linn | Iowa | 19113 | 819 | 58 |
128147 | 128147 | 2020-05-09 | Linn | Kansas | 20107 | 6 | 0 |
128718 | 128718 | 2020-05-09 | Linn | Missouri | 29115 | 5 | 1 |
129317 | 129317 | 2020-05-09 | Linn | Oregon | 41043 | 102 | 8 |
131053 | 131053 | 2020-05-10 | Linn | Iowa | 19113 | 827 | 58 |
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);