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()
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()
Plots contains marks on them which show when given restrcion was introduced.