Hours Worked by Employees in Colorado

Name: Hours Worked by Employees in Colorado
Creator: CDLE
Published: 2014-05-15T06:42:37

Estimated employment counts by month and industry with hours worked by industry from Colorado Department of Labor and Employment (CDLE), since 1990.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"colorado-gov/hours-worked-by-employees-in-colorado-pt2g-89wc\".\"hours_worked_by_employees_in_colorado\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

Preview

hours_worked_by_employees_in_colorado

Left sidebar is currently unimplemented

Right sidebar is currently unimplemented

Upstream Metadata

GeospatialCollection MethodNot specifiedHorizontal AccuracyNot specifiedCoordinate System DisclaimerNot specifiedHorizontal Coordinate SystemNot specifiedWeb Display Coordinate SystemNot specified

Data QualityExpected Update FrequencyManual - monthly

Data UpdatesUpdate TypeManual - monthlyUpdate MethodManualUpdate Schedule4th of monthSource Update ScheduleNot specifiedTotal Records At Initial Publish208958

Data DescriptionSingle RowNumber of people employed by year by industry and regionCollection ModeThe Current Employment Statistics Program is a federal-state cooperative program. The CES survey is based on approximately 143,000 businesses and government agencies representing approximately 588,000 worksites throughout the United States.Long DescriptionEmployment estimates as reported by the Current Employment Statistics program, a monthly survey conducted by the Bureau of Labor Statistics. The survey provides employment, hours, and earnings estimates based on payroll records of business establishments. Listed by FIPS code for state and nine (9) Metropolitan Statistical Areas in Colorado from 1990-2014: Pueblo, Fort Collins-Loveland, Colorado Springs, Denver-Aurora, Boulder-Longmont, Grand Junction, Greeley. Data is aggregated to 82 series title code for industry of employment, classified according to the 2012 North American Industry Classification System (NAICS). Employee counts are actual, not in thousands. The CES survey is based on approximately 143,000 businesses and government agencies representing approximately 588,000 worksites throughout the United States. Data produced from the CES survey include nonfarm employment series for all employees, production and nonsupervisory employees, and women employees, average hourly earnings, average weekly hours, and average weekly overtime hours (in manufacturing industries) for all employees, production and nonsupervisory employees.Related DatasetsJoinable to: Employee Counts by Industry in Colorado, Employment Wages in Colorado, Long-Term Employment Projections in Colorado, Personal Income in Colorado, Population Estimates by Year for Counties in Colorado 2015, Short-Term Employment Projections in Colorado, Unemployment Estimates in Colorado based on "areaname"Collection MethodSurveysNewest Record in Dataset2017Oldest Record in Dataset1990Data Collection InstrumentNot specifiedField Names, comma delimitedstateabbrv, statename, stfips, areatyname, areaname, area, periodyear, periodtype, pertypdesc, period, seriescode, seriesttls, seriesdesc, adjusted, benchmark, prelim, empces, empprodwrk, empfemale, hours, earnings, hourearn, supprecord, supphe, supppw, suppfem, hoursallwrkr, earningsallwrkr, hourearnallwrkr, suppheallwrkrDate of Initial Dataset CreationNot specified

Dataset CoverageGranularityNot specifiedUnit of AnalysisTabularGeographic CoverageState

Contributing Agency InformationCitationCDLE - Colorado Department of Labor & EmploymentData SourceNot specifiedAgency Program Pagehttps://www.colorado.gov/cdleAgency Data Series Pagehttps://www.bls.gov/data/

Additional Dataset DocumentationData DictionaryNot specifiedAdditional MetadataNot specifiedTechnical DocumentationNot specified

About

Hours Worked by Employees in Colorado

1 day ago (updated)

5 hours ago (indexed)

Topics