home / portal

procurement_vendor_payments

Pre-aggregated checkbook totals per vendor string at rung L1/L2. net_usd sums debit and credit rows together and is allowed to be negative. Two strings can reach the same checkbook name, so summing this table's rows double-counts — it is a per-vendor lookup, not a total.

928 rows

This data as json, CSV (advanced)

Suggested facets: rung, n_checkbook_names, n_checkbook_vendor_ids, credits_usd, n_credits, n_credits_paired, n_credits_unpaired, first_check_date (date), last_check_date (date), computed_at (date)

Link rowid ▼ vendor_string rung n_checkbook_names n_checkbook_vendor_ids n_rows gross_debits_usd credits_usd net_usd n_credits n_credits_paired n_credits_unpaired first_check_date last_check_date computed_at run_id
1 1 22Vets LLC L2 1 1 37 225645.5 0.0 225645.5 0 0 0 2023-03-06 2026-09-16 2026-11-21T22:36:21Z pv-c6b0d6196bc9
2 2 3-D SMART STRUCTURES, INC. L1 1 1 10 163419.28 -10000.0 153419.28 1 1 0 2024-08-01 2026-09-15 2026-11-21T22:36:21Z pv-c6b0d6196bc9
3 3 34 NORTHSIDE HOLDINGS, LLC L1 1 1 55 160319.9 0.0 160319.9 0 0 0 2023-01-25 2025-11-12 2026-11-21T22:36:21Z pv-c6b0d6196bc9
4 4 3P, Inc. L2 1 1 11 506693.37 0.0 506693.37 0 0 0 2023-09-06 2025-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
5 5 8West, LLC L2 1 1 17 81479.96 0.0 81479.96 0 0 0 2022-12-05 2025-09-19 2026-11-21T22:36:21Z pv-c6b0d6196bc9
6 6 8West, LLC. L2 1 1 17 81479.96 0.0 81479.96 0 0 0 2022-12-05 2025-09-19 2026-11-21T22:36:21Z pv-c6b0d6196bc9
7 7 A ADVANCE TOWING & AUTO REPAIR, LLC L1 1 1 31 13320.0 0.0 13320.0 0 0 0 2022-11-09 2026-07-09 2026-11-21T22:36:21Z pv-c6b0d6196bc9
8 8 A Clean Environment USVI, LLC L2 1 1 82 1152885.6 0.0 1152885.6 0 0 0 2022-11-07 2025-06-13 2026-11-21T22:36:21Z pv-c6b0d6196bc9
9 9 A TOUCH OF ELEGANCE, LLC L1 1 1 1 1150.0 0.0 1150.0 0 0 0 2026-02-03 2026-02-03 2026-11-21T22:36:21Z pv-c6b0d6196bc9
10 10 A-9 Trucking Enterprise Inc. L2 1 1 12 3096518.99 0.0 3096518.99 0 0 0 2023-03-27 2026-08-14 2026-11-21T22:36:21Z pv-c6b0d6196bc9
11 11 A.S.A.P TOWING SERVICES, LLC L1 1 1 1 200.0 0.0 200.0 0 0 0 2026-05-13 2026-05-13 2026-11-21T22:36:21Z pv-c6b0d6196bc9
12 12 A/C Cooling Systems, LLC L2 1 1 161 533934.9 0.0 533934.9 0 0 0 2022-10-03 2024-11-26 2026-11-21T22:36:21Z pv-c6b0d6196bc9
13 13 ABC Janitors of St Croix INC L2 1 1 74 126678.22 0.0 126678.22 0 0 0 2022-10-18 2026-09-14 2026-11-21T22:36:21Z pv-c6b0d6196bc9
14 14 ABC Sales & Services Inc L2 2 2 215 257807.0 0.0 257807.0 0 0 0 2022-10-05 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
15 15 ABC Sales & Services, Inc L2 2 2 215 257807.0 0.0 257807.0 0 0 0 2022-10-05 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
16 16 ABS PRINTING, LLC L1 1 1 151 498012.96 0.0 498012.96 0 0 0 2022-10-20 2026-09-29 2026-11-21T22:36:21Z pv-c6b0d6196bc9
17 17 ACD Telecom, LLC L2 1 1 2 40450.0 0.0 40450.0 0 0 0 2024-04-09 2024-05-23 2026-11-21T22:36:21Z pv-c6b0d6196bc9
18 18 ACF/GOLDEN GROVE INMATES FUND L1 1 1 48 303365.0 0.0 303365.0 0 0 0 2022-11-07 2026-05-19 2026-11-21T22:36:21Z pv-c6b0d6196bc9
19 19 ACTION TECH SOLUTIONS, LLC L1 1 1 91 195717.2 0.0 195717.2 0 0 0 2022-11-21 2026-09-21 2026-11-21T22:36:21Z pv-c6b0d6196bc9
20 20 ADSL LLC L1 1 1 1 21600.0 0.0 21600.0 0 0 0 2026-09-30 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
21 21 ADVANTAGE SOFTWARE INC. L1 1 1 5 3354.0 0.0 3354.0 0 0 0 2023-02-27 2025-07-21 2026-11-21T22:36:21Z pv-c6b0d6196bc9
22 22 AE Services, LLC L2 1 1 33 73502.81 0.0 73502.81 0 0 0 2025-06-23 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
23 23 AECOM Caribe, LLP L2 1 1 13 1753628.66 0.0 1753628.66 0 0 0 2023-11-28 2024-04-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
24 24 ALM Holding Co. Inc. L2 1 1 47 370275.0 0.0 370275.0 0 0 0 2022-11-07 2026-08-10 2026-11-21T22:36:21Z pv-c6b0d6196bc9
25 25 AMAZON WEB SERVICES, INC. L1 1 1 45 79867.83 0.0 79867.83 0 0 0 2026-03-06 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
26 26 AMBROSIA LANDSCAPING, LLC L1 1 1 5 13950.0 0.0 13950.0 0 0 0 2026-05-11 2026-07-29 2026-11-21T22:36:21Z pv-c6b0d6196bc9
27 27 AMERICAN MEDIATION INSTITUTE, INC L1 1 1 29 27482.29 0.0 27482.29 0 0 0 2023-02-21 2026-09-17 2026-11-21T22:36:21Z pv-c6b0d6196bc9
28 28 ANNIE'S CATERING, LLC L1 1 1 50 1115648.25 0.0 1115648.25 0 0 0 2022-12-07 2026-08-27 2026-11-21T22:36:21Z pv-c6b0d6196bc9
29 29 ANTOINETTE J. JOHNSON L1 1 1 46 30076.0 0.0 30076.0 0 0 0 2022-11-07 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
30 30 APEX CONSTRUCTION COMPANY, INC. L2 1 1 30 494861.17 0.0 494861.17 0 0 0 2023-01-31 2026-09-09 2026-11-21T22:36:21Z pv-c6b0d6196bc9
31 31 AQUA MIST, LLC L1 1 1 196 63877.6 0.0 63877.6 0 0 0 2022-12-13 2026-08-26 2026-11-21T22:36:21Z pv-c6b0d6196bc9
32 32 AT Construction Solutions L2 1 1 6 699334.0 0.0 699334.0 0 0 0 2022-12-22 2025-01-08 2026-11-21T22:36:21Z pv-c6b0d6196bc9
33 33 AT Construction Solutions, LLC L2 1 1 6 699334.0 0.0 699334.0 0 0 0 2022-12-22 2025-01-08 2026-11-21T22:36:21Z pv-c6b0d6196bc9
34 34 AT&T of the Virgin Islands, Inc. L2 1 1 601 489808.38 0.0 489808.38 0 0 0 2022-10-03 2026-10-17 2026-11-21T22:36:21Z pv-c6b0d6196bc9
35 35 ATLANTIC LINK APS L1 1 2 4 357132.0 0.0 357132.0 0 0 0 2024-04-04 2026-09-29 2026-11-21T22:36:21Z pv-c6b0d6196bc9
36 36 AVA PROFESSIONAL JANITORIAL SERVICES, LLC L1 1 1 4 6908.0 0.0 6908.0 0 0 0 2026-05-05 2026-07-07 2026-11-21T22:36:21Z pv-c6b0d6196bc9
37 37 AZTEK COMPUTERS, LLC L1 1 1 2 4003.0 0.0 4003.0 0 0 0 2026-07-21 2026-07-21 2026-11-21T22:36:21Z pv-c6b0d6196bc9
38 38 Abramson Enterprises L2 1 1 88 4744336.92 0.0 4744336.92 0 0 0 2023-06-05 2026-09-22 2026-11-21T22:36:21Z pv-c6b0d6196bc9
39 39 Abramson Enterprises Inc L2 1 1 88 4744336.92 0.0 4744336.92 0 0 0 2023-06-05 2026-09-22 2026-11-21T22:36:21Z pv-c6b0d6196bc9
40 40 Abramson Enterprises, Inc. L2 1 1 88 4744336.92 0.0 4744336.92 0 0 0 2023-06-05 2026-09-22 2026-11-21T22:36:21Z pv-c6b0d6196bc9
41 41 Adcon Environmental, LLC L2 1 1 83 1172586.46 0.0 1172586.46 0 0 0 2022-10-04 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
42 42 Advanced Hotel & Hospitality Resources, LLC L2 1 1 26 183481.44 0.0 183481.44 0 0 0 2024-01-11 2025-03-06 2026-11-21T22:36:21Z pv-c6b0d6196bc9
43 43 Aecom Caribe, LLP L2 1 1 13 1753628.66 0.0 1753628.66 0 0 0 2023-11-28 2024-04-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
44 44 Alliance Data Services L2 1 1 46 153462.17 0.0 153462.17 0 0 0 2023-02-22 2026-03-04 2026-11-21T22:36:21Z pv-c6b0d6196bc9
45 45 Alliance Data Services, LLC L2 1 1 46 153462.17 0.0 153462.17 0 0 0 2023-02-22 2026-03-04 2026-11-21T22:36:21Z pv-c6b0d6196bc9
46 46 American Compliance Technologies, Inc L2 1 1 5 1908658.0 0.0 1908658.0 0 0 0 2023-02-06 2023-09-08 2026-11-21T22:36:21Z pv-c6b0d6196bc9
47 47 American Compliance Technologies, Inc. L2 1 1 5 1908658.0 0.0 1908658.0 0 0 0 2023-02-06 2023-09-08 2026-11-21T22:36:21Z pv-c6b0d6196bc9
48 48 American Immunization Registry Association L2 1 1 3 7485.0 0.0 7485.0 0 0 0 2023-09-10 2025-12-29 2026-11-21T22:36:21Z pv-c6b0d6196bc9
49 49 American Public Human Services Association L2 1 1 3 98475.0 0.0 98475.0 0 0 0 2024-02-08 2025-12-12 2026-11-21T22:36:21Z pv-c6b0d6196bc9
50 50 American Signal Co L2 1 1 17 269566.01 0.0 269566.01 0 0 0 2022-12-29 2026-07-28 2026-11-21T22:36:21Z pv-c6b0d6196bc9
51 51 American Signal Corporation L2 1 1 17 269566.01 0.0 269566.01 0 0 0 2022-12-29 2026-07-28 2026-11-21T22:36:21Z pv-c6b0d6196bc9
52 52 Analysis Group, Inc. L2 1 1 8 20966.75 0.0 20966.75 0 0 0 2026-09-12 2026-09-15 2026-11-21T22:36:21Z pv-c6b0d6196bc9
53 53 Angel A. Lake, MD L2 1 1 87 384771.38 0.0 384771.38 0 0 0 2022-10-13 2026-09-10 2026-11-21T22:36:21Z pv-c6b0d6196bc9
54 54 Angel A. Lake,MD L2 1 1 87 384771.38 0.0 384771.38 0 0 0 2022-10-13 2026-09-10 2026-11-21T22:36:21Z pv-c6b0d6196bc9
55 55 Annaly Farms L2 1 1 211 3016265.75 0.0 3016265.75 0 0 0 2022-10-03 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
56 56 Annaly Farms Inc L2 1 1 211 3016265.75 0.0 3016265.75 0 0 0 2022-10-03 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
57 57 Annaly Farms, Inc. L2 1 1 211 3016265.75 0.0 3016265.75 0 0 0 2022-10-03 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
58 58 Anthony Plumbing, Inc. L2 1 1 17 34484.25 0.0 34484.25 0 0 0 2022-12-16 2025-06-23 2026-11-21T22:36:21Z pv-c6b0d6196bc9
59 59 Antilles Gas Corporation L2 2 2 15 15759.93 0.0 15759.93 0 0 0 2022-12-06 2026-02-12 2026-11-21T22:36:21Z pv-c6b0d6196bc9
60 60 Apex Construction Co., Inc. L2 1 1 30 494861.17 0.0 494861.17 0 0 0 2023-01-31 2026-09-09 2026-11-21T22:36:21Z pv-c6b0d6196bc9
61 61 Apex Construction Company Inc. L2 1 1 30 494861.17 0.0 494861.17 0 0 0 2023-01-31 2026-09-09 2026-11-21T22:36:21Z pv-c6b0d6196bc9
62 62 Apex Construction Company, Inc. L2 1 1 30 494861.17 0.0 494861.17 0 0 0 2023-01-31 2026-09-09 2026-11-21T22:36:21Z pv-c6b0d6196bc9
63 63 Association of Public Health Laboratories L2 1 1 4 2495.0 0.0 2495.0 0 0 0 2023-08-21 2026-08-18 2026-11-21T22:36:21Z pv-c6b0d6196bc9
64 64 Association of Public Health Laboratories, Inc. L2 1 1 4 2495.0 0.0 2495.0 0 0 0 2023-08-21 2026-08-18 2026-11-21T22:36:21Z pv-c6b0d6196bc9
65 65 Assurance and Consulting Group, LLC L2 1 1 61 760750.76 0.0 760750.76 0 0 0 2023-02-14 2026-09-23 2026-11-21T22:36:21Z pv-c6b0d6196bc9
66 66 Assurance and Consulting Group, LLC. L2 1 1 61 760750.76 0.0 760750.76 0 0 0 2023-02-14 2026-09-23 2026-11-21T22:36:21Z pv-c6b0d6196bc9
67 67 Atlantic Link ApS L2 1 2 4 357132.0 0.0 357132.0 0 0 0 2024-04-04 2026-09-29 2026-11-21T22:36:21Z pv-c6b0d6196bc9
68 68 Atlantic Maintenance & Trucking Services, Inc. L2 1 1 1344 769261.35 0.0 769261.35 0 0 0 2022-10-04 2026-10-06 2026-11-21T22:36:21Z pv-c6b0d6196bc9
69 69 Audio Visual Concepts, LLC L2 1 1 1 1800.0 0.0 1800.0 0 0 0 2024-07-12 2024-07-12 2026-11-21T22:36:21Z pv-c6b0d6196bc9
70 70 Axiell ALM, Inc. L2 1 1 51 1356113.98 0.0 1356113.98 0 0 0 2023-02-13 2026-04-01 2026-11-21T22:36:21Z pv-c6b0d6196bc9
71 71 Axis Development Group, LLC L2 1 1 51 99360.0 0.0 99360.0 0 0 0 2023-03-20 2026-09-03 2026-11-21T22:36:21Z pv-c6b0d6196bc9
72 72 B Tech Contracting Group, LLC L2 1 1 5 42999.33 0.0 42999.33 0 0 0 2023-02-28 2024-08-27 2026-11-21T22:36:21Z pv-c6b0d6196bc9
73 73 B.C.J Generators L2 1 1 12 128000.0 0.0 128000.0 0 0 0 2024-09-06 2025-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
74 74 B20 Maintenance L2 1 1 375 1709756.0 0.0 1709756.0 0 0 0 2022-10-03 2026-09-09 2026-11-21T22:36:21Z pv-c6b0d6196bc9
75 75 B20 Maintenance LLC L2 1 1 375 1709756.0 0.0 1709756.0 0 0 0 2022-10-03 2026-09-09 2026-11-21T22:36:21Z pv-c6b0d6196bc9
76 76 B20 Maintenance, LLC L2 1 1 375 1709756.0 0.0 1709756.0 0 0 0 2022-10-03 2026-09-09 2026-11-21T22:36:21Z pv-c6b0d6196bc9
77 77 BAYBRI PRODUCTIONS, LLC L1 1 1 1 1625.0 0.0 1625.0 0 0 0 2026-05-27 2026-05-27 2026-11-21T22:36:21Z pv-c6b0d6196bc9
78 78 BDO USA, P.C. L1 1 1 73 17058512.0 -2008000.0 15050512.0 8 8 0 2023-01-27 2026-08-12 2026-11-21T22:36:21Z pv-c6b0d6196bc9
79 79 BELLAVISTA PROPERTIES, INC. L1 1 1 8 3253.29 0.0 3253.29 0 0 0 2022-12-16 2025-06-23 2026-11-21T22:36:21Z pv-c6b0d6196bc9
80 80 BERLEY, BRY'NICE L1 1 1 9 17431.0 0.0 17431.0 0 0 0 2023-07-11 2026-08-04 2026-11-21T22:36:21Z pv-c6b0d6196bc9
81 81 BERT W. SMITH, JR. & CO., CHARTERED L1 1 1 19 1981677.0 0.0 1981677.0 0 0 0 2022-11-09 2026-07-29 2026-11-21T22:36:21Z pv-c6b0d6196bc9
82 82 BEYOND BORDERS, LLC L1 1 1 49 56965.0 0.0 56965.0 0 0 0 2023-06-22 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
83 83 BEYOND BRIGHT DAYCARE, LLC L1 1 1 170 866540.11 0.0 866540.11 0 0 0 2022-10-11 2026-10-13 2026-11-21T22:36:21Z pv-c6b0d6196bc9
84 84 BIG RED BARGE LTD.CO. L2 1 1 265 88415.2 0.0 88415.2 0 0 0 2022-10-17 2026-09-09 2026-11-21T22:36:21Z pv-c6b0d6196bc9
85 85 BLUE ANCHOR ASSET MANAGEMENT, LLC L1 1 1 75 1391983.02 0.0 1391983.02 0 0 0 2023-02-22 2026-09-02 2026-11-21T22:36:21Z pv-c6b0d6196bc9
86 86 BRADSHAW'S WATER DELIVERY LLC L1 1 1 22 108837.0 0.0 108837.0 0 0 0 2022-10-06 2026-08-11 2026-11-21T22:36:21Z pv-c6b0d6196bc9
87 87 BRIGHTVIEW ISLAND PROPERTY SERVICES LLC L1 1 1 1 1875.0 0.0 1875.0 0 0 0 2026-09-30 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
88 88 BRINC DRONES, INC. L1 1 1 1 912811.44 0.0 912811.44 0 0 0 2026-09-03 2026-09-03 2026-11-21T22:36:21Z pv-c6b0d6196bc9
89 89 BROTHERS CONSTRUCTION, INC. L2 1 1 26 191062.6 0.0 191062.6 0 0 0 2023-01-19 2026-05-20 2026-11-21T22:36:21Z pv-c6b0d6196bc9
90 90 BUNKERS OF ST. CROIX, INC. L1 1 1 113 403511.47 0.0 403511.47 0 0 0 2022-10-11 2026-09-30 2026-11-21T22:36:21Z pv-c6b0d6196bc9
91 91 Baker Law P.C L2 1 1 64 235565.47 0.0 235565.47 0 0 0 2023-10-25 2026-11-16 2026-11-21T22:36:21Z pv-c6b0d6196bc9
92 92 Baker Law P.C. L2 1 1 64 235565.47 0.0 235565.47 0 0 0 2023-10-25 2026-11-16 2026-11-21T22:36:21Z pv-c6b0d6196bc9
93 93 Baker Law, P.C. L2 1 1 64 235565.47 0.0 235565.47 0 0 0 2023-10-25 2026-11-16 2026-11-21T22:36:21Z pv-c6b0d6196bc9
94 94 Banco Popular de Puerto Rico L2 1 1 41 6872.63 0.0 6872.63 0 0 0 2022-11-09 2025-09-26 2026-11-21T22:36:21Z pv-c6b0d6196bc9
95 95 Barefoot Contessa LLC L2 1 1 22 81829.5 0.0 81829.5 0 0 0 2022-10-18 2026-09-29 2026-11-21T22:36:21Z pv-c6b0d6196bc9
96 96 Bart Enterprises LLC L2 1 1 1 3100.0 0.0 3100.0 0 0 0 2023-11-28 2023-11-28 2026-11-21T22:36:21Z pv-c6b0d6196bc9
97 97 Bart Enterprises, LLC L2 1 1 1 3100.0 0.0 3100.0 0 0 0 2023-11-28 2023-11-28 2026-11-21T22:36:21Z pv-c6b0d6196bc9
98 98 Basketball Travelers, Inc L2 1 1 7 1745000.0 0.0 1745000.0 0 0 0 2024-03-04 2026-04-16 2026-11-21T22:36:21Z pv-c6b0d6196bc9
99 99 Basketball Travelers, Inc. L2 1 1 7 1745000.0 0.0 1745000.0 0 0 0 2024-03-04 2026-04-16 2026-11-21T22:36:21Z pv-c6b0d6196bc9
100 100 Bates Trucking & Trash Removal, Inc. L2 1 1 131 316925.0 0.0 316925.0 0 0 0 2022-10-03 2026-01-15 2026-11-21T22:36:21Z pv-c6b0d6196bc9

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE procurement_vendor_payments(
  vendor_string TEXT,
  rung TEXT,
  n_checkbook_names INT,
  n_checkbook_vendor_ids INT,
  n_rows INT,
  gross_debits_usd REAL,
  credits_usd REAL,
  net_usd REAL,
  n_credits INT,
  n_credits_paired INT,
  n_credits_unpaired INT,
  first_check_date TEXT,
  last_check_date TEXT,
  computed_at TEXT,
  run_id TEXT
);
Powered by Datasette · Queries took 26.636ms