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 details)

Uploaded Source

Built Distribution

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

Uploaded Python 3

File details

Details for the file PL94andTigertoSQLite3-0.1.1.tar.gz.

File metadata

  • Download URL: PL94andTigertoSQLite3-0.1.1.tar.gz
  • Upload date:
  • Size: 5.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/3.10.0 pkginfo/1.8.2 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.59.0 CPython/3.8.5

File hashes

Hashes for PL94andTigertoSQLite3-0.1.1.tar.gz
Algorithm Hash digest
SHA256 b9d8fc668d9c8232cbf8d7e45d3be396fcd450f95d39e0d02a834f28ba200c35
MD5 5b254adb559dbd634612394a8992d181
BLAKE2b-256 7ad835f7b31a48af90fd0b0c6623fd9b02edb1dd945d0ff8b0d10895878ec7a1

See more details on using hashes here.

File details

Details for the file PL94andTigertoSQLite3-0.1.1-py3-none-any.whl.

File metadata

  • Download URL: PL94andTigertoSQLite3-0.1.1-py3-none-any.whl
  • Upload date:
  • Size: 6.3 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/3.10.0 pkginfo/1.8.2 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.59.0 CPython/3.8.5

File hashes

Hashes for PL94andTigertoSQLite3-0.1.1-py3-none-any.whl
Algorithm Hash digest
SHA256 3f7ab6cc5bebff0713aea799ae209168a095d86ac003fe8820c92428b180c601
MD5 82970060165d527b82e9b4a9b9416755
BLAKE2b-256 22bc0075a94572190ad599b4b3e6fc9f18f59420980861e31acd6a7fd9e5df08

See more details on using hashes here.

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