zillow_com street

No table description or topics provided.

Tables

state
county
code
street
building_address
real_estate
fact
feature
additional_feature
appliances_included
room_type
other
construction

street

You are browsing sample data.

<L0> street
id ts title code_id code
1 2017-03-02 20:35:21 Linden Ave
<L1> code
id ts title county_id county
1 2017-03-02 05:11:30 90895
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
90895
2 2017-03-02 20:35:23 Ila Joyce St
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
3 2017-03-02 20:35:23 Colman Street #
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
4 2017-03-02 20:35:23 Colman St
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
5 2017-03-02 20:35:23 Loma View Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
6 2017-03-02 20:35:23 Craig Ave
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
7 2017-03-02 20:35:23 Navarro Ave
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
8 2017-03-02 20:35:23 Saint James Pl
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
9 2017-03-02 20:35:23 Alvey Pl
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
10 2017-03-02 20:35:23 Echo Glen Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
11 2017-03-02 20:35:23 Neldome St
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
12 2017-03-02 20:35:23 Parnell Way
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
13 2017-03-02 20:35:23 PARNELL WAY
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
14 2017-03-02 20:35:23 3304 N Fair Oaks ave.
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
15 2017-03-02 20:35:23 Via Maderas St
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
16 2017-03-02 20:35:23 Laun St
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
17 2017-03-02 20:35:23 Tola Ave
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
18 2017-03-02 20:35:23 Purple Sage Ln
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
19 2017-03-02 20:35:23 Pentagon St
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
20 2017-03-02 20:35:23 Woodbury Rd
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
21 2017-03-02 20:35:23 Sunset Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
22 2017-03-02 20:35:23 Santa Rosa Ave
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
23 2017-03-02 20:35:23 Morada Pl
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
24 2017-03-02 20:35:23 Terrace St
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
25 2017-03-02 20:35:23 Madre Vista Rd
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
26 2017-03-02 20:35:23 Villa Zanita St
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
27 2017-03-02 20:35:23 Deodara Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
28 2017-03-02 20:35:23 Hollygrove Ln
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
29 2017-03-02 20:35:23 Pinecrest Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
30 2017-03-02 20:35:23 Canyon Ridge Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
31 2017-03-02 20:35:23 La Canada Verdugo Rd
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
32 2017-03-02 20:35:23 Poppyfields Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
33 2017-03-02 20:35:23 Sunmore Ln
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
34 2017-03-02 20:35:23 Ganesha Ave
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
35 2017-03-02 20:35:23 Harding Ave
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
36 2017-03-02 20:35:23 Porter Ave
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
37 2017-03-02 20:35:23 Dolores Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
38 2017-03-02 20:35:23 Alzada Rd
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
39 2017-03-02 20:35:23 Chapman Ct
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
40 2017-03-02 20:35:23 Dolores Rd
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
41 2017-03-02 20:35:23 Hollyslope Rd
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
42 2017-03-02 20:35:23 La Corona Ave
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
43 2017-03-02 20:35:23 Ventura St
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
44 2017-03-02 20:35:23 New York Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
45 2017-03-02 20:35:23 Jaxine Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
46 2017-03-02 20:35:23 Luna Ct
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
47 2017-03-02 20:35:23 Tanoble Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
48 2017-03-02 20:35:23 Midlothian Dr
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
49 2017-03-02 20:35:23 Hollingsworth Rd
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
50 2017-03-02 20:35:23 Alegre Ln
<L1> code
id ts title county_id county
2 2017-03-02 05:11:30 91001
<L2> county
id ts title state_id state
1 2017-03-02 05:04:17 Los Angeles
<L3> state
id ts title
1 2017-03-02 05:03:14 California
California
id ts title state_id state
Los Angeles
id ts title county_id county
91001
id ts title code_id code

Table Stats:

Size 1.82G
Columns 6
Rows (screenshot) 11,055,196
Rows (engine) 10,681,871