{
 "type": "record",
 "name": "patientboth",
 "fields": [
  {
   "name": "PID_SSNNumberPatient",
   "type": "int",
   "doc": "Type inferred from '823456789'"
  },
  {
   "name": "email",
   "type": "string",
   "doc": "Type inferred from '\"ahospital0@census.gov\"'"
  },
  {
   "name": "gender",
   "type": "string",
   "doc": "Type inferred from '\"Male\"'"
  },
  {
   "name": "ip_address",
   "type": "string",
   "doc": "Type inferred from '\"138.135.180.206\"'"
  },
  {
   "name": "drug_provider",
   "type": "string",
   "doc": "Type inferred from '\"OrchidPharma Inc\"'"
  },
  {
   "name": "icd9",
   "type": "string",
   "doc": "Type inferred from '\"94140\"'"
  },
  {
   "name": "icd9_description",
   "type": "string",
   "doc": "Type inferred from '\"Deep necrosis of underlying tissues [deep third degree] without mention of loss of a body part, face and head, unspecified site\"'"
  },
  {
   "name": "icd9P_proc",
   "type": "string",
   "doc": "Type inferred from '\"7942\"'"
  },
  {
   "name": "icd9_proc_description",
   "type": "string",
   "doc": "Type inferred from '\"Closed reduction of separated epiphysis, radius and ulna\"'"
  },
  {
   "name": "user_agent",
   "type": "string",
   "doc": "Type inferred from '\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_5_8) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.801.0 Safari/535.1\"'"
  },
  {
   "name": "drug_used",
   "type": "string",
   "doc": "Type inferred from '\"Naratriptan\"'"
  },
  {
   "name": "OBX_1_UserDefinedAccessChecks",
   "type": "string",
   "doc": "Type inferred from '\"20150101000100\"'"
  },
  {
   "name": "OBR_1_OrderingProvider_FamilyName",
   "type": "string",
   "doc": "Type inferred from '\"Johnson\"'"
  },
  {
   "name": "MSH_MessageControlID",
   "type": "string",
   "doc": "Type inferred from '\"Q1111111111111111111\"'"
  },
  {
   "name": "OBX_1_ObservationIdentifier_Text",
   "type": "string",
   "doc": "Type inferred from '\"Glucose Lvl\"'"
  },
  {
   "name": "MSH_SendingApplication_NamespaceID",
   "type": "string",
   "doc": "Type inferred from '\"XXXXXX\"'"
  },
  {
   "name": "OBR_1_UniversalServiceIdentifier_Text",
   "type": "string",
   "doc": "Type inferred from '\"Basic Metabolic Panel\"'"
  },
  {
   "name": "MSH_ReceivingApplication_NamespaceID",
   "type": "string",
   "doc": "Type inferred from '\"HealthOrg01\"'"
  },
  {
   "name": "MSH_ProcessingID_ProcessingID",
   "type": "string",
   "doc": "Type inferred from '\"P\"'"
  },
  {
   "name": "OBR_1_FillerOrderNumber_EntityIdentifier",
   "type": "string",
   "doc": "Type inferred from '\"000000000000000000\"'"
  },
  {
   "name": "PID_PatientAccountNumber_ID",
   "type": "string",
   "doc": "Type inferred from '\"999999999999\"'"
  },
  {
   "name": "PID_DateOfBirth",
   "type": "string",
   "doc": "Type inferred from '\"19700101\"'"
  },
  {
   "name": "PD1_PatientPrimaryCareProviderNameIDNo_IDNumber",
   "type": "string",
   "doc": "Type inferred from '\"1234567890\"'"
  },
  {
   "name": "PID_Sex",
   "type": "string",
   "doc": "Type inferred from '\"M\"'"
  },
  {
   "name": "MSH_MessageType_MessageType",
   "type": "string",
   "doc": "Type inferred from '\"ORU\"'"
  },
  {
   "name": "OBX_1_ReferencesRange",
   "type": "string",
   "doc": "Type inferred from '\"H\"'"
  },
  {
   "name": "OBR_1_OrderingProvider_IDNumber",
   "type": "string",
   "doc": "Type inferred from '\"1620\"'"
  },
  {
   "name": "PD1_PatientPrimaryCareProviderNameIDNo_FamilyName",
   "type": "string",
   "doc": "Type inferred from '\"LAST\"'"
  },
  {
   "name": "OBX_1_Units_NameOfCodingSystem",
   "type": "string",
   "doc": "Type inferred from '\"99\"'"
  },
  {
   "name": "OBX_1_Units_Identifier",
   "type": "string",
   "doc": "Type inferred from '\"65-99\"'"
  },
  {
   "name": "PID_PatientName_GivenName",
   "type": "string",
   "doc": "Type inferred from '\"JOHN\"'"
  },
  {
   "name": "OBX_1_ObservationSubID",
   "type": "string",
   "doc": "Type inferred from '\"159\"'"
  },
  {
   "name": "PD1_PatientPrimaryCareProviderNameIDNo_GivenName",
   "type": "string",
   "doc": "Type inferred from '\"FIRST\"'"
  },
  {
   "name": "OBR_1_PlacerOrderNumber_NamespaceID",
   "type": "string",
   "doc": "Type inferred from '\"HNAM_ORDERID\"'"
  },
  {
   "name": "MSH_MessageType_TriggerEvent",
   "type": "string",
   "doc": "Type inferred from '\"R01\"'"
  },
  {
   "name": "PD1_PatientPrimaryCareProviderNameIDNo_AssigningAuthority",
   "type": "string",
   "doc": "Type inferred from '\"NPI\"'"
  },
  {
   "name": "OBR_1_ResultStatus",
   "type": "string",
   "doc": "Type inferred from '\"M\"'"
  },
  {
   "name": "PID_PatientName_FamilyName",
   "type": "string",
   "doc": "Type inferred from '\"SMITH\"'"
  },
  {
   "name": "MSH_EncodingCharacters",
   "type": "string",
   "doc": "Type inferred from '\"^~\\\\&\"'"
  },
  {
   "name": "MSH_VersionID",
   "type": "string",
   "doc": "Type inferred from '\"2.3\"'"
  },
  {
   "name": "OBR_1_UniversalServiceIdentifier_Identifier",
   "type": "string",
   "doc": "Type inferred from '\"648088\"'"
  },
  {
   "name": "OBR_1_ObservationDateTime",
   "type": "string",
   "doc": "Type inferred from '\"20150101000100\"'"
  },
  {
   "name": "OBR_1_ScheduledDateTime",
   "type": "string",
   "doc": "Type inferred from '\"20150101000100\"'"
  },
  {
   "name": "OBX_1_ObservationIdentifier_Identifier",
   "type": "string",
   "doc": "Type inferred from '\"GLU\"'"
  },
  {
   "name": "OBR_1_OrderingProvider_GivenName",
   "type": "string",
   "doc": "Type inferred from '\"John\"'"
  },
  {
   "name": "OBR_1_SetIDObservationRequest",
   "type": "string",
   "doc": "Type inferred from '\"1\"'"
  },
  {
   "name": "OBR_1_ResultsRptStatusChngDateTime",
   "type": "string",
   "doc": "Type inferred from '\"20150101000100\"'"
  },
  {
   "name": "OBR_1_PlacerOrderNumber_EntityIdentifier",
   "type": "string",
   "doc": "Type inferred from '\"341856649\"'"
  },
  {
   "name": "OBX_1_NatureOfAbnormalTest",
   "type": "string",
   "doc": "Type inferred from '\"F\"'"
  },
  {
   "name": "OBX_1_SetIDOBX",
   "type": "string",
   "doc": "Type inferred from '\"1\"'"
  },
  {
   "name": "MSH_FieldSeparator",
   "type": "string",
   "doc": "Type inferred from '\"|\"'"
  },
  {
   "name": "PD1_PatientPrimaryCareProviderNameIDNo_MiddleInitialOrName",
   "type": "string",
   "doc": "Type inferred from '\"M\"'"
  },
  {
   "name": "OBX_1_Units_Text",
   "type": "string",
   "doc": "Type inferred from '\"65\"'"
  },
  {
   "name": "OBX_1_ValueType",
   "type": "string",
   "doc": "Type inferred from '\"NM\"'"
  },
  {
   "name": "PID_PatientIDInternalID_ID",
   "type": "string",
   "doc": "Type inferred from '\"000000001\"'"
  },
  {
   "name": "OBX_1_ObservationValue",
   "type": "string",
   "doc": "Type inferred from '\"mg/dL\"'"
  },
  {
   "name": "OBR_1_OrderingProvider_MiddleInitialOrName",
   "type": "string",
   "doc": "Type inferred from '\"R\"'"
  }
 ]
}