Code for Science and Society logo
Home News Welcome OpenRefine!

Welcome OpenRefine!

O:28:"craft\elements\db\AssetQuery":96:{s:27:"�yii\base\Component�_events";a:0:{}s:35:"�yii\base\Component�_eventWildcards";a:0:{}s:30:"�yii\base\Component�_behaviors";a:1:{s:12:"customFields";O:35:"craft\behaviors\CustomFieldBehavior":112:{s:5:"owner";r:1;s:34:"�yii\base\Behavior�_attachedEvents";a:0:{}s:10:"hasMethods";b:1;s:16:"canSetProperties";b:1;s:15:"personFirstName";N;s:14:"personLastName";N;s:5:"image";N;s:11:"personTitle";N;s:14:"contentBuilder";N;s:4:"text";N;s:11:"attribution";N;s:6:"people";N;s:10:"groupTitle";N;s:13:"relatedPeople";N;s:15:"relatedProjects";N;s:11:"relatedNews";N;s:8:"heroText";N;s:6:"teaser";N;s:13:"featuredImage";N;s:11:"postContent";N;s:6:"alumni";N;s:4:"logo";N;s:7:"website";N;s:11:"affiliation";N;s:7:"project";N;s:15:"applicationLink";N;s:16:"shortDescription";N;s:19:"applicationDeadline";N;s:10:"employment";N;s:15:"nonprofitStatus";N;s:13:"callsToAction";N;s:11:"description";N;s:7:"endDate";N;s:7:"endTime";N;s:14:"relatedProgram";N;s:9:"startDate";N;s:9:"startTime";N;s:8:"ctaTitle";N;s:7:"ctaLink";N;s:14:"ctaDescription";N;s:8:"timeZone";N;s:4:"tags";N;s:7:"context";N;s:11:"peopleGroup";N;s:9:"groupName";N;s:5:"users";N;s:4:"body";N;s:6:"header";N;s:7:"buttons";N;s:10:"buttonLink";N;s:5:"style";N;s:14:"quickLinkItems";N;s:8:"itemLink";N;s:15:"quickLinksTitle";N;s:17:"quickLinksDisplay";N;s:10:"visibility";N;s:9:"linkField";N;s:13:"featuredEvent";N;s:12:"featuredPost";N;s:12:"contributors";N;s:11:"grantAmount";N;s:8:"richText";N;s:3:"bio";N;s:4:"news";N;s:8:"projects";N;s:4:"jobs";N;s:6:"events";N;s:9:"resources";N;s:7:"caption";N;s:14:"mailingAddress";N;s:7:"twitter";N;s:12:"contactEmail";N;s:3:"ein";N;s:7:"userOrg";N;s:9:"loginText";N;s:8:"grantees";N;s:10:"fileGroups";N;s:18:"sectionDescription";N;s:12:"sectionTitle";N;s:5:"files";N;s:5:"width";N;s:12:"resourceType";N;s:12:"accessDenied";N;s:8:"noAccess";N;s:8:"linkedin";N;s:6:"github";N;s:17:"incubatorProjects";N;s:9:"listItems";N;s:14:"sectionContent";N;s:13:"headerContent";N;s:4:"year";N;s:13:"passwordReset";N;s:19:"restrictedResources";N;s:11:"headerStyle";N;s:5:"embed";N;s:14:"seoDescription";N;s:8:"seoImage";N;s:14:"analyticsEmbed";N;s:17:"programLogoSquare";N;s:19:"newsletterEmbedCode";N;s:11:"seoSettings";N;s:9:"shareLink";N;s:12:"feedbackLink";N;s:15:"feedbackFormUrl";N;s:26:"resourceFeedbackButtonText";N;s:16:"noUpcomingEvents";N;s:14:"personPronouns";N;s:17:"expiredJobWarning";N;s:10:"eventStart";N;s:8:"eventEnd";N;s:11:"maintainers";N;s:55:"�craft\behaviors\CustomFieldBehavior�_customFieldValues";a:0:{}}}s:6:"select";a:1:{s:2:"**";s:2:"**";}s:12:"selectOption";N;s:8:"distinct";b:0;s:4:"from";N;s:7:"groupBy";N;s:4:"join";a:1:{i:0;a:3:{i:0;s:10:"INNER JOIN";i:1;a:1:{s:9:"relations";s:14:"{{%relations}}";}i:2;a:4:{i:0;s:3:"and";i:1;s:40:"[[relations.targetId]] = [[elements.id]]";i:2;a:2:{s:18:"relations.sourceId";i:848;s:17:"relations.fieldId";i:3;}i:3;a:3:{i:0;s:2:"or";i:1;a:1:{s:22:"relations.sourceSiteId";N;}i:2;a:1:{s:22:"relations.sourceSiteId";i:1;}}}}}s:6:"having";N;s:5:"union";N;s:11:"withQueries";N;s:6:"params";a:0:{}s:18:"queryCacheDuration";N;s:20:"queryCacheDependency";N;s:5:"where";N;s:5:"limit";N;s:6:"offset";N;s:7:"orderBy";a:1:{s:19:"relations.sortOrder";i:4;}s:7:"indexBy";N;s:16:"emulateExecution";b:0;s:11:"elementType";s:20:"craft\elements\Asset";s:5:"query";N;s:8:"subQuery";N;s:12:"contentTable";s:12:"{{%content}}";s:12:"customFields";N;s:9:"inReverse";b:0;s:7:"asArray";b:0;s:18:"ignorePlaceholders";b:0;s:6:"drafts";b:0;s:17:"provisionalDrafts";b:0;s:7:"draftId";N;s:7:"draftOf";N;s:12:"draftCreator";N;s:15:"savedDraftsOnly";b:0;s:9:"revisions";b:0;s:10:"revisionId";N;s:10:"revisionOf";N;s:15:"revisionCreator";N;s:2:"id";N;s:3:"uid";N;s:14:"siteSettingsId";N;s:10:"fixedOrder";b:0;s:6:"status";a:1:{i:0;s:7:"enabled";}s:8:"archived";b:0;s:7:"trashed";b:0;s:11:"dateCreated";N;s:11:"dateUpdated";N;s:6:"siteId";i:4;s:6:"unique";b:0;s:11:"preferSites";N;s:6:"leaves";b:0;s:9:"relatedTo";N;s:5:"title";N;s:4:"slug";N;s:3:"uri";N;s:6:"search";N;s:3:"ref";N;s:4:"with";N;s:13:"withStructure";N;s:11:"structureId";N;s:5:"level";N;s:14:"hasDescendants";N;s:10:"ancestorOf";N;s:12:"ancestorDist";N;s:12:"descendantOf";N;s:14:"descendantDist";N;s:9:"siblingOf";N;s:13:"prevSiblingOf";N;s:13:"nextSiblingOf";N;s:16:"positionedBefore";N;s:15:"positionedAfter";N;s:17:"�*�defaultOrderBy";a:1:{s:20:"elements.dateCreated";i:3;}s:53:"�craft\elements\db\ElementQuery�_placeholderCondition";N;s:51:"�craft\elements\db\ElementQuery�_placeholderSiteIds";N;s:39:"�craft\elements\db\ElementQuery�_result";N;s:47:"�craft\elements\db\ElementQuery�_resultCriteria";N;s:46:"�craft\elements\db\ElementQuery�_searchResults";N;s:42:"�craft\elements\db\ElementQuery�_cacheTags";N;s:42:"�craft\elements\db\ElementQuery�_columnMap";a:0:{}s:51:"�craft\elements\db\ElementQuery�_joinedElementTable";b:0;s:8:"editable";N;s:7:"savable";N;s:8:"volumeId";N;s:8:"folderId";N;s:10:"uploaderId";N;s:8:"filename";N;s:4:"kind";N;s:6:"hasAlt";b:1;s:5:"width";N;s:6:"height";N;s:4:"size";N;s:12:"dateModified";N;s:17:"includeSubfolders";b:0;s:10:"folderPath";N;s:14:"withTransforms";N;}
Jessica Hardwicke on Jan 29, 2020

