6  Table Reference 

Loading required package: DBI

6.1 person table:

SELECT * FROM person LIMIT 10;
Displaying records 1 - 10
person_id gender_concept_id year_of_birth month_of_birth day_of_birth birth_datetime race_concept_id ethnicity_concept_id location_id provider_id care_site_id person_source_value gender_source_value gender_source_concept_id race_source_value race_source_concept_id ethnicity_source_value ethnicity_source_concept_id
6 8532 1963 12 31 1963-12-31 8516 0 NA NA NA 001f4a87-70d0-435c-a4b9-1425f6928d33 F 0 black 0 west_indian 0
123 8507 1950 4 12 1950-04-12 8527 0 NA NA NA 052d9254-80e8-428f-b8b6-69518b0ef3f3 M 0 white 0 italian 0
129 8507 1974 10 7 1974-10-07 8527 0 NA NA NA 054d32d5-904f-4df4-846b-8c08d165b4e9 M 0 white 0 polish 0
16 8532 1971 10 13 1971-10-13 8527 0 NA NA NA 00444703-f2c9-45c9-a247-f6317a43a929 F 0 white 0 american 0
65 8532 1967 3 31 1967-03-31 8516 0 NA NA NA 02a3dad9-f9d5-42fb-8074-c16d45b4f5c8 F 0 black 0 dominican 0
74 8532 1972 1 5 1972-01-05 8527 0 NA NA NA 02fbf1be-29b7-4da8-8bbd-14c7433f843f F 0 white 0 english 0
42 8532 1909 11 2 1909-11-02 8527 0 NA NA NA 0177d2e0-98f5-4f3d-bcfd-497b7a07b3f8 F 0 white 0 irish 0
187 8507 1945 7 23 1945-07-23 8527 0 NA NA NA 07a1e14d-73ed-4d3a-9a39-d729745773fa M 0 white 0 irish 0
18 8532 1965 11 17 1965-11-17 8527 0 NA NA NA 0084b0fe-e30f-4930-b6d1-5e1eff4b7dea F 0 white 0 english 0
111 8532 1975 5 2 1975-05-02 8527 0 NA NA NA 0478d6b3-bdb3-4574-9b93-cf448d725b84 F 0 white 0 english 0

6.2 procedure_occurrence table:

SELECT * FROM procedure_occurrence LIMIT 10;
Displaying records 1 - 10
procedure_occurrence_id person_id procedure_concept_id procedure_date procedure_datetime procedure_type_concept_id modifier_concept_id quantity provider_id visit_occurrence_id visit_detail_id procedure_source_value procedure_source_concept_id modifier_source_value
3554 343 4107731 1992-02-01 1992-02-01 38000275 0 NA NA 22951 0 180256009 4107731 NA
3741 357 4107731 1990-11-14 1990-11-14 38000275 0 NA NA 23670 0 180256009 4107731 NA
3928 399 4107731 1991-09-08 1991-09-08 38000275 0 NA NA 26205 0 180256009 4107731 NA
4115 406 4107731 1990-02-13 1990-02-13 38000275 0 NA NA 26759 0 180256009 4107731 NA
4302 411 4107731 1992-01-11 1992-01-11 38000275 0 NA NA 27401 0 180256009 4107731 NA
4489 430 4058899 1938-10-11 1938-10-11 38000275 0 NA NA 28537 0 168594001 4058899 NA
4676 442 4107731 1992-10-31 1992-10-31 38000275 0 NA NA 29330 0 180256009 4107731 NA
4863 453 4043071 1984-03-20 1984-03-20 38000275 0 NA NA 30237 0 228557008 4043071 NA
5050 469 4043071 1948-04-26 1948-04-26 38000275 0 NA NA 31282 0 228557008 4043071 NA
5237 488 4151422 1962-09-21 1962-09-21 38000275 0 NA NA 32616 0 269911007 4151422 NA

6.3 concept table

SELECT * FROM concept LIMIT 10;
Displaying records 1 - 10
concept_id concept_name domain_id vocabulary_id concept_class_id standard_concept concept_code valid_start_date valid_end_date invalid_reason
35208414 Gastrointestinal hemorrhage, unspecified Condition ICD10CM 4-char billing code NA K92.2 2007-01-01 2099-12-31 NA
1118088 celecoxib 200 MG Oral Capsule [Celebrex] Drug RxNorm Branded Drug S 213469 1970-01-01 2099-12-31 NA
40213201 pneumococcal polysaccharide vaccine, 23 valent Drug CVX CVX S 33 2008-12-01 2099-12-31 NA
1557272 Alendronate Drug RxNorm Ingredient S 46041 1970-01-01 2099-12-31 NA
4336464 Coronary artery bypass graft Procedure SNOMED Procedure S 232717009 1970-01-01 2099-12-31 NA
4295880 Intramuscular injection Procedure SNOMED Procedure S 76601001 1970-01-01 2099-12-31 NA
3020630 Protein serum/plasma Measurement LOINC Lab Test S 2885-2 1970-01-01 2099-12-31 NA
19129655 Ampicillin 100 MG/ML Injectable Solution Drug RxNorm Clinical Drug S 789980 2008-03-30 2099-12-31 NA
44923712 celecoxib 200 MG Oral Capsule [Celebrex] Drug NDC 11-digit NDC NA 00025152531 2000-01-01 2099-12-31 NA
1569708 Other diseases of digestive system Condition ICD10CM 3-char nonbill code NA K92 2012-01-01 2099-12-31 NA

6.4 condition_occurrence table

SELECT * FROM condition_occurrence LIMIT 10;
Displaying records 1 - 10
condition_occurrence_id person_id condition_concept_id condition_start_date condition_start_datetime condition_end_date condition_end_datetime condition_type_concept_id condition_status_concept_id stop_reason provider_id visit_occurrence_id visit_detail_id condition_source_value condition_source_concept_id condition_status_source_value
4483 263 4112343 2015-10-02 2015-10-02 2015-10-14 2015-10-14 32020 0 NA NA 17479 0 195662009 4112343 NA
4657 273 192671 2011-10-10 2011-10-10 NA NA 32020 0 NA NA 18192 0 K92.2 35208414 NA
4815 283 28060 1984-02-15 1984-02-15 1984-02-25 1984-02-25 32020 0 NA NA 18859 0 43878008 28060 NA
4981 293 378001 2005-11-07 2005-11-07 2005-12-07 2005-12-07 32020 0 NA NA 19515 0 62106007 378001 NA
5153 304 257012 1974-07-30 1974-07-30 1974-11-05 1974-11-05 32020 0 NA NA 20239 0 40055000 257012 NA
5313 312 4134304 1991-05-14 1991-05-14 1991-06-13 1991-06-13 32020 0 NA NA 20658 0 263102004 4134304 NA
5513 326 28060 1979-09-23 1979-09-23 1979-10-06 1979-10-06 32020 0 NA NA 21553 0 43878008 28060 NA
5655 334 40481087 1999-07-12 1999-07-12 1999-07-19 1999-07-19 32020 0 NA NA 22124 0 444814009 40481087 NA
5811 341 40481087 1990-09-14 1990-09-14 1990-10-05 1990-10-05 32020 0 NA NA 22784 0 444814009 40481087 NA
5977 351 40481087 1986-02-24 1986-02-24 1986-03-17 1986-03-17 32020 0 NA NA 23405 0 444814009 40481087 NA