kinlane
4/24/2016 - 5:32 AM
Human Services Data Specification Schema
Human Services Data Specification Schema
{
"name": "human_services_data",
"title": "Human Services Data",
"license": [
{
"url": "http://opendatacommons.org/licenses/pddl/",
"name": "Open Data Commons Public Domain",
"version": "1.0",
"id": "odc-pddl"
}
],
"resources": [
{
"name": "organization",
"path": "organization.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"type": "string"
},
{
"name": "name",
"type": "string"
},
{
"name": "alternate_name",
"type": "string"
},
{
"name": "description",
"type": "string",
"format": ""
},
{
"name": "email",
"type": "string"
},
{
"name": "url",
"type": "string"
},
{
"name": "tax_status",
"type": "string"
},
{
"name": "tax_id",
"type": "string"
},
{
"name": "year_incorporated",
"type": "date",
"format": "yyyy"
},
{
"name": "legal_status",
"type": "string"
}
],
"primaryKey": "id"
}
},
{
"name": "program",
"path": "program.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "organization_id",
"description": "",
"type": "string"
},
{
"name": "name",
"description": "",
"type": "string"
},
{
"name": "alternate_name",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "organization_id",
"reference": {
"resource": "organization.csv",
"fields": "id"
}
}
]
}
},
{
"name": "service",
"path": "service.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "organization_id",
"description": "",
"type": "string"
},
{
"name": "program_id",
"description": "",
"type": "string"
},
{
"name": "location_id",
"description": "",
"type": "string"
},
{
"name": "name",
"description": "",
"type": "string"
},
{
"name": "alternate_name",
"description": "",
"type": "string"
},
{
"name": "url",
"description": "",
"type": "string"
},
{
"name": "email",
"description": "",
"type": "string"
},
{
"name": "status",
"description": "",
"type": "string",
"values": [
"active",
"inactive",
"defunct",
"temporarily closed"
]
},
{
"name": "application_process",
"description": "",
"type": "string"
},
{
"name": "wait_time",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "organization_id",
"reference": {
"resource": "organization.csv",
"fields": "id"
}
},
{
"fields": "program_id",
"reference": {
"resource": "program.csv",
"fields": "id"
}
},
{
"fields": "location_id",
"reference": {
"resource": "location.csv",
"fields": "id"
}
}
]
}
},
{
"name": "service_at_location",
"path": "service_at_location.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "location_id",
"description": "",
"type": "string"
},
{
"name": "url",
"description": "",
"type": "string"
},
{
"name": "email",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
},
{
"fields": "location_id",
"reference": {
"resource": "location.csv",
"fields": "id"
}
}
]
}
},
{
"name": "location",
"path": "program.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "organization_id",
"description": "",
"type": "string"
},
{
"name": "name",
"description": "",
"type": "string"
},
{
"name": "alternate_name",
"description": "",
"type": "string"
},
{
"name": "transportation",
"description": "",
"type": "string"
},
{
"name": "latitude",
"description": "",
"type": "float"
},
{
"name": "longitude",
"description": "",
"type": "float"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "organization_id",
"reference": {
"resource": "organization.csv",
"fields": "id"
}
},
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "phone",
"path": "phone.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "location_id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "organization_id",
"description": "",
"type": "string"
},
{
"name": "contact_id",
"description": "",
"type": "string"
},
{
"name": "number",
"description": "",
"type": "string"
},
{
"name": "extension",
"description": "",
"type": "number"
},
{
"name": "type",
"description": "",
"type": "string"
},
{
"name": "department",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "organization_id",
"reference": {
"resource": "organization.csv",
"fields": "id"
}
},
{
"fields": "location_id",
"reference": {
"resource": "location.csv",
"fields": "id"
}
},
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
},
{
"fields": "contact_id",
"reference": {
"resource": "contact.csv",
"fields": "id"
}
}
]
}
},
{
"name": "contact",
"path": "contact.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "organization_id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "name",
"description": "",
"type": "string"
},
{
"name": "title",
"description": "",
"type": "string"
},
{
"name": "department",
"description": "",
"type": "string"
},
{
"name": "email",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "organization_id",
"reference": {
"resource": "organization.csv",
"fields": "id"
}
},
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "physical_address",
"path": "address.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "location_id",
"description": "",
"type": "string"
},
{
"name": "attention",
"description": "",
"type": "string"
},
{
"name": "address_1",
"description": "",
"type": "string"
},
{
"name": "address_2",
"description": "",
"type": "string"
},
{
"name": "address_3",
"description": "",
"type": "string"
},
{
"name": "address_4",
"description": "",
"type": "string"
},
{
"name": "city",
"description": "",
"type": "string"
},
{
"name": "state_province",
"description": "",
"type": "string"
},
{
"name": "postal_code",
"description": "",
"type": "string"
},
{
"name": "country",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "location_id",
"reference": {
"resource": "location.csv",
"fields": "id"
}
}
]
}
},
{
"name": "postal_address",
"path": "address.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "location_id",
"description": "",
"type": "string"
},
{
"name": "attention",
"description": "",
"type": "string"
},
{
"name": "address_1",
"description": "",
"type": "string"
},
{
"name": "address_2",
"description": "",
"type": "string"
},
{
"name": "address_3",
"description": "",
"type": "string"
},
{
"name": "address_4",
"description": "",
"type": "string"
},
{
"name": "city",
"description": "",
"type": "string"
},
{
"name": "state_province",
"description": "",
"type": "string"
},
{
"name": "postal_code",
"description": "",
"type": "string"
},
{
"name": "country",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "location_id",
"reference": {
"resource": "location.csv",
"fields": "id"
}
}
]
}
},
{
"name": "regular_schedule",
"path": "regular_schedule.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "location_id",
"description": "",
"type": "string"
},
{
"name": "weekday",
"description": "",
"type": "integer"
},
{
"name": "opens_at",
"description": "",
"type": "time"
},
{
"name": "closes_at",
"description": "",
"type": "time"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "location_id",
"reference": {
"resource": "location.csv",
"fields": "id"
}
},
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "holiday_schedule",
"path": "holiday_schedule.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "location_id",
"description": "",
"type": "string"
},
{
"name": "closed",
"description": "",
"type": "boolean"
},
{
"name": "opens_at",
"description": "",
"type": "time"
},
{
"name": "closes_at",
"description": "",
"type": "time"
},
{
"name": "start_date",
"description": "",
"type": "date"
},
{
"name": "end_date",
"description": "",
"type": "date"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "location_id",
"reference": {
"resource": "location.csv",
"fields": "id"
}
},
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "funding",
"path": "funding.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "organization_id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "source",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
},
{
"fields": "organization_id",
"reference": {
"resource": "organization.csv",
"fields": "id"
}
}
]
}
},
{
"name": "eligibility",
"path": "eligibility.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "eligibility",
"description": "",
"type": "string",
"values": [
"adult",
"child",
"teen",
"family",
"female",
"male",
"Transgender",
"Transgender - M to F",
"Transgender - F to M"
]
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "service_area",
"path": "service_area.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "service_area",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "required_document",
"path": "required_document.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "document",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "fee",
"path": "fee.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "fee",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "payment_accepted",
"path": "payment_accepted.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "payment",
"description": "",
"type": "string",
"values": [
"cash",
"check",
"money order",
"credit card",
"medicare",
"SNAP",
"WIC",
"EBT"
]
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "intepretation_services",
"path": "interpretation_services.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "language",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "language",
"path": "language.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "service_id",
"description": "",
"type": "string"
},
{
"name": "location_id",
"description": "",
"type": "string"
},
{
"name": "language",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
},
{
"fields": "location_id",
"reference": {
"resource": "location.csv",
"fields": "id"
}
}
]
}
},
{
"name": "accessibility_for_disabilities",
"path": "accessibility_for_disabilities.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "location_id",
"description": "",
"type": "string"
},
{
"name": "accessibility",
"description": "",
"type": "string",
"values": [
"cd",
"deaf_interpreter",
"disabled_parking",
"elevator",
"ramp",
"restroom",
"tape_braille",
"tty",
"wheelchair",
"wheelchair_van"
]
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "service_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
}
]
}
},
{
"name": "metadata",
"path": "metadata.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "resource_id",
"description": "",
"type": "string"
},
{
"name": "last_action_date",
"description": "",
"type": "string"
},
{
"name": "last_action_type",
"description": "",
"type": "string"
},
{
"name": "field_name",
"description": "",
"type": "string"
},
{
"name": "previous_value",
"description": "",
"type": "string"
},
{
"name": "replacement_value",
"description": "",
"type": "string"
},
{
"name": "updated_by",
"description": "",
"type": "string"
}
],
"primaryKey": "id",
"foreignKeys": [
{
"fields": "resource_id",
"reference": {
"resource": "location.csv",
"fields": "id"
}
},
{
"fields": "resource_id",
"reference": {
"resource": "service.csv",
"fields": "id"
}
},
{
"fields": "resource_id",
"reference": {
"resource": "organization.csv",
"fields": "id"
}
},
{
"fields": "resource_id",
"reference": {
"resource": "program.csv",
"fields": "id"
}
},
{
"fields": "resource_id",
"reference": {
"resource": "address.csv",
"fields": "id"
}
},
{
"fields": "resource_id",
"reference": {
"resource": "contact.csv",
"fields": "id"
}
},
{
"fields": "resource_id",
"reference": {
"resource": "holiday_schedules.csv",
"fields": "id"
}
},
{
"fields": "resource_id",
"reference": {
"resource": "regular_schedules.csv",
"fields": "id"
}
},
{
"fields": "resource_id",
"reference": {
"resource": "phone.csv",
"fields": "id"
}
}
]
}
},
{
"name": "meta_table_description",
"path": "meta_table_description.csv",
"format": "csv",
"mediatype": "text/csv",
"schema": {
"fields": [
{
"name": "id",
"description": "",
"type": "string"
},
{
"name": "name",
"description": "",
"type": "string"
},
{
"name": "language",
"description": "",
"type": "string"
},
{
"name": "character_set",
"description": "",
"type": "string"
}
],
"primaryKey": "id"
}
}
]
}