Questions tagged [json]

JSON (JavaScript Object Notation) is a lightweight data-interchange format.

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

Import Json file to R issue [migrated]

I have been having an issue by importing a Json file into R. I try to import this file https://data.montpellier3m.fr/dataset/comptages-velo-et-pieton-issus-des-eco-compteurs/resource/1a6d90b6-6ba7-...
0
votes
1answer
48 views

Extracting data from OpenFDA using python to save it locally

I have been looking to extract all data from FDA so I can use it all. I created this code below that works but seems it is too much data it fails. This way it just gives me 25000 records. url = '...
1
vote
2answers
56 views

Where can I find a database with edible plants?

I'm building an web-application where users can add plants they want to grow in a list! So my user would type, for example Oregano, and using that keyword i should be able to collect info regarding ...
0
votes
0answers
23 views

Is there a webpage that provides a JSON or CSV or VCALENDAR file for Bitcoin price predictions?

Various people have made various Bitcoin price predictions, and continue to make them. There are webpages which talk about them in English text, but where is one which has it in a computer-parseable ...
1
vote
0answers
18 views

Is there such a thing as a generic English-language news headline feed in JSON or RSS format?

I'm trying to make a mechanism which basically tells me in a few keywords what currently is being pumped out in the major news. I could of course sit and try to determine which websites currently are ...
1
vote
0answers
10 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) ...
1
vote
0answers
8 views

Is there such a thing as a JSON blob which has categorized *numerous* sites in a meaningful way?

I have a huge list of URLs in a database table. From these, I am able to extract the "domain", such as "stackexchange.com" or "bbc.co.uk". I'd like to be able to get some ...
1
vote
1answer
30 views

Missing whitespace in label text values?

As context for this question, look at the response for NDA211172 (inotersen) from the label.json endpoint: https://api.fda.gov/drug/label.json?search=openfda.application_number.exact:NDA211172 I have ...
1
vote
0answers
40 views

earthquake usgs api filter by country

I am trying to get recent earthquake data using https://earthquake.usgs.gov/fdsnws/event/1/ api. For example this url (https://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=...
3
votes
2answers
79 views

What is an effective way to share many geojsons that are a timeseries?

I currently have a long-running scrape that collects geojson data for Zürich bike-sharing. Each file is appended with a timestamp of when it was collected. The file structure doesn't change. What's ...
1
vote
0answers
41 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 ...
3
votes
1answer
37 views

designing a vocabulary / ontology where classes have fixed constraints

Let's say that I have a class called "Event". Inside of this class there is a property called chanceOfSuccess which has the type QuantitativeValue. QuantitativeValue is a class that has min, max, and ...
1
vote
1answer
68 views

Unzipping the openfda data in R

I've downloaded all the url's for the different drug-event pairs, but they all end in .zip. Does anyone know how to automate pulling the .json file out of these zip files without doing it manually for ...
1
vote
1answer
78 views

Syntax error when the developer friendly name starts with a number

I’m having an issue with this line – obj.results[0][2017].admissions.sat_scores.25th_percentile.math It’s giving me a syntax error. I’m using Javascript and it seems to be having a problem with the ...
1
vote
1answer
33 views

Testing my code with NoSQL Telecom data

Where can I find data sets that can be used to test NoSQL databases? It's better if its applied towards the telecommunications industry. I have already tried using tabular data but i feel like it ...
3
votes
0answers
51 views

LD+JSON Use for SameAs Product

Assume you have an eCommerce site from which you sell some product. You also sell that product on Amazon. What would be the SEO implications of using the sameAs property in your eCommerce site's ld+...
2
votes
1answer
35 views

Free, Limitless GeoJSON APIs for nation shapes?

I am looking for some API endpoints that return GeoJSON shapes for each nation. I am not interested in downloading shapefiles. I need some lightweight (not super accurate) nation shapes for every ...
1
vote
1answer
96 views

Vocabulary alignment in LDflex

From https://ruben.verborgh.org/blog/2018/12/28/designing-a-linked-data-developer-experience/#ldflex-feeling: If you are dealing with a different type of data, you cannot use them. This is odd, ...
0
votes
1answer
438 views

KEEPA API Experience

I'm trying to pull historical prices and BSR from about 3,000 ASINs on Amazon, but need something built to interface with Keepa's API. Does anyone have any experience with this? If so, is there a ...
1
vote
1answer
35 views

Good easy to use api with a dataset for exam

I'm teaching a course in app development at bachelors level (3rd year college/university). Each year the students exam is to make an app which have some basic functionality and targets an open API. ...
1
vote
0answers
96 views

Where can I find Hebrew and Greek Bible texts interlined with Strong's numbers in plain text or JSON format?

Example in Hebrew: Gen 1:1  בראשׁיתH7225 בראH1254 אלהיםH430 אתH853 השׁמיםH8064 ואתH853 הארץ׃H776  Example in Greek: Mat 1:1  βιβλοςG976 γενεσεωςG1078 ιησουG2424 χριστουG5547 υιουG5207 δαβιδG1138 ...
6
votes
1answer
470 views

Searching by disease through openFDA API

I'm trying to query for all drugs related to a certain disease group (say, for example testicular cancer). How would I structure that query? is this possible?
1
vote
1answer
440 views

Dataset of World Cities, Counties, Localities, Provinces, and States? [duplicate]

I have a JSON list of international cities with country, latitude, longtitude, but not the corresponding state or province associated with them. Is there a free database of cities that include what I ...
2
votes
1answer
174 views

OPenFDA API - querying on dosage_and_administration_table _exists_ not working

I was planning to get the results where brand name is aspirin and whose drug result has property dosage_and_administration_table. So I did this https://api.fda.gov/drug/label.json?search=brand_name:...
2
votes
1answer
623 views

Is there a way to query openFDA for drug pair interaction?

openFDA is awesome particularly the drug/event database. But I can't find a way to query whether a particular drug (e.g. xanax) has any drug interaction warning, precaution, or contraindication. ...
5
votes
3answers
4k views

I get 'certificate verify failed' URLError when trying to download data from openFDA

I'm using Python and pandas to try to download the data in the FDA's 'Adverse drug event reports since 2004'. Here is my code: import pandas as pd import json from pandas.io.json import ...
1
vote
1answer
61 views

Getting drug register information through API

I am trying to find the drug registration info. Is there any FDA API available to gather drug register data set. Please suggest.
2
votes
0answers
27 views

Is there a vocabulary for linking machine data on the shopfloor?

I've got a gateway that reads machine data on the shopfloor, e.g. running hours notifications ("low oil pressure",...) temperatures inside machine The gateway should publish this data in JSON-LD. ...
3
votes
1answer
347 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&...
5
votes
1answer
127 views

Getting influences / influencedBy data from DBpedia

