890 likes | 914 Views
Data as News: Journalists’ Experiences in Seeking and Using Databases of Public Records Ira Chinoy Philip Merrill College of Journalism University of Maryland. How journalists use databases of public records The language of databases Elements of data requests
E N D
Data as News:Journalists’ Experiences in Seeking and Using Databases of Public RecordsIra ChinoyPhilip Merrill College of JournalismUniversity of Maryland
How journalists use databases of public records The language of databases Elements of data requests Obstacles, from the requesters’ perspective Core issues Alternatives to case-by-case confrontation?
How journalists use databases of public records The language of databases Elements of data requests Obstacles, from the requesters’ perspective Core issues Alternatives to case-by-case confrontation?
How journalists use databases of public records The language of databases Elements of data requests Obstacles, from the requesters’ perspective Core issues Alternatives to case-by-case confrontation?
How journalists use databases of public records The language of databases Elements of data requests Obstacles, from the requesters’ perspective Core issues Alternatives to case-by-case confrontation?
How journalists use databases of public records The language of databases Elements of data requests Obstacles, from the requesters’ perspective Core issues Alternatives to case-by-case confrontation?
How journalists use databases of public records The language of databases Elements of data requests Obstacles, from the requesters’ perspective Core issues Alternatives to case-by-case confrontation?
CNS stories using databases of public records: Consumer complaints Prison violence Boating safety enforcement Train accidents Amusement rides Subprime loans Unsolved homicides Leaking underground oil storage tanks Campaign finance Lawyer discipline
Terms: “database” “relational database” “tables” “records” “fields” “codes” “queries” “joins”
Making requests Background Database Electronic Copy Documentation Format Redaction News purpose Waiver Fees
Making requests Background Database Electronic Copy Documentation Format Redaction News purpose Waiver Fees
Making requests Background Database Electronic Copy Documentation Format Redaction News purpose Waiver Fees
Making requests Background Database Electronic Copy Documentation Format Redaction News purpose Waiver Fees
Making requests Background Database Electronic Copy Documentation Format Redaction News purpose Waiver Fees
Database and spreadsheet programs have their own unique file types (.xls, .mdb…). But data can easily be moved between one file type and another by exporting and importing it in standard formats: “dbase” (.dbf) “comma-delimited text” “fixed-length text”
Making requests Background Database Electronic Copy Documentation Format Redaction News purpose Waiver Fees