Questions tagged [sql]

For questions related to SQL databases.

Filter by
Sorted by
Tagged with
1
vote
0answers
14 views

I am looking for an API that can provide all medicines that are sold in Pakistan. I have seen that chemists have a such kind of database?

I am looking for an API that can provide all the medicines that are sold in Pakistan. I have seen that chemists have a such kind of database. What are some pointers?
1
vote
0answers
61 views

correct way to add columns for all mlb player salaries, heights, weights since 2008 to merged MLBAM atbats_pitches table using MySQL

I am desperately looking to add columns for salary, height and weight to a merged MLBAM atbats and pitches table for all pitchers and batters using MySQL. I did locate salaries information from the ...
2
votes
2answers
164 views

Merging Pitchf/x tables Correctly

I need all the pitches and who threw them. I have downloaded the data into a sqlite db using the PitchRx library in R. All the pitch data is stored in a table called "pitch" and the pitcher name and ...
2
votes
0answers
56 views

Bulk processing XBRL into MySQL

I am working on a project involving processing a large volume of XBRL documents (> 1m separate files). I am totally new to XBRL and feeling quite lost at the moment, only downloaded Arelle 20 minutes ...
3
votes
1answer
2k views

Master Song Database containing popular titles and artists

I'm looking for a song database (sqlite, csv, etc.) Right now I'm searching through a list of songs from late 60s and early 70s on "http://www.song-database.com/" but I'm searching manually on the ...
6
votes
0answers
721 views

Any open public data sets for the Rugby World Cup (in England 2015)?

The Ruby World Cup 2015 kicked off in England on Sep/18 and runs until Oct/31. Wondering what's the state of open data for Rugby. Any open data sets available (incl. teams, players, squads, stadiums, ...
7
votes
2answers
210 views

Where can I publish small database for free?

Is there any site where one can easily publish a small database (<5MB)? Ideally, the data should be published in a way that it could be sql selected by number of parameters. Just like any national ...
3
votes
1answer
203 views

Australia Hotel/Motel Data

I am wondering if there is anyone here that either has 2013-2015 list of hotels in Australia with contact phone numbers and if it had emails that would be a bonus. I am currently putting an excel ...
5
votes
0answers
816 views

How to get a list of all strengths & forms for a drug from RxNorm?

RxNorm is a database of drugs put out by the U.S. National Library of Medicine. I've pulled the RxNorm data into a Postgres database using some of the supplied MySQL scripts and some code that I wrote ...
3
votes
2answers
880 views

SQL queries dataset

I am looking for a dataset containing natural language sentences (English preferred) and their corresponding SQL queries. E.g. "What are the names of the employees who live in Los Angeles" could be ...
1
vote
0answers
406 views

How to get XBRL into MySQL database?

I am trying to retrieve SEC filings in XBRL and dump them into MySQL. Anyone know how to do this or who I can hire to do it?
3
votes
1answer
682 views

where can I find gov datasets (from data.gov, bea etc) in MySQL format?

Is there a place where I can find gov datasets (from data.gov, bea etc) in MySQL format? - free or paid. I could download and parse the files of course, but wanted to check if it is already available ...
2
votes
1answer
48 views

I'm looking for an Oracle Express Edition 11g testing database

I am looking for a testing database that contains random tables full of random data where I can do my test. I just began studying Oracle express edition 11g, I am using Oracle SQL developer under ...
7
votes
2answers
2k views

Enron Email Dataset in MySQL

For the purpose of my research, I need the Enron Email Dataset. According to the project's official web-site, there is an archive of emails represented in the set of separate TXT-files, but the ...
1
vote
2answers
1k views

Parse Wiktionary Data Dump XML Into MySQL Database

I'm just trying to parse Wiktionary Data Dump provided by Wikimedia. My intention is to parse that XML data dump into MySQL database. I didn't find proper documentation regarding the structure of this ...
5
votes
1answer
175 views

Scraper for Openstreetmap: all south-american schools to mysql-db

I have seen the python scraper described here. Well this is very interesting. I am not a programmer and therefore some of the techniques and ideas of scrapers are too complicated for me. But it ...
1
vote
1answer
82 views

Fatality Analysis Reporting System

The National Highway Traffic Safety Administration has a database of fatal crashes called Fatality Analysis Reporting System (FARS) http://www.nhtsa.gov/FARS One can download each years data going ...
4
votes
1answer
186 views

What is the best tool for doing explorative analysis of databases?

We are looking for a tool that plugs into a database (SQL) and help us query and visualize results dynamically, building monitoring dashboards and dynamic queries. Any good tool out there?
4
votes
2answers
335 views

Open Product Data sources and importing into SQL

I'm trying to import the .sql file from Open Product Data, the POD Database Dump. The site recommends to use BigDump, but when I try to run the php script from BigDump in my localhost, I'm getting ...
10
votes
4answers
7k views

Where can I download those bible verses in JSON or XML or SQL formatted file?

I need to make a site that has Chinese bible verses as well as English bible verses. Where can I download those in MySQL, XML or JSON format? Can I download them for free? I need NIV version and 和合本 ...
6
votes
2answers
3k views

Wikipedia dump files in SQL format

I need to access to history of each wiki page. I found http://dumps.wikimedia.org/fawiki/latest/fawiki-latest-pages-meta-history.xml.7z contains such data for Persian wiki in XML format. But I want ...