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
American Indian, etc. This adds a dimension to the array.
Let's take it a step further and look at race in three different counties in Florida. Now
Palm_Beach are all parents. And each has children (individual race data).
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
Pahokee tribes. This creates another dimension in the array.
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.