search

iangow / wrds_pg

Code to get data from WRDS to PostgreSQL
46 stars 28 forks source link

Sort out legal tables (`audit`) #66

Closed iangow closed 10 months ago

iangow commented 10 months ago 
updated = wrds_update("feed13_legal_case_feed", "audit")
updated = wrds_update("feed14_company_legal_party_feed", "audit")
library(dplyr, warn.conflicts = FALSE)
library(DBI)
pg <- dbConnect(RPostgres::Postgres())

df <- tbl(pg, Id(table = "feed13_legal_case_feed", schema = "audit"))
df |> glimpse()

df <- tbl(pg, Id(table = "feed14_company_legal_party_feed", schema = "audit"))
df |> glimpse()