Covid Thailand Trends

Thailand Covid testing and case data gathered and combined from various sources for others to download or view


Project maintained by djay Hosted on GitHub Pages — Theme by mattgraham

Downloads

Daily CCSA Briefings

cases_briefings.json | cases_briefings.csv

Schema:

Column  
Date e.g “2021-04-06”
Cases Total cases that day. (Cases Imported + Cases Local Transmission)
Cases In Quarantine “Cases found in quarantine facilities/centers”
Cases Imported Cases In Quarantine + Cases outside quarantine
Cases Proactive Local transmissions that aren’t walk-ins
Cases Local Transmission “Cases infected in Thailand”. Cases Walkins + Cases Proactive
Cases Area Prison Cases reported in prison on this date
Hospitalized Total currently in isolation in hospital or field hospital
Hospitalized Field Total currently in isolation in field hospitals
Hospitalized Hospital total current active cases - anyone confirmed is considered hospitalized currently
Hospitalized Severe Currently hospitalised in a severe condition. Unclear what kind of beds this entails.
Hospitalized Respirator Current number in severe condition requiring ICU and mechanical ventilator
Recovered Number released from hospital/field hospital on this date
Deaths Number of deaths annouced that day
Deaths Age (Min,Max) Range of ages of those who died
Deaths Age Median Median age of those who died
Deaths Comorbidity {comorbidity} Deaths where a particular comorbidity was present
Deaths Comorbidity None Deaths where there wasn’t a disease that increased risk
Deaths {Female,Male} Deaths for 2 of the genders
Deaths Risk {risk} Risks that are the likely cause of catching the virus e.g. Family
Tests ATK Proactive Number of ATK free tests taken (likely NHSO provided)
Pos ATK Proactive Number of ATK free test positive results (likely NHSO provided)
Source Cases Tweet, api or briefing the primary information came from
Fields no longer updated  
Cases (Asymptomatic,Symptomatic) - No longer reported in briefing reports

Cases/Deaths per province

cases_by_province.json | cases_by_province.csv

Schema cases_by_province:

Column  
“Date e.g “2021-04-06”
“Province e.g “Samut Sakhon”
“Health District Number 1-13 - see Thailand Health Areas
“Cases Confirmed cases in this province
“Deaths 31.0
Vac Given 1 Cum null
Vac Given 2 Cum null
Vac Given 3 Cum null
Health District Number 13
The following comes from moph_dashboad_prov  
Cases Walkin Confirmed cases found those requesting tests or asked to from contact tracing or the media. Paid or having met the PUI criteria.
Cases Proactive Confirmed cases found government has gone to specific areas to mass test due to high risk of COVID-19.
Cases Area Prison see moph_dashboad_prov
Positive Rate Dash see moph_dashboad_prov
Tests see moph_dashboad_prov. No longer updated

Cases/Deaths per Health District

cases_by_area.json, cases_by_area.csv

Schema cases_by_area:

Column  
Date e.g “2021-04-06”
Cases Area {1-13} Confirmed cases in a given Health Area
Deaths Area {1-13} Deaths that day in the health district
Cases Risk {Group} Area {1-13} Categorisation of Risk field from the covid-19-daily dataset
The following are no longer updated but have some historical data  
Cases {Proactive,Walkin} Area {1-13} Cases found by people where tested

Cases by Health Area Walk-in Cases by Health Area Proactive Cases by Health Area Cases by symptoms by Health Area

MOPH Covid-19 Dashboard

Schema

Column  
Date  
ATK Probable cases/ATK Positives. Most likely represents those registered for home isolation without a PCR test
Cases  
Cases Area Prison  
Cases Imported  
Cases Proactive  
Cases Walkin  
Deaths  
Hospitalized  
Hospitalized Field Hospitalized Field HICI + Hospitalized Field Hospitel + Hospitalized Field Other
Hospitalized Field HICI Current confirmed cases (PCR tested) in home isolation or community isolation centers
Hospitalized Field Hospitel Field hospital in a hotel
Hospitalized Field Other  
Hospitalized Hospital  
Hospitalized Respirator Presumably means currently on ventilation
Hospitalized Severe Unclear if this is just condition or signifies a different bed type
Recovered Newly released from isolation on this day
Vac Given {1-3} Cum  
Tests No longer updated. Didn’t match the numbers of tests in the testing reports. Possibly because it was released earlier?
Positive Rate Dash The pre-calculated positive rate shown on the dashboard. It is already 7 day averaged. Doesn’t match exactly the calculated value from the test reports
Source Cases  

moph_dashboad_prov.json | moph_dashboard_prov.csv

Source - https://ddc.moph.go.th/covid19-dashboard/?dashboard=province

Schema

