Record Data Format Example

The following example will use the array object pop[recordID,recordFields] which contains population data for North America by country, sex, and time where

recordID is the numerical record id for each line in the database

recordFields is a collection of properties that is created from the selected columns in the database.

The import file may appear as follows:

Country  Sex     Year   Population
Canada   Male    2000   16
US       Female  2002   23
Mexico   Male    2004   12
Canada   Female  2003   14
US       Male    2001   15