Skip to content

Instantly share code, notes, and snippets.

@kinlane

kinlane/federalagencies.sql

Created April 26, 2013 08:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save kinlane/5465794 to your computer and use it in GitHub Desktop.
Save kinlane/5465794 to your computer and use it in GitHub Desktop.
Download ZIP
This is the table structure for the Federal digital strategy project.
Raw
federalagencies.sql
DROP TABLE IF EXISTS `federalagencies`;
CREATE TABLE `federalagencies` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`agency_id` varchar(150) DEFAULT NULL,
`agency_name` varchar(500) DEFAULT NULL,
`agency_url` varchar(500) DEFAULT NULL,
`digital_strategy_html_url` varchar(1500) DEFAULT NULL,
`digital_strategy_json_url` varchar(1500) DEFAULT NULL,
`digital_strategy_xml_url` varchar(1500) DEFAULT NULL,
`data_count` int(10) unsigned DEFAULT '0',
`mobile_count` int(10) unsigned DEFAULT '0',
`twitter_count` int(10) unsigned DEFAULT '0',
`facebook_count` int(10) unsigned DEFAULT '0',
`github_count` int(10) unsigned DEFAULT '0',
`twitter_follower_count` int(10) unsigned DEFAULT '0',
`facebook_friend_count` int(10) unsigned DEFAULT '0',
`github_repository_count` int(10) unsigned DEFAULT '0',
`description` text,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3384 DEFAULT CHARSET=latin1;
INSERT INTO `federalagencies` (`ID`,`agency_id`,`agency_name`,`agency_url`,`digital_strategy_html_url`,`digital_strategy_json_url`,`digital_strategy_xml_url`,`data_count`,`mobile_count`,`twitter_count`,`facebook_count`,`github_count`,`twitter_follower_count`,`facebook_friend_count`,`github_repository_count`,`description`) VALUES
(3138,'acf','Administration for Children and Families (ACF)','http://www.acf.hhs.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'The Administration for Children and Families (ACF) is a division of the United States Department of Health and Human Services (HHS). It is headed by the Assistant Secretary for Children and Families. It has a $58.8 billion budget for 65 programs that target children, youth and families.[1] These programs include assistance with welfare, child support enforcement, adoption assistance, foster care, child care, and child abuse.'),
(3139,'aoa','Administration on Aging (AOA)','http://www.aoa.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3140,'acus','Administrative Conference of the United States (ACUS)','http://www.acus.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3141,'uscourts','Administrative Office of the U.S. Courts','http://www.uscourts.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3142,'achp','Advisory Council on Historic Preservation (ACHP)','http://www.achp.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3143,'adf','African Development Foundation (ADF)','http://www.adf.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3144,'ahrq','Agency for Healthcare Research and Quality (AHRQ)','http://www.ahrq.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3145,'ams','Agricultural Marketing Service (AMS)','http://www.ams.usda.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3146,'ars','Agricultural Research Service (ARS)','http://www.ars.usda.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3147,'ttb','Alcohol and Tobacco Tax and Trade Bureau (TTB)','http://www.ttb.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3148,'amtrak','AMTRAK (National Railroad Passenger Corporation)','http://www.amtrak.com',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3149,'aphis','Animal and Plant Health Inspection Service (APHIS)','http://www.aphis.usda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3150,'capitol','Architect of the Capitol (AOC)','http://www.aoc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3151,'bbg','Broadcasting Board of Governors, International Broadcasting Bureau (BBG)','http://www.bbg.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3152,'atf','Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF)','http://www.atf.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3153,'bea','Bureau of Economic Analysis (BEA)','http://www.bea.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3154,'bep','Bureau of Engraving and Printing (BEP)','http://www.moneyfactory.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3155,'bia','Bureau of Indian Affairs (BIA)','http://www.bia.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3156,'bis','Bureau of Industry and Security (BIS)','http://www.bis.doc.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3157,'ilab','Bureau of International Labor Affairs (ILAB)','http://www.dol.gov/ilab/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3158,'bls','Bureau of Labor Statistics (BLS)','http://www.bls.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3159,'blm','Bureau of Land Management (BLM)','http://www.blm.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3160,'boem','Bureau of Ocean Energy Management (BOEM)','http://www.boem.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3161,'reclamation','Bureau of Reclamation','http://www.usbr.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3162,'bsee','Bureau of Safety and Environmental Enforcement (BSEE)','http://www.bsee.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3163,'census','Bureau of the Census','http://www.census.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3164,'publicdebt','Bureau of the Public Debt','http://www.publicdebt.treas.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3165,'bts','Bureau of Transportation Statistics (BTS)','http://www.bts.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3166,'cfbnp','Center for Faith-Based and Neighborhood Partnerships (CFBNP)','http://www.dol.gov/cfbnp/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3167,'cnpp','Center for Nutrition Policy and Promotion (CNPP)','http://www.cnpp.usda.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3168,'cdc','Centers for Disease Control and Prevention (CDC)','http://www.cdc.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3169,'cms','Centers for Medicare and Medicaid Services (CMS)','http://www.cms.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3170,'cia','Central Intelligence Agency (CIA)','http://www.cia.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3171,'usccr','Commission on Civil Rights (USCCR)','http://www.usccr.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3172,'cftc','Commodity Futures Trading Commission (CFTC)','http://www.cftc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3173,'cdfi','Community Development Financial Institutions Fund (CDFI)','http://www.cdfifund.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3174,'cbo','Congressional Budget Office (CBO)','http://www.cbo.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3175,'cfpb','Consumer Financial Protection Bureau ','www.consumerfinance.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3176,'cpsc','Consumer Product Safety Commission (CPSC)','http://www.cpsc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3177,'nationalservice','Corporation for National and Community Service (CNCS)','http://www.nationalservice.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3178,'cpb','Corporation for Public Broadcasting (CPB)','http://www.cpb.org/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3179,'csosa','Court Services and Offender Supervision Agency for the District of Columbia (CSOSA)','http://www.csosa.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3180,'darpa','Defense Advanced Research Projects Agency (DARPA)','http://www.darpa.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3181,'deca','Defense Commissary Agency (DeCA)','http://www.commissaries.com/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3182,'dcaa','Defense Contract Audit Agency (DCAA)','http://www.dcaa.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3183,'dcma','Defense Contract Management Agency (DCMA)','http://www.dcma.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3184,'dfas','Defense Finance and Accounting Service (DFAS)','http://www.dfas.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3185,'dhra','Defense Human Resources Activity (DHRA)','http://www.dhra.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3186,'disa','Defense Information Systems Agency (DISA)','http://www.disa.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3187,'dia','Defense Intelligence Agency (DIA)','http://www.dia.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3188,'dla','Defense Logistics Agency (DLA)','http://www.dla.mil',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3189,'dnfsb','Defense Nuclear Facilities Safety Board (DNFSB)','http://www.dnfsb.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3190,'dpmo','Defense Prisoner of War/Missing Personnel Office (DPMO)','http://www.dtic.mil/dpmo/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3191,'dsca','Defense Security Cooperation Agency (DCSA)','http://www.dsca.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3192,'dss','Defense Security Service (DSS)','http://www.dss.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3193,'dtic','Defense Technical Information Center (DTIC)','http://www.dtic.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3194,'dtra','Defense Threat Reduction Agency (DTRA)','http://www.dtra.mil',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3195,'usda','Department of Agriculture (USDA)','http://www.usda.gov',NULL,NULL,NULL,4,5,NULL,NULL,NULL,NULL,NULL,NULL,'The United States Department of Agriculture (informally the Agriculture Department or USDA) is the United States federal executive department responsible for developing and executing U.S. federal government policy on farming, agriculture, forestry, and food. It aims to meet the needs of farmers and ranchers, promote agricultural trade and production, work to assure food safety, protect natural resources, foster rural communities and end hunger in the United States and abroad.'),
(3196,'commerce','Department of Commerce','http://www.commerce.gov',NULL,NULL,NULL,2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3197,'defense','Department of Defense (DOD)','http://www.defense.gov',NULL,NULL,NULL,2,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3198,'dodea','Department of Defense Education Activity (DoDEA)','http://www.dodea.edu/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3199,'ed','Department of Education (ED)','http://www.ed.gov',NULL,NULL,NULL,9,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3200,'energy','Department of Energy (DOE)','http://www.energy.gov',NULL,NULL,NULL,4,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3201,'hhs','Department of Health and Human Services (HHS)','http://www.hhs.gov',NULL,NULL,NULL,2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3202,'dhs','Department of Homeland Security (DHS)','http://www.dhs.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3203,'hud','Department of Housing and Urban Development (HUD)','http://www.hud.gov',NULL,NULL,NULL,6,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3204,'justice','Department of Justice (DOJ)','http://www.justice.gov',NULL,NULL,NULL,5,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3205,'labor','Department of Labor (DOL)','http://www.labor.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3206,'state','Department of State','http://www.state.gov',NULL,NULL,NULL,6,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3207,'airforce','Department of the Air Force','http://www.af.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3208,'army','Department of the Army','http://www.army.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3209,'doi','Department of the Interior (DOI)','http://www.doi.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3210,'navy','Department of the Navy','http://www.navy.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3211,'treasury','Department of the Treasury','http://www.treasury.gov',NULL,NULL,NULL,3,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3212,'dot','Department of Transportation (DOT)','http://www.dot.gov',NULL,NULL,NULL,2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3213,'va','Department of Veterans Affairs (VA)','http://www.va.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3214,'dea','Drug Enforcement Administration (DEA)','http://www.justice.gov/dea/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3215,'eda','Economic Development Administration (EDA)','http://www.eda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3216,'ers','Economic Research Service (ERS)','http://www.ers.usda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3217,'esa','Economics and Statistics Administration (ESA)','http://www.esa.doc.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3218,'eac','Election Assistance Commission (EAC)','http://www.eac.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3219,'ebsa','Employee Benefits Security Administration (ESBA)','http://www.dol.gov/ebsa/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3220,'eta','Employment and Training Administration (ETA)','http://www.doleta.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3221,'epa','Environmental Protection Agency (EPA)','http://www.epa.gov',NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3222,'eeoc','Equal Employment Opportunity Commission (EEOC)','http://www.eeoc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3223,'eop','Executive Office of the President (EOP)','http://www.whitehouse.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3224,'exim','Export-Import Bank of the United States (EXIM)','http://www.exim.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3225,'fca','Farm Credit Administration (FCA)','http://www.fca.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3226,'fsa','Farm Service Agency (FSA)','http://www.fsa.usda.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3227,'faa','Federal Aviation Administration (FAA)','http://www.faa.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3228,'fbi','Federal Bureau of Investigation (FBI)','http://www.fbi.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3229,'bop','Federal Bureau of Prisons (BOP)','http://www.bop.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3230,'fcc','Federal Communications Commission (FCC)','http://www.fcc.gov',NULL,NULL,NULL,2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3231,'fcg','Federal Consulting Group (FCG)','http://www.fcg.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3232,'fdic','Federal Deposit Insurance Corporation (FDIC)','http://www.fdic.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3233,'fec','Federal Election Commission (FEC)','http://www.fec.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3234,'fema','Federal Emergency Management Agency (FEMA)','http://www.fema.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3235,'ferc','Federal Energy Regulatory Commission (FERC)','http://www.ferc.gov',NULL,NULL,NULL,5,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3236,'fhwa','Federal Highway Administration (FHWA)','http://www.fhwa.dot.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3237,'fha','Federal Housing Administration (FHA)','http://www.fha.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3238,'fhfa','Federal Housing Finance Agency (FHFA)','http://www.fhfa.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3239,'fjc','Federal Judicial Center (FJC)','http://www.fjc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3240,'flra','Federal Labor Relations Authority (FLRA)','http://www.flra.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3241,'fletc','Federal Law Enforcement Training Center (FLETC)','http://www.fletc.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3242,'fmc','Federal Maritime Commission (FMC)','http://www.fmc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3243,'fmcs','Federal Mediation and Conciliation Service (FMCS)','http://www.fmcs.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3244,'fmshrc','Federal Mine Safety and Health Review Commission (FMSHRC)','http://www.fmshrc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3245,'fmcsa','Federal Motor Carrier Safety Administration (FMCSA)','http://www.fmcsa.dot.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3246,'fra','Federal Railroad Administration (FRA)','http://www.fra.dot.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3247,'federalreserve','Federal Reserve System','http://www.federalreserve.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3248,'frtib','Federal Retirement Thrift Investment Board (FRTIB)','http://www.frtib.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3249,'fafsa','Federal Student Aid (FAFSA)','http://www.fafsa.ed.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3250,'ftc','Federal Trade Commission (FTC)','http://www.ftc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3251,'fta','Federal Transit Administration (FTA)','http://www.fta.dot.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3252,'fincen','Financial Crimes Enforcement Network (FinCEN)','http://www.fincen.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3253,'fms','Financial Management Service (FMS)','http://www.fms.treas.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3254,'fws','Fish and Wildlife Service (FWS)','http://www.fws.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3255,'fda','Food and Drug Administration (FDA)','http://www.fda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3256,'fns','Food and Nutrition Service (FNS)','http://www.fns.usda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3257,'fsis','Food Safety and Inspection Service (FSIS)','http://www.fsis.usda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3258,'fas','Foreign Agricultural Service (FAS)','http://www.fas.usda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3259,'forestservice','Forest Service','http://www.fs.fed.us/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3260,'gsa','General Services Administration (GSA)','http://www.gsa.gov',NULL,NULL,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3261,'gao','Government Accountability Office (GAO)','http://www.gao.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3262,'gpo','Government Printing Office (GPO)','http://www.gpo.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3263,'gipsa','Grain Inspection, Packers and Stockyards Administration (GIPSA)','http://www.gipsa.usda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3264,'hrsa','Health Resources and Services Administration (HRSA)','http://www.hrsa.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3265,'house','House of Representatives','http://www.house.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3266,'ihs','Indian Health Service (IHS)','http://www.ihs.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3267,'ise','Information Sharing Environment (ISE)','http://www.ise.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3268,'ies','Institute of Education Sciences (IES)','http://ies.ed.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3269,'imls','Institute of Museum and Library Services (IMLS)','http://www.imls.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3270,'iaf','Inter-American Foundation (IAF)','http://www.iaf.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3271,'irs','Internal Revenue Service (IRS)','http://www.irs.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3272,'trade','International Trade Administration','http://www.trade.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3273,'jobcorps','Job Corps','http://www.jobcorps.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3274,'jcs','Joint Chiefs of Staff (JCS)','http://www.jcs.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3275,'jpml','Judicial Panel on Multidistrict Litigation (JPML)','http://www.jpml.uscourts.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3276,'loc','Library of Congress (LOC)','http://www.libraryofcongress.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3277,'marad','Maritime Administration','http://www.marad.dot.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3278,'mspb','Merit Systems Protection Board (MSPB)','http://www.mspb.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3279,'mcc','Millennium Challenge Corporation (MCC)','http://www.mcc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3280,'msha','Mine Safety and Health Administration (MSHA)','http://www.msha.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3281,'mbda','Minority Business Development Agency (MBDA)','http://www.mbda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3282,'mda','Missile Defense Agency (MDA)','http://www.mda.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3283,'nasa','National Aeronautics and Space Administration (NASA)','http://www.nasa.gov',NULL,NULL,NULL,3,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3284,'nass','National Agricultural Statistics Service (NASS)','http://www.nass.usda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3285,'archives','National Archives and Records Administration (NARA)','http://www.archives.gov',NULL,NULL,NULL,5,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3286,'ncpc','National Capital Planning Commission (NCPC)','http://www.ncpc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3287,'cem','National Cemetery Administration (CERN)','http://www.cem.va.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3288,'nces','National Center for Education Statistics (NCES)','http://nces.ed.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3289,'ncd','National Council on Disability (NCD)','http://www.ncd.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3290,'ncua','National Credit Union Administration (NCUA)','http://www.ncua.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3291,'nea','National Endowment for the Arts (NEA)','http://www.nea.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3292,'neh','National Endowment for the Humanities (NEH)','http://www.neh.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3293,'nga','National Geospatial-Intelligence Agency (NGA)','http://www.nga.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3294,'nationalguard','National Guard Bureau','http://www.nationalguard.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3295,'nhtsa','National Highway Traffic Safety Administration (NHTSA)','http://www.nhtsa.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3296,'nifa','National Institute of Food and Agriculture (NIFA)','http://www.csrees.usda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3297,'nist','National Institute of Standards and Technology (NIST)','http://www.nist.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3298,'nih','National Institutes of Health (NIH)','http://www.nih.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3299,'nlrb','National Labor Relations Board (NLRB)','http://www.nlrb.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3300,'nmb','National Mediation Board (NMB)','http://www.nmb.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3301,'nnsa','National Nuclear Security Administration (NNSA)','http://nnsa.energy.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3302,'noaa','National Oceanic and Atmospheric Administration (NOAA)','http://www.noaa.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3303,'nps','National Park Service (NPS)','http://www.nps.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3304,'nro','National Reconnaissance Office (NRO)','http://www.nro.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3305,'nsf','National Science Foundation (NSF)','http://www.nsf.gov',NULL,NULL,NULL,6,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3306,'nsa','National Security Agency (NSA)','http://www.nsa.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3307,'ntia','National Telecommunications and Information Administration (NTIA)','http://www.ntia.doc.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3308,'ntsb','National Transportation Safety Board (NTSB)','http://www.ntsb.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3309,'nrcs','Natural Resources Conservation Service (NRCS)','http://www.nrcs.usda.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3310,'ncis','Naval Criminal Investigative Service (NCIS)','http://www.ncis.navy.mil',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3311,'nrc','Nuclear Regulatory Commission (NRC)','http://www.nrc.gov',NULL,NULL,NULL,5,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3312,'osha','Occupational Safety and Health Administration (OSHA)','http://www.osha.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3313,'oshrc','Occupational Safety and Health Review Commission (OSHRC)','http://www.oshrc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3314,'ocr','Office for Civil Rights (OCR)','http://www.ed.gov/ocr',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3315,'compliance','Office of Compliance','http://www.compliance.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3316,'oea','Office of Economic Adjustment (OEA)','http://www.oea.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3317,'oese','Office of Elementary and Secondary Education (OESE)','http://www.ed.gov/oese',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3318,'ofs','Office of Financial Stability (OFS)','http://www.financialstability.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3319,'usoge','Office of Government Ethics (USOGE)','http://www.usoge.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3320,'oia','Office of Insular Affairs (OIA)','http://www.doi.gov/oia/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3321,'opm','Office of Personnel Management (OPM)','http://www.opm.gov',NULL,NULL,NULL,2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3322,'ope','Office of Postsecondary Education (OPE)','http://www.ed.gov/ope',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3323,'osc','Office of Special Counsel (OSC)','http://www.osc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3324,'osers','Office of Special Education and Rehabilitative Services (OSERS)','http://www.ed.gov/osers',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3325,'osm','Office of Surface Mining (OSM)','http://www.osmre.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3326,'occ','Office of the Comptroller of the Currency (OCC)','http://www.occ.treas.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3327,'dni','Office of the Director of National Intelligence (DNI)','http://www.dni.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3328,'ncix','Office of the National Counterintelligence Executive (NCIX)','http://www.ncix.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3329,'ovae','Office of Vocational and Adult Education (OVAE)','http://www.ed.gov/ovae',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3330,'opic','Overseas Private Investment Corporation (OPIC)','http://www.opic.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3331,'acp','Panama Canal Authority (ACP)','http://www.pancanal.com',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3332,'uspto','Patent and Trademark Office (USPTO)','http://www.uspto.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3333,'peacecorps','Peace Corps','http://www.peacecorps.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3334,'pbgc','Pension Benefit Guaranty Corporation (PBGC)','http://www.pbgc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3335,'pfpa','Pentagon Force Protection Agency (PFPA)','http://www.pfpa.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3336,'phmsa','Pipeline and Hazardous Materials Safety Administration (PHMSA)','http://www.phmsa.dot.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3337,'prc','Postal Regulatory Commission (PRC)','http://www.prc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3338,'rrb','Railroad Retirement Board (RRB)','http://www.rrb.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3339,'rita','Research and Innovative Technology Administration (RITA)','http://www.rita.dot.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3340,'rma','Risk Management Agency (RMA)','http://www.rma.usda.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3341,'slsdc','Saint Lawrence Seaway Development Corporation (SLSDC)','http://www.seaway.dot.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3342,'sec','Securities and Exchange Commission (SEC)','http://www.sec.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3343,'sipc','Securities Investor Protection Corporation (SIPC)','http://www.sipc.org/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3344,'sss','Selective Service System (SSS)','http://www.sss.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3345,'sba','Small Business Administration (SBA)','http://www.sba.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3346,'ssa','Social Security Administration (SSA)','http://www.ssa.gov',NULL,NULL,NULL,5,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3347,'samhsa','Substance Abuse and Mental Health Services Administration (SAMHSA)','http://www.samhsa.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3348,'supremecourt','Supreme Court (SCOTUS)','http://www.supremecourt.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3349,'stb','Surface Transportation Board (STB)','http://www.stb.dot.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3350,'tva','Tennessee Valley Authority (TVA)','http://www.tva.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3351,'tsa','Transportation Security Administration (TSA)','http://www.tsa.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3352,'tricare','TRICARE Management Activity','http://www.tricare.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3353,'backruptcycourts','U.S. Bankruptcy Courts','http://www.uscourts.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3354,'courtofappeals','U.S. Court of Appeals (CAFC)','http://www.cafc.uscourts.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3355,'courtofappealsforarmedforces','U.S. Court of Appeals for the Armed Forces','http://www.armfor.uscourts.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3356,'courtofappealsforveterans','U.S. Court of Appeals for Veterans Claims (CAVC)','http://www.uscourts.cavc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3357,'courtoffederalclaims','U.S. Court of Federal Claims (USCFC)','http://www.uscfc.uscourts.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3358,'courtofinternationaltrade','U.S. Court of International Trade','http://www.cit.uscourts.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3359,'districtcourts','U.S. District Courts','http://www.uscourts.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3360,'eia','U.S. Energy Information Administration (EIA)','http://www.eia.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3361,'senate','U.S. Senate','http://www.senate.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3362,'ussc','U.S. Sentencing Commission (USSC)','http://www.ussc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3363,'ustaxcourt','U.S. Tax Court','http://www.ustaxcourt.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3364,'ustda','U.S. Trade and Development Agency (USTDA)','http://www.ustda.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3365,'usaid','United States Agency for International Development (USAID)','http://www.usaid.gov',NULL,NULL,NULL,3,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3366,'botanicgarden','United States Botanic Garden','http://www.usbg.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3367,'uscis','United States Citizenship and Immigration Services (USCIS)','http://www.uscis.gov/portal/site/uscis',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3368,'coastguard','United States Coast Guard ','http://www.uscg.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3369,'cbp','United States Customs and Border Protection (CBP)','http://www.cbp.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3370,'usgs','United States Geological Survey (USGS)','http://www.usgs.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3371,'ice','United States Immigration and Customs Enforcement (ICE)','http://www.ice.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3372,'usitc','United States International Trade Commission (USITC)','http://www.usitc.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3373,'marshals','United States Marshals','http://www.usmarshals.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3374,'mint','United States Mint','http://www.usmint.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3375,'usps','United States Postal Service (USPS)','http://www.usps.com',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3376,'usss','United States Secret Service','http://www.secretservice.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3377,'rd','USDA Rural Development (RD)','http://www.rurdev.usda.gov',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3378,'vba','Veterans Benefits Administration (VBA)','http://www.vba.va.gov/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3379,'vha','Veterans Health Administration (VHA)','http://www.va.gov/health',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3380,'vets','Veterans\' Employment and Training Service (VETS)','http://www.dol.gov/vets/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3381,'whd','Wage and Hour Division (WHD)','http://www.dol.gov/whd/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3382,'whs','Washington Headquarters Services (WHS)','http://www.whs.mil/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3383,'wb','Women\'s Bureau (WB)','http://www.dol.gov/wb/',NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `federalagencies` ENABLE KEYS */;
DROP TABLE IF EXISTS `federalagencies_report_fields`;
CREATE TABLE `federalagencies_report_fields` (
`Internal_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`federalagency` varchar(150) NOT NULL,
`id` varchar(45) NOT NULL,
`name` varchar(150) NOT NULL,
`label` varchar(1000) NOT NULL,
`value` text NOT NULL,
`acount` int(10) unsigned DEFAULT '0',
`multiple` int(10) unsigned DEFAULT '0',
`sortcount` int(10) unsigned DEFAULT '1',
PRIMARY KEY (`Internal_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=11584 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `federalagencies_report_items`;
CREATE TABLE `federalagencies_report_items` (
`Internal_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(45) NOT NULL,
`text` text,
`parent` varchar(45) DEFAULT NULL,
`due` varchar(45) DEFAULT NULL,
`due_date` varchar(45) DEFAULT NULL,
`federalagency` varchar(150) DEFAULT NULL,
PRIMARY KEY (`Internal_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3455 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `federalagencies_socialmedia`;
CREATE TABLE `federalagencies_socialmedia` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`agency_id` varchar(45) NOT NULL,
`type` varchar(100) NOT NULL,
`url` varchar(1500) NOT NULL,
`user_name` varchar(100) DEFAULT NULL,
`follower_count` int(10) unsigned DEFAULT NULL,
`like_count` int(10) unsigned DEFAULT NULL,
`repo_count` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1388 DEFAULT CHARSET=latin1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment