veyepar: Python, Government, and Contracts: providing a tool to investigate corruption

Hi user

Admin Login:

Name: Python, Government, and Contracts: providing a tool to investigate corruption
--client nbpy --show nbpy19 --room mystic 15061 --force
Prev: 12 A-hunting We Will Go: Debugging pytest with Django
Next: 12 Conference Close

show more...

Author(s):	Froilán Irizarry Rivera
Location	Mystic Theatre
Date	nov Sun 03	Days Raw Files
Start	17:00	First Raw Start	16:33
Duration	0:30:0	Offset	0:26:46
End	17:30	Last Raw End	17:54
Chapters	00:00 0:26:26
Total cuts_time	36 min.

https://2019.northbaypython.org/schedule/presentation/13/
raw-playlist raw-mp4-playlist encoded-files-playlist host archive tweet mp4 svg png

final audio

assets release.pdf Python_Government_and_Contracts_providing_a_tool_to_investigate_corruption.json
logs
Admin: episode episode list cut list raw files day marks day marks day image_files

State:
Locked:	clear this to unlock
Locked by:	user/process that locked.
Start:	initially scheduled time from master, adjusted to match reality
Duration:	length in hh:mm:ss
Name:	Video Title (shows in video search results)
Emails:	email(s) of the presenter(s)
Released:	has someone authorised pubication
Normalise:
Channelcopy:	m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:	filename.png
Description:	In the two years after Hurricane Maria struck Puerto Rico there has been a sharp increase in investigative journalism on the island. Most of these investigations have been around questionable contracts awarded by different government entities and officials in Puerto Rico. No-bid contracts like the ones award to White Fish and later to Cobra Acquisitions have generated national outrage. Lack of transparency, costly mismanagement, and abuse of power can be found throughout. The Office of the Comptroller of Puerto Rico has built a tool that lets you search and download contract documents (after they’ve been redacted of sensitive information). While it serves its purpose of making this information available, the tool does not permit any mass data analysis or download. In less than a week we were able to release a very early version of our tool to improve this. Our goal was to present a "better" way to search and use this data, create a sustainable project that could be easily used, while also keeping effort and cost to a minimum. For all these reasons we landed on using Python and Django. Django and the ecosystem around it presents an amazing opportunity to minimize effort and cost for a civic tech project while providing a robust way to manage the processes and data of a project like ContratosPR. Django's admin give use a central place to glance which contract documents need to be requested, OCR'ed, and provides the tools to execute the request process. All of this in combination with great docs and an amazing community made them a clear choice. In the years after Hurricane Maria there has been a sharp increase in investigative journalism in Puerto Rico. Most of these investigations have been around questionable contracts awarded by different government entities and officials. We've used Python and Django to create a tool that consumes an unwieldy government site to make this data more accessible to journalist and citizens. markdown
Comment:	production notes

2019-11-03/16_33_14.ts Apply: 16:33:14 - 16:34:13 ( 00:00:59 ) S: 16:33:14 - E: 17:03:13 D: 00:29:59 (End: 59.0) show more...

vlc ~/Videos/veyepar/nbpy/nbpy19/dv/mystic/2019-11-03/16_33_14.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	16:33:14		seconds: 0.0 Wall: 16:33:14
Duration	00:29:59
	17:03:13		seconds: 59.0 Wall: 16:34:13
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2019-11-03/16_33_14.ts Apply: 16:34:13 - 17:03:13 ( 00:29:00 ) S: 16:33:14 - E: 17:03:13 D: 00:29:59 (Start: 59.0) show more...

vlc ~/Videos/veyepar/nbpy/nbpy19/dv/mystic/2019-11-03/16_33_14.ts :start-time=059.0 --audio-desync=0

	Raw File	Cut List
	16:33:14		seconds: 59.0 Wall: 16:34:13
Duration	00:29:59
	17:03:13		seconds: 0.0 Wall: 16:33:14
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2019-11-03/17_03_14.ts Apply: 17:03:14 - 17:05:52 ( 00:02:38 ) S: 17:03:14 - E: 17:33:13 D: 00:29:59 (End: 158.0) show more...

vlc ~/Videos/veyepar/nbpy/nbpy19/dv/mystic/2019-11-03/17_03_14.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	17:03:14		seconds: 0.0 Wall: 17:03:14
Duration	00:29:59
	17:33:13		seconds: 158.0 Wall: 17:05:52
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2019-11-03/17_03_14.ts Apply: 17:05:52 - 17:06:34 ( 00:00:42 ) S: 17:03:14 - E: 17:33:13 D: 00:29:59 (Start: 158.0) (End: 200.0) show more...

vlc ~/Videos/veyepar/nbpy/nbpy19/dv/mystic/2019-11-03/17_03_14.ts :start-time=0158.0 --audio-desync=0

	Raw File	Cut List
	17:03:14		seconds: 158.0 Wall: 17:05:52
Duration	00:29:59
	17:33:13		seconds: 200.0 Wall: 17:06:34
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2019-11-03/17_03_14.ts Apply: 17:06:34 - 17:06:36 ( 00:00:02 ) S: 17:03:14 - E: 17:33:13 D: 00:29:59 (Start: 200.0) (End: 202.0) show more...

vlc ~/Videos/veyepar/nbpy/nbpy19/dv/mystic/2019-11-03/17_03_14.ts :start-time=0200.0 --audio-desync=0

	Raw File	Cut List
	17:03:14		seconds: 200.0 Wall: 17:06:34
Duration	00:29:59
	17:33:13		seconds: 202.0 Wall: 17:06:36
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2019-11-03/17_03_14.ts Apply: 17:06:36 - 17:06:47 ( 00:00:11 ) S: 17:03:14 - E: 17:33:13 D: 00:29:59 (Start: 202.0) (End: 213.0) show more...

vlc ~/Videos/veyepar/nbpy/nbpy19/dv/mystic/2019-11-03/17_03_14.ts :start-time=0202.0 --audio-desync=0

	Raw File	Cut List
	17:03:14		seconds: 202.0 Wall: 17:06:36
Duration	00:29:59
	17:33:13		seconds: 213.0 Wall: 17:06:47
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2019-11-03/17_03_14.ts Apply: 17:06:47 - 17:33:13 ( 00:26:26 ) S: 17:03:14 - E: 17:33:13 D: 00:29:59 (Start: 213.0) show more...

vlc ~/Videos/veyepar/nbpy/nbpy19/dv/mystic/2019-11-03/17_03_14.ts :start-time=0213.0 --audio-desync=0

	Raw File	Cut List
	17:03:14		seconds: 213.0 Wall: 17:06:47
Duration	00:29:59
	17:33:13		seconds: 0.0 Wall: 17:03:14
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2019-11-03/17_33_14.ts Apply: 17:33:14 - 17:42:49 ( 00:09:35 ) S: 17:33:14 - E: 17:54:39 D: 00:21:25 (End: 9:35) show more...

vlc ~/Videos/veyepar/nbpy/nbpy19/dv/mystic/2019-11-03/17_33_14.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	17:33:14		seconds: 0.0 Wall: 17:33:14
Duration	00:21:25
	17:54:39		seconds: 575.0 Wall: 17:42:49
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

Rf filename:	root is .../show/dv/location/, example: 2013-03-13/13:13:30.dv
Sequence:
get this:	check and save to add this

2019-11-03/16_33_14.ts
audio viz

audio viz

2019-11-03/17_03_14.ts
audio viz

audio viz

2019-11-03/17_33_14.ts
audio viz

audio viz

Veyepar Video Eyeball Processor and Review