/
README
32 lines (26 loc) · 976 Bytes
/
README
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
--
This data is provided as-is without any warranty.
Reasonable effort has been put in to make sure the data is accurate.
You are welcome and encouraged to use this data to create interesting visualizations and reports.
Please mention www.disclosed.ca as the generator of the data.
Source of the data is: http://www.tbs-sct.gc.ca/pd-dp/index-eng.asp
--
The CSV column names are:
- uri
- agency name
- vendor name
- reference number
- contract date
- description of work
- contract period
- delivery date
- contract value
- comments
--
LOADING INTO MYSQL
==================
mysqladmin -uroot create disclosed
mysql -uroot disclosed < contracts.sql
rm -f contracts.csv
cat *.csv >> contracts.csv
LOAD DATA LOCAL INFILE 'contracts.csv' IGNORE INTO TABLE contracts FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (uri, agency_name, vendor_name, reference_number, contract_date, description, contract_period, delivery_date, contract_value, comments)