Changes

Jump to navigation Jump to search
*9) timing_combined - This table combines all timing information we have and appends tables 4, 7 and 8. 10) cohortcompanies_wtiming - merges data in tables cohortcompany and timing_combined
*See also, Grace's code E:/McNair/Projects/Accelerators/Summer 2018/format_timing.py. Last file it produced was TurkData2ndPush-FormattedTiming.txt
 
====Hira's code====
 
Load:
*timing_final from formatted_timing_final.txt -- 1167
*additional_timing_info from merging_work.txt --257
*additional_timing_info2 from additional_timing_info2.txt -- 1523
*'''timing_combined''' from all three above (additional_timing_info,timing_final,additional_timing_info2) -- 2817
*cohortsfinal from cohorts_final.txt from File to Rule Them All.xlx
*founders from founders_main.txt from File to Rule Them All.xlx
*founders_experience from founders_experience.txt from File to Rule Them All.xlx
Last code written by Ed was likely:
E:\mcnair\Projects\Accelerators\Summer 2018\FindTiming.sql
/*
timing_final
Demo manual fill out effort
--1167
additional_timing_info
SeedDB crawl
--257
additional_timing_info2
Main MTURK Crawl
--1523
*/
Timing related tables:
*Draws from timing_combined
*Produces FindThese and FindTheseCos
*\COPY TurkRun2 FROM 'TurkData2ndPush-FormattedTimingWHeader.txt' --1538
*\COPY ManualAdd2 FROM 'SmallBatchTimingInfo.txt' --169
====Best files with provenance:====
SmallBatchTimingInfo.txt

Navigation menu