Context

The Bureau of Labor Statistics (BLS) is a unit of the United States Department of Labor. It is the principal fact-finding agency for the U.S. government in the broad field of labor economics and statistics and serves as a principal agency of the U.S. Federal Statistical System. The BLS is a governmental statistical agency that collects, processes, analyzes, and disseminates essential statistical data to the American public, the U.S. Congress, other Federal agencies, State and local governments, business, and labor representatives. Source: https://en.wikipedia.org/wiki/Bureau_of_Labor_Statistics

Content

Bureau of Labor Statistics including CPI (inflation), employment, unemployment, and wage data.

Update Frequency: Monthly

Querying BigQuery Tables

Fork this kernel to get started.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:bls

https://cloud.google.com/bigquery/public-data/bureau-of-labor-statistics

Dataset Source: http://www.bls.gov/data/

This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by Clark Young from Unsplash.

Inspiration

What is the average annual inflation across all US Cities? What was the monthly unemployment rate (U3) in 2016? What are the top 10 hourly-waged types of work in Pittsburgh, PA for 2016?

Each month, the Department of Labor (DOL) sends a file via eData which contains changes to the Black Lung payments (updates only). Annually, around the time of the Benefit Rate Increase (BRI), DOL sends an additional saturation file which represents all of their records. These records are matched to the Supplemental Security Income Record (SSR) to update SSI payments or alert the field offices to make changes in the SSI payments.

The Department of Labor (DOL) provides a monthly file through the use of eData which contains the necessary identifying and payment information for all live miners, under age 65, entitled to Part C Black Lung (BL) payments. SSA matches DOL's Part C BL data with SSA's records of persons receiving Social Security disability benefits in order to verify that recipients Social Security disability benefit is properly offset by the Part C BL benefits.

Analysis of ‘Earnings of females and males employees.’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/mpwolke/cusersmarildownloadsearningcsv on 28 January 2022.

--- Dataset description provided by original source is as follows ---

Context

The Bureau of Labor Statistics reported that, in 2013, female full-time workers had median weekly earnings of $706, compared to men's median weekly earnings of $860. Women aged 35 years and older earned 74% to 80% of the earnings of their male counterparts. https://en.wikipedia.org › wiki › Gender_pay_gap_in_the_United_States

Content

What is the gender pay gap 2019? Study after study has identified a persistent gender pay gap. A PayScale report found that women still make only $0.79 for each dollar men make in 2019. A Bureau of Labor Statistics (BLS) analysis discovered that in 2018, median weekly earnings for female full-time wage and salary workers was 81% of men's earnings.Jul 11, 2019 https://www.forbes.com/sites/shaharziv/2019/07/11/gender-pay-gap-bigger-than-you-thnk/#36ca335f7d8a.

Acknowledgements

Linked through data.gov.au for discoverability and availability. This dataset was originally found on data.gov.au https://data.gov.au/data/dataset/a5776c56-bdde-4643-a3fd-dcc2775d7d7a ***Photo by Samantha Sophia on Unsplash.

Inspiration

Great females scientists: Mileva Maric', Frances "Poppy" Northcut, Hedy Lamarr, Marie Sklodowska Curie and Ada Lovelace. If you don't know them yet, just search on Google.

--- Original source retains full ownership of the source dataset ---

Context

The Bureau of Labor Statistics reported that, in 2013, female full-time workers had median weekly earnings of $706, compared to men's median weekly earnings of $860. Women aged 35 years and older earned 74% to 80% of the earnings of their male counterparts. https://en.wikipedia.org › wiki › Gender_pay_gap_in_the_United_States

Content

What is the gender pay gap 2019? Study after study has identified a persistent gender pay gap. A PayScale report found that women still make only $0.79 for each dollar men make in 2019. A Bureau of Labor Statistics (BLS) analysis discovered that in 2018, median weekly earnings for female full-time wage and salary workers was 81% of men's earnings.Jul 11, 2019 https://www.forbes.com/sites/shaharziv/2019/07/11/gender-pay-gap-bigger-than-you-thnk/#36ca335f7d8a.

