FPDS Query
Unlock the full power of FPDS Query
Why FPDS Query is better than FPDS Atom Feed
Feature Comparison: FPDS Query vs FPDS Atom Feed
| Feature | FPDS Query | FPDS Atom Feed |
|---|---|---|
| Filter by any field |  |
|
| Combined conditions (AND, OR, IN) | |
 |
| Aggregations (SUM, AVG, COUNT) | |
|
| Grouping (GROUP BY) | |
|
| Sorting (ORDER BY) | |
Partial (date) |
| Partial (date) | |
Partial |
| Subqueries, WITH expressions | |
|
| JOIN tables | |
|
| Window functions (ROW_NUMBER, etc) | |
|
| Substring search (ILIKE, POS/CON) | |
|
| Arrays and IN conditions | |
|
| Contract version and mod analysis | |
|
| Filtering after aggregation (HAVING) | |
Partial |
| Computed fields (CASE, arithmetic) | |
Partial |
| Range filtering (BETWEEN) | |
Partial |
Choose your plan
save
20%