olihawkins

MDB Excavation

MDB is a Microsoft Access Database file. We'd like to look inside of it, but we have a Mac and no MS Office license.

export.py is a program that can do each of the following:

1. Put each table into its own .csv file to look at.
2. Put each table in the data into an excel / google sheets doc for easy viewing/browsing
3. Create a sqlite db which is similarly portable but accessible via a variety of common tools

olihawkins

# Functions for downloading data on Coronavirus cases in the UK by country, 
# region, NHS region, and local authority from the government dashboard API.
#
# The developer guide is here:
#
# https://coronavirus.data.gov.uk/developers-guide
# 
# The code below is based on the example code shown there.
# 
# Run ...

olihawkins

# -*- coding: utf-8 -*-

import pdpy

def fetch_mps_email():
    return fetch_members_email(house=pdpy.constants.PDP_ID_HOUSE_OF_COMMONS)

def fetch_lords_email():
    return fetch_members_email(house=pdpy.constants.PDP_ID_HOUSE_OF_LORDS)

olihawkins

# -*- coding: utf-8 -*-

"""
This is the Python module I used for scraping planetary data for the BBC radio
programme More or Less. You can read more about it here:

http://olihawkins.com/2019/02/1

"""