A complete extraction of the APP vehicle-session workbook contains 93,124 rows with plate, parking zone, start date, and end date. It spans September 1, 2022 at 00:12 through November 16, 2022 at 07:21 in the extracted values, covering 10,746 distinct plate strings and 49 parking-zone labels. The largest row groups are CUE Garage, Library Garage, Columbia Street Lot Top Bay, Wilson Road meters, and Green 5 South Beasley. Forty rows contain the literal plate string LFZ8649. Those rows require contextual review for duplicates, session rules, plate transcription, account linkage, and time-zone meaning.
A complete extraction of the LPR GPS Coordinates workbook contains 30,368 dated read rows from November 6 through November 15, 2022. The table includes read date, geofence, plate string, latitude, and longitude, with 9,663 distinct plate strings, 107 geofence labels, and 6,947 distinct coordinate pairs. “Other” is the largest geofence category, followed by several numbered WSU lots. No rows contain the literal strings CFB8708 or LFZ8649. Absence of those exact strings is not proof that a vehicle was absent: plate formats, recognition error, coverage, query scope, and missing data remain material limitations.
This record indexes “_PullmanPolice_Twitter_Mentions.pdf,” a PDF stored under “Pullman Social Media Records.” Connected extraction recovered 2,312 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “CityofPullmanPoliceDept_Facebook_Timeline_posts.pdf,” a PDF stored under “Pullman Social Media Records.” Connected extraction recovered 11,204 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “social_media_results_2.pdf,” a PDF stored under “Pullman Social Media Records.” Connected extraction recovered 34,965 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “social_media_results_3.pdf,” a PDF stored under “Pullman Social Media Records.” Connected extraction recovered 27,724 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “social_media_results_4.pdf,” a PDF stored under “Pullman Social Media Records.” Connected extraction recovered 33,604 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “social_media_results.pdf,” a PDF stored under “Pullman Social Media Records.” Connected extraction recovered 83,981 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “How campus cops broke Idaho slayings case open & other top stories.pdf,” a PDF stored under “Pullman Social Media Records/News.” Connected extraction recovered 22,360 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “IACP_s_The_Lead__Alabama_Law_Allowing_Concealed_Firearms_Without_Permit_Took_Effect_Sunday.pdf,” a PDF stored under “Pullman Social Media Records/News.” Connected extraction recovered 9,012 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “IACP_s_The_Lead__Biden_Announces_New_Migration_Quota_Policy__Border_Visit.pdf,” a PDF stored under “Pullman Social Media Records/News.” Connected extraction recovered 8,281 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “IACP_s_The_Lead__Maine_s_Correctional_System_Successfully_Reduces_Overdose_Rates_Among_People_Leaving_Prison.pdf,” a PDF stored under “Pullman Social Media Records/News.” Connected extraction recovered 9,057 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “IACP_s_The_Lead__Minnesota_School_District_To_Consider_Adding_More_Police.pdf,” a PDF stored under “Pullman Social Media Records/News.” Connected extraction recovered 13,191 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “IACP_s_The_Lead__Oregon_Judge_Upholds_Stay_On_Voter-Approved_Firearms_Measures.pdf,” a PDF stored under “Pullman Social Media Records/News.” Connected extraction recovered 9,214 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
This record indexes “Idaho_slayings_case_update__swatting_felony___other_top_stories.pdf,” a PDF stored under “Pullman Social Media Records/News.” Connected extraction recovered 10,133 searchable characters. A sanitized full-text extraction is included for research and must be checked against the original layout.
