ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 20035 and state = "Kansas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
26824 | 26824 | 2020-04-02 | Cowley | Kansas | 20035 | 1 | 0 |
29138 | 29138 | 2020-04-03 | Cowley | Kansas | 20035 | 1 | 0 |
31510 | 31510 | 2020-04-04 | Cowley | Kansas | 20035 | 1 | 0 |
33923 | 33923 | 2020-04-05 | Cowley | Kansas | 20035 | 1 | 0 |
36380 | 36380 | 2020-04-06 | Cowley | Kansas | 20035 | 1 | 0 |
38882 | 38882 | 2020-04-07 | Cowley | Kansas | 20035 | 1 | 0 |
41429 | 41429 | 2020-04-08 | Cowley | Kansas | 20035 | 1 | 0 |
44005 | 44005 | 2020-04-09 | Cowley | Kansas | 20035 | 2 | 1 |
46612 | 46612 | 2020-04-10 | Cowley | Kansas | 20035 | 2 | 1 |
49246 | 49246 | 2020-04-11 | Cowley | Kansas | 20035 | 2 | 1 |
51910 | 51910 | 2020-04-12 | Cowley | Kansas | 20035 | 2 | 1 |
54592 | 54592 | 2020-04-13 | Cowley | Kansas | 20035 | 2 | 1 |
57285 | 57285 | 2020-04-14 | Cowley | Kansas | 20035 | 1 | 1 |
59993 | 59993 | 2020-04-15 | Cowley | Kansas | 20035 | 1 | 1 |
62714 | 62714 | 2020-04-16 | Cowley | Kansas | 20035 | 1 | 1 |
65450 | 65450 | 2020-04-17 | Cowley | Kansas | 20035 | 1 | 1 |
68199 | 68199 | 2020-04-18 | Cowley | Kansas | 20035 | 1 | 1 |
70960 | 70960 | 2020-04-19 | Cowley | Kansas | 20035 | 1 | 1 |
73731 | 73731 | 2020-04-20 | Cowley | Kansas | 20035 | 1 | 1 |
76511 | 76511 | 2020-04-21 | Cowley | Kansas | 20035 | 1 | 1 |
79295 | 79295 | 2020-04-22 | Cowley | Kansas | 20035 | 1 | 1 |
82088 | 82088 | 2020-04-23 | Cowley | Kansas | 20035 | 1 | 1 |
84889 | 84889 | 2020-04-24 | Cowley | Kansas | 20035 | 1 | 1 |
87698 | 87698 | 2020-04-25 | Cowley | Kansas | 20035 | 1 | 1 |
90514 | 90514 | 2020-04-26 | Cowley | Kansas | 20035 | 2 | 1 |
93335 | 93335 | 2020-04-27 | Cowley | Kansas | 20035 | 3 | 1 |
96167 | 96167 | 2020-04-28 | Cowley | Kansas | 20035 | 3 | 1 |
99013 | 99013 | 2020-04-29 | Cowley | Kansas | 20035 | 3 | 1 |
101864 | 101864 | 2020-04-30 | Cowley | Kansas | 20035 | 3 | 1 |
104724 | 104724 | 2020-05-01 | Cowley | Kansas | 20035 | 3 | 1 |
107589 | 107589 | 2020-05-02 | Cowley | Kansas | 20035 | 3 | 1 |
110460 | 110460 | 2020-05-03 | Cowley | Kansas | 20035 | 3 | 1 |
113336 | 113336 | 2020-05-04 | Cowley | Kansas | 20035 | 3 | 1 |
116218 | 116218 | 2020-05-05 | Cowley | Kansas | 20035 | 3 | 1 |
119179 | 119179 | 2020-05-06 | Cowley | Kansas | 20035 | 3 | 1 |
122149 | 122149 | 2020-05-07 | Cowley | Kansas | 20035 | 3 | 1 |
125131 | 125131 | 2020-05-08 | Cowley | Kansas | 20035 | 3 | 1 |
128119 | 128119 | 2020-05-09 | Cowley | Kansas | 20035 | 3 | 1 |
131109 | 131109 | 2020-05-10 | Cowley | Kansas | 20035 | 3 | 1 |
134100 | 134100 | 2020-05-11 | Cowley | Kansas | 20035 | 3 | 1 |
137090 | 137090 | 2020-05-12 | Cowley | Kansas | 20035 | 3 | 1 |
140083 | 140083 | 2020-05-13 | Cowley | Kansas | 20035 | 3 | 1 |
143079 | 143079 | 2020-05-14 | Cowley | Kansas | 20035 | 3 | 1 |
146079 | 146079 | 2020-05-15 | Cowley | Kansas | 20035 | 3 | 1 |
149083 | 149083 | 2020-05-16 | Cowley | Kansas | 20035 | 5 | 1 |
152094 | 152094 | 2020-05-17 | Cowley | Kansas | 20035 | 5 | 1 |
155106 | 155106 | 2020-05-18 | Cowley | Kansas | 20035 | 5 | 1 |
158123 | 158123 | 2020-05-19 | Cowley | Kansas | 20035 | 4 | 1 |
161148 | 161148 | 2020-05-20 | Cowley | Kansas | 20035 | 4 | 1 |
164177 | 164177 | 2020-05-21 | Cowley | Kansas | 20035 | 4 | 1 |
167210 | 167210 | 2020-05-22 | Cowley | Kansas | 20035 | 4 | 1 |
170248 | 170248 | 2020-05-23 | Cowley | Kansas | 20035 | 4 | 1 |
173289 | 173289 | 2020-05-24 | Cowley | Kansas | 20035 | 4 | 1 |
176333 | 176333 | 2020-05-25 | Cowley | Kansas | 20035 | 4 | 1 |
179377 | 179377 | 2020-05-26 | Cowley | Kansas | 20035 | 4 | 1 |
182422 | 182422 | 2020-05-27 | Cowley | Kansas | 20035 | 4 | 1 |
185476 | 185476 | 2020-05-28 | Cowley | Kansas | 20035 | 4 | 1 |
188534 | 188534 | 2020-05-29 | Cowley | Kansas | 20035 | 5 | 1 |
191598 | 191598 | 2020-05-30 | Cowley | Kansas | 20035 | 5 | 1 |
194666 | 194666 | 2020-05-31 | Cowley | Kansas | 20035 | 5 | 1 |
197736 | 197736 | 2020-06-01 | Cowley | Kansas | 20035 | 10 | 1 |
200808 | 200808 | 2020-06-02 | Cowley | Kansas | 20035 | 10 | 1 |
203884 | 203884 | 2020-06-03 | Cowley | Kansas | 20035 | 15 | 1 |
206965 | 206965 | 2020-06-04 | Cowley | Kansas | 20035 | 15 | 1 |
210046 | 210046 | 2020-06-05 | Cowley | Kansas | 20035 | 17 | 1 |
213131 | 213131 | 2020-06-06 | Cowley | Kansas | 20035 | 17 | 1 |
216218 | 216218 | 2020-06-07 | Cowley | Kansas | 20035 | 17 | 1 |
219310 | 219310 | 2020-06-08 | Cowley | Kansas | 20035 | 26 | 1 |
222405 | 222405 | 2020-06-09 | Cowley | Kansas | 20035 | 26 | 1 |
225500 | 225500 | 2020-06-10 | Cowley | Kansas | 20035 | 27 | 1 |
228602 | 228602 | 2020-06-11 | Cowley | Kansas | 20035 | 27 | 1 |
231705 | 231705 | 2020-06-12 | Cowley | Kansas | 20035 | 39 | 1 |
234811 | 234811 | 2020-06-13 | Cowley | Kansas | 20035 | 39 | 1 |
237918 | 237918 | 2020-06-14 | Cowley | Kansas | 20035 | 39 | 1 |
241027 | 241027 | 2020-06-15 | Cowley | Kansas | 20035 | 41 | 1 |
244138 | 244138 | 2020-06-16 | Cowley | Kansas | 20035 | 41 | 1 |
247251 | 247251 | 2020-06-17 | Cowley | Kansas | 20035 | 45 | 1 |
250363 | 250363 | 2020-06-18 | Cowley | Kansas | 20035 | 45 | 1 |
253478 | 253478 | 2020-06-19 | Cowley | Kansas | 20035 | 52 | 1 |
256598 | 256598 | 2020-06-20 | Cowley | Kansas | 20035 | 52 | 1 |
259724 | 259724 | 2020-06-21 | Cowley | Kansas | 20035 | 52 | 1 |
262851 | 262851 | 2020-06-22 | Cowley | Kansas | 20035 | 59 | 1 |
265979 | 265979 | 2020-06-23 | Cowley | Kansas | 20035 | 59 | 1 |
269109 | 269109 | 2020-06-24 | Cowley | Kansas | 20035 | 61 | 1 |
272246 | 272246 | 2020-06-25 | Cowley | Kansas | 20035 | 61 | 1 |
275388 | 275388 | 2020-06-26 | Cowley | Kansas | 20035 | 66 | 1 |
278536 | 278536 | 2020-06-27 | Cowley | Kansas | 20035 | 66 | 1 |
281684 | 281684 | 2020-06-28 | Cowley | Kansas | 20035 | 66 | 1 |
284829 | 284829 | 2020-06-29 | Cowley | Kansas | 20035 | 70 | 1 |
287978 | 287978 | 2020-06-30 | Cowley | Kansas | 20035 | 70 | 1 |
291128 | 291128 | 2020-07-01 | Cowley | Kansas | 20035 | 71 | 1 |
294282 | 294282 | 2020-07-02 | Cowley | Kansas | 20035 | 71 | 1 |
297440 | 297440 | 2020-07-03 | Cowley | Kansas | 20035 | 73 | 1 |
300602 | 300602 | 2020-07-04 | Cowley | Kansas | 20035 | 73 | 1 |
303766 | 303766 | 2020-07-05 | Cowley | Kansas | 20035 | 73 | 1 |
306931 | 306931 | 2020-07-06 | Cowley | Kansas | 20035 | 76 | 1 |
310099 | 310099 | 2020-07-07 | Cowley | Kansas | 20035 | 76 | 1 |
313269 | 313269 | 2020-07-08 | Cowley | Kansas | 20035 | 77 | 1 |
316443 | 316443 | 2020-07-09 | Cowley | Kansas | 20035 | 77 | 1 |
319616 | 319616 | 2020-07-10 | Cowley | Kansas | 20035 | 79 | 1 |
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);