people_cf_bridge

Data license: CC BY 4.0 · Data source: MyTown

283 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: cf_source, match_method, confidence, updated_at (date)

Link rowid ▼ person_id cf_source cf_filer_key cf_filer_name cf_filer_id muni_id office n_txns match_method confidence evidence updated_at
1 1 p_005528f69e6e64a8 netfile_ca 21|Tyler Maxwell for Fresno CIty Council 2020 Tyler Maxwell for Fresno CIty Council 2020   21 Fresno CIty Council 2169 netfile_name_muni_office 0.85 {"parsed_office": "Fresno CIty Council", "agency_muni_id": 21, "parsed_candidate": "Tyler Maxwell"} 2026-08-03T11:27:22Z
2 2 p_005528f69e6e64a8 netfile_ca 21|Tyler Maxwell for Fresno City Council 2024 Tyler Maxwell for Fresno City Council 2024   21 Fresno City Council 421 netfile_name_muni_office 0.85 {"parsed_office": "Fresno City Council", "agency_muni_id": 21, "parsed_candidate": "Tyler Maxwell"} 2026-08-03T11:27:22Z
3 3 p_01b4835db631a164 netfile_ca 243|Joe Marcy for Manhattan Beach City Council 2024 Joe Marcy for Manhattan Beach City Council 2024   243 Manhattan Beach City Council 23 netfile_name_muni_office 0.85 {"parsed_office": "Manhattan Beach City Council", "agency_muni_id": 243, "parsed_candidate": "Joe Marcy"} 2026-08-03T11:27:22Z
4 4 p_05b7504d5e4f1a8d nc_state_local_office NC:PEN-020AJJ-C-001 RYAN COLLINS PEN-020AJJ-C-001 3408 CYCM 1 nc_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 1, "cf_office": "CYCM", "scope_state": "NC", "cf_filer_raw": "COMMITTEE TO ELECT RYAN COLLINS", "matched_official": "Ryan Collins", "parsed_candidate": "RYAN COLLINS"}  
5 5 p_068dca7da78e5399 netfile_ca 230|Ferrero, Greg for Supervisor 2028 Ferrero, Greg for Supervisor 2028   230 Supervisor 28 netfile_name_muni_office 0.85 {"parsed_office": "Supervisor", "agency_muni_id": 230, "parsed_candidate": "Ferrero, Greg"} 2026-08-03T11:27:22Z
6 6 p_06e78705a34b076e wa_pdc KETTR--291 Robert E. Kettle (Bob Kettle) KETTR--291 4 CITY COUNCIL MEMBER 82 wa_pdc_filerid_jurisdiction_name 0.9 {"jurisdiction": "CITY OF SEATTLE", "pdc_filer_id": "KETTR--291"} 2026-08-03T11:27:22Z
7 7 p_097236c25cc6c402 netfile_ca 25|James Kuszmaul for Mountain View City Council 2026 James Kuszmaul for Mountain View City Council 2026   25 Mountain View City Council 18 netfile_name_muni_office 0.85 {"parsed_office": "Mountain View City Council", "agency_muni_id": 25, "parsed_candidate": "James Kuszmaul"} 2026-08-03T11:27:22Z
8 8 p_0988dbc5ea5ad93c wa_state_local_office WA:ELENB 264 Ben Elenbaas ELENB 264 4360 COUNTY COUNCIL MEMBER 16 wa_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 16, "cf_office": "COUNTY COUNCIL MEMBER", "scope_state": "WA", "cf_filer_raw": "Ben Elenbaas", "matched_official": "Ben Elenbaas", "parsed_candidate": "Ben Elenbaas"}  
9 9 p_0b346260f3383592 netfile_ca 76|Curtis Burton for Chino City Council, District 2, 2022 Curtis Burton for Chino City Council, District 2, 2022   76 Chino City Council, District 2, 23 netfile_name_muni_office 0.85 {"parsed_office": "Chino City Council, District 2,", "agency_muni_id": 76, "parsed_candidate": "Curtis Burton"} 2026-08-03T11:27:22Z
10 10 p_0b42dcfa75651177 netfile_ca 22|Caity Maple for City Council 2022 Caity Maple for City Council 2022   22 City Council 1672 netfile_name_muni_office 0.85 {"parsed_office": "City Council", "agency_muni_id": 22, "parsed_candidate": "Caity Maple"} 2026-08-03T11:27:22Z
11 11 p_0b42dcfa75651177 netfile_ca 22|Caity Maple for City Council 2026 Caity Maple for City Council 2026   22 City Council 574 netfile_name_muni_office 0.85 {"parsed_office": "City Council", "agency_muni_id": 22, "parsed_candidate": "Caity Maple"} 2026-08-03T11:27:22Z
12 12 p_0c6482fa8ef8eac4 wa_state_local_office WA:BLACN 033 Neal Black BLACN 033 58 CITY COUNCIL MEMBER 13 wa_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 13, "cf_office": "CITY COUNCIL MEMBER", "scope_state": "WA", "cf_filer_raw": "Neal D.L. Black (Neal Black)", "matched_official": "Neal Black", "parsed_candidate": "Neal Black"}  
13 13 p_0de0d73d99d8e510 nc_state_local_office NC:MEC-68T672-C-001 ED DRIGGS MEC-68T672-C-001 145 COUM 3 nc_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 3, "cf_office": "COUM", "scope_state": "NC", "cf_filer_raw": "ED DRIGGS FOR CITY COUNCIL", "matched_official": "Ed Driggs", "parsed_candidate": "ED DRIGGS"}  
14 14 p_0ede5fa50d0de71e wa_pdc HINEJ 417 John Hines HINEJ 417 14 CITY COUNCIL MEMBER 32 wa_pdc_filerid_jurisdiction_name 0.9 {"jurisdiction": "CITY OF TACOMA", "pdc_filer_id": "HINEJ 417"} 2026-08-03T11:27:22Z
15 15 p_11de8535420406a1 wa_state_local_office WA:ZOLLL--382 Lori Zoller ZOLLL--382 4351 COUNTY COMMISSIONER 80 wa_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 80, "cf_office": "COUNTY COMMISSIONER", "scope_state": "WA", "cf_filer_raw": "LORI ZOLLER (Lori Zoller)", "matched_official": "Lori Zoller", "parsed_candidate": "Lori Zoller"}  
16 16 p_125f3f1f88b0c953 nc_state_local_office NC:CHA-RQY526-C-001 KATIE KENLAN CHA-RQY526-C-001 4122 CYCM 13 nc_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 13, "cf_office": "CYCM", "scope_state": "NC", "cf_filer_raw": "KATIE KENLAN FOR COMMISSIONER", "matched_official": "Katie Kenlan", "parsed_candidate": "KATIE KENLAN"}  
17 17 p_127a82826f2c6f91 nc_state_local_office NC:001-2MRDWX-C-001 RENEE MILLER 001-2MRDWX-C-001 3408 COUM 6 nc_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 6, "cf_office": "COUM", "scope_state": "NC", "cf_filer_raw": "COMMITTEE TO ELECT RENEE MILLER", "matched_official": "Renee Miller", "parsed_candidate": "RENEE MILLER"}  
18 18 p_13b03ef68fa228b5 wa_pdc NUTTJ 981 NUTTING JEREMY D (Jeremy Nutting) NUTTJ 981 1876 CITY COUNCIL MEMBER 12 wa_pdc_filerid_jurisdiction_name 0.9 {"jurisdiction": "CITY OF DES MOINES", "pdc_filer_id": "NUTTJ 981"} 2026-08-03T11:27:22Z
19 19 p_13ca99f2d60c0682 netfile_ca 94|Matt Rahn for Temecula City Council 2026 Matt Rahn for Temecula City Council 2026   94 Temecula City Council 8 netfile_name_muni_office 0.85 {"parsed_office": "Temecula City Council", "agency_muni_id": 94, "parsed_candidate": "Matt Rahn"} 2026-08-03T11:27:22Z
20 20 p_15cb6e90d257cc12 wa_state_local_office WA:JERDS--456 Stephanie Jerdon JERDS--456 60433 SCHOOL DIRECTOR 13 wa_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 13, "cf_office": "SCHOOL DIRECTOR", "scope_state": "WA", "cf_filer_raw": "Stephanie Jerdon", "matched_official": "Stephanie Jerdon", "parsed_candidate": "Stephanie Jerdon"}  
21 21 p_160e8f8a9a79ec14 netfile_ca 23|Michael Blower for City Council 2016 Michael Blower for City Council 2016   23 City Council 468 netfile_name_muni_office 0.85 {"parsed_office": "City Council", "agency_muni_id": 23, "parsed_candidate": "Michael Blower"} 2026-08-03T11:27:22Z
22 22 p_160e8f8a9a79ec14 netfile_ca 23|Michael Blower for Stockton City Council - District 3 2022 Michael Blower for Stockton City Council - District 3 2022   23 Stockton City Council - District 3 298 netfile_name_muni_office 0.85 {"parsed_office": "Stockton City Council - District 3", "agency_muni_id": 23, "parsed_candidate": "Michael Blower"} 2026-08-03T11:27:22Z
23 23 p_18a25b6fa7e7ed3a nc_state_local_office NC:162-39M7IQ-C-001 DERRICK THOMPSON 162-39M7IQ-C-001 209 COUM 2 nc_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 2, "cf_office": "COUM", "scope_state": "NC", "cf_filer_raw": "COMMITTEE TO ELECT DERRICK THOMPSON", "matched_official": "Derrick Thompson", "parsed_candidate": "DERRICK THOMPSON"}  
24 24 p_19b748ff0087d783 wa_pdc PAYND--502 DONTAE DERRELL PAYNE (Dontae Derrell Payne) PAYND--502 173 MAYOR 26 wa_pdc_filerid_jurisdiction_name 0.9 {"jurisdiction": "CITY OF OLYMPIA", "pdc_filer_id": "PAYND--502"} 2026-08-03T11:27:22Z
25 25 p_1ac0ed2ff4358496 wa_state_local_office WA:TURNT--987 Tracy Taylor-Turner TURNT--987 58 CITY COUNCIL MEMBER 18 wa_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 18, "cf_office": "CITY COUNCIL MEMBER", "scope_state": "WA", "cf_filer_raw": "Tracy Taylor-Turner", "matched_official": "Tracy Turner", "parsed_candidate": "Tracy Taylor-Turner"}  
26 26 p_1d56247a8d651c90 wa_state_local_office WA:GALLK--227 Kaylee Galloway GALLK--227 4360 COUNTY COUNCIL MEMBER 9 wa_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 9, "cf_office": "COUNTY COUNCIL MEMBER", "scope_state": "WA", "cf_filer_raw": "Kaylee Galloway", "matched_official": "Kaylee Galloway", "parsed_candidate": "Kaylee Galloway"}  
27 27 p_1fc84ae39b149e2e netfile_ca 23|Kimberly Warmsley For City Council 2024 Kimberly Warmsley For City Council 2024   23 City Council 533 netfile_name_muni_office 0.85 {"parsed_office": "City Council", "agency_muni_id": 23, "parsed_candidate": "Kimberly Warmsley"} 2026-08-03T11:27:22Z
28 28 p_213a5492047c7e05 netfile_ca 243|Joseph Ungoco for City Council 2017 Joseph Ungoco for City Council 2017   243 City Council 139 netfile_name_muni_office 0.85 {"parsed_office": "City Council", "agency_muni_id": 243, "parsed_candidate": "Joseph Ungoco"} 2026-08-03T11:27:22Z
29 29 p_2177c376a3e753d2 netfile_ca 25|Pat Showalter for Council 2014 Pat Showalter for Council 2014   25 Council 1 netfile_name_muni_office 0.85 {"parsed_office": "Council", "agency_muni_id": 25, "parsed_candidate": "Pat Showalter"} 2026-08-03T11:27:22Z
30 30 p_2177c376a3e753d2 netfile_ca 25|Pat Showalter for Council 2018 Pat Showalter for Council 2018   25 Council 1877 netfile_name_muni_office 0.85 {"parsed_office": "Council", "agency_muni_id": 25, "parsed_candidate": "Pat Showalter"} 2026-08-03T11:27:22Z
31 31 p_2177c376a3e753d2 netfile_ca 25|Pat Showalter for Council 2020 Pat Showalter for Council 2020   25 Council 288 netfile_name_muni_office 0.85 {"parsed_office": "Council", "agency_muni_id": 25, "parsed_candidate": "Pat Showalter"} 2026-08-03T11:27:22Z
32 32 p_2177c376a3e753d2 netfile_ca 25|Pat Showalter for Council 2024 Pat Showalter for Council 2024   25 Council 173 netfile_name_muni_office 0.85 {"parsed_office": "Council", "agency_muni_id": 25, "parsed_candidate": "Pat Showalter"} 2026-08-03T11:27:22Z
33 33 p_218f95a0904393c6 netfile_ca 229|Jean Josey for Dublin City Council 2018 Jean Josey for Dublin City Council 2018   229 Dublin City Council 1 netfile_name_muni_office 0.85 {"parsed_office": "Dublin City Council", "agency_muni_id": 229, "parsed_candidate": "Jean Josey"} 2026-08-03T11:27:22Z
34 34 p_218f95a0904393c6 netfile_ca 229|Jean Josey for Dublin City Council 2022 Jean Josey for Dublin City Council 2022   229 Dublin City Council 112 netfile_name_muni_office 0.85 {"parsed_office": "Dublin City Council", "agency_muni_id": 229, "parsed_candidate": "Jean Josey"} 2026-08-03T11:27:22Z
35 35 p_218f95a0904393c6 netfile_ca 229|Jean Josey for Dublin Mayor 2024 Jean Josey for Dublin Mayor 2024   229 Dublin Mayor 205 netfile_name_muni_office 0.85 {"parsed_office": "Dublin Mayor", "agency_muni_id": 229, "parsed_candidate": "Jean Josey"} 2026-08-03T11:27:22Z
36 36 p_2248972823a5da9d wa_state_local_office WA:BARKA--916 Anniece Barker BARKA--916 60433 SCHOOL DIRECTOR 28 wa_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 28, "cf_office": "SCHOOL DIRECTOR", "scope_state": "WA", "cf_filer_raw": "Anniece W Barker (Anniece Barker)", "matched_official": "Anniece Barker", "parsed_candidate": "Anniece Barker"}  
37 37 p_2261a5bb9cfabf1b wa_pdc WOODV 409 Victoria R Woodards (VICTORIA WOODARDS) WOODV 409 14 MAYOR 47 wa_pdc_filerid_jurisdiction_name 0.9 {"jurisdiction": "CITY OF TACOMA", "pdc_filer_id": "WOODV 409"} 2026-08-03T11:27:22Z
38 38 p_2350e1596ee0af61 wa_state_local_office WA:STREM--244 Mark Stremler STREM--244 4360 COUNTY COUNCIL MEMBER 46 wa_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 46, "cf_office": "COUNTY COUNCIL MEMBER", "scope_state": "WA", "cf_filer_raw": "Mark Stremler", "matched_official": "Mark Stremler", "parsed_candidate": "Mark Stremler"}  
39 39 p_25a4fcf71daa6211 netfile_ca 30|Lori Stone for Murrieta Council 2020 Lori Stone for Murrieta Council 2020   30 Murrieta Council 375 netfile_name_muni_office 0.85 {"parsed_office": "Murrieta Council", "agency_muni_id": 30, "parsed_candidate": "Lori Stone"} 2026-08-03T11:27:22Z
40 40 p_25a4fcf71daa6211 netfile_ca 30|Lori Stone for Murrieta Council 2024 Lori Stone for Murrieta Council 2024   30 Murrieta Council 498 netfile_name_muni_office 0.85 {"parsed_office": "Murrieta Council", "agency_muni_id": 30, "parsed_candidate": "Lori Stone"} 2026-08-03T11:27:22Z
41 41 p_25cca846af228c8a netfile_ca 25|Chris Clark for Council 2012 Chris Clark for Council 2012   25 Council 16 netfile_name_muni_office 0.85 {"parsed_office": "Council", "agency_muni_id": 25, "parsed_candidate": "Chris Clark"} 2026-08-03T11:27:22Z
42 42 p_25cca846af228c8a netfile_ca 25|Chris Clark for Council 2016 Chris Clark for Council 2016   25 Council 15 netfile_name_muni_office 0.85 {"parsed_office": "Council", "agency_muni_id": 25, "parsed_candidate": "Chris Clark"} 2026-08-03T11:27:22Z
43 43 p_25cca846af228c8a netfile_ca 25|Chris Clark for Council 2024 Chris Clark for Council 2024   25 Council 79 netfile_name_muni_office 0.85 {"parsed_office": "Council", "agency_muni_id": 25, "parsed_candidate": "Chris Clark"} 2026-08-03T11:27:22Z
44 44 p_27cc76f0923fbe94 wa_state_local_office WA:NEHRN 292 Nate Nehring NEHRN 292 174 COUNTY COUNCIL MEMBER 6 wa_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 6, "cf_office": "COUNTY COUNCIL MEMBER", "scope_state": "WA", "cf_filer_raw": "Nathan A Nehring (Nate Nehring)", "matched_official": "Nate Nehring", "parsed_candidate": "Nate Nehring"}  
45 45 p_2a666c88b30b2b7a wa_state_local_office WA:SCANJ--243 Jon Scanlon SCANJ--243 4360 COUNTY COUNCIL MEMBER 53 wa_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 53, "cf_office": "COUNTY COUNCIL MEMBER", "scope_state": "WA", "cf_filer_raw": "Jonathan S. Scanlon (Jon Scanlon)", "matched_official": "Jon Scanlon", "parsed_candidate": "Jon Scanlon"}  
46 46 p_2ae9a7960eb4b5db wa_pdc KAURS 031 Satwinder Kaur (SATWINDER KAUR) KAURS 031 3410 CITY COUNCIL MEMBER 1 wa_pdc_filerid_jurisdiction_name 0.9 {"jurisdiction": "CITY OF KENT", "pdc_filer_id": "KAURS 031"} 2026-08-03T11:27:22Z
47 47 p_2cd2abae7a3daee0 netfile_ca 26|Angela Andrews for Hayward City Council 2024 Angela Andrews for Hayward City Council 2024   26 Hayward City Council 600 netfile_name_muni_office 0.85 {"parsed_office": "Hayward City Council", "agency_muni_id": 26, "parsed_candidate": "Angela Andrews"} 2026-08-03T11:27:22Z
48 48 p_2d085df8a81810ee wa_pdc COROB--449 Ben Coronado COROB--449 9788 CITY COUNCIL MEMBER 4 wa_pdc_filerid_jurisdiction_name 0.9 {"jurisdiction": "CITY OF GIG HARBOR", "pdc_filer_id": "COROB--449"} 2026-08-03T11:27:22Z
49 49 p_2e1868ce05a0ba2e nc_state_local_office NC:009-D4969K-C-001 CHERYL STALLINGS 009-D4969K-C-001 3602 COUM 25 nc_state_office_namematch 0.75 {"rule": "state-level CF row whose office is a LOCAL office; namematch.same_person; ambiguous names dropped", "n_txns": 25, "cf_office": "COUM", "scope_state": "NC", "cf_filer_raw": "FRIENDS OF CHERYL STALLINGS", "matched_official": "Cheryl Stallings", "parsed_candidate": "CHERYL STALLINGS"}  
50 50 p_2e448e938ec46e01 netfile_ca 25|Alex Nunez for Mountain View City Council 2020 Alex Nunez for Mountain View City Council 2020   25 Mountain View City Council 350 netfile_name_muni_office 0.85 {"parsed_office": "Mountain View City Council", "agency_muni_id": 25, "parsed_candidate": "Alex Nunez"} 2026-08-03T11:27:22Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "people_cf_bridge" ("person_id", "cf_source", "cf_filer_key", "cf_filer_name", "cf_filer_id", "muni_id", "office", "n_txns", "match_method", "confidence", "evidence", "updated_at");