ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
722 rows where fips = 20083 and state = "Kansas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
167230 | 167230 | 2020-05-22 | Hodgeman | Kansas | 20083 | 1 | 0 |
170268 | 170268 | 2020-05-23 | Hodgeman | Kansas | 20083 | 1 | 0 |
173309 | 173309 | 2020-05-24 | Hodgeman | Kansas | 20083 | 1 | 0 |
176353 | 176353 | 2020-05-25 | Hodgeman | Kansas | 20083 | 1 | 0 |
179397 | 179397 | 2020-05-26 | Hodgeman | Kansas | 20083 | 1 | 0 |
182442 | 182442 | 2020-05-27 | Hodgeman | Kansas | 20083 | 1 | 0 |
185496 | 185496 | 2020-05-28 | Hodgeman | Kansas | 20083 | 1 | 0 |
188554 | 188554 | 2020-05-29 | Hodgeman | Kansas | 20083 | 4 | 0 |
191618 | 191618 | 2020-05-30 | Hodgeman | Kansas | 20083 | 4 | 0 |
194686 | 194686 | 2020-05-31 | Hodgeman | Kansas | 20083 | 4 | 0 |
197756 | 197756 | 2020-06-01 | Hodgeman | Kansas | 20083 | 5 | 0 |
200828 | 200828 | 2020-06-02 | Hodgeman | Kansas | 20083 | 5 | 0 |
203904 | 203904 | 2020-06-03 | Hodgeman | Kansas | 20083 | 5 | 0 |
206985 | 206985 | 2020-06-04 | Hodgeman | Kansas | 20083 | 5 | 0 |
210066 | 210066 | 2020-06-05 | Hodgeman | Kansas | 20083 | 5 | 0 |
213151 | 213151 | 2020-06-06 | Hodgeman | Kansas | 20083 | 5 | 0 |
216238 | 216238 | 2020-06-07 | Hodgeman | Kansas | 20083 | 5 | 0 |
219330 | 219330 | 2020-06-08 | Hodgeman | Kansas | 20083 | 6 | 0 |
222425 | 222425 | 2020-06-09 | Hodgeman | Kansas | 20083 | 6 | 0 |
225520 | 225520 | 2020-06-10 | Hodgeman | Kansas | 20083 | 5 | 0 |
228622 | 228622 | 2020-06-11 | Hodgeman | Kansas | 20083 | 5 | 0 |
231725 | 231725 | 2020-06-12 | Hodgeman | Kansas | 20083 | 5 | 0 |
234831 | 234831 | 2020-06-13 | Hodgeman | Kansas | 20083 | 5 | 0 |
237938 | 237938 | 2020-06-14 | Hodgeman | Kansas | 20083 | 5 | 0 |
241047 | 241047 | 2020-06-15 | Hodgeman | Kansas | 20083 | 6 | 0 |
244158 | 244158 | 2020-06-16 | Hodgeman | Kansas | 20083 | 6 | 0 |
247271 | 247271 | 2020-06-17 | Hodgeman | Kansas | 20083 | 7 | 0 |
250383 | 250383 | 2020-06-18 | Hodgeman | Kansas | 20083 | 7 | 0 |
253498 | 253498 | 2020-06-19 | Hodgeman | Kansas | 20083 | 8 | 0 |
256618 | 256618 | 2020-06-20 | Hodgeman | Kansas | 20083 | 8 | 0 |
259744 | 259744 | 2020-06-21 | Hodgeman | Kansas | 20083 | 8 | 0 |
262871 | 262871 | 2020-06-22 | Hodgeman | Kansas | 20083 | 9 | 0 |
265999 | 265999 | 2020-06-23 | Hodgeman | Kansas | 20083 | 9 | 0 |
269129 | 269129 | 2020-06-24 | Hodgeman | Kansas | 20083 | 9 | 0 |
272266 | 272266 | 2020-06-25 | Hodgeman | Kansas | 20083 | 9 | 0 |
275409 | 275409 | 2020-06-26 | Hodgeman | Kansas | 20083 | 9 | 0 |
278557 | 278557 | 2020-06-27 | Hodgeman | Kansas | 20083 | 9 | 0 |
281705 | 281705 | 2020-06-28 | Hodgeman | Kansas | 20083 | 9 | 0 |
284850 | 284850 | 2020-06-29 | Hodgeman | Kansas | 20083 | 9 | 0 |
287999 | 287999 | 2020-06-30 | Hodgeman | Kansas | 20083 | 9 | 0 |
291149 | 291149 | 2020-07-01 | Hodgeman | Kansas | 20083 | 9 | 0 |
294303 | 294303 | 2020-07-02 | Hodgeman | Kansas | 20083 | 9 | 0 |
297461 | 297461 | 2020-07-03 | Hodgeman | Kansas | 20083 | 9 | 0 |
300623 | 300623 | 2020-07-04 | Hodgeman | Kansas | 20083 | 9 | 0 |
303787 | 303787 | 2020-07-05 | Hodgeman | Kansas | 20083 | 9 | 0 |
306953 | 306953 | 2020-07-06 | Hodgeman | Kansas | 20083 | 9 | 0 |
310121 | 310121 | 2020-07-07 | Hodgeman | Kansas | 20083 | 9 | 0 |
313291 | 313291 | 2020-07-08 | Hodgeman | Kansas | 20083 | 9 | 0 |
316465 | 316465 | 2020-07-09 | Hodgeman | Kansas | 20083 | 9 | 0 |
319638 | 319638 | 2020-07-10 | Hodgeman | Kansas | 20083 | 9 | 0 |
322817 | 322817 | 2020-07-11 | Hodgeman | Kansas | 20083 | 9 | 0 |
326000 | 326000 | 2020-07-12 | Hodgeman | Kansas | 20083 | 9 | 0 |
329186 | 329186 | 2020-07-13 | Hodgeman | Kansas | 20083 | 10 | 0 |
332373 | 332373 | 2020-07-14 | Hodgeman | Kansas | 20083 | 10 | 0 |
335566 | 335566 | 2020-07-15 | Hodgeman | Kansas | 20083 | 10 | 0 |
338762 | 338762 | 2020-07-16 | Hodgeman | Kansas | 20083 | 10 | 0 |
341958 | 341958 | 2020-07-17 | Hodgeman | Kansas | 20083 | 10 | 0 |
345158 | 345158 | 2020-07-18 | Hodgeman | Kansas | 20083 | 10 | 0 |
348359 | 348359 | 2020-07-19 | Hodgeman | Kansas | 20083 | 10 | 0 |
351559 | 351559 | 2020-07-20 | Hodgeman | Kansas | 20083 | 10 | 0 |
354761 | 354761 | 2020-07-21 | Hodgeman | Kansas | 20083 | 10 | 0 |
357963 | 357963 | 2020-07-22 | Hodgeman | Kansas | 20083 | 10 | 0 |
361168 | 361168 | 2020-07-23 | Hodgeman | Kansas | 20083 | 10 | 0 |
364375 | 364375 | 2020-07-24 | Hodgeman | Kansas | 20083 | 10 | 0 |
367582 | 367582 | 2020-07-25 | Hodgeman | Kansas | 20083 | 10 | 0 |
370792 | 370792 | 2020-07-26 | Hodgeman | Kansas | 20083 | 10 | 0 |
374004 | 374004 | 2020-07-27 | Hodgeman | Kansas | 20083 | 11 | 0 |
377219 | 377219 | 2020-07-28 | Hodgeman | Kansas | 20083 | 11 | 0 |
380436 | 380436 | 2020-07-29 | Hodgeman | Kansas | 20083 | 11 | 0 |
383653 | 383653 | 2020-07-30 | Hodgeman | Kansas | 20083 | 11 | 0 |
386871 | 386871 | 2020-07-31 | Hodgeman | Kansas | 20083 | 11 | 0 |
390088 | 390088 | 2020-08-01 | Hodgeman | Kansas | 20083 | 11 | 0 |
393305 | 393305 | 2020-08-02 | Hodgeman | Kansas | 20083 | 11 | 0 |
396521 | 396521 | 2020-08-03 | Hodgeman | Kansas | 20083 | 11 | 0 |
399736 | 399736 | 2020-08-04 | Hodgeman | Kansas | 20083 | 11 | 0 |
402953 | 402953 | 2020-08-05 | Hodgeman | Kansas | 20083 | 11 | 0 |
406171 | 406171 | 2020-08-06 | Hodgeman | Kansas | 20083 | 11 | 0 |
409390 | 409390 | 2020-08-07 | Hodgeman | Kansas | 20083 | 11 | 0 |
412610 | 412610 | 2020-08-08 | Hodgeman | Kansas | 20083 | 11 | 0 |
415830 | 415830 | 2020-08-09 | Hodgeman | Kansas | 20083 | 11 | 0 |
419051 | 419051 | 2020-08-10 | Hodgeman | Kansas | 20083 | 11 | 0 |
422274 | 422274 | 2020-08-11 | Hodgeman | Kansas | 20083 | 11 | 0 |
425495 | 425495 | 2020-08-12 | Hodgeman | Kansas | 20083 | 11 | 0 |
428719 | 428719 | 2020-08-13 | Hodgeman | Kansas | 20083 | 11 | 0 |
431947 | 431947 | 2020-08-14 | Hodgeman | Kansas | 20083 | 11 | 0 |
435172 | 435172 | 2020-08-15 | Hodgeman | Kansas | 20083 | 11 | 0 |
438397 | 438397 | 2020-08-16 | Hodgeman | Kansas | 20083 | 11 | 0 |
441624 | 441624 | 2020-08-17 | Hodgeman | Kansas | 20083 | 11 | 0 |
444850 | 444850 | 2020-08-18 | Hodgeman | Kansas | 20083 | 11 | 0 |
448077 | 448077 | 2020-08-19 | Hodgeman | Kansas | 20083 | 12 | 0 |
451305 | 451305 | 2020-08-20 | Hodgeman | Kansas | 20083 | 12 | 0 |
454533 | 454533 | 2020-08-21 | Hodgeman | Kansas | 20083 | 11 | 0 |
457761 | 457761 | 2020-08-22 | Hodgeman | Kansas | 20083 | 11 | 0 |
460988 | 460988 | 2020-08-23 | Hodgeman | Kansas | 20083 | 11 | 0 |
464217 | 464217 | 2020-08-24 | Hodgeman | Kansas | 20083 | 13 | 0 |
467446 | 467446 | 2020-08-25 | Hodgeman | Kansas | 20083 | 13 | 0 |
470675 | 470675 | 2020-08-26 | Hodgeman | Kansas | 20083 | 14 | 0 |
473907 | 473907 | 2020-08-27 | Hodgeman | Kansas | 20083 | 14 | 0 |
477140 | 477140 | 2020-08-28 | Hodgeman | Kansas | 20083 | 14 | 0 |
480373 | 480373 | 2020-08-29 | Hodgeman | Kansas | 20083 | 14 | 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);