CS&S is proud to welcome OpenRefine to our Sponsored Projects Program! CS&S will be working with OpenRefine, supported by a recent $200k grant, to grow the community and revamp the core architecture (and they are looking for feedback in how to best accomplish this).

OpenRefine is a “powerful tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data”. Used by scientists, journalists, and librarians to wrangle messy data, OpenRefine will support the mission of CS&S to improve the public's ability to use and understand data.

OpenRefine is one of the most mature and widely used data cleaning and wrangling tools available. Originally known as Freebase Gridworks, the tool was designed primarily to support the Freebase database and community. Since then, they have grown to support a broader community and be a key part of the work of anyone trying to understand messy data. You can learn more about the OpenRefine community from their 2018 community survey. They recently received a WikidataCon 2019 Award in the Editing category. OpenRefine has been used to perform millions of Wikidata edits, either directly from OpenRefine or via QuickStatements.

OpenRefine is looking for new feedback on their 2020 user survey, if you already use this tool please fill it out and share!

OpenRefine contributor & Lead Dev on the EOSS grant, Antonin at the WikiTechStorm 2019. By Mx Lucy - Own work, CC BY-SA 4.0


We are pleased to announce that the Chan Zuckerberg Initiative (CZI) has awarded OpenRefine a $200,000 grant to fund its development in 2020. This award is part of CZI’s Essential Open Source Software for Science program which awarded $5 million to over 40 projects.

This grant will be used to achieve two main objectives:

  • Grow the community of OpenRefine contributors by reaching out to seasoned users and helping them get involved more closely in the project.
  • Revamp the core architecture of the tool to handle larger datasets and improve workflows.

CS&S’ Sponsored Projects Program supports open source, public interest technology projects through financial administration and assisting project teams with practical and strategic support. OpenRefine — as an open source data tool with a large user community across science, civic tech, libraries, and other public interest spaces — fits CS&S’ mission to advance collaboration and open data. We look forward to supporting OpenRefine in 2020!

Code for Science & Society is proud to welcome OpenRefine to our Sponsored Projects Program!