We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 16 columns, instead of 1 in line 5.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
LoanRange,BusinessName,Address,City,State,Zip,NAICSCode,BusinessType,RaceEthnicity,Gender,Veteran,NonProfit,JobsRetained,DateApproved,Lender,CD | |
b $2-5 million,"ACCOUNTING RESEARCH & ANALYTICS, LLC DBA CFRA",d/b/a CFRA 675 PETER JEFFERSON PKWY STE 100,CHARLOTTESVILLE,VA,22911,,Limited Liability Company(LLC),Unanswered,Unanswered,Unanswered,,25,05/01/2020,"JPMorgan Chase Bank, National Association",VA - 05 | |
b $2-5 million,APEX CLEAN ENERGY INC,"310 4th Street NE, suite 300",CHARLOTTESVILLE,VA,22902,541620,Subchapter S Corporation,White,Male Owned,Unanswered,,0,04/08/2020,Virginia National Bank,VA - 05 | |
b $2-5 million,COMMONWEALTH COMPUTER RESEARCH INC,1422 Sachem Pl Unit 1,CHARLOTTESVILLE,VA,22901,541511,Corporation,Unanswered,Male Owned,Unanswered,,135,04/09/2020,"Bank of America, National Association",VA - 05 | |
b $2-5 million,DESIGN ELECTRIC INC,1307 Carlton Avenue,CHARLOTTESVILLE,VA,22902,238210,Employee Stock Ownership Plan(ESOP),White,Male Owned,Unanswered,,0,04/07/2020,Virginia National Bank,VA - 05 | |
b $2 |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name | gnis | |
---|---|---|
Frederick County, Virginia | 1480124 | |
Madison County, Virginia | 1494590 | |
Culpeper County, Virginia | 1497831 | |
Augusta County, Virginia | 1480098 | |
Bath County, Virginia | 1673638 | |
Rockbridge County, Virginia | 1480166 | |
Alleghany County, Virginia | 1673675 | |
Amherst County, Virginia | 1480095 | |
Lee County, Virginia | 1496538 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# Inspired by: | |
# http://nialldonegan.me/2007/03/10/converting-microsoft-access-mdb-into-csv-or-mysql-in-linux/ | |
# http://cltb.ojuba.org/en/articles/mdb2sqlite.html | |
# https://gist.github.com/umrysh/4291298 | |
# Dave's Modifications: | |
# Line 29: Added code to remove COMMENT and SET statements. | |
# Lines 32 to 41: Added code to handle primary keys. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Phacking: A Brief History of Hacking the US Postal System | |
By Alien Time Agent, Seraf and Waldo | |
Phacking (postal hacking, pronounced PAH-king) has enjoyed a glorious but | |
obscure history in the United States, beginning with the godfather of phacking, | |
Samuel Osgood. It wasn't until the summer of 1969 that Zip C0de brought | |
phacking into the public eye. While he was only 20 years of age at the time, he | |
had already caught the attention of authorities. For Zip C0de, C-Note, PhedEx and the | |
other brave pioneers, here is a brief history of hacking the US postal system. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name | type | value | |
---|---|---|---|
1920160443.gosappsa | CNAME | domains.live.com | |
23bn-vdf | CNAME | 23bn-vdf.vhost.vipnet.org | |
23bn.vdf | CNAME | 23bn-vdf.vhost.vipnet.org | |
abcweb.abc | CNAME | gin.abc.virginia.gov | |
admanage-t.dmv | CNAME | dmv-pwr01-t.dmv.virginia.gov | |
admanage.dmv | CNAME | dmv-pwr01-p.dmv.virginia.gov | |
adms.vdot | CNAME | www27.vdot.virginia.gov | |
applyonline.abc | CNAME | gin.abc.virginia.gov | |
autodiscover.house | CNAME | autodiscover.outlook.com |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Industry | # of Businesses | |
---|---|---|
Agricultural Cooperatives | 137 | |
Animal and Children's Welfare | 66 | |
Architects | 563 | |
Arts and Sciences | 23 | |
Audiologist | 4 | |
Bank & Insurance Agent | 73 | |
Banks and Credit Unions | 474 | |
Bank w/Limited Certificate | 32 | |
Benefit Corporations | 48 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
020369964COLONIAL POINT CIVIC LEAGUE, INC. 00200903200000000019910117VA001420 FLINTFIELD CRESCENT CHESAPEAKE VA23321000000000000CLARINE B. ROBERTS 1420 Flintfield Crescent Chesapeake VA233210000199101171236N00000000000 0 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | |
020712928BARGER INC 10201101030000000020090819VA00 00000000000000000BARBARA J IFKO |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Remove old data | |
curl -XDELETE "http://localhost:9200/shapes" | |
curl -XDELETE "http://localhost:9200/businesses" | |
# Create shapes index, with mapping | |
curl -XPOST "http://localhost:9200/shapes/" -d ' | |
{ | |
"shapes" : { | |
"mappings" : { | |
"municipalities" : { |
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 15 columns, instead of 1 in line 6.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
id,name,incorporation_date,street_1,street_2,city,state,zip,agent_name,agent_street_1,agent_street_2,agent_city,agent_state,agent_zip,agent_status | |
0773356,"WHITE SPOT INCORPORATED",2014-01-14,"1407 UNIVERSITY AVENUE",,CHARLOTTESVILLE,VA,22903,"DIMITRIOS WHITE SP TAVAMPIS","1407 UNIVERSITY AVENUE",,CHARLOTTESVILLE,VA,22903,DIRECTOR | |
F197333,"Mission Secure, Inc.",2014-08-29,"250 W MAIN ST STE 300",,CHARLOTTESVILLE,VA,22902,"DANIEL PARK","941 GLENWOOD STATION LANE","SUITE 302",ARLINGTON,VA,22901,OFFICER | |
F195959,"EXPEDITION TRUST COMPANY",2014-04-14,"310 4TH ST NE STE 102",,CHARLOTTESVILLE,VA,22902,"JACOB A LUTZ III","1001 HAXALL POINT 15TH FL","PO BOX 1122",RICHMOND,VA,23219,ATTORNEY | |
0780498,"NJW Properties, Inc.",2014-07-23,"120 BOLLINGWOOD ROAD",,CHARLOTTESVILLE,VA,22903,"NORMAN JEFFREY WOOLWORTH","120 BOLLINGWOOD ROAD",,CHARLOTTESVILLE,VA,22903,DIRECTOR | |
0774667,"Nitor, Inc.",2014-02-18,"1111 LOCUST AVENUE",,CHARLOTTESVILLE,VA,22901,"CRAIG W. MOORE","1111 LOCUST AVENUE",,CHARLOTTESVILLE,VA,22901,DIRECTOR | |
S4850 |
NewerOlder