ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 20029 and state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
26822 | 26822 | 2020-04-02 | Cloud | Kansas | 20029 | 1 | 0 |
29136 | 29136 | 2020-04-03 | Cloud | Kansas | 20029 | 1 | 0 |
31508 | 31508 | 2020-04-04 | Cloud | Kansas | 20029 | 1 | 0 |
33921 | 33921 | 2020-04-05 | Cloud | Kansas | 20029 | 1 | 0 |
36378 | 36378 | 2020-04-06 | Cloud | Kansas | 20029 | 1 | 0 |
38880 | 38880 | 2020-04-07 | Cloud | Kansas | 20029 | 1 | 0 |
41427 | 41427 | 2020-04-08 | Cloud | Kansas | 20029 | 3 | 0 |
44003 | 44003 | 2020-04-09 | Cloud | Kansas | 20029 | 3 | 0 |
46610 | 46610 | 2020-04-10 | Cloud | Kansas | 20029 | 3 | 0 |
49244 | 49244 | 2020-04-11 | Cloud | Kansas | 20029 | 3 | 0 |
51908 | 51908 | 2020-04-12 | Cloud | Kansas | 20029 | 3 | 0 |
54590 | 54590 | 2020-04-13 | Cloud | Kansas | 20029 | 3 | 0 |
57283 | 57283 | 2020-04-14 | Cloud | Kansas | 20029 | 3 | 0 |
59991 | 59991 | 2020-04-15 | Cloud | Kansas | 20029 | 3 | 0 |
62712 | 62712 | 2020-04-16 | Cloud | Kansas | 20029 | 3 | 0 |
65448 | 65448 | 2020-04-17 | Cloud | Kansas | 20029 | 3 | 0 |
68197 | 68197 | 2020-04-18 | Cloud | Kansas | 20029 | 3 | 0 |
70958 | 70958 | 2020-04-19 | Cloud | Kansas | 20029 | 3 | 0 |
73729 | 73729 | 2020-04-20 | Cloud | Kansas | 20029 | 3 | 0 |
76509 | 76509 | 2020-04-21 | Cloud | Kansas | 20029 | 3 | 0 |
79293 | 79293 | 2020-04-22 | Cloud | Kansas | 20029 | 3 | 0 |
82086 | 82086 | 2020-04-23 | Cloud | Kansas | 20029 | 3 | 0 |
84887 | 84887 | 2020-04-24 | Cloud | Kansas | 20029 | 3 | 0 |
87696 | 87696 | 2020-04-25 | Cloud | Kansas | 20029 | 3 | 0 |
90512 | 90512 | 2020-04-26 | Cloud | Kansas | 20029 | 3 | 0 |
93333 | 93333 | 2020-04-27 | Cloud | Kansas | 20029 | 3 | 0 |
96165 | 96165 | 2020-04-28 | Cloud | Kansas | 20029 | 3 | 0 |
99011 | 99011 | 2020-04-29 | Cloud | Kansas | 20029 | 4 | 0 |
101862 | 101862 | 2020-04-30 | Cloud | Kansas | 20029 | 4 | 0 |
104722 | 104722 | 2020-05-01 | Cloud | Kansas | 20029 | 4 | 0 |
107587 | 107587 | 2020-05-02 | Cloud | Kansas | 20029 | 4 | 0 |
110458 | 110458 | 2020-05-03 | Cloud | Kansas | 20029 | 4 | 0 |
113334 | 113334 | 2020-05-04 | Cloud | Kansas | 20029 | 4 | 0 |
116216 | 116216 | 2020-05-05 | Cloud | Kansas | 20029 | 4 | 0 |
119177 | 119177 | 2020-05-06 | Cloud | Kansas | 20029 | 4 | 0 |
122147 | 122147 | 2020-05-07 | Cloud | Kansas | 20029 | 4 | 0 |
125129 | 125129 | 2020-05-08 | Cloud | Kansas | 20029 | 4 | 0 |
128117 | 128117 | 2020-05-09 | Cloud | Kansas | 20029 | 4 | 0 |
131107 | 131107 | 2020-05-10 | Cloud | Kansas | 20029 | 4 | 0 |
134098 | 134098 | 2020-05-11 | Cloud | Kansas | 20029 | 4 | 0 |
137088 | 137088 | 2020-05-12 | Cloud | Kansas | 20029 | 4 | 0 |
140081 | 140081 | 2020-05-13 | Cloud | Kansas | 20029 | 4 | 0 |
143077 | 143077 | 2020-05-14 | Cloud | Kansas | 20029 | 4 | 0 |
146077 | 146077 | 2020-05-15 | Cloud | Kansas | 20029 | 4 | 0 |
149081 | 149081 | 2020-05-16 | Cloud | Kansas | 20029 | 4 | 0 |
152092 | 152092 | 2020-05-17 | Cloud | Kansas | 20029 | 4 | 0 |
155104 | 155104 | 2020-05-18 | Cloud | Kansas | 20029 | 4 | 0 |
158121 | 158121 | 2020-05-19 | Cloud | Kansas | 20029 | 4 | 0 |
161146 | 161146 | 2020-05-20 | Cloud | Kansas | 20029 | 4 | 0 |
164175 | 164175 | 2020-05-21 | Cloud | Kansas | 20029 | 4 | 0 |
167207 | 167207 | 2020-05-22 | Cloud | Kansas | 20029 | 4 | 0 |
170245 | 170245 | 2020-05-23 | Cloud | Kansas | 20029 | 4 | 0 |
173286 | 173286 | 2020-05-24 | Cloud | Kansas | 20029 | 4 | 0 |
176330 | 176330 | 2020-05-25 | Cloud | Kansas | 20029 | 4 | 0 |
179374 | 179374 | 2020-05-26 | Cloud | Kansas | 20029 | 4 | 0 |
182419 | 182419 | 2020-05-27 | Cloud | Kansas | 20029 | 4 | 0 |
185473 | 185473 | 2020-05-28 | Cloud | Kansas | 20029 | 4 | 0 |
188531 | 188531 | 2020-05-29 | Cloud | Kansas | 20029 | 5 | 0 |
191595 | 191595 | 2020-05-30 | Cloud | Kansas | 20029 | 5 | 0 |
194663 | 194663 | 2020-05-31 | Cloud | Kansas | 20029 | 5 | 0 |
197733 | 197733 | 2020-06-01 | Cloud | Kansas | 20029 | 5 | 0 |
200805 | 200805 | 2020-06-02 | Cloud | Kansas | 20029 | 5 | 0 |
203881 | 203881 | 2020-06-03 | Cloud | Kansas | 20029 | 5 | 0 |
206962 | 206962 | 2020-06-04 | Cloud | Kansas | 20029 | 5 | 0 |
210043 | 210043 | 2020-06-05 | Cloud | Kansas | 20029 | 5 | 0 |
213128 | 213128 | 2020-06-06 | Cloud | Kansas | 20029 | 5 | 0 |
216215 | 216215 | 2020-06-07 | Cloud | Kansas | 20029 | 5 | 0 |
219307 | 219307 | 2020-06-08 | Cloud | Kansas | 20029 | 5 | 0 |
222402 | 222402 | 2020-06-09 | Cloud | Kansas | 20029 | 5 | 0 |
225497 | 225497 | 2020-06-10 | Cloud | Kansas | 20029 | 5 | 0 |
228599 | 228599 | 2020-06-11 | Cloud | Kansas | 20029 | 5 | 0 |
231702 | 231702 | 2020-06-12 | Cloud | Kansas | 20029 | 5 | 0 |
234808 | 234808 | 2020-06-13 | Cloud | Kansas | 20029 | 5 | 0 |
237915 | 237915 | 2020-06-14 | Cloud | Kansas | 20029 | 5 | 0 |
241024 | 241024 | 2020-06-15 | Cloud | Kansas | 20029 | 5 | 0 |
244135 | 244135 | 2020-06-16 | Cloud | Kansas | 20029 | 5 | 0 |
247248 | 247248 | 2020-06-17 | Cloud | Kansas | 20029 | 6 | 0 |
250360 | 250360 | 2020-06-18 | Cloud | Kansas | 20029 | 6 | 0 |
253475 | 253475 | 2020-06-19 | Cloud | Kansas | 20029 | 7 | 0 |
256595 | 256595 | 2020-06-20 | Cloud | Kansas | 20029 | 7 | 0 |
259721 | 259721 | 2020-06-21 | Cloud | Kansas | 20029 | 7 | 0 |
262848 | 262848 | 2020-06-22 | Cloud | Kansas | 20029 | 7 | 0 |
265976 | 265976 | 2020-06-23 | Cloud | Kansas | 20029 | 7 | 0 |
269106 | 269106 | 2020-06-24 | Cloud | Kansas | 20029 | 8 | 0 |
272243 | 272243 | 2020-06-25 | Cloud | Kansas | 20029 | 8 | 0 |
275385 | 275385 | 2020-06-26 | Cloud | Kansas | 20029 | 10 | 0 |
278533 | 278533 | 2020-06-27 | Cloud | Kansas | 20029 | 10 | 0 |
281681 | 281681 | 2020-06-28 | Cloud | Kansas | 20029 | 10 | 0 |
284826 | 284826 | 2020-06-29 | Cloud | Kansas | 20029 | 18 | 0 |
287975 | 287975 | 2020-06-30 | Cloud | Kansas | 20029 | 18 | 0 |
291125 | 291125 | 2020-07-01 | Cloud | Kansas | 20029 | 18 | 0 |
294279 | 294279 | 2020-07-02 | Cloud | Kansas | 20029 | 18 | 0 |
297437 | 297437 | 2020-07-03 | Cloud | Kansas | 20029 | 21 | 0 |
300599 | 300599 | 2020-07-04 | Cloud | Kansas | 20029 | 21 | 0 |
303763 | 303763 | 2020-07-05 | Cloud | Kansas | 20029 | 21 | 0 |
306928 | 306928 | 2020-07-06 | Cloud | Kansas | 20029 | 24 | 0 |
310096 | 310096 | 2020-07-07 | Cloud | Kansas | 20029 | 24 | 0 |
313266 | 313266 | 2020-07-08 | Cloud | Kansas | 20029 | 25 | 0 |
316440 | 316440 | 2020-07-09 | Cloud | Kansas | 20029 | 25 | 0 |
319613 | 319613 | 2020-07-10 | Cloud | Kansas | 20029 | 26 | 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);