Campaign Financial Contributions

District of Columbia

@usgov.district_of_columbia_campaign_financial_contributions_023f6

Table List

1 table(17.53 MB)

Table 1

@usgov.district_of_columbia_campaign_financial_contributions_023f6.table_1

17.53 MB
297157 rows
20 columns

committeename COMMITTEENAME	candidatename CANDIDATENAME	electionyear ELECTIONYEAR	contributorname CONTRIBUTORNAME	contributortype CONTRIBUTORTYPE	contributiontype CONTRIBUTIONTYPE	address ADDRESS	fulladdress FULLADDRESS	ward WARD	employer EMPLOYER	employeraddress EMPLOYERADDRESS	amount AMOUNT	dateofreceipt DATEOFRECEIPT	address_id ADDRESS ID	xcoord XCOORD	ycoord YCOORD	latitude LATITUDE	longitude LONGITUDE	gis_last_mod_dttm GIS LAST MOD DTTM	objectid OBJECTID
Running Against Bush DC Slate	Running Against Bush	2004	Tamela Gordon	Individual	Check	2613 39th St. NW #1, Washington, DC 20007	2613 39TH STREET NW	Ward 3	self	2613 39th St, NW #1, Washington, DC 20007	100	Fri Aug 27 2004 04:00:00 GMT+0000 (Coordinated Universal Time)	224281	393299.24	139586.53	38.9241282	-77.0772738	Mon Apr 07 2025 10:49:56 GMT+0000 (Coordinated Universal Time)	76109114
Running Against Bush DC Slate	Running Against Bush	2004	Daniel Blum	Individual	Check	807 Quintana Place NW, Washington, DC 20011	807 QUINTANA PLACE NW	Ward 4			50	Fri Aug 27 2004 04:00:00 GMT+0000 (Coordinated Universal Time)	254252	397843.34	144065.51	38.96449903	-77.02488489	Mon Apr 07 2025 10:49:56 GMT+0000 (Coordinated Universal Time)	76109115
Running Against Bush DC Slate	Running Against Bush	2004	John Nowicki	Individual	InKind	1908 Florida Ave NW #132, Washington, DC 20009	1908 FLORIDA AVENUE NW	Ward 2	Ajilon Consulting	210 W. Pennsylvania Ave, #650, Towson, MD 21204	176	Tue Aug 31 2004 04:00:00 GMT+0000 (Coordinated Universal Time)	241000	396135.84	138574.93	38.91503243	-77.04455617	Mon Apr 07 2025 10:49:56 GMT+0000 (Coordinated Universal Time)	76109116
Hannah Untereiner		2020									65	Mon Nov 02 2020 05:00:00 GMT+0000 (Coordinated Universal Time)						Mon Apr 07 2025 10:49:56 GMT+0000 (Coordinated Universal Time)	76109117
HMO Health PAC	Luc Noiset	2002	CareFirst Blue Cross Blue Shield	Corporation	Check	840 1st Street, N.E,, Washington, DC 20065	840 1ST STREET NE	Ward 6			2000	Mon Oct 27 2014 04:00:00 GMT+0000 (Coordinated Universal Time)	295924	399405.93	137030.44	38.90112709	-77.00684866	Mon Apr 07 2025 10:49:56 GMT+0000 (Coordinated Universal Time)	76109118
Ross 2014	Pete Ross	2014	Pete Ross	Candidate	Check	1712 Surrey Lane, NW, Washington, DC 20007	1712 SURREY LANE NW	Ward 3			300	Mon Aug 11 2014 04:00:00 GMT+0000 (Coordinated Universal Time)	271100	392777.38	138171.71	38.91137891	-77.08327705	Mon Apr 07 2025 10:49:56 GMT+0000 (Coordinated Universal Time)	76109119
Kent C. Boese		2018										Mon Nov 05 2018 05:00:00 GMT+0000 (Coordinated Universal Time)						Mon Apr 07 2025 10:49:56 GMT+0000 (Coordinated Universal Time)	76109120
Dan Orlaskey		2018										Mon Nov 05 2018 05:00:00 GMT+0000 (Coordinated Universal Time)						Mon Apr 07 2025 10:49:56 GMT+0000 (Coordinated Universal Time)	76601233
Brazil Constituent Fund	Harold Brazil	2002	American Insurance Association	Corporation	Other	1130 Connecticut Avenue N.W., Washington, DC 20036	1130 CONNECTICUT AVENUE NW	Ward 2			400	Thu Apr 17 2003 04:00:00 GMT+0000 (Coordinated Universal Time)	241787	396432.54	137421.29	38.9046413	-77.04112904	Mon Apr 07 2025 10:49:56 GMT+0000 (Coordinated Universal Time)	76601234
Carol Schwartz Council At Large - CSP	Carol Schwartz	2002	SunTrust Capitol Markets	Corporation		303 Peachtree Street, Atlanta, GA 30308	300 - 399 BLOCK OF 8TH STREET NE	Ward 6			44	Wed Nov 30 2005 05:00:00 GMT+0000 (Coordinated Universal Time)	810628	400437	136259.32	38.8941806556	-76.9949625907	Mon Apr 07 2025 10:49:56 GMT+0000 (Coordinated Universal Time)	76601235


CREATE TABLE table_1 (
  "committeename" VARCHAR,
  "candidatename" VARCHAR,
  "electionyear" DOUBLE,
  "contributorname" VARCHAR,
  "contributortype" VARCHAR,
  "contributiontype" VARCHAR,
  "address" VARCHAR,
  "fulladdress" VARCHAR,
  "ward" VARCHAR,
  "employer" VARCHAR,
  "employeraddress" VARCHAR,
  "amount" DOUBLE,
  "dateofreceipt" TIMESTAMP,
  "address_id" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "gis_last_mod_dttm" TIMESTAMP,
  "objectid" BIGINT
);