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

5,383 rows where category = "Law" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

state 1

  • TN 5,383

source 1

record_type 1

category 1

  • Law · 5,383 ✖
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
948722 948722 1230244 nashville_metro_payments vendor_payment 41 TN supplier#395829 12627257.0 2024-07-10   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 739962 2026-08-03T15:39:59.722037+00:00 municipal
1295721 1295721 1577243 nashville_metro_payments vendor_payment 41 TN supplier#395829 11639592.0 2025-06-27   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1108234 2026-08-03T15:48:44.752732+00:00 municipal
541051 541051 814942 nashville_metro_payments vendor_payment 41 TN supplier#395829 11581739.0 2023-07-26   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 307517 2026-08-03T14:55:24.215283+00:00 municipal
280744 280744 534903 nashville_metro_payments vendor_payment 41 TN supplier#395829 7193921.0 2022-08-01   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 27478 2026-08-03T14:49:46.127242+00:00 municipal
1331547 1331547 1613069 nashville_metro_payments vendor_payment 41 TN supplier#1025797 2323196.7 2025-07-30   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1146440 2026-08-03T15:49:43.080963+00:00 municipal
398360 398360 662451 nashville_metro_payments vendor_payment 41 TN supplier#6379 1982864.42 2023-02-03   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 155026 2026-08-03T14:52:21.492962+00:00 municipal
1167510 1167510 1449032 nashville_metro_payments vendor_payment 41 TN supplier#221566 1719513.22 2025-02-26   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 972986 2026-08-03T15:45:47.138438+00:00 municipal
1302049 1302049 1583571 nashville_metro_payments vendor_payment 41 TN supplier#218579 1572878.46 2025-06-25   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1115006 2026-08-03T15:49:02.055670+00:00 municipal
735571 735571 1017093 nashville_metro_payments vendor_payment 41 TN supplier#1013845 1200000.0 2023-02-22   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 515899 2026-08-03T15:35:10.559769+00:00 municipal
1196565 1196565 1478087 nashville_metro_payments vendor_payment 41 TN supplier#311122 960000.0 2025-03-26   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1003889 2026-08-03T15:46:20.735236+00:00 municipal
1208322 1208322 1489844 nashville_metro_payments vendor_payment 41 TN supplier#13317 890813.26 2025-04-15   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1016486 2026-08-03T15:46:41.226095+00:00 municipal
793475 793475 1074997 nashville_metro_payments vendor_payment 41 TN supplier#271096 827378.63 2024-01-22   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 575669 2026-08-03T15:36:29.821436+00:00 municipal
1285243 1285243 1566765 nashville_metro_payments vendor_payment 41 TN supplier#1025296 600000.0 2025-06-18   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1097322 2026-08-03T15:48:28.390993+00:00 municipal
908721 908721 1190243 nashville_metro_payments vendor_payment 41 TN supplier#218579 573985.19 2024-05-22   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 697476 2026-08-03T15:39:03.990088+00:00 municipal
981901 981901 1263423 nashville_metro_payments vendor_payment 41 TN supplier#271 508897.6 2024-08-23   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 775967 2026-08-03T15:40:43.824502+00:00 municipal
744406 744406 1025928 nashville_metro_payments vendor_payment 41 TN supplier#218579 487654.15 2023-04-05   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 524995 2026-08-03T15:35:23.394179+00:00 municipal
728150 728150 1009672 nashville_metro_payments vendor_payment 41 TN supplier#375422 445946.88 2023-01-04   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 508091 2026-08-03T15:35:03.235309+00:00 municipal
1165279 1165279 1446801 nashville_metro_payments vendor_payment 41 TN supplier#218579 437092.55 2025-02-20   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 970703 2026-08-03T15:45:39.595395+00:00 municipal
1355366 1355366 1636888 nashville_metro_payments vendor_payment 41 TN supplier#237378 407333.93 2025-08-27   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1172019 2026-08-03T15:50:20.630202+00:00 municipal
1285242 1285242 1566764 nashville_metro_payments vendor_payment 41 TN supplier#1025296 400000.0 2025-06-18   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1097321 2026-08-03T15:48:28.390993+00:00 municipal
588819 588819 866799 nashville_metro_payments vendor_payment 41 TN supplier#271 376712.2 2023-10-05   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 359374 2026-08-03T14:56:27.525262+00:00 municipal
1165275 1165275 1446797 nashville_metro_payments vendor_payment 41 TN supplier#218579 363235.47 2025-02-20   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 970699 2026-08-03T15:45:39.595395+00:00 municipal
441604 441604 709290 nashville_metro_payments vendor_payment 41 TN supplier#6379 361736.6 2023-04-06   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 201865 2026-08-03T14:53:16.641258+00:00 municipal
948732 948732 1230254 nashville_metro_payments vendor_payment 41 TN supplier#395829 330000.0 2024-07-10   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 739973 2026-08-03T15:39:59.722037+00:00 municipal
1295723 1295723 1577245 nashville_metro_payments vendor_payment 41 TN supplier#395829 330000.0 2025-06-27   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1108237 2026-08-03T15:48:44.752732+00:00 municipal
798045 798045 1079567 nashville_metro_payments vendor_payment 41 TN supplier#1012078 319928.43 2024-02-28   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 580431 2026-08-03T15:36:34.909474+00:00 municipal
1342078 1342078 1623600 nashville_metro_payments vendor_payment 41 TN supplier#1025296 305878.27 2025-08-20   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1157866 2026-08-03T15:50:05.309149+00:00 municipal
766181 766181 1047703 nashville_metro_payments vendor_payment 41 TN supplier#1016089 300000.0 2023-07-27   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 547406 2026-08-03T15:35:48.366839+00:00 municipal
1137937 1137937 1419459 nashville_metro_payments vendor_payment 41 TN supplier#1023062 300000.0 2025-01-22   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 941754 2026-08-03T15:45:04.182670+00:00 municipal
1141038 1141038 1422560 nashville_metro_payments vendor_payment 41 TN supplier#248275 300000.0 2025-01-29   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 944966 2026-08-03T15:45:04.182670+00:00 municipal
1298776 1298776 1580298 nashville_metro_payments vendor_payment 41 TN supplier#1025208 300000.0 2025-06-11   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1111618 2026-08-03T15:48:53.224545+00:00 municipal
1331497 1331497 1613019 nashville_metro_payments vendor_payment 41 TN supplier#248275 300000.0 2025-07-28   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1146388 2026-08-03T15:49:43.080963+00:00 municipal
1446764 1446764 1728286 nashville_metro_payments vendor_payment 41 TN supplier#180941 300000.0 2025-11-24   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1268658 2026-08-03T15:52:27.189002+00:00 municipal
1382867 1382867 1664389 nashville_metro_payments vendor_payment 41 TN supplier#1001147 290000.0 2025-09-15   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1201156 2026-08-03T15:51:02.983935+00:00 municipal
970738 970738 1252260 nashville_metro_payments vendor_payment 41 TN supplier#1021029 275000.0 2024-07-24   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 763761 2026-08-03T15:40:27.478083+00:00 municipal
1382487 1382487 1664009 nashville_metro_payments vendor_payment 41 TN supplier#1026348 275000.0 2025-09-17   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1200774 2026-08-03T15:51:02.983935+00:00 municipal
740762 740762 1022284 nashville_metro_payments vendor_payment 41 TN supplier#1012078 258500.03 2023-03-22   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 521262 2026-08-03T15:35:16.313813+00:00 municipal
782740 782740 1064262 nashville_metro_payments vendor_payment 41 TN supplier#237378 255000.0 2023-11-01   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 564555 2026-08-03T15:36:14.895244+00:00 municipal
768687 768687 1050209 nashville_metro_payments vendor_payment 41 TN supplier#1016089 253001.42 2023-08-28   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 550018 2026-08-03T15:35:55.821828+00:00 municipal
770756 770756 1052278 nashville_metro_payments vendor_payment 41 TN supplier#1016089 253001.42 2023-08-23   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 552156 2026-08-03T15:35:55.821828+00:00 municipal
797503 797503 1079025 nashville_metro_payments vendor_payment 41 TN supplier#1011509 250000.0 2024-02-14   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 579888 2026-08-03T15:36:34.909474+00:00 municipal
478112 478112 748572 nashville_metro_payments vendor_payment 41 TN supplier#6379 246863.56 2023-05-23   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 241147 2026-08-03T14:54:03.309268+00:00 municipal
1164394 1164394 1445916 nashville_metro_payments vendor_payment 41 TN supplier#181874 240000.0 2025-02-03   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 969788 2026-08-03T15:45:39.595395+00:00 municipal
733513 733513 1015035 nashville_metro_payments vendor_payment 41 TN supplier#348686 236000.0 2023-02-02   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 513777 2026-08-03T15:35:10.559769+00:00 municipal
1323590 1323590 1605112 nashville_metro_payments vendor_payment 41 TN supplier#25956 235662.0 2025-07-30   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1138065 2026-08-03T15:49:36.705719+00:00 municipal
959288 959288 1240810 nashville_metro_payments vendor_payment 41 TN supplier#25956 225062.0 2024-07-22   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 751400 2026-08-03T15:40:13.342515+00:00 municipal
970074 970074 1251596 nashville_metro_payments vendor_payment 41 TN supplier#1021033 225000.0 2024-07-24   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 763048 2026-08-03T15:40:27.478083+00:00 municipal
1195533 1195533 1477055 nashville_metro_payments vendor_payment 41 TN supplier#386198 223408.32 2025-03-24   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1002825 2026-08-03T15:46:20.735236+00:00 municipal
664174 664174 945696 nashville_metro_payments vendor_payment 41 TN supplier#271 213015.69 2024-01-17   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 440230 2026-08-03T15:33:38.920817+00:00 municipal
532644 532644 805979 nashville_metro_payments vendor_payment 41 TN supplier#25956 208812.0 2023-07-14   Law   Metro department Law (6)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 298554 2026-08-03T14:55:11.643467+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);