Open Records Requests
City of Austin
@usgov.city_of_austin_open_records_requests
City of Austin
@usgov.city_of_austin_open_records_requests
CREATE TABLE table_1 (
"id" BIGINT,
"month" VARCHAR,
"year" BIGINT,
"agency_name" VARCHAR,
"numagencypublications" BIGINT,
"numbudgetinformation" BIGINT,
"numcontractinformation" BIGINT,
"numexpendituresrevenues" BIGINT,
"numfinancialinformation" BIGINT,
"numpoliciesprocedures" BIGINT,
"numpendinglitigation" BIGINT,
"numclosedlitigation" BIGINT,
"numagendas" BIGINT,
"numminutes" BIGINT,
"numvotingrecords" BIGINT,
"numpermitapplications" BIGINT,
"numpersonnelinformation" BIGINT,
"numpurchaseorders" BIGINT,
"numregulatoryinformation" BIGINT,
"numrules" BIGINT,
"numstudentinformation" BIGINT,
"numstatisticalinformation" BIGINT,
"numadministrativerulings" BIGINT,
"numpolicereports" BIGINT,
"numcriminalinvestigations" BIGINT,
"numrightofaccess" BIGINT,
"descother1" VARCHAR,
"numother1" BIGINT,
"descother2" VARCHAR,
"numother2" BIGINT,
"descother3" VARCHAR,
"numother3" BIGINT,
"descother4" VARCHAR,
"numother4" BIGINT,
"descother5" VARCHAR,
"numother5" BIGINT,
"descother6" VARCHAR,
"numother6" BIGINT,
"descother7" VARCHAR,
"numother7" BIGINT,
"descother8" VARCHAR,
"numother8" BIGINT,
"descother9" VARCHAR,
"numother9" BIGINT,
"descother10" VARCHAR,
"numother10" BIGINT,
"descother11" VARCHAR,
"numother11" BIGINT,
"descother12" VARCHAR,
"numother12" BIGINT,
"descother13" VARCHAR,
"numother13" BIGINT,
"descother14" VARCHAR,
"numother14" BIGINT,
"descother15" VARCHAR,
"numother15" BIGINT,
"numreferattgen" BIGINT,
"numestrequestruling" DOUBLE,
"numestmanexception" DOUBLE,
"agychargeopenrecs" VARCHAR,
"chargeestablished" VARCHAR,
"chargestatute" VARCHAR,
"moniesreceived" DOUBLE,
"nonwebcapitalcost" DOUBLE,
"webcapitalcost" DOUBLE,
"nonwebpersonnelcost" DOUBLE,
"webpersonnelcost" DOUBLE,
"costfactors" VARCHAR,
"trainingprovided" VARCHAR,
"websitecontactinfo" VARCHAR,
"websitepolicies" VARCHAR,
"status" VARCHAR,
"reportdate" VARCHAR
);
Anyone who has the link will be able to view this.