Collecting dutch healthcare related opendataset & analyzing important factors for NL coronovirus infected number

The overall result is published on colab. Or you can dowloaded public_healthcare_dataset_NL.ipynb.

Overall steps:

1. Web crawlling/downloading open-dataset from different websites
2. Inserting data into bigquery
3. Combining all collected data to find important factors for NL coronovirus infected number

File structure:

• about_nl:
  • dutch cities info
• accuweather:
  • ducth city weather info
• bq_public_dataset:
  • openstreet:
    • dutch map node in openstreet
  • other_dataset:
    • other dutch info extracted from google public dataset
• coronvirus_NL:
  • coronorivus info in NL.
• nivel:
  • open dataset collected from nivel
• statline_rivm:
  • open dataset collected from nivel
• vetkis:
  • open dataset collected from nivel
• volksgezondheidenzorg:
  • open dataset collected from nivel
• zorgkaartnederland:
  • open dataset collected from nivel
• public_healthcare_dataset_NL.ipynb: the overall analysis of this opendatset.

N.B. Remeber to replace 'your bq credential json path' in python files and your_project_name in sql query files.