Reporting Methods Carleton University: Journalism 5206

Share

 

REPORTING METHODS Carleton University: Journalism 5206

David McKie

David McKie, CBC News Investigations

Phone: (O) 613-288-6523 (C) 613-290-7380 (fax) 613-288-6490

Jim Bronskill

Jim Bronskill, The Canadian Press

Phone: (O) 613-231-8653 (C) 613-859-3752 (fax) 613-238-4452

Graduate Course 2013/2014 – Winter term

Wednesdays: 7:00 to 10:00 p.m.

Room 2311 River Building

Assignments and Evaluation | Course outline |Biographies | Access to information links | Access to Information_Police| Access to information stories in the news| Business Analysis|Canadian Business |Canadian Business Statistics |Canadian Business Publications |CAR and ATI-related Stories | Catalogue Search Engines |Children’s safety|Consumer issues and Consumer-related issues|Computer-Assisted Reporting |Computer-Assisted Reporting tutorials|Contracts |Coroners’offices|Crime Databases |Data Journalism|Data Visualization|Defence|Digital news websites|Directories/Reference Works|Disciplinary bodiesDiscussions |DocumentCloud|The Economy|Education|Elections |Environment |Ethnic Newspapers|Evaluating Web Pages |Federal GovernmentFederal Politics|Federal Public Service|Federal Spending|Food safety|Foreign Affairs |Government spending | Health Health (Provincial)|Health (International)|Health PolicyHousing|Immigration | Innovative Tools Internet research InterviewingInvestigative Journalism WebsitesInvisible Web Journalists’ Blogs |Journalism Education|Journalism Research|Journalism Resource Sites |Key Word Search Engines | Land-title and property assessment offices | Legal System/Courts |Lesson plans |Libraries/Archives |Lien Records|Lobbyists Mapping |Mapping Stories|Mapping Tutorials|Medical devices|Miscellaneous Tools | Money |Multi-mediaMunicipal governments |MySQL |News Blogs|Numeracy skills|Online News Sites|Open Data government websites|People Finders |Photojournalism | PoliticsPolling |Population statistics |Preparing Stories|Provincial Audits |Provincial Contracts | Provincial Governments|Public Accounts|Public health| Publication finders|Public Policy Organizations Readings Researching Companies – Powerpoint presentation | Research tecnhiques Powerpoint presentation |Science | Search and Rescue | Searchable Online Websites |Search Engine Research|Senior’s CareShopping list of key records | Social Media | Sports |Spreadsheet tutorials |Stories about access to information|Stories about investigative journalismStudent investigations|Ten ways to improve your searches|Trade|Trade publications| Transportation Training resources|University Publications |U.S. Government|U.S. Business |U.S. Court Filings and Legal Action|Vancouver|Vital Statistics/CertificatesWebsites with tables to download|Workplace safety |Writing

 

Course objectives

1) Obtain a thorough grounding in journalistic research methods.

2) Acquire skills, such as computer-assisted 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)

Jan. 8: a. Course introduction b. Introduction to Access to Information|| Reading: Digging Deeper, Chapters 1, 2, 3, 10, and Appendix C

Jan. 15: a. Access to Information tips: Previously released records, complaints b. Assignment: Access-to-information story c. Corporate / Business resources (Advanced Google searches, Researching companies, corporate filings, securities exchanges) d. Assignment: Business story || Reading: Digger Deeper, Chapter 9 and Appendix C

Jan. 22: a. Corporate / Business resources (part two) b. Assignment: Whatever-happened-to? story c. One-on-ones: Business story / Access-to-information story / Research time || Reading: Digging Deeper, Chapters 4,7

Jan. 29: a. Business story due Friday b. Access to Information tips: focusing a request, negotiating  c. One-on-ones / Research time d. Databases (part one) || Reading: Digging Deeper, Chapter 11 and Appendices A and B

Feb. 5: a. Databases (part two) || Reading review: Digging Deeper

Feb. 12: a. Business story feedback b. Databases (part three) c. Assignment: Database story

Feb. 19: Reading Week. No class scheduled.

Feb. 26: a. Whatever-happened-to? story due (by 9 a.m. Feb. 27) b. Access to Information: Making sense of records (decoding documents, chronologies) c. One-on-ones: Database story / Access-to-information story / Research time || Reading: Digging Deeper, Chapter 6, Chapter 8

March 5: a. Interviewing / Sources b. Public records || Reading: Digging Deeper, Chapter 12

March 10: database story due by 9  a.m.

March 12: a. Whatever-happened-to? story feedback b. Overlooked Access to Information records

March 19: a. Access-to-information story due March 20, 9 a.m. b. Database story feedback c. Courts / Legal Affairs || Reading: Digging Deeper, Chapter 5

March 26: a. Journalistic ethics: investigative quandaries b. Enterprise journalism tips

April 2: a. Access-to-information story feedback. b. Sharing what we’ve learned

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

Assignments and Evaluation(TOP)

Assignments in this course are governed by the provisions of the document Ethics and Standards in the School of Journalism and Communication. There are four assignments, each with a deadline. Lateness will be penalized, though exceptional circumstances will be taken into account. There is no final examination. Each assignment has three components, all of which will figure in the grade:

A. Copies of the actual documents compiled / gathered (in paper or electronic form).

B. A description of how the documents were obtained, and why they were useful.

C. The resulting story.

Each of the four assignments is worth 20 per cent of the overall course grade. The remaining 20 per cent of the grade will be determined based on presence, punctuality, participation and professionalism.

Final standing in this course is determined by the course instructors subject to the approval of the Dean of Public Affairs. This means that final grades submitted by the instructors may be subject to revision. No grade is final until it has been approved by the Dean.

1) Business story

A news story about a business prepared with the assistance of a financial statement. 600 words, double-spaced (uploaded to our WordPress syllabus with interactive content).

Assignment requirements

A 600-word story on a publicly traded company

At least one interview with an expert who can put the numbers in context.

The assignment is to be uploaded to our WordPress site to the “category” which will be assigned.

The story should have the following multi-media components: An annotated financial statement(s) uploaded to DocumentCloud; A visual depiction of the trend you’re writing about (chart, line graph, pie chart, etc); A 500-word explanation in a Word document that explains how you got the story, the sources you used and people you attempted to contact; an Excel spreadsheet containing your calculations.

The actual story should have as many hyperlinked references as possible. For instance, if the piece mentions a news release, hyperlink to it; if it mentions a speech, hyperlink to it, etc. The hyperlinks allow the reader to delve into the weeds if he or she wishes, and free you up from having to delve into too much detail.

Deadline: Friday, Jan. 31, at midnight

Note: Keep it simple!! Tell a story. Just take one or two numbers and write about them. Take what the financial statement(s) gives you. Don’t go into the story with a pre-conceived idea. Let them story emerge from the financial statement. Find a business analyst as soon as you can. It could be a business prof, for instance.

2) Whatever-happened-to? story

A piece that updates the reader on a memorable person or event from 1989. If you choose to write about a person, select someone who hasn’t attracted much, or any, public attention in the last 25 years. 600 words, double-spaced, due at 9 a.m. Feb. 27. The story is to be uploaded as a blog post using the “Whatever-happened-to” category of the syllabus.

Checklist:

a. Story must include comments from your interview with the person in question or participant(s) in the original event.

b. Copies of two pieces of documentation gathered during research for your story.

c. For EACH of the two pieces of documentation, full-sentence answers to these questions:

(*) What is the documentation?

(*) How did you find/obtain it?

(*) Why was the documentation helpful?

Whatever-happened-to? story FAQ

Q: The story must include comments from my interview with the person in question or participant(s) in the original event. Does that mean I need to do just one interview?

A: No, treat the story as you would any other. Though it depends on the story, three voices seems about right. You might interview one person who remembers the original event, someone involved in the issue today and an expert – such as a professor or author – who can place the issue in perspective.

Q: Do I need to include hyperlinks in my story?

A: If they help the reader, yes, one or two well-chosen hyperlinks are welcome.

Q: What sort of documentation do you want?

A: It could be anything that helped you do the story, such as a news clipping about the original event, a photo, a telephone listing of someone you tracked down or a partial transcript of one of your interviews.

Q: Could the documentation be an audio or video clip?

A: Yes. But please be sure to test all posted links and media to make sure they work.

Q: How should I post my story?

A: Post your story in the Whatever-happened-to? story section of the syllabus in the same way you filed your Business story.

Q: How should I hand in my two pieces of documentation?

A: You could upload an annotated document to DocumentCloud that is then embedded in the WordPress post. Depending on the format, you could also upload the scanned documentation directly to WordPress. For instance, you could post a .jpeg file of a photograph or a Word document with a screen grab of a Canada 411 entry.

However, you post your documentation, don’t forget to answer the questions on the checklist about each piece.

Remember:

(*) Think of your person or event as a rock dropped into a pond 25 years ago. You are charting the ripples.

(*) Do not write a rehash. Ask yourself: Could my story have been written in 1989? If so, something’s wrong.

(*) Tell a story.

3) Database story

Specs for database assignment

The idea is to use a database, much like we did with the financial statement for the business assignment, as a starting point for a story. The story idea MUST emerge from the data, which you can obtain from any of the databases on the federal, provincial or municipal open data government websites, or a another site of your choosing. If you’re using a municipal or provincial data set, it can be from any jurisdiction. However, please keep in mind that if the city or province is too far afield, distance and time zones might make it more challenging to arrange interviews, which, if possible should be done in person. The story must contain at least TWO interviews. The story length is 600 words

Required elements for blog post

The story must contain hyperlinks to key concepts, documents or events, and is to be multi-media affair, uploaded as a post to our website. The story must contain three of the following four visualizations:

1) Chart, heat map or simple map in Fusion Tables.  Be sure to attribute the source. Example: Source: the city of Ottawa: Analysis by Jane Smith

2) An annotated document (report, audit, budget, etc) uploaded to Documentcloud that is to be embedded in the post

3) A photograph of the interviewee, or a picture that relates to your subject matter, complete with cutline

4) A video or audio clip of the key person in your story. The video can be one taken on your smart phone; audio, using a tool such as Audiocloud.

Please note: be sure that all your hyperlinks and embeds are working. A half mark will be deducted for broken links or embeds that don’t appear on the page.

Required to submit in addition to the blog post

1) ONE Excel workbook that contains the following five worksheets: the original table, complete with the table’s URL; a clean working copy; calculations for key numbers; pivot table; the table used to upload to Fusion Tables.  To repeat, please make sure all the worksheets are in one workbook, not separate ones.  And be sure to label each worksheet.

2) A 500-word document that explains how you got the data, sorted the information to obtain the trend, along with the links and contacts.

Requirement for data

You are to run your database past me for approval, BEFORE proceeding to the next step. This should be done before, during or shortly after reading week. Delaying this step to the last minute means you’ll have less time to conduct interviews and write drafts.

The story is due by 9:00 a.m. March 10. If you can submit your assignment before then, I’d be grateful. I’ll accept drafts 72 hours before the story is due.

.4) Access-to-information story

(*) A news story based on documents obtained through access-to-information/freedom-of-information laws. 600 words, due at 9 a.m. March 20. The story and all associated components are to be uploaded as a blog post, using the “Access-to-information story” category of the syllabus.

(*) Checklist:

a. Copies of at least one request to EACH of the three levels of government (municipal, provincial-territorial, federal).

b. Copies of three requests for previously released federal records.

c. Copies of correspondence received/sent by you during the course of each of the requests.

d. Copies of at least two particularly relevant pages of information obtained under the access laws that assisted your story.

e. For the pages in (d) above, full-sentence answers to these questions:

(*) What is the information?

(*) From which department and level of government did you obtain these pages?

(*) Why was this information helpful?

Access-to-information story: Frequently Asked Questions

Q: How should I select which pages to include with my story?
A: Choose records that contain passages you quoted or information that underpinned your story.

Q: How should I post the pages?
A: You could scan and post them using DocumentCloud with annotations, or simply as a PDF or .jpeg files directly to the WordPress site. Just be sure to point me to the relevant pages and answer the three questions. You can answer the questions directly on the blog or in a separate Word document posted to the site. Do not email documents to Jim.

Q: Do you want to see all the access requests I did?
A: No, just one from each of the three levels of government and the three for previously released federal records. So, six in all. But please be sure to include the one(s) you based your story on.

A: No, just one from each of the three levels of government and the three for previously released federal records. So, six in all. But please be sure to include the one(s) you based your story on.

Q: Do you want every piece of correspondence related to the six requests?
A: I want to see all relevant postal correspondence and emails to help me understand how things proceeded.

Q: I dealt with agencies largely on the phone. What should I do?
A: Please give me dates and summaries of these calls wherever possible.

Q: I forgot to make copies of my requests. What should I do?
A: Please try to recreate the wording and date of your original requests as best you can.

Q: How should I post the requests and associated correspondence?
A: You should scan and post these documents as a PDF or .jpeg files on the WordPress site.

Q: Do I have to use the access-to-information documents in my story?
A: Yes, there should be a substantial connection between the records you have obtained and your story. A good test of this is to ask, “Could I really have done this story without the documents?” You should also tell readers how you obtained the documents, eg. released under the Access to Information Act, or obtained through the Alberta Freedom of Information and Protection of Privacy Act.

Q: Can I use more than one set of records in my story?
A: Yes, if they fit into your piece. But one set of records from any of the levels of government is fine.

Q: Do I need to include hyperlinks in my story?
A: If they help the reader, yes, one or two well-chosen hyperlinks are welcome.

Q: I am having serious trouble obtaining records. What should I do?
A: Talk to Jim immediately about any difficulties you might be having. We will ensure you have documents on which to base your story.

Q: My classmate has a set of documents they’re not using. Can I use them?
A: No.

A shopping list of key records(TOP)

20 records you can get using the federal Access to Information Act

