gov_payments

Government spending / vendor payments. IMPORTANT before attributing spending to a city or county: rows where source = 'usaspending' are US FEDERAL awards, linked to a place only by place-of-performance, NOT paid by the local government. All other sources (nola-city-contract, miamidade_cocc, act370-*) are the local government's own money. Filter with WHERE source != 'usaspending' for municipal spending only.

Data license: CC BY 4.0 · Data source: MyTown

95,511 rows where category = "Administrative", source = "nashville_metro_payments" and state = "TN" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

state 1

  • TN · 95,511 ✖

source 1

  • nashville_metro_payments · 95,511 ✖

record_type 1

category 1

  • Administrative · 95,511 ✖
Link rowid id source record_type muni_id state payee amount ▲ txn_date end_date category object_type purpose funding_source site fiscal_period source_url external_id updated_at payer_level
1280597 1280597 1562119 nashville_metro_payments vendor_payment 41 TN supplier#216 20000000.0 2025-06-13   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1092415 2026-08-03T15:48:22.442469+00:00 municipal
1305262 1305262 1586784 nashville_metro_payments vendor_payment 41 TN supplier#216 16465000.0 2025-07-03   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1118460 2026-08-03T15:49:02.055670+00:00 municipal
1065157 1065157 1346679 nashville_metro_payments vendor_payment 41 TN supplier#4034 15000000.0 2024-11-13   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 864559 2026-08-03T15:43:11.653306+00:00 municipal
1230567 1230567 1512089 nashville_metro_payments vendor_payment 41 TN supplier#3679 10287493.83 2025-05-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1040025 2026-08-03T15:47:11.461695+00:00 municipal
464812 464812 734475 nashville_metro_payments vendor_payment 41 TN supplier#3679 10208431.02 2023-05-05   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 227050 2026-08-03T14:53:44.488801+00:00 municipal
861771 861771 1143293 nashville_metro_payments vendor_payment 41 TN supplier#3679 10139272.91 2024-04-30   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 648171 2026-08-03T15:37:58.198574+00:00 municipal
1056122 1056122 1337644 nashville_metro_payments vendor_payment 41 TN supplier#216 10000000.0 2024-11-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 854960 2026-08-03T15:42:56.958292+00:00 municipal
1113892 1113892 1395414 nashville_metro_payments vendor_payment 41 TN supplier#216 10000000.0 2025-01-02   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 916177 2026-08-03T15:44:29.480922+00:00 municipal
1145981 1145981 1427503 nashville_metro_payments vendor_payment 41 TN supplier#4034 10000000.0 2025-02-10   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 950255 2026-08-03T15:45:10.160599+00:00 municipal
1302722 1302722 1584244 nashville_metro_payments vendor_payment 41 TN supplier#216 10000000.0 2025-07-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1115703 2026-08-03T15:49:02.055670+00:00 municipal
1331984 1331984 1613506 nashville_metro_payments vendor_payment 41 TN supplier#216 10000000.0 2025-08-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1146912 2026-08-03T15:49:43.080963+00:00 municipal
1302490 1302490 1584012 nashville_metro_payments vendor_payment 41 TN supplier#1585 9505000.0 2025-07-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1115450 2026-08-03T15:49:02.055670+00:00 municipal
995688 995688 1277210 nashville_metro_payments vendor_payment 41 TN supplier#216 9500000.0 2024-09-04   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 790728 2026-08-03T15:41:05.165004+00:00 municipal
940166 940166 1221688 nashville_metro_payments vendor_payment 41 TN supplier#1585 9425000.0 2024-07-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 730780 2026-08-03T15:39:45.067813+00:00 municipal
586502 586502 864320 nashville_metro_payments vendor_payment 41 TN supplier#216 9000000.0 2023-10-02   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 356895 2026-08-03T14:56:27.525262+00:00 municipal
1142260 1142260 1423782 nashville_metro_payments vendor_payment 41 TN supplier#216 9000000.0 2025-02-04   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 946222 2026-08-03T15:45:10.160599+00:00 municipal
1233830 1233830 1515352 nashville_metro_payments vendor_payment 41 TN supplier#13317 9000000.0 2025-05-05   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1043453 2026-08-03T15:47:17.896363+00:00 municipal
1356514 1356514 1638036 nashville_metro_payments vendor_payment 41 TN supplier#216 9000000.0 2025-09-02   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1173240 2026-08-03T15:50:20.630202+00:00 municipal
1387823 1387823 1669345 nashville_metro_payments vendor_payment 41 TN supplier#216 9000000.0 2025-10-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1206292 2026-08-03T15:51:08.506774+00:00 municipal
1419531 1419531 1701053 nashville_metro_payments vendor_payment 41 TN supplier#216 9000000.0 2025-11-03   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1239866 2026-08-03T15:51:51.613166+00:00 municipal
1302507 1302507 1584029 nashville_metro_payments vendor_payment 41 TN supplier#1585 8765000.0 2025-07-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1115467 2026-08-03T15:49:02.055670+00:00 municipal
610162 610162 889797 nashville_metro_payments vendor_payment 41 TN supplier#216 8500000.0 2023-11-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 382372 2026-08-03T14:56:59.946074+00:00 municipal
652550 652550 934072 nashville_metro_payments vendor_payment 41 TN supplier#216 8500000.0 2024-01-03   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 427723 2026-08-03T15:33:27.218134+00:00 municipal
941185 941185 1222707 nashville_metro_payments vendor_payment 41 TN supplier#216 8500000.0 2024-07-02   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 731917 2026-08-03T15:39:45.067813+00:00 municipal
1444108 1444108 1725630 nashville_metro_payments vendor_payment 41 TN supplier#216 8500000.0 2025-11-28   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1265908 2026-08-03T15:52:27.189002+00:00 municipal
940204 940204 1221726 nashville_metro_payments vendor_payment 41 TN supplier#1585 8350000.0 2024-07-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 730818 2026-08-03T15:39:45.067813+00:00 municipal
297280 297280 553116 nashville_metro_payments vendor_payment 41 TN supplier#216 8000000.0 2022-09-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 45691 2026-08-03T14:50:09.986203+00:00 municipal
973024 973024 1254546 nashville_metro_payments vendor_payment 41 TN supplier#216 8000000.0 2024-08-02   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 766179 2026-08-03T15:40:35.120811+00:00 municipal
1026407 1026407 1307929 nashville_metro_payments vendor_payment 41 TN supplier#216 8000000.0 2024-10-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 823424 2026-08-03T15:41:57.488315+00:00 municipal
257437 257437 509823 nashville_metro_payments vendor_payment 41 TN supplier#1585 7940000.0 2023-07-03   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 2398 2026-08-03T14:49:19.019975+00:00 municipal
1175034 1175034 1456556 nashville_metro_payments vendor_payment 41 TN supplier#13317 7800000.0 2025-03-10   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 981123 2026-08-03T15:45:53.357317+00:00 municipal
256147 256147 508488 nashville_metro_payments vendor_payment 41 TN supplier#1585 7565000.0 2022-07-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1063 2026-08-03T14:49:19.019975+00:00 municipal
374931 374931 637166 nashville_metro_payments vendor_payment 41 TN supplier#216 7500000.0 2022-12-23   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 129741 2026-08-03T14:51:44.762369+00:00 municipal
256149 256149 508490 nashville_metro_payments vendor_payment 41 TN supplier#1585 7169150.0 2022-07-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1065 2026-08-03T14:49:19.019975+00:00 municipal
1302486 1302486 1584008 nashville_metro_payments vendor_payment 41 TN supplier#1585 7145000.0 2025-07-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1115446 2026-08-03T15:49:02.055670+00:00 municipal
255383 255383 507703 nashville_metro_payments vendor_payment 41 TN supplier#1585 7015400.0 2023-01-03   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 278 2026-08-03T14:49:19.019975+00:00 municipal
257441 257441 509827 nashville_metro_payments vendor_payment 41 TN supplier#1585 7015400.0 2023-07-03   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 2402 2026-08-03T14:49:19.019975+00:00 municipal
260390 260390 512927 nashville_metro_payments vendor_payment 41 TN supplier#216 7000000.0 2022-07-05   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 5502 2026-08-03T14:49:23.947350+00:00 municipal
277805 277805 531634 nashville_metro_payments vendor_payment 41 TN supplier#216 7000000.0 2022-07-26   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 24209 2026-08-03T14:49:41.240883+00:00 municipal
339135 339135 598286 nashville_metro_payments vendor_payment 41 TN supplier#216 7000000.0 2022-11-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 90861 2026-08-03T14:51:03.872713+00:00 municipal
520360 520360 793056 nashville_metro_payments vendor_payment 41 TN supplier#216 7000000.0 2023-07-03   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 285631 2026-08-03T14:54:57.612958+00:00 municipal
545662 545662 820020 nashville_metro_payments vendor_payment 41 TN supplier#216 7000000.0 2023-08-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 312595 2026-08-03T14:55:30.475260+00:00 municipal
563350 563350 839249 nashville_metro_payments vendor_payment 41 TN supplier#216 7000000.0 2023-08-30   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 331824 2026-08-03T14:55:55.237209+00:00 municipal
675975 675975 957497 nashville_metro_payments vendor_payment 41 TN supplier#216 7000000.0 2024-02-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 452843 2026-08-03T15:33:53.349960+00:00 municipal
957917 957917 1239439 nashville_metro_payments vendor_payment 41 TN supplier#282 6944000.0 2024-07-17   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 749941 2026-08-03T15:40:13.342515+00:00 municipal
257324 257324 509708 nashville_metro_payments vendor_payment 41 TN supplier#1585 6853775.0 2024-01-02   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 2283 2026-08-03T14:49:19.019975+00:00 municipal
940206 940206 1221728 nashville_metro_payments vendor_payment 41 TN supplier#1585 6853775.0 2024-07-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 730820 2026-08-03T15:39:45.067813+00:00 municipal
1145969 1145969 1427491 nashville_metro_payments vendor_payment 41 TN supplier#13317 6800000.0 2025-02-10   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 950241 2026-08-03T15:45:10.160599+00:00 municipal
940205 940205 1221727 nashville_metro_payments vendor_payment 41 TN supplier#1585 6795000.0 2024-07-01   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 730819 2026-08-03T15:39:45.067813+00:00 municipal
1113698 1113698 1395220 nashville_metro_payments vendor_payment 41 TN supplier#1585 6683900.0 2025-01-02   Administrative   Metro department Administrative (1)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 915912 2026-08-03T15:44:29.480922+00:00 municipal

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "gov_payments" ("id", "source", "record_type", "muni_id", "state", "payee", "amount", "txn_date", "end_date", "category", "object_type", "purpose", "funding_source", "site", "fiscal_period", "source_url", "external_id", "updated_at", "payer_level");
CREATE INDEX "ix_gov_payments_muni_id" ON "gov_payments" ("muni_id");
CREATE INDEX "ix_gov_payments_payee" ON "gov_payments" ("payee");
CREATE INDEX "ix_gov_payments_payee_nocase" ON "gov_payments" ("payee" COLLATE NOCASE);