Covid Thailand Trends

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

---

Project maintained by Hosted on GitHub Pages — Theme by mattgraham

Downloads

Daily CCSA Briefings

• Sources
  • CCSA Daily Briefing - Uploaded ~1-2pm each day
  • MOPH COVID 19 Dashboard
  • API: Details of all confirmed COVID-19 infections - 1-2 days delayed
  • API: Daily Summary of Cases/Deaths/Recovered
  • Daily infographics translated and tweeted Updated daily around midday (after gov briefing) - No Longer updated

cases_briefings.json | cases_briefings.csv

• Schema:
  • 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 None: Deaths where there wasn’t a disease that increased risk
  • Deaths {Female,Male}: Deaths for 2 of the genders
  • Deaths Risk Family: Deaths who likely cause of transmission was via family member
  • 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:
  • “Date”: e.g “2021-04-06”
  • “Province”: e.g “Samut Sakhon”
  • “Cases”: Confirmed cases in this province
  • “Health District Number”: 1-13 - see Thailand Health Areas
  • The following is no longer updated
    • “Cases Walkin”: Confirmed cases found those requesting tests or asked to from contact tracing or the media. Paid or having met the PUI criteria. No longer updated
    • “Cases Proactive”: Confirmed cases found government has gone to specific areas to mass test due to high risk of COVID-19. No longer updated
    • “Deaths”: 31.0

Cases/Deaths per Health District

cases_by_area.json, cases_by_area.csv

• Schema cases_by_area:
  • “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
• Notes:
  • Thailand Health Areas

Deaths by Province

deaths.json, deaths.csv

• Schema:
  • e.g
    • “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”:
• Notes:
  • Stopped being published 2021-04-28. Only summary data in cases_by_area is continuing

MOPH Covid-19 Dashboard

• Sources MOPH Covid-19 Dashboard

  moph_dashboad.json | moph_dashboard.csv

• Schema
  • Date
  • ATK
  • Cases
  • Cases Area Prison
  • Cases Imported
  • Cases Proactive
  • Cases Walkin
  • Deaths
  • Hospitalized
  • Hospitalized Field
  • Hospitalized Field HICI
  • Hospitalized Field Hospitel
  • Hospitalized Field Other
  • Hospitalized Hospital
  • Hospitalized Respirator
  • Hospitalized Severe
  • Recovered
  • Source Cases
  • Tests
  • Vac Given {1-3} Cum

moph_dashboad_prov.json | moph_dashboard_prov.csv

• Schema
  • Date
  • ATK
  • Cases
  • Cases Area Prison
  • Cases Imported
  • Cases Proactive
  • Cases Walkin
  • Deaths
  • Tests
  • Vac Given {1-3} Cum

moph_dashboad_ages.json | moph_dashboard_ages.csv

• Schema
  • Date
  • Cases Age {‘0-9’, ‘10-19’, ‘20-29’, ‘30-39’, ‘40-49’, ‘50-59’, ‘60-69’, ‘70+’}
  • Deaths Age {‘0-9’, ‘10-19’, ‘20-29’, ‘30-39’, ‘40-49’, ‘50-59’, ‘60-69’, ‘70+’}
  • Hospitalized Severe Age {‘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

• Sources:
  • MOPH daily situation report PDFs (Updated daily in the evening)
  • MOPH daily situation report PDFs (english translations) (Updated a few days later)
  • DDC Website - Today’s PUI count

• Schema
  • 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”.
• The following aren’t yet included
  • Screened Ports: “Type of Screened People and PUI / Ports of entry (Airports, ground ports, and seaports)”
  • Screened Immigration “Type of Screened People and PUI / People renewing their passports at the Immigration Bureau, Chaeng Watthana”
• Notes:
  • The only useful Tested number is “Tested PUI”.
  • All the daily numbers have cumulative raw data columns (ending in “Cum”) from which the daily numbers are calculated
    • except for all the Cases numbers from 2020-11-02 where daily numbers are taken from the reports
    • to calculate daily numbers missing data is interpolated
  • There are some figures in these reports not included
    • Screened Ports: Screened at “Ports of entry”
    • Screened Immigration: “People renewing their passports at the Immigration Bureau, Chaeng Watthana”
    • Data found in other places e.g.
      • Deaths
      • Recovered
      • Hospitalized

Testing Data

• Source:
  • DMSC: Thailand Laboratory testing data - latest report (updated weekly but sporadic)
  • DMSC: Thailand Laboratory testing data - weekly summary reports
  • also available via data.go.th testing data
  • Other info on lab network
  • This datasource is incomplete as not all tests go via this DMSc’co-lab database. In particular times with large amounts of proactive testing sometimes result in more cases reported than positive results.

Daily Tests Private+Public

tests_pubpriv.json | tests_pubpriv.csv

• Schema:
  • Date: e.g “2021-04-06”
  • Tests: PCR tests
  • Tests Private: PCR tests from private labs
  • Pos: Positive result
  • Pos Private: Positive result from private labs
  • Pos XLS: Tests positive results (includes corrected date-less data)
  • Tests XLS: Tests conducted (includes corrected date-less data)
• Notes:
  • Uses case history graphs from the latest PPTX
  • data seems to exclude some non-PCR tests (likely used in some proactive testing)
  • The Test XLS data includes a number of tests and results for which the date is unknown. This has been redistributed into the Pos XLS and Tests XLS numbers. Other than this it should be the same numbers as Pos and Tests.

Tests by Health District

tests_by_area.json tests_by_area.csv

• Schema:
  • Start: e.g “2021-04-06”
  • End: e.g “2021-04-13”
  • Pos Area {1-13} - Positive test results
  • Tests Area {1-13} - Total tests (PCR)
• Notes:
  • not all periods are a week
  • data seems to exclude non-PCR tests (likely used in some proactive testing)
  • There are missing files, so some weeks’ data are not shown
  • The example graphs shown have been extrapolated using daily totals from the test daily data

Vaccination Downloads

Daily DDC Vaccination Reports

vac_timeline.csv

• Source:
  • DDC Daily Vaccination Reports
  • COVID-19 Vaccines Track and Traceability Platform for Cold Chain and Patient Safety
• Schema e.g.

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

• Note
  • The previous data per province is no longer updated in the reports so this download has been removed.
  • “Vaccinations Given 1/2 %” refers to the % of allocation, not against population.
  • 1/2 refers to shot 1 or shot 2.
  • Some days some tables are images so there is missing data.
  • Summary vaccination data included in the combine download
  • Delivered Vaccines comes from [Track and Traceability Platform]((https://datastudio.google.com/u/0/reporting/731713b6-a3c4-4766-ab9d-a6502a4e7dd6/page/SpZGC)
  • #TODO: put in thai group explanations.

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

vaccinations.csv

• Source:
  • DDC Daily Vaccination Reports
  • COVID-19 Vaccines Track and Traceability Platform for Cold Chain and Patient Safety
• Schema:

      "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} {1-2}:
      "Vac Group {group} {1-2} Cum: Cumulative vaccines given to particular risk group (dose 1 and 2)
  

BORA Monthly Deaths (Excess Deaths)

deaths_all.csv

• Source:
  • Office of Registration Administration, Department of Provincial Administration
• Schema:
  • Year: 2012-2021
  • Month: 1-12
  • Province:

  • Gender: Male

    Female

  • Age: 0-101
  • Deaths:

Combined

combined.csv

• Source:
  • All the above daily sources combined
  • plus COVID-19 report, periodic summary
• Schema:
  • 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