Questions tagged [csv]

Comma Separated Values (CSV) are a common interchange format for tabular data.

Filter by
Sorted by
Tagged with
0 votes
0 answers
8 views

2020 FBI Hate Crime Tables?

I'm sure most of us are familiar with the data the FBI provides. A while back the FBI "released" the 2020 data, but it's missing from their website. If you go to the link https://ucr.fbi.gov/...
user avatar
0 votes
0 answers
13 views

Shapefile for Petrol Fueling stations across Europe

I'm looking for petrol stations across Europe either in a shapefile format, coordinate data as .csv or addresses from a webpage which I can scrape. I have had a look and couldn't find anything that ...
user avatar
0 votes
0 answers
12 views

How to open a zip folder's metadata as .CSV?

I'm working with a less than great reporting platform. Certain users of our system were expected to upload a certain document by a specific date. If they had not, they were sent a reminder. We are ...
user avatar
1 vote
1 answer
150 views

Time zones and country ISO codes

I am looking for a simple CSV with the list of country names, country ISO codes, city, time zone UTC and DST... It seems simple, but I am struggling to find it. Any advice/help would be very much ...
user avatar
  • 111
0 votes
0 answers
19 views

Is there a corpus of toy datasets specifically designed for finding bugs in data science software?

I'm looking for a corpus of toy tabular datasets that can be used to test data profiling, machine learning, data manipulation, etc. software. Some example attributes: Strange column names (empty ...
user avatar
0 votes
1 answer
20 views

CO2 dataset from Scripps is broken. How can in inform the owner?

I'm using the daily CO2 measurement dataset from the Scripps CO2 Program Data page: https://scrippsco2.ucsd.edu/data/atmospheric_co2/mlo.html Direct link to daily dataset: https://scrippsco2.ucsd.edu/...
user avatar
  • 17.1k
1 vote
0 answers
14 views

Where can I get a JSON or CSV file with the average Bitcoin USD value for each day since it was announced? [duplicate]

I've just spent several days downloading and loading in what turned out to be 10+ GB of garbage data. All I wanted was to know the current USD (average) market value for each day (not minute/hour) ...
user avatar
4 votes
2 answers
743 views

Is it possible to download worldometer COVID-19 country data?

I want to download the raw data for COVID-19 cases in Sweden but can't find anywhere on worldometer to do it. Does anyone know how to download the data as a csv file?
user avatar
  • 141
2 votes
0 answers
23 views

Is there such a thing as a public, curated list of people who WANT to be e-mailed?

I've always wanted to be able to send e-mails to a lot of people, for example to announce something. However, there are ultra-strict rules for this and basically, you destroy your "reputation" if you ...
user avatar
1 vote
0 answers
51 views

Where can accurate information on the release dates of all video game consoles, peripherals and games were released be grabbed?

I've long wanted to compile a private "timeline" consisting of various video game consoles, peripherals and games which I want to remember and quickly be able to look up when they were released. I ...
user avatar
1 vote
0 answers
25 views

Medical dataset for creating questionares (in csv/rdf formats so that I can import them into Neo4J directly)

I want to create a graph database of medical information in the form of entity nodes connected by relations and was wondering if any csv datasets existed that would allow me to directly import the ...
user avatar
1 vote
0 answers
30 views

Davis-Bacon wage dataset

Is anyone aware of a method or source for exporting Davis-Bacon wage information as a csv dataset? https://www.wdol.gov/archdba.aspx Assuming you have a particular DBA WD number you are interested ...
user avatar
2 votes
1 answer
721 views

Get list of all villages/towns in India

This might have been asked before but I couldn't get a similar question. I am working on an application which will have addresses in India populated using dropdowns till 4 levels. State => ...
user avatar
1 vote
0 answers
24 views

Obesity/Inactivity Data at a census tract level

Looking for obesity/inactivity data for adults at a census tract level for the state of California. Any good sources? Preferably in a format that can be uploaded to arcdesktop.
user avatar
1 vote
0 answers
18 views

