ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where county = "Jerome", deaths = 6 and state = "Idaho" 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 |
---|---|---|---|---|---|---|---|
535003 | 535003 | 2020-09-15 | Jerome | Idaho | 16053 | 695 | 6 |
531768 | 531768 | 2020-09-14 | Jerome | Idaho | 16053 | 689 | 6 |
528531 | 528531 | 2020-09-13 | Jerome | Idaho | 16053 | 681 | 6 |
525295 | 525295 | 2020-09-12 | Jerome | Idaho | 16053 | 681 | 6 |
522059 | 522059 | 2020-09-11 | Jerome | Idaho | 16053 | 679 | 6 |
518822 | 518822 | 2020-09-10 | Jerome | Idaho | 16053 | 676 | 6 |
515587 | 515587 | 2020-09-09 | Jerome | Idaho | 16053 | 661 | 6 |
512354 | 512354 | 2020-09-08 | Jerome | Idaho | 16053 | 654 | 6 |
509121 | 509121 | 2020-09-07 | Jerome | Idaho | 16053 | 639 | 6 |
505889 | 505889 | 2020-09-06 | Jerome | Idaho | 16053 | 632 | 6 |
502655 | 502655 | 2020-09-05 | Jerome | Idaho | 16053 | 627 | 6 |
499421 | 499421 | 2020-09-04 | Jerome | Idaho | 16053 | 624 | 6 |
496188 | 496188 | 2020-09-03 | Jerome | Idaho | 16053 | 623 | 6 |
492954 | 492954 | 2020-09-02 | Jerome | Idaho | 16053 | 613 | 6 |
489721 | 489721 | 2020-09-01 | Jerome | Idaho | 16053 | 607 | 6 |
486488 | 486488 | 2020-08-31 | Jerome | Idaho | 16053 | 601 | 6 |
483253 | 483253 | 2020-08-30 | Jerome | Idaho | 16053 | 597 | 6 |
480019 | 480019 | 2020-08-29 | Jerome | Idaho | 16053 | 596 | 6 |
476786 | 476786 | 2020-08-28 | Jerome | Idaho | 16053 | 593 | 6 |
473553 | 473553 | 2020-08-27 | Jerome | Idaho | 16053 | 590 | 6 |
470321 | 470321 | 2020-08-26 | Jerome | Idaho | 16053 | 579 | 6 |
467092 | 467092 | 2020-08-25 | Jerome | Idaho | 16053 | 576 | 6 |
463863 | 463863 | 2020-08-24 | Jerome | Idaho | 16053 | 571 | 6 |
460634 | 460634 | 2020-08-23 | Jerome | Idaho | 16053 | 568 | 6 |
457407 | 457407 | 2020-08-22 | Jerome | Idaho | 16053 | 560 | 6 |
454179 | 454179 | 2020-08-21 | Jerome | Idaho | 16053 | 548 | 6 |
450951 | 450951 | 2020-08-20 | Jerome | Idaho | 16053 | 544 | 6 |
447723 | 447723 | 2020-08-19 | Jerome | Idaho | 16053 | 541 | 6 |
444496 | 444496 | 2020-08-18 | Jerome | Idaho | 16053 | 536 | 6 |
441270 | 441270 | 2020-08-17 | Jerome | Idaho | 16053 | 528 | 6 |
438044 | 438044 | 2020-08-16 | Jerome | Idaho | 16053 | 525 | 6 |
434818 | 434818 | 2020-08-15 | Jerome | Idaho | 16053 | 521 | 6 |
431593 | 431593 | 2020-08-14 | Jerome | Idaho | 16053 | 517 | 6 |
428365 | 428365 | 2020-08-13 | Jerome | Idaho | 16053 | 512 | 6 |
425141 | 425141 | 2020-08-12 | Jerome | Idaho | 16053 | 501 | 6 |
421921 | 421921 | 2020-08-11 | Jerome | Idaho | 16053 | 489 | 6 |
418698 | 418698 | 2020-08-10 | Jerome | Idaho | 16053 | 484 | 6 |
415477 | 415477 | 2020-08-09 | Jerome | Idaho | 16053 | 474 | 6 |
412257 | 412257 | 2020-08-08 | Jerome | Idaho | 16053 | 471 | 6 |
409038 | 409038 | 2020-08-07 | Jerome | Idaho | 16053 | 469 | 6 |
405818 | 405818 | 2020-08-06 | Jerome | Idaho | 16053 | 458 | 6 |
402600 | 402600 | 2020-08-05 | Jerome | Idaho | 16053 | 452 | 6 |
399384 | 399384 | 2020-08-04 | Jerome | Idaho | 16053 | 439 | 6 |
396168 | 396168 | 2020-08-03 | Jerome | Idaho | 16053 | 435 | 6 |
392952 | 392952 | 2020-08-02 | Jerome | Idaho | 16053 | 426 | 6 |
389735 | 389735 | 2020-08-01 | Jerome | Idaho | 16053 | 420 | 6 |
386518 | 386518 | 2020-07-31 | Jerome | Idaho | 16053 | 414 | 6 |
383300 | 383300 | 2020-07-30 | Jerome | Idaho | 16053 | 409 | 6 |
380083 | 380083 | 2020-07-29 | Jerome | Idaho | 16053 | 401 | 6 |
376866 | 376866 | 2020-07-28 | Jerome | Idaho | 16053 | 394 | 6 |
373651 | 373651 | 2020-07-27 | Jerome | Idaho | 16053 | 389 | 6 |
370439 | 370439 | 2020-07-26 | Jerome | Idaho | 16053 | 369 | 6 |
367229 | 367229 | 2020-07-25 | Jerome | Idaho | 16053 | 369 | 6 |
364022 | 364022 | 2020-07-24 | Jerome | Idaho | 16053 | 369 | 6 |
360815 | 360815 | 2020-07-23 | Jerome | Idaho | 16053 | 364 | 6 |
357610 | 357610 | 2020-07-22 | Jerome | Idaho | 16053 | 361 | 6 |
354408 | 354408 | 2020-07-21 | Jerome | Idaho | 16053 | 360 | 6 |
351206 | 351206 | 2020-07-20 | Jerome | Idaho | 16053 | 356 | 6 |
348006 | 348006 | 2020-07-19 | Jerome | Idaho | 16053 | 351 | 6 |
344805 | 344805 | 2020-07-18 | Jerome | Idaho | 16053 | 349 | 6 |
341605 | 341605 | 2020-07-17 | Jerome | Idaho | 16053 | 345 | 6 |
338409 | 338409 | 2020-07-16 | Jerome | Idaho | 16053 | 337 | 6 |
335213 | 335213 | 2020-07-15 | Jerome | Idaho | 16053 | 326 | 6 |
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);