zillow_com street
Street names associated with ZIP or postal codes.
You are browsing sample data.
| street.id | street.ts | street.title | street.code | code.id | code.ts | code.title | code.county | county.id | county.ts | county.title | county.state | state.id | state.ts | state.title |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2017-03-02 20:35:21 | Linden Ave | 90895 | 1 | 2017-03-02 05:11:30 | 90895 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 2 | 2017-03-02 20:35:23 | Ila Joyce St | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 3 | 2017-03-02 20:35:23 | Colman Street # | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 4 | 2017-03-02 20:35:23 | Colman St | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 5 | 2017-03-02 20:35:23 | Loma View Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 6 | 2017-03-02 20:35:23 | Craig Ave | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 7 | 2017-03-02 20:35:23 | Navarro Ave | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 8 | 2017-03-02 20:35:23 | Saint James Pl | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 9 | 2017-03-02 20:35:23 | Alvey Pl | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 10 | 2017-03-02 20:35:23 | Echo Glen Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 11 | 2017-03-02 20:35:23 | Neldome St | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 12 | 2017-03-02 20:35:23 | Parnell Way | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 13 | 2017-03-02 20:35:23 | PARNELL WAY | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 14 | 2017-03-02 20:35:23 | 3304 N Fair Oaks ave. | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 15 | 2017-03-02 20:35:23 | Via Maderas St | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 16 | 2017-03-02 20:35:23 | Laun St | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 17 | 2017-03-02 20:35:23 | Tola Ave | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 18 | 2017-03-02 20:35:23 | Purple Sage Ln | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 19 | 2017-03-02 20:35:23 | Pentagon St | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 20 | 2017-03-02 20:35:23 | Woodbury Rd | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 21 | 2017-03-02 20:35:23 | Sunset Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 22 | 2017-03-02 20:35:23 | Santa Rosa Ave | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 23 | 2017-03-02 20:35:23 | Morada Pl | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 24 | 2017-03-02 20:35:23 | Terrace St | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 25 | 2017-03-02 20:35:23 | Madre Vista Rd | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 26 | 2017-03-02 20:35:23 | Villa Zanita St | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 27 | 2017-03-02 20:35:23 | Deodara Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 28 | 2017-03-02 20:35:23 | Hollygrove Ln | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 29 | 2017-03-02 20:35:23 | Pinecrest Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 30 | 2017-03-02 20:35:23 | Canyon Ridge Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 31 | 2017-03-02 20:35:23 | La Canada Verdugo Rd | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 32 | 2017-03-02 20:35:23 | Poppyfields Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 33 | 2017-03-02 20:35:23 | Sunmore Ln | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 34 | 2017-03-02 20:35:23 | Ganesha Ave | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 35 | 2017-03-02 20:35:23 | Harding Ave | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 36 | 2017-03-02 20:35:23 | Porter Ave | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 37 | 2017-03-02 20:35:23 | Dolores Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 38 | 2017-03-02 20:35:23 | Alzada Rd | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 39 | 2017-03-02 20:35:23 | Chapman Ct | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 40 | 2017-03-02 20:35:23 | Dolores Rd | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 41 | 2017-03-02 20:35:23 | Hollyslope Rd | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 42 | 2017-03-02 20:35:23 | La Corona Ave | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 43 | 2017-03-02 20:35:23 | Ventura St | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 44 | 2017-03-02 20:35:23 | New York Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 45 | 2017-03-02 20:35:23 | Jaxine Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 46 | 2017-03-02 20:35:23 | Luna Ct | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 47 | 2017-03-02 20:35:23 | Tanoble Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 48 | 2017-03-02 20:35:23 | Midlothian Dr | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 49 | 2017-03-02 20:35:23 | Hollingsworth Rd | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| 50 | 2017-03-02 20:35:23 | Alegre Ln | 91001 | 2 | 2017-03-02 05:11:30 | 91001 | Los Angeles | 1 | 2017-03-02 05:04:17 | Los Angeles | California | 1 | 2017-03-02 05:03:14 | California |
| street.id | street.ts | street.title | street.code | code.id | code.ts | code.title | code.county | county.id | county.ts | county.title | county.state | state.id | state.ts | state.title |
Table Overview:
The street table contains street-level geographic reference data. Its title column stores the street name, such as Linden Ave, and _yf_slug stores the associated URL or source slug. code_id and code identify the related ZIP or postal code, while id and ts provide record and source-timestamp information.
Table Stats:
Size 1.82G
Columns 6
Rows (screenshot) 11,055,196
Rows (engine) 10,722,351