use google refine to export json

Understanding multi-dimensional arrays

"That's great," you say. "But how can I edit the data to use the really cool Protovis examples?" The answer lies in multi-dimensional arrays. While this may sound intimidating, the concept is straight forward. All it really means is that a data element (the parent) may have subsets (children). 

In this example, race is the parent and the children are Asian, American Indian, etc. This adds a dimension to the array.

data simple

Let's take it a step further and look at race in three different counties in Florida. Now Broward, MiamiDade and Palm_Beach are all parents. And each has children (individual race data). 

data sample medium

Now here's where it gets a bit tricky. Just as in life, children can become parents and have their own offspring. In this example, American Indian is subdivided by the Seminole and Pahokee tribes. This creates another dimension in the array.

data advanced

This example is easy to understand but it's only the beginning. Any child can become a parent with it's own children and add a dimension to the array.