cometadata/datacite-titles-descriptions-related-identifiers huggingface dataset:
DOI: 10.5281/zenodo.16293143
title: REGENIE results of brain IDP GWAS (Part 19)

description: ○ more i2_marginal_20241220_all_eas/i2_marginal_20241220_all_eas_md5sums.txt88bb9b13589aab9fb3cedb2bc21880de  ./i2_marginal_20241220_all_eas_frac_l_vol.regenie.gz3496bb9565963cc3bf7e99d717e8d580  ./i2_marginal_20241220_all_eas_frac_r_vol.regenie.gz2766f0fc5b97867910fe31b355179bbe  ./i2_marginal_20241220_all_eas_lc_qsm_50th.regenie.gz58cbc1047a6c4495260e5b246f5ddffa  ./i2_marginal_20241220_all_eas_lc_swi_50th.regenie.gzb671aa601e10dd55f3c19d447a4883b3  ./i2_marginal_20241220_all_eas_lc_vol_native.regenie.gzea9dd30ab36eb23e539fb1c63fe601ec  ./i2_marginal_20241220_all_eas_lc_vol_nln.regenie.gz25334cb78b6cfe5972aea1ab982c6976  ./i2_marginal_20241220_all_eas_n1_l_qsm_50th.regenie.gz06b4827dc066be94857967a17dcdbfab  ./i2_marginal_20241220_all_eas_n1_l_swi_50th.regenie.gz2c56e1bb39b4ad990a72b77e56ca8bed  ./i2_marginal_20241220_all_eas_n1_l_vol_native.regenie.gz83ee4cd67f435a9a8606d972d2c896e5  ./i2_marginal_20241220_all_eas_n1_l_vol_nln.regenie.gz1c0ee006769596f7bffd3a18458c5722  ./i2_marginal_20241220_all_eas_n1_r_qsm_50th.regenie.gz0e6cd32d93ca1a37042aa083da19e6ec  ./i2_marginal_20241220_all_eas_n1_r_swi_50th.regenie.gz6a132b9354f01a888b59d4337d73d299  ./i2_marginal_20241220_all_eas_n1_r_vol_native.regenie.gz41d0735b0f6eb15ef65d18ed80494452  ./i2_marginal_20241220_all_eas_n1_r_vol_nln.regenie.gzc8a11ef7786d21d6328d0b07737e6704  ./i2_marginal_20241220_all_eas_n1msn_l_qsm.regenie.gz1d276cdf0a709c778efed7056611ddc4  ./i2_marginal_20241220_all_eas_n1msn_l_swi.regenie.gzeec9ee5b8d1002405ce218d2164fcfd9  ./i2_marginal_20241220_all_eas_n1msn_r_qsm.regenie.gzbfae88d292484385713bc8b59fac4bfd  ./i2_marginal_20241220_all_eas_n1msn_r_swi.regenie.gz7c596596137fa0f72fe70d28d1d1226e  ./i2_marginal_20241220_all_eas_sn_l_qsm_50th.regenie.gz7b57c03ca418c7a1e7736c5d4f0155ad  ./i2_marginal_20241220_all_eas_sn_l_swi_50th.regenie.gzf44e664833d28f4f373a1f93d408adbb  ./i2_marginal_20241220_all_eas_sn_l_vol_native.regenie.gze21bd690339ec5af52ed45766be8dee1  ./i2_marginal_20241220_all_eas_sn_l_vol_nln.regenie.gz68d014f16cc87e1582d77d3652ced17b  ./i2_marginal_20241220_all_eas_sn_r_qsm_50th.regenie.gz98b82eb3d947511e498d8a0a96a8dd0a  ./i2_marginal_20241220_all_eas_sn_r_swi_50th.regenie.gz1dc25dbba2ead2a494451951f658a846  ./i2_marginal_20241220_all_eas_sn_r_vol_native.regenie.gz81e3d1bf9fd5dee0a5bc68d67e39b1da  ./i2_marginal_20241220_all_eas_sn_r_vol_nln.regenie.gz

○ md5sum i2_marginal_20241220_all_eas_step2.zip290431be6f0f4ff2058a00e46b49e5c8  i2_marginal_20241220_all_eas_step2.zip

❯ md5sum single_20241220_eur_female_step2.zip348333ae7001dd2c8a74ec9215ece1fd  single_20241220_eur_female_step2.zip
DOI: 10.5281/zenodo.16293144
title: REGENIE results of brain IDP GWAS (Part 19)

