surveillance_spending

A DISCOVERY INDEX of surveillance and police-technology dollar figures found in local government meeting records across 130+ named vendors — NOT a table of confirmed spending, and NOT safe to SUM. An audit on 2026-07-29 found aggregate views were adding amounts that must not be added: the same procurement recurs at committee, council, approval, amendment and renewal stages; "not to exceed" figures are authorization ceilings, not payments. Use the canned query "the CONSERVATIVE total" for any number you intend to publish, and "data-quality report" to see what is flagged. Columns added for this: `amount_type` (stated / ceiling / proposed / recommended / estimated), `dup_rank` (>1 = redundant copy), `geo_suspect` (city disagrees with the source link), `anomaly` (implausible figure), `state_norm` (normalized state). Vendors covered include ALPR (Flock, Vigilant, Genetec), body cameras/tasers (Axon, WatchGuard, Utility, Getac), gunshot detection (ShotSpotter/SoundThinking), face recognition (Clearview AI, DataWorks Plus), fingerprint biometrics (Idemia AFIS/Livescan, filed separately under `sv:biometrics`), data fusion and OSINT (Fusus, Peregrine, LexisNexis Accurint, Thomson Reuters CLEAR), phone forensics (Cellebrite, GrayKey, Magnet), drones (Skydio, BRINC, DJI), cameras/VMS (Verkada, Avigilon), cell-site simulators, CAD/RMS records systems, photo enforcement, jail-call and student monitoring. Every row carries a VERBATIM quote from the minutes and a link to the source document, and a row only publishes if that quote was found character-for-character in the source text. READ THE `ledger` COLUMN: `sv:<category>:<vendor>`. `radio_infra` (two-way radios), `rms` (records/CAD software), `biometrics` (fingerprints) and `not_surveillance` are NOT surveillance sensors — exclude them before quoting any surveillance figure.

Data license: CC BY 4.0 · Data source: MyTown

69 rows where state = "WY" sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: city, amount_type, dup_rank, spend_date (date)

state 1

