ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where deaths = 29, fips = 19171 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
509419 | 509419 | 2020-09-07 | Tama | Iowa | 19171 | 652 | 29 |
506187 | 506187 | 2020-09-06 | Tama | Iowa | 19171 | 652 | 29 |
502953 | 502953 | 2020-09-05 | Tama | Iowa | 19171 | 649 | 29 |
499719 | 499719 | 2020-09-04 | Tama | Iowa | 19171 | 646 | 29 |
496486 | 496486 | 2020-09-03 | Tama | Iowa | 19171 | 645 | 29 |
493252 | 493252 | 2020-09-02 | Tama | Iowa | 19171 | 628 | 29 |
490019 | 490019 | 2020-09-01 | Tama | Iowa | 19171 | 623 | 29 |
486786 | 486786 | 2020-08-31 | Tama | Iowa | 19171 | 623 | 29 |
483551 | 483551 | 2020-08-30 | Tama | Iowa | 19171 | 622 | 29 |
480317 | 480317 | 2020-08-29 | Tama | Iowa | 19171 | 619 | 29 |
477084 | 477084 | 2020-08-28 | Tama | Iowa | 19171 | 614 | 29 |
473851 | 473851 | 2020-08-27 | Tama | Iowa | 19171 | 610 | 29 |
470619 | 470619 | 2020-08-26 | Tama | Iowa | 19171 | 601 | 29 |
467390 | 467390 | 2020-08-25 | Tama | Iowa | 19171 | 590 | 29 |
464161 | 464161 | 2020-08-24 | Tama | Iowa | 19171 | 586 | 29 |
460932 | 460932 | 2020-08-23 | Tama | Iowa | 19171 | 584 | 29 |
457705 | 457705 | 2020-08-22 | Tama | Iowa | 19171 | 582 | 29 |
454477 | 454477 | 2020-08-21 | Tama | Iowa | 19171 | 582 | 29 |
451249 | 451249 | 2020-08-20 | Tama | Iowa | 19171 | 577 | 29 |
448021 | 448021 | 2020-08-19 | Tama | Iowa | 19171 | 572 | 29 |
444794 | 444794 | 2020-08-18 | Tama | Iowa | 19171 | 563 | 29 |
441568 | 441568 | 2020-08-17 | Tama | Iowa | 19171 | 562 | 29 |
438342 | 438342 | 2020-08-16 | Tama | Iowa | 19171 | 562 | 29 |
435116 | 435116 | 2020-08-15 | Tama | Iowa | 19171 | 562 | 29 |
431891 | 431891 | 2020-08-14 | Tama | Iowa | 19171 | 561 | 29 |
428663 | 428663 | 2020-08-13 | Tama | Iowa | 19171 | 560 | 29 |
425439 | 425439 | 2020-08-12 | Tama | Iowa | 19171 | 556 | 29 |
422218 | 422218 | 2020-08-11 | Tama | Iowa | 19171 | 554 | 29 |
418995 | 418995 | 2020-08-10 | Tama | Iowa | 19171 | 553 | 29 |
415774 | 415774 | 2020-08-09 | Tama | Iowa | 19171 | 551 | 29 |
412554 | 412554 | 2020-08-08 | Tama | Iowa | 19171 | 548 | 29 |
409335 | 409335 | 2020-08-07 | Tama | Iowa | 19171 | 547 | 29 |
406115 | 406115 | 2020-08-06 | Tama | Iowa | 19171 | 545 | 29 |
402897 | 402897 | 2020-08-05 | Tama | Iowa | 19171 | 543 | 29 |
399681 | 399681 | 2020-08-04 | Tama | Iowa | 19171 | 539 | 29 |
396465 | 396465 | 2020-08-03 | Tama | Iowa | 19171 | 537 | 29 |
393249 | 393249 | 2020-08-02 | Tama | Iowa | 19171 | 537 | 29 |
390032 | 390032 | 2020-08-01 | Tama | Iowa | 19171 | 535 | 29 |
386815 | 386815 | 2020-07-31 | Tama | Iowa | 19171 | 534 | 29 |
383597 | 383597 | 2020-07-30 | Tama | Iowa | 19171 | 532 | 29 |
380380 | 380380 | 2020-07-29 | Tama | Iowa | 19171 | 529 | 29 |
377163 | 377163 | 2020-07-28 | Tama | Iowa | 19171 | 524 | 29 |
373948 | 373948 | 2020-07-27 | Tama | Iowa | 19171 | 521 | 29 |
370736 | 370736 | 2020-07-26 | Tama | Iowa | 19171 | 520 | 29 |
367526 | 367526 | 2020-07-25 | Tama | Iowa | 19171 | 519 | 29 |
364319 | 364319 | 2020-07-24 | Tama | Iowa | 19171 | 517 | 29 |
361112 | 361112 | 2020-07-23 | Tama | Iowa | 19171 | 514 | 29 |
357907 | 357907 | 2020-07-22 | Tama | Iowa | 19171 | 513 | 29 |
354705 | 354705 | 2020-07-21 | Tama | Iowa | 19171 | 511 | 29 |
351503 | 351503 | 2020-07-20 | Tama | Iowa | 19171 | 510 | 29 |
348303 | 348303 | 2020-07-19 | Tama | Iowa | 19171 | 509 | 29 |
345102 | 345102 | 2020-07-18 | Tama | Iowa | 19171 | 507 | 29 |
341902 | 341902 | 2020-07-17 | Tama | Iowa | 19171 | 503 | 29 |
338706 | 338706 | 2020-07-16 | Tama | Iowa | 19171 | 500 | 29 |
335510 | 335510 | 2020-07-15 | Tama | Iowa | 19171 | 493 | 29 |
332317 | 332317 | 2020-07-14 | Tama | Iowa | 19171 | 490 | 29 |
329130 | 329130 | 2020-07-13 | Tama | Iowa | 19171 | 488 | 29 |
325944 | 325944 | 2020-07-12 | Tama | Iowa | 19171 | 487 | 29 |
322763 | 322763 | 2020-07-11 | Tama | Iowa | 19171 | 484 | 29 |
319584 | 319584 | 2020-07-10 | Tama | Iowa | 19171 | 483 | 29 |
316411 | 316411 | 2020-07-09 | Tama | Iowa | 19171 | 478 | 29 |
313237 | 313237 | 2020-07-08 | Tama | Iowa | 19171 | 473 | 29 |
310067 | 310067 | 2020-07-07 | Tama | Iowa | 19171 | 468 | 29 |
306899 | 306899 | 2020-07-06 | Tama | Iowa | 19171 | 465 | 29 |
303734 | 303734 | 2020-07-05 | Tama | Iowa | 19171 | 465 | 29 |
300570 | 300570 | 2020-07-04 | Tama | Iowa | 19171 | 463 | 29 |
297408 | 297408 | 2020-07-03 | Tama | Iowa | 19171 | 460 | 29 |
294250 | 294250 | 2020-07-02 | Tama | Iowa | 19171 | 458 | 29 |
291096 | 291096 | 2020-07-01 | Tama | Iowa | 19171 | 451 | 29 |
287946 | 287946 | 2020-06-30 | Tama | Iowa | 19171 | 445 | 29 |
284797 | 284797 | 2020-06-29 | Tama | Iowa | 19171 | 439 | 29 |
281652 | 281652 | 2020-06-28 | Tama | Iowa | 19171 | 438 | 29 |
278504 | 278504 | 2020-06-27 | Tama | Iowa | 19171 | 438 | 29 |
275356 | 275356 | 2020-06-26 | Tama | Iowa | 19171 | 435 | 29 |
272214 | 272214 | 2020-06-25 | Tama | Iowa | 19171 | 433 | 29 |
269077 | 269077 | 2020-06-24 | Tama | Iowa | 19171 | 433 | 29 |
265947 | 265947 | 2020-06-23 | Tama | Iowa | 19171 | 432 | 29 |
262819 | 262819 | 2020-06-22 | Tama | Iowa | 19171 | 432 | 29 |
259692 | 259692 | 2020-06-21 | Tama | Iowa | 19171 | 431 | 29 |
256566 | 256566 | 2020-06-20 | Tama | Iowa | 19171 | 430 | 29 |
253446 | 253446 | 2020-06-19 | Tama | Iowa | 19171 | 430 | 29 |
250331 | 250331 | 2020-06-18 | Tama | Iowa | 19171 | 429 | 29 |
247219 | 247219 | 2020-06-17 | Tama | Iowa | 19171 | 429 | 29 |
244106 | 244106 | 2020-06-16 | Tama | Iowa | 19171 | 429 | 29 |
240995 | 240995 | 2020-06-15 | Tama | Iowa | 19171 | 429 | 29 |
237887 | 237887 | 2020-06-14 | Tama | Iowa | 19171 | 427 | 29 |
234780 | 234780 | 2020-06-13 | Tama | Iowa | 19171 | 427 | 29 |
231674 | 231674 | 2020-06-12 | Tama | Iowa | 19171 | 427 | 29 |
228571 | 228571 | 2020-06-11 | Tama | Iowa | 19171 | 426 | 29 |
225469 | 225469 | 2020-06-10 | Tama | Iowa | 19171 | 418 | 29 |
222374 | 222374 | 2020-06-09 | Tama | Iowa | 19171 | 417 | 29 |
219279 | 219279 | 2020-06-08 | Tama | Iowa | 19171 | 417 | 29 |
216187 | 216187 | 2020-06-07 | Tama | Iowa | 19171 | 416 | 29 |
213100 | 213100 | 2020-06-06 | Tama | Iowa | 19171 | 415 | 29 |
210015 | 210015 | 2020-06-05 | Tama | Iowa | 19171 | 412 | 29 |
206934 | 206934 | 2020-06-04 | Tama | Iowa | 19171 | 411 | 29 |
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);