🚧
Data Encoding Guidelines
ShortURL | Playbook | Assistant
NOTICE
This documentation page is under construction. Should you want to be notified once it's published, let us know.

About

Table of Contents

  1. 1.
    Abstract
  2. 2.
    Definitions
  3. 3.
    The Editor's Data Entry Interface
​

Abstract

This guide is aimed at Project Lockdown's Editors to help them in their task of analyzing sources and encoding the necessary data points for the COVID-19 NPIs Dataset Layer.
Back to top

Definitions

Source

A document from which the information needed by Project Lockdown can be obtained. For more information on how Project Lockdown selects Sources, please check our [[Sources Policy|https://github.com/Code-for-All/lockdown/wiki/Policies#sources]].

Territory

A Territory is a piece of land on Earth that Project Lockdown is monitoring. For more information on how Project Lockdown selects Territories, please check our [[Territories Policy|https://github.com/Code-for-All/lockdown/wiki/Policies#territories]].

Data Point

A Data Point is a piece of information extracted from a Source that is being measured by Project Lockdown.

Data Entry set

A Data Entry set is an organized collection of Data Points that is used to analyze the contents of a Source. **A Data Entry set can ONLY codify ONE Source. ** Why? It is important that to keep track of the granular occurrence of pronouncements. This will allow to evaluate how mandates from a Territory evolved and how this may have affected their recovery. Rule of thumb: One Source, One Data Entry set.
Back to top

The Editor's data entry interface

The current platform to enter data for Project Lockdown is a Google Sheet. You can find the latest revision of it always here: Data Entry Interface: https://TIOF.Click/PLDDEI​

How to use it the data entry interface

The Global sheet

In this sheet you'll find a list of all the Territories that Project Lockdown is monitoring. You'll see that on the left of each Territory name there is a hyperlink. Click on it to jump to that Territory's sheet.
Rule of thumb: To introduce data about a Territory, find it on the Global sheet and click on the "Go to this tab!" link on the left.

PLDCode sheet (Territory sheet)

Each Territory has a sheet that is named after its ISO 3 Alpha code. We call these PLDCode sheets. In these sheets Editors introduce the data extracted from Sources.
Each PLDCode sheet is composed by 2 areas:
  • Left: Info & Actions (Top) + Questions (Bottom)
  • Right: Data Entry sets
Info & Actions
A general set of fields provides information on the territory being referred.
You have 2 buttons there that allow you to:
  • Go back to the Global sheet
  • Create a new Data Entry Set (DES)
Questions (data points)
Questions are organized in 3 sections
  • Data Entry Source
  • Daily Activities
  • Mobility Each and one of them evaluate a number of Data Points.
Managing Data Entry sets
Data Entry sets are the core of the information that Editors introduce for Project Lockdown. Each Data Entry set encodes one, and only one, Source.
Data Entry sets are composed by:
  • Metadata
  • Data Point answers
Metadata
This section indicates information relative to the Data Entry set itself. It is composed by the following fields:
(1) EntryUID
Automatically generated, it uniquely identifies each Data Entry set in the database. Rule of thumb: You do not have to worry about this field.
(2) Timestamp
Automatically generated, it indicates the date and time that a Data Entry set was created, measured respective to UTC+0 (GMT+0). Rule of thumb: You do not have to worry about this field.
(3) Deliberation
This section is used to link a Data Entry set with the platform where Deliberations may be had if there some information is flagged. You can safely ignore this part for the time being. Rule of thumb: You do not have to worry about these fields at the moment.
(4) Status
This field indicates the status of this Data Entry set. It determines whether the information is ready to go live or not. Possible values:
  • Standby: The Data Entry set is yet not ready and must be be reviewed.
  • Ready: The Data Entry set is considered ready and will be shown in the website.
  • Demo: For internal use.
  • Flagged: The Data Entry set has some information that has been contested or otherwise considered inaccurate. The information will still go live although it will undergo a revision. For more information on your how Project Lockdown deals with flagged information, please visit our [Transparency and Accountability Policy](Transparency and Accountability Policy)
(5) Editor
This field allows you to identify who is the Editor for this Data Entry set. How to use: Just select your name out of list. What if my name is not on the list? Please notify one of the Coordinators.
(5) Reviewed by
This field allows you to identify who is the Editor/Coordinator who reviewed this Data Entry set. Rule of thumb: You do not have to worry about this field.
(6) Type
This field indicates the TYPE of Source to be encoded by this Data Entry set. How to use: Select the type of Source. Rule of thumb: Please always try to find the actual official pronouncement. Government >>>> Media > Other sources.
Data Point answers
Each Data Point is composed by 4 fields: Answer: The actual answer to the question posed for the Data Point. Start Date: When does the Answer start applying in time. End Date: When does the Answer stop applying in time. Details: Any extra information you feel is relevant to keep track of.
Data Entry Source questions
(10.1) Name of the pronouncement or media release
Ask yourself: What is the name of the Source I am entering? How to Answer: Enter the official name of the Source document. Use the official denomination on the language it was issued, whenever possible. Example: Official Gazette 23-2020 or Real Decreto 45-7/2020
(10.2) Source URL
Ask yourself: How could I verify the data that is reflected in this Data Entry set? How to Answer: Enter the URL to the Source. It doesn't matter if its a website or a PDF document, for instance. Example: https://www.pmo.gov.my/2020/03/perutusan-khas-yab-perdana-menteri-mengenai-covid-19-16-mac-2020/
(10.3) Title of the Status
Ask yourself: Does the Source announce a change on the official Status of the Territory? That being the case, how is the government calling that new Status? How to Answer: This field applies ONLY if the Source announces a change in the legal Status of the Territory. Try to find the name of the new Status in the dropdown and select it. If it doesn't exist there, select "Others(Yes) and indicate the new Status name on the Details field. Examples: a) The new Status is "State of Alarm": That Status exists so just select b) The new Status is "State of Fantasy": That Status doesn't exist so select "Others (Yes)" and indicate "State of Fantasy in Details.
(10.4) Date of issuance
Ask yourself: When did this Source be made public? From when and until when will it apply? How to Answer:
  • Answer: Indicate the Date of Issuance
  • Start Date: Indicate when the Source starts to apply.
  • End Date: Indicate when the Source ends to apply.
  • Details: Indicate any details you deem relevant.
Example: A pronouncement X was issued on the 1st of March. It indicates it will enter in effect on the 3rd of March for a period of 6 months.
  • Answer: 1 March
  • Start Date: 3 March
  • End Date: 3 September
  • Details: No extra information seems relevant so this field remains empty.
(20.1) What is the maximum assembly allowed (PAX)?
Ask yourself: How many people can get together, in an open space, freely, in compliance to the basic Human Right of Freedom of Assembly and Association (UDHR, Article 20)? How to Answer: Enter the number dictated by the Source. Should there be any special circumstances, please indicate them on Details.
  • Answer: The number of PAX
  • Start Date: Indicate when the restriction starts to apply.
  • End Date: Indicate when the restriction ends to apply.
  • Details: Indicate any details you deem relevant.
Example: Australia mandates that people may not gather in groups larger than 10 from 14th March to 1st April. Exceptions are made for large families who may be sharing a same roof during the lockdown.
  • Answer: 50
  • Start Date: 14 March
  • End Date: 1 April
  • Details: Exception: For larger families under same roof this limitation does not apply.
(20.2) Can regular individuals leave their homes?
Ask yourself: Can regular people go out of their homes? Is their Freedom of Movement (UDHR, Article 13) being respected? (This does not include those who are mandated/allowed to go out to help with the pandemic such as medical frontliners, essential personnel, law enforcement, etc.) How to Answer:
  • Answer: Select one of these options:
    • Yes: ABSOLUTE YES - Under no circumstances people will get into legal trouble if they go out of their homes, applied to thee whole Territory.
    • No: ABSOLUTE NO - If people go out as regularly and are caught outside of their homes they do face legal consequences EXCEPT if they do so for a justifiable emergency.
    • Partially: Anything in between Yes and No. This includes the following case scenarios:
      • When the lockdown is enacted yet NOT applied at National level (applies at State, Province, City or otherwise).
    • Unclear: The text mentions this provision yet in very uncertain terms that don't allow to determine what's the actual policy.
  • Start Date: Indicate when the mandate starts to apply.
  • End Date: Indicate when the mandate ends to apply.
  • Details: Indicate any details you deem relevant.
Example: Spain indicates that from 1 March to 15 March it is not allowed to leave home except in case of emergency, shopping and to walk dogs.
  • Answer: No
  • Start Date: 1 March
  • End Date: 15 March
  • Details: Exception: Walking dogs is allowed.
(20.3) Can regular individuals undertake outdoor activities?
Ask yourself: Can regular people do outdoor activities? Is their Freedom of Movement (UDHR, Article 13) being respected? (This does not include those who are mandated/allowed to go out to help with the pandemic such as medical frontliners, essential personnel, law enforcement, etc.) How to Answer:
  • Answer: Select one of these options:
    • Yes: ABSOLUTE YES - Under no circumstances people will get into legal trouble if they go out for outdoor activities.
    • No: ABSOLUTE NO - If people our caught outdoors they do face legal consequences EXCEPT if they do so for a justifiable emergency. This includes the following case scenarios:
      • Requiring a PRIOR authorization before leaving the house
    • Partially: Anything in between Yes and No. This includes the following case scenarios:
      • Curfews
    • Unclear: The text mentions this provision yet in very uncertain terms that don't allow to determine what's the actual policy.
  • Start Date: Indicate when the mandate starts to apply.
  • End Date: Indicate when the mandate ends to apply.
  • Details: Indicate any details you deem relevant.
Example: Spain indicates that from 1 March to 15 March it is not allowed to leave home except in case of emergency, shopping and to walk dogs.
  • Answer: Partially
  • Start Date: 1 March
  • End Date: 15 March
  • Details: Exception: Walking dogs is allowed.
(20.4) Can regular individuals attend religious sites?
Ask yourself: Can people go to religious sites? Is their Freedom of Belief being observed (UDHR, Article 18)? How to Answer:
  • Answer: Select one of these options:
    • Yes: ABSOLUTE YES - Religious sites are open to the public and people can freely attend any time.
    • No: ABSOLUTE NO - Religious sites are closed and people can't go to them.
    • Partially: Anything in between Yes and No.
    • Unclear: The text mentions this provision yet in very uncertain terms that don't allow to determine what's the actual policy.
  • Start Date: Indicate when the mandate starts to apply.
  • End Date: Indicate when the mandate ends to apply.
  • Details: Indicate any details you deem relevant.
Example: Malaysia mandates that from 13 March to 15 April religious sites of all creeds to be closed.
  • Answer: No
  • Start Date: 13 March
  • End Date: 15 April
  • Details: None.
(20.5) Can regular individuals go to work?
Ask yourself: Can people go to their working place? Is their Right to Work being observed (UDHR, Article 23)? How to Answer:
  • Answer: Select one of these options:
    • Yes: ABSOLUTE YES - People can go to their work place as usual, even if encouraged to work remotely.
    • No: ABSOLUTE NO - People are not allowed to go to their work place under no circumstance EXCEPT if they are a member of a force helping with the pandemic, such as medical frontliners, law enforcement, etc.
    • Partially: Anything in between Yes and No.
    • Unclear: The text mentions this provision yet in very uncertain terms that don't allow to determine what's the actual policy.
  • Start Date: Indicate when the mandate starts to apply.
  • End Date: Indicate when the mandate ends to apply.
  • Details: Indicate any details you deem relevant.
Example: Singapore mandates that from 1 April March to 15 April all offices are to be closed and all non-essential services must work remotely.
  • Answer: No
  • Start Date: 1 April
  • End Date: 15 April
  • Details: None
(20.6) No military reinforcements?
Ask yourself: Has there been NO INCREASE in response from the army during this pandemic? Do you observe the SAME forces being deployed as before the crisis? How to Answer:
  • Answer: Select one of these options:
    • Yes: ABSOLUTE YES - There is no increase in numbers or otherwise in the streets.
    • No: ABSOLUTE NO - New reinforcements have been deployed in the streets.
    • Partially: Anything in between Yes and No.
    • Unclear: The text mentions this provision yet in very uncertain terms that don't allow to determine what's the actual policy.
  • Start Date: Indicate when the mandate starts to apply.
  • End Date: Indicate when the mandate ends to apply.
  • Details: Indicate any details you deem relevant.
Example: Malaysia has requested the military to join forces with Law Enforcement forces to ensure the roadblocks are properly manned in order to observe the lockdown from 20 March onwards.
  • Answer: No
  • Start Date: 1 April
  • End Date: (NOTE, there is NO end date in the mandate so this field is left empty)
  • Details: None.
(20.7) Can regular individuals attend classes?
Ask yourself: Can students, of any category, go to their learning centre? How to Answer:
  • Answer: Select one of these options:
    • Yes: ABSOLUTE YES - It is possible for everyone to attend their learning institutions.
    • No: ABSOLUTE NO - It is forbidden to attend class and learning institutions are closed.
    • Partially: Anything in between Yes and No.
    • Unclear: The text mentions this provision yet in very uncertain terms that don't allow to determine what's the actual policy.
  • Start Date: Indicate when the mandate starts to apply.
  • End Date: Indicate when the mandate ends to apply.
  • Details: Indicate any details you deem relevant.
Example: Peru establishes that Primary and Secondary schools are to remain open whereas universities are to remain closed, from 1 April until further notice.
  • Answer: Partially
  • Start Date: 1 April
  • End Date: (NOTE, there is NO end date in the mandate so this field is left empty)
  • Details: None.
(20.8) Can regular individuals go shopping?
Ask yourself: Can people go to shop without restrictions? How to Answer:
  • Answer: Select one of these options:
    • Yes: ABSOLUTE YES - It is possible for everyone to go outdoors to shop anything they want.
    • No: ABSOLUTE NO - It is forbidden perform any kind of shopping outdoors.
    • Partially: Anything in between Yes and No.
    • Unclear: The text mentions this provision yet in very uncertain terms that don't allow to determine what's the actual policy.
  • Start Date: Indicate when the mandate starts to apply.
  • End Date: Indicate when the mandate ends to apply.
  • Details: Indicate any details you deem relevant.
Example: The US indicates that from 25 March to 30 April all shopping must be done online, no exceptions.
  • Answer: No
  • Start Date: 25 March
  • End Date: 30 April
  • Details: None.
(20.9) Is Electricity ensured?
Ask yourself: Has the Government established reassurances on supplying electricity to their citizens? How to Answer:
  • Answer: Select one of these options:
    • Yes: ABSOLUTE YES - There is an explicit mandate for electricity to be maintained during the crisis.
    • No: ABSOLUTE NO - There is an explicit indication that electricity will not be ensured during the crisis.
    • Partially: Anything in between Yes and No.
    • Unclear: The text mentions this provision yet in very uncertain terms that don't allow to determine what's the actual policy.
  • Start Date: Indicate when the mandate starts to apply.
  • End Date: Indicate when the mandate ends to apply.
  • Details: Indicate any details you deem relevant.
Example: Spain indicates that the supply of Electricity, gaz and other energy sources will be ensured at all given times across the crisis. This mandate is issued on the same pronouncement that declares the State of Alarm in the territory.
  • Answer: Yes
  • Start Date: 18 March
  • End Date: (NOTE, there is NO end date in the mandate so this field is left empty)
  • Details: None.
(20.10) Is Water supply ensured?
Ask yourself: Has the Government established reassurances on water supply to their citizens? How to Answer:
  • Answer: Select one of these options:
    • Yes: ABSOLUTE YES - There is an explicit mandate for water supply to be maintained during the crisis.
    • No: ABSOLUTE NO - There is an explicit indication that water supply will not be ensured during the crisis.
    • Partially: Anything in between Yes and No.
    • Unclear: The text mentions this provision yet in very uncertain terms that don't allow to determine what's the actual policy.
  • Start Date: Indicate when the mandate starts to apply.
  • End Date: Indicate when the mandate ends to apply.
  • Details: Indicate any details you deem relevant.
Example: France does not mention any specifics on the subject when declaring their State of Emergency.
  • Answer: Partially.
  • Start Date: 15 March
  • End Date: (NOTE, there is NO end date in the mandate so this field is left empty)
  • Details: None.
(20.11) Is Internet (telecommunications) ensured?
Ask yourself: Has the Government established reassurances to provide communication services to their citizens? How to Answer:
  • Answer: Select one of these options:
    • Yes: ABSOLUTE YES - There is an explicit mandate for communication services to be maintained during the crisis.
    • No: ABSOLUTE NO - There is an explicit indication that communication services will not be ensured during the crisis.
    • Partially: Anything in between Yes and No.
    • Unclear: The text mentions this provision yet in very uncertain terms that don't allow to determine what's the actual policy.
  • Start Date: Indicate when the mandate starts to apply.
  • End Date: Indicate when the mandate ends to apply.
  • Details: Indicate any details you deem relevant.
Example: Rwanda announces that they will focus their manpower to ensure electricity and thus communication services will be shut down until further notice. Voice calls will still function.
  • Answer: No.
  • Start Date: 20 March
  • End Date: (NOTE, there is NO end date in the mandate so this field is left empty)
  • Details: Voice calls are available, only Data is not.
Back to top