# Trying to get a complete list of all the ISH ID experiments for the mouse brain

**URL:** <https://community.brain-map.org/t/trying-to-get-a-complete-list-of-all-the-ish-id-experiments-for-the-mouse-brain/2089>\
**Category:** Technical\
**Tags:** api\
**Created:** [January 18, 2023, 9:00am UTC](https://community.brain-map.org/t/trying-to-get-a-complete-list-of-all-the-ish-id-experiments-for-the-mouse-brain/2089 "2023-01-18T09:00:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![spiluso](https://avatars.discourse-cdn.com/v4/letter/s/e480ec/32.png) [@spiluso](https://community.brain-map.org/u/spiluso)\
**Post date:** [January 18, 2023, 9:00am UTC](https://community.brain-map.org/t/trying-to-get-a-complete-list-of-all-the-ish-id-experiments-for-the-mouse-brain/2089/1 "2023-01-18T09:00:52Z")

</div>

Hi,

I was just wondering how to easily get a complete list of all the ISH ID experiments for the mouse brain.  
I have tried different ways through API queries but it is difficult to get the complete list because ID figures go so high. I did not find this information in the documentation as well.

Could you please help me to get such a list?

Many thanks in advance,  
Best,  
Sebastien

---

<div class="post-metadata">

**Author:** ![ndefrancesco](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.brain-map.org/ndefrancesco/32/395_2.png) [@ndefrancesco](https://community.brain-map.org/u/ndefrancesco)\
**Post date:** [February 3, 2023, 2:38am UTC](https://community.brain-map.org/t/trying-to-get-a-complete-list-of-all-the-ish-id-experiments-for-the-mouse-brain/2089/2 "2023-02-03T02:38:56Z")

</div>

Hi @spiluso!

You can get the full list of ISH mouse experiments by slightly modifying one of the examples that is listed in this page:

- [Example Queries for Experiment Metadata - Allen Brain Atlas API](http://help.brain-map.org/display/api/Example+Queries+for+Experiment+Metadata#ExampleQueriesforExperimentMetadata-AllMouseBrainISHexperiments)

Specifically, they provide this particular query to get all the ISH mouse experiments in csv format:

```auto
http://api.brain-map.org/api/v2/data/query.csv?criteria=
model::SectionDataSet,
rma::criteria,[failed$eqfalse],products[abbreviation$eq'Mouse'],treatments[name$eq'ISH'],genes,plane_of_section,
rma::options,
[tabular$eq'plane_of_sections.name+as+plane','genes.acronym+as+gene','data_sets.id+as+section_data_set_id'],
[order$eq'plane_of_sections.name,genes.acronym,data_sets.id']
&num_rows=50&start_row=0

```

This will get you the first 50 experiments, which is the default if you omit the `num_rows=50` option. You can [change](http://help.brain-map.org/pages/viewpage.action?pageId=5308449#RESTfulModelAccess(RMA)-SortingAndPaging) that to `num_rows=all` to get the full list of experiments (26079, in this case).

I hope this helps.

Cheers,  
Nico

---

<div class="post-metadata">

**Author:** ![spiluso](https://avatars.discourse-cdn.com/v4/letter/s/e480ec/32.png) [@spiluso](https://community.brain-map.org/u/spiluso)\
**Post date:** [February 6, 2023, 10:07am UTC](https://community.brain-map.org/t/trying-to-get-a-complete-list-of-all-the-ish-id-experiments-for-the-mouse-brain/2089/3 "2023-02-06T10:07:25Z")

</div>

Hi @ndefrancesco,

Excellent, that was exactly what I was looking for!  
I am very grateful for your help, which will make me save a lot of time and ressources!

Many thanks,  
Best,  
Sebastien

---

<div class="post-metadata">

**Author:** ![spiluso](https://avatars.discourse-cdn.com/v4/letter/s/e480ec/32.png) [@spiluso](https://community.brain-map.org/u/spiluso)\
**Post date:** [March 16, 2023, 6:47pm UTC](https://community.brain-map.org/t/trying-to-get-a-complete-list-of-all-the-ish-id-experiments-for-the-mouse-brain/2089/4 "2023-03-16T18:47:05Z")

</div>

Hi again,

Just a quick note about the list of experiments you provide through this command. It seems that one ID appears twice in a row in this list: ID **78153149** at positions _24785_ and _24786_. This would give a total number of 26078 experiments.

Hope it could be useful.  
Best,  
Sebastien