waldoj

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

waldoj

waldoj

waldoj

#!/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.

waldoj

		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.

waldoj

waldoj

waldoj

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                                                                 

waldoj

# 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" : {

waldoj

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