Example #1
0
def update_db():
    import_dataset(
        dataset_name=DATASET_NAME,
        namespace="owid",
        csv_path=os.path.join(GRAPHER_PATH, DATASET_NAME + ".csv"),
        default_variable_display={"yearIsDay": True, "zeroDay": ZERO_DAY},
        source_name="Official data collated by Our World in Data",
        slack_notifications=True,
    )
Example #2
0
def update_db():
    time_str = datetime.now().astimezone(
        pytz.timezone('Europe/London')).strftime("%-d %B, %H:%M")
    source_name = f"European CDC – Situation Update Worldwide – Last updated {time_str} (London time)"
    import_dataset(dataset_name=DATASET_NAME,
                   namespace='owid',
                   csv_path=os.path.join(OUTPUT_PATH, DATASET_NAME + ".csv"),
                   default_variable_display={
                       'yearIsDay': True,
                       'zeroDay': ZERO_DAY
                   },
                   source_name=source_name)
Example #3
0
def update_db():
    time_str = datetime.now().astimezone(
        pytz.timezone("Europe/London")).strftime("%-d %B, %H:%M")
    source_name = f"Google COVID-19 Community Mobility Trends – Last updated {time_str} (London time)"
    import_dataset(dataset_name=DATASET_NAME,
                   namespace="owid",
                   csv_path=OUTPUT_CSV_PATH,
                   default_variable_display={
                       "yearIsDay": True,
                       "zeroDay": ZERO_DAY
                   },
                   source_name=source_name)
Example #4
0
def update_db():
    time_str = datetime.now().astimezone(
        pytz.timezone("Europe/London")).strftime("%-d %B, %H:%M")
    source_name = f"Johns Hopkins University CSSE COVID-19 Data – Last updated {time_str} (London time)"
    import_dataset(dataset_name=DATASET_NAME,
                   namespace="owid",
                   csv_path=os.path.join(OUTPUT_PATH, DATASET_NAME + ".csv"),
                   default_variable_display={
                       "yearIsDay": True,
                       "zeroDay": ZERO_DAY
                   },
                   source_name=source_name)
Example #5
0
def update_db():
    time_str = datetime.now().astimezone(
        pytz.timezone("US/Eastern")).strftime("%B %-d, %H:%M")
    source_name = f"Centers for Disease Control and Prevention – Last updated {time_str} (Eastern Time)"
    import_dataset(dataset_name=DATASET_NAME,
                   namespace='owid',
                   csv_path=os.path.join(GRAPHER_PATH, DATASET_NAME + ".csv"),
                   default_variable_display={
                       'yearIsDay': True,
                       'zeroDay': ZERO_DAY
                   },
                   source_name=source_name)
Example #6
0
def update_db():
    import_dataset(
        dataset_name=DATASET_NAME,
        namespace='owid',
        csv_path=OUTPUT_CSV_PATH,
        default_variable_display={
            'yearIsDay': True,
            'zeroDay': ZERO_DAY
        },
        source_name="Official data collated by Our World in Data",
        slack_notifications=False
    )
Example #7
0
def update_db():
    time_str = datetime.now().astimezone(
        pytz.timezone('Europe/London')).strftime("%-d %B, %H:%M")
    source_name = f"Hale, Webster, Petherick, Phillips, and Kira (2020). Oxford COVID-19 Government Response Tracker – Last updated {time_str} (London time)"
    import_dataset(dataset_name=DATASET_NAME,
                   namespace='owid',
                   csv_path=OUTPUT_CSV_PATH,
                   default_variable_display={
                       'yearIsDay': True,
                       'zeroDay': ZERO_DAY
                   },
                   source_name=source_name,
                   slack_notifications=False)
Example #8
0
def update_db():
    time_str = datetime.datetime.now().astimezone(
        pytz.timezone("Europe/London")).strftime("%-d %B, %H:%M")
    source_name = f"European CDC for EU countries, government sources for other countries – Last updated {time_str} (London time)"
    import_dataset(dataset_name=DATASET_NAME,
                   namespace='owid',
                   csv_path=os.path.join(GRAPHER_PATH, DATASET_NAME + ".csv"),
                   default_variable_display={
                       'yearIsDay': True,
                       'zeroDay': ZERO_DAY
                   },
                   source_name=source_name,
                   slack_notifications=True)
Example #9
0
def update_db():
    time_str = datetime.now().astimezone(
        pytz.timezone('Europe/London')).strftime("%-d %B, %H:%M")
    source_name = f"Hale, Angrist, Goldszmidt, Kira, Petherick, Phillips, Webster, Cameron-Blake, Hallas, Majumdar, and Tatlow (2021). “A global panel database of pandemic policies (Oxford COVID-19 Government Response Tracker).” Nature Human Behaviour. – Last updated {time_str} (London time)"
    import_dataset(dataset_name=DATASET_NAME,
                   namespace='owid',
                   csv_path=OUTPUT_CSV_PATH,
                   default_variable_display={
                       'yearIsDay': True,
                       'zeroDay': ZERO_DAY
                   },
                   source_name=source_name,
                   slack_notifications=False)
Example #10
0
def update_db():
    time_str = datetime.now().astimezone(
        pytz.timezone('Europe/London')).strftime("%-d %B, %H:%M")
    source_name = f"Official data collated by Our World in Data – Last updated {time_str} (London time)"
    import_dataset(dataset_name=DATASET_NAME,
                   namespace='owid',
                   csv_path=OUTPUT_CSV_PATH,
                   default_variable_display={
                       'yearIsDay': True,
                       'zeroDay': ZERO_DAY
                   },
                   source_name=source_name,
                   slack_notifications=False)
Example #11
0
def update_db():
    time_str = datetime.now().astimezone(
        pytz.timezone("Europe/London")).strftime("%-d %B, %H:%M")
    source_name = f"Swedish Public Health Agency – Last updated {time_str} (London time)"
    import_dataset(dataset_name=DATASET_NAME,
                   namespace='owid',
                   csv_path=os.path.join(GRAPHER_PATH, DATASET_NAME + ".csv"),
                   default_variable_display={
                       'yearIsDay': True,
                       'zeroDay': ZERO_DAY
                   },
                   source_name=source_name,
                   slack_notifications=False)
Example #12
0
def update_db():
    time_str = datetime.datetime.now().astimezone(pytz.timezone('Europe/London')).strftime("%-d %B %Y, %H:%M")
    source_name = f"Imperial College London YouGov Covid 19 Behaviour Tracker Data Hub – Last updated {time_str} (London time)"
    import_dataset(
        dataset_name=DATASET_NAME,
        namespace='owid',
        csv_path=OUTPUT_CSV_PATH,
        default_variable_display={
            'yearIsDay': True,
            'zeroDay': ZERO_DAY
        },
        source_name=source_name,
        slack_notifications=False
    )
Example #13
0
def update_db():
    time_str = datetime.now().astimezone(
        pytz.timezone("Europe/London")).strftime("%-d %B, %H:%M")
    source_name = f"UK Government Coronavirus (COVID-19) Dashboard – Last updated {time_str} (London time)"
    import_dataset(
        dataset_name=DATASET_NAME,
        namespace="owid",
        csv_path=OUTPUT_CSV,
        default_variable_display={
            "yearIsDay": True,
            "zeroDay": ZERO_DAY
        },
        source_name=source_name,
        slack_notifications=True,
    )
Example #14
0
 def to_db(self, suffix=""):
     from utils.db_imports import import_dataset
     time_str = datetime.datetime.now().astimezone(
         pytz.timezone('Europe/London')).strftime("%-d %B %Y, %H:%M")
     source_name = (
         f"Imperial College London YouGov Covid 19 Behaviour Tracker Data Hub – Last updated {time_str} "
         f"(London time)")
     import_dataset(dataset_name=self.dataset_name + suffix,
                    namespace='owid',
                    csv_path=self.output_csv_path,
                    default_variable_display={
                        'yearIsDay': True,
                        'zeroDay': ZERO_DAY
                    },
                    source_name=source_name,
                    slack_notifications=False)