offemses

	A	B	C	D	E	F
1	inci_id	offense	date_rept	street	geox	geoy
2	20070731	GAS DRIVE-OFF	3/29/07 0:00	RICHMOND AVE	1132661800	673220950
3	20070730	GAS DRIVE-OFF	3/29/07 0:00	RICHMOND AVE	1132661800	673220950
4	20070733	POSSESSION WITH INTENT TO DISTRIBUTE METHAMPHETAMINES	3/29/07 0:00	PIERCE ST/HAYS AVE	1131287500	673796050
5	20070732	NUISANCE ANIMAL	3/29/07 0:00	STRAITH ST	1131268400	673897000
6	20070734	LARCENY- FROM MOTOR VEHICLE	3/29/07 0:00	PLUNKETT ST	1131230300	673952550
7	20070737	LARCENY- PURSE SNATCHING	3/29/07 0:00	ACADEMY ST	1131885400	673915900
8	20070736	DANGEROUS DOG	3/29/07 0:00	W JOHNSON ST	1131614500	673743100
9	20070738	LARCENY- SHOPLIFTING	3/29/07 0:00	RICHMOND AVE	1132531900	673271000
10	20070739	POSSESSION OF MARIJUANA	3/29/07 0:00	N COALTER ST	1132303600	674364250
11	20070740	LARCENY- ALL OTHERS	3/29/07 0:00	HILLTOP DR	1131627100	673429950
12	20070741	CRUELTY TO ANIMALS	3/29/07 0:00	BALTIMORE AVE	1131864700	673617150
13	20070742	ASSAULT- SIMPLE	3/29/07 0:00	S ST CLAIR ST	1131702200	673780500
14	20070743	LARCENY FROM RESIDENCE	3/29/07 0:00	DAVID ST/GEOFFREY ST	1131776600	673267650
15	20070744	CONCEALED WEAPON(S)	3/30/07 0:00	HAYS AVE/W BEVERLEY ST	1131349100	673918850

03-30-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		3/29/07	0010	AUGUSTA COUNTY	STAUNTON	GRAND LARCENY, F	92194	W	F	36
3	20070733	3/29/07	1059	HAYS AVE/PIERCE ST	STAUNTON	POSSESSION OF MARIJUANA, M	92202	W	F	29
4		3/29/07	1645	BALTIMORE AVE	STAUNTON	FAIL TO APPEAR, M	92206	B	M	34
5	20070741	3/29/07	1655	BALTIMORE AVE	STAUNTON	CRUELTY TO ANIMALS, M	92206	B	M	34
6		3/29/07	2315	N AUGUSTA ST	STAUNTON	DRUNK IN PUBLIC/ CURSE AND ABUSE, M	92215	W	M	48
7		3/29/07	1956	W BEVERLEY ST	STAUNTON	CONTEMPT OF COURT- CAPIAS, M	582	W	F	22
8		3/30/07	0415	HAYS AVE/W BEVERLEY ST	STAUNTON	CARRYING CONCEALED WEAPON, M	37184	W	M	18