# How to show a row by its key in a hail table?

**URL:** <https://discuss.hail.is/t/how-to-show-a-row-by-its-key-in-a-hail-table/3650>\
**Category:** Hail Query & hailctl\
**Created:** [November 16, 2023, 7:43pm UTC](https://discuss.hail.is/t/how-to-show-a-row-by-its-key-in-a-hail-table/3650 "2023-11-16T19:43:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ManavalanG](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/manavalang/32/1065_2.png) [@ManavalanG](https://discuss.hail.is/u/ManavalanG)\
**Post date:** [November 16, 2023, 7:43pm UTC](https://discuss.hail.is/t/how-to-show-a-row-by-its-key-in-a-hail-table/3650/1 "2023-11-16T19:43:55Z")

</div>

Given a hail table, how do I print a row of interest from its key? For example, how would I print the row with id `7` from the [table in hail tutorial](https://hail.is/docs/0.2/tutorials/03-tables.html#Exploring-Tables)? Also, how would it work if the locus and alleles were the keys?

I’m familiar with showing the row of interest using `filter`, but it feels wrong and I am guessing there is a straight-forward to achieve this 🙂

---

<div class="post-metadata">

**Author:** ![ehigham](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/ehigham/32/943_2.png) [@ehigham](https://discuss.hail.is/u/ehigham)\
**Post date:** [November 21, 2023, 4:41pm UTC](https://discuss.hail.is/t/how-to-show-a-row-by-its-key-in-a-hail-table/3650/2 "2023-11-21T16:41:18Z")

</div>

Hi @ManavalanG,  
Unfortunately there’s no more direct way of doing this than you observed with

```python
table.filter('idx'=7).row.show()

```

Warm regards,  
Edmund