Link rowid vendor city state spend_date product amount ▲ quote source_document mytown_record ledger amount_type dup_rank geo_suspect anomaly state_norm
214 214 Axon Laramie WY 2026-07-21   1002250.63 MOTION BY FRIED, seconded by Newman, to approve the five-year contract with Axon Enterprise, Inc. for Axon Officer Safety and Digital Evident Platform in the amount of one million two thousand two hundred fifty dollars and sixty-three cents ( $1,002,250.63 ) , and au https://www.cityoflaramie.org/AgendaCenter/ViewFile/Minutes/_07212026-3900 https://mytown.theboringparts.com/city/cityoflaramie.org/#m1005671 axon stated 1 0 0 WY
263 263 Axon Cheyenne WY 2023-12-21 body cameras 800797.5 Purchase of Axon Body 4 police body cameras from Axon Enterprise, Inc. for $800,797.50. https://cheyenne.granicus.com/AgendaViewer.php?view_id=6&clip_id=933 https://mytown.theboringparts.com/city/gr-cheyenne/2023/#m70120 axon stated 1 0 0 WY
349 349 Axon Campbell County WY 2023-07-18 Fleet ALPR 492948.0 Commissioner Ford moved the Board approve the Sole Source Purchase Request and agreement between Axon Enterprise, Inc and the Campbell County Sheriff's Office to lease vehicle cameras, in the amount of $492,948.00, for a 60-month period from January 2024 to January 2028, as presented. https://campbellcowy.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=8129,plainText=false) https://mytown.theboringparts.com/city/campbellcowy/2023/#m788730 axon stated 1 0 0 WY
480 480 Axon Laramie WY 2024-08-06 bundle/OSP 267865.92 aling $267,865.92 through 2028, and authorize the Mayor and City Clerk to sign. https://www.cityoflaramie.org/AgendaCenter/ViewFile/Minutes/_08062024-3420 https://mytown.theboringparts.com/city/cityoflaramie.org/2024/#m1233271 axon stated 1 0 0 WY
2416 2416 Motorola Solutions Lincoln County WY 2024-01-16 body cams & dash cams (approve vouchers) 233381.0 Motorola; Sheriff, body cams & dash cams $ 233,381.01 https://www.lincolncountywy.gov/Documents/Government/County%20Commissioners/Agendas%20And%20Minutes/2024/Minutes/OFFICIAL%20PROCEEDINGS%20%20january%2016,%202024...pdf https://mytown.theboringparts.com/city/rz-lincolncountywy.gov/2024/#m7720123 sv:motorola:motorola stated 1 0 0 WY
4046 4046 Motorola Solutions Teton County WY 2024-01-29 two-way radios (purchase) 209380.0 MOTOROLA SOLUTIONS, INC. 209,380.00 https://www.tetoncountywy.gov/AgendaCenter/ViewFile/Minutes/_01292024-2355 https://mytown.theboringparts.com/city/tetoncountywy.gov/2024/#m1199916 sv:radio_infra:motorola stated 1 0 0 WY
2820 2820 Motorola Solutions Teton County WY 2024-04-15 two-way radios (approve payment) 122000.0 Chair Propst noting he was happy to see a $122,000 item for Motorola Solutions to improve emergency communication with radio s . https://www.tetoncountywy.gov/AgendaCenter/ViewFile/Minutes/_04152024-2409 https://mytown.theboringparts.com/city/tetoncountywy.gov/2024/#m1199894 sv:radio_infra:motorola stated 1 0 0 WY
2498 2498 Motorola Solutions Green River WY 2026-03-17 body cameras (approve contract) 110039.0 Council Member Killpack moved to approve the agreement with Motorola Solutions, Inc., for the purchase of new V700 body cameras for the Police Department , in the amount of $110,039 and authorize the Mayor to sign the agreement, the Governing Body hereby finding that the commitment of Motorola Solutions, Inc., to provide the services specified for the term of years specified has been determined to constitute a significant benefit and advantage to the City and the Public, in that such services are not readily or economically available to the City in the absence of an extended term contract. https://www.cityofgreenriver.org/AgendaCenter/ViewFile/Minutes/_03172026-450 https://mytown.theboringparts.com/city/cityofgreenriver.org/#m1579550 sv:motorola:motorola stated 1 0 0 WY
719 719 Axon Campbell County WY 2025-09-16 Evidence.com 107960.34 Axon Enterprise Software Cost (Subs/Maint) $107,960.34 https://campbellcowy.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=12164,plainText=false) https://mytown.theboringparts.com/city/campbellcowy/2025/#m789082 axon stated 1 0 0 WY
772 772 Axon Cheyenne WY 2025-12-22 body cameras 96974.6 Purchase of ten Axon Enterprise, Inc. In-Car Camera Systems for $96,974.60 https://cheyenne.granicus.com/AgendaViewer.php?view_id=6&clip_id=1048 https://mytown.theboringparts.com/city/gr-cheyenne/#m70067 axon stated 1 0 0 WY
849 849 Axon Laramie WY 2024-08-06 body cameras 74753.28 Budget amendment and contract amendment for Axon body-worn camera software increasing annual cost by $74,753.28 https://www.cityoflaramie.org/AgendaCenter/ViewFile/Minutes/_08062024-3420 https://mytown.theboringparts.com/city/cityoflaramie.org/2024/#m1233271 axon stated 1 0 0 WY
860 860 Axon Campbell County WY 2026-03-18 Evidence.com 71181.68 Axon Enterprise Software Cost (Subs/Maint) $71,181.68 https://campbellcowy.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=12263,plainText=false) https://mytown.theboringparts.com/city/campbellcowy/#m789139 axon stated 1 0 0 WY
917 917 Axon Lincoln County WY 2023-08-15 tasers 59998.65 Axon Enterprise; Sheriff, tasers $ 59,998.65 https://www.lincolncountywy.gov/Documents/Government/County%20Commissioners/Agendas%20And%20Minutes/2023/Minutes/OFFICIAL%20PROCEEDINGS%20%20AUGUST%2015,%20%202023..%20(1).pdf https://mytown.theboringparts.com/city/rz-lincolncountywy.gov/2023/#m7720133 axon stated 1 0 0 WY
970 970 Axon Converse County WY 2025-06-17 Tasers 49998.68 Mr. Blackburn moved to approve the Quote and Agreement between Converse County and Axon Enterprise, Inc. for a five-year taser lease from June 2025 to June 2030 for 10 tasers plus all associated licensing and certifications for a total cost of $49,998.68 for the full term; https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_06172025-861 https://mytown.theboringparts.com/city/conversecountywy.gov/2025/#m1460379 axon stated 1 0 0 WY
3955 3955 L3Harris Sublette County WY 2023-08-15 surveillance systems (purchase) 45000.0 L3HARRIS TECHNOLOGIES, INC 45,000.00 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_08152023-139 https://mytown.theboringparts.com/city/sublettecountywy.gov/2023/#m1568425 sv:intercept:l3harris stated 1 0 0 WY
3962 3962 L3Harris Sublette County WY 2025-07-01 surveillance systems (approve accounts payable) 45000.0 L3HARRIS TECHNOLOGIES,INC 45,000.00 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_07012025-201 https://mytown.theboringparts.com/city/sublettecountywy.gov/2025/#m1568397 sv:intercept:l3harris stated 1 0 0 WY
1011 1011 Axon Rock Springs WY 2024-08-20 Tasers 40470.08 A Resolution accepting and approving a Quote from Axon Enterprise, Inc. for Axon Tasers, warranties, and software, in the amount of $40,470.08 https://towncloud.io/go/rock-springs-wy/agendas/544/PDF/get_agenda_document_link https://mytown.theboringparts.com/city/rock-springs-wy/2024/#m1605992 axon stated 1 0 0 WY
1037 1037 Axon Laramie County WY 2025-09-16 other 37082.0 Consideration of an agreement between Laramie County, WY, and Axon Enterprises, Inc, in an amount not to exceed $ 37,082 to purchase two Axon Sky-Hero Sigyn Ground Robots including accessories and warranty. https://laramiecounty.legistar1.com/laramiecounty/meetings/2025/9/2176_M_Board_of_County_Commissioners_25-09-16_Minutes_of_the_Proceedings.pdf https://mytown.theboringparts.com/city/laramiecounty/2025/#m621392 axon ceiling 1 0 0 WY
2585 2585 WatchGuard Video Converse County WY 2024-03-19 vehicle and body cameras (purchase) 30789.0 The Commissioners ’ authorized the purchase of five new Watchguard vehicle and body cameras in the amount of $30,789.50 for FY2024; it is anticipated that a budget amendment will not be required. https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_03192024-739 https://mytown.theboringparts.com/city/conversecountywy.gov/#m1460540 sv:bodycam:watchguard stated 1 0 0 WY
1106 1106 Axon Converse County WY 2024-06-18 Tasers 29400.0 Mr. Kaufman moved to approve the contract between the Converse County Sheriff ’s Office and Axon Enterprises, Inc. for a term of five years for a total cost $29,400 for ten Tasers plus software and warranty; https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_06182024-759 https://mytown.theboringparts.com/city/conversecountywy.gov/2024/#m1460526 axon stated 1 0 0 WY
3957 3957 Idemia Sublette County WY 2023-10-17 biometric systems (approve payment) 25830.0 IDEMIA IDENTITY & SECURITY USA LLC 25,830.00 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_10172023-143 https://mytown.theboringparts.com/city/sublettecountywy.gov/2023/#m1568421 sv:face:idemia stated 1 0 0 WY
4049 4049 Cellebrite Teton County WY 2026-01-26 mobile forensics software (payment of voucher) 23181.0 433478 CELLEBRITE, INC 23,181.00 https://www.tetoncountywy.gov/AgendaCenter/ViewFile/Minutes/_01262026-2854 https://mytown.theboringparts.com/city/tetoncountywy.gov/#m1199030 sv:forensics:cellebrite stated 1 0 0 WY
3950 3950 Cellebrite Sublette County WY 2024-09-17 mobile forensics software (approve accounts payable) 22500.0 CELLEBRITE USA, CORP. 22,500.00 / 49ER COMMUNICATIONS, INC. 625.95 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_09172024-172 https://mytown.theboringparts.com/city/sublettecountywy.gov/2024/#m1568453 sv:forensics:cellebrite stated 1 0 0 WY
3964 3964 Cellebrite Sublette County WY 2026-03-17 mobile forensics software (approve accounts payable) 21581.0 CELLEBRITE USA, CORP. 21,581.00 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_03172026-227 https://mytown.theboringparts.com/city/sublettecountywy.gov/#m1568314 sv:forensics:cellebrite stated 1 0 0 WY
3972 3972 Cellebrite Evanston WY 2025-09-02 mobile forensics equipment (approve bills for payment) 21169.0 Cellebrite Inc. Equipment 21169.00 https://www.evanstonwy.org/AgendaCenter/ViewFile/Minutes/_09022025-616 https://mytown.theboringparts.com/city/evanstonwy.org/2025/#m1520191 sv:forensics:cellebrite stated 1 0 0 WY
3959 3959 Cellebrite Sublette County WY 2025-04-01 mobile forensics (approve accounts payable) 20545.0 CELLEBRITE USA, CORP. 20,545.20 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_04012025-186 https://mytown.theboringparts.com/city/sublettecountywy.gov/2025/#m1568410 sv:forensics:cellebrite stated 1 0 0 WY
4047 4047 Cellebrite Teton County WY 2024-02-12 mobile forensics (purchase) 19000.0 417497 CELLEBRITE, INC 19,000.00 https://www.tetoncountywy.gov/AgendaCenter/ViewFile/Minutes/_02122024-2366 https://mytown.theboringparts.com/city/tetoncountywy.gov/2024/#m1199911 sv:forensics:cellebrite stated 1 0 0 WY
3960 3960 Magnet Forensics Sublette County WY 2025-04-01 AXIOM software license (approve accounts payable) 16400.0 MAGNET FORENSICS USA, INC 16,400.00 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_04012025-186 https://mytown.theboringparts.com/city/sublettecountywy.gov/2025/#m1568410 sv:forensics:magnet stated 1 0 0 WY
2975 2975 Cellebrite Campbell County WY 2025-04-15 digital forensics software (approve contract) 15000.0 Commissioner Clem moved the Board approve the Memorandum of Understanding between OUR Rescue and the Campbell County Sheriff's Office for the purchase of Cellebrite Premium, a digital forensics software, in the amount of $15,000 with a local match of $7,250, for a period of June 1, 2025, to May 31, 2026, as presented. https://campbellcowy.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=11872,plainText=false) https://mytown.theboringparts.com/city/campbellcowy/2025/#m789026 sv:forensics:cellebrite stated 1 0 0 WY
2976 2976 Cellebrite Campbell County WY 2025-02-19 digital forensics software (approve grant application for purchase) 15000.0 Commissioner Jordan moved the Board approve the submission of the OUR Rescue grant application for a one-time payment of up to $15,000 for the Sheriffs Office to purchase Cellebrite Premium, a digital forensics software, as presented. https://campbellcowy.api.civicclerk.com/v1/Meetings/GetMeetingFileStream(fileId=11756,plainText=false) https://mytown.theboringparts.com/city/campbellcowy/2025/#m789006 sv:forensics:cellebrite ceiling 1 0 0 WY
3236 3236 Cellebrite Converse County WY 2026-07-07 UFED subscription (approve warrants) 14770.0 Cellebrite $14,770.00 Subscrip https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_07072026-952 https://mytown.theboringparts.com/city/conversecountywy.gov/#m621323 sv:forensics:cellebrite stated 1 0 0 WY
3238 3238 Cellebrite Converse County WY 2026-07-08 mobile forensics subscription (approve warrants) 14770.0 Cellebrite $14,770.00 Subscrip https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_07082026-953 https://mytown.theboringparts.com/city/conversecountywy.gov/#m621322 sv:forensics:cellebrite stated 2 0 0 WY
3952 3952 Grayshift / GrayKey Sublette County WY 2023-05-02 iPhone/Android extraction devices (approved) 11620.0 GRAYSHIFT, LLC 11,620.00 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_05022023-126 https://mytown.theboringparts.com/city/sublettecountywy.gov/2023/#m1568437 sv:forensics:grayshift stated 1 0 0 WY
3992 3992 Cellebrite Converse County WY 2024-08-06 mobile forensics subscription (approve monthly warrant) 11560.0 Cellebrite 11560.80 Subcrip https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_08062024-781 https://mytown.theboringparts.com/city/conversecountywy.gov/2024/#m1460520 sv:forensics:cellebrite stated 1 0 0 WY
3993 3993 Cellebrite Converse County WY 2024-08-07 UFED subscription (purchase) 11560.0 Cellebrite 11560.80 Subcrip https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_08072024-782 https://mytown.theboringparts.com/city/conversecountywy.gov/2024/#m1460519 sv:forensics:cellebrite stated 2 0 0 WY
3234 3234 Magnet Forensics Converse County WY 2026-05-05 AXIOM/GrayKey software (purchase) 9720.0 Magnet Forensics $9,720.00 https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_05052026-936 https://mytown.theboringparts.com/city/conversecountywy.gov/#m621330 sv:forensics:magnet stated 1 0 0 WY
3235 3235 Magnet Forensics Converse County WY 2026-05-06 AXIOM/GrayKey software (purchase) 9720.0 Magnet Forensics $9,720.00 Utilities; https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_05062026-937 https://mytown.theboringparts.com/city/conversecountywy.gov/#m621329 sv:forensics:magnet stated 1 0 0 WY
2586 2586 Magnet Forensics Converse County WY 2026-01-06 AXIOM/GrayKey software (approve contract) 9540.0 Magnet Forensics $9,540 Contract; https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_01062026-904 https://mytown.theboringparts.com/city/conversecountywy.gov/#m1460298 sv:forensics:magnet stated 1 0 0 WY
2587 2587 Magnet Forensics Converse County WY 2026-01-07 AXIOM/GrayKey software (approve contract) 9540.0 Magnet Forensics $9,540 Contract; https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_01072026-905 https://mytown.theboringparts.com/city/conversecountywy.gov/#m1460297 sv:forensics:magnet stated 2 0 0 WY
3928 3928 RapidSOS Lincoln County WY 2025-09-02 text to 911 (renew) 8869.0 Rapid SOS Inc.; LCEMA, text to 911 $ 8,869.05 https://www.lincolncountywy.gov/Documents/Government/County%20Commissioners/Agendas%20And%20Minutes/2025/Minutes/OFFICIAL%20PROCEEDINGS%20SEPTEMBER%202-3,%202025..%20(1).pdf https://mytown.theboringparts.com/city/rz-lincolncountywy.gov/#m7720082 sv:other:rapidsos stated 1 0 0 WY
3994 3994 Oxygen Forensic Converse County WY 2025-08-05 forensic software (purchase) 8545.0 Oxygen Forensics 8545.50 Svc https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_08052025-873 https://mytown.theboringparts.com/city/conversecountywy.gov/2025/#m1460374 sv:forensics:oxygen stated 1 0 0 WY
3995 3995 Oxygen Forensic Converse County WY 2025-08-06 forensic software (purchase) 8545.0 Oxygen Forensics 8545.50 Svc https://www.conversecountywy.gov/AgendaCenter/ViewFile/Minutes/_08062025-874 https://mytown.theboringparts.com/city/conversecountywy.gov/2025/#m1460373 sv:forensics:oxygen stated 2 0 0 WY
2417 2417 RapidSOS Lincoln County WY 2024-05-21 emergency-data platform (fee) 6726.0 Rapid SOS, Inc; LCEMA/911, fee $ 6,726.00 https://www.lincolncountywy.gov/Documents/Government/County%20Commissioners/Agendas%20And%20Minutes/2024/Minutes/OFFICIAL%20PROCEEDINGS%20%20May%2021,%202024..%20(1).pdf https://mytown.theboringparts.com/city/rz-lincolncountywy.gov/2024/#m7720115 sv:other:rapidsos stated 1 0 0 WY
2420 2420 Motorola Solutions Sheridan County WY 2024-10-01 video equipment (purchase) 6588.0 MOTOROLA SOLUTIONS INC $6,588.00 VIDEO EQUIPMENT https://www.sheridancountywy.gov/Document%20Center/Agendas%20And%20Minutes/Commissioners/2024/BOCC/10-01-2024%20Regular%20Meeting%20Minutes.pdf https://mytown.theboringparts.com/city/rz-sheridancountywy.gov/2024/#m7717530 sv:motorola:motorola stated 1 0 0 WY
3951 3951 Cellebrite Sublette County WY 2023-05-02 mobile forensics software (approve payment) 6450.0 CELLEBRITE USA, CORP. 6,450.00 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_05022023-126 https://mytown.theboringparts.com/city/sublettecountywy.gov/2023/#m1568437 sv:forensics:cellebrite stated 1 0 0 WY
2418 2418 RapidSOS Lincoln County WY 2025-08-05 emergency-data platform (renew) 5976.0 Rapid SOS Inc.; LCEMA, year 3 of 5 $ 5,976.00 https://www.lincolncountywy.gov/Documents/Government/County%20Commissioners/Agendas%20And%20Minutes/2025/Minutes/OFFICIAL%20PROCEEDINGS%20August%205-6,%202025...pdf https://mytown.theboringparts.com/city/rz-lincolncountywy.gov/2025/#m7720084 sv:other:rapidsos stated 1 0 0 WY
3966 3966 Idemia Sublette County WY 2026-04-07 biometric services (approve) 5052.0 IDEMIA IDENTITY & SECURITY USA LLC 5,052.00 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_04072026-228 https://mytown.theboringparts.com/city/sublettecountywy.gov/#m1568313 sv:face:idemia stated 1 0 0 WY
3965 3965 Motorola Solutions Sublette County WY 2026-03-17 two-way radios (purchase) 4880.0 MOTOROLA SOLUTIONS, INC 4,880.32 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_03172026-227 https://mytown.theboringparts.com/city/sublettecountywy.gov/#m1568314 sv:radio_infra:motorola stated 1 0 0 WY
4182 4182 Motorola Solutions Sublette County WY 2026-06-16 two-way radios (approve accounts payable) 4880.0 MOTOROLA SOLUTIONS, INC 4,880.32 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_06162026-236 https://mytown.theboringparts.com/city/sublettecountywy.gov/#m622482 sv:radio_infra:motorola stated 2 0 0 WY
3958 3958 Motorola Solutions Sublette County WY 2025-02-18 two-way radios (approve) 4561.0 MOTOROLA SOLUTIONS, INC 4,561.04 https://www.sublettecountywy.gov/AgendaCenter/ViewFile/Minutes/_02182025-182 https://mytown.theboringparts.com/city/sublettecountywy.gov/2025/#m1568413 sv:radio_infra:motorola stated 1 0 0 WY

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE surveillance_spending (
  vendor TEXT, city TEXT, state TEXT, spend_date TEXT, product TEXT,
  amount REAL, quote TEXT, source_document TEXT, mytown_record TEXT, ledger TEXT, amount_type TEXT, dup_rank INTEGER, geo_suspect INTEGER, anomaly INTEGER, state_norm TEXT);
CREATE INDEX ix_surv_vendor ON surveillance_spending(vendor);
CREATE INDEX ix_surv_state ON surveillance_spending(state);
CREATE INDEX ix_surv_amount ON surveillance_spending(amount);
CREATE INDEX ix_surv_ledger ON surveillance_spending(ledger);