Acknowledgements

Linked through data.gov.au for discoverability and availability. This dataset was originally found on data.gov.au https://data.gov.au/data/dataset/a5776c56-bdde-4643-a3fd-dcc2775d7d7a ***Photo by Samantha Sophia on Unsplash.

Inspiration

Great females scientists: Mileva Maric', Frances "Poppy" Northcut, Hedy Lamarr, Marie Sklodowska Curie and Ada Lovelace. If you don't know them yet, just search on Google.

The Unemployment Insurance Query (UIQ) provides State Unemployment Insurance agencies real-time online access to SSA data. This includes SSN verification and Title II benefit payment data via the Department of Labor (DOL) ICON Hub.

Context

#TidyTuesday is a weekly data project aimed at the R ecosystem. As this project was borne out of the R4DS Online Learning Community and the R for Data Science textbook, an emphasis was placed on understanding how to summarize and arrange data to make meaningful charts with ggplot2, tidyr, dplyr, and other tools in the tidyverse ecosystem. However, any code-based methodology is welcome - just please remember to share the code used to generate the results.

Content

This data comes from Playbill. Weekly box office grosses comprise data on revenue and attendance figures for theatres that are part of The Broadway League, an industry association for, you guessed it, Broadway theatre.

CPI data is from the U.S. Bureau of Labor Statistics. There are many, many measures of CPI, so the one used here is "All items less food and energy in U.S. city average, all urban consumers, seasonally adjusted" (table CUSR0000SA0L1E).

Acknowledgements

Huge thanks to Alex Cookson who provided ALL of this week's data, cleaning script, and readme! You can check out his recent blog post on the same data here, and explore all of the raw data and other details on Alex's GitHub.

Office of Labor Management and Employee Relations (OLMER ) is proposing that a Labor Relations (LR) Case Tracking System be created to track all LR activities to include; grievances (agency, negotiated, and institutional), arbitrations, unfair labor practices, information requests, MSPB cases, adverse actions and negotiations.

This table contains quarterly and yearly figures on labour participation in the Netherlands. The population of 15 to 74 years of age (excluding the institutionalized population) is divided into the employed labour force, the unemployed labour force and those not in the labour force. The employed labour force is subdivided on the basis of the professional status, and the average working hours. A division by sex, age and level of education is available.

Data available from: 2013

Status of the figures: The figures in this table are final.

Changes as of April 30, 2025: The figures for the 1st quarter 2025 have been added.

Changes as of November 14, 2024: The figures for 3rd quarter 2024 are added. Figures have been added on labor participation based on whether or not the state pension age has been reached.

Changes as of August 17, 2022: None, this is a new table. This table has been compiled on the basis of the Labor Force Survey (LFS). Due to changes in the research design and the questionnaire of the LFS, the figures for 2021 are not automatically comparable with the figures up to and including 2020. The key figures in this table have therefore been made consistent with the (non-seasonally adjusted) figures in the table Arbeidsdeelname, kerncijfers seizoengecorrigeerd (see section 4), in which the outcomes for the period 2013-2020 have been recalculated to align with the outcomes from 2021. When further detailing the outcomes according to job and personal characteristics, there may nevertheless be differences from 2020 to 2021 as a result of the new method.

When will new figures be released? New figures will be published in July 2025.

This table comprises yearly figures on the main aspects of employment, wages and working hours in the Netherlands. The information in this table is classified according to Standard Industrial Classification of all Economic Activities (SIC 2008) and can be broken down into: - employee characteristics (age and sex) - job characteristics (type of employment contract and working hours) - company characteristics (size of the firm and collective wage agreements)

Data available from: 2009.

Status of the figures: Figures for the years 2009 to 2023 are final. Figures for 2024 are provisional.

Changes as of 28 April 2025: Provisional figures for 2024 are added. The figures for 2024 are excluding the selections: ‘Type of employment contract: full-time’, ‘Type of employment contract: part-time’ for the branche ‘P Education’

