select c.coll_id, c.title, count(t.title_id) as cnttitle
from collections c, titles t
where c.coll_id = t.coll_id
group by c.coll_id, c.title
order by title
Resources in ArchSearch
Below is a list of all the collections available within the ADS Catalogue: ArchSearch
The collections fall into roughly two different categories:
- Collections with records in ArchSearch: i.e. English Heritage Excavation Index or various Historic Enviroment Records
These collections can be searched alongside all other ADS collections or they can be searched individually. Many of these collections then have links from each record to more detailed information online (look out for the green links). Follow the [description] link for more information about the collection.
- Collections with downloadable or searchable data available online: i.e. Society of Anquaries Drawings catalogue or Royal Opera House Digital Archive
These collections have individual sets of webpages which contain detailed information about the projects and access to data. There is a link the description of the project as well as a link to the resource itself. All these resources are held by the ADS. These collections can also be found by searching ArchSearch.
#cnttitle# records in ArchSearch
select title_id from titles
where coll_id = #coll_id#
select unique type.type, source.title, source.url_text
from type, source
where source.title_id = #titles.title_id#
and source.title_id = type.title_id
and source.title like '%ads.ahds.ac.uk%'
#type# - #url_text#