1. 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 information laws to uncover stories. Before joining CP in November 2003, Jim was a reporter with Southam News (now 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. In each of the last two years 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. Three years ago 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.

David McKie is an Ottawa-based, award-winning journalist and an author who has been radio with the CBC for 20 years. In researching topics such as health and safety, he has become increasingly dependent on computer-assisted investigative reporting techniques, using the Internet to find sources, background material, and using spreadsheets and database managers to organize information and produce story ideas. He is now with the CBC’s investigative unit.To get an idea of the stories he has researched, written and broadcast, please go to the following links: A Matter of TrustFaint Warning (for which he was nominated for a Michener Award in 2003), Prescribed to Death , Dying for a Job and Out of SynchBeaten 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 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 the2007 Excellence in Health Reporting from the Canadian Medical Associationa and the Canadian Nurses’ Association. His latest project, Beaten Down: Fear and violence in Canada’s Nursing Homes, examines the national problem of violence in Canadian long-term care facilities. And he recently followed that up with Off-Limits, an investigation into doctors who continue to prescribe atypical anti-psychotics to seniors despite Health Canada warnings about increased risk of heart attack, stroke — and death. He’s working with The Canadian Press and The Toronto Star on Tasers and food safety , respectively. And for the taser series, David and Jim 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 And he maintains a website that keeps track of access-to-information requests that are made to federal departments, agencies and Crown corporations. The CAIRS site, which used to be maintained by professor Alasdair Roberts, has become a valuable tool for journalists.David obtained a Master of Journalism degree from Carleton University in the summer of 2001. One of the areas he researched was the evolution of computer-assisted, investigative reporting in Canada and the United States. And he was also one of four journalists/journalism instructors who wrote Digging Deeper, a Canadian textbook on investigative research techniques. You can order it by visiting Amazon.ca. And has helped write a second textbook, Computer-Assisted Reporting: A Comprehensive Primer.He also contributed to a textbook on Canada’s Access to Information Act entitled Brokering Access.

ACCESS-TO-INFORMATION(TOP)

 

The Access to Information Act
http://laws-lois.justice.gc.ca/eng/acts/A-1/

The Privacy Act
http://laws-lois.justice.gc.ca/eng/acts/P-21/

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

The top-24 institutions that field federal access-to-information requests

Access to Information and Privacy (ATIP) Online Request
https://atip-aiprp.apps.gc.ca/atip/welcome.do?lang=en

Directive on the Administration of the Access to Information Act (Treasury Board of Canada Secretariat)
http://www.tbs-sct.gc.ca/pol/doc-eng.aspx?section=text&id=18310#appA

Letter to the President of the Treasury Board on improving the performance of the access to information system 
http://www.oic-ci.gc.ca/eng/rapport-annuel-annual-report_2013-2014_12.aspx

The federal government’s initial reforms under the Federal Accountability Act
http://www.tbs-sct.gc.ca/faa-lfi/fs-fi/16/10fs-fi-eng.asp

Federal Departments and Agencies
http://canada.ca/en/gov/dept/index.html

Info Source (directory of holdings)
http://www.infosource.gc.ca/index-eng.asp

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

Brokering Access: Power, Politics, and Freedom of Information Process in Canada
http://www.ubcpress.ca/books/pdf/chapters/2012/BrokeringAccess.pdf

Access to Information Act (including the institutions covered by the law)
http://laws-lois.justice.gc.ca/PDF/Readability/A-1.pdf

Access to Information and Privacy requests can now be made online (Library and Archives Canada Blog)
http://thediscoverblog.com/2014/04/17/access-to-information-and-privacy-requests-can-now-be-made-online/

Completed Access to Information Requests ( a running tally of departments and agencies posting summaries of completed ATI requests)

http://open.gc.ca/eng/completed-access-information-requests

Search Summaries of Completed ATI Requests
http://data.gc.ca/eng/search/ati?

Download updated ATI summaries in csv format

David McKie’s CAIRs page
CAIRS

Access to Information Act and Privacy Act Bulletins
http://www.infosource.gc.ca/bulletin/bulletin-eng.asp

Office of the Information Commissioner (complaints, resources)
http://www.oic-ci.gc.ca/eng/

Report Cards (Information Commissioner)
http://www.oic-ci.gc.ca/eng/rp-pr_spe-rep_rap-spe_rep-car_fic-ren.aspx

Office of the Privacy Commissioner of Canada
https://www.priv.gc.ca/index_e.asp

Teaching Freedom of Information (FOI courses taught at universities around the world)
http://www.right2info.org/resources/teaching-foi

BLOGS

David McKie
http://www.cbc.ca/newsblogs/politics/inside-politics-blog/author/david-mckie/index.html

Alex’s Blog (Alex Himelfarb)
http://afhimelfarb.wordpress.com/alex/

Alexander Holbourn: Information and Privacy Blog
http://informationandprivacylaw.com/

Visible Government
http://visiblegovernment.ca/

The art of access (The blog serves as a companion to an American book by the same name)
http://theartofaccess.com/

Defamation Law Blog
http://defamationlawblog.wordpress.com/

Analysis & Opinion (Reuters)
http://blogs.reuters.com/us/

BOOKS AND STUDIES

The Art of Access: Strategies for Acquiring Public Records
http://www.cqpress.com/product/Art-of-Access-Strategies.html

Federal Access to Information and Privacy Legislation Annotated 2011 by Colonel Michel W. Drapeau & Marc-Aurèle Racicot
http://www.carswell.com/product-detail/federal-access-to-information-and-privacy-legislation-annotated-2014/

Newspapers Canada (access-to-information audits)
http://www.newspaperscanada.ca/FOI

CITIES

Calgary
http://www.calgary.ca/CA/city-clerks/Pages/Freedom-of-Information-and-Protection-of-Privacy/Freedom-of-Information-and-Protection-of-Privacy.aspx

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/irm/index.html

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
http://www.regina.ca/residents/council-committees/learn-city-clerk/access_to_information_and_protection_of_privacy/

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

PROVINCES

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.oipc.bc.ca/
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/public_bodies/public_bodies_under_fippa.html
http://www.gov.mb.ca/chc/fippa/public_bodies/forms.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
http://www.nsrighttoknow.ca/

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-Institution

Yukon
http://www.atipp.gov.yk.ca/

HEALTH AUTHORITIES

Rouge Valley Health System

http://www.rougevalley.ca/access-to-information

INTERNATIONAL

Links to International Freedom of Information offices
http://www.oic-ci.gc.ca/eng/links-liens.aspx
http://www.freedominfo.org/regions/
http://right2info.org/laws

The World Bank

http://www-wds.worldbank.org/external/default/WDSContentServer/WDSP/IB/2010/06/03/000112742_20100603084843/Rendered/PDF/548730Access0I1y0Statement01Final1.pdf

http://www-wds.worldbank.org/WBSITE/EXTERNAL/EXTWDS/0,,detailPagemenuPK:64187510~menuPK:64187513~pagePK:64187848~piPK:64187934~searchPagemenuPK:64187283~siteName:WDS~theSitePK:523679,00.html

Historically Significant FBI Files

http://vault.fbi.gov/

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

governmentattic.org (U.S.)

http://www.governmentattic.org/

The Freedom of Information Act ( The U.S. Department of Justice)
http://www.foia.gov/

governmentattatic.org (FOI logs)

http://www.governmentattic.org/

FOIOnline (FOI requests and previously released records for selected agencies)
foiaonline.regulations.gov

Reporters Committee for the Freedom of the Press (U.S. FOI requests)

http://www.rcfp.org/foiact/index.html

U.S. FOI requests for electronic data by state

http://www.rcfp.org/elecaccess/

National Freedom of Information Coalition: Protecting Your Right to Open Government (U.S.)
http://www.nfoic.org/

The National Archives and Records Administration 
http://www.archives.gov/

U.S. Coalition of Journalists for Open Government

http://www.cjog.net/

U.S. Food and Drug Administration: Electronic Reading Room

http://www.fda.gov/foi/electrr.htm

The FOI Advocate (U.S. news of developments in the area of freedom of information)

http://foiadvocate.blogspot.com/

U.K. FOI requests

http://www.whatdotheyknow.com/

http://www.whatdotheyknow.com/list/successful

The Sunshine Government Initiative (a coalition of U.S. media groups that advocates opening up access to government records)

http://www.sunshineingovernment.org/

ACCESS TO INFORMATION_POLICE(Top)

Calgary Police Service

http://www.calgarypolice.ca/privacyPop.html

Durham Regional Police Service

http://www.drps.ca/internet_explorer/over_the_counter/index.asp?Do_What=fetch&Page=1&ID=10&Category_ID=3

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

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

ACCESS TO INFORMATION STORIES IN THE NEWS(TOP)

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

http://rabble.ca/rabbletv/program-guide/2011/05/best-net/access-information-denied-interview-dean-beeby

Alberta releases first ‘Sunshine list’ of government salaries (CBC News)

http://www.cbc.ca/news/canada/edmonton/alberta-releases-first-sunshine-list-of-government-salaries-1.2519097

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)

http://inforrm.wordpress.com/2011/06/30/another-blow-to-access-to-information-supreme-court-of-canada-denies-access-to-political-documents-in-ministers%E2%80%99-offices/

Budget cuts undermine federal access-to-information system: watchdog (The Canadian Press)

http://www.ctvnews.ca/politics/budget-cuts-undermine-federal-access-to-information-system-watchdog-1.1227794

Canada (Information Commissioner) v. Canada (Minister of National Defence): Democratic Governance, Transparency and Accountability or Exective Priviledge?

http://www.thecourt.ca/2011/05/19/canada-information-commissioner-v-canada-minister-of-national-defence-democratic-governance-transparency-and-accountability-or-executive-privilege

BC Ferries to alter controversial policy on FOI disclosure

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)

http://www.winnipegfreepress.com/business/breakingnews/cbc-one-in-long-list-of-federal-agencies-to-go-up-against-info-czar-in-court-131944473.html

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

Bid to see Champlain Bridge report denied: Gazette to appeal federal body’s ruling (The Gazette)

http://www.montrealgazette.com/news/bridge+report+denied+Gazette+appeal+federal+body+ruling/5330765/story.html

Canada to probe alleged ‘muzzling’ of government scientists (The Japan Times)

http://www.japantimes.co.jp/life/2013/04/04/environment/canada-to-probe-alleged-muzzling-of-government-scientists/#.UWBgT5Osh8E

Chilly White North? Canadian government secrecy on the rise (The Christian Science Monitor)

http://www.csmonitor.com/World/Americas/2013/0405/Chilly-White-North-Canadian-government-secrecy-on-the-rise

CommitteeWatch: Hey, remember formerly alleged Access to Information interferent Sebastien Togneri? (CBCnews_Inside Politics Blog)

http://www.cbc.ca/news/politics/inside-politics-blog/2011/08/committeewatch-hey-remember-formerly-alleged-access-to-information-interferent-sebastien-togneri.html

Conflicting answers on whether complete Mercier Bridge reports will be released (The Gazette)

http://www.montrealgazette.com/news/todays-paper/Conflicting+answers+whether+complete+reports+will+released/5281505/story.html

Court rejects CBC appeal in access-to-information feud (The Canadian Press)

http://www.theglobeandmail.com/news/politics/court-rejects-cbc-appeal-in-access-to-information-feud/article2246240/

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

Even Montreal’s executive committee agenda is shielded (The Gazette)

http://www.montrealgazette.com/news/Even+exec+committee+agenda+shielded/5238086/story.html

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)

http://www.winnipegfreepress.com/canada/breakingnews/feds-appeal-judges-order-to-open-up-rcmp-security-file-on-tommy-douglas–130807383.html

From the bench, a boost for government secrecy (The Globe and Mail)

http://www.theglobeandmail.com/news/politics/from-the-bench-a-boost-for-government-secrecy/article2022108/

Government institutions don’t respect access to information laws (The Hill Timesonline)

http://www.thehilltimes.ca/page/printpage/-08-22-2011

Groups demand inquiry after RCMP drops access to info case (The Gazette)

http://ipolitics.ca/2011/08/30/groups-demand-commons-probe-of-rcmp-decision-to-drop-access-to-info-case/

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)

http://blog.ted.com/2012/10/18/how-freedom-of-information-requests-led-to-a-parliamentary-scandal-read-an-excerpt-from-heather-brookes-book/

Info commish slams Foreign Affairs bureaucrats (Toronto Sun)

http://m.torontosun.com/2012/02/19/info-commish-slams-foreign-affairs-bureaucrats

Perils of BC’s New Freedom of Info Policy (The Tyee)

http://thetyee.ca/Mediacheck/2011/08/31/New-BC-FOI-Policy/

On access to information, Canada is a developing country (The Globe and Mail editorial)

http://www.theglobeandmail.com/news/opinions/editorials/on-access-to-information-canada-is-a-developing-country/article2242001/

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

Restaurant inspection reports may go online (CBC News)

http://www.cbc.ca/news/canada/newfoundland-labrador/story/2012/10/24/nl-reconsidering-making-resto-inspections-available-1024.html

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

Rules are no substitute for cultivating a culture of open government (The Toronto Star)

http://www.thestar.com/opinion/commentary/2013/04/05/rules_are_no_substitute_for_cultivating_a_culture_of_open_government.html

The Gazette’s View: Inspection reports: the stonewalling must stop

http://www.montrealgazette.com/news/Gazette+View+Inspection+reports+stonewalling+must+stop/5336621/story.html

Roadblocks

Five ways Ottawa stymies Access to Information requests (The Globe and Mail)

http://www.theglobeandmail.com/news/politics/five-ways-ottawa-stymies-access-to-information-requests/article1871729/

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)

http://www.cbc.ca/news/politics/inside-politics-blog/2011/05/scoc-says-no-ministerial-agendas-off-limits.html

Stephen Harper could relax now, but will he? (The Globe and Mail)

http://www.theglobeandmail.com/news/opinions/opinion/stephen-harper-could-relax-now-but-will-he/article2025515/

Tasha Kheiriddin: Supreme Court: PM entitled to a hidden agenda (National Post)

http://fullcomment.nationalpost.com/2011/05/13/tasha-kheiriddin-supreme-court-pm-entitled-to-a-hidden-agenda/

The push for Open Government – up to a point (CBC News)

http://www.cbc.ca/news/politics/inside-politics-blog/2012/01/the-push-for-open-government-up-to-a-point.html

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)

http://www.winnipegfreepress.com/canada/breakingnews/truce-called-in-cbc-dispute-at-commons-committee-on-access-to-information-134458068.html

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”)

http://blog.fagstein.com/

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)

InvestD
https://invesd.com/home

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 

CANADIAN BUSINESS (TOP)

Google Finance

http://finance.google.com/finance

http://finance.google.ca/finance

FPinfomart.ca (Canada’s largest provider of news & broadcast media monitoring, financial and corporate data)

http://www.fpinfomart.ca/

Business Terminology

http://www.powerhomebiz.com/Glossary/glossary-A.htm

http://www.cra-arc.gc.ca/menu-eng.html

http://www.investorwords.com/

Business Dictionary
http://www.businessdictionary.com/

Campbell R. Harvey’s Hypertextual Finance Glossary

http://www.duke.edu/~charvey/Classes/wpg/glossary.htm

The Canadian Investor Relations Institute (CIRI)

http://www.ciri.org/Home.aspx

Investopedia

http://www.investopedia.com/

Corporations database online

https://www.ic.gc.ca/app/scr/cc/CorporationsCanada/fdrlCrpSrch.html?locale=en_CA

http://strategis.ic.gc.ca/engdoc/main.html

FAQs for Business Reporters

http://www2.sabew.org/sabewweb.nsf/LinksView/BF535B1E4F81347786256B8200774549

The Globe and Mail Public Policy Wiki

http://policywiki.theglobeandmail.com/tiki-index.php

Resources for Journalists (Society of American Business Editors and Writers, Inc.)

http://www.sabew.org/resources/index.php

Canada NewsWire

http://www.newswire.ca/htmindex/etoday.html

CCN Matthews

http://www.ccnmatthews.com/news/releases/home.jsp

PR Newswire (U.S.)

http://www.prnewswire.com/

CBC Business News

http://www.cbc.ca/business/

Canadian Business Resource Centre

http://www.cbr.ca/Default.aspx

SEDAR (Canada)

http://www.sedar.com/search/search_en.htm

Cyberbahn (fee-for-service)

http://www.cyberbahn.ca/cyberbahn/default.aspx

Advice for Investors

http://www.adviceforinvestors.com/

British Columbia Securities Commission

http://www.bcsc.bc.ca/

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

http://www.gov.ns.ca/nssc/

The Securities Commission of Newfoundland and Labrador

http://www.gs.gov.nl.ca/cca/fsr/rulemaking/

Search for information about private businesses

http://www.cyberbahn.ca/

Search for information about private corporations

http://www.oncorp.com/

Registre des entreprises du Québec

http://www.registreentreprises.gouv.qc.ca/fr/default.aspx

Disciplined Persons ( Canadian Securities Administrators)

http://www.securities-administrators.ca/disciplinedpersons.aspx

Canadian Insider

http://www.canadianinsider.com/

Bankruptcy

http://strategis.ic.gc.ca/epic/internet/inbsf-osb.nsf/en/home

Intellectual property (patents, trade-marks, copyrights)

http://strategis.ic.gc.ca/sc_mrksv/cipo/new/new-e.html#dec30

Government contract tendering

https://buyandsell.gc.ca/procurement-data/tenders

http://www.merx.com/Services/AboutMERX/English/MK_SiteMap.asp?FLASH=Yes

https://www.crownassets.pwgsc.gc.ca/mn-eng.cfm?snc=wfsav&vndsld=0

GC Surplus

http://www.gcsurplus.ca/mn-eng.cfm

Financial Consumer Agency of Canada (a federal agency that educates and protects consumers)

http://www.fcac-acfc.gc.ca/eng/default.asp

Charities

http://www.cra-arc.gc.ca/chrts-gvng/lstngs/menu-eng.html

Business Edge ( Bi-weekly business news magazine)

http://www.businessedge.ca

Businessjournalism.org

http://www.businessjournalism.org/

Daily Business Buzz (Atlantic Canada’s Source for business news)

http://www.dailybusinessbuzz.ca/

Canada Revenue probe focuses on some RBC DS clients (CBC and Globe and Mail investigation)

http://www.cbc.ca/canada/story/2009/12/13/cra-probe-rbc.html?ref=rss

CANADIAN BUSINESS STATISTICS[Top]

Search for a Federal Corporation (Industry Canada)

https://www.ic.gc.ca/app/scr/cc/CorporationsCanada/fdrlCrpSrch.html

CANSIM tables federal government revenue and expenditures

http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/ind01/l3_3055_3058-eng.htm?hili_none

Statistics Canada

http://www.statcan.gc.ca/dai-quo/index-eng.htm

Economic and Market Research/Statistics (Industry Canada)

http://www.ic.gc.ca/eic/site/ic1.nsf/eng/h_00072.html?OpenDocument&

Stockwatch

http://www.stockwatch.com/

CNW Group

http://www.newswire.ca/en/extras/snapshot.cgi

North American Industry Classification System (NAICS) 2007 (Statistics Canada)

http://www.statcan.gc.ca/subjects-sujets/standard-norme/naics-scian/2007/index-indexe-eng.htm

http://www.statcan.gc.ca/subjects-sujets/standard-norme/naics-scian/2007/list-liste-eng.htm

Insolvency Statistics and Economic Analysis (Office of the Superintendent of Bankruptcy Canada)

http://www.ic.gc.ca/eic/site/bsf-osb.nsf/eng/h_br01011.html

Investment Canada Act (Quarterly Statistics – Industry Canada)

http://www.ic.gc.ca/eic/site/ica-lic.nsf/eng/h_lk00015.html

Manpower Employment Outlook Survey

http://www.manpowergroup.com/wps/wcm/connect/manpowergroup-en/home/thought-leadership/meos/

Catalyst Canada, Inc.

http://www.catalyst.org/

The Progressive Economics Forum

http://www.progressive-economics.ca/

CANADIAN BUSINESS PUBLICATIONS[Top]

Northern Business Ontario

http://www.northernontariobusiness.com/

Alberta Oil: The Business of Energy

http://www.albertaoilmagazine.com

http://www.albertaoilmagazine.com/2011/06/the-top-100-canadian-publicly-traded-oil-gas-companies-2011/

CAR AND ATI-related STORIES(TOP)

Access to airline safety reports held up by court action (CBCNews)

http://www.cbc.ca/news/politics/story/2013/01/22/pol-airline-safety-sms-porter-lawsuit-transport-canada.html

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)

http://www.cbc.ca/news/politics/inside-politics-blog/2011/11/access-to-info-watch-in-search-of-documents-that-never-were.html

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)

http://www.thestar.com/news/canada/politics/article/1095436–air-force-warned-about-backlash-over-mackay-s-chopper-flight?bn=1

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)

http://www.cbc.ca/news/politics/story/2012/06/22/pol-mckie-cbsa-border-agency-surveillance-policy.html

 

Border officer fired for association with convicted criminal (CBCNews)
http://www.cbc.ca/news/politics/border-officer-fired-for-association-with-convicted-criminal-1.2598723

 

Documents show ‘harperization’ of government communications (The Canadian Press)

http://www.theglobeandmail.com/news/politics/documents-show-harperization-of-government-communications/article2253080/?utm_medium=Feeds%3A%20RSS%2FAtom&utm_source=Home&utm_content=2253080

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/montreal/story/2013/03/27/montreal-hot-spot-for-canada-drug-seizures.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)

http://www.cbc.ca/newsblogs/politics/inside-politics-blog/2011/03/canadas-arms-sales-to-the-middle-east.html

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)

http://www.cbc.ca/news/politics/citizenship-backlog-stark-contrast-to-fast-tracked-olympic-skater-1.2470634

Would-be Olympic ice dancer fast-tracked to Canadian citizenship (Global News)

http://ht.ly/tXpM4

Censors must not arbitrarily black out public documents, panel rules (The Globe and Mail)

http://www.theglobeandmail.com/news/politics/censors-must-not-arbitrarily-black-out-public-documents-panel-rules/article2045552/

Complaints against OC Transpo drivers pile up

http://www.ottawacitizen.com/technology/Complaints+against+Transpo+drivers+pile/5201883/story.html?cid=megadrop_story

Clement seeks ‘culture change’ on government transparency (The Globe and Mail)

http://m.theglobeandmail.com/news/politics/ottawa-notebook/clement-seeks-culture-change-on-government-transparency/article2237807/?service=mobile

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)

http://www.theglobeandmail.com/news/politics/conservative-mps-break-ranks-more-often-than-opposition/article8156279/?cs

Contaminated sites across Canada require clean up (CBC News)

http://www.cbc.ca/news/politics/story/2012/05/07/pol-mckie-contaminated-sites-treasury-board-environment.html

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)

http://www.canada.com/edmontonjournal/features/restaurants/story.html?id=b1c81f34-f532-423e-b1e9-3ebfa40ab6e6

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

http://www.cbc.ca/newsblogs/politics/inside-politics-blog/2011/03/bruce-carson-not-alone-in-bankruptcy.html

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)

http://www.cbc.ca/news/canada/newfoundland-labrador/story/2011/03/29/labrador-flight-close-call-329.html

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)

http://www.cbc.ca/news/politics/inside-politics-blog/2010/09/behind-the-numbers-the-g8g20-expenses-debate-is-it-really-about-transparency.html

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

The New York Times spent 10 months investigating business incentives awarded by hundreds of cities, counties and states

Europe’s Hidden Billions – tracking EU structural funds (The Financial Times)

http://www.ft.com/eu-funds

Facts & Figures (The Chronicle of Higher Education)

http://chronicle.com/section/Facts-Figures/58/

Faint Warning ( CBC National Radio News)

http://www.cbc.ca/news/adr/

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/news/politics/story/2012/08/03/pol-the-house-federal-cuts-threaten-program-hiring-vets.html

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

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

Increase in STDs in region alarming: officials: Health departments link rise to reduced condom use (The Ottawa Citizen)

http://www.ottawacitizen.com/health/Increase+STDs+region+alarming+officials/3618141/story.html

Stemming the spread of STDs: Sexual health clinic expanded to handle the rising number of cases of infection (The Ottawa Citizen)

http://www.ottawacitizen.com/health/Sexual+health+clinic+expanded+handle+rising+number+cases/4228762/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)

http://www.ottawacitizen.com/health/Special+Report+Critical+deficiencies+found+shawarma+eateries/2532974/Special+report+Food+thought/2531317/story.html

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/consumer/story/2010/03/29/toyota-recall-investigation.html?ref=rss

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

http://www.cbc.ca/news/canada/windsor/story/2013/06/14/wdr-gun-smuggling-windsor-detroit-border-union-resources.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)

http://www.winnipegfreepress.com/canada/breakingnews/looking-for-art-you-can-get-a-real-steal-at-government-buildings-130490643.html

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)

http://www.montrealgazette.com/news/MacKay%2Btook%2Btaxpayer%2Bfunded%2Bhelicopter%2Bafter%2Bofficials%2Badvised%2Bagainst%2Bmedia%2Bevent/7880658/story.html

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)

http://www.edmontonjournal.com/mobile/news/top-stories/Medical+marijuana+requests+spike+with+severe+arthritis+most+common/5838887/story.html

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

http://www.cbc.ca/news/politics/inside-politics-blog/2011/09/court-ruling-found-fault-with-medical-marijuana-law.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)

http://www.cbc.ca/news/politics/story/2012/09/07/pol-elliott-sidebar-office-religious-freedom.html?cmp=rss

Natural Resources Minister Joe Oliver said he didn’t ‘know very much’ about energy projects, emails reveal (Post Media)

http://www.calgaryherald.com/news/national/Natural+Resources+Minister+Oliver+said+didn+know+very+much/7478134/story.html

Navigation Protection Act: Government braces for court battles over waterways (CBC News)
http://www.cbc.ca/news/politics/navigation-protection-act-government-braces-for-court-battles-over-waterways-1.2703042

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)

http://www.cbc.ca/news/politics/inside-politics-blog/2012/01/opengov-watch-48-ati-governed-entities-down-150-to-go.html

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

http://www.cbc.ca/news/politics/inside-politics-blog/2010/05/political-contributions-what-the-numbers-say.html

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)

http://www.ctvnews.ca/canada/report-details-encounters-with-rude-accusatory-border-employees-1.940384

Ring of Fire mining may not benefit First Nations as hoped (The CBC)

http://www.cbc.ca/news/politics/story/2013/06/26/pol-ring-of-fire-first-nations-economic-benefit-doubts.html

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)

http://www.ctvbc.ctv.ca/servlet/an/local/CTVNews/20111209/bc_road_side_breath_tests_inaccurate_111209/20111209/?hub=BritishColumbiaHome

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)

http://www.cbc.ca/anewday/episodes/2011/08/22/some-childcare-facilities-fall-short-of-government-standards/

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)

http://www.cbc.ca/news/politics/canadavotes2011/realitycheck/2011/04/tax-breaks-for-volunteer-firefighters—less-than-meets-the-eye.html

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)
http://www.cbc.ca/news/politics/temporary-foreign-worker-program-queries-came-mostly-from-tory-mps-1.2687159

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)

http://www.theglobeandmail.com/news/politics/tory-mp-who-flirted-with-chinese-reporter-passed-security-check/article2162968/singlepage/#articlecontent

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/canada/story/2010/03/22/toyota-recall-celicas.html

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/consumer/story/2010/04/28/toyota-venza.html?ref=rss

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

http://www.cbc.ca/news/politics/story/2013/01/14/pol-foreign-affairs-cfia-us-meat-inspection-xl-foods.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

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)
http://toronto.ctvnews.ca/visits-to-food-banks-in-toronto-s-suburbs-up-almost-20-since-2008-1.1782655

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

http://ca.yahoo.com/

LookSmart

http://search.looksmart.com/

Open Directory Project

http://dmoz.org/

Cluster searches

http://clusty.com/

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)

https://duckduckgo.com/

Firefox Private Browsing

http://support.mozilla.org/en-US/kb/private-browsing-browse-web-without-saving-info

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)

http://www.ontario.ca/ONT/portal51/licensedchildcare/kcxml/04_Sj9SPykssy0xPLMnMz0vM0Y_QjzKLd443cQ4ESYGZlr76kTCxIH1vfV-P_NxU_QD9gtyIckdHRUUAjt9wJQ!!/delta/base64xml/L3dJdyEvd0ZNQUFzQUMvNElVRS82X0NfNENQ

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

