ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 20141 and state = "Kansas" 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 |
---|---|---|---|---|---|---|---|
29162 | 29162 | 2020-04-03 | Osborne | Kansas | 20141 | 1 | 0 |
31536 | 31536 | 2020-04-04 | Osborne | Kansas | 20141 | 2 | 0 |
33950 | 33950 | 2020-04-05 | Osborne | Kansas | 20141 | 2 | 0 |
36408 | 36408 | 2020-04-06 | Osborne | Kansas | 20141 | 2 | 0 |
38910 | 38910 | 2020-04-07 | Osborne | Kansas | 20141 | 2 | 0 |
41457 | 41457 | 2020-04-08 | Osborne | Kansas | 20141 | 2 | 0 |
44033 | 44033 | 2020-04-09 | Osborne | Kansas | 20141 | 2 | 0 |
46640 | 46640 | 2020-04-10 | Osborne | Kansas | 20141 | 2 | 0 |
49276 | 49276 | 2020-04-11 | Osborne | Kansas | 20141 | 2 | 0 |
51941 | 51941 | 2020-04-12 | Osborne | Kansas | 20141 | 2 | 0 |
54623 | 54623 | 2020-04-13 | Osborne | Kansas | 20141 | 2 | 0 |
57317 | 57317 | 2020-04-14 | Osborne | Kansas | 20141 | 2 | 0 |
60025 | 60025 | 2020-04-15 | Osborne | Kansas | 20141 | 2 | 0 |
62746 | 62746 | 2020-04-16 | Osborne | Kansas | 20141 | 2 | 0 |
65482 | 65482 | 2020-04-17 | Osborne | Kansas | 20141 | 2 | 0 |
68231 | 68231 | 2020-04-18 | Osborne | Kansas | 20141 | 2 | 0 |
70992 | 70992 | 2020-04-19 | Osborne | Kansas | 20141 | 2 | 0 |
73764 | 73764 | 2020-04-20 | Osborne | Kansas | 20141 | 2 | 0 |
76544 | 76544 | 2020-04-21 | Osborne | Kansas | 20141 | 2 | 0 |
79329 | 79329 | 2020-04-22 | Osborne | Kansas | 20141 | 2 | 0 |
82124 | 82124 | 2020-04-23 | Osborne | Kansas | 20141 | 2 | 0 |
84927 | 84927 | 2020-04-24 | Osborne | Kansas | 20141 | 2 | 0 |
87736 | 87736 | 2020-04-25 | Osborne | Kansas | 20141 | 2 | 0 |
90552 | 90552 | 2020-04-26 | Osborne | Kansas | 20141 | 2 | 0 |
93373 | 93373 | 2020-04-27 | Osborne | Kansas | 20141 | 2 | 0 |
96206 | 96206 | 2020-04-28 | Osborne | Kansas | 20141 | 2 | 0 |
99052 | 99052 | 2020-04-29 | Osborne | Kansas | 20141 | 2 | 0 |
101904 | 101904 | 2020-04-30 | Osborne | Kansas | 20141 | 2 | 0 |
104765 | 104765 | 2020-05-01 | Osborne | Kansas | 20141 | 2 | 0 |
107630 | 107630 | 2020-05-02 | Osborne | Kansas | 20141 | 2 | 0 |
110501 | 110501 | 2020-05-03 | Osborne | Kansas | 20141 | 2 | 0 |
113378 | 113378 | 2020-05-04 | Osborne | Kansas | 20141 | 2 | 0 |
116260 | 116260 | 2020-05-05 | Osborne | Kansas | 20141 | 2 | 0 |
119221 | 119221 | 2020-05-06 | Osborne | Kansas | 20141 | 2 | 0 |
122191 | 122191 | 2020-05-07 | Osborne | Kansas | 20141 | 2 | 0 |
125173 | 125173 | 2020-05-08 | Osborne | Kansas | 20141 | 2 | 0 |
128161 | 128161 | 2020-05-09 | Osborne | Kansas | 20141 | 2 | 0 |
131151 | 131151 | 2020-05-10 | Osborne | Kansas | 20141 | 2 | 0 |
134142 | 134142 | 2020-05-11 | Osborne | Kansas | 20141 | 2 | 0 |
137132 | 137132 | 2020-05-12 | Osborne | Kansas | 20141 | 2 | 0 |
140125 | 140125 | 2020-05-13 | Osborne | Kansas | 20141 | 2 | 0 |
143121 | 143121 | 2020-05-14 | Osborne | Kansas | 20141 | 2 | 0 |
146121 | 146121 | 2020-05-15 | Osborne | Kansas | 20141 | 2 | 0 |
149125 | 149125 | 2020-05-16 | Osborne | Kansas | 20141 | 2 | 0 |
152136 | 152136 | 2020-05-17 | Osborne | Kansas | 20141 | 2 | 0 |
155149 | 155149 | 2020-05-18 | Osborne | Kansas | 20141 | 2 | 0 |
158166 | 158166 | 2020-05-19 | Osborne | Kansas | 20141 | 2 | 0 |
161191 | 161191 | 2020-05-20 | Osborne | Kansas | 20141 | 2 | 0 |
164220 | 164220 | 2020-05-21 | Osborne | Kansas | 20141 | 2 | 0 |
167255 | 167255 | 2020-05-22 | Osborne | Kansas | 20141 | 2 | 0 |
170293 | 170293 | 2020-05-23 | Osborne | Kansas | 20141 | 2 | 0 |
173334 | 173334 | 2020-05-24 | Osborne | Kansas | 20141 | 2 | 0 |
176378 | 176378 | 2020-05-25 | Osborne | Kansas | 20141 | 2 | 0 |
179422 | 179422 | 2020-05-26 | Osborne | Kansas | 20141 | 2 | 0 |
182467 | 182467 | 2020-05-27 | Osborne | Kansas | 20141 | 2 | 0 |
185521 | 185521 | 2020-05-28 | Osborne | Kansas | 20141 | 2 | 0 |
188579 | 188579 | 2020-05-29 | Osborne | Kansas | 20141 | 2 | 0 |
191643 | 191643 | 2020-05-30 | Osborne | Kansas | 20141 | 2 | 0 |
194711 | 194711 | 2020-05-31 | Osborne | Kansas | 20141 | 2 | 0 |
197781 | 197781 | 2020-06-01 | Osborne | Kansas | 20141 | 2 | 0 |
200853 | 200853 | 2020-06-02 | Osborne | Kansas | 20141 | 2 | 0 |
203929 | 203929 | 2020-06-03 | Osborne | Kansas | 20141 | 2 | 0 |
207010 | 207010 | 2020-06-04 | Osborne | Kansas | 20141 | 2 | 0 |
210091 | 210091 | 2020-06-05 | Osborne | Kansas | 20141 | 2 | 0 |
213176 | 213176 | 2020-06-06 | Osborne | Kansas | 20141 | 2 | 0 |
216263 | 216263 | 2020-06-07 | Osborne | Kansas | 20141 | 2 | 0 |
219355 | 219355 | 2020-06-08 | Osborne | Kansas | 20141 | 2 | 0 |
222450 | 222450 | 2020-06-09 | Osborne | Kansas | 20141 | 2 | 0 |
225545 | 225545 | 2020-06-10 | Osborne | Kansas | 20141 | 2 | 0 |
228647 | 228647 | 2020-06-11 | Osborne | Kansas | 20141 | 2 | 0 |
231750 | 231750 | 2020-06-12 | Osborne | Kansas | 20141 | 2 | 0 |
234856 | 234856 | 2020-06-13 | Osborne | Kansas | 20141 | 2 | 0 |
237963 | 237963 | 2020-06-14 | Osborne | Kansas | 20141 | 2 | 0 |
241072 | 241072 | 2020-06-15 | Osborne | Kansas | 20141 | 2 | 0 |
244183 | 244183 | 2020-06-16 | Osborne | Kansas | 20141 | 2 | 0 |
247296 | 247296 | 2020-06-17 | Osborne | Kansas | 20141 | 2 | 0 |
250408 | 250408 | 2020-06-18 | Osborne | Kansas | 20141 | 2 | 0 |
253523 | 253523 | 2020-06-19 | Osborne | Kansas | 20141 | 2 | 0 |
256643 | 256643 | 2020-06-20 | Osborne | Kansas | 20141 | 2 | 0 |
259769 | 259769 | 2020-06-21 | Osborne | Kansas | 20141 | 2 | 0 |
262896 | 262896 | 2020-06-22 | Osborne | Kansas | 20141 | 2 | 0 |
266024 | 266024 | 2020-06-23 | Osborne | Kansas | 20141 | 2 | 0 |
269156 | 269156 | 2020-06-24 | Osborne | Kansas | 20141 | 2 | 0 |
272293 | 272293 | 2020-06-25 | Osborne | Kansas | 20141 | 2 | 0 |
275436 | 275436 | 2020-06-26 | Osborne | Kansas | 20141 | 2 | 0 |
278584 | 278584 | 2020-06-27 | Osborne | Kansas | 20141 | 2 | 0 |
281732 | 281732 | 2020-06-28 | Osborne | Kansas | 20141 | 2 | 0 |
284877 | 284877 | 2020-06-29 | Osborne | Kansas | 20141 | 2 | 0 |
288026 | 288026 | 2020-06-30 | Osborne | Kansas | 20141 | 2 | 0 |
291176 | 291176 | 2020-07-01 | Osborne | Kansas | 20141 | 2 | 0 |
294330 | 294330 | 2020-07-02 | Osborne | Kansas | 20141 | 2 | 0 |
297488 | 297488 | 2020-07-03 | Osborne | Kansas | 20141 | 2 | 0 |
300650 | 300650 | 2020-07-04 | Osborne | Kansas | 20141 | 2 | 0 |
303814 | 303814 | 2020-07-05 | Osborne | Kansas | 20141 | 2 | 0 |
306981 | 306981 | 2020-07-06 | Osborne | Kansas | 20141 | 3 | 0 |
310149 | 310149 | 2020-07-07 | Osborne | Kansas | 20141 | 3 | 0 |
313319 | 313319 | 2020-07-08 | Osborne | Kansas | 20141 | 3 | 0 |
316493 | 316493 | 2020-07-09 | Osborne | Kansas | 20141 | 3 | 0 |
319667 | 319667 | 2020-07-10 | Osborne | Kansas | 20141 | 3 | 0 |
322846 | 322846 | 2020-07-11 | Osborne | Kansas | 20141 | 3 | 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);