Changes

A version of crunchbase3 database is live on the postgresql in Z:/crunchbase3. However, a few csv files have not been copied to the SQL database because of data type errors, which is a small problem but Hiep will need to spend some time to fixthat. Hiep will fix work on it next week (March 28th).

Right now, a modification of load_crunchbase.sql is in both Z:/crunchbase3 and E:/projects/crunchbase3. Changes in dataset, datatype, and data columns have been made a lot compared to the previous version. The columns that are not yet added to the postgres postgresql db are noted inside two lines of ################'sin the sql script. Since the data has changed a lot compared to last year, using \i load_crunchbase.sql was not very useful, one may need to copy one table at a time by pasting the sql script into the terminal. Files that have not yet been copied to the postgresql server are degrees.csv events.csv funding_round.csv funds.csv investors.csv ipos.csv jobs.csv organizations.csv people.csv