Column  
Date  
Cases  
Cases Area Prison  
Cases Imported  
Cases Proactive  
Cases Walkin  
Deaths  
Tests No longer updated
Vac Given {1-3} Cum  
Positive Rate Dash The pre-calculated positive rate shown on the dashboard. It is already 7 day averaged. Doesn’t match exactly the calculated value from the test reports

moph_dashboad_ages.json | moph_dashboard_ages.csv

source - https://ddc.moph.go.th/covid19-dashboard/?dashboard=select-trend-line

Schema

Column  
Date  
Cases Age {age-group}  
Deaths Age {age-group}  
Cases Proactive Age {age-group}  

Age groups are {‘0-9’, ‘10-19’, ‘20-29’, ‘30-39’, ‘40-49’, ‘50-59’, ‘60-69’, ‘70+’}

Daily Situation Reports

Case Types and PUI counts

situation_reports.json | situation_reports.csv

PUI from situation reports Case Types

Schema

Column  
Date e.g “2021-04-06”
Cases Total cases that day. Cases Imported + Cases Local Transmission
Cases In Quarantine “Cases found in quarantine facilities/centers”
Cases Imported Cases In Quarantine + Cases outside quarantine
Cases Proactive Local transmissions that aren’t walk-ins
Cases Local Transmission “Cases infected in Thailand”. Cases Walkins + Cases Proactive
Tested PUI People Classified as Person Under Investigation.
Tested PUI Walkin Public “Sought medical services on their own at hospitals”/Public
Tested PUI Walkin Private “Sought medical services on their own at hospitals”/Private
The following are included but are not useful data since 2020-08.  
Tested Not different from PUI since 2020-08 says “Total number of laboratory tests” but is mislabeled.
Tested Quarantine Not changed since 2020-08. “Returnees in quarantine facilities/centers”.
Tested Proactive Not changed since 2020-08.Tested from “active case finding”.
Tested Not PUI Not changed since 2020-08. “People who did not meet the PUI criteria”.

Testing Reports

Private and Public Positive Test Results Private and Public Positive Tests Positive Test Results by health area PCR Tests by health area Positive Rate by Health District in overall positive rate (ex. some proactive tests)

Daily Tests Private+Public

tests_pubpriv.json | tests_pubpriv.csv

Schema

Column  
Date e.g “2021-04-06”
Tests PCR tests
Tests Private PCR tests from private labs. no longer updated
Pos Positive result
Pos Private Positive result from private labs. no longer updated
Pos XLS Tests positive results (includes corrected date-less data)
Tests XLS Tests conducted (includes corrected date-less data)

Tests by Health District

tests_by_area.json tests_by_area.csv

Schema

Column  
Start e.g “2021-04-06”
End e.g “2021-04-13”
Pos Area {1-13} Positive test results (PCR)
Tests Area {1-13} Total tests (PCR)

Vaccination Downloads

Daily DDC Vaccination Reports

vac_timeline.csv

Schema

Column    
Date 2021-04-25  
Vac Allocated Sinovac {dose} 3840.0  
Vac Allocated AstraZeneca {dose} 0.0  
Vac Delivered 200.00  
Vac Given {dose} Cum 3189.0  
Vac Given {dose} % 83.0  
Vac Group Medical Staff {dose} Cum 1939.0  
Vac Group Other Frontline Staff {dose} Cum 1081.0  
Vac Group Over 60 {dose} Cum 0.0  
Vac Group Risk: Disease {dose} Cum 54.0  
Vac Group Risk Location {dose} Cum 115.0

COVID-19 Vaccines Track and Traceability Platform for Cold Chain and Patient Safety

vaccinations.csv

Schema

Column    
Date 2021-04-25”  
Province “Bangkok”  
Vac Given Cum 3189.0  
Vac Given 83.0  
Vac Given {vaccine} Cum 3189.0  
Vac Given {vaccine} 83.0  
Vac Allocated {vaccine} {dose    
Vac Group {group} {dose Cum Cumulative vaccines given to particular risk group (dose 1 and 2)

BORA Monthly Deaths (Excess Deaths)

deaths_all.csv

Total deaths from all causes by province, month, age, gender

Schema:

Column      
Year 2012-2021    
Month 1-12    
Province      
Gender Male Female  
Age 0-101    
Deaths      

Deaths by Province

deaths.json, deaths.csv

Source: briefing reports

Schema

Column  
Date 2021-04-27
death_num 149.0
gender Male”
nationality ไทย”
age 47.0
Province Bangkok”
Following information is extracted by not properly parsed yet  
congenital_disease  
case_history  
risk_factor_sickness  
risk_factor_death  

Combined

combined.csv

Schema

Column  
Cases Age {‘0-9’, ‘10-19’, ‘20-29’, ‘30-39’, ‘40-49’, ‘50-59’, ‘60-69’, ‘70+’}  
Cases Risk {Group} Categorisation of Risk field from the covid-19-daily dataset
+ See all the above for data definitions