search

sfbrigade / datasci-sba

Solving problems with the Small Business Administration
10 stars 18 forks source link

Fixing data types #30

Closed VincentLa closed 7 years ago

VincentLa commented 7 years ago

In this PR I am

  1. Fixing the Parsers to load data in with the correct data types
  2. Adding Primary Keys to our tables
  3. Refactoring the code for trg_analytics.sba_zip_level (just making the SQL tighter)
  4. In trg_analytics.sba_zip_level only include zipcodes that are in our dataset. Thanks @makfan64 for loading this into our DB!
VincentLa14 commented 7 years ago

Thanks! @fiascojazz