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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3615 | 3615 | 2020-03-17 | Lane | Oregon | 41039 | 2 | 1 |
4230 | 4230 | 2020-03-18 | Lane | Oregon | 41039 | 2 | 1 |
4969 | 4969 | 2020-03-19 | Lane | Oregon | 41039 | 2 | 1 |
5837 | 5837 | 2020-03-20 | Lane | Oregon | 41039 | 2 | 1 |
6839 | 6839 | 2020-03-21 | Lane | Oregon | 41039 | 3 | 1 |
7954 | 7954 | 2020-03-22 | Lane | Oregon | 41039 | 4 | 1 |
9164 | 9164 | 2020-03-23 | Lane | Oregon | 41039 | 4 | 1 |
10483 | 10483 | 2020-03-24 | Lane | Oregon | 41039 | 4 | 1 |
11944 | 11944 | 2020-03-25 | Lane | Oregon | 41039 | 5 | 1 |
13560 | 13560 | 2020-03-26 | Lane | Oregon | 41039 | 7 | 1 |
15305 | 15305 | 2020-03-27 | Lane | Oregon | 41039 | 9 | 1 |
17152 | 17152 | 2020-03-28 | Lane | Oregon | 41039 | 9 | 1 |
19090 | 19090 | 2020-03-29 | Lane | Oregon | 41039 | 10 | 1 |
21140 | 21140 | 2020-03-30 | Lane | Oregon | 41039 | 12 | 1 |
23273 | 23273 | 2020-03-31 | Lane | Oregon | 41039 | 16 | 1 |
25471 | 25471 | 2020-04-01 | Lane | Oregon | 41039 | 18 | 1 |
27743 | 27743 | 2020-04-02 | Lane | Oregon | 41039 | 21 | 1 |
30076 | 30076 | 2020-04-03 | Lane | Oregon | 41039 | 21 | 1 |
32466 | 32466 | 2020-04-04 | Lane | Oregon | 41039 | 24 | 1 |
34900 | 34900 | 2020-04-05 | Lane | Oregon | 41039 | 27 | 1 |
37375 | 37375 | 2020-04-06 | Lane | Oregon | 41039 | 29 | 1 |
39896 | 39896 | 2020-04-07 | Lane | Oregon | 41039 | 30 | 1 |
42456 | 42456 | 2020-04-08 | Lane | Oregon | 41039 | 31 | 1 |
45042 | 45042 | 2020-04-09 | Lane | Oregon | 41039 | 33 | 1 |
47659 | 47659 | 2020-04-10 | Lane | Oregon | 41039 | 34 | 1 |
50316 | 50316 | 2020-04-11 | Lane | Oregon | 41039 | 35 | 1 |
52989 | 52989 | 2020-04-12 | Lane | Oregon | 41039 | 37 | 1 |
55674 | 55674 | 2020-04-13 | Lane | Oregon | 41039 | 41 | 1 |
58377 | 58377 | 2020-04-14 | Lane | Oregon | 41039 | 42 | 1 |
61092 | 61092 | 2020-04-15 | Lane | Oregon | 41039 | 44 | 1 |
63818 | 63818 | 2020-04-16 | Lane | Oregon | 41039 | 45 | 1 |
66564 | 66564 | 2020-04-17 | Lane | Oregon | 41039 | 46 | 1 |
69322 | 69322 | 2020-04-18 | Lane | Oregon | 41039 | 46 | 1 |
72089 | 72089 | 2020-04-19 | Lane | Oregon | 41039 | 48 | 1 |
74864 | 74864 | 2020-04-20 | Lane | Oregon | 41039 | 48 | 1 |
77646 | 77646 | 2020-04-21 | Lane | Oregon | 41039 | 48 | 1 |
80436 | 80436 | 2020-04-22 | Lane | Oregon | 41039 | 48 | 1 |
83235 | 83235 | 2020-04-23 | Lane | Oregon | 41039 | 48 | 1 |
86039 | 86039 | 2020-04-24 | Lane | Oregon | 41039 | 50 | 1 |
88853 | 88853 | 2020-04-25 | Lane | Oregon | 41039 | 50 | 2 |
91669 | 91669 | 2020-04-26 | Lane | Oregon | 41039 | 50 | 2 |
94496 | 94496 | 2020-04-27 | Lane | Oregon | 41039 | 50 | 2 |
97335 | 97335 | 2020-04-28 | Lane | Oregon | 41039 | 50 | 2 |
100184 | 100184 | 2020-04-29 | Lane | Oregon | 41039 | 50 | 2 |
103037 | 103037 | 2020-04-30 | Lane | Oregon | 41039 | 50 | 2 |
105900 | 105900 | 2020-05-01 | Lane | Oregon | 41039 | 50 | 2 |
108767 | 108767 | 2020-05-02 | Lane | Oregon | 41039 | 54 | 2 |
111641 | 111641 | 2020-05-03 | Lane | Oregon | 41039 | 54 | 2 |
114523 | 114523 | 2020-05-04 | Lane | Oregon | 41039 | 55 | 2 |
117404 | 117404 | 2020-05-05 | Lane | Oregon | 41039 | 55 | 2 |
120366 | 120366 | 2020-05-06 | Lane | Oregon | 41039 | 57 | 2 |
123343 | 123343 | 2020-05-07 | Lane | Oregon | 41039 | 57 | 2 |
126326 | 126326 | 2020-05-08 | Lane | Oregon | 41039 | 59 | 2 |
129315 | 129315 | 2020-05-09 | Lane | Oregon | 41039 | 60 | 2 |
132304 | 132304 | 2020-05-10 | Lane | Oregon | 41039 | 60 | 2 |
135295 | 135295 | 2020-05-11 | Lane | Oregon | 41039 | 60 | 2 |
138285 | 138285 | 2020-05-12 | Lane | Oregon | 41039 | 61 | 2 |
141281 | 141281 | 2020-05-13 | Lane | Oregon | 41039 | 61 | 2 |
144277 | 144277 | 2020-05-14 | Lane | Oregon | 41039 | 61 | 2 |
147278 | 147278 | 2020-05-15 | Lane | Oregon | 41039 | 61 | 2 |
150285 | 150285 | 2020-05-16 | Lane | Oregon | 41039 | 64 | 2 |
153296 | 153296 | 2020-05-17 | Lane | Oregon | 41039 | 64 | 2 |
156313 | 156313 | 2020-05-18 | Lane | Oregon | 41039 | 65 | 2 |
159334 | 159334 | 2020-05-19 | Lane | Oregon | 41039 | 65 | 2 |
162361 | 162361 | 2020-05-20 | Lane | Oregon | 41039 | 66 | 2 |
165390 | 165390 | 2020-05-21 | Lane | Oregon | 41039 | 66 | 2 |
167238 | 167238 | 2020-05-22 | Lane | Kansas | 20101 | 1 | 0 |
168426 | 168426 | 2020-05-22 | Lane | Oregon | 41039 | 66 | 2 |
170276 | 170276 | 2020-05-23 | Lane | Kansas | 20101 | 1 | 0 |
171465 | 171465 | 2020-05-23 | Lane | Oregon | 41039 | 67 | 2 |
173317 | 173317 | 2020-05-24 | Lane | Kansas | 20101 | 1 | 0 |
174507 | 174507 | 2020-05-24 | Lane | Oregon | 41039 | 67 | 2 |
176361 | 176361 | 2020-05-25 | Lane | Kansas | 20101 | 3 | 0 |
177551 | 177551 | 2020-05-25 | Lane | Oregon | 41039 | 67 | 2 |
179405 | 179405 | 2020-05-26 | Lane | Kansas | 20101 | 3 | 0 |
180594 | 180594 | 2020-05-26 | Lane | Oregon | 41039 | 67 | 2 |
182450 | 182450 | 2020-05-27 | Lane | Kansas | 20101 | 3 | 0 |
183644 | 183644 | 2020-05-27 | Lane | Oregon | 41039 | 67 | 2 |
185504 | 185504 | 2020-05-28 | Lane | Kansas | 20101 | 3 | 0 |
186701 | 186701 | 2020-05-28 | Lane | Oregon | 41039 | 67 | 2 |
188562 | 188562 | 2020-05-29 | Lane | Kansas | 20101 | 3 | 0 |
189762 | 189762 | 2020-05-29 | Lane | Oregon | 41039 | 68 | 2 |
191626 | 191626 | 2020-05-30 | Lane | Kansas | 20101 | 3 | 0 |
192827 | 192827 | 2020-05-30 | Lane | Oregon | 41039 | 69 | 3 |
194694 | 194694 | 2020-05-31 | Lane | Kansas | 20101 | 3 | 0 |
195896 | 195896 | 2020-05-31 | Lane | Oregon | 41039 | 73 | 3 |
197764 | 197764 | 2020-06-01 | Lane | Kansas | 20101 | 3 | 0 |
198969 | 198969 | 2020-06-01 | Lane | Oregon | 41039 | 77 | 3 |
200836 | 200836 | 2020-06-02 | Lane | Kansas | 20101 | 3 | 0 |
202044 | 202044 | 2020-06-02 | Lane | Oregon | 41039 | 77 | 3 |
203912 | 203912 | 2020-06-03 | Lane | Kansas | 20101 | 4 | 0 |
205121 | 205121 | 2020-06-03 | Lane | Oregon | 41039 | 77 | 3 |
206993 | 206993 | 2020-06-04 | Lane | Kansas | 20101 | 4 | 0 |
208202 | 208202 | 2020-06-04 | Lane | Oregon | 41039 | 80 | 3 |
210074 | 210074 | 2020-06-05 | Lane | Kansas | 20101 | 4 | 0 |
211284 | 211284 | 2020-06-05 | Lane | Oregon | 41039 | 80 | 3 |
213159 | 213159 | 2020-06-06 | Lane | Kansas | 20101 | 4 | 0 |
214370 | 214370 | 2020-06-06 | Lane | Oregon | 41039 | 80 | 3 |
216246 | 216246 | 2020-06-07 | Lane | Kansas | 20101 | 4 | 0 |
217460 | 217460 | 2020-06-07 | Lane | Oregon | 41039 | 80 | 3 |
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);