State Flowers List v.2.0.0
50 Database Records
State Flowers List is a carefully rebuilt reference to the official floral emblem of every U.S. state. Each record includes Census and postal identifiers, the state's official common designation, emblem type, adoption year and legal or resolution evidence, a row-level state-government source, and a separately sourced modern botanical interpretation. Ambiguous laws remain at genus or collective rank instead of being forced into a species. The protected package includes CSV, JSON, SQLite, schemas, samples, statistics, documentation, and complete source notes.
Table Schema Database Field Statistics
Release structure
State Flowers List
Review the published tables, record coverage, and field names included with release 2.0.0.
- Database
- #736
- Version
- 2.0.0
- Format
- XML schema
Data dictionary
Tables and fields
| Field | Type | Required | Description |
|---|---|---|---|
| state_fips | text | Yes | Two-digit U.S. Census state FIPS code. |
| postal_code | text | Yes | Two-letter USPS state abbreviation. |
| state_name | text | Yes | State name. |
| official_common_designation | text | Yes | State-designated common wording, normalized only for display. |
| scientific_name | text | Yes | Current botanical name at the rank supportable from the designation. |
| taxonomic_rank | text | Yes | Species, genus, cultivar, or collective resolution. |
| plant_family | text | Yes | Current botanical family. |
| emblem_type | text | Yes | Legal or official emblem category. |
| adoption_year | integer | Yes | Year of controlling designation or material clarification. |
| legal_reference | text | Yes | Statute, act, or resolution evidence. |
| designation_scope | text | Yes | Qualification of the selected emblem. |
| shared_designation_group | text | No | Relationship key for shared common designations. |
| legal_source_publisher | text | Yes | State government publisher. |
| legal_source_url | text | Yes | Row-level official state-government evidence URL. |
| taxonomy_source_publisher | text | Yes | Modern taxonomy authority. |
| taxonomy_source_url | text | Yes | Taxonomy lookup URL. |
| methodology_note | text | Yes | Caution about legal wording or botanical resolution. |
Release at a glance
What is inside this database
Review verified record totals, geographic coverage, classifications, and field completeness for State Flowers List.
state_fipsTwo-digit U.S. Census state FIPS code.
- Distinct
- 50
- Missing
- 0.0%
postal_codeTwo-letter USPS state abbreviation.
- Distinct
- 50
- Missing
- 0.0%
state_nameState name.
- Distinct
- 50
- Missing
- 0.0%
official_common_designationState-designated common wording, normalized only for display.
- Distinct
- 45
- Missing
- 0.0%
scientific_nameCurrent botanical name at the rank supportable from the designation.
- Distinct
- 42
- Missing
- 0.0%
taxonomic_rankSpecies, genus, cultivar, or collective resolution.
- Distinct
- 4
- Missing
- 0.0%
plant_familyCurrent botanical family.
- Distinct
- 27
- Missing
- 0.0%
emblem_typeLegal or official emblem category.
- Distinct
- 5
- Missing
- 0.0%
adoption_yearYear of controlling designation or material clarification.
- Distinct
- 33
- Missing
- 0.0%
legal_referenceStatute, act, or resolution evidence.
- Distinct
- 50
- Missing
- 0.0%
designation_scopeQualification of the selected emblem.
- Distinct
- 28
- Missing
- 0.0%
shared_designation_groupRelationship key for shared common designations.
- Distinct
- 8
- Missing
- 68.0%
legal_source_publisherState government publisher.
- Distinct
- 50
- Missing
- 0.0%
legal_source_urlRow-level official state-government evidence URL.
- Distinct
- 50
- Missing
- 0.0%
taxonomy_source_publisherModern taxonomy authority.
- Distinct
- 1
- Missing
- 0.0%
taxonomy_source_urlTaxonomy lookup URL.
- Distinct
- 42
- Missing
- 0.0%
methodology_noteCaution about legal wording or botanical resolution.
- Distinct
- 40
- Missing
- 0.0%
Taxonomy Rank
- Species36
- Genus12
- Cultivar1
- Collective1
Emblem Type
- State Flower44
- State Floral Emblem3
- Official Flower1
- State Flower And Floral Emblem1
- State Cultivated Flower1
Records Information
One record for each of the 50 states, keyed by FIPS code with a unique postal abbreviation. Washington, D.C. and territories are explicitly excluded by the immutable product methodology.
Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.
Need a closer fit?
Data shaped around your project.
Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.RECENT DATA UPDATES
Public School Districts Database
19,439 Districts and education agencies
v. 2.0.0
Updated 2 weeks ago
v. 2.0.0
Updated 2 weeks ago
Computer Networking Services Database
48,446 IT and networking locations
v. 2.0.0
Updated 2 weeks ago
v. 2.0.0
Updated 2 weeks ago
Custom Data Solutions
Tell us the industry, geography, fields, and format you need. We can help assemble a practical dataset for your project.
Discuss your data needs