Skip to main content

Scrape Census PL-94 datasets and TigerFiles and builds a SQLite3 database usibg those files

Project description

Census PL-94 to SQLite3

Simple tool to build out the Census PL-94 datasets from the FTP and build a SQLite3 database

Usage

getPL94(database, Exists='drop', Table='PL94', Vintage=2020, State=None, Directory=None)

Parameters

database - Name of database you would like to add data to

Exists - DEFAULT: drop any SQLite3 command for if_exists prameters

Table - DEFAULT: PL94 name of table in SQLite database

Vintage - DEFAULT: 2020 either 2020 or 2010 PL94 dataset are avaible through the FTP

State - DEFAULT: None unless secified by full name or 2 letter abberviation will build PL-94 National Dataset

Directory - DEFAULT: None dirctory where you would like to write too if not the current directory

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

PL94andTigertoSQLite3-0.1.1.tar.gz (5.4 kB view hashes)

Uploaded Source

Built Distribution

PL94andTigertoSQLite3-0.1.1-py3-none-any.whl (6.3 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page