| SchemaSpy Analysis of postgres.omop - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on dim. sept. 10 20:08 CEST 2017 |
| ||||||
|
|
postgres.omop contains 391 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | Comments |
|---|---|---|---|---|---|---|---|
| cdm_source | cdm_release_date | date | 13 | √ | null | The date when the CDM was instantiated | |
| cohort | cohort_end_date | date | 13 | The date when the Cohort Definition criteria for the Person, Provider or Visit no longer match or the Cohort membership was terminated. | |||
| cohort_attribute | cohort_end_date | date | 13 | The date when the Cohort Definition criteria for the Person, Provider or Visit no longer match or the Cohort membership was terminated. | |||
| cohort_definition | cohort_initiation_date | date | 13 | √ | null | A date to indicate when the Cohort was initiated in the COHORT table | |
| cohort | cohort_start_date | date | 13 | The date when the Cohort Definition criteria for the Person, Provider or Visit first match. | |||
| cohort_attribute | cohort_start_date | date | 13 | The date when the Cohort Definition criteria for the Person, Provider or Visit first match. | |||
| condition_occurrence | condition_end_date | date | 13 | √ | null | The date when the instance of the Condition is considered to have ended. | |
| condition_era | condition_era_end_date | date | 13 | The end date for the Condition Era constructed from the individual instances of Condition Occurrences. It is the end date of the final continuously recorded instance of the Condition. | |||
| condition_era | condition_era_start_date | date | 13 | The start date for the Condition Era constructed from the individual instances of Condition Occurrences. It is the start date of the very first chronologically recorded instance of the condition. | |||
| condition_occurrence | condition_start_date | date | 13 | The date when the instance of the Condition is recorded. | |||
| death | death_date | date | 13 | The date the person was deceased. If the precise date including day or month is not known or not allowed, December is used as the default month, and the last day of the month the default day. | |||
| device_exposure | device_exposure_end_date | date | 13 | √ | null | The date the Device or supply was removed from use. | |
| device_exposure | device_exposure_start_date | date | 13 | The date the Device or supply was applied or used. | |||
| dose_era | dose_era_end_date | date | 13 | The end date for the drug era constructed from the individual instance of drug exposures. It is the end date of the final continuously recorded instance of utilization of a drug. | |||
| dose_era | dose_era_start_date | date | 13 | The start date for the drug era constructed from the individual instances of drug exposures. It is the start date of the very first chronologically recorded instance of utilization of a drug. | |||
| drug_era | drug_era_end_date | date | 13 | The end date for the drug era constructed from the individual instance of drug exposures. It is the end date of the final continuously recorded instance of utilization of a drug. | |||
| drug_era | drug_era_start_date | date | 13 | The start date for the Drug Era constructed from the individual instances of Drug Exposures. It is the start date of the very first chronologically recorded instance of conutilization of a Drug. | |||
| drug_exposure | drug_exposure_end_date | date | 13 | The end date for the current instance of Drug utilization. It is not available from all sources. | |||
| drug_exposure | drug_exposure_start_date | date | 13 | The start date for the current instance of Drug utilization. Valid entries include a start date of a prescription, the date a prescription was filled, or the date on which a Drug administration procedure was recorded. | |||
| measurement | measurement_date | date | 13 | The date of the Measurement. | |||
| note_nlp | nlp_date | date | 13 | The date of the note processing.Useful for data provenance. | |||
| note | note_date | date | 13 | The date the note was recorded. | |||
| observation | observation_date | date | 13 | The date of the observation. | |||
| observation_period | observation_period_end_date | date | 13 | The end date of the observation period for which data are available from the data source. | |||
| observation_period | observation_period_start_date | date | 13 | The start date of the observation period for which data are available from the data source. | |||
| payer_plan_period | payer_plan_period_end_date | date | 13 | The end date of the payer plan period. | |||
| payer_plan_period | payer_plan_period_start_date | date | 13 | The start date of the payer plan period. | |||
| procedure_occurrence | procedure_date | date | 13 | The date on which the Procedure was performed. | |||
| cdm_source | source_release_date | date | 13 | √ | null | The date for which the source data are most current, such as the last day of data capture | |
| specimen | specimen_date | date | 13 | The date the specimen was obtained from the Person. | |||
| concept | valid_end_date | date | 13 | The date when the Concept became invalid because it was deleted or superseded (updated) by a new concept. The default value is 31-Dec-2099, meaning, the Concept is valid until it becomes deprecated. | |||
| concept_relationship | valid_end_date | date | 13 | The date when the Concept Relationship became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31-Dec-2099. | |||
| drug_strength | valid_end_date | date | 13 | The date when the concept became invalid because it was deleted or superseded (updated) by a new Concept. The default value is 31-Dec-2099. | |||
| source_to_concept_map | valid_end_date | date | 13 | The date when the mapping instance became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31-Dec-2099. | |||
| concept | valid_start_date | date | 13 | The date when the Concept was first recorded. The default value is 1-Jan-1970, meaning, the Concept has no (known) date of inception. | |||
| concept_relationship | valid_start_date | date | 13 | The date when the instance of the Concept Relationship is first recorded. | |||
| drug_strength | valid_start_date | date | 13 | The date when the Concept was first recorded. The default value is 1-Jan-1970. | |||
| source_to_concept_map | valid_start_date | date | 13 | The date when the mapping instance was first recorded. | |||
| drug_exposure | verbatim_end_date | date | 13 | √ | null | The known end date of a drug_exposure as provided by the source | |
| visit_detail | visit_end_date | date | 13 | The end date of the visit. If this is a one-day visit the end date should match the start date. | |||
| visit_occurrence | visit_end_date | date | 13 | The end date of the visit. If this is a one-day visit the end date should match the start date. | |||
| visit_detail | visit_start_date | date | 13 | The start date of the visit. | |||
| visit_occurrence | visit_start_date | date | 13 | The start date of the visit. | |||
| visit_detail | admitting_source_concept_id | int4 | 10 | √ | null | A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the admitting source for a visit. | |
| visit_occurrence | admitting_source_concept_id | int4 | 10 | √ | null | A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the admitting source for a visit. | |
| drug_strength | amount_unit_concept_id | int4 | 10 | √ | null | A foreign key to the Concept in the CONCEPT table representing the identifier for the Unit for the absolute amount of active ingredient. | |
| specimen | anatomic_site_concept_id | int4 | 10 | √ | null | A foreign key to a Standard Concept identifier for the anatomic location of specimen collection. | |
| concept_ancestor | ancestor_concept_id | int4 | 10 | A foreign key to the concept in the concept table for the higher-level concept that forms the ancestor in the relationship. | |||
| attribute_definition | attribute_definition_id | int4 | 10 | A unique identifier for each Attribute. | |||
| cohort_attribute | attribute_definition_id | int4 | 10 | A foreign key to a record in the [ATTRIBUTE_DEFINITION](https://github.com/OHDSI/CommonDataModel/wiki/ATTRIBUTE_DEFINITION) table containing relevant Attribute Definition information. | |||
| attribute_definition | attribute_type_concept_id | int4 | 10 | Type defining what kind of Attribute Definition the record represents and how the syntax may be executed | |||
| drug_strength | box_size | int4 | 10 | √ | null | The number of units of Clinical of Branded Drug, or Quantified Clinical or Branded Drug contained in a box as dispensed to the patient | |
| care_site | care_site_id | int4 | 10 | A unique identifier for each Care Site. | |||
| person | care_site_id | int4 | 10 | √ | null | A foreign key to the site of primary care in the care_site table, where the details of the care site are stored. | |
| provider | care_site_id | int4 | 10 | √ | null | A foreign key to the main Care Site where the provider is practicing. | |
| visit_detail | care_site_id | int4 | 10 | √ | null | A foreign key to the care site in the care site table that was visited. | |
| visit_occurrence | care_site_id | int4 | 10 | √ | null | A foreign key to the care site in the care site table that was visited. | |
| death | cause_concept_id | int4 | 10 | √ | null | A foreign key referring to a standard concept identifier in the Standardized Vocabularies for conditions. | |
| death | cause_source_concept_id | int4 | 10 | √ | null | A foreign key to the concept that refers to the code used in the source. Note, this variable name is abbreviated to ensure it will be allowable across database platforms. | |
| cohort | cohort_definition_id | int4 | 10 | A foreign key to a record in the COHORT_DEFINITION table containing relevant Cohort Definition information. | |||
| cohort_attribute | cohort_definition_id | int4 | 10 | A foreign key to a record in the [COHORT_DEFINITION](https://github.com/OHDSI/CommonDataModel/wiki/COHORT_DEFINITION) table containing relevant Cohort Definition information. | |||
| cohort_definition | cohort_definition_id | int4 | 10 | A unique identifier for each Cohort. | |||
| concept_class | concept_class_concept_id | int4 | 10 | A foreign key that refers to an identifier in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table for the unique Concept Class the record belongs to. | |||
| concept | concept_id | int4 | 10 | A unique identifier for each Concept across all domains. | |||
| concept_synonym | concept_id | int4 | 10 | A foreign key to the Concept in the CONCEPT table. | |||
| concept_relationship | concept_id_1 | int4 | 10 | A foreign key to a Concept in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table associated with the relationship. Relationships are directional, and this field represents the source concept designation. | |||
| concept_relationship | concept_id_2 | int4 | 10 | A foreign key to a Concept in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table associated with the relationship. Relationships are directional, and this field represents the destination concept designation. | |||
| condition_era | condition_concept_id | int4 | 10 | A foreign key that refers to a standard Condition Concept identifier in the Standardized Vocabularies. | |||
| condition_occurrence | condition_concept_id | int4 | 10 | A foreign key that refers to a Standard Condition Concept identifier in the Standardized Vocabularies. | |||
| condition_era | condition_era_id | int4 | 10 | A unique identifier for each Condition Era. | |||
| condition_era | condition_occurrence_count | int4 | 10 | √ | null | The number of individual Condition Occurrences used to construct the condition era. | |
| condition_occurrence | condition_occurrence_id | int4 | 10 | A unique identifier for each Condition Occurrence event. | |||
| condition_occurrence | condition_source_concept_id | int4 | 10 | √ | null | A foreign key to a Condition Concept that refers to the code used in the source. | |
| condition_occurrence | condition_status_concept_id | int4 | 10 | √ | null | A foreign key to the predefined concept in the standard vocabulary reflecting the condition status | |
| condition_occurrence | condition_type_concept_id | int4 | 10 | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the source data from which the condition was recorded, the level of standardization, and the type of occurrence. | |||
| cost | cost_event_id | int4 | 10 | A foreign key identifier to the event (e.g. Measurement, Procedure, Visit, Drug Exposure, etc) record for which cost data are recorded. | |||
| cost | cost_id | int4 | 10 | A unique identifier for each COST record. | |||
| cost | cost_type_concept_id | int4 | 10 | A foreign key identifier to a concept in the CONCEPT table for the provenance or the source of the COST data: Calculated from insurance claim information, provider revenue, calculated from cost-to-charge ratio, reported from accounting database, etc. | |||
| cost | currency_concept_id | int4 | 10 | √ | null | A foreign key identifier to the concept representing the 3-letter code used to delineate international currencies, such as USD for US Dollar. | |
| person | day_of_birth | int4 | 10 | √ | null | The day of the month of birth of the person. For data sources that provide the precise date of birth, the day is extracted and stored in this field. | |
| drug_exposure | days_supply | int4 | 10 | √ | null | The number of days of supply of the medication as recorded in the original prescription or dispensing record. | |
| death | death_type_concept_id | int4 | 10 | A foreign key referring to the predefined concept identifier in the Standardized Vocabularies reflecting how the death was represented in the source data. | |||
| cohort_definition | definition_type_concept_id | int4 | 10 | Type defining what kind of Cohort Definition the record represents and how the syntax may be executed | |||
| drug_strength | denominator_unit_concept_id | int4 | 10 | √ | null | A foreign key to the Concept in the CONCEPT table representing the identifier for the denominator Unit for the concentration of active ingredient. | |
| concept_ancestor | descendant_concept_id | int4 | 10 | A foreign key to the concept in the concept table for the lower-level concept that forms the descendant in the relationship. | |||
| device_exposure | device_concept_id | int4 | 10 | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Device concept. | |||
| device_exposure | device_exposure_id | int4 | 10 | A system-generated unique identifier for each Device Exposure. | |||
| device_exposure | device_source_concept_id | int4 | 10 | √ | null | A foreign key to a Device Concept that refers to the code used in the source. | |
| device_exposure | device_type_concept_id | int4 | 10 | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Device Exposure recorded. It indicates how the Device Exposure was represented in the source data. | |||
| visit_detail | discharge_to_concept_id | int4 | 10 | √ | null | A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the discharge disposition for a visit. | |
| visit_occurrence | discharge_to_concept_id | int4 | 10 | √ | null | A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the discharge disposition for a visit. | |
| specimen | disease_status_concept_id | int4 | 10 | √ | null | A foreign key to a Standard Concept identifier for the Disease Status of specimen collection. | |
| domain | domain_concept_id | int4 | 10 | A foreign key that refers to an identifier in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table for the unique Domain Concept the Domain record belongs to. | |||
| fact_relationship | domain_concept_id_1 | int4 | 10 | The concept representing the domain of fact one, from which the corresponding table can be inferred. | |||
| fact_relationship | domain_concept_id_2 | int4 | 10 | The concept representing the domain of fact two, from which the corresponding table can be inferred. | |||
| dose_era | dose_era_id | int4 | 10 | A unique identifier for each Dose Era. | |||
| cost | drg_concept_id | int4 | 10 | √ | null | A foreign key to the predefined concept in the DRG Vocabulary reflecting the DRG for a visit. | |
| dose_era | drug_concept_id | int4 | 10 | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the active Ingredient Concept. | |||
| drug_era | drug_concept_id | int4 | 10 | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Ingredient Concept. | |||
| drug_exposure | drug_concept_id | int4 | 10 | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Drug concept. | |||
| drug_strength | drug_concept_id | int4 | 10 | A foreign key to the Concept in the CONCEPT table representing the identifier for Branded Drug or Clinical Drug Concept. | |||
| drug_era | drug_era_id | int4 | 10 | A unique identifier for each Drug Era. | |||
| drug_era | drug_exposure_count | int4 | 10 | √ | null | The number of individual Drug Exposure occurrences used to construct the Drug Era. | |
| drug_exposure | drug_exposure_id | int4 | 10 | A system-generated unique identifier for each Drug utilization event. | |||
| drug_exposure | drug_source_concept_id | int4 | 10 | √ | null | A foreign key to a Drug Concept that refers to the code used in the source. | |
| drug_exposure | drug_type_concept_id | int4 | 10 | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Drug Exposure recorded. It indicates how the Drug Exposure was represented in the source data. | |||
| note | encoding_concept_id | int4 | 10 | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the note character encoding type | |||
| person | ethnicity_concept_id | int4 | 10 | A foreign key that refers to the standard concept identifier in the Standardized Vocabularies for the ethnicity of the person. | |||
| person | ethnicity_source_concept_id | int4 | 10 | √ | null | A foreign key to the ethnicity concept that refers to the code used in the source. | |
| fact_relationship | fact_id_1 | int4 | 10 | The unique identifier in the table corresponding to the domain of fact one. | |||
| fact_relationship | fact_id_2 | int4 | 10 | The unique identifier in the table corresponding to the domain of fact two. | |||
| drug_era | gap_days | int4 | 10 | √ | null | The number of days that are not covered by DRUG_EXPOSURE records that were used to make up the era record. | |
| person | gender_concept_id | int4 | 10 | A foreign key that refers to an identifier in the CONCEPT table for the unique gender of the person. | |||
| provider | gender_concept_id | int4 | 10 | √ | null | The gender of the Provider. | |
| person | gender_source_concept_id | int4 | 10 | √ | null | A foreign key to the gender concept that refers to the code used in the source. | |
| provider | gender_source_concept_id | int4 | 10 | √ | null | A foreign key to a Concept that refers to the code used in the source. | |
| drug_strength | ingredient_concept_id | int4 | 10 | A foreign key to the Concept in the CONCEPT table, representing the identifier for drug Ingredient Concept contained within the drug product. | |||
| concept_synonym | language_concept_id | int4 | 10 | A foreign key to a Concept representing the language. | |||
| note | language_concept_id | int4 | 10 | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the language of the note | |||
| care_site | location_id | int4 | 10 | √ | null | A foreign key to the geographic Location in the LOCATION table, where the detailed address information is stored. | |
| location | location_id | int4 | 10 | A unique identifier for each geographic location. | |||
| person | location_id | int4 | 10 | √ | null | A foreign key to the place of residency for the person in the location table, where the detailed address information is stored. | |
| concept_ancestor | max_levels_of_separation | int4 | 10 | The maximum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an attribute that is used to simplify hierarchic analysis. | |||
| measurement | measurement_concept_id | int4 | 10 | A foreign key to the standard measurement concept identifier in the Standardized Vocabularies. | |||
| measurement | measurement_id | int4 | 10 | A unique identifier for each Measurement. | |||
| measurement | measurement_source_concept_id | int4 | 10 | √ | null | A foreign key to a Concept in the Standard Vocabularies that refers to the code used in the source. | |
| measurement | measurement_type_concept_id | int4 | 10 | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the provenance from where the Measurement record was recorded. | |||
| concept_ancestor | min_levels_of_separation | int4 | 10 | The minimum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an attribute that is used to simplify hierarchic analysis. | |||
| procedure_occurrence | modifier_concept_id | int4 | 10 | √ | null | A foreign key to a Standard Concept identifier for a modifier to the Procedure (e.g. bilateral) | |
| person | month_of_birth | int4 | 10 | √ | null | The month of birth of the person. For data sources that provide the precise date of birth, the month is extracted and stored in this field. | |
| note | note_class_concept_id | int4 | 10 | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the HL7 LOINC Document Type Vocabulary classification of the note. | |||
| note | note_id | int4 | 10 | A unique identifier for each note. | |||
| note_nlp | note_id | int4 | 10 | A foreign key to the Note table note the term was extracted from. | |||
| note_nlp | note_nlp_concept_id | int4 | 10 | √ | null | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the normalized concept for the extracted term. Domain of the term is represented as part of the Concept table. | |
| note_nlp | note_nlp_source_concept_id | int4 | 10 | √ | null | A foreign key to a Concept that refers to the code in the source vocabulary used by the NLP system | |
| note | note_type_concept_id | int4 | 10 | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the type, origin or provenance of the Note. | |||
| drug_strength | numerator_unit_concept_id | int4 | 10 | √ | null | A foreign key to the Concept in the CONCEPT table representing the identifier for the numerator Unit for the concentration of active ingredient. | |
| observation | observation_concept_id | int4 | 10 | A foreign key to the standard observation concept identifier in the Standardized Vocabularies. | |||
| observation | observation_id | int4 | 10 | A unique identifier for each observation. | |||
| observation_period | observation_period_id | int4 | 10 | A unique identifier for each observation period. | |||
| observation | observation_source_concept_id | int4 | 10 | √ | null | A foreign key to a Concept that refers to the code used in the source. | |
| observation | observation_type_concept_id | int4 | 10 | A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of the observation. | |||
| measurement | operator_concept_id | int4 | 10 | √ | null | A foreign key identifier to the predefined Concept in the Standardized Vocabularies reflecting the mathematical operator that is applied to the value_as_number. Operators are <, <=, =, >=, >. | |
| cost | payer_plan_period_id | int4 | 10 | √ | null | A foreign key to the PAYER_PLAN_PERIOD table, where the details of the Payer, Plan and Family are stored. Record the payer_plan_id that relates to the payer who contributed to the paid_by_payer field. | |
| payer_plan_period | payer_plan_period_id | int4 | 10 | A identifier for each unique combination of payer, plan, family code and time span. | |||
| observation_period | period_type_concept_id | int4 | 10 | A foreign key identifier to the predefined concept in the Standardized Vocabularies reflecting the source of the observation period information | |||
| condition_era | person_id | int4 | 10 | A foreign key identifier to the Person who is experiencing the Condition during the Condition Era. The demographic details of that Person are stored in the PERSON table. | |||
| condition_occurrence | person_id | int4 | 10 | A foreign key identifier to the Person who is experiencing the condition. The demographic details of that Person are stored in the PERSON table. | |||
| death | person_id | int4 | 10 | A foreign key identifier to the deceased person. The demographic details of that person are stored in the person table. | |||
| device_exposure | person_id | int4 | 10 | A foreign key identifier to the Person who is subjected to the Device. The demographic details of that person are stored in the Person table. | |||
| dose_era | person_id | int4 | 10 | A foreign key identifier to the Person who is subjected to the drug during the drug era. The demographic details of that Person are stored in the PERSON table. | |||
| drug_era | person_id | int4 | 10 | A foreign key identifier to the Person who is subjected to the Drug during the fDrug Era. The demographic details of that Person are stored in the PERSON table. | |||
| drug_exposure | person_id | int4 | 10 | A foreign key identifier to the person who is subjected to the Drug. The demographic details of that person are stored in the person table. | |||
| measurement | person_id | int4 | 10 | A foreign key identifier to the Person about whom the measurement was recorded. The demographic details of that Person are stored in the PERSON table. | |||
| note | person_id | int4 | 10 | A foreign key identifier to the Person about whom the Note was recorded. The demographic details of that Person are stored in the PERSON table. | |||
| observation | person_id | int4 | 10 | A foreign key identifier to the Person about whom the observation was recorded. The demographic details of that Person are stored in the PERSON table. | |||
| observation_period | person_id | int4 | 10 | A foreign key identifier to the person for whom the observation period is defined. The demographic details of that person are stored in the person table. | |||
| payer_plan_period | person_id | int4 | 10 | A foreign key identifier to the Person covered by the payer. The demographic details of that Person are stored in the PERSON table. | |||
| person | person_id | int4 | 10 | A unique identifier for each person. | |||
| procedure_occurrence | person_id | int4 | 10 | A foreign key identifier to the Person who is subjected to the Procedure. The demographic details of that Person are stored in the PERSON table. | |||
| specimen | person_id | int4 | 10 | A foreign key identifier to the Person for whom the Specimen is recorded. | |||
| visit_detail | person_id | int4 | 10 | A foreign key identifier to the Person for whom the visit is recorded. The demographic details of that Person are stored in the PERSON table. | |||
| visit_occurrence | person_id | int4 | 10 | A foreign key identifier to the Person for whom the visit is recorded. The demographic details of that Person are stored in the PERSON table. | |||
| care_site | place_of_service_concept_id | int4 | 10 | √ | null | A foreign key that refers to a Place of Service Concept ID in the Standardized Vocabularies. | |
| visit_detail | preceding_visit_detail_id | int4 | 10 | √ | null | A foreign key to the VISIT_DETAIL table of the visit immediately preceding this visit | |
| visit_occurrence | preceding_visit_occurrence_id | int4 | 10 | √ | null | A foreign key to the VISIT_OCCURRENCE table of the visit immediately preceding this visit | |
| procedure_occurrence | procedure_concept_id | int4 | 10 | A foreign key that refers to a standard procedure Concept identifier in the Standardized Vocabularies. | |||
| procedure_occurrence | procedure_occurrence_id | int4 | 10 | A system-generated unique identifier for each Procedure Occurrence. | |||
| procedure_occurrence | procedure_source_concept_id | int4 | 10 | √ | null | A foreign key to a Procedure Concept that refers to the code used in the source. | |
| procedure_occurrence | procedure_type_concept_id | int4 | 10 | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the procedure record is derived. | |||
| condition_occurrence | provider_id | int4 | 10 | √ | null | A foreign key to the Provider in the PROVIDER table who was responsible for capturing (diagnosing) the Condition. | |
| device_exposure | provider_id | int4 | 10 | √ | null | A foreign key to the provider in the PROVIDER table who initiated of administered the Device. | |
| drug_exposure | provider_id | int4 | 10 | √ | null | A foreign key to the provider in the provider table who initiated (prescribed or administered) the Drug Exposure. | |
| measurement | provider_id | int4 | 10 | √ | null | A foreign key to the provider in the PROVIDER table who was responsible for initiating or obtaining the measurement. | |
| note | provider_id | int4 | 10 | √ | null | A foreign key to the Provider in the PROVIDER table who took the Note. | |
| observation | provider_id | int4 | 10 | √ | null | A foreign key to the provider in the PROVIDER table who was responsible for making the observation. | |
| person | provider_id | int4 | 10 | √ | null | A foreign key to the primary care provider the person is seeing in the provider table. | |
| procedure_occurrence | provider_id | int4 | 10 | √ | null | A foreign key to the provider in the provider table who was responsible for carrying out the procedure. | |
| provider | provider_id | int4 | 10 | A unique identifier for each Provider. | |||
| visit_detail | provider_id | int4 | 10 | √ | null | A foreign key to the provider in the provider table who was associated with the visit. | |
| visit_occurrence | provider_id | int4 | 10 | √ | null | A foreign key to the provider in the provider table who was associated with the visit. | |
| observation | qualifier_concept_id | int4 | 10 | √ | null | A foreign key to a Standard Concept ID for a qualifier (e.g., severity of drug-drug interaction alert) | |
| device_exposure | quantity | int4 | 10 | √ | null | The number of individual Devices used for the exposure. | |
| procedure_occurrence | quantity | int4 | 10 | √ | null | The quantity of procedures ordered or administered. | |
| person | race_concept_id | int4 | 10 | A foreign key that refers to an identifier in the CONCEPT table for the unique race of the person. | |||
| person | race_source_concept_id | int4 | 10 | √ | null | A foreign key to the race concept that refers to the code used in the source. | |
| drug_exposure | refills | int4 | 10 | √ | null | The number of refills after the initial prescription. The initial prescription is not counted, values start with 0. | |
| fact_relationship | relationship_concept_id | int4 | 10 | A foreign key to a Standard Concept ID of relationship in the Standardized Vocabularies. | |||
| relationship | relationship_concept_id | int4 | 10 | A foreign key that refers to an identifier in the CONCEPT table for the unique relationship concept. | |||
| cost | revenue_code_concept_id | int4 | 10 | √ | null | A foreign key referring to a Standard Concept ID in the Standardized Vocabularies for Revenue codes. | |
| drug_exposure | route_concept_id | int4 | 10 | √ | null | A foreign key to a predefined concept in the Standardized Vocabularies reflecting the route of administration. | |
| note_nlp | section_concept_id | int4 | 10 | √ | null | A foreign key to the predefined Concept in the Standardized Vocabularies representing the section of the extracted term. | |
| source_to_concept_map | source_concept_id | int4 | 10 | A foreign key to the Source Concept that is being translated into a Standard Concept. | |||
| provider | specialty_concept_id | int4 | 10 | √ | null | A foreign key to a Standard Specialty Concept ID in the Standardized Vocabularies. | |
| provider | specialty_source_concept_id | int4 | 10 | √ | null | A foreign key to a Concept that refers to the code used in the source. | |
| specimen | specimen_concept_id | int4 | 10 | A foreign key referring to a Standard Concept identifier in the Standardized Vocabularies for the Specimen. | |||
| specimen | specimen_id | int4 | 10 | A unique identifier for each specimen. | |||
| specimen | specimen_type_concept_id | int4 | 10 | A foreign key referring to the Concept identifier in the Standardized Vocabularies reflecting the system of record from which the Specimen was represented in the source data. | |||
| cohort_definition | subject_concept_id | int4 | 10 | A foreign key to the Concept to which defines the domain of subjects that are members of the cohort (e.g., Person, Provider, Visit). | |||
| cohort | subject_id | int4 | 10 | A foreign key to the subject in the cohort. These could be referring to records in the PERSON, PROVIDER, VISIT_OCCURRENCE table. | |||
| cohort_attribute | subject_id | int4 | 10 | A foreign key to the subject in the Cohort. These could be referring to records in the PERSON, PROVIDER, VISIT_OCCURRENCE table. | |||
| source_to_concept_map | target_concept_id | int4 | 10 | A foreign key to the target Concept to which the source code is being mapped. | |||
| dose_era | unit_concept_id | int4 | 10 | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the unit concept. | |||
| measurement | unit_concept_id | int4 | 10 | √ | null | A foreign key to a Standard Concept ID of Measurement Units in the Standardized Vocabularies. | |
| observation | unit_concept_id | int4 | 10 | √ | null | A foreign key to a Standard Concept ID of measurement units in the Standardized Vocabularies. | |
| specimen | unit_concept_id | int4 | 10 | √ | null | A foreign key to a Standard Concept identifier for the Unit associated with the numeric quantity of the Specimen collection. | |
| cohort_attribute | value_as_concept_id | int4 | 10 | √ | null | The attribute result stored as a Concept ID. This is applicable to attributes where the result is expressed as a categorical value. | |
| measurement | value_as_concept_id | int4 | 10 | √ | null | A foreign key to a Measurement result represented as a Concept from the Standardized Vocabularies (e.g., positive/negative, present/absent, low/high, etc.). | |
| observation | value_as_concept_id | int4 | 10 | √ | null | A foreign key to an observation result stored as a Concept ID. This is applicable to observations where the result can be expressed as a Standard Concept from the Standardized Vocabularies (e.g., positive/negative, present/absent, low/high, etc.). | |
| visit_occurrence | visit_concept_id | int4 | 10 | A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies. | |||
| visit_detail | visit_detail_concept_id | int4 | 10 | A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies. | |||
| condition_occurrence | visit_detail_id | int4 | 10 | √ | null | A foreign key to the visit in the VISIT_DETAIL table during which the Condition was determined (diagnosed). | |
| device_exposure | visit_detail_id | int4 | 10 | √ | null | A foreign key to the visit in the visit-detail table during which the Drug Exposure was initiated. | |
| drug_exposure | visit_detail_id | int4 | 10 | √ | null | A foreign key to the visit in the VISIT_DETAIL table during which the Drug Exposure was initiated. | |
| measurement | visit_detail_id | int4 | 10 | √ | null | A foreign key to the Visit in the VISIT_DETAIL table during which the Measurement was recorded. | |
| note | visit_detail_id | int4 | 10 | √ | null | ||
| observation | visit_detail_id | int4 | 10 | √ | null | A foreign key to the visit in the VISIT_DETAIL table during which the observation was recorded. | |
| procedure_occurrence | visit_detail_id | int4 | 10 | √ | null | A foreign key to the visit in the visit table during which the Procedure was carried out. | |
| visit_detail | visit_detail_id | int4 | 10 | A unique identifier for each Person's visit or encounter at a healthcare provider. | |||
| visit_detail | visit_detail_parent_id | int4 | 10 | √ | null | A foreign key to the VISIT_DETAIL table record to represent the immediate parent visit-detail record. | |
| condition_occurrence | visit_occurrence_id | int4 | 10 | √ | null | A foreign key to the visit in the VISIT_OCCURRENCE table during which the Condition was determined (diagnosed). | |
| device_exposure | visit_occurrence_id | int4 | 10 | √ | null | A foreign key to the visit in the VISIT table during which the device was used. | |
| drug_exposure | visit_occurrence_id | int4 | 10 | √ | null | A foreign key to the visit in the visit table during which the Drug Exposure was initiated. | |
| measurement | visit_occurrence_id | int4 | 10 | √ | null | A foreign key to the Visit in the VISIT_OCCURRENCE table during which the Measurement was recorded. | |
| note | visit_occurrence_id | int4 | 10 | √ | null | Foreign key to the Visit in the VISIT_OCCURRENCE table when the Note was taken. | |
| observation | visit_occurrence_id | int4 | 10 | √ | null | A foreign key to the visit in the VISIT_OCCURRENCE table during which the observation was recorded. | |
| procedure_occurrence | visit_occurrence_id | int4 | 10 | √ | null | A foreign key to the visit in the visit table during which the Procedure was carried out. | |
| visit_detail | visit_occurrence_id | int4 | 10 | √ | null | A foreign key that refers to the record in the VISIT_OCCURRENCE table. This is a required field, because for every visit_detail is a child of visit_occurrence and cannot exist without a corresponding parent record in visit_occurrence. | |
| visit_occurrence | visit_occurrence_id | int4 | 10 | A unique identifier for each Person's visit or encounter at a healthcare provider. | |||
| visit_detail | visit_source_concept_id | int4 | 10 | √ | null | A foreign key to a Concept that refers to the code used in the source. | |
| visit_occurrence | visit_source_concept_id | int4 | 10 | √ | null | A foreign key to a Concept that refers to the code used in the source. | |
| visit_detail | visit_type_concept_id | int4 | 10 | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the visit record is derived. | |||
| visit_occurrence | visit_type_concept_id | int4 | 10 | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the visit record is derived. | |||
| vocabulary | vocabulary_concept_id | int4 | 10 | A foreign key that refers to a standard concept identifier in the CONCEPT table for the Vocabulary the VOCABULARY record belongs to. | |||
| person | year_of_birth | int4 | 10 | The year of birth of the person. For data sources with date of birth, the year is extracted. For data sources where the year of birth is not available, the approximate year of birth is derived based on any age group categorization available. | |||
| provider | year_of_birth | int4 | 10 | √ | null | The year of birth of the Provider. | |
| note_nlp | note_nlp_id | int8 | 19 | A unique identifier for each term extracted from a note. | |||
| cost | amount_allowed | numeric | 131089 | √ | null | The contracted amount agreed between the payer and provider. | |
| drug_strength | amount_value | numeric | 131089 | √ | null | The numeric value associated with the amount of active ingredient contained within the product. | |
| drug_strength | denominator_value | numeric | 131089 | √ | null | The amount of total liquid (or other divisible product, such as ointment, gel, spray, etc.). | |
| dose_era | dose_value | numeric | 131089 | The numeric value of the dose. | |||
| drug_strength | numerator_value | numeric | 131089 | √ | null | The numeric value associated with the concentration of the active ingredient contained in the product | |
| cost | paid_by_patient | numeric | 131089 | √ | null | The total amount paid by the Person as a share of the expenses. | |
| cost | paid_by_payer | numeric | 131089 | √ | null | The amount paid by the Payer for the goods or services. | |
| cost | paid_by_primary | numeric | 131089 | √ | null | The amount paid by a primary Payer through the coordination of benefits. | |
| cost | paid_dispensing_fee | numeric | 131089 | √ | null | The amount paid by the Payer to a pharmacy for dispensing a drug, excluding the amount paid for the drug ingredient. paid_dispensing_fee contributes to the paid_by_payer field if this field is populated with a nonzero value. | |
| cost | paid_ingredient_cost | numeric | 131089 | √ | null | The amount paid by the Payer to a pharmacy for the drug, excluding the amount paid for dispensing the drug. paid_ingredient_cost contributes to the paid_by_payer field if this field is populated with a nonzero value. | |
| cost | paid_patient_coinsurance | numeric | 131089 | √ | null | The amount paid by the Person as a joint assumption of risk. Typically, this is a percentage of the expenses defined by the Payer Plan after the Person's deductible is exceeded. | |
| cost | paid_patient_copay | numeric | 131089 | √ | null | The amount paid by the Person as a fixed contribution to the expenses. | |
| cost | paid_patient_deductible | numeric | 131089 | √ | null | The amount paid by the Person that is counted toward the deductible defined by the Payer Plan. paid_patient_deductible does contribute to the paid_by_patient variable. | |
| drug_exposure | quantity | numeric | 131089 | √ | null | The quantity of drug as recorded in the original prescription or dispensing record. | |
| specimen | quantity | numeric | 131089 | √ | null | The amount of specimen collection from the person during the sampling procedure. | |
| measurement | range_high | numeric | 131089 | √ | null | The upper limit of the normal range of the Measurement. The upper range is assumed to be of the same unit of measure as the Measurement value. | |
| measurement | range_low | numeric | 131089 | √ | null | The lower limit of the normal range of the Measurement result. The lower range is assumed to be of the same unit of measure as the Measurement value. | |
| cost | total_charge | numeric | 131089 | √ | null | The total amount charged by some provider of goods or services (e.g. hospital, physician pharmacy, dme provider) to payers (insurance companies, the patient). | |
| cost | total_cost | numeric | 131089 | √ | null | The cost incurred by the provider of goods or services. | |
| cost | total_paid | numeric | 131089 | √ | null | The total amount actually paid from all payers for goods or services of the provider. | |
| cohort_attribute | value_as_number | numeric | 131089 | √ | null | The attribute result stored as a number. This is applicable to attributes where the result is expressed as a numeric value. | |
| measurement | value_as_number | numeric | 131089 | √ | null | A Measurement result where the result is expressed as a numeric value. | |
| observation | value_as_number | numeric | 131089 | √ | null | The observation result stored as a number. This is applicable to observations where the result is expressed as a numeric value. | |
| attribute_definition | attribute_description | text |<PHONE_NUMBER> | √ | null | A complete description of the Attribute definition | |
| attribute_definition | attribute_syntax | text |<PHONE_NUMBER> | √ | null | Syntax or code to operationalize the Attribute definition | |
| cohort_definition | cohort_definition_description | text |<PHONE_NUMBER> | √ | null | A complete description of the Cohort definition | |
| cohort_definition | cohort_definition_syntax | text |<PHONE_NUMBER> | √ | null | Syntax or code to operationalize the Cohort definition | |
| note | note_text | text |<PHONE_NUMBER> | The content of the Note. | |||
| drug_exposure | sig | text |<PHONE_NUMBER> | √ | null | The directions ("signetur") on the Drug prescription as recorded in the original prescription (and printed on the container) or dispensing record. | |
| cdm_source | source_description | text |<PHONE_NUMBER> | √ | null | A description of the source data origin and purpose for collection. The description may contain a summary of the period of time that is expected to be covered by this dataset. | |
| person | birth_datetime | timestamp | 29,6 | √ | null | The date and time of birth of the person. | |
| condition_occurrence | condition_end_datetime | timestamp | 29,6 | √ | null | The date when the instance of the Condition is considered to have ended. | |
| condition_occurrence | condition_start_datetime | timestamp | 29,6 | The date and time when the instance of the Condition is recorded. | |||
| death | death_datetime | timestamp | 29,6 | √ | null | The date and time the person was deceased. If the precise date including day or month is not known or not allowed, December is used as the default month, and the last day of the month the default day. | |
| device_exposure | device_exposure_end_datetime | timestamp | 29,6 | √ | null | The date and time the Device or supply was removed from use. | |
| device_exposure | device_exposure_start_datetime | timestamp | 29,6 | The date and time the Device or supply was applied or used. | |||
| drug_exposure | drug_exposure_end_datetime | timestamp | 29,6 | √ | null | The end date and time for the current instance of Drug utilization. It is not available from all sources. | |
| drug_exposure | drug_exposure_start_datetime | timestamp | 29,6 | The start date and time for the current instance of Drug utilization. Valid entries include a start date of a prescription, the date a prescription was filled, or the date on which a Drug administration procedure was recorded. | |||
| measurement | measurement_datetime | timestamp | 29,6 | √ | null | The date and time of the Measurement. Some database systems don't have a datatype of time. To accomodate all temporal analyses, datatype datetime can be used (combining measurement_date and measurement_time [forum discussion](http://forums.ohdsi.org/t/date-time-and-datetime-problem-and-the-world-of-hours-and-1day/314)) | |
| note_nlp | nlp_datetime | timestamp | 29,6 | √ | null | The date and time of the note processing. Useful for data provenance. | |
| note | note_datetime | timestamp | 29,6 | √ | null | The date and time the note was recorded. | |
| observation | observation_datetime | timestamp | 29,6 | √ | null | The date and time of the observation. | |
| observation_period | observation_period_end_datetime | timestamp | 29,6 | ||||
| observation_period | observation_period_start_datetime | timestamp | 29,6 | ||||
| procedure_occurrence | procedure_datetime | timestamp | 29,6 | The date and time on which the Procedure was performed. | |||
| specimen | specimen_datetime | timestamp | 29,6 | √ | null | The date and time on the date when the Specimen was obtained from the person. | |
| visit_detail | visit_end_datetime | timestamp | 29,6 | √ | null | The date and time of the visit end. | |
| visit_occurrence | visit_end_datetime | timestamp | 29,6 | √ | null | The date and time of the visit end. | |
| visit_detail | visit_start_datetime | timestamp | 29,6 | √ | null | The date and time of the visit started. | |
| visit_occurrence | visit_start_datetime | timestamp | 29,6 | √ | null | The date and time of the visit started. | |
| relationship | defines_ancestry | varchar | 1 | Defines whether a hierarchical relationship contributes to the concept_ancestor table. These are subsets of the hierarchical relationships. Valid values are 1 or 0. | |||
| concept | invalid_reason | varchar | 1 | √ | null | Reason the Concept was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value. | |
| concept_relationship | invalid_reason | varchar | 1 | √ | null | Reason the relationship was invalidated. Possible values are 'D'(deleted), 'U'(replaced with an update) or NULL when valid_end_date has the default value. | |
| drug_strength | invalid_reason | varchar | 1 | √ | null | Reason the concept was invalidated. Possible values are 'D'(deleted), 'U'(replaced with an update) or NULL when valid_end_date has the default value. | |
| source_to_concept_map | invalid_reason | varchar | 1 | √ | null | Reason the mapping instance was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value. | |
| relationship | is_hierarchical | varchar | 1 | Defines whether a relationship defines concepts into classes or hierarchies. Values are 1 for hierarchical relationship or 0 if not. | |||
| concept | standard_concept | varchar | 1 | √ | null | This flag determines where a Concept is a Standard Concept, i.e. is used in the data, a Classification Concept, or a non-standard Source Concept. The allowables values are 'S'(Standard Concept) and 'C'(Classification Concept), otherwise the content is NULL. | |
| note_nlp | term_exists | varchar | 1 | √ | null | A summary modifier that signifies presence or absence of the term for a given patient. Useful for quick querying. * | |
| location | state | varchar | 2 | √ | null | The state field as it appears in the source data. | |
| cost | drg_source_value | varchar | 3 | √ | null | The 3-digit DRG source code as it appears in the source data. | |
| location | zip | varchar | 9 | √ | null | The zip or postal code. | |
| cdm_source | cdm_version | varchar | 10 | √ | null | The version of CDM used | |
| concept | concept_class_id | varchar | 20 | The attribute or concept class of the Concept. Examples are 'Clinical Drug', 'Ingredient', 'Clinical Finding'etc. | |||
| concept_class | concept_class_id | varchar | 20 | A unique key for each class. | |||
| cost | cost_domain_id | varchar | 20 | The concept representing the domain of the cost event, from which the corresponding table can be inferred that contains the entity for which cost information is recorded. | |||
| location | county | varchar | 20 | √ | null | The county. | |
| provider | dea | varchar | 20 | √ | null | The Drug Enforcement Administration (DEA) number of the provider. | |
| concept | domain_id | varchar | 20 | A foreign key to the [DOMAIN](https://github.com/OHDSI/CommonDataModel/wiki/DOMAIN) table the Concept belongs to. | |||
| domain | domain_id | varchar | 20 | A unique key for each domain. | |||
| provider | npi | varchar | 20 | √ | null | The National Provider Identifier (NPI) of the provider. | |
| concept_relationship | relationship_id | varchar | 20 | A unique identifier to the type or nature of the Relationship as defined in the [RELATIONSHIP](https://github.com/OHDSI/CommonDataModel/wiki/RELATIONSHIP) table. | |||
| relationship | relationship_id | varchar | 20 | The type of relationship captured by the relationship record. | |||
| relationship | reverse_relationship_id | varchar | 20 | The identifier for the relationship used to define the reverse relationship between two concepts. | |||
| source_to_concept_map | source_vocabulary_id | varchar | 20 | A foreign key to the VOCABULARY table defining the vocabulary of the source code that is being translated to a Standard Concept. | |||
| condition_occurrence | stop_reason | varchar | 20 | √ | null | The reason that the condition was no longer present, as indicated in the source data. | |
| drug_exposure | stop_reason | varchar | 20 | √ | null | The reason the Drug was stopped. Reasons include regimen completed, changed, removed, etc. | |
| source_to_concept_map | target_vocabulary_id | varchar | 20 | A foreign key to the VOCABULARY table defining the vocabulary of the target Concept. | |||
| concept | vocabulary_id | varchar | 20 | A foreign key to the [VOCABULARY](https://github.com/OHDSI/CommonDataModel/wiki/VOCABULARY) table indicating from which source the Concept has been adapted. | |||
| vocabulary | vocabulary_id | varchar | 20 | A unique identifier for each Vocabulary, such as ICD9CM, SNOMED, Visit. | |||
| cdm_source | vocabulary_version | varchar | 20 | √ | null | The version of the vocabulary used | |
| cdm_source | cdm_source_abbreviation | varchar | 25 | √ | null | An abbreviation of the name | |
| location | address_1 | varchar | 50 | √ | null | The address field 1, typically used for the street address, as it appears in the source data. | |
| location | address_2 | varchar | 50 | √ | null | The address field 2, typically used for additional detail such as buildings, suites, floors, as it appears in the source data. | |
| visit_detail | admitting_source_value | varchar | 50 | √ | null | The source code for the admitting source as it appears in the source data. | |
| visit_occurrence | admitting_source_value | varchar | 50 | √ | null | The source code for the admitting source as it appears in the source data. | |
| specimen | anatomic_site_source_value | varchar | 50 | √ | null | The information about the anatomic site as detailed in the source. | |
| care_site | care_site_source_value | varchar | 50 | √ | null | The identifier for the Care Site in the source data, stored here for reference. | |
| death | cause_source_value | varchar | 50 | √ | null | The source code for the cause of death as it appears in the source data. This code is mapped to a standard concept in the Standardized Vocabularies and the original code is, stored here for reference. | |
| location | city | varchar | 50 | √ | null | The city field as it appears in the source data. | |
| concept | concept_code | varchar | 50 | The concept code represents the identifier of the Concept in the source vocabulary, such as SNOMED-CT concept IDs, RxNorm RXCUIs etc. Note that concept codes are not unique across vocabularies. | |||
| condition_occurrence | condition_source_value | varchar | 50 | √ | null | The source code for the condition as it appears in the source data. This code is mapped to a standard condition concept in the Standardized Vocabularies and the original code is stored here for reference. | |
| condition_occurrence | condition_status_source_value | varchar | 50 | √ | null | The source code for the condition status as it appears in the source data. | |
| visit_detail | discharge_to_source_value | varchar | 50 | √ | null | The source code for the discharge disposition as it appears in the source data. | |
| visit_occurrence | discharge_to_source_value | varchar | 50 | √ | null | The source code for the discharge disposition as it appears in the source data. | |
| specimen | disease_status_source_value | varchar | 50 | √ | null | The information about the disease status as detailed in the source. | |
| drug_exposure | dose_unit_source_value | varchar | 50 | √ | null | The information about the dose unit as detailed in the source. | |
| drug_exposure | drug_source_value | varchar | 50 | √ | null | The source code for the Drug as it appears in the source data. This code is mapped to a Standard Drug concept in the Standardized Vocabularies and the original code is, stored here for reference. | |
| person | ethnicity_source_value | varchar | 50 | √ | null | The source code for the ethnicity of the person as it appears in the source data. The person ethnicity is mapped to a standard ethnicity concept in the Standardized Vocabularies and the original code is, stored here for reference. | |
| payer_plan_period | family_source_value | varchar | 50 | √ | null | The source code for the Person's family as it appears in the source data. | |
| person | gender_source_value | varchar | 50 | √ | null | The source code for the gender of the person as it appears in the source data. The person?s gender is mapped to a standard gender concept in the Standardized Vocabularies; the original value is stored here for reference. | |
| provider | gender_source_value | varchar | 50 | √ | null | The gender code for the Provider as it appears in the source data, stored here for reference. | |
| location | location_source_value | varchar | 50 | √ | null | The verbatim information that is used to uniquely identify the location as it appears in the source data. | |
| drug_exposure | lot_number | varchar | 50 | √ | null | An identifier assigned to a particular quantity or lot of Drug product from the manufacturer. | |
| measurement | measurement_source_value | varchar | 50 | √ | null | The Measurement name as it appears in the source data. This code is mapped to a Standard Concept in the Standardized Vocabularies and the original code is stored here for reference. | |
| note | note_source_value | varchar | 50 | √ | null | The source value associated with the origin of the note | |
| observation | observation_source_value | varchar | 50 | √ | null | The observation code as it appears in the source data. This code is mapped to a Standard Concept in the Standardized Vocabularies and the original code is, stored here for reference. | |
| payer_plan_period | payer_source_value | varchar | 50 | √ | null | The source code for the payer as it appears in the source data. | |
| person | person_source_value | varchar | 50 | √ | null | An (encrypted) key derived from the person identifier in the source data. This is necessary when a use case requires a link back to the person data at the source dataset. | |
| care_site | place_of_service_source_value | varchar | 50 | √ | null | The source code for the Place of Service as it appears in the source data, stored here for reference. | |
| payer_plan_period | plan_source_value | varchar | 50 | √ | null | The source code for the Person's health benefit plan as it appears in the source data. | |
| procedure_occurrence | procedure_source_value | varchar | 50 | √ | null | The source code for the Procedure as it appears in the source data. This code is mapped to a standard procedure Concept in the Standardized Vocabularies and the original code is, stored here for reference. Procedure source codes are typically ICD-9-Proc, CPT-4, HCPCS or OPCS-4 codes. | |
| provider | provider_source_value | varchar | 50 | √ | null | The identifier used for the Provider in the source data, stored here for reference. | |
| observation | qualifier_source_value | varchar | 50 | √ | null | The source value associated with a qualifier to characterize the observation | |
| procedure_occurrence | qualifier_source_value | varchar | 50 | √ | null | The source code for the qualifier as it appears in the source data. | |
| person | race_source_value | varchar | 50 | √ | null | The source code for the race of the person as it appears in the source data. The person race is mapped to a standard race concept in the Standardized Vocabularies and the original value is stored here for reference. | |
| cost | revenue_code_source_value | varchar | 50 | √ | null | The source code for the Revenue code as it appears in the source data, stored here for reference. | |
| drug_exposure | route_source_value | varchar | 50 | √ | null | The information about the route of administration as detailed in the source. | |
| source_to_concept_map | source_code | varchar | 50 | The source code being translated into a Standard Concept. | |||
| provider | specialty_source_value | varchar | 50 | √ | null | The source code for the Provider specialty as it appears in the source data, stored here for reference. | |
| specimen | specimen_source_id | varchar | 50 | √ | null | The Specimen identifier as it appears in the source data. | |
| specimen | specimen_source_value | varchar | 50 | √ | null | The Specimen value as it appears in the source data. This value is mapped to a Standard Concept in the Standardized Vocabularies and the original code is, stored here for reference. | |
| note_nlp | term_temporal | varchar | 50 | √ | null | ||
| device_exposure | unique_device_id | varchar | 50 | √ | null | A UDI or equivalent identifying the instance of the Device used in the Person. | |
| measurement | unit_source_value | varchar | 50 | √ | null | The source code for the unit as it appears in the source data. This code is mapped to a standard unit concept in the Standardized Vocabularies and the original code is stored here for reference. | |
| observation | unit_source_value | varchar | 50 | √ | null | The source code for the unit as it appears in the source data. This code is mapped to a standard unit concept in the Standardized Vocabularies and the original code is, stored here for reference. | |
| specimen | unit_source_value | varchar | 50 | √ | null | The information about the Unit as detailed in the source. | |
| measurement | value_source_value | varchar | 50 | √ | null | The source value associated with the content of the value_as_number or value_as_concept_id as stored in the source data. | |
| visit_detail | visit_source_value | varchar | 50 | √ | null | The source code for the visit as it appears in the source data. | |
| visit_occurrence | visit_source_value | varchar | 50 | √ | null | The source code for the visit as it appears in the source data. | |
| observation | value_as_string | varchar | 60 | √ | null | The observation result stored as a string. This is applicable to observations where the result is expressed as verbatim text. | |
| device_exposure | device_source_value | varchar | 100 | √ | null | The source code for the Device as it appears in the source data. This code is mapped to a standard Device Concept in the Standardized Vocabularies and the original code is stored here for reference. | |
| note_nlp | lexical_variant | varchar | 250 | Raw text extracted from the NLP tool. | |||
| note_nlp | nlp_system | varchar | 250 | √ | null | Name and version of the NLP system that extracted the term.Useful for data provenance. | |
| note | note_title | varchar | 250 | √ | null | The title of the Note as it appears in the source. | |
| note_nlp | offset | varchar | 250 | √ | null | Character offset of the extracted term in the input note. | |
| note_nlp | snippet | varchar | 250 | √ | null | A small window of text surrounding the term. | |
| attribute_definition | attribute_name | varchar | 255 | A short description of the Attribute. | |||
| care_site | care_site_name | varchar | 255 | √ | null | The verbatim description or name of the Care Site as in data source | |
| cdm_source | cdm_etl_reference | varchar | 255 | √ | null | URL or other external reference to location of ETL specification documentation and ETL source code | |
| cdm_source | cdm_holder | varchar | 255 | √ | null | The name of the organization responsible for the development of the CDM instance | |
| cdm_source | cdm_source_name | varchar | 255 | The full name of the source | |||
| cohort_definition | cohort_definition_name | varchar | 255 | A short description of the Cohort. | |||
| concept_class | concept_class_name | varchar | 255 | The name describing the Concept Class, e.g. "Clinical Finding", "Ingredient", etc. | |||
| concept | concept_name | varchar | 255 | An unambiguous, meaningful and descriptive name for the Concept. | |||
| domain | domain_name | varchar | 255 | The name describing the Domain, e.g. "Condition", "Procedure", "Measurement" etc. | |||
| provider | provider_name | varchar | 255 | √ | null | A description of the Provider. | |
| relationship | relationship_name | varchar | 255 | The text that describes the relationship type. | |||
| source_to_concept_map | source_code_description | varchar | 255 | √ | null | An optional description for the source code. This is included as a convenience to compare the description of the source code to the name of the concept. | |
| cdm_source | source_documentation_reference | varchar | 255 | √ | null | URL or other external reference to location of source documentation | |
| vocabulary | vocabulary_name | varchar | 255 | The name describing the vocabulary, for example "International Classification of Diseases, Ninth Revision, Clinical Modification, Volume 1 and 2 (NCHS)" etc. | |||
| vocabulary | vocabulary_reference | varchar | 255 | √ | null | External reference to documentation or available download of the about the vocabulary. | |
| vocabulary | vocabulary_version | varchar | 255 | √ | null | Version of the Vocabulary as indicated in the source. | |
| concept_synonym | concept_synonym_name | varchar | 1000 | The alternative name for the Concept. | |||
| note_nlp | term_modifiers | varchar | 2000 | √ | null |


PLEASANTVILLE (director/writer:Gary Ross; cinematographer: John Lindley; cast:Tobey Maguire (David/Bud Parker), Jeff Daniels (Johnson), Joan Allen (Betty Parker),William H. Macy (George Parker), J.T. Walsh (Big Bob), Don Knotts (TV Repairman), Marley Shelton (Margaret), Jane Kaczmarek (David's Mom), Reese Witherspoon (Jennifer/Mary Sue Parker), 1998)
Reviewed by Dennis Schwartz
Obviously there is no such a place as Pleasantville, except in a sitcom. But Pleasantville the movie and the sitcom in the movie, is made into an idealized homogenous (all white) illusionary place, where a brother and sister will be transported into this never-never land of TV fantasy of the 1950s and 1960s, where everyone is repressed and seen in black-and-white sitcom form, reminiscent of shows like Father Knows Best, The Donna Reed Show, and The Adventures of Ozzie & Harriet.
Pleasantville is a film about how selective one's memory is when it comes to nostalgia, of pining for values that never existed back then but still are the values exemplified for the traditional family, of the resistance to change, and clashes between those in the film who become "colored" and those who remain in "black-and-white," and about the need to be an individual and not conform.
Pleasantville opens in the '90s, where a fast lifestyle and family dysfunctionality seem to be the norm. Teenagers David (Tobey Maguire) and Jennifer (Reese Witherspoon) are the twins of a troubled single- parent (Jane), who is never there for them. At night, with their mom out on a date, David is all keyed up to watch a marathon of his favorite TV program, Pleasantville, of which he is an expert on, knowing every character and minor detail about the show. Meanwhile, Jenn has a heavy date with a hunk she wants to be romantic with while watching MTV. The twins end up fighting over the remote for the TV show they want to see and it breaks apart, but bingo, a TV repairman (Don Knotts) who wasn't even called by them appears at their door and gives them a new magical remote (supposedly coming here because of David's true love and knowledge of the Pleasantville TV show), and with the new remote switched on, the twins are now trapped in the TV program Pleasantville, taking the place of the TV siblings Bud and Mary Sue. They are now in a place where people regularly say swell and keen, the weather is always perfect at 72 degrees, there is no such thing as rain, no colors (therefore no discrimination), no sex, no profanity, no fires (firemen only rescue cats), and everything is just peachy. Their new parents are the perfect couple George (William H. Macy) and Betty (Joan Allen), whose idea of marriage revolves around each of them knowing their place- he works and she stays home with a smile on her face, while kept busy by cleaning, cooking, and taking care of the children.
David and Jenn have a different outlook on life, with him relating to the simple existence of Pleasantville and upset that he can't fit in with the turbulent '90s: he finds it hard to talk to girls his age, in class he is upset to hear about incurable diseases, ozone depletion, and a tough job market. While Jenn is content with the "new age" freedom of the '90s in sex and not interested in anything that is not "cool."
It's fairly predictable what will happen once the two realize that they are transformed into an unreal TV world, as the film prepares to go into its satire mold and take apart the blandness of such perfection. David has no problem getting right into the program, while Jenn calls this place "Nerdville" and wants out immediately. The calendar permanently reads 1958, but the two, are stuck with their '90s views on things. At school everything seems more innocent and less tense, dates take place over ice cream sodas and cheese burgers, and being pinned means holding hands not having sex, the basketball team wins every game, and there is nothing really to learn in school that is perplexing because there is nothing outside of Pleasantville. But this changes when Jenn asks questions about what is outside of Pleasantville and takes her boyfriend to lover's lane for some serious sex. When things change, colors start to appear, it seems as if Jenn/Mary Sue has begun to upset the universe for these naive folks.
As expected, the siblings can't help but disrupt this simplistic community after living in a supposedly more sophisticated time period, and such things as color, emotions, jealousies, sex, conflicts, makeup for women, and other changes are now brought into this insular community like diseases transmitted to the modern world. The filmmaker then analyzes these changes on those newly affected and the result is a more troubled but more interesting people emerging. Through special effects from digital processing, flowers start taking on color and the film begins to have a modern-day "Alice in Wonderland" look to it.
Jeff Daniels plays the stunted soda shop owner (Mr. Johnson) who makes Betty sexually aware of herself and who blossoms when Bud/David gives him art books and he discovers he can paint in colors. The movie makes the point that the revolutionary changes in the '60s came about when people became dissatisfied with the staidness of the '50s and began to experiment and expand their horizons. J.T. Walsh is Big Bob, the mayor of the town, in an uninspiring role as the most ardent one against change.
There was something that rubbed me the wrong way about this "cute" idea of a film, besides the fact it was boring and I felt as if I was being lectured to about the obvious general ills of society. There are no radical new ideas presented in this film that will make me really think about these issues any differently than the films of the 1950s would have; it is as if the filmmaker is saying that 1950s didn't have films that were critical of society: but a list of such films would be very extensive (Marty, High Noon, Ace in the Hole, etc.). This snooty attitude, looking down at the past from the vantage point of a supposedly "hip" new age bothered me. Afterall, my impression of this film, is that it really is a 1950s sitcom merging with a 1990s "feel good" type of sitcom, and nothing more. It is basically, a gimmicky film, which is the only new ground it breaks, selling an idea about the past that connects it with the present, but doing it at the expense of telling the truth about neither the past or present.
The film presumes that through the efforts of these spoiled teens, that they will break through the "ignorance is bliss community" and bring about art and literature and a more enlightened attitude toward sex, and to inspire a climate for more responsible social changes. The film is trying to say that the innocence of the 1950s must be merged with the social awareness of the 1990s and this can only be accomplished by the teenage heroes, who are not afraid to take chances and change the times they're in. I just didn't buy into this premise and was not convinced that I wasn't seeing anything but a superficial film. For instance, having Jenn/Mary Sue substitute her new ideas of sexual feelings by reading "Lady Chatterley's Lover" instead of going out with her boyfriend and having sex, seemed to me to be a phony response to what literature can offer. Character development is a raising of consciousness that comes about only through a real inward awareness, a book can only act as a catalyst for that experience. What is offered movie-wise, is just the kind of empty gestures made to genuine problems, which can be found on TV programs from both yesterday and today. Therefore it is just another empty gesture at culture, trying to be cute, letting the baby boomers know that it's okay, there're doing just fine. You can keep being materialists, just be cool about it! And by not upsetting the apple cart, just railing against the general ills of society, the filmmaker has succeeded in tapping into a huge audience by not being probative enough, allowing the film's nostalgia to play for it rather than to make one really tune into the '90s aspect of the film it brings up about the real problems this society faces that are not being met, such as, families in crises situations, environments being raped, art and literature being more removed from mainstream America than ever before, schools that can't educate most of their students effectively, a continuation of bland TV programs (getting more obscene is not necessarily an advancement), and a society that is confused about the values it thinks are important. The film has simply lost track of its critique of society, and has failed to show how one age has evolved from another, with each age being misled by those trying to force its values onto another age. There was no one in this film who understood how to bridge the past with the future, instead this becomes a film just like the sitcoms it parodies, which means it's just another escape film, unable or unwilling to delve deeply into all the real problems it brings up.
REVIEWED ON 9/30/99 GRADE: C-
Dennis Schwartz: "Ozus' World Movie Reviews"
http://www.sover.net/~ozus
<EMAIL_ADDRESS>© ALL RIGHTS RESERVED DENNIS SCHWARTZ
The review above was posted to the
rec.arts.movies.reviews newsgroup (de.rec.film.kritiken for German reviews).
The Internet Movie Database accepts no responsibility for the contents of the
review and has no editorial control. Unless stated otherwise, the copyright
belongs to the author.
Please direct comments/criticisms of the review to relevant newsgroups.
Broken URLs inthe reviews are the responsibility of the author.
The formatting of the review is likely to differ from the original due
to ASCII to HTML conversion.
Related links: index of all rec.arts.movies.reviews reviews


First Name:
Last Name:
Email:
Phone:
Name previous favorite NFL team if there is one
Why are you leaving your previous team?
Favorite Offensive Vikings player
Favorite Defensive Vikings player
Favorite Special Teams Vikings player
Comments


|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object Activity org.robobrain.sdk.GameActivity
public class GameActivity
A GameActivity creates a full screen OpenGL window and provides methods for registering and your game's Engine object with the Renderer. This class is not meant to be instantiated. Derive your game's Activity from this class.
| Field Summary | |
|---|---|
protected Engine |
mGame
The game's Engine. |
protected GLView |
mGLView
A View that manages the OpenGL Renderer. |
protected static Context |
sContext
The GameActivity's Context. |
| Constructor Summary | |
|---|---|
GameActivity()
|
| Method Summary | |
|---|---|
static Context |
getContext()
Gets the Activity's application Context. |
void |
initRenderer(int width,
int height)
Initializes the OpenGL renderer. |
void |
onCreate(Bundle savedInstanceState)
Called when the activity is starting. |
protected void |
onDestroy()
Perform any final cleanup before an activity is destroyed. |
protected void |
onPause()
Called as part of the activity lifecycle when an activity is going into the background, but has not (yet) been killed. |
protected void |
onResume()
Called after onRestoreInstanceState(Bundle), onRestart(), or onPause(), for your activity to start interacting with the user. |
void |
registerGame(Engine game)
Registers a game Engine class to be used by this Activity to run a game. |
void |
setBackgroundColor(Color color)
Sets the background color of the Activity |
void |
setTargetSize(int width,
int height)
Sets the ideal width and height for your game. |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Field Detail |
|---|
protected Engine mGame
protected static Context sContext
protected GLView mGLView
| Constructor Detail |
|---|
public GameActivity()
| Method Detail |
|---|
public void onCreate(Bundle savedInstanceState)
protected void onResume()
protected void onPause()
protected void onDestroy()
public void setBackgroundColor(Color color)
public void registerGame(Engine game)
public void initRenderer(int width, int height)
width
- Width in pixels of the desired screen.height
- Height in pixels of the desired screen.public void setTargetSize(int width, int height)
Width
- in pixels of the screen.Height
- in pixels of the screen.public static Context getContext()
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |


FEND Travel App
submission by Joachim Klug
Plan your trip
Destinationnn:
Start date:
End date:
Plan my trip


Welcome to my new hand written website.  Check out the source on
github,
it is intended to be easy to read and understand.
This site is an experiment in building from scratch, simply to do so.
A personal reminder of the problems that the complexity of modern web
development has arisen to solve.


Gecode::Int::NegBoolView Class Reference
[Integer views]
Negated Boolean view. More...
#include <view.hpp>
Related Functions | |
(Note that these are not member functions.) | |
| template<class Char , class Traits > | |
| std::basic_ostream< Char, Traits > & | operator<< (std::basic_ostream< Char, Traits > &os, const NegBoolView &x) |
| Print negated Boolean view. | |
Domain status access | |
|
| |
| static const int | BITS = BoolView::BITS |
| How many bits does the status have. | |
| static const BoolStatus | ZERO = BoolView::ONE |
| Status of domain assigned to zero. | |
| static const BoolStatus | ONE = BoolView::ZERO |
| Status of domain assigned to one. | |
| static const BoolStatus | NONE = BoolView::NONE |
| Status of domain not yet assigned. | |
| BoolStatus | status (void) const |
| Return current domain status. | |
Constructors and initialization | |
|
| |
| NegBoolView (void) | |
| Default constructor. | |
| NegBoolView (const BoolView &y) | |
| Initialize with Boolean view y. | |
Boolean domain tests | |
|
| |
| bool | zero (void) const |
| Test whether view is assigned to be zero. | |
| bool | one (void) const |
| Test whether view is assigned to be one. | |
| bool | none (void) const |
| Test whether view is not yet assigned. | |
Boolean assignment operations | |
|
| |
| ModEvent | one (Space &home) |
| Try to assign view to one. | |
| ModEvent | zero (Space &home) |
| Try to assign view to zero. | |
| ModEvent | one_none (Space &home) |
| Assign not yet assigned view to one. | |
| ModEvent | zero_none (Space &home) |
| Assign not yet assigned view to zero. | |
Value access | |
|
| |
| int | min (void) const |
| Return minimum of domain. | |
| int | max (void) const |
| Return maximum of domain. | |
| int | val (void) const |
| Return assigned value (only if assigned). | |
Delta information for advisors | |
|
| |
| int | min (const Delta &d) const |
| Return minimum value just pruned. | |
| int | max (const Delta &d) const |
| Return maximum value just pruned. | |
| bool | any (const Delta &d) const |
| Test whether arbitrary values got pruned. | |
| static bool | zero (const Delta &d) |
| Test whether a view has been assigned to zero. | |
| static bool | one (const Delta &d) |
| Test whether a view has been assigned to one. |
Detailed Description
Negated Boolean view.
A negated Boolean view for a Boolean view provides operations such that behaves as .
Definition at line 1503 of file view.hpp.
Constructor & Destructor Documentation
| Gecode::Int::NegBoolView::NegBoolView | ( | void | ) | [inline] |
Default constructor.
Definition at line 50 of file neg-bool.hpp.
| Gecode::Int::NegBoolView::NegBoolView | ( | const BoolView & | y | ) | [inline, explicit] |
Initialize with Boolean view y.
Definition at line 52 of file neg-bool.hpp.
Member Function Documentation
| BoolStatus Gecode::Int::NegBoolView::status | ( | void | ) | const [inline] |
Return current domain status.
Definition at line 61 of file neg-bool.hpp.
| bool Gecode::Int::NegBoolView::zero | ( | void | ) | const [inline] |
Test whether view is assigned to be zero.
Definition at line 65 of file neg-bool.hpp.
| bool Gecode::Int::NegBoolView::one | ( | void | ) | const [inline] |
Test whether view is assigned to be one.
Definition at line 69 of file neg-bool.hpp.
| bool Gecode::Int::NegBoolView::none | ( | void | ) | const [inline] |
Test whether view is not yet assigned.
Definition at line 73 of file neg-bool.hpp.
Try to assign view to one.
Definition at line 96 of file neg-bool.hpp.
Try to assign view to zero.
Definition at line 92 of file neg-bool.hpp.
Assign not yet assigned view to one.
Definition at line 87 of file neg-bool.hpp.
Assign not yet assigned view to zero.
Definition at line 83 of file neg-bool.hpp.
| int Gecode::Int::NegBoolView::min | ( | void | ) | const [inline] |
Return minimum of domain.
Definition at line 106 of file neg-bool.hpp.
| int Gecode::Int::NegBoolView::max | ( | void | ) | const [inline] |
Return maximum of domain.
Definition at line 110 of file neg-bool.hpp.
| int Gecode::Int::NegBoolView::val | ( | void | ) | const [inline] |
Return assigned value (only if assigned).
Definition at line 114 of file neg-bool.hpp.
| int Gecode::Int::NegBoolView::min | ( | const Delta & | d | ) | const [inline] |
Return minimum value just pruned.
Definition at line 124 of file neg-bool.hpp.
| int Gecode::Int::NegBoolView::max | ( | const Delta & | d | ) | const [inline] |
Return maximum value just pruned.
Definition at line 128 of file neg-bool.hpp.
| bool Gecode::Int::NegBoolView::any | ( | const Delta & | d | ) | const [inline] |
Test whether arbitrary values got pruned.
Definition at line 132 of file neg-bool.hpp.
| bool Gecode::Int::NegBoolView::zero | ( | const Delta & | d | ) | [inline, static] |
Test whether a view has been assigned to zero.
Definition at line 136 of file neg-bool.hpp.
| bool Gecode::Int::NegBoolView::one | ( | const Delta & | d | ) | [inline, static] |
Test whether a view has been assigned to one.
Definition at line 140 of file neg-bool.hpp.
Friends And Related Function Documentation
| std::basic_ostream< Char, Traits > & operator<< | ( | std::basic_ostream< Char, Traits > & | os, | |
| const NegBoolView & | x | |||
| ) | [related] |
Member Data Documentation
const int Gecode::Int::NegBoolView::BITS = BoolView::BITS [static] |
const BoolStatus Gecode::Int::NegBoolView::ZERO = BoolView::ONE [static] |
const BoolStatus Gecode::Int::NegBoolView::ONE = BoolView::ZERO [static] |
const BoolStatus Gecode::Int::NegBoolView::NONE = BoolView::NONE [static] |
The documentation for this class was generated from the following files:
- gecode/int/view.hpp (Revision: 12418)
- gecode/int/view/neg-bool.hpp (Revision: 11118)


Singer Chris Brown holds high-end garage sale at his home
Chris Brown says he is having a high-end garage sale at his Los Angeles home, and a crowd has been gathering for hours.
The singer posted a flyer on his Instagram and Twitter accounts that included his home address in the Tarzana neighbourhood, and says the event started at 10am Wednesday and will go on until 7pm.
The flyer says the sale will feature “significantly marked-down high-end designer items”.
He captioned the posts: “DA CRIB … 2 day event.”
People began gathering at the house on Tuesday night, and a long line stretched down the pavement of the residential neighbourhood before the event Wednesday.
The house was the site of one of Brown’s many run-ins with the law, a 2016 police standoff that ended with his arrest.


Icons rely on an icon fonts located in assets/fonts
. The fonts was custom build using IcoMoon app.
To extend the font with additional characters, import selection.json
within the app, add in needed characters and export the font with “hyperaudio” as name and “icon-” as prefix.
Placing an icon on a page is as simple as add in a i
with appropriate class, for example:


Fast computation of access to opportunities given a selected
decay function. See details
for the available decay functions.
accessibility( r5r_core, origins, destinations, opportunities_colname = "opportunities", mode = "WALK", mode_egress = "WALK", departure_datetime = Sys.time(), time_window = 1L, percentiles = 50L, decay_function = "step", cutoffs = 30L, decay_value = 1, max_walk_dist = Inf, max_bike_dist = Inf, max_trip_duration = 120L, walk_speed = 3.6, bike_speed = 12, max_rides = 3, max_lts = 2, n_threads = Inf, verbose = TRUE )
| r5r_core | a rJava object to connect with R5 routing engine |
|---|---|
| origins, destinations | a spatial sf POINT object, or a data.frame containing the columns 'id', 'lon', 'lat' |
| opportunities_colname | string. The column name in the |
| mode | string. Transport modes allowed for the trips. Defaults to "WALK". See details for other options. |
| mode_egress | string. Transport mode used after egress from public transport. It can be either 'WALK', 'BICYCLE', or 'CAR'. Defaults to "WALK". |
| departure_datetime | POSIXct object. If working with public transport
networks, please check |
| time_window | numeric. Time window in minutes for which r5r will calculate travel times departing each minute. When using frequency-based GTFS files, 5 Monte Carlo simulations will be run for each minute in the time window. See details for further information. |
| percentiles | numeric vector. Defaults to '50', returning the accessibility value for the median travel time computed for a given time_window. If a numeric vector is passed, for example c(25, 50, 75), the function will return accessibility estimates for each percentile, by travel time cutoff. Only the first 5 cut points of the percentiles are considered. For more details, see R5 documentation at 'https://docs.conveyal.com/analysis/methodology#accounting-for-variability' |
| decay_function | string. Choice of one of the following decay functions:
'step', 'exponential', 'fixed_exponential', 'linear',
and 'logistic'. Defaults to 'step', which yields
cumulative opportunities accessibility metrics.
More info in |
| cutoffs | numeric. Cutoff times in minutes for calculating cumulative opportunities accessibility when using the 'step decay function'. This parameter has different effects for each of the other decay functions: it indicates the 'median' (or inflection point) of the decay curves in the 'logistic' and 'linear' functions, and the 'half-life' in the 'exponential' function. It has no effect when using the 'fixed exponential' function. |
| decay_value | numeric. Extra parameter to be passed to the selected
|
| max_walk_dist | numeric. Maximum walking distance (in meters) for the
whole trip. Defaults to no restrictions on walking, as
long as |
| max_bike_dist | numeric. Maximum cycling distance (in meters) for the
whole trip. Defaults to no restrictions on cycling, as
long as |
| max_trip_duration | numeric. Maximum trip duration in minutes. Defaults to 120 minutes (2 hours). |
| walk_speed | numeric. Average walk speed in km/h. Defaults to 3.6 km/h. |
| bike_speed | numeric. Average cycling speed in km/h. Defaults to 12 km/h. |
| max_rides | numeric. The max number of public transport rides allowed in the same trip. Defaults to 3. |
| max_lts | numeric (between 1 and 4). The maximum level of traffic stress that cyclists will tolerate. A value of 1 means cyclists will only travel through the quietest streets, while a value of 4 indicates cyclists can travel through any road. Defaults to 2. See details for more information. |
| n_threads | numeric. The number of threads to use in parallel computing. Defaults to use all available threads (Inf). |
| verbose | logical. |
A data.table with accessibility estimates for all origin points, by a given transport mode, and per travel time cutoff and percentile.
R5 allows for multiple decay functions. More info at https://docs.conveyal.com/learn-more/decay-functions The options include:
step
(cumulative opportunities)A binary decay function used to calculate cumulative opportunities metrics.
logistic
This is the logistic function, i.e. the cumulative distribution function of the logistic distribution, expressed such that its parameters are the median (inflection point) and standard deviation. This function applies a sigmoid rolloff that has a convenient relationship to discrete choice theory. Its parameters can be set to reflect a whole population's tolerance for making trips with different travel times. The function's value represents the probability that a randomly chosen member of the population would accept making a trip, given its duration. Opportunities are then weighted by how likely it is a person would consider them "reachable".
The median parameter is controlled by the cutoff
parameter, leaving only
the standard deviation to configure through the decay_value
parameter.
fixed_exponential
This function is of the form e-Lt where L is a single fixed decay constant in the range (0, 1). It is constrained to be positive to ensure weights decrease (rather than grow) with increasing travel time.
This function is controlled exclusively by the L constant, given by the
decay_value
parameter. Values provided in cutoffs
are ignored.
exponential
This is similar to the fixed-exponential option above, but in this case the
decay parameter is inferred from the cutoffs
parameter values, which is
treated as the half-life of the decay.
linear
This is a simple, vaguely sigmoid option, which may be useful when you have a sense of a maximum travel time that would be tolerated by any traveler, and a minimum time below which all travel is perceived to be equally easy.
The transition region is transposable and symmetric around the cutoffs
parameter values, taking decay_value
minutes to taper down from one to zero.
R5 allows for multiple combinations of transport modes. The options include:
TRAM, SUBWAY, RAIL, BUS, FERRY, CABLE_CAR, GONDOLA, FUNICULAR. The option 'TRANSIT' automatically considers all public transport modes available.
WALK, BICYCLE, CAR, BICYCLE_RENT, CAR_PARK
When cycling is enabled in R5, setting max_lts
will allow cycling only on
streets with a given level of danger/stress. Setting max_lts
to 1, for example,
will allow cycling only on separated bicycle infrastructure or low-traffic
streets; routing will revert to walking when traversing any links with LTS
exceeding 1. Setting max_lts
to 3 will allow cycling on links with LTS 1, 2,
or 3.
The default methodology for assigning LTS values to network edges is based on commonly tagged attributes of OSM ways. See more info about LTS at https://docs.conveyal.com/learn-more/traffic-stress. In summary:
LTS 1: Tolerable for children. This includes low-speed, low-volume streets, as well as those with separated bicycle facilities (such as parking-protected lanes or cycle tracks).
LTS 2: Tolerable for the mainstream adult population. This includes streets where cyclists have dedicated lanes and only have to interact with traffic at formal crossing.
LTS 3: Tolerable for “enthused and confident” cyclists. This includes streets which may involve close proximity to moderate- or high-speed vehicular traffic.
LTS 4: Tolerable for only “strong and fearless” cyclists. This includes streets where cyclists are required to mix with moderate- to high-speed vehicular traffic.
The accessibility()
function uses an R5-specific extension to the RAPTOR
routing algorithm (see Conway et al., 2017). This RAPTOR extension uses a
systematic sample of one departure per minute over the time window set by the
user in the 'time_window' parameter. A detailed description of base RAPTOR
can be found in Delling et al (2015).
Conway, M. W., Byrd, A., & van der Linden, M. (2017). Evidence-based transit and land use sketch planning using interactive accessibility methods on combined schedule and headway-based networks. Transportation Research Record, 2653(1), 45-53.
Delling, D., Pajor, T., & Werneck, R. F. (2015). Round-based public transit routing. Transportation Science, 49(3), 591-604.
Other routing:
detailed_itineraries()
,
travel_time_matrix()
if (interactive()) { library(r5r) # build transport network data_path <- system.file("extdata/poa", package = "r5r") r5r_core <- setup_r5(data_path = data_path) # load origin/destination points points <- read.csv(file.path(data_path, "poa_hexgrid.csv")) access <- accessibility(r5r_core, origins = points, destinations = points, opportunities_colname = "schools", mode = "WALK", cutoffs = c(25, 30), max_trip_duration = 30, verbose = FALSE) stop_r5(r5r_core) }


Loading…
this is a random error
Already registered?
Sign In
this is a random error
Not registered?
Create an account
Logout
Remove Background
Change Background
Nothing Right Now
Color Inversion
Low
Medium
High
To-Do List
Low
Medium
High
Favourite Links
Stats


CONTEMPT A film review by Steve Rhodes Copyright 1997 Steve Rhodes
RATING (0 TO ****): *** 1/2
Director Jean-Luc Godard's CONTEMPT (LE MEPRIS) has been hailed by some critics as one of the best films ever made. A handsome new print of the 1963 film is being shown now in New York City and is scheduled to be making its way to other cities.
As the film opens, two lovers are having an intimate conversation. The nude woman is lying face down on the bed as she queries her husband about various parts of her anatomy. She wants to know if he loves her feet, her ankles, and so forth. The dialog remains more romantic than sexual although with Brigitte Bardot playing the part of the wife, Camille Javal, the audiences at the time of the picture's release may have had trouble concentrating on the lines spoken. (The modicum of female rear nudity may have been a bit shocking at the time, but the movie is quite tame by today's standards.)
Brigitte Bardot gives an incredible performance as the 28-year-old typist who does not have a clue about what she wants in life. She is an intelligent woman, no airhead, but her life is aimless. The film works precisely because she convinces us of her disdain for most aspects of her life, especially her marriage. After an idyllic beginning she informs her husband that she despises him and feels contempt for him. Her husband Paul, played beautifully by Michel Piccoli, becomes perplexed. What could he have said or done that made her feel thus? After all, it was only hours ago that they were making romantic small talk in bed.
Her husband is an aspiring but unsuccessful playwright who has agreed to help American producer Jerry Prokosch with a movie that he is making of Homer's Odyssey. When Odyssey's director Fritz Lang, played by the great director himself, starts talking about how cultured the performance will be, Jerry will have none of it. "Every time I hear the word culture, I bring out my checkbook," he declares as he writes a check on the spot to Paul to rewrite the script.
Lacking the smooth refinements of the rest of the characters, Jerry, played by Jack Palance, is crude but believes himself more refined than any of them. "Gods, I like Gods," he says about his movie. "I know exactly how they feel." Jerry carries a tiny book with him everywhere and loves to quote homilies from it.
Godard has a great sense for the visual, and his films are feasts for the eyes. In CONTEMPT several scenes are memorable. One of the best has an ancient Greek statue slowly turning. In another, the blond and tanned Bardot is framed by the rocky coast and deep blue waters of Capri. And then, who could forget the opening scene of her lying on the sheets with her toes twirling in the air.
My personal favorite aspect of the production is the music by Georges Delerue. It has a timelessness and a sweeping grandeur that starts off romantic but becomes increasingly morose as the tragedy unfolds.
The film is about many things. Certainly Godard's love of the cinema comes across in ways explicit and subtle. The film, which is more a dramatic tone poem than a traditional movie, ultimately is about the impact of the death of love. When Paul learns that his wife holds him in contempt, he does not know how to deal with it. Similarly, Camille is confused and just as lost when she realizes she no longer loves Paul. Both are depressed in their own way.
Effusive Jerry couldn't care less about any of this.  His life can only be lived in the fast lane where love and relationships have no relevance.
CONTEMPT is an entrancing and moving film that leaves its audiences thinking and somewhat devastated. One may forget many of the story's details, but its impact will remain.
CONTEMPT runs 1:45 but feels much shorter perhaps because the story takes place in less than 24 hours. The film is partially in French with English subtitles and partially in English. It is not rated but would be a mild R for some female rear nudity, a little profanity, and a little violence. The film would be fine for teenagers. I strongly recommend you see or rent this marvelous film, and I give it *** 1/2.
**** = A must see film. *** = Excellent show. Look for it. ** = Average movie. Kind of enjoyable. * = Poor show. Don't waste your money. 0 = Totally and painfully unbearable picture.
REVIEW WRITTEN ON: August 16, 1997
Opinions expressed are mine and not meant to reflect my employer's.
The review above was posted to the
rec.arts.movies.reviews newsgroup (de.rec.film.kritiken for German reviews).
The Internet Movie Database accepts no responsibility for the contents of the
review and has no editorial control. Unless stated otherwise, the copyright
belongs to the author.
Please direct comments/criticisms of the review to relevant newsgroups.
Broken URLs inthe reviews are the responsibility of the author.
The formatting of the review is likely to differ from the original due
to ASCII to HTML conversion.
Related links: index of all rec.arts.movies.reviews reviews