All Projects → OxCGRT → Covid Policy Tracker

OxCGRT / Covid Policy Tracker

Licence: cc-by-4.0
Systematic dataset of Covid-19 policy, from Oxford University

Projects that are alternatives of or similar to Covid Policy Tracker

digitalgov.gov
Digital.gov — Helping the government community deliver better digital services.
Stars: ✭ 167 (-55.23%)
Mutual labels:  government, policy
open-source-logiciel-libre
Open Source Software Requirements and Guidance (Draft) - Exigences et guides liés aux logiciels libres (Ébauche)
Stars: ✭ 31 (-91.69%)
Mutual labels:  government, policy
plainlanguage.gov
A resource to help federal employees write in plain language and comply with the Plain Writing Act of 2010
Stars: ✭ 111 (-70.24%)
Mutual labels:  government, policy
Dbpatterns
Dbpatterns is a service that allows you to create, share, explore database models on the web. Built on top of Django, Backbone. Patterns are stored on MongoDB, and uses Lettuce for BDD approach.
Stars: ✭ 355 (-4.83%)
Mutual labels:  database
Jodd
Jodd! Lightweight. Java. Zero dependencies. Use what you like.
Stars: ✭ 3,616 (+869.44%)
Mutual labels:  database
Bigchaindb
Meet BigchainDB. The blockchain database.
Stars: ✭ 3,768 (+910.19%)
Mutual labels:  database
Hive
Apache Hive
Stars: ✭ 4,031 (+980.7%)
Mutual labels:  database
K Rail
Kubernetes security tool for policy enforcement
Stars: ✭ 350 (-6.17%)
Mutual labels:  policy
T Rex
t-rex is a vector tile server specialized on publishing MVT tiles from your own data
Stars: ✭ 371 (-0.54%)
Mutual labels:  database
Lbadd
LBADD: An experimental, distributed SQL database
Stars: ✭ 362 (-2.95%)
Mutual labels:  database
Semanticmediawiki
🔗 Semantic MediaWiki turns MediaWiki into a knowledge management platform with query and export capabilities
Stars: ✭ 359 (-3.75%)
Mutual labels:  database
Django Watchman
django-watchman exposes a status endpoint for your backing services like databases, caches, etc.
Stars: ✭ 357 (-4.29%)
Mutual labels:  database
Sqlectron Gui
A simple and lightweight SQL client desktop with cross database and platform support.
Stars: ✭ 3,852 (+932.71%)
Mutual labels:  database
5e Database
Database for the D&D 5th Edition API
Stars: ✭ 354 (-5.09%)
Mutual labels:  database
Datalevin
A simple, fast and durable Datalog database
Stars: ✭ 360 (-3.49%)
Mutual labels:  database
Uniquewith Validator
Custom Laravel Validator for combined unique indexes
Stars: ✭ 352 (-5.63%)
Mutual labels:  database
Hyrise
Hyrise is a research in-memory database.
Stars: ✭ 371 (-0.54%)
Mutual labels:  database
Bitraft
🎉A Bitcask Distributed Key/Value store using Raft for consensus with a Redis compatible API written in Go.
Stars: ✭ 348 (-6.7%)
Mutual labels:  database
Rxjava2 Jdbc
RxJava2 integration with JDBC including Non-blocking Connection Pools
Stars: ✭ 360 (-3.49%)
Mutual labels:  database
K8tools
K8工具合集(内网渗透/提权工具/远程溢出/漏洞利用/扫描工具/密码破解/免杀工具/Exploit/APT/0day/Shellcode/Payload/priviledge/BypassUAC/OverFlow/WebShell/PenTest) Web GetShell Exploit(Struts2/Zimbra/Weblogic/Tomcat/Apache/Jboss/DotNetNuke/zabbix)
Stars: ✭ 4,173 (+1018.77%)
Mutual labels:  database

UPDATE:

  • We are creating a mailing list to provide technical users with slightly more detailed release notes, and advance warning of changes to database structure. You can register for these email updates here: http://eepurl.com/hiMsdL


Oxford Covid-19 Government Response Tracker (OxCGRT)

