Questions tagged [json]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
15 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
14 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
73 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
12 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
34 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 ...
0
votes
1answer
47 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
46 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
30 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
34 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
30 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
87 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
382 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
33 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
70 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 ...
5
votes
1answer
371 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
367 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
135 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
560 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
3k 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
22 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
325 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
126 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
54 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
915 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
117 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
165 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
180 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
349 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
427 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
134 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
141 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
95 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
363 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": "...
1
vote
1answer
132 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
992 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 ...
8
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
336 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 ...
8
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
607 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 ...
10
votes
4answers
8k 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 和合本 ...
22
votes
10answers
7k views

Wikipedia table to JSON (or other machine-readable format)

I'm interested in the data listed in the tables listed here. Is there a good way to extract the information (as JSON, preferably) without resorting to HTML parsing?
21
votes
9answers
4k views

Any uses of JSON-LD?

The formal semantic web, now linked data, using RDF is largely flailing in most regions outside the UK. The main problem is the complexity in implementation compared with the tools typically used by ...
25
votes
8answers
8k views

How can I download the complete Wikidata database?

Wikidata is a new Wikimedia project: It centralizes access to and management of structured data, such as interwiki references and statistical information. This data would be of enormous interest ...