home / nicar

sessions

2 rows where location_room = 19

View and edit SQL

Link rowid event_id name clean_description location_room start_date_clean start_time end_time pre_reg_flag paid_flag laptop_flag speakers_cleaned session_type keywords skill_level session_title
145 4374 Lightning Talks Sometimes you don't need 45 minutes to explain a useful technique or interesting resource. Join your colleagues for a session of short (5-minute) talks. Here's the 2019 lineup: 1. How to write a data story in five minutes — Youyou Zhou 2. 5 ways to write racist code (with examples) —Alex Garcia 3. How to build a massive database that no one wants you to build — Disha Raychaudhuri 4. FOIA is my API — Matt Kiefer 5. 911, What’s Your Emergency: how insider knowledge of law enforcement has been an asset — Stacy Montemayor 6. How To Use Your Data Skills To Gain Financial Independence — Sean McMinn 7. My own worst enemy: Overcoming impostor syndrome* — Kate Martin 8. How to beat a serious case of the post-project blues — Christopher Baxter 9. Blindspotting: Covering communities you’re not a part of — Emmanuel Martinez 10. Save Student Newsrooms. How you can help the next generation of journalists — Caitlin Ostroff Lightning Talks is sponsored by the Knight Foundation. Grand Pacific A-D 19 2019-03-08 2019-03-08 17:00:00 2019-03-08 18:15:00 0 0 0   General 5      
172 4375 Philip Meyer Award Presentation The presentation of the 2018 Philip Meyer Journalism Awards will take place on Friday at the 2019 CAR Conference in Newport Beach. The awards recognize the best uses of social research methods in journalism and are named in honor of Philip Meyer, author of “Precision Journalism” and retired Knight Chair in Journalism and UNC School of Journalism and Mass Communications. Three awards are given annually — a first, second and third place — to recognize the best work using techniques that are part of precision journalism, computer-assisted reporting and social science research. The awards are: $500 for first, $300 for second, and $200 for third. Grand Pacific A-D 19 2019-03-08 2019-03-08 18:15:00 2019-03-08 18:30:00 0 0 0   General 5      

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "sessions" (
"event_id" INTEGER,
  "name" TEXT,
  "clean_description" TEXT,
  "location_room" INTEGER,
  "start_date_clean" TEXT,
  "start_time" TEXT,
  "end_time" TEXT,
  "pre_reg_flag" INTEGER,
  "paid_flag" INTEGER,
  "laptop_flag" INTEGER,
  "speakers_cleaned" TEXT,
  "session_type" INTEGER,
  "keywords" REAL,
  "skill_level" INTEGER,
  "session_title" TEXT
,
FOREIGN KEY ("skill_level") REFERENCES [skill_level](id),
    FOREIGN KEY ("location_room") REFERENCES [location_room](id),
    FOREIGN KEY ("session_type") REFERENCES [session_type](id))
Powered by Datasette · Query took 3.042ms