Course objectives1) Obtain a thorough grounding in journalistic research methods. 2) Acquire skills, such as computer-assisted or data-journalism reporting techniques, needed to make sense of the information gathered. 3) Develop the ability to shape the information into accurate and compelling stories. Course outline (TOP)Special needs / Accommodation (TOP) You may need special arrangements to meet your academic obligations during the term. For an accommodation request the processes are as follows: Pregnancy obligation: write to us with any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details visit the Equity Services website: http://www2.carleton.ca/equity/ Religious obligation: write to us with any requests for academic accommodation during the first two weeks of class, or as soon as possible after the need for accommodation is known to exist. For more details visit the Equity Services website: http://www2.carleton.ca/equity/ Academic Accommodations for Students with Disabilities: The Paul Menton Centre for Students with Disabilities (PMC) provides services to students with Learning Disabilities (LD), psychiatric/mental health disabilities, Attention Deficit Hyperactivity Disorder (ADHD), Autism Spectrum Disorders (ASD), chronic medical conditions, and impairments in mobility, hearing, and vision. If you have a disability requiring academic accommodations in this course, please contact PMC at 613-520-6608 or pmc@carleton.ca for a formal evaluation. If you are already registered with the PMC, contact your PMC coordinator to send us your Letter of Accommodation at the beginning of the term, and no later than two weeks before the first in-class scheduled test or exam requiring accommodation (if applicable). After requesting accommodation from PMC, meet with one of us to ensure accommodation arrangements are made. Please consult the PMC website for the deadline to request accommodations for the formally-scheduled exam (if applicable) at http://www2.carleton.ca/pmc/new-and-current-students/dates-and-deadlines/ You can visit the Equity Services website to view the policies and to obtain more detailed information on academic accommodation at http://www2.carleton.ca/equity/ School ethics policy: http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/EthicsPolicy.pdf School publishing policy: http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/PublishingPolicy.pdf School electronic media usage policy: http://www1.carleton.ca/journalism/ccms/wp-content/ccms-files/media-usage-policy-2010.pdf A shopping list of key records(TOP)20 records you can get using the federal Access to Information Act1. RECORD: Ministerial briefing notes. DEPARTMENT: All departments. ASK FOR: All briefing notes prepared specifically to help the new minister become acquainted with his/her new portfolio. HINT: Make this request a week or two after a new cabinet is named. RESULT: Yields wide range of information about a department’s plans/activities. 2. RECORD: Expense claims. DEPARTMENT: All departments/agencies. ASK FOR: Receipts, invoices and guest lists detailing travel and hospitality expenses claimed by a deputy minister or other senior bureaucrat that are more detailed than the ones you’ll find in the information federal institutions are obliged to file on line. HINT: Limit request to no more than one year’s worth of claims.RESULT: Can reveal spending habits and establish dates of key meetings, dealings. Remember former federal heritage minister Bev Oda’s $16-dollar glass of orange juice! 3. RECORD: Correspondence. DEPARTMENT: All departments/agencies. ASK FOR: Correspondence with a minister or agency head on a topic of interest. HINT: Frame request narrowly. For instance, exclude letters from the public if you do not require them. RESULT: Can uncover letters from provincial premiers, lobby groups. 4. RECORD: House cards. DEPARTMENT: All departments. ASK FOR: All cards prepared for the minister in the House of Commons on a specific issue. HINT: Watch headlines, Commons debates for ideas. RESULT: Often contain much more detail, background than revealed in Question Period. 5. RECORD: Material on possible legislation. DEPARTMENT: All departments. ASK FOR: Records concerning possible legislation or other initiatives on a given issue. HINT: Limit request to cover the last year to ensure currency of material. RESULT: Provides insight into initiatives that might be in pipeline, and reasons why the initiatives might (or might not) proceed. 6. RECORD: Meeting minutes. DEPARTMENT: All departments/agencies. ASK FOR: Minutes from the two most recent meetings of a specific committee. HINT: Make calls to find out meeting schedules and whether minutes are kept. RESULT: Can aid in understanding internal policy debates and decisions. 7. RECORD: Audits. DEPARTMENT: All departments, most agencies. ASK FOR: Audits and evaluations completed by or for the department/agency on specific subjects in the last year. HINT: Ask department informally for list of audits conducted in the last year. RESULT: Audits often reveal shortcomings in programs, policies. 8. RECORD: Polls. DEPARTMENT: All departments, but especially Privy Council Office. ASK FOR: Polls conducted for the department on a given subject. HINT: Some (but not all) polls are released informally. RESULT: Can reveal public attitudes towards government policies. 9. RECORD: Contract information. DEPARTMENT: All departments. ASK FOR: A copy of the contract for a specific project. HINT: Public Works and Government Services administers many contracts. RESULT: Reveals details of financial arrangements with private companies. 10. RECORD: Responses to discussion papers. DEPARTMENT: Any department that publishes consultation/discussion paper. ASK FOR:Copies of all submissions in response to the department’s paper. HINT: Put in request just after cut-off date for submissions. Only narrow request if certain submissions are required. RESULT: Reveals views of wide cross-section of groups on pressing issues. 11. RECORD: Contracted studies. DEPARTMENT: Privy Council Office. ASK FOR: Specific studies, research conducted for PCO. HINT: Ask informally for list of studies, which is updated regularly. RESULT: Yields advice prepared for government on unity, security, parliamentary affairs and other key issues. 12. RECORD: 20-year-old cabinet documents. DEPARTMENT: Privy Council Office. ASK FOR: Cabinet records on a specific issue. HINT:Check almanac for noteworthy past events. RESULT: Meeting minutes reveal thinking of ministers on issues. (Cabinet documents routinely become public only after 30 years). 13. RECORD: Prime Minister’s email. DEPARTMENT: Privy Council Office. ASK FOR: E-mail sent to the Prime Minister by visitors to his website. HINT: Limit request to a one-week period. RESULT: Names of correspondents are deleted, but letters yield an interesting mix of feedback, including light-hearted, angry and thoughtful correspondence. 14. RECORD: Criminal intelligence briefs. AGENCY: RCMP. ASK FOR: Criminal intelligence briefs prepared during the last six months. HINT:Make time-frame the last couple of years if you are seeking a brief on a specific subject. RESULT: Briefs cover issues such as aboriginal militancy, drug trade and smuggling. 15. RECORD: Incident reports. AGENCY: RCMP. ASK FOR: Incident report on a specific event. HINT: Broaden request to include other records if incident is a prolonged one, such as a standoff. RESULT: Can help explain police decision-making. 16. RECORD: Lessons learned. DEPARTMENT: National Defence. ASK FOR: “Lessons learned” from major military missions. HINT: Wait a month or two after mission is complete. RESULT: Provides evaluation of peacekeeping tours and other assignments. 17. RECORD: UFO reports. DEPARTMENT: Transport. ASK FOR: Reports of unidentified flying objects filed by the public. HINT: UFO reports are also often filed with Defence and RCMP. RESULT: Names of people who make reports are deleted, but other details can be released. 18. RECORD: Observer reports. DEPARTMENT: Fisheries. ASK FOR: Observer reports prepared for the department. HINTS: Limit request to specific geographic area and time frame. RESULTS: Can provide details about operations of foreign vessels. 19. RECORD: SIRC reports. AGENCY: Security Intelligence Review Committee. ASK FOR: Specific reports prepared by committee on CSIS activities. HINT: Reports are listed in back of committee’s annual report. RESULT: Reports, though heavily edited, provide check on spy agency CSIS. 20. RECORD: CRTC debriefing notes. AGENCY: Canadian Radio-television and Telecommunications Commission. ASK FOR: Debriefing notes prepared in connection with a specific licensing hearing. HINT: Make request shortly after licence decision is made. RESULT: Can provide behind-the-scenes reasoning on why TV, radio licences are granted or denied. Ten ways to improve your searches(TOP)1. Look to the headlines for ideas. 2. Check the relevant federal websites for forms, contacts, info on departmental holdings. 3. Call the access co-ordinator before making your request. 4. Call the co-ordinator after submitting your request. 5. Make similar requests to more than one agency or government. 6. Keep a photocopy or scan of each request and attach all return correspondence. 7. Negotiate with agencies. 8. Be persistent. If necessary, complain. 9. Read the records you receive carefully. 10. Don’t get discouraged. |
Biographies(TOP)
Jim Bronskill is a reporter in the Ottawa bureau of The Canadian Press news agency, specializing in security and intelligence, the RCMP and justice-related issues. He has considerable experience using access-to-information laws to uncover stories. Before joining CP in November 2003, Jim was a reporter with Southam News (which became CanWest News Service). He previously held various positions at CP and has also worked for the Ottawa Citizen, the Owen Sound Sun Times and TVOntario. Jim holds a master’s degree in journalism from Carleton University. He and colleague Sue Bailey were National Newspaper Award finalists for investigative stories on Taser stun guns. In 2002, Jim received two Canadian Association of Journalists awards, including one for best overall investigative report, for a series he co-wrote with David Pugliese of the Citizen about the crackdown by security agencies on public dissent. He and Bailey won the national Justicia Award for a series on how the justice system often fails the mentally ill. Jim was part of a team that collaborated with the CBC/Radio-Canada to earn the 2008 Michener Award for their series on Taser use by the RCMP.
Jim has contributed to a textbook on Canada’s Access to Information Act entitled Brokering Access. And he has co-authored an access-to-information research guide with David McKie called Your Right to Know, copies of which available on-line at Indigo Books or Self-Counsel Press, the publisher.
David McKie is an Ottawa-based, award-winning author and producer who works out of the CBC News Parliamentary bureau. To get an idea of some of the stories he has researched, written and broadcast, please go to the following links: A Matter of Trust, Faint Warning (for which he was nominated for a Michener Award in 2003), Prescribed to Death , Dying for a Job and Out of Synch, Beaten Down: Fear and Violence in Canada’s Nursing Homes and Off-Limits.
For a story in the series,A Matter of Trust, on a botched clinical trial and its effect on two families, David and the late CBC documentary maker, Bob Carty, won the 2003 Science in Society Journalism Award in the radio category. Faint Warning was a finalist for the 2004 Michener award, winner of the 2004 RTNDA award for best investigative report, and winner the Canadian Association of Journalists’ 2004 computer-assisted reporting (CAR) award and the overall CAJ award for best investigative series.
Faint Warning won the Service Journalism category for the 2004 Online News Association. The follow-up series, Prescribed to Death, that ran in 2005 was also a big award winner. The series won the CAJ’s 2006 CAR award, the Open Radio News Award and, for the second year in a row, the overall award. The series also won the 2006 CNA ( Canadian Nurses Association ) & CMA ( Canadian Medical Association ) Media Awards for Excellence in Health Reporting and the American-based IRE (Investigative Reporters and Editors) award in the radio category.
Dying for a Job won the 2007 Excellence in Health Reporting from the Canadian Medical Association and the Canadian Nurses’ Association. For the Taser series, David and Jim Bronskill were part of the large team that earned the 2008 Michener Award.
David edits a magazine for the Canadian Association of Journalists called Media, which you can find at: Media magazine. He was also one of four journalists/journalism instructors who wrote Digging Deeper, a Canadian textbook on investigative research techniques that’s now in its third edition. And has helped write a second textbook, Computer-Assisted Reporting: A Comprehensive Primer, contributed to a textbook on Canada’s Access to Information Act entitled Brokering Access.
And he has co-authored an access-to-information research guide with Jim Bronskill called Your Right to Know, copies of which available on-line at Indigo Books or Self-Counsel Press, the publisher.
ACCESS-TO-INFORMATION(TOP)
CANADA
Access to Information Act
http://laws-lois.justice.gc.ca/eng/acts/A-1/
Interim Directive on the Administration of the Access to Information Act
https://www.tbs-sct.gc.ca/pol/doc-eng.aspx?id=18310
Access To Information: Federal Liberal Campaign Promise
https://www.liberal.ca/realchange/access-to-information/
E-1090 (ACCESS TO INFORMATION)
https://petitions.ourcommons.ca/en/Petition/Details?Petition=e-1090
Privacy Act
http://laws-lois.justice.gc.ca/eng/acts/P-21/
Federal Departments and Agencies
http://canada.ca/en/gov/dept/index.html
Info Source (directory of holdings)
http://www.infosource.gc.ca/emp/emp05-eng.asp
Open Data Portal
List of briefing notes prepared for the federal Minister of finance, the Deputy Minister and the Parliamentary Secretary
http://www.fin.gc.ca/disclose-divulgation/bn-nb/2016-08-eng.asp
Search Summaries of Completed ATI Requests
http://data.gc.ca/eng/search/ati?
Summary of briefing document titles prepared for the Treasury Board President and the Secretary
https://www.canada.ca/en/treasury-board-secretariat/corporate/transparency/summary-briefing-note-titles.html
List of briefing notes prepared for the Minister of Finance, the Deputy Minister and the Parliamentary Secretary
http://www.fin.gc.ca/disclose-divulgation/bn-nb/index-eng.asp
Summary of briefing note titles addressed to the President and the Minister responsible for Shared Services Canada
https://www.canada.ca/en/shared-services/corporate/transparency.html#a2
David McKie’s CAIRs page
Access to Information and Privacy Coordinators
http://www.tbs-sct.gc.ca/atip-aiprp/apps/coords/index-eng.asp
Access to Information request forms
http://www.tbs-sct.gc.ca/tbsf-fsct/350-57_e.asp
Access to Information fillable request form
Specific Exemptions under the Access to Information Act (Treasury Board of Canada Secretariat)
http://www.tbs-sct.gc.ca/pol/doc-eng.aspx?section=text&id=13784
Office of the Information Commissioner
Office of the Privacy Commissioner
PROVINCES AND TERRITORIES
Alberta
http://foip.alberta.ca/pbdirectory/index.cfm
British Columbia
http://www.gov.bc.ca/citz/iao/foi/
http://www.gov.bc.ca/citz/iao/foi/contacts/index.html
http://www.openinfo.gov.bc.ca/ibc/index.page?
Completed Freedom of Information requests at BCFerries
http://www.bcferries.com/about/foi/tracker.html
Access in the Academy: Bringing FOI and ATI to Academic Research (BC Freedom of Information and Privacy Association)
https://www.gifttool.com/donations/Donate?ID=1552&AID=2700:
Manitoba
http://www.gov.mb.ca/chc/fippa/
http://www.gov.mb.ca/chc/fippa/disclosure.html
Manitoba (Access to information requests — weekly listing)
http://www.gov.mb.ca/chc/fippa/disclosure.html
New Brunswick
Main:http://www2.gnb.ca/content/gnb/en/services/services_renderer.200949.html
Law: http://www.gnb.ca/acts/acts/r-10-3.htm
Newfoundland and Labrador
http://www.justice.gov.nl.ca/just/info/index.html
Northwest Territories
http://www.justice.gov.nt.ca/ATIPP/index.shtml
Nova Scotia
Main: http://www.foipop.ns.ca/
List of departments: http://foipop.ns.ca/PB_Contact
Review: http://www.foipop.ns.ca/
The Right to Know Coalition of Nova Scotia
Nunavut
http://www.gov.nu.ca/access-information-and-protection-privacy-atipp
Ontario
Main: http://www.accessandprivacy.gov.on.ca/english/doi/index.html
Forms: http://www.accessandprivacy.gov.on.ca/english/download/index.html
FAQ: http://www.cfipo.gov.on.ca/mbs/dor/dirrec.nsf/webpages/FAQ
Information and Privacy Commissioner decisions and resolutions
Prince Edward Island
http://www.gov.pe.ca/jps/FOIPPfaqs
http://www.gov.pe.ca/forms/pdf/641.pdf
http://www.gov.pe.ca/jps/index.php3?number=1024337&lang=E
Quebec
http://www.cai.gouv.qc.ca/index-en.html
Quebec access-to-information coordinators
http://www.cai.gouv.qc.ca/documents/CAI_liste_resp_acces_eng.pdf
Saskatchewan
http://www.justice.gov.sk.ca/Contacts-by-Institutio
Yukon
CITIES
Calgary
Edmonton
http://www.edmonton.ca/city_government/city_organization/freedom-of-information-and-privacy.aspx
Fredericton
http://www.fredericton.ca/en/citygovernment/rtipp2013.asp
Ottawa
http://ottawa.ca/en/city-hall/your-city-government/access-information-and-privacy
Halifax Regional Municipality
http://www.halifax.ca/AccessPrivacy/index.php
Hamilton
http://www.hamilton.ca/CityDepartments/CorporateServices/Clerks/MFIPPA_adn_PHIPA.htm
Moncton
http://www.moncton.ca/Government/Right_to_Information_and_Protection_of_Privacy_Act__RTIPPA_.htm
Montreal
http://ville.montreal.qc.ca/portal/page?_pageid=5798,39687582&_dad=portal&_schema=PORTAL
Regina
Saskatoon
http://www.saskatoon.ca/DEPARTMENTS/City%20Clerks%20Office/Pages/FreedomofInformation.aspx
Toronto
http://www.toronto.ca/cap/form_foi.htm
Waterloo
http://www.waterloo.ca/en/government/freedomofinformation.asp
Winnipeg
http://winnipeg.ca/clerks/fippa/fippa.stm
Vancouver
http://vancouver.ca/ctyclerk/foi/index.htm
INTERNATIONAL
governmentattic.org (U.S.)
http://www.governmentattic.org/
The FOI Advocate (U.S. news of developments in the area of freedom of information)
http://foiadvocate.blogspot.com/
The Freedom of Information Act ( The U.S. Department of Justice)
FOIS Update (1996)
FOIOnline (FOI requests and previously released records for selected agencies)
Historically Significant FBI Files
National Freedom of Information Coalition: Protecting Your Right to Open Government (U.S.)
The National Archives and Records Administration
Open Government: a journal on freedom of information
http://www.opengovjournal.org/index
Overview of FOIA Countries Worldwide – February 1 2006
http://www.statewatch.org/news/2006/feb/foia-feb-2006.pdf
Reporters Committee for the Freedom of the Press (U.S. FOI requests)
http://www.rcfp.org/foiact/index.html
The Sunshine Government Initiative (a coalition of U.S. media groups that advocates opening up access to government records)
http://www.sunshineingovernment.org/
U.S. FOI requests for electronic data by state
http://www.rcfp.org/elecaccess/
U.S. Coalition of Journalists for Open Government
U.S. Food and Drug Administration: Electronic Reading Room
http://www.fda.gov/foi/electrr.htm
U.K. FOI requests
http://www.whatdotheyknow.com/
http://www.whatdotheyknow.com/list/successful
The World Bank
The World’s First Freedom of Information Act | Right To Information
https://rtieng.wordpress.com/2011/07/29/the-worlds-first-freedom-of-information-act/
FURTHER READING
Access Info
All About Information http://allaboutinformation.ca
Digging deeper: A Canadian reporter’s research guide, 3rd Edition
http://www.oupcanada.com/higher_education/companion/comm_studies/9780199008490.html
Freedominfo.org
Right2Info
Your Right to Know: How to Use the Law to Get Government Secrets
http://www.self-counsel.com/your-right-to-know.html
ACCESS TO INFORMATION_POLICE(Top)
Calgary Police Service
http://www.calgarypolice.ca/privacyPop.html
Canadian Newspaper Association freedom-of-information audit of police forces (CBC story)
http://www.cbc.ca/canada/story/2009/01/09/access-to-information.html?ref=rss
Durham Regional Police Service
Edmonton Police Service
http://www.edmontonpolice.ca/AboutEPS/HowToRequestInformation.aspx
Fredericton Police Force
http://www.fredericton.ca/en/publicsafety/ContactPoliceMain.asp
Halifax Regional Municipality
http://www.halifax.ca/irm/pdf/form1.pdf
Halton Regional Police
http://www.hrps.on.ca/RecordsCourts/FOI/Pages/default.aspx
Hamilton Police Services
http://www.hamiltonpolice.on.ca/HPS/Services/Records/PoliceOccurrenceReports.htm
London Police Service
http://www.police.london.ca/d.aspx?s=/Services/FOI/default.htm
Niagara Regional Police
http://www.nrps.com/foi/default.asp
Peel Regional Police
http://www.peelpolice.on.ca/Police%20Records/Freedom%20Of%20Information%20Requests.aspx
Regina Police Service
http://www.reginapolice.ca/contact.htm
Vancouver Police Department
http://vancouver.ca/police/organization/support-services/information-privacy.html
Vancouver Police Department (Published Freedom of Information requests)
http://vancouver.ca/police/organization/public-affairs/freedom-of-information.html
Waterloo Regional Police Service
http://www.wrps.on.ca/job/access-information-analyst
York Region Police
http://www.police.york.on.ca/foi.aspx
ACCESS TO INFORMATION STORIES IN THE NEWS(TOP)
53 First Nations reserves lack adequate fire protection: audit
http://www.cbc.ca/news/politics/audit-reserves-inadequate-fire-protection-1.4124616
Access to Information Act Reforms Would Still Put Canada Behind Peru: Democracy Centre
http://www.huffingtonpost.ca/2017/06/23/access-to-information-act-reforms-would-still-put-canada-behind_a_22806686/
Access to Information law changes won’t open up PMO, cabinet offices
http://www.cbc.ca/news/politics/access-information-government-secrecy-1.4167681
Access to information in Alberta nearing ‘crisis situation,’ FOIP commissioner says
http://www.cbc.ca/news/canada/edmonton/information-foip-privacy-commissioner-clayton-alberta-notley-1.3864204
Access to Information Act – Revitalizing access to information consultation (The Canadian Association of Research Libraries)
http://www.carl-abrc.ca/wp-content/uploads/docs/ATI_Revitalization_Submission_June2016.pdf
The 2011 National Freedom of Information Audit (The Canadian Newspaper Association and The Canadian Community Newspapers Association)
http://www.newspaperscanada.ca/public-affairs/FOI2011
Access to Information Act Failure: Watchdog Suzanne Legault Finds Big Problems With Delays, Denials (Huffington Post Canada)
http://www.huffingtonpost.ca/2011/06/17/access-to-information-act_n_878865.html
Access to information denied: Interview with Dean Beeby
Alberta releases first ‘Sunshine list’ of government salaries (CBC News)
Another Blow to Access to Information: Supreme Court of Canada Denies Access to Political Documents in Ministers’ Offices (Inforrm’s Blog: The International Forum for Responsible Media Blog)
Braid: Bizarre case reveals NDP death grip on freedom of information
http://calgaryherald.com/news/politics/braid-bizarre-case-reveals-ndp-death-grip-on-freedom-of-information
Budget cuts undermine federal access-to-information system: watchdog (The Canadian Press)
Budget Cover Cost $212,234
https://www.blacklocks.ca/budget-cover-cost-212234/
http://nationalpost.com/opinion/colby-cosh-200000-on-a-budget-cover-thats-exclusively-liberal-tomfoolery
Canada’s access-to-information system has worsened under Trudeau government: report
https://www.theglobeandmail.com/news/politics/canadas-access-to-information-system-has-worsened-under-trudeau-government-report/article36407309/?service=amp
Canada’s Access to Information Act has ‘never been in worse shape,’ CBC’s Dean Beeby says
http://www.cbc.ca/radio/asithappens/as-it-happens-monday-edition-1.4146446/canada-s-access-to-information-act-has-never-been-in-worse-shape-cbc-s-dean-beeby-says-1.4146447
Canada (Information Commissioner) v. Canada (Minister of National Defence): Democratic Governance, Transparency and Accountability or Exective Priviledge?
BC Ferries to alter controversial policy on FOI disclosure
Canada suffering from chronic access-to-information obfuscation
https://www.biv.com/article/2017/10/canada-suffering-chronic-access-information-obfusc/
CBC document dispute continues at Access committee: Kady O’Malley liveblogs the House of Commons Access to Information committee hearings on the CBC (CBC News)
http://www.cbc.ca/news/politics/story/2011/11/01/pol-kady-stub.html
CBC head defends broadcaster on access to info (CBC News)
http://www.cbc.ca/news/canada/ottawa/story/2011/11/24/pol-cbc-ethics-committee-lacroix.html
CBC must hand over files to information watchdog (CBC News)
http://www.cbc.ca/news/canada/story/2011/11/23/pol-cbc-information-commissioner-appeal.html
CBC still refusing to release info (Toronto Sun)
http://www.torontosun.com/2011/08/19/cbc-still-refusing-to-release-info
CBC one in long list of federal agencies to go up against info czar in court (The Canadian Press)
Canada mediocre in access to information rankings (The Toronto Star)
http://www.thestar.com/news/canada/article/1062154–canada-mediocre-in-access-to-information-rankings
Committee calls for sweeping changes to Access to Information Act
http://www.theglobeandmail.com/news/politics/commons-committee-calls-for-sweeping-changes-to-access-to-information-act/article30488132/
Bid to see Champlain Bridge report denied: Gazette to appeal federal body’s ruling (The Gazette)
Canada to probe alleged ‘muzzling’ of government scientists (The Japan Times)
Chilly White North? Canadian government secrecy on the rise (The Christian Science Monitor)
CommitteeWatch: Hey, remember formerly alleged Access to Information interferent Sebastien Togneri? (CBCnews_Inside Politics Blog)
Conflicting answers on whether complete Mercier Bridge reports will be released (The Gazette)
Court rejects CBC appeal in access-to-information feud (The Canadian Press)
CBC’s David McKie on investigative reporting: Your Community Blog
http://www.cbc.ca/news/yourcommunity/2012/04/cbcs-david-mckie-on-investigative-reporting.html
Dermod Travis: How B.C. Liberal outsourcing made government more opaque
http://www.straight.com/news/942036/dermod-travis-how-bc-liberal-outsourcing-made-government-more-opaque
Even Montreal’s executive committee agenda is shielded (The Gazette)
http://www.montrealgazette.com/news/Even+exec+committee+agenda+shielded/5238086/story.html
F” as in ‘forget about it’: Liberals blame Harper for their failing grade on Access to Information audit
http://ipolitics.ca/2017/09/28/liberals-blame-harper-for-their-failing-grade-on-access-to-info-disclosure/
Feds, several provinces get low marks for information transparency (Postmedia News)
http://www.vancouversun.com/Feds+several+provinces+marks+information+transparency/5461784/story.html
Feds appeal judge’s order to open up RCMP security file on Tommy Douglas (The Canadian Press)
Federal Court judge orders government to release pages of docs on Senate scandal
http://www.timescolonist.com/federal-court-judge-orders-government-to-release-pages-of-docs-on-senate-scandal-1.22736342
From the bench, a boost for government secrecy (The Globe and Mail)
Full review of Access to Information law 2 years away, Scott Brison says
http://www.cbc.ca/news/politics/access-information-law-review-brison-1.3514800
http://www.cbc.ca/news/canada/government-records-archives-history-1.4129935
Government institutions don’t respect access to information laws (The Hill Timesonline)
http://www.thehilltimes.ca/page/printpage/-08-22-2011
Government veto would undermine push for openness: Editorial
https://www.thestar.com/opinion/editorials/2016/05/23/government-veto-would-undermine-push-for-openness-editorial.html
Groups demand inquiry after RCMP drops access to info case (The Gazette)
Notable Canadian print news stories based on ATIA requests
How Freedom of Information requests led to a Parliamentary scandal: Read an excerpt from Heather Brooke’s book (Ted Blog)
Information and Privacy Commissioner Cautions Against Using Personal Email and Instant Messaging When Doing Public Business
https://www.ipc.on.ca/english/Resources/News-Releases/News-Releases-Summary/?id=1665
Information Commissioner Suzanne Legault declines to reapply for her job
http://www.cbc.ca/news/politics/information-liberal-suzanne-legault-access-appointments-parliament-courts-brison-wilson-raybould-1.4059338
Info commish slams Foreign Affairs bureaucrats (Toronto Sun)
http://m.torontosun.com/2012/02/19/info-commish-slams-foreign-affairs-bureaucrats
Interim Directive on the Administration of the Access to Information Act
https://www.tbs-sct.gc.ca/pol/doc-eng.aspx?id=18310
Liberals redefine key transparency promise in new bill
https://www.thestar.com/news/canada/2017/06/20/liberals-redefine-key-transparency-promise-in-new-bill.html
Liberals end access to information fees, more reforms coming
Liberal government postpones initial Access to Information reforms
http://globalnews.ca/news/3323656/ottawa-postpone-initial-access-to-information-reforms/
Liberals’ slow movement on Access to Information reform concerns commissioner
http://www.cbc.ca/news/politics/suzanne-legault-access-to-information-timeline-liberals-1.3812208
Liberals won’t commit to meeting platform promises on transparency by next election
https://www.hilltimes.com/2017/03/29/liberals-wont-commit-election-deadline-access-information-reform/101111
Military cops struggle to enforce mental health laws
http://www.cbc.ca/news/politics/military-police-provinces-1.4223219
New access law is needed for a digital age: Editorial-An all-party Commons committee is on the right track with a series of overdue reforms to fix the broken Access to Information Act
https://www.thestar.com/opinion/editorials/2016/06/20/new-access-law-is-needed-for-a-digital-age-editorial.html
New bill would boost information watchdog’s powers, reshape Access to Information Act
https://www.thestar.com/news/canada/2017/06/19/new-bill-would-boost-information-watchdogs-powers-reshape-access-to-information-act.html
Perils of BC’s New Freedom of Info Policy (The Tyee)
http://thetyee.ca/Mediacheck/2011/08/31/New-BC-FOI-Policy/
Many Indigenous families not applying for Canada child benefit: documents
http://www.cbc.ca/news/politics/canada-child-benefit-indigenous-1.4211545
On access to information, Canada is a developing country (The Globe and Mail editorial)
Open CBC’s records, Quebecor owner says (CBC News)
http://www.cbc.ca/news/politics/story/2011/10/20/pol-cbc-access-hearings-parliament.html
Opinion: Federal Access to Information Act reform is overdue
http://montrealgazette.com/opinion/opinion-federal-access-to-information-act-reform-is-overdue
Overhaul of Canada’s Access to Information Act taking too long, critic says
http://www.cbc.ca/news/canada/nova-scotia/access-to-information-act-changes-overhaul-promised-liberals-federal-government-1.4056886
Ottawa to release long-sought St. Anne’s residential school documents
https://www.thestar.com/news/canada/2017/04/07/ottawa-to-release-long-sought-st-annes-residential-school-documents.html
Possible changes to federal Access to Information Act would be two steps forward and one giant step back
http://www.hamiltonnews.com/opinion-story/6705871-possible-changes-to-federal-access-to-information-act-would-be-two-steps-forward-and-one-giant-step/
RCMP admit fabricating backdated response to gun registry access to info request
http://cfjctoday.com/article/551043/rcmp-admit-fabricating-backdated-response-gun-registry-access-info-request
Restaurant inspection reports may go online (CBC News)
http://www.servicenl.gov.nl.ca/inspections/index.html
Rethink secrecy over Tommy Douglas files, Ottawa told (The Canadian Press)
http://www.cbc.ca/news/politics/story/2011/08/11/pol-court-douglas-rcmp-archives.html
Rubin: Open government promise rings hollow
http://ottawacitizen.com/opinion/columnists/rubin-open-government-promise-rings-hollow
Rules are no substitute for cultivating a culture of open government (The Toronto Star)
Scott Brison listen up, Canada’s information commissioner has some advice for you
http://www.cbc.ca/news/politics/suzanne-legault-leadership-atip-1.4039890
Scott Brison explains delay in promised transparency reforms
https://www.thestar.com/news/canada/2017/03/26/scott-brison-explains-delay-in-promised-transparency-reforms.html
Solicitor-client privilege can hinder access to information
http://www.calgarysun.com/2017/05/28/solicitor-client-privilege-can-hinder-access-to-information
The strange cases of travelling cats, chihuahuas, and top-secret goats
http://www.ottawasun.com/2017/08/02/the-strange-cases-of-travelling-cats-chihuahuas-and-top-secret-goats
Sunshine list case goes to court
http://www.thetelegram.com/News/Local/2016-11-14/article-4685743/Sunshine-list-case-goes-to-court/1
Sunshine List to shed light on civil service salaries, names to be released Friday
https://ca.news.yahoo.com/sunshine-list-shed-light-civil-005224926.html
The Gazette’s View: Inspection reports: the stonewalling must stop
Roadblocks:Five ways Ottawa stymies Access to Information requests (The Globe and Mail)
SCC Establishes Scope of Access to Information Act (A legal blog about the law of information)
http://allaboutinformation.ca/2011/05/15/scc-establishes-scope-of-access-to-information-act/
SCOC says no: ministerial agendas off-limits (CBC News)
SECURING THE PUBLIC’S RIGHT TO KNOW (Canadian Journalists for Free Expression)
http://www.cjfe.org/securing_the_public_s_right_to_know
Stephen Harper could relax now, but will he? (The Globe and Mail)
Supreme Court Of Canada Affirms Protections For Privilege In The Face Of Statutory Production Demands
http://www.mondaq.com/canada/x/549322/trials+appeals+compensation/Supreme+Court+Of+Canada+Affirms+Protections+For+Privilege+In+The+Face+Of+Statutory+Production+Demands
Tasha Kheiriddin: Supreme Court: PM entitled to a hidden agenda (National Post)
The push for Open Government – up to a point (CBC News)
The Internet Archive gears up for the Trump era by creating a backup in Canada
http://www.digitaltrends.com/web/internet-archive-backup-donations-canada-donald-trump/
Top court says PM, ministers not subject to info law (CBCNews)
http://www.cbc.ca/news/canada/toronto/story/2011/05/13/supreme-court.html
Truce called in CBC dispute at Commons committee on Access to Information (The Canadian Press)
Transparent Censorship: An In-Depth Look at FOIA in 2015
https://foiamapper.com/annual-foia-reports-2015/
UPEI introduces new access to information policy
http://www.theguardian.pe.ca/news/local/2017/3/20/upei-introduces-new-access-to-information-policy-.html
‘We want to be transparent’: UPEI creates new access to information policy
http://www.cbc.ca/news/canada/prince-edward-island/pei-upei-foipp-access-to-information-1.4033268
Canada: Unproven Complaints Against Employers Could Soon Be Released To The Public
http://www.mondaq.com/canada/x/569834/employee+rights+labour+relations/Unproven+Complaints+Against+Employers+Could+Soon+be+Released+to+the+Public
Watchdog recommends blanket ban on personal emails for government business
http://www.cbc.ca/news/canada/newfoundland-labrador/information-commissioner-personal-emails-government-ban-1.3793832
What makes a good FOIA request? We studied 33,000 to find out.
https://www.cjr.org/analysis/foia-request-how-to-study.php
Why are the Liberals stalling on their promise to reform access to information?http://www.theglobeandmail.com/opinion/editorials/why-are-the-liberals-stalling-on-their-promise-to-reform-access-to-information/article29496212/
BLOGS[Top]
David McKie
http://www.cbc.ca/politics/insidepolitics/syndication/blog-author-david-mckie.xml
Glen McGregor (A few tasteful snaps: Mostly about Canadian data journalism and politics)
http://afewtastefulsnaps.wordpress.com/
Justin Piche (Tracking the Politics of ‘Crime’ and Punishment in Canada)
http://tpcp-canada.blogspot.com/
Fagstein (Maintained by Montreal Gazette copy editor Steve Faguy and self-described “twenty-something geek freelance journalist who lives in Montreal”)
The SPJ International Journalism Committee Blog
http://blogs.spjnetwork.org/ijc/
Now The Details
http://nowthedetails.blogspot.com/
The Senate Tackles B(5) FOIA Reform (the U.S.)
http://nsarchive.wordpress.com/2014/06/24/the-senate-tackles-b5-foia-reform/
BUSINESS ANALYSIS(TOP)
CIBC Economics Research
https://economics.cibccm.com/economicsweb/EconomicsHome#!WORKSPACE_ID=ECO_HOME
RBC Economic Research
http://www.rbc.com/economics/#
TD Economics
https://www.td.com/economics/analysis/economics-index.jsp
BMO Capital Markets
http://economics.bmocapitalmarkets.com/
BMO Financial Group
https://newsroom.bmo.com/index.php?s=2429
Scotia Bank Economics
http://www.gbm.scotiabank.com/ResearchCapabilities/RE_Scotia_Economics.htm
Bank of Canada
http://www.bankofcanada.ca/
Big Five Canadian Banks
http://www.canadabanks.net/default.aspx?article=Big+Five+Canadian+Banks
InvestD
Hoovers
http://www.hoovers.com/#megamenu_0.html
Summary table — Debt to equity ratio by industries (Statistics Canada)
http://www.statcan.gc.ca/pub/61-219-x/2010000/t007-eng.htm
Business Insider
http://www.businessinsider.com/
Financial glossary (Reuters)
http://glossary.reuters.com/index.php?title=Main_Page
Society of American Business Writers and Editors
http://sabew.org/resources/resources/
“Best Business Writing” anthologies compiled by Columbia University
For the most recent edition, click here
Worthwhile Canadian Initiative
http://worthwhile.typepad.com/
BUSINESS REPORTING (TOP)
Donald W. Reynolds National Center for Business Journalism
http://businessjournalism.org/
Beginners’ Guide to Financial Statements (U.S. Securities and Exchange Commission)
http://www.sec.gov/investor/pubs/begfinstmtguide.htm
CANADIAN BUSINESS (TOP)
Catalyst Canada, Inc.
Business Terminology
http://www.powerhomebiz.com/Glossary/glossary-A.htm
Business Dictionary
http://www.businessdictionary.com/
Canada NewsWire
CCN Matthews
http://www.ccnmatthews.com/news/releases/home.jsp
Campbell R. Harvey’s Hypertextual Finance Glossary
http://www.duke.edu/~charvey/Classes/wpg/glossary.htm
Corporations database online
https://www.ic.gc.ca/app/scr/cc/CorporationsCanada/fdrlCrpSrch.html?locale=en_CA
Google Finance
http://finance.google.com/finance
FPinfomart.ca (Canada’s largest provider of news & broadcast media monitoring, financial and corporate data)
MarketWatch
http://www.marketwatch.com/?link=MW_Nav_FP
Nasdaq
SEDAR (Canada)
http://www.sedar.com/search/search_en.htm
Securities commissions
British Columbia Securities Commission
Alberta Securities Commission
http://www.albertasecurities.com/Pages/Default.aspx
Manitoba Securities Commission
http://www.msc.gov.mb.ca/index_en.html
Ontario Securities Commission
http://www.osc.gov.on.ca/en/home.htm
http://www.osc.gov.on.ca/en/Proceedings_before-commission_index.htm
The Autorité des marchés financiers (AMF)
http://www.lautorite.qc.ca/index.en.html
Nova Scotia Securities Commission
The Securities Commission of Newfoundland and Labrador
http://www.gs.gov.nl.ca/cca/fsr/rulemaking/
CANADIAN BUSINESS STATISTICS(TOP)
Bankruptcy (Office of the Superintendent of Bankruptcy Canada)
http://strategis.ic.gc.ca/epic/internet/inbsf-osb.nsf/en/home
http://www.ic.gc.ca/eic/site/bsf-osb.nsf/eng/h_br01011.html
http://www.ic.gc.ca/eic/site/ica-lic.nsf/eng/h_lk00015.html
North American Industry Classification System (NAICS) 2007 (Statistics Canada)
http://www.statcan.gc.ca/subjects-sujets/standard-norme/naics-scian/2007/list-liste-eng.htm
Manpower Employment Outlook Survey
http://www.manpowergroup.com/wps/wcm/connect/manpowergroup-en/home/thought-leadership/meos/
Statistics Canada
http://www.statcan.gc.ca/dai-quo/index-eng.htm
Stockwatch
Tradingview
https://www.tradingview.com/e/MSuvXQsL/
CANADIAN BUSINESS PUBLICATIONS(TOP)
Alberta Oil: The Business of Energy
http://www.albertaoilmagazine.com
Canadian Business
http://www.canadianbusiness.com/
Northern Business Ontario
http://www.northernontariobusiness.com/
Report on Business Magazine (The Globe and Mail)
http://www.theglobeandmail.com/report-on-business/rob-magazine/
CAR AND ATI-related STORIES(TOP)
Access to airline safety reports held up by court action (CBCNews)
Ambrose got earful on definition-of-life vote (CBC News)
http://www.cbc.ca/news/politics/story/2012/12/05/pol-ambrose-woodworth-motion-correspondence.html
Access to Information Act turns 30 amid calls for reform (CBC News)
http://www.cbc.ca/news/politics/story/2012/07/06/pol-access-to-information-30th-anniversary.html
Access to Info Watch: In search of … documents that never were (CBC News)
As fundraising gap grows, Toronto’s wealthy schools leaving poor schools behind (Toronto Star)
Advocates demand inquiry into Ontario’s costly handling of Royal Crest nursing-home failure: Bankruptcy of nursing-home chain cost feds, province, unions tens of millions of dollars (CBC News)|
http://www.cbc.ca/news/canada/story/2009/03/23/ontario-royal-crest-nursing-home.html
ANALYSIS | Health Canada drug approval policy lacks key power (CBC News)
http://www.cbc.ca/news/politics/story/2011/11/30/pol-drug-approvals-health-canada.html
Another OC Transpo crash: Passenger suggests “refresher course” for bus drivers (The Ottawa Citizen)
A Twitter memorial to Canada’s war dead (Glen McGregor’s blog for the Ottawa Citizen)
http://blogs.ottawacitizen.com/2011/11/09/a-twitter-memorial-to-canadas-war-dead/
A CBC News investigation into the increasing use of atypical anti-psychotics among the elderly (CBC News)
http://www.cbc.ca/news/background/seniorsdrugs/off-limits.html
1 in 1,000: How often Tories break ranks (The Ottawa Citizen analysis of House of Commons votes)
Air force warned about backlash over MacKay’s chopper flight (The Toronto Star)
Analysing data is the future for journalists, says Tim Berners-Lee (The Guardian)
http://www.guardian.co.uk/media/2010/nov/22/data-analysis-tim-berners-lee
An ugly campaign against the CBC (The Toronto Star)
http://www.thestar.com/opinion/editorialopinion/article/1086826–an-ugly-campaign-against-the-cbc
Arthritis claims up in bid to speed applications: Advocates say it’s easier to get a doctor to sign a prescription for pot intended to treat sore joints (PostMedia News)
http://www.vancouversun.com/health/Arthritis+claims+speed+applications/5841518/story.html
Border agency policy spells out surveillance rules (CBC News)
Border officer fired for association with convicted criminal (CBCNews)
Documents show ‘harperization’ of government communications (The Canadian Press)
Don’t shoot the messenger
http://www.torontosun.com/2011/11/16/dont-shoot-the-messenger
Drug seizure stories (CBC News)
http://www.cbc.ca/news/politics/story/2013/03/27/pol-busted-at-the-border-drug-seizures-cbsa.html
http://www.cbc.ca/news/politics/story/2013/03/27/pol-border-drug-seizures-china-gbh.html
http://www.cbc.ca/news/canada/british-columbia/story/2013/03/27/bc-cbsa-drugs-ketamine.html
http://www.cbc.ca/news/canada/windsor/story/2013/03/28/wdr-cocaine-seizures-ambassador-bridge.html
http://www.cbc.ca/news/canada/nova-scotia/story/2013/03/27/ns-border-halifax-smuggle.html
http://www.cbc.ca/news/canada/manitoba/story/2013/03/27/mb-khat-manitoba-border-smuggling.html
http://www.radio-canada.ca/grands-titres/
http://www.cbc.ca/news/politics/inside-politics-blog/2013/03/post-15.html
Canada’s arms sales to the Middle East (CBC News)
CBC’s David McKie on investigative reporting
http://www.cbc.ca/news/yourcommunity/2012/04/cbcs-david-mckie-on-investigative-reporting.html
CBC releases some records to House committee (CBC News)
http://www.cbc.ca/news/politics/cbc-releases-some-records-to-house-committee-1.1008924
Citizenship backlog stark contrast to fast-tracked Olympic skater (CBC News)
Would-be Olympic ice dancer fast-tracked to Canadian citizenship (Global News)
Censors must not arbitrarily black out public documents, panel rules (The Globe and Mail)
Complaints against OC Transpo drivers pile up
Clement seeks ‘culture change’ on government transparency (The Globe and Mail)
Code Red (The Hamilton Spectator)
http://www.thespec.com/topic/codered
EcoEnergy home retrofits’ early end left funds unspent: Internal memo says funds budgeted for 2011 renewal of home energy savings plan (CBC News)
http://www.cbc.ca/news/politics/ecoenergy-home-retrofits-early-end-left-funds-unspent-1.2447081
Party discipline: Conservative MPs break ranks more often than opposition (The Globe and Mail)
Contaminated sites across Canada require clean up (CBC News)
Drunk driving tops list of pardoned offences (CBC News)
http://www.cbc.ca/news/politics/story/2011/02/09/parole-board-numbers.html?ref=rss
FATAL FLIGHTS A Perilous Rush to Profit (The Washington Post)
http://www.washingtonpost.com/wp-dyn/content/article/2009/08/20/AR2009082004500.html
Federal agency ACOA writes off millions in bad loans (CBC News)
http://www.cbc.ca/news/politics/story/2012/10/12/pol-mckie-power-politics-acoa-loan-defaults.html
$1.4B tax scams nail donors:Taxman going after 106,000 who submitted inflated charity claims (The Toronto Star)
http://www.thestar.com/Investigation/article/261820
Absent Liberals under fire for giving Tories de facto majority (The Ottawa Citizen)
http://www.canada.com/ottawacitizen/story.html?id=0cf2b9a0-663c-4a30-8a8e-ef30cec3e7ed&k=37011&p=1
Arming the world (CBC National Radio News)
http://www.cbc.ca/news/background/arming-the-world/
Beaten Down: Fear and violence in Canada’s nursing homes (CBC National Radio News)
http://www.cbc.ca/news/background/nursing-homes/
Behind the kitchen door (The Edmonton Journal)
Beauty and the Breast: The Controversy Continues (CBC News)
Click here to download the documentary
Bird strikes increasing at Canadian airports, data shows (CBC News)
http://www.cbc.ca/canada/story/2009/05/13/bird-strikes-airports.html?ref=rss
Bruce Carson not alone in bankruptcy
Buying Influence? Which lobbyists gave money to councillors durring the last election? (Toronto Media Co-op)
http://toronto.mediacoop.ca/story/buying-influence/4843
Canada’s air marshals cost $40 million a year, documents show
http://www.canada.com/business/Canada+marshals+cost+million+year+documents+show/5254081/story.html
Canada OK’s most Sri Lankan refugee claims (CBC News)
http://www.cbc.ca/news/politics/story/2010/09/27/f-migrant-refugee-numbers.html?ref=rss
Canadian military grapples with drug convictions (CBC News)
http://www.cbc.ca/news/politics/story/2010/09/17/f-military-conviction-drug.html
Canadian Newspaper Association freedom-of-information audit of police forces (CBC story)
http://www.cbc.ca/canada/story/2009/01/09/access-to-information.html?ref=rss
Canadian arms sales 2007-09 top $1.4B
http://www.cbc.ca/news/canada/story/2011/03/11/pol-arms-sales.html
Care and attention: Daycares lost track of children 230 times over five years (The Vancouver Sun)
http://www.canada.com/vancouversun/features/care/index.html
CBSA urged to act on marriage fraud complaints: Immigration minister wants border agents to build credible cases (CBC News)
http://www.cbc.ca/news/politics/story/2011/10/29/pol-marriage-fraud.html
Close call for Labrador-bound flight (CBC News Newfoundland)
Collision Course ( The Toronto Star, Hamilton Spectator and The Record)
http://blogs.ukings.ca/carincanada/2006/06/14/collision-course/
Dangling the Dollars ( The Ottawa Citizen and the Halifax Chronicle-Herald)
Database: G8/G20 spending numbers (CBC News)
Database: Accessing MPs’ expenses
http://www.cbc.ca/news/politics/story/2010/10/29/f-database-mp-expenses.html
Deadly Mistkes: Critical Errors by City’s Network Found in 40 Fatalities; Confidential Files Show Wide Pattern of Official Neglect (The Washington Post)
http://www.pulitzer.org/citation/2002,Investigative+Reporting
Dirty little secrets: Abuse in daycares (The Toronto Star)
http://www.thestar.com/News/article/218357
Dishing the Dirt (Winnipeg Free Press)
http://www.winnipegfreepress.com/breakingnews/Dishing-the-dirt-49338292.html
Driving the 401 a risky business (The Toronto Star)
http://www.thestar.com/article/236480
Dying for Job (CBC National Radio New)
http://www.cbc.ca/news/background/workplace-safety/dyingforajob.html
http://www.cbc.ca/news/background/workplace-safety/media.html
Explore the Data
Europe’s Hidden Billions – tracking EU structural funds (The Financial Times)
Facts & Figures (The Chronicle of Higher Education)
http://chronicle.com/section/Facts-Figures/58/
Faint Warning ( CBC National Radio News)
Federal workers lead pack in rising absenteeism (The Ottawa Citizen)
Please read the story by clicking here.
Federal cuts threaten program hiring medically discharged vets (CBC News)
http://www.cbc.ca/thehouse/2012/08/04/program-to-help-veterans-find-work-delivering-mixed-results/
Feds open up access to government data (CBC News)
http://www.cbc.ca/news/politics/story/2011/11/16/pol-clement-open-government.html
Fewer prisoners escaping federal custody (CBC News)
http://www.cbc.ca/news/canada/thunder-bay/story/2012/10/30/pol-prison-escapes.html
Fixing D.C.’s Schools (A Washington Post investigation)
http://www.washingtonpost.com/wp-srv/metro/interactives/dcschools/
Flaherty looked to Liberals for lessons on spending cuts (CBC News)
http://www.cbc.ca/news/politics/story/2011/06/03/pol-budget-cuts.html
Florida’s Stand Your Ground Law (Tampa Bay Times)
http://tampabay.com/stand-your-ground-law/
Fluctuations in refugee rulings trouble critics (CBC News investigation)
http://www.cbc.ca/news/politics/story/2009/12/17/f-refugee-claims.html
Forces introduce new fitness test requirement for troops being deployed abroad
http://www.cbc.ca/news/politics/troops-fitness-deployed-test-1.4402024
Elusive access pushing patients to B.C (Calgary Herald)
http://www.calgaryherald.com/health/Elusive+access+pushing+patients/5841217/story.html
Government’s online information access plan falls short (CBC News)
http://www.cbc.ca/news/politics/story/2012/01/11/pol-mckie-atip-online-summaries-opengov.html
Government warned before loss of student loan, CPP data (CBC News)
http://www.cbc.ca/news/politics/story/2013/06/10/pol-mckie-pnp-hrsdc-data-security-breaches.html
‘Guantanamo North’: Inside Secretive U.S. Prisons (NPR)
http://www.npr.org/2011/03/03/134168714/guantanamo-north-inside-u-s-secretive-prisons
Harvesting Cash (A Washington Post investigation into farm subsidies)
http://www.washingtonpost.com/wp-srv/nation/interactives/farmaid/
Health Canada planned to target binge, pregnant smokers (CBC News)
http://www.cbc.ca/canada/story/2010/12/08/tobacco-warnings-health-canada.html
Hosed at the Pumps (The Ottawa Citizen)
http://www.canada.com/ottawacitizen/features/hosedatthepumps/index.html
Immigration programs still poorly tracked: Volpe
http://www.cbc.ca/news/politics/story/2011/01/28/mckie-cic-volpe-012911.html
http://www.ottawacitizen.com/health/Increase+STDs+region+alarming+officials/3618141/story.html
Industry Canada queried Bernier census claims
http://www.cbc.ca/news/politics/story/2010/10/04/census-bernier-complaints-documents.html
Information czar gives Canada Post, CBC low marks (CBC News)
http://www.cbc.ca/news/arts/story/2011/03/10/pol-info-czar-post-cbc.html
Inmate programs fall short of capital spending (CBC News)
http://www.cbc.ca/news/politics/story/2011/01/13/inmate-spending-mckie.html?ref=rss
IMPACT (The Record series on road safety)
http://news.therecord.com/specialsections/section/impact
Inspectors averaged 2 hours a day inside listeria-infected plant (The CBC and Toronto Star)
http://www.cbc.ca/canada/story/2009/06/10/listeria-inspectors-maple-leaf.html?ref=rss
Female appointments dip under Tories (CBC News)
http://www.cbc.ca/canada/story/2011/01/07/mckie-gender-equity.html
Firms with worker deaths to lose rebates: Star investigation prompts WSIB change (The Toronto Star)
http://www.thestar.com/News/Ontario/article/504076
Food for thought (The Ottawa Citizen)
Food agency database shows rise in serious product recalls (CBC News)
http://www.cbc.ca/news/politics/story/2011/10/07/pol-cfia-food-product-recalls.html
Forced Out (A Washington Post Investigation Into the Casualties of the District’s Real Estate Boom)
http://www.washingtonpost.com/wp-srv/metro/forcedout/index.htm
Gas-pedal problems plagued several carmakers (CBC News)
http://www.cbc.ca/news/gas-pedal-problems-plagued-several-carmakers-1.941619
GIVE AND TAKE: Charitable empire has high costs
http://www.thestar.com/News/Ontario/article/273350
Gun seizures up but fears of porous border remain (CBC News)
http://www.cbc.ca/news/politics/story/2013/05/01/pol-cbsa-weapons-seized-border-guns.html
Lebanon crisis sparked consular staff concerns (CBC News)
http://www.cbc.ca/news/politics/story/2011/02/05/lebanon-evacuation-report.html?ref=rss
Listeriosis victims, families still waiting for compensation (CBC News)
http://www.cbc.ca/news/politics/story/2011/10/08/pol-listeriosis-claim-payments.html
Lobbyists mount full-court press (The Ottawa Citizen)
http://www.ottawacitizen.com/news/Lobbyists+mount+full+court+press/3792127/story.html
Looking for art? You can get a real steal at government buildings (The Canadian Press)
MacKay helicopter airlift ‘under guise’ of training (CBC News)
http://www.cbc.ca/news/politics/story/2011/12/01/pol-mackay-helicopter-fishing-flight.html
MacKay took taxpayer-funded helicopter after officials advised against media event (Postmedia News)
Marriages of convenience problems persist (CBC News)
http://www.cbc.ca/news/politics/story/2010/11/07/david-mckie-marriages-of-convenience.html
http://www.cbc.ca/news/politics/story/2011/10/29/pol-marriage-fraud.html
Medical marijuana blurb (PostMedia News)
http://www.canada.com/Medical+marijuana+blurb/5841886/story.html
Medical marijuana requests spike, with severe arthritis most common claim (Edmonton Journal.com)
Memo warned Toews of risks in dropping gun show rules: Elimination of long-gun registry raises concern over gun show sales (CBC News)
http://www.cbc.ca/news/politics/story/2012/11/13/pol-gun-show-briefing-notes-power-politics.html
More people failing revamped citizenship tests (CBC News)
http://www.cbc.ca/news/politics/story/2013/06/14/pol-citizenship-immigration-test-failure-rate.html
Government signals crackdown on marriage fraud
http://www.cbc.ca/news/politics/story/2011/03/29/pol-marriage-fraud.html
Medical marijuana law changes under microscope (CBC News)
http://www.cbc.ca/news/politics/story/2011/09/28/pol-mckie-medical-marijuana-talks.html
More CAR-related stories ( CARinCanada)
http://blogs.ukings.ca/carincanada/category/stories-done-with-car/
More home sellers taking a loss (The Baltimore Sun)
http://www.baltimoresun.com/business/bal-te.bz.loss11oct11,0,3496598,full.story
More than $1M spent on VIP flights for Natynczyk since 2008 (CTV News)
http://www.ctv.ca/CTVNews/Canada/20110915/million-spent-on-vip-flights-for-natynczyk-since-110915/
Most medical marijuana users middle-aged men (The Ottawa Citizen)
http://www.canada.com/health/Most+medical+marijuana+users+middle+aged/5837757/story.html
Muslim panelists ‘not available,’ unredacted document says (CBC News)
Natural Resources Minister Joe Oliver said he didn’t ‘know very much’ about energy projects, emails reveal (Post Media)
Navigation Protection Act: Government braces for court battles over waterways (CBC News)
News stories produced by ATI Act requests, 2006-2010
http://www3.telus.net/index100/atiastories1
No Running Water (The Winnipeg Free Press)
http://www.winnipegfreepress.com/no-running-water/
Nova Scotia government gave $2.3 million in merit pay to civil servants (The Chronicle Herald)
http://thechronicleherald.ca/Front/9021696.html
50 Alberta news stories made possible by FOIP Act requests
http://www3.telus.net/index100/albertafoistories
OC Transpo’s waiting game (It’s not your imagination. According to a Citizen study, fewer than half of OC Transpo buses run on time. Glen McGregor crunches the numbers.)
http://www.ottawacitizen.com/Transpo+waiting+game/4190821/story.html
PDF version of Glen’s entire OC Transpo series, including the methodology
Oda’s staff silent on travel expense changes (CBC News)
http://www.cbc.ca/news/politics/story/2012/05/30/pol-oda-expenses.html
Ontario public servants’ $100,00 Club growing; 24% Rise In Year (National Post)
Ontario runway problems cause rise in plane accidents (CBC News)
http://www.cbc.ca/news/canada/ottawa/story/2011/09/07/ottawa-airport-landing-problems.html
OpenGov Watch: 48 ATI-governed entities down, 100+ to go! (CBC News)
Ottawa high schools’ police presence shows results (CBC News)
http://www.cbc.ca/news/canada/ottawa/ottawa-high-schools-police-presence-shows-results-1.2619602
Out of Synch (CBC National Radio News)
http://www.cbc.ca/news/background/workplace-safety/outofsync.html
Overserved (Ottawa Citizen series on bar inspections)
http://www.ottawacitizen.com/entertainment/Controversy+straight/1965956/story.html
http://www.ottawacitizen.com/search/search.html?q=overserved
Pardons allow new start, applicants say (CBC News)
http://www.cbc.ca/news/politics/story/2011/02/20/pol-mckie-pardon-story.html
Pardon applications expected to tumble (The Canadian Press)
http://www.cbc.ca/news/politics/story/2012/01/03/pardons-canada-prison.html
Parking Secrets: Where you’re most likely to be ticketed (The Vancouver Sun)
http://www.vancouversun.com/Parking+Secrets+Where+most+likely+ticketed/1323988/story.html
Police dip into victims’ cash (The Toronto Star)
http://www.thestar.com/news/gta/article/702444
Political contributions: What the numbers say
Political donations in Alberta – 2004 to 2010 (Edmonton Journal)
http://www.edmontonjournal.com/news/donations/database.html
http://www2.canada.com/edmontonjournal/news/story.html?id=a4ddf170-bd63-4ff0-b7d9-9ae55199e92c&p=2
Prescribed to death
http://www.cbc.ca/news/background/seniorsdrugs/
Prison ‘double-bunking’ risks violence, ombudsman says (CBC News)
http://www.cbc.ca/news/politics/story/2011/06/17/pol-prisons-double-bunking.html
Payment plea for Tamil protest costs ignored (CBC News)
http://www.cbc.ca/news/politics/story/2010/07/29/ottawa-tamil-protest-costs-public-safety.html
Private sector must help keep lid on drug costs, report argues (CBC News)
http://www.cbc.ca/news/politics/story/2011/05/11/pol-mckie-drug-costs-report.html
PS balloons on Conservatives’ watch (The Ottawa Citizen)
http://www.ottawacitizen.com/business/Conservatives+watch/4234048/story.html
Public service absenteeism jumps by 40%; ‘Alarming’ spike over past decade draws ire, sympathy from experts (The Ottawa Citizen)
Please read the story by clicking here
Race Matters (The Toronto Star)
http://www.thestar.com/specialsections/raceandcrime
Rapid Fire (The Ottawa Citizen)
http://www.canada.com/ottawacitizen/features/rapidfire/index.html
RCMP fire Tasers multiple times despite health hazards: probe (CBC-Radio-Canada, The Canadan Press)
http://www.cbc.ca/canada/story/2008/06/11/taser-rcmp.html
RCMP softened Taser-use restrictions (CBC-Radio-Canada, The Canadian Press)
http://www.cbc.ca/canada/britishcolumbia/story/2009/03/25/taser.html
RCMP shocked 16 people five times or more last year (CBC and The Canadian Press)
http://www.cbc.ca/news/canada/rcmp-shocked-16-people-five-times-or-more-last-year-1.812794
RCMP spied on scholar Northrop Frye, records show (The Canadian Press)
To read article, please click here
RCMP spied on Tommy Douglas as early as 1936 (The Canadian Press)
http://www.ctv.ca/CTVNews/Canada/20111111/tommy-douglas-rcmp-files-111111/
RCMP halts use of older model Tasers after B.C. decision (The CBC)
http://www.cbc.ca/canada/british-columbia/story/2009/06/01/bc-government-pulls-tasers.html?ref=rss
Report details encounters with rude, accusatory border employees (The Canadian Press)
Ring of Fire mining may not benefit First Nations as hoped (The CBC)
Rise in prison gangs fuelling violence, drug trade (CBC News)
http://www.cbc.ca/news/politics/story/2012/10/24/pol-gangs-prisons.html
Roadside breath tests not always accurate: documents (CTV News, British Columbia)
Several news stories by Stanley Tromp, based upon Freedom of Information requests
http://www3.telus.net/index100/trompfoistories
Secret Skies (CBC News investigation into air safety on the 10th anniversary of the Swissair crash)
http://www.cbc.ca/news/secretskies/
Security video of Robert Dziekanski: Select footage from 6 hours in Vancouver International Airport (CBC News)
http://www.cbc.ca/news/background/tasers/video.html
Some airport screeners have sticky fingers, documents show (QMI Agency)
http://www.torontosun.com/2011/09/12/some-airport-screeners-have-sticky-fingers-documents-show
Some childcare facilities fall short of government standards (Martha Troian, CBC News North)
Some tested Tasers fire stronger current than company says: CBC/Radio-Canada probe
http://www.cbc.ca/canada/story/2008/12/04/taser-tests.html
Taser this: RCMP increases its use of stun guns ( CBC National Radio News/The Canadian Press)
http://www.cbc.ca/news/background/tasers/taser-use.html
Tax breaks for volunteer firefighters – less than meets the eye (CBC News, Election 2011 reality check)
Temporary foreign workers hired in areas with EI claimants (CBC News)
http://www.cbc.ca/news/politics/story/2013/05/06/temporary-foreign-worker-program.html
Temporary Foreign Worker Program complaints began in 2006 (CBC News)
http://www.cbc.ca/news/politics/temporary-foreign-worker-program-complaints-began-in-2006-1.2685056
Temporary Foreign Worker Program queries came mostly from Tory MPs (CBC News)
Harper says foreign worker program is being fixed (CBC News)
http://www.cbc.ca/news/politics/story/2013/05/07/pol-cp-temporary-foreign-workers.html
The Hornet’s Sting (The Ottawa Citizen)
http://www.canada.com/ottawacitizen/features/hornet/index.html#
The Joy of Parking (CBC Radio Halifax)
http://www.cbc.ca/ns/features/the-joy-of-parking/
The long, hot summer (The Winnipeg Free Press)
http://www.winnipegfreepress.com/breakingnews/the-long-hot-summer-128867333.html
The school nurse is in … for now (Pioneer Press)
http://www.twincities.com/ci_13874895?nclick_check=1
The Washington Post (artricles by former database editor Sarah Cohen)
http://projects.washingtonpost.com/staff/articles/sarah+cohen/
Times launching database that maps, analyzes crime reports across L.A. County
http://www.latimes.com/news/local/la-me-crime-data-20100930,0,4503455.story
Time’s Up (Winnipeg Free Press)
http://www.winnipegfreepress.com/special/parking_tickets/
Tory ridings the winners from stimulus (The Ottawa Citizen)
Tory MP who flirted with Chinese reporter passed security check (The Canadian Press)
Toxic spills put Arctic under threat, report finds
Too many drugs allowed on market: MP (CBC News)
http://www.cbc.ca/news/health/story/2011/01/19/health-canada-drugs.html
Top-paid Ont. civil servants list jumps 11% (CBC News)
http://www.cbc.ca/news/canada/toronto/story/2011/03/31/ontario-sunshine-list.html
Tory crime plan fails victims, inmates: critics (CBC News)
http://www.cbc.ca/news/story/2011/02/15/pol-mckie-inmate-programs.html
Toyota floor-mat problems arose in 2003 (CBC News)
http://www.cbc.ca/news/toyota-floor-mat-problems-arose-in-2003-1.974720
Toyota should have revealed ’05 lawsuit: critics (CBC News)
http://www.cbc.ca/money/story/2010/04/12/toyota-lawsuit-critics.html
Toyota problems seen months before recall (CBC News)
http://www.cbc.ca/news/toyota-problems-seen-months-before-recall-1.896283
Toxic Waters: Clean Water Laws Are Neglected, at a Cost in Suffering (The New York Times)
http://projects.nytimes.com/toxic-waters
U.S. worries about Canadian meat flagged in memo: Coalition wants plug pulled on meat pre-clearance pilot project in wake of XL Foods recall
XL Foods warned 6 times over lapses before E. coli outbreak (CBC News): Correction Action Requests issued at Alberta plant for sanitation, contamination
http://www.cbc.ca/news/politics/story/2013/01/08/pol-cfia-xl-foods-atip-corrective-action.html
Vehicle safety bill moves ahead (CBC News)
http://www.cbc.ca/canada/story/2010/10/06/transport-canada-recall-vehicles.html?ref=rss
Visits to food banks in Toronto’s suburbs up almost 20% since 2008 (CTV News)
Who are Saskatchewan’s medicinal marijuana users? ( The Leader-Post)
http://www.leaderpost.com/health/Saskatchewan+medicinal+marijuana+users/5838807/story.html
Who wins, loses from mass immigration to California? (The Orange County Register)
http://www.ocregister.com/news/-267327–.html
WORKING WOUNDED: Hiding injuries rewards companies
http://www.thestar.com/News/GTA/article/451322
CATALOGUE SEARCH ENGINES (TOP)
Yahoo
LookSmart
Open Directory Project
Cluster searches
Reporter’s desktop
http://www.reporter.org/desktop/
Verbatim tool: Search using the exact words you typed
https://support.google.com/websearch/answer/1734130?hl=en\
Incognito mode (browse in private)
https://support.google.com/chrome/answer/95464?hl=en
DuckDuckGo (anonymous searches)
Firefox Private Browsing
http://support.mozilla.org/en-US/kb/private-browsing-browse-web-without-saving-info
CENSUS (TOP)
2016 Census Program release schedule
http://www12.statcan.gc.ca/census-recensement/2016/ref/release-dates-diffusion-eng.cfm
2016 Census of Population: Age and sex release
http://www12.statcan.gc.ca/census-recensement/2016/ref/98-501/98-501-x2016002-eng.cfm#a1
http://www.statcan.gc.ca/daily-quotidien/170503/dq170503a-eng.htm?HPA=1
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/index.cfm?Lang=E
2016 Census of Population: Type of dwelling release
http://www12.statcan.gc.ca/census-recensement/2016/ref/98-501/98-501-x2016003-eng.cfm
Dictionary, Census of Population, 2016
http://www12.statcan.gc.ca/census-recensement/2016/ref/dict/index-eng.cfm
2016 Geographic boundaries
http://www12.statcan.gc.ca/census-recensement/2016/geo/index-eng.cfm
Census Mapper
https://censusmapper.ca/maps/584
Population and Dwelling Count Highlight Tables, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/hlt-fst/pd-pl/comprehensive.cfm
Hierarchy of standard geographic areas for dissemination, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/ref/dict/figures/f1_1-eng.cfm
Current population and household estimates
http://ottawa.ca/en/city-hall/get-know-your-city/statistics-and-economic-profile/statistics/current-population-and
Canadian Census Analyser from the University of Toronto
https://login.proxy.library.carleton.ca/login?url=http://dc1.chass.utoronto.ca/census/
Canadian Immigration Stats (for Canada and all regions from the 2001 and 2006 censuses)
Boundary files (Statistics Canada)
http://www12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-eng.cfm
City of Ottawa 2011 Census Backgrounder
Geogrpahic levels for 2011 census (Statistics Canada)
2006 Census Population (Statistics Canada)
http://www12.statcan.gc.ca/census-recensement/2006/index-eng.cfm
2006 Census Income and Earnings
2006 Census Household Income
2011 Census – Province and Territory Cargographic Boundary Files (Statistics Canada)
http://www.data.gc.ca/data/en/dataset/bab06e04-e6d0-41f1-a595-6cff4d71bedf
NHS Profile, 2011
http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/index.cfm?Lang=E
National Household Survey User Guide
http://www12.statcan.ca/nhs-enm/2011/ref/nhs-enm_guide/index-eng.cfm
HS Profile – Download NHS data for a complete geographic level: CSV or TAB
Census tract (CT) suppression list
http://www12.statcan.ca/census-recensement/2011/ref/sup_CT-SR-eng.cfm
Ottawa ward boundary file
http://data.ottawa.ca/dataset/wards-2010/resource/6abe3aa1-4ad8-4061-bb18-dad5054b85fb
Toronto Has Over 99,000 Unoccupied Homes, Here’s Where They Are [Interactive]
https://betterdwelling.com/city/toronto/toronto-has-over-99000-unoccupied-homes-heres-where-they-are-interactive/#_
The house is sold, but nobody’s home
https://www.theglobeandmail.com/real-estate/toronto/vancouvers-vacant-home-surge-comes-to-thegta/article34639829
CHILDREN’S SAFETY (TOP)
Child Care Lookup (Government of Alberta)
http://www.child.alberta.ca/home/ChildCareLookup.cfm
Ontario Ministry of Children and Youth Services (Find Licenced Childcare)
Toronto’s Children’s Services
http://www.toronto.ca/children
Nova Scotia Directory of Licensed Child Care Facilities
http://www.gov.ns.ca/coms/families/childcare/directories/FacilitySearch.aspx
Care and Attention (The Vancouver Sun’s investigation into daycares)
http://www.canada.com/vancouversun/features/care/index.html
Child and Spousal Support: Maintenance Enforcement Survey Statistics (Statistics Canada)
http://www.statcan.gc.ca/pub/85-228-x/85-228-x2011000-eng.htm
http://www.statcan.gc.ca/pub/85-228-x/2011000/tablesectlist-listetableauxsect-eng.htm
CONSUMER ISSUES AND CONSUMER-RELATED STORIES(TOP)
InjuryBoard Blog Network
Chemical companies, Big Tobacco and the toxic products in your home (Chicago Tribune.com)
http://media.apps.chicagotribune.com/flames/index.html
Joe Debtor:Who Is The Average “Joe Debtor” And Why Does He File Insolvency?
http://www.hoyes.com/press/joe-debtor/
COMPUTER-ASSISTED REPORTING(Top)
CBC’s adverse drug reaction database series
Rapid Fire ( the Ottawa Citizen’s searchable online gun registry database http://www.canada.com/ottawacitizen/features/rapidfire/form.html
National Institute for Computer-Assisted Reporting
http://www.ire.org/resource-center/listservs/subscribe-nicar-l/
Investigative Reporters and Editors, Inc.
Example syllabi
http://ire.org/resource-center/educators-center/syllabi/
Syllabi – Curriculum Outlines and Ideas (IRE)
http://www.ire.org/education/syllabi.html
Center for Public Integrity
http://www.publicintegrity.org/wow/default.aspx
CARinCanada
Calculator Soup
http://www.calculatorsoup.com/calculators/algebra/percent-change-calculator.php
NewsEngin’s Percent Change Calculator
http://newsengin.com/neFreeTools.nsf/PercentChange/formPercentChange
Stephen Lamble’s computer-assisted reporting home page (Faculty of Arts and Social Sciences, University of the Sunshine Coast, Queensland, Australia)
http://members.optusnet.com.au/~slamble/index.html
SearchEngineWatch.com
Jakob Nielsen’s Website (Expert advice on Internet trends and usage)
Domain name registries around the world
http://www.norid.no/domenenavnbaser/domreg.html
Latitude/Longitude Distance Calculation
http://jan.ucc.nau.edu/~cvm/latlongdist.html
NGA Range Bearing Computation (the National Geospatial-Intelligence Agency)
http://geoengine.nga.mil/geospatial/SW_TOOLS/NIMAMUSE/webinter/rangbear.html
SQL Server Express
http://www.microsoft.com/express/Database/InstallOptions.aspx
University of Maryland Computer Science (the history of spreadsheets and other applications)
http://www.cs.umd.edu//class/spring2002/cmsc434-0101/MUIseum/applications/index.html
COMPUTER-ASSISTED REPORTING TUTORIALS(Top)
Text editing with spreadsheets
http://forjournalists.com/cookbook/index.php?title=Text_editing_with_spreadsheets
‘Microsoft Excel Tips’ (CARinCanada)
http://blogs.ukings.ca/carincanada/category/data-you-can-use/
Excel Tips
http://excel.tips.net/questions.html?awt_l=9wwNF&awt_m=1aE6X1z3C1sx4X
My Favorite (Excel) Things (Excellent tutorial from MaryJo (Sylwester) of the St. Paul Pioneer Press)
http://extra.twincities.com/CAR/MJ/ExcelClasshandout.pdf
http://extra.twincities.com/CAR/MJ/DataStateofMind.pdf
http://extra.twincities.com/CAR/MJ/ManagingJuggling.pdf
Computer-Assisted Reporting: A Comprehensive Primer
http://www.oupcanada.com/higher_education/companion/comm_studies/9780195424577.html
ProPublica News Apps Style Guide
https://github.com/propublica/guides/blob/master/news-apps.md#data-singular-or-plural
Reporters’ Cookbook!
http://forjournalists.com/cookbook/index.php?title=Main_Page
Computer Tutorials
http://599cd.com/tips/excel/?key=
HelpbyHacks
http://help.hackshackers.com/questions
Miracle Solutions
http://www.auditexcel.co.za/GoTo%20Special%20Project.html#eighth
Internet Relay Chat
http://en.wikipedia.org/wiki/Internet_Relay_Chat
Google Refine (ClusteringInDepth)
http://code.google.com/p/google-refine/wiki/ClusteringInDepth
How to Scrape Websites for Data without Programming Skills (The Poynter Institute)
Scraping for Journalists: How to grab data from hundreds of sources, put it in a form you can interrogate – and still hit deadlines By Paul Bradshaw
https://leanpub.com/scrapingforjournalists
For Journalism: Data journalism for all (@forjournalism)
https://twitter.com/forjournalism
101 Ready-to-Use Excel Formulas
http://books.google.ca/books?id=HnwJBAAAQBAJ&printsec=frontcover#v=onepage&q&f=false
Excel DATEDIF Function – Calculate the difference between two dates
http://www.exceltrick.com/formulas_macros/excel-datedif-function/
The Elements of Data Analytic Style
23 things you should know about Excel pivot tables
https://exceljet.net/things-to-know-about-excel-pivot-tables
CONTRACTS(Top)
Buyandsell.gc.ca
https://buyandsell.gc.ca/procurement-data/tenders
Government-Wide Reporting — Proactive Disclosure (Treasury Board Secretariat of Canada)
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
http://open.canada.ca/data/en/dataset/455d4d0a-5d5f-4f60-aa8a-9e36540d21d3
Alberta
http://vendor.purchasingconnection.ca/
British Columbia
http://www.bcbid.gov.bc.ca/open.dll/welcome
Quebec
https://www.seao.ca/index.aspx
Saskatchewan
http://www.sasktenders.ca/index.html
CORONERS’/CHIEF MEDICAL EXAMINERS’ OFFICES(Top)
Directory of chief coroners (Canadian Centre for Occupational Health and Safety)
http://ccinfoweb.ccohs.ca/help/fatality/coroners.html
B.C.
http://www.pssg.gov.bc.ca/coroners/
Alberta
http://www.justice.gov.ab.ca/ocme/
Saskatchewan
http://www.saskjustice.gov.sk.ca/coronersoffice/
Manitoba
http://www.gov.mb.ca/justice/about/chief.html#2
Ontario
http://www.mcscs.jus.gov.on.ca/English/pub_safety/office_coroner/about_coroner.html
Québec
http://www.msp.gouv.qc.ca/coroner/coroner.asp?txtSection=bureau_coroner
New Brunswick
http://www.gnb.ca/0276/Coroner/index-e.asp
Nova Scotia
http://nslegislature.ca/index.php/proceedings/hansard/
Prince Edward Island
http://www.gov.pe.ca/infopei/index.php3?number=52651
Nunavut
http://www.justice.gov.nu.ca/english/courtserv.html
NWT
http://www.justice.gov.nt.ca/Coroner/coroner.htm
Yukon
http://www.justice.gov.yk.ca/prog/cjps/crnr/
CRIME (Top)
Canada Border Services Agency code of conduct statistics
http://www.cbsa-asfc.gc.ca/agency-agence/reports-rapports/acc-resp/codeconduct-normeethique-eng.html
Documenting Hate Crimes in Alberta
https://stophateab.ca/
RCMP Detachments – Telephone Numbers
http://www.rcmp-grc.gc.ca/detach/index-eng.htm
Criminal Intelligence Service Canada
http://www.cisc.gc.ca/products_services/products_services_e.html
Canadian Firearms Program (RCMP – facts and figures)
http://www.rcmp-grc.gc.ca/cfp-pcaf/facts-faits/index-eng.htm
Edmonton Police Service Dashboard
https://dashboard.edmonton.ca/eps
Marihuana Grow Initiative (RCMP)
http://www.rcmp-grc.gc.ca/drugs-drogues/mgi-ircm/index-eng.htm
Call for Backup (RCMP site)
http://www.callforbackup.ca/en/
Police reported crime statistics (Statcan summary table that compares “most serious crimes” from 2007 to 2008)
http://www.statcan.gc.ca/daily-quotidien/090721/dq090721a-eng.htm
Crimes and offences (Statcan summary tables that break crimes down by province and territories)
Crimes by type of violation, and by province and territory (Statcan summary tables)
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/legal50a-eng.htm
Incident-based crime statistics, by detailed violations (Statcan summary tables)
Juristat (Statistics Canada)
http://dsp-psd.pwgsc.gc.ca/Collection-R/Statcan/85-002-XIE/85-002-XIE.html
Public Safety Canada terrorist list
http://www.publicsafety.gc.ca/cnt/ntnl-scrt/cntr-trrrsm/lstd-ntts/crrnt-lstd-ntts-eng.aspx
Ottawa Police
http://www.ottawapolice.ca/en/CrimeFiles/CrimeMaps_Reports/crimestats.aspx
Crime Reports (Ottawa police)
http://www.ottawapolice.ca/en/crime/crime-stats.asp
Canadian Association of Police Boards
http://capb.cms10.tomahawk.ca/Home
Crime Reports (crime mapping company for police forces in North America)
http://www.crimereports.com/map?search=Ottawa+Ontario
The University of Ottawa
http://www.protection.uottawa.ca/en/statistics.html
Queen’s University
http://www.queensu.ca/security/
Security in the Community (Hintonburg Community Association)
http://hintonburg.com/SC_start.html
Tracking the Politics of ‘Crime’ and Punishment in Canada
http://tpcp-canada.blogspot.com/
Adult Correctional Services Survey (Canadian Centre for Justice Statistics)
http://library.queensu.ca/webdoc/ssdc/b2020/ccjs_guide.htm
United Nations Office of Drugs and Crime — Global Study on Homicide
http://www.unodc.org/gsh/en/data.html
DATABASES(Top)
Vehicle Defect Complaints (Transport Canada)
Ottawa Citizen article on domestic violence
Statscan2006 detailed samesex data
Statscan 2001 detailed samesex data
Ottawa CMA, all violation, 1998-2010
AidData
http://aiddata.org/content/index/AidData-Raw
Data & Research (The World Bank)
Datacatalogs.org (a comprehensive list of open data catalogs currated by experts from around the world)
DATA JOURNALISM EDUCATION(Top)
10 principles for data journalism in its second decade
https://medium.com/thoughts-on-journalism/10-principles-for-data-journalism-in-its-second-decade-3b45e08a4793
Data Journalism or Computer Assisted Reporting
https://tcij.org/resources/handbooks/data-journalism
Census Reporter
https://censusreporter.org/
Crime Data Explorer
https://crime-data-explorer.fr.cloud.gov/
Understanding the needs of people in journalism tech
http://datadrivenjournalism.net/news_and_analysis/understanding_the_needs_of_people_in_journalism_tech
Introducing Our Data Journalism Advisers
https://www.propublica.org/nerds/introducing-our-data-journalism-advisers
Murder Accountability Project
http://murderdata.org/
Strategies and Best Practices for Data Literacy Education
https://dalspace.library.dal.ca/bitstream/handle/10222/64578/Strategies%20and%20Best%20Practices%20for%20Data%20Literacy%20Education.pdf?sequence=1&isAllowed=y
OpenUp
https://openup.org.za/
Teaching Open Data
http://open.canada.ca/en/blog/teaching-open-data
Two fundamentals that define good data journalism
https://medium.com/@digidickinson/two-fundamentals-that-define-good-data-journalism-fe79170f8566
DATA JOURNALISM (Top)
A crucial skill that most J-schools aren’t teaching
http://www.cjr.org/analysis/data.php?utm_content=bufferf0be0
A Primer on Machine Readability for Online Documents and Data
https://www.data.gov/developers/blog/primer-machine-readability-online-documents-and-data
Data empowers journalism independence in Trump’s era
https://www.cjr.org/watchdog/data-journalism-independence-trump.php
50 ideas in 60 minutes #NICAR15//ATL
Bad water: ‘Third World’ conditions on First Nations in Canada
http://www.cbc.ca/news/canada/manitoba/bad-water-third-world-conditions-on-first-nations-in-canada-1.3269500prez
CUNY J+: Data Journalism Bootcamp: Excel, Open Refine, Tableau and More
https://www.journalism.cuny.edu/events/cuny-j-data-journalism-bootcamp-excel-open-refine-tableau/2017-09-23/
Data Desk (The Los Angeles Times)
Data Driven Journalism: Doing Journalism with Data: First Steps, Skills and Tools
http://learno.net/courses/doing-journalism-with-data-first-steps-skills-and-tools
Data Driven Journalism: Where Journalism Meets Data
http://datadrivenjournalism.net/news_and_analysis
Data Driven Journalism
http://www.rightrelevance.com/search/influencers?query=Data%20Driven%20Journalism&taccount=ddj_rr
DATA JOURNALISM: AN EXPLICATION
https://isojjournal.wordpress.com/2015/04/15/data-journalism-an-explication/
Data Journalism Tools Part 1: Extracting and Scraping Data
http://blog.silk.co/post/142737643047/data-journalism-tools-part-1-extracting-and
Diving into Data Journalism: Strategies for getting started or going deeper
https://www.americanpressinstitute.org/publications/reports/strategy-studies/data-journalism/
Exposing The Invisable
https://exposingtheinvisible.org/guides/decoding-data/
Tools for Data Visualization Part 2: Cleaning Data
http://blog.silk.co/post/143527419532/tools-for-data-visualization-part-2-cleaning-data
Tools for Data Visualization part 3: Enhancing Data
http://blog.silk.co/post/144293633212/tools-for-data-visualization-part-3-enhancing
Data storytelling
DataProf (Fred Vallance-Jones)
Chad Skelton (Telling stories with data)
The “coxcomb” or “rose diagram”: Florence Nightingale’s most famous statistical diagram (1858)
http://www.florence-nightingale-avenging-angel.co.uk/Coxcomb.htm
The Guardian’s data blog
http://www.theguardian.com/news/datablog
Dan Bricklin’s Web Site
Data Journalism Blog
http://www.datajournalismblog.com
Data Journalism Handbook (1.0 Beta)
http://datajournalismhandbook.org/1.0/en/
Chicago Crime (Chicago Tribune)
http://crime.chicagotribune.com/
http://www.chicagotribune.com/news/data/
http://www.chicagotribune.com/news/watchdog/
http://schools.chicagotribune.com/
CodeAcademy
Collaboration, computer help, and coding: A new book looks at data journalism in the newsroom
Global Investigative Journalism Network
http://gijn.org/resources/data-journalism/
FlowingData
http://flowingdata.com/
How the News Apps Team at Chicago Tribune Works
http://www.datajournalismhandbook.org/1.0/en/in_the_newsroom_2.html
Intro Into Web Apps
https://introwebapps.wordpress.com/2016/11/18/history-data-story/
I’m @mtdukes
Inayat Singh
Journalism++
/datajournalism
https://github.com/lenagroeger/datajournalism
Nael Shiab
http://naelshiab.com/language/en/
News Apps Blog ( The Chicago Tribune)
http://blog.apps.chicagotribune.com/
http://www.chicagotribune.com/news/data/
Open Source vs. Proprietary Software
http://www.gn.apc.org/support/open-source-vs-proprietary-software
Ontario political donations surge, plunge around key policy decisions, Radio-Canada finds
http://www.cbc.ca/news/canada/toronto/ontario-political-donations-1.3588320
Ontario unions behind 94 per cent of third-party ad spending in past three elections
http://www.theglobeandmail.com/news/national/ontario-unions-behind-94-per-cent-of-third-party-ad-spending-in-past-three-elections/article31326097/
10 ans et 100 millions en dons pour influencer les partis ontariens
The next wave of data journalism?https://onlinejournalismblog.com/2017/08/01/future-of-data-journalism-book-chapter/
Nouvelles règles du financement politique en Ontario : quel parti sortira gagnant?
The New Precision Journalism (Chapter 10)
http://www.unc.edu/~pmeyer/book/Chapter10.htm
NICAR Courses
Open (The New York Times)
http://open.blogs.nytimes.com/
opencorporates
OpenSecrets Open Data (A U.S. Google group for open-date and data-journalism enthsiasts)
https://groups.google.com/forum/#!forum/opensecrets-open-data
Paper.li
http://paper.li/flpires/1336026968#/
School of Communication to host SPJ-Google News Lab training
https://news.illinoisstate.edu/2017/08/school-communication-host-spj-google-news-lab-training/
The Art and Science of Data-Driven Journalism
http://towcenter.org/the-art-and-science-of-data-driven-journalism/
http://towcenter.org/wp-content/uploads/2014/05/Tow-Center-Data-Driven-Journalism.pdf
The future of news: A conversation with Google
https://mg.co.za/article/2017-08-09-the-future-of-news-a-conversation-with-google
The Overview Project
The Curious Journalist’s Guide to Data
The Datajournalist
http://thedatajournalist.ca/
O’Reilly Media
http://www.propublica.org/nerds
The Ythat Blog
The 10 and 3
Sarah Slobin
TEACHING DATA AND COMPUTATIONAL JOURNALISM
http://www.journalism.columbia.edu/system/documents/1001/original/teachingdata16.pdf
The dirty little secret that data journalists aren’t telling you
Want to start a small data journalism team in your newsroom? Here are 8 steps
Winny De Jong
https://feedly.com/datajournalism
DATA JOURNALISM Stories(Top)
4 examples of computational thinking in journalism
https://onlinejournalismblog.com/2017/10/06/4-examples-of-computational-thinking-in-journalism/
1 in 10 rapes reported at Auburn occur in student athlete dorms
https://thetab.com/us/auburn/2017/09/06/1-every-10-rapes-auburn-happens-student-athlete-dorms-1205
Adult Obesity in the United States
https://stateofobesity.org/adult-obesity/
BuzzFeed News Trained A Computer To Search For Hidden Spy Planes. This Is What We Found
https://www.buzzfeed.com/peteraldhous/hidden-spy-planes?utm_term=.vaBpvJG65#.feWo91q7g
Giving data soul: Best practices for ethical data journalism
https://gijn.org/2017/09/06/data-journalisms-top-ten-6/
L’Assemblée nationale est sexiste et en voici la preuve
http://www.lactualite.com/politique/deputees/
The Associated Press adds new data journalism chapter to their Stylebook
http://community.powerbi.com/t5/Data-Storytelling-Discussion/The-Associated-Press-adds-new-data-journalism-chapter-to-their/m-p/216860
ICAR2017: CAR Conference Blog
http://ire.org/blog/car-conference-blog/
http://ire.org/blog/transparency-watch/
Chemical Breakdown
http://www.houstonchronicle.com/local/texas/chemical-breakdown/
Conservative ridings got most of Canada 150 cash
https://www.thestar.com/news/canada/2016/10/15/conservative-ridings-got-most-of-canada-150-cash.html
Data-Driven Journalism: Global Investigative Journalism Network
http://gijn.org/category/data-driven-journalism/
Distrust Your Data:Jacob Harris on Six Ways to Make Mistakes with Data
https://source.opennews.org/articles/distrust-your-data/
How the Doctors & Sex Abuse project came about
http://doctors.ajc.com/about_this_investigation/
How Trump’s Budget Would Affect Every Part of Government
https://www.nytimes.com/interactive/2017/05/23/us/politics/trump-budget-details.html?_r=0
Journalists and editorial analyst – Urbs Media RADAR project
http://www.pressgazette.co.uk/job/journalists-and-editorial-analyst-urbs-media-radar-project/
8 fantastic examples of data journalism
https://www.import.io/post/8-fantastic-examples-of-data-journalism/?ref=quuu&utm_content=buffer85490&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer
More than 30,000 parking tickets worth over $1.4 million issued at UTSG, UTSC
http://thevarsity.ca/2016/07/17/more-than-30000-parking-tickets-worth-over-1-4-million-issued-at-utsg-utsc/
Muckrock: Original reporting, commentary, and analysis of public records by MuckRock’s staff and affiliates, with new articles every weekday
https://www.muckrock.com/news/
NSA Files: Decoded
http://www.theguardian.com/world/interactive/2013/nov/01/snowden-nsa-files-surveillance-revelations-decoded#section/1
Ontario unions behind 94 per cent of third-party ad spending in past three elections
http://www.theglobeandmail.com/news/national/ontario-unions-behind-94-per-cent-of-third-party-ad-spending-in-past-three-elections/article31326097/
Our Broken Economy, in One Simple Chart
https://www.nytimes.com/interactive/2017/08/07/opinion/leonhardt-income-inequality.html
Plastic Fibers Are Found in 83% of the World’s Tap Water, a New Study Reveals
http://time.com/4928759/plastic-fiber-tap-water-study/
Research Matters
https://researchmatters.in/
The Deadliest Jobs in America
http://www.bloomberg.com/graphics/2015-dangerous-jobs/
Teacher vacancy rate double in poor areas
http://www.bbc.com/news/uk-england-40936182
Ten principles for data journalism in its second decade
https://onlinejournalismblog.com/2017/08/07/10-principles-for-data-journalism-in-its-second-decade/
Half of complaints against RCMP lead to discipline, data suggests
http://www.cbc.ca/news/politics/rcmp-disciplinary-database-1.3854365
Top 10 Data Journalism Links
http://gijn.org/series/top-10-data-journalism-links/
What are the worst places to park in Canada? Here’s the data on that
http://www.cbc.ca/news/business/marketplace-parking-tickets-canada-nov-17-1.3854094
DATA VISUALIZATION (Top)
31 Free Data Visualization Tools
https://www.springboard.com/blog/31-free-data-visualization-tools/
Code out loud
Collision-prone: When are you statistically most likely to get in an accident?
http://www.wheels.ca/news/49355/
Canada’s deficits and surpluses, 1963-2014 (CBC News)
http://www.cbc.ca/news2/interactives/canada-deficit/
Chart types and data formats
https://support.google.com/docs/topic/30240
City Expands Open Data To Include 311 Service Requests
http://windsorite.ca/2017/01/city-expands-open-data-to-include-311-service-requests/
Cost of a Standard Hospital Stay
https://yourhealthsystem.cihi.ca/hsp/inbrief?lang=en#!/indicators/015/cost-of-a-standard-hospital-stay/;mapC1;mapLevel2;provinceC9001;trend(C1,C9001);/
Data Visualization For All: Tell Your Story with Free and Easy Tools
https://www.gitbook.com/book/jackdougherty/datavizforall/details
Day of Mourning for workers focuses on asbestos ban
http://www.cbc.ca/news/canada/ottawa/day-of-mourning-ottawa-1.3555869
Documenting Hate Crimes in Alberta
https://stophateab.ca/
Big Data Visualization: Review of the 20 Best Tools
http://inspire.blufra.me/big-data-visualization-review-of-the-20-best-tools/
Data visualization resources and ideas
http://www.mulinblog.com/data-visualization-resources-and-ideas/
THE DATAVIZ DESIGN PROCESS: 7 STEPS FOR BEGINNERS
http://annkemery.com/dataviz-design-process/
The Data Visualization Catalogue
http://datavizcatalogue.com/index.html
Dadaviz.com
Data Visualization for Human Perception (By Stephen Few, chapter 35 in Interaction Design Foundation: Encyclopedia of Human-Computer Interaction)
https://www.interaction-design.org/encyclopedia/data_visualization_for_human_perception.html
Data Visualization
http://searchbusinessanalytics.techtarget.com/definition/data-visualization
Edmonton police data posted online paints a picture of rising crime
http://edmontonjournal.com/news/crime/edmonton-police-data-posted-online-paints-a-picture-of-rising-crime
EPS Dashboard
https://dashboard.edmonton.ca/eps
FiveThirtyEight
http://fivethirtyeight.com/datalab/our-33-weirdest-charts-from-2014/
FlowingData
For about $100,000, Columbia Journalism School will train you to be ready for the next massive leak
http://www.poynter.org/2017/for-about-100000-columbia-journalism-school-will-train-you-to-be-ready-for-the-next-massive-leak-update3/469364/
How the counting of points, not votes, could determine Conservative leadership race
http://www.cbc.ca/news/politics/grenier-conservative-leadership-ridings-1.4118356
How to: use maps effectively to explain stories
http://www.carlapedret.cat/maps-stories-cartodb-mapbox-fusion-tables/
How we used satellite data to track California wildfires
https://www.revealnews.org/blog/how-we-used-satellite-data-to-track-california-wildfires/
How Fire Feeds
http://fire.revealnews.org/
Innovation in America (Peter Aldous)
http://www.peteraldhous.com/innovation.html
Introduction to Data Visualization – top ten do’s and don’ts
http://guides.library.duke.edu/topten
Jonathan Gray
http://jonathangray.org/
Journalism in the Age of Data
http://datajournalism.stanford.edu/#
Junk Charts
http://junkcharts.typepad.com/
Lena Groeger
http://lenagroeger.com/
Michelle Minkoff
http://michelleminkoff.com/teaching/
Milestones in the History of Thematic Cartography,
Statistical Graphics, and Data Visualization
http://euclid.psych.yorku.ca/SCS/Gallery/milestone/
MulinBlog: A digital journalism blog
http://www.mulinblog.com/teaching-data-visualization-recommended-readings-and-resources/
The Noun Project
https://thenounproject.com/
Overview (visualizations of large document sets)
Part 1: Working with Data
https://pudding.cool/process/how-to-make-dope-shit-part-1/
Public Data (Google)
http://www.google.com/publicdata/directory
Pay vs. performance: How do Canada’s CEOs stack up?http://www.theglobeandmail.com/report-on-business/careers/management/executive-compensation/how-does-canadian-ceo-pay-compare-to-their-performance/article30171589/
Roberto Rocha
7 Data Visualization Types You Should be Using More (and How to Start)
Shielded By The Badge: Convicted, But Still Policing
http://www.startribune.com/minnesota-police-officers-convicted-of-serious-crimes-still-on-the-job/437687453/
Silk Blog (Picking The Right Visualization For Your Data)
http://blog.silk.co/post/120086012962/picking-the-right-visualization-for-your-data
Sixteen useless infographics
http://www.theguardian.com/news/datablog/gallery/2013/aug/01/16-useless-infographics?CMP=twt_gu
The fundraising race: Search our map to see where Tory leadership candidates are getting donations
http://news.nationalpost.com/news/canada/canadian-politics/winners-and-losers-in-the-pc-leadership-race-sorted-by-postal-codes
Video: All Your Pot Are Belong to Us (The Center for Investigative Reporting)
http://cironline.org/reports/video-all-your-pot-are-belong-us-4771
Which tool should I use?http://ire.org/files/static_files/video/toolvideos.html
W3Schools.com
What’s Your Pay Gap? (The Wall Street Journal)
http://graphics.wsj.com/gender-pay-gap/
Women in Elite Jobs Face Stubborn Pay Gap (The Wall Street Journal)
http://www.wsj.com/articles/women-in-elite-jobs-face-stubborn-pay-gap-1463502938
Wooing America:Sixty-four cities, 44 states and 300 contacts. Inside Canada’s six-month mission to one-up the White House in the next NAFTA negotiations, one handshake at a time.
http://www.macleans.ca/wooing-america/
World Development Indicators (The World Bank)
http://data.worldbank.org/data-catalog/world-development-indicators?cid=GPD_WDI
DEFENCE(Top)
CRS Evaluation Reports
http://www.crs-csex.forces.gc.ca/reports-rapports/rp-ev-eng.aspx
Discovery recalls Justin Trudeau’s 1st visit to High Arctic — as a 3-year-old
http://www.cbc.ca/news/politics/arctic-cairn-ward-hunt-island-trudeau-1.4055558
To see the video of the plaque’s presentation to the Prime Minister, please click here.
Today @HarjitSajjan presented @JustinTrudeau with a piece of his past the Canadian Forces discovered on an exercise in the Arctic #pnpcbc
Office of the Judge Advocate General (National Defence)
http://www.forces.gc.ca/en/about-org-structure/judge-advocate-general-office.page?
Decisions of convictions resulting from courts martial
http://www.jmc-cmj.forces.gc.ca/en/2013/res.page
THE MONEY PAGE:Government gets poor grade for military spending (CBC News)
http://www.cbc.ca/news/politics/government-gets-poor-grade-for-military-spending-1.3030862
The Canadian Veterans Advocacy
http://canadianveteransadvocacy.com/
Summary Proceedings (National Defence)
http://www.admfincs.forces.gc.ca/qro-orf/vol-02/doc/chapter-chapitre-108.pdf
David Pugliese (Ottawa Citizen defence blog)
http://blogs.ottawacitizen.com/author/davidpugliese2/
University of British Columbia’s Veterans Transition Program
Army Suicide Prevention Program (The U.S.)
http://www.armyg1.army.mil/hr/suicide/references.asp
DIRECTORIES/REFERENCE WORKS (Top)
Repositories of Primary Sources
http://uidaho.edu/special-collections/Other.Repositories.html
Directory of Open Access Journals
WorldCat (WorldCat connects you to the collections and services of more than 10,000 libraries worldwide)
Webopedia
Wikipedia
http://en.wikipedia.org/wiki/Main_Page
Wikiscanner
Globe and Mail article about political staff making changes to Wikipedias, please click here
Canadian Historical Association Booklets
http://www.collectionscanada.ca/002/013/index-e.html?PHPSESSID=3f3137912b9f2b1722e11155b6401860
Sources Directory
Acronym Finder
Canadian Business & Current Affairs (CBCA): Queen’s University Library
http://library.queensu.ca/inforef/guides/databases/cbca.htm
Electronic Collection: A Virtual Collection of Monographs and Periodicals
Various Canadian sources
http://www.gdsourcing.ca/indexa.htm
Maps
Atlas of Canada
http://atlas.gc.ca/site/english/index.html
Books
Project Gutenberg
http://www.gutenberg.org/wiki/Main_Page
Canadian Encyclopedia
http://www.thecanadianencyclopedia.com/index.cfm?TCE_Version=A
Columbia University Libraries
http://www.columbia.edu/cu/lweb/
AskOxford.com (Oxford Dictionaries)
The Canadian Illustrated News (1869 to 1883)
http://www.collectionscanada.ca/cin/index-e.html
Dictionary of Canadian Biography
Bilingual Dictionaries
http://www.oxfordreference.com/views/SUBJECT_SEARCH.html?subject=s16&authstatuscode=200
History of the Federal Electoral Ridings since 1867
http://www.parl.gc.ca/information/about/process/house/hfer/hfer.asp?
Historical statistics of Canada
http://www.statcan.ca/english/freepub/11-516-XIE/sectiona/toc.htm
The Early Alberta Newspaper collection
http://136.159.239.228/newspapr/
Saskatchewan News Index 1884-2000
Acadiensis: The Journal of the History of the Atlantic Region
http://www.lib.unb.ca/Texts/Acadiensis/
Proquest
World News Digest
http://www.2facts.com/stories/digest-home-feature.asp
Europa World
http://www.europaworld.com/welcome?authstatuscode=200
Nationmaster.com
http://www.nationmaster.com/index.php
The World Factbook
https://www.cia.gov/library/publications/the-world-factbook/
DIGITAL NEWS WEBSITES(Top)
Engaged Journalism: Connecting with Digitally Empowered News Audiences
https://cup.columbia.edu/book/engaged-journalism/9780231168342
Why your phone is suddenly full of explainer journalism (The Globe and Mail)
The Upshot
http://www.nytimes.com/upshot/?_r=0
Vox Media
http://www.voxmedia.com/#cover
Ricochet
Newsonomics
Online Journalism Blog
https://onlinejournalismblog.com/
Quartz
The Intercept
https://firstlook.org/theintercept/
The Information
https://www.theinformation.com/
FiveThirtyEight
The ProPublica Nerd Blog:Secrets for Data Journalists and Newsroom Developers
https://www.propublica.org/nerds
Open: All the Code That’s Fit to printf() (The New York Times)
https://open.blogs.nytimes.com/
Tow Centre For Digital Journalism
http://towcenter.org/blog/
The Story So Far: What We Know About the Business of Digital Journalism
http://cjrarchive.org/img/posts/report/The_Story_So_Far.pdf
DISCIPLINARY BODIES(Top)
Chartered Accountants of Ontario
https://ebusiness.icao.on.ca/discipline/d/Alphaindex.cfm
DISCUSSIONS(Top)
Google Groups
http://groups.google.com/groups/dir
Yahoo! Groups
http://dir.groups.yahoo.com/dir/
National Archives (listserv discussion and references)
http://www.archivescanada.ca/car/car_e.asp?l=e&a=listserv
Journalism Listservs
http://reporter.asu.edu/listserv.htm
CataList (the official catalog of LISTSERV® lists)
http://www.lsoft.com/lists/listref.html
http://www.lsoft.com/scripts/wl.exe?XC=CA&C=Canada
Listserv search on journalismnet
http://www.journalismnet.com/people/listserv.htm
Canada FOI listserv
http://groups.yahoo.com/group/Canada-foi
The Slyck’s Guide to newsgroups
Tile.Net/Newsgroups (The Reference to Usenet Newsgroups)
Cyberfiber Newsgroups
Women’s Health
http://www.research.umbc.edu/~korenman/wmst/f_hlth.html
Road to Canada ( immigration discussion group)
http://www.roadtocanada.com/forums/
Workscape ( a workplace discussion group hosted by the Canadian Centre for Occupational Health and Safety)
Health-related listservs ( The Canadian Centre for Occupational Health and Safety)
http://www.ccohs.ca/resources/listserv.html
The Canadian Women’s Health Network (CWHN)
AvCanada (a discussion forum about aviation issues)
http://www.avcanada.ca/forums2/
Canadian Gunnutz
http://www.canadiangunnutz.com/
Ottawa South History Project (Canadian Heritage)
About Surrogacy.com
http://www.allaboutsurrogacy.com/forums/
SMO Message Boards
http://www.surromomsonline.com/support/
DOCUMENTCLOUD(Top)]
DocumentCloud
http://www.documentcloud.org/help/public
http://www.documentcloud.org/help/notes
Overview: Visual Document Mining for Journalists (beta)
https://www.overviewproject.org/
Annotated documents: Highlights of key excerpts and findings from Freeh report on Penn State (ydr.com)
http://www.ydr.com/local/ci_21055552
U.S. cables dissect Canada’s leaders: WikiLeaks (CBC News)
http://www.cbc.ca/news/canada/story/2011/05/01/wikileaks-canada-leaders.html
Chemical companies, Big Tobacco and the toxic products in your home (chicagogtribune.com)
http://media.apps.chicagotribune.com/flames/index.html
Videographer Who Took Aim at NPR Gets IRS Approval for New Charity (The Chronicle of Philanthropy)
http://philanthropy.com/article/Videographer-Who-Took-Aim-at/127637/
A key witness’ changing stories (chicagogtribune.com)
http://media.apps.chicagotribune.com/flames/facts-vs-testimony.html
Big pension payouts set in motion years ago (chicagotribune.com)
http://media.apps.chicagotribune.com/pensions/document_narrative.html
Colorado bill tracker
http://tekhne.co/colorado-bill-tracker/
Interactive: Inside The Health Care Ruling (National Public Radio)
How Nonprofits Spend Millions on Elections and Call it Public Welfare (ProPublica)
Legal Experts Decode the Supreme Court’s Obamacare Ruling (The Daily Beast)
Ex-Tyco CEO says “CEO-type bubble” made him feel entitled to steal millions (njcom)
http://www.nj.com/business/index.ssf/2012/04/ex-tyco_ceo_says_ceo-type_bubb.html
Read selected e-mails from Toronto Mayor Rob Ford’s communication team (The Globe and Mail)
http://www.theglobeandmail.com/news/toronto/article4423207.ece
Search the Afghan detainee documents (cbcnews)
http://www.cbc.ca/news/politics/story/2011/06/22/pol-afghan-detainee-docs-embed.html
The Sarah Palin emails (The Guardian)
http://www.guardian.co.uk/world/sarah-palin-emails
Read the Afghan detainee files and flag important passages (The Globe and Mail)
http://media.apps.chicagotribune.com/flames/facts-vs-testimony.html
The Education of Dasmine Cathey (Chronicle.com)
http://chronicle.com/article/The-Education-of-Dasmine-Cathey/132065/
Safety Flaws Found At Western State Hospital (KUOW News)
http://www.kuow.org/program.php?id=27190
Some of Christie’s biggest bills match model legislation from D.C. group called ALEC (nj.com)
http://www.nj.com/news/index.ssf/2012/04/alec_model_bills_used_in_nj_la.html
EXCLUSIVE: Detective is NYPD’s most-sued cop, with 28 lawsuits filed against him since 2006 (SEE INTERACTIVE GRAPHIC) Daily News
THE ECONOMY(Top)
The Bank of Canada
http://www.bankofcanada.ca/rates/exchange/
Bureau of Economic Analysis (U.S. Department of Commerce)
Canadian Centre for Policy Alternatives
https://www.policyalternatives.ca/
The Conference Board of Canada
http://www.conferenceboard.ca/
The Canadian Chamber of Commerce
C.D. Howe Institute
CPI Inflation Calculator (U.S. Bureau of Labor Statistics)
http://www.bls.gov/data/inflation_calculator.htm
Talking Biz News (Information about business journalism, from the Carolina Business News Initiative)
http://weblogs.jomc.unc.edu/talkingbiznews/
BMO Capital Markets
http://www.bmonesbittburns.com/Economics/
Business Blog (The Guardian)
http://www.guardian.co.uk/business/blog
Faser Institute
https://www.fraserinstitute.org/
Kevin Milligan (Vancouver School of Economics at the University of British Columbia)
https://blogs.ubc.ca/kevinmilligan/about-kevin-milligan/
The Laurier Institution
OECD
OECD Quarterly GDP
https://data.oecd.org/gdp/quarterly-gdp.htm#indicator-chart
RBC Economic Research
http://www.rbc.com/economics/index.html
Statistics Canada
http://www.statcan.gc.ca/start-debut-eng.html
EDUCATION
Statistics Canada (Salaries of full-time teaching staff at Canadian universities and colleges)
http://www.statcan.gc.ca/pub/81-595-m/2009073/tbl-eng.htm
Statistics Canada (Education Statistics Program)
http://www.statcan.gc.ca/edu/edu03_0001-eng.htm
Media Research Methods by Arizona State University
http://itunes.apple.com/WebObjects/MZStore.woa/wa/viewiTunesUCollection?id=387507218
An Open Letter to America’s University Presidents (Knight Foundation)
http://www.knightfoundation.org/press-room/other/open-letter-americas-university-presidents/
Mercer, GPB and Telegraph form novel partnership
http://www.macon.com/2011/12/15/1824961/mercer-gpb-and-telegraph-form.html#storylink=misearch
ECONOMISTS(Top)
Tammy Schirle (Associate Professor of Economics at Wilfrid Laurier University)
Lindsay Tedds (Associate Professor in the School of Public Administration at the University of Victoria)
Mikal Skuterud (Associate Professor in the Economics Department at the University of Waterloo)
http://arts.uwaterloo.ca/~skuterud/Mikal_Skuterud/Welcome.html
The School of Public Police (University of Calgary)
http://www.policyschool.ucalgary.ca/
Kevin Milligan
http://blogs.ubc.ca/kevinmilligan/2017/09/10/taxation-of-private-corporations-an-explainer-compendium/
ELECTIONS(Top)
Elections Canada: Contribution to all political entities, as filed
http://open.canada.ca/data/en/dataset/6495ea57-3824-48f0-a2b2-88477122a286
Elections Canada: Contribution to all political entities, as reviewed by Elections Canada
http://open.canada.ca/data/en/dataset/ef1e3528-b570-4a42-92ef-18a9749af8f2
VotingCounts.ca
http://www.votingcounts.ca/announcing-votingcountsca
Elections Canada: Electoral Districts: Maps Corner
http://www.elections.ca/content.asp?section=cir&dir=maps&document=index&lang=e&textonly=false#canada
Women Candidates in General Elections (1921 to Date)
http://www2.parl.gc.ca/Parlinfo/compilations/parliament/WomenRepresentation.aspx
History of Federal Ridings since 1867
http://www2.parl.gc.ca/Sites/LOP/HFER/HFER.asp
Pundits’ Guide to Canadian Federal Elections
http://punditsguide.ca/index.php
Alberta
http://efpublic.elections.ab.ca/
Political donations in Alberta – 2004 to 2010 (Edmonton Journal)
http://www.edmontonjournal.com/news/donations/database.html
http://www2.canada.com/edmontonjournal/news/story.html?id=a4ddf170-bd63-4ff0-b7d9-9ae55199e92c&p=2
http://www.edmontonjournal.com/news/donations/top_donors.html
Manitoba
http://www.elections.mb.ca/main/home_1.htm
Elections Ontario
https://www3.elections.on.ca/internetapp/efsearch.aspx?lang=en
Quebec political contributions
Nova Scotia
http://electionsnovascotia.ns.ca/politicalcontributions.asp
Nova Scotia (electorial district boundaries)
http://electionsnovascotia.ca/geoginfo.asp
Political Contributions Regime Annual Report (Nova Scotia)
http://contrarian.ca/wp-content/uploads/CEO/NS%20Political%20Donations%202010-open%20format.pdf
ENVIRONMENT(Top)
Canada’s Greenhouse Gas Inventory ( Environment Canada )
http://www.ec.gc.ca/pdb/ghg/onlinedata/DataAndReports_e.cfm
Canadian Environmental Assessment Registry
http://www.ceaa-acee.gc.ca/050/index_e.cfm
Canadian Environmental Protection Act and Fisheries Act (prosecutions)
http://www.ec.gc.ca/ele-ale/prosecutions/prosecutions_e.asp
DeSmog Canada
Federal Contaminated Sites Inventory
http://www.tbs-sct.gc.ca/fcsi-rscf/home-accueil.aspx?Language=EN&sid=wu825155318360
Federal Contaminated Sites Inventory (Find Sites by Classification)
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx
Future Asset Restoration Liability (Treasury Board)
http://www.tbs-sct.gc.ca/pol/doc-eng.aspx?section=text&id=20885
Managing Contaminated Sites (Environment Canada)
http://www.ec.gc.ca/pollution/default.asp?lang=En&n=D0F5D8DC-1
Parks Canada orders tests on Rideau Canal after contaminants found
http://www.cbc.ca/news/politics/rideau-canal-toxins-parks-fish-mckenna-industrial-waste-1.4056815
Who to Call in an Emergency
http://www.ec.gc.ca/ee-ue/default.asp?lang=En&n=EED2E58C-
Table of Inactive Lighthouses Declared Surplus (Fisheries and Oceans Canada)
http://www.dfo-mpo.gc.ca/media/infocus-alaune/2010/02/lighthouse-phare-inactive-eng.htm
Table of Active Lighthouses Declared Surplus (Fisheries and Oceans Canada)
http://www.dfo-mpo.gc.ca/media/infocus-alaune/2010/02/lighthouse-phare-active-eng.htm
Northern Contaminated Sites Program (Aboriginal Affairs and Northern Development Canada
http://www.ainc-inac.gc.ca/eng/1100100035301
Contaminated Site Registry (PEI)
http://www.gov.pe.ca/Contaminated_sites/
Environmental Communication Options’ Media Releases
http://huffstrategy.com/MediaManager/all_releases.html
U.S. Environmental Protection Agency (Exposure Research – databases)
http://www.epa.gov/nerl/topics/databases.html
Keystone XL Pipeline stories (The New York Times)
Imperial Oil’s role in museum’s energy exhibit questioned: Foundation contributed $600,000 over 6 years to exhibit (CBC News)
DesmogCanada
International Energy Agency
ETHNIC NEWSPAPERS(Top)
The Link (Leading Indo-Canadian Newspaper)
EVALUATING WEB PAGES(Top)
We will place a lot of emphasis on ensuring that the website you use when researching a story is trustworthy. In order to determine credibility, it’s necessary to have a checklist of key criteria that the site must meet. Here are some sites that will help reinforce and add to what you’ve already learned: http://www.library.ubc.ca/home/evaluating/;
http://www.lib.vt.edu/help/instruct/evaluate/evalbiblio.html;
http://www.virtualsalt.com/evalu8it.htm;
http://www.library.cornell.edu/olinuris/ref/webcrit.html;
http://members.optusnet.com.au/~slamble/links.htm#VERIFYING%20ONLINE%20INFORMATION.
What also helps is to know who is behind the Web page in question. The following links will help you determine who set up the commercial site that has attracted your interest: http://whois.cira.ca/public (For Canadian websites); http://www.alexa.com/ (deals with domains from all countries, and analyzes the website’s reach; that is, the number and identity of visitors to the page) http://www.domaintools.com/ and http://www.geektools.com/ andhttp://www.betterwhois.com/ and http://www.register.com/ , http://www.networksolutions.com/en US/whois/index.jhtml, http://www.domaintools.com/ and http://www.norid.no/domenenavnbaser/domreg.html and http://www.nominet.org.uk/ for “UK” domain names. When plugging in the website you’re researching, be sure to exclude the “www.” The first site on the list, “geektools,” contains the easiest interface of the three. The choice is yours.
ReverseWhoIs
http://viewdns.info/reversewhois/
FEDERAL GOVERNMENT(Top)
Canada News Centre
Open Data Pilot Project
http://www.data.gc.ca/default.asp?lang=En
http://news.gc.ca/web/article-eng.do?nid=638049
Public Opinion Research Reports
http://www.porr-rrop.gc.ca/index-e.html
Public Opinion Research Reports
http://amicus.collectionscanada.ca/porr-rrop-bin/Main/BasicSearch?coll=28&l=0&v=1
Visible Government (government transparency in Canada)
Government-Wide Reporting (Treasury Board’s listing of proactive disclosures by department)
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
Openparliament.ca
http://openparliament.ca/about/
Government of Canada official website
http://canada.gc.ca/main_e.html
All Websites Administered by the Government of Canada
http://www.google.com/cse/home?cx=001420363236126974246:mu2eiq-tbzw&hl=en
Years of Service in Parliament
Governor in Council Appointments
http://www.appointments-nominations.gc.ca/index.asp?lang=eng&Page=index
Orders in Council Appointments
http://www.pco-bcp.gc.ca/oic-ddc.asp?lang=eng&Page=secretariats
Orders in Council Glossary
http://www.pco-bcp.gc.ca/index.asp?lang=eng&page=secretariats&sub=oic-ddc&doc=gloss-eng.htm
Federal government departments
http://canada.gc.ca/depts/major/depind-eng.html
Federal government search engines
How Did They Vote
Canada Gazette
Federal government selected disclosure of travel and hospitality expenses and contracts
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index_e.asp
Federal government phone book
http://sage-geds.tpsgc-pwgsc.gc.ca/cgi-bin/direct500/eng/TE?FN=index.htm
Mandate letters, please click here to open in a new browser
Polling (click on the “continue to the document” link to get to the departmental polls)
http://epe.lac-bac.gc.ca/100/200/301/pwgsc-tpsgc/por-ef/index.html
Public Opinion Research Reports
http://www.porr-rrop.gc.ca/index-e.html
Federal bugets
http://www.fin.gc.ca/access/budinfo-eng.asp
Reviews, Audits and Evaluations
http://www.tbs-sct.gc.ca/rma/database/aeve_e.asp
http://www.tbs-sct.gc.ca/rpp/2009-2010/info/ia-vi-eng.asp
Tools and Resources for Parliamentarians (Treasury Board gate to reports including Departmental Quarterly Financial Reports)
http://www.tbs-sct.gc.ca/tbs-sct/audience-auditoire/parliamentarian-parlementaire-eng.asp
The Fiscal Monitor 2008 (the Finance department)
http://www.fin.gc.ca/pub/fm-rf-index-eng.asp
Auditor General of Canada
http://www.oag-bvg.gc.ca/internet/English/admin_e_41.html
Proactive Disclosure
http://www.tbs-sct.gc.ca/pd-dp/index_e.asp
http://github.com/nurey/disclosed/tree/2b91216860fdc85b1231a28aa05a907c43f5b9be/data
Travel and Hospitality Expenses Reports (Government of Canada: Privy Council Office)
http://www.pco-bcp.gc.ca/di/category_list.asp?id=1&Language=E
Public Office Holders Search (Office of the Ethics Commissioner)
http://www.parl.gc.ca/oec/PublicSearch/PublicSearch.aspx
Plans and Priorities / Performance Reports
http://www.tbs-sct.gc.ca/est-pre/estime.asp#OSD
Public Accounts (Government-wide)
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
FEDERAL POLITICS(Top)
Members’ Expenditures Report
http://www.parl.gc.ca/PublicDisclosure/MemberExpenditures.aspx?Id=MER2013FY&Language=E
The Federal Cabinet
http://www.pm.gc.ca/eng/cabinet.asp
MEMBERS OF THE CABINET, PARLIAMENTARY SECRETARIES AND OPPOSITION PARTY CRITICS
http://www.lop.parl.gc.ca/ParlInfo/Compilations/HouseOfCommons/MinistryMembers.aspx
Minotaur (website monitors the federal government telephone directory for changes in staff listings in ministerial offices)
http://lobbywatcher.ca/minotaur/minotaur.php
Committees
http://www.parl.gc.ca/common/committee.asp?Language=E&Parl=38&Ses=1
Conservative Research Bureau
NDP Research Bureau
Members of Parliament
http://webinfo.parl.gc.ca/membersofparliament/MainMPsCompleteList.aspx?TimePeriod=Current&Language=E
Liberal critics
NDP critics
http://www.ndp.ca/shadow-cabinet
Parliamentary Secretaries
http://pm.gc.ca/eng/feature.asp?pageId=39&featureId=8
Cabinet ministers
http://pm.gc.ca/eng/cabinet.asp?featureId=8&pageId=38
Guide to Canadian Ministries Since Confederation
http://www.pco-bcp.gc.ca/mgm/dtail.asp?lang=eng&mbtpid=1&mstyid=32
Senators
http://www.parl.gc.ca/common/senmemb/senate/isenator.asp?Language=E
Parliament
http://www.parl.gc.ca/common/index.asp?Language=E&Parl=37&Ses=2
Parliamentary publications
http://www.parl.gc.ca/About/House/compendium/web-content/c_g_parliamentarypublications-e.htm#3
openparliament.ca
House Government Bills ( Parliament )
http://www2.parl.gc.ca/HouseBills/BillsGovernment.aspx?Language=E&Mode=1&Parl=40&Ses=3
Parliamentary Committees
http://www2.parl.gc.ca/CommitteeBusiness/CommitteeList.aspx?Language=E&Mode=1&Parl=40&Ses=3
House of Commons Procedure and Practice
Order paper questions
http://www.parl.gc.ca/HousePublications/Publication.aspx?Pub=status&Language=E&Mode=1&Parl=42&Ses=1&File=12
Written Questions (Senate)
http://www.parl.gc.ca/Content/SEN/Chamber/411/OrderPaper/ord-e.htm#QUESTIONS
House of Commons List of Reports and Returns brings (this is a generic description of documents that ministers are obliged to table in the House)
http://www.parl.gc.ca/40/2/parlbus/chambus/house/reports/02-toc-e.htm
Debates (Hansard)
Hansard
Current and Emerging Issues (Library of Parliament)
http://www.parl.gc.ca/Content/LOP/ResearchPublications/cei-foreword-e.htm
History of electoral ridings
Women in the House of Commons
Women in the Senate
Women in Parliament (Parliamentary Information and Research Service, Library of Parliament)
http://www2.parl.gc.ca/content/lop/researchpublications/prb0562-e.htm
Women candidates in federal elections since 1921
http://www2.parl.gc.ca/Sites/LOP/HFER/hfer.asp?Language=E&Search=WomenElection
PoliTwitter (Track what federal politicians are saying on social media)
Votes in the House of Commons
http://www.parl.gc.ca/housechamberbusiness/ChamberVoteList.aspx?Language=E
FEDERAL PUBLIC SERVICE(Top)
Canada School of Public Service
http://www.csps-efpc.gc.ca/index-eng.asp
Chief Human Resources Officer
http://www.tbs-sct.gc.ca/chro-dprh/index-eng.asp
Public Servants Disclosure Protection Tribunal
http://www.psdpt-tpfd.gc.ca/Information/WrongdoingsReprisals-eng.html
FAIR ( Federal Accountability Initiative for Reform)
Public service absenteeism jumps by 40%; ‘Alarming’ spike over past decade draws ire, sympathy from experts
(The Ottawa Citizen)
Please read the story by clicking here
Federal workers lead pack in rising absenteeism (The Ottawa Citizen)
Please read the story by clicking here.
Ethics boss found morale mess in office (The Ottawa Citizen)
Pleae read the story by clicking here.
Minotaur (website monitors the federal government telephone directory for changes in staff listings in ministerial offices)
http://lobbywatcher.ca/minotaur/minotaur.php
FEDERAL SPENDING(Top)
Parliamentary Budget Officer federal spending watch
http://pbo-dpb.gc.ca/en/imd/index/#view_departments
Parliamentary Budget Officer’s Integrated Monitoring Database that tracks public money
http://www.pbo-dpb.gc.ca/en/imd/index/#search-department_outcomes
Transfer payments to provinces ( Department of finance)
http://www.fin.gc.ca/fedprov/mtp-eng.asp#Ontario
FOOD SAFETY(Top)
Ottawa restaurant inspections
Food Recall Report (Downloadable food recalls from the Canadian Food Inspection Agency)
http://active.inspection.gc.ca/eng/corp/recarapp_dbe.asp
Health Safety Watch (real-time health and safety information)
http://www.healthandsafetywatch.com/Dashboard.aspx?AspxAutoDetectCookieSupport=1
Food Recalls and Allergy Alerts
http://www.inspection.gc.ca/english/corpaffr/recarapp/recaltoce.shtml
Audits, Reviews and Evaluations – Executive Summaries (The Canadian Food Inspection Agency)
http://www.inspection.gc.ca/english/agen/eval/evale.shtml
Audio Clips for Food Recalls and Allergy Alerts (The Canadian Food Inspection Agency)
http://www.inspection.gc.ca/english/corpaffr/relations/audio/recarappaude.shtml
Food Safety Assessment Reports (Health Canada)
http://www.hc-sc.gc.ca/fn-an/securit/eval/reports-rapports/index-eng.php
Reports on the Canadian Food Inspection Agency (By the Auditor General of Canada)
http://www.oag-bvg.gc.ca/internet/English/parl_lpf_e_1228.html
CBC-Toronto Star food-safety investigation
http://www.cbc.ca/consumer/story/2008/09/23/f-cfia.html
http://www.cbc.ca/consumer/story/2008/10/05/listeria-inspections.html
http://www.cbc.ca/consumer/story/2008/10/09/listeria-tests.html
http://www.cbc.ca/health/story/2008/10/09/mccain.html
http://www.cbc.ca/canada/story/2008/10/21/lawsuit-mapleleaf.html
http://www.cbc.ca/consumer/story/2008/10/27/listeria-nursinghome.html?ref=rss
http://www.cbc.ca/canada/story/2008/11/06/listeria-regulations.html?ref=rss
http://www.cbc.ca/consumer/story/2008/11/07/mccain-memos.html
http://www.cbc.ca/consumer/story/2008/12/19/listeria-cfia.html
http://www.cbc.ca/canada/story/2009/01/20/listeriosis-investigator.html?ref=rss
http://www.cbc.ca/canada/story/2009/01/23/listeria-investigation.html?ref=rss
http://www.cbc.ca/canada/story/2009/02/05/poultryvets-cfia.html?ref=rss
http://www.cbc.ca/canada/story/2009/03/25/listeria-cfia.html
http://www.cbc.ca/consumer/story/2009/04/21/listeriosis-probe-cfia021.html?ref=rss
http://www.cbc.ca/canada/story/2009/04/23/listeriosis-probe.html?ref=rss
http://www.cbc.ca/canada/story/2009/04/30/listeria-cfia-reports043009.html?ref=rss
http://www.cbc.ca/canada/story/2009/06/10/listeria-inspectors-maple-leaf.html?ref=rss
Food safety at risk with budget cuts expected, union says (CBC News)
http://www.cbc.ca/news/politics/story/2012/01/16/pol-food-safety-inspection-funding.html
Federal food safety surveillance program stalled (CBC News)
http://www.cbc.ca/news/politics/story/2012/02/03/pol-mckie-thehouse-disease-centres.html
Listeriosis victims receive reduced compensation (CBC News)
http://www.cbc.ca/news/politics/story/2012/02/04/pol-listeriosis-victims-receive-compensation.html
XL Foods warned 6 times over lapses before E. coli outbreak (CBC News)
Correction Action Requests issued at Alberta plant for sanitation, contamination
http://www.cbc.ca/news/politics/story/2013/01/08/pol-cfia-xl-foods-atip-corrective-action.html
U.S. worries about Canadian meat flagged in memo (CBC News)
Coalition wants plug pulled on meat pre-clearance pilot project in wake of XL Foods recall
BC investigation into faulty juice boxes
http://www.cbc.ca/consumer/story/2008/11/19/iunit-drinkboxes.html
Nova Scotia Food Establishment Inspection Reports
http://www.gov.ns.ca/agri/foodsafety/reports/Request.aspx
Newfoundland &Labrador Inspection Reports
http://www.servicenl.gov.nl.ca/inspections/index.html
The National Agricultural Library (the U.S. Department of Agriculture)
Gateway to Government Food Safety Information (U.S.)
http://www.foodsafety.gov/~fsg/fsgprobs.html
The Food Safety and Inspection Service (the public health agency in the U.S. Department of Agriculture)
Foreign Audit Reports (United States Department of Agriculture – Food Safety Inspection Service)
Search for Peanut Butter Product Recalls (The U.S. Food and Drug Administration)
http://www.accessdata.fda.gov/scripts/peanutbutterrecall/index.cfm
Foreign Audit Reports (the USDA’s Food Safety and Inspection Service)
http://www.fsis.usda.gov/regulations_&_policies/Foreign_Audit_Reports/index.asp
http://www.fsis.usda.gov/regulations_&_policies/Foreign_Audit_Reports_Past/index.asp
United States Departrment of Agriculture Food Safety Inspection Service
http://www.fsis.usda.gov/FSIS_Recalls/Open_Federal_Cases/index.asp
Canadian food companies cerfitifed to export to the United States
Food safety reports from Thomas Hargrove of the Scripps Howard Service
ftp://shnsclients.scripps.com/data/FatalFood/
Centers for Disease Control and Prevention_ cached Outbreak Surveillance Data (Department of Health and Human Services)
http://74.125.95.132/search?q=cache:http://www.cdc.gov/foodborneoutbreaks/outbreak_data.htm
The Traceability Institute
http://www.traceability-institute.com/
Eat Safe ( the city of Ottawa’s website for restaurant inspections)
http://www.ottawa.ca/cgi-bin/search/inspections/q.pl?ss=home_en&qt=fsi_en
Food Safety News
http://www.foodsafetynews.com/
GlobalMeatnews.com
http://www.globalmeatnews.com/
BarfBlog (safe food from farm to fork)
http://barfblog.foodsafety.ksu.edu/barfblog
News for Shoppers
http://www.newsforshoppers.com/
People’s Food Policy Project
http://www.peoplesfoodpolicy.ca/
Caffeine Content of Drinks (A complete guide to caffeine)
http://www.energyfiend.com/the-caffeine-database
Bites and barflog (safe food from farm to fork)
dicentra
The Poultry Site
http://www.thepoultrysite.com/
PerishableNews.com
http://www.perishablenews.com/
fishnews.com
Current World Production, Markets, and Trade Reports (United States Department of Agriculture)
http://www.fas.usda.gov/report.asp
FOREIGN AFFAIRS(Top)
Canada’s International Gateway
http://www.canadainternational.gc.ca/ci-ci/index.aspx?lang=eng
Canada’s bilateral relations with countries around the world (Canada’s International Gateway)
http://www.international.gc.ca/cip-pic/geo.aspx?view=d
FUSION TABLES(Top)
Google Fusion Tables
Googe Fusion Tables discussion group
https://groups.google.com/forum/#!topic/fusion-tables-users-group/4SVxAew5P78
Google Fusion Table (shape file to KML conversion)
Google fusion tables beta (data sets you can use)
https://www.google.com/fusiontables/search
FusionTablesLayer Builder
Google Sites (allows you to see what your Fusion Table maps or charts look like before publishing them)
http://www.google.com/sites/help/intl/en/overview.html
ColorBrewer (for doing fancier colour schemes in Fusion Tables)
Fusion Table Icon Markers
https://www.google.com/fusiontables/data?docid=1BDnT5U1Spyaes0Nj3DXciJKa_tuu7CzNRXWdVA#map:id=3
A map to help voters find their polling places using Fusion Tables as a data source (Google fusion tables)
Shape to Fusion ( A website that allow users to import shape files into fusion tables)
GOVERNMENT SPENDING(Top)
Advertising Annual Reports (Public Works and Government Services Canada)
http://www.tpsgc-pwgsc.gc.ca/pub-adv/annuel-annual-eng.html
Budget 2009: Canada’s Economic Action Plan
http://www.fin.gc.ca/n08/09-011-eng.asp
http://www.actionplan.gc.ca/eng/index.asp
Transactions under the Troubled Asset Relief Program (TARP)
http://subsidyscope.com/projects/bailout/tarp/
Many Eyes (a website that helps visualize U.S. government spending)
http://manyeyes.alphaworks.ibm.com/manyeyes/
Economic Stimulus: Transportation Infrastructure Projects by County (Associated Press)
http://hosted.ap.org/dynamic/files/specials/interactives/wdc/stimulus_counties/index.html?SITE=NYPLA
Canada’s Economic Action Plan
http://www.actionplan.gc.ca/eng/index.asp
Economic Stimulus: Distressed bridges often overlooked for repairs ( American Press)
http://hosted.ap.org/specials/interactives/wdc/stimulus_bridges/index.html?SITE=AP
ProPublica’s FAQ for Recovery.gov
http://www.propublica.org/ion/stimulus/item/propublicas-faq-for-recovery.gov-1109
Recovery.org (the official U.S. government website that tracks stimulus spending)
http://www.recovery.gov/Pages/home.aspx
HEALTH(Top)
Chronic Disease Infobase (the Public Health Agency of Canada)
http://204.187.39.30/surveillance/Index.aspx?L=eng
Canadian Patient Safety Institute
http://www.patientsafetyinstitute.ca/English/Pages/default.aspx
FluWatch (The Public Health Agency of Canada’s national surveillance system that monitors the spread of flu and flu-like illnesses)
http://www.phac-aspc.gc.ca/fluwatch/index-eng.php
Deaths Associated with H1N1 flu virus in Canada
http://www.phac-aspc.gc.ca/alert-alerte/h1n1/surveillance-eng.php
Canadian Institute for Health Information (statistics)
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=reqdata_e
Statistics Canada (deaths from infectious diseases)
Statistics Canada (abortion rates)
http://www.statcan.gc.ca/pub/82-223-x/2008000/5202136-eng.htm
http://www.statcan.gc.ca/pub/82-223-x/2008000/5202008-eng.htm
http://www.statcan.gc.ca/pub/82-223-x/2008000/5202017-eng.htm
Food recalls (Health Canada and the Public Health Agency of Canada)
http://www.healthycanadians.gc.ca/pr-rp/index_e.php
Food recall archives (The Canadian Food Inspection Agency)
http://www.inspection.gc.ca/english/corpaffr/recarapp/recal2e.shtml
Medication Guides ( the U.S. Food and Drug Administration )
http://www.fda.gov/cder/Offices/ODS/medication_guides.htm
MedlinePlus
http://www.nlm.nih.gov/medlineplus/druginformation.html
E-CPS (Canadian Pharmacists Association)
https://www.e-therapeutics.ca/wps/portal/!ut/p/.scr/Login
Psychotropics
http://www.psychotropics.dk/monographies/index.asp?Catalogtype=A
Pharmalot
PharmaWatch Canaada
http://pharmawatchcanada.wordpress.com/
Consumer Reports Best Buy Drugs
http://www.crbestbuydrugs.org/
Consumer Reports Health.org
http://www.consumerreports.org/health/home.htm
Therapeutic Goods Administration (Australian Adverse Drug Reactions Bulletin)
http://www.tga.gov.au/adr/aadrb.htm
Science Daily
Canadian Centre for Occupational Health and Safety
Association of Workers’ Compensation Boards of Canada
http://www.awcbc.org/en/index.asp
Health Canada
http://www.hc-sc.gc.ca/index_e.html
Health Canada (Dear Health Care Professional Letters and public advisories)
http://www.hc-sc.gc.ca/ahc-asc/media/advisories-avis/_2007/index_e.html
Health Canada, drug and medical device recalls
http://www.hc-sc.gc.ca/dhp-mps/compli-conform/recall-retrait/_list/index-eng.php
Health Canada Advisories, Warnings and Recalls by Subject
http://www.hc-sc.gc.ca/ahc-asc/media/advisories-avis/alpha_e.html
Health Canada, Consumer Product Safety Recalls
http://209.217.71.106/PR/home-accueil-e.jsp
Index of Published Canadian Adverse Reaction Newsletters
http://www.hc-sc.gc.ca/dhp-mps/medeff/bulletin/carn-bcei_index_e.html
Health Canada’s Adverse Drug Reaction Database
http://webprod3.hc-sc.gc.ca/arquery-rechercheei/index-eng.jsp
Health Canada list of expert advisory committees
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/activit/sci-consult/index_e.html
Notice of compliance ( drugs Health Canada has approved )\
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/notices-avis/index_e.html
http://webprod5.hc-sc.gc.ca/noc-ac/index-eng.jsp
http://data.gc.ca/data/en/dataset/9cbaef00-b52c-4a70-9fed-d9aa8263ab74
http://data.gc.ca/data/en/dataset/52bb749a-4006-4253-a4a5-63e51d2f880f
http://data.gc.ca/data/en/dataset/fa5ad2aa-ab59-4421-8491-4c004d94d0bc
Drug Products Database ( all of the drugs Health Canada has approved for marketing)
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/databasdon/dpd_bdpp_data_extract_e.html
Food and Drug Administration advisory committees
http://www.fda.gov/ohrms/dockets/ac/acwhatsnew.htm
FDA advisory committees (search)
http://www.fda.gov/ohrms/dockets/default.htm
Vaccine Adverse Event Reporting System (The U.S. Food and Drug Administration)
http://vaers.hhs.gov/data/data/
BlackBoxRX.com
http://blackboxrx.com/index.php
Controversial drug marketing
http://www.cbc.ca/disclosure/archives/0103_pharm/resources.html
Recently approved medical devices ( FDA )
http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfTopic/MDA/mda-list.cfm?list=1
HealthImaging.com
http://www.healthimaging.com/index.php?option=com_articles&division=hiit
Health Space (contains online inspection information for provinces such as B.C.)
http://www.healthspace.ca/Websites/HealthSpace/Website_CA.nsf/index.html
Patient Safety (Ontario Ministry of Health and Long Term Care)
http://www.health.gov.on.ca/patient_safety/index.html
Health Inspection Orders (Alberta Health Services)
RateMDs.com
Patient Drug News
http://www.patientdrugnews.com/about-patient-drug-news/
Public Health Inspections (city of Ottawa)
http://www.ottawapublichealth.ca/en/public-health-services/public-health-inspections.aspx#Food-Premises
HEALTH (PROVINCIAL)(TOP)
Nova Scotia Prescription Monitoring Program
HEALTH (INTERNATIONAL)(TOP)
International Society For Infectious Diseases
Centers for Disease Control and Prevention
Medicaid: Pharmacy Pricing (All National Average Drug Acquisition Cost data)
https://www.medicaid.gov/medicaid/prescription-drugs/pharmacy-pricing/index.html
http://media.cq.com/pub/table/index.php?id=326
HEALTH POLICY (Top)
CONSULTATION ON LEGISLATIVE OPTIONS FOR ASSISTED DYING
Healthy Debate (Healthydebate.ca is led by a core team of physicians, policy advisors and researchers based at the Li Ka Shing Knowledge Institute of St. Michael’s Hospital in Toronto)
HealthNewsReview.org
http://www.healthnewsreview.org/
EvidenceNetwork.ca (Non-partisan health policy experts and evidence)
http://www.evidencenetwork.ca/
Cutting Edge Information
http://www.cuttingedgeinfo.com/
HOUSING(Top)
Housing Again (a site dedicated to putting affordable housing back on the public agenda)
http://housingagain.web.ca/index.html
Canada Mortgage and Housing Corporation, average rents for areas with a population of 10,000 and over (Statistics Canada)
Forecasts and Analysis (Canada Mortgage and Housing Corporation)
http://www.cmhc-schl.gc.ca/en/hoficlincl/homain/foan/index.cfm
Housing Market Information (Canada Mortgage and Housing Corporation)
http://www.cmhc.ca/housingmarketinformation/
National Average Price Map: Canadian Real Estate Association
http://www.crea.ca/housing-market-stats/national-average-price-map/
Rental Report
http://rentalreport.ca/
IMMIGRATION(Top)
Canadian Immigration Statistics (Canada Immigrant Job Issues)
http://www.canadaimmigrants.com/statistics.asp
Canadian Immigration Stats (for Canada and all regions from the 2001 and 2006 censuses)
Recent immigrants in metropolitan areas (Citizenship and Immigration Canada)
http://www.cic.gc.ca/english/resources/statistics/facts2008/index.asp
2006-09 Refugee Claim Data & IRB Member Grant Rates (Compiled by Sean Rehaag, Assistant Professor Osgoode Hall Law School York University)
http://www.ccrweb.ca/documents/rehaagdatamarch10.htm
2010 Refugee Claim Data and IRB Member Grant Rates
http://ccrweb.ca/en/2010-refugee-claim-data
2011 Refugee Claim Data and IRB Member Grant Rates
http://ccrweb.ca/en/2011-refugee-claim-data
2012 Refugee Claim Data and IRB Member Grant Rates
http://ccrweb.ca/en/2012-refugee-claim-data
2013 Refugee Claim Data and IRB Member Grant Rates
https://ccrweb.ca/en/2013-refugee-claim-data
2014 Refugee Claim Data and IRB Member Recognition Rates
http://ccrweb.ca/en/2014-refugee-claim-data
2015 Refugee Claim Data and IRB Member Recognition Rates
http://ccrweb.ca/en/2015-refugee-claim-data
Quarterly Administrative Data Release
http://www.cic.gc.ca/english/resources/statistics/data-release/2009-Q3/index.asp
Human Rights Research and Education Centre
http://www.cdp-hrc.uottawa.ca/eng/project/refugee-forum/index.php
Responses to Information Requests
http://www.irb-cisr.gc.ca/Eng/ResRec/RirRdi/Pages/index.aspx
Revoked immigration consultants (The Canadian Society of Immigration Consultants)
https://www.csic-scci.ca/find/revoked.html
Centre for Immigration Policy Reform
http://immigrationreform.ca/english/view.asp?x=1
Innovative Tools (Top)
ABBYY FineReader 14
https://www.abbyy.com/en-ca/finereader/
TurboScan: quickly scan multipage documents into high-quality PDFs
https://itunes.apple.com/ca/app/turboscan-quickly-scan-multipage/id342548956?mt=8
Convert JSON to CSV
https://konklone.io/json/
Reporters’ Lab Reviews
timeanddata.com
Freeware Hex Editor XVI32
http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm
DocumentCloud
http://blog.documentcloud.org/blog/2011/06/new-home-at-ire/
The Overview Project
https://www.overviewproject.org/
Tabula
http://tabula.technology/
Mikogo (Free web conferencing and desktop sharing software)
http://www.mikogo.com/product/features/
Join.me.com
GoToMeeting
https://www1.gotomeeting.com/join/894058849
TeamViewer
http://www.teamviewer.com/en/index.aspx
Docudesk (converts pdfs to spreadsheets for PCs and Macs)
http://www.docudesk.com/index.shtml
ScraperWiki
Free PDF Text Reader 1.1
Chapter 3: Turning PDFs to Text (ProPublica)
http://www.propublica.org/nerds/item/turning-pdfs-to-text-doc-dollars-guide
Nitro PDF Professional
Guaranteed PDF Decrypter
PDFUnlock
PDFPirate
ABBYY FineReader
Awsome Screenshot (Capture the whole page or any portion, annotate it with rectangles, circles, arrows, lines and text…..)
https://chrome.google.com/extensions/detail/alelhddbbhepgpmgidjdcjakblofbmce?hl=en
Xpdf (An open source viewer for Portable Document Format (PDF) files)
http://www.foolabs.com/xpdf/home.html
PDFill PDF Editor 5.0
PDFCreator
http://sourceforge.net/projects/pdfcreator/
PDFtoExcel (online converter)
http://www.pdftoexcelonline.com/default.aspx
Zamzar (Free online file conversion)
Cometdocs( Free online file conversion)
Able2Extract (Standalone conversion to Excel, Word etc. Probably the best overall choice. Reliable and accurate results)
http://www.investintech.com/prod_a2e.htm
Cogniview
Irfanview (A Windows graphic viewer)
Yousendit
Googlenewstime
http://newstimeline.googlelabs.com/
Beta Office 1010
http://officebeta.microsoft.com/en-us
Docsplit (a command-line utility and Ruby library for splitting apart documents into their component parts)
http://documentcloud.github.com/docsplit/
Chrome Extensions
http://www.chromeextensions.org/music-videos-photos/youtube-downloader/
Plug in for Firefox MP3 converter
https://addons.mozilla.org/en-US/firefox/addon/youtube-to-mp3/
YouTube Video Downloader 1.5 (can download videos in FLVand MP4 formats)
http://www.youtubedownloaderhd.com/download.html
Audio Hijack Pro (audio recorder for Macs)
http://www.rogueamoeba.com/audiohijackpro/
NodeXL for Social Network Analysis
http://www.peteraldhous.com/CAR/Aldhous_CAR2011_NodeXL.pdf
Googe Motion
http://mail.google.com/mail/help/motion.html
ASAP Utilities (add-ins for Excel)
http://www.asap-utilities.com/
TimelineSetter: Easy Timelines From Spreadsheets, Now Open to All (Propublica)
http://www.propublica.org/nerds/item/timelinesetter-easy-timelines-from-spreadsheets-now-open-to-all
dtSearch (searches files on your desktop)
http://www.dtsearch.com/PLF_desktop_2.html
Online Dictionary (Translation, definition, synonyms, English, French, Spanish, etc)
http://dictionary.reverso.net/
Zoocasa (estimated Canadian home prices)
Regular-Expressions.info
http://www.regular-expressions.info/
Wordhippo.com
http://www.wordhippo.com/what-is/another-word-for/survey.html
Online-Stopwatch
http://www.online-stopwatch.com/
Measuring Worth
http://measuringworth.com/calculators/uscompare/
CAA Distracted Driving Simulator
http://distracteddriving.caa.ca/simulator/environment.php
INTERNET RESEARCH(Top)
ChangeDetecion.com
https://www.changedetection.com/index.html
People Search Pro (Julian Sher)
http://tips.peoplesearchpro.com/
Google News Timeline
http://newstimeline.googlelabs.com/
SearchSystems.net (Search Free Public Records in the United States)
http://publicrecords.searchsystems.net/
Q&A With Storyzy Founder Stan Motte on the Fight Against Fake News
http://mediashift.org/2017/07/qa-storyzy-founder-stan-motte-fight-fake-news/
INTERVIEWING(Top)
TRANSCRIPT | Peter Mansbridge talks with Stephen Harper (CBC News)
http://www.cbc.ca/news/politics/story/2012/01/17/pol-mansbridge-interview-harper-transcript.html
To download Peter Mansbridge’s 2014 year-end interview with Prime Minister, Stephen Harper, please click here.
Stephen Harper’s 2014 year-end interview
Paul McLaughlin: Asking Questions The Art of the Media Interview
INVESTIGATIVE JOURNALISM WEBSITES(Top)
Open Channel
http://openchannel.msnbc.msn.com/
Neimanwatchdog
http://www.niemanwatchdog.org/index.cfm
http://www.niemanwatchdog.org/index.cfm?fuseaction=showcase.welcome
Center for Investigative Reporting to curate investigative reporting on new YouTube channel (Poynter)
Jesse Brown’s Canadaland
InvestigativePost
http://www.investigativepost.org/
Rocky Mountain PBS iNews
Tarbell
http://tarbell.readthedocs.org/en/1.0/
https://github.com/tarbell-project
INVISIBLE WEB(Top)
Resource Shelf
BrightPlanet
Price’s List of Lists
http://www.specialissues.com/lol/
Complete Planet (The Deep Web Directory)
Invisible Web tutorial
http://www.lib.berkeley.edu/TeachingLib/Guides/Internet/InvisibleWeb.html
Search Engine Watch
Infomine
Repositories of Primary Resources ( The University of Idaho)
http://www.uiweb.uidaho.edu/special-collections/Other.Repositories.html
Directory of Open Access Journals (This service covers free, full text, quality controlled scientific and scholarly journals)
WorldCat (Finds items in libraries near you)
Academic Search Engines (JournalismNet)
http://www.peoplesearchpro.com/journalism/search/academic.htm
INTERACTIVE STORIES(Top)
A global guide to the first world war – interactive documentary (The Guardian)
JOURNALISTS’ BLOGS(TOP)
Andrea Woo
Allison Martell
Brittny Goodsell
http://brittnygoodsell.com/home.html
Brad Cabana
http://www.blogger.com/profile/08957343946915171802
Blacklock’s Reporter
David Eaves
David Pugliese Defence Watch
http://blogs.ottawacitizen.com/category/news/defence-watch/
Claudine Brule
http://www.claudinebrule.com/
Glen McGregor
http://blogs.ottawacitizen.com/author/glenmcgregor/
Paul Krugman
http://krugman.blogs.nytimes.com/
Heather Scoffield
http://www.blogscanada.ca/author/heather-scoffield-the-canadian-press/?feedsort=comment_count
Jen Skerritt
http://muckrack.com/jenskerritt
Katelyn Verstraten
Kate Crawford: Thinking about data
Kim Bolan: The Real Scoop ( The Vancouver Sun)
http://blogs.vancouversun.com/category/staff/crime-and-justice/the-real-scoop/
Lysanne Loouter
http://www.lysannelouter.com/
Michelle Minkoff
http://michelleminkoff.com/teaching/
MediaPowerMonitor
http://mediapowermonitor.com/
BloombergView
http://www.bloomberg.com/view/
Canada.com
http://www.canada.com/opinion/blogs/index.html
David Gehring (Google)
Eric Newton (The Nieman Journalism Lab)
http://www.niemanlab.org/author/enewton/
Jay Rosen’s Press Think
http://pressthink.org/2013/02/look-youre-right-okay-but-youre-also-wrong/
Karen Kleiss (The Edmonton Journal)
http://blogs.edmontonjournal.com/author/ablegreporter/
Karl Idsvoog
http://www.whenjournalismfails.com/
Mark Coddington
Meg Wilcox
Nicole S. Cohen
Lisa Johnson (CBC Vancouver)
Lisa Roberts
http://lisaroberts.ca/?page_id=12
Melanie Coulson (The Ottawa Citizen)
Sam Wang (Princeton Election Consortium)
http://election.princeton.edu/
Nate Silver (FiveThirtyEight)
http://fivethirtyeight.blogs.nytimes.com/
SARAH L. RYLEY Investigative & Data Journalist
https://www.sarahryley.com/
Tamsin McMahon
http://www2.macleans.ca/author/tmcmahon/
Tara Carman
http://blogs.vancouversun.com/author/taracarman/
The Media Business (Robert G. Picard)
http://themediabusiness.blogspot.ca/
The Filter Buble (Eli Pariser and Peter Koechley)
http://www.thefilterbubble.com/
Taylor Owen
The Ottawa Citizen
http://www.ottawacitizen.com/opinion/blogs/index.html
The Bulldog (A blog by Ken Gray)
The Huffington Post
http://www.huffingtonpost.com/the-blog/
WSJ blogs
Ben Mook
Lauren Shepard (Newseum)
http://laurenshepherdwritingon.tumblr.com
Alexandra Posadzki
JOURNALISM EDUCATION(Top)
A Blueprint for How to Make J-School Matter (Again)
http://niemanreports.org/articles/a-blueprint-for-how-to-make-j-school-matter-again/
Can new models of public interest journalism survive?https://theconversation.com/can-new-models-of-public-interest-journalism-survive-85604
Carleton University (Office of Institutional Research and Planning
http://oirp.carleton.ca/newsite/
Carleton Library
https://blogs.library.carleton.ca/roller/themadgicalweb/
Columbia Journalism School
http://www.journalism.columbia.edu/home
Tow Center for Digital Journalism (Columbia Journalism School)
Reuters Institute for the Study of Journalism
http://reutersinstitute.politics.ox.ac.uk/
UBC Graduate School of Journalism
Philip Merrill College of Journalism
“Toward 2020” makes the case for better journalism education
http://www.j-source.ca/article/%E2%80%9Ctoward-2020%E2%80%9D-makes-case-better-journalism-education
Toward 2020 : New Directions In Journalism Education
http://digital.library.ryerson.ca/islandora/object/RULA%3A3830
Universities’ media teachings evolve toward entrepreneurial angle
http://ijnet.org/en/blog/universities-media-teachings-evolve-toward-entrepreneurial-angle
JOURNALISM JOBS SITES(TOP)
Code out loud
NewsAppsJobs
https://twitter.com/newsapps_jobs
Google Journalism Fellowship
http://www.google.com/get/journalismfellowship/
JOURNALISM RESEARCH(TOP)
The Coral Project
https://coralproject.net/
Data Journalism Handbook
http://www.datajournalismhandbook.org/1.0/en/
Every J-School Should Teach Data, and Here’s How
http://mediashift.org/2017/08/make-data-part-of-a-basic-journalism-curriculum/
JEFF SONDERMAN
Journalist’s Resource (Harvard Kennedy School, Joan Shorenstein Center)
http://journalistsresource.org/
Newspapers Turning Ideas into Dollars (Pew Research Center’s Project for Excellence in Journalism)
http://www.journalism.org/analysis_report/newspapers_turning_ideas_dollars
Thinking about the Future of Informed Communities and Journalism
Survey Research, Its New Frontiers and Democracy (Pew Research Center)
http://www.pewresearch.org/2012/05/24/survey-research-its-new-frontiers-and-democracy/
Math for Journalists:Help With Numbers (Poynter.news university)
https://www.newsu.org/courses/math-for-journalists
Newseum
Society of Profesional Journalists eCampus
https://www.spj.org/trainingondemand.asp
JOURNALISM RESOURCE SITES(TOP)
The Tow Center for Digital Journalism
http://newsle.com/article/0/135646330/
CNet (a well-respected technology website)
The Canadian Journalism Project
The Canadian Association of Journalists
Canadian Journalists for Free Expression
The Center for Investigative Reporting
http://centerforinvestigativereporting.org/
The Center for News Literacy at Stony Brook University’s School of Journalism
http://www.stonybrook.edu/journalism/newsliteracy/index.html
Google expands fact checking in news searches
http://ipolitics.ca/2017/04/07/google-expands-fact-checking-in-news-searches/
Journalist’s Toolbox
http://www.journaliststoolbox.org/
Journalist’s Resource
https://journalistsresource.org/syllabi/data-journalism-visualization-mapping-ethics-syllabus
PowerReportering (resource for journalists)
http://www.powerreporting.com/category/Alerts_for_journalists
Committee to Protect Journalists (Defending Journalists Worldwide)
ChangeDetection.com
http://www.changedetection.com/
blinkx
Online Education Database
http://oedb.org/library/college-basics/research-beyond-google
Investigative Reporters and Editors
Investigative Reporters and Editors (IRE)Quick Hits
http://www.ire.org/quickhits/08_June27.html#b1
Investigate This! With Alex Roslin
http://albloggedup.blogspot.com/
Institute for Justice and Journalism
http://justicejournalism.org/curriculum/data-animation-webinar-part-1/
IRE story search
http://www.ire.org/resourcecenter/search.php
How Stuff Works
Media magazine
Logan Symposium
http://investigativereportingprogram.com/logan-symposium/
The scoop (A blog maintained by computer-assisted reporting specialist Derek Willis)
FINAL REPORT ON THE CANADIAN NEWS MEDIA (Standing Senate Committee on Transport and Communications)
Nieman Lab (The Donald, documented: The Washington Post open-sources much of its Trump reporting
http://www.niemanlab.org/2016/08/the-donald-documented-the-washington-post-open-sources-much-of-its-trump-reporting/?utm_source=Daily+Lab+email+list&utm_campaign=107c14838f-dailylabemail3&utm_medium=email&utm_term=0_d68264fd5e-107c14838f-395868801
ProPublica: Journalism in the Public Interest
The Investigative Reporting Workshop (a project of the School of Communication at American University)
http://investigativereportingworkshop.org/
The Toronto Star in-depth stories
http://www.thestar.com/investigations
Enquete ( Radio-Canada’s investigative program)
http://www.radio-canada.ca/emissions/enquete/2008-2009/
Daylife
http://www.daylife.com/topstories
Chicago Tribune
http://www.chicagotribune.com/news/specials/
The Cable Public Affairs Channel (CPAC)
http://www.cpac.ca/forms/index.asp?dsp=template&act=view3&template_id=46&lang=e
Cultural Diversity and Ethnic Media in BC. (a report of Simon Fraser University’s Centre for Policy Studies on Culture and Communities)
http://www.bcethnicmedia.ca/research.html
The Canadian Military in the news
http://www.cfc.forces.gc.ca/spotnews_e.html
Online News Association
Adrian Holovaty (web developer and Chicago-based journalist)
Online Journalism Review
NowPublic (crowd powered media)
Orato ( True stories from real people)
International Consortium of Investigative Journalists
http://www.publicintegrity.org/icij/
International Journalists’ Network
JNet’s Picks of the Week (a random selection of websites of use to journalists)
http://www.journalismnet.com/picks
Radio-Canada (archives)
http://www.radio-canada.ca/actualite/v2/tj22h/archive50_200408.shtml
Kirk LaPointe’s J-home
Infomart
Canada.com
The Canadian Press
http://www.thecanadianpress.com/default.aspx
http://www.cpimages.com/fotoweb/index.fwx
National Post photos
http://news.nationalpost.com/category/photos/
The Hill Times
http://www.hilltimes.com/information_pages/about.php
iPolitics
World news
Association for Education in Journalism and Mass Communication
Independent media
Independent Media TV
http://www.independent-media.tv/about.cfm
DiversityWatch
http://www.diversitywatch.ryerson.ca/media/
ABYZ News Links
Newspaper archives
http://www.newspaperarchive.com/
AllYouCanRead
Sept.11 Archives
http://www.september11archive.com/
Canadian Community Newspapers Association (CCNA)
Community Press Online (Ontario)
http://www.communitypress-online.com
Online Newspapers
http://www.onlinenewspapers.com/
Google News Advanced Archive Search
http://news.google.com/archivesearch/advanced_search
LexisNexis AlaCarte! (advanced search)
http://alacarte.lexisnexis.com/partners/int/lexisnews/srchNW.asp
LexisNexis AlaCarte! (free short-term news searches on hot stories)
http://www.lexisnexis.com/news/
Hospital News
Medical Doctor (a Canadian website that tracks medical coverage)
Columbia Journalism Review
The Complete New Yorker: Eighty Years of the Nation’s Greatest Magazine
http://www.amazon.ca/exec/obidos/ASIN/1400064740/ref=pd_bxgy_text_2/702-6007597-6128034
Counterpunch (left-wing American political newsletter)
Cyberjournalist.net ( The Online News Association )
http://www.cyberjournalist.net/supersearch.php/
Expert sources — ProfNet
http://www2.profnet.com/login_prn.jsp
Carleton’s journalism in Rwanda effort
http://www.rwandainitiative.ca/index2.html
Snopes.com (Rumour Has It)
Regret The Error ( it reports on corrections, retractions, clarifications and trends regarding accuracy and honesty in the media)
http://www.regrettheerror.com/
Wikileaks
http://www.wikileaks.org/index.html
OhmyNews International
Canadian Association of Internet Providers
Public Eye Online
http://www.publiceyeonline.com/
Public Editor ( The site of the New York Times public editor )
http://topics.nytimes.com/top/opinion/thepubliceditor/index.html
Project for Excellence In Journalism (The State of the News Media 2008)
http://www.stateofthenewsmedia.org/2008/
Legacy.com (obituary searches)
American Press Institute
http://www.americanpressinstitute.org/
Inside the Queensway: Maclean’s blogger Kady O’Malley
http://blog.macleans.ca/2009/02/19/liveblogging-the-layover-of-the-century/
Jacqui Banaszynski tips on finding stories
Famous quotes & quotations
http://www.famous-quotes-and-quotations.com/
The Future of Journalism
http://www.ourblook.com/component/option,com_sectionex/Itemid,200076/id,8/view,category/#catid69
Investigative Reporting Workshop (The American University)
http://investigativereportingworkshop.org/staff/openings/
“American Radical: The Life and Times of I.F. Stone” (DemocracyNow)
http://www.democracynow.org/2009/6/18/american_radical_the_life_and_times
Alternate News Sources
http://www.peoplesearchpro.com/journalism/alternate/
Narrative Matters (A peer-reviewed, personal-essay section of the policy journal Health Affairs)
http://www.healthaffairs.org/NM.php
VND (Algonquin College’s Virtual News Desk)
Scribd.com
Marion Warnica
The New York Review of Books
OWNI.EU Digital Journalism (Technology, Politics and Culture)
Charlie Brooker – How To Report The News (on Youtube)
http://www.youtube.com/watch?feature=player_embedded&v=YtGSXMuWMR4
National News Watch
http://www.nationalnewswatch.com/
The Huffington Post (Canada)
TRAINING RESOURCES(TOP)
Access 2000 tutorial (Florida Gulf Coast University)
http://www.fgcu.edu/support/office2000/access/index.html
Allen Browne’s Database and Training
http://allenbrowne.com/tips.html
College syllabi on computer-assisted reporting, precision journalism and news research
Gannett Newsroom Resources
http://www.gannett.com/go/newswatch/nwwebtips/webresmain.html
Institute for Analytic Journalism
http://analyticjournalism.blogharbor.com/blog
Journalism Education in Canada (Carleton professor, Mary McGuire)
http://http-server.carleton.ca/~mmcguire/J-Ed/
JournalismNet (Julian Sher’s Internet site)
MVP Web Sites (tutorials for Microsoft Access)
http://mvps.org/links.html#Access
PewResearchCenter Publications
http://pewresearch.org/pubs/1220/home-ownership-trends-blacks-hispanics
Newscollege ( Practical Journalism Tips )
News University (A project of The Poynter Institute for Media Studies funded)
No Train, No Gain
http://www.notrain-nogain.com/
Online tutorials from Brown University
Poynter Institutue
Knowledgewebb (Baltimore-based online training for people working in the digital media)
Writing About Business (The New Columbia Knight – Bagehot Guide to Economics & Business Journalism)
Society of Professional Journalists
Citizen Journalism course at Kwantlen Polytechnic University
http://beyourownjournalist.com/
What the unemployment rate does – and doesn’t – say about the economy
http://www.pewresearch.org/fact-tank/2017/03/07/employment-vs-unemployment-different-stories-from-the-jobs-numbers/
KEY WORD SEARCH ENGINES(TOP)
Google Keyword Selector
https://adwords.google.com/select/KeywordToolExternal
The Official Google Reader Blog (Follow changes to any websites)
http://googlereader.blogspot.com/2010/01/follow-changes-to-any-website.html
SearchEngineWatch.com
Yahoo Search
Windows Live (MSN Search)
http://www.live.com/?searchonly=true&mkt=en-ca
AlltheWeb
Wisenut
Vivisimo
Killer Info
Search Engine Showdown (The User’s Guide To Searching the Web)
http://www.searchengineshowdown.com/others/archive.shtml
Wayback machine (Internet archives)
http://www.archive.org/web/web.php
http://www.archive.org/index.php
Finding Old Web Pages
http://www.searchengineshowdown.com/others/archive.shtml
baidu (a large Chinese search engine that has a cache link)
Cyberjournalists.net
http://www.cyberjournalist.net/cyberjournalists.php
Search Engine Showdown (The Users’ Guide to Web Searching)
http://searchengineshowdown.com/
http://www.searchengineshowdown.com/others/archive.shtml
LABOUR [Top]
Occupation – Standard Occupational Classification 1991 (Historical) (707) (Statistics Canada)
Enforcement Statistics (Ontario Ministry of Labour)
http://www.labour.gov.on.ca/english/hs/pubs/enforcement/index.php
LAND-TITLE AND PROPERTY ASSESSMENT OFFICES(TOP)
The TitleSearchers.ca ( is a website of title searches / registry agents across Canada
Alberta Land Titles
http://www.servicealberta.ca/LandTitles.cfm
British Columbia Land Titles
https://www.bconline.gov.bc.ca/
Manitoba Property Registry
http://www.gov.mb.ca/tpr/land_titles/lto_offices/offices.html
New Brunswick Land Titles and Assessments
http://www.snb.ca/e/4000/4106e.asp
NewFoundland and Labrador Deeds
http://www.gs.gov.nl.ca/registries/deeds.html
Northwest Territories Land Titles
http://www.justice.gov.nt.ca/LandTitles/index.shtml
Nova Scotia’s Property Online
http://www.gov.ns.ca/snsmr/property/default.asp?mn=282.46.1064
Nunavut
http://www.justice.gov.nu.ca/i18n/french/legreg/lt_index.shtm
Ontario Land Registration Information
http://www.ontario.ca/en/information_bundle/land_registration/STEL01_130081.html
Prince Edward Island Registry of Deeds
http://www.gov.pe.ca/finance/index.php3?number=1007538&lang=E
Quebec Land Titles
https://www.registrefoncier.gouv.qc.ca/Sirf/Script/14_06_01-02/pf_14_06_01_reglr.asp
Saskatchewan Land Registry
http://www.isc.ca/LandTitles/Pages/default.aspx
Yukon Land Titles
http://www.justice.gov.yk.ca/prog/cs/index.html
LEGAL SYSTEM/COURTS (TOP)
National Class Action Database (The Canadian Bar Association)
http://www.cba.org/classactions/main/gate/index/
Martindale.com
Multilingual Legal Glossary
http://legalglossary.ca/dictionary/getRecord2.asp?3325,1,0
Legal terminology
http://www.duhaime.org/dictionary/diction.htm
Canada’s justice system
http://canada.justice.gc.ca/eng/sch-rch/sch-rch.asp
The Criminal Code
http://laws.justice.gc.ca/en/C-46/index.html
Justice Laws Website Title (The Department of Justice Canada)
http://laws-lois.justice.gc.ca/eng/index.html
The Association of Justice Counsel (The bargaining agent for Justice lawyers and notaries for which Treasury Board is the employer)
http://www.ajc-ajj.org/eng/default.aspx
Table of Public Statutes and Responsible Ministers (The Department of Justice Canada)
http://laws-lois.justice.gc.ca/eng/TablePublicStatutes/index.html
Federal Accountability Act (S.C. 2006, c. 9 – The Department of Justice Canada)
http://laws-lois.justice.gc.ca/eng/acts/F-5.5/index.html
Canadian legal resources
http://jurist.law.utoronto.ca/ref_desk.htm
The Canadian Legal Information Institute
http://canlii.org/en/index.php
The scope of CANLII’s databases
http://canlii.org/en/databases.html
Law Society of Upper Canada ( list of disbarred lawyer )
http://www.lsuc.on.ca/with.aspx?id=689
The National Class Action Database (a voluntary initiative and is not a comprehensive listing of all class action lawsuits currently underway in Canada)
http://www.cba.org/ClassActions/main/gate/index/default.aspx
Canadian Media Lawyers Association (Ad IDEM)
WestlawECarswell (site to be used by Carleton student ID number)
http://www.library.carleton.ca/eresources/db_titles_W.html
Supreme Court of Canada
http://www.scc-csc.gc.ca/home-accueil/index-eng.asp
Judgements of the Supreme Court of Canada
http://csc.lexum.org/en/index.html
Federal Court of Canada
http://www.fct-cf.gc.ca/index_e.html
Federal Court watch (This site monitors the most recent files on the Federal Court of Canada trial division docket)
http://sushiboy.org/fedcourt.php
Tax Court of Canada
http://www.tcc-cci.gc.ca/main_e.htm
Manitoba Courts
Ontario Courts
http://www.ontariocourts.on.ca/english.htm
Quebec Courts
http://www.jugements.qc.ca/generalites/contenu.php
Provincial Offences Court – Ottawa
http://ottawa.ca/city_hall/prov_crt/index_en.html
Canadian Bar Association
http://www.cba.org/CBA/Home.asp
Canadian Law List
http://www.canadianlawlist.com/
Law Commission of Canada
http://www.lcc.gc.ca/default-en.asp?lang_update=1
ipblog.ca (intellectual property, trade-mark & Internet law)
Bankruptcydata.com
http://www.bankruptcydata.com/default.asp
Findlaw
http://www.findlaw.com/index.html?srchfindlaw
Smoking Gun
British and Irish Legal Information Institute
Ottawa Law Review
http://www.commonlaw.uottawa.ca/en/ottawa-law-review/full-page-content/ottawa-law-review.html
HG.org (Worldwide legal directories)
http://www.hg.org/law-firms/Personal-Injury/Canada.html
LIBRARIES/ARCHIVES (TOP)
Library of Parliament
http://www.parl.gc.ca/common/library_prb.asp?Language=E
Library of Parliament Publications
http://www.lop.parl.gc.ca/About/Library/VirtualLibrary/ResearchPublications-e.asp
Provincial and Territorial Archives
http://www.collectionscanada.gc.ca/genealogy/022-802-e.html
Library and Archives Canada
http://www.collectionscanada.ca/index-e.html
The Internet Public Library
The Canadian Council of Archives
http://www.archivescanada.ca/index2.html
Theses Canada Portal (Library and Archives Canada)
http://www.collectionscanada.ca/thesescanada/index-e.html
ArchiviaNet Online Research Tool
http://www.archives.ca/02/0201_e.html
Ottawa Public Library
http://www.library.ottawa.on.ca/english/index.htm
Proquest
Bartleby.com (a complete reference guide)
http://www.bartleby.com/reference/
Gumshoe Librarian ( A bibliography of Recommended Websites for Global Research Issues )
http://www.llrx.com/features/gumshoe.htm
U.S. News Archives on the Web
http://www.ibiblio.org/slanews/internet/archives.html
LOBBYISTS(TOP)
Federal Public Registry of Lobbyists
http://www.ocl-cal.gc.ca/eic/site/lobbyist-lobbyiste1.nsf/eng/home
Federal lobbyists search
https://lobbycanada.gc.ca/eic/site/012.nsf/eng/h_00872.html
Lobbyists (Alberta)
http://www.lobbyistsact.ab.ca/LRS/Search.nsf/$$Search
Lobbyists ( British Columbia)
http://www.lobbyistsregistrar.bc.ca/
Lobbyists (Nova Scotia)
http://www.gov.ns.ca/snsmr/lobbyist/
Lobbying (New Brunswick)
http://www.lobbycomply.com/wordpress/?p=4003
Lobbyists (Ontario)
https://lobbyist.oico.on.ca/LRO/GeneralSettings.nsf/vwEnHTML/Home.htm
Lobbyists (Quebec)
https://www.lobby.gouv.qc.ca/servicespublic/consultation/ConsultationCitoyen.aspx
http://www.si2.commissairelobby.qc.ca/en/commissioner/access_information
Lobbyists (Newfoundland and Labrador)
http://www.gs.gov.nl.ca/registries/lobbyists.html
Lobbyists (City of Toronto)
http://www.toronto.ca/lobbying/
The Lobby Monitor
Lobby Watcher
http://www.lobbywatcher.ca/index.php
Elections Canada (contributions and expenses)
http://www.elections.ca/intro.asp?section=fin&document=index&lang=e&textonly=false
http://www.elections.ca/scripts/webpep/fin/welcome.aspx?lang=e
Open Secrets (a nonpartisan guide to money’s influence on U.S. elections and public policy)
http://www.opensecrets.org/index.php
Project On Government Oversight (U.S. non-profit watch-dog group)
Corporate and union campaign donations still loom large at city hall
Query the Lobbying Disclosure Act Database (U.S. Senate)
https://soprweb.senate.gov/index.cfm?event=selectfields
Lobbying Disclosure (U.S. House of Representatives)
http://lobbyingdisclosure.house.gov/
MAPPING(TOP)
Aboriginal Lands – CANADA
http://geogratis.gc.ca/api/en/nrcan-rncan/ess-sst/815dd99d-4fbd-47cc-be02-7ad4b03a23ec.html
http://geogratis.gc.ca/api/en/nrcan-rncan/ess-sst/-/(urn:gc:subject)aboriginal-lands
http://open.canada.ca/data/en/dataset/b6567c5c-8339-4055-99fa-63f92114d9e4 (the First Nations Location csv file is the 6th option “Pre-packaged csv file”)
https://fusiontables.google.com/DataSource?docid=1H_cl-oyeG4FDwqJUTeI_aGKmmkJdPDzRNccp96M&hl=en_US&pli=1
Geobase – Federal Electoral Districts – Canada 2013
Geographic Information Systems (Algonquin College)
http://www3.algonquincollege.com/sat/program/geographic-information-systems/
Geographic Information System (Q&A)
GPS Coordinates Finder
http://www.gps-coordinates.org/
For Fusion Table tutorial, click here
Simple Polylines (Google Maps JavaScript API v3)
https://developers.google.com/maps/documentation/javascript/examples/polyline-simple
Oil and Gas Rights Digital Files (Aboriginal Affairs and Northern Development Canada)
http://www.aadnc-aandc.gc.ca/eng/1100100036298/1100100036301
Leaflet
http://leafletjs.com/
Qgis (on windows)
http://www.qgis.org/downloads/QGIS-OSGeo4W-1.5.0-14109-Setup.exe
Qgis (for Mac users)
http://www.kyngchaos.com/files/software/qgis/Qgis(standalone)-1.5.0-3-Snow.dmg (for Snow Leopard 10.6)
http://www.kyngchaos.com/files/software/qgis/Qgis(standalone)-1.5.0-4-Leopard.dmg (for Leopard 10.5)
Qgis basics for journalists
http://multimedia.journalism.berkeley.edu/tutorials/qgis-basics-journalists/install/
QGIS Cloud
http://qgiscloud.com/pages/quickstart
QGIS Cloud (test)
http://qgiscloud.com/jrivard5/test
Making maps with QGIS (Peter Aldhous)
http://paldhous.github.io/NICAR/2015/qgis.html
Manipulating and editing geographic data with QGIS (Michael Corey)
http://mikejcorey.github.io/qgis_advanced_2015/
Knight Digital Media Center’s data visualization tutorials
http://multimedia.journalism.berkeley.edu/tutorials/cat/data
Knight Digital Media Center’s digital media tutorials
http://multimedia.journalism.berkeley.edu/tutorials/
FalconView
http://www.falconview.org/trac/FalconView
Lining Up Data in ArcGIS: A Guide to Map Projections, Second Edition
http://esripress.esri.com/display/index.cfm?fuseaction=display&websiteID=231&moduleID=0
Natural Resources Canada’s collection of maps
http://www.nrcan.gc.ca/earth-sciences/geography/topographic-information/free-data-geogratis/11042
Maps Corner ( Elections Canada)
http://www.elections.ca/content.aspx?section=res&dir=cir/maps&document=index&lang=e
Federal Electoral Districts
http://geogratis.cgdi.gc.ca/geogratis/en/option/select.do?id=258D0E88-4C19-7DB1-41C2-0D0CF1CAF49C
Geospatial Database (Queen’s University Library)
http://db.library.queensu.ca/geospatial_data/
Data Catalogue (City of Ottawa)
http://ottawa.ca/online_services/opendata/info/index_en.html
GIS Data Classifications in Cartographica
http://blog.cartographica.com/blog/2010/8/16/gis-data-classifications-in-cartographica.html
GeoCoder (converts addresses into longitude and latitude for use in mapping)
Geocoder.ca
http://geocoder.ca/?freedata=1
Get Latitude and Longitude
http://www.latlong.net/
GeoBase
http://www.geobase.ca/geobase/en/index.html
GeoCoder.ca
Geocommons
Degrees, Minutes, Seconds and Decimal Degrees Latitude/Longitude Conversions (Federal Communications Commission)
http://transition.fcc.gov/mb/audio/bickel/DDDMMSS-decimal.html
Understanding Latitude and Longitude:The Global Grid
http://www.learner.org/jnorth/tm/LongitudeIntro.html
MapShaper
http://mapshaper.com/test/demo.html
ESRI
http://esripress.esri.com/display/index.cfm
GIS for Stimulus Reporting
http://www.esri.com/industries/stategov/business/stimulus.html
Tableau Public ( a free application that helps to visualize data )
http://www.tableausoftware.com/public/gallery
http://www.tableausoftware.com/public/ire
Tableau tutorials
Google Fusion Tables
Googe Fusion Tables discussion group
https://groups.google.com/forum/#!topic/fusion-tables-users-group/4SVxAew5P78
Google Fusion Table (shape file to KML conversion)
Google fusion tables beta (data sets you can use)
https://www.google.com/fusiontables/search
FusionTablesLayer Builder
http://gmaps-samples.googlecode.com/svn/trunk/fusiontables/fusiontableslayer_builder.html
Google Sites (allows you to see what your Fusion Table maps or charts look like before publishing them)
http://www.google.com/sites/help/intl/en/overview.html
ColorBrewer (for doing fancier colour schemes in Fusion Tables)
A map to help voters find their polling places using Fusion Tables as a data source (Google fusion tables)
Google earth
http://www.google.com/earth/index.html
How to make your own data map of Montreal
http://blogs.montrealgazette.com/2011/10/07/how-to-make-your-own-data-map-of-montreal/
Zonum Solutions (Converts shape file files to KML files)
http://www.zonums.com/shp2kml.html
Gut Those Shapefiles (shape file converter)
Google Geo Developers Blog
http://googlegeodevelopers.blogspot.com/2010/11/search-your-geo-data-using-spatial.html
Google’s Chart Tool
http://imagecharteditor.appspot.com/
Shape to Fusion ( A website that allow users to import shape files into fusion tables)
Patrickcain.ca (A journalist who makes maps for the Web)
All things spatial (a good mapping blog)
http://all-things-spatial.blogspot.com/
Google public data explorer
http://www.google.com/publicdata/home
http://www.google.com/support/publicdata/
http://www.youtube.com/watch?v=jbkSRLYSojo&feature=related
GPS Visualizer
http://www.gpsvisualizer.com/geocoder/
Infinite Gravity Data Services (The Canadian Postal Code)
http://www.infinitegravity.ca/postalcodeformat.htm
Think Data
Fusion Table URL for the Ottawa bike thefts
http://www.google.com/fusiontables/DataSource?snapid=S290201DOQI
Patrickcain.ca: A journalist who makes maps for the web
http://www.patrickcain.ca/?p=1
111031_afghan_dead_for_Google
http://www.google.com/fusiontables/DataSource?snapid=S308680sRHu
Boundary files (Statistics Canada)
http://www12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-eng.cfm
Geogrpahic levels for 2011 census (Statistics Canada)
2006 Census Population (Statistics Canada)
http://www12.statcan.gc.ca/census-recensement/2006/index-eng.cfm
2006 Census Income and Earnings
2006 Census Household Income
2011 Census – Province and Territory Cargographic Boundary Files (Statistics Canada)
http://www.data.gc.ca/data/en/dataset/bab06e04-e6d0-41f1-a595-6cff4d71bedf
Geography (Statistics Canada)
http://www12.statcan.gc.ca/census-recensement/2011/geo/index-eng.cfm
OpenStreetMap
http://planet.openstreetmap.org/planet/planet-latest.osm.bz2
ArcGIS Resources
http://resources.arcgis.com/en/help/main/10.1/index.html#//006z00000009000000
Importing csv data tutorial
https://www.trentu.ca/library/data/addingXYdata_V10.pdf
Mapbox: Tips for using colors
https://www.mapbox.com/tilemill/docs/guides/tips-for-color/
Welcome to the First Nation Profiles Interactive Map
http://fnpim-cippn.aandc-aadnc.gc.ca/index-eng.html
MAPPING STORIES(TOP)
Airbnb renters hope to score big cash during Pan Am games (CBC-Radio-Canada)
Follow the Money: Federal spending announcements in 2013(CBC News and Carleton J-school)
http://www.cbc.ca/news/politics/federal-funding
EXCLUSIVE: Search and rescue for false alarms costs millions (CBC News)
http://www.cbc.ca/news/politics/search-and-rescue-for-false-alarms-costs-millions-1.2594306
Contaminated sites cleanup to cost billions more, budget office says (CBC News)
2011 Census Population Data by Ward (Raise the Hammer)
http://www.raisethehammer.org/article/1541/2011_census_population_data_by_ward
Crime in St. Paul
http://stpaulcrime.twincities.com/#trends
2011 Wisconsin Senate Recalls
http://host.madison.com/data/maps/politics/2011-senate-recalls/
After federal changes to waterways rules, 90 per cent of protected lakes lap on Conservative shores (The Ottawa Citizen)
http://aware-simcoe.ca/issues/water/3237-water.html
Conservatives defend new waterways rules against accusations of favouritism (The Ottawa Citizen)
A new view of Edmonton (Edmonton Journal)
http://www.edmontonjournal.com/news/living-on-the-edge/index.html
Battleground B.C.: Election Trends (The Vancouver Sun)
http://www.vancouversun.com/news/electiontrends.html
Canada’s climbing tuition fees (CBC News)
http://www.cbc.ca/news/interactives/map-tuition-fees/
City’s Information Technology Master Plan – Enabling an Engaged & Connected City
Mapping info: More city data within reach online
http://windsorstar.com/news/local-news/mapping-info-more-city-data-within-reach-online
Median home prices in 2010 remained below 2007 levels across Cuyahoga County
http://www.cleveland.com/datacentral/index.ssf/2011/02/median_home_prices_in_2010_rem.html
Midterm byelections to test Liberal government and leaderless opposition parties
http://www.cbc.ca/news/politics/grenier-byelection-tests-1.4047721
MONTREAL: CITY OF CONTRASTS (The Gazette, Montreal)
http://www.montrealgazette.com/news/interactives/household-survey/index.html
More discarded needles being found in Ottawa’s suburbs (CBC News)
New Westminster launches open data website
http://www.burnabynow.com/news/new-westminster-launches-open-data-website-1.2114670
Lying with Maps: How Enbridge is Misleading the Public in its Ads
http://eaves.ca/2012/08/15/lying-with-maps-how-enbridge-is-misleading-the-public-in-its-ads/
New federal electoral boundaries (CBC News)
http://www.cbc.ca/news2/interactives/electoral-district-search/
Current Events Maps
http://www.esri.com/news/maps/index.html
Crime rates continue to fall in Canada: Declines recorded across country, for most offences (CBC News)
http://www.cbc.ca/news/interactives/crime-severity/
Gulf of Mexico Oil Spill
http://www.esri.com/services/disaster-response/gulf-oil-spill-2010/resources.html
Census 2010 Interactive Map: Texas Population By Race, Hispanic Origin (The Texas Tribune)
http://www.texastribune.org/library/data/census-2010/
Census 2010 Interactive Map: Texas Population By House, Senate District (The Texas Tribune)
http://www.texastribune.org/library/data/census-2010/
Family, church important to Filipinos: Many call the central neighbourhood around Fraser Street home, and Tagalog signs abound (The Vancouver Sun)
Federal Parolees Per Capita (The Vancouver Sun)
http://www.vancouversun.com/news/parolees-capita.html
Fare evasion on SkyTrain and Canada Line (The Vancouver Sun)
http://www.vancouversun.com/news/transit-system-crime/fare-evasion.html
Election Prediction 2011 (Hill and Knowlton)
Enbridge affiliates have had 175 leaks, spills over 10 years in U.S. (The Ottawa Citizen)
Explore the data: Toronto bicycle collisions mapped over 25 years (The Globe and Mail)
50 ridings to watch in the 2011 election (The Globe and Mail)
2008 Federal election: GTA ridings (The Toronto Star)
http://www3.thestar.com/static/googlemaps/electionmaps.html?xml=2008_federal.xml
Highway 63 features map (The Edmonton Journal)
http://www.edmontonjournal.com/news/highway63/map/index.html
Homicides mapped: 1999 to 2011 (Edmonton Journal)
http://www.edmontonjournal.com/news/homicide/map/index.html
How Many People Have Been Killed by Guns Since Newtown? (Slate)
INTERACTIVE: Census Explorer (The Canadian Press)
http://www.winnipegfreepress.com/canada/breakingnews/INTERACTIVE-Census-Explorer-138930999.html
Interactive map: Data links low income to poor school test results (Global News)
Interactive Map: Nov. 8 Amendment Vote by County (The Texas Tribune)
http://www.texastribune.org/library/data/nov-8-amendment-vote-map/
Interactive: What’s My District Now? (The Texas Tribune)
http://www.texastribune.org/library/data/whats-my-district-now/
Interactive: Perry Tracker (The Texas Tribune)
http://www.texastribune.org/library/data/perrytracker/
Interactive: Exploring Presidential Donors by ZIP Code (The Texas Tribune)
http://www.texastribune.org/library/data/exploring-presidential-donor-zip-code/
Interactive: Census: Where you live (The Telegraph)
http://www.macon.com/2011/03/22/1497153/census-where-you-live.html#storylink=misearch
Interactive map: Bibb County’s congressional redistricting (The Telegraph)
Interactive: Making the WNYC Census Map (JohnKeefe.net)
Interactive: SNAPSHOT: Motorcycles per 1,000 residents, 2010 (boston.com)
Interactive Map: Explore the data behind Toronto’s working poor (The globe and Mail)
Interactive: City of Toronto homicides and gang activity, 2008 to present
Investigate with us (Edmonton Journal)
http://www.edmontonjournal.com/news/living-on-the-edge/index.html
Grand Falls-Windsor growing without paper mill (CBC News)
http://www.cbc.ca/news/canada/newfoundland-labrador/story/2012/02/11/nl-gfw-census-211.html
Living on the Edge (Edmonton Journal)
http://www.edmontonjournal.com/news/livingontheedge/index.html
Map: See Dallas-area holiday light displays (Dallas Morning News)
Metro Vancouver Daycare Ratings Map (The Vancouver Sun)
http://www.vancouversun.com/news/daycare-map.html
New Ramsey County sheriff approves a higher percentage of gun applications than Fletcher (Pioneer Press)
http://www.twincities.com/ci_19512257
NYC Evacuation Zones
http://project.wnyc.org/news-maps/hurricane-zones/hurricane-zones.html
Minnesota’s public pensins: 40-year financial snapshot
http://public.tableausoftware.com/views/Pensions2/Dashboard1?:embed=y
Pioneer Press Family Outings Find fun things to do with your kids in the Twin Cities
http://www.twincities.com/family
Riding Profile — Edmonton – Strathcona (The Edmonton Journal)
http://www.edmontonjournal.com/news/election/edmontonstrathcona.html
BC Liberal leadership vote by the numbers — exclusive maps, graphics and analysis (The Vancouver Sun)
(902)-9-1-1 (A King’s College Investigation)
http://902911.kingsjournalism.com/
Comment vos voisins ont-ils voté en 2008? (Cyberpresse.ca)
Canada Votes 2011 ( Interactive map: CBCNews.ca)
http://www.cbc.ca/news/politics/canadavotes2011/#/171
Canadian federal election results for 2004, 2008 and 2011 (ERSI Press)
http://50.16.208.225/CompareWebMaps/
Canada’s 41st Election Explained ( Flickr )
http://www.flickr.com/photos/david_hicks/5683761559/sizes/l/in/photostream/
Find Your Polling Place (baycitizen.org)
http://www.baycitizen.org/data/mayors-race-2011/poll-locations/
Global News Exclusive: Maritimers leading the way in organ donor registration (globalnewsmaritimes)
Gogama : la hausse du transport de pétrole par train en partie responsable des accidents, croient des experts (Radio-Canada)
http://ici.radio-canada.ca/regions/ontario/2015/03/10/007-lien-petrole-deraillements.shtml
Interactive map shows breakdown of HST vote (The Vancouver Sun)
http://www.vancouversun.com/news/Interactive+shows+breakdown+vote/5313564/story.html
Interactive: Direct your own exploration of Minnesota Census data (Pioneer Press)
http://www.twincities.com/1000/ci_17627259?source=pkg
Interactive: Get to know your candidates (The Gazette)
http://www.montrealgazette.com/news/decision-canada/learn-about-candidates.html
Interactive graphics and databases (The Seattle Times)
http://seattletimes.nwsource.com/flatpages/specialreports/interactives.html?from=stnv2
Interactive: Texas Presidential Contributions by ZIP Code (The Texas Tribune)
http://www.texastribune.org/library/data/presidential-contributions-zip-code-2011/
METHADONE AND THE POLITICS OF PAIN (The Seattle Times)
Proposed Keystone Pipeline road map (CBC News)
http://www.cbc.ca/news/interactives/map-pipeline/
http://www.cbc.ca/news/politics/story/2011/11/10/keyston-pipeline-route.html
How WNYC Used Texts from Citizens To Map Snowstorm (Mobile Phone Blog)
http://mobilephone.firstblogfirst.com/2011/01/28/how-wnyc-used-texts-from-citizens-to-map-snowstorm/
Map of the Week: Grow operations (The Toronto Star)
Mapping our ethnicity Parts 1,2,3,5 (The Vancouver Sun)
http://www.vancouversun.com/news/Mapping+ethnicity+Part+South+Asia+Surrey/5547648/story.html
http://www.vancouversun.com/ethnicity/index.html
Mapping the Nation’s Well-Being (The New York Times)
http://www.nytimes.com/interactive/2011/03/06/weekinreview/20110306-happiness.html?ref=multimedia
Maps: Who are the dogs in your Toronto neighbourhood? (Global News)
http://www.globalnews.ca/Pages/Story.aspx?id=6442522298
Map: Where the tornadoes hit
http://news.cincinnati.com/interactive/article/20130227/CINCI/130227014?nclick_check=1
Medical marijuana use in Canada by postal code, 2001 to 2007 (Postmedia News)
http://www.vancouversun.com/health/medical-marijuana/map/index.html
Metro Vancouver Mapped: If you’re living in sin, you’re most likely living in Kitsilano (The Vancouver Sun)
http://www.vancouversun.com/news/metro-mapped/index.html
Metro buses involved in hundreds of crashes a year (CBC News Nova Scotia)
http://www.cbc.ca/news/canada/nova-scotia/story/2012/01/29/ns-metro-transit-collisions.html
Mississippi floods: how does 2011 compare? (New Scientist)
http://www.newscientist.com/blogs/shortsharpscience/2011/05/mississippi-floods-how-does-20.html
Oilsands website (Alberta government)
Ontario voter turnout lowest since 1867 (globalnews.ca)
http://www.globalnews.ca/interactive/6442496991/story.html
Rains come to Texas but drought could last for years (New Scientist)
http://www.newscientist.com/blogs/shortsharpscience/2011/10/texas-rains-too-little-too-lat.html
Spence residents complaining about bedbugs (globalwinnipeg)
http://www.globalwinnipeg.com/spence+residents+complaining+about+bedbugs/6442512625/story.html
Spinal-cord injuries hit teen athletes hardest (Pioneer Press)
http://www.twincities.com/ci_19750035
‘Sputnik moment’? A report card for US cities (New Scientist)
http://www.newscientist.com/blogs/onepercent/2011/01/-innovation-in-america-dashboa.html
Storm warning: prepare for a busy hurricane season (New Scientist)
http://www.newscientist.com/blogs/shortsharpscience/2011/05/prepare-for-hurricane-season.html
St. Paul gun incident reports up 65 percent so far in 2012 (w/ searchable map) (St. Paul Pioneer Press)
The Census: Canada’s Changing Society (The Canadian Press)
http://thecanadianpress-census.ca/?graphics=communities-interactive-map
http://thecanadianpress-census.ca/
TransLink bus routes with the most passups (The Vancouver Sun)
http://www.vancouversun.com/news/passuproutes.html
Travelling memorial: Canadians in Afghanistan (CBC News)
http://www.cbc.ca/news/interactives/mural-cdnsinafghanistan/
U.S. tech workers by the numbers (Computer World)
http://www.computerworld.com/s/article/9231501/U.S._tech_workers_by_the_numbers#map
Unemployment rates in Canada (CBC News)
http://www.cbc.ca/news/interactives/unemployment-stats/
Vancouver Photos from Flickr (The Vancouver Sun)
http://www.vancouversun.com/news/flickr.html
Vancouver Crime 2006-2011
http://marcellison.com/fusion/fusion_index.html
Welcome to The Bay Citizen’s Bike Accident Tracker! (baycitizen.org)
http://www.baycitizen.org/data/bike-accidents/
When Maps shouldn’t be Maps (Matthew Ericson, deputy graphics director for The New York Times)
http://www.ericson.net/content/2011/10/when-maps-shouldnt-be-maps/
Where are the world’s nuclear reactors? (New Scientist)
http://www.newscientist.com/embedded/nuclear-reactor-map
Where are the mayoral candidates raising their money? (NPR)
http://empire.wnyc.org/2011/07/where-are-the-mayoral-candidates-raising-their-money/
The deadly mixture of guns and class in Toronto
Why Taxpayers Will Bail Out the Rich When the Next Storm Hits (NBC News)
http://www.nbcnews.com/news/us-news/average-joes-fighting-fema-flood-maps-isnt-easy-or-cheap-n23871
MAPPING TUTORIALS(TOP)
Bringing Google spreadsheets and Fusion Tables closer together
http://chrislkeller.blogspot.ca/
Fusion Table tutorial (MaryJo Webster, St. Paul Pioneer Press)
http://extra.twincities.com/car/mj/fusiontableswebinar.wmv
Quickly visualize and map a data set using Google Fusion Tables
How to make a map in Google Fusion Tables
http://www.computerworld.com/slideshow/detail/68971#slide1
Spatial Analysis Tip Sheet — Spatial Joins and Overlays, Density, and Proximity Analysis (Barbara Parmenter, Tufts University)
http://ocw.tufts.edu/data/54/616425.pdf
HTML Tutorial – (HTML5 Compliant)
http://www.w3schools.com/html/default.asp
City of Ottawa building inspections (practice data)
Mapping Tutorial for 2010 Ottawa bike thefts
Mapping Tutorial for the distribution of baseball diamond in Ottawa wards
Mapping Tutorial for matching specific bike thefts in each wards using Qgis
Tutorial on visualing data separated into groups and creating a legend
Quantum GIS (QGIS) Tutorials
http://qgis.spatialthoughts.com/2012/03/using-tabular-data-in-qgis.html
http://qgis.spatialthoughts.com/2012/06/making-maps-for-print-using-qgis.html
http://docs.qgis.org/html/en/user_manual/print_composer/print_composer.html
Expressions, Filtering and Calculating Values in Qgis
http://docs.qgis.org/testing/en/docs/pyqgis_developer_cookbook/expressions.html
http://qgis.spatialthoughts.com/2010/10/working-with-attribute-table-basic.html
To obtain the first Qgis tutorial, please click here.
Here’s the second Qgis mapping tutorial.
Data for the third Qgis tutorial
2006 Census – Boundary files
http://www12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-2006-eng.cfm
After obtaining the census boundary file in the link above and downloading the “TotalIncome” file, you are ready for the third Qgis tutorial.
Telling your story with maps: ArcGIS Online Tutorial
http://video.arcgis.com/watch/916/arcgis-online-overview
http://video.arcgis.com/watch/916/arcgis-online-overview
http://video.arcgis.com/watch/916/arcgis-online-overview
http://video.arcgis.com/watch/1341/sharing-and-collaborating-within-an-organization
http://video.arcgis.com/watch/2457/map-your-excel-data
http://video.arcgis.com/watch/1340/managing-the-resources-of-an-organization
http://video.arcgis.com/watch/249/embedding-a-map-in-your-website
http://video.arcgis.com/watch/248/editing-feature-layers-on-a-map
http://video.arcgis.com/series/18/arcgis-online
A Mac user tutorial for downloading and creating your own base map layer (Lucus Timmons)
Tutorial: QGIS Basics For Journalists
http://multimedia.journalism.berkeley.edu/tutorials/qgis-basics-journalists/
Data journalism resources (Peter Aldhous, science journalist)
http://peteraldhous.com/resources.html
http://paldhous.github.io/NICAR/2015/qgis.html
Lining Up Data in ArcGIS: A Guide to Map Projections, Second Edition
http://esripress.esri.com/display/index.cfm?fuseaction=display&websiteID=231&moduleID=0
MEDICAL DEVICES(TOP)
Health Canada’s list of recalled drugs and medical devices
http://www.hc-sc.gc.ca/dhp-mps/compli-conform/recall-retrait/_list/index-eng.php
Health Canada’s list of warnings, advisories and recalls (on marketed health products, including Natural Health Products and medical devices)
http://www.hc-sc.gc.ca/dhp-mps/medeff/advisories-avis/index-eng.php
Food and Drug Administration’s list of device recalls
http://www.fda.gov/MedicalDevices/Safety/RecallsCorrectionsRemovals/ListofRecalls/default.htm
Food and Drug Administration’s Medical & Radiation Emitting Device Recalls
http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfRES/res.cfm
Food and Drug Administration’s Medical Device Databases
http://www.fda.gov/MedicalDevices/DeviceRegulationandGuidance/Databases/default.htm
Food and Drug Administration’s MAUDE – Manufacturer and User Facility Device Experience (MAUDE data contains reports of adverse events involving medical devices)
http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfMAUDE/search.CFM
Medical Device Reports (MAUDE) (NICAR)
https://ire.org/nicar/database-library/databases/medical-device-reports-maude/
Panel says medical device review system ‘flawed’ (The Associated Pres and CBC News)
http://www.cbc.ca/news/health/story/2011/07/29/health-medical-devices.html
Medical device changes to come in U.S. (The Associated Press)
http://www.cbc.ca/news/health/story/2011/01/20/medical-devices-fda.html
Medical device licence pulled, but still on the market (Marketplace)
Recently approved medical devices ( FDA )
http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfTopic/MDA/mda-list.cfm?list=1
MISCELLANEOUS TOOLS(TOP)
Listservs
http://www.lsoft.com/catalist.html
Blogs
Blog search (blog search)
Google’s BlogSearch
Ghostery
https://www.ghostery.com/en-GB/
Sphere
Feedster
All Calculators
http://calculator-converter.com/
Day-of-the-week calculator
http://www.calculatorcat.com/free_calculators/day_of_week.phtml
Calculate distance between two locations
http://www.timeanddate.com/worldclock/distance.html
The World Clock — Time Zones
Weather (Environment Canada)
http://www.weatheroffice.gc.ca/canada_e.html
Bank of Canada exchange rate converter
http://www.bankofcanada.ca/en/exchform.htm
http://www.bankofcanada.ca/rates/exchange/
Bank of Canada Inflation Calculator
http://www.bankofcanada.ca/en/rates/inflation_calc.html
Translation sites
http://babelfish.altavista.com/
http://www.google.ca/language_tools?hl=en
Timeanddate.com
MONEY(TOP)
Free Lunch: How the Wealthiest Americans Enrich Themselves at Government Expense (and Stick you with the bill)
GetSmarterAboutMoney.ca
http://www.getsmarteraboutmoney.ca/en/Pages/default.aspx
3Dpolicy.ca
Multi-media(TOP)
Liveleak
YouTube
Blinkx (Over 35 million hours of video. Search it all.)
The Tyee
The Printed Blog
http://www.theprintedblog.com/
MUNICIPAL GOVERNMENTS(TOP)
The Federation of Canadian Municipalities (FCM)
http://www.fcm.ca/english/main.html
Munimall (general information and news stories about municipalities)
Quebec municipalities
http://www.quebecmunicipal.qc.ca/liens/index.asp?LienID=47
Property assessments (Quebec municipalities)
http://www.quebecmunicipal.qc.ca/liens/index.asp?lienid=47
NEWS BLOGS(TOP)
Medium Close Up ( a blog by former CBC TV producer, Howard Bernstein)
How Canada became an open data and data journalism powerhouse (The Guardian)
http://m.guardian.co.uk/news/datablog/2010/nov/09/canada-open-data?cat=news&type=article
MYSQL(TOP)
Server SQL modes
http://dev.mysql.com/doc/refman/5.5/en/index.html
MySQL Documentation
MySQL Youtube Channel
https://www.youtube.com/user/MySQLChannel?cmid=NAMK15048361MPP057C009&elq_mid=43019&sh=
Oracle’s MySQL Blog
https://blogs.oracle.com/mysql/?elq_mid=43019&sh=&cmid=NAMK15048361MPP057C009
Planet MySQL
http://planet.mysql.com/?elq_mid=43019&sh=&cmid=NAMK15048361MPP057C009
NUMERACY SKILLS(TOP)
Addressing journalistic innumeracy and math phobia: A sequence of resources to sharpen your mind
http://journalistsresource.org/tip-sheets/research/journalistic-innumeracy-math-phobia-sequence-resources-to-sharpen-your-mind
Percentage Change Calculator
http://www.calculatorsoup.com/calculators/algebra/percent-change-calculator.php
Bank of Canada Statistics
http://www.bankofcanada.ca/rates/
A tipsheet on dealing with numbers
Don Gibb’s numeracy column for Media magazine
Math Quiz (the numbers are contained in Excel worksheets)
Math cribsheet courtesy of Steve Doig
http://forjournalists.com/cookbook/index.php?title=Math_cribsheet
Robert Niles.com
John Allen Paulos
No Train No Gain
http://www.notrain-nogain.org/Train/Res/Num/NUM.asp
The Poynter Institute
Math for Journalists (Debbie Wolfe)
http://www.newsu.org/courses/course_detail.aspx?id=nu_math05
Capping Credit Card Rates ( The NDP)
http://www.ndp.ca/credit-card-caps
Tips for journalists working with math, statistics: A list of key resources
http://journalistsresource.org/tip-sheets/research/math-journalist-numbers-statistics-research
OTTAWA [Top]
Ottawa city council
http://ottawa.ca/index_en.html
City Council & Committee Agendas & Minutes
http://ottawa.ca/cgi-bin/docs.pl?lang=en
http://ottawa.primegov.com/portal/#/
Budget 2018
https://ottawa.ca/en/city-hall/budget-and-taxes/budget/budget-2018
City of Ottawa data catalogue
http://ottawa.ca/online_services/opendata/info/index_en.html
City of Ottawa Ward profiles
http://ottawa.ca/residents/statistics/census/wards/index_en.html
Previous City Budgets (City of Ottawa)
http://www.ottawa.ca/en/city_hall/budgettaxes/budget/index.html
Information
The Municipal Performance Measurement Program
http://www.ottawa.ca/city_hall/ottawa_performance/mpmp/index_en.html
Community Information Centre of Ottawa
http://www.cominfo-ottawa.org/main_eng.html
Community Case Study: City of Ottawa (Natural Resources Canada)
ONLINE NEWS SITES(TOP)
The Huffington Post (Canada)
The Canadian Journalism Project
Open File (Community-powered news in several Canadian cities)
bclocalnews.com
OPEN DATA GOVERNMENT-INSTITUTION WEBSITES(Top)
2016 OPEN CITIES INDEX – TOP 20 RESULTS
https://publicsectordigest.com/2016-open-cities-index-top-20-results
Alberta
General Revenue Fund Details of Supplies, Services, Tangible Capital Assets and Other Payments
http://open.alberta.ca/dataset/general-revenue-fund-details-of-supplies-services-tangible-capital-assets-and-other-payments
BC
http://www.openinfo.gov.bc.ca/ibc/search/search.page#cateloguehttp://www.openinfo.gov.bc.ca/ibc/index.page?http://www.data.gov.bc.ca/
Canada Revenue Agency Tax-Free Savings Account 2014 Statistics (2012 contributions)
http://open.canada.ca/data/en/dataset/10531a5e-b500-4842-a1b0-305802a1da28
Canadian Open Data Institute
Canada’s Action Plan on Open Government 2014-16
http://open.canada.ca/en/content/canadas-action-plan-open-government-2014-16
Campaign Donations (City of Ottawa)
http://ottwatch.ca/election/listDonations
Chicago Crime Data
https://data.cityofchicago.org/Public-Safety/Crimes-2001-to-present/ijzp-q8t2
City of Kamloops
http://www.kamloops.ca/downloads/maps/launch.htm
Data Inventory Project (DIP) (Statistics Canada)
http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=5190&Item_Id=122357&lang=en
datalibre.ca
Directive on Open Government
http://www.tbs-sct.gc.ca/pol/doc-eng.aspx?id=28108
CANSIM – Table directory – All Section
http://www5.statcan.gc.ca/cansim/a29?lang=eng&groupid=All&p2=17#n376
Edmonton
Education Equality and Accountability Office
http://www.eqao.com/en
GeoNOVA
Government-Wide Reporting — Proactive Disclosure
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
Halifax’s Open Data Catalogue
http://www.halifax.ca/opendata/
Healthdoc (find local doctors and health care providers near you)
Kamloops
http://www.kamloops.ca/downloads/maps/launch.htm
Newfoundland and Labrador
Missing Migrants Project (International Organization for Migration)
http://missingmigrants.iom.int/
Mississauga
http://www.mississauga.ca/portal/residents/mississaugadata
Nova Scotia
Nova Scotia: Public Sector Compensation Disclosure
http://www.novascotia.ca/finance/en/home/publications/PSCD/default.aspx
Oakville
Online Journalism Blog
https://onlinejournalismblog.com/
Ontario
http://www.ontario.ca/government/open-data-ontario
http://www.ontario.ca/government/open-government
Ontario to allow public to vote on open data priorities
http://o.canada.com/technology/internet/ontario-to-allow-public-to-vote-on-open-data-priorities/
Ontario Trillium Foundation
http://otf.ca/our-impact/open-data
Open Government Declaration
http://www.opengovpartnership.org/about/open-government-declaration
OpenDataSites
Open Government Partnership
Open Data Pilot Project (federal government)
http://www.data.gc.ca/default.asp?lang=En
Open Data Pilot Project – csv files (federal government)
http://open.canada.ca/data/en/dataset?res_format=kml+%2F+kmz&_res_format_limit=0
Ottawa
http://data.ottawa.ca/en/?page=1
Ottawa restaurant inspections
Québec Ouvert (les données ouvertes pour le Québec)
Safe Schools: Statistics on Suspension and Expulsion
http://www.edu.gov.on.ca/eng/safeschools/statistics.html
Strathcona County
http://www.strathcona.ca/departments/information-technology-services/open-data/
Sudbury
http://www.greatersudbury.ca/inside-city-hall/open-data/
Squamish Open Data
http://data.squamish.ca/
Surrey
https://data.surrey.ca/dataset
Toronto
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD
Toronto (parking tickets)
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=ca20256c54ea4310VgnVCM1000003dd60f89RCRD
Transripts of Canadian parliamentary debates since 1901
http://mobilesyrup.com/2016/08/31/the-transcripts-of-canadian-parliamentary-debates-since-1901-are-now-online/
Transparency and Open Government ( Barack Obama’s first memorandum)
https://www.whitehouse.gov/the_press_office/TransparencyandOpenGovernment
TSB InfoBase (a searchable online database providing financial and human resources information on government operations.)
http://www.tbs-sct.gc.ca/ems-sgd/edb-bdd/ennojs-home.html
UNHCR migrant data and visualizations
http://data.unhcr.org/mediterranean/regional.php
Vancouver
World Development Indicators (The World Bank)
http://data.worldbank.org/data-catalog/world-development-indicators?cid=GPD_WDI
WJP OPEN GOVERNMENT INDEX (World Justice Project)
http://worldjusticeproject.org/open-government-index
World Council on City Data
http://open.dataforcities.org/
The United States
The Department of Transportation
http://www.dot.gov/mission/open/open-government
MEMORANDUM FOR THE HEADS OF EXECUTIVE DEPARTMENTS AND AGENCIES https://www.whitehouse.gov/sites/default/files/omb/memoranda/2013/m-13-13.pdf
The UK
Data.police.uk
Protection of Freedoms Act 2012
http://www.legislation.gov.uk/ukpga/2012/9/contents/enacted
Information Commissioner’s Office (a discussion of the datasets identified in the Protection of Freedoms Act 2012)
https://ico.org.uk/media/for-organisations/documents/1151/datasets-foi-guidance.pdf
U.K. Prime Minister’s first open letter on open data
U.K. Prime Minsiter’s second open letter on open data
https://www.gov.uk/government/news/letter-to-cabinet-ministers-on-transparency-and-open-data
U.K. Open Data Strategies ( by department)
http://data.gov.uk/open-data-strategies
Secretary of State’s Code of Practice (datasets) on the discharge of public authorities’ functions under Part 1 of the Freedom of Information Act
http://www.justice.gov.uk/downloads/information-access-rights/foi/code-of-practice-datasets.pdf
The World Wide Web Consortium (W3C)
OPEN DATA RESEARCH(Top)
An open data platform for improving Toronto transportation
http://news.engineering.utoronto.ca/an-open-data-platform-for-improving-toronto-transportation/
The Art and Science of Data-Driven Journalism (Tow Center for Digital Journalism)
http://towcenter.org/research/the-art-and-science-of-data-driven-journalism/
The Benefits of a Big Tent: Opening Up Government in Developing Countries
Big Data & Society
Chicago Tribune news apps blog
http://blog.apps.chicagotribune.com/
Council for Big Data, Ethics, and Society
Datalibre
David Eaves
Defining Open Government (by Beth Simone Noveck, U.S. Deputy Chief Technology Officer for Open Government)
Election Issues 2015: A Maclean’s primer on vanishing data
http://www.macleans.ca/politics/election-issues-2015-a-macleans-primer-on-vanishing-data/
Federal Open Government Guide
http://www.rcfp.org/rcfp/orders/docs/FOGG.pdf
How not to screw up your data (Noah Veltman)
http://veltman.tumblr.com/post/44638298912/how-to-not-screw-up-your-data
3rd International Open Data Conference 2015
Kate Crawford: Thinking about data
Nick Diakopoulos
http://www.nickdiakopoulos.com/
Open Government Analytics
http://open.canada.ca/en/content/open-government-analytics
Open Data Policy Comparison: Best Practices https://docs.google.com/spreadsheet/ccc?key=0Ap0CEAgs-R_odFc0Qk1WNHdIUDE3bUNVd1U3WUlnblE&usp=drive_web#gid=8
Open Data Institute (U.K)
Open Data Research Symposium: Shaw Centre, Ottawa, May 27th 2015
http://www.digitaljournal.com/pr/2563300
Open Government: Collaboration, Transparency, and Participation in Practice
http://www.amazon.ca/Open-Government-Collaboration-Transparency-Participation/dp/0596804350
http://radar.oreilly.com/2013/01/open-government-files-released.html
Open data: Unlocking innovation and performance with liquid information
Open Data User Group (the U.K.)
https://www.gov.uk/government/groups/open-data-user-group
Oxford Internet Institute
Predicting Fire Risk: From New Orleans to a Nationwide Tool
http://datasmart.ash.harvard.edu/news/article/predicting-fire-risk-from-new-orleans-to-a-nationwide-tool-846
“Raw Data Is An Oxymoron”
http://www.amazon.com/dp/0262518287
Research project: Open Data Barometer (World-wide)
http://www.opendataresearch.org/project/2013/odb
Speaking notes for the Honourable Tony Clement, President of the Treasury Board, to the International Open Data Conference
http://news.gc.ca/web/article-en.do?mthd=advSrch&crtr.page=1&crtr.dpt1D=6694&nid=981299
The New Ambiguity of ‘Open Government’ (Social Science Research Network)
http://papers.ssrn.com/sol3/papers.cfm?abstract_id=2012489
The Rhetoric of Data (Nicholas Diakopoulos, Tow Center for Digital Journalism)
http://towcenter.org/the-rhetoric-of-data/
SELKIRK COLLEGE SHEDS LIGHT ON OPEN DATA AT GIS DAY
http://boundarysentinel.com/news/selkirk-college-sheds-light-open-data-gis-day-43118#.WCm5-S0rInk
UK open government data: the results of the official audit
http://www.theguardian.com/news/datablog/2012/apr/18/uk-open-government-data-national-audit-office
Welcome to the Big Data and Social Research Roundup
http://info.sagepub.com/q/1f4FAZ5J0wZXduOm5SdGJ02/wv
Wikibon Blog
http://wikibon.org/blog/big-data-statistics/
Why the wealthiest countries are also the most open with their data (The Washington Post)
OPEN DATA STORIES(Top)
A big win for open government: Sunlight gets U.S. to release indexes of federal data
http://sunlightfoundation.com/blog/2015/02/09/a-big-win-for-open-government-sunlight-gets-us-to-release-indexes-of-federal-data/
Alberta government offering prize for app design
http://www.edmontonsun.com/2015/07/17/alberta-government-offering-prize-for-app-design
Alberta’s open data catalogue rapidly expands, spawning dozens of new apps
Alberta parents show a love of the land when naming their kids. Say hello to Mountain and Prairie.
Bike theft: Toronto’s worst streets to lock up your wheels
Bringing Canada’s access to information back from the brink
CANADA RANKS NO. 2 IN GLOBAL OPEN DATA INDEX
http://www.canadait.com/index.php/c-level-insight/2163-canada-ranks-no-2-in-global-open-data-index
Chrétien’s nemesis is back – and that’s good for access to information
City hoping to use open data to appeal to province for cash
http://www.inews880.com/syn/110/139585/139585
City data opens up; machine-readable documents available on Open Data site
City of Calgary officials eye tailoring services to better suit taxpayers’ needs
City of Lethbridge launches innovative Open Data Catalogue online
http://globalnews.ca/news/2364381/city-of-lethbridge-launches-innovative-open-data-catalogue-online/
City of Windsor Recognized As Open Data Trailblazer
http://windsorite.ca/2016/01/city-of-windsor-recognized-as-open-data-trailblazer/
https://www.publicsectordigest.com/articles/view/1547
David Alston eyes province as leader in digital society
http://www.cbc.ca/news/canada/new-brunswick/open-data-summit-david-alston-1.3555640
DriveBC data now online and open for business
http://www.voiceonline.com/drivebc-data-now-online-and-open-for-business/
Government to implement sunshine list this fallhttp://www.thetelegram.com/News/Local/2016-06-07/article-4552635/Government-to-implement-sunshine-list-this-fall/1
Government of Canada shows global leadership on open government
http://finance.yahoo.com/news/government-canada-shows-global-leadership-193508517.html
Greater Sudbury: City debuts open data
http://www.thesudburystar.com/2015/07/15/city-debuts-open-data
City’s 311 hotline faces a new challenge: suicide calls
Communitech to launch Open Data Exchange in Waterloo
http://www.therecord.com/news-story/5633195-communitech-to-launch-open-data-exchange-in-waterloo/
Grey County opens up with new Open Data initiative
http://www.simcoe.com/news-story/5633152-grey-county-opens-up-with-new-open-data-initiative/
Calgary-based app maps out sports fields and courts
http://metronews.ca/news/calgary/1372887/calgary-based-app-maps-out-sports-fields-and-courts/
Edmonton launches 311 explore website
http://www.edmontonsun.com/2015/02/19/edmonton-launches-311-explore-website
Edmonton’s open data initiatives rank #1 among 34 Canadian cities
http://globalnews.ca/news/2456703/edmontons-open-data-initiatives-rank-1-among-34-canadian-cities/
Foodspect app puts the restaurant health inspector in the palm of your hand
http://www.cjob.com/syn/112/184422/foodspect-app-warns-of-bad-restaurants
ESRI SUPPORTS WHITE HOUSE POLICE DATA INITIATIVE
http://www.digitaljournal.com/pr/2826243
GRT buses miss the mark 20 per cent of the time
http://www.therecord.com/news-story/5812751-grt-buses-miss-the-mark-20-per-cent-of-the-time/
City’s new portal makes accessing data sets easier
http://guelph.ca/2016/03/citys-new-portal-makes-accessing-data-sets-easier/
Federal prison death details so sparse that family grief deepens: study
http://www.680news.com/2016/07/28/federal-prison-death-details-so-sparse-that-family-grief-deepens-study/
Government data ‘not usable, not used or not acted upon’: auditor general
Halifax Transit rolls out test version of real-time bus location data
http://www.metronews.ca/news/halifax/2017/02/01/halifax-transit-test-version-of-real-time-bus-location-data.html
How open data can improve medicine
http://www.macleans.ca/society/how-open-data-can-improve-medicine/
How the quest for a bike collision map opened up city data in Edmonton
How to avoid Toronto’s parking ticket hot spots
https://www.thestar.com/news/gta/2016/05/15/how-to-avoid-torontos-parking-ticket-hot-splots.html
New portal eases access to city’s open data
http://www.therecord.com/news-story/6858379-new-portal-eases-access-to-city-s-open-data/
New Brunswick’s promised open data portal to launch next year
http://www.cbc.ca/news/canada/new-brunswick/new-brunswick-open-data-app-1.4266972
Mayor’s committee votes ‘yes’ to more open employee disclosure
http://www.metronews.ca/news/winnipeg/2016/09/14/winnipeg-committee-votes-yes-to-more-open-employee-disclosure.html
This Is How Visualizing Open Data Can Help Save Lives
Interactive map tracks rainfall in the Edmonton area in real time
http://globalnews.ca/news/2108542/interactive-map-tracks-rainfall-in-the-edmonton-area-in-real-time/
http://www.edmonton.ca/city_government/news/gauge-the-storm-with-rainfall-data.aspx
Harper Government Announces Funding to Establish the Open Data Exchange
http://www.techvibes.com/blog/open-data-exchange-2015-05-20
How the quest for a bike collision map opened up city data in Edmonton
How Unique is the New U.S. Open Data Policy?https://sunlightfoundation.com/blog/2013/05/13/how-unique-is-the-new-u-s-open-data-policy/
Laval starts Open Data policy
Let’s get serious about open government
http://www.thecoast.ca/halifax/lets-get-serious-about-open-government/Content?oid=5442719
EDITORIAL: Let the sun shine on government information
Local real estate group creates open data map showing how Edmonton has grown in size
http://www.hometribe.ca/city-of-edmonton-building-age-map
London among top five cities for providing data
http://www.lfpress.com/2016/01/15/london-among-top-five-cities-for-providing-data
Lowertown group pushes for neighbourhood crime data
Local schools open to data
http://www.sherwoodparknews.com/2015/05/28/local-schools-open-to-data
National open data summit to be held in Saint John Thursday
http://www.cbc.ca/news/canada/new-brunswick/open-data-summit-saint-john-1.3553229
New online portal opens city data
http://www.brantfordexpositor.ca/2016/10/21/new-online-portal-opens-city-data
New study finds HRM still lagging behind in public transparency
New York City Transit Authority Takes a Ride with OpenText
New Vancouver website will help renters find good landlords
http://globalnews.ca/news/2010721/new-vancouver-website-will-help-renters-find-good-landlords/
News from the Office of Statistics and Information (OSI)
http://www.finance.alberta.ca/aboutalberta/osi/index.html
Make Ottawa crime data more open, says U of O professor
http://www.metronews.ca/news/ottawa/2016/08/03/law-professor-says-ottawa-crime-data-should-be-open.html
Making government information more accessible
Missed garbage pickup complaints rise in east, fall in west
Montreal embraces new ‘open by default’ data policy
http://montrealgazette.com/news/local-news/montreal-embraces-new-open-data-policy
Montreal police to release more crime data
http://www.cbc.ca/news/canada/montreal/montreal-police-open-data-1.3555343
Montréal, Smart and Digital City – Reform of the Open Data Policy: Montréal adopts an “open by default” approach
Montreal spent $120K on employees’ travel expenses in 2 years
More than 30,000 parking tickets worth over $1.4 million issued at UTSG, UTSC
http://thevarsity.ca/2016/07/17/more-than-30000-parking-tickets-worth-over-1-4-million-issued-at-utsg-utsc/
NCC looking to ‘push the envelope’ on openness, CEO says
http://ottawacitizen.com/news/local-news/mark-kristmanson-shares-thoughts-on-ncc
Nova Scotia launches open data portal
New map explores the mysteries of Edmonton’s tax assessments
Obama promotes online search tool with college-specific data to aid families in school choice
‘One size fits all’ an outdated approach to city services, says top Calgary bureaucrat
Online Parry Sound business directory officially launched
Open data — Canada’s ‘new natural resource’ — proves harder to mine than expected
http://business.financialpost.com/fp-tech-desk/open-data-canadas-new-natural-resource-proves-harder-to-mine-than-expected
Open data on P.E.I. ‘a great start’
http://www.cbc.ca/news/canada/prince-edward-island/pei-open-data-1.3634672
‘Open data’: Why it’s making waves across Canada
http://www.cbc.ca/news/technology/open-data-movement-canada-1.3557562
Ontario Deficit $2.2 Billion Lower Than Projected
http://news.ontario.ca/tbs/en/2015/09/ontario-deficit-22-billion-lower-than-projected.html
Ontario unions behind 94 per cent of third-party ad spending in past three election
http://www.theglobeandmail.com/news/national/ontario-unions-behind-94-per-cent-of-third-party-ad-spending-in-past-three-elections/article31326097/
Open Data Exchange aimed at helping firms commercialize public sector data sets
Open government at a crossroad: Canada needs better funding and access to information reform
Open Data Portal Launched
http://novascotia.ca/news/release/?id=20160205001
Ontario Making Data Open by Default:New Open Data Directive Drafted with Feedback from Ontarians
http://news.ontario.ca/tbs/en/2015/11/ontario-making-data-open-by-default.html
Open government manager puts his Best face forward
http://www.guelphmercury.com/news-story/5816017-open-government-manager-puts-his-best-face-forward/
Ottawa flush with new toilet-finder apps
http://www.metronews.ca/news/ottawa/2016/03/28/ottawa-city-flush-with-new-toilet-locator-apps.html
P.E.I. landmarks project looking for public input
http://www.cbc.ca/news/canada/prince-edward-island/landmarks-open-data-map-1.3332428
Police open data site lets citizens track crimes
http://montrealgazette.com/news/local-news/police-open-data-site-lets-citizens-track-crimes
Premier issues order to save emails after blistering report
http://www.timescolonist.com/premier-issues-order-to-save-emails-after-blistering-report-1.2093960
Premier launches New Brunswick’s open data policy
http://www2.gnb.ca/content/gnb/en/news/news_release.2016.04.0334.html
Prime Minister Releases Guide for Ministers
http://www.marketwired.com/press-release/prime-minister-releases-guide-for-ministers-2077429.htm
http://pm.gc.ca/eng/news/2015/11/27/open-and-accountable-government
Promises of transparency easily eroded
Province Making Advances in Open Data
http://novascotia.ca/News/Release/?id=20150619004
Publish salaries, but no names say N.L. teachers as union prepares court challenge
Pulling apart Pallister’s ‘open government’
Saint John launches open data pilot program for the public
http://www.cbc.ca/news/canada/new-brunswick/saint-john-open-data-program-1.3299609
Science and Tech museums’ documents to be ‘open by default’ by fall, CEO pledges
http://ottawacitizen.com/news/local-news/science-and-tech-museums-documents-to-be-open-by-default-by-fall-ceo-pledges
Set the data free, Mr. Trudeau
https://ipolitics.ca/2015/12/08/set-the-data-free-mr-trudeau/
Small startup seizes opportunity with big data
http://www.thespec.com/news-story/5652398-small-startup-seizes-opportunity-with-big-data/
Stephen Gordon: There’s more to evidence-based policymaking than fixing the census
‘Sunshine List’ law introduced to the House of Assembly
http://www.cbc.ca/news/canada/newfoundland-labrador/sunshine-list-law-introduced-1.3894380
Sunlight Foundation Open Data Site
https://sunlightfoundation.com/blog/
Tenants will be able to see how their buildings did on fire inspections by end of year
http://www.metronews.ca/news/toronto/2017/10/13/tenants-will-be-able-to-see-how-their-buildings-did-on-fire-inspections-by-end-of-year.html
The 100 WORST landlords in Toronto
Tax burden getting heavier by the year
The way media and police report Edmonton’s pedestrian collisions a problem, says advocate
This online tool lets you check your city’s air quality in real time
http://www.cantechletter.com/2015/12/check-your-citys-air-quality-using-plume-labs-free-app/
Toronto joins cities around the world in celebrating Open Data Day 2016
Toronto’s Burgeoning Civic Tech Community
http://torontoist.com/2016/03/torontos-burgeoning-civic-tech-community/
Toronto at the Centre of the Race To Save Climate Change Data from Trump
http://torontoist.com/2017/04/toronto-centre-race-save-climate-change-data-trump/
Guerrilla Archiving Event: Saving Environmental Data from Trump
Trudeau must do a better job of connecting with Canadians online: memos
UWindsor research team working to predict border delays
http://www.ourwindsor.ca/news-story/5788960-uwindsor-research-team-working-to-predict-border-delays/
Vancouver makes Council voting records public
http://www.voiceonline.com/vancouver-makes-council-voting-records-public/
Vanishing Canada: Why we’re all losers in Ottawa’s war on data
http://www.macleans.ca/news/canada/vanishing-canada-why-were-all-losers-in-ottawas-war-on-data/
Visualization, analysis, interactive maps and real-time graphics: HUFFPOST DATA
http://data.huffingtonpost.com/
Weird and wonderful ways Open Data is unearthing Edmonton information
http://globalnews.ca/news/3649702/weird-and-wonderful-ways-open-data-is-unearthing-edmonton-information/
We Mapped the City’s 311 Requests
http://torontoist.com/2016/11/388770/
What are the worst places to park in Canada? Here’s the data on that
http://www.cbc.ca/news/business/marketplace-parking-tickets-canada-nov-17-1.3854094
Why I Co-Created an App to Better Understand Toronto’s Budget
http://torontoist.com/2016/11/budgetpedia/
Website coming to Vancouver will help renters find good landlords
http://globalnews.ca/news/2010721/new-vancouver-website-will-help-renters-find-good-landlords/
Waning Calgary pedestrian collision stats show potentially costly hysteria overblown
What does a Liberal government mean for Canada’s technology policy?
or visit http://www.itworldcanada.com for more Canadian IT News
Why do downtown councillors get all the online attention?http://www.thestar.com/news/city_hall/2015/07/17/why-do-downtown-councillors-get-all-the-online-attention.html
Winning apps make government data more accessible
http://www.stonyplainreporter.com/2015/08/21/winning-apps-make-government-data-more-accessible
OPEN REFINE(Top)
OpenRefine
http://openrefine.org/
OpenRefine – Recipes
https://github.com/OpenRefine/OpenRefine/wiki/Recipes
OpenRefine – Stripping HTML
https://github.com/OpenRefine/OpenRefine/wiki/StrippingHTML
RefinePro Knowledge Base for OpenRefine
http://kb.refinepro.com/2015/02/parsing-and-extracting-html-tag-and.html
PEOPLE FINDERS(TOP)
Accurint (LexisNexis)
Spokeo
Facebook Graph Search is a “journalist’s rolodex”
http://socialtimes.com/facebooks-vadim-lavrusik-on-why-facebook-is-a-journalists-rolodex_b125949
LinkedIn for Journalists
http://www.linkedin.com/groups/LinkedIn-Journalists-3753151
FAIR ( Federal Accountability Initiative for Reform)
Blue Book (University of Toronto)
http://www.bluebook.utoronto.ca/
Exerpts on Call (University of Ottawa)
http://www.media.uottawa.ca/mediaroom/experts.html
Experts on Call (Carleton University)
http://newsroom.carleton.ca/experts/
Experts on Call (Dalhousie University)
Ixquick International Phone Books
Canada 411
http://canada411.sympatico.ca/
411.ca
Find a Postal Code (Canada Post)
http://www.canadapost.ca/cpotools/apps/fpc/personal/findByCity?execution=e1s1
YellowPages.ca
VitalCheck (a source for U.S. government-certified vital records)
Area Code Listing, by Number
http://www.bennetyee.org/ucsd-pages/area.html
PeopleSearch.net
Legacy.com (obituary searches)
Omgili forum search engine
Icerocket
Thoora
AnyWho directory
http://www.anywho.com/international.html
Free Public Records (access to more than 5,000 U.S. public record databases)
http://publicrecords.searchsystems.net
Obituaries
http://www3.sympatico.ca/bkinnon/obit_links2.htm
http://obits.rootsweb.com/cgi-bin/obit.cgi
Usenet archives
http://usenet-addresses.mit.edu/
Bar-eX ( property searches in Ontario )
https://www.bar-ex.com/barex/appmanager/bx/on?_nfpb=true&_pageLabel=services
IPAddressGuide.com
http://www.ipaddressguide.com/
IP Address Lookup
What is my IP address
Flickr.com
Myspace
Xanga
Friendster
Twitter tools
Yoname
Canada Background Checks
http://www.infocheckusa.com/canada-background-check.htm
eFindOutTheTruth.com (A Canadian site described as a “do-it-yourself “net-detective” software or unlimited “membership” type of company”)
http://www.efindoutthetruth.com/canada.htm
BackCheck (A Canadian site described as specializes in pre-employment background checks, including Criminal Record Checks, Credit Bureau Inquiries)
Lifenews.ca
http://www.lifenews.ca/waterloorecord/home
PHOTOJOURNALISM(TOP)
Canadian Association of Journalists’ 2003 photojournalism award
http://www.caj.ca/mediamag/awards2004/cajAwards/theAwards/08_photoJ/index.html
Canadian Association of Journalists’ 2004 photojournalism award
http://www.caj.ca/mediamag/awards2005/Pages/Photojournalism.htm
Canadian Association of Journalists’ 2005 photojournalism award
http://www.caj.ca/mediamag/awards2006/pages/Photojournalism.htm
Canadian Association of Journalists’ 2006 photojournalism award
Louie Palu
Sports Shooter
http://www.sportsshooter.com/members.html?id=965
The best photographs of 2008
http://www.j-source.ca/english_new/detail.php?id=3134
Sarah Moffat Imagery
http://www.sarahmoffatimagery.com/
World Press Photo
http://www.worldpressphoto.org/?bandwidth=high
World Press Photo
http://www.enterworldpressphoto.org/
Mundo Sport Images
http://www.mundosportimages.com/
POLITICS(TOP)
The Hill ( a blog on U.S. politics )
PolitiFact.com
POLLING(TOP)
Evaluating the Polls: an Open Letter to Ontario’s Journalists (an article on the Ipsos website)
http://www.ipsos-na.com/news-polls/pressrelease.aspx?id=5336
Fundamentals of Polling-Glossary of Terminology
http://www.ropercenter.uconn.edu/education/polling_fundamentals_glossary.html
POPULATION STATISTICS(TOP)
Census profile (Statistics Canada)
http://www12.statcan.ca/census-recensement/2011/dp-pd/prof/index.cfm?Lang=E
City Population
http://www.citypopulation.de/Canada.html
Registered Indian Population by Sex and Residence 2012
https://www.aadnc-aandc.gc.ca/eng/1373985023065/1373985196078
Selected trend data for Canada, 2006, 2001 and 1996 censuses (Statistics Canada)
Statistics Canada census data ( from 2001 and 2006 censuses)
2011 Census topics and release dates
http://www12.statcan.ca/census-recensement/2011/rt-td/rt-td-eng.cfm
Population by year, by province and territory (Statistics Canada)
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/demo02a-eng.htm?sdi=population
Population of census metropolitan areas (Statistics Canada)
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/demo05a-eng.htm
Statistics Canada (population and dwelling counts)
http://www12.statcan.ca/english/census06/data/popdwell/Tables.cfm
City of Ottawa (population stats)
Ottawa neighborhood information (The University of Ottawa)
http://www.geomatics.uottawa.ca/movies/naborhoods/mapindex.html
Nova Scotia Community Counts
http://www.gov.ns.ca/finance/communitycounts/default.asp
Census.IRE.ORG (Download bulk U.S. census data)
http://census.ire.org/data/bulkdata.html
UNHCR population statistics
http://popstats.unhcr.org/PSQ_POC.aspx
PREPARING STORIES(TOP)
Interviewing Tips
http://www.concernedjournalists.org/node/94
Interviewing
http://www.journalism.org/resources/tools/reporting/interviewing/tips.asp?from=print
Revelations from the Rocket on ’60 Minutes?’ Not likely (A John Swatsky analysis)
http://sports.espn.go.com/mlb/columns/story?id=3181572
Writing
http://www.nytimes.com/learning/general/specials/weblines/4.html
Carleton University Style Guide
http://newsroom.carleton.ca/wp-content/files/writing-style-guide.pdf
George Orwell’s Six Rules
To find Orwell’s rules, please click here.
The story process
http://www.journalism.org/resources/tools/writing/lessons/blackbox.asp?from=print
We are storytellers
PowerPoint presentation on getting away from numbers in order to tell great stories
Accuracy checklist
http://www.journalism.org/resources/tools/reporting/accuracy/mercury.asp?from=print
Grammar and punctuation
http://www.yorku.ca/ycom/style/
http://www.snn-rdr.ca/snn/nr_reporterstoolbox/snnstyleguide.html
Journalism ethics
http://www.poynter.org/subject.asp?id=32
Journalism Ethics Morals and the Media, 2nd edition, by Nick Russell (sample chapter)
http://www.ubcpress.ca/books/pdf/chapters/russell.pdf
Journalism Ethics for the Global Citizen (UBC School of Journalism)
http://www.journalismethics.ca/about_us/index.htm
The Canadian Press’s Copy Talk
http://www.thecanadianpress.com/books.aspx?id=186&terms=&searchtype=1&fragment=False
Don Gibb’s writing columns for Media magazine
PROVINCIAL AUDITS(TOP)
Alberta
British Columbia
http://www.bcauditor.com/auditorgeneral.htm
Manitoba
New Brunswick
Newfoundland and Labrador
Northwest Territories
Nova Scotia
Nunavut
http://www.gov.nu.ca/finance/public.shtml
Ontario
Prince Edward Island
http://www.assembly.pe.ca/auditorgeneral/
Quebec
Saskatchewan
Yukon
http://www.yukonenergy.ca/about/business/auditor_reports
PRIVACY(TOP)
Amendments to the Canadian Radio-television and Telecommunications Commission Act, the Competition Act, the Personal Information Protection and Electronic Documents Act and the Telecommunications Act
http://laws-lois.justice.gc.ca/eng/acts/E-1.6/page-1.html#docCont
Access Now
The best defense: How to improve your digital security
http://passcode.csmonitor.com/theweb#chapter-2005113
B.C. Civil Liberties Association: Privacy Handbook
http://bccla.org/privacy-handbook/index.html
Canada’s Anti-Spam Legislation
http://fightspam.gc.ca/eic/site/030.nsf/eng/home
Canadian Internet Policy and Public Interest Clinic
Consumer Sentinel Network
https://www.ftc.gov/enforcement/consumer-sentinel-network
Canadian Privacy Law Blog
Center for Democracy & Technology
Cornel Unversity Law School
https://www.law.cornell.edu/wex/inbox/state_anti-spam_laws
Electronic Frontier Foundation: Defendening Your Rights In The Digital World
Electronic Privacy Information Center
Ghostery
Global Privacy Enforcement Network (GPEN)
https://www.privacyenforcement.net/
KNOW YOUR RIGHTS: PHOTOGRAPHERS – WHAT TO DO IF YOU ARE STOPPED OR DETAINED FOR TAKING PHOTOGRAPHS
IOT Agenda (Intenet of Things)
http://internetofthingsagenda.techtarget.com/definition/Internet-of-Things-IoT
Online Privacy
https://www.priv.gc.ca/resource/op-vpel/index_e.asp
Privacy Badger
chrome-extension://pkehgijcmpdhfbdbbnkijodmdjhbjlgp/skin/firstRun.html
Privacy and Social Media in the Age of Big Data: Report of the Standing Committee on Access to Information, Privacy and Ethics
https://www.documentcloud.org/documents/2697380-PRIVACY-and-SOCIAL-MEDIA.html
List of Witnesses for Standing Committee hearings
The Photographer’s Right
http://www.krages.com/ThePhotographersRight.pdf
Public Interest Advocacy Centre
Reuters Institute Digital News Report 2015_Full Report.pdf
RuinMyHistory
https://github.com/FascinatedBox/RuinMyHistory
Technology, Thoughts & Trinkets
https://www.christopher-parsons.com/
The Personal Information Protection and Electronic Documents Act (PIPEDA)
https://www.priv.gc.ca/leg_c/leg_c_p_e.asp
Top 15 Most Popular Social Networking Sites | April 2016
http://www.ebizmba.com/articles/social-networking-websites
Your Right To Privacy: Minimize Your Digital Footprint
https://www.chapters.indigo.ca/en-ca/books/your-right-to-privacy-minimize/9781770402638-item.html
United States Department of Justice
http://www.justice.gov/usao/resources/making-foia-request/foia-frequently-asked-questions
PROVINCIAL CONTRACTS(TOP)
Alberta
http://vendor.purchasingconnection.ca/
British Columbia
http://www.bcbid.gov.bc.ca/open.dll/welcome
Quebec
https://www.seao.ca/index.aspx
Saskatchewan
http://www.sasktenders.ca/index.html
PROVINCIAL GOVERNMENTS(TOP)
http://www.canada.gc.ca/othergov/prov_e.htm
Government of Alberta (International Travel Expenses)|
http://alberta.ca/expenditure/expenditure.cfm?id=0
Links to provincial government directories
http://canadaonline.about.com/od/govtdirectories/Canadian_Government_Directories.htm
B.C. Online
https://www.bconline.gov.bc.ca/
Alberta Legislative Assembly
http://www.assembly.ab.ca/net/index.aspx?p=adr_home
British Columbia Legislative Assembly
Manitoba Legislative Assembly
http://www.gov.mb.ca/legislature/hansard/
Newfoundland and Labrador House of Assembly
http://www.hoa.gov.nl.ca/hoa/business/
New Brunswick Legislative Assembly
http://www.gnb.ca/legis/business/currentsession/currentsession-e.asp
Nova Scotia Legislative Assembly
http://www.gov.ns.ca/legislature/house_business/hansard.html
Northwest Territories Legislative Assembly
http://www.assembly.gov.nt.ca/hansard/
Nunavut Legislative Assembly
http://www.assembly.nu.ca/english/index.html
Ontario Legislative Assembly
http://www.ontla.on.ca/hansard/
http://www.ontla.on.ca/web/house-proceedings/house_current.do
Prince Edward Island Legislative Assembly
http://www.assembly.pe.ca/hansard/
Quebec National Assembly
Saskatchewan Legislative Assembly
http://www.legassembly.sk.ca/hansard/
Yukon Legislative Assembly
PUBLIC ACCOUNTS(TOP)
Public Accounts ( Federal )
http://www.tpsgc-pwgsc.gc.ca/recgen/cpc-pac/2014/index-eng.html
http://open.canada.ca/data/en/dataset?q=public+accounts
Public Accounts ( Ontario )
https://www.ontario.ca/page/public-accounts-ontario
Lapsed federal spending $2B higher than expected last year
http://www.cbc.ca/news/politics/lapsed-federal-spending-2b-higher-than-expected-last-year-1.3359378
Tories left $9.5 billion in approved funds untouched to avoid deficit during election year
Military lost $1.5 million in uniforms last year
PUBLIC HEALTH(TOP)
DineSafe (the city of Toronto’s Food Premises Inspection and Disclosure System)
http://app.toronto.ca/food2/index.jsp
Community Acquired Infections Division (The Public Health Agency of Canada)
http://www.phac-aspc.gc.ca/std-mts/sti-its_tab/index-eng.php
http://www.phac-aspc.gc.ca/std-mts/sti-its_tab/chlamydia1991-07-eng.php
http://www.phac-aspc.gc.ca/std-mts/sti-its_tab/gonorrhea1980-07-eng.php
http://www.phac-aspc.gc.ca/std-mts/sti-its_tab/syphilis1993-07-eng.php
http://www.phac-aspc.gc.ca/std-mts/stdcases-casmts/cases-cas-08-eng.php
Reportable Diseases by Year for Ottawa Residents (The city of Ottawa)
PUBLICATION FINDERS(TOP)
bNet
http://findarticles.com/p/articles/an_1/?tag=wrapper;width
PUBLIC POLICY ORGANIZATIONS(TOP)
Atlantic Institute for Market Studies
http://www.aims.ca/en/home/default.aspx
Asia Pacific Foundation of Canada
http://www.asiapacific.ca/
Balsillie School of International Affairs
https://www.balsillieschool.ca/
Bennett Jones
Canadians for Tax Fairness
http://www.taxfairness.ca/front
Canadian Policy Research Networks
Canadian Centre for Policy Alternatives
http://www.policyalternatives.ca/
Canadian Institute for Advanced Research
Canada Institute
https://www.wilsoncenter.org/program/canada-institute
Centre for International Policy Studies ( Universit of Ottawa)
Institute for Research on Public Policy
http://www.irpp.org/index_en.php
International Institute for Sustainable Development
http://www.iisd.org/
Institute For Security Studies
https://www.issafrica.org/
The Canadian Taxpayers Federation
http://www.taxpayer.com/main/index.php
The Fraser Institute
http://www.fraserinstitute.ca/
The C.D. Howe Institute
http://www.fraserinstitute.ca/
The Macdonald-Laurier Institute for Public Policy
http://www.macdonaldlaurier.ca/about/who-we-are/
Migration Policy Institute
http://www.migrationpolicy.org/
http://www.migrationpolicy.org/data/unauthorized-immigrant-population/state/US
The Polaris Institute
http://www.polarisinstitute.org/
The Parkland Institute
http://www.ualberta.ca/~parkland/
Policy Monitor Canada
Public Policy Options
http://policyoptions.irpp.org/author/emacfarlane/
OpenMedia.ca
Congressional Research Service (The “Congress’s think tank” is the public policy research arm of the United States)
Congressional Budget Office (Provides economic data to the U.S. Congress)
Government Accountability Office (the audit, evaluation and investigative arm of the U.S. Congress)
The British Psychological Society
http://www.bps.org.uk/publications/journals
Urban Worker Project
http://www.urbanworker.ca/
The Wilson Center
https://www.wilsoncenter.org/
READINGS(TOP)
Working the fringes
http://www.cjr.org/issues/2005/6/cunningham.asp
Journalism trends in Canada
Public journalism in a Canadian context
The elements of journalism
http://www.journalism.org/resources/publications/books/elements_intro.asp
The quest for context
http://www.caj.ca/mediamag/winter2002/tools.html
Inspiration
Tips for rediscovering your passion for story telling
`Right to Know’ Series — Toronto Star
Please click here to read the articles
Report Card on Canadian News Media
http://www.cmrcccrm.ca/english/reportcard2004/01.html
2005 Report on state of the media
http://www.stateofthenewsmedia.org/2005/index.asp
2008 List of Banished Words
http://www.lssu.edu/banished/discuss/?p=20
Banishment Word List Archive
http://www.lssu.edu/banished/archived_lists.php
Election Coverage
http://www.ompp.mcgill.ca/pages/2006election.htm
SCIENCE(TOP)
Science Media Centre of Canada (SMCC)
http://www.sciencemediacentre.ca/smc/index.php?lang=en
Social Science and Humanities Research Council of Canada (SSHRC)
http://www.sshrc.ca/web/home_e.asp
The Canadian Research Information System
http://webapps.cihr-irsc.gc.ca/cris/Search?p_language=E&p_version=CRIS
Science-related search engines ( in French and English )
http://sdis.inrs.uquebec.ca/index.jsp?page=5_3#statistiques
The National Academies Press (U.S)
SEARCH AND RESCUE(TOP)
Civil Air Search and Rescue Association
Canadian Beacon Registry
https://www.cbr-rcb.ca/cbr/presentation/other_autre/index.php?lang=en
Canadian Owners and Pilots Association
International Cospas-Sarsat Programme
https://www.cospas-sarsat.org/
International Cospas-Sarsat Programme Beacon Regulations
http://www.cospas-sarsat.org/en/cospas-sarsat-documentation/sdocs
National Search and Rescue Secretariat
http://www.nss-snrs.gc.ca/en/index.page
National Oceanic and Atmospheric Administration Search and Rescue Satellite Aided Tracking
http://www.sarsat.noaa.gov/406vs121.pdf
Quadrennial Search and Rescue Review – Report
Fixed-Wing Search and Rescue Aircraft Replacement (FWSAR) Project
http://www.tpsgc-pwgsc.gc.ca/app-acq/stamgp-lamsmp/svtvn-rscfw-eng.html
SEARCHABLE ONLINE WEBSITES(TOP)
Adverse Events (A U.S. website that tracks adverse drug reactions in real time)
http://www.adverseevents.com/drugs.php
Drug and health product inspections
SearchSystems.net
Arms Exports (Industry Canada)
http://strategis.ic.gc.ca/sc_mrkti/tdst/tdo/tdo.php#tag
Arms Exports ( Foreign Affairs and International Trade Canada)
Canadian Environmental Assessment Registry
http://www.ceaa-acee.gc.ca/050/index_e.cfm
Charities (Note: click on the “Download results” tab on the left-hand side inorder to save the database)
http://www.cra-arc.gc.ca/ebci/haip/srch/sec/SrchInput01Validate-e#pageControl
Elections Canada
http://www.elections.ca/scripts/webpep/fin/select_search_option.aspx
Federal Contaminated Sites Inventory
http://www.tbs-sct.gc.ca/fcsi-rscf/home-accueil.aspx?Language=EN&sid=wu825155318360
Health Canada’s Adverse Drug Reaction Database
http://www.hc-sc.gc.ca/dhp-mps/medeff/databasdon/index-eng.php#a1
Health Canada’s Drug Product Database
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/databasdon/index_e.html
Lobbyists ( registered with the federal government )
Rapid Fire ( the Ottawa Citizen’s searchable online gun registry database )
http://www.canada.com/ottawacitizen/features/rapidfire/form.html
Transport Canada (Air safety)
http://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/q.aspx?lang=eng
Vehicle recalls on-line database ( Transport Canada )
http://wwwapps.tc.gc.ca/Saf-Sec-Sur/7/VRDB-BDRV/search-recherche/menu.aspx?lang=eng
Vehicle recalls on-line database (Department of Transportation)
http://www-odi.nhtsa.dot.gov/recalls/recallsearch.cfm
http://www-odi.nhtsa.dot.gov/downloads/index.cfm
DineSafe (the city of Toronto’s Food Premises Inspection and Disclosure System)
http://app.toronto.ca/food2/index.jsp
Data Planet (The Data Planet is a resource for searchable databases or interactive maps from the Pioneer Press, government agencies and non-profit organizations.)
http://www.twincities.com/dataplanet
Publc Service Staff Relations Board (search decisions)
SEARCH ENGINE RESEARCH(TOP)
Research Strategies: Finding Your Way through the Information Fog. William B. Badke. 2d ed. iUniverse, 2004.
http://www.acts.twu.ca/lbr/preface.htm
Search Engine Watch
DegreeTutor
http://www.degreetutor.com/library/research-tools/librarian-searchguide
Lycos
http://www.lycos.com/info/search-engines-list.html
SECURITY(TOP)
Currently listed entities (Public Safety Canada’s list and explanation of
terror groups)
http://www.publicsafety.gc.ca/cnt/ntnl-scrt/cntr-trrrsm/lstd-ntts/crrnt-lstd-ntts-eng.aspx
FRACTURED LANDS: HOW THE ARAB WORLD CAME APART
http://www.nytimes.com/interactive/2016/08/11/magazine/isis-middle-east-arab-spring-fractured-lands.html?smid=tw-nytmag&smtyp=cur&_r=0
SENIOR’S CARE(TOP)
Offlimits (CBC News investigation into the continued use of atypical antipsychotics in seniors)
http://www.cbc.ca/news/background/seniorsdrugs/off-limits.html
http://www.cbc.ca/health/story/2009/01/09/anti-psychotic-risks.html?ref=rss
Beaten Down: Fear and Violence in Canada’s Nursing Homes (CBC News investigation into nursing homes)
http://www.cbc.ca/news/background/nursing-homes/index.html
Advocates call for inquiry into nursing home chain collapse
http://www.cbc.ca/canada/story/2009/03/23/ontario-royal-crest-nursing-home.html
Care and Attention (Vancouver Sun investigation into nursing homes)
http://www.canada.com/vancouversun/features/care/index.html
Long-Term Care Medical Directors Association of Canada
Reports on Long-Term Care Homes ( Ontario )
http://publicreporting.ltchomes.net/en-ca/default.aspx
Quebec long-term care inspections
http://www.msss.gouv.qc.ca/sujets/organisation/visites_appreciation/visites.php
The Ministère de la Famille et des Aînés (Quebec)
Residential care facilities ( B.C. )
http://www2.vpl.vancouver.bc.ca/DBs/RedBook/orgPgs/3/3248.html
The Care Guide (calls itself “Canada’s most comprehensive guide to seniors’ housing and care services”)
http://www.thecareguide.com/Search.aspx
Aging and Seniors (Public Health Agency of Canada)
http://www.phac-aspc.gc.ca/seniors-aines/index_pages/aboutus_e.htm
Elder Advocates Of Alberta Society
http://www.elderadvocates.ca/index.php
The Canadian Institute for Health Information (nursing home study)
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=PG_1170_E&cw_topic=1170&cw_rel=AR_2129_E
MEDICARE, The Official U.S. Government Site for People with Medicare
The Canadian Institute for Health Information (nursing home study)
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=PG_1170_E&cw_topic=1170&cw_rel=AR_2129_E
The Senior Brigade (A Michigan Seniors’ website)
SOCIAL MEDIA(TOP)
HerdictWeb (A Harvard University project chronicling potential censorship of the Web around the world)
Renesys (Internet monitoring firm)
Dipity
Storify
Storyful
ComScore
PoliTwitter (Track what federal politicians are saying on social media)
Archiving tweets isn’t as easy as it seems (Reporter’s Lab)
http://www.reporterslab.org/twitter-archiver/
How Emergent founder Craig Silverman is using data to hunt down online hoaxes
SPORTS(TOP)
Canadian Interuniversity Sport
http://english.cis-sic.ca/information/members_info/research_stats
SPREADSHEET TUTORIALS(TOP)
A Brief History of Spreadsheets
http://www.cs.umd.edu/class/spring2002/cmsc434-0101/MUIseum/applications/spreadsheethistory1.html
http://dssresources.com/history/sshistory.html
Excel functions
https://support.office.com/en-us/article/Excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188
ExcelJedi
http://exceljedi.blogspot.ca/
How journalists can use Excel to organize data for stories (The Poynter Institute)
Finding Stories in Spreadsheets
https://leanpub.com/spreadsheetstories
Microsoft Support
Spreadsheet tutorial from CARinCanada
http://www.carincanada.ca/CARCANtips.htm
Reporters’ cookbook
http://forjournalists.com/cookbook/index.php?title=Main_Page
Experiments in Finance (Excel Function Tutorials)
http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/
How to use Excel – The top formulas and functions you need to know
https://www.avidian.com/resources/how-to-use-excel
Math for Journalists
http://www.newsu.org/courses/course_detail.aspx?id=nu_math05
InflationData.com
http://inflationdata.com/inflation/
Ozgrid.com
CARstat
http://www.unc.edu/~pmeyer/carstat/index.html
Spreadsheet tutorial from Computer-Assisted Reporting: A Pratical Guide, 3rd edition, by Brant Houston
http://www.ire.org/carbook/chapter3/referredData/crony.xls
Nilesonline (a simple guide to understanding statistics)
Spreadsheet tutorial
Introduction to spreadsheets
http://www.cmu.edu/computing/education/excel/Excel2003/index.htm
Daily Dose of Excel
Jon Peltier’s Excel Page
Pearson Software Consulting
http://www.cpearson.com/excel.htm
Stephen Bullen’s Excel Page
David McRitchie’s Excel Pages
www.mvps.org/dmcritchie/excel/excel.htm
Mr. Excel
About.com:Spreadsheets
Microsoft.public.excel
http://groups.google.ca/group/microsoft.public.excel/topics?lnk=sg&hl=en
The City of Ottawa budget in Excel format
STORIES ABOUT ACCESS TO INFORMATION(TOP)
Access to Information reforms fall short, pro-openness voices tell MPs
http://www.ctvnews.ca/politics/access-to-information-reforms-fall-short-pro-openness-voices-tell-mps-1.3645172
The Calgary Herald (editorial)
How to lead a more transparent government
RCMP, bureaucrats rapped for improperly collecting personal info
http://www.cbc.ca/news/politics/rcmp-bureaucrats-rapped-for-improperly-collecting-personal-info-1.3609614
Privacy commissioner wants to put brakes on info czar’s planned new power
http://www.ctvnews.ca/politics/privacy-commissioner-wants-to-put-brakes-on-info-czar-s-planned-new-power-1.2926433
Supreme Court Of Canada Affirms Protections For Privilege In The Face Of Statutory Production Demands
http://www.mondaq.com/canada/x/549322/trials+appeals+compensation/Supreme+Court+Of+Canada+Affirms+Protections+For+Privilege+In+The+Face+Of+Statutory+Production+Demands
STATISTICS CANADA EMPLOYMENT AND UNEMPLOYMENT TABLES (TOP)
Documentation – Labour Force Survey (LFS)
Employment by industry
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/econ40-eng.htm
Employment, payroll employment, by industry
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/labr71a-eng.htm
Labour Force Survey (LFS)
http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=3701#a5
Major wage settlements, by region and/or jurisdiction
http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&p2=33&id=2780008
Major wage settlements, by major industry division
http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&p2=33&id=2780007#F1
NB Liquor lawsuit may undermine confidence in accessing information-Journalism professor Fred Vallance-Jones says public bodies need to see importance of access to information
http://www.cbc.ca/news/canada/new-brunswick/lawsuit-access-to-information-professor-1.3781186
Tables by subject: Employment and unemployment
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/ind01/l3_2621_1803-eng.htm?hili_econ40
STORIES ABOUT INVESTIGATIVE JOURNALISM(TOP)
What 2011 holds for investigative reporting (The Poynter Institute)
The best journalism-job want ad ever ever (Mother Jones)
STORIES USING DATA FROM OPEN-DATA WEBSITES (TOP)
Cats have tougher lives than dogs in Toronto: analysis
Dogs of NYC
http://project.wnyc.org/dogs-of-nyc/
Maps: Who are the dogs in your Toronto neighbourhood? (Global News)
http://www.globalnews.ca/Pages/Story.aspx?id=6442522298
Missed garbage pickup complaints rise in east, fall in west
This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press)
Why do downtown councillors get all the online attention?http://www.thestar.com/news/city_hall/2015/07/17/why-do-downtown-councillors-get-all-the-online-attention.html
STUDENT INVESTIGATIONS(TOP)
Hidden Profits, Student Debt (Columbia City Paper)
http://www.columbiacitypaper.com/2010/06/16/hidden-profits-student-debt/
University of King’s College
http://investigative.kingsjournalism.com/
http://algonquintimes.com/news/illicit-invitation/
Examining the University Bill
http://et.kent.edu/jmc40004/fees/
Untitled: The Legacy of Land in North Preston
http://www.northprestonland.ca/index.html
TABLEAU(TOP)
Tableau Public ( a free application that helps to visualize data )
http://www.tableausoftware.com/public/gallery
http://www.tableausoftware.com/public/ire
Installing the Tableau Add-In for Reshaping Data in Excel
http://kb.tableausoftware.com/articles/knowledgebase/addin-reshaping-data-excel
Tableau tutorials
Installing the Tableau Add-In for Reshaping Data in Excel
http://kb.tableausoftware.com/articles/knowledgebase/addin-reshaping-data-excel
TABLEAU — STORIES(TOP)
Population Growth and Decline in Puget Sound
http://public.tableausoftware.com/profile/cephillips#!/vizhome/PugetSoundcensus/Dashboard
Station Crime Report
http://public.tableausoftware.com/profile/sarah.ryley#!/vizhome/MTAstationviz/Light
Housing Project Report Card
http://public.tableausoftware.com/profile/sarah.ryley#!/vizhome/MTAstationviz/Light
TRADE(TOP)
Canadian Import and Export Stats (Industry Canada)
http://strategis.ic.gc.ca/sc_mrkti/tdst/tdo/tdo.php#tag
Canadian international merchandise trade – Statistics Canada
http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2280069&&pattern=&stByVal=1&p1=1&p2=31&tabMode=dataTable&csid=
http://www5.statcan.gc.ca/cimt-cicm/home-accueil?lang=eng
Canadian international trade HS codes – Canada Border Services Agency
http://www.cbsa-asfc.gc.ca/trade-commerce/tariff-tarif/2017/html/05/ch27-eng.html
Balance of Payments trade in goods at Statistics Canada: Expanding geographic detail to 27 principal trading partners
http://www.statcan.gc.ca/pub/13-605-x/2014004/article/14107-eng.htm
Crude Oil in Dollars per Barrel, Products in Dollars per Gallon (U.S. Energy Information Administration)
https://www.eia.gov/dnav/pet/pet_pri_spt_s1_d.htm
Report on Exports of Military Goods from Canada
http://www.international.gc.ca/controls-controles/report-rapports/mil-2010-2011.aspx?lang=eng
Report on Exports of Military Goods from Canada – 2014
http://www.international.gc.ca/controls-controles/report-rapports/mil-2014.aspx?lang=eng
Report on Exports of Military Goods from Canada – 2015
http://www.international.gc.ca/controls-controles/report-rapports/mil-2015.aspx?lang=eng
Trudeau advised to deepen ties with Saudi Arabia
U.S. International Trade Statistics
http://www.census.gov/foreign-trade/index.html
Record Layouts and Sample Files
https://www.census.gov/foreign-trade/reference/products/layouts/index.html
TRADE PUBLICATIONS(TOP)
Drug Rep Chronicle
AGCanada
http://www.agcanada.com/daily/
The Western Producer
PennEnergy
http://www.pennenergy.com/oil-gas/more-oil-gas-wire-news.html
The Packer: Covering the fresh produce industry since 1893
http://www.thepacker.com/fruit-vegetable-news/Canada-mulls-inspection-fee-increase-200913761.html
ReNew Canada (The Infrastructure Magazine)
Oilprice.com
Engineering and Technology Magazine
TRANSPORTATION(TOP)
Air
Aviation Safety Letters
http://www.tc.gc.ca/eng/civilaviation/publications/tp185-menu-5395.htm
Secret Skies (A CBC News investigation into air safety)
http://www.cbc.ca/news/secretskies/
Aviation safety investigations database (CBC News extract of helicopter misshaps from CADORS)
http://www.cbc.ca/news/interactives/helicopter-database/index.html
Number of reported bird strikes at Windsor airport soars (The Windsor Star)
http://blogs.windsorstar.com/2013/05/13/number-of-reported-bird-strikes-at-windsor-airport-soars/
Search for Complaints (the U.S. National Highway Traffic Safety Administration )
http://www-odi.nhtsa.dot.gov/complaints/
Top-secret measures taken over possible explosives at Pearson (CBC News Investigation)
http://www.cbc.ca/canada/story/2010/01/12/airport-security-pearson.html?ref=rss
Transport Canada: Civil Aviation Daily Occurrence Reporting System (CADORS)
http://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/q.aspx?lang=eng
TP 185 – Aviation Safety Letter (The Aviation Safety Letter (ASL) is published quarterly by Transport Canada, Civil Aviation)
http://www.tc.gc.ca/eng/civilaviation/publications/tp185-menu-5395.htm
LaserPointerSafety.com
http://www.laserpointersafety.com/how2reduceincidents/pilots/pilots.html
Skybrary (billed as “the single point reference for aviation safety knowledge”)
http://aviationsafetywiki.org/index.php/Main_Page
LiveAtc.net (Live Air Traffic – From their headsets to you)
http://www.liveatc.net/archive.php
Live Flight Tracking
http://flightaware.com/live/flight/JZA862
Obstruction Evaluation / Airport Airspace Analysis (U.S. Federal Aviation Administration
(OE/AAA)https://oeaaa.faa.gov/oeaaa/external/portal.jsp
Planesregister.com
Transport Canada: Bird Strike Summary Reports
National Wildlife Strike Database ON-LINE (The United States)
http://wildlife.pr.erau.edu/public/index.html
Bird Strike Committee Canada
http://www.birdstrikecanada.com/
Safeskies.ca
FlightPilotFatigue
http://fightpilotfatigue.tumblr.com/
Links to Canadian Airport Authorities
http://www.tc.gc.ca/programs/airports/caa.htm
Canadian list of airports ( Transport Canada)
http://www.tc.gc.ca/programs/airports/status/menu.htm
Transport Canada: Corporate Offenders Enforcement Action Summaries
http://www.tc.gc.ca/CivilAviation/standards/Enforcement/Publications/Corporate/summary.htm
Transport Canada Overview Reports
http://www.tc.gc.ca/pol/en/anre/menu.htm
Transport Canada (service difficulty reports)
Transport Canada (continuing airworthiness reports)
http://www.tc.gc.ca/eng/civilaviation/opssvs/managementservices-referencecentre-acs-500-menu-127.htm
Transportation Appeal Tribunal of Canada
http://www.tc.gc.ca/civilAviation/regserv/Appeals/Juris/amend/amend19/menu.htm
Transport Canada Flight Training Units
https://www.tc.gc.ca/aviation/activepages/ftae/index.aspx
Federal Aviation Administration (Canadian service diffciulty reports can be downloaded from this site thanks to an agreement between the FAA and Transport Canada)
http://av-info.faa.gov/dd_sublevel.asp?Folder=%5CSDRS
The Canadian Civil aircraft register year-end summaries
http://wwwapps2.tc.gc.ca/Saf-Sec-Sur/2/ccarcs/aspscripts/en/yearendsum.asp
http://wwwapps2.tc.gc.ca/saf-sec-sur/2/ccarcs/aspscripts/en/menu.asp
The Canadian Transportation Agency (Air Carrier Licence Search)
http://forms.cta-otc.gc.ca/AirLicences/Search_e.cfm
The Air Transport Association of Canada (ATAC)
Aviation service bulletin (Statistics Canada’s trends, including air carrier statistics, including number of passengers carried and kilometres travelled)
http://www.statcan.ca/english/freepub/51-004-XIE/51-004-XIE2008001.htm
Aircraft Movement Statistics (NAV CANADA Towers and Flight Service Stations )
http://www.statcan.ca/english/freepub/51-007-XIE/51-007-XIE2008001.htm
Transportation Safety Board of Canada
Pipeline investigation reports (Transportation Safety Board of Canada)
http://www.tsb.gc.ca/eng/rapports-reports/pipeline/
The Canadian Air Transport Security Authority (CATSA)
http://www.catsa.gc.ca/english/index.shtml
The Canadian Transportation Research Forum
The Air Line Pilots Association, International (ALPA)
http://alpa.org/Default.aspx?tabid=139
Aviation Safety & Security Digest
http://www.aviation-safety-security.com/homepage/about-us/index.php
Bill C-26 Home Page
http://cmte.parl.gc.ca/cmte/CommitteeWitnesses.aspx?Lang=1&PARLSES=391&JNT=0&SELID=e23_&COM=10462
Transport 2000
AVCANADA (a discussion forum on aviation in Canada)
http://www.avcanada.ca/forums2/viewtopic.php?f=54&t=40787&st=0&sk=t&sd=a&start=0
Flight Global
British Columbia Safety Council
http://www.safetycouncil.bc.ca/
Aviation Alberta
http://www.aviationalberta.com/
The Saskatchewan Aviaton Council
http://www.saskaviationcouncil.ca/
Manitoba Aviation Council
http://www.manitobaaviationcouncil.ca/
Ontario Region ( Transport Canada)
http://www.tc.gc.ca/OntarioRegion/civilaviation/system/seminars.htm
Quebec Air Transport Association
http://www.aqta.ca/en/default.asp?
Aviation Safety (Atlantic Region)
http://www.tc.gc.ca/atl/en/air/aviation_safety/menu.htm
North American Transportation Statistics Database
http://nats.sct.gob.mx/sys/index.jsp?i=3
The U.S. Federal Aviation Administration (FAA)
FAA airworthiness directives
U.S. aircraft register
http://www.faa.gov/aircraft/air_cert/aircraft_registry/
U.S. Department of Transportation
The U.S. Federal Aviation Administration (Aircrart Inquiries)
http://registry.faa.gov/aircraftinquiry/NNum_inquiry.asp
National Transportation Safety Board inventory of databases|
http://www.ntsb.gov/investigations/databases.html
The Family Assistance Foundation
http://www.fafonline.org/index.php
Pilot Getaways (U.S.)
The UK Civil Aviation Authority
Aviation Safety Network
http://aviation-safety.net/index.php
The International Air Transport Association (IATA)
International Civil Aviation Organization (ICAO)
International Aviation Safety Association (started by a relative of a victim of the Swissair disaster)
http://www.iasa.com.au/folders/menu/index.htm
Flight Safety Foundation
http://www.flightsafety.org/home.html
Flight Aware
Floweb.com
FareCompare.com
The Boeing 737 Technical Site
http://www.b737.org.uk/index.htm
ASIResource.com
http://www.asiresource.com/default.htm#contents
Marine
Vessel Register (Transport Canada)
http://wwwapps.tc.gc.ca/Saf-Sec-Sur/4/vrqs-srib/a.aspx?lang=e
MarineTraffic
http://www.marinetraffic.com/en/
Ground
Transport Canada Collision and Road Safety Statistics
http://www.tc.gc.ca/roadsafety/resources/researchstats/menu.htm#collisionstats
Road collision statistics (B.C.)
http://www.icbc.com/road-safety/safety-research/collision-statistics
Road collision statistics ( Saskatchewan )
http://www.sgi.sk.ca/sgi_pub/road_safety/trafficcollisionstats/index.htm
Road collision statistics (Newfoundland and Labrador)
http://www.tw.gov.nl.ca/CollisionStats/pamphlet.stm
Road collision statistics (Nova Scotia)
http://www.gov.ns.ca/tran/highwayops/stats.asp
Transport Canada:Vehicle Recalls On-Line Database
http://wwwapps.tc.gc.ca/saf-sec-sur/7/vrdb-bdrv/search/Search.aspx?lang=eng
Vessel registry
http://www.tc.gc.ca/ShipRegistry/menu.asp?lang=e
Autoglass search ( vehicle recall database )
http://www.autoglasssearch.com/articles/vehicle-recalls.htm
Ontario driver, vehicle information
http://www.mto.gov.on.ca/english/dandv/catalogue.htm
Ontario Road Safety Annual Report
http://www.mto.gov.on.ca/english/safety/orsar/
La Société de l’assurance automobile du Québec (SAAQ)
Driving Statistics for Nova Scotia’s department of Transportation and Infrastructure Renewal
http://www.gov.ns.ca/tran/highwayops/stats.asp
Annual Road Safety Reports (the city of Ottawa)
http://ottawa.ca/residents/onthemove/driving/road_safety/integrated/annual_reports/index_en.html
UNIVERSITY PUBLICATIONS(TOP)
Centretown News (Online)
http://www.carleton.ca//ctown/home/homeNew.htm
Off Centre
http://ottawaoffcentre.wordpress.com/
Hartwells (Living well in Ottawa)
http://hartwellsottawa.wordpress.com/
Convergence magazine (Humber College)
http://magazines.humber.ca/convergence2008/
Face Time (Mount Royal University News)
http://www.mtroyal.ca/facetime/FTDATA_journal_092310
The Canadian Journal of Media Studies (Faculty of Information and Media Studies at the University of Western Ontario in London, Ontario)
http://cjms.fims.uwo.ca/default.htm
U.S. GOVERNMENT(TOP)
The Whitehouse President Barak Obama
GPO Access (The Federal Depository Library Program Electronic Collection (FDLP/EC) is a comprehensive digital library of U.S. Government information)
http://www.access.gpo.gov/su_docs/fdlp/ec/
http://www.lib.lsu.edu/gov/alpha
Federal Audit Clearinghouse
Data.gov (datasets from top U.S. executive departments)
Data.gov (Raw data sets)
http://explore.data.gov/catalog/raw/
Sunlight Foundation Reporting Group (U.S. non-profit group that tracks federal spending)
http://reporting.sunlightfoundation.com/2010/ogd/
Federal Energy Regulatory Commission
http://www.ferc.gov/about/about.asp
U.S. Business (TOP)
National Bureau of Economic Research
Business Wire (U.S.)
EDGAR (U.S.)
http://www.sec.gov/cgi-bin/srch-edgar
SEC Filing Alerts
Morningstar Document Research (formerly 10-K Wizard)
Descriptions of 10-Ks, 10-Qs, 6-Ks and other forms companies are required to file with the SEC
http://www.sec.gov/info/edgar/forms/edgform.pdf
New York Stock Exchange
The National Association of Securities Dealers
http://www.nasd.com/web/idcplg?IdcService=SS_GET_PAGE&nodeId=6
The North American Securities Administrators Association
http://www.nasaa.org/home/index.cfm
Equilar (a firm that tracks executive and director compensation)
Standard & Poor’s
http://www2.standardandpoors.com/servlet/Satellite?pagename=sp/Page/HomePg&r=1&l=EN&b=10
Moody’s Investors Service
http://www.moodys.com/cust/default.asp
Dun & Bradstreet
Hoover’s Online
Financial Directory
Fast Company
http://www.fastcompany.com/homepage/index.html
Newslink
http://newslink.org/biznews.html
Business magazines
http://allyoucanread.com/index.asp?idCat=7
Facsnet
The McKinsey Quarterly
Sources and Experts
http://www.ibiblio.org/slanews/internet/experts.html
American Experts
http://www.journalismnet.com/experts/us.htm
The National Bureau of Economic Research
Searchable database for bills in Congress
U.S. Government Printing Office
The U.S. Food and Drug Administration’s archive of warning letters
http://www.accessdata.fda.gov/scripts/wlcfm/searchwl_new.cfm
FDA Recalls, Market Withdrawals and Safety Alerts
http://www.fda.gov/opacom/7alerts.html
FDA Enforcement Report Index
http://www.fda.gov/opacom/Enforce.html
Securities lawsuits
http://securities.stanford.edu/companies.html
Lawyers
Confined Space ( A U.S. site on workplace safety)
http://spewingforth.blogspot.com/
U.S. Department of LABOUR (Occupational Safety & Health Administration)
http://www.osha.gov/pls/imis/establishment.html
Power Reporting (resources for business journalists)
http://powerreporting.com/category/Beat_by_beat/Economics/
Reynolds Centre
http://businessjournalism.org/
Workforce Explorer Washington (state)
http://www.workforceexplorer.com/cgi/dataanalysis/?PAGEID=14
BNET Industries (A site for managers and executives)
http://www.bnet.com/2405-13071_23-41875.html
CorpWatch
http://www.corpwatch.org/index.php
Left Business Observer
http://www.leftbusinessobserver.com/
LBO News from Doug Henwood
http://doughenwood.wordpress.com/
Inequality.org
http://www.demos.org/inequality/
AlterNet
http://www.alternet.org/workplace/
ExportFocus.com
U.S. COURT FILINGS AND LEGAL ACTION(TOP)
Pacer
The Public Library of Law (U.S.)
http://www.plol.org/Pages/Search.aspx
Lexis
United States Department of Justice
http://www.usdoj.gov/index.html
United States Bankruptcy Courts
http://www.uscourts.gov/bankruptcycourts.html
Banktruptcy Data.com
CLB Media Inc. (A publisher of many trade magazines and other media services)
Transactional Records Access Clearinghouse ( TRAC is a data-gathering, data research and data distribution organization at Syracuse University)
http://trac.syr.edu/tracreports/bulletins/
VANCOUVER(TOP)
Stories about Entegrity Systems
Insolvency information about Entegrity
Sample foreclosurelist for Greater Vancouver
B.C. election campaign contribution data
VITAL STATISTICS/CERTIFICATES(TOP)
Statistics Canada
http://www.statcan.ca/english/Pgdb/
Canadian vital statistics offices
http://www.cbs.gov.on.ca/mcbs/english/4UBMCE.htm
Ontario births, deaths, marriages
http://www.cbs.gov.on.ca/mcbs/english/4ULUQT.htm
Ontario historical births, deaths, marriages
http://www.archives.gov.on.ca/english/interloan/vsfaq.htm
Ontario coroner’s reports
http://www.mpss.jus.gov.on.ca/english/pub_safety/office_coroner/coroner_how.html
Ontario wills
http://www.archives.gov.on.ca/english/virtualrr/info15.htm
Ontario divorce files
http://www.archives.gov.on.ca/english/guides/rg_210_divorce_ont.htm
Ontario land registration
http://www.cbs.gov.on.ca/mcbs/english/4UBSJK.htm
Ontario personal property registry
http://www.cbs.gov.on.ca/mcbs/english/269a_3ea2.htm
Ontario liens
http://www.cbs.gov.on.ca/mcbs/english/2502_3ea2.htm
Ontario fire deaths
http://www.ofm.gov.on.ca/english/publications/Statistics/deathrate/default.asp
WEBSCRAPING(TOP)
Downloadthemall
Firebug
kimono
Outwit
SiteSucker
http://sitesucker.en.softonic.com/mac
WEBSITES WITH TABLES FOR DOWNLOAD(TOP)
Ontario’s Public Sector Salary Disclosure
http://www.ontario.ca/government/public-sector-salary-disclosure
Alberta’s Public Sector Salary Disclosure
http://alberta.ca/SalaryDisclosure.cfm
http://data.alberta.ca/data/public-disclosure-salary-and-severance
Terrorism Financing (Office of the Superintendent of Financial Institutions Canada)
http://www.osfi-bsif.gc.ca/osfi/index_e.aspx?DetailID=525
Healthy Canadians
Food Recall Report (Downloadable food recalls from the Canadian Food Inspection Agency)
http://active.inspection.gc.ca/eng/corp/recarapp_dbe.asp
Dairy Facts and Figures (Canadian Dairy Information Centre)
http://dairyinfo.gc.ca/index_e.php?s1=dff-fcil#trade
Canadian International Merchandise Trade Database
http://strategis.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/home
Community Acquired Infections Division (The Public Health Agency of Canada)
http://www.phac-aspc.gc.ca/std-mts/sti-its_tab/index-eng.php
Data-Pass (Data Preservation Alliance for the Social Sciences)
Elections Canada
http://www.elections.ca/scripts/webpep/fin/select_search_option.aspx
Road Safety Vehicle Recalls (Transport Canada)
http://www.tc.gc.ca/eng/roadsafety/safevehicles-defectinvestigations-index-76.htm
http://data.gc.ca/data/en/dataset/1ec92326-47ef-4110-b7ca-959fab03f96d
Search for Complaints (the U.S. National Highway Traffic Safety Administration )
http://www-odi.nhtsa.dot.gov/complaints/
National Highway Traffic Safety Administration:Product Information Catalog and Vehicle Listing (vPIC)
https://vpic.nhtsa.dot.gov/
National Transportation Safety Board inventory of databases
http://www.ntsb.gov/investigations/databases.html
http://www-odi.nhtsa.dot.gov/downloads/
Women Candidates in General Elections (1921 to Date)
http://www.parl.gc.ca/information/about/process/house/asp/WomenElect.asp?Language=E&source=hoc
Quebec political contributions
Elections Ontario
http://www.elections.on.ca/en-CA/Tools/FinancialStatementsandContributions/RealTimeDisclosure.htm
Elections BC (Political Contributions System)
http://contributions.electionsbc.gov.bc.ca/pcs/SA1ASearch.aspx
Canadian charities ( Canada Revenue Agency )
http://www.cra-arc.gc.ca/chrts-gvng/lstngs/menu-eng.html
Federal lobbyists
Canada Foundation for Innovation ( all the grants awarded )
http://www.innovation.ca/projects/index.cfm
Transport Canada (road safety)
http://www.tc.gc.ca/eng/roadsafety/tp-tp3322-2004-menu-691.htm
Environment Canada’s National Pollutant Release Inventory (NPRI)
http://www.ec.gc.ca/pdb/websol/querysite/query_e.cfm
http://www.ec.gc.ca/inrp-npri/Default.asp?lang=En&n=0EC58C98-1
Canada’s Greenhouse Gas Inventory ( Environment Canada )
http://www.ec.gc.ca/pdb/ghg/onlinedata/DataAndReports_e.cfm
Greenhouse Gas Reporting Site ( glossary of terms )
http://www.ghgreporting.gc.ca/GHGInfo/Pages/page15.aspx
Contaminated sites in Quebec
http://www.mddep.gouv.qc.ca/sol/residus_ind/resultats.asp
ACOA Project Information (Atlantic Canada Opportunities Agency)
http://pub.acoa-apeca.gc.ca/atip/e/content/default.asp
Health Canada’s Adverse Drug Reaction Database
http://webprod3.hc-sc.gc.ca/arquery-rechercheei/index-eng.jsp
http://data.gc.ca/data/en/dataset/9cbaef00-b52c-4a70-9fed-d9aa8263ab74
Canada Vigilance Adverse Reaction Online Database – Data Structure
https://www.canada.ca/en/health-canada/services/drugs-health-products/medeffect-canada/adverse-reaction-database/canada-vigilance-adverse-reaction-online-database-data-structures.html
The FDA’s Adverse Drug Reaction Database
DataGov
http://dirtdiggersdigest.org/enforcement
Navigate the world
of public data
European database of suspected adverse drug reaction reports
National Collision Database Online (Transport Canada)
http://wwwapps2.tc.gc.ca/Saf-Sec-Sur/7/NCDB-BNDC/p.aspx?l=en
Notice of Compliance Online Query
http://webprod5.hc-sc.gc.ca/noc-ac/index-eng.jsp
Notice of compliance ( drugs Health Canada has approved )
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/notices-avis/list/index_e.html#Weekly%20Updates
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/notices-avis/conditions/index-eng.php
Health Canada’s Register of Innovative Drugs for Pediatric use
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/applic-demande/regist/reg_innov_dr-eng.php
Drug Products Database ( all of the drugs Health Canada has approved for marketing)
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/databasdon/dpd_bdpp_data_extract_e.html
Health Canada’s list of recalled drugs and medical devices
http://www.hc-sc.gc.ca/dhp-mps/compli-conform/recall-retrait/_list/index-eng.php
Health Canada’s list of recalled consumer products
http://cpsr-rspc.hc-sc.gc.ca/PR-RP/home-accueil-eng.jsp
Health Canada’s list of warnings, advisories and recalls (on marketed health products, including Natural Health Products and medical devices)
http://www.hc-sc.gc.ca/dhp-mps/medeff/advisories-avis/index-eng.php
Health Canada’s Licensed Natural Health Product Database (LNHPD)
http://www.hc-sc.gc.ca/dhp-mps/prodnatur/applications/licen-prod/lnhpd-bdpsnh_data_extract-eng.php
Treasury Board, Directory of the federal real estate properties
http://www.tbs-sct.gc.ca/dfrp-rbif/query_question/export-eng.aspx?qid=23174
CARinCanada
http://www.carincanada.ca/DATABASES.htm
Statistics Canada
http://www.statcan.gc.ca/start-debut-eng.html
Census (Statistics Canada)
http://www12.statcan.ca/english/census/index.cfm
Average Annual Percentage Wage Adjustments by Year (Human Resources and Skills Development Canada)
Income statistics (Canada Revenue Agency)
http://www.cra-arc.gc.ca/gncy/stts/ntrm-eng.html
Exploring Data (a tutorial for examining statistics)
http://exploringdata.cqu.edu.au/
Fatality Reports Database ( The Canadian Centre for Occupational Health and Safety)
http://www.ccohs.ca/products/databases/fatalityreports.html
Arms Exports
http://strategis.ic.gc.ca/sc_mrkti/tdst/tdo/tdo.php#tag
Complaint Statistics (Ontario Civilian Commission on Police Services for the years 2001 to 2005)
Canadian National Defence Contracts over $10,000
http://www.admfincs.forces.gc.ca/apps/dgca-dposc/dgcaoq-dposcst-eng.asp
RCMP Detachments – Telephone Numbers
http://www.rcmp-grc.gc.ca/html/generalcont_e.htm
City of Ottawa paramedic serives
http://www.ottawa.ca/residents/ambulance/structure_contact/operations/daily/stats_en.html
Office of Pipeline Safety (U.S.)
UJIMA project (U.S. site that contains Canadian data such as arms exports)
http://ujima-project.org/countries/34
SIPRI Arms Transfers Database
http://www.sipri.org/databases/armstransfers
Environmental Journalism Tipsheet
http://www.rtnda.org/resources/tipsheet/september26.shtml
Data Handbook ( city of Ottawa )
http://www.ottawa.ca/city_services/statistics/data_handbook/index_en.shtml
National Wildlife Strike Database ON-LINE
http://wildlife.pr.erau.edu/public/index.html
Health Inspection Orders (Alberta Health Services)
Datadot.gc.ca
DataBC
Transparency Tracker (Propublica)
http://projects.propublica.org/transparency/
National Data Catalogue ( the United States )
http://nationaldatacatalog.com/dashboard
The World Bank
Unofficial Open Data Ottawa
http://opendataottawa.pbworks.com/
Vaccine Adverse Event Reporting System (The U.S. Food and Drug Administration)
http://vaers.hhs.gov/data/data/
SeeThroughNY
http://www.seethroughny.net/Home/tabid/36/Default.aspx
Find NY state and local pensions (2010)
http://data.lohud.com/labor/retire_form_2010.php
AccountableCalifornia.org
http://accountablecalifornia.org/investigative-reports/
DataStore: World Government Data
http://www.guardian.co.uk/news/datablog/2010/jan/07/governm(TOP)
WORKPLACE SAFETY(TOP)
Canadian Centre for Occupational Health and Safety
Association of Workers’ Compensation Boards of Canada
Alberta Occupational Health and Safety Workplace Incident Fatalities
http://www.humanservices.alberta.ca/working-in-alberta/781.html#Incidents
Links to Workers’ Compensation Boards/Commissions
http://www.awcbc.org/en/linkstoworkerscompensationboardscommissions.asp
Enforcement Activities: Prosecution and Conviction Statistics (Ontario Ministry of Labour)
http://www.labour.gov.on.ca/english/es/pubs/enforcement/convictions.php
Workplace Safety Fines: Ontario Ministry of Labour (courtesy of CNW Group)
http://ogov.newswire.ca/getorg_e.html?okey=16716
http://www.labour.gov.on.ca/english/news/court_news.html
Workplace Safety Fines: Ontario Ministry of Labour (courtesy of the Occupational Safety Group)
http://67.69.16.62/fmi/iwp/cgi?-db=OSGCA&-loadframes
OHS CANADA Magazine
Farm Association (of Ontario)
http://www.farmsafety.ca/pages/annual_report.html
Laborsta (An International Labour Office database on labour statistics)
http://laborsta.ilo.org/default.html
U.S. Department of Labour Enforcement Data
http://ogesdw.dol.gov/views/data_summary.php
OSHA Workplace Safety Data (IRE)
http://ire.org/nicar/database-library/databases/osha-workplace-safety-data/
WRITING(TOP)
Cam-girls: Inside the Romanian sexcam industry
http://www.bbc.com/news/magazine-40829230
Fifty-two ugly leads: The first sentence is prime real estate, so don`t waste it (By Don Gibb, pages 7-8 of Media magazine)
http://caj.ca//wp-content/uploads/2010/mediamag/Fall%202012/MEDIA%20MAGAZINE%20FALL%202012_FINAL.pdf
The man who transformed how The New York Times covers the gay community
http://www.cjr.org/the_profile/jeff_schmalz_sam_freedman_new_york_times.php
What’s bugging our writing coach, Don Gibb? (pages 7-8 of Media magazine)
http://caj.ca/wp-content/uploads/2010/mediamag/Spring%202011/Media%20Magazine%20Spring%202011.pdf
CAJ column on reporting tips (Don gibb’s last column for Media magazine)