Washington Flora Checklist
A Checklist of the Vascular Plants of Washington State
Hosted by the University of Washington Herbarium

 


About the Data Files

The Washington Flora Checklist data is stored in a database. The contents of the checklist database can be accessed through the files listed below, which are pulled directly from the database tables without modification. Because they are pulled directly from the database, these files will always contain the most recent revisions made to the checklist.

Each file is in tab-delimited text format. These files are not meant for general viewing; instead they provide access to the raw data for use in other applications and databases. Explanations of the fields contained in each file are provided below.

Please cite the Washington Flora Checklist as the source of these data files.

» Family Table
» Names Table
» Literature Table
» External Links Table


Data Fields and Definitions

Family Table:

The family table includes data for all families contained in the checklist. It includes both accepted family names and family synonyms.

IDA unique integer identifier for each record in this table.
HitsRecords the number of times each family has been accessed through the website.
Treatment AuthorsThe name(s) of the checklist author(s) who compiled and wrote the treatment for each family name.
Last Modified OnThe full date and time that each family name was last modified by one of the checklist authors.
Last Modified ByThe name of the last checklist author to modify each family name's data.
FamilyScientific name of the family. Names may be accepted or synonyms.
Common NamesA list of common names that have been applied to each family.
Name ReferencesA comma-separted list of the usage references - or authoritative sources - that treat the family as accepted.
Taxonomic StatusA single-letter code specifying the taxonomic status of each family as determined by the checklist authors. Codes are: 'A' for accepted, 'S' for synonym, and 'M' for misapplied name. Misapplied names are treated as a class of names separate from synonyms.
Status ClarificationA short text note that appears after a family name to clarify its taxonomic/nomenclatural status (eg: 'in part').
Accepted Family IDThe ID number (corresponds to the ID field in this table) referring to the accepted family to which each family belongs. This field has a value regardless of whether the family is accepted, a synonym, or misapplied. Accepted names refer to themselves, while synonyms and misapplied names refer to the appropriate accepted name.
Accepted Family NameThe name of the accepted family to which each family belongs. This field has a value regardless of whether the family is accepted, a synonym, or misapplied. Accepted names refer to themselves, while synonyms and misapplied names refer to the appropriate accepted name.
NotesA general-purpose field to hold any additional information associated with this family.


Taxa Names Table:

The family table includes data for all terminal taxa names (eg: species, subspecies, varieties, hybrids) contained in the checklist. It includes accepted names, synonyms, and excluded taxa, endemics, etc.

