ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 20185 and state = "Kansas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
18322 | 18322 | 2020-03-29 | Stafford | Kansas | 20185 | 1 | 0 |
20336 | 20336 | 2020-03-30 | Stafford | Kansas | 20185 | 1 | 0 |
22435 | 22435 | 2020-03-31 | Stafford | Kansas | 20185 | 1 | 0 |
24611 | 24611 | 2020-04-01 | Stafford | Kansas | 20185 | 1 | 0 |
26855 | 26855 | 2020-04-02 | Stafford | Kansas | 20185 | 1 | 0 |
29171 | 29171 | 2020-04-03 | Stafford | Kansas | 20185 | 1 | 0 |
31545 | 31545 | 2020-04-04 | Stafford | Kansas | 20185 | 1 | 0 |
33960 | 33960 | 2020-04-05 | Stafford | Kansas | 20185 | 1 | 0 |
36418 | 36418 | 2020-04-06 | Stafford | Kansas | 20185 | 1 | 0 |
38923 | 38923 | 2020-04-07 | Stafford | Kansas | 20185 | 1 | 0 |
41470 | 41470 | 2020-04-08 | Stafford | Kansas | 20185 | 1 | 0 |
44046 | 44046 | 2020-04-09 | Stafford | Kansas | 20185 | 1 | 0 |
46653 | 46653 | 2020-04-10 | Stafford | Kansas | 20185 | 1 | 0 |
49290 | 49290 | 2020-04-11 | Stafford | Kansas | 20185 | 1 | 0 |
51955 | 51955 | 2020-04-12 | Stafford | Kansas | 20185 | 1 | 0 |
54637 | 54637 | 2020-04-13 | Stafford | Kansas | 20185 | 1 | 0 |
57331 | 57331 | 2020-04-14 | Stafford | Kansas | 20185 | 1 | 0 |
60040 | 60040 | 2020-04-15 | Stafford | Kansas | 20185 | 1 | 0 |
62761 | 62761 | 2020-04-16 | Stafford | Kansas | 20185 | 1 | 0 |
65498 | 65498 | 2020-04-17 | Stafford | Kansas | 20185 | 1 | 0 |
68247 | 68247 | 2020-04-18 | Stafford | Kansas | 20185 | 1 | 0 |
71009 | 71009 | 2020-04-19 | Stafford | Kansas | 20185 | 1 | 0 |
73781 | 73781 | 2020-04-20 | Stafford | Kansas | 20185 | 1 | 0 |
76561 | 76561 | 2020-04-21 | Stafford | Kansas | 20185 | 1 | 0 |
79346 | 79346 | 2020-04-22 | Stafford | Kansas | 20185 | 1 | 0 |
82142 | 82142 | 2020-04-23 | Stafford | Kansas | 20185 | 1 | 0 |
84945 | 84945 | 2020-04-24 | Stafford | Kansas | 20185 | 1 | 0 |
87754 | 87754 | 2020-04-25 | Stafford | Kansas | 20185 | 1 | 0 |
90570 | 90570 | 2020-04-26 | Stafford | Kansas | 20185 | 1 | 0 |
93391 | 93391 | 2020-04-27 | Stafford | Kansas | 20185 | 1 | 0 |
96224 | 96224 | 2020-04-28 | Stafford | Kansas | 20185 | 1 | 0 |
99070 | 99070 | 2020-04-29 | Stafford | Kansas | 20185 | 1 | 0 |
101922 | 101922 | 2020-04-30 | Stafford | Kansas | 20185 | 1 | 0 |
104783 | 104783 | 2020-05-01 | Stafford | Kansas | 20185 | 1 | 0 |
107648 | 107648 | 2020-05-02 | Stafford | Kansas | 20185 | 1 | 0 |
110519 | 110519 | 2020-05-03 | Stafford | Kansas | 20185 | 1 | 0 |
113396 | 113396 | 2020-05-04 | Stafford | Kansas | 20185 | 1 | 0 |
116278 | 116278 | 2020-05-05 | Stafford | Kansas | 20185 | 1 | 0 |
119239 | 119239 | 2020-05-06 | Stafford | Kansas | 20185 | 1 | 0 |
122209 | 122209 | 2020-05-07 | Stafford | Kansas | 20185 | 1 | 0 |
125191 | 125191 | 2020-05-08 | Stafford | Kansas | 20185 | 1 | 0 |
128179 | 128179 | 2020-05-09 | Stafford | Kansas | 20185 | 1 | 0 |
131169 | 131169 | 2020-05-10 | Stafford | Kansas | 20185 | 1 | 0 |
134160 | 134160 | 2020-05-11 | Stafford | Kansas | 20185 | 1 | 0 |
137150 | 137150 | 2020-05-12 | Stafford | Kansas | 20185 | 1 | 0 |
140143 | 140143 | 2020-05-13 | Stafford | Kansas | 20185 | 1 | 0 |
143139 | 143139 | 2020-05-14 | Stafford | Kansas | 20185 | 1 | 0 |
146139 | 146139 | 2020-05-15 | Stafford | Kansas | 20185 | 1 | 0 |
149143 | 149143 | 2020-05-16 | Stafford | Kansas | 20185 | 1 | 0 |
152154 | 152154 | 2020-05-17 | Stafford | Kansas | 20185 | 1 | 0 |
155167 | 155167 | 2020-05-18 | Stafford | Kansas | 20185 | 1 | 0 |
158184 | 158184 | 2020-05-19 | Stafford | Kansas | 20185 | 1 | 0 |
161209 | 161209 | 2020-05-20 | Stafford | Kansas | 20185 | 1 | 0 |
164238 | 164238 | 2020-05-21 | Stafford | Kansas | 20185 | 1 | 0 |
167273 | 167273 | 2020-05-22 | Stafford | Kansas | 20185 | 1 | 0 |
170311 | 170311 | 2020-05-23 | Stafford | Kansas | 20185 | 1 | 0 |
173352 | 173352 | 2020-05-24 | Stafford | Kansas | 20185 | 1 | 0 |
176396 | 176396 | 2020-05-25 | Stafford | Kansas | 20185 | 1 | 0 |
179440 | 179440 | 2020-05-26 | Stafford | Kansas | 20185 | 1 | 0 |
182485 | 182485 | 2020-05-27 | Stafford | Kansas | 20185 | 1 | 0 |
185539 | 185539 | 2020-05-28 | Stafford | Kansas | 20185 | 1 | 0 |
188597 | 188597 | 2020-05-29 | Stafford | Kansas | 20185 | 1 | 0 |
191661 | 191661 | 2020-05-30 | Stafford | Kansas | 20185 | 1 | 0 |
194729 | 194729 | 2020-05-31 | Stafford | Kansas | 20185 | 1 | 0 |
197799 | 197799 | 2020-06-01 | Stafford | Kansas | 20185 | 1 | 0 |
200871 | 200871 | 2020-06-02 | Stafford | Kansas | 20185 | 1 | 0 |
203948 | 203948 | 2020-06-03 | Stafford | Kansas | 20185 | 1 | 0 |
207029 | 207029 | 2020-06-04 | Stafford | Kansas | 20185 | 1 | 0 |
210110 | 210110 | 2020-06-05 | Stafford | Kansas | 20185 | 1 | 0 |
213195 | 213195 | 2020-06-06 | Stafford | Kansas | 20185 | 1 | 0 |
216282 | 216282 | 2020-06-07 | Stafford | Kansas | 20185 | 1 | 0 |
219374 | 219374 | 2020-06-08 | Stafford | Kansas | 20185 | 1 | 0 |
222469 | 222469 | 2020-06-09 | Stafford | Kansas | 20185 | 1 | 0 |
225564 | 225564 | 2020-06-10 | Stafford | Kansas | 20185 | 1 | 0 |
228666 | 228666 | 2020-06-11 | Stafford | Kansas | 20185 | 1 | 0 |
231769 | 231769 | 2020-06-12 | Stafford | Kansas | 20185 | 1 | 0 |
234875 | 234875 | 2020-06-13 | Stafford | Kansas | 20185 | 1 | 0 |
237982 | 237982 | 2020-06-14 | Stafford | Kansas | 20185 | 1 | 0 |
241091 | 241091 | 2020-06-15 | Stafford | Kansas | 20185 | 1 | 0 |
244202 | 244202 | 2020-06-16 | Stafford | Kansas | 20185 | 1 | 0 |
247315 | 247315 | 2020-06-17 | Stafford | Kansas | 20185 | 1 | 0 |
250427 | 250427 | 2020-06-18 | Stafford | Kansas | 20185 | 1 | 0 |
253542 | 253542 | 2020-06-19 | Stafford | Kansas | 20185 | 1 | 0 |
256662 | 256662 | 2020-06-20 | Stafford | Kansas | 20185 | 1 | 0 |
259788 | 259788 | 2020-06-21 | Stafford | Kansas | 20185 | 1 | 0 |
262915 | 262915 | 2020-06-22 | Stafford | Kansas | 20185 | 1 | 0 |
266043 | 266043 | 2020-06-23 | Stafford | Kansas | 20185 | 1 | 0 |
269175 | 269175 | 2020-06-24 | Stafford | Kansas | 20185 | 1 | 0 |
272312 | 272312 | 2020-06-25 | Stafford | Kansas | 20185 | 1 | 0 |
275455 | 275455 | 2020-06-26 | Stafford | Kansas | 20185 | 1 | 0 |
278603 | 278603 | 2020-06-27 | Stafford | Kansas | 20185 | 1 | 0 |
281751 | 281751 | 2020-06-28 | Stafford | Kansas | 20185 | 1 | 0 |
284897 | 284897 | 2020-06-29 | Stafford | Kansas | 20185 | 1 | 0 |
288046 | 288046 | 2020-06-30 | Stafford | Kansas | 20185 | 1 | 0 |
291196 | 291196 | 2020-07-01 | Stafford | Kansas | 20185 | 1 | 0 |
294350 | 294350 | 2020-07-02 | Stafford | Kansas | 20185 | 1 | 0 |
297508 | 297508 | 2020-07-03 | Stafford | Kansas | 20185 | 1 | 0 |
300670 | 300670 | 2020-07-04 | Stafford | Kansas | 20185 | 1 | 0 |
303834 | 303834 | 2020-07-05 | Stafford | Kansas | 20185 | 1 | 0 |
307001 | 307001 | 2020-07-06 | Stafford | Kansas | 20185 | 1 | 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);