[koolkid]

hello  below is my code

PHP Code


<?php 
import urllib.request
import json
##inp = input("enter website address : ")
##url= urllib.request.urlopen("http://freegeoip.net/json/{}".format(inp))
url= urllib.request.urlopen("http://data.gov.jm/api/action/datastore/search.json?resource_id=da5f0429-18ba-4d38-bd03-26171b81309c&limit=1")

data = json.loads(url.read().decode())
#print('IP : {}'.format(data['ip']))
print(data)
#print('Division : {}'.format(data['Clarendon']))
#print('Year : {}'.format(data[2007]))
#print('Fatalities : {}'.format(data['']))
#print(data["Division"])
if data[{"Division"}] == "Clarendon":
    print(data[{"Division"}])
    print(data[{"Fatalities"}])
     


i want to be able to search for specific data in this json api

[Anxuein]

You get a list of results from that JSON result with:

PHP Code


<?php 
data["result"]["records"] 


I assume there can be more than one result; however, to get the first result, you'd call it like such:

PHP Code


<?php 
data["result"]["records"][0] 


That will be a dictionary containing the following keys:

Code

Division
Fatal accidents
Fatalities
Year

If you want to loop through to find a specific division, you'd use something like this:

PHP Code


<?php 
for division in data["result"]["records"]:
    print(division["Division"])
    if division["Division"] == "whatever":
        # do stuff