L.A. MIGRAHACK

The Event


Welcome to the L.A. Migrahack This wiki is for the event. We'll be posting more information on the logistics soon, so please check back often. Everyone is free to use the wiki to prepare for the contest, contribute ideas, find teammates and so on. During the hackathon, we'll be using the wiki to post projects for the judging panel to evaluate and the general public to see.

WINNING TEAMS AND PROJECTS

TEAM MISSING MIKE
1st Place Winning Team

Looking at immigration through permanent residency networks

flickr:8261219231flickr:8261136761flickr:8261135833
http://alexleavitt.com/lahack/

Team: Alex Leavitt & Ashley Seto
Description: The project looks at the global connections underlying immigration in the US. We looked at open government data about legal permanent residents (those getting their green cards), and we mapped the countries of the recipients to each US state that awarded them. By looking at these connections, you can see how various immigrant communities are awarded resident status and how those communities vary in each state to map out the immigrant fabric underlying American culture more broadly. To illustrate the connections, we constructed an interactive network graph that shows state-country connections and paired this network with a global map.

TEAM LOONEY TUNES
2nd Place Winning Team

Three Ways To Measure Latinos' Health In Los Angeles County

flickr:8260977151

http://www.lamigrahack.friendfail.com/diabetes.html

This interactive map allows users to see which areas of Los Angeles County have the highest and lowest rates of diabetes and obesity among Latinos, as well as which areas have the highest and lowest life expectancies among Latinos.

