ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where county = "Chase" and state = "Kansas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
65444 | 65444 | 2020-04-17 | Chase | Kansas | 20017 | 1 | 0 |
68193 | 68193 | 2020-04-18 | Chase | Kansas | 20017 | 1 | 0 |
70954 | 70954 | 2020-04-19 | Chase | Kansas | 20017 | 1 | 0 |
73725 | 73725 | 2020-04-20 | Chase | Kansas | 20017 | 1 | 0 |
76505 | 76505 | 2020-04-21 | Chase | Kansas | 20017 | 1 | 0 |
79289 | 79289 | 2020-04-22 | Chase | Kansas | 20017 | 1 | 0 |
82081 | 82081 | 2020-04-23 | Chase | Kansas | 20017 | 1 | 0 |
84882 | 84882 | 2020-04-24 | Chase | Kansas | 20017 | 1 | 0 |
87691 | 87691 | 2020-04-25 | Chase | Kansas | 20017 | 1 | 0 |
90507 | 90507 | 2020-04-26 | Chase | Kansas | 20017 | 1 | 0 |
93328 | 93328 | 2020-04-27 | Chase | Kansas | 20017 | 1 | 0 |
96160 | 96160 | 2020-04-28 | Chase | Kansas | 20017 | 1 | 0 |
99005 | 99005 | 2020-04-29 | Chase | Kansas | 20017 | 1 | 0 |
101856 | 101856 | 2020-04-30 | Chase | Kansas | 20017 | 1 | 0 |
104716 | 104716 | 2020-05-01 | Chase | Kansas | 20017 | 1 | 0 |
107581 | 107581 | 2020-05-02 | Chase | Kansas | 20017 | 1 | 0 |
110452 | 110452 | 2020-05-03 | Chase | Kansas | 20017 | 1 | 0 |
113328 | 113328 | 2020-05-04 | Chase | Kansas | 20017 | 1 | 0 |
116210 | 116210 | 2020-05-05 | Chase | Kansas | 20017 | 1 | 0 |
119171 | 119171 | 2020-05-06 | Chase | Kansas | 20017 | 3 | 0 |
122141 | 122141 | 2020-05-07 | Chase | Kansas | 20017 | 3 | 0 |
125123 | 125123 | 2020-05-08 | Chase | Kansas | 20017 | 3 | 0 |
128111 | 128111 | 2020-05-09 | Chase | Kansas | 20017 | 3 | 0 |
131101 | 131101 | 2020-05-10 | Chase | Kansas | 20017 | 3 | 0 |
134092 | 134092 | 2020-05-11 | Chase | Kansas | 20017 | 3 | 0 |
137082 | 137082 | 2020-05-12 | Chase | Kansas | 20017 | 3 | 0 |
140075 | 140075 | 2020-05-13 | Chase | Kansas | 20017 | 3 | 0 |
143071 | 143071 | 2020-05-14 | Chase | Kansas | 20017 | 3 | 0 |
146071 | 146071 | 2020-05-15 | Chase | Kansas | 20017 | 3 | 0 |
149075 | 149075 | 2020-05-16 | Chase | Kansas | 20017 | 3 | 0 |
152086 | 152086 | 2020-05-17 | Chase | Kansas | 20017 | 3 | 0 |
155098 | 155098 | 2020-05-18 | Chase | Kansas | 20017 | 3 | 0 |
158115 | 158115 | 2020-05-19 | Chase | Kansas | 20017 | 3 | 0 |
161140 | 161140 | 2020-05-20 | Chase | Kansas | 20017 | 3 | 0 |
164169 | 164169 | 2020-05-21 | Chase | Kansas | 20017 | 3 | 0 |
167201 | 167201 | 2020-05-22 | Chase | Kansas | 20017 | 3 | 0 |
170239 | 170239 | 2020-05-23 | Chase | Kansas | 20017 | 3 | 0 |
173280 | 173280 | 2020-05-24 | Chase | Kansas | 20017 | 3 | 0 |
176324 | 176324 | 2020-05-25 | Chase | Kansas | 20017 | 4 | 0 |
179368 | 179368 | 2020-05-26 | Chase | Kansas | 20017 | 4 | 0 |
182413 | 182413 | 2020-05-27 | Chase | Kansas | 20017 | 4 | 0 |
185467 | 185467 | 2020-05-28 | Chase | Kansas | 20017 | 4 | 0 |
188525 | 188525 | 2020-05-29 | Chase | Kansas | 20017 | 4 | 0 |
191589 | 191589 | 2020-05-30 | Chase | Kansas | 20017 | 4 | 0 |
194657 | 194657 | 2020-05-31 | Chase | Kansas | 20017 | 4 | 0 |
197727 | 197727 | 2020-06-01 | Chase | Kansas | 20017 | 4 | 0 |
200799 | 200799 | 2020-06-02 | Chase | Kansas | 20017 | 4 | 0 |
203875 | 203875 | 2020-06-03 | Chase | Kansas | 20017 | 4 | 0 |
206956 | 206956 | 2020-06-04 | Chase | Kansas | 20017 | 4 | 0 |
210037 | 210037 | 2020-06-05 | Chase | Kansas | 20017 | 4 | 0 |
213122 | 213122 | 2020-06-06 | Chase | Kansas | 20017 | 4 | 0 |
216209 | 216209 | 2020-06-07 | Chase | Kansas | 20017 | 4 | 0 |
219301 | 219301 | 2020-06-08 | Chase | Kansas | 20017 | 4 | 0 |
222396 | 222396 | 2020-06-09 | Chase | Kansas | 20017 | 4 | 0 |
225491 | 225491 | 2020-06-10 | Chase | Kansas | 20017 | 4 | 0 |
228593 | 228593 | 2020-06-11 | Chase | Kansas | 20017 | 4 | 0 |
231696 | 231696 | 2020-06-12 | Chase | Kansas | 20017 | 4 | 0 |
234802 | 234802 | 2020-06-13 | Chase | Kansas | 20017 | 4 | 0 |
237909 | 237909 | 2020-06-14 | Chase | Kansas | 20017 | 3 | 0 |
241018 | 241018 | 2020-06-15 | Chase | Kansas | 20017 | 3 | 0 |
244129 | 244129 | 2020-06-16 | Chase | Kansas | 20017 | 3 | 0 |
247242 | 247242 | 2020-06-17 | Chase | Kansas | 20017 | 3 | 0 |
250354 | 250354 | 2020-06-18 | Chase | Kansas | 20017 | 3 | 0 |
253469 | 253469 | 2020-06-19 | Chase | Kansas | 20017 | 4 | 0 |
256589 | 256589 | 2020-06-20 | Chase | Kansas | 20017 | 4 | 0 |
259715 | 259715 | 2020-06-21 | Chase | Kansas | 20017 | 4 | 0 |
262842 | 262842 | 2020-06-22 | Chase | Kansas | 20017 | 4 | 0 |
265970 | 265970 | 2020-06-23 | Chase | Kansas | 20017 | 4 | 0 |
269100 | 269100 | 2020-06-24 | Chase | Kansas | 20017 | 4 | 0 |
272237 | 272237 | 2020-06-25 | Chase | Kansas | 20017 | 4 | 0 |
275379 | 275379 | 2020-06-26 | Chase | Kansas | 20017 | 4 | 0 |
278527 | 278527 | 2020-06-27 | Chase | Kansas | 20017 | 4 | 0 |
281675 | 281675 | 2020-06-28 | Chase | Kansas | 20017 | 4 | 0 |
284820 | 284820 | 2020-06-29 | Chase | Kansas | 20017 | 4 | 0 |
287969 | 287969 | 2020-06-30 | Chase | Kansas | 20017 | 4 | 0 |
291119 | 291119 | 2020-07-01 | Chase | Kansas | 20017 | 4 | 0 |
294273 | 294273 | 2020-07-02 | Chase | Kansas | 20017 | 4 | 0 |
297431 | 297431 | 2020-07-03 | Chase | Kansas | 20017 | 5 | 0 |
300593 | 300593 | 2020-07-04 | Chase | Kansas | 20017 | 5 | 0 |
303757 | 303757 | 2020-07-05 | Chase | Kansas | 20017 | 5 | 0 |
306922 | 306922 | 2020-07-06 | Chase | Kansas | 20017 | 5 | 0 |
310090 | 310090 | 2020-07-07 | Chase | Kansas | 20017 | 5 | 0 |
313260 | 313260 | 2020-07-08 | Chase | Kansas | 20017 | 5 | 0 |
316434 | 316434 | 2020-07-09 | Chase | Kansas | 20017 | 5 | 0 |
319607 | 319607 | 2020-07-10 | Chase | Kansas | 20017 | 5 | 0 |
322786 | 322786 | 2020-07-11 | Chase | Kansas | 20017 | 5 | 0 |
325967 | 325967 | 2020-07-12 | Chase | Kansas | 20017 | 5 | 0 |
329153 | 329153 | 2020-07-13 | Chase | Kansas | 20017 | 6 | 0 |
332340 | 332340 | 2020-07-14 | Chase | Kansas | 20017 | 6 | 0 |
335533 | 335533 | 2020-07-15 | Chase | Kansas | 20017 | 6 | 0 |
338729 | 338729 | 2020-07-16 | Chase | Kansas | 20017 | 6 | 0 |
341925 | 341925 | 2020-07-17 | Chase | Kansas | 20017 | 6 | 0 |
345125 | 345125 | 2020-07-18 | Chase | Kansas | 20017 | 6 | 0 |
348326 | 348326 | 2020-07-19 | Chase | Kansas | 20017 | 6 | 0 |
351526 | 351526 | 2020-07-20 | Chase | Kansas | 20017 | 6 | 0 |
354728 | 354728 | 2020-07-21 | Chase | Kansas | 20017 | 6 | 0 |
357930 | 357930 | 2020-07-22 | Chase | Kansas | 20017 | 6 | 0 |
361135 | 361135 | 2020-07-23 | Chase | Kansas | 20017 | 6 | 0 |
364342 | 364342 | 2020-07-24 | Chase | Kansas | 20017 | 6 | 0 |
367549 | 367549 | 2020-07-25 | Chase | Kansas | 20017 | 6 | 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);