China Shanghai Ninth People Hospital - Drugs, Patients, Doctors PII
by meateater420 - November 25, 2021 at 07:56 AM
#1
Big Shanghai hospital. Similar to my previous work 



Personal information that gives light on patient drug uses, costs, and doctor commissions- interesting work to be done looking at Chinese pharma industry here

edit: added much more data, see file names below + line counts

370mb uncomrpessed, 28mb compressed


line counts, uncompressed ndjson files
242 doctor_commission.json
  215649 drug.json
      0 drugn.json
    284 hospital_dose_rule.json
      0 hospital_dose_rulen.json
    312 hospital_incompatibility.json
    961 medicine_grant_operation.json
  10943 medicine_patient_record.json
    320 medicine_record_ap.json
    290 medicine_record_cpm.json
    823 medicine_record_pt.json
      66 medicine_record_pt_log.json
  10487 medicine_record_tcm.json
  48228 medicine_record_tcm_compose.json
  10337 patient_register.json
  80158 pine-millet-2021.11.17.json
    2128 pine_millet_order.json
    166 pine_millet_order_approval.json
    3284 pine_millet_order_item.json
    388 pine_millet_order_receiving_address.json
    228 pine_millet_order_refund.json
  31382 pine_millet_order_setup.json
  10523 prescription_tcm_data_detail.json
    1760 prescription_tcm_detail.json
  15196 scheduling_doctor.json
  90647 scheduling_doctor_slot.json
      59 scheduling_plan_doctor_usage.json
    2499 stock_manage.json
  537360 total



samples



drug.json - 215649 lines ndjson

{"id":1394660395525914600,"warehouseId":null,"hospitalId":1392741140924514300,"code":"CPM000100","name":"参桂调经丸","simpleSpell":"cgdjw","fullSpell":"canguitiaojingwan","drugType":"中成药","purchaseUnit":null,"preUnit":"盒","purchasePrice":null,"prePrice":null,"oldPrePrice":null,"addPrice":null,"billie":null,"supplier":null,"state":1,"isProvide":0,"createUser":null,"createTime":"2021-05-18T22:25:24+08:00","createDept":null,"updateUser":null,"updateTime":"2021-05-18T22:25:24+08:00","status":1,"isDeleted":0,"source":3}

doctor_commission.json - 242 lines ndjson

{"id":1435947742585143300,"hospitalId":1392741140924514300,"doctorId":1393880950296854500,"doctorName":"赵琛","serialSn":"BH20210909gn2zWm","targetType":11,"targetId":1435946264614191000,"isOnline":0,"actualPrice":714,"unitPrice":120,"proportion":50,"commission":357,"setup":null,"description":"中药饮片提成","buyerName":"天香","buyer":1430921898797088800,"buyerType":"patient","payTime":"2021-09-09T20:46:33+08:00","createTime":"2021-09-09T20:46:35+08:00"}

hospital_dose_rule.json - 284 lines ndjson



{"id":1422452742862979000,"hospitalId":1422452738937110500,"drugName":"大枣","drugCode":null,"dose":13,"isSystem":0,"createUserId":1333350234012520400,"createTime":"2021-08-03T15:02:16+08:00","updateUserId":null,"updateTime":"2021-07-13T17:43:06+08:00","isDeleted":0}





Hidden Content
You must register or login to view this content.






Inspired by ATW- cheers bro
Reply
#2
can you specify the hospital name
Reply
#3
(November 25, 2021 at 08:17 AM)elliot1 Wrote: can you specify the hospital name
real ones can figure that out  Biggrin
Reply
#4
https://raidforums.com/Thread-SELLING-Ch...Y-DETAILED is it this data ?
Reply
#5
Lol your nick is awesome carnivore buddd x))
Reply
#6
(November 25, 2021 at 07:56 AM)meateater420 Wrote: Big Shanghai hospital. Similar to my previous work 

Personal information that gives light on patient drug uses, costs, and doctor commissions- interesting work to be done looking at Chinese pharma industry here

samples

drug.json - 215649 lines ndjson
{"id":1394660395525914600,"warehouseId":null,"hospitalId":1392741140924514300,"code":"CPM000100","name":"参桂调经丸","simpleSpell":"cgdjw","fullSpell":"canguitiaojingwan","drugType":"中成药","purchaseUnit":null,"preUnit":"盒","purchasePrice":null,"prePrice":null,"oldPrePrice":null,"addPrice":null,"billie":null,"supplier":null,"state":1,"isProvide":0,"createUser":null,"createTime":"2021-05-18T22:25:24+08:00","createDept":null,"updateUser":null,"updateTime":"2021-05-18T22:25:24+08:00","status":1,"isDeleted":0,"source":3}
doctor_commission.json - 242 lines ndjson
{"id":1435947742585143300,"hospitalId":1392741140924514300,"doctorId":1393880950296854500,"doctorName":"赵琛","serialSn":"BH20210909gn2zWm","targetType":11,"targetId":1435946264614191000,"isOnline":0,"actualPrice":714,"unitPrice":120,"proportion":50,"commission":357,"setup":null,"description":"中药饮片提成","buyerName":"天香","buyer":1430921898797088800,"buyerType":"patient","payTime":"2021-09-09T20:46:33+08:00","createTime":"2021-09-09T20:46:35+08:00"}
hospital_dose_rule.json - 284 lines ndjson

{"id":1422452742862979000,"hospitalId":1422452738937110500,"drugName":"大枣","drugCode":null,"dose":13,"isSystem":0,"createUserId":1333350234012520400,"createTime":"2021-08-03T15:02:16+08:00","updateUserId":null,"updateTime":"2021-07-13T17:43:06+08:00","isDeleted":0}

more to come

[Hidden Content]


Inspired by ATW- cheers bro
Great work! Love to see people being involved in China's shit Smile
Shanghai Ninth People Hospital is the hospital's name btw :-)
Reply
#7
(November 25, 2021 at 08:32 AM)elliot1 Wrote: https://raidforums.com/Thread-SELLING-Ch...Y-DETAILED is it this data  ?

lmfao it might be. hilarious

OK, more data on its way. 370mb uncompressed. I will be editing the thread here I don't need to make duplicate.
Reply
#8
(November 25, 2021 at 09:55 AM)sullivanjee Wrote: Lol your nick is awesome carnivore buddd x))

i just love meat you know
Reply
#9
Thank you for share brother Wink have a nice day!
Reply
#10
These are of no use to me. But thank you anyway
Reply
#11
(November 27, 2021 at 05:40 AM)wzhing Wrote: These are of no use to me. But thank you anyway

because every thing i do, i do for you @wzhing Wink

in general, i think hackers have duty to shed light where there is none, this is why i do this and will continue to poke at the CCP regime
Reply
#12
your are tought guys ,thanks yours leaking
Reply

Possibly Related Threads…
Thread Author Replies Views Last Post
CSV US Doctors Database - 790,000+ Records - Emails, tel #s, faxes, addresses osint20 2 1,425 41 minutes ago
Last Post: elliot1
Shanghai International Tourism Resort | Confidential Parking report PDF | ATW | 2021 AgainstTheWest 0 1,228 December 01, 2021 at 07:18 AM
Last Post: AgainstTheWest
Permata Bunda Hospital DB [Indonesia] p0L1cy 10 5,501 November 30, 2021 at 06:05 PM
Last Post: udinsedih

 Users browsing this thread: 1 Guest(s)