The data comes from 2005 and 2007 surveys conducted by the County of Los Angeles Public Health Department and is publicly available on their site (http://dqs.hasten.ladhs.org/default.aspx). The data is organized by "health district" — regions created by the health department based on 2000 census tracts — and layered across a map of Los Angeles County.

Team members: Cesar Arredondo, Richard Busby, Chris Keller and Anna Almendrala

ONE MILLON
Reporter best insight Winning Team

Each year, the U.S. issues about 1 million green cards to immigrants from more than 200 nations. Click on a country to see how many of its citizens have been granted residency through family sponsorship and how long they waited for their legal documents.

flickr:8262037572

Link: http://1000000immigrants.tk/

Team members:
Adelaide Chen
@adelaide_chen
Sireen O'Mari
moc.liamg|enneereS#moc.liamg|enneereS
Matt Glass
moc.mwsog|ttam#moc.mwsog|ttam
Sandra Baltazar Martinez
moc.ep|zenitrams#moc.ep|zenitrams

TEAM AVANGERS

Possible Causes of for Internal Migration of Undocumented People

flickr:8260921231
http://pydanny.com/result-of-our-la-migration-hackathon-submission.html

Our concept was to measure the effect of changing immigrant laws per state compared to income differences between regions. We present three embeddable charts that demonstrate this impact over time that represent financial, census, and legal data over a Map of the United States. We ask that users of this data (provided by US Census, Pew Institute, and the Bureau of Economic Impact) draw their own conclusions from this data

Future plans:

Charts and data will be on their own site with full accreditation of sources.
Current charts will be combined into one chart for better understanding of data

Team members:
Carlos Hernandez
Rachel Estabrook
Scott Smith
Agustin Duran
Daniel Greenfeld

TEAM COYOTE

Introducing the how to guide for crossing the U.S.A border

flickr:8262013562
URL: http://illegalimmigrationguide.com/

Team Members
Audrey Roy
Ruxandra Guidi
Monica Curca
Roberto Guerra

TEAM DFNDR

Dashboard to monitor, report, and predict human trafficking patterns.

flickr:8262002870
Link to project files
https://github.com/JGallardo/dfndr

Link to live site
dfndr.agavefarm.com

Team Members
Designer / Frontend Developer - Juan Gallardo - em.odrallagj|j#em.odrallagj|j
Journalist / Researcher - Bertha Del Rivero - moc.liamg|orevirledb#moc.liamg|orevirledb
Journalist / Researcher - Daniel Morales - moc.aidemzipat|selaromleinad#moc.aidemzipat|selaromleinad
Journalist / Researcher - Maria Del Rosario Burgueo - moc.liamg|seugruboirasor#moc.liamg|seugruboirasor
Journalist / Researcher - Maria Luisa Arredondo - moc.ainrofilaconital|odnoderralm#moc.ainrofilaconital|odnoderralm

THE SURVIVORS

Hispanic grandparents living with their grandchildren in the biggest counties in CA.

flickr:8262023294

Project Link on Fusion Tables:
https://www.google.com/fusiontables/DataSource?docid=1-IECKAaZuIIpsUQ9FJLLFqleEgv3rrBAnsJe-Kw

Team Members:
German Sierra (moc.liamtekcor|arreis_namreg#moc.liamtekcor|arreis_namreg)
Edwin Tamara (gro.pa|aramate#gro.pa|aramate)
Dawn Page (moc.liamg|egapnwadrp#moc.liamg|egapnwadrp)
Gil Santana (moc.anatnaslig|lig#moc.anatnaslig|lig)

Logistics


The Venue:
La Opinión
700 S. Flower St. Ste. 3100
Los Angeles, California 91007
Please, plan to arrive around 9:00am on Saturday for breakfast and registration

Agenda


  • Saturday, December 8th, 2012

9:00am-10:00am Breakfast and Registration for the Workshops

10:00am-10:30am Opening Remarks

10:30am–12:15pm Census Database Training For Journalists: Resources, findings and methods related to Census 2010 and American Community Survey.

10:30am- 11:15am Column Five Infographics: Importance of data visualization, highlighting best practices and common errors in data visualization.

10:30am–11:15am Capture high quality video on your mobile phone.

11:20am–12:15pm Mapduh, learn how to take location content, photos and videos and organize them on a map!

11:20am–12:15 pm Data mining, find the story behind the numbers. Come and learn some advanced Excel functionality including pivot tables, formulas, and custom macros.

11:20am–12:15 pm Hands-on Twitter for journalists. New and helpful ways on how to use Twitter. Do’s and Dont’s in Tweeting.

BREAK FOR LUNCH

1:00pm-2:00pm Citizen Journalism Forum:
* Start your own blog or website (Beginners)
* DataViz Fundatmetals: A practical guide to designing with Data and open software
* US Treamtv. Learn how to put the #1 live broadcast company to work for you and your newsroom.

2:00-5:00pm Google Data Boot Camp: Use Google Fusion tables, Google Map and G-Refine, among other free online tools and ultimately, craft narratives around your data, to find and tell the 'human story' behind the numbers.

5:00pm MIXER: The LA Hackathon on Immigration begins! Developers meet your LAmigrahack fellows and start your engines to fuel one project to hack together. Complete your work by 4:00pm Sunday the 9th and present it to the judges and other LAmigrahack teams.
Team Development: We will be forming the teams during the mixer as well as the topic to hack.

  • Sunday, December 9th, 2012

9:00-10:00am Breakfast. You can start working any time after 9:00 am

3:30pm Prepare for Presentations

4:00pm Project Demonstrations

5:00pm Judges Announce Winners.

5:30pm Dinner

Prizes


1st Place Winning Team: $1,000.
2nd Place Winning Team: A total of $300 in Gift Cards.
Reporter best insight: Smartphone with 3 months of free service.

Prize Criteria


For Best Data Visualization Project Category:
Innovative/Informative: How innovative is the product you have developed. Impact of your discovery. Complexity of the analysis. Scope of your discovery
Design: We will look at the interactivity, easy updates and simple manipulation.
Interactivity: This would allow users to explore the data as they would like
Simple Manipulation: Project that allow users to manipulate and mash data.
The project has to have the ability to be embedded into any web page and it will open source

For Best Reporter Idea with Data and Best Insight Category:
• Impact of your discovery
• Complexity of the analysis
• Scope of your discovery

Judges


Beth Barrett, Investigative reporter and treasurer of the LA Press Club

Ronald Campbell, investigative reporter at The Orange County Register.

Hector Galvan, Regional Multicultural Marketing Manager at Sprint

Phuong Ly, Executive Director of Institute for Justice and Journalism

Pervez Sikora, Chief Technology Officer at ImpreMedia

Tools


Everyone is welcome to use any tools and methods: from basic functions in a spreadsheet to the latest machine learning algorithms.

Data


Economic data, immigrants’ remittances, which you can download in bulk, excel format, and it covers 1970 -> 2010
http://data.worldbank.org/data-catalog/migration-and-remittances

Number of international migrants and refugees between 1960 and 2010 at the global, regional, and country levels.
http://esa.un.org/migration/index.asp?panel=1

Number of Foreign Born by State, Percent Foreign Born by State, Numeric Difference in the Foreign Born by State and Percent Change in the Foreign Born by State (1990, 2000, and 2010)
http://www.migrationinformation.org/DataHub/acscensus.cfm

Data on Victims of Trafficking in Person and Victims of Crime
http://www.uscis.gov/portal/site/uscis/menuitem.eb1d4c2a3e5b9ac89243c6a7543f6d1a/?vgnextoid=9c45211f28ff0310VgnVCM100000082ca60aRCRD&vgnextchannel=9c45211f28ff0310VgnVCM100000082ca60aRCRD

http://www.ungift.org/doc/knowledgehub/resource-centre/IOM-Global-Trafficking-Data-on-Assisted-Cases-2012.pdf

2011 Job Patterns for Minorities and Women in Private Industry (EEO-1)
Raw Datasets
http://www.eeoc.gov/eeoc/statistics/employment/jobpat-eeo1/2011/datasets.cfm

Raw Data Immigration
https://explore.data.gov/catalog/raw?q=immigration&sortBy=relevance

Tables that provides data on foreign nationals who were granted lawful permanent residence, applied for asylum or refugee status, or were naturalized.
http://www.dhs.gov/yearbook-immigration-statistics

Noncitizens SSA Recipients, by eligibility category, December 1982–2011
http://www.ssa.gov/policy/docs/statcomps/ssi_asr/2011/index.html

Number of Service members by Gender, Race, Branch
https://explore.data.gov/Population/Personnel-Trends-by-Gender-Race/zqae-ad8k

Farmers Markets Geographic Data longitude and latitude, state, address, name, and zip code of Farmers Markets in the United States
http://www.ams.usda.gov/AMSv1.0/farmersmarkets
https://explore.data.gov/Agriculture/Farmers-Markets-Geographic-Data/wfna-38ey

SOI Tax Stats - Free Migration Data Downloads
http://www.irs.gov/uac/SOI-Tax-Stats---Free-Migration-Data-Downloads

Aliens Removed or Returned: Fiscal Years 1892 to 2011
http://www.dhs.gov/sites/default/files/publications/immigration-statistics/table39.xls

Aliens Removed by Criminal Status and Region and Country of Nationality: Fiscal Years 2002 to 2011
http://www.dhs.gov/sites/default/files/publications/immigration-statistics/table41d.xls

Language Assistance Program June 2012, each person who files bankruptcy is required to attend a meeting of creditors and respond to questions under oath from the trustee and creditors if a participant (debtor or creditor) has limited English proficiency, an interpreter is provided free of charge via a conference phone
http://www.justice.gov/ust/eo/public_affairs/data_files/lap/

Enforcement & Compliance History Online (ECHO)
The ECHO Exporter provide a download for more than half a million regulated facilities in one zip file. There up to 85 data fields available for each facility, including the frequency of inspections, violations, actions, and penalties. The file includes Clean Air Act, Clean Water Act, Resource Conservation and Recovery Act and other data, such Toxics Release Inventory releases, industry codes, and permit types. Also included is the latitude/longitude information — which will allow users to integrate facility locations into maps, mobile apps, and third party websites.
http://www.epa-echo.gov/echo/idea_download.html

Migration Policy Institute Data Hub
Provides accessible, up-to-date immigration statistics, maps, and numbers for the United States and other countries. Find where immigrants live in the United States; the amount of remittances sent to other countries; and the top global destinations for immigrants.
http://www.migrationpolicy.org/datahub

Campaign finance data is available for the last 33 years, going back to 1979. The files and their descriptions are available on FEC's website(Note, however, that the raw data is quite difficult to parse. See Influence Explorer, below, for the same data in more accessible formats.)
Influence Explorer contains a wide variety of influence-related datasets, including federal and state campaign finance, lobbying, federal spending, various enforcement datasets and more. Raw data can be searched and downloaded in Excel format from data.influenceexplorer.com or downloaded in bulk CSVs from
data.influenceexplorer.com/bulk/
Census Bureau
Census Historical Files
Follow the Money.org National Institute on Money in State Politics
Bureau of Labor Statistics
http://www.osha.gov/oshstats/index.html

Work on data done by others previously

———
FOR MORE EXAMPLES GO TO:
https://docs.google.com/folder/d/0B4JHpEn2Xyf6TVFsRGdpNFhFdFU/edit?docId=15RbFZMIJFzibjuc1dzH2LRUJRsz9Vbz8SacEI5WsA9M

Remittance flows
http://www.torre.nl/remittances/

flickr:8172607057

Almost 216 million people live outside their countries
flickr:8172607601

Voting Rights: Election Counties Required to Provide Spanish
http://newamericamedia.org/2012/11/adelaide-chen.php
flickr:8172636504

Project Ideas

———
FOR MORE PROJECT IDEAS GO TO:
https://docs.google.com/folder/d/0B4JHpEn2Xyf6TVFsRGdpNFhFdFU/edit?docId=0AoJHpEn2Xyf6dHFjcWRHdDVNVHM2MGwxNE9FQ0RxcFE

  • Participation rates of low-income immigrants in publicly subsidized home energy efficiency programs.
  • Immigration & academic achievements.
  • Immigration and projection of voter demo.
  • Twitter ideas for emergency situations.
  • Immigration & health care.
  • Comparing immigrants and US born citizen figures on welfare.
  • Mapping the flow of undocumented immigration and overlay of hate groups to see if there is a correlation.
  • Hate crimes in South East Los Angeles.
  • Obesity and immigrants in Los Angeles.
  • Transportation among immigrants in LA.
  • Children of immigrants who benefited from the 1986 amnesty.
  • Border Patrol violence, especially in response to alleged rock-throwing.

Project Submission Guidelines


By midnight Saturday, Dec. 8th:

Please create a page for your project or team in "Projects & Teams" section of this page. Include the following information:
Your project or team name.
A brief description of what you are working on.
A list of people on the team.
What prize category you think your project fits in.
What you are starting with: existing codebase, libraries, etc.

By 3:00 pm Sunday, Dec. 9th:

Please add to your page the following information:
A brief summary of your work.
A step-by-step explanation of how you reached the result(s). Screenshots will be much appreciated.
Any links such as to a code repository, Google docs, etc.

Comments & Questions

moc.kooltuo|xoVataDR#moc.kooltuo|xoVataDR


Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License