home

dcc

Recovered production database with 17,578 cooperative organizations

Data license: CC-BY-4.0

Custom SQL query

Tables

access_rules

id, access_type

1 row

data_sharing_orgs

id, name, dso, dso_update, created_at, updated_at, default_import_plugin_name, dccid, key

25 rows

data_sharing_orgs_taggables

id, data_sharing_org_id, taggable_id, taggable_type, verified, dso, dso_update, created_at, updated_at, foreign_key_id, dccid

17,595 rows

data_sharing_orgs_users

id, user_id, data_sharing_org_id

0 rows

legal_structures

id, name, created_at, updated_at

11 rows

locations

id, mailing_address1, mailing_address2, mailing_city, mailing_state, mailing_zip, mailing_country, mailing_county, physical_county, dccid, created_at, updated_at, note, dso, dso_update, taggable_id, physical_address1, physical_address2, physical_city, physical_state, physical_zip, physical_country, latitude, longitude, taggable_type

Many rows

member_orgs

id, name, created_at, updated_at

23 rows

member_orgs_organizations

id, member_org_id, organization_id

0 rows

oids

id, dccid, oid

Many rows

org_types

id, name, description, created_at, updated_at

234 rows

org_types_organizations

id, org_type_id, organization_id

0 rows

organizations

id, grouping, dccid, created_at, updated_at, fax, year_founded, dso, dso_update, name, description, phone, email, website, democratic, import_notice_sent_at, email_response_token, responded_at, response, access_rule_id, primary_location_id, oid, group, source_grouping, mode

Many rows

organizations_people

id, person_id, organization_id

0 rows

organizations_sectors

id, sector_id, organization_id

0 rows

organizations_users

id, user_id, organization_id

0 rows

people

id, firstname, lastname, updated_at

0 rows

product_services

id, name, organization_id

0 rows

sectors

id, name, created_at, updated_at

71 rows

sources

name, key, name_of_organization, description, source_directory_link, source_info_link

24 rows

tag_contexts

id, name, friendly_name

4 rows

tag_worlds

id, name

1 row

taggings

id, tag_id, taggable_id, taggable_type, dso, dso_update, created_at, dccid

22,074 rows

tags

id, name, root_id, root_type, parent_id, effective_id, created_at, updated_at

332 rows

users

id, login, password, is_admin, person_id, last_login

5 rows

... and 7 hidden tables

Powered by Datasette · Queries took 234.724ms · Data license: CC-BY-4.0