{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# ICE Contractor Analysis\n",
"By [Leon Yin](www.leonyin.org) Last Updated 2018-12-06\n",
"\n",
"View this notebook in [NBViewer](https://nbviewer.jupyter.org/github/yinleon/ice-money/blob/master/ice_money.ipynb) or [Github](https://www.github.com/yinleon/ice-money/blob/master/ice_money.ipynb).\n",
"The output is availalble publically on [Google Drive](http://bit.ly/ice-contractors) and [Github](https://raw.githubusercontent.com/yinleon/ice-money/master/ice_data/data_out/ice_prime_contractors_aggregated_clean.csv).\n",
"\n",
"Following my analysis of [federal contracts](https://nbviewer.jupyter.org/github/yinleon/us-spending/blob/master/1_analysis_methods.ipynb) 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 USASpending.gov [dashboard](https://www.usaspending.gov/#/search/1da7f3124d80741313219fd741632538), specifically I filtered `Funding Agency` with \"U.S. Immigration and Customs Enforcement (ICE) | Sub-Agency\"."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/anaconda3/lib/python3.6/site-packages/fuzzywuzzy/fuzz.py:35: UserWarning: Using slow pure-python SequenceMatcher. Install python-Levenshtein to remove this warning\n",
" warnings.warn('Using slow pure-python SequenceMatcher. Install python-Levenshtein to remove this warning')\n"
]
}
],
"source": [
"%matplotlib inline\n",
"import glob\n",
"import datetime\n",
"import string\n",
"from collections import Counter\n",
"\n",
"import numpy as np\n",
"import pandas as pd\n",
"import matplotlib.pyplot as plt\n",
"from nltk.corpus import stopwords\n",
"from fuzzywuzzy import fuzz"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"# data downloaded from USAspending.gov\n",
"input_file_pattern = 'ice_data/data_in/all_prime_awards_subawards_*/*'"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['ice_data/data_in/all_prime_awards_subawards_20181206050302/all_contracts_subawards_1.csv',\n",
" 'ice_data/data_in/all_prime_awards_subawards_20181206050302/all_contracts_prime_awards_1.csv',\n",
" 'ice_data/data_in/all_prime_awards_subawards_20181206050302/all_assistance_prime_awards_1.csv',\n",
" 'ice_data/data_in/all_prime_awards_subawards_20181206050302/all_assistance_subawards_1.csv']"
]
},
"execution_count": 3,
"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": 4,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/anaconda3/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2698: DtypeWarning: Columns (13,32,40,42,43,50,72,73,81,100,128,129) 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[1])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Something to note here, if we don't filter out funding agency we get some inaccuracies!"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'awarding_sub_agency_name': 'U.S. IMMIGRATION AND CUSTOMS ENFORCEMENT',\n",
" 'funding_sub_agency_name': 'U.S. IMMIGRATION AND CUSTOMS ENFORCEMENT'}"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"{\n",
" 'awarding_sub_agency_name' : 'U.S. IMMIGRATION AND CUSTOMS ENFORCEMENT', # N = 15056\n",
" 'funding_sub_agency_name' : 'U.S. IMMIGRATION AND CUSTOMS ENFORCEMENT', # N = 17145\n",
"}"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"15056"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# here we're filtering only when ICE awards a contract\n",
"df_prime_contracts = df_prime_contracts[\n",
" df_prime_contracts['awarding_sub_agency_name'] == 'U.S. IMMIGRATION AND CUSTOMS ENFORCEMENT'\n",
"]\n",
"\n",
"len(df_prime_contracts)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"There are 249 columns in this file!\n",
"Here are some of the column names:\n"
]
},
{
"data": {
"text/plain": [
"['award_id_piid',\n",
" 'parent_award_agency_id',\n",
" 'parent_award_agency_name',\n",
" 'parent_award_id',\n",
" 'obligated_amount',\n",
" 'current_total_value_of_award',\n",
" 'potential_total_value_of_award',\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',\n",
" 'awarding_sub_agency_name',\n",
" 'awarding_office_code',\n",
" 'awarding_office_name',\n",
" 'funding_agency_code',\n",
" 'funding_agency_name',\n",
" 'funding_sub_agency_code']"
]
},
"execution_count": 7,
"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",
"`funding_sub_agency_name`
\n",
"A Funding Agency pays for the majority of funds for an award out of its budget. Typically, the Funding Agency is the same as the Awarding Agency. In some cases, one agency will administer an award (Awarding Agency) and another agency will pay for it (Funding Agency).\n",
"\n",
"`awarding_sub_agency_name`
\n",
"The Awarding Sub Agency is the sub agency that issues and administers the award. For example, the Internal Revenue Service (IRS) is a sub agency of the Department of the Treasury.\n",
"\n",
"
\n", " | Recipient Parent Name | \n", "Recipient Parent Duns | \n", "Top Words From Serv Desc | \n", "Number Of Prime Awards | \n", "Current Total Value Of Awards Usd | \n", "Potential Total Value Of Awards Usd | \n", "Remaining Total Value Of Awards Usd | \n", "Award Id Piids | \n", "First Contract Start Date | \n", "Last Contract End Date | \n", "... | \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", "SCIENCE APPLICATIONS INTERNATIONAL CORPORATION | \n", "078745061 | \n", "telecom, systems, development, analysis, house... | \n", "8 | \n", "5.322573e+08 | \n", "7.048101e+08 | \n", "1.725527e+08 | \n", "HSCETC09J00034, HSCETC10J00005, HSCOW5D0056, H... | \n", "2015-06-04 | \n", "2015-09-24 | \n", "... | \n", "NaN | \n", "MCLEAN | \n", "VA | \n", "VIRGINIA | \n", "22102 | \n", "NaN | \n", "7036765681 | \n", "7036765063 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
1 | \n", "THE GEO GROUP INC | \n", "612706465 | \n", "guard, housekeeping, services, support, profes... | \n", "56 | \n", "5.295999e+08 | \n", "2.641455e+09 | \n", "2.111855e+09 | \n", "70CDCR18FR0000045, HSCEDM11J00054, 70CDCR18FR0... | \n", "2007-06-01 | \n", "2029-10-11 | \n", "... | \n", "NaN | \n", "BOCA RATON | \n", "FL | \n", "FLORIDA | \n", "334878242 | \n", "22 | \n", "5619997359 | \n", "5619997648 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
2 | \n", "CSI AVIATION SERVICES INC. | \n", "102793460 | \n", "travel, air, passenger, transportation, reloca... | \n", "15 | \n", "5.213086e+08 | \n", "6.580096e+08 | \n", "1.367010e+08 | \n", "HSCECR14F00009, HSCECR14F00010, HSCECR14F00015... | \n", "2009-10-05 | \n", "2018-06-30 | \n", "... | \n", "NaN | \n", "ALBUQUERQUE | \n", "NM | \n", "NEW MEXICO | \n", "871072876 | \n", "01 | \n", "5057619000 | \n", "5053427377 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
3 | \n", "INGENESIS INC. | \n", "019992424 | \n", "medical, general, health, care | \n", "2 | \n", "3.335133e+08 | \n", "4.491412e+08 | \n", "1.156279e+08 | \n", "70CDCR18C00000002, HSCECR12F00048 | \n", "2018-08-06 | \n", "2018-11-15 | \n", "... | \n", "NaN | \n", "SAN ANTONIO | \n", "TX | \n", "TEXAS | \n", "782174430 | \n", "21 | \n", "2103660033 | \n", "2105684582 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
4 | \n", "M V M INC. | \n", "038049532 | \n", "support, housekeeping, guard, administrative, ... | \n", "38 | \n", "2.611629e+08 | \n", "1.086340e+09 | \n", "8.251771e+08 | \n", "70CMSW18FR0000058, HSCEMS17F00040, HSCEDM14J00... | \n", "2010-09-20 | \n", "2023-01-31 | \n", "... | \n", "NaN | \n", "ASHBURN | \n", "VA | \n", "VIRGINIA | \n", "201476063 | \n", "10 | \n", "5712234620 | \n", "5712234487 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
5 | \n", "GENERAL DYNAMICS CORPORATION | \n", "001381284 | \n", "support, ammunition, 30mm, equipment, professi... | \n", "52 | \n", "2.480584e+08 | \n", "4.923976e+08 | \n", "2.443392e+08 | \n", "HSCEMD16F00117, HSCETC16J00002, HSCEMD15F00113... | \n", "2011-04-07 | \n", "2021-09-24 | \n", "... | \n", "NaN | \n", "CHANTILLY | \n", "VA | \n", "VIRGINIA | \n", "201513848 | \n", "10 | \n", "7038761243 | \n", "7038761243 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
6 | \n", "NANA REGIONAL CORPORATION INC | \n", "079253761 | \n", "housekeeping, guard | \n", "13 | \n", "2.451490e+08 | \n", "1.172830e+09 | \n", "9.276814e+08 | \n", "HSCEDM15J00019, 70CDCR18FR0000051, 70CDCR18FR0... | \n", "2016-06-21 | \n", "2024-04-30 | \n", "... | \n", "NaN | \n", "ANCHORAGE | \n", "AK | \n", "ALASKA | \n", "99502 | \n", "00 | \n", "7037666837 | \n", "7037666906 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
7 | \n", "CORRECTIONS CORPORATION OF AMERICA | \n", "159734151 | \n", "guard, housekeeping, support, services, profes... | \n", "32 | \n", "2.415587e+08 | \n", "6.227455e+08 | \n", "3.811868e+08 | \n", "70CDCR18FR0000058, 70CDCR18FR0000017, 70CDCR18... | \n", "2010-04-29 | \n", "2019-06-30 | \n", "... | \n", "NaN | \n", "NASHVILLE | \n", "TN | \n", "TENNESSEE | \n", "372156105 | \n", "05 | \n", "6152636713 | \n", "6152633090 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
8 | \n", "SPECTRUM SECURITY SERVICES INC. | \n", "6.18954e+08 | \n", "guard, housekeeping, services | \n", "13 | \n", "1.927423e+08 | \n", "3.628039e+08 | \n", "1.700616e+08 | \n", "70CDCR18FC0000013, 70CDCR18FC0000012, 70CDCR18... | \n", "2009-12-09 | \n", "2019-10-31 | \n", "... | \n", "NaN | \n", "JAMUL | \n", "CA | \n", "CALIFORNIA | \n", "9.19353e+08 | \n", "50 | \n", "NaN | \n", "NaN | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
9 | \n", "DELOITTE LLP | \n", "014127109 | \n", "support, management, professional, program, fi... | \n", "83 | \n", "1.779484e+08 | \n", "3.771559e+08 | \n", "1.992075e+08 | \n", "70CMSW18FR0000103, 70CMSW18FC0000097, HSCEMS17... | \n", "2011-08-29 | \n", "2023-09-29 | \n", "... | \n", "NaN | \n", "ARLINGTON | \n", "VA | \n", "VIRGINIA | \n", "222091742 | \n", "08 | \n", "5718580176 | \n", "7038426748 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
10 | \n", "AHTNA INCORPORATED | \n", "6.95861e+07 | \n", "housekeeping, guard, maint, rep, alt | \n", "9 | \n", "1.421123e+08 | \n", "4.689208e+08 | \n", "3.268086e+08 | \n", "70CDCR19FR0000003, 70CDCR18FR0000003, HSCEDM17... | \n", "2011-10-21 | \n", "2019-11-30 | \n", "... | \n", "NaN | \n", "ANCHORAGE | \n", "AK | \n", "ALASKA | \n", "995035677 | \n", "00 | \n", "9073346477 | \n", "9073346750 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
11 | \n", "CLASSIC AIR CHARTER INC. | \n", "9.61705e+08 | \n", "travel, transportation, relocation, lodging, r... | \n", "1 | \n", "1.420237e+08 | \n", "6.518740e+08 | \n", "5.098503e+08 | \n", "70CDCR18FR0000002 | \n", "2018-11-14 | \n", "2023-06-30 | \n", "... | \n", "NaN | \n", "HUNTINGTON | \n", "NY | \n", "NEW YORK | \n", "1.17433e+08 | \n", "03 | \n", "6.3155e+09 | \n", "NaN | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
12 | \n", "TRAILBOSS ENTERPRISES INC. | \n", "879740454 | \n", "housekeeping, guard, facilities, operations, s... | \n", "6 | \n", "1.187095e+08 | \n", "5.630046e+08 | \n", "4.442951e+08 | \n", "70CDCR18FR0000159, 70CDCR18FR0000075, 70CDCR18... | \n", "2018-07-18 | \n", "2019-09-27 | \n", "... | \n", "NaN | \n", "ANCHORAGE | \n", "AK | \n", "ALASKA | \n", "995012503 | \n", "00 | \n", "9073388243 | \n", "9073380869 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
13 | \n", "BOOZ ALLEN HAMILTON HOLDING CORPORATION | \n", "964725688 | \n", "support, professional, management, telecom, pr... | \n", "23 | \n", "1.099139e+08 | \n", "3.423611e+08 | \n", "2.324473e+08 | \n", "70CTD018FR0000193, HSCEMD17F00080, HSCETC15F00... | \n", "2013-02-05 | \n", "2024-03-06 | \n", "... | \n", "NaN | \n", "MCLEAN | \n", "VA | \n", "VIRGINIA | \n", "221023830 | \n", "11 | \n", "7033770195 | \n", "7039023200 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
14 | \n", "ASSET PROTECTION & SECURITY SERVICES L.P. | \n", "009741828 | \n", "housekeeping, guard, oper, govt, misc | \n", "11 | \n", "9.983111e+07 | \n", "3.326429e+08 | \n", "2.328118e+08 | \n", "HSCEDM16J00022, HSCEDM16J00018, HSCEDM15J00018... | \n", "2012-02-15 | \n", "2018-12-28 | \n", "... | \n", "NaN | \n", "CORPUS CHRISTI | \n", "TX | \n", "TEXAS | \n", "784133787 | \n", "27 | \n", "3619061552 | \n", "3619061844 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
15 | \n", "GLOBAL PRECISION SYSTEMS LLC | \n", "805596710 | \n", "housekeeping, guard, tableware | \n", "9 | \n", "9.716002e+07 | \n", "4.184622e+08 | \n", "3.213022e+08 | \n", "70CDCR18FR0000134, 70CDCR18FR0000061, HSCEDM17... | \n", "2017-05-15 | \n", "2022-09-29 | \n", "... | \n", "NaN | \n", "NOME | \n", "AK | \n", "ALASKA | \n", "99762 | \n", "00 | \n", "9073348308 | \n", "9075632742 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
16 | \n", "STG INTERNATIONAL INC. | \n", "179570403 | \n", "support, professional, program, management, ad... | \n", "25 | \n", "8.962683e+07 | \n", "4.524422e+08 | \n", "3.628154e+08 | \n", "70CDCR18C00000003, HSCEMS13F00071, HSCEMD13F00... | \n", "2009-07-16 | \n", "2023-06-28 | \n", "... | \n", "NaN | \n", "ALEXANDRIA | \n", "VA | \n", "VIRGINIA | \n", "223145504 | \n", "08 | \n", "7035786030 | \n", "5712556545 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
17 | \n", "SAVANTAGE FINANCIAL SERVICES INC. | \n", "878187012 | \n", "telecom, telecommunications | \n", "2 | \n", "8.604917e+07 | \n", "1.302544e+08 | \n", "4.420525e+07 | \n", "HSCETC17F00002, HSCETC12F00013 | \n", "2017-11-22 | \n", "2020-12-31 | \n", "... | \n", "NaN | \n", "ROCKVILLE | \n", "MD | \n", "MARYLAND | \n", "208504339 | \n", "08 | \n", "NaN | \n", "NaN | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
18 | \n", "PALANTIR TECHNOLOGIES INC. | \n", "3.62131e+08 | \n", "data, telecom, information, broadcasting, dist... | \n", "6 | \n", "7.103665e+07 | \n", "1.696240e+08 | \n", "9.858732e+07 | \n", "70CTD019C00000001, HSCETC15C00001, HSCETC13F00... | \n", "2013-09-13 | \n", "2021-11-27 | \n", "... | \n", "NaN | \n", "PALO ALTO | \n", "CA | \n", "CALIFORNIA | \n", "9.43012e+08 | \n", "18 | \n", "6.50815e+09 | \n", "6.50618e+09 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
19 | \n", "DEV TECHNOLOGY GROUP INC. | \n", "105667401 | \n", "telecom, services, programming, systems, devel... | \n", "15 | \n", "6.771468e+07 | \n", "1.370574e+08 | \n", "6.934275e+07 | \n", "HSCETC16J00057, HSCETC16J00026, HSCETC17J00004... | \n", "2012-06-28 | \n", "2022-02-28 | \n", "... | \n", "NaN | \n", "RESTON | \n", "VA | \n", "VIRGINIA | \n", "201905041 | \n", "11 | \n", "7038608135 | \n", "7038608138 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
20 | \n", "PHACIL INC. | \n", "054885111 | \n", "telecom, help, desk | \n", "1 | \n", "6.757944e+07 | \n", "6.969906e+07 | \n", "2.119618e+06 | \n", "HSCETC12F00014 | \n", "2018-09-05 | \n", "2019-03-09 | \n", "... | \n", "NaN | \n", "MCLEAN | \n", "VA | \n", "VIRGINIA | \n", "221023590 | \n", "11 | \n", "7035261852 | \n", "7037377100 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
21 | \n", "PERSPECTA INC. | \n", "081218565 | \n", "telecom, data, centers, storage, support | \n", "3 | \n", "6.156383e+07 | \n", "8.597697e+07 | \n", "2.441314e+07 | \n", "HSCETE15J00227, 70CMSD18FC0000012, HSCETC08F00013 | \n", "2018-09-21 | \n", "2020-06-26 | \n", "... | \n", "NaN | \n", "HERNDON | \n", "VA | \n", "VIRGINIA | \n", "201713299 | \n", "11 | \n", "7037333793 | \n", "7037422674 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
22 | \n", "CACI INTERNATIONAL INC | \n", "045534641 | \n", "support, professional, miscellaneous, communic... | \n", "4 | \n", "5.923109e+07 | \n", "9.455504e+07 | \n", "3.532395e+07 | \n", "HSCEMS16J00065, HSCEMD14FAF003, HSCEMD10F00260... | \n", "2014-04-14 | \n", "2021-03-17 | \n", "... | \n", "NaN | \n", "CHANTILLY | \n", "VA | \n", "VIRGINIA | \n", "201512218 | \n", "10 | \n", "7036794137 | \n", "7036793402 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
23 | \n", "WIDEPOINT CORPORATION | \n", "788549012 | \n", "support, professional, program, management | \n", "2 | \n", "5.494329e+07 | \n", "2.127748e+08 | \n", "1.578315e+08 | \n", "HSCETE15F00007, HSCETE15F00002 | \n", "2017-03-23 | \n", "2018-12-08 | \n", "... | \n", "NaN | \n", "MC LEAN | \n", "VA | \n", "VIRGINIA | \n", "221023371 | \n", "11 | \n", "7033495644 | \n", "7038483560 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
24 | \n", "MAXIM HEALTHCARE SERVICES INC. | \n", "606290401 | \n", "medical, general, health, care | \n", "3 | \n", "5.416702e+07 | \n", "5.416702e+07 | \n", "0.000000e+00 | \n", "HSCEDM17C00002, HSCEDM15C00004, HSCEDM14C00005 | \n", "2016-08-05 | \n", "2018-11-22 | \n", "... | \n", "NaN | \n", "COLUMBIA | \n", "MD | \n", "MARYLAND | \n", "210463236 | \n", "03 | \n", "4109101553 | \n", "4109101615 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
25 | \n", "NET DIRECT SYSTEMS LLC | \n", "5.40078e+07 | \n", "equipment, support, information, technology, adp | \n", "931 | \n", "4.864500e+07 | \n", "5.851272e+07 | \n", "9.867719e+06 | \n", "70CTD018FC0000010, HSCETE17J00388, HSCETE17J00... | \n", "2010-03-22 | \n", "2018-12-13 | \n", "... | \n", "NaN | \n", "APEX | \n", "NC | \n", "NORTH CAROLINA | \n", "2.75396e+08 | \n", "04 | \n", "NaN | \n", "NaN | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
26 | \n", "THE MITRE CORPORATION | \n", "007872690 | \n", "development, support, engineering, r, research | \n", "12 | \n", "4.857490e+07 | \n", "4.913481e+07 | \n", "5.599040e+05 | \n", "70CMSW18FR0000119, HSCETC16J00004, HSCETC16J00... | \n", "2010-08-31 | \n", "2019-09-28 | \n", "... | \n", "NaN | \n", "MC LEAN | \n", "VA | \n", "VIRGINIA | \n", "221027539 | \n", "08 | \n", "7039836474 | \n", "7039837121 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
27 | \n", "GRANT THORNTON INTERNATIONAL LTD | \n", "3.47201e+08 | \n", "support, management, professional, program, fi... | \n", "24 | \n", "4.768990e+07 | \n", "1.035107e+08 | \n", "5.582075e+07 | \n", "70CMSD18FC0000060, 70CMSW18FC0000076, 70CMSD18... | \n", "2011-07-11 | \n", "2024-03-09 | \n", "... | \n", "NaN | \n", "ALEXANDRIA | \n", "VA | \n", "VIRGINIA | \n", "223145767 | \n", "08 | \n", "NaN | \n", "NaN | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
28 | \n", "KNIGHT POINT SYSTEMS LLC | \n", "622594492 | \n", "telecom, help, desk, support, telecommunications | \n", "4 | \n", "4.439087e+07 | \n", "7.911528e+07 | \n", "3.472440e+07 | \n", "HSCETC16J00050, 70CTD018FR0000058, HSCETC14J00... | \n", "2014-07-24 | \n", "2021-06-29 | \n", "... | \n", "NaN | \n", "RESTON | \n", "VA | \n", "VIRGINIA | \n", "201905109 | \n", "11 | \n", "7036577051 | \n", "5712663106 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
29 | \n", "U.S. BANCORP | \n", "006213482 | \n", "support, management, financial | \n", "2 | \n", "4.063902e+07 | \n", "5.850522e+07 | \n", "1.786619e+07 | \n", "70CTD018C00000001, HSCEMD12C00003 | \n", "2018-03-23 | \n", "2023-04-27 | \n", "... | \n", "NaN | \n", "MINNEAPOLIS | \n", "MN | \n", "MINNESOTA | \n", "554027000 | \n", "05 | \n", "2022610806 | \n", "2022610800 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
30 | \n", "CAP GEMINI | \n", "382014330 | \n", "support, professional, program, management, se... | \n", "13 | \n", "3.812979e+07 | \n", "8.017269e+07 | \n", "4.204290e+07 | \n", "70CDCR18FC0000021, HSCEMS16F00054, HSCEMS17F00... | \n", "2010-08-16 | \n", "2023-06-30 | \n", "... | \n", "NaN | \n", "RESTON | \n", "VA | \n", "VIRGINIA | \n", "201911560 | \n", "11 | \n", "5713361618 | \n", "5713361700 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
31 | \n", "JACOBS ENGINEERING GROUP INC. | \n", "074103508 | \n", "telecom, telecommunications, transmission, sys... | \n", "2 | \n", "3.640971e+07 | \n", "3.772398e+07 | \n", "1.314267e+06 | \n", "HSCETC16F00018, HSCOW3D0603 | \n", "2018-04-06 | \n", "2018-09-08 | \n", "... | \n", "NaN | \n", "RESTON | \n", "VA | \n", "VIRGINIA | \n", "201905380 | \n", "11 | \n", "7038964000 | \n", "NaN | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
32 | \n", "INTERNATIONAL BUSINESS MACHINES CORPORATION | \n", "1.36808e+06 | \n", "software, adp, information, technology, support | \n", "14 | \n", "3.244281e+07 | \n", "3.516806e+07 | \n", "2.725246e+06 | \n", "70CTD018FR0000377, HSCETC14F00043, HSCETC09J00... | \n", "2011-09-15 | \n", "2019-03-31 | \n", "... | \n", "NaN | \n", "BETHESDA | \n", "MD | \n", "MARYLAND | \n", "208171834 | \n", "08 | \n", "8003336705 | \n", "8885200533 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
33 | \n", "VISTA OUTDOOR SALES LLC | \n", "079728394 | \n", "30mm, ammunition, guns, 75mm, miscellaneous | \n", "236 | \n", "2.907978e+07 | \n", "2.857832e+08 | \n", "2.567034e+08 | \n", "70CMSW18FR0000023, HSCEMS16J00074, 70CMSW18FR0... | \n", "2016-03-22 | \n", "2022-09-26 | \n", "... | \n", "NaN | \n", "ANOKA | \n", "MN | \n", "MINNESOTA | \n", "553036794 | \n", "06 | \n", "7637126056 | \n", "7633232506 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
34 | \n", "360 IT INTEGRATED SOLUTIONS | \n", "962373515 | \n", "telecom, telecommunications, facility, operati... | \n", "2 | \n", "2.885949e+07 | \n", "3.252903e+07 | \n", "3.669532e+06 | \n", "HSCETC16J00055, HSCETC14J00117 | \n", "2018-09-21 | \n", "2020-09-29 | \n", "... | \n", "NaN | \n", "RESTON | \n", "VA | \n", "VIRGINIA | \n", "201905014 | \n", "11 | \n", "8884580345 | \n", "7034373709 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
35 | \n", "DENALI HOLDING INC | \n", "6.0184e+08 | \n", "software, information, technology, adp, compon... | \n", "171 | \n", "2.823319e+07 | \n", "4.828102e+07 | \n", "2.004783e+07 | \n", "HSCETE16J00107, HSCETE15J00642, HSCETE16J00069... | \n", "2014-11-20 | \n", "2020-08-25 | \n", "... | \n", "NaN | \n", "ROUND ROCK | \n", "TX | \n", "TEXAS | \n", "7.86827e+08 | \n", "31 | \n", "5.12729e+09 | \n", "5.12283e+09 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
36 | \n", "DTC COMMUNICATIONS INC. | \n", "611639688 | \n", "equipment, recording, reproducing, video, sound | \n", "27 | \n", "2.762288e+07 | \n", "3.817939e+07 | \n", "1.055651e+07 | \n", "70CMSD18FR0000267, 70CMSD18FR0000189, 70CMSD18... | \n", "2016-10-25 | \n", "2019-03-29 | \n", "... | \n", "NaN | \n", "PINELLAS PARK | \n", "FL | \n", "FLORIDA | \n", "337826132 | \n", "13 | \n", "7274716988 | \n", "7274716773 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
37 | \n", "NATIVE ENERGY & TECHNOLOGY INC. | \n", "080778868 | \n", "government, maintenance, owned, operated, gogo | \n", "1 | \n", "2.706727e+07 | \n", "5.421699e+07 | \n", "2.714972e+07 | \n", "HSCEMR17F00041 | \n", "2018-10-18 | \n", "2027-06-05 | \n", "... | \n", "NaN | \n", "SAN ANTONIO | \n", "TX | \n", "TEXAS | \n", "782492239 | \n", "20 | \n", "2102316060 | \n", "2102316098 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
38 | \n", "XL ASSOCIATES INC. | \n", "6.08717e+08 | \n", "support, management, professional, program, data | \n", "19 | \n", "2.683397e+07 | \n", "3.480865e+07 | \n", "7.974672e+06 | \n", "70CMSW18FC0000104, HSCETC16J00047, HSCEMR15F00... | \n", "2014-07-11 | \n", "2023-07-14 | \n", "... | \n", "NaN | \n", "VIENNA | \n", "VA | \n", "VIRGINIA | \n", "221822264 | \n", "11 | \n", "7038480400 | \n", "7032569508 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
39 | \n", "MCKINSEY & COMPANY INC. | \n", "001673920 | \n", "support, management, professional | \n", "3 | \n", "2.657078e+07 | \n", "3.180656e+07 | \n", "5.235783e+06 | \n", "HSCECR16F00004, HSCECR17F00003, HSCECR16F00001 | \n", "2017-04-05 | \n", "2019-03-20 | \n", "... | \n", "NaN | \n", "WASHINGTON | \n", "DC | \n", "DISTRICT OF COLUMBIA | \n", "200362412 | \n", "00 | \n", "2026621185 | \n", "2026623256 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
40 | \n", "METROPOLITAN INTERPRETERS & TRANSLATORS INC | \n", "186945325 | \n", "support, administrative, translation, interpre... | \n", "18 | \n", "2.591282e+07 | \n", "2.920811e+07 | \n", "3.295290e+06 | \n", "HSCEMD17F00215, HSCEMD16F00142, HSCEMD15J00067... | \n", "2010-09-14 | \n", "2019-03-16 | \n", "... | \n", "NaN | \n", "NEW YORK | \n", "NY | \n", "NEW YORK | \n", "100178538 | \n", "12 | \n", "2136734710 | \n", "2136734711 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
41 | \n", "UNIVERSAL LANGUAGE CORPORATION | \n", "961404241 | \n", "support, administrative, translation, interpre... | \n", "9 | \n", "2.411732e+07 | \n", "4.469079e+07 | \n", "2.057347e+07 | \n", "HSCEMD09J00229, HSCEMD09J00240, HSCENV08JCL016... | \n", "2007-09-10 | \n", "2014-03-22 | \n", "... | \n", "NaN | \n", "REGO PARK | \n", "NY | \n", "NEW YORK | \n", "113742244 | \n", "06 | \n", "7189979369 | \n", "7184590331 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
42 | \n", "ACCENTURE INC. | \n", "985015354 | \n", "telecom, cyber, security, data, backup | \n", "3 | \n", "2.380236e+07 | \n", "3.929861e+07 | \n", "1.549624e+07 | \n", "HSCETC16F00019, HSCETE14A00005, HSCETC15A00008 | \n", "2017-04-27 | \n", "2021-09-27 | \n", "... | \n", "NaN | \n", "ALEXANDRIA | \n", "VA | \n", "VIRGINIA | \n", "223141552 | \n", "08 | \n", "5407299926 | \n", "5713662006 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
43 | \n", "PROCENTRIX INC. | \n", "626154640 | \n", "telecom, systems, development, strategy, archi... | \n", "10 | \n", "2.337984e+07 | \n", "2.365943e+07 | \n", "2.795936e+05 | \n", "HSCETC17F00005, HSCETC16J00060, HSCETC15J00048... | \n", "2013-03-13 | \n", "2019-05-31 | \n", "... | \n", "NaN | \n", "HERNDON | \n", "VA | \n", "VIRGINIA | \n", "201714583 | \n", "11 | \n", "7036352627 | \n", "7036352629 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
44 | \n", "DYNAMIS INC. | \n", "809429728 | \n", "support, professional, program, management | \n", "3 | \n", "2.199776e+07 | \n", "2.604925e+07 | \n", "4.051484e+06 | \n", "70CMSD18FR0000184, 70CMSD18FR0000217, HSCEMD13... | \n", "2018-08-23 | \n", "2023-09-16 | \n", "... | \n", "NaN | \n", "FAIRFAX | \n", "VA | \n", "VIRGINIA | \n", "220314504 | \n", "11 | \n", "7034654400 | \n", "7034654488 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
45 | \n", "MOTOROLA INC | \n", "1.32546e+06 | \n", "equipment, communication, radio, television, a... | \n", "54 | \n", "2.193658e+07 | \n", "2.415277e+07 | \n", "2.216185e+06 | \n", "70CMSD18P00000143, HSCEMS17J00177, HSCEMS16J00... | \n", "2010-10-18 | \n", "2023-08-31 | \n", "... | \n", "NaN | \n", "LINTHICUM HEIGHTS | \n", "MD | \n", "MARYLAND | \n", "210902535 | \n", "03 | \n", "4107126545 | \n", "4107126501 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
46 | \n", "HARRIS CORPORATION | \n", "4.20334e+06 | \n", "equipment, countermeasures, electronic, counte... | \n", "17 | \n", "2.127281e+07 | \n", "2.130907e+07 | \n", "3.626050e+04 | \n", "HSCEMD17P00004, 70CMSD18P00000076, 70CMSD18P00... | \n", "2012-10-12 | \n", "2022-10-02 | \n", "... | \n", "NaN | \n", "PALM BAY | \n", "FL | \n", "FLORIDA | \n", "329053377 | \n", "08 | \n", "3217276361 | \n", "NaN | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
47 | \n", "JAVA PRODUCTIONS INC. | \n", "143692858 | \n", "support, professional, program, management | \n", "1 | \n", "2.090808e+07 | \n", "2.243571e+07 | \n", "1.527626e+06 | \n", "HSCEMD14F00041 | \n", "2018-07-10 | \n", "2019-10-29 | \n", "... | \n", "NaN | \n", "BLACKSBURG | \n", "VA | \n", "VIRGINIA | \n", "240605130 | \n", "09 | \n", "5408183098 | \n", "5403013615 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
48 | \n", "K'OYITL'OTS'INA LIMITED | \n", "9.43393e+08 | \n", "facilities, government, housekeeping, support,... | \n", "30 | \n", "1.949453e+07 | \n", "4.086089e+07 | \n", "2.136636e+07 | \n", "70CMSW18FR0000015, HSCEMS16C00006, HSCEMS16C00... | \n", "2012-05-10 | \n", "2023-02-28 | \n", "... | \n", "NaN | \n", "FAIRBANKS | \n", "AK | \n", "ALASKA | \n", "997094175 | \n", "00 | \n", "9074528119 | \n", "9074528109 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
49 | \n", "ENGILITY CORPORATION | \n", "7.83838e+08 | \n", "support, professional, program, management, legal | \n", "18 | \n", "1.874999e+07 | \n", "1.874999e+07 | \n", "0.000000e+00 | \n", "HSCEMD16FAF001, HSCEMS14F00057, HSCEMD12F00018... | \n", "2013-02-22 | \n", "2016-09-30 | \n", "... | \n", "NaN | \n", "ASHBURN | \n", "VA | \n", "VIRGINIA | \n", "201475060 | \n", "10 | \n", "5712918900 | \n", "5712918957 | \n", "2018-12-06 01:30:13.766382 | \n", "2018-12-06 | \n", "
50 rows Ć 21 columns
\n", "