When will new figures be published? The final figures for 2024 will be published in October 2025.

These criminal justice expenditure and employment (CJEE) data are taken from a special compilation of sources available from the Census Bureau's Annual Surveys of Governments, Finance Statistics and Employment Statistics. Levels of government covered are federal, state, county, municipal, and towns and townships. Information is included on total employment, total police protection, police protection with arrest powers, other police protection, judicial-legal employment, corrections employment, total expenditures, police protection expenditures, judicial-legal expenditures, and corrections expenditures. Types of expenditures include direct current, capital outlay, equipment, and intergovernmental. Types of employment include total, full-time, part-time, and full-time equivalent.

This table contains quarterly and yearly figures on the economic activities where people work. The population of 15 to 74 years of age (excluding the institutionalized population) in paid employment is classified according to the Standard Industrial Classification (SIC 2008). A division by sex, age, level of education, professional status and working hours is available.

Data available from: 2013

Status of the figures: The figures in this table are final.

Changes as of May 8, 2025: The figures for the 1st quarter 2025 have been added.

Changes as of November 15, 2022: In the previous version, the self-employed variable was not published in the personal characteristics dimension for employment status. This has been added in this version.

Changes as of August 17, 2022: None, this is a new table. This table has been compiled on the basis of the Labor Force Survey (LFS). Due to changes in the research design and the questionnaire of the LFS, the figures for 2021 are not automatically comparable with the figures up to and including 2020. The key figures in this table have therefore been made consistent with the (non-seasonally adjusted) figures in the table Arbeidsdeelname, kerncijfers seizoengecorrigeerd (see section 4), in which the outcomes for the period 2013-2020 have been recalculated to align with the outcomes from 2021. When further detailing the outcomes according to job and personal characteristics, there may nevertheless be differences from 2020 to 2021 as a result of the new method.

When will new figures be released? New figures will be published in August 2025.

This table contains the number of unfilled, new and filled vacancies in the government and education. The figures over vacancies are specified to government sector.

This table replaces the StatLine-table Vacancies; government and education 1992-2009. In 2010 the observation is based on the standard industrial classification 2008, SIC2008. Because of this the original figures of the period 1997 up to the second quarter of 2009, all based on SIC 1993, are recalculated to SIC 2008. Therefore these figures can deviate slightly from the figures from the Vacancies; government and education 1992-2009.

Data available since 1997, quarter 1.

Status of the figures: The figures in this table are final.

In the period from the third quarter of 2008 until the fourth quarter of 2009 the job vacancy-survey compiled the job vacancies at the Ministry of Defence according to a different method. Due to this approximately 7 thousand vacancies per quarter have been added to the government. This should be taken into account, when interpreting the results. Because of this extra number of vacancies, the numbers of vacancies, new vacancies and filled vacancies in this period are not completely consistent with the vacancies in the second quarter of 2008 and the first quarter of 2010. The results of this table are including the second quarter of 2009 based on recalculated information on basis of the perception according SBI 2008. Because of this the numbers of vacancies, new vacancies and filled vacancies are in the third quarter of 2009 not completely consistent with the vacancies in the second quarter.

Changes as of 30 April 2025: Figures of the first quarter of 2025 have been added.

When will new figures be published? Figures of the second quarter of 2025 will be published in July 2025.

This table provides information on labour price developments, i.e. the development of wage costs per hour worked by employees, corrected for changes in the personnel structure. The labor price index divides the total increase in wage costs per hour worked into a price component and a structural effect.

Data available from: 2001

Status of the figures: Data from 2001 up to and including 2022 are final. The figures concerning 2023 and 2024 are provisional.

Changes as of January 31st 2025: Compared to the previous version the figures for the reference period '2024 January - 2024 December' are added and the figures are adjusted for the period '2023 October - 2024 September'.

When will new figures become available? New figures are published three to four months after the end of the reference period.