description: ○ more i2_marginal_20241220_all_eas/i2_marginal_20241220_all_eas_md5sums.txt88bb9b13589aab9fb3cedb2bc21880de  ./i2_marginal_20241220_all_eas_frac_l_vol.regenie.gz3496bb9565963cc3bf7e99d717e8d580  ./i2_marginal_20241220_all_eas_frac_r_vol.regenie.gz2766f0fc5b97867910fe31b355179bbe  ./i2_marginal_20241220_all_eas_lc_qsm_50th.regenie.gz58cbc1047a6c4495260e5b246f5ddffa  ./i2_marginal_20241220_all_eas_lc_swi_50th.regenie.gzb671aa601e10dd55f3c19d447a4883b3  ./i2_marginal_20241220_all_eas_lc_vol_native.regenie.gzea9dd30ab36eb23e539fb1c63fe601ec  ./i2_marginal_20241220_all_eas_lc_vol_nln.regenie.gz25334cb78b6cfe5972aea1ab982c6976  ./i2_marginal_20241220_all_eas_n1_l_qsm_50th.regenie.gz06b4827dc066be94857967a17dcdbfab  ./i2_marginal_20241220_all_eas_n1_l_swi_50th.regenie.gz2c56e1bb39b4ad990a72b77e56ca8bed  ./i2_marginal_20241220_all_eas_n1_l_vol_native.regenie.gz83ee4cd67f435a9a8606d972d2c896e5  ./i2_marginal_20241220_all_eas_n1_l_vol_nln.regenie.gz1c0ee006769596f7bffd3a18458c5722  ./i2_marginal_20241220_all_eas_n1_r_qsm_50th.regenie.gz0e6cd32d93ca1a37042aa083da19e6ec  ./i2_marginal_20241220_all_eas_n1_r_swi_50th.regenie.gz6a132b9354f01a888b59d4337d73d299  ./i2_marginal_20241220_all_eas_n1_r_vol_native.regenie.gz41d0735b0f6eb15ef65d18ed80494452  ./i2_marginal_20241220_all_eas_n1_r_vol_nln.regenie.gzc8a11ef7786d21d6328d0b07737e6704  ./i2_marginal_20241220_all_eas_n1msn_l_qsm.regenie.gz1d276cdf0a709c778efed7056611ddc4  ./i2_marginal_20241220_all_eas_n1msn_l_swi.regenie.gzeec9ee5b8d1002405ce218d2164fcfd9  ./i2_marginal_20241220_all_eas_n1msn_r_qsm.regenie.gzbfae88d292484385713bc8b59fac4bfd  ./i2_marginal_20241220_all_eas_n1msn_r_swi.regenie.gz7c596596137fa0f72fe70d28d1d1226e  ./i2_marginal_20241220_all_eas_sn_l_qsm_50th.regenie.gz7b57c03ca418c7a1e7736c5d4f0155ad  ./i2_marginal_20241220_all_eas_sn_l_swi_50th.regenie.gzf44e664833d28f4f373a1f93d408adbb  ./i2_marginal_20241220_all_eas_sn_l_vol_native.regenie.gze21bd690339ec5af52ed45766be8dee1  ./i2_marginal_20241220_all_eas_sn_l_vol_nln.regenie.gz68d014f16cc87e1582d77d3652ced17b  ./i2_marginal_20241220_all_eas_sn_r_qsm_50th.regenie.gz98b82eb3d947511e498d8a0a96a8dd0a  ./i2_marginal_20241220_all_eas_sn_r_swi_50th.regenie.gz1dc25dbba2ead2a494451951f658a846  ./i2_marginal_20241220_all_eas_sn_r_vol_native.regenie.gz81e3d1bf9fd5dee0a5bc68d67e39b1da  ./i2_marginal_20241220_all_eas_sn_r_vol_nln.regenie.gz

○ md5sum i2_marginal_20241220_all_eas_step2.zip290431be6f0f4ff2058a00e46b49e5c8  i2_marginal_20241220_all_eas_step2.zip

❯ md5sum single_20241220_eur_female_step2.zip348333ae7001dd2c8a74ec9215ece1fd  single_20241220_eur_female_step2.zip
DOI: 10.15468/dl.tjrpne
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Piliocolobus waldroni",
 "HasCoordinate is TRUE"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038853-251120083545085/datasets/export for details.
DOI: 10.20383/103.01515
title: NP TCR Surface Interactions