Pain levels using GSR and heart rate measurements

I am looking for dataset(s) that classifies the GSR (skin conductivity) / heart rate readings to emotions and pain levels for machine learning purposes.
user avatar
1 vote
1 answer
48 views

How can I flter data from a stream of very large text files?

I have a stream of data being delivered to my Amazon S3 bucket in the form of tab-delimited text. I would like to scan as it comes in to keep a very small subset of the rows from that match certain ...
user avatar
  • 111
2 votes
1 answer
216 views

Sensor data trains dataset

For an experiment I'm looking for a particular type of data set, been looking for quite a while but couldn't find any data sets which even remotely match this description. Are there any good datasets ...
user avatar
  • 23
3 votes
2 answers
74 views

Is there a set of data points available to draw an outline of the coast of the British Isles?

I would like to plot a map of the coastline of the British Isles using gnuplot, for which I need a data set of points along the coast. Is this available in csv form, please, or help to convert it to ...
user avatar
8 votes
3 answers
3k views

Trying to link ZIP code to core-based statistical area

I have a dataset downloaded from the IRS reporting AGI by ZIP code (link: irs.gov). However, I'm interested in tying each ZIP code to statistical areas (whether it's [a] primary statistical area, [b] ...
user avatar
  • 101
1 vote
0 answers
52 views

How can I deploy a sci-kit learn model when the data in use are .csv files?

I am dealing with accelerometer data (csv) as well as audio data stored in FTP server coming from an android app. Data is loaded from FTP in my notebook for exploratory analysis to extract features ...
user avatar
3 votes
0 answers
41 views

The W3C's tabular-data-model is de facto in use?

