Socket
Socket
Sign inDemoInstall

naq-reports-quick

Package Overview
Dependencies
18
Maintainers
1
Versions
2
Alerts
File Explorer

Advanced tools

Install Socket

Detect and block malicious and high-risk dependencies

Install

    naq-reports-quick

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


Version published
0
Maintainers
1
Created
Weekly downloads
 

Readme

Source

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

FAQs

Last updated on 11 Mar 2016

Did you know?

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc