Washington Flora Checklist

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

Search:
- Search by Field

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.

ID	A unique integer identifier for each record in this table.
Hits	Records the number of times each family has been accessed through the website.
Treatment Authors	The name(s) of the checklist author(s) who compiled and wrote the treatment for each family name.
Last Modified On	The full date and time that each family name was last modified by one of the checklist authors.
Last Modified By	The name of the last checklist author to modify each family name's data.
Family	Scientific name of the family. Names may be accepted or synonyms.
Common Names	A list of common names that have been applied to each family.
Name References	A comma-separted list of the usage references - or authoritative sources - that treat the family as accepted.
Taxonomic Status	A 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 Clarification	A short text note that appears after a family name to clarify its taxonomic/nomenclatural status (eg: 'in part').
Accepted Family ID	The 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 Name	The 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.
Notes	A 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.

ID	A unique integer identifier for each record in this table.
Hits	Records the number of times each scientific name has been accessed through the website.
Treatment Authors	The name(s) of the checklist author(s) who compiled and wrote the treatment for each scientific name.
Last Modified On	The full date and time that each family name was last modified by one of the checklist authors.
Last Modified By	The name of the last checklist author to modify each scientific name.
Name Rank	The 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'.
Family	The name of the family to which each scientific name belongs. Corresponds to a family in the families table.
Search And Sort Name	A 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.
Genus	Genus name only for each scientific name.
Species Epithet	Species epithet only for each scientific name. Doesn't include the genus.
Species Author	Species authors for each scientific name.
Trinomial Rank	The 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 Epithet	The epithet of the first sub-specific portion of each scientific name.
Trinomial Author	The authors of the first sub-specific portion of each scientific name.
Quadrinomial Rank	The 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 Epithet	The epithet of the second sub-specific portion of each scientific name.
Quadrinomial Author	The 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 Parents	The 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 Names	A list of the common names that have been applied to this scientific name.
Usage References	A 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 Published	Year in which each scientific name was first published, even if invalidly published.
Name Publication	The citation for the publication in which each scientific name was first published.
Types	Information 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 Status	A 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 Clarification	A 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 ID	The 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. Name	The (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 WA	A 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.
Endemic	A 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.
Origin	A 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 Text	A text-string containing a more detailed human-readable version of the origin of each accepted taxon for display on the lists.
Herbarium	Acronym 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.
Accession	The accession number for the designated voucher that verifies the presence of each accepted taxon in the state.
Collector	The collector's name for the designated voucher that verifies the presence of each accepted taxon in the state.
Collector Number	The collector's number for the designated voucher that verifies the presence of each accepted taxon in the state..
Label Data	Full 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.
Notes	A 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.

ID	A unique integer identifier for each record in this table.
Name ID	ID 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.
Title	Title only for each reference, used in the popup tooltips that appear when a literature code is highlighted in the checklist.
Citation	Full citation for each literature reference.
URL	Full 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.

ID	A unique integer identifier for each record in this table.
Name ID	ID of the scientific name or family (including synonyms and misapplied names) to which each link is associated.
Link Name	Text name of each link.
Link URL	Full URL for each link.