I am looking for location data of USA in SQL/CSV format
Here is the structure for a data
1. State with abbreviation (New York, NY)
2. County
3. City
4. Zip code with latitude & longitude
Hi,
I have this data for all zip codes in USA (around 43000 zip codes). Below you can see a sample:
Zip City State State Code County latitude longitude
35902 Gadsden Alabama AL Etowah 33.9841 -85.8034
35903 Gadsden Alabama AL Etowah 33.9845 -85.9077
35904 Gadsden Alabama AL Etowah 34.0217 -86.0495
35905 Gadsden Alabama AL Etowah 33.9352 -85.9576
35907 Gadsden Alabama AL Etowah 33.8979 -86.0245
35999 Gadsden Alabama AL Etowah County 34.0138 -86.0084
36540 Gainestown Alabama AL Clarke 31.4258 -87.6822
35464 Gainesville Alabama AL Sumter 32.7783 -88.1457
35972 Gallant Alabama AL Etowah 33.9976 -86.2346
36742 Gallion Alabama AL Hale 32.5298 -87.6985
36038 Gantt Alabama AL Covington 31.2609 -86.4448
35070 Garden City Alabama AL Cullman 34.0058 -86.7499
35071 Gardendale Alabama AL Jefferson 33.7189 -86.8225
35973 Gaylesville Alabama AL Cherokee 34.3573 -85.5589
36340 Geneva Alabama AL Geneva 31.0414 -85.8847
36033 Georgiana Alabama AL Butler 31.6287 -86.734
35974 Geraldine Alabama AL DeKalb 34.3592 -86.024
I can deliver you the data now if you award me the job.
Regards,
Sedat
can do your job.
These are my skills related to web scraping and crawling
Have done scraping in CasperJS Phantomjs, python.
Have done testing and automation with selenium also.
Know to deal with database like mongo, mysql, Elasticsearch.
Also know to handle proxy and captcha while scrapping.
Experienced project professional, US based, MBA, EXCEL and MS Project expert; also experienced with proposal writing, technical training documents and English instruction.
I have this data in EXCEL and can transfer to CSV file format quicky
Hi there,
I have read the your project brief named - "Location data of USA in SQL" and I am interested to work on this project. Are you available to discuss on chat now?
Please consider my bid and take a look at my portfolio and reviews:
https://www.freelancer.com/u/envisionops
Kindly contact me to discuss further.
Best regards,
Sujal
Hi
I am a analyst and data mining expert with 5+ years of experience. I have worked on various projects for my organization. As a freelancer I have worked for local schools to prepare their automated attendance sheet and account book management and for small scale business for there inventory management and stock up gradation process. I have extensive knowledge in advance excel and ms word. I can also transfer workbooks/spreadsheets to different file formats.
I am dedicated to my work and always maintain accuracy and productivity for my clients
I am always available to discuss about the project so feel free to contact me anytime.
Will be looking forward to working with you.