Just to provide some BASIC items of differences on data sources for home/work FLOWS.
ACS and CTPP based on ACS: This is a sample SURVEY of households and household members. The ACS is an address-based sample. The response rate to ACS is lower than to Census 2000 "long form" and the field follow-up for non-respondents to the mail-back form is for a SAMPLE of non-respondents. All the responses are weighted to come up with a total estimate. Respondents are asked to provide their workplace location, which are then geocoded by the Census Bureau. About 25 % of workers do not provide sufficient information to code to a census block and their workplace is imputed using a routine using 4 variables: industry, occupation, travel mode and travel speed. See the recent CTPP Status Report article by Melanie Rapino on the details of the imputation process.
LEHD: is from ADMINISTRATIVE records, based on Employment Security (unemployment), and augmented with federal employment records. The base is from files submitted to the Census Bureau from State Departments of Employment Security who maintain the QCEW files (formerly called ES-202). LEHD does not currently include self-employed, or military employment. In this case, the workplace location is the address(es) provided by businesses. If the business has multiple locations in a county, many states require that each location be reported. Only in Minnesota is the employee record tied to a specific workplace location. That is, in all other states, for businesses with multiple sites, the link between an employee's home location and the workplace location is imputed. That is, an algorithm selects among the multiple worksites which is the most likely workplace for that worker. The home location may be moved to protect individual confidentiality, but largely the moves are within the same census tract. The link between the unemployment (QCEW) and home location is primarily from IRS tax records, using an encrypted version of SSN.
Sometimes people use a different home address for IRS than where they are actually living, for example young people or college students may use their parents' address. And similarly, sometime people report on the ACS form a workplace location where they may not actually be working, for example, a construction worker might report the business address of his employer. So, there is plenty of room for inconsistencies.
Private lists of businesses and employment totals: Typically these are compiled using web resources and telephone surveys. Often the list guarantees that each business has been contacted within 3 (or 5) years to get the most current employment figures. Because these firms have been compiling these lists and checking them for so many years, they have been able to refine their databases. However, these lists do not provide FLOW between work and home, just workplace location totals.
Please let me (and the listserv) know if I have made any mistakes above.
Elaine Murakami
________________________________________
From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of hprawiranata mitcrpc.org [hprawiranata(a)mitcrpc.org]
Sent: Friday, March 08, 2013 11:49 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] Commuter Flow Data Concerns
Thanks, Ed.
I have been working LEHD data for 2 weeks and comparing it with other
sources (REMI, Claritas, WP, etc). All sources has different number
for 2010, for example, which one is the good one ? LEHD has all jobs,
primary jobs, private jobs, etc. I found the use primary job data give
close number with other sources, am I on the right track ?
I have not compared LEHD data with 'just released' commuting data set,
I guess it would be the same and LEHD has better resolution. What do
you think ?
Thanks,
Hary
On Fri, Mar 8, 2013 at 10:22 AM, Ed Christopher <edc(a)berwyned.com> wrote:
> A few of us have been getting calls and emails from people who have been
> looking at the commuter follow data the Census Bureau just released, the
> On the Map (LEHD) and some of the earlier flow data. If you have, you
> probably noticed some interesting (or maybe wierd) things. Needless to
> say a good understanding of the data is needed to sort out some of the
> issues. Below are some references and points that may be of interest.
> What are people noticing with the data?
> ---------------
> In the January 20011 Status Report newsletter there is an article from
> the NY State DOT by the late Nathan Erlbaum which discusses the issues
> surrounding the various flow data sets. The article “Commutation Flow:
> CTPP 2000, ACS and CTPP, and LEHD-OTM” can be found at
> http://www.trbcensus.com/newsltr/sr0111.pdf (starting on page 6). In it
> is a link to a larger body of work that Nathan did on the topic. a read
> of this is must if you are having questions about the data.
>
> Regarding the LEHD and CTPP flow data, there is an NCHRP report that has
> been completed that is also worth reviewing. It gets into detail about
> some of the differences between the two data sets. It can be found at
> http://onlinepubs.trb.org/onlinepubs/nchrp/docs/NCHRP08-36%2898%29_FR.pdf
>
> Elaine Murakami reminds me that
> 1. LEHD does not include self-employed (approx. 10%)
> 2. LEHD only recently included federal workers, but does not include
> MILITARY
> 3. LEHD is jobs and ACS is "workers at work".
>
> Periodically issue like this pop up and there is a discussion on the
> list serve. there is an archive but off course it takes some time to
> mine and search through. If anyone is interested in looking through it,
> it is open to the public and available at
> http://www.chrispy.net/pipermail/ctpp-news/. There was a discussion
> around august of 2010 dealing with flow data but it centered more on
> availability.
>
> Hope this helps.
> --
> Ed Christopher
> 708-283-3534 (V)
> 708-574-8131 (cell)
>
> FHWA RC-TST-PLN
> 4749 Lincoln Mall Drive, Suite 600
> Matteson, IL 60443
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.nethttp://ryoko.chrispy.net/mailman/listinfo/ctpp-news
Hi, Hary
If you compare LEHD with commuting data, you may want to know that commuting data is only workers at work, which excludes workers on vacation, sick leave etc (approximately 1 or 2 pct).
The following article "CTPP Workers-at-Work Compared to Other Employment Estimates" maybe helpful if you try to compare ACS employment data with other sources. Although the article is about CTPP 2000 (Decennial long forms), but they can be applied to ACS as well.
http://www.fhwa.dot.gov/planning/census_issues/ctpp/status_report/sr0104.cfm
Liang
________________________________________
From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of hprawiranata mitcrpc.org [hprawiranata(a)mitcrpc.org]
Sent: Friday, March 08, 2013 2:49 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] Commuter Flow Data Concerns
Thanks, Ed.
I have been working LEHD data for 2 weeks and comparing it with other
sources (REMI, Claritas, WP, etc). All sources has different number
for 2010, for example, which one is the good one ? LEHD has all jobs,
primary jobs, private jobs, etc. I found the use primary job data give
close number with other sources, am I on the right track ?
I have not compared LEHD data with 'just released' commuting data set,
I guess it would be the same and LEHD has better resolution. What do
you think ?
Thanks,
Hary
On Fri, Mar 8, 2013 at 10:22 AM, Ed Christopher <edc(a)berwyned.com> wrote:
> A few of us have been getting calls and emails from people who have been
> looking at the commuter follow data the Census Bureau just released, the
> On the Map (LEHD) and some of the earlier flow data. If you have, you
> probably noticed some interesting (or maybe wierd) things. Needless to
> say a good understanding of the data is needed to sort out some of the
> issues. Below are some references and points that may be of interest.
> What are people noticing with the data?
> ---------------
> In the January 20011 Status Report newsletter there is an article from
> the NY State DOT by the late Nathan Erlbaum which discusses the issues
> surrounding the various flow data sets. The article “Commutation Flow:
> CTPP 2000, ACS and CTPP, and LEHD-OTM” can be found at
> http://www.trbcensus.com/newsltr/sr0111.pdf (starting on page 6). In it
> is a link to a larger body of work that Nathan did on the topic. a read
> of this is must if you are having questions about the data.
>
> Regarding the LEHD and CTPP flow data, there is an NCHRP report that has
> been completed that is also worth reviewing. It gets into detail about
> some of the differences between the two data sets. It can be found at
> http://onlinepubs.trb.org/onlinepubs/nchrp/docs/NCHRP08-36%2898%29_FR.pdf
>
> Elaine Murakami reminds me that
> 1. LEHD does not include self-employed (approx. 10%)
> 2. LEHD only recently included federal workers, but does not include
> MILITARY
> 3. LEHD is jobs and ACS is "workers at work".
>
> Periodically issue like this pop up and there is a discussion on the
> list serve. there is an archive but off course it takes some time to
> mine and search through. If anyone is interested in looking through it,
> it is open to the public and available at
> http://www.chrispy.net/pipermail/ctpp-news/. There was a discussion
> around august of 2010 dealing with flow data but it centered more on
> availability.
>
> Hope this helps.
> --
> Ed Christopher
> 708-283-3534 (V)
> 708-574-8131 (cell)
>
> FHWA RC-TST-PLN
> 4749 Lincoln Mall Drive, Suite 600
> Matteson, IL 60443
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.nethttp://ryoko.chrispy.net/mailman/listinfo/ctpp-news
Please keep your eyes out for this and let us all know what you
think...It looks to be based on migration flows but who knows someday it
might grow to consider commuter flows.
-------
American Community Survey
2006-2010 County-to-County Migration Flows Mapper Tool and 2006-2010
County-to-County Characteristics Migration Tables — Based on data
collected during the American Community Survey from 2006 to 2010, the
county-to-county migration tables give added information on the paths of
the 17.3 million people who moved to another county. The tables provide
the current county of residence, the county of residence one year ago
and the estimated number of movers between the counties. Additional
tables provide the same information broken down by selected
characteristics: age, sex, race or Hispanic origin.
The Census Bureau has developed its first beta version of an online
mapping tool called Census Flows Mapper. It is an interactive
application that allows users to select a county in the U.S. and view
the outbound, inbound and net migration flows for that county.
Additionally, users can choose flows based on characteristics such as
age, sex, race or Hispanic origin. The application also allows users to
download the data for the flow they have selected, zoom in and out on
the map to an area of interest, view additional statistics of the
selected county and print their map to a PDF file. (Scheduled for
release March 19.)
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
A few of us have been getting calls and emails from people who have been
looking at the commuter follow data the Census Bureau just released, the
On the Map (LEHD) and some of the earlier flow data. If you have, you
probably noticed some interesting (or maybe wierd) things. Needless to
say a good understanding of the data is needed to sort out some of the
issues. Below are some references and points that may be of interest.
What are people noticing with the data?
---------------
In the January 20011 Status Report newsletter there is an article from
the NY State DOT by the late Nathan Erlbaum which discusses the issues
surrounding the various flow data sets. The article “Commutation Flow:
CTPP 2000, ACS and CTPP, and LEHD-OTM” can be found at
http://www.trbcensus.com/newsltr/sr0111.pdf (starting on page 6). In it
is a link to a larger body of work that Nathan did on the topic. a read
of this is must if you are having questions about the data.
Regarding the LEHD and CTPP flow data, there is an NCHRP report that has
been completed that is also worth reviewing. It gets into detail about
some of the differences between the two data sets. It can be found at
http://onlinepubs.trb.org/onlinepubs/nchrp/docs/NCHRP08-36%2898%29_FR.pdf
Elaine Murakami reminds me that
1. LEHD does not include self-employed (approx. 10%)
2. LEHD only recently included federal workers, but does not include
MILITARY
3. LEHD is jobs and ACS is "workers at work".
Periodically issue like this pop up and there is a discussion on the
list serve. there is an archive but off course it takes some time to
mine and search through. If anyone is interested in looking through it,
it is open to the public and available at
http://www.chrispy.net/pipermail/ctpp-news/. There was a discussion
around august of 2010 dealing with flow data but it centered more on
availability.
Hope this helps.
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
I have spent a bunch of time downloading these new tables and extracting
the Michigan sections of each.
Imagine my surprise to find that in tables labeled County-MCD, there *are
no MCD data for Michigan!! *I guess there are MCD data only for the New
England states. I need Detroit!!
I surmise that the reason for this is that the only purpose of this data
set is to redefine MSAs; in fact, that's why it's on the Metropolitan
section of the census web site.
When do I get flows for Detroit and the counties of the Detroit MSA?
Patty Becker
--
Patricia C. (Patty) Becker
APB Associates/Southeast Michigan Census Council (SEMCC)
28300 Franklin Rd, Southfield, MI 48034
office: 248-354-6520
home:248-355-2428
pbecker(a)umich.edu
FOR IMMEDIATE RELEASE: THURSDAY, MARCH 7, 2013
“A Look at Commuting Patterns in the United States” Live on “America by
the Numbers” Segment of C-SPAN’s “Washington Journal”
More than one quarter of all U.S. workers live in a different county
than where they work. Find out more on Friday, March 8, 2013, at
approximately 9 a.m. EDT as Brian McKenzie — an analyst in the Social,
Economic and Housing Statistics Division at the U.S. Census Bureau —
discusses the latest data from the Census Bureau. Each Friday, C-SPAN’s
“America by the Numbers” segment features information from the federal
statistical system. The program highlights the trends and allows the
public to call in or email their views. More information on previous
C-SPAN programs is available at <http://www.census.gov/newsroom/cspan/>.
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
Just in case you missed it. Yesterday the Census Bureau put out several
journey to work data products. (Accept my apologies for cross-posting)
---------------
U.S. Census Bureau Releases American Community Survey (ACS) 2006-10
County-to-County Commuting Flows Products
We are pleased to announce the release of the ACS 2006-10
County-to-County Commuting Flow estimates. Though regularly produced
commuting data products address where people work and where people live,
these flow products uniquely describe the residence to workplace
relationship.
The ACS 2006-10 County-to-County commuting flows datasets can be found
on our Metropolitan and Micropolitan Statistical Areas page
(http://www.census.gov/population/metro/data/other.html).
An accompanying analysis paper, County-to-County Commuting Flows:
2006-10, is available on our Commuting (Journey to Work) page. 2011 and
a working paper and poster that explore Mega Commuting in the
U.S.(http://www.census.gov/hhes/commuting/)
The ACS provides reliable statistics that are indispensable to anyone
who has to make informed decisions about the future. These statistics
are required by all levels of government to manage or evaluate a wide
range of programs, but are also useful for research, education,
journalism, business and advocacy. If you have questions about this
survey, please call our Customer Services Center on 1 (800) 923-8282.
Thank you,
American Community Survey Office
U.S. Census Bureau
----------------
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
Apologies to all.
Meant to forward to folks in-house.
Hit "send" before changing the "recipients" field.
Chuck Imbrogno
-----Original Message-----
From: Chuck Imbrogno
Sent: Monday, March 04, 2013 4:11 PM
To: 'ctpp-news(a)chrispy.net'
Subject: RE: [CTPP] Census Bureau News -- Census Bureau Media Advisory
Commuting Products to be Embargoed
Shannon, Chuck:
FYI - See bottom of this e-mail chain for the "Media Advisory" from the
Census Bureau regarding the Commuter Flow data that Tom Fontaine asked
about earlier today. Data was "embargoed" by the Census Bureau.
Available to the media at noon today, but not released publicly to
everyone else (including us) until midnight tonight.
Bob Schwartz should be downloading the file sometime in the morning.
Chuck Imbrogno
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net
[mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Graham, Todd
Sent: Friday, March 01, 2013 7:32 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] Census Bureau News -- Census Bureau Media Advisory
Commuting Products to be Embargoed
Census Bureau wil be releasing data and reports on commuting patterns
next week.
If you have Census PIO embargo access, you'll be able to dig into it as
early as Monday afternoon.
This is a new product -- so I'm not sure how the data will be structured
-- anyone know?
Enjoy.
--Todd Graham
Metropolitan Council Research
________________________________________
From: U.S. Census Bureau [census(a)subscriptions.census.gov]
Sent: Friday, March 01, 2013 9:54 AM
Subject: Census Bureau News -- **Census Bureau Media Advisory**
Commuting Products to be Embargoed
FOR IMMEDIATE RELEASE: FRIDAY, MARCH 1, 2013
Public Information Office
CB13-39
301-763-3030
email: <pio(a)census.gov>
***CENSUS BUREAU MEDIA ADVISORY***
Commuting Products to be Embargoed
The U.S. Census Bureau's Public Information Office will offer an embargo
period next week for members of the media to view a series of commuting
products. Statistics will be available for every county in the U.S.
showing the number of workers that commute in or out and which counties
those commuters travel to and from. Additional reports and tables, based
on statistics from the American Community Survey, examine U.S. residents
traveling across county and state lines to work. Specifically, the
products present U.S. workers who have commutes of 60 minutes or longer
and workers who have "mega commutes" of at least 90 minutes and 50
miles. Statistics will also be available for every county in the U.S.
that show the number of workers that commute into or out of the county
and which counties those commuters travel to and from.
The reports and tables will be posted to the Census Bureau's embargo
site at noon EST Monday, March 4. The public release will be at 12:01
a.m. EST Tuesday, March 5. Wire and distribution services are prohibited
from distributing embargoed news releases and data files to subscribers
before the public release date and time.
If you are interested in scheduling a radio interview on Tuesday, March
5, please contact the U.S. Census Bureau Public Information Office at
301-763-3030.
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.nethttp://ryoko.chrispy.net/mailman/listinfo/ctpp-news
Census Bureau wil be releasing data and reports on commuting patterns next week.
If you have Census PIO embargo access, you'll be able to dig into it as early as Monday afternoon.
This is a new product -- so I'm not sure how the data will be structured -- anyone know?
Enjoy.
--Todd Graham
Metropolitan Council Research
________________________________________
From: U.S. Census Bureau [census(a)subscriptions.census.gov]
Sent: Friday, March 01, 2013 9:54 AM
Subject: Census Bureau News -- **Census Bureau Media Advisory** Commuting Products to be Embargoed
FOR IMMEDIATE RELEASE: FRIDAY, MARCH 1, 2013
Public Information Office CB13-39
301-763-3030
email: <pio(a)census.gov>
***CENSUS BUREAU MEDIA ADVISORY***
Commuting Products to be Embargoed
The U.S. Census Bureau’s Public Information Office will offer an embargo period next week for members of the media to view a series of commuting products. Statistics will be available for every county in the U.S. showing the number of workers that commute in or out and which counties those commuters travel to and from. Additional reports and tables, based on statistics from the American Community Survey, examine U.S. residents traveling across county and state lines to work. Specifically, the products present U.S. workers who have commutes of 60 minutes or longer and workers who have “mega commutes” of at least 90 minutes and 50 miles. Statistics will also be available for every county in the U.S. that show the number of workers that commute into or out of the county and which counties those commuters travel to and from.
The reports and tables will be posted to the Census Bureau’s embargo site at noon EST Monday, March 4. The public release will be at 12:01 a.m. EST Tuesday, March 5. Wire and distribution services are prohibited from distributing embargoed news releases and data files to subscribers before the public release date and time.
If you are interested in scheduling a radio interview on Tuesday, March 5, please contact the U.S. Census Bureau Public Information Office at 301-763-3030.
Hi, All
Our Census Bureau friend, Brian McKenzie told us that OMB released the
metro/micro areas late last week. The new definitions' link
http://www.whitehouse.gov/omb/bulletins_default .
The new 2006-2010 county worker flows will come out tomorrow some time.
Enjoy!
Liang Long
Cambridge Systematics, Inc.
4800 Hampden Lane
Suite 800
Bethesda, MD 20814
tel 301 347 0100
fax 301 347 0101
FHWA 202-366-6971
e-mail llong(a)camsys.comwww.camsys.com