Skip to content

Instantly share code, notes, and snippets.

View planemad's full-sized avatar

Arun Ganesh planemad

View GitHub Profile
@planemad
planemad / assembly_constituencies.csv
Last active March 18, 2024 15:42
CSV list of parliament and assembly constituencies of India as on March 2024. Source: https://lgdirectory.gov.in/ and https://ramseraph.github.io/opendata/lgd/
S.No. State Code State Name Parliament Constituency Code Parliament Constituency Name Assembly Constituency Code Assembly Constituency Name
1 35 Andaman And Nicobar Islands 543 Andaman & Nicobar Islands
2 28 Andhra Pradesh 411 Amalapuram 3166 Amalapuram
3 28 Andhra Pradesh 411 Amalapuram 3167 Gannavaram
4 28 Andhra Pradesh 411 Amalapuram 3168 Kothapeta
5 28 Andhra Pradesh 411 Amalapuram 3169 Mandapeta
6 28 Andhra Pradesh 411 Amalapuram 3170 Mummidivaram
7 28 Andhra Pradesh 411 Amalapuram 3171 Ramachandrapuram
8 28 Andhra Pradesh 411 Amalapuram 3172 Razole
9 28 Andhra Pradesh 412 Anakapalle 3173 Anakapalle
@planemad
planemad / goa.geojson
Created August 11, 2023 17:26
State boundary of Goa. License: ODbL OpensStreetMap project
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@planemad
planemad / india-covid-containment-zone-district-20200501.csv
Last active July 31, 2023 14:25
Classification of districts in India by COVID containment zones as on 1 May 2020.
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 10 columns, instead of 6. in line 8.
"District ID","District Name","State","Classification","District Code","District Name(In English)","State Code","State Name (In English)","Census 2001 Code","Census 2011 Code"
"2","Nicobars","Andaman And Nicobar lslands","Green Zone","603","NICOBARS","35","ANDAMAN AND NICOBAR ISLANDS","02","638"
"3","North And Middle Andaman","Andaman And Nicobar lslands","Green Zone","632","NORTH AND MIDDLE ANDAMAN","35","ANDAMAN AND NICOBAR ISLANDS","","639"
"1","South Andamans","Andaman And Nicobar lslands","Red Zone","602","SOUTH ANDAMANS","35","ANDAMAN AND NICOBAR ISLANDS","01","640"
"11","Anantapur","Andhra Pradesh","Orange Zone","502","ANANTAPUR","28","ANDHRA PRADESH","22","553"
"7","Chittoor","Andhra Pradesh","Red Zone","503","CHITTOOR","28","ANDHRA PRADESH","23","554"
"13","East Godavari","Andhra Pradesh","Orange Zone","505","EAST GODAVARI","28","ANDHRA PRADESH","14","545"
"5","Guntur","Andhra Pradesh","Red Zone","506","GUNTUR","28","ANDHRA PRADESH","17","548"
"6","Krishna","Andhra Pradesh","Red Zone","510","KRISHNA"
@planemad
planemad / india_airports_osm.tsv
Last active April 7, 2023 18:20
Location and codes of all airports in India from OpenStreetMap. Generated from Overpass API https://overpass-turbo.eu/s/1tu9
@type @id name alt_name old_name aerodrome:type operator iata icao wikidata @lat @lon
node 245642465 Warangal Airport WGC Q7968794 17.9140552 79.6036086
node 245652501 Jeypore PYB VEJP Q12693189 18.8812875 82.5527680
node 245759577 Dibrugarh Mohanbari Airport military/public DIB VEMN Q1657723 27.4854679 95.0170764
node 410592085 Car Nicobar Air Force Station military Indian Air Force CBD VOCX Q2172548 9.1562250 92.8215167
node 678810688 Jindal Vijaynagar Airport Vidyanagar Airport VDY VOJV 15.1751365 76.6332705
node 697276907 Hasimara Air Force Station military VE44 26.7018159 89.3664783
node 746951085 Sookerating Airfield 27.5515210 95.5728029
node 746952719 Chabua Air Force Station VECA 27.4630047 95.1143134
node 747077944 Ondwa Airport VA1H 25.1427315 74.6119255
{"id": "M51R", "stop_timings": [{"stop": "BROADWAY", "timings": ["09:10", "17:40"]}, {"stop": "CEMENT ROAD", "timings": ["05:15", "13:35"]}, {"stop": "KILKATTALAI", "timings": ["05:50", "10:30", "12:30", "14:15", "16:15", "20:50"]}, {"stop": "PUZHUTHIVAKKAM", "timings": ["07:40", "19:10"]}, {"stop": "THIAGARAYA NAGAR", "timings": ["06:45", "11:30", "15:15", "19:55"]}]}
{"id": "57H", "stop_timings": [{"stop": "BROADWAY", "timings": ["06:30", "10:00", "12:40", "21:25"]}, {"stop": "KOYAMBEDU MARKET", "timings": ["20:45"]}, {"stop": "NEW ERUMAIVETTIPALAYAM", "timings": ["04:45", "07:00", "08:20", "09:00", "11:00", "14:25", "14:45", "17:15", "18:10", "19:10", "19:50"]}, {"stop": "PADIYANALLUR", "timings": ["06:03", "13:43"]}, {"stop": "REDHILLS", "timings": ["06:10", "08:00", "10:00", "11:02", "13:50", "18:20", "19:00", "21:32"]}, {"stop": "VALLALAR NAGAR", "timings": ["15:50", "16:20"]}]}
{"id": "S36", "stop_timings": [{"stop": "D.M.S. METRO", "timings": ["06:35", "07:00", "07:25", "07:50", "08:25", "08:50", "09:
{"id": "556", "stops": [{"stop_id": "1", "stop_name": "THIRUVOTRIYUR"}, {"stop_id": "2", "stop_name": "ERNAVOOR GATE"}, {"stop_id": "3", "stop_name": "SATHIYAMOORTHY NAGAR"}, {"stop_id": "4", "stop_name": "JN.,OF PONNERI RD,&ERANOOR"}, {"stop_id": "5", "stop_name": "ANDARKUPPAM"}, {"stop_id": "6", "stop_name": "ECHANKUZHI"}, {"stop_id": "7", "stop_name": "NAPALAYAM"}, {"stop_id": "8", "stop_name": "KONDAKKARAI"}, {"stop_id": "9", "stop_name": "PATTAMANDIRI"}, {"stop_id": "10", "stop_name": "INDIA CEMENT"}, {"stop_id": "11", "stop_name": "ATHIPATTU PUDU NAGAR"}, {"stop_id": "12", "stop_name": "ATHIPEDU CAMP ROAD"}, {"stop_id": "13", "stop_name": "ENNORE E.B. MAIN GATE"}, {"stop_id": "14", "stop_name": "ENNORE THERMAL POWER"}, {"stop_id": "15", "stop_name": "ENNORE PORT MAIN GATE"}, {"stop_id": "16", "stop_name": "BACK WATER BRIDGE"}, {"stop_id": "17", "stop_name": "L&T HARBOUR"}, {"stop_id": "18", "stop_name": "KATTUPALLIVILLA"}, {"stop_id": "19", "stop_name": "L&T CORNER"}, {"stop_id": "20", "stop_name": "KAT
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
{
"map": {
"title": "Sample title"
},
"version": "v1"
}
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 31 columns, instead of 7. in line 2.
data_id,iso,event_id_cnty,event_id_no_cnty,event_date,year,time_precision,event_type,sub_event_type,actor1,assoc_actor_1,inter1,actor2,assoc_actor_2,inter2,interaction,region,country,admin1,admin2,admin3,location,latitude,longitude,geo_precision,source,source_scale,notes,fatalities,timestamp,iso3
8656762,356,IND102916,102916,"18 November 2021",2021,1,"Explosions/Remote violence","Remote explosive/landmine/IED","Unidentified Armed Group (India)",,3,,,0,30,"South Asia",India,Manipur,"Imphal East",Porompat,Heingang,24.8375,93.9492,2,"Sentinel (India); Assam Tribune; South Asia Terrorism Portal; E-Pao",Other-Subnational,"On 18 November 2021, unidentified assailants exploded an improvised explosive device (IED) in front of a shop, damaging a portion of the steel shutter of the shop at Kairang Muslim Mayai Leikai under Heingang police station (Porompat, Imphal East district, Manipur). No militant group claimed responsibility for the explosion.",0,1637706301,IND
8656857,356,IND102863,102863,"18 November 2021",2021,1
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.