naq-reports-quick
v0.0.2
Published
These are quick reports that I've made to pull data from PostgresSQL.
Downloads
3
Readme
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 [email protected] -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