Offices (view)

Awarding and funding offices, by office code.

86,708 rows

✎ View and edit SQL

id created_at updated_at office_code office_name sub_tier_code agency_code contract_awards_office contract_funding_office financial_assistance_awards_office financial_assistance_funding_office
470652568 2026-10-06 00:56:32.919433 2026-10-06 00:56:32.919437 000000   1725 097 False True False True
470530305 2026-10-06 00:56:29.900532 2026-10-06 00:56:29.900537 000251 AMERICAN RED CROSS 1763 097 False True False True
470530306 2026-10-06 00:56:29.900553 2026-10-06 00:56:29.900558 000253 AMERICAN RED CROSS 1763 097 False True False True
470576037 2026-10-06 00:56:30.895195 2026-10-06 00:56:30.895200 001175 OFFICE NAME UNKNOWN:CREATED FOR DOD MIGRATION 2005 9700 097 False True False True
470671877 2026-10-06 00:56:33.340953 2026-10-06 00:56:33.340957 0031XN Business Continuity/Disaster Recovery (BCDR) 0099 000 True True False False
470653165 2026-10-06 00:56:32.932423 2026-10-06 00:56:32.932427 003910   1727 097 False True False True
470670207 2026-10-06 00:56:33.304721 2026-10-06 00:56:33.304725 023102 US CAPITOL POLICE - OFFICE OF ACQUISITION MANAGEMENT 0002 002 True True False False
470484386 2026-10-06 00:56:28.897095 2026-10-06 00:56:28.897100 023106 US CAPITOL POLICE PROCUREMENT 0099 002 True True False False
470538191 2026-10-06 00:56:30.071782 2026-10-06 00:56:30.071786 030ADV CONTRACTS SERVICES 0300 003 True True False False
470567007 2026-10-06 00:56:30.698150 2026-10-06 00:56:30.698155 033103 LIBRARY OF CONGRESS FEDLINK 0300 003 True True False False
470653191 2026-10-06 00:56:32.932977 2026-10-06 00:56:32.932981 045924   1725 097 False True False True
470653863 2026-10-06 00:56:32.947605 2026-10-06 00:56:32.947609 049119   1700 097 False True False True
470410156 2026-10-06 00:56:27.258620 2026-10-06 00:56:27.258624 050001 US GAO OI TEAM 0559 005 True True False False
470410157 2026-10-06 00:56:27.258641 2026-10-06 00:56:27.258645 050010 US GAO IO TEAM 0559 005 True True False False
470410170 2026-10-06 00:56:27.258919 2026-10-06 00:56:27.258923 05001G US GAO IG TEAM 0559 005 True True False False
470410570 2026-10-06 00:56:27.267837 2026-10-06 00:56:27.267842 05001T US GAO IT TEAM 0559 005 True True False False
470410151 2026-10-06 00:56:27.258511 2026-10-06 00:56:27.258516 0500EC US GAO EXECUTIVE COMMITTEE 0559 005 True True False False
470407220 2026-10-06 00:56:27.193288 2026-10-06 00:56:27.193293 0500GC US GAO GC TEAM 0559 005 True True False False
470410165 2026-10-06 00:56:27.258810 2026-10-06 00:56:27.258815 0500HC US GAO HC TEAM 0559 005 True True False False
470410152 2026-10-06 00:56:27.258533 2026-10-06 00:56:27.258537 0500P1 US GAO PI TEAM 0559 005 True True False False
470410597 2026-10-06 00:56:27.268448 2026-10-06 00:56:27.268452 0500PA US GAO PA TEAM 0559 005 True True False False
470410174 2026-10-06 00:56:27.259004 2026-10-06 00:56:27.259008 0500S1 US GAO SI TEAM 0559 005 True True False False
470410162 2026-10-06 00:56:27.258747 2026-10-06 00:56:27.258751 0501AT US GAO IAT TEAM 0559 005 True True False False
470410384 2026-10-06 00:56:27.263645 2026-10-06 00:56:27.263650 0501TC US GAO ITC TEAM 0559 005 False True False False
470407873 2026-10-06 00:56:27.207601 2026-10-06 00:56:27.207605 050ACQ US GAO ACQ TEAM 0559 005 True True False False
470407221 2026-10-06 00:56:27.193309 2026-10-06 00:56:27.193314 050ARM US GAO ARM TEAM 0559 005 True True False False
470407945 2026-10-06 00:56:27.209186 2026-10-06 00:56:27.209190 050ASM US GAO ASM TEAM 0559 005 True True False False
470407235 2026-10-06 00:56:27.193609 2026-10-06 00:56:27.193614 050CA0 US GAO CAO TEAM 0559 005 False True False False
470407237 2026-10-06 00:56:27.193654 2026-10-06 00:56:27.193658 050DCM US GAO DCM TEAM 0559 005 True True False False
470597742 2026-10-06 00:56:31.366827 2026-10-06 00:56:31.366831 050F0P US GAO FIELD OPERATIONS 0559 005 False True False False
470410172 2026-10-06 00:56:27.258961 2026-10-06 00:56:27.258966 050FMA US GAO FMA TEAM 0559 005 True True False False
470410166 2026-10-06 00:56:27.258831 2026-10-06 00:56:27.258836 050HC0 US GAO HCO TEAM 0559 005 True True False False
470410171 2026-10-06 00:56:27.258940 2026-10-06 00:56:27.258945 050HSJ US GAO HSJ TEAM 0559 005 True True False False
470410142 2026-10-06 00:56:27.258320 2026-10-06 00:56:27.258325 050NRE US GAO NRE TEAM 0559 005 True True False False
470407241 2026-10-06 00:56:27.193738 2026-10-06 00:56:27.193743 050PAB US GAO PAB TEAM 0559 005 False True False False
470410164 2026-10-06 00:56:27.258789 2026-10-06 00:56:27.258794 051STS US GAO ISTS TEAM 0559 005 False True False False
470410124 2026-10-06 00:56:27.257924 2026-10-06 00:56:27.257928 05APQA US GAO APQA TEAM 0559 005 True True False False
470410565 2026-10-06 00:56:27.267726 2026-10-06 00:56:27.267730 05ARML US GAO ARM LIBRARY 0559 005 False True False False
470410163 2026-10-06 00:56:27.258768 2026-10-06 00:56:27.258773 05EW1S US GAO EWIS TEAM 0559 005 True True False False
470410168 2026-10-06 00:56:27.258874 2026-10-06 00:56:27.258878 05FA1S US GAO FAIS TEAM 0559 005 True True False False
470410125 2026-10-06 00:56:27.257945 2026-10-06 00:56:27.257950 05FASB US GAO FASAB TEAM 0559 005 False True False False
470410149 2026-10-06 00:56:27.258469 2026-10-06 00:56:27.258474 05FMB0 US GAO FMBO TEAM 0559 005 True True False False
470410169 2026-10-06 00:56:27.258897 2026-10-06 00:56:27.258902 05FMC1 US GAO FMCI TEAM 0559 005 True True False False
470617881 2026-10-06 00:56:31.805028 2026-10-06 00:56:31.805033 05GA0A GOVERNMENT ACCOUNTABILITY OFFICE 0559 005 True True False False
470410173 2026-10-06 00:56:27.258983 2026-10-06 00:56:27.258987 05SPEL US GAO SPEL TEAM 0559 005 True True False False
470411668 2026-10-06 00:56:27.292190 2026-10-06 00:56:27.292194 05STAA US GAO STAA TEAM 0559 005 True True False False
470653184 2026-10-06 00:56:32.932827 2026-10-06 00:56:32.932831 06100Q   1725 097 False True False True
470653178 2026-10-06 00:56:32.932701 2026-10-06 00:56:32.932705 062755   1710 097 False True False True
470652901 2026-10-06 00:56:32.926620 2026-10-06 00:56:32.926625 0C33AS   2100 097 False True False True
470576058 2026-10-06 00:56:30.895658 2026-10-06 00:56:30.895663 100102 OFFICE NAME UNKNOWN:CREATED FOR DOD MIGRATION 2005 1700 097 False True False True
470527903 2026-10-06 00:56:29.848549 2026-10-06 00:56:29.848553 100135 9TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470527902 2026-10-06 00:56:29.848527 2026-10-06 00:56:29.848532 100227 9TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470527897 2026-10-06 00:56:29.848422 2026-10-06 00:56:29.848427 100462 9TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470527907 2026-10-06 00:56:29.848633 2026-10-06 00:56:29.848638 100576 9TH CIRCUIT COURT 1027 010 False True False False
470527899 2026-10-06 00:56:29.848464 2026-10-06 00:56:29.848469 100577 9TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470515654 2026-10-06 00:56:29.581432 2026-10-06 00:56:29.581436 101370 1ST CIRCUIT COURT OF APPEALS 1027 010 False True False False
470515652 2026-10-06 00:56:29.581389 2026-10-06 00:56:29.581394 101371 1ST CIRCUIT COURT OF APPEALS 1027 010 False True False False
470515656 2026-10-06 00:56:29.581474 2026-10-06 00:56:29.581479 101372 1ST CIRCUIT COURT OF APPEALS 1027 010 False True False False
470515655 2026-10-06 00:56:29.581453 2026-10-06 00:56:29.581457 101373 1ST CIRCUIT COURT OF APPEALS 1027 010 False True False False
470515653 2026-10-06 00:56:29.581410 2026-10-06 00:56:29.581415 101374 1ST CIRCUIT COURT OF APPEALS 1027 010 False True False False
470515651 2026-10-06 00:56:29.581368 2026-10-06 00:56:29.581372 101375 1ST CIRCUIT COURT OF APPEALS 1027 010 False True False False
470593939 2026-10-06 00:56:31.284334 2026-10-06 00:56:31.284338 102377 US COURT OF CUSTOMER INTL TRADE 1027 010 False True False False
470517188 2026-10-06 00:56:29.614633 2026-10-06 00:56:29.614638 102M32 2ND CIRCUIT COURT OF APPEALS 1027 010 False True False False
470517191 2026-10-06 00:56:29.614697 2026-10-06 00:56:29.614702 102M33 2ND CIRCUIT COURT OF APPEALS 1027 010 False True False False
470517189 2026-10-06 00:56:29.614655 2026-10-06 00:56:29.614659 102M34 2ND CIRCUIT COURT OF APPEALS 1027 010 False True False False
470517192 2026-10-06 00:56:29.614718 2026-10-06 00:56:29.614723 102M35 2ND CIRCUIT COURT OF APPEALS 1027 010 False True False False
470517190 2026-10-06 00:56:29.614676 2026-10-06 00:56:29.614680 102M36 2ND CIRCUIT COURT OF APPEALS 1027 010 False True False False
470517193 2026-10-06 00:56:29.614739 2026-10-06 00:56:29.614744 102M37 2ND CIRCUIT COURT OF APPEALS 1027 010 False True False False
470517187 2026-10-06 00:56:29.614612 2026-10-06 00:56:29.614616 102M38 2ND CIRCUIT COURT OF APPEALS 1027 010 False True False False
470533482 2026-10-06 00:56:29.969090 2026-10-06 00:56:29.969094 1031B1 CLERK TEMPORARY EMERGENCY 2557 097 False True False True
470539297 2026-10-06 00:56:30.095707 2026-10-06 00:56:30.095711 103260 DC CIRCUIT COURT OF APPEALS 1027 010 False True False False
470552985 2026-10-06 00:56:30.393226 2026-10-06 00:56:30.393230 103261 FEDERAL CIRCUIT COURT OF APPEALS 1027 010 False True False False
470593940 2026-10-06 00:56:31.284355 2026-10-06 00:56:31.284359 103267 US COURT OF CLAIMS 1027 010 False True False False
470552980 2026-10-06 00:56:30.393110 2026-10-06 00:56:30.393114 103276 FEDERAL JUDICIAL COMMTTEE 1027 010 False True False False
470598360 2026-10-06 00:56:31.380176 2026-10-06 00:56:31.380180 103298 US SENTENCING COMMISSION 1027 010 False True False False
470530626 2026-10-06 00:56:29.907423 2026-10-06 00:56:29.907427 103299 AOUSC-PROCUREMENT MANAGEMENT DIV 1027 010 True True False False
470576327 2026-10-06 00:56:30.901434 2026-10-06 00:56:30.901439 103307 OFFICE OF INDEPENDENT COUNSEL 1027 010 False True False False
470555014 2026-10-06 00:56:30.437077 2026-10-06 00:56:30.437082 103308 FOREIGN INTELLIGENCE SURVEILLANCE 1027 010 False True False False
470565875 2026-10-06 00:56:30.673533 2026-10-06 00:56:30.673538 103320 JUDICIAL PANEL ON MULTIDISTRICT 1027 010 False True False False
470593938 2026-10-06 00:56:31.284313 2026-10-06 00:56:31.284317 1033D3 US COURTS 1027 010 False True False False
470521820 2026-10-06 00:56:29.716155 2026-10-06 00:56:29.716160 1033D7 4TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470521822 2026-10-06 00:56:29.716199 2026-10-06 00:56:29.716203 1033D8 4TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470521821 2026-10-06 00:56:29.716177 2026-10-06 00:56:29.716181 1033D9 4TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470521819 2026-10-06 00:56:29.716134 2026-10-06 00:56:29.716139 1033E0 4TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470521818 2026-10-06 00:56:29.716100 2026-10-06 00:56:29.716105 1033E1 4TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470521817 2026-10-06 00:56:29.716079 2026-10-06 00:56:29.716084 1033E2 4TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470521816 2026-10-06 00:56:29.716058 2026-10-06 00:56:29.716062 1033E3 4TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470521815 2026-10-06 00:56:29.716037 2026-10-06 00:56:29.716041 1033E4 4TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470640475 2026-10-06 00:56:32.655712 2026-10-06 00:56:32.655717 1033E5 WESTERN DISTRICT COURT OF NC 1027 010 True True False False
470521814 2026-10-06 00:56:29.716015 2026-10-06 00:56:29.716020 1033E6 4TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470521813 2026-10-06 00:56:29.715994 2026-10-06 00:56:29.715999 1033E7 4TH CIRCUIT COURT OF APPEALS 1027 010 False True False False
470565876 2026-10-06 00:56:30.673555 2026-10-06 00:56:30.673559 103B01 JUDGE HENRY S. PERKIN 1027 010 False True False False
470519605 2026-10-06 00:56:29.667635 2026-10-06 00:56:29.667640 103B02 3RD CIRCUIT COURT OF APPEALS 1027 010 False True False False
470519607 2026-10-06 00:56:29.667678 2026-10-06 00:56:29.667682 103B03 3RD CIRCUIT COURT OF APPEALS 1027 010 False True False False
470519609 2026-10-06 00:56:29.667720 2026-10-06 00:56:29.667725 103B04 3RD CIRCUIT COURT OF APPEALS 1027 010 False True False False
470519606 2026-10-06 00:56:29.667657 2026-10-06 00:56:29.667661 103B05 3RD CIRCUIT COURT OF APPEALS 1027 010 False True False False
470519608 2026-10-06 00:56:29.667699 2026-10-06 00:56:29.667703 103B06 3RD CIRCUIT COURT OF APPEALS 1027 010 False True False False
470543479 2026-10-06 00:56:30.186811 2026-10-06 00:56:30.186815 103B07 DISTRICT COURT THE VIRGIN ISLANDS 1027 010 False True False False
470519604 2026-10-06 00:56:29.667614 2026-10-06 00:56:29.667619 103B08 3RD CIRCUIT COURT OF APPEALS 1027 010 False True False False
470511872 2026-10-06 00:56:29.499636 2026-10-06 00:56:29.499640 104199 11TH CIRCUIT COURT OF APPEALS 1027 010 False True False False

Next page

Download this data

CSV · JSON

View definition 
CREATE VIEW office AS SELECT * FROM read_parquet(main.list_value('/data/usaspending/office.parquet'));