opengovernment/opengovernment-app — pull request #1 by rchekaluk (2013-06-07 13:53:30+00:00)
Title: Initial rake tasks openstates:json:download and openstates:json:update

Note that this imports a slightly different schema from the BSON imports, not sure of the application impact:

Here is a sample committee imported from JSON:
> db.committees.findOne();
{
"_id" : ObjectId("51b0b0f95a9e87016cc4603e"),
"committee" : "Aging",
"level" : "state",
"country" : "us",
"created_at" : "2011-05-05 01:30:48",
"updated_at" : "2013-06-01 16:29:12",
"chamber" : "upper",
"state" : "ny",
"sources" : [
{
"url" : "http://www.nysenate.gov/committee/aging"
}
],
"parent_id" : null,
"members" : [
{
"leg_id" : "NYL000001",
"role" : "chair",
"name" : "Sen. Eric Adams"
},
{
"leg_id" : "NYL000001",
"role" : "member",
"name" : "Eric Adams"
},
{
"leg_id" : "NYL000002",
"role" : "member",
"name" : "Joseph P. Addabbo Jr"
},
{
"leg_id" : "NYL000004",
"role" : "member",
"name" : "Tony Avella"
},
{
"leg_id" : "NYL000010",
"role" : "member",
"name" : "Ruben Diaz"
},
{
"leg_id" : "NYL000229",
"role" : "member",
"name" : "Simcha Felder"
},
{
"leg_id" : "NYL000019",
"role" : "member",
"name" : "Martin J. Golden"
},
{
"leg_id" : "NYL000032",
"role" : "member",
"name" : "Kenneth P. LaValle"
},
{
"leg_id" : "NYL000235",
"role" : "member",
"name" : "Kathleen A. Marchione"
},
{
"leg_id" : "NYL000058",
"role" : "member",
"name" : "Toby Ann Stavisky"
},
{
"leg_id" : "NYL000060",
"role" : "member",
"name" : "David J. Valesky"
},
{
"leg_id" : "NYL000062",
"role" : "member",
"name" : "Lee M. Zeldin"
}
],
"id" : "NYC000001",
"subcommittee" : null
}

Here is a sample committee document imported from BSON:
> db.committees.findOne( { _id: "NYC000001" } );
{
"_id" : "NYC000001",
"_type" : "committee",
"committee" : "Aging",
"_all_ids" : [
"NYC000001"
],
"country" : "us",
"created_at" : ISODate("2011-05-05T01:30:48.059Z"),
"level" : "state",
"updated_at" : ISODate("2013-03-02T14:00:20.201Z"),
"chamber" : "upper",
"state" : "ny",
"sources" : [
{
"url" : "http://www.nysenate.gov/committee/aging"
}
],
"parent_id" : null,
"members" : [
{
"leg_id" : "NYL000001",
"role" : "chair",
"name" : "Sen. Eric Adams"
},
{
"leg_id" : "NYL000001",
"role" : "member",
"name" : "Eric Adams"
},
{
"leg_id" : "NYL000002",
"role" : "member",
"name" : "Joseph P. Addabbo Jr"
},
{
"leg_id" : "NYL000004",
"role" : "member",
"name" : "Tony Avella"
},
{
"leg_id" : "NYL000010",
"role" : "member",
"name" : "Ruben Diaz"
},
{
"leg_id" : "NYL000229",
"role" : "member",
"name" : "Simcha Felder"
},
{
"leg_id" : "NYL000019",
"role" : "member",
"name" : "Martin J. Golden"
},
{
"leg_id" : "NYL000032",
"role" : "member",
"name" : "Kenneth P. LaValle"
},
{
"leg_id" : "NYL000235",
"role" : "member",
"name" : "Kathleen A. Marchione"
},
{
"leg_id" : "NYL000058",
"role" : "member",
"name" : "Toby Ann Stavisky"
},
{
"leg_id" : "NYL000060",
"role" : "member",
"name" : "David J. Valesky"
},
{
"leg_id" : "NYL000062",
"role" : "member",
"name" : "Lee M. Zeldin"
}
],
"subcommittee" : null
}