Skip to content

Instantly share code, notes, and snippets.

@paulfitz
Created September 5, 2018 16:13
Show Gist options
  • Save paulfitz/713fb52ff7f23cd1a2b9a36a8589a4ef to your computer and use it in GitHub Desktop.
Save paulfitz/713fb52ff7f23cd1a2b9a36a8589a4ef to your computer and use it in GitHub Desktop.
Sketch of the fields stored in find.coop

find.coop is primarily a database of Organizations with Locations.

Organization

field meaning type
name name of organization string
phone primary phone number string
email primary email address string
website primary internet presence string
description freeform text about organization string
year_founded year the organization came into existence integer
locations list of locations associated with organizations Locations
tags freeform tags for organization list of strings
org_types tags specifically related to non-legal aspects of how org is structured list of strings
sectors tags specifically related to market/industrial sector list of strings
legal_structures tags specifically related to incorporated form list of strings
member_orgs names of organizations this org belongs to list of strings

Location

field meaning type
physical_street_address1 physical (as opposed to mailing) address string
physical_street_address2 string
physical_city string
physical_state string
physical_zip string
physical_country string
latitude optional, we'll geocode this if blank number
longitude optional, we'll geocode this if blank number
mailing_street_address1 mailing address string
mailing_street_address2 string
mailing_city string
mailing_state string
mailing_zip string
mailing_country string
note freeform description of location's role string
is_primary_location is this the "headquarters" boolean
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment