Covid Restrictions.

Setting up the environment Initialization of the Ontology editor in Jupyter Notebook

[1]:
from cognipy.ontology import Ontology
from cognipy.ontology import CQL
from cognipy.ontology import ABoxBatch
from cognipy.ontology import encode_string_for_graph_label
from cognipy.edit import CnlEditBox
from cognipy.edit import CnlQueryForConcept

import random
import textwrap
import numpy as np
import pandas as pd
import pickle
import datetime

def graph_attribute_formatter(val):
    if isinstance(val,list) or isinstance(val,set):
        return " | ".join(list(map(lambda i:encode_string_for_graph_label(graph_attribute_formatter(i)),val)))
    elif isinstance(val,dict):
        return " | ".join(list(map(lambda i:i[0]+" : "+encode_string_for_graph_label(graph_attribute_formatter(i[1])),val.items())))
    else:
        return encode_string_for_graph_label(textwrap.fill(str(val),40))

from pint import UnitRegistry
ureg = UnitRegistry()
Q = ureg.Quantity

def Qstr(a):
    return "Q('"+str(a)+"')"
Q.__repr__=Qstr

Lets setup the fist ontology editor for the general knowledge. The editor allows you to enter the knowledge in text format, and support you with the prdictive editor.

[2]:
policies=pd.read_csv('https://raw.githubusercontent.com/saudiwin/corona_tscs/master/data/CoronaNet/data_country/coronanet_release/coronanet_release_Australia.csv', encoding='cp1252',index_col=0)
[3]:
pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)
pd.set_option('display.width', None)
pd.set_option('display.max_colwidth', -1)
c:\users\pkapl\anaconda3\envs\makler\lib\site-packages\ipykernel_launcher.py:4: FutureWarning: Passing a negative integer is deprecated in version 1.0 and will not be supported in future version. Instead, use None to not limit the column width.
  after removing the cwd from sys.path.
[4]:
policies_cnl_lines=[]
for i,row in policies[policies['entry_type']=='new_entry'].iterrows():
    policies_cnl_lines.append(f"Australia introduced Policy-{row.policy_id}.")
    policies_cnl_lines.append(f"Policy-{row.policy_id} is a restriction and was-introduced equal-to {row.date_start}.")
    if not row.date_end!=row.date_end:
        policies_cnl_lines.append(f"Policy-{row.policy_id} was-withdrawn  equal-to {row.date_end}.")
[5]:
policies_cnl_lines
[5]:
['Australia introduced Policy-3144269.',
 'Policy-3144269 is a restriction and was-introduced equal-to 2020-03-24.',
 'Policy-3144269 was-withdrawn  equal-to 2020-04-26.',
 'Australia introduced Policy-3144269.',
 'Policy-3144269 is a restriction and was-introduced equal-to 2020-03-24.',
 'Policy-3144269 was-withdrawn  equal-to 2020-04-26.',
 'Australia introduced Policy-3144269.',
 'Policy-3144269 is a restriction and was-introduced equal-to 2020-03-24.',
 'Policy-3144269 was-withdrawn  equal-to 2020-04-26.',
 'Australia introduced Policy-7778287.',
 'Policy-7778287 is a restriction and was-introduced equal-to 2020-03-24.',
 'Australia introduced Policy-7778287.',
 'Policy-7778287 is a restriction and was-introduced equal-to 2020-03-24.',
 'Australia introduced Policy-4610550.',
 'Policy-4610550 is a restriction and was-introduced equal-to 2020-04-06.',
 'Policy-4610550 was-withdrawn  equal-to 2020-07-12.',
 'Australia introduced Policy-4531517.',
 'Policy-4531517 is a restriction and was-introduced equal-to 2020-01-29.',
 'Policy-4531517 was-withdrawn  equal-to 2020-12-31.',
 'Australia introduced Policy-4668893.',
 'Policy-4668893 is a restriction and was-introduced equal-to 2020-03-16.',
 'Policy-4668893 was-withdrawn  equal-to 2020-09-14.',
 'Australia introduced Policy-8782298.',
 'Policy-8782298 is a restriction and was-introduced equal-to 2020-03-16.',
 'Policy-8782298 was-withdrawn  equal-to 2020-07-07.',
 'Australia introduced Policy-6543237.',
 'Policy-6543237 is a restriction and was-introduced equal-to 2020-03-17.',
 'Australia introduced Policy-8990133.',
 'Policy-8990133 is a restriction and was-introduced equal-to 2020-03-17.',
 'Australia introduced Policy-6796297.',
 'Policy-6796297 is a restriction and was-introduced equal-to 2020-03-18.',
 'Australia introduced Policy-4650800.',
 'Policy-4650800 is a restriction and was-introduced equal-to 2020-03-19.',
 'Australia introduced Policy-5780481.',
 'Policy-5780481 is a restriction and was-introduced equal-to 2020-03-22.',
 'Policy-5780481 was-withdrawn  equal-to 2020-05-30.',
 'Australia introduced Policy-7299351.',
 'Policy-7299351 is a restriction and was-introduced equal-to 2020-01-28.',
 'Australia introduced Policy-8441068.',
 'Policy-8441068 is a restriction and was-introduced equal-to 2020-01-28.',
 'Australia introduced Policy-8416733.',
 'Policy-8416733 is a restriction and was-introduced equal-to 2020-02-01.',
 'Policy-8416733 was-withdrawn  equal-to 2020-02-29.',
 'Australia introduced Policy-2201464.',
 'Policy-2201464 is a restriction and was-introduced equal-to 2020-03-01.',
 'Australia introduced Policy-2338386.',
 'Policy-2338386 is a restriction and was-introduced equal-to 2020-03-05.',
 'Australia introduced Policy-2568387.',
 'Policy-2568387 is a restriction and was-introduced equal-to 2020-03-10.',
 'Australia introduced Policy-9700836.',
 'Policy-9700836 is a restriction and was-introduced equal-to 2020-03-15.',
 'Australia introduced Policy-536454.',
 'Policy-536454 is a restriction and was-introduced equal-to 2020-03-16.',
 'Policy-536454 was-withdrawn  equal-to 2020-04-16.',
 'Australia introduced Policy-536454.',
 'Policy-536454 is a restriction and was-introduced equal-to 2020-03-16.',
 'Policy-536454 was-withdrawn  equal-to 2020-04-16.',
 'Australia introduced Policy-9588194.',
 'Policy-9588194 is a restriction and was-introduced equal-to 2020-03-18.',
 'Policy-9588194 was-withdrawn  equal-to 2020-04-15.',
 'Australia introduced Policy-5781245.',
 'Policy-5781245 is a restriction and was-introduced equal-to 2020-03-20.',
 'Australia introduced Policy-6056211.',
 'Policy-6056211 is a restriction and was-introduced equal-to 2020-03-20.',
 'Australia introduced Policy-257258.',
 'Policy-257258 is a restriction and was-introduced equal-to 2020-03-25.',
 'Policy-257258 was-withdrawn  equal-to 2020-04-25.',
 'Australia introduced Policy-3019341.',
 'Policy-3019341 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-266435.',
 'Policy-266435 is a restriction and was-introduced equal-to 2020-04-03.',
 'Australia introduced Policy-5323094.',
 'Policy-5323094 is a restriction and was-introduced equal-to 2020-04-03.',
 'Australia introduced Policy-7700961.',
 'Policy-7700961 is a restriction and was-introduced equal-to 2020-04-04.',
 'Australia introduced Policy-8019733.',
 'Policy-8019733 is a restriction and was-introduced equal-to 2020-04-04.',
 'Australia introduced Policy-3192495.',
 'Policy-3192495 is a restriction and was-introduced equal-to 2020-05-20.',
 'Australia introduced Policy-214945.',
 'Policy-214945 is a restriction and was-introduced equal-to 2020-07-06.',
 'Australia introduced Policy-214945.',
 'Policy-214945 is a restriction and was-introduced equal-to 2020-07-07.',
 'Australia introduced Policy-3766159.',
 'Policy-3766159 is a restriction and was-introduced equal-to 2020-07-08.',
 'Australia introduced Policy-9564981.',
 'Policy-9564981 is a restriction and was-introduced equal-to 2020-07-08.',
 'Policy-9564981 was-withdrawn  equal-to 2021-01-02.',
 'Australia introduced Policy-9564981.',
 'Policy-9564981 is a restriction and was-introduced equal-to 2020-07-08.',
 'Policy-9564981 was-withdrawn  equal-to 2021-01-02.',
 'Australia introduced Policy-7091430.',
 'Policy-7091430 is a restriction and was-introduced equal-to 2020-07-09.',
 'Australia introduced Policy-7091430.',
 'Policy-7091430 is a restriction and was-introduced equal-to 2020-07-09.',
 'Australia introduced Policy-4727735.',
 'Policy-4727735 is a restriction and was-introduced equal-to 2020-07-13.',
 'Policy-4727735 was-withdrawn  equal-to 2020-08-07.',
 'Australia introduced Policy-9994627.',
 'Policy-9994627 is a restriction and was-introduced equal-to 2020-07-15.',
 'Australia introduced Policy-6532586.',
 'Policy-6532586 is a restriction and was-introduced equal-to 2020-07-17.',
 'Australia introduced Policy-357126.',
 'Policy-357126 is a restriction and was-introduced equal-to 2020-08-07.',
 'Policy-357126 was-withdrawn  equal-to 2020-10-24.',
 'Australia introduced Policy-7561488.',
 'Policy-7561488 is a restriction and was-introduced equal-to 2020-08-10.',
 'Australia introduced Policy-9681714.',
 'Policy-9681714 is a restriction and was-introduced equal-to 2020-01-21.',
 'Australia introduced Policy-1444651.',
 'Policy-1444651 is a restriction and was-introduced equal-to 2020-02-29.',
 'Australia introduced Policy-7065129.',
 'Policy-7065129 is a restriction and was-introduced equal-to 2020-03-30.',
 'Australia introduced Policy-5988809.',
 'Policy-5988809 is a restriction and was-introduced equal-to 2020-04-16.',
 'Australia introduced Policy-2599738.',
 'Policy-2599738 is a restriction and was-introduced equal-to 2020-04-26.',
 'Australia introduced Policy-6421666.',
 'Policy-6421666 is a restriction and was-introduced equal-to 2020-06-15.',
 'Australia introduced Policy-313076.',
 'Policy-313076 is a restriction and was-introduced equal-to 2020-03-02.',
 'Australia introduced Policy-313076.',
 'Policy-313076 is a restriction and was-introduced equal-to 2020-03-02.',
 'Australia introduced Policy-313076.',
 'Policy-313076 is a restriction and was-introduced equal-to 2020-03-02.',
 'Australia introduced Policy-3225476.',
 'Policy-3225476 is a restriction and was-introduced equal-to 2020-03-02.',
 'Australia introduced Policy-3763354.',
 'Policy-3763354 is a restriction and was-introduced equal-to 2020-03-02.',
 'Australia introduced Policy-3763354.',
 'Policy-3763354 is a restriction and was-introduced equal-to 2020-03-02.',
 'Australia introduced Policy-6604917.',
 'Policy-6604917 is a restriction and was-introduced equal-to 2020-03-02.',
 'Australia introduced Policy-2006341.',
 'Policy-2006341 is a restriction and was-introduced equal-to 2020-03-10.',
 'Australia introduced Policy-3952335.',
 'Policy-3952335 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-3952335.',
 'Policy-3952335 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6083702.',
 'Policy-6083702 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6083702.',
 'Policy-6083702 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6083702.',
 'Policy-6083702 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6083702.',
 'Policy-6083702 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6083702.',
 'Policy-6083702 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6083702.',
 'Policy-6083702 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6417745.',
 'Policy-6417745 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6417745.',
 'Policy-6417745 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6417745.',
 'Policy-6417745 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6417745.',
 'Policy-6417745 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-6457532.',
 'Policy-6457532 is a restriction and was-introduced equal-to 2020-03-13.',
 'Policy-6457532 was-withdrawn  equal-to 2020-09-30.',
 'Australia introduced Policy-6457532.',
 'Policy-6457532 is a restriction and was-introduced equal-to 2020-03-13.',
 'Policy-6457532 was-withdrawn  equal-to 2020-09-30.',
 'Australia introduced Policy-6457532.',
 'Policy-6457532 is a restriction and was-introduced equal-to 2020-03-13.',
 'Policy-6457532 was-withdrawn  equal-to 2020-09-30.',
 'Australia introduced Policy-6457532.',
 'Policy-6457532 is a restriction and was-introduced equal-to 2020-03-13.',
 'Policy-6457532 was-withdrawn  equal-to 2020-09-30.',
 'Australia introduced Policy-6457532.',
 'Policy-6457532 is a restriction and was-introduced equal-to 2020-03-13.',
 'Policy-6457532 was-withdrawn  equal-to 2020-09-30.',
 'Australia introduced Policy-6457532.',
 'Policy-6457532 is a restriction and was-introduced equal-to 2020-03-13.',
 'Policy-6457532 was-withdrawn  equal-to 2020-09-30.',
 'Australia introduced Policy-9421025.',
 'Policy-9421025 is a restriction and was-introduced equal-to 2020-03-18.',
 'Australia introduced Policy-7493721.',
 'Policy-7493721 is a restriction and was-introduced equal-to 2020-03-20.',
 'Australia introduced Policy-7855101.',
 'Policy-7855101 is a restriction and was-introduced equal-to 2020-03-22.',
 'Australia introduced Policy-5015413.',
 'Policy-5015413 is a restriction and was-introduced equal-to 2020-03-23.',
 'Australia introduced Policy-9916108.',
 'Policy-9916108 is a restriction and was-introduced equal-to 2020-03-23.',
 'Australia introduced Policy-5592385.',
 'Policy-5592385 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-6728273.',
 'Policy-6728273 is a restriction and was-introduced equal-to 2020-03-25.',
 'Policy-6728273 was-withdrawn  equal-to 2020-05-29.',
 'Australia introduced Policy-7661796.',
 'Policy-7661796 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-7661796.',
 'Policy-7661796 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-7661796.',
 'Policy-7661796 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-7661796.',
 'Policy-7661796 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-7661796.',
 'Policy-7661796 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-7661796.',
 'Policy-7661796 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-1163020.',
 'Policy-1163020 is a restriction and was-introduced equal-to 2020-03-26.',
 'Australia introduced Policy-2813266.',
 'Policy-2813266 is a restriction and was-introduced equal-to 2020-03-26.',
 'Australia introduced Policy-9219740.',
 'Policy-9219740 is a restriction and was-introduced equal-to 2020-03-29.',
 'Australia introduced Policy-9219740.',
 'Policy-9219740 is a restriction and was-introduced equal-to 2020-03-29.',
 'Australia introduced Policy-6405214.',
 'Policy-6405214 is a restriction and was-introduced equal-to 2020-03-31.',
 'Australia introduced Policy-1506621.',
 'Policy-1506621 is a restriction and was-introduced equal-to 2020-04-01.',
 'Policy-1506621 was-withdrawn  equal-to 2020-12-31.',
 'Australia introduced Policy-1506621.',
 'Policy-1506621 is a restriction and was-introduced equal-to 2020-04-01.',
 'Policy-1506621 was-withdrawn  equal-to 2020-12-31.',
 'Australia introduced Policy-1506621.',
 'Policy-1506621 is a restriction and was-introduced equal-to 2020-04-01.',
 'Policy-1506621 was-withdrawn  equal-to 2020-12-31.',
 'Australia introduced Policy-1506621.',
 'Policy-1506621 is a restriction and was-introduced equal-to 2020-04-01.',
 'Policy-1506621 was-withdrawn  equal-to 2020-12-31.',
 'Australia introduced Policy-7743475.',
 'Policy-7743475 is a restriction and was-introduced equal-to 2020-04-01.',
 'Australia introduced Policy-1714095.',
 'Policy-1714095 is a restriction and was-introduced equal-to 2020-04-03.',
 'Australia introduced Policy-6602530.',
 'Policy-6602530 is a restriction and was-introduced equal-to 2020-04-03.',
 'Australia introduced Policy-4435519.',
 'Policy-4435519 is a restriction and was-introduced equal-to 2020-04-04.',
 'Australia introduced Policy-447804.',
 'Policy-447804 is a restriction and was-introduced equal-to 2020-04-07.',
 'Australia introduced Policy-447804.',
 'Policy-447804 is a restriction and was-introduced equal-to 2020-04-07.',
 'Australia introduced Policy-447804.',
 'Policy-447804 is a restriction and was-introduced equal-to 2020-04-07.',
 'Australia introduced Policy-447804.',
 'Policy-447804 is a restriction and was-introduced equal-to 2020-04-07.',
 'Australia introduced Policy-5266354.',
 'Policy-5266354 is a restriction and was-introduced equal-to 2020-04-08.',
 'Australia introduced Policy-1059484.',
 'Policy-1059484 is a restriction and was-introduced equal-to 2020-04-10.',
 'Australia introduced Policy-9719145.',
 'Policy-9719145 is a restriction and was-introduced equal-to 2020-04-11.',
 'Australia introduced Policy-4676054.',
 'Policy-4676054 is a restriction and was-introduced equal-to 2020-04-18.',
 'Australia introduced Policy-6348033.',
 'Policy-6348033 is a restriction and was-introduced equal-to 2020-04-21.',
 'Australia introduced Policy-7032136.',
 'Policy-7032136 is a restriction and was-introduced equal-to 2020-04-23.',
 'Australia introduced Policy-3596868.',
 'Policy-3596868 is a restriction and was-introduced equal-to 2020-04-24.',
 'Australia introduced Policy-3596868.',
 'Policy-3596868 is a restriction and was-introduced equal-to 2020-04-24.',
 'Australia introduced Policy-3596868.',
 'Policy-3596868 is a restriction and was-introduced equal-to 2020-04-24.',
 'Australia introduced Policy-1653230.',
 'Policy-1653230 is a restriction and was-introduced equal-to 2020-04-28.',
 'Policy-1653230 was-withdrawn  equal-to 2020-03-31.',
 'Australia introduced Policy-9215410.',
 'Policy-9215410 is a restriction and was-introduced equal-to 2020-04-28.',
 'Australia introduced Policy-578959.',
 'Policy-578959 is a restriction and was-introduced equal-to 2020-05-02.',
 'Australia introduced Policy-578959.',
 'Policy-578959 is a restriction and was-introduced equal-to 2020-05-02.',
 'Australia introduced Policy-872420.',
 'Policy-872420 is a restriction and was-introduced equal-to 2020-05-03.',
 'Australia introduced Policy-3356576.',
 'Policy-3356576 is a restriction and was-introduced equal-to 2020-05-04.',
 'Australia introduced Policy-3356576.',
 'Policy-3356576 is a restriction and was-introduced equal-to 2020-05-04.',
 'Australia introduced Policy-4737919.',
 'Policy-4737919 is a restriction and was-introduced equal-to 2020-05-05.',
 'Australia introduced Policy-5227756.',
 'Policy-5227756 is a restriction and was-introduced equal-to 2020-05-05.',
 'Policy-5227756 was-withdrawn  equal-to 2020-05-05.',
 'Australia introduced Policy-2577721.',
 'Policy-2577721 is a restriction and was-introduced equal-to 2020-05-13.',
 'Policy-2577721 was-withdrawn  equal-to 2020-05-13.',
 'Australia introduced Policy-2577721.',
 'Policy-2577721 is a restriction and was-introduced equal-to 2020-05-13.',
 'Policy-2577721 was-withdrawn  equal-to 2020-05-13.',
 'Australia introduced Policy-2577721.',
 'Policy-2577721 is a restriction and was-introduced equal-to 2020-05-13.',
 'Policy-2577721 was-withdrawn  equal-to 2020-05-13.',
 'Australia introduced Policy-2577721.',
 'Policy-2577721 is a restriction and was-introduced equal-to 2020-05-13.',
 'Policy-2577721 was-withdrawn  equal-to 2020-05-13.',
 'Australia introduced Policy-2577721.',
 'Policy-2577721 is a restriction and was-introduced equal-to 2020-05-13.',
 'Policy-2577721 was-withdrawn  equal-to 2020-05-13.',
 'Australia introduced Policy-3157527.',
 'Policy-3157527 is a restriction and was-introduced equal-to 2020-05-21.',
 'Australia introduced Policy-3157527.',
 'Policy-3157527 is a restriction and was-introduced equal-to 2020-05-21.',
 'Australia introduced Policy-6064709.',
 'Policy-6064709 is a restriction and was-introduced equal-to 2020-05-25.',
 'Australia introduced Policy-6064709.',
 'Policy-6064709 is a restriction and was-introduced equal-to 2020-05-25.',
 'Australia introduced Policy-4247357.',
 'Policy-4247357 is a restriction and was-introduced equal-to 2020-06-02.',
 'Australia introduced Policy-4639193.',
 'Policy-4639193 is a restriction and was-introduced equal-to 2020-06-05.',
 'Australia introduced Policy-212658.',
 'Policy-212658 is a restriction and was-introduced equal-to 2020-06-10.',
 'Australia introduced Policy-8827124.',
 'Policy-8827124 is a restriction and was-introduced equal-to 2020-06-24.',
 'Australia introduced Policy-156708.',
 'Policy-156708 is a restriction and was-introduced equal-to 2020-06-30.',
 'Australia introduced Policy-156708.',
 'Policy-156708 is a restriction and was-introduced equal-to 2020-06-30.',
 'Australia introduced Policy-156708.',
 'Policy-156708 is a restriction and was-introduced equal-to 2020-06-30.',
 'Australia introduced Policy-156708.',
 'Policy-156708 is a restriction and was-introduced equal-to 2020-06-30.',
 'Australia introduced Policy-1724992.',
 'Policy-1724992 is a restriction and was-introduced equal-to 2020-07-01.',
 'Australia introduced Policy-7396432.',
 'Policy-7396432 is a restriction and was-introduced equal-to 2020-07-23.',
 'Australia introduced Policy-7396432.',
 'Policy-7396432 is a restriction and was-introduced equal-to 2020-07-23.',
 'Australia introduced Policy-8341933.',
 'Policy-8341933 is a restriction and was-introduced equal-to 2020-07-27.',
 'Australia introduced Policy-6537372.',
 'Policy-6537372 is a restriction and was-introduced equal-to 2020-07-31.',
 'Australia introduced Policy-8827124.',
 'Policy-8827124 is a restriction and was-introduced equal-to 2020-08-13.',
 'Australia introduced Policy-4262917.',
 'Policy-4262917 is a restriction and was-introduced equal-to 2020-08-14.',
 'Australia introduced Policy-4262917.',
 'Policy-4262917 is a restriction and was-introduced equal-to 2020-08-14.',
 'Australia introduced Policy-2128580.',
 'Policy-2128580 is a restriction and was-introduced equal-to 2020-08-16.',
 'Policy-2128580 was-withdrawn  equal-to 2020-10-12.',
 'Australia introduced Policy-2128580.',
 'Policy-2128580 is a restriction and was-introduced equal-to 2020-08-16.',
 'Policy-2128580 was-withdrawn  equal-to 2020-10-12.',
 'Australia introduced Policy-2128580.',
 'Policy-2128580 is a restriction and was-introduced equal-to 2020-08-16.',
 'Policy-2128580 was-withdrawn  equal-to 2020-10-12.',
 'Australia introduced Policy-9458966.',
 'Policy-9458966 is a restriction and was-introduced equal-to 2020-08-17.',
 'Australia introduced Policy-2687817.',
 'Policy-2687817 is a restriction and was-introduced equal-to 2020-08-18.',
 'Australia introduced Policy-6722516.',
 'Policy-6722516 is a restriction and was-introduced equal-to 2020-08-19.',
 'Australia introduced Policy-5763252.',
 'Policy-5763252 is a restriction and was-introduced equal-to 2020-08-21.',
 'Australia introduced Policy-5763252.',
 'Policy-5763252 is a restriction and was-introduced equal-to 2020-08-21.',
 'Australia introduced Policy-110101.',
 'Policy-110101 is a restriction and was-introduced equal-to 2020-09-02.',
 'Policy-110101 was-withdrawn  equal-to 2020-09-02.',
 'Australia introduced Policy-110101.',
 'Policy-110101 is a restriction and was-introduced equal-to 2020-09-02.',
 'Policy-110101 was-withdrawn  equal-to 2020-09-02.',
 'Australia introduced Policy-7451990.',
 'Policy-7451990 is a restriction and was-introduced equal-to 2020-09-07.',
 'Policy-7451990 was-withdrawn  equal-to 2020-09-07.',
 'Australia introduced Policy-899424.',
 'Policy-899424 is a restriction and was-introduced equal-to 2020-01-28.',
 'Australia introduced Policy-899424.',
 'Policy-899424 is a restriction and was-introduced equal-to 2020-02-06.',
 'Australia introduced Policy-2399366.',
 'Policy-2399366 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-2399366.',
 'Policy-2399366 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-3596160.',
 'Policy-3596160 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-3596160.',
 'Policy-3596160 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-9570329.',
 'Policy-9570329 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-7493721.',
 'Policy-7493721 is a restriction and was-introduced equal-to 2020-03-20.',
 'Australia introduced Policy-4657525.',
 'Policy-4657525 is a restriction and was-introduced equal-to 2020-03-22.',
 'Policy-4657525 was-withdrawn  equal-to 2020-05-08.',
 'Australia introduced Policy-836238.',
 'Policy-836238 is a restriction and was-introduced equal-to 2020-03-24.',
 'Australia introduced Policy-836238.',
 'Policy-836238 is a restriction and was-introduced equal-to 2020-03-24.',
 'Australia introduced Policy-9123887.',
 'Policy-9123887 is a restriction and was-introduced equal-to 2020-03-26.',
 'Australia introduced Policy-277619.',
 'Policy-277619 is a restriction and was-introduced equal-to 2020-04-02.',
 'Australia introduced Policy-7838742.',
 'Policy-7838742 is a restriction and was-introduced equal-to 2020-04-02.',
 'Australia introduced Policy-4205342.',
 'Policy-4205342 is a restriction and was-introduced equal-to 2020-05-01.',
 'Australia introduced Policy-4205342.',
 'Policy-4205342 is a restriction and was-introduced equal-to 2020-05-01.',
 'Australia introduced Policy-9527194.',
 'Policy-9527194 is a restriction and was-introduced equal-to 2020-05-06.',
 'Australia introduced Policy-9527194.',
 'Policy-9527194 is a restriction and was-introduced equal-to 2020-05-06.',
 'Australia introduced Policy-3886046.',
 'Policy-3886046 is a restriction and was-introduced equal-to 2020-05-28.',
 'Policy-3886046 was-withdrawn  equal-to 2020-06-10.',
 'Australia introduced Policy-3886046.',
 'Policy-3886046 is a restriction and was-introduced equal-to 2020-05-28.',
 'Policy-3886046 was-withdrawn  equal-to 2020-06-10.',
 'Australia introduced Policy-8463002.',
 'Policy-8463002 is a restriction and was-introduced equal-to 2020-06-03.',
 'Policy-8463002 was-withdrawn  equal-to 2020-06-10.',
 'Australia introduced Policy-5709114.',
 'Policy-5709114 is a restriction and was-introduced equal-to 2020-07-11.',
 'Australia introduced Policy-3949994.',
 'Policy-3949994 is a restriction and was-introduced equal-to 2020-09-11.',
 'Policy-3949994 was-withdrawn  equal-to 2020-11-30.',
 'Australia introduced Policy-1540207.',
 'Policy-1540207 is a restriction and was-introduced equal-to 2020-03-22.',
 'Australia introduced Policy-7644697.',
 'Policy-7644697 is a restriction and was-introduced equal-to 2020-04-29.',
 'Australia introduced Policy-30924.',
 'Policy-30924 is a restriction and was-introduced equal-to 2020-05-02.',
 'Australia introduced Policy-30924.',
 'Policy-30924 is a restriction and was-introduced equal-to 2020-05-02.',
 'Australia introduced Policy-4062424.',
 'Policy-4062424 is a restriction and was-introduced equal-to 2020-05-18.',
 'Australia introduced Policy-5268047.',
 'Policy-5268047 is a restriction and was-introduced equal-to 2020-05-29.',
 'Australia introduced Policy-3897513.',
 'Policy-3897513 is a restriction and was-introduced equal-to 2020-07-09.',
 'Australia introduced Policy-569996.',
 'Policy-569996 is a restriction and was-introduced equal-to 2020-07-09.',
 'Australia introduced Policy-1383283.',
 'Policy-1383283 is a restriction and was-introduced equal-to 2020-09-21.',
 'Australia introduced Policy-1383283.',
 'Policy-1383283 is a restriction and was-introduced equal-to 2020-09-21.',
 'Australia introduced Policy-1218642.',
 'Policy-1218642 is a restriction and was-introduced equal-to 2020-03-18.',
 'Australia introduced Policy-130356.',
 'Policy-130356 is a restriction and was-introduced equal-to 2020-03-22.',
 'Policy-130356 was-withdrawn  equal-to 2020-11-28.',
 'Australia introduced Policy-130356.',
 'Policy-130356 is a restriction and was-introduced equal-to 2020-03-22.',
 'Policy-130356 was-withdrawn  equal-to 2020-11-28.',
 'Australia introduced Policy-2998411.',
 'Policy-2998411 is a restriction and was-introduced equal-to 2020-03-24.',
 'Australia introduced Policy-1338851.',
 'Policy-1338851 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-4577640.',
 'Policy-4577640 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-6105720.',
 'Policy-6105720 is a restriction and was-introduced equal-to 2020-03-31.',
 'Policy-6105720 was-withdrawn  equal-to 2020-06-29.',
 'Australia introduced Policy-6761627.',
 'Policy-6761627 is a restriction and was-introduced equal-to 2020-05-27.',
 'Policy-6761627 was-withdrawn  equal-to 2020-07-09.',
 'Australia introduced Policy-6105720.',
 'Policy-6105720 is a restriction and was-introduced equal-to 2020-06-01.',
 'Policy-6105720 was-withdrawn  equal-to 2020-06-29.',
 'Australia introduced Policy-7091430.',
 'Policy-7091430 is a restriction and was-introduced equal-to 2020-07-09.',
 'Australia introduced Policy-7091430.',
 'Policy-7091430 is a restriction and was-introduced equal-to 2020-07-09.',
 'Australia introduced Policy-6228258.',
 'Policy-6228258 is a restriction and was-introduced equal-to 2020-07-20.',
 'Australia introduced Policy-5814484.',
 'Policy-5814484 is a restriction and was-introduced equal-to 2020-02-01.',
 'Policy-5814484 was-withdrawn  equal-to 2020-02-15.',
 'Australia introduced Policy-7079987.',
 'Policy-7079987 is a restriction and was-introduced equal-to 2020-03-23.',
 'Australia introduced Policy-7248141.',
 'Policy-7248141 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-7248141 was-withdrawn  equal-to 2020-06-01.',
 'Australia introduced Policy-383336.',
 'Policy-383336 is a restriction and was-introduced equal-to 2020-03-24.',
 'Policy-383336 was-withdrawn  equal-to 2020-09-21.',
 'Australia introduced Policy-1222789.',
 'Policy-1222789 is a restriction and was-introduced equal-to 2020-03-25.',
 'Policy-1222789 was-withdrawn  equal-to 2020-06-05.',
 'Australia introduced Policy-1185171.',
 'Policy-1185171 is a restriction and was-introduced equal-to 2020-03-26.',
 'Australia introduced Policy-4168297.',
 'Policy-4168297 is a restriction and was-introduced equal-to 2020-03-29.',
 'Australia introduced Policy-4232794.',
 'Policy-4232794 is a restriction and was-introduced equal-to 2020-03-31.',
 'Policy-4232794 was-withdrawn  equal-to 2020-06-29.',
 'Australia introduced Policy-2127791.',
 'Policy-2127791 is a restriction and was-introduced equal-to 2020-04-09.',
 'Policy-2127791 was-withdrawn  equal-to 2020-04-09.',
 'Australia introduced Policy-2586418.',
 'Policy-2586418 is a restriction and was-introduced equal-to 2020-05-12.',
 'Policy-2586418 was-withdrawn  equal-to 2020-07-31.',
 'Australia introduced Policy-1510199.',
 'Policy-1510199 is a restriction and was-introduced equal-to 2020-06-23.',
 'Policy-1510199 was-withdrawn  equal-to 2020-12-17.',
 'Australia introduced Policy-2751659.',
 'Policy-2751659 is a restriction and was-introduced equal-to 2020-07-13.',
 'Australia introduced Policy-5580303.',
 'Policy-5580303 is a restriction and was-introduced equal-to 2020-07-13.',
 'Australia introduced Policy-8847595.',
 'Policy-8847595 is a restriction and was-introduced equal-to 2020-03-13.',
 'Australia introduced Policy-1211926.',
 'Policy-1211926 is a restriction and was-introduced equal-to 2020-03-18.',
 'Australia introduced Policy-734010.',
 'Policy-734010 is a restriction and was-introduced equal-to 2020-03-19.',
 'Australia introduced Policy-7549220.',
 'Policy-7549220 is a restriction and was-introduced equal-to 2020-03-19.',
 'Australia introduced Policy-1650025.',
 'Policy-1650025 is a restriction and was-introduced equal-to 2020-03-20.',
 'Australia introduced Policy-3126988.',
 'Policy-3126988 is a restriction and was-introduced equal-to 2020-03-21.',
 'Australia introduced Policy-7609003.',
 'Policy-7609003 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-4445933.',
 'Policy-4445933 is a restriction and was-introduced equal-to 2020-03-27.',
 'Australia introduced Policy-4192744.',
 'Policy-4192744 is a restriction and was-introduced equal-to 2020-03-31.',
 'Australia introduced Policy-1257816.',
 'Policy-1257816 is a restriction and was-introduced equal-to 2020-04-02.',
 'Australia introduced Policy-8273738.',
 'Policy-8273738 is a restriction and was-introduced equal-to 2020-04-03.',
 'Australia introduced Policy-8097258.',
 'Policy-8097258 is a restriction and was-introduced equal-to 2020-04-06.',
 'Australia introduced Policy-2057199.',
 'Policy-2057199 is a restriction and was-introduced equal-to 2020-04-08.',
 'Australia introduced Policy-1218417.',
 'Policy-1218417 is a restriction and was-introduced equal-to 2020-04-30.',
 'Australia introduced Policy-4853241.',
 'Policy-4853241 is a restriction and was-introduced equal-to 2020-05-08.',
 'Policy-4853241 was-withdrawn  equal-to 2020-06-12.',
 'Australia introduced Policy-610100.',
 'Policy-610100 is a restriction and was-introduced equal-to 2020-06-12.',
 'Australia introduced Policy-4542908.',
 'Policy-4542908 is a restriction and was-introduced equal-to 2020-07-13.',
 'Australia introduced Policy-8589102.',
 'Policy-8589102 is a restriction and was-introduced equal-to 2020-07-27.',
 'Australia introduced Policy-6463356.',
 'Policy-6463356 is a restriction and was-introduced equal-to 2020-07-29.',
 'Australia introduced Policy-7300492.',
 'Policy-7300492 is a restriction and was-introduced equal-to 2020-08-20.',
 'Australia introduced Policy-8874992.',
 'Policy-8874992 is a restriction and was-introduced equal-to 2020-08-24.',
 'Australia introduced Policy-8536437.',
 'Policy-8536437 is a restriction and was-introduced equal-to 2020-01-23.',
 'Policy-8536437 was-withdrawn  equal-to 2020-01-28.',
 'Australia introduced Policy-8441068.',
 'Policy-8441068 is a restriction and was-introduced equal-to 2020-01-28.',
 'Australia introduced Policy-3028558.',
 'Policy-3028558 is a restriction and was-introduced equal-to 2020-01-29.',
 'Australia introduced Policy-3028558.',
 'Policy-3028558 is a restriction and was-introduced equal-to 2020-01-29.',
 'Australia introduced Policy-8534580.',
 'Policy-8534580 is a restriction and was-introduced equal-to 2020-02-18.',
 'Australia introduced Policy-5834093.',
 'Policy-5834093 is a restriction and was-introduced equal-to 2020-03-05.',
 'Australia introduced Policy-9454185.',
 'Policy-9454185 is a restriction and was-introduced equal-to 2020-03-13.',
 'Australia introduced Policy-357683.',
 'Policy-357683 is a restriction and was-introduced equal-to 2020-03-28.',
 'Australia introduced Policy-8607667.',
 'Policy-8607667 is a restriction and was-introduced equal-to 2020-04-09.',
 'Australia introduced Policy-4519329.',
 'Policy-4519329 is a restriction and was-introduced equal-to 2020-04-16.',
 'Policy-4519329 was-withdrawn  equal-to 2020-04-16.',
 'Australia introduced Policy-2048977.',
 'Policy-2048977 is a restriction and was-introduced equal-to 2020-04-20.',
 'Policy-2048977 was-withdrawn  equal-to 2020-07-03.',
 'Australia introduced Policy-5866571.',
 'Policy-5866571 is a restriction and was-introduced equal-to 2020-04-23.',
 'Australia introduced Policy-4998015.',
 'Policy-4998015 is a restriction and was-introduced equal-to 2020-05-01.',
 'Australia introduced Policy-6666171.',
 'Policy-6666171 is a restriction and was-introduced equal-to 2020-05-16.',
 'Australia introduced Policy-983443.',
 'Policy-983443 is a restriction and was-introduced equal-to 2020-05-29.',
 'Australia introduced Policy-2703044.',
 'Policy-2703044 is a restriction and was-introduced equal-to 2020-07-07.',
 'Policy-2703044 was-withdrawn  equal-to 2020-12-18.',
 'Australia introduced Policy-9372846.',
 'Policy-9372846 is a restriction and was-introduced equal-to 2020-08-12.',
 'Australia introduced Policy-5595976.',
 'Policy-5595976 is a restriction and was-introduced equal-to 2020-08-21.',
 'Australia introduced Policy-3514054.',
 'Policy-3514054 is a restriction and was-introduced equal-to 2020-01-21.',
 'Australia introduced Policy-6046630.',
 'Policy-6046630 is a restriction and was-introduced equal-to 2020-01-25.',
 'Australia introduced Policy-9013235.',
 'Policy-9013235 is a restriction and was-introduced equal-to 2020-02-04.',
 'Australia introduced Policy-5695934.',
 'Policy-5695934 is a restriction and was-introduced equal-to 2020-03-02.',
 'Australia introduced Policy-1610829.',
 'Policy-1610829 is a restriction and was-introduced equal-to 2020-03-08.',
 'Australia introduced Policy-2996422.',
 'Policy-2996422 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-2996422.',
 'Policy-2996422 is a restriction and was-introduced equal-to 2020-03-11.',
 'Australia introduced Policy-3411907.',
 'Policy-3411907 is a restriction and was-introduced equal-to 2020-03-14.',
 'Australia introduced Policy-5212791.',
 'Policy-5212791 is a restriction and was-introduced equal-to 2020-03-14.',
 'Australia introduced Policy-9470914.',
 'Policy-9470914 is a restriction and was-introduced equal-to 2020-03-14.',
 'Australia introduced Policy-7379460.',
 'Policy-7379460 is a restriction and was-introduced equal-to 2020-03-21.',
 'Australia introduced Policy-8511730.',
 'Policy-8511730 is a restriction and was-introduced equal-to 2020-03-21.',
 'Australia introduced Policy-6962631.',
 'Policy-6962631 is a restriction and was-introduced equal-to 2020-03-26.',
 'Australia introduced Policy-8421238.',
 'Policy-8421238 is a restriction and was-introduced equal-to 2020-04-16.',
 'Australia introduced Policy-4767813.',
 'Policy-4767813 is a restriction and was-introduced equal-to 2020-04-24.',
 'Australia introduced Policy-8709330.',
 'Policy-8709330 is a restriction and was-introduced equal-to 2020-04-24.',
 'Australia introduced Policy-5356718.',
 'Policy-5356718 is a restriction and was-introduced equal-to 2020-04-26.',
 'Australia introduced Policy-847012.',
 'Policy-847012 is a restriction and was-introduced equal-to 2020-04-27.',
 'Australia introduced Policy-8938676.',
 'Policy-8938676 is a restriction and was-introduced equal-to 2020-04-27.',
 'Australia introduced Policy-2528584.',
 'Policy-2528584 is a restriction and was-introduced equal-to 2020-04-30.',
 'Australia introduced Policy-489610.',
 'Policy-489610 is a restriction and was-introduced equal-to 2020-04-30.',
 'Australia introduced Policy-2760222.',
 'Policy-2760222 is a restriction and was-introduced equal-to 2020-05-01.',
 'Australia introduced Policy-5267558.',
 'Policy-5267558 is a restriction and was-introduced equal-to 2020-05-01.',
 'Australia introduced Policy-3973774.',
 'Policy-3973774 is a restriction and was-introduced equal-to 2020-05-02.',
 'Australia introduced Policy-5218881.',
 'Policy-5218881 is a restriction and was-introduced equal-to 2020-05-02.',
 'Australia introduced Policy-7487898.',
 'Policy-7487898 is a restriction and was-introduced equal-to 2020-05-02.',
 'Australia introduced Policy-8034041.',
 'Policy-8034041 is a restriction and was-introduced equal-to 2020-05-02.',
 'Australia introduced Policy-8820806.',
 'Policy-8820806 is a restriction and was-introduced equal-to 2020-05-02.',
 'Australia introduced Policy-8528239.',
 'Policy-8528239 is a restriction and was-introduced equal-to 2020-05-03.',
 'Australia introduced Policy-2672224.',
 'Policy-2672224 is a restriction and was-introduced equal-to 2020-05-08.',
 'Australia introduced Policy-6285196.',
 'Policy-6285196 is a restriction and was-introduced equal-to 2020-05-11.',
 'Australia introduced Policy-6285196.',
 'Policy-6285196 is a restriction and was-introduced equal-to 2020-05-11.',
 'Australia introduced Policy-5483463.',
 'Policy-5483463 is a restriction and was-introduced equal-to 2020-05-13.',
 'Australia introduced Policy-2498291.',
 'Policy-2498291 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-372332.',
 'Policy-372332 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-5755613.',
 'Policy-5755613 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-9401044.',
 'Policy-9401044 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-9556066.',
 'Policy-9556066 is a restriction and was-introduced equal-to 2020-06-03.',
 'Australia introduced Policy-9621773.',
 'Policy-9621773 is a restriction and was-introduced equal-to 2020-06-16.',
 'Australia introduced Policy-1401063.',
 'Policy-1401063 is a restriction and was-introduced equal-to 2020-07-23.',
 'Australia introduced Policy-2229317.',
 'Policy-2229317 is a restriction and was-introduced equal-to 2020-08-20.',
 'Australia introduced Policy-673496.',
 'Policy-673496 is a restriction and was-introduced equal-to 2020-01-30.',
 'Policy-673496 was-withdrawn  equal-to 2020-03-15.',
 'Australia introduced Policy-8124105.',
 'Policy-8124105 is a restriction and was-introduced equal-to 2020-01-30.',
 'Australia introduced Policy-7218488.',
 'Policy-7218488 is a restriction and was-introduced equal-to 2020-02-01.',
 'Australia introduced Policy-5088220.',
 'Policy-5088220 is a restriction and was-introduced equal-to 2020-02-07.',
 'Australia introduced Policy-648544.',
 'Policy-648544 is a restriction and was-introduced equal-to 2020-02-07.',
 'Australia introduced Policy-2644359.',
 'Policy-2644359 is a restriction and was-introduced equal-to 2020-03-01.',
 'Australia introduced Policy-7722975.',
 'Policy-7722975 is a restriction and was-introduced equal-to 2020-03-05.',
 'Australia introduced Policy-1534778.',
 'Policy-1534778 is a restriction and was-introduced equal-to 2020-03-16.',
 'Australia introduced Policy-4892944.',
 'Policy-4892944 is a restriction and was-introduced equal-to 2020-03-17.',
 'Australia introduced Policy-4892944.',
 'Policy-4892944 is a restriction and was-introduced equal-to 2020-03-17.',
 'Australia introduced Policy-6281315.',
 'Policy-6281315 is a restriction and was-introduced equal-to 2020-03-17.',
 'Policy-6281315 was-withdrawn  equal-to 2020-06-25.',
 'Australia introduced Policy-1026838.',
 'Policy-1026838 is a restriction and was-introduced equal-to 2020-03-21.',
 'Australia introduced Policy-628712.',
 'Policy-628712 is a restriction and was-introduced equal-to 2020-03-22.',
 'Policy-628712 was-withdrawn  equal-to 2020-08-03.',
 'Australia introduced Policy-628712.',
 'Policy-628712 is a restriction and was-introduced equal-to 2020-03-22.',
 'Policy-628712 was-withdrawn  equal-to 2020-08-03.',
 'Australia introduced Policy-6174681.',
 'Policy-6174681 is a restriction and was-introduced equal-to 2020-03-24.',
 'Policy-6174681 was-withdrawn  equal-to 2020-09-24.',
 'Australia introduced Policy-6174681.',
 'Policy-6174681 is a restriction and was-introduced equal-to 2020-03-24.',
 'Policy-6174681 was-withdrawn  equal-to 2020-09-24.',
 'Australia introduced Policy-2221008.',
 'Policy-2221008 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-852952.',
 'Policy-852952 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-3058219.',
 'Policy-3058219 is a restriction and was-introduced equal-to 2020-03-26.',
 'Policy-3058219 was-withdrawn  equal-to 2020-10-21.',
 'Australia introduced Policy-1423145.',
 'Policy-1423145 is a restriction and was-introduced equal-to 2020-03-27.',
 'Australia introduced Policy-1423145.',
 'Policy-1423145 is a restriction and was-introduced equal-to 2020-03-27.',
 'Australia introduced Policy-1423145.',
 'Policy-1423145 is a restriction and was-introduced equal-to 2020-03-27.',
 'Australia introduced Policy-757781.',
 'Policy-757781 is a restriction and was-introduced equal-to 2020-03-27.',
 'Australia introduced Policy-5246883.',
 'Policy-5246883 is a restriction and was-introduced equal-to 2020-03-28.',
 'Australia introduced Policy-6092567.',
 'Policy-6092567 is a restriction and was-introduced equal-to 2020-03-28.',
 'Policy-6092567 was-withdrawn  equal-to 2020-06-26.',
 'Australia introduced Policy-6931822.',
 'Policy-6931822 is a restriction and was-introduced equal-to 2020-03-28.',
 'Australia introduced Policy-713243.',
 'Policy-713243 is a restriction and was-introduced equal-to 2020-03-29.',
 'Policy-713243 was-withdrawn  equal-to 2020-12-19.',
 'Australia introduced Policy-7333852.',
 'Policy-7333852 is a restriction and was-introduced equal-to 2020-03-29.',
 'Policy-7333852 was-withdrawn  equal-to 2020-12-20.',
 'Australia introduced Policy-2732666.',
 'Policy-2732666 is a restriction and was-introduced equal-to 2020-04-09.',
 'Australia introduced Policy-5268655.',
 'Policy-5268655 is a restriction and was-introduced equal-to 2020-04-10.',
 'Australia introduced Policy-24714.',
 'Policy-24714 is a restriction and was-introduced equal-to 2020-06-15.',
 'Australia introduced Policy-24714.',
 'Policy-24714 is a restriction and was-introduced equal-to 2020-06-15.',
 'Australia introduced Policy-1738832.',
 'Policy-1738832 is a restriction and was-introduced equal-to 2020-06-26.',
 'Australia introduced Policy-1705305.',
 'Policy-1705305 is a restriction and was-introduced equal-to 2020-07-08.',
 'Policy-1705305 was-withdrawn  equal-to 2020-10-08.',
 'Australia introduced Policy-4161508.',
 'Policy-4161508 is a restriction and was-introduced equal-to 2020-07-09.',
 'Australia introduced Policy-4161508.',
 'Policy-4161508 is a restriction and was-introduced equal-to 2020-07-09.',
 'Australia introduced Policy-3504061.',
 'Policy-3504061 is a restriction and was-introduced equal-to 2020-07-17.',
 'Australia introduced Policy-3504061.',
 'Policy-3504061 is a restriction and was-introduced equal-to 2020-07-17.',
 'Australia introduced Policy-8433226.',
 'Policy-8433226 is a restriction and was-introduced equal-to 2020-08-07.',
 'Policy-8433226 was-withdrawn  equal-to 2020-10-09.',
 'Australia introduced Policy-3315426.',
 'Policy-3315426 is a restriction and was-introduced equal-to 2020-08-10.',
 'Australia introduced Policy-3315426.',
 'Policy-3315426 is a restriction and was-introduced equal-to 2020-08-10.',
 'Australia introduced Policy-3900358.',
 'Policy-3900358 is a restriction and was-introduced equal-to 2020-08-20.',
 'Australia introduced Policy-9516857.',
 'Policy-9516857 is a restriction and was-introduced equal-to 2020-10-02.',
 'Policy-9516857 was-withdrawn  equal-to 2021-01-02.',
 'Australia introduced Policy-912489.',
 'Policy-912489 is a restriction and was-introduced equal-to 2020-03-19.',
 'Policy-912489 was-withdrawn  equal-to 2020-05-19.',
 'Australia introduced Policy-912489.',
 'Policy-912489 is a restriction and was-introduced equal-to 2020-03-19.',
 'Policy-912489 was-withdrawn  equal-to 2020-05-19.',
 'Australia introduced Policy-4697072.',
 'Policy-4697072 is a restriction and was-introduced equal-to 2020-03-20.',
 'Australia introduced Policy-137943.',
 'Policy-137943 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-137943 was-withdrawn  equal-to 2020-09-01.',
 'Australia introduced Policy-137943.',
 'Policy-137943 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-137943 was-withdrawn  equal-to 2020-09-01.',
 'Australia introduced Policy-137943.',
 'Policy-137943 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-137943 was-withdrawn  equal-to 2020-09-01.',
 'Australia introduced Policy-405096.',
 'Policy-405096 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-405096 was-withdrawn  equal-to 2020-06-01.',
 'Australia introduced Policy-405096.',
 'Policy-405096 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-405096 was-withdrawn  equal-to 2020-06-01.',
 'Australia introduced Policy-405096.',
 'Policy-405096 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-405096 was-withdrawn  equal-to 2020-06-01.',
 'Australia introduced Policy-7369938.',
 'Policy-7369938 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-7369938 was-withdrawn  equal-to 2020-03-25.',
 'Australia introduced Policy-7369938.',
 'Policy-7369938 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-7369938 was-withdrawn  equal-to 2020-03-25.',
 'Australia introduced Policy-7369938.',
 'Policy-7369938 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-7369938 was-withdrawn  equal-to 2020-03-25.',
 'Australia introduced Policy-8504979.',
 'Policy-8504979 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-8504979 was-withdrawn  equal-to 2020-05-14.',
 'Australia introduced Policy-8504979.',
 'Policy-8504979 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-8504979 was-withdrawn  equal-to 2020-05-14.',
 'Australia introduced Policy-8504979.',
 'Policy-8504979 is a restriction and was-introduced equal-to 2020-03-23.',
 'Policy-8504979 was-withdrawn  equal-to 2020-05-14.',
 'Australia introduced Policy-3968553.',
 'Policy-3968553 is a restriction and was-introduced equal-to 2020-03-24.',
 'Policy-3968553 was-withdrawn  equal-to 2020-08-14.',
 'Australia introduced Policy-3968553.',
 'Policy-3968553 is a restriction and was-introduced equal-to 2020-03-24.',
 'Policy-3968553 was-withdrawn  equal-to 2020-08-14.',
 'Australia introduced Policy-3495330.',
 'Policy-3495330 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-3495330.',
 'Policy-3495330 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-3495330.',
 'Policy-3495330 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-3495330.',
 'Policy-3495330 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-3495330.',
 'Policy-3495330 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-3495330.',
 'Policy-3495330 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-9716056.',
 'Policy-9716056 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-9716056.',
 'Policy-9716056 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-9716056.',
 'Policy-9716056 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-9716056.',
 'Policy-9716056 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-9716056.',
 'Policy-9716056 is a restriction and was-introduced equal-to 2020-03-25.',
 'Australia introduced Policy-456137.',
 'Policy-456137 is a restriction and was-introduced equal-to 2020-03-26.',
 'Policy-456137 was-withdrawn  equal-to 2020-05-17.',
 'Australia introduced Policy-456137.',
 'Policy-456137 is a restriction and was-introduced equal-to 2020-03-26.',
 'Policy-456137 was-withdrawn  equal-to 2020-05-17.',
 'Australia introduced Policy-456137.',
 'Policy-456137 is a restriction and was-introduced equal-to 2020-03-26.',
 'Policy-456137 was-withdrawn  equal-to 2020-05-17.',
 'Australia introduced Policy-456137.',
 'Policy-456137 is a restriction and was-introduced equal-to 2020-03-26.',
 'Policy-456137 was-withdrawn  equal-to 2020-05-17.',
 'Australia introduced Policy-8221851.',
 'Policy-8221851 is a restriction and was-introduced equal-to 2020-03-26.',
 'Australia introduced Policy-9230476.',
 'Policy-9230476 is a restriction and was-introduced equal-to 2020-03-30.',
 'Australia introduced Policy-3968553.',
 'Policy-3968553 is a restriction and was-introduced equal-to 2020-05-15.',
 'Policy-3968553 was-withdrawn  equal-to 2020-08-14.',
 'Australia introduced Policy-5963324.',
 'Policy-5963324 is a restriction and was-introduced equal-to 2020-05-15.',
 'Policy-5963324 was-withdrawn  equal-to 2020-08-14.',
 'Australia introduced Policy-5963324.',
 'Policy-5963324 is a restriction and was-introduced equal-to 2020-05-15.',
 'Policy-5963324 was-withdrawn  equal-to 2020-08-14.',
 'Australia introduced Policy-5963324.',
 'Policy-5963324 is a restriction and was-introduced equal-to 2020-05-15.',
 'Policy-5963324 was-withdrawn  equal-to 2020-08-14.',
 'Australia introduced Policy-5963324.',
 'Policy-5963324 is a restriction and was-introduced equal-to 2020-05-15.',
 'Policy-5963324 was-withdrawn  equal-to 2020-08-14.',
 'Australia introduced Policy-79497.',
 'Policy-79497 is a restriction and was-introduced equal-to 2020-05-15.',
 'Australia introduced Policy-79497.',
 'Policy-79497 is a restriction and was-introduced equal-to 2020-05-15.',
 'Australia introduced Policy-79497.',
 'Policy-79497 is a restriction and was-introduced equal-to 2020-05-15.',
 'Australia introduced Policy-79497.',
 'Policy-79497 is a restriction and was-introduced equal-to 2020-05-15.',
 'Australia introduced Policy-79497.',
 'Policy-79497 is a restriction and was-introduced equal-to 2020-05-15.',
 'Australia introduced Policy-79497.',
 'Policy-79497 is a restriction and was-introduced equal-to 2020-05-15.',
 'Australia introduced Policy-79497.',
 'Policy-79497 is a restriction and was-introduced equal-to 2020-05-15.',
 'Australia introduced Policy-79497.',
 'Policy-79497 is a restriction and was-introduced equal-to 2020-05-15.',
 'Australia introduced Policy-79497.',
 'Policy-79497 is a restriction and was-introduced equal-to 2020-05-15.',
 'Australia introduced Policy-79497.',
 'Policy-79497 is a restriction and was-introduced equal-to 2020-05-15.',
 'Australia introduced Policy-5866249.',
 'Policy-5866249 is a restriction and was-introduced equal-to 2020-05-18.',
 'Policy-5866249 was-withdrawn  equal-to 2020-06-05.',
 'Australia introduced Policy-5866249.',
 'Policy-5866249 is a restriction and was-introduced equal-to 2020-05-18.',
 'Policy-5866249 was-withdrawn  equal-to 2020-06-05.',
 'Australia introduced Policy-5866249.',
 'Policy-5866249 is a restriction and was-introduced equal-to 2020-05-18.',
 'Policy-5866249 was-withdrawn  equal-to 2020-06-05.',
 'Australia introduced Policy-5866249.',
 'Policy-5866249 is a restriction and was-introduced equal-to 2020-05-18.',
 'Policy-5866249 was-withdrawn  equal-to 2020-06-05.',
 'Australia introduced Policy-4518550.',
 'Policy-4518550 is a restriction and was-introduced equal-to 2020-05-29.',
 'Australia introduced Policy-7556935.',
 'Policy-7556935 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-7556935.',
 'Policy-7556935 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-7556935.',
 'Policy-7556935 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-7556935.',
 'Policy-7556935 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-7556935.',
 'Policy-7556935 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-9776896.',
 'Policy-9776896 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-9776896.',
 'Policy-9776896 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-9776896.',
 'Policy-9776896 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-9776896.',
 'Policy-9776896 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-9776896.',
 'Policy-9776896 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-9776896.',
 'Policy-9776896 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-9776896.',
 'Policy-9776896 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-9776896.',
 'Policy-9776896 is a restriction and was-introduced equal-to 2020-06-01.',
 'Australia introduced Policy-5055528.',
 'Policy-5055528 is a restriction and was-introduced equal-to 2020-06-05.',
 'Australia introduced Policy-7857221.',
 'Policy-7857221 is a restriction and was-introduced equal-to 2020-06-06.',
 'Policy-7857221 was-withdrawn  equal-to 2020-06-27.',
 'Australia introduced Policy-7857221.',
 'Policy-7857221 is a restriction and was-introduced equal-to 2020-06-06.',
 'Policy-7857221 was-withdrawn  equal-to 2020-06-27.',
 'Australia introduced Policy-7857221.',
 'Policy-7857221 is a restriction and was-introduced equal-to 2020-06-06.',
 'Policy-7857221 was-withdrawn  equal-to 2020-06-27.',
 'Australia introduced Policy-7234085.',
 'Policy-7234085 is a restriction and was-introduced equal-to 2020-06-13.',
 'Australia introduced Policy-7234085.',
 'Policy-7234085 is a restriction and was-introduced equal-to 2020-06-13.',
 'Australia introduced Policy-7234085.',
 'Policy-7234085 is a restriction and was-introduced equal-to 2020-06-13.',
 'Australia introduced Policy-7234085.',
 'Policy-7234085 is a restriction and was-introduced equal-to 2020-06-13.',
 'Australia introduced Policy-7234085.',
 'Policy-7234085 is a restriction and was-introduced equal-to 2020-06-13.',
 'Australia introduced Policy-4428794.',
 'Policy-4428794 is a restriction and was-introduced equal-to 2020-06-27.',
 'Australia introduced Policy-4428794.',
 'Policy-4428794 is a restriction and was-introduced equal-to 2020-06-27.',
 'Australia introduced Policy-4428794.',
 'Policy-4428794 is a restriction and was-introduced equal-to 2020-06-27.',
 'Australia introduced Policy-4384818.',
 'Policy-4384818 is a restriction and was-introduced equal-to 2020-07-01.',
 'Australia introduced Policy-4384818.',
 'Policy-4384818 is a restriction and was-introduced equal-to 2020-07-01.',
 'Australia introduced Policy-4384818.',
 'Policy-4384818 is a restriction and was-introduced equal-to 2020-07-01.',
 'Australia introduced Policy-4384818.',
 'Policy-4384818 is a restriction and was-introduced equal-to 2020-07-01.',
 'Australia introduced Policy-4384818.',
 'Policy-4384818 is a restriction and was-introduced equal-to 2020-07-01.',
 'Australia introduced Policy-4384818.',
 'Policy-4384818 is a restriction and was-introduced equal-to 2020-07-01.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 'Policy-1413216 is a restriction and was-introduced equal-to 2020-07-24.',
 'Policy-1413216 was-withdrawn  equal-to 2020-10-25.',
 'Australia introduced Policy-1413216.',
 ...]
[6]:
parts_editors={}
parts_editors['01']=CnlEditBox('countries.encnl')
parts_editors['02']=CnlEditBox('border_cross_quarantine.encnl')
parts_editors['03']=CnlEditBox('face_cover.encnl')
parts_editors['04']=CnlEditBox('lockdown.encnl')
parts_editors['05']=CnlEditBox('mass_coronavirus_testing.encnl')
Welcome to CogniPy
[7]:
parts_editors['01']
[8]:
parts_editors['02']
[8]:
parts_editors['03']
[9]:
parts_editors['04']
[10]:
parts_editors['05']

Lets define the function that will build the ontology based on the dict of ontology editors and the optional additional editor for testing purposes. All it is doing it is concatenaiting the values of all the editors and puts them into the newly created ontology object.

[11]:
def buildOntology(parts_editors,test_editor=None):
    return Ontology("cnl/string",
                    "\n\n".join(k.getvalue() for k in parts_editors.values())+('' if test_editor is None else test_editor.getvalue()) + '\n'.join(policies_cnl_lines),
                    evaluator = lambda e:eval(e,globals(),locals()),
                    graph_attribute_formatter = graph_attribute_formatter)

onto=buildOntology(parts_editors)

Lets draw our ontology.

[ ]:
onto.draw_graph(layout='force directed')

