ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Phillips" and state = "Kansas" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
49278 | 49278 | 2020-04-11 | Phillips | Kansas | 20147 | 1 | 0 |
51943 | 51943 | 2020-04-12 | Phillips | Kansas | 20147 | 1 | 0 |
54625 | 54625 | 2020-04-13 | Phillips | Kansas | 20147 | 1 | 0 |
57319 | 57319 | 2020-04-14 | Phillips | Kansas | 20147 | 1 | 0 |
60027 | 60027 | 2020-04-15 | Phillips | Kansas | 20147 | 1 | 0 |
62748 | 62748 | 2020-04-16 | Phillips | Kansas | 20147 | 1 | 0 |
65484 | 65484 | 2020-04-17 | Phillips | Kansas | 20147 | 1 | 0 |
68233 | 68233 | 2020-04-18 | Phillips | Kansas | 20147 | 1 | 0 |
70994 | 70994 | 2020-04-19 | Phillips | Kansas | 20147 | 1 | 0 |
73766 | 73766 | 2020-04-20 | Phillips | Kansas | 20147 | 1 | 0 |
76546 | 76546 | 2020-04-21 | Phillips | Kansas | 20147 | 1 | 0 |
79331 | 79331 | 2020-04-22 | Phillips | Kansas | 20147 | 1 | 0 |
82126 | 82126 | 2020-04-23 | Phillips | Kansas | 20147 | 1 | 0 |
84929 | 84929 | 2020-04-24 | Phillips | Kansas | 20147 | 1 | 0 |
87738 | 87738 | 2020-04-25 | Phillips | Kansas | 20147 | 1 | 0 |
90554 | 90554 | 2020-04-26 | Phillips | Kansas | 20147 | 1 | 0 |
93375 | 93375 | 2020-04-27 | Phillips | Kansas | 20147 | 1 | 0 |
96208 | 96208 | 2020-04-28 | Phillips | Kansas | 20147 | 1 | 0 |
99054 | 99054 | 2020-04-29 | Phillips | Kansas | 20147 | 1 | 0 |
101906 | 101906 | 2020-04-30 | Phillips | Kansas | 20147 | 1 | 0 |
104767 | 104767 | 2020-05-01 | Phillips | Kansas | 20147 | 1 | 0 |
107632 | 107632 | 2020-05-02 | Phillips | Kansas | 20147 | 1 | 0 |
110503 | 110503 | 2020-05-03 | Phillips | Kansas | 20147 | 1 | 0 |
113380 | 113380 | 2020-05-04 | Phillips | Kansas | 20147 | 1 | 0 |
116262 | 116262 | 2020-05-05 | Phillips | Kansas | 20147 | 1 | 0 |
119223 | 119223 | 2020-05-06 | Phillips | Kansas | 20147 | 1 | 0 |
122193 | 122193 | 2020-05-07 | Phillips | Kansas | 20147 | 1 | 0 |
125175 | 125175 | 2020-05-08 | Phillips | Kansas | 20147 | 1 | 0 |
128163 | 128163 | 2020-05-09 | Phillips | Kansas | 20147 | 1 | 0 |
131153 | 131153 | 2020-05-10 | Phillips | Kansas | 20147 | 1 | 0 |
134144 | 134144 | 2020-05-11 | Phillips | Kansas | 20147 | 1 | 0 |
137134 | 137134 | 2020-05-12 | Phillips | Kansas | 20147 | 1 | 0 |
140127 | 140127 | 2020-05-13 | Phillips | Kansas | 20147 | 1 | 0 |
143123 | 143123 | 2020-05-14 | Phillips | Kansas | 20147 | 1 | 0 |
146123 | 146123 | 2020-05-15 | Phillips | Kansas | 20147 | 2 | 0 |
149127 | 149127 | 2020-05-16 | Phillips | Kansas | 20147 | 2 | 0 |
152138 | 152138 | 2020-05-17 | Phillips | Kansas | 20147 | 2 | 0 |
155151 | 155151 | 2020-05-18 | Phillips | Kansas | 20147 | 2 | 0 |
158168 | 158168 | 2020-05-19 | Phillips | Kansas | 20147 | 2 | 0 |
161193 | 161193 | 2020-05-20 | Phillips | Kansas | 20147 | 2 | 0 |
164222 | 164222 | 2020-05-21 | Phillips | Kansas | 20147 | 2 | 0 |
167257 | 167257 | 2020-05-22 | Phillips | Kansas | 20147 | 2 | 0 |
170295 | 170295 | 2020-05-23 | Phillips | Kansas | 20147 | 2 | 0 |
173336 | 173336 | 2020-05-24 | Phillips | Kansas | 20147 | 2 | 0 |
176380 | 176380 | 2020-05-25 | Phillips | Kansas | 20147 | 2 | 0 |
179424 | 179424 | 2020-05-26 | Phillips | Kansas | 20147 | 2 | 0 |
182469 | 182469 | 2020-05-27 | Phillips | Kansas | 20147 | 2 | 0 |
185523 | 185523 | 2020-05-28 | Phillips | Kansas | 20147 | 2 | 0 |
188581 | 188581 | 2020-05-29 | Phillips | Kansas | 20147 | 2 | 0 |
191645 | 191645 | 2020-05-30 | Phillips | Kansas | 20147 | 2 | 0 |
194713 | 194713 | 2020-05-31 | Phillips | Kansas | 20147 | 2 | 0 |
197783 | 197783 | 2020-06-01 | Phillips | Kansas | 20147 | 2 | 0 |
200855 | 200855 | 2020-06-02 | Phillips | Kansas | 20147 | 2 | 0 |
203932 | 203932 | 2020-06-03 | Phillips | Kansas | 20147 | 2 | 0 |
207013 | 207013 | 2020-06-04 | Phillips | Kansas | 20147 | 2 | 0 |
210094 | 210094 | 2020-06-05 | Phillips | Kansas | 20147 | 2 | 0 |
213179 | 213179 | 2020-06-06 | Phillips | Kansas | 20147 | 2 | 0 |
216266 | 216266 | 2020-06-07 | Phillips | Kansas | 20147 | 2 | 0 |
219358 | 219358 | 2020-06-08 | Phillips | Kansas | 20147 | 2 | 0 |
222453 | 222453 | 2020-06-09 | Phillips | Kansas | 20147 | 2 | 0 |
225548 | 225548 | 2020-06-10 | Phillips | Kansas | 20147 | 2 | 0 |
228650 | 228650 | 2020-06-11 | Phillips | Kansas | 20147 | 2 | 0 |
231753 | 231753 | 2020-06-12 | Phillips | Kansas | 20147 | 2 | 0 |
234859 | 234859 | 2020-06-13 | Phillips | Kansas | 20147 | 2 | 0 |
237966 | 237966 | 2020-06-14 | Phillips | Kansas | 20147 | 2 | 0 |
241075 | 241075 | 2020-06-15 | Phillips | Kansas | 20147 | 2 | 0 |
244186 | 244186 | 2020-06-16 | Phillips | Kansas | 20147 | 2 | 0 |
247299 | 247299 | 2020-06-17 | Phillips | Kansas | 20147 | 2 | 0 |
250411 | 250411 | 2020-06-18 | Phillips | Kansas | 20147 | 2 | 0 |
253526 | 253526 | 2020-06-19 | Phillips | Kansas | 20147 | 2 | 0 |
256646 | 256646 | 2020-06-20 | Phillips | Kansas | 20147 | 2 | 0 |
259772 | 259772 | 2020-06-21 | Phillips | Kansas | 20147 | 2 | 0 |
262899 | 262899 | 2020-06-22 | Phillips | Kansas | 20147 | 3 | 0 |
266027 | 266027 | 2020-06-23 | Phillips | Kansas | 20147 | 3 | 0 |
269159 | 269159 | 2020-06-24 | Phillips | Kansas | 20147 | 3 | 0 |
272296 | 272296 | 2020-06-25 | Phillips | Kansas | 20147 | 3 | 0 |
275439 | 275439 | 2020-06-26 | Phillips | Kansas | 20147 | 3 | 0 |
278587 | 278587 | 2020-06-27 | Phillips | Kansas | 20147 | 3 | 0 |
281735 | 281735 | 2020-06-28 | Phillips | Kansas | 20147 | 3 | 0 |
284880 | 284880 | 2020-06-29 | Phillips | Kansas | 20147 | 3 | 0 |
288029 | 288029 | 2020-06-30 | Phillips | Kansas | 20147 | 3 | 0 |
291179 | 291179 | 2020-07-01 | Phillips | Kansas | 20147 | 3 | 0 |
294333 | 294333 | 2020-07-02 | Phillips | Kansas | 20147 | 3 | 0 |
297491 | 297491 | 2020-07-03 | Phillips | Kansas | 20147 | 10 | 0 |
300653 | 300653 | 2020-07-04 | Phillips | Kansas | 20147 | 10 | 0 |
303817 | 303817 | 2020-07-05 | Phillips | Kansas | 20147 | 10 | 0 |
306984 | 306984 | 2020-07-06 | Phillips | Kansas | 20147 | 27 | 0 |
310152 | 310152 | 2020-07-07 | Phillips | Kansas | 20147 | 27 | 0 |
313322 | 313322 | 2020-07-08 | Phillips | Kansas | 20147 | 27 | 0 |
316496 | 316496 | 2020-07-09 | Phillips | Kansas | 20147 | 27 | 0 |
319670 | 319670 | 2020-07-10 | Phillips | Kansas | 20147 | 28 | 0 |
322849 | 322849 | 2020-07-11 | Phillips | Kansas | 20147 | 28 | 0 |
326032 | 326032 | 2020-07-12 | Phillips | Kansas | 20147 | 32 | 4 |
329218 | 329218 | 2020-07-13 | Phillips | Kansas | 20147 | 33 | 4 |
332405 | 332405 | 2020-07-14 | Phillips | Kansas | 20147 | 33 | 4 |
335598 | 335598 | 2020-07-15 | Phillips | Kansas | 20147 | 34 | 4 |
338794 | 338794 | 2020-07-16 | Phillips | Kansas | 20147 | 34 | 4 |
341990 | 341990 | 2020-07-17 | Phillips | Kansas | 20147 | 35 | 4 |
345190 | 345190 | 2020-07-18 | Phillips | Kansas | 20147 | 35 | 4 |
348391 | 348391 | 2020-07-19 | Phillips | Kansas | 20147 | 35 | 4 |
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);