India live monitoring

	A	B	C	D	E	F	G
1	id	name	latitude	longitude	stateID	live	pop (2011)
2	286	Patna	25.6	85.1	2	TRUE	1683200
3	342	Muzaffarpur	26.12	85.4	2	TRUE	351838
4	345	Gaya	24.75	85.01	2	TRUE	463454
5	11	Delhi	28.6587	77.19887	5	TRUE	11034555
6	13	Faridabad	28.4445	77.30958	6	TRUE	1404653
7	343	Panchkula	30.42208	76.51115	6	TRUE	211355
8	344	Gurgaon	30.70578	76.8532	6	TRUE	876824
9	348	Rohtak	28.8909	76.5796	6	TRUE	373133
10	298	Aurangabad	19.88	75.32	10	TRUE	1171330
11	299	Mumbai	18.97	72.82	10	TRUE	12442373
12	300	Nagpur	21.15	79.09	10	TRUE	2405665
13	301	Nashik	20	73.78	10	TRUE	1486973
14	302	Pune	18.52	73.85	10	TRUE	3124458
15	304	Thane	19.17	72.96	10	TRUE	1818872
16	305	Navi Mumbai	19.02	73.02	10	TRUE	1119477
17	341	Chandrapur	19.95	79.3	10	TRUE	321036
18	347	Solapur	17.68	75.92	10	TRUE	951118
19	310	Jaipur	26.9	75.8	18	TRUE	3046163
20	311	Jodhpur	26.28	73.02	18	TRUE	1033918
21	67	Agra	27.18979	78.03167	21	TRUE	1585704
22	73	Kanpur	26.46661	80.35277	21	TRUE	2765348
23	75	Lucknow	26.86892	80.9256	21	TRUE	2817105
24	83	Varanasi	25.3045	82.99329	21	TRUE	1201815
25	62	Chennai	13.067	80.267	20	TRUE	4646732
26	319	Kolkata	22.58	88.37	23	TRUE	4496694
27	320	Howrah	22.59	88.31	23	TRUE	1072161
28	346	Haldia	22.03	88.06	23	TRUE	200827
29	350	Durgapur	23.52	87.31	23	TRUE	566937
30	91	Ahmedabad	23.02579	72.58726	25	TRUE	5577940
31	284	Visakhapatnam	17.68	83.22	24	TRUE	2035922
32	349	Tirupati	13.67299	79.35122	24	TRUE	374260
33	92	Bengaluru	12.954	77.63094	26	TRUE	8443675
34	315	Hyderabad	17.37	78.48	29	TRUE	6731790
35		Total in LIVE cities					87837305
36		% of total population					7%
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100