SHELDON-AFWERX Discussion 2023-06-09

Draft FPDS Phase III BERTopic Output and Summary Data

SHELDON-AFWERX 2023-06-09 Discussion Items

Discussion items for 2023-06-09 call.

Data Rights

Contract Number: N6833522C0500
Contractor Name: P.W. Communications, Inc.
Contractor Address: 11200 Rockville Pike Suite 130 Rockville, MD 20852
Expiration of Data Rights Period: January 16, 2029

The Government’s rights to use, modify, reproduce, release, perform, display, or disclose technical data or computer software marked with this legend are restricted during the period shown as provided in paragraph (b)(4) of the Rights in Noncommercial Technical Data and Computer Software Small Business Innovation Research (SBIR) Program clause contained in the above identified contract. No restrictions apply after the expiration date shown above. Any reproduction of technical data, computer software, or portions thereof marked with this legend must also reproduce the markings.

USASpending Contract Data Dump vs FPDS Schema

Note, the fields represent analysis data from 2023; actual number of observations much higher.

Coded Phase III Analysis

Summary Table

Coded Phase III Sunburst Chart

Note the numbers don’t match at the nested level because the sunburst chart has to exclude one of the companies with a -2M FPDS Phase III Balance at the Agency/Department level that nets out in the aggregate.

Coded Phase III by Funding Department, Agency, GNG Group and Awardee

BERTopic Text Analysis

Base Output

BERTopic Label Count Table

Distinct Texts and Labels

BERTopic Label Count Visualization

Topic Hierarchy

BERTopic Label UMAP

BERTopic Document UMAP

BERTopic Document Level UMAP