search

labordynamicsinstitute / qwi_schemas

Unofficial LEHD Schema files
https://lehd.ces.census.gov/data/schema/
Creative Commons Zero v1.0 Universal
1 stars 6 forks source link

Clarify contents of variables_qwi*.csv #78

Closed larsvilhuber closed 6 years ago

larsvilhuber commented 6 years ago

There is some hand-curated and manual labor in these files. We are checking to see what the definitive labels should be and how to generate them. This is partially addressed in the discussion in #71

heathhayward commented 6 years ago

Should we call these "variables_qwi.csv" and "variables_qwir.csv" to match the format of j2j?

srt1 commented 6 years ago

We do.

variables_qwi.csv

variables_qwir.csv

I think we're just getting confused in the ticket discussion.

From: heathhayward notifications@github.com Sent: Monday, December 18, 2017 4:45:43 PM To: labordynamicsinstitute/qwi_schemas Cc: Stephen R Tibbets (CENSUS/CES FED); Assign Subject: Re: [labordynamicsinstitute/qwi_schemas] Clarify contents of qwi*_variables.csv (#78)

Should we call these "variables_qwi.csv" and "variables_qwir.csv" to match the format of j2j?

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHubhttps://github.com/labordynamicsinstitute/qwi_schemas/issues/78#issuecomment-352567580, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AVlyoXdCmanAVAgQwt4unxCl5YE_s0zvks5tBt0GgaJpZM4RGHTX.

srt1 commented 6 years ago

The following a comment regarding the "Concept" for J2JOD counts from Erika (see previous discussion in #71)

I don't have a very strong opinion on this, but agree that for the sake of consistency, it would make sense to use either 'hires/separations' or 'flow to employment/flow to nonemployment' for the same types J2J flows on the counts/rates and OD files. It doesn't make much sense to change the concept for the same job move just because on one file we are seeing both origin and destination characteristics of the job move.

Erika

srt1 commented 6 years ago

Reference discussion in #71 regarding the various QWI measures. I believe that most of the questions were resolved, but I think the one last open one was what Concept to apply to the JF/JD/JC family of measures. I suggested "Job Change", which is really shorthand for "Firm Job Change", as these are all establishment growth and decline concepts. Any thoughts on this? (@larsvilhuber )

larsvilhuber commented 6 years ago

"Job flows" would be the correct term for these - "gross job flows" are job creation and destruction, and "net job flows" is it's own variable, the entire class is "Job flows" in the entire economics literature.

-- Lars Vilhuber, Economist Cornell University, Executive Director, Labor Dynamics Institute and ILR School - Department of Economics

e: lars.vilhuber@cornell.edu p: +1.607-330-5743 v: https://cornell.zoom.us/my/larsvilhuber w: http://lars.vilhuber.com/ http://lars.vilhuber.com/

Assistant: ldi@cornell.edu | +1.607-255-2744

GnuPG Fingerprint: 0D7D 527F 9268 F693 74BB A666 FD01 37F0 3362 7346

From: srt1 notifications@github.com Sent: Wednesday, December 20, 2017 11:38:13 AM To: labordynamicsinstitute/qwi_schemas Cc: Lars Vilhuber; Mention Subject: Re: [labordynamicsinstitute/qwi_schemas] Clarify contents of variables_qwi*.csv (#78)

Reference discussion in #71https://github.com/labordynamicsinstitute/qwi_schemas/issues/71 regarding the various QWI measures. I believe that most of the questions were resolved, but I think the one last open one was what Concept to apply to the JF/JD/JC family of measures. I suggested "Job Change", which is really shorthand for "Firm Job Change", as these are all establishment growth and decline concepts. Any thoughts on this? (@larsvilhuberhttps://github.com/larsvilhuber )

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/labordynamicsinstitute/qwi_schemas/issues/78#issuecomment-353114333, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AGsoeJbYtFF4OdpxdbcGbGQlTBcmJdp7ks5tCTf1gaJpZM4RGHTX.

srt1 commented 6 years ago

Fine - will update concept.

From: Lars Vilhuber notifications@github.com Sent: Wednesday, December 20, 2017 11:46:01 AM To: labordynamicsinstitute/qwi_schemas Cc: Stephen R Tibbets (CENSUS/CES FED); Assign Subject: Re: [labordynamicsinstitute/qwi_schemas] Clarify contents of variables_qwi*.csv (#78)

"Job flows" would be the correct term for these - "gross job flows" are job creation and destruction, and "net job flows" is it's own variable, the entire class is "Job flows" in the entire economics literature.

-- Lars Vilhuber, Economist Cornell University, Executive Director, Labor Dynamics Institute and ILR School - Department of Economics

e: lars.vilhuber@cornell.edu p: +1.607-330-5743 v: https://cornell.zoom.us/my/larsvilhuber w: http://lars.vilhuber.com/ http://lars.vilhuber.com/

Assistant: ldi@cornell.edu | +1.607-255-2744

GnuPG Fingerprint: 0D7D 527F 9268 F693 74BB A666 FD01 37F0 3362 7346

From: srt1 notifications@github.com Sent: Wednesday, December 20, 2017 11:38:13 AM To: labordynamicsinstitute/qwi_schemas Cc: Lars Vilhuber; Mention Subject: Re: [labordynamicsinstitute/qwi_schemas] Clarify contents of variables_qwi*.csv (#78)

Reference discussion in #71https://github.com/labordynamicsinstitute/qwi_schemas/issues/71 regarding the various QWI measures. I believe that most of the questions were resolved, but I think the one last open one was what Concept to apply to the JF/JD/JC family of measures. I suggested "Job Change", which is really shorthand for "Firm Job Change", as these are all establishment growth and decline concepts. Any thoughts on this? (@larsvilhuberhttps://github.com/larsvilhuber )

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/labordynamicsinstitute/qwi_schemas/issues/78#issuecomment-353114333, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AGsoeJbYtFF4OdpxdbcGbGQlTBcmJdp7ks5tCTf1gaJpZM4RGHTX.

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHubhttps://github.com/labordynamicsinstitute/qwi_schemas/issues/78#issuecomment-353116605, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AVlyoQKEHK5UqJI4DEvHMgL7dng3O_moks5tCTnJgaJpZM4RGHTX.

srt1 commented 6 years ago

Updated QWI variables tables. I hope.

variables_qwi.csv.gz variables_qwir.csv.gz