FOIA columns public

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1
2	Tony Webster	ID # (YY-001..., matches a folder where I store data)	agency	department	project (internal)	subject	date filed	date acknowledged	current status (unack'd, ack'd, waiting, denied, challenged waiting, appealed, litigation, closed)	last response date	last response notes	next action	produced (nothing, emailed, downloaded, postal mail)	violations (list of what laws the agency has violated)	appeal status	follow-up flag (sometimes i get so frustrated with a response that I don't want to deal with it until tomorrow and I just mark an X reminding me to get back to it later)	notes (one entry per line: YYYY-MM-DD what happened... this field is a mess, but useful)	email list (as a request progresses, the number of government staffers CC'd increases - I keep the list here for easy follow-up)
3	Sandhya Kambhampati	agency_filer	file_date	request_subject	how_request_made(email, fax,mail)	where_sent(address or email or fax # sent to)	request_notes	request_location(file location on computer or drive)	received_acknowledgement_letter	ack_date	request_number	date_response_due	notes_on_response	notes_on_foia_officer(best # to reach	notes on the person)	received_resp	resp_date	url_resp	resp_notes	resp_ok (do I need to appeal)	appealed	appeal_date	appeal_notes
4	Max Galka	Date	agency	message	from	to	status	(Each request gets it's own table)
5	Matt Drange	Name of Agency	Date Filed	Contact	What is request for?	Reference #	Anticipated sending of records?	What Needs to Be Done Next?		Received Records?	Other notes
6	Christopher Groskopf	syn	ack	scope	country	agency	tracking_number	submitted_via	foia_contact	fee_waiver	expedited	delayed	status	last_action	twenty_days	description	notes
7	Lisa Pickoff-White	contacted when	contacted by	PRA in regards to	Received?	county	agency	attention	named_contact	phone	email address	notes	(keeps track of due dates separately, on a calendar that sends reminders)
8	Dan Nguyen	title	description	precedent	status	respondent_entity	respondent_person	request_page_url	date_sent	date_response_expected	date_acknowledged
9	Jeremy B. Merrill	reporter	agency	filed_date	request_subject	request_notes	is_state_foia	received_ack_letter	ack_date	request_number	submission_notes	date_response_due_custom	received_response	resp_date	response_satisfactory	response_notes	response_url	appealed	appeal_date	lawsuit_filed	lawsuit_filed_date	lawsuit_notes
10	Brad Heath	foia_id	owner	title	agency	date_filed	date_entered	date_changed	date_acknowledged	date_received	date_closed	status_id	records_sought	notes	contact_name	contact_number	fee_initial	fee_charged	fee_paid	fee_method
11	muckrock	user	title	slug	status	jurisdiction	agency	date_submitted	date_updated	date_done	date_due	days_until_due	date_followup	date_estimate	date_processing	embargo	permanent_embargo	date_embargo	price	requested_docs	description	featured	tracker	sidebar_html	tracking_id	mail_id	updated	email	other_emails
12	Cecilia Reyes	officer_name	date_filed	five_days_date	org	has_extension	extension_date	email	phone	records_description	is_FOIA	is_granted
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100