http://www.injuryboard.com/

Chemical companies, Big Tobacco and the toxic products in your home (Chicago Tribune.com)

http://media.apps.chicagotribune.com/flames/index.html

COMPUTER-ASSISTED REPORTING(Top)

CBC’s adverse drug reaction database series

http://www.cbc.ca/news/adr

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.nicar.org/

http://data.nicar.org/

http://www.ire.org/resource-center/listservs/subscribe-nicar-l/

Investigative Reporters and Editors, Inc.

http://www.ire.org/

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

http://carincanada.ca/

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

http://searchenginewatch.com/

Jakob Nielsen’s Website (Expert advice on Internet trends and usage)

http://www.useit.com/

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

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

http://excel.tips.net/

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)

http://www.poynter.org/how-tos/digital-strategies/e-media-tidbits/102589/how-to-scrape-websites-for-data-without-programming-skills/

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

CONTRACTS(Top)

Buyandsell.gc.ca

https://buyandsell.gc.ca/procurement-data/tenders

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

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

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)

http://cansim2.statcan.gc.ca/cgi-win/cnsmcgi.pgm?Lang=E&SP_Action=Result&SP_ID=2102&SP_TYP=5&SP_Sort=1&SP_Portal=2

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

http://web.archive.org/web/20070205094752/ottawapolice.ca/en/resources/crime_analysis_statistics/index.cfm

Crime Reports (Ottawa police)

https://www.crimereports.com/

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)

Charities

Recalled Medical Devices

Vehicle Defect Complaints (Transport Canada)

Arms

Hospital infections

Vancouver Sun article

Ottawa Citizen article on domestic violence

Statscan2006 detailed samesex data

Statscan 2001 detailed samesex data

Proactive Disclosure

Ottawa CMA, all violation, 1998-2010

Food recall stats

Contaminated sites

AidData

http://aiddata.org/content/index/AidData-Raw

Data & Research (The World Bank)

http://web.worldbank.org/WBSITE/EXTERNAL/0,,contentMDK:22547097~pagePK:50016803~piPK:50016805~theSitePK:13,00.html

http://econ.worldbank.org/WBSITE/EXTERNAL/EXTDEC/0,,menuPK:476823~pagePK:64165236~piPK:64165141~theSitePK:469372,00.html

Datacatalogs.org (a comprehensive list of open data catalogs currated by experts from around the world)

http://datacatalogs.org/

DATA JOURNALISM (Top)

The ProPublica Nerd Blog
http://www.propublica.org/nerds

The Guardian’s data blog
http://www.theguardian.com/news/datablog

Data Journalism Blog
http://www.datajournalismblog.com

Open (The New York Times)
http://open.blogs.nytimes.com/

Data Desk (The Los Angeles Times)
http://datadesk.latimes.com/

News Apps Blog ( The Chicago Tribune)
http://blog.apps.chicagotribune.com/

DATA VISUALIZATION (Top)

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

Innovation in America (Peter Aldous)

http://www.peteraldhous.com/innovation.html

Overview (visualizations of large document sets)

http://overview.ap.org/

Public Data (Google)

http://www.google.com/publicdata/directory

World Development Indicators (The World Bank)

http://data.worldbank.org/data-catalog/world-development-indicators?cid=GPD_WDI

Code out loud

http://www.newsnerdjobs.com/

Collision-prone: When are you statistically most likely to get in an accident?http://www.wheels.ca/news/49355/

DEFENCE(Top)

CRS Evaluation Reports
http://www.crs-csex.forces.gc.ca/reports-rapports/rp-ev-eng.aspx

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 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

http://www.publicaffairs.ubc.ca/2010/10/26/ubc%E2%80%99s-veterans-transition-program-receives-1-37-million-from-the-bcyukon-command-of-the-royal-canadian-legion/

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

http://www.doaj.org/

WorldCat (WorldCat connects you to the collections and services of more than 10,000 libraries worldwide)

http://www.worldcat.org/

Webopedia

http://www.webopedia.com/

Wikipedia

http://en.wikipedia.org/wiki/Main_Page

Wikiscanner

http://wikiscanner.virgil.gr/

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

http://www.sources.com/

Acronym Finder

http://www.acronymfinder.com/

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

http://epe.lac-bac.gc.ca/

Various Canadian sources

http://www.gdsourcing.ca/indexa.htm

Maps

http://www.multimap.com

Atlas of Canada

http://atlas.gc.ca/site/english/index.html

Books

http://www.bookfinder.com/

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)

http://www.askoxford.com/

The Canadian Illustrated News (1869 to 1883)

http://www.collectionscanada.ca/cin/index-e.html

Dictionary of Canadian Biography

http://www.biographi.ca/EN/

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

http://library.usask.ca/sni/

Acadiensis: The Journal of the History of the Atlantic Region

http://www.lib.unb.ca/Texts/Acadiensis/

Proquest

http://www.proquest.com/

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

DIGITAL NEWS WEBSITES(Top)

Why your phone is suddenly full of explainer journalism (The Globe and Mail)
http://www.theglobeandmail.com/report-on-business/why-your-phone-is-suddenly-full-of-explainer-journalism/article20294501/#dashboard/follows/

The Upshot
http://www.nytimes.com/upshot/?_r=0

Vox Media
http://www.voxmedia.com/#cover

Ricochet
https://ricochetmedia.ca/en

Newsonomics
http://newsonomics.com/

Quartz
http://qz.com/

The Intercept
https://firstlook.org/theintercept/

The Information
https://www.theinformation.com/

FiveThirtyEight
http://fivethirtyeight.com/

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
http://www.slyck.com/ng.php

Tile.Net/Newsgroups (The Reference to Usenet Newsgroups)
http://tile.net/

Cyberfiber Newsgroups
http://www.cyberfiber.com/

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)
http://www.workscape.ca/

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)
http://www.cwhn.ca/about.html

AvCanada (a discussion forum about aviation issues)
http://www.avcanada.ca/forums2/

Canadian Gunnutz
http://www.canadiangunnutz.com/

Ottawa South History Project (Canadian Heritage)
http://www.chin.gc.ca/PM.cgi?pmLANG=English&pmAP=return_full_record&pmLM=News&pmPR=FORUM_DISCUSSION&pmSource=canned&chinKey=16273

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)

http://www.npr.org/2012/06/28/155907705/interactive-inside-the-health-care-ruling#document/p38/a61902

How Nonprofits Spend Millions on Elections and Call it Public Welfare (ProPublica)

http://www.propublica.org/article/how-nonprofits-spend-millions-on-elections-and-call-it-public-welfare

Legal Experts Decode the Supreme Court’s Obamacare Ruling (The Daily Beast)

http://www.thedailybeast.com/articles/2012/06/28/legal-experts-decode-the-supreme-court-s-obamacare-ruling.html

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)
http://www.nydailynews.com/new-york/lawsuits-nypd-double-decade-costing-taxpayers-1b-article-1.1615919

THE ECONOMY(Top)

The Bank of Canada

http://www.bankofcanada.ca/

Bureau of Economic Analysis (U.S. Department of Commerce)

http://bea.gov/

Canadian Centre for Policy Alternatives

https://www.policyalternatives.ca/

The Conference Board of Canada

http://www.conferenceboard.ca/

The Canadian Chamber of Commerce

http://www.chamber.ca/

C.D. Howe Institute

http://www.cdhowe.org/

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

http://thelaurier.ca/

OECD

http://www.oecd.org

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

ELECTIONS(Top)

 

Elections Canada

http://www.elections.ca/scripts/webpep/fin/select_search_option.aspx

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/lists/PartyStandings.aspx?Language=E&Section=03d93c58-f843-49b3-9653-84275c23f3fb&Gender=F

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

British Columbia

Alberta 

http://www.electionsalberta.ab.ca/efpublic/index.cfm?MID=O1

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

http://www.elections.on.ca/en-CA/Tools/FinancialStatementsandContributions/RealTimeDisclosure.htm

Quebec political contributions

http://www.electionsquebec.qc.ca/francais/provincial/financement-et-depenses-electorales/recherche-sur-les-donateurs.php#

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
http://www.desmog.ca/

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

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)

http://topics.nytimes.com/top/reference/timestopics/subjects/k/keystone_pipeline/index.html?scp=9&sq=keystone%20keystone%20pipeline%20maps&st=cse

Imperial Oil’s role in museum’s energy exhibit questioned: Foundation contributed $600,000 over 6 years to exhibit (CBC News)

http://www.cbc.ca/news/canada/ottawa/story/2012/01/23/ottawa-science-energy-exhibit-imperial-oil.html

DesmogCanada

http://www.desmog.ca/

International Energy Agency
http://www.iea.org/

ETHNIC NEWSPAPERS(Top)

The Link (Leading Indo-Canadian Newspaper)

http://thelinkpaper.ca/

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.htmlhttp://www.virtualsalt.com/evalu8it.htmhttp://www.library.cornell.edu/olinuris/ref/webcrit.htmlhttp://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.jhtmlhttp://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.

FEDERAL GOVERNMENT(Top)

Canada News Centre

http://news.gc.ca

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)

http://visiblegovernment.ca/

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

http://www2.parl.gc.ca/Parlinfo/Compilations/parliament/YearsOfService.aspx?Language=E&Menu=HOC-Politic&Section=03d93c58-f843-49b3-9653-84275c23f3fb&Current=True

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

http://recherche-search.gc.ca/s_r?S_08D4T.1ct57n=form&S_08D4T.s3rv5c3=basic&s5t34d=canada&t3mpl1t34d=1&l7c1l3=eng

How Did They Vote

http://www.howdtheyvote.ca/

Canada Gazette

http://www.gazette.gc.ca/

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

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

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

http://sage-geds.tpsgc-pwgsc.gc.ca/cgi-bin/direct500/eng/XEou=CON-BUR,ou=CON-PAR,ou=HOU-AGE,ou=HoC-CdC,o=GC,c=CA

NDP Research Bureau

http://sage-geds.tpsgc-pwgsc.gc.ca/cgi-bin/direct500/eng/XEou=NDP-BUR,ou=NEW-NOU,ou=HOU-AGE,ou=HoC-CdC,o=GC,c=CA

Members of Parliament

http://www.parl.gc.ca/parlinfo/Lists/Members.aspx?Language=E&SortColumn=PartyName&SortDirection=ASC&Parliament=1924d334-6bd0-4cb3-8793-cee640025ff6&Riding=&Name=&Party=0c0ef0db-d14a-4438-8818-784c924f06ae&Province=&Gender=&New=False&Current=False&First=True&Picture=True&Section=False&ElectionDate

http://webinfo.parl.gc.ca/membersofparliament/MainMPsCompleteList.aspx?TimePeriod=Current&Language=E

Liberal critics

http://www.liberal.ca/mp/

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

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

openparliament.ca

http://openparliament.ca/

House Government Bills ( Parliament )

http://www2.parl.gc.ca/HouseBills/BillsGovernment.aspx?Language=E&Mode=1&Parl=40&Ses=3

http://www2.parl.gc.ca/Sites/LOP/LEGISINFO/index.asp?Language=E&List=list&Type=0&Chamber=C&StartList=2&EndList=200&Session=23

Parliamentary Committees

http://www2.parl.gc.ca/CommitteeBusiness/CommitteeList.aspx?Language=E&Mode=1&Parl=40&Ses=3

House of Commons Procedure and Practice

http://www.parl.gc.ca/procedure-book-livre/Document.aspx?sbdid=3F818022-AD6E-411C-B495-EC000CF32935&sbpid=DB76738A-3FD4-4B95-B803-E2F44E31AE59&Language=E&Mode=1

Order Paper questions

http://www.parl.gc.ca/About/House/compendium/web-content/c_d_orderpaperquestions-e.htm

Written Questions (Senate)

http://www.parl.gc.ca/Content/SEN/Chamber/411/OrderPaper/ord-e.htm#QUESTIONS

Written Questions (House of Commons)

http://www.parl.gc.ca/HousePublications/Publication.aspx?Pub=NoticeOrder&Mode=1&Language=E&Parl=41&Ses=1&File=10

The complete list of questions on the Order Paper (click on the “Status of House Business” tab on the left-hand side to obtain a running tally of MPs’ written questions)

http://www2.parl.gc.ca/HouseChamberBusiness/ChamberSittings.aspx?Language=E&Mode=1&Parl=40&Ses=3&View=N

Current list of questions (for the current list of questions, select the Order Paper & Notice Paper tab on the left-hand side, then go to the “Questions” section)

http://www2.parl.gc.ca/HouseChamberBusiness/ChamberSittings.aspx?View=N&Language=E&Mode=1&Parl=40&Ses=3

Reports and Returns Deposited with the Clerk of the House (this is the website were you’ll find ouf if the sessional papers have been produced on that particular day. This link should be checked every day in order to keep track of tabled documents.)

http://www.parl.gc.ca/40/3/parlbus/chambus/house/reports/tablingJanuary192011-e.html

House of Commons Calendar (the dates highlighted in pink, indicate the days when the House is not sitting when documents like sessional papers are tabled)

http://www2.parl.gc.ca/HouseChamberBusiness/ChamberCalendar.aspx?Language=E&Mode=1&Parl=40&Ses=3

House of Commons Journals (a link that provides the returns and reports tabled with the clerk when the House is not in session. The sessional papers that begin with the numbers 8555 are written answers to MPs questions)

http://www2.parl.gc.ca/HouseChamberBusiness/ChamberSittings.aspx?View=J&Language=E&Mode=1&Parl=40&Ses=3

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)

http://www2.parl.gc.ca/housechamberbusiness/ChamberSittings.aspx?View=H&Key=2009&Language=E&Mode=1&Parl=40&Ses=2

Hansard

http://www2.parl.gc.ca/housechamberbusiness/ChamberPublicationIndexSearch.aspx?Language=E&Mode=1&Parl=39&Ses=1

Current and Emerging Issues (Library of Parliament)

http://www.parl.gc.ca/Content/LOP/ResearchPublications/cei-foreword-e.htm

History of electoral ridings