I am struggling with DBpedia. The description is unclear (to the point that for me it is hard to tell which data can be obtain, which - cannot), and (what is worst) it does not have many examples (...
2
votes
1answer
136 views

NDC's in Enforcement Reports - Package vs Product vs Product Description?

In queries such as this, for example, notice some results include a product_ndc and package_ndc, while others include a NDC in the product_description. Some include no NDC identifier in any field. ...
2
votes
1answer
58 views

Is there anyway to get the NDC code for a drug from the drug enforcement report fields?

Given the fields acquired from a drug enforcement report: country reason_for_recall classification recall_number recalling_firm initial_firm_notification code_info product_quantity event_id ...
4
votes
2answers
960 views

List of European countries and capitals with populations

I am searching a list of European countries and capitals with populations. This list must include the name of country with its population and area in square kilometer, the capital of country with its ...
5
votes
1answer
118 views

What should I think about when making JSON data into JSON-LD?

I've added a little more of my work to show how I'm thinking I hope this question isn't too broad. I'm thinking through a number of things and thought I'd try to put a "basic" question down here. I ...
5
votes
3answers
169 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 ...
2
votes
1answer
192 views

Variable/multidimensional json record structure OpenFDA

Arguably this is more a general programming question, and I should keep learning; yet, if advice or guidance is forthcoming I wanted to try asking: what is the best way to look for substances that ...
3
votes
1answer
374 views

Any uses of Hydra Core Vocabulary?

JSON-LD starts having a fairly large number of users. Hydra is a lightweight vocabulary to create hypermedia-driven Web APIs. Are there any significant sites or project that use Hydra with JSON-LD?
4
votes
1answer
475 views

Installing GeoJSON preview plugin on CKAN

I've managed to stand up a CKAN instance, and would now like to preview GeoJSON data in CKAN. According to the ckanext-spatial documentation, I don't need to install the full ckanext-spatial package, ...
1
vote
1answer
135 views

Most reusable way to publish a list as JSON

I have a list that I want to publish as JSON, so that others can easily reuse it: product1: price1 product2: price2 product3: price3 product4: price4 What is the most reusable way to publish this ...
5
votes
0answers
142 views

Planned Restful JSON apis for Healthcare Finder?

Are there any plans to provide a restful / json version of these apis? I realize that some of the urls contain the WORD rest (e.g. https://hiosgateway.cms.gov/RBIS-API/v11.0/REST/getSBCReportFile?...
2
votes
1answer
51 views

Drug time series produces unexpected results

I run two queries for the daily number of reports for bextra and avandia: https://api.fda.gov/drug/event.json?search=receivedate:[20050101+TO+20050430]+AND+brand_name:bextra&count=receivedate ...
3
votes
1answer
104 views

Is it possible to get the exact (particular) information from openFDA?

I am looking for just meta information from openFDA. Whenever I do a query I get all the information like meta, results. My requirement doesn't deal with results. We just care about metadata, because ...
2
votes
2answers
387 views

How do we relate Adverse Reactions and Drug in Open FDA?

I have been trying to relate adverse reaction to list of drugs in the Open FDA JSON but just can't manage to understand. Consider this JSON: "reaction": [ { "reactionmeddrapt": "...
2
votes
1answer
147 views

Is it the right query on what I am looking for in openFDA?

I have performed a query. I was planning to get the adverse report based on medicine name and age. So I did this https://api.fda.gov/drug/event.json?search=patient.drug.openfda.brand_name:advil+AND+...
3
votes
2answers
1k views

Looking for openFDA datasets which gives JSON data

I am looking for openFDA datasets for my current academic project. The project describes that a user enters medicine name and the result has to show me the information about the adverse events based ...
9
votes
6answers
2k views

What Linked Data serialization format to choose for our (now CSV) open data?

We have open data as a CSV file, about 200k lines, columns are mostly text. In order to make it into Linked Data and be easily reusable by as many mashups/apps/etc as possible, we want to propose ...
6
votes
4answers
364 views

Is there a vocabulary for linking weather data?

I've got a weather station and want to publish the data in JSON-LD. For the context file I'm searching for a vocubulary to express the weather data. Is there already a vocabulary or 'setup' for ...
9
votes
4answers
4k views

Any Open (Structured) Datasets for the World Factbook (Public Domain Country Profiles Published by the CIA)?

The World Factbook [1][2] published by the Central Intelligence Agency (CIA) offers 267 free country 'n' territories profiles (incl. flags 'n' overview and locator maps) in the public domain (that is, ...
8
votes
2answers
2k views

How to get all the DrugList

I want to fetch all the drugList, lets say -> DrugName, Manufacturer, Prescribed for, Description. I tried using https://api.fda.gov/drug/event.json?count=patient.drug.openfda.manufacturer_name.exact ...
4
votes
3answers
714 views

Data In CSV Format from OpenFDA

I read about data availability on http://open.fda.gov/ Now i want to download data in structured row-column format but all that i am getting is modifying my search query in order to retrieve ...