Skip to content

Instantly share code, notes, and snippets.

View Chanch95's full-sized avatar

Chanchal Prajapati Chanch95

3 followers · 1 following
View GitHub Profile
@Chanch95
Chanch95 / airport.csv
Created August 23, 2018 11:04
We can't make this file beautiful and searchable because it's too large.
ID,Airport,City,Country,IATA,ICAO,Latitude,Longitude,Altitude,Timezone,DST,Tz,Type,Source
1,Goroka Airport,Goroka,Papua New Guinea,GKA,AYGA,-6.081689834590001,145.391998291,5282,10,U,Pacific/Port_Moresby,airport,OurAirports
2,Madang Airport,Madang,Papua New Guinea,MAG,AYMD,-5.20707988739,145.789001465,20,10,U,Pacific/Port_Moresby,airport,OurAirports
3,Mount Hagen Kagamuga Airport,Mount Hagen,Papua New Guinea,HGU,AYMH,-5.826789855957031,144.29600524902344,5388,10,U,Pacific/Port_Moresby,airport,OurAirports
4,Nadzab Airport,Nadzab,Papua New Guinea,LAE,AYNZ,-6.569803,146.725977,239,10,U,Pacific/Port_Moresby,airport,OurAirports
5,Port Moresby Jacksons International Airport,Port Moresby,Papua New Guinea,POM,AYPY,-9.443380355834961,147.22000122070312,146,10,U,Pacific/Port_Moresby,airport,OurAirports
6,Wewak International Airport,Wewak,Papua New Guinea,WWK,AYWK,-3.58383011818,143.669006348,19,10,U,Pacific/Port_Moresby,airport,OurAirports
7,Narsarsuaq Airport,Narssarssuaq,Greenland,UAK,BGBW,61.1604995728,-45.425998687
@Chanch95
Chanch95 / touristdest.csv
Created September 7, 2018 12:48
Rank City Country Tourists (Millions)
1 Hong Kong Hong Kong 23.7
2 Singapore Singapore 21.3
3 Bangkok Thailand 15.8
4 London UK 15.5
5 Macau Macau 13.4
6 Kuala Lumpur Malaysia 13.3
7 Shenzhen China 12.1
8 New York City USA 11.6
9 Antalya Turkey 10.3
@Chanch95
Chanch95 / touristxairportsorted.csv
Created September 7, 2018 12:48
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 13 columns, instead of 10 in line 8.
"","City","Rank","Tourists..Millions.","ID","Airport","Country.y","IATA","ICAO","Latitude","Longitude","Altitude","Timezone"
"55","Hong Kong",1,23.7,3077,"Chek Lap Kok International Airport","Hong Kong","HKG","VHHH",22.3089008331,113.915000916,28,"8"
"56","Hong Kong",1,23.7,4390,"Shun Tak Heliport","Hong Kong","\N","VHST",22.2893714905,114.152153015,107,"8"
"150","Singapore",2,21.3,3316,"Singapore Changi Airport","Singapore","SIN","WSSS",1.35019,103.994003,22,"8"
"151","Singapore",2,21.3,3315,"Seletar Airport","Singapore","XSP","WSSL",1.4169499874115,103.86799621582,36,"8"
"152","Singapore",2,21.3,12004,"Changi Air Base (East)","Singapore","\N","WSAC",1.3441400528,104.009002686,22,"\N"
"11","Bangkok",3,15.8,3157,"Don Mueang International Airport","Thailand","DMK","VTBD",13.9125995636,100.607002258,9,"7"
"12","Bangkok",3,15.8,3885,"Suvarnabhumi Airport","Thailand","BKK","VTBS",13.6810998916626,100.747001647949,5,"7"
"82","London",4,15.5,8410,"London-Corbin Airport/Magee Field","United States","LOZ","KLOZ",37.0
@Chanch95
Chanch95 / countofairportsincitiessorted.csv
Created September 7, 2018 12:53
City freq
1 44
3271 London 9
1247 Columbus 7
1944 Georgetown 7
5046 San Jose 7
129 Alexandria 6
2060 Greenville 6
2323 Houston 6
3815 Moscow 6
@Chanch95
Chanch95 / countofairportsinpopularcitiessorted.csv
Created September 7, 2018 12:53
City freq
46 London 9
56 Moscow 6
70 Rome 5
39 Johannesburg 4
43 Las Vegas 4
49 Madrid 4
52 Melbourne 4
63 Paris 4
81 Toronto 4
@Chanch95
Chanch95 / worldtourismarrival.csv
Created September 11, 2018 11:59
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 27 columns, instead of 19 in line 4.
"","X...Country.Name","Country.Code","Indicator.Name","Indicator.Code","X1995","X1996","X1997","X1998","X1999","X2000","X2001","X2002","X2003","X2004","X2005","X2006","X2007","X2008","X2009","X2010","X2011","X2012","X2013","X2014","X2015","X2016"
"1","Aruba","ABW","International tourism, number of arrivals","ST.INT.ARVL",619000,641000,650000,647000,683000,721000,691000,643000,642000,728000,733000,694000,772000,827000,813000,824000,869000,904000,979000,1072000,1225000,1102000
"2","Afghanistan","AFG","International tourism, number of arrivals","ST.INT.ARVL",NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA
"3","Angola","AGO","International tourism, number of arrivals","ST.INT.ARVL",9000,21000,45000,52000,45000,51000,67000,91000,107000,194000,210000,121000,195000,294000,366000,425000,481000,528000,650000,595000,592000,397000
"4","Albania","ALB","International tourism, number of arrivals","ST.INT.ARVL",304000,287000,119000,184000,371000,317000,354000,470000,557000,645000,748000,937000,1062000,1247
@Chanch95
Chanch95 / routes.csv
Created September 12, 2018 15:02
We can't make this file beautiful and searchable because it's too large.
Airline,Airline ID,Source Airport,Source Airport ID,Destination Airport,Destination Airport ID,Codeshare,Stops,Equipment
2B,410,AER,2965,KZN,2990,,0,CR2
2B,410,ASF,2966,KZN,2990,,0,CR2
2B,410,ASF,2966,MRV,2962,,0,CR2
2B,410,CEK,2968,KZN,2990,,0,CR2
2B,410,CEK,2968,OVB,4078,,0,CR2
2B,410,DME,4029,KZN,2990,,0,CR2
2B,410,DME,4029,NBC,6969,,0,CR2
2B,410,DME,4029,TGK,\N,,0,CR2
2B,410,DME,4029,UUA,6160,,0,CR2
@Chanch95
Chanch95 / countofairportsinpopularcitiessorted.json
Created September 12, 2018 15:04
[
{
"": 46,
"City": "London",
"freq": 9
},
{
"": 56,
"City": "Moscow",
"freq": 6
@Chanch95
Chanch95 / countofairportsincitiessorted.json
Created September 12, 2018 15:05
[
{
"": 3271,
"City": "London",
"freq": 9
},
{
"": 1247,
"City": "Columbus",
"freq": 7