In nowadays (2016) what standard is a de facto standard for CSV file metadata,   W3C's tabular-data-model or OKFN's tabular-data-package? NOTES Important to remember: these metadata standards (W3C ...
user avatar
4 votes
2 answers
3k 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 ...
user avatar
  • 145
1 vote
1 answer
2k views

Postal codes of China

Where can I find geodata with postal codes of China with an open license (commercial use is allowed)? It may be shp, csv, kml. any geodata.
user avatar
3 votes
1 answer
368 views

College Scorecard API call returns all data in .json but only two fields in .csv

I'm trying to pull debt data from College Scorecard for Texas institutions using the following call: https://api.data.gov/ed/collegescorecard/v1/schools.csv?school.state_fips=48&_page=0&...
user avatar
  • 31
6 votes
1 answer
2k views

Looking for open source LGBT datasets

I have been looking for any general datasets about LGBT Americans. The type of file I look for are either CSV or TSV. Although my inquiry will hopefully yield some spatial indices at the county or ...
user avatar
2 votes
2 answers
53 views

cattle and sheep production and reproduction records

I am looking for some records (spread sheets) that I can use for teaching/analysis. I am specifically looking for dairy/beef cattle and sheep/goat farm production and reproduction records. Appreciate ...
user avatar
3 votes
2 answers
771 views

Grouped vocabulary list as .txt or .csv files

I'm working on a project with email data.And simply i need to group up all the emails according to suitable categories. Therefore, i use the dictionary mapping method. So, My project required lots ...
user avatar
  • 281
4 votes
3 answers
6k views

Looking for sample lat/long data of thousands of US addresses

In order to test some mapping and geocoding functionality, I'm looking for a free data source containing a few thousand US addresses, including latitude and longitude. I need them distributed among a ...
user avatar
  • 181
6 votes
1 answer
363 views

Finding tables in messy structured Excel / csv file to import them in DB

we have a lot of messy structured excel files containing tables somewhere on a sheet and we want to import these tables into a database to do some analytic on it. There problem is that we don't have ...
user avatar
  • 61
3 votes
1 answer
221 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 ...
user avatar
5 votes
3 answers
171 views

Water level historical data for California

I am looking for data attesting for the variation of fresh water availability in California over the years (ideally 20+ years). For instance river levels, river throughput, wells levels. If data is ...
user avatar
6 votes
1 answer
350 views

Mapping CSV Header to RDF + SPARQL console

I would like to know your opinion about the next system: with a large CSV file convert it's header to RDF schema, in which exists only the CSV columns information and access point. This way there's ...
user avatar
  • 63
8 votes
2 answers
516 views

What needs to be done to be 4 or 5-star open data?

I work at a University which is trying to open up some of its data. We make some of our data available as PDF or Excel documents. The 5-star deployment scheme has been referenced a fair bit in Europe ...
user avatar
12 votes
3 answers
3k views

Where can I download photoperiod (daylength) data?

I'm looking to download photoperiod (day length) data for a variety of locations in Europe on a variety of dates. For each date and locations, I need to the number of hours of daylight. Ideally, the ...
user avatar
  • 311
6 votes
1 answer
80 views

DOL Wage and Hour data: Counting backwages under Fair Labor Standards Act

I have a question about the Wage and Hour Compliance Action Data of the Department of Labor's Wage and Hour division: http://prd-enforce-xfr-02.dol.gov/data_catalog/WHD/whd_whisard_20141105.csv.zip ...
user avatar
4 votes
4 answers
750 views

Applying filters to headers in a huge CSV file

I am working with a CSV file that is approximately 500 MB. When I open this file in Excel, the wrong data is displayed under the column headers. I suspect this may be due to the large size of the CSV ...
user avatar
  • 141
5 votes
1 answer
224 views

"DBpedia as Tables" not having all the properties

I browsed a sample for available data at http://dbpedia.org/page/Sachin_Tendulkar. I wanted these properties as columns, so I downloaded the CSV files from http://wiki.dbpedia.org/DBpediaAsTables. ...
user avatar
3 votes
1 answer
203 views

A DB of banks for each country

I'm looking for a free database of banks (preferably with their web sites, phone numbers, etc) for each country in a convenient format, not html. Is there any?
user avatar
  • 401
4 votes
1 answer
41 views

Which licence and format should I use for the Norwegian language "data" I am creating?

While learning a foreign language, I am creating my own list of verbs (with their variants when conjugated), list of idioms, nouns (with plural form), etc. As an example, let's focus on the verbs: I ...
user avatar
  • 143
12 votes
2 answers
324 views

Where to upload open data? (no online data editing needed)

I have CSV and RDF files that I would like to upload somewhere so that everyone can download them. What is the most appropriate website for this? I need at least: Easily upload, just select the ...
user avatar
4 votes
2 answers
138 views

Wiki site for data tables

Recently I participated in a digital humanities hackathon where we created programs for automatic handling of texts. For example, one program involved automatic detection of Biblical phrases in modern ...
user avatar
91 votes
21 answers
171k views

How can I work with a 4GB csv file?

What's the best way to access a 4GB csv file? I would like get a 'cut' of this open data set: Full Replacement Monthly NPI File, available here http://nppes.viva-it.com/NPI_Files.html Specifically, ...
user avatar
  • 929
13 votes
5 answers
370 views

How to publish open data on my website? (Or: from CSV to RDFa)

I already spent some time importing data in a tabular form from a PDF published by an official institution. I would like to publish this table on my website. The data is nicely formatted in CSV. Is ...
user avatar
  • 231
19 votes
7 answers
816 views

Keeping track of updates to open data published as CSV

I looked through several related questions here (e.g. Tools for merging similar datasets continuously) but nothing seemed to quite answer my question. So, apologies in advance if I missed something. ...
user avatar
29 votes
12 answers
3k views

Metadata standards and best practices for data dictionaries for CSV files/data

We publish most of our machine-readable open data in CSV format. What are best practices and/or standards to publish data dictionaries (e.g. definitions of columns in CSV files including human-...
user avatar