User
Need data on Japanese people living in Brazil
Need fresh data on Vietnamese university students
PM
idx name nickname email phone_number kakao_token naver_token account_type
1035189 김에스더 에짱짱 esd1103@nate.com 010-6729-1103 77033756 5
1035190 최혜지 슬비맘 chjlnys@hanmail.net 010-2419-2429 60383128 5
1035191 전은옥 hmhm00 okcut00@naver.com 010-3115-2677 58619267 5
account_id,account_type,account_telco_code,vno_id,brand_id,create_time,update_time,account_name,phone,email,mac,virtual_code,recharge_code,first_login_device,first_login_app,activation_ts,batch_number,account_group,pre_payed_plan,vendor_id,vendor,model,phone_pre_code,country_code,properties,status,recharge_status,first_charge_ts,free_trial_status,first_open_type,last_free_resource_allocation_ts,last_login_ts,password,account_protect_status,remark,reseller_id,expire_ts_max,first_login_ip,first_login_country_id,first_login_country_name,first_login_province_id,first_login_province_name,first_login_city_id,first_login_city_name,last_recharge_time,last_recharge_type_unit_day,login_method,panel_package_id_list,portal_package_id_list,product_list,pay_type,renew_type,tag_id_list,is_bind_account,is_trial,is_biz_mobile_disable,is_biz_email_first_for_account,is_biz_email_first_for_mac,is_biz_email_first_for_probation,is_biz_email_first_for_another_email,is_biz_email_first_for_website,is_biz_website_already_get_trial,is_biz_charge_code_first_login,is_biz_email_first_for_charge_code,is_biz_charge_code_already_bind,is_biz_charge_code_already_get_trial,is_biz_probation_already_get_trial,is_biz_email_first_for_device_user,is_biz_device_user_already_bind,first_login_country_iso_code,first_login_province_iso_code,enduser_source
4160082,trust,,89,1000126,1598766742000,1598766742000,+5543-99952-2187,+5543-99952-2187,,,,,0,,1598737942034,,,0,0,tve_web,,,,128,1,,0,,,0,0,,0,,0,0,,0,,0,,0,,1598738284723,30,6,,,"1000185,1000186",PAID,1,,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,,,test
9226969,trust,,89,1000126,1634454400000,1635360350000,+55048998575104,+55048998575104,,,,,0,,1555456374816,,,0,0,,,,,34,1,,0,,,0,0,,0,,0,0,,0,,0,,0,,1634421428301,30,6,,,"1000185,1000186",PAID,0,,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,,,test
9230937,trust,,89,1000126,1634527008000,1635360534000,+55085981803948,+55085981803948,,,,,0,,1634249549108,,,0,0,,,,,34,1,,0,,,0,0,,0,,0,0,,0,,0,,0,,1634496421529,30,6,,,"1000185,1000186",PAID,0,,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,,,test
9229096,trust,,89,1000126,1634508693000,1636392686000,+55038999532173,+55038999532173,,,,,0,,1633633130093,,,0,0,,,,,34,1,,0,,,0,0,,0,,0,0,,0,,0,,0,,1634239414024,365,6,,,"1000185,1000186",PAID,0,,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,,,test
"id","firstname","lastname","email","phone","password","referal_code","is_verified","verify_type","verify_code","verify_expired_date","lastest_token","referal_register","remember_token","created_at","updated_at","temp_email","is_banned","deleted_at","phone_temporary","b2b_id"
122,Andhika,Yoga,ayoga2612@gmail.com,"085285809192",$2y$10$UuCDhFT3RBtkRfm5161M.e76y3YS3KaIc0gtEDi1dYudSNFmMVgWG,"9852",1,otp,"277997","2020-02-13 08:09:22",eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwczovL2FwaS5haXFxb24uaWQvYXBpL3YzL2xvZ2luIiwiaWF0IjoxNjUwODc1OTc3LCJleHAiOjE2NTE0ODA3NzcsIm5iZiI6MTY1MDg3NTk3NywianRpIjoidmhrNVhkVkNrdVBOd3BxeiIsInN1YiI6MTIyLCJwcnYiOiI4N2UwYWYxZWY5ZmQxNTgxMmZkZWM5NzE1M2ExNGUwYjA0NzU0NmFhIn0.dKpL8h7zsWf5gmC6_noImP2BdoFR6-p0eiLVq3uUAZI,,,"2019-01-25 17:17:01","2022-04-25 15:39:37",,0,,"",
147,Asih oke,Priyatno,asreds.claten@gmail.com,"085643892690",$2y$10$xXNYQpimXbPCIvdxmZkDTuoLAuIJ.ZULbe7l6096K9w7XgYO.BydK,"5606",1,,"692119","2020-04-28 18:51:13",eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwczovL2FwaS5haXFxb24uaWQvYXBpL3YzL2xvZ2luIiwiaWF0IjoxNjA1NTY0NDU2LCJleHAiOjE2MDYxNjkyNTYsIm5iZiI6MTYwNTU2NDQ1NiwianRpIjoiUVIxSDFWb3c0UkR2UTlXcyIsInN1YiI6MTQ3LCJwcnYiOiI4N2UwYWYxZWY5ZmQxNTgxMmZkZWM5NzE1M2ExNGUwYjA0NzU0NmFhIn0.PHRZgn6K5j5OR6ZS2NhWj7mwa4qdx2wk1KPPTu4dE3g,,,"2019-01-26 21:23:29","2020-11-17 05:07:36",,0,,,
149,Bernado,Rizky Julhenry,hi@kelana.id,"081325605555",$2y$10$6AZmAkw1vXTpHEEuwDy6/eUCDWdHmG5qPOt/yQAqgSMfuDoCXwv8q,"0166",1,,"288523","2019-08-12 13:56:11",eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwczovL2FwaS5haXFxb24uaWQvYXBpL3YyL2xvZ2luIiwiaWF0IjoxNTgzMzA0OTk0LCJleHAiOjE1ODM5MDk3OTQsIm5iZiI6MTU4MzMwNDk5NCwianRpIjoid3ZMRUxTbmJOTUUwdDF5QyIsInN1YiI6MTQ5LCJwcnYiOiI4N2UwYWYxZWY5ZmQxNTgxMmZkZWM5NzE1M2ExNGUwYjA0NzU0NmFhIn0.4a1f3UUnzs5itkMcXtQHqcDNryYj7yGBPMdlEnOaHY0,,,"2019-01-28 18:19:15","2020-03-04 13:56:34",,0,,,
ID METRO CARD NAME PHONE EMAIL
9804929 6430130800174152011708 Глеб Ильдеров +7(911)5725167 gleb01062006b@gmail.com
9804930 6430104000186436011723 Ирина Уварова +7(921)4363633 inuvarova@mail.ru
9804931 6430106100139116011743 Флера Салахиева +7(918)8536056 fliora14@gmail.com
MRN# Patient_Last Patient_First PATIENT_DOB_YYYY-MM-DD Patient_Address1 Patient_Address2 Patient_Phone Patient_Phone Ordering_Location_Name Ordering_Location_Add1 Ordering_Location_Add2 Ordering_Location_City2 Ordering_Location_Phone
MLD-12-000366 GALVIS CAROLINA 2001/1/1 0001 PALISADES AVE 2010005500 MEDICAL LABORATORY DIAGNOSTICS 85 HORSE HILL ROAD CEDAR KNOLLS 9737312900
Patient Signature Date,Patient FeeSchedule From Date,Patient FeeSchedule To Date,Patient Account Number,Patient Age,Patient Age Groups,Patient Characteristic,Patient Deceased,Patient Date of Birth,Patient Demographic Pharmacy IsPrimary,Patient Demographic Don't Send Statement,Patient Exact Age,Patient FeeSchedule Name,Patient Employer Name,Patient Employer Address,Patient Employer Address 2,Patient Employer City,Patient Employer State,Patient Employer Zipcode,Patient Employer Phone Number,Patient Ethnicity,Patient Gender,Patient Language,Patient Misc Info,Patient Misc Value,Patient MRN,Patient Name,Patient First Name,Patient Last Name,Patient Middle Initial,Patient Full Name (First Name First),Patient Full Address,Patient Address Line1,Patient Address Line2,Patient City,Patient State,Patient Zip Code,Patient Phone Number,Patient Work Phone Number,Patient Cell Number,Patient Email,Patient SSN,Patient Primary Pharmacy Name,Patient Race,Patient Release of Information,Patient Status,Patient Student Status,Primary Service Location,Responsible Party Account Number,Responsible Party Date of Birth,Responsible Party Employer Name,Responsible Party Name,Responsible Party Full Address,Responsible Party Address Line1,Responsible Party Address Line2,Responsible Party City,Responsible Party State,Responsible Party Zip Code,Responsible Party Phone Number,Responsible Party SSN,Web Enabled,Patient Demographic Primary Pharmacy ID,Patient ID,Primary Service Location ID
,,,,4,Under 18 Yrs,,No,4/25/2017,No,Yes,4 Years 07 Months 11 Days,,n/a,,,,,,,,female,,,,,"Hartsell, Sharon ",Sharon,Hartsell,,Sharon Hartsell,"7012 Trimble Drive Fort Worth TX, 76134",7012 Trimble Drive,,Fort Worth,TX,76134,817-293-8104,000-000-0000,817-480-3872,shartsell@sbcglobal.net,,,,Yes,Active,,,,,,,,,,,,,,,No,,79485,
MEASUREMENT_PERIOD_START_DATE,MEASUREMENT_PERIOD_END_DATE,ETL_TRACKING_DATETIME,SERVICE_AREA_ID,History,Patient_ID,SSN,Patient_DOB,Pat_First_Name,Pat_Middle_Name,Pat_Last_Name,Pat_Gender_Desc,Pat_Lang_Desc,Pat_Race_Desc,Pat_Ethnicity_Desc,Pat_Home_Phone,Pat_Mobile_Phone_Num,Pat_Email,Pat_Home_Addr_Line1,Pat_Home_Addr_Line2,Pat_Home_Addr_City,Pat_Home_Addr_State,Pat_Home_Addr_Zip,Emergency_Contact_Name,Emergency_Contact_Number,Emergency_Contact_Relationship,Pat_Deceased_Date_or_Active_Status,Patient_Primary_Insurance_Carrier_Name,Patient_Primary_Insurance_Plan_Name,Patient_Primary_Insurance_Plan_Type_Descr,Patient_Secondary_Insurance_Carrier_Name,Patient_Secondary_IInsurance_Plan_Name,Patient_Secondary_Insurance_Plan_Type_Descr,Appt_Date,Appt_Time,Appt_Type,Appt_Status_Desc,Reason_Desc,Reason_Class_Desc,Appt_Provider_Name,Clinic_Facility_Location,Service_Location,Pat_PCP_Name,Aux,PAT_ID,PAT_ENC_CSN_ID,AGE_asof_ENC,Enc_Type,DEPARTMENT_NAME,HSP_ACCOUNT_ID,HSP_ACCOUNT_NAME,ACCT_FIN_CLASS_C,APPT_NOTE,ENC_REASON_NAME,Pat_Race,Pat_Ethnicity,CVG_LIST_SELECT_YN
11/1/2021,12/31/2023,2024-02-08 09:56:05.460,900000,====== History Appointment flds ====>,01010748,,4/9/1949,Donita,R,Miller,Female,English,White,Non-Hispanic,712-755-3889,712-579-9982,dmdm3889@gmail.com,1220 CYCLONE AVE,NULL,HARLAN,Iowa,51537-1202,"Jones,Cresta",NULL,Niece,Active,MEDICARE,MEDICARE A & B,,TRICARE FOR LIFE,TRICARE FOR LIFE,,12/14/2023,1100,90000027=AWV WITH OFFICE VISIT MMC,Completed,NULL,AWV - Subsequent with lab Review,"FERRY, JILL",90016,MMC HARLAN RURAL HEALTH CLINIC,"FERRY, JILL",====== AuxFlds to the right====>,Z1049726,436964921,74,101=Office Visit,MMC HARLAN RURAL HEALTH CLINIC,9901587643,"MILLER,DONITA R",2,AWV - Subsequent with lab Review,NULL,WHITE,NON-HISPANIC,Y