ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
237 rows where county = "Gray" and deaths = 0 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
674750 | 674750 | 2020-10-28 | Gray | Kansas | 20069 | 194 | 0 |
671508 | 671508 | 2020-10-27 | Gray | Kansas | 20069 | 180 | 0 |
668265 | 668265 | 2020-10-26 | Gray | Kansas | 20069 | 180 | 0 |
665021 | 665021 | 2020-10-25 | Gray | Kansas | 20069 | 176 | 0 |
661776 | 661776 | 2020-10-24 | Gray | Kansas | 20069 | 176 | 0 |
658532 | 658532 | 2020-10-23 | Gray | Kansas | 20069 | 176 | 0 |
655287 | 655287 | 2020-10-22 | Gray | Kansas | 20069 | 172 | 0 |
652042 | 652042 | 2020-10-21 | Gray | Kansas | 20069 | 172 | 0 |
648798 | 648798 | 2020-10-20 | Gray | Kansas | 20069 | 169 | 0 |
645553 | 645553 | 2020-10-19 | Gray | Kansas | 20069 | 169 | 0 |
642306 | 642306 | 2020-10-18 | Gray | Kansas | 20069 | 163 | 0 |
639059 | 639059 | 2020-10-17 | Gray | Kansas | 20069 | 163 | 0 |
635813 | 635813 | 2020-10-16 | Gray | Kansas | 20069 | 163 | 0 |
632567 | 632567 | 2020-10-15 | Gray | Kansas | 20069 | 157 | 0 |
629323 | 629323 | 2020-10-14 | Gray | Kansas | 20069 | 157 | 0 |
626080 | 626080 | 2020-10-13 | Gray | Kansas | 20069 | 152 | 0 |
622838 | 622838 | 2020-10-12 | Gray | Kansas | 20069 | 152 | 0 |
619594 | 619594 | 2020-10-11 | Gray | Kansas | 20069 | 143 | 0 |
616352 | 616352 | 2020-10-10 | Gray | Kansas | 20069 | 143 | 0 |
613111 | 613111 | 2020-10-09 | Gray | Kansas | 20069 | 143 | 0 |
609869 | 609869 | 2020-10-08 | Gray | Kansas | 20069 | 137 | 0 |
606626 | 606626 | 2020-10-07 | Gray | Kansas | 20069 | 137 | 0 |
603384 | 603384 | 2020-10-06 | Gray | Kansas | 20069 | 133 | 0 |
600141 | 600141 | 2020-10-05 | Gray | Kansas | 20069 | 133 | 0 |
596899 | 596899 | 2020-10-04 | Gray | Kansas | 20069 | 129 | 0 |
593657 | 593657 | 2020-10-03 | Gray | Kansas | 20069 | 129 | 0 |
590416 | 590416 | 2020-10-02 | Gray | Kansas | 20069 | 129 | 0 |
587175 | 587175 | 2020-10-01 | Gray | Kansas | 20069 | 127 | 0 |
583935 | 583935 | 2020-09-30 | Gray | Kansas | 20069 | 127 | 0 |
580696 | 580696 | 2020-09-29 | Gray | Kansas | 20069 | 125 | 0 |
577455 | 577455 | 2020-09-28 | Gray | Kansas | 20069 | 125 | 0 |
574213 | 574213 | 2020-09-27 | Gray | Kansas | 20069 | 121 | 0 |
570970 | 570970 | 2020-09-26 | Gray | Kansas | 20069 | 121 | 0 |
567728 | 567728 | 2020-09-25 | Gray | Kansas | 20069 | 121 | 0 |
564488 | 564488 | 2020-09-24 | Gray | Kansas | 20069 | 116 | 0 |
561248 | 561248 | 2020-09-23 | Gray | Kansas | 20069 | 116 | 0 |
558012 | 558012 | 2020-09-22 | Gray | Kansas | 20069 | 105 | 0 |
554775 | 554775 | 2020-09-21 | Gray | Kansas | 20069 | 105 | 0 |
551536 | 551536 | 2020-09-20 | Gray | Kansas | 20069 | 105 | 0 |
548297 | 548297 | 2020-09-19 | Gray | Kansas | 20069 | 105 | 0 |
545059 | 545059 | 2020-09-18 | Gray | Kansas | 20069 | 105 | 0 |
541823 | 541823 | 2020-09-17 | Gray | Kansas | 20069 | 104 | 0 |
538586 | 538586 | 2020-09-16 | Gray | Kansas | 20069 | 104 | 0 |
535350 | 535350 | 2020-09-15 | Gray | Kansas | 20069 | 103 | 0 |
532115 | 532115 | 2020-09-14 | Gray | Kansas | 20069 | 103 | 0 |
528878 | 528878 | 2020-09-13 | Gray | Kansas | 20069 | 101 | 0 |
525642 | 525642 | 2020-09-12 | Gray | Kansas | 20069 | 101 | 0 |
522406 | 522406 | 2020-09-11 | Gray | Kansas | 20069 | 101 | 0 |
519169 | 519169 | 2020-09-10 | Gray | Kansas | 20069 | 99 | 0 |
515934 | 515934 | 2020-09-09 | Gray | Kansas | 20069 | 99 | 0 |
512701 | 512701 | 2020-09-08 | Gray | Kansas | 20069 | 99 | 0 |
509468 | 509468 | 2020-09-07 | Gray | Kansas | 20069 | 99 | 0 |
506236 | 506236 | 2020-09-06 | Gray | Kansas | 20069 | 98 | 0 |
503002 | 503002 | 2020-09-05 | Gray | Kansas | 20069 | 98 | 0 |
499768 | 499768 | 2020-09-04 | Gray | Kansas | 20069 | 98 | 0 |
496535 | 496535 | 2020-09-03 | Gray | Kansas | 20069 | 95 | 0 |
493301 | 493301 | 2020-09-02 | Gray | Kansas | 20069 | 95 | 0 |
490068 | 490068 | 2020-09-01 | Gray | Kansas | 20069 | 90 | 0 |
486835 | 486835 | 2020-08-31 | Gray | Kansas | 20069 | 90 | 0 |
483600 | 483600 | 2020-08-30 | Gray | Kansas | 20069 | 87 | 0 |
480366 | 480366 | 2020-08-29 | Gray | Kansas | 20069 | 87 | 0 |
477133 | 477133 | 2020-08-28 | Gray | Kansas | 20069 | 87 | 0 |
473900 | 473900 | 2020-08-27 | Gray | Kansas | 20069 | 85 | 0 |
470668 | 470668 | 2020-08-26 | Gray | Kansas | 20069 | 85 | 0 |
467439 | 467439 | 2020-08-25 | Gray | Kansas | 20069 | 83 | 0 |
464210 | 464210 | 2020-08-24 | Gray | Kansas | 20069 | 83 | 0 |
460981 | 460981 | 2020-08-23 | Gray | Kansas | 20069 | 82 | 0 |
457754 | 457754 | 2020-08-22 | Gray | Kansas | 20069 | 82 | 0 |
454526 | 454526 | 2020-08-21 | Gray | Kansas | 20069 | 82 | 0 |
451298 | 451298 | 2020-08-20 | Gray | Kansas | 20069 | 82 | 0 |
448070 | 448070 | 2020-08-19 | Gray | Kansas | 20069 | 82 | 0 |
444843 | 444843 | 2020-08-18 | Gray | Kansas | 20069 | 79 | 0 |
441617 | 441617 | 2020-08-17 | Gray | Kansas | 20069 | 79 | 0 |
438390 | 438390 | 2020-08-16 | Gray | Kansas | 20069 | 77 | 0 |
435165 | 435165 | 2020-08-15 | Gray | Kansas | 20069 | 77 | 0 |
431940 | 431940 | 2020-08-14 | Gray | Kansas | 20069 | 77 | 0 |
428712 | 428712 | 2020-08-13 | Gray | Kansas | 20069 | 75 | 0 |
425488 | 425488 | 2020-08-12 | Gray | Kansas | 20069 | 75 | 0 |
422267 | 422267 | 2020-08-11 | Gray | Kansas | 20069 | 73 | 0 |
419044 | 419044 | 2020-08-10 | Gray | Kansas | 20069 | 73 | 0 |
415823 | 415823 | 2020-08-09 | Gray | Kansas | 20069 | 73 | 0 |
412603 | 412603 | 2020-08-08 | Gray | Kansas | 20069 | 73 | 0 |
409383 | 409383 | 2020-08-07 | Gray | Kansas | 20069 | 73 | 0 |
406164 | 406164 | 2020-08-06 | Gray | Kansas | 20069 | 70 | 0 |
402946 | 402946 | 2020-08-05 | Gray | Kansas | 20069 | 70 | 0 |
399729 | 399729 | 2020-08-04 | Gray | Kansas | 20069 | 69 | 0 |
396514 | 396514 | 2020-08-03 | Gray | Kansas | 20069 | 69 | 0 |
393298 | 393298 | 2020-08-02 | Gray | Kansas | 20069 | 64 | 0 |
390081 | 390081 | 2020-08-01 | Gray | Kansas | 20069 | 64 | 0 |
386864 | 386864 | 2020-07-31 | Gray | Kansas | 20069 | 64 | 0 |
383646 | 383646 | 2020-07-30 | Gray | Kansas | 20069 | 57 | 0 |
380429 | 380429 | 2020-07-29 | Gray | Kansas | 20069 | 57 | 0 |
377212 | 377212 | 2020-07-28 | Gray | Kansas | 20069 | 54 | 0 |
373997 | 373997 | 2020-07-27 | Gray | Kansas | 20069 | 54 | 0 |
370785 | 370785 | 2020-07-26 | Gray | Kansas | 20069 | 47 | 0 |
367575 | 367575 | 2020-07-25 | Gray | Kansas | 20069 | 47 | 0 |
364368 | 364368 | 2020-07-24 | Gray | Kansas | 20069 | 47 | 0 |
361161 | 361161 | 2020-07-23 | Gray | Kansas | 20069 | 44 | 0 |
357956 | 357956 | 2020-07-22 | Gray | Kansas | 20069 | 44 | 0 |
354754 | 354754 | 2020-07-21 | Gray | Kansas | 20069 | 42 | 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);