Access Assignment 2
vk4queen
Indepentdentproject.accdb| LicenseNumber | BirthDate | LastName | FirstName | Address | City | State | ZIP | Gender |
|---|---|---|---|---|---|---|---|---|
| 10000501 | 3/12/47 | Smith | Timothy | 274 W 145th Street | New York | NY | 10039 | M |
| 10001786 | 11/11/47 | Johnson | Sanda | 321 Deforest Road | Syracuse | NY | 13214 | F |
| 10003086 | 1/12/62 | Williams | Mark | 345 E 73rd Street | New York | NY | 10021 | M |
| 10004372 | 1/21/64 | Brown | Kathy | 448 E. 88th Street #5B | New York | NY | 10128 | F |
| 10004387 | 2/7/68 | Jones | Miranda | 433 E. 80th Street | New York | NY | 10075 | F |
| 10004672 | 9/4/69 | Miller | Steve | 609 Church Street | Syracuse | NY | 13212 | M |
| 12344537 | 10/23/72 | Davis | Austin | 903 Champlin Avenue | Utica | NY | 13502 | M |
| 12345678 | 7/11/73 | Garcia | Emily | 288 Kimball Avenue | Yonkers | NY | 10704 | F |
| 12345823 | 11/10/73 | Rodriguez | Franco | 131 Ridgewood Circle | Buffalo | NY | 14218 | M |
| 12345838 | 4/14/73 | Wilson | Eric | 24 Alwin Place | Buffalo | NY | 14211 | M |
| 12346123 | 11/25/73 | Schooler | Claudia | 748 South Street #2 | Utica | NY | 13501 | F |
| 12346251 | 12/13/73 | Pelayo | Randy | 74 Morris Street | Albany | NY | 12208 | M |
| 12346377 | 2/1/74 | Johns | Greg | 72 Wylie Street | Schenectady | NY | 12307 | M |
| 12346978 | 2/7/74 | Juarez | Jon | 118 Boyden Street | Syracuse | NY | 13202 | M |
| 12348264 | 5/12/74 | Carter | Kevin | 38 Cliff Street | Yonkers | NY | 10701 | M |
| 12348279 | 5/15/74 | Altier | Sharon | 180 Wyoming Avenue | Buffalo | NY | 14215 | F |
| 12348564 | 7/21/74 | Gates | Kristin | 1122 Lexington Avenue | Schenectady | NY | 12309 | F |
| 12348692 | 8/20/74 | Finch | Michael | 28 Besch Avenue | Albany | NY | 12209 | M |
| 12388495 | 7/15/76 | Krentler | Amanda | 1022 WeStreet Street | Utica | NY | 13501 | F |
| 12388510 | 7/19/76 | Rios | Carlos | 1815 Bleecker Street | Utica | NY | 13501 | M |
| 12388795 | 3/7/79 | Doiron | Caroline | 418 Spratt Place | Utica | NY | 13502 | F |
| 12388923 | 3/22/79 | Singh | Mehdi | 118 Manning Boulevard | Albany | NY | 12203 | M |
| 12389049 | 4/17/79 | Hirshman | Bonnie | 299 Clinton Avenue | Albany | NY | 12210 | F |
| 12390334 | 4/15/79 | Kerr | Steve | 603 Ravine Drive | Utica | NY | 13502 | M |
| 12394037 | 9/30/79 | Plice | Haley | 428 Whitehall Road | Albany | NY | 12208 | F |
| 12394163 | 10/30/79 | Harvey | Jake | 705 Renaissance Drive | Buffalo | NY | 14221 | M |
| 12395448 | 11/1/79 | Tyler | Jackie | 98 Manhart Street | Buffalo | NY | 14215 | F |
| 12396748 | 11/6/79 | Bertram | James | 720 Albany Street | Schenectady | NY | 12307 | M |
| 12398034 | 8/23/80 | Peters | Richard | 152 Edna Place | Buffalo | NY | 14209 | M |
| 15500501 | 10/10/80 | Addo | Kathy | 446 Herkimer Street | Buffalo | NY | 14213 | F |
| 15500786 | 10/24/80 | Shin | Brian | 50 Main Street | Yonkers | NY | 10701 | M |
| 15500914 | 3/19/81 | Taylor | Michelle | 111 Morris Street #1 | Yonkers | NY | 10705 | F |
| 15501040 | 8/9/82 | Fishberg | Steve | 526 Altamont Avenue | Schenectady | NY | 12303 | M |
| 15502325 | 8/24/82 | Stokes | Ron | 359 Warburton Avenue | Yonkers | NY | 10701 | M |
| 15503625 | 3/26/85 | Norman | Corey | 503 Joanne Drive | Utica | NY | 13502 | M |
| 18955678 | 5/7/85 | Rizzo | Eric | 39 Moultie Avenue | Yonkers | NY | 10710 | M |
| 18955806 | 8/11/85 | Smith | Nancy | 2906 Grant Boulevard | Syracuse | NY | 13208 | F |
| 18955932 | 9/5/85 | Moyers | Molly | 80 Westgate Road | Buffalo | NY | 14217 | F |
| 18957217 | 10/22/86 | Healy | Jessica | 1025 Warren Street | Utica | NY | 13502 | F |
| 18958517 | 7/4/88 | Valenzuela | Kaitlin | 6298 Stage Road | Utica | NY | 13502 | F |
| 39988495 | 7/6/88 | Shin | Lucy | 238 Marshall Avenue | Schenectady | NY | 12304 | F |
| 39989780 | 5/20/89 | Nguyen | Kevin | 358 Breckenridge Street | Buffalo | NY | 14213 | M |
| 39991080 | 11/28/89 | Kirby | Kayla | 27 Lawrence Street | Yonkers | NY | 10705 | F |
| 39992366 | 9/25/93 | Watson | Mark | 213 Garfield Street | Utica | NY | 13502 | M |
| 39992381 | 10/2/97 | Larson | Annie | 89 Robinson Street | Schenectady | NY | 12304 | F |
| 39992387 | 10/1/97 | Caton | Kiana | 2567 Woodman Street | Utica | NY | 13502 | F |
| TicketNumber | DLNumber | TicketDate | City | PrimaryFactor | OfficerBadgeNumber | Fine |
|---|---|---|---|---|---|---|
| 4235879527 | 12348279 | 1/4/16 | Buffalo | Unsafe Speed | A00032567 | ¤ 360.00 |
| 4235879530 | 12346123 | 1/7/16 | New York | Passing/Lane Violations | A00061444 | ¤ 150.00 |
| 4235879534 | 12389049 | 1/10/16 | Utica | Passing/Lane Violations | A00045729 | ¤ 130.00 |
| 4235879759 | 15500786 | 1/15/16 | Yonkers | Alcohol | A00057706 | ¤ 400.00 |
| 4235879760 | 10004387 | 1/16/16 | Yonkers | Alcohol | A00057706 | ¤ 400.00 |
| 4235879761 | 39989780 | 1/18/16 | New York | Unsafe Speed | A00061444 | ¤ 90.00 |
| 4235889527 | 15503625 | 1/26/16 | Buffalo | Alcohol | A00032567 | ¤ 400.00 |
| 4235893852 | 10000501 | 2/1/16 | New York | Unsafe Speed | A00061444 | ¤ 45.00 |
| 4235893950 | 12389049 | 2/2/16 | Yonkers | Traffic Control Disregarded | A00057706 | ¤ 150.00 |
| 4235893968 | 12348692 | 2/6/16 | Utica | Backing Unsafely | A00045729 | ¤ 60.00 |
| 4235894281 | 15503625 | 2/11/16 | Albany | Alcohol | A00092385 | ¤ 400.00 |
| 4235894283 | 12346978 | 2/12/16 | Albany | Alcohol | A00092385 | ¤ 400.00 |
| 4235894307 | 39989780 | 2/12/16 | Albany | Unsafe Speed | A00092385 | ¤ 45.00 |
| 4235894327 | 12389049 | 2/13/16 | New York | Alcohol | A00061444 | ¤ 400.00 |
| 4235894352 | 10000501 | 2/14/16 | Albany | Passing/Lane Violations | A00092385 | ¤ 120.00 |
| 4235894379 | 15500786 | 2/15/16 | Yonkers | Traffic Control Disregarded | A00057706 | ¤ 150.00 |
| 4235894386 | 12348692 | 2/16/16 | Utica | Unsafe Speed | A00045729 | ¤ 45.00 |
| 4235894388 | 12348279 | 2/16/16 | Utica | Unsafe Speed | A00045729 | ¤ 90.00 |
| 4235894390 | 18957217 | 2/16/16 | Utica | Unsafe Speed | A00056591 | ¤ 45.00 |
| 4235894394 | 39992366 | 2/16/16 | Utica | Unsafe Speed | A00056591 | ¤ 180.00 |
| 4235894399 | 10003086 | 2/19/16 | Albany | Passing/Lane Violations | A00092385 | ¤ 120.00 |
| 4235894427 | 12388795 | 3/20/16 | Albany | Turning Improperly | A00061403 | ¤ 90.00 |
| 4235894473 | 15500914 | 3/11/16 | Utica | Driver Distraction | A00045729 | ¤ 90.00 |
| 4235894496 | 12345838 | 3/25/16 | Syracuse | Driver Distraction | A00021411 | ¤ 120.00 |
| 4235894590 | 12345678 | 3/29/16 | Utica | Turning Improperly | A00056591 | ¤ 60.00 |
| 4235894823 | 15500786 | 4/6/16 | Utica | Failure to Keep Right | A00045729 | ¤ 90.00 |
| 4235894914 | 18957217 | 4/8/16 | Utica | Unsafe Speed | A00056591 | ¤ 60.00 |
| 4235895001 | 12348279 | 4/10/16 | Buffalo | Unsafe Speed | A00032567 | ¤ 45.00 |
| 4235895049 | 12344537 | 4/13/16 | Yonkers | Alcohol | A00057706 | ¤ 400.00 |
| 4235895082 | 12394163 | 4/14/16 | Utica | Unsafe Speed | A00045729 | ¤ 90.00 |
| 4235895110 | 39992387 | 4/15/16 | Utica | Unsafe Speed | A00045729 | ¤ 45.00 |
| 4235895121 | 12348692 | 4/15/16 | Yonkers | Alcohol | A00057706 | ¤ 400.00 |
| 4235895197 | 10001786 | 4/20/16 | Utica | Unsafe Speed | A00056591 | ¤ 60.00 |
| 4235895280 | 39989780 | 4/24/16 | Syracuse | Alcohol | A00021411 | ¤ 400.00 |
| 4235895648 | 10000501 | 5/11/16 | Buffalo | Unsafe Speed | A00032567 | ¤ 180.00 |
| 4235895673 | 10004372 | 5/13/16 | Albany | Unsafe Speed | A00092385 | ¤ 90.00 |
| 4235896886 | 15500786 | 5/14/16 | Syracuse | Alcohol | A00021411 | ¤ 400.00 |
| 4235896888 | 12344537 | 5/14/16 | Syracuse | Turning Improperly | A00021411 | ¤ 120.00 |
| 4235896903 | 15502325 | 5/15/16 | Syracuse | Traffic Control Disregarded | A00021411 | ¤ 130.00 |
| 4235896915 | 18955806 | 5/15/16 | Syracuse | Unsafe Speed | A00021411 | ¤ 90.00 |
