naq-reports-quick

naq-reports-quick

These are quick reports that I've made to pull data from PostgreSQL.

Tech

• Node
• PostgreSQL

Database

I typically don't have the PostgreSQL database running on my system. Instead I create a local tunnel to the database server I would like to use.

ssh -L 5432:localhost:5432 <username>@<ip> -p <ssh port>

Example: ssh -L 5432:localhost:5432 naqio@192.168.1.42 -p 22

Reports

Real Estate Economics Counts by Year by County

Usage

./bin/ree_fips_year_counts > /users/naq.io/Desktop/dates.csv

Description

Creates a report showing the counts by year of housing transactions in each county covered by Real Estate Economics.

Reason For Creation

The sales team at Real Estate Economics needed a report to see how far back housing transactions data went for each county.

Header Row

State, County, Fips, {...years}

Require Tables/Fields

trn_processed: abv, county, fips, date