Questions tagged [json]
JSON (JavaScript Object Notation) is a lightweight data-interchange format.
57
questions
1
vote
0
answers
12
views
Data for multi-modal semantic search
Context: I am interested in the potential to use vector indexing and semantic search for multimodal data. For instance, a retail website may have unstructured text data from the advertising copy on ...
0
votes
0
answers
35
views
Different results from API based on range input, but database includes the data
When I am searching this API range 500-999, I get good results.
If I search 999 - 1010, I get good results.
If I search 1000-1100, I get 502 Bad Gateway nginx.
Similar results with average SAT scores.....
0
votes
0
answers
16
views
Collaboratively adding linked data?
I don't want to reinvent the wheel, are there any sites where you can actually link data collaborative.
Meaning: finding a picture online in an archive that doesn't have specific metadata, adding that ...
1
vote
1
answer
56
views
Linking data and making it available as linked data
I know some websites with photographs that have missing metadata. For example it could be missing location, missing event (WW1, WW2, …).
If I have a source URL: http://example.org/imgwithoutlocation....
0
votes
2
answers
56
views
What is the best way to convert a taxonomy from wikipedia into a JSON-like object?
I'm trying to use the Wikipedia academic fields as a JSON object in one of my projects. I couldn't find it in a useable or convertible format so I am looking into the best approach to obtain it.
I ...
0
votes
1
answer
221
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
2
answers
280
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 ...
1
vote
0
answers
23
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
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) ...
1
vote
0
answers
12
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
1
answer
36
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
0
answers
132
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
2
answers
81
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
0
answers
58
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
1
answer
42
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
1
answer
100
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
1
answer
88
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
1
answer
42
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
0
answers
83
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
1
answer
44
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
1
answer
102
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
1
answer
539
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
1
answer
43
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
0
answers
150
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
1
answer
517
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
1
answer
526
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
1
answer
193
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
1
answer
681
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
3
answers
5k
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
1
answer
64
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
0
answers
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
1
answer
378
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
1
answer
134
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
1
answer
137
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
1
answer
61
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
2
answers
1k
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
1
answer
124
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
3
answers
172
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
1
answer
207
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
1
answer
384
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
1
answer
511
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
1
answer
143
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
0
answers
147
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
1
answer
55
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
1
answer
110
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
2
answers
398
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
1
answer
157
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
2
answers
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
6
answers
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
4
answers
386
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 ...