The Oxford Covid-19 Government Response Tracker (OxCGRT) collects systematic information on which governments have taken which measures, and when. This can help decision-makers and citizens understand governmental responses in a consistent way, aiding efforts to fight the pandemic. The OxCGRT systematically collects information on several different common policy responses governments have taken, records these policies on a scale to reflect the extent of government action, and aggregates these scores into a suite of policy indices.

This is a project from the Blavatnik School of Government. More information on the OxCGRT is available on the school's website: https://www.bsg.ox.ac.uk/covidtracker. This README contains information about using the database.


Cite as: Thomas Hale, Sam Webster, Anna Petherick, Toby Phillips, and Beatriz Kira. (2020). Oxford COVID-19 Government Response Tracker. Blavatnik School of Government.


The database

OxCGRT collects publicly available information on 19 indicators of government response. This information is collected by a team of over 200 volunteers from the Oxford community and is updated continuously.

We also include statistics on the number of reported Covid-19 cases and deaths in each country. These are taken from the JHU CSSE data repository for all countries and the US States.

Individual policy measures

Full descriptions of the policy indicators and their meaning can be found in our codebook. For more detailed guidance about the codebook and how we interpret the indicators, see the coding interpretation guide. This ensures consistency, and standardizes coding across the database.

Eight of the policy indicators (C1-C8) record information on containment and closure policies, such as school closures and restrictions in movement. Four of the indicators (E1-E4) record economic policies such as income support to citizens or provision of foreign aid. And seven indicators (H1-H7) record health system policies such as the Covid-19 testing regime or emergency investments into healthcare.

Finally, we have a miscellaneous indicator (M1) for notes that do not fit elsewhere.

Policy indices

To help make sense of the data, we have produced four indices that aggregate the data into a single number. Each of these indices report a number between 0 to 100 that reflects the level of the governments response along certain dimensions. This is a measure of how many of the relevant indicators a government has acted upon, and to what degree. The index cannot say whether a government's policy has been implemented effectively.

  • overall government response index (all indicators)
  • containment and health index (all C and H indicators)
  • stringency index (all C indicators, plus H1 which records public information campaigns)
  • economic support index (all E indicators)

(Note: these only include indicators recorded on ordinal scales, so they all exclude E3, E4, H4, H5, and M1.)

The documentation folder contains an index methodology page explaining how the different indexes are calculated and how they are reported for days with incomplete data. This also describes the methodology for the legacy stringency index which is based on the old database structure in place prior to 25 April 2020.

Subnational data

In addition to country-level data, our primary dataset additionally includes some subnational data. So far we have incorporated data for US states, Brazilian States, and UK devolved nations into the primary dataset on this covid-policy-tracker repository. These subnational entities are included in our /data/OxCGRT_latest.csv and /data/OxCGRT_latest_withnotes.csv. But no other CSVs at this stage.

Subnational data can be interpreted using the main codebook, with additional guidance on subnational-specific interpretation available in the documentation folder. The state data included in our primary dataset aims to describe the overall policy environment that applies to residents of the state, and so includes policies set by the national government where those values are more stringent than state-level action. For data that focuses only on subnational policies, see our additional datasets in the OxCGRT/USA-covid-policy and OxCGRT/Brazil-covid-policy respositories.

Our documentation and working papers have more information

The most up-to-date description of database components is here in the documentation folder of this GitHub repo, which contains a detailed codebook, index methodology, a coding interpretation guide, and notes on subnational interpretation.

We have also published a national working paper with our national methodology, data collection protocols, and description of the individual indicators.

Legacy database structure (from before 25 April 2020)

Prior to 25 April 2020 the OxCGRT had a structure of 13 indicators (labelled S1-S13). Data up until this point is archived and still available in the /legacy_data_20200425 folder.

Using OxCGRT data

The OxCGRT is updated continuously in real time. There are numerous ways you can access the raw data.

Getting data from this GitHub repository

Data link to OxCGRT <-- status of connection to OxCGRT database

The /data folder in this repo contains recent exports from the OxCGRT database. You are welcome to build applications that draw directly from this repository.

  • The CSV file /data/OxCGRT_latest.csv reports country/territory- and state-level data presented in "country/territory-day" format (or "state-day" as the case may be), with a list of all indicators for each country/territory as a single row each day. This CSV is updated every hour from the main database, and the badge above shows whether this data link is functioning correctly.
  • The CSV file /data/OxCGRT_latest_combined.csv reports country/territory- and state-level data in "country/territory-day" format, but gives a single "combined" value for each indicator. As described in the codebook, many of our indicators are recorded across two variables: one that records the strictness of the policy, and one that records its scope.
    • This is reported as a combination of the policy level (a number) and the scope flag (a letter: T for targetted policies or G for general policie; or F/A flags for indicator E1). For instance, for C3_Cancel public events we would have 0, 1T (recommend cancelling in some areas), 1G (recommend cancelling everywhere), 2T (require cancelling in some areas), 2G (require cancelling everywhere).
    • We also include a numerical combination, using the same methodology to calculate compenents for our indices: a targeted policy is considered a half-step lower than a general jurisdiction-wide policy. For instance, for C3_Cancel public events we would have 0, 0.5 (recommend cancelling in some areas), 1 (recommend cancelling everywhere), 1.5 (require cancelling in some areas), 2 (require cancelling everywhere).
  • The CSV file /data/OxCGRT_latest_withnotes.csv reports country/territory- and state-level data in "country/territory-day" format with a column of notes from our data collectors for each indicator. This is also updated every hour from the main database. Please note that some of the comments contain commas and other characters interpreted as a delimiter, and so may cause problems when parsing this CSV file.
  • The CSV file /data/OxCGRT_latest_allchanges.csv reports country/territory-level data with a list of every change to the database. Every time a policy value changes, or every time a note is added to an indicator, it is represented with it's own new row. (This does not include subnational data.)
  • The /data/timeseries folder reports country/territory-level data as individual timeseries for each indicator (except for the non-ordinal indicators E3, E4, H4, H5 and M1) in CSV format, as well as a combined Excel file with a tab for each indicator. This is updated periodically – usually daily – and the date will be listed in the commit description and at the bottom of each sheet. (This does not include subnational data.)
  • The CSV file /data/OxCGRT_US_states_temp.csv is a temporary CSV that presents only US state-level data in "state-day" format, with a column of notes from our data collectors for each indicator. This is updated manually.

Getting data through our API

You can also get some OxCGRT national-level data through our API. Documentation for this is published here.

Data quality

It is important to understand the limitations of this dataset, most of which stem from the "live" nature of data collection. Our first goal is to publish a real-time dataset; but this carries risks. For instance, you may get a version of the database that was exported just as our team was half-way through entering new data, or that was exported in the window between an error being made and being fixed.

For details on how these issues around patchy or missing data affect our index calculations, please see our documentation on calculating indices.

  • Be skeptical of reductions in index values. Incomplete or missing data will sometimes cause a dip in the calculated index (we conservatively treat some missing values as 0). For most countries, a reduction in index level that is recent, relatively small (less than 10 points), or only lasts a couple of days, is more likely the result of missing data rather than a legitimate reduction in the underlying policy.
  • Not all countries are equally up to date. We try to ensure that all countries and relevant subnational units are updated at least once a week, and most countries are updated more frequently. But there will inevitably be "patchiness" within the last week.
  • For each country/territory, some indicators will be missing in some days. As our data collectors find information, they will update a country/territory in real time. This means a country/territory may only have up-to-date information for some indicators, but not all.
  • Some indicators (and therefore, index values) will be changed retroactively. We aim to have a second pair of eyes review every data point in the OxCGRT. As at 19 May 2020, the majority of our 400,000 data points are yet to be reviewed. Inevitably, some things may be tweaked in this review process, leading to changes to past dates. We recommend you frequently download fresh data from OxCGRT, rather than relying on an old export.
  • Null values are not the same as 0. The gaps described above – where countries are not up to date, or where some indicators are missing – will be represented as null values. These should not be interpreted as a 0, although for the purposes of calculating our indices, we conservatively treat them as such.
  • Fiscal and monetary indicators are not evenly covered. We do not yet have comprehensive and high quality coverage of our indicators E3, E4, H4, and H5. You should check the data carefully before using these indicators.

Sample analysis

Here are several examples of the type of analysis enabled by OxCGRT:

Analysis of specific countries

An individual chart of each country/territory is in the /images/country charts folder.

Global comparisons

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].