Course objectives1) Obtain a thorough grounding in journalistic research methods. 2) Acquire skills, such as computer-assisted or data-journalism reporting techniques, needed to make sense of the information gathered. 3) Develop the ability to shape the information into accurate and compelling stories. Course outline (TOP)Jan. 7: a. Course introduction b. Introduction to Access to Information || Reading: Digging Deeper, Chapters 1, 2, 3, 10, 11 and Appendix – Finance Facts Note: To find the rest of the appendices, please click here. Jan. 14: 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. 21: 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. 28: a. Business story due on Jan. 30 at midnight b. Access-to-information tips: focusing a request, negotiating, seeking partial releases b. One-on-ones: Whatever-happened-to story? / Research time c. Databases (part one) || Reading: Digging Deeper, Chapter 8 Feb. 4: a. Databases (part two) || Reading review: Digging Deeper, Chapter 11 and Appendix A Feb. 11: a. Business story feedback b. Databases (part three) c. Assignment: Database story Feb. 18: Reading Week. No class scheduled. Feb. 25: a. Whatever-happened-to? story due Feb. 26, 9 a.m. 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 March 4: a. Interviewing / Sources b. Public records c. Database story due by midnight March 6 || Reading: Digging Deeper, Chapter 12 March 11: a. Whatever-happened-to? story feedback b. Courts / Legal Affairs March 18: a. Access-to-information story due March 20, 11:59 p.m. b. Database story feedback c. Overlooked Access-to-information records March 25: a. Journalistic ethics: investigative quandaries b. Enterprise journalism tips April 1: 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 publicly traded company. 600 words, to be submitted by midnight Jan. 30. Assignment requirements 1) A 600-word story on a publicly traded company. 2) The story is to emerge from the financial statement(s). 3) Upload the story to the category on the WordPress site that you’ll be assigned. 4) At least one interview with an expert who can put the numbers in context. 5) An interview, emailed response, or public statement of a company representative discussing an aspect of the trend that you’ve discovered. 6) An annotated financial statement(s) uploaded to DocumentCloud that MUST be embedded into your story. 7) A visual depiction of the trend you’re writing about (chart, line graph, pie chart, etc.) that, too, must be embedded into your story. That charts MUST contain titles, and be properly sourced. To be submitted 1) A 500-word explanation in a Word document that explains how you got the story, the sources you used or attempted to contact and their coordinates (phone numbers, email address, twitter handle, LinkedIn page, etc.) 2) An Excel spreadsheet containing your calculations. 3) The assignment is to be uploaded to our WordPress site to the “category” which will be assigned. The story MUST also contain a comment from the company, be it an interview, emailed correspondence, statement in the financial statement, etc. Qs and As Q: Can it be any company? A: Yes. Q: Does it have to be the most recent financial statement? A: Yes. Q: Which financial statements should I be using? A: Stick with the ones discussed in the business chapter. Q: Should I create a Google Alert for my company? A: Yes! Q: Who should the expert be? A: It could be a business professor, for instance. So as soon as you choose your company, be sure to line up an interview. Q: What if no one from the company gets back to me? A: This is a distinct possibility. So brace yourself. Certainly, try to obtain the company’s comments on the record either through an interview or emailed response. Failing these two options, there are other ways to obtain the company’s point of view that are described in chapters four, seven and nine. For instance, what has the company said in the Management Discussion and Analysis section of the financial statement, in a news release, or an interview, an appearance before a Parliamentary committee, a court document, etc.? Q: What multi-media elements should the story contain? A: A chart that illustrates the trend you’ve discovered. It could be a simple bar chart that compares profits for two quarters, or any other newsworthy aspect from the financial statement. It could be a chart or line graph showing the company’s stock prices, using the TradingView website, as demonstrated in the tutorial. You should also have a picture of the company or person in your story. If it’s a business prof, the piece should have a picture that is properly sourced. Q: How do I illustrate the financial statement? A: It MUST be uploaded to DocumentCloud and annotated, which means that each annotation contains your analysis of the significance of the numbers, why they matter and why they are in your story. Q: Must the story contain hyperlinks? A: An emphatic YES!!!! The idea is to hunt for the original records described in chapter four. For instance, if you cite a quotation from the financial statement, then there must be a hyperlink to the statement in DocumentCloud, or you can embed the entire document, which is preferable. DO NOT LINK to media reports, as they are secondary sources that could contain factual errors. Always use original documents to check numbers, and then show people where you got them. So be sure to link to primary documents and data sets. For instance, if you refer to a speech an executive delivered, hyperlink to the speech, or better yet, uploaded it to DocumentCloud and annotate the section in question. Get used to hunting for primary records. The hyperlinks also allow the reader to delve into the weeds, which then allows you to stick to a tight narrative. Q: How many numbers should I use? A: Please keep it simple!! TELL A STORY. Just take one or two numbers and write about them. Take what the financial statement(s) gives you. Q: Can I use the financial statement to confirm a story idea I already have? A: No. The idea is to analyze the financial statement, and then let the story emerge from the analysis. (Note: this is true for all the assignments. That is, the story should originate from the record you’re studying.) The story could be as simple as profits are up compared to the same quarter from the previous year; or the cost of sales has increased significantly; or the company may be making money, but only by selling property or parts of its business. So, to repeat, avoid going into the story with a pre-conceived idea. Let the story emerge from the financial statement. The business chapter should give you some ideas. If not, I’m happy to brainstorm. Q: When is the story due: A: Friday, Jan. 30, at midnight 2) Whatever-happened-to? story A piece that updates the reader on a memorable person or event from 1990. 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, due 9 a.m. Feb. 26. 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? Qs and As 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? category 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 1990? If so, something’s wrong. (*) Tell a story. 3) Database story A news story based on information gleaned from the database you either build in class or download from a government (federal, provincial, municipal) open-data site. 600 words, to be submitted before the March 6 before midnight. 3) Database assignment A news story based on a trend or a pattern derived from a database. Assignment requirements 1) A 600-word story 2) The story MUST come from the database 3) Upload the story to the category on the WordPress category, “Database_Assignment”. 4) AT LEAST ONE interview with an expert who can put the trend into context, and AT LEAST ONE interview with a person who is affected by the trend you’ve identified. Both interviews must be in person or over the phone – not emailed responses. 5) Supporting primary documents uploaded to DocumentCloud and annotated. The documents or annotated links MUST be embedded in your story. 6) A visual depiction of the trend that you’re writing about, (heat map, map, chart, ling graph, pie chart, etc.) that MUST be embedded in your story and properly titled and sourced. A screen grab does not count. 7) The story is due at midnight, March 6 To be submitted 1) A 500-word explanation in a Word document that explains how you go the story, the sources you contacted or attempted to contact, and their coordinates ( phone number, email address, twitter handle, LinkedIn page, etc.), and a list links to the primary sources ( reports, audits, studies ) that you used. Please keep the explanation tight. Avoid detailed discussions of the problems you encountered. Problems and obstacles are a given. 2) An Excel workbook containing your calculations. If you’re using tables from different data sets, please combine them into ONE Excel workbook with properly labelled worksheets. 3) The story must be uploaded to our WordPress site to the “category” which will be assigned. 4) So, to recap, each emailed assignment will contain the following elements: 1) A URL to the WordPress story; 2) ONE Excel attachment; 3) a Word document containing your background information. Qs and As Q: Can I choose any database? A: Yes Q: Where can I find data sets? A: Governments at all levels have open-data sites. And many of them get better every week. You’ll find a listing under our syllabus’ OPEN DATA GOVERNMENT WEBSITES section. We’re already using the city of Ottawa’s open-data site. Toronto has an excellent one, too. I would suggest municipal datasets, in large part because it may be easier to get interviews with city officials, local politicians and residents or citizens groups who are affected by the trend you’ve identified. That being said, the federal government has excellent data sets, everything from recalled vehicles to disclosures of grants and contributions to groups that may surprise you. To make finding a data set as easy as possible, filter the search engine for databases in csv format, and then by subject. Q: Do I need to have my data set approved? A: No. But please feel to solicit my feedback. Q: Does the data set have to be on one of the lists that you’ve suggested? A: No. For instance, there are many data sets, such as the Treasury Boards contaminated sites, that do not appear on the federal open data website. Similarly, Ottawa crime data statistics can be pulled out of PDFs on the Police Services’ website, but you won’t find them on the city of Ottawa’s open data portal. I’ve simply provided guidance to make finding data as easy as possible. Q: What kinds of considerations come into play when thinking about what data set to use? A: The topic should be newsworthy. And there has to be enough data that allows you to sort, filter, create pivot tables, or map geographic coordinates; in essence, use the skills we‘ve learned thus far. If in doubt, please let me know. Q: How many numbers should I be using? A: Apply the philosophy we used for the business assignment: The fewer numbers, the better. The number(s) is simply a springboard to a story. Q: How soon should I choose the data set? A: The sooner you can select your data set and perform the analysis, the quicker you can begin booking interviews, which, as you’ve discovered, can be time-consuming, especially in trying to get the best possible voices. Q: Speaking of interviews, does an emailed response count? A: No. But feel free to use an emailed response if it helps advance the story or answer a key question. It just won’t count as one of the two interviews. Q: What kinds of visualizations should I use? A: The same as the business assignment, with one important addition, a Fusion Table. Q: So does that mean that I have to use a Fusion Table? A: No. If you choose a data set that doesn’t have geographic coordinates or can’t be linked to a boundary file, then mapping is impossible. That means that if you want to map your trend, choose a data set with geographic coordinates such as longitudes and latitudes, postal codes or street addresses. Q: Can I submit a draft? A: Yes. Q: How close to the deadline can I submit a draft? A: 48 hours. Q: If I don’t have time to submit a full draft, how about a lead and an outline in point-form? A: Yes. Q: Will I lose marks for shoddy proofreading, ignoring CP style or poor grammar? A: Yes!! Q: What’s the key idea to keep in mind when doing this assignment? A: Tell a simple story!!!!! Good luck!! 4) Access-to-information story A news story based on documents obtained through access-to-information/freedom- Checklist: a. Copies of at least one request to EACH of the three levels of government (municipal, provincial, federal). b. Copies of three requests for previously released records from any level of government. c. Copies of correspondence received/sent by you during the course of each of the six requests. d. Copies of at least two – but not more than 10 – 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? Qs and As Q: How do I hand in my assignment? A: Upload everything – including documents, photos and answers to the three questions – to the relevant “category” of the syllabus. It doesn’t matter what format you choose, but most supporting material should be in PDF, .jpeg or Word format. You can also use DocumentCloud to upload pages of your records to the syllabus. DO NOT email components to Jim. Q: How should I select which pages to hand in? A: Choose records that contain passages you quoted or information that underpinned your story. You can hand in more than two pages, but no more than 10 pages. Please try to highlight relevant passages and do not hand in entire documents or huge volumes of material. Q: Do you want to see all the original access requests I did? A: No, just one from each of the three levels of government. Q: Do you want every piece of correspondence related to the six requests (original and previously released)? A: I want to see all relevant correspondence 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: Do I have to use the 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?’ 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: Must I include hyperlinks? A: A few, well-chosen hyperlinks in the story are welcome. A shopping list of key records(TOP) 20 records you can get using the federal Access to Information Act1. RECORD: Ministerial briefing notes. DEPARTMENT: All departments. ASK FOR: All briefing notes prepared specifically to help the new minister become acquainted with his/her new portfolio. HINT: Make this request a week or two after a new cabinet is named. RESULT: Yields wide range of information about a department’s plans/activities. 2. RECORD: Expense claims. DEPARTMENT: All departments/agencies. ASK FOR: Receipts, invoices and guest lists detailing travel and hospitality expenses claimed by a deputy minister or other senior bureaucrat that are more detailed than the ones you’ll find in the information federal institutions are obliged to file on line. HINT: Limit request to no more than one year’s worth of claims.RESULT: Can reveal spending habits and establish dates of key meetings, dealings. Remember former federal heritage minister Bev Oda’s $16-dollar glass of orange juice! 3. RECORD: Correspondence. DEPARTMENT: All departments/agencies. ASK FOR: Correspondence with a minister or agency head on a topic of interest. HINT: Frame request narrowly. For instance, exclude letters from the public if you do not require them. RESULT: Can uncover letters from provincial premiers, lobby groups. 4. RECORD: House cards. DEPARTMENT: All departments. ASK FOR: All cards prepared for the minister in the House of Commons on a specific issue. HINT: Watch headlines, Commons debates for ideas. RESULT: Often contain much more detail, background than revealed in Question Period. 5. RECORD: Material on possible legislation. DEPARTMENT: All departments. ASK FOR: Records concerning possible legislation or other initiatives on a given issue. HINT: Limit request to cover the last year to ensure currency of material. RESULT: Provides insight into initiatives that might be in pipeline, and reasons why the initiatives might (or might not) proceed. 6. RECORD: Meeting minutes. DEPARTMENT: All departments/agencies. ASK FOR: Minutes from the two most recent meetings of a specific committee. HINT: Make calls to find out meeting schedules and whether minutes are kept. RESULT: Can aid in understanding internal policy debates and decisions. 7. RECORD: Audits. DEPARTMENT: All departments, most agencies. ASK FOR: Audits and evaluations completed by or for the department/agency on specific subjects in the last year. HINT: Ask department informally for list of audits conducted in the last year. RESULT: Audits often reveal shortcomings in programs, policies. 8. RECORD: Polls. DEPARTMENT: All departments, but especially Privy Council Office. ASK FOR: Polls conducted for the department on a given subject. HINT: Some (but not all) polls are released informally. RESULT: Can reveal public attitudes towards government policies. 9. RECORD: Contract information. DEPARTMENT: All departments. ASK FOR: A copy of the contract for a specific project. HINT: Public Works and Government Services administers many contracts. RESULT: Reveals details of financial arrangements with private companies. 10. RECORD: Responses to discussion papers. DEPARTMENT: Any department that publishes consultation/discussion paper. ASK FOR:Copies of all submissions in response to the department’s paper. HINT: Put in request just after cut-off date for submissions. Only narrow request if certain submissions are required. RESULT: Reveals views of wide cross-section of groups on pressing issues. 11. RECORD: Contracted studies. DEPARTMENT: Privy Council Office. ASK FOR: Specific studies, research conducted for PCO. HINT: Ask informally for list of studies, which is updated regularly. RESULT: Yields advice prepared for government on unity, security, parliamentary affairs and other key issues. 12. RECORD: 20-year-old cabinet documents. DEPARTMENT: Privy Council Office. ASK FOR: Cabinet records on a specific issue. HINT:Check almanac for noteworthy past events. RESULT: Meeting minutes reveal thinking of ministers on issues. (Cabinet documents routinely become public only after 30 years). 13. RECORD: Prime Minister’s email. DEPARTMENT: Privy Council Office. ASK FOR: E-mail sent to the Prime Minister by visitors to his website. HINT: Limit request to a one-week period. RESULT: Names of correspondents are deleted, but letters yield an interesting mix of feedback, including light-hearted, angry and thoughtful correspondence. 14. RECORD: Criminal intelligence briefs. AGENCY: RCMP. ASK FOR: Criminal intelligence briefs prepared during the last six months. HINT:Make time-frame the last couple of years if you are seeking a brief on a specific subject. RESULT: Briefs cover issues such as aboriginal militancy, drug trade and smuggling. 15. RECORD: Incident reports. AGENCY: RCMP. ASK FOR: Incident report on a specific event. HINT: Broaden request to include other records if incident is a prolonged one, such as a standoff. RESULT: Can help explain police decision-making. 16. RECORD: Lessons learned. DEPARTMENT: National Defence. ASK FOR: “Lessons learned” from major military missions. HINT: Wait a month or two after mission is complete. RESULT: Provides evaluation of peacekeeping tours and other assignments. 17. RECORD: UFO reports. DEPARTMENT: Transport. ASK FOR: Reports of unidentified flying objects filed by the public. HINT: UFO reports are also often filed with Defence and RCMP. RESULT: Names of people who make reports are deleted, but other details can be released. 18. RECORD: Observer reports. DEPARTMENT: Fisheries. ASK FOR: Observer reports prepared for the department. HINTS: Limit request to specific geographic area and time frame. RESULTS: Can provide details about operations of foreign vessels. 19. RECORD: SIRC reports. AGENCY: Security Intelligence Review Committee. ASK FOR: Specific reports prepared by committee on CSIS activities. HINT: Reports are listed in back of committee’s annual report. RESULT: Reports, though heavily edited, provide check on spy agency CSIS. 20. RECORD: CRTC debriefing notes. AGENCY: Canadian Radio-television and Telecommunications Commission. ASK FOR: Debriefing notes prepared in connection with a specific licensing hearing. HINT: Make request shortly after licence decision is made. RESULT: Can provide behind-the-scenes reasoning on why TV, radio licences are granted or denied. Ten ways to improve your searches(TOP)1. Look to the headlines for ideas. 2. Check the relevant federal websites for forms, contacts, info on departmental holdings. 3. Call the access co-ordinator before making your request. 4. Call the co-ordinator after submitting your request. 5. Make similar requests to more than one agency or government. 6. Keep a photocopy or scan of each request and attach all return correspondence. 7. Negotiate with agencies. 8. Be persistent. If necessary, complain. 9. Read the records you receive carefully. 10. Don’t get discouraged. |
Biographies(TOP)
Jim Bronskill is a reporter in the Ottawa bureau of The Canadian Press news agency, specializing in security and intelligence, the RCMP and justice-related issues. He has considerable experience using access-to-information laws to uncover stories. Before joining CP in November 2003, Jim was a reporter with Southam News (which became CanWest News Service). He previously held various positions at CP and has also worked for the Ottawa Citizen, the Owen Sound Sun Times and TVOntario. Jim holds a master’s degree in journalism from Carleton University. He and colleague Sue Bailey were National Newspaper Award finalists for investigative stories on Taser stun guns. In 2002, Jim received two Canadian Association of Journalists awards, including one for best overall investigative report, for a series he co-wrote with David Pugliese of the Citizen about the crackdown by security agencies on public dissent. He and Bailey won the national Justicia Award for a series on how the justice system often fails the mentally ill. Jim was part of a team that collaborated with the CBC/Radio-Canada to earn the 2008 Michener Award for their series on Taser use by the RCMP.
Jim has contributed to a textbook on Canada’s Access to Information Act entitled Brokering Access. And he has co-authored an access-to-information research guide with David McKie called Your Right to Know, copies of which available on-line at Indigo Books or Self-Counsel Press, the publisher.
David McKie is an Ottawa-based, award-winning author and producer who works out of the CBC News Parliamentary bureau. To get an idea of some of the stories he has researched, written and broadcast, please go to the following links: A Matter of Trust, Faint Warning (for which he was nominated for a Michener Award in 2003), Prescribed to Death , Dying for a Job and Out of Synch, Beaten Down: Fear and Violence in Canada’s Nursing Homes and Off-Limits.
For a story in the series,A Matter of Trust, on a botched clinical trial and its effect on two families, David and the late CBC documentary maker, Bob Carty, won the 2003 Science in Society Journalism Award in the radio category. Faint Warning was a finalist for the 2004 Michener award, winner of the 2004 RTNDA award for best investigative report, and winner the Canadian Association of Journalists’ 2004 computer-assisted reporting (CAR) award and the overall CAJ award for best investigative series.
Faint Warning won the Service Journalism category for the 2004 Online News Association. The follow-up series, Prescribed to Death, that ran in 2005 was also a big award winner. The series won the CAJ’s 2006 CAR award, the Open Radio News Award and, for the second year in a row, the overall award. The series also won the 2006 CNA ( Canadian Nurses Association ) & CMA ( Canadian Medical Association ) Media Awards for Excellence in Health Reporting and the American-based IRE (Investigative Reporters and Editors) award in the radio category.
Dying for a Job won the 2007 Excellence in Health Reporting from the Canadian Medical Association and the Canadian Nurses’ Association. For the Taser series, David and Jim Bronskill were part of the large team that earned the 2008 Michener Award.
David edits a magazine for the Canadian Association of Journalists called Media, which you can find at: Media magazine. He was also one of four journalists/journalism instructors who wrote Digging Deeper, a Canadian textbook on investigative research techniques that’s now in its third edition. And has helped write a second textbook, Computer-Assisted Reporting: A Comprehensive Primer, contributed to a textbook on Canada’s Access to Information Act entitled Brokering Access.
And he has co-authored an access-to-information research guide with Jim Bronskill called Your Right to Know, copies of which available on-line at Indigo Books or Self-Counsel Press, the publisher.
ACCESS-TO-INFORMATION(TOP)
CANADA
Access to Information Act
http://laws-lois.justice.gc.ca/eng/acts/A-1/
Privacy Act
http://laws-lois.justice.gc.ca/eng/acts/P-21/
Federal Departments and Agencies
http://canada.ca/en/gov/dept/index.html
Info Source (directory of holdings)
http://www.infosource.gc.ca/emp/emp05-eng.asp
Open Data Portal
Search Summaries of Completed ATI Requests
http://data.gc.ca/eng/search/ati?
David McKie’s CAIRs page
Access to Information and Privacy Coordinators
http://www.tbs-sct.gc.ca/atip-aiprp/apps/coords/index-eng.asp
Access to Information request forms
http://www.tbs-sct.gc.ca/tbsf-fsct/350-57_e.asp
Access to Information fillable request form
Specific Exemptions under the Access to Information Act (Treasury Board of Canada Secretariat)
http://www.tbs-sct.gc.ca/pol/doc-eng.aspx?section=text&id=13784
Office of the Information Commissioner
Office of the Privacy Commissioner
PROVINCES AND TERRITORIES
Alberta
http://foip.alberta.ca/pbdirectory/index.cfm
British Columbia
http://www.gov.bc.ca/citz/iao/foi/
HYPERLINK “http://www.gov.bc.ca/citz/iao/foi/contacts/index.html” http://www.gov.bc.ca/citz/iao/foi/contacts/index.html
HYPERLINK “http://www.oipc.bc.ca/” 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/disclosure.html
Manitoba (Access to information requests — weekly listing)
http://www.gov.mb.ca/chc/fippa/disclosure.html
New Brunswick
Main:http://www2.gnb.ca/content/gnb/en/services/services_renderer.200949.html
Law: http://www.gnb.ca/acts/acts/r-10-3.htm
Newfoundland and Labrador
http://www.justice.gov.nl.ca/just/info/index.html
Northwest Territories
http://www.justice.gov.nt.ca/ATIPP/index.shtml
Nova Scotia
Main: http://www.foipop.ns.ca/
List of departments: http://foipop.ns.ca/PB_Contact
Review: http://www.foipop.ns.ca/
The Right to Know Coalition of Nova Scotia
Nunavut
http://www.gov.nu.ca/access-information-and-protection-privacy-atipp
Ontario
Main: http://www.accessandprivacy.gov.on.ca/english/doi/index.html
Forms: http://www.accessandprivacy.gov.on.ca/english/download/index.html
FAQ: http://www.cfipo.gov.on.ca/mbs/dor/dirrec.nsf/webpages/FAQ
Information and Privacy Commissioner decisions and resolutions
Prince Edward Island
http://www.gov.pe.ca/jps/FOIPPfaqs
HYPERLINK “http://www.gov.pe.ca/forms/pdf/641.pdf” http://www.gov.pe.ca/forms/pdf/641.pdf
http://www.gov.pe.ca/jps/index.php3?number=1024337&lang=E
Quebec
http://www.cai.gouv.qc.ca/index-en.html
Quebec access-to-information coordinators
http://www.cai.gouv.qc.ca/documents/CAI_liste_resp_acces_eng.pdf
Saskatchewan
http://www.justice.gov.sk.ca/Contacts-by-Institutio
Yukon
CITIES
Calgary
Edmonton
http://www.edmonton.ca/city_government/city_organization/freedom-of-information-and-privacy.aspx
Fredericton
http://www.fredericton.ca/en/citygovernment/rtipp2013.asp
Ottawa
http://ottawa.ca/en/city-hall/your-city-government/access-information-and-privacy
Halifax Regional Municipality
http://www.halifax.ca/AccessPrivacy/index.php
Hamilton
http://www.hamilton.ca/CityDepartments/CorporateServices/Clerks/MFIPPA_adn_PHIPA.htm
Moncton
http://www.moncton.ca/Government/Right_to_Information_and_Protection_of_Privacy_Act__RTIPPA_.htm
Montreal
http://ville.montreal.qc.ca/portal/page?_pageid=5798,39687582&_dad=portal&_schema=PORTAL
Regina
Saskatoon
http://www.saskatoon.ca/DEPARTMENTS/City%20Clerks%20Office/Pages/FreedomofInformation.aspx
Toronto
http://www.toronto.ca/cap/form_foi.htm
Waterloo
http://www.waterloo.ca/en/government/freedomofinformation.asp
Winnipeg
http://winnipeg.ca/clerks/fippa/fippa.stm
Vancouver
http://vancouver.ca/ctyclerk/foi/index.htm
INTERNATIONAL
governmentattic.org (U.S.)
http://www.governmentattic.org/
The FOI Advocate (U.S. news of developments in the area of freedom of information)
http://foiadvocate.blogspot.com/
The Freedom of Information Act ( The U.S. Department of Justice)
FOIS Update (1996)
FOIOnline (FOI requests and previously released records for selected agencies)
Historically Significant FBI Files
National Freedom of Information Coalition: Protecting Your Right to Open Government (U.S.)
The National Archives and Records Administration
Open Government: a journal on freedom of information
http://www.opengovjournal.org/index
Overview of FOIA Countries Worldwide – February 1 2006
http://www.statewatch.org/news/2006/feb/foia-feb-2006.pdf
Reporters Committee for the Freedom of the Press (U.S. FOI requests)
http://www.rcfp.org/foiact/index.html
The Sunshine Government Initiative (a coalition of U.S. media groups that advocates opening up access to government records)
http://www.sunshineingovernment.org/
U.S. FOI requests for electronic data by state
http://www.rcfp.org/elecaccess/
U.S. Coalition of Journalists for Open Government
U.S. Food and Drug Administration: Electronic Reading Room
http://www.fda.gov/foi/electrr.htm
U.K. FOI requests
http://www.whatdotheyknow.com/
http://www.whatdotheyknow.com/list/successful
The World Bank
The World’s First Freedom of Information Act | Right To Information
https://rtieng.wordpress.com/2011/07/29/the-worlds-first-freedom-of-information-act/
FURTHER READING
Access Info
All About Information http://allaboutinformation.ca
Digging deeper: A Canadian reporter’s research guide, 3rd Edition
http://www.oupcanada.com/higher_education/companion/comm_studies/9780199008490.html
Freedominfo.org
Right2Info
Your Right to Know: How to Use the Law to Get Government Secrets
http://www.self-counsel.com/your-right-to-know.html
ACCESS TO INFORMATION_POLICE(Top)
Calgary Police Service
http://www.calgarypolice.ca/privacyPop.html
Canadian Newspaper Association freedom-of-information audit of police forces (CBC story)
http://www.cbc.ca/canada/story/2009/01/09/access-to-information.html?ref=rss
Durham Regional Police Service
Edmonton Police Service
http://www.edmontonpolice.ca/AboutEPS/HowToRequestInformation.aspx
Fredericton Police Force
http://www.fredericton.ca/en/publicsafety/ContactPoliceMain.asp
Halifax Regional Municipality
http://www.halifax.ca/irm/pdf/form1.pdf
Halton Regional Police
http://www.hrps.on.ca/RecordsCourts/FOI/Pages/default.aspx
Hamilton Police Services
http://www.hamiltonpolice.on.ca/HPS/Services/Records/PoliceOccurrenceReports.htm
London Police Service
http://www.police.london.ca/d.aspx?s=/Services/FOI/default.htm
Niagara Regional Police
http://www.nrps.com/foi/default.asp
Peel Regional Police
http://www.peelpolice.on.ca/Police%20Records/Freedom%20Of%20Information%20Requests.aspx
Regina Police Service
http://www.reginapolice.ca/contact.htm
Vancouver Police Department
http://vancouver.ca/police/organization/support-services/information-privacy.html
Vancouver Police Department (Published Freedom of Information requests)
http://vancouver.ca/police/organization/public-affairs/freedom-of-information.html
Waterloo Regional Police Service
http://www.wrps.on.ca/job/access-information-analyst
York Region Police
http://www.police.york.on.ca/foi.aspx
ACCESS TO INFORMATION STORIES IN THE NEWS(TOP)
The 2011 National Freedom of Information Audit (The Canadian Newspaper Association and The Canadian Community Newspapers Association)
http://www.newspaperscanada.ca/public-affairs/FOI2011
Access to Information Act Failure: Watchdog Suzanne Legault Finds Big Problems With Delays, Denials (Huffington Post Canada)
http://www.huffingtonpost.ca/2011/06/17/access-to-information-act_n_878865.html
Access to information denied: Interview with Dean Beeby
Alberta releases first ‘Sunshine list’ of government salaries (CBC News)
Another Blow to Access to Information: Supreme Court of Canada Denies Access to Political Documents in Ministers’ Offices (Inforrm’s Blog: The International Forum for Responsible Media Blog)
Budget cuts undermine federal access-to-information system: watchdog (The Canadian Press)
Canada (Information Commissioner) v. Canada (Minister of National Defence): Democratic Governance, Transparency and Accountability or Exective Priviledge?
BC Ferries to alter controversial policy on FOI disclosure
CBC document dispute continues at Access committee: Kady O’Malley liveblogs the House of Commons Access to Information committee hearings on the CBC (CBC News)
http://www.cbc.ca/news/politics/story/2011/11/01/pol-kady-stub.html
CBC head defends broadcaster on access to info (CBC News)
http://www.cbc.ca/news/canada/ottawa/story/2011/11/24/pol-cbc-ethics-committee-lacroix.html
CBC must hand over files to information watchdog (CBC News)
http://www.cbc.ca/news/canada/story/2011/11/23/pol-cbc-information-commissioner-appeal.html
CBC still refusing to release info (Toronto Sun)
http://www.torontosun.com/2011/08/19/cbc-still-refusing-to-release-info
CBC one in long list of federal agencies to go up against info czar in court (The Canadian Press)
Canada mediocre in access to information rankings (The Toronto Star)
http://www.thestar.com/news/canada/article/1062154–canada-mediocre-in-access-to-information-rankings
Bid to see Champlain Bridge report denied: Gazette to appeal federal body’s ruling (The Gazette)
Canada to probe alleged ‘muzzling’ of government scientists (The Japan Times)
Chilly White North? Canadian government secrecy on the rise (The Christian Science Monitor)
CommitteeWatch: Hey, remember formerly alleged Access to Information interferent Sebastien Togneri? (CBCnews_Inside Politics Blog)
Conflicting answers on whether complete Mercier Bridge reports will be released (The Gazette)
Court rejects CBC appeal in access-to-information feud (The Canadian Press)
CBC’s David McKie on investigative reporting: Your Community Blog
http://www.cbc.ca/news/yourcommunity/2012/04/cbcs-david-mckie-on-investigative-reporting.html
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)
From the bench, a boost for government secrecy (The Globe and Mail)
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)
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)
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)
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.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)
The Gazette’s View: Inspection reports: the stonewalling must stop
Roadblocks
Five ways Ottawa stymies Access to Information requests (The Globe and Mail)
SCC Establishes Scope of Access to Information Act (A legal blog about the law of information)
http://allaboutinformation.ca/2011/05/15/scc-establishes-scope-of-access-to-information-act/
SCOC says no: ministerial agendas off-limits (CBC News)
Stephen Harper could relax now, but will he? (The Globe and Mail)
Tasha Kheiriddin: Supreme Court: PM entitled to a hidden agenda (National Post)
The push for Open Government – up to a point (CBC News)
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)
BLOGS[Top]
David McKie
http://www.cbc.ca/politics/insidepolitics/syndication/blog-author-david-mckie.xml
Glen McGregor (A few tasteful snaps: Mostly about Canadian data journalism and politics)
http://afewtastefulsnaps.wordpress.com/
Justin Piche (Tracking the Politics of ‘Crime’ and Punishment in Canada)
http://tpcp-canada.blogspot.com/
Fagstein (Maintained by Montreal Gazette copy editor Steve Faguy and self-described “twenty-something geek freelance journalist who lives in Montreal”)
The SPJ International Journalism Committee Blog
http://blogs.spjnetwork.org/ijc/
Now The Details
http://nowthedetails.blogspot.com/
The Senate Tackles B(5) FOIA Reform (the U.S.)
http://nsarchive.wordpress.com/2014/06/24/the-senate-tackles-b5-foia-reform/
BUSINESS ANALYSIS(TOP)
InvestD
Hoovers
http://www.hoovers.com/#megamenu_0.html
Summary table — Debt to equity ratio by industries (Statistics Canada)
http://www.statcan.gc.ca/pub/61-219-x/2010000/t007-eng.htm
Business Insider
http://www.businessinsider.com/
Financial glossary (Reuters)
http://glossary.reuters.com/index.php?title=Main_Page
Society of American Business Writers and Editors
http://sabew.org/resources/resources/
“Best Business Writing” anthologies compiled by Columbia University
For the most recent edition, click here
Worthwhile Canadian Initiative
http://worthwhile.typepad.com/
BUSINESS REPORTING (TOP)
Donald W. Reynolds National Center for Business Journalism
http://businessjournalism.org/
Beginners’ Guide to Financial Statements (U.S. Securities and Exchange Commission)
http://www.sec.gov/investor/pubs/begfinstmtguide.htm
CANADIAN BUSINESS (TOP)
Catalyst Canada, Inc.
Business Terminology
http://www.powerhomebiz.com/Glossary/glossary-A.htm
Business Dictionary
http://www.businessdictionary.com/
Canada NewsWire
http://www.newswire.ca/htmindex/etoday.html
CCN Matthews
http://www.ccnmatthews.com/news/releases/home.jsp
Campbell R. Harvey’s Hypertextual Finance Glossary
http://www.duke.edu/~charvey/Classes/wpg/glossary.htm
Corporations database online
https://www.ic.gc.ca/app/scr/cc/CorporationsCanada/fdrlCrpSrch.html?locale=en_CA
Google Finance
http://finance.google.com/finance
FPinfomart.ca (Canada’s largest provider of news & broadcast media monitoring, financial and corporate data)
MarketWatch
http://www.marketwatch.com/?link=MW_Nav_FP
Nasdaq
SEDAR (Canada)
http://www.sedar.com/search/search_en.htm
Securities commissions
British Columbia Securities Commission
Alberta Securities Commission
http://www.albertasecurities.com/Pages/Default.aspx
Manitoba Securities Commission
http://www.msc.gov.mb.ca/index_en.html
Ontario Securities Commission
http://www.osc.gov.on.ca/en/home.htm
http://www.osc.gov.on.ca/en/Proceedings_before-commission_index.htm
The Autorité des marchés financiers (AMF)
http://www.lautorite.qc.ca/index.en.html
Nova Scotia Securities Commission
The Securities Commission of Newfoundland and Labrador
http://www.gs.gov.nl.ca/cca/fsr/rulemaking/
CANADIAN BUSINESS STATISTICS(TOP)
Bankruptcy (Office of the Superintendent of Bankruptcy Canada)
http://strategis.ic.gc.ca/epic/internet/inbsf-osb.nsf/en/home
http://www.ic.gc.ca/eic/site/bsf-osb.nsf/eng/h_br01011.html
http://www.ic.gc.ca/eic/site/ica-lic.nsf/eng/h_lk00015.html
North American Industry Classification System (NAICS) 2007 (Statistics Canada)
http://www.statcan.gc.ca/subjects-sujets/standard-norme/naics-scian/2007/list-liste-eng.htm
Manpower Employment Outlook Survey
http://www.manpowergroup.com/wps/wcm/connect/manpowergroup-en/home/thought-leadership/meos/
Statistics Canada
http://www.statcan.gc.ca/dai-quo/index-eng.htm
Stockwatch
Tradingview
https://www.tradingview.com/e/MSuvXQsL/
CANADIAN BUSINESS PUBLICATIONS(TOP)
Alberta Oil: The Business of Energy
http://www.albertaoilmagazine.com
Canadian Business
http://www.canadianbusiness.com/
Northern Business Ontario
http://www.northernontariobusiness.com/
Report on Business Magazine (The Globe and Mail)
http://www.theglobeandmail.com/report-on-business/rob-magazine/
CAR AND ATI-related STORIES(TOP)
Access to airline safety reports held up by court action (CBCNews)
Ambrose got earful on definition-of-life vote (CBC News)
http://www.cbc.ca/news/politics/story/2012/12/05/pol-ambrose-woodworth-motion-correspondence.html
Access to Information Act turns 30 amid calls for reform (CBC News)
http://www.cbc.ca/news/politics/story/2012/07/06/pol-access-to-information-30th-anniversary.html
Access to Info Watch: In search of … documents that never were (CBC News)
As fundraising gap grows, Toronto’s wealthy schools leaving poor schools behind (Toronto Star)
Advocates demand inquiry into Ontario’s costly handling of Royal Crest nursing-home failure: Bankruptcy of nursing-home chain cost feds, province, unions tens of millions of dollars (CBC News)|
http://www.cbc.ca/news/canada/story/2009/03/23/ontario-royal-crest-nursing-home.html
ANALYSIS | Health Canada drug approval policy lacks key power (CBC News)
http://www.cbc.ca/news/politics/story/2011/11/30/pol-drug-approvals-health-canada.html
Another OC Transpo crash: Passenger suggests “refresher course” for bus drivers (The Ottawa Citizen)
A Twitter memorial to Canada’s war dead (Glen McGregor’s blog for the Ottawa Citizen)
http://blogs.ottawacitizen.com/2011/11/09/a-twitter-memorial-to-canadas-war-dead/
A CBC News investigation into the increasing use of atypical anti-psychotics among the elderly (CBC News)
http://www.cbc.ca/news/background/seniorsdrugs/off-limits.html
1 in 1,000: How often Tories break ranks (The Ottawa Citizen analysis of House of Commons votes)
Air force warned about backlash over MacKay’s chopper flight (The Toronto Star)
Analysing data is the future for journalists, says Tim Berners-Lee (The Guardian)
http://www.guardian.co.uk/media/2010/nov/22/data-analysis-tim-berners-lee
An ugly campaign against the CBC (The Toronto Star)
http://www.thestar.com/opinion/editorialopinion/article/1086826–an-ugly-campaign-against-the-cbc
Arthritis claims up in bid to speed applications: Advocates say it’s easier to get a doctor to sign a prescription for pot intended to treat sore joints (PostMedia News)
http://www.vancouversun.com/health/Arthritis+claims+speed+applications/5841518/story.html
Border agency policy spells out surveillance rules (CBC News)
Border officer fired for association with convicted criminal (CBCNews)
Documents show ‘harperization’ of government communications (The Canadian Press)
Don’t shoot the messenger
http://www.torontosun.com/2011/11/16/dont-shoot-the-messenger
Drug seizure stories (CBC News)
http://www.cbc.ca/news/politics/story/2013/03/27/pol-busted-at-the-border-drug-seizures-cbsa.html
http://www.cbc.ca/news/politics/story/2013/03/27/pol-border-drug-seizures-china-gbh.html
http://www.cbc.ca/news/canada/british-columbia/story/2013/03/27/bc-cbsa-drugs-ketamine.html
http://www.cbc.ca/news/canada/windsor/story/2013/03/28/wdr-cocaine-seizures-ambassador-bridge.html
http://www.cbc.ca/news/canada/nova-scotia/story/2013/03/27/ns-border-halifax-smuggle.html
http://www.cbc.ca/news/canada/manitoba/story/2013/03/27/mb-khat-manitoba-border-smuggling.html
http://www.radio-canada.ca/grands-titres/
http://www.cbc.ca/news/politics/inside-politics-blog/2013/03/post-15.html
Canada’s arms sales to the Middle East (CBC News)
CBC’s David McKie on investigative reporting
http://www.cbc.ca/news/yourcommunity/2012/04/cbcs-david-mckie-on-investigative-reporting.html
CBC releases some records to House committee (CBC News)
http://www.cbc.ca/news/politics/cbc-releases-some-records-to-house-committee-1.1008924
Citizenship backlog stark contrast to fast-tracked Olympic skater (CBC News)
Would-be Olympic ice dancer fast-tracked to Canadian citizenship (Global News)
Censors must not arbitrarily black out public documents, panel rules (The Globe and Mail)
Complaints against OC Transpo drivers pile up
Clement seeks ‘culture change’ on government transparency (The Globe and Mail)
Code Red (The Hamilton Spectator)
http://www.thespec.com/topic/codered
EcoEnergy home retrofits’ early end left funds unspent: Internal memo says funds budgeted for 2011 renewal of home energy savings plan (CBC News)
http://www.cbc.ca/news/politics/ecoenergy-home-retrofits-early-end-left-funds-unspent-1.2447081
Party discipline: Conservative MPs break ranks more often than opposition (The Globe and Mail)
Contaminated sites across Canada require clean up (CBC News)
Drunk driving tops list of pardoned offences (CBC News)
http://www.cbc.ca/news/politics/story/2011/02/09/parole-board-numbers.html?ref=rss
FATAL FLIGHTS A Perilous Rush to Profit (The Washington Post)
http://www.washingtonpost.com/wp-dyn/content/article/2009/08/20/AR2009082004500.html
Federal agency ACOA writes off millions in bad loans (CBC News)
http://www.cbc.ca/news/politics/story/2012/10/12/pol-mckie-power-politics-acoa-loan-defaults.html
$1.4B tax scams nail donors:Taxman going after 106,000 who submitted inflated charity claims (The Toronto Star)
http://www.thestar.com/Investigation/article/261820
Absent Liberals under fire for giving Tories de facto majority (The Ottawa Citizen)
http://www.canada.com/ottawacitizen/story.html?id=0cf2b9a0-663c-4a30-8a8e-ef30cec3e7ed&k=37011&p=1
Arming the world (CBC National Radio News)
http://www.cbc.ca/news/background/arming-the-world/
Beaten Down: Fear and violence in Canada’s nursing homes (CBC National Radio News)
http://www.cbc.ca/news/background/nursing-homes/
Behind the kitchen door (The Edmonton Journal)
Beauty and the Breast: The Controversy Continues (CBC News)
Click here to download the documentary
Bird strikes increasing at Canadian airports, data shows (CBC News)
http://www.cbc.ca/canada/story/2009/05/13/bird-strikes-airports.html?ref=rss
Bruce Carson not alone in bankruptcy
Buying Influence? Which lobbyists gave money to councillors durring the last election? (Toronto Media Co-op)
http://toronto.mediacoop.ca/story/buying-influence/4843
Canada’s air marshals cost $40 million a year, documents show
http://www.canada.com/business/Canada+marshals+cost+million+year+documents+show/5254081/story.html
Canada OK’s most Sri Lankan refugee claims (CBC News)
http://www.cbc.ca/news/politics/story/2010/09/27/f-migrant-refugee-numbers.html?ref=rss
Canadian military grapples with drug convictions (CBC News)
http://www.cbc.ca/news/politics/story/2010/09/17/f-military-conviction-drug.html
Canadian Newspaper Association freedom-of-information audit of police forces (CBC story)
http://www.cbc.ca/canada/story/2009/01/09/access-to-information.html?ref=rss
Canadian arms sales 2007-09 top $1.4B
http://www.cbc.ca/news/canada/story/2011/03/11/pol-arms-sales.html
Care and attention: Daycares lost track of children 230 times over five years (The Vancouver Sun)
http://www.canada.com/vancouversun/features/care/index.html
CBSA urged to act on marriage fraud complaints: Immigration minister wants border agents to build credible cases (CBC News)
http://www.cbc.ca/news/politics/story/2011/10/29/pol-marriage-fraud.html
Close call for Labrador-bound flight (CBC News Newfoundland)
Collision Course ( The Toronto Star, Hamilton Spectator and The Record)
http://blogs.ukings.ca/carincanada/2006/06/14/collision-course/
Dangling the Dollars ( The Ottawa Citizen and the Halifax Chronicle-Herald)
Database: G8/G20 spending numbers (CBC News)
Database: Accessing MPs’ expenses
http://www.cbc.ca/news/politics/story/2010/10/29/f-database-mp-expenses.html
Deadly Mistkes: Critical Errors by City’s Network Found in 40 Fatalities; Confidential Files Show Wide Pattern of Official Neglect (The Washington Post)
http://www.pulitzer.org/citation/2002,Investigative+Reporting
Dirty little secrets: Abuse in daycares (The Toronto Star)
http://www.thestar.com/News/article/218357
Dishing the Dirt (Winnipeg Free Press)
http://www.winnipegfreepress.com/breakingnews/Dishing-the-dirt-49338292.html
Driving the 401 a risky business (The Toronto Star)
http://www.thestar.com/article/236480
Dying for Job (CBC National Radio New)
http://www.cbc.ca/news/background/workplace-safety/dyingforajob.html
http://www.cbc.ca/news/background/workplace-safety/media.html
Explore the Data
Europe’s Hidden Billions – tracking EU structural funds (The Financial Times)
Facts & Figures (The Chronicle of Higher Education)
http://chronicle.com/section/Facts-Figures/58/
Faint Warning ( CBC National Radio News)
Federal workers lead pack in rising absenteeism (The Ottawa Citizen)
Please read the story by clicking here.
Federal cuts threaten program hiring medically discharged vets (CBC News)
http://www.cbc.ca/thehouse/2012/08/04/program-to-help-veterans-find-work-delivering-mixed-results/
Feds open up access to government data (CBC News)
http://www.cbc.ca/news/politics/story/2011/11/16/pol-clement-open-government.html
Fewer prisoners escaping federal custody (CBC News)
http://www.cbc.ca/news/canada/thunder-bay/story/2012/10/30/pol-prison-escapes.html
Fixing D.C.’s Schools (A Washington Post investigation)
http://www.washingtonpost.com/wp-srv/metro/interactives/dcschools/
Flaherty looked to Liberals for lessons on spending cuts (CBC News)
http://www.cbc.ca/news/politics/story/2011/06/03/pol-budget-cuts.html
Florida’s Stand Your Ground Law (Tampa Bay Times)
http://tampabay.com/stand-your-ground-law/
Fluctuations in refugee rulings trouble critics (CBC News investigation)
http://www.cbc.ca/news/politics/story/2009/12/17/f-refugee-claims.html
Elusive access pushing patients to B.C (Calgary Herald)
http://www.calgaryherald.com/health/Elusive+access+pushing+patients/5841217/story.html
Government’s online information access plan falls short (CBC News)
http://www.cbc.ca/news/politics/story/2012/01/11/pol-mckie-atip-online-summaries-opengov.html
Government warned before loss of student loan, CPP data (CBC News)
http://www.cbc.ca/news/politics/story/2013/06/10/pol-mckie-pnp-hrsdc-data-security-breaches.html
‘Guantanamo North’: Inside Secretive U.S. Prisons (NPR)
http://www.npr.org/2011/03/03/134168714/guantanamo-north-inside-u-s-secretive-prisons
Harvesting Cash (A Washington Post investigation into farm subsidies)
http://www.washingtonpost.com/wp-srv/nation/interactives/farmaid/
Health Canada planned to target binge, pregnant smokers (CBC News)
http://www.cbc.ca/canada/story/2010/12/08/tobacco-warnings-health-canada.html
Hosed at the Pumps (The Ottawa Citizen)
http://www.canada.com/ottawacitizen/features/hosedatthepumps/index.html
Immigration programs still poorly tracked: Volpe
http://www.cbc.ca/news/politics/story/2011/01/28/mckie-cic-volpe-012911.html
http://www.ottawacitizen.com/health/Increase+STDs+region+alarming+officials/3618141/story.html
Industry Canada queried Bernier census claims
http://www.cbc.ca/news/politics/story/2010/10/04/census-bernier-complaints-documents.html
Information czar gives Canada Post, CBC low marks (CBC News)
http://www.cbc.ca/news/arts/story/2011/03/10/pol-info-czar-post-cbc.html
Inmate programs fall short of capital spending (CBC News)
http://www.cbc.ca/news/politics/story/2011/01/13/inmate-spending-mckie.html?ref=rss
IMPACT (The Record series on road safety)
http://news.therecord.com/specialsections/section/impact
Inspectors averaged 2 hours a day inside listeria-infected plant (The CBC and Toronto Star)
http://www.cbc.ca/canada/story/2009/06/10/listeria-inspectors-maple-leaf.html?ref=rss
Female appointments dip under Tories (CBC News)
http://www.cbc.ca/canada/story/2011/01/07/mckie-gender-equity.html
Firms with worker deaths to lose rebates: Star investigation prompts WSIB change (The Toronto Star)
http://www.thestar.com/News/Ontario/article/504076
Food for thought (The Ottawa Citizen)
Food agency database shows rise in serious product recalls (CBC News)
http://www.cbc.ca/news/politics/story/2011/10/07/pol-cfia-food-product-recalls.html
Forced Out (A Washington Post Investigation Into the Casualties of the District’s Real Estate Boom)
http://www.washingtonpost.com/wp-srv/metro/forcedout/index.htm
Gas-pedal problems plagued several carmakers (CBC News)
http://www.cbc.ca/news/gas-pedal-problems-plagued-several-carmakers-1.941619
GIVE AND TAKE: Charitable empire has high costs
http://www.thestar.com/News/Ontario/article/273350
Gun seizures up but fears of porous border remain (CBC News)
http://www.cbc.ca/news/politics/story/2013/05/01/pol-cbsa-weapons-seized-border-guns.html
Lebanon crisis sparked consular staff concerns (CBC News)
http://www.cbc.ca/news/politics/story/2011/02/05/lebanon-evacuation-report.html?ref=rss
Listeriosis victims, families still waiting for compensation (CBC News)
http://www.cbc.ca/news/politics/story/2011/10/08/pol-listeriosis-claim-payments.html
Lobbyists mount full-court press (The Ottawa Citizen)
http://www.ottawacitizen.com/news/Lobbyists+mount+full+court+press/3792127/story.html
Looking for art? You can get a real steal at government buildings (The Canadian Press)
MacKay helicopter airlift ‘under guise’ of training (CBC News)
http://www.cbc.ca/news/politics/story/2011/12/01/pol-mackay-helicopter-fishing-flight.html
MacKay took taxpayer-funded helicopter after officials advised against media event (Postmedia News)
Marriages of convenience problems persist (CBC News)
http://www.cbc.ca/news/politics/story/2010/11/07/david-mckie-marriages-of-convenience.html
http://www.cbc.ca/news/politics/story/2011/10/29/pol-marriage-fraud.html
Medical marijuana blurb (PostMedia News)
http://www.canada.com/Medical+marijuana+blurb/5841886/story.html
Medical marijuana requests spike, with severe arthritis most common claim (Edmonton Journal.com)
Memo warned Toews of risks in dropping gun show rules: Elimination of long-gun registry raises concern over gun show sales (CBC News)
http://www.cbc.ca/news/politics/story/2012/11/13/pol-gun-show-briefing-notes-power-politics.html
More people failing revamped citizenship tests (CBC News)
http://www.cbc.ca/news/politics/story/2013/06/14/pol-citizenship-immigration-test-failure-rate.html
Government signals crackdown on marriage fraud
http://www.cbc.ca/news/politics/story/2011/03/29/pol-marriage-fraud.html
Medical marijuana law changes under microscope (CBC News)
http://www.cbc.ca/news/politics/story/2011/09/28/pol-mckie-medical-marijuana-talks.html
More CAR-related stories ( CARinCanada)
http://blogs.ukings.ca/carincanada/category/stories-done-with-car/
More home sellers taking a loss (The Baltimore Sun)
http://www.baltimoresun.com/business/bal-te.bz.loss11oct11,0,3496598,full.story
More than $1M spent on VIP flights for Natynczyk since 2008 (CTV News)
http://www.ctv.ca/CTVNews/Canada/20110915/million-spent-on-vip-flights-for-natynczyk-since-110915/
Most medical marijuana users middle-aged men (The Ottawa Citizen)
http://www.canada.com/health/Most+medical+marijuana+users+middle+aged/5837757/story.html
Muslim panelists ‘not available,’ unredacted document says (CBC News)
Natural Resources Minister Joe Oliver said he didn’t ‘know very much’ about energy projects, emails reveal (Post Media)
Navigation Protection Act: Government braces for court battles over waterways (CBC News)
News stories produced by ATI Act requests, 2006-2010
http://www3.telus.net/index100/atiastories1
No Running Water (The Winnipeg Free Press)
http://www.winnipegfreepress.com/no-running-water/
Nova Scotia government gave $2.3 million in merit pay to civil servants (The Chronicle Herald)
http://thechronicleherald.ca/Front/9021696.html
50 Alberta news stories made possible by FOIP Act requests
http://www3.telus.net/index100/albertafoistories
OC Transpo’s waiting game (It’s not your imagination. According to a Citizen study, fewer than half of OC Transpo buses run on time. Glen McGregor crunches the numbers.)
http://www.ottawacitizen.com/Transpo+waiting+game/4190821/story.html
PDF version of Glen’s entire OC Transpo series, including the methodology
Oda’s staff silent on travel expense changes (CBC News)
http://www.cbc.ca/news/politics/story/2012/05/30/pol-oda-expenses.html
Ontario public servants’ $100,00 Club growing; 24% Rise In Year (National Post)
Ontario runway problems cause rise in plane accidents (CBC News)
http://www.cbc.ca/news/canada/ottawa/story/2011/09/07/ottawa-airport-landing-problems.html
OpenGov Watch: 48 ATI-governed entities down, 100+ to go! (CBC News)
Ottawa high schools’ police presence shows results (CBC News)
http://www.cbc.ca/news/canada/ottawa/ottawa-high-schools-police-presence-shows-results-1.2619602
Out of Synch (CBC National Radio News)
http://www.cbc.ca/news/background/workplace-safety/outofsync.html
Overserved (Ottawa Citizen series on bar inspections)
http://www.ottawacitizen.com/entertainment/Controversy+straight/1965956/story.html
http://www.ottawacitizen.com/search/search.html?q=overserved
Pardons allow new start, applicants say (CBC News)
http://www.cbc.ca/news/politics/story/2011/02/20/pol-mckie-pardon-story.html
Pardon applications expected to tumble (The Canadian Press)
http://www.cbc.ca/news/politics/story/2012/01/03/pardons-canada-prison.html
Parking Secrets: Where you’re most likely to be ticketed (The Vancouver Sun)
http://www.vancouversun.com/Parking+Secrets+Where+most+likely+ticketed/1323988/story.html
Police dip into victims’ cash (The Toronto Star)
http://www.thestar.com/news/gta/article/702444
Political contributions: What the numbers say
Political donations in Alberta – 2004 to 2010 (Edmonton Journal)
http://www.edmontonjournal.com/news/donations/database.html
http://www2.canada.com/edmontonjournal/news/story.html?id=a4ddf170-bd63-4ff0-b7d9-9ae55199e92c&p=2
Prescribed to death
http://www.cbc.ca/news/background/seniorsdrugs/
Prison ‘double-bunking’ risks violence, ombudsman says (CBC News)
http://www.cbc.ca/news/politics/story/2011/06/17/pol-prisons-double-bunking.html
Payment plea for Tamil protest costs ignored (CBC News)
http://www.cbc.ca/news/politics/story/2010/07/29/ottawa-tamil-protest-costs-public-safety.html
Private sector must help keep lid on drug costs, report argues (CBC News)
http://www.cbc.ca/news/politics/story/2011/05/11/pol-mckie-drug-costs-report.html
PS balloons on Conservatives’ watch (The Ottawa Citizen)
http://www.ottawacitizen.com/business/Conservatives+watch/4234048/story.html
Public service absenteeism jumps by 40%; ‘Alarming’ spike over past decade draws ire, sympathy from experts (The Ottawa Citizen)
Please read the story by clicking here
Race Matters (The Toronto Star)
http://www.thestar.com/specialsections/raceandcrime
Rapid Fire (The Ottawa Citizen)
http://www.canada.com/ottawacitizen/features/rapidfire/index.html
RCMP fire Tasers multiple times despite health hazards: probe (CBC-Radio-Canada, The Canadan Press)
http://www.cbc.ca/canada/story/2008/06/11/taser-rcmp.html
RCMP softened Taser-use restrictions (CBC-Radio-Canada, The Canadian Press)
http://www.cbc.ca/canada/britishcolumbia/story/2009/03/25/taser.html
RCMP shocked 16 people five times or more last year (CBC and The Canadian Press)
http://www.cbc.ca/news/canada/rcmp-shocked-16-people-five-times-or-more-last-year-1.812794
RCMP spied on scholar Northrop Frye, records show (The Canadian Press)
To read article, please click here
RCMP spied on Tommy Douglas as early as 1936 (The Canadian Press)
http://www.ctv.ca/CTVNews/Canada/20111111/tommy-douglas-rcmp-files-111111/
RCMP halts use of older model Tasers after B.C. decision (The CBC)
http://www.cbc.ca/canada/british-columbia/story/2009/06/01/bc-government-pulls-tasers.html?ref=rss
Report details encounters with rude, accusatory border employees (The Canadian Press)
Ring of Fire mining may not benefit First Nations as hoped (The CBC)
Rise in prison gangs fuelling violence, drug trade (CBC News)
http://www.cbc.ca/news/politics/story/2012/10/24/pol-gangs-prisons.html
Roadside breath tests not always accurate: documents (CTV News, British Columbia)
Several news stories by Stanley Tromp, based upon Freedom of Information requests
http://www3.telus.net/index100/trompfoistories
Secret Skies (CBC News investigation into air safety on the 10th anniversary of the Swissair crash)
http://www.cbc.ca/news/secretskies/
Security video of Robert Dziekanski: Select footage from 6 hours in Vancouver International Airport (CBC News)
http://www.cbc.ca/news/background/tasers/video.html
Some airport screeners have sticky fingers, documents show (QMI Agency)
http://www.torontosun.com/2011/09/12/some-airport-screeners-have-sticky-fingers-documents-show
Some childcare facilities fall short of government standards (Martha Troian, CBC News North)
Some tested Tasers fire stronger current than company says: CBC/Radio-Canada probe
http://www.cbc.ca/canada/story/2008/12/04/taser-tests.html
Taser this: RCMP increases its use of stun guns ( CBC National Radio News/The Canadian Press)
http://www.cbc.ca/news/background/tasers/taser-use.html
Tax breaks for volunteer firefighters – less than meets the eye (CBC News, Election 2011 reality check)
Temporary foreign workers hired in areas with EI claimants (CBC News)
http://www.cbc.ca/news/politics/story/2013/05/06/temporary-foreign-worker-program.html
Temporary Foreign Worker Program complaints began in 2006 (CBC News)
http://www.cbc.ca/news/politics/temporary-foreign-worker-program-complaints-began-in-2006-1.2685056
Temporary Foreign Worker Program queries came mostly from Tory MPs (CBC News)
Harper says foreign worker program is being fixed (CBC News)
http://www.cbc.ca/news/politics/story/2013/05/07/pol-cp-temporary-foreign-workers.html
The Hornet’s Sting (The Ottawa Citizen)
http://www.canada.com/ottawacitizen/features/hornet/index.html#
The Joy of Parking (CBC Radio Halifax)
http://www.cbc.ca/ns/features/the-joy-of-parking/
The long, hot summer (The Winnipeg Free Press)
http://www.winnipegfreepress.com/breakingnews/the-long-hot-summer-128867333.html
The school nurse is in … for now (Pioneer Press)
http://www.twincities.com/ci_13874895?nclick_check=1
The Washington Post (artricles by former database editor Sarah Cohen)
http://projects.washingtonpost.com/staff/articles/sarah+cohen/
Times launching database that maps, analyzes crime reports across L.A. County
http://www.latimes.com/news/local/la-me-crime-data-20100930,0,4503455.story
Time’s Up (Winnipeg Free Press)
http://www.winnipegfreepress.com/special/parking_tickets/
Tory ridings the winners from stimulus (The Ottawa Citizen)
Tory MP who flirted with Chinese reporter passed security check (The Canadian Press)
Toxic spills put Arctic under threat, report finds
Too many drugs allowed on market: MP (CBC News)
http://www.cbc.ca/news/health/story/2011/01/19/health-canada-drugs.html
Top-paid Ont. civil servants list jumps 11% (CBC News)
http://www.cbc.ca/news/canada/toronto/story/2011/03/31/ontario-sunshine-list.html
Tory crime plan fails victims, inmates: critics (CBC News)
http://www.cbc.ca/news/story/2011/02/15/pol-mckie-inmate-programs.html
Toyota floor-mat problems arose in 2003 (CBC News)
http://www.cbc.ca/news/toyota-floor-mat-problems-arose-in-2003-1.974720
Toyota should have revealed ’05 lawsuit: critics (CBC News)
http://www.cbc.ca/money/story/2010/04/12/toyota-lawsuit-critics.html
Toyota problems seen months before recall (CBC News)
http://www.cbc.ca/news/toyota-problems-seen-months-before-recall-1.896283
Toxic Waters: Clean Water Laws Are Neglected, at a Cost in Suffering (The New York Times)
http://projects.nytimes.com/toxic-waters
U.S. worries about Canadian meat flagged in memo: Coalition wants plug pulled on meat pre-clearance pilot project in wake of XL Foods recall
XL Foods warned 6 times over lapses before E. coli outbreak (CBC News): Correction Action Requests issued at Alberta plant for sanitation, contamination
http://www.cbc.ca/news/politics/story/2013/01/08/pol-cfia-xl-foods-atip-corrective-action.html
Vehicle safety bill moves ahead (CBC News)
http://www.cbc.ca/canada/story/2010/10/06/transport-canada-recall-vehicles.html?ref=rss
Visits to food banks in Toronto’s suburbs up almost 20% since 2008 (CTV News)
Who are Saskatchewan’s medicinal marijuana users? ( The Leader-Post)
http://www.leaderpost.com/health/Saskatchewan+medicinal+marijuana+users/5838807/story.html
Who wins, loses from mass immigration to California? (The Orange County Register)
http://www.ocregister.com/news/-267327–.html
WORKING WOUNDED: Hiding injuries rewards companies
http://www.thestar.com/News/GTA/article/451322
CATALOGUE SEARCH ENGINES (TOP)
Yahoo
LookSmart
Open Directory Project
Cluster searches
Reporter’s desktop
http://www.reporter.org/desktop/
Verbatim tool: Search using the exact words you typed
https://support.google.com/websearch/answer/1734130?hl=en\
Incognito mode (browse in private)
https://support.google.com/chrome/answer/95464?hl=en
DuckDuckGo (anonymous searches)
Firefox Private Browsing
http://support.mozilla.org/en-US/kb/private-browsing-browse-web-without-saving-info
CENSUS (TOP)
Canadian Census Analyser from the University of Toronto
https://login.proxy.library.carleton.ca/login?url=http://dc1.chass.utoronto.ca/census/
Canadian Immigration Stats (for Canada and all regions from the 2001 and 2006 censuses)
Boundary files (Statistics Canada)
http://www12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-eng.cfm
City of Ottawa 2011 Census Backgrounder
http://barrhavenbia.ca/files%20to%20add%20to%20website/A%20-%20Census%20Report_Planning%20Committee%20final.pdf
Geogrpahic levels for 2011 census (Statistics Canada)
2006 Census Population (Statistics Canada)
http://www12.statcan.gc.ca/census-recensement/2006/index-eng.cfm
2006 Census Income and Earnings
2006 Census Household Income
2011 Census – Province and Territory Cargographic Boundary Files (Statistics Canada)
http://www.data.gc.ca/data/en/dataset/bab06e04-e6d0-41f1-a595-6cff4d71bedf
NHS Profile, 2011
http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/index.cfm?Lang=E
National Household Survey User Guide
http://www12.statcan.ca/nhs-enm/2011/ref/nhs-enm_guide/index-eng.cfm
HS Profile – Download NHS data for a complete geographic level: CSV or TAB
CHILDREN’S SAFETY (TOP)
Child Care Lookup (Government of Alberta)
http://www.child.alberta.ca/home/ChildCareLookup.cfm
Ontario Ministry of Children and Youth Services (Find Licenced Childcare)
Toronto’s Children’s Services
http://www.toronto.ca/children
Nova Scotia Directory of Licensed Child Care Facilities
http://www.gov.ns.ca/coms/families/childcare/directories/FacilitySearch.aspx
Care and Attention (The Vancouver Sun’s investigation into daycares)
http://www.canada.com/vancouversun/features/care/index.html
Child and Spousal Support: Maintenance Enforcement Survey Statistics (Statistics Canada)
http://www.statcan.gc.ca/pub/85-228-x/85-228-x2011000-eng.htm
http://www.statcan.gc.ca/pub/85-228-x/2011000/tablesectlist-listetableauxsect-eng.htm
CONSUMER ISSUES AND CONSUMER-RELATED STORIES(TOP)
InjuryBoard Blog Network
Chemical companies, Big Tobacco and the toxic products in your home (Chicago Tribune.com)
http://media.apps.chicagotribune.com/flames/index.html
COMPUTER-ASSISTED REPORTING(Top)
CBC’s adverse drug reaction database series
Rapid Fire ( the Ottawa Citizen’s searchable online gun registry database http://www.canada.com/ottawacitizen/features/rapidfire/form.html
National Institute for Computer-Assisted Reporting
http://www.ire.org/resource-center/listservs/subscribe-nicar-l/
Investigative Reporters and Editors, Inc.
Example syllabi
http://ire.org/resource-center/educators-center/syllabi/
Syllabi – Curriculum Outlines and Ideas (IRE)
http://www.ire.org/education/syllabi.html
Center for Public Integrity
http://www.publicintegrity.org/wow/default.aspx
CARinCanada
Calculator Soup
http://www.calculatorsoup.com/calculators/algebra/percent-change-calculator.php
NewsEngin’s Percent Change Calculator
http://newsengin.com/neFreeTools.nsf/PercentChange/formPercentChange
Stephen Lamble’s computer-assisted reporting home page (Faculty of Arts and Social Sciences, University of the Sunshine Coast, Queensland, Australia)
http://members.optusnet.com.au/~slamble/index.html
SearchEngineWatch.com
Jakob Nielsen’s Website (Expert advice on Internet trends and usage)
Domain name registries around the world
http://www.norid.no/domenenavnbaser/domreg.html
Latitude/Longitude Distance Calculation
http://jan.ucc.nau.edu/~cvm/latlongdist.html
NGA Range Bearing Computation (the National Geospatial-Intelligence Agency)
http://geoengine.nga.mil/geospatial/SW_TOOLS/NIMAMUSE/webinter/rangbear.html
SQL Server Express
http://www.microsoft.com/express/Database/InstallOptions.aspx
University of Maryland Computer Science (the history of spreadsheets and other applications)
http://www.cs.umd.edu//class/spring2002/cmsc434-0101/MUIseum/applications/index.html
COMPUTER-ASSISTED REPORTING TUTORIALS(Top)
Text editing with spreadsheets
http://forjournalists.com/cookbook/index.php?title=Text_editing_with_spreadsheets
‘Microsoft Excel Tips’ (CARinCanada)
http://blogs.ukings.ca/carincanada/category/data-you-can-use/
Excel Tips
http://excel.tips.net/questions.html?awt_l=9wwNF&awt_m=1aE6X1z3C1sx4X
My Favorite (Excel) Things (Excellent tutorial from MaryJo (Sylwester) of the St. Paul Pioneer Press)
http://extra.twincities.com/CAR/MJ/ExcelClasshandout.pdf
http://extra.twincities.com/CAR/MJ/DataStateofMind.pdf
http://extra.twincities.com/CAR/MJ/ManagingJuggling.pdf
Computer-Assisted Reporting: A Comprehensive Primer
http://www.oupcanada.com/higher_education/companion/comm_studies/9780195424577.html
ProPublica News Apps Style Guide
https://github.com/propublica/guides/blob/master/news-apps.md#data-singular-or-plural
Reporters’ Cookbook!
http://forjournalists.com/cookbook/index.php?title=Main_Page
Computer Tutorials
http://599cd.com/tips/excel/?key=
HelpbyHacks
http://help.hackshackers.com/questions
Miracle Solutions
http://www.auditexcel.co.za/GoTo%20Special%20Project.html#eighth
Internet Relay Chat
http://en.wikipedia.org/wiki/Internet_Relay_Chat
Google Refine (ClusteringInDepth)
http://code.google.com/p/google-refine/wiki/ClusteringInDepth
How to Scrape Websites for Data without Programming Skills (The Poynter Institute)
Scraping for Journalists: How to grab data from hundreds of sources, put it in a form you can interrogate – and still hit deadlines By Paul Bradshaw
https://leanpub.com/scrapingforjournalists
For Journalism: Data journalism for all (@forjournalism)
https://twitter.com/forjournalism
101 Ready-to-Use Excel Formulas
http://books.google.ca/books?id=HnwJBAAAQBAJ&printsec=frontcover#v=onepage&q&f=false
Excel DATEDIF Function – Calculate the difference between two dates
http://www.exceltrick.com/formulas_macros/excel-datedif-function/
The Elements of Data Analytic Style
CONTRACTS(Top)
Buyandsell.gc.ca
https://buyandsell.gc.ca/procurement-data/tenders
Government-Wide Reporting — Proactive Disclosure (Treasury Board Secretariat of Canada)
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
http://open.canada.ca/data/en/dataset/455d4d0a-5d5f-4f60-aa8a-9e36540d21d3
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)
Crimes by type of violation, and by province and territory (Statcan summary tables)
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/legal50a-eng.htm
Incident-based crime statistics, by detailed violations (Statcan summary tables)
http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2520051&paSer=&pattern=&stByVal=1&p1=1&p2=37&tabMode=dataTable&csid=
Juristat (Statistics Canada)
http://dsp-psd.pwgsc.gc.ca/Collection-R/Statcan/85-002-XIE/85-002-XIE.html
Public Safety Canada terrorist list
http://www.publicsafety.gc.ca/cnt/ntnl-scrt/cntr-trrrsm/lstd-ntts/crrnt-lstd-ntts-eng.aspx
Ottawa Police
http://www.ottawapolice.ca/en/CrimeFiles/CrimeMaps_Reports/crimestats.aspx
Crime Reports (Ottawa police)
http://www.ottawapolice.ca/en/crime/crime-stats.asp
Canadian Association of Police Boards
http://capb.cms10.tomahawk.ca/Home
Crime Reports (crime mapping company for police forces in North America)
http://www.crimereports.com/map?search=Ottawa+Ontario
The University of Ottawa
http://www.protection.uottawa.ca/en/statistics.html
Queen’s University
http://www.queensu.ca/security/
Security in the Community (Hintonburg Community Association)
http://hintonburg.com/SC_start.html
Tracking the Politics of ‘Crime’ and Punishment in Canada
http://tpcp-canada.blogspot.com/
Adult Correctional Services Survey (Canadian Centre for Justice Statistics)
http://library.queensu.ca/webdoc/ssdc/b2020/ccjs_guide.htm
United Nations Office of Drugs and Crime — Global Study on Homicide
http://www.unodc.org/gsh/en/data.html
DATABASES(Top)
Vehicle Defect Complaints (Transport Canada)
Ottawa Citizen article on domestic violence
Statscan2006 detailed samesex data
Statscan 2001 detailed samesex data
Ottawa CMA, all violation, 1998-2010
AidData
http://aiddata.org/content/index/AidData-Raw
Data & Research (The World Bank)
Datacatalogs.org (a comprehensive list of open data catalogs currated by experts from around the world)
DATA JOURNALISM (Top)
50 data-journalism ideas (NICAR)
Bad water: ‘Third World’ conditions on First Nations in Canada
http://www.cbc.ca/news/canada/manitoba/bad-water-third-world-conditions-on-first-nations-in-canada-1.3269500
Data Desk (The Los Angeles Times)
DATA JOURNALISM: AN EXPLICATION
https://isojjournal.wordpress.com/2015/04/15/data-journalism-an-explication/
The Guardian’s data blog
http://www.theguardian.com/news/datablog
Dan Bricklin’s Web Site
Data Journalism Blog
http://www.datajournalismblog.com
Data Journalism Handbook (1.0 Beta)
http://datajournalismhandbook.org/1.0/en/
Chicago Crime (Chicago Tribune)
http://crime.chicagotribune.com/
http://www.chicagotribune.com/news/data/
Collaboration, computer help, and coding: A new book looks at data journalism in the newsroom
http://www.niemanlab.org/2015/12/collaboration-computer-help-and-coding-a-new-book-looks-at-data-journalism-in-the-newsroom/?utm_source=Daily+Lab+email+list&utm_campaign=e1cb6f04fc-dailylabemail3&utm_medium=email&utm_term=0_d68264fd5e-e1cb6f04fc-395868801
How the News Apps Team at Chicago Tribune Works
http://www.datajournalismhandbook.org/1.0/en/in_the_newsroom_2.html
News Apps Blog ( The Chicago Tribune)
http://blog.apps.chicagotribune.com/
NICAR Courses
Open (The New York Times)
http://open.blogs.nytimes.com/
http://www.propublica.org/nerds
The Ythat Blog
The 10 and 3
http://www.the10and3.com/
DATA VISUALIZATION (Top)
Code out loud
Collision-prone: When are you statistically most likely to get in an accident?
http://www.wheels.ca/news/49355/
http://journalistopia.com/2013/05/21/free-tools-for-digital-journalism-storytelling/
Canada’s deficits and surpluses, 1963-2014 (CBC News)
http://www.cbc.ca/news2/interactives/canada-deficit/
Chart types and data formats
https://support.google.com/docs/topic/30240
Data visualization resources and ideas
http://www.mulinblog.com/data-visualization-resources-and-ideas/
THE DATAVIZ DESIGN PROCESS: 7 STEPS FOR BEGINNERS
http://annkemery.com/dataviz-design-process/
The Data Visualization Catalogue
http://datavizcatalogue.com/index.html
Dadaviz.com
http://dadaviz.com/
Data Visualization for Human Perception (By Stephen Few, chapter 35 in Interaction Design Foundation: Encyclopedia of Human-Computer Interaction)
https://www.interaction-design.org/encyclopedia/data_visualization_for_human_perception.html
FlowingData
http://flowingdata.com/
Innovation in America (Peter Aldous)
http://www.peteraldhous.com/innovation.html
Introduction to Data Visualization – top ten do’s and don’ts
http://guides.library.duke.edu/topten
Journalism in the Age of Data
http://datajournalism.stanford.edu/#
Junk Charts
http://junkcharts.typepad.com/
Michelle Minkoff
http://michelleminkoff.com/teaching/
Milestones in the History of Thematic Cartography,
Statistical Graphics, and Data Visualization
http://euclid.psych.yorku.ca/SCS/Gallery/milestone/
MulinBlog: A digital journalism blog
http://www.mulinblog.com/teaching-data-visualization-recommended-readings-and-resources/
Overview (visualizations of large document sets)
Public Data (Google)
http://www.google.com/publicdata/directory
Roberto Rocha
http://robertorocha.info/
Silk Blog (Picking The Right Visualization For Your Data)
http://blog.silk.co/post/120086012962/picking-the-right-visualization-for-your-data
Sixteen useless infographics
http://www.theguardian.com/news/datablog/gallery/2013/aug/01/16-useless-infographics?CMP=twt_gu
Video: All Your Pot Are Belong to Us (The Center for Investigative Reporting)
http://cironline.org/reports/video-all-your-pot-are-belong-us-4771
Which tool should I use?http://ire.org/files/static_files/video/toolvideos.html
W3Schools.com
http://www.w3schools.com/
World Development Indicators (The World Bank)
http://data.worldbank.org/data-catalog/world-development-indicators?cid=GPD_WDI
DEFENCE(Top)
CRS Evaluation Reports
http://www.crs-csex.forces.gc.ca/reports-rapports/rp-ev-eng.aspx
Office of the Judge Advocate General (National Defence)
http://www.forces.gc.ca/en/about-org-structure/judge-advocate-general-office.page?
Decisions of convictions resulting from courts martial
http://www.jmc-cmj.forces.gc.ca/en/2013/res.page
THE MONEY PAGE:Government gets poor grade for military spending (CBC News)
http://www.cbc.ca/news/politics/government-gets-poor-grade-for-military-spending-1.3030862
The Canadian Veterans Advocacy
http://canadianveteransadvocacy.com/
Summary Proceedings (National Defence)
http://www.admfincs.forces.gc.ca/qro-orf/vol-02/doc/chapter-chapitre-108.pdf
David Pugliese (Ottawa Citizen defence blog)
http://blogs.ottawacitizen.com/author/davidpugliese2/
University of British Columbia’s Veterans Transition Program
Army Suicide Prevention Program (The U.S.)
http://www.armyg1.army.mil/hr/suicide/references.asp
DIRECTORIES/REFERENCE WORKS (Top)
Repositories of Primary Sources
http://uidaho.edu/special-collections/Other.Repositories.html
Directory of Open Access Journals
WorldCat (WorldCat connects you to the collections and services of more than 10,000 libraries worldwide)
Webopedia
Wikipedia
http://en.wikipedia.org/wiki/Main_Page
Wikiscanner
Globe and Mail article about political staff making changes to Wikipedias, please click here
Canadian Historical Association Booklets
http://www.collectionscanada.ca/002/013/index-e.html?PHPSESSID=3f3137912b9f2b1722e11155b6401860
Sources Directory
Acronym Finder
Canadian Business & Current Affairs (CBCA): Queen’s University Library
http://library.queensu.ca/inforef/guides/databases/cbca.htm
Electronic Collection: A Virtual Collection of Monographs and Periodicals
Various Canadian sources
http://www.gdsourcing.ca/indexa.htm
Maps
Atlas of Canada
http://atlas.gc.ca/site/english/index.html
Books
Project Gutenberg
http://www.gutenberg.org/wiki/Main_Page
Canadian Encyclopedia
http://www.thecanadianencyclopedia.com/index.cfm?TCE_Version=A
Columbia University Libraries
http://www.columbia.edu/cu/lweb/
AskOxford.com (Oxford Dictionaries)
The Canadian Illustrated News (1869 to 1883)
http://www.collectionscanada.ca/cin/index-e.html
Dictionary of Canadian Biography
Bilingual Dictionaries
http://www.oxfordreference.com/views/SUBJECT_SEARCH.html?subject=s16&authstatuscode=200
History of the Federal Electoral Ridings since 1867
http://www.parl.gc.ca/information/about/process/house/hfer/hfer.asp?
Historical statistics of Canada
http://www.statcan.ca/english/freepub/11-516-XIE/sectiona/toc.htm
The Early Alberta Newspaper collection
http://136.159.239.228/newspapr/
Saskatchewan News Index 1884-2000
Acadiensis: The Journal of the History of the Atlantic Region
http://www.lib.unb.ca/Texts/Acadiensis/
Proquest
World News Digest
http://www.2facts.com/stories/digest-home-feature.asp
Europa World
http://www.europaworld.com/welcome?authstatuscode=200
Nationmaster.com
http://www.nationmaster.com/index.php
DIGITAL NEWS WEBSITES(Top)
Why your phone is suddenly full of explainer journalism (The Globe and Mail)
The Upshot
http://www.nytimes.com/upshot/?_r=0
Vox Media
http://www.voxmedia.com/#cover
Ricochet
Newsonomics
Quartz
The Intercept
https://firstlook.org/theintercept/
The Information
https://www.theinformation.com/
FiveThirtyEight
DISCIPLINARY BODIES(Top)
Chartered Accountants of Ontario
https://ebusiness.icao.on.ca/discipline/d/Alphaindex.cfm
DISCUSSIONS(Top)
Google Groups
http://groups.google.com/groups/dir
Yahoo! Groups
http://dir.groups.yahoo.com/dir/
National Archives (listserv discussion and references)
http://www.archivescanada.ca/car/car_e.asp?l=e&a=listserv
Journalism Listservs
http://reporter.asu.edu/listserv.htm
CataList (the official catalog of LISTSERV® lists)
http://www.lsoft.com/lists/listref.html
http://www.lsoft.com/scripts/wl.exe?XC=CA&C=Canada
Listserv search on journalismnet
http://www.journalismnet.com/people/listserv.htm
Canada FOI listserv
http://groups.yahoo.com/group/Canada-foi
The Slyck’s Guide to newsgroups
Tile.Net/Newsgroups (The Reference to Usenet Newsgroups)
Cyberfiber Newsgroups
Women’s Health
http://www.research.umbc.edu/~korenman/wmst/f_hlth.html
Road to Canada ( immigration discussion group)
http://www.roadtocanada.com/forums/
Workscape ( a workplace discussion group hosted by the Canadian Centre for Occupational Health and Safety)
Health-related listservs ( The Canadian Centre for Occupational Health and Safety)
http://www.ccohs.ca/resources/listserv.html
The Canadian Women’s Health Network (CWHN)
AvCanada (a discussion forum about aviation issues)
http://www.avcanada.ca/forums2/
Canadian Gunnutz
http://www.canadiangunnutz.com/
Ottawa South History Project (Canadian Heritage)
About Surrogacy.com
http://www.allaboutsurrogacy.com/forums/
SMO Message Boards
http://www.surromomsonline.com/support/
DOCUMENTCLOUD(Top)]
DocumentCloud
http://www.documentcloud.org/help/public
http://www.documentcloud.org/help/notes
Overview: Visual Document Mining for Journalists (beta)
https://www.overviewproject.org/
Annotated documents: Highlights of key excerpts and findings from Freeh report on Penn State (ydr.com)
http://www.ydr.com/local/ci_21055552
U.S. cables dissect Canada’s leaders: WikiLeaks (CBC News)
http://www.cbc.ca/news/canada/story/2011/05/01/wikileaks-canada-leaders.html
Chemical companies, Big Tobacco and the toxic products in your home (chicagogtribune.com)
http://media.apps.chicagotribune.com/flames/index.html
Videographer Who Took Aim at NPR Gets IRS Approval for New Charity (The Chronicle of Philanthropy)
http://philanthropy.com/article/Videographer-Who-Took-Aim-at/127637/
A key witness’ changing stories (chicagogtribune.com)
http://media.apps.chicagotribune.com/flames/facts-vs-testimony.html
Big pension payouts set in motion years ago (chicagotribune.com)
http://media.apps.chicagotribune.com/pensions/document_narrative.html
Colorado bill tracker
http://tekhne.co/colorado-bill-tracker/
Interactive: Inside The Health Care Ruling (National Public Radio)
How Nonprofits Spend Millions on Elections and Call it Public Welfare (ProPublica)
Legal Experts Decode the Supreme Court’s Obamacare Ruling (The Daily Beast)
Ex-Tyco CEO says “CEO-type bubble” made him feel entitled to steal millions (njcom)
http://www.nj.com/business/index.ssf/2012/04/ex-tyco_ceo_says_ceo-type_bubb.html
Read selected e-mails from Toronto Mayor Rob Ford’s communication team (The Globe and Mail)
http://www.theglobeandmail.com/news/toronto/article4423207.ece
Search the Afghan detainee documents (cbcnews)
http://www.cbc.ca/news/politics/story/2011/06/22/pol-afghan-detainee-docs-embed.html
The Sarah Palin emails (The Guardian)
http://www.guardian.co.uk/world/sarah-palin-emails
Read the Afghan detainee files and flag important passages (The Globe and Mail)
http://media.apps.chicagotribune.com/flames/facts-vs-testimony.html
The Education of Dasmine Cathey (Chronicle.com)
http://chronicle.com/article/The-Education-of-Dasmine-Cathey/132065/
Safety Flaws Found At Western State Hospital (KUOW News)
http://www.kuow.org/program.php?id=27190
Some of Christie’s biggest bills match model legislation from D.C. group called ALEC (nj.com)
http://www.nj.com/news/index.ssf/2012/04/alec_model_bills_used_in_nj_la.html
EXCLUSIVE: Detective is NYPD’s most-sued cop, with 28 lawsuits filed against him since 2006 (SEE INTERACTIVE GRAPHIC) Daily News
THE ECONOMY(Top)
The Bank of Canada
Bureau of Economic Analysis (U.S. Department of Commerce)
Canadian Centre for Policy Alternatives
https://www.policyalternatives.ca/
The Conference Board of Canada
http://www.conferenceboard.ca/
The Canadian Chamber of Commerce
C.D. Howe Institute
CPI Inflation Calculator (U.S. Bureau of Labor Statistics)
http://www.bls.gov/data/inflation_calculator.htm
Talking Biz News (Information about business journalism, from the Carolina Business News Initiative)
http://weblogs.jomc.unc.edu/talkingbiznews/
BMO Capital Markets
http://www.bmonesbittburns.com/Economics/
Business Blog (The Guardian)
http://www.guardian.co.uk/business/blog
Faser Institute
https://www.fraserinstitute.org/
Kevin Milligan (Vancouver School of Economics at the University of British Columbia)
https://blogs.ubc.ca/kevinmilligan/about-kevin-milligan/
The Laurier Institution
OECD
OECD Quarterly GDP
https://data.oecd.org/gdp/quarterly-gdp.htm#indicator-chart
RBC Economic Research
http://www.rbc.com/economics/index.html
Statistics Canada
http://www.statcan.gc.ca/start-debut-eng.html
EDUCATION
Statistics Canada (Salaries of full-time teaching staff at Canadian universities and colleges)
http://www.statcan.gc.ca/pub/81-595-m/2009073/tbl-eng.htm
Statistics Canada (Education Statistics Program)
http://www.statcan.gc.ca/edu/edu03_0001-eng.htm
Media Research Methods by Arizona State University
http://itunes.apple.com/WebObjects/MZStore.woa/wa/viewiTunesUCollection?id=387507218
An Open Letter to America’s University Presidents (Knight Foundation)
http://www.knightfoundation.org/press-room/other/open-letter-americas-university-presidents/
Mercer, GPB and Telegraph form novel partnership
http://www.macon.com/2011/12/15/1824961/mercer-gpb-and-telegraph-form.html#storylink=misearch
ECONOMISTS(Top)
Tammy Schirle (Associate Professor of Economics at Wilfrid Laurier University)
Lindsay Tedds (Associate Professor in the School of Public Administration at the University of Victoria)
Mikal Skuterud (Associate Professor in the Economics Department at the University of Waterloo)
http://arts.uwaterloo.ca/~skuterud/Mikal_Skuterud/Welcome.html
The School of Public Police (University of Calgary)
http://www.policyschool.ucalgary.ca/
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/compilations/parliament/WomenRepresentation.aspx
History of Federal Ridings since 1867
http://www2.parl.gc.ca/Sites/LOP/HFER/HFER.asp
Pundits’ Guide to Canadian Federal Elections
http://punditsguide.ca/index.php
Alberta
http://efpublic.elections.ab.ca/
Political donations in Alberta – 2004 to 2010 (Edmonton Journal)
http://www.edmontonjournal.com/news/donations/database.html
http://www2.canada.com/edmontonjournal/news/story.html?id=a4ddf170-bd63-4ff0-b7d9-9ae55199e92c&p=2
http://www.edmontonjournal.com/news/donations/top_donors.html
Manitoba
http://www.elections.mb.ca/main/home_1.htm
Elections Ontario
http://www.elections.on.ca/en-CA/Tools/FinancialStatementsandContributions/RealTimeDisclosure.htm
Quebec political contributions
Nova Scotia
http://electionsnovascotia.ns.ca/politicalcontributions.asp
Nova Scotia (electorial district boundaries)
http://electionsnovascotia.ca/geoginfo.asp
Political Contributions Regime Annual Report (Nova Scotia)
http://contrarian.ca/wp-content/uploads/CEO/NS%20Political%20Donations%202010-open%20format.pdf
ENVIRONMENT(Top)
Canada’s Greenhouse Gas Inventory ( Environment Canada )
http://www.ec.gc.ca/pdb/ghg/onlinedata/DataAndReports_e.cfm
Canadian Environmental Assessment Registry
http://www.ceaa-acee.gc.ca/050/index_e.cfm
Canadian Environmental Protection Act and Fisheries Act (prosecutions)
http://www.ec.gc.ca/ele-ale/prosecutions/prosecutions_e.asp
DeSmog Canada
Federal Contaminated Sites Inventory
http://www.tbs-sct.gc.ca/fcsi-rscf/home-accueil.aspx?Language=EN&sid=wu825155318360
Federal Contaminated Sites Inventory (Find Sites by Classification)
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx
Future Asset Restoration Liability (Treasury Board)
http://www.tbs-sct.gc.ca/pol/doc-eng.aspx?section=text&id=20885
Managing Contaminated Sites (Environment Canada)
http://www.ec.gc.ca/pollution/default.asp?lang=En&n=D0F5D8DC-1
Who to Call in an Emergency
http://www.ec.gc.ca/ee-ue/default.asp?lang=En&n=EED2E58C-
Table of Inactive Lighthouses Declared Surplus (Fisheries and Oceans Canada)
http://www.dfo-mpo.gc.ca/media/infocus-alaune/2010/02/lighthouse-phare-inactive-eng.htm
Table of Active Lighthouses Declared Surplus (Fisheries and Oceans Canada)
http://www.dfo-mpo.gc.ca/media/infocus-alaune/2010/02/lighthouse-phare-active-eng.htm
Northern Contaminated Sites Program (Aboriginal Affairs and Northern Development Canada
http://www.ainc-inac.gc.ca/eng/1100100035301
Contaminated Site Registry (PEI)
http://www.gov.pe.ca/Contaminated_sites/
Environmental Communication Options’ Media Releases
http://huffstrategy.com/MediaManager/all_releases.html
U.S. Environmental Protection Agency (Exposure Research – databases)
http://www.epa.gov/nerl/topics/databases.html
Keystone XL Pipeline stories (The New York Times)
Imperial Oil’s role in museum’s energy exhibit questioned: Foundation contributed $600,000 over 6 years to exhibit (CBC News)
DesmogCanada
International Energy Agency
ETHNIC NEWSPAPERS(Top)
The Link (Leading Indo-Canadian Newspaper)
EVALUATING WEB PAGES(Top)
We will place a lot of emphasis on ensuring that the website you use when researching a story is trustworthy. In order to determine credibility, it’s necessary to have a checklist of key criteria that the site must meet. Here are some sites that will help reinforce and add to what you’ve already learned: http://www.library.ubc.ca/home/evaluating/;http://www.lib.vt.edu/help/instruct/evaluate/evalbiblio.html; http://www.virtualsalt.com/evalu8it.htm; http://www.library.cornell.edu/olinuris/ref/webcrit.html; http://members.optusnet.com.au/~slamble/links.htm#VERIFYING%20ONLINE%20INFORMATION.What also helps is to know who is behind the Web page in question. The following links will help you determine who set up the commercial site that has attracted your interest: http://whois.cira.ca/public (For Canadian websites); http://www.alexa.com/ (deals with domains from all countries, and analyzes the website’s reach; that is, the number and identity of visitors to the page) http://www.domaintools.com/ and http://www.geektools.com/ andhttp://www.betterwhois.com/ and http://www.register.com/ , http://www.networksolutions.com/en US/whois/index.jhtml, http://www.domaintools.com/ and http://www.norid.no/domenenavnbaser/domreg.html and http://www.nominet.org.uk/ for “UK” domain names. When plugging in the website you’re researching, be sure to exclude the “www.” The first site on the list, “geektools,” contains the easiest interface of the three. The choice is yours.
FEDERAL GOVERNMENT(Top)
Canada News Centre
Open Data Pilot Project
http://www.data.gc.ca/default.asp?lang=En
http://news.gc.ca/web/article-eng.do?nid=638049
Public Opinion Research Reports
http://www.porr-rrop.gc.ca/index-e.html
Public Opinion Research Reports
http://amicus.collectionscanada.ca/porr-rrop-bin/Main/BasicSearch?coll=28&l=0&v=1
Visible Government (government transparency in Canada)
Government-Wide Reporting (Treasury Board’s listing of proactive disclosures by department)
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
Openparliament.ca
http://openparliament.ca/about/
Government of Canada official website
http://canada.gc.ca/main_e.html
All Websites Administered by the Government of Canada
http://www.google.com/cse/home?cx=001420363236126974246:mu2eiq-tbzw&hl=en
Years of Service in Parliament
Governor in Council Appointments
http://www.appointments-nominations.gc.ca/index.asp?lang=eng&Page=index
Orders in Council Appointments
http://www.pco-bcp.gc.ca/oic-ddc.asp?lang=eng&Page=secretariats
Orders in Council Glossary
http://www.pco-bcp.gc.ca/index.asp?lang=eng&page=secretariats&sub=oic-ddc&doc=gloss-eng.htm
Federal government departments
http://canada.gc.ca/depts/major/depind-eng.html
Federal government search engines
How Did They Vote
Canada Gazette
Federal government selected disclosure of travel and hospitality expenses and contracts
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index_e.asp
Federal government phone book
http://sage-geds.tpsgc-pwgsc.gc.ca/cgi-bin/direct500/eng/TE?FN=index.htm
Mandate letters, please click here to open in a new browser
Polling (click on the “continue to the document” link to get to the departmental polls)
http://epe.lac-bac.gc.ca/100/200/301/pwgsc-tpsgc/por-ef/index.html
Public Opinion Research Reports
http://www.porr-rrop.gc.ca/index-e.html
Federal bugets
http://www.fin.gc.ca/access/budinfo-eng.asp
Reviews, Audits and Evaluations
http://www.tbs-sct.gc.ca/rma/database/aeve_e.asp
http://www.tbs-sct.gc.ca/rpp/2009-2010/info/ia-vi-eng.asp
Tools and Resources for Parliamentarians (Treasury Board gate to reports including Departmental Quarterly Financial Reports)
http://www.tbs-sct.gc.ca/tbs-sct/audience-auditoire/parliamentarian-parlementaire-eng.asp
The Fiscal Monitor 2008 (the Finance department)
http://www.fin.gc.ca/pub/fm-rf-index-eng.asp
Auditor General of Canada
http://www.oag-bvg.gc.ca/internet/English/admin_e_41.html
Proactive Disclosure
http://www.tbs-sct.gc.ca/pd-dp/index_e.asp
http://github.com/nurey/disclosed/tree/2b91216860fdc85b1231a28aa05a907c43f5b9be/data
Travel and Hospitality Expenses Reports (Government of Canada: Privy Council Office)
http://www.pco-bcp.gc.ca/di/category_list.asp?id=1&Language=E
Public Office Holders Search (Office of the Ethics Commissioner)
http://www.parl.gc.ca/oec/PublicSearch/PublicSearch.aspx
Plans and Priorities / Performance Reports
http://www.tbs-sct.gc.ca/est-pre/estime.asp#OSD
Public Accounts (Government-wide)
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
FEDERAL POLITICS(Top)
Members’ Expenditures Report
http://www.parl.gc.ca/PublicDisclosure/MemberExpenditures.aspx?Id=MER2013FY&Language=E
The Federal Cabinet
http://www.pm.gc.ca/eng/cabinet.asp
Minotaur (website monitors the federal government telephone directory for changes in staff listings in ministerial offices)
http://lobbywatcher.ca/minotaur/minotaur.php
Committees
http://www.parl.gc.ca/common/committee.asp?Language=E&Parl=38&Ses=1
Conservative Research Bureau
NDP Research Bureau
Members of Parliament
http://webinfo.parl.gc.ca/membersofparliament/MainMPsCompleteList.aspx?TimePeriod=Current&Language=E
Liberal critics
NDP critics
http://www.ndp.ca/shadow-cabinet
Parliamentary Secretaries
http://pm.gc.ca/eng/feature.asp?pageId=39&featureId=8
Cabinet ministers
http://pm.gc.ca/eng/cabinet.asp?featureId=8&pageId=38
Senators
http://www.parl.gc.ca/common/senmemb/senate/isenator.asp?Language=E
Parliament
http://www.parl.gc.ca/common/index.asp?Language=E&Parl=37&Ses=2
Parliamentary publications
http://www.parl.gc.ca/About/House/compendium/web-content/c_g_parliamentarypublications-e.htm#3
openparliament.ca
House Government Bills ( Parliament )
http://www2.parl.gc.ca/HouseBills/BillsGovernment.aspx?Language=E&Mode=1&Parl=40&Ses=3
Parliamentary Committees
http://www2.parl.gc.ca/CommitteeBusiness/CommitteeList.aspx?Language=E&Mode=1&Parl=40&Ses=3
House of Commons Procedure and Practice
Order Paper questions
http://www.parl.gc.ca/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)
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)
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)
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)
House of Commons List of Reports and Returns brings (this is a generic description of documents that ministers are obliged to table in the House)
http://www.parl.gc.ca/40/2/parlbus/chambus/house/reports/02-toc-e.htm
Debates (Hansard)
Hansard
Current and Emerging Issues (Library of Parliament)
http://www.parl.gc.ca/Content/LOP/ResearchPublications/cei-foreword-e.htm
History of electoral ridings
Women in the House of Commons
Women in the Senate
Women in Parliament (Parliamentary Information and Research Service, Library of Parliament)
http://www2.parl.gc.ca/content/lop/researchpublications/prb0562-e.htm
Women candidates in federal elections since 1921
http://www2.parl.gc.ca/Sites/LOP/HFER/hfer.asp?Language=E&Search=WomenElection
PoliTwitter (Track what federal politicians are saying on social media)
Votes in the House of Commons
http://www.parl.gc.ca/housechamberbusiness/ChamberVoteList.aspx?Language=E
FEDERAL PUBLIC SERVICE(Top)
Canada School of Public Service
http://www.csps-efpc.gc.ca/index-eng.asp
Chief Human Resources Officer
http://www.tbs-sct.gc.ca/chro-dprh/index-eng.asp
Public Servants Disclosure Protection Tribunal
http://www.psdpt-tpfd.gc.ca/Information/WrongdoingsReprisals-eng.html
FAIR ( Federal Accountability Initiative for Reform)
Public service absenteeism jumps by 40%; ‘Alarming’ spike over past decade draws ire, sympathy from experts
(The Ottawa Citizen)
Please read the story by clicking here
Federal workers lead pack in rising absenteeism (The Ottawa Citizen)
Please read the story by clicking here.
Ethics boss found morale mess in office (The Ottawa Citizen)
Pleae read the story by clicking here.
Minotaur (website monitors the federal government telephone directory for changes in staff listings in ministerial offices)
http://lobbywatcher.ca/minotaur/minotaur.php
FEDERAL SPENDING(Top)
Parliamentary Budget Officer federal spending watch
http://pbo-dpb.gc.ca/en/imd/index/#view_departments
Parliamentary Budget Officer’s Integrated Monitoring Database that tracks public money
http://www.pbo-dpb.gc.ca/en/imd/index/#search-department_outcomes
Transfer payments to provinces ( Department of finance)
http://www.fin.gc.ca/fedprov/mtp-eng.asp#Ontario
FOOD SAFETY(Top)
Ottawa restaurant inspections
Food Recall Report (Downloadable food recalls from the Canadian Food Inspection Agency)
http://active.inspection.gc.ca/eng/corp/recarapp_dbe.asp
Health Safety Watch (real-time health and safety information)
http://www.healthandsafetywatch.com/Dashboard.aspx?AspxAutoDetectCookieSupport=1
Food Recalls and Allergy Alerts
http://www.inspection.gc.ca/english/corpaffr/recarapp/recaltoce.shtml
Audits, Reviews and Evaluations – Executive Summaries (The Canadian Food Inspection Agency)
http://www.inspection.gc.ca/english/agen/eval/evale.shtml
Audio Clips for Food Recalls and Allergy Alerts (The Canadian Food Inspection Agency)
http://www.inspection.gc.ca/english/corpaffr/relations/audio/recarappaude.shtml
Food Safety Assessment Reports (Health Canada)
http://www.hc-sc.gc.ca/fn-an/securit/eval/reports-rapports/index-eng.php
Reports on the Canadian Food Inspection Agency (By the Auditor General of Canada)
http://www.oag-bvg.gc.ca/internet/English/parl_lpf_e_1228.html
CBC-Toronto Star food-safety investigation
http://www.cbc.ca/consumer/story/2008/09/23/f-cfia.html
http://www.cbc.ca/consumer/story/2008/10/05/listeria-inspections.html
http://www.cbc.ca/consumer/story/2008/10/09/listeria-tests.html
http://www.cbc.ca/health/story/2008/10/09/mccain.html
http://www.cbc.ca/canada/story/2008/10/21/lawsuit-mapleleaf.html
http://www.cbc.ca/consumer/story/2008/10/27/listeria-nursinghome.html?ref=rss
http://www.cbc.ca/canada/story/2008/11/06/listeria-regulations.html?ref=rss
http://www.cbc.ca/consumer/story/2008/11/07/mccain-memos.html
http://www.cbc.ca/consumer/story/2008/12/19/listeria-cfia.html
http://www.cbc.ca/canada/story/2009/01/20/listeriosis-investigator.html?ref=rss
http://www.cbc.ca/canada/story/2009/01/23/listeria-investigation.html?ref=rss
http://www.cbc.ca/canada/story/2009/02/05/poultryvets-cfia.html?ref=rss
http://www.cbc.ca/canada/story/2009/03/25/listeria-cfia.html
http://www.cbc.ca/consumer/story/2009/04/21/listeriosis-probe-cfia021.html?ref=rss
http://www.cbc.ca/canada/story/2009/04/23/listeriosis-probe.html?ref=rss
http://www.cbc.ca/canada/story/2009/04/30/listeria-cfia-reports043009.html?ref=rss
http://www.cbc.ca/canada/story/2009/06/10/listeria-inspectors-maple-leaf.html?ref=rss
Food safety at risk with budget cuts expected, union says (CBC News)
http://www.cbc.ca/news/politics/story/2012/01/16/pol-food-safety-inspection-funding.html
Federal food safety surveillance program stalled (CBC News)
http://www.cbc.ca/news/politics/story/2012/02/03/pol-mckie-thehouse-disease-centres.html
Listeriosis victims receive reduced compensation (CBC News)
http://www.cbc.ca/news/politics/story/2012/02/04/pol-listeriosis-victims-receive-compensation.html
XL Foods warned 6 times over lapses before E. coli outbreak (CBC News)
Correction Action Requests issued at Alberta plant for sanitation, contamination
http://www.cbc.ca/news/politics/story/2013/01/08/pol-cfia-xl-foods-atip-corrective-action.html
U.S. worries about Canadian meat flagged in memo (CBC News)
Coalition wants plug pulled on meat pre-clearance pilot project in wake of XL Foods recall
BC investigation into faulty juice boxes
http://www.cbc.ca/consumer/story/2008/11/19/iunit-drinkboxes.html
Nova Scotia Food Establishment Inspection Reports
http://www.gov.ns.ca/agri/foodsafety/reports/Request.aspx
Newfoundland &Labrador Inspection Reports
http://www.servicenl.gov.nl.ca/inspections/index.html
The National Agricultural Library (the U.S. Department of Agriculture)
Gateway to Government Food Safety Information (U.S.)
http://www.foodsafety.gov/~fsg/fsgprobs.html
The Food Safety and Inspection Service (the public health agency in the U.S. Department of Agriculture)
Search for Peanut Butter Product Recalls (The U.S. Food and Drug Administration)
http://www.accessdata.fda.gov/scripts/peanutbutterrecall/index.cfm
Foreign Audit Reports (the USDA’s Food Safety and Inspection Service)
http://www.fsis.usda.gov/regulations_&_policies/Foreign_Audit_Reports/index.asp
http://www.fsis.usda.gov/regulations_&_policies/Foreign_Audit_Reports_Past/index.asp
United States Departrment of Agriculture Food Safety Inspection Service
http://www.fsis.usda.gov/FSIS_Recalls/Open_Federal_Cases/index.asp
Canadian food companies cerfitifed to export to the United States
Food safety reports from Thomas Hargrove of the Scripps Howard Service
ftp://shnsclients.scripps.com/data/FatalFood/
Centers for Disease Control and Prevention_ cached Outbreak Surveillance Data (Department of Health and Human Services)
http://74.125.95.132/search?q=cache:http://www.cdc.gov/foodborneoutbreaks/outbreak_data.htm
The Traceability Institute
http://www.traceability-institute.com/
Eat Safe ( the city of Ottawa’s website for restaurant inspections)
http://www.ottawa.ca/cgi-bin/search/inspections/q.pl?ss=home_en&qt=fsi_en
Food Safety News
http://www.foodsafetynews.com/
GlobalMeatnews.com
http://www.globalmeatnews.com/
BarfBlog (safe food from farm to fork)
http://barfblog.foodsafety.ksu.edu/barfblog
News for Shoppers
http://www.newsforshoppers.com/
People’s Food Policy Project
http://www.peoplesfoodpolicy.ca/
Caffeine Content of Drinks (A complete guide to caffeine)
http://www.energyfiend.com/the-caffeine-database
Bites and barflog (safe food from farm to fork)
dicentra
The Poultry Site
http://www.thepoultrysite.com/
PerishableNews.com
http://www.perishablenews.com/
fishnews.com
Current World Production, Markets, and Trade Reports (United States Department of Agriculture)
http://www.fas.usda.gov/report.asp
FOREIGN AFFAIRS(Top)
Canada’s International Gateway
http://www.canadainternational.gc.ca/ci-ci/index.aspx?lang=eng
Canada’s bilateral relations with countries around the world (Canada’s International Gateway)
http://www.international.gc.ca/cip-pic/geo.aspx?view=d
FUSION TABLES(Top)
Google Fusion Tables
Googe Fusion Tables discussion group
https://groups.google.com/forum/#!topic/fusion-tables-users-group/4SVxAew5P78
Google Fusion Table (shape file to KML conversion)
Google fusion tables beta (data sets you can use)
https://www.google.com/fusiontables/search
FusionTablesLayer Builder
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)
Fusion Table Icon Markers
https://www.google.com/fusiontables/data?docid=1BDnT5U1Spyaes0Nj3DXciJKa_tuu7CzNRXWdVA#map:id=3
A map to help voters find their polling places using Fusion Tables as a data source (Google fusion tables)
Shape to Fusion ( A website that allow users to import shape files into fusion tables)
GOVERNMENT SPENDING(Top)
Advertising Annual Reports (Public Works and Government Services Canada)
http://www.tpsgc-pwgsc.gc.ca/pub-adv/annuel-annual-eng.html
Budget 2009: Canada’s Economic Action Plan
http://www.fin.gc.ca/n08/09-011-eng.asp
http://www.actionplan.gc.ca/eng/index.asp
Transactions under the Troubled Asset Relief Program (TARP)
http://subsidyscope.com/projects/bailout/tarp/
Many Eyes (a website that helps visualize U.S. government spending)
http://manyeyes.alphaworks.ibm.com/manyeyes/
Economic Stimulus: Transportation Infrastructure Projects by County (Associated Press)
http://hosted.ap.org/dynamic/files/specials/interactives/wdc/stimulus_counties/index.html?SITE=NYPLA
Canada’s Economic Action Plan
http://www.actionplan.gc.ca/eng/index.asp
Economic Stimulus: Distressed bridges often overlooked for repairs ( American Press)
http://hosted.ap.org/specials/interactives/wdc/stimulus_bridges/index.html?SITE=AP
ProPublica’s FAQ for Recovery.gov
http://www.propublica.org/ion/stimulus/item/propublicas-faq-for-recovery.gov-1109
Recovery.org (the official U.S. government website that tracks stimulus spending)
http://www.recovery.gov/Pages/home.aspx
HEALTH(Top)
Chronic Disease Infobase (the Public Health Agency of Canada)
http://204.187.39.30/surveillance/Index.aspx?L=eng
Canadian Patient Safety Institute
http://www.patientsafetyinstitute.ca/English/Pages/default.aspx
FluWatch (The Public Health Agency of Canada’s national surveillance system that monitors the spread of flu and flu-like illnesses)
http://www.phac-aspc.gc.ca/fluwatch/index-eng.php
Deaths Associated with H1N1 flu virus in Canada
http://www.phac-aspc.gc.ca/alert-alerte/h1n1/surveillance-eng.php
Canadian Institute for Health Information (statistics)
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=reqdata_e
Statistics Canada (deaths from infectious diseases)
Statistics Canada (abortion rates)
http://www.statcan.gc.ca/pub/82-223-x/2008000/5202136-eng.htm
http://www.statcan.gc.ca/pub/82-223-x/2008000/5202008-eng.htm
http://www.statcan.gc.ca/pub/82-223-x/2008000/5202017-eng.htm
Food recalls (Health Canada and the Public Health Agency of Canada)
http://www.healthycanadians.gc.ca/pr-rp/index_e.php
Food recall archives (The Canadian Food Inspection Agency)
http://www.inspection.gc.ca/english/corpaffr/recarapp/recal2e.shtml
Medication Guides ( the U.S. Food and Drug Administration )
http://www.fda.gov/cder/Offices/ODS/medication_guides.htm
MedlinePlus
http://www.nlm.nih.gov/medlineplus/druginformation.html
E-CPS (Canadian Pharmacists Association)
https://www.e-therapeutics.ca/wps/portal/!ut/p/.scr/Login
Psychotropics
http://www.psychotropics.dk/monographies/index.asp?Catalogtype=A
Pharmalot
PharmaWatch Canaada
http://pharmawatchcanada.wordpress.com/
Consumer Reports Best Buy Drugs
http://www.crbestbuydrugs.org/
Consumer Reports Health.org
http://www.consumerreports.org/health/home.htm
Therapeutic Goods Administration (Australian Adverse Drug Reactions Bulletin)
http://www.tga.gov.au/adr/aadrb.htm
Science Daily
Canadian Centre for Occupational Health and Safety
Association of Workers’ Compensation Boards of Canada
http://www.awcbc.org/en/index.asp
Health Canada
http://www.hc-sc.gc.ca/index_e.html
Health Canada (Dear Health Care Professional Letters and public advisories)
http://www.hc-sc.gc.ca/ahc-asc/media/advisories-avis/_2007/index_e.html
Health Canada, drug and medical device recalls
http://www.hc-sc.gc.ca/dhp-mps/compli-conform/recall-retrait/_list/index-eng.php
Health Canada Advisories, Warnings and Recalls by Subject
http://www.hc-sc.gc.ca/ahc-asc/media/advisories-avis/alpha_e.html
Health Canada, Consumer Product Safety Recalls
http://209.217.71.106/PR/home-accueil-e.jsp
Index of Published Canadian Adverse Reaction Newsletters
http://www.hc-sc.gc.ca/dhp-mps/medeff/bulletin/carn-bcei_index_e.html
Health Canada’s Adverse Drug Reaction Database
http://webprod3.hc-sc.gc.ca/arquery-rechercheei/index-eng.jsp
Health Canada list of expert advisory committees
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/activit/sci-consult/index_e.html
Notice of compliance ( drugs Health Canada has approved )\
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/notices-avis/index_e.html
http://webprod5.hc-sc.gc.ca/noc-ac/index-eng.jsp
http://data.gc.ca/data/en/dataset/9cbaef00-b52c-4a70-9fed-d9aa8263ab74
http://data.gc.ca/data/en/dataset/52bb749a-4006-4253-a4a5-63e51d2f880f
http://data.gc.ca/data/en/dataset/fa5ad2aa-ab59-4421-8491-4c004d94d0bc
Drug Products Database ( all of the drugs Health Canada has approved for marketing)
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/databasdon/dpd_bdpp_data_extract_e.html
Food and Drug Administration advisory committees
http://www.fda.gov/ohrms/dockets/ac/acwhatsnew.htm
FDA advisory committees (search)
http://www.fda.gov/ohrms/dockets/default.htm
Vaccine Adverse Event Reporting System (The U.S. Food and Drug Administration)
http://vaers.hhs.gov/data/data/
BlackBoxRX.com
http://blackboxrx.com/index.php
Controversial drug marketing
http://www.cbc.ca/disclosure/archives/0103_pharm/resources.html
Recently approved medical devices ( FDA )
http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfTopic/MDA/mda-list.cfm?list=1
HealthImaging.com
http://www.healthimaging.com/index.php?option=com_articles&division=hiit
Health Space (contains online inspection information for provinces such as B.C.)
http://www.healthspace.ca/Websites/HealthSpace/Website_CA.nsf/index.html
Patient Safety (Ontario Ministry of Health and Long Term Care)
http://www.health.gov.on.ca/patient_safety/index.html
Health Inspection Orders (Alberta Health Services)
RateMDs.com
Patient Drug News
http://www.patientdrugnews.com/about-patient-drug-news/
HEALTH (PROVINCIAL)(TOP)
Nova Scotia Prescription Monitoring Program
HEALTH (INTERNATIONAL)(TOP)
International Society For Infectious Diseases
Centers for Disease Control and Prevention
HEALTH POLICY (Top)
CONSULTATION ON LEGISLATIVE OPTIONS FOR ASSISTED DYING
http://ep-ce.ca/en/faqs/#q1
Healthy Debate (Healthydebate.ca is led by a core team of physicians, policy advisors and researchers based at the Li Ka Shing Knowledge Institute of St. Michael’s Hospital in Toronto)
HealthNewsReview.org
http://www.healthnewsreview.org/
EvidenceNetwork.ca (Non-partisan health policy experts and evidence)
http://www.evidencenetwork.ca/
Cutting Edge Information
http://www.cuttingedgeinfo.com/
HOUSING(Top)
Housing Again (a site dedicated to putting affordable housing back on the public agenda)
http://housingagain.web.ca/index.html
Canada Mortgage and Housing Corporation, average rents for areas with a population of 10,000 and over (Statistics Canada)
Forecasts and Analysis (Canada Mortgage and Housing Corporation)
http://www.cmhc-schl.gc.ca/en/hoficlincl/homain/foan/index.cfm
Housing Market Information (Canada Mortgage and Housing Corporation)
http://www.cmhc.ca/housingmarketinformation/
IMMIGRATION(Top)
Canadian Immigration Statistics (Canada Immigrant Job Issues)
http://www.canadaimmigrants.com/statistics.asp
Canadian Immigration Stats (for Canada and all regions from the 2001 and 2006 censuses)
Recent immigrants in metropolitan areas (Citizenship and Immigration Canada)
http://www.cic.gc.ca/english/resources/statistics/facts2008/index.asp
2006-09 Refugee Claim Data & IRB Member Grant Rates (Compiled by Sean Rehaag, Assistant Professor Osgoode Hall Law School York University)
http://www.ccrweb.ca/documents/rehaagdatamarch10.htm
2010 Refugee Claim Data and IRB Member Grant Rates
http://ccrweb.ca/en/2010-refugee-claim-data
2011 Refugee Claim Data and IRB Member Grant Rates
http://ccrweb.ca/en/2011-refugee-claim-data
2012 Refugee Claim Data and IRB Member Grant Rates
http://ccrweb.ca/en/2012-refugee-claim-data
2013 Refugee Claim Data and IRB Member Grant Rates
https://ccrweb.ca/en/2013-refugee-claim-data
2014 Refugee Claim Data and IRB Member Recognition Rates
http://ccrweb.ca/en/2014-refugee-claim-data
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
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
GoToMeeting
https://www1.gotomeeting.com/join/894058849
TeamViewer
http://www.teamviewer.com/en/index.aspx
Docudesk (converts pdfs to spreadsheets for PCs and Macs)
http://www.docudesk.com/index.shtml
ScraperWiki
Free PDF Text Reader 1.1
Chapter 3: Turning PDFs to Text (ProPublica)
http://www.propublica.org/nerds/item/turning-pdfs-to-text-doc-dollars-guide
Nitro PDF Professional
Guaranteed PDF Decrypter
PDFUnlock
PDFPirate
ABBYY FineReader
Awsome Screenshot (Capture the whole page or any portion, annotate it with rectangles, circles, arrows, lines and text…..)
https://chrome.google.com/extensions/detail/alelhddbbhepgpmgidjdcjakblofbmce?hl=en
Xpdf (An open source viewer for Portable Document Format (PDF) files)
http://www.foolabs.com/xpdf/home.html
PDFill PDF Editor 5.0
PDFCreator
http://sourceforge.net/projects/pdfcreator/
PDFtoExcel (online converter)
http://www.pdftoexcelonline.com/default.aspx
Zamzar (Free online file conversion)
Cometdocs( Free online file conversion)
Able2Extract (Standalone conversion to Excel, Word etc. Probably the best overall choice. Reliable and accurate results)
http://www.investintech.com/prod_a2e.htm
Cogniview
Irfanview (A Windows graphic viewer)
Yousendit
Googlenewstime
http://newstimeline.googlelabs.com/
Beta Office 1010
http://officebeta.microsoft.com/en-us
Docsplit (a command-line utility and Ruby library for splitting apart documents into their component parts)
http://documentcloud.github.com/docsplit/
Chrome Extensions
http://www.chromeextensions.org/music-videos-photos/youtube-downloader/
Plug in for Firefox MP3 converter
https://addons.mozilla.org/en-US/firefox/addon/youtube-to-mp3/
YouTube Video Downloader 1.5 (can download videos in FLVand MP4 formats)
http://www.youtubedownloaderhd.com/download.html
Audio Hijack Pro (audio recorder for Macs)
http://www.rogueamoeba.com/audiohijackpro/
NodeXL for Social Network Analysis
http://www.peteraldhous.com/CAR/Aldhous_CAR2011_NodeXL.pdf
Googe Motion
http://mail.google.com/mail/help/motion.html
ASAP Utilities (add-ins for Excel)
http://www.asap-utilities.com/
TimelineSetter: Easy Timelines From Spreadsheets, Now Open to All (Propublica)
http://www.propublica.org/nerds/item/timelinesetter-easy-timelines-from-spreadsheets-now-open-to-all
dtSearch (searches files on your desktop)
http://www.dtsearch.com/PLF_desktop_2.html
Online Dictionary (Translation, definition, synonyms, English, French, Spanish, etc)
http://dictionary.reverso.net/
Zoocasa (estimated Canadian home prices)
Regular-Expressions.info
http://www.regular-expressions.info/
Wordhippo.com
http://www.wordhippo.com/what-is/another-word-for/survey.html
Online-Stopwatch
http://www.online-stopwatch.com/
Measuring Worth
http://measuringworth.com/calculators/uscompare/
CAA Distracted Driving Simulator
http://distracteddriving.caa.ca/simulator/environment.php
INTERNET RESEARCH(Top)
ChangeDetecion.com
https://www.changedetection.com/index.html
People Search Pro (Julian Sher)
http://tips.peoplesearchpro.com/
Google News Timeline
http://newstimeline.googlelabs.com/
SearchSystems.net (Search Free Public Records in the United States)
http://publicrecords.searchsystems.net/
INTERVIEWING(Top)
TRANSCRIPT | Peter Mansbridge talks with Stephen Harper (CBC News)
http://www.cbc.ca/news/politics/story/2012/01/17/pol-mansbridge-interview-harper-transcript.html
To download Peter Mansbridge’s 2014 year-end interview with Prime Minister, Stephen Harper, please click here.
Stephen Harper’s 2014 year-end interview
Paul McLaughlin: Asking Questions The Art of the Media Interview
INVESTIGATIVE JOURNALISM WEBSITES(Top)
Open Channel
http://openchannel.msnbc.msn.com/
Neimanwatchdog
http://www.niemanwatchdog.org/index.cfm
http://www.niemanwatchdog.org/index.cfm?fuseaction=showcase.welcome
Center for Investigative Reporting to curate investigative reporting on new YouTube channel (Poynter)
Jesse Brown’s Canadaland
Rocky Mountain PBS iNews
Tarbell
http://tarbell.readthedocs.org/en/1.0/
https://github.com/tarbell-project
INVISIBLE WEB(Top)
Resource Shelf
BrightPlanet
Price’s List of Lists
http://www.specialissues.com/lol/
Complete Planet (The Deep Web Directory)
Invisible Web tutorial
http://www.lib.berkeley.edu/TeachingLib/Guides/Internet/InvisibleWeb.html
Search Engine Watch
Infomine
Repositories of Primary Resources ( The University of Idaho)
http://www.uiweb.uidaho.edu/special-collections/Other.Repositories.html
Directory of Open Access Journals (This service covers free, full text, quality controlled scientific and scholarly journals)
WorldCat (Finds items in libraries near you)
Academic Search Engines (JournalismNet)
http://www.peoplesearchpro.com/journalism/search/academic.htm
INTERACTIVE STORIES(Top)
A global guide to the first world war – interactive documentary (The Guardian)
JOURNALISTS’ BLOGS(TOP)
Andrea Woo
Allison Martell
Brittny Goodsell
http://brittnygoodsell.com/home.html
Brad Cabana
http://www.blogger.com/profile/08957343946915171802
Blacklock’s Reporter
David Eaves
David Pugliese Defence Watch
http://blogs.ottawacitizen.com/category/news/defence-watch/
Glen McGregor
http://blogs.ottawacitizen.com/author/glenmcgregor/
Paul Krugman
http://krugman.blogs.nytimes.com/
Heather Scoffield
http://www.blogscanada.ca/author/heather-scoffield-the-canadian-press/?feedsort=comment_count
Jen Skerritt
http://muckrack.com/jenskerritt
Katelyn Verstraten
http://katelynverstraten.com/
Kate Crawford: Thinking about data
Kim Bolan: The Real Scoop ( The Vancouver Sun)
http://blogs.vancouversun.com/category/staff/crime-and-justice/the-real-scoop/
Michelle Minkoff
http://michelleminkoff.com/teaching/
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)
Eric Newton (The Nieman Journalism Lab)
http://www.niemanlab.org/author/enewton/
Jay Rosen’s Press Think
http://pressthink.org/2013/02/look-youre-right-okay-but-youre-also-wrong/
Karen Kleiss (The Edmonton Journal)
http://blogs.edmontonjournal.com/author/ablegreporter/
Marion Warnica
Mark Coddington
Meg Wilcox
Nicole S. Cohen
Lisa Johnson (CBC Vancouver)
Lisa Roberts
http://lisaroberts.ca/?page_id=12
Melanie Coulson (The Ottawa Citizen)
Sam Wang (Princeton Election Consortium)
http://election.princeton.edu/
Nate Silver (FiveThirtyEight)
http://fivethirtyeight.blogs.nytimes.com/
Tamsin McMahon
http://www2.macleans.ca/author/tmcmahon/
Tara Carman
http://blogs.vancouversun.com/author/taracarman/
The Media Business (Robert G. Picard)
http://themediabusiness.blogspot.ca/
The Filter Buble (Eli Pariser and Peter Koechley)
http://www.thefilterbubble.com/
Taylor Owen
The Ottawa Citizen
http://www.ottawacitizen.com/opinion/blogs/index.html
The Bulldog (A blog by Ken Gray)
The Huffington Post
http://www.huffingtonpost.com/the-blog/
WSJ blogs
Ben Mook
Lauren Shepard (Newseum)
http://laurenshepherdwritingon.tumblr.com
Alexandra Posadzki
JOURNALISM EDUCATION(Top)
A Blueprint for How to Make J-School Matter (Again)
http://niemanreports.org/articles/a-blueprint-for-how-to-make-j-school-matter-again/
Carleton University (Office of Institutional Research and Planning
http://oirp.carleton.ca/newsite/
Carleton Library
https://blogs.library.carleton.ca/roller/themadgicalweb/
Columbia Journalism School
http://www.journalism.columbia.edu/home
Tow Center for Digital Journalism (Columbia Journalism School)
Reuters Institute for the Study of Journalism
http://reutersinstitute.politics.ox.ac.uk/
UBC Graduate School of Journalism
Philip Merrill College of Journalism
JOURNALISM JOBS SITES(TOP)
Code out loud
NewsAppsJobs
https://twitter.com/newsapps_jobs
Google Journalism Fellowship
http://www.google.com/get/journalismfellowship/
JOURNALISM RESEARCH(TOP)
Journalist’s Resource (Harvard Kennedy School, Joan Shorenstein Center)
http://journalistsresource.org/
Newspapers Turning Ideas into Dollars (Pew Research Center’s Project for Excellence in Journalism)
http://www.journalism.org/analysis_report/newspapers_turning_ideas_dollars
Thinking about the Future of Informed Communities and Journalism
Survey Research, Its New Frontiers and Democracy (Pew Research Center)
http://www.pewresearch.org/2012/05/24/survey-research-its-new-frontiers-and-democracy/
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
Society of Profesional Journalists eCampus
https://www.spj.org/trainingondemand.asp
JEFF SONDERMAN
JOURNALISM RESOURCE SITES(TOP)
The Tow Center for Digital Journalism
http://newsle.com/article/0/135646330/
CNet (a well-respected technology website)
The Canadian Journalism Project
The Canadian Association of Journalists
Canadian Journalists for Free Expression
The Center for Investigative Reporting
http://centerforinvestigativereporting.org/
The Center for News Literacy at Stony Brook University’s School of Journalism
http://www.stonybrook.edu/journalism/newsliteracy/index.html
Journalist’s Toolbox
http://www.journaliststoolbox.org/
PowerReportering (resource for journalists)
http://www.powerreporting.com/category/Alerts_for_journalists
Committee to Protect Journalists (Defending Journalists Worldwide)
ChangeDetection.com
http://www.changedetection.com/
blinkx
Online Education Database
http://oedb.org/library/college-basics/research-beyond-google
Investigative Reporters and Editors
Investigative Reporters and Editors (IRE)Quick Hits
http://www.ire.org/quickhits/08_June27.html#b1
Investigate This! With Alex Roslin
http://albloggedup.blogspot.com/
Institute for Justice and Journalism
http://justicejournalism.org/curriculum/data-animation-webinar-part-1/
IRE story search
http://www.ire.org/resourcecenter/search.php
How Stuff Works
Media magazine
Logan Symposium
http://investigativereportingprogram.com/logan-symposium/
The scoop (A blog maintained by computer-assisted reporting specialist Derek Willis)
FINAL REPORT ON THE CANADIAN NEWS MEDIA (Standing Senate Committee on Transport and Communications)
ProPublica: Journalism in the Public Interest
The Investigative Reporting Workshop (a project of the School of Communication at American University)
http://investigativereportingworkshop.org/
The Toronto Star in-depth stories
http://www.thestar.com/investigations
Enquete ( Radio-Canada’s investigative program)
http://www.radio-canada.ca/emissions/enquete/2008-2009/
Daylife
http://www.daylife.com/topstories
Chicago Tribune
http://www.chicagotribune.com/news/specials/
The Cable Public Affairs Channel (CPAC)
http://www.cpac.ca/forms/index.asp?dsp=template&act=view3&template_id=46&lang=e
Cultural Diversity and Ethnic Media in BC. (a report of Simon Fraser University’s Centre for Policy Studies on Culture and Communities)
http://www.bcethnicmedia.ca/research.html
The Canadian Military in the news
http://www.cfc.forces.gc.ca/spotnews_e.html
Online News Association
Adrian Holovaty (web developer and Chicago-based journalist)
Online Journalism Review
NowPublic (crowd powered media)
Orato ( True stories from real people)
International Consortium of Investigative Journalists
http://www.publicintegrity.org/icij/
International Journalists’ Network
JNet’s Picks of the Week (a random selection of websites of use to journalists)
http://www.journalismnet.com/picks
Radio-Canada (archives)
http://www.radio-canada.ca/actualite/v2/tj22h/archive50_200408.shtml
Kirk LaPointe’s J-home
Infomart
Canada.com
The Canadian Press
http://www.thecanadianpress.com/default.aspx
http://www.cpimages.com/fotoweb/index.fwx
National Post photos
http://news.nationalpost.com/category/photos/
The Hill Times
http://www.hilltimes.com/information_pages/about.php
iPolitics
World news
Association for Education in Journalism and Mass Communication
Independent media
Independent Media TV
http://www.independent-media.tv/about.cfm
DiversityWatch
http://www.diversitywatch.ryerson.ca/media/
ABYZ News Links
Newspaper archives
http://www.newspaperarchive.com/
AllYouCanRead
Sept.11 Archives
http://www.september11archive.com/
Canadian Community Newspapers Association (CCNA)
Community Press Online (Ontario)
http://www.communitypress-online.com
Online Newspapers
http://www.onlinenewspapers.com/
Google News Advanced Archive Search
http://news.google.com/archivesearch/advanced_search
LexisNexis AlaCarte! (advanced search)
http://alacarte.lexisnexis.com/partners/int/lexisnews/srchNW.asp
LexisNexis AlaCarte! (free short-term news searches on hot stories)
http://www.lexisnexis.com/news/
Hospital News
Medical Doctor (a Canadian website that tracks medical coverage)
Columbia Journalism Review
The Complete New Yorker: Eighty Years of the Nation’s Greatest Magazine
http://www.amazon.ca/exec/obidos/ASIN/1400064740/ref=pd_bxgy_text_2/702-6007597-6128034
Counterpunch (left-wing American political newsletter)
Cyberjournalist.net ( The Online News Association )
http://www.cyberjournalist.net/supersearch.php/
Expert sources — ProfNet
http://www2.profnet.com/login_prn.jsp
Carleton’s journalism in Rwanda effort
http://www.rwandainitiative.ca/index2.html
Snopes.com (Rumour Has It)
Regret The Error ( it reports on corrections, retractions, clarifications and trends regarding accuracy and honesty in the media)
http://www.regrettheerror.com/
Wikileaks
http://www.wikileaks.org/index.html
OhmyNews International
Canadian Association of Internet Providers
Public Eye Online
http://www.publiceyeonline.com/
Public Editor ( The site of the New York Times public editor )
http://topics.nytimes.com/top/opinion/thepubliceditor/index.html
Project for Excellence In Journalism (The State of the News Media 2008)
http://www.stateofthenewsmedia.org/2008/
Legacy.com (obituary searches)
American Press Institute
http://www.americanpressinstitute.org/
Inside the Queensway: Maclean’s blogger Kady O’Malley
http://blog.macleans.ca/2009/02/19/liveblogging-the-layover-of-the-century/
Jacqui Banaszynski tips on finding stories
Famous quotes & quotations
http://www.famous-quotes-and-quotations.com/
The Future of Journalism
http://www.ourblook.com/component/option,com_sectionex/Itemid,200076/id,8/view,category/#catid69
Investigative Reporting Workshop (The American University)
http://investigativereportingworkshop.org/staff/openings/
“American Radical: The Life and Times of I.F. Stone” (DemocracyNow)
http://www.democracynow.org/2009/6/18/american_radical_the_life_and_times
Alternate News Sources
http://www.peoplesearchpro.com/journalism/alternate/
Narrative Matters (A peer-reviewed, personal-essay section of the policy journal Health Affairs)
http://www.healthaffairs.org/NM.php
VND (Algonquin College’s Virtual News Desk)
Scribd.com
Marion Warnica
The New York Review of Books
OWNI.EU Digital Journalism (Technology, Politics and Culture)
Charlie Brooker – How To Report The News (on Youtube)
http://www.youtube.com/watch?feature=player_embedded&v=YtGSXMuWMR4
National News Watch
http://www.nationalnewswatch.com/
The Huffington Post (Canada)
TRAINING RESOURCES(TOP)
Access 2000 tutorial (Florida Gulf Coast University)
http://www.fgcu.edu/support/office2000/access/index.html
Allen Browne’s Database and Training
http://allenbrowne.com/tips.html
College syllabi on computer-assisted reporting, precision journalism and news research
Gannett Newsroom Resources
http://www.gannett.com/go/newswatch/nwwebtips/webresmain.html
Institute for Analytic Journalism
http://analyticjournalism.blogharbor.com/blog
Journalism Education in Canada (Carleton professor, Mary McGuire)
http://http-server.carleton.ca/~mmcguire/J-Ed/
JournalismNet (Julian Sher’s Internet site)
MVP Web Sites (tutorials for Microsoft Access)
http://mvps.org/links.html#Access
PewResearchCenter Publications
http://pewresearch.org/pubs/1220/home-ownership-trends-blacks-hispanics
Newscollege ( Practical Journalism Tips )
News University (A project of The Poynter Institute for Media Studies funded)
No Train, No Gain
http://www.notrain-nogain.com/
Online tutorials from Brown University
Poynter Institutue
Knowledgewebb (Baltimore-based online training for people working in the digital media)
Writing About Business (The New Columbia Knight – Bagehot Guide to Economics & Business Journalism)
Society of Professional Journalists
Citizen Journalism course at Kwantlen Polytechnic University
http://beyourownjournalist.com/
KEY WORD SEARCH ENGINES(TOP)
Google Keyword Selector
https://adwords.google.com/select/KeywordToolExternal
The Official Google Reader Blog (Follow changes to any websites)
http://googlereader.blogspot.com/2010/01/follow-changes-to-any-website.html
SearchEngineWatch.com
Yahoo Search
Windows Live (MSN Search)
http://www.live.com/?searchonly=true&mkt=en-ca
AlltheWeb
Wisenut
Vivisimo
Killer Info
Search Engine Showdown (The User’s Guide To Searching the Web)
http://www.searchengineshowdown.com/others/archive.shtml
Wayback machine (Internet archives)
http://www.archive.org/web/web.php
http://www.archive.org/index.php
Finding Old Web Pages
http://www.searchengineshowdown.com/others/archive.shtml
baidu (a large Chinese search engine that has a cache link)
Cyberjournalists.net
http://www.cyberjournalist.net/cyberjournalists.php
Search Engine Showdown (The Users’ Guide to Web Searching)
http://searchengineshowdown.com/
http://www.searchengineshowdown.com/others/archive.shtml
LABOUR [Top]
Occupation – Standard Occupational Classification 1991 (Historical) (707) (Statistics Canada)
Enforcement Statistics (Ontario Ministry of Labour)
http://www.labour.gov.on.ca/english/hs/pubs/enforcement/index.php
LAND-TITLE AND PROPERTY ASSESSMENT OFFICES(TOP)
The TitleSearchers.ca ( is a website of title searches / registry agents across Canada
Alberta Land Titles
http://www.servicealberta.ca/LandTitles.cfm
British Columbia Land Titles
https://www.bconline.gov.bc.ca/
Manitoba Property Registry
http://www.gov.mb.ca/tpr/land_titles/lto_offices/offices.html
New Brunswick Land Titles and Assessments
http://www.snb.ca/e/4000/4106e.asp
NewFoundland and Labrador Deeds
http://www.gs.gov.nl.ca/registries/deeds.html
Northwest Territories Land Titles
http://www.justice.gov.nt.ca/LandTitles/index.shtml
Nova Scotia’s Property Online
http://www.gov.ns.ca/snsmr/property/default.asp?mn=282.46.1064
Nunavut
http://www.justice.gov.nu.ca/i18n/french/legreg/lt_index.shtm
Ontario Land Registration Information
http://www.ontario.ca/en/information_bundle/land_registration/STEL01_130081.html
Prince Edward Island Registry of Deeds
http://www.gov.pe.ca/finance/index.php3?number=1007538&lang=E
Quebec Land Titles
https://www.registrefoncier.gouv.qc.ca/Sirf/Script/14_06_01-02/pf_14_06_01_reglr.asp
Saskatchewan Land Registry
http://www.isc.ca/LandTitles/Pages/default.aspx
Yukon Land Titles
http://www.justice.gov.yk.ca/prog/cs/index.html
LEGAL SYSTEM/COURTS (TOP)
National Class Action Database (The Canadian Bar Association)
http://www.cba.org/classactions/main/gate/index/
Martindale.com
Multilingual Legal Glossary
http://legalglossary.ca/dictionary/getRecord2.asp?3325,1,0
Legal terminology
http://www.duhaime.org/dictionary/diction.htm
Canada’s justice system
http://canada.justice.gc.ca/eng/sch-rch/sch-rch.asp
The Criminal Code
http://laws.justice.gc.ca/en/C-46/index.html
Justice Laws Website Title (The Department of Justice Canada)
http://laws-lois.justice.gc.ca/eng/index.html
The Association of Justice Counsel (The bargaining agent for Justice lawyers and notaries for which Treasury Board is the employer)
http://www.ajc-ajj.org/eng/default.aspx
Table of Public Statutes and Responsible Ministers (The Department of Justice Canada)
http://laws-lois.justice.gc.ca/eng/TablePublicStatutes/index.html
Federal Accountability Act (S.C. 2006, c. 9 – The Department of Justice Canada)
http://laws-lois.justice.gc.ca/eng/acts/F-5.5/index.html
Canadian legal resources
http://jurist.law.utoronto.ca/ref_desk.htm
The Canadian Legal Information Institute
http://canlii.org/en/index.php
The scope of CANLII’s databases
http://canlii.org/en/databases.html
Law Society of Upper Canada ( list of disbarred lawyer )
http://www.lsuc.on.ca/with.aspx?id=689
The National Class Action Database (a voluntary initiative and is not a comprehensive listing of all class action lawsuits currently underway in Canada)
http://www.cba.org/ClassActions/main/gate/index/default.aspx
Canadian Media Lawyers Association (Ad IDEM)
WestlawECarswell (site to be used by Carleton student ID number)
http://www.library.carleton.ca/eresources/db_titles_W.html
Supreme Court of Canada
http://www.scc-csc.gc.ca/home-accueil/index-eng.asp
Judgements of the Supreme Court of Canada
http://csc.lexum.org/en/index.html
Federal Court of Canada
http://www.fct-cf.gc.ca/index_e.html
Federal Court watch (This site monitors the most recent files on the Federal Court of Canada trial division docket)
http://sushiboy.org/fedcourt.php
Tax Court of Canada
http://www.tcc-cci.gc.ca/main_e.htm
Manitoba Courts
Ontario Courts
http://www.ontariocourts.on.ca/english.htm
Quebec Courts
http://www.jugements.qc.ca/generalites/contenu.php
Provincial Offences Court – Ottawa
http://ottawa.ca/city_hall/prov_crt/index_en.html
Canadian Bar Association
http://www.cba.org/CBA/Home.asp
Canadian Law List
http://www.canadianlawlist.com/
Law Commission of Canada
http://www.lcc.gc.ca/default-en.asp?lang_update=1
ipblog.ca (intellectual property, trade-mark & Internet law)
Bankruptcydata.com
http://www.bankruptcydata.com/default.asp
Findlaw
http://www.findlaw.com/index.html?srchfindlaw
Smoking Gun
British and Irish Legal Information Institute
Ottawa Law Review
http://www.commonlaw.uottawa.ca/en/ottawa-law-review/full-page-content/ottawa-law-review.html
HG.org (Worldwide legal directories)
http://www.hg.org/law-firms/Personal-Injury/Canada.html
LESSON PLANS (Top)
Week one
Week two
Crude Oil – Electronic (NYMEX)
http://www.marketwatch.com/investing/future/crude%20oil%20-%20electronic
Bank of Canada
Statistics Canada
http://www.statcan.gc.ca/start-debut-eng.html
BlackBerry Limited
http://ca.blackberry.com/company.html
BlackBerry’s 2015 Third Quarter annotated results
https://www.documentcloud.org/documents/1501586-q3-fiscal-2015-financial-information.html
To obtain BlackBerry’s Q3-Fiscal-2015_Consolidated Statement, please click here.
CometDocs
I love PDF
To download the Excel file containing the Q3-Fiscal-2015, please click here.
Week three
An analysis of Blackberry’s third quarter financial statement annotated in DocumentCloud.
An analysis of BlackBerry’s 2014 Proxy Circular annotated in DocumentCloud.
Tradingview
https://www.tradingview.com/e/MSuvXQsL/
Nasdaq
For the tutorial that explains how to download an interactive stock price chart, please click here.
For the spreadsheet that contains a Samsung stock-price chart downloaded from the Nasdaq website, please click or right-click (if you are a Mac user) here.
For instructions on how to upload data to infogr.am, please click here.
State marks 25th anniversary of King holiday
Newcastle remembers its earthquake 25 years ago
http://www.smh.com.au/national/newcastle-remembers-its-earthquake-25-years-ago-20141228-12epjo.html
On 25th Exxon Valdez anniversary, oil still clings to beaches
Week four
Food inspection agency looks for investigators to probe contracting practices
ByandSell.gc.ca
https://buyandsell.gc.ca/procurement-data/tenders
City of Toronto Parking Tickets
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=ca20256c54ea4310VgnVCM1000003dd60f89RCRD
To download 2013 city of Toronto Parking Tickets, please click here
City of Ottawa Open Data Catalog
http://data.ottawa.ca/en/?page=1
Week five
Beer Store has donated $1.1-million to Ontario politicians (The Globe and Mail)
Elections Ontario
http://www.elections.on.ca/en-CA/Tools/FinancialStatementsandContributions/RealTimeDisclosure.htm
To download Ontario donation data please click here.
Contaminated sites cleanup to cost billions more, budget office says (CBC News)
Treasury Board contaminated Sites
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx
To obtain the Excel workbook that contains the High Priority for Action site, please click here.
First Nations Contaminated Sites mapped out in Google Fusion Tables
To download the pivot table tutorial (part one) using the Ontario elections data, please click here.
Week six
Decade-long OPP study shows Ontario road deaths on steady decline, preventable (The Ottawa Citizen)
Champlain LHIN aims to reduce high rate of falls by seniors (The Ottawa Citizen)
http://ottawacitizen.com/news/local-news/champlain-lhin-aims-to-reduce-high-rate-of-falls-by-seniors
To download the second pivot table tutorial, please click here.
To download the Excel workbook with 2013 and 2014 Ontario political donations, please click here.
August 2014 city of Ottawa noise complaints mapped out in Fusion Tables
City of Ottawa Open Data Catalog
http://data.ottawa.ca/en/?page=1
To download the Fusion Tables tutorial for the city of Ottawa’s complaints data, please click here.
To download the city of Ottawa ward KML file, please either right-click and “save as” or simply click here.
To download the Excel workbook that contains the August 2014 city of Ottawa complaints data, please click here.
Appendix C from Digging Deeper 3rd edition: Visualizing Data with Google Fusion Tables and Tableau Public
How cities are searching for solutions among massive mounds of data (The Globe and Mail)
Week seven
Week eight
Canadian Embassy went too far to protect mining company interests in Mexico, critics say
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)
To download the temporary foreign worker chronology in Excel, please click here.
To download a clean copy of the city’s ward kml file, please click here.
Week nine
Ottawa asking federal government to cover $375K of city police overtime (CBC News)
http://www.cbc.ca/news/canada/ottawa/rcmp-overtime-costs-for-ottawa-shooting-nearly-330k-1.2983330
Interviewing: 5206-15-PowerPointEight.ppt
To download Peter Mansbridge’s 2014 year-end interview with Prime Minister, Stephen Harper, please click here.
Stephen Harper’s 2014 year-end interview
Jason Kenney’s tweet confirming soldier’s death sparked anger
Commodes, if Not Commutes, Have Improved at Port Authority Bus Terminal
Hillary Clinton Used Personal Email Account at State Dept., Possibly Breaking Rules (The New York Times)
Hillary Clinton’s use of private e-mail reflects poor judgment (The Washington Post)
State Department reviewing whether Clinton e-mail violated security rules (The Washington Post)
Dr. Jeffrey Sirzyk files lawsuit against police
http://www.cbc.ca/news/canada/
L’École de langue de l’Estrie met la clé sous la porte
Estrie Language school going bankrupt, teachers told: Estrie Language School also operates in Montreal, Quebec City and Gatineau, Que. (CBC News)
http://www.cbc.ca/news/canada/ottawa/estrie-language-school-going-bankrupt-teachers-told-1.2510995
To download Estrie’s bankruptcy records, click here
Bankruptcy
http://strategis.ic.gc.ca/epic/internet/inbsf-osb.nsf/en/
Government-Wide Reporting — Proactive Disclosure (Treasury Board Secretariat of Canada)
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
http://open.canada.ca/data/en/dataset/455d4d0a-5d5f-4f60-aa8a-9e36540d21d3
To download the government-wide federal contracts database, please click here.
Former escort called to testify against Bruce Carson at preliminary inquiry (APTN National News)
http://aptn.ca/news/2014/06/02/former-escort-called-testify-bruce-carson-preliminary-inquiry/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
Week ten
DelisleSearchWarrantReportVehicle.pdf
DelisleSearchWarrantReportHome.pdf
Wallin’s ‘suspicious’ expense claims included personal trips, RCMP finds (The Globe and Mail)
Pamela Wallin’s Senate expenses for board-related trips being investigated (CBC News)
To see the annotated court document that details Wallin’s “suspicious” claims, please click here.
Week eleven
50 data-journalism ideas (NICAR)
http://mtduk.es/prez/50ideas.html#/
Florida city’s ‘stop and frisk’ nabs thousands of kids, finds 5-year-olds ‘suspicious’
Data Journalism ideas and databases (NICAR)
https://www.dropbox.com/s/44nhv2hp6rdg04h/Game_of_Life.docx?dl=0
Solo data journalist tips and tools
https://gist.github.com/brentajones/77167d4dfe81d46cb731
Tell.me.story.I.wont.forget.pdf
CAR Conference Blog (NICAR)
http://ire.org/blog/car-conference-blog/
Sparks flew, crew members ran as video offers glimpse into Sea King crash at CFB Shearwater
Week twelve
Reports of Bell meddling with news coverage ‘disturbing’, CRTC chief says (The Globe and Mail)
Statement by Jean-Pierre Blais, Chairman and CEO of the CRTC, on journalistic independence
http://news.gc.ca/web/article-en.do?nid=955409
CAJ to Bell: Don’t interfere with CTV’s journalism
http://www.newswire.ca/en/story/1507935/caj-to-bell-don-t-interfere-with-ctv-s-journalism
Statement by Kevin Crull, President, Bell Media on CTV News
http://www.bellmedia.ca/pr/press/statement-kevin-crull-president-bell-media-ctv-news/
Bell Media president apologizes for interfering in CTV news coverage (Toronto Star)
Bill C-51: Sister of slain soldier Patrice Vincent testifies as committee review resumes (CBC News)
Enbridge fined $264,000 for safety, environmental hazards on oil pipeline
Administrative Monetary Penalties Issued (National Energy Board)
https://www.neb-one.gc.ca/bts/ctrg/gnnb/dmnstrtvmntrypnlts/index-eng.html#nbrdg-ln3-2
To learn about the fines Enbridge is facing in the United States, please click here.
Enbridge Investor Documents & Filings
http://www.enbridge.com/InvestorRelations/FinancialInformation/InvestorDocumentsandFilingsOld.aspx
The U.S. Pipeline & Hazardous Materials Safety Administration
http://primis.phmsa.dot.gov/comm/reports/enforce/Enforcement.html?nocache=6308
U.S. Federal Inspection and Enforcement data for Enbridge
Theft of military uniforms sparks fresh security concerns (Ottawa Citizen)
http://ottawacitizen.com/news/politics/theft-of-military-uniforms-sparks-fresh-security-concerns
Public Accounts reference in DocumentCloud
Losses of public property figured tallied in Excel
Veterans Affairs’ unused funds total $1.13B since 2006 (The Canadian Press)
Response from the Veterans Affairs Minister’s office to lapsed-spending coverage
Veterans Affairs lapsed-spending numbers from the 2014 Public Accounts
Lapsed spending numbers tallied in Excel
Week thirteen
5206-15-PowerPointThirteen.ppt
Ethics watchdog approved jobs with Barrick Gold, Canadian Pacific: Baird (Ottawa Citizen)
http://ottawacitizen.com/news/politics/john-baird-was-lobbied-by-barrick-gold-in-2013
The Barrick Gold annual report in DocumentCloud
https://www.documentcloud.org/documents/1699223-barrickgoldannual-report.html#document/p14/a210853
CP Proxy Circular in DocumentCloud
https://www.documentcloud.org/documents/1698495-cpproxycircular.html
Office of the Commissioner of Lobbying Canada
http://www.ocl-cal.gc.ca/eic/site/012.nsf/eng/00035.html
https://ocl-cal.gc.ca/app/secure/orl/lrrs/do/clntCmmLgs?cno=223422®Id=707349
Air Canada AC624 touched down 335 metres short of runway, TSB says (CBC News)
Collision with terrain involving an Air Canada Airbus A320 at Stanfield International Airport, Halifax, Nova Scotia (Transportation Safety Board)
http://www.tsb.gc.ca/eng/medias-media/communiques/aviation/2015/a15h0002-20150330.asp
To download the lawsuit notification against Air Canada, please click here.
CADORS (Transport Canada)
http://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/q.aspx?lang=eng
To download the CADORS 2000-2015 data run for Atlantic Canada, please click here.
Sunshine List shows London schools and hospitals have top public salaries (The London Free Press)
Ontario Sunshine List stories (at The Huffington Post Canada site)
http://www.huffingtonpost.ca/news/ontario-sunshine-list/
Public Sector Salary Disclosure 2015 (Disclosure for 2014)
http://www.ontario.ca/government/public-sector-salary-disclosure
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
The Canadian Council of Archives
http://www.archivescanada.ca/index2.html
Theses Canada Portal (Library and Archives Canada)
http://www.collectionscanada.ca/thesescanada/index-e.html
ArchiviaNet Online Research Tool
http://www.archives.ca/02/0201_e.html
Ottawa Public Library
http://www.library.ottawa.on.ca/english/index.htm
Proquest
Bartleby.com (a complete reference guide)
http://www.bartleby.com/reference/
Gumshoe Librarian ( A bibliography of Recommended Websites for Global Research Issues )
http://www.llrx.com/features/gumshoe.htm
U.S. News Archives on the Web
http://www.ibiblio.org/slanews/internet/archives.html
LOBBYISTS(TOP)
Federal Public Registry of Lobbyists
http://www.ocl-cal.gc.ca/eic/site/lobbyist-lobbyiste1.nsf/eng/home
Federal lobbyists search
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
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)
MAPPING(TOP)
Geobase – Federal Electoral Districts – Canada 2013
Geographic Information Systems (Algonquin College)
http://www3.algonquincollege.com/sat/program/geographic-information-systems/
Geographic Information System (Q&A)
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/
Making maps with QGIS (Peter Aldhous)
http://paldhous.github.io/NICAR/2015/qgis.html
Manipulating and editing geographic data with QGIS (Michael Corey)
http://mikejcorey.github.io/qgis_advanced_2015/
Knight Digital Media Center’s data visualization tutorials
http://multimedia.journalism.berkeley.edu/tutorials/cat/data
Knight Digital Media Center’s digital media tutorials
http://multimedia.journalism.berkeley.edu/tutorials/
FalconView
http://www.falconview.org/trac/FalconView
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)
Geocoder.ca
http://geocoder.ca/?freedata=1
Latitude and longitude locator
http://www.kenjikojima.com/jikankei/map.html
GeoBase
http://www.geobase.ca/geobase/en/index.html
GeoCoder.ca
Geocommons
Degrees, Minutes, Seconds and Decimal Degrees Latitude/Longitude Conversions (Federal Communications Commission)
http://transition.fcc.gov/mb/audio/bickel/DDDMMSS-decimal.html
Understanding Latitude and Longitude:The Global Grid
http://www.learner.org/jnorth/tm/LongitudeIntro.html
MapShaper
http://mapshaper.com/test/demo.html
ESRI
http://esripress.esri.com/display/index.cfm
GIS for Stimulus Reporting
http://www.esri.com/industries/stategov/business/stimulus.html
Tableau Public ( a free application that helps to visualize data )
http://www.tableausoftware.com/public/gallery
http://www.tableausoftware.com/public/ire
Tableau tutorials
Google Fusion Tables
Googe Fusion Tables discussion group
https://groups.google.com/forum/#!topic/fusion-tables-users-group/4SVxAew5P78
Google Fusion Table (shape file to KML conversion)
Google fusion tables beta (data sets you can use)
https://www.google.com/fusiontables/search
FusionTablesLayer Builder
http://gmaps-samples.googlecode.com/svn/trunk/fusiontables/fusiontableslayer_builder.html
Google Sites (allows you to see what your Fusion Table maps or charts look like before publishing them)
http://www.google.com/sites/help/intl/en/overview.html
ColorBrewer (for doing fancier colour schemes in Fusion Tables)
A map to help voters find their polling places using Fusion Tables as a data source (Google fusion tables)
Google earth
http://www.google.com/earth/index.html
How to make your own data map of Montreal
http://blogs.montrealgazette.com/2011/10/07/how-to-make-your-own-data-map-of-montreal/
Zonum Solutions (Converts shape file files to KML files)
http://www.zonums.com/shp2kml.html
Gut Those Shapefiles (shape file converter)
Google Geo Developers Blog
http://googlegeodevelopers.blogspot.com/2010/11/search-your-geo-data-using-spatial.html
Google’s Chart Tool
http://imagecharteditor.appspot.com/
Shape to Fusion ( A website that allow users to import shape files into fusion tables)
Patrickcain.ca (A journalist who makes maps for the Web)
All things spatial (a good mapping blog)
http://all-things-spatial.blogspot.com/
Google public data explorer
http://www.google.com/publicdata/home
http://www.google.com/support/publicdata/
http://www.youtube.com/watch?v=jbkSRLYSojo&feature=related
GPS Visualizer
http://www.gpsvisualizer.com/geocoder/
Infinite Gravity Data Services (The Canadian Postal Code)
http://www.infinitegravity.ca/postalcodeformat.htm
Think Data
Fusion Table URL for the Ottawa bike thefts
http://www.google.com/fusiontables/DataSource?snapid=S290201DOQI
Patrickcain.ca: A journalist who makes maps for the web
http://www.patrickcain.ca/?p=1
111031_afghan_dead_for_Google
http://www.google.com/fusiontables/DataSource?snapid=S308680sRHu
Boundary files (Statistics Canada)
http://www12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-eng.cfm
Geogrpahic levels for 2011 census (Statistics Canada)
2006 Census Population (Statistics Canada)
http://www12.statcan.gc.ca/census-recensement/2006/index-eng.cfm
2006 Census Income and Earnings
2006 Census Household Income
2011 Census – Province and Territory Cargographic Boundary Files (Statistics Canada)
http://www.data.gc.ca/data/en/dataset/bab06e04-e6d0-41f1-a595-6cff4d71bedf
Geography (Statistics Canada)
http://www12.statcan.gc.ca/census-recensement/2011/geo/index-eng.cfm
OpenStreetMap
http://planet.openstreetmap.org/planet/planet-latest.osm.bz2
ArcGIS Resources
http://resources.arcgis.com/en/help/main/10.1/index.html#//006z00000009000000
Importing csv data tutorial
https://www.trentu.ca/library/data/addingXYdata_V10.pdf
Mapbox: Tips for using colors
https://www.mapbox.com/tilemill/docs/guides/tips-for-color/
MAPPING STORIES(TOP)
Airbnb renters hope to score big cash during Pan Am games (CBC-Radio-Canada)
http://www.cbc.ca/news/canada/toronto/multimedia/airbnb-renters-hope-to-score-big-cash-during-pan-am-games-1.3133581
Follow the Money: Federal spending announcements in 2013(CBC News and Carleton J-school)
http://www.cbc.ca/news/politics/federal-funding
EXCLUSIVE: Search and rescue for false alarms costs millions (CBC News)
http://www.cbc.ca/news/politics/search-and-rescue-for-false-alarms-costs-millions-1.2594306
Contaminated sites cleanup to cost billions more, budget office says (CBC News)
2011 Census Population Data by Ward (Raise the Hammer)
http://www.raisethehammer.org/article/1541/2011_census_population_data_by_ward
Crime in St. Paul
http://stpaulcrime.twincities.com/#trends
2011 Wisconsin Senate Recalls
http://host.madison.com/data/maps/politics/2011-senate-recalls/
After federal changes to waterways rules, 90 per cent of protected lakes lap on Conservative shores (The Ottawa Citizen)
http://aware-simcoe.ca/issues/water/3237-water.html
Conservatives defend new waterways rules against accusations of favouritism (The Ottawa Citizen)
A new view of Edmonton (Edmonton Journal)
http://www.edmontonjournal.com/news/living-on-the-edge/index.html
Battleground B.C.: Election Trends (The Vancouver Sun)
http://www.vancouversun.com/news/electiontrends.html
Canada’s climbing tuition fees (CBC News)
http://www.cbc.ca/news/interactives/map-tuition-fees/
City’s Information Technology Master Plan – Enabling an Engaged & Connected City
http://www.mississauga.ca/portal/cityhall/pressreleases;.node2-4?paf_gear_id=9700020&itemId=5300808q&returnUrl=%2Fportal%2Fcityhall%2Fpressreleases%3Bjsessionid%3D8F25AE5F5A8F02933AC6DBE5C555B93E.node2-4
Mapping info: More city data within reach online
http://windsorstar.com/news/local-news/mapping-info-more-city-data-within-reach-online
Median home prices in 2010 remained below 2007 levels across Cuyahoga County
http://www.cleveland.com/datacentral/index.ssf/2011/02/median_home_prices_in_2010_rem.html
MONTREAL: CITY OF CONTRASTS (The Gazette, Montreal)
http://www.montrealgazette.com/news/interactives/household-survey/index.html
More discarded needles being found in Ottawa’s suburbs (CBC News)
New Westminster launches open data website
http://www.burnabynow.com/news/new-westminster-launches-open-data-website-1.2114670
Lying with Maps: How Enbridge is Misleading the Public in its Ads
http://eaves.ca/2012/08/15/lying-with-maps-how-enbridge-is-misleading-the-public-in-its-ads/
New federal electoral boundaries (CBC News)
http://www.cbc.ca/news2/interactives/electoral-district-search/
Current Events Maps
http://www.esri.com/news/maps/index.html
Crime rates continue to fall in Canada: Declines recorded across country, for most offences (CBC News)
http://www.cbc.ca/news/interactives/crime-severity/
Gulf of Mexico Oil Spill
http://www.esri.com/services/disaster-response/gulf-oil-spill-2010/resources.html
Census 2010 Interactive Map: Texas Population By Race, Hispanic Origin (The Texas Tribune)
http://www.texastribune.org/library/data/census-2010/
Census 2010 Interactive Map: Texas Population By House, Senate District (The Texas Tribune)
http://www.texastribune.org/library/data/census-2010/
Family, church important to Filipinos: Many call the central neighbourhood around Fraser Street home, and Tagalog signs abound (The Vancouver Sun)
Federal Parolees Per Capita (The Vancouver Sun)
http://www.vancouversun.com/news/parolees-capita.html
Fare evasion on SkyTrain and Canada Line (The Vancouver Sun)
http://www.vancouversun.com/news/transit-system-crime/fare-evasion.html
Election Prediction 2011 (Hill and Knowlton)
Enbridge affiliates have had 175 leaks, spills over 10 years in U.S. (The Ottawa Citizen)
Explore the data: Toronto bicycle collisions mapped over 25 years (The Globe and Mail)
50 ridings to watch in the 2011 election (The Globe and Mail)
2008 Federal election: GTA ridings (The Toronto Star)
http://www3.thestar.com/static/googlemaps/electionmaps.html?xml=2008_federal.xml
Highway 63 features map (The Edmonton Journal)
http://www.edmontonjournal.com/news/highway63/map/index.html
Homicides mapped: 1999 to 2011 (Edmonton Journal)
http://www.edmontonjournal.com/news/homicide/map/index.html
How Many People Have Been Killed by Guns Since Newtown? (Slate)
INTERACTIVE: Census Explorer (The Canadian Press)
http://www.winnipegfreepress.com/canada/breakingnews/INTERACTIVE-Census-Explorer-138930999.html
Interactive map: Data links low income to poor school test results (Global News)
Interactive Map: Nov. 8 Amendment Vote by County (The Texas Tribune)
http://www.texastribune.org/library/data/nov-8-amendment-vote-map/
Interactive: What’s My District Now? (The Texas Tribune)
http://www.texastribune.org/library/data/whats-my-district-now/
Interactive: Perry Tracker (The Texas Tribune)
http://www.texastribune.org/library/data/perrytracker/
Interactive: Exploring Presidential Donors by ZIP Code (The Texas Tribune)
http://www.texastribune.org/library/data/exploring-presidential-donor-zip-code/
Interactive: Census: Where you live (The Telegraph)
http://www.macon.com/2011/03/22/1497153/census-where-you-live.html#storylink=misearch
Interactive map: Bibb County’s congressional redistricting (The Telegraph)
Interactive: Making the WNYC Census Map (JohnKeefe.net)
Interactive: SNAPSHOT: Motorcycles per 1,000 residents, 2010 (boston.com)
Interactive Map: Explore the data behind Toronto’s working poor (The globe and Mail)
Interactive: City of Toronto homicides and gang activity, 2008 to present
Investigate with us (Edmonton Journal)
http://www.edmontonjournal.com/news/living-on-the-edge/index.html
Grand Falls-Windsor growing without paper mill (CBC News)
http://www.cbc.ca/news/canada/newfoundland-labrador/story/2012/02/11/nl-gfw-census-211.html
Living on the Edge (Edmonton Journal)
http://www.edmontonjournal.com/news/livingontheedge/index.html
Map: See Dallas-area holiday light displays (Dallas Morning News)
Metro Vancouver Daycare Ratings Map (The Vancouver Sun)
http://www.vancouversun.com/news/daycare-map.html
New Ramsey County sheriff approves a higher percentage of gun applications than Fletcher (Pioneer Press)
http://www.twincities.com/ci_19512257
NYC Evacuation Zones
http://project.wnyc.org/news-maps/hurricane-zones/hurricane-zones.html
Minnesota’s public pensins: 40-year financial snapshot
http://public.tableausoftware.com/views/Pensions2/Dashboard1?:embed=y
Pioneer Press Family Outings Find fun things to do with your kids in the Twin Cities
http://www.twincities.com/family
Riding Profile — Edmonton – Strathcona (The Edmonton Journal)
http://www.edmontonjournal.com/news/election/edmontonstrathcona.html
BC Liberal leadership vote by the numbers — exclusive maps, graphics and analysis (The Vancouver Sun)
(902)-9-1-1 (A King’s College Investigation)
http://902911.kingsjournalism.com/
Comment vos voisins ont-ils voté en 2008? (Cyberpresse.ca)
Canada Votes 2011 ( Interactive map: CBCNews.ca)
http://www.cbc.ca/news/politics/canadavotes2011/#/171
Canadian federal election results for 2004, 2008 and 2011 (ERSI Press)
http://50.16.208.225/CompareWebMaps/
Canada’s 41st Election Explained ( Flickr )
http://www.flickr.com/photos/david_hicks/5683761559/sizes/l/in/photostream/
Find Your Polling Place (baycitizen.org)
http://www.baycitizen.org/data/mayors-race-2011/poll-locations/
Global News Exclusive: Maritimers leading the way in organ donor registration (globalnewsmaritimes)
Gogama : la hausse du transport de pétrole par train en partie responsable des accidents, croient des experts (Radio-Canada)
http://ici.radio-canada.ca/regions/ontario/2015/03/10/007-lien-petrole-deraillements.shtml
Interactive map shows breakdown of HST vote (The Vancouver Sun)
http://www.vancouversun.com/news/Interactive+shows+breakdown+vote/5313564/story.html
Interactive: Direct your own exploration of Minnesota Census data (Pioneer Press)
http://www.twincities.com/1000/ci_17627259?source=pkg
Interactive: Get to know your candidates (The Gazette)
http://www.montrealgazette.com/news/decision-canada/learn-about-candidates.html
Interactive graphics and databases (The Seattle Times)
http://seattletimes.nwsource.com/flatpages/specialreports/interactives.html?from=stnv2
Interactive: Texas Presidential Contributions by ZIP Code (The Texas Tribune)
http://www.texastribune.org/library/data/presidential-contributions-zip-code-2011/
METHADONE AND THE POLITICS OF PAIN (The Seattle Times)
Proposed Keystone Pipeline road map (CBC News)
http://www.cbc.ca/news/interactives/map-pipeline/
http://www.cbc.ca/news/politics/story/2011/11/10/keyston-pipeline-route.html
How WNYC Used Texts from Citizens To Map Snowstorm (Mobile Phone Blog)
http://mobilephone.firstblogfirst.com/2011/01/28/how-wnyc-used-texts-from-citizens-to-map-snowstorm/
Map of the Week: Grow operations (The Toronto Star)
Mapping our ethnicity Parts 1,2,3,5 (The Vancouver Sun)
http://www.vancouversun.com/news/Mapping+ethnicity+Part+South+Asia+Surrey/5547648/story.html
http://www.vancouversun.com/ethnicity/index.html
Mapping the Nation’s Well-Being (The New York Times)
http://www.nytimes.com/interactive/2011/03/06/weekinreview/20110306-happiness.html?ref=multimedia
Maps: Who are the dogs in your Toronto neighbourhood? (Global News)
http://www.globalnews.ca/Pages/Story.aspx?id=6442522298
Map: Where the tornadoes hit
http://news.cincinnati.com/interactive/article/20130227/CINCI/130227014?nclick_check=1
Medical marijuana use in Canada by postal code, 2001 to 2007 (Postmedia News)
http://www.vancouversun.com/health/medical-marijuana/map/index.html
Metro Vancouver Mapped: If you’re living in sin, you’re most likely living in Kitsilano (The Vancouver Sun)
http://www.vancouversun.com/news/metro-mapped/index.html
Metro buses involved in hundreds of crashes a year (CBC News Nova Scotia)
http://www.cbc.ca/news/canada/nova-scotia/story/2012/01/29/ns-metro-transit-collisions.html
Mississippi floods: how does 2011 compare? (New Scientist)
http://www.newscientist.com/blogs/shortsharpscience/2011/05/mississippi-floods-how-does-20.html
Oilsands website (Alberta government)
Ontario voter turnout lowest since 1867 (globalnews.ca)
http://www.globalnews.ca/interactive/6442496991/story.html
Rains come to Texas but drought could last for years (New Scientist)
http://www.newscientist.com/blogs/shortsharpscience/2011/10/texas-rains-too-little-too-lat.html
Spence residents complaining about bedbugs (globalwinnipeg)
http://www.globalwinnipeg.com/spence+residents+complaining+about+bedbugs/6442512625/story.html
Spinal-cord injuries hit teen athletes hardest (Pioneer Press)
http://www.twincities.com/ci_19750035
‘Sputnik moment’? A report card for US cities (New Scientist)
http://www.newscientist.com/blogs/onepercent/2011/01/-innovation-in-america-dashboa.html
Storm warning: prepare for a busy hurricane season (New Scientist)
http://www.newscientist.com/blogs/shortsharpscience/2011/05/prepare-for-hurricane-season.html
St. Paul gun incident reports up 65 percent so far in 2012 (w/ searchable map) (St. Paul Pioneer Press)
The Census: Canada’s Changing Society (The Canadian Press)
http://thecanadianpress-census.ca/?graphics=communities-interactive-map
http://thecanadianpress-census.ca/
TransLink bus routes with the most passups (The Vancouver Sun)
http://www.vancouversun.com/news/passuproutes.html
Travelling memorial: Canadians in Afghanistan (CBC News)
http://www.cbc.ca/news/interactives/mural-cdnsinafghanistan/
U.S. tech workers by the numbers (Computer World)
http://www.computerworld.com/s/article/9231501/U.S._tech_workers_by_the_numbers#map
Unemployment rates in Canada (CBC News)
http://www.cbc.ca/news/interactives/unemployment-stats/
Vancouver Photos from Flickr (The Vancouver Sun)
http://www.vancouversun.com/news/flickr.html
Vancouver Crime 2006-2011
http://marcellison.com/fusion/fusion_index.html
Welcome to The Bay Citizen’s Bike Accident Tracker! (baycitizen.org)
http://www.baycitizen.org/data/bike-accidents/
When Maps shouldn’t be Maps (Matthew Ericson, deputy graphics director for The New York Times)
http://www.ericson.net/content/2011/10/when-maps-shouldnt-be-maps/
Where are the world’s nuclear reactors? (New Scientist)
http://www.newscientist.com/embedded/nuclear-reactor-map
Where are the mayoral candidates raising their money? (NPR)
http://empire.wnyc.org/2011/07/where-are-the-mayoral-candidates-raising-their-money/
The deadly mixture of guns and class in Toronto
Why Taxpayers Will Bail Out the Rich When the Next Storm Hits (NBC News)
http://www.nbcnews.com/news/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
MAPPING TUTORIALS(TOP)
Bringing Google spreadsheets and Fusion Tables closer together
http://chrislkeller.blogspot.ca/
Fusion Table tutorial (MaryJo Webster, St. Paul Pioneer Press)
http://extra.twincities.com/car/mj/fusiontableswebinar.wmv
Quickly visualize and map a data set using Google Fusion Tables
How to make a map in Google Fusion Tables
http://www.computerworld.com/slideshow/detail/68971#slide1
Spatial Analysis Tip Sheet — Spatial Joins and Overlays, Density, and Proximity Analysis (Barbara Parmenter, Tufts University)
http://ocw.tufts.edu/data/54/616425.pdf
HTML Tutorial – (HTML5 Compliant)
http://www.w3schools.com/html/default.asp
City of Ottawa building inspections (practice data)
Mapping Tutorial for 2010 Ottawa bike thefts
Mapping Tutorial for the distribution of baseball diamond in Ottawa wards
Mapping Tutorial for matching specific bike thefts in each wards using Qgis
Tutorial on visualing data separated into groups and creating a legend
Quantum GIS (QGIS) Tutorials
http://qgis.spatialthoughts.com/2012/03/using-tabular-data-in-qgis.html
http://qgis.spatialthoughts.com/2012/06/making-maps-for-print-using-qgis.html
http://docs.qgis.org/html/en/user_manual/print_composer/print_composer.html
Expressions, Filtering and Calculating Values in Qgis
http://docs.qgis.org/testing/en/docs/pyqgis_developer_cookbook/expressions.html
http://qgis.spatialthoughts.com/2010/10/working-with-attribute-table-basic.html
To obtain the first Qgis tutorial, please click here.
Here’s the second Qgis mapping tutorial.
Data for the third Qgis tutorial
2006 Census – Boundary files
http://www12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-2006-eng.cfm
After obtaining the census boundary file in the link above and downloading the “TotalIncome” file, you are ready for the third Qgis tutorial.
Telling your story with maps: ArcGIS Online Tutorial
http://video.arcgis.com/watch/916/arcgis-online-overview
http://video.arcgis.com/watch/916/arcgis-online-overview
http://video.arcgis.com/watch/916/arcgis-online-overview
http://video.arcgis.com/watch/1341/sharing-and-collaborating-within-an-organization
http://video.arcgis.com/watch/2457/map-your-excel-data
http://video.arcgis.com/watch/1340/managing-the-resources-of-an-organization
http://video.arcgis.com/watch/249/embedding-a-map-in-your-website
http://video.arcgis.com/watch/248/editing-feature-layers-on-a-map
http://video.arcgis.com/series/18/arcgis-online
A Mac user tutorial for downloading and creating your own base map layer (Lucus Timmons)
Tutorial: QGIS Basics For Journalists
http://multimedia.journalism.berkeley.edu/tutorials/qgis-basics-journalists/
Data journalism resources (Peter Aldhous, science journalist)
http://peteraldhous.com/resources.html
http://paldhous.github.io/NICAR/2015/qgis.html
Lining Up Data in ArcGIS: A Guide to Map Projections, Second Edition
http://esripress.esri.com/display/index.cfm?fuseaction=display&websiteID=231&moduleID=0
MEDICAL DEVICES(TOP)
Health Canada’s list of recalled drugs and medical devices
http://www.hc-sc.gc.ca/dhp-mps/compli-conform/recall-retrait/_list/index-eng.php
Health Canada’s list of warnings, advisories and recalls (on marketed health products, including Natural Health Products and medical devices)
http://www.hc-sc.gc.ca/dhp-mps/medeff/advisories-avis/index-eng.php
Food and Drug Administration’s list of device recalls
http://www.fda.gov/MedicalDevices/Safety/RecallsCorrectionsRemovals/ListofRecalls/default.htm
Food and Drug Administration’s Medical & Radiation Emitting Device Recalls
http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfRES/res.cfm
Food and Drug Administration’s Medical Device Databases
http://www.fda.gov/MedicalDevices/DeviceRegulationandGuidance/Databases/default.htm
Food and Drug Administration’s MAUDE – Manufacturer and User Facility Device Experience (MAUDE data contains reports of adverse events involving medical devices)
http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfMAUDE/search.CFM
Medical Device Reports (MAUDE) (NICAR)
https://ire.org/nicar/database-library/databases/medical-device-reports-maude/
Panel says medical device review system ‘flawed’ (The Associated Pres and CBC News)
http://www.cbc.ca/news/health/story/2011/07/29/health-medical-devices.html
Medical device changes to come in U.S. (The Associated Press)
http://www.cbc.ca/news/health/story/2011/01/20/medical-devices-fda.html
Medical device licence pulled, but still on the market (Marketplace)
Recently approved medical devices ( FDA )
http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfTopic/MDA/mda-list.cfm?list=1
MISCELLANEOUS TOOLS(TOP)
Listservs
http://www.lsoft.com/catalist.html
Blogs
Blog search (blog search)
Google’s BlogSearch
Ghostery
https://www.ghostery.com/en-GB/
Sphere
Feedster
All Calculators
http://calculator-converter.com/
Day-of-the-week calculator
http://www.calculatorcat.com/free_calculators/day_of_week.phtml
Calculate distance between two locations
http://www.timeanddate.com/worldclock/distance.html
The World Clock — Time Zones
Weather (Environment Canada)
http://www.weatheroffice.gc.ca/canada_e.html
Bank of Canada exchange rate converter
http://www.bankofcanada.ca/en/exchform.htm
Bank of Canada Inflation Calculator
http://www.bankofcanada.ca/en/rates/inflation_calc.html
Translation sites
http://babelfish.altavista.com/
http://www.google.ca/language_tools?hl=en
Timeanddate.com
MONEY(TOP)
Free Lunch: How the Wealthiest Americans Enrich Themselves at Government Expense (and Stick you with the bill)
GetSmarterAboutMoney.ca
http://www.getsmarteraboutmoney.ca/en/Pages/default.aspx
3Dpolicy.ca
Multi-media(TOP)
Liveleak
YouTube
Blinkx (Over 35 million hours of video. Search it all.)
The Tyee
The Printed Blog
http://www.theprintedblog.com/
MUNICIPAL GOVERNMENTS(TOP)
The Federation of Canadian Municipalities (FCM)
http://www.fcm.ca/english/main.html
Munimall (general information and news stories about municipalities)
Quebec municipalities
http://www.quebecmunicipal.qc.ca/liens/index.asp?LienID=47
Property assessments (Quebec municipalities)
http://www.quebecmunicipal.qc.ca/liens/index.asp?lienid=47
NEWS BLOGS(TOP)
Medium Close Up ( a blog by former CBC TV producer, Howard Bernstein)
How Canada became an open data and data journalism powerhouse (The Guardian)
http://m.guardian.co.uk/news/datablog/2010/nov/09/canada-open-data?cat=news&type=article
MYSQL(TOP)
Server SQL modes
http://dev.mysql.com/doc/refman/5.5/en/index.html
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
Don Gibb’s numeracy column for Media magazine
Math Quiz (the numbers are contained in Excel worksheets)
Math cribsheet courtesy of Steve Doig
http://forjournalists.com/cookbook/index.php?title=Math_cribsheet
Robert Niles.com
John Allen Paulos
No Train No Gain
http://www.notrain-nogain.org/Train/Res/Num/NUM.asp
The Poynter Institute
Math for Journalists (Debbie Wolfe)
http://www.newsu.org/courses/course_detail.aspx?id=nu_math05
Capping Credit Card Rates ( The NDP)
http://www.ndp.ca/credit-card-caps
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
City of Ottawa data catalogue
http://ottawa.ca/online_services/opendata/info/index_en.html
City of Ottawa Ward profiles
http://ottawa.ca/residents/statistics/census/wards/index_en.html
Previous City Budgets (City of Ottawa)
http://www.ottawa.ca/en/city_hall/budgettaxes/budget/index.html
Information
The Municipal Performance Measurement Program
http://www.ottawa.ca/city_hall/ottawa_performance/mpmp/index_en.html
Community Information Centre of Ottawa
http://www.cominfo-ottawa.org/main_eng.html
Community Case Study: City of Ottawa (Natural Resources Canada)
ONLINE NEWS SITES(TOP)
The Huffington Post (Canada)
The Canadian Journalism Project
Open File (Community-powered news in several Canadian cities)
bclocalnews.com
OPEN DATA GOVERNMENT WEBSITES(Top)
Alberta
BC
http://www.openinfo.gov.bc.ca/ibc/search/search.page#cateloguehttp://www.openinfo.gov.bc.ca/ibc/index.page?http://www.data.gov.bc.ca/
Canada Revenue Agency Tax-Free Savings Account 2014 Statistics (2012 contributions)
http://open.canada.ca/data/en/dataset/10531a5e-b500-4842-a1b0-305802a1da28
Canadian Open Data Institute
Canada’s Action Plan on Open Government 2014-16
http://open.canada.ca/en/content/canadas-action-plan-open-government-2014-16
Campaign Donations (City of Ottawa)
http://ottwatch.ca/election/listDonations
Data Inventory Project (DIP) (Statistics Canada)
http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=5190&Item_Id=122357&lang=en
datalibre.ca
Directive on Open Government
http://www.tbs-sct.gc.ca/pol/doc-eng.aspx?id=28108
Edmonton
GeoNOVA
Government-Wide Reporting — Proactive Disclosure
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
Halifax’s Open Data Catalogue
http://www.halifax.ca/opendata/
Healthdoc (find local doctors and health care providers near you)
https://www.healthdoc.ca/
Newfoundland and Labrador
Mississauga
http://www.mississauga.ca/portal/residents/mississaugadata
Oakville
Ontario
http://www.ontario.ca/government/open-data-ontario
http://www.ontario.ca/government/open-government
Ontario to allow public to vote on open data priorities
http://o.canada.com/technology/internet/ontario-to-allow-public-to-vote-on-open-data-priorities/
Ontario Trillium Foundation
http://otf.ca/our-impact/open-data
Open Government Declaration
http://www.opengovpartnership.org/about/open-government-declaration
OpenDataSites
Open Government Partnership
Open Data Pilot Project (federal government)
http://www.data.gc.ca/default.asp?lang=En
Open Data Pilot Project – csv files (federal government)
http://open.canada.ca/data/en/dataset?res_format=kml+%2F+kmz&_res_format_limit=0
Ottawa
http://data.ottawa.ca/en/?page=1
Ottawa restaurant inspections
Québec Ouvert (les données ouvertes pour le Québec)
Strathcona County
http://www.strathcona.ca/departments/information-technology-services/open-data/
Sudbury
http://www.greatersudbury.ca/inside-city-hall/open-data/
Toronto
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD
Toronto (parking tickets)
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=ca20256c54ea4310VgnVCM1000003dd60f89RCRD
Transparency and Open Government ( Barack Obama’s first memorandum)
https://www.whitehouse.gov/the_press_office/TransparencyandOpenGovernment
TSB InfoBase (a searchable online database providing financial and human resources information on government operations.)
http://www.tbs-sct.gc.ca/ems-sgd/edb-bdd/ennojs-home.html
Vancouver
World Development Indicators (The World Bank)
http://data.worldbank.org/data-catalog/world-development-indicators?cid=GPD_WDI
WJP OPEN GOVERNMENT INDEX (World Justice Project)
http://worldjusticeproject.org/open-government-index
World Council on City Data
http://open.dataforcities.org/
The United States
The Department of Transportation
http://www.dot.gov/mission/open/open-government
MEMORANDUM FOR THE HEADS OF EXECUTIVE DEPARTMENTS AND AGENCIES https://www.whitehouse.gov/sites/default/files/omb/memoranda/2013/m-13-13.pdf
The UK
Data.police.uk
Protection of Freedoms Act 2012
http://www.legislation.gov.uk/ukpga/2012/9/contents/enacted
Information Commissioner’s Office (a discussion of the datasets identified in the Protection of Freedoms Act 2012)
https://ico.org.uk/media/for-organisations/documents/1151/datasets-foi-guidance.pdf
U.K. Prime Minister’s first open letter on open data
U.K. Prime Minsiter’s second open letter on open data
https://www.gov.uk/government/news/letter-to-cabinet-ministers-on-transparency-and-open-data
U.K. Open Data Strategies ( by department)
http://data.gov.uk/open-data-strategies
Secretary of State’s Code of Practice (datasets) on the discharge of public authorities’ functions under Part 1 of the Freedom of Information Act
http://www.justice.gov.uk/downloads/information-access-rights/foi/code-of-practice-datasets.pdf
The World Wide Web Consortium (W3C)
OPEN DATA RESEARCH(Top)
An open data platform for improving Toronto transportation
http://news.engineering.utoronto.ca/an-open-data-platform-for-improving-toronto-transportation/
The Art and Science of Data-Driven Journalism (Tow Center for Digital Journalism)
http://towcenter.org/research/the-art-and-science-of-data-driven-journalism/
The Benefits of a Big Tent: Opening Up Government in Developing Countries
Big Data & Society
Chicago Tribune news apps blog
http://blog.apps.chicagotribune.com/
Council for Big Data, Ethics, and Society
Datalibre
David Eaves
Defining Open Government (by Beth Simone Noveck, U.S. Deputy Chief Technology Officer for Open Government)
Election Issues 2015: A Maclean’s primer on vanishing data
http://www.macleans.ca/politics/election-issues-2015-a-macleans-primer-on-vanishing-data/
Federal Open Government Guide
http://www.rcfp.org/rcfp/orders/docs/FOGG.pdf
How not to screw up your data (Noah Veltman)
http://veltman.tumblr.com/post/44638298912/how-to-not-screw-up-your-data
3rd International Open Data Conference 2015
Kate Crawford: Thinking about data
Nick Diakopoulos
http://www.nickdiakopoulos.com/
Open Government Analytics
http://open.canada.ca/en/content/open-government-analytics
Open Data Policy Comparison: Best Practices https://docs.google.com/spreadsheet/ccc?key=0Ap0CEAgs-R_odFc0Qk1WNHdIUDE3bUNVd1U3WUlnblE&usp=drive_web#gid=8
Open Data Institute (U.K)
Open Data Research Symposium: Shaw Centre, Ottawa, May 27th 2015
http://www.digitaljournal.com/pr/2563300
Open Government: Collaboration, Transparency, and Participation in Practice
http://www.amazon.ca/Open-Government-Collaboration-Transparency-Participation/dp/0596804350
http://radar.oreilly.com/2013/01/open-government-files-released.html
Open data: Unlocking innovation and performance with liquid information
Open Data User Group (the U.K.)
https://www.gov.uk/government/groups/open-data-user-group
Oxford Internet Institute
“Raw Data Is An Oxymoron”
http://www.amazon.com/dp/0262518287
Research project: Open Data Barometer (World-wide)
http://www.opendataresearch.org/project/2013/odb
Speaking notes for the Honourable Tony Clement, President of the Treasury Board, to the International Open Data Conference
http://news.gc.ca/web/article-en.do?mthd=advSrch&crtr.page=1&crtr.dpt1D=6694&nid=981299
The New Ambiguity of ‘Open Government’ (Social Science Research Network)
http://papers.ssrn.com/sol3/papers.cfm?abstract_id=2012489
The Rhetoric of Data (Nicholas Diakopoulos, Tow Center for Digital Journalism)
http://towcenter.org/the-rhetoric-of-data/
UK open government data: the results of the official audit
http://www.theguardian.com/news/datablog/2012/apr/18/uk-open-government-data-national-audit-office
Wikibon Blog
http://wikibon.org/blog/big-data-statistics/
Why the wealthiest countries are also the most open with their data (The Washington Post)
OPEN DATA STORIES(Top)
Alberta government offering prize for app design
http://www.edmontonsun.com/2015/07/17/alberta-government-offering-prize-for-app-design
Alberta’s open data catalogue rapidly expands, spawning dozens of new apps
http://metronews.ca/news/calgary/1425479/albertas-open-data-catalogue-rapidly-expands-spawning-dozens-of-new-apps/
Alberta parents show a love of the land when naming their kids. Say hello to Mountain and Prairie.
http://www.edmontonjournal.com/Alberta+parents+show+love+land+when+naming+their+kids+hello+Mountain+Prairie/11215773/story.html
Bringing Canada’s access to information back from the brink
http://www.thestar.com/news/canada/2015/09/11/bringing-canadas-access-to-information-back-from-the-brink.html
City data opens up; machine-readable documents available on Open Data site
http://www.winnipegsun.com/2015/09/16/city-data-opens-up-machine-readable-documents-available-on-open-data-site
City of Lethbridge launches innovative Open Data Catalogue online
http://globalnews.ca/news/2364381/city-of-lethbridge-launches-innovative-open-data-catalogue-online/
DriveBC data now online and open for business
http://www.voiceonline.com/drivebc-data-now-online-and-open-for-business/
Greater Sudbury: City debuts open data
http://www.thesudburystar.com/2015/07/15/city-debuts-open-data
City’s 311 hotline faces a new challenge: suicide calls
http://www.thestar.com/news/insight/2015/07/05/citys-311-hotline-faces-a-new-challenge-suicide-calls.html
Communitech to launch Open Data Exchange in Waterloo
http://www.therecord.com/news-story/5633195-communitech-to-launch-open-data-exchange-in-waterloo/
Grey County opens up with new Open Data initiative
http://www.simcoe.com/news-story/5633152-grey-county-opens-up-with-new-open-data-initiative/
Calgary-based app maps out sports fields and courts
http://metronews.ca/news/calgary/1372887/calgary-based-app-maps-out-sports-fields-and-courts/
Edmonton launches 311 explore website
http://www.edmontonsun.com/2015/02/19/edmonton-launches-311-explore-website
GRT buses miss the mark 20 per cent of the time
http://www.therecord.com/news-story/5812751-grt-buses-miss-the-mark-20-per-cent-of-the-time/
How the quest for a bike collision map opened up city data in Edmonton
Interactive map tracks rainfall in the Edmonton area in real time
http://globalnews.ca/news/2108542/interactive-map-tracks-rainfall-in-the-edmonton-area-in-real-time/
http://www.edmonton.ca/city_government/news/gauge-the-storm-with-rainfall-data.aspx
Harper Government Announces Funding to Establish the Open Data Exchange
http://www.techvibes.com/blog/open-data-exchange-2015-05-20
How the quest for a bike collision map opened up city data in Edmonton
How Unique is the New U.S. Open Data Policy?https://sunlightfoundation.com/blog/2013/05/13/how-unique-is-the-new-u-s-open-data-policy/
EDITORIAL: Let the sun shine on government information
http://thechronicleherald.ca/editorials/1329328-editorial-let-the-sun-shine-on-government-information
Lowertown group pushes for neighbourhood crime data
http://www.ottawacommunitynews.com/news-story/5769235-lowertown-group-pushes-for-neighbourhood-crime-data/
Local schools open to data
http://www.sherwoodparknews.com/2015/05/28/local-schools-open-to-data
New York City Transit Authority Takes a Ride with OpenText
http://www.newswire.ca/news-releases/new-york-city-transit-authority-takes-a-ride-with-opentext-518024001.html
New Vancouver website will help renters find good landlords
http://globalnews.ca/news/2010721/new-vancouver-website-will-help-renters-find-good-landlords/
News from the Office of Statistics and Information (OSI)
http://www.finance.alberta.ca/aboutalberta/osi/index.html
Missed garbage pickup complaints rise in east, fall in west
http://www.thestar.com/news/gta/2015/07/09/missed-garbage-pickup-complaints-rise-in-east-fall-in-west.html
Montreal embraces new ‘open by default’ data policy
http://montrealgazette.com/news/local-news/montreal-embraces-new-open-data-policy
Montréal, Smart and Digital City – Reform of the Open Data Policy: Montréal adopts an “open by default” approach
http://www.newswire.ca/news-releases/montreal-smart-and-digital-city—reform-of-the-open-data-policy-montreal-adopts-an-open-by-default-approach-538028351.html
NCC looking to ‘push the envelope’ on openness, CEO says
http://ottawacitizen.com/news/local-news/mark-kristmanson-shares-thoughts-on-ncc
Obama promotes online search tool with college-specific data to aid families in school choice
http://www.canadianbusiness.com/business-news/scrapping-plan-for-a-system-to-rate-colleges-obama-unveils-a-redesigned-higher-ed-search-tool/
Online Parry Sound business directory officially launched
http://www.parrysound.com/news-story/5818992-online-parry-sound-business-directory-officially-launched/
Ontario Deficit $2.2 Billion Lower Than Projected
http://news.ontario.ca/tbs/en/2015/09/ontario-deficit-22-billion-lower-than-projected.html
Open Data Exchange aimed at helping firms commercialize public sector data sets
http://www.thestar.com/news/gta/2015/07/09/missed-garbage-pickup-complaints-rise-in-east-fall-in-west.html
Ontario Making Data Open by Default:New Open Data Directive Drafted with Feedback from Ontarians
http://news.ontario.ca/tbs/en/2015/11/ontario-making-data-open-by-default.html
Open government manager puts his Best face forward
http://www.guelphmercury.com/news-story/5816017-open-government-manager-puts-his-best-face-forward/
P.E.I. landmarks project looking for public input
http://www.cbc.ca/news/canada/prince-edward-island/landmarks-open-data-map-1.3332428
Premier issues order to save emails after blistering report
http://www.timescolonist.com/premier-issues-order-to-save-emails-after-blistering-report-1.2093960
Prime Minister Releases Guide for Ministers
http://www.marketwired.com/press-release/prime-minister-releases-guide-for-ministers-2077429.htm
http://pm.gc.ca/eng/news/2015/11/27/open-and-accountable-government
Promises of transparency easily eroded
http://www.timescolonist.com/opinion/columnists/les-leyne-promises-of-transparency-easily-eroded-1.2095913
Province Making Advances in Open Data
http://novascotia.ca/News/Release/?id=20150619004
Saint John launches open data pilot program for the public
http://www.cbc.ca/news/canada/new-brunswick/saint-john-open-data-program-1.3299609
Set the data free, Mr. Trudeau
https://ipolitics.ca/2015/12/08/set-the-data-free-mr-trudeau/
Small startup seizes opportunity with big data
http://www.thespec.com/news-story/5652398-small-startup-seizes-opportunity-with-big-data/
Stephen Gordon: There’s more to evidence-based policymaking than fixing the census
http://news.nationalpost.com/full-comment/stephen-gordon-theres-more-to-evidence-based-policymaking-than-fixing-the-census
UWindsor research team working to predict border delays
http://www.ourwindsor.ca/news-story/5788960-uwindsor-research-team-working-to-predict-border-delays/
Vanishing Canada: Why we’re all losers in Ottawa’s war on data
http://www.macleans.ca/news/canada/vanishing-canada-why-were-all-losers-in-ottawas-war-on-data/
Visualization, analysis, interactive maps and real-time graphics: HUFFPOST DATA
http://data.huffingtonpost.com/
Website coming to Vancouver will help renters find good landlords
http://globalnews.ca/news/2010721/new-vancouver-website-will-help-renters-find-good-landlords/
What does a Liberal government mean for Canada’s technology policy?
http://www.itworldcanada.com/article/what-does-a-liberal-government-mean-for-canadas-technology-policy/377808
Read more: http://www.itworldcanada.com/article/what-does-a-liberal-government-mean-for-canadas-technology-policy/377808#ixzz3preCVrlV
or visit http://www.itworldcanada.com for more Canadian IT News
Why do downtown councillors get all the online attention?http://www.thestar.com/news/city_hall/2015/07/17/why-do-downtown-councillors-get-all-the-online-attention.html
Winning apps make government data more accessible
http://www.stonyplainreporter.com/2015/08/21/winning-apps-make-government-data-more-accessible
PEOPLE FINDERS(TOP)
Accurint (LexisNexis)
Spokeo
Facebook Graph Search is a “journalist’s rolodex”
http://socialtimes.com/facebooks-vadim-lavrusik-on-why-facebook-is-a-journalists-rolodex_b125949
LinkedIn for Journalists
http://www.linkedin.com/groups/LinkedIn-Journalists-3753151
FAIR ( Federal Accountability Initiative for Reform)
Blue Book (University of Toronto)
http://www.bluebook.utoronto.ca/
Exerpts on Call (University of Ottawa)
http://www.media.uottawa.ca/mediaroom/experts.html
Experts on Call (Carleton University)
http://newsroom.carleton.ca/experts/
Experts on Call (Dalhousie University)
Ixquick International Phone Books
Canada 411
http://canada411.sympatico.ca/
411.ca
Find a Postal Code (Canada Post)
http://www.canadapost.ca/cpotools/apps/fpc/personal/findByCity?execution=e1s1
YellowPages.ca
VitalCheck (a source for U.S. government-certified vital records)
Area Code Listing, by Number
http://www.bennetyee.org/ucsd-pages/area.html
PeopleSearch.net
Legacy.com (obituary searches)
Omgili forum search engine
Icerocket
Thoora
AnyWho directory
http://www.anywho.com/international.html
Free Public Records (access to more than 5,000 U.S. public record databases)
http://publicrecords.searchsystems.net
Obituaries
http://www3.sympatico.ca/bkinnon/obit_links2.htm
http://obits.rootsweb.com/cgi-bin/obit.cgi
Usenet archives
http://usenet-addresses.mit.edu/
Bar-eX ( property searches in Ontario )
https://www.bar-ex.com/barex/appmanager/bx/on?_nfpb=true&_pageLabel=services
IPAddressGuide.com
http://www.ipaddressguide.com/
IP Address Lookup
What is my IP address
Flickr.com
Myspace
Xanga
Friendster
Twitter tools
Yoname
Canada Background Checks
http://www.infocheckusa.com/canada-background-check.htm
eFindOutTheTruth.com (A Canadian site described as a “do-it-yourself “net-detective” software or unlimited “membership” type of company”)
http://www.efindoutthetruth.com/canada.htm
BackCheck (A Canadian site described as specializes in pre-employment background checks, including Criminal Record Checks, Credit Bureau Inquiries)
Lifenews.ca
http://www.lifenews.ca/waterloorecord/home
PHOTOJOURNALISM(TOP)
Canadian Association of Journalists’ 2003 photojournalism award
http://www.caj.ca/mediamag/awards2004/cajAwards/theAwards/08_photoJ/index.html
Canadian Association of Journalists’ 2004 photojournalism award
http://www.caj.ca/mediamag/awards2005/Pages/Photojournalism.htm
Canadian Association of Journalists’ 2005 photojournalism award
http://www.caj.ca/mediamag/awards2006/pages/Photojournalism.htm
Canadian Association of Journalists’ 2006 photojournalism award
Louie Palu
Sports Shooter
http://www.sportsshooter.com/members.html?id=965
The best photographs of 2008
http://www.j-source.ca/english_new/detail.php?id=3134
Sarah Moffat Imagery
http://www.sarahmoffatimagery.com/
World Press Photo
http://www.worldpressphoto.org/?bandwidth=high
World Press Photo
http://www.enterworldpressphoto.org/
Mundo Sport Images
http://www.mundosportimages.com/
POLITICS(TOP)
The Hill ( a blog on U.S. politics )
PolitiFact.com
POLLING(TOP)
Evaluating the Polls: an Open Letter to Ontario’s Journalists (an article on the Ipsos website)
http://www.ipsos-na.com/news-polls/pressrelease.aspx?id=5336
Fundamentals of Polling-Glossary of Terminology
http://www.ropercenter.uconn.edu/education/polling_fundamentals_glossary.html
POPULATION STATISTICS(TOP)
Census profile (Statistics Canada)
http://www12.statcan.ca/census-recensement/2011/dp-pd/prof/index.cfm?Lang=E
Detailed Tables – Registered Indian Population by Sex and Type of Residence by Group, Responsibility Centre and Region 2011 – Ontario
https://www.aadnc-aandc.gc.ca/eng/1351774203440/1351774405311
Selected trend data for Canada, 2006, 2001 and 1996 censuses (Statistics Canada)
Statistics Canada census data ( from 2001 and 2006 censuses)
2011 Census topics and release dates
http://www12.statcan.ca/census-recensement/2011/rt-td/rt-td-eng.cfm
Population by year, by province and territory (Statistics Canada)
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/demo02a-eng.htm?sdi=population
Population of census metropolitan areas (Statistics Canada)
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/demo05a-eng.htm
Statistics Canada (population and dwelling counts)
http://www12.statcan.ca/english/census06/data/popdwell/Tables.cfm
City of Ottawa (population stats)
Ottawa neighborhood information (The University of Ottawa)
http://www.geomatics.uottawa.ca/movies/naborhoods/mapindex.html
Nova Scotia Community Counts
http://www.gov.ns.ca/finance/communitycounts/default.asp
Census.IRE.ORG (Download bulk U.S. census data)
http://census.ire.org/data/bulkdata.html
UNHCR population statistics
http://popstats.unhcr.org/PSQ_POC.aspx
PREPARING STORIES(TOP)
Interviewing Tips
http://www.concernedjournalists.org/node/94
Interviewing
http://www.journalism.org/resources/tools/reporting/interviewing/tips.asp?from=print
Revelations from the Rocket on ’60 Minutes?’ Not likely (A John Swatsky analysis)
http://sports.espn.go.com/mlb/columns/story?id=3181572
Writing
http://www.nytimes.com/learning/general/specials/weblines/4.html
Carleton University Style Guide
http://newsroom.carleton.ca/wp-content/files/writing-style-guide.pdf
George Orwell’s Six Rules
To find Orwell’s rules, please click here.
The story process
http://www.journalism.org/resources/tools/writing/lessons/blackbox.asp?from=print
We are storytellers
PowerPoint presentation on getting away from numbers in order to tell great stories
Accuracy checklist
http://www.journalism.org/resources/tools/reporting/accuracy/mercury.asp?from=print
Grammar and punctuation
http://www.yorku.ca/ycom/style/
http://www.snn-rdr.ca/snn/nr_reporterstoolbox/snnstyleguide.html
Journalism ethics
http://www.poynter.org/subject.asp?id=32
Journalism Ethics Morals and the Media, 2nd edition, by Nick Russell (sample chapter)
http://www.ubcpress.ca/books/pdf/chapters/russell.pdf
Journalism Ethics for the Global Citizen (UBC School of Journalism)
http://www.journalismethics.ca/about_us/index.htm
The Canadian Press’s Copy Talk
http://www.thecanadianpress.com/books.aspx?id=186&terms=&searchtype=1&fragment=False
Don Gibb’s writing columns for Media magazine
PROVINCIAL AUDITS(TOP)
Alberta
British Columbia
http://www.bcauditor.com/auditorgeneral.htm
Manitoba
New Brunswick
Newfoundland and Labrador
Northwest Territories
Nova Scotia
Nunavut
http://www.gov.nu.ca/finance/public.shtml
Ontario
Prince Edward Island
http://www.assembly.pe.ca/auditorgeneral/
Quebec
Saskatchewan
Yukon
http://www.yukonenergy.ca/about/business/auditor_reports
PROVINCIAL CONTRACTS(TOP)
Alberta
http://vendor.purchasingconnection.ca/
British Columbia
http://www.bcbid.gov.bc.ca/open.dll/welcome
Quebec
https://www.seao.ca/index.aspx
Saskatchewan
http://www.sasktenders.ca/index.html
PROVINCIAL GOVERNMENTS(TOP)
http://www.canada.gc.ca/othergov/prov_e.htm
Government of Alberta (International Travel Expenses)|
http://alberta.ca/expenditure/expenditure.cfm?id=0
Links to provincial government directories
http://canadaonline.about.com/od/govtdirectories/Canadian_Government_Directories.htm
B.C. Online
https://www.bconline.gov.bc.ca/
Alberta Legislative Assembly
http://www.assembly.ab.ca/net/index.aspx?p=adr_home
British Columbia Legislative Assembly
Manitoba Legislative Assembly
http://www.gov.mb.ca/legislature/hansard/
Newfoundland and Labrador House of Assembly
http://www.hoa.gov.nl.ca/hoa/business/
New Brunswick Legislative Assembly
http://www.gnb.ca/legis/business/currentsession/currentsession-e.asp
Nova Scotia Legislative Assembly
http://www.gov.ns.ca/legislature/house_business/hansard.html
Northwest Territories Legislative Assembly
http://www.assembly.gov.nt.ca/hansard/
Nunavut Legislative Assembly
http://www.assembly.nu.ca/english/index.html
Ontario Legislative Assembly
http://www.ontla.on.ca/hansard/
http://www.ontla.on.ca/web/house-proceedings/house_current.do
Prince Edward Island Legislative Assembly
http://www.assembly.pe.ca/hansard/
Quebec National Assembly
Saskatchewan Legislative Assembly
http://www.legassembly.sk.ca/hansard/
Yukon Legislative Assembly
PUBLIC ACCOUNTS(TOP)
Public Accounts ( Federal )
http://www.tpsgc-pwgsc.gc.ca/recgen/cpc-pac/2014/index-eng.html
http://open.canada.ca/data/en/dataset?q=public+accounts
Public Accounts ( Ontario )
https://www.ontario.ca/page/public-accounts-ontario
Lapsed federal spending $2B higher than expected last year
http://www.cbc.ca/news/politics/lapsed-federal-spending-2b-higher-than-expected-last-year-1.3359378
Tories left $9.5 billion in approved funds untouched to avoid deficit during election year
http://news.nationalpost.com/news/canada/tories-left-9-5-billion-in-approved-funds-untouched-to-avoid-deficit-during-election-year
Military lost $1.5 million in uniforms last year
http://www.thestar.com/news/canada/2015/12/12/military-lost-15-million-in-uniforms-last-year-documents.html
PUBLIC HEALTH(TOP)
DineSafe (the city of Toronto’s Food Premises Inspection and Disclosure System)
http://app.toronto.ca/food2/index.jsp
Community Acquired Infections Division (The Public Health Agency of Canada)
http://www.phac-aspc.gc.ca/std-mts/sti-its_tab/index-eng.php
http://www.phac-aspc.gc.ca/std-mts/sti-its_tab/chlamydia1991-07-eng.php
http://www.phac-aspc.gc.ca/std-mts/sti-its_tab/gonorrhea1980-07-eng.php
http://www.phac-aspc.gc.ca/std-mts/sti-its_tab/syphilis1993-07-eng.php
http://www.phac-aspc.gc.ca/std-mts/stdcases-casmts/cases-cas-08-eng.php
Reportable Diseases by Year for Ottawa Residents (The city of Ottawa)
PUBLICATION FINDERS(TOP)
bNet
http://findarticles.com/p/articles/an_1/?tag=wrapper;width
PUBLIC POLICY ORGANIZATIONS(TOP)
Atlantic Institute for Market Studies
http://www.aims.ca/en/home/default.aspx
Bennett Jones
Canadians for Tax Fairness
http://www.taxfairness.ca/front
Canadian Policy Research Networks
Canadian Centre for Policy Alternatives
http://www.policyalternatives.ca/
Canadian Institute for Advanced Research
Centre for International Policy Studies ( Universit of Ottawa)
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
Public Policy Options
http://policyoptions.irpp.org/author/emacfarlane/
OpenMedia.ca
Congressional Research Service (The “Congress’s think tank” is the public policy research arm of the United States)
Congressional Budget Office (Provides economic data to the U.S. Congress)
Government Accountability Office (the audit, evaluation and investigative arm of the U.S. Congress)
The British Psychological Society
http://www.bps.org.uk/publications/journals
READINGS(TOP)
Working the fringes
http://www.cjr.org/issues/2005/6/cunningham.asp
Journalism trends in Canada
Public journalism in a Canadian context
The elements of journalism
http://www.journalism.org/resources/publications/books/elements_intro.asp
The quest for context
http://www.caj.ca/mediamag/winter2002/tools.html
Inspiration
Tips for rediscovering your passion for story telling
`Right to Know’ Series — Toronto Star
Please click here to read the articles
Report Card on Canadian News Media
http://www.cmrcccrm.ca/english/reportcard2004/01.html
2005 Report on state of the media
http://www.stateofthenewsmedia.org/2005/index.asp
2008 List of Banished Words
http://www.lssu.edu/banished/discuss/?p=20
Banishment Word List Archive
http://www.lssu.edu/banished/archived_lists.php
Election Coverage
http://www.ompp.mcgill.ca/pages/2006election.htm
SCIENCE(TOP)
Science Media Centre of Canada (SMCC)
http://www.sciencemediacentre.ca/smc/index.php?lang=en
Social Science and Humanities Research Council of Canada (SSHRC)
http://www.sshrc.ca/web/home_e.asp
The Canadian Research Information System
http://webapps.cihr-irsc.gc.ca/cris/Search?p_language=E&p_version=CRIS
Science-related search engines ( in French and English )
http://sdis.inrs.uquebec.ca/index.jsp?page=5_3#statistiques
The National Academies Press (U.S)
SEARCH AND RESCUE(TOP)
Civil Air Search and Rescue Association
Canadian Beacon Registry
https://www.cbr-rcb.ca/cbr/presentation/other_autre/index.php?lang=en
Canadian Owners and Pilots Association
International Cospas-Sarsat Programme
https://www.cospas-sarsat.org/
International Cospas-Sarsat Programme Beacon Regulations
http://www.cospas-sarsat.org/en/cospas-sarsat-documentation/sdocs
National Search and Rescue Secretariat
http://www.nss-snrs.gc.ca/en/index.page
National Oceanic and Atmospheric Administration Search and Rescue Satellite Aided Tracking
http://www.sarsat.noaa.gov/406vs121.pdf
Quadrennial Search and Rescue Review – Report
Fixed-Wing Search and Rescue Aircraft Replacement (FWSAR) Project
http://www.tpsgc-pwgsc.gc.ca/app-acq/stamgp-lamsmp/svtvn-rscfw-eng.html
SEARCHABLE ONLINE WEBSITES(TOP)
Adverse Events (A U.S. website that tracks adverse drug reactions in real time)
http://www.adverseevents.com/drugs.php
Drug and health product inspections
SearchSystems.net
Arms Exports (Industry Canada)
http://strategis.ic.gc.ca/sc_mrkti/tdst/tdo/tdo.php#tag
Arms Exports ( Foreign Affairs and International Trade Canada)
Canadian Environmental Assessment Registry
http://www.ceaa-acee.gc.ca/050/index_e.cfm
Charities (Note: click on the “Download results” tab on the left-hand side inorder to save the database)
http://www.cra-arc.gc.ca/ebci/haip/srch/sec/SrchInput01Validate-e#pageControl
Elections Canada
http://www.elections.ca/scripts/webpep/fin/select_search_option.aspx
Federal Contaminated Sites Inventory
http://www.tbs-sct.gc.ca/fcsi-rscf/home-accueil.aspx?Language=EN&sid=wu825155318360
Health Canada’s Adverse Drug Reaction Database
http://www.hc-sc.gc.ca/dhp-mps/medeff/databasdon/index-eng.php#a1
Health Canada’s Drug Product Database
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/databasdon/index_e.html
Lobbyists ( registered with the federal government )
Rapid Fire ( the Ottawa Citizen’s searchable online gun registry database )
http://www.canada.com/ottawacitizen/features/rapidfire/form.html
Transport Canada (Air safety)
http://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/q.aspx?lang=eng
Vehicle recalls on-line database ( Transport Canada )
http://wwwapps.tc.gc.ca/Saf-Sec-Sur/7/VRDB-BDRV/search-recherche/menu.aspx?lang=eng
Vehicle recalls on-line database (Department of Transportation)
http://www-odi.nhtsa.dot.gov/recalls/recallsearch.cfm
http://www-odi.nhtsa.dot.gov/downloads/index.cfm
DineSafe (the city of Toronto’s Food Premises Inspection and Disclosure System)
http://app.toronto.ca/food2/index.jsp
Data Planet (The Data Planet is a resource for searchable databases or interactive maps from the Pioneer Press, government agencies and non-profit organizations.)
http://www.twincities.com/dataplanet
Publc Service Staff Relations Board (search decisions)
SEARCH ENGINE RESEARCH(TOP)
Research Strategies: Finding Your Way through the Information Fog. William B. Badke. 2d ed. iUniverse, 2004.
http://www.acts.twu.ca/lbr/preface.htm
Search Engine Watch
DegreeTutor
http://www.degreetutor.com/library/research-tools/librarian-searchguide
Lycos
http://www.lycos.com/info/search-engines-list.html
SECURITY(TOP)
Currently listed entities (Public Safety Canada’s list and explanation of
terror groups)
http://www.publicsafety.gc.ca/cnt/ntnl-scrt/cntr-trrrsm/lstd-ntts/crrnt-lstd-ntts-eng.aspx
SENIOR’S CARE(TOP)
Offlimits (CBC News investigation into the continued use of atypical antipsychotics in seniors)
http://www.cbc.ca/news/background/seniorsdrugs/off-limits.html
http://www.cbc.ca/health/story/2009/01/09/anti-psychotic-risks.html?ref=rss
Beaten Down: Fear and Violence in Canada’s Nursing Homes (CBC News investigation into nursing homes)
http://www.cbc.ca/news/background/nursing-homes/index.html
Advocates call for inquiry into nursing home chain collapse
http://www.cbc.ca/canada/story/2009/03/23/ontario-royal-crest-nursing-home.html
Care and Attention (Vancouver Sun investigation into nursing homes)
http://www.canada.com/vancouversun/features/care/index.html
Long-Term Care Medical Directors Association of Canada
Reports on Long-Term Care Homes ( Ontario )
http://publicreporting.ltchomes.net/en-ca/default.aspx
Quebec long-term care inspections
http://www.msss.gouv.qc.ca/sujets/organisation/visites_appreciation/visites.php
The Ministère de la Famille et des Aînés (Quebec)
Residential care facilities ( B.C. )
http://www2.vpl.vancouver.bc.ca/DBs/RedBook/orgPgs/3/3248.html
The Care Guide (calls itself “Canada’s most comprehensive guide to seniors’ housing and care services”)
http://www.thecareguide.com/Search.aspx
Aging and Seniors (Public Health Agency of Canada)
http://www.phac-aspc.gc.ca/seniors-aines/index_pages/aboutus_e.htm
Elder Advocates Of Alberta Society
http://www.elderadvocates.ca/index.php
The Canadian Institute for Health Information (nursing home study)
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=PG_1170_E&cw_topic=1170&cw_rel=AR_2129_E
MEDICARE, The Official U.S. Government Site for People with Medicare
The Canadian Institute for Health Information (nursing home study)
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=PG_1170_E&cw_topic=1170&cw_rel=AR_2129_E
The Senior Brigade (A Michigan Seniors’ website)
SOCIAL MEDIA(TOP)
HerdictWeb (A Harvard University project chronicling potential censorship of the Web around the world)
Renesys (Internet monitoring firm)
Dipity
Storify
Storyful
ComScore
PoliTwitter (Track what federal politicians are saying on social media)
Archiving tweets isn’t as easy as it seems (Reporter’s Lab)
http://www.reporterslab.org/twitter-archiver/
How Emergent founder Craig Silverman is using data to hunt down online hoaxes
SPORTS(TOP)
Canadian Interuniversity Sport
http://english.cis-sic.ca/information/members_info/research_stats
SPREADSHEET TUTORIALS(TOP)
A Brief History of Spreadsheets
http://www.cs.umd.edu/class/spring2002/cmsc434-0101/MUIseum/applications/spreadsheethistory1.html
http://dssresources.com/history/sshistory.html
How journalists can use Excel to organize data for stories (The Poynter Institute)
Microsoft Support
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
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/
How to use Excel – The top formulas and functions you need to know
https://www.avidian.com/resources/how-to-use-excel
Math for Journalists
http://www.newsu.org/courses/course_detail.aspx?id=nu_math05
InflationData.com
http://inflationdata.com/inflation/
Ozgrid.com
CARstat
http://www.unc.edu/~pmeyer/carstat/index.html
Spreadsheet tutorial from Computer-Assisted Reporting: A Pratical Guide, 3rd edition, by Brant Houston
http://www.ire.org/carbook/chapter3/referredData/crony.xls
Nilesonline (a simple guide to understanding statistics)
Spreadsheet tutorial
Introduction to spreadsheets
http://www.cmu.edu/computing/education/excel/Excel2003/index.htm
Daily Dose of Excel
Jon Peltier’s Excel Page
Pearson Software Consulting
http://www.cpearson.com/excel.htm
Stephen Bullen’s Excel Page
David McRitchie’s Excel Pages
www.mvps.org/dmcritchie/excel/excel.htm
Mr. Excel
About.com:Spreadsheets
Microsoft.public.excel
http://groups.google.ca/group/microsoft.public.excel/topics?lnk=sg&hl=en
The City of Ottawa budget in Excel format
STORIES ABOUT ACCESS TO INFORMATION(TOP)
The Calgary Herald (editorial)
How to lead a more transparent government
STATISTICS CANADA EMPLOYMENT AND UNEMPLOYMENT TABLES (TOP)
Documentation – Labour Force Survey (LFS)
Employment by industry
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/econ40-eng.htm
Employment, payroll employment, by industry
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/cst01/labr71a-eng.htm
Labour Force Survey (LFS)
http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=3701#a5
Major wage settlements, by region and/or jurisdiction
http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&p2=33&id=2780008
Major wage settlements, by major industry division
http://www5.statcan.gc.ca/cansim/pick-choisir?lang=eng&p2=33&id=2780007#F1
Tables by subject: Employment and unemployment
http://www.statcan.gc.ca/tables-tableaux/sum-som/l01/ind01/l3_2621_1803-eng.htm?hili_econ40
STORIES ABOUT INVESTIGATIVE JOURNALISM(TOP)
What 2011 holds for investigative reporting (The Poynter Institute)
The best journalism-job want ad ever ever (Mother Jones)
STORIES USING DATA FROM OPEN-DATA WEBSITES (TOP)
Cats have tougher lives than dogs in Toronto: analysis
http://www.thestar.com/news/gta/2015/07/31/cats-have-tougher-lives-than-dogs-in-toronto-analysis.html
Dogs of NYC
http://project.wnyc.org/dogs-of-nyc/
Maps: Who are the dogs in your Toronto neighbourhood? (Global News)
http://www.globalnews.ca/Pages/Story.aspx?id=6442522298
Missed garbage pickup complaints rise in east, fall in west
http://www.thestar.com/news/gta/2015/07/09/missed-garbage-pickup-complaints-rise-in-east-fall-in-west.html
This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press)
http://www.thestar.com/news/gta/2014/08/11/this_fire_hydrant_costs_toronto_drivers_the_most_in_parking_tickets.html
Why do downtown councillors get all the online attention?http://www.thestar.com/news/city_hall/2015/07/17/why-do-downtown-councillors-get-all-the-online-attention.html
STUDENT INVESTIGATIONS(TOP)
Hidden Profits, Student Debt (Columbia City Paper)
http://www.columbiacitypaper.com/2010/06/16/hidden-profits-student-debt/
University of King’s College
http://investigative.kingsjournalism.com/
http://algonquintimes.com/news/illicit-invitation/
TABLEAU(TOP)
Tableau Public ( a free application that helps to visualize data )
http://www.tableausoftware.com/public/gallery
http://www.tableausoftware.com/public/ire
Installing the Tableau Add-In for Reshaping Data in Excel
http://kb.tableausoftware.com/articles/knowledgebase/addin-reshaping-data-excel
Tableau tutorials
Installing the Tableau Add-In for Reshaping Data in Excel
http://kb.tableausoftware.com/articles/knowledgebase/addin-reshaping-data-excel
TABLEAU — STORIES(TOP)
Population Growth and Decline in Puget Sound
http://public.tableausoftware.com/profile/cephillips#!/vizhome/PugetSoundcensus/Dashboard
Station Crime Report
http://public.tableausoftware.com/profile/sarah.ryley#!/vizhome/MTAstationviz/Light
Housing Project Report Card
http://public.tableausoftware.com/profile/sarah.ryley#!/vizhome/MTAstationviz/Light
TRADE(TOP)
Canadian Import and Export Stats (Industry Canada)
http://strategis.ic.gc.ca/sc_mrkti/tdst/tdo/tdo.php#tag
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
AGCanada
http://www.agcanada.com/daily/
The Western Producer
PennEnergy
http://www.pennenergy.com/oil-gas/more-oil-gas-wire-news.html
The Packer: Covering the fresh produce industry since 1893
http://www.thepacker.com/fruit-vegetable-news/Canada-mulls-inspection-fee-increase-200913761.html
ReNew Canada (The Infrastructure Magazine)
Oilprice.com
Engineering and Technology Magazine
TRANSPORTATION(TOP)
Air
Aviation Safety Letters
http://www.tc.gc.ca/eng/civilaviation/publications/tp185-menu-5395.htm
Secret Skies (A CBC News investigation into air safety)
http://www.cbc.ca/news/secretskies/
Aviation safety investigations database (CBC News extract of helicopter misshaps from CADORS)
http://www.cbc.ca/news/interactives/helicopter-database/index.html
Number of reported bird strikes at Windsor airport soars (The Windsor Star)
http://blogs.windsorstar.com/2013/05/13/number-of-reported-bird-strikes-at-windsor-airport-soars/
Search for Complaints (the U.S. National Highway Traffic Safety Administration )
http://www-odi.nhtsa.dot.gov/complaints/
Top-secret measures taken over possible explosives at Pearson (CBC News Investigation)
http://www.cbc.ca/canada/story/2010/01/12/airport-security-pearson.html?ref=rss
Transport Canada: Civil Aviation Daily Occurrence Reporting System (CADORS)
http://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/q.aspx?lang=eng
TP 185 – Aviation Safety Letter (The Aviation Safety Letter (ASL) is published quarterly by Transport Canada, Civil Aviation)
http://www.tc.gc.ca/eng/civilaviation/publications/tp185-menu-5395.htm
LaserPointerSafety.com
http://www.laserpointersafety.com/how2reduceincidents/pilots/pilots.html
Skybrary (billed as “the single point reference for aviation safety knowledge”)
http://aviationsafetywiki.org/index.php/Main_Page
LiveAtc.net (Live Air Traffic – From their headsets to you)
http://www.liveatc.net/archive.php
Live Flight Tracking
http://flightaware.com/live/flight/JZA862
Planesregister.com
Transport Canada: Bird Strike Summary Reports
National Wildlife Strike Database ON-LINE (The United States)
http://wildlife.pr.erau.edu/public/index.html
Bird Strike Committee Canada
http://www.birdstrikecanada.com/
Safeskies.ca
FlightPilotFatigue
http://fightpilotfatigue.tumblr.com/
Links to Canadian Airport Authorities
http://www.tc.gc.ca/programs/airports/caa.htm
Canadian list of airports ( Transport Canada)
http://www.tc.gc.ca/programs/airports/status/menu.htm
Transport Canada: Corporate Offenders Enforcement Action Summaries
http://www.tc.gc.ca/CivilAviation/standards/Enforcement/Publications/Corporate/summary.htm
Transport Canada Overview Reports
http://www.tc.gc.ca/pol/en/anre/menu.htm
Transport Canada (service difficulty reports)
Transport Canada (continuing airworthiness reports)
http://www.tc.gc.ca/eng/civilaviation/opssvs/managementservices-referencecentre-acs-500-menu-127.htm
Transportation Appeal Tribunal of Canada
http://www.tc.gc.ca/civilAviation/regserv/Appeals/Juris/amend/amend19/menu.htm
Transport Canada Flight Training Units
https://www.tc.gc.ca/aviation/activepages/ftae/index.aspx
Federal Aviation Administration (Canadian service diffciulty reports can be downloaded from this site thanks to an agreement between the FAA and Transport Canada)
http://av-info.faa.gov/dd_sublevel.asp?Folder=%5CSDRS
The Canadian Civil aircraft register year-end summaries
http://wwwapps2.tc.gc.ca/Saf-Sec-Sur/2/ccarcs/aspscripts/en/yearendsum.asp
http://wwwapps2.tc.gc.ca/saf-sec-sur/2/ccarcs/aspscripts/en/menu.asp
The Canadian Transportation Agency (Air Carrier Licence Search)
http://forms.cta-otc.gc.ca/AirLicences/Search_e.cfm
The Air Transport Association of Canada (ATAC)
Aviation service bulletin (Statistics Canada’s trends, including air carrier statistics, including number of passengers carried and kilometres travelled)
http://www.statcan.ca/english/freepub/51-004-XIE/51-004-XIE2008001.htm
Aircraft Movement Statistics (NAV CANADA Towers and Flight Service Stations )
http://www.statcan.ca/english/freepub/51-007-XIE/51-007-XIE2008001.htm
Transportation Safety Board of Canada
Pipeline investigation reports (Transportation Safety Board of Canada)
http://www.tsb.gc.ca/eng/rapports-reports/pipeline/
The Canadian Air Transport Security Authority (CATSA)
http://www.catsa.gc.ca/english/index.shtml
The Canadian Transportation Research Forum
The Air Line Pilots Association, International (ALPA)
http://alpa.org/Default.aspx?tabid=139
Aviation Safety & Security Digest
http://www.aviation-safety-security.com/homepage/about-us/index.php
Bill C-26 Home Page
http://cmte.parl.gc.ca/cmte/CommitteeWitnesses.aspx?Lang=1&PARLSES=391&JNT=0&SELID=e23_&COM=10462
Transport 2000
AVCANADA (a discussion forum on aviation in Canada)
http://www.avcanada.ca/forums2/viewtopic.php?f=54&t=40787&st=0&sk=t&sd=a&start=0
Flight Global
British Columbia Safety Council
http://www.safetycouncil.bc.ca/
Aviation Alberta
http://www.aviationalberta.com/
The Saskatchewan Aviaton Council
http://www.saskaviationcouncil.ca/
Manitoba Aviation Council
http://www.manitobaaviationcouncil.ca/
Ontario Region ( Transport Canada)
http://www.tc.gc.ca/OntarioRegion/civilaviation/system/seminars.htm
Quebec Air Transport Association
http://www.aqta.ca/en/default.asp?
Aviation Safety (Atlantic Region)
http://www.tc.gc.ca/atl/en/air/aviation_safety/menu.htm
North American Transportation Statistics Database
http://nats.sct.gob.mx/sys/index.jsp?i=3
The U.S. Federal Aviation Administration (FAA)
FAA airworthiness directives
U.S. aircraft register
http://www.faa.gov/aircraft/air_cert/aircraft_registry/
U.S. Department of Transportation
The U.S. Federal Aviation Administration (Aircrart Inquiries)
http://registry.faa.gov/aircraftinquiry/NNum_inquiry.asp
National Transportation Safety Board inventory of databases|
http://www.ntsb.gov/investigations/databases.html
The Family Assistance Foundation
http://www.fafonline.org/index.php
Pilot Getaways (U.S.)
The UK Civil Aviation Authority
Aviation Safety Network
http://aviation-safety.net/index.php
The International Air Transport Association (IATA)
International Civil Aviation Organization (ICAO)
International Aviation Safety Association (started by a relative of a victim of the Swissair disaster)
http://www.iasa.com.au/folders/menu/index.htm
Flight Safety Foundation
http://www.flightsafety.org/home.html
Flight Aware
Floweb.com
FareCompare.com
The Boeing 737 Technical Site
http://www.b737.org.uk/index.htm
ASIResource.com
http://www.asiresource.com/default.htm#contents
Marine
Vessel Register (Transport Canada)
http://wwwapps.tc.gc.ca/Saf-Sec-Sur/4/vrqs-srib/a.aspx?lang=e
MarineTraffic
http://www.marinetraffic.com/en/
Ground
Transport Canada Collision and Road Safety Statistics
http://www.tc.gc.ca/roadsafety/resources/researchstats/menu.htm#collisionstats
Road collision statistics (B.C.)
http://www.icbc.com/road-safety/safety-research/collision-statistics
Road collision statistics ( Saskatchewan )
http://www.sgi.sk.ca/sgi_pub/road_safety/trafficcollisionstats/index.htm
Road collision statistics (Newfoundland and Labrador)
http://www.tw.gov.nl.ca/CollisionStats/pamphlet.stm
Road collision statistics (Nova Scotia)
http://www.gov.ns.ca/tran/highwayops/stats.asp
Transport Canada:Vehicle Recalls On-Line Database
http://wwwapps.tc.gc.ca/saf-sec-sur/7/vrdb-bdrv/search/Search.aspx?lang=eng
Vessel registry
http://www.tc.gc.ca/ShipRegistry/menu.asp?lang=e
Autoglass search ( vehicle recall database )
http://www.autoglasssearch.com/articles/vehicle-recalls.htm
Ontario driver, vehicle information
http://www.mto.gov.on.ca/english/dandv/catalogue.htm
Ontario Road Safety Annual Report
http://www.mto.gov.on.ca/english/safety/orsar/
La Société de l’assurance automobile du Québec (SAAQ)
Driving Statistics for Nova Scotia’s department of Transportation and Infrastructure Renewal
http://www.gov.ns.ca/tran/highwayops/stats.asp
Annual Road Safety Reports (the city of Ottawa)
http://ottawa.ca/residents/onthemove/driving/road_safety/integrated/annual_reports/index_en.html
UNIVERSITY PUBLICATIONS(TOP)
Centretown News (Online)
http://www.carleton.ca//ctown/home/homeNew.htm
Off Centre
http://ottawaoffcentre.wordpress.com/
Hartwells (Living well in Ottawa)
http://hartwellsottawa.wordpress.com/
Convergence magazine (Humber College)
http://magazines.humber.ca/convergence2008/
Face Time (Mount Royal University News)
http://www.mtroyal.ca/facetime/FTDATA_journal_092310
The Canadian Journal of Media Studies (Faculty of Information and Media Studies at the University of Western Ontario in London, Ontario)
http://cjms.fims.uwo.ca/default.htm
U.S. GOVERNMENT(TOP)
The Whitehouse President Barak Obama
GPO Access (The Federal Depository Library Program Electronic Collection (FDLP/EC) is a comprehensive digital library of U.S. Government information)
http://www.access.gpo.gov/su_docs/fdlp/ec/
http://www.lib.lsu.edu/gov/alpha
Federal Audit Clearinghouse
Data.gov (datasets from top U.S. executive departments)
Data.gov (Raw data sets)
http://explore.data.gov/catalog/raw/
Sunlight Foundation Reporting Group (U.S. non-profit group that tracks federal spending)
http://reporting.sunlightfoundation.com/2010/ogd/
Federal Energy Regulatory Commission
http://www.ferc.gov/about/about.asp
U.S. Business (TOP)
National Bureau of Economic Research
Business Wire (U.S.)
EDGAR (U.S.)
http://www.sec.gov/cgi-bin/srch-edgar
SEC Filing Alerts
Morningstar Document Research (formerly 10-K Wizard)
Descriptions of 10-Ks, 10-Qs, 6-Ks and other forms companies are required to file with the SEC
http://www.sec.gov/info/edgar/forms/edgform.pdf
New York Stock Exchange
The National Association of Securities Dealers
http://www.nasd.com/web/idcplg?IdcService=SS_GET_PAGE&nodeId=6
The North American Securities Administrators Association
http://www.nasaa.org/home/index.cfm
Equilar (a firm that tracks executive and director compensation)
Standard & Poor’s
http://www2.standardandpoors.com/servlet/Satellite?pagename=sp/Page/HomePg&r=1&l=EN&b=10
Moody’s Investors Service
http://www.moodys.com/cust/default.asp
Dun & Bradstreet
Hoover’s Online
Financial Directory
Fast Company
http://www.fastcompany.com/homepage/index.html
Newslink
http://newslink.org/biznews.html
Business magazines
http://allyoucanread.com/index.asp?idCat=7
Facsnet
The McKinsey Quarterly
Sources and Experts
http://www.ibiblio.org/slanews/internet/experts.html
American Experts
http://www.journalismnet.com/experts/us.htm
The National Bureau of Economic Research
Searchable database for bills in Congress
U.S. Government Printing Office
The U.S. Food and Drug Administration’s archive of warning letters
http://www.accessdata.fda.gov/scripts/wlcfm/searchwl_new.cfm
FDA Recalls, Market Withdrawals and Safety Alerts
http://www.fda.gov/opacom/7alerts.html
FDA Enforcement Report Index
http://www.fda.gov/opacom/Enforce.html
Securities lawsuits
http://securities.stanford.edu/companies.html
Lawyers
Confined Space ( A U.S. site on workplace safety)
http://spewingforth.blogspot.com/
U.S. Department of LABOUR (Occupational Safety & Health Administration)
http://www.osha.gov/pls/imis/establishment.html
Power Reporting (resources for business journalists)
http://powerreporting.com/category/Beat_by_beat/Economics/
Reynolds Centre
http://businessjournalism.org/
Workforce Explorer Washington (state)
http://www.workforceexplorer.com/cgi/dataanalysis/?PAGEID=14
BNET Industries (A site for managers and executives)
http://www.bnet.com/2405-13071_23-41875.html
CorpWatch
http://www.corpwatch.org/index.php
Left Business Observer
http://www.leftbusinessobserver.com/
LBO News from Doug Henwood
http://doughenwood.wordpress.com/
Inequality.org
http://www.demos.org/inequality/
AlterNet
http://www.alternet.org/workplace/
ExportFocus.com
U.S. COURT FILINGS AND LEGAL ACTION(TOP)
Pacer
The Public Library of Law (U.S.)
http://www.plol.org/Pages/Search.aspx
Lexis
United States Department of Justice
http://www.usdoj.gov/index.html
United States Bankruptcy Courts
http://www.uscourts.gov/bankruptcycourts.html
Banktruptcy Data.com
CLB Media Inc. (A publisher of many trade magazines and other media services)
Transactional Records Access Clearinghouse ( TRAC is a data-gathering, data research and data distribution organization at Syracuse University)
http://trac.syr.edu/tracreports/bulletins/
VANCOUVER(TOP)
Stories about Entegrity Systems
Insolvency information about Entegrity
Sample foreclosurelist for Greater Vancouver
B.C. election campaign contribution data
VITAL STATISTICS/CERTIFICATES(TOP)
Statistics Canada
http://www.statcan.ca/english/Pgdb/
Canadian vital statistics offices
http://www.cbs.gov.on.ca/mcbs/english/4UBMCE.htm
Ontario births, deaths, marriages
http://www.cbs.gov.on.ca/mcbs/english/4ULUQT.htm
Ontario historical births, deaths, marriages
http://www.archives.gov.on.ca/english/interloan/vsfaq.htm
Ontario coroner’s reports
http://www.mpss.jus.gov.on.ca/english/pub_safety/office_coroner/coroner_how.html
Ontario wills
http://www.archives.gov.on.ca/english/virtualrr/info15.htm
Ontario divorce files
http://www.archives.gov.on.ca/english/guides/rg_210_divorce_ont.htm
Ontario land registration
http://www.cbs.gov.on.ca/mcbs/english/4UBSJK.htm
Ontario personal property registry
http://www.cbs.gov.on.ca/mcbs/english/269a_3ea2.htm
Ontario liens
http://www.cbs.gov.on.ca/mcbs/english/2502_3ea2.htm
Ontario fire deaths
http://www.ofm.gov.on.ca/english/publications/Statistics/deathrate/default.asp
WEBSCRAPING(TOP)
Downloadthemall
http://www.downthemall.net/
Firebug
http://getfirebug.com/
kimono
https://www.kimonolabs.com/
Outwit
http://www.outwit.com/
SiteSucker
http://sitesucker.en.softonic.com/mac
WEBSITES WITH TABLES FOR DOWNLOAD(TOP)
Ontario’s Public Sector Salary Disclosure
http://www.ontario.ca/government/public-sector-salary-disclosure
Alberta’s Public Sector Salary Disclosure
http://alberta.ca/SalaryDisclosure.cfm
http://data.alberta.ca/data/public-disclosure-salary-and-severance
Terrorism Financing (Office of the Superintendent of Financial Institutions Canada)
http://www.osfi-bsif.gc.ca/osfi/index_e.aspx?DetailID=525
Healthy Canadians
Food Recall Report (Downloadable food recalls from the Canadian Food Inspection Agency)
http://active.inspection.gc.ca/eng/corp/recarapp_dbe.asp
Dairy Facts and Figures (Canadian Dairy Information Centre)
http://dairyinfo.gc.ca/index_e.php?s1=dff-fcil#trade
Canadian International Merchandise Trade Database
http://strategis.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/home
Community Acquired Infections Division (The Public Health Agency of Canada)
http://www.phac-aspc.gc.ca/std-mts/sti-its_tab/index-eng.php
Data-Pass (Data Preservation Alliance for the Social Sciences)
Elections Canada
http://www.elections.ca/scripts/webpep/fin/select_search_option.aspx
Road Safety Vehicle Recalls (Transport Canada)
http://www.tc.gc.ca/eng/roadsafety/safevehicles-defectinvestigations-index-76.htm
http://data.gc.ca/data/en/dataset/1ec92326-47ef-4110-b7ca-959fab03f96d
Search for Complaints (the U.S. National Highway Traffic Safety Administration )
http://www-odi.nhtsa.dot.gov/complaints/
National Transportation Safety Board inventory of databases
http://www.ntsb.gov/investigations/databases.html
http://www-odi.nhtsa.dot.gov/downloads/
Women Candidates in General Elections (1921 to Date)
http://www.parl.gc.ca/information/about/process/house/asp/WomenElect.asp?Language=E&source=hoc
Quebec political contributions
Elections Ontario
http://www.elections.on.ca/en-CA/Tools/FinancialStatementsandContributions/RealTimeDisclosure.htm
Elections BC (Political Contributions System)
http://contributions.electionsbc.gov.bc.ca/pcs/SA1ASearch.aspx
Canadian charities ( Canada Revenue Agency )
http://www.cra-arc.gc.ca/chrts-gvng/lstngs/menu-eng.html
Federal lobbyists
Canada Foundation for Innovation ( all the grants awarded )
http://www.innovation.ca/projects/index.cfm
Transport Canada (road safety)
http://www.tc.gc.ca/eng/roadsafety/tp-tp3322-2004-menu-691.htm
Environment Canada’s National Pollutant Release Inventory (NPRI)
http://www.ec.gc.ca/pdb/websol/querysite/query_e.cfm
http://www.ec.gc.ca/inrp-npri/Default.asp?lang=En&n=0EC58C98-1
Canada’s Greenhouse Gas Inventory ( Environment Canada )
http://www.ec.gc.ca/pdb/ghg/onlinedata/DataAndReports_e.cfm
Greenhouse Gas Reporting Site ( glossary of terms )
http://www.ghgreporting.gc.ca/GHGInfo/Pages/page15.aspx
Contaminated sites in Quebec
http://www.mddep.gouv.qc.ca/sol/residus_ind/resultats.asp
ACOA Project Information (Atlantic Canada Opportunities Agency)
http://pub.acoa-apeca.gc.ca/atip/e/content/default.asp
Health Canada’s Adverse Drug Reaction Database
http://webprod3.hc-sc.gc.ca/arquery-rechercheei/index-eng.jsp
http://data.gc.ca/data/en/dataset/9cbaef00-b52c-4a70-9fed-d9aa8263ab74
The FDA’s Adverse Drug Reaction Database
DataGov
http://dirtdiggersdigest.org/enforcement
Navigate the world
of public data
European database of suspected adverse drug reaction reports
National Collision Database Online (Transport Canada)
http://wwwapps2.tc.gc.ca/Saf-Sec-Sur/7/NCDB-BNDC/p.aspx?l=en
Notice of Compliance Online Query
http://webprod5.hc-sc.gc.ca/noc-ac/index-eng.jsp
Notice of compliance ( drugs Health Canada has approved )
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/notices-avis/list/index_e.html#Weekly%20Updates
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/notices-avis/conditions/index-eng.php
Health Canada’s Register of Innovative Drugs for Pediatric use
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/applic-demande/regist/reg_innov_dr-eng.php
Drug Products Database ( all of the drugs Health Canada has approved for marketing)
http://www.hc-sc.gc.ca/dhp-mps/prodpharma/databasdon/dpd_bdpp_data_extract_e.html
Health Canada’s list of recalled drugs and medical devices
http://www.hc-sc.gc.ca/dhp-mps/compli-conform/recall-retrait/_list/index-eng.php
Health Canada’s list of recalled consumer products
http://cpsr-rspc.hc-sc.gc.ca/PR-RP/home-accueil-eng.jsp
Health Canada’s list of warnings, advisories and recalls (on marketed health products, including Natural Health Products and medical devices)
http://www.hc-sc.gc.ca/dhp-mps/medeff/advisories-avis/index-eng.php
Health Canada’s Licensed Natural Health Product Database (LNHPD)
http://www.hc-sc.gc.ca/dhp-mps/prodnatur/applications/licen-prod/lnhpd-bdpsnh_data_extract-eng.php
Treasury Board, Directory of the federal real estate properties
http://www.tbs-sct.gc.ca/dfrp-rbif/query_question/export-eng.aspx?qid=23174
CARinCanada
http://www.carincanada.ca/DATABASES.htm
Statistics Canada
http://www.statcan.gc.ca/start-debut-eng.html
Census (Statistics Canada)
http://www12.statcan.ca/english/census/index.cfm
Average Annual Percentage Wage Adjustments by Year (Human Resources and Skills Development Canada)
Income statistics (Canada Revenue Agency)
http://www.cra-arc.gc.ca/gncy/stts/ntrm-eng.html
Exploring Data (a tutorial for examining statistics)
http://exploringdata.cqu.edu.au/
Fatality Reports Database ( The Canadian Centre for Occupational Health and Safety)
http://www.ccohs.ca/products/databases/fatalityreports.html
Arms Exports
http://strategis.ic.gc.ca/sc_mrkti/tdst/tdo/tdo.php#tag
Complaint Statistics (Ontario Civilian Commission on Police Services for the years 2001 to 2005)
Canadian National Defence Contracts over $10,000
http://www.admfincs.forces.gc.ca/apps/dgca-dposc/dgcaoq-dposcst-eng.asp
RCMP Detachments – Telephone Numbers
http://www.rcmp-grc.gc.ca/html/generalcont_e.htm
City of Ottawa paramedic serives
http://www.ottawa.ca/residents/ambulance/structure_contact/operations/daily/stats_en.html
Office of Pipeline Safety (U.S.)
UJIMA project (U.S. site that contains Canadian data such as arms exports)
http://ujima-project.org/countries/34
SIPRI Arms Transfers Database
http://www.sipri.org/databases/armstransfers
Environmental Journalism Tipsheet
http://www.rtnda.org/resources/tipsheet/september26.shtml
Data Handbook ( city of Ottawa )
http://www.ottawa.ca/city_services/statistics/data_handbook/index_en.shtml
National Wildlife Strike Database ON-LINE
http://wildlife.pr.erau.edu/public/index.html
Health Inspection Orders (Alberta Health Services)
Datadot.gc.ca
DataBC
Transparency Tracker (Propublica)
http://projects.propublica.org/transparency/
National Data Catalogue ( the United States )
http://nationaldatacatalog.com/dashboard
The World Bank
Unofficial Open Data Ottawa
http://opendataottawa.pbworks.com/
Vaccine Adverse Event Reporting System (The U.S. Food and Drug Administration)
http://vaers.hhs.gov/data/data/
SeeThroughNY
http://www.seethroughny.net/Home/tabid/36/Default.aspx
Find NY state and local pensions (2010)
http://data.lohud.com/labor/retire_form_2010.php
AccountableCalifornia.org
http://accountablecalifornia.org/investigative-reports/
DataStore: World Government Data
http://www.guardian.co.uk/news/datablog/2010/jan/07/governm(TOP)
WEBSITES(TOP)
WORKPLACE SAFETY(TOP)
Canadian Centre for Occupational Health and Safety
Association of Workers’ Compensation Boards of Canada
Alberta Occupational Health and Safety Workplace Incident Fatalities
http://www.humanservices.alberta.ca/working-in-alberta/781.html#Incidents
Links to Workers’ Compensation Boards/Commissions
http://www.awcbc.org/en/linkstoworkerscompensationboardscommissions.asp
Enforcement Activities: Prosecution and Conviction Statistics (Ontario Ministry of Labour)
http://www.labour.gov.on.ca/english/es/pubs/enforcement/convictions.php
Workplace Safety Fines: Ontario Ministry of Labour (courtesy of CNW Group)
http://ogov.newswire.ca/getorg_e.html?okey=16716
http://www.labour.gov.on.ca/english/news/court_news.html
Workplace Safety Fines: Ontario Ministry of Labour (courtesy of the Occupational Safety Group)
http://67.69.16.62/fmi/iwp/cgi?-db=OSGCA&-loadframes
OHS CANADA Magazine
Farm Association (of Ontario)
http://www.farmsafety.ca/pages/annual_report.html
Laborsta (An International Labour Office database on labour statistics)
http://laborsta.ilo.org/default.html
U.S. Department of Labour Enforcement Data
http://ogesdw.dol.gov/views/data_summary.php
OSHA Workplace Safety Data (IRE)
http://ire.org/nicar/database-library/databases/osha-workplace-safety-data/
WRITING(TOP)
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)