Changes

|Has title=VentureXpert Data

|Has owner=Augi Liebster,

|Has project status=Active

}}

==Relevant Former Projects==

==Location==

My scripts for SDC pulls are located in the E drive in the location:

My successfully pulled and normalized files are stored in the location:

My scripts for loading tables and data are in:

There are a variety of SQL files in there with self explanatory names. The file that has all of the loading scripts is called LoadingScriptsV1. The folder vcdb2 is there for reference to see what people before had done. ExtractedData is there because I pulled data before July 1st, and Ed asked me to repull the data.

This is a slight detour from the creation of VCDB3. However, this is a cool process because you actually get to use the data you've been working with. This process is extensive, but the queries are easy to understand. If you wish to have deeper understanding of the process, read the code. It is located in:

First you must create a table that has aggregate round information grouped by cities and round year. Since this is a little difficult to picture, I will attach the code.

For states follow the same general process but group by states not cities and states.

==Master Tables==