Tip #29: Filtering by Date Added in Scopus

By

This week's tip comes to us from Paije Wilson, MLIS Health Sciences Librarian at the Ebling Library. She credits the Systematic Reviews, Scoping Reviews, and other Knowledge Syntheses guide from McGill Library as the original source for the tip.

You can filter results in Scopus by date added to the database. I've found this handy when researchers want everything added to a database after or before a specific date, regardless of when the items were published.

ORIG-LOAD-DATE > [insert Unix time without brackets or year month day]

ORIG-LOAD-DATE < [insert Unix time without brackets or year month day]

For example, ORIG-LOAD-DATE > 1616907600 or ORIG-LOAD-DATE > 20210328 will retrieve items added to Scopus after March 28, 2021 (regardless of publication date). 


You can also AND a before and after filter together to get a date range. I've only seen this tip on a couple of pages, including this blog page (https://christinaslisrant.scientopia.org/2014/04/29/searching-scopus-by-date-added-to-the-database/) and McGill's libguide (https://libraryguides.mcgill.ca/knowledge-syntheses/updating).

That McGill guide has filters for load dates for other databases too!

Comments

Post a Comment

Popular posts from this blog

Tip #1: Bulk export from Google Scholar

By
Image
This post was updated on October 10, 2022 with new instructions for #3 under "For EndNote users..." For years, I kept hearing from colleagues that I should be searching Google Scholar as part of my systematic review projects. I didn't, for 3 reasons: I didn't know GS' search syntax GS notoriously does not allow bulk export to reference managers I didn't have a sense of how many results I should export.   Last fall, I finally said enough was enough and it was time to learn how to wrangle this beast. It turns out that there is now a third-party tool that facilitates bulk export from Google Scholar, Harzing's Publish or Perish . Here's how you get started: Download PoP for free Paste your query into the Keywords field Set your maximum number of results. I follow the guidelines on p. 135 of Wichor Bramer's dissertation , which is a great handbook for expert searching. Bramer suggests the first 200 results, or 100 if you are getting low numbers of res
Read more

Tip #46: Exporting Records from Clinicaltrials.gov into EndNote

By
Image
Many thanks to Ben Harnke, MLIS from the Strauss Health Sciences Library, University of Colorado (ben.harnke@cuanschutz.edu) for this week's tip!   Overview The following are instructions to export records from clincicaltrials.gov (Trials) to EndNote, with the ultimate goal of sending the records to a screening software, namely Covidence. The new Trials website ( https://www.clinicaltrials.gov /) will only export in JSON (Java Script format) and Comma Separated Values (CSV) formats. We will be using the CSV export format, the format for spreadsheets. These instructions are simply slight modifications to the Clarivate instructions for importing tab-delimited files (spreadsheets) into EndNote. Before proceeding with the following instructions, first decide whether it is necessary to export directly from clinicaltrials.gov to begin with. Cochrane CENTRAL contains records from Trials and is more user friendly. CENTRAL is limited to "randomized and quasi-randomized controlled tri
Read more

Favorite Features & Sneaky Solutions: A Database Tips Lightning Round: View the recording!

By
On October 7, 2024, the Medical Library Association's User Experience (UX) Caucus held a database tips lightning round. Watch the entire event recording! MLA UX Caucus Database Tips Lightning Round * (October 2024)  View presenter slide decks, the full chat transcript, and a summary of Q&A and tips culled from the chat: Lightning Round documents  (October 2024) The presenters and their topics, with timestamps of when they appear in the video, were: Methodology and Publication Type Filters in EBSCOhost Databases (00:40) Marilia Antunez, MA (LIS), MA,  Life & Allied Health Sciences Librarian, Associate Professor, The University of Akron (OH) Tricky Truncation in ProQuest Databases (07:15) Jocelyn Boice, Associate Professor / Collection Strategies and Data Analysis Librarian, Colorado State University Libraries Embase Query Translator (12:52) Molly Higgins, Systematic Review Librarian, USDA NESR What’s Included in Emtree’s /syn and /br (19:20) Amy Nadell, MSLIS, MA , AHIP-D, L
Read more