From :
To : nino_moroshkina@yahoo.com<nino_moroshkina@yahoo.com> <nino_moroshkina@yahoo.com>; nino_moroshkina@yahoo.com
Subject : RE: Technical requirements for morbidity data
Received On : 08.01.2020 11:57

each row is a count of 1 admission

 

 

 

From: Nino Moroshkina [mailto:nino_moroshkina@yahoo.com]
Sent: 08 January, 2020 14:46
To: Ketevan Goginashvili
Subject: Fw: Technical requirements for morbidity data

 

 

Qet, kidev kitxva maqvs: 

 

Is a row a single person being admitted to hospital (so each row is a count of 1 admission)?

 

I guess single row is a person being admitted, but would be good to confirm

 

 

----- Forwarded Message -----

From: "Ketevan Goginashvili" <kgoginashvili@moh.gov.ge>

Cc:

Sent: Wed, Jan 8, 2020 at 12:24 PM

Subject: RE: Technical requirements for morbidity data

Dear Nino,

 

See answers on the consultants questions:

1)      First, just to note that the region and municipality codes are in Georgian script, but I can probably handle that. I will only use region, I think, and I can translate the eight codes I have for them.

If needed help in translation we will support.

2)      What I am less clear about is (1) what each row represents and (2) what the last variable (‘Day_Delay’) represents.

3)      And how do I use “Day_Delay” (if indeed I need to use it)? It takes a value from 1 (for 2,244,599 of the total of 3,059,722 records) up to a maximum value of 1,830.

Day_Delay : Count of days between patient admission and patient discharge date

4)      Is a row a single person being admitted to hospital (so each row is a count of 1 admission)? And if so, is the date variable ‘PatientReleaseDate’ the date of his/her admission or discharge? (The name suggests it might be date of discharge but perhaps it means something different.)

PatientReleaseDate : Is the date a patient was discharged from a 

 

 

From: Paul Wilkinson <Paul.Wilkinson@lshtm.ac.uk>
Sent: Monday, December 30, 2019 10:24 PM
To: Joseph Melitauri <jmelitauri@worldbank.org>
Cc: Tamer Samah Rabie <trabie@worldbank.org>; nino_moroshkina@yahoo.com; Stephen Geoffrey Dorey <sdorey@worldbank.org>
Subject: RE: Technical requirements for morbidity data

 

[External]

Joseph,

 

Could I ask for some help in decoding the data file which I have now successfully loaded and transferred to Stata format for analysis.

 

First, just to note that the region and municipality codes are in Georgian script, but I can probably handle that. I will only use region, I think, and I can translate the eight codes I have for them.

 

What I am less clear about is (1) what each row represents and (2) what the last variable (‘Day_Delay’) represents.

 

Is a row a single person being admitted to hospital (so each row is a count of 1 admission)? And if so, is the date variable ‘PatientReleaseDate’ the date of his/her admission or discharge? (The name suggests it might be date of discharge but perhaps it means something different.)

 

And how do I use “Day_Delay” (if indeed I need to use it)? It takes a value from 1 (for 2,244,599 of the total of 3,059,722 records) up to a maximum value of 1,830.

 

Many thanks,

 

 

Paul

 

From: Joseph Melitauri <jmelitauri@worldbank.org>
Sent: 23 December 2019 08:19
To: Paul Wilkinson <Paul.Wilkinson@lshtm.ac.uk>; Stephen Geoffrey Dorey <sdorey@worldbank.org>
Cc: Tamer Samah Rabie <trabie@worldbank.org>; nino_moroshkina@yahoo.com
Subject: RE: Technical requirements for morbidity data

 

Dear Paul et al,

 

You should have received a link for the shared folder with the health database file. I have been able to open the file. Please confirm that you have been able to access the file.

 

Regards,

 

Joseph Melitauri

 

Senior Operations Officer

 

Europe and Central Asia Region

Energy & Extractives Global Practice

Email:      jmelitauri@worldbank.org

Phone:   +(995) 322296235

 

 

 

 

 

From: Stephen Geoffrey Dorey <sdorey@worldbank.org>
Sent: Thursday, December 12, 2019 8:57 PM
To: nino_moroshkina@yahoo.com; Joseph Melitauri <jmelitauri@worldbank.org>
Cc: Paul Wilkinson <Paul.Wilkinson@lshtm.ac.uk>; Tamer Samah Rabie <trabie@worldbank.org>
Subject: RE: Technical requirements for morbidity data

 

Dear Nino,

 

Ah that is really great news! Thanks for the update!

 

On our end we also have someone looking at the recommendations for the CHVA so we hope that also will have moved forward before Christmas.

 

Best wishes all,

 

 

Stephen

 

From: Nino Moroshkina <nino_moroshkina@yahoo.com>
Sent: Thursday, December 12, 2019 11:55 AM
To: Stephen Geoffrey Dorey <sdorey@worldbank.org>; Joseph Melitauri <jmelitauri@worldbank.org>
Cc: Paul Wilkinson <Paul.Wilkinson@lshtm.ac.uk>; Tamer Samah Rabie <trabie@worldbank.org>
Subject: RE: Technical requirements for morbidity data

 

[External]

Dear Team,

 

I followed up with the ministry and SSA. The data requested will be available next week. 

 

I will check early next week.

 

Best regards, Nino

 

 

On Thu, Dec 12, 2019 at 10:27 AM, Stephen Geoffrey Dorey

Dear Joseph,

 

I hope all is well with you. Just checking if there are any updates on this? I didn’t see the letter go across so assume I was not cc’d?

 

Let me know if you would like me or Nino to follow up with the ministry so we can get this data to Paul before the Christmas break.

 

Best wishes,

 

 

Stephen

 

From: Joseph Melitauri <jmelitauri@worldbank.org>
Sent: Tuesday, November 19, 2019 4:08 AM
To: Stephen Geoffrey Dorey <sdorey@worldbank.org>
Cc: nino_moroshkina@yahoo.com; Paul Wilkinson <Paul.Wilkinson@lshtm.ac.uk>; Tamer Samah Rabie <trabie@worldbank.org>
Subject: RE: Technical requirements for morbidity data

 

Stephen,

 

Thanks a lot for the request. It will go out today.

 

Regards,

 

Joseph

 

From: Stephen Geoffrey Dorey <sdorey@worldbank.org>
Sent: Monday, November 18, 2019 7:53 PM
To: Joseph Melitauri <jmelitauri@worldbank.org>
Cc: nino_moroshkina@yahoo.com; Paul Wilkinson <Paul.Wilkinson@lshtm.ac.uk>; Tamer Samah Rabie <trabie@worldbank.org>
Subject: Technical requirements for morbidity data

 

Dear Joseph,

 

Please find attached text to add to the official data request letter for the morbidity analysis (word file). Also attached is the excel file supplied by Paul and mentioned in the text (excel file).

 

Nino has informed us this letter should be addressed to the First Deputy Minister, Tamar Gabunia - tgabunia@moh.gov.ge

 

Please let me know if you need further assistance with this letter.

 

Best wishes,

 

 

Stephen