ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where county = "Hamilton", deaths = 3 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
655192 | 655192 | 2020-10-22 | Hamilton | Iowa | 19079 | 461 | 3 |
651947 | 651947 | 2020-10-21 | Hamilton | Iowa | 19079 | 454 | 3 |
648703 | 648703 | 2020-10-20 | Hamilton | Iowa | 19079 | 451 | 3 |
645458 | 645458 | 2020-10-19 | Hamilton | Iowa | 19079 | 443 | 3 |
642211 | 642211 | 2020-10-18 | Hamilton | Iowa | 19079 | 431 | 3 |
638964 | 638964 | 2020-10-17 | Hamilton | Iowa | 19079 | 429 | 3 |
635718 | 635718 | 2020-10-16 | Hamilton | Iowa | 19079 | 427 | 3 |
632472 | 632472 | 2020-10-15 | Hamilton | Iowa | 19079 | 422 | 3 |
629228 | 629228 | 2020-10-14 | Hamilton | Iowa | 19079 | 420 | 3 |
625985 | 625985 | 2020-10-13 | Hamilton | Iowa | 19079 | 407 | 3 |
622743 | 622743 | 2020-10-12 | Hamilton | Iowa | 19079 | 391 | 3 |
619499 | 619499 | 2020-10-11 | Hamilton | Iowa | 19079 | 388 | 3 |
616257 | 616257 | 2020-10-10 | Hamilton | Iowa | 19079 | 382 | 3 |
613016 | 613016 | 2020-10-09 | Hamilton | Iowa | 19079 | 382 | 3 |
609774 | 609774 | 2020-10-08 | Hamilton | Iowa | 19079 | 371 | 3 |
606531 | 606531 | 2020-10-07 | Hamilton | Iowa | 19079 | 348 | 3 |
603289 | 603289 | 2020-10-06 | Hamilton | Iowa | 19079 | 347 | 3 |
600046 | 600046 | 2020-10-05 | Hamilton | Iowa | 19079 | 346 | 3 |
596804 | 596804 | 2020-10-04 | Hamilton | Iowa | 19079 | 342 | 3 |
593562 | 593562 | 2020-10-03 | Hamilton | Iowa | 19079 | 341 | 3 |
590321 | 590321 | 2020-10-02 | Hamilton | Iowa | 19079 | 341 | 3 |
587080 | 587080 | 2020-10-01 | Hamilton | Iowa | 19079 | 340 | 3 |
583840 | 583840 | 2020-09-30 | Hamilton | Iowa | 19079 | 337 | 3 |
580601 | 580601 | 2020-09-29 | Hamilton | Iowa | 19079 | 334 | 3 |
577360 | 577360 | 2020-09-28 | Hamilton | Iowa | 19079 | 332 | 3 |
574118 | 574118 | 2020-09-27 | Hamilton | Iowa | 19079 | 327 | 3 |
570875 | 570875 | 2020-09-26 | Hamilton | Iowa | 19079 | 322 | 3 |
567633 | 567633 | 2020-09-25 | Hamilton | Iowa | 19079 | 322 | 3 |
564393 | 564393 | 2020-09-24 | Hamilton | Iowa | 19079 | 322 | 3 |
561153 | 561153 | 2020-09-23 | Hamilton | Iowa | 19079 | 323 | 3 |
557917 | 557917 | 2020-09-22 | Hamilton | Iowa | 19079 | 317 | 3 |
554680 | 554680 | 2020-09-21 | Hamilton | Iowa | 19079 | 315 | 3 |
551441 | 551441 | 2020-09-20 | Hamilton | Iowa | 19079 | 314 | 3 |
548202 | 548202 | 2020-09-19 | Hamilton | Iowa | 19079 | 314 | 3 |
544964 | 544964 | 2020-09-18 | Hamilton | Iowa | 19079 | 314 | 3 |
541728 | 541728 | 2020-09-17 | Hamilton | Iowa | 19079 | 313 | 3 |
538491 | 538491 | 2020-09-16 | Hamilton | Iowa | 19079 | 311 | 3 |
535255 | 535255 | 2020-09-15 | Hamilton | Iowa | 19079 | 311 | 3 |
532020 | 532020 | 2020-09-14 | Hamilton | Iowa | 19079 | 307 | 3 |
528783 | 528783 | 2020-09-13 | Hamilton | Iowa | 19079 | 307 | 3 |
525547 | 525547 | 2020-09-12 | Hamilton | Iowa | 19079 | 305 | 3 |
522311 | 522311 | 2020-09-11 | Hamilton | Iowa | 19079 | 304 | 3 |
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);