ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Osage" and state = "Kansas" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14600 | 14600 | 2020-03-27 | Osage | Kansas | 20139 | 1 | 0 |
16408 | 16408 | 2020-03-28 | Osage | Kansas | 20139 | 1 | 0 |
18315 | 18315 | 2020-03-29 | Osage | Kansas | 20139 | 1 | 0 |
20328 | 20328 | 2020-03-30 | Osage | Kansas | 20139 | 2 | 0 |
22427 | 22427 | 2020-03-31 | Osage | Kansas | 20139 | 3 | 0 |
24602 | 24602 | 2020-04-01 | Osage | Kansas | 20139 | 3 | 0 |
26846 | 26846 | 2020-04-02 | Osage | Kansas | 20139 | 3 | 0 |
29161 | 29161 | 2020-04-03 | Osage | Kansas | 20139 | 3 | 0 |
31535 | 31535 | 2020-04-04 | Osage | Kansas | 20139 | 3 | 0 |
33949 | 33949 | 2020-04-05 | Osage | Kansas | 20139 | 3 | 0 |
36407 | 36407 | 2020-04-06 | Osage | Kansas | 20139 | 3 | 0 |
38909 | 38909 | 2020-04-07 | Osage | Kansas | 20139 | 3 | 0 |
41456 | 41456 | 2020-04-08 | Osage | Kansas | 20139 | 3 | 0 |
44032 | 44032 | 2020-04-09 | Osage | Kansas | 20139 | 3 | 0 |
46639 | 46639 | 2020-04-10 | Osage | Kansas | 20139 | 3 | 0 |
49275 | 49275 | 2020-04-11 | Osage | Kansas | 20139 | 3 | 0 |
51940 | 51940 | 2020-04-12 | Osage | Kansas | 20139 | 4 | 0 |
54622 | 54622 | 2020-04-13 | Osage | Kansas | 20139 | 4 | 0 |
57316 | 57316 | 2020-04-14 | Osage | Kansas | 20139 | 4 | 0 |
60024 | 60024 | 2020-04-15 | Osage | Kansas | 20139 | 4 | 0 |
62745 | 62745 | 2020-04-16 | Osage | Kansas | 20139 | 4 | 0 |
65481 | 65481 | 2020-04-17 | Osage | Kansas | 20139 | 4 | 0 |
68230 | 68230 | 2020-04-18 | Osage | Kansas | 20139 | 4 | 0 |
70991 | 70991 | 2020-04-19 | Osage | Kansas | 20139 | 4 | 0 |
73763 | 73763 | 2020-04-20 | Osage | Kansas | 20139 | 4 | 0 |
76543 | 76543 | 2020-04-21 | Osage | Kansas | 20139 | 4 | 0 |
79328 | 79328 | 2020-04-22 | Osage | Kansas | 20139 | 5 | 0 |
82123 | 82123 | 2020-04-23 | Osage | Kansas | 20139 | 5 | 0 |
84926 | 84926 | 2020-04-24 | Osage | Kansas | 20139 | 5 | 0 |
87735 | 87735 | 2020-04-25 | Osage | Kansas | 20139 | 5 | 0 |
90551 | 90551 | 2020-04-26 | Osage | Kansas | 20139 | 5 | 0 |
93372 | 93372 | 2020-04-27 | Osage | Kansas | 20139 | 5 | 0 |
96205 | 96205 | 2020-04-28 | Osage | Kansas | 20139 | 5 | 0 |
99051 | 99051 | 2020-04-29 | Osage | Kansas | 20139 | 5 | 0 |
101903 | 101903 | 2020-04-30 | Osage | Kansas | 20139 | 5 | 0 |
104764 | 104764 | 2020-05-01 | Osage | Kansas | 20139 | 5 | 0 |
107629 | 107629 | 2020-05-02 | Osage | Kansas | 20139 | 5 | 0 |
110500 | 110500 | 2020-05-03 | Osage | Kansas | 20139 | 5 | 0 |
113377 | 113377 | 2020-05-04 | Osage | Kansas | 20139 | 5 | 0 |
116259 | 116259 | 2020-05-05 | Osage | Kansas | 20139 | 5 | 0 |
119220 | 119220 | 2020-05-06 | Osage | Kansas | 20139 | 5 | 0 |
122190 | 122190 | 2020-05-07 | Osage | Kansas | 20139 | 5 | 0 |
125172 | 125172 | 2020-05-08 | Osage | Kansas | 20139 | 5 | 0 |
128160 | 128160 | 2020-05-09 | Osage | Kansas | 20139 | 5 | 0 |
131150 | 131150 | 2020-05-10 | Osage | Kansas | 20139 | 5 | 0 |
134141 | 134141 | 2020-05-11 | Osage | Kansas | 20139 | 6 | 0 |
137131 | 137131 | 2020-05-12 | Osage | Kansas | 20139 | 6 | 0 |
140124 | 140124 | 2020-05-13 | Osage | Kansas | 20139 | 6 | 0 |
143120 | 143120 | 2020-05-14 | Osage | Kansas | 20139 | 6 | 0 |
146120 | 146120 | 2020-05-15 | Osage | Kansas | 20139 | 6 | 0 |
149124 | 149124 | 2020-05-16 | Osage | Kansas | 20139 | 6 | 0 |
152135 | 152135 | 2020-05-17 | Osage | Kansas | 20139 | 6 | 0 |
155148 | 155148 | 2020-05-18 | Osage | Kansas | 20139 | 7 | 0 |
158165 | 158165 | 2020-05-19 | Osage | Kansas | 20139 | 7 | 0 |
161190 | 161190 | 2020-05-20 | Osage | Kansas | 20139 | 7 | 0 |
164219 | 164219 | 2020-05-21 | Osage | Kansas | 20139 | 7 | 0 |
167254 | 167254 | 2020-05-22 | Osage | Kansas | 20139 | 7 | 0 |
170292 | 170292 | 2020-05-23 | Osage | Kansas | 20139 | 7 | 0 |
173333 | 173333 | 2020-05-24 | Osage | Kansas | 20139 | 7 | 0 |
176377 | 176377 | 2020-05-25 | Osage | Kansas | 20139 | 7 | 0 |
179421 | 179421 | 2020-05-26 | Osage | Kansas | 20139 | 7 | 0 |
182466 | 182466 | 2020-05-27 | Osage | Kansas | 20139 | 7 | 0 |
185520 | 185520 | 2020-05-28 | Osage | Kansas | 20139 | 7 | 0 |
188578 | 188578 | 2020-05-29 | Osage | Kansas | 20139 | 7 | 0 |
191642 | 191642 | 2020-05-30 | Osage | Kansas | 20139 | 7 | 0 |
194710 | 194710 | 2020-05-31 | Osage | Kansas | 20139 | 7 | 0 |
197780 | 197780 | 2020-06-01 | Osage | Kansas | 20139 | 7 | 0 |
200852 | 200852 | 2020-06-02 | Osage | Kansas | 20139 | 7 | 0 |
203928 | 203928 | 2020-06-03 | Osage | Kansas | 20139 | 8 | 0 |
207009 | 207009 | 2020-06-04 | Osage | Kansas | 20139 | 8 | 0 |
210090 | 210090 | 2020-06-05 | Osage | Kansas | 20139 | 9 | 0 |
213175 | 213175 | 2020-06-06 | Osage | Kansas | 20139 | 9 | 0 |
216262 | 216262 | 2020-06-07 | Osage | Kansas | 20139 | 9 | 0 |
219354 | 219354 | 2020-06-08 | Osage | Kansas | 20139 | 9 | 0 |
222449 | 222449 | 2020-06-09 | Osage | Kansas | 20139 | 9 | 0 |
225544 | 225544 | 2020-06-10 | Osage | Kansas | 20139 | 10 | 0 |
228646 | 228646 | 2020-06-11 | Osage | Kansas | 20139 | 10 | 0 |
231749 | 231749 | 2020-06-12 | Osage | Kansas | 20139 | 10 | 0 |
234855 | 234855 | 2020-06-13 | Osage | Kansas | 20139 | 10 | 0 |
237962 | 237962 | 2020-06-14 | Osage | Kansas | 20139 | 10 | 0 |
241071 | 241071 | 2020-06-15 | Osage | Kansas | 20139 | 10 | 0 |
244182 | 244182 | 2020-06-16 | Osage | Kansas | 20139 | 10 | 0 |
247295 | 247295 | 2020-06-17 | Osage | Kansas | 20139 | 10 | 0 |
250407 | 250407 | 2020-06-18 | Osage | Kansas | 20139 | 10 | 0 |
253522 | 253522 | 2020-06-19 | Osage | Kansas | 20139 | 10 | 0 |
256642 | 256642 | 2020-06-20 | Osage | Kansas | 20139 | 10 | 0 |
259768 | 259768 | 2020-06-21 | Osage | Kansas | 20139 | 10 | 0 |
262895 | 262895 | 2020-06-22 | Osage | Kansas | 20139 | 10 | 0 |
266023 | 266023 | 2020-06-23 | Osage | Kansas | 20139 | 10 | 0 |
269155 | 269155 | 2020-06-24 | Osage | Kansas | 20139 | 10 | 0 |
272292 | 272292 | 2020-06-25 | Osage | Kansas | 20139 | 10 | 0 |
275435 | 275435 | 2020-06-26 | Osage | Kansas | 20139 | 11 | 0 |
278583 | 278583 | 2020-06-27 | Osage | Kansas | 20139 | 11 | 0 |
281731 | 281731 | 2020-06-28 | Osage | Kansas | 20139 | 11 | 0 |
284876 | 284876 | 2020-06-29 | Osage | Kansas | 20139 | 13 | 0 |
288025 | 288025 | 2020-06-30 | Osage | Kansas | 20139 | 13 | 0 |
291175 | 291175 | 2020-07-01 | Osage | Kansas | 20139 | 13 | 0 |
294329 | 294329 | 2020-07-02 | Osage | Kansas | 20139 | 13 | 0 |
297487 | 297487 | 2020-07-03 | Osage | Kansas | 20139 | 15 | 0 |
300649 | 300649 | 2020-07-04 | Osage | Kansas | 20139 | 15 | 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);