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

27,666 rows where category = "Sheriff" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

state 1

  • TN 27,666

source 1

record_type 1

category 1

  • Sheriff · 27,666 ✖
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
987137 987137 1268659 nashville_metro_payments vendor_payment 41 TN supplier#14862 1125128.61 2024-08-29   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 781652 2026-08-03T15:40:57.545110+00:00 municipal
1198268 1198268 1479790 nashville_metro_payments vendor_payment 41 TN supplier#1007901 836041.28 2025-04-02   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1005681 2026-08-03T15:46:28.028303+00:00 municipal
1421369 1421369 1702891 nashville_metro_payments vendor_payment 41 TN supplier#1007901 627030.96 2025-11-04   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1241809 2026-08-03T15:51:51.613166+00:00 municipal
1063305 1063305 1344827 nashville_metro_payments vendor_payment 41 TN supplier#14862 550000.0 2024-11-14   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 862590 2026-08-03T15:43:11.653306+00:00 municipal
651422 651422 932944 nashville_metro_payments vendor_payment 41 TN supplier#217 462840.0 2023-12-29   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 426445 2026-08-03T15:33:20.474014+00:00 municipal
410153 410153 675398 nashville_metro_payments vendor_payment 41 TN supplier#8298 367531.0 2023-02-23   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 167973 2026-08-03T14:52:33.028899+00:00 municipal
567932 567932 844163 nashville_metro_payments vendor_payment 41 TN supplier#8298 292814.0 2023-09-07   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 336738 2026-08-03T14:56:00.088500+00:00 municipal
282217 282217 536542 nashville_metro_payments vendor_payment 41 TN supplier#1968 261865.5 2022-08-05   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 29117 2026-08-03T14:49:46.127242+00:00 municipal
688178 688178 969700 nashville_metro_payments vendor_payment 41 TN supplier#1968 232179.5 2024-02-21   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 466268 2026-08-03T15:34:11.876520+00:00 municipal
567936 567936 844167 nashville_metro_payments vendor_payment 41 TN supplier#8298 178489.0 2023-09-07   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 336742 2026-08-03T14:56:00.088500+00:00 municipal
333729 333729 592448 nashville_metro_payments vendor_payment 41 TN supplier#1003072 163047.57 2022-10-28   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 85023 2026-08-03T14:50:57.455060+00:00 municipal
1091582 1091582 1373104 nashville_metro_payments vendor_payment 41 TN supplier#14862 159500.0 2024-12-11   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 892514 2026-08-03T15:43:49.271636+00:00 municipal
436570 436570 703912 nashville_metro_payments vendor_payment 41 TN supplier#8298 156932.0 2023-03-30   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 196487 2026-08-03T14:53:09.533307+00:00 municipal
552207 552207 827135 nashville_metro_payments vendor_payment 41 TN supplier#22330 144249.68 2023-08-11   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 319710 2026-08-03T14:55:35.801249+00:00 municipal
436577 436577 703921 nashville_metro_payments vendor_payment 41 TN supplier#8298 141315.0 2023-03-30   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 196496 2026-08-03T14:53:09.533307+00:00 municipal
820227 820227 1101749 nashville_metro_payments vendor_payment 41 TN supplier#1003072 139760.8 2024-03-22   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 604327 2026-08-03T15:37:02.475505+00:00 municipal
281894 281894 536135 nashville_metro_payments vendor_payment 41 TN supplier#270 135000.0 2022-08-03   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 28710 2026-08-03T14:49:46.127242+00:00 municipal
818804 818804 1100326 nashville_metro_payments vendor_payment 41 TN supplier#217 134442.69 2024-03-21   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 602827 2026-08-03T15:37:02.475505+00:00 municipal
416362 416362 682102 nashville_metro_payments vendor_payment 41 TN supplier#8142 131260.67 2023-03-02   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 174677 2026-08-03T14:52:39.904977+00:00 municipal
410149 410149 675394 nashville_metro_payments vendor_payment 41 TN supplier#8298 129911.0 2023-02-23   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 167969 2026-08-03T14:52:33.028899+00:00 municipal
329785 329785 588244 nashville_metro_payments vendor_payment 41 TN supplier#8298 123611.0 2022-10-20   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 80819 2026-08-03T14:50:51.835966+00:00 municipal
410151 410151 675396 nashville_metro_payments vendor_payment 41 TN supplier#8298 122470.0 2023-02-23   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 167971 2026-08-03T14:52:33.028899+00:00 municipal
645874 645874 927396 nashville_metro_payments vendor_payment 41 TN supplier#7073 117647.66 2023-12-21   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 420495 2026-08-03T15:33:15.200955+00:00 municipal
411519 411519 676836 nashville_metro_payments vendor_payment 41 TN supplier#26549 114890.0 2023-02-24   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 169411 2026-08-03T14:52:33.028899+00:00 municipal
548069 548069 822641 nashville_metro_payments vendor_payment 41 TN supplier#26549 113252.98 2023-08-07   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 315216 2026-08-03T14:55:35.801249+00:00 municipal
380752 380752 643466 nashville_metro_payments vendor_payment 41 TN supplier#1003072 112972.73 2023-01-05   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 136041 2026-08-03T14:51:57.123968+00:00 municipal
1015953 1015953 1297475 nashville_metro_payments vendor_payment 41 TN supplier#1968 106225.5 2024-09-26   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 812435 2026-08-03T15:41:40.604262+00:00 municipal
638532 638532 920054 nashville_metro_payments vendor_payment 41 TN supplier#17255 104304.74 2023-12-12   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 412719 2026-08-03T15:33:08.243775+00:00 municipal
1230221 1230221 1511743 nashville_metro_payments vendor_payment 41 TN supplier#1015912 103007.86 2025-05-07   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1039641 2026-08-03T15:47:11.461695+00:00 municipal
827328 827328 1108850 nashville_metro_payments vendor_payment 41 TN supplier#17255 102998.7 2024-03-28   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 611912 2026-08-03T15:37:15.828236+00:00 municipal
643670 643670 925192 nashville_metro_payments vendor_payment 41 TN supplier#17255 102526.06 2023-12-15   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 418215 2026-08-03T15:33:15.200955+00:00 municipal
648239 648239 929761 nashville_metro_payments vendor_payment 41 TN supplier#17255 101609.09 2023-12-26   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 422997 2026-08-03T15:33:20.474014+00:00 municipal
846123 846123 1127645 nashville_metro_payments vendor_payment 41 TN supplier#17255 100796.28 2024-04-12   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 631661 2026-08-03T15:37:36.618964+00:00 municipal
660745 660745 942267 nashville_metro_payments vendor_payment 41 TN supplier#17255 99835.76 2024-01-11   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 436629 2026-08-03T15:33:33.949988+00:00 municipal
841588 841588 1123110 nashville_metro_payments vendor_payment 41 TN supplier#17255 99828.79 2024-04-05   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 626920 2026-08-03T15:37:30.963866+00:00 municipal
852748 852748 1134270 nashville_metro_payments vendor_payment 41 TN supplier#17255 99759.19 2024-04-19   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 638769 2026-08-03T15:37:49.857249+00:00 municipal
689647 689647 971169 nashville_metro_payments vendor_payment 41 TN supplier#17255 98794.59 2024-02-23   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 467798 2026-08-03T15:34:11.876520+00:00 municipal
821604 821604 1103126 nashville_metro_payments vendor_payment 41 TN supplier#17255 98638.62 2024-03-22   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 605767 2026-08-03T15:37:02.475505+00:00 municipal
862985 862985 1144507 nashville_metro_payments vendor_payment 41 TN supplier#17255 98550.27 2024-04-30   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 649461 2026-08-03T15:38:05.935382+00:00 municipal
807936 807936 1089458 nashville_metro_payments vendor_payment 41 TN supplier#17255 98441.43 2024-03-08   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 591195 2026-08-03T15:36:48.649964+00:00 municipal
801432 801432 1082954 nashville_metro_payments vendor_payment 41 TN supplier#17255 98219.27 2024-03-01   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 584142 2026-08-03T15:36:34.909474+00:00 municipal
879645 879645 1161167 nashville_metro_payments vendor_payment 41 TN supplier#17255 97771.33 2024-05-10   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 667060 2026-08-03T15:38:26.415901+00:00 municipal
567933 567933 844164 nashville_metro_payments vendor_payment 41 TN supplier#8298 97605.0 2023-09-07   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 336739 2026-08-03T14:56:00.088500+00:00 municipal
656221 656221 937743 nashville_metro_payments vendor_payment 41 TN supplier#17255 97058.94 2024-01-03   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 431704 2026-08-03T15:33:27.218134+00:00 municipal
815870 815870 1097392 nashville_metro_payments vendor_payment 41 TN supplier#17255 96994.97 2024-03-15   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 599626 2026-08-03T15:36:55.148277+00:00 municipal
1088387 1088387 1369909 nashville_metro_payments vendor_payment 41 TN supplier#228985 96310.01 2024-12-05   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 889123 2026-08-03T15:43:49.271636+00:00 municipal
638534 638534 920056 nashville_metro_payments vendor_payment 41 TN supplier#17255 95013.41 2023-12-12   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 412721 2026-08-03T15:33:08.243775+00:00 municipal
947410 947410 1228932 nashville_metro_payments vendor_payment 41 TN supplier#25079 94596.71 2024-07-09   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 738601 2026-08-03T15:39:59.722037+00:00 municipal
638530 638530 920052 nashville_metro_payments vendor_payment 41 TN supplier#17255 94173.98 2023-12-12   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 412717 2026-08-03T15:33:08.243775+00:00 municipal
567935 567935 844166 nashville_metro_payments vendor_payment 41 TN supplier#8298 94164.0 2023-09-07   Sheriff   Metro department Sheriff (30)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 336741 2026-08-03T14:56:00.088500+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);