http://www.parl.gc.ca/information/about/process/house/hfer/hfer.asp?Language=E&Search=R&Source=AboutParl_Process

Women in the House of Commons

http://www2.parl.gc.ca/parlinfo/lists/Members.aspx?Language=E&Parliament=8714654b-cdbf-48a2-b1ad-57a3c8ece839&Riding=&Name=&Party=&Province=&Gender=F&New=False&Current=True&First=False&Picture=False&Section=False

Women in the Senate

http://www2.parl.gc.ca/Parlinfo/lists/senators.aspx?Language=E&Parliament=&Name=&Party=&Province=&Gender=M&Current=True&PrimeMinister=0218bf67-ef3a-4a8d-8ab4-0229e4fcaa54&TermEnd=&Ministry=&Picture=False

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)

http://politwitter.ca/

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)

http://fairwhistleblower.ca/

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

FOOD SAFETY(Top)

Ottawa restaurant inspections

http://app06.ottawa.ca/cgi-bin/search/inspections/q.pl?ss=results_en&qt=fsi_s&sq_app_id=fsi&sq_keywords=&sq_field=all&sq_fs_ftcd=&sq_fs_fwcd=&sort=fs_insp_sort+asc%2Cscore+desc

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

http://www.cbc.ca/news/politics/story/2013/01/14/pol-foreign-affairs-cfia-us-meat-inspection-xl-foods.html

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)

http://www.nal.usda.gov/

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)

http://www.foodsafety.gov/

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

http://www.fsis.usda.gov/Search/Search_Results/Index.asp?q=%22Food+Safety+and+Inspection+Service+Canada%22&mode=simple&num=10&as_occt=any&site=FSIS&sort=rel

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)

http://bites.ksu.edu/

dicentra

http://dicentra.com/

The Poultry Site

http://www.thepoultrysite.com/

PerishableNews.com

http://www.perishablenews.com/

fishnews.com

http://www.fishnewseu.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

GOVERNMENT SPENDING(Top)

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)

http://cansim2.statcan.ca/cgi-win/cnsmcgi.exe?Lang=E&RootDir=CII/&ResultTemplate=CII/CII___&Array_Pick=1&ArrayId=1020521

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

http://www.pharmalot.com/

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

http://www.sciencedaily.com

Canadian Centre for Occupational Health and Safety

http://www.ccohs.ca/

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)

http://www.calgaryhealthregion.ca/publichealth/envhealth/inspection_orders/food_establishments.htm#2009

RateMDs.com

http://www.ratemds.com/

Patient Drug News
http://www.patientdrugnews.com/about-patient-drug-news/

HEALTH (PROVINCIAL)(TOP)

Nova Scotia Prescription Monitoring Program

http://www.nspmp.ca/

HEALTH (INTERNATIONAL)(TOP)

International Society For Infectious Diseases

http://www.isid.org/

Centers for Disease Control and Prevention

http://www.cdc.gov/az/c.html

HEALTH POLICY (Top)

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)

http://www.healthydebate.ca/

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)

http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0270040&pattern=Canada+Mortgage+and+Housing&tabMode=dataTable&srchLan=-1&p1=1&p2=-1

Forecasts and Analysis (Canada Mortgage and Housing Corporation)

http://www.cmhc-schl.gc.ca/en/hoficlincl/homain/foan/index.cfm

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)

http://www12.statcan.ca/english/census06/data/profiles/community/Details/Page.cfm?Lang=E&Geo1=PR&Code1=01&Geo2=PR&Code2=01&Data=Count&SearchText=ottawa&SearchType=Begins&SearchPR=01&B1=Immigration%20and%20citizenship&Custom=

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

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

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)

TurboScan: quickly scan multipage documents into high-quality PDFs
https://itunes.apple.com/ca/app/turboscan-quickly-scan-multipage/id342548956?mt=8

Reporters’ Lab Reviews

timeanddata.com

http://www.timeanddate.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/

Mikogo (Free web conferencing and desktop sharing software)

http://www.mikogo.com/product/features/

Join.me.com

https://join.me/

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

http://scraperwiki.com/

Free PDF Text Reader 1.1

http://www.ctdeveloping.com/

Chapter 3: Turning PDFs to Text (ProPublica)

http://www.propublica.org/nerds/item/turning-pdfs-to-text-doc-dollars-guide

Nitro PDF Professional

http://www.nitropdf.com/

Guaranteed PDF Decrypter

http://www.guapdf.com/

PDFUnlock

http://www.pdfunlock.com/

PDFPirate

http://pdfpirate.net/

ABBYY FineReader

http://finereader.abbyy.com/

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

http://www.pdfill.com/

PDFCreator

http://sourceforge.net/projects/pdfcreator/

PDFtoExcel (online converter)

http://www.pdftoexcelonline.com/default.aspx

Zamzar (Free online file conversion)

http://zamzar.com/

Cometdocs( Free online file conversion)

http://www.cometdocs.com/

Able2Extract (Standalone conversion to Excel, Word etc. Probably the best overall choice. Reliable and accurate results)

http://www.investintech.com/prod_a2e.htm

Cogniview

http://www.cogniview.com/

Irfanview (A Windows graphic viewer)

http://www.irfanview.com/

Yousendit

http://www.yousendit.com/

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)

http://www.zoocasa.com/en/

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)

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/

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

Paul McLaughlin: Asking Questions The Art of the Media Interview
http://paulmclaughlin.ca/

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)

http://www.poynter.org/latest-news/mediawire/183816/center-for-investigative-reporting-to-curate-investigative-reporting-on-new-youtube-channel/

INVISIBLE WEB(Top)

Resource Shelf

http://www.resourceshelf.com/

BrightPlanet

http://brightplanet.com/

Price’s List of Lists

http://www.specialissues.com/lol/

Complete Planet (The Deep Web Directory)

http://aip.completeplanet.com

Invisible Web tutorial

http://www.lib.berkeley.edu/TeachingLib/Guides/Internet/InvisibleWeb.html

Search Engine Watch

http://searchenginewatch.com/

Infomine

http://www.infomine.com/

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)

http://www.doaj.org/

WorldCat (Finds items in libraries near you)

http://www.worldcat.org/

Academic Search Engines (JournalismNet)

http://www.peoplesearchpro.com/journalism/search/academic.htm

JOURNALISTS’ BLOGS(TOP)

Brittny Goodsell

http://brittnygoodsell.com/home.html

Brad Cabana

http://www.blogger.com/profile/08957343946915171802

David Eaves

http://eaves.ca/

David Pugliese Defence Watch

http://blogs.ottawacitizen.com/category/news/defence-watch/

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

Kim Bolan: The Real Scoop ( The Vancouver Sun)

http://blogs.vancouversun.com/category/staff/crime-and-justice/the-real-scoop/

Sarah Schmidt (Postmedia News)

http://blogs.canada.com/author/sarahtschmidt/

Aaron Wherry – Beyond the Commons (Macleans.ca)

http://www2.macleans.ca/category/blog-central/beyond-the-commons/

BloombergView

http://www.bloomberg.com/view/

Canada.com

http://www.canada.com/opinion/blogs/index.html

David Gehring (Google)

http://www.linkedin.com/profile/view?authToken=DYP2&authType=name&goback=%2Enpv_7898109_*1_*1_name_DYP2_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1_*1&locale=en_US&id=7898109

Eric Newton (The Nieman Journalism Lab)

http://www.niemanlab.org/author/enewton/

http://www.knightfoundation.org/press-room/press-mention/eric-newton-journalism-schools-arent-changing-quic/

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/

Marion Warnica

http://marionwarnica.com/

Mark Coddington

http://markcoddington.com/

Meg Wilcox

http://www.megwilcox.com/

Nicole S. Cohen

http://nicolescohen.com/

Lisa Johnson (CBC Vancouver)

http://lisa-johnson.ca/

Lisa Roberts

http://lisaroberts.ca/?page_id=12

Melanie Coulson (The Ottawa Citizen)

http://journomel.com/about/

Sam Wang (Princeton Election Consortium)

http://election.princeton.edu/

Nate Silver (FiveThirtyEight)

http://fivethirtyeight.blogs.nytimes.com/

Tamsin McMahon

http://www2.macleans.ca/author/tmcmahon/

The Media Business (Robert G. Picard)

http://themediabusiness.blogspot.ca/

The Filter Buble (Eli Pariser and Peter Koechley)

http://www.thefilterbubble.com/

Taylor Owen

http://taylorowen.com/

The Ottawa Citizen

http://www.ottawacitizen.com/opinion/blogs/index.html

The Bulldog (A blog by Ken Gray)

http://bulldogottawa.com/

The Huffington Post

http://www.huffingtonpost.com/the-blog/

WSJ blogs

http://blogs.wsj.com/

JOURNALISM EDUCATION(Top)

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)

http://towcenter.org/

Reuters Institute for the Study of Journalism

http://reutersinstitute.politics.ox.ac.uk/

UBC Graduate School of Journalism

http://journalism.ubc.ca/

Philip Merrill College of Journalism

http://www.merrill.umd.edu/

JOURNALISM RESEARCH(TOP)

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

http://www.forbes.com/sites/adamthierer/2011/12/04/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/

Data Journalism Handbook

http://www.datajournalismhandbook.org/1.0/en/

Math for Journalists:Help With Numbers (Poynter.news university)

https://www.newsu.org/courses/math-for-journalists

Newseum

http://www.newseum.org/

Society of Profesional Journalists eCampus

https://www.spj.org/trainingondemand.asp

JEFF SONDERMAN
http://jeffsonderman.com/

JOURNALISM RESOURCE SITES(TOP)

The Tow Center for Digital Journalism
http://newsle.com/article/0/135646330/

CNet (a well-respected technology website)

http://news.cnet.com/

The Canadian Journalism Project

http://www.j-source.ca/

The Canadian Association of Journalists

http://www.caj.ca/

Canadian Journalists for Free Expression

http://www.cjfe.org/

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

Journalist’s Toolbox

http://www.journaliststoolbox.org/

PowerReportering (resource for journalists)

http://www.powerreporting.com/category/Alerts_for_journalists

http://powerreporting.com/

Committee to Protect Journalists (Defending Journalists Worldwide)

http://www.cpj.org/

ChangeDetection.com

http://www.changedetection.com/

blinkx

http://www.blinkx.com/

Online Education Database

http://oedb.org/library/college-basics/research-beyond-google

Investigative Reporters and Editors

http://www.ire.org/

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

http://www.howstuffworks.com/

Media magazine

http://www.caj.ca/?cat=4

Logan Symposium

http://investigativereportingprogram.com/logan-symposium/

The scoop (A blog maintained by computer-assisted reporting specialist Derek Willis)

http://blog.thescoop.org/

FINAL REPORT ON THE CANADIAN NEWS MEDIA (Standing Senate Committee on Transport and Communications)

http://www.parl.gc.ca/39/1/parlbus/commbus/senate/Com-e/TRAN-E/rep-e/repfinjun06vol1-e.htm#TABLE_OF_CONTENTS

ProPublica: Journalism in the Public Interest

http://www.propublica.org/

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

http://journalists.org/

Adrian Holovaty (web developer and Chicago-based journalist)

http://www.holovaty.com/

Online Journalism Review

http://www.ojr.org/

NowPublic (crowd powered media)

http://www.nowpublic.com/

Orato ( True stories from real people)

http://www.orato.com/

International Consortium of Investigative Journalists

http://www.publicintegrity.org/icij/

International Journalists’ Network
http://ijnet.org/

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

http://www.kirklapointe.com/

Infomart

http://www.infomart.ca/

Canada.com

http://www.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

http://ipolitics.ca/

World news

http://wn.com/

Association for Education in Journalism and Mass Communication

http://www.aejmc.org/

Independent media

http://www.indymedia.org/

Independent Media TV

http://www.independent-media.tv/about.cfm

DiversityWatch

http://www.diversitywatch.ryerson.ca/media/

ABYZ News Links

http://www.abyznewslinks.com/

Newspaper archives

http://www.newspaperarchive.com/

http://www.paperofrecord.com/

AllYouCanRead

http://www.allyoucanread.com/

Sept.11 Archives

http://www.september11archive.com/

Canadian Community Newspapers Association (CCNA)

http://www.ccna.ca/

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

http://www.hospitalnews.com

Medical Doctor (a Canadian website that tracks medical coverage)

http://www.mediadoctor.ca/

Columbia Journalism Review

http://www.cjr.org/

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)

http://www.counterpunch.org/

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)

http://snopes.com

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

http://english.ohmynews.com/

Canadian Association of Internet Providers

http://www.cata.ca/

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)

http://www.legacy.com/NS/

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)

http://webcitybeat.com/

Scribd.com

http://www.scribd.com/

Marion Warnica

http://marionwarnica.com/

The New York Review of Books

http://www.nybooks.com/

OWNI.EU Digital Journalism (Technology, Politics and Culture)

http://owni.eu/

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)

http://www.huffingtonpost.ca/

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

http://powerreporting.com/

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)

http://www.journalismnet.com/

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 )

http://www.newscollege.ca/

News University (A project of The Poynter Institute for Media Studies funded)

http://www.newsu.org/

No Train, No Gain

http://www.notrain-nogain.com/

Online tutorials from Brown University

https://wiki.brown.edu/confluence/labels/viewlabel.action?id=59&key=$generalUtil.urlEncode($spaceKey)&startIndex=0

Poynter Institutue

http://www.poynter.org/

Knowledgewebb (Baltimore-based online training for people working in the digital media)

http://www.knowledgewebb.net/

Writing About Business (The New Columbia Knight – Bagehot Guide to Economics & Business Journalism)

http://books.google.ca/books?id=JAiiSqgFIFMC&dq=Writing+about+Business:+The+New+Columbia+Knight-Bagehot+Guide+to+Economics+%26+Business+Journalism&printsec=frontcover&source=bl&ots=TdyOGM4Dyx&sig=0Uo7lZDbqr70u60fpzY4KibE8b0&hl=en&ei=2Z4kSq6PH5vMMtHw-IEF&sa=X&oi=book_result&ct=result&resnum=1

Society of Professional Journalists

http://www.spj.org/

Citizen Journalism course at Kwantlen Polytechnic University

