home / mytown-research

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,514 rows where category = "Juvenile Court", source = "nashville_metro_payments" and state = "TN" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

state 1

  • TN · 3,514 ✖

source 1

  • nashville_metro_payments · 3,514 ✖

record_type 1

  • vendor_payment 3,514

category 1

  • Juvenile Court · 3,514 ✖
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
1470865 1470865 1752387 nashville_metro_payments vendor_payment 41 TN supplier#2272 6421352.42 2025-12-26   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1294397 2026-08-03T15:53:06.261145+00:00 municipal
1302957 1302957 1584479 nashville_metro_payments vendor_payment 41 TN supplier#2272 5300724.0 2025-07-02   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1115956 2026-08-03T15:49:02.055670+00:00 municipal
1392127 1392127 1673649 nashville_metro_payments vendor_payment 41 TN supplier#2272 4894779.55 2025-10-06   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1210873 2026-08-03T15:51:16.036956+00:00 municipal
1450333 1450333 1731855 nashville_metro_payments vendor_payment 41 TN supplier#2272 4863320.8 2025-12-05   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1272312 2026-08-03T15:52:35.542036+00:00 municipal
1325391 1325391 1606913 nashville_metro_payments vendor_payment 41 TN supplier#2272 4835998.09 2025-07-30   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1139990 2026-08-03T15:49:36.705719+00:00 municipal
1348583 1348583 1630105 nashville_metro_payments vendor_payment 41 TN supplier#2272 4666779.27 2025-08-29   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1164877 2026-08-03T15:50:12.768346+00:00 municipal
1450332 1450332 1731854 nashville_metro_payments vendor_payment 41 TN supplier#2272 4504471.73 2025-12-05   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1272311 2026-08-03T15:52:35.542036+00:00 municipal
1421314 1421314 1702836 nashville_metro_payments vendor_payment 41 TN supplier#2272 4381866.67 2025-11-04   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1241753 2026-08-03T15:51:51.613166+00:00 municipal
1392126 1392126 1673648 nashville_metro_payments vendor_payment 41 TN supplier#2272 3443755.33 2025-10-06   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1210872 2026-08-03T15:51:16.036956+00:00 municipal
1222156 1222156 1503678 nashville_metro_payments vendor_payment 41 TN supplier#2272 3198966.73 2025-04-30   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1031284 2026-08-03T15:47:03.542997+00:00 municipal
1114760 1114760 1396282 nashville_metro_payments vendor_payment 41 TN supplier#2272 3177482.34 2025-01-03   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 917094 2026-08-03T15:44:29.480922+00:00 municipal
1160271 1160271 1441793 nashville_metro_payments vendor_payment 41 TN supplier#2272 3170956.33 2025-02-28   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 965398 2026-08-03T15:45:31.836289+00:00 municipal
1421313 1421313 1702835 nashville_metro_payments vendor_payment 41 TN supplier#2272 2962132.71 2025-11-04   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1241752 2026-08-03T15:51:51.613166+00:00 municipal
1470855 1470855 1752377 nashville_metro_payments vendor_payment 41 TN supplier#2272 2904243.98 2025-12-26   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1294387 2026-08-03T15:53:06.261145+00:00 municipal
1348582 1348582 1630104 nashville_metro_payments vendor_payment 41 TN supplier#2272 2682450.0 2025-08-29   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1164876 2026-08-03T15:50:12.768346+00:00 municipal
1191221 1191221 1472743 nashville_metro_payments vendor_payment 41 TN supplier#2272 2347285.92 2025-03-31   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 998298 2026-08-03T15:46:13.136208+00:00 municipal
1133357 1133357 1414879 nashville_metro_payments vendor_payment 41 TN supplier#2272 2286097.96 2025-01-30   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 936953 2026-08-03T15:44:56.266124+00:00 municipal
1270553 1270553 1552075 nashville_metro_payments vendor_payment 41 TN supplier#2272 1923609.77 2025-06-02   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1081938 2026-08-03T15:48:08.685821+00:00 municipal
1450331 1450331 1731853 nashville_metro_payments vendor_payment 41 TN supplier#2272 1829704.34 2025-12-05   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1272310 2026-08-03T15:52:35.542036+00:00 municipal
1348581 1348581 1630103 nashville_metro_payments vendor_payment 41 TN supplier#2272 1787775.65 2025-08-29   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1164875 2026-08-03T15:50:12.768346+00:00 municipal
1470853 1470853 1752375 nashville_metro_payments vendor_payment 41 TN supplier#2272 1783180.44 2025-12-26   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1294385 2026-08-03T15:53:06.261145+00:00 municipal
1270552 1270552 1552074 nashville_metro_payments vendor_payment 41 TN supplier#2272 1737731.02 2025-06-02   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1081937 2026-08-03T15:48:08.685821+00:00 municipal
1421312 1421312 1702834 nashville_metro_payments vendor_payment 41 TN supplier#2272 1700368.05 2025-11-04   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1241751 2026-08-03T15:51:51.613166+00:00 municipal
1222151 1222151 1503673 nashville_metro_payments vendor_payment 41 TN supplier#2272 1543622.99 2025-04-30   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1031279 2026-08-03T15:47:03.542997+00:00 municipal
1325388 1325388 1606910 nashville_metro_payments vendor_payment 41 TN supplier#2272 1525202.21 2025-07-30   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1139987 2026-08-03T15:49:36.705719+00:00 municipal
1421311 1421311 1702833 nashville_metro_payments vendor_payment 41 TN supplier#2272 1486517.08 2025-11-04   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1241750 2026-08-03T15:51:51.613166+00:00 municipal
1302956 1302956 1584478 nashville_metro_payments vendor_payment 41 TN supplier#2272 1460645.93 2025-07-02   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1115955 2026-08-03T15:49:02.055670+00:00 municipal
1222143 1222143 1503665 nashville_metro_payments vendor_payment 41 TN supplier#2272 1412224.35 2025-04-30   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1031271 2026-08-03T15:47:03.542997+00:00 municipal
1325385 1325385 1606907 nashville_metro_payments vendor_payment 41 TN supplier#2272 1357525.33 2025-07-30   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1139984 2026-08-03T15:49:36.705719+00:00 municipal
1302955 1302955 1584477 nashville_metro_payments vendor_payment 41 TN supplier#2272 1324552.69 2025-07-02   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1115954 2026-08-03T15:49:02.055670+00:00 municipal
1302954 1302954 1584476 nashville_metro_payments vendor_payment 41 TN supplier#2272 1322385.33 2025-07-02   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1115953 2026-08-03T15:49:02.055670+00:00 municipal
1222140 1222140 1503662 nashville_metro_payments vendor_payment 41 TN supplier#2272 1311289.2 2025-04-30   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1031268 2026-08-03T15:47:03.542997+00:00 municipal
1270551 1270551 1552073 nashville_metro_payments vendor_payment 41 TN supplier#2272 1178921.0 2025-06-02   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1081936 2026-08-03T15:48:08.685821+00:00 municipal
1191218 1191218 1472740 nashville_metro_payments vendor_payment 41 TN supplier#2272 1124598.47 2025-03-31   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 998295 2026-08-03T15:46:13.136208+00:00 municipal
1077857 1077857 1359379 nashville_metro_payments vendor_payment 41 TN supplier#2272 1080981.05 2024-11-29   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 878058 2026-08-03T15:43:35.593551+00:00 municipal
1078119 1078119 1359641 nashville_metro_payments vendor_payment 41 TN supplier#22415 1032739.08 2024-11-29   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 878385 2026-08-03T15:43:35.593551+00:00 municipal
1392125 1392125 1673647 nashville_metro_payments vendor_payment 41 TN supplier#2272 953904.14 2025-10-06   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1210871 2026-08-03T15:51:16.036956+00:00 municipal
1270550 1270550 1552072 nashville_metro_payments vendor_payment 41 TN supplier#2272 941482.9 2025-06-02   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1081935 2026-08-03T15:48:08.685821+00:00 municipal
985928 985928 1267450 nashville_metro_payments vendor_payment 41 TN supplier#22415 902361.31 2024-08-28   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 780334 2026-08-03T15:40:51.766195+00:00 municipal
1450330 1450330 1731852 nashville_metro_payments vendor_payment 41 TN supplier#2272 899128.5 2025-12-05   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1272309 2026-08-03T15:52:35.542036+00:00 municipal
1191215 1191215 1472737 nashville_metro_payments vendor_payment 41 TN supplier#2272 877527.65 2025-03-31   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 998292 2026-08-03T15:46:13.136208+00:00 municipal
1061975 1061975 1343497 nashville_metro_payments vendor_payment 41 TN supplier#22415 816506.69 2024-11-08   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 861161 2026-08-03T15:43:02.559446+00:00 municipal
1123398 1123398 1404920 nashville_metro_payments vendor_payment 41 TN supplier#22415 797606.43 2025-01-15   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 926247 2026-08-03T15:44:42.687969+00:00 municipal
1048345 1048345 1329867 nashville_metro_payments vendor_payment 41 TN supplier#2272 794820.7 2024-10-30   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 846789 2026-08-03T15:42:39.130321+00:00 municipal
1176868 1176868 1458390 nashville_metro_payments vendor_payment 41 TN supplier#22415 784374.59 2025-03-12   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 983104 2026-08-03T15:45:53.357317+00:00 municipal
1160270 1160270 1441792 nashville_metro_payments vendor_payment 41 TN supplier#2272 780000.0 2025-02-28   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 965397 2026-08-03T15:45:31.836289+00:00 municipal
1148422 1148422 1429944 nashville_metro_payments vendor_payment 41 TN supplier#22415 746187.82 2025-02-13   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 952805 2026-08-03T15:45:17.782586+00:00 municipal
1470850 1470850 1752372 nashville_metro_payments vendor_payment 41 TN supplier#2272 743535.09 2025-12-26   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 1294382 2026-08-03T15:53:06.261145+00:00 municipal
1010994 1010994 1292516 nashville_metro_payments vendor_payment 41 TN supplier#22415 738697.62 2024-09-20   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 807162 2026-08-03T15:41:29.212245+00:00 municipal
944878 944878 1226400 nashville_metro_payments vendor_payment 41 TN supplier#22415 688654.15 2024-07-05   Juvenile Court   Metro department Juvenile Court (26)       https://data.nashville.gov/datasets/Nashville::metro-vendor-payments 735954 2026-08-03T15:39:52.291236+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);
Powered by Datasette · Queries took 6294.97ms · Data license: CC BY 4.0 · Data source: MyTown