notebooks/OC Explorations.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Should study [open-context-jupyter/Open Context Measurements.ipynb at master · ekansa/open-context-jupyter](https://github.com/ekansa/open-context-jupyter/blob/master/notebooks/Open%20Context%20Measurements.ipynb)\n",
    "\n",
    "May make use of [digitalbazaar/pyld: JSON-LD processor written in Python](https://github.com/digitalbazaar/pyld)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# create pybash macro\n",
    "# https://stackoverflow.com/a/67029719/7782\n",
    "from IPython import get_ipython\n",
    "from IPython.core.magic import register_cell_magic\n",
    "\n",
    "ipython = get_ipython()\n",
    "\n",
    "@register_cell_magic\n",
    "def pybash(line, cell):\n",
    "    ipython.run_cell_magic('bash', '', cell.format(**globals()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from itertools import islice\n",
    "import json\n",
    "from urllib.parse import urljoin\n",
    "from urllib.parse import urlencode, quote_plus\n",
    "\n",
    "import requests\n",
    "from requests.packages.urllib3.util.retry import Retry\n",
    "from requests.adapters import HTTPAdapter\n",
    "\n",
    "from pyld import jsonld\n",
    "import pysolr\n",
    "\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from pandas import DataFrame, Series, Index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "%%pybash\n",
    "\n",
    "curl 'https://iscaws.isample.xyz/isamples_central/thing/select?q=*:*&fl=searchText%20authorizedBy%20producedBy_resultTimeRange%20hasContextCategory%20curation_accessContraints%20curation_description_text%20curation_label%20curation_location%20curation_responsibility%20description_text%20id%20informalClassification%20keywords%20label%20hasMaterialCategory%20producedBy_description_text%20producedBy_hasFeatureOfInterest%20producedBy_label%20producedBy_responsibility%20producedBy_resultTime%20producedBy_samplingSite_description_text%20producedBy_samplingSite_label%20producedBy_samplingSite_location_elevationInMeters%20producedBy_samplingSite_location_latitude%20producedBy_samplingSite_location_longitude%20producedBy_samplingSite_placeName%20registrant%20samplingPurpose%20source%20sourceUpdatedTime%20producedBy_samplingSite_location_rpt%20hasSpecimenCategory&fq=producedBy_resultTimeRange%3A%5B1800%20TO%202023%5D&fq=source%3A(%22OPENCONTEXT%22)&fq=-relation_target%3A*&facet.field=authorizedBy&facet.field=hasContextCategory&facet.field=hasMaterialCategory&facet.field=registrant&facet.field=source&facet.field=hasSpecimenCategory&facet.range=producedBy_resultTimeRange&facet.range.gap=%2B1YEARS&facet.range.start=1800-01-01T00:00:00Z&facet.range.end=2023-01-01T00:00:00Z&f.registrant.facet.sort=count&f.source.facet.sort=index&rows=20&facet.limit=-1&facet.sort=index&&start=20&facet=on&wt=json' \\\n",
    "  -H 'Accept: */*' \\\n",
    "  -H 'Accept-Language: en-US,en;q=0.9,fr-CA;q=0.8,fr;q=0.7,es-US;q=0.6,es;q=0.5,zh-HK;q=0.4,zh-CN;q=0.3,zh;q=0.2,hu-HU;q=0.1,hu;q=0.1' \\\n",
    "  -H 'Connection: keep-alive' \\\n",
    "  -H 'Cookie: previousParams=%7B%22searchFields%22%3A%22JOz12u9048N_IknPmUmI7JEl6IaHYCIsEyR2wChk6ehutnijfTFmtlTctcu-CEHFG7PWaKO4uPIkDoVkW7ciL82II6EqR0N8O_ymO5jqcQhWoklN579z0vIHjEARoVDBBi0HgLHzuzWItUw3W3JlVZeCmft7tb-HptIoYj4RrbAhMoF-2b1PjvwUPwgD8w1g2HrvWjxF6qlPagC5R_rOkbnQ2bboYSzHSixYUyQAiVW0%22%2C%22start%22%3A%22oolDoG40%22%2C%22view%22%3A%22FSqn3iCW343HktXE4JR6DZb7Bq0JIf2Yj0ETejwzPEdyfFzFUEQbT9ZXdXzxWGdsrr5R_wm5vXjoSeQIA0Y9cEZWtF-gZYEo28NWFP7915jfTHivyfwT1jQKH9K4-RAyjgDUYCwOlQbu4zOO9dYtlcmZIjvP3CAZ9gWngGtBTVpm-mC0%22%7D' \\\n",
    "  -H 'Referer: https://iscaws.isample.xyz/isamples_central/ui/' \\\n",
    "  -H 'Sec-Fetch-Dest: empty' \\\n",
    "  -H 'Sec-Fetch-Mode: cors' \\\n",
    "  -H 'Sec-Fetch-Site: same-origin' \\\n",
    "  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36' \\\n",
    "  -H 'sec-ch-ua: \"Chromium\";v=\"118\", \"Google Chrome\";v=\"118\", \"Not=A?Brand\";v=\"99\"' \\\n",
    "  -H 'sec-ch-ua-mobile: ?0' \\\n",
    "  -H 'sec-ch-ua-platform: \"macOS\"' \\\n",
    "  -H 'sec-gpc: 1' \\\n",
    "  --compressed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "%%pybash\n",
    "\n",
    "curl 'https://iscaws.isample.xyz/isamples_central/thing/select?q=*:*&fl=searchText%20authorizedBy%20producedBy_resultTimeRange%20hasContextCategory%20curation_accessContraints%20curation_description_text%20curation_label%20curation_location%20curation_responsibility%20description_text%20id%20informalClassification%20keywords%20label%20hasMaterialCategory%20producedBy_description_text%20producedBy_hasFeatureOfInterest%20producedBy_label%20producedBy_responsibility%20producedBy_resultTime%20producedBy_samplingSite_description_text%20producedBy_samplingSite_label%20producedBy_samplingSite_location_elevationInMeters%20producedBy_samplingSite_location_latitude%20producedBy_samplingSite_location_longitude%20producedBy_samplingSite_placeName%20registrant%20samplingPurpose%20source%20sourceUpdatedTime%20producedBy_samplingSite_location_rpt%20hasSpecimenCategory&fq=producedBy_resultTimeRange%3A%5B1800%20TO%202023%5D&fq=source%3A(%22OPENCONTEXT%22)&fq=-relation_target%3A*&facet.field=authorizedBy&facet.field=hasContextCategory&facet.field=hasMaterialCategory&facet.field=registrant&facet.field=source&facet.field=hasSpecimenCategory&facet.range=producedBy_resultTimeRange&facet.range.gap=%2B1YEARS&facet.range.start=1800-01-01T00:00:00Z&facet.range.end=2023-01-01T00:00:00Z&f.registrant.facet.sort=count&f.source.facet.sort=index&rows=20&facet.limit=-1&facet.sort=index&&start=20&facet=on&wt=json' \\\n",
    "  -H 'Accept: */*' \\\n",
    "  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36' \\\n",
    "  --compressed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "853229\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "\n",
    "# Define the URL\n",
    "url = 'https://iscaws.isample.xyz/isamples_central/thing/select'\n",
    "\n",
    "# Define the URL parameters\n",
    "params = {\n",
    "    'q': '*:*',\n",
    "    'fl': 'searchText authorizedBy producedBy_resultTimeRange hasContextCategory curation_accessContraints curation_description_text curation_label curation_location curation_responsibility description_text id informalClassification keywords label hasMaterialCategory producedBy_description_text producedBy_hasFeatureOfInterest producedBy_label producedBy_responsibility producedBy_resultTime producedBy_samplingSite_description_text producedBy_samplingSite_label producedBy_samplingSite_location_elevationInMeters producedBy_samplingSite_location_latitude producedBy_samplingSite_location_longitude producedBy_samplingSite_placeName registrant samplingPurpose source sourceUpdatedTime producedBy_samplingSite_location_rpt hasSpecimenCategory',\n",
    "    'fq': [\n",
    "        'producedBy_resultTimeRange:[1800 TO 2023]',\n",
    "        'source:(\"OPENCONTEXT\")',\n",
    "        '-relation_target:*'\n",
    "    ],\n",
    "    'facet.field': [\n",
    "        'authorizedBy',\n",
    "        'hasContextCategory',\n",
    "        'hasMaterialCategory',\n",
    "        'registrant',\n",
    "        'source',\n",
    "        'hasSpecimenCategory'\n",
    "    ],\n",
    "    'facet.range': 'producedBy_resultTimeRange',\n",
    "    'facet.range.gap': '+1YEARS',\n",
    "    'facet.range.start': '1800-01-01T00:00:00Z',\n",
    "    'facet.range.end': '2023-01-01T00:00:00Z',\n",
    "    'f.registrant.facet.sort': 'count',\n",
    "    'f.source.facet.sort': 'index',\n",
    "    'rows': 20,\n",
    "    'facet.limit': -1,\n",
    "    'facet.sort': 'index',\n",
    "    'start': 20,\n",
    "    'facet': 'on',\n",
    "    'wt': 'json'\n",
    "}\n",
    "\n",
    "# Define the headers\n",
    "headers = {\n",
    "    'Accept': '*/*',\n",
    "    'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36'\n",
    "}\n",
    "\n",
    "# Make the request\n",
    "response = requests.get(url, params=params, headers=headers)\n",
    "\n",
    "# Check the response\n",
    "if response.status_code == 200:\n",
    "    json_data = response.json()\n",
    "    print (json_data['response']['numFound'])\n",
    "else:\n",
    "    print(f\"Failed to get data. HTTP status code: {response.status_code}\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "%%pybash\n",
    "\n",
    "curl 'https://opencontext.org/query/?type=projects' \\\n",
    "  -H 'Accept: application/json' \\\n",
    "  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36' \\\n",
    "  --compressed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "%%pybash\n",
    "\n",
    "\n",
    "curl 'https://opencontext.org/query/?cat=oc-gen-cat-object&type=subjects' \\\n",
    "  -H 'Accept: application/json' \\\n",
    "  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36' \\\n",
    "  --compressed | jq"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "\n",
    "# url = \"https://opencontext.org/query/?cat=oc-gen-cat-object&type=subjects\"\n",
    "url = \"https://opencontext.org/query/?type=projects\"\n",
    "\n",
    "headers = {\n",
    "    \"Accept\": \"application/json\",\n",
    "    'User-Agent': 'oc-api-client'\n",
    "}\n",
    "\n",
    "response = requests.get(url, headers=headers)\n",
    "\n",
    "# If you want to view the JSON response\n",
    "if response.status_code == 200:\n",
    "    json_data = response.json()\n",
    "    print(json_data)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "json_data['oc-api:has-facets']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "json_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def filter_none(d):\n",
    "    return dict([(k,v) for (k,v) in d.items() if v is not None])\n",
    "\n",
    "\n",
    "class OpenContextAPI(object):\n",
    "    def __init__(self, api_url=\"https://opencontext.org/\"):\n",
    "        self.api_url = api_url\n",
    "        self.session = requests.Session()\n",
    "        self.session.headers.update({\n",
    "            \"Accept\": \"application/json\",\n",
    "            \"User-Agent\": \"oc-api-client\"\n",
    "        })\n",
    "        retries = Retry(total=5,\n",
    "                backoff_factor=0.3,\n",
    "                status_forcelist=[ 500, 502, 503, 504 ])\n",
    "        self.session.mount(self.api_url, HTTPAdapter(max_retries=retries))\n",
    "        \n",
    "    def _pager(self, url):\n",
    "        while url:\n",
    "            print(url)\n",
    "            r = self.session.get(url)\n",
    "            if r.status_code == 200:\n",
    "                features = r.json().get('features', [])\n",
    "                yield from features\n",
    "            else:\n",
    "                # to do: figure what to do when non-200 status code\n",
    "                pass\n",
    "            url = r.json().get('next-json', None)\n",
    "        \n",
    "        \n",
    "    def projects_search(self, start=None, stop=None, rows=None):\n",
    "\n",
    "        kw = filter_none({\n",
    "            'start': start,\n",
    "            'stop': stop,\n",
    "            'rows': rows\n",
    "        })\n",
    "        \n",
    "        url = urljoin(self.api_url, \"query/?type=projects\") + \"&\" + urlencode(kw, quote_via=quote_plus)\n",
    "        yield from self._pager(url)\n",
    "        \n",
    "                \n",
    "    def project(self, project_id):\n",
    "        \n",
    "        url = urljoin(self.api_url, \"projects/{}.json\".format(project_id))\n",
    "        r = self.session.get(url)\n",
    "        if r.status_code == 200:\n",
    "            return r.json()\n",
    "        \n",
    "    def subjects_search(self, project_id):\n",
    "        \"\"\"\n",
    "        start with https://opencontext.org/subjects-search.json/?proj=12-presidio-of-san-francisco\n",
    "        \n",
    "        more complex possibilties:\n",
    "        https://opencontext.org/subjects-search.json/?proj=12-presidio-of-san-francisco#10/37.8001/-122.4559/20/any/Google-Satellite.json\n",
    "        \"\"\"\n",
    "        url = urljoin(self.api_url, \"subjects-search.json/\") + \"?proj={}\".format(project_id)\n",
    "        print (url)\n",
    "        yield from self._pager(url)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "oc = OpenContextAPI(\"https://opencontext.org/\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "features = oc.projects_search()\n",
    "\n",
    "projects_df = DataFrame(list(islice(features,None)))\n",
    "projects_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "len(set(projects_df['rdfs:isDefinedBy']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "projects_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "len(list(chain(*project_list)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from itertools import chain\n",
    "\n",
    "project_list = [\n",
    "[\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/3de4cd9c-259e-4c14-9b03-8b10454ba66e\",\n",
    "    \"text\": \"Kenan Tepe\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/416a274c-cf88-4471-3e31-93db825e9e4a\",\n",
    "    \"text\": \"Digital Index of North American Archaeology (DINAA)\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/a5ddbea2-b3c8-43f9-8151-33343cbdc857\",\n",
    "    \"text\": \"Petra Great Temple Excavations\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/df043419-f23b-41da-7e4d-ee52af22f92f\",\n",
    "    \"text\": \"Murlo\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/347286db-b6c6-4fd2-b3bd-b50316b0cb9f\",\n",
    "    \"text\": \"Architecture and Urbanism at Seyitömer Höyük, Turkey\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/e0ea772b-a64f-4758-93aa-8db3b07564a3\",\n",
    "    \"text\": \"DINAA Sites from Aggregate Totals\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/bc71c724-eb1e-47d6-9d45-b586ddafdcfe\",\n",
    "    \"text\": \"The Eastern Korinthia Archaeological Survey\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/e6fb0f7c-6f69-6ca8-683b-8c6d5e98a099\",\n",
    "    \"text\": \"Domuztepe Excavations\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/01860ee9-6fb6-4e71-8958-113fb852c850\",\n",
    "    \"text\": \"Guanaco (Lama guanicoe) osteometric data from an individual from Northwest Argentina\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/339673ec-f692-4a96-8a88-1e7a3c8ae4fa\",\n",
    "    \"text\": \"The Čḯxʷicən Bird Bone Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b0a915f3-43cd-1d81-cc89-043d7e11e7c9\",\n",
    "    \"text\": \"Iraq Heritage Program\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/1b426f7c-99ec-4322-4069-e8dbd927ccf1\",\n",
    "    \"text\": \"Çatalhöyük Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/02b55e8c-e9b1-49e5-8edf-0afeea10e2be\",\n",
    "    \"text\": \"Avkat Archaeological Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/fde9a92e-9748-47a5-a8e3-7f95c486e1a0\",\n",
    "    \"text\": \"The Čḯxʷicən Fishbone Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/2c5addea-41d5-4941-b2bd-672bc1e60448\",\n",
    "    \"text\": \"China Ceramic Petrography Database\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/141e814a-ba2d-4560-879f-80f1afb019e9\",\n",
    "    \"text\": \"ARCE Sphinx Project 1979-1983 Archive\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/81204af8-127c-4686-e9b0-1202c3a47959\",\n",
    "    \"text\": \"Florida Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b4345f6a-f926-4062-144e-3fbc175cc7b6\",\n",
    "    \"text\": \"Bade Museum\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/ca4f4719-f2a5-4119-99fa-b04573c8929a\",\n",
    "    \"text\": \"Kahramanmaraş Survey\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/0404c6dc-a467-421e-47b8-d68f7090fbcc\",\n",
    "    \"text\": \"Osteometric Database of South American Camelids\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/10aa84ad-c5de-4e79-89ce-d83b75ed72b5\",\n",
    "    \"text\": \"Giza Botanical Database\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/59157336-e1df-4d14-9cc9-f046bc429230\",\n",
    "    \"text\": \"Northern Highland Archaeofaunas of Ecuador\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/8894eec0-dc96-4304-1efc-4572fd91717a\",\n",
    "    \"text\": \"Zooarchaeology of Öküzini Cave\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/d297cd29-50ca-4b2c-4a07-498adf3af487\",\n",
    "    \"text\": \"Ilıpınar Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/48113f9f-707b-4d18-b40c-d976ff7884a2\",\n",
    "    \"text\": \"Abu Hureyra Digital Data Archive\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/3f6dcd13-a476-488e-ed10-47d25513fcb2\",\n",
    "    \"text\": \"Pyla-Koutsopetria Archaeological Project I: Pedestrian Survey\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/01d080df-2f6b-4f59-bcf0-87543ac89574\",\n",
    "    \"text\": \"Dhiban Excavation and Development Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/95b1ef01-9ccb-4484-b0f2-540f4dc54672\",\n",
    "    \"text\": \"Early Islamic Mosques Database\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/05f5b702-2967-49b1-feaa-9b2aa0184513\",\n",
    "    \"text\": \"Köşk Höyük Faunal Data\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/140ebe61-35f8-43e7-9d34-1180ef7fc794\",\n",
    "    \"text\": \"Archaeobiological and Artifactual Data from the Dhiban Excavation and Development Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/bc90d462-6639-4087-8527-6bb9e528e07d\",\n",
    "    \"text\": \"Çukuriçi Höyük Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b9472eec-e622-4838-b6d8-5a2958b9d4d3\",\n",
    "    \"text\": \"Pyla-Koutsopetria Archaeological Project II: Geophysics and Excavation\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/bdc6cb19-e739-404b-8b4f-eeeaae3b8aae\",\n",
    "    \"text\": \"Animal remains from Forcello\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/731b0670-ce2a-414a-8ef6-9c050a1c60f5\",\n",
    "    \"text\": \"Zooarchaeology of Karain Cave B\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/ae3beea5-3cc0-4076-91cf-49033eaa1e5d\",\n",
    "    \"text\": \"Las Vegas Archaeofaunas\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/24945aba-38f6-46bb-92e9-2c8886e598fc\",\n",
    "    \"text\": \"The Čḯxʷicən Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/94247f2f-f4f7-4caa-b022-556e440c23d8\",\n",
    "    \"text\": \"Interanalyst Variation Assessment for Faunal Assemblages at Domuztepe\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/02594c48-7497-40d7-11ae-ab942dc513b8\",\n",
    "    \"text\": \"Çatalhöyük Area TP Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/2015946b-da6d-4a0f-b676-03bee1efad21\",\n",
    "    \"text\": \"Madaba Plains Project-`Umayri\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/8e7fee33-8ec7-4707-910b-6ace9d70d032\",\n",
    "    \"text\": \"Andean Geochemistry Visualization Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/cbb6b9f7-500c-4ddd-71aa-4d5e5b96cdbb\",\n",
    "    \"text\": \"Khirbat al-Mudayna al-Aliya\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/99bdb878-6411-44f8-2d7b-a99384a6ca21\",\n",
    "    \"text\": \"Zooarchaeology of Neolithic Ulucak\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/bb308d84-da93-4e0b-8b46-2160c023f592\",\n",
    "    \"text\": \"Zooarchaeological Data from the Historic Hacienda El Progreso San Cristóbal Island, Galápagos, Ecuador\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/cdd40c27-62ed-4966-af3d-e781dd0d4846\",\n",
    "    \"text\": \"Erbaba Höyük and Suberde Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b028c160-092e-4e2d-9738-a40367ad543b\",\n",
    "    \"text\": \"Tel Dor, Area G Report\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/64013c33-4039-46c9-609a-a758ce51ca49\",\n",
    "    \"text\": \"Georgia Archaeological Site File (GASF)\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/00000000-0000-0000-0000-000000000001\",\n",
    "    \"text\": \"Open Context\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/d4e82e22-d96f-4d01-a15a-fc5ec7958435\",\n",
    "    \"text\": \"Database of Archaeological Information on Maya Dogs (Canis lupus familiaris) from Preclassic through Colonial Periods\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/fd0845e0-7dc7-4629-9ec3-681aa22ab73b\",\n",
    "    \"text\": \"Cattle and People: Interdisciplinary approaches to an ancient relationship\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/08c9cef2-f49d-4596-aac4-b51fa3852107\",\n",
    "    \"text\": \"Southern Highland Archaeofaunas of Ecuador\"\n",
    "  }\n",
    "],\n",
    "\n",
    "[\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/1816a043-92e2-471d-a23d-aac58695d0d3\",\n",
    "    \"text\": \"Biometrical Database of European Aurochs and Domestic Cattle\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/c89e6a9e-105a-4368-9e90-26940d7bf37a\",\n",
    "    \"text\": \"Neolithic and Bronze Age cattle data from Switzerland\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/edda846f-7225-495e-ab77-7314c256449a\",\n",
    "    \"text\": \"Ohio Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b7f85eb6-4bf5-43fa-98e7-ff8faf1aa452\",\n",
    "    \"text\": \"Illinois Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/289c201f-837f-4535-b039-5fa1f9b731bd\",\n",
    "    \"text\": \"Charcoal Hearths along the Blue Mountain of Pennsylvania\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/01d79ce4-43fb-4eca-9119-0cd505b1972a\",\n",
    "    \"text\": \"Pınarbaşı Bird Remains\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/87a117ea-71a8-4a43-997c-cae27b744307\",\n",
    "    \"text\": \"Household Zooarchaeology of Colonial Lamanai\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/497adead-0c2a-4c62-feef-9079fb09b1a5\",\n",
    "    \"text\": \"Chogha Mish Fauna\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/a52bd40a-9ac8-4160-a9b0-bd2795079203\",\n",
    "    \"text\": \"Visualizing Votive Practice: Exploring Limestone and Terracotta Sculpture from Athienou-Malloura through 3D Models\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/d6b25ec9-2884-4e3c-00e8-0c5a6472fa63\",\n",
    "    \"text\": \"Tal-e Malyan Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b7047162-6906-4a5e-13c0-b5b86a108510\",\n",
    "    \"text\": \"Zooarchaeology of Medieval Emden\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/74749949-4fd4-4c3e-c830-5aa75703e08e\",\n",
    "    \"text\": \"Barçın Höyük Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/df8e4efd-e06b-4b0b-a056-08b6fd199536\",\n",
    "    \"text\": \"Idalion\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/96e12c83-f055-486f-ab64-dc3f3e021b6c\",\n",
    "    \"text\": \"Fuel and Plant Use in Northern Mesopotamia\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/d42fc0eb-61b0-4937-700e-4efeab008677\",\n",
    "    \"text\": \"Indiana Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/cf6e1364-d6ef-4042-b726-82cfb73f7c9d\",\n",
    "    \"text\": \"Mikt’sqaq Angayuk Finds\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/0ef13284-90ce-4f5e-a864-35ce934cca4e\",\n",
    "    \"text\": \"Tick Island Zooarchaeological Data\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/8d1b6933-f4f9-433f-b539-bef04226d5de\",\n",
    "    \"text\": \"Baptizing Spring Zooarchaeological Data\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/0ee6a09e-62e5-45f0-1cb9-f5cda44f4d9e\",\n",
    "    \"text\": \"South Carolina SHPO\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/0c2d10b9-9691-458b-991b-01602195405c\",\n",
    "    \"text\": \"Cattle husbandry in the Iron Age and Roman Britain\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/d3bed915-947d-4c1a-8c9a-b7723f03d21a\",\n",
    "    \"text\": \"Virtual Valdivia\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/42ead4db-baed-4a58-9b9b-7ec85266d2a9\",\n",
    "    \"text\": \"Faunal Data from Neolithic Menteşe\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/2c7ff3c8-b299-4138-ab04-f4e17e49ad64\",\n",
    "    \"text\": \"The Amulets of the Kerma Culture\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/d1d54309-e39c-444b-968a-49dfd00ccc60\",\n",
    "    \"text\": \"Herding and Feasting at Halaf Domuztepe: Zooarchaeological and Biogeochemical Data\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/9cc85c77-e2c3-4534-bbe9-3fef64de7bc2\",\n",
    "    \"text\": \"The Phoebe A. Hearst Expedition to Naga ed-Deir, Cemeteries N 2000 and N 2500\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b1dac335-4dc6-4a57-622e-75bf28ba598d\",\n",
    "    \"text\": \"Aegean Archaeomalacology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/0cea2f4a-84cb-4083-8c66-5191628abe67\",\n",
    "    \"text\": \"Digital Index of North American Archaeology, Linking Sites and Literature\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/4b5721e9-2bb3-423f-5d04-1b948fa65fab\",\n",
    "    \"text\": \"Missouri Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/ea62c747-f3ae-4972-8f83-f8aecfcfbaea\",\n",
    "    \"text\": \"Faunal Data from Al-Wu’ayra Fortress, Petra Valley, Jordan\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/48c1b136-6dd7-4e09-98d5-21150263d2cd\",\n",
    "    \"text\": \"North Midden Zooarchaeological Data\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/af0d2f67-2eab-4c28-9c61-0f019cbf628e\",\n",
    "    \"text\": \"Virginia Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/4b16f48e-6f5d-41e0-f568-fce64be6d3fa\",\n",
    "    \"text\": \"Asian Stoneware Jars\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/d1c85af4-c870-488a-865b-b3cf784cfc60\",\n",
    "    \"text\": \"Northern Mesopotamian Pig Husbandry (Late Neolithic-EBA)\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/f05ace4f-9b55-48a0-d640-5276b8b899c7\",\n",
    "    \"text\": \"Kentucky Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/a3cbadb6-6cd4-4099-9fe2-a33757eab749\",\n",
    "    \"text\": \"Dove Mountain Groundstone\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/7a06aecd-8b0e-4f94-b0f9-5c9fb649e003\",\n",
    "    \"text\": \"Community and Identity in the Roman Seventh Legion\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/8492aec3-e406-44c6-03ca-2bf280d8f5b0\",\n",
    "    \"text\": \"Iowa Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/83dbc102-a42d-b643-e26e-9a8dc5d37ba5\",\n",
    "    \"text\": \"Hazor: Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/766d9fd5-2175-41e3-b7c9-7eba6777f1f0\",\n",
    "    \"text\": \"Excavations at Polis\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/59e7bfbc-2557-4fe4-fc14-284ed10d903d\",\n",
    "    \"text\": \"West Stow West Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/d75ef68a-0e23-458c-976d-286d83c13013\",\n",
    "    \"text\": \"Paleoindian Database of the Americas (PIDBA)\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/7232a02f-a861-4860-af20-a905b5b3ae0b\",\n",
    "    \"text\": \"3D History for Ukraine: Archaeological Museum of the Taras Shevchenko National University of Kyiv\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/6eebf118-1c43-409e-8a47-307380d5d261\",\n",
    "    \"text\": \"Halaf Figurines Project: A Catalog of Figurines Excavated from Sixth Millennium Northern Mesopotamian Sites in Syria and Turkey\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/cf179695-1e6a-440f-1ddb-4fea7b02a5b5\",\n",
    "    \"text\": \"Hacksilber Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/a9ce74a8-06fb-4a90-8191-2253c4615151\",\n",
    "    \"text\": \"Raised Field Archaeofaunas of the Lower Guayas Basin, Ecuador\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/1ff1d684-0a7d-4db6-a052-507d008cefb3\",\n",
    "    \"text\": \"Jama Valley Archaeofaunas, Manabí Province, Ecuador\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/46cbb4e6-c820-4ef5-a97b-2078ef55d3de\",\n",
    "    \"text\": \"Zooarchaeology of Early Bronze Age Nahal Tillah\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/21a79037-01ea-4cbb-7048-6aa054fb4a0d\",\n",
    "    \"text\": \"The Archaeology of Mesoamerican Animals\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/50e00bdf-b4e2-435d-8e8e-6d54c48942b1\",\n",
    "    \"text\": \"Biometrical Database of Near East and Eastern Mediterranean Fauna\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/ab22d409-8051-4f52-a000-7c081ddce52a\",\n",
    "    \"text\": \"Hybrid Objects and Intercultural Assemblages in Colonial Louisiana\"\n",
    "  }\n",
    "],\n",
    "\n",
    "[\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/1fea0e30-148e-40dd-a251-76dbcb76730b\",\n",
    "    \"text\": \"Parnell Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/0db006e9-7d27-47b9-aea8-7b0019a7e81a\",\n",
    "    \"text\": \"Late Chalcolithic Archaeobotanical Remains at Çadır Höyük, Turkey\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/3585b372-8d2d-436c-9a4c-b5c10fce3ccd\",\n",
    "    \"text\": \"The Gabii Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/ababd13c-a69f-499e-ca7f-5118f3684e4d\",\n",
    "    \"text\": \"Ceramics, Trade, Provenience and Geology: Cyprus in the Late Bronze Age\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/1677643a-15d0-1b2c-3a35-37f04c765387\",\n",
    "    \"text\": \"Pınarbaşı 1994: Animal Bones\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/5a6ddb94-70be-43b4-2d5d-35d983b21515\",\n",
    "    \"text\": \"Giza AERA Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/f905bd53-c843-4349-0a46-48ff32b5f1be\",\n",
    "    \"text\": \"Alabama Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/ce8fcc0f-adff-4ece-a1c6-634326ed8a23\",\n",
    "    \"text\": \"The Greek-American Excavations at Koutsongila, Kenchreai\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/c5b4f73b-5ef8-4099-590e-b0275edba2a7\",\n",
    "    \"text\": \"Presidio of San Francisco\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/81d1157d-28f4-46ff-98dd-94899c1688f8\",\n",
    "    \"text\": \"Differentiating local from nonlocal ceramic production at Late Bronze Age/Iron Age Kinet Höyük using NAA\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/7f82f3f3-04d2-47c3-b0a9-21aa28294d25\",\n",
    "    \"text\": \"Tennessee Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/cbd24bbb-c6fc-44ed-bd67-6f844f120ad5\",\n",
    "    \"text\": \"Differentiating local from nonlocal ceramic production at Iron Age Sardis using NAA\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b6de18c6-bba8-4b53-9d9e-3eea4b794268\",\n",
    "    \"text\": \"Kuthodaw Pagoda Inscriptions\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/766698e3-2e79-4a78-b0bc-245ff435bbbd\",\n",
    "    \"text\": \"Pennsylvania Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/fab0532a-2953-4f13-aa97-8a9d7e992dbe\",\n",
    "    \"text\": \"Historic Fort Snelling\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/eaa5276b-fb65-4587-bfda-f0e4aea8c1c5\",\n",
    "    \"text\": \"Cheung Ek Neutron Activation Analysis\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/334853c8-320e-4bdc-96b3-f696171b5a58\",\n",
    "    \"text\": \"Digital Companion to 'Preliminary Analysis of the Zooarchaeology of the San Cristóbal Site, Nicaragua: The Bounty of Mohammed’s Paradise'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/12bd285a-baf6-d9ae-2506-24358b1fe49d\",\n",
    "    \"text\": \"Lake Carlos Beach Site, 1992 and 1996\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/8f947319-3c69-4847-b7a2-09e00ed90b32\",\n",
    "    \"text\": \"Balance Pan Weights from Nippur\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/56110b30-3c18-49f9-bda9-550fe8e28450\",\n",
    "    \"text\": \"Louisiana Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/55c3110a-843f-445e-9de7-a8e529af038d\",\n",
    "    \"text\": \"The animal bones found in Vatnsvik, lake Þingvallavatn, Iceland\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/8d959c97-759e-2753-29c7-9be023d6c363\",\n",
    "    \"text\": \"Harvard Peabody Mus. Zooarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/5351bac5-0543-4f7c-b484-913f6ba1610d\",\n",
    "    \"text\": \"Čḯxʷicən Charcoal\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/a820af0c-ab4d-4518-ba91-ac3bede21c4d\",\n",
    "    \"text\": \"Digital Companion to \\\"A Preliminary Analysis of the Iron Age III Faunal Remains from Tell Ta'yinat, Turkey (Ancient Kunulua)\\\"\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/5f2d4172-d823-4f7f-d3a8-4bd68ed1369d\",\n",
    "    \"text\": \"North Carolina Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/f9970276-8636-478d-a3f0-08cc7efead4f\",\n",
    "    \"text\": \"Maryland Site Files\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/646b7034-07b7-4971-8d89-ebe37dda4cd2\",\n",
    "    \"text\": \"Biometry of Iron Age II and Hellenistic Period Dog 'Burials' from Tell Gezer and Other Sites\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/27e90af3-6bf7-4da1-a1c3-7b2f744e8cf7\",\n",
    "    \"text\": \"Oracle Bones in East Asia\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/a9dbf427-cff6-41b7-8462-a9ab8d9908f4\",\n",
    "    \"text\": \"Database of non-human primate dietary studies\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/685a86a5-ed68-4f92-8c50-d2dfb8f20995\",\n",
    "    \"text\": \"Early Bronze Age Numayra\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/3faaa477-5572-4b05-8dc1-ca264fe1fc10\",\n",
    "    \"text\": \"San Diego Archaeological Center\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/23696274-1f6d-44ca-9697-36b9d5e3fe5d\",\n",
    "    \"text\": \"Traces in the Lost Landscape\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/2bc1f77d-fe36-41eb-99b9-c0261edb4f18\",\n",
    "    \"text\": \"Images Documenting The Ottoman Tiles of the Fakahani Mosque in Cairo\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/45c12f7c-8744-47bb-902a-523d11ce0c32\",\n",
    "    \"text\": \"LBA-IA Ceramic Compositional Data from Troy\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/8ae150fc-50f1-4e60-9dd3-df594b02ddd4\",\n",
    "    \"text\": \"Digital Companion to 'Late Nineteenth and Early Twentieth-Century Animal Use by San Pedro Maya and British Populations at Holotunich, Belize'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/295b5bf4-0f44-4698-80cd-7a39cb6f133d\",\n",
    "    \"text\": \"Rough Cilicia\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/d69293e8-c8a7-4fc0-b3e3-4c2ff23486e6\",\n",
    "    \"text\": \"Animals of the First Maya States: Zooarchaeological and Stable Isotopic Analyses from Ceibal, Guatemala\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/cf6f297f-ada6-404c-801e-9ec094323303\",\n",
    "    \"text\": \"San Jacinto Archaeofaunas\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b0b44b5d-80f8-4aff-9306-22183c319710\",\n",
    "    \"text\": \"Visualizing Antiquarian Excavations: Digital Reunification of the Mecklenburg Collection\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/2c337d0f-7906-4f8c-aeff-cbb65989d284\",\n",
    "    \"text\": \"Digital Companion to 'Archaeological Animals of the Southern Maya Highlands: Zooarchaeology of Kaminaljuyu'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/4c9d2f6b-98d5-46bf-8871-85b106b96d5d\",\n",
    "    \"text\": \"Digital Companion to 'Pre-Columbian Exploitation of Birds Around Panama Bay'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/26d906f6-4505-44f9-80b7-d52fdf052718\",\n",
    "    \"text\": \"Hagios Sozon Bioarchaeology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/25aa5ca5-2dc9-47a5-96f9-83991afcec12\",\n",
    "    \"text\": \"Cerro de Trincheras Archaeofaunas\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/cc9ea1e3-342d-4d94-a5f1-f05de35f4460\",\n",
    "    \"text\": \"Digital Companion to 'Dog Remains from the Marismas Nacionales'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/892c5794-4f2a-4c5c-8c75-d72193d20c86\",\n",
    "    \"text\": \"Western Argolid Regional Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/02062f0f-7c5d-4754-2b42-4eac8a37f5dc\",\n",
    "    \"text\": \"Patterns of Consumption: Ceramic Residue Analysis at Liangchengzhen, Shandong, China\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/1ab2943c-f4c8-4527-a205-515e89ae19e0\",\n",
    "    \"text\": \"Calibrating the Eastern Oyster\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/e10cd7db-c567-4f97-a8b0-605d31a1f919\",\n",
    "    \"text\": \"Zooarchaeology and Cultural Ecology of Puesteros in Southern Mendoza,   Argentina\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/d9f52a5f-ff53-49a9-9b29-6e199b49797a\",\n",
    "    \"text\": \"Digital Companion to 'Archaeofauna at Isla Cilvituk, Campeche, Mexico: Residential Site Structure and Taphonomy in Postclassic Mesoamerica'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/03828abd-2b37-4b91-a592-4266b3db2383\",\n",
    "    \"text\": \"Essays from the Edge of Academia: Supplements to 'Sushi in Cortez'\"\n",
    "  }\n",
    "],\n",
    "\n",
    "[\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/78affbdc-4ea7-4caf-89e5-c3bcea21e46d\",\n",
    "    \"text\": \"Digital Companion to 'Animal Consumption at the Monumental Center of Mayapán'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/04df4d32-9843-4edc-9361-132474acaa5f\",\n",
    "    \"text\": \"Images Documenting Ethnoarchaeology in the Environs of Tell Halif, Israel\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/abb5de2c-7a65-4f5e-a004-0bcaef87a1b1\",\n",
    "    \"text\": \"Exchanging Everyday Luxuries in Byzantine Arabia:  Late Roman Fine Wares at Dhiban, Jordan\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/270edd24-6e6f-6304-829a-7efbf5b094fb\",\n",
    "    \"text\": \"Corneal Ulceration in South East Asia\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/01e63719-a390-b53d-91a5-e1a4d5af4e75\",\n",
    "    \"text\": \"Hayonim: Micromorphology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/8859aa10-c0c4-42ad-993b-cc9d79800d8e\",\n",
    "    \"text\": \"Images Documenting Looting in the North Cemetery at Abydos, Egypt\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/ae05dc70-d551-48ee-820f-63c62cf62ab1\",\n",
    "    \"text\": \"The Čḯxʷicən Marine Invertebrate Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/2e36ba29-2bb9-4e78-a4c4-6babfc20ff6d\",\n",
    "    \"text\": \"The Čḯxʷicən Mammal Bone Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/681dd901-0db6-4c32-9d33-0583675b189f\",\n",
    "    \"text\": \"The Čḯxʷicən Chronology and Depositional History Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/1dfe27e7-e705-20f3-1374-7ada98af7c99\",\n",
    "    \"text\": \"Geissenklosterle: Micromorphology\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/90e4c62f-5b51-4891-a7af-dd77c1e1a00f\",\n",
    "    \"text\": \"The Mesoamerican Cattle Project: Zooarchaeology of Cows in Early Spanish America\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/9134b53f-eac9-42c3-8190-31d0119ac0ae\",\n",
    "    \"text\": \"Paleoethnobotany at tall Dhiban, ca. 900 BCE - 1500 CE\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/1ae2a5d9-5515-4796-92e3-52400293f8e0\",\n",
    "    \"text\": \"Paleoethnobotany at Early Iron Age Khirbat al-Mudayana al-'Aliya (KMA)\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/e682f907-6e4a-44cc-8a5f-3e2c73001673\",\n",
    "    \"text\": \"Archaeology of the International Space Station\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/781abb20-45c7-4213-8cd3-596a29457346\",\n",
    "    \"text\": \"Digital Companion to 'Inferring the Archaeological Context Through Taphonomy: The Use of the White-Tailed Deer (Odocoileus virginianus) in Chinikihá, Chiapas'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/8d6d255b-bb48-42a8-a095-3c2eab42eb2e\",\n",
    "    \"text\": \"Digital Companion to 'Molluscs as Food in a Prolific Coastal Environment: Evidence for Selective Foraging and Taphonomy from Cueva de los Vampiros (Central Panama)'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/3e59f952-ccaa-47b4-962f-0bc6aaa052d2\",\n",
    "    \"text\": \"Digital Companion to 'The Zooarchaeology of Olmec and epi-Olmec Foodways along Mexico’s Gulf Coast'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/eddedde7-d654-41b3-a14d-73d0fd673a51\",\n",
    "    \"text\": \"Digital Companion to 'The Use of Animals by the Pre-Hispanic Maya of the Northern Lowlands'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/6a409055-ae9b-41d1-a54e-a9192a2d1fcd\",\n",
    "    \"text\": \"Zooarchaeological Evidence for Rats in Europe\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/ab9b84d5-ae8a-4d5b-8e45-9f3d260723b1\",\n",
    "    \"text\": \"Digital Companion to 'Crawling and Walking at the Same Time: Challenges in 'Animal Archaeology' in Northern South America'\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/3a2b3f3f-6b8c-4cb6-d4e7-b286e0bbf041\",\n",
    "    \"text\": \"Khirbet et-Tannur\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/f95c5f7a-0703-45d9-9654-627e01482c04\",\n",
    "    \"text\": \"ZooArchNet\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/82e67b1c-9f1a-42ee-8f1c-62e0a5061626\",\n",
    "    \"text\": \"Venus Pompeiana Project (VPP) Data Archive\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/24e2aa20-59e6-4d66-948b-50ee245a7cfc\",\n",
    "    \"text\": \"TRAP Digital Archive\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/5e692b1d-f366-4a28-84ef-2348e04618c4\",\n",
    "    \"text\": \"Khmer Production and Exchange Project\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/22f3e357-c900-4ad5-9d91-248e68cfeba6\",\n",
    "    \"text\": \"The Middle and Late Byzantine Glazed Fine Wares\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/aebeee67-b9d9-4920-b952-5483d41e83cd\",\n",
    "    \"text\": \"Kites in Context\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/542a1d87-f399-4a82-a2cd-9fda54b1c609\",\n",
    "    \"text\": \"Cappadocian Ceiling Crosses\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b674332d-d19b-4097-a99f-64c614e65b05\",\n",
    "    \"text\": \"Chicha Pottery Ethnoarchaeological Study\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b90a6129-ff98-43ab-ba48-ff5a9384b68b\",\n",
    "    \"text\": \"Archaeobotanical Data from Tell Leilan\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/8efcf06c-e855-45cc-c31b-e2aafcf52075\",\n",
    "    \"text\": \"The University of Queensland Archaeological Reference Collection\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/f4ab6a28-6a06-4760-a7a5-eba51d3dc964\",\n",
    "    \"text\": \"Zooarchaeology of Uğurlu Höyük, Gökçeada, Turkey\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/3d9b9ce0-47ee-40cb-ae94-046a056eb8b1\",\n",
    "    \"text\": \"Egiin Gol Survey\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/77a8ecc1-25ba-4b5e-9783-d667d008538b\",\n",
    "    \"text\": \"Middle and Late Byzantine Glazed Fine Wares\"\n",
    "  },\n",
    "  {\n",
    "    \"href\": \"https://opencontext.org/projects/b9bbfd1c-1d9c-43a5-9208-597610c7f723\",\n",
    "    \"text\": \"Carthage\"\n",
    "  }\n",
    "]\n",
    "\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "projects_df['item category'] = projects_df.apply(lambda x: x['properties'].get('item category'), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "projects_df[projects_df['item category']=='Projects']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "print(\", \".join([f\"'{id_}'\" for id_ in list(projects_df.apply(lambda row: row['properties']['href'].split('/')[-1], axis=1))]))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I don't understand why we get only 77 results and not 108."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# Studying a specific project"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "https://opencontext.org/projects/C5B4F73B-5EF8-4099-590E-B0275EDBA2A7  --> Presidio project\n",
    "\n",
    "aka https://opencontext.org/projects/12-presidio-of-san-francisco"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "projects_df.iloc[0].properties.get('uri')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "\n",
    "k = projects_df.apply(lambda row: row.properties.get('uri'), axis=1)\n",
    "k.to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#presidio project is not in that list\n",
    "\n",
    "projects_df[projects_df.apply(lambda row: row.properties.get('uri'), axis=1) == 'https://opencontext.org/projects/C5B4F73B-5EF8-4099-590E-B0275EDBA2A7']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "oc.project('C5B4F73B-5EF8-4099-590E-B0275EDBA2A7')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "* Data Records\n",
    "* Media"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# this takes a while to get through all 1000+ records \n",
    "# limit this to 50\n",
    "\n",
    "for (i, record) in enumerate(islice(oc.subjects_search('12-presidio-of-san-francisco'),50)):\n",
    "    print (\"\\r\", i, end=\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": false,
   "sideBar": false,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": false,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}