Quickly load National Provider Identifier (NPI) and Health Care Provider Taxonomy data into Postgres
# Replace empty "" integer fields in NPI CSV file
$ sed 's/""//g' npidata_20050523-20160110.csv > npi.csv
# Convert taxonomy data to utf-8 and tab delimited
$ iconv -c -t utf8 nucc_taxonomy_160.csv | csvformat -T > taxonomy.tab$ createdb -O [USERNAME] [DBNAME]
$ ./create_npi_db.sh [USERNAME] [DBNAME] /full/path/npi.csv /full/path/taxonomy.tab