description: Time-series results of simulated nanoparticle-T-cell surface interactions. The number of bound T cell receptors (TCRs) are recorded over time for various arrangements of TCR nanoclusters and NP design parameters. Simulations were performed using an adaptive time step Gillespie algorithm (Tau leaping) in Matlab and results were saved as .mat files.
DOI: 10.15468/4828ae
title: Records of the Brisbane Botanic Gardens Conservation Seedbank

description: Records of the specimens held in the Brisbane Botanic Gardens Conservation Seedbank.

The Brisbane Botanic Gardens Conservation Seed Bank has, with the financial assistance of the Millennium Seed Bank, and as part of the Seeds for Life consortium, made conservation collections of seeds from Queensland native taxa since 2005.

Collections have been made from predominantly dry land species.
DOI: 10.15468/hsfdaj
title: Records of the Brisbane Botanic Gardens Conservation Seedbank

description: Records of the specimens held in the Brisbane Botanic Gardens Conservation Seedbank.

The Brisbane Botanic Gardens Conservation Seed Bank has, with the financial assistance of the Millennium Seed Bank, and as part of the Seeds for Life consortium, made conservation collections of seeds from Queensland native taxa since 2005.

Collections have been made from predominantly dry land species.
DOI: 10.15468/aumrki
title: Records of the Victorian Conservation Seedbank

description: Records of the Victorian Conservation Seedbank
DOI: 10.15468/haxg6f
title: Records of the Victorian Conservation Seedbank

description: Records of the Victorian Conservation Seedbank
DOI: 10.15468/77eqit
title: Records of the Tasmanian Seed Conservation Centre

description: The Tasmanian Seed Conservation Centre is a seed bank facility based at the Royal Tasmanian Botanical Gardens. It was opened in 2005 as part of international Millennium Seed Bank Project. The seed bank is focused on the native flora of Tasmania, with a particular emphasis on Tasmania's Rare and Threatened plants. A small number of introduced weeds and garden exotics are also held. The seed bank currently has one full time member of staff and a number of volunteers who assist in the processing and curation of the seed collections. Collecting priorities for the seed bank are informed and assisted by staff of the Biodiversity and Conservation Branch of Department of Primary Industries, Parks, Water and Environment. Collection verification is handled by the staff of the Tasmanian Herbarium.
DOI: 10.15468/vw5qza
title: Records of the Tasmanian Seed Conservation Centre

description: The Tasmanian Seed Conservation Centre is a seed bank facility based at the Royal Tasmanian Botanical Gardens. It was opened in 2005 as part of international Millennium Seed Bank Project. The seed bank is focused on the native flora of Tasmania, with a particular emphasis on Tasmania's Rare and Threatened plants. A small number of introduced weeds and garden exotics are also held. The seed bank currently has one full time member of staff and a number of volunteers who assist in the processing and curation of the seed collections. Collecting priorities for the seed bank are informed and assisted by staff of the Biodiversity and Conservation Branch of Department of Primary Industries, Parks, Water and Environment. Collection verification is handled by the staff of the Tasmanian Herbarium.
DOI: 10.15468/kinrrl
title: Records of the Australian National Botanic Gardens Seedbank
DOI: 10.15468/uuqtas
title: Records of the Australian National Botanic Gardens Seedbank
DOI: 10.15468/qfmilu
title: Records of the WA Seed Technology Centre

description: The Western Australian Seed Technology Centre in Kings Park is managed by the Botanic Gardens and Parks Authority in Perth. Kings Park has had a strong botanical collection program since 1963 with a focus on the Western Australian flora. Field collecting trips are undertaken throughout Western Australia to collect material for conservation, display, education, research and restoration programs.
In addition to supporting the Botanic Garden with material for conservation, display and education, the Seed Centre also supports the Kings Park Science Directorate which undertakes integrated and innovative research in native plant biology, underpinning the conservation and ecological restoration of Western Australia's unique biodiversity, and biodiversity generally. 
The Seed Science team undertakes research into fundamental and applied aspects of seed physiology and ecology. The research aims to advance the underlying principles of seed biology and translate these into technologies for plant propagation, conservation, and landscape restoration, and to better understand the role of seeds in shaping the establishment, reproduction, and persistence of plant species and communities. 
The Authority has been an inaugural partner with the international Millennium Seed Bank Project and continues to liaise with staff at the Royal Botanic Gardens Kew.
DOI: 10.15468/ctgc28
title: Records of the WA Seed Technology Centre

