ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
740 rows where fips = 20013 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 |
---|---|---|---|---|---|---|---|
113326 | 113326 | 2020-05-04 | Brown | Kansas | 20013 | 1 | 0 |
116208 | 116208 | 2020-05-05 | Brown | Kansas | 20013 | 1 | 0 |
119169 | 119169 | 2020-05-06 | Brown | Kansas | 20013 | 1 | 0 |
122139 | 122139 | 2020-05-07 | Brown | Kansas | 20013 | 1 | 0 |
125121 | 125121 | 2020-05-08 | Brown | Kansas | 20013 | 1 | 0 |
128109 | 128109 | 2020-05-09 | Brown | Kansas | 20013 | 1 | 0 |
131099 | 131099 | 2020-05-10 | Brown | Kansas | 20013 | 1 | 0 |
134090 | 134090 | 2020-05-11 | Brown | Kansas | 20013 | 1 | 0 |
137080 | 137080 | 2020-05-12 | Brown | Kansas | 20013 | 1 | 0 |
140073 | 140073 | 2020-05-13 | Brown | Kansas | 20013 | 1 | 0 |
143069 | 143069 | 2020-05-14 | Brown | Kansas | 20013 | 1 | 0 |
146069 | 146069 | 2020-05-15 | Brown | Kansas | 20013 | 3 | 0 |
149073 | 149073 | 2020-05-16 | Brown | Kansas | 20013 | 3 | 0 |
152084 | 152084 | 2020-05-17 | Brown | Kansas | 20013 | 3 | 0 |
155096 | 155096 | 2020-05-18 | Brown | Kansas | 20013 | 5 | 0 |
158113 | 158113 | 2020-05-19 | Brown | Kansas | 20013 | 5 | 0 |
161138 | 161138 | 2020-05-20 | Brown | Kansas | 20013 | 5 | 0 |
164167 | 164167 | 2020-05-21 | Brown | Kansas | 20013 | 5 | 0 |
167199 | 167199 | 2020-05-22 | Brown | Kansas | 20013 | 5 | 0 |
170237 | 170237 | 2020-05-23 | Brown | Kansas | 20013 | 5 | 0 |
173278 | 173278 | 2020-05-24 | Brown | Kansas | 20013 | 5 | 0 |
176322 | 176322 | 2020-05-25 | Brown | Kansas | 20013 | 6 | 0 |
179366 | 179366 | 2020-05-26 | Brown | Kansas | 20013 | 6 | 0 |
182411 | 182411 | 2020-05-27 | Brown | Kansas | 20013 | 6 | 0 |
185465 | 185465 | 2020-05-28 | Brown | Kansas | 20013 | 6 | 0 |
188523 | 188523 | 2020-05-29 | Brown | Kansas | 20013 | 6 | 0 |
191587 | 191587 | 2020-05-30 | Brown | Kansas | 20013 | 6 | 0 |
194655 | 194655 | 2020-05-31 | Brown | Kansas | 20013 | 6 | 0 |
197725 | 197725 | 2020-06-01 | Brown | Kansas | 20013 | 6 | 0 |
200797 | 200797 | 2020-06-02 | Brown | Kansas | 20013 | 6 | 0 |
203873 | 203873 | 2020-06-03 | Brown | Kansas | 20013 | 6 | 0 |
206954 | 206954 | 2020-06-04 | Brown | Kansas | 20013 | 6 | 0 |
210035 | 210035 | 2020-06-05 | Brown | Kansas | 20013 | 7 | 0 |
213120 | 213120 | 2020-06-06 | Brown | Kansas | 20013 | 7 | 0 |
216207 | 216207 | 2020-06-07 | Brown | Kansas | 20013 | 7 | 0 |
219299 | 219299 | 2020-06-08 | Brown | Kansas | 20013 | 9 | 0 |
222394 | 222394 | 2020-06-09 | Brown | Kansas | 20013 | 9 | 0 |
225489 | 225489 | 2020-06-10 | Brown | Kansas | 20013 | 9 | 0 |
228591 | 228591 | 2020-06-11 | Brown | Kansas | 20013 | 9 | 0 |
231694 | 231694 | 2020-06-12 | Brown | Kansas | 20013 | 10 | 0 |
234800 | 234800 | 2020-06-13 | Brown | Kansas | 20013 | 10 | 0 |
237907 | 237907 | 2020-06-14 | Brown | Kansas | 20013 | 10 | 0 |
241016 | 241016 | 2020-06-15 | Brown | Kansas | 20013 | 10 | 0 |
244127 | 244127 | 2020-06-16 | Brown | Kansas | 20013 | 10 | 0 |
247240 | 247240 | 2020-06-17 | Brown | Kansas | 20013 | 10 | 0 |
250352 | 250352 | 2020-06-18 | Brown | Kansas | 20013 | 10 | 0 |
253467 | 253467 | 2020-06-19 | Brown | Kansas | 20013 | 11 | 0 |
256587 | 256587 | 2020-06-20 | Brown | Kansas | 20013 | 11 | 0 |
259713 | 259713 | 2020-06-21 | Brown | Kansas | 20013 | 11 | 0 |
262840 | 262840 | 2020-06-22 | Brown | Kansas | 20013 | 11 | 0 |
265968 | 265968 | 2020-06-23 | Brown | Kansas | 20013 | 11 | 0 |
269098 | 269098 | 2020-06-24 | Brown | Kansas | 20013 | 11 | 0 |
272235 | 272235 | 2020-06-25 | Brown | Kansas | 20013 | 11 | 0 |
275377 | 275377 | 2020-06-26 | Brown | Kansas | 20013 | 11 | 0 |
278525 | 278525 | 2020-06-27 | Brown | Kansas | 20013 | 11 | 0 |
281673 | 281673 | 2020-06-28 | Brown | Kansas | 20013 | 11 | 0 |
284818 | 284818 | 2020-06-29 | Brown | Kansas | 20013 | 11 | 0 |
287967 | 287967 | 2020-06-30 | Brown | Kansas | 20013 | 11 | 0 |
291117 | 291117 | 2020-07-01 | Brown | Kansas | 20013 | 11 | 0 |
294271 | 294271 | 2020-07-02 | Brown | Kansas | 20013 | 11 | 0 |
297429 | 297429 | 2020-07-03 | Brown | Kansas | 20013 | 12 | 0 |
300591 | 300591 | 2020-07-04 | Brown | Kansas | 20013 | 12 | 0 |
303755 | 303755 | 2020-07-05 | Brown | Kansas | 20013 | 12 | 0 |
306920 | 306920 | 2020-07-06 | Brown | Kansas | 20013 | 12 | 0 |
310088 | 310088 | 2020-07-07 | Brown | Kansas | 20013 | 12 | 0 |
313258 | 313258 | 2020-07-08 | Brown | Kansas | 20013 | 12 | 0 |
316432 | 316432 | 2020-07-09 | Brown | Kansas | 20013 | 12 | 0 |
319605 | 319605 | 2020-07-10 | Brown | Kansas | 20013 | 19 | 0 |
322784 | 322784 | 2020-07-11 | Brown | Kansas | 20013 | 19 | 0 |
325965 | 325965 | 2020-07-12 | Brown | Kansas | 20013 | 19 | 0 |
329151 | 329151 | 2020-07-13 | Brown | Kansas | 20013 | 23 | 0 |
332338 | 332338 | 2020-07-14 | Brown | Kansas | 20013 | 23 | 0 |
335531 | 335531 | 2020-07-15 | Brown | Kansas | 20013 | 23 | 0 |
338727 | 338727 | 2020-07-16 | Brown | Kansas | 20013 | 23 | 0 |
341923 | 341923 | 2020-07-17 | Brown | Kansas | 20013 | 24 | 0 |
345123 | 345123 | 2020-07-18 | Brown | Kansas | 20013 | 24 | 0 |
348324 | 348324 | 2020-07-19 | Brown | Kansas | 20013 | 24 | 0 |
351524 | 351524 | 2020-07-20 | Brown | Kansas | 20013 | 25 | 0 |
354726 | 354726 | 2020-07-21 | Brown | Kansas | 20013 | 25 | 0 |
357928 | 357928 | 2020-07-22 | Brown | Kansas | 20013 | 25 | 0 |
361133 | 361133 | 2020-07-23 | Brown | Kansas | 20013 | 25 | 0 |
364340 | 364340 | 2020-07-24 | Brown | Kansas | 20013 | 25 | 0 |
367547 | 367547 | 2020-07-25 | Brown | Kansas | 20013 | 25 | 0 |
370757 | 370757 | 2020-07-26 | Brown | Kansas | 20013 | 25 | 0 |
373969 | 373969 | 2020-07-27 | Brown | Kansas | 20013 | 27 | 0 |
377184 | 377184 | 2020-07-28 | Brown | Kansas | 20013 | 27 | 0 |
380401 | 380401 | 2020-07-29 | Brown | Kansas | 20013 | 28 | 0 |
383618 | 383618 | 2020-07-30 | Brown | Kansas | 20013 | 28 | 0 |
386836 | 386836 | 2020-07-31 | Brown | Kansas | 20013 | 36 | 0 |
390053 | 390053 | 2020-08-01 | Brown | Kansas | 20013 | 36 | 0 |
393270 | 393270 | 2020-08-02 | Brown | Kansas | 20013 | 36 | 0 |
396486 | 396486 | 2020-08-03 | Brown | Kansas | 20013 | 36 | 0 |
399701 | 399701 | 2020-08-04 | Brown | Kansas | 20013 | 36 | 0 |
402918 | 402918 | 2020-08-05 | Brown | Kansas | 20013 | 40 | 0 |
406136 | 406136 | 2020-08-06 | Brown | Kansas | 20013 | 40 | 0 |
409355 | 409355 | 2020-08-07 | Brown | Kansas | 20013 | 42 | 0 |
412575 | 412575 | 2020-08-08 | Brown | Kansas | 20013 | 42 | 0 |
415795 | 415795 | 2020-08-09 | Brown | Kansas | 20013 | 42 | 0 |
419016 | 419016 | 2020-08-10 | Brown | Kansas | 20013 | 44 | 0 |
422239 | 422239 | 2020-08-11 | Brown | Kansas | 20013 | 44 | 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);