Patent grant bibliographic (front page) text data (JAN 1976 - present)

from alexandria3k.data_sources import uspto

Generated schema

CREATE TABLE us_patents(
  id,
  container_id,
  language,
  status,
  country,
  filename,
  date_produced,
  date_published,
  publication_reference_doc_number,
  publication_reference_kind,
  publication_reference_name,
  type,
  application_reference_doc_number,
  application_reference_kind,
  application_reference_name,
  application_reference_date,
  locarno_edition,
  locarno_main_classification,
  locarno_further_classification,
  locarno_text,
  national_edition,
  national_main_classification,
  national_further_classification,
  national_additional_info,
  national_linked_indexing_code_group,
  national_unlinked_indexing_code,
  national_text,
  series_code,
  invention_title,
  botanic_name,
  botanic_variety,
  claims_number,
  exemplary_claim,
  figures_number,
  drawings_number,
  primary_examiner_firstname,
  primary_examiner_lastname,
  assistant_examiner_firstname,
  assistant_examiner_lastname,
  authorized_officer_firstname,
  authorized_officer_lastname,
  hague_reg_num,
  cpa_flag,
  rule47_flag
);

CREATE TABLE usp_icpr_classifications(
  patent_id,
  container_id,
  ipc_date,
  class_level,
  section,
  class,
  subclass,
  main_group,
  subgroup,
  symbol_position,
  class_value,
  action_date,
  generating_office,
  class_status,
  class_source
);

CREATE TABLE usp_cpc_classifications(
  patent_id,
  container_id,
  type,
  cpc_version_indicator,
  section,
  class,
  sub_class,
  main_group,
  sub_group,
  symbol_position,
  class_value,
  action_date,
  generating_office,
  class_status,
  class_data_source,
  scheme_origination_code,
  combination_group_number,
  combination_rank_number
);

CREATE TABLE usp_related_documents(
  patent_id,
  container_id,
  relation,
  parent_doc_number,
  parent_doc_kind,
  parent_doc_name,
  parent_doc_date,
  status,
  parent_grant_doc_number,
  parent_pct_doc_number,
  parent_filing_date,
  child_doc_number,
  child_doc_kind,
  child_doc_name,
  child_doc_date,
  child_filing_date,
  document_number,
  document_kind,
  document_name,
  document_date,
  provisional_application_status,
  corrected_document_doc_number,
  corrected_document_kind,
  corrected_document_name,
  corrected_document_date,
  type_of_correction,
  gazette_number,
  gazette_date,
  correction_text
);

CREATE TABLE usp_field_of_classification(
  patent_id,
  container_id,
  ipcr_classification,
  cpc_classification_text,
  cpc_classification_combination_text,
  national_edition,
  national_main,
  national_further,
  national_additional_info,
  national_linked_code_group,
  national_unlinked_code,
  national_text
);

CREATE TABLE usp_inventors(
  patent_id,
  container_id,
  sequence,
  name,
  first_name,
  middle_name,
  last_name,
  org_name,
  suffix,
  iid,
  role,
  department,
  synonym,
  registered_number,
  email,
  url,
  text,
  city,
  state,
  country,
  postcode,
  designation,
  designated_country,
  designated_region
);

CREATE TABLE usp_applicants(
  patent_id,
  container_id,
  sequence,
  name,
  first_name,
  middle_name,
  last_name,
  org_name,
  suffix,
  iid,
  role,
  department,
  synonym,
  registered_number,
  email,
  url,
  text,
  city,
  state,
  country,
  postcode,
  app_type,
  applicant_authority_category,
  designation,
  residence,
  us_rights,
  designated_country,
  designated_region,
  designated_country_inventor,
  designated_region_inventor
);

CREATE TABLE usp_agents(
  patent_id,
  container_id,
  sequence,
  name,
  first_name,
  middle_name,
  last_name,
  org_name,
  suffix,
  iid,
  role,
  department,
  synonym,
  registered_number,
  email,
  url,
  text,
  city,
  state,
  country,
  postcode,
  rep_type
);

CREATE TABLE usp_assignees(
  patent_id,
  container_id,
  name,
  first_name,
  middle_name,
  last_name,
  org_name,
  suffix,
  iid,
  role,
  department,
  synonym,
  registered_number,
  email,
  url,
  text,
  city,
  state,
  country,
  postcode
);

CREATE TABLE usp_citations(
  patent_id,
  container_id,
  patcit_num,
  nplcit_num,
  nplcit_othercit,
  patcit_doc_number,
  patcit_country,
  patcit_kind,
  patcit_date,
  patcit_rel_passage,
  patcit_rel_category,
  patcit_rel_claims,
  category,
  ipc_class_edition,
  ipc_class_main,
  ipc_class_further,
  cpc_class_text,
  national_class_country,
  national_class_edition,
  national_class_main,
  national_class_further
);

CREATE TABLE usp_patent_family(
  patent_id,
  container_id,
  priority_app_doc_number,
  priority_app_country,
  priority_app_kind,
  priority_app_name,
  priority_app_date,
  family_member_doc_number,
  family_member_country,
  family_member_kind,
  family_member_name,
  family_member_date,
  text
);