OurCampaigns is a comprehensive political data resource whose mission is to collect and make available information about all official elections, historical, current and ongoing.
Our primary focus is on the United States, but we also intend to collect all international election data as well.
This data includes not only the election results themselves, but also information and photos on the candidates, polls, advertisements, endorsements, finance reports, predictions, the most important news items,
district maps and data and mapping of what detailed data is available.
OurCampaigns has been a work in progress since 2002. We are a collaboration with our trusted users who have access to a large variety of tools to help enter and maintain the data.
We always need more help with our enormous task, so if you want to contribute please sign up for an account and after a short time of contributing you will get access to the systems. We appreciate it very much.
ne ''>DELETE FROM FAQ WHERE FAQID=;FINISHFAQ Deleted.
|
| Site Data Statistics |
|
|
SELECT count(*)/ TPg FROM ;OUTPUT NIL
|
SELECT 'Members' Lbl,'User' Tbl,count(*) Entries,1000 DoDL FROM User;OUTPUT
SELECT 'Containers' Lbl,'Container' Tbl,count(*) Entries,10000 DoDL FROM Container;OUTPUT
SELECT 'Races' Lbl,'Race' Tbl,count(*) Entries,50000 DoDL FROM Race;OUTPUT
SELECT 'Race Members' Lbl,'RaceMember' Tbl,count(*) Entries,100000 DoDL FROM RaceMember;OUTPUT
SELECT 'Candidates' Lbl,'Candidate' Tbl,count(*) Entries,20000 DoDL FROM Candidate;OUTPUT
SELECT 'Polls' Lbl,'Poll' Tbl,count(*) Entries,3000 DoDL FROM Poll;OUTPUT
SELECT 'Poll Results' Lbl,'PollResult' Tbl,count(*) Entries,10000 DoDL FROM PollResult;OUTPUT
SELECT 'Polling Firms' Lbl,'PollingFirm' Tbl,count(*) Entries,1000 DoDL FROM PollingFirm;OUTPUT
SELECT 'Ad Videos' Lbl,'AdVideo' Tbl,count(*) Entries,0 DoDL FROM AdVideo;OUTPUT
SELECT 'Endorsements' Lbl,'Endorsement' Tbl,count(*) Entries,5000 DoDL FROM Endorsement;OUTPUT
SELECT 'Finance Reports' Lbl,'FinanceReport' Tbl,count(*) Entries,1000 DoDL FROM FinanceReport;OUTPUT
SELECT 'Maps' Lbl,'MapImage' Tbl,count(*) Entries,0 DoDL FROM MapImage;OUTPUT
SELECT 'Map Locations' Lbl,'MapLocation' Tbl,count(*) Entries,0 DoDL FROM MapLocation;OUTPUT
SELECT 'Precincts' Lbl,'VotingDistrict' Tbl,count(*) Entries,0 DoDL FROM VotingDistrict;OUTPUT
SELECT 'Issues' Lbl,'Issue' Tbl,count(*) Entries,1000 DoDL FROM Issue;OUTPUT
SELECT 'Parties' Lbl,'Party' Tbl,count(*) Entries,1000 DoDL FROM Party;OUTPUT
SELECT 'News Items' Lbl,'News' Tbl,count(*) Entries,5000 DoDL FROM News;OUTPUT
SELECT 'Books' Lbl,'Book' Tbl,count(*) Entries,1000 DoDL FROM Book;OUTPUT
SELECT 'Links' Lbl,'InfoLink' Tbl,count(*) Entries,1000 DoDL FROM InfoLink;OUTPUT
SELECT 'Leaning Predictions' Lbl,'Leaning' Tbl,count(*) Entries,10000 DoDL FROM Leaning;OUTPUT
SELECT '% Predictions' Lbl,'Prediction' Tbl,count(*) Entries,10000 DoDL FROM Prediction;OUTPUT
SELECT 'Site Polls' Lbl,count(*) Entries,0 DoDL FROM UserPoll;OUTPUT
SELECT count(*) NewMsg FROM Discussion;OUTPUT NILSELECT 'Messages' Lbl,( + count(*)) Entries,0 DoDL FROM DiscussionArchive;OUTPUT
| Data Entry To-Do |
,Safe> , :
|
|
|
SELECT UserID SgUserID,Nym SgNym,DataEntryToDoID,Title,FirstBy,FirstEnter FROM DataEntryToDo,User WHERE CompleteDate='0000-00-00 00:00:00' AND UserID=FirstBy ORDER BY FirstEnter DESC;OUTPUT
|