You can select and print out all instaces of given concept’s name.

[12]:
regions=onto.select_instances_of("region")
regions
[12]:
Instance introduceds
0 Victoria [Mass-Coronavirus-Testing-Victoria, Lockdown-Victoria, Face-Cover-Victoria, Border-Cross-Quarantine-Victoria]
1 Berlin [Mass-Coronavirus-Testing-Berlin, Lockdown-Berlin, Face-Cover-Berlin, Border-Cross-Quarantine-Berlin]
2 United-Kingdom None
3 Australia [Policy-599939, Policy-4595838, Policy-8888423, Policy-6796297, Policy-4657525, Policy-7451990, Policy-4767813, Policy-9700836, Policy-9564981, Policy-1510199, Policy-2399366, Policy-6421666, Policy-4668893, Face-Cover-Australia, Policy-5963324, Policy-2687817, Policy-6666171, Policy-2813266, Policy-9470914, Policy-4577640, Policy-673496, Policy-5595976, Policy-1658680, Policy-1575088, Policy-357126, Policy-8034041, Policy-5592385, Policy-9527194, Policy-9516857, Policy-9123887, Policy-2528584, Policy-79497, Policy-6092567, Policy-110101, Policy-3973774, Policy-3968553, Policy-9994627, Policy-6537372, Policy-8245407, Policy-5268047, Policy-9482658, Policy-5442485, Policy-4531517, Policy-7234085, Policy-6543237, Policy-5755613, Policy-6285196, Policy-9716056, Policy-30924, Policy-5695934, Policy-4639193, Policy-5081649, Policy-5763252, Policy-4518550, Policy-1401063, Policy-8847595, Policy-2751659, Policy-536454, Policy-3157527, Policy-3411907, Policy-9631567, Policy-4262917, Policy-1026838, Policy-9458966, Policy-9372846, Policy-3356576, Policy-7032136, Policy-6602530, Policy-1724992, Policy-3225476, Policy-2568387, Policy-2577721, Policy-2586418, Policy-1413216, Policy-7396432, Policy-6174681, Policy-4542908, Policy-3058219, Policy-3126988, Policy-3028558, Policy-7609003, Policy-7549220, Policy-447804, Policy-6405214, Policy-8433226, Policy-9738776, Policy-5055528, Policy-8504979, Policy-7079987, Policy-9719145, Policy-4060611, Policy-9401044, Policy-7700961, Policy-9219740, Policy-1705305, Policy-257258, Policy-1222789, Policy-559206, Policy-7300492, Policy-6532586, ...]
4 Bavaria [Mass-Coronavirus-Testing-Bavaria, Lockdown-Bavaria, Face-Cover-Bavaria, Border-Cross-Quarantine-Bavaria]
5 New-York [Lockdown-New-York, Face-Cover-New-York, Border-Cross-Quarantine-New-York]
6 California [Lockdown-California, Face-Cover-California]
7 Sweden Border-Cross-Quarantine-Sweden
8 Poland [Lockdown-Poland, Face-Cover-Poland, Border-Cross-Quarantine-Poland]
9 Germany None
10 USA None
11 Switzerland Border-Cross-Quarantine-Switzerland

Cognipy allows you to do queries on ontology using sparql language. In example we query for every region which has indtroduced some restriction and then we save it to pandas dataframe.

[13]:
df=onto.sparql_query(CQL("""select ?region ?restriction ?date{
                            ?region rdf:type <region>.
                            ?restriction rdf:type <restriction>.
                            ?region <introduceds> ?restriction.
                            ?restriction <was-introduced> ?date.
                        }"""))
[14]:
df['date'] = pd.to_datetime(pd.to_datetime(df['date']).apply(lambda x: x.strftime('%d/%m/%Y')))
df.set_index('date',inplace=True)
[15]:
df
[15]:
region restriction
date
2020-06-08 Victoria Lockdown-Victoria
2020-02-08 Victoria Face-Cover-Victoria
2020-03-15 Victoria Border-Cross-Quarantine-Victoria
2020-03-23 Berlin Lockdown-Berlin
2020-04-21 Berlin Face-Cover-Berlin
2020-04-22 Berlin Border-Cross-Quarantine-Berlin
2020-05-06 Australia Policy-599939
2020-03-18 Australia Policy-4595838
2020-05-06 Australia Policy-8888423
2020-03-18 Australia Policy-6796297
2020-03-22 Australia Policy-4657525
2020-07-09 Australia Policy-7451990
2020-04-24 Australia Policy-4767813
2020-03-15 Australia Policy-9700836
2020-08-07 Australia Policy-9564981
2020-06-23 Australia Policy-1510199
2020-11-03 Australia Policy-2399366
2020-06-15 Australia Policy-6421666
2020-03-16 Australia Policy-4668893
2020-07-19 Australia Face-Cover-Australia
2020-05-15 Australia Policy-5963324
2020-08-18 Australia Policy-2687817
2020-05-16 Australia Policy-6666171
2020-03-26 Australia Policy-2813266
2020-03-14 Australia Policy-9470914
2020-03-25 Australia Policy-4577640
2020-01-30 Australia Policy-673496
2020-08-21 Australia Policy-5595976
2020-07-18 Australia Policy-1658680
2020-10-08 Australia Policy-1575088
2020-07-08 Australia Policy-357126
2020-02-05 Australia Policy-8034041
2020-03-25 Australia Policy-5592385
2020-06-05 Australia Policy-9527194
2020-02-10 Australia Policy-9516857
2020-03-26 Australia Policy-9123887
2020-04-30 Australia Policy-2528584
2020-05-15 Australia Policy-79497
2020-03-28 Australia Policy-6092567
2020-02-09 Australia Policy-110101
2020-02-05 Australia Policy-3973774
2020-05-15 Australia Policy-3968553
2020-03-24 Australia Policy-3968553
2020-07-15 Australia Policy-9994627
2020-07-31 Australia Policy-6537372
2020-03-18 Australia Policy-8245407
2020-05-29 Australia Policy-5268047
2020-03-18 Australia Policy-9482658
2020-03-27 Australia Policy-5442485
2020-01-29 Australia Policy-4531517
2020-06-13 Australia Policy-7234085
2020-03-17 Australia Policy-6543237
2020-01-06 Australia Policy-5755613
2020-11-05 Australia Policy-6285196
2020-03-25 Australia Policy-9716056
2020-02-05 Australia Policy-30924
2020-02-03 Australia Policy-5695934
2020-05-06 Australia Policy-4639193
2020-09-07 Australia Policy-5081649
2020-08-21 Australia Policy-5763252
2020-05-29 Australia Policy-4518550
2020-07-23 Australia Policy-1401063
2020-03-13 Australia Policy-8847595
2020-07-13 Australia Policy-2751659
2020-03-16 Australia Policy-536454
2020-05-21 Australia Policy-3157527
2020-03-14 Australia Policy-3411907
2020-03-29 Australia Policy-9631567
2020-08-14 Australia Policy-4262917
2020-03-21 Australia Policy-1026838
2020-08-17 Australia Policy-9458966
2020-12-08 Australia Policy-9372846
2020-04-05 Australia Policy-3356576
2020-04-23 Australia Policy-7032136
2020-03-04 Australia Policy-6602530
2020-01-07 Australia Policy-1724992
2020-02-03 Australia Policy-3225476
2020-10-03 Australia Policy-2568387
2020-05-13 Australia Policy-2577721
2020-12-05 Australia Policy-2586418
2020-07-24 Australia Policy-1413216
2020-07-23 Australia Policy-7396432
2020-03-24 Australia Policy-6174681
2020-07-13 Australia Policy-4542908
2020-03-26 Australia Policy-3058219
2020-03-21 Australia Policy-3126988
2020-01-29 Australia Policy-3028558
2020-03-25 Australia Policy-7609003
2020-03-19 Australia Policy-7549220
2020-07-04 Australia Policy-447804
2020-03-31 Australia Policy-6405214
2020-07-08 Australia Policy-8433226
2020-03-21 Australia Policy-9738776
2020-05-06 Australia Policy-5055528
2020-03-23 Australia Policy-8504979
2020-03-23 Australia Policy-7079987
2020-11-04 Australia Policy-9719145
2020-03-16 Australia Policy-4060611
2020-01-06 Australia Policy-9401044
2020-04-04 Australia Policy-7700961
2020-03-29 Australia Policy-9219740
2020-08-07 Australia Policy-1705305
2020-03-25 Australia Policy-257258
2020-03-25 Australia Policy-1222789
2020-03-22 Australia Policy-559206
2020-08-20 Australia Policy-7300492
2020-07-17 Australia Policy-6532586
2020-10-08 Australia Policy-1397340
2020-03-23 Australia Policy-137943
2020-03-26 Australia Policy-1532456
2020-01-04 Australia Policy-7743475
2020-03-21 Australia Policy-3577757
2020-11-03 Australia Policy-3596160
2020-03-19 Australia Policy-1562868
2020-09-07 Australia Policy-3897513
2020-04-16 Australia Policy-8421238
2020-03-22 Australia Policy-130356
2020-08-04 Australia Policy-5266354
2020-01-09 Australia Policy-9528767
2020-09-10 Australia Policy-6780559
2020-03-24 Australia Policy-383336
2020-03-23 Australia Policy-4299367
2020-09-07 Australia Policy-569996
2020-07-02 Australia Policy-5088220
2020-09-04 Australia Policy-2127791
2020-09-10 Australia Policy-6942274
2020-03-18 Australia Policy-2882756
2020-03-27 Australia Policy-1423145
2020-03-15 Australia Policy-8999379
2020-03-21 Australia Policy-6394043
2020-05-05 Australia Policy-4737919
2020-09-21 Australia Policy-1383283
2020-02-04 Australia Policy-277619
2020-05-15 Australia Policy-4641762
2020-03-19 Australia Policy-6626208
2020-03-18 Australia Policy-6626208
2020-06-26 Australia Policy-1738832
2020-01-05 Australia Policy-4205342
2020-11-09 Australia Policy-3949994
2020-04-27 Australia Policy-8938676
2020-03-19 Australia Policy-2433052
2020-03-18 Australia Policy-2433052
2020-03-29 Australia Policy-713243
2020-06-27 Australia Policy-4428794
2020-01-04 Australia Policy-1506621
2020-03-21 Australia Policy-7379460
2020-05-18 Australia Policy-5866249
2020-03-20 Australia Policy-6842911
2020-06-06 Australia Policy-2972473
2020-03-31 Australia Policy-4192744
2020-11-03 Australia Policy-6083702
2020-09-10 Australia Policy-2566638
2020-02-05 Australia Policy-8593981
2020-01-06 Australia Policy-7556935
2020-03-13 Australia Policy-6457532
2020-02-18 Australia Policy-8534580
2020-02-06 Australia Policy-4247357
2020-03-31 Australia Policy-4232794
2020-01-30 Australia Policy-8124105
2020-05-03 Australia Policy-5834093
2020-11-03 Australia Policy-2996422
2020-03-26 Australia Policy-1163020
2020-03-21 Australia Policy-8511730
2020-03-18 Australia Policy-1211926
2020-03-24 Australia Policy-836238
2020-06-16 Australia Policy-9621773
2020-03-25 Australia Policy-7854207
2020-09-04 Australia Policy-2732666
2020-03-31 Australia Policy-2980103
2020-06-15 Australia Policy-24714
2020-02-29 Australia Policy-1444651
2020-03-25 Australia Policy-7661796
2020-03-06 Australia Policy-8463002
2020-03-26 Australia Policy-456137
2020-03-22 Australia Policy-1540207
2020-04-16 Australia Policy-5988809
2020-03-17 Australia Policy-8990133
2020-12-06 Australia Policy-610100
2020-02-03 Australia Policy-6604917
2020-06-27 Australia Policy-8040575
2020-11-03 Australia Policy-9570329
2020-07-27 Australia Policy-8589102
2020-04-21 Australia Policy-6348033
2020-07-29 Australia Policy-6463356
2020-05-25 Australia Policy-6064709
2020-03-16 Australia Policy-1534778
2020-03-25 Australia Policy-1338851
2020-01-03 Australia Policy-2201464
2020-09-07 Australia Policy-7091430
2020-01-23 Australia Policy-8536437
2020-03-23 Australia Lockdown-Australia
2020-08-16 Australia Policy-2128580
2020-08-05 Australia Policy-4853241
2020-10-08 Australia Policy-7561488
2020-07-13 Australia Policy-4727735
2020-03-27 Australia Policy-4445933
2020-03-30 Australia Policy-7065129
2020-04-18 Australia Policy-4676054
2020-01-05 Australia Policy-5267558
2020-01-05 Australia Policy-2760222
2020-08-06 Australia Policy-3047104
2020-03-20 Australia Policy-6056211
2020-01-21 Australia Policy-9681714
2020-05-28 Australia Policy-3886046
2020-01-05 Australia Policy-2468738
2020-03-24 Australia Policy-7778287
2020-01-03 Australia Policy-2644359
2020-03-26 Australia Policy-2942858
2020-04-23 Australia Policy-5866571
2020-03-19 Australia Policy-7598481
2020-03-20 Australia Policy-4697072
2020-03-30 Australia Policy-9230476
2020-02-04 Australia Policy-1257816
2020-04-27 Australia Policy-6929016
2020-05-20 Australia Policy-3192495
2020-05-06 Australia Policy-5742686
2020-01-21 Australia Policy-3514054
2020-06-02 Australia Policy-899424
2020-01-28 Australia Policy-899424
2020-02-03 Australia Policy-313076
2020-05-13 Australia Policy-5483463
2020-01-06 Australia Policy-372332
2020-01-02 Australia Policy-8416733
2020-02-03 Australia Policy-3763354
2020-08-20 Australia Policy-2229317
2020-04-28 Australia Policy-1653230
2020-03-25 Australia Policy-3495330
2020-03-06 Australia Policy-9556066
2020-05-03 Australia Policy-2338386
2020-03-05 Australia Policy-872420
2020-07-02 Australia Policy-648544
2020-01-06 Australia Policy-9776896
2020-10-08 Australia Policy-9059584
2020-03-29 Australia Policy-1017233
2020-03-04 Australia Policy-1714095
2020-03-25 Australia Policy-948508
2020-03-22 Australia Policy-628712
2020-04-16 Australia Policy-4519329
2020-01-28 Australia Policy-7299351
2020-04-26 Australia Policy-5356718
2020-06-06 Australia Policy-7857221
2020-03-28 Australia Policy-6931822
2020-04-24 Australia Policy-8709330
2020-07-07 Australia Policy-214945
2020-06-07 Australia Policy-214945
2020-03-18 Australia Policy-4463187
2020-03-27 Australia Policy-1559134
2020-03-26 Australia Policy-4657279
2020-03-23 Australia Policy-7369938
2020-02-05 Australia Policy-578959
2020-03-18 Australia Policy-9588194
2020-03-04 Australia Policy-6563526
2020-11-07 Australia Policy-5709114
2020-03-31 Australia Policy-4236315
2020-02-04 Australia Policy-7838742
2020-02-05 Australia Policy-7487898
2020-09-04 Australia Policy-8607667
2020-03-24 Australia Policy-3144269
2020-03-28 Australia Policy-357683
2020-03-14 Australia Policy-5212791
2020-03-23 Australia Policy-405096
2020-01-07 Australia Policy-5048388
2020-05-18 Australia Policy-5048388
2020-07-13 Australia Policy-5580303
2020-08-27 Australia Policy-7165723
2020-03-25 Australia Policy-6728273
2020-05-29 Australia Policy-7389658
2020-03-17 Australia Policy-6281315
2020-10-04 Australia Policy-5268655
2020-08-24 Australia Policy-8874992
2020-03-20 Australia Policy-5781245
2020-10-06 Australia Policy-212658
2020-03-28 Australia Policy-5246883
2020-01-06 Australia Policy-2498291
2020-01-02 Australia Policy-7218488
2020-02-05 Australia Policy-8820806
2020-04-28 Australia Policy-9215410
2020-01-02 Australia Policy-5814484
2020-04-29 Australia Policy-7644697
2020-03-19 Australia Policy-734010
2020-03-25 Australia Policy-5815641
2020-03-16 Australia Policy-8782298
2020-05-03 Australia Policy-7722975
2020-08-28 Australia Policy-7902208
2020-03-25 Australia Policy-852952
2020-08-19 Australia Policy-6722516
2020-03-15 Australia Border-Cross-Quarantine-Australia
2020-03-18 Australia Policy-1218642
2020-03-18 Australia Policy-875200
2020-03-25 Australia Policy-1831969
2020-10-04 Australia Policy-1059484
2020-10-08 Australia Policy-3315426
2020-07-17 Australia Policy-3504061
2020-01-09 Australia Policy-4480230
2020-09-18 Australia Policy-1649322
2020-04-02 Australia Policy-9013235
2020-04-25 Australia Policy-2515313
2020-01-28 Australia Policy-8441068
2020-03-30 Australia Policy-6911744
2020-03-27 Australia Policy-757781
2020-04-30 Australia Policy-1218417
2020-07-24 Australia Policy-4384818
2020-01-07 Australia Policy-4384818
2020-06-04 Australia Policy-4610550
2020-03-13 Australia Policy-9454185
2020-09-10 Australia Policy-7822582
2020-04-24 Australia Policy-3596868
2020-01-25 Australia Policy-6046630
2020-03-16 Australia Policy-2496144
2020-03-26 Australia Policy-6962631
2020-10-03 Australia Policy-2006341
2020-02-05 Australia Policy-5218881
2020-03-04 Australia Policy-5323094
2020-03-26 Australia Policy-8221851
2020-08-07 Australia Policy-3766159
2020-08-03 Australia Policy-1610829
2020-04-30 Australia Policy-489610
2020-03-20 Australia Policy-7493721
2020-03-29 Australia Policy-4168297
2020-03-23 Australia Policy-5015413
2020-04-04 Australia Policy-8019733
2020-03-20 Australia Policy-1650025
2020-07-20 Australia Policy-6228258
2020-03-29 Australia Policy-7333852
2020-05-29 Australia Policy-983443
2020-05-18 Australia Policy-4062424
2020-07-07 Australia Policy-2703044
2020-01-06 Australia Policy-6105720
2020-03-31 Australia Policy-6105720
2020-03-25 Australia Policy-2221008
2020-04-26 Australia Policy-2599738
2020-03-22 Australia Policy-495393
2020-03-23 Australia Policy-7248141
2020-03-26 Australia Policy-5988678
2020-08-20 Australia Policy-3900358
2020-05-27 Australia Policy-6761627
2020-03-26 Australia Policy-1185171
2020-03-18 Australia Policy-9421025
2020-04-04 Australia Policy-4435519
2020-03-23 Australia Policy-3132734
2020-05-18 Australia Policy-8486643
2020-03-29 Australia Policy-8505019
2020-11-03 Australia Policy-3952335
2020-03-17 Australia Policy-4892944
2020-08-04 Australia Policy-2057199
2020-11-03 Australia Policy-6417745
2020-06-04 Australia Policy-8097258
2020-03-19 Australia Policy-912489
2020-03-19 Australia Policy-4650800
2020-01-05 Australia Policy-1413492
2020-01-10 Australia Policy-6588316
2020-03-04 Australia Policy-266435
2020-05-05 Australia Policy-5227756
2020-01-07 Australia Policy-7268929
2020-03-23 Australia Policy-9916108
2020-03-22 Australia Policy-7855101
2020-08-13 Australia Policy-8827124
2020-06-24 Australia Policy-8827124
2020-03-31 Australia Policy-1199229
2020-03-25 Australia Policy-3019341
2020-04-27 Australia Policy-847012
2020-09-07 Australia Policy-4161508
2020-01-05 Australia Policy-4998015
2020-03-04 Australia Policy-8273738
2020-03-16 Australia Policy-5194790
2020-07-27 Australia Policy-8341933
2020-06-30 Australia Policy-156708
2020-03-05 Australia Policy-8528239
2020-08-05 Australia Policy-2672224
2020-04-20 Australia Policy-2048977
2020-03-24 Australia Policy-2998411
2020-03-20 Bavaria Lockdown-Bavaria
2020-03-16 Bavaria Face-Cover-Bavaria
2020-04-18 Bavaria Border-Cross-Quarantine-Bavaria
2020-03-22 New-York Lockdown-New-York
2020-04-15 New-York Face-Cover-New-York
2020-06-24 New-York Border-Cross-Quarantine-New-York
2020-03-19 California Lockdown-California
2020-06-18 California Face-Cover-California
2020-04-06 Sweden Border-Cross-Quarantine-Sweden
2020-03-13 Poland Lockdown-Poland
2020-04-16 Poland Face-Cover-Poland
2020-03-23 Poland Border-Cross-Quarantine-Poland
2020-06-07 Switzerland Border-Cross-Quarantine-Switzerland

Lets import covid cases data.

[16]:
covid_data = pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv')
[17]:
per_country_covid_data=covid_data.drop(["Lat","Long","Province/State"],axis=1).groupby("Country/Region").sum()
per_country_covid_data=per_country_covid_data[per_country_covid_data.index.isin(regions["Instance"])].T
[18]:
per_country_covid_data.index = pd.to_datetime(per_country_covid_data.index)
[33]:
new_cases = per_country_covid_data.diff(periods=1).dropna()
[34]:
new_cases
[34]:
Country/Region Australia Germany Poland Sweden Switzerland
2020-01-23 0.0 0.0 0.0 0.0 0.0
2020-01-24 0.0 0.0 0.0 0.0 0.0
2020-01-25 0.0 0.0 0.0 0.0 0.0
2020-01-26 4.0 0.0 0.0 0.0 0.0
2020-01-27 1.0 1.0 0.0 0.0 0.0
2020-01-28 0.0 3.0 0.0 0.0 0.0
2020-01-29 1.0 0.0 0.0 0.0 0.0
2020-01-30 3.0 0.0 0.0 0.0 0.0
2020-01-31 0.0 1.0 0.0 0.0 0.0
2020-02-01 3.0 3.0 0.0 1.0 0.0
2020-02-02 0.0 2.0 0.0 0.0 0.0
2020-02-03 0.0 2.0 0.0 0.0 0.0
2020-02-04 1.0 0.0 0.0 0.0 0.0
2020-02-05 0.0 0.0 0.0 0.0 0.0
2020-02-06 1.0 0.0 0.0 0.0 0.0
2020-02-07 1.0 1.0 0.0 0.0 0.0
2020-02-08 0.0 0.0 0.0 0.0 0.0
2020-02-09 0.0 1.0 0.0 0.0 0.0
2020-02-10 0.0 0.0 0.0 0.0 0.0
2020-02-11 0.0 2.0 0.0 0.0 0.0
2020-02-12 0.0 0.0 0.0 0.0 0.0
2020-02-13 0.0 0.0 0.0 0.0 0.0
2020-02-14 0.0 0.0 0.0 0.0 0.0
2020-02-15 0.0 0.0 0.0 0.0 0.0
2020-02-16 0.0 0.0 0.0 0.0 0.0
2020-02-17 0.0 0.0 0.0 0.0 0.0
2020-02-18 0.0 0.0 0.0 0.0 0.0
2020-02-19 0.0 0.0 0.0 0.0 0.0
2020-02-20 0.0 0.0 0.0 0.0 0.0
2020-02-21 0.0 0.0 0.0 0.0 0.0
2020-02-22 0.0 0.0 0.0 0.0 0.0
2020-02-23 0.0 0.0 0.0 0.0 0.0
2020-02-24 0.0 0.0 0.0 0.0 0.0
2020-02-25 0.0 1.0 0.0 0.0 1.0
2020-02-26 0.0 10.0 0.0 1.0 0.0
2020-02-27 0.0 19.0 0.0 1.0 7.0
2020-02-28 0.0 2.0 0.0 8.0 0.0
2020-02-29 10.0 31.0 0.0 3.0 10.0
2020-03-01 2.0 51.0 0.0 0.0 9.0
2020-03-02 3.0 29.0 0.0 5.0 15.0
2020-03-03 9.0 37.0 0.0 13.0 14.0
2020-03-04 13.0 66.0 1.0 30.0 34.0
2020-03-05 3.0 220.0 0.0 25.0 24.0
2020-03-06 5.0 188.0 4.0 59.0 100.0
2020-03-07 3.0 129.0 0.0 33.0 54.0
2020-03-08 13.0 241.0 6.0 46.0 69.0
2020-03-09 15.0 136.0 5.0 101.0 37.0
2020-03-10 16.0 281.0 6.0 98.0 117.0
2020-03-11 21.0 451.0 9.0 196.0 161.0
2020-03-12 0.0 170.0 18.0 151.0 0.0
2020-03-13 72.0 1597.0 19.0 152.0 487.0
2020-03-14 50.0 910.0 35.0 71.0 220.0
2020-03-15 47.0 1210.0 16.0 69.0 841.0
2020-03-16 80.0 1477.0 58.0 83.0 0.0
2020-03-17 75.0 1985.0 61.0 119.0 500.0
2020-03-18 116.0 3070.0 13.0 145.0 328.0
2020-03-19 113.0 2993.0 104.0 143.0 1047.0
2020-03-20 110.0 4528.0 70.0 180.0 1219.0
2020-03-21 280.0 2365.0 111.0 135.0 1281.0
2020-03-22 478.0 2660.0 98.0 118.0 899.0
2020-03-23 133.0 4183.0 115.0 182.0 1321.0
2020-03-24 362.0 3930.0 152.0 230.0 1082.0
2020-03-25 320.0 4337.0 150.0 314.0 1020.0
2020-03-26 446.0 6615.0 170.0 286.0 914.0
2020-03-27 333.0 6933.0 168.0 365.0 1117.0
2020-03-28 497.0 6824.0 249.0 300.0 1148.0
2020-03-29 344.0 4400.0 224.0 280.0 753.0
2020-03-30 377.0 4790.0 193.0 416.0 1093.0
2020-03-31 198.0 4923.0 256.0 475.0 683.0
2020-04-01 303.0 6064.0 243.0 486.0 1163.0
2020-04-02 254.0 6922.0 392.0 554.0 1059.0
2020-04-03 214.0 6365.0 437.0 601.0 779.0
2020-04-04 220.0 4933.0 244.0 357.0 899.0
2020-04-05 137.0 4031.0 475.0 340.0 595.0
2020-04-06 110.0 3251.0 311.0 389.0 557.0
2020-04-07 98.0 4289.0 435.0 738.0 596.0
2020-04-08 115.0 5633.0 357.0 655.0 1027.0
2020-04-09 98.0 4885.0 370.0 645.0 771.0
2020-04-10 107.0 3990.0 380.0 454.0 500.0
2020-04-11 88.0 2737.0 401.0 395.0 556.0
2020-04-12 12.0 2946.0 318.0 464.0 308.0
2020-04-13 36.0 2218.0 260.0 437.0 273.0
2020-04-14 64.0 1287.0 268.0 479.0 248.0
2020-04-15 25.0 3394.0 380.0 604.0 400.0
2020-04-16 22.0 2945.0 336.0 623.0 396.0
2020-04-17 60.0 3699.0 461.0 688.0 346.0
2020-04-18 46.0 1945.0 363.0 532.0 326.0
2020-04-19 42.0 1842.0 545.0 388.0 336.0
2020-04-20 13.0 1881.0 306.0 461.0 204.0
2020-04-21 22.0 1226.0 263.0 707.0 119.0
2020-04-22 7.0 2357.0 313.0 722.0 205.0
2020-04-23 10.0 2481.0 342.0 758.0 228.0
2020-04-24 15.0 1870.0 381.0 779.0 181.0
2020-04-25 17.0 1514.0 381.0 473.0 217.0
2020-04-26 20.0 1257.0 344.0 300.0 167.0
2020-04-27 7.0 988.0 285.0 563.0 103.0
2020-04-28 23.0 1154.0 316.0 742.0 100.0
2020-04-29 8.0 1627.0 422.0 798.0 143.0
2020-04-30 14.0 1470.0 237.0 635.0 179.0
2020-05-01 12.0 1068.0 228.0 532.0 119.0
2020-05-02 21.0 890.0 270.0 299.0 112.0
2020-05-03 23.0 697.0 318.0 261.0 88.0
2020-05-04 25.0 488.0 313.0 476.0 76.0
2020-05-05 28.0 855.0 425.0 657.0 28.0
2020-05-06 19.0 1155.0 309.0 746.0 51.0
2020-05-07 19.0 1268.0 307.0 787.0 66.0
2020-05-08 5.0 1158.0 319.0 700.0 81.0
2020-05-09 21.0 736.0 285.0 509.0 44.0
2020-05-10 9.0 555.0 345.0 278.0 54.0
2020-05-11 22.0 697.0 330.0 455.0 39.0
2020-05-12 10.0 595.0 595.0 754.0 36.0
2020-05-13 9.0 927.0 283.0 700.0 33.0
2020-05-14 30.0 380.0 411.0 660.0 50.0
2020-05-15 16.0 755.0 401.0 688.0 51.0
2020-05-16 9.0 519.0 241.0 358.0 58.0
2020-05-17 10.0 617.0 272.0 259.0 15.0
2020-05-18 14.0 182.0 356.0 431.0 10.0
2020-05-19 4.0 1227.0 383.0 667.0 21.0
2020-05-20 9.0 695.0 471.0 808.0 40.0
2020-05-21 14.0 548.0 404.0 610.0 36.0
2020-05-22 4.0 689.0 476.0 532.0 13.0
2020-05-23 15.0 276.0 312.0 403.0 18.0
2020-05-24 0.0 342.0 395.0 210.0 11.0
2020-05-25 12.0 272.0 305.0 490.0 10.0
2020-05-26 13.0 600.0 443.0 746.0 15.0
2020-05-27 11.0 324.0 399.0 800.0 15.0
2020-05-28 15.0 672.0 352.0 774.0 20.0
2020-05-29 19.0 726.0 330.0 773.0 32.0
2020-05-30 8.0 267.0 416.0 432.0 17.0
2020-05-31 10.0 221.0 215.0 265.0 17.0
2020-06-01 19.0 184.0 379.0 648.0 9.0
2020-06-02 8.0 285.0 230.0 901.0 3.0
2020-06-03 11.0 242.0 292.0 1046.0 19.0
2020-06-04 7.0 351.0 361.0 1039.0 20.0
2020-06-05 5.0 452.0 362.0 1146.0 23.0
2020-06-06 7.0 526.0 576.0 783.0 20.0
2020-06-07 6.0 300.0 575.0 462.0 9.0
2020-06-08 2.0 359.0 599.0 677.0 7.0
2020-06-09 7.0 397.0 400.0 936.0 16.0
2020-06-10 11.0 16.0 282.0 1437.0 23.0
2020-06-11 4.0 169.0 359.0 1294.0 33.0
2020-06-12 5.0 535.0 376.0 1337.0 19.0
2020-06-13 26.0 41.0 440.0 1042.0 31.0
2020-06-14 15.0 251.0 375.0 418.0 23.0
2020-06-15 12.0 164.0 396.0 684.0 14.0
2020-06-16 23.0 570.0 407.0 1218.0 23.0
2020-06-17 21.0 352.0 506.0 1457.0 33.0
2020-06-18 18.0 1213.0 314.0 1496.0 13.0
2020-06-19 2.0 482.0 301.0 1213.0 35.0
2020-06-20 50.0 371.0 304.0 702.0 8.0
2020-06-21 13.0 602.0 311.0 321.0 49.0
2020-06-22 18.0 496.0 296.0 800.0 18.0
2020-06-23 29.0 712.0 300.0 1312.0 22.0
2020-06-24 37.0 391.0 294.0 1698.0 44.0
2020-06-25 37.0 500.0 298.0 1281.0 52.0
2020-06-26 6.0 665.0 276.0 1203.0 58.0
2020-06-27 85.0 422.0 319.0 760.0 69.0
2020-06-28 78.0 235.0 193.0 420.0 62.0
2020-06-29 70.0 349.0 247.0 727.0 35.0
2020-06-30 86.0 376.0 239.0 805.0 62.0
2020-07-01 81.0 475.0 382.0 684.0 137.0
2020-07-02 65.0 477.0 371.0 689.0 116.0
2020-07-03 194.0 410.0 259.0 699.0 134.0
2020-07-04 183.0 418.0 314.0 370.0 97.0
2020-07-05 140.0 325.0 231.0 315.0 70.0
2020-07-06 172.0 541.0 205.0 251.0 47.0
2020-07-07 131.0 279.0 257.0 278.0 54.0
2020-07-08 170.0 356.0 277.0 537.0 129.0
2020-07-09 318.0 302.0 262.0 335.0 88.0
2020-07-10 179.0 331.0 265.0 377.0 104.0
2020-07-11 244.0 377.0 305.0 314.0 127.0
2020-07-12 183.0 210.0 370.0 106.0 66.0
2020-07-13 271.0 261.0 299.0 170.0 63.0
2020-07-14 236.0 276.0 267.0 315.0 70.0
2020-07-15 323.0 434.0 264.0 299.0 132.0
2020-07-16 423.0 560.0 333.0 273.0 142.0
2020-07-17 208.0 595.0 353.0 299.0 92.0
2020-07-18 361.0 381.0 339.0 200.0 110.0
2020-07-19 267.0 309.0 358.0 110.0 99.0
2020-07-20 359.0 590.0 279.0 131.0 43.0
2020-07-21 466.0 392.0 399.0 226.0 108.0
2020-07-22 408.0 559.0 380.0 297.0 141.0
2020-07-23 293.0 605.0 418.0 220.0 117.0
2020-07-24 355.0 742.0 458.0 262.0 154.0
2020-07-25 453.0 655.0 584.0 138.0 148.0
2020-07-26 532.0 389.0 443.0 42.0 110.0
2020-07-27 368.0 445.0 337.0 71.0 65.0
2020-07-28 279.0 595.0 502.0 283.0 132.0
2020-07-29 716.0 839.0 512.0 301.0 193.0
2020-07-30 605.0 989.0 615.0 302.0 220.0
2020-07-31 377.0 864.0 657.0 258.0 210.0
2020-08-01 615.0 606.0 658.0 303.0 180.0
2020-08-02 423.0 215.0 548.0 38.0 138.0
2020-08-03 412.0 891.0 575.0 165.0 66.0
2020-08-04 715.0 717.0 680.0 334.0 130.0
2020-08-05 445.0 1285.0 640.0 425.0 181.0
2020-08-06 382.0 926.0 726.0 378.0 181.0
2020-08-07 426.0 1157.0 809.0 380.0 161.0
2020-08-08 386.0 707.0 843.0 260.0 182.0
2020-08-09 313.0 385.0 624.0 73.0 152.0
2020-08-10 316.0 1220.0 619.0 196.0 105.0
2020-08-11 414.0 1032.0 551.0 417.0 187.0
2020-08-12 231.0 1319.0 715.0 444.0 274.0
2020-08-13 384.0 1422.0 811.0 362.0 234.0
2020-08-14 293.0 1510.0 832.0 344.0 268.0
2020-08-15 252.0 697.0 771.0 226.0 253.0
2020-08-16 271.0 519.0 594.0 63.0 200.0
2020-08-17 215.0 1693.0 595.0 174.0 128.0
2020-08-18 216.0 1420.0 597.0 314.0 197.0
2020-08-19 247.0 1586.0 735.0 351.0 311.0
2020-08-20 171.0 1586.0 767.0 333.0 266.0
2020-08-21 195.0 1737.0 903.0 298.0 306.0
2020-08-22 209.0 832.0 900.0 160.0 295.0
2020-08-23 104.0 633.0 581.0 57.0 276.0
2020-08-24 138.0 1628.0 548.0 182.0 157.0
2020-08-25 151.0 1461.0 763.0 225.0 202.0
2020-08-26 118.0 1427.0 729.0 246.0 383.0
2020-08-27 126.0 1561.0 887.0 134.0 361.0
2020-08-28 99.0 1555.0 791.0 0.0 340.0
2020-08-29 123.0 709.0 759.0 0.0 376.0
2020-08-30 76.0 470.0 631.0 0.0 292.0
2020-08-31 73.0 1497.0 502.0 421.0 163.0
2020-09-01 104.0 1213.0 550.0 142.0 216.0
2020-09-02 126.0 1396.0 595.0 11.0 370.0
2020-09-03 87.0 1429.0 612.0 197.0 364.0
2020-09-04 71.0 1443.0 691.0 256.0 405.0
2020-09-05 71.0 775.0 567.0 0.0 425.0
2020-09-06 43.0 670.0 437.0 0.0 444.0
2020-09-07 52.0 1898.0 302.0 573.0 191.0
2020-09-08 92.0 1331.0 400.0 149.0 245.0
2020-09-09 59.0 1476.0 421.0 173.0 469.0
2020-09-10 40.0 1716.0 506.0 314.0 405.0
2020-09-11 43.0 1586.0 594.0 311.0 528.0
2020-09-12 44.0 1082.0 603.0 0.0 465.0
2020-09-13 41.0 920.0 502.0 0.0 475.0
2020-09-14 47.0 1485.0 377.0 0.0 257.0
2020-09-15 39.0 1792.0 605.0 840.0 315.0
2020-09-16 35.0 1855.0 600.0 230.0 514.0
2020-09-17 48.0 2179.0 837.0 310.0 530.0
2020-09-18 24.0 2199.0 757.0 352.0 488.0
2020-09-19 13.0 1685.0 1002.0 0.0 0.0
2020-09-20 14.0 1033.0 910.0 0.0 0.0
2020-09-21 30.0 1595.0 748.0 0.0 1095.0
2020-09-22 30.0 1852.0 711.0 1199.0 286.0
2020-09-23 8.0 1613.0 974.0 320.0 437.0
2020-09-24 20.0 2321.0 1136.0 533.0 391.0
2020-09-25 16.0 2366.0 1587.0 634.0 372.0
2020-09-26 24.0 1314.0 1584.0 0.0 0.0
2020-09-27 4.0 1313.0 1350.0 0.0 0.0
2020-09-28 11.0 2292.0 1306.0 0.0 782.0
2020-09-29 23.0 1840.0 1326.0 1543.0 225.0
2020-09-30 18.0 2442.0 1552.0 397.0 411.0
2020-10-01 13.0 2626.0 1967.0 752.0 550.0
2020-10-02 12.0 2835.0 2292.0 668.0 552.0
2020-10-03 14.0 1653.0 2367.0 0.0 0.0
2020-10-04 13.0 1546.0 1934.0 0.0 0.0
2020-10-05 25.0 3100.0 2006.0 0.0 1548.0
2020-10-06 8.0 2454.0 2236.0 1862.0 700.0
2020-10-07 25.0 4010.0 3003.0 532.0 1077.0
2020-10-08 20.0 4804.0 4280.0 855.0 1172.0
2020-10-09 18.0 4554.0 4739.0 919.0 1487.0
2020-10-10 19.0 2968.0 5300.0 0.0 0.0
2020-10-11 22.0 2846.0 4178.0 0.0 0.0
2020-10-12 25.0 6541.0 4394.0 0.0 4068.0
2020-10-13 27.0 4464.0 5068.0 2203.0 1445.0
2020-10-14 20.0 7173.0 6526.0 678.0 2823.0
2020-10-15 14.0 7620.0 8099.0 1075.0 2613.0
2020-10-16 7.0 7695.0 7705.0 793.0 3105.0
2020-10-17 12.0 4862.0 9622.0 0.0 0.0
2020-10-18 9.0 4007.0 8536.0 0.0 0.0
2020-10-19 6.0 8397.0 7482.0 0.0 8737.0
2020-10-20 38.0 8523.0 9291.0 3180.0 3008.0
2020-10-21 15.0 12331.0 10040.0 975.0 5596.0
[21]:
from matplotlib import pyplot as plt
%matplotlib inline
[35]:
plt.figure(figsize=(12,8))

rolling14 = new_cases.rolling(window=14).mean()
for column in rolling14.columns:
    plt.plot(rolling14.index, rolling14[column], label=column)

plt.legend(loc=4)
#plt.yscale("log")

plt.show()
../../_images/jupyter_notebooks_Covid_Virus_31_0.png

Figure shows covid new cases in time on logarythmic scale.

[28]:
from datetime import timedelta
[29]:
for i, column in enumerate(rolling14.columns):
    plt.figure(figsize=(12,4))
    plt.plot(rolling14.index, rolling14[column], label=column)
    plt.legend()
    for datex,row in df[df["region"]==column].iterrows():
        datex=datex+timedelta(1)
        val = 0.0
        if datex in rolling14[column].index:
            val =rolling14[column].loc[datex]
        val = 0.0 if val!=val else val
        plt.scatter(datex, val , marker="|", s=500, c="red")
#        plt.annotate(row.restriction, (datex, val), xytext=(-20,20),
#            textcoords='offset points', ha='center', va='bottom', arrowprops=dict(arrowstyle='->',
#            connectionstyle='arc3,rad=0.5', color='red'))
    plt.show()
../../_images/jupyter_notebooks_Covid_Virus_34_0.png
../../_images/jupyter_notebooks_Covid_Virus_34_1.png
../../_images/jupyter_notebooks_Covid_Virus_34_2.png
../../_images/jupyter_notebooks_Covid_Virus_34_3.png
../../_images/jupyter_notebooks_Covid_Virus_34_4.png

Plots contains marks on them which show when given restrcion was introduced.