http://beyourownjournalist.com/

KEY WORD SEARCH ENGINES(TOP)

Google

http://www.google.ca/

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

http://searchenginewatch.com/

Yahoo Search

http://search.yahoo.com/

Windows Live (MSN Search)

http://www.live.com/?searchonly=true&mkt=en-ca

AlltheWeb

http://www.alltheweb.com/

Wisenut

http://wisenut.com/

Vivisimo

http://vivisimo.com/

Killer Info

http://www.killerinfo.com/

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)

http://www.baidu.com/

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)

http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Rp-eng.cfm?TABID=6&LANG=E&APATH=3&DETAIL=0&DIM=3&FL=A&FREE=0&GC=01&GID=837928&GK=1&GRP=1&PID=92105&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=74&VID=15743&VNAMEE=&VNAMEF=&D1=0&D2=0&D3=0&D4=0&D5=0&D6=0

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

http://www.titlesearchers.ca/

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

http://www.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)

http://adidem.org/Main_Page

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

http://www.jus.gov.mb.ca/

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)

http://www.ipblog.ca/

Bankruptcydata.com

http://www.bankruptcydata.com/default.asp

Findlaw

http://www.findlaw.com/index.html?srchfindlaw

Smoking Gun

http://www.thesmokinggun.com/

British and Irish Legal Information Institute

http://www.bailii.org/

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

LESSON PLANS (Top)

Week one

5206-14-PowerPointOne.ppt

5206-14-PowerPointTwo.ppt

Canada Revenue Agency reviewing issue of taxpayers wrongfully declared dead (Ottawa Citizen)

Week two

5206-14-PowerPointThree.ppt

Week three

Experts say wireless auction likely won’t increase competition (The Canadian Press)

Rogers

SEDAR

Rogers 2013 Proxy Circular

Cometdocs

Rogers 2013 Proxy Circular in Excel

Rogers 2013 annual reports uploaded to DocumentCloud

BlackBerr y FinancialStatement_2012.xlsx

5206-14-PowerPointFour.ppt

Week four

Instructions for embedding your financial statement.pdf

Instructions for Infogr.pdf

5206-14-PowerPointFive.ppt

5206-14-PowerPointSix.ppt

Canada – Total entries of foreign students by source country_000016-eng.xls

Monthly Service Request Submissions_JanSR-311-2013.xlsx

Week five

Newfoundland premier does about-face
http://metronews.ca/news/canada/924956/newfoundland-premier-does-about-face/

Alberta releases first ‘Sunshine list’ of government salaries (CBC News)
http://www.cbc.ca/news/canada/edmonton/alberta-releases-first-sunshine-list-of-government-salaries-1.2519097

Alberta’s Public Sector Salary Disclosure
http://alberta.ca/SalaryDisclosure.cfm
http://data.alberta.ca/data/public-disclosure-salary-and-severance

Ontario’s Public Sector Salary Disclosure
http://www.fin.gov.on.ca/en/publications/salarydisclosure/2013/

Elections Canada Financial Reports
http://www.elections.ca/WPAPPS/WPF/Home
FederalCampaignContributions.zip

Elections Ontario
http://www.elections.on.ca/en-CA/Tools/FinancialStatementsandContributions/RealTimeDisclosure.htm

Elections  Quebec
http://www.electionsquebec.qc.ca/francais/provincial/financement-et-depenses-electorales/recherche-sur-les-donateurs.php#

Pivot Table Tutorial for the Alberta.pdf

Part two of an Excel tutorial using the the Alberta.pdf

Pivot Table tutorial for Macs.pdf

Week six

Canada Revenue Agency Charities Listings
http://www.cra-arc.gc.ca/chrts-gvng/lstngs/menu-eng.html

Fusion Table map of revoked charities
https://www.google.com/fusiontables/data?docid=16WGWW6eH0p9qIaUE4AtTqeN4dwT4iB6yHVF5j4U#map:id=3

Fustion Table Chart of Top-Ten Cities With Revoked Charities

Revoked Charities Database

Complete Charities database

Ottawa Police
http://www.ottawapolice.ca/en/CrimeFiles/CrimeMaps_Reports/crimestats.aspx

Ottawa Crime  data

Fusion Table Heat Map For Break and Enters

https://www.google.com/fusiontables/DataSource?docid=1VXvMgn9Sqvf1TkQb5t9_GKOJcCNgQYbwCPM1tkI#map:id=3

Fusion Table Bar Graph for Break and Enters
https://www.google.com/fusiontables/DataSource?docid=1BGm-RX967kSISIBafeJEZrxs5lhskWslpzRWzT4#chartnew:id=3

Government Information (Carleton Library)
http://www.library.carleton.ca/research/course-guides/busi-2208/government-information

Tutorial for mapping revoked charities.pdf

Week Seven

BreakandEnters2012.xlsx

Use the “save as”  option to download the Ottawa wards KML file

Heat map tutorial.pdf

Week Eight

5206-14-PowerPointSeven.pptx

Citizenship backlog stark contrast to fast-tracked Olympic skater (CBC News)
http://www.cbc.ca/news/politics/citizenship-backlog-stark-contrast-to-fast-tracked-olympic-skater-1.2470634

Would-be Olympic ice dancer fast-tracked to Canadian citizenship (Global News)
http://ht.ly/tXpM4

The statistics the drove the CBC News citizenship story

Privy Council Office briefing note regarding BlackBerry meeting

The Excel chronology for the BlackBerry story

Week Nine

Rob Ford interview with Peter Mansbridge
https://www.youtube.com/watch?v=JY1nExxVASY

Partial transcription of Mansbridge interview with the Fords

Paul McLaughlin: Asking Questions The Art of the Media Interview
http://paulmclaughlin.ca/

5206-14-PowerPointEight.ppt

TwitterFake.pdf

Faking a Tweet
http://www.lemmetweetthatforyou.com/

Deep Twitter search
https://twitter.com/search-advanced

Central divorce registry
http://www.justice.gc.ca/eng/fl-df/divorce/crdp-bead.html

Ontario lien search
https://www.services.gov.on.ca/locations/serviceDetails.do?id=83

Ontario property search
http://www.teranet.ca/node/7

Language school declares bankruptcy:Liabilities total $2.8M; teachers, staff seek wages (The Ottawa Citizen)
http://www.ottawacitizen.com/Language+school+declares+bankruptcy/9565333/story.html

Ecole De Langues de Lestrie Inc.pdf

RCMP seize banking records for former PMO staffer Bruce Carson (CBC News)
http://www.cbc.ca/news/politics/rcmp-seize-banking-records-for-former-pmo-staffer-bruce-carson-1.2561271

Carson Response.pdf

Office of the Commissioner of Lobbying of Canada
http://www.ocl-cal.gc.ca/eic/site/012.nsf/eng/home

Bankruptcy
http://strategis.ic.gc.ca/epic/internet/inbsf-osb.nsf/en/home

Bruce Carson_Statement of Affairs_AR-M355N_20110329_120222.pdf

Bruce Carson affidavit in insolvency case.pdf

Bruce Carson_Statement of Affairs (liabilities) AR-M355N_20110329_120626.pdf

Entegrity stories.pdf

Integrity court docs.pdf

78445103-Court-documents-relating-to-charges-against-Jeffrey-Paul-Delisle.pdf

Jeffrey Paul Delisle court docs.pdf

Week Ten

Ontario presses for monitoring of Korea trade deal’s impact on auto sector (The Globe and Mail)
http://www.theglobeandmail.com/report-on-business/economy/manufacturing-groups-laud-sales-prospects-after-trade-deal-inked/article17424569/

Free-trade deal with South Korea may give Harper the political boost he needs (Ottawa Citizen)
http://www.ottawacitizen.com/business/Free+trade+deal+with+South+Korea+give+Harper+political+boost+needs/9605710/story.html

Canadian Import and Export Stats (Industry Canada)
http://strategis.ic.gc.ca/sc_mrkti/tdst/tdo/tdo.php#tag

Federal prosecutors open criminal probe of GM recall (Reuters)
http://www.theglobeandmail.com/report-on-business/federal-prosecutors-open-criminal-probe-of-gm-recall/article17446392/?cmpid=rss1

303 Deaths Seen in G.M. Cars With Failed Air Bags (The New York Times)
http://www.nytimes.com/2014/03/14/business/gm-air-bag-failures-linked-to-303-deaths.html?emc=edit_na_20140313&nlid=29021587&_r=1

GM Criminal Probe of Recalls Complicates Barra Turnaround (Bloomberg)
http://www.bloomberg.com/news/2014-03-12/gm-criminal-probe-of-recalls-complicates-barra-turnaround.html

Search for Complaints (the U.S. National Highway Traffic Safety Administration )
http://www-odi.nhtsa.dot.gov/complaints/

Downloadable databases from the U.S. National Highway Traffic Safety Administration
http://www-odi.nhtsa.dot.gov/downloads/

Transport Canada’s Searchable On-line Road Safety  Recalls Database
http://www.tc.gc.ca/eng/motorvehiclesafety/safevehicles-defectinvestigations-index-76.htm

Downloadable vehicle recall databases from Transport Canada
http://data.gc.ca/data/en/dataset?q=vehicle+recalls

5206-14-PowerPointNine.ppt

5206-Ship-Audio.wav

n_Taser-Dziekanski20080330T2030.mpg

Week Eleven

More discarded needles being found in Ottawa’s suburbs (CBC News)
http://www.cbc.ca/news/canada/ottawa/more-discarded-needles-being-found-in-ottawa-s-suburbs-1.2572573

5206-14-PowerPointTen.ppt

National Class Action Database (The Canadian Bar Association)
http://www.cba.org/classactions/main/gate/index/

The Canadian Legal Information Institute
http://canlii.org/en/index.php

Supreme Court of Canada
http://www.scc-csc.gc.ca/home-accueil/index-eng.aspx#

Federal Court
http://cas-ncr-nter03.cas-satj.gc.ca/portal/page/portal/fc_cf_en/Index

Judgement of the Supreme Court of Canada
http://scc-csc.lexum.com/scc-csc/en/nav.do

Language school declares bankruptcy:Liabilities total $2.8M; teachers, staff seek wages (The Ottawa Citizen)
http://www.ottawacitizen.com/Language+school+declares+bankruptcy/9565333/story.html

Bankruptcy
http://strategis.ic.gc.ca/epic/internet/inbsf-osb.nsf/en/home

Ecole De Langues de Lestrie Inc.pdf

DelisleSearchWarrant.pdf

DelisleSearchWarrantReportVehicle.pdf

DelisleSearchWarrantReportHome.pdf

Week twelve

CBC Should Banish Paid Speeches (Huffington Post)
http://www.huffingtonpost.ca/frank-koller/paid-speeches-cbc_b_4966651.html

Tories write off $4B in 2012-13
http://www.ottawacitizen.com/news/Tories+write+2012/9136020/story.html

Public Accounts (Government-wide)
http://data.gc.ca/data/en/dataset?q=public+accounts&sort=relevance+asc&organization=tbs-sct

Public Accounts of Canada 2013
http://www.tpsgc-pwgsc.gc.ca/recgen/cpc-pac/2013/index-eng.html

Definition: Liens, available through provincial and territorial government offices, are records of consumer and busines loans to individuals who use their property as collateral. – Source: Digging Deeper: A Canadian Reporter’s Research Guide

Lien (PPSA) Search

http://www.ppsa.ca/ppsacaV3/ppsa_search/ppsa_search1.jsp

Canada Search and Registry Corp.

http://www.csrcorp.ca/wwstore/item.wws?sku=VHCAN34

Alberta

http://www.servicealberta.ca/208.cfm

British Columbia

https://www.bconline.gov.bc.ca/

Manitoba

https://direct.gov.mb.ca/pprhtml/html/internet/en/ppr.html

New Brunswick

https://pprs.acol.ca/lc/acptTerms.do

Newfoundland and Labrador

http://www.acol.ca/Services/PPR/NF/menu.html

Northwest Territories

http://www.justice.gov.nt.ca/PropertyRegistry/ppr_liencheck.shtml

Nova Scotia

http://www.gov.ns.ca/snsmr/property/default.asp?mn=282.46.82.358

Nunavut

http://www.justice.gov.nu.ca/i18n/french/legreg/lt_index.shtm

Ontario

http://www.ontario.ca/en/services_for_business/access_now/STEL01_086166.html

Prince Edward Island

http://www.gov.pe.ca/infopei/index.php3?number=1034615&lang=E

Quebec

http://www.mrn.gouv.qc.ca/

Saskatchewan

http://www.isc.ca/Pages/default.aspx

Yukon

https://ppsr.gov.yk.ca/pls/apex32p/f?p=109:1:3681372969564095

LIBRARIES/ARCHIVES (TOP)

Library of Parliament

http://www.parl.gc.ca/common/library_prb.asp?Language=E

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

http://www.ipl.org/

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

http://www.proquest.com/

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

http://www.ocl-cal.gc.ca/eic/site/lobbyist-lobbyiste1.nsf/eng/h_nx00274.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

http://www.arcpub.com/lm.htm

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)

http://pogo.org/

MAPPING(TOP)

Geographic Information Systems (Algonquin College)
http://www3.algonquincollege.com/sat/program/geographic-information-systems/

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

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/

Geovisualization_QGIS.pdf

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

Natural Resources Canada’s collection of maps

http://geogratis.cgdi.gc.ca/geogratis/en/collection/search.do#E

Natural Resources Canada ( Understanding projections)

http://atlas.nrcan.gc.ca/site/english/learningresources/carto_corner/map_projections.html/#choosing

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

GeoCoder (converts addresses into longitude and latidue for use in mapping)

http://www.batchgeo.com/

Latitude and longitude locator

http://www.kenjikojima.com/jikankei/map.html

GeoBase

http://www.geobase.ca/geobase/en/index.html

GeoCoder.ca

http://geocoder.ca/

Geocommons

http://geocommons.com/

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/about/press-releases/2014/tableau-82-brings-data-mac-and-data-storytelling-everyone

http://www.tableausoftware.com/public/ire

Tableau tutorials

http://www.jewelloree.com/

Google Fusion Tables

