California Open Data Publisher's Handbook
Documents and ResourcesCA Open Data Portal
  • Introduction
  • β˜‘οΈ1. Review the Pre-Publishing Checklist
  • πŸ“ˆ2. Prepare Data for Publishing
  • πŸ“™3. Create Metadata and Data Dictionary
  • πŸ”Ό4. Upload the Dataset
  • πŸ‘5. Get Final Publishing Approval
  • πŸ”„6. Update and Maintain the Dataset
  • πŸ“£Feedback & Help
  • Reference
    • The What and Why of Open Data
    • Open Data Portals Managed by State Entities
    • Data Preparation and Formatting Guidance
      • Column Headers and Order
      • Date and Time
      • Text
      • Numeric
      • Addresses
    • Metadata Field Definitions
    • Data Dictionary: What to Include
    • Detailed Steps for Uploading Data to the Portal
    • Email Templates
    • Glossary
    • Acknowledgements
    • Version and Changelog
Powered by GitBook
On this page
  • Column Headers
  • Column Order

Was this helpful?

Edit on GitHub
Export as PDF
  1. Reference
  2. Data Preparation and Formatting Guidance

Column Headers and Order

Column Headers

  • Only use alphanumeric or these 3 special characters: period (.), dash (-), and underscore (_)

    • Ampersand (&) should be replaced by β€œand” if needed

  • Each header must be unique

    • e.g. can’t have two headers called "duration"

  • Units of measure should be omitted

    • Units can and must be provided with the data dictionary

  • Keep short (less than 30 characters)

    • A full description can and must be provided with the data dictionary

Column Order

  • Unique identifiers should be in the left-most column if applicable

  • Date and time variables should be in the first column for time series data

  • Fixed or classified variables should be ordered with the highest-level variable on the left and most granular variable on the right, for example

  • Observed variables should always be on the rightmost columns, these are measured variables often numeric, the following are some example field names that could be observed variables:

    • Duration

    • Number of Units

    • Number of Stories

    • Year Built

    • People Served

PreviousData Preparation and Formatting GuidanceNextDate and Time

Last updated 1 year ago

Was this helpful?