Open data
Download the database
The whole BullionBase database - every coin, bar and round, with its makers, marks and full edit history - free to download and reuse under the Open Database License. A new release goes out on the 1st of every month.
Latest release
The first release will be published on December 1, 2026. After that, a new release goes out on the 1st of every month.
What is in it
One row per edition: a specific issue of an item, such as one year, finish or design of it. The code (BB12) is the one shown on the site. Coin, bar and round details are all in this file; a column that does not apply to an edition's format is empty.
One row per item: a product line as collectors know it, such as the 1 oz Silver Maple Leaf, whose editions are in editions. Coin, bar and round details are all in this file; a column that does not apply to an item's format is empty.
Mints, refineries, brands, hand pourers and distributors. A producer is never a country: a coin's issuing country is items.issuing_country_id.
Programs that group items, such as Canadian Wildlife or Lunar Series II. A series can sit within a wider one.
Designers and engravers credited on editions.
The marks library: makers' marks, assay hallmarks, counterstamps and date marks found on pieces. Which editions carry which mark is in edition_marks.
Plants where producers make their pieces, such as a refiner's separate sites.
Collections sold as one product, such as a four-coin proof set. Their editions are in set_members.
Which marks each edition carries.
Treatments applied on top of an edition's strike, such as gilding, colorization or ruthenium plating. An edition can have several.
The editions in each set.
Former names of producers, with the years they were used.
Accreditations a facility holds from outside bodies, such as LBMA Good Delivery.
Countries, including former ones, referred to by the other files.
The precious metals, with their chemical symbols.
The units weights are given in, with each one's size in grams.
The treatments that can be applied on top of a strike, as used by edition_surface_treatments.
Every create and every edit of every record, with the record as it stood afterward. Who made each edit is never included.
Where a value came from: one row per source supporting one field of one record, as shown in the record's Sources list. Each row carries its source's details itself; there is no separate table of sources. Who added it is never included; its revision is in revisions.
A record's name in another language, where it has one: the Iberian Lynx for the item named Lince Ibérico. A record's own name, in its file's name column, is in the piece's own language; this file adds at most one name per language. Items, producers and series so far. The site shows a record under its name in the page's language where there is one, and searches every name.
What is not in it
- Photos. Contributors' photos are licensed separately, under CC BY-SA 4.0, and stay on each record's page on the site. The release is the data itself.
- Anything about contributors. Every edit is in the release, but not who made it: no name, handle or identifier of any kind, because people who photograph bullion are photographing what they own.
- Commercial information. Who sells a piece, at what price and in what quantity is not part of the database and is never in the release.
License and credit
The data is available under the Open Database License (ODbL) v1.0, the license OpenStreetMap uses. You may copy it, share it and build on it, including commercially. Credit it, and if you publish a database made from it, keep that database open under the same license.
Credit it like this:
Contains data from BullionBase (https://bullionbase.com) and its contributors, available under the Open Database License (ODbL) v1.0.
How releases work
- A release is named by the date of its snapshot, and every file in it comes from that one moment.
- A release is never changed once published. One found to be wrong is marked withdrawn, and a corrected release follows.
- The format has its own version. A minor version only adds columns or files. A major version changes or removes something; it is announced a release ahead, and both formats are published for three months.
- The major version is part of every address, so a script that reads v0/latest.json keeps working until you choose to move.
- Codes such as BB12 are never reused. A record merged into a duplicate stays in every release, pointing to where it went.
Copies and mirrors
Keeping your own copy, or a public mirror, needs no permission: the license already allows it, and it is what the license is for. Public mirrors will be listed here.
Guide to the files
- Every file comes as CSV and as JSON Lines, both gzipped, with the same columns in the same order.
- CSV files are UTF-8 with a header row, comma-separated, double-quoted where needed, with LF line endings. An empty field is a missing value; an empty text value is written as "" so the two never mix (PostgreSQL's COPY reads them this way).
- JSON Lines files hold one JSON object per line. A missing value is null; numbers and true/false are JSON numbers and booleans.
- Dates are YYYY-MM-DD. Times are ISO 8601 in UTC, such as 2026-11-01T00:00:05.123456Z.
- Decimals are exact, with no trailing zeros. Weights are in grams and dimensions in millimeters unless a column says otherwise.
- A list (such as a mark's motifs) is a JSON array; in CSV it is written as JSON text.
- Rows are sorted by their key, so two releases can be compared line by line.
- Text is exactly as contributed. Spreadsheet programs may treat text beginning with = as a formula; open the files as data, not by double-clicking, if that matters to you.
Editionseditions54 columns
One row per edition: a specific issue of an item, such as one year, finish or design of it. The code (BB12) is the one shown on the site. Coin, bar and round details are all in this file; a column that does not apply to an edition's format is empty.
- idinteger, key
- The edition's number. Never reused, even after a merge.
- codetext
- The code shown on the site: BB followed by id.
- item_idinteger, refers to items.id
- The item this is an edition of (items.id).
- formatenum
- coin, bar or round - always the same as the item's.coin · bar · round
- slugtext
- The readable end of the record's web address (bullionbase.com/ + lowercase code + - + slug). It changes when a record is renamed; the code never does.
- yearinteger
- The year on the piece, or the year of issue. May be empty.
- year_labeltext
- Coins: the date as written when it is not a plain year, such as a span across two years. May be empty.
- era_frominteger
- For an undated piece: roughly the first year it was made. May be empty.
- era_tointeger
- For an undated piece: roughly the last year it was made. Empty if still made. May be empty.
- design_nametext
- The named design, such as Statue of Liberty. May be empty.
- design_varianttext
- A variety within that design, such as Large Date or Type 2. May be empty.
- mint_marktext
- Coins: the mint mark, the small letter identifying which mint struck it. May be empty.
- privy_marktext
- Coins: a small extra mark added to a standard design, such as a lunar animal. May be empty.
- strike_typeenum
- Coins: how it was struck.bullion_bu · proof · burnished · reverse_proof · enhanced_reverse_proof · enhanced_uncirculated May be empty.
- finishenum
- Rounds: the finish of the strike.bu · proof · proof_like · reverse_proof_like · matte May be empty.
- bar_subtypeenum
- Bars: commercial (sold as bullion), art_bar or industrial_pour.commercial · art_bar · industrial_pour May be empty.
- manufacturing_methodenum
- How it was made: cast_poured, minted_struck, extruded or machined. Always given for a bar; given for a round when known (a round is struck or poured); empty for a coin.cast_poured · minted_struck · extruded · machined May be empty.
- shapeenum
- Bars: the outline.rectangle · rounded_rect · square · oval · loaf · bullet · figural · freeform · other May be empty.
- orientationenum
- Bars: whether the design reads portrait or landscape.portrait · landscape · na May be empty.
- design_generationtext
- Bars: which run of a long-lived design, where the producer revised the artwork over the years. May be empty.
- logo_hallmark_varianttext
- Bars: which version of the producer's logo or maker's mark it carries. May be empty.
- hallmark_positionenum
- Bars: where the maker's mark sits on the face.top · mid · bottom · left · right · top_left · custom · na May be empty.
- reverse_designtext
- Bars: what is on the back. "blank" is a real answer. May be empty.
- community_nametext
- Bars: the name collectors use for it, where that differs from anything the producer printed. May be empty.
- assay_cardenum
- Bars: whether it was issued sealed in an assay card, and which generation of card.none · included · gen_1 · gen_2 · gen_3 · veriscan May be empty.
- obverse_designer_idinteger, refers to designers.id
- Who designed the obverse (designers.id). May be empty.
- reverse_designer_idinteger, refers to designers.id
- Who designed the reverse (designers.id). May be empty.
- manufacturer_idinteger, refers to producers.id
- The company that physically made this edition, when that is not the item's producer - a mint working under contract (producers.id). May be empty.
- facility_idinteger, refers to facilities.id
- The plant it was made at (facilities.id). May be empty.
- distributor_idinteger, refers to producers.id
- A distributor or counterstamp partner that commissioned or sold this edition (producers.id). May be empty.
- derived_from_edition_idinteger, refers to editions.id
- For a run modified after striking by someone other than the maker (colorized, gilded, counterstamped): the edition it was made from (editions.id). May be empty.
- diameter_mmdecimal
- Diameter in millimeters. May be empty.
- length_mmdecimal
- The longer edge in millimeters. May be empty.
- width_mmdecimal
- The shorter edge in millimeters. May be empty.
- thickness_mmdecimal
- Thickness in millimeters. May be empty.
- mintageinteger
- How many were made. May be empty.
- mintage_confidenceenum
- How reliable the mintage is. unknown means someone checked and no reliable figure exists; empty means nobody has said.confirmed · estimated · unknown May be empty.
- mintage_boundenum
- Which way the mintage reads: exact, at_most (the figure or fewer, as with an announced limit) or at_least (the figure or more, as with ongoing production).exact · at_most · at_least May be empty.
- coa_includedboolean
- Issued with a certificate of authenticity. May be empty.
- box_includedboolean
- Issued in a box or presentation case. May be empty.
- security_featuretext
- A named feature that proves the piece genuine, such as Veriscan or MintMark SI. May be empty.
- special_designationtext
- A release detail that does not warrant its own edition, such as First Strike, a numbered run or a signed certificate. May be empty.
- licensed_brandtext
- A licensed franchise or brand on the design, such as Star Wars. May be empty.
- sustainability_designationtext
- A responsible-sourcing label as marketed, such as Carbon Neutral. May be empty.
- serial_presentenum
- Whether pieces in the run carry a serial number. absent_error means one was missed by mistake.present · absent_intentional · absent_error · na May be empty.
- serial_prefixtext
- The letters that begin the run's serial numbers. May be empty.
- serial_number_formattext
- The shape of the serial numbers: L for a letter, # for a digit, so P123456 is L######. May be empty.
- pcgs_coin_numbertext
- Coins: PCGS's catalog number for this coin. May be empty.
- ngc_coin_idtext
- Coins: NGC's identifier for this coin. May be empty.
- data_qualityenum
- The community's verdict on the record. New records start at needs_vote.needs_vote · needs_major_changes · needs_minor_changes · correct · correct_and_complete
- merged_into_idinteger, refers to editions.id
- Set when this record was found to be a duplicate and merged: the record it now lives on (editions.id). Its code redirects there. May be empty.
- merged_attimestamp
- When it was merged. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Itemsitems28 columns
One row per item: a product line as collectors know it, such as the 1 oz Silver Maple Leaf, whose editions are in editions. Coin, bar and round details are all in this file; a column that does not apply to an item's format is empty.
- idinteger, key
- The item's number. Never reused, even after a merge.
- codetext
- The code shown on the site: IT followed by id.
- formatenum
- coin, bar or round.coin · bar · round
- nametext
- The name.
- slugtext
- The readable end of the record's web address (bullionbase.com/ + lowercase code + - + slug). It changes when a record is renamed; the code never does.
- producer_idinteger, refers to producers.id
- The mint, refinery or brand whose product this is (producers.id). Never a country: a coin's issuing country is issuing_country_id.
- series_idinteger, refers to series.id
- The program it belongs to, such as Canadian Wildlife (series.id). May be empty.
- metalenum
- The precious metal.gold · silver · platinum · palladium
- finenessdecimal
- Purity as a fraction, such as 0.9999. May be empty.
- fineness_confidenceenum
- How reliable the fineness is. unknown means someone checked and no reliable figure exists; empty means nobody has said.confirmed · estimated · unknown May be empty.
- nominal_weight_valuedecimal
- The weight it is sold as, in nominal_weight_unit, such as 1 or 0.1.
- nominal_weight_unittext, refers to weight_units.code
- The unit of nominal_weight_value, such as oz_t for troy ounces (weight_units.code).
- nominal_weight_approximateboolean
- True when the weight is a class rather than exact, as with hand-poured bars sold as about 3 oz.
- fine_weight_gramsdecimal
- Precious metal content in grams. Empty when the weight is approximate. May be empty.
- gross_weight_gramsdecimal
- Total weight in grams as published, alloy included. May be empty.
- design_aftertext
- The earlier design it reproduces, in words, such as 1913 Buffalo nickel. May be empty.
- issuing_country_iduuid, refers to countries.id
- Coins: the country that issued it as legal tender (countries.id). Often not where it was struck. May be empty.
- denomination_valuedecimal
- Coins: the face value. May be empty.
- denomination_currencytext
- Coins: the face value's three-letter currency code, such as CAD. May be empty.
- compositiontext
- Coins: the alloy, as described by the producer. May be empty.
- edgeenum
- Coins and rounds: the edge.reeded · plain · lettered May be empty.
- km_numbertext
- Coins: the Krause (Standard Catalog of World Coins) number, without its KM#, such as 106 or 625a. May be empty.
- ira_eligibleboolean
- Whether it qualifies for a US precious-metals IRA. May be empty.
- data_qualityenum
- The community's verdict on the record. New records start at needs_vote.needs_vote · needs_major_changes · needs_minor_changes · correct · correct_and_complete
- merged_into_idinteger, refers to items.id
- Set when this record was found to be a duplicate and merged: the record it now lives on (items.id). Its code redirects there. May be empty.
- merged_attimestamp
- When it was merged. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Producersproducers16 columns
Mints, refineries, brands, hand pourers and distributors. A producer is never a country: a coin's issuing country is items.issuing_country_id.
- idinteger, key
- The producer's number. Never reused, even after a merge.
- codetext
- The code shown on the site: PR followed by id.
- nametext
- The name.
- slugtext
- The readable end of the record's web address (bullionbase.com/ + lowercase code + - + slug). It changes when a record is renamed; the code never does.
- short_nametext
- A common short form of the name, such as RCM. May be empty.
- typeenum
- Its role. brand_issuer owns the product but has it made by someone else; assay_office tests pieces and hallmarks other makers' work. Empty for an unidentified maker.sovereign_mint · private_mint · refinery · brand_issuer · hand_pourer · distributor · assay_office May be empty.
- identification_statusenum
- identified (a known maker), provisional (an unidentified maker grouped by a recurring mark) or unattributed (the one placeholder for pieces with no known maker).identified · provisional · unattributed
- country_iduuid, refers to countries.id
- Where it is based (countries.id). May be empty.
- parent_producer_idinteger, refers to producers.id
- The company it became part of, or its parent (producers.id). May be empty.
- active_frominteger
- The year it began operating. May be empty.
- active_tointeger
- The year it stopped, if it has. May be empty.
- descriptiontext
- A short description, as written by contributors. May be empty.
- merged_into_idinteger, refers to producers.id
- Set when this record was found to be a duplicate and merged: the record it now lives on (producers.id). Its code redirects there. May be empty.
- merged_attimestamp
- When it was merged. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Seriesseries11 columns
Programs that group items, such as Canadian Wildlife or Lunar Series II. A series can sit within a wider one.
- idinteger, key
- The series's number. Never reused, even after a merge.
- codetext
- The code shown on the site: SR followed by id.
- nametext
- The name.
- slugtext
- The readable end of the record's web address (bullionbase.com/ + lowercase code + - + slug). It changes when a record is renamed; the code never does.
- producer_idinteger, refers to producers.id
- The producer running the program (producers.id).
- parent_series_idinteger, refers to series.id
- The wider program this one sits within (series.id). May be empty.
- introduced_yearinteger
- The year it began. May be empty.
- discontinued_yearinteger
- The year it ended, if it has. May be empty.
- descriptiontext
- A short description, as written by contributors. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Designersdesigners13 columns
Designers and engravers credited on editions.
- idinteger, key
- The designer's number. Never reused, even after a merge.
- codetext
- The code shown on the site: DS followed by id.
- nametext
- The name.
- slugtext
- The readable end of the record's web address (bullionbase.com/ + lowercase code + - + slug). It changes when a record is renamed; the code never does.
- initialstext
- The initials or monogram they sign a design with, as found on the piece. May be empty.
- country_iduuid, refers to countries.id
- Their country (countries.id). May be empty.
- birth_yearinteger
- Year of birth. May be empty.
- death_yearinteger
- Year of death. May be empty.
- descriptiontext
- A short description, as written by contributors. May be empty.
- merged_into_idinteger, refers to designers.id
- Set when this record was found to be a duplicate and merged: the record it now lives on (designers.id). Its code redirects there. May be empty.
- merged_attimestamp
- When it was merged. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Marksmarks13 columns
The marks library: makers' marks, assay hallmarks, counterstamps and date marks found on pieces. Which editions carry which mark is in edition_marks.
- idinteger, key
- The mark's number. Never reused, even after a merge.
- codetext
- The code shown on the site: MK followed by id.
- nametext
- The name.
- slugtext
- The readable end of the record's web address (bullionbase.com/ + lowercase code + - + slug). It changes when a record is renamed; the code never does.
- typeenum
- assay_hallmark is an official purity mark; counterstamp was added after the piece was made.makers_mark · assay_hallmark · counterstamp · date_mark · other
- producer_idinteger, refers to producers.id
- Whose mark it is (producers.id). Empty while the maker is unidentified. May be empty.
- motifsenum list
- What the mark shows.eagle · banner · star · crown · shield · lion · anchor · sun · mountain · monogram · other May be empty.
- fontenum
- The style of its lettering.script · serif · sans_serif · stylized · other May be empty.
- active_frominteger
- The first year it was used. May be empty.
- active_tointeger
- The last year it was used. May be empty.
- descriptiontext
- A short description, as written by contributors. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Facilitiesfacilities15 columns
Plants where producers make their pieces, such as a refiner's separate sites.
- idinteger, key
- The facility's number. Never reused, even after a merge.
- codetext
- The code shown on the site: FA followed by id.
- nametext
- The name.
- slugtext
- The readable end of the record's web address (bullionbase.com/ + lowercase code + - + slug). It changes when a record is renamed; the code never does.
- producer_idinteger, refers to producers.id
- The producer that runs it (producers.id).
- citytext
- City. May be empty.
- regiontext
- State, province or region. May be empty.
- country_iduuid, refers to countries.id
- Country (countries.id). May be empty.
- addresstext
- Street address, where public. May be empty.
- serial_prefixtext
- The serial-number prefix used on pieces made here. May be empty.
- active_frominteger
- The year it opened. May be empty.
- active_tointeger
- The year it closed, if it has. May be empty.
- descriptiontext
- A short description, as written by contributors. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Setssets10 columns
Collections sold as one product, such as a four-coin proof set. Their editions are in set_members.
- idinteger, key
- The set's number. Never reused, even after a merge.
- nametext
- The name.
- slugtext
- The readable end of the record's web address (bullionbase.com/ + lowercase code + - + slug). It changes when a record is renamed; the code never does.
- producer_idinteger, refers to producers.id
- The producer that issued it (producers.id).
- release_yearinteger
- The year it was released. May be empty.
- mintageinteger
- How many sets were made. May be empty.
- mintage_confidenceenum
- How reliable the mintage is. unknown means someone checked and no reliable figure exists; empty means nobody has said.confirmed · estimated · unknown May be empty.
- descriptiontext
- A short description, as written by contributors. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Edition marksedition_marks6 columns
Which marks each edition carries.
- iduuid, key
- The row's identifier.
- edition_idinteger, refers to editions.id
- The edition (editions.id).
- mark_idinteger, refers to marks.id
- The mark it carries (marks.id).
- positiontext
- Where the mark is on the piece, as described, such as obverse lower left. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Edition surface treatmentsedition_surface_treatments7 columns
Treatments applied on top of an edition's strike, such as gilding, colorization or ruthenium plating. An edition can have several.
- iduuid, key
- The row's identifier.
- edition_idinteger, refers to editions.id
- The edition (editions.id).
- treatment_codetext, refers to surface_treatments.code
- The treatment (surface_treatments.code).
- order_in_stackinteger
- The order the treatments were applied in, when known: 1 first. May be empty.
- notestext
- Notes on this treatment of this edition. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Set membersset_members7 columns
The editions in each set.
- iduuid, key
- The row's identifier.
- set_idinteger, refers to sets.id
- The set (sets.id).
- edition_idinteger, refers to editions.id
- An edition in it (editions.id).
- positioninteger
- Its place in the set's order. May be empty.
- quantityinteger
- How many of that edition the set holds, such as 50 for a CombiBar of 50 one-gram pieces.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Producer aliasesproducer_aliases7 columns
Former names of producers, with the years they were used.
- iduuid, key
- The row's identifier.
- producer_idinteger, refers to producers.id
- The producer (producers.id).
- alias_nametext
- The former name.
- active_frominteger
- The first year it was used. May be empty.
- active_tointeger
- The last year it was used. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Facility accreditationsfacility_accreditations10 columns
Accreditations a facility holds from outside bodies, such as LBMA Good Delivery.
- iduuid, key
- The row's identifier.
- facility_idinteger, refers to facilities.id
- The facility (facilities.id).
- bodytext
- The accrediting body, such as LBMA or COMEX.
- typetext
- What is accredited, such as good_delivery_gold.
- statusenum
- Whether the accreditation stands.active · suspended · former
- first_listeddate
- When the facility was first listed. May be empty.
- status_changed_atdate
- When the status last changed. May be empty.
- notestext
- Notes. May be empty.
- created_attimestamp
- When the record was created.
- updated_attimestamp
- When the record last changed.
Countriescountries5 columns
Countries, including former ones, referred to by the other files.
- iduuid, key
- The country's identifier.
- nametext
- The name.
- iso_codetext
- Its ISO 3166-1 alpha-3 code, such as CAN, or an ISO 3166-3 code for a former country, such as SUHH for the USSR.
- active_frominteger
- The year it was formed, where that matters. May be empty.
- active_tointeger
- The year it was dissolved, for a former country. May be empty.
Metalsmetals3 columns
The precious metals, with their chemical symbols.
- iduuid, key
- The metal's identifier.
- nametext
- The name.
- symboltext
- Its chemical symbol, such as Au.
Weight unitsweight_units6 columns
The units weights are given in, with each one's size in grams.
- codetext, key
- The unit's code, as used by items.nominal_weight_unit.
- symboltext
- How it is written, such as oz.
- display_nametext
- Its full name, such as troy ounce.
- grams_per_unitdecimal
- How many grams one unit is.
- is_activeboolean
- Whether contributors can currently choose it.
- sort_orderinteger
- The order the site lists units in. May be empty.
Surface treatmentssurface_treatments9 columns
The treatments that can be applied on top of a strike, as used by edition_surface_treatments.
- codetext, key
- The treatment's code.
- nametext
- The name.
- categoryenum
- overlay (decoration on top), plating (a thin metal layer), texture (surface relief) or effect (intentional toning).overlay · plating · texture · effect
- descriptiontext
- What it is. May be empty.
- applies_to_coinsboolean
- Whether it is offered for coins.
- applies_to_barsboolean
- Whether it is offered for bars.
- applies_to_roundsboolean
- Whether it is offered for rounds.
- is_activeboolean
- Whether contributors can currently choose it.
- sort_orderinteger
- The order the site lists treatments in. May be empty.
Edit historyrevisions9 columns
Every create and every edit of every record, with the record as it stood afterward. Who made each edit is never included.
- iduuid, key
- The revision's identifier. Sorting by it sorts by time.
- record_typeenum
- Which kind of record was changed.item · edition · producer · series · facility · set · designer · mark · specimen
- record_idinteger
- The changed record's id in its own file, such as editions.id for an edition.
- revision_numberinteger
- 1 for the record's creation, then 2, 3 and so on for each edit.
- timestamptimestamp
- When the change was made.
- submission_notestext
- The reason given for the change, as its contributor wrote it.
- snapshotjson
- The record after the change, as JSON. Its keys follow the site's forms at the time of the edit, so older revisions can be shaped differently from newer ones.
- statusenum
- active, superseded (a later revision replaced it) or reverted (undone).active · superseded · reverted
- reverted_by_revision_iduuid
- For a reverted revision, the revision that undid it (revisions.id). May be empty.
Sourcescitations16 columns
Where a value came from: one row per source supporting one field of one record, as shown in the record's Sources list. Each row carries its source's details itself; there is no separate table of sources. Who added it is never included; its revision is in revisions.
- iduuid, key
- The citation's identifier.
- record_typeenum
- Which kind of record it belongs to.item · edition · producer · series · facility · set · designer · mark · specimen
- record_idinteger
- The record's id in its own file, such as editions.id for an edition.
- fieldtext
- The field it supports, named as in the record's revision snapshots, such as estimatedMintage or kmNumber; empty when it cites the record as a whole. May be empty.
- kindenum
- link (a web page, or a scan in a public archive), publication (a printed book, catalog, brochure or gazette) or photo (a photo on BullionBase).link · publication · photo
- urltext
- For a link, the page; for a publication, an online copy if there is one. May be empty.
- titletext
- The page's or publication's title. May be empty.
- publishertext
- The site, publisher or author. May be empty.
- publishedtext
- A date, year or edition, as the source gives it. May be empty.
- isbntext
- A publication's ISBN, if it has one. May be empty.
- photo_iduuid
- For a photo, its identifier on BullionBase. Photos are not part of this release. May be empty.
- locatortext
- Where in the source: a page, table or entry. May be empty.
- quotetext
- What the source says, in its own words, if quoted. At most 300 characters. May be empty.
- cited_valuetext
- The value the source supports, as stored when it was cited. When it differs from the field's current value, the site shows it as what another source says. May be empty.
- checked_ondate
- The date the contributor checked the source. May be empty.
- positioninteger
- The order the record lists its sources in.
Names in other languagesentity_names5 columns
A record's name in another language, where it has one: the Iberian Lynx for the item named Lince Ibérico. A record's own name, in its file's name column, is in the piece's own language; this file adds at most one name per language. Items, producers and series so far. The site shows a record under its name in the page's language where there is one, and searches every name.
- iduuid, key
- The name's identifier.
- record_typeenum
- Which kind of record it names.item · edition · producer · series · facility · set · designer · mark · specimen
- record_idinteger
- The record's id in its own file, such as items.id for an item.
- langtext
- The language, as a BCP 47 tag: en for English.
- nametext
- The record's name in that language.