https://www.google.com/accounts/ServiceLogin?service=fusiontables&passive=1209600&continue=http://www.google.com/fusiontables/Home&followup=http://www.google.com/fusiontables/Home

Googe Fusion Tables discussion group

https://groups.google.com/forum/#!topic/fusion-tables-users-group/4SVxAew5P78

Google Fusion Table (shape file to KML conversion)

http://www.shpescape.com/

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)

http://colorbrewer2.org/

A map to help voters find their polling places using Fusion Tables as a data source (Google fusion tables)

https://docs.google.com/a/baycitizen.org/document/d/1hgRO3DMvppG9zySelxTT787YsdKWNzFHu_g5Rbex2nU/edit?hl=en_US&pli=1#

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)

http://gut.sfgeo.org/

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)

http://www.shpescape.com/

Patrickcain.ca (A journalist who makes maps for the Web)

http://www.patrickcain.ca/

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

http://thinkquarterly.co.uk/

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)

http://www12.statcan.gc.ca/census-recensement/2011/dp-pd/prof/details/download-telecharger/comprehensive/comp-ivt-xml-dwnld-tlchrgr.cfm?Lang=E

2006 Census Population (Statistics Canada)

http://www12.statcan.gc.ca/census-recensement/2006/index-eng.cfm

2006 Census Income and Earnings

http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/St-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=0&Temporal=2006&THEME=81&VID=0&VNAMEE=&VNAMEF=

2006 Census Household Income

http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=814&Temporal=2006&THEME=81&VID=0&VNAMEE=&VNAMEF=

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

Fusion Table Test

MAPPING STORIES(TOP)

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)
http://www.cbc.ca/news/politics/contaminated-sites-cleanup-to-cost-billions-more-budget-office-says-1.2604939

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/

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

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)
http://www.cbc.ca/news/canada/ottawa/more-discarded-needles-being-found-in-ottawa-s-suburbs-1.2572573

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/

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)

http://www.vancouversun.com/life/Vancouver+ethnic+enclave+series+Family+church+important+Filipinos/5559392/story.html

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)

http://predictor.hillandknowlton.ca/predictor/index.php?o=sp&j=6:0.398,4:0.302,3:0.165,2:0.04,5:0.083,1:0.012&r=0

Enbridge affiliates have had 175 leaks, spills over 10 years in U.S. (The Ottawa Citizen)

http://www.ottawacitizen.com/technology/Enbridge+affiliates+have+leaks+spills+over+years/5987092/story.html

Explore the data: Toronto bicycle collisions mapped over 25 years (The Globe and Mail)

http://www.theglobeandmail.com/news/toronto/explore-the-data-toronto-bicycle-collisions-mapped-over-25-years/article543684/

50 ridings to watch in the 2011 election (The Globe and Mail)

http://www.theglobeandmail.com:80/news/politics/50-ridings-to-watch-in-the-2011-election/article1957425/?from=1957526

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)

http://www.slate.com/articles/news_and_politics/crime/2012/12/gun_death_tally_every_american_gun_death_since_newtown_sandy_hook_shooting.html

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)

http://www.globaltoronto.com/interactive+map+data+links+low+income+to+poor+eqao+test+results/6442705166/story.html

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)

http://www.macon.com/2011/09/25/1717493/interactive-map-bibb-countys-congressional.html#storylink=misearch

Interactive: Making the WNYC Census Map (JohnKeefe.net)

http://johnkeefe.net/47474697

Interactive: SNAPSHOT: Motorcycles per 1,000 residents, 2010 (boston.com)

http://www.boston.com/yourtown/specials/snapshot/snapshot_massachusetts_motorcycles_per_1000_residents_2010/

Interactive Map: Explore the data behind Toronto’s working poor (The globe and Mail)

http://www.theglobeandmail.com/news/toronto/interactive-map-explore-the-data-behind-torontos-working-poor/article2332885/

Interactive: City of Toronto homicides and gang activity, 2008 to present

http://www.theglobeandmail.com/news/toronto/interactive-city-of-toronto-homicides-and-gang-activity-2008-to-present/article4240673/

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)

http://www.dallasnews.com/entertainment/headlines/20111206-map-see-dallas-area-holiday-light-displays.ece

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)

http://communities.canada.com/vancouversun/blogs/papertrail/archive/2011/02/26/bc-liberal-leadership-vote-by-the-numbers-exclusive-maps-graphs-and-analysis.aspx

(902)-9-1-1 (A King’s College Investigation)

http://902911.kingsjournalism.com/

Comment vos voisins ont-ils voté en 2008? (Cyberpresse.ca)

http://www.cyberpresse.ca/actualites/elections-federales/resultats-des-elections-federales-2008/?utm_categorieinterne=trafficdrivers&utm_contenuinterne=cyberpresse_B2_carte-interactive_1474045_section_POS1

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)

http://www.globalmaritimes.com/global+news+exclusive+maritimers+leading+the+way+in+organ+donor+registration/6442494330/story.html

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)

http://seattletimes.nwsource.com/flatpages/specialreports/methadone/methadoneandthepoliticsofpain.html

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)

http://thestar.blogs.com/maps/2009/02/map-2008-marijuana-grow-operations——marijuana-grow-op-busts-in-toronto-were-down-in-2008-at-145-compared-t.html

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

http://www.vancouversun.com/life/Mapping+ethnicity+Part+Family+church+important+Filipinos/5559392/story.html

http://blogs.vancouversun.com/2011/10/19/ethnic-mapping-5-find-metros-dutch-blacks-germans-and-iranians/

http://www.vancouversun.com/news/Metro+ethnic+enclaves+expand+will+residents+trust+hold/5578612/story.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)

http://www.vancouversun.com/business/Oilsands+details+available+through+single+government+website/5690817/story.html

http://www.vancouversun.com/business/Oilsands+details+available+through+single+government+website/5690817/story.html

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)

http://www.twincities.com/localnews/ci_20953465/pioneer-press-investigation-st-paul-gun-incident-reports

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

http://www.thestar.com/opinion/editorialopinion/2013/03/03/the_deadly_mixture_of_guns_and_class_in_toronto.html

Why Taxpayers Will Bail Out the Rich When the Next Storm Hits (NBC News)
http://www.nbcnews.com/news/investigations/why-taxpayers-will-bail-out-rich-when-next-storm-hits-n25901
http://www.nbcnews.com/news/investigations/meet-flood-insurance-robin-hood-who-saves-condo-owners-millions-n26711
http://www.nbcnews.com/news/us-news/average-joes-fighting-fema-flood-maps-isnt-easy-or-cheap-n23871
http://www.nbcnews.com/news/investigations/fbi-investigates-fema-flood-map-changes-after-nbc-news-report-n62906

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

http://blog.apps.chicagotribune.com/2010/03/04/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

Geocoding

Cracking PDS

Tableau Public

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

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

TotalIncome_PH_2005.xlsx

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

ArcGIS Video Tutorials

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)
https://vimeo.com/92914327

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

http://www.fda.gov/MedicalDevices/DeviceRegulationandGuidance/PostmarketRequirements/ReportingAdverseEvents/ucm127891.htm

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)

http://www.cbc.ca/marketplace/blog/2010/06/investigation-medical-device-licence-pulled-but-still-on-the-market.html

Recalled Medical Devices

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

http://www.bloglines.com/

Blog search (blog search)

http://www.technorati.com/

Google’s BlogSearch

http://blogsearch.google.com/

Sphere

http://www.sphere.com

Feedster

http://www.feedster.com/

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

http://www.timeanddate.com/

Weather (Environment Canada)

http://www.weatheroffice.gc.ca/canada_e.html

Bank of Canada exchange rate converter

http://www.bankofcanada.ca/en/exchform.htm

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

MONEY(TOP)

Free Lunch: How the Wealthiest Americans Enrich Themselves at Government Expense (and Stick you with the bill)

http://www.scribd.com/doc/62818741/David-Cay-Johnston-Free-Lunch-How-the-Wealthiest-Americans-Enrich-Themselves-at-Government-Expense-and-Stick-You-With-the-Bill-2007

GetSmarterAboutMoney.ca

http://www.getsmarteraboutmoney.ca/en/Pages/default.aspx

3Dpolicy.ca

http://3dpolicy.ca/

Multi-media(TOP)

Liveleak

http://liveleak.com/

YouTube

http://www.youtube.com/

Blinkx (Over 35 million hours of video. Search it all.)

http://www.blinkx.com/

Facebook

http://www.facebook.com/

The Tyee

http://thetyee.ca/

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)

http://www.munimall.net

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)

http://hlbtoo.wordpress.com/

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.0/en/server-sql-mode.html

NUMERACY SKILLS(TOP)

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

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

www.robertniles.com/stats

John Allen Paulos

www.math.temple.edu/~paulos

No Train No Gain

www.notrain-nogain.org

http://www.notrain-nogain.org/Train/Res/Num/NUM.asp

The Poynter Institute

www.poynter.org

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

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

Ottawa Police Board minutes

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

http://www.ottawaplus.ca/

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)

http://canmetenergy-canmetenergie.nrcan-rncan.gc.ca/eng/buildings_communities/communities/publications/ottawa.html

ONLINE NEWS SITES(TOP)

The Huffington Post (Canada)

http://www.huffingtonpost.ca/

The Canadian Journalism Project

http://www.j-source.ca/

Open File (Community-powered news in several Canadian cities)

http://toronto.openfile.ca/

bclocalnews.com

http://www.bclocalnews.com/

OPEN DATA GOVERNMENT WEBSITES(Top)

Edmonton

http://data.edmonton.ca/

Halifax’s Open Data Catalogue

https://www.halifaxopendata.ca/

Government-Wide Reporting — Proactive Disclosure

http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp

Ottawa

http://data.ottawa.ca/en/?page=1

Ottawa restaurant inspections

http://app06.ottawa.ca/cgi-bin/search/inspections/q.pl?ss=results_en&qt=fsi_s&sq_app_id=fsi&sq_keywords=&sq_field=all&sq_fs_ftcd=&sq_fs_fwcd=&sort=fs_insp_sort+asc%2Cscore+desc

Toronto

http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD

Vancouver

http://data.vancouver.ca/

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/

Ontario

http://www.ontario.ca/government/open-data-ontario

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/

Open Data Pilot Project (federal government)

http://www.data.gc.ca/default.asp?lang=En

Canadian Open Data Institute

http://opendatainstitute.ca/

World Development Indicators (The World Bank)

http://data.worldbank.org/data-catalog/world-development-indicators?cid=GPD_WDI

Québec Ouvert (les données ouvertes pour le Québec)

http://quebecouvert.org/

The United States

The Department of Transportation

http://www.dot.gov/mission/open/open-government

PEOPLE FINDERS(TOP)

Accurint (LexisNexis)

http://www.accurint.com/

Spokeo

http://www.spokeo.com/

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)

http://fairwhistleblower.ca/

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)

http://experts.dal.ca/

Ixquick International Phone Books

http://us.ixquick.com/

Canada 411

http://canada411.sympatico.ca/

411.ca

http://411.ca/person

Find a Postal Code (Canada Post)

http://www.canadapost.ca/cpotools/apps/fpc/personal/findByCity?execution=e1s1

YellowPages.ca

http://www.yellowpages.ca

VitalCheck (a source for U.S. government-certified vital records)

http://www.vitalchek.com/

Area Code Listing, by Number

http://www.bennetyee.org/ucsd-pages/area.html

PeopleSearch.net

http://peoplesearch.net/

Legacy.com (obituary searches)

http://www.legacy.com/NS/

Omgili forum search engine

http://omgili.com/

Icerocket

http://www.icerocket.com/

Thoora

http://thoora.com/

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

http://www.ipgp.net/

What is my IP address

http://www.whatismyip.com/

Flickr.com

http://www.flickr.com/

Myspace

http://www.myspace.com/

Xanga

http://www.xanga.com/

Friendster

http://www.friendster.com/

Twitter tools

http://friendorfollow.com/

http://tweetake.com/

http://www.topifybeta.com/

Yoname

http://www.yoname.com/

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)

http://www.backcheck.net/

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

http://www.caj.ca/mediamag/Summer%202007%20awards%20edition%20files%20to%20beuploaded/Photojournalism%20.htm

Louie Palu

http://www.louiepalu.com/

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/

POLITICS(TOP)

The Hill ( a blog on U.S. politics )

http://thehill.com/

PolitiFact.com

http://www.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

POPULATION STATISTICS(TOP)

 

Census profile (Statistics Canada)
http://www12.statcan.ca/census-recensement/2011/dp-pd/prof/index.cfm?Lang=E

Selected trend data for Canada, 2006, 2001 and 1996 censuses (Statistics Canada)

http://www12.statcan.ca/english/census06/data/trends/Table_1.cfm?TID=0&T=PR&GEOCODE=01&PRCODE=35&geosubCSD=Submit&GEOLVL=PR

Statistics Canada census data ( from 2001 and 2006 censuses)

http://www12.statcan.ca/english/census06/data/profiles/community/Details/Page.cfm?Lang=E&Geo1=PR&Code1=01&Geo2=PR&Code2=01&Data=Count&SearchText=ottawa&SearchType=Begins&SearchPR=01&B1=All&Custom=

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)

http://ottawa.ca/en/city-hall/official-and-master-plans/ward-boundary-review/appendix-ward-population-and-area

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

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

Winter 2009

Spring 2008

Fall 2007

Spring 2007

PROVINCIAL AUDITS(TOP)

Alberta

http://www.oag.ab.ca/

British Columbia

http://www.bcauditor.com/auditorgeneral.htm

Manitoba

http://www.oag.mb.ca/

New Brunswick

http://www.gnb.ca/oag%2Dbvg/

Newfoundland and Labrador

http://www.ag.gov.nl.ca/ag/

Northwest Territories

http://www.gov.nt.ca/FMBS/

Nova Scotia

http://www.gov.ns.ca/audg/

Nunavut

http://www.gov.nu.ca/finance/public.shtml

Ontario

http://www.auditor.on.ca/

Prince Edward Island

http://www.assembly.pe.ca/auditorgeneral/

Quebec

http://www.vgq.gouv.qc.ca/

Saskatchewan

http://www.auditor.sk.ca/

Yukon

http://www.yukonenergy.ca/about/business/auditor_reports

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

http://www.leg.bc.ca/hansard/

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

http://www.assnat.qc.ca/eng/

Saskatchewan Legislative Assembly

http://www.legassembly.sk.ca/hansard/

Yukon Legislative Assembly

http://www.hansard.gov.yk.ca/

PUBLIC ACCOUNTS(TOP)

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)

http://ottawa.ca/residents/health/statistics/reportable_en.html

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

Bennett Jones 
http://www.bennettjones.com/

Canadians for Tax Fairness
http://www.taxfairness.ca/front

Canadian Policy Research Networks

http://www.cprn.org/en/

Canadian Centre for Policy Alternatives

http://www.policyalternatives.ca/

Canadian Institute for Advanced Research
http://www.cifar.ca/home

Centre for International Policy Studies ( Universit of Ottawa)

http://cips.uottawa.ca/

Institute for Research on Public Policy

http://www.irpp.org/index_en.php

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/

The Polaris Institute

http://www.polarisinstitute.org/

The Parkland Institute

http://www.ualberta.ca/~parkland/

Policy Monitor Canada

http://policymonitor.ca

OpenMedia.ca

http://openmedia.ca/

Congressional Research Service (The “Congress’s think tank” is the public policy research arm of the United States)

http://www.loc.gov/crsinfo/

Congressional Budget Office (Provides economic data to the U.S. Congress)

http://www.cbo.gov/

Government Accountability Office (the audit, evaluation and investigative arm of the U.S. Congress)

http://www.gao.gov/

The British Psychological Society

http://www.bps.org.uk/publications/journals

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)
http://www.nap.edu/

SEARCH AND RESCUE(TOP)

Civil Air Search and Rescue Association
http://www.casara.ca/

Canadian Beacon Registry
https://www.cbr-rcb.ca/cbr/presentation/other_autre/index.php?lang=en

Canadian Owners and Pilots Association
http://www.copanational.org/

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
http://www.nss-snrs.gc.ca/sites/NSS_Internet/quadrennial-review/quadrennialsarreview-report.page#qsr-es

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

SearchSystems.net
http://www.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)
http://www.international.gc.ca/controls-controles/report-rapports/military_report-2007_09_toc-rapport_militaire.aspx?lang=eng&view=d
http://www.international.gc.ca/controls-controles/report-rapports/military-report06-2-rapport-militaire06-2.aspx?view=d
http://www.dfait-maeci.gc.ca/controls-controles/assets/pdfs/military/documents/Military_Report2007-en.pdf

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/advancedsearchresult-eng.action?n=&b=&q=&s=+&d=&e=+&c=&v=+&o=&z=&g=+&t=+&y=+&p=1
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 )
https://ocl-cal.gc.ca/app/secure/orl/lrrs/do/_ls63_ls6f_ls6d_ls6d_ls4c_ls6f_ls67_ls50_ls75_ls62_ls6c_ls69_ls63_ls53_ls65_ls61_ls72_ls63_ls68?_STRTG3=tr

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://www.tc.gc.ca/roadsafety/recalls/search_e.asp

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)
http://search.pslrb.gc.ca/search?q=logan&lr=&site=ft&output=xml_no_dtd&oe=UTF-8&hl=fr&ie=UTF-8&filter=0&proxyreload=1&getfields=description&client=de&proxystylesheet=de

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

http://searchenginewatch.com/

DegreeTutor

http://www.degreetutor.com/library/research-tools/librarian-searchguide

Lycos

http://www.lycos.com/info/search-engines-list.html

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

http://www.cmda.ca/

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)

http://www.mfa.gouv.qc.ca/

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

http://www.medicare.gov

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)

http://www.seniorbrigade.com/

SOCIAL MEDIA(TOP)

HerdictWeb (A Harvard University project chronicling potential censorship of the Web around the world)

http://www.herdict.org/web/

Renesys (Internet monitoring firm)

http://www.renesys.com/

Dipity

http://www.dipity.com/

Storify

http://storify.com/

Storyful

http://storyful.com/

ComScore

http://www.comscore.com/

PoliTwitter (Track what federal politicians are saying on social media)

http://politwitter.ca/

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
https://gigaom.com/2014/10/03/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)

 

How journalists can use Excel to organize data for stories (The Poynter Institute)

http://www.poynter.org/how-tos/digital-strategies/154584/how-journalists-can-use-excel-to-organize-data-for-stories/

Making a chart

Basics about math

Microsoft Support

http://support.microsoft.com/

Spreadsheet tutorial from CARinCanada

http://www.carincanada.ca/CARCANtips.htm

Reporters’ cookbook

http://forjournalists.com/cookbook/index.php?title=Main_Page

Technology training for journalists

http://canyonwolfephoto.com/

ExcelTips!

http://exceltips.vitalnews.com/

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/

Math for Journalists

http://www.newsu.org/courses/course_detail.aspx?id=nu_math05

InflationData.com

http://inflationdata.com/inflation/

Ozgrid.com

http://www.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)

http://nilesonline.com/stats/

Spreadsheet tutorial

http://www.j-walk.com/ss/

Introduction to spreadsheets

http://www.cmu.edu/computing/education/excel/Excel2003/index.htm

Daily Dose of Excel

http://dailydoseofexcel.com

Jon Peltier’s Excel Page

http://peltiertech.com/Excel

Pearson Software Consulting

http://www.cpearson.com/excel.htm

Stephen Bullen’s Excel Page

www.bmsltd.co.uk/excel.htm

David McRitchie’s Excel Pages

www.mvps.org/dmcritchie/excel/excel.htm

Mr. Excel

www.mrexcel.com/

About.com:Spreadsheets

http://spreadsheets.about.com

Microsoft.public.excel

http://groups.google.ca/group/microsoft.public.excel/topics?lnk=sg&hl=en

The City of Ottawa budget in Excel format

Ottawa Budget

STORIES ABOUT ACCESS TO INFORMATION(TOP)

 

The Calgary Herald (editorial)

How to lead a more transparent government

STORIES ABOUT INVESTIGATIVE JOURNALISM(TOP)

 

What 2011 holds for investigative reporting (The Poynter Institute)

http://www.poynter.org/latest-news/als-morning-meeting/112043/what-2011-holds-for-investigative-reporting-imagine-a-julian-assange-in-every-state-and-major-city-in-the-us/#

The best journalism-job want ad ever ever (Mother Jones)

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/

TRADE(TOP)

Canadian Import and Export Stats (Industry Canada)
http://strategis.ic.gc.ca/sc_mrkti/tdst/tdo/tdo.php#tag

Report on Exports of Military Goods from Canada
http://www.international.gc.ca/controls-controles/report-rapports/mil-2010-2011.aspx?lang=eng

U.S. International Trade Statistics
http://www.census.gov/foreign-trade/index.html

TRADE PUBLICATIONS(TOP)

Drug Rep Chronicle
http://www.drugrep.tk/

AGCanada
http://www.agcanada.com/daily/

The Western Producer
http://www.producer.com/

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)
http://renewcanada.net/

Oilprice.com
http://oilprice.com/

Engineering and Technology Magazine
http://eandt.theiet.org/

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

Planesregister.com
http://www.planesregister.com

Transport Canada: Bird Strike Summary Reports
http://www.tc.gc.ca/eng/civilaviation/standards/aerodromeairnav-standards-wildlifecontrol-summaries-menu-98.htm

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
http://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)
http://www.tc.gc.ca/wsdrs/

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

The Canadian Civil aircraft register (general page that includes option to download the register database)
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)
http://www.atac.ca/

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
http://www.tsb.gc.ca/eng/

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
http://www.ctrf.ca/index.html

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://www.parl.gc.ca/LEGISINFO/index.asp?Language=E&Chamber=N&StartList=A&EndList=Z&Session=14&Type=0&Scope=I&query=4675&List=stat
http://cmte.parl.gc.ca/cmte/CommitteeWitnesses.aspx?Lang=1&PARLSES=391&JNT=0&SELID=e23_&COM=10462

Transport 2000
http://www.transport2000.ca/

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
http://www.flightglobal.com

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)
http://www.faa.gov/

FAA airworthiness directives
http://www.airweb.faa.gov/Regulatory_and_Guidance_Library/rgAD.nsf/MainFrame?OpenFrameSet&CFID=5636626&CFTOKEN=65167113

U.S. aircraft register
http://www.faa.gov/aircraft/air_cert/aircraft_registry/

U.S. Department of Transportation
http://www.dot.gov/

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.)
http://www.landings.com/

The UK Civil Aviation Authority
http://www.caa.co.uk/

Aviation Safety Network
http://aviation-safety.net/index.php

The International Air Transport Association (IATA)
http://www.iata.org/index.htm

International Civil Aviation Organization (ICAO)
http://www.icao.int/

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
http://flightaware.com/

Floweb.com
http://fboweb.com/

FareCompare.com
http://www.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)
http://www.saaq.gouv.qc.ca/

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
http://ottawa.ca/residents/onthemove/driving/road_safety/integrated/annual_reports/report_2003_en.html
http://ottawa.ca/residents/onthemove/driving/road_safety/integrated/annual_reports/report_2004_en.html
http://ottawa.ca/residents/onthemove/driving/road_safety/integrated/annual_reports/report_2005_en.html
http://ottawa.ca/residents/onthemove/driving/road_safety/integrated/annual_reports/report_2006_en.html
http://ottawa.ca/residents/onthemove/driving/road_safety/integrated/annual_reports/report_2007_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
http://www.whitehouse.gov/

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
http://harvester.census.gov/

Data.gov (datasets from top U.S. executive departments)
http://www.data.gov/

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/

U.S. Business (TOP)

 

National Bureau of Economic Research
http://www.nber.org

Business Wire (U.S.)
http://www.businesswire.com/

EDGAR (U.S.)
http://www.sec.gov/cgi-bin/srch-edgar

SEC Filing Alerts
http://secfilings.com/

Morningstar Document Research (formerly 10-K Wizard)
http://www.10kwizard.com/

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
http://www.nyse.com

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)
http://equilar.com/

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
http://www.dnb.com/us/

Hoover’s Online
http://www.hoovers.com/free/

Financial Directory
http://investorlinks.com/

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
http://www.facsnet.org

The McKinsey Quarterly
http://mckinseyquarterly.com

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
http://www.nber.org/

Searchable database for bills in Congress
http://thomas.loc.gov/

U.S. Government Printing Office
http://www.access.gpo.gov

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
http://www.yourlawyer.com

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://workforceexplorer.com/
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
http://exportfocus.com/

U.S. COURT FILINGS AND LEGAL ACTION(TOP)

Pacer
http://pacer.psc.uscourts.gov

The Public Library of Law (U.S.)
http://www.plol.org/Pages/Search.aspx

Lexis
http://www.lexis.com/

United States Department of Justice
http://www.usdoj.gov/index.html

United States Bankruptcy Courts
http://www.uscourts.gov/bankruptcycourts.html

Banktruptcy Data.com
http://bankruptcydata.com/

CLB Media Inc. (A publisher of many trade magazines and other media services)
http://www.clbmedia.ca/

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

IRB decisions database

Public Records

FOI.ppt

Computer-Assissted Reporting

Parole Board of Canada

Arms Sales to the Middle East

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

WEBSITES WITH TABLES FOR DOWNLOAD(TOP)

Ontario’s Public Sector Salary Disclosure
http://www.fin.gov.on.ca/en/publications/salarydisclosure/2012/

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
http://healthycanadians.gc.ca/recall-alert-rappel-avis/index-eng.php?utm_campaign=CHS1213&utm_source=google_en&utm_content=ADV0096-12_sem-ad-1_en&utm_medium=cpc&utm_keyword=%2Bcanada%20%2Bhealth

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)
http://www.data-pass.org/

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://www.data.gc.ca/default.asp?lang=En&n=5175A6F0-1&xsl=datacataloguerecord&metaxsl=datacataloguerecord&formid=1EC92326-47EF-4110-B7CA-959FAB03F96D
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 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
http://www.electionsquebec.qc.ca/francais/provincial/financement-et-depenses-electorales/recherche-sur-les-donateurs.php#

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
https://ocl-cal.gc.ca/app/secure/orl/lrrs/do/_ls70_ls75_ls62_ls6c_ls69_ls63_ls53_ls65_ls61_ls72_ls63_ls68?_ls73_ls65_ls61_ls72_ls63_ls68_ls54_ls79_ls70_ls65=Search&_ls73_ls65_ls61_ls72_ls63_ls68_ls43_ls6f_ls6d_ls6d_ls61_ls6e_ls64=navigate&_ls74_ls6f_ls6b_ls65_ls6e=1223927200019&_ls64_ls6f_ls63_ls73_ls53_ls74_ls61_ls72_ls74=1&_STRTG3=tr

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

The FDA’s Adverse Drug Reaction Database
http://www.fda.gov/Drugs/GuidanceComplianceRegulatoryInformation/Surveillance/AdverseDrugEffects/ucm082193.htm

DataGov
http://www.data.gov/

Dirt Diggers Digest
http://dirtdiggersdigest.org/enforcement

Navigate the world 
of public data
http://enigma.io/

European database of suspected adverse drug reaction reports
http://www.adrreports.eu/

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)
http://www.hrsdc.gc.ca/eng/labour/labour_relations/info_analysis/wages/adjustments/2011/01/yearly.shtml

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)
http://www.occps.ca/

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.)
http://ops.dot.gov/rinfo.htm

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)
http://www.calgaryhealthregion.ca/publichealth/envhealth/inspection_orders/food_establishments.htm#2009

Datadot.gc.ca
http://datadotgc.ca/

DataBC
http://www.data.gov.bc.ca/

Transparency Tracker (Propublica)
http://projects.propublica.org/transparency/

National Data Catalogue ( the United States )
http://nationaldatacatalog.com/dashboard

The World Bank
http://data.worldbank.org/

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/government-data-world

WORKPLACE SAFETY(TOP)

Canadian Centre for Occupational Health and Safety
http://www.ccohs.ca/

Association of Workers’ Compensation Boards of Canada
http://www.awcbc.org/en/

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
http://www.ohscanada.com

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

WRITING(TOP)

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

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)