description: The Western Australian Seed Technology Centre in Kings Park is managed by the Botanic Gardens and Parks Authority in Perth. Kings Park has had a strong botanical collection program since 1963 with a focus on the Western Australian flora. Field collecting trips are undertaken throughout Western Australia to collect material for conservation, display, education, research and restoration programs.
In addition to supporting the Botanic Garden with material for conservation, display and education, the Seed Centre also supports the Kings Park Science Directorate which undertakes integrated and innovative research in native plant biology, underpinning the conservation and ecological restoration of Western Australia's unique biodiversity, and biodiversity generally. 
The Seed Science team undertakes research into fundamental and applied aspects of seed physiology and ecology. The research aims to advance the underlying principles of seed biology and translate these into technologies for plant propagation, conservation, and landscape restoration, and to better understand the role of seeds in shaping the establishment, reproduction, and persistence of plant species and communities. 
The Authority has been an inaugural partner with the international Millennium Seed Bank Project and continues to liaise with staff at the Royal Botanic Gardens Kew.
DOI: 10.15468/dl.a4387p
title: Occurrence Download

description: A dataset containing 6 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Vitreotubus digeronimoi",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 6 records from 5 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038855-251120083545085/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.cbh422
title: Occurrence Download

description: A dataset containing 30743 species occurrences available in GBIF matching the query:
{
 "and" : [
 "SpeciesKey is Vespa velutina",
 "Year is one of (2024, 2025)",
 "HasCoordinate is true",
 "Geometry POLYGON((3.5 43.5, 12.5 43.5, 12.5 50.5, 3.5 50.5, 3.5 43.5))"
 ]
}

 The dataset includes 30743 records from 10 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038854-251120083545085/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.5281/zenodo.17857527
title: Ancillary files to generate a localised multi-envelope s-coordinate system in the Southern Ocean area of the UK GOSI10 eddy-permitting global ocean and sea-ice configuration

description: Ancillary files to generate a localised multi-envelope s-coordinate system in the Southern Ocean area of the UK GOSI10 eddy-permitting global ocean and sea-ice configuration as documented @ https://github.com/JMMP-Group/GOSI-SO/wiki/2.-HPGE-tests-for-envelopes.
DOI: 10.5281/zenodo.17857528
title: Ancillary files to generate a localised multi-envelope s-coordinate system in the Southern Ocean area of the UK GOSI10 eddy-permitting global ocean and sea-ice configuration

description: Ancillary files to generate a localised multi-envelope s-coordinate system in the Southern Ocean area of the UK GOSI10 eddy-permitting global ocean and sea-ice configuration as documented @ https://github.com/JMMP-Group/GOSI-SO/wiki/2.-HPGE-tests-for-envelopes.
DOI: 10.15468/dl.cwcjx2
title: Occurrence Download

description: A dataset listing the 47 species recorded in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((23.74081 35.30465,24.01878 35.30465,24.01878 35.41590,23.74081 35.41590,23.74081 35.30465))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Basidiomycota"
 ]
}

 The dataset's 47 records were derived from 4 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038834-251120083545085/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.17026/ar/cdpjiq
title: PAN-00142163 - plate (Central-/East- Gaulish terra sigillata)

description: &lt;p&gt;This find is registered at Portable Antiquities of the Netherlands with number PAN-00142163&lt;/p&gt;
description: Modified: 2025-10-13T15:58:34+02:00
DOI: 10.5281/zenodo.17859917
title: Data from: Response of soil organic carbon fractions to cover cropping: A meta-analysis of agroecosystems

description: Data associated with a meta-analysis of soil carbon fraction (mineral-associated and particulate) responses to cover cropping, published in the Agriculture, Ecosystems, and Environment (2023). The authors were supported with funding from the United States Department of Agriculture AFRI Competitive Grant (Award No. 2020–68013-30862).
DOI: 10.5281/zenodo.17859918
title: Data from: Response of soil organic carbon fractions to cover cropping: A meta-analysis of agroecosystems

description: Data associated with a meta-analysis of soil carbon fraction (mineral-associated and particulate) responses to cover cropping, published in the Agriculture, Ecosystems, and Environment (2023). The authors were supported with funding from the United States Department of Agriculture AFRI Competitive Grant (Award No. 2020–68013-30862).
DOI: 10.15468/dl.nu4rzt
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Pogonomys fergussoniensis",
 "HasCoordinate is TRUE"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038857-251120083545085/datasets/export for details.
DOI: 10.25345/c50r9mh72
title: MassIVE MSV000100151 - Development of MAN-1: A potent orally bioavailable TRIM21-mediated molecular glue degrader for pancreatic cancer
title: Targeted protein degradation transformed drug discovery by hijacking E3 ubiquitin ligases to induce proteasomal degradation of disease-driving proteins. Molecular glue degraders achieve target degradation by promoting the interactions between the target protein and a E3 ligase. The E3 ligase TRIM21 has emerged as a promising platform for molecular glue discovery, with a class of degraders reported to promote interactions between TRIM21 and the nuclear pore complex, resulting in selective degradation of nuclear pore complex (NPC) proteins such as NUP98 and destruction of nuclear pore. Given the strong reliance of pancreatic ductal adenocarcinoma (PDAC) and other aggressive tumors on NPC function, TRIM21-mediated NPC degradation offers a novel therapeutic avenue. Here, we report the structure-guided development of MAN-1, a best-in-class TRIM21-dependent molecular glue degrader of NPC that exhibits sub-nanomolar potency, strict TRIM21 dependence, favorable ADME properties, no hERG liability, and good oral bioavailability. By determining NUP98-MAN-1-TRIM21 complex structure, we confirmed that MAN-1 promotes the interactions between TRIM21 and NUP98, and we further demonstrated that MAN-1 induces selective degradation of NUPs. These features position MAN-1 as a promising preclinical candidate for PDAC therapy. This submission contains the global proteome profiling to identify downregulated proteins upon MAN-1 treatment.
DOI: 10.15468/dl.4ctbk2
title: Occurrence Download

description: A dataset containing 41 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Claparedepelogenia inclusa",
 "HasCoordinate is true",
 "HasGeospatialIssue is false"
 ]
}

 The dataset includes 41 records from 12 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038859-251120083545085/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.xy22b9
title: Occurrence Download

description: A dataset containing 164 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.countrycode = 'US'
 AND occurrence.datasetkey = '50c9509d-22c7-4a22-a47d-8c48425ef4a7'
 AND (GBIF_WITHIN('POLYGON((-122.81644 47.97764,-122.81639 47.97764,-122.81639 47.9849,-122.81644 47.9849,-122.81644 47.97764))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE OR occurrence.decimallatitude &gt;= 47.96687 AND occurrence.decimallatitude &lt;= 47.98485 AND (occurrence.decimallongitude &gt;= -122.82108 AND occurrence.decimallongitude &lt;= -122.80877) AND GBIF_WITHIN('POLYGON ((-122.81622 47.98485, -122.8162 47.97757, -122.82108 47.97679, -122.82108 47.97408, -122.81913 47.97407, -122.81903 47.96715, -122.80877 47.96687, -122.80909 47.9718, -122.81117 47.97206, -122.81093 47.98477, -122.81622 47.98485))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
 AND occurrence.hasgeospatialissues = FALSE
 AND occurrence.occurrencestatus = 'PRESENT'
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL)
GROUP BY
 occurrence.kingdom,
 occurrence.kingdomkey,
 occurrence.phylum,
 occurrence.phylumkey,
 occurrence.class,
 occurrence.classkey,
 occurrence."order",
 occurrence.orderkey,
 occurrence.family,
 occurrence.familykey,
 occurrence.genus,
 occurrence.genuskey,
 occurrence.species,
 occurrence.specieskey,
 occurrence."year"

 The dataset's 164 records were derived from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038846-251120083545085/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.cuvfvh
title: Occurrence Download

description: A dataset containing 25013287 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.hasgeospatialissues = FALSE
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL)
GROUP BY
 occurrence.kingdom,
 occurrence.kingdomkey,
 occurrence.phylum,
 occurrence.phylumkey,
 occurrence.class,
 occurrence.classkey,
 occurrence."order",
 occurrence.orderkey,
 occurrence.family,
 occurrence.familykey,
 occurrence.genus,
 occurrence.genuskey,
 occurrence.species,
 occurrence.specieskey,
 occurrence."year"

 The dataset's 25013287 records were derived from 70505 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0038795-251120083545085/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.17026/ar/tolbkd
title: PAN-00164522 - smooth ware jug type St. 110

description: &lt;p&gt;This find is registered at Portable Antiquities of the Netherlands with number PAN-00164522&lt;/p&gt;
description: Modified: 2025-11-03T14:52:57+01:00