Skip to content

Repository for downloading, processing, and analyzing FDA Adverse Event Reporting System data.

Notifications You must be signed in to change notification settings

mlbernauer/FAERS

Repository files navigation

FAERS

This repository contains files setting up an FAERS Postgres database

Create postgres database faers

sudo -u postgres createdb faers postgres

Create schema

sudo -u postgres psql faers < create-tables.sql

Download FAERS files

The file 2016-faers-files.txt contains URLs for the 2016 FAERS files (Q1-Q4). Note: if you would like to use another set of files you should make sure they are compatable with the 2016 schema files list in create-tables.sql

./download-faers-data.sh 2016-faers-files.txt

Load data into tables

The required FAERS archive files should be located within ./data. We are now ready to load data into the faers database

./load-data.sh

Create indices

sudo -u postgres psql faers < create-indices.sql

About

Repository for downloading, processing, and analyzing FDA Adverse Event Reporting System data.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages