Python: Searching for a data in JSON

Question

How to extract data of specific district (e.g. Nicobars, North and Middle Andaman...) from https://api.covid19india.org/state_district_wise.json I need to extract Active just by searching for the district name. Right now I'm extracting it this way:

url='https://api.covid19india.org/state_district_wise.json'
r = urllib.request.urlopen(url)
data = r.read().decode()
js=json.loads(data)
print('Confirmed cases:', js[State_name]['districtData']["District_name"]['confirmed'])

I don't want to specify state name every time.

You should edit the question to be more clear on what you want to do. — LhasaDad
– LhasaDad, Commented Sep 13, 2020 at 21:45

stilManiac · Accepted Answer · 2020-09-13 22:08:20Z

2

url= 'https://api.covid19india.org/state_district_wise.json'  
r = urllib.request.urlopen(url)  
data = r.read().decode()  
js = json.loads(data)  

district = "Prakasam" 

for state, value in js.items():  
    if not district in value['districtData'].keys(): 
        continue 
      
    value = value['districtData'][district] 

    print(f"State: {state}") 
    print(f"* District: {district}")  
    print(f"** Active: {value['active']}")  
    print(f"** Confirmed: {value['confirmed']}")

edited Sep 13, 2020 at 22:08

answered Sep 13, 2020 at 21:42

stilManiac

4643 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sumukh Jadhav Over a year ago

This is returning all the district values, I want to search for a specific district by its name

Sumukh Jadhav Over a year ago

This works. If you don't mind can you explain what's actually happening here, I didn't understand

stilManiac Over a year ago

I just iterate through json keys (states, then districts) and skip districts that don’t match ‘district’ variable’s value

Collectives™ on Stack Overflow

Python: Searching for a data in JSON

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related