ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Klamath" and fips = 41035 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 |
---|---|---|---|---|---|---|---|
724 | 724 | 2020-03-07 | Klamath | Oregon | 41035 | 1 | 0 |
832 | 832 | 2020-03-08 | Klamath | Oregon | 41035 | 1 | 0 |
960 | 960 | 2020-03-09 | Klamath | Oregon | 41035 | 1 | 0 |
1111 | 1111 | 2020-03-10 | Klamath | Oregon | 41035 | 1 | 0 |
1301 | 1301 | 2020-03-11 | Klamath | Oregon | 41035 | 1 | 0 |
1545 | 1545 | 2020-03-12 | Klamath | Oregon | 41035 | 1 | 0 |
1841 | 1841 | 2020-03-13 | Klamath | Oregon | 41035 | 1 | 0 |
2202 | 2202 | 2020-03-14 | Klamath | Oregon | 41035 | 1 | 0 |
2621 | 2621 | 2020-03-15 | Klamath | Oregon | 41035 | 1 | 0 |
3086 | 3086 | 2020-03-16 | Klamath | Oregon | 41035 | 1 | 0 |
3614 | 3614 | 2020-03-17 | Klamath | Oregon | 41035 | 1 | 0 |
4229 | 4229 | 2020-03-18 | Klamath | Oregon | 41035 | 1 | 0 |
4968 | 4968 | 2020-03-19 | Klamath | Oregon | 41035 | 1 | 0 |
5836 | 5836 | 2020-03-20 | Klamath | Oregon | 41035 | 1 | 0 |
6838 | 6838 | 2020-03-21 | Klamath | Oregon | 41035 | 1 | 0 |
7953 | 7953 | 2020-03-22 | Klamath | Oregon | 41035 | 1 | 0 |
9163 | 9163 | 2020-03-23 | Klamath | Oregon | 41035 | 1 | 0 |
10482 | 10482 | 2020-03-24 | Klamath | Oregon | 41035 | 1 | 0 |
11943 | 11943 | 2020-03-25 | Klamath | Oregon | 41035 | 1 | 0 |
13559 | 13559 | 2020-03-26 | Klamath | Oregon | 41035 | 1 | 0 |
15304 | 15304 | 2020-03-27 | Klamath | Oregon | 41035 | 2 | 0 |
17151 | 17151 | 2020-03-28 | Klamath | Oregon | 41035 | 2 | 0 |
19089 | 19089 | 2020-03-29 | Klamath | Oregon | 41035 | 4 | 0 |
21139 | 21139 | 2020-03-30 | Klamath | Oregon | 41035 | 4 | 0 |
23272 | 23272 | 2020-03-31 | Klamath | Oregon | 41035 | 5 | 0 |
25470 | 25470 | 2020-04-01 | Klamath | Oregon | 41035 | 5 | 0 |
27742 | 27742 | 2020-04-02 | Klamath | Oregon | 41035 | 8 | 0 |
30075 | 30075 | 2020-04-03 | Klamath | Oregon | 41035 | 13 | 0 |
32465 | 32465 | 2020-04-04 | Klamath | Oregon | 41035 | 14 | 0 |
34899 | 34899 | 2020-04-05 | Klamath | Oregon | 41035 | 15 | 0 |
37374 | 37374 | 2020-04-06 | Klamath | Oregon | 41035 | 18 | 0 |
39895 | 39895 | 2020-04-07 | Klamath | Oregon | 41035 | 19 | 0 |
42455 | 42455 | 2020-04-08 | Klamath | Oregon | 41035 | 19 | 0 |
45041 | 45041 | 2020-04-09 | Klamath | Oregon | 41035 | 20 | 0 |
47658 | 47658 | 2020-04-10 | Klamath | Oregon | 41035 | 24 | 0 |
50315 | 50315 | 2020-04-11 | Klamath | Oregon | 41035 | 25 | 0 |
52988 | 52988 | 2020-04-12 | Klamath | Oregon | 41035 | 25 | 0 |
55673 | 55673 | 2020-04-13 | Klamath | Oregon | 41035 | 25 | 0 |
58376 | 58376 | 2020-04-14 | Klamath | Oregon | 41035 | 26 | 0 |
61091 | 61091 | 2020-04-15 | Klamath | Oregon | 41035 | 26 | 0 |
63817 | 63817 | 2020-04-16 | Klamath | Oregon | 41035 | 29 | 0 |
66563 | 66563 | 2020-04-17 | Klamath | Oregon | 41035 | 29 | 0 |
69321 | 69321 | 2020-04-18 | Klamath | Oregon | 41035 | 31 | 0 |
72088 | 72088 | 2020-04-19 | Klamath | Oregon | 41035 | 30 | 0 |
74863 | 74863 | 2020-04-20 | Klamath | Oregon | 41035 | 31 | 0 |
77645 | 77645 | 2020-04-21 | Klamath | Oregon | 41035 | 33 | 0 |
80435 | 80435 | 2020-04-22 | Klamath | Oregon | 41035 | 33 | 0 |
83234 | 83234 | 2020-04-23 | Klamath | Oregon | 41035 | 36 | 0 |
86038 | 86038 | 2020-04-24 | Klamath | Oregon | 41035 | 36 | 0 |
88852 | 88852 | 2020-04-25 | Klamath | Oregon | 41035 | 36 | 0 |
91668 | 91668 | 2020-04-26 | Klamath | Oregon | 41035 | 36 | 0 |
94495 | 94495 | 2020-04-27 | Klamath | Oregon | 41035 | 36 | 0 |
97334 | 97334 | 2020-04-28 | Klamath | Oregon | 41035 | 37 | 0 |
100183 | 100183 | 2020-04-29 | Klamath | Oregon | 41035 | 37 | 0 |
103036 | 103036 | 2020-04-30 | Klamath | Oregon | 41035 | 38 | 0 |
105899 | 105899 | 2020-05-01 | Klamath | Oregon | 41035 | 39 | 0 |
108766 | 108766 | 2020-05-02 | Klamath | Oregon | 41035 | 39 | 0 |
111640 | 111640 | 2020-05-03 | Klamath | Oregon | 41035 | 39 | 0 |
114522 | 114522 | 2020-05-04 | Klamath | Oregon | 41035 | 39 | 0 |
117403 | 117403 | 2020-05-05 | Klamath | Oregon | 41035 | 39 | 0 |
120365 | 120365 | 2020-05-06 | Klamath | Oregon | 41035 | 39 | 0 |
123342 | 123342 | 2020-05-07 | Klamath | Oregon | 41035 | 39 | 0 |
126325 | 126325 | 2020-05-08 | Klamath | Oregon | 41035 | 39 | 0 |
129314 | 129314 | 2020-05-09 | Klamath | Oregon | 41035 | 39 | 0 |
132303 | 132303 | 2020-05-10 | Klamath | Oregon | 41035 | 39 | 0 |
135294 | 135294 | 2020-05-11 | Klamath | Oregon | 41035 | 40 | 0 |
138284 | 138284 | 2020-05-12 | Klamath | Oregon | 41035 | 41 | 0 |
141280 | 141280 | 2020-05-13 | Klamath | Oregon | 41035 | 41 | 0 |
144276 | 144276 | 2020-05-14 | Klamath | Oregon | 41035 | 41 | 0 |
147277 | 147277 | 2020-05-15 | Klamath | Oregon | 41035 | 41 | 0 |
150284 | 150284 | 2020-05-16 | Klamath | Oregon | 41035 | 41 | 0 |
153295 | 153295 | 2020-05-17 | Klamath | Oregon | 41035 | 41 | 0 |
156312 | 156312 | 2020-05-18 | Klamath | Oregon | 41035 | 41 | 0 |
159333 | 159333 | 2020-05-19 | Klamath | Oregon | 41035 | 41 | 0 |
162360 | 162360 | 2020-05-20 | Klamath | Oregon | 41035 | 41 | 0 |
165389 | 165389 | 2020-05-21 | Klamath | Oregon | 41035 | 41 | 0 |
168425 | 168425 | 2020-05-22 | Klamath | Oregon | 41035 | 41 | 0 |
171464 | 171464 | 2020-05-23 | Klamath | Oregon | 41035 | 41 | 0 |
174506 | 174506 | 2020-05-24 | Klamath | Oregon | 41035 | 41 | 0 |
177550 | 177550 | 2020-05-25 | Klamath | Oregon | 41035 | 41 | 0 |
180593 | 180593 | 2020-05-26 | Klamath | Oregon | 41035 | 41 | 0 |
183642 | 183642 | 2020-05-27 | Klamath | Oregon | 41035 | 41 | 0 |
186699 | 186699 | 2020-05-28 | Klamath | Oregon | 41035 | 41 | 0 |
189760 | 189760 | 2020-05-29 | Klamath | Oregon | 41035 | 42 | 0 |
192825 | 192825 | 2020-05-30 | Klamath | Oregon | 41035 | 44 | 0 |
195894 | 195894 | 2020-05-31 | Klamath | Oregon | 41035 | 44 | 0 |
198967 | 198967 | 2020-06-01 | Klamath | Oregon | 41035 | 44 | 0 |
202042 | 202042 | 2020-06-02 | Klamath | Oregon | 41035 | 44 | 0 |
205119 | 205119 | 2020-06-03 | Klamath | Oregon | 41035 | 44 | 0 |
208200 | 208200 | 2020-06-04 | Klamath | Oregon | 41035 | 44 | 0 |
211282 | 211282 | 2020-06-05 | Klamath | Oregon | 41035 | 45 | 0 |
214368 | 214368 | 2020-06-06 | Klamath | Oregon | 41035 | 45 | 0 |
217458 | 217458 | 2020-06-07 | Klamath | Oregon | 41035 | 45 | 0 |
220550 | 220550 | 2020-06-08 | Klamath | Oregon | 41035 | 46 | 0 |
223645 | 223645 | 2020-06-09 | Klamath | Oregon | 41035 | 46 | 0 |
226745 | 226745 | 2020-06-10 | Klamath | Oregon | 41035 | 46 | 0 |
229849 | 229849 | 2020-06-11 | Klamath | Oregon | 41035 | 46 | 0 |
232954 | 232954 | 2020-06-12 | Klamath | Oregon | 41035 | 48 | 0 |
236059 | 236059 | 2020-06-13 | Klamath | Oregon | 41035 | 48 | 0 |
239167 | 239167 | 2020-06-14 | Klamath | Oregon | 41035 | 51 | 0 |
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);