Fandom

Scratchpad

DAN Data Schema

215,866pages on
this wiki
Add New Page
Discuss this page0 Share

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.

DAN Data Schema

Spreadsheet columns

  • as of 2/18/2007
    • Resource_Type, Coverage_Area, Disaster_Restriction, Organization, Program, Street_Address, City, State, Zip, Contact, Phone, Web_Address_Org, Web_Address_App, Email
  • as of 3/30/2007
    • OrgID, Resource_Type, Coverage_Area, Disaster_Restriction, Organization, Program, Street_Address, City, State, Zip, Contact, Phone, Web_Address_Org, Web_Address_App, Email

Resource_Type

  • as of 2/18/2007
    • Adult Wishes, Baby, Building Material, Business, Charity, Child Care, Children Dental, Children Insurance, Children, Childrens Wishes, Christmas, Churches Helping, Clothing, College, Computers, Counseling, Credit, Direct Assistance, Disabilities, Disability, Disaster Assistance, Document Replacment, Emergency Assistance, Emergency Shelter, Employment, Financial, Food, Fraternal Organizations, Fraud, Free Vacations, Furniture, General, Gift Cards, Heating, Home Buying, Home Ownership, Home Repair, Home Schooling, Household, Housing, Insurance Help, Legal Assistance, Legal, Materials, Maternity, Medical Amputee, Medical Cancer, Medical Diabetes, Medical Equipment, Medical Financial Help, Medical Hearing, Medical Home Care, Medical Housing, Medical Kidney, Medical Transportation, Medical Vision, Medical, Mental Health, Mobile, Mortgage Assistance, Newspapers, Prescription Senior, Prescription, Rebuilding, Referral Service, Relocation, Rent, Rentals, Savings, School, Senior Medical Equipment, Senior Vision, Training, Transportation Shipping, Transportation, Tutoring, Utilities, Utility Assistance, Vision, Volunteers, Weatherization,

DAN Entities

Organization

  • Organization ID
  • Organization type ID
  • Organization title
  • Also known as
  • Organization established
  • Administrator name
  • Administrator title
  • Administrator phone
  • Internet address
  • Email address
  • Administrative address
    • Street address
    • City
    • State
    • Zip
  • Organization description

Organization type

  • Organization type ID
  • Organization type title
  • Organization type description

Site

  • Site ID
  • Site title
  • Site Address
    • Street address
    • City
    • State
    • Zip
    • County
  • Site public transportation
  • Site accessibility
  • Site contact for service
  • Site phone
  • Site FAX
  • Site service hours
  • Site appointment required
  • Site office hours
  • Site referral required
  • Site availability
  • Site languages
  • Site description

Service

  • Service ID
  • Service title
  • Service description

Organization:Site

  • Organization ID
  • Site ID

Organization:Service

  • Organization ID
  • Service ID
  • Service access criteria
    • Age
    • Residency
    • Requirement
  • Income guideline ID
  • Service fee
  • Service description

Site:Service

  • Site ID
  • Service ID
  • Site service description

Income guideline

  • Income guideline ID
  • Income guideline title
  • Income guideline description

To do

See also

References

DAN Links

Also on Fandom

Random wikia