![dealscan database manual dealscan database manual](https://image.slidesharecdn.com/8c514fcb-0ced-4e1c-9359-49d0a26b9471-161027035944/95/dashboard-and-database-manual-for-afg-4-638.jpg)
see the documentation and manuals page available via WRDS. dta files with original industry classifications, with translated, most recent classifications, with two fitted Herfindahl Index variables, and a description. Many of the following financial databases are available via the web-based interface of WRDS. Census and BLS data compiled by Jan Keil first presented in "Jan Keil, The Trouble with Approximating Industry Concentration from Compustat, Journal of Corporate Finance, 2017". Browse products, examine datasets and metadata and download and. Please reference to the original sources that hold the copy rights, my website and the publication in which I used the file first. We identify non-bank lenders based on information provided by DealScan, in combination with Standard Industrial Classification codes, string search and manual. View and subscribe to our enterprise datasets at, a web-based Linked Data Platform powered by Hypermedia API. Raw data are not readily usable for a quantitative analysis and must be either collected by hand, requested, or scraped from websites. Files are assembled from raw data that can be freely obtained by the respective U.S. Department of Commerce and Bureau of Labor Statistics (for additional sales, payroll and employee variables). The latter requires a paid subscription.Ĭontent: Concentration ratios, Herfindahl Index, number of establishments for manufacturing and non-manufacturing U.S. Lender names, information on lenders and loans must be obtained from the FDIC, the FED, and DealScan. Files contain only companyid, rssd and FDIC/FED flag variables.
![dealscan database manual dealscan database manual](https://files.ninoxdb.de/5a15530614b52a56c69f943a.png)
ĭownload: A technical documentation, and CSV files linking DealScan lenders and ultimate parents. Referencing: Augmentations to the DealScan-Compustat Link are obtained from Jan Keil's website first presented in "Jan Keil, Do Relationship Lenders Manage Loans Differently?, Working Paper, 2018". 10 For example, PwC UK has prepared their own in-house database of real estate.
Dealscan database manual plus#
Files can be linked with this table using the variables RSSD (the FDIC and FED identifier), companyid or ultimateparentid (the DealScan identifiers), plus the year variable for all files involved.Ĭoverage: 93% or 652,772 of 701,435 of all lender-facility observations in which DealScan loans were issued by U.S. Cambridge Crystallographic Data Centre Cambridge University Press Cambridgesoft Corporation CCH Center for Governmental Studies Center for Homeland. CAB International Cabell Publishing, Inc.
Dealscan database manual manual#
Manual input Custom interface Vendor-supplied interface I / 6. /rebates/&252fdealscan-database-manual. Bureau van Dijk Business Monitor International Ltd. You can select items from your product database and automatically include price and. Content: 44,224 links between RSSD lender identifier-years from FDIC (Federal Deposit Insurance Corporation) or FED/NIC (Federal Reserve Bank/National Information Center) databases and companyid lender identifier-years from the Thomson Reuters DealScan Facilities file. Brepols Publishers Brill BuildingGreen, Inc.