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

3,836 rows where category = "Public Defender" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

state 1

  • TN 3,836

source 1

record_type 1

category 1

  • Public Defender · 3,836 ✖
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
1312561 1312561 1594083 nashville_metro_payments vendor_payment 41 TN supplier#1015792 138074.39 2025-07-14   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1126165 2026-08-03T15:49:19.134119+00:00 municipal
1343684 1343684 1625206 nashville_metro_payments vendor_payment 41 TN supplier#1015792 138074.39 2025-08-25   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1159651 2026-08-03T15:50:05.309149+00:00 municipal
1364891 1364891 1646413 nashville_metro_payments vendor_payment 41 TN supplier#1015792 138074.39 2025-09-11   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1182088 2026-08-03T15:50:34.053987+00:00 municipal
1392197 1392197 1673719 nashville_metro_payments vendor_payment 41 TN supplier#1015792 138074.39 2025-10-06   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1210958 2026-08-03T15:51:16.036956+00:00 municipal
1419524 1419524 1701046 nashville_metro_payments vendor_payment 41 TN supplier#1015792 138074.39 2025-11-03   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1239859 2026-08-03T15:51:51.613166+00:00 municipal
1456745 1456745 1738267 nashville_metro_payments vendor_payment 41 TN supplier#1015792 138074.39 2025-12-11   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1279185 2026-08-03T15:52:43.200950+00:00 municipal
482642 482642 753402 nashville_metro_payments vendor_payment 41 TN supplier#286 28713.25 2023-05-26   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 245977 2026-08-03T14:54:08.466318+00:00 municipal
702945 702945 984467 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20786.61 2022-08-03   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 481737 2026-08-03T15:34:30.193639+00:00 municipal
707050 707050 988572 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20524.24 2022-09-07   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 486013 2026-08-03T15:34:36.645329+00:00 municipal
713015 713015 994537 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20524.24 2022-09-21   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 492304 2026-08-03T15:34:43.484907+00:00 municipal
718412 718412 999934 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20524.24 2022-11-02   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 497912 2026-08-03T15:34:51.044212+00:00 municipal
723392 723392 1004914 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20524.24 2022-11-30   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 503054 2026-08-03T15:34:56.080298+00:00 municipal
727614 727614 1009136 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20524.24 2023-01-04   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 507546 2026-08-03T15:35:03.235309+00:00 municipal
730934 730934 1012456 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20524.24 2023-01-25   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 511013 2026-08-03T15:35:03.235309+00:00 municipal
736242 736242 1017764 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20524.24 2023-03-01   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 516574 2026-08-03T15:35:10.559769+00:00 municipal
740582 740582 1022104 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20524.24 2023-03-22   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 521080 2026-08-03T15:35:16.313813+00:00 municipal
746940 746940 1028462 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20524.24 2023-04-26   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 527616 2026-08-03T15:35:23.394179+00:00 municipal
752092 752092 1033614 nashville_metro_payments vendor_payment 41 TN supplier#1000620 20524.24 2023-05-24   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 532943 2026-08-03T15:35:35.389388+00:00 municipal
866728 866728 1148250 nashville_metro_payments vendor_payment 41 TN supplier#282 12400.0 2024-05-22   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 653366 2026-08-03T15:38:05.935382+00:00 municipal
707049 707049 988571 nashville_metro_payments vendor_payment 41 TN supplier#1000620 12162.51 2022-09-07   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 486012 2026-08-03T15:34:36.645329+00:00 municipal
713014 713014 994536 nashville_metro_payments vendor_payment 41 TN supplier#1000620 12162.51 2022-09-21   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 492303 2026-08-03T15:34:43.484907+00:00 municipal
718410 718410 999932 nashville_metro_payments vendor_payment 41 TN supplier#1000620 12162.51 2022-11-02   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 497910 2026-08-03T15:34:51.044212+00:00 municipal
723388 723388 1004910 nashville_metro_payments vendor_payment 41 TN supplier#1000620 12162.51 2022-11-30   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 503050 2026-08-03T15:34:56.080298+00:00 municipal
727613 727613 1009135 nashville_metro_payments vendor_payment 41 TN supplier#1000620 12162.51 2023-01-04   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 507545 2026-08-03T15:35:03.235309+00:00 municipal
730933 730933 1012455 nashville_metro_payments vendor_payment 41 TN supplier#1000620 12162.51 2023-01-25   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 511012 2026-08-03T15:35:03.235309+00:00 municipal
736241 736241 1017763 nashville_metro_payments vendor_payment 41 TN supplier#1000620 12162.51 2023-03-01   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 516573 2026-08-03T15:35:10.559769+00:00 municipal
740581 740581 1022103 nashville_metro_payments vendor_payment 41 TN supplier#1000620 12162.51 2023-03-22   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 521079 2026-08-03T15:35:16.313813+00:00 municipal
746939 746939 1028461 nashville_metro_payments vendor_payment 41 TN supplier#1000620 12162.51 2023-04-26   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 527615 2026-08-03T15:35:23.394179+00:00 municipal
752090 752090 1033612 nashville_metro_payments vendor_payment 41 TN supplier#1000620 12162.51 2023-05-24   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 532941 2026-08-03T15:35:35.389388+00:00 municipal
766094 766094 1047616 nashville_metro_payments vendor_payment 41 TN supplier#1000620 11422.59 2023-07-27   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 547313 2026-08-03T15:35:48.366839+00:00 municipal
702942 702942 984464 nashville_metro_payments vendor_payment 41 TN supplier#1000620 11377.11 2022-08-03   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 481734 2026-08-03T15:34:30.193639+00:00 municipal
1198894 1198894 1480416 nashville_metro_payments vendor_payment 41 TN supplier#282 11200.0 2025-04-21   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1006429 2026-08-03T15:46:28.028303+00:00 municipal
259057 259057 511535 nashville_metro_payments vendor_payment 41 TN supplier#282 10400.0 2023-05-19   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 4110 2026-08-03T14:49:19.019975+00:00 municipal
1225265 1225265 1506787 nashville_metro_payments vendor_payment 41 TN supplier#219018 10000.0 2025-04-14   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1034497 2026-08-03T15:47:03.542997+00:00 municipal
1198893 1198893 1480415 nashville_metro_payments vendor_payment 41 TN supplier#282 8400.0 2025-04-21   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1006428 2026-08-03T15:46:28.028303+00:00 municipal
581615 581615 858951 nashville_metro_payments vendor_payment 41 TN supplier#286 7741.29 2023-09-25   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 351526 2026-08-03T14:56:21.003979+00:00 municipal
979384 979384 1260906 nashville_metro_payments vendor_payment 41 TN supplier#2568 7577.0 2024-08-16   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 773206 2026-08-03T15:40:43.824502+00:00 municipal
766090 766090 1047612 nashville_metro_payments vendor_payment 41 TN supplier#1000620 6768.94 2023-07-27   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 547309 2026-08-03T15:35:48.366839+00:00 municipal
581603 581603 858939 nashville_metro_payments vendor_payment 41 TN supplier#286 6071.6 2023-09-25   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 351514 2026-08-03T14:56:21.003979+00:00 municipal
259054 259054 511532 nashville_metro_payments vendor_payment 41 TN supplier#282 6000.0 2023-05-19   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 4107 2026-08-03T14:49:19.019975+00:00 municipal
966074 966074 1247596 nashville_metro_payments vendor_payment 41 TN supplier#747501 6000.0 2024-07-03   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 758844 2026-08-03T15:40:21.870060+00:00 municipal
1039852 1039852 1321374 nashville_metro_payments vendor_payment 41 TN supplier#10459 6000.0 2024-10-22   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 837745 2026-08-03T15:42:23.575282+00:00 municipal
509527 509527 781543 nashville_metro_payments vendor_payment 41 TN supplier#286 5717.44 2023-06-22   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 274118 2026-08-03T14:54:40.483970+00:00 municipal
1300286 1300286 1581808 nashville_metro_payments vendor_payment 41 TN supplier#747501 5625.0 2025-06-23   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1113175 2026-08-03T15:48:53.224545+00:00 municipal
866727 866727 1148249 nashville_metro_payments vendor_payment 41 TN supplier#282 5600.0 2024-05-22   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 653365 2026-08-03T15:38:05.935382+00:00 municipal
917355 917355 1198877 nashville_metro_payments vendor_payment 41 TN supplier#7073 5140.42 2024-06-11   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 706588 2026-08-03T15:39:19.018588+00:00 municipal
696980 696980 978502 nashville_metro_payments vendor_payment 41 TN supplier#736139 4800.0 2022-07-06   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 475583 2026-08-03T15:34:18.620533+00:00 municipal
482641 482641 753401 nashville_metro_payments vendor_payment 41 TN supplier#286 4737.25 2023-05-26   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 245976 2026-08-03T14:54:08.466318+00:00 municipal
1289765 1289765 1571287 nashville_metro_payments vendor_payment 41 TN supplier#215396 4457.0 2025-06-23   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1102031 2026-08-03T15:48:36.719656+00:00 municipal
966073 966073 1247595 nashville_metro_payments vendor_payment 41 TN supplier#747501 4100.0 2024-07-03   Public Defender   Metro department Public Defender (21)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 758843 2026-08-03T15:40:21.870060+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);