{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Auditing Federal Contractors Part III\n",
"_By [Leon Yin](www.leonyin.org) Last Updated 2018-06-24_\n",
"\n",
"View this notebook in [NBViewer](http://nbviewer.jupyter.org/github/yinleon/us-spending/blob/master/2_ice_money.ipynb?flush=true) or [Github](https://github.com/yinleon/us-spending/blob/master/2_ice_money.ipynb).\n",
"\n",
"The output is availalble publically on [Google Drive](https://docs.google.com/spreadsheets/d/1FnMDVm9rXJrUp8wk-TPL7lIL409ai1Gv9ApeigXa_mM/edit#gid=128424636) and [Github](https://raw.githubusercontent.com/yinleon/us-spending/master/ice_data/data_out/ice_prime_contractors_aggregated.csv)."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## ICE Contractor Analysis\n",
"Following [my analysis](https://nbviewer.jupyter.org/github/yinleon/us-spending/blob/master/1_analysis_methods.ipynb) of federal contracts to the private prisons CoreCivic and Geo Group, this notebook analyzes publically avaiable contracts from the Immigration and Customs Enforcement Agency (ICE). This analysis uses data downloaded from the new USASpending.gov [dashboard](https://www.usaspending.gov/#/search/1da7f3124d80741313219fd741632538) filtered on \"U.S. Immigration and Customs Enforcement (ICE) | Sub-Agency\"."
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"import glob\n",
"import datetime\n",
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"# data downloaded from USAspending.gov\n",
"input_file_pattern = 'ice_data/data_in/*'"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['ice_data/data_in/all_contracts_subawards_1.csv',\n",
" 'ice_data/data_in/all_assistance_prime_transactions_1.csv',\n",
" 'ice_data/data_in/all_contracts_prime_transactions_1.csv',\n",
" 'ice_data/data_in/all_assistance_subawards_1.csv']"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"files = glob.glob(input_file_pattern)\n",
"files"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let's just look at prime contracts today."
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/anaconda3/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2698: DtypeWarning: Columns (19,32,38,46,47,48,49,56,65,78,79,87,106,107,135,136,204) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" interactivity=interactivity, compiler=compiler, result=result)\n"
]
}
],
"source": [
"df_prime_contracts = pd.read_csv(files[2])"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"There are 258 columns in this file!\n",
"Here are some of the column names:\n"
]
},
{
"data": {
"text/plain": [
"['award_id_piid',\n",
" 'modification_number',\n",
" 'transaction_number',\n",
" 'parent_award_agency_id',\n",
" 'parent_award_agency_name',\n",
" 'parent_award_id',\n",
" 'parent_award_modification_number',\n",
" 'federal_action_obligation',\n",
" 'base_and_exercised_options_value',\n",
" 'current_total_value_of_award',\n",
" 'base_and_all_options_value',\n",
" 'potential_total_value_of_award',\n",
" 'action_date',\n",
" 'period_of_performance_start_date',\n",
" 'period_of_performance_current_end_date',\n",
" 'period_of_performance_potential_end_date',\n",
" 'ordering_period_end_date',\n",
" 'awarding_agency_code',\n",
" 'awarding_agency_name',\n",
" 'awarding_sub_agency_code']"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# there are a lot of columns!\n",
"prime_cols = df_prime_contracts.columns\n",
"num_cols = len(prime_cols)\n",
"print(f\"There are {num_cols} columns in this file!\\nHere are some of the column names:\")\n",
"prime_cols.values.tolist()[:20]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"That is a lot of columns, here are the definitions of the columns we'll be using here:"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Glossary of fields used in this Analysis with Definitions from USASpending:\n",
"`recipient_duns`
\n",
"The unique identification number for the ultimate parent of an awardee or recipient. Currently the identifier is the 9-digit number maintained by Dun & Bradstreet as the global parent DUNSĀ® number.\n",
"\n",
"\n",
"\n",
"`potential_total_value_of_award`
\n",
"The total amount that could be obligated on a contract. This total includes the base plus options amount. For example, if a recipient is awarded 10M on a base contract with 3 option years at 1M each, the potential award amount is 13M.\n",
"\n",
"`current_total_value_of_award`
\n",
"The amount of money that the government has promised (obligated) to pay a recipient for a contract. This means the base amount and any exercised options.\n",
"\n",
"`period_of_performance_start_date`
\n",
"The date that the award begins.\n",
"\n",
"`period_of_performance_potential_end_date`
\n",
"For procurement, the date on which, for the award referred to by the action being reported if all potential pre-determined or pre-negotiated options were exercised, awardee effort is completed or the award is otherwise ended. Administrative actions related to this award may continue to occur after this date. This date does not apply to procurement indefinite delivery vehicles under which definitive orders may be awarded.\n",
"\n",
"
\n", " | recipient_parent_name | \n", "top_words_from_serv_desc | \n", "number_of_prime_awards | \n", "current_total_value_of_awards_USD | \n", "potential_total_value_of_awards | \n", "first_contract_start_date | \n", "last_contract_end_date | \n", "recipient_address_line_1 | \n", "recipient_address_line_2 | \n", "recipient_city_name | \n", "recipient_state_code | \n", "recipient_state_name | \n", "recipient_zip_4_code | \n", "recipient_congressional_district | \n", "recipient_phone_number | \n", "recipient_fax_number | \n", "analysis_date | \n", "raw_data_download_date | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "BATTELLE MEMORIAL INSTITUTE INC | \n", "oper, govt, r&d, goco, facilities | \n", "1 | \n", "2.258840e+10 | \n", "2.258840e+10 | \n", "2016-05-27 00:00:00 | \n", "2017-09-30 | \n", "902 BATTELLE BLVD | \n", "NaN | \n", "RICHLAND | \n", "WA | \n", "WASHINGTON | \n", "993521873 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
1 | \n", "SPECTRUM SECURITY SERVICES INC. | \n", "guard, housekeeping, services | \n", "128 | \n", "1.731890e+10 | \n", "1.902971e+10 | \n", "2008-09-08 00:00:00 | \n", "2018-12-11 | \n", "13967 HIGHWAY 94 STE 101 | \n", "NaN | \n", "JAMUL | \n", "CA | \n", "CALIFORNIA | \n", "919353232 | \n", "50 | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
2 | \n", "CSI AVIATION SERVICES INC. | \n", "travel, air, passenger, transportation, reloca... | \n", "63 | \n", "5.897378e+09 | \n", "7.426944e+09 | \n", "2009-03-31 00:00:00 | \n", "2018-06-30 | \n", "3700 RIO GRANDE BLVD NW | \n", "NaN | \n", "ALBUQUERQUE | \n", "NM | \n", "NEW MEXICO | \n", "871072876 | \n", "01 | \n", "5057619000 | \n", "5053427377 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
3 | \n", "INGENESIS INC. | \n", "medical, general, health, care | \n", "20 | \n", "3.530665e+09 | \n", "4.874056e+09 | \n", "2012-07-16 00:00:00 | \n", "2018-07-15 | \n", "10231 KOTZEBUE ST | \n", "NaN | \n", "SAN ANTONIO | \n", "TX | \n", "TEXAS | \n", "782174430 | \n", "21 | \n", "2103660033 | \n", "2105684582 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
4 | \n", "THE GEO GROUP INC | \n", "guard, housekeeping, support, services, program | \n", "115 | \n", "3.335807e+09 | \n", "1.663010e+10 | \n", "2007-06-01 00:00:00 | \n", "2029-10-11 | \n", "621 NW 53RD ST STE 700 | \n", "NaN | \n", "BOCA RATON | \n", "FL | \n", "FLORIDA | \n", "334878242 | \n", "22 | \n", "5619997359 | \n", "5619997648 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
5 | \n", "PHACIL INC. | \n", "telecom, help, desk | \n", "47 | \n", "2.889115e+09 | \n", "3.027381e+09 | \n", "2012-09-10 00:00:00 | \n", "2018-09-09 | \n", "800 N GLEBE RD STE 700 | \n", "NaN | \n", "ARLINGTON | \n", "VA | \n", "VIRGINIA | \n", "222032149 | \n", "8 | \n", "7035261800 | \n", "7033662900 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
6 | \n", "SPECTRUM SECURITY SERVICES INC. | \n", "housekeeping, guard | \n", "13 | \n", "1.864530e+09 | \n", "1.997933e+09 | \n", "2011-12-21 00:00:00 | \n", "2016-02-29 | \n", "13967 HIGHWAY 94 STE 101 | \n", "NaN | \n", "JAMUL | \n", "CA | \n", "CALIFORNIA | \n", "919353232 | \n", "52 | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
7 | \n", "ASSET PROTECTION & SECURITY SERVICES L.P. | \n", "guard, housekeeping, oper, govt, misc | \n", "19 | \n", "1.400854e+09 | \n", "1.633666e+09 | \n", "2009-09-30 00:00:00 | \n", "2018-09-30 | \n", "5502 BURNHAM DR | \n", "NaN | \n", "CORPUS CHRISTI | \n", "TX | \n", "TEXAS | \n", "784133787 | \n", "27 | \n", "3619061552 | \n", "3619061844 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
8 | \n", "WIDEPOINT CORPORATION | \n", "support, professional:, program, management | \n", "25 | \n", "1.318187e+09 | \n", "5.204160e+09 | \n", "2015-04-09 00:00:00 | \n", "2018-12-08 | \n", "7926 JONES BRANCH DR STE 520 | \n", "NaN | \n", "MC LEAN | \n", "VA | \n", "VIRGINIA | \n", "221023371 | \n", "11 | \n", "7033495644 | \n", "7038483560 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
9 | \n", "TRAILBOSS ENTERPRISES INC. | \n", "housekeeping, facilities, operations, support,... | \n", "13 | \n", "1.266682e+09 | \n", "3.871661e+09 | \n", "2012-06-01 00:00:00 | \n", "2018-09-30 | \n", "201 EAST 3RD AVE | \n", "NaN | \n", "ANCHORAGE | \n", "AK | \n", "ALASKA | \n", "995012503 | \n", "00 | \n", "9073388243 | \n", "9073380869 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
10 | \n", "CORRECTIONS CORPORATION OF AMERICA | \n", "guard, housekeeping, services, support, facili... | \n", "58 | \n", "1.230570e+09 | \n", "2.311516e+09 | \n", "2009-04-01 00:00:00 | \n", "2019-06-30 | \n", "10 BURTON HILLS BLVD | \n", "NaN | \n", "NASHVILLE | \n", "TN | \n", "TENNESSEE | \n", "372156105 | \n", "05 | \n", "6152636713 | \n", "6152633090 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
11 | \n", "AHTNA INCORPORATED | \n", "guard, housekeeping, services, penal, facilities | \n", "29 | \n", "9.644808e+08 | \n", "3.692711e+09 | \n", "2010-02-01 00:00:00 | \n", "2018-11-30 | \n", "110 W 38TH AVE STE 200D | \n", "NaN | \n", "ANCHORAGE | \n", "AK | \n", "ALASKA | \n", "995035677 | \n", "0 | \n", "9073346477 | \n", "9073346750 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
12 | \n", "G4S PLC | \n", "guard, housekeeping, services, social, rehabil... | \n", "181 | \n", "9.630253e+08 | \n", "1.101117e+09 | \n", "2009-08-12 00:00:00 | \n", "2019-01-31 | \n", "4200 WACKENHUT DR STE 100 | \n", "NaN | \n", "PALM BEACH GARDENS | \n", "FL | \n", "FLORIDA | \n", "334104243 | \n", "18 | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
13 | \n", "CLASSIC AIR CHARTER INC. | \n", "travel, transportation, relocation, lodging, r... | \n", "6 | \n", "7.483224e+08 | \n", "3.851914e+09 | \n", "2017-10-20 00:00:00 | \n", "2023-06-30 | \n", "460 NEW YORK AVE | \n", "NaN | \n", "HUNTINGTON | \n", "NY | \n", "NEW YORK | \n", "117433432 | \n", "03 | \n", "6315495021 | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
14 | \n", "NANA REGIONAL CORPORATION INC | \n", "housekeeping, guard, relocation, services, tra... | \n", "22 | \n", "5.979669e+08 | \n", "4.151455e+09 | \n", "2008-09-25 00:00:00 | \n", "2025-01-31 | \n", "3901 OLD INTERNATIONAL AIRPORT RD STE 200-G | \n", "NaN | \n", "ANCHORAGE | \n", "AK | \n", "ALASKA | \n", "99502 | \n", "0 | \n", "7037666837 | \n", "7037666906 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
15 | \n", "SRA INTERNATIONAL INC. | \n", "support, professional:, communications, progra... | \n", "45 | \n", "5.940203e+08 | \n", "1.370448e+09 | \n", "2016-06-20 00:00:00 | \n", "2022-09-29 | \n", "4300 FAIR LAKES CT | \n", "NaN | \n", "FAIRFAX | \n", "VA | \n", "VIRGINIA | \n", "220334232 | \n", "11 | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
16 | \n", "SCIENCE APPLICATIONS INTERNATIONAL CORPORATION | \n", "telecom, systems, development, equipment, tele... | \n", "4 | \n", "5.322573e+08 | \n", "7.048101e+08 | \n", "2014-09-25 00:00:00 | \n", "2015-09-24 | \n", "1710 SAIC DR | \n", "NaN | \n", "MCLEAN | \n", "VA | \n", "VIRGINIA | \n", "22102 | \n", "NaN | \n", "7036765681 | \n", "7036765063 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
17 | \n", "M V M INC. | \n", "guard, housekeeping, support, administrative:,... | \n", "41 | \n", "4.726719e+08 | \n", "1.767799e+09 | \n", "2008-06-27 00:00:00 | \n", "2022-08-03 | \n", "44620 GUILFORD DR STE 150 | \n", "NaN | \n", "ASHBURN | \n", "VA | \n", "VIRGINIA | \n", "201476063 | \n", "10 | \n", "5712234620 | \n", "5712234487 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
18 | \n", "UNIVERSAL LANGUAGE CORPORATION | \n", "translation, admin, svcs, sign, languag | \n", "41 | \n", "4.180052e+08 | \n", "8.500482e+08 | \n", "2007-09-10 00:00:00 | \n", "2014-03-22 | \n", "97 12 63RD DR STE 2 A | \n", "NaN | \n", "REGO PARK | \n", "NY | \n", "NEW YORK | \n", "113742244 | \n", "06 | \n", "7189979369 | \n", "7184590331 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
19 | \n", "THE MITRE CORPORATION | \n", "programming, r&d, research, development, (engi... | \n", "27 | \n", "4.062568e+08 | \n", "4.108850e+08 | \n", "2008-08-29 00:00:00 | \n", "2018-01-12 | \n", "7515 COLSHIRE DR | \n", "NaN | \n", "MC LEAN | \n", "VA | \n", "VIRGINIA | \n", "221027539 | \n", "8 | \n", "7039836474 | \n", "7039837121 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
20 | \n", "ENTERPRISE SERVICES LLC | \n", "telecom, data, centers, storage | \n", "9 | \n", "3.831977e+08 | \n", "6.851440e+08 | \n", "2017-06-09 00:00:00 | \n", "2020-06-26 | \n", "13600 EDS DR A3S-B53 | \n", "NaN | \n", "HERNDON | \n", "VA | \n", "VIRGINIA | \n", "201713299 | \n", "10 | \n", "7037333793 | \n", "7037422674 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
21 | \n", "SAVANTAGE FINANCIAL SERVICES INC. | \n", "telecommunications, telecom, adp, &, svcs | \n", "11 | \n", "3.674644e+08 | \n", "6.826124e+08 | \n", "2009-12-08 00:00:00 | \n", "2020-12-31 | \n", "1355 PICCARD DR STE 425 | \n", "NaN | \n", "ROCKVILLE | \n", "MD | \n", "MARYLAND | \n", "208504339 | \n", "8 | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
22 | \n", "BOOZ ALLEN HAMILTON HOLDING CORPORATION | \n", "support, professional:, program, management, t... | \n", "43 | \n", "3.664082e+08 | \n", "1.161358e+09 | \n", "2009-09-28 00:00:00 | \n", "2023-01-16 | \n", "8283 GREENSBORO DR | \n", "NaN | \n", "MCLEAN | \n", "VA | \n", "VIRGINIA | \n", "221023830 | \n", "11 | \n", "7033770667 | \n", "7039023200 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
23 | \n", "MAXIM HEALTHCARE SERVICES INC. | \n", "medical, general, health, care | \n", "12 | \n", "3.577394e+08 | \n", "3.577394e+08 | \n", "2014-09-11 00:00:00 | \n", "2018-09-22 | \n", "7227 LEE DEFOREST DR | \n", "NaN | \n", "COLUMBIA | \n", "MD | \n", "MARYLAND | \n", "210463236 | \n", "03 | \n", "4109101553 | \n", "4109101615 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
24 | \n", "DELOITTE LLP | \n", "support, management, professional:, program, f... | \n", "70 | \n", "3.086653e+08 | \n", "7.260085e+08 | \n", "2009-08-19 00:00:00 | \n", "2022-09-22 | \n", "1725 DUKE ST | \n", "NaN | \n", "ALEXANDRIA | \n", "VA | \n", "VIRGINIA | \n", "223143456 | \n", "08 | \n", "5718826190 | \n", "7039963387 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
25 | \n", "KNIGHT POINT SYSTEMS LLC | \n", "telecom, help, desk, telecommunications, support | \n", "19 | \n", "2.907098e+08 | \n", "8.810253e+08 | \n", "2011-08-15 00:00:00 | \n", "2021-06-29 | \n", "1775 WIEHLE AVE STE 101 | \n", "NaN | \n", "RESTON | \n", "VA | \n", "VIRGINIA | \n", "201905109 | \n", "11 | \n", "7036577051 | \n", "5712663106 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
26 | \n", "GLOBAL PRECISION SYSTEMS LLC | \n", "housekeeping, guard | \n", "20 | \n", "2.860719e+08 | \n", "1.683557e+09 | \n", "2015-09-23 00:00:00 | \n", "2019-07-27 | \n", "4600 DEBARR RD STE 200 | \n", "NaN | \n", "ANCHORAGE | \n", "AK | \n", "ALASKA | \n", "995083103 | \n", "00 | \n", "9073348348 | \n", "9075632742 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
27 | \n", "CACI INTERNATIONAL INC | \n", "support, professional:, miscellaneous, communi... | \n", "7 | \n", "2.709178e+08 | \n", "6.560159e+08 | \n", "2007-10-22 00:00:00 | \n", "2021-03-17 | \n", "14370 NEWBROOK DRIVE | \n", "NaN | \n", "CHANTILLY | \n", "VA | \n", "VIRGINIA | \n", "201512218 | \n", "10 | \n", "7036794137 | \n", "7036793402 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
28 | \n", "MCKINSEY & COMPANY INC. | \n", "support, management:, professional: | \n", "14 | \n", "2.189934e+08 | \n", "2.845323e+08 | \n", "2015-10-21 00:00:00 | \n", "2019-05-23 | \n", "1200 19TH ST NW STE 1100 | \n", "NaN | \n", "WASHINGTON | \n", "DC | \n", "DISTRICT OF COLUMBIA | \n", "200362412 | \n", "0 | \n", "2026621185 | \n", "2026623256 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
29 | \n", "PALANTIR TECHNOLOGIES INC. | \n", "data, telecom, information, broadcasting, dist... | \n", "17 | \n", "2.100309e+08 | \n", "5.111377e+08 | \n", "2011-02-24 00:00:00 | \n", "2018-11-27 | \n", "100 HAMILTON AVE STE 300 | \n", "NaN | \n", "PALO ALTO | \n", "CA | \n", "CALIFORNIA | \n", "943011651 | \n", "18 | \n", "6508150200 | \n", "6506182298 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
30 | \n", "BEN FITZGERALD REAL ESTATE SERVICES L.L.C. | \n", "facilities, operations, support, housekeeping,... | \n", "165 | \n", "1.981641e+08 | \n", "2.393186e+08 | \n", "2008-09-25 00:00:00 | \n", "2019-04-30 | \n", "1530 S SOUTHWEST LOOP 323 | \n", "NaN | \n", "TYLER | \n", "TX | \n", "TEXAS | \n", "757012556 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
31 | \n", "FORFEITURE SUPPORT ASSOCIATES LLC | \n", "support, legal, professional:, services, program | \n", "24 | \n", "1.971348e+08 | \n", "1.971348e+08 | \n", "2010-03-23 00:00:00 | \n", "2016-09-30 | \n", "20110 ASHBROOK PL STE 220 | \n", "NaN | \n", "ASHBURN | \n", "VA | \n", "VIRGINIA | \n", "201475060 | \n", "10 | \n", "5712918900 | \n", "5712918957 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
32 | \n", "CAP GEMINI | \n", "support, professional:, services, professional... | \n", "13 | \n", "1.926498e+08 | \n", "2.366901e+08 | \n", "2009-09-25 00:00:00 | \n", "2023-06-30 | \n", "1900 CAMPUS COMMONS DR #250 | \n", "NaN | \n", "RESTON | \n", "VA | \n", "VIRGINIA | \n", "201911560 | \n", "11 | \n", "5713361618 | \n", "5713361700 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
33 | \n", "PHACIL INC. | \n", "telecom, help, desk | \n", "3 | \n", "1.840695e+08 | \n", "1.932425e+08 | \n", "2013-07-04 00:00:00 | \n", "2018-09-09 | \n", "950 N GLEBE RD STE 910 | \n", "NaN | \n", "ARLINGTON | \n", "VA | \n", "VIRGINIA | \n", "222034173 | \n", "08 | \n", "7035261800 | \n", "7037387100 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
34 | \n", "STG INTERNATIONAL INC. | \n", "support, professional:, program, management, s... | \n", "2 | \n", "1.790737e+08 | \n", "9.042798e+08 | \n", "2007-08-22 00:00:00 | \n", "2023-02-19 | \n", "99 CANAL CTR PLZ STE 500 | \n", "NaN | \n", "ALEXANDRIA | \n", "VA | \n", "VIRGINIA | \n", "223145504 | \n", "8 | \n", "7035786030 | \n", "5712556545 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
35 | \n", "DEV TECHNOLOGY GROUP INC. | \n", "telecom, programming, services, systems, devel... | \n", "24 | \n", "1.648354e+08 | \n", "4.167145e+08 | \n", "2011-05-23 00:00:00 | \n", "2022-02-28 | \n", "1984 ISAAC NEWTON SQ W STE 302 | \n", "NaN | \n", "RESTON | \n", "VA | \n", "VIRGINIA | \n", "201905041 | \n", "11 | \n", "7038608135 | \n", "7038608138 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
36 | \n", "GRANT THORNTON INTERNATIONAL LTD | \n", "support, management, program, professional:, m... | \n", "13 | \n", "1.291985e+08 | \n", "2.115375e+08 | \n", "2008-09-17 00:00:00 | \n", "2023-04-23 | \n", "333 JOHN CARLYLE ST STE 500 | \n", "NaN | \n", "ALEXANDRIA | \n", "VA | \n", "VIRGINIA | \n", "223145767 | \n", "08 | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
37 | \n", "GENERAL DYNAMICS CORPORATION | \n", "ammunition,, 30mm, equipment, public, relations | \n", "24 | \n", "1.289099e+08 | \n", "3.557973e+08 | \n", "2010-05-11 00:00:00 | \n", "2020-12-31 | \n", "3170 FAIRVIEW PARK DR | \n", "NaN | \n", "FALLS CHURCH | \n", "VA | \n", "VIRGINIA | \n", "220424516 | \n", "11 | \n", "7038761243 | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
38 | \n", "UNIVERSAL LANGUAGE CORPORATION | \n", "support, administrative:, translation, interpr... | \n", "10 | \n", "1.186904e+08 | \n", "2.421312e+08 | \n", "2011-12-28 00:00:00 | \n", "2013-09-07 | \n", "97 12 63RD DR STE 2 A | \n", "NaN | \n", "REGO PARK | \n", "NY | \n", "NEW YORK | \n", "113742244 | \n", "06 | \n", "7189979369 | \n", "7184590331 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
39 | \n", "ISYS LLC | \n", "support, professional:, program, management | \n", "6 | \n", "1.099893e+08 | \n", "4.345540e+08 | \n", "2014-10-16 00:00:00 | \n", "2018-12-08 | \n", "11715 CRIPPEN CT | \n", "NaN | \n", "GREAT FALLS | \n", "VA | \n", "VIRGINIA | \n", "220661624 | \n", "10 | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
40 | \n", "AFOGNAK NATIVE CORPORATION | \n", "support, housekeeping, facilities, operations,... | \n", "25 | \n", "1.065148e+08 | \n", "1.392211e+08 | \n", "2011-08-05 00:00:00 | \n", "2019-10-31 | \n", "3909 ARCTIC BLVD STE 400 | \n", "NaN | \n", "ANCHORAGE | \n", "AK | \n", "ALASKA | \n", "995030000 | \n", "NaN | \n", "9072229500 | \n", "9072229501 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
41 | \n", "360 IT INTEGRATED SOLUTIONS | \n", "telecom, facility, operation, maintenance, tel... | \n", "7 | \n", "9.905847e+07 | \n", "1.318722e+08 | \n", "2014-09-15 00:00:00 | \n", "2020-09-29 | \n", "1943 ISAAC NEWTON SQ E #200 | \n", "NaN | \n", "RESTON | \n", "VA | \n", "VIRGINIA | \n", "201905014 | \n", "11 | \n", "8884580345 | \n", "7034373709 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
42 | \n", "NET DIRECT SYSTEMS LLC | \n", "equipment, support, adp, information, technology | \n", "1261 | \n", "9.505704e+07 | \n", "1.345279e+08 | \n", "2010-02-01 00:00:00 | \n", "2018-12-13 | \n", "2524 RELIANCE AVE | \n", "NaN | \n", "APEX | \n", "NC | \n", "NORTH CAROLINA | \n", "275396346 | \n", "4 | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
43 | \n", "NATIVE ENERGY & TECHNOLOGY INC. | \n", "government, maintenance, owned, operated, (gogo) | \n", "9 | \n", "9.187506e+07 | \n", "3.440581e+08 | \n", "2017-06-06 08:27:49 | \n", "2027-06-05 | \n", "12793 COGBURN AVE | \n", "NaN | \n", "SAN ANTONIO | \n", "TX | \n", "TEXAS | \n", "782492239 | \n", "20 | \n", "2102316060 | \n", "2102316098 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
44 | \n", "HARRIS CORPORATION | \n", "equipment, electronic, quick, countermeasures,... | \n", "15 | \n", "8.126279e+07 | \n", "3.818081e+08 | \n", "2010-05-03 00:00:00 | \n", "2022-10-02 | \n", "2400 PALM BAY RD NE | \n", "NaN | \n", "PALM BAY | \n", "FL | \n", "FLORIDA | \n", "329053377 | \n", "8 | \n", "3217276361 | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
45 | \n", "U.S. BANCORP | \n", "support, management:, financial | \n", "4 | \n", "8.077518e+07 | \n", "1.165076e+08 | \n", "2012-09-28 00:00:00 | \n", "2023-04-27 | \n", "800 NICOLLET MALL STE 1500 | \n", "NaN | \n", "MINNEAPOLIS | \n", "MN | \n", "MINNESOTA | \n", "554027000 | \n", "05 | \n", "2022610806 | \n", "2022610800 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
46 | \n", "AIRCRAFT TRANSPORT SERVICES INC. | \n", "travel, transportation, relocation, lodging, r... | \n", "8 | \n", "7.895843e+07 | \n", "1.744191e+08 | \n", "2016-12-01 00:00:00 | \n", "2020-11-30 | \n", "4285 SW MARTIN HWY | \n", "NaN | \n", "PALM CITY | \n", "FL | \n", "FLORIDA | \n", "349908615 | \n", "18 | \n", "5612104373 | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
47 | \n", "JATOM SYSTEMS INC | \n", "software, information, technology, adp, telephone | \n", "5 | \n", "7.623178e+07 | \n", "9.659306e+07 | \n", "2011-07-20 00:00:00 | \n", "2020-01-19 | \n", "15004 NORTHRIDGE DR # 100 | \n", "NaN | \n", "CHANTILLY | \n", "VA | \n", "VIRGINIA | \n", "201513817 | \n", "10 | \n", "7034665220 | \n", "7034665299 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
48 | \n", "XL ASSOCIATES INC. | \n", "support, professional:, program, management, m... | \n", "28 | \n", "7.325194e+07 | \n", "8.224773e+07 | \n", "2014-07-11 00:00:00 | \n", "2021-11-24 | \n", "8614 WESTWOOD CENTER DR STE 700 | \n", "NaN | \n", "VIENNA | \n", "VA | \n", "VIRGINIA | \n", "221822264 | \n", "11 | \n", "7038480400 | \n", "7032569508 | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "
49 | \n", "NET DIRECT SYSTEMS LLC | \n", "adp, support, equipment, central, processing | \n", "73 | \n", "7.168369e+07 | \n", "1.407577e+08 | \n", "2011-12-28 00:00:00 | \n", "2016-02-25 | \n", "2524 RELIANCE AVE | \n", "NaN | \n", "APEX | \n", "NC | \n", "NORTH CAROLINA | \n", "275396346 | \n", "04 | \n", "NaN | \n", "NaN | \n", "2018-06-24 21:06:38.085717 | \n", "2018-06-24 | \n", "