IDA unique integer identifier for each record in this table.
HitsRecords the number of times each scientific name has been accessed through the website.
Treatment AuthorsThe name(s) of the checklist author(s) who compiled and wrote the treatment for each scientific name.
Last Modified OnThe full date and time that each family name was last modified by one of the checklist authors.
Last Modified ByThe name of the last checklist author to modify each scientific name.
Name RankThe nomenclatural rank of each scientific name (not the taxon/accepted name), at the species level or lower. Possible values within this checklist are: 'species', 'subspecies', 'variety', 'f.', and 'hybrid'.
FamilyThe name of the family to which each scientific name belongs. Corresponds to a family in the families table.
Search And Sort NameA text string built from the component name fields for each scientific name. This value is used for searching and sorting within the checklist website. The Search And Sort name is the same as the full scientific name (without authors) except that hybrid symbols () have been removed. The full proper scientific name can be created by combining the remaining name fields in this table.
GenusGenus name only for each scientific name.
Species EpithetSpecies epithet only for each scientific name. Doesn't include the genus.
Species AuthorSpecies authors for each scientific name.
Trinomial RankThe first rank below species for each scientific name (eg: ssp., var., f.). It is possible for a scientific name to have two sub-specific ranks (eg: both ssp. and var.). In such cases the Trinomial fields hold the first sub-specific portion of the name while the Quadrinomial fields hold the second sub-specific portion. For names that have only one sub-specific rank (eg: trinomials), only the Trinomial fields will be used and the Quadrinomial fields will remain blank.
Trinomial EpithetThe epithet of the first sub-specific portion of each scientific name.
Trinomial AuthorThe authors of the first sub-specific portion of each scientific name.
Quadrinomial RankThe second sub-specific rank for each scientific name (if applicable, see notes under Trinomial Rank field). Valid options are 'var.' and .f.'; 'ssp.' is not allowed.
Quadrinomial EpithetThe epithet of the second sub-specific portion of each scientific name.
Quadrinomial AuthorThe authors of the second sub-specific portion of each scientific name.
Hybrid Symbol(only used for unnamed hybrids) The symbol (eg: ) used in the hybrid formula of an unnamed hybrid. If an entry in this table is not an unnamed hybrid then this field and all of the Second __ name fields will remain blank.
Second Genus(only used for unnamed hybrids) Genus name only of the second parent of an unnamed hybrid.
Second Species Epithet[only used for unnamed hybrids] Species epithet only of the second parent of an unnamed hybrid. Doesn't inlcude the genus.
Second Species Author[only used for unnamed hybrids] Species authors for the second parent of an unnamed hybrid.
Second Trinomial Rank[only used for unnamed hybrids] The first sub-specific rank of the second parent of an unnamed hybrid (eg: ssp., var., f.). It is possible for a second parent name to have two sub-specific ranks (eg: both ssp. and var.). In such cases the Second Trinomial fields hold the first sub-specific portion of the name while the Second Quadrinomial fields hold the second sub-specific portion. For names that have only one sub-specific rank (eg: trinomials), only the Trinomial fields will be used and the Quadrinomial fields will remain blank.
Second Trinomial Epithet[only used for unnamed hybrids] The epithet of the first sub-specific portion of the second parent of an unnamed hybrid.
Second Trinomial Author[only used for unnamed hybrids] The authors of the first sub-specific portion of the second parent of an unnamed hybrid.
Second Quadrinomial Rank[only used for unnamed hybrids] The second sub-specific rank of the second parent of an unnamed hybrid (if applicable; see also notes under Trinomial Rank field). Valid options are 'var.' and .f.'; 'ssp.' is not allowed.
Second Quadrinomial Epithet[only used for unnamed hybrids] The epithet of the second sub-specific portion of the second parent of an unnamed hybrid.
Second Quadrinomial Author[only used for unnamed hybrids] The authors of the second sub-specific portion of the second parent of an unnamed hybrid.
Hybrid ParentsThe names of the parents for a hybrid using typical unnamed hybrid formula notation. For consistency, parent names should be entered here regardless of whether the hybrid is named or unnamed.
Common NamesA list of the common names that have been applied to this scientific name.
Usage ReferencesA comma-separted list of the usage references - or authoritative sources - that treat the scientific name as accepted (even though this checklist may treat the name as a synonym).
Year PublishedYear in which each scientific name was first published, even if invalidly published.
Name PublicationThe citation for the publication in which each scientific name was first published.
TypesInformation about the type specimens associated with each scientific name. Free-text field that can hold any information, such as holotype location, other type locations, and type label data.
Taxonomic StatusA single-character code specifying the taxonomic status of each scientific name as determined by the checklist authors. Codes are: 'A' for accepted, 'S' for synonym, and 'M' for misapplied name. Misapplied names are treated as a class of names separate from synonyms.
Status ClarificationA short text note that can appear after a scientific name (not its taxon name) to clarify the name's taxonomic/nomenclatural status (eg: 'misapplied', 'in part', 'nomen inval.').
Taxon IDThe ID number (corresponds to the ID field in this table) of the accepted taxon to which this scientific name can be referred. This field has a value regardless of whether the scientific name is considered accepted, a synonym, or misapplied. Accepted names refer to themselves, while synonyms and misapplied names refer to the appropriate accepted taxon name.
Taxon S.A.S. NameThe (Search And Sort) name of the accepted taxon to which this name can be referred. This field has a value regardless of whether the name is considered accepted or a synonym. Accepted names refer to themselves, while synonyms and misapplied names refer to the appropriate accepted name. The Taxon S.A.S. name is identical to the full scientific name minus authors, except hybrid symbols () are excluded; hybrid symbols can interfere when performing searches or sorting.
Present/Excluded in WAA single-character code specifying whether a taxon is present in Washington State (eg: included in the checklist) or excluded from the state (eg: erroneous reports, misapplied names). Code values are: 'P' for present and 'E' for excluded. Does not apply to synonyms, but may apply to misapplied names.
EndemicA single-character code specifying whether a taxon is endemic to Washington State. Code values are 'Y' for endemic and 'N' for not endemic. Only applies to accepted taxa.
OriginA 1-2 letter code indicating the origin of each accepted taxon in Washington State. Possible code values are: 'N', 'N?' , 'I', 'I?', 'B', 'B?', '?', where N = Native, I = Introduced, B = Both native and introduced, and ? indicates uncertainty.
Origin TextA text-string containing a more detailed human-readable version of the origin of each accepted taxon for display on the lists.
HerbariumAcronym of the herbarium where a voucher is stored that verifies the presence of an accepted taxon in Washington State. More than one acronym can be listed, and additional notes can also be appended after the acronyms.
AccessionThe accession number for the designated voucher that verifies the presence of each accepted taxon in the state.
CollectorThe collector's name for the designated voucher that verifies the presence of each accepted taxon in the state.
Collector NumberThe collector's number for the designated voucher that verifies the presence of each accepted taxon in the state..
Label DataFull label data for the designated voucher for each accepted taxon. Free-text; can hold any information. Note: label data for vouchers stored at WTU are usually not included in this field; instead a link is automatically created to the voucher in the WTU specimen database.
NotesA general-purpose field to hold any additional information associated with this scientific name.


Literature Table:

The literature table includes data for all literature references cited in the checklist, except for the original publications associated with a scientific name (those publications are associated with the name in the Taxa Names Table). A given literature source may be included more than once if it is referenced by more than one family or taxon.

IDA unique integer identifier for each record in this table.
Name IDID of the scientific name or family (including synonyms and misapplied names) to which each link is associated.
Code A 3-6 letter code is assigned to most references. These codes are displayed as usage references after names in the checklist.
TitleTitle only for each reference, used in the popup tooltips that appear when a literature code is highlighted in the checklist.
CitationFull citation for each literature reference.
URLFull URL for the online access point of each literature reference, if the reference is available online.


External Links Table:

The external links table includes data for all external links included in the checklist. A given link may appear more than once if it is referenced by more than one family or taxon.

IDA unique integer identifier for each record in this table.
Name IDID of the scientific name or family (including synonyms and misapplied names) to which each link is associated.
Link NameText name of each link.
Link URLFull URL for each link.


© 2010 University of Washington Herbarium,
Burke Museum of Natural History and Culture.
All Rights Reserved.
Box 355325, University of Washington,
Seattle, WA 98195-5325.