offenses

	A	B	C	D	E	F
1	inci_id	offense	date_rept	street	geox	geoy
2	20070923	LARCENY- SHOPLIFTING	4/19/07 0:00	STATLER BLVD	1131993100	673442800
3	20070925	POSSESSION OF MARIJUANA	4/19/07 0:00	S JEFFERSON ST/W JOHNSON ST	1131650700	673747900
4	20070929	CHILD ENDANGERMENT- NONVIOLENT	4/19/07 0:00	WEST END
5	20070928	GAS DRIVE-OFF	4/19/07 0:00	RICHMOND AVE	1132661800	673220950
6	20070927	DOMESTIC ASSAULT	4/19/07 0:00	ROWE ST	1130980200	673955550
7	20070931	BURGLARY- COMMERCIAL	4/19/07 0:00	GREENVILLE AVE	1131874000	673588500
8	20070932	BOMB THREATS	4/19/07 0:00	W FREDERICK ST	1131709100	673863900
9	20070933	DESTRUCTION OF PROPERTY- PRIVATE PROPERTY - GRAFFITI	4/19/07 0:00	MIDDLEBROOK AVE	1131789000	673713550
10	20070934	DESTRUCTION OF PROPERTY- CITY PROPERTY	4/19/07 0:00	GUILFORD AVE	1131630300	674010400
11	20070936	LARCENY FROM RESIDENCE	4/19/07 0:00	ESSEX DR	1130916700	674338200
12	20070937	ROBBERY	4/19/07 0:00	W BEVERLEY ST	1131078300	674037850

04-20-07_arrests

	A	B	C	D	E	F	G	H	I	J
1	case_id	date	time	arrest location	city	charge	name_id	race	sex	age
2		4/19/07	0001	TANNEHILL ST	STAUNTON	FORGERY, F	5107	B	M	47
3		4/19/07	0001	ROWE ST	STAUNTON	ASSAULT & BATTERY -FAMILY MEMBER, M	81980	W	F	18
4		4/19/07	0100	EAST AVE	STAUNTON	UNDERAGE POSSESSION OF ALCOHOL/ INTERDICTED, M	83829	W	M	18
5		4/19/07	0100	EAST AVE	STAUNTON	UNDERAGE POSSESSION OF ALCOHOL/ INTERDICTED, M	85704	W	M	18
6		4/19/07	0100	EAST AVE	STAUNTON	UNDERAGE POSSESSION OF ALCOHOL/ INTERDICTED, M	87518	W	F	18
7		4/19/07	0130	W BEVERLEY ST	STAUNTON	DRUNK IN PUBLIC/ CURSE AND ABUSE, M	90468	W	M	36
8		4/19/07	0130	W JOHNSON ST/S JEFFERSON ST	STAUNTON	POSSESSION OF MARIJUANA, M	9316	B	M	38
9	20070632	4/19/07	0225	EAST AVE	STAUNTON	LARCENY-3RD OR SUBSQ OFFENSE, F	53305	W	M	25