get_proquest.RdThis function loads data on PhD graduates or their advisors
from ProQuest. It is based on metadata from ProQuest,
and automatically adds the likely gender of the person,
using define_gender, and for graduates, their
field using define_field.
get_proquest(conn, from, start_year = 1985, end_year = 2005, ...)An object of class SQLiteConnection to a sqlite database.
A string with options to be queried: "advisors" or "graduates".
Lowest graduation year to consider. Default: 1985.
Highest graduation year to consider. Default: 2005.
Additional arguments to be passed to
make_tbl_output.
If not specified, a lazily evaluated table without limit is returned.
Partially specified arguments are completed with
dots_tbl_output.
For graduates, returns a table with degree year, university id, fieldname and gender. For advisors, returns a table with gender and relationship id.
For simplicity, does not return the degree year and university information to
advisors. You can add this information to advisors by joining the
output of get_proquest(from = "graduates") to the output of
get_proquest(from = "advisors").
conn <- connect_to_db(db_example("AcademicGraph.sqlite"))
#> The database connection is:
#> src: sqlite 3.38.5 [/tmp/RtmptPxKJr/temp_libpath72cc939d74f39/magutils/extdata/AcademicGraph.sqlite]
#> tbls: AuthorAffiliation, FieldsOfStudy, FirstNamesGender, author_coauthor,
#> author_output, current_links, current_links_advisors, pq_advisors,
#> pq_authors, pq_fields_mag, pq_unis
d_graduates <- get_proquest(conn = conn, from = "graduates")
d_advisors <- get_proquest(conn = conn, from = "advisors")