id	state	st	city	latitude	longitude
1	Delaware	DE	Dover	39.161922	-75.526756
2	Pennsylvania	PA	Harrisburg	40.269791	-76.875610
3	New Jersey	NJ	Trenton	40.221741	-74.756142
4	Georgia	GA	Atlanta	33.759998	-84.389999
5	Connecticut	CT	Hartford	41.766998	-72.677002
6	Massachusetts	MA	Boston	42.235199	-71.027496
7	Maryland	MD	Annapolis	38.972946	-76.501160
8	South Carolina	SC	Columbia	34.000000	-81.035004
9	New Hampshire	NH	Concord	43.220093	-71.549126
10	Virginia	VA	Richmond	37.540001	-77.459999
11	New York	NY	Albany	42.659828	-73.781342
12	North Carolina	NC	Raleigh	35.771000	-78.638000
13	Rhode Island	RI	Providence	41.823551	-71.422134
14	Vermont	VT	Montpelier	44.266392	-72.571938
15	Kentucky	KY	Frankfort	38.197273	-84.863113
16	Tennessee	TN	Nashville	36.165001	-86.783997
17	Ohio	OH	Columbus	39.962246	-83.000648
18	Louisiana	LA	Baton Rouge	30.458090	-91.140228
19	Indiana	IN	Indianapolis	39.790943	-86.147682
20	Mississippi	MS	Jackson	32.320000	-90.207001
21	Illinois	IL	Springfield	39.783249	-89.650375
22	Alabama	AL	Montgomery	32.361538	-86.279121
23	Maine	ME	Augusta	44.323536	-69.765259
24	Missouri	MO	Jefferson City	38.572952	-92.189285
25	Arkansas	AR	Little Rock	34.736008	-92.331123
26	Michigan	MI	Lansing	42.733501	-84.546700
27	Florida	FL	Tallahassee	30.451799	-84.272774
28	Texas	TX	Austin	30.266666	-97.750000
29	Iowa	IA	Des Moines	41.590939	-93.620865
30	Wisconsin	WI	Madison	43.074722	-89.384445
31	California	CA	Sacramento	38.555607	-121.468925
32	Minnesota	MN	Saint Paul	44.950001	-93.094002
33	Oregon	OR	Salem	44.931110	-123.029160
34	Kansas	KS	Topeka	39.040001	-95.690002
35	West Virginia	WV	Charleston	38.349499	-81.633293
36	Nevada	NV	Carson City	39.160950	-119.753876
37	Nebraska	NE	Lincoln	40.809868	-96.675346
38	Colorado	CO	Denver	39.739166	-104.984169
39	North Dakota	ND	Bismarck	48.813343	-100.779007
40	South Dakota	SD	Pierre	44.367966	-100.336380
41	Montana	MT	Helena	46.595806	-112.027031
42	Washington	WA	Olympia	47.042419	-122.893074
43	Idaho	ID	Boise	43.613739	-116.237648
44	Wyoming	WY	Cheyenne	41.145550	-104.802040
45	Utah	UT	Salt Lake City	40.754700	-111.892624
46	Oklahoma	OK	Oklahoma City	35.482307	-97.534996
47	New Mexico	NM	Santa Fe	35.667233	-105.964577
48	Arizona	AZ	Phoenix	33.448456	-112.073845
49	Alaska	AK	Juneau	58.301933	-134.419739
50	Hawaii	HI	Honolulu	21.308950	-157.826187