Search results for "data updates" ...

• Down and dirty with the DocumentCloud API

  Welsh talks about how the Los Angeles Times uses DocumentCloud. Learn how to use DocumentCloud's API to interact with your documents and how to update or access documents' data with scripting.

  Tags: DocumentCloud; DocumentCloud's API; documents; data; scripting

  By Ben Welsh

  2013

• Investigating Subprime Lending and Foreclosures: HMDA Data

  Thompson describes how to use the federal Home Mortgage Disclosure Act (HMDA) database in order to investigate subprime lending in your community. She explains what fields in the database will reveal subprime lending, and how to use an "update function" to count the subprime loans and apply a demographic element. The tipsheet ends with a list of helpful sources, such as the Consumer Federation of America and the State Licensing Board.

  Tags: foreclosure; subprime lending; data analysis; Microsoft Access; queries

  By Tisha Thompson

  2008

• Center for public integrity policy data accuracy

  Perry shares the Center for Public Integrity's procedures and policies for computer assisted reporting. It addresses data importation, cleaning, coding, updates and fact checking. It is an extensive explanation of CAR methods. Also included is a summary of the methods used for a story about lobbyists providing legislators with free travel.

  Tags: CAR; computer assisted reporting; data; campaign finance; research

  By John Perry

  2006

• Importing HTML tables using Microsoft Excel

  This tipsheet is a step by step guide to importing HTML tables into Microsoft Excel. The author includes screen shots to illustrate each step of the process.

  Tags: internet; data formatting; HTML; spreadsheets; data analysis; importing

  By Ron Nixon (updated by Carolyn Edds)

  2006

• An Indirect Approach to Excel

  This tipsheet is a good guide to using Excel as a way of accessing information in other tables. Schnaars explains how to program Excel to link to information in a different table. That way, information only has to be updated once (in the original table) and you don't waste space copying and pasting the information into new tables.

  Tags: Excel; spreadsheet; data

  By Christopher Schnaars

  2005

• Put searchable and updatable databases on your Intranet with PHP

  Benincasa gives a list of resources and important points about PHP in relation to your newsroom Intranet.

  Tags: None

  By Robert Benincasa

  2004

• Simple FoxPro Programs

  Foxpro programs can be useful, if you know when to use them and how to do them. Sylwester offers up some criteria for when to use programs and provides some examples of programs as well.

  Tags: programs; fox pro; automation; CAR; hands-on; data updates; data cleaning; databases; importing; import

  By Mary Jo Sylwester

  2003

• Redistricting - Winners and Losers

  Hurley Schweers of the National Journal offers helpful links on redistricting. The handout also includes charts based on data from the Census Bureau and the National Conference of States Legislatures.

  Tags: politics; population; legislature; Congress; GOP; Democrats; Republicans

  By Maureen Hurley Schweers

  2002

• Census 2000 two years later: Challenges of the "good stuff"

  Overberg of the USA Today offers tips how to deal with census summaries and multi-directional trends. The handout includes list of online resources for universal topics like segregation, urban sprawl, income inequality and redistricting.

  Tags: minorities; poverty; income; urban development; CAR; data

  By Paul Overberg

  2002

• Updating Tables and String Functions

  This tipsheet outlines the basic techniques for making changes to your data table using the Update Query and String functions. You can split names, convert text fields to date fields, and standardize data.

  Tags: data; Microsoft Access

  By Mary Jo Sylwester

  2002